ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
395 rows where cases = 1308 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 53
- Kentucky 32
- Illinois 24
- Georgia 23
- Iowa 23
- Mississippi 14
- Virginia 14
- Missouri 13
- Tennessee 12
- North Dakota 10
- Puerto Rico 10
- South Dakota 10
- Arkansas 9
- Michigan 9
- West Virginia 9
- Minnesota 8
- North Carolina 8
- Colorado 7
- Connecticut 7
- Montana 7
- Alabama 6
- Florida 6
- Kansas 6
- Nebraska 6
- Oregon 6
- California 5
- Idaho 5
- Maine 5
- Ohio 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502366 | 2502366 | 2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 |
2499108 | 2499108 | 2022-05-12 | McCulloch | Texas | 48307 | 1308 | 47 |
2499340 | 2499340 | 2022-05-12 | Norton city | Virginia | 51720 | 1308 | 22 |
2495850 | 2495850 | 2022-05-11 | McCulloch | Texas | 48307 | 1308 | 47 |
2492592 | 2492592 | 2022-05-10 | McCulloch | Texas | 48307 | 1308 | 47 |
2489334 | 2489334 | 2022-05-09 | McCulloch | Texas | 48307 | 1308 | 47 |
2429963 | 2429963 | 2022-04-21 | McHenry | North Dakota | 38049 | 1308 | 31 |
2426707 | 2426707 | 2022-04-20 | McHenry | North Dakota | 38049 | 1308 | 31 |
2423451 | 2423451 | 2022-04-19 | McHenry | North Dakota | 38049 | 1308 | 31 |
2420194 | 2420194 | 2022-04-18 | McHenry | North Dakota | 38049 | 1308 | 31 |
2416939 | 2416939 | 2022-04-17 | McHenry | North Dakota | 38049 | 1308 | 31 |
2413683 | 2413683 | 2022-04-16 | McHenry | North Dakota | 38049 | 1308 | 31 |
2410427 | 2410427 | 2022-04-15 | McHenry | North Dakota | 38049 | 1308 | 31 |
2370340 | 2370340 | 2022-04-03 | Ballard | Kentucky | 21007 | 1308 | 28 |
2367087 | 2367087 | 2022-04-02 | Ballard | Kentucky | 21007 | 1308 | 28 |
2363834 | 2363834 | 2022-04-01 | Ballard | Kentucky | 21007 | 1308 | 28 |
2360580 | 2360580 | 2022-03-31 | Ballard | Kentucky | 21007 | 1308 | 28 |
2357326 | 2357326 | 2022-03-30 | Ballard | Kentucky | 21007 | 1308 | 28 |
2354073 | 2354073 | 2022-03-29 | Ballard | Kentucky | 21007 | 1308 | 28 |
2350821 | 2350821 | 2022-03-28 | Ballard | Kentucky | 21007 | 1308 | 28 |
2335505 | 2335505 | 2022-03-23 | Hyde | North Carolina | 37095 | 1308 | 13 |
2332251 | 2332251 | 2022-03-22 | Hyde | North Carolina | 37095 | 1308 | 13 |
2293794 | 2293794 | 2022-03-10 | Walworth | South Dakota | 46129 | 1308 | 25 |
2287264 | 2287264 | 2022-03-08 | Kingsbury | South Dakota | 46077 | 1308 | 21 |
2242131 | 2242131 | 2022-02-22 | Kane | Utah | 49025 | 1308 | 13 |
2224676 | 2224676 | 2022-02-17 | Dawes | Nebraska | 31045 | 1308 | 21 |
2205521 | 2205521 | 2022-02-11 | Sioux | North Dakota | 38085 | 1308 | 19 |
2194689 | 2194689 | 2022-02-08 | Rooks | Kansas | 20163 | 1308 | 20 |
2196064 | 2196064 | 2022-02-08 | Ceiba | Puerto Rico | 72037 | 1308 | |
2191435 | 2191435 | 2022-02-07 | Rooks | Kansas | 20163 | 1308 | 20 |
2191790 | 2191790 | 2022-02-07 | Big Stone | Minnesota | 27011 | 1308 | 8 |
2192810 | 2192810 | 2022-02-07 | Ceiba | Puerto Rico | 72037 | 1308 | |
2176704 | 2176704 | 2022-02-02 | McCook | South Dakota | 46087 | 1308 | 30 |
2161081 | 2161081 | 2022-01-28 | Wirt | West Virginia | 54105 | 1308 | 19 |
2150207 | 2150207 | 2022-01-25 | Ransom | North Dakota | 38073 | 1308 | 24 |
2143392 | 2143392 | 2022-01-23 | Nemaha | Nebraska | 31127 | 1308 | 18 |
2140137 | 2140137 | 2022-01-22 | Nemaha | Nebraska | 31127 | 1308 | 18 |
2136881 | 2136881 | 2022-01-21 | Nemaha | Nebraska | 31127 | 1308 | 18 |
2133490 | 2133490 | 2022-01-20 | Shannon | Missouri | 29203 | 1308 | 31 |
2133616 | 2133616 | 2022-01-20 | Keith | Nebraska | 31101 | 1308 | 13 |
2098848 | 2098848 | 2022-01-09 | Hansford | Texas | 48195 | 1308 | 27 |
2087615 | 2087615 | 2022-01-06 | Alger | Michigan | 26003 | 1308 | 11 |
2087888 | 2087888 | 2022-01-06 | Chariton | Missouri | 29041 | 1308 | 32 |
2083276 | 2083276 | 2022-01-05 | Monroe | Arkansas | 5095 | 1308 | 26 |
2084363 | 2084363 | 2022-01-05 | Alger | Michigan | 26003 | 1308 | 11 |
2082352 | 2082352 | 2022-01-04 | Fall River | South Dakota | 46047 | 1308 | 31 |
2034886 | 2034886 | 2021-12-21 | Taylor | Georgia | 13269 | 1308 | 41 |
2031636 | 2031636 | 2021-12-20 | Taylor | Georgia | 13269 | 1308 | 41 |
2028385 | 2028385 | 2021-12-19 | Taylor | Georgia | 13269 | 1308 | 40 |
2028760 | 2028760 | 2021-12-19 | Anderson | Kansas | 20003 | 1308 | 23 |
2025134 | 2025134 | 2021-12-18 | Taylor | Georgia | 13269 | 1308 | 40 |
2025509 | 2025509 | 2021-12-18 | Anderson | Kansas | 20003 | 1308 | 23 |
2026187 | 2026187 | 2021-12-18 | Ozark | Missouri | 29153 | 1308 | 43 |
2021883 | 2021883 | 2021-12-17 | Taylor | Georgia | 13269 | 1308 | 40 |
2022258 | 2022258 | 2021-12-17 | Anderson | Kansas | 20003 | 1308 | 23 |
2018632 | 2018632 | 2021-12-16 | Taylor | Georgia | 13269 | 1308 | 40 |
2021247 | 2021247 | 2021-12-16 | Pocahontas | West Virginia | 54075 | 1308 | 21 |
2015161 | 2015161 | 2021-12-15 | San Miguel | Colorado | 8113 | 1308 | 5 |
2015382 | 2015382 | 2021-12-15 | Taylor | Georgia | 13269 | 1308 | 40 |
1997973 | 1997973 | 2021-12-09 | Van Buren | Tennessee | 47175 | 1308 | 32 |
1997996 | 1997996 | 2021-12-09 | Blanco | Texas | 48031 | 1308 | 28 |
1994722 | 1994722 | 2021-12-08 | Van Buren | Tennessee | 47175 | 1308 | 32 |
1988883 | 1988883 | 2021-12-07 | Greene | Alabama | 1063 | 1308 | 45 |
1969900 | 1969900 | 2021-12-01 | Wilcox | Georgia | 13315 | 1308 | 60 |
1963025 | 1963025 | 2021-11-29 | Searcy | Arkansas | 5129 | 1308 | 25 |
1959774 | 1959774 | 2021-11-28 | Searcy | Arkansas | 5129 | 1308 | 25 |
1922284 | 1922284 | 2021-11-16 | Cuming | Nebraska | 31039 | 1308 | 15 |
1913717 | 1913717 | 2021-11-13 | Winkler | Texas | 48495 | 1308 | 29 |
1909129 | 1909129 | 2021-11-12 | Gentry | Missouri | 29075 | 1308 | 27 |
1910467 | 1910467 | 2021-11-12 | Winkler | Texas | 48495 | 1308 | 29 |
1877820 | 1877820 | 2021-11-02 | Hamilton | Texas | 48193 | 1308 | 29 |
1874571 | 1874571 | 2021-11-01 | Hamilton | Texas | 48193 | 1308 | 29 |
1871322 | 1871322 | 2021-10-31 | Hamilton | Texas | 48193 | 1308 | 29 |
1868073 | 1868073 | 2021-10-30 | Hamilton | Texas | 48193 | 1308 | 29 |
1864824 | 1864824 | 2021-10-29 | Hamilton | Texas | 48193 | 1308 | 29 |
1826569 | 1826569 | 2021-10-18 | Mariposa | California | 6043 | 1308 | 15 |
1828020 | 1828020 | 2021-10-18 | Sanders | Montana | 30089 | 1308 | 19 |
1825636 | 1825636 | 2021-10-17 | Turner | South Dakota | 46125 | 1308 | 60 |
1826134 | 1826134 | 2021-10-17 | Poquoson city | Virginia | 51735 | 1308 | 19 |
1826355 | 1826355 | 2021-10-17 | Sublette | Wyoming | 56035 | 1308 | 13 |
1822387 | 1822387 | 2021-10-16 | Turner | South Dakota | 46125 | 1308 | 60 |
1822885 | 1822885 | 2021-10-16 | Poquoson city | Virginia | 51735 | 1308 | 19 |
1823106 | 1823106 | 2021-10-16 | Sublette | Wyoming | 56035 | 1308 | 13 |
1819138 | 1819138 | 2021-10-15 | Turner | South Dakota | 46125 | 1308 | 60 |
1819636 | 1819636 | 2021-10-15 | Poquoson city | Virginia | 51735 | 1308 | 19 |
1819723 | 1819723 | 2021-10-15 | Gilmer | West Virginia | 54021 | 1308 | 9 |
1819857 | 1819857 | 2021-10-15 | Sublette | Wyoming | 56035 | 1308 | 13 |
1797016 | 1797016 | 2021-10-08 | Tyler | West Virginia | 54095 | 1308 | 18 |
1791717 | 1791717 | 2021-10-07 | Owen | Kentucky | 21187 | 1308 | 22 |
1793439 | 1793439 | 2021-10-07 | Red River | Texas | 48387 | 1308 | 47 |
1777785 | 1777785 | 2021-10-03 | Nevada | Arkansas | 5099 | 1308 | 30 |
1771019 | 1771019 | 2021-09-30 | Summers | West Virginia | 54089 | 1308 | 26 |
1767762 | 1767762 | 2021-09-29 | Pleasants | West Virginia | 54073 | 1308 | 22 |
1758885 | 1758885 | 2021-09-27 | Martin | Indiana | 18101 | 1308 | 19 |
1759331 | 1759331 | 2021-09-27 | Washington | Maine | 23029 | 1308 | 20 |
1756083 | 1756083 | 2021-09-26 | Washington | Maine | 23029 | 1308 | 20 |
1746217 | 1746217 | 2021-09-23 | McLean | Kentucky | 21149 | 1308 | 33 |
1738051 | 1738051 | 2021-09-20 | Clay | Texas | 48077 | 1308 | 21 |
1732454 | 1732454 | 2021-09-19 | Unknown | Connecticut | 1308 | 3 | |
1734801 | 1734801 | 2021-09-19 | Clay | Texas | 48077 | 1308 | 21 |
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);