ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 7359 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Mississippi 7
- Michigan 5
- Tennessee 5
- Indiana 4
- North Carolina 4
- California 3
- Georgia 3
- Louisiana 3
- Missouri 3
- Virginia 3
- Washington 3
- New York 2
- Ohio 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Colorado 1
- Florida 1
- Minnesota 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494198 | 2494198 | 2022-05-11 | De Soto | Louisiana | 22031 | 7359 | 135 |
2388002 | 2388002 | 2022-04-08 | Rio Grande | Puerto Rico | 72119 | 7359 | |
2335485 | 2335485 | 2022-03-23 | Dare | North Carolina | 37055 | 7359 | 23 |
2302465 | 2302465 | 2022-03-13 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2303963 | 2303963 | 2022-03-13 | Botetourt | Virginia | 51023 | 7359 | 94 |
2299213 | 2299213 | 2022-03-12 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2300711 | 2300711 | 2022-03-12 | Botetourt | Virginia | 51023 | 7359 | 94 |
2295961 | 2295961 | 2022-03-11 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2297459 | 2297459 | 2022-03-11 | Botetourt | Virginia | 51023 | 7359 | 94 |
2292709 | 2292709 | 2022-03-10 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2289457 | 2289457 | 2022-03-09 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2286027 | 2286027 | 2022-03-08 | Dickinson | Michigan | 26043 | 7359 | 106 |
2286206 | 2286206 | 2022-03-08 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2282775 | 2282775 | 2022-03-07 | Dickinson | Michigan | 26043 | 7359 | 106 |
2282954 | 2282954 | 2022-03-07 | Itawamba | Mississippi | 28057 | 7359 | 143 |
2260834 | 2260834 | 2022-02-28 | Gallia | Ohio | 39053 | 7359 | 115 |
2206791 | 2206791 | 2022-02-12 | Winston | Alabama | 1133 | 7359 | 116 |
2174127 | 2174127 | 2022-02-01 | Juneau | Wisconsin | 55057 | 7359 | 58 |
2154663 | 2154663 | 2022-01-26 | Sheridan | Wyoming | 56033 | 7359 | 63 |
2111428 | 2111428 | 2022-01-13 | Jefferson | Pennsylvania | 42065 | 7359 | 194 |
1961498 | 1961498 | 2021-11-28 | Tompkins | New York | 36109 | 7359 | 61 |
1925755 | 1925755 | 2021-11-17 | Beaufort | North Carolina | 37013 | 7359 | 131 |
1921946 | 1921946 | 2021-11-16 | Goodhue | Minnesota | 27049 | 7359 | 93 |
1918470 | 1918470 | 2021-11-15 | Avoyelles | Louisiana | 22009 | 7359 | 181 |
1838057 | 1838057 | 2021-10-21 | Haywood | North Carolina | 37087 | 7359 | 138 |
1821913 | 1821913 | 2021-10-16 | Stark | North Dakota | 38089 | 7359 | 60 |
1813587 | 1813587 | 2021-10-14 | San Benito | California | 6069 | 7359 | 71 |
1791916 | 1791916 | 2021-10-07 | Marquette | Michigan | 26103 | 7359 | 72 |
1788667 | 1788667 | 2021-10-06 | Marquette | Michigan | 26103 | 7359 | 72 |
1784392 | 1784392 | 2021-10-05 | Garfield | Colorado | 8045 | 7359 | 59 |
1710122 | 1710122 | 2021-09-12 | Dubois | Indiana | 18037 | 7359 | 123 |
1706875 | 1706875 | 2021-09-11 | Dubois | Indiana | 18037 | 7359 | 123 |
1703627 | 1703627 | 2021-09-10 | Dubois | Indiana | 18037 | 7359 | 123 |
1693395 | 1693395 | 2021-09-07 | Tehama | California | 6103 | 7359 | 74 |
1625352 | 1625352 | 2021-08-17 | Catoosa | Georgia | 13047 | 7359 | 78 |
1313407 | 1313407 | 2021-05-13 | Lonoke | Arkansas | 5085 | 7359 | 119 |
1310346 | 1310346 | 2021-05-12 | Flagler | Florida | 12035 | 7359 | 111 |
1302150 | 1302150 | 2021-05-09 | Oswego | New York | 36075 | 7359 | 90 |
1302879 | 1302879 | 2021-05-09 | Tipton | Tennessee | 47167 | 7359 | 103 |
1299632 | 1299632 | 2021-05-08 | Tipton | Tennessee | 47167 | 7359 | 103 |
1296385 | 1296385 | 2021-05-07 | Tipton | Tennessee | 47167 | 7359 | 103 |
1291789 | 1291789 | 2021-05-06 | Clinton | Michigan | 26037 | 7359 | 83 |
1239116 | 1239116 | 2021-04-20 | Walker | Georgia | 13295 | 7359 | 86 |
1170290 | 1170290 | 2021-03-29 | Chippewa | Wisconsin | 55017 | 7359 | 95 |
1153985 | 1153985 | 2021-03-24 | Whatcom | Washington | 53073 | 7359 | 87 |
1154041 | 1154041 | 2021-03-24 | Wood | West Virginia | 54107 | 7359 | 162 |
1038009 | 1038009 | 2021-02-17 | Hancock | Indiana | 18059 | 7359 | 132 |
1004102 | 1004102 | 2021-02-06 | Anderson | Tennessee | 47001 | 7359 | 143 |
980971 | 980971 | 2021-01-30 | Muskingum | Ohio | 39119 | 7359 | 42 |
969224 | 969224 | 2021-01-27 | Santa Cruz | Arizona | 4023 | 7359 | 145 |
938181 | 938181 | 2021-01-17 | Christian | Missouri | 29043 | 7359 | 60 |
934936 | 934936 | 2021-01-16 | Christian | Missouri | 29043 | 7359 | 60 |
931691 | 931691 | 2021-01-15 | Christian | Missouri | 29043 | 7359 | 60 |
841909 | 841909 | 2020-12-18 | Sevier | Tennessee | 47155 | 7359 | 55 |
837975 | 837975 | 2020-12-17 | Buncombe | North Carolina | 37021 | 7359 | 148 |
755471 | 755471 | 2020-11-22 | Whitfield | Georgia | 13313 | 7359 | 77 |
710654 | 710654 | 2020-11-08 | Ouachita | Louisiana | 22073 | 7359 | 173 |
599054 | 599054 | 2020-10-04 | Spokane | Washington | 53063 | 7359 | 175 |
476042 | 476042 | 2020-08-27 | Pierce | Washington | 53053 | 7359 | 177 |
237243 | 237243 | 2020-06-14 | San Bernardino | California | 6071 | 7359 | 229 |
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);