ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 1288 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Texas 8
- Colorado 4
- Louisiana 4
- Florida 3
- Maryland 2
- New Jersey 2
- California 1
- Connecticut 1
- Georgia 1
- Indiana 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417705 | 2417705 | 2022-04-17 | Montgomery | Texas | 48339 | 139540 | 1288 |
2414449 | 2414449 | 2022-04-16 | Montgomery | Texas | 48339 | 139540 | 1288 |
2411193 | 2411193 | 2022-04-15 | Montgomery | Texas | 48339 | 139540 | 1288 |
2407937 | 2407937 | 2022-04-14 | Montgomery | Texas | 48339 | 139540 | 1288 |
2391660 | 2391660 | 2022-04-09 | Montgomery | Texas | 48339 | 139191 | 1288 |
2388404 | 2388404 | 2022-04-08 | Montgomery | Texas | 48339 | 139121 | 1288 |
2354619 | 2354619 | 2022-03-29 | Kansas City | Missouri | 112592 | 1288 | |
2237125 | 2237125 | 2022-02-21 | East Baton Rouge | Louisiana | 22033 | 109690 | 1288 |
2233883 | 2233883 | 2022-02-20 | Jefferson | Louisiana | 22051 | 112158 | 1288 |
2230632 | 2230632 | 2022-02-19 | Jefferson | Louisiana | 22051 | 112158 | 1288 |
2227381 | 2227381 | 2022-02-18 | Jefferson | Louisiana | 22051 | 112158 | 1288 |
2219977 | 2219977 | 2022-02-16 | Adams | Colorado | 8001 | 129484 | 1288 |
2216726 | 2216726 | 2022-02-15 | Adams | Colorado | 8001 | 129484 | 1288 |
2213475 | 2213475 | 2022-02-14 | Adams | Colorado | 8001 | 129484 | 1288 |
1989117 | 1989117 | 2021-12-07 | El Paso | Colorado | 8041 | 116876 | 1288 |
1966853 | 1966853 | 2021-11-30 | Lake | Indiana | 18089 | 71598 | 1288 |
1833292 | 1833292 | 2021-10-20 | DeKalb | Georgia | 13089 | 91520 | 1288 |
1779431 | 1779431 | 2021-10-03 | Morris | New Jersey | 34027 | 56336 | 1288 |
1776181 | 1776181 | 2021-10-02 | Morris | New Jersey | 34027 | 56260 | 1288 |
1713851 | 1713851 | 2021-09-13 | Baltimore city | Maryland | 24510 | 57237 | 1288 |
1336351 | 1336351 | 2021-05-20 | Orange | Florida | 12095 | 141232 | 1288 |
1083921 | 1083921 | 2021-03-03 | Baltimore | Maryland | 24005 | 51217 | 1288 |
1085000 | 1085000 | 2021-03-03 | Delaware | Pennsylvania | 42045 | 41224 | 1288 |
995303 | 995303 | 2021-02-04 | Sacramento | California | 6067 | 87414 | 1288 |
979225 | 979225 | 2021-01-30 | Pinellas | Florida | 12103 | 59207 | 1288 |
840659 | 840659 | 2020-12-18 | Hennepin | Minnesota | 27053 | 81645 | 1288 |
811332 | 811332 | 2020-12-09 | Suffolk | Massachusetts | 25025 | 42036 | 1288 |
534749 | 534749 | 2020-09-15 | Broward | Florida | 12011 | 74689 | 1288 |
395068 | 395068 | 2020-08-02 | Harris | Texas | 48201 | 76642 | 1288 |
391852 | 391852 | 2020-08-01 | Harris | Texas | 48201 | 74884 | 1288 |
197145 | 197145 | 2020-06-01 | Fairfield | Connecticut | 9001 | 15709 | 1288 |
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);