ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 2010 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Ohio 7
- Rhode Island 7
- New Jersey 6
- California 3
- New York 3
- Massachusetts 2
- Connecticut 1
- Maryland 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449589 | 2449589 | 2022-04-27 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2446332 | 2446332 | 2022-04-26 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2443077 | 2443077 | 2022-04-25 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2439821 | 2439821 | 2022-04-24 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2436565 | 2436565 | 2022-04-23 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2433309 | 2433309 | 2022-04-22 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2430053 | 2430053 | 2022-04-21 | Montgomery | Ohio | 39113 | 127061 | 2010 |
2318502 | 2318502 | 2022-03-18 | Montgomery | Maryland | 24031 | 166295 | 2010 |
2217716 | 2217716 | 2022-02-15 | Hampden | Massachusetts | 25013 | 129982 | 2010 |
2172747 | 2172747 | 2022-02-01 | Monmouth | New Jersey | 34025 | 157930 | 2010 |
2081107 | 2081107 | 2022-01-04 | Suffolk | Massachusetts | 25025 | 147263 | 2010 |
1709619 | 1709619 | 2021-09-12 | Sacramento | California | 6067 | 146958 | 2010 |
1706372 | 1706372 | 2021-09-11 | Sacramento | California | 6067 | 146645 | 2010 |
1703124 | 1703124 | 2021-09-10 | Sacramento | California | 6067 | 146129 | 2010 |
1691720 | 1691720 | 2021-09-06 | Union | New Jersey | 34039 | 76096 | 2010 |
1688470 | 1688470 | 2021-09-05 | Union | New Jersey | 34039 | 75988 | 2010 |
1685220 | 1685220 | 2021-09-04 | Union | New Jersey | 34039 | 75901 | 2010 |
1627352 | 1627352 | 2021-08-17 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1624105 | 1624105 | 2021-08-16 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1620858 | 1620858 | 2021-08-15 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1617610 | 1617610 | 2021-08-14 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1614362 | 1614362 | 2021-08-13 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1611113 | 1611113 | 2021-08-12 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1607865 | 1607865 | 2021-08-11 | Providence | Rhode Island | 44007 | 101727 | 2010 |
1451851 | 1451851 | 2021-06-24 | Allegheny | Pennsylvania | 42003 | 101821 | 2010 |
1194914 | 1194914 | 2021-04-06 | Ocean | New Jersey | 34029 | 70250 | 2010 |
1037585 | 1037585 | 2021-02-17 | Fairfield | Connecticut | 9001 | 77597 | 2010 |
1022949 | 1022949 | 2021-02-12 | Westchester | New York | 36119 | 100503 | 2010 |
533072 | 533072 | 2020-09-14 | Suffolk | New York | 36103 | 45714 | 2010 |
314108 | 314108 | 2020-07-08 | Bergen | New Jersey | 34003 | 19993 | 2010 |
251279 | 251279 | 2020-06-18 | Suffolk | New York | 36103 | 40810 | 2010 |
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);