ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46,970
- Georgia 32,409
- Virginia 26,379
- Kentucky 23,212
- Missouri 22,090
- North Carolina 20,108
- Illinois 20,052
- Tennessee 19,340
- Iowa 19,270
- Indiana 18,710
- Kansas 18,386
- Ohio 17,890
- Minnesota 17,107
- Mississippi 16,775
- Michigan 16,734
- Nebraska 15,216
- Arkansas 15,104
- Oklahoma 14,918
- Wisconsin 14,440
- Florida 14,058
- Pennsylvania 13,782
- Alabama 13,586
- Louisiana 13,341
- Puerto Rico 12,814
- Colorado 12,535
- New York 12,226
- California 12,161
- South Dakota 11,470
- West Virginia 10,501
- South Carolina 9,549
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
626328 | 626328 | 2020-10-13 | Vermilion | Louisiana | 22113 | 2076 | 68 |
626329 | 626329 | 2020-10-13 | Vernon | Louisiana | 22115 | 1104 | 52 |
626330 | 626330 | 2020-10-13 | Washington | Louisiana | 22117 | 1699 | 68 |
626331 | 626331 | 2020-10-13 | Webster | Louisiana | 22119 | 1381 | 32 |
626332 | 626332 | 2020-10-13 | West Baton Rouge | Louisiana | 22121 | 936 | 42 |
626333 | 626333 | 2020-10-13 | West Carroll | Louisiana | 22123 | 358 | 10 |
626334 | 626334 | 2020-10-13 | West Feliciana | Louisiana | 22125 | 743 | 25 |
626335 | 626335 | 2020-10-13 | Winn | Louisiana | 22127 | 657 | 19 |
626336 | 626336 | 2020-10-13 | Androscoggin | Maine | 23001 | 817 | 10 |
626337 | 626337 | 2020-10-13 | Aroostook | Maine | 23003 | 53 | 1 |
626338 | 626338 | 2020-10-13 | Cumberland | Maine | 23005 | 2392 | 70 |
626339 | 626339 | 2020-10-13 | Franklin | Maine | 23007 | 72 | 1 |
626340 | 626340 | 2020-10-13 | Hancock | Maine | 23009 | 56 | 1 |
626341 | 626341 | 2020-10-13 | Kennebec | Maine | 23011 | 268 | 11 |
626342 | 626342 | 2020-10-13 | Knox | Maine | 23013 | 52 | 1 |
626343 | 626343 | 2020-10-13 | Lincoln | Maine | 23015 | 50 | 1 |
626344 | 626344 | 2020-10-13 | Oxford | Maine | 23017 | 158 | 2 |
626345 | 626345 | 2020-10-13 | Penobscot | Maine | 23019 | 271 | 6 |
626346 | 626346 | 2020-10-13 | Piscataquis | Maine | 23021 | 10 | 0 |
626347 | 626347 | 2020-10-13 | Sagadahoc | Maine | 23023 | 74 | 0 |
626348 | 626348 | 2020-10-13 | Somerset | Maine | 23025 | 123 | 8 |
626349 | 626349 | 2020-10-13 | Waldo | Maine | 23027 | 80 | 14 |
626350 | 626350 | 2020-10-13 | Washington | Maine | 23029 | 20 | 0 |
626351 | 626351 | 2020-10-13 | York | Maine | 23031 | 1284 | 17 |
626352 | 626352 | 2020-10-13 | Allegany | Maryland | 24001 | 528 | 23 |
626353 | 626353 | 2020-10-13 | Anne Arundel | Maryland | 24003 | 10927 | 258 |
626354 | 626354 | 2020-10-13 | Baltimore | Maryland | 24005 | 19125 | 647 |
626355 | 626355 | 2020-10-13 | Baltimore city | Maryland | 24510 | 16560 | 494 |
626356 | 626356 | 2020-10-13 | Calvert | Maryland | 24009 | 1075 | 28 |
626357 | 626357 | 2020-10-13 | Caroline | Maryland | 24011 | 684 | 8 |
626358 | 626358 | 2020-10-13 | Carroll | Maryland | 24013 | 2095 | 126 |
626359 | 626359 | 2020-10-13 | Cecil | Maryland | 24015 | 1180 | 36 |
626360 | 626360 | 2020-10-13 | Charles | Maryland | 24017 | 2949 | 101 |
626361 | 626361 | 2020-10-13 | Dorchester | Maryland | 24019 | 642 | 10 |
626362 | 626362 | 2020-10-13 | Frederick | Maryland | 24021 | 4387 | 135 |
626363 | 626363 | 2020-10-13 | Garrett | Maryland | 24023 | 82 | 1 |
626364 | 626364 | 2020-10-13 | Harford | Maryland | 24025 | 3292 | 77 |
626365 | 626365 | 2020-10-13 | Howard | Maryland | 24027 | 5479 | 123 |
626366 | 626366 | 2020-10-13 | Kent | Maryland | 24029 | 327 | 24 |
626367 | 626367 | 2020-10-13 | Montgomery | Maryland | 24031 | 23857 | 856 |
626368 | 626368 | 2020-10-13 | Prince George's | Maryland | 24033 | 31253 | 839 |
626369 | 626369 | 2020-10-13 | Queen Anne's | Maryland | 24035 | 706 | 26 |
626370 | 626370 | 2020-10-13 | Somerset | Maryland | 24039 | 345 | 4 |
626371 | 626371 | 2020-10-13 | St. Mary's | Maryland | 24037 | 1373 | 59 |
626372 | 626372 | 2020-10-13 | Talbot | Maryland | 24041 | 589 | 6 |
626373 | 626373 | 2020-10-13 | Unknown | Maryland | 0 | 11 | |
626374 | 626374 | 2020-10-13 | Washington | Maryland | 24043 | 2008 | 41 |
626375 | 626375 | 2020-10-13 | Wicomico | Maryland | 24045 | 2242 | 49 |
626376 | 626376 | 2020-10-13 | Worcester | Maryland | 24047 | 1134 | 30 |
626377 | 626377 | 2020-10-13 | Barnstable | Massachusetts | 25001 | 1878 | 178 |
626378 | 626378 | 2020-10-13 | Berkshire | Massachusetts | 25003 | 732 | 51 |
626379 | 626379 | 2020-10-13 | Bristol | Massachusetts | 25005 | 10739 | 725 |
626380 | 626380 | 2020-10-13 | Dukes | Massachusetts | 25007 | 70 | 0 |
626381 | 626381 | 2020-10-13 | Essex | Massachusetts | 25009 | 21380 | 1313 |
626382 | 626382 | 2020-10-13 | Franklin | Massachusetts | 25011 | 426 | 71 |
626383 | 626383 | 2020-10-13 | Hampden | Massachusetts | 25013 | 8854 | 792 |
626384 | 626384 | 2020-10-13 | Hampshire | Massachusetts | 25015 | 1364 | 150 |
626385 | 626385 | 2020-10-13 | Middlesex | Massachusetts | 25017 | 29358 | 2196 |
626386 | 626386 | 2020-10-13 | Nantucket | Massachusetts | 25019 | 131 | 1 |
626387 | 626387 | 2020-10-13 | Norfolk | Massachusetts | 25021 | 10942 | 1084 |
626388 | 626388 | 2020-10-13 | Plymouth | Massachusetts | 25023 | 10380 | 784 |
626389 | 626389 | 2020-10-13 | Suffolk | Massachusetts | 25025 | 25824 | 1148 |
626390 | 626390 | 2020-10-13 | Unknown | Massachusetts | 3145 | 6 | |
626391 | 626391 | 2020-10-13 | Worcester | Massachusetts | 25027 | 15189 | 1131 |
626392 | 626392 | 2020-10-13 | Alcona | Michigan | 26001 | 48 | 2 |
626393 | 626393 | 2020-10-13 | Alger | Michigan | 26003 | 64 | 0 |
626394 | 626394 | 2020-10-13 | Allegan | Michigan | 26005 | 943 | 7 |
626395 | 626395 | 2020-10-13 | Alpena | Michigan | 26007 | 148 | 14 |
626396 | 626396 | 2020-10-13 | Antrim | Michigan | 26009 | 82 | 0 |
626397 | 626397 | 2020-10-13 | Arenac | Michigan | 26011 | 82 | 3 |
626398 | 626398 | 2020-10-13 | Baraga | Michigan | 26013 | 58 | 3 |
626399 | 626399 | 2020-10-13 | Barry | Michigan | 26015 | 457 | 5 |
626400 | 626400 | 2020-10-13 | Bay | Michigan | 26017 | 1151 | 55 |
626401 | 626401 | 2020-10-13 | Benzie | Michigan | 26019 | 95 | 2 |
626402 | 626402 | 2020-10-13 | Berrien | Michigan | 26021 | 2219 | 77 |
626403 | 626403 | 2020-10-13 | Branch | Michigan | 26023 | 1534 | 33 |
626404 | 626404 | 2020-10-13 | Calhoun | Michigan | 26025 | 1940 | 51 |
626405 | 626405 | 2020-10-13 | Cass | Michigan | 26027 | 710 | 22 |
626406 | 626406 | 2020-10-13 | Charlevoix | Michigan | 26029 | 127 | 4 |
626407 | 626407 | 2020-10-13 | Cheboygan | Michigan | 26031 | 101 | 2 |
626408 | 626408 | 2020-10-13 | Chippewa | Michigan | 26033 | 97 | 0 |
626409 | 626409 | 2020-10-13 | Clare | Michigan | 26035 | 169 | 6 |
626410 | 626410 | 2020-10-13 | Clinton | Michigan | 26037 | 815 | 14 |
626411 | 626411 | 2020-10-13 | Crawford | Michigan | 26039 | 132 | 5 |
626412 | 626412 | 2020-10-13 | Delta | Michigan | 26041 | 849 | 15 |
626413 | 626413 | 2020-10-13 | Dickinson | Michigan | 26043 | 342 | 4 |
626414 | 626414 | 2020-10-13 | Eaton | Michigan | 26045 | 838 | 10 |
626415 | 626415 | 2020-10-13 | Emmet | Michigan | 26047 | 180 | 4 |
626416 | 626416 | 2020-10-13 | Genesee | Michigan | 26049 | 5465 | 314 |
626417 | 626417 | 2020-10-13 | Gladwin | Michigan | 26051 | 135 | 2 |
626418 | 626418 | 2020-10-13 | Gogebic | Michigan | 26053 | 200 | 2 |
626419 | 626419 | 2020-10-13 | Grand Traverse | Michigan | 26055 | 602 | 11 |
626420 | 626420 | 2020-10-13 | Gratiot | Michigan | 26057 | 372 | 16 |
626421 | 626421 | 2020-10-13 | Hillsdale | Michigan | 26059 | 400 | 27 |
626422 | 626422 | 2020-10-13 | Houghton | Michigan | 26061 | 809 | 5 |
626423 | 626423 | 2020-10-13 | Huron | Michigan | 26063 | 248 | 5 |
626424 | 626424 | 2020-10-13 | Ingham | Michigan | 26065 | 4086 | 55 |
626425 | 626425 | 2020-10-13 | Ionia | Michigan | 26067 | 660 | 8 |
626426 | 626426 | 2020-10-13 | Iosco | Michigan | 26069 | 251 | 14 |
626427 | 626427 | 2020-10-13 | Iron | Michigan | 26071 | 302 | 15 |
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);