ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 3335 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 18
- Illinois 8
- Kentucky 7
- Colorado 6
- North Carolina 6
- Florida 5
- Indiana 5
- Alabama 4
- Arkansas 4
- Georgia 4
- Oregon 4
- Puerto Rico 4
- Tennessee 4
- Virginia 4
- Maine 3
- Minnesota 3
- Missouri 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Louisiana 2
- Maryland 2
- Michigan 2
- South Dakota 2
- California 1
- Massachusetts 1
- Mississippi 1
- Nebraska 1
- New Hampshire 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2385397 | 2385397 | 2022-04-07 | Southampton | Virginia | 51175 | 3335 | 89 |
2380910 | 2380910 | 2022-04-06 | Unknown | New Jersey | 3335 | 0 | |
2303078 | 2303078 | 2022-03-13 | Walsh | North Dakota | 38099 | 3335 | 34 |
2289750 | 2289750 | 2022-03-09 | Otoe | Nebraska | 31131 | 3335 | 17 |
2262614 | 2262614 | 2022-03-01 | Cumberland | Illinois | 17035 | 3335 | 49 |
2259363 | 2259363 | 2022-02-28 | Cumberland | Illinois | 17035 | 3335 | 49 |
2209605 | 2209605 | 2022-02-12 | Zapata | Texas | 48505 | 3335 | 48 |
2203242 | 2203242 | 2022-02-10 | Patrick | Virginia | 51141 | 3335 | 80 |
2191689 | 2191689 | 2022-02-07 | Dukes | Massachusetts | 25007 | 3335 | 0 |
2157341 | 2157341 | 2022-01-27 | Colorado | Texas | 48089 | 3335 | 57 |
2148949 | 2148949 | 2022-01-25 | Tipton | Indiana | 18159 | 3335 | 79 |
2143185 | 2143185 | 2022-01-23 | Dallas | Missouri | 29059 | 3335 | 64 |
2123330 | 2123330 | 2022-01-17 | Lincoln | Maine | 23015 | 3335 | 16 |
2120078 | 2120078 | 2022-01-16 | Lincoln | Maine | 23015 | 3335 | 16 |
2116826 | 2116826 | 2022-01-15 | Lincoln | Maine | 23015 | 3335 | 16 |
2118511 | 2118511 | 2022-01-15 | Young | Texas | 48503 | 3335 | 75 |
2098960 | 2098960 | 2022-01-09 | Shelby | Texas | 48419 | 3335 | 115 |
2079845 | 2079845 | 2022-01-03 | Carbon | Wyoming | 56007 | 3335 | 46 |
2057401 | 2057401 | 2021-12-28 | Otero | Colorado | 8089 | 3335 | 115 |
2039452 | 2039452 | 2021-12-22 | San Miguel | New Mexico | 35047 | 3335 | 33 |
2015366 | 2015366 | 2021-12-15 | Putnam | Georgia | 13237 | 3335 | 88 |
1986294 | 1986294 | 2021-12-06 | Union | Illinois | 17181 | 3335 | 54 |
1971746 | 1971746 | 2021-12-01 | Rio Grande | Puerto Rico | 72119 | 3335 | |
1968496 | 1968496 | 2021-11-30 | Rio Grande | Puerto Rico | 72119 | 3335 | |
1965245 | 1965245 | 2021-11-29 | Rio Grande | Puerto Rico | 72119 | 3335 | |
1946407 | 1946407 | 2021-11-23 | Adams | Washington | 53001 | 3335 | 34 |
1933715 | 1933715 | 2021-11-20 | Clark | Arkansas | 5019 | 3335 | 60 |
1882039 | 1882039 | 2021-11-04 | Elbert | Georgia | 13105 | 3335 | 87 |
1878397 | 1878397 | 2021-11-03 | Monroe | Alabama | 1099 | 3335 | 66 |
1875148 | 1875148 | 2021-11-02 | Monroe | Alabama | 1099 | 3335 | 65 |
1855611 | 1855611 | 2021-10-27 | Butler | Alabama | 1013 | 3335 | 96 |
1853578 | 1853578 | 2021-10-26 | Somerset | Maryland | 24039 | 3335 | 53 |
1810760 | 1810760 | 2021-10-13 | Jersey | Illinois | 17083 | 3335 | 72 |
1755044 | 1755044 | 2021-09-26 | Ouachita | Arkansas | 5103 | 3335 | 75 |
1757114 | 1757114 | 2021-09-26 | Columbia | Oregon | 41009 | 3335 | 39 |
1753866 | 1753866 | 2021-09-25 | Columbia | Oregon | 41009 | 3335 | 39 |
1750618 | 1750618 | 2021-09-24 | Columbia | Oregon | 41009 | 3335 | 39 |
1750742 | 1750742 | 2021-09-24 | Dorado | Puerto Rico | 72051 | 3335 | |
1744596 | 1744596 | 2021-09-22 | Gillespie | Texas | 48171 | 3335 | 68 |
1739902 | 1739902 | 2021-09-21 | Dickinson | Michigan | 26043 | 3335 | 75 |
1736653 | 1736653 | 2021-09-20 | Dickinson | Michigan | 26043 | 3335 | 75 |
1724477 | 1724477 | 2021-09-16 | Gallia | Ohio | 39053 | 3335 | 54 |
1700875 | 1700875 | 2021-09-09 | Queen Anne's | Maryland | 24035 | 3335 | 59 |
1695947 | 1695947 | 2021-09-07 | Milam | Texas | 48331 | 3335 | 63 |
1692699 | 1692699 | 2021-09-06 | Milam | Texas | 48331 | 3335 | 63 |
1688780 | 1688780 | 2021-09-05 | Morrow | Ohio | 39117 | 3335 | 47 |
1689450 | 1689450 | 2021-09-05 | Milam | Texas | 48331 | 3335 | 63 |
1686200 | 1686200 | 2021-09-04 | Milam | Texas | 48331 | 3335 | 63 |
1682949 | 1682949 | 2021-09-03 | Milam | Texas | 48331 | 3335 | 63 |
1672023 | 1672023 | 2021-08-31 | Washington | Missouri | 29221 | 3335 | 56 |
1669674 | 1669674 | 2021-08-30 | Meade | South Dakota | 46093 | 3335 | 32 |
1656676 | 1656676 | 2021-08-26 | Lawrence | South Dakota | 46081 | 3335 | 50 |
1626026 | 1626026 | 2021-08-17 | Montgomery | Kentucky | 21173 | 3335 | 32 |
1611750 | 1611750 | 2021-08-12 | Warren | Virginia | 51187 | 3335 | 64 |
1601388 | 1601388 | 2021-08-09 | Edgefield | South Carolina | 45037 | 3335 | 43 |
1583817 | 1583817 | 2021-08-04 | Taylor | Kentucky | 21217 | 3335 | 55 |
1584136 | 1584136 | 2021-08-04 | Copiah | Mississippi | 28029 | 3335 | 69 |
1538739 | 1538739 | 2021-07-21 | Barry | Missouri | 29009 | 3335 | 49 |
1535130 | 1535130 | 2021-07-20 | East Feliciana | Louisiana | 22037 | 3335 | 117 |
1535369 | 1535369 | 2021-07-20 | Nicollet | Minnesota | 27103 | 3335 | 45 |
1530910 | 1530910 | 2021-07-19 | Poinsett | Arkansas | 5111 | 3335 | 80 |
1396706 | 1396706 | 2021-06-07 | Jefferson | Pennsylvania | 42065 | 3335 | 99 |
1393459 | 1393459 | 2021-06-06 | Jefferson | Pennsylvania | 42065 | 3335 | 99 |
1390214 | 1390214 | 2021-06-05 | Jefferson | Pennsylvania | 42065 | 3335 | 99 |
1347690 | 1347690 | 2021-05-23 | Montgomery | North Carolina | 37123 | 3335 | 94 |
1344442 | 1344442 | 2021-05-22 | Montgomery | North Carolina | 37123 | 3335 | 94 |
1341194 | 1341194 | 2021-05-21 | Montgomery | North Carolina | 37123 | 3335 | 94 |
1337946 | 1337946 | 2021-05-20 | Montgomery | North Carolina | 37123 | 3335 | 94 |
1223113 | 1223113 | 2021-04-15 | Ripley | Indiana | 18137 | 3335 | 68 |
1223403 | 1223403 | 2021-04-15 | Knox | Kentucky | 21121 | 3335 | 34 |
1216907 | 1216907 | 2021-04-13 | Knox | Kentucky | 21121 | 3335 | 34 |
1196644 | 1196644 | 2021-04-07 | Montrose | Colorado | 8085 | 3335 | 57 |
1193396 | 1193396 | 2021-04-06 | Montrose | Colorado | 8085 | 3335 | 57 |
1186899 | 1186899 | 2021-04-04 | Montrose | Colorado | 8085 | 3335 | 57 |
1180746 | 1180746 | 2021-04-02 | Fulton | Illinois | 17057 | 3335 | 58 |
1168909 | 1168909 | 2021-03-29 | Belknap | New Hampshire | 33001 | 3335 | 95 |
1160936 | 1160936 | 2021-03-27 | Summit | Colorado | 8117 | 3335 | 7 |
1141473 | 1141473 | 2021-03-21 | Baker | Florida | 12003 | 3335 | 59 |
1138227 | 1138227 | 2021-03-20 | Baker | Florida | 12003 | 3335 | 59 |
1118195 | 1118195 | 2021-03-13 | Petersburg city | Virginia | 51730 | 3335 | 72 |
1108882 | 1108882 | 2021-03-11 | Humboldt | California | 6023 | 3335 | 34 |
1096304 | 1096304 | 2021-03-07 | Bureau | Illinois | 17011 | 3335 | 90 |
1096839 | 1096839 | 2021-03-07 | Evangeline | Louisiana | 22039 | 3335 | 79 |
1089994 | 1089994 | 2021-03-05 | Wabash | Indiana | 18169 | 3335 | 76 |
1058607 | 1058607 | 2021-02-23 | Columbia | New York | 36021 | 3335 | 94 |
1044504 | 1044504 | 2021-02-19 | Huntington | Indiana | 18069 | 3335 | 77 |
1044785 | 1044785 | 2021-02-19 | Calloway | Kentucky | 21035 | 3335 | 38 |
1032682 | 1032682 | 2021-02-15 | Tompkins | New York | 36109 | 3335 | 41 |
1026279 | 1026279 | 2021-02-13 | Scotland | North Carolina | 37165 | 3335 | 71 |
1000435 | 1000435 | 2021-02-05 | Logan | Ohio | 39091 | 3335 | 39 |
988977 | 988977 | 2021-02-02 | Unknown | Florida | 3335 | 0 | |
989978 | 989978 | 2021-02-02 | Polk | Minnesota | 27119 | 3335 | 60 |
987593 | 987593 | 2021-02-01 | Linn | Oregon | 41043 | 3335 | 50 |
964497 | 964497 | 2021-01-25 | Madison | New York | 36053 | 3335 | 77 |
953033 | 953033 | 2021-01-22 | Independence | Arkansas | 5063 | 3335 | 109 |
935954 | 935954 | 2021-01-16 | Cheatham | Tennessee | 47021 | 3335 | 29 |
930184 | 930184 | 2021-01-15 | Chilton | Alabama | 1021 | 3335 | 65 |
927645 | 927645 | 2021-01-14 | DeKalb | Indiana | 18033 | 3335 | 67 |
920327 | 920327 | 2021-01-11 | Putnam | West Virginia | 54079 | 3335 | 60 |
891885 | 891885 | 2021-01-03 | Macoupin | Illinois | 17117 | 3335 | 81 |
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);