johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where deaths = 4951 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756667 | 2756667 | 2022-10-18 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-19 04:22:26 | Alberta, Canada | |||
2024501 | 2024501 | 2022-10-17 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-18 04:22:42 | Alberta, Canada | |||
2159279 | 2159279 | 2022-10-16 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-17 04:20:31 | Alberta, Canada | |||
515476 | 515476 | 2022-10-15 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-16 04:22:39 | Alberta, Canada | |||
2032533 | 2032533 | 2022-10-14 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-15 04:22:00 | Alberta, Canada | |||
3753221 | 3753221 | 2022-10-13 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-14 04:22:28 | Alberta, Canada | |||
3214046 | 3214046 | 2022-10-12 | Canada | Alberta | 610027 | 4951 | 0 | 53.9333 | -116.5765 | 2022-10-13 04:22:39 | Alberta, Canada | |||
670589 | 670589 | 2022-07-21 | Spain | Aragon | 449760 | 4951 | 0 | 41.5976 | -0.9057 | 2022-07-22 04:21:15 | Aragon, Spain | |||
1608552 | 1608552 | 2022-07-20 | Spain | Aragon | 449760 | 4951 | 0 | 41.5976 | -0.9057 | 2022-07-21 04:21:10 | Aragon, Spain | |||
959185 | 959185 | 2022-07-19 | Spain | Aragon | 449760 | 4951 | 0 | 41.5976 | -0.9057 | 2022-07-20 04:20:59 | Aragon, Spain | |||
1767653 | 1767653 | 2022-07-03 | Sudan | 62624 | 4951 | 0 | 12.8628 | 30.2176 | 2022-07-04 04:20:54 | Sudan | ||||
3365639 | 3365639 | 2022-07-02 | Sudan | 62624 | 4951 | 0 | 12.8628 | 30.2176 | 2022-07-03 04:20:59 | Sudan | ||||
593968 | 593968 | 2022-07-01 | Sudan | 62624 | 4951 | 0 | 12.8628 | 30.2176 | 2022-07-02 04:21:16 | Sudan | ||||
3940369 | 3940369 | 2022-06-30 | Sudan | 62624 | 4951 | 0 | 12.8628 | 30.2176 | 2022-07-01 04:21:10 | Sudan | ||||
2490327 | 2490327 | 2022-06-29 | Sudan | 62624 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-30 04:21:01 | Sudan | ||||
2239709 | 2239709 | 2022-06-28 | Sudan | 62551 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-29 04:20:59 | Sudan | ||||
2147951 | 2147951 | 2022-06-27 | Sudan | 62551 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-28 04:20:58 | Sudan | ||||
475752 | 475752 | 2022-06-26 | Sudan | 62551 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-27 04:21:00 | Sudan | ||||
939127 | 939127 | 2022-06-25 | Sudan | 62551 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-26 04:21:02 | Sudan | ||||
3346947 | 3346947 | 2022-06-24 | Sudan | 62551 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-25 04:20:57 | Sudan | ||||
1648688 | 1648688 | 2022-06-23 | Sudan | 62551 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-24 04:20:58 | Sudan | ||||
2187923 | 2187923 | 2022-06-22 | Sudan | 62541 | 4951 | 0 | 12.8628 | 30.2176 | 2022-06-23 04:20:55 | Sudan | ||||
1948481 | 1948481 | 2022-04-12 | Italy | Friuli Venezia Giulia | 346554 | 4951 | 0 | 45.6494354 | 13.76813649 | 2022-04-13 04:21:03 | Friuli Venezia Giulia, Italy | |||
3859469 | 3859469 | 2022-02-18 | Ukraine | Kiev Oblast | 220202 | 4951 | 0 | 50.053000000000004 | 30.7667 | 2022-02-19 04:21:11 | Kiev Oblast, Ukraine | |||
233377 | 233377 | 2022-02-11 | Netherlands | Zuid-Holland | 1262124 | 4951 | 0 | 51.937835 | 4.462114 | 2022-02-12 04:21:06 | Zuid-Holland, Netherlands | |||
2012749 | 2012749 | 2022-02-06 | Latvia | 450105 | 4951 | 0 | 56.8796 | 24.6032 | 2022-02-07 04:21:05 | Latvia | ||||
3998743 | 3998743 | 2021-12-30 | Mexico | Morelos | 50602 | 4951 | 0 | 18.6813 | -99.1013 | 2021-12-31 04:21:50 | Morelos, Mexico | |||
3970254 | 3970254 | 2021-06-11 | Azerbaijan | 335065 | 4951 | 328194 | 1920 | 40.1431 | 47.5769 | 2021-06-12 04:22:22 | Azerbaijan | |||
2716676 | 2716676 | 2021-06-10 | Azerbaijan | 334992 | 4951 | 327907 | 2134 | 40.1431 | 47.5769 | 2021-06-11 04:23:20 | Azerbaijan | |||
3472203 | 3472203 | 2021-06-08 | Georgia | 350428 | 4951 | 335029 | 10448 | 42.3154 | 43.3569 | 2021-06-09 04:23:31 | Georgia | |||
3369418 | 3369418 | 2021-03-21 | Mexico | Michoacan | 44569 | 4951 | 0 | 39618 | 19.5665 | -101.7068 | 2021-03-22 05:25:43 | Michoacan, Mexico | ||
2211830 | 2211830 | 2021-01-30 | Peru | Lambayeque | 35543 | 4951 | 0 | 30592 | -6.353049 | -79.824113 | 2021-01-31 05:22:42 | Lambayeque, Peru | ||
2120004 | 2120004 | 2020-12-20 | Spain | Castilla y Leon | 128932 | 4951 | 8716 | 115265 | 41.8357 | -4.3976 | 2020-12-21 05:27:58 | Castilla y Leon, Spain | ||
2931511 | 2931511 | 2020-12-19 | Spain | Castilla y Leon | 128932 | 4951 | 8716 | 115265 | 41.8357 | -4.3976 | 2020-12-20 05:27:32 | Castilla y Leon, Spain | ||
1901457 | 1901457 | 2020-12-18 | Spain | Castilla y Leon | 128932 | 4951 | 8716 | 115265 | 41.8357 | -4.3976 | 2020-12-19 05:27:52 | Castilla y Leon, Spain | ||
1006027 | 1006027 | 2020-12-06 | Brazil | Amazonas | 182668 | 4951 | 156395 | 21322 | -3.4168 | -65.8561 | 2020-12-07 05:26:14 | Amazonas, Brazil | ||
2215508 | 2215508 | 2020-08-23 | Colombia | Capital District | 188220 | 4951 | 122221 | 61048 | 4.711 | -74.0721 | 2020-08-24 04:27:56 | Capital District, Colombia | ||
1613205 | 1613205 | 2020-08-14 | US | Illinois | Cook | 17031 | 114724 | 4951 | 0 | 109773 | 41.84144849 | -87.81658794 | 2020-08-15 04:27:31 | Cook, Illinois, US |
3612575 | 3612575 | 2020-08-06 | Egypt | 95006 | 4951 | 48898 | 41157 | 26.820553000000004 | 30.802498 | 2020-08-07 04:35:11 | Egypt |
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]);