johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where deaths = 2969 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752891 | 2752891 | 2022-12-29 | Japan | Chiba | 1275307 | 2969 | 0 | 35.510141 | 140.198917 | 2022-12-30 04:21:04 | Chiba, Japan | |||
253278 | 253278 | 2022-09-08 | Italy | Calabria | 544934 | 2969 | 0 | 38.90597598 | 16.59440194 | 2022-09-09 04:21:11 | Calabria, Italy | |||
3745076 | 3745076 | 2022-09-07 | Italy | Calabria | 544245 | 2969 | 0 | 38.90597598 | 16.59440194 | 2022-09-08 04:21:02 | Calabria, Italy | |||
2740788 | 2740788 | 2022-07-07 | Chile | Maule | 264213 | 2969 | 0 | -35.5183 | -71.6885 | 2022-07-08 04:20:56 | Maule, Chile | |||
1572120 | 1572120 | 2022-05-03 | Jamaica | 130388 | 2969 | 0 | 18.1096 | -77.2975 | 2022-05-04 04:20:59 | Jamaica | ||||
2115907 | 2115907 | 2022-04-08 | Russia | Astrakhan Oblast | 115181 | 2969 | 0 | 47.1878186 | 47.608851 | 2022-04-09 04:20:42 | Astrakhan Oblast, Russia | |||
2140390 | 2140390 | 2022-03-09 | Russia | Komi Republic | 163374 | 2969 | 0 | 63.9881421 | 54.3326073 | 2022-03-10 04:20:48 | Komi Republic, Russia | |||
2140214 | 2140214 | 2022-03-09 | Kyrgyzstan | 200671 | 2969 | 0 | 41.20438 | 74.766098 | 2022-03-10 04:20:48 | Kyrgyzstan | ||||
942896 | 942896 | 2022-02-28 | Malaysia | Sabah | 339554 | 2969 | 0 | 5.9788 | 116.0753 | 2022-03-01 04:21:09 | Sabah, Malaysia | |||
71390 | 71390 | 2022-02-07 | Spain | Galicia | 480394 | 2969 | 0 | 42.5751 | -8.1339 | 2022-02-08 04:21:15 | Galicia, Spain | |||
2015700 | 2015700 | 2022-02-06 | US | Tennessee | Shelby | 47157 | 229232 | 2969 | 0 | 35.1864775 | -89.89692423 | 2022-02-07 04:21:05 | Shelby, Tennessee, US | |
1297029 | 1297029 | 2022-02-05 | US | Tennessee | Shelby | 47157 | 229046 | 2969 | 0 | 35.1864775 | -89.89692423 | 2022-02-06 04:21:00 | Shelby, Tennessee, US | |
2330357 | 2330357 | 2022-02-04 | US | Tennessee | Shelby | 47157 | 228775 | 2969 | 0 | 35.1864775 | -89.89692423 | 2022-02-05 04:21:05 | Shelby, Tennessee, US | |
2167826 | 2167826 | 2022-01-01 | Russia | Vologda Oblast | 100053 | 2969 | 0 | 60.0391461 | 43.1215213 | 2022-01-02 04:20:52 | Vologda Oblast, Russia | |||
2963612 | 2963612 | 2021-12-24 | Russia | Leningrad Oblast | 99199 | 2969 | 0 | 60.185329599999996 | 32.3925325 | 2021-12-25 04:21:37 | Leningrad Oblast, Russia | |||
3749386 | 3749386 | 2021-11-22 | Russia | Udmurt Republic | 72242 | 2969 | 0 | 57.1961165 | 52.69598320000001 | 2021-11-23 04:22:39 | Udmurt Republic, Russia | |||
423171 | 423171 | 2021-10-10 | Colombia | Bolivar | 156836 | 2969 | 0 | 8.6704 | -74.03 | 2021-10-11 04:21:31 | Bolivar, Colombia | |||
2961538 | 2961538 | 2021-10-08 | US | New Jersey | Bergen | 34003 | 117607 | 2969 | 0 | 40.96010917 | -74.07164325 | 2021-10-09 04:21:34 | Bergen, New Jersey, US | |
2772995 | 2772995 | 2021-09-30 | Japan | Osaka | 199550 | 2969 | 0 | 34.620965000000005 | 135.507481 | 2021-10-01 04:21:35 | Osaka, Japan | |||
3193885 | 3193885 | 2021-09-06 | El Salvador | 96067 | 2969 | 0 | 13.7942 | -88.8965 | 2021-09-07 04:21:35 | El Salvador | ||||
2422987 | 2422987 | 2021-06-23 | Mexico | Quintana Roo | 31128 | 2969 | 0 | 28159 | 19.1817 | -88.4791 | 2021-06-24 04:21:55 | Quintana Roo, Mexico | ||
2911117 | 2911117 | 2021-06-17 | India | Goa | 163612 | 2969 | 156819 | 3824 | 15.359682 | 74.057396 | 2021-06-18 04:22:16 | Goa, India | ||
1736218 | 1736218 | 2021-06-12 | Belarus | 404740 | 2969 | 397587 | 4184 | 53.7098 | 27.9534 | 2021-06-13 04:22:44 | Belarus | |||
1773505 | 1773505 | 2021-05-23 | US | New Jersey | Essex | 34013 | 93798 | 2969 | 0 | 40.78681335 | -74.24657979 | 2021-05-24 04:20:53 | Essex, New Jersey, US | |
728660 | 728660 | 2021-05-22 | US | New Jersey | Essex | 34013 | 93800 | 2969 | 0 | 40.78681335 | -74.24657979 | 2021-05-23 04:20:51 | Essex, New Jersey, US | |
1536053 | 1536053 | 2021-03-28 | Netherlands | Noord-Brabant | 195884 | 2969 | 0 | 194389 | 51.561174 | 5.184942 | 2021-03-29 04:28:35 | Noord-Brabant, Netherlands | ||
998192 | 998192 | 2021-03-01 | Brazil | Sergipe | 152003 | 2969 | 142095 | 6939 | -10.5741 | -37.3857 | 2021-03-02 05:23:30 | Sergipe, Brazil | ||
1857734 | 1857734 | 2021-02-25 | Brazil | Alagoas | 129917 | 2969 | 123631 | 3317 | -9.5713 | -36.782 | 2021-02-26 05:22:40 | Alagoas, Brazil | ||
845656 | 845656 | 2020-12-12 | Mexico | Hidalgo | 21129 | 2969 | 0 | 18160 | 20.0911 | -98.7624 | 2020-12-13 05:27:20 | Hidalgo, Mexico | ||
860654 | 860654 | 2020-12-11 | Israel | 353269 | 2969 | 333900 | 16400 | 31.046051 | 34.851612 | 2020-12-12 05:26:19 | Israel | |||
3782002 | 3782002 | 2020-10-13 | Mexico | Tabasco | 33195 | 2969 | 29479 | 747 | 17.8409 | -92.6189 | 2020-10-14 04:24:05 | Tabasco, Mexico | ||
546850 | 546850 | 2020-09-12 | Mexico | Sinaloa | 17289 | 2969 | 13635 | 685 | 25.1721 | -107.4795 | 2020-09-13 04:30:52 | Sinaloa, Mexico |
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]);