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-07-19 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 |
---|---|---|---|---|---|---|---|
349298 | 349298 | 2020-07-19 | Alamance | North Carolina | 37001 | 1684 | 39 |
349299 | 349299 | 2020-07-19 | Alexander | North Carolina | 37003 | 213 | 1 |
349300 | 349300 | 2020-07-19 | Alleghany | North Carolina | 37005 | 53 | 0 |
349301 | 349301 | 2020-07-19 | Anson | North Carolina | 37007 | 260 | 1 |
349302 | 349302 | 2020-07-19 | Ashe | North Carolina | 37009 | 73 | 1 |
349303 | 349303 | 2020-07-19 | Avery | North Carolina | 37011 | 42 | 0 |
349304 | 349304 | 2020-07-19 | Beaufort | North Carolina | 37013 | 197 | 0 |
349305 | 349305 | 2020-07-19 | Bertie | North Carolina | 37015 | 178 | 4 |
349306 | 349306 | 2020-07-19 | Bladen | North Carolina | 37017 | 485 | 5 |
349307 | 349307 | 2020-07-19 | Brunswick | North Carolina | 37019 | 943 | 13 |
349308 | 349308 | 2020-07-19 | Buncombe | North Carolina | 37021 | 1140 | 50 |
349309 | 349309 | 2020-07-19 | Burke | North Carolina | 37023 | 1315 | 22 |
349310 | 349310 | 2020-07-19 | Cabarrus | North Carolina | 37025 | 1949 | 34 |
349311 | 349311 | 2020-07-19 | Caldwell | North Carolina | 37027 | 771 | 6 |
349312 | 349312 | 2020-07-19 | Camden | North Carolina | 37029 | 45 | 2 |
349313 | 349313 | 2020-07-19 | Carteret | North Carolina | 37031 | 176 | 4 |
349314 | 349314 | 2020-07-19 | Caswell | North Carolina | 37033 | 167 | 2 |
349315 | 349315 | 2020-07-19 | Catawba | North Carolina | 37035 | 1469 | 14 |
349316 | 349316 | 2020-07-19 | Chatham | North Carolina | 37037 | 1106 | 47 |
349317 | 349317 | 2020-07-19 | Cherokee | North Carolina | 37039 | 118 | 2 |
349318 | 349318 | 2020-07-19 | Chowan | North Carolina | 37041 | 51 | 0 |
349319 | 349319 | 2020-07-19 | Clay | North Carolina | 37043 | 31 | 0 |
349320 | 349320 | 2020-07-19 | Cleveland | North Carolina | 37045 | 671 | 10 |
349321 | 349321 | 2020-07-19 | Columbus | North Carolina | 37047 | 713 | 39 |
349322 | 349322 | 2020-07-19 | Craven | North Carolina | 37049 | 509 | 8 |
349323 | 349323 | 2020-07-19 | Cumberland | North Carolina | 37051 | 1917 | 46 |
349324 | 349324 | 2020-07-19 | Currituck | North Carolina | 37053 | 48 | 0 |
349325 | 349325 | 2020-07-19 | Dare | North Carolina | 37055 | 145 | 1 |
349326 | 349326 | 2020-07-19 | Davidson | North Carolina | 37057 | 1414 | 16 |
349327 | 349327 | 2020-07-19 | Davie | North Carolina | 37059 | 275 | 3 |
349328 | 349328 | 2020-07-19 | Duplin | North Carolina | 37061 | 1766 | 33 |
349329 | 349329 | 2020-07-19 | Durham | North Carolina | 37063 | 5072 | 73 |
349330 | 349330 | 2020-07-19 | Edgecombe | North Carolina | 37065 | 440 | 10 |
349331 | 349331 | 2020-07-19 | Forsyth | North Carolina | 37067 | 4196 | 41 |
349332 | 349332 | 2020-07-19 | Franklin | North Carolina | 37069 | 591 | 23 |
349333 | 349333 | 2020-07-19 | Gaston | North Carolina | 37071 | 2267 | 19 |
349334 | 349334 | 2020-07-19 | Gates | North Carolina | 37073 | 32 | 2 |
349335 | 349335 | 2020-07-19 | Graham | North Carolina | 37075 | 10 | 0 |
349336 | 349336 | 2020-07-19 | Granville | North Carolina | 37077 | 1030 | 25 |
349337 | 349337 | 2020-07-19 | Greene | North Carolina | 37079 | 252 | 3 |
349338 | 349338 | 2020-07-19 | Guilford | North Carolina | 37081 | 4127 | 133 |
349339 | 349339 | 2020-07-19 | Halifax | North Carolina | 37083 | 474 | 4 |
349340 | 349340 | 2020-07-19 | Harnett | North Carolina | 37085 | 880 | 32 |
349341 | 349341 | 2020-07-19 | Haywood | North Carolina | 37087 | 171 | 0 |
349342 | 349342 | 2020-07-19 | Henderson | North Carolina | 37089 | 1098 | 52 |
349343 | 349343 | 2020-07-19 | Hertford | North Carolina | 37091 | 195 | 11 |
349344 | 349344 | 2020-07-19 | Hoke | North Carolina | 37093 | 540 | 5 |
349345 | 349345 | 2020-07-19 | Hyde | North Carolina | 37095 | 33 | 0 |
349346 | 349346 | 2020-07-19 | Iredell | North Carolina | 37097 | 1334 | 11 |
349347 | 349347 | 2020-07-19 | Jackson | North Carolina | 37099 | 279 | 3 |
349348 | 349348 | 2020-07-19 | Johnston | North Carolina | 37101 | 2386 | 39 |
349349 | 349349 | 2020-07-19 | Jones | North Carolina | 37103 | 43 | 3 |
349350 | 349350 | 2020-07-19 | Lee | North Carolina | 37105 | 990 | 8 |
349351 | 349351 | 2020-07-19 | Lenoir | North Carolina | 37107 | 451 | 11 |
349352 | 349352 | 2020-07-19 | Lincoln | North Carolina | 37109 | 547 | 2 |
349353 | 349353 | 2020-07-19 | Macon | North Carolina | 37113 | 381 | 1 |
349354 | 349354 | 2020-07-19 | Madison | North Carolina | 37115 | 22 | 0 |
349355 | 349355 | 2020-07-19 | Martin | North Carolina | 37117 | 184 | 6 |
349356 | 349356 | 2020-07-19 | McDowell | North Carolina | 37111 | 373 | 3 |
349357 | 349357 | 2020-07-19 | Mecklenburg | North Carolina | 37119 | 17379 | 179 |
349358 | 349358 | 2020-07-19 | Mitchell | North Carolina | 37121 | 60 | 1 |
349359 | 349359 | 2020-07-19 | Montgomery | North Carolina | 37123 | 452 | 10 |
349360 | 349360 | 2020-07-19 | Moore | North Carolina | 37125 | 708 | 14 |
349361 | 349361 | 2020-07-19 | Nash | North Carolina | 37127 | 755 | 6 |
349362 | 349362 | 2020-07-19 | New Hanover | North Carolina | 37129 | 1779 | 11 |
349363 | 349363 | 2020-07-19 | Northampton | North Carolina | 37131 | 233 | 16 |
349364 | 349364 | 2020-07-19 | Onslow | North Carolina | 37133 | 558 | 6 |
349365 | 349365 | 2020-07-19 | Orange | North Carolina | 37135 | 1102 | 45 |
349366 | 349366 | 2020-07-19 | Pamlico | North Carolina | 37137 | 43 | 1 |
349367 | 349367 | 2020-07-19 | Pasquotank | North Carolina | 37139 | 267 | 17 |
349368 | 349368 | 2020-07-19 | Pender | North Carolina | 37141 | 473 | 2 |
349369 | 349369 | 2020-07-19 | Perquimans | North Carolina | 37143 | 44 | 2 |
349370 | 349370 | 2020-07-19 | Person | North Carolina | 37145 | 143 | 1 |
349371 | 349371 | 2020-07-19 | Pitt | North Carolina | 37147 | 1173 | 6 |
349372 | 349372 | 2020-07-19 | Polk | North Carolina | 37149 | 114 | 5 |
349373 | 349373 | 2020-07-19 | Randolph | North Carolina | 37151 | 1719 | 34 |
349374 | 349374 | 2020-07-19 | Richmond | North Carolina | 37153 | 400 | 7 |
349375 | 349375 | 2020-07-19 | Robeson | North Carolina | 37155 | 1942 | 46 |
349376 | 349376 | 2020-07-19 | Rockingham | North Carolina | 37157 | 351 | 3 |
349377 | 349377 | 2020-07-19 | Rowan | North Carolina | 37159 | 1700 | 45 |
349378 | 349378 | 2020-07-19 | Rutherford | North Carolina | 37161 | 459 | 12 |
349379 | 349379 | 2020-07-19 | Sampson | North Carolina | 37163 | 1303 | 8 |
349380 | 349380 | 2020-07-19 | Scotland | North Carolina | 37165 | 188 | 2 |
349381 | 349381 | 2020-07-19 | Stanly | North Carolina | 37167 | 657 | 5 |
349382 | 349382 | 2020-07-19 | Stokes | North Carolina | 37169 | 198 | 1 |
349383 | 349383 | 2020-07-19 | Surry | North Carolina | 37171 | 671 | 4 |
349384 | 349384 | 2020-07-19 | Swain | North Carolina | 37173 | 80 | 2 |
349385 | 349385 | 2020-07-19 | Transylvania | North Carolina | 37175 | 84 | 1 |
349386 | 349386 | 2020-07-19 | Tyrrell | North Carolina | 37177 | 65 | 1 |
349387 | 349387 | 2020-07-19 | Union | North Carolina | 37179 | 2190 | 32 |
349388 | 349388 | 2020-07-19 | Vance | North Carolina | 37181 | 623 | 40 |
349389 | 349389 | 2020-07-19 | Wake | North Carolina | 37183 | 8800 | 89 |
349390 | 349390 | 2020-07-19 | Warren | North Carolina | 37185 | 207 | 6 |
349391 | 349391 | 2020-07-19 | Washington | North Carolina | 37187 | 67 | 3 |
349392 | 349392 | 2020-07-19 | Watauga | North Carolina | 37189 | 176 | 0 |
349393 | 349393 | 2020-07-19 | Wayne | North Carolina | 37191 | 2100 | 34 |
349394 | 349394 | 2020-07-19 | Wilkes | North Carolina | 37193 | 657 | 7 |
349395 | 349395 | 2020-07-19 | Wilson | North Carolina | 37195 | 1128 | 28 |
349396 | 349396 | 2020-07-19 | Yadkin | North Carolina | 37197 | 404 | 6 |
349397 | 349397 | 2020-07-19 | Yancey | North Carolina | 37199 | 67 | 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);