ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
389 rows where cases = 1097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 32
- Georgia 27
- Louisiana 23
- Virginia 20
- Montana 18
- Michigan 16
- Nebraska 16
- Missouri 15
- Alabama 14
- Kentucky 14
- Alaska 13
- North Carolina 13
- New Mexico 12
- Illinois 11
- Indiana 11
- Iowa 10
- Mississippi 10
- Oregon 10
- Tennessee 10
- Arkansas 8
- Kansas 8
- West Virginia 8
- North Dakota 7
- Colorado 6
- Minnesota 6
- Pennsylvania 5
- Puerto Rico 5
- Vermont 5
- Maine 4
- Oklahoma 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467066 | 2467066 | 2022-05-03 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2463811 | 2463811 | 2022-05-02 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2460555 | 2460555 | 2022-05-01 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2463542 | 2463542 | 2022-05-01 | Surry | Virginia | 51181 | 1097 | 19 |
2457299 | 2457299 | 2022-04-30 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2460286 | 2460286 | 2022-04-30 | Surry | Virginia | 51181 | 1097 | 19 |
2454043 | 2454043 | 2022-04-29 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2457030 | 2457030 | 2022-04-29 | Surry | Virginia | 51181 | 1097 | 19 |
2450787 | 2450787 | 2022-04-28 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2452368 | 2452368 | 2022-04-28 | Mineral | Montana | 30061 | 1097 | 17 |
2447531 | 2447531 | 2022-04-27 | Aleutians East Borough | Alaska | 2013 | 1097 | 3 |
2416735 | 2416735 | 2022-04-17 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2413479 | 2413479 | 2022-04-16 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2410223 | 2410223 | 2022-04-15 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2406967 | 2406967 | 2022-04-14 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2403711 | 2403711 | 2022-04-13 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2400456 | 2400456 | 2022-04-12 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2397201 | 2397201 | 2022-04-11 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2393946 | 2393946 | 2022-04-10 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2390690 | 2390690 | 2022-04-09 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2387434 | 2387434 | 2022-04-08 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2384179 | 2384179 | 2022-04-07 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2380924 | 2380924 | 2022-04-06 | Hidalgo | New Mexico | 35023 | 1097 | 14 |
2212975 | 2212975 | 2022-02-13 | King and Queen | Virginia | 51097 | 1097 | 10 |
2209722 | 2209722 | 2022-02-12 | King and Queen | Virginia | 51097 | 1097 | 10 |
2206469 | 2206469 | 2022-02-11 | King and Queen | Virginia | 51097 | 1097 | 10 |
2203216 | 2203216 | 2022-02-10 | King and Queen | Virginia | 51097 | 1097 | 10 |
2199962 | 2199962 | 2022-02-09 | King and Queen | Virginia | 51097 | 1097 | 10 |
2187883 | 2187883 | 2022-02-06 | Putnam | Illinois | 17155 | 1097 | 8 |
2184630 | 2184630 | 2022-02-05 | Putnam | Illinois | 17155 | 1097 | 8 |
2181378 | 2181378 | 2022-02-04 | Putnam | Illinois | 17155 | 1097 | 8 |
2164954 | 2164954 | 2022-01-30 | Talbot | Georgia | 13263 | 1097 | 30 |
2166698 | 2166698 | 2022-01-30 | Wallowa | Oregon | 41063 | 1097 | 14 |
2161699 | 2161699 | 2022-01-29 | Talbot | Georgia | 13263 | 1097 | 30 |
2163443 | 2163443 | 2022-01-29 | Wallowa | Oregon | 41063 | 1097 | 14 |
2158443 | 2158443 | 2022-01-28 | Talbot | Georgia | 13263 | 1097 | 30 |
2160188 | 2160188 | 2022-01-28 | Wallowa | Oregon | 41063 | 1097 | 14 |
2154286 | 2154286 | 2022-01-26 | Wheeler | Texas | 48483 | 1097 | 15 |
2110104 | 2110104 | 2022-01-13 | Republic | Kansas | 20157 | 1097 | 14 |
2106853 | 2106853 | 2022-01-12 | Republic | Kansas | 20157 | 1097 | 14 |
2098373 | 2098373 | 2022-01-09 | Lake | Oregon | 41037 | 1097 | 23 |
2095121 | 2095121 | 2022-01-08 | Lake | Oregon | 41037 | 1097 | 23 |
2091869 | 2091869 | 2022-01-07 | Lake | Oregon | 41037 | 1097 | 23 |
2084202 | 2084202 | 2022-01-05 | Menifee | Kentucky | 21165 | 1097 | 26 |
2029596 | 2029596 | 2021-12-19 | Nemaha | Nebraska | 31127 | 1097 | 16 |
2026345 | 2026345 | 2021-12-18 | Nemaha | Nebraska | 31127 | 1097 | 16 |
2023094 | 2023094 | 2021-12-17 | Nemaha | Nebraska | 31127 | 1097 | 16 |
2019843 | 2019843 | 2021-12-16 | Nemaha | Nebraska | 31127 | 1097 | 16 |
2012603 | 2012603 | 2021-12-14 | Wabaunsee | Kansas | 20197 | 1097 | 19 |
2009352 | 2009352 | 2021-12-13 | Wabaunsee | Kansas | 20197 | 1097 | 19 |
2010878 | 2010878 | 2021-12-13 | Spink | South Dakota | 46115 | 1097 | 29 |
1960206 | 1960206 | 2021-11-28 | Brown | Illinois | 17009 | 1097 | 18 |
1956955 | 1956955 | 2021-11-27 | Brown | Illinois | 17009 | 1097 | 18 |
1953704 | 1953704 | 2021-11-26 | Brown | Illinois | 17009 | 1097 | 18 |
1950453 | 1950453 | 2021-11-25 | Brown | Illinois | 17009 | 1097 | 18 |
1947202 | 1947202 | 2021-11-24 | Brown | Illinois | 17009 | 1097 | 18 |
1946312 | 1946312 | 2021-11-23 | Fairfax city | Virginia | 51600 | 1097 | 35 |
1940372 | 1940372 | 2021-11-22 | Kit Carson | Colorado | 8063 | 1097 | 20 |
1938860 | 1938860 | 2021-11-21 | Dickey | North Dakota | 38021 | 1097 | 36 |
1935109 | 1935109 | 2021-11-20 | Carter | Missouri | 29035 | 1097 | 17 |
1935610 | 1935610 | 2021-11-20 | Dickey | North Dakota | 38021 | 1097 | 36 |
1931859 | 1931859 | 2021-11-19 | Carter | Missouri | 29035 | 1097 | 17 |
1927349 | 1927349 | 2021-11-18 | Conejos | Colorado | 8021 | 1097 | 41 |
1927372 | 1927372 | 2021-11-18 | Lake | Colorado | 8065 | 1097 | 1 |
1928608 | 1928608 | 2021-11-18 | Carter | Missouri | 29035 | 1097 | 17 |
1914627 | 1914627 | 2021-11-14 | Twiggs | Georgia | 13289 | 1097 | 62 |
1915787 | 1915787 | 2021-11-14 | Dawes | Nebraska | 31045 | 1097 | 21 |
1916104 | 1916104 | 2021-11-14 | Bottineau | North Dakota | 38009 | 1097 | 21 |
1911377 | 1911377 | 2021-11-13 | Twiggs | Georgia | 13289 | 1097 | 62 |
1912537 | 1912537 | 2021-11-13 | Dawes | Nebraska | 31045 | 1097 | 21 |
1908128 | 1908128 | 2021-11-12 | Twiggs | Georgia | 13289 | 1097 | 62 |
1909287 | 1909287 | 2021-11-12 | Dawes | Nebraska | 31045 | 1097 | 21 |
1893070 | 1893070 | 2021-11-07 | Knox | Nebraska | 31107 | 1097 | 13 |
1889820 | 1889820 | 2021-11-06 | Knox | Nebraska | 31107 | 1097 | 13 |
1886570 | 1886570 | 2021-11-05 | Knox | Nebraska | 31107 | 1097 | 13 |
1887493 | 1887493 | 2021-11-05 | Brewster | Texas | 48043 | 1097 | 22 |
1883321 | 1883321 | 2021-11-04 | Knox | Nebraska | 31107 | 1097 | 13 |
1884243 | 1884243 | 2021-11-04 | Brewster | Texas | 48043 | 1097 | 22 |
1880072 | 1880072 | 2021-11-03 | Knox | Nebraska | 31107 | 1097 | 13 |
1880994 | 1880994 | 2021-11-03 | Brewster | Texas | 48043 | 1097 | 22 |
1876781 | 1876781 | 2021-11-02 | Butler | Nebraska | 31023 | 1097 | 12 |
1877745 | 1877745 | 2021-11-02 | Brewster | Texas | 48043 | 1097 | 22 |
1873532 | 1873532 | 2021-11-01 | Butler | Nebraska | 31023 | 1097 | 12 |
1874496 | 1874496 | 2021-11-01 | Brewster | Texas | 48043 | 1097 | 20 |
1871247 | 1871247 | 2021-10-31 | Brewster | Texas | 48043 | 1097 | 20 |
1858750 | 1858750 | 2021-10-27 | Tucker | West Virginia | 54093 | 1097 | 26 |
1847101 | 1847101 | 2021-10-24 | Alcona | Michigan | 26001 | 1097 | 41 |
1843851 | 1843851 | 2021-10-23 | Alcona | Michigan | 26001 | 1097 | 41 |
1840601 | 1840601 | 2021-10-22 | Alcona | Michigan | 26001 | 1097 | 41 |
1837121 | 1837121 | 2021-10-21 | Bracken | Kentucky | 21023 | 1097 | 10 |
1834637 | 1834637 | 2021-10-20 | Pershing | Nevada | 32027 | 1097 | 26 |
1831388 | 1831388 | 2021-10-19 | Pershing | Nevada | 32027 | 1097 | 26 |
1827146 | 1827146 | 2021-10-18 | Union | Indiana | 18161 | 1097 | 16 |
1818190 | 1818190 | 2021-10-15 | Ozark | Missouri | 29153 | 1097 | 30 |
1790427 | 1790427 | 2021-10-06 | Williamsburg city | Virginia | 51830 | 1097 | 14 |
1786846 | 1786846 | 2021-10-05 | Hansford | Texas | 48195 | 1097 | 26 |
1783576 | 1783576 | 2021-10-04 | Floyd | Texas | 48153 | 1097 | 34 |
1783714 | 1783714 | 2021-10-04 | Stephens | Texas | 48429 | 1097 | 32 |
1779267 | 1779267 | 2021-10-03 | Madison | Montana | 30057 | 1097 | 8 |
1780327 | 1780327 | 2021-10-03 | Floyd | Texas | 48153 | 1097 | 34 |
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);