johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where deaths = 10743 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3222481 | 3222481 | 2022-12-25 | Lebanon | 1222055 | 10743 | 0 | 33.8547 | 35.8623 | 2022-12-26 04:21:06 | Lebanon | ||||
1018395 | 1018395 | 2022-12-24 | Lebanon | 1222055 | 10743 | 0 | 33.8547 | 35.8623 | 2022-12-25 04:21:04 | Lebanon | ||||
690418 | 690418 | 2022-12-23 | Lebanon | 1221874 | 10743 | 0 | 33.8547 | 35.8623 | 2022-12-24 04:21:02 | Lebanon | ||||
2179628 | 2179628 | 2022-12-22 | Lebanon | 1221874 | 10743 | 0 | 33.8547 | 35.8623 | 2022-12-23 04:21:04 | Lebanon | ||||
451432 | 451432 | 2022-12-21 | Lebanon | 1221791 | 10743 | 0 | 33.8547 | 35.8623 | 2022-12-22 04:20:56 | Lebanon | ||||
2951431 | 2951431 | 2022-12-20 | Lebanon | 1221791 | 10743 | 0 | 33.8547 | 35.8623 | 2022-12-21 04:21:03 | Lebanon | ||||
384561 | 384561 | 2022-09-23 | Taiwan* | 6172769 | 10743 | 0 | 23.7 | 121.0 | 2022-09-24 04:21:40 | Taiwan* | ||||
3078001 | 3078001 | 2022-07-04 | India | Madhya Pradesh | 1044819 | 10743 | 0 | 23.541513 | 78.289633 | 2022-07-05 04:20:45 | Madhya Pradesh, India | |||
1767283 | 1767283 | 2022-07-03 | India | Madhya Pradesh | 1044711 | 10743 | 0 | 23.541513 | 78.289633 | 2022-07-04 04:20:54 | Madhya Pradesh, India | |||
3365269 | 3365269 | 2022-07-02 | India | Madhya Pradesh | 1044603 | 10743 | 0 | 23.541513 | 78.289633 | 2022-07-03 04:20:59 | Madhya Pradesh, India | |||
3593279 | 3593279 | 2022-05-23 | Russia | Sverdlovsk Oblast | 443471 | 10743 | 0 | 58.6414755 | 61.8021546 | 2022-05-24 04:20:57 | Sverdlovsk Oblast, Russia | |||
2892634 | 2892634 | 2022-04-21 | Russia | Krasnoyarsk Krai | 363041 | 10743 | 0 | 63.3233807 | 97.09799740000001 | 2022-04-22 04:20:45 | Krasnoyarsk Krai, Russia | |||
1436552 | 1436552 | 2022-03-28 | Italy | Lazio | 1257303 | 10743 | 0 | 41.89277044 | 12.48366722 | 2022-03-29 04:20:46 | Lazio, Italy | |||
603931 | 603931 | 2021-09-23 | US | New York | Kings | 36047 | 319096 | 10743 | 0 | 40.636182500000004 | -73.94935552 | 2021-09-24 04:21:44 | Kings, New York, US | |
1952597 | 1952597 | 2021-05-21 | Mexico | Guanajuato | 131589 | 10743 | 0 | 120846 | 21.019 | -101.2574 | 2021-05-22 04:20:45 | Guanajuato, Mexico | ||
351999 | 351999 | 2021-03-11 | Austria | 477553 | 10743 | 450862 | 25256 | 47.5162 | 14.5501 | 2021-03-12 05:26:50 | Austria | |||
774187 | 774187 | 2021-01-12 | Colombia | Capital District | 525622 | 10743 | 467394 | 47485 | 4.711 | -74.0721 | 2021-01-13 05:22:15 | Capital District, Colombia |
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]);