ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
236 rows where cases = 2115 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Kentucky 19
- Georgia 16
- Minnesota 16
- Illinois 15
- Kansas 14
- Missouri 14
- Tennessee 12
- Virginia 8
- Iowa 6
- Montana 6
- North Carolina 6
- West Virginia 6
- Arkansas 5
- Colorado 5
- Indiana 5
- Mississippi 5
- Ohio 5
- Puerto Rico 5
- South Dakota 5
- Alabama 4
- Louisiana 4
- Nebraska 4
- Wisconsin 4
- Oklahoma 3
- Pennsylvania 3
- Florida 2
- Michigan 2
- New York 2
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494432 | 2494432 | 2022-05-11 | Marshall | Minnesota | 27089 | 2115 | 23 |
2491174 | 2491174 | 2022-05-10 | Marshall | Minnesota | 27089 | 2115 | 23 |
2489388 | 2489388 | 2022-05-09 | Somervell | Texas | 48425 | 2115 | 36 |
2486130 | 2486130 | 2022-05-08 | Somervell | Texas | 48425 | 2115 | 36 |
2482872 | 2482872 | 2022-05-07 | Somervell | Texas | 48425 | 2115 | 36 |
2479614 | 2479614 | 2022-05-06 | Somervell | Texas | 48425 | 2115 | 36 |
2476356 | 2476356 | 2022-05-05 | Somervell | Texas | 48425 | 2115 | 36 |
2473099 | 2473099 | 2022-05-04 | Somervell | Texas | 48425 | 2115 | 36 |
2466716 | 2466716 | 2022-05-02 | Falls Church city | Virginia | 51610 | 2115 | 17 |
2431358 | 2431358 | 2022-04-22 | Searcy | Arkansas | 5129 | 2115 | 48 |
2406035 | 2406035 | 2022-04-14 | Anderson | Kansas | 20003 | 2115 | 29 |
2402779 | 2402779 | 2022-04-13 | Anderson | Kansas | 20003 | 2115 | 29 |
2399525 | 2399525 | 2022-04-12 | Anderson | Kansas | 20003 | 2115 | 29 |
2396269 | 2396269 | 2022-04-11 | Anderson | Kansas | 20003 | 2115 | 29 |
2393014 | 2393014 | 2022-04-10 | Anderson | Kansas | 20003 | 2115 | 29 |
2389758 | 2389758 | 2022-04-09 | Anderson | Kansas | 20003 | 2115 | 29 |
2386502 | 2386502 | 2022-04-08 | Anderson | Kansas | 20003 | 2115 | 29 |
2285154 | 2285154 | 2022-03-08 | Atkinson | Georgia | 13003 | 2115 | 47 |
2277711 | 2277711 | 2022-03-05 | Franklin | Texas | 48159 | 2115 | 40 |
2269468 | 2269468 | 2022-03-03 | Pawnee | Kansas | 20145 | 2115 | 23 |
2266215 | 2266215 | 2022-03-02 | Pawnee | Kansas | 20145 | 2115 | 23 |
2267640 | 2267640 | 2022-03-02 | Rincon | Puerto Rico | 72117 | 2115 | |
2262964 | 2262964 | 2022-03-01 | Pawnee | Kansas | 20145 | 2115 | 23 |
2259713 | 2259713 | 2022-02-28 | Pawnee | Kansas | 20145 | 2115 | 23 |
2257152 | 2257152 | 2022-02-27 | Sanders | Montana | 30089 | 2115 | 46 |
2253901 | 2253901 | 2022-02-26 | Sanders | Montana | 30089 | 2115 | 46 |
2250650 | 2250650 | 2022-02-25 | Sanders | Montana | 30089 | 2115 | 46 |
2237516 | 2237516 | 2022-02-21 | DeKalb | Missouri | 29063 | 2115 | 43 |
2234265 | 2234265 | 2022-02-20 | DeKalb | Missouri | 29063 | 2115 | 43 |
2231014 | 2231014 | 2022-02-19 | DeKalb | Missouri | 29063 | 2115 | 43 |
2227763 | 2227763 | 2022-02-18 | DeKalb | Missouri | 29063 | 2115 | 43 |
2224512 | 2224512 | 2022-02-17 | DeKalb | Missouri | 29063 | 2115 | 43 |
2221261 | 2221261 | 2022-02-16 | DeKalb | Missouri | 29063 | 2115 | 43 |
2219629 | 2219629 | 2022-02-15 | Tyler | West Virginia | 54095 | 2115 | 27 |
2211404 | 2211404 | 2022-02-13 | Claiborne | Mississippi | 28021 | 2115 | 45 |
2208151 | 2208151 | 2022-02-12 | Claiborne | Mississippi | 28021 | 2115 | 45 |
2204898 | 2204898 | 2022-02-11 | Claiborne | Mississippi | 28021 | 2115 | 45 |
2197599 | 2197599 | 2022-02-09 | Hamilton | Illinois | 17065 | 2115 | 31 |
2165345 | 2165345 | 2022-01-30 | Cloud | Kansas | 20029 | 2115 | 35 |
2162090 | 2162090 | 2022-01-29 | Cloud | Kansas | 20029 | 2115 | 35 |
2158835 | 2158835 | 2022-01-28 | Cloud | Kansas | 20029 | 2115 | 35 |
2146307 | 2146307 | 2022-01-24 | Rock | Minnesota | 27133 | 2115 | 32 |
2147938 | 2147938 | 2022-01-24 | Poquoson city | Virginia | 51735 | 2115 | 24 |
2137509 | 2137509 | 2022-01-21 | Florida | Puerto Rico | 72054 | 2115 | |
2086386 | 2086386 | 2022-01-06 | Conecuh | Alabama | 1035 | 2115 | 62 |
2076733 | 2076733 | 2022-01-03 | Chicot | Arkansas | 5017 | 2115 | 48 |
2079477 | 2079477 | 2022-01-03 | Ward | Texas | 48475 | 2115 | 36 |
2029273 | 2029273 | 2021-12-19 | Watonwan | Minnesota | 27165 | 2115 | 21 |
2026022 | 2026022 | 2021-12-18 | Watonwan | Minnesota | 27165 | 2115 | 21 |
2022771 | 2022771 | 2021-12-17 | Watonwan | Minnesota | 27165 | 2115 | 21 |
2017763 | 2017763 | 2021-12-15 | Unknown | Utah | 2115 | 48 | |
2014081 | 2014081 | 2021-12-14 | Butte | South Dakota | 46019 | 2115 | 35 |
2007579 | 2007579 | 2021-12-12 | Butte | South Dakota | 46019 | 2115 | 35 |
2004328 | 2004328 | 2021-12-11 | Butte | South Dakota | 46019 | 2115 | 35 |
2001077 | 2001077 | 2021-12-10 | Butte | South Dakota | 46019 | 2115 | 35 |
1998513 | 1998513 | 2021-12-09 | Bayfield | Wisconsin | 55007 | 2115 | 30 |
1994111 | 1994111 | 2021-12-08 | Barnes | North Dakota | 38003 | 2115 | 39 |
1977429 | 1977429 | 2021-12-03 | Pemiscot | Missouri | 29155 | 2115 | 57 |
1974179 | 1974179 | 2021-12-02 | Pemiscot | Missouri | 29155 | 2115 | 57 |
1970375 | 1970375 | 2021-12-01 | Carroll | Kentucky | 21041 | 2115 | 31 |
1971926 | 1971926 | 2021-12-01 | Jackson | Tennessee | 47087 | 2115 | 41 |
1937942 | 1937942 | 2021-11-21 | Pendleton | Kentucky | 21191 | 2115 | 24 |
1934692 | 1934692 | 2021-11-20 | Pendleton | Kentucky | 21191 | 2115 | 24 |
1931441 | 1931441 | 2021-11-19 | Pendleton | Kentucky | 21191 | 2115 | 24 |
1927379 | 1927379 | 2021-11-18 | Moffat | Colorado | 8081 | 2115 | 47 |
1928190 | 1928190 | 2021-11-18 | Pendleton | Kentucky | 21191 | 2115 | 21 |
1919080 | 1919080 | 2021-11-15 | Otoe | Nebraska | 31131 | 2115 | 16 |
1919467 | 1919467 | 2021-11-15 | Noble | Ohio | 39121 | 2115 | 47 |
1877946 | 1877946 | 2021-11-02 | Terry | Texas | 48445 | 2115 | 66 |
1859436 | 1859436 | 2021-10-28 | Idaho | Idaho | 16049 | 2115 | 35 |
1855391 | 1855391 | 2021-10-26 | Rockbridge | Virginia | 51163 | 2115 | 57 |
1827936 | 1827936 | 2021-10-18 | Osage | Missouri | 29151 | 2115 | 23 |
1823267 | 1823267 | 2021-10-17 | Marion | Arkansas | 5089 | 2115 | 57 |
1784819 | 1784819 | 2021-10-05 | Wabash | Illinois | 17185 | 2115 | 21 |
1785986 | 1785986 | 2021-10-05 | Essex | New York | 36031 | 2115 | 30 |
1781519 | 1781519 | 2021-10-04 | Jo Daviess | Illinois | 17085 | 2115 | 30 |
1773936 | 1773936 | 2021-10-01 | Pecos | Texas | 48371 | 2115 | 44 |
1767437 | 1767437 | 2021-09-29 | Pecos | Texas | 48371 | 2115 | 44 |
1714204 | 1714204 | 2021-09-13 | Madison | Missouri | 29123 | 2115 | 18 |
1712518 | 1712518 | 2021-09-12 | Lincoln | West Virginia | 54043 | 2115 | 29 |
1702753 | 1702753 | 2021-09-09 | Barbour | West Virginia | 54001 | 2115 | 35 |
1673928 | 1673928 | 2021-09-01 | Elbert | Colorado | 8039 | 2115 | 16 |
1647586 | 1647586 | 2021-08-23 | Adams | Wisconsin | 55001 | 2115 | 21 |
1641578 | 1641578 | 2021-08-22 | Banks | Georgia | 13011 | 2115 | 46 |
1642186 | 1642186 | 2021-08-22 | Anderson | Kentucky | 21005 | 2115 | 25 |
1638328 | 1638328 | 2021-08-21 | Banks | Georgia | 13011 | 2115 | 46 |
1638936 | 1638936 | 2021-08-21 | Anderson | Kentucky | 21005 | 2115 | 25 |
1635078 | 1635078 | 2021-08-20 | Banks | Georgia | 13011 | 2115 | 46 |
1635686 | 1635686 | 2021-08-20 | Anderson | Kentucky | 21005 | 2115 | 25 |
1620777 | 1620777 | 2021-08-15 | Aguada | Puerto Rico | 72003 | 2115 | |
1611096 | 1611096 | 2021-08-12 | San Lorenzo | Puerto Rico | 72129 | 2115 | |
1611477 | 1611477 | 2021-08-12 | Madison | Texas | 48313 | 2115 | 31 |
1611876 | 1611876 | 2021-08-12 | Green Lake | Wisconsin | 55047 | 2115 | 25 |
1608022 | 1608022 | 2021-08-11 | Humphreys | Tennessee | 47085 | 2115 | 32 |
1581027 | 1581027 | 2021-08-03 | Morgan | Missouri | 29141 | 2115 | 46 |
1573570 | 1573570 | 2021-08-01 | Cass | Illinois | 17017 | 2115 | 36 |
1570322 | 1570322 | 2021-07-31 | Cass | Illinois | 17017 | 2115 | 36 |
1567074 | 1567074 | 2021-07-30 | Cass | Illinois | 17017 | 2115 | 36 |
1565914 | 1565914 | 2021-07-29 | Falls | Texas | 48145 | 2115 | 33 |
1562666 | 1562666 | 2021-07-28 | Falls | Texas | 48145 | 2115 | 33 |
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);