ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
389 rows where cases = 1512 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 41
- Louisiana 45
- Iowa 24
- Nebraska 22
- Texas 22
- Georgia 20
- Kentucky 20
- Mississippi 19
- Kansas 18
- Minnesota 16
- Illinois 14
- Michigan 14
- Tennessee 12
- Missouri 11
- Virginia 10
- Indiana 9
- Puerto Rico 9
- Arkansas 8
- North Carolina 7
- South Dakota 7
- Washington 7
- Wisconsin 7
- Alabama 6
- Colorado 6
- Montana 6
- Alaska 5
- Connecticut 5
- Utah 5
- West Virginia 5
- Idaho 4
- New York 4
- Florida 3
- North Dakota 3
- Ohio 3
- Oregon 3
- Oklahoma 2
- South Carolina 2
- Wyoming 2
- California 1
- New Hampshire 1
- New Mexico 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501266 | 2501266 | 2022-05-13 | Clay | Nebraska | 31035 | 1512 | 24 |
2497278 | 2497278 | 2022-05-12 | Morris | Kansas | 20127 | 1512 | 28 |
2494020 | 2494020 | 2022-05-11 | Morris | Kansas | 20127 | 1512 | 28 |
2490762 | 2490762 | 2022-05-10 | Morris | Kansas | 20127 | 1512 | 28 |
2487505 | 2487505 | 2022-05-09 | Morris | Kansas | 20127 | 1512 | 28 |
2484247 | 2484247 | 2022-05-08 | Morris | Kansas | 20127 | 1512 | 28 |
2480989 | 2480989 | 2022-05-07 | Morris | Kansas | 20127 | 1512 | 28 |
2477731 | 2477731 | 2022-05-06 | Morris | Kansas | 20127 | 1512 | 28 |
2470011 | 2470011 | 2022-05-03 | Mathews | Virginia | 51115 | 1512 | 27 |
2466755 | 2466755 | 2022-05-02 | Mathews | Virginia | 51115 | 1512 | 27 |
2463584 | 2463584 | 2022-05-01 | Skamania | Washington | 53059 | 1512 | 13 |
2459589 | 2459589 | 2022-04-30 | Ceiba | Puerto Rico | 72037 | 1512 | |
2460328 | 2460328 | 2022-04-30 | Skamania | Washington | 53059 | 1512 | 13 |
2457072 | 2457072 | 2022-04-29 | Skamania | Washington | 53059 | 1512 | 13 |
2453470 | 2453470 | 2022-04-28 | Jack | Texas | 48237 | 1512 | 28 |
2450214 | 2450214 | 2022-04-27 | Jack | Texas | 48237 | 1512 | 28 |
2446957 | 2446957 | 2022-04-26 | Jack | Texas | 48237 | 1512 | 28 |
2436807 | 2436807 | 2022-04-23 | Guanica | Puerto Rico | 72055 | 1512 | |
2429615 | 2429615 | 2022-04-21 | Cedar | Nebraska | 31027 | 1512 | 14 |
2426359 | 2426359 | 2022-04-20 | Cedar | Nebraska | 31027 | 1512 | 14 |
2423103 | 2423103 | 2022-04-19 | Cedar | Nebraska | 31027 | 1512 | 14 |
2379783 | 2379783 | 2022-04-06 | Stark | Illinois | 17175 | 1512 | 32 |
2376529 | 2376529 | 2022-04-05 | Stark | Illinois | 17175 | 1512 | 32 |
2373277 | 2373277 | 2022-04-04 | Stark | Illinois | 17175 | 1512 | 32 |
2348252 | 2348252 | 2022-03-27 | Clay | Nebraska | 31035 | 1512 | 23 |
2344999 | 2344999 | 2022-03-26 | Clay | Nebraska | 31035 | 1512 | 23 |
2341746 | 2341746 | 2022-03-25 | Clay | Nebraska | 31035 | 1512 | 23 |
2338493 | 2338493 | 2022-03-24 | Clay | Nebraska | 31035 | 1512 | 23 |
2335239 | 2335239 | 2022-03-23 | Clay | Nebraska | 31035 | 1512 | 23 |
2331985 | 2331985 | 2022-03-22 | Clay | Nebraska | 31035 | 1512 | 23 |
2328732 | 2328732 | 2022-03-21 | Clay | Nebraska | 31035 | 1512 | 23 |
2324046 | 2324046 | 2022-03-20 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2325480 | 2325480 | 2022-03-20 | Clay | Nebraska | 31035 | 1512 | 23 |
2320792 | 2320792 | 2022-03-19 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2322226 | 2322226 | 2022-03-19 | Clay | Nebraska | 31035 | 1512 | 23 |
2317538 | 2317538 | 2022-03-18 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2314285 | 2314285 | 2022-03-17 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2302710 | 2302710 | 2022-03-13 | Clay | Nebraska | 31035 | 1512 | 23 |
2299458 | 2299458 | 2022-03-12 | Clay | Nebraska | 31035 | 1512 | 23 |
2296206 | 2296206 | 2022-03-11 | Clay | Nebraska | 31035 | 1512 | 23 |
2289702 | 2289702 | 2022-03-09 | Clay | Nebraska | 31035 | 1512 | 21 |
2246348 | 2246348 | 2022-02-24 | Calhoun | Illinois | 17013 | 1512 | 8 |
2239311 | 2239311 | 2022-02-22 | Dillingham Census Area | Alaska | 2070 | 1512 | 11 |
2236060 | 2236060 | 2022-02-21 | Dillingham Census Area | Alaska | 2070 | 1512 | 11 |
2232809 | 2232809 | 2022-02-20 | Dillingham Census Area | Alaska | 2070 | 1512 | 11 |
2229558 | 2229558 | 2022-02-19 | Dillingham Census Area | Alaska | 2070 | 1512 | 11 |
2226307 | 2226307 | 2022-02-18 | Dillingham Census Area | Alaska | 2070 | 1512 | 11 |
2217014 | 2217014 | 2022-02-15 | Twiggs | Georgia | 13289 | 1512 | 66 |
2195081 | 2195081 | 2022-02-08 | Mahnomen | Minnesota | 27087 | 1512 | 17 |
2188679 | 2188679 | 2022-02-06 | Quitman | Mississippi | 28119 | 1512 | 29 |
2185426 | 2185426 | 2022-02-05 | Quitman | Mississippi | 28119 | 1512 | 29 |
2182174 | 2182174 | 2022-02-04 | Quitman | Mississippi | 28119 | 1512 | 29 |
2143234 | 2143234 | 2022-01-23 | Ozark | Missouri | 29153 | 1512 | 48 |
2129267 | 2129267 | 2022-01-19 | Edwards | Illinois | 17047 | 1512 | 24 |
2123570 | 2123570 | 2022-01-17 | Franklin | Mississippi | 28037 | 1512 | 34 |
2120318 | 2120318 | 2022-01-16 | Franklin | Mississippi | 28037 | 1512 | 34 |
2117066 | 2117066 | 2022-01-15 | Franklin | Mississippi | 28037 | 1512 | 34 |
2113815 | 2113815 | 2022-01-14 | Franklin | Mississippi | 28037 | 1512 | 34 |
2101384 | 2101384 | 2022-01-10 | Benson | North Dakota | 38005 | 1512 | 22 |
2094471 | 2094471 | 2022-01-08 | St. Clair | Missouri | 29185 | 1512 | 29 |
2075402 | 2075402 | 2022-01-02 | Pembina | North Dakota | 38067 | 1512 | 15 |
2051034 | 2051034 | 2021-12-26 | Clinch | Georgia | 13065 | 1512 | 36 |
2047784 | 2047784 | 2021-12-25 | Clinch | Georgia | 13065 | 1512 | 36 |
2044534 | 2044534 | 2021-12-24 | Clinch | Georgia | 13065 | 1512 | 36 |
2027720 | 2027720 | 2021-12-18 | Doddridge | West Virginia | 54017 | 1512 | 12 |
2011602 | 2011602 | 2021-12-13 | Sublette | Wyoming | 56035 | 1512 | 23 |
1997069 | 1997069 | 2021-12-09 | Holt | Nebraska | 31089 | 1512 | 16 |
1983275 | 1983275 | 2021-12-05 | Ellsworth | Kansas | 20053 | 1512 | 31 |
1983866 | 1983866 | 2021-12-05 | Carroll | Missouri | 29033 | 1512 | 39 |
1980025 | 1980025 | 2021-12-04 | Ellsworth | Kansas | 20053 | 1512 | 31 |
1976775 | 1976775 | 2021-12-03 | Ellsworth | Kansas | 20053 | 1512 | 31 |
1964229 | 1964229 | 2021-11-29 | Murray | Minnesota | 27101 | 1512 | 11 |
1965807 | 1965807 | 2021-11-29 | Clarke | Virginia | 51043 | 1512 | 29 |
1960785 | 1960785 | 2021-11-28 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1957534 | 1957534 | 2021-11-27 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1954283 | 1954283 | 2021-11-26 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1951032 | 1951032 | 2021-11-25 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1947781 | 1947781 | 2021-11-24 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1944530 | 1944530 | 2021-11-23 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1945730 | 1945730 | 2021-11-23 | Naguabo | Puerto Rico | 72103 | 1512 | |
1941280 | 1941280 | 2021-11-22 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1942479 | 1942479 | 2021-11-22 | Naguabo | Puerto Rico | 72103 | 1512 | |
1938030 | 1938030 | 2021-11-21 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1938186 | 1938186 | 2021-11-21 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1934780 | 1934780 | 2021-11-20 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1934936 | 1934936 | 2021-11-20 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1931529 | 1931529 | 2021-11-19 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1931686 | 1931686 | 2021-11-19 | Clearwater | Minnesota | 27029 | 1512 | 20 |
1928278 | 1928278 | 2021-11-18 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1925028 | 1925028 | 2021-11-17 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1921779 | 1921779 | 2021-11-16 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1918529 | 1918529 | 2021-11-15 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1915176 | 1915176 | 2021-11-14 | McLean | Kentucky | 21149 | 1512 | 39 |
1915279 | 1915279 | 2021-11-14 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1915514 | 1915514 | 2021-11-14 | Benton | Mississippi | 28009 | 1512 | 39 |
1911926 | 1911926 | 2021-11-13 | McLean | Kentucky | 21149 | 1512 | 39 |
1912029 | 1912029 | 2021-11-13 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
1912264 | 1912264 | 2021-11-13 | Benton | Mississippi | 28009 | 1512 | 39 |
1908677 | 1908677 | 2021-11-12 | McLean | Kentucky | 21149 | 1512 | 39 |
1908780 | 1908780 | 2021-11-12 | West Feliciana | Louisiana | 22125 | 1512 | 41 |
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);