johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Gujarat" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687411 | 3687411 | 2022-01-13 | India | Gujarat | 885718 | 10137 | 0 | 22.694884 | 71.590923 | 2022-01-14 04:21:54 | Gujarat, India | |||
3612995 | 3612995 | 2022-01-12 | India | Gujarat | 885718 | 10137 | 0 | 22.694884 | 71.590923 | 2022-01-13 08:00:09 | Gujarat, India | |||
1113520 | 1113520 | 2022-01-11 | India | Gujarat | 868301 | 10130 | 0 | 22.694884 | 71.590923 | 2022-01-12 04:21:44 | Gujarat, India | |||
1692248 | 1692248 | 2022-01-10 | India | Gujarat | 868301 | 10130 | 0 | 22.694884 | 71.590923 | 2022-01-11 04:22:01 | Gujarat, India | |||
126663 | 126663 | 2022-01-09 | India | Gujarat | 862204 | 10128 | 0 | 22.694884 | 71.590923 | 2022-01-10 04:22:07 | Gujarat, India | |||
1215498 | 1215498 | 2022-01-08 | India | Gujarat | 855929 | 10128 | 0 | 22.694884 | 71.590923 | 2022-01-09 04:21:46 | Gujarat, India | |||
1389591 | 1389591 | 2022-01-07 | India | Gujarat | 850252 | 10128 | 0 | 22.694884 | 71.590923 | 2022-01-08 04:21:53 | Gujarat, India | |||
2609978 | 2609978 | 2022-01-06 | India | Gujarat | 844856 | 10127 | 0 | 22.694884 | 71.590923 | 2022-01-07 04:22:09 | 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 | |||
1700280 | 1700280 | 2022-01-03 | India | Gujarat | 835028 | 10123 | 0 | 22.694884 | 71.590923 | 2022-01-04 04:22:17 | Gujarat, India | |||
3519363 | 3519363 | 2022-01-02 | India | Gujarat | 833769 | 10120 | 0 | 22.694884 | 71.590923 | 2022-01-03 02:22:25 | Gujarat, India | |||
2167493 | 2167493 | 2022-01-01 | India | Gujarat | 832801 | 10119 | 0 | 22.694884 | 71.590923 | 2022-01-02 04:20:52 | Gujarat, India | |||
2776924 | 2776924 | 2021-12-31 | India | Gujarat | 831732 | 10118 | 0 | 22.694884 | 71.590923 | 2022-01-01 04:22:14 | Gujarat, India | |||
3998581 | 3998581 | 2021-12-30 | India | Gujarat | 831078 | 10118 | 0 | 22.694884 | 71.590923 | 2021-12-31 04:21:50 | Gujarat, India | |||
1668388 | 1668388 | 2021-12-29 | India | Gujarat | 830505 | 10116 | 0 | 22.694884 | 71.590923 | 2021-12-30 04:21:25 | Gujarat, India | |||
1432497 | 1432497 | 2021-12-28 | India | Gujarat | 829957 | 10115 | 0 | 22.694884 | 71.590923 | 2021-12-29 03:21:43 | Gujarat, India | |||
730458 | 730458 | 2021-12-27 | India | Gujarat | 829563 | 10114 | 0 | 22.694884 | 71.590923 | 2021-12-28 04:21:47 | Gujarat, India | |||
2111630 | 2111630 | 2021-12-26 | India | Gujarat | 829359 | 10113 | 0 | 22.694884 | 71.590923 | 2021-12-27 04:21:58 | Gujarat, India | |||
3605002 | 3605002 | 2021-12-25 | India | Gujarat | 829182 | 10113 | 0 | 22.694884 | 71.590923 | 2021-12-26 04:21:50 | Gujarat, India | |||
2963320 | 2963320 | 2021-12-24 | India | Gujarat | 829003 | 10111 | 0 | 22.694884 | 71.590923 | 2021-12-25 04:21:37 | Gujarat, India | |||
3816352 | 3816352 | 2021-12-23 | India | Gujarat | 828905 | 10108 | 0 | 22.694884 | 71.590923 | 2021-12-24 04:21:34 | Gujarat, India | |||
798360 | 798360 | 2021-12-22 | India | Gujarat | 828794 | 10106 | 0 | 22.694884 | 71.590923 | 2021-12-23 04:21:21 | Gujarat, India | |||
3828400 | 3828400 | 2021-12-21 | India | Gujarat | 828703 | 10104 | 0 | 22.694884 | 71.590923 | 2021-12-22 04:21:54 | Gujarat, India | |||
1254703 | 1254703 | 2021-12-20 | India | Gujarat | 828616 | 10102 | 0 | 22.694884 | 71.590923 | 2021-12-21 03:21:27 | Gujarat, India | |||
2903646 | 2903646 | 2021-12-19 | India | Gujarat | 828546 | 10101 | 0 | 22.694884 | 71.590923 | 2021-12-20 04:21:43 | Gujarat, India | |||
1258719 | 1258719 | 2021-12-18 | India | Gujarat | 828427 | 10101 | 0 | 22.694884 | 71.590923 | 2021-12-19 04:21:11 | Gujarat, India | |||
2398747 | 2398747 | 2021-12-17 | India | Gujarat | 828367 | 10100 | 0 | 22.694884 | 71.590923 | 2021-12-18 02:22:20 | Gujarat, India | |||
1716285 | 1716285 | 2021-12-16 | India | Gujarat | 828367 | 10100 | 0 | 22.694884 | 71.590923 | 2021-12-17 04:22:14 | Gujarat, India | |||
3496119 | 3496119 | 2021-12-15 | India | Gujarat | 828299 | 10100 | 0 | 22.694884 | 71.590923 | 2021-12-16 04:22:11 | Gujarat, India | |||
2087904 | 2087904 | 2021-12-14 | India | Gujarat | 828246 | 10100 | 0 | 22.694884 | 71.590923 | 2021-12-15 03:22:16 | Gujarat, India | |||
782321 | 782321 | 2021-12-13 | India | Gujarat | 828191 | 10099 | 0 | 22.694884 | 71.590923 | 2021-12-14 04:22:38 | Gujarat, India | |||
1660356 | 1660356 | 2021-12-12 | India | Gujarat | 828133 | 10098 | 0 | 22.694884 | 71.590923 | 2021-12-13 04:22:02 | Gujarat, India | |||
1664372 | 1664372 | 2021-12-11 | India | Gujarat | 828077 | 10098 | 0 | 22.694884 | 71.590923 | 2021-12-12 04:22:12 | Gujarat, India | |||
3655524 | 3655524 | 2021-12-10 | India | Gujarat | 828006 | 10098 | 0 | 22.694884 | 71.590923 | 2021-12-11 04:22:45 | Gujarat, India | |||
1077855 | 1077855 | 2021-12-09 | India | Gujarat | 827943 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-10 04:22:28 | Gujarat, India | |||
550704 | 550704 | 2021-12-08 | India | Gujarat | 827873 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-09 04:22:49 | Gujarat, India | |||
404224 | 404224 | 2021-12-07 | India | Gujarat | 827806 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-08 04:22:46 | Gujarat, India | |||
1030306 | 1030306 | 2021-12-06 | India | Gujarat | 827745 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-07 04:22:34 | Gujarat, India | |||
1740469 | 1740469 | 2021-12-05 | India | Gujarat | 827707 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-06 04:22:34 | Gujarat, India | |||
137901 | 137901 | 2021-12-04 | India | Gujarat | 827615 | 10094 | 0 | 22.694884 | 71.590923 | 2021-12-05 04:22:25 | Gujarat, India | |||
2195554 | 2195554 | 2021-12-03 | India | Gujarat | 827615 | 10094 | 0 | 22.694884 | 71.590923 | 2021-12-04 04:22:18 | Gujarat, India | |||
260 | 260 | 2021-12-02 | India | Gujarat | 827570 | 10094 | 0 | 22.694884 | 71.590923 | 2021-12-03 04:23:05 | Gujarat, India | |||
1144859 | 1144859 | 2021-12-01 | India | Gujarat | 827520 | 10093 | 0 | 22.694884 | 71.590923 | 2021-12-02 04:22:37 | Gujarat, India | |||
3401371 | 3401371 | 2021-11-30 | India | Gujarat | 827475 | 10092 | 0 | 22.694884 | 71.590923 | 2021-12-01 04:22:29 | Gujarat, India | |||
149914 | 149914 | 2021-11-29 | India | Gujarat | 827435 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-30 04:22:53 | Gujarat, India | |||
1231560 | 1231560 | 2021-11-28 | India | Gujarat | 827408 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-29 04:22:30 | Gujarat, India | |||
1358267 | 1358267 | 2021-11-27 | India | Gujarat | 827382 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-28 04:22:43 | Gujarat, India | |||
758258 | 758258 | 2021-11-26 | India | Gujarat | 827354 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-27 04:22:45 | Gujarat, India | |||
1802675 | 1802675 | 2021-11-25 | India | Gujarat | 827327 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-26 04:22:33 | Gujarat, India | |||
904109 | 904109 | 2021-11-24 | India | Gujarat | 827296 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-25 04:22:33 | Gujarat, India | |||
3069959 | 3069959 | 2021-11-23 | India | Gujarat | 827267 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-24 04:22:14 | Gujarat, India | |||
3749057 | 3749057 | 2021-11-22 | India | Gujarat | 827231 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-23 04:22:39 | Gujarat, India | |||
1014264 | 1014264 | 2021-11-21 | India | Gujarat | 827206 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-22 04:22:20 | Gujarat, India | |||
722428 | 722428 | 2021-11-20 | India | Gujarat | 827184 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-21 04:22:13 | Gujarat, India | |||
161958 | 161958 | 2021-11-19 | India | Gujarat | 827148 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-20 04:22:17 | Gujarat, India | |||
3288845 | 3288845 | 2021-11-18 | India | Gujarat | 827112 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-19 04:21:40 | Gujarat, India | |||
447301 | 447301 | 2021-11-17 | India | Gujarat | 827068 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-18 04:21:33 | Gujarat, India | |||
3342551 | 3342551 | 2021-11-16 | India | Gujarat | 827014 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-17 04:21:48 | Gujarat, India | |||
2287387 | 2287387 | 2021-11-15 | India | Gujarat | 826979 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-16 04:21:10 | Gujarat, India | |||
1322161 | 1322161 | 2021-11-14 | India | Gujarat | 826950 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-15 04:21:36 | Gujarat, India | |||
686287 | 686287 | 2021-11-13 | India | Gujarat | 826924 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-14 04:21:31 | Gujarat, India | |||
714396 | 714396 | 2021-11-12 | India | Gujarat | 826887 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-13 04:21:38 | Gujarat, India | |||
28346 | 28346 | 2021-11-11 | India | Gujarat | 826866 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-12 04:22:01 | Gujarat, India | |||
2844785 | 2844785 | 2021-11-10 | India | Gujarat | 826826 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-11 04:21:45 | Gujarat, India | |||
87055 | 87055 | 2021-11-09 | India | Gujarat | 826784 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-10 04:21:38 | Gujarat, India | |||
3639483 | 3639483 | 2021-11-08 | India | Gujarat | 826764 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-09 04:21:36 | Gujarat, India | |||
2000591 | 2000591 | 2021-11-07 | India | Gujarat | 826735 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-08 04:21:43 | Gujarat, India | |||
495582 | 495582 | 2021-11-06 | India | Gujarat | 826716 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-07 04:21:53 | Gujarat, India | |||
3121437 | 3121437 | 2021-11-05 | India | Gujarat | 826700 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-06 04:21:51 | Gujarat, India | |||
698335 | 698335 | 2021-11-04 | India | Gujarat | 826680 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-05 04:21:54 | Gujarat, India | |||
276113 | 276113 | 2021-11-03 | India | Gujarat | 826656 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-04 04:22:20 | Gujarat, India | |||
43638 | 43638 | 2021-11-02 | India | Gujarat | 826627 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-03 06:22:09 | Gujarat, India | |||
3511334 | 3511334 | 2021-11-01 | India | Gujarat | 826597 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-02 04:22:03 | Gujarat, India | |||
287926 | 287926 | 2021-10-31 | India | Gujarat | 826577 | 10089 | 0 | 22.694884 | 71.590923 | 2021-11-01 04:22:01 | Gujarat, India | |||
2720932 | 2720932 | 2021-10-30 | India | Gujarat | 826557 | 10089 | 0 | 22.694884 | 71.590923 | 2021-10-31 04:22:08 | Gujarat, India | |||
567034 | 567034 | 2021-10-29 | India | Gujarat | 826526 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-30 04:22:03 | Gujarat, India | |||
4276 | 4276 | 2021-10-28 | India | Gujarat | 826504 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-29 04:22:03 | Gujarat, India | |||
534666 | 534666 | 2021-10-27 | India | Gujarat | 826481 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-28 04:22:08 | Gujarat, India | |||
3492103 | 3492103 | 2021-10-26 | India | Gujarat | 826464 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-27 04:22:32 | Gujarat, India | |||
3793825 | 3793825 | 2021-10-25 | India | Gujarat | 826434 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-26 04:22:09 | Gujarat, India | |||
682271 | 682271 | 2021-10-24 | India | Gujarat | 826418 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-25 04:22:31 | Gujarat, India | |||
770279 | 770279 | 2021-10-23 | India | Gujarat | 826402 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-24 04:21:22 | Gujarat, India | |||
653926 | 653926 | 2021-10-22 | India | Gujarat | 826378 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-23 04:21:32 | Gujarat, India | |||
2123673 | 2123673 | 2021-10-21 | India | Gujarat | 826353 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-22 04:21:14 | Gujarat, India | |||
443285 | 443285 | 2021-10-20 | India | Gujarat | 826340 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-21 04:21:18 | Gujarat, India | |||
597604 | 597604 | 2021-10-19 | India | Gujarat | 826326 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-20 04:21:00 | Gujarat, India | |||
2043781 | 2043781 | 2021-10-18 | India | Gujarat | 826308 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-19 04:20:54 | Gujarat, India | |||
1909142 | 1909142 | 2021-10-17 | India | Gujarat | 826290 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-18 04:21:10 | Gujarat, India | |||
934731 | 934731 | 2021-10-16 | India | Gujarat | 826280 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-17 04:21:29 | Gujarat, India | |||
2943286 | 2943286 | 2021-10-15 | India | Gujarat | 826258 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-16 04:21:15 | Gujarat, India | |||
491566 | 491566 | 2021-10-14 | India | Gujarat | 826244 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-15 04:21:26 | Gujarat, India | |||
633854 | 633854 | 2021-10-13 | India | Gujarat | 826210 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-14 04:21:29 | Gujarat, India | |||
1491532 | 1491532 | 2021-10-12 | India | Gujarat | 826184 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-13 04:20:51 | Gujarat, India | |||
3007265 | 3007265 | 2021-10-11 | India | Gujarat | 826162 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-12 04:21:09 | Gujarat, India | |||
423281 | 423281 | 2021-10-10 | India | Gujarat | 826141 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-11 04:21:31 | Gujarat, India | |||
2876138 | 2876138 | 2021-10-09 | India | Gujarat | 826123 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-10 04:21:38 | Gujarat, India | |||
2959304 | 2959304 | 2021-10-08 | India | Gujarat | 826099 | 10085 | 0 | 22.694884 | 71.590923 | 2021-10-09 04:21:34 | Gujarat, India | |||
467342 | 467342 | 2021-10-07 | India | Gujarat | 826080 | 10085 | 0 | 22.694884 | 71.590923 | 2021-10-08 04:21:25 | Gujarat, India | |||
2458722 | 2458722 | 2021-10-06 | India | Gujarat | 826060 | 10084 | 0 | 22.694884 | 71.590923 | 2021-10-07 04:21:36 | 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]);