ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
206 rows where cases = 2401 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 30
- Texas 20
- Kentucky 13
- Georgia 11
- Puerto Rico 10
- Virginia 10
- Indiana 8
- Missouri 8
- Idaho 7
- Mississippi 7
- Michigan 6
- Tennessee 6
- Arkansas 5
- Minnesota 5
- New York 5
- Ohio 5
- Florida 4
- Maine 4
- Maryland 4
- North Carolina 4
- Pennsylvania 3
- South Carolina 3
- Wyoming 3
- Alabama 2
- Arizona 2
- Illinois 2
- Louisiana 2
- New Jersey 2
- Oregon 2
- Washington 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488916 | 2488916 | 2022-05-09 | Hormigueros | Puerto Rico | 72067 | 2401 | |
2449859 | 2449859 | 2022-04-27 | Penuelas | Puerto Rico | 72111 | 2401 | |
2422294 | 2422294 | 2022-04-19 | Sac | Iowa | 19161 | 2401 | 32 |
2419038 | 2419038 | 2022-04-18 | Sac | Iowa | 19161 | 2401 | 32 |
2415782 | 2415782 | 2022-04-17 | Sac | Iowa | 19161 | 2401 | 32 |
2412526 | 2412526 | 2022-04-16 | Sac | Iowa | 19161 | 2401 | 32 |
2409270 | 2409270 | 2022-04-15 | Sac | Iowa | 19161 | 2401 | 32 |
2406014 | 2406014 | 2022-04-14 | Sac | Iowa | 19161 | 2401 | 32 |
2408142 | 2408142 | 2022-04-14 | Lunenburg | Virginia | 51111 | 2401 | 37 |
2402758 | 2402758 | 2022-04-13 | Sac | Iowa | 19161 | 2401 | 32 |
2404886 | 2404886 | 2022-04-13 | Lunenburg | Virginia | 51111 | 2401 | 36 |
2376717 | 2376717 | 2022-04-05 | Sac | Iowa | 19161 | 2401 | 33 |
2373465 | 2373465 | 2022-04-04 | Sac | Iowa | 19161 | 2401 | 33 |
2370212 | 2370212 | 2022-04-03 | Sac | Iowa | 19161 | 2401 | 33 |
2366959 | 2366959 | 2022-04-02 | Sac | Iowa | 19161 | 2401 | 33 |
2363706 | 2363706 | 2022-04-01 | Sac | Iowa | 19161 | 2401 | 33 |
2360452 | 2360452 | 2022-03-31 | Sac | Iowa | 19161 | 2401 | 33 |
2357198 | 2357198 | 2022-03-30 | Sac | Iowa | 19161 | 2401 | 33 |
2334156 | 2334156 | 2022-03-23 | Brown | Illinois | 17009 | 2401 | 21 |
2309887 | 2309887 | 2022-03-15 | Florida | Puerto Rico | 72054 | 2401 | |
2306634 | 2306634 | 2022-03-14 | Florida | Puerto Rico | 72054 | 2401 | |
2284653 | 2284653 | 2022-03-07 | Ritchie | West Virginia | 54085 | 2401 | 30 |
2189583 | 2189583 | 2022-02-06 | Luquillo | Puerto Rico | 72089 | 2401 | |
2178710 | 2178710 | 2022-02-03 | Crawford | Michigan | 26039 | 2401 | 24 |
2175458 | 2175458 | 2022-02-02 | Crawford | Michigan | 26039 | 2401 | 24 |
2160610 | 2160610 | 2022-01-28 | Dawson | Texas | 48115 | 2401 | 87 |
2132981 | 2132981 | 2022-01-20 | Metcalfe | Kentucky | 21169 | 2401 | 53 |
2110593 | 2110593 | 2022-01-13 | Montgomery | Mississippi | 28097 | 2401 | 58 |
2086447 | 2086447 | 2022-01-06 | Ketchikan Gateway Borough | Alaska | 2130 | 2401 | 13 |
2084607 | 2084607 | 2022-01-05 | Walthall | Mississippi | 28147 | 2401 | 67 |
2060103 | 2060103 | 2021-12-28 | King William | Virginia | 51101 | 2401 | 27 |
2033489 | 2033489 | 2021-12-20 | Las Piedras | Puerto Rico | 72085 | 2401 | |
1964049 | 1964049 | 2021-11-29 | Sagadahoc | Maine | 23023 | 2401 | 14 |
1944432 | 1944432 | 2021-11-23 | Monroe | Kentucky | 21171 | 2401 | 64 |
1924627 | 1924627 | 2021-11-17 | Tipton | Indiana | 18159 | 2401 | 66 |
1922154 | 1922154 | 2021-11-16 | Madison | Missouri | 29123 | 2401 | 27 |
1916480 | 1916480 | 2021-11-14 | Naranjito | Puerto Rico | 72105 | 2401 | |
1905841 | 1905841 | 2021-11-11 | Yalobusha | Mississippi | 28161 | 2401 | 47 |
1902592 | 1902592 | 2021-11-10 | Yalobusha | Mississippi | 28161 | 2401 | 47 |
1884639 | 1884639 | 2021-11-04 | Southampton | Virginia | 51175 | 2401 | 67 |
1876454 | 1876454 | 2021-11-02 | Houston | Minnesota | 27055 | 2401 | 17 |
1873498 | 1873498 | 2021-11-01 | Park | Montana | 30067 | 2401 | 28 |
1860102 | 1860102 | 2021-10-28 | Antrim | Michigan | 26009 | 2401 | 38 |
1860456 | 1860456 | 2021-10-28 | Ste. Genevieve | Missouri | 29186 | 2401 | 29 |
1857207 | 1857207 | 2021-10-27 | Ste. Genevieve | Missouri | 29186 | 2401 | 29 |
1857467 | 1857467 | 2021-10-27 | Essex | New York | 36031 | 2401 | 34 |
1855366 | 1855366 | 2021-10-26 | New Kent | Virginia | 51127 | 2401 | 22 |
1850168 | 1850168 | 2021-10-25 | Knott | Kentucky | 21119 | 2401 | 36 |
1850308 | 1850308 | 2021-10-25 | Waldo | Maine | 23027 | 2401 | 31 |
1850709 | 1850709 | 2021-10-25 | Ste. Genevieve | Missouri | 29186 | 2401 | 29 |
1847058 | 1847058 | 2021-10-24 | Waldo | Maine | 23027 | 2401 | 31 |
1843808 | 1843808 | 2021-10-23 | Waldo | Maine | 23027 | 2401 | 31 |
1796512 | 1796512 | 2021-10-08 | Bosque | Texas | 48035 | 2401 | 52 |
1796793 | 1796793 | 2021-10-08 | Windsor | Vermont | 50027 | 2401 | 28 |
1762202 | 1762202 | 2021-09-28 | Delaware | Iowa | 19055 | 2401 | 43 |
1758954 | 1758954 | 2021-09-27 | Delaware | Iowa | 19055 | 2401 | 43 |
1761358 | 1761358 | 2021-09-27 | Carbon | Wyoming | 56007 | 2401 | 35 |
1755706 | 1755706 | 2021-09-26 | Delaware | Iowa | 19055 | 2401 | 43 |
1752458 | 1752458 | 2021-09-25 | Delaware | Iowa | 19055 | 2401 | 43 |
1749209 | 1749209 | 2021-09-24 | Delaware | Iowa | 19055 | 2401 | 43 |
1745959 | 1745959 | 2021-09-23 | Delaware | Iowa | 19055 | 2401 | 43 |
1742710 | 1742710 | 2021-09-22 | Delaware | Iowa | 19055 | 2401 | 43 |
1728412 | 1728412 | 2021-09-17 | Llano | Texas | 48299 | 2401 | 63 |
1719852 | 1719852 | 2021-09-15 | Carroll | Indiana | 18015 | 2401 | 28 |
1713859 | 1713859 | 2021-09-13 | Garrett | Maryland | 24023 | 2401 | 69 |
1700878 | 1700878 | 2021-09-09 | Talbot | Maryland | 24041 | 2401 | 49 |
1685808 | 1685808 | 2021-09-04 | San Sebastian | Puerto Rico | 72131 | 2401 | |
1679158 | 1679158 | 2021-09-02 | Lincoln | Oregon | 41041 | 2401 | 26 |
1648150 | 1648150 | 2021-08-24 | Jeff Davis | Georgia | 13161 | 2401 | 45 |
1644835 | 1644835 | 2021-08-23 | Brantley | Georgia | 13025 | 2401 | 44 |
1625796 | 1625796 | 2021-08-17 | Mahaska | Iowa | 19123 | 2401 | 51 |
1622549 | 1622549 | 2021-08-16 | Mahaska | Iowa | 19123 | 2401 | 51 |
1619302 | 1619302 | 2021-08-15 | Mahaska | Iowa | 19123 | 2401 | 51 |
1619495 | 1619495 | 2021-08-15 | Hart | Kentucky | 21099 | 2401 | 54 |
1619503 | 1619503 | 2021-08-15 | Johnson | Kentucky | 21115 | 2401 | 37 |
1616054 | 1616054 | 2021-08-14 | Mahaska | Iowa | 19123 | 2401 | 51 |
1616247 | 1616247 | 2021-08-14 | Hart | Kentucky | 21099 | 2401 | 54 |
1616255 | 1616255 | 2021-08-14 | Johnson | Kentucky | 21115 | 2401 | 37 |
1616766 | 1616766 | 2021-08-14 | New Madrid | Missouri | 29143 | 2401 | 48 |
1612805 | 1612805 | 2021-08-13 | Mahaska | Iowa | 19123 | 2401 | 51 |
1612998 | 1612998 | 2021-08-13 | Hart | Kentucky | 21099 | 2401 | 54 |
1613006 | 1613006 | 2021-08-13 | Johnson | Kentucky | 21115 | 2401 | 37 |
1609557 | 1609557 | 2021-08-12 | Mahaska | Iowa | 19123 | 2401 | 51 |
1611521 | 1611521 | 2021-08-12 | Robertson | Texas | 48395 | 2401 | 49 |
1606308 | 1606308 | 2021-08-11 | Mahaska | Iowa | 19123 | 2401 | 51 |
1602644 | 1602644 | 2021-08-10 | Elbert | Georgia | 13105 | 2401 | 74 |
1569720 | 1569720 | 2021-07-31 | Butler | Alabama | 1013 | 2401 | 72 |
1563807 | 1563807 | 2021-07-29 | Minidoka | Idaho | 16067 | 2401 | 34 |
1566463 | 1566463 | 2021-07-29 | Uinta | Wyoming | 56041 | 2401 | 14 |
1560712 | 1560712 | 2021-07-28 | Jennings | Indiana | 18079 | 2401 | 51 |
1554740 | 1554740 | 2021-07-26 | Emmet | Michigan | 26047 | 2401 | 43 |
1529354 | 1529354 | 2021-07-18 | Delaware | New York | 36025 | 2401 | 39 |
1526107 | 1526107 | 2021-07-17 | Delaware | New York | 36025 | 2401 | 39 |
1522860 | 1522860 | 2021-07-16 | Delaware | New York | 36025 | 2401 | 39 |
1512336 | 1512336 | 2021-07-13 | Marion | Kentucky | 21155 | 2401 | 38 |
1503866 | 1503866 | 2021-07-10 | Canovanas | Puerto Rico | 72029 | 2401 | |
1498120 | 1498120 | 2021-07-08 | Stevens | Washington | 53065 | 2401 | 32 |
1494873 | 1494873 | 2021-07-07 | Stevens | Washington | 53065 | 2401 | 32 |
1490778 | 1490778 | 2021-07-06 | Jefferson | Oregon | 41031 | 2401 | 41 |
1485852 | 1485852 | 2021-07-05 | Blaine | Idaho | 16013 | 2401 | 18 |
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);