ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 4138 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 10
- Alabama 9
- Iowa 9
- Mississippi 9
- Nebraska 7
- Tennessee 7
- Texas 7
- Georgia 6
- Illinois 5
- Minnesota 5
- Puerto Rico 5
- West Virginia 4
- Arkansas 3
- Kentucky 3
- Louisiana 3
- New York 3
- North Carolina 3
- Kansas 2
- Ohio 2
- Pennsylvania 2
- South Carolina 2
- Utah 2
- Virginia 2
- Wisconsin 2
- Arizona 1
- Colorado 1
- Indiana 1
- Michigan 1
- New Jersey 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501102 | 2501102 | 2022-05-13 | Cooper | Missouri | 29053 | 4138 | 77 |
2443294 | 2443294 | 2022-04-25 | Aguas Buenas | Puerto Rico | 72007 | 4138 | |
2338329 | 2338329 | 2022-03-24 | Cooper | Missouri | 29053 | 4138 | 74 |
2335075 | 2335075 | 2022-03-23 | Cooper | Missouri | 29053 | 4138 | 74 |
2315555 | 2315555 | 2022-03-17 | Cooper | Missouri | 29053 | 4138 | 74 |
2312302 | 2312302 | 2022-03-16 | Cooper | Missouri | 29053 | 4138 | 74 |
2309049 | 2309049 | 2022-03-15 | Cooper | Missouri | 29053 | 4138 | 74 |
2240294 | 2240294 | 2022-02-22 | Jackson | Kentucky | 21109 | 4138 | 71 |
2235505 | 2235505 | 2022-02-20 | Lavaca | Texas | 48285 | 4138 | 111 |
2232254 | 2232254 | 2022-02-19 | Lavaca | Texas | 48285 | 4138 | 111 |
2168364 | 2168364 | 2022-01-31 | Piatt | Illinois | 17147 | 4138 | 26 |
2166791 | 2166791 | 2022-01-30 | Coamo | Puerto Rico | 72043 | 4138 | |
2164284 | 2164284 | 2022-01-29 | Barbour | West Virginia | 54001 | 4138 | 63 |
2154184 | 2154184 | 2022-01-26 | Lamb | Texas | 48279 | 4138 | 102 |
2099851 | 2099851 | 2022-01-10 | Lamar | Georgia | 13171 | 4138 | 102 |
2095252 | 2095252 | 2022-01-08 | Manati | Puerto Rico | 72091 | 4138 | |
2066609 | 2066609 | 2021-12-30 | Louisa | Virginia | 51109 | 4138 | 54 |
2055933 | 2055933 | 2021-12-27 | Carroll | Ohio | 39019 | 4138 | 90 |
2016268 | 2016268 | 2021-12-15 | Waseca | Minnesota | 27161 | 4138 | 34 |
2010886 | 2010886 | 2021-12-13 | Yankton | South Dakota | 46135 | 4138 | 44 |
1992279 | 1992279 | 2021-12-08 | Sevier | Arkansas | 5133 | 4138 | 61 |
1989621 | 1989621 | 2021-12-07 | Posey | Indiana | 18129 | 4138 | 44 |
1985059 | 1985059 | 2021-12-05 | Frio | Texas | 48163 | 4138 | 77 |
1943228 | 1943228 | 2021-11-22 | Nicholas | West Virginia | 54067 | 4138 | 58 |
1914595 | 1914595 | 2021-11-14 | Peach | Georgia | 13225 | 4138 | 108 |
1911345 | 1911345 | 2021-11-13 | Peach | Georgia | 13225 | 4138 | 108 |
1908096 | 1908096 | 2021-11-12 | Peach | Georgia | 13225 | 4138 | 108 |
1830102 | 1830102 | 2021-10-19 | Monroe | Georgia | 13207 | 4138 | 142 |
1829543 | 1829543 | 2021-10-18 | Juneau | Wisconsin | 55057 | 4138 | 34 |
1781968 | 1781968 | 2021-10-04 | Ohio | Kentucky | 21183 | 4138 | 74 |
1779086 | 1779086 | 2021-10-03 | Marion | Mississippi | 28091 | 4138 | 104 |
1775836 | 1775836 | 2021-10-02 | Marion | Mississippi | 28091 | 4138 | 104 |
1772586 | 1772586 | 2021-10-01 | Marion | Mississippi | 28091 | 4138 | 104 |
1764505 | 1764505 | 2021-09-28 | Mineral | West Virginia | 54057 | 4138 | 104 |
1759631 | 1759631 | 2021-09-27 | Barry | Missouri | 29009 | 4138 | 58 |
1746158 | 1746158 | 2021-09-23 | Carter | Kentucky | 21043 | 4138 | 50 |
1702818 | 1702818 | 2021-09-09 | Clark | Wisconsin | 55019 | 4138 | 67 |
1694631 | 1694631 | 2021-09-07 | Prentiss | Mississippi | 28117 | 4138 | 71 |
1691295 | 1691295 | 2021-09-06 | Polk | Minnesota | 27119 | 4138 | 75 |
1688045 | 1688045 | 2021-09-05 | Polk | Minnesota | 27119 | 4138 | 75 |
1684795 | 1684795 | 2021-09-04 | Polk | Minnesota | 27119 | 4138 | 75 |
1681544 | 1681544 | 2021-09-03 | Polk | Minnesota | 27119 | 4138 | 75 |
1672752 | 1672752 | 2021-08-31 | Arecibo | Puerto Rico | 72013 | 4138 | |
1653357 | 1653357 | 2021-08-25 | Clarendon | South Carolina | 45027 | 4138 | 116 |
1641360 | 1641360 | 2021-08-22 | St. Francis | Arkansas | 5123 | 4138 | 50 |
1643719 | 1643719 | 2021-08-22 | Carroll | Tennessee | 47017 | 4138 | 85 |
1640469 | 1640469 | 2021-08-21 | Carroll | Tennessee | 47017 | 4138 | 85 |
1636811 | 1636811 | 2021-08-20 | Preble | Ohio | 39135 | 4138 | 108 |
1637219 | 1637219 | 2021-08-20 | Carroll | Tennessee | 47017 | 4138 | 85 |
1580087 | 1580087 | 2021-08-03 | Fulton | Illinois | 17057 | 4138 | 67 |
1537266 | 1537266 | 2021-07-21 | Escambia | Alabama | 1053 | 4138 | 82 |
1491962 | 1491962 | 2021-07-07 | Union | Arkansas | 5139 | 4138 | 116 |
1493784 | 1493784 | 2021-07-07 | Yadkin | North Carolina | 37197 | 4138 | 55 |
1474028 | 1474028 | 2021-07-01 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1469336 | 1469336 | 2021-06-30 | La Plata | Colorado | 8067 | 4138 | 41 |
1470782 | 1470782 | 2021-06-30 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1466977 | 1466977 | 2021-06-29 | St. Bernard | Louisiana | 22087 | 4138 | 54 |
1467537 | 1467537 | 2021-06-29 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1464292 | 1464292 | 2021-06-28 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1461047 | 1461047 | 2021-06-27 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1457802 | 1457802 | 2021-06-26 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1454557 | 1454557 | 2021-06-25 | Lincoln | Nebraska | 31111 | 4138 | 81 |
1436667 | 1436667 | 2021-06-20 | Tallapoosa | Alabama | 1123 | 4138 | 155 |
1433420 | 1433420 | 2021-06-19 | Tallapoosa | Alabama | 1123 | 4138 | 155 |
1430174 | 1430174 | 2021-06-18 | Tallapoosa | Alabama | 1123 | 4138 | 155 |
1353678 | 1353678 | 2021-05-25 | Monroe | Mississippi | 28095 | 4138 | 135 |
1350432 | 1350432 | 2021-05-24 | Monroe | Mississippi | 28095 | 4138 | 135 |
1333413 | 1333413 | 2021-05-19 | Randolph | Illinois | 17157 | 4138 | 90 |
1326260 | 1326260 | 2021-05-17 | Covington | Alabama | 1039 | 4138 | 118 |
1323014 | 1323014 | 2021-05-16 | Covington | Alabama | 1039 | 4138 | 118 |
1319768 | 1319768 | 2021-05-15 | Covington | Alabama | 1039 | 4138 | 118 |
1316520 | 1316520 | 2021-05-14 | Covington | Alabama | 1039 | 4138 | 118 |
1297673 | 1297673 | 2021-05-08 | Lee | Illinois | 17103 | 4138 | 91 |
1291374 | 1291374 | 2021-05-06 | Jasper | Iowa | 19099 | 4138 | 71 |
1279970 | 1279970 | 2021-05-02 | Chester | South Carolina | 45023 | 4138 | 75 |
1257398 | 1257398 | 2021-04-25 | Marshall | Tennessee | 47117 | 4138 | 58 |
1254151 | 1254151 | 2021-04-24 | Marshall | Tennessee | 47117 | 4138 | 58 |
1250904 | 1250904 | 2021-04-23 | Marshall | Tennessee | 47117 | 4138 | 58 |
1185235 | 1185235 | 2021-04-03 | Madison | New York | 36053 | 4138 | 85 |
1171885 | 1171885 | 2021-03-30 | Butler | Missouri | 29023 | 4138 | 39 |
1168637 | 1168637 | 2021-03-29 | Butler | Missouri | 29023 | 4138 | 39 |
1132883 | 1132883 | 2021-03-18 | Pontotoc | Mississippi | 28115 | 4138 | 72 |
1134376 | 1134376 | 2021-03-18 | Fauquier | Virginia | 51061 | 4138 | 61 |
1121727 | 1121727 | 2021-03-15 | Russell | Alabama | 1113 | 4138 | 34 |
1106244 | 1106244 | 2021-03-10 | Buena Vista | Iowa | 19021 | 4138 | 37 |
1103373 | 1103373 | 2021-03-09 | Washington | Louisiana | 22117 | 4138 | 122 |
1100127 | 1100127 | 2021-03-08 | Washington | Louisiana | 22117 | 4138 | 122 |
1087450 | 1087450 | 2021-03-04 | Warren | Mississippi | 28149 | 4138 | 115 |
1067956 | 1067956 | 2021-02-26 | Pearl River | Mississippi | 28109 | 4138 | 128 |
1060862 | 1060862 | 2021-02-24 | Muscatine | Iowa | 19139 | 4138 | 89 |
1057616 | 1057616 | 2021-02-23 | Muscatine | Iowa | 19139 | 4138 | 89 |
1054370 | 1054370 | 2021-02-22 | Muscatine | Iowa | 19139 | 4138 | 88 |
1051123 | 1051123 | 2021-02-21 | Muscatine | Iowa | 19139 | 4138 | 88 |
1047876 | 1047876 | 2021-02-20 | Muscatine | Iowa | 19139 | 4138 | 88 |
1044631 | 1044631 | 2021-02-19 | Muscatine | Iowa | 19139 | 4138 | 88 |
1046889 | 1046889 | 2021-02-19 | Mercer | West Virginia | 54055 | 4138 | 103 |
1019722 | 1019722 | 2021-02-11 | Carteret | North Carolina | 37031 | 4138 | 41 |
1001232 | 1001232 | 2021-02-05 | Wasatch | Utah | 49051 | 4138 | 17 |
896649 | 896649 | 2021-01-04 | Grady | Oklahoma | 40051 | 4138 | 37 |
887015 | 887015 | 2021-01-01 | Clearfield | Pennsylvania | 42033 | 4138 | 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);