ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where cases = 2501 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Georgia 19
- Missouri 12
- Tennessee 12
- Puerto Rico 9
- South Dakota 8
- North Carolina 7
- Mississippi 6
- Virginia 6
- Alabama 5
- Kansas 5
- Kentucky 5
- Louisiana 5
- Michigan 5
- Wisconsin 5
- Alaska 4
- Arkansas 4
- Indiana 4
- Minnesota 4
- West Virginia 4
- Colorado 3
- Idaho 3
- Maryland 3
- Montana 3
- North Dakota 3
- Pennsylvania 3
- California 2
- Hawaii 2
- Illinois 2
- Iowa 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462883 | 2462883 | 2022-05-01 | Penuelas | Puerto Rico | 72111 | 2501 | |
2427628 | 2427628 | 2022-04-20 | Charlotte | Virginia | 51037 | 2501 | 45 |
2424372 | 2424372 | 2022-04-19 | Charlotte | Virginia | 51037 | 2501 | 45 |
2342913 | 2342913 | 2022-03-25 | Trinity | Texas | 48455 | 2501 | 72 |
2339660 | 2339660 | 2022-03-24 | Trinity | Texas | 48455 | 2501 | 72 |
2336406 | 2336406 | 2022-03-23 | Trinity | Texas | 48455 | 2501 | 72 |
2327294 | 2327294 | 2022-03-21 | Bent | Colorado | 8011 | 2501 | 47 |
2322941 | 2322941 | 2022-03-19 | Santa Isabel | Puerto Rico | 72133 | 2501 | |
2307071 | 2307071 | 2022-03-14 | Morris | Texas | 48343 | 2501 | 70 |
2303820 | 2303820 | 2022-03-13 | Morris | Texas | 48343 | 2501 | 70 |
2300568 | 2300568 | 2022-03-12 | Morris | Texas | 48343 | 2501 | 70 |
2270005 | 2270005 | 2022-03-03 | Bollinger | Missouri | 29017 | 2501 | 36 |
2266803 | 2266803 | 2022-03-02 | Linn | Missouri | 29115 | 2501 | 62 |
2244147 | 2244147 | 2022-02-23 | Rosebud | Montana | 30087 | 2501 | 60 |
2208760 | 2208760 | 2022-02-12 | Mercer | North Dakota | 38057 | 2501 | 23 |
2194665 | 2194665 | 2022-02-08 | Marshall | Kansas | 20117 | 2501 | 40 |
2195639 | 2195639 | 2022-02-08 | Clay | North Carolina | 37043 | 2501 | 38 |
2191411 | 2191411 | 2022-02-07 | Marshall | Kansas | 20117 | 2501 | 40 |
2129981 | 2129981 | 2022-01-19 | Chippewa | Minnesota | 27023 | 2501 | 44 |
2130650 | 2130650 | 2022-01-19 | Barnes | North Dakota | 38003 | 2501 | 41 |
2122252 | 2122252 | 2022-01-17 | Bradley | Arkansas | 5011 | 2501 | 43 |
2103897 | 2103897 | 2022-01-11 | Gogebic | Michigan | 26053 | 2501 | 63 |
2100646 | 2100646 | 2022-01-10 | Gogebic | Michigan | 26053 | 2501 | 63 |
2086651 | 2086651 | 2022-01-06 | Las Animas | Colorado | 8071 | 2501 | 33 |
2066541 | 2066541 | 2021-12-30 | Alleghany | Virginia | 51005 | 2501 | 87 |
2058743 | 2058743 | 2021-12-28 | Glacier | Montana | 30035 | 2501 | 63 |
2055494 | 2055494 | 2021-12-27 | Glacier | Montana | 30035 | 2501 | 63 |
2037768 | 2037768 | 2021-12-22 | Marion | Arkansas | 5089 | 2501 | 69 |
2023996 | 2023996 | 2021-12-17 | Bandera | Texas | 48019 | 2501 | 64 |
2020745 | 2020745 | 2021-12-16 | Bandera | Texas | 48019 | 2501 | 64 |
2017728 | 2017728 | 2021-12-15 | Wilbarger | Texas | 48487 | 2501 | 69 |
2011461 | 2011461 | 2021-12-13 | Braxton | West Virginia | 54007 | 2501 | 27 |
2004988 | 2004988 | 2021-12-11 | Morgan | West Virginia | 54065 | 2501 | 51 |
1993190 | 1993190 | 2021-12-08 | Monroe | Kentucky | 21171 | 2501 | 65 |
1974958 | 1974958 | 2021-12-02 | Corozal | Puerto Rico | 72047 | 2501 | |
1970370 | 1970370 | 2021-12-01 | Butler | Kentucky | 21031 | 2501 | 41 |
1970713 | 1970713 | 2021-12-01 | Kanabec | Minnesota | 27065 | 2501 | 36 |
1971385 | 1971385 | 2021-12-01 | McKenzie | North Dakota | 38053 | 2501 | 22 |
1971709 | 1971709 | 2021-12-01 | Corozal | Puerto Rico | 72047 | 2501 | |
1965366 | 1965366 | 2021-11-29 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1962114 | 1962114 | 2021-11-28 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1958863 | 1958863 | 2021-11-27 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1955612 | 1955612 | 2021-11-26 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1952361 | 1952361 | 2021-11-25 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1949110 | 1949110 | 2021-11-24 | Oglala Lakota | South Dakota | 46102 | 2501 | 54 |
1929387 | 1929387 | 2021-11-18 | Fulton | Pennsylvania | 42057 | 2501 | 37 |
1930238 | 1930238 | 2021-11-18 | Taylor | West Virginia | 54091 | 2501 | 41 |
1923856 | 1923856 | 2021-11-17 | Clay | Alabama | 1027 | 2501 | 69 |
1920510 | 1920510 | 2021-11-15 | Crawford | Wisconsin | 55023 | 2501 | 23 |
1876943 | 1876943 | 2021-11-02 | Taos | New Mexico | 35055 | 2501 | 65 |
1873712 | 1873712 | 2021-11-01 | Essex | New York | 36031 | 2501 | 35 |
1858874 | 1858874 | 2021-10-28 | Crenshaw | Alabama | 1041 | 2501 | 75 |
1837689 | 1837689 | 2021-10-21 | Pike | Missouri | 29163 | 2501 | 37 |
1833414 | 1833414 | 2021-10-20 | Kauai | Hawaii | 15007 | 2501 | 9 |
1833928 | 1833928 | 2021-10-20 | Lewis | Kentucky | 21135 | 2501 | 55 |
1834631 | 1834631 | 2021-10-20 | Humboldt | Nevada | 32013 | 2501 | 27 |
1826444 | 1826444 | 2021-10-18 | North Slope Borough | Alaska | 2185 | 2501 | 6 |
1823195 | 1823195 | 2021-10-17 | North Slope Borough | Alaska | 2185 | 2501 | 6 |
1824075 | 1824075 | 2021-10-17 | Neosho | Kansas | 20133 | 2501 | 49 |
1819946 | 1819946 | 2021-10-16 | North Slope Borough | Alaska | 2185 | 2501 | 6 |
1820826 | 1820826 | 2021-10-16 | Neosho | Kansas | 20133 | 2501 | 49 |
1816697 | 1816697 | 2021-10-15 | North Slope Borough | Alaska | 2185 | 2501 | 6 |
1817577 | 1817577 | 2021-10-15 | Neosho | Kansas | 20133 | 2501 | 49 |
1812995 | 1812995 | 2021-10-13 | Zavala | Texas | 48507 | 2501 | 53 |
1809537 | 1809537 | 2021-10-12 | Colorado | Texas | 48089 | 2501 | 51 |
1788767 | 1788767 | 2021-10-06 | Roseau | Minnesota | 27135 | 2501 | 24 |
1764532 | 1764532 | 2021-09-28 | Adams | Wisconsin | 55001 | 2501 | 33 |
1759171 | 1759171 | 2021-09-27 | Garrard | Kentucky | 21079 | 2501 | 41 |
1760390 | 1760390 | 2021-09-27 | Wasco | Oregon | 41065 | 2501 | 39 |
1746693 | 1746693 | 2021-09-23 | Livingston | Missouri | 29117 | 2501 | 62 |
1700803 | 1700803 | 2021-09-09 | LaSalle | Louisiana | 22059 | 2501 | 41 |
1679882 | 1679882 | 2021-09-02 | Fredericksburg city | Virginia | 51630 | 2501 | 25 |
1671176 | 1671176 | 2021-08-31 | Orange | Indiana | 18117 | 2501 | 60 |
1664049 | 1664049 | 2021-08-29 | Cross | Arkansas | 5037 | 2501 | 57 |
1653987 | 1653987 | 2021-08-25 | Adams | Washington | 53001 | 2501 | 25 |
1636259 | 1636259 | 2021-08-20 | Perry | Missouri | 29157 | 2501 | 30 |
1610184 | 1610184 | 2021-08-12 | Tishomingo | Mississippi | 28141 | 2501 | 70 |
1595275 | 1595275 | 2021-08-07 | Reeves | Texas | 48389 | 2501 | 45 |
1588304 | 1588304 | 2021-08-05 | Canovanas | Puerto Rico | 72029 | 2501 | |
1565653 | 1565653 | 2021-07-29 | Fairfield | South Carolina | 45039 | 2501 | 83 |
1553938 | 1553938 | 2021-07-26 | Hart | Georgia | 13147 | 2501 | 56 |
1534224 | 1534224 | 2021-07-20 | Siskiyou | California | 6093 | 2501 | 40 |
1523655 | 1523655 | 2021-07-16 | Calhoun | Texas | 48057 | 2501 | 25 |
1520407 | 1520407 | 2021-07-15 | Calhoun | Texas | 48057 | 2501 | 25 |
1396013 | 1396013 | 2021-06-07 | Stone | Missouri | 29209 | 2501 | 47 |
1393543 | 1393543 | 2021-06-06 | Mayaguez | Puerto Rico | 72097 | 2501 | |
1385178 | 1385178 | 2021-06-04 | Pierce | Georgia | 13229 | 2501 | 55 |
1378687 | 1378687 | 2021-06-02 | Pierce | Georgia | 13229 | 2501 | 55 |
1375441 | 1375441 | 2021-06-01 | Pierce | Georgia | 13229 | 2501 | 55 |
1372196 | 1372196 | 2021-05-31 | Pierce | Georgia | 13229 | 2501 | 55 |
1368951 | 1368951 | 2021-05-30 | Pierce | Georgia | 13229 | 2501 | 55 |
1370812 | 1370812 | 2021-05-30 | Humacao | Puerto Rico | 72069 | 2501 | |
1365705 | 1365705 | 2021-05-29 | Pierce | Georgia | 13229 | 2501 | 55 |
1362459 | 1362459 | 2021-05-28 | Pierce | Georgia | 13229 | 2501 | 55 |
1361071 | 1361071 | 2021-05-27 | Gurabo | Puerto Rico | 72063 | 2501 | |
1347326 | 1347326 | 2021-05-23 | Stoddard | Missouri | 29207 | 2501 | 41 |
1342521 | 1342521 | 2021-05-22 | Marengo | Alabama | 1091 | 2501 | 65 |
1336026 | 1336026 | 2021-05-20 | Marengo | Alabama | 1091 | 2501 | 65 |
1328732 | 1328732 | 2021-05-17 | Hughes | South Dakota | 46065 | 2501 | 39 |
1307248 | 1307248 | 2021-05-11 | McDuffie | Georgia | 13189 | 2501 | 48 |
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);