ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where cases = 3073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 11
- Minnesota 10
- Mississippi 7
- Virginia 7
- Arkansas 6
- California 6
- Colorado 6
- Georgia 6
- Indiana 6
- New York 6
- Illinois 5
- Michigan 5
- Ohio 5
- Idaho 4
- Louisiana 4
- Missouri 4
- Wisconsin 4
- Kentucky 3
- New Mexico 3
- North Carolina 3
- Oklahoma 3
- Oregon 3
- Pennsylvania 3
- Puerto Rico 3
- Texas 3
- West Virginia 3
- Alabama 2
- Iowa 2
- South Carolina 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460696 | 2460696 | 2022-05-01 | Mariposa | California | 6043 | 3073 | 34 |
2457440 | 2457440 | 2022-04-30 | Mariposa | California | 6043 | 3073 | 34 |
2454184 | 2454184 | 2022-04-29 | Mariposa | California | 6043 | 3073 | 34 |
2403221 | 2403221 | 2022-04-13 | Chippewa | Minnesota | 27023 | 3073 | 48 |
2399967 | 2399967 | 2022-04-12 | Chippewa | Minnesota | 27023 | 3073 | 48 |
2396711 | 2396711 | 2022-04-11 | Chippewa | Minnesota | 27023 | 3073 | 48 |
2260589 | 2260589 | 2022-02-28 | Torrance | New Mexico | 35057 | 3073 | 50 |
2203258 | 2203258 | 2022-02-10 | Rockbridge | Virginia | 51163 | 3073 | 73 |
2194960 | 2194960 | 2022-02-08 | Arenac | Michigan | 26011 | 3073 | 61 |
2191706 | 2191706 | 2022-02-07 | Arenac | Michigan | 26011 | 3073 | 61 |
2186329 | 2186329 | 2022-02-05 | Loiza | Puerto Rico | 72087 | 3073 | |
2179022 | 2179022 | 2022-02-03 | Osage | Missouri | 29151 | 3073 | 39 |
2180120 | 2180120 | 2022-02-03 | Comanche | Texas | 48093 | 3073 | 72 |
2170897 | 2170897 | 2022-01-31 | Price | Wisconsin | 55099 | 3073 | 28 |
2158523 | 2158523 | 2022-01-28 | Unknown | Idaho | 3073 | 33 | |
2160022 | 2160022 | 2022-01-28 | Harrison | Ohio | 39067 | 3073 | 65 |
2155687 | 2155687 | 2022-01-27 | Butler | Kentucky | 21031 | 3073 | 46 |
2122093 | 2122093 | 2022-01-16 | Richland | Wisconsin | 55103 | 3073 | 38 |
2118841 | 2118841 | 2022-01-15 | Richland | Wisconsin | 55103 | 3073 | 38 |
2115589 | 2115589 | 2022-01-14 | Richland | Wisconsin | 55103 | 3073 | 38 |
2102761 | 2102761 | 2022-01-11 | Franklin | Arkansas | 5047 | 3073 | 61 |
2060527 | 2060527 | 2021-12-29 | Polk | Arkansas | 5113 | 3073 | 126 |
2061930 | 2061930 | 2021-12-29 | Morgan | Missouri | 29141 | 3073 | 75 |
2060053 | 2060053 | 2021-12-28 | Buchanan | Virginia | 51027 | 3073 | 85 |
2051311 | 2051311 | 2021-12-26 | White | Illinois | 17193 | 3073 | 43 |
2048061 | 2048061 | 2021-12-25 | White | Illinois | 17193 | 3073 | 43 |
2044811 | 2044811 | 2021-12-24 | White | Illinois | 17193 | 3073 | 43 |
2041562 | 2041562 | 2021-12-23 | White | Illinois | 17193 | 3073 | 43 |
2015348 | 2015348 | 2021-12-15 | Meriwether | Georgia | 13199 | 3073 | 121 |
2011458 | 2011458 | 2021-12-13 | Barbour | West Virginia | 54001 | 3073 | 53 |
1998734 | 1998734 | 2021-12-10 | Cross | Arkansas | 5037 | 3073 | 69 |
1996443 | 1996443 | 2021-12-09 | Morgan | Kentucky | 21175 | 3073 | 16 |
1984958 | 1984958 | 2021-12-05 | Sequatchie | Tennessee | 47153 | 3073 | 39 |
1981708 | 1981708 | 2021-12-04 | Sequatchie | Tennessee | 47153 | 3073 | 39 |
1978458 | 1978458 | 2021-12-03 | Sequatchie | Tennessee | 47153 | 3073 | 39 |
1944740 | 1944740 | 2021-11-23 | Roseau | Minnesota | 27135 | 3073 | 31 |
1904651 | 1904651 | 2021-11-11 | Teller | Colorado | 8119 | 3073 | 38 |
1890464 | 1890464 | 2021-11-06 | Humacao | Puerto Rico | 72069 | 3073 | |
1877334 | 1877334 | 2021-11-02 | Crook | Oregon | 41013 | 3073 | 52 |
1848767 | 1848767 | 2021-10-24 | Bennington | Vermont | 50003 | 3073 | 26 |
1838549 | 1838549 | 2021-10-21 | Hampton | South Carolina | 45049 | 3073 | 74 |
1831038 | 1831038 | 2021-10-19 | Clay | Mississippi | 28025 | 3073 | 76 |
1826952 | 1826952 | 2021-10-18 | Minidoka | Idaho | 16067 | 3073 | 44 |
1818960 | 1818960 | 2021-10-15 | Canovanas | Puerto Rico | 72029 | 3073 | |
1813115 | 1813115 | 2021-10-13 | Louisa | Virginia | 51109 | 3073 | 43 |
1783935 | 1783935 | 2021-10-04 | Adams | Washington | 53001 | 3073 | 27 |
1748505 | 1748505 | 2021-09-24 | Clark | Arkansas | 5019 | 3073 | 50 |
1745757 | 1745757 | 2021-09-23 | Douglas | Illinois | 17041 | 3073 | 42 |
1738433 | 1738433 | 2021-09-20 | Staunton city | Virginia | 51790 | 3073 | 76 |
1699344 | 1699344 | 2021-09-08 | Botetourt | Virginia | 51023 | 3073 | 39 |
1694643 | 1694643 | 2021-09-07 | Tishomingo | Mississippi | 28141 | 3073 | 83 |
1691772 | 1691772 | 2021-09-06 | Franklin | New York | 36033 | 3073 | 13 |
1622264 | 1622264 | 2021-08-16 | Cassia | Idaho | 16031 | 3073 | 28 |
1624747 | 1624747 | 2021-08-16 | Winchester city | Virginia | 51840 | 3073 | 49 |
1598325 | 1598325 | 2021-08-08 | Wayne | Tennessee | 47181 | 3073 | 36 |
1595076 | 1595076 | 2021-08-07 | Wayne | Tennessee | 47181 | 3073 | 36 |
1591827 | 1591827 | 2021-08-06 | Wayne | Tennessee | 47181 | 3073 | 36 |
1573754 | 1573754 | 2021-08-01 | Wells | Indiana | 18179 | 3073 | 83 |
1570506 | 1570506 | 2021-07-31 | Wells | Indiana | 18179 | 3073 | 83 |
1567258 | 1567258 | 2021-07-30 | Wells | Indiana | 18179 | 3073 | 83 |
1538402 | 1538402 | 2021-07-21 | Sabine | Louisiana | 22085 | 3073 | 64 |
1534251 | 1534251 | 2021-07-20 | Delta | Colorado | 8029 | 3073 | 70 |
1531004 | 1531004 | 2021-07-19 | Delta | Colorado | 8029 | 3073 | 70 |
1509039 | 1509039 | 2021-07-12 | Clark | Kentucky | 21049 | 3073 | 32 |
1417664 | 1417664 | 2021-06-14 | Unknown | Georgia | 3073 | 4 | |
1356796 | 1356796 | 2021-05-26 | Brown | Minnesota | 27015 | 3073 | 40 |
1321299 | 1321299 | 2021-05-15 | Lafayette | Missouri | 29107 | 3073 | 57 |
1315153 | 1315153 | 2021-05-13 | Washington | New York | 36115 | 3073 | 55 |
1296921 | 1296921 | 2021-05-07 | Wayne | West Virginia | 54099 | 3073 | 40 |
1284469 | 1284469 | 2021-05-04 | Dawson | Georgia | 13085 | 3073 | 43 |
1286562 | 1286562 | 2021-05-04 | Yankton | South Dakota | 46135 | 3073 | 31 |
1270537 | 1270537 | 2021-04-29 | Hopkins | Texas | 48223 | 3073 | 109 |
1260664 | 1260664 | 2021-04-26 | Scott | Tennessee | 47151 | 3073 | 45 |
1244366 | 1244366 | 2021-04-21 | Claiborne | Tennessee | 47025 | 3073 | 73 |
1215181 | 1215181 | 2021-04-12 | Marion | Tennessee | 47115 | 3073 | 46 |
1183881 | 1183881 | 2021-04-03 | Stephens | Georgia | 13257 | 3073 | 78 |
1185609 | 1185609 | 2021-04-03 | Klamath | Oregon | 41035 | 3073 | 57 |
1176983 | 1176983 | 2021-04-01 | Baxter | Arkansas | 5005 | 3073 | 100 |
1178347 | 1178347 | 2021-04-01 | Scott | Mississippi | 28123 | 3073 | 72 |
1171929 | 1171929 | 2021-03-30 | Lafayette | Missouri | 29107 | 3073 | 56 |
1172657 | 1172657 | 2021-03-30 | Clinton | Pennsylvania | 42035 | 3073 | 58 |
1155260 | 1155260 | 2021-03-25 | Allen | Louisiana | 22003 | 3073 | 91 |
1155920 | 1155920 | 2021-03-25 | Cheshire | New Hampshire | 33005 | 3073 | 30 |
1119894 | 1119894 | 2021-03-14 | Pike | Mississippi | 28113 | 3073 | 100 |
1116647 | 1116647 | 2021-03-13 | Pike | Mississippi | 28113 | 3073 | 100 |
1108559 | 1108559 | 2021-03-10 | Marshall | West Virginia | 54051 | 3073 | 66 |
1096002 | 1096002 | 2021-03-07 | Summit | Colorado | 8117 | 3073 | 7 |
1098004 | 1098004 | 2021-03-07 | McKean | Pennsylvania | 42083 | 3073 | 64 |
1092756 | 1092756 | 2021-03-06 | Summit | Colorado | 8117 | 3073 | 7 |
1089510 | 1089510 | 2021-03-05 | Summit | Colorado | 8117 | 3073 | 7 |
1084689 | 1084689 | 2021-03-03 | Pasquotank | North Carolina | 37139 | 3073 | 78 |
1084968 | 1084968 | 2021-03-03 | Polk | Oregon | 41053 | 3073 | 43 |
1062222 | 1062222 | 2021-02-24 | Woodward | Oklahoma | 40153 | 3073 | 15 |
1054863 | 1054863 | 2021-02-22 | Itasca | Minnesota | 27061 | 3073 | 45 |
1055335 | 1055335 | 2021-02-22 | Luna | New Mexico | 35029 | 3073 | 74 |
1050456 | 1050456 | 2021-02-21 | Humboldt | California | 6023 | 3073 | 32 |
1049161 | 1049161 | 2021-02-20 | Adair | Oklahoma | 40001 | 3073 | 21 |
1033733 | 1033733 | 2021-02-15 | Charlottesville city | Virginia | 51540 | 3073 | 40 |
1020249 | 1020249 | 2021-02-11 | Marion | South Carolina | 45067 | 3073 | 92 |
1015298 | 1015298 | 2021-02-10 | Jasper | Indiana | 18073 | 3073 | 43 |
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);