ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
576 rows where cases = 499 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 31
- Kentucky 28
- Virginia 25
- Illinois 19
- Kansas 19
- Michigan 18
- Puerto Rico 18
- South Dakota 18
- Minnesota 17
- Montana 17
- Louisiana 16
- Wyoming 15
- Nebraska 14
- Idaho 12
- Indiana 12
- Mississippi 12
- North Carolina 12
- Iowa 11
- West Virginia 11
- Missouri 10
- Rhode Island 10
- New Mexico 9
- Colorado 8
- Ohio 8
- Washington 8
- Arkansas 7
- Oklahoma 7
- Pennsylvania 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502418 | 2502418 | 2022-05-13 | Sherman | Texas | 48421 | 499 | 16 |
2499160 | 2499160 | 2022-05-12 | Sherman | Texas | 48421 | 499 | 16 |
2495902 | 2495902 | 2022-05-11 | Sherman | Texas | 48421 | 499 | 16 |
2492644 | 2492644 | 2022-05-10 | Sherman | Texas | 48421 | 499 | 16 |
2489386 | 2489386 | 2022-05-09 | Sherman | Texas | 48421 | 499 | 16 |
2486128 | 2486128 | 2022-05-08 | Sherman | Texas | 48421 | 499 | 16 |
2482870 | 2482870 | 2022-05-07 | Sherman | Texas | 48421 | 499 | 16 |
2479612 | 2479612 | 2022-05-06 | Sherman | Texas | 48421 | 499 | 16 |
2476354 | 2476354 | 2022-05-05 | Sherman | Texas | 48421 | 499 | 16 |
2473097 | 2473097 | 2022-05-04 | Sherman | Texas | 48421 | 499 | 16 |
2469841 | 2469841 | 2022-05-03 | Sherman | Texas | 48421 | 499 | 16 |
2466585 | 2466585 | 2022-05-02 | Sherman | Texas | 48421 | 499 | 16 |
2463330 | 2463330 | 2022-05-01 | Sherman | Texas | 48421 | 499 | 16 |
2460074 | 2460074 | 2022-04-30 | Sherman | Texas | 48421 | 499 | 16 |
2456818 | 2456818 | 2022-04-29 | Sherman | Texas | 48421 | 499 | 16 |
2453562 | 2453562 | 2022-04-28 | Sherman | Texas | 48421 | 499 | 16 |
2450306 | 2450306 | 2022-04-27 | Sherman | Texas | 48421 | 499 | 16 |
2447049 | 2447049 | 2022-04-26 | Sherman | Texas | 48421 | 499 | 16 |
2443794 | 2443794 | 2022-04-25 | Sherman | Texas | 48421 | 499 | 16 |
2440538 | 2440538 | 2022-04-24 | Sherman | Texas | 48421 | 499 | 16 |
2437282 | 2437282 | 2022-04-23 | Sherman | Texas | 48421 | 499 | 16 |
2434026 | 2434026 | 2022-04-22 | Sherman | Texas | 48421 | 499 | 16 |
2331205 | 2331205 | 2022-03-22 | Clark | Kansas | 20025 | 499 | 7 |
2327953 | 2327953 | 2022-03-21 | Clark | Kansas | 20025 | 499 | 7 |
2260771 | 2260771 | 2022-02-28 | Kidder | North Dakota | 38043 | 499 | 13 |
2261376 | 2261376 | 2022-02-28 | Armstrong | Texas | 48011 | 499 | 8 |
2257520 | 2257520 | 2022-02-27 | Kidder | North Dakota | 38043 | 499 | 13 |
2258125 | 2258125 | 2022-02-27 | Armstrong | Texas | 48011 | 499 | 8 |
2254269 | 2254269 | 2022-02-26 | Kidder | North Dakota | 38043 | 499 | 13 |
2254874 | 2254874 | 2022-02-26 | Armstrong | Texas | 48011 | 499 | 8 |
2230770 | 2230770 | 2022-02-19 | Keweenaw | Michigan | 26083 | 499 | 12 |
2227519 | 2227519 | 2022-02-18 | Keweenaw | Michigan | 26083 | 499 | 12 |
2223058 | 2223058 | 2022-02-17 | Haines Borough | Alaska | 2100 | 499 | 1 |
2224268 | 2224268 | 2022-02-17 | Keweenaw | Michigan | 26083 | 499 | 12 |
2219807 | 2219807 | 2022-02-16 | Haines Borough | Alaska | 2100 | 499 | 1 |
2221017 | 2221017 | 2022-02-16 | Keweenaw | Michigan | 26083 | 499 | 12 |
2190037 | 2190037 | 2022-02-06 | Schleicher | Texas | 48413 | 499 | 9 |
2186784 | 2186784 | 2022-02-05 | Schleicher | Texas | 48413 | 499 | 9 |
2178024 | 2178024 | 2022-02-03 | Custer | Idaho | 16037 | 499 | 7 |
2180128 | 2180128 | 2022-02-03 | Culberson | Texas | 48109 | 499 | 13 |
2173323 | 2173323 | 2022-02-01 | Maricao | Puerto Rico | 72093 | 499 | |
2170071 | 2170071 | 2022-01-31 | Maricao | Puerto Rico | 72093 | 499 | |
2166817 | 2166817 | 2022-01-30 | Maricao | Puerto Rico | 72093 | 499 | |
2127395 | 2127395 | 2022-01-18 | Adams | North Dakota | 38001 | 499 | 9 |
2124635 | 2124635 | 2022-01-17 | Jackson | South Dakota | 46071 | 499 | 20 |
2124656 | 2124656 | 2022-01-17 | Sanborn | South Dakota | 46111 | 499 | 5 |
2121383 | 2121383 | 2022-01-16 | Jackson | South Dakota | 46071 | 499 | 20 |
2121404 | 2121404 | 2022-01-16 | Sanborn | South Dakota | 46111 | 499 | 5 |
2118131 | 2118131 | 2022-01-15 | Jackson | South Dakota | 46071 | 499 | 20 |
2118152 | 2118152 | 2022-01-15 | Sanborn | South Dakota | 46111 | 499 | 5 |
2114880 | 2114880 | 2022-01-14 | Jackson | South Dakota | 46071 | 499 | 20 |
2114901 | 2114901 | 2022-01-14 | Sanborn | South Dakota | 46111 | 499 | 5 |
2109195 | 2109195 | 2022-01-13 | Aleutians East Borough | Alaska | 2013 | 499 | 3 |
2111155 | 2111155 | 2022-01-13 | Griggs | North Dakota | 38039 | 499 | 2 |
2105944 | 2105944 | 2022-01-12 | Aleutians East Borough | Alaska | 2013 | 499 | 3 |
2103572 | 2103572 | 2022-01-11 | Kiowa | Kansas | 20097 | 499 | 7 |
2100321 | 2100321 | 2022-01-10 | Kiowa | Kansas | 20097 | 499 | 7 |
2040106 | 2040106 | 2021-12-22 | Hanson | South Dakota | 46061 | 499 | 5 |
2040853 | 2040853 | 2021-12-22 | Niobrara | Wyoming | 56027 | 499 | 8 |
2037603 | 2037603 | 2021-12-21 | Niobrara | Wyoming | 56027 | 499 | 8 |
2034353 | 2034353 | 2021-12-20 | Niobrara | Wyoming | 56027 | 499 | 8 |
2031103 | 2031103 | 2021-12-19 | Niobrara | Wyoming | 56027 | 499 | 8 |
2027852 | 2027852 | 2021-12-18 | Niobrara | Wyoming | 56027 | 499 | 8 |
2024601 | 2024601 | 2021-12-17 | Niobrara | Wyoming | 56027 | 499 | 8 |
2021350 | 2021350 | 2021-12-16 | Niobrara | Wyoming | 56027 | 499 | 8 |
2018099 | 2018099 | 2021-12-15 | Niobrara | Wyoming | 56027 | 499 | 8 |
2011598 | 2011598 | 2021-12-13 | Niobrara | Wyoming | 56027 | 499 | 8 |
2008347 | 2008347 | 2021-12-12 | Niobrara | Wyoming | 56027 | 499 | 8 |
2005096 | 2005096 | 2021-12-11 | Niobrara | Wyoming | 56027 | 499 | 8 |
2001845 | 2001845 | 2021-12-10 | Niobrara | Wyoming | 56027 | 499 | 8 |
1998020 | 1998020 | 2021-12-09 | Cochran | Texas | 48079 | 499 | 19 |
1998595 | 1998595 | 2021-12-09 | Niobrara | Wyoming | 56027 | 499 | 8 |
1995344 | 1995344 | 2021-12-08 | Niobrara | Wyoming | 56027 | 499 | 8 |
1945851 | 1945851 | 2021-11-23 | Marshall | South Dakota | 46091 | 499 | 8 |
1926780 | 1926780 | 2021-11-17 | Bath | Virginia | 51017 | 499 | 15 |
1921567 | 1921567 | 2021-11-16 | Rawlins | Kansas | 20153 | 499 | 7 |
1923059 | 1923059 | 2021-11-16 | Bennett | South Dakota | 46007 | 499 | 9 |
1918317 | 1918317 | 2021-11-15 | Rawlins | Kansas | 20153 | 499 | 7 |
1920281 | 1920281 | 2021-11-15 | Bath | Virginia | 51017 | 499 | 15 |
1902462 | 1902462 | 2021-11-10 | Lake of the Woods | Minnesota | 27077 | 499 | 4 |
1891595 | 1891595 | 2021-11-07 | Baca | Colorado | 8009 | 499 | 5 |
1888345 | 1888345 | 2021-11-06 | Baca | Colorado | 8009 | 499 | 5 |
1885095 | 1885095 | 2021-11-05 | Baca | Colorado | 8009 | 499 | 5 |
1886872 | 1886872 | 2021-11-05 | Hettinger | North Dakota | 38041 | 499 | 6 |
1857881 | 1857881 | 2021-10-27 | Cameron | Pennsylvania | 42023 | 499 | 11 |
1850767 | 1850767 | 2021-10-25 | Sheridan | Montana | 30091 | 499 | 7 |
1785970 | 1785970 | 2021-10-05 | Union | New Mexico | 35059 | 499 | 11 |
1779637 | 1779637 | 2021-10-03 | Bowman | North Dakota | 38011 | 499 | 7 |
1770359 | 1770359 | 2021-09-30 | Douglas | South Dakota | 46043 | 499 | 9 |
1763861 | 1763861 | 2021-09-28 | Douglas | South Dakota | 46043 | 499 | 9 |
1758807 | 1758807 | 2021-09-27 | Pope | Illinois | 17151 | 499 | 5 |
1743437 | 1743437 | 2021-09-22 | Knox | Missouri | 29103 | 499 | 3 |
1744916 | 1744916 | 2021-09-22 | Rappahannock | Virginia | 51157 | 499 | 4 |
1721603 | 1721603 | 2021-09-15 | Aurora | South Dakota | 46003 | 499 | 15 |
1717910 | 1717910 | 2021-09-14 | Dunn | North Dakota | 38025 | 499 | 7 |
1708472 | 1708472 | 2021-09-11 | Sullivan | Pennsylvania | 42113 | 499 | 22 |
1696705 | 1696705 | 2021-09-08 | Saguache | Colorado | 8109 | 499 | 8 |
1698197 | 1698197 | 2021-09-08 | Unknown | New Hampshire | 499 | 1 | |
1699133 | 1699133 | 2021-09-08 | Haskell | Texas | 48207 | 499 | 29 |
1682195 | 1682195 | 2021-09-03 | Nelson | North Dakota | 38063 | 499 | 15 |
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);