ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where cases = 3900 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Kentucky 12
- Georgia 11
- Kansas 10
- Minnesota 7
- Alaska 6
- Illinois 6
- Ohio 6
- Puerto Rico 6
- Louisiana 5
- Missouri 5
- Nebraska 5
- New Hampshire 5
- Pennsylvania 5
- Virginia 5
- Mississippi 4
- South Carolina 4
- West Virginia 3
- Arkansas 2
- Indiana 2
- Michigan 2
- New York 2
- North Carolina 2
- South Dakota 2
- California 1
- Colorado 1
- Hawaii 1
- Idaho 1
- Iowa 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2404661 | 2404661 | 2022-04-13 | Llano | Texas | 48299 | 3900 | 97 |
2400019 | 2400019 | 2022-04-12 | Redwood | Minnesota | 27127 | 3900 | 53 |
2401406 | 2401406 | 2022-04-12 | Llano | Texas | 48299 | 3900 | 97 |
2398151 | 2398151 | 2022-04-11 | Llano | Texas | 48299 | 3900 | 97 |
2394896 | 2394896 | 2022-04-10 | Llano | Texas | 48299 | 3900 | 97 |
2391640 | 2391640 | 2022-04-09 | Llano | Texas | 48299 | 3900 | 97 |
2388384 | 2388384 | 2022-04-08 | Llano | Texas | 48299 | 3900 | 97 |
2385129 | 2385129 | 2022-04-07 | Llano | Texas | 48299 | 3900 | 97 |
2381874 | 2381874 | 2022-04-06 | Llano | Texas | 48299 | 3900 | 97 |
2378619 | 2378619 | 2022-04-05 | Llano | Texas | 48299 | 3900 | 97 |
2375365 | 2375365 | 2022-04-04 | Llano | Texas | 48299 | 3900 | 97 |
2359653 | 2359653 | 2022-03-31 | Ketchikan Gateway Borough | Alaska | 2130 | 3900 | 17 |
2356399 | 2356399 | 2022-03-30 | Ketchikan Gateway Borough | Alaska | 2130 | 3900 | 17 |
2359428 | 2359428 | 2022-03-30 | Braxton | West Virginia | 54007 | 3900 | 42 |
2355948 | 2355948 | 2022-03-29 | Young | Texas | 48503 | 3900 | 90 |
2356174 | 2356174 | 2022-03-29 | Braxton | West Virginia | 54007 | 3900 | 42 |
2352695 | 2352695 | 2022-03-28 | Young | Texas | 48503 | 3900 | 90 |
2352796 | 2352796 | 2022-03-28 | Goochland | Virginia | 51075 | 3900 | 47 |
2347681 | 2347681 | 2022-03-27 | Webster | Kentucky | 21233 | 3900 | 48 |
2349443 | 2349443 | 2022-03-27 | Young | Texas | 48503 | 3900 | 90 |
2344428 | 2344428 | 2022-03-26 | Webster | Kentucky | 21233 | 3900 | 48 |
2346190 | 2346190 | 2022-03-26 | Young | Texas | 48503 | 3900 | 90 |
2341175 | 2341175 | 2022-03-25 | Webster | Kentucky | 21233 | 3900 | 48 |
2337922 | 2337922 | 2022-03-24 | Webster | Kentucky | 21233 | 3900 | 48 |
2339143 | 2339143 | 2022-03-24 | Aguas Buenas | Puerto Rico | 72007 | 3900 | |
2334668 | 2334668 | 2022-03-23 | Webster | Kentucky | 21233 | 3900 | 48 |
2331414 | 2331414 | 2022-03-22 | Webster | Kentucky | 21233 | 3900 | 48 |
2328162 | 2328162 | 2022-03-21 | Webster | Kentucky | 21233 | 3900 | 48 |
2319048 | 2319048 | 2022-03-18 | York | Nebraska | 31185 | 3900 | 20 |
2315795 | 2315795 | 2022-03-17 | York | Nebraska | 31185 | 3900 | 20 |
2291661 | 2291661 | 2022-03-10 | Banks | Georgia | 13011 | 3900 | 84 |
2287277 | 2287277 | 2022-03-08 | Oglala Lakota | South Dakota | 46102 | 3900 | 60 |
2256517 | 2256517 | 2022-02-27 | Casey | Kentucky | 21045 | 3900 | 66 |
2253266 | 2253266 | 2022-02-26 | Casey | Kentucky | 21045 | 3900 | 66 |
2250015 | 2250015 | 2022-02-25 | Casey | Kentucky | 21045 | 3900 | 66 |
2217378 | 2217378 | 2022-02-15 | Allen | Kansas | 20001 | 3900 | 45 |
2214127 | 2214127 | 2022-02-14 | Allen | Kansas | 20001 | 3900 | 45 |
2176723 | 2176723 | 2022-02-02 | Union | South Dakota | 46127 | 3900 | 49 |
2160276 | 2160276 | 2022-01-28 | Catano | Puerto Rico | 72033 | 3900 | |
2156251 | 2156251 | 2022-01-27 | Pike | Missouri | 29163 | 3900 | 56 |
2142262 | 2142262 | 2022-01-23 | Bond | Illinois | 17005 | 3900 | 34 |
2139007 | 2139007 | 2022-01-22 | Bond | Illinois | 17005 | 3900 | 34 |
2135751 | 2135751 | 2022-01-21 | Bond | Illinois | 17005 | 3900 | 34 |
2126351 | 2126351 | 2022-01-18 | Neosho | Kansas | 20133 | 3900 | 56 |
2123099 | 2123099 | 2022-01-17 | Neosho | Kansas | 20133 | 3900 | 56 |
2119847 | 2119847 | 2022-01-16 | Neosho | Kansas | 20133 | 3900 | 56 |
2116595 | 2116595 | 2022-01-15 | Neosho | Kansas | 20133 | 3900 | 56 |
2113344 | 2113344 | 2022-01-14 | Neosho | Kansas | 20133 | 3900 | 56 |
2049720 | 2049720 | 2021-12-25 | Dorado | Puerto Rico | 72051 | 3900 | |
2000756 | 2000756 | 2021-12-10 | Wyandot | Ohio | 39175 | 3900 | 77 |
1996761 | 1996761 | 2021-12-09 | Wabasha | Minnesota | 27157 | 3900 | 10 |
1986106 | 1986106 | 2021-12-06 | Pike | Georgia | 13231 | 3900 | 71 |
1982797 | 1982797 | 2021-12-05 | Fannin | Georgia | 13111 | 3900 | 111 |
1979547 | 1979547 | 2021-12-04 | Fannin | Georgia | 13111 | 3900 | 111 |
1976297 | 1976297 | 2021-12-03 | Fannin | Georgia | 13111 | 3900 | 111 |
1929511 | 1929511 | 2021-11-18 | Abbeville | South Carolina | 45001 | 3900 | 50 |
1904073 | 1904073 | 2021-11-10 | Gloucester | Virginia | 51073 | 3900 | 78 |
1871023 | 1871023 | 2021-10-31 | Barnwell | South Carolina | 45011 | 3900 | 84 |
1867774 | 1867774 | 2021-10-30 | Barnwell | South Carolina | 45011 | 3900 | 84 |
1864525 | 1864525 | 2021-10-29 | Barnwell | South Carolina | 45011 | 3900 | 84 |
1861235 | 1861235 | 2021-10-28 | Mayaguez | Puerto Rico | 72097 | 3900 | |
1792715 | 1792715 | 2021-10-07 | Hardin | Ohio | 39065 | 3900 | 71 |
1790124 | 1790124 | 2021-10-06 | Karnes | Texas | 48255 | 3900 | 52 |
1781459 | 1781459 | 2021-10-04 | Jerome | Idaho | 16053 | 3900 | 38 |
1749976 | 1749976 | 2021-09-24 | Saline | Missouri | 29195 | 3900 | 46 |
1739138 | 1739138 | 2021-09-21 | Peach | Georgia | 13225 | 3900 | 82 |
1721798 | 1721798 | 2021-09-15 | Cass | Texas | 48067 | 3900 | 112 |
1700609 | 1700609 | 2021-09-09 | McPherson | Kansas | 20113 | 3900 | 90 |
1697360 | 1697360 | 2021-09-08 | McPherson | Kansas | 20113 | 3900 | 90 |
1694112 | 1694112 | 2021-09-07 | McPherson | Kansas | 20113 | 3900 | 89 |
1688089 | 1688089 | 2021-09-05 | Covington | Mississippi | 28031 | 3900 | 89 |
1684839 | 1684839 | 2021-09-04 | Covington | Mississippi | 28031 | 3900 | 89 |
1685729 | 1685729 | 2021-09-04 | Snyder | Pennsylvania | 42109 | 3900 | 87 |
1681588 | 1681588 | 2021-09-03 | Covington | Mississippi | 28031 | 3900 | 89 |
1673780 | 1673780 | 2021-09-01 | Carroll | Arkansas | 5015 | 3900 | 59 |
1636988 | 1636988 | 2021-08-20 | McKean | Pennsylvania | 42083 | 3900 | 75 |
1611725 | 1611725 | 2021-08-12 | Prince George | Virginia | 51149 | 3900 | 33 |
1596884 | 1596884 | 2021-08-08 | Vernon | Louisiana | 22115 | 3900 | 114 |
1593635 | 1593635 | 2021-08-07 | Vernon | Louisiana | 22115 | 3900 | 114 |
1590386 | 1590386 | 2021-08-06 | Vernon | Louisiana | 22115 | 3900 | 114 |
1587871 | 1587871 | 2021-08-05 | Bladen | North Carolina | 37017 | 3900 | 59 |
1574290 | 1574290 | 2021-08-01 | Becker | Minnesota | 27005 | 3900 | 57 |
1571042 | 1571042 | 2021-07-31 | Becker | Minnesota | 27005 | 3900 | 57 |
1567794 | 1567794 | 2021-07-30 | Becker | Minnesota | 27005 | 3900 | 57 |
1512322 | 1512322 | 2021-07-13 | Knox | Kentucky | 21121 | 3900 | 47 |
1487070 | 1487070 | 2021-07-05 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1483824 | 1483824 | 2021-07-04 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1480578 | 1480578 | 2021-07-03 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1477331 | 1477331 | 2021-07-02 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1474085 | 1474085 | 2021-07-01 | Cheshire | New Hampshire | 33005 | 3900 | 35 |
1434969 | 1434969 | 2021-06-19 | Webster | Missouri | 29225 | 3900 | 55 |
1405291 | 1405291 | 2021-06-10 | Iberville | Louisiana | 22047 | 3900 | 100 |
1390172 | 1390172 | 2021-06-05 | Polk | Oregon | 41053 | 3900 | 55 |
1379762 | 1379762 | 2021-06-02 | Phelps | Missouri | 29161 | 3900 | 130 |
1371764 | 1371764 | 2021-05-31 | Bethel Census Area | Alaska | 2050 | 3900 | 22 |
1368518 | 1368518 | 2021-05-30 | Bethel Census Area | Alaska | 2050 | 3900 | 22 |
1365272 | 1365272 | 2021-05-29 | Bethel Census Area | Alaska | 2050 | 3900 | 22 |
1362026 | 1362026 | 2021-05-28 | Bethel Census Area | Alaska | 2050 | 3900 | 22 |
1358481 | 1358481 | 2021-05-26 | Petersburg city | Virginia | 51730 | 3900 | 86 |
1314033 | 1314033 | 2021-05-13 | Steuben | Indiana | 18151 | 3900 | 59 |
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);