ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
412 rows where cases = 1005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 41
- Puerto Rico 31
- Oklahoma 22
- Arkansas 20
- North Dakota 20
- Kentucky 17
- New Mexico 16
- Missouri 15
- Mississippi 14
- Virginia 14
- Georgia 12
- Iowa 12
- Colorado 11
- Louisiana 11
- Michigan 11
- Kansas 10
- Nebraska 10
- North Carolina 10
- Wisconsin 10
- Indiana 9
- West Virginia 9
- Alabama 8
- Tennessee 8
- Illinois 7
- Idaho 6
- Minnesota 6
- New York 6
- Ohio 6
- South Dakota 5
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449314 | 2449314 | 2022-04-27 | Union | New Mexico | 35059 | 1005 | 16 |
2446057 | 2446057 | 2022-04-26 | Union | New Mexico | 35059 | 1005 | 16 |
2442802 | 2442802 | 2022-04-25 | Union | New Mexico | 35059 | 1005 | 16 |
2439546 | 2439546 | 2022-04-24 | Union | New Mexico | 35059 | 1005 | 16 |
2436290 | 2436290 | 2022-04-23 | Union | New Mexico | 35059 | 1005 | 16 |
2433034 | 2433034 | 2022-04-22 | Union | New Mexico | 35059 | 1005 | 16 |
2429778 | 2429778 | 2022-04-21 | Union | New Mexico | 35059 | 1005 | 16 |
2429961 | 2429961 | 2022-04-21 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2426522 | 2426522 | 2022-04-20 | Union | New Mexico | 35059 | 1005 | 16 |
2426705 | 2426705 | 2022-04-20 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2423266 | 2423266 | 2022-04-19 | Union | New Mexico | 35059 | 1005 | 16 |
2423449 | 2423449 | 2022-04-19 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2420009 | 2420009 | 2022-04-18 | Union | New Mexico | 35059 | 1005 | 16 |
2420192 | 2420192 | 2022-04-18 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2416754 | 2416754 | 2022-04-17 | Union | New Mexico | 35059 | 1005 | 16 |
2416937 | 2416937 | 2022-04-17 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2413498 | 2413498 | 2022-04-16 | Union | New Mexico | 35059 | 1005 | 16 |
2413681 | 2413681 | 2022-04-16 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2410242 | 2410242 | 2022-04-15 | Union | New Mexico | 35059 | 1005 | 16 |
2410425 | 2410425 | 2022-04-15 | LaMoure | North Dakota | 38045 | 1005 | 20 |
2338852 | 2338852 | 2022-03-24 | Sargent | North Dakota | 38081 | 1005 | 9 |
2335598 | 2335598 | 2022-03-23 | Sargent | North Dakota | 38081 | 1005 | 9 |
2332344 | 2332344 | 2022-03-22 | Sargent | North Dakota | 38081 | 1005 | 9 |
2329091 | 2329091 | 2022-03-21 | Sargent | North Dakota | 38081 | 1005 | 9 |
2323886 | 2323886 | 2022-03-20 | Unknown | American Samoa | 1005 | 0 | |
2325839 | 2325839 | 2022-03-20 | Sargent | North Dakota | 38081 | 1005 | 9 |
2320632 | 2320632 | 2022-03-19 | Unknown | American Samoa | 1005 | 0 | |
2322586 | 2322586 | 2022-03-19 | Sargent | North Dakota | 38081 | 1005 | 9 |
2317378 | 2317378 | 2022-03-18 | Unknown | American Samoa | 1005 | 0 | |
2319332 | 2319332 | 2022-03-18 | Sargent | North Dakota | 38081 | 1005 | 9 |
2262584 | 2262584 | 2022-03-01 | Lincoln | Idaho | 16063 | 1005 | 15 |
2264053 | 2264053 | 2022-03-01 | Wells | North Dakota | 38103 | 1005 | 11 |
2260802 | 2260802 | 2022-02-28 | Wells | North Dakota | 38103 | 1005 | 11 |
2257551 | 2257551 | 2022-02-27 | Wells | North Dakota | 38103 | 1005 | 11 |
2254300 | 2254300 | 2022-02-26 | Wells | North Dakota | 38103 | 1005 | 11 |
2200525 | 2200525 | 2022-02-10 | Washington | Colorado | 8121 | 1005 | 26 |
2170865 | 2170865 | 2022-01-31 | Florence | Wisconsin | 55037 | 1005 | 15 |
2166475 | 2166475 | 2022-01-30 | Pierce | North Dakota | 38069 | 1005 | 30 |
2167265 | 2167265 | 2022-01-30 | San Augustine | Texas | 48405 | 1005 | 38 |
2155210 | 2155210 | 2022-01-27 | Warren | Georgia | 13301 | 1005 | 27 |
2156373 | 2156373 | 2022-01-27 | Furnas | Nebraska | 31065 | 1005 | 6 |
2154149 | 2154149 | 2022-01-26 | Hemphill | Texas | 48211 | 1005 | 4 |
2150655 | 2150655 | 2022-01-25 | Gregory | South Dakota | 46053 | 1005 | 33 |
2151183 | 2151183 | 2022-01-25 | Norton city | Virginia | 51720 | 1005 | 20 |
2132574 | 2132574 | 2022-01-20 | Putnam | Illinois | 17155 | 1005 | 8 |
2108659 | 2108659 | 2022-01-12 | Martin | Texas | 48317 | 1005 | 24 |
2101857 | 2101857 | 2022-01-10 | Day | South Dakota | 46037 | 1005 | 30 |
2089154 | 2089154 | 2022-01-06 | McCulloch | Texas | 48307 | 1005 | 40 |
2079342 | 2079342 | 2022-01-03 | Hartley | Texas | 48205 | 1005 | 2 |
2074889 | 2074889 | 2022-01-02 | Dade | Missouri | 29057 | 1005 | 38 |
2071638 | 2071638 | 2022-01-01 | Dade | Missouri | 29057 | 1005 | 38 |
2068387 | 2068387 | 2021-12-31 | Dade | Missouri | 29057 | 1005 | 38 |
2065136 | 2065136 | 2021-12-30 | Dade | Missouri | 29057 | 1005 | 38 |
2062078 | 2062078 | 2021-12-29 | Jefferson | Nebraska | 31095 | 1005 | 3 |
2039231 | 2039231 | 2021-12-22 | Broadwater | Montana | 30007 | 1005 | 17 |
2035981 | 2035981 | 2021-12-21 | Broadwater | Montana | 30007 | 1005 | 17 |
1998186 | 1998186 | 2021-12-09 | San Saba | Texas | 48411 | 1005 | 29 |
1994935 | 1994935 | 2021-12-08 | San Saba | Texas | 48411 | 1005 | 29 |
1991684 | 1991684 | 2021-12-07 | San Saba | Texas | 48411 | 1005 | 29 |
1988433 | 1988433 | 2021-12-06 | San Saba | Texas | 48411 | 1005 | 29 |
1985183 | 1985183 | 2021-12-05 | San Saba | Texas | 48411 | 1005 | 29 |
1981933 | 1981933 | 2021-12-04 | San Saba | Texas | 48411 | 1005 | 29 |
1978596 | 1978596 | 2021-12-03 | Jack | Texas | 48237 | 1005 | 22 |
1975796 | 1975796 | 2021-12-02 | Menominee | Wisconsin | 55078 | 1005 | 11 |
1968896 | 1968896 | 2021-11-30 | Mitchell | Texas | 48335 | 1005 | 42 |
1955458 | 1955458 | 2021-11-26 | Florida | Puerto Rico | 72054 | 1005 | |
1952207 | 1952207 | 2021-11-25 | Florida | Puerto Rico | 72054 | 1005 | |
1948956 | 1948956 | 2021-11-24 | Florida | Puerto Rico | 72054 | 1005 | |
1945705 | 1945705 | 2021-11-23 | Florida | Puerto Rico | 72054 | 1005 | |
1942454 | 1942454 | 2021-11-22 | Florida | Puerto Rico | 72054 | 1005 | |
1939204 | 1939204 | 2021-11-21 | Florida | Puerto Rico | 72054 | 1005 | |
1935954 | 1935954 | 2021-11-20 | Florida | Puerto Rico | 72054 | 1005 | |
1932704 | 1932704 | 2021-11-19 | Florida | Puerto Rico | 72054 | 1005 | |
1929453 | 1929453 | 2021-11-18 | Florida | Puerto Rico | 72054 | 1005 | |
1926203 | 1926203 | 2021-11-17 | Florida | Puerto Rico | 72054 | 1005 | |
1922386 | 1922386 | 2021-11-16 | Unknown | New Hampshire | 1005 | 5 | |
1922953 | 1922953 | 2021-11-16 | Florida | Puerto Rico | 72054 | 1005 | |
1919704 | 1919704 | 2021-11-15 | Florida | Puerto Rico | 72054 | 1005 | |
1915778 | 1915778 | 2021-11-14 | Cedar | Nebraska | 31027 | 1005 | 11 |
1916454 | 1916454 | 2021-11-14 | Florida | Puerto Rico | 72054 | 1005 | |
1912528 | 1912528 | 2021-11-13 | Cedar | Nebraska | 31027 | 1005 | 11 |
1913204 | 1913204 | 2021-11-13 | Florida | Puerto Rico | 72054 | 1005 | |
1909278 | 1909278 | 2021-11-12 | Cedar | Nebraska | 31027 | 1005 | 11 |
1892657 | 1892657 | 2021-11-07 | Oscoda | Michigan | 26135 | 1005 | 39 |
1889407 | 1889407 | 2021-11-06 | Oscoda | Michigan | 26135 | 1005 | 39 |
1886157 | 1886157 | 2021-11-05 | Oscoda | Michigan | 26135 | 1005 | 39 |
1878625 | 1878625 | 2021-11-03 | Kit Carson | Colorado | 8063 | 1005 | 20 |
1874483 | 1874483 | 2021-11-01 | Bailey | Texas | 48017 | 1005 | 25 |
1874528 | 1874528 | 2021-11-01 | Crosby | Texas | 48107 | 1005 | 37 |
1871234 | 1871234 | 2021-10-31 | Bailey | Texas | 48017 | 1005 | 25 |
1871279 | 1871279 | 2021-10-31 | Crosby | Texas | 48107 | 1005 | 37 |
1867985 | 1867985 | 2021-10-30 | Bailey | Texas | 48017 | 1005 | 25 |
1868030 | 1868030 | 2021-10-30 | Crosby | Texas | 48107 | 1005 | 37 |
1864736 | 1864736 | 2021-10-29 | Bailey | Texas | 48017 | 1005 | 23 |
1861487 | 1861487 | 2021-10-28 | Bailey | Texas | 48017 | 1005 | 23 |
1858238 | 1858238 | 2021-10-27 | Bailey | Texas | 48017 | 1005 | 23 |
1852866 | 1852866 | 2021-10-26 | Randolph | Georgia | 13243 | 1005 | 42 |
1854989 | 1854989 | 2021-10-26 | Bailey | Texas | 48017 | 1005 | 23 |
1849617 | 1849617 | 2021-10-25 | Randolph | Georgia | 13243 | 1005 | 42 |
1815058 | 1815058 | 2021-10-14 | Dawes | Nebraska | 31045 | 1005 | 21 |
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);