ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where cases = 4032 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 16
- Iowa 11
- Virginia 11
- Mississippi 10
- Alaska 7
- Illinois 7
- North Carolina 6
- Indiana 5
- Ohio 5
- South Carolina 5
- Alabama 4
- Arkansas 4
- Texas 4
- Kentucky 3
- New York 3
- Pennsylvania 3
- Washington 3
- Georgia 2
- Idaho 2
- Minnesota 2
- Puerto Rico 2
- Louisiana 1
- Maine 1
- Michigan 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- North Dakota 1
- Oklahoma 1
- Tennessee 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421496 | 2421496 | 2022-04-19 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2418240 | 2418240 | 2022-04-18 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2414984 | 2414984 | 2022-04-17 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2411728 | 2411728 | 2022-04-16 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2408472 | 2408472 | 2022-04-15 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2405216 | 2405216 | 2022-04-14 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2405780 | 2405780 | 2022-04-14 | Jo Daviess | Illinois | 17085 | 4032 | 39 |
2401961 | 2401961 | 2022-04-13 | Kusilvak Census Area | Alaska | 2158 | 4032 | 12 |
2402525 | 2402525 | 2022-04-13 | Jo Daviess | Illinois | 17085 | 4032 | 39 |
2399270 | 2399270 | 2022-04-12 | Jo Daviess | Illinois | 17085 | 4032 | 39 |
2333278 | 2333278 | 2022-03-22 | Grayson | Virginia | 51077 | 4032 | 79 |
2330025 | 2330025 | 2022-03-21 | Grayson | Virginia | 51077 | 4032 | 79 |
2296868 | 2296868 | 2022-03-11 | Catano | Puerto Rico | 72033 | 4032 | |
2254872 | 2254872 | 2022-02-26 | Aransas | Texas | 48007 | 4032 | 77 |
2240025 | 2240025 | 2022-02-22 | Vermillion | Indiana | 18165 | 4032 | 71 |
2237483 | 2237483 | 2022-02-21 | Yalobusha | Mississippi | 28161 | 4032 | 52 |
2234232 | 2234232 | 2022-02-20 | Yalobusha | Mississippi | 28161 | 4032 | 52 |
2230981 | 2230981 | 2022-02-19 | Yalobusha | Mississippi | 28161 | 4032 | 52 |
2227730 | 2227730 | 2022-02-18 | Yalobusha | Mississippi | 28161 | 4032 | 52 |
2226115 | 2226115 | 2022-02-17 | Monroe | West Virginia | 54063 | 4032 | 37 |
2128673 | 2128673 | 2022-01-19 | Hale | Alabama | 1065 | 4032 | 94 |
2109277 | 2109277 | 2022-01-13 | Lawrence | Arkansas | 5075 | 4032 | 64 |
2102779 | 2102779 | 2022-01-11 | Logan | Arkansas | 5083 | 4032 | 57 |
2098170 | 2098170 | 2022-01-09 | Rolette | North Dakota | 38079 | 4032 | 36 |
2098945 | 2098945 | 2022-01-09 | Reeves | Texas | 48389 | 4032 | 63 |
2080724 | 2080724 | 2022-01-04 | Mahaska | Iowa | 19123 | 4032 | 69 |
2077472 | 2077472 | 2022-01-03 | Mahaska | Iowa | 19123 | 4032 | 69 |
2074221 | 2074221 | 2022-01-02 | Mahaska | Iowa | 19123 | 4032 | 69 |
2070970 | 2070970 | 2022-01-01 | Mahaska | Iowa | 19123 | 4032 | 69 |
2067719 | 2067719 | 2021-12-31 | Mahaska | Iowa | 19123 | 4032 | 69 |
2064468 | 2064468 | 2021-12-30 | Mahaska | Iowa | 19123 | 4032 | 69 |
2061218 | 2061218 | 2021-12-29 | Mahaska | Iowa | 19123 | 4032 | 69 |
2056788 | 2056788 | 2021-12-27 | St. Thomas | Virgin Islands | 78030 | 4032 | 46 |
2033264 | 2033264 | 2021-12-20 | Wyandot | Ohio | 39175 | 4032 | 79 |
2015432 | 2015432 | 2021-12-15 | Cassia | Idaho | 16031 | 4032 | 43 |
2012689 | 2012689 | 2021-12-14 | McCreary | Kentucky | 21147 | 4032 | 66 |
2007525 | 2007525 | 2021-12-12 | Abbeville | South Carolina | 45001 | 4032 | 53 |
2004274 | 2004274 | 2021-12-11 | Abbeville | South Carolina | 45001 | 4032 | 53 |
2001023 | 2001023 | 2021-12-10 | Abbeville | South Carolina | 45001 | 4032 | 53 |
1983298 | 1983298 | 2021-12-05 | Labette | Kansas | 20099 | 4032 | 63 |
1980048 | 1980048 | 2021-12-04 | Labette | Kansas | 20099 | 4032 | 63 |
1976798 | 1976798 | 2021-12-03 | Labette | Kansas | 20099 | 4032 | 63 |
1963620 | 1963620 | 2021-11-29 | Posey | Indiana | 18129 | 4032 | 44 |
1960526 | 1960526 | 2021-11-28 | Franklin | Kansas | 20059 | 4032 | 61 |
1957275 | 1957275 | 2021-11-27 | Franklin | Kansas | 20059 | 4032 | 61 |
1954024 | 1954024 | 2021-11-26 | Franklin | Kansas | 20059 | 4032 | 61 |
1950773 | 1950773 | 2021-11-25 | Franklin | Kansas | 20059 | 4032 | 61 |
1947522 | 1947522 | 2021-11-24 | Franklin | Kansas | 20059 | 4032 | 61 |
1920770 | 1920770 | 2021-11-16 | Sevier | Arkansas | 5133 | 4032 | 59 |
1846452 | 1846452 | 2021-10-24 | Payette | Idaho | 16075 | 4032 | 58 |
1782330 | 1782330 | 2021-10-04 | Leake | Mississippi | 28079 | 4032 | 87 |
1757870 | 1757870 | 2021-09-26 | Isle of Wight | Virginia | 51093 | 4032 | 77 |
1754622 | 1754622 | 2021-09-25 | Isle of Wight | Virginia | 51093 | 4032 | 77 |
1751374 | 1751374 | 2021-09-24 | Isle of Wight | Virginia | 51093 | 4032 | 77 |
1733599 | 1733599 | 2021-09-19 | Marion | Mississippi | 28091 | 4032 | 100 |
1730349 | 1730349 | 2021-09-18 | Marion | Mississippi | 28091 | 4032 | 100 |
1727099 | 1727099 | 2021-09-17 | Marion | Mississippi | 28091 | 4032 | 100 |
1698477 | 1698477 | 2021-09-08 | Champaign | Ohio | 39021 | 4032 | 61 |
1698974 | 1698974 | 2021-09-08 | Hickman | Tennessee | 47081 | 4032 | 52 |
1670363 | 1670363 | 2021-08-30 | Oneida | Wisconsin | 55085 | 4032 | 82 |
1656512 | 1656512 | 2021-08-26 | Arecibo | Puerto Rico | 72013 | 4032 | |
1652314 | 1652314 | 2021-08-25 | Polk | Minnesota | 27119 | 4032 | 75 |
1649994 | 1649994 | 2021-08-24 | Perry | Pennsylvania | 42099 | 4032 | 101 |
1580858 | 1580858 | 2021-08-03 | Steele | Minnesota | 27147 | 4032 | 19 |
1575981 | 1575981 | 2021-08-01 | Petersburg city | Virginia | 51730 | 4032 | 89 |
1572733 | 1572733 | 2021-07-31 | Petersburg city | Virginia | 51730 | 4032 | 89 |
1569485 | 1569485 | 2021-07-30 | Petersburg city | Virginia | 51730 | 4032 | 89 |
1529047 | 1529047 | 2021-07-18 | Laclede | Missouri | 29105 | 4032 | 79 |
1471124 | 1471124 | 2021-06-30 | Brown | Ohio | 39015 | 4032 | 61 |
1467879 | 1467879 | 2021-06-29 | Brown | Ohio | 39015 | 4032 | 61 |
1463438 | 1463438 | 2021-06-28 | Plymouth | Iowa | 19149 | 4032 | 81 |
1460193 | 1460193 | 2021-06-27 | Plymouth | Iowa | 19149 | 4032 | 81 |
1456948 | 1456948 | 2021-06-26 | Plymouth | Iowa | 19149 | 4032 | 81 |
1453703 | 1453703 | 2021-06-25 | Plymouth | Iowa | 19149 | 4032 | 81 |
1442165 | 1442165 | 2021-06-21 | Pike | Pennsylvania | 42103 | 4032 | 54 |
1395079 | 1395079 | 2021-06-07 | Morgan | Illinois | 17137 | 4032 | 104 |
1372488 | 1372488 | 2021-05-31 | Whitley | Indiana | 18183 | 4032 | 40 |
1369243 | 1369243 | 2021-05-30 | Whitley | Indiana | 18183 | 4032 | 40 |
1366985 | 1366985 | 2021-05-29 | Grafton | New Hampshire | 33009 | 4032 | 26 |
1341084 | 1341084 | 2021-05-21 | Columbia | New York | 36021 | 4032 | 103 |
1329667 | 1329667 | 2021-05-18 | Union | Arkansas | 5139 | 4032 | 114 |
1324996 | 1324996 | 2021-05-16 | Yadkin | North Carolina | 37197 | 4032 | 49 |
1321750 | 1321750 | 2021-05-15 | Yadkin | North Carolina | 37197 | 4032 | 49 |
1318504 | 1318504 | 2021-05-14 | Yadkin | North Carolina | 37197 | 4032 | 49 |
1309729 | 1309729 | 2021-05-11 | Franklin | Virginia | 51067 | 4032 | 76 |
1285970 | 1285970 | 2021-05-04 | Davie | North Carolina | 37059 | 4032 | 37 |
1259216 | 1259216 | 2021-04-26 | Natchitoches | Louisiana | 22069 | 4032 | 85 |
1244686 | 1244686 | 2021-04-21 | Waller | Texas | 48473 | 4032 | 46 |
1204341 | 1204341 | 2021-04-09 | Union | Mississippi | 28145 | 4032 | 75 |
1170387 | 1170387 | 2021-03-30 | Chilton | Alabama | 1021 | 4032 | 109 |
1171055 | 1171055 | 2021-03-30 | Randolph | Illinois | 17157 | 4032 | 88 |
1150910 | 1150910 | 2021-03-24 | Covington | Alabama | 1039 | 4032 | 110 |
1138946 | 1138946 | 2021-03-20 | Graves | Kentucky | 21083 | 4032 | 86 |
1136119 | 1136119 | 2021-03-19 | Monroe | Mississippi | 28095 | 4032 | 130 |
1093648 | 1093648 | 2021-03-06 | Penobscot | Maine | 23019 | 4032 | 85 |
1080749 | 1080749 | 2021-03-02 | Isabella | Michigan | 26073 | 4032 | 73 |
1057418 | 1057418 | 2021-02-23 | Monroe | Illinois | 17133 | 4032 | 80 |
1051209 | 1051209 | 2021-02-21 | Lyon | Kansas | 20111 | 4032 | 75 |
1047962 | 1047962 | 2021-02-20 | Lyon | Kansas | 20111 | 4032 | 75 |
1048069 | 1048069 | 2021-02-20 | Jessamine | Kentucky | 21113 | 4032 | 49 |
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);