ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
168 rows where cases = 3122 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 20
- Texas 18
- Indiana 10
- Iowa 9
- Louisiana 9
- Mississippi 8
- Puerto Rico 8
- Arkansas 7
- Illinois 7
- North Carolina 6
- Pennsylvania 6
- Kansas 4
- Minnesota 4
- New York 4
- South Carolina 4
- Tennessee 4
- Wisconsin 4
- California 3
- Idaho 3
- Missouri 3
- Utah 3
- West Virginia 3
- Alabama 2
- Hawaii 2
- Michigan 2
- Ohio 2
- Alaska 1
- Colorado 1
- Florida 1
- Kentucky 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500795 | 2500795 | 2022-05-13 | Kent | Maryland | 24029 | 3122 | 66 |
2359793 | 2359793 | 2022-03-31 | Plumas | California | 6063 | 3122 | 13 |
2353777 | 2353777 | 2022-03-29 | Blackford | Indiana | 18009 | 3122 | 69 |
2350525 | 2350525 | 2022-03-28 | Blackford | Indiana | 18009 | 3122 | 69 |
2327753 | 2327753 | 2022-03-21 | Blackford | Indiana | 18009 | 3122 | 69 |
2282091 | 2282091 | 2022-03-07 | Gooding | Idaho | 16047 | 3122 | 54 |
2270877 | 2270877 | 2022-03-03 | Loiza | Puerto Rico | 72087 | 3122 | |
2267625 | 2267625 | 2022-03-02 | Loiza | Puerto Rico | 72087 | 3122 | |
2264372 | 2264372 | 2022-03-01 | Loiza | Puerto Rico | 72087 | 3122 | |
2261122 | 2261122 | 2022-02-28 | Loiza | Puerto Rico | 72087 | 3122 | |
2245162 | 2245162 | 2022-02-23 | Comanche | Texas | 48093 | 3122 | 76 |
2241911 | 2241911 | 2022-02-22 | Comanche | Texas | 48093 | 3122 | 75 |
2238660 | 2238660 | 2022-02-21 | Comanche | Texas | 48093 | 3122 | 75 |
2179853 | 2179853 | 2022-02-03 | Utuado | Puerto Rico | 72141 | 3122 | |
2174694 | 2174694 | 2022-02-02 | Oglethorpe | Georgia | 13221 | 3122 | 47 |
2150056 | 2150056 | 2022-01-25 | Schuyler | New York | 36097 | 3122 | 23 |
2127036 | 2127036 | 2022-01-18 | Park | Montana | 30067 | 3122 | 32 |
2099846 | 2099846 | 2022-01-10 | Jeff Davis | Georgia | 13161 | 3122 | 64 |
2089521 | 2089521 | 2022-01-06 | Wetzel | West Virginia | 54103 | 3122 | 68 |
2083814 | 2083814 | 2022-01-05 | Warren | Illinois | 17187 | 3122 | 75 |
2080470 | 2080470 | 2022-01-04 | Bond | Illinois | 17005 | 3122 | 34 |
2038102 | 2038102 | 2021-12-22 | Meriwether | Georgia | 13199 | 3122 | 121 |
2035129 | 2035129 | 2021-12-21 | Perry | Indiana | 18123 | 3122 | 59 |
2035303 | 2035303 | 2021-12-21 | Jefferson | Kansas | 20087 | 3122 | 52 |
2032053 | 2032053 | 2021-12-20 | Jefferson | Kansas | 20087 | 3122 | 52 |
2030469 | 2030469 | 2021-12-19 | Sequatchie | Tennessee | 47153 | 3122 | 42 |
2027218 | 2027218 | 2021-12-18 | Sequatchie | Tennessee | 47153 | 3122 | 42 |
2023967 | 2023967 | 2021-12-17 | Sequatchie | Tennessee | 47153 | 3122 | 42 |
2024461 | 2024461 | 2021-12-17 | Barbour | West Virginia | 54001 | 3122 | 53 |
1969908 | 1969908 | 2021-12-01 | Kauai | Hawaii | 15007 | 3122 | 13 |
1971700 | 1971700 | 2021-12-01 | Canovanas | Puerto Rico | 72029 | 3122 | |
1964279 | 1964279 | 2021-11-29 | Clay | Mississippi | 28025 | 3122 | 78 |
1959777 | 1959777 | 2021-11-28 | Sharp | Arkansas | 5135 | 3122 | 70 |
1962042 | 1962042 | 2021-11-28 | Hampton | South Carolina | 45049 | 3122 | 74 |
1958791 | 1958791 | 2021-11-27 | Hampton | South Carolina | 45049 | 3122 | 74 |
1955540 | 1955540 | 2021-11-26 | Hampton | South Carolina | 45049 | 3122 | 74 |
1944171 | 1944171 | 2021-11-23 | Dickinson | Iowa | 19059 | 3122 | 55 |
1944769 | 1944769 | 2021-11-23 | Chickasaw | Mississippi | 28017 | 3122 | 67 |
1940921 | 1940921 | 2021-11-22 | Dickinson | Iowa | 19059 | 3122 | 55 |
1937395 | 1937395 | 2021-11-21 | Worth | Georgia | 13321 | 3122 | 93 |
1937671 | 1937671 | 2021-11-21 | Dickinson | Iowa | 19059 | 3122 | 55 |
1934145 | 1934145 | 2021-11-20 | Worth | Georgia | 13321 | 3122 | 93 |
1934421 | 1934421 | 2021-11-20 | Dickinson | Iowa | 19059 | 3122 | 55 |
1935959 | 1935959 | 2021-11-20 | Gurabo | Puerto Rico | 72063 | 3122 | |
1930893 | 1930893 | 2021-11-19 | Worth | Georgia | 13321 | 3122 | 93 |
1931170 | 1931170 | 2021-11-19 | Dickinson | Iowa | 19059 | 3122 | 55 |
1927919 | 1927919 | 2021-11-18 | Dickinson | Iowa | 19059 | 3122 | 55 |
1924669 | 1924669 | 2021-11-17 | Dickinson | Iowa | 19059 | 3122 | 55 |
1918107 | 1918107 | 2021-11-15 | Orange | Indiana | 18117 | 3122 | 73 |
1919643 | 1919643 | 2021-11-15 | Juniata | Pennsylvania | 42067 | 3122 | 120 |
1898544 | 1898544 | 2021-11-09 | Wayne | Illinois | 17191 | 3122 | 66 |
1819988 | 1819988 | 2021-10-16 | Conway | Arkansas | 5029 | 3122 | 43 |
1800421 | 1800421 | 2021-10-10 | Pickens | Alabama | 1107 | 3122 | 77 |
1781174 | 1781174 | 2021-10-04 | Routt | Colorado | 8107 | 3122 | 22 |
1773776 | 1773776 | 2021-10-01 | Burleson | Texas | 48051 | 3122 | 57 |
1768318 | 1768318 | 2021-09-30 | Elbert | Georgia | 13105 | 3122 | 81 |
1761996 | 1761996 | 2021-09-28 | Crawford | Illinois | 17033 | 3122 | 46 |
1755389 | 1755389 | 2021-09-26 | Putnam | Georgia | 13237 | 3122 | 74 |
1757713 | 1757713 | 2021-09-26 | Scurry | Texas | 48415 | 3122 | 78 |
1752141 | 1752141 | 2021-09-25 | Putnam | Georgia | 13237 | 3122 | 74 |
1748892 | 1748892 | 2021-09-24 | Putnam | Georgia | 13237 | 3122 | 74 |
1733821 | 1733821 | 2021-09-19 | Cass | Nebraska | 31025 | 3122 | 17 |
1701517 | 1701517 | 2021-09-09 | Franklin | New York | 36033 | 3122 | 13 |
1696868 | 1696868 | 2021-09-08 | Hart | Georgia | 13147 | 3122 | 59 |
1682286 | 1682286 | 2021-09-03 | Pike | Ohio | 39131 | 3122 | 38 |
1634203 | 1634203 | 2021-08-19 | Limestone | Texas | 48293 | 3122 | 85 |
1628705 | 1628705 | 2021-08-18 | Sumter | Georgia | 13261 | 3122 | 107 |
1626862 | 1626862 | 2021-08-17 | Cherokee | North Carolina | 37039 | 3122 | 39 |
1621868 | 1621868 | 2021-08-16 | Sevier | Arkansas | 5133 | 3122 | 28 |
1609645 | 1609645 | 2021-08-12 | Labette | Kansas | 20099 | 3122 | 52 |
1606396 | 1606396 | 2021-08-11 | Labette | Kansas | 20099 | 3122 | 52 |
1601641 | 1601641 | 2021-08-09 | Dimmit | Texas | 48127 | 3122 | 38 |
1598393 | 1598393 | 2021-08-08 | Dimmit | Texas | 48127 | 3122 | 38 |
1595144 | 1595144 | 2021-08-07 | Dimmit | Texas | 48127 | 3122 | 38 |
1583290 | 1583290 | 2021-08-04 | Jefferson | Idaho | 16051 | 3122 | 33 |
1563752 | 1563752 | 2021-07-29 | Unknown | Georgia | 3122 | 5 | |
1561397 | 1561397 | 2021-07-28 | Coahoma | Mississippi | 28027 | 3122 | 85 |
1554629 | 1554629 | 2021-07-26 | Morehouse | Louisiana | 22067 | 3122 | 79 |
1489909 | 1489909 | 2021-07-06 | Mille Lacs | Minnesota | 27095 | 3122 | 55 |
1442172 | 1442172 | 2021-06-21 | Tioga | Pennsylvania | 42117 | 3122 | 110 |
1363507 | 1363507 | 2021-05-28 | Lafayette | Missouri | 29107 | 3122 | 57 |
1359244 | 1359244 | 2021-05-27 | Unknown | Georgia | 3122 | 8 | |
1353224 | 1353224 | 2021-05-25 | Bell | Kentucky | 21013 | 3122 | 56 |
1353712 | 1353712 | 2021-05-25 | Yazoo | Mississippi | 28163 | 3122 | 70 |
1349403 | 1349403 | 2021-05-24 | Dawson | Georgia | 13085 | 3122 | 46 |
1350466 | 1350466 | 2021-05-24 | Yazoo | Mississippi | 28163 | 3122 | 70 |
1346156 | 1346156 | 2021-05-23 | Dawson | Georgia | 13085 | 3122 | 46 |
1342908 | 1342908 | 2021-05-22 | Dawson | Georgia | 13085 | 3122 | 46 |
1306808 | 1306808 | 2021-05-11 | Marion | Alabama | 1093 | 3122 | 101 |
1309039 | 1309039 | 2021-05-11 | Clarion | Pennsylvania | 42031 | 3122 | 91 |
1291114 | 1291114 | 2021-05-06 | Latah | Idaho | 16057 | 3122 | 10 |
1292136 | 1292136 | 2021-05-06 | Warren | Missouri | 29219 | 3122 | 31 |
1286619 | 1286619 | 2021-05-04 | Marion | Tennessee | 47115 | 3122 | 47 |
1277889 | 1277889 | 2021-05-02 | Hardee | Florida | 12049 | 3122 | 43 |
1271043 | 1271043 | 2021-04-29 | Sheridan | Wyoming | 56033 | 3122 | 31 |
1247478 | 1247478 | 2021-04-22 | Vega Baja | Puerto Rico | 72145 | 3122 | |
1236479 | 1236479 | 2021-04-19 | Jefferson Davis | Louisiana | 22053 | 3122 | 93 |
1233232 | 1233232 | 2021-04-18 | Jefferson Davis | Louisiana | 22053 | 3122 | 93 |
1229984 | 1229984 | 2021-04-17 | Jefferson Davis | Louisiana | 22053 | 3122 | 93 |
1226736 | 1226736 | 2021-04-16 | Jefferson Davis | Louisiana | 22053 | 3122 | 93 |
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);