ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 1819 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Georgia 7
- New Mexico 6
- Pennsylvania 5
- Indiana 3
- Maryland 2
- Massachusetts 2
- Minnesota 2
- Florida 1
- New Jersey 1
- New York 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499998 | 2499998 | 2022-05-13 | Cobb | Georgia | 13067 | 176832 | 1819 |
2496740 | 2496740 | 2022-05-12 | Cobb | Georgia | 13067 | 176832 | 1819 |
2493482 | 2493482 | 2022-05-11 | Cobb | Georgia | 13067 | 176832 | 1819 |
2449283 | 2449283 | 2022-04-27 | Bernalillo | New Mexico | 35001 | 147755 | 1819 |
2446026 | 2446026 | 2022-04-26 | Bernalillo | New Mexico | 35001 | 147755 | 1819 |
2442771 | 2442771 | 2022-04-25 | Bernalillo | New Mexico | 35001 | 147755 | 1819 |
2438446 | 2438446 | 2022-04-24 | Lake | Indiana | 18089 | 106656 | 1819 |
2439515 | 2439515 | 2022-04-24 | Bernalillo | New Mexico | 35001 | 147598 | 1819 |
2435190 | 2435190 | 2022-04-23 | Lake | Indiana | 18089 | 106656 | 1819 |
2436259 | 2436259 | 2022-04-23 | Bernalillo | New Mexico | 35001 | 147598 | 1819 |
2431934 | 2431934 | 2022-04-22 | Lake | Indiana | 18089 | 106656 | 1819 |
2433003 | 2433003 | 2022-04-22 | Bernalillo | New Mexico | 35001 | 147598 | 1819 |
2261033 | 2261033 | 2022-02-28 | Delaware | Pennsylvania | 42045 | 108809 | 1819 |
2257782 | 2257782 | 2022-02-27 | Delaware | Pennsylvania | 42045 | 108791 | 1819 |
2254531 | 2254531 | 2022-02-26 | Delaware | Pennsylvania | 42045 | 108768 | 1819 |
2251280 | 2251280 | 2022-02-25 | Delaware | Pennsylvania | 42045 | 108698 | 1819 |
2100596 | 2100596 | 2022-01-10 | Prince George's | Maryland | 24033 | 146908 | 1819 |
1937295 | 1937295 | 2021-11-21 | Fulton | Georgia | 13121 | 134092 | 1819 |
1934045 | 1934045 | 2021-11-20 | Fulton | Georgia | 13121 | 134092 | 1819 |
1930793 | 1930793 | 2021-11-19 | Fulton | Georgia | 13121 | 134092 | 1819 |
1927543 | 1927543 | 2021-11-18 | Fulton | Georgia | 13121 | 133945 | 1819 |
1830816 | 1830816 | 2021-10-19 | Baltimore | Maryland | 24005 | 75854 | 1819 |
1812427 | 1812427 | 2021-10-13 | Montgomery | Pennsylvania | 42091 | 82998 | 1819 |
1629538 | 1629538 | 2021-08-18 | Hennepin | Minnesota | 27053 | 131251 | 1819 |
1626291 | 1626291 | 2021-08-17 | Hennepin | Minnesota | 27053 | 131024 | 1819 |
1275536 | 1275536 | 2021-05-01 | Suffolk | Massachusetts | 25025 | 90988 | 1819 |
1207909 | 1207909 | 2021-04-10 | Passaic | New Jersey | 34031 | 67167 | 1819 |
948302 | 948302 | 2021-01-20 | Westchester | New York | 36119 | 85722 | 1819 |
921669 | 921669 | 2021-01-12 | Essex | Massachusetts | 25009 | 67475 | 1819 |
913393 | 913393 | 2021-01-09 | El Paso | Texas | 48141 | 102889 | 1819 |
846169 | 846169 | 2020-12-20 | Palm Beach | Florida | 12099 | 76600 | 1819 |
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);