ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where cases = 3563 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 13
- Georgia 10
- Mississippi 9
- Arkansas 7
- Kansas 7
- California 6
- Illinois 6
- New York 6
- Virginia 6
- Kentucky 5
- Alaska 4
- Louisiana 4
- Tennessee 4
- Alabama 3
- Missouri 3
- Puerto Rico 3
- Minnesota 2
- Nebraska 2
- New Hampshire 2
- North Carolina 2
- Ohio 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- Colorado 1
- Florida 1
- Idaho 1
- Indiana 1
- Maine 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491163 | 2491163 | 2022-05-10 | Kanabec | Minnesota | 27065 | 3563 | 57 |
2449875 | 2449875 | 2022-04-27 | Utuado | Puerto Rico | 72141 | 3563 | |
2292826 | 2292826 | 2022-03-10 | Madison | Missouri | 29123 | 3563 | 52 |
2287694 | 2287694 | 2022-03-08 | Alleghany | Virginia | 51005 | 3563 | 94 |
2279711 | 2279711 | 2022-03-06 | Lawrence | Mississippi | 28077 | 3563 | 55 |
2276458 | 2276458 | 2022-03-05 | Lawrence | Mississippi | 28077 | 3563 | 55 |
2273205 | 2273205 | 2022-03-04 | Lawrence | Mississippi | 28077 | 3563 | 55 |
2263699 | 2263699 | 2022-03-01 | Gage | Nebraska | 31067 | 3563 | 37 |
2223063 | 2223063 | 2022-02-17 | Kusilvak Census Area | Alaska | 2158 | 3563 | 10 |
2225024 | 2225024 | 2022-02-17 | Ramsey | North Dakota | 38071 | 3563 | 54 |
2219812 | 2219812 | 2022-02-16 | Kusilvak Census Area | Alaska | 2158 | 3563 | 10 |
2218040 | 2218040 | 2022-02-15 | Macon | Missouri | 29121 | 3563 | 48 |
2219669 | 2219669 | 2022-02-15 | Lafayette | Wisconsin | 55065 | 3563 | 21 |
2212354 | 2212354 | 2022-02-13 | Lares | Puerto Rico | 72081 | 3563 | |
2213084 | 2213084 | 2022-02-13 | Braxton | West Virginia | 54007 | 3563 | 37 |
2206144 | 2206144 | 2022-02-11 | Colorado | Texas | 48089 | 3563 | 58 |
2151077 | 2151077 | 2022-01-25 | Addison | Vermont | 50001 | 3563 | 13 |
2147557 | 2147557 | 2022-01-24 | Bosque | Texas | 48035 | 3563 | 60 |
2080490 | 2080490 | 2022-01-04 | Edgar | Illinois | 17045 | 3563 | 74 |
2076739 | 2076739 | 2022-01-03 | Conway | Arkansas | 5029 | 3563 | 48 |
2063334 | 2063334 | 2021-12-29 | Fredericksburg city | Virginia | 51630 | 3563 | 27 |
2054253 | 2054253 | 2021-12-27 | Appling | Georgia | 13001 | 3563 | 108 |
2027964 | 2027964 | 2021-12-19 | La Paz | Arizona | 4012 | 3563 | 105 |
2006999 | 2006999 | 2021-12-12 | Seneca | New York | 36099 | 3563 | 71 |
2001966 | 2001966 | 2021-12-11 | Arkansas | Arkansas | 5001 | 3563 | 62 |
1927736 | 1927736 | 2021-11-18 | Jersey | Illinois | 17083 | 3563 | 73 |
1929807 | 1929807 | 2021-11-18 | Gonzales | Texas | 48177 | 3563 | 85 |
1926557 | 1926557 | 2021-11-17 | Gonzales | Texas | 48177 | 3563 | 85 |
1875562 | 1875562 | 2021-11-02 | Hart | Georgia | 13147 | 3563 | 69 |
1872313 | 1872313 | 2021-11-01 | Hart | Georgia | 13147 | 3563 | 68 |
1846961 | 1846961 | 2021-10-24 | Rowan | Kentucky | 21205 | 3563 | 28 |
1843711 | 1843711 | 2021-10-23 | Rowan | Kentucky | 21205 | 3563 | 28 |
1840461 | 1840461 | 2021-10-22 | Rowan | Kentucky | 21205 | 3563 | 28 |
1839292 | 1839292 | 2021-10-21 | Kewaunee | Wisconsin | 55061 | 3563 | 41 |
1829612 | 1829612 | 2021-10-19 | Barbour | Alabama | 1005 | 3563 | 76 |
1824598 | 1824598 | 2021-10-17 | Tishomingo | Mississippi | 28141 | 3563 | 91 |
1826129 | 1826129 | 2021-10-17 | Orange | Virginia | 51137 | 3563 | 51 |
1821349 | 1821349 | 2021-10-16 | Tishomingo | Mississippi | 28141 | 3563 | 91 |
1822880 | 1822880 | 2021-10-16 | Orange | Virginia | 51137 | 3563 | 51 |
1818100 | 1818100 | 2021-10-15 | Tishomingo | Mississippi | 28141 | 3563 | 91 |
1819631 | 1819631 | 2021-10-15 | Orange | Virginia | 51137 | 3563 | 51 |
1815059 | 1815059 | 2021-10-14 | Dawson | Nebraska | 31047 | 3563 | 33 |
1812670 | 1812670 | 2021-10-13 | Fentress | Tennessee | 47049 | 3563 | 62 |
1787808 | 1787808 | 2021-10-06 | Dodge | Georgia | 13091 | 3563 | 122 |
1786895 | 1786895 | 2021-10-05 | Limestone | Texas | 48293 | 3563 | 104 |
1781302 | 1781302 | 2021-10-04 | Cook | Georgia | 13075 | 3563 | 56 |
1782000 | 1782000 | 2021-10-04 | Assumption | Louisiana | 22007 | 3563 | 57 |
1783574 | 1783574 | 2021-10-04 | Fayette | Texas | 48149 | 3563 | 88 |
1774497 | 1774497 | 2021-10-02 | Cleburne | Arkansas | 5023 | 3563 | 88 |
1762599 | 1762599 | 2021-09-28 | Queen Anne's | Maryland | 24035 | 3563 | 64 |
1626367 | 1626367 | 2021-08-17 | Copiah | Mississippi | 28029 | 3563 | 70 |
1572119 | 1572119 | 2021-07-31 | Vega Baja | Puerto Rico | 72145 | 3563 | |
1541444 | 1541444 | 2021-07-22 | Montgomery | Kansas | 20125 | 3563 | 84 |
1538197 | 1538197 | 2021-07-21 | Montgomery | Kansas | 20125 | 3563 | 84 |
1533306 | 1533306 | 2021-07-19 | Hardeman | Tennessee | 47069 | 3563 | 64 |
1520628 | 1520628 | 2021-07-15 | Wood | Texas | 48499 | 3563 | 129 |
1517380 | 1517380 | 2021-07-14 | Wood | Texas | 48499 | 3563 | 129 |
1517614 | 1517614 | 2021-07-14 | Fayette | West Virginia | 54019 | 3563 | 80 |
1514133 | 1514133 | 2021-07-13 | Wood | Texas | 48499 | 3563 | 129 |
1509861 | 1509861 | 2021-07-12 | Allegany | New York | 36003 | 3563 | 87 |
1506614 | 1506614 | 2021-07-11 | Allegany | New York | 36003 | 3563 | 87 |
1503368 | 1503368 | 2021-07-10 | Allegany | New York | 36003 | 3563 | 87 |
1500122 | 1500122 | 2021-07-09 | Allegany | New York | 36003 | 3563 | 87 |
1443300 | 1443300 | 2021-06-22 | Lake | California | 6033 | 3563 | 45 |
1440055 | 1440055 | 2021-06-21 | Lake | California | 6033 | 3563 | 45 |
1436808 | 1436808 | 2021-06-20 | Lake | California | 6033 | 3563 | 45 |
1433561 | 1433561 | 2021-06-19 | Lake | California | 6033 | 3563 | 45 |
1430315 | 1430315 | 2021-06-18 | Lake | California | 6033 | 3563 | 45 |
1427793 | 1427793 | 2021-06-17 | Geary | Kansas | 20061 | 3563 | 41 |
1424548 | 1424548 | 2021-06-16 | Geary | Kansas | 20061 | 3563 | 41 |
1415425 | 1415425 | 2021-06-13 | Howell | Missouri | 29091 | 3563 | 45 |
1405165 | 1405165 | 2021-06-10 | Calloway | Kentucky | 21035 | 3563 | 49 |
1321843 | 1321843 | 2021-05-15 | Highland | Ohio | 39071 | 3563 | 62 |
1308659 | 1308659 | 2021-05-11 | Warren | New York | 36113 | 3563 | 57 |
1303524 | 1303524 | 2021-05-10 | Chambers | Alabama | 1017 | 3563 | 123 |
1300277 | 1300277 | 2021-05-09 | Chambers | Alabama | 1017 | 3563 | 123 |
1285819 | 1285819 | 2021-05-04 | Cheshire | New Hampshire | 33005 | 3563 | 33 |
1278911 | 1278911 | 2021-05-02 | Lyon | Minnesota | 27083 | 3563 | 50 |
1253880 | 1253880 | 2021-04-24 | Perry | Pennsylvania | 42099 | 3563 | 98 |
1251175 | 1251175 | 2021-04-23 | Uvalde | Texas | 48463 | 3563 | 72 |
1247928 | 1247928 | 2021-04-22 | Uvalde | Texas | 48463 | 3563 | 72 |
1244681 | 1244681 | 2021-04-21 | Uvalde | Texas | 48463 | 3563 | 72 |
1238984 | 1238984 | 2021-04-20 | Bryan | Georgia | 13029 | 3563 | 37 |
1240364 | 1240364 | 2021-04-20 | Grafton | New Hampshire | 33009 | 3563 | 25 |
1235737 | 1235737 | 2021-04-19 | Bryan | Georgia | 13029 | 3563 | 37 |
1221675 | 1221675 | 2021-04-14 | Macon | Tennessee | 47111 | 3563 | 76 |
1210004 | 1210004 | 2021-04-11 | Logan | Illinois | 17107 | 3563 | 68 |
1210285 | 1210285 | 2021-04-11 | Harvey | Kansas | 20079 | 3563 | 66 |
1206405 | 1206405 | 2021-04-10 | Summit | Colorado | 8117 | 3563 | 7 |
1207036 | 1207036 | 2021-04-10 | Harvey | Kansas | 20079 | 3563 | 66 |
1203788 | 1203788 | 2021-04-09 | Harvey | Kansas | 20079 | 3563 | 66 |
1122338 | 1122338 | 2021-03-15 | Montgomery | Illinois | 17135 | 3563 | 77 |
1122465 | 1122465 | 2021-03-15 | Whitley | Indiana | 18183 | 3563 | 39 |
1122815 | 1122815 | 2021-03-15 | Iberville | Louisiana | 22047 | 3563 | 92 |
1119568 | 1119568 | 2021-03-14 | Iberville | Louisiana | 22047 | 3563 | 92 |
1091139 | 1091139 | 2021-03-05 | Davie | North Carolina | 37059 | 3563 | 31 |
1076295 | 1076295 | 2021-03-01 | Bethel Census Area | Alaska | 2050 | 3563 | 19 |
1031120 | 1031120 | 2021-02-15 | DeSoto | Florida | 12027 | 3563 | 71 |
1023612 | 1023612 | 2021-02-12 | Henderson | Tennessee | 47077 | 3563 | 69 |
1017983 | 1017983 | 2021-02-11 | Union | Arkansas | 5139 | 3563 | 97 |
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);