ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where cases = 2968 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 19
- Texas 18
- South Dakota 14
- Indiana 11
- North Dakota 9
- Alabama 8
- Arkansas 8
- Georgia 8
- Mississippi 8
- Virginia 8
- California 7
- Michigan 7
- Louisiana 6
- Minnesota 6
- Ohio 6
- Kentucky 5
- South Carolina 5
- Tennessee 4
- Missouri 3
- Puerto Rico 3
- West Virginia 3
- Wisconsin 3
- Wyoming 3
- Colorado 2
- Florida 2
- Hawaii 2
- Illinois 2
- Nebraska 2
- Arizona 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463762 | 2463762 | 2022-05-02 | Coosa | Alabama | 1037 | 2968 | 58 |
2466003 | 2466003 | 2022-05-02 | Morrow | Oregon | 41049 | 2968 | 34 |
2460506 | 2460506 | 2022-05-01 | Coosa | Alabama | 1037 | 2968 | 58 |
2457250 | 2457250 | 2022-04-30 | Coosa | Alabama | 1037 | 2968 | 58 |
2453994 | 2453994 | 2022-04-29 | Coosa | Alabama | 1037 | 2968 | 58 |
2450738 | 2450738 | 2022-04-28 | Coosa | Alabama | 1037 | 2968 | 58 |
2447482 | 2447482 | 2022-04-27 | Coosa | Alabama | 1037 | 2968 | 58 |
2407148 | 2407148 | 2022-04-14 | Barnes | North Dakota | 38003 | 2968 | 47 |
2403892 | 2403892 | 2022-04-13 | Barnes | North Dakota | 38003 | 2968 | 47 |
2400637 | 2400637 | 2022-04-12 | Barnes | North Dakota | 38003 | 2968 | 47 |
2397382 | 2397382 | 2022-04-11 | Barnes | North Dakota | 38003 | 2968 | 47 |
2394127 | 2394127 | 2022-04-10 | Barnes | North Dakota | 38003 | 2968 | 47 |
2390871 | 2390871 | 2022-04-09 | Barnes | North Dakota | 38003 | 2968 | 47 |
2387615 | 2387615 | 2022-04-08 | Barnes | North Dakota | 38003 | 2968 | 47 |
2388018 | 2388018 | 2022-04-08 | Villalba | Puerto Rico | 72149 | 2968 | |
2355594 | 2355594 | 2022-03-29 | Todd | South Dakota | 46121 | 2968 | 52 |
2352341 | 2352341 | 2022-03-28 | Todd | South Dakota | 46121 | 2968 | 52 |
2349089 | 2349089 | 2022-03-27 | Todd | South Dakota | 46121 | 2968 | 52 |
2345836 | 2345836 | 2022-03-26 | Todd | South Dakota | 46121 | 2968 | 52 |
2342583 | 2342583 | 2022-03-25 | Todd | South Dakota | 46121 | 2968 | 52 |
2339330 | 2339330 | 2022-03-24 | Todd | South Dakota | 46121 | 2968 | 52 |
2336076 | 2336076 | 2022-03-23 | Todd | South Dakota | 46121 | 2968 | 52 |
2296525 | 2296525 | 2022-03-11 | Barnes | North Dakota | 38003 | 2968 | 47 |
2210196 | 2210196 | 2022-02-13 | Plumas | California | 6063 | 2968 | 13 |
2206943 | 2206943 | 2022-02-12 | Plumas | California | 6063 | 2968 | 13 |
2203690 | 2203690 | 2022-02-11 | Plumas | California | 6063 | 2968 | 13 |
2206618 | 2206618 | 2022-02-11 | Roane | West Virginia | 54087 | 2968 | 33 |
2199769 | 2199769 | 2022-02-09 | Nolan | Texas | 48353 | 2968 | 90 |
2171956 | 2171956 | 2022-02-01 | Breathitt | Kentucky | 21025 | 2968 | 49 |
2166471 | 2166471 | 2022-01-30 | Mountrail | North Dakota | 38061 | 2968 | 33 |
2146649 | 2146649 | 2022-01-24 | Otoe | Nebraska | 31131 | 2968 | 16 |
2130040 | 2130040 | 2022-01-19 | Sibley | Minnesota | 27143 | 2968 | 23 |
2118948 | 2118948 | 2022-01-16 | Washington | Alabama | 1129 | 2968 | 52 |
2110257 | 2110257 | 2022-01-13 | Bienville | Louisiana | 22013 | 2968 | 100 |
2107006 | 2107006 | 2022-01-12 | Bienville | Louisiana | 22013 | 2968 | 100 |
2103755 | 2103755 | 2022-01-11 | Bienville | Louisiana | 22013 | 2968 | 100 |
2057027 | 2057027 | 2021-12-27 | Crawford | Wisconsin | 55023 | 2968 | 24 |
2014829 | 2014829 | 2021-12-14 | Washburn | Wisconsin | 55129 | 2968 | 34 |
2011187 | 2011187 | 2021-12-13 | San Jacinto | Texas | 48407 | 2968 | 82 |
1986626 | 1986626 | 2021-12-06 | Casey | Kentucky | 21045 | 2968 | 59 |
1982484 | 1982484 | 2021-12-05 | Drew | Arkansas | 5043 | 2968 | 55 |
1981937 | 1981937 | 2021-12-04 | Shelby | Texas | 48419 | 2968 | 113 |
1973644 | 1973644 | 2021-12-02 | Garrard | Kentucky | 21079 | 2968 | 54 |
1975572 | 1975572 | 2021-12-02 | Fluvanna | Virginia | 51065 | 2968 | 29 |
1970877 | 1970877 | 2021-12-01 | Cooper | Missouri | 29053 | 2968 | 53 |
1969203 | 1969203 | 2021-11-30 | Barbour | West Virginia | 54001 | 2968 | 52 |
1946168 | 1946168 | 2021-11-23 | Robertson | Texas | 48395 | 2968 | 66 |
1942917 | 1942917 | 2021-11-22 | Robertson | Texas | 48395 | 2968 | 66 |
1939667 | 1939667 | 2021-11-21 | Robertson | Texas | 48395 | 2968 | 66 |
1936417 | 1936417 | 2021-11-20 | Robertson | Texas | 48395 | 2968 | 66 |
1933167 | 1933167 | 2021-11-19 | Robertson | Texas | 48395 | 2968 | 66 |
1929916 | 1929916 | 2021-11-18 | Robertson | Texas | 48395 | 2968 | 66 |
1926666 | 1926666 | 2021-11-17 | Robertson | Texas | 48395 | 2968 | 66 |
1921275 | 1921275 | 2021-11-16 | Richland | Illinois | 17159 | 2968 | 67 |
1921609 | 1921609 | 2021-11-16 | Breckinridge | Kentucky | 21027 | 2968 | 36 |
1894735 | 1894735 | 2021-11-08 | Hempstead | Arkansas | 5057 | 2968 | 41 |
1891485 | 1891485 | 2021-11-07 | Hempstead | Arkansas | 5057 | 2968 | 41 |
1888235 | 1888235 | 2021-11-06 | Hempstead | Arkansas | 5057 | 2968 | 40 |
1884404 | 1884404 | 2021-11-04 | Panola | Texas | 48365 | 2968 | 108 |
1884473 | 1884473 | 2021-11-04 | Young | Texas | 48503 | 2968 | 68 |
1859343 | 1859343 | 2021-10-28 | Meriwether | Georgia | 13199 | 2968 | 111 |
1824359 | 1824359 | 2021-10-17 | Alpena | Michigan | 26007 | 2968 | 69 |
1821110 | 1821110 | 2021-10-16 | Alpena | Michigan | 26007 | 2968 | 69 |
1817861 | 1817861 | 2021-10-15 | Alpena | Michigan | 26007 | 2968 | 69 |
1793879 | 1793879 | 2021-10-08 | Cherokee | Alabama | 1019 | 2968 | 57 |
1783025 | 1783025 | 2021-10-04 | Wyandot | Ohio | 39175 | 2968 | 58 |
1777817 | 1777817 | 2021-10-03 | Colusa | California | 6011 | 2968 | 18 |
1774567 | 1774567 | 2021-10-02 | Colusa | California | 6011 | 2968 | 18 |
1771317 | 1771317 | 2021-10-01 | Colusa | California | 6011 | 2968 | 18 |
1770247 | 1770247 | 2021-09-30 | Juncos | Puerto Rico | 72077 | 2968 | |
1757322 | 1757322 | 2021-09-26 | Hampton | South Carolina | 45049 | 2968 | 69 |
1754074 | 1754074 | 2021-09-25 | Hampton | South Carolina | 45049 | 2968 | 69 |
1750826 | 1750826 | 2021-09-24 | Hampton | South Carolina | 45049 | 2968 | 69 |
1745429 | 1745429 | 2021-09-23 | Pitkin | Colorado | 8097 | 2968 | 5 |
1739825 | 1739825 | 2021-09-21 | Aroostook | Maine | 23003 | 2968 | 71 |
1712794 | 1712794 | 2021-09-13 | Lawrence | Arkansas | 5075 | 2968 | 47 |
1715008 | 1715008 | 2021-09-13 | Gurabo | Puerto Rico | 72063 | 2968 | |
1715689 | 1715689 | 2021-09-13 | Staunton city | Virginia | 51790 | 2968 | 73 |
1712048 | 1712048 | 2021-09-12 | Burleson | Texas | 48051 | 2968 | 55 |
1708801 | 1708801 | 2021-09-11 | Burleson | Texas | 48051 | 2968 | 55 |
1705536 | 1705536 | 2021-09-10 | Austin | Texas | 48015 | 2968 | 45 |
1673856 | 1673856 | 2021-09-01 | Del Norte | California | 6015 | 2968 | 23 |
1649968 | 1649968 | 2021-08-24 | Elk | Pennsylvania | 42047 | 2968 | 42 |
1626341 | 1626341 | 2021-08-17 | Todd | Minnesota | 27153 | 2968 | 33 |
1604357 | 1604357 | 2021-08-10 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1604419 | 1604419 | 2021-08-10 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1601108 | 1601108 | 2021-08-09 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1601170 | 1601170 | 2021-08-09 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1597860 | 1597860 | 2021-08-08 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1597922 | 1597922 | 2021-08-08 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1594611 | 1594611 | 2021-08-07 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1594673 | 1594673 | 2021-08-07 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1591362 | 1591362 | 2021-08-06 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1591424 | 1591424 | 2021-08-06 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1588113 | 1588113 | 2021-08-05 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1588175 | 1588175 | 2021-08-05 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1584863 | 1584863 | 2021-08-04 | Beckham | Oklahoma | 40009 | 2968 | 58 |
1584925 | 1584925 | 2021-08-04 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1578970 | 1578970 | 2021-08-02 | Kleberg | Texas | 48273 | 2968 | 95 |
1573439 | 1573439 | 2021-08-01 | Lee | Georgia | 13177 | 2968 | 59 |
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);