johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where "day" is on date 2021-05-31 and province_or_state = "Maryland" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1190308 | 1190308 | 2021-05-31 | US | Maryland | Allegany | 24001 | 7006 | 211 | 0 | 39.62357628 | -78.69280486 | 2021-06-01 04:23:09 | Allegany, Maryland, US | |
1190309 | 1190309 | 2021-05-31 | US | Maryland | Anne Arundel | 24003 | 43778 | 646 | 0 | 39.00670238 | -76.60329337 | 2021-06-01 04:23:09 | Anne Arundel, Maryland, US | |
1190310 | 1190310 | 2021-05-31 | US | Maryland | Baltimore | 24005 | 65627 | 1657 | 0 | 39.45784712 | -76.62911955 | 2021-06-01 04:23:09 | Baltimore, Maryland, US | |
1190311 | 1190311 | 2021-05-31 | US | Maryland | Baltimore City | 24510 | 52852 | 1223 | 0 | 39.30211911 | -76.61151012 | 2021-06-01 04:23:09 | Baltimore City, Maryland, US | |
1190312 | 1190312 | 2021-05-31 | US | Maryland | Calvert | 24009 | 4217 | 85 | 0 | 38.53961642 | -76.56820632 | 2021-06-01 04:23:09 | Calvert, Maryland, US | |
1190313 | 1190313 | 2021-05-31 | US | Maryland | Caroline | 24011 | 2341 | 29 | 0 | 38.87172293 | -75.82904158 | 2021-06-01 04:23:09 | Caroline, Maryland, US | |
1190314 | 1190314 | 2021-05-31 | US | Maryland | Carroll | 24013 | 9477 | 252 | 0 | 39.56453592 | -77.02373735 | 2021-06-01 04:23:09 | Carroll, Maryland, US | |
1190315 | 1190315 | 2021-05-31 | US | Maryland | Cecil | 24015 | 6299 | 150 | 0 | 39.56647682 | -75.94627411 | 2021-06-01 04:23:09 | Cecil, Maryland, US | |
1190316 | 1190316 | 2021-05-31 | US | Maryland | Charles | 24017 | 10861 | 210 | 0 | 38.51092331 | -76.98580666 | 2021-06-01 04:23:09 | Charles, Maryland, US | |
1190317 | 1190317 | 2021-05-31 | US | Maryland | Dorchester | 24019 | 2828 | 64 | 0 | 38.45413522 | -76.02752426 | 2021-06-01 04:23:09 | Dorchester, Maryland, US | |
1190318 | 1190318 | 2021-05-31 | US | Maryland | Frederick | 24021 | 19772 | 338 | 0 | 39.47296601 | -77.39999394 | 2021-06-01 04:23:09 | Frederick, Maryland, US | |
1190319 | 1190319 | 2021-05-31 | US | Maryland | Garrett | 24023 | 2033 | 65 | 0 | 39.52786077 | -79.27355126 | 2021-06-01 04:23:09 | Garrett, Maryland, US | |
1190320 | 1190320 | 2021-05-31 | US | Maryland | Harford | 24025 | 16563 | 292 | 0 | 39.55010644 | -76.30775940000002 | 2021-06-01 04:23:09 | Harford, Maryland, US | |
1190321 | 1190321 | 2021-05-31 | US | Maryland | Howard | 24027 | 19210 | 250 | 0 | 39.25305293 | -76.93126208 | 2021-06-01 04:23:09 | Howard, Maryland, US | |
1190322 | 1190322 | 2021-05-31 | US | Maryland | Kent | 24029 | 1348 | 51 | 0 | 39.24976208 | -76.04741541 | 2021-06-01 04:23:09 | Kent, Maryland, US | |
1190323 | 1190323 | 2021-05-31 | US | Maryland | Montgomery | 24031 | 70921 | 1604 | 0 | 39.13676329 | -77.20358245 | 2021-06-01 04:23:09 | Montgomery, Maryland, US | |
1190324 | 1190324 | 2021-05-31 | US | Maryland | Prince George's | 24033 | 85056 | 1573 | 0 | 38.83070039 | -76.8496441 | 2021-06-01 04:23:09 | Prince George's, Maryland, US | |
1190325 | 1190325 | 2021-05-31 | US | Maryland | Queen Anne's | 24035 | 2997 | 51 | 0 | 39.06198912 | -76.03530977 | 2021-06-01 04:23:09 | Queen Anne's, Maryland, US | |
1190326 | 1190326 | 2021-05-31 | US | Maryland | Somerset | 24039 | 2611 | 40 | 0 | 38.1163542 | -75.75118623 | 2021-06-01 04:23:09 | Somerset, Maryland, US | |
1190327 | 1190327 | 2021-05-31 | US | Maryland | St. Mary's | 24037 | 6023 | 130 | 0 | 38.30058422 | -76.60629279999998 | 2021-06-01 04:23:09 | St. Mary's, Maryland, US | |
1190328 | 1190328 | 2021-05-31 | US | Maryland | Talbot | 24041 | 2158 | 44 | 0 | 38.76618159 | -76.10882561 | 2021-06-01 04:23:09 | Talbot, Maryland, US | |
1190329 | 1190329 | 2021-05-31 | US | Maryland | Unassigned | 90024 | 0 | 44 | 0 | 39.62357628 | 0.0 | 2021-06-01 04:23:09 | Unassigned, Maryland, US | |
1190330 | 1190330 | 2021-05-31 | US | Maryland | Washington | 24043 | 14586 | 328 | 0 | 39.60835778 | -77.82002295 | 2021-06-01 04:23:09 | Washington, Maryland, US | |
1190331 | 1190331 | 2021-05-31 | US | Maryland | Wicomico | 24045 | 7684 | 171 | 0 | 38.37301947 | -75.62705831 | 2021-06-01 04:23:09 | Wicomico, Maryland, US | |
1190332 | 1190332 | 2021-05-31 | US | Maryland | Worcester | 24047 | 3646 | 106 | 0 | 38.21274277 | -75.33200012 | 2021-06-01 04:23:09 | Worcester, Maryland, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);