ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
623 rows where cases = 435 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 55
- Texas 55
- Georgia 29
- Virginia 28
- Nebraska 27
- Kansas 21
- Kentucky 21
- Mississippi 20
- Missouri 20
- South Dakota 20
- Illinois 19
- Colorado 18
- Arkansas 17
- Puerto Rico 17
- Michigan 15
- Tennessee 15
- North Carolina 14
- Oklahoma 14
- Alabama 13
- Iowa 13
- Louisiana 13
- Ohio 13
- Minnesota 12
- Montana 12
- Oregon 11
- Pennsylvania 11
- Idaho 10
- South Carolina 9
- Utah 9
- Indiana 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501609 | 2501609 | 2022-05-13 | Logan | North Dakota | 38047 | 435 | 12 |
2452754 | 2452754 | 2022-04-28 | Logan | North Dakota | 38047 | 435 | 12 |
2449498 | 2449498 | 2022-04-27 | Logan | North Dakota | 38047 | 435 | 12 |
2446241 | 2446241 | 2022-04-26 | Logan | North Dakota | 38047 | 435 | 12 |
2442986 | 2442986 | 2022-04-25 | Logan | North Dakota | 38047 | 435 | 12 |
2439730 | 2439730 | 2022-04-24 | Logan | North Dakota | 38047 | 435 | 12 |
2436474 | 2436474 | 2022-04-23 | Logan | North Dakota | 38047 | 435 | 12 |
2433218 | 2433218 | 2022-04-22 | Logan | North Dakota | 38047 | 435 | 12 |
2429962 | 2429962 | 2022-04-21 | Logan | North Dakota | 38047 | 435 | 12 |
2426706 | 2426706 | 2022-04-20 | Logan | North Dakota | 38047 | 435 | 12 |
2423450 | 2423450 | 2022-04-19 | Logan | North Dakota | 38047 | 435 | 12 |
2420193 | 2420193 | 2022-04-18 | Logan | North Dakota | 38047 | 435 | 12 |
2416938 | 2416938 | 2022-04-17 | Logan | North Dakota | 38047 | 435 | 12 |
2413682 | 2413682 | 2022-04-16 | Logan | North Dakota | 38047 | 435 | 12 |
2410426 | 2410426 | 2022-04-15 | Logan | North Dakota | 38047 | 435 | 12 |
2407170 | 2407170 | 2022-04-14 | Logan | North Dakota | 38047 | 435 | 12 |
2403914 | 2403914 | 2022-04-13 | Logan | North Dakota | 38047 | 435 | 12 |
2400659 | 2400659 | 2022-04-12 | Logan | North Dakota | 38047 | 435 | 12 |
2397404 | 2397404 | 2022-04-11 | Logan | North Dakota | 38047 | 435 | 12 |
2394149 | 2394149 | 2022-04-10 | Logan | North Dakota | 38047 | 435 | 12 |
2390893 | 2390893 | 2022-04-09 | Logan | North Dakota | 38047 | 435 | 12 |
2387637 | 2387637 | 2022-04-08 | Logan | North Dakota | 38047 | 435 | 12 |
2384382 | 2384382 | 2022-04-07 | Logan | North Dakota | 38047 | 435 | 12 |
2381127 | 2381127 | 2022-04-06 | Logan | North Dakota | 38047 | 435 | 12 |
2377872 | 2377872 | 2022-04-05 | Logan | North Dakota | 38047 | 435 | 12 |
2374619 | 2374619 | 2022-04-04 | Logan | North Dakota | 38047 | 435 | 12 |
2371367 | 2371367 | 2022-04-03 | Logan | North Dakota | 38047 | 435 | 12 |
2368114 | 2368114 | 2022-04-02 | Logan | North Dakota | 38047 | 435 | 12 |
2364861 | 2364861 | 2022-04-01 | Logan | North Dakota | 38047 | 435 | 12 |
2361607 | 2361607 | 2022-03-31 | Logan | North Dakota | 38047 | 435 | 12 |
2358353 | 2358353 | 2022-03-30 | Logan | North Dakota | 38047 | 435 | 12 |
2355099 | 2355099 | 2022-03-29 | Logan | North Dakota | 38047 | 435 | 12 |
2351846 | 2351846 | 2022-03-28 | Logan | North Dakota | 38047 | 435 | 12 |
2348594 | 2348594 | 2022-03-27 | Logan | North Dakota | 38047 | 435 | 12 |
2345341 | 2345341 | 2022-03-26 | Logan | North Dakota | 38047 | 435 | 12 |
2342088 | 2342088 | 2022-03-25 | Logan | North Dakota | 38047 | 435 | 12 |
2258402 | 2258402 | 2022-02-27 | Wayne | Utah | 49055 | 435 | 0 |
2255151 | 2255151 | 2022-02-26 | Wayne | Utah | 49055 | 435 | 0 |
2251900 | 2251900 | 2022-02-25 | Wayne | Utah | 49055 | 435 | 0 |
2248649 | 2248649 | 2022-02-24 | Wayne | Utah | 49055 | 435 | 0 |
2238731 | 2238731 | 2022-02-21 | Irion | Texas | 48235 | 435 | 3 |
2210891 | 2210891 | 2022-02-13 | Comanche | Kansas | 20033 | 435 | 14 |
2207638 | 2207638 | 2022-02-12 | Comanche | Kansas | 20033 | 435 | 14 |
2209375 | 2209375 | 2022-02-12 | Briscoe | Texas | 48045 | 435 | 8 |
2204385 | 2204385 | 2022-02-11 | Comanche | Kansas | 20033 | 435 | 14 |
2177540 | 2177540 | 2022-02-03 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 435 | 5 |
2174287 | 2174287 | 2022-02-02 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 435 | 5 |
2171855 | 2171855 | 2022-02-01 | Comanche | Kansas | 20033 | 435 | 13 |
2168602 | 2168602 | 2022-01-31 | Comanche | Kansas | 20033 | 435 | 13 |
2170385 | 2170385 | 2022-01-31 | Edwards | Texas | 48137 | 435 | 10 |
2156694 | 2156694 | 2022-01-27 | Grant | North Dakota | 38037 | 435 | 11 |
2141194 | 2141194 | 2022-01-22 | Menard | Texas | 48327 | 435 | 12 |
2131153 | 2131153 | 2022-01-19 | Mellette | South Dakota | 46095 | 435 | 5 |
2101114 | 2101114 | 2022-01-10 | Perkins | Nebraska | 31135 | 435 | 12 |
2059608 | 2059608 | 2021-12-28 | Jackson | South Dakota | 46071 | 435 | 19 |
2055576 | 2055576 | 2021-12-27 | Hitchcock | Nebraska | 31087 | 435 | 5 |
2052326 | 2052326 | 2021-12-26 | Hitchcock | Nebraska | 31087 | 435 | 5 |
2049076 | 2049076 | 2021-12-25 | Hitchcock | Nebraska | 31087 | 435 | 5 |
2049737 | 2049737 | 2021-12-25 | Las Marias | Puerto Rico | 72083 | 435 | |
2045826 | 2045826 | 2021-12-24 | Hitchcock | Nebraska | 31087 | 435 | 5 |
2042576 | 2042576 | 2021-12-23 | Hitchcock | Nebraska | 31087 | 435 | 5 |
2020602 | 2020602 | 2021-12-16 | Hand | South Dakota | 46059 | 435 | 8 |
2015961 | 2015961 | 2021-12-15 | Robertson | Kentucky | 21201 | 435 | 16 |
2006808 | 2006808 | 2021-12-12 | Frontier | Nebraska | 31063 | 435 | 2 |
2003557 | 2003557 | 2021-12-11 | Frontier | Nebraska | 31063 | 435 | 2 |
2000307 | 2000307 | 2021-12-10 | Frontier | Nebraska | 31063 | 435 | 2 |
1995611 | 1995611 | 2021-12-09 | Costilla | Colorado | 8023 | 435 | 13 |
1992360 | 1992360 | 2021-12-08 | Costilla | Colorado | 8023 | 435 | 13 |
1989109 | 1989109 | 2021-12-07 | Costilla | Colorado | 8023 | 435 | 13 |
1987354 | 1987354 | 2021-12-06 | Sherman | Nebraska | 31163 | 435 | 4 |
1988271 | 1988271 | 2021-12-06 | Collingsworth | Texas | 48087 | 435 | 11 |
1982609 | 1982609 | 2021-12-05 | Costilla | Colorado | 8023 | 435 | 13 |
1985021 | 1985021 | 2021-12-05 | Collingsworth | Texas | 48087 | 435 | 11 |
1979359 | 1979359 | 2021-12-04 | Costilla | Colorado | 8023 | 435 | 13 |
1981771 | 1981771 | 2021-12-04 | Collingsworth | Texas | 48087 | 435 | 11 |
1976109 | 1976109 | 2021-12-03 | Costilla | Colorado | 8023 | 435 | 13 |
1975690 | 1975690 | 2021-12-02 | San Juan | Washington | 53055 | 435 | 0 |
1962087 | 1962087 | 2021-11-28 | Faulk | South Dakota | 46049 | 435 | 15 |
1958836 | 1958836 | 2021-11-27 | Faulk | South Dakota | 46049 | 435 | 15 |
1955585 | 1955585 | 2021-11-26 | Faulk | South Dakota | 46049 | 435 | 15 |
1952334 | 1952334 | 2021-11-25 | Faulk | South Dakota | 46049 | 435 | 15 |
1948639 | 1948639 | 2021-11-24 | Renville | North Dakota | 38075 | 435 | 14 |
1949083 | 1949083 | 2021-11-24 | Faulk | South Dakota | 46049 | 435 | 15 |
1927178 | 1927178 | 2021-11-18 | Petersburg Borough | Alaska | 2195 | 435 | 2 |
1900363 | 1900363 | 2021-11-09 | Potter | South Dakota | 46107 | 435 | 4 |
1882564 | 1882564 | 2021-11-04 | Osborne | Kansas | 20141 | 435 | 14 |
1879315 | 1879315 | 2021-11-03 | Osborne | Kansas | 20141 | 435 | 14 |
1835351 | 1835351 | 2021-10-20 | Hanson | South Dakota | 46061 | 435 | 4 |
1835364 | 1835364 | 2021-10-20 | Marshall | South Dakota | 46091 | 435 | 6 |
1831477 | 1831477 | 2021-10-19 | Hamilton | New York | 36041 | 435 | 3 |
1818178 | 1818178 | 2021-10-15 | Mercer | Missouri | 29129 | 435 | 3 |
1792652 | 1792652 | 2021-10-07 | McIntosh | North Dakota | 38051 | 435 | 8 |
1785490 | 1785490 | 2021-10-05 | Lake of the Woods | Minnesota | 27077 | 435 | 4 |
1750745 | 1750745 | 2021-09-24 | Guanica | Puerto Rico | 72055 | 435 | |
1715600 | 1715600 | 2021-09-13 | Craig | Virginia | 51045 | 435 | 6 |
1699947 | 1699947 | 2021-09-09 | Phillips | Colorado | 8095 | 435 | 13 |
1698050 | 1698050 | 2021-09-08 | Mineral | Montana | 30061 | 435 | 9 |
1698068 | 1698068 | 2021-09-08 | Sweet Grass | Montana | 30097 | 435 | 7 |
1699165 | 1699165 | 2021-09-08 | Kinney | Texas | 48271 | 435 | 8 |
1695337 | 1695337 | 2021-09-07 | Harper | Oklahoma | 40059 | 435 | 8 |
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);