ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
252 rows where cases = 1921 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 18
- Virginia 16
- Georgia 15
- Iowa 14
- Illinois 13
- Michigan 10
- Missouri 10
- Alabama 9
- Arkansas 9
- Colorado 8
- North Carolina 8
- Ohio 8
- Texas 8
- Kentucky 7
- Minnesota 7
- North Dakota 7
- South Dakota 7
- Indiana 6
- Kansas 6
- Tennessee 6
- Louisiana 5
- Maine 5
- Washington 5
- West Virginia 5
- Mississippi 4
- Wisconsin 4
- Florida 3
- Nebraska 3
- New York 3
- Oregon 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498002 | 2498002 | 2022-05-12 | Butler | Nebraska | 31023 | 1921 | 18 |
2494744 | 2494744 | 2022-05-11 | Butler | Nebraska | 31023 | 1921 | 18 |
2401354 | 2401354 | 2022-04-12 | Hansford | Texas | 48195 | 1921 | 29 |
2398099 | 2398099 | 2022-04-11 | Hansford | Texas | 48195 | 1921 | 29 |
2269933 | 2269933 | 2022-03-03 | Franklin | Mississippi | 28037 | 1921 | 37 |
2216571 | 2216571 | 2022-02-15 | Southeast Fairbanks Census Area | Alaska | 2240 | 1921 | 16 |
2213320 | 2213320 | 2022-02-14 | Southeast Fairbanks Census Area | Alaska | 2240 | 1921 | 16 |
2194273 | 2194273 | 2022-02-08 | Benewah | Idaho | 16009 | 1921 | 35 |
2196101 | 2196101 | 2022-02-08 | Patillas | Puerto Rico | 72109 | 1921 | |
2192847 | 2192847 | 2022-02-07 | Patillas | Puerto Rico | 72109 | 1921 | |
2168111 | 2168111 | 2022-01-31 | Clinch | Georgia | 13065 | 1921 | 37 |
2150830 | 2150830 | 2022-01-25 | Clay | Texas | 48077 | 1921 | 26 |
2131037 | 2131037 | 2022-01-19 | Sabana Grande | Puerto Rico | 72121 | 1921 | |
2128477 | 2128477 | 2022-01-18 | Pend Oreille | Washington | 53051 | 1921 | 28 |
2118293 | 2118293 | 2022-01-15 | Castro | Texas | 48069 | 1921 | 45 |
2097101 | 2097101 | 2022-01-09 | Rice | Kansas | 20159 | 1921 | 17 |
2093849 | 2093849 | 2022-01-08 | Rice | Kansas | 20159 | 1921 | 17 |
2090597 | 2090597 | 2022-01-07 | Rice | Kansas | 20159 | 1921 | 17 |
2089402 | 2089402 | 2022-01-06 | Richmond | Virginia | 51159 | 1921 | 17 |
2061827 | 2061827 | 2021-12-29 | Noxubee | Mississippi | 28103 | 1921 | 44 |
2042060 | 2042060 | 2021-12-23 | Piscataquis | Maine | 23021 | 1921 | 16 |
2040136 | 2040136 | 2021-12-22 | Todd | South Dakota | 46121 | 1921 | 39 |
1997389 | 1997389 | 2021-12-09 | Mercer | North Dakota | 38057 | 1921 | 19 |
1988687 | 1988687 | 2021-12-06 | Pacific | Washington | 53049 | 1921 | 37 |
1972851 | 1972851 | 2021-12-02 | Archuleta | Colorado | 8007 | 1921 | 8 |
1974968 | 1974968 | 2021-12-02 | Hatillo | Puerto Rico | 72065 | 1921 | |
1971719 | 1971719 | 2021-12-01 | Hatillo | Puerto Rico | 72065 | 1921 | |
1968469 | 1968469 | 2021-11-30 | Hatillo | Puerto Rico | 72065 | 1921 | |
1965218 | 1965218 | 2021-11-29 | Hatillo | Puerto Rico | 72065 | 1921 | |
1947919 | 1947919 | 2021-11-24 | Unknown | Michigan | 1921 | 18 | |
1930360 | 1930360 | 2021-11-19 | Conecuh | Alabama | 1035 | 1921 | 62 |
1877135 | 1877135 | 2021-11-02 | Mountrail | North Dakota | 38061 | 1921 | 27 |
1872936 | 1872936 | 2021-11-01 | Metcalfe | Kentucky | 21169 | 1921 | 43 |
1867704 | 1867704 | 2021-10-30 | Cidra | Puerto Rico | 72041 | 1921 | |
1850300 | 1850300 | 2021-10-25 | Knox | Maine | 23013 | 1921 | 13 |
1850697 | 1850697 | 2021-10-25 | Ripley | Missouri | 29181 | 1921 | 24 |
1847050 | 1847050 | 2021-10-24 | Knox | Maine | 23013 | 1921 | 13 |
1847447 | 1847447 | 2021-10-24 | Ripley | Missouri | 29181 | 1921 | 24 |
1843800 | 1843800 | 2021-10-23 | Knox | Maine | 23013 | 1921 | 13 |
1841705 | 1841705 | 2021-10-22 | Catano | Puerto Rico | 72033 | 1921 | |
1838350 | 1838350 | 2021-10-21 | Hood River | Oregon | 41027 | 1921 | 37 |
1814709 | 1814709 | 2021-10-14 | Cottonwood | Minnesota | 27033 | 1921 | 27 |
1801334 | 1801334 | 2021-10-10 | Osage | Kansas | 20139 | 1921 | 35 |
1798085 | 1798085 | 2021-10-09 | Osage | Kansas | 20139 | 1921 | 35 |
1794836 | 1794836 | 2021-10-08 | Osage | Kansas | 20139 | 1921 | 35 |
1789338 | 1789338 | 2021-10-06 | Mitchell | North Carolina | 37121 | 1921 | 18 |
1767992 | 1767992 | 2021-09-30 | Bradley | Arkansas | 5011 | 1921 | 37 |
1770880 | 1770880 | 2021-09-30 | Martinsville city | Virginia | 51690 | 1921 | 85 |
1762186 | 1762186 | 2021-09-28 | Butler | Iowa | 19023 | 1921 | 36 |
1758938 | 1758938 | 2021-09-27 | Butler | Iowa | 19023 | 1921 | 36 |
1755557 | 1755557 | 2021-09-26 | Piatt | Illinois | 17147 | 1921 | 20 |
1755690 | 1755690 | 2021-09-26 | Butler | Iowa | 19023 | 1921 | 36 |
1752309 | 1752309 | 2021-09-25 | Piatt | Illinois | 17147 | 1921 | 20 |
1752442 | 1752442 | 2021-09-25 | Butler | Iowa | 19023 | 1921 | 36 |
1749060 | 1749060 | 2021-09-24 | Piatt | Illinois | 17147 | 1921 | 20 |
1749193 | 1749193 | 2021-09-24 | Butler | Iowa | 19023 | 1921 | 36 |
1745943 | 1745943 | 2021-09-23 | Butler | Iowa | 19023 | 1921 | 36 |
1747708 | 1747708 | 2021-09-23 | Jackson | Tennessee | 47087 | 1921 | 38 |
1741923 | 1741923 | 2021-09-22 | Lamar | Alabama | 1075 | 1921 | 40 |
1742694 | 1742694 | 2021-09-22 | Butler | Iowa | 19023 | 1921 | 36 |
1741213 | 1741213 | 2021-09-21 | Lake | Tennessee | 47095 | 1921 | 31 |
1737964 | 1737964 | 2021-09-20 | Lake | Tennessee | 47095 | 1921 | 31 |
1734179 | 1734179 | 2021-09-19 | Ramsey | North Dakota | 38071 | 1921 | 31 |
1720717 | 1720717 | 2021-09-15 | Pemiscot | Missouri | 29155 | 1921 | 40 |
1710789 | 1710789 | 2021-09-12 | Redwood | Minnesota | 27127 | 1921 | 41 |
1707542 | 1707542 | 2021-09-11 | Redwood | Minnesota | 27127 | 1921 | 41 |
1704295 | 1704295 | 2021-09-10 | Redwood | Minnesota | 27127 | 1921 | 41 |
1698385 | 1698385 | 2021-09-08 | Polk | North Carolina | 37149 | 1921 | 36 |
1693626 | 1693626 | 2021-09-07 | Jasper | Georgia | 13159 | 1921 | 43 |
1696276 | 1696276 | 2021-09-07 | Lewis | West Virginia | 54041 | 1921 | 27 |
1690579 | 1690579 | 2021-09-06 | Moultrie | Illinois | 17139 | 1921 | 37 |
1687329 | 1687329 | 2021-09-05 | Moultrie | Illinois | 17139 | 1921 | 37 |
1684079 | 1684079 | 2021-09-04 | Moultrie | Illinois | 17139 | 1921 | 37 |
1680828 | 1680828 | 2021-09-03 | Moultrie | Illinois | 17139 | 1921 | 37 |
1671058 | 1671058 | 2021-08-31 | Johnson | Illinois | 17087 | 1921 | 26 |
1668207 | 1668207 | 2021-08-30 | Garrard | Kentucky | 21079 | 1921 | 37 |
1660821 | 1660821 | 2021-08-28 | Lee | Arkansas | 5077 | 1921 | 40 |
1654789 | 1654789 | 2021-08-26 | Clay | Illinois | 17025 | 1921 | 48 |
1645545 | 1645545 | 2021-08-23 | Union | Kentucky | 21225 | 1921 | 19 |
1626017 | 1626017 | 2021-08-17 | Mason | Kentucky | 21161 | 1921 | 41 |
1604257 | 1604257 | 2021-08-10 | Walsh | North Dakota | 38099 | 1921 | 27 |
1600002 | 1600002 | 2021-08-09 | Harrison | Kentucky | 21097 | 1921 | 27 |
1601008 | 1601008 | 2021-08-09 | Walsh | North Dakota | 38099 | 1921 | 27 |
1597760 | 1597760 | 2021-08-08 | Walsh | North Dakota | 38099 | 1921 | 27 |
1594511 | 1594511 | 2021-08-07 | Walsh | North Dakota | 38099 | 1921 | 27 |
1591876 | 1591876 | 2021-08-06 | Colorado | Texas | 48089 | 1921 | 33 |
1583163 | 1583163 | 2021-08-04 | Greene | Georgia | 13133 | 1921 | 62 |
1563338 | 1563338 | 2021-07-29 | Clay | Arkansas | 5021 | 1921 | 52 |
1560731 | 1560731 | 2021-07-28 | Orange | Indiana | 18117 | 1921 | 59 |
1557118 | 1557118 | 2021-07-27 | Banks | Georgia | 13011 | 1921 | 40 |
1558691 | 1558691 | 2021-07-27 | Northampton | North Carolina | 37131 | 1921 | 61 |
1550278 | 1550278 | 2021-07-25 | Monroe | Alabama | 1099 | 1921 | 41 |
1492183 | 1492183 | 2021-07-07 | Berrien | Georgia | 13019 | 1921 | 47 |
1492210 | 1492210 | 2021-07-07 | Cook | Georgia | 13075 | 1921 | 44 |
1488963 | 1488963 | 2021-07-06 | Cook | Georgia | 13075 | 1921 | 44 |
1484418 | 1484418 | 2021-07-04 | Manati | Puerto Rico | 72091 | 1921 | |
1481172 | 1481172 | 2021-07-03 | Manati | Puerto Rico | 72091 | 1921 | |
1477925 | 1477925 | 2021-07-02 | Manati | Puerto Rico | 72091 | 1921 | |
1472609 | 1472609 | 2021-07-01 | Teller | Colorado | 8119 | 1921 | 18 |
1474679 | 1474679 | 2021-07-01 | Manati | Puerto Rico | 72091 | 1921 |
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);