ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
183 rows where cases = 2898 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 30
- Missouri 13
- Georgia 10
- Texas 9
- Ohio 8
- Kentucky 7
- Michigan 7
- Illinois 6
- Pennsylvania 6
- Wisconsin 6
- Arkansas 5
- Louisiana 5
- Minnesota 5
- Mississippi 5
- Montana 5
- North Carolina 5
- West Virginia 5
- Florida 4
- Indiana 4
- Puerto Rico 4
- Tennessee 4
- Virginia 4
- New York 3
- Utah 3
- Washington 3
- Alabama 2
- Iowa 2
- Nebraska 2
- Wyoming 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473155 | 2473155 | 2022-05-04 | Morgan | Utah | 49029 | 2898 | 15 |
2469899 | 2469899 | 2022-05-03 | Morgan | Utah | 49029 | 2898 | 15 |
2466643 | 2466643 | 2022-05-02 | Morgan | Utah | 49029 | 2898 | 15 |
2418408 | 2418408 | 2022-04-18 | Archuleta | Colorado | 8007 | 2898 | 15 |
2335698 | 2335698 | 2022-03-23 | Vinton | Ohio | 39163 | 2898 | 55 |
2332444 | 2332444 | 2022-03-22 | Vinton | Ohio | 39163 | 2898 | 55 |
2329191 | 2329191 | 2022-03-21 | Vinton | Ohio | 39163 | 2898 | 55 |
2325939 | 2325939 | 2022-03-20 | Vinton | Ohio | 39163 | 2898 | 55 |
2322686 | 2322686 | 2022-03-19 | Vinton | Ohio | 39163 | 2898 | 55 |
2319432 | 2319432 | 2022-03-18 | Vinton | Ohio | 39163 | 2898 | 55 |
2316178 | 2316178 | 2022-03-17 | Vinton | Ohio | 39163 | 2898 | 55 |
2260261 | 2260261 | 2022-02-28 | Cedar | Missouri | 29039 | 2898 | 48 |
2247068 | 2247068 | 2022-02-24 | Aitkin | Minnesota | 27001 | 2898 | 60 |
2240649 | 2240649 | 2022-02-22 | Watonwan | Minnesota | 27165 | 2898 | 22 |
2215705 | 2215705 | 2022-02-14 | Charles Mix | South Dakota | 46023 | 2898 | 32 |
2175327 | 2175327 | 2022-02-02 | Caldwell | Louisiana | 22021 | 2898 | 44 |
2155737 | 2155737 | 2022-01-27 | Leslie | Kentucky | 21131 | 2898 | 39 |
2126449 | 2126449 | 2022-01-18 | Knott | Kentucky | 21119 | 2898 | 51 |
2080533 | 2080533 | 2022-01-04 | Mercer | Illinois | 17131 | 2898 | 38 |
2078585 | 2078585 | 2022-01-03 | Northampton | North Carolina | 37131 | 2898 | 66 |
2059489 | 2059489 | 2021-12-28 | Manati | Puerto Rico | 72091 | 2898 | |
2027983 | 2027983 | 2021-12-19 | Clay | Arkansas | 5021 | 2898 | 77 |
2027763 | 2027763 | 2021-12-18 | Wetzel | West Virginia | 54103 | 2898 | 66 |
2019614 | 2019614 | 2021-12-16 | Benton | Missouri | 29015 | 2898 | 70 |
1993525 | 1993525 | 2021-12-08 | Calhoun | Mississippi | 28013 | 2898 | 51 |
1973302 | 1973302 | 2021-12-02 | White | Illinois | 17193 | 2898 | 43 |
1973668 | 1973668 | 2021-12-02 | Lawrence | Kentucky | 21127 | 2898 | 44 |
1971665 | 1971665 | 2021-12-01 | Montour | Pennsylvania | 42093 | 2898 | 75 |
1961124 | 1961124 | 2021-11-28 | Cooper | Missouri | 29053 | 2898 | 52 |
1957873 | 1957873 | 2021-11-27 | Cooper | Missouri | 29053 | 2898 | 52 |
1954622 | 1954622 | 2021-11-26 | Cooper | Missouri | 29053 | 2898 | 52 |
1951371 | 1951371 | 2021-11-25 | Cooper | Missouri | 29053 | 2898 | 52 |
1948120 | 1948120 | 2021-11-24 | Cooper | Missouri | 29053 | 2898 | 52 |
1944369 | 1944369 | 2021-11-23 | Casey | Kentucky | 21045 | 2898 | 58 |
1945207 | 1945207 | 2021-11-23 | Essex | New York | 36031 | 2898 | 37 |
1942923 | 1942923 | 2021-11-22 | San Jacinto | Texas | 48407 | 2898 | 80 |
1939673 | 1939673 | 2021-11-21 | San Jacinto | Texas | 48407 | 2898 | 80 |
1936423 | 1936423 | 2021-11-20 | San Jacinto | Texas | 48407 | 2898 | 80 |
1927230 | 1927230 | 2021-11-18 | Grant | Arkansas | 5053 | 2898 | 50 |
1921902 | 1921902 | 2021-11-16 | Ogemaw | Michigan | 26129 | 2898 | 68 |
1917899 | 1917899 | 2021-11-15 | Kauai | Hawaii | 15007 | 2898 | 11 |
1918652 | 1918652 | 2021-11-15 | Ogemaw | Michigan | 26129 | 2898 | 68 |
1916026 | 1916026 | 2021-11-14 | Currituck | North Carolina | 37053 | 2898 | 27 |
1917273 | 1917273 | 2021-11-14 | Iowa | Wisconsin | 55049 | 2898 | 17 |
1912776 | 1912776 | 2021-11-13 | Currituck | North Carolina | 37053 | 2898 | 27 |
1914023 | 1914023 | 2021-11-13 | Iowa | Wisconsin | 55049 | 2898 | 17 |
1909526 | 1909526 | 2021-11-12 | Currituck | North Carolina | 37053 | 2898 | 27 |
1910773 | 1910773 | 2021-11-12 | Iowa | Wisconsin | 55049 | 2898 | 17 |
1869860 | 1869860 | 2021-10-31 | Cheboygan | Michigan | 26031 | 2898 | 66 |
1866611 | 1866611 | 2021-10-30 | Cheboygan | Michigan | 26031 | 2898 | 66 |
1863362 | 1863362 | 2021-10-29 | Cheboygan | Michigan | 26031 | 2898 | 66 |
1813930 | 1813930 | 2021-10-14 | Blaine | Idaho | 16013 | 2898 | 22 |
1779241 | 1779241 | 2021-10-03 | Big Horn | Montana | 30003 | 2898 | 81 |
1775991 | 1775991 | 2021-10-02 | Big Horn | Montana | 30003 | 2898 | 81 |
1772741 | 1772741 | 2021-10-01 | Big Horn | Montana | 30003 | 2898 | 81 |
1765116 | 1765116 | 2021-09-29 | Meriwether | Georgia | 13199 | 2898 | 100 |
1763783 | 1763783 | 2021-09-28 | Vega Alta | Puerto Rico | 72143 | 2898 | |
1760534 | 1760534 | 2021-09-27 | Vega Alta | Puerto Rico | 72143 | 2898 | |
1754891 | 1754891 | 2021-09-26 | Cherokee | Alabama | 1019 | 2898 | 55 |
1735192 | 1735192 | 2021-09-19 | Waynesboro city | Virginia | 51820 | 2898 | 39 |
1731942 | 1731942 | 2021-09-18 | Waynesboro city | Virginia | 51820 | 2898 | 39 |
1728692 | 1728692 | 2021-09-17 | Waynesboro city | Virginia | 51820 | 2898 | 39 |
1699779 | 1699779 | 2021-09-09 | Conway | Arkansas | 5029 | 2898 | 41 |
1688986 | 1688986 | 2021-09-05 | Warren | Pennsylvania | 42123 | 2898 | 109 |
1685736 | 1685736 | 2021-09-04 | Warren | Pennsylvania | 42123 | 2898 | 108 |
1679676 | 1679676 | 2021-09-02 | Lavaca | Texas | 48285 | 2898 | 79 |
1644877 | 1644877 | 2021-08-23 | Fannin | Georgia | 13111 | 2898 | 77 |
1625461 | 1625461 | 2021-08-17 | Tattnall | Georgia | 13267 | 2898 | 74 |
1602664 | 1602664 | 2021-08-10 | Harris | Georgia | 13145 | 2898 | 66 |
1604768 | 1604768 | 2021-08-10 | Haywood | Tennessee | 47075 | 2898 | 62 |
1599456 | 1599456 | 2021-08-09 | Pierce | Georgia | 13229 | 2898 | 63 |
1586458 | 1586458 | 2021-08-05 | Peach | Georgia | 13225 | 2898 | 70 |
1589041 | 1589041 | 2021-08-05 | Okanogan | Washington | 53047 | 2898 | 42 |
1585316 | 1585316 | 2021-08-04 | Smith | Tennessee | 47159 | 2898 | 40 |
1580918 | 1580918 | 2021-08-03 | Marion | Mississippi | 28091 | 2898 | 82 |
1581060 | 1581060 | 2021-08-03 | Stoddard | Missouri | 29207 | 2898 | 48 |
1569226 | 1569226 | 2021-07-30 | Kleberg | Texas | 48273 | 2898 | 95 |
1565302 | 1565302 | 2021-07-29 | Fayette | Ohio | 39047 | 2898 | 50 |
1557200 | 1557200 | 2021-07-27 | Lee | Georgia | 13177 | 2898 | 59 |
1554562 | 1554562 | 2021-07-26 | Montgomery | Kentucky | 21173 | 2898 | 30 |
1500980 | 1500980 | 2021-07-09 | Frio | Texas | 48163 | 2898 | 52 |
1495760 | 1495760 | 2021-07-08 | Greene | Indiana | 18055 | 2898 | 89 |
1449579 | 1449579 | 2021-06-23 | Park | Wyoming | 56029 | 2898 | 30 |
1446334 | 1446334 | 2021-06-22 | Park | Wyoming | 56029 | 2898 | 30 |
1426701 | 1426701 | 2021-06-16 | Mason | Washington | 53045 | 2898 | 35 |
1399809 | 1399809 | 2021-06-08 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1396564 | 1396564 | 2021-06-07 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1393317 | 1393317 | 2021-06-06 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1388337 | 1388337 | 2021-06-05 | Chattooga | Georgia | 13055 | 2898 | 74 |
1390072 | 1390072 | 2021-06-05 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1386827 | 1386827 | 2021-06-04 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1383582 | 1383582 | 2021-06-03 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1380336 | 1380336 | 2021-06-02 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1377091 | 1377091 | 2021-06-01 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1373845 | 1373845 | 2021-05-31 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1370600 | 1370600 | 2021-05-30 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1367354 | 1367354 | 2021-05-29 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1363486 | 1363486 | 2021-05-28 | Dunklin | Missouri | 29069 | 2898 | 50 |
1364108 | 1364108 | 2021-05-28 | Beckham | Oklahoma | 40009 | 2898 | 58 |
1360862 | 1360862 | 2021-05-27 | Beckham | Oklahoma | 40009 | 2898 | 58 |
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);