Census Business Dynamics Statistics
Business openings & closings
Firm and establishment births and deaths, and jobs created and lost, by county and by sector (2010–2023).
Published by Census Business Dynamics Statistics
Finest detail county
Tables 2
How we use this · on 2 desks
“Are more businesses opening or closing here?”
Where you'll see it
- Health Markets: Jobs and workers
- Business & Site Planning: Business dynamics, SBA loans and lenders, Understand the place, Who owns the businesses, and 1 more
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Matched to the same county codes as every other source, so it lines up cleanly with all of them
- Every year we've loaded is kept, so you can see the trend
By county
Sample of 25 rows out of about 44,461
· 16 columns
| id | year | state_fips | county_fips | firms | estabs | emp | estabs_entry | estabs_entry_rate | estabs_exit | estabs_exit_rate | job_creation | job_destruction | net_job_creation | net_job_creation_rate | firmdeath_firms |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2010 | 01 | 001 | 695 | 744 | 7564 | 71 | 9.524 | 74 | 9.926 | 931 | 1360 | -429 | -5.521 | 48 |
| 2 | 2010 | 01 | 003 | 3732 | 4357 | 52245 | 422 | 9.506 | 587 | 13.222 | 7120 | 8237 | -1117 | -2.114 | 395 |
| 3 | 2010 | 01 | 005 | 439 | 473 | 7513 | 34 | 7.098 | 46 | 9.603 | 612 | 956 | -344 | -4.475 | 35 |
| 4 | 2010 | 01 | 007 | 263 | 279 | 2818 | 25 | 8.787 | 36 | 12.654 | 305 | 322 | -17 | -0.602 | 30 |
| 5 | 2010 | 01 | 009 | 629 | 664 | 6605 | 52 | 7.647 | 84 | 12.353 | 763 | 1328 | -565 | -8.193 | 61 |
| 6 | 2010 | 01 | 011 | 117 | 121 | 2078 | 8 | 6.723 | 4 | 3.361 | 273 | 104 | 169 | 8.467 | 4 |
| 7 | 2010 | 01 | 013 | 375 | 395 | 5186 | 22 | 5.439 | 41 | 10.136 | 647 | 747 | -100 | -1.914 | 30 |
| 8 | 2010 | 01 | 015 | 1934 | 2299 | 37182 | 156 | 6.756 | 176 | 7.622 | 3426 | 4512 | -1086 | -2.878 | 117 |
| 9 | 2010 | 01 | 017 | 520 | 550 | 6190 | 48 | 8.759 | 44 | 8.029 | 816 | 824 | -8 | -0.129 | 34 |
| 10 | 2010 | 01 | 019 | 314 | 344 | 3330 | 32 | 9.37 | 27 | 7.906 | 343 | 513 | -170 | -4.978 | 22 |
| 11 | 2010 | 01 | 021 | 645 | 690 | 6678 | 52 | 7.418 | 74 | 10.556 | 641 | 1140 | -499 | -7.205 | 59 |
| 12 | 2010 | 01 | 023 | 237 | 252 | 2813 | 23 | 9.073 | 26 | 10.256 | 221 | 419 | -198 | -6.812 | 20 |
| 13 | 2010 | 01 | 025 | 545 | 608 | 6816 | 42 | 6.874 | 48 | 7.856 | 1062 | 1163 | -101 | -1.465 | 35 |
| 14 | 2010 | 01 | 027 | 172 | 180 | 3063 | 13 | 6.971 | 26 | 13.941 | 261 | 401 | -140 | -4.471 | 20 |
| 15 | 2010 | 01 | 029 | 156 | 161 | 1932 | 12 | 7.339 | 17 | 10.398 | 203 | 303 | -100 | -5.054 | 12 |
| 16 | 2010 | 01 | 031 | 892 | 951 | 12629 | 89 | 9.418 | 77 | 8.148 | 1306 | 1093 | 213 | 1.7 | 61 |
| 17 | 2010 | 01 | 033 | 1081 | 1212 | 18257 | 82 | 6.73 | 95 | 7.796 | 1718 | 2750 | -1032 | -5.506 | 69 |
| 18 | 2010 | 01 | 035 | 179 | 189 | 2518 | 15 | 7.853 | 19 | 9.948 | 437 | 435 | 2 | 0.079 | 16 |
| 19 | 2010 | 01 | 037 | 87 | 93 | 1010 | 9 | 9.375 | 15 | 15.625 | 117 | 95 | 22 | 2.203 | 10 |
| 20 | 2010 | 01 | 039 | 750 | 807 | 10403 | 74 | 9.193 | 70 | 8.696 | 1074 | 1339 | -265 | -2.514 | 49 |
| 21 | 2010 | 01 | 041 | 197 | 208 | 2908 | 15 | 7.042 | 25 | 11.737 | 245 | 311 | -66 | -2.242 | 20 |
| 22 | 2010 | 01 | 043 | 1466 | 1613 | 21437 | 116 | 7.136 | 141 | 8.674 | 2014 | 3288 | -1274 | -5.759 | 91 |
| 23 | 2010 | 01 | 045 | 698 | 791 | 13637 | 85 | 10.665 | 97 | 12.171 | 1827 | 1593 | 234 | 1.729 | 66 |
| 24 | 2010 | 01 | 047 | 670 | 739 | 11440 | 38 | 5.077 | 57 | 7.615 | 1178 | 1142 | 36 | 0.315 | 40 |
| 25 | 2010 | 01 | 049 | 923 | 1040 | 17041 | 70 | 6.641 | 98 | 9.298 | 1781 | 1962 | -181 | -1.056 | 69 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing