ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 1621 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Utah 9
- South Carolina 7
- Georgia 4
- Maryland 4
- New Jersey 4
- Massachusetts 3
- North Carolina 3
- Pennsylvania 2
- Colorado 1
- Florida 1
- Minnesota 1
- New York 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501545 | 2501545 | 2022-05-13 | Mecklenburg | North Carolina | 37119 | 284986 | 1621 |
2498287 | 2498287 | 2022-05-12 | Mecklenburg | North Carolina | 37119 | 284986 | 1621 |
2495029 | 2495029 | 2022-05-11 | Mecklenburg | North Carolina | 37119 | 284986 | 1621 |
2428193 | 2428193 | 2022-04-21 | El Paso | Colorado | 8041 | 186395 | 1621 |
2381996 | 2381996 | 2022-04-06 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2378741 | 2378741 | 2022-04-05 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2375487 | 2375487 | 2022-04-04 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2372235 | 2372235 | 2022-04-03 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2368982 | 2368982 | 2022-04-02 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2365729 | 2365729 | 2022-04-01 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2362476 | 2362476 | 2022-03-31 | Salt Lake | Utah | 49035 | 341302 | 1621 |
2359222 | 2359222 | 2022-03-30 | Salt Lake | Utah | 49035 | 341243 | 1621 |
2355968 | 2355968 | 2022-03-29 | Salt Lake | Utah | 49035 | 341182 | 1621 |
2213653 | 2213653 | 2022-02-14 | Cobb | Georgia | 13067 | 168011 | 1621 |
2157111 | 2157111 | 2022-01-27 | Greenville | South Carolina | 45045 | 158094 | 1621 |
2153858 | 2153858 | 2022-01-26 | Greenville | South Carolina | 45045 | 157063 | 1621 |
2150606 | 2150606 | 2022-01-25 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2147354 | 2147354 | 2022-01-24 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2144100 | 2144100 | 2022-01-23 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2140845 | 2140845 | 2022-01-22 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2137589 | 2137589 | 2022-01-21 | Greenville | South Carolina | 45045 | 149844 | 1621 |
2114670 | 2114670 | 2022-01-14 | Delaware | Pennsylvania | 42045 | 97865 | 1621 |
2019349 | 2019349 | 2021-12-16 | Plymouth | Massachusetts | 25023 | 70980 | 1621 |
1769111 | 1769111 | 2021-09-30 | Hampden | Massachusetts | 25013 | 62663 | 1621 |
1755332 | 1755332 | 2021-09-26 | Fulton | Georgia | 13121 | 126616 | 1621 |
1752084 | 1752084 | 2021-09-25 | Fulton | Georgia | 13121 | 126616 | 1621 |
1748835 | 1748835 | 2021-09-24 | Fulton | Georgia | 13121 | 126616 | 1621 |
1441069 | 1441069 | 2021-06-21 | Montgomery | Maryland | 24031 | 71161 | 1621 |
1437823 | 1437823 | 2021-06-20 | Montgomery | Maryland | 24031 | 71156 | 1621 |
1434576 | 1434576 | 2021-06-19 | Montgomery | Maryland | 24031 | 71148 | 1621 |
1431329 | 1431329 | 2021-06-18 | Montgomery | Maryland | 24031 | 71140 | 1621 |
1363758 | 1363758 | 2021-05-28 | Monmouth | New Jersey | 34025 | 75426 | 1621 |
1360512 | 1360512 | 2021-05-27 | Monmouth | New Jersey | 34025 | 75415 | 1621 |
1190208 | 1190208 | 2021-04-05 | Hillsborough | Florida | 12057 | 123770 | 1621 |
1106791 | 1106791 | 2021-03-10 | Hennepin | Minnesota | 27053 | 102270 | 1621 |
1100805 | 1100805 | 2021-03-08 | Erie | New York | 36029 | 66987 | 1621 |
1077462 | 1077462 | 2021-03-01 | Norfolk | Massachusetts | 25021 | 45602 | 1621 |
1029617 | 1029617 | 2021-02-14 | Cuyahoga | Ohio | 39035 | 92699 | 1621 |
944963 | 944963 | 2021-01-19 | Union | New Jersey | 34039 | 47928 | 1621 |
311448 | 311448 | 2020-07-07 | Philadelphia | Pennsylvania | 42101 | 26901 | 1621 |
220114 | 220114 | 2020-06-08 | Bergen | New Jersey | 34003 | 18538 | 1621 |
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);