ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where deaths = 1500 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Texas 10
- New Jersey 9
- Michigan 5
- Maryland 4
- Ohio 4
- New York 3
- Pennsylvania 3
- California 2
- Georgia 2
- Massachusetts 2
- Florida 1
- Kentucky 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469337 | 2469337 | 2022-05-03 | York | Pennsylvania | 42133 | 119653 | 1500 |
2388277 | 2388277 | 2022-04-08 | Collin | Texas | 48085 | 211296 | 1500 |
2385022 | 2385022 | 2022-04-07 | Collin | Texas | 48085 | 211099 | 1500 |
2381767 | 2381767 | 2022-04-06 | Collin | Texas | 48085 | 210708 | 1500 |
2325075 | 2325075 | 2022-03-20 | Kent | Michigan | 26081 | 165766 | 1500 |
2321821 | 2321821 | 2022-03-19 | Kent | Michigan | 26081 | 165766 | 1500 |
2318567 | 2318567 | 2022-03-18 | Kent | Michigan | 26081 | 165766 | 1500 |
2228040 | 2228040 | 2022-02-18 | Morris | New Jersey | 34027 | 115616 | 1500 |
2189077 | 2189077 | 2022-02-06 | Monroe | New York | 36055 | 146949 | 1500 |
2176468 | 2176468 | 2022-02-02 | Berks | Pennsylvania | 42011 | 99421 | 1500 |
2149433 | 2149433 | 2022-01-25 | Genesee | Michigan | 26049 | 92689 | 1500 |
2146181 | 2146181 | 2022-01-24 | Genesee | Michigan | 26049 | 92689 | 1500 |
2076215 | 2076215 | 2022-01-02 | Travis | Texas | 48453 | 133466 | 1500 |
2072964 | 2072964 | 2022-01-01 | Travis | Texas | 48453 | 133466 | 1500 |
2069713 | 2069713 | 2021-12-31 | Travis | Texas | 48453 | 133466 | 1500 |
2066462 | 2066462 | 2021-12-30 | Travis | Texas | 48453 | 133466 | 1500 |
2063212 | 2063212 | 2021-12-29 | Travis | Texas | 48453 | 132862 | 1500 |
2059962 | 2059962 | 2021-12-28 | Travis | Texas | 48453 | 132230 | 1500 |
2056713 | 2056713 | 2021-12-27 | Travis | Texas | 48453 | 131434 | 1500 |
2019905 | 2019905 | 2021-12-16 | Camden | New Jersey | 34007 | 76223 | 1500 |
1956536 | 1956536 | 2021-11-27 | Alameda | California | 6001 | 124679 | 1500 |
1953285 | 1953285 | 2021-11-26 | Alameda | California | 6001 | 124679 | 1500 |
1762435 | 1762435 | 2021-09-28 | Jefferson | Kentucky | 21111 | 111388 | 1500 |
1609150 | 1609150 | 2021-08-12 | Fulton | Georgia | 13121 | 108325 | 1500 |
1610785 | 1610785 | 2021-08-12 | Franklin | Ohio | 39049 | 133426 | 1500 |
1605901 | 1605901 | 2021-08-11 | Fulton | Georgia | 13121 | 107912 | 1500 |
1607537 | 1607537 | 2021-08-11 | Franklin | Ohio | 39049 | 133083 | 1500 |
1604288 | 1604288 | 2021-08-10 | Franklin | Ohio | 39049 | 132759 | 1500 |
1356681 | 1356681 | 2021-05-26 | Prince George's | Maryland | 24033 | 84908 | 1500 |
1307965 | 1307965 | 2021-05-11 | Baltimore | Maryland | 24005 | 64672 | 1500 |
1307994 | 1307994 | 2021-05-11 | Hampden | Massachusetts | 25013 | 51433 | 1500 |
1304748 | 1304748 | 2021-05-10 | Hampden | Massachusetts | 25013 | 51410 | 1500 |
1236550 | 1236550 | 2021-04-19 | Montgomery | Maryland | 24031 | 68911 | 1500 |
1238407 | 1238407 | 2021-04-19 | King | Washington | 53033 | 97232 | 1500 |
1233303 | 1233303 | 2021-04-18 | Montgomery | Maryland | 24031 | 68888 | 1500 |
1178674 | 1178674 | 2021-04-01 | Monmouth | New Jersey | 34025 | 68357 | 1500 |
1082074 | 1082074 | 2021-03-02 | Shelby | Tennessee | 47157 | 88214 | 1500 |
1023125 | 1023125 | 2021-02-12 | Cuyahoga | Ohio | 39035 | 92243 | 1500 |
977869 | 977869 | 2021-01-29 | Allegheny | Pennsylvania | 42003 | 68809 | 1500 |
841116 | 841116 | 2020-12-18 | Union | New Jersey | 34039 | 33923 | 1500 |
789179 | 789179 | 2020-12-02 | Middlesex | New Jersey | 34023 | 31783 | 1500 |
760072 | 760072 | 2020-11-23 | Westchester | New York | 36119 | 47261 | 1500 |
756826 | 756826 | 2020-11-22 | Westchester | New York | 36119 | 46840 | 1500 |
635212 | 635212 | 2020-10-16 | Broward | Florida | 12011 | 80443 | 1500 |
387717 | 387717 | 2020-07-31 | Hudson | New Jersey | 34017 | 19647 | 1500 |
381282 | 381282 | 2020-07-29 | Hudson | New Jersey | 34017 | 19599 | 1500 |
355600 | 355600 | 2020-07-21 | Hudson | New Jersey | 34017 | 19452 | 1500 |
161930 | 161930 | 2020-05-20 | Bergen | New Jersey | 34003 | 17518 | 1500 |
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);