johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where deaths = 4764 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
463571 | 463571 | 2022-05-02 | Peru | Puno | 65981 | 4764 | 0 | -14.995827 | -69.922726 | 2022-05-03 04:21:00 | Puno, Peru | |||
3916210 | 3916210 | 2022-05-01 | Peru | Puno | 65981 | 4764 | 0 | -14.995827 | -69.922726 | 2022-05-02 04:21:10 | Puno, Peru | |||
2841014 | 2841014 | 2022-04-30 | Peru | Puno | 65981 | 4764 | 0 | -14.995827 | -69.922726 | 2022-05-01 04:20:57 | Puno, Peru | |||
1157327 | 1157327 | 2022-04-29 | Peru | Puno | 65981 | 4764 | 0 | -14.995827 | -69.922726 | 2022-04-30 04:21:05 | Puno, Peru | |||
1696509 | 1696509 | 2022-04-28 | Peru | Puno | 65981 | 4764 | 0 | -14.995827 | -69.922726 | 2022-04-29 04:20:59 | Puno, Peru | |||
3851992 | 3851992 | 2022-04-27 | Peru | Puno | 65981 | 4764 | 0 | -14.995827 | -69.922726 | 2022-04-28 04:20:47 | Puno, Peru | |||
1326422 | 1326422 | 2022-04-26 | Peru | Puno | 65981 | 4764 | 0 | -14.995826999999998 | -69.922726 | 2022-04-27 04:20:52 | Puno, Peru | |||
3722376 | 3722376 | 2022-04-25 | Peru | Puno | 65981 | 4764 | 0 | -14.995826999999998 | -69.922726 | 2022-04-26 04:20:51 | Puno, Peru | |||
2016334 | 2016334 | 2022-02-06 | Ukraine | Crimea Republic* | 137519 | 4764 | 0 | 45.2835 | 34.2008 | 2022-02-07 04:21:05 | Crimea Republic*, Ukraine | |||
102961 | 102961 | 2022-01-14 | Ukraine | Kiev Oblast | 188475 | 4764 | 0 | 50.053000000000004 | 30.7667 | 2022-01-15 04:21:07 | Kiev Oblast, Ukraine | |||
1284240 | 1284240 | 2022-01-05 | US | New York | New York | 36061 | 304048 | 4764 | 0 | 40.76727260000001 | -73.97152637 | 2022-01-06 04:22:09 | New York, New York, US | |
451044 | 451044 | 2021-11-17 | West Bank and Gaza | 457477 | 4764 | 0 | 31.9522 | 35.2332 | 2021-11-18 04:21:33 | West Bank and Gaza | ||||
2287549 | 2287549 | 2021-11-15 | Mexico | Morelos | 49864 | 4764 | 0 | 18.6813 | -99.1013 | 2021-11-16 04:21:10 | Morelos, Mexico | |||
491797 | 491797 | 2021-10-14 | Peru | Cusco | 73600 | 4764 | 0 | -13.191068 | -72.153609 | 2021-10-15 04:21:26 | Cusco, Peru | |||
634085 | 634085 | 2021-10-13 | Peru | Cusco | 73600 | 4764 | 0 | -13.191068 | -72.153609 | 2021-10-14 04:21:29 | Cusco, Peru | |||
1491763 | 1491763 | 2021-10-12 | Peru | Cusco | 73600 | 4764 | 0 | -13.191068 | -72.153609 | 2021-10-13 04:20:51 | Cusco, Peru | |||
778300 | 778300 | 2021-07-08 | India | Assam | 527200 | 4764 | 499388 | 23048 | 26.357149 | 92.830441 | 2021-07-09 04:21:21 | Assam, India | ||
2020824 | 2020824 | 2021-04-20 | Mexico | Tamaulipas | 55863 | 4764 | 0 | 51099 | 24.2669 | -98.8363 | 2021-04-21 04:21:14 | Tamaulipas, Mexico | ||
609854 | 609854 | 2020-08-29 | Peru | Piura | 27779 | 4764 | 0 | 23015 | -5.133361 | -80.335861 | 2020-08-30 04:28:22 | Piura, Peru | ||
1996864 | 1996864 | 2020-08-26 | Russia | Moscow | 259070 | 4764 | 208193 | 46113 | 55.7504461 | 37.6174943 | 2020-08-27 04:28:15 | Moscow, Russia | ||
1920688 | 1920688 | 2020-08-10 | Argentina | 253868 | 4764 | 108242 | 140862 | -38.4161 | -63.6167 | 2020-08-11 04:35:08 | Argentina |
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]);