ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
407 rows where cases = 1187 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46
- Iowa 25
- Kentucky 24
- Georgia 21
- Kansas 17
- Puerto Rico 17
- Virginia 17
- Michigan 16
- Missouri 14
- Oklahoma 13
- West Virginia 13
- Nevada 11
- Arkansas 10
- Nebraska 10
- North Carolina 10
- Colorado 9
- Idaho 9
- Minnesota 9
- Montana 8
- Alabama 7
- Mississippi 7
- North Dakota 7
- Ohio 7
- Tennessee 7
- Florida 6
- Illinois 6
- Louisiana 6
- Indiana 5
- Pennsylvania 5
- South Dakota 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502545 | 2502545 | 2022-05-13 | Emporia city | Virginia | 51595 | 1187 | 55 |
2499287 | 2499287 | 2022-05-12 | Emporia city | Virginia | 51595 | 1187 | 55 |
2496029 | 2496029 | 2022-05-11 | Emporia city | Virginia | 51595 | 1187 | 55 |
2491209 | 2491209 | 2022-05-10 | Unknown | Minnesota | 1187 | 280 | |
2492771 | 2492771 | 2022-05-10 | Emporia city | Virginia | 51595 | 1187 | 55 |
2450337 | 2450337 | 2022-04-27 | Wheeler | Texas | 48483 | 1187 | 22 |
2421716 | 2421716 | 2022-04-19 | Saguache | Colorado | 8109 | 1187 | 12 |
2419858 | 2419858 | 2022-04-18 | Dixon | Nebraska | 31051 | 1187 | 11 |
2415204 | 2415204 | 2022-04-17 | Saguache | Colorado | 8109 | 1187 | 12 |
2416603 | 2416603 | 2022-04-17 | Dixon | Nebraska | 31051 | 1187 | 11 |
2411948 | 2411948 | 2022-04-16 | Saguache | Colorado | 8109 | 1187 | 12 |
2413347 | 2413347 | 2022-04-16 | Dixon | Nebraska | 31051 | 1187 | 11 |
2408692 | 2408692 | 2022-04-15 | Saguache | Colorado | 8109 | 1187 | 12 |
2410091 | 2410091 | 2022-04-15 | Dixon | Nebraska | 31051 | 1187 | 11 |
2406835 | 2406835 | 2022-04-14 | Dixon | Nebraska | 31051 | 1187 | 11 |
2403579 | 2403579 | 2022-04-13 | Dixon | Nebraska | 31051 | 1187 | 11 |
2375371 | 2375371 | 2022-04-04 | Martin | Texas | 48317 | 1187 | 26 |
2372119 | 2372119 | 2022-04-03 | Martin | Texas | 48317 | 1187 | 26 |
2368866 | 2368866 | 2022-04-02 | Martin | Texas | 48317 | 1187 | 26 |
2365613 | 2365613 | 2022-04-01 | Martin | Texas | 48317 | 1187 | 26 |
2293980 | 2293980 | 2022-03-10 | Goliad | Texas | 48175 | 1187 | 32 |
2290728 | 2290728 | 2022-03-09 | Goliad | Texas | 48175 | 1187 | 32 |
2257266 | 2257266 | 2022-02-27 | Lander | Nevada | 32015 | 1187 | 20 |
2254015 | 2254015 | 2022-02-26 | Lander | Nevada | 32015 | 1187 | 20 |
2250764 | 2250764 | 2022-02-25 | Lander | Nevada | 32015 | 1187 | 20 |
2247513 | 2247513 | 2022-02-24 | Lander | Nevada | 32015 | 1187 | 17 |
2244262 | 2244262 | 2022-02-23 | Lander | Nevada | 32015 | 1187 | 17 |
2214598 | 2214598 | 2022-02-14 | Lincoln | Minnesota | 27081 | 1187 | 6 |
2211111 | 2211111 | 2022-02-13 | Cameron | Louisiana | 22023 | 1187 | 8 |
2207858 | 2207858 | 2022-02-12 | Cameron | Louisiana | 22023 | 1187 | 8 |
2204605 | 2204605 | 2022-02-11 | Cameron | Louisiana | 22023 | 1187 | 8 |
2199472 | 2199472 | 2022-02-09 | Lyman | South Dakota | 46085 | 1187 | 12 |
2188160 | 2188160 | 2022-02-06 | Meade | Kansas | 20119 | 1187 | 17 |
2184907 | 2184907 | 2022-02-05 | Meade | Kansas | 20119 | 1187 | 17 |
2181655 | 2181655 | 2022-02-04 | Meade | Kansas | 20119 | 1187 | 17 |
2171873 | 2171873 | 2022-02-01 | Gray | Kansas | 20069 | 1187 | 23 |
2173770 | 2173770 | 2022-02-01 | Sabine | Texas | 48403 | 1187 | 78 |
2168620 | 2168620 | 2022-01-31 | Gray | Kansas | 20069 | 1187 | 23 |
2169189 | 2169189 | 2022-01-31 | Atchison | Missouri | 29005 | 1187 | 19 |
2162404 | 2162404 | 2022-01-29 | Unknown | Maryland | 1187 | 214 | |
2154817 | 2154817 | 2022-01-27 | Lafayette | Arkansas | 5073 | 1187 | 28 |
2156410 | 2156410 | 2022-01-27 | Pierce | Nebraska | 31139 | 1187 | 21 |
2157456 | 2157456 | 2022-01-27 | McCulloch | Texas | 48307 | 1187 | 42 |
2145599 | 2145599 | 2022-01-24 | Scott | Illinois | 17171 | 1187 | 10 |
2146943 | 2146943 | 2022-01-24 | McHenry | North Dakota | 38049 | 1187 | 28 |
2146961 | 2146961 | 2022-01-24 | Sioux | North Dakota | 38085 | 1187 | 19 |
2143689 | 2143689 | 2022-01-23 | McHenry | North Dakota | 38049 | 1187 | 28 |
2143707 | 2143707 | 2022-01-23 | Sioux | North Dakota | 38085 | 1187 | 19 |
2078175 | 2078175 | 2022-01-03 | Maries | Missouri | 29125 | 1187 | 22 |
2074350 | 2074350 | 2022-01-02 | Sherman | Kansas | 20181 | 1187 | 16 |
2075373 | 2075373 | 2022-01-02 | Bottineau | North Dakota | 38009 | 1187 | 24 |
2071099 | 2071099 | 2022-01-01 | Sherman | Kansas | 20181 | 1187 | 16 |
2072122 | 2072122 | 2022-01-01 | Bottineau | North Dakota | 38009 | 1187 | 24 |
2067848 | 2067848 | 2021-12-31 | Sherman | Kansas | 20181 | 1187 | 16 |
2064597 | 2064597 | 2021-12-30 | Sherman | Kansas | 20181 | 1187 | 16 |
2061347 | 2061347 | 2021-12-29 | Sherman | Kansas | 20181 | 1187 | 16 |
2057540 | 2057540 | 2021-12-28 | Crawford | Georgia | 13079 | 1187 | 46 |
2041022 | 2041022 | 2021-12-23 | Montgomery | Arkansas | 5097 | 1187 | 50 |
2036854 | 2036854 | 2021-12-21 | Hamlin | South Dakota | 46057 | 1187 | 40 |
1996874 | 1996874 | 2021-12-09 | Clark | Missouri | 29045 | 1187 | 27 |
1993881 | 1993881 | 2021-12-08 | Pershing | Nevada | 32027 | 1187 | 27 |
1989649 | 1989649 | 2021-12-07 | Adair | Iowa | 19001 | 1187 | 39 |
1991042 | 1991042 | 2021-12-07 | Kiowa | Oklahoma | 40075 | 1187 | 44 |
1986399 | 1986399 | 2021-12-06 | Adair | Iowa | 19001 | 1187 | 39 |
1987791 | 1987791 | 2021-12-06 | Kiowa | Oklahoma | 40075 | 1187 | 44 |
1983149 | 1983149 | 2021-12-05 | Adair | Iowa | 19001 | 1187 | 39 |
1984541 | 1984541 | 2021-12-05 | Kiowa | Oklahoma | 40075 | 1187 | 44 |
1979899 | 1979899 | 2021-12-04 | Adair | Iowa | 19001 | 1187 | 39 |
1981291 | 1981291 | 2021-12-04 | Kiowa | Oklahoma | 40075 | 1187 | 44 |
1976649 | 1976649 | 2021-12-03 | Adair | Iowa | 19001 | 1187 | 39 |
1978041 | 1978041 | 2021-12-03 | Kiowa | Oklahoma | 40075 | 1187 | 44 |
1973400 | 1973400 | 2021-12-02 | Adair | Iowa | 19001 | 1187 | 39 |
1974791 | 1974791 | 2021-12-02 | Kiowa | Oklahoma | 40075 | 1187 | 41 |
1975269 | 1975269 | 2021-12-02 | Coleman | Texas | 48083 | 1187 | 55 |
1970150 | 1970150 | 2021-12-01 | Adair | Iowa | 19001 | 1187 | 39 |
1971542 | 1971542 | 2021-12-01 | Kiowa | Oklahoma | 40075 | 1187 | 41 |
1946893 | 1946893 | 2021-11-24 | Rio Blanco | Colorado | 8103 | 1187 | 10 |
1942874 | 1942874 | 2021-11-22 | Marion | Texas | 48315 | 1187 | 51 |
1939624 | 1939624 | 2021-11-21 | Marion | Texas | 48315 | 1187 | 51 |
1940094 | 1940094 | 2021-11-21 | Weston | Wyoming | 56045 | 1187 | 13 |
1936374 | 1936374 | 2021-11-20 | Marion | Texas | 48315 | 1187 | 51 |
1936844 | 1936844 | 2021-11-20 | Weston | Wyoming | 56045 | 1187 | 13 |
1933124 | 1933124 | 2021-11-19 | Marion | Texas | 48315 | 1187 | 51 |
1933594 | 1933594 | 2021-11-19 | Weston | Wyoming | 56045 | 1187 | 13 |
1928669 | 1928669 | 2021-11-18 | Ozark | Missouri | 29153 | 1187 | 41 |
1928928 | 1928928 | 2021-11-18 | Quay | New Mexico | 35037 | 1187 | 25 |
1929873 | 1929873 | 2021-11-18 | Marion | Texas | 48315 | 1187 | 51 |
1926623 | 1926623 | 2021-11-17 | Marion | Texas | 48315 | 1187 | 51 |
1923373 | 1923373 | 2021-11-16 | Marion | Texas | 48315 | 1187 | 51 |
1923593 | 1923593 | 2021-11-16 | Lunenburg | Virginia | 51111 | 1187 | 22 |
1917505 | 1917505 | 2021-11-15 | Newton | Arkansas | 5101 | 1187 | 38 |
1920124 | 1920124 | 2021-11-15 | Marion | Texas | 48315 | 1187 | 51 |
1916874 | 1916874 | 2021-11-14 | Marion | Texas | 48315 | 1187 | 51 |
1913624 | 1913624 | 2021-11-13 | Marion | Texas | 48315 | 1187 | 51 |
1910374 | 1910374 | 2021-11-12 | Marion | Texas | 48315 | 1187 | 51 |
1907125 | 1907125 | 2021-11-11 | Marion | Texas | 48315 | 1187 | 51 |
1897436 | 1897436 | 2021-11-08 | Stephens | Texas | 48429 | 1187 | 36 |
1892590 | 1892590 | 2021-11-07 | Alcona | Michigan | 26001 | 1187 | 44 |
1894186 | 1894186 | 2021-11-07 | Stephens | Texas | 48429 | 1187 | 36 |
1889340 | 1889340 | 2021-11-06 | Alcona | Michigan | 26001 | 1187 | 44 |
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);