johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Gujarat" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714396 | 714396 | 2021-11-12 | India | Gujarat | 826887 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-13 04:21:38 | Gujarat, India | |||
718413 | 718413 | 2022-12-04 | India | Gujarat | 1277464 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-05 04:20:58 | Gujarat, India | |||
722428 | 722428 | 2021-11-20 | India | Gujarat | 827184 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-21 04:22:13 | Gujarat, India | |||
730458 | 730458 | 2021-12-27 | India | Gujarat | 829563 | 10114 | 0 | 22.694884 | 71.590923 | 2021-12-28 04:21:47 | Gujarat, India | |||
746275 | 746275 | 2022-04-23 | India | Gujarat | 1224233 | 10943 | 0 | 22.694884 | 71.590923 | 2022-04-24 04:20:56 | Gujarat, India | |||
758258 | 758258 | 2021-11-26 | India | Gujarat | 827354 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-27 04:22:45 | Gujarat, India | |||
770279 | 770279 | 2021-10-23 | India | Gujarat | 826402 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-24 04:21:22 | Gujarat, India | |||
782321 | 782321 | 2021-12-13 | India | Gujarat | 828191 | 10099 | 0 | 22.694884 | 71.590923 | 2021-12-14 04:22:38 | Gujarat, India | |||
794345 | 794345 | 2022-10-24 | India | Gujarat | 1276573 | 11038 | 0 | 22.694884 | 71.590923 | 2022-10-25 04:21:53 | Gujarat, India | |||
798360 | 798360 | 2021-12-22 | India | Gujarat | 828794 | 10106 | 0 | 22.694884 | 71.590923 | 2021-12-23 04:21:21 | Gujarat, India | |||
809522 | 809522 | 2021-09-20 | India | Gujarat | 825737 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-21 04:21:26 | Gujarat, India | |||
833558 | 833558 | 2022-12-02 | India | Gujarat | 1277459 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-03 04:21:02 | Gujarat, India | |||
849530 | 849530 | 2022-11-02 | India | Gujarat | 1276896 | 11039 | 0 | 22.694884 | 71.590923 | 2022-11-03 04:22:05 | Gujarat, India | |||
853546 | 853546 | 2022-09-30 | India | Gujarat | 1274751 | 11034 | 0 | 22.694884 | 71.590923 | 2022-10-01 04:23:01 | Gujarat, India | |||
868730 | 868730 | 2022-12-11 | India | Gujarat | 1277491 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-12 04:21:01 | Gujarat, India | |||
876195 | 876195 | 2022-03-27 | India | Gujarat | 1223871 | 10942 | 0 | 22.694884 | 71.590923 | 2022-03-28 04:20:33 | Gujarat, India | |||
880211 | 880211 | 2022-08-05 | India | Gujarat | 1259528 | 10975 | 0 | 22.694884 | 71.590923 | 2022-08-06 04:20:56 | Gujarat, India | |||
896078 | 896078 | 2022-07-24 | India | Gujarat | 1248487 | 10960 | 0 | 22.694884 | 71.590923 | 2022-07-25 04:20:51 | Gujarat, India | |||
900094 | 900094 | 2022-07-22 | India | Gujarat | 1246708 | 10959 | 0 | 22.694884 | 71.590923 | 2022-07-23 04:20:53 | Gujarat, India | |||
904109 | 904109 | 2021-11-24 | India | Gujarat | 827296 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-25 04:22:33 | Gujarat, India | |||
912139 | 912139 | 2022-10-29 | India | Gujarat | 1276702 | 11039 | 0 | 22.694884 | 71.590923 | 2022-10-30 04:22:14 | Gujarat, India | |||
919615 | 919615 | 2022-03-08 | India | Gujarat | 1223360 | 10938 | 0 | 22.694884 | 71.590923 | 2022-03-09 04:20:59 | Gujarat, India | |||
934731 | 934731 | 2021-10-16 | India | Gujarat | 826280 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-17 04:21:29 | Gujarat, India | |||
938748 | 938748 | 2022-06-25 | India | Gujarat | 1229708 | 10946 | 0 | 22.694884 | 71.590923 | 2022-06-26 04:21:02 | Gujarat, India | |||
942764 | 942764 | 2022-02-28 | India | Gujarat | 1222628 | 10930 | 0 | 22.694884 | 71.590923 | 2022-03-01 04:21:09 | Gujarat, India | |||
946780 | 946780 | 2022-06-14 | India | Gujarat | 1226528 | 10945 | 0 | 22.694884 | 71.590923 | 2022-06-15 04:20:54 | Gujarat, India | |||
950796 | 950796 | 2022-03-12 | India | Gujarat | 1223562 | 10938 | 0 | 22.694884 | 71.590923 | 2022-03-13 04:20:49 | Gujarat, India | |||
958826 | 958826 | 2022-07-19 | India | Gujarat | 1244114 | 10954 | 0 | 22.694884 | 71.590923 | 2022-07-20 04:20:59 | Gujarat, India | |||
962842 | 962842 | 2022-09-09 | India | Gujarat | 1271986 | 11018 | 0 | 22.694884 | 71.590923 | 2022-09-10 04:21:10 | Gujarat, India | |||
970850 | 970850 | 2022-06-01 | India | Gujarat | 1225242 | 10944 | 0 | 22.694884 | 71.590923 | 2022-06-02 05:20:39 | Gujarat, India | |||
978879 | 978879 | 2022-02-01 | India | Gujarat | 1168997 | 10511 | 0 | 22.694884 | 71.590923 | 2022-02-02 04:21:09 | Gujarat, India | |||
986909 | 986909 | 2021-10-04 | India | Gujarat | 826016 | 10082 | 0 | 22.694884 | 71.590923 | 2021-10-05 04:21:27 | Gujarat, India | |||
990925 | 990925 | 2022-08-16 | India | Gujarat | 1266168 | 10994 | 0 | 22.694884 | 71.590923 | 2022-08-17 04:20:59 | Gujarat, India | |||
1014264 | 1014264 | 2021-11-21 | India | Gujarat | 827206 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-22 04:22:20 | Gujarat, India | |||
1018281 | 1018281 | 2022-12-24 | India | Gujarat | 1277538 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-25 04:21:04 | Gujarat, India | |||
1022297 | 1022297 | 2022-11-04 | India | Gujarat | 1276978 | 11039 | 0 | 22.694884 | 71.590923 | 2022-11-05 04:21:52 | Gujarat, India | |||
1030306 | 1030306 | 2021-12-06 | India | Gujarat | 827745 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-07 04:22:34 | Gujarat, India | |||
1049769 | 1049769 | 2022-11-06 | India | Gujarat | 1277046 | 11040 | 0 | 22.694884 | 71.590923 | 2022-11-07 04:21:26 | Gujarat, India | |||
1057780 | 1057780 | 2022-02-23 | India | Gujarat | 1221581 | 10911 | 0 | 22.694884 | 71.590923 | 2022-02-24 04:21:14 | Gujarat, India | |||
1065808 | 1065808 | 2022-07-28 | India | Gujarat | 1250988 | 10964 | 0 | 22.694884 | 71.590923 | 2022-07-29 04:20:45 | Gujarat, India | |||
1069824 | 1069824 | 2022-08-07 | India | Gujarat | 1260493 | 10975 | 0 | 22.694884 | 71.590923 | 2022-08-08 04:21:08 | Gujarat, India | |||
1073840 | 1073840 | 2022-12-28 | India | Gujarat | 1277557 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-29 04:21:01 | Gujarat, India | |||
1077855 | 1077855 | 2021-12-09 | India | Gujarat | 827943 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-10 04:22:28 | Gujarat, India | |||
1086006 | 1086006 | 2022-08-09 | India | Gujarat | 1262600 | 10981 | 0 | 22.694884 | 71.590923 | 2022-08-10 04:20:57 | Gujarat, India | |||
1098049 | 1098049 | 2022-08-03 | India | Gujarat | 1257710 | 10971 | 0 | 22.694884 | 71.590923 | 2022-08-04 04:20:58 | Gujarat, India | |||
1109505 | 1109505 | 2022-05-21 | India | Gujarat | 1224893 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-22 04:20:52 | Gujarat, India | |||
1113520 | 1113520 | 2022-01-11 | India | Gujarat | 868301 | 10130 | 0 | 22.694884 | 71.590923 | 2022-01-12 04:21:44 | Gujarat, India | |||
1117536 | 1117536 | 2021-08-06 | India | Gujarat | 825001 | 10077 | 0 | 22.694884 | 71.590923 | 2021-08-07 04:21:30 | Gujarat, India | |||
1140843 | 1140843 | 2022-01-23 | India | Gujarat | 1062555 | 10249 | 0 | 22.694884 | 71.590923 | 2022-01-24 04:21:12 | Gujarat, India | |||
1144859 | 1144859 | 2021-12-01 | India | Gujarat | 827520 | 10093 | 0 | 22.694884 | 71.590923 | 2021-12-02 04:22:37 | Gujarat, India | |||
1148876 | 1148876 | 2022-12-12 | India | Gujarat | 1277497 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-13 04:21:01 | Gujarat, India | |||
1157083 | 1157083 | 2022-04-29 | India | Gujarat | 1224322 | 10943 | 0 | 22.694884 | 71.590923 | 2022-04-30 04:21:05 | Gujarat, India | |||
1161099 | 1161099 | 2022-08-18 | India | Gujarat | 1266918 | 10996 | 0 | 22.694884 | 71.590923 | 2022-08-19 04:20:54 | Gujarat, India | |||
1169129 | 1169129 | 2022-05-20 | India | Gujarat | 1224865 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-21 04:20:58 | Gujarat, India | |||
1184676 | 1184676 | 2022-05-18 | India | Gujarat | 1224814 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-19 04:20:54 | Gujarat, India | |||
1199738 | 1199738 | 2022-07-06 | India | Gujarat | 1235354 | 10948 | 0 | 22.694884 | 71.590923 | 2022-07-07 04:20:55 | Gujarat, India | |||
1211483 | 1211483 | 2022-07-11 | India | Gujarat | 1238432 | 10948 | 0 | 22.694884 | 71.590923 | 2022-07-12 04:20:51 | Gujarat, India | |||
1215498 | 1215498 | 2022-01-08 | India | Gujarat | 855929 | 10128 | 0 | 22.694884 | 71.590923 | 2022-01-09 04:21:46 | Gujarat, India | |||
1223529 | 1223529 | 2022-04-14 | India | Gujarat | 1224127 | 10942 | 0 | 22.694884 | 71.590923 | 2022-04-15 04:20:57 | Gujarat, India | |||
1227544 | 1227544 | 2022-01-24 | India | Gujarat | 1076360 | 10274 | 0 | 22.694884 | 71.590923 | 2022-01-25 04:21:05 | Gujarat, India | |||
1231560 | 1231560 | 2021-11-28 | India | Gujarat | 827408 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-29 04:22:30 | Gujarat, India | |||
1235576 | 1235576 | 2021-09-27 | India | Gujarat | 825872 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-28 04:21:28 | Gujarat, India | |||
1239592 | 1239592 | 2022-11-28 | India | Gujarat | 1277431 | 11043 | 0 | 22.694884 | 71.590923 | 2022-11-29 04:21:05 | Gujarat, India | |||
1250688 | 1250688 | 2022-08-23 | India | Gujarat | 1268243 | 11000 | 0 | 22.694884 | 71.590923 | 2022-08-24 04:20:46 | Gujarat, India | |||
1254703 | 1254703 | 2021-12-20 | India | Gujarat | 828616 | 10102 | 0 | 22.694884 | 71.590923 | 2021-12-21 03:21:27 | Gujarat, India | |||
1258719 | 1258719 | 2021-12-18 | India | Gujarat | 828427 | 10101 | 0 | 22.694884 | 71.590923 | 2021-12-19 04:21:11 | Gujarat, India | |||
1262735 | 1262735 | 2021-09-09 | India | Gujarat | 825563 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-10 04:21:20 | Gujarat, India | |||
1274219 | 1274219 | 2021-10-03 | India | Gujarat | 826002 | 10082 | 0 | 22.694884 | 71.590923 | 2021-10-04 04:21:31 | Gujarat, India | |||
1281920 | 1281920 | 2022-01-05 | India | Gujarat | 840643 | 10126 | 0 | 22.694884 | 71.590923 | 2022-01-06 04:22:09 | Gujarat, India | |||
1285936 | 1285936 | 2022-01-04 | India | Gujarat | 837293 | 10125 | 0 | 22.694884 | 71.590923 | 2022-01-05 04:21:59 | Gujarat, India | |||
1293966 | 1293966 | 2022-02-05 | India | Gujarat | 1196344 | 10648 | 0 | 22.694884 | 71.590923 | 2022-02-06 04:21:00 | Gujarat, India | |||
1297983 | 1297983 | 2022-02-17 | India | Gujarat | 1219082 | 10864 | 0 | 22.694884 | 71.590923 | 2022-02-18 04:21:04 | Gujarat, India | |||
1314130 | 1314130 | 2022-05-27 | India | Gujarat | 1225058 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-28 04:21:07 | Gujarat, India | |||
1318145 | 1318145 | 2022-01-26 | India | Gujarat | 1107749 | 10323 | 0 | 22.694884 | 71.590923 | 2022-01-27 04:21:19 | Gujarat, India | |||
1322161 | 1322161 | 2021-11-14 | India | Gujarat | 826950 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-15 04:21:36 | Gujarat, India | |||
1326178 | 1326178 | 2022-04-26 | India | Gujarat | 1224276 | 10943 | 0 | 22.694884 | 71.590923 | 2022-04-27 04:20:52 | Gujarat, India | |||
1334207 | 1334207 | 2021-09-28 | India | Gujarat | 825896 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-29 04:21:45 | Gujarat, India | |||
1342236 | 1342236 | 2021-08-11 | India | Gujarat | 825101 | 10077 | 0 | 22.694884 | 71.590923 | 2021-08-12 04:21:25 | Gujarat, India | |||
1346251 | 1346251 | 2022-08-10 | India | Gujarat | 1263278 | 10985 | 0 | 22.694884 | 71.590923 | 2022-08-11 04:20:49 | Gujarat, India | |||
1358267 | 1358267 | 2021-11-27 | India | Gujarat | 827382 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-28 04:22:43 | Gujarat, India | |||
1362283 | 1362283 | 2022-02-08 | India | Gujarat | 1205652 | 10716 | 0 | 22.694884 | 71.590923 | 2022-02-09 04:21:04 | Gujarat, India | |||
1366408 | 1366408 | 2022-10-28 | India | Gujarat | 1276662 | 11039 | 0 | 22.694884 | 71.590923 | 2022-10-29 04:21:13 | Gujarat, India | |||
1370424 | 1370424 | 2022-09-21 | India | Gujarat | 1273787 | 11028 | 0 | 22.694884 | 71.590923 | 2022-09-22 04:22:56 | Gujarat, India | |||
1374439 | 1374439 | 2021-09-15 | India | Gujarat | 825655 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-16 04:22:19 | Gujarat, India | |||
1385577 | 1385577 | 2021-09-13 | India | Gujarat | 825629 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-14 04:21:41 | Gujarat, India | |||
1389591 | 1389591 | 2022-01-07 | India | Gujarat | 850252 | 10128 | 0 | 22.694884 | 71.590923 | 2022-01-08 04:21:53 | Gujarat, India | |||
1393608 | 1393608 | 2022-09-02 | India | Gujarat | 1270639 | 11014 | 0 | 22.694884 | 71.590923 | 2022-09-03 04:21:04 | Gujarat, India | |||
1397624 | 1397624 | 2022-05-06 | India | Gujarat | 1224443 | 10943 | 0 | 22.694884 | 71.590923 | 2022-05-07 04:21:09 | Gujarat, India | |||
1404974 | 1404974 | 2022-08-02 | India | Gujarat | 1256651 | 10971 | 0 | 22.694884 | 71.590923 | 2022-08-03 04:20:59 | Gujarat, India | |||
1417018 | 1417018 | 2022-07-08 | India | Gujarat | 1236707 | 10948 | 0 | 22.694884 | 71.590923 | 2022-07-09 04:20:59 | Gujarat, India | |||
1421034 | 1421034 | 2022-06-08 | India | Gujarat | 1225698 | 10944 | 0 | 22.694884 | 71.590923 | 2022-06-09 04:20:54 | Gujarat, India | |||
1432497 | 1432497 | 2021-12-28 | India | Gujarat | 829957 | 10115 | 0 | 22.694884 | 71.590923 | 2021-12-29 03:21:43 | Gujarat, India | |||
1436514 | 1436514 | 2022-03-28 | India | Gujarat | 1223879 | 10942 | 0 | 22.694884 | 71.590923 | 2022-03-29 04:20:46 | Gujarat, India | |||
1464015 | 1464015 | 2022-02-10 | India | Gujarat | 1210487 | 10761 | 0 | 22.694884 | 71.590923 | 2022-02-11 04:21:09 | Gujarat, India | |||
1468031 | 1468031 | 2022-03-24 | India | Gujarat | 1223832 | 10942 | 0 | 22.694884 | 71.590923 | 2022-03-25 04:20:46 | Gujarat, India | |||
1472046 | 1472046 | 2022-01-17 | India | Gujarat | 938993 | 10164 | 0 | 22.694884 | 71.590923 | 2022-01-18 04:21:04 | Gujarat, India | |||
1483502 | 1483502 | 2021-08-13 | India | Gujarat | 825141 | 10078 | 0 | 22.694884 | 71.590923 | 2021-08-14 04:21:25 | Gujarat, India | |||
1487517 | 1487517 | 2022-07-26 | India | Gujarat | 1250009 | 10964 | 0 | 22.694884 | 71.590923 | 2022-07-27 04:21:04 | Gujarat, India | |||
1491532 | 1491532 | 2021-10-12 | India | Gujarat | 826184 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-13 04:20:51 | Gujarat, India | |||
1503530 | 1503530 | 2022-05-16 | India | Gujarat | 1224754 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-17 04:20:59 | Gujarat, 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]);