ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
588 rows where cases = 546 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 46
- Texas 62
- Arkansas 41
- North Dakota 40
- Virginia 36
- Georgia 34
- West Virginia 28
- Minnesota 26
- South Dakota 23
- Puerto Rico 19
- Illinois 18
- Kansas 18
- Nebraska 18
- Kentucky 17
- New Mexico 16
- North Carolina 16
- Iowa 15
- Missouri 14
- Alabama 13
- Michigan 12
- Tennessee 11
- Colorado 10
- Montana 9
- Nevada 9
- Idaho 8
- Louisiana 8
- Wisconsin 8
- Florida 7
- Oklahoma 7
- Pennsylvania 6
- Indiana 5
- Ohio 5
- Mississippi 4
- New York 4
- Alaska 3
- Vermont 3
- Arizona 2
- California 2
- Massachusetts 2
- Oregon 2
- Connecticut 1
- Maryland 1
- New Hampshire 1
- South Carolina 1
- Utah 1
- Virgin Islands 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501264 | 2501264 | 2022-05-13 | Cherry | Nebraska | 31031 | 546 | 10 |
2498006 | 2498006 | 2022-05-12 | Cherry | Nebraska | 31031 | 546 | 10 |
2494748 | 2494748 | 2022-05-11 | Cherry | Nebraska | 31031 | 546 | 10 |
2445984 | 2445984 | 2022-04-26 | Lincoln | Nevada | 32017 | 546 | 7 |
2442729 | 2442729 | 2022-04-25 | Lincoln | Nevada | 32017 | 546 | 7 |
2439473 | 2439473 | 2022-04-24 | Lincoln | Nevada | 32017 | 546 | 7 |
2436217 | 2436217 | 2022-04-23 | Lincoln | Nevada | 32017 | 546 | 7 |
2432961 | 2432961 | 2022-04-22 | Lincoln | Nevada | 32017 | 546 | 7 |
2429705 | 2429705 | 2022-04-21 | Lincoln | Nevada | 32017 | 546 | 7 |
2426449 | 2426449 | 2022-04-20 | Lincoln | Nevada | 32017 | 546 | 7 |
2273795 | 2273795 | 2022-03-04 | Renville | North Dakota | 38075 | 546 | 15 |
2270542 | 2270542 | 2022-03-03 | Renville | North Dakota | 38075 | 546 | 15 |
2267290 | 2267290 | 2022-03-02 | Renville | North Dakota | 38075 | 546 | 15 |
2264038 | 2264038 | 2022-03-01 | Renville | North Dakota | 38075 | 546 | 15 |
2260787 | 2260787 | 2022-02-28 | Renville | North Dakota | 38075 | 546 | 15 |
2257536 | 2257536 | 2022-02-27 | Renville | North Dakota | 38075 | 546 | 15 |
2254285 | 2254285 | 2022-02-26 | Renville | North Dakota | 38075 | 546 | 15 |
2251034 | 2251034 | 2022-02-25 | Renville | North Dakota | 38075 | 546 | 15 |
2247783 | 2247783 | 2022-02-24 | Renville | North Dakota | 38075 | 546 | 15 |
2244532 | 2244532 | 2022-02-23 | Renville | North Dakota | 38075 | 546 | 15 |
2241281 | 2241281 | 2022-02-22 | Renville | North Dakota | 38075 | 546 | 15 |
2241619 | 2241619 | 2022-02-22 | Maricao | Puerto Rico | 72093 | 546 | |
2238030 | 2238030 | 2022-02-21 | Renville | North Dakota | 38075 | 546 | 15 |
2238368 | 2238368 | 2022-02-21 | Maricao | Puerto Rico | 72093 | 546 | |
2234779 | 2234779 | 2022-02-20 | Renville | North Dakota | 38075 | 546 | 15 |
2235117 | 2235117 | 2022-02-20 | Maricao | Puerto Rico | 72093 | 546 | |
2231528 | 2231528 | 2022-02-19 | Renville | North Dakota | 38075 | 546 | 15 |
2222220 | 2222220 | 2022-02-16 | Faulk | South Dakota | 46049 | 546 | 16 |
2198786 | 2198786 | 2022-02-09 | De Baca | New Mexico | 35011 | 546 | 5 |
2180172 | 2180172 | 2022-02-03 | Hardeman | Texas | 48197 | 546 | 14 |
2166956 | 2166956 | 2022-01-30 | Sanborn | South Dakota | 46111 | 546 | 5 |
2163701 | 2163701 | 2022-01-29 | Sanborn | South Dakota | 46111 | 546 | 5 |
2159950 | 2159950 | 2022-01-28 | Griggs | North Dakota | 38039 | 546 | 2 |
2160446 | 2160446 | 2022-01-28 | Sanborn | South Dakota | 46111 | 546 | 5 |
2145365 | 2145365 | 2022-01-24 | Glascock | Georgia | 13125 | 546 | 22 |
2137201 | 2137201 | 2022-01-21 | Towner | North Dakota | 38095 | 546 | 11 |
2098646 | 2098646 | 2022-01-09 | Stanley | South Dakota | 46117 | 546 | 3 |
2095394 | 2095394 | 2022-01-08 | Stanley | South Dakota | 46117 | 546 | 3 |
2092142 | 2092142 | 2022-01-07 | Stanley | South Dakota | 46117 | 546 | 3 |
2037904 | 2037904 | 2021-12-22 | Ouray | Colorado | 8091 | 546 | 6 |
2040119 | 2040119 | 2021-12-22 | Marshall | South Dakota | 46091 | 546 | 8 |
2019103 | 2019103 | 2021-12-16 | Trego | Kansas | 20195 | 546 | 9 |
2015853 | 2015853 | 2021-12-15 | Trego | Kansas | 20195 | 546 | 9 |
2012974 | 2012974 | 2021-12-14 | Lake of the Woods | Minnesota | 27077 | 546 | 5 |
1998189 | 1998189 | 2021-12-09 | Shackelford | Texas | 48417 | 546 | 7 |
1990879 | 1990879 | 2021-12-07 | Hettinger | North Dakota | 38041 | 546 | 7 |
1925394 | 1925394 | 2021-11-17 | Knox | Missouri | 29103 | 546 | 3 |
1921392 | 1921392 | 2021-11-16 | Adams | Iowa | 19003 | 546 | 8 |
1918142 | 1918142 | 2021-11-15 | Adams | Iowa | 19003 | 546 | 8 |
1914892 | 1914892 | 2021-11-14 | Adams | Iowa | 19003 | 546 | 8 |
1911642 | 1911642 | 2021-11-13 | Adams | Iowa | 19003 | 546 | 8 |
1908393 | 1908393 | 2021-11-12 | Adams | Iowa | 19003 | 546 | 8 |
1905144 | 1905144 | 2021-11-11 | Adams | Iowa | 19003 | 546 | 8 |
1901894 | 1901894 | 2021-11-10 | Adams | Iowa | 19003 | 546 | 8 |
1893192 | 1893192 | 2021-11-07 | Union | New Mexico | 35059 | 546 | 12 |
1889942 | 1889942 | 2021-11-06 | Union | New Mexico | 35059 | 546 | 12 |
1886692 | 1886692 | 2021-11-05 | Union | New Mexico | 35059 | 546 | 12 |
1876822 | 1876822 | 2021-11-02 | Kimball | Nebraska | 31105 | 546 | 9 |
1873573 | 1873573 | 2021-11-01 | Kimball | Nebraska | 31105 | 546 | 9 |
1864823 | 1864823 | 2021-10-29 | Hall | Texas | 48191 | 546 | 15 |
1861810 | 1861810 | 2021-10-28 | Craig | Virginia | 51045 | 546 | 7 |
1831345 | 1831345 | 2021-10-19 | Nuckolls | Nebraska | 31129 | 546 | 12 |
1828096 | 1828096 | 2021-10-18 | Nuckolls | Nebraska | 31129 | 546 | 12 |
1818625 | 1818625 | 2021-10-15 | Bowman | North Dakota | 38011 | 546 | 7 |
1809898 | 1809898 | 2021-10-12 | Rappahannock | Virginia | 51157 | 546 | 4 |
1805675 | 1805675 | 2021-10-11 | Wells | North Dakota | 38103 | 546 | 9 |
1789199 | 1789199 | 2021-10-06 | Hidalgo | New Mexico | 35023 | 546 | 11 |
1779947 | 1779947 | 2021-10-03 | Sullivan | Pennsylvania | 42113 | 546 | 24 |
1755561 | 1755561 | 2021-09-26 | Putnam | Illinois | 17155 | 546 | 5 |
1756526 | 1756526 | 2021-09-26 | Mineral | Montana | 30061 | 546 | 9 |
1752313 | 1752313 | 2021-09-25 | Putnam | Illinois | 17155 | 546 | 5 |
1753278 | 1753278 | 2021-09-25 | Mineral | Montana | 30061 | 546 | 9 |
1749064 | 1749064 | 2021-09-24 | Putnam | Illinois | 17155 | 546 | 5 |
1750030 | 1750030 | 2021-09-24 | Mineral | Montana | 30061 | 546 | 9 |
1738560 | 1738560 | 2021-09-20 | Florence | Wisconsin | 55037 | 546 | 13 |
1732699 | 1732699 | 2021-09-19 | Bear Lake | Idaho | 16007 | 546 | 9 |
1729449 | 1729449 | 2021-09-18 | Bear Lake | Idaho | 16007 | 546 | 9 |
1731268 | 1731268 | 2021-09-18 | Maunabo | Puerto Rico | 72095 | 546 | |
1726199 | 1726199 | 2021-09-17 | Bear Lake | Idaho | 16007 | 546 | 9 |
1717201 | 1717201 | 2021-09-14 | Ontonagon | Michigan | 26131 | 546 | 22 |
1713953 | 1713953 | 2021-09-13 | Ontonagon | Michigan | 26131 | 546 | 22 |
1664875 | 1664875 | 2021-08-29 | Meade | Kansas | 20119 | 546 | 13 |
1661627 | 1661627 | 2021-08-28 | Meade | Kansas | 20119 | 546 | 13 |
1658379 | 1658379 | 2021-08-27 | Meade | Kansas | 20119 | 546 | 13 |
1652468 | 1652468 | 2021-08-25 | Holt | Missouri | 29087 | 546 | 15 |
1644687 | 1644687 | 2021-08-23 | Clear Creek | Colorado | 8019 | 546 | 3 |
1646080 | 1646080 | 2021-08-23 | Phillips | Montana | 30071 | 546 | 16 |
1642681 | 1642681 | 2021-08-22 | Atchison | Missouri | 29005 | 546 | 6 |
1642832 | 1642832 | 2021-08-22 | Pondera | Montana | 30073 | 546 | 3 |
1644131 | 1644131 | 2021-08-22 | Charles City | Virginia | 51036 | 546 | 16 |
1639582 | 1639582 | 2021-08-21 | Pondera | Montana | 30073 | 546 | 3 |
1640881 | 1640881 | 2021-08-21 | Charles City | Virginia | 51036 | 546 | 16 |
1636332 | 1636332 | 2021-08-20 | Pondera | Montana | 30073 | 546 | 3 |
1637631 | 1637631 | 2021-08-20 | Charles City | Virginia | 51036 | 546 | 16 |
1634381 | 1634381 | 2021-08-19 | Charles City | Virginia | 51036 | 546 | 16 |
1631133 | 1631133 | 2021-08-18 | Charles City | Virginia | 51036 | 546 | 16 |
1626965 | 1626965 | 2021-08-17 | LaMoure | North Dakota | 38045 | 546 | 17 |
1623718 | 1623718 | 2021-08-16 | LaMoure | North Dakota | 38045 | 546 | 17 |
1620471 | 1620471 | 2021-08-15 | LaMoure | North Dakota | 38045 | 546 | 17 |
1621402 | 1621402 | 2021-08-15 | Cumberland | Virginia | 51049 | 546 | 10 |
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);