johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

18 rows where deaths = 4765 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 11

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
350573 350573 2022-12-14 US New York Suffolk 36103 544241 4765 0   40.88320119 -72.8012172 2022-12-15 04:20:58 Suffolk, New York, US
3547400 3547400 2022-09-01 Germany Berlin     1230732 4765 0   52.52 13.405 2022-09-02 04:21:07 Berlin, Germany
2343320 2343320 2022-08-31 Germany Berlin     1229249 4765 0   52.52 13.405 2022-09-01 04:21:03 Berlin, Germany
1065811 1065811 2022-07-28 India Jammu and Kashmir     461947 4765 0   33.75943 76.612638 2022-07-29 04:20:45 Jammu and Kashmir, India
2335330 2335330 2022-07-27 India Jammu and Kashmir     461947 4765 0   33.75943 76.612638 2022-07-28 04:20:56 Jammu and Kashmir, India
1611929 1611929 2022-07-20 United Kingdom Northern Ireland     713294 4765 0   54.7877 -6.4923 2022-07-21 04:21:10 Northern Ireland, United Kingdom
574800 574800 2022-02-25 Italy Friuli Venezia Giulia     306992 4765 0   45.6494354 13.76813649 2022-02-26 04:21:12 Friuli Venezia Giulia, Italy
3342713 3342713 2021-11-16 Mexico Morelos     49873 4765 0   18.6813 -99.1013 2021-11-17 04:21:48 Morelos, Mexico
2618104 2618104 2021-09-17 Lithuania       314705 4765 0   55.1694 23.8813 2021-09-18 04:21:24 Lithuania
3555755 3555755 2021-08-21 Mexico Yucatan     59364 4765 0   20.7099 -89.0943 2021-08-22 04:21:29 Yucatan, Mexico
3954638 3954638 2021-05-11 Pakistan Sindh     294251 4765 271581 17905 26.009446 68.77680699999999 2021-05-12 04:21:29 Sindh, Pakistan
974656 974656 2021-02-06 Brazil Maranhao     209604 4765 196784 7793 -4.9609 -45.2744 2021-02-07 05:23:00 Maranhao, Brazil
12324 12324 2021-01-26 Italy Lazio     199606 4765 128709 66132 41.89277044 12.48366722 2021-01-27 05:23:41 Lazio, Italy
2227855 2227855 2021-01-02 Tunisia       141979 4765 106050 31164 33.886917 9.537499 2021-01-03 05:22:52 Tunisia
1600311 1600311 2020-12-10 Mexico Nuevo Leon     71981 4765 0 67216 25.5922 -99.9962 2020-12-11 05:26:59 Nuevo Leon, Mexico
2935195 2935195 2020-11-28 India Punjab     150805 4765 138206 7834 30.841465000000003 75.40879 2020-11-29 05:25:55 Punjab, India
1041977 1041977 2020-10-07 Peru Callao     33832 4765 0 29067 -11.954609 -77.136042 2020-10-08 04:23:56 Callao, Peru
2705828 2705828 2020-07-17 US Illinois Cook 17031 97790 4765 0 93025 41.84144849 -87.81658794 2020-07-18 04:34:45 Cook, Illinois, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);