johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where deaths = 4407 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 11
- India 4
- Italy 4
- Lithuania 2
- Peru 2
- Russia 2
- Costa Rica 1
- Germany 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3206160 | 3206160 | 2022-04-11 | Germany | Berlin | 945480 | 4407 | 0 | 52.52 | 13.405 | 2022-04-12 04:20:49 | Berlin, Germany | |||
2474683 | 2474683 | 2022-02-03 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-02-04 04:21:10 | Palm Beach, Florida, US | |
460108 | 460108 | 2022-02-02 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-02-03 04:21:21 | Palm Beach, Florida, US | |
979677 | 979677 | 2022-02-01 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-02-02 04:21:09 | Palm Beach, Florida, US | |
2658519 | 2658519 | 2022-01-31 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-02-01 04:21:11 | Palm Beach, Florida, US | |
3300936 | 3300936 | 2022-01-30 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-01-31 04:21:09 | Palm Beach, Florida, US | |
3062727 | 3062727 | 2022-01-29 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-01-30 04:21:26 | Palm Beach, Florida, US | |
3810661 | 3810661 | 2022-01-28 | US | Florida | Palm Beach | 12099 | 350714 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-01-29 04:21:10 | Palm Beach, Florida, US | |
1780115 | 1780115 | 2022-01-27 | US | Florida | Palm Beach | 12099 | 342003 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-01-28 04:21:09 | Palm Beach, Florida, US | |
1318943 | 1318943 | 2022-01-26 | US | Florida | Palm Beach | 12099 | 342003 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-01-27 04:21:19 | Palm Beach, Florida, US | |
2052611 | 2052611 | 2022-01-25 | US | Florida | Palm Beach | 12099 | 342003 | 4407 | 0 | 26.64676272 | -80.46536002 | 2022-01-26 04:21:07 | Palm Beach, Florida, US | |
1227581 | 1227581 | 2022-01-24 | Italy | Friuli Venezia Giulia | 241016 | 4407 | 0 | 45.6494354 | 13.76813649 | 2022-01-25 04:21:05 | Friuli Venezia Giulia, Italy | |||
2777185 | 2777185 | 2021-12-31 | Russia | Bashkortostan Republic | 121732 | 4407 | 0 | 54.8573563 | 57.1439682 | 2022-01-01 04:22:14 | Bashkortostan Republic, Russia | |||
1664680 | 1664680 | 2021-12-11 | Russia | Penza Oblast | 95748 | 4407 | 0 | 53.1655415 | 44.78791810000001 | 2021-12-12 04:22:12 | Penza Oblast, Russia | |||
2123877 | 2123877 | 2021-10-21 | Netherlands | Zuid-Holland | 495241 | 4407 | 0 | 51.937835 | 4.462114 | 2021-10-22 04:21:14 | Zuid-Holland, Netherlands | |||
1235615 | 1235615 | 2021-09-27 | Italy | Liguria | 112445 | 4407 | 0 | 44.41149315 | 8.9326992 | 2021-09-28 04:21:28 | Liguria, Italy | |||
2075916 | 2075916 | 2021-09-26 | Italy | Liguria | 112442 | 4407 | 0 | 44.41149315 | 8.9326992 | 2021-09-27 04:21:16 | Liguria, Italy | |||
1724468 | 1724468 | 2021-09-25 | Italy | Liguria | 112353 | 4407 | 0 | 44.41149315 | 8.9326992 | 2021-09-26 04:21:29 | Liguria, Italy | |||
1775306 | 1775306 | 2021-08-30 | India | Jammu and Kashmir | 325253 | 4407 | 0 | 33.75943 | 76.612638 | 2021-08-31 04:21:46 | Jammu and Kashmir, India | |||
3891880 | 3891880 | 2021-08-29 | India | Jammu and Kashmir | 325148 | 4407 | 0 | 33.75943 | 76.612638 | 2021-08-30 04:21:23 | Jammu and Kashmir, India | |||
408358 | 408358 | 2021-07-28 | Lithuania | 282025 | 4407 | 268834 | 8383 | 55.1694 | 23.8813 | 2021-07-29 04:21:33 | Lithuania | |||
1306219 | 1306219 | 2021-07-27 | Lithuania | 281677 | 4407 | 268769 | 8104 | 55.1694 | 23.8813 | 2021-07-28 04:21:39 | Lithuania | |||
2339265 | 2339265 | 2021-06-15 | Costa Rica | 345312 | 4407 | 265255 | 75650 | 9.7489 | -83.7534 | 2021-06-16 04:22:32 | Costa Rica | |||
3393958 | 3393958 | 2021-04-28 | US | California | Riverside | 6065 | 300583 | 4407 | 0 | 33.74314981 | -115.9933578 | 2021-04-29 04:20:55 | Riverside, California, US | |
1302213 | 1302213 | 2021-04-01 | Peru | Junin | 50720 | 4407 | 0 | 46313 | -11.541783 | -74.876968 | 2021-04-02 04:20:36 | Junin, Peru | ||
2055835 | 2055835 | 2021-03-15 | India | Kerala | 1092324 | 4407 | 1060560 | 27357 | 10.450898 | 76.405749 | 2021-03-16 05:25:13 | Kerala, India | ||
280129 | 280129 | 2021-02-24 | India | Gujarat | 268147 | 4407 | 261871 | 1869 | 22.694884 | 71.590923 | 2021-02-25 05:24:57 | Gujarat, India | ||
3480470 | 3480470 | 2020-10-26 | Peru | La Libertad | 32263 | 4407 | 0 | 27856 | -7.92139 | -78.370238 | 2020-10-27 04:24:45 | La Libertad, Peru |
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]);