ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 1788 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Georgia 7
- Oklahoma 7
- Ohio 4
- Illinois 3
- Massachusetts 3
- Minnesota 3
- New York 3
- Indiana 2
- New Jersey 2
- Pennsylvania 2
- Alabama 1
- California 1
- Maryland 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444631 | 2444631 | 2022-04-26 | Cobb | Georgia | 13067 | 174754 | 1788 |
2445445 | 2445445 | 2022-04-26 | Hampden | Massachusetts | 25013 | 135131 | 1788 |
2441375 | 2441375 | 2022-04-25 | Cobb | Georgia | 13067 | 174754 | 1788 |
2438119 | 2438119 | 2022-04-24 | Cobb | Georgia | 13067 | 174757 | 1788 |
2434863 | 2434863 | 2022-04-23 | Cobb | Georgia | 13067 | 174757 | 1788 |
2431607 | 2431607 | 2022-04-22 | Cobb | Georgia | 13067 | 174757 | 1788 |
2428351 | 2428351 | 2022-04-21 | Cobb | Georgia | 13067 | 174757 | 1788 |
2425095 | 2425095 | 2022-04-20 | Cobb | Georgia | 13067 | 174757 | 1788 |
2405759 | 2405759 | 2022-04-14 | DuPage | Illinois | 17043 | 211805 | 1788 |
2402504 | 2402504 | 2022-04-13 | DuPage | Illinois | 17043 | 211415 | 1788 |
2399249 | 2399249 | 2022-04-12 | DuPage | Illinois | 17043 | 211246 | 1788 |
2397170 | 2397170 | 2022-04-11 | Camden | New Jersey | 34007 | 125930 | 1788 |
2097344 | 2097344 | 2022-01-09 | Montgomery | Maryland | 24031 | 130947 | 1788 |
2013832 | 2013832 | 2021-12-14 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
2010581 | 2010581 | 2021-12-13 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
2007330 | 2007330 | 2021-12-12 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
2004079 | 2004079 | 2021-12-11 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
2000828 | 2000828 | 2021-12-10 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
1997578 | 1997578 | 2021-12-09 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
1993908 | 1993908 | 2021-12-08 | Monmouth | New Jersey | 34025 | 101071 | 1788 |
1994327 | 1994327 | 2021-12-08 | Tulsa | Oklahoma | 40143 | 113212 | 1788 |
1919431 | 1919431 | 2021-11-15 | Franklin | Ohio | 39049 | 170832 | 1788 |
1916181 | 1916181 | 2021-11-14 | Franklin | Ohio | 39049 | 170486 | 1788 |
1912931 | 1912931 | 2021-11-13 | Franklin | Ohio | 39049 | 170249 | 1788 |
1909681 | 1909681 | 2021-11-12 | Franklin | Ohio | 39049 | 169949 | 1788 |
1770186 | 1770186 | 2021-09-30 | Montgomery | Pennsylvania | 42091 | 80719 | 1788 |
1766937 | 1766937 | 2021-09-29 | Montgomery | Pennsylvania | 42091 | 80576 | 1788 |
1761414 | 1761414 | 2021-09-28 | Jefferson | Alabama | 1073 | 111953 | 1788 |
1579677 | 1579677 | 2021-08-03 | Sacramento | California | 6067 | 119572 | 1788 |
1473656 | 1473656 | 2021-07-01 | Hennepin | Minnesota | 27053 | 125221 | 1788 |
1470410 | 1470410 | 2021-06-30 | Hennepin | Minnesota | 27053 | 125204 | 1788 |
1463920 | 1463920 | 2021-06-28 | Hennepin | Minnesota | 27053 | 125156 | 1788 |
1360568 | 1360568 | 2021-05-27 | Erie | New York | 36029 | 89142 | 1788 |
1357322 | 1357322 | 2021-05-26 | Erie | New York | 36029 | 89087 | 1788 |
1354076 | 1354076 | 2021-05-25 | Erie | New York | 36029 | 89031 | 1788 |
1249072 | 1249072 | 2021-04-23 | Marion | Indiana | 18097 | 97386 | 1788 |
1245825 | 1245825 | 2021-04-22 | Marion | Indiana | 18097 | 97222 | 1788 |
1174864 | 1174864 | 2021-03-31 | Suffolk | Massachusetts | 25025 | 84646 | 1788 |
838739 | 838739 | 2020-12-17 | Dallas | Texas | 48113 | 166230 | 1788 |
250671 | 250671 | 2020-06-18 | Middlesex | Massachusetts | 25017 | 23407 | 1788 |
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);