ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 1160 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- California 8
- Texas 8
- Pennsylvania 7
- Illinois 6
- Ohio 6
- Louisiana 5
- Florida 4
- Georgia 4
- Indiana 4
- Massachusetts 2
- Missouri 2
- Arkansas 1
- Connecticut 1
- District of Columbia 1
- New Jersey 1
- New York 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2317453 | 2317453 | 2022-03-18 | Pulaski | Arkansas | 5119 | 102577 | 1160 |
2301667 | 2301667 | 2022-03-13 | Kane | Illinois | 17089 | 124954 | 1160 |
2298415 | 2298415 | 2022-03-12 | Kane | Illinois | 17089 | 124954 | 1160 |
2295163 | 2295163 | 2022-03-11 | Kane | Illinois | 17089 | 124954 | 1160 |
2291911 | 2291911 | 2022-03-10 | Kane | Illinois | 17089 | 124908 | 1160 |
2289559 | 2289559 | 2022-03-09 | Jackson | Missouri | 29095 | 96003 | 1160 |
2286307 | 2286307 | 2022-03-08 | Jackson | Missouri | 29095 | 96030 | 1160 |
2278963 | 2278963 | 2022-03-06 | Allen | Indiana | 18003 | 103394 | 1160 |
2275710 | 2275710 | 2022-03-05 | Allen | Indiana | 18003 | 103394 | 1160 |
2272457 | 2272457 | 2022-03-04 | Allen | Indiana | 18003 | 103394 | 1160 |
2269205 | 2269205 | 2022-03-03 | Allen | Indiana | 18003 | 103374 | 1160 |
2235441 | 2235441 | 2022-02-20 | Fort Bend | Texas | 48157 | 174877 | 1160 |
2232190 | 2232190 | 2022-02-19 | Fort Bend | Texas | 48157 | 174809 | 1160 |
2228939 | 2228939 | 2022-02-18 | Fort Bend | Texas | 48157 | 174506 | 1160 |
2163486 | 2163486 | 2022-01-29 | Lehigh | Pennsylvania | 42077 | 86662 | 1160 |
2137926 | 2137926 | 2022-01-21 | Lubbock | Texas | 48303 | 88975 | 1160 |
2134005 | 2134005 | 2022-01-20 | Lucas | Ohio | 39095 | 91746 | 1160 |
2130753 | 2130753 | 2022-01-19 | Lucas | Ohio | 39095 | 90937 | 1160 |
2127499 | 2127499 | 2022-01-18 | Lucas | Ohio | 39095 | 89997 | 1160 |
2115177 | 2115177 | 2022-01-14 | Montgomery | Texas | 48339 | 114850 | 1160 |
2111925 | 2111925 | 2022-01-13 | Montgomery | Texas | 48339 | 113326 | 1160 |
2104957 | 2104957 | 2022-01-11 | Westmoreland | Pennsylvania | 42129 | 64784 | 1160 |
2076854 | 2076854 | 2022-01-03 | Tulare | California | 6107 | 89686 | 1160 |
2073603 | 2073603 | 2022-01-02 | Tulare | California | 6107 | 89686 | 1160 |
2070352 | 2070352 | 2022-01-01 | Tulare | California | 6107 | 89686 | 1160 |
2067101 | 2067101 | 2021-12-31 | Tulare | California | 6107 | 89686 | 1160 |
2063850 | 2063850 | 2021-12-30 | Tulare | California | 6107 | 89497 | 1160 |
1859992 | 1859992 | 2021-10-28 | East Baton Rouge | Louisiana | 22033 | 63825 | 1160 |
1856743 | 1856743 | 2021-10-27 | East Baton Rouge | Louisiana | 22033 | 63799 | 1160 |
1858152 | 1858152 | 2021-10-27 | Davidson | Tennessee | 47037 | 132423 | 1160 |
1853494 | 1853494 | 2021-10-26 | East Baton Rouge | Louisiana | 22033 | 63737 | 1160 |
1850245 | 1850245 | 2021-10-25 | East Baton Rouge | Louisiana | 22033 | 63696 | 1160 |
1850254 | 1850254 | 2021-10-25 | Jefferson | Louisiana | 22051 | 69406 | 1160 |
1810359 | 1810359 | 2021-10-13 | Ventura | California | 6111 | 100337 | 1160 |
1807110 | 1807110 | 2021-10-12 | Ventura | California | 6111 | 100191 | 1160 |
1803859 | 1803859 | 2021-10-11 | Ventura | California | 6111 | 100144 | 1160 |
1772999 | 1772999 | 2021-10-01 | Monroe | New York | 36055 | 80018 | 1160 |
1754435 | 1754435 | 2021-09-25 | Nueces | Texas | 48355 | 59655 | 1160 |
1751187 | 1751187 | 2021-09-24 | Nueces | Texas | 48355 | 59655 | 1160 |
1736089 | 1736089 | 2021-09-20 | Will | Illinois | 17197 | 86981 | 1160 |
1732571 | 1732571 | 2021-09-19 | DeKalb | Georgia | 13089 | 85208 | 1160 |
1729321 | 1729321 | 2021-09-18 | DeKalb | Georgia | 13089 | 85208 | 1160 |
1726071 | 1726071 | 2021-09-17 | DeKalb | Georgia | 13089 | 85208 | 1160 |
1670736 | 1670736 | 2021-08-31 | District of Columbia | District of Columbia | 11001 | 55431 | 1160 |
1644855 | 1644855 | 2021-08-23 | Cobb | Georgia | 13067 | 91871 | 1160 |
1442149 | 1442149 | 2021-06-21 | Lancaster | Pennsylvania | 42071 | 55365 | 1160 |
1438904 | 1438904 | 2021-06-20 | Lancaster | Pennsylvania | 42071 | 55362 | 1160 |
1435657 | 1435657 | 2021-06-19 | Lancaster | Pennsylvania | 42071 | 55355 | 1160 |
1432410 | 1432410 | 2021-06-18 | Lancaster | Pennsylvania | 42071 | 55354 | 1160 |
1201697 | 1201697 | 2021-04-08 | Hamilton | Ohio | 39061 | 77213 | 1160 |
1198448 | 1198448 | 2021-04-07 | Hamilton | Ohio | 39061 | 77090 | 1160 |
1195199 | 1195199 | 2021-04-06 | Hamilton | Ohio | 39061 | 76986 | 1160 |
1141519 | 1141519 | 2021-03-21 | Orange | Florida | 12095 | 120182 | 1160 |
1138273 | 1138273 | 2021-03-20 | Orange | Florida | 12095 | 119870 | 1160 |
1139707 | 1139707 | 2021-03-20 | Morris | New Jersey | 34027 | 42348 | 1160 |
1130434 | 1130434 | 2021-03-17 | Bucks | Pennsylvania | 42017 | 47659 | 1160 |
950268 | 950268 | 2021-01-21 | DuPage | Illinois | 17043 | 69900 | 1160 |
756162 | 756162 | 2020-11-22 | Norfolk | Massachusetts | 25021 | 14911 | 1160 |
645864 | 645864 | 2020-10-19 | Suffolk | Massachusetts | 25025 | 26546 | 1160 |
499211 | 499211 | 2020-09-04 | Palm Beach | Florida | 12099 | 42760 | 1160 |
470067 | 470067 | 2020-08-26 | Broward | Florida | 12011 | 69883 | 1160 |
157537 | 157537 | 2020-05-19 | Fairfield | Connecticut | 9001 | 14522 | 1160 |
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);