ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 2858 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 15
- Texas 15
- Virginia 14
- Georgia 10
- Illinois 9
- Indiana 8
- West Virginia 7
- Arkansas 6
- Mississippi 6
- Ohio 6
- Tennessee 6
- North Carolina 5
- Pennsylvania 5
- Washington 5
- Florida 4
- Louisiana 4
- Minnesota 4
- Puerto Rico 4
- Colorado 3
- Idaho 3
- Maryland 3
- Missouri 3
- Nevada 3
- Wisconsin 3
- Alabama 2
- California 2
- Iowa 2
- Kentucky 2
- New Mexico 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444500 | 2444500 | 2022-04-26 | Park | Colorado | 8093 | 2858 | 20 |
2355458 | 2355458 | 2022-03-29 | Orocovis | Puerto Rico | 72107 | 2858 | |
2352205 | 2352205 | 2022-03-28 | Orocovis | Puerto Rico | 72107 | 2858 | |
2265310 | 2265310 | 2022-03-02 | Wilcox | Alabama | 1131 | 2858 | 42 |
2245919 | 2245919 | 2022-02-24 | Stone | Arkansas | 5137 | 2858 | 59 |
2217892 | 2217892 | 2022-02-15 | Watonwan | Minnesota | 27165 | 2858 | 22 |
2219373 | 2219373 | 2022-02-15 | Juab | Utah | 49023 | 2858 | 22 |
2150371 | 2150371 | 2022-01-25 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2151172 | 2151172 | 2022-01-25 | Martinsville city | Virginia | 51690 | 2858 | 100 |
2147119 | 2147119 | 2022-01-24 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2143865 | 2143865 | 2022-01-23 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2140610 | 2140610 | 2022-01-22 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2137354 | 2137354 | 2022-01-21 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2134100 | 2134100 | 2022-01-20 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2134300 | 2134300 | 2022-01-20 | Utuado | Puerto Rico | 72141 | 2858 | |
2130848 | 2130848 | 2022-01-19 | Okfuskee | Oklahoma | 40107 | 2858 | 51 |
2122831 | 2122831 | 2022-01-17 | Wabash | Illinois | 17185 | 2858 | 22 |
2119579 | 2119579 | 2022-01-16 | Wabash | Illinois | 17185 | 2858 | 22 |
2116327 | 2116327 | 2022-01-15 | Wabash | Illinois | 17185 | 2858 | 22 |
2113076 | 2113076 | 2022-01-14 | Wabash | Illinois | 17185 | 2858 | 22 |
2114414 | 2114414 | 2022-01-14 | McKenzie | North Dakota | 38053 | 2858 | 23 |
2111773 | 2111773 | 2022-01-13 | Bosque | Texas | 48035 | 2858 | 59 |
2060054 | 2060054 | 2021-12-28 | Buckingham | Virginia | 51029 | 2858 | 41 |
2034228 | 2034228 | 2021-12-20 | Hardy | West Virginia | 54031 | 2858 | 38 |
2015487 | 2015487 | 2021-12-15 | Ford | Illinois | 17053 | 2858 | 67 |
1967168 | 1967168 | 2021-11-30 | Lawrence | Kentucky | 21127 | 2858 | 44 |
1960328 | 1960328 | 2021-11-28 | Franklin | Indiana | 18047 | 2858 | 49 |
1961912 | 1961912 | 2021-11-28 | Montour | Pennsylvania | 42093 | 2858 | 75 |
1957077 | 1957077 | 2021-11-27 | Franklin | Indiana | 18047 | 2858 | 49 |
1953826 | 1953826 | 2021-11-26 | Franklin | Indiana | 18047 | 2858 | 49 |
1950575 | 1950575 | 2021-11-25 | Franklin | Indiana | 18047 | 2858 | 49 |
1947324 | 1947324 | 2021-11-24 | Franklin | Indiana | 18047 | 2858 | 49 |
1939815 | 1939815 | 2021-11-21 | Fluvanna | Virginia | 51065 | 2858 | 27 |
1936565 | 1936565 | 2021-11-20 | Fluvanna | Virginia | 51065 | 2858 | 27 |
1933315 | 1933315 | 2021-11-19 | Fluvanna | Virginia | 51065 | 2858 | 27 |
1927792 | 1927792 | 2021-11-18 | White | Illinois | 17193 | 2858 | 43 |
1924456 | 1924456 | 2021-11-17 | Clark | Illinois | 17023 | 2858 | 50 |
1919181 | 1919181 | 2021-11-15 | Roosevelt | New Mexico | 35041 | 2858 | 70 |
1914674 | 1914674 | 2021-11-14 | Gem | Idaho | 16045 | 2858 | 65 |
1900177 | 1900177 | 2021-11-09 | Wyoming | Pennsylvania | 42131 | 2858 | 64 |
1878017 | 1878017 | 2021-11-02 | Orleans | Vermont | 50019 | 2858 | 16 |
1863625 | 1863625 | 2021-10-29 | Clinton | Missouri | 29049 | 2858 | 77 |
1839324 | 1839324 | 2021-10-21 | Vernon | Wisconsin | 55123 | 2858 | 56 |
1835984 | 1835984 | 2021-10-20 | McDowell | West Virginia | 54047 | 2858 | 46 |
1784092 | 1784092 | 2021-10-04 | Vilas | Wisconsin | 55125 | 2858 | 50 |
1768605 | 1768605 | 2021-09-30 | Fulton | Indiana | 18049 | 2858 | 59 |
1766235 | 1766235 | 2021-09-29 | Vernon | Missouri | 29217 | 2858 | 64 |
1755473 | 1755473 | 2021-09-26 | Minidoka | Idaho | 16067 | 2858 | 39 |
1752225 | 1752225 | 2021-09-25 | Minidoka | Idaho | 16067 | 2858 | 39 |
1745605 | 1745605 | 2021-09-23 | Jeff Davis | Georgia | 13161 | 2858 | 49 |
1695067 | 1695067 | 2021-09-07 | Ashe | North Carolina | 37009 | 2858 | 45 |
1695908 | 1695908 | 2021-09-07 | Jones | Texas | 48253 | 2858 | 61 |
1690202 | 1690202 | 2021-09-06 | Pitkin | Colorado | 8097 | 2858 | 4 |
1692660 | 1692660 | 2021-09-06 | Jones | Texas | 48253 | 2858 | 61 |
1689411 | 1689411 | 2021-09-05 | Jones | Texas | 48253 | 2858 | 61 |
1686161 | 1686161 | 2021-09-04 | Jones | Texas | 48253 | 2858 | 61 |
1665405 | 1665405 | 2021-08-29 | Tishomingo | Mississippi | 28141 | 2858 | 76 |
1662157 | 1662157 | 2021-08-28 | Tishomingo | Mississippi | 28141 | 2858 | 76 |
1658909 | 1658909 | 2021-08-27 | Tishomingo | Mississippi | 28141 | 2858 | 76 |
1653746 | 1653746 | 2021-08-25 | Reeves | Texas | 48389 | 2858 | 45 |
1644936 | 1644936 | 2021-08-23 | Pike | Georgia | 13231 | 2858 | 47 |
1625061 | 1625061 | 2021-08-17 | Cleburne | Arkansas | 5023 | 2858 | 76 |
1584141 | 1584141 | 2021-08-04 | George | Mississippi | 28039 | 2858 | 51 |
1553208 | 1553208 | 2021-07-25 | Halifax | Virginia | 51083 | 2858 | 78 |
1549961 | 1549961 | 2021-07-24 | Halifax | Virginia | 51083 | 2858 | 78 |
1546714 | 1546714 | 2021-07-23 | Halifax | Virginia | 51083 | 2858 | 78 |
1542094 | 1542094 | 2021-07-22 | Washington | Missouri | 29221 | 2858 | 53 |
1543467 | 1543467 | 2021-07-22 | Halifax | Virginia | 51083 | 2858 | 78 |
1537159 | 1537159 | 2021-07-20 | Door | Wisconsin | 55029 | 2858 | 34 |
1522214 | 1522214 | 2021-07-16 | Dorchester | Maryland | 24019 | 2858 | 65 |
1518965 | 1518965 | 2021-07-15 | Dorchester | Maryland | 24019 | 2858 | 65 |
1515718 | 1515718 | 2021-07-14 | Dorchester | Maryland | 24019 | 2858 | 65 |
1488427 | 1488427 | 2021-07-05 | Randolph | West Virginia | 54083 | 2858 | 15 |
1485180 | 1485180 | 2021-07-04 | Randolph | West Virginia | 54083 | 2858 | 15 |
1481934 | 1481934 | 2021-07-03 | Randolph | West Virginia | 54083 | 2858 | 15 |
1478687 | 1478687 | 2021-07-02 | Randolph | West Virginia | 54083 | 2858 | 15 |
1458160 | 1458160 | 2021-06-26 | Fayette | Ohio | 39047 | 2858 | 50 |
1454915 | 1454915 | 2021-06-25 | Fayette | Ohio | 39047 | 2858 | 50 |
1421710 | 1421710 | 2021-06-15 | Cass | Minnesota | 27021 | 2858 | 32 |
1392301 | 1392301 | 2021-06-06 | De Soto | Louisiana | 22031 | 2858 | 78 |
1389056 | 1389056 | 2021-06-05 | De Soto | Louisiana | 22031 | 2858 | 78 |
1385811 | 1385811 | 2021-06-04 | De Soto | Louisiana | 22031 | 2858 | 78 |
1377863 | 1377863 | 2021-06-01 | Accomack | Virginia | 51001 | 2858 | 42 |
1374374 | 1374374 | 2021-05-31 | Deaf Smith | Texas | 48117 | 2858 | 66 |
1371129 | 1371129 | 2021-05-30 | Deaf Smith | Texas | 48117 | 2858 | 66 |
1367883 | 1367883 | 2021-05-29 | Deaf Smith | Texas | 48117 | 2858 | 66 |
1364241 | 1364241 | 2021-05-28 | Elk | Pennsylvania | 42047 | 2858 | 39 |
1360995 | 1360995 | 2021-05-27 | Elk | Pennsylvania | 42047 | 2858 | 39 |
1320819 | 1320819 | 2021-05-15 | Logan | Kentucky | 21141 | 2858 | 66 |
1314063 | 1314063 | 2021-05-13 | Carroll | Iowa | 19027 | 2858 | 52 |
1310424 | 1310424 | 2021-05-12 | Chattooga | Georgia | 13055 | 2858 | 71 |
1309815 | 1309815 | 2021-05-11 | Winchester city | Virginia | 51840 | 2858 | 45 |
1300685 | 1300685 | 2021-05-09 | Chattooga | Georgia | 13055 | 2858 | 71 |
1274089 | 1274089 | 2021-04-30 | Smyth | Virginia | 51173 | 2858 | 91 |
1263524 | 1263524 | 2021-04-27 | Seminole | Oklahoma | 40133 | 2858 | 69 |
1260277 | 1260277 | 2021-04-26 | Seminole | Oklahoma | 40133 | 2858 | 69 |
1257030 | 1257030 | 2021-04-25 | Seminole | Oklahoma | 40133 | 2858 | 69 |
1253783 | 1253783 | 2021-04-24 | Seminole | Oklahoma | 40133 | 2858 | 69 |
1250536 | 1250536 | 2021-04-23 | Seminole | Oklahoma | 40133 | 2858 | 69 |
1246557 | 1246557 | 2021-04-22 | Tippah | Mississippi | 28139 | 2858 | 68 |
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);