ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 1443 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- California 5
- Connecticut 4
- Pennsylvania 3
- Wisconsin 3
- Maryland 2
- Massachusetts 2
- New Jersey 2
- Florida 1
- Georgia 1
- Minnesota 1
- New York 1
- North Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176161 | 2176161 | 2022-02-02 | Mecklenburg | North Carolina | 37119 | 262965 | 1443 |
2150038 | 2150038 | 2022-01-25 | Monroe | New York | 36055 | 142733 | 1443 |
2018532 | 2018532 | 2021-12-16 | Cobb | Georgia | 13067 | 114373 | 1443 |
1997656 | 1997656 | 2021-12-09 | Lancaster | Pennsylvania | 42071 | 81606 | 1443 |
1701941 | 1701941 | 2021-09-09 | Delaware | Pennsylvania | 42045 | 56845 | 1443 |
1698692 | 1698692 | 2021-09-08 | Delaware | Pennsylvania | 42045 | 56762 | 1443 |
1631634 | 1631634 | 2021-08-19 | Kern | California | 6029 | 119277 | 1443 |
1576155 | 1576155 | 2021-08-01 | Milwaukee | Wisconsin | 55079 | 120939 | 1443 |
1572907 | 1572907 | 2021-07-31 | Milwaukee | Wisconsin | 55079 | 120939 | 1443 |
1569659 | 1569659 | 2021-07-30 | Milwaukee | Wisconsin | 55079 | 120939 | 1443 |
1424860 | 1424860 | 2021-06-16 | Plymouth | Massachusetts | 25023 | 49246 | 1443 |
1246278 | 1246278 | 2021-04-22 | Baltimore | Maryland | 24005 | 61882 | 1443 |
1171611 | 1171611 | 2021-03-30 | Hampden | Massachusetts | 25013 | 45670 | 1443 |
1126134 | 1126134 | 2021-03-16 | Montgomery | Maryland | 24031 | 64979 | 1443 |
1076420 | 1076420 | 2021-03-01 | Fresno | California | 6019 | 95548 | 1443 |
1073174 | 1073174 | 2021-02-28 | Fresno | California | 6019 | 95393 | 1443 |
1069928 | 1069928 | 2021-02-27 | Fresno | California | 6019 | 95202 | 1443 |
1039880 | 1039880 | 2021-02-17 | Shelby | Tennessee | 47157 | 86644 | 1443 |
912055 | 912055 | 2021-01-09 | Hennepin | Minnesota | 27053 | 90265 | 1443 |
784353 | 784353 | 2020-12-01 | Riverside | California | 6065 | 87722 | 1443 |
696833 | 696833 | 2020-11-04 | Fairfield | Connecticut | 9001 | 25538 | 1443 |
656160 | 656160 | 2020-10-22 | Middlesex | New Jersey | 34023 | 21525 | 1443 |
628704 | 628704 | 2020-10-14 | Hartford | Connecticut | 9003 | 16010 | 1443 |
625461 | 625461 | 2020-10-13 | Hartford | Connecticut | 9003 | 15949 | 1443 |
622218 | 622218 | 2020-10-12 | Hartford | Connecticut | 9003 | 15836 | 1443 |
609268 | 609268 | 2020-10-08 | Broward | Florida | 12011 | 78614 | 1443 |
146853 | 146853 | 2020-05-15 | Bergen | New Jersey | 34003 | 17195 | 1443 |
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);