ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where deaths = 1431 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Florida 14
- Ohio 8
- Pennsylvania 6
- Illinois 4
- New Jersey 4
- California 3
- Connecticut 3
- Maryland 3
- Texas 3
- Virginia 2
- Georgia 1
- Michigan 1
- Nevada 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490163 | 2490163 | 2022-05-10 | Manatee | Florida | 12081 | 96960 | 1431 |
2486906 | 2486906 | 2022-05-09 | Manatee | Florida | 12081 | 96960 | 1431 |
2483648 | 2483648 | 2022-05-08 | Manatee | Florida | 12081 | 96960 | 1431 |
2480390 | 2480390 | 2022-05-07 | Manatee | Florida | 12081 | 96960 | 1431 |
2477132 | 2477132 | 2022-05-06 | Manatee | Florida | 12081 | 96960 | 1431 |
2473874 | 2473874 | 2022-05-05 | Manatee | Florida | 12081 | 96100 | 1431 |
2470617 | 2470617 | 2022-05-04 | Manatee | Florida | 12081 | 96100 | 1431 |
2359290 | 2359290 | 2022-03-30 | Fairfax | Virginia | 51059 | 175772 | 1431 |
2356036 | 2356036 | 2022-03-29 | Fairfax | Virginia | 51059 | 175664 | 1431 |
2285118 | 2285118 | 2022-03-08 | Lake | Florida | 12069 | 84142 | 1431 |
2281866 | 2281866 | 2022-03-07 | Lake | Florida | 12069 | 84142 | 1431 |
2278613 | 2278613 | 2022-03-06 | Lake | Florida | 12069 | 84142 | 1431 |
2275360 | 2275360 | 2022-03-05 | Lake | Florida | 12069 | 84142 | 1431 |
2272107 | 2272107 | 2022-03-04 | Lake | Florida | 12069 | 84142 | 1431 |
2268855 | 2268855 | 2022-03-03 | Lake | Florida | 12069 | 83878 | 1431 |
2265602 | 2265602 | 2022-03-02 | Lake | Florida | 12069 | 83878 | 1431 |
2241571 | 2241571 | 2022-02-22 | York | Pennsylvania | 42133 | 117303 | 1431 |
2238320 | 2238320 | 2022-02-21 | York | Pennsylvania | 42133 | 117222 | 1431 |
2235069 | 2235069 | 2022-02-20 | York | Pennsylvania | 42133 | 117222 | 1431 |
2154316 | 2154316 | 2022-01-26 | Salt Lake | Utah | 49035 | 318596 | 1431 |
2149971 | 2149971 | 2022-01-25 | Morris | New Jersey | 34027 | 111862 | 1431 |
2147052 | 2147052 | 2022-01-24 | Stark | Ohio | 39151 | 77100 | 1431 |
2143798 | 2143798 | 2022-01-23 | Stark | Ohio | 39151 | 76873 | 1431 |
2140543 | 2140543 | 2022-01-22 | Stark | Ohio | 39151 | 76632 | 1431 |
2137287 | 2137287 | 2022-01-21 | Stark | Ohio | 39151 | 76361 | 1431 |
2077821 | 2077821 | 2022-01-03 | Baltimore city | Maryland | 24510 | 85595 | 1431 |
2074570 | 2074570 | 2022-01-02 | Baltimore city | Maryland | 24510 | 84171 | 1431 |
1973026 | 1973026 | 2021-12-02 | Cobb | Georgia | 13067 | 112642 | 1431 |
1868203 | 1868203 | 2021-10-30 | Travis | Texas | 48453 | 119762 | 1431 |
1864954 | 1864954 | 2021-10-29 | Travis | Texas | 48453 | 119609 | 1431 |
1851199 | 1851199 | 2021-10-25 | Hamilton | Ohio | 39061 | 105605 | 1431 |
1847949 | 1847949 | 2021-10-24 | Hamilton | Ohio | 39061 | 105489 | 1431 |
1844699 | 1844699 | 2021-10-23 | Hamilton | Ohio | 39061 | 105366 | 1431 |
1841449 | 1841449 | 2021-10-22 | Hamilton | Ohio | 39061 | 105206 | 1431 |
1710022 | 1710022 | 2021-09-12 | DuPage | Illinois | 17043 | 101781 | 1431 |
1706775 | 1706775 | 2021-09-11 | DuPage | Illinois | 17043 | 101781 | 1431 |
1703527 | 1703527 | 2021-09-10 | DuPage | Illinois | 17043 | 101781 | 1431 |
1700277 | 1700277 | 2021-09-09 | DuPage | Illinois | 17043 | 101493 | 1431 |
1653214 | 1653214 | 2021-08-25 | Delaware | Pennsylvania | 42045 | 54969 | 1431 |
1338266 | 1338266 | 2021-05-20 | Delaware | Pennsylvania | 42045 | 51789 | 1431 |
1335019 | 1335019 | 2021-05-19 | Delaware | Pennsylvania | 42045 | 51759 | 1431 |
1249539 | 1249539 | 2021-04-23 | Prince George's | Maryland | 24033 | 82058 | 1431 |
1110487 | 1110487 | 2021-03-11 | Monmouth | New Jersey | 34025 | 60556 | 1431 |
1050478 | 1050478 | 2021-02-21 | Sacramento | California | 6067 | 92056 | 1431 |
1047231 | 1047231 | 2021-02-20 | Sacramento | California | 6067 | 91814 | 1431 |
1043986 | 1043986 | 2021-02-19 | Sacramento | California | 6067 | 91796 | 1431 |
827614 | 827614 | 2020-12-14 | Macomb | Michigan | 26099 | 45516 | 1431 |
769717 | 769717 | 2020-11-26 | Union | New Jersey | 34039 | 27627 | 1431 |
667645 | 667645 | 2020-10-26 | Fairfield | Connecticut | 9001 | 22893 | 1431 |
613982 | 613982 | 2020-10-09 | Middlesex | New Jersey | 34023 | 20428 | 1431 |
610705 | 610705 | 2020-10-08 | Clark | Nevada | 32003 | 70121 | 1431 |
534731 | 534731 | 2020-09-15 | Hartford | Connecticut | 9003 | 14099 | 1431 |
531496 | 531496 | 2020-09-14 | Hartford | Connecticut | 9003 | 14060 | 1431 |
533907 | 533907 | 2020-09-14 | Hidalgo | Texas | 48215 | 29459 | 1431 |
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);