ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where "date" is on date 2020-05-28 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 25
county 25
- Allegany 1
- Anne Arundel 1
- Baltimore 1
- Baltimore city 1
- Calvert 1
- Caroline 1
- Carroll 1
- Cecil 1
- Charles 1
- Dorchester 1
- Frederick 1
- Garrett 1
- Harford 1
- Howard 1
- Kent 1
- Montgomery 1
- Prince George's 1
- Queen Anne's 1
- Somerset 1
- St. Mary's 1
- Talbot 1
- Unknown 1
- Washington 1
- Wicomico 1
- Worcester 1
state 1
- Maryland · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
185748 | 185748 | 2020-05-28 | Allegany | Maryland | 24001 | 178 | 15 |
185749 | 185749 | 2020-05-28 | Anne Arundel | Maryland | 24003 | 3565 | 163 |
185750 | 185750 | 2020-05-28 | Baltimore | Maryland | 24005 | 5693 | 323 |
185751 | 185751 | 2020-05-28 | Baltimore city | Maryland | 24510 | 5211 | 240 |
185752 | 185752 | 2020-05-28 | Calvert | Maryland | 24009 | 321 | 17 |
185753 | 185753 | 2020-05-28 | Caroline | Maryland | 24011 | 245 | 0 |
185754 | 185754 | 2020-05-28 | Carroll | Maryland | 24013 | 843 | 85 |
185755 | 185755 | 2020-05-28 | Cecil | Maryland | 24015 | 356 | 22 |
185756 | 185756 | 2020-05-28 | Charles | Maryland | 24017 | 1028 | 72 |
185757 | 185757 | 2020-05-28 | Dorchester | Maryland | 24019 | 136 | 3 |
185758 | 185758 | 2020-05-28 | Frederick | Maryland | 24021 | 1831 | 104 |
185759 | 185759 | 2020-05-28 | Garrett | Maryland | 24023 | 10 | 0 |
185760 | 185760 | 2020-05-28 | Harford | Maryland | 24025 | 830 | 49 |
185761 | 185761 | 2020-05-28 | Howard | Maryland | 24027 | 1819 | 56 |
185762 | 185762 | 2020-05-28 | Kent | Maryland | 24029 | 165 | 15 |
185763 | 185763 | 2020-05-28 | Montgomery | Maryland | 24031 | 10791 | 581 |
185764 | 185764 | 2020-05-28 | Prince George's | Maryland | 24033 | 15042 | 530 |
185765 | 185765 | 2020-05-28 | Queen Anne's | Maryland | 24035 | 152 | 12 |
185766 | 185766 | 2020-05-28 | Somerset | Maryland | 24039 | 73 | 2 |
185767 | 185767 | 2020-05-28 | St. Mary's | Maryland | 24037 | 417 | 19 |
185768 | 185768 | 2020-05-28 | Talbot | Maryland | 24041 | 87 | 1 |
185769 | 185769 | 2020-05-28 | Unknown | Maryland | 0 | 69 | |
185770 | 185770 | 2020-05-28 | Washington | Maryland | 24043 | 423 | 12 |
185771 | 185771 | 2020-05-28 | Wicomico | Maryland | 24045 | 919 | 27 |
185772 | 185772 | 2020-05-28 | Worcester | Maryland | 24047 | 199 | 11 |
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);