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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687402 | 3687402 | 2022-01-13 | India | Andhra Pradesh | 2087879 | 14505 | 0 | 15.9129 | 79.74 | 2022-01-14 04:21:54 | Andhra Pradesh, India | |||
3612986 | 3612986 | 2022-01-12 | India | Andhra Pradesh | 2087879 | 14505 | 0 | 15.9129 | 79.74 | 2022-01-13 08:00:09 | Andhra Pradesh, India | |||
1113511 | 1113511 | 2022-01-11 | India | Andhra Pradesh | 2082843 | 14505 | 0 | 15.9129 | 79.74 | 2022-01-12 04:21:44 | Andhra Pradesh, India | |||
1692239 | 1692239 | 2022-01-10 | India | Andhra Pradesh | 2082843 | 14505 | 0 | 15.9129 | 79.74 | 2022-01-11 04:22:01 | Andhra Pradesh, India | |||
126654 | 126654 | 2022-01-09 | India | Andhra Pradesh | 2081859 | 14505 | 0 | 15.9129 | 79.74 | 2022-01-10 04:22:07 | Andhra Pradesh, India | |||
1215489 | 1215489 | 2022-01-08 | India | Andhra Pradesh | 2080602 | 14503 | 0 | 15.9129 | 79.74 | 2022-01-09 04:21:46 | Andhra Pradesh, India | |||
1389582 | 1389582 | 2022-01-07 | India | Andhra Pradesh | 2079763 | 14501 | 0 | 15.9129 | 79.74 | 2022-01-08 04:21:53 | Andhra Pradesh, India | |||
2609969 | 2609969 | 2022-01-06 | India | Andhra Pradesh | 2078923 | 14500 | 0 | 15.9129 | 79.74 | 2022-01-07 04:22:09 | Andhra Pradesh, India | |||
1281911 | 1281911 | 2022-01-05 | India | Andhra Pradesh | 2078376 | 14499 | 0 | 15.9129 | 79.74 | 2022-01-06 04:22:09 | Andhra Pradesh, India | |||
1285927 | 1285927 | 2022-01-04 | India | Andhra Pradesh | 2077942 | 14499 | 0 | 15.9129 | 79.74 | 2022-01-05 04:21:59 | Andhra Pradesh, India | |||
1700271 | 1700271 | 2022-01-03 | India | Andhra Pradesh | 2077608 | 14498 | 0 | 15.9129 | 79.74 | 2022-01-04 04:22:17 | Andhra Pradesh, India | |||
3519354 | 3519354 | 2022-01-02 | India | Andhra Pradesh | 2077486 | 14497 | 0 | 15.9129 | 79.74 | 2022-01-03 02:22:25 | Andhra Pradesh, India | |||
2167484 | 2167484 | 2022-01-01 | India | Andhra Pradesh | 2077321 | 14495 | 0 | 15.9129 | 79.74 | 2022-01-02 04:20:52 | Andhra Pradesh, India | |||
2776915 | 2776915 | 2021-12-31 | India | Andhra Pradesh | 2077145 | 14495 | 0 | 15.9129 | 79.74 | 2022-01-01 04:22:14 | Andhra Pradesh, India | |||
3998572 | 3998572 | 2021-12-30 | India | Andhra Pradesh | 2076979 | 14493 | 0 | 15.9129 | 79.74 | 2021-12-31 04:21:50 | Andhra Pradesh, India | |||
1668379 | 1668379 | 2021-12-29 | India | Andhra Pradesh | 2076849 | 14492 | 0 | 15.9129 | 79.74 | 2021-12-30 04:21:25 | Andhra Pradesh, India | |||
1432488 | 1432488 | 2021-12-28 | India | Andhra Pradesh | 2076687 | 14492 | 0 | 15.9129 | 79.74 | 2021-12-29 03:21:43 | Andhra Pradesh, India | |||
730449 | 730449 | 2021-12-27 | India | Andhra Pradesh | 2076546 | 14490 | 0 | 15.9129 | 79.74 | 2021-12-28 04:21:47 | Andhra Pradesh, India | |||
2111621 | 2111621 | 2021-12-26 | India | Andhra Pradesh | 2076492 | 14490 | 0 | 15.9129 | 79.74 | 2021-12-27 04:21:58 | Andhra Pradesh, India | |||
3604993 | 3604993 | 2021-12-25 | India | Andhra Pradesh | 2076410 | 14489 | 0 | 15.9129 | 79.74 | 2021-12-26 04:21:50 | Andhra Pradesh, India | |||
2963311 | 2963311 | 2021-12-24 | India | Andhra Pradesh | 2076306 | 14488 | 0 | 15.9129 | 79.74 | 2021-12-25 04:21:37 | Andhra Pradesh, India | |||
3816343 | 3816343 | 2021-12-23 | India | Andhra Pradesh | 2076212 | 14486 | 0 | 15.9129 | 79.74 | 2021-12-24 04:21:34 | Andhra Pradesh, India | |||
798351 | 798351 | 2021-12-22 | India | Andhra Pradesh | 2076077 | 14483 | 0 | 15.9129 | 79.74 | 2021-12-23 04:21:21 | Andhra Pradesh, India | |||
3828391 | 3828391 | 2021-12-21 | India | Andhra Pradesh | 2075974 | 14481 | 0 | 15.9129 | 79.74 | 2021-12-22 04:21:54 | Andhra Pradesh, India | |||
1254694 | 1254694 | 2021-12-20 | India | Andhra Pradesh | 2075879 | 14480 | 0 | 15.9129 | 79.74 | 2021-12-21 03:21:27 | Andhra Pradesh, India | |||
2903637 | 2903637 | 2021-12-19 | India | Andhra Pradesh | 2075804 | 14479 | 0 | 15.9129 | 79.74 | 2021-12-20 04:21:43 | Andhra Pradesh, India | |||
1258710 | 1258710 | 2021-12-18 | India | Andhra Pradesh | 2075546 | 14477 | 0 | 15.9129 | 79.74 | 2021-12-19 04:21:11 | Andhra Pradesh, India | |||
2398738 | 2398738 | 2021-12-17 | India | Andhra Pradesh | 2075419 | 14474 | 0 | 15.9129 | 79.74 | 2021-12-18 02:22:20 | Andhra Pradesh, India | |||
1716276 | 1716276 | 2021-12-16 | India | Andhra Pradesh | 2075419 | 14474 | 0 | 15.9129 | 79.74 | 2021-12-17 04:22:14 | Andhra Pradesh, India | |||
3496110 | 3496110 | 2021-12-15 | India | Andhra Pradesh | 2075271 | 14471 | 0 | 15.9129 | 79.74 | 2021-12-16 04:22:11 | Andhra Pradesh, India | |||
2087895 | 2087895 | 2021-12-14 | India | Andhra Pradesh | 2075108 | 14468 | 0 | 15.9129 | 79.74 | 2021-12-15 03:22:16 | Andhra Pradesh, India | |||
782312 | 782312 | 2021-12-13 | India | Andhra Pradesh | 2074976 | 14467 | 0 | 15.9129 | 79.74 | 2021-12-14 04:22:38 | Andhra Pradesh, India | |||
1660347 | 1660347 | 2021-12-12 | India | Andhra Pradesh | 2074868 | 14466 | 0 | 15.9129 | 79.74 | 2021-12-13 04:22:02 | Andhra Pradesh, India | |||
1664363 | 1664363 | 2021-12-11 | India | Andhra Pradesh | 2074708 | 14465 | 0 | 15.9129 | 79.74 | 2021-12-12 04:22:12 | Andhra Pradesh, India | |||
3655515 | 3655515 | 2021-12-10 | India | Andhra Pradesh | 2074552 | 14462 | 0 | 15.9129 | 79.74 | 2021-12-11 04:22:45 | Andhra Pradesh, India | |||
1077846 | 1077846 | 2021-12-09 | India | Andhra Pradesh | 2074410 | 14460 | 0 | 15.9129 | 79.74 | 2021-12-10 04:22:28 | Andhra Pradesh, India | |||
550695 | 550695 | 2021-12-08 | India | Andhra Pradesh | 2074217 | 14457 | 0 | 15.9129 | 79.74 | 2021-12-09 04:22:49 | Andhra Pradesh, India | |||
404215 | 404215 | 2021-12-07 | India | Andhra Pradesh | 2074036 | 14455 | 0 | 15.9129 | 79.74 | 2021-12-08 04:22:46 | Andhra Pradesh, India | |||
1030297 | 1030297 | 2021-12-06 | India | Andhra Pradesh | 2073852 | 14453 | 0 | 15.9129 | 79.74 | 2021-12-07 04:22:34 | Andhra Pradesh, India | |||
1740460 | 1740460 | 2021-12-05 | India | Andhra Pradesh | 2073730 | 14452 | 0 | 15.9129 | 79.74 | 2021-12-06 04:22:34 | Andhra Pradesh, India | |||
137892 | 137892 | 2021-12-04 | India | Andhra Pradesh | 2073390 | 14445 | 0 | 15.9129 | 79.74 | 2021-12-05 04:22:25 | Andhra Pradesh, India | |||
2195545 | 2195545 | 2021-12-03 | India | Andhra Pradesh | 2073390 | 14445 | 0 | 15.9129 | 79.74 | 2021-12-04 04:22:18 | Andhra Pradesh, India | |||
251 | 251 | 2021-12-02 | India | Andhra Pradesh | 2073252 | 14444 | 0 | 15.9129 | 79.74 | 2021-12-03 04:23:05 | Andhra Pradesh, India | |||
1144850 | 1144850 | 2021-12-01 | India | Andhra Pradesh | 2073093 | 14443 | 0 | 15.9129 | 79.74 | 2021-12-02 04:22:37 | Andhra Pradesh, India | |||
3401362 | 3401362 | 2021-11-30 | India | Andhra Pradesh | 2072909 | 14442 | 0 | 15.9129 | 79.74 | 2021-12-01 04:22:29 | Andhra Pradesh, India | |||
149905 | 149905 | 2021-11-29 | India | Andhra Pradesh | 2072725 | 14439 | 0 | 15.9129 | 79.74 | 2021-11-30 04:22:53 | Andhra Pradesh, India | |||
1231551 | 1231551 | 2021-11-28 | India | Andhra Pradesh | 2072624 | 14438 | 0 | 15.9129 | 79.74 | 2021-11-29 04:22:30 | Andhra Pradesh, India | |||
1358258 | 1358258 | 2021-11-27 | India | Andhra Pradesh | 2072446 | 14432 | 0 | 15.9129 | 79.74 | 2021-11-28 04:22:43 | Andhra Pradesh, India | |||
758249 | 758249 | 2021-11-26 | India | Andhra Pradesh | 2072198 | 14432 | 0 | 15.9129 | 79.74 | 2021-11-27 04:22:45 | Andhra Pradesh, India | |||
1802666 | 1802666 | 2021-11-25 | India | Andhra Pradesh | 2072014 | 14431 | 0 | 15.9129 | 79.74 | 2021-11-26 04:22:33 | Andhra Pradesh, India | |||
904100 | 904100 | 2021-11-24 | India | Andhra Pradesh | 2071831 | 14430 | 0 | 15.9129 | 79.74 | 2021-11-25 04:22:33 | Andhra Pradesh, India | |||
3069950 | 3069950 | 2021-11-23 | India | Andhra Pradesh | 2071567 | 14429 | 0 | 15.9129 | 79.74 | 2021-11-24 04:22:14 | Andhra Pradesh, India | |||
3749048 | 3749048 | 2021-11-22 | India | Andhra Pradesh | 2071371 | 14428 | 0 | 15.9129 | 79.74 | 2021-11-23 04:22:39 | Andhra Pradesh, India | |||
1014255 | 1014255 | 2021-11-21 | India | Andhra Pradesh | 2071244 | 14426 | 0 | 15.9129 | 79.74 | 2021-11-22 04:22:20 | Andhra Pradesh, India | |||
722419 | 722419 | 2021-11-20 | India | Andhra Pradesh | 2071070 | 14426 | 0 | 15.9129 | 79.74 | 2021-11-21 04:22:13 | Andhra Pradesh, India | |||
161949 | 161949 | 2021-11-19 | India | Andhra Pradesh | 2070906 | 14425 | 0 | 15.9129 | 79.74 | 2021-11-20 04:22:17 | Andhra Pradesh, India | |||
3288836 | 3288836 | 2021-11-18 | India | Andhra Pradesh | 2070738 | 14423 | 0 | 15.9129 | 79.74 | 2021-11-19 04:21:40 | Andhra Pradesh, India | |||
447292 | 447292 | 2021-11-17 | India | Andhra Pradesh | 2070516 | 14421 | 0 | 15.9129 | 79.74 | 2021-11-18 04:21:33 | Andhra Pradesh, India | |||
3342542 | 3342542 | 2021-11-16 | India | Andhra Pradesh | 2070286 | 14418 | 0 | 15.9129 | 79.74 | 2021-11-17 04:21:48 | Andhra Pradesh, India | |||
2287378 | 2287378 | 2021-11-15 | India | Andhra Pradesh | 2070095 | 14416 | 0 | 15.9129 | 79.74 | 2021-11-16 04:21:10 | Andhra Pradesh, India | |||
1322152 | 1322152 | 2021-11-14 | India | Andhra Pradesh | 2069978 | 14415 | 0 | 15.9129 | 79.74 | 2021-11-15 04:21:36 | Andhra Pradesh, India | |||
686278 | 686278 | 2021-11-13 | India | Andhra Pradesh | 2069770 | 14412 | 0 | 15.9129 | 79.74 | 2021-11-14 04:21:31 | Andhra Pradesh, India | |||
714387 | 714387 | 2021-11-12 | India | Andhra Pradesh | 2069614 | 14411 | 0 | 15.9129 | 79.74 | 2021-11-13 04:21:38 | Andhra Pradesh, India | |||
28337 | 28337 | 2021-11-11 | India | Andhra Pradesh | 2069352 | 14409 | 0 | 15.9129 | 79.74 | 2021-11-12 04:22:01 | Andhra Pradesh, India | |||
2844776 | 2844776 | 2021-11-10 | India | Andhra Pradesh | 2069066 | 14406 | 0 | 15.9129 | 79.74 | 2021-11-11 04:21:45 | Andhra Pradesh, India | |||
87046 | 87046 | 2021-11-09 | India | Andhra Pradesh | 2068718 | 14403 | 0 | 15.9129 | 79.74 | 2021-11-10 04:21:38 | Andhra Pradesh, India | |||
3639474 | 3639474 | 2021-11-08 | India | Andhra Pradesh | 2068487 | 14401 | 0 | 15.9129 | 79.74 | 2021-11-09 04:21:36 | Andhra Pradesh, India | |||
2000582 | 2000582 | 2021-11-07 | India | Andhra Pradesh | 2068241 | 14397 | 0 | 15.9129 | 79.74 | 2021-11-08 04:21:43 | Andhra Pradesh, India | |||
495573 | 495573 | 2021-11-06 | India | Andhra Pradesh | 2067921 | 14392 | 0 | 15.9129 | 79.74 | 2021-11-07 04:21:53 | Andhra Pradesh, India | |||
3121428 | 3121428 | 2021-11-05 | India | Andhra Pradesh | 2067706 | 14391 | 0 | 15.9129 | 79.74 | 2021-11-06 04:21:51 | Andhra Pradesh, India | |||
698326 | 698326 | 2021-11-04 | India | Andhra Pradesh | 2067556 | 14388 | 0 | 15.9129 | 79.74 | 2021-11-05 04:21:54 | Andhra Pradesh, India | |||
276104 | 276104 | 2021-11-03 | India | Andhra Pradesh | 2067255 | 14386 | 0 | 15.9129 | 79.74 | 2021-11-04 04:22:20 | Andhra Pradesh, India | |||
43629 | 43629 | 2021-11-02 | India | Andhra Pradesh | 2066929 | 14382 | 0 | 15.9129 | 79.74 | 2021-11-03 06:22:09 | Andhra Pradesh, India | |||
3511325 | 3511325 | 2021-11-01 | India | Andhra Pradesh | 2066670 | 14377 | 0 | 15.9129 | 79.74 | 2021-11-02 04:22:03 | Andhra Pradesh, India | |||
287917 | 287917 | 2021-10-31 | India | Andhra Pradesh | 2066450 | 14373 | 0 | 15.9129 | 79.74 | 2021-11-01 04:22:01 | Andhra Pradesh, India | |||
2720923 | 2720923 | 2021-10-30 | India | Andhra Pradesh | 2066065 | 14369 | 0 | 15.9129 | 79.74 | 2021-10-31 04:22:08 | Andhra Pradesh, India | |||
567025 | 567025 | 2021-10-29 | India | Andhra Pradesh | 2065716 | 14367 | 0 | 15.9129 | 79.74 | 2021-10-30 04:22:03 | Andhra Pradesh, India | |||
4267 | 4267 | 2021-10-28 | India | Andhra Pradesh | 2065235 | 14365 | 0 | 15.9129 | 79.74 | 2021-10-29 04:22:03 | Andhra Pradesh, India | |||
534657 | 534657 | 2021-10-27 | India | Andhra Pradesh | 2064854 | 14364 | 0 | 15.9129 | 79.74 | 2021-10-28 04:22:08 | Andhra Pradesh, India | |||
3492094 | 3492094 | 2021-10-26 | India | Andhra Pradesh | 2064287 | 14356 | 0 | 15.9129 | 79.74 | 2021-10-27 04:22:32 | Andhra Pradesh, India | |||
3793816 | 3793816 | 2021-10-25 | India | Andhra Pradesh | 2063872 | 14350 | 0 | 15.9129 | 79.74 | 2021-10-26 04:22:09 | Andhra Pradesh, India | |||
682262 | 682262 | 2021-10-24 | India | Andhra Pradesh | 2063577 | 14343 | 0 | 15.9129 | 79.74 | 2021-10-25 04:22:31 | Andhra Pradesh, India | |||
770270 | 770270 | 2021-10-23 | India | Andhra Pradesh | 2063177 | 14339 | 0 | 15.9129 | 79.74 | 2021-10-24 04:21:22 | Andhra Pradesh, India | |||
653917 | 653917 | 2021-10-22 | India | Andhra Pradesh | 2062781 | 14333 | 0 | 15.9129 | 79.74 | 2021-10-23 04:21:32 | Andhra Pradesh, India | |||
2123664 | 2123664 | 2021-10-21 | India | Andhra Pradesh | 2062303 | 14327 | 0 | 15.9129 | 79.74 | 2021-10-22 04:21:14 | Andhra Pradesh, India | |||
443276 | 443276 | 2021-10-20 | India | Andhra Pradesh | 2061810 | 14320 | 0 | 15.9129 | 79.74 | 2021-10-21 04:21:18 | Andhra Pradesh, India | |||
597595 | 597595 | 2021-10-19 | India | Andhra Pradesh | 2061287 | 14317 | 0 | 15.9129 | 79.74 | 2021-10-20 04:21:00 | Andhra Pradesh, India | |||
2043772 | 2043772 | 2021-10-18 | India | Andhra Pradesh | 2060804 | 14313 | 0 | 15.9129 | 79.74 | 2021-10-19 04:20:54 | Andhra Pradesh, India | |||
1909133 | 1909133 | 2021-10-17 | India | Andhra Pradesh | 2060472 | 14307 | 0 | 15.9129 | 79.74 | 2021-10-18 04:21:10 | Andhra Pradesh, India | |||
934722 | 934722 | 2021-10-16 | India | Andhra Pradesh | 2060040 | 14302 | 0 | 15.9129 | 79.74 | 2021-10-17 04:21:29 | Andhra Pradesh, India | |||
2943277 | 2943277 | 2021-10-15 | India | Andhra Pradesh | 2059708 | 14295 | 0 | 15.9129 | 79.74 | 2021-10-16 04:21:15 | Andhra Pradesh, India | |||
491557 | 491557 | 2021-10-14 | India | Andhra Pradesh | 2059122 | 14286 | 0 | 15.9129 | 79.74 | 2021-10-15 04:21:26 | Andhra Pradesh, India | |||
633845 | 633845 | 2021-10-13 | India | Andhra Pradesh | 2058582 | 14276 | 0 | 15.9129 | 79.74 | 2021-10-14 04:21:29 | Andhra Pradesh, India | |||
1491523 | 1491523 | 2021-10-12 | India | Andhra Pradesh | 2058065 | 14268 | 0 | 15.9129 | 79.74 | 2021-10-13 04:20:51 | Andhra Pradesh, India | |||
3007256 | 3007256 | 2021-10-11 | India | Andhra Pradesh | 2057562 | 14256 | 0 | 15.9129 | 79.74 | 2021-10-12 04:21:09 | Andhra Pradesh, India | |||
423272 | 423272 | 2021-10-10 | India | Andhra Pradesh | 2057252 | 14254 | 0 | 15.9129 | 79.74 | 2021-10-11 04:21:31 | Andhra Pradesh, India | |||
2876129 | 2876129 | 2021-10-09 | India | Andhra Pradesh | 2056628 | 14250 | 0 | 15.9129 | 79.74 | 2021-10-10 04:21:38 | Andhra Pradesh, India | |||
2959295 | 2959295 | 2021-10-08 | India | Andhra Pradesh | 2055999 | 14242 | 0 | 15.9129 | 79.74 | 2021-10-09 04:21:34 | Andhra Pradesh, India | |||
467333 | 467333 | 2021-10-07 | India | Andhra Pradesh | 2055306 | 14236 | 0 | 15.9129 | 79.74 | 2021-10-08 04:21:25 | Andhra Pradesh, India | |||
2458713 | 2458713 | 2021-10-06 | India | Andhra Pradesh | 2054663 | 14228 | 0 | 15.9129 | 79.74 | 2021-10-07 04:21:36 | 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]);