ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
582 rows where cases = 473 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 66
- South Dakota 40
- Kansas 32
- Missouri 31
- Virginia 26
- Puerto Rico 25
- Colorado 24
- Illinois 24
- Oklahoma 21
- Kentucky 19
- Idaho 17
- Georgia 16
- North Carolina 16
- Michigan 15
- Nebraska 15
- North Dakota 15
- Iowa 13
- Arkansas 12
- Minnesota 12
- Oregon 12
- Indiana 11
- Pennsylvania 11
- Wisconsin 11
- Alabama 9
- Florida 9
- Ohio 8
- West Virginia 8
- Mississippi 7
- South Carolina 7
- Tennessee 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264017 | 2264017 | 2022-03-01 | Golden Valley | North Dakota | 38033 | 473 | 4 |
2176986 | 2176986 | 2022-02-02 | Menard | Texas | 48327 | 473 | 12 |
2173574 | 2173574 | 2022-02-01 | Armstrong | Texas | 48011 | 473 | 8 |
2170322 | 2170322 | 2022-01-31 | Armstrong | Texas | 48011 | 473 | 8 |
2155579 | 2155579 | 2022-01-27 | Clark | Kansas | 20025 | 473 | 7 |
2152326 | 2152326 | 2022-01-26 | Clark | Kansas | 20025 | 473 | 7 |
2150330 | 2150330 | 2022-01-25 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2147078 | 2147078 | 2022-01-24 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2143824 | 2143824 | 2022-01-23 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2144340 | 2144340 | 2022-01-23 | Culberson | Texas | 48109 | 473 | 13 |
2140569 | 2140569 | 2022-01-22 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2137313 | 2137313 | 2022-01-21 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2132289 | 2132289 | 2022-01-20 | Baker | Georgia | 13007 | 473 | 14 |
2133529 | 2133529 | 2022-01-20 | Granite | Montana | 30039 | 473 | 6 |
2134059 | 2134059 | 2022-01-20 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2130344 | 2130344 | 2022-01-19 | Frontier | Nebraska | 31063 | 473 | 2 |
2130807 | 2130807 | 2022-01-19 | Cimarron | Oklahoma | 40025 | 473 | 0 |
2107921 | 2107921 | 2022-01-12 | Renville | North Dakota | 38075 | 473 | 15 |
2105328 | 2105328 | 2022-01-11 | Fisher | Texas | 48151 | 473 | 20 |
2098612 | 2098612 | 2022-01-09 | Faulk | South Dakota | 46049 | 473 | 16 |
2095360 | 2095360 | 2022-01-08 | Faulk | South Dakota | 46049 | 473 | 16 |
2092108 | 2092108 | 2022-01-07 | Faulk | South Dakota | 46049 | 473 | 16 |
2088395 | 2088395 | 2022-01-06 | Griggs | North Dakota | 38039 | 473 | 2 |
2084870 | 2084870 | 2022-01-05 | Sherman | Nebraska | 31163 | 473 | 4 |
2080771 | 2080771 | 2022-01-04 | Chase | Kansas | 20017 | 473 | 6 |
2077519 | 2077519 | 2022-01-03 | Chase | Kansas | 20017 | 473 | 6 |
2078620 | 2078620 | 2022-01-03 | Adams | North Dakota | 38001 | 473 | 8 |
2075369 | 2075369 | 2022-01-02 | Adams | North Dakota | 38001 | 473 | 8 |
2072118 | 2072118 | 2022-01-01 | Adams | North Dakota | 38001 | 473 | 8 |
2059164 | 2059164 | 2021-12-28 | Towner | North Dakota | 38095 | 473 | 11 |
2037136 | 2037136 | 2021-12-21 | Lipscomb | Texas | 48295 | 473 | 12 |
1997884 | 1997884 | 2021-12-09 | Ziebach | South Dakota | 46137 | 473 | 10 |
1994633 | 1994633 | 2021-12-08 | Ziebach | South Dakota | 46137 | 473 | 10 |
1988095 | 1988095 | 2021-12-06 | Hanson | South Dakota | 46061 | 473 | 5 |
1984845 | 1984845 | 2021-12-05 | Hanson | South Dakota | 46061 | 473 | 5 |
1981595 | 1981595 | 2021-12-04 | Hanson | South Dakota | 46061 | 473 | 5 |
1978345 | 1978345 | 2021-12-03 | Hanson | South Dakota | 46061 | 473 | 5 |
1973591 | 1973591 | 2021-12-02 | Smith | Kansas | 20183 | 473 | 3 |
1970341 | 1970341 | 2021-12-01 | Smith | Kansas | 20183 | 473 | 3 |
1967091 | 1967091 | 2021-11-30 | Smith | Kansas | 20183 | 473 | 3 |
1963839 | 1963839 | 2021-11-29 | Smith | Kansas | 20183 | 473 | 3 |
1910259 | 1910259 | 2021-11-12 | Cochran | Texas | 48079 | 473 | 18 |
1907010 | 1907010 | 2021-11-11 | Cochran | Texas | 48079 | 473 | 18 |
1881866 | 1881866 | 2021-11-04 | Gilpin | Colorado | 8047 | 473 | 3 |
1871066 | 1871066 | 2021-10-31 | Bennett | South Dakota | 46007 | 473 | 9 |
1867817 | 1867817 | 2021-10-30 | Bennett | South Dakota | 46007 | 473 | 9 |
1864568 | 1864568 | 2021-10-29 | Bennett | South Dakota | 46007 | 473 | 9 |
1841383 | 1841383 | 2021-10-22 | Hettinger | North Dakota | 38041 | 473 | 5 |
1818890 | 1818890 | 2021-10-15 | Cameron | Pennsylvania | 42023 | 473 | 10 |
1810203 | 1810203 | 2021-10-13 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 473 | 5 |
1797678 | 1797678 | 2021-10-09 | Adams | Idaho | 16003 | 473 | 8 |
1787966 | 1787966 | 2021-10-06 | Oneida | Idaho | 16071 | 473 | 6 |
1785110 | 1785110 | 2021-10-05 | Sheridan | Kansas | 20179 | 473 | 14 |
1785529 | 1785529 | 2021-10-05 | Traverse | Minnesota | 27155 | 473 | 5 |
1781861 | 1781861 | 2021-10-04 | Sheridan | Kansas | 20179 | 473 | 14 |
1778611 | 1778611 | 2021-10-03 | Sheridan | Kansas | 20179 | 473 | 14 |
1775361 | 1775361 | 2021-10-02 | Sheridan | Kansas | 20179 | 473 | 14 |
1772111 | 1772111 | 2021-10-01 | Sheridan | Kansas | 20179 | 473 | 14 |
1768862 | 1768862 | 2021-09-30 | Sheridan | Kansas | 20179 | 473 | 14 |
1770832 | 1770832 | 2021-09-30 | Craig | Virginia | 51045 | 473 | 6 |
1764717 | 1764717 | 2021-09-29 | Unknown | Alaska | 473 | 0 | |
1765613 | 1765613 | 2021-09-29 | Sheridan | Kansas | 20179 | 473 | 14 |
1748151 | 1748151 | 2021-09-23 | Norton city | Virginia | 51720 | 473 | 8 |
1723378 | 1723378 | 2021-09-16 | Stafford | Kansas | 20185 | 473 | 13 |
1724400 | 1724400 | 2021-09-16 | Bowman | North Dakota | 38011 | 473 | 6 |
1720129 | 1720129 | 2021-09-15 | Stafford | Kansas | 20185 | 473 | 13 |
1715333 | 1715333 | 2021-09-13 | Donley | Texas | 48129 | 473 | 16 |
1712087 | 1712087 | 2021-09-12 | Donley | Texas | 48129 | 473 | 16 |
1708840 | 1708840 | 2021-09-11 | Donley | Texas | 48129 | 473 | 16 |
1701669 | 1701669 | 2021-09-09 | Cavalier | North Dakota | 38019 | 473 | 5 |
1702128 | 1702128 | 2021-09-09 | Clark | South Dakota | 46025 | 473 | 5 |
1699186 | 1699186 | 2021-09-08 | Mason | Texas | 48319 | 473 | 7 |
1694949 | 1694949 | 2021-09-07 | Unknown | New Hampshire | 473 | 1 | |
1679594 | 1679594 | 2021-09-02 | Delta | Texas | 48119 | 473 | 15 |
1675719 | 1675719 | 2021-09-01 | Wells | North Dakota | 38103 | 473 | 8 |
1659443 | 1659443 | 2021-08-27 | Emmons | North Dakota | 38029 | 473 | 14 |
1651442 | 1651442 | 2021-08-25 | Schley | Georgia | 13249 | 473 | 5 |
1650728 | 1650728 | 2021-08-24 | Surry | Virginia | 51181 | 473 | 9 |
1637410 | 1637410 | 2021-08-20 | Haskell | Texas | 48207 | 473 | 28 |
1628459 | 1628459 | 2021-08-18 | Huerfano | Colorado | 8055 | 473 | 18 |
1627666 | 1627666 | 2021-08-17 | Haskell | Texas | 48207 | 473 | 28 |
1622696 | 1622696 | 2021-08-16 | Ballard | Kentucky | 21007 | 473 | 10 |
1619032 | 1619032 | 2021-08-15 | Lewis | Idaho | 16061 | 473 | 12 |
1615784 | 1615784 | 2021-08-14 | Lewis | Idaho | 16061 | 473 | 12 |
1612535 | 1612535 | 2021-08-13 | Lewis | Idaho | 16061 | 473 | 12 |
1576326 | 1576326 | 2021-08-02 | Calhoun | Arkansas | 5013 | 473 | 4 |
1578548 | 1578548 | 2021-08-02 | Arroyo | Puerto Rico | 72015 | 473 | |
1575300 | 1575300 | 2021-08-01 | Arroyo | Puerto Rico | 72015 | 473 | |
1557022 | 1557022 | 2021-07-27 | Saguache | Colorado | 8109 | 473 | 7 |
1559386 | 1559386 | 2021-07-27 | Coke | Texas | 48081 | 473 | 13 |
1553775 | 1553775 | 2021-07-26 | Saguache | Colorado | 8109 | 473 | 7 |
1556139 | 1556139 | 2021-07-26 | Coke | Texas | 48081 | 473 | 13 |
1537066 | 1537066 | 2021-07-20 | Jefferson | Washington | 53031 | 473 | 4 |
1530952 | 1530952 | 2021-07-19 | Mariposa | California | 6043 | 473 | 7 |
1507013 | 1507013 | 2021-07-11 | Lake | Oregon | 41037 | 473 | 8 |
1503767 | 1503767 | 2021-07-10 | Lake | Oregon | 41037 | 473 | 8 |
1499815 | 1499815 | 2021-07-09 | Holt | Missouri | 29087 | 473 | 14 |
1500521 | 1500521 | 2021-07-09 | Lake | Oregon | 41037 | 473 | 8 |
1497275 | 1497275 | 2021-07-08 | Lake | Oregon | 41037 | 473 | 8 |
1494028 | 1494028 | 2021-07-07 | Lake | Oregon | 41037 | 473 | 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);