ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
527 rows where cases = 683 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 49
- South Dakota 39
- Illinois 28
- Nebraska 28
- Georgia 27
- Kentucky 23
- West Virginia 23
- Iowa 22
- Oklahoma 22
- Missouri 20
- Virginia 20
- Puerto Rico 19
- Colorado 14
- Arkansas 13
- Indiana 13
- Idaho 12
- North Carolina 12
- Wisconsin 12
- Minnesota 11
- Kansas 10
- Alabama 9
- North Dakota 9
- Mississippi 8
- Alaska 7
- Tennessee 6
- Utah 6
- Washington 6
- Maine 5
- Maryland 5
- Montana 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500549 | 2500549 | 2022-05-13 | Rawlins | Kansas | 20153 | 683 | 9 |
2492323 | 2492323 | 2022-05-10 | Perkins | South Dakota | 46105 | 683 | 18 |
2489065 | 2489065 | 2022-05-09 | Perkins | South Dakota | 46105 | 683 | 18 |
2485808 | 2485808 | 2022-05-08 | Perkins | South Dakota | 46105 | 683 | 18 |
2482550 | 2482550 | 2022-05-07 | Perkins | South Dakota | 46105 | 683 | 18 |
2479292 | 2479292 | 2022-05-06 | Perkins | South Dakota | 46105 | 683 | 18 |
2476034 | 2476034 | 2022-05-05 | Perkins | South Dakota | 46105 | 683 | 18 |
2472777 | 2472777 | 2022-05-04 | Perkins | South Dakota | 46105 | 683 | 18 |
2469521 | 2469521 | 2022-05-03 | Perkins | South Dakota | 46105 | 683 | 18 |
2466265 | 2466265 | 2022-05-02 | Perkins | South Dakota | 46105 | 683 | 18 |
2463010 | 2463010 | 2022-05-01 | Perkins | South Dakota | 46105 | 683 | 18 |
2459754 | 2459754 | 2022-04-30 | Perkins | South Dakota | 46105 | 683 | 18 |
2456498 | 2456498 | 2022-04-29 | Perkins | South Dakota | 46105 | 683 | 18 |
2453242 | 2453242 | 2022-04-28 | Perkins | South Dakota | 46105 | 683 | 18 |
2449986 | 2449986 | 2022-04-27 | Perkins | South Dakota | 46105 | 683 | 18 |
2379351 | 2379351 | 2022-04-06 | Costilla | Colorado | 8023 | 683 | 16 |
2376097 | 2376097 | 2022-04-05 | Costilla | Colorado | 8023 | 683 | 16 |
2372845 | 2372845 | 2022-04-04 | Costilla | Colorado | 8023 | 683 | 16 |
2335144 | 2335144 | 2022-03-23 | Scotland | Missouri | 29199 | 683 | 18 |
2291350 | 2291350 | 2022-03-10 | Petersburg Borough | Alaska | 2195 | 683 | 2 |
2288098 | 2288098 | 2022-03-09 | Petersburg Borough | Alaska | 2195 | 683 | 2 |
2284846 | 2284846 | 2022-03-08 | Petersburg Borough | Alaska | 2195 | 683 | 2 |
2281594 | 2281594 | 2022-03-07 | Petersburg Borough | Alaska | 2195 | 683 | 2 |
2270092 | 2270092 | 2022-03-03 | Scotland | Missouri | 29199 | 683 | 18 |
2266839 | 2266839 | 2022-03-02 | Scotland | Missouri | 29199 | 683 | 18 |
2247304 | 2247304 | 2022-02-24 | Mercer | Missouri | 29129 | 683 | 12 |
2244053 | 2244053 | 2022-02-23 | Mercer | Missouri | 29129 | 683 | 12 |
2212497 | 2212497 | 2022-02-13 | Potter | South Dakota | 46107 | 683 | 7 |
2209244 | 2209244 | 2022-02-12 | Potter | South Dakota | 46107 | 683 | 7 |
2205991 | 2205991 | 2022-02-11 | Potter | South Dakota | 46107 | 683 | 7 |
2202738 | 2202738 | 2022-02-10 | Potter | South Dakota | 46107 | 683 | 7 |
2195303 | 2195303 | 2022-02-08 | Schuyler | Missouri | 29197 | 683 | 24 |
2179209 | 2179209 | 2022-02-03 | Webster | Nebraska | 31181 | 683 | 9 |
2175949 | 2175949 | 2022-02-02 | Stanton | Nebraska | 31167 | 683 | 11 |
2169710 | 2169710 | 2022-01-31 | Emmons | North Dakota | 38029 | 683 | 16 |
2154179 | 2154179 | 2022-01-26 | Kinney | Texas | 48271 | 683 | 10 |
2133921 | 2133921 | 2022-01-20 | Hettinger | North Dakota | 38041 | 683 | 7 |
2099493 | 2099493 | 2022-01-10 | Calhoun | Arkansas | 5013 | 683 | 9 |
2078092 | 2078092 | 2022-01-03 | Sharkey | Mississippi | 28125 | 683 | 21 |
2072123 | 2072123 | 2022-01-01 | Bowman | North Dakota | 38011 | 683 | 9 |
2056909 | 2056909 | 2021-12-27 | Surry | Virginia | 51181 | 683 | 13 |
2019515 | 2019515 | 2021-12-16 | Unknown | Minnesota | 683 | 124 | |
1996760 | 1996760 | 2021-12-09 | Unknown | Minnesota | 683 | 124 | |
1995061 | 1995061 | 2021-12-08 | Craig | Virginia | 51045 | 683 | 10 |
1962266 | 1962266 | 2021-11-28 | Coke | Texas | 48081 | 683 | 18 |
1959015 | 1959015 | 2021-11-27 | Coke | Texas | 48081 | 683 | 18 |
1955764 | 1955764 | 2021-11-26 | Coke | Texas | 48081 | 683 | 18 |
1952513 | 1952513 | 2021-11-25 | Coke | Texas | 48081 | 683 | 18 |
1949262 | 1949262 | 2021-11-24 | Coke | Texas | 48081 | 683 | 18 |
1946011 | 1946011 | 2021-11-23 | Coke | Texas | 48081 | 683 | 18 |
1942760 | 1942760 | 2021-11-22 | Coke | Texas | 48081 | 683 | 18 |
1939510 | 1939510 | 2021-11-21 | Coke | Texas | 48081 | 683 | 18 |
1936260 | 1936260 | 2021-11-20 | Coke | Texas | 48081 | 683 | 18 |
1933010 | 1933010 | 2021-11-19 | Coke | Texas | 48081 | 683 | 18 |
1929151 | 1929151 | 2021-11-18 | Wells | North Dakota | 38103 | 683 | 9 |
1929759 | 1929759 | 2021-11-18 | Coke | Texas | 48081 | 683 | 18 |
1923766 | 1923766 | 2021-11-16 | Florence | Wisconsin | 55037 | 683 | 14 |
1903984 | 1903984 | 2021-11-10 | Garfield | Utah | 49017 | 683 | 12 |
1900734 | 1900734 | 2021-11-09 | Garfield | Utah | 49017 | 683 | 12 |
1883625 | 1883625 | 2021-11-04 | LaMoure | North Dakota | 38045 | 683 | 17 |
1880825 | 1880825 | 2021-11-03 | Corson | South Dakota | 46031 | 683 | 13 |
1868907 | 1868907 | 2021-10-31 | Washington | Colorado | 8121 | 683 | 19 |
1865658 | 1865658 | 2021-10-30 | Washington | Colorado | 8121 | 683 | 19 |
1862409 | 1862409 | 2021-10-29 | Washington | Colorado | 8121 | 683 | 19 |
1862692 | 1862692 | 2021-10-29 | Lincoln | Idaho | 16063 | 683 | 12 |
1853361 | 1853361 | 2021-10-26 | Ballard | Kentucky | 21007 | 683 | 20 |
1855304 | 1855304 | 2021-10-26 | Charles City | Virginia | 51036 | 683 | 20 |
1850112 | 1850112 | 2021-10-25 | Ballard | Kentucky | 21007 | 683 | 19 |
1835119 | 1835119 | 2021-10-20 | Wallowa | Oregon | 41063 | 683 | 12 |
1828379 | 1828379 | 2021-10-18 | Dunn | North Dakota | 38025 | 683 | 7 |
1825130 | 1825130 | 2021-10-17 | Dunn | North Dakota | 38025 | 683 | 7 |
1813974 | 1813974 | 2021-10-14 | Calhoun | Illinois | 17013 | 683 | 5 |
1805317 | 1805317 | 2021-10-11 | Fillmore | Nebraska | 31059 | 683 | 13 |
1802068 | 1802068 | 2021-10-10 | Fillmore | Nebraska | 31059 | 683 | 13 |
1798819 | 1798819 | 2021-10-09 | Fillmore | Nebraska | 31059 | 683 | 13 |
1795570 | 1795570 | 2021-10-08 | Fillmore | Nebraska | 31059 | 683 | 13 |
1796600 | 1796600 | 2021-10-08 | Hemphill | Texas | 48211 | 683 | 3 |
1793351 | 1793351 | 2021-10-07 | Hemphill | Texas | 48211 | 683 | 3 |
1789123 | 1789123 | 2021-10-06 | Sheridan | Nebraska | 31161 | 683 | 23 |
1789860 | 1789860 | 2021-10-06 | Gregory | South Dakota | 46053 | 683 | 30 |
1790081 | 1790081 | 2021-10-06 | Garza | Texas | 48169 | 683 | 22 |
1784761 | 1784761 | 2021-10-05 | Henderson | Illinois | 17071 | 683 | 23 |
1785954 | 1785954 | 2021-10-05 | Los Alamos | New Mexico | 35028 | 683 | 9 |
1786833 | 1786833 | 2021-10-05 | Garza | Texas | 48169 | 683 | 22 |
1781512 | 1781512 | 2021-10-04 | Henderson | Illinois | 17071 | 683 | 23 |
1782648 | 1782648 | 2021-10-04 | Lander | Nevada | 32015 | 683 | 14 |
1778262 | 1778262 | 2021-10-03 | Henderson | Illinois | 17071 | 683 | 23 |
1775012 | 1775012 | 2021-10-02 | Henderson | Illinois | 17071 | 683 | 23 |
1771762 | 1771762 | 2021-10-01 | Henderson | Illinois | 17071 | 683 | 23 |
1766278 | 1766278 | 2021-09-29 | Pondera | Montana | 30073 | 683 | 4 |
1762746 | 1762746 | 2021-09-28 | Lincoln | Minnesota | 27081 | 683 | 4 |
1745037 | 1745037 | 2021-09-22 | Wirt | West Virginia | 54105 | 683 | 8 |
1731560 | 1731560 | 2021-09-18 | Concho | Texas | 48095 | 683 | 9 |
1724755 | 1724755 | 2021-09-16 | Hormigueros | Puerto Rico | 72067 | 683 | |
1721506 | 1721506 | 2021-09-15 | Hormigueros | Puerto Rico | 72067 | 683 | |
1717684 | 1717684 | 2021-09-14 | Unknown | New Hampshire | 683 | 1 | |
1698909 | 1698909 | 2021-09-08 | Lyman | South Dakota | 46085 | 683 | 11 |
1695661 | 1695661 | 2021-09-07 | Lyman | South Dakota | 46085 | 683 | 11 |
1695814 | 1695814 | 2021-09-07 | Carson | Texas | 48065 | 683 | 17 |
1692566 | 1692566 | 2021-09-06 | Carson | Texas | 48065 | 683 | 17 |
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);