ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
512 rows where cases = 712 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 37
- Texas 31
- Nebraska 30
- Wyoming 30
- Puerto Rico 26
- Georgia 25
- Virginia 21
- Montana 19
- Iowa 18
- Mississippi 18
- Illinois 16
- Arkansas 15
- South Dakota 15
- Kentucky 14
- Tennessee 14
- Missouri 13
- Idaho 12
- Indiana 12
- Michigan 12
- Minnesota 11
- North Carolina 11
- Oklahoma 9
- Alabama 8
- Colorado 8
- Ohio 8
- West Virginia 8
- New Mexico 7
- Wisconsin 7
- Alaska 6
- North Dakota 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476277 | 2476277 | 2022-05-05 | Kimble | Texas | 48267 | 712 | 15 |
2473020 | 2473020 | 2022-05-04 | Kimble | Texas | 48267 | 712 | 15 |
2469764 | 2469764 | 2022-05-03 | Kimble | Texas | 48267 | 712 | 15 |
2466508 | 2466508 | 2022-05-02 | Kimble | Texas | 48267 | 712 | 15 |
2463253 | 2463253 | 2022-05-01 | Kimble | Texas | 48267 | 712 | 15 |
2400390 | 2400390 | 2022-04-12 | Webster | Nebraska | 31181 | 712 | 10 |
2397135 | 2397135 | 2022-04-11 | Webster | Nebraska | 31181 | 712 | 10 |
2393880 | 2393880 | 2022-04-10 | Webster | Nebraska | 31181 | 712 | 10 |
2390624 | 2390624 | 2022-04-09 | Webster | Nebraska | 31181 | 712 | 10 |
2387368 | 2387368 | 2022-04-08 | Webster | Nebraska | 31181 | 712 | 10 |
2384113 | 2384113 | 2022-04-07 | Webster | Nebraska | 31181 | 712 | 10 |
2380858 | 2380858 | 2022-04-06 | Webster | Nebraska | 31181 | 712 | 10 |
2377603 | 2377603 | 2022-04-05 | Webster | Nebraska | 31181 | 712 | 10 |
2374350 | 2374350 | 2022-04-04 | Webster | Nebraska | 31181 | 712 | 10 |
2374998 | 2374998 | 2022-04-04 | Vieques | Puerto Rico | 72147 | 712 | |
2371098 | 2371098 | 2022-04-03 | Webster | Nebraska | 31181 | 712 | 10 |
2371746 | 2371746 | 2022-04-03 | Vieques | Puerto Rico | 72147 | 712 | |
2367845 | 2367845 | 2022-04-02 | Webster | Nebraska | 31181 | 712 | 10 |
2368493 | 2368493 | 2022-04-02 | Vieques | Puerto Rico | 72147 | 712 | |
2364592 | 2364592 | 2022-04-01 | Webster | Nebraska | 31181 | 712 | 10 |
2365240 | 2365240 | 2022-04-01 | Vieques | Puerto Rico | 72147 | 712 | |
2361338 | 2361338 | 2022-03-31 | Webster | Nebraska | 31181 | 712 | 10 |
2361987 | 2361987 | 2022-03-31 | Vieques | Puerto Rico | 72147 | 712 | |
2354831 | 2354831 | 2022-03-29 | Webster | Nebraska | 31181 | 712 | 10 |
2198986 | 2198986 | 2022-02-09 | Emmons | North Dakota | 38029 | 712 | 17 |
2195434 | 2195434 | 2022-02-08 | Kimball | Nebraska | 31105 | 712 | 9 |
2188570 | 2188570 | 2022-02-06 | Lake of the Woods | Minnesota | 27077 | 712 | 5 |
2189966 | 2189966 | 2022-02-06 | Kinney | Texas | 48271 | 712 | 10 |
2185317 | 2185317 | 2022-02-05 | Lake of the Woods | Minnesota | 27077 | 712 | 5 |
2186713 | 2186713 | 2022-02-05 | Kinney | Texas | 48271 | 712 | 10 |
2182065 | 2182065 | 2022-02-04 | Lake of the Woods | Minnesota | 27077 | 712 | 5 |
2183461 | 2183461 | 2022-02-04 | Kinney | Texas | 48271 | 712 | 10 |
2175880 | 2175880 | 2022-02-02 | Chase | Nebraska | 31029 | 712 | 6 |
2164505 | 2164505 | 2022-01-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 712 | 1 |
2161250 | 2161250 | 2022-01-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 712 | 1 |
2157994 | 2157994 | 2022-01-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 712 | 1 |
2155664 | 2155664 | 2022-01-27 | Trego | Kansas | 20195 | 712 | 9 |
2152411 | 2152411 | 2022-01-26 | Trego | Kansas | 20195 | 712 | 9 |
2098500 | 2098500 | 2022-01-09 | Las Marias | Puerto Rico | 72083 | 712 | |
2075848 | 2075848 | 2022-01-02 | Edmunds | South Dakota | 46045 | 712 | 14 |
2076029 | 2076029 | 2022-01-02 | Coke | Texas | 48081 | 712 | 18 |
2072597 | 2072597 | 2022-01-01 | Edmunds | South Dakota | 46045 | 712 | 14 |
2072778 | 2072778 | 2022-01-01 | Coke | Texas | 48081 | 712 | 18 |
2069346 | 2069346 | 2021-12-31 | Edmunds | South Dakota | 46045 | 712 | 14 |
2069527 | 2069527 | 2021-12-31 | Coke | Texas | 48081 | 712 | 18 |
2066095 | 2066095 | 2021-12-30 | Edmunds | South Dakota | 46045 | 712 | 14 |
2066276 | 2066276 | 2021-12-30 | Coke | Texas | 48081 | 712 | 18 |
2037357 | 2037357 | 2021-12-21 | King and Queen | Virginia | 51097 | 712 | 9 |
2010092 | 2010092 | 2021-12-13 | Nuckolls | Nebraska | 31129 | 712 | 12 |
2010691 | 2010691 | 2021-12-13 | Adjuntas | Puerto Rico | 72001 | 712 | |
2007440 | 2007440 | 2021-12-12 | Adjuntas | Puerto Rico | 72001 | 712 | |
2003877 | 2003877 | 2021-12-11 | Foster | North Dakota | 38031 | 712 | 19 |
1991220 | 1991220 | 2021-12-07 | Hormigueros | Puerto Rico | 72067 | 712 | |
1986115 | 1986115 | 2021-12-06 | Schley | Georgia | 13249 | 712 | 8 |
1987969 | 1987969 | 2021-12-06 | Hormigueros | Puerto Rico | 72067 | 712 | |
1984715 | 1984715 | 2021-12-05 | Guayanilla | Puerto Rico | 72059 | 712 | |
1984719 | 1984719 | 2021-12-05 | Hormigueros | Puerto Rico | 72067 | 712 | |
1981465 | 1981465 | 2021-12-04 | Guayanilla | Puerto Rico | 72059 | 712 | |
1981469 | 1981469 | 2021-12-04 | Hormigueros | Puerto Rico | 72067 | 712 | |
1978219 | 1978219 | 2021-12-03 | Hormigueros | Puerto Rico | 72067 | 712 | |
1974969 | 1974969 | 2021-12-02 | Hormigueros | Puerto Rico | 72067 | 712 | |
1968581 | 1968581 | 2021-11-30 | Corson | South Dakota | 46031 | 712 | 13 |
1951209 | 1951209 | 2021-11-25 | Kittson | Minnesota | 27069 | 712 | 23 |
1947958 | 1947958 | 2021-11-24 | Kittson | Minnesota | 27069 | 712 | 23 |
1923324 | 1923324 | 2021-11-16 | Hemphill | Texas | 48211 | 712 | 3 |
1918349 | 1918349 | 2021-11-15 | Ballard | Kentucky | 21007 | 712 | 20 |
1901402 | 1901402 | 2021-11-10 | Washington | Colorado | 8121 | 712 | 21 |
1898152 | 1898152 | 2021-11-09 | Washington | Colorado | 8121 | 712 | 20 |
1891646 | 1891646 | 2021-11-07 | Saguache | Colorado | 8109 | 712 | 8 |
1888396 | 1888396 | 2021-11-06 | Saguache | Colorado | 8109 | 712 | 8 |
1885146 | 1885146 | 2021-11-05 | Saguache | Colorado | 8109 | 712 | 8 |
1875660 | 1875660 | 2021-11-02 | Bear Lake | Idaho | 16007 | 712 | 13 |
1876744 | 1876744 | 2021-11-02 | Mineral | Montana | 30061 | 712 | 13 |
1849744 | 1849744 | 2021-10-25 | Henderson | Illinois | 17071 | 712 | 23 |
1846543 | 1846543 | 2021-10-24 | Scott | Illinois | 17171 | 712 | 6 |
1848815 | 1848815 | 2021-10-24 | Cumberland | Virginia | 51049 | 712 | 17 |
1843293 | 1843293 | 2021-10-23 | Scott | Illinois | 17171 | 712 | 6 |
1845565 | 1845565 | 2021-10-23 | Cumberland | Virginia | 51049 | 712 | 17 |
1840043 | 1840043 | 2021-10-22 | Scott | Illinois | 17171 | 712 | 6 |
1842315 | 1842315 | 2021-10-22 | Cumberland | Virginia | 51049 | 712 | 17 |
1836794 | 1836794 | 2021-10-21 | Scott | Illinois | 17171 | 712 | 6 |
1785115 | 1785115 | 2021-10-05 | Stevens | Kansas | 20189 | 712 | 12 |
1786302 | 1786302 | 2021-10-05 | Greer | Oklahoma | 40055 | 712 | 23 |
1781866 | 1781866 | 2021-10-04 | Stevens | Kansas | 20189 | 712 | 12 |
1783053 | 1783053 | 2021-10-04 | Greer | Oklahoma | 40055 | 712 | 23 |
1779804 | 1779804 | 2021-10-03 | Greer | Oklahoma | 40055 | 712 | 23 |
1776554 | 1776554 | 2021-10-02 | Greer | Oklahoma | 40055 | 712 | 23 |
1773304 | 1773304 | 2021-10-01 | Greer | Oklahoma | 40055 | 712 | 23 |
1770054 | 1770054 | 2021-09-30 | Greer | Oklahoma | 40055 | 712 | 23 |
1766805 | 1766805 | 2021-09-29 | Greer | Oklahoma | 40055 | 712 | 23 |
1758650 | 1758650 | 2021-09-27 | Talbot | Georgia | 13263 | 712 | 23 |
1758717 | 1758717 | 2021-09-27 | Lemhi | Idaho | 16059 | 712 | 13 |
1709411 | 1709411 | 2021-09-12 | Choctaw | Alabama | 1023 | 712 | 25 |
1710359 | 1710359 | 2021-09-12 | Morris | Kansas | 20127 | 712 | 23 |
1706164 | 1706164 | 2021-09-11 | Choctaw | Alabama | 1023 | 712 | 25 |
1707112 | 1707112 | 2021-09-11 | Morris | Kansas | 20127 | 712 | 23 |
1703864 | 1703864 | 2021-09-10 | Morris | Kansas | 20127 | 712 | 23 |
1702890 | 1702890 | 2021-09-09 | Hot Springs | Wyoming | 56017 | 712 | 4 |
1666312 | 1666312 | 2021-08-29 | Sabana Grande | Puerto Rico | 72121 | 712 | |
1656216 | 1656216 | 2021-08-26 | Ransom | North Dakota | 38073 | 712 | 17 |
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);