ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where deaths = 1345 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Florida 11
- California 8
- Ohio 8
- Kentucky 7
- New Jersey 6
- Texas 6
- Pennsylvania 4
- Wisconsin 4
- Minnesota 3
- Maryland 2
- Connecticut 1
- Illinois 1
- Indiana 1
- Massachusetts 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491192 | 2491192 | 2022-05-10 | Ramsey | Minnesota | 27123 | 128183 | 1345 |
2398063 | 2398063 | 2022-04-11 | Denton | Texas | 48121 | 179537 | 1345 |
2394808 | 2394808 | 2022-04-10 | Denton | Texas | 48121 | 179444 | 1345 |
2391552 | 2391552 | 2022-04-09 | Denton | Texas | 48121 | 179444 | 1345 |
2388296 | 2388296 | 2022-04-08 | Denton | Texas | 48121 | 179444 | 1345 |
2384659 | 2384659 | 2022-04-07 | Luzerne | Pennsylvania | 42079 | 73449 | 1345 |
2385041 | 2385041 | 2022-04-07 | Denton | Texas | 48121 | 179388 | 1345 |
2365519 | 2365519 | 2022-04-01 | Denton | Texas | 48121 | 179201 | 1345 |
2262357 | 2262357 | 2022-03-01 | Manatee | Florida | 12081 | 94336 | 1345 |
2262381 | 2262381 | 2022-03-01 | Unknown | Florida | 8061 | 1345 | |
2259106 | 2259106 | 2022-02-28 | Manatee | Florida | 12081 | 94336 | 1345 |
2255855 | 2255855 | 2022-02-27 | Manatee | Florida | 12081 | 94336 | 1345 |
2252604 | 2252604 | 2022-02-26 | Manatee | Florida | 12081 | 94336 | 1345 |
2249353 | 2249353 | 2022-02-25 | Manatee | Florida | 12081 | 94336 | 1345 |
2246102 | 2246102 | 2022-02-24 | Manatee | Florida | 12081 | 93876 | 1345 |
2242851 | 2242851 | 2022-02-23 | Manatee | Florida | 12081 | 93876 | 1345 |
2242204 | 2242204 | 2022-02-22 | Fairfax | Virginia | 51059 | 171883 | 1345 |
1919463 | 1919463 | 2021-11-15 | Montgomery | Ohio | 39113 | 77296 | 1345 |
1916213 | 1916213 | 2021-11-14 | Montgomery | Ohio | 39113 | 77203 | 1345 |
1912963 | 1912963 | 2021-11-13 | Montgomery | Ohio | 39113 | 77057 | 1345 |
1909713 | 1909713 | 2021-11-12 | Montgomery | Ohio | 39113 | 76932 | 1345 |
1887147 | 1887147 | 2021-11-05 | Lancaster | Pennsylvania | 42071 | 72597 | 1345 |
1774562 | 1774562 | 2021-10-02 | Alameda | California | 6001 | 118019 | 1345 |
1771312 | 1771312 | 2021-10-01 | Alameda | California | 6001 | 118019 | 1345 |
1679182 | 1679182 | 2021-09-02 | Bucks | Pennsylvania | 42017 | 65170 | 1345 |
1574756 | 1574756 | 2021-08-01 | Camden | New Jersey | 34007 | 56844 | 1345 |
1571508 | 1571508 | 2021-07-31 | Camden | New Jersey | 34007 | 56793 | 1345 |
1551284 | 1551284 | 2021-07-25 | Jefferson | Kentucky | 21111 | 84173 | 1345 |
1548037 | 1548037 | 2021-07-24 | Jefferson | Kentucky | 21111 | 84173 | 1345 |
1544790 | 1544790 | 2021-07-23 | Jefferson | Kentucky | 21111 | 84173 | 1345 |
1541542 | 1541542 | 2021-07-22 | Jefferson | Kentucky | 21111 | 84043 | 1345 |
1538295 | 1538295 | 2021-07-21 | Jefferson | Kentucky | 21111 | 83939 | 1345 |
1535047 | 1535047 | 2021-07-20 | Jefferson | Kentucky | 21111 | 83857 | 1345 |
1531800 | 1531800 | 2021-07-19 | Jefferson | Kentucky | 21111 | 83752 | 1345 |
1326615 | 1326615 | 2021-05-17 | Polk | Florida | 12105 | 69939 | 1345 |
1283983 | 1283983 | 2021-05-03 | Milwaukee | Wisconsin | 55079 | 115175 | 1345 |
1280736 | 1280736 | 2021-05-02 | Milwaukee | Wisconsin | 55079 | 115093 | 1345 |
1277489 | 1277489 | 2021-05-01 | Milwaukee | Wisconsin | 55079 | 114963 | 1345 |
1274242 | 1274242 | 2021-04-30 | Milwaukee | Wisconsin | 55079 | 114801 | 1345 |
1268424 | 1268424 | 2021-04-29 | DuPage | Illinois | 17043 | 88519 | 1345 |
1261509 | 1261509 | 2021-04-27 | Kern | California | 6029 | 108418 | 1345 |
1258262 | 1258262 | 2021-04-26 | Kern | California | 6029 | 108313 | 1345 |
1255015 | 1255015 | 2021-04-25 | Kern | California | 6029 | 108280 | 1345 |
1251768 | 1251768 | 2021-04-24 | Kern | California | 6029 | 108256 | 1345 |
1248521 | 1248521 | 2021-04-23 | Kern | California | 6029 | 108195 | 1345 |
1225925 | 1225925 | 2021-04-16 | Duval | Florida | 12031 | 94984 | 1345 |
1214683 | 1214683 | 2021-04-12 | Franklin | Ohio | 39049 | 120804 | 1345 |
1211436 | 1211436 | 2021-04-11 | Franklin | Ohio | 39049 | 120536 | 1345 |
1208187 | 1208187 | 2021-04-10 | Franklin | Ohio | 39049 | 120346 | 1345 |
1204939 | 1204939 | 2021-04-09 | Franklin | Ohio | 39049 | 120142 | 1345 |
1179156 | 1179156 | 2021-04-01 | Delaware | Pennsylvania | 42045 | 44969 | 1345 |
1145602 | 1145602 | 2021-03-22 | Baltimore | Maryland | 24005 | 53949 | 1345 |
1142355 | 1142355 | 2021-03-21 | Baltimore | Maryland | 24005 | 53836 | 1345 |
1129402 | 1129402 | 2021-03-17 | Plymouth | Massachusetts | 25023 | 42023 | 1345 |
1008441 | 1008441 | 2021-02-08 | Pinellas | Florida | 12103 | 61730 | 1345 |
972590 | 972590 | 2021-01-28 | Santa Clara | California | 6085 | 100468 | 1345 |
927679 | 927679 | 2021-01-14 | Marion | Indiana | 18097 | 80078 | 1345 |
863375 | 863375 | 2020-12-25 | Hennepin | Minnesota | 27053 | 84116 | 1345 |
860130 | 860130 | 2020-12-24 | Hennepin | Minnesota | 27053 | 84116 | 1345 |
381293 | 381293 | 2020-07-29 | Union | New Jersey | 34039 | 16610 | 1345 |
371648 | 371648 | 2020-07-26 | Union | New Jersey | 34039 | 16534 | 1345 |
368436 | 368436 | 2020-07-25 | Union | New Jersey | 34039 | 16510 | 1345 |
365227 | 365227 | 2020-07-24 | Union | New Jersey | 34039 | 16496 | 1345 |
234219 | 234219 | 2020-06-13 | Fairfield | Connecticut | 9001 | 16277 | 1345 |
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);