johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where deaths = 6345 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2431033 | 2431033 | 2022-11-09 | Mexico | Queretaro | 177374 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-10 04:21:16 | Queretaro, Mexico | |||
479689 | 479689 | 2022-11-08 | Mexico | Queretaro | 177349 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-09 04:21:22 | Queretaro, Mexico | |||
2438839 | 2438839 | 2022-11-07 | Mexico | Queretaro | 177349 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-08 04:21:21 | Queretaro, Mexico | |||
1049935 | 1049935 | 2022-11-06 | Mexico | Oaxaca | 149851 | 6345 | 0 | 17.0732 | -96.7266 | 2022-11-07 04:21:26 | Oaxaca, Mexico | |||
617959 | 617959 | 2022-11-05 | Mexico | Oaxaca | 149851 | 6345 | 0 | 17.0732 | -96.7266 | 2022-11-06 04:21:24 | Oaxaca, Mexico | |||
1022463 | 1022463 | 2022-11-04 | Mexico | Oaxaca | 149851 | 6345 | 0 | 17.0732 | -96.7266 | 2022-11-05 04:21:52 | Oaxaca, Mexico | |||
3798060 | 3798060 | 2022-08-20 | Pakistan | Khyber Pakhtunkhwa | 222883 | 6345 | 0 | 34.485332 | 72.09169 | 2022-08-21 04:20:44 | Khyber Pakhtunkhwa, Pakistan | |||
2147977 | 2147977 | 2022-06-27 | Taiwan* | 3641921 | 6345 | 0 | 23.7 | 121.0 | 2022-06-28 04:20:58 | Taiwan* | ||||
3895699 | 3895699 | 2022-05-19 | Brazil | Sergipe | 327284 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-20 04:20:57 | Sergipe, Brazil | |||
1184483 | 1184483 | 2022-05-18 | Brazil | Sergipe | 327284 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-19 04:20:54 | Sergipe, Brazil | |||
3582380 | 3582380 | 2022-05-17 | Brazil | Sergipe | 327284 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-18 04:20:50 | Sergipe, Brazil | |||
1503337 | 1503337 | 2022-05-16 | Brazil | Sergipe | 327284 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-17 04:20:59 | Sergipe, Brazil | |||
2083696 | 2083696 | 2022-05-15 | Brazil | Sergipe | 327271 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-16 04:20:47 | Sergipe, Brazil | |||
3354407 | 3354407 | 2022-05-14 | Brazil | Sergipe | 327254 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-15 04:20:53 | Sergipe, Brazil | |||
658052 | 658052 | 2022-05-13 | Brazil | Sergipe | 327238 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-14 04:20:48 | Sergipe, Brazil | |||
2533135 | 2533135 | 2022-05-12 | Brazil | Sergipe | 327218 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-13 04:20:51 | Sergipe, Brazil | |||
3444581 | 3444581 | 2022-05-11 | Brazil | Sergipe | 327198 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-12 04:20:54 | Sergipe, Brazil | |||
3535198 | 3535198 | 2022-05-10 | Brazil | Sergipe | 327179 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-11 04:20:48 | Sergipe, Brazil | |||
221733 | 221733 | 2022-05-09 | Brazil | Sergipe | 327167 | 6345 | 0 | -10.5741 | -37.3857 | 2022-05-10 04:20:50 | Sergipe, Brazil | |||
2076046 | 2076046 | 2021-09-26 | Mexico | San Luis Potosi | 98396 | 6345 | 0 | 22.1565 | -100.9855 | 2021-09-27 04:21:16 | San Luis Potosi, Mexico | |||
1305904 | 1305904 | 2021-07-27 | Brazil | Rondonia | 257053 | 6345 | 245126 | 5582 | -11.5057 | -63.5806 | 2021-07-28 04:21:39 | Rondonia, Brazil | ||
2393874 | 2393874 | 2021-05-18 | US | Texas | Harris | 48201 | 465941 | 6345 | 0 | 29.85864939 | -95.39339521 | 2021-05-19 04:20:42 | Harris, Texas, US | |
2020700 | 2020700 | 2021-04-20 | Israel | 837357 | 6345 | 828902 | 2110 | 31.046051 | 34.851612 | 2021-04-21 04:21:14 | Israel | |||
605788 | 605788 | 2021-04-09 | Mexico | Sonora | 71262 | 6345 | 0 | 64917 | 29.2972 | -110.3309 | 2021-04-10 04:20:59 | Sonora, Mexico | ||
998730 | 998730 | 2021-03-01 | Spain | Castilla y Leon | 206184 | 6345 | 8716 | 191123 | 41.8357 | -4.3976 | 2021-03-02 05:23:30 | Castilla y Leon, Spain | ||
1751594 | 1751594 | 2020-12-14 | Switzerland | 384557 | 6345 | 308300 | 69912 | 46.8182 | 8.2275 | 2020-12-15 05:26:38 | Switzerland |
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]);