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-15 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
536319 | 536319 | 2020-09-15 | Alamance | North Carolina | 37001 | 3584 | 48 |
536320 | 536320 | 2020-09-15 | Alexander | North Carolina | 37003 | 471 | 3 |
536321 | 536321 | 2020-09-15 | Alleghany | North Carolina | 37005 | 217 | 0 |
536322 | 536322 | 2020-09-15 | Anson | North Carolina | 37007 | 521 | 3 |
536323 | 536323 | 2020-09-15 | Ashe | North Carolina | 37009 | 244 | 1 |
536324 | 536324 | 2020-09-15 | Avery | North Carolina | 37011 | 306 | 0 |
536325 | 536325 | 2020-09-15 | Beaufort | North Carolina | 37013 | 791 | 10 |
536326 | 536326 | 2020-09-15 | Bertie | North Carolina | 37015 | 520 | 7 |
536327 | 536327 | 2020-09-15 | Bladen | North Carolina | 37017 | 803 | 12 |
536328 | 536328 | 2020-09-15 | Brunswick | North Carolina | 37019 | 1487 | 26 |
536329 | 536329 | 2020-09-15 | Buncombe | North Carolina | 37021 | 2764 | 85 |
536330 | 536330 | 2020-09-15 | Burke | North Carolina | 37023 | 1974 | 33 |
536331 | 536331 | 2020-09-15 | Cabarrus | North Carolina | 37025 | 3647 | 59 |
536332 | 536332 | 2020-09-15 | Caldwell | North Carolina | 37027 | 1526 | 17 |
536333 | 536333 | 2020-09-15 | Camden | North Carolina | 37029 | 107 | 3 |
536334 | 536334 | 2020-09-15 | Carteret | North Carolina | 37031 | 587 | 5 |
536335 | 536335 | 2020-09-15 | Caswell | North Carolina | 37033 | 278 | 3 |
536336 | 536336 | 2020-09-15 | Catawba | North Carolina | 37035 | 2860 | 48 |
536337 | 536337 | 2020-09-15 | Chatham | North Carolina | 37037 | 1577 | 57 |
536338 | 536338 | 2020-09-15 | Cherokee | North Carolina | 37039 | 546 | 6 |
536339 | 536339 | 2020-09-15 | Chowan | North Carolina | 37041 | 285 | 3 |
536340 | 536340 | 2020-09-15 | Clay | North Carolina | 37043 | 106 | 1 |
536341 | 536341 | 2020-09-15 | Cleveland | North Carolina | 37045 | 1879 | 54 |
536342 | 536342 | 2020-09-15 | Columbus | North Carolina | 37047 | 1269 | 53 |
536343 | 536343 | 2020-09-15 | Craven | North Carolina | 37049 | 1181 | 30 |
536344 | 536344 | 2020-09-15 | Cumberland | North Carolina | 37051 | 4787 | 75 |
536345 | 536345 | 2020-09-15 | Currituck | North Carolina | 37053 | 137 | 0 |
536346 | 536346 | 2020-09-15 | Dare | North Carolina | 37055 | 259 | 2 |
536347 | 536347 | 2020-09-15 | Davidson | North Carolina | 37057 | 2477 | 33 |
536348 | 536348 | 2020-09-15 | Davie | North Carolina | 37059 | 520 | 6 |
536349 | 536349 | 2020-09-15 | Duplin | North Carolina | 37061 | 2121 | 52 |
536350 | 536350 | 2020-09-15 | Durham | North Carolina | 37063 | 7356 | 88 |
536351 | 536351 | 2020-09-15 | Edgecombe | North Carolina | 37065 | 1189 | 36 |
536352 | 536352 | 2020-09-15 | Forsyth | North Carolina | 37067 | 6668 | 91 |
536353 | 536353 | 2020-09-15 | Franklin | North Carolina | 37069 | 1156 | 30 |
536354 | 536354 | 2020-09-15 | Gaston | North Carolina | 37071 | 4600 | 74 |
536355 | 536355 | 2020-09-15 | Gates | North Carolina | 37073 | 109 | 3 |
536356 | 536356 | 2020-09-15 | Graham | North Carolina | 37075 | 113 | 0 |
536357 | 536357 | 2020-09-15 | Granville | North Carolina | 37077 | 1647 | 48 |
536358 | 536358 | 2020-09-15 | Greene | North Carolina | 37079 | 485 | 5 |
536359 | 536359 | 2020-09-15 | Guilford | North Carolina | 37081 | 7790 | 176 |
536360 | 536360 | 2020-09-15 | Halifax | North Carolina | 37083 | 930 | 17 |
536361 | 536361 | 2020-09-15 | Harnett | North Carolina | 37085 | 1887 | 49 |
536362 | 536362 | 2020-09-15 | Haywood | North Carolina | 37087 | 560 | 31 |
536363 | 536363 | 2020-09-15 | Henderson | North Carolina | 37089 | 1848 | 65 |
536364 | 536364 | 2020-09-15 | Hertford | North Carolina | 37091 | 645 | 24 |
536365 | 536365 | 2020-09-15 | Hoke | North Carolina | 37093 | 997 | 13 |
536366 | 536366 | 2020-09-15 | Hyde | North Carolina | 37095 | 123 | 3 |
536367 | 536367 | 2020-09-15 | Iredell | North Carolina | 37097 | 2569 | 25 |
536368 | 536368 | 2020-09-15 | Jackson | North Carolina | 37099 | 523 | 7 |
536369 | 536369 | 2020-09-15 | Johnston | North Carolina | 37101 | 4227 | 54 |
536370 | 536370 | 2020-09-15 | Jones | North Carolina | 37103 | 141 | 11 |
536371 | 536371 | 2020-09-15 | Lee | North Carolina | 37105 | 1538 | 13 |
536372 | 536372 | 2020-09-15 | Lenoir | North Carolina | 37107 | 907 | 22 |
536373 | 536373 | 2020-09-15 | Lincoln | North Carolina | 37109 | 1378 | 14 |
536374 | 536374 | 2020-09-15 | Macon | North Carolina | 37113 | 567 | 2 |
536375 | 536375 | 2020-09-15 | Madison | North Carolina | 37115 | 87 | 1 |
536376 | 536376 | 2020-09-15 | Martin | North Carolina | 37117 | 400 | 9 |
536377 | 536377 | 2020-09-15 | McDowell | North Carolina | 37111 | 870 | 26 |
536378 | 536378 | 2020-09-15 | Mecklenburg | North Carolina | 37119 | 27271 | 340 |
536379 | 536379 | 2020-09-15 | Mitchell | North Carolina | 37121 | 101 | 3 |
536380 | 536380 | 2020-09-15 | Montgomery | North Carolina | 37123 | 990 | 23 |
536381 | 536381 | 2020-09-15 | Moore | North Carolina | 37125 | 1472 | 22 |
536382 | 536382 | 2020-09-15 | Nash | North Carolina | 37127 | 1986 | 34 |
536383 | 536383 | 2020-09-15 | New Hanover | North Carolina | 37129 | 3710 | 26 |
536384 | 536384 | 2020-09-15 | Northampton | North Carolina | 37131 | 389 | 17 |
536385 | 536385 | 2020-09-15 | Onslow | North Carolina | 37133 | 1731 | 20 |
536386 | 536386 | 2020-09-15 | Orange | North Carolina | 37135 | 2535 | 54 |
536387 | 536387 | 2020-09-15 | Pamlico | North Carolina | 37137 | 219 | 2 |
536388 | 536388 | 2020-09-15 | Pasquotank | North Carolina | 37139 | 631 | 26 |
536389 | 536389 | 2020-09-15 | Pender | North Carolina | 37141 | 837 | 5 |
536390 | 536390 | 2020-09-15 | Perquimans | North Carolina | 37143 | 161 | 3 |
536391 | 536391 | 2020-09-15 | Person | North Carolina | 37145 | 385 | 6 |
536392 | 536392 | 2020-09-15 | Pitt | North Carolina | 37147 | 4345 | 25 |
536393 | 536393 | 2020-09-15 | Polk | North Carolina | 37149 | 254 | 7 |
536394 | 536394 | 2020-09-15 | Randolph | North Carolina | 37151 | 2611 | 49 |
536395 | 536395 | 2020-09-15 | Richmond | North Carolina | 37153 | 842 | 12 |
536396 | 536396 | 2020-09-15 | Robeson | North Carolina | 37155 | 4065 | 66 |
536397 | 536397 | 2020-09-15 | Rockingham | North Carolina | 37157 | 1087 | 13 |
536398 | 536398 | 2020-09-15 | Rowan | North Carolina | 37159 | 3086 | 85 |
536399 | 536399 | 2020-09-15 | Rutherford | North Carolina | 37161 | 1070 | 27 |
536400 | 536400 | 2020-09-15 | Sampson | North Carolina | 37163 | 1710 | 22 |
536401 | 536401 | 2020-09-15 | Scotland | North Carolina | 37165 | 838 | 12 |
536402 | 536402 | 2020-09-15 | Stanly | North Carolina | 37167 | 1733 | 52 |
536403 | 536403 | 2020-09-15 | Stokes | North Carolina | 37169 | 391 | 3 |
536404 | 536404 | 2020-09-15 | Surry | North Carolina | 37171 | 1243 | 20 |
536405 | 536405 | 2020-09-15 | Swain | North Carolina | 37173 | 135 | 3 |
536406 | 536406 | 2020-09-15 | Transylvania | North Carolina | 37175 | 296 | 6 |
536407 | 536407 | 2020-09-15 | Tyrrell | North Carolina | 37177 | 111 | 2 |
536408 | 536408 | 2020-09-15 | Union | North Carolina | 37179 | 4474 | 56 |
536409 | 536409 | 2020-09-15 | Vance | North Carolina | 37181 | 990 | 43 |
536410 | 536410 | 2020-09-15 | Wake | North Carolina | 37183 | 16655 | 220 |
536411 | 536411 | 2020-09-15 | Warren | North Carolina | 37185 | 302 | 7 |
536412 | 536412 | 2020-09-15 | Washington | North Carolina | 37187 | 196 | 8 |
536413 | 536413 | 2020-09-15 | Watauga | North Carolina | 37189 | 540 | 0 |
536414 | 536414 | 2020-09-15 | Wayne | North Carolina | 37191 | 3046 | 62 |
536415 | 536415 | 2020-09-15 | Wilkes | North Carolina | 37193 | 1124 | 31 |
536416 | 536416 | 2020-09-15 | Wilson | North Carolina | 37195 | 1979 | 44 |
536417 | 536417 | 2020-09-15 | Yadkin | North Carolina | 37197 | 688 | 7 |
536418 | 536418 | 2020-09-15 | Yancey | North Carolina | 37199 | 116 | 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);