daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Gujarat" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-18 | India | Gujarat | 120336 | 3286 | 100974 | 16076 | 22.694884 | 71.590923 | 2020-09-19 04:22:00 | Gujarat, India | ||
2020-09-19 | India | Gujarat | 121768 | 3302 | 102444 | 16022 | 22.694884 | 71.590923 | 2020-09-20 04:22:00 | Gujarat, India | ||
2020-09-20 | India | Gujarat | 123175 | 3319 | 103648 | 16208 | 22.694884 | 71.590923 | 2020-09-21 04:23:00 | Gujarat, India | ||
2020-09-21 | India | Gujarat | 124605 | 3336 | 104964 | 16305 | 22.694884 | 71.590923 | 2020-09-22 04:23:00 | Gujarat, India | ||
2020-09-22 | India | Gujarat | 126007 | 3352 | 106285 | 16370 | 22.694884 | 71.590923 | 2020-09-23 04:23:00 | Gujarat, India | ||
2020-09-23 | India | Gujarat | 127379 | 3367 | 107574 | 16438 | 22.694884 | 71.590923 | 2020-09-24 04:23:00 | Gujarat, India | ||
2020-09-24 | India | Gujarat | 128787 | 3381 | 109079 | 16327 | 22.694884 | 71.590923 | 2020-09-25 04:23:00 | Gujarat, India | ||
2020-09-25 | India | Gujarat | 130229 | 3393 | 110358 | 16478 | 22.694884 | 71.590923 | 2020-09-26 04:23:00 | Gujarat, India | ||
2020-09-26 | India | Gujarat | 131646 | 3406 | 111777 | 16463 | 22.694884 | 71.590923 | 2020-09-27 04:23:00 | Gujarat, India | ||
2020-09-27 | India | Gujarat | 133057 | 3416 | 113008 | 16633 | 22.694884 | 71.590923 | 2020-09-28 04:23:00 | Gujarat, India | ||
2020-09-28 | India | Gujarat | 134461 | 3428 | 114344 | 16689 | 22.694884 | 71.590923 | 2020-09-29 04:23:42 | Gujarat, India | ||
2020-09-29 | India | Gujarat | 135842 | 3439 | 115727 | 16676 | 22.694884 | 71.590923 | 2020-09-30 04:23:33 | Gujarat, India | ||
2020-09-30 | India | Gujarat | 137232 | 3450 | 117099 | 16683 | 22.694884 | 71.590923 | 2020-10-01 04:23:42 | Gujarat, India | ||
2020-10-01 | India | Gujarat | 138583 | 3460 | 118433 | 16690 | 22.694884 | 71.590923 | 2020-10-02 04:23:51 | Gujarat, India | ||
2020-10-02 | India | Gujarat | 139893 | 3475 | 119683 | 16735 | 22.694884 | 71.590923 | 2020-10-03 04:23:40 | Gujarat, India | ||
2020-10-03 | India | Gujarat | 141236 | 3487 | 120987 | 16762 | 22.694884 | 71.590923 | 2020-10-04 04:23:44 | Gujarat, India | ||
2020-10-04 | India | Gujarat | 142538 | 3496 | 122233 | 16809 | 22.694884 | 71.590923 | 2020-10-05 04:23:33 | Gujarat, India | ||
2020-10-05 | India | Gujarat | 143865 | 3509 | 123638 | 16718 | 22.694884 | 71.590923 | 2020-10-06 04:23:33 | Gujarat, India | ||
2020-10-06 | India | Gujarat | 145200 | 3519 | 125111 | 16570 | 22.694884 | 71.590923 | 2020-10-07 04:23:40 | Gujarat, India | ||
2020-10-07 | India | Gujarat | 146673 | 3531 | 126657 | 16485 | 22.694884 | 71.590923 | 2020-10-08 04:23:56 | Gujarat, India | ||
2020-10-08 | India | Gujarat | 147789 | 3538 | 127786 | 16465 | 22.694884 | 71.590923 | 2020-10-09 04:23:59 | Gujarat, India | ||
2020-10-09 | India | Gujarat | 149032 | 3547 | 129304 | 16181 | 22.694884 | 71.590923 | 2020-10-10 04:23:57 | Gujarat, India | ||
2020-10-10 | India | Gujarat | 150253 | 3557 | 130760 | 15936 | 22.694884 | 71.590923 | 2020-10-11 04:23:46 | Gujarat, India | ||
2020-10-11 | India | Gujarat | 151434 | 3566 | 132173 | 15695 | 22.694884 | 71.590923 | 2020-10-12 04:23:45 | Gujarat, India | ||
2020-10-12 | India | Gujarat | 152603 | 3574 | 133615 | 15414 | 22.694884 | 71.590923 | 2020-10-13 04:24:02 | Gujarat, India | ||
2020-10-13 | India | Gujarat | 153761 | 3584 | 134990 | 15187 | 22.694884 | 71.590923 | 2020-10-14 04:24:05 | Gujarat, India | ||
2020-10-14 | India | Gujarat | 154936 | 3595 | 136404 | 14937 | 22.694884 | 71.590923 | 2020-10-15 04:24:28 | Gujarat, India | ||
2020-10-15 | India | Gujarat | 156121 | 3606 | 137733 | 14782 | 22.694884 | 71.590923 | 2020-10-16 04:24:01 | Gujarat, India | ||
2020-10-16 | India | Gujarat | 157312 | 3617 | 139012 | 14683 | 22.694884 | 71.590923 | 2020-10-17 04:24:12 | Gujarat, India | ||
2020-10-17 | India | Gujarat | 158473 | 3626 | 140282 | 14565 | 22.694884 | 71.590923 | 2020-10-18 04:24:25 | Gujarat, India | ||
2020-10-18 | India | Gujarat | 159564 | 3635 | 141515 | 14414 | 22.694884 | 71.590923 | 2020-10-19 04:24:16 | Gujarat, India | ||
2020-10-19 | India | Gujarat | 160560 | 3643 | 142662 | 14255 | 22.694884 | 71.590923 | 2020-10-20 04:24:22 | Gujarat, India | ||
2020-10-20 | India | Gujarat | 161686 | 3651 | 143790 | 14245 | 22.694884 | 71.590923 | 2020-10-21 04:24:14 | Gujarat, India | ||
2020-10-21 | India | Gujarat | 162823 | 3660 | 144970 | 14193 | 22.694884 | 71.590923 | 2020-10-22 04:24:27 | Gujarat, India | ||
2020-10-22 | India | Gujarat | 163959 | 3667 | 146171 | 14121 | 22.694884 | 71.590923 | 2020-10-23 04:24:46 | Gujarat, India | ||
2020-10-23 | India | Gujarat | 165071 | 3673 | 147435 | 13963 | 22.694884 | 71.590923 | 2020-10-24 04:24:46 | Gujarat, India | ||
2020-10-24 | India | Gujarat | 166092 | 3679 | 148448 | 13965 | 22.694884 | 71.590923 | 2020-10-25 04:24:36 | Gujarat, India | ||
2020-10-25 | India | Gujarat | 167011 | 3686 | 149411 | 13914 | 22.694884 | 71.590923 | 2020-10-26 04:25:02 | Gujarat, India | ||
2020-10-26 | India | Gujarat | 167919 | 3690 | 150513 | 13716 | 22.694884 | 71.590923 | 2020-10-27 04:24:45 | Gujarat, India | ||
2020-10-27 | India | Gujarat | 168911 | 3695 | 151751 | 13465 | 22.694884 | 71.590923 | 2020-10-28 04:24:39 | Gujarat, India | ||
2020-10-28 | India | Gujarat | 169891 | 3701 | 152858 | 13332 | 22.694884 | 71.590923 | 2020-10-29 04:24:49 | Gujarat, India | ||
2020-10-29 | India | Gujarat | 170878 | 3705 | 153941 | 13232 | 22.694884 | 71.590923 | 2020-10-30 04:24:49 | Gujarat, India | ||
2020-10-30 | India | Gujarat | 171847 | 3711 | 154968 | 13168 | 22.694884 | 71.590923 | 2020-10-31 04:24:44 | Gujarat, India | ||
2020-10-31 | India | Gujarat | 172782 | 3716 | 155982 | 13084 | 22.694884 | 71.590923 | 2020-11-01 04:36:19 | Gujarat, India | ||
2020-11-01 | India | Gujarat | 173642 | 3721 | 157110 | 12811 | 22.694884 | 71.590923 | 2020-11-02 05:25:04 | Gujarat, India | ||
2020-11-02 | India | Gujarat | 174517 | 3725 | 158114 | 12678 | 22.694884 | 71.590923 | 2020-11-03 06:00:16 | Gujarat, India | ||
2020-11-03 | India | Gujarat | 175471 | 3731 | 159311 | 12429 | 22.694884 | 71.590923 | 2020-11-04 05:25:09 | Gujarat, India | ||
2020-11-04 | India | Gujarat | 176446 | 3737 | 160333 | 12376 | 22.694884 | 71.590923 | 2020-11-05 06:05:03 | Gujarat, India | ||
2020-11-05 | India | Gujarat | 177436 | 3744 | 161388 | 12304 | 22.694884 | 71.590923 | 2020-11-06 05:24:55 | Gujarat, India | ||
2020-11-06 | India | Gujarat | 178471 | 3748 | 162709 | 12014 | 22.694884 | 71.590923 | 2020-11-07 05:24:52 | Gujarat, India | ||
2020-11-07 | India | Gujarat | 179517 | 3753 | 163640 | 12124 | 22.694884 | 71.590923 | 2020-11-08 05:24:56 | Gujarat, India | ||
2020-11-08 | India | Gujarat | 180537 | 3760 | 164459 | 12318 | 22.694884 | 71.590923 | 2020-11-09 05:25:45 | Gujarat, India | ||
2020-11-09 | India | Gujarat | 181508 | 3765 | 165452 | 12291 | 22.694884 | 71.590923 | 2020-11-10 05:40:07 | Gujarat, India | ||
2020-11-10 | India | Gujarat | 182557 | 3770 | 166331 | 12456 | 22.694884 | 71.590923 | 2020-11-11 05:25:30 | Gujarat, India | ||
2020-11-11 | India | Gujarat | 183682 | 3776 | 167683 | 12223 | 22.694884 | 71.590923 | 2020-11-12 05:25:55 | Gujarat, India | ||
2020-11-12 | India | Gujarat | 184964 | 3785 | 168858 | 12321 | 22.694884 | 71.590923 | 2020-11-13 05:25:30 | Gujarat, India | ||
2020-11-13 | India | Gujarat | 186116 | 3791 | 169936 | 12389 | 22.694884 | 71.590923 | 2020-11-14 05:25:37 | Gujarat, India | ||
2020-11-14 | India | Gujarat | 187240 | 3797 | 170931 | 12512 | 22.694884 | 71.590923 | 2020-11-15 05:26:53 | Gujarat, India | ||
2020-11-15 | India | Gujarat | 188310 | 3803 | 171932 | 12575 | 22.694884 | 71.590923 | 2020-11-16 05:25:57 | Gujarat, India | ||
2020-11-16 | India | Gujarat | 189236 | 3808 | 172972 | 12456 | 22.694884 | 71.590923 | 2020-11-17 05:25:54 | Gujarat, India | ||
2020-11-17 | India | Gujarat | 190361 | 3815 | 174088 | 12458 | 22.694884 | 71.590923 | 2020-11-18 05:40:31 | Gujarat, India | ||
2020-11-18 | India | Gujarat | 191642 | 3823 | 175362 | 12457 | 22.694884 | 71.590923 | 2020-11-19 05:25:23 | Gujarat, India | ||
2020-11-19 | India | Gujarat | 192982 | 3830 | 176475 | 12677 | 22.694884 | 71.590923 | 2020-11-20 05:26:28 | Gujarat, India | ||
2020-11-20 | India | Gujarat | 194402 | 3837 | 177515 | 13050 | 22.694884 | 71.590923 | 2020-11-21 05:25:51 | Gujarat, India | ||
2020-11-21 | India | Gujarat | 195917 | 3846 | 178786 | 13285 | 22.694884 | 71.590923 | 2020-11-22 05:25:45 | Gujarat, India | ||
2020-11-22 | India | Gujarat | 197412 | 3859 | 179953 | 13600 | 22.694884 | 71.590923 | 2020-11-23 05:25:26 | Gujarat, India | ||
2020-11-23 | India | Gujarat | 198899 | 3876 | 181187 | 13836 | 22.694884 | 71.590923 | 2020-11-24 05:27:31 | Gujarat, India | ||
2020-11-24 | India | Gujarat | 200409 | 3892 | 182473 | 14044 | 22.694884 | 71.590923 | 2020-11-25 05:27:20 | Gujarat, India | ||
2020-11-25 | India | Gujarat | 201949 | 3906 | 183756 | 14287 | 22.694884 | 71.590923 | 2020-11-26 05:27:44 | Gujarat, India | ||
2020-11-26 | India | Gujarat | 203509 | 3922 | 185058 | 14529 | 22.694884 | 71.590923 | 2020-11-27 05:26:53 | Gujarat, India | ||
2020-11-27 | India | Gujarat | 205116 | 3938 | 186446 | 14732 | 22.694884 | 71.590923 | 2020-11-28 05:25:50 | Gujarat, India | ||
2020-11-28 | India | Gujarat | 206714 | 3953 | 187969 | 14792 | 22.694884 | 71.590923 | 2020-11-29 05:25:55 | Gujarat, India | ||
2020-11-29 | India | Gujarat | 208278 | 3969 | 189420 | 14889 | 22.694884 | 71.590923 | 2020-11-30 05:26:13 | Gujarat, India | ||
2020-11-30 | India | Gujarat | 209780 | 3989 | 190821 | 14970 | 22.694884 | 71.590923 | 2020-12-01 05:26:18 | Gujarat, India | ||
2020-12-01 | India | Gujarat | 211257 | 4004 | 192368 | 14885 | 22.694884 | 71.590923 | 2020-12-02 05:27:41 | Gujarat, India | ||
2020-12-02 | India | Gujarat | 212769 | 4018 | 193938 | 14813 | 22.694884 | 71.590923 | 2020-12-03 05:28:22 | Gujarat, India | ||
2020-12-03 | India | Gujarat | 214309 | 4031 | 195365 | 14913 | 22.694884 | 71.590923 | 2020-12-04 05:27:27 | Gujarat, India | ||
2020-12-04 | India | Gujarat | 215819 | 4049 | 196992 | 14778 | 22.694884 | 71.590923 | 2020-12-05 05:27:36 | Gujarat, India | ||
2020-12-05 | India | Gujarat | 217333 | 4064 | 198527 | 14742 | 22.694884 | 71.590923 | 2020-12-06 05:26:18 | Gujarat, India | ||
2020-12-06 | India | Gujarat | 218788 | 4081 | 200012 | 14695 | 22.694884 | 71.590923 | 2020-12-07 05:26:14 | Gujarat, India | ||
2020-12-07 | India | Gujarat | 220168 | 4095 | 201580 | 14493 | 22.694884 | 71.590923 | 2020-12-08 05:27:42 | Gujarat, India | ||
2020-12-08 | India | Gujarat | 221493 | 4110 | 203111 | 14272 | 22.694884 | 71.590923 | 2020-12-09 05:28:01 | Gujarat, India | ||
2020-12-09 | India | Gujarat | 222811 | 4123 | 204661 | 14027 | 22.694884 | 71.590923 | 2020-12-10 05:26:19 | Gujarat, India | ||
2020-12-10 | India | Gujarat | 224081 | 4135 | 206126 | 13820 | 22.694884 | 71.590923 | 2020-12-11 05:26:59 | Gujarat, India | ||
2020-12-11 | India | Gujarat | 225304 | 4148 | 207529 | 13627 | 22.694884 | 71.590923 | 2020-12-12 05:26:19 | Gujarat, India | ||
2020-12-12 | India | Gujarat | 226508 | 4160 | 208867 | 13481 | 22.694884 | 71.590923 | 2020-12-13 05:27:20 | Gujarat, India | ||
2020-12-13 | India | Gujarat | 227683 | 4171 | 210214 | 13298 | 22.694884 | 71.590923 | 2020-12-14 05:26:27 | Gujarat, India | ||
2020-12-14 | India | Gujarat | 228803 | 4182 | 211603 | 13018 | 22.694884 | 71.590923 | 2020-12-15 05:26:38 | Gujarat, India | ||
2020-12-15 | India | Gujarat | 229913 | 4193 | 212839 | 12881 | 22.694884 | 71.590923 | 2020-12-16 05:28:04 | Gujarat, India | ||
2020-12-16 | India | Gujarat | 231073 | 4203 | 214223 | 12647 | 22.694884 | 71.590923 | 2020-12-17 05:28:12 | Gujarat, India | ||
2020-12-17 | India | Gujarat | 232188 | 4211 | 215528 | 12449 | 22.694884 | 71.590923 | 2020-12-18 05:28:18 | Gujarat, India | ||
2020-12-18 | India | Gujarat | 233263 | 4220 | 216683 | 12360 | 22.694884 | 71.590923 | 2020-12-19 05:27:52 | Gujarat, India | ||
2020-12-19 | India | Gujarat | 234289 | 4227 | 217935 | 12127 | 22.694884 | 71.590923 | 2020-12-20 05:27:32 | Gujarat, India | ||
2020-12-20 | India | Gujarat | 235299 | 4234 | 219125 | 11940 | 22.694884 | 71.590923 | 2020-12-21 05:27:58 | Gujarat, India | ||
2020-12-21 | India | Gujarat | 236259 | 4241 | 220393 | 11625 | 22.694884 | 71.590923 | 2020-12-22 05:22:33 | Gujarat, India | ||
2020-12-22 | India | Gujarat | 237247 | 4248 | 221602 | 11397 | 22.694884 | 71.590923 | 2020-12-23 05:22:03 | Gujarat, India | ||
2020-12-23 | India | Gujarat | 238205 | 4254 | 222911 | 11040 | 22.694884 | 71.590923 | 2020-12-24 05:23:04 | Gujarat, India | ||
2020-12-24 | India | Gujarat | 239195 | 4262 | 224092 | 10841 | 22.694884 | 71.590923 | 2020-12-25 05:22:48 | Gujarat, India | ||
2020-12-25 | India | Gujarat | 240105 | 4268 | 225206 | 10631 | 22.694884 | 71.590923 | 2020-12-26 05:22:28 | Gujarat, India | ||
2020-12-26 | India | Gujarat | 240995 | 4275 | 226208 | 10512 | 22.694884 | 71.590923 | 2020-12-27 05:22:55 | Gujarat, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;