ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
576 rows where cases = 699 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 86
- South Dakota 35
- Georgia 27
- Kentucky 27
- Virginia 26
- Puerto Rico 24
- Illinois 23
- Missouri 20
- Idaho 19
- Iowa 17
- Colorado 15
- North Dakota 15
- Oklahoma 15
- Mississippi 14
- Alabama 13
- Montana 13
- Nebraska 12
- Tennessee 12
- West Virginia 12
- North Carolina 11
- Louisiana 10
- Minnesota 10
- South Carolina 10
- Arkansas 9
- Kansas 9
- California 8
- Pennsylvania 8
- Utah 8
- Ohio 7
- Alaska 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468662 | 2468662 | 2022-05-03 | Sheridan | Montana | 30091 | 699 | 11 |
2465406 | 2465406 | 2022-05-02 | Sheridan | Montana | 30091 | 699 | 11 |
2462151 | 2462151 | 2022-05-01 | Sheridan | Montana | 30091 | 699 | 11 |
2458895 | 2458895 | 2022-04-30 | Sheridan | Montana | 30091 | 699 | 11 |
2455639 | 2455639 | 2022-04-29 | Sheridan | Montana | 30091 | 699 | 11 |
2450977 | 2450977 | 2022-04-28 | Costilla | Colorado | 8023 | 699 | 16 |
2452383 | 2452383 | 2022-04-28 | Sheridan | Montana | 30091 | 699 | 11 |
2447721 | 2447721 | 2022-04-27 | Costilla | Colorado | 8023 | 699 | 16 |
2449127 | 2449127 | 2022-04-27 | Sheridan | Montana | 30091 | 699 | 11 |
2444465 | 2444465 | 2022-04-26 | Costilla | Colorado | 8023 | 699 | 16 |
2402440 | 2402440 | 2022-04-13 | Adams | Idaho | 16003 | 699 | 15 |
2399185 | 2399185 | 2022-04-12 | Adams | Idaho | 16003 | 699 | 15 |
2395930 | 2395930 | 2022-04-11 | Adams | Idaho | 16003 | 699 | 15 |
2392674 | 2392674 | 2022-04-10 | Adams | Idaho | 16003 | 699 | 15 |
2389418 | 2389418 | 2022-04-09 | Adams | Idaho | 16003 | 699 | 15 |
2386163 | 2386163 | 2022-04-08 | Adams | Idaho | 16003 | 699 | 15 |
2382908 | 2382908 | 2022-04-07 | Adams | Idaho | 16003 | 699 | 15 |
2379653 | 2379653 | 2022-04-06 | Adams | Idaho | 16003 | 699 | 15 |
2353627 | 2353627 | 2022-03-29 | Adams | Idaho | 16003 | 699 | 15 |
2350375 | 2350375 | 2022-03-28 | Adams | Idaho | 16003 | 699 | 15 |
2303540 | 2303540 | 2022-03-13 | Potter | South Dakota | 46107 | 699 | 7 |
2300288 | 2300288 | 2022-03-12 | Potter | South Dakota | 46107 | 699 | 7 |
2297036 | 2297036 | 2022-03-11 | Potter | South Dakota | 46107 | 699 | 7 |
2293784 | 2293784 | 2022-03-10 | Potter | South Dakota | 46107 | 699 | 7 |
2188963 | 2188963 | 2022-02-06 | Valley | Nebraska | 31175 | 699 | 6 |
2185710 | 2185710 | 2022-02-05 | Valley | Nebraska | 31175 | 699 | 6 |
2182458 | 2182458 | 2022-02-04 | Valley | Nebraska | 31175 | 699 | 6 |
2179467 | 2179467 | 2022-02-03 | Emmons | North Dakota | 38029 | 699 | 17 |
2176216 | 2176216 | 2022-02-02 | Emmons | North Dakota | 38029 | 699 | 17 |
2102105 | 2102105 | 2022-01-10 | Haskell | Texas | 48207 | 699 | 37 |
2097603 | 2097603 | 2022-01-09 | Sharkey | Mississippi | 28125 | 699 | 21 |
2098854 | 2098854 | 2022-01-09 | Haskell | Texas | 48207 | 699 | 37 |
2094351 | 2094351 | 2022-01-08 | Sharkey | Mississippi | 28125 | 699 | 21 |
2091099 | 2091099 | 2022-01-07 | Sharkey | Mississippi | 28125 | 699 | 21 |
2082722 | 2082722 | 2022-01-04 | Upton | Texas | 48461 | 699 | 15 |
2024027 | 2024027 | 2021-12-17 | Coke | Texas | 48081 | 699 | 18 |
2017853 | 2017853 | 2021-12-15 | King and Queen | Virginia | 51097 | 699 | 9 |
2012287 | 2012287 | 2021-12-14 | Putnam | Illinois | 17155 | 699 | 6 |
2014566 | 2014566 | 2021-12-14 | Craig | Virginia | 51045 | 699 | 11 |
1987623 | 1987623 | 2021-12-06 | Foster | North Dakota | 38031 | 699 | 19 |
1984373 | 1984373 | 2021-12-05 | Foster | North Dakota | 38031 | 699 | 19 |
1981123 | 1981123 | 2021-12-04 | Foster | North Dakota | 38031 | 699 | 19 |
1961658 | 1961658 | 2021-11-28 | Wells | North Dakota | 38103 | 699 | 10 |
1941456 | 1941456 | 2021-11-22 | Kittson | Minnesota | 27069 | 699 | 22 |
1942982 | 1942982 | 2021-11-22 | Garfield | Utah | 49017 | 699 | 12 |
1937358 | 1937358 | 2021-11-21 | Schley | Georgia | 13249 | 699 | 8 |
1939732 | 1939732 | 2021-11-21 | Garfield | Utah | 49017 | 699 | 12 |
1934108 | 1934108 | 2021-11-20 | Schley | Georgia | 13249 | 699 | 8 |
1936482 | 1936482 | 2021-11-20 | Garfield | Utah | 49017 | 699 | 12 |
1930856 | 1930856 | 2021-11-19 | Schley | Georgia | 13249 | 699 | 8 |
1933232 | 1933232 | 2021-11-19 | Garfield | Utah | 49017 | 699 | 12 |
1929456 | 1929456 | 2021-11-18 | Guayanilla | Puerto Rico | 72059 | 699 | |
1930060 | 1930060 | 2021-11-18 | Falls Church city | Virginia | 51610 | 699 | 14 |
1926206 | 1926206 | 2021-11-17 | Guayanilla | Puerto Rico | 72059 | 699 | |
1922956 | 1922956 | 2021-11-16 | Guayanilla | Puerto Rico | 72059 | 699 | |
1919707 | 1919707 | 2021-11-15 | Guayanilla | Puerto Rico | 72059 | 699 | |
1919822 | 1919822 | 2021-11-15 | Corson | South Dakota | 46031 | 699 | 13 |
1916457 | 1916457 | 2021-11-14 | Guayanilla | Puerto Rico | 72059 | 699 | |
1916572 | 1916572 | 2021-11-14 | Corson | South Dakota | 46031 | 699 | 13 |
1913207 | 1913207 | 2021-11-13 | Guayanilla | Puerto Rico | 72059 | 699 | |
1913322 | 1913322 | 2021-11-13 | Corson | South Dakota | 46031 | 699 | 13 |
1908184 | 1908184 | 2021-11-12 | Lincoln | Idaho | 16063 | 699 | 12 |
1910072 | 1910072 | 2021-11-12 | Corson | South Dakota | 46031 | 699 | 13 |
1904935 | 1904935 | 2021-11-11 | Lincoln | Idaho | 16063 | 699 | 12 |
1906373 | 1906373 | 2021-11-11 | LaMoure | North Dakota | 38045 | 699 | 17 |
1901685 | 1901685 | 2021-11-10 | Lincoln | Idaho | 16063 | 699 | 12 |
1898722 | 1898722 | 2021-11-09 | Ringgold | Iowa | 19159 | 699 | 29 |
1895472 | 1895472 | 2021-11-08 | Ringgold | Iowa | 19159 | 699 | 29 |
1892222 | 1892222 | 2021-11-07 | Ringgold | Iowa | 19159 | 699 | 29 |
1888972 | 1888972 | 2021-11-06 | Ringgold | Iowa | 19159 | 699 | 29 |
1885722 | 1885722 | 2021-11-05 | Ringgold | Iowa | 19159 | 699 | 29 |
1882473 | 1882473 | 2021-11-04 | Ringgold | Iowa | 19159 | 699 | 29 |
1884309 | 1884309 | 2021-11-04 | Goliad | Texas | 48175 | 699 | 28 |
1879224 | 1879224 | 2021-11-03 | Ringgold | Iowa | 19159 | 699 | 29 |
1881060 | 1881060 | 2021-11-03 | Goliad | Texas | 48175 | 699 | 28 |
1877811 | 1877811 | 2021-11-02 | Goliad | Texas | 48175 | 699 | 28 |
1874562 | 1874562 | 2021-11-01 | Goliad | Texas | 48175 | 699 | 28 |
1871313 | 1871313 | 2021-10-31 | Goliad | Texas | 48175 | 699 | 28 |
1868064 | 1868064 | 2021-10-30 | Goliad | Texas | 48175 | 699 | 28 |
1864815 | 1864815 | 2021-10-29 | Goliad | Texas | 48175 | 699 | 28 |
1859810 | 1859810 | 2021-10-28 | Meade | Kansas | 20119 | 699 | 14 |
1861114 | 1861114 | 2021-10-28 | Wallowa | Oregon | 41063 | 699 | 12 |
1861566 | 1861566 | 2021-10-28 | Goliad | Texas | 48175 | 699 | 28 |
1856561 | 1856561 | 2021-10-27 | Meade | Kansas | 20119 | 699 | 14 |
1857971 | 1857971 | 2021-10-27 | Hormigueros | Puerto Rico | 72067 | 699 | |
1858317 | 1858317 | 2021-10-27 | Goliad | Texas | 48175 | 699 | 28 |
1854722 | 1854722 | 2021-10-26 | Hormigueros | Puerto Rico | 72067 | 699 | |
1855068 | 1855068 | 2021-10-26 | Goliad | Texas | 48175 | 699 | 28 |
1851473 | 1851473 | 2021-10-25 | Hormigueros | Puerto Rico | 72067 | 699 | |
1851819 | 1851819 | 2021-10-25 | Goliad | Texas | 48175 | 699 | 28 |
1851837 | 1851837 | 2021-10-25 | Hemphill | Texas | 48211 | 699 | 3 |
1848223 | 1848223 | 2021-10-24 | Hormigueros | Puerto Rico | 72067 | 699 | |
1848569 | 1848569 | 2021-10-24 | Goliad | Texas | 48175 | 699 | 28 |
1848587 | 1848587 | 2021-10-24 | Hemphill | Texas | 48211 | 699 | 3 |
1844973 | 1844973 | 2021-10-23 | Hormigueros | Puerto Rico | 72067 | 699 | |
1845319 | 1845319 | 2021-10-23 | Goliad | Texas | 48175 | 699 | 28 |
1845337 | 1845337 | 2021-10-23 | Hemphill | Texas | 48211 | 699 | 3 |
1842069 | 1842069 | 2021-10-22 | Goliad | Texas | 48175 | 699 | 28 |
1838820 | 1838820 | 2021-10-21 | Goliad | Texas | 48175 | 699 | 28 |
1835571 | 1835571 | 2021-10-20 | Goliad | Texas | 48175 | 699 | 28 |
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);