ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where cases = 2993 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 13
- Kentucky 13
- Idaho 11
- Arkansas 10
- Indiana 9
- Mississippi 9
- Georgia 8
- Puerto Rico 8
- West Virginia 8
- Texas 7
- Washington 7
- Louisiana 6
- Missouri 6
- Nevada 6
- Ohio 6
- California 5
- Colorado 5
- Michigan 5
- Pennsylvania 5
- Virginia 5
- North Carolina 4
- South Dakota 4
- Alabama 3
- Iowa 3
- Nebraska 3
- Florida 2
- Maryland 2
- Minnesota 2
- New York 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487126 | 2487126 | 2022-05-09 | Idaho | Idaho | 16049 | 2993 | 52 |
2483868 | 2483868 | 2022-05-08 | Idaho | Idaho | 16049 | 2993 | 52 |
2480610 | 2480610 | 2022-05-07 | Idaho | Idaho | 16049 | 2993 | 52 |
2477352 | 2477352 | 2022-05-06 | Idaho | Idaho | 16049 | 2993 | 52 |
2474094 | 2474094 | 2022-05-05 | Idaho | Idaho | 16049 | 2993 | 52 |
2470837 | 2470837 | 2022-05-04 | Idaho | Idaho | 16049 | 2993 | 52 |
2444324 | 2444324 | 2022-04-26 | Bradley | Arkansas | 5011 | 2993 | 49 |
2445538 | 2445538 | 2022-04-26 | Aitkin | Minnesota | 27001 | 2993 | 62 |
2441068 | 2441068 | 2022-04-25 | Bradley | Arkansas | 5011 | 2993 | 49 |
2437812 | 2437812 | 2022-04-24 | Bradley | Arkansas | 5011 | 2993 | 49 |
2434556 | 2434556 | 2022-04-23 | Bradley | Arkansas | 5011 | 2993 | 49 |
2431300 | 2431300 | 2022-04-22 | Bradley | Arkansas | 5011 | 2993 | 49 |
2350102 | 2350102 | 2022-03-28 | Moffat | Colorado | 8081 | 2993 | 51 |
2346849 | 2346849 | 2022-03-27 | Moffat | Colorado | 8081 | 2993 | 51 |
2343596 | 2343596 | 2022-03-26 | Moffat | Colorado | 8081 | 2993 | 51 |
2340343 | 2340343 | 2022-03-25 | Moffat | Colorado | 8081 | 2993 | 51 |
2310985 | 2310985 | 2022-03-16 | Mariposa | California | 6043 | 2993 | 30 |
2232867 | 2232867 | 2022-02-20 | Desha | Arkansas | 5041 | 2993 | 38 |
2187635 | 2187635 | 2022-02-06 | Dade | Georgia | 13083 | 2993 | 26 |
2184382 | 2184382 | 2022-02-05 | Dade | Georgia | 13083 | 2993 | 26 |
2181130 | 2181130 | 2022-02-04 | Dade | Georgia | 13083 | 2993 | 26 |
2131034 | 2131034 | 2022-01-19 | Quebradillas | Puerto Rico | 72115 | 2993 | |
2124255 | 2124255 | 2022-01-17 | Monroe | Ohio | 39111 | 2993 | 68 |
2097739 | 2097739 | 2022-01-09 | Wright | Missouri | 29229 | 2993 | 68 |
2086570 | 2086570 | 2022-01-06 | Inyo | California | 6027 | 2993 | 49 |
2076514 | 2076514 | 2022-01-02 | Wetzel | West Virginia | 54103 | 2993 | 68 |
2073263 | 2073263 | 2022-01-01 | Wetzel | West Virginia | 54103 | 2993 | 68 |
2070012 | 2070012 | 2021-12-31 | Wetzel | West Virginia | 54103 | 2993 | 68 |
2066761 | 2066761 | 2021-12-30 | Wetzel | West Virginia | 54103 | 2993 | 68 |
2052656 | 2052656 | 2021-12-26 | Richland | North Dakota | 38077 | 2993 | 21 |
2035933 | 2035933 | 2021-12-21 | Morgan | Missouri | 29141 | 2993 | 75 |
2030389 | 2030389 | 2021-12-19 | Union | South Dakota | 46127 | 2993 | 46 |
2027138 | 2027138 | 2021-12-18 | Union | South Dakota | 46127 | 2993 | 46 |
2023887 | 2023887 | 2021-12-17 | Union | South Dakota | 46127 | 2993 | 46 |
2023988 | 2023988 | 2021-12-17 | Andrews | Texas | 48003 | 2993 | 65 |
2017694 | 2017694 | 2021-12-15 | Shelby | Texas | 48419 | 2993 | 113 |
1996419 | 1996419 | 2021-12-09 | Lawrence | Kentucky | 21127 | 2993 | 44 |
1988410 | 1988410 | 2021-12-06 | Panola | Texas | 48365 | 2993 | 109 |
1983646 | 1983646 | 2021-12-05 | Manistee | Michigan | 26101 | 2993 | 49 |
1980396 | 1980396 | 2021-12-04 | Manistee | Michigan | 26101 | 2993 | 49 |
1977146 | 1977146 | 2021-12-03 | Manistee | Michigan | 26101 | 2993 | 49 |
1963940 | 1963940 | 2021-11-29 | Morgan | Kentucky | 21175 | 2993 | 11 |
1960235 | 1960235 | 2021-11-28 | Hancock | Illinois | 17067 | 2993 | 45 |
1962663 | 1962663 | 2021-11-28 | Asotin | Washington | 53003 | 2993 | 50 |
1956984 | 1956984 | 2021-11-27 | Hancock | Illinois | 17067 | 2993 | 45 |
1959412 | 1959412 | 2021-11-27 | Asotin | Washington | 53003 | 2993 | 50 |
1953733 | 1953733 | 2021-11-26 | Hancock | Illinois | 17067 | 2993 | 45 |
1956161 | 1956161 | 2021-11-26 | Asotin | Washington | 53003 | 2993 | 50 |
1950482 | 1950482 | 2021-11-25 | Hancock | Illinois | 17067 | 2993 | 45 |
1952910 | 1952910 | 2021-11-25 | Asotin | Washington | 53003 | 2993 | 50 |
1947231 | 1947231 | 2021-11-24 | Hancock | Illinois | 17067 | 2993 | 45 |
1949659 | 1949659 | 2021-11-24 | Asotin | Washington | 53003 | 2993 | 50 |
1931843 | 1931843 | 2021-11-19 | Andrew | Missouri | 29003 | 2993 | 38 |
1923623 | 1923623 | 2021-11-16 | Radford city | Virginia | 51750 | 2993 | 35 |
1917521 | 1917521 | 2021-11-15 | Sharp | Arkansas | 5135 | 2993 | 71 |
1918771 | 1918771 | 2021-11-15 | Clarke | Mississippi | 28023 | 2993 | 95 |
1888263 | 1888263 | 2021-11-06 | Polk | Arkansas | 5113 | 2993 | 112 |
1885013 | 1885013 | 2021-11-05 | Polk | Arkansas | 5113 | 2993 | 112 |
1880719 | 1880719 | 2021-11-03 | Juncos | Puerto Rico | 72077 | 2993 | |
1877470 | 1877470 | 2021-11-02 | Juncos | Puerto Rico | 72077 | 2993 | |
1877864 | 1877864 | 2021-11-02 | Lamb | Texas | 48279 | 2993 | 89 |
1874221 | 1874221 | 2021-11-01 | Juncos | Puerto Rico | 72077 | 2993 | |
1870972 | 1870972 | 2021-10-31 | Juncos | Puerto Rico | 72077 | 2993 | |
1860210 | 1860210 | 2021-10-28 | Hubbard | Minnesota | 27057 | 2993 | 44 |
1806579 | 1806579 | 2021-10-11 | Dinwiddie | Virginia | 51053 | 2993 | 50 |
1800560 | 1800560 | 2021-10-10 | Colusa | California | 6011 | 2993 | 18 |
1803329 | 1803329 | 2021-10-10 | Dinwiddie | Virginia | 51053 | 2993 | 50 |
1797311 | 1797311 | 2021-10-09 | Colusa | California | 6011 | 2993 | 18 |
1800080 | 1800080 | 2021-10-09 | Dinwiddie | Virginia | 51053 | 2993 | 50 |
1794062 | 1794062 | 2021-10-08 | Colusa | California | 6011 | 2993 | 18 |
1796831 | 1796831 | 2021-10-08 | Dinwiddie | Virginia | 51053 | 2993 | 50 |
1788950 | 1788950 | 2021-10-06 | Perry | Missouri | 29157 | 2993 | 32 |
1782516 | 1782516 | 2021-10-04 | Lincoln | Montana | 30053 | 2993 | 45 |
1778317 | 1778317 | 2021-10-03 | Union | Illinois | 17181 | 2993 | 51 |
1779993 | 1779993 | 2021-10-03 | Humacao | Puerto Rico | 72069 | 2993 | |
1775067 | 1775067 | 2021-10-02 | Union | Illinois | 17181 | 2993 | 51 |
1771817 | 1771817 | 2021-10-01 | Union | Illinois | 17181 | 2993 | 51 |
1759238 | 1759238 | 2021-09-27 | Simpson | Kentucky | 21213 | 2993 | 47 |
1739289 | 1739289 | 2021-09-21 | Lawrence | Illinois | 17101 | 2993 | 40 |
1733259 | 1733259 | 2021-09-19 | Woodford | Kentucky | 21239 | 2993 | 25 |
1734472 | 1734472 | 2021-09-19 | Aguadilla | Puerto Rico | 72005 | 2993 | |
1730009 | 1730009 | 2021-09-18 | Woodford | Kentucky | 21239 | 2993 | 25 |
1726759 | 1726759 | 2021-09-17 | Woodford | Kentucky | 21239 | 2993 | 25 |
1713751 | 1713751 | 2021-09-13 | Russell | Kentucky | 21207 | 2993 | 50 |
1710504 | 1710504 | 2021-09-12 | Russell | Kentucky | 21207 | 2993 | 50 |
1707257 | 1707257 | 2021-09-11 | Russell | Kentucky | 21207 | 2993 | 50 |
1685509 | 1685509 | 2021-09-04 | Holmes | Ohio | 39075 | 2993 | 103 |
1674196 | 1674196 | 2021-09-01 | Union | Georgia | 13291 | 2993 | 87 |
1671008 | 1671008 | 2021-08-31 | Payette | Idaho | 16075 | 2993 | 39 |
1669099 | 1669099 | 2021-08-30 | Dare | North Carolina | 37055 | 2993 | 10 |
1652096 | 1652096 | 2021-08-25 | St. James | Louisiana | 22093 | 2993 | 58 |
1642275 | 1642275 | 2021-08-22 | Ohio | Kentucky | 21183 | 2993 | 58 |
1639025 | 1639025 | 2021-08-21 | Ohio | Kentucky | 21183 | 2993 | 58 |
1635775 | 1635775 | 2021-08-20 | Ohio | Kentucky | 21183 | 2993 | 58 |
1630270 | 1630270 | 2021-08-18 | Fayette | Ohio | 39047 | 2993 | 50 |
1605943 | 1605943 | 2021-08-11 | Monroe | Georgia | 13207 | 2993 | 106 |
1608592 | 1608592 | 2021-08-11 | Randolph | West Virginia | 54083 | 2993 | 17 |
1580189 | 1580189 | 2021-08-03 | Greene | Indiana | 18055 | 2993 | 89 |
1576276 | 1576276 | 2021-08-02 | Winston | Alabama | 1133 | 2993 | 73 |
1565342 | 1565342 | 2021-07-29 | Perry | Ohio | 39127 | 2993 | 50 |
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);