ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
307 rows where cases = 1828 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 23
- Georgia 21
- Minnesota 19
- Missouri 18
- Illinois 17
- Indiana 17
- Michigan 16
- Texas 13
- West Virginia 13
- Virginia 11
- Arkansas 10
- Florida 10
- Mississippi 10
- South Carolina 9
- Kentucky 8
- Louisiana 7
- Ohio 7
- Wisconsin 7
- New Mexico 6
- Puerto Rico 6
- Pennsylvania 5
- Kansas 4
- Nebraska 4
- New York 4
- North Carolina 4
- Washington 4
- Alabama 3
- California 3
- Colorado 3
- Idaho 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476514 | 2476514 | 2022-05-05 | Lancaster | Virginia | 51103 | 1828 | 31 |
2471948 | 2471948 | 2022-05-04 | Cuming | Nebraska | 31039 | 1828 | 15 |
2468692 | 2468692 | 2022-05-03 | Cuming | Nebraska | 31039 | 1828 | 15 |
2356177 | 2356177 | 2022-03-29 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2352924 | 2352924 | 2022-03-28 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2349672 | 2349672 | 2022-03-27 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2346419 | 2346419 | 2022-03-26 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2343166 | 2343166 | 2022-03-25 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2339913 | 2339913 | 2022-03-24 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2336393 | 2336393 | 2022-03-23 | Stephens | Texas | 48429 | 1828 | 45 |
2336660 | 2336660 | 2022-03-23 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2333406 | 2333406 | 2022-03-22 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2330152 | 2330152 | 2022-03-21 | Calhoun | West Virginia | 54013 | 1828 | 13 |
2240483 | 2240483 | 2022-02-22 | Alger | Michigan | 26003 | 1828 | 13 |
2237232 | 2237232 | 2022-02-21 | Alger | Michigan | 26003 | 1828 | 13 |
2233981 | 2233981 | 2022-02-20 | Alger | Michigan | 26003 | 1828 | 13 |
2183835 | 2183835 | 2022-02-04 | Pendleton | West Virginia | 54071 | 1828 | 16 |
2164592 | 2164592 | 2022-01-30 | Monroe | Arkansas | 5095 | 1828 | 28 |
2161337 | 2161337 | 2022-01-29 | Monroe | Arkansas | 5095 | 1828 | 28 |
2158081 | 2158081 | 2022-01-28 | Monroe | Arkansas | 5095 | 1828 | 28 |
2160629 | 2160629 | 2022-01-28 | Floyd | Texas | 48153 | 1828 | 42 |
2148950 | 2148950 | 2022-01-25 | Union | Indiana | 18161 | 1828 | 21 |
2144676 | 2144676 | 2022-01-23 | Northampton | Virginia | 51131 | 1828 | 51 |
2141421 | 2141421 | 2022-01-22 | Northampton | Virginia | 51131 | 1828 | 51 |
2138165 | 2138165 | 2022-01-21 | Northampton | Virginia | 51131 | 1828 | 51 |
2127099 | 2127099 | 2022-01-18 | Hamilton | Nebraska | 31081 | 1828 | 22 |
2121733 | 2121733 | 2022-01-16 | Terry | Texas | 48445 | 1828 | 74 |
2121836 | 2121836 | 2022-01-16 | Charlotte | Virginia | 51037 | 1828 | 32 |
2118584 | 2118584 | 2022-01-15 | Charlotte | Virginia | 51037 | 1828 | 32 |
2115332 | 2115332 | 2022-01-14 | Charlotte | Virginia | 51037 | 1828 | 32 |
2112094 | 2112094 | 2022-01-13 | Essex | Virginia | 51057 | 1828 | 22 |
2106453 | 2106453 | 2022-01-12 | Clearwater | Idaho | 16035 | 1828 | 29 |
2103539 | 2103539 | 2022-01-11 | Coffey | Kansas | 20031 | 1828 | 33 |
2100288 | 2100288 | 2022-01-10 | Coffey | Kansas | 20031 | 1828 | 33 |
2096613 | 2096613 | 2022-01-09 | McIntosh | Georgia | 13191 | 1828 | 33 |
2093361 | 2093361 | 2022-01-08 | McIntosh | Georgia | 13191 | 1828 | 33 |
2090109 | 2090109 | 2022-01-07 | McIntosh | Georgia | 13191 | 1828 | 33 |
2086858 | 2086858 | 2022-01-06 | McIntosh | Georgia | 13191 | 1828 | 33 |
2083326 | 2083326 | 2022-01-05 | Mariposa | California | 6043 | 1828 | 18 |
2083606 | 2083606 | 2022-01-05 | McIntosh | Georgia | 13191 | 1828 | 33 |
2084257 | 2084257 | 2022-01-05 | East Carroll | Louisiana | 22035 | 1828 | 33 |
2061763 | 2061763 | 2021-12-29 | Swift | Minnesota | 27151 | 1828 | 29 |
2062173 | 2062173 | 2021-12-29 | Unknown | New Jersey | 1828 | 0 | |
2057828 | 2057828 | 2021-12-28 | Crawford | Indiana | 18025 | 1828 | 31 |
2029141 | 2029141 | 2021-12-19 | Iron | Michigan | 26071 | 1828 | 70 |
2030526 | 2030526 | 2021-12-19 | Childress | Texas | 48075 | 1828 | 22 |
2025890 | 2025890 | 2021-12-18 | Iron | Michigan | 26071 | 1828 | 70 |
2027275 | 2027275 | 2021-12-18 | Childress | Texas | 48075 | 1828 | 22 |
2022639 | 2022639 | 2021-12-17 | Iron | Michigan | 26071 | 1828 | 70 |
2023653 | 2023653 | 2021-12-17 | Forest | Pennsylvania | 42053 | 1828 | 31 |
2019243 | 2019243 | 2021-12-16 | Catahoula | Louisiana | 22025 | 1828 | 48 |
2019400 | 2019400 | 2021-12-16 | Luce | Michigan | 26095 | 1828 | 6 |
2016150 | 2016150 | 2021-12-15 | Luce | Michigan | 26095 | 1828 | 6 |
2011533 | 2011533 | 2021-12-13 | Forest | Wisconsin | 55041 | 1828 | 37 |
1990316 | 1990316 | 2021-12-07 | Montgomery | Mississippi | 28097 | 1828 | 57 |
1969867 | 1969867 | 2021-12-01 | Screven | Georgia | 13251 | 1828 | 62 |
1967006 | 1967006 | 2021-11-30 | Brown | Kansas | 20013 | 1828 | 40 |
1963754 | 1963754 | 2021-11-29 | Brown | Kansas | 20013 | 1828 | 40 |
1961155 | 1961155 | 2021-11-28 | Lewis | Missouri | 29111 | 1828 | 30 |
1961745 | 1961745 | 2021-11-28 | Vinton | Ohio | 39163 | 1828 | 37 |
1957904 | 1957904 | 2021-11-27 | Lewis | Missouri | 29111 | 1828 | 30 |
1954653 | 1954653 | 2021-11-26 | Lewis | Missouri | 29111 | 1828 | 30 |
1951402 | 1951402 | 2021-11-25 | Lewis | Missouri | 29111 | 1828 | 30 |
1948151 | 1948151 | 2021-11-24 | Lewis | Missouri | 29111 | 1828 | 30 |
1943557 | 1943557 | 2021-11-23 | Mono | California | 6051 | 1828 | 5 |
1894678 | 1894678 | 2021-11-08 | Nome Census Area | Alaska | 2180 | 1828 | 2 |
1894814 | 1894814 | 2021-11-08 | Plumas | California | 6063 | 1828 | 7 |
1894431 | 1894431 | 2021-11-07 | Pacific | Washington | 53049 | 1828 | 33 |
1891181 | 1891181 | 2021-11-06 | Pacific | Washington | 53049 | 1828 | 33 |
1887931 | 1887931 | 2021-11-05 | Pacific | Washington | 53049 | 1828 | 33 |
1875978 | 1875978 | 2021-11-02 | Shelby | Iowa | 19165 | 1828 | 41 |
1876382 | 1876382 | 2021-11-02 | Kalkaska | Michigan | 26079 | 1828 | 38 |
1872729 | 1872729 | 2021-11-01 | Shelby | Iowa | 19165 | 1828 | 41 |
1873133 | 1873133 | 2021-11-01 | Kalkaska | Michigan | 26079 | 1828 | 38 |
1869480 | 1869480 | 2021-10-31 | Shelby | Iowa | 19165 | 1828 | 41 |
1866231 | 1866231 | 2021-10-30 | Shelby | Iowa | 19165 | 1828 | 41 |
1862982 | 1862982 | 2021-10-29 | Shelby | Iowa | 19165 | 1828 | 41 |
1859733 | 1859733 | 2021-10-28 | Shelby | Iowa | 19165 | 1828 | 41 |
1856484 | 1856484 | 2021-10-27 | Shelby | Iowa | 19165 | 1828 | 41 |
1852262 | 1852262 | 2021-10-25 | Ashland | Wisconsin | 55003 | 1828 | 16 |
1848339 | 1848339 | 2021-10-24 | Dewey | South Dakota | 46041 | 1828 | 31 |
1845089 | 1845089 | 2021-10-23 | Dewey | South Dakota | 46041 | 1828 | 31 |
1841839 | 1841839 | 2021-10-22 | Dewey | South Dakota | 46041 | 1828 | 31 |
1813196 | 1813196 | 2021-10-13 | Klickitat | Washington | 53039 | 1828 | 17 |
1782498 | 1782498 | 2021-10-04 | Custer | Montana | 30017 | 1828 | 26 |
1778969 | 1778969 | 2021-10-03 | Cottonwood | Minnesota | 27033 | 1828 | 24 |
1775719 | 1775719 | 2021-10-02 | Cottonwood | Minnesota | 27033 | 1828 | 24 |
1772469 | 1772469 | 2021-10-01 | Cottonwood | Minnesota | 27033 | 1828 | 24 |
1768007 | 1768007 | 2021-09-30 | Desha | Arkansas | 5041 | 1828 | 29 |
1747477 | 1747477 | 2021-09-23 | Barranquitas | Puerto Rico | 72019 | 1828 | |
1743235 | 1743235 | 2021-09-22 | Faribault | Minnesota | 27043 | 1828 | 25 |
1744227 | 1744227 | 2021-09-22 | Barranquitas | Puerto Rico | 72019 | 1828 | |
1741845 | 1741845 | 2021-09-21 | Rusk | Wisconsin | 55107 | 1828 | 29 |
1697067 | 1697067 | 2021-09-08 | Massac | Illinois | 17127 | 1828 | 45 |
1694185 | 1694185 | 2021-09-07 | Clinton | Kentucky | 21053 | 1828 | 33 |
1690936 | 1690936 | 2021-09-06 | Clinton | Kentucky | 21053 | 1828 | 33 |
1687686 | 1687686 | 2021-09-05 | Clinton | Kentucky | 21053 | 1828 | 33 |
1684436 | 1684436 | 2021-09-04 | Clinton | Kentucky | 21053 | 1828 | 33 |
1667798 | 1667798 | 2021-08-30 | Greene | Illinois | 17061 | 1828 | 49 |
1659000 | 1659000 | 2021-08-27 | Pemiscot | Missouri | 29155 | 1828 | 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);