ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 4422 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 9
- Tennessee 8
- Texas 8
- Louisiana 7
- Georgia 6
- Kentucky 6
- Missouri 6
- Indiana 5
- New York 4
- California 3
- Iowa 3
- Kansas 3
- Nebraska 3
- Ohio 3
- Pennsylvania 3
- Virginia 3
- Wisconsin 3
- Idaho 2
- Michigan 2
- Minnesota 2
- Puerto Rico 2
- West Virginia 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Delaware 1
- Massachusetts 1
- Mississippi 1
- Nevada 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324977 | 2324977 | 2022-03-20 | Winn | Louisiana | 22127 | 4422 | 62 |
2321723 | 2321723 | 2022-03-19 | Winn | Louisiana | 22127 | 4422 | 62 |
2318469 | 2318469 | 2022-03-18 | Winn | Louisiana | 22127 | 4422 | 62 |
2242522 | 2242522 | 2022-02-23 | Henry | Alabama | 1067 | 4422 | 69 |
2223472 | 2223472 | 2022-02-17 | Meriwether | Georgia | 13199 | 4422 | 133 |
2177017 | 2177017 | 2022-02-02 | Reeves | Texas | 48389 | 4422 | 65 |
2169135 | 2169135 | 2022-01-31 | Jasper | Mississippi | 28061 | 4422 | 66 |
2156241 | 2156241 | 2022-01-27 | New Madrid | Missouri | 29143 | 4422 | 71 |
2157371 | 2157371 | 2022-01-27 | Fayette | Texas | 48149 | 4422 | 96 |
2151808 | 2151808 | 2022-01-26 | Appling | Georgia | 13001 | 4422 | 112 |
2126165 | 2126165 | 2022-01-18 | Spencer | Indiana | 18147 | 4422 | 58 |
2109125 | 2109125 | 2022-01-12 | Uinta | Wyoming | 56041 | 4422 | 34 |
2096917 | 2096917 | 2022-01-09 | Washington | Indiana | 18175 | 4422 | 63 |
2093665 | 2093665 | 2022-01-08 | Washington | Indiana | 18175 | 4422 | 63 |
2090413 | 2090413 | 2022-01-07 | Washington | Indiana | 18175 | 4422 | 63 |
2054938 | 2054938 | 2021-12-27 | Marion | Kentucky | 21155 | 4422 | 63 |
2035610 | 2035610 | 2021-12-21 | Alpena | Michigan | 26007 | 4422 | 107 |
2032360 | 2032360 | 2021-12-20 | Alpena | Michigan | 26007 | 4422 | 107 |
2008934 | 2008934 | 2021-12-13 | Elmore | Idaho | 16039 | 4422 | 52 |
2006269 | 2006269 | 2021-12-12 | Richland | Louisiana | 22083 | 4422 | 80 |
2003018 | 2003018 | 2021-12-11 | Richland | Louisiana | 22083 | 4422 | 80 |
1999768 | 1999768 | 2021-12-10 | Richland | Louisiana | 22083 | 4422 | 80 |
1996588 | 1996588 | 2021-12-09 | Franklin | Massachusetts | 25011 | 4422 | 126 |
1990443 | 1990443 | 2021-12-07 | Saline | Missouri | 29195 | 4422 | 84 |
1969544 | 1969544 | 2021-12-01 | Calaveras | California | 6009 | 4422 | 88 |
1966847 | 1966847 | 2021-11-30 | Jennings | Indiana | 18079 | 4422 | 69 |
1945489 | 1945489 | 2021-11-23 | Van Wert | Ohio | 39161 | 4422 | 87 |
1912346 | 1912346 | 2021-11-13 | Barry | Missouri | 29009 | 4422 | 64 |
1892878 | 1892878 | 2021-11-07 | Dunklin | Missouri | 29069 | 4422 | 61 |
1889628 | 1889628 | 2021-11-06 | Dunklin | Missouri | 29069 | 4422 | 61 |
1841763 | 1841763 | 2021-10-22 | Vega Baja | Puerto Rico | 72145 | 4422 | |
1837196 | 1837196 | 2021-10-21 | Montgomery | Kentucky | 21173 | 4422 | 55 |
1814734 | 1814734 | 2021-10-14 | Lyon | Minnesota | 27083 | 4422 | 56 |
1808717 | 1808717 | 2021-10-12 | Allegany | New York | 36003 | 4422 | 94 |
1808988 | 1808988 | 2021-10-12 | Morrow | Ohio | 39117 | 4422 | 56 |
1801290 | 1801290 | 2021-10-10 | Ellis | Kansas | 20051 | 4422 | 76 |
1798041 | 1798041 | 2021-10-09 | Ellis | Kansas | 20051 | 4422 | 76 |
1794792 | 1794792 | 2021-10-08 | Ellis | Kansas | 20051 | 4422 | 76 |
1789691 | 1789691 | 2021-10-06 | Snyder | Pennsylvania | 42109 | 4422 | 94 |
1779317 | 1779317 | 2021-10-03 | Dakota | Nebraska | 31043 | 4422 | 82 |
1776067 | 1776067 | 2021-10-02 | Dakota | Nebraska | 31043 | 4422 | 82 |
1772817 | 1772817 | 2021-10-01 | Dakota | Nebraska | 31043 | 4422 | 82 |
1746971 | 1746971 | 2021-09-23 | Rio Arriba | New Mexico | 35039 | 4422 | 83 |
1735574 | 1735574 | 2021-09-20 | Yell | Arkansas | 5149 | 4422 | 76 |
1725510 | 1725510 | 2021-09-16 | Logan | West Virginia | 54045 | 4422 | 111 |
1719444 | 1719444 | 2021-09-15 | Summit | Colorado | 8117 | 4422 | 9 |
1653564 | 1653564 | 2021-08-25 | Bee | Texas | 48025 | 4422 | 82 |
1637399 | 1637399 | 2021-08-20 | Grimes | Texas | 48185 | 4422 | 74 |
1624661 | 1624661 | 2021-08-16 | Franklin | Virginia | 51067 | 4422 | 83 |
1607012 | 1607012 | 2021-08-11 | Marion | Missouri | 29127 | 4422 | 55 |
1601574 | 1601574 | 2021-08-09 | Weakley | Tennessee | 47183 | 4422 | 69 |
1517086 | 1517086 | 2021-07-14 | Lincoln | Tennessee | 47103 | 4422 | 67 |
1505435 | 1505435 | 2021-07-11 | Monroe | Illinois | 17133 | 4422 | 94 |
1505810 | 1505810 | 2021-07-11 | Graves | Kentucky | 21083 | 4422 | 96 |
1502189 | 1502189 | 2021-07-10 | Monroe | Illinois | 17133 | 4422 | 94 |
1502564 | 1502564 | 2021-07-10 | Graves | Kentucky | 21083 | 4422 | 96 |
1498943 | 1498943 | 2021-07-09 | Monroe | Illinois | 17133 | 4422 | 94 |
1499318 | 1499318 | 2021-07-09 | Graves | Kentucky | 21083 | 4422 | 96 |
1437246 | 1437246 | 2021-06-20 | Jefferson | Illinois | 17081 | 4422 | 123 |
1433999 | 1433999 | 2021-06-19 | Jefferson | Illinois | 17081 | 4422 | 123 |
1430753 | 1430753 | 2021-06-18 | Jefferson | Illinois | 17081 | 4422 | 123 |
1425483 | 1425483 | 2021-06-16 | Fulton | New York | 36035 | 4422 | 91 |
1422236 | 1422236 | 2021-06-15 | Fulton | New York | 36035 | 4422 | 91 |
1376843 | 1376843 | 2021-06-01 | Alexander | North Carolina | 37003 | 4422 | 84 |
1327596 | 1327596 | 2021-05-17 | Itasca | Minnesota | 27061 | 4422 | 56 |
1302531 | 1302531 | 2021-05-09 | Yamhill | Oregon | 41071 | 4422 | 75 |
1275350 | 1275350 | 2021-05-01 | Hopkins | Kentucky | 21107 | 4422 | 146 |
1234623 | 1234623 | 2021-04-18 | Cheatham | Tennessee | 47021 | 4422 | 54 |
1231375 | 1231375 | 2021-04-17 | Cheatham | Tennessee | 47021 | 4422 | 54 |
1228127 | 1228127 | 2021-04-16 | Cheatham | Tennessee | 47021 | 4422 | 54 |
1193051 | 1193051 | 2021-04-05 | Marinette | Wisconsin | 55075 | 4422 | 68 |
1189801 | 1189801 | 2021-04-04 | Marinette | Wisconsin | 55075 | 4422 | 68 |
1186554 | 1186554 | 2021-04-03 | Marinette | Wisconsin | 55075 | 4422 | 68 |
1174018 | 1174018 | 2021-03-31 | Baldwin | Georgia | 13009 | 4422 | 123 |
1161497 | 1161497 | 2021-03-27 | Muscatine | Iowa | 19139 | 4422 | 95 |
1152062 | 1152062 | 2021-03-24 | St. Mary | Louisiana | 22101 | 4422 | 127 |
1072133 | 1072133 | 2021-02-27 | Unknown | Puerto Rico | 4422 | 2032 | |
1030449 | 1030449 | 2021-02-14 | Chittenden | Vermont | 50007 | 4422 | 82 |
1019570 | 1019570 | 2021-02-11 | Elko | Nevada | 32007 | 4422 | 49 |
1011852 | 1011852 | 2021-02-09 | Ware | Georgia | 13299 | 4422 | 127 |
1004311 | 1004311 | 2021-02-06 | Howard | Texas | 48227 | 4422 | 91 |
998954 | 998954 | 2021-02-05 | Effingham | Illinois | 17049 | 4422 | 79 |
997635 | 997635 | 2021-02-04 | Franklin | Tennessee | 47051 | 4422 | 74 |
984212 | 984212 | 2021-01-31 | Mercer | Ohio | 39107 | 4422 | 92 |
947032 | 947032 | 2021-01-20 | Grundy | Illinois | 17063 | 4422 | 54 |
933876 | 933876 | 2021-01-16 | Habersham | Georgia | 13137 | 4422 | 108 |
924499 | 924499 | 2021-01-13 | Clinton | Iowa | 19045 | 4422 | 61 |
922318 | 922318 | 2021-01-12 | Oswego | New York | 36075 | 4422 | 57 |
890963 | 890963 | 2021-01-02 | Hampton city | Virginia | 51650 | 4422 | 48 |
890965 | 890965 | 2021-01-02 | Harrisonburg city | Virginia | 51660 | 4422 | 44 |
879136 | 879136 | 2020-12-30 | Webster | Iowa | 19187 | 4422 | 61 |
871039 | 871039 | 2020-12-27 | Bedford | Tennessee | 47003 | 4422 | 59 |
839187 | 839187 | 2020-12-17 | Monongalia | West Virginia | 54061 | 4422 | 11 |
821862 | 821862 | 2020-12-12 | Morton | North Dakota | 38059 | 4422 | 80 |
792887 | 792887 | 2020-12-03 | Beaver | Pennsylvania | 42007 | 4422 | 160 |
774956 | 774956 | 2020-11-28 | Bannock | Idaho | 16005 | 4422 | 29 |
715596 | 715596 | 2020-11-09 | Victoria | Texas | 48469 | 4422 | 98 |
712352 | 712352 | 2020-11-08 | Victoria | Texas | 48469 | 4422 | 98 |
709108 | 709108 | 2020-11-07 | Victoria | Texas | 48469 | 4422 | 98 |
696750 | 696750 | 2020-11-04 | San Luis Obispo | California | 6079 | 4422 | 33 |
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);