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: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1051600 | 1051600 | 2021-02-21 | Clearwater | Minnesota | 27029 | 709 | 14 |
1051601 | 1051601 | 2021-02-21 | Cook | Minnesota | 27031 | 119 | 0 |
1051602 | 1051602 | 2021-02-21 | Cottonwood | Minnesota | 27033 | 1332 | 20 |
1051603 | 1051603 | 2021-02-21 | Crow Wing | Minnesota | 27035 | 5134 | 80 |
1051604 | 1051604 | 2021-02-21 | Dakota | Minnesota | 27037 | 35610 | 383 |
1051605 | 1051605 | 2021-02-21 | Dodge | Minnesota | 27039 | 1510 | 4 |
1051606 | 1051606 | 2021-02-21 | Douglas | Minnesota | 27041 | 3895 | 68 |
1051607 | 1051607 | 2021-02-21 | Faribault | Minnesota | 27043 | 1209 | 16 |
1051608 | 1051608 | 2021-02-21 | Fillmore | Minnesota | 27045 | 1362 | 8 |
1051609 | 1051609 | 2021-02-21 | Freeborn | Minnesota | 27047 | 2755 | 23 |
1051610 | 1051610 | 2021-02-21 | Goodhue | Minnesota | 27049 | 3817 | 68 |
1051611 | 1051611 | 2021-02-21 | Grant | Minnesota | 27051 | 481 | 8 |
1051612 | 1051612 | 2021-02-21 | Hennepin | Minnesota | 27053 | 99347 | 1576 |
1051613 | 1051613 | 2021-02-21 | Houston | Minnesota | 27055 | 1559 | 14 |
1051614 | 1051614 | 2021-02-21 | Hubbard | Minnesota | 27057 | 1595 | 40 |
1051615 | 1051615 | 2021-02-21 | Isanti | Minnesota | 27059 | 3029 | 52 |
1051616 | 1051616 | 2021-02-21 | Itasca | Minnesota | 27061 | 3071 | 45 |
1051617 | 1051617 | 2021-02-21 | Jackson | Minnesota | 27063 | 920 | 10 |
1051618 | 1051618 | 2021-02-21 | Kanabec | Minnesota | 27065 | 1064 | 19 |
1051619 | 1051619 | 2021-02-21 | Kandiyohi | Minnesota | 27067 | 5756 | 74 |
1051620 | 1051620 | 2021-02-21 | Kittson | Minnesota | 27069 | 404 | 21 |
1051621 | 1051621 | 2021-02-21 | Koochiching | Minnesota | 27071 | 617 | 11 |
1051622 | 1051622 | 2021-02-21 | Lac qui Parle | Minnesota | 27073 | 679 | 16 |
1051623 | 1051623 | 2021-02-21 | Lake | Minnesota | 27075 | 719 | 17 |
1051624 | 1051624 | 2021-02-21 | Lake of the Woods | Minnesota | 27077 | 212 | 1 |
1051625 | 1051625 | 2021-02-21 | Le Sueur | Minnesota | 27079 | 2300 | 20 |
1051626 | 1051626 | 2021-02-21 | Lincoln | Minnesota | 27081 | 502 | 2 |
1051627 | 1051627 | 2021-02-21 | Lyon | Minnesota | 27083 | 3111 | 43 |
1051628 | 1051628 | 2021-02-21 | Mahnomen | Minnesota | 27087 | 434 | 7 |
1051629 | 1051629 | 2021-02-21 | Marshall | Minnesota | 27089 | 764 | 15 |
1051630 | 1051630 | 2021-02-21 | Martin | Minnesota | 27091 | 1860 | 28 |
1051631 | 1051631 | 2021-02-21 | McLeod | Minnesota | 27085 | 3358 | 49 |
1051632 | 1051632 | 2021-02-21 | Meeker | Minnesota | 27093 | 2051 | 34 |
1051633 | 1051633 | 2021-02-21 | Mille Lacs | Minnesota | 27095 | 2249 | 47 |
1051634 | 1051634 | 2021-02-21 | Morrison | Minnesota | 27097 | 3210 | 46 |
1051635 | 1051635 | 2021-02-21 | Mower | Minnesota | 27099 | 3985 | 31 |
1051636 | 1051636 | 2021-02-21 | Murray | Minnesota | 27101 | 940 | 8 |
1051637 | 1051637 | 2021-02-21 | Nicollet | Minnesota | 27103 | 2500 | 41 |
1051638 | 1051638 | 2021-02-21 | Nobles | Minnesota | 27105 | 3846 | 47 |
1051639 | 1051639 | 2021-02-21 | Norman | Minnesota | 27107 | 462 | 8 |
1051640 | 1051640 | 2021-02-21 | Olmsted | Minnesota | 27109 | 11660 | 88 |
1051641 | 1051641 | 2021-02-21 | Otter Tail | Minnesota | 27111 | 4778 | 70 |
1051642 | 1051642 | 2021-02-21 | Pennington | Minnesota | 27113 | 1245 | 16 |
1051643 | 1051643 | 2021-02-21 | Pine | Minnesota | 27115 | 2790 | 16 |
1051644 | 1051644 | 2021-02-21 | Pipestone | Minnesota | 27117 | 1006 | 24 |
1051645 | 1051645 | 2021-02-21 | Polk | Minnesota | 27119 | 3402 | 62 |
1051646 | 1051646 | 2021-02-21 | Pope | Minnesota | 27121 | 786 | 5 |
1051647 | 1051647 | 2021-02-21 | Ramsey | Minnesota | 27123 | 42602 | 794 |
1051648 | 1051648 | 2021-02-21 | Red Lake | Minnesota | 27125 | 351 | 4 |
1051649 | 1051649 | 2021-02-21 | Redwood | Minnesota | 27127 | 1461 | 27 |
1051650 | 1051650 | 2021-02-21 | Renville | Minnesota | 27129 | 1467 | 40 |
1051651 | 1051651 | 2021-02-21 | Rice | Minnesota | 27131 | 6632 | 90 |
1051652 | 1051652 | 2021-02-21 | Rock | Minnesota | 27133 | 1152 | 12 |
1051653 | 1051653 | 2021-02-21 | Roseau | Minnesota | 27135 | 1775 | 17 |
1051654 | 1051654 | 2021-02-21 | Scott | Minnesota | 27139 | 13073 | 104 |
1051655 | 1051655 | 2021-02-21 | Sherburne | Minnesota | 27141 | 8638 | 73 |
1051656 | 1051656 | 2021-02-21 | Sibley | Minnesota | 27143 | 1160 | 10 |
1051657 | 1051657 | 2021-02-21 | St. Louis | Minnesota | 27137 | 14608 | 262 |
1051658 | 1051658 | 2021-02-21 | Stearns | Minnesota | 27145 | 18645 | 200 |
1051659 | 1051659 | 2021-02-21 | Steele | Minnesota | 27147 | 2965 | 11 |
1051660 | 1051660 | 2021-02-21 | Stevens | Minnesota | 27149 | 737 | 8 |
1051661 | 1051661 | 2021-02-21 | Swift | Minnesota | 27151 | 871 | 18 |
1051662 | 1051662 | 2021-02-21 | Todd | Minnesota | 27153 | 2428 | 30 |
1051663 | 1051663 | 2021-02-21 | Traverse | Minnesota | 27155 | 301 | 5 |
1051664 | 1051664 | 2021-02-21 | Unknown | Minnesota | 497 | 68 | |
1051665 | 1051665 | 2021-02-21 | Wabasha | Minnesota | 27157 | 1849 | 3 |
1051666 | 1051666 | 2021-02-21 | Wadena | Minnesota | 27159 | 1277 | 20 |
1051667 | 1051667 | 2021-02-21 | Waseca | Minnesota | 27161 | 2057 | 17 |
1051668 | 1051668 | 2021-02-21 | Washington | Minnesota | 27163 | 21769 | 253 |
1051669 | 1051669 | 2021-02-21 | Watonwan | Minnesota | 27165 | 1140 | 8 |
1051670 | 1051670 | 2021-02-21 | Wilkin | Minnesota | 27167 | 660 | 10 |
1051671 | 1051671 | 2021-02-21 | Winona | Minnesota | 27169 | 4133 | 48 |
1051672 | 1051672 | 2021-02-21 | Wright | Minnesota | 27171 | 12379 | 114 |
1051673 | 1051673 | 2021-02-21 | Yellow Medicine | Minnesota | 27173 | 973 | 17 |
1051674 | 1051674 | 2021-02-21 | Adams | Mississippi | 28001 | 2319 | 74 |
1051675 | 1051675 | 2021-02-21 | Alcorn | Mississippi | 28003 | 2895 | 60 |
1051676 | 1051676 | 2021-02-21 | Amite | Mississippi | 28005 | 1102 | 32 |
1051677 | 1051677 | 2021-02-21 | Attala | Mississippi | 28007 | 2056 | 69 |
1051678 | 1051678 | 2021-02-21 | Benton | Mississippi | 28009 | 923 | 24 |
1051679 | 1051679 | 2021-02-21 | Bolivar | Mississippi | 28011 | 4564 | 120 |
1051680 | 1051680 | 2021-02-21 | Calhoun | Mississippi | 28013 | 1551 | 27 |
1051681 | 1051681 | 2021-02-21 | Carroll | Mississippi | 28015 | 1169 | 23 |
1051682 | 1051682 | 2021-02-21 | Chickasaw | Mississippi | 28017 | 2001 | 50 |
1051683 | 1051683 | 2021-02-21 | Choctaw | Mississippi | 28019 | 693 | 16 |
1051684 | 1051684 | 2021-02-21 | Claiborne | Mississippi | 28021 | 973 | 29 |
1051685 | 1051685 | 2021-02-21 | Clarke | Mississippi | 28023 | 1673 | 70 |
1051686 | 1051686 | 2021-02-21 | Clay | Mississippi | 28025 | 1769 | 48 |
1051687 | 1051687 | 2021-02-21 | Coahoma | Mississippi | 28027 | 2722 | 65 |
1051688 | 1051688 | 2021-02-21 | Copiah | Mississippi | 28029 | 2725 | 57 |
1051689 | 1051689 | 2021-02-21 | Covington | Mississippi | 28031 | 2459 | 77 |
1051690 | 1051690 | 2021-02-21 | DeSoto | Mississippi | 28033 | 19415 | 226 |
1051691 | 1051691 | 2021-02-21 | Forrest | Mississippi | 28035 | 7040 | 135 |
1051692 | 1051692 | 2021-02-21 | Franklin | Mississippi | 28037 | 750 | 19 |
1051693 | 1051693 | 2021-02-21 | George | Mississippi | 28039 | 2293 | 45 |
1051694 | 1051694 | 2021-02-21 | Greene | Mississippi | 28041 | 1261 | 33 |
1051695 | 1051695 | 2021-02-21 | Grenada | Mississippi | 28043 | 2440 | 75 |
1051696 | 1051696 | 2021-02-21 | Hancock | Mississippi | 28045 | 3366 | 73 |
1051697 | 1051697 | 2021-02-21 | Harrison | Mississippi | 28047 | 16347 | 269 |
1051698 | 1051698 | 2021-02-21 | Hinds | Mississippi | 28049 | 18532 | 382 |
1051699 | 1051699 | 2021-02-21 | Holmes | Mississippi | 28051 | 1803 | 69 |
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);