johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 23631 and province_or_state = "Uttar Pradesh" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3523404 | 3523404 | 2022-11-24 | India | Uttar Pradesh | 2128012 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-25 04:21:06 | Uttar Pradesh, India | |||
3312187 | 3312187 | 2022-11-23 | India | Uttar Pradesh | 2128003 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-24 04:21:09 | Uttar Pradesh, India | |||
1620228 | 1620228 | 2022-11-22 | India | Uttar Pradesh | 2127995 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-23 04:21:06 | Uttar Pradesh, India | |||
3460116 | 3460116 | 2022-11-21 | India | Uttar Pradesh | 2127987 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-22 04:20:47 | Uttar Pradesh, India | |||
1640301 | 1640301 | 2022-11-20 | India | Uttar Pradesh | 2127982 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-21 04:21:05 | Uttar Pradesh, India | |||
2063858 | 2063858 | 2022-11-19 | India | Uttar Pradesh | 2127976 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-20 04:21:08 | Uttar Pradesh, India | |||
1755252 | 1755252 | 2022-11-18 | India | Uttar Pradesh | 2127962 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-19 04:21:14 | Uttar Pradesh, India | |||
3026245 | 3026245 | 2022-11-17 | India | Uttar Pradesh | 2127953 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-18 04:21:15 | Uttar Pradesh, India | |||
2485956 | 2485956 | 2022-11-16 | India | Uttar Pradesh | 2127937 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-17 04:21:11 | Uttar Pradesh, India | |||
291967 | 291967 | 2022-11-15 | India | Uttar Pradesh | 2127925 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-16 04:21:09 | Uttar Pradesh, India | |||
3596997 | 3596997 | 2022-11-14 | India | Uttar Pradesh | 2127904 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-15 04:21:16 | Uttar Pradesh, India | |||
311855 | 311855 | 2022-11-13 | India | Uttar Pradesh | 2127897 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-14 04:21:09 | Uttar Pradesh, India | |||
63016 | 63016 | 2022-11-12 | India | Uttar Pradesh | 2127882 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-13 04:21:14 | Uttar Pradesh, India | |||
2927178 | 2927178 | 2022-11-11 | India | Uttar Pradesh | 2127857 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-12 04:20:41 | Uttar Pradesh, India | |||
2506014 | 2506014 | 2022-11-10 | India | Uttar Pradesh | 2127848 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-11 04:21:22 | Uttar Pradesh, India | |||
2430889 | 2430889 | 2022-11-09 | India | Uttar Pradesh | 2127761 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-10 04:21:16 | Uttar Pradesh, India | |||
479545 | 479545 | 2022-11-08 | India | Uttar Pradesh | 2127761 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-09 04:21:22 | Uttar Pradesh, India | |||
2438695 | 2438695 | 2022-11-07 | India | Uttar Pradesh | 2127761 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-08 04:21:21 | Uttar Pradesh, India | |||
1049793 | 1049793 | 2022-11-06 | India | Uttar Pradesh | 2127761 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-07 04:21:26 | Uttar Pradesh, India | |||
617817 | 617817 | 2022-11-05 | India | Uttar Pradesh | 2127726 | 23631 | 0 | 26.925425 | 80.560982 | 2022-11-06 04:21:24 | Uttar Pradesh, India |
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]);