ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
531 rows where cases = 583 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 45
- Nebraska 43
- Georgia 30
- Virginia 29
- Kansas 28
- Missouri 25
- Kentucky 21
- Minnesota 21
- Alabama 19
- Montana 18
- North Dakota 17
- Puerto Rico 16
- South Dakota 16
- Indiana 14
- Arkansas 12
- Illinois 11
- Iowa 11
- Mississippi 11
- Wisconsin 11
- Michigan 10
- Ohio 8
- Oklahoma 8
- Colorado 7
- Maine 7
- New York 6
- North Carolina 6
- Oregon 6
- South Carolina 6
- Tennessee 6
- Wyoming 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501605 | 2501605 | 2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 |
2485041 | 2485041 | 2022-05-08 | Sherman | Nebraska | 31163 | 583 | 4 |
2481783 | 2481783 | 2022-05-07 | Sherman | Nebraska | 31163 | 583 | 4 |
2478525 | 2478525 | 2022-05-06 | Sherman | Nebraska | 31163 | 583 | 4 |
2475267 | 2475267 | 2022-05-05 | Sherman | Nebraska | 31163 | 583 | 4 |
2472010 | 2472010 | 2022-05-04 | Sherman | Nebraska | 31163 | 583 | 4 |
2468754 | 2468754 | 2022-05-03 | Sherman | Nebraska | 31163 | 583 | 4 |
2436826 | 2436826 | 2022-04-23 | Maricao | Puerto Rico | 72093 | 583 | |
2280009 | 2280009 | 2022-03-06 | Sherman | Nebraska | 31163 | 583 | 4 |
2276756 | 2276756 | 2022-03-05 | Sherman | Nebraska | 31163 | 583 | 4 |
2273503 | 2273503 | 2022-03-04 | Sherman | Nebraska | 31163 | 583 | 4 |
2260496 | 2260496 | 2022-02-28 | Sherman | Nebraska | 31163 | 583 | 4 |
2231491 | 2231491 | 2022-02-19 | Adams | North Dakota | 38001 | 583 | 9 |
2177900 | 2177900 | 2022-02-03 | Glascock | Georgia | 13125 | 583 | 23 |
2174647 | 2174647 | 2022-02-02 | Glascock | Georgia | 13125 | 583 | 23 |
2171394 | 2171394 | 2022-02-01 | Glascock | Georgia | 13125 | 583 | 23 |
2161438 | 2161438 | 2022-01-29 | Custer | Colorado | 8027 | 583 | 17 |
2163233 | 2163233 | 2022-01-29 | Towner | North Dakota | 38095 | 583 | 11 |
2154929 | 2154929 | 2022-01-27 | Custer | Colorado | 8027 | 583 | 17 |
2150664 | 2150664 | 2022-01-25 | Jackson | South Dakota | 46071 | 583 | 20 |
2140435 | 2140435 | 2022-01-22 | McIntosh | North Dakota | 38051 | 583 | 9 |
2132883 | 2132883 | 2022-01-20 | Smith | Kansas | 20183 | 583 | 5 |
2129630 | 2129630 | 2022-01-19 | Smith | Kansas | 20183 | 583 | 5 |
2112940 | 2112940 | 2022-01-14 | Adams | Idaho | 16003 | 583 | 14 |
2097879 | 2097879 | 2022-01-09 | Stanton | Nebraska | 31167 | 583 | 11 |
2094627 | 2094627 | 2022-01-08 | Stanton | Nebraska | 31167 | 583 | 11 |
2094899 | 2094899 | 2022-01-08 | Hettinger | North Dakota | 38041 | 583 | 7 |
2091375 | 2091375 | 2022-01-07 | Stanton | Nebraska | 31167 | 583 | 11 |
2092455 | 2092455 | 2022-01-07 | Shackelford | Texas | 48417 | 583 | 9 |
2079530 | 2079530 | 2022-01-03 | Grand Isle | Vermont | 50013 | 583 | 3 |
2042729 | 2042729 | 2021-12-23 | Hamilton | New York | 36041 | 583 | 4 |
2036382 | 2036382 | 2021-12-21 | Eddy | North Dakota | 38027 | 583 | 6 |
2036744 | 2036744 | 2021-12-21 | Maunabo | Puerto Rico | 72095 | 583 | |
2036838 | 2036838 | 2021-12-21 | Clark | South Dakota | 46025 | 583 | 6 |
2033494 | 2033494 | 2021-12-20 | Maunabo | Puerto Rico | 72095 | 583 | |
2027394 | 2027394 | 2021-12-18 | Mason | Texas | 48319 | 583 | 8 |
2024143 | 2024143 | 2021-12-17 | Mason | Texas | 48319 | 583 | 8 |
2016874 | 2016874 | 2021-12-15 | Cavalier | North Dakota | 38019 | 583 | 6 |
1985073 | 1985073 | 2021-12-05 | Hall | Texas | 48191 | 583 | 15 |
1981823 | 1981823 | 2021-12-04 | Hall | Texas | 48191 | 583 | 15 |
1971076 | 1971076 | 2021-12-01 | Kimball | Nebraska | 31105 | 583 | 9 |
1951510 | 1951510 | 2021-11-25 | Sweet Grass | Montana | 30097 | 583 | 8 |
1951867 | 1951867 | 2021-11-25 | Emmons | North Dakota | 38029 | 583 | 16 |
1948259 | 1948259 | 2021-11-24 | Sweet Grass | Montana | 30097 | 583 | 8 |
1944523 | 1944523 | 2021-11-23 | Unknown | Louisiana | 583 | 0 | |
1945008 | 1945008 | 2021-11-23 | Sweet Grass | Montana | 30097 | 583 | 8 |
1940181 | 1940181 | 2021-11-22 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 583 | 6 |
1941273 | 1941273 | 2021-11-22 | Unknown | Louisiana | 583 | 0 | |
1941757 | 1941757 | 2021-11-22 | Sweet Grass | Montana | 30097 | 583 | 8 |
1938507 | 1938507 | 2021-11-21 | Sweet Grass | Montana | 30097 | 583 | 8 |
1935257 | 1935257 | 2021-11-20 | Sweet Grass | Montana | 30097 | 583 | 8 |
1932007 | 1932007 | 2021-11-19 | Sweet Grass | Montana | 30097 | 583 | 8 |
1928756 | 1928756 | 2021-11-18 | Sweet Grass | Montana | 30097 | 583 | 8 |
1925506 | 1925506 | 2021-11-17 | Sweet Grass | Montana | 30097 | 583 | 8 |
1923550 | 1923550 | 2021-11-16 | Craig | Virginia | 51045 | 583 | 9 |
1871340 | 1871340 | 2021-10-31 | Hudspeth | Texas | 48229 | 583 | 14 |
1868091 | 1868091 | 2021-10-30 | Hudspeth | Texas | 48229 | 583 | 14 |
1864842 | 1864842 | 2021-10-29 | Hudspeth | Texas | 48229 | 583 | 14 |
1861593 | 1861593 | 2021-10-28 | Hudspeth | Texas | 48229 | 583 | 14 |
1857926 | 1857926 | 2021-10-27 | Sullivan | Pennsylvania | 42113 | 583 | 24 |
1858344 | 1858344 | 2021-10-27 | Hudspeth | Texas | 48229 | 583 | 14 |
1854130 | 1854130 | 2021-10-26 | Lincoln | Nevada | 32017 | 583 | 5 |
1854677 | 1854677 | 2021-10-26 | Sullivan | Pennsylvania | 42113 | 583 | 24 |
1855095 | 1855095 | 2021-10-26 | Hudspeth | Texas | 48229 | 583 | 14 |
1851428 | 1851428 | 2021-10-25 | Sullivan | Pennsylvania | 42113 | 583 | 24 |
1851846 | 1851846 | 2021-10-25 | Hudspeth | Texas | 48229 | 583 | 14 |
1847868 | 1847868 | 2021-10-24 | Bowman | North Dakota | 38011 | 583 | 7 |
1848596 | 1848596 | 2021-10-24 | Hudspeth | Texas | 48229 | 583 | 14 |
1845346 | 1845346 | 2021-10-23 | Hudspeth | Texas | 48229 | 583 | 14 |
1842096 | 1842096 | 2021-10-22 | Hudspeth | Texas | 48229 | 583 | 14 |
1837097 | 1837097 | 2021-10-21 | Stafford | Kansas | 20185 | 583 | 16 |
1838847 | 1838847 | 2021-10-21 | Hudspeth | Texas | 48229 | 583 | 14 |
1833848 | 1833848 | 2021-10-20 | Stafford | Kansas | 20185 | 583 | 16 |
1835598 | 1835598 | 2021-10-20 | Hudspeth | Texas | 48229 | 583 | 14 |
1828845 | 1828845 | 2021-10-18 | Edmunds | South Dakota | 46045 | 583 | 14 |
1819430 | 1819430 | 2021-10-15 | Reagan | Texas | 48383 | 583 | 10 |
1801677 | 1801677 | 2021-10-10 | Ontonagon | Michigan | 26131 | 583 | 22 |
1803540 | 1803540 | 2021-10-10 | Florence | Wisconsin | 55037 | 583 | 13 |
1798428 | 1798428 | 2021-10-09 | Ontonagon | Michigan | 26131 | 583 | 22 |
1800291 | 1800291 | 2021-10-09 | Florence | Wisconsin | 55037 | 583 | 13 |
1795179 | 1795179 | 2021-10-08 | Ontonagon | Michigan | 26131 | 583 | 22 |
1797042 | 1797042 | 2021-10-08 | Florence | Wisconsin | 55037 | 583 | 13 |
1790227 | 1790227 | 2021-10-06 | Upton | Texas | 48461 | 583 | 13 |
1780992 | 1780992 | 2021-10-04 | Calhoun | Arkansas | 5013 | 583 | 7 |
1783868 | 1783868 | 2021-10-04 | King and Queen | Virginia | 51097 | 583 | 8 |
1777742 | 1777742 | 2021-10-03 | Calhoun | Arkansas | 5013 | 583 | 7 |
1774492 | 1774492 | 2021-10-02 | Calhoun | Arkansas | 5013 | 583 | 7 |
1723410 | 1723410 | 2021-09-16 | Carlisle | Kentucky | 21039 | 583 | 10 |
1725478 | 1725478 | 2021-09-16 | Skamania | Washington | 53059 | 583 | 3 |
1721168 | 1721168 | 2021-09-15 | LaMoure | North Dakota | 38045 | 583 | 17 |
1710939 | 1710939 | 2021-09-12 | Holt | Missouri | 29087 | 583 | 16 |
1711048 | 1711048 | 2021-09-12 | Phillips | Montana | 30071 | 583 | 17 |
1707692 | 1707692 | 2021-09-11 | Holt | Missouri | 29087 | 583 | 16 |
1707801 | 1707801 | 2021-09-11 | Phillips | Montana | 30071 | 583 | 17 |
1704445 | 1704445 | 2021-09-10 | Holt | Missouri | 29087 | 583 | 16 |
1704554 | 1704554 | 2021-09-10 | Phillips | Montana | 30071 | 583 | 17 |
1695634 | 1695634 | 2021-09-07 | Corson | South Dakota | 46031 | 583 | 12 |
1692386 | 1692386 | 2021-09-06 | Corson | South Dakota | 46031 | 583 | 12 |
1689137 | 1689137 | 2021-09-05 | Corson | South Dakota | 46031 | 583 | 12 |
1685887 | 1685887 | 2021-09-04 | Corson | South Dakota | 46031 | 583 | 12 |
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);