daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where deaths = 1 and province_or_state = "Lakshadweep" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-04-28 | India | Lakshadweep | 2401 | 1 | 1198 | 1202 | 13.6999972 | 72.18333259999999 | 2021-04-29 04:20:55 | Lakshadweep, India | ||
2021-04-27 | India | Lakshadweep | 2247 | 1 | 1067 | 1179 | 13.6999972 | 72.18333259999999 | 2021-04-28 04:20:32 | Lakshadweep, India | ||
2021-04-26 | India | Lakshadweep | 2126 | 1 | 947 | 1178 | 13.6999972 | 72.18333259999999 | 2021-04-27 04:20:52 | Lakshadweep, India | ||
2021-04-25 | India | Lakshadweep | 2126 | 1 | 947 | 1178 | 13.6999972 | 72.18333259999999 | 2021-04-26 04:21:04 | Lakshadweep, India | ||
2021-04-24 | India | Lakshadweep | 1962 | 1 | 917 | 1044 | 13.6999972 | 72.18333259999999 | 2021-04-25 04:20:32 | Lakshadweep, India | ||
2021-04-23 | India | Lakshadweep | 1805 | 1 | 884 | 920 | 13.6999972 | 72.18333259999999 | 2021-04-24 04:20:38 | Lakshadweep, India | ||
2021-04-22 | India | Lakshadweep | 1671 | 1 | 867 | 803 | 13.6999972 | 72.18333259999999 | 2021-04-23 04:20:52 | Lakshadweep, India | ||
2021-04-21 | India | Lakshadweep | 1335 | 1 | 833 | 501 | 13.6999972 | 72.18333259999999 | 2021-04-22 04:20:53 | Lakshadweep, India | ||
2021-04-20 | India | Lakshadweep | 1335 | 1 | 817 | 517 | 13.6999972 | 72.18333259999999 | 2021-04-21 04:21:14 | Lakshadweep, India | ||
2021-04-19 | India | Lakshadweep | 1165 | 1 | 774 | 390 | 13.6999972 | 72.18333259999999 | 2021-04-20 04:20:41 | Lakshadweep, India | ||
2021-04-18 | India | Lakshadweep | 1051 | 1 | 770 | 280 | 13.6999972 | 72.18333259999999 | 2021-04-19 04:20:57 | Lakshadweep, India | ||
2021-04-17 | India | Lakshadweep | 945 | 1 | 765 | 179 | 13.6999972 | 72.18333259999999 | 2021-04-18 04:20:41 | Lakshadweep, India | ||
2021-04-16 | India | Lakshadweep | 945 | 1 | 765 | 179 | 13.6999972 | 72.18333259999999 | 2021-04-17 04:20:40 | Lakshadweep, India | ||
2021-04-15 | India | Lakshadweep | 901 | 1 | 754 | 146 | 13.6999972 | 72.18333259999999 | 2021-04-16 04:20:46 | Lakshadweep, India | ||
2021-04-14 | India | Lakshadweep | 845 | 1 | 746 | 98 | 13.6999972 | 72.18333259999999 | 2021-04-15 04:20:54 | Lakshadweep, India | ||
2021-04-13 | India | Lakshadweep | 833 | 1 | 746 | 86 | 13.6999972 | 72.18333259999999 | 2021-04-14 04:20:41 | Lakshadweep, India | ||
2021-04-12 | India | Lakshadweep | 813 | 1 | 737 | 75 | 13.6999972 | 72.18333259999999 | 2021-04-13 04:20:37 | Lakshadweep, India | ||
2021-04-11 | India | Lakshadweep | 799 | 1 | 736 | 62 | 13.6999972 | 72.18333259999999 | 2021-04-12 04:21:00 | Lakshadweep, India | ||
2021-04-10 | India | Lakshadweep | 794 | 1 | 733 | 60 | 13.6999972 | 72.18333259999999 | 2021-04-11 04:20:56 | Lakshadweep, India | ||
2021-04-09 | India | Lakshadweep | 784 | 1 | 728 | 55 | 13.6999972 | 72.18333259999999 | 2021-04-10 04:20:59 | Lakshadweep, India | ||
2021-04-08 | India | Lakshadweep | 778 | 1 | 719 | 58 | 13.6999972 | 72.18333259999999 | 2021-04-09 04:21:13 | Lakshadweep, India | ||
2021-04-07 | India | Lakshadweep | 770 | 1 | 716 | 53 | 13.6999972 | 72.18333259999999 | 2021-04-08 04:21:13 | Lakshadweep, India | ||
2021-04-06 | India | Lakshadweep | 751 | 1 | 712 | 38 | 13.6999972 | 72.18333259999999 | 2021-04-07 04:20:53 | Lakshadweep, India | ||
2021-04-05 | India | Lakshadweep | 744 | 1 | 712 | 31 | 13.6999972 | 72.18333259999999 | 2021-04-06 04:20:32 | Lakshadweep, India | ||
2021-04-04 | India | Lakshadweep | 741 | 1 | 704 | 36 | 13.6999972 | 72.18333259999999 | 2021-04-05 04:20:35 | Lakshadweep, India | ||
2021-04-03 | India | Lakshadweep | 740 | 1 | 701 | 38 | 13.6999972 | 72.18333259999999 | 2021-04-04 04:20:49 | Lakshadweep, India | ||
2021-04-02 | India | Lakshadweep | 733 | 1 | 690 | 42 | 13.6999972 | 72.18333259999999 | 2021-04-03 04:20:44 | Lakshadweep, India | ||
2021-04-01 | India | Lakshadweep | 726 | 1 | 688 | 37 | 13.6999972 | 72.18333259999999 | 2021-04-02 04:20:36 | Lakshadweep, India | ||
2021-03-31 | India | Lakshadweep | 723 | 1 | 680 | 42 | 13.6999972 | 72.18333259999999 | 2021-04-01 04:27:05 | Lakshadweep, India | ||
2021-03-30 | India | Lakshadweep | 718 | 1 | 678 | 39 | 13.6999972 | 72.18333259999999 | 2021-03-31 04:26:25 | Lakshadweep, India | ||
2021-03-29 | India | Lakshadweep | 715 | 1 | 669 | 45 | 13.6999972 | 72.18333259999999 | 2021-03-30 04:26:23 | Lakshadweep, India | ||
2021-03-28 | India | Lakshadweep | 715 | 1 | 657 | 57 | 13.6999972 | 72.18333259999999 | 2021-03-29 04:28:35 | Lakshadweep, India | ||
2021-03-27 | India | Lakshadweep | 714 | 1 | 625 | 88 | 13.6999972 | 72.18333259999999 | 2021-03-28 05:28:10 | Lakshadweep, India | ||
2021-03-26 | India | Lakshadweep | 714 | 1 | 614 | 99 | 13.6999972 | 72.18333259999999 | 2021-03-27 05:25:04 | Lakshadweep, India | ||
2021-03-25 | India | Lakshadweep | 708 | 1 | 596 | 111 | 13.6999972 | 72.18333259999999 | 2021-03-26 05:26:55 | Lakshadweep, India | ||
2021-03-24 | India | Lakshadweep | 697 | 1 | 592 | 104 | 13.6999972 | 72.18333259999999 | 2021-03-25 05:27:00 | Lakshadweep, India | ||
2021-03-23 | India | Lakshadweep | 697 | 1 | 592 | 104 | 13.6999972 | 72.18333259999999 | 2021-03-24 05:25:40 | Lakshadweep, India | ||
2021-03-22 | India | Lakshadweep | 691 | 1 | 581 | 109 | 13.6999972 | 72.18333259999999 | 2021-03-23 05:26:18 | Lakshadweep, India | ||
2021-03-21 | India | Lakshadweep | 666 | 1 | 536 | 129 | 13.6999972 | 72.18333259999999 | 2021-03-22 05:25:43 | Lakshadweep, India | ||
2021-03-20 | India | Lakshadweep | 648 | 1 | 511 | 136 | 13.6999972 | 72.18333259999999 | 2021-03-21 05:25:44 | Lakshadweep, India | ||
2021-03-19 | India | Lakshadweep | 647 | 1 | 489 | 157 | 13.6999972 | 72.18333259999999 | 2021-03-20 05:25:46 | Lakshadweep, India | ||
2021-03-18 | India | Lakshadweep | 644 | 1 | 470 | 173 | 13.6999972 | 72.18333259999999 | 2021-03-19 05:26:09 | Lakshadweep, India | ||
2021-03-17 | India | Lakshadweep | 639 | 1 | 459 | 179 | 13.6999972 | 72.18333259999999 | 2021-03-18 05:26:22 | Lakshadweep, India | ||
2021-03-16 | India | Lakshadweep | 625 | 1 | 457 | 167 | 13.6999972 | 72.18333259999999 | 2021-03-17 05:25:07 | Lakshadweep, India | ||
2021-03-15 | India | Lakshadweep | 606 | 1 | 416 | 189 | 13.6999972 | 72.18333259999999 | 2021-03-16 05:25:13 | Lakshadweep, India | ||
2021-03-14 | India | Lakshadweep | 604 | 1 | 400 | 203 | 13.6999972 | 72.18333259999999 | 2021-03-15 05:25:51 | Lakshadweep, India | ||
2021-03-13 | India | Lakshadweep | 603 | 1 | 394 | 208 | 13.6999972 | 72.18333259999999 | 2021-03-14 05:25:37 | Lakshadweep, India | ||
2021-03-12 | India | Lakshadweep | 587 | 1 | 380 | 206 | 13.6999972 | 72.18333259999999 | 2021-03-13 05:25:15 | Lakshadweep, India | ||
2021-03-11 | India | Lakshadweep | 569 | 1 | 374 | 194 | 13.6999972 | 72.18333259999999 | 2021-03-12 05:26:50 | Lakshadweep, India | ||
2021-03-10 | India | Lakshadweep | 524 | 1 | 355 | 168 | 13.6999972 | 72.18333259999999 | 2021-03-11 05:25:48 | Lakshadweep, India | ||
2021-03-09 | India | Lakshadweep | 509 | 1 | 341 | 167 | 13.6999972 | 72.18333259999999 | 2021-03-10 05:24:35 | Lakshadweep, India | ||
2021-03-08 | India | Lakshadweep | 494 | 1 | 329 | 164 | 13.6999972 | 72.18333259999999 | 2021-03-09 05:28:19 | Lakshadweep, India | ||
2021-03-07 | India | Lakshadweep | 486 | 1 | 327 | 158 | 13.6999972 | 72.18333259999999 | 2021-03-08 05:24:48 | Lakshadweep, India | ||
2021-03-06 | India | Lakshadweep | 473 | 1 | 313 | 159 | 13.6999972 | 72.18333259999999 | 2021-03-07 05:21:54 | Lakshadweep, India | ||
2021-03-05 | India | Lakshadweep | 425 | 1 | 309 | 115 | 13.6999972 | 72.18333259999999 | 2021-03-06 04:23:41 | Lakshadweep, India | ||
2021-03-04 | India | Lakshadweep | 425 | 1 | 309 | 115 | 13.6999972 | 72.18333259999999 | 2021-03-05 05:26:29 | Lakshadweep, India | ||
2021-03-03 | India | Lakshadweep | 414 | 1 | 285 | 128 | 13.6999972 | 72.18333259999999 | 2021-03-04 05:24:24 | Lakshadweep, India | ||
2021-03-02 | India | Lakshadweep | 407 | 1 | 269 | 137 | 13.6999972 | 72.18333259999999 | 2021-03-03 05:23:28 | Lakshadweep, India | ||
2021-03-01 | India | Lakshadweep | 397 | 1 | 268 | 128 | 13.6999972 | 72.18333259999999 | 2021-03-02 05:23:30 | Lakshadweep, India | ||
2021-02-28 | India | Lakshadweep | 382 | 1 | 261 | 120 | 13.6999972 | 72.18333259999999 | 2021-03-01 05:23:01 | Lakshadweep, India | ||
2021-02-27 | India | Lakshadweep | 359 | 1 | 260 | 98 | 13.6999972 | 72.18333259999999 | 2021-02-28 05:22:20 | Lakshadweep, India | ||
2021-02-26 | India | Lakshadweep | 333 | 1 | 252 | 80 | 13.6999972 | 72.18333259999999 | 2021-02-27 05:22:28 | Lakshadweep, India | ||
2021-02-25 | India | Lakshadweep | 331 | 1 | 244 | 86 | 13.6999972 | 72.18333259999999 | 2021-02-26 05:22:40 | Lakshadweep, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;