ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-09-19 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Avery 1
- Beaufort 1
- Bertie 1
- Bladen 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Camden 1
- Carteret 1
- Caswell 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Chowan 1
- Clay 1
- Cleveland 1
- Columbus 1
- Craven 1
- Cumberland 1
- Currituck 1
- Dare 1
- Davidson 1
- Davie 1
- …
state 1
- North Carolina · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
549268 | 549268 | 2020-09-19 | Alamance | North Carolina | 37001 | 3695 | 48 |
549269 | 549269 | 2020-09-19 | Alexander | North Carolina | 37003 | 483 | 5 |
549270 | 549270 | 2020-09-19 | Alleghany | North Carolina | 37005 | 219 | 0 |
549271 | 549271 | 2020-09-19 | Anson | North Carolina | 37007 | 549 | 4 |
549272 | 549272 | 2020-09-19 | Ashe | North Carolina | 37009 | 247 | 1 |
549273 | 549273 | 2020-09-19 | Avery | North Carolina | 37011 | 321 | 0 |
549274 | 549274 | 2020-09-19 | Beaufort | North Carolina | 37013 | 818 | 17 |
549275 | 549275 | 2020-09-19 | Bertie | North Carolina | 37015 | 540 | 7 |
549276 | 549276 | 2020-09-19 | Bladen | North Carolina | 37017 | 818 | 12 |
549277 | 549277 | 2020-09-19 | Brunswick | North Carolina | 37019 | 1523 | 26 |
549278 | 549278 | 2020-09-19 | Buncombe | North Carolina | 37021 | 2844 | 89 |
549279 | 549279 | 2020-09-19 | Burke | North Carolina | 37023 | 2018 | 33 |
549280 | 549280 | 2020-09-19 | Cabarrus | North Carolina | 37025 | 3739 | 61 |
549281 | 549281 | 2020-09-19 | Caldwell | North Carolina | 37027 | 1557 | 18 |
549282 | 549282 | 2020-09-19 | Camden | North Carolina | 37029 | 107 | 3 |
549283 | 549283 | 2020-09-19 | Carteret | North Carolina | 37031 | 608 | 5 |
549284 | 549284 | 2020-09-19 | Caswell | North Carolina | 37033 | 315 | 3 |
549285 | 549285 | 2020-09-19 | Catawba | North Carolina | 37035 | 2958 | 51 |
549286 | 549286 | 2020-09-19 | Chatham | North Carolina | 37037 | 1589 | 57 |
549287 | 549287 | 2020-09-19 | Cherokee | North Carolina | 37039 | 567 | 10 |
549288 | 549288 | 2020-09-19 | Chowan | North Carolina | 37041 | 306 | 3 |
549289 | 549289 | 2020-09-19 | Clay | North Carolina | 37043 | 109 | 2 |
549290 | 549290 | 2020-09-19 | Cleveland | North Carolina | 37045 | 1994 | 60 |
549291 | 549291 | 2020-09-19 | Columbus | North Carolina | 37047 | 1305 | 54 |
549292 | 549292 | 2020-09-19 | Craven | North Carolina | 37049 | 1247 | 30 |
549293 | 549293 | 2020-09-19 | Cumberland | North Carolina | 37051 | 5018 | 75 |
549294 | 549294 | 2020-09-19 | Currituck | North Carolina | 37053 | 150 | 2 |
549295 | 549295 | 2020-09-19 | Dare | North Carolina | 37055 | 258 | 2 |
549296 | 549296 | 2020-09-19 | Davidson | North Carolina | 37057 | 2575 | 34 |
549297 | 549297 | 2020-09-19 | Davie | North Carolina | 37059 | 527 | 6 |
549298 | 549298 | 2020-09-19 | Duplin | North Carolina | 37061 | 2137 | 53 |
549299 | 549299 | 2020-09-19 | Durham | North Carolina | 37063 | 7502 | 91 |
549300 | 549300 | 2020-09-19 | Edgecombe | North Carolina | 37065 | 1254 | 37 |
549301 | 549301 | 2020-09-19 | Forsyth | North Carolina | 37067 | 6786 | 94 |
549302 | 549302 | 2020-09-19 | Franklin | North Carolina | 37069 | 1177 | 32 |
549303 | 549303 | 2020-09-19 | Gaston | North Carolina | 37071 | 4806 | 75 |
549304 | 549304 | 2020-09-19 | Gates | North Carolina | 37073 | 121 | 3 |
549305 | 549305 | 2020-09-19 | Graham | North Carolina | 37075 | 122 | 1 |
549306 | 549306 | 2020-09-19 | Granville | North Carolina | 37077 | 1680 | 48 |
549307 | 549307 | 2020-09-19 | Greene | North Carolina | 37079 | 498 | 5 |
549308 | 549308 | 2020-09-19 | Guilford | North Carolina | 37081 | 8064 | 176 |
549309 | 549309 | 2020-09-19 | Halifax | North Carolina | 37083 | 957 | 18 |
549310 | 549310 | 2020-09-19 | Harnett | North Carolina | 37085 | 2003 | 51 |
549311 | 549311 | 2020-09-19 | Haywood | North Carolina | 37087 | 577 | 31 |
549312 | 549312 | 2020-09-19 | Henderson | North Carolina | 37089 | 1909 | 64 |
549313 | 549313 | 2020-09-19 | Hertford | North Carolina | 37091 | 681 | 26 |
549314 | 549314 | 2020-09-19 | Hoke | North Carolina | 37093 | 1058 | 16 |
549315 | 549315 | 2020-09-19 | Hyde | North Carolina | 37095 | 124 | 4 |
549316 | 549316 | 2020-09-19 | Iredell | North Carolina | 37097 | 2653 | 27 |
549317 | 549317 | 2020-09-19 | Jackson | North Carolina | 37099 | 529 | 7 |
549318 | 549318 | 2020-09-19 | Johnston | North Carolina | 37101 | 4317 | 55 |
549319 | 549319 | 2020-09-19 | Jones | North Carolina | 37103 | 143 | 11 |
549320 | 549320 | 2020-09-19 | Lee | North Carolina | 37105 | 1569 | 13 |
549321 | 549321 | 2020-09-19 | Lenoir | North Carolina | 37107 | 937 | 27 |
549322 | 549322 | 2020-09-19 | Lincoln | North Carolina | 37109 | 1437 | 14 |
549323 | 549323 | 2020-09-19 | Macon | North Carolina | 37113 | 582 | 2 |
549324 | 549324 | 2020-09-19 | Madison | North Carolina | 37115 | 89 | 1 |
549325 | 549325 | 2020-09-19 | Martin | North Carolina | 37117 | 418 | 10 |
549326 | 549326 | 2020-09-19 | McDowell | North Carolina | 37111 | 880 | 26 |
549327 | 549327 | 2020-09-19 | Mecklenburg | North Carolina | 37119 | 27605 | 344 |
549328 | 549328 | 2020-09-19 | Mitchell | North Carolina | 37121 | 102 | 3 |
549329 | 549329 | 2020-09-19 | Montgomery | North Carolina | 37123 | 1020 | 25 |
549330 | 549330 | 2020-09-19 | Moore | North Carolina | 37125 | 1505 | 27 |
549331 | 549331 | 2020-09-19 | Nash | North Carolina | 37127 | 2091 | 36 |
549332 | 549332 | 2020-09-19 | New Hanover | North Carolina | 37129 | 3875 | 29 |
549333 | 549333 | 2020-09-19 | Northampton | North Carolina | 37131 | 401 | 17 |
549334 | 549334 | 2020-09-19 | Onslow | North Carolina | 37133 | 1825 | 21 |
549335 | 549335 | 2020-09-19 | Orange | North Carolina | 37135 | 2570 | 54 |
549336 | 549336 | 2020-09-19 | Pamlico | North Carolina | 37137 | 228 | 2 |
549337 | 549337 | 2020-09-19 | Pasquotank | North Carolina | 37139 | 658 | 29 |
549338 | 549338 | 2020-09-19 | Pender | North Carolina | 37141 | 888 | 5 |
549339 | 549339 | 2020-09-19 | Perquimans | North Carolina | 37143 | 171 | 3 |
549340 | 549340 | 2020-09-19 | Person | North Carolina | 37145 | 405 | 6 |
549341 | 549341 | 2020-09-19 | Pitt | North Carolina | 37147 | 4498 | 27 |
549342 | 549342 | 2020-09-19 | Polk | North Carolina | 37149 | 257 | 8 |
549343 | 549343 | 2020-09-19 | Randolph | North Carolina | 37151 | 2645 | 50 |
549344 | 549344 | 2020-09-19 | Richmond | North Carolina | 37153 | 896 | 13 |
549345 | 549345 | 2020-09-19 | Robeson | North Carolina | 37155 | 4218 | 72 |
549346 | 549346 | 2020-09-19 | Rockingham | North Carolina | 37157 | 1131 | 13 |
549347 | 549347 | 2020-09-19 | Rowan | North Carolina | 37159 | 3171 | 91 |
549348 | 549348 | 2020-09-19 | Rutherford | North Carolina | 37161 | 1104 | 27 |
549349 | 549349 | 2020-09-19 | Sampson | North Carolina | 37163 | 1751 | 24 |
549350 | 549350 | 2020-09-19 | Scotland | North Carolina | 37165 | 907 | 12 |
549351 | 549351 | 2020-09-19 | Stanly | North Carolina | 37167 | 1781 | 56 |
549352 | 549352 | 2020-09-19 | Stokes | North Carolina | 37169 | 404 | 3 |
549353 | 549353 | 2020-09-19 | Surry | North Carolina | 37171 | 1271 | 21 |
549354 | 549354 | 2020-09-19 | Swain | North Carolina | 37173 | 139 | 3 |
549355 | 549355 | 2020-09-19 | Transylvania | North Carolina | 37175 | 302 | 7 |
549356 | 549356 | 2020-09-19 | Tyrrell | North Carolina | 37177 | 112 | 2 |
549357 | 549357 | 2020-09-19 | Union | North Carolina | 37179 | 4596 | 58 |
549358 | 549358 | 2020-09-19 | Vance | North Carolina | 37181 | 1014 | 43 |
549359 | 549359 | 2020-09-19 | Wake | North Carolina | 37183 | 16939 | 228 |
549360 | 549360 | 2020-09-19 | Warren | North Carolina | 37185 | 313 | 7 |
549361 | 549361 | 2020-09-19 | Washington | North Carolina | 37187 | 200 | 8 |
549362 | 549362 | 2020-09-19 | Watauga | North Carolina | 37189 | 578 | 1 |
549363 | 549363 | 2020-09-19 | Wayne | North Carolina | 37191 | 3135 | 64 |
549364 | 549364 | 2020-09-19 | Wilkes | North Carolina | 37193 | 1152 | 32 |
549365 | 549365 | 2020-09-19 | Wilson | North Carolina | 37195 | 2053 | 46 |
549366 | 549366 | 2020-09-19 | Yadkin | North Carolina | 37197 | 707 | 7 |
549367 | 549367 | 2020-09-19 | Yancey | North Carolina | 37199 | 119 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);