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-11-28 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 |
---|---|---|---|---|---|---|---|
776301 | 776301 | 2020-11-28 | Alamance | North Carolina | 37001 | 7097 | 97 |
776302 | 776302 | 2020-11-28 | Alexander | North Carolina | 37003 | 1602 | 17 |
776303 | 776303 | 2020-11-28 | Alleghany | North Carolina | 37005 | 384 | 1 |
776304 | 776304 | 2020-11-28 | Anson | North Carolina | 37007 | 913 | 14 |
776305 | 776305 | 2020-11-28 | Ashe | North Carolina | 37009 | 778 | 3 |
776306 | 776306 | 2020-11-28 | Avery | North Carolina | 37011 | 926 | 8 |
776307 | 776307 | 2020-11-28 | Beaufort | North Carolina | 37013 | 1700 | 54 |
776308 | 776308 | 2020-11-28 | Bertie | North Carolina | 37015 | 893 | 24 |
776309 | 776309 | 2020-11-28 | Bladen | North Carolina | 37017 | 1334 | 19 |
776310 | 776310 | 2020-11-28 | Brunswick | North Carolina | 37019 | 2973 | 58 |
776311 | 776311 | 2020-11-28 | Buncombe | North Carolina | 37021 | 5542 | 140 |
776312 | 776312 | 2020-11-28 | Burke | North Carolina | 37023 | 3895 | 64 |
776313 | 776313 | 2020-11-28 | Cabarrus | North Carolina | 37025 | 6868 | 107 |
776314 | 776314 | 2020-11-28 | Caldwell | North Carolina | 37027 | 3512 | 21 |
776315 | 776315 | 2020-11-28 | Camden | North Carolina | 37029 | 179 | 4 |
776316 | 776316 | 2020-11-28 | Carteret | North Carolina | 37031 | 1713 | 14 |
776317 | 776317 | 2020-11-28 | Caswell | North Carolina | 37033 | 835 | 6 |
776318 | 776318 | 2020-11-28 | Catawba | North Carolina | 37035 | 6774 | 85 |
776319 | 776319 | 2020-11-28 | Chatham | North Carolina | 37037 | 2354 | 65 |
776320 | 776320 | 2020-11-28 | Cherokee | North Carolina | 37039 | 928 | 15 |
776321 | 776321 | 2020-11-28 | Chowan | North Carolina | 37041 | 622 | 18 |
776322 | 776322 | 2020-11-28 | Clay | North Carolina | 37043 | 278 | 5 |
776323 | 776323 | 2020-11-28 | Cleveland | North Carolina | 37045 | 4242 | 108 |
776324 | 776324 | 2020-11-28 | Columbus | North Carolina | 37047 | 2735 | 71 |
776325 | 776325 | 2020-11-28 | Craven | North Carolina | 37049 | 3115 | 69 |
776326 | 776326 | 2020-11-28 | Cumberland | North Carolina | 37051 | 9343 | 115 |
776327 | 776327 | 2020-11-28 | Currituck | North Carolina | 37053 | 324 | 5 |
776328 | 776328 | 2020-11-28 | Dare | North Carolina | 37055 | 639 | 4 |
776329 | 776329 | 2020-11-28 | Davidson | North Carolina | 37057 | 5238 | 51 |
776330 | 776330 | 2020-11-28 | Davie | North Carolina | 37059 | 1219 | 13 |
776331 | 776331 | 2020-11-28 | Duplin | North Carolina | 37061 | 3333 | 61 |
776332 | 776332 | 2020-11-28 | Durham | North Carolina | 37063 | 11308 | 113 |
776333 | 776333 | 2020-11-28 | Edgecombe | North Carolina | 37065 | 2523 | 71 |
776334 | 776334 | 2020-11-28 | Forsyth | North Carolina | 37067 | 13074 | 164 |
776335 | 776335 | 2020-11-28 | Franklin | North Carolina | 37069 | 1984 | 33 |
776336 | 776336 | 2020-11-28 | Gaston | North Carolina | 37071 | 10109 | 181 |
776337 | 776337 | 2020-11-28 | Gates | North Carolina | 37073 | 212 | 6 |
776338 | 776338 | 2020-11-28 | Graham | North Carolina | 37075 | 273 | 11 |
776339 | 776339 | 2020-11-28 | Granville | North Carolina | 37077 | 2525 | 57 |
776340 | 776340 | 2020-11-28 | Greene | North Carolina | 37079 | 1187 | 25 |
776341 | 776341 | 2020-11-28 | Guilford | North Carolina | 37081 | 16509 | 239 |
776342 | 776342 | 2020-11-28 | Halifax | North Carolina | 37083 | 1963 | 36 |
776343 | 776343 | 2020-11-28 | Harnett | North Carolina | 37085 | 3931 | 77 |
776344 | 776344 | 2020-11-28 | Haywood | North Carolina | 37087 | 1153 | 40 |
776345 | 776345 | 2020-11-28 | Henderson | North Carolina | 37089 | 3133 | 73 |
776346 | 776346 | 2020-11-28 | Hertford | North Carolina | 37091 | 982 | 41 |
776347 | 776347 | 2020-11-28 | Hoke | North Carolina | 37093 | 1946 | 31 |
776348 | 776348 | 2020-11-28 | Hyde | North Carolina | 37095 | 185 | 5 |
776349 | 776349 | 2020-11-28 | Iredell | North Carolina | 37097 | 5476 | 50 |
776350 | 776350 | 2020-11-28 | Jackson | North Carolina | 37099 | 1385 | 8 |
776351 | 776351 | 2020-11-28 | Johnston | North Carolina | 37101 | 7668 | 78 |
776352 | 776352 | 2020-11-28 | Jones | North Carolina | 37103 | 274 | 15 |
776353 | 776353 | 2020-11-28 | Lee | North Carolina | 37105 | 2473 | 30 |
776354 | 776354 | 2020-11-28 | Lenoir | North Carolina | 37107 | 2130 | 52 |
776355 | 776355 | 2020-11-28 | Lincoln | North Carolina | 37109 | 3395 | 20 |
776356 | 776356 | 2020-11-28 | Macon | North Carolina | 37113 | 935 | 9 |
776357 | 776357 | 2020-11-28 | Madison | North Carolina | 37115 | 516 | 17 |
776358 | 776358 | 2020-11-28 | Martin | North Carolina | 37117 | 831 | 21 |
776359 | 776359 | 2020-11-28 | McDowell | North Carolina | 37111 | 1843 | 34 |
776360 | 776360 | 2020-11-28 | Mecklenburg | North Carolina | 37119 | 42933 | 445 |
776361 | 776361 | 2020-11-28 | Mitchell | North Carolina | 37121 | 517 | 6 |
776362 | 776362 | 2020-11-28 | Montgomery | North Carolina | 37123 | 1388 | 41 |
776363 | 776363 | 2020-11-28 | Moore | North Carolina | 37125 | 2883 | 65 |
776364 | 776364 | 2020-11-28 | Nash | North Carolina | 37127 | 4396 | 108 |
776365 | 776365 | 2020-11-28 | New Hanover | North Carolina | 37129 | 6889 | 53 |
776366 | 776366 | 2020-11-28 | Northampton | North Carolina | 37131 | 818 | 25 |
776367 | 776367 | 2020-11-28 | Onslow | North Carolina | 37133 | 5251 | 41 |
776368 | 776368 | 2020-11-28 | Orange | North Carolina | 37135 | 3863 | 62 |
776369 | 776369 | 2020-11-28 | Pamlico | North Carolina | 37137 | 402 | 3 |
776370 | 776370 | 2020-11-28 | Pasquotank | North Carolina | 37139 | 1085 | 35 |
776371 | 776371 | 2020-11-28 | Pender | North Carolina | 37141 | 1887 | 17 |
776372 | 776372 | 2020-11-28 | Perquimans | North Carolina | 37143 | 334 | 4 |
776373 | 776373 | 2020-11-28 | Person | North Carolina | 37145 | 975 | 11 |
776374 | 776374 | 2020-11-28 | Pitt | North Carolina | 37147 | 7816 | 48 |
776375 | 776375 | 2020-11-28 | Polk | North Carolina | 37149 | 474 | 13 |
776376 | 776376 | 2020-11-28 | Randolph | North Carolina | 37151 | 5313 | 82 |
776377 | 776377 | 2020-11-28 | Richmond | North Carolina | 37153 | 1846 | 38 |
776378 | 776378 | 2020-11-28 | Robeson | North Carolina | 37155 | 7351 | 110 |
776379 | 776379 | 2020-11-28 | Rockingham | North Carolina | 37157 | 3063 | 22 |
776380 | 776380 | 2020-11-28 | Rowan | North Carolina | 37159 | 5623 | 131 |
776381 | 776381 | 2020-11-28 | Rutherford | North Carolina | 37161 | 2401 | 85 |
776382 | 776382 | 2020-11-28 | Sampson | North Carolina | 37163 | 3627 | 43 |
776383 | 776383 | 2020-11-28 | Scotland | North Carolina | 37165 | 1949 | 39 |
776384 | 776384 | 2020-11-28 | Stanly | North Carolina | 37167 | 2945 | 78 |
776385 | 776385 | 2020-11-28 | Stokes | North Carolina | 37169 | 1151 | 16 |
776386 | 776386 | 2020-11-28 | Surry | North Carolina | 37171 | 2755 | 44 |
776387 | 776387 | 2020-11-28 | Swain | North Carolina | 37173 | 396 | 5 |
776388 | 776388 | 2020-11-28 | Transylvania | North Carolina | 37175 | 547 | 9 |
776389 | 776389 | 2020-11-28 | Tyrrell | North Carolina | 37177 | 140 | 3 |
776390 | 776390 | 2020-11-28 | Union | North Carolina | 37179 | 7707 | 73 |
776391 | 776391 | 2020-11-28 | Vance | North Carolina | 37181 | 1732 | 55 |
776392 | 776392 | 2020-11-28 | Wake | North Carolina | 37183 | 28745 | 289 |
776393 | 776393 | 2020-11-28 | Warren | North Carolina | 37185 | 653 | 8 |
776394 | 776394 | 2020-11-28 | Washington | North Carolina | 37187 | 312 | 8 |
776395 | 776395 | 2020-11-28 | Watauga | North Carolina | 37189 | 1843 | 6 |
776396 | 776396 | 2020-11-28 | Wayne | North Carolina | 37191 | 5728 | 112 |
776397 | 776397 | 2020-11-28 | Wilkes | North Carolina | 37193 | 2634 | 50 |
776398 | 776398 | 2020-11-28 | Wilson | North Carolina | 37195 | 4004 | 77 |
776399 | 776399 | 2020-11-28 | Yadkin | North Carolina | 37197 | 1517 | 14 |
776400 | 776400 | 2020-11-28 | Yancey | North Carolina | 37199 | 550 | 2 |
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);