ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,508 rows where cases = 94 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 128
- Nebraska 105
- Colorado 98
- Kentucky 66
- Georgia 52
- Michigan 52
- Puerto Rico 51
- South Dakota 51
- Virginia 48
- Iowa 45
- Indiana 43
- Missouri 43
- Illinois 41
- Minnesota 40
- North Carolina 40
- Pennsylvania 37
- Oklahoma 36
- Montana 32
- Mississippi 31
- Tennessee 31
- Ohio 30
- Wisconsin 29
- Arkansas 28
- New York 28
- Kansas 25
- Utah 25
- Oregon 24
- Alaska 23
- Idaho 23
- Louisiana 23
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491478 | 2491478 | 2022-05-10 | Banner | Nebraska | 31007 | 94 | 2 |
2488220 | 2488220 | 2022-05-09 | Banner | Nebraska | 31007 | 94 | 2 |
2484963 | 2484963 | 2022-05-08 | Banner | Nebraska | 31007 | 94 | 2 |
2481705 | 2481705 | 2022-05-07 | Banner | Nebraska | 31007 | 94 | 2 |
2478447 | 2478447 | 2022-05-06 | Banner | Nebraska | 31007 | 94 | 2 |
2475189 | 2475189 | 2022-05-05 | Banner | Nebraska | 31007 | 94 | 2 |
2471932 | 2471932 | 2022-05-04 | Banner | Nebraska | 31007 | 94 | 2 |
2468676 | 2468676 | 2022-05-03 | Banner | Nebraska | 31007 | 94 | 2 |
2465420 | 2465420 | 2022-05-02 | Banner | Nebraska | 31007 | 94 | 2 |
2462165 | 2462165 | 2022-05-01 | Banner | Nebraska | 31007 | 94 | 2 |
2458909 | 2458909 | 2022-04-30 | Banner | Nebraska | 31007 | 94 | 2 |
2455653 | 2455653 | 2022-04-29 | Banner | Nebraska | 31007 | 94 | 2 |
2452397 | 2452397 | 2022-04-28 | Banner | Nebraska | 31007 | 94 | 2 |
2449141 | 2449141 | 2022-04-27 | Banner | Nebraska | 31007 | 94 | 2 |
2445884 | 2445884 | 2022-04-26 | Banner | Nebraska | 31007 | 94 | 2 |
2442629 | 2442629 | 2022-04-25 | Banner | Nebraska | 31007 | 94 | 2 |
2439373 | 2439373 | 2022-04-24 | Banner | Nebraska | 31007 | 94 | 2 |
2436117 | 2436117 | 2022-04-23 | Banner | Nebraska | 31007 | 94 | 2 |
2432861 | 2432861 | 2022-04-22 | Banner | Nebraska | 31007 | 94 | 2 |
2280013 | 2280013 | 2022-03-06 | Thomas | Nebraska | 31171 | 94 | 1 |
2276760 | 2276760 | 2022-03-05 | Thomas | Nebraska | 31171 | 94 | 1 |
2273507 | 2273507 | 2022-03-04 | Thomas | Nebraska | 31171 | 94 | 1 |
2274395 | 2274395 | 2022-03-04 | Borden | Texas | 48033 | 94 | 2 |
2270255 | 2270255 | 2022-03-03 | Thomas | Nebraska | 31171 | 94 | 1 |
2271142 | 2271142 | 2022-03-03 | Borden | Texas | 48033 | 94 | 2 |
2267002 | 2267002 | 2022-03-02 | Thomas | Nebraska | 31171 | 94 | 1 |
2267890 | 2267890 | 2022-03-02 | Borden | Texas | 48033 | 94 | 2 |
2262090 | 2262090 | 2022-03-01 | Unknown | American Samoa | 94 | 0 | |
2263751 | 2263751 | 2022-03-01 | Thomas | Nebraska | 31171 | 94 | 1 |
2264637 | 2264637 | 2022-03-01 | Borden | Texas | 48033 | 94 | 2 |
2260500 | 2260500 | 2022-02-28 | Thomas | Nebraska | 31171 | 94 | 1 |
2261387 | 2261387 | 2022-02-28 | Borden | Texas | 48033 | 94 | 2 |
2258136 | 2258136 | 2022-02-27 | Borden | Texas | 48033 | 94 | 2 |
2254885 | 2254885 | 2022-02-26 | Borden | Texas | 48033 | 94 | 2 |
2251634 | 2251634 | 2022-02-25 | Borden | Texas | 48033 | 94 | 2 |
2248383 | 2248383 | 2022-02-24 | Borden | Texas | 48033 | 94 | 2 |
2245132 | 2245132 | 2022-02-23 | Borden | Texas | 48033 | 94 | 2 |
2241881 | 2241881 | 2022-02-22 | Borden | Texas | 48033 | 94 | 2 |
2238630 | 2238630 | 2022-02-21 | Borden | Texas | 48033 | 94 | 2 |
2235379 | 2235379 | 2022-02-20 | Borden | Texas | 48033 | 94 | 2 |
2232128 | 2232128 | 2022-02-19 | Borden | Texas | 48033 | 94 | 2 |
2228877 | 2228877 | 2022-02-18 | Borden | Texas | 48033 | 94 | 2 |
2225626 | 2225626 | 2022-02-17 | Borden | Texas | 48033 | 94 | 2 |
2222375 | 2222375 | 2022-02-16 | Borden | Texas | 48033 | 94 | 2 |
2219124 | 2219124 | 2022-02-15 | Borden | Texas | 48033 | 94 | 2 |
2215873 | 2215873 | 2022-02-14 | Borden | Texas | 48033 | 94 | 2 |
2212622 | 2212622 | 2022-02-13 | Borden | Texas | 48033 | 94 | 2 |
2209369 | 2209369 | 2022-02-12 | Borden | Texas | 48033 | 94 | 2 |
2206116 | 2206116 | 2022-02-11 | Borden | Texas | 48033 | 94 | 2 |
2202863 | 2202863 | 2022-02-10 | Borden | Texas | 48033 | 94 | 2 |
2199609 | 2199609 | 2022-02-09 | Borden | Texas | 48033 | 94 | 2 |
2196355 | 2196355 | 2022-02-08 | Borden | Texas | 48033 | 94 | 2 |
2193101 | 2193101 | 2022-02-07 | Borden | Texas | 48033 | 94 | 2 |
2189847 | 2189847 | 2022-02-06 | Borden | Texas | 48033 | 94 | 2 |
2186594 | 2186594 | 2022-02-05 | Borden | Texas | 48033 | 94 | 2 |
2183342 | 2183342 | 2022-02-04 | Borden | Texas | 48033 | 94 | 2 |
2180090 | 2180090 | 2022-02-03 | Borden | Texas | 48033 | 94 | 2 |
2176839 | 2176839 | 2022-02-02 | Borden | Texas | 48033 | 94 | 2 |
2173585 | 2173585 | 2022-02-01 | Borden | Texas | 48033 | 94 | 2 |
2143414 | 2143414 | 2022-01-23 | Thomas | Nebraska | 31171 | 94 | 1 |
2140159 | 2140159 | 2022-01-22 | Thomas | Nebraska | 31171 | 94 | 1 |
2136903 | 2136903 | 2022-01-21 | Thomas | Nebraska | 31171 | 94 | 1 |
2133603 | 2133603 | 2022-01-20 | Grant | Nebraska | 31075 | 94 | 5 |
2130350 | 2130350 | 2022-01-19 | Grant | Nebraska | 31075 | 94 | 5 |
2125476 | 2125476 | 2022-01-18 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2125962 | 2125962 | 2022-01-18 | Clark | Idaho | 16033 | 94 | 0 |
2127096 | 2127096 | 2022-01-18 | Grant | Nebraska | 31075 | 94 | 5 |
2122224 | 2122224 | 2022-01-17 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2122710 | 2122710 | 2022-01-17 | Clark | Idaho | 16033 | 94 | 0 |
2123844 | 2123844 | 2022-01-17 | Grant | Nebraska | 31075 | 94 | 5 |
2118972 | 2118972 | 2022-01-16 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2119458 | 2119458 | 2022-01-16 | Clark | Idaho | 16033 | 94 | 0 |
2120592 | 2120592 | 2022-01-16 | Grant | Nebraska | 31075 | 94 | 5 |
2115720 | 2115720 | 2022-01-15 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2116206 | 2116206 | 2022-01-15 | Clark | Idaho | 16033 | 94 | 0 |
2117340 | 2117340 | 2022-01-15 | Grant | Nebraska | 31075 | 94 | 5 |
2112468 | 2112468 | 2022-01-14 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2112955 | 2112955 | 2022-01-14 | Clark | Idaho | 16033 | 94 | 0 |
2114089 | 2114089 | 2022-01-14 | Grant | Nebraska | 31075 | 94 | 5 |
2109216 | 2109216 | 2022-01-13 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2109401 | 2109401 | 2022-01-13 | Hinsdale | Colorado | 8053 | 94 | 0 |
2109703 | 2109703 | 2022-01-13 | Clark | Idaho | 16033 | 94 | 0 |
2110837 | 2110837 | 2022-01-13 | Grant | Nebraska | 31075 | 94 | 5 |
2105965 | 2105965 | 2022-01-12 | Skagway Municipality | Alaska | 2230 | 94 | 0 |
2106150 | 2106150 | 2022-01-12 | Hinsdale | Colorado | 8053 | 94 | 0 |
2106452 | 2106452 | 2022-01-12 | Clark | Idaho | 16033 | 94 | 0 |
2107586 | 2107586 | 2022-01-12 | Grant | Nebraska | 31075 | 94 | 5 |
2107591 | 2107591 | 2022-01-12 | Hayes | Nebraska | 31085 | 94 | 0 |
2103201 | 2103201 | 2022-01-11 | Clark | Idaho | 16033 | 94 | 0 |
2104340 | 2104340 | 2022-01-11 | Hayes | Nebraska | 31085 | 94 | 0 |
2099950 | 2099950 | 2022-01-10 | Clark | Idaho | 16033 | 94 | 0 |
2101089 | 2101089 | 2022-01-10 | Hayes | Nebraska | 31085 | 94 | 0 |
2096699 | 2096699 | 2022-01-09 | Clark | Idaho | 16033 | 94 | 0 |
2093447 | 2093447 | 2022-01-08 | Clark | Idaho | 16033 | 94 | 0 |
2090195 | 2090195 | 2022-01-07 | Clark | Idaho | 16033 | 94 | 0 |
2086944 | 2086944 | 2022-01-06 | Clark | Idaho | 16033 | 94 | 0 |
2075126 | 2075126 | 2022-01-02 | Wheeler | Nebraska | 31183 | 94 | 0 |
2071875 | 2071875 | 2022-01-01 | Wheeler | Nebraska | 31183 | 94 | 0 |
2068624 | 2068624 | 2021-12-31 | Wheeler | Nebraska | 31183 | 94 | 0 |
2065373 | 2065373 | 2021-12-30 | Wheeler | Nebraska | 31183 | 94 | 0 |
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);