johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where deaths = 6 and province_or_state = "W.P. Putrajaya" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1531586 | 1531586 | 2021-02-09 | Malaysia | W.P. Putrajaya | 972 | 6 | 834 | 132 | 2.9264 | 101.6964 | 2021-02-10 05:22:41 | W.P. Putrajaya, Malaysia | ||
617377 | 617377 | 2021-02-08 | Malaysia | W.P. Putrajaya | 962 | 6 | 812 | 144 | 2.9264 | 101.6964 | 2021-02-09 05:23:30 | W.P. Putrajaya, Malaysia | ||
1676146 | 1676146 | 2021-02-07 | Malaysia | W.P. Putrajaya | 954 | 6 | 809 | 139 | 2.9264 | 101.6964 | 2021-02-08 05:22:39 | W.P. Putrajaya, Malaysia | ||
978607 | 978607 | 2021-02-06 | Malaysia | W.P. Putrajaya | 945 | 6 | 784 | 155 | 2.9264 | 101.6964 | 2021-02-07 05:23:00 | W.P. Putrajaya, Malaysia | ||
1591865 | 1591865 | 2021-02-05 | Malaysia | W.P. Putrajaya | 937 | 6 | 775 | 156 | 2.9264 | 101.6964 | 2021-02-06 05:23:55 | W.P. Putrajaya, Malaysia | ||
794072 | 794072 | 2021-02-04 | Malaysia | W.P. Putrajaya | 931 | 6 | 769 | 156 | 2.9264 | 101.6964 | 2021-02-05 05:22:38 | W.P. Putrajaya, Malaysia | ||
343964 | 343964 | 2021-02-03 | Malaysia | W.P. Putrajaya | 911 | 6 | 756 | 149 | 2.9264 | 101.6964 | 2021-02-04 05:22:26 | W.P. Putrajaya, Malaysia | ||
1688190 | 1688190 | 2021-02-02 | Malaysia | W.P. Putrajaya | 897 | 6 | 739 | 152 | 2.9264 | 101.6964 | 2021-02-03 05:22:52 | W.P. Putrajaya, Malaysia | ||
1680160 | 1680160 | 2021-02-01 | Malaysia | W.P. Putrajaya | 891 | 6 | 718 | 167 | 2.9264 | 101.6964 | 2021-02-02 05:22:49 | W.P. Putrajaya, Malaysia | ||
1463448 | 1463448 | 2021-01-31 | Malaysia | W.P. Putrajaya | 881 | 6 | 693 | 182 | 2.9264 | 101.6964 | 2021-02-01 05:22:53 | W.P. Putrajaya, Malaysia | ||
2215356 | 2215356 | 2021-01-30 | Malaysia | W.P. Putrajaya | 875 | 6 | 641 | 228 | 2.9264 | 101.6964 | 2021-01-31 05:22:42 | W.P. Putrajaya, Malaysia | ||
1900843 | 1900843 | 2021-01-29 | Malaysia | W.P. Putrajaya | 863 | 6 | 619 | 238 | 2.9264 | 101.6964 | 2021-01-30 05:22:49 | W.P. Putrajaya, Malaysia | ||
2485659 | 2485659 | 2021-01-28 | Malaysia | W.P. Putrajaya | 847 | 6 | 594 | 247 | 2.9264 | 101.6964 | 2021-01-29 05:22:23 | W.P. Putrajaya, Malaysia | ||
3157294 | 3157294 | 2021-01-27 | Malaysia | W.P. Putrajaya | 837 | 6 | 546 | 285 | 2.9264 | 101.6964 | 2021-01-28 05:22:24 | W.P. Putrajaya, Malaysia | ||
16029 | 16029 | 2021-01-26 | Malaysia | W.P. Putrajaya | 818 | 6 | 527 | 285 | 2.9264 | 101.6964 | 2021-01-27 05:23:41 | W.P. Putrajaya, Malaysia | ||
2571353 | 2571353 | 2021-01-25 | Malaysia | W.P. Putrajaya | 803 | 6 | 492 | 305 | 2.9264 | 101.6964 | 2021-01-26 05:22:02 | W.P. Putrajaya, Malaysia | ||
1762985 | 1762985 | 2021-01-24 | Malaysia | W.P. Putrajaya | 781 | 6 | 478 | 297 | 2.9264 | 101.6964 | 2021-01-25 05:22:16 | W.P. Putrajaya, Malaysia | ||
2430592 | 2430592 | 2021-01-23 | Malaysia | W.P. Putrajaya | 743 | 6 | 456 | 281 | 2.9264 | 101.6964 | 2021-01-24 05:22:35 | W.P. Putrajaya, Malaysia | ||
2470494 | 2470494 | 2021-01-22 | Malaysia | W.P. Putrajaya | 708 | 6 | 443 | 259 | 2.9264 | 101.6964 | 2021-01-23 05:22:03 | W.P. Putrajaya, Malaysia | ||
439045 | 439045 | 2021-01-21 | Malaysia | W.P. Putrajaya | 669 | 6 | 413 | 250 | 2.9264 | 101.6964 | 2021-01-22 05:22:10 | W.P. Putrajaya, Malaysia | ||
1097776 | 1097776 | 2021-01-20 | Malaysia | W.P. Putrajaya | 636 | 6 | 398 | 232 | 2.9264 | 101.6964 | 2021-01-21 05:22:01 | W.P. Putrajaya, Malaysia | ||
911866 | 911866 | 2021-01-19 | Malaysia | W.P. Putrajaya | 613 | 6 | 392 | 215 | 2.9264 | 101.6964 | 2021-01-20 05:21:54 | W.P. Putrajaya, Malaysia | ||
240929 | 240929 | 2021-01-18 | Malaysia | W.P. Putrajaya | 587 | 6 | 362 | 219 | 2.9264 | 101.6964 | 2021-01-19 05:22:15 | W.P. Putrajaya, Malaysia | ||
3507046 | 3507046 | 2021-01-17 | Malaysia | W.P. Putrajaya | 572 | 6 | 353 | 213 | 2.9264 | 101.6964 | 2021-01-18 05:22:34 | W.P. Putrajaya, Malaysia | ||
3105129 | 3105129 | 2021-01-16 | Malaysia | W.P. Putrajaya | 549 | 6 | 340 | 203 | 2.9264 | 101.6964 | 2021-01-17 05:22:17 | W.P. Putrajaya, Malaysia | ||
3519091 | 3519091 | 2021-01-15 | Malaysia | W.P. Putrajaya | 514 | 6 | 328 | 180 | 2.9264 | 101.6964 | 2021-01-16 05:22:40 | W.P. Putrajaya, Malaysia | ||
3883263 | 3883263 | 2021-01-14 | Malaysia | W.P. Putrajaya | 490 | 6 | 306 | 178 | 2.9264 | 101.6964 | 2021-01-15 05:22:24 | W.P. Putrajaya, 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]);