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 confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2863845 | 2863845 | 2020-06-10 | India | Gujarat | 21014 | 1313 | 14365 | 5336 | 22.694884 | 71.590923 | 2020-06-11 03:33:41 | Gujarat, India | ||
737432 | 737432 | 2020-06-12 | India | Gujarat | 22032 | 1385 | 15101 | 5546 | 22.694884 | 71.590923 | 2020-06-13 03:33:14 | Gujarat, India | ||
1273402 | 1273402 | 2020-06-11 | India | Gujarat | 22032 | 1385 | 15101 | 5546 | 22.694884 | 71.590923 | 2020-06-12 05:09:52 | Gujarat, India | ||
3061112 | 3061112 | 2020-06-13 | India | Gujarat | 22527 | 1415 | 15493 | 5619 | 22.694884 | 71.590923 | 2020-06-14 03:33:15 | Gujarat, India | ||
1837060 | 1837060 | 2020-06-14 | India | Gujarat | 23038 | 1448 | 15883 | 5707 | 22.694884 | 71.590923 | 2020-06-15 03:33:14 | Gujarat, India | ||
287109 | 287109 | 2020-06-15 | India | Gujarat | 24055 | 1505 | 16664 | 5886 | 22.694884 | 71.590923 | 2020-06-16 04:33:09 | Gujarat, India | ||
2386546 | 2386546 | 2020-06-16 | India | Gujarat | 24577 | 1533 | 17082 | 5962 | 22.694884 | 71.590923 | 2020-06-17 04:33:21 | Gujarat, India | ||
1195783 | 1195783 | 2020-06-17 | India | Gujarat | 25093 | 1560 | 17430 | 6103 | 22.694884 | 71.590923 | 2020-06-18 04:33:18 | Gujarat, India | ||
3682580 | 3682580 | 2020-06-18 | India | Gujarat | 25601 | 1591 | 17819 | 6191 | 22.694884 | 71.590923 | 2020-06-19 04:33:17 | Gujarat, India | ||
1691431 | 1691431 | 2020-06-19 | India | Gujarat | 26141 | 1618 | 18159 | 6364 | 22.694884 | 71.590923 | 2020-06-20 04:33:19 | Gujarat, India | ||
2437853 | 2437853 | 2020-06-20 | India | Gujarat | 26680 | 1638 | 18694 | 6348 | 22.694884 | 71.590923 | 2020-06-21 04:33:19 | Gujarat, India | ||
3249260 | 3249260 | 2020-06-21 | India | Gujarat | 27260 | 1663 | 19349 | 6248 | 22.694884 | 71.590923 | 2020-06-22 04:33:20 | Gujarat, India | ||
1510521 | 1510521 | 2020-06-22 | India | Gujarat | 27825 | 1684 | 19909 | 6232 | 22.694884 | 71.590923 | 2020-06-23 04:33:22 | Gujarat, India | ||
1522327 | 1522327 | 2020-06-23 | India | Gujarat | 28371 | 1710 | 20513 | 6148 | 22.694884 | 71.590923 | 2020-06-24 04:33:28 | Gujarat, India | ||
2700642 | 2700642 | 2020-06-24 | India | Gujarat | 28943 | 1735 | 21088 | 6120 | 22.694884 | 71.590923 | 2020-06-25 05:26:54 | Gujarat, India | ||
2625002 | 2625002 | 2020-06-25 | India | Gujarat | 29520 | 1753 | 21498 | 6269 | 22.694884 | 71.590923 | 2020-06-26 04:33:43 | Gujarat, India | ||
1136015 | 1136015 | 2020-06-26 | India | Gujarat | 30095 | 1771 | 22030 | 6294 | 22.694884 | 71.590923 | 2020-06-27 04:33:35 | Gujarat, India | ||
2039734 | 2039734 | 2020-06-27 | India | Gujarat | 30709 | 1789 | 22409 | 6511 | 22.694884 | 71.590923 | 2020-06-28 04:34:04 | Gujarat, India | ||
2306399 | 2306399 | 2020-06-28 | India | Gujarat | 31320 | 1808 | 22800 | 6712 | 22.694884 | 71.590923 | 2020-06-29 04:33:44 | Gujarat, India | ||
2632836 | 2632836 | 2020-06-29 | India | Gujarat | 31938 | 1827 | 23240 | 6871 | 22.694884 | 71.590923 | 2020-06-30 04:33:48 | Gujarat, India | ||
2974359 | 2974359 | 2020-06-30 | India | Gujarat | 32557 | 1846 | 23662 | 7049 | 22.694884 | 71.590923 | 2020-07-01 04:33:52 | Gujarat, India | ||
302981 | 302981 | 2020-07-01 | India | Gujarat | 33232 | 1867 | 24030 | 7335 | 22.694884 | 71.590923 | 2020-07-02 04:33:46 | Gujarat, India | ||
3045290 | 3045290 | 2020-07-02 | India | Gujarat | 33913 | 1886 | 24593 | 7434 | 22.694884 | 71.590923 | 2020-07-03 04:33:54 | Gujarat, India | ||
2234496 | 2234496 | 2020-07-03 | India | Gujarat | 34600 | 1904 | 24933 | 7763 | 22.694884 | 71.590923 | 2020-07-04 04:33:51 | Gujarat, India | ||
529835 | 529835 | 2020-07-04 | India | Gujarat | 35312 | 1925 | 25406 | 7981 | 22.694884 | 71.590923 | 2020-07-05 04:33:46 | Gujarat, India | ||
415273 | 415273 | 2020-07-05 | India | Gujarat | 36037 | 1943 | 25892 | 8202 | 22.694884 | 71.590923 | 2020-07-06 04:33:57 | Gujarat, India | ||
2684808 | 2684808 | 2020-07-06 | India | Gujarat | 36772 | 1960 | 26315 | 8497 | 22.694884 | 71.590923 | 2020-07-07 04:34:00 | Gujarat, India | ||
887248 | 887248 | 2020-07-07 | India | Gujarat | 37550 | 1977 | 26720 | 8853 | 22.694884 | 71.590923 | 2020-07-08 05:33:48 | Gujarat, India | ||
2222639 | 2222639 | 2020-07-08 | India | Gujarat | 38333 | 1993 | 27289 | 9051 | 22.694884 | 71.590923 | 2020-07-09 04:34:23 | Gujarat, India | ||
1005423 | 1005423 | 2020-07-09 | India | Gujarat | 39194 | 2008 | 27718 | 9468 | 22.694884 | 71.590923 | 2020-07-10 04:34:24 | Gujarat, India | ||
3237438 | 3237438 | 2020-07-10 | India | Gujarat | 40069 | 2022 | 28147 | 9900 | 22.694884 | 71.590923 | 2020-07-11 04:34:26 | Gujarat, India | ||
3435940 | 3435940 | 2020-07-11 | India | Gujarat | 40941 | 2032 | 28649 | 10260 | 22.694884 | 71.590923 | 2020-07-12 04:34:30 | Gujarat, India | ||
3737545 | 3737545 | 2020-07-12 | India | Gujarat | 41820 | 2045 | 29162 | 10613 | 22.694884 | 71.590923 | 2020-07-13 04:43:04 | Gujarat, India | ||
3491282 | 3491282 | 2020-07-13 | India | Gujarat | 42722 | 2055 | 29770 | 10897 | 22.694884 | 71.590923 | 2020-07-14 04:34:46 | Gujarat, India | ||
2158641 | 2158641 | 2020-07-14 | India | Gujarat | 43637 | 2069 | 30503 | 11065 | 22.694884 | 71.590923 | 2020-07-15 04:34:39 | Gujarat, India | ||
2747997 | 2747997 | 2020-07-15 | India | Gujarat | 44552 | 2079 | 31286 | 11187 | 22.694884 | 71.590923 | 2020-07-16 04:44:59 | Gujarat, India | ||
367329 | 367329 | 2020-07-16 | India | Gujarat | 45481 | 2089 | 32103 | 11289 | 22.694884 | 71.590923 | 2020-07-17 04:34:50 | Gujarat, India | ||
2708515 | 2708515 | 2020-07-17 | India | Gujarat | 46430 | 2106 | 32973 | 11351 | 22.694884 | 71.590923 | 2020-07-18 04:34:45 | Gujarat, India | ||
3205213 | 3205213 | 2020-07-18 | India | Gujarat | 47390 | 2122 | 34035 | 11233 | 22.694884 | 71.590923 | 2020-07-19 04:34:58 | Gujarat, India | ||
121824 | 121824 | 2020-07-19 | India | Gujarat | 48355 | 2142 | 34901 | 11312 | 22.694884 | 71.590923 | 2020-07-20 05:34:40 | Gujarat, India | ||
326919 | 326919 | 2020-07-20 | India | Gujarat | 49353 | 2162 | 35678 | 11513 | 22.694884 | 71.590923 | 2020-07-21 04:38:46 | Gujarat, India | ||
1707428 | 1707428 | 2020-07-21 | India | Gujarat | 50379 | 2196 | 36423 | 11760 | 22.694884 | 71.590923 | 2020-07-22 04:34:42 | Gujarat, India | ||
844689 | 844689 | 2020-07-22 | India | Gujarat | 51399 | 2224 | 37260 | 11915 | 22.694884 | 71.590923 | 2020-07-23 05:15:04 | Gujarat, India | ||
61889 | 61889 | 2020-07-23 | India | Gujarat | 52477 | 2252 | 37978 | 12247 | 22.694884 | 71.590923 | 2020-07-24 05:30:40 | Gujarat, India | ||
2563669 | 2563669 | 2020-07-24 | India | Gujarat | 53545 | 2278 | 38849 | 12418 | 22.694884 | 71.590923 | 2020-07-25 04:47:39 | Gujarat, India | ||
1502699 | 1502699 | 2020-07-25 | India | Gujarat | 54626 | 2300 | 39631 | 12695 | 22.694884 | 71.590923 | 2020-07-26 04:35:00 | Gujarat, India | ||
442455 | 442455 | 2020-07-26 | India | Gujarat | 55822 | 2326 | 40365 | 13131 | 22.694884 | 71.590923 | 2020-07-27 04:35:02 | Gujarat, India | ||
177142 | 177142 | 2020-07-27 | India | Gujarat | 56874 | 2348 | 41380 | 13146 | 22.694884 | 71.590923 | 2020-07-28 04:58:43 | Gujarat, India | ||
3185090 | 3185090 | 2020-07-28 | India | Gujarat | 56874 | 2348 | 41380 | 13146 | 22.694884 | 71.590923 | 2020-07-29 04:35:11 | Gujarat, India | ||
2958474 | 2958474 | 2020-07-29 | India | Gujarat | 59126 | 2396 | 43195 | 13535 | 22.694884 | 71.590923 | 2020-07-30 04:35:05 | Gujarat, India | ||
1928306 | 1928306 | 2020-07-30 | India | Gujarat | 60285 | 2418 | 44074 | 13793 | 22.694884 | 71.590923 | 2020-07-31 04:35:18 | Gujarat, India | ||
3264599 | 3264599 | 2020-07-31 | India | Gujarat | 61438 | 2441 | 44907 | 14090 | 22.694884 | 71.590923 | 2020-08-01 04:36:27 | Gujarat, India | ||
753434 | 753434 | 2020-08-01 | India | Gujarat | 62463 | 2464 | 45699 | 14300 | 22.694884 | 71.590923 | 2020-08-02 04:34:47 | Gujarat, India | ||
2807866 | 2807866 | 2020-08-02 | India | Gujarat | 63562 | 2486 | 46504 | 14572 | 22.694884 | 71.590923 | 2020-08-03 04:34:35 | Gujarat, India | ||
2740114 | 2740114 | 2020-08-03 | India | Gujarat | 64585 | 2508 | 47478 | 14599 | 22.694884 | 71.590923 | 2020-08-04 04:41:59 | Gujarat, India | ||
98231 | 98231 | 2020-08-04 | India | Gujarat | 65599 | 2533 | 48376 | 14690 | 22.694884 | 71.590923 | 2020-08-05 04:34:43 | Gujarat, India | ||
3792995 | 3792995 | 2020-08-05 | India | Gujarat | 66669 | 2556 | 49433 | 14680 | 22.694884 | 71.590923 | 2020-08-06 04:35:02 | Gujarat, India | ||
3612165 | 3612165 | 2020-08-06 | India | Gujarat | 67699 | 2583 | 50350 | 14766 | 22.694884 | 71.590923 | 2020-08-07 04:35:11 | Gujarat, India | ||
458480 | 458480 | 2020-08-07 | India | Gujarat | 68768 | 2605 | 51720 | 14443 | 22.694884 | 71.590923 | 2020-08-08 04:34:53 | Gujarat, India | ||
371296 | 371296 | 2020-08-08 | India | Gujarat | 69869 | 2628 | 52855 | 14386 | 22.694884 | 71.590923 | 2020-08-09 04:34:54 | Gujarat, India | ||
3923128 | 3923128 | 2020-08-09 | India | Gujarat | 70965 | 2652 | 54166 | 14147 | 22.694884 | 71.590923 | 2020-08-10 04:34:55 | Gujarat, India | ||
1920319 | 1920319 | 2020-08-10 | India | Gujarat | 72031 | 2672 | 55304 | 14055 | 22.694884 | 71.590923 | 2020-08-11 04:35:08 | Gujarat, India | ||
662245 | 662245 | 2020-08-11 | India | Gujarat | 73163 | 2695 | 56444 | 14024 | 22.694884 | 71.590923 | 2020-08-12 04:27:29 | Gujarat, India | ||
3531396 | 3531396 | 2020-08-12 | India | Gujarat | 74318 | 2713 | 57421 | 14184 | 22.694884 | 71.590923 | 2020-08-13 04:29:15 | Gujarat, India | ||
582777 | 582777 | 2020-08-13 | India | Gujarat | 75408 | 2731 | 58467 | 14210 | 22.694884 | 71.590923 | 2020-08-14 04:51:19 | Gujarat, India | ||
1612193 | 1612193 | 2020-08-14 | India | Gujarat | 76480 | 2746 | 59538 | 14196 | 22.694884 | 71.590923 | 2020-08-15 04:27:31 | Gujarat, India | ||
145918 | 145918 | 2020-08-15 | India | Gujarat | 77559 | 2765 | 60553 | 14241 | 22.694884 | 71.590923 | 2020-08-16 04:27:42 | Gujarat, India | ||
1555916 | 1555916 | 2020-08-16 | India | Gujarat | 78680 | 2785 | 61512 | 14383 | 22.694884 | 71.590923 | 2020-08-17 04:27:20 | Gujarat, India | ||
837558 | 837558 | 2020-08-17 | India | Gujarat | 79710 | 2800 | 62595 | 14315 | 22.694884 | 71.590923 | 2020-08-18 04:27:56 | Gujarat, India | ||
3177954 | 3177954 | 2020-08-18 | India | Gujarat | 80802 | 2820 | 63703 | 14279 | 22.694884 | 71.590923 | 2020-08-19 04:27:00 | Gujarat, India | ||
206200 | 206200 | 2020-08-19 | India | Gujarat | 81942 | 2837 | 64823 | 14282 | 22.694884 | 71.590923 | 2020-08-20 04:27:43 | Gujarat, India | ||
3484251 | 3484251 | 2020-08-20 | India | Gujarat | 83109 | 2853 | 65946 | 14310 | 22.694884 | 71.590923 | 2020-08-21 04:27:41 | Gujarat, India | ||
1479502 | 1479502 | 2020-08-21 | India | Gujarat | 84311 | 2867 | 67267 | 14177 | 22.694884 | 71.590923 | 2020-08-22 04:27:49 | Gujarat, India | ||
2299395 | 2299395 | 2020-08-22 | India | Gujarat | 85523 | 2881 | 68243 | 14399 | 22.694884 | 71.590923 | 2020-08-23 04:27:48 | Gujarat, India | ||
2215613 | 2215613 | 2020-08-23 | India | Gujarat | 86624 | 2895 | 69212 | 14517 | 22.694884 | 71.590923 | 2020-08-24 04:27:56 | Gujarat, India | ||
2991218 | 2991218 | 2020-08-24 | India | Gujarat | 87691 | 2908 | 70231 | 14552 | 22.694884 | 71.590923 | 2020-08-25 04:28:02 | Gujarat, India | ||
3562514 | 3562514 | 2020-08-25 | India | Gujarat | 88805 | 2928 | 71236 | 14641 | 22.694884 | 71.590923 | 2020-08-26 04:28:11 | Gujarat, India | ||
1996590 | 1996590 | 2020-08-26 | India | Gujarat | 89994 | 2945 | 72282 | 14767 | 22.694884 | 71.590923 | 2020-08-27 04:28:15 | Gujarat, India | ||
2510130 | 2510130 | 2020-08-27 | India | Gujarat | 91179 | 2962 | 73475 | 14742 | 22.694884 | 71.590923 | 2020-08-28 04:28:11 | Gujarat, India | ||
1523129 | 1523129 | 2020-08-28 | India | Gujarat | 92452 | 2976 | 74525 | 14951 | 22.694884 | 71.590923 | 2020-08-29 04:28:19 | Gujarat, India | ||
609634 | 609634 | 2020-08-29 | India | Gujarat | 93734 | 2989 | 75636 | 15109 | 22.694884 | 71.590923 | 2020-08-30 04:28:22 | Gujarat, India | ||
3931972 | 3931972 | 2020-08-30 | India | Gujarat | 95009 | 3006 | 76731 | 15272 | 22.694884 | 71.590923 | 2020-08-31 04:28:27 | Gujarat, India | ||
194013 | 194013 | 2020-08-31 | India | Gujarat | 96300 | 3020 | 77756 | 15524 | 22.694884 | 71.590923 | 2020-09-01 04:28:31 | Gujarat, India | ||
2059828 | 2059828 | 2020-09-01 | India | Gujarat | 97629 | 3034 | 78887 | 15708 | 22.694884 | 71.590923 | 2020-09-02 04:28:25 | Gujarat, India | ||
1105499 | 1105499 | 2020-09-02 | India | Gujarat | 98888 | 3046 | 79929 | 15913 | 22.694884 | 71.590923 | 2020-09-03 04:28:22 | Gujarat, India | ||
1354262 | 1354262 | 2020-09-03 | India | Gujarat | 100213 | 3062 | 81055 | 16096 | 22.694884 | 71.590923 | 2020-09-04 04:28:26 | Gujarat, India | ||
2661722 | 2661722 | 2020-09-04 | India | Gujarat | 101533 | 3076 | 82273 | 16184 | 22.694884 | 71.590923 | 2020-09-05 04:28:19 | Gujarat, India | ||
813522 | 813522 | 2020-09-05 | India | Gujarat | 102844 | 3091 | 83419 | 16334 | 22.694884 | 71.590923 | 2020-09-06 04:28:33 | Gujarat, India | ||
3161567 | 3161567 | 2020-09-06 | India | Gujarat | 104179 | 3105 | 84631 | 16443 | 22.694884 | 71.590923 | 2020-09-07 04:28:30 | Gujarat, India | ||
427282 | 427282 | 2020-09-07 | India | Gujarat | 105509 | 3120 | 85907 | 16482 | 22.694884 | 71.590923 | 2020-09-08 04:28:25 | Gujarat, India | ||
1243703 | 1243703 | 2020-09-08 | India | Gujarat | 106804 | 3133 | 87352 | 16319 | 22.694884 | 71.590923 | 2020-09-09 04:28:48 | Gujarat, India | ||
2171494 | 2171494 | 2020-09-09 | India | Gujarat | 108133 | 3149 | 88688 | 16296 | 22.694884 | 71.590923 | 2020-09-10 04:29:01 | Gujarat, India | ||
1173129 | 1173129 | 2020-09-10 | India | Gujarat | 109465 | 3164 | 90103 | 16198 | 22.694884 | 71.590923 | 2020-09-11 04:46:23 | Gujarat, India | ||
1444528 | 1444528 | 2020-09-11 | India | Gujarat | 110809 | 3180 | 91343 | 16286 | 22.694884 | 71.590923 | 2020-09-12 04:25:05 | Gujarat, India | ||
546699 | 546699 | 2020-09-12 | India | Gujarat | 112174 | 3195 | 92678 | 16301 | 22.694884 | 71.590923 | 2020-09-13 04:30:52 | Gujarat, India | ||
344221 | 344221 | 2020-09-14 | India | Gujarat | 113500 | 3210 | 93883 | 16407 | 22.694884 | 71.590923 | 2020-09-15 03:22:50 | Gujarat, India | ||
2868660 | 2868660 | 2020-09-13 | India | Gujarat | 113500 | 3210 | 93883 | 16407 | 22.694884 | 71.590923 | 2020-09-14 04:26:00 | Gujarat, India | ||
2728949 | 2728949 | 2020-09-15 | India | Gujarat | 116183 | 3244 | 96582 | 16357 | 22.694884 | 71.590923 | 2020-09-16 04:22:53 | Gujarat, India | ||
666224 | 666224 | 2020-09-16 | India | Gujarat | 117547 | 3256 | 98029 | 16262 | 22.694884 | 71.590923 | 2020-09-17 04:22:00 | Gujarat, India | ||
1121535 | 1121535 | 2020-09-17 | India | Gujarat | 118926 | 3270 | 99681 | 15975 | 22.694884 | 71.590923 | 2020-09-18 05:05:00 | 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]);