ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
178 rows where cases = 2680 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 18
- Georgia 16
- Tennessee 12
- Indiana 10
- Illinois 9
- Kentucky 9
- Wisconsin 8
- Missouri 7
- Virginia 7
- Minnesota 6
- Mississippi 6
- Texas 6
- Idaho 5
- Iowa 5
- Pennsylvania 5
- West Virginia 5
- Arkansas 4
- Florida 4
- Nebraska 4
- Ohio 4
- Puerto Rico 4
- Alaska 3
- Louisiana 3
- Maryland 3
- Oregon 3
- Montana 2
- Oklahoma 2
- South Carolina 2
- Alabama 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499256 | 2499256 | 2022-05-12 | Amelia | Virginia | 51007 | 2680 | 60 |
2469576 | 2469576 | 2022-05-03 | Houston | Tennessee | 47083 | 2680 | 61 |
2466320 | 2466320 | 2022-05-02 | Houston | Tennessee | 47083 | 2680 | 61 |
2463065 | 2463065 | 2022-05-01 | Houston | Tennessee | 47083 | 2680 | 61 |
2459809 | 2459809 | 2022-04-30 | Houston | Tennessee | 47083 | 2680 | 61 |
2456553 | 2456553 | 2022-04-29 | Houston | Tennessee | 47083 | 2680 | 61 |
2453297 | 2453297 | 2022-04-28 | Houston | Tennessee | 47083 | 2680 | 61 |
2453901 | 2453901 | 2022-04-28 | Forest | Wisconsin | 55041 | 2680 | 52 |
2450041 | 2450041 | 2022-04-27 | Houston | Tennessee | 47083 | 2680 | 61 |
2450645 | 2450645 | 2022-04-27 | Forest | Wisconsin | 55041 | 2680 | 52 |
2447389 | 2447389 | 2022-04-26 | Forest | Wisconsin | 55041 | 2680 | 52 |
2444133 | 2444133 | 2022-04-25 | Forest | Wisconsin | 55041 | 2680 | 52 |
2406040 | 2406040 | 2022-04-14 | Brown | Kansas | 20013 | 2680 | 46 |
2402784 | 2402784 | 2022-04-13 | Brown | Kansas | 20013 | 2680 | 46 |
2399530 | 2399530 | 2022-04-12 | Brown | Kansas | 20013 | 2680 | 46 |
2396274 | 2396274 | 2022-04-11 | Brown | Kansas | 20013 | 2680 | 46 |
2393019 | 2393019 | 2022-04-10 | Brown | Kansas | 20013 | 2680 | 46 |
2389763 | 2389763 | 2022-04-09 | Brown | Kansas | 20013 | 2680 | 46 |
2386507 | 2386507 | 2022-04-08 | Brown | Kansas | 20013 | 2680 | 46 |
2331887 | 2331887 | 2022-03-22 | Ripley | Missouri | 29181 | 2680 | 61 |
2314933 | 2314933 | 2022-03-17 | Brown | Kansas | 20013 | 2680 | 47 |
2311680 | 2311680 | 2022-03-16 | Brown | Kansas | 20013 | 2680 | 47 |
2308427 | 2308427 | 2022-03-15 | Brown | Kansas | 20013 | 2680 | 47 |
2305176 | 2305176 | 2022-03-14 | Brown | Kansas | 20013 | 2680 | 47 |
2301924 | 2301924 | 2022-03-13 | Brown | Kansas | 20013 | 2680 | 47 |
2298672 | 2298672 | 2022-03-12 | Brown | Kansas | 20013 | 2680 | 47 |
2295420 | 2295420 | 2022-03-11 | Brown | Kansas | 20013 | 2680 | 47 |
2292168 | 2292168 | 2022-03-10 | Brown | Kansas | 20013 | 2680 | 47 |
2288916 | 2288916 | 2022-03-09 | Brown | Kansas | 20013 | 2680 | 47 |
2210638 | 2210638 | 2022-02-13 | Marshall | Illinois | 17123 | 2680 | 31 |
2207385 | 2207385 | 2022-02-12 | Marshall | Illinois | 17123 | 2680 | 31 |
2204132 | 2204132 | 2022-02-11 | Marshall | Illinois | 17123 | 2680 | 31 |
2200879 | 2200879 | 2022-02-10 | Marshall | Illinois | 17123 | 2680 | 31 |
2195178 | 2195178 | 2022-02-08 | Noxubee | Mississippi | 28103 | 2680 | 47 |
2188962 | 2188962 | 2022-02-06 | Unknown | Nebraska | 2680 | 354 | |
2185709 | 2185709 | 2022-02-05 | Unknown | Nebraska | 2680 | 354 | |
2182457 | 2182457 | 2022-02-04 | Unknown | Nebraska | 2680 | 354 | |
2122287 | 2122287 | 2022-01-17 | Little River | Arkansas | 5081 | 2680 | 85 |
2103126 | 2103126 | 2022-01-11 | Oglethorpe | Georgia | 13221 | 2680 | 44 |
2063463 | 2063463 | 2021-12-29 | Braxton | West Virginia | 54007 | 2680 | 31 |
2054880 | 2054880 | 2021-12-27 | Caldwell | Kentucky | 21033 | 2680 | 53 |
2028255 | 2028255 | 2021-12-19 | Bacon | Georgia | 13005 | 2680 | 64 |
2028629 | 2028629 | 2021-12-19 | Pike | Indiana | 18125 | 2680 | 46 |
2025004 | 2025004 | 2021-12-18 | Bacon | Georgia | 13005 | 2680 | 64 |
2025378 | 2025378 | 2021-12-18 | Pike | Indiana | 18125 | 2680 | 46 |
2021753 | 2021753 | 2021-12-17 | Bacon | Georgia | 13005 | 2680 | 64 |
2022127 | 2022127 | 2021-12-17 | Pike | Indiana | 18125 | 2680 | 46 |
2018502 | 2018502 | 2021-12-16 | Bacon | Georgia | 13005 | 2680 | 64 |
1988050 | 1988050 | 2021-12-06 | Lee | South Carolina | 45061 | 2680 | 79 |
1982431 | 1982431 | 2021-12-05 | Kodiak Island Borough | Alaska | 2150 | 2680 | 9 |
1979181 | 1979181 | 2021-12-04 | Kodiak Island Borough | Alaska | 2150 | 2680 | 9 |
1975931 | 1975931 | 2021-12-03 | Kodiak Island Borough | Alaska | 2150 | 2680 | 9 |
1967495 | 1967495 | 2021-11-30 | Renville | Minnesota | 27129 | 2680 | 51 |
1967751 | 1967751 | 2021-11-30 | Park | Montana | 30067 | 2680 | 30 |
1859620 | 1859620 | 2021-10-28 | Perry | Indiana | 18123 | 2680 | 55 |
1852969 | 1852969 | 2021-10-26 | Clark | Illinois | 17023 | 2680 | 48 |
1853751 | 1853751 | 2021-10-26 | Roseau | Minnesota | 27135 | 2680 | 27 |
1828691 | 1828691 | 2021-10-18 | Wyoming | Pennsylvania | 42131 | 2680 | 59 |
1788008 | 1788008 | 2021-10-06 | Hancock | Illinois | 17067 | 2680 | 45 |
1785095 | 1785095 | 2021-10-05 | Pottawatomie | Kansas | 20149 | 2680 | 41 |
1787340 | 1787340 | 2021-10-05 | Vernon | Wisconsin | 55123 | 2680 | 54 |
1781846 | 1781846 | 2021-10-04 | Pottawatomie | Kansas | 20149 | 2680 | 41 |
1778734 | 1778734 | 2021-10-03 | Spencer | Kentucky | 21215 | 2680 | 28 |
1775484 | 1775484 | 2021-10-02 | Spencer | Kentucky | 21215 | 2680 | 28 |
1772234 | 1772234 | 2021-10-01 | Spencer | Kentucky | 21215 | 2680 | 28 |
1723478 | 1723478 | 2021-09-16 | Morgan | Kentucky | 21175 | 2680 | 5 |
1718386 | 1718386 | 2021-09-14 | Hughes | South Dakota | 46065 | 2680 | 43 |
1651546 | 1651546 | 2021-08-25 | Crawford | Illinois | 17033 | 2680 | 43 |
1636744 | 1636744 | 2021-08-20 | Adams | Ohio | 39001 | 2680 | 59 |
1634045 | 1634045 | 2021-08-19 | Trousdale | Tennessee | 47169 | 2680 | 22 |
1601606 | 1601606 | 2021-08-09 | Calhoun | Texas | 48057 | 2680 | 26 |
1598358 | 1598358 | 2021-08-08 | Calhoun | Texas | 48057 | 2680 | 26 |
1595109 | 1595109 | 2021-08-07 | Calhoun | Texas | 48057 | 2680 | 26 |
1585301 | 1585301 | 2021-08-04 | Morgan | Tennessee | 47129 | 2680 | 39 |
1580052 | 1580052 | 2021-08-03 | Payette | Idaho | 16075 | 2680 | 39 |
1577301 | 1577301 | 2021-08-02 | Ohio | Kentucky | 21183 | 2680 | 55 |
1558629 | 1558629 | 2021-07-27 | Anson | North Carolina | 37007 | 2680 | 57 |
1550747 | 1550747 | 2021-07-25 | Sumter | Georgia | 13261 | 2680 | 106 |
1547500 | 1547500 | 2021-07-24 | Sumter | Georgia | 13261 | 2680 | 106 |
1544253 | 1544253 | 2021-07-23 | Sumter | Georgia | 13261 | 2680 | 106 |
1538840 | 1538840 | 2021-07-21 | Stoddard | Missouri | 29207 | 2680 | 44 |
1539619 | 1539619 | 2021-07-21 | Mayaguez | Puerto Rico | 72097 | 2680 | |
1528080 | 1528080 | 2021-07-18 | Jerome | Idaho | 16053 | 2680 | 24 |
1524833 | 1524833 | 2021-07-17 | Jerome | Idaho | 16053 | 2680 | 24 |
1521585 | 1521585 | 2021-07-16 | Jerome | Idaho | 16053 | 2680 | 24 |
1518337 | 1518337 | 2021-07-15 | Jerome | Idaho | 16053 | 2680 | 24 |
1511723 | 1511723 | 2021-07-13 | Harris | Georgia | 13145 | 2680 | 63 |
1455818 | 1455818 | 2021-06-25 | Hopewell city | Virginia | 51670 | 2680 | 79 |
1442206 | 1442206 | 2021-06-21 | Dorado | Puerto Rico | 72051 | 2680 | |
1438961 | 1438961 | 2021-06-20 | Dorado | Puerto Rico | 72051 | 2680 | |
1429810 | 1429810 | 2021-06-17 | Caroline | Virginia | 51033 | 2680 | 38 |
1414344 | 1414344 | 2021-06-13 | Haralson | Georgia | 13143 | 2680 | 89 |
1409467 | 1409467 | 2021-06-11 | Coshocton | Ohio | 39031 | 2680 | 59 |
1398476 | 1398476 | 2021-06-08 | Crawford | Iowa | 19047 | 2680 | 40 |
1398816 | 1398816 | 2021-06-08 | Pointe Coupee | Louisiana | 22077 | 2680 | 75 |
1395229 | 1395229 | 2021-06-07 | Crawford | Iowa | 19047 | 2680 | 40 |
1391984 | 1391984 | 2021-06-06 | Crawford | Iowa | 19047 | 2680 | 40 |
1385478 | 1385478 | 2021-06-04 | Boone | Iowa | 19015 | 2680 | 34 |
1381239 | 1381239 | 2021-06-02 | Wythe | Virginia | 51197 | 2680 | 81 |
1377964 | 1377964 | 2021-06-01 | Pulaski | Virginia | 51155 | 2680 | 61 |
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);