ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 3143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Michigan 21
- Florida 10
- South Carolina 9
- Alabama 8
- Iowa 7
- Kansas 7
- Minnesota 7
- Tennessee 7
- Texas 7
- West Virginia 6
- Colorado 5
- Illinois 5
- Virginia 5
- Oklahoma 4
- Arkansas 3
- Indiana 3
- Kentucky 3
- Louisiana 3
- Mississippi 3
- Missouri 3
- Pennsylvania 3
- Idaho 2
- New York 2
- North Carolina 2
- North Dakota 2
- Ohio 2
- Oregon 2
- South Dakota 2
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483755 | 2483755 | 2022-05-08 | Jasper | Georgia | 13159 | 3143 | 72 |
2480497 | 2480497 | 2022-05-07 | Jasper | Georgia | 13159 | 3143 | 72 |
2477239 | 2477239 | 2022-05-06 | Jasper | Georgia | 13159 | 3143 | 72 |
2473981 | 2473981 | 2022-05-05 | Jasper | Georgia | 13159 | 3143 | 72 |
2470724 | 2470724 | 2022-05-04 | Jasper | Georgia | 13159 | 3143 | 72 |
2300112 | 2300112 | 2022-03-12 | Barceloneta | Puerto Rico | 72017 | 3143 | |
2205509 | 2205509 | 2022-02-11 | Mountrail | North Dakota | 38061 | 3143 | 34 |
2202966 | 2202966 | 2022-02-10 | Jackson | Texas | 48239 | 3143 | 55 |
2179544 | 2179544 | 2022-02-03 | Harrison | Ohio | 39067 | 3143 | 66 |
2152478 | 2152478 | 2022-01-26 | Knott | Kentucky | 21119 | 3143 | 51 |
2132165 | 2132165 | 2022-01-20 | Grand | Colorado | 8049 | 3143 | 20 |
2096019 | 2096019 | 2022-01-08 | Taylor | West Virginia | 54091 | 3143 | 52 |
2040219 | 2040219 | 2021-12-22 | Sequatchie | Tennessee | 47153 | 3143 | 46 |
2013016 | 2013016 | 2021-12-14 | Wadena | Minnesota | 27159 | 3143 | 43 |
1998241 | 1998241 | 2021-12-09 | Duchesne | Utah | 49013 | 3143 | 21 |
1992653 | 1992653 | 2021-12-08 | Worth | Georgia | 13321 | 3143 | 95 |
1990280 | 1990280 | 2021-12-07 | Clay | Mississippi | 28025 | 3143 | 78 |
1982755 | 1982755 | 2021-12-05 | Brantley | Georgia | 13025 | 3143 | 90 |
1979505 | 1979505 | 2021-12-04 | Brantley | Georgia | 13025 | 3143 | 90 |
1976255 | 1976255 | 2021-12-03 | Brantley | Georgia | 13025 | 3143 | 90 |
1973006 | 1973006 | 2021-12-02 | Brantley | Georgia | 13025 | 3143 | 90 |
1969756 | 1969756 | 2021-12-01 | Brantley | Georgia | 13025 | 3143 | 90 |
1966506 | 1966506 | 2021-11-30 | Brantley | Georgia | 13025 | 3143 | 88 |
1963254 | 1963254 | 2021-11-29 | Brantley | Georgia | 13025 | 3143 | 88 |
1962394 | 1962394 | 2021-11-28 | Montague | Texas | 48337 | 3143 | 96 |
1959143 | 1959143 | 2021-11-27 | Montague | Texas | 48337 | 3143 | 96 |
1955892 | 1955892 | 2021-11-26 | Montague | Texas | 48337 | 3143 | 96 |
1952641 | 1952641 | 2021-11-25 | Montague | Texas | 48337 | 3143 | 96 |
1949390 | 1949390 | 2021-11-24 | Montague | Texas | 48337 | 3143 | 96 |
1927856 | 1927856 | 2021-11-18 | Orange | Indiana | 18117 | 3143 | 74 |
1926964 | 1926964 | 2021-11-17 | Lincoln | West Virginia | 54043 | 3143 | 49 |
1884878 | 1884878 | 2021-11-05 | Hale | Alabama | 1065 | 3143 | 88 |
1878380 | 1878380 | 2021-11-03 | Hale | Alabama | 1065 | 3143 | 89 |
1868895 | 1868895 | 2021-10-31 | Pitkin | Colorado | 8097 | 3143 | 5 |
1865646 | 1865646 | 2021-10-30 | Pitkin | Colorado | 8097 | 3143 | 5 |
1862136 | 1862136 | 2021-10-29 | Henry | Alabama | 1067 | 3143 | 66 |
1862397 | 1862397 | 2021-10-29 | Pitkin | Colorado | 8097 | 3143 | 5 |
1858887 | 1858887 | 2021-10-28 | Henry | Alabama | 1067 | 3143 | 66 |
1859445 | 1859445 | 2021-10-28 | Minidoka | Idaho | 16067 | 3143 | 45 |
1860101 | 1860101 | 2021-10-28 | Alpena | Michigan | 26007 | 3143 | 73 |
1861468 | 1861468 | 2021-10-28 | Unicoi | Tennessee | 47171 | 3143 | 65 |
1856852 | 1856852 | 2021-10-27 | Alpena | Michigan | 26007 | 3143 | 73 |
1830389 | 1830389 | 2021-10-19 | Starke | Indiana | 18149 | 3143 | 71 |
1815963 | 1815963 | 2021-10-14 | Polk | Tennessee | 47139 | 3143 | 29 |
1788781 | 1788781 | 2021-10-06 | Waseca | Minnesota | 27161 | 3143 | 26 |
1765168 | 1765168 | 2021-09-29 | Washington | Georgia | 13303 | 3143 | 108 |
1763323 | 1763323 | 2021-09-28 | Greene | North Carolina | 37079 | 3143 | 53 |
1760593 | 1760593 | 2021-09-27 | Beadle | South Dakota | 46005 | 3143 | 43 |
1757926 | 1757926 | 2021-09-26 | Staunton city | Virginia | 51790 | 3143 | 76 |
1754678 | 1754678 | 2021-09-25 | Staunton city | Virginia | 51790 | 3143 | 76 |
1751430 | 1751430 | 2021-09-24 | Staunton city | Virginia | 51790 | 3143 | 76 |
1740403 | 1740403 | 2021-09-21 | Churchill | Nevada | 32001 | 3143 | 55 |
1722880 | 1722880 | 2021-09-16 | Mitchell | Georgia | 13205 | 3143 | 95 |
1715583 | 1715583 | 2021-09-13 | Botetourt | Virginia | 51023 | 3143 | 39 |
1710300 | 1710300 | 2021-09-12 | Barton | Kansas | 20009 | 3143 | 51 |
1707053 | 1707053 | 2021-09-11 | Barton | Kansas | 20009 | 3143 | 51 |
1703805 | 1703805 | 2021-09-10 | Barton | Kansas | 20009 | 3143 | 51 |
1701073 | 1701073 | 2021-09-09 | Attala | Mississippi | 28007 | 3143 | 83 |
1694730 | 1694730 | 2021-09-07 | Nodaway | Missouri | 29147 | 3143 | 31 |
1693022 | 1693022 | 2021-09-06 | Hancock | West Virginia | 54029 | 3143 | 92 |
1677071 | 1677071 | 2021-09-02 | Ouachita | Arkansas | 5103 | 3143 | 68 |
1677260 | 1677260 | 2021-09-02 | Holmes | Florida | 12059 | 3143 | 49 |
1674013 | 1674013 | 2021-09-01 | Holmes | Florida | 12059 | 3143 | 49 |
1670765 | 1670765 | 2021-08-31 | Holmes | Florida | 12059 | 3143 | 49 |
1671262 | 1671262 | 2021-08-31 | Jones | Iowa | 19105 | 3143 | 57 |
1667518 | 1667518 | 2021-08-30 | Holmes | Florida | 12059 | 3143 | 49 |
1668015 | 1668015 | 2021-08-30 | Jones | Iowa | 19105 | 3143 | 57 |
1664271 | 1664271 | 2021-08-29 | Holmes | Florida | 12059 | 3143 | 49 |
1664768 | 1664768 | 2021-08-29 | Jones | Iowa | 19105 | 3143 | 57 |
1661023 | 1661023 | 2021-08-28 | Holmes | Florida | 12059 | 3143 | 49 |
1661520 | 1661520 | 2021-08-28 | Jones | Iowa | 19105 | 3143 | 57 |
1657775 | 1657775 | 2021-08-27 | Holmes | Florida | 12059 | 3143 | 49 |
1658272 | 1658272 | 2021-08-27 | Jones | Iowa | 19105 | 3143 | 57 |
1655024 | 1655024 | 2021-08-26 | Jones | Iowa | 19105 | 3143 | 57 |
1651777 | 1651777 | 2021-08-25 | Jones | Iowa | 19105 | 3143 | 57 |
1653161 | 1653161 | 2021-08-25 | Coos | Oregon | 41011 | 3143 | 49 |
1633959 | 1633959 | 2021-08-19 | Yankton | South Dakota | 46135 | 3143 | 33 |
1626158 | 1626158 | 2021-08-17 | Queen Anne's | Maryland | 24035 | 3143 | 55 |
1619401 | 1619401 | 2021-08-15 | Miami | Kansas | 20121 | 3143 | 44 |
1616153 | 1616153 | 2021-08-14 | Miami | Kansas | 20121 | 3143 | 44 |
1612904 | 1612904 | 2021-08-13 | Miami | Kansas | 20121 | 3143 | 44 |
1588553 | 1588553 | 2021-08-05 | Overton | Tennessee | 47133 | 3143 | 62 |
1573412 | 1573412 | 2021-08-01 | Gilmer | Georgia | 13123 | 3143 | 91 |
1570164 | 1570164 | 2021-07-31 | Gilmer | Georgia | 13123 | 3143 | 91 |
1572036 | 1572036 | 2021-07-31 | Tioga | Pennsylvania | 42117 | 3143 | 112 |
1566916 | 1566916 | 2021-07-30 | Gilmer | Georgia | 13123 | 3143 | 91 |
1568346 | 1568346 | 2021-07-30 | Orleans | New York | 36073 | 3143 | 83 |
1568788 | 1568788 | 2021-07-30 | Tioga | Pennsylvania | 42117 | 3143 | 112 |
1565098 | 1565098 | 2021-07-29 | Orleans | New York | 36073 | 3143 | 83 |
1565540 | 1565540 | 2021-07-29 | Tioga | Pennsylvania | 42117 | 3143 | 112 |
1557876 | 1557876 | 2021-07-27 | Morehouse | Louisiana | 22067 | 3143 | 79 |
1538612 | 1538612 | 2021-07-21 | Mille Lacs | Minnesota | 27095 | 3143 | 56 |
1532016 | 1532016 | 2021-07-19 | Houghton | Michigan | 26061 | 3143 | 43 |
1528769 | 1528769 | 2021-07-18 | Houghton | Michigan | 26061 | 3143 | 43 |
1525522 | 1525522 | 2021-07-17 | Houghton | Michigan | 26061 | 3143 | 43 |
1522275 | 1522275 | 2021-07-16 | Houghton | Michigan | 26061 | 3143 | 43 |
1519026 | 1519026 | 2021-07-15 | Houghton | Michigan | 26061 | 3143 | 43 |
1515779 | 1515779 | 2021-07-14 | Houghton | Michigan | 26061 | 3143 | 43 |
1512533 | 1512533 | 2021-07-13 | Houghton | Michigan | 26061 | 3143 | 43 |
1509286 | 1509286 | 2021-07-12 | Houghton | Michigan | 26061 | 3143 | 43 |
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);