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 = "Telangana" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2864122 | 2864122 | 2020-06-10 | India | Telangana | 3920 | 148 | 1809 | 1963 | 18.1124 | 79.0193 | 2020-06-11 03:33:41 | Telangana, India | ||
737711 | 737711 | 2020-06-12 | India | Telangana | 4320 | 165 | 1993 | 2162 | 18.1124 | 79.0193 | 2020-06-13 03:33:14 | Telangana, India | ||
1273681 | 1273681 | 2020-06-11 | India | Telangana | 4320 | 165 | 1993 | 2162 | 18.1124 | 79.0193 | 2020-06-12 05:09:52 | Telangana, India | ||
3061391 | 3061391 | 2020-06-13 | India | Telangana | 4484 | 174 | 2278 | 2032 | 18.1124 | 79.0193 | 2020-06-14 03:33:15 | Telangana, India | ||
1837339 | 1837339 | 2020-06-14 | India | Telangana | 4737 | 182 | 2352 | 2203 | 18.1124 | 79.0193 | 2020-06-15 03:33:14 | Telangana, India | ||
287388 | 287388 | 2020-06-15 | India | Telangana | 5193 | 187 | 2766 | 2240 | 18.1124 | 79.0193 | 2020-06-16 04:33:09 | Telangana, India | ||
2386825 | 2386825 | 2020-06-16 | India | Telangana | 5406 | 191 | 3027 | 2188 | 18.1124 | 79.0193 | 2020-06-17 04:33:21 | Telangana, India | ||
1196062 | 1196062 | 2020-06-17 | India | Telangana | 5675 | 192 | 3071 | 2412 | 18.1124 | 79.0193 | 2020-06-18 04:33:18 | Telangana, India | ||
3682859 | 3682859 | 2020-06-18 | India | Telangana | 6027 | 195 | 3301 | 2531 | 18.1124 | 79.0193 | 2020-06-19 04:33:17 | Telangana, India | ||
1691710 | 1691710 | 2020-06-19 | India | Telangana | 6526 | 198 | 3353 | 2975 | 18.1124 | 79.0193 | 2020-06-20 04:33:19 | Telangana, India | ||
2438132 | 2438132 | 2020-06-20 | India | Telangana | 7072 | 203 | 3506 | 3363 | 18.1124 | 79.0193 | 2020-06-21 04:33:19 | Telangana, India | ||
3249539 | 3249539 | 2020-06-21 | India | Telangana | 7802 | 210 | 3731 | 3861 | 18.1124 | 79.0193 | 2020-06-22 04:33:20 | Telangana, India | ||
1510800 | 1510800 | 2020-06-22 | India | Telangana | 8674 | 217 | 4005 | 4452 | 18.1124 | 79.0193 | 2020-06-23 04:33:22 | Telangana, India | ||
1522606 | 1522606 | 2020-06-23 | India | Telangana | 9553 | 220 | 4224 | 5109 | 18.1124 | 79.0193 | 2020-06-24 04:33:28 | Telangana, India | ||
2700921 | 2700921 | 2020-06-24 | India | Telangana | 10444 | 225 | 4361 | 5858 | 18.1124 | 79.0193 | 2020-06-25 05:26:54 | Telangana, India | ||
2625281 | 2625281 | 2020-06-25 | India | Telangana | 11364 | 230 | 4688 | 6446 | 18.1124 | 79.0193 | 2020-06-26 04:33:43 | Telangana, India | ||
1136294 | 1136294 | 2020-06-26 | India | Telangana | 12349 | 237 | 4766 | 7346 | 18.1124 | 79.0193 | 2020-06-27 04:33:35 | Telangana, India | ||
2040013 | 2040013 | 2020-06-27 | India | Telangana | 13436 | 243 | 4928 | 8265 | 18.1124 | 79.0193 | 2020-06-28 04:34:04 | Telangana, India | ||
2306678 | 2306678 | 2020-06-28 | India | Telangana | 14419 | 247 | 5172 | 9000 | 18.1124 | 79.0193 | 2020-06-29 04:33:44 | Telangana, India | ||
2633115 | 2633115 | 2020-06-29 | India | Telangana | 15394 | 253 | 5582 | 9559 | 18.1124 | 79.0193 | 2020-06-30 04:33:48 | Telangana, India | ||
2974638 | 2974638 | 2020-06-30 | India | Telangana | 16339 | 260 | 7294 | 8785 | 18.1124 | 79.0193 | 2020-07-01 04:33:52 | Telangana, India | ||
303260 | 303260 | 2020-07-01 | India | Telangana | 17357 | 267 | 8082 | 9008 | 18.1124 | 79.0193 | 2020-07-02 04:33:46 | Telangana, India | ||
3045569 | 3045569 | 2020-07-02 | India | Telangana | 18570 | 275 | 9069 | 9226 | 18.1124 | 79.0193 | 2020-07-03 04:33:54 | Telangana, India | ||
2234775 | 2234775 | 2020-07-03 | India | Telangana | 20462 | 283 | 10195 | 9984 | 18.1124 | 79.0193 | 2020-07-04 04:33:51 | Telangana, India | ||
530114 | 530114 | 2020-07-04 | India | Telangana | 22312 | 288 | 11537 | 10487 | 18.1124 | 79.0193 | 2020-07-05 04:33:46 | Telangana, India | ||
415552 | 415552 | 2020-07-05 | India | Telangana | 23902 | 295 | 12703 | 10904 | 18.1124 | 79.0193 | 2020-07-06 04:33:57 | Telangana, India | ||
2685087 | 2685087 | 2020-07-06 | India | Telangana | 25733 | 306 | 14781 | 10646 | 18.1124 | 79.0193 | 2020-07-07 04:34:00 | Telangana, India | ||
887527 | 887527 | 2020-07-07 | India | Telangana | 27612 | 313 | 16287 | 11012 | 18.1124 | 79.0193 | 2020-07-08 05:33:48 | Telangana, India | ||
2222918 | 2222918 | 2020-07-08 | India | Telangana | 29536 | 324 | 17279 | 11933 | 18.1124 | 79.0193 | 2020-07-09 04:34:23 | Telangana, India | ||
1005702 | 1005702 | 2020-07-09 | India | Telangana | 30946 | 331 | 18192 | 12423 | 18.1124 | 79.0193 | 2020-07-10 04:34:24 | Telangana, India | ||
3237717 | 3237717 | 2020-07-10 | India | Telangana | 32224 | 339 | 19205 | 12680 | 18.1124 | 79.0193 | 2020-07-11 04:34:26 | Telangana, India | ||
3436219 | 3436219 | 2020-07-11 | India | Telangana | 33402 | 348 | 20919 | 12135 | 18.1124 | 79.0193 | 2020-07-12 04:34:30 | Telangana, India | ||
3737824 | 3737824 | 2020-07-12 | India | Telangana | 34671 | 356 | 22482 | 11833 | 18.1124 | 79.0193 | 2020-07-13 04:43:04 | Telangana, India | ||
3491561 | 3491561 | 2020-07-13 | India | Telangana | 36221 | 365 | 23679 | 12177 | 18.1124 | 79.0193 | 2020-07-14 04:34:46 | Telangana, India | ||
2158920 | 2158920 | 2020-07-14 | India | Telangana | 37745 | 375 | 24840 | 12530 | 18.1124 | 79.0193 | 2020-07-15 04:34:39 | Telangana, India | ||
2748276 | 2748276 | 2020-07-15 | India | Telangana | 39342 | 386 | 25999 | 12957 | 18.1124 | 79.0193 | 2020-07-16 04:44:59 | Telangana, India | ||
367608 | 367608 | 2020-07-16 | India | Telangana | 41018 | 396 | 27295 | 13327 | 18.1124 | 79.0193 | 2020-07-17 04:34:50 | Telangana, India | ||
2708798 | 2708798 | 2020-07-17 | India | Telangana | 42496 | 403 | 28705 | 13388 | 18.1124 | 79.0193 | 2020-07-18 04:34:45 | Telangana, India | ||
3205496 | 3205496 | 2020-07-18 | India | Telangana | 43780 | 409 | 30607 | 12764 | 18.1124 | 79.0193 | 2020-07-19 04:34:58 | Telangana, India | ||
122107 | 122107 | 2020-07-19 | India | Telangana | 45076 | 415 | 32438 | 12223 | 18.1124 | 79.0193 | 2020-07-20 05:34:40 | Telangana, India | ||
327202 | 327202 | 2020-07-20 | India | Telangana | 46274 | 422 | 34323 | 11529 | 18.1124 | 79.0193 | 2020-07-21 04:38:46 | Telangana, India | ||
1707711 | 1707711 | 2020-07-21 | India | Telangana | 47705 | 429 | 37385 | 9891 | 18.1124 | 79.0193 | 2020-07-22 04:34:42 | Telangana, India | ||
844972 | 844972 | 2020-07-22 | India | Telangana | 49259 | 438 | 37666 | 11155 | 18.1124 | 79.0193 | 2020-07-23 05:15:04 | Telangana, India | ||
62156 | 62156 | 2020-07-23 | India | Telangana | 50826 | 447 | 39327 | 11052 | 18.1124 | 79.0193 | 2020-07-24 05:30:40 | Telangana, India | ||
1503226 | 1503226 | 2020-07-25 | India | Telangana | 52466 | 455 | 40334 | 11677 | 18.1124 | 79.0193 | 2020-07-26 03:35:08 | Telangana, India | ||
2563952 | 2563952 | 2020-07-24 | India | Telangana | 52466 | 455 | 40334 | 11677 | 18.1124 | 79.0193 | 2020-07-25 04:47:39 | Telangana, India | ||
177670 | 177670 | 2020-07-27 | India | Telangana | 54059 | 463 | 41332 | 12264 | 18.1124 | 79.0193 | 2020-07-28 03:35:13 | Telangana, India | ||
442738 | 442738 | 2020-07-26 | India | Telangana | 54059 | 463 | 41332 | 12264 | 18.1124 | 79.0193 | 2020-07-27 04:35:02 | Telangana, India | ||
1928835 | 1928835 | 2020-07-30 | India | Telangana | 57142 | 480 | 42909 | 13753 | 18.1124 | 79.0193 | 2020-07-30 03:35:26 | Telangana, India | ||
2959003 | 2959003 | 2020-07-29 | India | Telangana | 57142 | 480 | 42909 | 13753 | 18.1124 | 79.0193 | 2020-07-30 03:35:26 | Telangana, India | ||
3185374 | 3185374 | 2020-07-28 | India | Telangana | 57142 | 480 | 42909 | 13753 | 18.1124 | 79.0193 | 2020-07-29 04:35:11 | Telangana, India | ||
3264883 | 3264883 | 2020-07-31 | India | Telangana | 62703 | 519 | 45388 | 16796 | 18.1124 | 79.0193 | 2020-08-01 04:36:27 | Telangana, India | ||
753718 | 753718 | 2020-08-01 | India | Telangana | 64786 | 530 | 46502 | 17754 | 18.1124 | 79.0193 | 2020-08-02 04:34:47 | Telangana, India | ||
2808150 | 2808150 | 2020-08-02 | India | Telangana | 66677 | 540 | 47590 | 18547 | 18.1124 | 79.0193 | 2020-08-03 04:34:35 | Telangana, India | ||
2740398 | 2740398 | 2020-08-03 | India | Telangana | 68946 | 563 | 49675 | 18708 | 18.1124 | 79.0193 | 2020-08-04 04:41:59 | Telangana, India | ||
98515 | 98515 | 2020-08-04 | India | Telangana | 70958 | 576 | 50814 | 19568 | 18.1124 | 79.0193 | 2020-08-05 04:34:43 | Telangana, India | ||
3793279 | 3793279 | 2020-08-05 | India | Telangana | 73050 | 589 | 52103 | 20358 | 18.1124 | 79.0193 | 2020-08-06 04:35:02 | Telangana, India | ||
3612449 | 3612449 | 2020-08-06 | India | Telangana | 75257 | 601 | 53239 | 21417 | 18.1124 | 79.0193 | 2020-08-07 04:35:11 | Telangana, India | ||
458764 | 458764 | 2020-08-07 | India | Telangana | 77513 | 615 | 54330 | 22568 | 18.1124 | 79.0193 | 2020-08-08 04:34:53 | Telangana, India | ||
371580 | 371580 | 2020-08-08 | India | Telangana | 79495 | 627 | 55999 | 22869 | 18.1124 | 79.0193 | 2020-08-09 04:34:54 | Telangana, India | ||
3923412 | 3923412 | 2020-08-09 | India | Telangana | 80751 | 637 | 57586 | 22528 | 18.1124 | 79.0193 | 2020-08-10 04:34:55 | Telangana, India | ||
1920603 | 1920603 | 2020-08-10 | India | Telangana | 82647 | 645 | 59374 | 22628 | 18.1124 | 79.0193 | 2020-08-11 04:35:08 | Telangana, India | ||
662266 | 662266 | 2020-08-11 | India | Telangana | 84544 | 654 | 61294 | 22596 | 18.1124 | 79.0193 | 2020-08-12 04:27:29 | Telangana, India | ||
3531417 | 3531417 | 2020-08-12 | India | Telangana | 86475 | 665 | 63074 | 22736 | 18.1124 | 79.0193 | 2020-08-13 04:29:15 | Telangana, India | ||
582798 | 582798 | 2020-08-13 | India | Telangana | 88396 | 674 | 64284 | 23438 | 18.1124 | 79.0193 | 2020-08-14 04:51:19 | Telangana, India | ||
1612214 | 1612214 | 2020-08-14 | India | Telangana | 90259 | 684 | 66196 | 23379 | 18.1124 | 79.0193 | 2020-08-15 04:27:31 | Telangana, India | ||
145939 | 145939 | 2020-08-15 | India | Telangana | 91361 | 693 | 68126 | 22542 | 18.1124 | 79.0193 | 2020-08-16 04:27:42 | Telangana, India | ||
1555937 | 1555937 | 2020-08-16 | India | Telangana | 92255 | 703 | 70132 | 21420 | 18.1124 | 79.0193 | 2020-08-17 04:27:20 | Telangana, India | ||
837579 | 837579 | 2020-08-17 | India | Telangana | 93937 | 711 | 72202 | 21024 | 18.1124 | 79.0193 | 2020-08-18 04:27:56 | Telangana, India | ||
3177975 | 3177975 | 2020-08-18 | India | Telangana | 95700 | 719 | 73991 | 20990 | 18.1124 | 79.0193 | 2020-08-19 04:27:00 | Telangana, India | ||
206221 | 206221 | 2020-08-19 | India | Telangana | 97424 | 729 | 75186 | 21509 | 18.1124 | 79.0193 | 2020-08-20 04:27:43 | Telangana, India | ||
3484272 | 3484272 | 2020-08-20 | India | Telangana | 99391 | 737 | 76967 | 21687 | 18.1124 | 79.0193 | 2020-08-21 04:27:41 | Telangana, India | ||
1479523 | 1479523 | 2020-08-21 | India | Telangana | 101865 | 744 | 78735 | 22386 | 18.1124 | 79.0193 | 2020-08-22 04:27:49 | Telangana, India | ||
2299416 | 2299416 | 2020-08-22 | India | Telangana | 104249 | 755 | 80586 | 22908 | 18.1124 | 79.0193 | 2020-08-23 04:27:48 | Telangana, India | ||
2215634 | 2215634 | 2020-08-23 | India | Telangana | 106091 | 761 | 82411 | 22919 | 18.1124 | 79.0193 | 2020-08-24 04:27:56 | Telangana, India | ||
2991239 | 2991239 | 2020-08-24 | India | Telangana | 108670 | 770 | 84163 | 23737 | 18.1124 | 79.0193 | 2020-08-25 04:28:02 | Telangana, India | ||
3562535 | 3562535 | 2020-08-25 | India | Telangana | 111688 | 780 | 85223 | 25685 | 18.1124 | 79.0193 | 2020-08-26 04:28:11 | Telangana, India | ||
1996611 | 1996611 | 2020-08-26 | India | Telangana | 114483 | 788 | 86095 | 27600 | 18.1124 | 79.0193 | 2020-08-27 04:28:15 | Telangana, India | ||
2510151 | 2510151 | 2020-08-27 | India | Telangana | 117415 | 799 | 87675 | 28941 | 18.1124 | 79.0193 | 2020-08-28 04:28:11 | Telangana, India | ||
1523150 | 1523150 | 2020-08-28 | India | Telangana | 120166 | 808 | 89350 | 30008 | 18.1124 | 79.0193 | 2020-08-29 04:28:19 | Telangana, India | ||
609655 | 609655 | 2020-08-29 | India | Telangana | 123090 | 818 | 90988 | 31284 | 18.1124 | 79.0193 | 2020-08-30 04:28:22 | Telangana, India | ||
3931993 | 3931993 | 2020-08-30 | India | Telangana | 124963 | 827 | 92837 | 31299 | 18.1124 | 79.0193 | 2020-08-31 04:28:27 | Telangana, India | ||
194034 | 194034 | 2020-08-31 | India | Telangana | 127697 | 836 | 95162 | 31699 | 18.1124 | 79.0193 | 2020-09-01 04:28:31 | Telangana, India | ||
2059849 | 2059849 | 2020-09-01 | India | Telangana | 130589 | 846 | 97402 | 32341 | 18.1124 | 79.0193 | 2020-09-02 04:28:25 | Telangana, India | ||
1105520 | 1105520 | 2020-09-02 | India | Telangana | 133406 | 856 | 100013 | 32537 | 18.1124 | 79.0193 | 2020-09-03 04:28:22 | Telangana, India | ||
1354283 | 1354283 | 2020-09-03 | India | Telangana | 135884 | 866 | 102024 | 32994 | 18.1124 | 79.0193 | 2020-09-04 04:28:26 | Telangana, India | ||
2661743 | 2661743 | 2020-09-04 | India | Telangana | 138395 | 877 | 104603 | 32915 | 18.1124 | 79.0193 | 2020-09-05 04:28:19 | Telangana, India | ||
813543 | 813543 | 2020-09-05 | India | Telangana | 140969 | 886 | 107530 | 32553 | 18.1124 | 79.0193 | 2020-09-06 04:28:33 | Telangana, India | ||
3161588 | 3161588 | 2020-09-06 | India | Telangana | 142771 | 895 | 110241 | 31635 | 18.1124 | 79.0193 | 2020-09-07 04:28:30 | Telangana, India | ||
427303 | 427303 | 2020-09-07 | India | Telangana | 145163 | 906 | 112587 | 31670 | 18.1124 | 79.0193 | 2020-09-08 04:28:25 | Telangana, India | ||
1243724 | 1243724 | 2020-09-08 | India | Telangana | 147642 | 916 | 115072 | 31654 | 18.1124 | 79.0193 | 2020-09-09 04:28:48 | Telangana, India | ||
2171515 | 2171515 | 2020-09-09 | India | Telangana | 150176 | 927 | 117143 | 32106 | 18.1124 | 79.0193 | 2020-09-10 04:29:01 | Telangana, India | ||
1173150 | 1173150 | 2020-09-10 | India | Telangana | 152602 | 940 | 119467 | 32195 | 18.1124 | 79.0193 | 2020-09-11 04:46:23 | Telangana, India | ||
1444549 | 1444549 | 2020-09-11 | India | Telangana | 154880 | 950 | 121925 | 32005 | 18.1124 | 79.0193 | 2020-09-12 04:25:05 | Telangana, India | ||
546720 | 546720 | 2020-09-12 | India | Telangana | 157096 | 961 | 124528 | 31607 | 18.1124 | 79.0193 | 2020-09-13 04:30:52 | Telangana, India | ||
344242 | 344242 | 2020-09-14 | India | Telangana | 158513 | 974 | 127007 | 30532 | 18.1124 | 79.0193 | 2020-09-15 03:22:50 | Telangana, India | ||
2868681 | 2868681 | 2020-09-13 | India | Telangana | 158513 | 974 | 127007 | 30532 | 18.1124 | 79.0193 | 2020-09-14 04:26:00 | Telangana, India | ||
2728970 | 2728970 | 2020-09-15 | India | Telangana | 162844 | 996 | 131447 | 30401 | 18.1124 | 79.0193 | 2020-09-16 04:22:53 | Telangana, India | ||
666245 | 666245 | 2020-09-16 | India | Telangana | 165003 | 1005 | 133555 | 30443 | 18.1124 | 79.0193 | 2020-09-17 04:22:00 | Telangana, India | ||
1121556 | 1121556 | 2020-09-17 | India | Telangana | 167046 | 1016 | 135357 | 30673 | 18.1124 | 79.0193 | 2020-09-18 05:05:00 | Telangana, 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]);