ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 8657 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492658 | 2492658 | 2022-05-10 | Titus | Texas | 48449 | 8657 | 128 |
2467846 | 2467846 | 2022-05-03 | Jasper | Iowa | 19099 | 8657 | 110 |
2464591 | 2464591 | 2022-05-02 | Jasper | Iowa | 19099 | 8657 | 110 |
2461335 | 2461335 | 2022-05-01 | Jasper | Iowa | 19099 | 8657 | 110 |
2458079 | 2458079 | 2022-04-30 | Jasper | Iowa | 19099 | 8657 | 110 |
2454823 | 2454823 | 2022-04-29 | Jasper | Iowa | 19099 | 8657 | 110 |
2451567 | 2451567 | 2022-04-28 | Jasper | Iowa | 19099 | 8657 | 110 |
2448311 | 2448311 | 2022-04-27 | Jasper | Iowa | 19099 | 8657 | 110 |
2419903 | 2419903 | 2022-04-18 | Platte | Nebraska | 31141 | 8657 | 74 |
2416134 | 2416134 | 2022-04-17 | Worcester | Maryland | 24047 | 8657 | 158 |
2416648 | 2416648 | 2022-04-17 | Platte | Nebraska | 31141 | 8657 | 74 |
2412878 | 2412878 | 2022-04-16 | Worcester | Maryland | 24047 | 8657 | 158 |
2413392 | 2413392 | 2022-04-16 | Platte | Nebraska | 31141 | 8657 | 74 |
2409622 | 2409622 | 2022-04-15 | Worcester | Maryland | 24047 | 8657 | 158 |
2410136 | 2410136 | 2022-04-15 | Platte | Nebraska | 31141 | 8657 | 74 |
2333398 | 2333398 | 2022-03-22 | Whitman | Washington | 53075 | 8657 | 90 |
2330144 | 2330144 | 2022-03-21 | Whitman | Washington | 53075 | 8657 | 90 |
2279983 | 2279983 | 2022-03-06 | Lincoln | Nebraska | 31111 | 8657 | 107 |
2276730 | 2276730 | 2022-03-05 | Lincoln | Nebraska | 31111 | 8657 | 107 |
2273477 | 2273477 | 2022-03-04 | Lincoln | Nebraska | 31111 | 8657 | 107 |
2124127 | 2124127 | 2022-01-17 | Stokes | North Carolina | 37169 | 8657 | 124 |
2120875 | 2120875 | 2022-01-16 | Stokes | North Carolina | 37169 | 8657 | 124 |
2120961 | 2120961 | 2022-01-16 | Clinton | Ohio | 39027 | 8657 | 121 |
2117623 | 2117623 | 2022-01-15 | Stokes | North Carolina | 37169 | 8657 | 124 |
2114372 | 2114372 | 2022-01-14 | Stokes | North Carolina | 37169 | 8657 | 124 |
2005739 | 2005739 | 2021-12-12 | Grundy | Illinois | 17063 | 8657 | 95 |
2002488 | 2002488 | 2021-12-11 | Grundy | Illinois | 17063 | 8657 | 95 |
1999238 | 1999238 | 2021-12-10 | Grundy | Illinois | 17063 | 8657 | 95 |
1989740 | 1989740 | 2021-12-07 | Warren | Iowa | 19181 | 8657 | 107 |
1986490 | 1986490 | 2021-12-06 | Warren | Iowa | 19181 | 8657 | 107 |
1983240 | 1983240 | 2021-12-05 | Warren | Iowa | 19181 | 8657 | 107 |
1979990 | 1979990 | 2021-12-04 | Warren | Iowa | 19181 | 8657 | 107 |
1976740 | 1976740 | 2021-12-03 | Warren | Iowa | 19181 | 8657 | 107 |
1973491 | 1973491 | 2021-12-02 | Warren | Iowa | 19181 | 8657 | 107 |
1970241 | 1970241 | 2021-12-01 | Warren | Iowa | 19181 | 8657 | 107 |
1905122 | 1905122 | 2021-11-11 | Shelby | Indiana | 18145 | 8657 | 134 |
1902947 | 1902947 | 2021-11-10 | Cattaraugus | New York | 36009 | 8657 | 138 |
1868868 | 1868868 | 2021-10-31 | Fremont | Colorado | 8043 | 8657 | 93 |
1865619 | 1865619 | 2021-10-30 | Fremont | Colorado | 8043 | 8657 | 93 |
1862370 | 1862370 | 2021-10-29 | Fremont | Colorado | 8043 | 8657 | 93 |
1831379 | 1831379 | 2021-10-19 | Elko | Nevada | 32007 | 8657 | 105 |
1696382 | 1696382 | 2021-09-07 | Wood | Wisconsin | 55141 | 8657 | 116 |
1690988 | 1690988 | 2021-09-06 | McCracken | Kentucky | 21145 | 8657 | 140 |
1687738 | 1687738 | 2021-09-05 | McCracken | Kentucky | 21145 | 8657 | 140 |
1684488 | 1684488 | 2021-09-04 | McCracken | Kentucky | 21145 | 8657 | 140 |
1681237 | 1681237 | 2021-09-03 | McCracken | Kentucky | 21145 | 8657 | 140 |
1663920 | 1663920 | 2021-08-29 | Autauga | Alabama | 1001 | 8657 | 118 |
1519726 | 1519726 | 2021-07-15 | Orange | North Carolina | 37135 | 8657 | 101 |
1497309 | 1497309 | 2021-07-08 | Clearfield | Pennsylvania | 42033 | 8657 | 156 |
1493893 | 1493893 | 2021-07-07 | Marion | Ohio | 39101 | 8657 | 140 |
1247601 | 1247601 | 2021-04-22 | Anderson | Tennessee | 47001 | 8657 | 172 |
1198271 | 1198271 | 2021-04-07 | Brunswick | North Carolina | 37019 | 8657 | 147 |
1192172 | 1192172 | 2021-04-05 | Northumberland | Pennsylvania | 42097 | 8657 | 337 |
1124941 | 1124941 | 2021-03-16 | DeKalb | Alabama | 1049 | 8657 | 178 |
1105583 | 1105583 | 2021-03-10 | Jefferson | Arkansas | 5069 | 8657 | 161 |
954146 | 954146 | 2021-01-22 | Calhoun | Michigan | 26025 | 8657 | 209 |
837314 | 837314 | 2020-12-17 | Berrien | Michigan | 26021 | 8657 | 162 |
839276 | 839276 | 2020-12-17 | Walworth | Wisconsin | 55127 | 8657 | 79 |
834444 | 834444 | 2020-12-16 | Gallatin | Montana | 30031 | 8657 | 30 |
798903 | 798903 | 2020-12-05 | Atlantic | New Jersey | 34001 | 8657 | 305 |
758136 | 758136 | 2020-11-22 | Sheboygan | Wisconsin | 55117 | 8657 | 50 |
714150 | 714150 | 2020-11-09 | Washington | Minnesota | 27163 | 8657 | 80 |
633173 | 633173 | 2020-10-15 | Greene | Missouri | 29077 | 8657 | 121 |
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);