ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where deaths = 1196 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- District of Columbia 14
- Oklahoma 7
- Pennsylvania 7
- New Jersey 6
- Tennessee 5
- Massachusetts 4
- Colorado 3
- Illinois 3
- Michigan 3
- California 2
- Florida 2
- Georgia 2
- Kansas 2
- Alabama 1
- Arizona 1
- Louisiana 1
- Maryland 1
- New Mexico 1
- New York 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403679 | 2403679 | 2022-04-13 | Burlington | New Jersey | 34005 | 102762 | 1196 |
2400424 | 2400424 | 2022-04-12 | Burlington | New Jersey | 34005 | 102680 | 1196 |
2384147 | 2384147 | 2022-04-07 | Burlington | New Jersey | 34005 | 102286 | 1196 |
2374384 | 2374384 | 2022-04-04 | Burlington | New Jersey | 34005 | 102073 | 1196 |
2354010 | 2354010 | 2022-03-29 | Johnson | Kansas | 20091 | 145027 | 1196 |
2350758 | 2350758 | 2022-03-28 | Johnson | Kansas | 20091 | 145027 | 1196 |
2212284 | 2212284 | 2022-02-13 | Lehigh | Pennsylvania | 42077 | 88227 | 1196 |
2209031 | 2209031 | 2022-02-12 | Lehigh | Pennsylvania | 42077 | 88195 | 1196 |
2187465 | 2187465 | 2022-02-06 | Denver | Colorado | 8031 | 160195 | 1196 |
2184212 | 2184212 | 2022-02-05 | Denver | Colorado | 8031 | 160195 | 1196 |
2180960 | 2180960 | 2022-02-04 | Denver | Colorado | 8031 | 160195 | 1196 |
2166742 | 2166742 | 2022-01-30 | Luzerne | Pennsylvania | 42079 | 69965 | 1196 |
2163487 | 2163487 | 2022-01-29 | Luzerne | Pennsylvania | 42079 | 69785 | 1196 |
2128882 | 2128882 | 2022-01-19 | Tulare | California | 6107 | 102511 | 1196 |
2126526 | 2126526 | 2022-01-18 | East Baton Rouge | Louisiana | 22033 | 93501 | 1196 |
2083221 | 2083221 | 2022-01-05 | Mohave | Arizona | 4015 | 39946 | 1196 |
2075695 | 2075695 | 2022-01-02 | York | Pennsylvania | 42133 | 88124 | 1196 |
2072444 | 2072444 | 2022-01-01 | York | Pennsylvania | 42133 | 86890 | 1196 |
2015510 | 2015510 | 2021-12-15 | Lake | Illinois | 17097 | 92293 | 1196 |
1974417 | 1974417 | 2021-12-02 | Bernalillo | New Mexico | 35001 | 88234 | 1196 |
1969675 | 1969675 | 2021-12-01 | District of Columbia | District of Columbia | 11001 | 67047 | 1196 |
1966425 | 1966425 | 2021-11-30 | District of Columbia | District of Columbia | 11001 | 66912 | 1196 |
1963173 | 1963173 | 2021-11-29 | District of Columbia | District of Columbia | 11001 | 66857 | 1196 |
1959922 | 1959922 | 2021-11-28 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1962148 | 1962148 | 2021-11-28 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1956671 | 1956671 | 2021-11-27 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1958897 | 1958897 | 2021-11-27 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1953420 | 1953420 | 2021-11-26 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1955646 | 1955646 | 2021-11-26 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1950169 | 1950169 | 2021-11-25 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1952395 | 1952395 | 2021-11-25 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1946918 | 1946918 | 2021-11-24 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1949144 | 1949144 | 2021-11-24 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1943667 | 1943667 | 2021-11-23 | District of Columbia | District of Columbia | 11001 | 66433 | 1196 |
1940417 | 1940417 | 2021-11-22 | District of Columbia | District of Columbia | 11001 | 66347 | 1196 |
1937167 | 1937167 | 2021-11-21 | District of Columbia | District of Columbia | 11001 | 66028 | 1196 |
1933917 | 1933917 | 2021-11-20 | District of Columbia | District of Columbia | 11001 | 66028 | 1196 |
1930665 | 1930665 | 2021-11-19 | District of Columbia | District of Columbia | 11001 | 66028 | 1196 |
1927415 | 1927415 | 2021-11-18 | District of Columbia | District of Columbia | 11001 | 65889 | 1196 |
1863976 | 1863976 | 2021-10-29 | Monroe | New York | 36055 | 85994 | 1196 |
1758563 | 1758563 | 2021-09-27 | DeKalb | Georgia | 13089 | 87586 | 1196 |
1738685 | 1738685 | 2021-09-21 | Mobile | Alabama | 1097 | 70288 | 1196 |
1712882 | 1712882 | 2021-09-13 | Stanislaus | California | 6099 | 78924 | 1196 |
1682459 | 1682459 | 2021-09-03 | Lancaster | Pennsylvania | 42071 | 59982 | 1196 |
1649902 | 1649902 | 2021-08-24 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1646653 | 1646653 | 2021-08-23 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1643404 | 1643404 | 2021-08-22 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1640154 | 1640154 | 2021-08-21 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1636904 | 1636904 | 2021-08-20 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1633654 | 1633654 | 2021-08-19 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1630407 | 1630407 | 2021-08-18 | Tulsa | Oklahoma | 40143 | 87935 | 1196 |
1404604 | 1404604 | 2021-06-10 | Gwinnett | Georgia | 13135 | 102988 | 1196 |
1110478 | 1110478 | 2021-03-11 | Camden | New Jersey | 34007 | 45497 | 1196 |
1065326 | 1065326 | 2021-02-25 | Franklin | Ohio | 39049 | 111312 | 1196 |
989213 | 989213 | 2021-02-02 | DuPage | Illinois | 17043 | 72732 | 1196 |
985966 | 985966 | 2021-02-01 | DuPage | Illinois | 17043 | 72610 | 1196 |
954110 | 954110 | 2021-01-22 | Prince George's | Maryland | 24033 | 64830 | 1196 |
928158 | 928158 | 2021-01-14 | Bristol | Massachusetts | 25005 | 43148 | 1196 |
804840 | 804840 | 2020-12-07 | Norfolk | Massachusetts | 25021 | 18383 | 1196 |
801595 | 801595 | 2020-12-06 | Norfolk | Massachusetts | 25021 | 18180 | 1196 |
713983 | 713983 | 2020-11-09 | Worcester | Massachusetts | 25027 | 18474 | 1196 |
568103 | 568103 | 2020-09-25 | Oakland | Michigan | 26125 | 20442 | 1196 |
564863 | 564863 | 2020-09-24 | Oakland | Michigan | 26125 | 20346 | 1196 |
561623 | 561623 | 2020-09-23 | Oakland | Michigan | 26125 | 20235 | 1196 |
528321 | 528321 | 2020-09-13 | Palm Beach | Florida | 12099 | 44023 | 1196 |
525085 | 525085 | 2020-09-12 | Palm Beach | Florida | 12099 | 43871 | 1196 |
307783 | 307783 | 2020-07-06 | Passaic | New Jersey | 34031 | 17110 | 1196 |
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);