johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where country_or_region = "Malaysia", deaths = 193 and province_or_state = "Perlis" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
833689 | 833689 | 2022-12-02 | Malaysia | Perlis | 18817 | 193 | 0 | 6.4449 | 100.2048 | 2022-12-03 04:21:02 | Perlis, Malaysia | |||
2136219 | 2136219 | 2022-12-01 | Malaysia | Perlis | 18802 | 193 | 0 | 6.4449 | 100.2048 | 2022-12-02 04:21:07 | Perlis, Malaysia | |||
1964635 | 1964635 | 2022-11-30 | Malaysia | Perlis | 18797 | 193 | 0 | 6.4449 | 100.2048 | 2022-12-01 04:21:03 | Perlis, Malaysia | |||
2556649 | 2556649 | 2022-11-29 | Malaysia | Perlis | 18789 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-30 04:21:07 | Perlis, Malaysia | |||
1239723 | 1239723 | 2022-11-28 | Malaysia | Perlis | 18786 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-29 04:21:05 | Perlis, Malaysia | |||
3551711 | 3551711 | 2022-11-27 | Malaysia | Perlis | 18778 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-28 04:21:02 | Perlis, Malaysia | |||
2100191 | 2100191 | 2022-11-26 | Malaysia | Perlis | 18770 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-27 04:21:05 | Perlis, Malaysia | |||
487682 | 487682 | 2022-11-25 | Malaysia | Perlis | 18761 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-26 04:21:11 | Perlis, Malaysia | |||
3523511 | 3523511 | 2022-11-24 | Malaysia | Perlis | 18754 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-25 04:21:06 | Perlis, Malaysia | |||
3312294 | 3312294 | 2022-11-23 | Malaysia | Perlis | 18745 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-24 04:21:09 | Perlis, Malaysia | |||
1620335 | 1620335 | 2022-11-22 | Malaysia | Perlis | 18736 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-23 04:21:06 | Perlis, Malaysia | |||
3460223 | 3460223 | 2022-11-21 | Malaysia | Perlis | 18731 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-22 04:20:47 | Perlis, Malaysia | |||
1640408 | 1640408 | 2022-11-20 | Malaysia | Perlis | 18729 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-21 04:21:05 | Perlis, Malaysia | |||
2063965 | 2063965 | 2022-11-19 | Malaysia | Perlis | 18726 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-20 04:21:08 | Perlis, Malaysia | |||
1755359 | 1755359 | 2022-11-18 | Malaysia | Perlis | 18720 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-19 04:21:14 | Perlis, Malaysia | |||
3026352 | 3026352 | 2022-11-17 | Malaysia | Perlis | 18711 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-18 04:21:15 | Perlis, Malaysia | |||
2486063 | 2486063 | 2022-11-16 | Malaysia | Perlis | 18707 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-17 04:21:11 | Perlis, Malaysia | |||
292074 | 292074 | 2022-11-15 | Malaysia | Perlis | 18687 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-16 04:21:09 | Perlis, Malaysia | |||
3597104 | 3597104 | 2022-11-14 | Malaysia | Perlis | 18684 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-15 04:21:16 | Perlis, Malaysia | |||
311962 | 311962 | 2022-11-13 | Malaysia | Perlis | 18679 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-14 04:21:09 | Perlis, Malaysia | |||
63123 | 63123 | 2022-11-12 | Malaysia | Perlis | 18676 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-13 04:21:14 | Perlis, Malaysia | |||
2927285 | 2927285 | 2022-11-11 | Malaysia | Perlis | 18672 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-12 04:20:41 | Perlis, Malaysia | |||
2506121 | 2506121 | 2022-11-10 | Malaysia | Perlis | 18655 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-11 04:21:22 | Perlis, Malaysia | |||
2430996 | 2430996 | 2022-11-09 | Malaysia | Perlis | 18644 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-10 04:21:16 | Perlis, Malaysia | |||
479652 | 479652 | 2022-11-08 | Malaysia | Perlis | 18639 | 193 | 0 | 6.4449 | 100.2048 | 2022-11-09 04:21:22 | Perlis, Malaysia |
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]);