ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
712 rows where cases = 680 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 179
- South Dakota 43
- Virginia 39
- Texas 37
- Missouri 35
- Puerto Rico 33
- Illinois 26
- Georgia 20
- Nebraska 20
- Iowa 19
- West Virginia 18
- North Carolina 16
- Arkansas 15
- Indiana 14
- North Dakota 13
- Michigan 12
- Mississippi 12
- Colorado 11
- Kentucky 11
- Alabama 10
- Minnesota 10
- Idaho 9
- Tennessee 9
- Ohio 8
- Montana 7
- Oregon 7
- Utah 7
- Washington 7
- Maine 6
- New Jersey 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501171 | 2501171 | 2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 |
2501205 | 2501205 | 2022-05-13 | Fallon | Montana | 30025 | 680 | 10 |
2497291 | 2497291 | 2022-05-12 | Rawlins | Kansas | 20153 | 680 | 9 |
2497913 | 2497913 | 2022-05-12 | Scotland | Missouri | 29199 | 680 | 18 |
2494033 | 2494033 | 2022-05-11 | Rawlins | Kansas | 20153 | 680 | 9 |
2494655 | 2494655 | 2022-05-11 | Scotland | Missouri | 29199 | 680 | 18 |
2495445 | 2495445 | 2022-05-11 | Maricao | Puerto Rico | 72093 | 680 | |
2490775 | 2490775 | 2022-05-10 | Rawlins | Kansas | 20153 | 680 | 9 |
2491397 | 2491397 | 2022-05-10 | Scotland | Missouri | 29199 | 680 | 18 |
2487518 | 2487518 | 2022-05-09 | Rawlins | Kansas | 20153 | 680 | 9 |
2488139 | 2488139 | 2022-05-09 | Scotland | Missouri | 29199 | 680 | 18 |
2484260 | 2484260 | 2022-05-08 | Rawlins | Kansas | 20153 | 680 | 9 |
2484882 | 2484882 | 2022-05-08 | Scotland | Missouri | 29199 | 680 | 18 |
2481002 | 2481002 | 2022-05-07 | Rawlins | Kansas | 20153 | 680 | 9 |
2481624 | 2481624 | 2022-05-07 | Scotland | Missouri | 29199 | 680 | 18 |
2477744 | 2477744 | 2022-05-06 | Rawlins | Kansas | 20153 | 680 | 9 |
2478366 | 2478366 | 2022-05-06 | Scotland | Missouri | 29199 | 680 | 18 |
2443792 | 2443792 | 2022-04-25 | Shackelford | Texas | 48417 | 680 | 12 |
2440536 | 2440536 | 2022-04-24 | Shackelford | Texas | 48417 | 680 | 12 |
2437280 | 2437280 | 2022-04-23 | Shackelford | Texas | 48417 | 680 | 12 |
2434024 | 2434024 | 2022-04-22 | Shackelford | Texas | 48417 | 680 | 12 |
2430768 | 2430768 | 2022-04-21 | Shackelford | Texas | 48417 | 680 | 12 |
2356578 | 2356578 | 2022-03-30 | Costilla | Colorado | 8023 | 680 | 16 |
2310043 | 2310043 | 2022-03-15 | Perkins | South Dakota | 46105 | 680 | 18 |
2306790 | 2306790 | 2022-03-14 | Perkins | South Dakota | 46105 | 680 | 18 |
2303539 | 2303539 | 2022-03-13 | Perkins | South Dakota | 46105 | 680 | 18 |
2300287 | 2300287 | 2022-03-12 | Perkins | South Dakota | 46105 | 680 | 18 |
2297035 | 2297035 | 2022-03-11 | Perkins | South Dakota | 46105 | 680 | 18 |
2293783 | 2293783 | 2022-03-10 | Perkins | South Dakota | 46105 | 680 | 18 |
2290531 | 2290531 | 2022-03-09 | Perkins | South Dakota | 46105 | 680 | 18 |
2286793 | 2286793 | 2022-03-08 | McIntosh | North Dakota | 38051 | 680 | 9 |
2287279 | 2287279 | 2022-03-08 | Perkins | South Dakota | 46105 | 680 | 18 |
2283541 | 2283541 | 2022-03-07 | McIntosh | North Dakota | 38051 | 680 | 9 |
2284027 | 2284027 | 2022-03-07 | Perkins | South Dakota | 46105 | 680 | 18 |
2280289 | 2280289 | 2022-03-06 | McIntosh | North Dakota | 38051 | 680 | 9 |
2280775 | 2280775 | 2022-03-06 | Perkins | South Dakota | 46105 | 680 | 18 |
2277036 | 2277036 | 2022-03-05 | McIntosh | North Dakota | 38051 | 680 | 9 |
2277522 | 2277522 | 2022-03-05 | Perkins | South Dakota | 46105 | 680 | 18 |
2274269 | 2274269 | 2022-03-04 | Perkins | South Dakota | 46105 | 680 | 18 |
2271016 | 2271016 | 2022-03-03 | Perkins | South Dakota | 46105 | 680 | 17 |
2267764 | 2267764 | 2022-03-02 | Perkins | South Dakota | 46105 | 680 | 17 |
2264511 | 2264511 | 2022-03-01 | Perkins | South Dakota | 46105 | 680 | 17 |
2261261 | 2261261 | 2022-02-28 | Perkins | South Dakota | 46105 | 680 | 17 |
2239797 | 2239797 | 2022-02-22 | Adams | Idaho | 16003 | 680 | 14 |
2240831 | 2240831 | 2022-02-22 | Scotland | Missouri | 29199 | 680 | 17 |
2240898 | 2240898 | 2022-02-22 | Sheridan | Montana | 30091 | 680 | 11 |
2241723 | 2241723 | 2022-02-22 | Douglas | South Dakota | 46043 | 680 | 16 |
2237580 | 2237580 | 2022-02-21 | Scotland | Missouri | 29199 | 680 | 17 |
2238472 | 2238472 | 2022-02-21 | Douglas | South Dakota | 46043 | 680 | 16 |
2234329 | 2234329 | 2022-02-20 | Scotland | Missouri | 29199 | 680 | 17 |
2235221 | 2235221 | 2022-02-20 | Douglas | South Dakota | 46043 | 680 | 16 |
2231078 | 2231078 | 2022-02-19 | Scotland | Missouri | 29199 | 680 | 17 |
2231970 | 2231970 | 2022-02-19 | Douglas | South Dakota | 46043 | 680 | 16 |
2227827 | 2227827 | 2022-02-18 | Scotland | Missouri | 29199 | 680 | 17 |
2228719 | 2228719 | 2022-02-18 | Douglas | South Dakota | 46043 | 680 | 16 |
2225468 | 2225468 | 2022-02-17 | Douglas | South Dakota | 46043 | 680 | 16 |
2222217 | 2222217 | 2022-02-16 | Douglas | South Dakota | 46043 | 680 | 16 |
2218966 | 2218966 | 2022-02-15 | Douglas | South Dakota | 46043 | 680 | 16 |
2215715 | 2215715 | 2022-02-14 | Douglas | South Dakota | 46043 | 680 | 16 |
2212464 | 2212464 | 2022-02-13 | Douglas | South Dakota | 46043 | 680 | 16 |
2209211 | 2209211 | 2022-02-12 | Douglas | South Dakota | 46043 | 680 | 16 |
2205958 | 2205958 | 2022-02-11 | Douglas | South Dakota | 46043 | 680 | 16 |
2202705 | 2202705 | 2022-02-10 | Douglas | South Dakota | 46043 | 680 | 16 |
2163200 | 2163200 | 2022-01-29 | Emmons | North Dakota | 38029 | 680 | 16 |
2156429 | 2156429 | 2022-01-27 | Valley | Nebraska | 31175 | 680 | 5 |
2150927 | 2150927 | 2022-01-25 | Kinney | Texas | 48271 | 680 | 10 |
2122429 | 2122429 | 2022-01-17 | Phillips | Colorado | 8095 | 680 | 15 |
2104904 | 2104904 | 2022-01-11 | Cameron | Pennsylvania | 42023 | 680 | 14 |
2098942 | 2098942 | 2022-01-09 | Reagan | Texas | 48383 | 680 | 11 |
2088237 | 2088237 | 2022-01-06 | Hamilton | New York | 36041 | 680 | 4 |
2063073 | 2063073 | 2021-12-29 | Goliad | Texas | 48175 | 680 | 28 |
2053341 | 2053341 | 2021-12-26 | Haskell | Texas | 48207 | 680 | 36 |
2050091 | 2050091 | 2021-12-25 | Haskell | Texas | 48207 | 680 | 36 |
2046841 | 2046841 | 2021-12-24 | Haskell | Texas | 48207 | 680 | 36 |
2043591 | 2043591 | 2021-12-23 | Haskell | Texas | 48207 | 680 | 36 |
2040342 | 2040342 | 2021-12-22 | Haskell | Texas | 48207 | 680 | 36 |
2037092 | 2037092 | 2021-12-21 | Haskell | Texas | 48207 | 680 | 36 |
2033842 | 2033842 | 2021-12-20 | Haskell | Texas | 48207 | 680 | 36 |
2030233 | 2030233 | 2021-12-19 | Jayuya | Puerto Rico | 72073 | 680 | |
2030592 | 2030592 | 2021-12-19 | Haskell | Texas | 48207 | 680 | 36 |
1991204 | 1991204 | 2021-12-07 | Ceiba | Puerto Rico | 72037 | 680 | |
1987953 | 1987953 | 2021-12-06 | Ceiba | Puerto Rico | 72037 | 680 | |
1984703 | 1984703 | 2021-12-05 | Ceiba | Puerto Rico | 72037 | 680 | |
1967124 | 1967124 | 2021-11-30 | Carlisle | Kentucky | 21039 | 680 | 12 |
1961185 | 1961185 | 2021-11-28 | Putnam | Missouri | 29171 | 680 | 19 |
1957934 | 1957934 | 2021-11-27 | Putnam | Missouri | 29171 | 680 | 19 |
1954683 | 1954683 | 2021-11-26 | Putnam | Missouri | 29171 | 680 | 19 |
1951432 | 1951432 | 2021-11-25 | Putnam | Missouri | 29171 | 680 | 19 |
1948181 | 1948181 | 2021-11-24 | Putnam | Missouri | 29171 | 680 | 19 |
1938153 | 1938153 | 2021-11-21 | Ontonagon | Michigan | 26131 | 680 | 23 |
1934903 | 1934903 | 2021-11-20 | Ontonagon | Michigan | 26131 | 680 | 23 |
1931653 | 1931653 | 2021-11-19 | Ontonagon | Michigan | 26131 | 680 | 23 |
1932677 | 1932677 | 2021-11-19 | Adjuntas | Puerto Rico | 72001 | 680 | |
1929426 | 1929426 | 2021-11-18 | Adjuntas | Puerto Rico | 72001 | 680 | |
1925233 | 1925233 | 2021-11-17 | Red Lake | Minnesota | 27125 | 680 | 10 |
1926176 | 1926176 | 2021-11-17 | Adjuntas | Puerto Rico | 72001 | 680 | |
1922615 | 1922615 | 2021-11-16 | Foster | North Dakota | 38031 | 680 | 19 |
1922926 | 1922926 | 2021-11-16 | Adjuntas | Puerto Rico | 72001 | 680 | |
1919677 | 1919677 | 2021-11-15 | Adjuntas | Puerto Rico | 72001 | 680 | |
1916427 | 1916427 | 2021-11-14 | Adjuntas | Puerto Rico | 72001 | 680 |
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);