ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-05-27" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
---|---|---|---|---|---|---|---|
183321 | 183321 | 2020-05-27 | Alamance | North Carolina | 37001 | 282 | 21 |
183322 | 183322 | 2020-05-27 | Alexander | North Carolina | 37003 | 28 | 0 |
183323 | 183323 | 2020-05-27 | Alleghany | North Carolina | 37005 | 14 | 0 |
183324 | 183324 | 2020-05-27 | Anson | North Carolina | 37007 | 59 | 0 |
183325 | 183325 | 2020-05-27 | Ashe | North Carolina | 37009 | 34 | 0 |
183326 | 183326 | 2020-05-27 | Avery | North Carolina | 37011 | 2 | 0 |
183327 | 183327 | 2020-05-27 | Beaufort | North Carolina | 37013 | 33 | 0 |
183328 | 183328 | 2020-05-27 | Bertie | North Carolina | 37015 | 115 | 4 |
183329 | 183329 | 2020-05-27 | Bladen | North Carolina | 37017 | 94 | 2 |
183330 | 183330 | 2020-05-27 | Brunswick | North Carolina | 37019 | 90 | 4 |
183331 | 183331 | 2020-05-27 | Buncombe | North Carolina | 37021 | 279 | 16 |
183332 | 183332 | 2020-05-27 | Burke | North Carolina | 37023 | 337 | 14 |
183333 | 183333 | 2020-05-27 | Cabarrus | North Carolina | 37025 | 449 | 21 |
183334 | 183334 | 2020-05-27 | Caldwell | North Carolina | 37027 | 110 | 2 |
183335 | 183335 | 2020-05-27 | Camden | North Carolina | 37029 | 3 | 0 |
183336 | 183336 | 2020-05-27 | Carteret | North Carolina | 37031 | 36 | 3 |
183337 | 183337 | 2020-05-27 | Caswell | North Carolina | 37033 | 55 | 1 |
183338 | 183338 | 2020-05-27 | Catawba | North Carolina | 37035 | 167 | 3 |
183339 | 183339 | 2020-05-27 | Chatham | North Carolina | 37037 | 588 | 26 |
183340 | 183340 | 2020-05-27 | Cherokee | North Carolina | 37039 | 20 | 1 |
183341 | 183341 | 2020-05-27 | Chowan | North Carolina | 37041 | 16 | 0 |
183342 | 183342 | 2020-05-27 | Clay | North Carolina | 37043 | 5 | 0 |
183343 | 183343 | 2020-05-27 | Cleveland | North Carolina | 37045 | 73 | 2 |
183344 | 183344 | 2020-05-27 | Columbus | North Carolina | 37047 | 304 | 22 |
183345 | 183345 | 2020-05-27 | Craven | North Carolina | 37049 | 192 | 4 |
183346 | 183346 | 2020-05-27 | Cumberland | North Carolina | 37051 | 600 | 16 |
183347 | 183347 | 2020-05-27 | Currituck | North Carolina | 37053 | 13 | 0 |
183348 | 183348 | 2020-05-27 | Dare | North Carolina | 37055 | 22 | 1 |
183349 | 183349 | 2020-05-27 | Davidson | North Carolina | 37057 | 361 | 11 |
183350 | 183350 | 2020-05-27 | Davie | North Carolina | 37059 | 79 | 2 |
183351 | 183351 | 2020-05-27 | Duplin | North Carolina | 37061 | 707 | 12 |
183352 | 183352 | 2020-05-27 | Durham | North Carolina | 37063 | 1359 | 45 |
183353 | 183353 | 2020-05-27 | Edgecombe | North Carolina | 37065 | 190 | 9 |
183354 | 183354 | 2020-05-27 | Forsyth | North Carolina | 37067 | 1022 | 9 |
183355 | 183355 | 2020-05-27 | Franklin | North Carolina | 37069 | 151 | 20 |
183356 | 183356 | 2020-05-27 | Gaston | North Carolina | 37071 | 250 | 7 |
183357 | 183357 | 2020-05-27 | Gates | North Carolina | 37073 | 24 | 1 |
183358 | 183358 | 2020-05-27 | Graham | North Carolina | 37075 | 2 | 0 |
183359 | 183359 | 2020-05-27 | Granville | North Carolina | 37077 | 258 | 8 |
183360 | 183360 | 2020-05-27 | Greene | North Carolina | 37079 | 66 | 2 |
183361 | 183361 | 2020-05-27 | Guilford | North Carolina | 37081 | 1143 | 54 |
183362 | 183362 | 2020-05-27 | Halifax | North Carolina | 37083 | 151 | 1 |
183363 | 183363 | 2020-05-27 | Harnett | North Carolina | 37085 | 278 | 21 |
183364 | 183364 | 2020-05-27 | Haywood | North Carolina | 37087 | 42 | 0 |
183365 | 183365 | 2020-05-27 | Henderson | North Carolina | 37089 | 324 | 46 |
183366 | 183366 | 2020-05-27 | Hertford | North Carolina | 37091 | 72 | 1 |
183367 | 183367 | 2020-05-27 | Hoke | North Carolina | 37093 | 214 | 1 |
183368 | 183368 | 2020-05-27 | Hyde | North Carolina | 37095 | 1 | 0 |
183369 | 183369 | 2020-05-27 | Iredell | North Carolina | 37097 | 236 | 5 |
183370 | 183370 | 2020-05-27 | Jackson | North Carolina | 37099 | 26 | 1 |
183371 | 183371 | 2020-05-27 | Johnston | North Carolina | 37101 | 365 | 20 |
183372 | 183372 | 2020-05-27 | Jones | North Carolina | 37103 | 26 | 3 |
183373 | 183373 | 2020-05-27 | Lee | North Carolina | 37105 | 376 | 3 |
183374 | 183374 | 2020-05-27 | Lenoir | North Carolina | 37107 | 194 | 7 |
183375 | 183375 | 2020-05-27 | Lincoln | North Carolina | 37109 | 61 | 0 |
183376 | 183376 | 2020-05-27 | Macon | North Carolina | 37113 | 18 | 1 |
183377 | 183377 | 2020-05-27 | Madison | North Carolina | 37115 | 3 | 0 |
183378 | 183378 | 2020-05-27 | Martin | North Carolina | 37117 | 61 | 4 |
183379 | 183379 | 2020-05-27 | McDowell | North Carolina | 37111 | 52 | 1 |
183380 | 183380 | 2020-05-27 | Mecklenburg | North Carolina | 37119 | 3478 | 80 |
183381 | 183381 | 2020-05-27 | Mitchell | North Carolina | 37121 | 9 | 0 |
183382 | 183382 | 2020-05-27 | Montgomery | North Carolina | 37123 | 93 | 3 |
183383 | 183383 | 2020-05-27 | Moore | North Carolina | 37125 | 150 | 10 |
183384 | 183384 | 2020-05-27 | Nash | North Carolina | 37127 | 184 | 4 |
183385 | 183385 | 2020-05-27 | New Hanover | North Carolina | 37129 | 164 | 4 |
183386 | 183386 | 2020-05-27 | Northampton | North Carolina | 37131 | 144 | 12 |
183387 | 183387 | 2020-05-27 | Onslow | North Carolina | 37133 | 98 | 2 |
183388 | 183388 | 2020-05-27 | Orange | North Carolina | 37135 | 314 | 40 |
183389 | 183389 | 2020-05-27 | Pamlico | North Carolina | 37137 | 9 | 0 |
183390 | 183390 | 2020-05-27 | Pasquotank | North Carolina | 37139 | 100 | 9 |
183391 | 183391 | 2020-05-27 | Pender | North Carolina | 37141 | 74 | 1 |
183392 | 183392 | 2020-05-27 | Perquimans | North Carolina | 37143 | 23 | 2 |
183393 | 183393 | 2020-05-27 | Person | North Carolina | 37145 | 39 | 1 |
183394 | 183394 | 2020-05-27 | Pitt | North Carolina | 37147 | 267 | 2 |
183395 | 183395 | 2020-05-27 | Polk | North Carolina | 37149 | 35 | 4 |
183396 | 183396 | 2020-05-27 | Randolph | North Carolina | 37151 | 624 | 12 |
183397 | 183397 | 2020-05-27 | Richmond | North Carolina | 37153 | 153 | 2 |
183398 | 183398 | 2020-05-27 | Robeson | North Carolina | 37155 | 737 | 21 |
183399 | 183399 | 2020-05-27 | Rockingham | North Carolina | 37157 | 73 | 2 |
183400 | 183400 | 2020-05-27 | Rowan | North Carolina | 37159 | 613 | 34 |
183401 | 183401 | 2020-05-27 | Rutherford | North Carolina | 37161 | 174 | 7 |
183402 | 183402 | 2020-05-27 | Sampson | North Carolina | 37163 | 408 | 1 |
183403 | 183403 | 2020-05-27 | Scotland | North Carolina | 37165 | 69 | 0 |
183404 | 183404 | 2020-05-27 | Stanly | North Carolina | 37167 | 54 | 4 |
183405 | 183405 | 2020-05-27 | Stokes | North Carolina | 37169 | 58 | 0 |
183406 | 183406 | 2020-05-27 | Surry | North Carolina | 37171 | 173 | 1 |
183407 | 183407 | 2020-05-27 | Swain | North Carolina | 37173 | 10 | 0 |
183408 | 183408 | 2020-05-27 | Transylvania | North Carolina | 37175 | 11 | 0 |
183409 | 183409 | 2020-05-27 | Tyrrell | North Carolina | 37177 | 4 | 0 |
183410 | 183410 | 2020-05-27 | Union | North Carolina | 37179 | 417 | 18 |
183411 | 183411 | 2020-05-27 | Vance | North Carolina | 37181 | 266 | 19 |
183412 | 183412 | 2020-05-27 | Wake | North Carolina | 37183 | 1523 | 36 |
183413 | 183413 | 2020-05-27 | Warren | North Carolina | 37185 | 54 | 1 |
183414 | 183414 | 2020-05-27 | Washington | North Carolina | 37187 | 27 | 3 |
183415 | 183415 | 2020-05-27 | Watauga | North Carolina | 37189 | 14 | 0 |
183416 | 183416 | 2020-05-27 | Wayne | North Carolina | 37191 | 1045 | 20 |
183417 | 183417 | 2020-05-27 | Wilkes | North Carolina | 37193 | 483 | 3 |
183418 | 183418 | 2020-05-27 | Wilson | North Carolina | 37195 | 325 | 9 |
183419 | 183419 | 2020-05-27 | Yadkin | North Carolina | 37197 | 149 | 2 |
183420 | 183420 | 2020-05-27 | Yancey | North Carolina | 37199 | 10 | 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);