ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
524 rows where cases = 686 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 68
- Oklahoma 33
- Kansas 30
- North Dakota 26
- Kentucky 24
- Georgia 23
- Illinois 22
- Nebraska 22
- Virginia 19
- Missouri 18
- Iowa 16
- Puerto Rico 16
- South Dakota 16
- Colorado 15
- Tennessee 13
- North Carolina 11
- Florida 10
- Minnesota 10
- Wisconsin 10
- Indiana 9
- Oregon 9
- Washington 9
- Idaho 7
- Mississippi 7
- Montana 7
- West Virginia 7
- Alabama 6
- Alaska 6
- Arkansas 6
- Louisiana 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473095 | 2473095 | 2022-05-04 | Shackelford | Texas | 48417 | 686 | 12 |
2452756 | 2452756 | 2022-04-28 | McIntosh | North Dakota | 38051 | 686 | 9 |
2449500 | 2449500 | 2022-04-27 | McIntosh | North Dakota | 38051 | 686 | 9 |
2446243 | 2446243 | 2022-04-26 | McIntosh | North Dakota | 38051 | 686 | 9 |
2442988 | 2442988 | 2022-04-25 | McIntosh | North Dakota | 38051 | 686 | 9 |
2439732 | 2439732 | 2022-04-24 | McIntosh | North Dakota | 38051 | 686 | 9 |
2436476 | 2436476 | 2022-04-23 | McIntosh | North Dakota | 38051 | 686 | 9 |
2433220 | 2433220 | 2022-04-22 | McIntosh | North Dakota | 38051 | 686 | 9 |
2429964 | 2429964 | 2022-04-21 | McIntosh | North Dakota | 38051 | 686 | 9 |
2426708 | 2426708 | 2022-04-20 | McIntosh | North Dakota | 38051 | 686 | 9 |
2423452 | 2423452 | 2022-04-19 | McIntosh | North Dakota | 38051 | 686 | 9 |
2420195 | 2420195 | 2022-04-18 | McIntosh | North Dakota | 38051 | 686 | 9 |
2416940 | 2416940 | 2022-04-17 | McIntosh | North Dakota | 38051 | 686 | 9 |
2413684 | 2413684 | 2022-04-16 | McIntosh | North Dakota | 38051 | 686 | 9 |
2410428 | 2410428 | 2022-04-15 | McIntosh | North Dakota | 38051 | 686 | 9 |
2392372 | 2392372 | 2022-04-10 | Costilla | Colorado | 8023 | 686 | 16 |
2389116 | 2389116 | 2022-04-09 | Costilla | Colorado | 8023 | 686 | 16 |
2385861 | 2385861 | 2022-04-08 | Costilla | Colorado | 8023 | 686 | 16 |
2381858 | 2381858 | 2022-04-06 | Kimble | Texas | 48267 | 686 | 15 |
2378603 | 2378603 | 2022-04-05 | Kimble | Texas | 48267 | 686 | 15 |
2375349 | 2375349 | 2022-04-04 | Kimble | Texas | 48267 | 686 | 15 |
2372097 | 2372097 | 2022-04-03 | Kimble | Texas | 48267 | 686 | 15 |
2368844 | 2368844 | 2022-04-02 | Kimble | Texas | 48267 | 686 | 15 |
2365591 | 2365591 | 2022-04-01 | Kimble | Texas | 48267 | 686 | 15 |
2362338 | 2362338 | 2022-03-31 | Kimble | Texas | 48267 | 686 | 15 |
2359084 | 2359084 | 2022-03-30 | Kimble | Texas | 48267 | 686 | 15 |
2355830 | 2355830 | 2022-03-29 | Kimble | Texas | 48267 | 686 | 15 |
2352577 | 2352577 | 2022-03-28 | Kimble | Texas | 48267 | 686 | 15 |
2349325 | 2349325 | 2022-03-27 | Kimble | Texas | 48267 | 686 | 15 |
2346072 | 2346072 | 2022-03-26 | Kimble | Texas | 48267 | 686 | 15 |
2323876 | 2323876 | 2022-03-20 | Petersburg Borough | Alaska | 2195 | 686 | 2 |
2320622 | 2320622 | 2022-03-19 | Petersburg Borough | Alaska | 2195 | 686 | 2 |
2317368 | 2317368 | 2022-03-18 | Petersburg Borough | Alaska | 2195 | 686 | 2 |
2264664 | 2264664 | 2022-03-01 | Collingsworth | Texas | 48087 | 686 | 16 |
2261414 | 2261414 | 2022-02-28 | Collingsworth | Texas | 48087 | 686 | 16 |
2257057 | 2257057 | 2022-02-27 | Mercer | Missouri | 29129 | 686 | 12 |
2258163 | 2258163 | 2022-02-27 | Collingsworth | Texas | 48087 | 686 | 16 |
2253806 | 2253806 | 2022-02-26 | Mercer | Missouri | 29129 | 686 | 12 |
2254912 | 2254912 | 2022-02-26 | Collingsworth | Texas | 48087 | 686 | 16 |
2250555 | 2250555 | 2022-02-25 | Mercer | Missouri | 29129 | 686 | 12 |
2188958 | 2188958 | 2022-02-06 | Stanton | Nebraska | 31167 | 686 | 11 |
2185705 | 2185705 | 2022-02-05 | Stanton | Nebraska | 31167 | 686 | 11 |
2182453 | 2182453 | 2022-02-04 | Stanton | Nebraska | 31167 | 686 | 11 |
2146318 | 2146318 | 2022-01-24 | Traverse | Minnesota | 27155 | 686 | 8 |
2134359 | 2134359 | 2022-01-20 | Aurora | South Dakota | 46003 | 686 | 17 |
2128207 | 2128207 | 2022-01-18 | Real | Texas | 48385 | 686 | 22 |
2125226 | 2125226 | 2022-01-17 | San Juan | Washington | 53055 | 686 | 0 |
2121974 | 2121974 | 2022-01-16 | San Juan | Washington | 53055 | 686 | 0 |
2118722 | 2118722 | 2022-01-15 | San Juan | Washington | 53055 | 686 | 0 |
2115470 | 2115470 | 2022-01-14 | San Juan | Washington | 53055 | 686 | 0 |
2082082 | 2082082 | 2022-01-04 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2078830 | 2078830 | 2022-01-03 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2075579 | 2075579 | 2022-01-02 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2076092 | 2076092 | 2022-01-02 | Haskell | Texas | 48207 | 686 | 37 |
2072328 | 2072328 | 2022-01-01 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2072841 | 2072841 | 2022-01-01 | Haskell | Texas | 48207 | 686 | 37 |
2069077 | 2069077 | 2021-12-31 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2069590 | 2069590 | 2021-12-31 | Haskell | Texas | 48207 | 686 | 37 |
2065826 | 2065826 | 2021-12-30 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2066339 | 2066339 | 2021-12-30 | Haskell | Texas | 48207 | 686 | 37 |
2062576 | 2062576 | 2021-12-29 | Roger Mills | Oklahoma | 40129 | 686 | 12 |
2060158 | 2060158 | 2021-12-28 | Surry | Virginia | 51181 | 686 | 13 |
2055268 | 2055268 | 2021-12-27 | Unknown | Minnesota | 686 | 134 | |
2056201 | 2056201 | 2021-12-27 | Arroyo | Puerto Rico | 72015 | 686 | |
2033483 | 2033483 | 2021-12-20 | Jayuya | Puerto Rico | 72073 | 686 | |
2026963 | 2026963 | 2021-12-18 | Ceiba | Puerto Rico | 72037 | 686 | |
2017545 | 2017545 | 2021-12-15 | Delta | Texas | 48119 | 686 | 22 |
2014094 | 2014094 | 2021-12-14 | Edmunds | South Dakota | 46045 | 686 | 14 |
2011315 | 2011315 | 2021-12-13 | Craig | Virginia | 51045 | 686 | 10 |
1926810 | 1926810 | 2021-11-17 | Falls Church city | Virginia | 51610 | 686 | 14 |
1884074 | 1884074 | 2021-11-04 | Corson | South Dakota | 46031 | 686 | 13 |
1869190 | 1869190 | 2021-10-31 | Lincoln | Idaho | 16063 | 686 | 12 |
1865941 | 1865941 | 2021-10-30 | Lincoln | Idaho | 16063 | 686 | 12 |
1859154 | 1859154 | 2021-10-28 | Saguache | Colorado | 8109 | 686 | 8 |
1861802 | 1861802 | 2021-10-28 | Charles City | Virginia | 51036 | 686 | 20 |
1856610 | 1856610 | 2021-10-27 | Ballard | Kentucky | 21007 | 686 | 20 |
1857967 | 1857967 | 2021-10-27 | Guayanilla | Puerto Rico | 72059 | 686 | |
1852917 | 1852917 | 2021-10-26 | Bear Lake | Idaho | 16007 | 686 | 13 |
1848117 | 1848117 | 2021-10-24 | Wallowa | Oregon | 41063 | 686 | 12 |
1844867 | 1844867 | 2021-10-23 | Wallowa | Oregon | 41063 | 686 | 12 |
1841617 | 1841617 | 2021-10-22 | Wallowa | Oregon | 41063 | 686 | 12 |
1838368 | 1838368 | 2021-10-21 | Wallowa | Oregon | 41063 | 686 | 12 |
1831282 | 1831282 | 2021-10-19 | Antelope | Nebraska | 31003 | 686 | 9 |
1823720 | 1823720 | 2021-10-17 | Calhoun | Illinois | 17013 | 686 | 5 |
1820471 | 1820471 | 2021-10-16 | Calhoun | Illinois | 17013 | 686 | 5 |
1817222 | 1817222 | 2021-10-15 | Calhoun | Illinois | 17013 | 686 | 5 |
1816095 | 1816095 | 2021-10-14 | Hemphill | Texas | 48211 | 686 | 3 |
1809045 | 1809045 | 2021-10-12 | Grant | Oklahoma | 40053 | 686 | 7 |
1805336 | 1805336 | 2021-10-11 | Johnson | Nebraska | 31097 | 686 | 10 |
1805795 | 1805795 | 2021-10-11 | Grant | Oklahoma | 40053 | 686 | 7 |
1802087 | 1802087 | 2021-10-10 | Johnson | Nebraska | 31097 | 686 | 10 |
1802545 | 1802545 | 2021-10-10 | Grant | Oklahoma | 40053 | 686 | 7 |
1798838 | 1798838 | 2021-10-09 | Johnson | Nebraska | 31097 | 686 | 10 |
1799296 | 1799296 | 2021-10-09 | Grant | Oklahoma | 40053 | 686 | 7 |
1795589 | 1795589 | 2021-10-08 | Johnson | Nebraska | 31097 | 686 | 10 |
1796047 | 1796047 | 2021-10-08 | Grant | Oklahoma | 40053 | 686 | 7 |
1792340 | 1792340 | 2021-10-07 | Johnson | Nebraska | 31097 | 686 | 10 |
1792798 | 1792798 | 2021-10-07 | Grant | Oklahoma | 40053 | 686 | 7 |
1788010 | 1788010 | 2021-10-06 | Henderson | Illinois | 17071 | 686 | 23 |
1789202 | 1789202 | 2021-10-06 | Los Alamos | New Mexico | 35028 | 686 | 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);