johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 46222 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116922 | 116922 | 2022-09-06 | US | New Jersey | Cumberland | 34011 | 46222 | 631 | 0 | 39.37199394 | -75.10712559 | 2022-09-07 04:20:59 | Cumberland, New Jersey, US | |
1405254 | 1405254 | 2022-08-02 | Russia | Karachay-Cherkess Republic | 46222 | 984 | 0 | 43.7368326 | 41.7267991 | 2022-08-03 04:20:59 | Karachay-Cherkess Republic, Russia | |||
1421135 | 1421135 | 2022-06-08 | Japan | Yamaguchi | 46222 | 178 | 0 | 34.20119 | 131.573293 | 2022-06-09 04:20:54 | Yamaguchi, Japan | |||
782713 | 782713 | 2021-12-13 | Sweden | Ostergotland | 46222 | 661 | 0 | 58.3454 | 15.5198 | 2021-12-14 04:22:38 | Ostergotland, Sweden | |||
1660748 | 1660748 | 2021-12-12 | Sweden | Ostergotland | 46222 | 661 | 0 | 58.3454 | 15.5198 | 2021-12-13 04:22:02 | Ostergotland, Sweden | |||
1664764 | 1664764 | 2021-12-11 | Sweden | Ostergotland | 46222 | 661 | 0 | 58.3454 | 15.5198 | 2021-12-12 04:22:12 | Ostergotland, Sweden | |||
3655916 | 3655916 | 2021-12-10 | Sweden | Ostergotland | 46222 | 661 | 0 | 58.3454 | 15.5198 | 2021-12-11 04:22:45 | Ostergotland, Sweden | |||
1342481 | 1342481 | 2021-08-11 | Russia | Belgorod Oblast | 46222 | 944 | 0 | 50.7080119 | 37.5837615 | 2021-08-12 04:21:25 | Belgorod Oblast, Russia | |||
1002070 | 1002070 | 2021-03-01 | Ukraine | Poltava Oblast | 46222 | 977 | 42421 | 2824 | 49.5883 | 34.5514 | 2021-03-02 05:23:30 | Poltava Oblast, Ukraine | ||
2680312 | 2680312 | 2021-02-13 | US | Ohio | Montgomery | 39113 | 46222 | 963 | 0 | 45260 | 39.75394919 | -84.29050975 | 2021-02-14 05:23:43 | Montgomery, Ohio, US |
3543099 | 3543099 | 2021-02-12 | Ukraine | Zhytomyr Oblast | 46222 | 777 | 42657 | 2788 | 50.2547 | 28.6587 | 2021-02-13 05:22:12 | Zhytomyr Oblast, Ukraine | ||
191707 | 191707 | 2021-01-11 | US | Michigan | Kent | 26081 | 46222 | 594 | 0 | 45628 | 43.03197711 | -85.54934642 | 2021-01-12 05:22:15 | Kent, Michigan, US |
2613958 | 2613958 | 2020-09-26 | Ghana | 46222 | 299 | 45417 | 506 | 7.9465 | -1.0232 | 2020-09-27 04:23:00 | Ghana | |||
2812673 | 2812673 | 2020-09-25 | Ghana | 46222 | 299 | 45417 | 506 | 7.9465 | -1.0232 | 2020-09-26 04:23:00 | Ghana | |||
2605950 | 2605950 | 2020-09-24 | Ghana | 46222 | 299 | 45417 | 506 | 7.9465 | -1.0232 | 2020-09-25 04:23:00 | Ghana |
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]);