ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where cases = 2073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- Missouri 18
- Oklahoma 15
- Texas 15
- Minnesota 14
- Virginia 13
- Montana 11
- West Virginia 11
- Puerto Rico 10
- Illinois 9
- Kentucky 8
- Tennessee 8
- Alabama 7
- Arkansas 7
- Colorado 7
- Wisconsin 7
- Louisiana 6
- Indiana 5
- Kansas 5
- North Carolina 5
- South Carolina 5
- Iowa 4
- Michigan 4
- Mississippi 4
- Ohio 4
- New York 3
- Northern Mariana Islands 3
- Florida 2
- Maryland 2
- Nebraska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497937 | 2497937 | 2022-05-12 | Blaine | Montana | 30005 | 2073 | 32 |
2494679 | 2494679 | 2022-05-11 | Blaine | Montana | 30005 | 2073 | 32 |
2491421 | 2491421 | 2022-05-10 | Blaine | Montana | 30005 | 2073 | 32 |
2488163 | 2488163 | 2022-05-09 | Blaine | Montana | 30005 | 2073 | 32 |
2484906 | 2484906 | 2022-05-08 | Blaine | Montana | 30005 | 2073 | 32 |
2486430 | 2486430 | 2022-05-08 | Pleasants | West Virginia | 54073 | 2073 | 36 |
2481648 | 2481648 | 2022-05-07 | Blaine | Montana | 30005 | 2073 | 32 |
2483172 | 2483172 | 2022-05-07 | Pleasants | West Virginia | 54073 | 2073 | 36 |
2478390 | 2478390 | 2022-05-06 | Blaine | Montana | 30005 | 2073 | 32 |
2479914 | 2479914 | 2022-05-06 | Pleasants | West Virginia | 54073 | 2073 | 36 |
2475132 | 2475132 | 2022-05-05 | Blaine | Montana | 30005 | 2073 | 32 |
2471875 | 2471875 | 2022-05-04 | Blaine | Montana | 30005 | 2073 | 32 |
2468621 | 2468621 | 2022-05-03 | Carbon | Montana | 30009 | 2073 | 28 |
2388273 | 2388273 | 2022-04-08 | Clay | Texas | 48077 | 2073 | 36 |
2347056 | 2347056 | 2022-03-27 | Montgomery | Georgia | 13209 | 2073 | 51 |
2343803 | 2343803 | 2022-03-26 | Montgomery | Georgia | 13209 | 2073 | 51 |
2340550 | 2340550 | 2022-03-25 | Montgomery | Georgia | 13209 | 2073 | 51 |
2285173 | 2285173 | 2022-03-08 | Candler | Georgia | 13043 | 2073 | 91 |
2282300 | 2282300 | 2022-03-07 | Warren | Indiana | 18171 | 2073 | 27 |
2257864 | 2257864 | 2022-02-27 | Jayuya | Puerto Rico | 72073 | 2073 | |
2226286 | 2226286 | 2022-02-18 | Perry | Alabama | 1105 | 2073 | 42 |
2225788 | 2225788 | 2022-02-17 | Ochiltree | Texas | 48357 | 2073 | 45 |
2215293 | 2215293 | 2022-02-14 | Unknown | Northern Mariana Islands | 2073 | 0 | |
2215861 | 2215861 | 2022-02-14 | Archer | Texas | 48009 | 2073 | 26 |
2212042 | 2212042 | 2022-02-13 | Unknown | Northern Mariana Islands | 2073 | 0 | |
2212610 | 2212610 | 2022-02-13 | Archer | Texas | 48009 | 2073 | 26 |
2208789 | 2208789 | 2022-02-12 | Unknown | Northern Mariana Islands | 2073 | 0 | |
2193474 | 2193474 | 2022-02-07 | Northumberland | Virginia | 51133 | 2073 | 41 |
2175266 | 2175266 | 2022-02-02 | Livingston | Kentucky | 21139 | 2073 | 51 |
2148766 | 2148766 | 2022-01-25 | Washington | Idaho | 16087 | 2073 | 52 |
2131900 | 2131900 | 2022-01-20 | Bullock | Alabama | 1011 | 2073 | 46 |
2110392 | 2110392 | 2022-01-13 | Crawford | Michigan | 26039 | 2073 | 23 |
2107141 | 2107141 | 2022-01-12 | Crawford | Michigan | 26039 | 2073 | 23 |
2094430 | 2094430 | 2022-01-08 | Linn | Missouri | 29115 | 2073 | 58 |
2092030 | 2092030 | 2022-01-07 | Villalba | Puerto Rico | 72149 | 2073 | |
2015932 | 2015932 | 2021-12-15 | Lyon | Kentucky | 21143 | 2073 | 29 |
2006517 | 2006517 | 2021-12-12 | Watonwan | Minnesota | 27165 | 2073 | 21 |
2003266 | 2003266 | 2021-12-11 | Watonwan | Minnesota | 27165 | 2073 | 21 |
2000016 | 2000016 | 2021-12-10 | Watonwan | Minnesota | 27165 | 2073 | 21 |
1984257 | 1984257 | 2021-12-05 | Yates | New York | 36123 | 2073 | 34 |
1975074 | 1975074 | 2021-12-02 | Butte | South Dakota | 46019 | 2073 | 34 |
1962757 | 1962757 | 2021-11-28 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1958699 | 1958699 | 2021-11-27 | Cayey | Puerto Rico | 72035 | 2073 | |
1959506 | 1959506 | 2021-11-27 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1955448 | 1955448 | 2021-11-26 | Cayey | Puerto Rico | 72035 | 2073 | |
1956255 | 1956255 | 2021-11-26 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1953004 | 1953004 | 2021-11-25 | Ashland | Wisconsin | 55003 | 2073 | 21 |
1941624 | 1941624 | 2021-11-22 | Dent | Missouri | 29065 | 2073 | 62 |
1937742 | 1937742 | 2021-11-21 | Allen | Kansas | 20001 | 2073 | 26 |
1934492 | 1934492 | 2021-11-20 | Allen | Kansas | 20001 | 2073 | 26 |
1931241 | 1931241 | 2021-11-19 | Allen | Kansas | 20001 | 2073 | 26 |
1918683 | 1918683 | 2021-11-15 | Chippewa | Minnesota | 27023 | 2073 | 40 |
1891978 | 1891978 | 2021-11-07 | Greene | Illinois | 17061 | 2073 | 53 |
1888728 | 1888728 | 2021-11-06 | Greene | Illinois | 17061 | 2073 | 53 |
1885478 | 1885478 | 2021-11-05 | Greene | Illinois | 17061 | 2073 | 53 |
1881748 | 1881748 | 2021-11-04 | Little River | Arkansas | 5081 | 2073 | 76 |
1882229 | 1882229 | 2021-11-04 | Greene | Illinois | 17061 | 2073 | 53 |
1878118 | 1878118 | 2021-11-02 | Patrick | Virginia | 51141 | 2073 | 55 |
1874854 | 1874854 | 2021-11-01 | Martinsville city | Virginia | 51690 | 2073 | 89 |
1859521 | 1859521 | 2021-10-28 | Mercer | Illinois | 17131 | 2073 | 37 |
1852237 | 1852237 | 2021-10-25 | Monroe | West Virginia | 54063 | 2073 | 25 |
1842488 | 1842488 | 2021-10-22 | Morgan | West Virginia | 54065 | 2073 | 41 |
1835894 | 1835894 | 2021-10-20 | Rockbridge | Virginia | 51163 | 2073 | 57 |
1831008 | 1831008 | 2021-10-19 | Sibley | Minnesota | 27143 | 2073 | 12 |
1767048 | 1767048 | 2021-09-29 | Bamberg | South Carolina | 45009 | 2073 | 61 |
1761560 | 1761560 | 2021-09-28 | Van Buren | Arkansas | 5141 | 2073 | 37 |
1747946 | 1747946 | 2021-09-23 | Pecos | Texas | 48371 | 2073 | 41 |
1743144 | 1743144 | 2021-09-22 | Charlevoix | Michigan | 26029 | 2073 | 29 |
1736922 | 1736922 | 2021-09-20 | Gasconade | Missouri | 29073 | 2073 | 48 |
1722403 | 1722403 | 2021-09-16 | Cleburne | Alabama | 1029 | 2073 | 46 |
1705262 | 1705262 | 2021-09-10 | Fajardo | Puerto Rico | 72053 | 2073 | |
1677533 | 1677533 | 2021-09-02 | Edgar | Illinois | 17045 | 2073 | 62 |
1671527 | 1671527 | 2021-08-31 | Union | Kentucky | 21225 | 2073 | 20 |
1659734 | 1659734 | 2021-08-27 | Montour | Pennsylvania | 42093 | 2073 | 67 |
1657216 | 1657216 | 2021-08-26 | Southampton | Virginia | 51175 | 2073 | 58 |
1634472 | 1634472 | 2021-08-19 | Scott | Virginia | 51169 | 2073 | 61 |
1630515 | 1630515 | 2021-08-18 | Wyoming | Pennsylvania | 42131 | 2073 | 54 |
1630563 | 1630563 | 2021-08-18 | Manati | Puerto Rico | 72091 | 2073 | |
1630800 | 1630800 | 2021-08-18 | Union | Tennessee | 47173 | 2073 | 35 |
1625335 | 1625335 | 2021-08-17 | Banks | Georgia | 13011 | 2073 | 45 |
1627316 | 1627316 | 2021-08-17 | Manati | Puerto Rico | 72091 | 2073 | |
1624845 | 1624845 | 2021-08-16 | Adams | Wisconsin | 55001 | 2073 | 21 |
1598146 | 1598146 | 2021-08-08 | Hampton | South Carolina | 45049 | 2073 | 53 |
1594897 | 1594897 | 2021-08-07 | Hampton | South Carolina | 45049 | 2073 | 53 |
1591648 | 1591648 | 2021-08-06 | Hampton | South Carolina | 45049 | 2073 | 53 |
1583788 | 1583788 | 2021-08-04 | McCreary | Kentucky | 21147 | 2073 | 34 |
1570927 | 1570927 | 2021-07-31 | Garrett | Maryland | 24023 | 2073 | 66 |
1572547 | 1572547 | 2021-07-31 | Shelby | Texas | 48419 | 2073 | 72 |
1566127 | 1566127 | 2021-07-29 | Bennington | Vermont | 50003 | 2073 | 15 |
1558908 | 1558908 | 2021-07-27 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1555087 | 1555087 | 2021-07-26 | Wright | Missouri | 29229 | 2073 | 34 |
1555661 | 1555661 | 2021-07-26 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1552414 | 1552414 | 2021-07-25 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1549167 | 1549167 | 2021-07-24 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1545920 | 1545920 | 2021-07-23 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1542673 | 1542673 | 2021-07-22 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1539425 | 1539425 | 2021-07-21 | Kingfisher | Oklahoma | 40073 | 2073 | 42 |
1540415 | 1540415 | 2021-07-21 | Green Lake | Wisconsin | 55047 | 2073 | 24 |
1537168 | 1537168 | 2021-07-20 | Green Lake | Wisconsin | 55047 | 2073 | 24 |
1513454 | 1513454 | 2021-07-13 | Marshall | Oklahoma | 40095 | 2073 | 23 |
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);