ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,065 rows where cases = 266 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 149
- South Dakota 100
- Nebraska 89
- Georgia 84
- Texas 75
- North Dakota 48
- Puerto Rico 36
- Montana 34
- Virginia 34
- Kentucky 27
- Colorado 25
- Indiana 25
- New York 25
- Illinois 23
- Iowa 23
- Arkansas 22
- Alaska 21
- North Carolina 20
- Ohio 20
- Minnesota 18
- Mississippi 16
- West Virginia 13
- Missouri 11
- Oregon 11
- Tennessee 11
- Wisconsin 11
- Florida 9
- Pennsylvania 9
- Oklahoma 8
- Alabama 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444729 | 2444729 | 2022-04-26 | Taliaferro | Georgia | 13265 | 266 | 3 |
2441473 | 2441473 | 2022-04-25 | Taliaferro | Georgia | 13265 | 266 | 3 |
2438217 | 2438217 | 2022-04-24 | Taliaferro | Georgia | 13265 | 266 | 3 |
2434961 | 2434961 | 2022-04-23 | Taliaferro | Georgia | 13265 | 266 | 3 |
2431705 | 2431705 | 2022-04-22 | Taliaferro | Georgia | 13265 | 266 | 3 |
2428449 | 2428449 | 2022-04-21 | Taliaferro | Georgia | 13265 | 266 | 3 |
2425193 | 2425193 | 2022-04-20 | Taliaferro | Georgia | 13265 | 266 | 3 |
2421937 | 2421937 | 2022-04-19 | Taliaferro | Georgia | 13265 | 266 | 3 |
2418681 | 2418681 | 2022-04-18 | Taliaferro | Georgia | 13265 | 266 | 3 |
2415425 | 2415425 | 2022-04-17 | Taliaferro | Georgia | 13265 | 266 | 3 |
2412169 | 2412169 | 2022-04-16 | Taliaferro | Georgia | 13265 | 266 | 3 |
2408913 | 2408913 | 2022-04-15 | Taliaferro | Georgia | 13265 | 266 | 3 |
2405657 | 2405657 | 2022-04-14 | Taliaferro | Georgia | 13265 | 266 | 3 |
2402402 | 2402402 | 2022-04-13 | Taliaferro | Georgia | 13265 | 266 | 3 |
2399147 | 2399147 | 2022-04-12 | Taliaferro | Georgia | 13265 | 266 | 3 |
2401104 | 2401104 | 2022-04-12 | Campbell | South Dakota | 46021 | 266 | 7 |
2395892 | 2395892 | 2022-04-11 | Taliaferro | Georgia | 13265 | 266 | 3 |
2397849 | 2397849 | 2022-04-11 | Campbell | South Dakota | 46021 | 266 | 7 |
2392636 | 2392636 | 2022-04-10 | Taliaferro | Georgia | 13265 | 266 | 3 |
2394594 | 2394594 | 2022-04-10 | Campbell | South Dakota | 46021 | 266 | 7 |
2389380 | 2389380 | 2022-04-09 | Taliaferro | Georgia | 13265 | 266 | 3 |
2391338 | 2391338 | 2022-04-09 | Campbell | South Dakota | 46021 | 266 | 7 |
2386125 | 2386125 | 2022-04-08 | Taliaferro | Georgia | 13265 | 266 | 3 |
2388082 | 2388082 | 2022-04-08 | Campbell | South Dakota | 46021 | 266 | 7 |
2382870 | 2382870 | 2022-04-07 | Taliaferro | Georgia | 13265 | 266 | 3 |
2384827 | 2384827 | 2022-04-07 | Campbell | South Dakota | 46021 | 266 | 7 |
2379615 | 2379615 | 2022-04-06 | Taliaferro | Georgia | 13265 | 266 | 3 |
2381572 | 2381572 | 2022-04-06 | Campbell | South Dakota | 46021 | 266 | 7 |
2376361 | 2376361 | 2022-04-05 | Taliaferro | Georgia | 13265 | 266 | 3 |
2378317 | 2378317 | 2022-04-05 | Campbell | South Dakota | 46021 | 266 | 7 |
2373109 | 2373109 | 2022-04-04 | Taliaferro | Georgia | 13265 | 266 | 3 |
2375063 | 2375063 | 2022-04-04 | Campbell | South Dakota | 46021 | 266 | 7 |
2369856 | 2369856 | 2022-04-03 | Taliaferro | Georgia | 13265 | 266 | 3 |
2371811 | 2371811 | 2022-04-03 | Campbell | South Dakota | 46021 | 266 | 7 |
2366603 | 2366603 | 2022-04-02 | Taliaferro | Georgia | 13265 | 266 | 3 |
2368558 | 2368558 | 2022-04-02 | Campbell | South Dakota | 46021 | 266 | 7 |
2363350 | 2363350 | 2022-04-01 | Taliaferro | Georgia | 13265 | 266 | 3 |
2365305 | 2365305 | 2022-04-01 | Campbell | South Dakota | 46021 | 266 | 7 |
2360096 | 2360096 | 2022-03-31 | Taliaferro | Georgia | 13265 | 266 | 3 |
2362052 | 2362052 | 2022-03-31 | Campbell | South Dakota | 46021 | 266 | 7 |
2356842 | 2356842 | 2022-03-30 | Taliaferro | Georgia | 13265 | 266 | 3 |
2358798 | 2358798 | 2022-03-30 | Campbell | South Dakota | 46021 | 266 | 7 |
2355544 | 2355544 | 2022-03-29 | Campbell | South Dakota | 46021 | 266 | 7 |
2352291 | 2352291 | 2022-03-28 | Campbell | South Dakota | 46021 | 266 | 7 |
2349039 | 2349039 | 2022-03-27 | Campbell | South Dakota | 46021 | 266 | 7 |
2345786 | 2345786 | 2022-03-26 | Campbell | South Dakota | 46021 | 266 | 7 |
2342533 | 2342533 | 2022-03-25 | Campbell | South Dakota | 46021 | 266 | 7 |
2339280 | 2339280 | 2022-03-24 | Campbell | South Dakota | 46021 | 266 | 7 |
2336026 | 2336026 | 2022-03-23 | Campbell | South Dakota | 46021 | 266 | 7 |
2332772 | 2332772 | 2022-03-22 | Campbell | South Dakota | 46021 | 266 | 7 |
2329519 | 2329519 | 2022-03-21 | Campbell | South Dakota | 46021 | 266 | 7 |
2326267 | 2326267 | 2022-03-20 | Campbell | South Dakota | 46021 | 266 | 7 |
2323014 | 2323014 | 2022-03-19 | Campbell | South Dakota | 46021 | 266 | 7 |
2319760 | 2319760 | 2022-03-18 | Campbell | South Dakota | 46021 | 266 | 7 |
2281108 | 2281108 | 2022-03-06 | Throckmorton | Texas | 48447 | 266 | 8 |
2277855 | 2277855 | 2022-03-05 | Throckmorton | Texas | 48447 | 266 | 8 |
2274602 | 2274602 | 2022-03-04 | Throckmorton | Texas | 48447 | 266 | 8 |
2271349 | 2271349 | 2022-03-03 | Throckmorton | Texas | 48447 | 266 | 8 |
2268097 | 2268097 | 2022-03-02 | Throckmorton | Texas | 48447 | 266 | 8 |
2264844 | 2264844 | 2022-03-01 | Throckmorton | Texas | 48447 | 266 | 8 |
2261594 | 2261594 | 2022-02-28 | Throckmorton | Texas | 48447 | 266 | 8 |
2258343 | 2258343 | 2022-02-27 | Throckmorton | Texas | 48447 | 266 | 8 |
2255092 | 2255092 | 2022-02-26 | Throckmorton | Texas | 48447 | 266 | 8 |
2251841 | 2251841 | 2022-02-25 | Throckmorton | Texas | 48447 | 266 | 8 |
2248590 | 2248590 | 2022-02-24 | Throckmorton | Texas | 48447 | 266 | 8 |
2245339 | 2245339 | 2022-02-23 | Throckmorton | Texas | 48447 | 266 | 8 |
2242088 | 2242088 | 2022-02-22 | Throckmorton | Texas | 48447 | 266 | 8 |
2238837 | 2238837 | 2022-02-21 | Throckmorton | Texas | 48447 | 266 | 8 |
2159972 | 2159972 | 2022-01-28 | Sheridan | North Dakota | 38083 | 266 | 6 |
2144336 | 2144336 | 2022-01-23 | Cottle | Texas | 48101 | 266 | 9 |
2141081 | 2141081 | 2022-01-22 | Cottle | Texas | 48101 | 266 | 9 |
2137825 | 2137825 | 2022-01-21 | Cottle | Texas | 48101 | 266 | 9 |
2123907 | 2123907 | 2022-01-17 | Eureka | Nevada | 32011 | 266 | 1 |
2120655 | 2120655 | 2022-01-16 | Eureka | Nevada | 32011 | 266 | 1 |
2117403 | 2117403 | 2022-01-15 | Eureka | Nevada | 32011 | 266 | 1 |
2114152 | 2114152 | 2022-01-14 | Eureka | Nevada | 32011 | 266 | 1 |
2106132 | 2106132 | 2022-01-12 | Cheyenne | Colorado | 8017 | 266 | 9 |
2102881 | 2102881 | 2022-01-11 | Cheyenne | Colorado | 8017 | 266 | 9 |
2104322 | 2104322 | 2022-01-11 | Deuel | Nebraska | 31049 | 266 | 2 |
2101071 | 2101071 | 2022-01-10 | Deuel | Nebraska | 31049 | 266 | 2 |
2101414 | 2101414 | 2022-01-10 | Oliver | North Dakota | 38065 | 266 | 4 |
2098163 | 2098163 | 2022-01-09 | Oliver | North Dakota | 38065 | 266 | 4 |
2075068 | 2075068 | 2022-01-02 | Garden | Nebraska | 31069 | 266 | 1 |
2071817 | 2071817 | 2022-01-01 | Garden | Nebraska | 31069 | 266 | 1 |
2068566 | 2068566 | 2021-12-31 | Garden | Nebraska | 31069 | 266 | 1 |
2065315 | 2065315 | 2021-12-30 | Garden | Nebraska | 31069 | 266 | 1 |
1989790 | 1989790 | 2021-12-07 | Hodgeman | Kansas | 20083 | 266 | 10 |
1991925 | 1991925 | 2021-12-07 | Garfield | Washington | 53023 | 266 | 7 |
1986540 | 1986540 | 2021-12-06 | Hodgeman | Kansas | 20083 | 266 | 10 |
1972879 | 1972879 | 2021-12-02 | Kiowa | Colorado | 8061 | 266 | 4 |
1969629 | 1969629 | 2021-12-01 | Kiowa | Colorado | 8061 | 266 | 4 |
1967743 | 1967743 | 2021-11-30 | Liberty | Montana | 30051 | 266 | 2 |
1964491 | 1964491 | 2021-11-29 | Liberty | Montana | 30051 | 266 | 2 |
1961240 | 1961240 | 2021-11-28 | Liberty | Montana | 30051 | 266 | 2 |
1961307 | 1961307 | 2021-11-28 | Gosper | Nebraska | 31073 | 266 | 5 |
1957989 | 1957989 | 2021-11-27 | Liberty | Montana | 30051 | 266 | 2 |
1958056 | 1958056 | 2021-11-27 | Gosper | Nebraska | 31073 | 266 | 5 |
1954738 | 1954738 | 2021-11-26 | Liberty | Montana | 30051 | 266 | 2 |
1954805 | 1954805 | 2021-11-26 | Gosper | Nebraska | 31073 | 266 | 5 |
1951487 | 1951487 | 2021-11-25 | Liberty | Montana | 30051 | 266 | 2 |
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);