johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where deaths = 4607 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3311981 | 3311981 | 2022-11-23 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-24 04:21:09 | British Columbia, Canada | |||
1620022 | 1620022 | 2022-11-22 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-23 04:21:06 | British Columbia, Canada | |||
3459910 | 3459910 | 2022-11-21 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-22 04:20:47 | British Columbia, Canada | |||
1640095 | 1640095 | 2022-11-20 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-21 04:21:05 | British Columbia, Canada | |||
2063652 | 2063652 | 2022-11-19 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-20 04:21:08 | British Columbia, Canada | |||
1755046 | 1755046 | 2022-11-18 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-19 04:21:14 | British Columbia, Canada | |||
3026039 | 3026039 | 2022-11-17 | Canada | British Columbia | 388984 | 4607 | 0 | 53.7267 | -127.6476 | 2022-11-18 04:21:15 | British Columbia, Canada | |||
1878040 | 1878040 | 2022-08-28 | US | Illinois | Unassigned | 90017 | 90 | 4607 | 0 | 42.36542373 | 0.0 | 2022-08-29 04:21:06 | Unassigned, Illinois, US | |
2097167 | 2097167 | 2022-08-27 | US | Illinois | Unassigned | 90017 | 90 | 4607 | 0 | 42.36542373 | 0.0 | 2022-08-28 04:21:02 | Unassigned, Illinois, US | |
1532982 | 1532982 | 2022-08-26 | US | Illinois | Unassigned | 90017 | 90 | 4607 | 0 | 42.36542373 | 0.0 | 2022-08-27 04:20:57 | Unassigned, Illinois, US | |
670325 | 670325 | 2022-07-21 | Japan | Tokyo | 1845743 | 4607 | 0 | 35.711343 | 139.446921 | 2022-07-22 04:21:15 | Tokyo, Japan | |||
2743799 | 2743799 | 2022-07-07 | US | Puerto Rico | Unassigned | 72999 | 26752 | 4607 | 0 | 18.459681 | -67.336525 | 2022-07-08 04:20:56 | Unassigned, Puerto Rico, US | |
3539125 | 3539125 | 2022-05-10 | United Kingdom | Northern Ireland | 710567 | 4607 | 0 | 54.7877 | -6.4923 | 2022-05-11 04:20:48 | Northern Ireland, United Kingdom | |||
2841038 | 2841038 | 2022-04-30 | Russia | Chuvashia Republic | 78635 | 4607 | 0 | 55.4259922 | 47.0849429 | 2022-05-01 04:20:57 | Chuvashia Republic, Russia | |||
1436600 | 1436600 | 2022-03-28 | Japan | Osaka | 782221 | 4607 | 0 | 34.620965000000005 | 135.507481 | 2022-03-29 04:20:46 | Osaka, Japan | |||
1231764 | 1231764 | 2021-11-28 | Netherlands | Zuid-Holland | 603672 | 4607 | 0 | 51.937835 | 4.462114 | 2021-11-29 04:22:30 | Zuid-Holland, Netherlands | |||
2876490 | 2876490 | 2021-10-09 | Slovenia | 300969 | 4607 | 0 | 46.1512 | 14.9955 | 2021-10-10 04:21:38 | Slovenia | ||||
1239320 | 1239320 | 2021-09-27 | Zimbabwe | 129919 | 4607 | 0 | -19.015438 | 29.154857 | 2021-09-28 04:21:28 | Zimbabwe | ||||
1237894 | 1237894 | 2021-09-27 | US | New York | New York | 36061 | 163017 | 4607 | 0 | 40.76727260000001 | -73.97152637 | 2021-09-28 04:21:28 | New York, New York, US | |
2078195 | 2078195 | 2021-09-26 | US | New York | New York | 36061 | 162810 | 4607 | 0 | 40.76727260000001 | -73.97152637 | 2021-09-27 04:21:16 | New York, New York, US | |
1385831 | 1385831 | 2021-09-13 | Russia | Irkutsk Oblast | 102714 | 4607 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-14 04:21:41 | Irkutsk Oblast, Russia | |||
3632043 | 3632043 | 2021-07-14 | Mexico | Guerrero | 44051 | 4607 | 0 | 39444 | 17.4392 | -99.5451 | 2021-07-15 04:21:48 | Guerrero, Mexico | ||
1771072 | 1771072 | 2021-05-23 | Brazil | Alagoas | 188958 | 4607 | 177282 | 7069 | -9.5713 | -36.782 | 2021-05-24 04:20:53 | Alagoas, Brazil | ||
3643547 | 3643547 | 2021-03-30 | Italy | Sicilia | 172450 | 4607 | 150426 | 17417 | 38.11569725 | 13.362356699999998 | 2021-03-31 04:26:25 | Sicilia, Italy | ||
1290000 | 1290000 | 2021-03-29 | Italy | Sicilia | 172450 | 4607 | 150426 | 17417 | 38.11569725 | 13.362356699999998 | 2021-03-30 04:26:23 | Sicilia, Italy | ||
3369887 | 3369887 | 2021-03-21 | US | California | Orange | 6059 | 264721 | 4607 | 0 | 33.70147516 | -117.76459979999998 | 2021-03-22 05:25:43 | Orange, California, US | |
3981678 | 3981678 | 2021-02-10 | US | Texas | Harris | 48201 | 398471 | 4607 | 0 | 325649 | 29.85864939 | -95.39339521 | 2021-02-11 05:23:55 | Harris, Texas, US |
375916 | 375916 | 2020-11-06 | Brazil | Amazonas | 164070 | 4607 | 140356 | 19107 | -3.4168 | -65.8561 | 2020-11-07 05:24:52 | Amazonas, Brazil | ||
891854 | 891854 | 2020-11-05 | Brazil | Amazonas | 164070 | 4607 | 138647 | 20164 | -3.4168 | -65.8561 | 2020-11-06 05:24:55 | Amazonas, Brazil |
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]);