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 = "Puducherry" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908140 | 908140 | 2021-01-19 | India | Puducherry | 38706 | 643 | 37766 | 297 | 11.882658 | 78.86498 | 2021-01-20 05:21:54 | Puducherry, India | ||
237203 | 237203 | 2021-01-18 | India | Puducherry | 38669 | 643 | 37740 | 286 | 11.882658 | 78.86498 | 2021-01-19 05:22:15 | Puducherry, India | ||
3503320 | 3503320 | 2021-01-17 | India | Puducherry | 38646 | 642 | 37720 | 284 | 11.882658 | 78.86498 | 2021-01-18 05:22:34 | Puducherry, India | ||
3101403 | 3101403 | 2021-01-16 | India | Puducherry | 38611 | 642 | 37683 | 286 | 11.882658 | 78.86498 | 2021-01-17 05:22:17 | Puducherry, India | ||
3515365 | 3515365 | 2021-01-15 | India | Puducherry | 38595 | 640 | 37661 | 294 | 11.882658 | 78.86498 | 2021-01-16 05:22:40 | Puducherry, India | ||
3879538 | 3879538 | 2021-01-14 | India | Puducherry | 38567 | 640 | 37629 | 298 | 11.882658 | 78.86498 | 2021-01-15 17:22 | Puducherry, India | ||
3308165 | 3308165 | 2021-01-13 | India | Puducherry | 38524 | 639 | 37607 | 278 | 11.882658 | 78.86498 | 2021-01-14 05:22:32 | Puducherry, India | ||
774310 | 774310 | 2021-01-12 | India | Puducherry | 38495 | 639 | 37563 | 293 | 11.882658 | 78.86498 | 2021-01-13 05:22:15 | Puducherry, India | ||
190031 | 190031 | 2021-01-11 | India | Puducherry | 38477 | 638 | 37535 | 304 | 11.882658 | 78.86498 | 2021-01-12 05:22:15 | Puducherry, India | ||
2625834 | 2625834 | 2021-01-10 | India | Puducherry | 38455 | 638 | 37501 | 316 | 11.882658 | 78.86498 | 2021-01-11 05:21:50 | Puducherry, India | ||
3899922 | 3899922 | 2021-01-09 | India | Puducherry | 38425 | 636 | 37461 | 328 | 11.882658 | 78.86498 | 2021-01-10 05:22:12 | Puducherry, India | ||
153945 | 153945 | 2021-01-08 | India | Puducherry | 38369 | 636 | 37374 | 359 | 11.882658 | 78.86498 | 2021-01-09 05:22:18 | Puducherry, India | ||
2541369 | 2541369 | 2021-01-07 | India | Puducherry | 38369 | 636 | 37374 | 359 | 11.882658 | 78.86498 | 2021-01-08 05:22:42 | Puducherry, India | ||
2864678 | 2864678 | 2021-01-06 | India | Puducherry | 38334 | 635 | 37327 | 372 | 11.882658 | 78.86498 | 2021-01-07 05:22:03 | Puducherry, India | ||
3034265 | 3034265 | 2021-01-05 | India | Puducherry | 38300 | 635 | 37292 | 373 | 11.882658 | 78.86498 | 2021-01-06 05:22:16 | Puducherry, India | ||
1061810 | 1061810 | 2021-01-04 | India | Puducherry | 38253 | 635 | 37261 | 357 | 11.882658 | 78.86498 | 2021-01-05 05:21:49 | Puducherry, India | ||
3230413 | 3230413 | 2021-01-03 | India | Puducherry | 38224 | 633 | 37233 | 358 | 11.882658 | 78.86498 | 2021-01-04 05:22:02 | Puducherry, India | ||
2227482 | 2227482 | 2021-01-02 | India | Puducherry | 38174 | 633 | 37195 | 346 | 11.882658 | 78.86498 | 2021-01-03 05:22:52 | Puducherry, India | ||
1136846 | 1136846 | 2021-01-01 | India | Puducherry | 38164 | 633 | 37115 | 416 | 11.882658 | 78.86498 | 2021-01-02 05:22:33 | Puducherry, India | ||
3695452 | 3695452 | 2020-12-31 | India | Puducherry | 38096 | 633 | 37100 | 363 | 11.882658 | 78.86498 | 2021-01-01 05:23:07 | Puducherry, India | ||
1010267 | 1010267 | 2020-12-30 | India | Puducherry | 38096 | 633 | 37100 | 363 | 11.882658 | 78.86498 | 2020-12-31 05:22:49 | Puducherry, India | ||
766282 | 766282 | 2020-12-29 | India | Puducherry | 38070 | 633 | 37074 | 363 | 11.882658 | 78.86498 | 2020-12-30 05:22:34 | Puducherry, India | ||
3761546 | 3761546 | 2020-12-28 | India | Puducherry | 38028 | 631 | 37040 | 357 | 11.882658 | 78.86498 | 2020-12-29 05:22:37 | Puducherry, India | ||
3777866 | 3777866 | 2020-12-27 | India | Puducherry | 37995 | 631 | 37005 | 359 | 11.882658 | 78.86498 | 2020-12-28 05:22:06 | Puducherry, India | ||
2223471 | 2223471 | 2020-12-26 | India | Puducherry | 37947 | 630 | 36962 | 355 | 11.882658 | 78.86498 | 2020-12-27 05:22:55 | Puducherry, India | ||
202218 | 202218 | 2020-12-25 | India | Puducherry | 37914 | 629 | 36936 | 349 | 11.882658 | 78.86498 | 2020-12-26 05:22:28 | Puducherry, India | ||
3691441 | 3691441 | 2020-12-24 | India | Puducherry | 37885 | 629 | 36892 | 364 | 11.882658 | 78.86498 | 2020-12-25 05:22:48 | Puducherry, India | ||
2406793 | 2406793 | 2020-12-23 | India | Puducherry | 37845 | 629 | 36866 | 350 | 11.882658 | 78.86498 | 2020-12-24 05:23:04 | Puducherry, India | ||
3769839 | 3769839 | 2020-12-22 | India | Puducherry | 37811 | 629 | 36822 | 360 | 11.882658 | 78.86498 | 2020-12-23 05:22:03 | Puducherry, India | ||
927655 | 927655 | 2020-12-21 | India | Puducherry | 37762 | 627 | 36803 | 332 | 11.882658 | 78.86498 | 2020-12-22 05:22:33 | Puducherry, India | ||
2119676 | 2119676 | 2020-12-20 | India | Puducherry | 37748 | 626 | 36777 | 345 | 11.882658 | 78.86498 | 2020-12-21 05:27:58 | Puducherry, India | ||
2931183 | 2931183 | 2020-12-19 | India | Puducherry | 37715 | 624 | 36752 | 339 | 11.882658 | 78.86498 | 2020-12-20 05:27:32 | Puducherry, India | ||
1901129 | 1901129 | 2020-12-18 | India | Puducherry | 37670 | 623 | 36731 | 316 | 11.882658 | 78.86498 | 2020-12-19 05:27:52 | Puducherry, India | ||
2127955 | 2127955 | 2020-12-17 | India | Puducherry | 37622 | 622 | 36693 | 307 | 11.882658 | 78.86498 | 2020-12-18 05:28:18 | Puducherry, India | ||
3149555 | 3149555 | 2020-12-16 | India | Puducherry | 37582 | 622 | 36661 | 299 | 11.882658 | 78.86498 | 2020-12-17 05:28:12 | Puducherry, India | ||
1034336 | 1034336 | 2020-12-15 | India | Puducherry | 37550 | 620 | 36633 | 297 | 11.882658 | 78.86498 | 2020-12-16 05:28:04 | Puducherry, India | ||
1751230 | 1751230 | 2020-12-14 | India | Puducherry | 37513 | 620 | 36586 | 307 | 11.882658 | 78.86498 | 2020-12-15 05:26:38 | Puducherry, India | ||
3847750 | 3847750 | 2020-12-13 | India | Puducherry | 37492 | 619 | 36536 | 337 | 11.882658 | 78.86498 | 2020-12-14 05:26:27 | Puducherry, India | ||
845532 | 845532 | 2020-12-12 | India | Puducherry | 37444 | 619 | 36479 | 346 | 11.882658 | 78.86498 | 2020-12-13 05:27:20 | Puducherry, India | ||
860639 | 860639 | 2020-12-11 | India | Puducherry | 37406 | 619 | 36420 | 367 | 11.882658 | 78.86498 | 2020-12-12 05:26:19 | Puducherry, India | ||
1600181 | 1600181 | 2020-12-10 | India | Puducherry | 37363 | 617 | 36372 | 374 | 11.882658 | 78.86498 | 2020-12-11 05:26:59 | Puducherry, India | ||
2975190 | 2975190 | 2020-12-09 | India | Puducherry | 37339 | 615 | 36354 | 370 | 11.882658 | 78.86498 | 2020-12-10 05:26:19 | Puducherry, India | ||
1818750 | 1818750 | 2020-12-08 | India | Puducherry | 37311 | 615 | 36308 | 388 | 11.882658 | 78.86498 | 2020-12-09 05:28:01 | Puducherry, India | ||
2347386 | 2347386 | 2020-12-07 | India | Puducherry | 37270 | 615 | 36263 | 392 | 11.882658 | 78.86498 | 2020-12-08 05:27:42 | Puducherry, India | ||
1006256 | 1006256 | 2020-12-06 | India | Puducherry | 37224 | 614 | 36238 | 372 | 11.882658 | 78.86498 | 2020-12-07 05:26:14 | Puducherry, India | ||
1632265 | 1632265 | 2020-12-05 | India | Puducherry | 37209 | 614 | 36176 | 419 | 11.882658 | 78.86498 | 2020-12-06 05:26:18 | Puducherry, India | ||
3859793 | 3859793 | 2020-12-04 | India | Puducherry | 37165 | 614 | 36124 | 427 | 11.882658 | 78.86498 | 2020-12-05 05:27:36 | Puducherry, India | ||
75051 | 75051 | 2020-12-03 | India | Puducherry | 37119 | 613 | 36062 | 444 | 11.882658 | 78.86498 | 2020-12-04 05:27:27 | Puducherry, India | ||
738263 | 738263 | 2020-12-02 | India | Puducherry | 37079 | 612 | 36035 | 432 | 11.882658 | 78.86498 | 2020-12-03 05:28:22 | Puducherry, India | ||
2537357 | 2537357 | 2020-12-01 | India | Puducherry | 37020 | 611 | 35970 | 439 | 11.882658 | 78.86498 | 2020-12-02 05:27:41 | Puducherry, India | ||
1584126 | 1584126 | 2020-11-30 | India | Puducherry | 36968 | 610 | 35898 | 460 | 11.882658 | 78.86498 | 2020-12-01 05:26:18 | Puducherry, India | ||
3566529 | 3566529 | 2020-11-29 | India | Puducherry | 36935 | 609 | 35846 | 480 | 11.882658 | 78.86498 | 2020-11-30 05:26:13 | Puducherry, India | ||
2935194 | 2935194 | 2020-11-28 | India | Puducherry | 36902 | 609 | 35774 | 519 | 11.882658 | 78.86498 | 2020-11-29 05:25:55 | Puducherry, India | ||
392197 | 392197 | 2020-11-27 | India | Puducherry | 36856 | 609 | 35733 | 514 | 11.882658 | 78.86498 | 2020-11-28 05:25:50 | Puducherry, India | ||
923644 | 923644 | 2020-11-26 | India | Puducherry | 36840 | 609 | 35687 | 544 | 11.882658 | 78.86498 | 2020-11-27 05:26:53 | Puducherry, India | ||
1972549 | 1972549 | 2020-11-25 | India | Puducherry | 36820 | 609 | 35671 | 540 | 11.882658 | 78.86498 | 2020-11-26 05:27:44 | Puducherry, India | ||
1350280 | 1350280 | 2020-11-24 | India | Puducherry | 36769 | 609 | 35671 | 489 | 11.882658 | 78.86498 | 2020-11-25 05:27:20 | Puducherry, India | ||
678274 | 678274 | 2020-11-23 | India | Puducherry | 36718 | 609 | 35582 | 527 | 11.882658 | 78.86498 | 2020-11-24 05:27:31 | Puducherry, India | ||
3189950 | 3189950 | 2020-11-22 | India | Puducherry | 36693 | 609 | 35525 | 559 | 11.882658 | 78.86498 | 2020-11-23 05:25:26 | Puducherry, India | ||
3836444 | 3836444 | 2020-11-21 | India | Puducherry | 36648 | 609 | 35437 | 602 | 11.882658 | 78.86498 | 2020-11-22 05:25:45 | Puducherry, India | ||
2701472 | 2701472 | 2020-11-20 | India | Puducherry | 36585 | 609 | 35355 | 621 | 11.882658 | 78.86498 | 2020-11-21 05:25:51 | Puducherry, India | ||
821532 | 821532 | 2020-11-19 | India | Puducherry | 36533 | 609 | 35254 | 670 | 11.882658 | 78.86498 | 2020-11-20 05:26:28 | Puducherry, India | ||
122666 | 122666 | 2020-11-18 | India | Puducherry | 36465 | 608 | 35152 | 705 | 11.882658 | 78.86498 | 2020-11-19 05:25:23 | Puducherry, India | ||
3338554 | 3338554 | 2020-11-17 | India | Puducherry | 36409 | 608 | 34958 | 843 | 11.882658 | 78.86498 | 2020-11-18 05:40:31 | Puducherry, India | ||
3169599 | 3169599 | 2020-11-16 | India | Puducherry | 36337 | 608 | 34827 | 902 | 11.882658 | 78.86498 | 2020-11-17 05:25:54 | Puducherry, India | ||
2880167 | 2880167 | 2020-11-15 | India | Puducherry | 36324 | 608 | 34732 | 984 | 11.882658 | 78.86498 | 2020-11-16 05:25:57 | Puducherry, India | ||
2915145 | 2915145 | 2020-11-14 | India | Puducherry | 36299 | 608 | 34637 | 1054 | 11.882658 | 78.86498 | 2020-11-15 05:26:53 | Puducherry, India | ||
2784967 | 2784967 | 2020-11-13 | India | Puducherry | 36252 | 608 | 34571 | 1073 | 11.882658 | 78.86498 | 2020-11-14 05:25:37 | Puducherry, India | ||
864732 | 864732 | 2020-11-12 | India | Puducherry | 36179 | 607 | 34501 | 1071 | 11.882658 | 78.86498 | 2020-11-13 05:25:30 | Puducherry, India | ||
3440777 | 3440777 | 2020-11-11 | India | Puducherry | 36114 | 605 | 34432 | 1077 | 11.882658 | 78.86498 | 2020-11-12 05:25:55 | Puducherry, India | ||
272117 | 272117 | 2020-11-10 | India | Puducherry | 36000 | 604 | 34325 | 1071 | 11.882658 | 78.86498 | 2020-11-11 05:25:30 | Puducherry, India | ||
1988594 | 1988594 | 2020-11-09 | India | Puducherry | 35900 | 602 | 34212 | 1086 | 11.882658 | 78.86498 | 2020-11-10 05:40:07 | Puducherry, India | ||
1728446 | 1728446 | 2020-11-08 | India | Puducherry | 35838 | 601 | 34067 | 1170 | 11.882658 | 78.86498 | 2020-11-09 05:25:45 | Puducherry, India | ||
1543906 | 1543906 | 2020-11-07 | India | Puducherry | 35744 | 600 | 33932 | 1212 | 11.882658 | 78.86498 | 2020-11-08 05:24:56 | Puducherry, India | ||
376144 | 376144 | 2020-11-06 | India | Puducherry | 35675 | 598 | 33437 | 1640 | 11.882658 | 78.86498 | 2020-11-07 05:24:52 | Puducherry, India | ||
892082 | 892082 | 2020-11-05 | India | Puducherry | 35550 | 597 | 33123 | 1830 | 11.882658 | 78.86498 | 2020-11-06 05:24:55 | Puducherry, India | ||
2919144 | 2919144 | 2020-11-04 | India | Puducherry | 35429 | 597 | 32703 | 2129 | 11.882658 | 78.86498 | 2020-11-05 06:05:03 | Puducherry, India | ||
2497981 | 2497981 | 2020-11-03 | India | Puducherry | 35325 | 596 | 32284 | 2445 | 11.882658 | 78.86498 | 2020-11-04 05:25:09 | Puducherry, India | ||
3304156 | 3304156 | 2020-11-02 | India | Puducherry | 35178 | 595 | 31827 | 2756 | 11.882658 | 78.86498 | 2020-11-03 06:00:16 | Puducherry, India | ||
3409405 | 3409405 | 2020-11-01 | India | Puducherry | 35109 | 595 | 31345 | 3169 | 11.882658 | 78.86498 | 2020-11-02 05:25:04 | Puducherry, India | ||
2079894 | 2079894 | 2020-10-31 | India | Puducherry | 35013 | 592 | 30724 | 3697 | 11.882658 | 78.86498 | 2020-11-01 04:36:19 | Puducherry, India | ||
2243347 | 2243347 | 2020-10-30 | India | Puducherry | 34908 | 592 | 30577 | 3739 | 11.882658 | 78.86498 | 2020-10-31 04:24:44 | Puducherry, India | ||
210202 | 210202 | 2020-10-29 | India | Puducherry | 34761 | 592 | 30449 | 3720 | 11.882658 | 78.86498 | 2020-10-30 04:24:49 | Puducherry, India | ||
754264 | 754264 | 2020-10-28 | India | Puducherry | 34583 | 590 | 30307 | 3686 | 11.882658 | 78.86498 | 2020-10-29 04:24:49 | Puducherry, India | ||
1452549 | 1452549 | 2020-10-27 | India | Puducherry | 34482 | 588 | 30153 | 3741 | 11.882658 | 78.86498 | 2020-10-28 04:24:39 | Puducherry, India | ||
3480273 | 3480273 | 2020-10-26 | India | Puducherry | 34336 | 588 | 29990 | 3758 | 11.882658 | 78.86498 | 2020-10-27 04:24:45 | Puducherry, India | ||
8294 | 8294 | 2020-10-25 | India | Puducherry | 34193 | 588 | 29801 | 3804 | 11.882658 | 78.86498 | 2020-10-26 04:25:02 | Puducherry, India | ||
3651531 | 3651531 | 2020-10-24 | India | Puducherry | 34112 | 586 | 29614 | 3912 | 11.882658 | 78.86498 | 2020-10-25 04:24:36 | Puducherry, India | ||
1053786 | 1053786 | 2020-10-23 | India | Puducherry | 33986 | 584 | 29427 | 3975 | 11.882658 | 78.86498 | 2020-10-24 04:24:46 | Puducherry, India | ||
1177456 | 1177456 | 2020-10-22 | India | Puducherry | 33832 | 582 | 29211 | 4039 | 11.882658 | 78.86498 | 2020-10-23 04:24:46 | Puducherry, India | ||
2191561 | 2191561 | 2020-10-21 | India | Puducherry | 33622 | 580 | 29016 | 4026 | 11.882658 | 78.86498 | 2020-10-22 04:24:27 | Puducherry, India | ||
3990572 | 3990572 | 2020-10-20 | India | Puducherry | 33452 | 577 | 28774 | 4101 | 11.882658 | 78.86498 | 2020-10-21 04:24:14 | Puducherry, India | ||
1794592 | 1794592 | 2020-10-19 | India | Puducherry | 33247 | 575 | 28520 | 4152 | 11.882658 | 78.86498 | 2020-10-20 04:24:22 | Puducherry, India | ||
762276 | 762276 | 2020-10-18 | India | Puducherry | 33141 | 574 | 28290 | 4277 | 11.882658 | 78.86498 | 2020-10-19 04:24:16 | Puducherry, India | ||
1026314 | 1026314 | 2020-10-17 | India | Puducherry | 32978 | 574 | 27984 | 4420 | 11.882658 | 78.86498 | 2020-10-18 04:24:25 | Puducherry, India | ||
2856809 | 2856809 | 2020-10-16 | India | Puducherry | 32766 | 571 | 27671 | 4524 | 11.882658 | 78.86498 | 2020-10-17 04:24:12 | Puducherry, India | ||
786339 | 786339 | 2020-10-15 | India | Puducherry | 32486 | 570 | 27365 | 4551 | 11.882658 | 78.86498 | 2020-10-16 04:24:01 | Puducherry, India | ||
79050 | 79050 | 2020-10-14 | India | Puducherry | 32245 | 568 | 27152 | 4525 | 11.882658 | 78.86498 | 2020-10-15 04:24:28 | Puducherry, India | ||
3781865 | 3781865 | 2020-10-13 | India | Puducherry | 32004 | 567 | 26865 | 4572 | 11.882658 | 78.86498 | 2020-10-14 04:24:05 | Puducherry, India | ||
2291405 | 2291405 | 2020-10-12 | India | Puducherry | 31737 | 565 | 26555 | 4617 | 11.882658 | 78.86498 | 2020-10-13 04:24:02 | Puducherry, 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]);