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 2022-01-10 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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 |
---|---|---|---|---|---|---|---|
2100580 | 2100580 | 2022-01-10 | Allegany | Maryland | 24001 | 13268 | 298 |
2100581 | 2100581 | 2022-01-10 | Anne Arundel | Maryland | 24003 | 75441 | 862 |
2100582 | 2100582 | 2022-01-10 | Baltimore | Maryland | 24005 | 113131 | 2043 |
2100583 | 2100583 | 2022-01-10 | Baltimore city | Maryland | 24510 | 94744 | 1473 |
2100584 | 2100584 | 2022-01-10 | Calvert | Maryland | 24009 | 8758 | 109 |
2100585 | 2100585 | 2022-01-10 | Caroline | Maryland | 24011 | 4800 | 58 |
2100586 | 2100586 | 2022-01-10 | Carroll | Maryland | 24013 | 17553 | 332 |
2100587 | 2100587 | 2022-01-10 | Cecil | Maryland | 24015 | 12225 | 215 |
2100588 | 2100588 | 2022-01-10 | Charles | Maryland | 24017 | 22627 | 279 |
2100589 | 2100589 | 2022-01-10 | Dorchester | Maryland | 24019 | 6005 | 93 |
2100590 | 2100590 | 2022-01-10 | Frederick | Maryland | 24021 | 36992 | 428 |
2100591 | 2100591 | 2022-01-10 | Garrett | Maryland | 24023 | 4625 | 101 |
2100592 | 2100592 | 2022-01-10 | Harford | Maryland | 24025 | 31724 | 441 |
2100593 | 2100593 | 2022-01-10 | Howard | Maryland | 24027 | 35379 | 305 |
2100594 | 2100594 | 2022-01-10 | Kent | Maryland | 24029 | 2412 | 60 |
2100595 | 2100595 | 2022-01-10 | Montgomery | Maryland | 24031 | 133716 | 1789 |
2100596 | 2100596 | 2022-01-10 | Prince George's | Maryland | 24033 | 146908 | 1819 |
2100597 | 2100597 | 2022-01-10 | Queen Anne's | Maryland | 24035 | 5790 | 86 |
2100598 | 2100598 | 2022-01-10 | Somerset | Maryland | 24039 | 4201 | 60 |
2100599 | 2100599 | 2022-01-10 | St. Mary's | Maryland | 24037 | 14572 | 184 |
2100600 | 2100600 | 2022-01-10 | Talbot | Maryland | 24041 | 4340 | 68 |
2100601 | 2100601 | 2022-01-10 | Unknown | Maryland | 835 | 282 | |
2100602 | 2100602 | 2022-01-10 | Washington | Maryland | 24043 | 28793 | 486 |
2100603 | 2100603 | 2022-01-10 | Wicomico | Maryland | 24045 | 15216 | 255 |
2100604 | 2100604 | 2022-01-10 | Worcester | Maryland | 24047 | 6810 | 132 |
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);