ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 1812 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- New York 17
- Florida 9
- New Jersey 5
- California 3
- Massachusetts 3
- Indiana 1
- Maryland 1
- Michigan 1
- Pennsylvania 1
- Puerto Rico 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2350566 | 2350566 | 2022-03-28 | Lake | Indiana | 18089 | 106118 | 1812 |
2058916 | 2058916 | 2021-12-28 | Monmouth | New Jersey | 34025 | 114570 | 1812 |
1891703 | 1891703 | 2021-11-07 | Lee | Florida | 12071 | 125270 | 1812 |
1888453 | 1888453 | 2021-11-06 | Lee | Florida | 12071 | 125270 | 1812 |
1885203 | 1885203 | 2021-11-05 | Lee | Florida | 12071 | 125270 | 1812 |
1881954 | 1881954 | 2021-11-04 | Lee | Florida | 12071 | 124961 | 1812 |
1878705 | 1878705 | 2021-11-03 | Lee | Florida | 12071 | 124961 | 1812 |
1875456 | 1875456 | 2021-11-02 | Lee | Florida | 12071 | 124961 | 1812 |
1872207 | 1872207 | 2021-11-01 | Lee | Florida | 12071 | 124961 | 1812 |
1868958 | 1868958 | 2021-10-31 | Lee | Florida | 12071 | 124961 | 1812 |
1817820 | 1817820 | 2021-10-15 | Baltimore | Maryland | 24005 | 75506 | 1812 |
1618665 | 1618665 | 2021-08-15 | Sacramento | California | 6067 | 125867 | 1812 |
1615417 | 1615417 | 2021-08-14 | Sacramento | California | 6067 | 125297 | 1812 |
1612168 | 1612168 | 2021-08-13 | Sacramento | California | 6067 | 124651 | 1812 |
1606689 | 1606689 | 2021-08-11 | Norfolk | Massachusetts | 25021 | 56612 | 1812 |
1509873 | 1509873 | 2021-07-12 | Erie | New York | 36029 | 89806 | 1812 |
1506626 | 1506626 | 2021-07-11 | Erie | New York | 36029 | 89795 | 1812 |
1503380 | 1503380 | 2021-07-10 | Erie | New York | 36029 | 89785 | 1812 |
1500134 | 1500134 | 2021-07-09 | Erie | New York | 36029 | 89775 | 1812 |
1496888 | 1496888 | 2021-07-08 | Erie | New York | 36029 | 89755 | 1812 |
1493641 | 1493641 | 2021-07-07 | Erie | New York | 36029 | 89749 | 1812 |
1490394 | 1490394 | 2021-07-06 | Erie | New York | 36029 | 89737 | 1812 |
1487147 | 1487147 | 2021-07-05 | Erie | New York | 36029 | 89729 | 1812 |
1483901 | 1483901 | 2021-07-04 | Erie | New York | 36029 | 89717 | 1812 |
1480655 | 1480655 | 2021-07-03 | Erie | New York | 36029 | 89704 | 1812 |
1477408 | 1477408 | 2021-07-02 | Erie | New York | 36029 | 89695 | 1812 |
1474162 | 1474162 | 2021-07-01 | Erie | New York | 36029 | 89678 | 1812 |
1470916 | 1470916 | 2021-06-30 | Erie | New York | 36029 | 89668 | 1812 |
1467671 | 1467671 | 2021-06-29 | Erie | New York | 36029 | 89665 | 1812 |
1464426 | 1464426 | 2021-06-28 | Erie | New York | 36029 | 89660 | 1812 |
1461181 | 1461181 | 2021-06-27 | Erie | New York | 36029 | 89651 | 1812 |
1457936 | 1457936 | 2021-06-26 | Erie | New York | 36029 | 89638 | 1812 |
1352567 | 1352567 | 2021-05-25 | Hillsborough | Florida | 12057 | 142014 | 1812 |
1259301 | 1259301 | 2021-04-26 | Suffolk | Massachusetts | 25025 | 90356 | 1812 |
1201413 | 1201413 | 2021-04-08 | Passaic | New Jersey | 34031 | 66665 | 1812 |
1113740 | 1113740 | 2021-03-12 | Union | New Jersey | 34039 | 59397 | 1812 |
1052064 | 1052064 | 2021-02-21 | Ocean | New Jersey | 34029 | 56646 | 1812 |
978006 | 978006 | 2021-01-29 | Unknown | Puerto Rico | 4260 | 1812 | |
941213 | 941213 | 2021-01-18 | Oakland | Michigan | 26125 | 67674 | 1812 |
938465 | 938465 | 2021-01-17 | Middlesex | New Jersey | 34023 | 57400 | 1812 |
559389 | 559389 | 2020-09-22 | Philadelphia | Pennsylvania | 42101 | 35901 | 1812 |
436942 | 436942 | 2020-08-15 | Harris | Texas | 48201 | 91698 | 1812 |
266287 | 266287 | 2020-06-23 | Middlesex | Massachusetts | 25017 | 23647 | 1812 |
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);