ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
675 rows where cases = 427 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 50
- Texas 47
- Georgia 39
- North Dakota 39
- Virginia 36
- Puerto Rico 34
- South Dakota 34
- Missouri 30
- New Mexico 26
- Illinois 21
- Iowa 20
- Michigan 20
- Tennessee 19
- Indiana 16
- Kentucky 16
- Oklahoma 16
- Minnesota 15
- Louisiana 14
- Montana 14
- North Carolina 13
- Pennsylvania 13
- Nebraska 12
- Arkansas 11
- Mississippi 11
- Idaho 10
- West Virginia 10
- Alabama 8
- Colorado 8
- Washington 8
- Florida 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500566 | 2500566 | 2022-05-13 | Stanton | Kansas | 20187 | 427 | 8 |
2406127 | 2406127 | 2022-04-14 | Stanton | Kansas | 20187 | 427 | 8 |
2402389 | 2402389 | 2022-04-13 | Quitman | Georgia | 13239 | 427 | 4 |
2402871 | 2402871 | 2022-04-13 | Stanton | Kansas | 20187 | 427 | 8 |
2399134 | 2399134 | 2022-04-12 | Quitman | Georgia | 13239 | 427 | 4 |
2399617 | 2399617 | 2022-04-12 | Stanton | Kansas | 20187 | 427 | 8 |
2395879 | 2395879 | 2022-04-11 | Quitman | Georgia | 13239 | 427 | 4 |
2396361 | 2396361 | 2022-04-11 | Stanton | Kansas | 20187 | 427 | 8 |
2392623 | 2392623 | 2022-04-10 | Quitman | Georgia | 13239 | 427 | 4 |
2393106 | 2393106 | 2022-04-10 | Stanton | Kansas | 20187 | 427 | 8 |
2389367 | 2389367 | 2022-04-09 | Quitman | Georgia | 13239 | 427 | 4 |
2389850 | 2389850 | 2022-04-09 | Stanton | Kansas | 20187 | 427 | 8 |
2386112 | 2386112 | 2022-04-08 | Quitman | Georgia | 13239 | 427 | 4 |
2386594 | 2386594 | 2022-04-08 | Stanton | Kansas | 20187 | 427 | 8 |
2383340 | 2383340 | 2022-04-07 | Stanton | Kansas | 20187 | 427 | 8 |
2380085 | 2380085 | 2022-04-06 | Stanton | Kansas | 20187 | 427 | 8 |
2376830 | 2376830 | 2022-04-05 | Stanton | Kansas | 20187 | 427 | 8 |
2373578 | 2373578 | 2022-04-04 | Stanton | Kansas | 20187 | 427 | 8 |
2370325 | 2370325 | 2022-04-03 | Stanton | Kansas | 20187 | 427 | 8 |
2367072 | 2367072 | 2022-04-02 | Stanton | Kansas | 20187 | 427 | 8 |
2363819 | 2363819 | 2022-04-01 | Stanton | Kansas | 20187 | 427 | 8 |
2360565 | 2360565 | 2022-03-31 | Stanton | Kansas | 20187 | 427 | 8 |
2357311 | 2357311 | 2022-03-30 | Stanton | Kansas | 20187 | 427 | 8 |
2313468 | 2313468 | 2022-03-16 | Dickens | Texas | 48125 | 427 | 16 |
2310215 | 2310215 | 2022-03-15 | Dickens | Texas | 48125 | 427 | 16 |
2306962 | 2306962 | 2022-03-14 | Dickens | Texas | 48125 | 427 | 16 |
2303711 | 2303711 | 2022-03-13 | Dickens | Texas | 48125 | 427 | 16 |
2300459 | 2300459 | 2022-03-12 | Dickens | Texas | 48125 | 427 | 16 |
2297207 | 2297207 | 2022-03-11 | Dickens | Texas | 48125 | 427 | 16 |
2241267 | 2241267 | 2022-02-22 | Logan | North Dakota | 38047 | 427 | 12 |
2238016 | 2238016 | 2022-02-21 | Logan | North Dakota | 38047 | 427 | 12 |
2234765 | 2234765 | 2022-02-20 | Logan | North Dakota | 38047 | 427 | 12 |
2231514 | 2231514 | 2022-02-19 | Logan | North Dakota | 38047 | 427 | 12 |
2228263 | 2228263 | 2022-02-18 | Logan | North Dakota | 38047 | 427 | 12 |
2222641 | 2222641 | 2022-02-16 | Wayne | Utah | 49055 | 427 | 0 |
2217477 | 2217477 | 2022-02-15 | Wallace | Kansas | 20199 | 427 | 5 |
2214226 | 2214226 | 2022-02-14 | Wallace | Kansas | 20199 | 427 | 5 |
2210521 | 2210521 | 2022-02-13 | Webster | Georgia | 13307 | 427 | 7 |
2207268 | 2207268 | 2022-02-12 | Webster | Georgia | 13307 | 427 | 7 |
2208738 | 2208738 | 2022-02-12 | Burke | North Dakota | 38013 | 427 | 3 |
2204015 | 2204015 | 2022-02-11 | Webster | Georgia | 13307 | 427 | 7 |
2205485 | 2205485 | 2022-02-11 | Burke | North Dakota | 38013 | 427 | 3 |
2200762 | 2200762 | 2022-02-10 | Webster | Georgia | 13307 | 427 | 7 |
2196361 | 2196361 | 2022-02-08 | Briscoe | Texas | 48045 | 427 | 8 |
2193107 | 2193107 | 2022-02-07 | Briscoe | Texas | 48045 | 427 | 8 |
2189853 | 2189853 | 2022-02-06 | Briscoe | Texas | 48045 | 427 | 8 |
2147404 | 2147404 | 2022-01-24 | Haakon | South Dakota | 46055 | 427 | 11 |
2105432 | 2105432 | 2022-01-11 | Oldham | Texas | 48359 | 427 | 6 |
2097759 | 2097759 | 2022-01-09 | Granite | Montana | 30039 | 427 | 6 |
2094507 | 2094507 | 2022-01-08 | Granite | Montana | 30039 | 427 | 6 |
2091255 | 2091255 | 2022-01-07 | Granite | Montana | 30039 | 427 | 6 |
2088108 | 2088108 | 2022-01-06 | Perkins | Nebraska | 31135 | 427 | 12 |
2014128 | 2014128 | 2021-12-14 | Sanborn | South Dakota | 46111 | 427 | 3 |
2010850 | 2010850 | 2021-12-13 | Hand | South Dakota | 46059 | 427 | 8 |
2007599 | 2007599 | 2021-12-12 | Hand | South Dakota | 46059 | 427 | 8 |
2004348 | 2004348 | 2021-12-11 | Hand | South Dakota | 46059 | 427 | 8 |
2001097 | 2001097 | 2021-12-10 | Hand | South Dakota | 46059 | 427 | 8 |
1992424 | 1992424 | 2021-12-08 | Unknown | Delaware | 427 | 0 | |
1993936 | 1993936 | 2021-12-08 | Mora | New Mexico | 35033 | 427 | 12 |
1969610 | 1969610 | 2021-12-01 | Costilla | Colorado | 8023 | 427 | 13 |
1971039 | 1971039 | 2021-12-01 | Cherry | Nebraska | 31031 | 427 | 8 |
1939331 | 1939331 | 2021-11-21 | Faulk | South Dakota | 46049 | 427 | 15 |
1936081 | 1936081 | 2021-11-20 | Faulk | South Dakota | 46049 | 427 | 15 |
1932831 | 1932831 | 2021-11-19 | Faulk | South Dakota | 46049 | 427 | 15 |
1929146 | 1929146 | 2021-11-18 | Towner | North Dakota | 38095 | 427 | 11 |
1929580 | 1929580 | 2021-11-18 | Faulk | South Dakota | 46049 | 427 | 15 |
1925436 | 1925436 | 2021-11-17 | Scotland | Missouri | 29199 | 427 | 4 |
1921594 | 1921594 | 2021-11-16 | Woodson | Kansas | 20207 | 427 | 10 |
1922187 | 1922187 | 2021-11-16 | Scotland | Missouri | 29199 | 427 | 4 |
1918344 | 1918344 | 2021-11-15 | Woodson | Kansas | 20207 | 427 | 10 |
1918937 | 1918937 | 2021-11-15 | Scotland | Missouri | 29199 | 427 | 4 |
1915687 | 1915687 | 2021-11-14 | Scotland | Missouri | 29199 | 427 | 4 |
1916147 | 1916147 | 2021-11-14 | Towner | North Dakota | 38095 | 427 | 11 |
1912437 | 1912437 | 2021-11-13 | Scotland | Missouri | 29199 | 427 | 4 |
1912897 | 1912897 | 2021-11-13 | Towner | North Dakota | 38095 | 427 | 11 |
1909187 | 1909187 | 2021-11-12 | Scotland | Missouri | 29199 | 427 | 4 |
1905938 | 1905938 | 2021-11-11 | Scotland | Missouri | 29199 | 427 | 4 |
1902689 | 1902689 | 2021-11-10 | Scotland | Missouri | 29199 | 427 | 4 |
1899439 | 1899439 | 2021-11-09 | Scotland | Missouri | 29199 | 427 | 4 |
1880864 | 1880864 | 2021-11-03 | Potter | South Dakota | 46107 | 427 | 4 |
1876050 | 1876050 | 2021-11-02 | Logan | Kansas | 20109 | 427 | 9 |
1872171 | 1872171 | 2021-11-01 | Unknown | Delaware | 427 | 0 | |
1872801 | 1872801 | 2021-11-01 | Logan | Kansas | 20109 | 427 | 9 |
1854876 | 1854876 | 2021-10-26 | Stanley | South Dakota | 46117 | 427 | 3 |
1836377 | 1836377 | 2021-10-21 | Gilpin | Colorado | 8047 | 427 | 3 |
1830518 | 1830518 | 2021-10-19 | Cheyenne | Kansas | 20023 | 427 | 13 |
1832443 | 1832443 | 2021-10-19 | Shackelford | Texas | 48417 | 427 | 5 |
1827269 | 1827269 | 2021-10-18 | Cheyenne | Kansas | 20023 | 427 | 13 |
1825617 | 1825617 | 2021-10-17 | Marshall | South Dakota | 46091 | 427 | 6 |
1822368 | 1822368 | 2021-10-16 | Marshall | South Dakota | 46091 | 427 | 6 |
1819119 | 1819119 | 2021-10-15 | Marshall | South Dakota | 46091 | 427 | 6 |
1808735 | 1808735 | 2021-10-12 | Hamilton | New York | 36041 | 427 | 3 |
1793113 | 1793113 | 2021-10-07 | Hanson | South Dakota | 46061 | 427 | 4 |
1777134 | 1777134 | 2021-10-02 | Kimble | Texas | 48267 | 427 | 11 |
1769242 | 1769242 | 2021-09-30 | Lake of the Woods | Minnesota | 27077 | 427 | 4 |
1760594 | 1760594 | 2021-09-27 | Bennett | South Dakota | 46007 | 427 | 9 |
1757346 | 1757346 | 2021-09-26 | Bennett | South Dakota | 46007 | 427 | 9 |
1754098 | 1754098 | 2021-09-25 | Bennett | South Dakota | 46007 | 427 | 9 |
1750850 | 1750850 | 2021-09-24 | Bennett | South Dakota | 46007 | 427 | 9 |
1741976 | 1741976 | 2021-09-22 | Unknown | Alaska | 427 | 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);