ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
635 rows where cases = 433 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 80
- North Dakota 36
- Georgia 34
- Virginia 32
- Kansas 30
- Alaska 26
- Colorado 25
- Idaho 23
- South Dakota 23
- Michigan 22
- Oklahoma 22
- Kentucky 20
- Iowa 19
- Illinois 16
- Florida 15
- Indiana 15
- Puerto Rico 14
- Arkansas 13
- Louisiana 13
- Missouri 13
- Wisconsin 13
- Minnesota 11
- Nebraska 11
- Mississippi 10
- New Mexico 9
- North Carolina 9
- West Virginia 9
- Alabama 8
- Ohio 8
- Montana 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501592 | 2501592 | 2022-05-13 | Burke | North Dakota | 38013 | 433 | 3 |
2498334 | 2498334 | 2022-05-12 | Burke | North Dakota | 38013 | 433 | 3 |
2495076 | 2495076 | 2022-05-11 | Burke | North Dakota | 38013 | 433 | 3 |
2491818 | 2491818 | 2022-05-10 | Burke | North Dakota | 38013 | 433 | 3 |
2488560 | 2488560 | 2022-05-09 | Burke | North Dakota | 38013 | 433 | 3 |
2485303 | 2485303 | 2022-05-08 | Burke | North Dakota | 38013 | 433 | 3 |
2482045 | 2482045 | 2022-05-07 | Burke | North Dakota | 38013 | 433 | 3 |
2478787 | 2478787 | 2022-05-06 | Burke | North Dakota | 38013 | 433 | 3 |
2301116 | 2301116 | 2022-03-13 | Unknown | American Samoa | 433 | 0 | |
2297864 | 2297864 | 2022-03-12 | Unknown | American Samoa | 433 | 0 | |
2286791 | 2286791 | 2022-03-08 | Logan | North Dakota | 38047 | 433 | 12 |
2277034 | 2277034 | 2022-03-05 | Logan | North Dakota | 38047 | 433 | 12 |
2273781 | 2273781 | 2022-03-04 | Logan | North Dakota | 38047 | 433 | 12 |
2240234 | 2240234 | 2022-02-22 | Wallace | Kansas | 20199 | 433 | 5 |
2236983 | 2236983 | 2022-02-21 | Wallace | Kansas | 20199 | 433 | 5 |
2233732 | 2233732 | 2022-02-20 | Wallace | Kansas | 20199 | 433 | 5 |
2230481 | 2230481 | 2022-02-19 | Wallace | Kansas | 20199 | 433 | 5 |
2227230 | 2227230 | 2022-02-18 | Wallace | Kansas | 20199 | 433 | 5 |
2222476 | 2222476 | 2022-02-16 | Irion | Texas | 48235 | 433 | 3 |
2219225 | 2219225 | 2022-02-15 | Irion | Texas | 48235 | 433 | 3 |
2215974 | 2215974 | 2022-02-14 | Irion | Texas | 48235 | 433 | 3 |
2212723 | 2212723 | 2022-02-13 | Irion | Texas | 48235 | 433 | 3 |
2209470 | 2209470 | 2022-02-12 | Irion | Texas | 48235 | 433 | 3 |
2202869 | 2202869 | 2022-02-10 | Briscoe | Texas | 48045 | 433 | 8 |
2167131 | 2167131 | 2022-01-30 | Edwards | Texas | 48137 | 433 | 10 |
2159949 | 2159949 | 2022-01-28 | Grant | North Dakota | 38037 | 433 | 11 |
2157161 | 2157161 | 2022-01-27 | Haakon | South Dakota | 46055 | 433 | 11 |
2153439 | 2153439 | 2022-01-26 | Golden Valley | North Dakota | 38033 | 433 | 4 |
2150189 | 2150189 | 2022-01-25 | Grant | North Dakota | 38037 | 433 | 11 |
2126317 | 2126317 | 2022-01-18 | Graham | Kansas | 20065 | 433 | 13 |
2127416 | 2127416 | 2022-01-18 | Kidder | North Dakota | 38043 | 433 | 13 |
2123065 | 2123065 | 2022-01-17 | Graham | Kansas | 20065 | 433 | 13 |
2119813 | 2119813 | 2022-01-16 | Graham | Kansas | 20065 | 433 | 13 |
2116561 | 2116561 | 2022-01-15 | Graham | Kansas | 20065 | 433 | 13 |
2113310 | 2113310 | 2022-01-14 | Graham | Kansas | 20065 | 433 | 13 |
2115062 | 2115062 | 2022-01-14 | Culberson | Texas | 48109 | 433 | 13 |
2106272 | 2106272 | 2022-01-12 | Baker | Georgia | 13007 | 433 | 14 |
2040111 | 2040111 | 2021-12-22 | Jackson | South Dakota | 46071 | 433 | 19 |
2036077 | 2036077 | 2021-12-21 | Hitchcock | Nebraska | 31087 | 433 | 5 |
2032827 | 2032827 | 2021-12-20 | Hitchcock | Nebraska | 31087 | 433 | 5 |
2019823 | 2019823 | 2021-12-16 | Hitchcock | Nebraska | 31087 | 433 | 5 |
2016573 | 2016573 | 2021-12-15 | Hitchcock | Nebraska | 31087 | 433 | 5 |
2006939 | 2006939 | 2021-12-12 | Mora | New Mexico | 35033 | 433 | 12 |
2003688 | 2003688 | 2021-12-11 | Mora | New Mexico | 35033 | 433 | 12 |
2000438 | 2000438 | 2021-12-10 | Mora | New Mexico | 35033 | 433 | 12 |
1964905 | 1964905 | 2021-11-29 | Towner | North Dakota | 38095 | 433 | 11 |
1965553 | 1965553 | 2021-11-29 | Fisher | Texas | 48151 | 433 | 17 |
1961653 | 1961653 | 2021-11-28 | Towner | North Dakota | 38095 | 433 | 11 |
1962301 | 1962301 | 2021-11-28 | Fisher | Texas | 48151 | 433 | 17 |
1958402 | 1958402 | 2021-11-27 | Towner | North Dakota | 38095 | 433 | 11 |
1959050 | 1959050 | 2021-11-27 | Fisher | Texas | 48151 | 433 | 17 |
1955151 | 1955151 | 2021-11-26 | Towner | North Dakota | 38095 | 433 | 11 |
1955799 | 1955799 | 2021-11-26 | Fisher | Texas | 48151 | 433 | 17 |
1951900 | 1951900 | 2021-11-25 | Towner | North Dakota | 38095 | 433 | 11 |
1952548 | 1952548 | 2021-11-25 | Fisher | Texas | 48151 | 433 | 17 |
1949297 | 1949297 | 2021-11-24 | Fisher | Texas | 48151 | 433 | 17 |
1945388 | 1945388 | 2021-11-23 | Renville | North Dakota | 38075 | 433 | 14 |
1942137 | 1942137 | 2021-11-22 | Renville | North Dakota | 38075 | 433 | 14 |
1914353 | 1914353 | 2021-11-14 | Custer | Colorado | 8027 | 433 | 9 |
1911103 | 1911103 | 2021-11-13 | Custer | Colorado | 8027 | 433 | 9 |
1907854 | 1907854 | 2021-11-12 | Custer | Colorado | 8027 | 433 | 9 |
1900362 | 1900362 | 2021-11-09 | Perkins | South Dakota | 46105 | 433 | 16 |
1893863 | 1893863 | 2021-11-07 | Potter | South Dakota | 46107 | 433 | 4 |
1890613 | 1890613 | 2021-11-06 | Potter | South Dakota | 46107 | 433 | 4 |
1887363 | 1887363 | 2021-11-05 | Potter | South Dakota | 46107 | 433 | 4 |
1868668 | 1868668 | 2021-10-31 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1865419 | 1865419 | 2021-10-30 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1862170 | 1862170 | 2021-10-29 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1858921 | 1858921 | 2021-10-28 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1855672 | 1855672 | 2021-10-27 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1852423 | 1852423 | 2021-10-26 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1849173 | 1849173 | 2021-10-25 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1845923 | 1845923 | 2021-10-24 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1842673 | 1842673 | 2021-10-23 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1839424 | 1839424 | 2021-10-22 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1836175 | 1836175 | 2021-10-21 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1832926 | 1832926 | 2021-10-20 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1826428 | 1826428 | 2021-10-18 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1823179 | 1823179 | 2021-10-17 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1825604 | 1825604 | 2021-10-17 | Hanson | South Dakota | 46061 | 433 | 4 |
1819930 | 1819930 | 2021-10-16 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1822355 | 1822355 | 2021-10-16 | Hanson | South Dakota | 46061 | 433 | 4 |
1816681 | 1816681 | 2021-10-15 | Aleutians East Borough | Alaska | 2013 | 433 | 3 |
1819106 | 1819106 | 2021-10-15 | Hanson | South Dakota | 46061 | 433 | 4 |
1809532 | 1809532 | 2021-10-12 | Cochran | Texas | 48079 | 433 | 18 |
1806282 | 1806282 | 2021-10-11 | Cochran | Texas | 48079 | 433 | 18 |
1803032 | 1803032 | 2021-10-10 | Cochran | Texas | 48079 | 433 | 18 |
1799783 | 1799783 | 2021-10-09 | Cochran | Texas | 48079 | 433 | 18 |
1799877 | 1799877 | 2021-10-09 | Kimble | Texas | 48267 | 433 | 11 |
1796534 | 1796534 | 2021-10-08 | Cochran | Texas | 48079 | 433 | 18 |
1792897 | 1792897 | 2021-10-07 | Cameron | Pennsylvania | 42023 | 433 | 10 |
1767092 | 1767092 | 2021-09-29 | Bennett | South Dakota | 46007 | 433 | 9 |
1722155 | 1722155 | 2021-09-15 | Norton city | Virginia | 51720 | 433 | 8 |
1696479 | 1696479 | 2021-09-08 | Dillingham Census Area | Alaska | 2070 | 433 | 3 |
1675672 | 1675672 | 2021-09-01 | Bowman | North Dakota | 38011 | 433 | 5 |
1672594 | 1672594 | 2021-08-31 | Harper | Oklahoma | 40059 | 433 | 8 |
1669346 | 1669346 | 2021-08-30 | Harper | Oklahoma | 40059 | 433 | 8 |
1666099 | 1666099 | 2021-08-29 | Harper | Oklahoma | 40059 | 433 | 8 |
1662851 | 1662851 | 2021-08-28 | Harper | Oklahoma | 40059 | 433 | 8 |
1659603 | 1659603 | 2021-08-27 | Harper | Oklahoma | 40059 | 433 | 8 |
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);