ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,528 rows where deaths = 70 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 694
- Georgia 556
- Virginia 527
- Mississippi 363
- Michigan 326
- Illinois 318
- Tennessee 293
- Indiana 289
- Kentucky 289
- Louisiana 277
- Minnesota 249
- Oklahoma 228
- Florida 204
- Iowa 189
- Missouri 186
- Alabama 184
- Arkansas 181
- Ohio 179
- New Mexico 150
- North Carolina 149
- Nebraska 144
- Wisconsin 140
- Maine 135
- West Virginia 125
- South Carolina 124
- New York 115
- Oregon 113
- Idaho 104
- Kansas 98
- Pennsylvania 94
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499592 | 2499592 | 2022-05-13 | Conecuh | Alabama | 1035 | 2869 | 70 |
2499707 | 2499707 | 2022-05-13 | Drew | Arkansas | 5043 | 4686 | 70 |
2499718 | 2499718 | 2022-05-13 | Izard | Arkansas | 5065 | 3906 | 70 |
2499911 | 2499911 | 2022-05-13 | Dixie | Florida | 12029 | 4046 | 70 |
2500069 | 2500069 | 2022-05-13 | Morgan | Georgia | 13211 | 4709 | 70 |
2500089 | 2500089 | 2022-05-13 | Screven | Georgia | 13251 | 2659 | 70 |
2500108 | 2500108 | 2022-05-13 | Twiggs | Georgia | 13289 | 1543 | 70 |
2500152 | 2500152 | 2022-05-13 | Elmore | Idaho | 16039 | 7264 | 70 |
2500251 | 2500251 | 2022-05-13 | Pike | Illinois | 17149 | 5050 | 70 |
2500568 | 2500568 | 2022-05-13 | Sumner | Kansas | 20191 | 5724 | 70 |
2500581 | 2500581 | 2022-05-13 | Anderson | Kentucky | 21005 | 6620 | 70 |
2500702 | 2500702 | 2022-05-13 | Assumption | Louisiana | 22007 | 5575 | 70 |
2500875 | 2500875 | 2022-05-13 | Menominee | Michigan | 26109 | 5693 | 70 |
2501071 | 2501071 | 2022-05-13 | Webster | Mississippi | 28155 | 3388 | 70 |
2502131 | 2502131 | 2022-05-13 | Decatur | Tennessee | 47039 | 3738 | 70 |
2502224 | 2502224 | 2022-05-13 | Bosque | Texas | 48035 | 4130 | 70 |
2502272 | 2502272 | 2022-05-13 | Duval | Texas | 48131 | 3412 | 70 |
2502334 | 2502334 | 2022-05-13 | Karnes | Texas | 48255 | 5968 | 70 |
2502651 | 2502651 | 2022-05-13 | Douglas | Washington | 53017 | 11269 | 70 |
2496334 | 2496334 | 2022-05-12 | Conecuh | Alabama | 1035 | 2869 | 70 |
2496449 | 2496449 | 2022-05-12 | Drew | Arkansas | 5043 | 4686 | 70 |
2496460 | 2496460 | 2022-05-12 | Izard | Arkansas | 5065 | 3904 | 70 |
2496653 | 2496653 | 2022-05-12 | Dixie | Florida | 12029 | 4046 | 70 |
2496811 | 2496811 | 2022-05-12 | Morgan | Georgia | 13211 | 4709 | 70 |
2496831 | 2496831 | 2022-05-12 | Screven | Georgia | 13251 | 2659 | 70 |
2496850 | 2496850 | 2022-05-12 | Twiggs | Georgia | 13289 | 1543 | 70 |
2496894 | 2496894 | 2022-05-12 | Elmore | Idaho | 16039 | 7257 | 70 |
2496993 | 2496993 | 2022-05-12 | Pike | Illinois | 17149 | 5047 | 70 |
2497310 | 2497310 | 2022-05-12 | Sumner | Kansas | 20191 | 5719 | 70 |
2497323 | 2497323 | 2022-05-12 | Anderson | Kentucky | 21005 | 6620 | 70 |
2497444 | 2497444 | 2022-05-12 | Assumption | Louisiana | 22007 | 5574 | 70 |
2497617 | 2497617 | 2022-05-12 | Menominee | Michigan | 26109 | 5693 | 70 |
2497813 | 2497813 | 2022-05-12 | Webster | Mississippi | 28155 | 3388 | 70 |
2498873 | 2498873 | 2022-05-12 | Decatur | Tennessee | 47039 | 3738 | 70 |
2498966 | 2498966 | 2022-05-12 | Bosque | Texas | 48035 | 4126 | 70 |
2499014 | 2499014 | 2022-05-12 | Duval | Texas | 48131 | 3411 | 70 |
2499076 | 2499076 | 2022-05-12 | Karnes | Texas | 48255 | 5943 | 70 |
2499393 | 2499393 | 2022-05-12 | Douglas | Washington | 53017 | 11246 | 70 |
2493076 | 2493076 | 2022-05-11 | Conecuh | Alabama | 1035 | 2868 | 70 |
2493191 | 2493191 | 2022-05-11 | Drew | Arkansas | 5043 | 4686 | 70 |
2493202 | 2493202 | 2022-05-11 | Izard | Arkansas | 5065 | 3904 | 70 |
2493395 | 2493395 | 2022-05-11 | Dixie | Florida | 12029 | 4046 | 70 |
2493553 | 2493553 | 2022-05-11 | Morgan | Georgia | 13211 | 4709 | 70 |
2493573 | 2493573 | 2022-05-11 | Screven | Georgia | 13251 | 2659 | 70 |
2493592 | 2493592 | 2022-05-11 | Twiggs | Georgia | 13289 | 1543 | 70 |
2493636 | 2493636 | 2022-05-11 | Elmore | Idaho | 16039 | 7257 | 70 |
2493735 | 2493735 | 2022-05-11 | Pike | Illinois | 17149 | 5044 | 70 |
2494052 | 2494052 | 2022-05-11 | Sumner | Kansas | 20191 | 5719 | 70 |
2494065 | 2494065 | 2022-05-11 | Anderson | Kentucky | 21005 | 6620 | 70 |
2494186 | 2494186 | 2022-05-11 | Assumption | Louisiana | 22007 | 5573 | 70 |
2494359 | 2494359 | 2022-05-11 | Menominee | Michigan | 26109 | 5693 | 70 |
2494555 | 2494555 | 2022-05-11 | Webster | Mississippi | 28155 | 3388 | 70 |
2495615 | 2495615 | 2022-05-11 | Decatur | Tennessee | 47039 | 3738 | 70 |
2495708 | 2495708 | 2022-05-11 | Bosque | Texas | 48035 | 4125 | 70 |
2495756 | 2495756 | 2022-05-11 | Duval | Texas | 48131 | 3403 | 70 |
2495818 | 2495818 | 2022-05-11 | Karnes | Texas | 48255 | 5924 | 70 |
2496135 | 2496135 | 2022-05-11 | Douglas | Washington | 53017 | 11246 | 70 |
2489818 | 2489818 | 2022-05-10 | Conecuh | Alabama | 1035 | 2868 | 70 |
2489933 | 2489933 | 2022-05-10 | Drew | Arkansas | 5043 | 4687 | 70 |
2489944 | 2489944 | 2022-05-10 | Izard | Arkansas | 5065 | 3904 | 70 |
2490137 | 2490137 | 2022-05-10 | Dixie | Florida | 12029 | 4046 | 70 |
2490334 | 2490334 | 2022-05-10 | Twiggs | Georgia | 13289 | 1541 | 70 |
2490378 | 2490378 | 2022-05-10 | Elmore | Idaho | 16039 | 7252 | 70 |
2490477 | 2490477 | 2022-05-10 | Pike | Illinois | 17149 | 5045 | 70 |
2490794 | 2490794 | 2022-05-10 | Sumner | Kansas | 20191 | 5719 | 70 |
2490807 | 2490807 | 2022-05-10 | Anderson | Kentucky | 21005 | 6620 | 70 |
2490928 | 2490928 | 2022-05-10 | Assumption | Louisiana | 22007 | 5570 | 70 |
2491101 | 2491101 | 2022-05-10 | Menominee | Michigan | 26109 | 5656 | 70 |
2491297 | 2491297 | 2022-05-10 | Webster | Mississippi | 28155 | 3388 | 70 |
2492243 | 2492243 | 2022-05-10 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2492357 | 2492357 | 2022-05-10 | Decatur | Tennessee | 47039 | 3738 | 70 |
2492450 | 2492450 | 2022-05-10 | Bosque | Texas | 48035 | 4124 | 70 |
2492498 | 2492498 | 2022-05-10 | Duval | Texas | 48131 | 3403 | 70 |
2492560 | 2492560 | 2022-05-10 | Karnes | Texas | 48255 | 5894 | 70 |
2492834 | 2492834 | 2022-05-10 | Prince Edward | Virginia | 51147 | 5100 | 70 |
2492877 | 2492877 | 2022-05-10 | Douglas | Washington | 53017 | 11211 | 70 |
2486561 | 2486561 | 2022-05-09 | Conecuh | Alabama | 1035 | 2868 | 70 |
2486676 | 2486676 | 2022-05-09 | Drew | Arkansas | 5043 | 4686 | 70 |
2486687 | 2486687 | 2022-05-09 | Izard | Arkansas | 5065 | 3904 | 70 |
2486880 | 2486880 | 2022-05-09 | Dixie | Florida | 12029 | 4046 | 70 |
2487077 | 2487077 | 2022-05-09 | Twiggs | Georgia | 13289 | 1541 | 70 |
2487121 | 2487121 | 2022-05-09 | Elmore | Idaho | 16039 | 7252 | 70 |
2487220 | 2487220 | 2022-05-09 | Pike | Illinois | 17149 | 5044 | 70 |
2487537 | 2487537 | 2022-05-09 | Sumner | Kansas | 20191 | 5719 | 70 |
2487550 | 2487550 | 2022-05-09 | Anderson | Kentucky | 21005 | 6620 | 70 |
2487671 | 2487671 | 2022-05-09 | Assumption | Louisiana | 22007 | 5569 | 70 |
2487844 | 2487844 | 2022-05-09 | Menominee | Michigan | 26109 | 5656 | 70 |
2488039 | 2488039 | 2022-05-09 | Webster | Mississippi | 28155 | 3388 | 70 |
2488780 | 2488780 | 2022-05-09 | Benton | Oregon | 41003 | 16078 | 70 |
2488985 | 2488985 | 2022-05-09 | Edgefield | South Carolina | 45037 | 6779 | 70 |
2489099 | 2489099 | 2022-05-09 | Decatur | Tennessee | 47039 | 3738 | 70 |
2489192 | 2489192 | 2022-05-09 | Bosque | Texas | 48035 | 4120 | 70 |
2489240 | 2489240 | 2022-05-09 | Duval | Texas | 48131 | 3403 | 70 |
2489302 | 2489302 | 2022-05-09 | Karnes | Texas | 48255 | 5887 | 70 |
2489461 | 2489461 | 2022-05-09 | Bennington | Vermont | 50003 | 10015 | 70 |
2489576 | 2489576 | 2022-05-09 | Prince Edward | Virginia | 51147 | 5094 | 70 |
2489619 | 2489619 | 2022-05-09 | Douglas | Washington | 53017 | 11209 | 70 |
2483303 | 2483303 | 2022-05-08 | Conecuh | Alabama | 1035 | 2868 | 70 |
2483418 | 2483418 | 2022-05-08 | Drew | Arkansas | 5043 | 4686 | 70 |
2483429 | 2483429 | 2022-05-08 | Izard | Arkansas | 5065 | 3904 | 70 |
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);