ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
223 rows where cases = 2593 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Iowa 19
- Alabama 13
- Indiana 13
- Illinois 12
- Mississippi 10
- Virginia 10
- Georgia 9
- Oklahoma 9
- Montana 7
- North Carolina 7
- Kentucky 6
- Louisiana 6
- Missouri 6
- Pennsylvania 6
- Arkansas 5
- Colorado 5
- Michigan 5
- Ohio 5
- South Carolina 4
- Florida 3
- Idaho 3
- Kansas 3
- Maryland 3
- Massachusetts 3
- New York 3
- North Dakota 3
- Tennessee 3
- Washington 3
- West Virginia 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483997 | 2483997 | 2022-05-08 | Brown | Indiana | 18013 | 2593 | 62 |
2480739 | 2480739 | 2022-05-07 | Brown | Indiana | 18013 | 2593 | 62 |
2477481 | 2477481 | 2022-05-06 | Brown | Indiana | 18013 | 2593 | 62 |
2474223 | 2474223 | 2022-05-05 | Brown | Indiana | 18013 | 2593 | 62 |
2470966 | 2470966 | 2022-05-04 | Brown | Indiana | 18013 | 2593 | 62 |
2467710 | 2467710 | 2022-05-03 | Brown | Indiana | 18013 | 2593 | 62 |
2464455 | 2464455 | 2022-05-02 | Brown | Indiana | 18013 | 2593 | 62 |
2452359 | 2452359 | 2022-04-28 | Jefferson | Montana | 30043 | 2593 | 23 |
2449103 | 2449103 | 2022-04-27 | Jefferson | Montana | 30043 | 2593 | 23 |
2445846 | 2445846 | 2022-04-26 | Jefferson | Montana | 30043 | 2593 | 23 |
2442591 | 2442591 | 2022-04-25 | Jefferson | Montana | 30043 | 2593 | 23 |
2429567 | 2429567 | 2022-04-21 | Jefferson | Montana | 30043 | 2593 | 23 |
2423055 | 2423055 | 2022-04-19 | Jefferson | Montana | 30043 | 2593 | 23 |
2382109 | 2382109 | 2022-04-06 | Nelson | Virginia | 51125 | 2593 | 34 |
2376649 | 2376649 | 2022-04-05 | Calhoun | Iowa | 19025 | 2593 | 24 |
2373397 | 2373397 | 2022-04-04 | Calhoun | Iowa | 19025 | 2593 | 24 |
2370144 | 2370144 | 2022-04-03 | Calhoun | Iowa | 19025 | 2593 | 24 |
2371312 | 2371312 | 2022-04-03 | Pamlico | North Carolina | 37137 | 2593 | 27 |
2366891 | 2366891 | 2022-04-02 | Calhoun | Iowa | 19025 | 2593 | 24 |
2368059 | 2368059 | 2022-04-02 | Pamlico | North Carolina | 37137 | 2593 | 27 |
2363638 | 2363638 | 2022-04-01 | Calhoun | Iowa | 19025 | 2593 | 24 |
2364806 | 2364806 | 2022-04-01 | Pamlico | North Carolina | 37137 | 2593 | 27 |
2360384 | 2360384 | 2022-03-31 | Calhoun | Iowa | 19025 | 2593 | 24 |
2357130 | 2357130 | 2022-03-30 | Calhoun | Iowa | 19025 | 2593 | 24 |
2352772 | 2352772 | 2022-03-28 | Clarke | Virginia | 51043 | 2593 | 41 |
2314195 | 2314195 | 2022-03-17 | Pike | Arkansas | 5109 | 2593 | 42 |
2310942 | 2310942 | 2022-03-16 | Pike | Arkansas | 5109 | 2593 | 42 |
2311072 | 2311072 | 2022-03-16 | Prowers | Colorado | 8099 | 2593 | 48 |
2306937 | 2306937 | 2022-03-14 | Childress | Texas | 48075 | 2593 | 31 |
2303686 | 2303686 | 2022-03-13 | Childress | Texas | 48075 | 2593 | 31 |
2300434 | 2300434 | 2022-03-12 | Childress | Texas | 48075 | 2593 | 30 |
2297182 | 2297182 | 2022-03-11 | Childress | Texas | 48075 | 2593 | 30 |
2284465 | 2284465 | 2022-03-07 | Clarke | Virginia | 51043 | 2593 | 41 |
2271454 | 2271454 | 2022-03-03 | Clarke | Virginia | 51043 | 2593 | 40 |
2259826 | 2259826 | 2022-02-28 | McLean | Kentucky | 21149 | 2593 | 45 |
2241454 | 2241454 | 2022-02-22 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2238203 | 2238203 | 2022-02-21 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2234952 | 2234952 | 2022-02-20 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2231701 | 2231701 | 2022-02-19 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2226276 | 2226276 | 2022-02-18 | Lowndes | Alabama | 1085 | 2593 | 69 |
2228450 | 2228450 | 2022-02-18 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2225199 | 2225199 | 2022-02-17 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2221948 | 2221948 | 2022-02-16 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2217760 | 2217760 | 2022-02-15 | Iron | Michigan | 26071 | 2593 | 81 |
2214509 | 2214509 | 2022-02-14 | Iron | Michigan | 26071 | 2593 | 81 |
2214593 | 2214593 | 2022-02-14 | Koochiching | Minnesota | 27071 | 2593 | 34 |
2190016 | 2190016 | 2022-02-06 | Pecos | Texas | 48371 | 2593 | 65 |
2165015 | 2165015 | 2022-01-30 | Gooding | Idaho | 16047 | 2593 | 48 |
2161760 | 2161760 | 2022-01-29 | Gooding | Idaho | 16047 | 2593 | 48 |
2160584 | 2160584 | 2022-01-28 | Camp | Texas | 48063 | 2593 | 70 |
2125912 | 2125912 | 2022-01-18 | Telfair | Georgia | 13271 | 2593 | 75 |
2108933 | 2108933 | 2022-01-12 | Westmoreland | Virginia | 51193 | 2593 | 39 |
2101472 | 2101472 | 2022-01-10 | Harrison | Ohio | 39067 | 2593 | 60 |
2095675 | 2095675 | 2022-01-08 | Nolan | Texas | 48353 | 2593 | 85 |
2091187 | 2091187 | 2022-01-07 | Mississippi | Missouri | 29133 | 2593 | 50 |
2083273 | 2083273 | 2022-01-05 | Marion | Arkansas | 5089 | 2593 | 75 |
2068917 | 2068917 | 2021-12-31 | Walsh | North Dakota | 38099 | 2593 | 34 |
2054524 | 2054524 | 2021-12-27 | Massac | Illinois | 17127 | 2593 | 59 |
2037466 | 2037466 | 2021-12-21 | Braxton | West Virginia | 54007 | 2593 | 29 |
2006708 | 2006708 | 2021-12-12 | Ste. Genevieve | Missouri | 29186 | 2593 | 34 |
1996372 | 1996372 | 2021-12-09 | Caldwell | Kentucky | 21033 | 2593 | 52 |
1988116 | 1988116 | 2021-12-06 | Oglala Lakota | South Dakota | 46102 | 2593 | 54 |
1952141 | 1952141 | 2021-11-25 | Fulton | Pennsylvania | 42057 | 2593 | 38 |
1937747 | 1937747 | 2021-11-21 | Bourbon | Kansas | 20011 | 2593 | 44 |
1934497 | 1934497 | 2021-11-20 | Bourbon | Kansas | 20011 | 2593 | 44 |
1931246 | 1931246 | 2021-11-19 | Bourbon | Kansas | 20011 | 2593 | 44 |
1895105 | 1895105 | 2021-11-08 | Rabun | Georgia | 13241 | 2593 | 66 |
1886460 | 1886460 | 2021-11-05 | Wright | Missouri | 29229 | 2593 | 54 |
1870645 | 1870645 | 2021-10-31 | Richland | North Dakota | 38077 | 2593 | 20 |
1840862 | 1840862 | 2021-10-22 | Benton | Missouri | 29015 | 2593 | 45 |
1837613 | 1837613 | 2021-10-21 | Benton | Missouri | 29015 | 2593 | 45 |
1839077 | 1839077 | 2021-10-21 | Fluvanna | Virginia | 51065 | 2593 | 22 |
1827073 | 1827073 | 2021-10-18 | Carroll | Indiana | 18015 | 2593 | 34 |
1801554 | 1801554 | 2021-10-10 | Winn | Louisiana | 22127 | 2593 | 58 |
1798305 | 1798305 | 2021-10-09 | Winn | Louisiana | 22127 | 2593 | 58 |
1795056 | 1795056 | 2021-10-08 | Winn | Louisiana | 22127 | 2593 | 58 |
1784734 | 1784734 | 2021-10-05 | Cass | Illinois | 17017 | 2593 | 38 |
1782231 | 1782231 | 2021-10-04 | Hubbard | Minnesota | 27057 | 2593 | 41 |
1782920 | 1782920 | 2021-10-04 | Rolette | North Dakota | 38079 | 2593 | 30 |
1776268 | 1776268 | 2021-10-02 | Seneca | New York | 36099 | 2593 | 60 |
1736069 | 1736069 | 2021-09-20 | Richland | Illinois | 17159 | 2593 | 63 |
1709072 | 1709072 | 2021-09-11 | Washington | Vermont | 50023 | 2593 | 18 |
1699683 | 1699683 | 2021-09-09 | Fayette | Alabama | 1057 | 2593 | 66 |
1641800 | 1641800 | 2021-08-22 | Crawford | Illinois | 17033 | 2593 | 43 |
1642442 | 1642442 | 2021-08-22 | Clare | Michigan | 26035 | 2593 | 87 |
1638550 | 1638550 | 2021-08-21 | Crawford | Illinois | 17033 | 2593 | 43 |
1639192 | 1639192 | 2021-08-21 | Clare | Michigan | 26035 | 2593 | 87 |
1635300 | 1635300 | 2021-08-20 | Crawford | Illinois | 17033 | 2593 | 43 |
1635942 | 1635942 | 2021-08-20 | Clare | Michigan | 26035 | 2593 | 87 |
1631625 | 1631625 | 2021-08-19 | Colusa | California | 6011 | 2593 | 18 |
1618498 | 1618498 | 2021-08-15 | Pickens | Alabama | 1107 | 2593 | 63 |
1621690 | 1621690 | 2021-08-15 | Uinta | Wyoming | 56041 | 2593 | 14 |
1618442 | 1618442 | 2021-08-14 | Uinta | Wyoming | 56041 | 2593 | 14 |
1615194 | 1615194 | 2021-08-13 | Uinta | Wyoming | 56041 | 2593 | 14 |
1610842 | 1610842 | 2021-08-12 | Van Wert | Ohio | 39161 | 2593 | 65 |
1602706 | 1602706 | 2021-08-10 | Pike | Georgia | 13231 | 2593 | 44 |
1601998 | 1601998 | 2021-08-09 | Staunton city | Virginia | 51790 | 2593 | 70 |
1596396 | 1596396 | 2021-08-08 | Union | Illinois | 17181 | 2593 | 46 |
1598355 | 1598355 | 2021-08-08 | Burleson | Texas | 48051 | 2593 | 48 |
1593147 | 1593147 | 2021-08-07 | Union | Illinois | 17181 | 2593 | 46 |
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);