ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where cases = 2317 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Texas 15
- Kentucky 14
- Virginia 13
- Oklahoma 10
- Arkansas 9
- Mississippi 9
- Ohio 9
- Illinois 8
- Indiana 8
- Missouri 8
- Minnesota 7
- South Dakota 7
- Alabama 6
- Louisiana 5
- North Carolina 5
- Tennessee 5
- Iowa 4
- Puerto Rico 4
- South Carolina 4
- Kansas 3
- Nebraska 3
- New York 3
- West Virginia 3
- Florida 2
- Idaho 2
- Maryland 2
- New Hampshire 2
- North Dakota 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2433579 | 2433579 | 2022-04-22 | Penuelas | Puerto Rico | 72111 | 2317 | |
2430267 | 2430267 | 2022-04-21 | Adjuntas | Puerto Rico | 72001 | 2317 | |
2287265 | 2287265 | 2022-03-08 | Lake | South Dakota | 46079 | 2317 | 27 |
2283249 | 2283249 | 2022-03-07 | Phelps | Nebraska | 31137 | 2317 | 12 |
2284013 | 2284013 | 2022-03-07 | Lake | South Dakota | 46079 | 2317 | 27 |
2281023 | 2281023 | 2022-03-06 | La Salle | Texas | 48283 | 2317 | 45 |
2277770 | 2277770 | 2022-03-05 | La Salle | Texas | 48283 | 2317 | 45 |
2274517 | 2274517 | 2022-03-04 | La Salle | Texas | 48283 | 2317 | 45 |
2270238 | 2270238 | 2022-03-03 | Phelps | Nebraska | 31137 | 2317 | 12 |
2241467 | 2241467 | 2022-02-22 | Woods | Oklahoma | 40151 | 2317 | 33 |
2238216 | 2238216 | 2022-02-21 | Woods | Oklahoma | 40151 | 2317 | 33 |
2234965 | 2234965 | 2022-02-20 | Woods | Oklahoma | 40151 | 2317 | 33 |
2231714 | 2231714 | 2022-02-19 | Woods | Oklahoma | 40151 | 2317 | 33 |
2228463 | 2228463 | 2022-02-18 | Woods | Oklahoma | 40151 | 2317 | 33 |
2225212 | 2225212 | 2022-02-17 | Woods | Oklahoma | 40151 | 2317 | 33 |
2221961 | 2221961 | 2022-02-16 | Woods | Oklahoma | 40151 | 2317 | 33 |
2202970 | 2202970 | 2022-02-10 | Jim Hogg | Texas | 48247 | 2317 | 20 |
2190515 | 2190515 | 2022-02-07 | Sumter | Alabama | 1119 | 2317 | 43 |
2190175 | 2190175 | 2022-02-06 | Floyd | Virginia | 51063 | 2317 | 34 |
2186922 | 2186922 | 2022-02-05 | Floyd | Virginia | 51063 | 2317 | 34 |
2183669 | 2183669 | 2022-02-04 | Floyd | Virginia | 51063 | 2317 | 34 |
2142172 | 2142172 | 2022-01-23 | Screven | Georgia | 13251 | 2317 | 62 |
2138917 | 2138917 | 2022-01-22 | Screven | Georgia | 13251 | 2317 | 62 |
2135661 | 2135661 | 2022-01-21 | Screven | Georgia | 13251 | 2317 | 62 |
2128777 | 2128777 | 2022-01-19 | Fulton | Arkansas | 5049 | 2317 | 79 |
2128821 | 2128821 | 2022-01-19 | Stone | Arkansas | 5137 | 2317 | 51 |
2129402 | 2129402 | 2022-01-19 | Newton | Indiana | 18111 | 2317 | 63 |
2122575 | 2122575 | 2022-01-17 | Early | Georgia | 13099 | 2317 | 58 |
2105101 | 2105101 | 2022-01-11 | Charles Mix | South Dakota | 46023 | 2317 | 32 |
2098782 | 2098782 | 2022-01-09 | Camp | Texas | 48063 | 2317 | 69 |
2087758 | 2087758 | 2022-01-06 | Pope | Minnesota | 27121 | 2317 | 14 |
2084536 | 2084536 | 2022-01-05 | Amite | Mississippi | 28005 | 2317 | 59 |
2082288 | 2082288 | 2022-01-04 | Bamberg | South Carolina | 45009 | 2317 | 64 |
2074517 | 2074517 | 2022-01-02 | Madison | Louisiana | 22065 | 2317 | 55 |
2071266 | 2071266 | 2022-01-01 | Madison | Louisiana | 22065 | 2317 | 55 |
2068015 | 2068015 | 2021-12-31 | Madison | Louisiana | 22065 | 2317 | 55 |
2064764 | 2064764 | 2021-12-30 | Madison | Louisiana | 22065 | 2317 | 55 |
2058641 | 2058641 | 2021-12-28 | Dent | Missouri | 29065 | 2317 | 63 |
2052517 | 2052517 | 2021-12-26 | Yates | New York | 36123 | 2317 | 35 |
2036486 | 2036486 | 2021-12-21 | Noble | Ohio | 39121 | 2317 | 50 |
2037368 | 2037368 | 2021-12-21 | Martinsville city | Virginia | 51690 | 2317 | 95 |
2034118 | 2034118 | 2021-12-20 | Martinsville city | Virginia | 51690 | 2317 | 94 |
1986734 | 1986734 | 2021-12-06 | Caldwell | Louisiana | 22021 | 2317 | 39 |
1987978 | 1987978 | 2021-12-06 | Las Piedras | Puerto Rico | 72085 | 2317 | |
1969767 | 1969767 | 2021-12-01 | Charlton | Georgia | 13049 | 2317 | 56 |
1966517 | 1966517 | 2021-11-30 | Charlton | Georgia | 13049 | 2317 | 56 |
1966765 | 1966765 | 2021-11-30 | Massac | Illinois | 17127 | 2317 | 57 |
1963265 | 1963265 | 2021-11-29 | Charlton | Georgia | 13049 | 2317 | 56 |
1944547 | 1944547 | 2021-11-23 | Washington | Maine | 23029 | 2317 | 28 |
1920553 | 1920553 | 2021-11-15 | Rusk | Wisconsin | 55107 | 2317 | 35 |
1875883 | 1875883 | 2021-11-02 | Tipton | Indiana | 18159 | 2317 | 61 |
1853001 | 1853001 | 2021-10-26 | Johnson | Illinois | 17087 | 2317 | 38 |
1832902 | 1832902 | 2021-10-20 | Macon | Alabama | 1087 | 2317 | 63 |
1830628 | 1830628 | 2021-10-19 | Caldwell | Kentucky | 21033 | 2317 | 47 |
1782477 | 1782477 | 2021-10-04 | Ste. Genevieve | Missouri | 29186 | 2317 | 29 |
1783388 | 1783388 | 2021-10-04 | Oglala Lakota | South Dakota | 46102 | 2317 | 52 |
1779227 | 1779227 | 2021-10-03 | Ste. Genevieve | Missouri | 29186 | 2317 | 29 |
1766373 | 1766373 | 2021-09-29 | Saline | Nebraska | 31151 | 2317 | 3 |
1762496 | 1762496 | 2021-09-28 | Webster | Kentucky | 21233 | 2317 | 33 |
1755784 | 1755784 | 2021-09-26 | Bourbon | Kansas | 20011 | 2317 | 41 |
1752536 | 1752536 | 2021-09-25 | Bourbon | Kansas | 20011 | 2317 | 41 |
1749287 | 1749287 | 2021-09-24 | Bourbon | Kansas | 20011 | 2317 | 41 |
1733533 | 1733533 | 2021-09-19 | Roseau | Minnesota | 27135 | 2317 | 23 |
1730283 | 1730283 | 2021-09-18 | Roseau | Minnesota | 27135 | 2317 | 23 |
1727033 | 1727033 | 2021-09-17 | Roseau | Minnesota | 27135 | 2317 | 23 |
1722543 | 1722543 | 2021-09-16 | Madison | Arkansas | 5087 | 2317 | 35 |
1719544 | 1719544 | 2021-09-15 | Brooks | Georgia | 13027 | 2317 | 56 |
1721264 | 1721264 | 2021-09-15 | Paulding | Ohio | 39125 | 2317 | 42 |
1701439 | 1701439 | 2021-09-09 | Coos | New Hampshire | 33007 | 2317 | 46 |
1695935 | 1695935 | 2021-09-07 | Madison | Texas | 48313 | 2317 | 35 |
1673727 | 1673727 | 2021-09-01 | Washington | Alabama | 1129 | 2317 | 43 |
1676043 | 1676043 | 2021-09-01 | Moca | Puerto Rico | 72099 | 2317 | |
1676266 | 1676266 | 2021-09-01 | Sequatchie | Tennessee | 47153 | 2317 | 30 |
1647002 | 1647002 | 2021-08-23 | Humphreys | Tennessee | 47085 | 2317 | 33 |
1643707 | 1643707 | 2021-08-22 | Union | South Dakota | 46127 | 2317 | 43 |
1640457 | 1640457 | 2021-08-21 | Union | South Dakota | 46127 | 2317 | 43 |
1637207 | 1637207 | 2021-08-20 | Union | South Dakota | 46127 | 2317 | 43 |
1605590 | 1605590 | 2021-08-11 | Hempstead | Arkansas | 5057 | 2317 | 20 |
1602366 | 1602366 | 2021-08-10 | Phillips | Arkansas | 5107 | 2317 | 49 |
1599494 | 1599494 | 2021-08-09 | Washington | Georgia | 13303 | 2317 | 90 |
1599529 | 1599529 | 2021-08-09 | Elmore | Idaho | 16039 | 2317 | 19 |
1600060 | 1600060 | 2021-08-09 | Simpson | Kentucky | 21213 | 2317 | 44 |
1588996 | 1588996 | 2021-08-05 | Salem city | Virginia | 51775 | 2317 | 50 |
1578977 | 1578977 | 2021-08-02 | Lee | Texas | 48287 | 2317 | 40 |
1554518 | 1554518 | 2021-07-26 | Grayson | Kentucky | 21085 | 2317 | 58 |
1552993 | 1552993 | 2021-07-25 | Lampasas | Texas | 48281 | 2317 | 33 |
1549746 | 1549746 | 2021-07-24 | Lampasas | Texas | 48281 | 2317 | 33 |
1536967 | 1536967 | 2021-07-20 | Gloucester | Virginia | 51073 | 2317 | 51 |
1527068 | 1527068 | 2021-07-17 | Reeves | Texas | 48389 | 2317 | 44 |
1518209 | 1518209 | 2021-07-15 | Grady | Georgia | 13131 | 2317 | 66 |
1508548 | 1508548 | 2021-07-12 | Union | Georgia | 13291 | 2317 | 81 |
1504920 | 1504920 | 2021-07-11 | Logan | Arkansas | 5083 | 2317 | 25 |
1501674 | 1501674 | 2021-07-10 | Logan | Arkansas | 5083 | 2317 | 25 |
1498428 | 1498428 | 2021-07-09 | Logan | Arkansas | 5083 | 2317 | 25 |
1496523 | 1496523 | 2021-07-08 | Winston | Mississippi | 28159 | 2317 | 82 |
1493276 | 1493276 | 2021-07-07 | Winston | Mississippi | 28159 | 2317 | 82 |
1451548 | 1451548 | 2021-06-24 | Martin | North Carolina | 37117 | 2317 | 45 |
1437693 | 1437693 | 2021-06-20 | Morgan | Kentucky | 21175 | 2317 | 4 |
1434446 | 1434446 | 2021-06-19 | Morgan | Kentucky | 21175 | 2317 | 4 |
1431200 | 1431200 | 2021-06-18 | Morgan | Kentucky | 21175 | 2317 | 4 |
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);