ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
628 rows where cases = 534 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 57
- Illinois 43
- Nebraska 41
- Kansas 36
- Kentucky 36
- Iowa 33
- Texas 27
- Virginia 27
- Oklahoma 23
- New Mexico 21
- Idaho 18
- Missouri 18
- Puerto Rico 17
- Minnesota 16
- West Virginia 16
- Mississippi 14
- South Dakota 14
- North Carolina 13
- Tennessee 12
- Arkansas 11
- Louisiana 11
- North Dakota 11
- Michigan 10
- Montana 10
- Alabama 8
- Alaska 8
- Florida 8
- Indiana 7
- New York 7
- Ohio 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491518 | 2491518 | 2022-05-10 | Hitchcock | Nebraska | 31087 | 534 | 8 |
2488260 | 2488260 | 2022-05-09 | Hitchcock | Nebraska | 31087 | 534 | 8 |
2470100 | 2470100 | 2022-05-03 | Wahkiakum | Washington | 53069 | 534 | 7 |
2466844 | 2466844 | 2022-05-02 | Wahkiakum | Washington | 53069 | 534 | 7 |
2452357 | 2452357 | 2022-04-28 | Granite | Montana | 30039 | 534 | 8 |
2449101 | 2449101 | 2022-04-27 | Granite | Montana | 30039 | 534 | 8 |
2445844 | 2445844 | 2022-04-26 | Granite | Montana | 30039 | 534 | 8 |
2382743 | 2382743 | 2022-04-07 | Baker | Georgia | 13007 | 534 | 14 |
2379488 | 2379488 | 2022-04-06 | Baker | Georgia | 13007 | 534 | 14 |
2376234 | 2376234 | 2022-04-05 | Baker | Georgia | 13007 | 534 | 14 |
2372982 | 2372982 | 2022-04-04 | Baker | Georgia | 13007 | 534 | 14 |
2369729 | 2369729 | 2022-04-03 | Baker | Georgia | 13007 | 534 | 14 |
2366476 | 2366476 | 2022-04-02 | Baker | Georgia | 13007 | 534 | 14 |
2363223 | 2363223 | 2022-04-01 | Baker | Georgia | 13007 | 534 | 14 |
2359969 | 2359969 | 2022-03-31 | Baker | Georgia | 13007 | 534 | 14 |
2356715 | 2356715 | 2022-03-30 | Baker | Georgia | 13007 | 534 | 14 |
2353462 | 2353462 | 2022-03-29 | Baker | Georgia | 13007 | 534 | 14 |
2350210 | 2350210 | 2022-03-28 | Baker | Georgia | 13007 | 534 | 14 |
2346957 | 2346957 | 2022-03-27 | Baker | Georgia | 13007 | 534 | 14 |
2343704 | 2343704 | 2022-03-26 | Baker | Georgia | 13007 | 534 | 14 |
2340451 | 2340451 | 2022-03-25 | Baker | Georgia | 13007 | 534 | 14 |
2337198 | 2337198 | 2022-03-24 | Baker | Georgia | 13007 | 534 | 14 |
2333944 | 2333944 | 2022-03-23 | Baker | Georgia | 13007 | 534 | 14 |
2335237 | 2335237 | 2022-03-23 | Cherry | Nebraska | 31031 | 534 | 8 |
2330690 | 2330690 | 2022-03-22 | Baker | Georgia | 13007 | 534 | 14 |
2327438 | 2327438 | 2022-03-21 | Baker | Georgia | 13007 | 534 | 14 |
2324185 | 2324185 | 2022-03-20 | Baker | Georgia | 13007 | 534 | 14 |
2320931 | 2320931 | 2022-03-19 | Baker | Georgia | 13007 | 534 | 14 |
2317677 | 2317677 | 2022-03-18 | Baker | Georgia | 13007 | 534 | 14 |
2314424 | 2314424 | 2022-03-17 | Baker | Georgia | 13007 | 534 | 14 |
2311171 | 2311171 | 2022-03-16 | Baker | Georgia | 13007 | 534 | 14 |
2307918 | 2307918 | 2022-03-15 | Baker | Georgia | 13007 | 534 | 14 |
2304667 | 2304667 | 2022-03-14 | Baker | Georgia | 13007 | 534 | 14 |
2301415 | 2301415 | 2022-03-13 | Baker | Georgia | 13007 | 534 | 14 |
2298163 | 2298163 | 2022-03-12 | Baker | Georgia | 13007 | 534 | 14 |
2294911 | 2294911 | 2022-03-11 | Baker | Georgia | 13007 | 534 | 14 |
2291659 | 2291659 | 2022-03-10 | Baker | Georgia | 13007 | 534 | 14 |
2288407 | 2288407 | 2022-03-09 | Baker | Georgia | 13007 | 534 | 14 |
2285156 | 2285156 | 2022-03-08 | Baker | Georgia | 13007 | 534 | 14 |
2281904 | 2281904 | 2022-03-07 | Baker | Georgia | 13007 | 534 | 14 |
2212360 | 2212360 | 2022-02-13 | Maricao | Puerto Rico | 72093 | 534 | |
2192143 | 2192143 | 2022-02-07 | Cherry | Nebraska | 31031 | 534 | 8 |
2189025 | 2189025 | 2022-02-06 | De Baca | New Mexico | 35011 | 534 | 5 |
2185772 | 2185772 | 2022-02-05 | De Baca | New Mexico | 35011 | 534 | 5 |
2182520 | 2182520 | 2022-02-04 | De Baca | New Mexico | 35011 | 534 | 5 |
2154142 | 2154142 | 2022-01-26 | Hardeman | Texas | 48197 | 534 | 14 |
2150890 | 2150890 | 2022-01-25 | Hardeman | Texas | 48197 | 534 | 14 |
2148155 | 2148155 | 2022-01-24 | Niobrara | Wyoming | 56027 | 534 | 8 |
2110962 | 2110962 | 2022-01-13 | Mora | New Mexico | 35033 | 534 | 14 |
2097033 | 2097033 | 2022-01-09 | Cheyenne | Kansas | 20023 | 534 | 14 |
2093781 | 2093781 | 2022-01-08 | Cheyenne | Kansas | 20023 | 534 | 14 |
2090529 | 2090529 | 2022-01-07 | Cheyenne | Kansas | 20023 | 534 | 14 |
2085879 | 2085879 | 2022-01-05 | Kinney | Texas | 48271 | 534 | 10 |
2086207 | 2086207 | 2022-01-05 | San Juan | Washington | 53055 | 534 | 0 |
2079080 | 2079080 | 2022-01-03 | Bennett | South Dakota | 46007 | 534 | 9 |
2052204 | 2052204 | 2021-12-26 | Schuyler | Missouri | 29197 | 534 | 22 |
2048954 | 2048954 | 2021-12-25 | Schuyler | Missouri | 29197 | 534 | 22 |
2045704 | 2045704 | 2021-12-24 | Schuyler | Missouri | 29197 | 534 | 22 |
2042454 | 2042454 | 2021-12-23 | Schuyler | Missouri | 29197 | 534 | 22 |
2036879 | 2036879 | 2021-12-21 | Perkins | South Dakota | 46105 | 534 | 16 |
2021047 | 2021047 | 2021-12-16 | Bath | Virginia | 51017 | 534 | 15 |
2017796 | 2017796 | 2021-12-15 | Bath | Virginia | 51017 | 534 | 15 |
1996321 | 1996321 | 2021-12-09 | Osborne | Kansas | 20141 | 534 | 15 |
1993070 | 1993070 | 2021-12-08 | Osborne | Kansas | 20141 | 534 | 15 |
1988436 | 1988436 | 2021-12-06 | Shackelford | Texas | 48417 | 534 | 7 |
1967857 | 1967857 | 2021-11-30 | Stanton | Nebraska | 31167 | 534 | 11 |
1967865 | 1967865 | 2021-11-30 | Webster | Nebraska | 31181 | 534 | 9 |
1968284 | 1968284 | 2021-11-30 | Harper | Oklahoma | 40059 | 534 | 10 |
1965033 | 1965033 | 2021-11-29 | Harper | Oklahoma | 40059 | 534 | 10 |
1961781 | 1961781 | 2021-11-28 | Harper | Oklahoma | 40059 | 534 | 10 |
1958530 | 1958530 | 2021-11-27 | Harper | Oklahoma | 40059 | 534 | 10 |
1955279 | 1955279 | 2021-11-26 | Harper | Oklahoma | 40059 | 534 | 10 |
1952028 | 1952028 | 2021-11-25 | Harper | Oklahoma | 40059 | 534 | 10 |
1948777 | 1948777 | 2021-11-24 | Harper | Oklahoma | 40059 | 534 | 10 |
1943416 | 1943416 | 2021-11-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 534 | 0 |
1940166 | 1940166 | 2021-11-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 534 | 0 |
1936916 | 1936916 | 2021-11-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 534 | 0 |
1933666 | 1933666 | 2021-11-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 534 | 0 |
1930414 | 1930414 | 2021-11-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 534 | 0 |
1932370 | 1932370 | 2021-11-19 | Hettinger | North Dakota | 38041 | 534 | 6 |
1927183 | 1927183 | 2021-11-18 | Unknown | Alaska | 534 | 1 | |
1925018 | 1925018 | 2021-11-17 | Tensas | Louisiana | 22107 | 534 | 10 |
1926318 | 1926318 | 2021-11-17 | Clark | South Dakota | 46025 | 534 | 5 |
1921580 | 1921580 | 2021-11-16 | Sheridan | Kansas | 20179 | 534 | 15 |
1921769 | 1921769 | 2021-11-16 | Tensas | Louisiana | 22107 | 534 | 10 |
1918330 | 1918330 | 2021-11-15 | Sheridan | Kansas | 20179 | 534 | 15 |
1915073 | 1915073 | 2021-11-14 | Rush | Kansas | 20165 | 534 | 16 |
1911823 | 1911823 | 2021-11-13 | Rush | Kansas | 20165 | 534 | 16 |
1908574 | 1908574 | 2021-11-12 | Rush | Kansas | 20165 | 534 | 16 |
1898405 | 1898405 | 2021-11-09 | Adams | Idaho | 16003 | 534 | 12 |
1894682 | 1894682 | 2021-11-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 534 | 6 |
1875392 | 1875392 | 2021-11-02 | Phillips | Colorado | 8095 | 534 | 14 |
1876945 | 1876945 | 2021-11-02 | Union | New Mexico | 35059 | 534 | 12 |
1867367 | 1867367 | 2021-10-30 | Cavalier | North Dakota | 38019 | 534 | 5 |
1854079 | 1854079 | 2021-10-26 | Kimball | Nebraska | 31105 | 534 | 9 |
1854375 | 1854375 | 2021-10-26 | Eddy | North Dakota | 38027 | 534 | 6 |
1849700 | 1849700 | 2021-10-25 | Oneida | Idaho | 16071 | 534 | 8 |
1850830 | 1850830 | 2021-10-25 | Kimball | Nebraska | 31105 | 534 | 9 |
1847580 | 1847580 | 2021-10-24 | Kimball | Nebraska | 31105 | 534 | 9 |
1844330 | 1844330 | 2021-10-23 | Kimball | Nebraska | 31105 | 534 | 9 |
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);