ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 1548 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- California 5
- Georgia 5
- Massachusetts 5
- New York 5
- Wisconsin 4
- Michigan 3
- Pennsylvania 3
- South Carolina 3
- Florida 2
- Alabama 1
- Connecticut 1
- Illinois 1
- Minnesota 1
- New Jersey 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502040 | 2502040 | 2022-05-13 | Spartanburg | South Carolina | 45083 | 95357 | 1548 |
2498782 | 2498782 | 2022-05-12 | Spartanburg | South Carolina | 45083 | 95357 | 1548 |
2495524 | 2495524 | 2022-05-11 | Spartanburg | South Carolina | 45083 | 95357 | 1548 |
2354943 | 2354943 | 2022-03-29 | Monroe | New York | 36055 | 150972 | 1548 |
2351690 | 2351690 | 2022-03-28 | Monroe | New York | 36055 | 150904 | 1548 |
2348438 | 2348438 | 2022-03-27 | Monroe | New York | 36055 | 150831 | 1548 |
2345185 | 2345185 | 2022-03-26 | Monroe | New York | 36055 | 150735 | 1548 |
2242537 | 2242537 | 2022-02-23 | Mobile | Alabama | 1097 | 111585 | 1548 |
2233169 | 2233169 | 2022-02-20 | DeKalb | Georgia | 13089 | 144239 | 1548 |
2229918 | 2229918 | 2022-02-19 | DeKalb | Georgia | 13089 | 144239 | 1548 |
2226667 | 2226667 | 2022-02-18 | DeKalb | Georgia | 13089 | 144239 | 1548 |
2222004 | 2222004 | 2022-02-16 | Berks | Pennsylvania | 42011 | 100946 | 1548 |
2168112 | 2168112 | 2022-01-31 | Cobb | Georgia | 13067 | 163506 | 1548 |
2086993 | 2086993 | 2022-01-06 | DuPage | Illinois | 17043 | 157094 | 1548 |
1899086 | 1899086 | 2021-11-09 | Plymouth | Massachusetts | 25023 | 60488 | 1548 |
1780820 | 1780820 | 2021-10-03 | Milwaukee | Wisconsin | 55079 | 143120 | 1548 |
1777570 | 1777570 | 2021-10-02 | Milwaukee | Wisconsin | 55079 | 143120 | 1548 |
1774320 | 1774320 | 2021-10-01 | Milwaukee | Wisconsin | 55079 | 143120 | 1548 |
1771070 | 1771070 | 2021-09-30 | Milwaukee | Wisconsin | 55079 | 142712 | 1548 |
1700104 | 1700104 | 2021-09-09 | Fulton | Georgia | 13121 | 121118 | 1548 |
1696630 | 1696630 | 2021-09-08 | San Joaquin | California | 6077 | 94105 | 1548 |
1693382 | 1693382 | 2021-09-07 | San Joaquin | California | 6077 | 93930 | 1548 |
1690133 | 1690133 | 2021-09-06 | San Joaquin | California | 6077 | 93758 | 1548 |
1686883 | 1686883 | 2021-09-05 | San Joaquin | California | 6077 | 93483 | 1548 |
1609933 | 1609933 | 2021-08-12 | Hampden | Massachusetts | 25013 | 54207 | 1548 |
1606685 | 1606685 | 2021-08-11 | Hampden | Massachusetts | 25013 | 54089 | 1548 |
1329314 | 1329314 | 2021-05-17 | King | Washington | 53033 | 107368 | 1548 |
1153496 | 1153496 | 2021-03-24 | Shelby | Tennessee | 47157 | 90497 | 1548 |
1121890 | 1121890 | 2021-03-15 | Sacramento | California | 6067 | 95440 | 1548 |
1109034 | 1109034 | 2021-03-11 | Hillsborough | Florida | 12057 | 114724 | 1548 |
1078531 | 1078531 | 2021-03-01 | Montgomery | Pennsylvania | 42091 | 54030 | 1548 |
1075286 | 1075286 | 2021-02-28 | Montgomery | Pennsylvania | 42091 | 53921 | 1548 |
1002928 | 1002928 | 2021-02-06 | Hennepin | Minnesota | 27053 | 97000 | 1548 |
973601 | 973601 | 2021-01-28 | Suffolk | Massachusetts | 25025 | 70398 | 1548 |
944959 | 944959 | 2021-01-19 | Passaic | New Jersey | 34031 | 48089 | 1548 |
863314 | 863314 | 2020-12-25 | Macomb | Michigan | 26099 | 48331 | 1548 |
860069 | 860069 | 2020-12-24 | Macomb | Michigan | 26099 | 48331 | 1548 |
856824 | 856824 | 2020-12-23 | Macomb | Michigan | 26099 | 48331 | 1548 |
830800 | 830800 | 2020-12-15 | Essex | Massachusetts | 25009 | 46814 | 1548 |
745497 | 745497 | 2020-11-19 | Hartford | Connecticut | 9003 | 24706 | 1548 |
709826 | 709826 | 2020-11-08 | Broward | Florida | 12011 | 90997 | 1548 |
270042 | 270042 | 2020-06-24 | Westchester | New York | 36119 | 34596 | 1548 |
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);