ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where cases = 2896 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 14
- Missouri 13
- Kentucky 12
- Arkansas 10
- Illinois 9
- Indiana 9
- Mississippi 8
- Texas 7
- Louisiana 6
- Alabama 5
- Georgia 5
- Iowa 5
- Maine 5
- Pennsylvania 5
- Puerto Rico 5
- Utah 5
- Minnesota 4
- New York 4
- Ohio 4
- Virginia 4
- Alaska 3
- Colorado 3
- Kansas 3
- California 2
- Nevada 2
- New Mexico 2
- North Carolina 2
- South Carolina 2
- South Dakota 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501951 | 2501951 | 2022-05-13 | Jayuya | Puerto Rico | 72073 | 2896 | |
2495957 | 2495957 | 2022-05-11 | Juab | Utah | 49023 | 2896 | 25 |
2492699 | 2492699 | 2022-05-10 | Juab | Utah | 49023 | 2896 | 25 |
2489441 | 2489441 | 2022-05-09 | Juab | Utah | 49023 | 2896 | 25 |
2401314 | 2401314 | 2022-04-12 | Dawson | Texas | 48115 | 2896 | 94 |
2301170 | 2301170 | 2022-03-13 | Lee | Arkansas | 5077 | 2896 | 58 |
2297918 | 2297918 | 2022-03-12 | Lee | Arkansas | 5077 | 2896 | 58 |
2294666 | 2294666 | 2022-03-11 | Lee | Arkansas | 5077 | 2896 | 58 |
2257010 | 2257010 | 2022-02-27 | Cedar | Missouri | 29039 | 2896 | 48 |
2253759 | 2253759 | 2022-02-26 | Cedar | Missouri | 29039 | 2896 | 48 |
2250508 | 2250508 | 2022-02-25 | Cedar | Missouri | 29039 | 2896 | 48 |
2236005 | 2236005 | 2022-02-21 | Coosa | Alabama | 1037 | 2896 | 54 |
2236273 | 2236273 | 2022-02-21 | Moffat | Colorado | 8081 | 2896 | 51 |
2199221 | 2199221 | 2022-02-09 | Morrow | Oregon | 41049 | 2896 | 27 |
2171073 | 2171073 | 2022-02-01 | Desha | Arkansas | 5041 | 2896 | 35 |
2146488 | 2146488 | 2022-01-24 | Osage | Missouri | 29151 | 2896 | 39 |
2135102 | 2135102 | 2022-01-20 | Price | Wisconsin | 55099 | 2896 | 27 |
2097091 | 2097091 | 2022-01-09 | Osage | Kansas | 20139 | 2896 | 40 |
2099004 | 2099004 | 2022-01-09 | Zavala | Texas | 48507 | 2896 | 56 |
2093839 | 2093839 | 2022-01-08 | Osage | Kansas | 20139 | 2896 | 40 |
2090587 | 2090587 | 2022-01-07 | Osage | Kansas | 20139 | 2896 | 40 |
2081424 | 2081424 | 2022-01-04 | Livingston | Missouri | 29117 | 2896 | 81 |
2077808 | 2077808 | 2022-01-03 | Lincoln | Maine | 23015 | 2896 | 11 |
2074557 | 2074557 | 2022-01-02 | Lincoln | Maine | 23015 | 2896 | 11 |
2075176 | 2075176 | 2022-01-02 | Unknown | New Jersey | 2896 | 0 | |
2071306 | 2071306 | 2022-01-01 | Lincoln | Maine | 23015 | 2896 | 11 |
2067015 | 2067015 | 2021-12-31 | Madison | Arkansas | 5087 | 2896 | 44 |
2068055 | 2068055 | 2021-12-31 | Lincoln | Maine | 23015 | 2896 | 11 |
2042056 | 2042056 | 2021-12-23 | Knox | Maine | 23013 | 2896 | 19 |
2022927 | 2022927 | 2021-12-17 | Moniteau | Missouri | 29135 | 2896 | 46 |
2013903 | 2013903 | 2021-12-14 | Fulton | Pennsylvania | 42057 | 2896 | 40 |
2009426 | 2009426 | 2021-12-13 | Lewis | Kentucky | 21135 | 2896 | 64 |
2005189 | 2005189 | 2021-12-12 | North Slope Borough | Alaska | 2185 | 2896 | 8 |
2001938 | 2001938 | 2021-12-11 | North Slope Borough | Alaska | 2185 | 2896 | 8 |
1998688 | 1998688 | 2021-12-10 | North Slope Borough | Alaska | 2185 | 2896 | 8 |
1966727 | 1966727 | 2021-11-30 | Edgar | Illinois | 17045 | 2896 | 70 |
1880472 | 1880472 | 2021-11-03 | Paulding | Ohio | 39125 | 2896 | 47 |
1875231 | 1875231 | 2021-11-02 | Drew | Arkansas | 5043 | 2896 | 54 |
1869343 | 1869343 | 2021-10-31 | Jay | Indiana | 18075 | 2896 | 51 |
1866094 | 1866094 | 2021-10-30 | Jay | Indiana | 18075 | 2896 | 51 |
1862845 | 1862845 | 2021-10-29 | Jay | Indiana | 18075 | 2896 | 51 |
1852232 | 1852232 | 2021-10-25 | McDowell | West Virginia | 54047 | 2896 | 47 |
1816753 | 1816753 | 2021-10-15 | Hempstead | Arkansas | 5057 | 2896 | 38 |
1787540 | 1787540 | 2021-10-06 | Polk | Arkansas | 5113 | 2896 | 101 |
1778354 | 1778354 | 2021-10-03 | Fulton | Indiana | 18049 | 2896 | 59 |
1775104 | 1775104 | 2021-10-02 | Fulton | Indiana | 18049 | 2896 | 59 |
1771854 | 1771854 | 2021-10-01 | Fulton | Indiana | 18049 | 2896 | 59 |
1769300 | 1769300 | 2021-09-30 | Chickasaw | Mississippi | 28017 | 2896 | 66 |
1766234 | 1766234 | 2021-09-29 | Texas | Missouri | 29215 | 2896 | 40 |
1757286 | 1757286 | 2021-09-26 | Vega Alta | Puerto Rico | 72143 | 2896 | |
1717658 | 1717658 | 2021-09-14 | Churchill | Nevada | 32001 | 2896 | 54 |
1699708 | 1699708 | 2021-09-09 | Pickens | Alabama | 1107 | 2896 | 64 |
1695479 | 1695479 | 2021-09-07 | Susquehanna | Pennsylvania | 42115 | 2896 | 62 |
1690530 | 1690530 | 2021-09-06 | Douglas | Illinois | 17041 | 2896 | 42 |
1687280 | 1687280 | 2021-09-05 | Douglas | Illinois | 17041 | 2896 | 42 |
1684030 | 1684030 | 2021-09-04 | Douglas | Illinois | 17041 | 2896 | 42 |
1680779 | 1680779 | 2021-09-03 | Douglas | Illinois | 17041 | 2896 | 42 |
1664383 | 1664383 | 2021-08-29 | Hart | Georgia | 13147 | 2896 | 58 |
1661135 | 1661135 | 2021-08-28 | Hart | Georgia | 13147 | 2896 | 58 |
1657887 | 1657887 | 2021-08-27 | Hart | Georgia | 13147 | 2896 | 58 |
1656591 | 1656591 | 2021-08-26 | Abbeville | South Carolina | 45001 | 2896 | 42 |
1608480 | 1608480 | 2021-08-11 | Pulaski | Virginia | 51155 | 2896 | 69 |
1602916 | 1602916 | 2021-08-10 | Clay | Indiana | 18021 | 2896 | 49 |
1601310 | 1601310 | 2021-08-09 | Dorado | Puerto Rico | 72051 | 2896 | |
1583476 | 1583476 | 2021-08-04 | Posey | Indiana | 18129 | 2896 | 35 |
1582440 | 1582440 | 2021-08-03 | Halifax | Virginia | 51083 | 2896 | 78 |
1574364 | 1574364 | 2021-08-01 | Todd | Minnesota | 27153 | 2896 | 33 |
1570925 | 1570925 | 2021-07-31 | Dorchester | Maryland | 24019 | 2896 | 65 |
1571116 | 1571116 | 2021-07-31 | Todd | Minnesota | 27153 | 2896 | 33 |
1567868 | 1567868 | 2021-07-30 | Todd | Minnesota | 27153 | 2896 | 33 |
1561399 | 1561399 | 2021-07-28 | Covington | Mississippi | 28031 | 2896 | 83 |
1556022 | 1556022 | 2021-07-26 | DeKalb | Tennessee | 47041 | 2896 | 57 |
1540553 | 1540553 | 2021-07-22 | Winston | Alabama | 1133 | 2896 | 72 |
1538738 | 1538738 | 2021-07-21 | Audrain | Missouri | 29007 | 2896 | 58 |
1533331 | 1533331 | 2021-07-19 | McNairy | Tennessee | 47109 | 2896 | 56 |
1530084 | 1530084 | 2021-07-18 | McNairy | Tennessee | 47109 | 2896 | 56 |
1526837 | 1526837 | 2021-07-17 | McNairy | Tennessee | 47109 | 2896 | 56 |
1523590 | 1523590 | 2021-07-16 | McNairy | Tennessee | 47109 | 2896 | 56 |
1507335 | 1507335 | 2021-07-11 | Hickman | Tennessee | 47081 | 2896 | 47 |
1504089 | 1504089 | 2021-07-10 | Hickman | Tennessee | 47081 | 2896 | 47 |
1500843 | 1500843 | 2021-07-09 | Hickman | Tennessee | 47081 | 2896 | 47 |
1496183 | 1496183 | 2021-07-08 | Morehouse | Louisiana | 22067 | 2896 | 78 |
1497734 | 1497734 | 2021-07-08 | Frio | Texas | 48163 | 2896 | 52 |
1494350 | 1494350 | 2021-07-07 | Hickman | Tennessee | 47081 | 2896 | 47 |
1489340 | 1489340 | 2021-07-06 | Bremer | Iowa | 19017 | 2896 | 62 |
1489612 | 1489612 | 2021-07-06 | Marshall | Kentucky | 21157 | 2896 | 60 |
1486093 | 1486093 | 2021-07-05 | Bremer | Iowa | 19017 | 2896 | 62 |
1486365 | 1486365 | 2021-07-05 | Marshall | Kentucky | 21157 | 2896 | 60 |
1483119 | 1483119 | 2021-07-04 | Marshall | Kentucky | 21157 | 2896 | 60 |
1483632 | 1483632 | 2021-07-04 | Saline | Missouri | 29195 | 2896 | 38 |
1479872 | 1479872 | 2021-07-03 | Marshall | Kentucky | 21157 | 2896 | 60 |
1476626 | 1476626 | 2021-07-02 | Marshall | Kentucky | 21157 | 2896 | 60 |
1473380 | 1473380 | 2021-07-01 | Marshall | Kentucky | 21157 | 2896 | 60 |
1450723 | 1450723 | 2021-06-24 | De Soto | Louisiana | 22031 | 2896 | 78 |
1443357 | 1443357 | 2021-06-22 | Delta | Colorado | 8029 | 2896 | 64 |
1432816 | 1432816 | 2021-06-18 | Frio | Texas | 48163 | 2896 | 52 |
1385092 | 1385092 | 2021-06-04 | Chattooga | Georgia | 13055 | 2896 | 74 |
1382091 | 1382091 | 2021-06-03 | McDonough | Illinois | 17109 | 2896 | 62 |
1378846 | 1378846 | 2021-06-02 | McDonough | Illinois | 17109 | 2896 | 62 |
1372741 | 1372741 | 2021-05-31 | Harlan | Kentucky | 21095 | 2896 | 84 |
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);