Total Registered Nonprofits: 2005, 2010, 2015, Latest Year (10/2020)
SELECT '2005' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm0507 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND state in ('DC','MD','VA') UNION SELECT '2010' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm1007 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND state in ('DC','MD','VA') UNION SELECT '2015' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm1507 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND state in ('DC','MD','VA') UNION SELECT '2020 (October)' AS YEAR, COUNT(EIN) AS 'All Registered Nonprofits' FROM bmf.bm2010 WHERE (OUTNCCS IS NULL OR OUTNCCS <> 'OUT') AND state in ('DC','MD','VA')