johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where deaths = 3963 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- India 8
- Spain 7
- Dominican Republic 3
- Italy 2
- Mexico 2
- Peru 2
- Russia 2
- US 2
- Zambia 2
- Brazil 1
- Japan 1
- Namibia 1
- Trinidad and Tobago 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3377678 | 3377678 | 2022-12-08 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-09 04:21:05 | Galicia, Spain | |||
1984949 | 1984949 | 2022-12-07 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-08 04:21:07 | Galicia, Spain | |||
3714472 | 3714472 | 2022-12-06 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-07 04:20:58 | Galicia, Spain | |||
2415177 | 2415177 | 2022-12-05 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-06 04:21:03 | Galicia, Spain | |||
718785 | 718785 | 2022-12-04 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-05 04:20:58 | Galicia, Spain | |||
2817074 | 2817074 | 2022-12-03 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-04 04:20:56 | Galicia, Spain | |||
833930 | 833930 | 2022-12-02 | Spain | Galicia | 740432 | 3963 | 0 | 42.5751 | -8.1339 | 2022-12-03 04:21:02 | Galicia, Spain | |||
2987217 | 2987217 | 2022-09-04 | India | Goa | 256510 | 3963 | 0 | 15.359682 | 74.057396 | 2022-09-05 04:21:01 | Goa, India | |||
2712902 | 2712902 | 2022-09-03 | India | Goa | 256409 | 3963 | 0 | 15.359682 | 74.057396 | 2022-09-04 04:21:22 | Goa, India | |||
1393607 | 1393607 | 2022-09-02 | India | Goa | 256300 | 3963 | 0 | 15.359682 | 74.057396 | 2022-09-03 04:21:04 | Goa, India | |||
3547436 | 3547436 | 2022-09-01 | India | Goa | 256224 | 3963 | 0 | 15.359682 | 74.057396 | 2022-09-02 04:21:07 | Goa, India | |||
2343356 | 2343356 | 2022-08-31 | India | Goa | 256182 | 3963 | 0 | 15.359682 | 74.057396 | 2022-09-01 04:21:03 | Goa, India | |||
1407294 | 1407294 | 2022-08-02 | US | New York | Nassau | 36059 | 475473 | 3963 | 0 | 40.74066522 | -73.58941873 | 2022-08-03 04:20:59 | Nassau, New York, US | |
2418862 | 2418862 | 2022-07-15 | Italy | Marche | 539267 | 3963 | 0 | 43.61675973 | 13.5188753 | 2022-07-16 04:21:05 | Marche, Italy | |||
2235726 | 2235726 | 2022-06-12 | Trinidad and Tobago | 164723 | 3963 | 0 | 10.6918 | -61.2225 | 2022-06-13 04:21:14 | Trinidad and Tobago | ||||
3852011 | 3852011 | 2022-04-27 | Russia | Bryansk Oblast | 160936 | 3963 | 0 | 52.8873315 | 33.415853 | 2022-04-28 04:20:47 | Bryansk Oblast, Russia | |||
1908875 | 1908875 | 2022-03-22 | Zambia | 316088 | 3963 | 0 | -13.133897 | 27.849332 | 2022-03-23 04:20:48 | Zambia | ||||
3242006 | 3242006 | 2022-03-21 | Zambia | 315892 | 3963 | 0 | -13.133897 | 27.849332 | 2022-03-22 04:20:54 | Zambia | ||||
2263917 | 2263917 | 2022-03-14 | Japan | Tokyo | 1127194 | 3963 | 0 | 35.711343 | 139.446921 | 2022-03-15 04:20:47 | Tokyo, Japan | |||
3062115 | 3062115 | 2022-01-29 | Namibia | 155783 | 3963 | 0 | -22.9576 | 18.4904 | 2022-01-30 04:21:26 | Namibia | ||||
99064 | 99064 | 2022-01-14 | Brazil | Tocantins | 242824 | 3963 | 0 | -10.1753 | -48.2982 | 2022-01-15 04:21:07 | Tocantins, Brazil | |||
1081587 | 1081587 | 2021-12-09 | United Kingdom | Northern Ireland | 335228 | 3963 | 0 | 54.7877 | -6.4923 | 2021-12-10 04:22:28 | Northern Ireland, United Kingdom | |||
3121458 | 3121458 | 2021-11-05 | India | Telangana | 672203 | 3963 | 0 | 18.1124 | 79.0193 | 2021-11-06 04:21:51 | Telangana, India | |||
3683332 | 3683332 | 2021-08-02 | Dominican Republic | 342660 | 3963 | 324227 | 14470 | 18.7357 | -70.1627 | 2021-08-03 04:21:39 | Dominican Republic | |||
3015231 | 3015231 | 2021-08-01 | Dominican Republic | 342267 | 3963 | 323700 | 14604 | 18.7357 | -70.1627 | 2021-08-02 04:21:36 | Dominican Republic | |||
3903854 | 3903854 | 2021-07-31 | Dominican Republic | 341905 | 3963 | 323333 | 14609 | 18.7357 | -70.1627 | 2021-08-01 04:21:50 | Dominican Republic | |||
778611 | 778611 | 2021-07-08 | Russia | Sverdlovsk Oblast | 96485 | 3963 | 89866 | 2656 | 58.6414755 | 61.8021546 | 2021-07-09 04:21:21 | Sverdlovsk Oblast, Russia | ||
1893235 | 1893235 | 2021-06-30 | Mexico | Oaxaca | 48620 | 3963 | 0 | 44657 | 17.0732 | -96.7266 | 2021-07-01 04:21:19 | Oaxaca, Mexico | ||
1448693 | 1448693 | 2021-06-03 | Mexico | Yucatan | 40504 | 3963 | 0 | 36541 | 20.7099 | -89.0943 | 2021-06-04 04:23:37 | Yucatan, Mexico | ||
1708260 | 1708260 | 2021-06-02 | India | Jammu and Kashmir | 294078 | 3963 | 258536 | 31579 | 33.75943 | 76.612638 | 2021-06-03 04:23:32 | Jammu and Kashmir, India | ||
1913369 | 1913369 | 2021-05-20 | Peru | Cusco | 59820 | 3963 | 0 | 55857 | -13.191068 | -72.153609 | 2021-05-21 04:20:43 | Cusco, Peru | ||
471406 | 471406 | 2021-02-19 | Italy | Sicilia | 148105 | 3963 | 112573 | 31569 | 38.11569725 | 13.362356699999998 | 2021-02-20 05:22:51 | Sicilia, Italy | ||
1898838 | 1898838 | 2021-01-29 | US | Michigan | Wayne | 26163 | 96445 | 3963 | 0 | 92482 | 42.28098405 | -83.281255 | 2021-01-30 05:22:49 | Wayne, Michigan, US |
3480461 | 3480461 | 2020-10-26 | Peru | Arequipa | 44256 | 3963 | 0 | 40293 | -15.843524 | -72.475539 | 2020-10-27 04:24:45 | Arequipa, Peru | ||
3264553 | 3264553 | 2020-07-31 | India | Delhi | 135598 | 3963 | 120930 | 10705 | 28.646519 | 77.10898 | 2020-08-01 04:36:27 | Delhi, India |
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]);