johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 32161 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
880307 | 880307 | 2022-08-05 | Japan | Tottori | 32161 | 25 | 0 | 35.359069 | 133.863619 | 2022-08-06 04:20:56 | Tottori, Japan | |||
3187595 | 3187595 | 2022-05-30 | US | Massachusetts | Hampshire | 25015 | 32161 | 359 | 0 | 42.33997957 | -72.65898478 | 2022-05-31 04:20:51 | Hampshire, Massachusetts, US | |
3199744 | 3199744 | 2022-05-29 | US | Massachusetts | Hampshire | 25015 | 32161 | 359 | 0 | 42.33997957 | -72.65898478 | 2022-05-30 04:20:50 | Hampshire, Massachusetts, US | |
2726622 | 2726622 | 2022-05-28 | US | Massachusetts | Hampshire | 25015 | 32161 | 359 | 0 | 42.33997957 | -72.65898478 | 2022-05-29 04:20:53 | Hampshire, Massachusetts, US | |
1315803 | 1315803 | 2022-05-27 | US | Massachusetts | Hampshire | 25015 | 32161 | 359 | 0 | 42.33997957 | -72.65898478 | 2022-05-28 04:21:07 | Hampshire, Massachusetts, US | |
3496133 | 3496133 | 2021-12-15 | India | Nagaland | 32161 | 700 | 0 | 26.06702 | 94.470302 | 2021-12-16 04:22:11 | Nagaland, India | |||
2087918 | 2087918 | 2021-12-14 | India | Nagaland | 32161 | 700 | 0 | 26.06702 | 94.470302 | 2021-12-15 03:22:16 | Nagaland, India | |||
722447 | 722447 | 2021-11-20 | India | Sikkim | 32161 | 403 | 0 | 27.571671000000002 | 88.472712 | 2021-11-21 04:22:13 | Sikkim, India | |||
162206 | 162206 | 2021-11-19 | Peru | Ucayali | 32161 | 3091 | 0 | -9.621718 | -73.444929 | 2021-11-20 04:22:17 | Ucayali, Peru | |||
3289093 | 3289093 | 2021-11-18 | Peru | Ucayali | 32161 | 3091 | 0 | -9.621718 | -73.444929 | 2021-11-19 04:21:40 | Ucayali, Peru | |||
447549 | 447549 | 2021-11-17 | Peru | Ucayali | 32161 | 3091 | 0 | -9.621718 | -73.444929 | 2021-11-18 04:21:33 | Ucayali, Peru | |||
2004780 | 2004780 | 2021-05-12 | Netherlands | Drenthe | 32161 | 350 | 0 | 31772 | 52.862485 | 6.618435000000002 | 2021-05-13 04:20:51 | Drenthe, Netherlands | ||
2450729 | 2450729 | 2021-05-02 | India | Manipur | 32161 | 415 | 29923 | 1823 | 24.738975 | 93.882541 | 2021-05-03 04:20:39 | Manipur, India | ||
2020909 | 2020909 | 2021-04-20 | Russia | Astrakhan Oblast | 32161 | 712 | 30678 | 771 | 47.1878186 | 47.608851 | 2021-04-21 04:21:14 | Astrakhan Oblast, Russia | ||
1980814 | 1980814 | 2021-03-25 | Russia | Ivanovo Oblast | 32161 | 1023 | 30504 | 634 | 56.9167446 | 41.43521370000001 | 2021-03-26 05:26:55 | Ivanovo Oblast, Russia | ||
202345 | 202345 | 2020-12-25 | Mexico | Michoacan | 32161 | 2669 | 0 | 29492 | 19.5665 | -101.7068 | 2020-12-26 05:22:28 | Michoacan, 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]);