Community Platform

You are limited to viewing 10 records at a time. Contact your Community Administrator about obtaining full access or a full listing.

Organization Listing


SELECT * FRoM ( (sELECT a.ein as ID, concat_ws('', '',a.name, '
',trim(a.address),'
',a.city,', ', a.state, ' ', a.zip5) as Name, CASE WHEN length(supp.website)>0 then supp.website WHEN length(n1.p0website) > 0 then n1.p0website WHEN length(n2.j_web) > 0 then n2.j_web WHEN length(n3.p0website) > 0 then n3.p0website else '' end as Website, CASE WHEN length(supp.phone) > 0 then supp.phone WHEN length(n1.p0phone) > 0 then n1.p0phone WHEN length(n2.e_phone) > 0 then n2.e_phone WHEN length(n3.p0phone) > 0 then n3.p0phone else '' end as Phone from nccs.nteedocAllEins a LEFT JOIN platform.SC_old990_table1 n1 ON a.ein = n1.ein and n1.latestOne = 1 LEFT JOIN platform.SC_new990_table1 n2 ON a.ein = n2.ein and n2.latestOne = 1 LEFT JOIN platform.SC_990ez_table1 n3 ON a.ein = n3.ein and n3.latestOne = 1 LEFT JOIN platform.organizationSupplemental supp on a.ein = supp.ein where a.latestBMF = 1 and length(a.ein) = 9 and a.fips = '12009' group by a.name) UNION (SELECT a.ID, concat_ws('', '',a.name, '
',trim(a.address),'
',a.city,', ', a.state, ' ', a.zip5) as Name, if( length(supp.website)> 0, supp.website, a.website) as Website, if( length(supp.phone)> 3, supp.phone, a.phone) as Phone from nccs.nteedocNoEin a LEFT JOIN platform.organizationSupplemental supp on a.ID = supp.orgID where a.isActive = 1 and a.isDeleted = 0 and length(a.id) > 0 and a.fips = '12009' group by a.name) ) a ORDER BY name LIMIT 10
0 Records Found


«Top Of Page»