ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where deaths = 1178 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Virginia 15
- Ohio 8
- Pennsylvania 8
- Kansas 7
- Illinois 6
- New Jersey 6
- California 5
- Indiana 5
- New Mexico 5
- Kentucky 4
- Tennessee 3
- Georgia 2
- Massachusetts 2
- Michigan 2
- New York 2
- Texas 2
- Arizona 1
- District of Columbia 1
- Florida 1
- Louisiana 1
- Maryland 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444854 | 2444854 | 2022-04-26 | Kane | Illinois | 17089 | 128092 | 1178 |
2441598 | 2441598 | 2022-04-25 | Kane | Illinois | 17089 | 127943 | 1178 |
2438342 | 2438342 | 2022-04-24 | Kane | Illinois | 17089 | 127585 | 1178 |
2435086 | 2435086 | 2022-04-23 | Kane | Illinois | 17089 | 127585 | 1178 |
2431830 | 2431830 | 2022-04-22 | Kane | Illinois | 17089 | 127585 | 1178 |
2399332 | 2399332 | 2022-04-12 | Allen | Indiana | 18003 | 103767 | 1178 |
2396077 | 2396077 | 2022-04-11 | Allen | Indiana | 18003 | 103767 | 1178 |
2392821 | 2392821 | 2022-04-10 | Allen | Indiana | 18003 | 103743 | 1178 |
2389565 | 2389565 | 2022-04-09 | Allen | Indiana | 18003 | 103743 | 1178 |
2386310 | 2386310 | 2022-04-08 | Allen | Indiana | 18003 | 103743 | 1178 |
2285704 | 2285704 | 2022-03-08 | Johnson | Kansas | 20091 | 144413 | 1178 |
2282452 | 2282452 | 2022-03-07 | Johnson | Kansas | 20091 | 144413 | 1178 |
2279199 | 2279199 | 2022-03-06 | Johnson | Kansas | 20091 | 144341 | 1178 |
2280052 | 2280052 | 2022-03-06 | Burlington | New Jersey | 34005 | 101000 | 1178 |
2275946 | 2275946 | 2022-03-05 | Johnson | Kansas | 20091 | 144341 | 1178 |
2276799 | 2276799 | 2022-03-05 | Burlington | New Jersey | 34005 | 100972 | 1178 |
2272693 | 2272693 | 2022-03-04 | Johnson | Kansas | 20091 | 144341 | 1178 |
2269441 | 2269441 | 2022-03-03 | Johnson | Kansas | 20091 | 144171 | 1178 |
2266188 | 2266188 | 2022-03-02 | Johnson | Kansas | 20091 | 144171 | 1178 |
2183004 | 2183004 | 2022-02-04 | Lehigh | Pennsylvania | 42077 | 87510 | 1178 |
2169492 | 2169492 | 2022-01-31 | Mercer | New Jersey | 34021 | 72305 | 1178 |
2166237 | 2166237 | 2022-01-30 | Mercer | New Jersey | 34021 | 72207 | 1178 |
2162982 | 2162982 | 2022-01-29 | Mercer | New Jersey | 34021 | 72111 | 1178 |
2153723 | 2153723 | 2022-01-26 | Luzerne | Pennsylvania | 42079 | 68595 | 1178 |
2150961 | 2150961 | 2022-01-25 | Montgomery | Texas | 48339 | 125556 | 1178 |
2124467 | 2124467 | 2022-01-17 | Westmoreland | Pennsylvania | 42129 | 69220 | 1178 |
2121215 | 2121215 | 2022-01-16 | Westmoreland | Pennsylvania | 42129 | 68953 | 1178 |
2117963 | 2117963 | 2022-01-15 | Westmoreland | Pennsylvania | 42129 | 67953 | 1178 |
2066964 | 2066964 | 2021-12-31 | Mohave | Arizona | 4015 | 39143 | 1178 |
2055000 | 2055000 | 2021-12-27 | East Baton Rouge | Louisiana | 22033 | 66967 | 1178 |
2008072 | 2008072 | 2021-12-12 | Fairfax | Virginia | 51059 | 97108 | 1178 |
2004821 | 2004821 | 2021-12-11 | Fairfax | Virginia | 51059 | 97108 | 1178 |
2001570 | 2001570 | 2021-12-10 | Fairfax | Virginia | 51059 | 97108 | 1178 |
1998320 | 1998320 | 2021-12-09 | Fairfax | Virginia | 51059 | 96870 | 1178 |
1991818 | 1991818 | 2021-12-07 | Fairfax | Virginia | 51059 | 96309 | 1178 |
1988567 | 1988567 | 2021-12-06 | Fairfax | Virginia | 51059 | 96161 | 1178 |
1985317 | 1985317 | 2021-12-05 | Fairfax | Virginia | 51059 | 95666 | 1178 |
1982067 | 1982067 | 2021-12-04 | Fairfax | Virginia | 51059 | 95666 | 1178 |
1978817 | 1978817 | 2021-12-03 | Fairfax | Virginia | 51059 | 95666 | 1178 |
1973870 | 1973870 | 2021-12-02 | Genesee | Michigan | 26049 | 62139 | 1178 |
1975567 | 1975567 | 2021-12-02 | Fairfax | Virginia | 51059 | 95470 | 1178 |
1970621 | 1970621 | 2021-12-01 | Genesee | Michigan | 26049 | 62139 | 1178 |
1972318 | 1972318 | 2021-12-01 | Fairfax | Virginia | 51059 | 95238 | 1178 |
1961415 | 1961415 | 2021-11-28 | Bernalillo | New Mexico | 35001 | 85278 | 1178 |
1958164 | 1958164 | 2021-11-27 | Bernalillo | New Mexico | 35001 | 85278 | 1178 |
1954913 | 1954913 | 2021-11-26 | Bernalillo | New Mexico | 35001 | 85278 | 1178 |
1951662 | 1951662 | 2021-11-25 | Bernalillo | New Mexico | 35001 | 85278 | 1178 |
1951986 | 1951986 | 2021-11-25 | Summit | Ohio | 39153 | 68882 | 1178 |
1948411 | 1948411 | 2021-11-24 | Bernalillo | New Mexico | 35001 | 85278 | 1178 |
1948735 | 1948735 | 2021-11-24 | Summit | Ohio | 39153 | 68882 | 1178 |
1945484 | 1945484 | 2021-11-23 | Summit | Ohio | 39153 | 68497 | 1178 |
1942233 | 1942233 | 2021-11-22 | Summit | Ohio | 39153 | 68187 | 1178 |
1938983 | 1938983 | 2021-11-21 | Summit | Ohio | 39153 | 67937 | 1178 |
1935733 | 1935733 | 2021-11-20 | Summit | Ohio | 39153 | 67709 | 1178 |
1932483 | 1932483 | 2021-11-19 | Summit | Ohio | 39153 | 67368 | 1178 |
1916642 | 1916642 | 2021-11-14 | Davidson | Tennessee | 47037 | 133942 | 1178 |
1913392 | 1913392 | 2021-11-13 | Davidson | Tennessee | 47037 | 133942 | 1178 |
1910142 | 1910142 | 2021-11-12 | Davidson | Tennessee | 47037 | 133942 | 1178 |
1881839 | 1881839 | 2021-11-04 | Ventura | California | 6111 | 102107 | 1178 |
1884561 | 1884561 | 2021-11-04 | Fairfax | Virginia | 51059 | 92377 | 1178 |
1878590 | 1878590 | 2021-11-03 | Ventura | California | 6111 | 101968 | 1178 |
1875341 | 1875341 | 2021-11-02 | Ventura | California | 6111 | 101901 | 1178 |
1872092 | 1872092 | 2021-11-01 | Ventura | California | 6111 | 101854 | 1178 |
1848821 | 1848821 | 2021-10-24 | Fairfax | Virginia | 51059 | 91314 | 1178 |
1845571 | 1845571 | 2021-10-23 | Fairfax | Virginia | 51059 | 91314 | 1178 |
1842321 | 1842321 | 2021-10-22 | Fairfax | Virginia | 51059 | 91314 | 1178 |
1815238 | 1815238 | 2021-10-14 | Monroe | New York | 36055 | 82768 | 1178 |
1811990 | 1811990 | 2021-10-13 | Monroe | New York | 36055 | 82481 | 1178 |
1781197 | 1781197 | 2021-10-04 | District of Columbia | District of Columbia | 11001 | 61791 | 1178 |
1781576 | 1781576 | 2021-10-04 | Will | Illinois | 17197 | 89027 | 1178 |
1760931 | 1760931 | 2021-09-27 | Nueces | Texas | 48355 | 59879 | 1178 |
1742319 | 1742319 | 2021-09-22 | DeKalb | Georgia | 13089 | 86624 | 1178 |
1627238 | 1627238 | 2021-08-17 | Lancaster | Pennsylvania | 42071 | 57360 | 1178 |
1362413 | 1362413 | 2021-05-28 | Gwinnett | Georgia | 13135 | 102549 | 1178 |
1285093 | 1285093 | 2021-05-04 | Jefferson | Kentucky | 21111 | 81209 | 1178 |
1281846 | 1281846 | 2021-05-03 | Jefferson | Kentucky | 21111 | 81112 | 1178 |
1278599 | 1278599 | 2021-05-02 | Jefferson | Kentucky | 21111 | 81037 | 1178 |
1275352 | 1275352 | 2021-05-01 | Jefferson | Kentucky | 21111 | 80963 | 1178 |
1172648 | 1172648 | 2021-03-30 | Bucks | Pennsylvania | 42017 | 50726 | 1178 |
1147844 | 1147844 | 2021-03-23 | Kern | California | 6029 | 105625 | 1178 |
1097493 | 1097493 | 2021-03-07 | Camden | New Jersey | 34007 | 44972 | 1178 |
1049097 | 1049097 | 2021-02-20 | Franklin | Ohio | 39049 | 110335 | 1178 |
1002780 | 1002780 | 2021-02-06 | Baltimore | Maryland | 24005 | 48316 | 1178 |
967105 | 967105 | 2021-01-26 | Hampden | Massachusetts | 25013 | 35812 | 1178 |
778880 | 778880 | 2020-11-29 | Norfolk | Massachusetts | 25021 | 16047 | 1178 |
515377 | 515377 | 2020-09-09 | Palm Beach | Florida | 12099 | 43420 | 1178 |
165456 | 165456 | 2020-05-21 | Philadelphia | Pennsylvania | 42101 | 20700 | 1178 |
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);