ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
149 rows where cases = 3534 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 16
- Georgia 14
- Texas 11
- Indiana 9
- Minnesota 8
- Pennsylvania 8
- South Carolina 6
- Kansas 5
- Kentucky 5
- Mississippi 5
- North Carolina 5
- Tennessee 5
- Louisiana 4
- Missouri 4
- Ohio 4
- Puerto Rico 4
- Virginia 4
- Alabama 3
- Iowa 3
- Massachusetts 3
- Utah 3
- Wisconsin 3
- California 2
- Oregon 2
- Arizona 1
- Arkansas 1
- Florida 1
- Illinois 1
- Maine 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484070 | 2484070 | 2022-05-08 | Tipton | Indiana | 18159 | 3534 | 87 |
2484520 | 2484520 | 2022-05-08 | Dukes | Massachusetts | 25007 | 3534 | 0 |
2480812 | 2480812 | 2022-05-07 | Tipton | Indiana | 18159 | 3534 | 87 |
2481262 | 2481262 | 2022-05-07 | Dukes | Massachusetts | 25007 | 3534 | 0 |
2477554 | 2477554 | 2022-05-06 | Tipton | Indiana | 18159 | 3534 | 87 |
2478004 | 2478004 | 2022-05-06 | Dukes | Massachusetts | 25007 | 3534 | 0 |
2474296 | 2474296 | 2022-05-05 | Tipton | Indiana | 18159 | 3534 | 87 |
2471039 | 2471039 | 2022-05-04 | Tipton | Indiana | 18159 | 3534 | 87 |
2444118 | 2444118 | 2022-04-25 | Buffalo | Wisconsin | 55011 | 3534 | 12 |
2439096 | 2439096 | 2022-04-24 | Sibley | Minnesota | 27143 | 3534 | 24 |
2435840 | 2435840 | 2022-04-23 | Sibley | Minnesota | 27143 | 3534 | 24 |
2432584 | 2432584 | 2022-04-22 | Sibley | Minnesota | 27143 | 3534 | 24 |
2426883 | 2426883 | 2022-04-20 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2423627 | 2423627 | 2022-04-19 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2420370 | 2420370 | 2022-04-18 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2417115 | 2417115 | 2022-04-17 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2413859 | 2413859 | 2022-04-16 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2410603 | 2410603 | 2022-04-15 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2407347 | 2407347 | 2022-04-14 | Okfuskee | Oklahoma | 40107 | 3534 | 61 |
2387947 | 2387947 | 2022-04-08 | Anasco | Puerto Rico | 72011 | 3534 | |
2258425 | 2258425 | 2022-02-27 | Alleghany | Virginia | 51005 | 3534 | 92 |
2255174 | 2255174 | 2022-02-26 | Alleghany | Virginia | 51005 | 3534 | 92 |
2251923 | 2251923 | 2022-02-25 | Alleghany | Virginia | 51005 | 3534 | 92 |
2247300 | 2247300 | 2022-02-24 | Madison | Missouri | 29123 | 3534 | 49 |
2224019 | 2224019 | 2022-02-17 | Fleming | Kentucky | 21069 | 3534 | 44 |
2217665 | 2217665 | 2022-02-15 | West Carroll | Louisiana | 22123 | 3534 | 57 |
2200155 | 2200155 | 2022-02-09 | Lafayette | Wisconsin | 55065 | 3534 | 21 |
2191222 | 2191222 | 2022-02-07 | Parke | Indiana | 18121 | 3534 | 43 |
2193129 | 2193129 | 2022-02-07 | Colorado | Texas | 48089 | 3534 | 57 |
2188806 | 2188806 | 2022-02-06 | Ste. Genevieve | Missouri | 29186 | 3534 | 36 |
2175311 | 2175311 | 2022-02-02 | Washington | Kentucky | 21229 | 3534 | 54 |
2173713 | 2173713 | 2022-02-01 | Leon | Texas | 48289 | 3534 | 77 |
2165825 | 2165825 | 2022-01-30 | Redwood | Minnesota | 27127 | 3534 | 50 |
2162570 | 2162570 | 2022-01-29 | Redwood | Minnesota | 27127 | 3534 | 50 |
2159315 | 2159315 | 2022-01-28 | Redwood | Minnesota | 27127 | 3534 | 50 |
2141032 | 2141032 | 2022-01-22 | Andrews | Texas | 48003 | 3534 | 68 |
2127004 | 2127004 | 2022-01-18 | Big Horn | Montana | 30003 | 3534 | 87 |
2121179 | 2121179 | 2022-01-16 | Fulton | Pennsylvania | 42057 | 3534 | 55 |
2111245 | 2111245 | 2022-01-13 | Meigs | Ohio | 39105 | 3534 | 70 |
2098437 | 2098437 | 2022-01-09 | Montour | Pennsylvania | 42093 | 3534 | 82 |
2087333 | 2087333 | 2022-01-06 | Neosho | Kansas | 20133 | 3534 | 55 |
2084081 | 2084081 | 2022-01-05 | Neosho | Kansas | 20133 | 3534 | 55 |
2051106 | 2051106 | 2021-12-26 | Morgan | Georgia | 13211 | 3534 | 52 |
2047856 | 2047856 | 2021-12-25 | Morgan | Georgia | 13211 | 3534 | 52 |
2044606 | 2044606 | 2021-12-24 | Morgan | Georgia | 13211 | 3534 | 52 |
2031513 | 2031513 | 2021-12-20 | Berrien | Georgia | 13019 | 3534 | 72 |
1995525 | 1995525 | 2021-12-09 | Randolph | Arkansas | 5121 | 3534 | 65 |
1937319 | 1937319 | 2021-11-21 | Jones | Georgia | 13169 | 3534 | 95 |
1938754 | 1938754 | 2021-11-21 | Ashe | North Carolina | 37009 | 3534 | 53 |
1934069 | 1934069 | 2021-11-20 | Jones | Georgia | 13169 | 3534 | 95 |
1935504 | 1935504 | 2021-11-20 | Ashe | North Carolina | 37009 | 3534 | 53 |
1930817 | 1930817 | 2021-11-19 | Jones | Georgia | 13169 | 3534 | 95 |
1932254 | 1932254 | 2021-11-19 | Ashe | North Carolina | 37009 | 3534 | 53 |
1927567 | 1927567 | 2021-11-18 | Jones | Georgia | 13169 | 3534 | 95 |
1899218 | 1899218 | 2021-11-09 | Martin | Minnesota | 27091 | 3534 | 41 |
1881114 | 1881114 | 2021-11-03 | Lampasas | Texas | 48281 | 3534 | 65 |
1838821 | 1838821 | 2021-10-21 | Gonzales | Texas | 48177 | 3534 | 83 |
1835572 | 1835572 | 2021-10-20 | Gonzales | Texas | 48177 | 3534 | 83 |
1796196 | 1796196 | 2021-10-08 | Warren | Pennsylvania | 42123 | 3534 | 117 |
1765062 | 1765062 | 2021-09-29 | Dodge | Georgia | 13091 | 3534 | 117 |
1760828 | 1760828 | 2021-09-27 | Fayette | Texas | 48149 | 3534 | 87 |
1741563 | 1741563 | 2021-09-21 | St. Thomas | Virgin Islands | 78030 | 3534 | 42 |
1736051 | 1736051 | 2021-09-20 | McDonough | Illinois | 17109 | 3534 | 68 |
1723158 | 1723158 | 2021-09-16 | Posey | Indiana | 18129 | 3534 | 41 |
1719601 | 1719601 | 2021-09-15 | Haralson | Georgia | 13143 | 3534 | 99 |
1710611 | 1710611 | 2021-09-12 | Dorchester | Maryland | 24019 | 3534 | 69 |
1708431 | 1708431 | 2021-09-11 | Clarion | Pennsylvania | 42031 | 3534 | 100 |
1673859 | 1673859 | 2021-09-01 | Glenn | California | 6021 | 3534 | 30 |
1646891 | 1646891 | 2021-08-23 | Union | South Carolina | 45087 | 3534 | 84 |
1608755 | 1608755 | 2021-08-12 | Pike | Alabama | 1109 | 3534 | 80 |
1597181 | 1597181 | 2021-08-08 | Scott | Mississippi | 28123 | 3534 | 77 |
1593932 | 1593932 | 2021-08-07 | Scott | Mississippi | 28123 | 3534 | 77 |
1590683 | 1590683 | 2021-08-06 | Scott | Mississippi | 28123 | 3534 | 77 |
1591279 | 1591279 | 2021-08-06 | Champaign | Ohio | 39021 | 3534 | 60 |
1587439 | 1587439 | 2021-08-05 | Sunflower | Mississippi | 28133 | 3534 | 95 |
1552633 | 1552633 | 2021-07-25 | Vega Baja | Puerto Rico | 72145 | 3534 | |
1519902 | 1519902 | 2021-07-15 | Williams | Ohio | 39171 | 3534 | 78 |
1496941 | 1496941 | 2021-07-08 | Bladen | North Carolina | 37017 | 3534 | 49 |
1478401 | 1478401 | 2021-07-02 | Upshur | Texas | 48459 | 3534 | 77 |
1414809 | 1414809 | 2021-06-13 | Geary | Kansas | 20061 | 3534 | 40 |
1411564 | 1411564 | 2021-06-12 | Geary | Kansas | 20061 | 3534 | 40 |
1408319 | 1408319 | 2021-06-11 | Geary | Kansas | 20061 | 3534 | 40 |
1399239 | 1399239 | 2021-06-08 | Pulaski | Missouri | 29169 | 3534 | 55 |
1399874 | 1399874 | 2021-06-08 | Texas | Oklahoma | 40139 | 3534 | 34 |
1396629 | 1396629 | 2021-06-07 | Texas | Oklahoma | 40139 | 3534 | 34 |
1391368 | 1391368 | 2021-06-06 | Lake | California | 6033 | 3534 | 45 |
1393382 | 1393382 | 2021-06-06 | Texas | Oklahoma | 40139 | 3534 | 34 |
1390137 | 1390137 | 2021-06-05 | Texas | Oklahoma | 40139 | 3534 | 34 |
1390255 | 1390255 | 2021-06-05 | Arecibo | Puerto Rico | 72013 | 3534 | |
1386892 | 1386892 | 2021-06-04 | Texas | Oklahoma | 40139 | 3534 | 34 |
1383647 | 1383647 | 2021-06-03 | Texas | Oklahoma | 40139 | 3534 | 34 |
1380401 | 1380401 | 2021-06-02 | Texas | Oklahoma | 40139 | 3534 | 34 |
1361156 | 1361156 | 2021-05-27 | Marion | South Carolina | 45067 | 3534 | 107 |
1352576 | 1352576 | 2021-05-25 | Levy | Florida | 12075 | 3534 | 55 |
1353411 | 1353411 | 2021-05-25 | Oxford | Maine | 23017 | 3534 | 65 |
1340246 | 1340246 | 2021-05-21 | Calloway | Kentucky | 21035 | 3534 | 51 |
1328687 | 1328687 | 2021-05-17 | Marion | South Carolina | 45067 | 3534 | 107 |
1325441 | 1325441 | 2021-05-16 | Marion | South Carolina | 45067 | 3534 | 107 |
1274320 | 1274320 | 2021-05-01 | Dallas | Alabama | 1047 | 3534 | 150 |
1273450 | 1273450 | 2021-04-30 | Trujillo Alto | Puerto Rico | 72139 | 3534 |
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);