ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 7540 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 7
- Texas 6
- Wisconsin 6
- South Carolina 5
- Ohio 4
- Pennsylvania 3
- Virginia 3
- Alabama 2
- Nebraska 2
- Vermont 2
- Georgia 1
- Maine 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- New York 1
- North Carolina 1
- Oklahoma 1
- South Dakota 1
- Tennessee 1
- Utah 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451913 | 2451913 | 2022-04-28 | Hancock | Maine | 23009 | 7540 | 85 |
2225719 | 2225719 | 2022-02-17 | Hockley | Texas | 48219 | 7540 | 154 |
2216415 | 2216415 | 2022-02-14 | Juneau | Wisconsin | 55057 | 7540 | 61 |
2147209 | 2147209 | 2022-01-24 | Greene | Pennsylvania | 42059 | 7540 | 91 |
2128649 | 2128649 | 2022-01-19 | Chambers | Alabama | 1017 | 7540 | 147 |
2126616 | 2126616 | 2022-01-18 | Worcester | Maryland | 24047 | 7540 | 139 |
2108312 | 2108312 | 2022-01-12 | Dillon | South Carolina | 45033 | 7540 | 123 |
2082772 | 2082772 | 2022-01-04 | Wasatch | Utah | 49051 | 7540 | 31 |
2036832 | 2036832 | 2021-12-21 | Brown | South Dakota | 46013 | 7540 | 107 |
1988593 | 1988593 | 2021-12-06 | James City | Virginia | 51095 | 7540 | 98 |
1965282 | 1965282 | 2021-11-29 | Chesterfield | South Carolina | 45025 | 7540 | 147 |
1932670 | 1932670 | 2021-11-19 | Venango | Pennsylvania | 42121 | 7540 | 159 |
1922085 | 1922085 | 2021-11-16 | Washington | Mississippi | 28151 | 7540 | 168 |
1878827 | 1878827 | 2021-11-03 | Liberty | Georgia | 13179 | 7540 | 116 |
1874302 | 1874302 | 2021-11-01 | Newberry | South Carolina | 45071 | 7540 | 146 |
1576164 | 1576164 | 2021-08-01 | Portage | Wisconsin | 55097 | 7540 | 75 |
1572916 | 1572916 | 2021-07-31 | Portage | Wisconsin | 55097 | 7540 | 75 |
1569668 | 1569668 | 2021-07-30 | Portage | Wisconsin | 55097 | 7540 | 75 |
1472643 | 1472643 | 2021-07-01 | Flagler | Florida | 12035 | 7540 | 114 |
1475213 | 1475213 | 2021-07-01 | Chittenden | Vermont | 50007 | 7540 | 105 |
1469397 | 1469397 | 2021-06-30 | Flagler | Florida | 12035 | 7540 | 114 |
1471967 | 1471967 | 2021-06-30 | Chittenden | Vermont | 50007 | 7540 | 104 |
1466152 | 1466152 | 2021-06-29 | Flagler | Florida | 12035 | 7540 | 114 |
1462907 | 1462907 | 2021-06-28 | Flagler | Florida | 12035 | 7540 | 114 |
1459662 | 1459662 | 2021-06-27 | Flagler | Florida | 12035 | 7540 | 114 |
1456417 | 1456417 | 2021-06-26 | Flagler | Florida | 12035 | 7540 | 114 |
1453172 | 1453172 | 2021-06-25 | Flagler | Florida | 12035 | 7540 | 114 |
1445540 | 1445540 | 2021-06-22 | Laurens | South Carolina | 45059 | 7540 | 173 |
1442133 | 1442133 | 2021-06-21 | Crawford | Pennsylvania | 42039 | 7540 | 154 |
1442295 | 1442295 | 2021-06-21 | Laurens | South Carolina | 45059 | 7540 | 173 |
1224423 | 1224423 | 2021-04-15 | Erie | Ohio | 39043 | 7540 | 153 |
1155847 | 1155847 | 2021-03-25 | Hall | Nebraska | 31079 | 7540 | 112 |
1152600 | 1152600 | 2021-03-24 | Hall | Nebraska | 31079 | 7540 | 112 |
1124701 | 1124701 | 2021-03-15 | Roanoke | Virginia | 51161 | 7540 | 131 |
1092009 | 1092009 | 2021-03-05 | Orange | Texas | 48361 | 7540 | 116 |
1088763 | 1088763 | 2021-03-04 | Orange | Texas | 48361 | 7540 | 116 |
1039497 | 1039497 | 2021-02-17 | Wagoner | Oklahoma | 40145 | 7540 | 77 |
1000887 | 1000887 | 2021-02-05 | Hamblen | Tennessee | 47063 | 7540 | 149 |
984223 | 984223 | 2021-01-31 | Pickaway | Ohio | 39129 | 7540 | 50 |
971226 | 971226 | 2021-01-27 | Marion | Ohio | 39101 | 7540 | 113 |
926752 | 926752 | 2021-01-13 | Grant | Washington | 53025 | 7540 | 90 |
920388 | 920388 | 2021-01-11 | Ozaukee | Wisconsin | 55089 | 7540 | 62 |
907390 | 907390 | 2021-01-07 | Jefferson | Wisconsin | 55055 | 7540 | 64 |
863870 | 863870 | 2020-12-25 | Broome | New York | 36007 | 7540 | 195 |
826024 | 826024 | 2020-12-13 | Chesapeake city | Virginia | 51550 | 7540 | 88 |
657166 | 657166 | 2020-10-22 | Potter | Texas | 48375 | 7540 | 98 |
614117 | 614117 | 2020-10-09 | Forsyth | North Carolina | 37067 | 7540 | 104 |
588987 | 588987 | 2020-10-01 | Jefferson | Texas | 48245 | 7540 | 134 |
555957 | 555957 | 2020-09-21 | Montgomery | Ohio | 39113 | 7540 | 152 |
411293 | 411293 | 2020-08-07 | Webb | Texas | 48479 | 7540 | 155 |
334675 | 334675 | 2020-07-15 | Jefferson | Alabama | 1073 | 7540 | 178 |
182838 | 182838 | 2020-05-27 | Hennepin | Minnesota | 27053 | 7540 | 565 |
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);