I'm analysing employment by U.S. CBSA in the period 2001-2014, based on U.S. Census CBP data. I'd like to obtain aggregate employment in the U.S. (50 states+DC) based on CBPs. Since CBSA data is partial, I can't get country-level aggregates by just summing CBSA data. (I could get it by aggregating county-level data but that's a lot of work.) Is there a source for U.S.-level CBP-based employment year by year? (It may be somewhere on the U.S. Census website, but I can't find it.)
EDIT 1: Based on this answer, I found this U.S. Census website page, where the link "Economy-Wide Key Statistics (Number of Establishments, Annual Payroll, Number of Employees, ...)" leads to an empty American Fact Finder table.
EDIT 2: Another link "County Business Patterns (Number of Establishments, Annual Payroll, Number of Employees, ...)" on the same page leads to an American Fact Finder table with total employment for a single year at a time from 2005 to 2014. So you need to manually click and copy-paste 15 times. But I'm still missing the same for years 2001-2004.