ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 1343 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- New Jersey 21
- Kentucky 7
- Tennessee 7
- Michigan 5
- Massachusetts 4
- Florida 3
- Louisiana 3
- Minnesota 3
- Pennsylvania 3
- California 1
- Illinois 1
- Nevada 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484677 | 2484677 | 2022-05-08 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2481419 | 2481419 | 2022-05-07 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2478161 | 2478161 | 2022-05-06 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2429068 | 2429068 | 2022-04-21 | East Baton Rouge | Louisiana | 22033 | 110933 | 1343 |
2425812 | 2425812 | 2022-04-20 | East Baton Rouge | Louisiana | 22033 | 110922 | 1343 |
2422556 | 2422556 | 2022-04-19 | East Baton Rouge | Louisiana | 22033 | 110882 | 1343 |
2378149 | 2378149 | 2022-04-05 | Luzerne | Pennsylvania | 42079 | 73421 | 1343 |
2378420 | 2378420 | 2022-04-05 | Knox | Tennessee | 47093 | 127671 | 1343 |
2375166 | 2375166 | 2022-04-04 | Knox | Tennessee | 47093 | 127671 | 1343 |
2371914 | 2371914 | 2022-04-03 | Knox | Tennessee | 47093 | 127671 | 1343 |
2368661 | 2368661 | 2022-04-02 | Knox | Tennessee | 47093 | 127671 | 1343 |
2365408 | 2365408 | 2022-04-01 | Knox | Tennessee | 47093 | 127671 | 1343 |
2362155 | 2362155 | 2022-03-31 | Knox | Tennessee | 47093 | 127671 | 1343 |
2358901 | 2358901 | 2022-03-30 | Knox | Tennessee | 47093 | 127671 | 1343 |
2074631 | 2074631 | 2022-01-02 | Genesee | Michigan | 26049 | 72131 | 1343 |
2071380 | 2071380 | 2022-01-01 | Genesee | Michigan | 26049 | 72131 | 1343 |
2068129 | 2068129 | 2021-12-31 | Genesee | Michigan | 26049 | 72131 | 1343 |
2064878 | 2064878 | 2021-12-30 | Genesee | Michigan | 26049 | 72131 | 1343 |
2061628 | 2061628 | 2021-12-29 | Genesee | Michigan | 26049 | 72131 | 1343 |
2055668 | 2055668 | 2021-12-27 | Morris | New Jersey | 34027 | 73905 | 1343 |
1883897 | 1883897 | 2021-11-04 | Lancaster | Pennsylvania | 42071 | 72429 | 1343 |
1815804 | 1815804 | 2021-10-14 | Greenville | South Carolina | 45045 | 103092 | 1343 |
1768063 | 1768063 | 2021-09-30 | Alameda | California | 6001 | 117832 | 1343 |
1542280 | 1542280 | 2021-07-22 | Camden | New Jersey | 34007 | 56404 | 1343 |
1539033 | 1539033 | 2021-07-21 | Camden | New Jersey | 34007 | 56380 | 1343 |
1535786 | 1535786 | 2021-07-20 | Camden | New Jersey | 34007 | 56332 | 1343 |
1532538 | 1532538 | 2021-07-19 | Camden | New Jersey | 34007 | 56310 | 1343 |
1528553 | 1528553 | 2021-07-18 | Jefferson | Kentucky | 21111 | 83574 | 1343 |
1529291 | 1529291 | 2021-07-18 | Camden | New Jersey | 34007 | 56288 | 1343 |
1525306 | 1525306 | 2021-07-17 | Jefferson | Kentucky | 21111 | 83574 | 1343 |
1526044 | 1526044 | 2021-07-17 | Camden | New Jersey | 34007 | 56264 | 1343 |
1522058 | 1522058 | 2021-07-16 | Jefferson | Kentucky | 21111 | 83574 | 1343 |
1522797 | 1522797 | 2021-07-16 | Camden | New Jersey | 34007 | 56242 | 1343 |
1518810 | 1518810 | 2021-07-15 | Jefferson | Kentucky | 21111 | 83529 | 1343 |
1519548 | 1519548 | 2021-07-15 | Camden | New Jersey | 34007 | 56208 | 1343 |
1515563 | 1515563 | 2021-07-14 | Jefferson | Kentucky | 21111 | 83477 | 1343 |
1516301 | 1516301 | 2021-07-14 | Camden | New Jersey | 34007 | 56189 | 1343 |
1512317 | 1512317 | 2021-07-13 | Jefferson | Kentucky | 21111 | 83425 | 1343 |
1513054 | 1513054 | 2021-07-13 | Camden | New Jersey | 34007 | 56164 | 1343 |
1509070 | 1509070 | 2021-07-12 | Jefferson | Kentucky | 21111 | 83393 | 1343 |
1509807 | 1509807 | 2021-07-12 | Camden | New Jersey | 34007 | 56147 | 1343 |
1506561 | 1506561 | 2021-07-11 | Camden | New Jersey | 34007 | 56140 | 1343 |
1503315 | 1503315 | 2021-07-10 | Camden | New Jersey | 34007 | 56132 | 1343 |
1320123 | 1320123 | 2021-05-15 | Polk | Florida | 12105 | 69778 | 1343 |
1261930 | 1261930 | 2021-04-27 | DuPage | Illinois | 17043 | 88158 | 1343 |
1126155 | 1126155 | 2021-03-16 | Plymouth | Massachusetts | 25023 | 41927 | 1343 |
1032589 | 1032589 | 2021-02-15 | Monmouth | New Jersey | 34025 | 53221 | 1343 |
1029342 | 1029342 | 2021-02-14 | Monmouth | New Jersey | 34025 | 53108 | 1343 |
958444 | 958444 | 2021-01-23 | Montgomery | Pennsylvania | 42091 | 45577 | 1343 |
866507 | 866507 | 2020-12-26 | Suffolk | Massachusetts | 25025 | 51663 | 1343 |
814579 | 814579 | 2020-12-10 | Worcester | Massachusetts | 25027 | 30516 | 1343 |
675053 | 675053 | 2020-10-28 | Essex | Massachusetts | 25009 | 23642 | 1343 |
576898 | 576898 | 2020-09-28 | Palm Beach | Florida | 12099 | 46308 | 1343 |
560647 | 560647 | 2020-09-23 | Broward | Florida | 12011 | 76146 | 1343 |
558843 | 558843 | 2020-09-22 | Clark | Nevada | 32003 | 64470 | 1343 |
362021 | 362021 | 2020-07-23 | Union | New Jersey | 34039 | 16472 | 1343 |
342805 | 342805 | 2020-07-17 | Union | New Jersey | 34039 | 16719 | 1343 |
330027 | 330027 | 2020-07-13 | Union | New Jersey | 34039 | 16703 | 1343 |
326840 | 326840 | 2020-07-12 | Union | New Jersey | 34039 | 16685 | 1343 |
323656 | 323656 | 2020-07-11 | Union | New Jersey | 34039 | 16655 | 1343 |
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);