ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 3735 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 14
- Texas 11
- Minnesota 10
- Ohio 10
- Alabama 9
- Indiana 8
- Oklahoma 8
- West Virginia 7
- Arkansas 6
- Georgia 5
- Pennsylvania 5
- Colorado 4
- Mississippi 4
- Missouri 4
- Vermont 4
- Nebraska 3
- New Mexico 3
- New York 3
- Oregon 3
- South Carolina 3
- Tennessee 3
- Wisconsin 3
- Idaho 2
- Illinois 2
- Kansas 2
- Michigan 2
- Montana 2
- Alaska 1
- California 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496381 | 2496381 | 2022-05-12 | Washington | Alabama | 1129 | 3735 | 59 |
2493123 | 2493123 | 2022-05-11 | Washington | Alabama | 1129 | 3735 | 59 |
2486581 | 2486581 | 2022-05-09 | Lamar | Alabama | 1075 | 3735 | 65 |
2483323 | 2483323 | 2022-05-08 | Lamar | Alabama | 1075 | 3735 | 65 |
2480065 | 2480065 | 2022-05-07 | Lamar | Alabama | 1075 | 3735 | 65 |
2476807 | 2476807 | 2022-05-06 | Lamar | Alabama | 1075 | 3735 | 65 |
2461255 | 2461255 | 2022-05-01 | Pike | Indiana | 18125 | 3735 | 49 |
2462752 | 2462752 | 2022-05-01 | Tillamook | Oregon | 41057 | 3735 | 64 |
2463487 | 2463487 | 2022-05-01 | King William | Virginia | 51101 | 3735 | 44 |
2457999 | 2457999 | 2022-04-30 | Pike | Indiana | 18125 | 3735 | 49 |
2459496 | 2459496 | 2022-04-30 | Tillamook | Oregon | 41057 | 3735 | 64 |
2460231 | 2460231 | 2022-04-30 | King William | Virginia | 51101 | 3735 | 44 |
2454743 | 2454743 | 2022-04-29 | Pike | Indiana | 18125 | 3735 | 49 |
2456240 | 2456240 | 2022-04-29 | Tillamook | Oregon | 41057 | 3735 | 64 |
2456975 | 2456975 | 2022-04-29 | King William | Virginia | 51101 | 3735 | 44 |
2403274 | 2403274 | 2022-04-13 | Renville | Minnesota | 27129 | 3735 | 56 |
2404260 | 2404260 | 2022-04-13 | Lares | Puerto Rico | 72081 | 3735 | |
2400020 | 2400020 | 2022-04-12 | Renville | Minnesota | 27129 | 3735 | 56 |
2312126 | 2312126 | 2022-03-16 | Faribault | Minnesota | 27043 | 3735 | 50 |
2302526 | 2302526 | 2022-03-13 | Bates | Missouri | 29013 | 3735 | 89 |
2299274 | 2299274 | 2022-03-12 | Bates | Missouri | 29013 | 3735 | 89 |
2296022 | 2296022 | 2022-03-11 | Bates | Missouri | 29013 | 3735 | 89 |
2290713 | 2290713 | 2022-03-09 | Falls | Texas | 48145 | 3735 | 63 |
2248852 | 2248852 | 2022-02-24 | Grant | West Virginia | 54023 | 3735 | 55 |
2240255 | 2240255 | 2022-02-22 | Butler | Kentucky | 21031 | 3735 | 49 |
2236121 | 2236121 | 2022-02-21 | Franklin | Arkansas | 5047 | 3735 | 68 |
2234579 | 2234579 | 2022-02-20 | Socorro | New Mexico | 35053 | 3735 | 84 |
2231328 | 2231328 | 2022-02-19 | Socorro | New Mexico | 35053 | 3735 | 84 |
2226825 | 2226825 | 2022-02-18 | Minidoka | Idaho | 16067 | 3735 | 56 |
2228077 | 2228077 | 2022-02-18 | Socorro | New Mexico | 35053 | 3735 | 84 |
2170334 | 2170334 | 2022-01-31 | Bosque | Texas | 48035 | 3735 | 62 |
2146529 | 2146529 | 2022-01-24 | Big Horn | Montana | 30003 | 3735 | 87 |
2118427 | 2118427 | 2022-01-15 | Montague | Texas | 48337 | 3735 | 104 |
2083794 | 2083794 | 2022-01-05 | Pike | Illinois | 17149 | 3735 | 62 |
2076286 | 2076286 | 2022-01-02 | Windham | Vermont | 50025 | 3735 | 30 |
2076325 | 2076325 | 2022-01-02 | Dinwiddie | Virginia | 51053 | 3735 | 62 |
2073035 | 2073035 | 2022-01-01 | Windham | Vermont | 50025 | 3735 | 30 |
2073074 | 2073074 | 2022-01-01 | Dinwiddie | Virginia | 51053 | 3735 | 62 |
2069784 | 2069784 | 2021-12-31 | Windham | Vermont | 50025 | 3735 | 30 |
2069823 | 2069823 | 2021-12-31 | Dinwiddie | Virginia | 51053 | 3735 | 62 |
2066493 | 2066493 | 2021-12-30 | Carbon | Utah | 49007 | 3735 | 41 |
2066533 | 2066533 | 2021-12-30 | Windham | Vermont | 50025 | 3735 | 30 |
2044114 | 2044114 | 2021-12-24 | Barbour | Alabama | 1005 | 3735 | 81 |
1998572 | 1998572 | 2021-12-09 | Vernon | Wisconsin | 55123 | 3735 | 69 |
1975422 | 1975422 | 2021-12-02 | Reeves | Texas | 48389 | 3735 | 59 |
1969505 | 1969505 | 2021-12-01 | Logan | Arkansas | 5083 | 3735 | 52 |
1921861 | 1921861 | 2021-11-16 | Emmet | Michigan | 26047 | 3735 | 53 |
1919898 | 1919898 | 2021-11-15 | Fentress | Tennessee | 47049 | 3735 | 68 |
1894403 | 1894403 | 2021-11-07 | Winchester city | Virginia | 51840 | 3735 | 55 |
1891153 | 1891153 | 2021-11-06 | Winchester city | Virginia | 51840 | 3735 | 55 |
1887903 | 1887903 | 2021-11-05 | Winchester city | Virginia | 51840 | 3735 | 55 |
1878116 | 1878116 | 2021-11-02 | Orange | Virginia | 51137 | 3735 | 58 |
1873287 | 1873287 | 2021-11-01 | Grenada | Mississippi | 28043 | 3735 | 108 |
1871733 | 1871733 | 2021-10-31 | Nicholas | West Virginia | 54067 | 3735 | 48 |
1860548 | 1860548 | 2021-10-28 | Dawson | Nebraska | 31047 | 3735 | 33 |
1861333 | 1861333 | 2021-10-28 | Davison | South Dakota | 46035 | 3735 | 70 |
1857299 | 1857299 | 2021-10-27 | Dawson | Nebraska | 31047 | 3735 | 33 |
1836515 | 1836515 | 2021-10-21 | Burke | Georgia | 13033 | 3735 | 83 |
1826934 | 1826934 | 2021-10-18 | Cassia | Idaho | 16031 | 3735 | 34 |
1791083 | 1791083 | 2021-10-07 | Haralson | Georgia | 13143 | 3735 | 109 |
1753515 | 1753515 | 2021-09-25 | Orleans | New York | 36073 | 3735 | 84 |
1722277 | 1722277 | 2021-09-15 | Preston | West Virginia | 54077 | 3735 | 54 |
1711858 | 1711858 | 2021-09-12 | Union | South Carolina | 45087 | 3735 | 84 |
1708611 | 1708611 | 2021-09-11 | Union | South Carolina | 45087 | 3735 | 84 |
1705364 | 1705364 | 2021-09-10 | Union | South Carolina | 45087 | 3735 | 84 |
1675122 | 1675122 | 2021-09-01 | Marion | Mississippi | 28091 | 3735 | 92 |
1672983 | 1672983 | 2021-08-31 | Hickman | Tennessee | 47081 | 3735 | 50 |
1673175 | 1673175 | 2021-08-31 | Kleberg | Texas | 48273 | 3735 | 103 |
1632928 | 1632928 | 2021-08-19 | Yazoo | Mississippi | 28163 | 3735 | 80 |
1607770 | 1607770 | 2021-08-11 | Snyder | Pennsylvania | 42109 | 3735 | 86 |
1598813 | 1598813 | 2021-08-08 | Fayette | West Virginia | 54019 | 3735 | 84 |
1595564 | 1595564 | 2021-08-07 | Fayette | West Virginia | 54019 | 3735 | 84 |
1591304 | 1591304 | 2021-08-06 | Highland | Ohio | 39071 | 3735 | 68 |
1592315 | 1592315 | 2021-08-06 | Fayette | West Virginia | 54019 | 3735 | 84 |
1576997 | 1576997 | 2021-08-02 | Wabash | Indiana | 18169 | 3735 | 84 |
1578773 | 1578773 | 2021-08-02 | Hardin | Tennessee | 47071 | 3735 | 69 |
1496571 | 1496571 | 2021-07-08 | Howell | Missouri | 29091 | 3735 | 47 |
1448462 | 1448462 | 2021-06-23 | Ottawa | Ohio | 39123 | 3735 | 81 |
1445217 | 1445217 | 2021-06-22 | Ottawa | Ohio | 39123 | 3735 | 81 |
1428987 | 1428987 | 2021-06-17 | Ottawa | Ohio | 39123 | 3735 | 81 |
1425742 | 1425742 | 2021-06-16 | Ottawa | Ohio | 39123 | 3735 | 81 |
1375242 | 1375242 | 2021-06-01 | Summit | Colorado | 8117 | 3735 | 8 |
1371997 | 1371997 | 2021-05-31 | Summit | Colorado | 8117 | 3735 | 8 |
1374539 | 1374539 | 2021-05-31 | Titus | Texas | 48449 | 3735 | 84 |
1368752 | 1368752 | 2021-05-30 | Summit | Colorado | 8117 | 3735 | 8 |
1371294 | 1371294 | 2021-05-30 | Titus | Texas | 48449 | 3735 | 84 |
1365506 | 1365506 | 2021-05-29 | Summit | Colorado | 8117 | 3735 | 8 |
1368048 | 1368048 | 2021-05-29 | Titus | Texas | 48449 | 3735 | 84 |
1364802 | 1364802 | 2021-05-28 | Titus | Texas | 48449 | 3735 | 84 |
1337876 | 1337876 | 2021-05-20 | Tioga | New York | 36107 | 3735 | 62 |
1333479 | 1333479 | 2021-05-19 | Knox | Indiana | 18083 | 3735 | 90 |
1335791 | 1335791 | 2021-05-19 | York | Virginia | 51199 | 3735 | 54 |
1311175 | 1311175 | 2021-05-12 | St. John the Baptist | Louisiana | 22095 | 3735 | 138 |
1284958 | 1284958 | 2021-05-04 | Ellis | Kansas | 20051 | 3735 | 72 |
1281711 | 1281711 | 2021-05-03 | Ellis | Kansas | 20051 | 3735 | 73 |
1282119 | 1282119 | 2021-05-03 | Becker | Minnesota | 27005 | 3735 | 49 |
1265209 | 1265209 | 2021-04-28 | Logan | Illinois | 17107 | 3735 | 70 |
1253695 | 1253695 | 2021-04-24 | Preble | Ohio | 39135 | 3735 | 98 |
1240304 | 1240304 | 2021-04-20 | Lincoln | Nebraska | 31111 | 3735 | 53 |
1236662 | 1236662 | 2021-04-19 | Beltrami | Minnesota | 27007 | 3735 | 57 |
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);