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-08-20 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 |
---|---|---|---|---|---|---|---|
452261 | 452261 | 2020-08-20 | Alamance | North Carolina | 37001 | 2726 | 44 |
452262 | 452262 | 2020-08-20 | Alexander | North Carolina | 37003 | 354 | 2 |
452263 | 452263 | 2020-08-20 | Alleghany | North Carolina | 37005 | 181 | 0 |
452264 | 452264 | 2020-08-20 | Anson | North Carolina | 37007 | 388 | 3 |
452265 | 452265 | 2020-08-20 | Ashe | North Carolina | 37009 | 179 | 1 |
452266 | 452266 | 2020-08-20 | Avery | North Carolina | 37011 | 114 | 0 |
452267 | 452267 | 2020-08-20 | Beaufort | North Carolina | 37013 | 470 | 9 |
452268 | 452268 | 2020-08-20 | Bertie | North Carolina | 37015 | 340 | 5 |
452269 | 452269 | 2020-08-20 | Bladen | North Carolina | 37017 | 663 | 8 |
452270 | 452270 | 2020-08-20 | Brunswick | North Carolina | 37019 | 1337 | 24 |
452271 | 452271 | 2020-08-20 | Buncombe | North Carolina | 37021 | 2167 | 64 |
452272 | 452272 | 2020-08-20 | Burke | North Carolina | 37023 | 1753 | 27 |
452273 | 452273 | 2020-08-20 | Cabarrus | North Carolina | 37025 | 2866 | 51 |
452274 | 452274 | 2020-08-20 | Caldwell | North Carolina | 37027 | 1320 | 14 |
452275 | 452275 | 2020-08-20 | Camden | North Carolina | 37029 | 83 | 2 |
452276 | 452276 | 2020-08-20 | Carteret | North Carolina | 37031 | 399 | 5 |
452277 | 452277 | 2020-08-20 | Caswell | North Carolina | 37033 | 207 | 2 |
452278 | 452278 | 2020-08-20 | Catawba | North Carolina | 37035 | 2345 | 38 |
452279 | 452279 | 2020-08-20 | Chatham | North Carolina | 37037 | 1380 | 55 |
452280 | 452280 | 2020-08-20 | Cherokee | North Carolina | 37039 | 346 | 5 |
452281 | 452281 | 2020-08-20 | Chowan | North Carolina | 37041 | 170 | 2 |
452282 | 452282 | 2020-08-20 | Clay | North Carolina | 37043 | 80 | 1 |
452283 | 452283 | 2020-08-20 | Cleveland | North Carolina | 37045 | 1398 | 25 |
452284 | 452284 | 2020-08-20 | Columbus | North Carolina | 37047 | 1013 | 50 |
452285 | 452285 | 2020-08-20 | Craven | North Carolina | 37049 | 844 | 23 |
452286 | 452286 | 2020-08-20 | Cumberland | North Carolina | 37051 | 3573 | 63 |
452287 | 452287 | 2020-08-20 | Currituck | North Carolina | 37053 | 86 | 0 |
452288 | 452288 | 2020-08-20 | Dare | North Carolina | 37055 | 218 | 2 |
452289 | 452289 | 2020-08-20 | Davidson | North Carolina | 37057 | 1965 | 31 |
452290 | 452290 | 2020-08-20 | Davie | North Carolina | 37059 | 449 | 5 |
452291 | 452291 | 2020-08-20 | Duplin | North Carolina | 37061 | 2043 | 49 |
452292 | 452292 | 2020-08-20 | Durham | North Carolina | 37063 | 6557 | 81 |
452293 | 452293 | 2020-08-20 | Edgecombe | North Carolina | 37065 | 792 | 16 |
452294 | 452294 | 2020-08-20 | Forsyth | North Carolina | 37067 | 5681 | 63 |
452295 | 452295 | 2020-08-20 | Franklin | North Carolina | 37069 | 956 | 28 |
452296 | 452296 | 2020-08-20 | Gaston | North Carolina | 37071 | 3716 | 59 |
452297 | 452297 | 2020-08-20 | Gates | North Carolina | 37073 | 66 | 2 |
452298 | 452298 | 2020-08-20 | Graham | North Carolina | 37075 | 49 | 0 |
452299 | 452299 | 2020-08-20 | Granville | North Carolina | 37077 | 1391 | 35 |
452300 | 452300 | 2020-08-20 | Greene | North Carolina | 37079 | 355 | 3 |
452301 | 452301 | 2020-08-20 | Guilford | North Carolina | 37081 | 6165 | 160 |
452302 | 452302 | 2020-08-20 | Halifax | North Carolina | 37083 | 789 | 9 |
452303 | 452303 | 2020-08-20 | Harnett | North Carolina | 37085 | 1463 | 41 |
452304 | 452304 | 2020-08-20 | Haywood | North Carolina | 37087 | 474 | 25 |
452305 | 452305 | 2020-08-20 | Henderson | North Carolina | 37089 | 1620 | 59 |
452306 | 452306 | 2020-08-20 | Hertford | North Carolina | 37091 | 425 | 12 |
452307 | 452307 | 2020-08-20 | Hoke | North Carolina | 37093 | 794 | 12 |
452308 | 452308 | 2020-08-20 | Hyde | North Carolina | 37095 | 64 | 0 |
452309 | 452309 | 2020-08-20 | Iredell | North Carolina | 37097 | 2083 | 18 |
452310 | 452310 | 2020-08-20 | Jackson | North Carolina | 37099 | 462 | 7 |
452311 | 452311 | 2020-08-20 | Johnston | North Carolina | 37101 | 3555 | 50 |
452312 | 452312 | 2020-08-20 | Jones | North Carolina | 37103 | 120 | 4 |
452313 | 452313 | 2020-08-20 | Lee | North Carolina | 37105 | 1362 | 11 |
452314 | 452314 | 2020-08-20 | Lenoir | North Carolina | 37107 | 689 | 11 |
452315 | 452315 | 2020-08-20 | Lincoln | North Carolina | 37109 | 966 | 10 |
452316 | 452316 | 2020-08-20 | Macon | North Carolina | 37113 | 492 | 2 |
452317 | 452317 | 2020-08-20 | Madison | North Carolina | 37115 | 52 | 1 |
452318 | 452318 | 2020-08-20 | Martin | North Carolina | 37117 | 294 | 7 |
452319 | 452319 | 2020-08-20 | McDowell | North Carolina | 37111 | 735 | 22 |
452320 | 452320 | 2020-08-20 | Mecklenburg | North Carolina | 37119 | 23824 | 276 |
452321 | 452321 | 2020-08-20 | Mitchell | North Carolina | 37121 | 83 | 3 |
452322 | 452322 | 2020-08-20 | Montgomery | North Carolina | 37123 | 739 | 16 |
452323 | 452323 | 2020-08-20 | Moore | North Carolina | 37125 | 1132 | 21 |
452324 | 452324 | 2020-08-20 | Nash | North Carolina | 37127 | 1391 | 17 |
452325 | 452325 | 2020-08-20 | New Hanover | North Carolina | 37129 | 2770 | 21 |
452326 | 452326 | 2020-08-20 | Northampton | North Carolina | 37131 | 322 | 16 |
452327 | 452327 | 2020-08-20 | Onslow | North Carolina | 37133 | 1280 | 12 |
452328 | 452328 | 2020-08-20 | Orange | North Carolina | 37135 | 1650 | 49 |
452329 | 452329 | 2020-08-20 | Pamlico | North Carolina | 37137 | 77 | 2 |
452330 | 452330 | 2020-08-20 | Pasquotank | North Carolina | 37139 | 468 | 21 |
452331 | 452331 | 2020-08-20 | Pender | North Carolina | 37141 | 716 | 4 |
452332 | 452332 | 2020-08-20 | Perquimans | North Carolina | 37143 | 97 | 2 |
452333 | 452333 | 2020-08-20 | Person | North Carolina | 37145 | 259 | 2 |
452334 | 452334 | 2020-08-20 | Pitt | North Carolina | 37147 | 2404 | 14 |
452335 | 452335 | 2020-08-20 | Polk | North Carolina | 37149 | 190 | 6 |
452336 | 452336 | 2020-08-20 | Randolph | North Carolina | 37151 | 2289 | 42 |
452337 | 452337 | 2020-08-20 | Richmond | North Carolina | 37153 | 584 | 9 |
452338 | 452338 | 2020-08-20 | Robeson | North Carolina | 37155 | 3128 | 56 |
452339 | 452339 | 2020-08-20 | Rockingham | North Carolina | 37157 | 651 | 6 |
452340 | 452340 | 2020-08-20 | Rowan | North Carolina | 37159 | 2449 | 55 |
452341 | 452341 | 2020-08-20 | Rutherford | North Carolina | 37161 | 889 | 20 |
452342 | 452342 | 2020-08-20 | Sampson | North Carolina | 37163 | 1531 | 19 |
452343 | 452343 | 2020-08-20 | Scotland | North Carolina | 37165 | 495 | 7 |
452344 | 452344 | 2020-08-20 | Stanly | North Carolina | 37167 | 1300 | 31 |
452345 | 452345 | 2020-08-20 | Stokes | North Carolina | 37169 | 310 | 3 |
452346 | 452346 | 2020-08-20 | Surry | North Carolina | 37171 | 1041 | 11 |
452347 | 452347 | 2020-08-20 | Swain | North Carolina | 37173 | 123 | 2 |
452348 | 452348 | 2020-08-20 | Transylvania | North Carolina | 37175 | 180 | 1 |
452349 | 452349 | 2020-08-20 | Tyrrell | North Carolina | 37177 | 103 | 2 |
452350 | 452350 | 2020-08-20 | Union | North Carolina | 37179 | 3551 | 47 |
452351 | 452351 | 2020-08-20 | Vance | North Carolina | 37181 | 832 | 41 |
452352 | 452352 | 2020-08-20 | Wake | North Carolina | 37183 | 13313 | 188 |
452353 | 452353 | 2020-08-20 | Warren | North Carolina | 37185 | 277 | 6 |
452354 | 452354 | 2020-08-20 | Washington | North Carolina | 37187 | 155 | 4 |
452355 | 452355 | 2020-08-20 | Watauga | North Carolina | 37189 | 358 | 0 |
452356 | 452356 | 2020-08-20 | Wayne | North Carolina | 37191 | 2618 | 44 |
452357 | 452357 | 2020-08-20 | Wilkes | North Carolina | 37193 | 945 | 19 |
452358 | 452358 | 2020-08-20 | Wilson | North Carolina | 37195 | 1604 | 36 |
452359 | 452359 | 2020-08-20 | Yadkin | North Carolina | 37197 | 587 | 7 |
452360 | 452360 | 2020-08-20 | Yancey | North Carolina | 37199 | 83 | 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);