ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where cases = 2808 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Iowa 20
- Georgia 15
- Illinois 12
- Kentucky 9
- North Carolina 8
- Virginia 8
- Kansas 7
- Ohio 7
- Missouri 6
- Indiana 5
- Tennessee 5
- Alabama 4
- California 4
- Mississippi 4
- Montana 4
- New York 4
- Vermont 4
- West Virginia 4
- Arkansas 3
- Connecticut 3
- Michigan 3
- Puerto Rico 3
- Wisconsin 3
- Colorado 2
- Louisiana 2
- Maryland 2
- Minnesota 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501944 | 2501944 | 2022-05-13 | Guayanilla | Puerto Rico | 72059 | 2808 | |
2431078 | 2431078 | 2022-04-21 | Summers | West Virginia | 54089 | 2808 | 54 |
2424970 | 2424970 | 2022-04-20 | Rio Grande | Colorado | 8105 | 2808 | 46 |
2398068 | 2398068 | 2022-04-11 | Eastland | Texas | 48133 | 2808 | 113 |
2394813 | 2394813 | 2022-04-10 | Eastland | Texas | 48133 | 2808 | 113 |
2391557 | 2391557 | 2022-04-09 | Eastland | Texas | 48133 | 2808 | 113 |
2315029 | 2315029 | 2022-03-17 | Wilson | Kansas | 20205 | 2808 | 42 |
2311776 | 2311776 | 2022-03-16 | Wilson | Kansas | 20205 | 2808 | 42 |
2308523 | 2308523 | 2022-03-15 | Wilson | Kansas | 20205 | 2808 | 41 |
2305272 | 2305272 | 2022-03-14 | Wilson | Kansas | 20205 | 2808 | 41 |
2287420 | 2287420 | 2022-03-08 | Camp | Texas | 48063 | 2808 | 73 |
2278573 | 2278573 | 2022-03-06 | Unknown | Connecticut | 2808 | 5 | |
2275320 | 2275320 | 2022-03-05 | Unknown | Connecticut | 2808 | 5 | |
2272067 | 2272067 | 2022-03-04 | Unknown | Connecticut | 2808 | 5 | |
2264992 | 2264992 | 2022-03-01 | Lexington city | Virginia | 51678 | 2808 | 39 |
2259830 | 2259830 | 2022-02-28 | Metcalfe | Kentucky | 21169 | 2808 | 58 |
2246806 | 2246806 | 2022-02-24 | Lee | Kentucky | 21129 | 2808 | 46 |
2243555 | 2243555 | 2022-02-23 | Lee | Kentucky | 21129 | 2808 | 46 |
2190743 | 2190743 | 2022-02-07 | Moffat | Colorado | 8081 | 2808 | 51 |
2165870 | 2165870 | 2022-01-30 | Greene | Mississippi | 28041 | 2808 | 50 |
2162615 | 2162615 | 2022-01-29 | Greene | Mississippi | 28041 | 2808 | 50 |
2162756 | 2162756 | 2022-01-29 | Pemiscot | Missouri | 29155 | 2808 | 61 |
2159360 | 2159360 | 2022-01-28 | Greene | Mississippi | 28041 | 2808 | 50 |
2130609 | 2130609 | 2022-01-19 | Mitchell | North Carolina | 37121 | 2808 | 25 |
2104745 | 2104745 | 2022-01-11 | Monroe | Ohio | 39111 | 2808 | 67 |
2100935 | 2100935 | 2022-01-10 | Macon | Missouri | 29121 | 2808 | 37 |
2092531 | 2092531 | 2022-01-07 | Addison | Vermont | 50001 | 2808 | 10 |
2059855 | 2059855 | 2021-12-28 | Jackson | Texas | 48239 | 2808 | 52 |
2056606 | 2056606 | 2021-12-27 | Jackson | Texas | 48239 | 2808 | 52 |
2024067 | 2024067 | 2021-12-17 | Freestone | Texas | 48161 | 2808 | 73 |
1960214 | 1960214 | 2021-11-28 | Clay | Illinois | 17025 | 2808 | 59 |
1956963 | 1956963 | 2021-11-27 | Clay | Illinois | 17025 | 2808 | 59 |
1958393 | 1958393 | 2021-11-27 | Richland | North Dakota | 38077 | 2808 | 21 |
1953712 | 1953712 | 2021-11-26 | Clay | Illinois | 17025 | 2808 | 59 |
1950461 | 1950461 | 2021-11-25 | Clay | Illinois | 17025 | 2808 | 59 |
1947210 | 1947210 | 2021-11-24 | Clay | Illinois | 17025 | 2808 | 59 |
1947797 | 1947797 | 2021-11-24 | Waldo | Maine | 23027 | 2808 | 36 |
1944183 | 1944183 | 2021-11-23 | Hardin | Iowa | 19083 | 2808 | 53 |
1940933 | 1940933 | 2021-11-22 | Hardin | Iowa | 19083 | 2808 | 53 |
1937241 | 1937241 | 2021-11-21 | Banks | Georgia | 13011 | 2808 | 65 |
1937683 | 1937683 | 2021-11-21 | Hardin | Iowa | 19083 | 2808 | 53 |
1933991 | 1933991 | 2021-11-20 | Banks | Georgia | 13011 | 2808 | 65 |
1934433 | 1934433 | 2021-11-20 | Hardin | Iowa | 19083 | 2808 | 53 |
1930739 | 1930739 | 2021-11-19 | Banks | Georgia | 13011 | 2808 | 65 |
1931182 | 1931182 | 2021-11-19 | Hardin | Iowa | 19083 | 2808 | 53 |
1927489 | 1927489 | 2021-11-18 | Banks | Georgia | 13011 | 2808 | 65 |
1927821 | 1927821 | 2021-11-18 | Franklin | Indiana | 18047 | 2808 | 48 |
1927931 | 1927931 | 2021-11-18 | Hardin | Iowa | 19083 | 2808 | 53 |
1924681 | 1924681 | 2021-11-17 | Hardin | Iowa | 19083 | 2808 | 53 |
1893278 | 1893278 | 2021-11-07 | Currituck | North Carolina | 37053 | 2808 | 27 |
1890028 | 1890028 | 2021-11-06 | Currituck | North Carolina | 37053 | 2808 | 27 |
1886778 | 1886778 | 2021-11-05 | Currituck | North Carolina | 37053 | 2808 | 27 |
1883369 | 1883369 | 2021-11-04 | Humboldt | Nevada | 32013 | 2808 | 36 |
1846556 | 1846556 | 2021-10-24 | White | Illinois | 17193 | 2808 | 43 |
1843306 | 1843306 | 2021-10-23 | White | Illinois | 17193 | 2808 | 43 |
1840056 | 1840056 | 2021-10-22 | White | Illinois | 17193 | 2808 | 43 |
1837332 | 1837332 | 2021-10-21 | Talbot | Maryland | 24041 | 2808 | 53 |
1832438 | 1832438 | 2021-10-19 | San Jacinto | Texas | 48407 | 2808 | 74 |
1824029 | 1824029 | 2021-10-17 | Dickinson | Kansas | 20041 | 2808 | 60 |
1820780 | 1820780 | 2021-10-16 | Dickinson | Kansas | 20041 | 2808 | 60 |
1816791 | 1816791 | 2021-10-15 | Sharp | Arkansas | 5135 | 2808 | 66 |
1817531 | 1817531 | 2021-10-15 | Dickinson | Kansas | 20041 | 2808 | 60 |
1806355 | 1806355 | 2021-10-11 | Houston | Texas | 48225 | 2808 | 78 |
1803105 | 1803105 | 2021-10-10 | Houston | Texas | 48225 | 2808 | 78 |
1799856 | 1799856 | 2021-10-09 | Houston | Texas | 48225 | 2808 | 78 |
1796784 | 1796784 | 2021-10-08 | Franklin | Vermont | 50011 | 2808 | 45 |
1779260 | 1779260 | 2021-10-03 | Hill | Montana | 30041 | 2808 | 52 |
1776010 | 1776010 | 2021-10-02 | Hill | Montana | 30041 | 2808 | 52 |
1772760 | 1772760 | 2021-10-01 | Hill | Montana | 30041 | 2808 | 52 |
1764146 | 1764146 | 2021-09-28 | Lee | Texas | 48287 | 2808 | 47 |
1764185 | 1764185 | 2021-09-28 | Panola | Texas | 48365 | 2808 | 98 |
1760744 | 1760744 | 2021-09-27 | Union | Tennessee | 47173 | 2808 | 42 |
1748097 | 1748097 | 2021-09-23 | Dinwiddie | Virginia | 51053 | 2808 | 49 |
1744807 | 1744807 | 2021-09-22 | Washington | Vermont | 50023 | 2808 | 18 |
1734709 | 1734709 | 2021-09-19 | Humphreys | Tennessee | 47085 | 2808 | 41 |
1731459 | 1731459 | 2021-09-18 | Humphreys | Tennessee | 47085 | 2808 | 41 |
1728209 | 1728209 | 2021-09-17 | Humphreys | Tennessee | 47085 | 2808 | 41 |
1718811 | 1718811 | 2021-09-14 | Rutland | Vermont | 50021 | 2808 | 22 |
1714251 | 1714251 | 2021-09-13 | Texas | Missouri | 29215 | 2808 | 36 |
1692915 | 1692915 | 2021-09-06 | Mecklenburg | Virginia | 51117 | 2808 | 71 |
1679052 | 1679052 | 2021-09-02 | Van Wert | Ohio | 39161 | 2808 | 67 |
1675444 | 1675444 | 2021-09-01 | Carroll | New Hampshire | 33003 | 2808 | 14 |
1667658 | 1667658 | 2021-08-30 | Mitchell | Georgia | 13205 | 2808 | 89 |
1669492 | 1669492 | 2021-08-30 | Warren | Pennsylvania | 42123 | 2808 | 107 |
1651672 | 1651672 | 2021-08-25 | Jennings | Indiana | 18079 | 2808 | 54 |
1645475 | 1645475 | 2021-08-23 | Grayson | Kentucky | 21085 | 2808 | 59 |
1625742 | 1625742 | 2021-08-17 | Boone | Iowa | 19015 | 2808 | 35 |
1622495 | 1622495 | 2021-08-16 | Boone | Iowa | 19015 | 2808 | 35 |
1619248 | 1619248 | 2021-08-15 | Boone | Iowa | 19015 | 2808 | 35 |
1616000 | 1616000 | 2021-08-14 | Boone | Iowa | 19015 | 2808 | 35 |
1617273 | 1617273 | 2021-08-14 | Coshocton | Ohio | 39031 | 2808 | 62 |
1612751 | 1612751 | 2021-08-13 | Boone | Iowa | 19015 | 2808 | 35 |
1609503 | 1609503 | 2021-08-12 | Boone | Iowa | 19015 | 2808 | 35 |
1609722 | 1609722 | 2021-08-12 | Carter | Kentucky | 21043 | 2808 | 37 |
1609963 | 1609963 | 2021-08-12 | Dickinson | Michigan | 26043 | 2808 | 74 |
1606254 | 1606254 | 2021-08-11 | Boone | Iowa | 19015 | 2808 | 35 |
1606473 | 1606473 | 2021-08-11 | Carter | Kentucky | 21043 | 2808 | 37 |
1606715 | 1606715 | 2021-08-11 | Dickinson | Michigan | 26043 | 2808 | 74 |
1601049 | 1601049 | 2021-08-09 | Henry | Ohio | 39069 | 2808 | 67 |
1587882 | 1587882 | 2021-08-05 | Cherokee | North Carolina | 37039 | 2808 | 39 |
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);