ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 2875 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 13
- Georgia 12
- Virginia 11
- Kentucky 10
- Tennessee 10
- Texas 10
- Arkansas 8
- Oklahoma 8
- Alaska 7
- South Dakota 7
- Minnesota 6
- North Carolina 6
- Wisconsin 6
- West Virginia 5
- Indiana 4
- Louisiana 4
- Ohio 4
- Alabama 3
- Florida 3
- Illinois 3
- Puerto Rico 3
- Utah 3
- California 2
- Colorado 2
- Iowa 2
- Maryland 2
- Michigan 2
- Mississippi 2
- Oregon 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500663 | 2500663 | 2022-05-13 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2497405 | 2497405 | 2022-05-12 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2494147 | 2494147 | 2022-05-11 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2490889 | 2490889 | 2022-05-10 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2487632 | 2487632 | 2022-05-09 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2433845 | 2433845 | 2022-04-22 | Callahan | Texas | 48059 | 2875 | 72 |
2430589 | 2430589 | 2022-04-21 | Callahan | Texas | 48059 | 2875 | 72 |
2385037 | 2385037 | 2022-04-07 | Dawson | Texas | 48115 | 2875 | 94 |
2372836 | 2372836 | 2022-04-04 | Archuleta | Colorado | 8007 | 2875 | 15 |
2353159 | 2353159 | 2022-03-29 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2349907 | 2349907 | 2022-03-28 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2346654 | 2346654 | 2022-03-27 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2343401 | 2343401 | 2022-03-26 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2340148 | 2340148 | 2022-03-25 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2336895 | 2336895 | 2022-03-24 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2333641 | 2333641 | 2022-03-23 | Valdez-Cordova Census Area | Alaska | 2261 | 2875 | 17 |
2265395 | 2265395 | 2022-03-02 | Lee | Arkansas | 5077 | 2875 | 58 |
2264886 | 2264886 | 2022-03-01 | Juab | Utah | 49023 | 2875 | 22 |
2237504 | 2237504 | 2022-02-21 | Cedar | Missouri | 29039 | 2875 | 44 |
2234253 | 2234253 | 2022-02-20 | Cedar | Missouri | 29039 | 2875 | 44 |
2231002 | 2231002 | 2022-02-19 | Cedar | Missouri | 29039 | 2875 | 44 |
2227751 | 2227751 | 2022-02-18 | Cedar | Missouri | 29039 | 2875 | 44 |
2219750 | 2219750 | 2022-02-16 | Coosa | Alabama | 1037 | 2875 | 53 |
2217869 | 2217869 | 2022-02-15 | Pope | Minnesota | 27121 | 2875 | 17 |
2144001 | 2144001 | 2022-01-23 | Barceloneta | Puerto Rico | 72017 | 2875 | |
2139978 | 2139978 | 2022-01-22 | Osage | Missouri | 29151 | 2875 | 39 |
2137269 | 2137269 | 2022-01-21 | Morgan | Ohio | 39115 | 2875 | 48 |
2133007 | 2133007 | 2022-01-20 | Trigg | Kentucky | 21221 | 2875 | 34 |
2128923 | 2128923 | 2022-01-19 | Las Animas | Colorado | 8071 | 2875 | 35 |
2121862 | 2121862 | 2022-01-16 | Giles | Virginia | 51071 | 2875 | 38 |
2118610 | 2118610 | 2022-01-15 | Giles | Virginia | 51071 | 2875 | 38 |
2115358 | 2115358 | 2022-01-14 | Giles | Virginia | 51071 | 2875 | 38 |
2095752 | 2095752 | 2022-01-08 | Zavala | Texas | 48507 | 2875 | 56 |
2055476 | 2055476 | 2021-12-27 | Wright | Missouri | 29229 | 2875 | 66 |
2012004 | 2012004 | 2021-12-14 | Banks | Georgia | 13011 | 2875 | 68 |
1963475 | 1963475 | 2021-11-29 | Edgar | Illinois | 17045 | 2875 | 70 |
1928930 | 1928930 | 2021-11-18 | Roosevelt | New Mexico | 35041 | 2875 | 70 |
1916045 | 1916045 | 2021-11-14 | Hertford | North Carolina | 37091 | 2875 | 72 |
1912795 | 1912795 | 2021-11-13 | Hertford | North Carolina | 37091 | 2875 | 72 |
1909545 | 1909545 | 2021-11-12 | Hertford | North Carolina | 37091 | 2875 | 72 |
1906277 | 1906277 | 2021-11-11 | Currituck | North Carolina | 37053 | 2875 | 27 |
1903028 | 1903028 | 2021-11-10 | Currituck | North Carolina | 37053 | 2875 | 27 |
1901001 | 1901001 | 2021-11-09 | Adams | Wisconsin | 55001 | 2875 | 33 |
1887675 | 1887675 | 2021-11-05 | San Jacinto | Texas | 48407 | 2875 | 79 |
1855742 | 1855742 | 2021-10-27 | Grant | Arkansas | 5053 | 2875 | 50 |
1838343 | 1838343 | 2021-10-21 | Crook | Oregon | 41013 | 2875 | 46 |
1823077 | 1823077 | 2021-10-16 | Taylor | Wisconsin | 55119 | 2875 | 44 |
1819828 | 1819828 | 2021-10-15 | Taylor | Wisconsin | 55119 | 2875 | 44 |
1816579 | 1816579 | 2021-10-14 | Taylor | Wisconsin | 55119 | 2875 | 44 |
1798707 | 1798707 | 2021-10-09 | Ray | Missouri | 29177 | 2875 | 48 |
1793999 | 1793999 | 2021-10-08 | Cross | Arkansas | 5037 | 2875 | 59 |
1794009 | 1794009 | 2021-10-08 | Hempstead | Arkansas | 5057 | 2875 | 27 |
1795458 | 1795458 | 2021-10-08 | Ray | Missouri | 29177 | 2875 | 48 |
1786729 | 1786729 | 2021-10-05 | Sequatchie | Tennessee | 47153 | 2875 | 30 |
1784062 | 1784062 | 2021-10-04 | Langlade | Wisconsin | 55067 | 2875 | 54 |
1770669 | 1770669 | 2021-09-30 | Montague | Texas | 48337 | 2875 | 84 |
1759233 | 1759233 | 2021-09-27 | Rockcastle | Kentucky | 21203 | 2875 | 25 |
1723798 | 1723798 | 2021-09-16 | Waseca | Minnesota | 27161 | 2875 | 25 |
1724794 | 1724794 | 2021-09-16 | Vega Alta | Puerto Rico | 72143 | 2875 | |
1725154 | 1725154 | 2021-09-16 | Lamb | Texas | 48279 | 2875 | 87 |
1712435 | 1712435 | 2021-09-12 | Russell | Virginia | 51167 | 2875 | 42 |
1709188 | 1709188 | 2021-09-11 | Russell | Virginia | 51167 | 2875 | 42 |
1705941 | 1705941 | 2021-09-10 | Russell | Virginia | 51167 | 2875 | 42 |
1700096 | 1700096 | 2021-09-09 | Elbert | Georgia | 13105 | 2875 | 77 |
1679276 | 1679276 | 2021-09-02 | Humacao | Puerto Rico | 72069 | 2875 | |
1673180 | 1673180 | 2021-08-31 | Lampasas | Texas | 48281 | 2875 | 41 |
1651364 | 1651364 | 2021-08-25 | Dodge | Georgia | 13091 | 2875 | 112 |
1630419 | 1630419 | 2021-08-18 | Coos | Oregon | 41011 | 2875 | 44 |
1622214 | 1622214 | 2021-08-16 | Tattnall | Georgia | 13267 | 2875 | 72 |
1620952 | 1620952 | 2021-08-15 | Meade | South Dakota | 46093 | 2875 | 31 |
1617704 | 1617704 | 2021-08-14 | Meade | South Dakota | 46093 | 2875 | 31 |
1614456 | 1614456 | 2021-08-13 | Meade | South Dakota | 46093 | 2875 | 31 |
1564429 | 1564429 | 2021-07-29 | Dorchester | Maryland | 24019 | 2875 | 65 |
1564789 | 1564789 | 2021-07-29 | Nodaway | Missouri | 29147 | 2875 | 27 |
1561541 | 1561541 | 2021-07-28 | Nodaway | Missouri | 29147 | 2875 | 27 |
1562668 | 1562668 | 2021-07-28 | Fayette | Texas | 48149 | 2875 | 69 |
1558293 | 1558293 | 2021-07-27 | Nodaway | Missouri | 29147 | 2875 | 27 |
1555083 | 1555083 | 2021-07-26 | Washington | Missouri | 29221 | 2875 | 53 |
1550706 | 1550706 | 2021-07-25 | Lee | Georgia | 13177 | 2875 | 59 |
1547459 | 1547459 | 2021-07-24 | Lee | Georgia | 13177 | 2875 | 59 |
1544212 | 1544212 | 2021-07-23 | Lee | Georgia | 13177 | 2875 | 59 |
1539323 | 1539323 | 2021-07-21 | Fayette | Ohio | 39047 | 2875 | 50 |
1534058 | 1534058 | 2021-07-20 | Winston | Alabama | 1133 | 2875 | 72 |
1536279 | 1536279 | 2021-07-20 | Elk | Pennsylvania | 42047 | 2875 | 41 |
1532080 | 1532080 | 2021-07-19 | Cass | Minnesota | 27021 | 2875 | 33 |
1515843 | 1515843 | 2021-07-14 | Cass | Minnesota | 27021 | 2875 | 33 |
1513807 | 1513807 | 2021-07-13 | DeKalb | Tennessee | 47041 | 2875 | 56 |
1510561 | 1510561 | 2021-07-12 | DeKalb | Tennessee | 47041 | 2875 | 56 |
1507693 | 1507693 | 2021-07-11 | Accomack | Virginia | 51001 | 2875 | 46 |
1504447 | 1504447 | 2021-07-10 | Accomack | Virginia | 51001 | 2875 | 46 |
1460477 | 1460477 | 2021-06-27 | Morehouse | Louisiana | 22067 | 2875 | 78 |
1461868 | 1461868 | 2021-06-27 | DeKalb | Tennessee | 47041 | 2875 | 56 |
1457232 | 1457232 | 2021-06-26 | Morehouse | Louisiana | 22067 | 2875 | 78 |
1458623 | 1458623 | 2021-06-26 | DeKalb | Tennessee | 47041 | 2875 | 56 |
1453987 | 1453987 | 2021-06-25 | Morehouse | Louisiana | 22067 | 2875 | 78 |
1455378 | 1455378 | 2021-06-25 | DeKalb | Tennessee | 47041 | 2875 | 56 |
1448927 | 1448927 | 2021-06-23 | McNairy | Tennessee | 47109 | 2875 | 55 |
1439506 | 1439506 | 2021-06-20 | Uintah | Utah | 49047 | 2875 | 25 |
1421105 | 1421105 | 2021-06-15 | Greene | Indiana | 18055 | 2875 | 89 |
1421510 | 1421510 | 2021-06-15 | De Soto | Louisiana | 22031 | 2875 | 78 |
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);