ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 5531 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Georgia 7
- Virginia 6
- Texas 5
- Colorado 4
- Indiana 4
- Missouri 4
- Puerto Rico 4
- Tennessee 4
- Florida 3
- Maryland 3
- New York 3
- Ohio 3
- Alabama 2
- Illinois 2
- Iowa 2
- Louisiana 2
- Minnesota 2
- Pennsylvania 2
- Utah 2
- West Virginia 2
- Arizona 1
- California 1
- Maine 1
- Michigan 1
- Mississippi 1
- Nebraska 1
- New Jersey 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500775 | 2500775 | 2022-05-13 | Sagadahoc | Maine | 23023 | 5531 | 32 |
2466095 | 2466095 | 2022-05-02 | Camuy | Puerto Rico | 72027 | 5531 | |
2431055 | 2431055 | 2022-04-21 | Lincoln | West Virginia | 54043 | 5531 | 81 |
2394950 | 2394950 | 2022-04-10 | San Jacinto | Texas | 48407 | 5531 | 100 |
2291034 | 2291034 | 2022-03-09 | Page | Virginia | 51139 | 5531 | 118 |
2261791 | 2261791 | 2022-02-28 | Staunton city | Virginia | 51790 | 5531 | 104 |
2242992 | 2242992 | 2022-02-23 | Pierce | Georgia | 13229 | 5531 | 121 |
2240453 | 2240453 | 2022-02-22 | Garrett | Maryland | 24023 | 5531 | 113 |
2209416 | 2209416 | 2022-02-12 | Dimmit | Texas | 48127 | 5531 | 50 |
2133566 | 2133566 | 2022-01-20 | Adams | Nebraska | 31001 | 5531 | 56 |
2125195 | 2125195 | 2022-01-17 | Winchester city | Virginia | 51840 | 5531 | 59 |
2119178 | 2119178 | 2022-01-16 | Pitkin | Colorado | 8097 | 5531 | 6 |
2115926 | 2115926 | 2022-01-15 | Pitkin | Colorado | 8097 | 5531 | 6 |
2112675 | 2112675 | 2022-01-14 | Pitkin | Colorado | 8097 | 5531 | 6 |
2110545 | 2110545 | 2022-01-13 | Adams | Mississippi | 28001 | 5531 | 125 |
2081079 | 2081079 | 2022-01-04 | Dorchester | Maryland | 24019 | 5531 | 92 |
2051140 | 2051140 | 2021-12-26 | Toombs | Georgia | 13279 | 5531 | 177 |
2047890 | 2047890 | 2021-12-25 | Toombs | Georgia | 13279 | 5531 | 177 |
2044640 | 2044640 | 2021-12-24 | Toombs | Georgia | 13279 | 5531 | 177 |
2043189 | 2043189 | 2021-12-23 | Warren | Pennsylvania | 42123 | 5531 | 177 |
2015163 | 2015163 | 2021-12-15 | Summit | Colorado | 8117 | 5531 | 12 |
1996729 | 1996729 | 2021-12-09 | Mille Lacs | Minnesota | 27095 | 5531 | 84 |
1941951 | 1941951 | 2021-11-22 | Columbia | New York | 36021 | 5531 | 113 |
1938428 | 1938428 | 2021-11-21 | Pulaski | Missouri | 29169 | 5531 | 96 |
1859043 | 1859043 | 2021-10-28 | Amador | California | 6005 | 5531 | 64 |
1800376 | 1800376 | 2021-10-10 | Chambers | Alabama | 1017 | 5531 | 139 |
1791038 | 1791038 | 2021-10-07 | Chattahoochee | Georgia | 13053 | 5531 | 17 |
1783442 | 1783442 | 2021-10-04 | Henderson | Tennessee | 47077 | 5531 | 95 |
1772668 | 1772668 | 2021-10-01 | Howell | Missouri | 29091 | 5531 | 68 |
1737503 | 1737503 | 2021-09-20 | Mercer | Ohio | 39107 | 5531 | 90 |
1716611 | 1716611 | 2021-09-14 | DeKalb | Indiana | 18033 | 5531 | 94 |
1713825 | 1713825 | 2021-09-13 | Vernon | Louisiana | 22115 | 5531 | 140 |
1654813 | 1654813 | 2021-08-26 | Henry | Illinois | 17073 | 5531 | 100 |
1645942 | 1645942 | 2021-08-23 | Camden | Missouri | 29029 | 5531 | 111 |
1542063 | 1542063 | 2021-07-22 | Pettis | Missouri | 29159 | 5531 | 79 |
1533469 | 1533469 | 2021-07-19 | Harrison | Texas | 48203 | 5531 | 112 |
1530222 | 1530222 | 2021-07-18 | Harrison | Texas | 48203 | 5531 | 112 |
1526975 | 1526975 | 2021-07-17 | Harrison | Texas | 48203 | 5531 | 112 |
1414695 | 1414695 | 2021-06-13 | Cerro Gordo | Iowa | 19033 | 5531 | 93 |
1406245 | 1406245 | 2021-06-10 | Huron | Ohio | 39077 | 5531 | 121 |
1374570 | 1374570 | 2021-05-31 | Box Elder | Utah | 49003 | 5531 | 50 |
1331888 | 1331888 | 2021-05-18 | Unknown | Puerto Rico | 5531 | 2445 | |
1302369 | 1302369 | 2021-05-09 | Jefferson | Ohio | 39081 | 5531 | 151 |
1295033 | 1295033 | 2021-05-07 | Chippewa | Michigan | 26033 | 5531 | 49 |
1292429 | 1292429 | 2021-05-06 | Wayne | New York | 36117 | 5531 | 67 |
1250188 | 1250188 | 2021-04-23 | Jefferson | New York | 36045 | 5531 | 65 |
1235432 | 1235432 | 2021-04-19 | Graham | Arizona | 4009 | 5531 | 77 |
1190363 | 1190363 | 2021-04-05 | Polk | Georgia | 13233 | 5531 | 88 |
1177606 | 1177606 | 2021-04-01 | Henry | Indiana | 18065 | 5531 | 101 |
1170717 | 1170717 | 2021-03-30 | Gadsden | Florida | 12039 | 5531 | 90 |
1164221 | 1164221 | 2021-03-28 | Gadsden | Florida | 12039 | 5531 | 89 |
1102911 | 1102911 | 2021-03-09 | Dearborn | Indiana | 18029 | 5531 | 73 |
1070507 | 1070507 | 2021-02-27 | Shelby | Indiana | 18145 | 5531 | 100 |
1067003 | 1067003 | 2021-02-26 | Spalding | Georgia | 13255 | 5531 | 157 |
1052835 | 1052835 | 2021-02-21 | Lawrence | Tennessee | 47099 | 5531 | 80 |
1049588 | 1049588 | 2021-02-20 | Lawrence | Tennessee | 47099 | 5531 | 80 |
1036372 | 1036372 | 2021-02-16 | Caguas | Puerto Rico | 72025 | 5531 | |
1020737 | 1020737 | 2021-02-11 | Bedford | Virginia | 51019 | 5531 | 42 |
994136 | 994136 | 2021-02-03 | Lawrence | Pennsylvania | 42073 | 5531 | 172 |
972159 | 972159 | 2021-01-27 | Suffolk city | Virginia | 51800 | 5531 | 109 |
965607 | 965607 | 2021-01-25 | Hanover | Virginia | 51085 | 5531 | 95 |
942806 | 942806 | 2021-01-18 | Tooele | Utah | 49045 | 5531 | 17 |
931399 | 931399 | 2021-01-15 | Wicomico | Maryland | 24045 | 5531 | 100 |
842590 | 842590 | 2020-12-19 | Lauderdale | Alabama | 1077 | 5531 | 64 |
807196 | 807196 | 2020-12-08 | Hernando | Florida | 12053 | 5531 | 229 |
780173 | 780173 | 2020-11-29 | Blount | Tennessee | 47009 | 5531 | 61 |
774268 | 774268 | 2020-11-27 | Kanawha | West Virginia | 54039 | 5531 | 140 |
721566 | 721566 | 2020-11-11 | Bayamon | Puerto Rico | 72021 | 5531 | |
629240 | 629240 | 2020-10-14 | Johnson | Iowa | 19103 | 5531 | 30 |
561020 | 561020 | 2020-09-23 | Winnebago | Illinois | 17201 | 5531 | 152 |
542220 | 542220 | 2020-09-17 | Anoka | Minnesota | 27003 | 5531 | 131 |
358798 | 358798 | 2020-07-22 | Burlington | New Jersey | 34005 | 5531 | 467 |
294497 | 294497 | 2020-07-02 | East Baton Rouge | Louisiana | 22033 | 5531 | 273 |
163249 | 163249 | 2020-05-20 | Milwaukee | Wisconsin | 55079 | 5531 | 265 |
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);