johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where active = 4839 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170372 | 170372 | 2021-04-16 | Syria | 20856 | 1423 | 14594 | 4839 | 34.802075 | 38.99681500000001 | 2021-04-17 04:20:40 | Syria | |||
3670058 | 3670058 | 2021-03-06 | US | Ohio | Belmont | 39013 | 4999 | 160 | 0 | 4839 | 40.01625942 | -80.9924051 | 2021-03-07 05:21:54 | Belmont, Ohio, US |
3065916 | 3065916 | 2021-02-27 | Germany | Rheinland-Pfalz | 101823 | 3089 | 94075 | 4839 | 50.1183 | 7.309 | 2021-02-28 05:22:20 | Rheinland-Pfalz, Germany | ||
533021 | 533021 | 2021-02-22 | US | North Carolina | Halifax | 37083 | 4934 | 95 | 0 | 4839 | 36.25669272 | -77.6556109 | 2021-02-23 05:23:41 | Halifax, North Carolina, US |
473068 | 473068 | 2021-02-19 | US | Michigan | Midland | 26111 | 4903 | 64 | 0 | 4839 | 43.64330771 | -84.38804374 | 2021-02-20 05:22:51 | Midland, Michigan, US |
2680274 | 2680274 | 2021-02-13 | US | Ohio | Darke | 39037 | 4958 | 119 | 0 | 4839 | 40.13412966 | -84.6194517 | 2021-02-14 05:23:43 | Darke, Ohio, US |
1678686 | 1678686 | 2021-02-01 | US | New York | Cayuga | 36011 | 4922 | 83 | 0 | 4839 | 42.91261714 | -76.55731592 | 2021-02-02 05:22:49 | Cayuga, New York, US |
192980 | 192980 | 2021-01-11 | US | Tennessee | Carter | 47019 | 5197 | 103 | 0 | 4839 | 36.28969086 | -82.12588974 | 2021-01-12 05:22:15 | Carter, Tennessee, US |
1010539 | 1010539 | 2020-12-30 | Russia | Perm Krai | 30298 | 1123 | 24336 | 4839 | 58.5951603 | 56.3159546 | 2020-12-31 05:22:49 | Perm Krai, Russia | ||
2410352 | 2410352 | 2020-12-23 | US | Wisconsin | Calumet | 55015 | 4874 | 35 | 0 | 4839 | 44.0816316 | -88.21780273 | 2020-12-24 05:23:04 | Calumet, Wisconsin, US |
3149844 | 3149844 | 2020-12-16 | Russia | Tver Oblast | 18727 | 422 | 13466 | 4839 | 57.1134475 | 35.174442799999994 | 2020-12-17 05:28:12 | Tver Oblast, Russia | ||
3192288 | 3192288 | 2020-11-22 | US | North Carolina | Davidson | 37057 | 4888 | 49 | 0 | 4839 | 35.79115496 | -80.21256572 | 2020-11-23 05:25:26 | Davidson, North Carolina, US |
3189928 | 3189928 | 2020-11-22 | India | Bihar | 229544 | 1221 | 223484 | 4839 | 25.679658 | 85.60484 | 2020-11-23 05:25:26 | Bihar, India | ||
3441597 | 3441597 | 2020-11-11 | US | Georgia | Douglas | 13097 | 4922 | 83 | 0 | 4839 | 33.70291126 | -84.77026156 | 2020-11-12 05:25:55 | Douglas, Georgia, US |
3992788 | 3992788 | 2020-10-20 | US | New Mexico | Dona Ana | 35013 | 4902 | 63 | 0 | 4839 | 32.35275771 | -106.8329387 | 2020-10-21 04:24:14 | Dona Ana, New Mexico, US |
1822732 | 1822732 | 2020-10-04 | India | Goa | 35328 | 456 | 30033 | 4839 | 15.359682 | 74.057396 | 2020-10-05 04:23:33 | Goa, India | ||
344994 | 344994 | 2020-09-14 | US | Florida | St. Johns | 12109 | 4902 | 63 | 0 | 4839 | 29.90096506 | -81.43589967 | 2020-09-15 03:22:50 | St. Johns, Florida, US |
3867074 | 3867074 | 2020-06-03 | Honduras | 5690 | 234 | 617 | 4839 | 15.2 | -86.2419 | 2020-06-04 02:33:14 | Honduras |
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]);