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 = "Andhra Pradesh" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908115 | 908115 | 2021-01-19 | India | Andhra Pradesh | 886245 | 7142 | 877443 | 1660 | 15.9129 | 79.74 | 2021-01-20 05:21:54 | Andhra Pradesh, India | ||
237178 | 237178 | 2021-01-18 | India | Andhra Pradesh | 886066 | 7141 | 877212 | 1713 | 15.9129 | 79.74 | 2021-01-19 05:22:15 | Andhra Pradesh, India | ||
3503295 | 3503295 | 2021-01-17 | India | Andhra Pradesh | 885985 | 7140 | 876949 | 1896 | 15.9129 | 79.74 | 2021-01-18 05:22:34 | Andhra Pradesh, India | ||
3101378 | 3101378 | 2021-01-16 | India | Andhra Pradesh | 885824 | 7139 | 876698 | 1987 | 15.9129 | 79.74 | 2021-01-17 05:22:17 | Andhra Pradesh, India | ||
3515340 | 3515340 | 2021-01-15 | India | Andhra Pradesh | 885710 | 7139 | 876372 | 2199 | 15.9129 | 79.74 | 2021-01-16 05:22:40 | Andhra Pradesh, India | ||
3879513 | 3879513 | 2021-01-14 | India | Andhra Pradesh | 885616 | 7138 | 876140 | 2338 | 15.9129 | 79.74 | 2021-01-15 17:22 | Andhra Pradesh, India | ||
3308140 | 3308140 | 2021-01-13 | India | Andhra Pradesh | 885437 | 7134 | 875921 | 2382 | 15.9129 | 79.74 | 2021-01-14 05:22:32 | Andhra Pradesh, India | ||
774285 | 774285 | 2021-01-12 | India | Andhra Pradesh | 885234 | 7133 | 875690 | 2411 | 15.9129 | 79.74 | 2021-01-13 05:22:15 | Andhra Pradesh, India | ||
190006 | 190006 | 2021-01-11 | India | Andhra Pradesh | 885037 | 7131 | 875456 | 2450 | 15.9129 | 79.74 | 2021-01-12 05:22:15 | Andhra Pradesh, India | ||
2625809 | 2625809 | 2021-01-10 | India | Andhra Pradesh | 884916 | 7129 | 875243 | 2544 | 15.9129 | 79.74 | 2021-01-11 05:21:50 | Andhra Pradesh, India | ||
3899897 | 3899897 | 2021-01-09 | India | Andhra Pradesh | 884689 | 7128 | 874954 | 2607 | 15.9129 | 79.74 | 2021-01-10 05:22:12 | Andhra Pradesh, India | ||
153920 | 153920 | 2021-01-08 | India | Andhra Pradesh | 884171 | 7126 | 874223 | 2822 | 15.9129 | 79.74 | 2021-01-09 05:22:18 | Andhra Pradesh, India | ||
2541344 | 2541344 | 2021-01-07 | India | Andhra Pradesh | 884171 | 7126 | 874223 | 2822 | 15.9129 | 79.74 | 2021-01-08 05:22:42 | Andhra Pradesh, India | ||
2864653 | 2864653 | 2021-01-06 | India | Andhra Pradesh | 883876 | 7125 | 873855 | 2896 | 15.9129 | 79.74 | 2021-01-07 05:22:03 | Andhra Pradesh, India | ||
3034240 | 3034240 | 2021-01-05 | India | Andhra Pradesh | 883587 | 7122 | 873427 | 3038 | 15.9129 | 79.74 | 2021-01-06 05:22:16 | Andhra Pradesh, India | ||
1061785 | 1061785 | 2021-01-04 | India | Andhra Pradesh | 883210 | 7118 | 873149 | 2943 | 15.9129 | 79.74 | 2021-01-05 05:21:49 | Andhra Pradesh, India | ||
3230388 | 3230388 | 2021-01-03 | India | Andhra Pradesh | 883082 | 7115 | 872897 | 3070 | 15.9129 | 79.74 | 2021-01-04 05:22:02 | Andhra Pradesh, India | ||
2227457 | 2227457 | 2021-01-02 | India | Andhra Pradesh | 882850 | 7111 | 872545 | 3194 | 15.9129 | 79.74 | 2021-01-03 05:22:52 | Andhra Pradesh, India | ||
1136821 | 1136821 | 2021-01-01 | India | Andhra Pradesh | 882612 | 7108 | 871916 | 3588 | 15.9129 | 79.74 | 2021-01-02 05:22:33 | Andhra Pradesh, India | ||
3695427 | 3695427 | 2020-12-31 | India | Andhra Pradesh | 881948 | 7104 | 871588 | 3256 | 15.9129 | 79.74 | 2021-01-01 05:23:07 | Andhra Pradesh, India | ||
1010242 | 1010242 | 2020-12-30 | India | Andhra Pradesh | 881948 | 7104 | 871588 | 3256 | 15.9129 | 79.74 | 2020-12-31 05:22:49 | Andhra Pradesh, India | ||
766257 | 766257 | 2020-12-29 | India | Andhra Pradesh | 881599 | 7100 | 871116 | 3383 | 15.9129 | 79.74 | 2020-12-30 05:22:34 | Andhra Pradesh, India | ||
3761521 | 3761521 | 2020-12-28 | India | Andhra Pradesh | 881273 | 7098 | 870752 | 3423 | 15.9129 | 79.74 | 2020-12-29 05:22:37 | Andhra Pradesh, India | ||
3777841 | 3777841 | 2020-12-27 | India | Andhra Pradesh | 881061 | 7094 | 870342 | 3625 | 15.9129 | 79.74 | 2020-12-28 05:22:06 | Andhra Pradesh, India | ||
2223446 | 2223446 | 2020-12-26 | India | Andhra Pradesh | 880712 | 7092 | 869920 | 3700 | 15.9129 | 79.74 | 2020-12-27 05:22:55 | Andhra Pradesh, India | ||
202193 | 202193 | 2020-12-25 | India | Andhra Pradesh | 880430 | 7091 | 869478 | 3861 | 15.9129 | 79.74 | 2020-12-26 05:22:28 | Andhra Pradesh, India | ||
3691416 | 3691416 | 2020-12-24 | India | Andhra Pradesh | 880075 | 7089 | 869124 | 3862 | 15.9129 | 79.74 | 2020-12-25 05:22:48 | Andhra Pradesh, India | ||
2406768 | 2406768 | 2020-12-23 | India | Andhra Pradesh | 879718 | 7085 | 868769 | 3864 | 15.9129 | 79.74 | 2020-12-24 05:23:04 | Andhra Pradesh, India | ||
3769814 | 3769814 | 2020-12-22 | India | Andhra Pradesh | 879339 | 7082 | 868279 | 3978 | 15.9129 | 79.74 | 2020-12-23 05:22:03 | Andhra Pradesh, India | ||
927630 | 927630 | 2020-12-21 | India | Andhra Pradesh | 878937 | 7078 | 867867 | 3992 | 15.9129 | 79.74 | 2020-12-22 05:22:33 | Andhra Pradesh, India | ||
2119651 | 2119651 | 2020-12-20 | India | Andhra Pradesh | 878723 | 7076 | 867445 | 4202 | 15.9129 | 79.74 | 2020-12-21 05:27:58 | Andhra Pradesh, India | ||
2931158 | 2931158 | 2020-12-19 | India | Andhra Pradesh | 878285 | 7074 | 866856 | 4355 | 15.9129 | 79.74 | 2020-12-20 05:27:32 | Andhra Pradesh, India | ||
1901104 | 1901104 | 2020-12-18 | India | Andhra Pradesh | 877806 | 7070 | 866359 | 4377 | 15.9129 | 79.74 | 2020-12-19 05:27:52 | Andhra Pradesh, India | ||
2127930 | 2127930 | 2020-12-17 | India | Andhra Pradesh | 877348 | 7069 | 865825 | 4454 | 15.9129 | 79.74 | 2020-12-18 05:28:18 | Andhra Pradesh, India | ||
3149530 | 3149530 | 2020-12-16 | India | Andhra Pradesh | 876814 | 7067 | 865327 | 4420 | 15.9129 | 79.74 | 2020-12-17 05:28:12 | Andhra Pradesh, India | ||
1034311 | 1034311 | 2020-12-15 | India | Andhra Pradesh | 876336 | 7064 | 864612 | 4660 | 15.9129 | 79.74 | 2020-12-16 05:28:04 | Andhra Pradesh, India | ||
1751205 | 1751205 | 2020-12-14 | India | Andhra Pradesh | 875836 | 7059 | 864049 | 4728 | 15.9129 | 79.74 | 2020-12-15 05:26:38 | Andhra Pradesh, India | ||
3847725 | 3847725 | 2020-12-13 | India | Andhra Pradesh | 875531 | 7057 | 863508 | 4966 | 15.9129 | 79.74 | 2020-12-14 05:26:27 | Andhra Pradesh, India | ||
845507 | 845507 | 2020-12-12 | India | Andhra Pradesh | 875025 | 7052 | 862895 | 5078 | 15.9129 | 79.74 | 2020-12-13 05:27:20 | Andhra Pradesh, India | ||
860614 | 860614 | 2020-12-11 | India | Andhra Pradesh | 874515 | 7049 | 862230 | 5236 | 15.9129 | 79.74 | 2020-12-12 05:26:19 | Andhra Pradesh, India | ||
1600156 | 1600156 | 2020-12-10 | India | Andhra Pradesh | 873995 | 7047 | 861711 | 5237 | 15.9129 | 79.74 | 2020-12-11 05:26:59 | Andhra Pradesh, India | ||
2975165 | 2975165 | 2020-12-09 | India | Andhra Pradesh | 873457 | 7045 | 861153 | 5259 | 15.9129 | 79.74 | 2020-12-10 05:26:19 | Andhra Pradesh, India | ||
1818725 | 1818725 | 2020-12-08 | India | Andhra Pradesh | 872839 | 7042 | 860368 | 5429 | 15.9129 | 79.74 | 2020-12-09 05:28:01 | Andhra Pradesh, India | ||
2347361 | 2347361 | 2020-12-07 | India | Andhra Pradesh | 872288 | 7038 | 859624 | 5626 | 15.9129 | 79.74 | 2020-12-08 05:27:42 | Andhra Pradesh, India | ||
1006231 | 1006231 | 2020-12-06 | India | Andhra Pradesh | 871972 | 7033 | 859029 | 5910 | 15.9129 | 79.74 | 2020-12-07 05:26:14 | Andhra Pradesh, India | ||
1632240 | 1632240 | 2020-12-05 | India | Andhra Pradesh | 871305 | 7024 | 858115 | 6166 | 15.9129 | 79.74 | 2020-12-06 05:26:18 | Andhra Pradesh, India | ||
3859768 | 3859768 | 2020-12-04 | India | Andhra Pradesh | 870675 | 7020 | 857233 | 6422 | 15.9129 | 79.74 | 2020-12-05 05:27:36 | Andhra Pradesh, India | ||
75026 | 75026 | 2020-12-03 | India | Andhra Pradesh | 870076 | 7014 | 856320 | 6742 | 15.9129 | 79.74 | 2020-12-04 05:27:27 | Andhra Pradesh, India | ||
738238 | 738238 | 2020-12-02 | India | Andhra Pradesh | 869412 | 7003 | 855485 | 6924 | 15.9129 | 79.74 | 2020-12-03 05:28:22 | Andhra Pradesh, India | ||
2537332 | 2537332 | 2020-12-01 | India | Andhra Pradesh | 868749 | 6996 | 854326 | 7427 | 15.9129 | 79.74 | 2020-12-02 05:27:41 | Andhra Pradesh, India | ||
1584101 | 1584101 | 2020-11-30 | India | Andhra Pradesh | 868064 | 6992 | 853232 | 7840 | 15.9129 | 79.74 | 2020-12-01 05:26:18 | Andhra Pradesh, India | ||
3566504 | 3566504 | 2020-11-29 | India | Andhra Pradesh | 867683 | 6988 | 852298 | 8397 | 15.9129 | 79.74 | 2020-11-30 05:26:13 | Andhra Pradesh, India | ||
2935169 | 2935169 | 2020-11-28 | India | Andhra Pradesh | 867063 | 6981 | 848511 | 11571 | 15.9129 | 79.74 | 2020-11-29 05:25:55 | Andhra Pradesh, India | ||
392172 | 392172 | 2020-11-27 | India | Andhra Pradesh | 866438 | 6976 | 847325 | 12137 | 15.9129 | 79.74 | 2020-11-28 05:25:50 | Andhra Pradesh, India | ||
923619 | 923619 | 2020-11-26 | India | Andhra Pradesh | 865705 | 6970 | 846120 | 12615 | 15.9129 | 79.74 | 2020-11-27 05:26:53 | Andhra Pradesh, India | ||
1972524 | 1972524 | 2020-11-25 | India | Andhra Pradesh | 864674 | 6962 | 845039 | 12673 | 15.9129 | 79.74 | 2020-11-26 05:27:44 | Andhra Pradesh, India | ||
1350255 | 1350255 | 2020-11-24 | India | Andhra Pradesh | 863843 | 6956 | 843863 | 13024 | 15.9129 | 79.74 | 2020-11-25 05:27:20 | Andhra Pradesh, India | ||
678249 | 678249 | 2020-11-23 | India | Andhra Pradesh | 862758 | 6948 | 842416 | 13394 | 15.9129 | 79.74 | 2020-11-24 05:27:31 | Andhra Pradesh, India | ||
3189925 | 3189925 | 2020-11-22 | India | Andhra Pradesh | 862213 | 6938 | 841026 | 14249 | 15.9129 | 79.74 | 2020-11-23 05:25:26 | Andhra Pradesh, India | ||
3836419 | 3836419 | 2020-11-21 | India | Andhra Pradesh | 861092 | 6927 | 839395 | 14770 | 15.9129 | 79.74 | 2020-11-22 05:25:45 | Andhra Pradesh, India | ||
2701447 | 2701447 | 2020-11-20 | India | Andhra Pradesh | 859932 | 6920 | 837630 | 15382 | 15.9129 | 79.74 | 2020-11-21 05:25:51 | Andhra Pradesh, India | ||
821507 | 821507 | 2020-11-19 | India | Andhra Pradesh | 858711 | 6910 | 835801 | 16000 | 15.9129 | 79.74 | 2020-11-20 05:26:28 | Andhra Pradesh, India | ||
122641 | 122641 | 2020-11-18 | India | Andhra Pradesh | 857395 | 6899 | 833980 | 16516 | 15.9129 | 79.74 | 2020-11-19 05:25:23 | Andhra Pradesh, India | ||
3338529 | 3338529 | 2020-11-17 | India | Andhra Pradesh | 856159 | 6890 | 832284 | 16985 | 15.9129 | 79.74 | 2020-11-18 05:40:31 | Andhra Pradesh, India | ||
3169574 | 3169574 | 2020-11-16 | India | Andhra Pradesh | 854764 | 6881 | 829991 | 17892 | 15.9129 | 79.74 | 2020-11-17 05:25:54 | Andhra Pradesh, India | ||
2880142 | 2880142 | 2020-11-15 | India | Andhra Pradesh | 854011 | 6868 | 828484 | 18659 | 15.9129 | 79.74 | 2020-11-16 05:25:57 | Andhra Pradesh, India | ||
2915120 | 2915120 | 2020-11-14 | India | Andhra Pradesh | 852955 | 6854 | 826344 | 19757 | 15.9129 | 79.74 | 2020-11-15 05:26:53 | Andhra Pradesh, India | ||
2784942 | 2784942 | 2020-11-13 | India | Andhra Pradesh | 851298 | 6847 | 824189 | 20262 | 15.9129 | 79.74 | 2020-11-14 05:25:37 | Andhra Pradesh, India | ||
864707 | 864707 | 2020-11-12 | India | Andhra Pradesh | 849705 | 6837 | 822011 | 20857 | 15.9129 | 79.74 | 2020-11-13 05:25:30 | Andhra Pradesh, India | ||
3440752 | 3440752 | 2020-11-11 | India | Andhra Pradesh | 847977 | 6828 | 820234 | 20915 | 15.9129 | 79.74 | 2020-11-12 05:25:55 | Andhra Pradesh, India | ||
272092 | 272092 | 2020-11-10 | India | Andhra Pradesh | 846245 | 6814 | 818473 | 20958 | 15.9129 | 79.74 | 2020-11-11 05:25:30 | Andhra Pradesh, India | ||
1988569 | 1988569 | 2020-11-09 | India | Andhra Pradesh | 844359 | 6802 | 816322 | 21235 | 15.9129 | 79.74 | 2020-11-10 05:40:07 | Andhra Pradesh, India | ||
1728421 | 1728421 | 2020-11-08 | India | Andhra Pradesh | 842967 | 6791 | 814773 | 21403 | 15.9129 | 79.74 | 2020-11-09 05:25:45 | Andhra Pradesh, India | ||
1543881 | 1543881 | 2020-11-07 | India | Andhra Pradesh | 840730 | 6779 | 812517 | 21434 | 15.9129 | 79.74 | 2020-11-08 05:24:56 | Andhra Pradesh, India | ||
376119 | 376119 | 2020-11-06 | India | Andhra Pradesh | 838363 | 6768 | 809770 | 21825 | 15.9129 | 79.74 | 2020-11-07 05:24:52 | Andhra Pradesh, India | ||
892057 | 892057 | 2020-11-05 | India | Andhra Pradesh | 835953 | 6757 | 807318 | 21878 | 15.9129 | 79.74 | 2020-11-06 05:24:55 | Andhra Pradesh, India | ||
2919119 | 2919119 | 2020-11-04 | India | Andhra Pradesh | 833208 | 6744 | 805026 | 21438 | 15.9129 | 79.74 | 2020-11-05 06:05:03 | Andhra Pradesh, India | ||
2497956 | 2497956 | 2020-11-03 | India | Andhra Pradesh | 830731 | 6734 | 802325 | 21672 | 15.9129 | 79.74 | 2020-11-04 05:25:09 | Andhra Pradesh, India | ||
3304131 | 3304131 | 2020-11-02 | India | Andhra Pradesh | 827882 | 6719 | 798625 | 22538 | 15.9129 | 79.74 | 2020-11-03 06:00:16 | Andhra Pradesh, India | ||
3409380 | 3409380 | 2020-11-01 | India | Andhra Pradesh | 825966 | 6706 | 795592 | 23668 | 15.9129 | 79.74 | 2020-11-02 05:25:04 | Andhra Pradesh, India | ||
2079869 | 2079869 | 2020-10-31 | India | Andhra Pradesh | 823348 | 6690 | 792083 | 24575 | 15.9129 | 79.74 | 2020-11-01 04:36:19 | Andhra Pradesh, India | ||
2243322 | 2243322 | 2020-10-30 | India | Andhra Pradesh | 820565 | 6676 | 788375 | 25514 | 15.9129 | 79.74 | 2020-10-31 04:24:44 | Andhra Pradesh, India | ||
210177 | 210177 | 2020-10-29 | India | Andhra Pradesh | 817679 | 6659 | 784752 | 26268 | 15.9129 | 79.74 | 2020-10-30 04:24:49 | Andhra Pradesh, India | ||
754239 | 754239 | 2020-10-28 | India | Andhra Pradesh | 814774 | 6643 | 781509 | 26622 | 15.9129 | 79.74 | 2020-10-29 04:24:49 | Andhra Pradesh, India | ||
1452524 | 1452524 | 2020-10-27 | India | Andhra Pradesh | 811825 | 6625 | 777900 | 27300 | 15.9129 | 79.74 | 2020-10-28 04:24:39 | Andhra Pradesh, India | ||
3480248 | 3480248 | 2020-10-26 | India | Andhra Pradesh | 808924 | 6606 | 773548 | 28770 | 15.9129 | 79.74 | 2020-10-27 04:24:45 | Andhra Pradesh, India | ||
8269 | 8269 | 2020-10-25 | India | Andhra Pradesh | 807023 | 6587 | 769576 | 30860 | 15.9129 | 79.74 | 2020-10-26 04:25:02 | Andhra Pradesh, India | ||
3651506 | 3651506 | 2020-10-24 | India | Andhra Pradesh | 804026 | 6566 | 765991 | 31469 | 15.9129 | 79.74 | 2020-10-25 04:24:36 | Andhra Pradesh, India | ||
1053761 | 1053761 | 2020-10-23 | India | Andhra Pradesh | 800684 | 6544 | 762419 | 31721 | 15.9129 | 79.74 | 2020-10-24 04:24:46 | Andhra Pradesh, India | ||
1177431 | 1177431 | 2020-10-22 | India | Andhra Pradesh | 796919 | 6524 | 758138 | 32257 | 15.9129 | 79.74 | 2020-10-23 04:24:46 | Andhra Pradesh, India | ||
2191536 | 2191536 | 2020-10-21 | India | Andhra Pradesh | 793299 | 6508 | 754415 | 32376 | 15.9129 | 79.74 | 2020-10-22 04:24:27 | Andhra Pradesh, India | ||
3990547 | 3990547 | 2020-10-20 | India | Andhra Pradesh | 789553 | 6481 | 749676 | 33396 | 15.9129 | 79.74 | 2020-10-21 04:24:14 | Andhra Pradesh, India | ||
1794567 | 1794567 | 2020-10-19 | India | Andhra Pradesh | 786050 | 6453 | 744532 | 35065 | 15.9129 | 79.74 | 2020-10-20 04:24:22 | Andhra Pradesh, India | ||
762251 | 762251 | 2020-10-18 | India | Andhra Pradesh | 783132 | 6429 | 740229 | 36474 | 15.9129 | 79.74 | 2020-10-19 04:24:16 | Andhra Pradesh, India | ||
1026289 | 1026289 | 2020-10-17 | India | Andhra Pradesh | 779146 | 6406 | 735638 | 37102 | 15.9129 | 79.74 | 2020-10-18 04:24:25 | Andhra Pradesh, India | ||
2856784 | 2856784 | 2020-10-16 | India | Andhra Pradesh | 775470 | 6382 | 730109 | 38979 | 15.9129 | 79.74 | 2020-10-17 04:24:12 | Andhra Pradesh, India | ||
786314 | 786314 | 2020-10-15 | India | Andhra Pradesh | 771503 | 6357 | 725099 | 40047 | 15.9129 | 79.74 | 2020-10-16 04:24:01 | Andhra Pradesh, India | ||
79025 | 79025 | 2020-10-14 | India | Andhra Pradesh | 767465 | 6319 | 719477 | 41669 | 15.9129 | 79.74 | 2020-10-15 04:24:28 | Andhra Pradesh, India | ||
3781840 | 3781840 | 2020-10-13 | India | Andhra Pradesh | 763573 | 6291 | 714427 | 42855 | 15.9129 | 79.74 | 2020-10-14 04:24:05 | Andhra Pradesh, India | ||
2291380 | 2291380 | 2020-10-12 | India | Andhra Pradesh | 758951 | 6256 | 708712 | 43983 | 15.9129 | 79.74 | 2020-10-13 04:24:02 | Andhra Pradesh, 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]);