ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where cases = 2590 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19
- Georgia 15
- Missouri 13
- Alabama 11
- Illinois 11
- Virginia 11
- Montana 9
- Oklahoma 9
- Louisiana 8
- Kansas 7
- Kentucky 6
- Ohio 6
- Tennessee 6
- Indiana 5
- Mississippi 5
- Puerto Rico 5
- South Dakota 5
- Idaho 4
- Minnesota 4
- North Carolina 4
- West Virginia 4
- Wisconsin 4
- Wyoming 4
- Arkansas 3
- Maryland 3
- Michigan 3
- Nebraska 3
- Nevada 3
- New York 3
- Vermont 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496376 | 2496376 | 2022-05-12 | Sumter | Alabama | 1119 | 2590 | 51 |
2493118 | 2493118 | 2022-05-11 | Sumter | Alabama | 1119 | 2590 | 51 |
2489860 | 2489860 | 2022-05-10 | Sumter | Alabama | 1119 | 2590 | 51 |
2492840 | 2492840 | 2022-05-10 | Richmond | Virginia | 51159 | 2590 | 25 |
2485655 | 2485655 | 2022-05-08 | Guayanilla | Puerto Rico | 72059 | 2590 | |
2482397 | 2482397 | 2022-05-07 | Guayanilla | Puerto Rico | 72059 | 2590 | |
2444919 | 2444919 | 2022-04-26 | Brown | Indiana | 18013 | 2590 | 62 |
2441663 | 2441663 | 2022-04-25 | Brown | Indiana | 18013 | 2590 | 62 |
2400264 | 2400264 | 2022-04-12 | Jefferson | Montana | 30043 | 2590 | 23 |
2397009 | 2397009 | 2022-04-11 | Jefferson | Montana | 30043 | 2590 | 23 |
2393754 | 2393754 | 2022-04-10 | Jefferson | Montana | 30043 | 2590 | 23 |
2390498 | 2390498 | 2022-04-09 | Jefferson | Montana | 30043 | 2590 | 23 |
2387242 | 2387242 | 2022-04-08 | Jefferson | Montana | 30043 | 2590 | 23 |
2383987 | 2383987 | 2022-04-07 | Jefferson | Montana | 30043 | 2590 | 23 |
2365680 | 2365680 | 2022-04-01 | Terry | Texas | 48445 | 2590 | 84 |
2326748 | 2326748 | 2022-03-20 | Clarke | Virginia | 51043 | 2590 | 40 |
2323495 | 2323495 | 2022-03-19 | Clarke | Virginia | 51043 | 2590 | 40 |
2320241 | 2320241 | 2022-03-18 | Clarke | Virginia | 51043 | 2590 | 40 |
2304873 | 2304873 | 2022-03-14 | Valley | Idaho | 16085 | 2590 | 16 |
2305929 | 2305929 | 2022-03-14 | Richland | Montana | 30083 | 2590 | 31 |
2269096 | 2269096 | 2022-03-03 | Shoshone | Idaho | 16079 | 2590 | 75 |
2264949 | 2264949 | 2022-03-01 | Clarke | Virginia | 51043 | 2590 | 40 |
2219774 | 2219774 | 2022-02-16 | Lowndes | Alabama | 1085 | 2590 | 69 |
2219514 | 2219514 | 2022-02-15 | Richmond | Virginia | 51159 | 2590 | 21 |
2172028 | 2172028 | 2022-02-01 | Metcalfe | Kentucky | 21169 | 2590 | 54 |
2172445 | 2172445 | 2022-02-01 | Barton | Missouri | 29011 | 2590 | 46 |
2151709 | 2151709 | 2022-01-26 | Park | Colorado | 8093 | 2590 | 17 |
2141676 | 2141676 | 2022-01-23 | Coosa | Alabama | 1037 | 2590 | 49 |
2128622 | 2128622 | 2022-01-18 | Converse | Wyoming | 56009 | 2590 | 49 |
2103589 | 2103589 | 2022-01-11 | Nemaha | Kansas | 20131 | 2590 | 58 |
2100338 | 2100338 | 2022-01-10 | Nemaha | Kansas | 20131 | 2590 | 58 |
2089290 | 2089290 | 2022-01-06 | Unknown | Vermont | 2590 | 0 | |
2079658 | 2079658 | 2022-01-03 | Southampton | Virginia | 51175 | 2590 | 74 |
2063336 | 2063336 | 2021-12-29 | Giles | Virginia | 51071 | 2590 | 38 |
2030443 | 2030443 | 2021-12-19 | Lewis | Tennessee | 47101 | 2590 | 44 |
2027192 | 2027192 | 2021-12-18 | Lewis | Tennessee | 47101 | 2590 | 44 |
2023941 | 2023941 | 2021-12-17 | Lewis | Tennessee | 47101 | 2590 | 44 |
1999798 | 1999798 | 2021-12-10 | Knox | Maine | 23013 | 2590 | 17 |
1996956 | 1996956 | 2021-12-09 | Ste. Genevieve | Missouri | 29186 | 2590 | 34 |
1998562 | 1998562 | 2021-12-09 | Richland | Wisconsin | 55103 | 2590 | 32 |
1984866 | 1984866 | 2021-12-05 | Oglala Lakota | South Dakota | 46102 | 2590 | 54 |
1981616 | 1981616 | 2021-12-04 | Oglala Lakota | South Dakota | 46102 | 2590 | 54 |
1978366 | 1978366 | 2021-12-03 | Oglala Lakota | South Dakota | 46102 | 2590 | 54 |
1969248 | 1969248 | 2021-11-30 | Taylor | West Virginia | 54091 | 2590 | 44 |
1960296 | 1960296 | 2021-11-28 | Warren | Illinois | 17187 | 2590 | 71 |
1957045 | 1957045 | 2021-11-27 | Warren | Illinois | 17187 | 2590 | 71 |
1953794 | 1953794 | 2021-11-26 | Warren | Illinois | 17187 | 2590 | 71 |
1950543 | 1950543 | 2021-11-25 | Warren | Illinois | 17187 | 2590 | 71 |
1947292 | 1947292 | 2021-11-24 | Warren | Illinois | 17187 | 2590 | 71 |
1943954 | 1943954 | 2021-11-23 | Carroll | Illinois | 17015 | 2590 | 42 |
1882106 | 1882106 | 2021-11-04 | Rabun | Georgia | 13241 | 2590 | 66 |
1867396 | 1867396 | 2021-10-30 | Richland | North Dakota | 38077 | 2590 | 20 |
1854984 | 1854984 | 2021-10-26 | Aransas | Texas | 48007 | 2590 | 66 |
1851735 | 1851735 | 2021-10-25 | Aransas | Texas | 48007 | 2590 | 66 |
1847629 | 1847629 | 2021-10-24 | Humboldt | Nevada | 32013 | 2590 | 27 |
1848485 | 1848485 | 2021-10-24 | Aransas | Texas | 48007 | 2590 | 66 |
1844379 | 1844379 | 2021-10-23 | Humboldt | Nevada | 32013 | 2590 | 27 |
1845235 | 1845235 | 2021-10-23 | Aransas | Texas | 48007 | 2590 | 66 |
1841129 | 1841129 | 2021-10-22 | Humboldt | Nevada | 32013 | 2590 | 27 |
1841985 | 1841985 | 2021-10-22 | Aransas | Texas | 48007 | 2590 | 65 |
1838736 | 1838736 | 2021-10-21 | Aransas | Texas | 48007 | 2590 | 64 |
1834364 | 1834364 | 2021-10-20 | Benton | Missouri | 29015 | 2590 | 45 |
1831115 | 1831115 | 2021-10-19 | Benton | Missouri | 29015 | 2590 | 45 |
1831819 | 1831819 | 2021-10-19 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1827866 | 1827866 | 2021-10-18 | Benton | Missouri | 29015 | 2590 | 44 |
1828570 | 1828570 | 2021-10-18 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1829284 | 1829284 | 2021-10-18 | Windsor | Vermont | 50027 | 2590 | 29 |
1824420 | 1824420 | 2021-10-17 | Ogemaw | Michigan | 26129 | 2590 | 54 |
1824617 | 1824617 | 2021-10-17 | Benton | Missouri | 29015 | 2590 | 44 |
1825321 | 1825321 | 2021-10-17 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1821171 | 1821171 | 2021-10-16 | Ogemaw | Michigan | 26129 | 2590 | 54 |
1822072 | 1822072 | 2021-10-16 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1817922 | 1817922 | 2021-10-15 | Ogemaw | Michigan | 26129 | 2590 | 54 |
1818823 | 1818823 | 2021-10-15 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1814760 | 1814760 | 2021-10-14 | Roseau | Minnesota | 27135 | 2590 | 24 |
1815574 | 1815574 | 2021-10-14 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1816062 | 1816062 | 2021-10-14 | Falls | Texas | 48145 | 2590 | 43 |
1812326 | 1812326 | 2021-10-13 | Pawnee | Oklahoma | 40117 | 2590 | 60 |
1801383 | 1801383 | 2021-10-10 | Breckinridge | Kentucky | 21027 | 2590 | 27 |
1803488 | 1803488 | 2021-10-10 | Lincoln | West Virginia | 54043 | 2590 | 41 |
1798134 | 1798134 | 2021-10-09 | Breckinridge | Kentucky | 21027 | 2590 | 27 |
1794885 | 1794885 | 2021-10-08 | Breckinridge | Kentucky | 21027 | 2590 | 27 |
1790433 | 1790433 | 2021-10-06 | Asotin | Washington | 53003 | 2590 | 46 |
1785604 | 1785604 | 2021-10-05 | Smith | Mississippi | 28129 | 2590 | 49 |
1782712 | 1782712 | 2021-10-04 | Roosevelt | New Mexico | 35041 | 2590 | 68 |
1768642 | 1768642 | 2021-09-30 | Perry | Indiana | 18123 | 2590 | 56 |
1758601 | 1758601 | 2021-09-27 | Jefferson | Georgia | 13163 | 2590 | 74 |
1749909 | 1749909 | 2021-09-24 | Cooper | Missouri | 29053 | 2590 | 31 |
1742342 | 1742342 | 2021-09-22 | Greene | Georgia | 13133 | 2590 | 67 |
1737459 | 1737459 | 2021-09-20 | Carroll | Ohio | 39019 | 2590 | 52 |
1720512 | 1720512 | 2021-09-15 | Martin | Minnesota | 27091 | 2590 | 33 |
1710370 | 1710370 | 2021-09-12 | Pottawatomie | Kansas | 20149 | 2590 | 38 |
1707123 | 1707123 | 2021-09-11 | Pottawatomie | Kansas | 20149 | 2590 | 38 |
1703875 | 1703875 | 2021-09-10 | Pottawatomie | Kansas | 20149 | 2590 | 38 |
1686787 | 1686787 | 2021-09-05 | Cross | Arkansas | 5037 | 2590 | 58 |
1676580 | 1676580 | 2021-09-01 | Rutland | Vermont | 50021 | 2590 | 22 |
1646925 | 1646925 | 2021-08-23 | Hughes | South Dakota | 46065 | 2590 | 43 |
1636540 | 1636540 | 2021-08-20 | Delaware | New York | 36025 | 2590 | 39 |
1604943 | 1604943 | 2021-08-10 | Hutchinson | Texas | 48233 | 2590 | 72 |
1601718 | 1601718 | 2021-08-09 | Lamb | Texas | 48279 | 2590 | 83 |
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);