ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where date = "2020-03-20" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
fips 20
county 20
- Baldwin 1
- Calhoun 1
- Chambers 1
- Cullman 1
- Elmore 1
- Jackson 1
- Jefferson 1
- Lamar 1
- Lauderdale 1
- Lee 1
- Limestone 1
- Madison 1
- Mobile 1
- Montgomery 1
- Shelby 1
- St. Clair 1
- Talladega 1
- Tuscaloosa 1
- Walker 1
- Washington 1
state 1
- Alabama · 20 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5167 | 5167 | 2020-03-20 | Baldwin | Alabama | 1003 | 2 | 0 |
5168 | 5168 | 2020-03-20 | Calhoun | Alabama | 1015 | 1 | 0 |
5169 | 5169 | 2020-03-20 | Chambers | Alabama | 1017 | 1 | 0 |
5170 | 5170 | 2020-03-20 | Cullman | Alabama | 1043 | 1 | 0 |
5171 | 5171 | 2020-03-20 | Elmore | Alabama | 1051 | 6 | 0 |
5172 | 5172 | 2020-03-20 | Jackson | Alabama | 1071 | 1 | 0 |
5173 | 5173 | 2020-03-20 | Jefferson | Alabama | 1073 | 50 | 0 |
5174 | 5174 | 2020-03-20 | Lamar | Alabama | 1075 | 1 | 0 |
5175 | 5175 | 2020-03-20 | Lauderdale | Alabama | 1077 | 1 | 0 |
5176 | 5176 | 2020-03-20 | Lee | Alabama | 1081 | 11 | 0 |
5177 | 5177 | 2020-03-20 | Limestone | Alabama | 1083 | 1 | 0 |
5178 | 5178 | 2020-03-20 | Madison | Alabama | 1089 | 7 | 0 |
5179 | 5179 | 2020-03-20 | Mobile | Alabama | 1097 | 2 | 0 |
5180 | 5180 | 2020-03-20 | Montgomery | Alabama | 1101 | 3 | 0 |
5181 | 5181 | 2020-03-20 | Shelby | Alabama | 1117 | 10 | 0 |
5182 | 5182 | 2020-03-20 | St. Clair | Alabama | 1115 | 1 | 0 |
5183 | 5183 | 2020-03-20 | Talladega | Alabama | 1121 | 1 | 0 |
5184 | 5184 | 2020-03-20 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
5185 | 5185 | 2020-03-20 | Walker | Alabama | 1127 | 1 | 0 |
5186 | 5186 | 2020-03-20 | Washington | Alabama | 1129 | 1 | 0 |
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);