ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 1145 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Pennsylvania 10
- Ohio 8
- Florida 7
- Louisiana 7
- Missouri 7
- South Carolina 7
- Illinois 4
- Texas 4
- Tennessee 3
- Washington 3
- Colorado 2
- District of Columbia 2
- Georgia 2
- Massachusetts 2
- New York 2
- California 1
- Minnesota 1
- New Jersey 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502673 | 2502673 | 2022-05-13 | Snohomish | Washington | 53061 | 159246 | 1145 |
2499415 | 2499415 | 2022-05-12 | Snohomish | Washington | 53061 | 158407 | 1145 |
2496157 | 2496157 | 2022-05-11 | Snohomish | Washington | 53061 | 158407 | 1145 |
2490172 | 2490172 | 2022-05-10 | Osceola | Florida | 12097 | 115328 | 1145 |
2486915 | 2486915 | 2022-05-09 | Osceola | Florida | 12097 | 115328 | 1145 |
2483657 | 2483657 | 2022-05-08 | Osceola | Florida | 12097 | 115328 | 1145 |
2480399 | 2480399 | 2022-05-07 | Osceola | Florida | 12097 | 115328 | 1145 |
2477141 | 2477141 | 2022-05-06 | Osceola | Florida | 12097 | 115328 | 1145 |
2473883 | 2473883 | 2022-05-05 | Osceola | Florida | 12097 | 114270 | 1145 |
2470626 | 2470626 | 2022-05-04 | Osceola | Florida | 12097 | 114270 | 1145 |
2440264 | 2440264 | 2022-04-24 | Hamilton | Tennessee | 47065 | 100147 | 1145 |
2437008 | 2437008 | 2022-04-23 | Hamilton | Tennessee | 47065 | 100147 | 1145 |
2433752 | 2433752 | 2022-04-22 | Hamilton | Tennessee | 47065 | 100147 | 1145 |
2426749 | 2426749 | 2022-04-20 | Butler | Ohio | 39017 | 92921 | 1145 |
2423493 | 2423493 | 2022-04-19 | Butler | Ohio | 39017 | 92921 | 1145 |
2419292 | 2419292 | 2022-04-18 | Caddo | Louisiana | 22017 | 67256 | 1145 |
2420236 | 2420236 | 2022-04-18 | Butler | Ohio | 39017 | 92921 | 1145 |
2420446 | 2420446 | 2022-04-18 | Chester | Pennsylvania | 42029 | 92470 | 1145 |
2416036 | 2416036 | 2022-04-17 | Caddo | Louisiana | 22017 | 67239 | 1145 |
2416981 | 2416981 | 2022-04-17 | Butler | Ohio | 39017 | 92921 | 1145 |
2417190 | 2417190 | 2022-04-17 | Chester | Pennsylvania | 42029 | 92417 | 1145 |
2412780 | 2412780 | 2022-04-16 | Caddo | Louisiana | 22017 | 67239 | 1145 |
2413725 | 2413725 | 2022-04-16 | Butler | Ohio | 39017 | 92921 | 1145 |
2413934 | 2413934 | 2022-04-16 | Chester | Pennsylvania | 42029 | 92349 | 1145 |
2409524 | 2409524 | 2022-04-15 | Caddo | Louisiana | 22017 | 67239 | 1145 |
2410469 | 2410469 | 2022-04-15 | Butler | Ohio | 39017 | 92921 | 1145 |
2410678 | 2410678 | 2022-04-15 | Chester | Pennsylvania | 42029 | 92260 | 1145 |
2406268 | 2406268 | 2022-04-14 | Caddo | Louisiana | 22017 | 67239 | 1145 |
2407213 | 2407213 | 2022-04-14 | Butler | Ohio | 39017 | 92921 | 1145 |
2407422 | 2407422 | 2022-04-14 | Chester | Pennsylvania | 42029 | 92175 | 1145 |
2403012 | 2403012 | 2022-04-13 | Caddo | Louisiana | 22017 | 67234 | 1145 |
2375033 | 2375033 | 2022-04-04 | Horry | South Carolina | 45051 | 96219 | 1145 |
2371781 | 2371781 | 2022-04-03 | Horry | South Carolina | 45051 | 96219 | 1145 |
2368528 | 2368528 | 2022-04-02 | Horry | South Carolina | 45051 | 96219 | 1145 |
2365275 | 2365275 | 2022-04-01 | Horry | South Carolina | 45051 | 96219 | 1145 |
2362022 | 2362022 | 2022-03-31 | Horry | South Carolina | 45051 | 96219 | 1145 |
2358768 | 2358768 | 2022-03-30 | Horry | South Carolina | 45051 | 96219 | 1145 |
2355514 | 2355514 | 2022-03-29 | Horry | South Carolina | 45051 | 96219 | 1145 |
2246386 | 2246386 | 2022-02-24 | Kane | Illinois | 17089 | 124212 | 1145 |
2244039 | 2244039 | 2022-02-23 | Kansas City | Missouri | 111184 | 1145 | |
2240788 | 2240788 | 2022-02-22 | Kansas City | Missouri | 111120 | 1145 | |
2237537 | 2237537 | 2022-02-21 | Kansas City | Missouri | 110862 | 1145 | |
2234286 | 2234286 | 2022-02-20 | Kansas City | Missouri | 110862 | 1145 | |
2231035 | 2231035 | 2022-02-19 | Kansas City | Missouri | 110862 | 1145 | |
2227784 | 2227784 | 2022-02-18 | Kansas City | Missouri | 110862 | 1145 | |
2224533 | 2224533 | 2022-02-17 | Kansas City | Missouri | 110916 | 1145 | |
2148412 | 2148412 | 2022-01-25 | Arapahoe | Colorado | 8005 | 139765 | 1145 |
2145174 | 2145174 | 2022-01-24 | Denver | Colorado | 8031 | 153846 | 1145 |
2147601 | 2147601 | 2022-01-24 | Denton | Texas | 48121 | 154269 | 1145 |
2089164 | 2089164 | 2022-01-06 | Montgomery | Texas | 48339 | 104090 | 1145 |
1814017 | 1814017 | 2021-10-14 | Lake | Illinois | 17097 | 79434 | 1145 |
1811255 | 1811255 | 2021-10-13 | East Baton Rouge | Louisiana | 22033 | 63272 | 1145 |
1722104 | 1722104 | 2021-09-15 | Fairfax | Virginia | 51059 | 85647 | 1145 |
1708024 | 1708024 | 2021-09-11 | Monroe | New York | 36055 | 76031 | 1145 |
1704777 | 1704777 | 2021-09-10 | Monroe | New York | 36055 | 75819 | 1145 |
1693858 | 1693858 | 2021-09-07 | Will | Illinois | 17197 | 84759 | 1145 |
1518076 | 1518076 | 2021-07-15 | District of Columbia | District of Columbia | 11001 | 49615 | 1145 |
1514829 | 1514829 | 2021-07-14 | District of Columbia | District of Columbia | 11001 | 49574 | 1145 |
1351269 | 1351269 | 2021-05-24 | Lancaster | Pennsylvania | 42071 | 54931 | 1145 |
1348023 | 1348023 | 2021-05-23 | Lancaster | Pennsylvania | 42071 | 54897 | 1145 |
1344775 | 1344775 | 2021-05-22 | Lancaster | Pennsylvania | 42071 | 54797 | 1145 |
1284494 | 1284494 | 2021-05-04 | Gwinnett | Georgia | 13135 | 101165 | 1145 |
1281247 | 1281247 | 2021-05-03 | Gwinnett | Georgia | 13135 | 101058 | 1145 |
1101217 | 1101217 | 2021-03-08 | Bucks | Pennsylvania | 42017 | 46264 | 1145 |
1097971 | 1097971 | 2021-03-07 | Bucks | Pennsylvania | 42017 | 46156 | 1145 |
961459 | 961459 | 2021-01-24 | Cuyahoga | Ohio | 39035 | 86066 | 1145 |
949866 | 949866 | 2021-01-21 | Sacramento | California | 6067 | 81686 | 1145 |
937285 | 937285 | 2021-01-17 | DuPage | Illinois | 17043 | 68737 | 1145 |
791975 | 791975 | 2020-12-03 | Hennepin | Minnesota | 27053 | 70069 | 1145 |
792427 | 792427 | 2020-12-03 | Ocean | New Jersey | 34029 | 22986 | 1145 |
645866 | 645866 | 2020-10-19 | Worcester | Massachusetts | 25027 | 15544 | 1145 |
616662 | 616662 | 2020-10-10 | Suffolk | Massachusetts | 25025 | 25497 | 1145 |
501468 | 501468 | 2020-09-04 | Bexar | Texas | 48029 | 47196 | 1145 |
475691 | 475691 | 2020-08-27 | Hidalgo | Texas | 48215 | 27018 | 1145 |
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);