johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 46370 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3278456 | 3278456 | 2022-10-23 | US | Maryland | Harford | 24025 | 46370 | 632 | 0 | 39.55010644 | -76.3077594 | 2022-10-24 04:22:29 | Harford, Maryland, US | |
2269494 | 2269494 | 2022-10-22 | US | Maryland | Harford | 24025 | 46370 | 632 | 0 | 39.55010644 | -76.3077594 | 2022-10-23 04:22:46 | Harford, Maryland, US | |
1593794 | 1593794 | 2022-10-21 | US | Maryland | Harford | 24025 | 46370 | 632 | 0 | 39.55010644 | -76.3077594 | 2022-10-22 04:22:53 | Harford, Maryland, US | |
2275490 | 2275490 | 2022-10-20 | US | Wisconsin | Marathon | 55073 | 46370 | 523 | 0 | 44.89792533 | -89.75863384 | 2022-10-21 04:22:23 | Marathon, Wisconsin, US | |
3250346 | 3250346 | 2022-10-11 | Russia | Chechen Republic | 46370 | 1076 | 0 | 43.3976147 | 45.6985005 | 2022-10-12 04:22:51 | Chechen Republic, Russia | |||
2888609 | 2888609 | 2022-08-12 | Russia | Karachay-Cherkess Republic | 46370 | 984 | 0 | 43.7368326 | 41.7267991 | 2022-08-13 04:20:52 | Karachay-Cherkess Republic, Russia | |||
3593027 | 3593027 | 2022-05-23 | Japan | Kagawa | 46370 | 123 | 0 | 34.217292 | 133.969047 | 2022-05-24 04:20:57 | Kagawa, Japan | |||
2659591 | 2659591 | 2022-01-31 | US | Mississippi | DeSoto | 28033 | 46370 | 483 | 0 | 34.87625235 | -89.99091418 | 2022-02-01 04:21:11 | DeSoto, Mississippi, US | |
567689 | 567689 | 2021-10-29 | US | California | Solano | 6095 | 46370 | 346 | 0 | 38.26827353 | -121.9357113 | 2021-10-30 04:22:03 | Solano, California, US | |
2902776 | 2902776 | 2021-08-12 | US | Texas | Galveston | 48167 | 46370 | 473 | 0 | 29.40167322 | -94.90469073 | 2021-08-13 04:21:24 | Galveston, Texas, US | |
1153153 | 1153153 | 2021-02-18 | Japan | Osaka | 46370 | 1082 | 43124 | 2164 | 34.620965000000005 | 135.507481 | 2021-02-19 05:24:16 | Osaka, Japan | ||
862733 | 862733 | 2020-12-11 | US | Nebraska | Douglas | 31055 | 46370 | 416 | 0 | 45954 | 41.29518299 | -96.15085305 | 2020-12-12 05:26:19 | Douglas, Nebraska, 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]);