Organization births (ruling dates) by year and organization type
Shows public charities and private foundation ruling dates. (Note that the current year may be incomplete.)select CASE WHEN level1 = 'PC' THEN 'Public charities' WHEN level1 = 'PF' THEN 'Private foundations' else level1 END as Type, case when substr(ruledate,1,4) > '1980' then substr(ruledate,1,4) else 'Older' end as Ruling_Year, count(*) as Number_of_orgs from bmf.bm1602c3 where state in ('DC','MD','VA') AND RULEDATE > '2005' group by level1, Ruling_Year;