ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
585 rows where cases = 628 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 42
- Georgia 40
- Missouri 37
- Texas 34
- Virginia 30
- Nebraska 29
- Puerto Rico 25
- Kentucky 23
- New Mexico 23
- Iowa 21
- North Carolina 21
- Kansas 20
- Oklahoma 17
- Arkansas 16
- Michigan 16
- Mississippi 16
- Louisiana 15
- Alabama 14
- Colorado 14
- Minnesota 11
- Indiana 10
- Illinois 9
- West Virginia 9
- Idaho 8
- Ohio 8
- Tennessee 7
- Wisconsin 7
- Alaska 6
- California 6
- North Dakota 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456206 | 2456206 | 2022-04-29 | Unknown | Oklahoma | 628 | 4 | |
2452950 | 2452950 | 2022-04-28 | Unknown | Oklahoma | 628 | 4 | |
2378342 | 2378342 | 2022-04-05 | Jackson | South Dakota | 46071 | 628 | 21 |
2375088 | 2375088 | 2022-04-04 | Jackson | South Dakota | 46071 | 628 | 21 |
2371836 | 2371836 | 2022-04-03 | Jackson | South Dakota | 46071 | 628 | 21 |
2368583 | 2368583 | 2022-04-02 | Jackson | South Dakota | 46071 | 628 | 21 |
2365330 | 2365330 | 2022-04-01 | Jackson | South Dakota | 46071 | 628 | 21 |
2362077 | 2362077 | 2022-03-31 | Jackson | South Dakota | 46071 | 628 | 21 |
2358823 | 2358823 | 2022-03-30 | Jackson | South Dakota | 46071 | 628 | 21 |
2355569 | 2355569 | 2022-03-29 | Jackson | South Dakota | 46071 | 628 | 21 |
2352316 | 2352316 | 2022-03-28 | Jackson | South Dakota | 46071 | 628 | 21 |
2349064 | 2349064 | 2022-03-27 | Jackson | South Dakota | 46071 | 628 | 21 |
2345811 | 2345811 | 2022-03-26 | Jackson | South Dakota | 46071 | 628 | 21 |
2342558 | 2342558 | 2022-03-25 | Jackson | South Dakota | 46071 | 628 | 21 |
2339305 | 2339305 | 2022-03-24 | Jackson | South Dakota | 46071 | 628 | 21 |
2336051 | 2336051 | 2022-03-23 | Jackson | South Dakota | 46071 | 628 | 21 |
2332797 | 2332797 | 2022-03-22 | Jackson | South Dakota | 46071 | 628 | 21 |
2329544 | 2329544 | 2022-03-21 | Jackson | South Dakota | 46071 | 628 | 21 |
2326292 | 2326292 | 2022-03-20 | Jackson | South Dakota | 46071 | 628 | 21 |
2323039 | 2323039 | 2022-03-19 | Jackson | South Dakota | 46071 | 628 | 21 |
2319785 | 2319785 | 2022-03-18 | Jackson | South Dakota | 46071 | 628 | 21 |
2316531 | 2316531 | 2022-03-17 | Jackson | South Dakota | 46071 | 628 | 21 |
2313278 | 2313278 | 2022-03-16 | Jackson | South Dakota | 46071 | 628 | 21 |
2310025 | 2310025 | 2022-03-15 | Jackson | South Dakota | 46071 | 628 | 21 |
2306772 | 2306772 | 2022-03-14 | Jackson | South Dakota | 46071 | 628 | 21 |
2303521 | 2303521 | 2022-03-13 | Jackson | South Dakota | 46071 | 628 | 21 |
2300269 | 2300269 | 2022-03-12 | Jackson | South Dakota | 46071 | 628 | 21 |
2297017 | 2297017 | 2022-03-11 | Jackson | South Dakota | 46071 | 628 | 21 |
2288272 | 2288272 | 2022-03-09 | Custer | Colorado | 8027 | 628 | 19 |
2268758 | 2268758 | 2022-03-03 | Custer | Colorado | 8027 | 628 | 18 |
2262254 | 2262254 | 2022-03-01 | Custer | Colorado | 8027 | 628 | 18 |
2195743 | 2195743 | 2022-02-08 | McIntosh | North Dakota | 38051 | 628 | 9 |
2169282 | 2169282 | 2022-01-31 | Scotland | Missouri | 29199 | 628 | 17 |
2166027 | 2166027 | 2022-01-30 | Scotland | Missouri | 29199 | 628 | 17 |
2162772 | 2162772 | 2022-01-29 | Scotland | Missouri | 29199 | 628 | 17 |
2160686 | 2160686 | 2022-01-28 | Kimble | Texas | 48267 | 628 | 12 |
2153250 | 2153250 | 2022-01-26 | Mora | New Mexico | 35033 | 628 | 16 |
2150340 | 2150340 | 2022-01-25 | Ellis | Oklahoma | 40045 | 628 | 6 |
2147088 | 2147088 | 2022-01-24 | Ellis | Oklahoma | 40045 | 628 | 6 |
2143834 | 2143834 | 2022-01-23 | Ellis | Oklahoma | 40045 | 628 | 6 |
2140579 | 2140579 | 2022-01-22 | Ellis | Oklahoma | 40045 | 628 | 6 |
2137323 | 2137323 | 2022-01-21 | Ellis | Oklahoma | 40045 | 628 | 6 |
2132868 | 2132868 | 2022-01-20 | Rawlins | Kansas | 20153 | 628 | 10 |
2134069 | 2134069 | 2022-01-20 | Ellis | Oklahoma | 40045 | 628 | 6 |
2129615 | 2129615 | 2022-01-19 | Rawlins | Kansas | 20153 | 628 | 10 |
2130817 | 2130817 | 2022-01-19 | Ellis | Oklahoma | 40045 | 628 | 6 |
2107893 | 2107893 | 2022-01-12 | Cavalier | North Dakota | 38019 | 628 | 7 |
2087424 | 2087424 | 2022-01-06 | Hickman | Kentucky | 21105 | 628 | 22 |
2089006 | 2089006 | 2022-01-06 | Baylor | Texas | 48023 | 628 | 25 |
2058052 | 2058052 | 2021-12-28 | Jewell | Kansas | 20089 | 628 | 11 |
2058516 | 2058516 | 2021-12-28 | Traverse | Minnesota | 27155 | 628 | 8 |
2054803 | 2054803 | 2021-12-27 | Jewell | Kansas | 20089 | 628 | 11 |
2056601 | 2056601 | 2021-12-27 | Hudspeth | Texas | 48229 | 628 | 14 |
2040334 | 2040334 | 2021-12-22 | Hall | Texas | 48191 | 628 | 15 |
1988458 | 1988458 | 2021-12-06 | Upton | Texas | 48461 | 628 | 15 |
1985208 | 1985208 | 2021-12-05 | Upton | Texas | 48461 | 628 | 15 |
1981958 | 1981958 | 2021-12-04 | Upton | Texas | 48461 | 628 | 15 |
1960537 | 1960537 | 2021-11-28 | Haskell | Kansas | 20081 | 628 | 9 |
1961446 | 1961446 | 2021-11-28 | Union | New Mexico | 35059 | 628 | 12 |
1957286 | 1957286 | 2021-11-27 | Haskell | Kansas | 20081 | 628 | 9 |
1958195 | 1958195 | 2021-11-27 | Union | New Mexico | 35059 | 628 | 12 |
1954035 | 1954035 | 2021-11-26 | Haskell | Kansas | 20081 | 628 | 9 |
1954944 | 1954944 | 2021-11-26 | Union | New Mexico | 35059 | 628 | 12 |
1950784 | 1950784 | 2021-11-25 | Haskell | Kansas | 20081 | 628 | 9 |
1951693 | 1951693 | 2021-11-25 | Union | New Mexico | 35059 | 628 | 12 |
1947533 | 1947533 | 2021-11-24 | Haskell | Kansas | 20081 | 628 | 9 |
1948442 | 1948442 | 2021-11-24 | Union | New Mexico | 35059 | 628 | 12 |
1942780 | 1942780 | 2021-11-22 | Delta | Texas | 48119 | 628 | 22 |
1939530 | 1939530 | 2021-11-21 | Delta | Texas | 48119 | 628 | 22 |
1936280 | 1936280 | 2021-11-20 | Delta | Texas | 48119 | 628 | 22 |
1926165 | 1926165 | 2021-11-17 | Sullivan | Pennsylvania | 42113 | 628 | 24 |
1895232 | 1895232 | 2021-11-08 | Hardin | Illinois | 17069 | 628 | 16 |
1882906 | 1882906 | 2021-11-04 | Ontonagon | Michigan | 26131 | 628 | 22 |
1879657 | 1879657 | 2021-11-03 | Ontonagon | Michigan | 26131 | 628 | 22 |
1876640 | 1876640 | 2021-11-02 | Holt | Missouri | 29087 | 628 | 16 |
1876873 | 1876873 | 2021-11-02 | Lincoln | Nevada | 32017 | 628 | 5 |
1873435 | 1873435 | 2021-11-01 | Putnam | Missouri | 29171 | 628 | 10 |
1873624 | 1873624 | 2021-11-01 | Lincoln | Nevada | 32017 | 628 | 5 |
1870186 | 1870186 | 2021-10-31 | Putnam | Missouri | 29171 | 628 | 10 |
1866937 | 1866937 | 2021-10-30 | Putnam | Missouri | 29171 | 628 | 10 |
1806099 | 1806099 | 2021-10-11 | Deuel | South Dakota | 46039 | 628 | 11 |
1802849 | 1802849 | 2021-10-10 | Deuel | South Dakota | 46039 | 628 | 11 |
1799600 | 1799600 | 2021-10-09 | Deuel | South Dakota | 46039 | 628 | 11 |
1796351 | 1796351 | 2021-10-08 | Deuel | South Dakota | 46039 | 628 | 11 |
1791944 | 1791944 | 2021-10-07 | Unknown | Michigan | 628 | 13 | |
1792266 | 1792266 | 2021-10-07 | Mineral | Montana | 30061 | 628 | 10 |
1793102 | 1793102 | 2021-10-07 | Deuel | South Dakota | 46039 | 628 | 11 |
1773154 | 1773154 | 2021-10-01 | LaMoure | North Dakota | 38045 | 628 | 17 |
1769376 | 1769376 | 2021-09-30 | Atchison | Missouri | 29005 | 628 | 6 |
1746613 | 1746613 | 2021-09-23 | Sharkey | Mississippi | 28125 | 628 | 20 |
1737876 | 1737876 | 2021-09-20 | Gregory | South Dakota | 46053 | 628 | 30 |
1734626 | 1734626 | 2021-09-19 | Gregory | South Dakota | 46053 | 628 | 30 |
1731376 | 1731376 | 2021-09-18 | Gregory | South Dakota | 46053 | 628 | 30 |
1728126 | 1728126 | 2021-09-17 | Gregory | South Dakota | 46053 | 628 | 30 |
1717273 | 1717273 | 2021-09-14 | Norman | Minnesota | 27107 | 628 | 9 |
1713254 | 1713254 | 2021-09-13 | Calhoun | Illinois | 17013 | 628 | 5 |
1694527 | 1694527 | 2021-09-07 | Mahnomen | Minnesota | 27087 | 628 | 9 |
1691278 | 1691278 | 2021-09-06 | Mahnomen | Minnesota | 27087 | 628 | 9 |
1688028 | 1688028 | 2021-09-05 | Mahnomen | Minnesota | 27087 | 628 | 9 |
1684778 | 1684778 | 2021-09-04 | Mahnomen | Minnesota | 27087 | 628 | 9 |
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);