ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
420 rows where cases = 1000 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Missouri 28
- Georgia 25
- Nebraska 25
- Virginia 25
- Iowa 20
- Indiana 17
- Kentucky 16
- Michigan 16
- Puerto Rico 15
- New Mexico 13
- Alaska 11
- North Carolina 11
- Tennessee 11
- Illinois 10
- Arkansas 9
- Kansas 8
- Minnesota 8
- Idaho 7
- Louisiana 7
- Montana 7
- North Dakota 7
- Oklahoma 7
- Oregon 7
- South Carolina 7
- Washington 7
- Colorado 6
- Ohio 6
- West Virginia 6
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499786 | 2499786 | 2022-05-13 | Modoc | California | 6049 | 1000 | 8 |
2496528 | 2496528 | 2022-05-12 | Modoc | California | 6049 | 1000 | 8 |
2493270 | 2493270 | 2022-05-11 | Modoc | California | 6049 | 1000 | 8 |
2490012 | 2490012 | 2022-05-10 | Modoc | California | 6049 | 1000 | 8 |
2491112 | 2491112 | 2022-05-10 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2487855 | 2487855 | 2022-05-09 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2484597 | 2484597 | 2022-05-08 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2481339 | 2481339 | 2022-05-07 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2478081 | 2478081 | 2022-05-06 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2474823 | 2474823 | 2022-05-05 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2471566 | 2471566 | 2022-05-04 | Ontonagon | Michigan | 26131 | 1000 | 38 |
2408173 | 2408173 | 2022-04-14 | Rappahannock | Virginia | 51157 | 1000 | 10 |
2400379 | 2400379 | 2022-04-12 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2401662 | 2401662 | 2022-04-12 | Rappahannock | Virginia | 51157 | 1000 | 10 |
2397124 | 2397124 | 2022-04-11 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2393869 | 2393869 | 2022-04-10 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2390613 | 2390613 | 2022-04-09 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2387357 | 2387357 | 2022-04-08 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2384102 | 2384102 | 2022-04-07 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2380847 | 2380847 | 2022-04-06 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2377592 | 2377592 | 2022-04-05 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2374339 | 2374339 | 2022-04-04 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2371087 | 2371087 | 2022-04-03 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2367834 | 2367834 | 2022-04-02 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2364581 | 2364581 | 2022-04-01 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2361327 | 2361327 | 2022-03-31 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2358073 | 2358073 | 2022-03-30 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2354820 | 2354820 | 2022-03-29 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2351222 | 2351222 | 2022-03-28 | Unknown | Minnesota | 1000 | 220 | |
2351567 | 2351567 | 2022-03-28 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2347969 | 2347969 | 2022-03-27 | Unknown | Minnesota | 1000 | 220 | |
2348315 | 2348315 | 2022-03-27 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2344716 | 2344716 | 2022-03-26 | Unknown | Minnesota | 1000 | 220 | |
2345062 | 2345062 | 2022-03-26 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2341463 | 2341463 | 2022-03-25 | Unknown | Minnesota | 1000 | 220 | |
2341809 | 2341809 | 2022-03-25 | Sheridan | Nebraska | 31161 | 1000 | 23 |
2332144 | 2332144 | 2022-03-22 | Union | New Mexico | 35059 | 1000 | 15 |
2328891 | 2328891 | 2022-03-21 | Union | New Mexico | 35059 | 1000 | 15 |
2325639 | 2325639 | 2022-03-20 | Union | New Mexico | 35059 | 1000 | 15 |
2322385 | 2322385 | 2022-03-19 | Union | New Mexico | 35059 | 1000 | 15 |
2319131 | 2319131 | 2022-03-18 | Union | New Mexico | 35059 | 1000 | 15 |
2315878 | 2315878 | 2022-03-17 | Union | New Mexico | 35059 | 1000 | 15 |
2312625 | 2312625 | 2022-03-16 | Union | New Mexico | 35059 | 1000 | 15 |
2309372 | 2309372 | 2022-03-15 | Union | New Mexico | 35059 | 1000 | 15 |
2306119 | 2306119 | 2022-03-14 | Union | New Mexico | 35059 | 1000 | 15 |
2302868 | 2302868 | 2022-03-13 | Union | New Mexico | 35059 | 1000 | 15 |
2299616 | 2299616 | 2022-03-12 | Union | New Mexico | 35059 | 1000 | 15 |
2296364 | 2296364 | 2022-03-11 | Union | New Mexico | 35059 | 1000 | 15 |
2290971 | 2290971 | 2022-03-09 | Covington city | Virginia | 51580 | 1000 | 24 |
2199012 | 2199012 | 2022-02-09 | Sargent | North Dakota | 38081 | 1000 | 9 |
2170338 | 2170338 | 2022-01-31 | Brewster | Texas | 48043 | 1000 | 25 |
2164010 | 2164010 | 2022-01-29 | San Augustine | Texas | 48405 | 1000 | 38 |
2151957 | 2151957 | 2022-01-26 | Warren | Georgia | 13301 | 1000 | 26 |
2147791 | 2147791 | 2022-01-24 | Yoakum | Texas | 48501 | 1000 | 37 |
2134626 | 2134626 | 2022-01-20 | Hemphill | Texas | 48211 | 1000 | 3 |
2116857 | 2116857 | 2022-01-15 | Unknown | Maryland | 1000 | 261 | |
2107598 | 2107598 | 2022-01-12 | Kearney | Nebraska | 31099 | 1000 | 7 |
2108259 | 2108259 | 2022-01-12 | Maunabo | Puerto Rico | 72095 | 1000 | |
2097056 | 2097056 | 2022-01-09 | Gray | Kansas | 20069 | 1000 | 23 |
2093804 | 2093804 | 2022-01-08 | Gray | Kansas | 20069 | 1000 | 23 |
2090552 | 2090552 | 2022-01-07 | Gray | Kansas | 20069 | 1000 | 23 |
2074125 | 2074125 | 2022-01-02 | Ohio | Indiana | 18115 | 1000 | 15 |
2076091 | 2076091 | 2022-01-02 | Hartley | Texas | 48205 | 1000 | 2 |
2070874 | 2070874 | 2022-01-01 | Ohio | Indiana | 18115 | 1000 | 15 |
2072840 | 2072840 | 2022-01-01 | Hartley | Texas | 48205 | 1000 | 2 |
2067623 | 2067623 | 2021-12-31 | Ohio | Indiana | 18115 | 1000 | 15 |
2069589 | 2069589 | 2021-12-31 | Hartley | Texas | 48205 | 1000 | 2 |
2064372 | 2064372 | 2021-12-30 | Ohio | Indiana | 18115 | 1000 | 15 |
2066338 | 2066338 | 2021-12-30 | Hartley | Texas | 48205 | 1000 | 2 |
2060904 | 2060904 | 2021-12-29 | Wheeler | Georgia | 13309 | 1000 | 36 |
2031700 | 2031700 | 2021-12-20 | Lemhi | Idaho | 16059 | 1000 | 21 |
1998247 | 1998247 | 2021-12-09 | Kane | Utah | 49025 | 1000 | 12 |
1994996 | 1994996 | 2021-12-08 | Kane | Utah | 49025 | 1000 | 12 |
1991861 | 1991861 | 2021-12-07 | Middlesex | Virginia | 51119 | 1000 | 33 |
1988610 | 1988610 | 2021-12-06 | Middlesex | Virginia | 51119 | 1000 | 33 |
1985584 | 1985584 | 2021-12-05 | Crook | Wyoming | 56011 | 1000 | 21 |
1982334 | 1982334 | 2021-12-04 | Crook | Wyoming | 56011 | 1000 | 21 |
1979084 | 1979084 | 2021-12-03 | Crook | Wyoming | 56011 | 1000 | 21 |
1975346 | 1975346 | 2021-12-02 | Jack | Texas | 48237 | 1000 | 21 |
1975834 | 1975834 | 2021-12-02 | Crook | Wyoming | 56011 | 1000 | 21 |
1968610 | 1968610 | 2021-11-30 | McCook | South Dakota | 46087 | 1000 | 27 |
1969297 | 1969297 | 2021-11-30 | Menominee | Wisconsin | 55078 | 1000 | 11 |
1906029 | 1906029 | 2021-11-11 | Cedar | Nebraska | 31027 | 1000 | 11 |
1906066 | 1906066 | 2021-11-11 | Keith | Nebraska | 31101 | 1000 | 11 |
1883192 | 1883192 | 2021-11-04 | Shannon | Missouri | 29203 | 1000 | 19 |
1878100 | 1878100 | 2021-11-02 | Madison | Virginia | 51113 | 1000 | 21 |
1870960 | 1870960 | 2021-10-31 | Florida | Puerto Rico | 72054 | 1000 | |
1867711 | 1867711 | 2021-10-30 | Florida | Puerto Rico | 72054 | 1000 | |
1864462 | 1864462 | 2021-10-29 | Florida | Puerto Rico | 72054 | 1000 | |
1860099 | 1860099 | 2021-10-28 | Alger | Michigan | 26003 | 1000 | 9 |
1856850 | 1856850 | 2021-10-27 | Alger | Michigan | 26003 | 1000 | 9 |
1848097 | 1848097 | 2021-10-24 | Grant | Oregon | 41023 | 1000 | 13 |
1844847 | 1844847 | 2021-10-23 | Grant | Oregon | 41023 | 1000 | 13 |
1841597 | 1841597 | 2021-10-22 | Grant | Oregon | 41023 | 1000 | 13 |
1838348 | 1838348 | 2021-10-21 | Grant | Oregon | 41023 | 1000 | 13 |
1835492 | 1835492 | 2021-10-20 | Bailey | Texas | 48017 | 1000 | 23 |
1786365 | 1786365 | 2021-10-05 | Harney | Oregon | 41025 | 1000 | 24 |
1782240 | 1782240 | 2021-10-04 | Lake | Minnesota | 27075 | 1000 | 21 |
1782492 | 1782492 | 2021-10-04 | Blaine | Montana | 30005 | 1000 | 24 |
1782599 | 1782599 | 2021-10-04 | Knox | Nebraska | 31107 | 1000 | 13 |
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);