ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,360 rows where cases = 113 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
- Nebraska 126
- Texas 105
- Montana 70
- Georgia 63
- Kentucky 62
- Illinois 57
- Virginia 53
- Iowa 48
- Colorado 42
- South Dakota 41
- Michigan 38
- Kansas 35
- Minnesota 34
- North Carolina 34
- Indiana 33
- Pennsylvania 33
- Missouri 30
- California 29
- Ohio 29
- Puerto Rico 27
- Oklahoma 24
- Arkansas 23
- Mississippi 23
- Tennessee 23
- New York 22
- Florida 20
- West Virginia 20
- Utah 19
- Wisconsin 19
- Idaho 17
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501294 | 2501294 | 2022-05-13 | Hooker | Nebraska | 31091 | 113 | 5 |
2498036 | 2498036 | 2022-05-12 | Hooker | Nebraska | 31091 | 113 | 5 |
2494778 | 2494778 | 2022-05-11 | Hooker | Nebraska | 31091 | 113 | 5 |
2491517 | 2491517 | 2022-05-10 | Hayes | Nebraska | 31085 | 113 | 0 |
2491520 | 2491520 | 2022-05-10 | Hooker | Nebraska | 31091 | 113 | 5 |
2488259 | 2488259 | 2022-05-09 | Hayes | Nebraska | 31085 | 113 | 0 |
2488262 | 2488262 | 2022-05-09 | Hooker | Nebraska | 31091 | 113 | 5 |
2485002 | 2485002 | 2022-05-08 | Hayes | Nebraska | 31085 | 113 | 0 |
2481744 | 2481744 | 2022-05-07 | Hayes | Nebraska | 31085 | 113 | 0 |
2478486 | 2478486 | 2022-05-06 | Hayes | Nebraska | 31085 | 113 | 0 |
2475228 | 2475228 | 2022-05-05 | Hayes | Nebraska | 31085 | 113 | 0 |
2471971 | 2471971 | 2022-05-04 | Hayes | Nebraska | 31085 | 113 | 0 |
2468715 | 2468715 | 2022-05-03 | Hayes | Nebraska | 31085 | 113 | 0 |
2468718 | 2468718 | 2022-05-03 | Hooker | Nebraska | 31091 | 113 | 5 |
2465459 | 2465459 | 2022-05-02 | Hayes | Nebraska | 31085 | 113 | 0 |
2465462 | 2465462 | 2022-05-02 | Hooker | Nebraska | 31091 | 113 | 5 |
2462204 | 2462204 | 2022-05-01 | Hayes | Nebraska | 31085 | 113 | 0 |
2462207 | 2462207 | 2022-05-01 | Hooker | Nebraska | 31091 | 113 | 5 |
2458948 | 2458948 | 2022-04-30 | Hayes | Nebraska | 31085 | 113 | 0 |
2458951 | 2458951 | 2022-04-30 | Hooker | Nebraska | 31091 | 113 | 5 |
2455692 | 2455692 | 2022-04-29 | Hayes | Nebraska | 31085 | 113 | 0 |
2455695 | 2455695 | 2022-04-29 | Hooker | Nebraska | 31091 | 113 | 5 |
2452439 | 2452439 | 2022-04-28 | Hooker | Nebraska | 31091 | 113 | 5 |
2449183 | 2449183 | 2022-04-27 | Hooker | Nebraska | 31091 | 113 | 5 |
2445926 | 2445926 | 2022-04-26 | Hooker | Nebraska | 31091 | 113 | 5 |
2442671 | 2442671 | 2022-04-25 | Hooker | Nebraska | 31091 | 113 | 5 |
2439415 | 2439415 | 2022-04-24 | Hooker | Nebraska | 31091 | 113 | 5 |
2436159 | 2436159 | 2022-04-23 | Hooker | Nebraska | 31091 | 113 | 5 |
2432903 | 2432903 | 2022-04-22 | Hooker | Nebraska | 31091 | 113 | 5 |
2429647 | 2429647 | 2022-04-21 | Hooker | Nebraska | 31091 | 113 | 5 |
2426391 | 2426391 | 2022-04-20 | Hooker | Nebraska | 31091 | 113 | 5 |
2423135 | 2423135 | 2022-04-19 | Hooker | Nebraska | 31091 | 113 | 5 |
2283226 | 2283226 | 2022-03-07 | Hooker | Nebraska | 31091 | 113 | 5 |
2279973 | 2279973 | 2022-03-06 | Hooker | Nebraska | 31091 | 113 | 5 |
2276720 | 2276720 | 2022-03-05 | Hooker | Nebraska | 31091 | 113 | 5 |
2273467 | 2273467 | 2022-03-04 | Hooker | Nebraska | 31091 | 113 | 5 |
2270215 | 2270215 | 2022-03-03 | Hooker | Nebraska | 31091 | 113 | 5 |
2266962 | 2266962 | 2022-03-02 | Hooker | Nebraska | 31091 | 113 | 5 |
2263711 | 2263711 | 2022-03-01 | Hooker | Nebraska | 31091 | 113 | 5 |
2260460 | 2260460 | 2022-02-28 | Hooker | Nebraska | 31091 | 113 | 5 |
2257215 | 2257215 | 2022-02-27 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2253964 | 2253964 | 2022-02-26 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2250713 | 2250713 | 2022-02-25 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2247462 | 2247462 | 2022-02-24 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2244211 | 2244211 | 2022-02-23 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2240960 | 2240960 | 2022-02-22 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2237709 | 2237709 | 2022-02-21 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2234458 | 2234458 | 2022-02-20 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2231207 | 2231207 | 2022-02-19 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2227956 | 2227956 | 2022-02-18 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2224705 | 2224705 | 2022-02-17 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2221454 | 2221454 | 2022-02-16 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2218203 | 2218203 | 2022-02-15 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2214952 | 2214952 | 2022-02-14 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2211700 | 2211700 | 2022-02-13 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2208447 | 2208447 | 2022-02-12 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2205194 | 2205194 | 2022-02-11 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2201941 | 2201941 | 2022-02-10 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2198687 | 2198687 | 2022-02-09 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2199814 | 2199814 | 2022-02-09 | Terrell | Texas | 48443 | 113 | 3 |
2195433 | 2195433 | 2022-02-08 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2196560 | 2196560 | 2022-02-08 | Terrell | Texas | 48443 | 113 | 3 |
2192179 | 2192179 | 2022-02-07 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2193306 | 2193306 | 2022-02-07 | Terrell | Texas | 48443 | 113 | 3 |
2188926 | 2188926 | 2022-02-06 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2190052 | 2190052 | 2022-02-06 | Terrell | Texas | 48443 | 113 | 3 |
2185673 | 2185673 | 2022-02-05 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2186799 | 2186799 | 2022-02-05 | Terrell | Texas | 48443 | 113 | 3 |
2182421 | 2182421 | 2022-02-04 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2183547 | 2183547 | 2022-02-04 | Terrell | Texas | 48443 | 113 | 3 |
2179169 | 2179169 | 2022-02-03 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2180295 | 2180295 | 2022-02-03 | Terrell | Texas | 48443 | 113 | 3 |
2098972 | 2098972 | 2022-01-09 | Terrell | Texas | 48443 | 113 | 3 |
2095720 | 2095720 | 2022-01-08 | Terrell | Texas | 48443 | 113 | 3 |
2092468 | 2092468 | 2022-01-07 | Terrell | Texas | 48443 | 113 | 3 |
2086558 | 2086558 | 2022-01-06 | Alpine | California | 6003 | 113 | 0 |
2089216 | 2089216 | 2022-01-06 | Terrell | Texas | 48443 | 113 | 3 |
2083306 | 2083306 | 2022-01-05 | Alpine | California | 6003 | 113 | 0 |
2085965 | 2085965 | 2022-01-05 | Terrell | Texas | 48443 | 113 | 3 |
2080054 | 2080054 | 2022-01-04 | Alpine | California | 6003 | 113 | 0 |
2082713 | 2082713 | 2022-01-04 | Terrell | Texas | 48443 | 113 | 3 |
2076802 | 2076802 | 2022-01-03 | Alpine | California | 6003 | 113 | 0 |
2073551 | 2073551 | 2022-01-02 | Alpine | California | 6003 | 113 | 0 |
2070300 | 2070300 | 2022-01-01 | Alpine | California | 6003 | 113 | 0 |
2067049 | 2067049 | 2021-12-31 | Alpine | California | 6003 | 113 | 0 |
2063798 | 2063798 | 2021-12-30 | Alpine | California | 6003 | 113 | 0 |
2060548 | 2060548 | 2021-12-29 | Alpine | California | 6003 | 113 | 0 |
2057299 | 2057299 | 2021-12-28 | Alpine | California | 6003 | 113 | 0 |
2054050 | 2054050 | 2021-12-27 | Alpine | California | 6003 | 113 | 0 |
2050800 | 2050800 | 2021-12-26 | Alpine | California | 6003 | 113 | 0 |
2050913 | 2050913 | 2021-12-26 | San Juan | Colorado | 8111 | 113 | 0 |
2047550 | 2047550 | 2021-12-25 | Alpine | California | 6003 | 113 | 0 |
2047663 | 2047663 | 2021-12-25 | San Juan | Colorado | 8111 | 113 | 0 |
2044300 | 2044300 | 2021-12-24 | Alpine | California | 6003 | 113 | 0 |
2044413 | 2044413 | 2021-12-24 | San Juan | Colorado | 8111 | 113 | 0 |
2041164 | 2041164 | 2021-12-23 | San Juan | Colorado | 8111 | 113 | 0 |
2037914 | 2037914 | 2021-12-22 | San Juan | Colorado | 8111 | 113 | 0 |
2011242 | 2011242 | 2021-12-13 | Daggett | Utah | 49009 | 113 | 0 |
2007991 | 2007991 | 2021-12-12 | Daggett | Utah | 49009 | 113 | 0 |
2004740 | 2004740 | 2021-12-11 | Daggett | Utah | 49009 | 113 | 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);