ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 1776 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Maryland 10
- New Jersey 6
- Massachusetts 5
- Georgia 4
- California 2
- Missouri 2
- Pennsylvania 2
- Florida 1
- Indiana 1
- New York 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497526 | 2497526 | 2022-05-12 | Baltimore city | Maryland | 24510 | 116321 | 1776 |
2494268 | 2494268 | 2022-05-11 | Baltimore city | Maryland | 24510 | 116053 | 1776 |
2491010 | 2491010 | 2022-05-10 | Baltimore city | Maryland | 24510 | 115782 | 1776 |
2487753 | 2487753 | 2022-05-09 | Baltimore city | Maryland | 24510 | 115286 | 1776 |
2484495 | 2484495 | 2022-05-08 | Baltimore city | Maryland | 24510 | 114991 | 1776 |
2481237 | 2481237 | 2022-05-07 | Baltimore city | Maryland | 24510 | 114991 | 1776 |
2477979 | 2477979 | 2022-05-06 | Baltimore city | Maryland | 24510 | 114991 | 1776 |
2402304 | 2402304 | 2022-04-13 | Cobb | Georgia | 13067 | 174413 | 1776 |
2299566 | 2299566 | 2022-03-12 | Camden | New Jersey | 34007 | 124604 | 1776 |
2296314 | 2296314 | 2022-03-11 | Camden | New Jersey | 34007 | 124604 | 1776 |
2278444 | 2278444 | 2022-03-06 | Alameda | California | 6001 | 265611 | 1776 |
2259494 | 2259494 | 2022-02-28 | Lake | Indiana | 18089 | 105510 | 1776 |
2040808 | 2040808 | 2021-12-22 | Milwaukee | Wisconsin | 55079 | 173865 | 1776 |
1958154 | 1958154 | 2021-11-27 | Monmouth | New Jersey | 34025 | 97353 | 1776 |
1869051 | 1869051 | 2021-10-31 | Fulton | Georgia | 13121 | 132239 | 1776 |
1865802 | 1865802 | 2021-10-30 | Fulton | Georgia | 13121 | 132239 | 1776 |
1862553 | 1862553 | 2021-10-29 | Fulton | Georgia | 13121 | 132239 | 1776 |
1782081 | 1782081 | 2021-10-04 | Baltimore | Maryland | 24005 | 74196 | 1776 |
1778831 | 1778831 | 2021-10-03 | Baltimore | Maryland | 24005 | 74098 | 1776 |
1775581 | 1775581 | 2021-10-02 | Baltimore | Maryland | 24005 | 73978 | 1776 |
1740947 | 1740947 | 2021-09-21 | Montgomery | Pennsylvania | 42091 | 79239 | 1776 |
1321607 | 1321607 | 2021-05-15 | Erie | New York | 36029 | 88350 | 1776 |
1288520 | 1288520 | 2021-05-05 | Norfolk | Massachusetts | 25021 | 54015 | 1776 |
1285274 | 1285274 | 2021-05-04 | Norfolk | Massachusetts | 25021 | 53947 | 1776 |
1282028 | 1282028 | 2021-05-03 | Norfolk | Massachusetts | 25021 | 53890 | 1776 |
1162439 | 1162439 | 2021-03-27 | Passaic | New Jersey | 34031 | 63225 | 1776 |
1158625 | 1158625 | 2021-03-26 | Suffolk | Massachusetts | 25025 | 83361 | 1776 |
1159191 | 1159191 | 2021-03-26 | Passaic | New Jersey | 34031 | 62933 | 1776 |
1016157 | 1016157 | 2021-02-10 | St. Louis | Missouri | 29189 | 85740 | 1776 |
1012912 | 1012912 | 2021-02-09 | St. Louis | Missouri | 29189 | 85342 | 1776 |
972583 | 972583 | 2021-01-28 | San Bernardino | California | 6071 | 271189 | 1776 |
922239 | 922239 | 2021-01-12 | Middlesex | New Jersey | 34023 | 54224 | 1776 |
908689 | 908689 | 2021-01-08 | Essex | Massachusetts | 25009 | 64512 | 1776 |
846125 | 846125 | 2020-12-20 | Broward | Florida | 12011 | 127240 | 1776 |
510843 | 510843 | 2020-09-07 | Philadelphia | Pennsylvania | 42101 | 34699 | 1776 |
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);