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 and sector
Sample of 25 rows out of about 547,040
· 17 columns
| id | year | state_fips | county_fips | sector | 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 | 2015 | 01 | 001 | 11 | 6 | 6 | 71 | No data | No data | 0 | 0.0 | 17 | 4 | 13 | 20.155 | 0 |
| 2 | 2015 | 01 | 001 | 21 | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | 0 |
| 3 | 2015 | 01 | 001 | 22 | 4 | 10 | 210 | 0 | 0.0 | 0 | 0.0 | 28 | 14 | 14 | 6.931 | 0 |
| 4 | 2015 | 01 | 001 | 23 | 63 | 63 | 371 | 9 | 14.634 | 6 | 9.756 | 73 | 70 | 3 | 0.805 | 3 |
| 5 | 2015 | 01 | 001 | 31 | 24 | 24 | 1000 | 3 | 13.333 | 0 | 0.0 | 50 | 79 | -29 | -2.867 | 0 |
| 6 | 2015 | 01 | 001 | 42 | 28 | 29 | 368 | 4 | 14.545 | No data | No data | 18 | 30 | -12 | -3.213 | No data |
| 7 | 2015 | 01 | 001 | 44 | 114 | 121 | 1062 | 11 | 9.167 | 9 | 7.5 | 211 | 166 | 45 | 4.329 | 7 |
| 8 | 2015 | 01 | 001 | 48 | 14 | 14 | 120 | No data | No data | No data | No data | 18 | 22 | -4 | -3.306 | No data |
| 9 | 2015 | 01 | 001 | 51 | 3 | 5 | 30 | 0 | 0.0 | No data | No data | 3 | 3 | 0 | 0.0 | No data |
| 10 | 2015 | 01 | 001 | 52 | 49 | 59 | 289 | 3 | 5.0 | 5 | 8.333 | 25 | 37 | -12 | -4.061 | No data |
| 11 | 2015 | 01 | 001 | 53 | 35 | 36 | 114 | 5 | 14.706 | No data | No data | 33 | 13 | 20 | 19.231 | No data |
| 12 | 2015 | 01 | 001 | 54 | 39 | 43 | 238 | 6 | 13.333 | 10 | 22.222 | 33 | 64 | -31 | -12.205 | 6 |
| 13 | 2015 | 01 | 001 | 55 | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | No data | 0 |
| 14 | 2015 | 01 | 001 | 56 | 23 | 23 | 111 | 4 | 18.182 | No data | No data | 21 | 21 | 0 | 0.0 | No data |
| 15 | 2015 | 01 | 001 | 61 | 5 | 5 | 138 | 0 | 0.0 | 0 | 0.0 | 6 | 5 | 1 | 0.727 | 0 |
| 16 | 2015 | 01 | 001 | 62 | 85 | 89 | 1684 | 5 | 5.65 | 4 | 4.52 | 122 | 124 | -2 | -0.119 | 3 |
| 17 | 2015 | 01 | 001 | 71 | 6 | 8 | 103 | 0 | 0.0 | No data | No data | 2 | 30 | -28 | -23.83 | No data |
| 18 | 2015 | 01 | 001 | 72 | 45 | 46 | 880 | 4 | 8.421 | 7 | 14.737 | 131 | 70 | 61 | 7.176 | 5 |
| 19 | 2015 | 01 | 001 | 81 | 111 | 111 | 854 | 9 | 8.295 | 4 | 3.687 | 56 | 64 | -8 | -0.933 | No data |
| 20 | 2015 | 01 | 003 | 11 | 4 | 4 | 10 | 0 | 0.0 | 4 | 66.667 | 1 | 12 | -11 | -70.968 | No data |
| 21 | 2015 | 01 | 003 | 21 | 8 | 8 | 102 | No data | No data | 0 | 0.0 | 55 | 1 | 54 | 75.0 | 0 |
| 22 | 2015 | 01 | 003 | 22 | 8 | 10 | 258 | 0 | 0.0 | No data | No data | 3 | 2 | 1 | 0.39 | 0 |
| 23 | 2015 | 01 | 003 | 23 | 450 | 451 | 3462 | 64 | 14.414 | 50 | 11.261 | 767 | 555 | 212 | 6.326 | 35 |
| 24 | 2015 | 01 | 003 | 31 | 144 | 146 | 4318 | 14 | 9.655 | 12 | 8.276 | 353 | 161 | 192 | 4.554 | 8 |
| 25 | 2015 | 01 | 003 | 42 | 217 | 223 | 2261 | 22 | 9.955 | 18 | 8.145 | 211 | 182 | 29 | 1.293 | 14 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing