ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,537 rows where cases = 87 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 152
- Nebraska 109
- Georgia 74
- Virginia 73
- Missouri 71
- Colorado 64
- Kentucky 64
- Minnesota 54
- Kansas 50
- Iowa 48
- Indiana 45
- Puerto Rico 42
- South Dakota 40
- Illinois 39
- North Carolina 33
- Oklahoma 32
- Pennsylvania 31
- Oregon 30
- Michigan 29
- Montana 29
- Ohio 29
- Idaho 28
- Tennessee 28
- Wisconsin 27
- Arkansas 26
- California 25
- Alabama 23
- New York 22
- West Virginia 21
- Utah 20
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501252 | 2501252 | 2022-05-13 | Banner | Nebraska | 31007 | 87 | 2 |
2497994 | 2497994 | 2022-05-12 | Banner | Nebraska | 31007 | 87 | 2 |
2494736 | 2494736 | 2022-05-11 | Banner | Nebraska | 31007 | 87 | 2 |
2429659 | 2429659 | 2022-04-21 | Loup | Nebraska | 31115 | 87 | 0 |
2426403 | 2426403 | 2022-04-20 | Loup | Nebraska | 31115 | 87 | 0 |
2423147 | 2423147 | 2022-04-19 | Loup | Nebraska | 31115 | 87 | 0 |
2419890 | 2419890 | 2022-04-18 | Loup | Nebraska | 31115 | 87 | 0 |
2416635 | 2416635 | 2022-04-17 | Loup | Nebraska | 31115 | 87 | 0 |
2413379 | 2413379 | 2022-04-16 | Loup | Nebraska | 31115 | 87 | 0 |
2409278 | 2409278 | 2022-04-15 | Unknown | Iowa | 87 | 0 | |
2410123 | 2410123 | 2022-04-15 | Loup | Nebraska | 31115 | 87 | 0 |
2406022 | 2406022 | 2022-04-14 | Unknown | Iowa | 87 | 0 | |
2406867 | 2406867 | 2022-04-14 | Loup | Nebraska | 31115 | 87 | 0 |
2403611 | 2403611 | 2022-04-13 | Loup | Nebraska | 31115 | 87 | 0 |
2400356 | 2400356 | 2022-04-12 | Loup | Nebraska | 31115 | 87 | 0 |
2397101 | 2397101 | 2022-04-11 | Loup | Nebraska | 31115 | 87 | 0 |
2393846 | 2393846 | 2022-04-10 | Loup | Nebraska | 31115 | 87 | 0 |
2390590 | 2390590 | 2022-04-09 | Loup | Nebraska | 31115 | 87 | 0 |
2387334 | 2387334 | 2022-04-08 | Loup | Nebraska | 31115 | 87 | 0 |
2384079 | 2384079 | 2022-04-07 | Loup | Nebraska | 31115 | 87 | 0 |
2380824 | 2380824 | 2022-04-06 | Loup | Nebraska | 31115 | 87 | 0 |
2377569 | 2377569 | 2022-04-05 | Loup | Nebraska | 31115 | 87 | 0 |
2374316 | 2374316 | 2022-04-04 | Loup | Nebraska | 31115 | 87 | 0 |
2371064 | 2371064 | 2022-04-03 | Loup | Nebraska | 31115 | 87 | 0 |
2367811 | 2367811 | 2022-04-02 | Loup | Nebraska | 31115 | 87 | 0 |
2364558 | 2364558 | 2022-04-01 | Loup | Nebraska | 31115 | 87 | 0 |
2361304 | 2361304 | 2022-03-31 | Loup | Nebraska | 31115 | 87 | 0 |
2358050 | 2358050 | 2022-03-30 | Loup | Nebraska | 31115 | 87 | 0 |
2354797 | 2354797 | 2022-03-29 | Loup | Nebraska | 31115 | 87 | 0 |
2351544 | 2351544 | 2022-03-28 | Loup | Nebraska | 31115 | 87 | 0 |
2348292 | 2348292 | 2022-03-27 | Loup | Nebraska | 31115 | 87 | 0 |
2345039 | 2345039 | 2022-03-26 | Loup | Nebraska | 31115 | 87 | 0 |
2341786 | 2341786 | 2022-03-25 | Loup | Nebraska | 31115 | 87 | 0 |
2338533 | 2338533 | 2022-03-24 | Loup | Nebraska | 31115 | 87 | 0 |
2335279 | 2335279 | 2022-03-23 | Loup | Nebraska | 31115 | 87 | 0 |
2332025 | 2332025 | 2022-03-22 | Loup | Nebraska | 31115 | 87 | 0 |
2328772 | 2328772 | 2022-03-21 | Loup | Nebraska | 31115 | 87 | 0 |
2325520 | 2325520 | 2022-03-20 | Loup | Nebraska | 31115 | 87 | 0 |
2322266 | 2322266 | 2022-03-19 | Loup | Nebraska | 31115 | 87 | 0 |
2319012 | 2319012 | 2022-03-18 | Loup | Nebraska | 31115 | 87 | 0 |
2315759 | 2315759 | 2022-03-17 | Loup | Nebraska | 31115 | 87 | 0 |
2312506 | 2312506 | 2022-03-16 | Loup | Nebraska | 31115 | 87 | 0 |
2309253 | 2309253 | 2022-03-15 | Loup | Nebraska | 31115 | 87 | 0 |
2306001 | 2306001 | 2022-03-14 | Loup | Nebraska | 31115 | 87 | 0 |
2302750 | 2302750 | 2022-03-13 | Loup | Nebraska | 31115 | 87 | 0 |
2299498 | 2299498 | 2022-03-12 | Loup | Nebraska | 31115 | 87 | 0 |
2296246 | 2296246 | 2022-03-11 | Loup | Nebraska | 31115 | 87 | 0 |
2292994 | 2292994 | 2022-03-10 | Loup | Nebraska | 31115 | 87 | 0 |
2289742 | 2289742 | 2022-03-09 | Loup | Nebraska | 31115 | 87 | 0 |
2286490 | 2286490 | 2022-03-08 | Loup | Nebraska | 31115 | 87 | 0 |
2283238 | 2283238 | 2022-03-07 | Loup | Nebraska | 31115 | 87 | 0 |
2279985 | 2279985 | 2022-03-06 | Loup | Nebraska | 31115 | 87 | 0 |
2276732 | 2276732 | 2022-03-05 | Loup | Nebraska | 31115 | 87 | 0 |
2273479 | 2273479 | 2022-03-04 | Loup | Nebraska | 31115 | 87 | 0 |
2270227 | 2270227 | 2022-03-03 | Loup | Nebraska | 31115 | 87 | 0 |
2266974 | 2266974 | 2022-03-02 | Loup | Nebraska | 31115 | 87 | 0 |
2263723 | 2263723 | 2022-03-01 | Loup | Nebraska | 31115 | 87 | 0 |
2260472 | 2260472 | 2022-02-28 | Loup | Nebraska | 31115 | 87 | 0 |
2257221 | 2257221 | 2022-02-27 | Loup | Nebraska | 31115 | 87 | 0 |
2253970 | 2253970 | 2022-02-26 | Loup | Nebraska | 31115 | 87 | 0 |
2250719 | 2250719 | 2022-02-25 | Loup | Nebraska | 31115 | 87 | 0 |
2247468 | 2247468 | 2022-02-24 | Loup | Nebraska | 31115 | 87 | 0 |
2244217 | 2244217 | 2022-02-23 | Loup | Nebraska | 31115 | 87 | 0 |
2240966 | 2240966 | 2022-02-22 | Loup | Nebraska | 31115 | 87 | 0 |
2237715 | 2237715 | 2022-02-21 | Loup | Nebraska | 31115 | 87 | 0 |
2234464 | 2234464 | 2022-02-20 | Loup | Nebraska | 31115 | 87 | 0 |
2231213 | 2231213 | 2022-02-19 | Loup | Nebraska | 31115 | 87 | 0 |
2227962 | 2227962 | 2022-02-18 | Loup | Nebraska | 31115 | 87 | 0 |
2201989 | 2201989 | 2022-02-10 | Esmeralda | Nevada | 32009 | 87 | 3 |
2198735 | 2198735 | 2022-02-09 | Esmeralda | Nevada | 32009 | 87 | 3 |
2198812 | 2198812 | 2022-02-09 | Unknown | New Mexico | 87 | 0 | |
2195439 | 2195439 | 2022-02-08 | Loup | Nebraska | 31115 | 87 | 0 |
2195481 | 2195481 | 2022-02-08 | Esmeralda | Nevada | 32009 | 87 | 3 |
2192185 | 2192185 | 2022-02-07 | Loup | Nebraska | 31115 | 87 | 0 |
2192227 | 2192227 | 2022-02-07 | Esmeralda | Nevada | 32009 | 87 | 3 |
2188932 | 2188932 | 2022-02-06 | Loup | Nebraska | 31115 | 87 | 0 |
2188974 | 2188974 | 2022-02-06 | Esmeralda | Nevada | 32009 | 87 | 3 |
2185679 | 2185679 | 2022-02-05 | Loup | Nebraska | 31115 | 87 | 0 |
2185721 | 2185721 | 2022-02-05 | Esmeralda | Nevada | 32009 | 87 | 3 |
2182427 | 2182427 | 2022-02-04 | Loup | Nebraska | 31115 | 87 | 0 |
2182469 | 2182469 | 2022-02-04 | Esmeralda | Nevada | 32009 | 87 | 3 |
2179175 | 2179175 | 2022-02-03 | Loup | Nebraska | 31115 | 87 | 0 |
2179217 | 2179217 | 2022-02-03 | Esmeralda | Nevada | 32009 | 87 | 3 |
2175923 | 2175923 | 2022-02-02 | Loup | Nebraska | 31115 | 87 | 0 |
2175965 | 2175965 | 2022-02-02 | Esmeralda | Nevada | 32009 | 87 | 3 |
2172712 | 2172712 | 2022-02-01 | Esmeralda | Nevada | 32009 | 87 | 3 |
2169459 | 2169459 | 2022-01-31 | Esmeralda | Nevada | 32009 | 87 | 2 |
2134537 | 2134537 | 2022-01-20 | Borden | Texas | 48033 | 87 | 2 |
2101132 | 2101132 | 2022-01-10 | Thomas | Nebraska | 31171 | 87 | 1 |
1995442 | 1995442 | 2021-12-09 | Skagway Municipality | Alaska | 2230 | 87 | 0 |
1992191 | 1992191 | 2021-12-08 | Skagway Municipality | Alaska | 2230 | 87 | 0 |
1988940 | 1988940 | 2021-12-07 | Skagway Municipality | Alaska | 2230 | 87 | 0 |
1990615 | 1990615 | 2021-12-07 | Wheeler | Nebraska | 31183 | 87 | 0 |
1985690 | 1985690 | 2021-12-06 | Skagway Municipality | Alaska | 2230 | 87 | 0 |
1915810 | 1915810 | 2021-11-14 | Hooker | Nebraska | 31091 | 87 | 3 |
1912560 | 1912560 | 2021-11-13 | Hooker | Nebraska | 31091 | 87 | 3 |
1909310 | 1909310 | 2021-11-12 | Hooker | Nebraska | 31091 | 87 | 3 |
1906061 | 1906061 | 2021-11-11 | Hooker | Nebraska | 31091 | 87 | 3 |
1902812 | 1902812 | 2021-11-10 | Hooker | Nebraska | 31091 | 87 | 3 |
1899562 | 1899562 | 2021-11-09 | Hooker | Nebraska | 31091 | 87 | 3 |
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);