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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260 | 260 | 2021-12-02 | India | Gujarat | 827570 | 10094 | 0 | 22.694884 | 71.590923 | 2021-12-03 04:23:05 | Gujarat, India | |||
4276 | 4276 | 2021-10-28 | India | Gujarat | 826504 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-29 04:22:03 | Gujarat, India | |||
16301 | 16301 | 2021-09-18 | India | Gujarat | 825715 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-19 04:21:34 | Gujarat, India | |||
24331 | 24331 | 2022-03-20 | India | Gujarat | 1223767 | 10939 | 0 | 22.694884 | 71.590923 | 2022-03-21 04:20:50 | Gujarat, India | |||
28346 | 28346 | 2021-11-11 | India | Gujarat | 826866 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-12 04:22:01 | Gujarat, India | |||
32362 | 32362 | 2021-08-25 | India | Gujarat | 825347 | 10080 | 0 | 22.694884 | 71.590923 | 2021-08-26 04:21:28 | Gujarat, India | |||
43638 | 43638 | 2021-11-02 | India | Gujarat | 826627 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-03 06:22:09 | Gujarat, India | |||
62992 | 62992 | 2022-11-12 | India | Gujarat | 1277227 | 11040 | 0 | 22.694884 | 71.590923 | 2022-11-13 04:21:14 | Gujarat, India | |||
67007 | 67007 | 2021-09-01 | India | Gujarat | 825435 | 10081 | 0 | 22.694884 | 71.590923 | 2021-09-02 04:21:15 | Gujarat, India | |||
71021 | 71021 | 2022-02-07 | India | Gujarat | 1203150 | 10688 | 0 | 22.694884 | 71.590923 | 2022-02-08 04:21:15 | Gujarat, India | |||
87055 | 87055 | 2021-11-09 | India | Gujarat | 826784 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-10 04:21:38 | Gujarat, India | |||
91072 | 91072 | 2022-07-23 | India | Gujarat | 1247645 | 10960 | 0 | 22.694884 | 71.590923 | 2022-07-24 04:20:47 | Gujarat, India | |||
99256 | 99256 | 2022-01-14 | India | Gujarat | 906913 | 10144 | 0 | 22.694884 | 71.590923 | 2022-01-15 04:21:07 | Gujarat, India | |||
103272 | 103272 | 2021-08-15 | India | Gujarat | 825182 | 10078 | 0 | 22.694884 | 71.590923 | 2021-08-16 04:21:31 | Gujarat, India | |||
114682 | 114682 | 2022-09-06 | India | Gujarat | 1271392 | 11017 | 0 | 22.694884 | 71.590923 | 2022-09-07 04:20:59 | Gujarat, India | |||
126663 | 126663 | 2022-01-09 | India | Gujarat | 862204 | 10128 | 0 | 22.694884 | 71.590923 | 2022-01-10 04:22:07 | Gujarat, India | |||
130680 | 130680 | 2022-10-04 | India | Gujarat | 1275069 | 11035 | 0 | 22.694884 | 71.590923 | 2022-10-05 04:23:06 | Gujarat, India | |||
137901 | 137901 | 2021-12-04 | India | Gujarat | 827615 | 10094 | 0 | 22.694884 | 71.590923 | 2021-12-05 04:22:25 | Gujarat, India | |||
141918 | 141918 | 2022-07-09 | India | Gujarat | 1237375 | 10948 | 0 | 22.694884 | 71.590923 | 2022-07-10 04:20:54 | Gujarat, India | |||
149914 | 149914 | 2021-11-29 | India | Gujarat | 827435 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-30 04:22:53 | Gujarat, India | |||
157943 | 157943 | 2022-03-29 | India | Gujarat | 1223884 | 10942 | 0 | 22.694884 | 71.590923 | 2022-03-30 04:20:45 | Gujarat, India | |||
161958 | 161958 | 2021-11-19 | India | Gujarat | 827148 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-20 04:22:17 | Gujarat, India | |||
165975 | 165975 | 2022-06-21 | India | Gujarat | 1228086 | 10946 | 0 | 22.694884 | 71.590923 | 2022-06-22 04:20:54 | Gujarat, India | |||
177972 | 177972 | 2021-09-02 | India | Gujarat | 825445 | 10081 | 0 | 22.694884 | 71.590923 | 2021-09-03 04:21:20 | Gujarat, India | |||
186001 | 186001 | 2022-02-13 | India | Gujarat | 1215290 | 10808 | 0 | 22.694884 | 71.590923 | 2022-02-14 04:20:51 | Gujarat, India | |||
198189 | 198189 | 2022-10-19 | India | Gujarat | 1276244 | 11038 | 0 | 22.694884 | 71.590923 | 2022-10-20 04:22:59 | Gujarat, India | |||
217910 | 217910 | 2022-12-26 | India | Gujarat | 1277548 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-27 04:21:07 | Gujarat, India | |||
221926 | 221926 | 2022-05-09 | India | Gujarat | 1224530 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-10 04:20:50 | Gujarat, India | |||
229157 | 229157 | 2022-05-31 | India | Gujarat | 1225202 | 10944 | 0 | 22.694884 | 71.590923 | 2022-06-01 04:20:55 | Gujarat, India | |||
233173 | 233173 | 2022-02-11 | India | Gujarat | 1212370 | 10775 | 0 | 22.694884 | 71.590923 | 2022-02-12 04:21:06 | Gujarat, India | |||
245215 | 245215 | 2021-08-17 | India | Gujarat | 825213 | 10078 | 0 | 22.694884 | 71.590923 | 2021-08-18 04:21:35 | Gujarat, India | |||
249229 | 249229 | 2021-09-04 | India | Gujarat | 825476 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-05 04:21:33 | Gujarat, India | |||
253244 | 253244 | 2022-09-08 | India | Gujarat | 1271783 | 11018 | 0 | 22.694884 | 71.590923 | 2022-09-09 04:21:11 | Gujarat, India | |||
257260 | 257260 | 2022-12-10 | India | Gujarat | 1277491 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-11 04:20:50 | Gujarat, India | |||
261463 | 261463 | 2022-03-15 | India | Gujarat | 1223661 | 10939 | 0 | 22.694884 | 71.590923 | 2022-03-16 04:20:50 | Gujarat, India | |||
276113 | 276113 | 2021-11-03 | India | Gujarat | 826656 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-04 04:22:20 | Gujarat, India | |||
287926 | 287926 | 2021-10-31 | India | Gujarat | 826577 | 10089 | 0 | 22.694884 | 71.590923 | 2021-11-01 04:22:01 | Gujarat, India | |||
291943 | 291943 | 2022-11-15 | India | Gujarat | 1277282 | 11041 | 0 | 22.694884 | 71.590923 | 2022-11-16 04:21:09 | Gujarat, India | |||
303799 | 303799 | 2022-04-16 | India | Gujarat | 1224142 | 10942 | 0 | 22.694884 | 71.590923 | 2022-04-17 04:20:59 | Gujarat, India | |||
307815 | 307815 | 2022-12-13 | India | Gujarat | 1277499 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-14 04:21:04 | Gujarat, India | |||
311831 | 311831 | 2022-11-13 | India | Gujarat | 1277250 | 11040 | 0 | 22.694884 | 71.590923 | 2022-11-14 04:21:09 | Gujarat, India | |||
315847 | 315847 | 2022-02-12 | India | Gujarat | 1214016 | 10795 | 0 | 22.694884 | 71.590923 | 2022-02-13 04:21:00 | Gujarat, India | |||
319863 | 319863 | 2022-10-30 | India | Gujarat | 1276743 | 11039 | 0 | 22.694884 | 71.590923 | 2022-10-31 04:21:36 | Gujarat, India | |||
327837 | 327837 | 2022-12-27 | India | Gujarat | 1277551 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-28 04:21:04 | Gujarat, India | |||
335867 | 335867 | 2022-03-18 | India | Gujarat | 1223728 | 10939 | 0 | 22.694884 | 71.590923 | 2022-03-19 04:20:47 | Gujarat, India | |||
348227 | 348227 | 2022-12-14 | India | Gujarat | 1277502 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-15 04:20:58 | Gujarat, India | |||
356257 | 356257 | 2022-03-11 | India | Gujarat | 1223515 | 10938 | 0 | 22.694884 | 71.590923 | 2022-03-12 04:20:50 | Gujarat, India | |||
360273 | 360273 | 2022-05-07 | India | Gujarat | 1224470 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-08 04:20:49 | Gujarat, India | |||
372127 | 372127 | 2022-09-13 | India | Gujarat | 1272611 | 11024 | 0 | 22.694884 | 71.590923 | 2022-09-14 04:20:44 | Gujarat, India | |||
384154 | 384154 | 2022-09-23 | India | Gujarat | 1274036 | 11031 | 0 | 22.694884 | 71.590923 | 2022-09-24 04:21:40 | Gujarat, India | |||
396195 | 396195 | 2022-10-07 | India | Gujarat | 1275323 | 11036 | 0 | 22.694884 | 71.590923 | 2022-10-08 04:22:56 | Gujarat, India | |||
404224 | 404224 | 2021-12-07 | India | Gujarat | 827806 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-08 04:22:46 | Gujarat, India | |||
419266 | 419266 | 2022-09-18 | India | Gujarat | 1273428 | 11027 | 0 | 22.694884 | 71.590923 | 2022-09-19 04:21:49 | Gujarat, India | |||
423281 | 423281 | 2021-10-10 | India | Gujarat | 826141 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-11 04:21:31 | Gujarat, India | |||
431288 | 431288 | 2022-11-03 | India | Gujarat | 1276932 | 11039 | 0 | 22.694884 | 71.590923 | 2022-11-04 04:22:11 | Gujarat, India | |||
443285 | 443285 | 2021-10-20 | India | Gujarat | 826340 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-21 04:21:18 | Gujarat, India | |||
447301 | 447301 | 2021-11-17 | India | Gujarat | 827068 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-18 04:21:33 | Gujarat, India | |||
451318 | 451318 | 2022-12-21 | India | Gujarat | 1277520 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-22 04:20:56 | Gujarat, India | |||
459310 | 459310 | 2022-02-02 | India | Gujarat | 1177931 | 10545 | 0 | 22.694884 | 71.590923 | 2022-02-03 04:21:21 | Gujarat, India | |||
463327 | 463327 | 2022-05-02 | India | Gujarat | 1224374 | 10943 | 0 | 22.694884 | 71.590923 | 2022-05-03 04:21:00 | Gujarat, India | |||
467342 | 467342 | 2021-10-07 | India | Gujarat | 826080 | 10085 | 0 | 22.694884 | 71.590923 | 2021-10-08 04:21:25 | Gujarat, India | |||
475373 | 475373 | 2022-06-26 | India | Gujarat | 1230128 | 10946 | 0 | 22.694884 | 71.590923 | 2022-06-27 04:21:00 | Gujarat, India | |||
479521 | 479521 | 2022-11-08 | India | Gujarat | 1277046 | 11040 | 0 | 22.694884 | 71.590923 | 2022-11-09 04:21:22 | Gujarat, India | |||
487551 | 487551 | 2022-11-25 | India | Gujarat | 1277417 | 11043 | 0 | 22.694884 | 71.590923 | 2022-11-26 04:21:11 | Gujarat, India | |||
491566 | 491566 | 2021-10-14 | India | Gujarat | 826244 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-15 04:21:26 | Gujarat, India | |||
495582 | 495582 | 2021-11-06 | India | Gujarat | 826716 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-07 04:21:53 | Gujarat, India | |||
499599 | 499599 | 2022-04-02 | India | Gujarat | 1223922 | 10942 | 0 | 22.694884 | 71.590923 | 2022-04-03 04:20:48 | Gujarat, India | |||
503615 | 503615 | 2022-12-17 | India | Gujarat | 1277511 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-18 04:21:03 | Gujarat, India | |||
507630 | 507630 | 2021-08-14 | India | Gujarat | 825166 | 10078 | 0 | 22.694884 | 71.590923 | 2021-08-15 04:21:41 | Gujarat, India | |||
511644 | 511644 | 2021-08-19 | India | Gujarat | 825255 | 10078 | 0 | 22.694884 | 71.590923 | 2021-08-20 04:21:33 | Gujarat, India | |||
515659 | 515659 | 2022-10-15 | India | Gujarat | 1276018 | 11037 | 0 | 22.694884 | 71.590923 | 2022-10-16 04:22:39 | Gujarat, India | |||
534666 | 534666 | 2021-10-27 | India | Gujarat | 826481 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-28 04:22:08 | Gujarat, India | |||
538683 | 538683 | 2022-10-26 | India | Gujarat | 1276615 | 11038 | 0 | 22.694884 | 71.590923 | 2022-10-27 04:22:01 | Gujarat, India | |||
542699 | 542699 | 2022-12-15 | India | Gujarat | 1277504 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-16 04:21:01 | Gujarat, India | |||
550704 | 550704 | 2021-12-08 | India | Gujarat | 827873 | 10095 | 0 | 22.694884 | 71.590923 | 2021-12-09 04:22:49 | Gujarat, India | |||
554720 | 554720 | 2022-01-16 | India | Gujarat | 926240 | 10159 | 0 | 22.694884 | 71.590923 | 2022-01-17 04:21:08 | Gujarat, India | |||
558737 | 558737 | 2022-06-16 | India | Gujarat | 1226940 | 10946 | 0 | 22.694884 | 71.590923 | 2022-06-17 04:20:56 | Gujarat, India | |||
567034 | 567034 | 2021-10-29 | India | Gujarat | 826526 | 10088 | 0 | 22.694884 | 71.590923 | 2021-10-30 04:22:03 | Gujarat, India | |||
574763 | 574763 | 2022-02-25 | India | Gujarat | 1222119 | 10924 | 0 | 22.694884 | 71.590923 | 2022-02-26 04:21:12 | Gujarat, India | |||
589574 | 589574 | 2021-08-08 | India | Gujarat | 825045 | 10077 | 0 | 22.694884 | 71.590923 | 2021-08-09 04:21:24 | Gujarat, India | |||
593589 | 593589 | 2022-07-01 | India | Gujarat | 1232662 | 10947 | 0 | 22.694884 | 71.590923 | 2022-07-02 04:21:16 | Gujarat, India | |||
597604 | 597604 | 2021-10-19 | India | Gujarat | 826326 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-20 04:21:00 | Gujarat, India | |||
601620 | 601620 | 2021-09-23 | India | Gujarat | 825797 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-24 04:21:44 | Gujarat, India | |||
617793 | 617793 | 2022-11-05 | India | Gujarat | 1277019 | 11040 | 0 | 22.694884 | 71.590923 | 2022-11-06 04:21:24 | Gujarat, India | |||
621809 | 621809 | 2022-05-22 | India | Gujarat | 1225004 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-26 04:20:50 | Gujarat, India | |||
629839 | 629839 | 2022-07-12 | India | Gujarat | 1239009 | 10950 | 0 | 22.694884 | 71.590923 | 2022-07-13 04:20:58 | Gujarat, India | |||
633854 | 633854 | 2021-10-13 | India | Gujarat | 826210 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-14 04:21:29 | Gujarat, India | |||
641884 | 641884 | 2021-09-07 | India | Gujarat | 825527 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-08 04:21:31 | Gujarat, India | |||
649912 | 649912 | 2021-08-09 | India | Gujarat | 825064 | 10077 | 0 | 22.694884 | 71.590923 | 2021-08-10 04:21:27 | Gujarat, India | |||
653926 | 653926 | 2021-10-22 | India | Gujarat | 826378 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-23 04:21:32 | Gujarat, India | |||
658245 | 658245 | 2022-05-13 | India | Gujarat | 1224657 | 10944 | 0 | 22.694884 | 71.590923 | 2022-05-14 04:20:48 | Gujarat, India | |||
670230 | 670230 | 2022-07-21 | India | Gujarat | 1245824 | 10956 | 0 | 22.694884 | 71.590923 | 2022-07-22 04:21:15 | Gujarat, India | |||
674246 | 674246 | 2022-07-30 | India | Gujarat | 1254229 | 10970 | 0 | 22.694884 | 71.590923 | 2022-07-31 04:21:02 | Gujarat, India | |||
682271 | 682271 | 2021-10-24 | India | Gujarat | 826418 | 10087 | 0 | 22.694884 | 71.590923 | 2021-10-25 04:22:31 | Gujarat, India | |||
686287 | 686287 | 2021-11-13 | India | Gujarat | 826924 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-14 04:21:31 | Gujarat, India | |||
690304 | 690304 | 2022-12-23 | India | Gujarat | 1277529 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-24 04:21:02 | Gujarat, India | |||
694320 | 694320 | 2022-03-17 | India | Gujarat | 1223710 | 10939 | 0 | 22.694884 | 71.590923 | 2022-03-18 04:20:55 | Gujarat, India | |||
698335 | 698335 | 2021-11-04 | India | Gujarat | 826680 | 10090 | 0 | 22.694884 | 71.590923 | 2021-11-05 04:21:54 | Gujarat, India | |||
706365 | 706365 | 2021-09-29 | India | Gujarat | 825916 | 10082 | 0 | 22.694884 | 71.590923 | 2021-09-30 04:21:20 | Gujarat, India | |||
710381 | 710381 | 2022-11-01 | India | Gujarat | 1276839 | 11039 | 0 | 22.694884 | 71.590923 | 2022-11-02 04:22:09 | 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]);