ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where cases = 2555 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 45
- Kentucky 15
- Tennessee 13
- Virginia 12
- Iowa 11
- Oklahoma 10
- Indiana 9
- North Carolina 9
- Kansas 8
- Michigan 8
- Mississippi 7
- Alabama 6
- Colorado 6
- Georgia 6
- Illinois 6
- Missouri 6
- Ohio 6
- Puerto Rico 6
- New York 5
- Arkansas 4
- Pennsylvania 4
- West Virginia 4
- Idaho 3
- North Dakota 3
- South Dakota 3
- Wyoming 3
- Florida 2
- Louisiana 2
- Minnesota 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430903 | 2430903 | 2022-04-21 | Floyd | Virginia | 51063 | 2555 | 49 |
2408117 | 2408117 | 2022-04-14 | Galax city | Virginia | 51640 | 2555 | 77 |
2377103 | 2377103 | 2022-04-05 | Crawford | Michigan | 26039 | 2555 | 30 |
2373851 | 2373851 | 2022-04-04 | Crawford | Michigan | 26039 | 2555 | 30 |
2370598 | 2370598 | 2022-04-03 | Crawford | Michigan | 26039 | 2555 | 30 |
2367345 | 2367345 | 2022-04-02 | Crawford | Michigan | 26039 | 2555 | 30 |
2364092 | 2364092 | 2022-04-01 | Crawford | Michigan | 26039 | 2555 | 30 |
2279680 | 2279680 | 2022-03-06 | Carroll | Mississippi | 28015 | 2555 | 50 |
2276427 | 2276427 | 2022-03-05 | Carroll | Mississippi | 28015 | 2555 | 50 |
2273174 | 2273174 | 2022-03-04 | Carroll | Mississippi | 28015 | 2555 | 50 |
2269922 | 2269922 | 2022-03-03 | Carroll | Mississippi | 28015 | 2555 | 50 |
2262054 | 2262054 | 2022-03-01 | Sumter | Alabama | 1119 | 2555 | 45 |
2224957 | 2224957 | 2022-02-17 | Pamlico | North Carolina | 37137 | 2555 | 27 |
2217457 | 2217457 | 2022-02-15 | Rice | Kansas | 20159 | 2555 | 22 |
2218709 | 2218709 | 2022-02-15 | Washita | Oklahoma | 40149 | 2555 | 41 |
2214206 | 2214206 | 2022-02-14 | Rice | Kansas | 20159 | 2555 | 22 |
2215458 | 2215458 | 2022-02-14 | Washita | Oklahoma | 40149 | 2555 | 41 |
2212207 | 2212207 | 2022-02-13 | Washita | Oklahoma | 40149 | 2555 | 41 |
2208954 | 2208954 | 2022-02-12 | Washita | Oklahoma | 40149 | 2555 | 41 |
2205701 | 2205701 | 2022-02-11 | Washita | Oklahoma | 40149 | 2555 | 41 |
2200930 | 2200930 | 2022-02-10 | Brown | Indiana | 18013 | 2555 | 60 |
2202448 | 2202448 | 2022-02-10 | Washita | Oklahoma | 40149 | 2555 | 41 |
2199194 | 2199194 | 2022-02-09 | Washita | Oklahoma | 40149 | 2555 | 41 |
2190498 | 2190498 | 2022-02-07 | Lowndes | Alabama | 1085 | 2555 | 69 |
2193462 | 2193462 | 2022-02-07 | Manassas Park city | Virginia | 51685 | 2555 | 16 |
2168330 | 2168330 | 2022-01-31 | Jasper | Illinois | 17079 | 2555 | 26 |
2156703 | 2156703 | 2022-01-27 | McLean | North Dakota | 38055 | 2555 | 48 |
2145494 | 2145494 | 2022-01-24 | Gooding | Idaho | 16047 | 2555 | 45 |
2144317 | 2144317 | 2022-01-23 | Camp | Texas | 48063 | 2555 | 70 |
2116850 | 2116850 | 2022-01-15 | Kent | Maryland | 24029 | 2555 | 61 |
2080713 | 2080713 | 2022-01-04 | Jefferson | Iowa | 19101 | 2555 | 44 |
2077461 | 2077461 | 2022-01-03 | Jefferson | Iowa | 19101 | 2555 | 44 |
2074210 | 2074210 | 2022-01-02 | Jefferson | Iowa | 19101 | 2555 | 44 |
2074475 | 2074475 | 2022-01-02 | Trigg | Kentucky | 21221 | 2555 | 30 |
2070959 | 2070959 | 2022-01-01 | Jefferson | Iowa | 19101 | 2555 | 44 |
2071224 | 2071224 | 2022-01-01 | Trigg | Kentucky | 21221 | 2555 | 30 |
2067016 | 2067016 | 2021-12-31 | Marion | Arkansas | 5089 | 2555 | 71 |
2067708 | 2067708 | 2021-12-31 | Jefferson | Iowa | 19101 | 2555 | 44 |
2067973 | 2067973 | 2021-12-31 | Trigg | Kentucky | 21221 | 2555 | 30 |
2064457 | 2064457 | 2021-12-30 | Jefferson | Iowa | 19101 | 2555 | 44 |
2064722 | 2064722 | 2021-12-30 | Trigg | Kentucky | 21221 | 2555 | 30 |
2061207 | 2061207 | 2021-12-29 | Jefferson | Iowa | 19101 | 2555 | 44 |
2061472 | 2061472 | 2021-12-29 | Trigg | Kentucky | 21221 | 2555 | 30 |
2058077 | 2058077 | 2021-12-28 | Osage | Kansas | 20139 | 2555 | 40 |
2054828 | 2054828 | 2021-12-27 | Osage | Kansas | 20139 | 2555 | 40 |
2052930 | 2052930 | 2021-12-26 | Potter | Pennsylvania | 42105 | 2555 | 78 |
2053591 | 2053591 | 2021-12-26 | Grayson | Virginia | 51077 | 2555 | 59 |
2050341 | 2050341 | 2021-12-25 | Grayson | Virginia | 51077 | 2555 | 59 |
2047091 | 2047091 | 2021-12-24 | Grayson | Virginia | 51077 | 2555 | 59 |
2040415 | 2040415 | 2021-12-22 | Nolan | Texas | 48353 | 2555 | 83 |
2037165 | 2037165 | 2021-12-21 | Nolan | Texas | 48353 | 2555 | 83 |
2033892 | 2033892 | 2021-12-20 | Madison | Texas | 48313 | 2555 | 46 |
2024624 | 2024624 | 2021-12-18 | Clay | Alabama | 1027 | 2555 | 69 |
2010399 | 2010399 | 2021-12-13 | Ramsey | North Dakota | 38071 | 2555 | 41 |
2007148 | 2007148 | 2021-12-12 | Ramsey | North Dakota | 38071 | 2555 | 41 |
1990356 | 1990356 | 2021-12-07 | Bates | Missouri | 29013 | 2555 | 59 |
1991252 | 1991252 | 2021-12-07 | San Sebastian | Puerto Rico | 72131 | 2555 | |
1988001 | 1988001 | 2021-12-06 | San Sebastian | Puerto Rico | 72131 | 2555 | |
1982493 | 1982493 | 2021-12-05 | Howard | Arkansas | 5061 | 2555 | 39 |
1984751 | 1984751 | 2021-12-05 | San Sebastian | Puerto Rico | 72131 | 2555 | |
1965731 | 1965731 | 2021-11-29 | Zavala | Texas | 48507 | 2555 | 56 |
1962479 | 1962479 | 2021-11-28 | Zavala | Texas | 48507 | 2555 | 56 |
1959228 | 1959228 | 2021-11-27 | Zavala | Texas | 48507 | 2555 | 56 |
1955977 | 1955977 | 2021-11-26 | Zavala | Texas | 48507 | 2555 | 56 |
1952726 | 1952726 | 2021-11-25 | Zavala | Texas | 48507 | 2555 | 56 |
1949475 | 1949475 | 2021-11-24 | Zavala | Texas | 48507 | 2555 | 56 |
1946224 | 1946224 | 2021-11-23 | Zavala | Texas | 48507 | 2555 | 56 |
1942973 | 1942973 | 2021-11-22 | Zavala | Texas | 48507 | 2555 | 55 |
1939424 | 1939424 | 2021-11-21 | Lewis | Tennessee | 47101 | 2555 | 41 |
1936174 | 1936174 | 2021-11-20 | Lewis | Tennessee | 47101 | 2555 | 41 |
1932924 | 1932924 | 2021-11-19 | Lewis | Tennessee | 47101 | 2555 | 41 |
1923907 | 1923907 | 2021-11-17 | Washington | Alabama | 1129 | 2555 | 52 |
1883965 | 1883965 | 2021-11-04 | Isabela | Puerto Rico | 72071 | 2555 | |
1880716 | 1880716 | 2021-11-03 | Isabela | Puerto Rico | 72071 | 2555 | |
1871270 | 1871270 | 2021-10-31 | Colorado | Texas | 48089 | 2555 | 51 |
1862004 | 1862004 | 2021-10-28 | Wetzel | West Virginia | 54103 | 2555 | 53 |
1837666 | 1837666 | 2021-10-21 | Livingston | Missouri | 29117 | 2555 | 62 |
1827148 | 1827148 | 2021-10-18 | Vermillion | Indiana | 18165 | 2555 | 54 |
1829330 | 1829330 | 2021-10-18 | Fluvanna | Virginia | 51065 | 2555 | 22 |
1813346 | 1813346 | 2021-10-13 | Carbon | Wyoming | 56007 | 2555 | 36 |
1807134 | 1807134 | 2021-10-12 | Elbert | Colorado | 8039 | 2555 | 21 |
1790927 | 1790927 | 2021-10-07 | Teller | Colorado | 8119 | 2555 | 26 |
1768917 | 1768917 | 2021-09-30 | Garrard | Kentucky | 21079 | 2555 | 42 |
1766589 | 1766589 | 2021-09-29 | Madison | North Carolina | 37115 | 2555 | 54 |
1760040 | 1760040 | 2021-09-27 | Avery | North Carolina | 37011 | 2555 | 31 |
1746052 | 1746052 | 2021-09-23 | Dickinson | Kansas | 20041 | 2555 | 56 |
1742803 | 1742803 | 2021-09-22 | Dickinson | Kansas | 20041 | 2555 | 56 |
1736023 | 1736023 | 2021-09-20 | Hancock | Illinois | 17067 | 2555 | 44 |
1731802 | 1731802 | 2021-09-18 | Franklin | Vermont | 50011 | 2555 | 40 |
1690687 | 1690687 | 2021-09-06 | Starke | Indiana | 18149 | 2555 | 62 |
1687437 | 1687437 | 2021-09-05 | Starke | Indiana | 18149 | 2555 | 62 |
1684187 | 1684187 | 2021-09-04 | Starke | Indiana | 18149 | 2555 | 62 |
1680936 | 1680936 | 2021-09-03 | Starke | Indiana | 18149 | 2555 | 62 |
1673530 | 1673530 | 2021-08-31 | Jackson | West Virginia | 54035 | 2555 | 64 |
1667757 | 1667757 | 2021-08-30 | Minidoka | Idaho | 16067 | 2555 | 34 |
1646340 | 1646340 | 2021-08-23 | Ashe | North Carolina | 37009 | 2555 | 45 |
1619488 | 1619488 | 2021-08-15 | Grayson | Kentucky | 21085 | 2555 | 58 |
1616240 | 1616240 | 2021-08-14 | Grayson | Kentucky | 21085 | 2555 | 58 |
1612991 | 1612991 | 2021-08-13 | Grayson | Kentucky | 21085 | 2555 | 58 |
1603277 | 1603277 | 2021-08-10 | Marion | Kentucky | 21155 | 2555 | 39 |
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);