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 2021-03-14 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 |
---|---|---|---|---|---|---|---|
1120328 | 1120328 | 2021-03-14 | Alamance | North Carolina | 37001 | 16144 | 233 |
1120329 | 1120329 | 2021-03-14 | Alexander | North Carolina | 37003 | 4004 | 82 |
1120330 | 1120330 | 2021-03-14 | Alleghany | North Carolina | 37005 | 934 | 5 |
1120331 | 1120331 | 2021-03-14 | Anson | North Carolina | 37007 | 2376 | 53 |
1120332 | 1120332 | 2021-03-14 | Ashe | North Carolina | 37009 | 1908 | 40 |
1120333 | 1120333 | 2021-03-14 | Avery | North Carolina | 37011 | 1900 | 20 |
1120334 | 1120334 | 2021-03-14 | Beaufort | North Carolina | 37013 | 4342 | 84 |
1120335 | 1120335 | 2021-03-14 | Bertie | North Carolina | 37015 | 1680 | 41 |
1120336 | 1120336 | 2021-03-14 | Bladen | North Carolina | 37017 | 3022 | 41 |
1120337 | 1120337 | 2021-03-14 | Brunswick | North Carolina | 37019 | 8251 | 138 |
1120338 | 1120338 | 2021-03-14 | Buncombe | North Carolina | 37021 | 15895 | 304 |
1120339 | 1120339 | 2021-03-14 | Burke | North Carolina | 37023 | 9374 | 145 |
1120340 | 1120340 | 2021-03-14 | Cabarrus | North Carolina | 37025 | 18963 | 238 |
1120341 | 1120341 | 2021-03-14 | Caldwell | North Carolina | 37027 | 8775 | 93 |
1120342 | 1120342 | 2021-03-14 | Camden | North Carolina | 37029 | 606 | 5 |
1120343 | 1120343 | 2021-03-14 | Carteret | North Carolina | 37031 | 4563 | 45 |
1120344 | 1120344 | 2021-03-14 | Caswell | North Carolina | 37033 | 2017 | 25 |
1120345 | 1120345 | 2021-03-14 | Catawba | North Carolina | 37035 | 17792 | 286 |
1120346 | 1120346 | 2021-03-14 | Chatham | North Carolina | 37037 | 4236 | 80 |
1120347 | 1120347 | 2021-03-14 | Cherokee | North Carolina | 37039 | 2165 | 19 |
1120348 | 1120348 | 2021-03-14 | Chowan | North Carolina | 37041 | 1390 | 22 |
1120349 | 1120349 | 2021-03-14 | Clay | North Carolina | 37043 | 667 | 18 |
1120350 | 1120350 | 2021-03-14 | Cleveland | North Carolina | 37045 | 10552 | 218 |
1120351 | 1120351 | 2021-03-14 | Columbus | North Carolina | 37047 | 5993 | 147 |
1120352 | 1120352 | 2021-03-14 | Craven | North Carolina | 37049 | 8566 | 116 |
1120353 | 1120353 | 2021-03-14 | Cumberland | North Carolina | 37051 | 24825 | 284 |
1120354 | 1120354 | 2021-03-14 | Currituck | North Carolina | 37053 | 1413 | 15 |
1120355 | 1120355 | 2021-03-14 | Dare | North Carolina | 37055 | 1888 | 8 |
1120356 | 1120356 | 2021-03-14 | Davidson | North Carolina | 37057 | 14875 | 177 |
1120357 | 1120357 | 2021-03-14 | Davie | North Carolina | 37059 | 3628 | 35 |
1120358 | 1120358 | 2021-03-14 | Duplin | North Carolina | 37061 | 5830 | 128 |
1120359 | 1120359 | 2021-03-14 | Durham | North Carolina | 37063 | 22713 | 214 |
1120360 | 1120360 | 2021-03-14 | Edgecombe | North Carolina | 37065 | 4793 | 100 |
1120361 | 1120361 | 2021-03-14 | Forsyth | North Carolina | 37067 | 32522 | 357 |
1120362 | 1120362 | 2021-03-14 | Franklin | North Carolina | 37069 | 5642 | 45 |
1120363 | 1120363 | 2021-03-14 | Gaston | North Carolina | 37071 | 24208 | 389 |
1120364 | 1120364 | 2021-03-14 | Gates | North Carolina | 37073 | 689 | 12 |
1120365 | 1120365 | 2021-03-14 | Graham | North Carolina | 37075 | 568 | 12 |
1120366 | 1120366 | 2021-03-14 | Granville | North Carolina | 37077 | 5409 | 76 |
1120367 | 1120367 | 2021-03-14 | Greene | North Carolina | 37079 | 2151 | 42 |
1120368 | 1120368 | 2021-03-14 | Guilford | North Carolina | 37081 | 40987 | 564 |
1120369 | 1120369 | 2021-03-14 | Halifax | North Carolina | 37083 | 5062 | 102 |
1120370 | 1120370 | 2021-03-14 | Harnett | North Carolina | 37085 | 10033 | 158 |
1120371 | 1120371 | 2021-03-14 | Haywood | North Carolina | 37087 | 3930 | 90 |
1120372 | 1120372 | 2021-03-14 | Henderson | North Carolina | 37089 | 9158 | 151 |
1120373 | 1120373 | 2021-03-14 | Hertford | North Carolina | 37091 | 1970 | 62 |
1120374 | 1120374 | 2021-03-14 | Hoke | North Carolina | 37093 | 4223 | 54 |
1120375 | 1120375 | 2021-03-14 | Hyde | North Carolina | 37095 | 629 | 8 |
1120376 | 1120376 | 2021-03-14 | Iredell | North Carolina | 37097 | 16823 | 197 |
1120377 | 1120377 | 2021-03-14 | Jackson | North Carolina | 37099 | 3405 | 55 |
1120378 | 1120378 | 2021-03-14 | Johnston | North Carolina | 37101 | 18580 | 204 |
1120379 | 1120379 | 2021-03-14 | Jones | North Carolina | 37103 | 751 | 16 |
1120380 | 1120380 | 2021-03-14 | Lee | North Carolina | 37105 | 5541 | 73 |
1120381 | 1120381 | 2021-03-14 | Lenoir | North Carolina | 37107 | 5544 | 108 |
1120382 | 1120382 | 2021-03-14 | Lincoln | North Carolina | 37109 | 9030 | 75 |
1120383 | 1120383 | 2021-03-14 | Macon | North Carolina | 37113 | 2612 | 31 |
1120384 | 1120384 | 2021-03-14 | Madison | North Carolina | 37115 | 1407 | 40 |
1120385 | 1120385 | 2021-03-14 | Martin | North Carolina | 37117 | 2101 | 37 |
1120386 | 1120386 | 2021-03-14 | McDowell | North Carolina | 37111 | 4932 | 62 |
1120387 | 1120387 | 2021-03-14 | Mecklenburg | North Carolina | 37119 | 98940 | 899 |
1120388 | 1120388 | 2021-03-14 | Mitchell | North Carolina | 37121 | 1271 | 16 |
1120389 | 1120389 | 2021-03-14 | Montgomery | North Carolina | 37123 | 3131 | 89 |
1120390 | 1120390 | 2021-03-14 | Moore | North Carolina | 37125 | 8174 | 182 |
1120391 | 1120391 | 2021-03-14 | Nash | North Carolina | 37127 | 10014 | 172 |
1120392 | 1120392 | 2021-03-14 | New Hanover | North Carolina | 37129 | 16723 | 157 |
1120393 | 1120393 | 2021-03-14 | Northampton | North Carolina | 37131 | 1751 | 36 |
1120394 | 1120394 | 2021-03-14 | Onslow | North Carolina | 37133 | 15018 | 137 |
1120395 | 1120395 | 2021-03-14 | Orange | North Carolina | 37135 | 7847 | 97 |
1120396 | 1120396 | 2021-03-14 | Pamlico | North Carolina | 37137 | 989 | 10 |
1120397 | 1120397 | 2021-03-14 | Pasquotank | North Carolina | 37139 | 3124 | 78 |
1120398 | 1120398 | 2021-03-14 | Pender | North Carolina | 37141 | 4857 | 65 |
1120399 | 1120399 | 2021-03-14 | Perquimans | North Carolina | 37143 | 935 | 9 |
1120400 | 1120400 | 2021-03-14 | Person | North Carolina | 37145 | 3097 | 67 |
1120401 | 1120401 | 2021-03-14 | Pitt | North Carolina | 37147 | 17822 | 84 |
1120402 | 1120402 | 2021-03-14 | Polk | North Carolina | 37149 | 1370 | 27 |
1120403 | 1120403 | 2021-03-14 | Randolph | North Carolina | 37151 | 13725 | 207 |
1120404 | 1120404 | 2021-03-14 | Richmond | North Carolina | 37153 | 4278 | 92 |
1120405 | 1120405 | 2021-03-14 | Robeson | North Carolina | 37155 | 15441 | 218 |
1120406 | 1120406 | 2021-03-14 | Rockingham | North Carolina | 37157 | 6943 | 61 |
1120407 | 1120407 | 2021-03-14 | Rowan | North Carolina | 37159 | 15207 | 291 |
1120408 | 1120408 | 2021-03-14 | Rutherford | North Carolina | 37161 | 6846 | 201 |
1120409 | 1120409 | 2021-03-14 | Sampson | North Carolina | 37163 | 7062 | 94 |
1120410 | 1120410 | 2021-03-14 | Scotland | North Carolina | 37165 | 3528 | 80 |
1120411 | 1120411 | 2021-03-14 | Stanly | North Carolina | 37167 | 7011 | 112 |
1120412 | 1120412 | 2021-03-14 | Stokes | North Carolina | 37169 | 3710 | 75 |
1120413 | 1120413 | 2021-03-14 | Surry | North Carolina | 37171 | 7487 | 140 |
1120414 | 1120414 | 2021-03-14 | Swain | North Carolina | 37173 | 1174 | 16 |
1120415 | 1120415 | 2021-03-14 | Transylvania | North Carolina | 37175 | 1978 | 28 |
1120416 | 1120416 | 2021-03-14 | Tyrrell | North Carolina | 37177 | 305 | 6 |
1120417 | 1120417 | 2021-03-14 | Union | North Carolina | 37179 | 21331 | 204 |
1120418 | 1120418 | 2021-03-14 | Vance | North Carolina | 37181 | 4480 | 82 |
1120419 | 1120419 | 2021-03-14 | Wake | North Carolina | 37183 | 77197 | 572 |
1120420 | 1120420 | 2021-03-14 | Warren | North Carolina | 37185 | 1649 | 18 |
1120421 | 1120421 | 2021-03-14 | Washington | North Carolina | 37187 | 1004 | 31 |
1120422 | 1120422 | 2021-03-14 | Watauga | North Carolina | 37189 | 4101 | 30 |
1120423 | 1120423 | 2021-03-14 | Wayne | North Carolina | 37191 | 10389 | 229 |
1120424 | 1120424 | 2021-03-14 | Wilkes | North Carolina | 37193 | 6133 | 104 |
1120425 | 1120425 | 2021-03-14 | Wilson | North Carolina | 37195 | 8670 | 152 |
1120426 | 1120426 | 2021-03-14 | Yadkin | North Carolina | 37197 | 3713 | 46 |
1120427 | 1120427 | 2021-03-14 | Yancey | North Carolina | 37199 | 1476 | 26 |
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);