ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
243 rows where cases = 2524 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 21
- Tennessee 21
- Texas 20
- Virginia 18
- Louisiana 16
- Minnesota 14
- Arkansas 13
- Kentucky 13
- Georgia 11
- Missouri 10
- Illinois 7
- Puerto Rico 7
- Wisconsin 7
- Indiana 5
- Montana 5
- North Carolina 5
- Ohio 5
- South Carolina 5
- Iowa 4
- Michigan 4
- New Mexico 4
- South Dakota 4
- Colorado 3
- Idaho 3
- Wyoming 3
- Alabama 2
- Nebraska 2
- Oregon 2
- California 1
- Kansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475052 | 2475052 | 2022-05-05 | Grundy | Missouri | 29079 | 2524 | 68 |
2396859 | 2396859 | 2022-04-11 | Tunica | Mississippi | 28143 | 2524 | 46 |
2393604 | 2393604 | 2022-04-10 | Tunica | Mississippi | 28143 | 2524 | 46 |
2390348 | 2390348 | 2022-04-09 | Tunica | Mississippi | 28143 | 2524 | 46 |
2387092 | 2387092 | 2022-04-08 | Tunica | Mississippi | 28143 | 2524 | 46 |
2383837 | 2383837 | 2022-04-07 | Tunica | Mississippi | 28143 | 2524 | 46 |
2380582 | 2380582 | 2022-04-06 | Tunica | Mississippi | 28143 | 2524 | 46 |
2376090 | 2376090 | 2022-04-05 | Bent | Colorado | 8011 | 2524 | 47 |
2377327 | 2377327 | 2022-04-05 | Tunica | Mississippi | 28143 | 2524 | 46 |
2374075 | 2374075 | 2022-04-04 | Tunica | Mississippi | 28143 | 2524 | 46 |
2365685 | 2365685 | 2022-04-01 | Trinity | Texas | 48455 | 2524 | 72 |
2360990 | 2360990 | 2022-03-31 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2362432 | 2362432 | 2022-03-31 | Trinity | Texas | 48455 | 2524 | 72 |
2357736 | 2357736 | 2022-03-30 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2354483 | 2354483 | 2022-03-29 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2351231 | 2351231 | 2022-03-28 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2347978 | 2347978 | 2022-03-27 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2344725 | 2344725 | 2022-03-26 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2341472 | 2341472 | 2022-03-25 | Yellow Medicine | Minnesota | 27173 | 2524 | 29 |
2342701 | 2342701 | 2022-03-25 | Blanco | Texas | 48031 | 2524 | 34 |
2339448 | 2339448 | 2022-03-24 | Blanco | Texas | 48031 | 2524 | 34 |
2302160 | 2302160 | 2022-03-13 | East Carroll | Louisiana | 22035 | 2524 | 38 |
2298908 | 2298908 | 2022-03-12 | East Carroll | Louisiana | 22035 | 2524 | 38 |
2295656 | 2295656 | 2022-03-11 | East Carroll | Louisiana | 22035 | 2524 | 38 |
2263258 | 2263258 | 2022-03-01 | Crawford | Michigan | 26039 | 2524 | 29 |
2260007 | 2260007 | 2022-02-28 | Crawford | Michigan | 26039 | 2524 | 29 |
2239297 | 2239297 | 2022-02-22 | Sumter | Alabama | 1119 | 2524 | 45 |
2210575 | 2210575 | 2022-02-13 | Shoshone | Idaho | 16079 | 2524 | 71 |
2211953 | 2211953 | 2022-02-13 | Pamlico | North Carolina | 37137 | 2524 | 27 |
2213209 | 2213209 | 2022-02-13 | Big Horn | Wyoming | 56003 | 2524 | 60 |
2207322 | 2207322 | 2022-02-12 | Shoshone | Idaho | 16079 | 2524 | 71 |
2208700 | 2208700 | 2022-02-12 | Pamlico | North Carolina | 37137 | 2524 | 27 |
2209956 | 2209956 | 2022-02-12 | Big Horn | Wyoming | 56003 | 2524 | 60 |
2205447 | 2205447 | 2022-02-11 | Pamlico | North Carolina | 37137 | 2524 | 27 |
2206703 | 2206703 | 2022-02-11 | Big Horn | Wyoming | 56003 | 2524 | 60 |
2165568 | 2165568 | 2022-01-30 | Catahoula | Louisiana | 22025 | 2524 | 49 |
2162313 | 2162313 | 2022-01-29 | Catahoula | Louisiana | 22025 | 2524 | 49 |
2159058 | 2159058 | 2022-01-28 | Catahoula | Louisiana | 22025 | 2524 | 49 |
2123759 | 2123759 | 2022-01-17 | Custer | Montana | 30017 | 2524 | 43 |
2120507 | 2120507 | 2022-01-16 | Custer | Montana | 30017 | 2524 | 43 |
2117255 | 2117255 | 2022-01-15 | Custer | Montana | 30017 | 2524 | 43 |
2114004 | 2114004 | 2022-01-14 | Custer | Montana | 30017 | 2524 | 43 |
2097700 | 2097700 | 2022-01-09 | Osage | Missouri | 29151 | 2524 | 37 |
2094448 | 2094448 | 2022-01-08 | Osage | Missouri | 29151 | 2524 | 37 |
2086628 | 2086628 | 2022-01-06 | Crowley | Colorado | 8025 | 2524 | 27 |
2083376 | 2083376 | 2022-01-05 | Crowley | Colorado | 8025 | 2524 | 27 |
2084601 | 2084601 | 2022-01-05 | Tallahatchie | Mississippi | 28135 | 2524 | 53 |
2054017 | 2054017 | 2021-12-27 | Marion | Arkansas | 5089 | 2524 | 70 |
2054890 | 2054890 | 2021-12-27 | Clinton | Kentucky | 21053 | 2524 | 41 |
2051640 | 2051640 | 2021-12-26 | Clinton | Kentucky | 21053 | 2524 | 41 |
2048390 | 2048390 | 2021-12-25 | Clinton | Kentucky | 21053 | 2524 | 41 |
2045140 | 2045140 | 2021-12-24 | Clinton | Kentucky | 21053 | 2524 | 41 |
2041891 | 2041891 | 2021-12-23 | Clinton | Kentucky | 21053 | 2524 | 41 |
2038641 | 2038641 | 2021-12-22 | Clinton | Kentucky | 21053 | 2524 | 41 |
2040467 | 2040467 | 2021-12-22 | Tyler | Texas | 48457 | 2524 | 72 |
2035391 | 2035391 | 2021-12-21 | Clinton | Kentucky | 21053 | 2524 | 41 |
2036742 | 2036742 | 2021-12-21 | Manati | Puerto Rico | 72091 | 2524 | |
2037217 | 2037217 | 2021-12-21 | Tyler | Texas | 48457 | 2524 | 72 |
2020660 | 2020660 | 2021-12-16 | Decatur | Tennessee | 47039 | 2524 | 44 |
2010414 | 2010414 | 2021-12-13 | Walsh | North Dakota | 38099 | 2524 | 30 |
2006665 | 2006665 | 2021-12-12 | Macon | Missouri | 29121 | 2524 | 34 |
2006666 | 2006666 | 2021-12-12 | Madison | Missouri | 29123 | 2524 | 40 |
2008316 | 2008316 | 2021-12-12 | Rusk | Wisconsin | 55107 | 2524 | 37 |
2005065 | 2005065 | 2021-12-11 | Rusk | Wisconsin | 55107 | 2524 | 37 |
2001814 | 2001814 | 2021-12-10 | Rusk | Wisconsin | 55107 | 2524 | 37 |
1959741 | 1959741 | 2021-11-28 | Howard | Arkansas | 5061 | 2524 | 38 |
1960244 | 1960244 | 2021-11-28 | Jo Daviess | Illinois | 17085 | 2524 | 32 |
1956490 | 1956490 | 2021-11-27 | Howard | Arkansas | 5061 | 2524 | 38 |
1956993 | 1956993 | 2021-11-27 | Jo Daviess | Illinois | 17085 | 2524 | 32 |
1953239 | 1953239 | 2021-11-26 | Howard | Arkansas | 5061 | 2524 | 38 |
1953742 | 1953742 | 2021-11-26 | Jo Daviess | Illinois | 17085 | 2524 | 32 |
1949988 | 1949988 | 2021-11-25 | Howard | Arkansas | 5061 | 2524 | 38 |
1950491 | 1950491 | 2021-11-25 | Jo Daviess | Illinois | 17085 | 2524 | 32 |
1951196 | 1951196 | 2021-11-25 | Faribault | Minnesota | 27043 | 2524 | 31 |
1947240 | 1947240 | 2021-11-24 | Jo Daviess | Illinois | 17085 | 2524 | 32 |
1947945 | 1947945 | 2021-11-24 | Faribault | Minnesota | 27043 | 2524 | 31 |
1909993 | 1909993 | 2021-11-12 | San Sebastian | Puerto Rico | 72131 | 2524 | |
1879739 | 1879739 | 2021-11-03 | Redwood | Minnesota | 27127 | 2524 | 44 |
1861433 | 1861433 | 2021-10-28 | Lewis | Tennessee | 47101 | 2524 | 38 |
1858052 | 1858052 | 2021-10-27 | Lee | South Carolina | 45061 | 2524 | 74 |
1852499 | 1852499 | 2021-10-26 | Izard | Arkansas | 5065 | 2524 | 55 |
1854803 | 1854803 | 2021-10-26 | Lee | South Carolina | 45061 | 2524 | 74 |
1849250 | 1849250 | 2021-10-25 | Izard | Arkansas | 5065 | 2524 | 55 |
1824951 | 1824951 | 2021-10-17 | San Miguel | New Mexico | 35047 | 2524 | 22 |
1821702 | 1821702 | 2021-10-16 | San Miguel | New Mexico | 35047 | 2524 | 22 |
1818453 | 1818453 | 2021-10-15 | San Miguel | New Mexico | 35047 | 2524 | 22 |
1816356 | 1816356 | 2021-10-14 | King George | Virginia | 51099 | 2524 | 22 |
1809884 | 1809884 | 2021-10-12 | Nottoway | Virginia | 51135 | 2524 | 62 |
1793395 | 1793395 | 2021-10-07 | Llano | Texas | 48299 | 2524 | 68 |
1775933 | 1775933 | 2021-10-02 | Livingston | Missouri | 29117 | 2524 | 62 |
1769232 | 1769232 | 2021-09-30 | Hubbard | Minnesota | 27057 | 2524 | 41 |
1766197 | 1766197 | 2021-09-29 | Morgan | Missouri | 29141 | 2524 | 57 |
1735509 | 1735509 | 2021-09-20 | Clay | Arkansas | 5021 | 2524 | 55 |
1732609 | 1732609 | 2021-09-19 | Jefferson | Georgia | 13163 | 2524 | 74 |
1729359 | 1729359 | 2021-09-18 | Jefferson | Georgia | 13163 | 2524 | 74 |
1726109 | 1726109 | 2021-09-17 | Jefferson | Georgia | 13163 | 2524 | 74 |
1679007 | 1679007 | 2021-09-02 | Hocking | Ohio | 39073 | 2524 | 63 |
1667136 | 1667136 | 2021-08-29 | Vilas | Wisconsin | 55125 | 2524 | 46 |
1663888 | 1663888 | 2021-08-28 | Vilas | Wisconsin | 55125 | 2524 | 46 |
1660640 | 1660640 | 2021-08-27 | Vilas | Wisconsin | 55125 | 2524 | 46 |
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);