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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254109 | 3254109 | 2021-03-02 | India | Puducherry | 39763 | 669 | 38920 | 174 | 11.882658 | 78.86498 | 2021-03-03 05:23:28 | Puducherry, India | ||
998401 | 998401 | 2021-03-01 | India | Puducherry | 39734 | 669 | 38888 | 177 | 11.882658 | 78.86498 | 2021-03-02 05:23:30 | Puducherry, India | ||
2367459 | 2367459 | 2021-02-28 | India | Puducherry | 39725 | 668 | 38872 | 185 | 11.882658 | 78.86498 | 2021-03-01 05:23:01 | Puducherry, India | ||
3065961 | 3065961 | 2021-02-27 | India | Puducherry | 39717 | 668 | 38852 | 197 | 11.882658 | 78.86498 | 2021-02-28 05:22:20 | Puducherry, India | ||
2183545 | 2183545 | 2021-02-26 | India | Puducherry | 39697 | 667 | 38836 | 194 | 11.882658 | 78.86498 | 2021-02-27 05:22:28 | Puducherry, India | ||
1857967 | 1857967 | 2021-02-25 | India | Puducherry | 39677 | 667 | 38814 | 196 | 11.882658 | 78.86498 | 2021-02-26 05:22:40 | Puducherry, India | ||
280145 | 280145 | 2021-02-24 | India | Puducherry | 39656 | 666 | 38801 | 189 | 11.882658 | 78.86498 | 2021-02-25 05:24:57 | Puducherry, India | ||
1936413 | 1936413 | 2021-02-23 | India | Puducherry | 39628 | 665 | 38784 | 179 | 11.882658 | 78.86498 | 2021-02-24 05:29:16 | Puducherry, India | ||
530668 | 530668 | 2021-02-22 | India | Puducherry | 39600 | 663 | 38763 | 174 | 11.882658 | 78.86498 | 2021-02-23 05:23:41 | Puducherry, India | ||
182002 | 182002 | 2021-02-21 | India | Puducherry | 39592 | 663 | 38737 | 192 | 11.882658 | 78.86498 | 2021-02-22 05:24:21 | Puducherry, India | ||
742276 | 742276 | 2021-02-20 | India | Puducherry | 39569 | 662 | 38719 | 188 | 11.882658 | 78.86498 | 2021-02-21 05:24:33 | Puducherry, India | ||
471374 | 471374 | 2021-02-19 | India | Puducherry | 39540 | 662 | 38701 | 177 | 11.882658 | 78.86498 | 2021-02-20 05:22:51 | Puducherry, India | ||
1153083 | 1153083 | 2021-02-18 | India | Puducherry | 39526 | 660 | 38667 | 199 | 11.882658 | 78.86498 | 2021-02-19 05:24:16 | Puducherry, India | ||
3601003 | 3601003 | 2021-02-17 | India | Puducherry | 39506 | 660 | 38644 | 202 | 11.882658 | 78.86498 | 2021-02-18 05:22:58 | Puducherry, India | ||
3050138 | 3050138 | 2021-02-16 | India | Puducherry | 39488 | 658 | 38617 | 213 | 11.882658 | 78.86498 | 2021-02-17 05:23:10 | Puducherry, India | ||
1338237 | 1338237 | 2021-02-15 | India | Puducherry | 39468 | 658 | 38574 | 236 | 11.882658 | 78.86498 | 2021-02-16 05:24:38 | Puducherry, India | ||
2283388 | 2283388 | 2021-02-14 | India | Puducherry | 39448 | 657 | 38533 | 258 | 11.882658 | 78.86498 | 2021-02-15 05:24:49 | Puducherry, India | ||
2677788 | 2677788 | 2021-02-13 | India | Puducherry | 39440 | 656 | 38500 | 284 | 11.882658 | 78.86498 | 2021-02-14 05:23:43 | Puducherry, India | ||
3539421 | 3539421 | 2021-02-12 | India | Puducherry | 39416 | 656 | 38476 | 284 | 11.882658 | 78.86498 | 2021-02-13 05:22:12 | Puducherry, India | ||
2637684 | 2637684 | 2021-02-11 | India | Puducherry | 39397 | 656 | 38445 | 296 | 11.882658 | 78.86498 | 2021-02-12 05:23:29 | Puducherry, India | ||
3978539 | 3978539 | 2021-02-10 | India | Puducherry | 39372 | 656 | 38423 | 293 | 11.882658 | 78.86498 | 2021-02-11 05:23:55 | Puducherry, India | ||
1527859 | 1527859 | 2021-02-09 | India | Puducherry | 39353 | 655 | 38391 | 307 | 11.882658 | 78.86498 | 2021-02-10 05:22:41 | Puducherry, India | ||
613650 | 613650 | 2021-02-08 | India | Puducherry | 39318 | 655 | 38354 | 309 | 11.882658 | 78.86498 | 2021-02-09 05:23:30 | Puducherry, India | ||
1672419 | 1672419 | 2021-02-07 | India | Puducherry | 39292 | 654 | 38326 | 312 | 11.882658 | 78.86498 | 2021-02-08 05:22:39 | Puducherry, India | ||
974880 | 974880 | 2021-02-06 | India | Puducherry | 39270 | 654 | 38299 | 317 | 11.882658 | 78.86498 | 2021-02-07 05:23:00 | Puducherry, India | ||
1588138 | 1588138 | 2021-02-05 | India | Puducherry | 39235 | 654 | 38267 | 314 | 11.882658 | 78.86498 | 2021-02-06 05:23:55 | Puducherry, India | ||
790345 | 790345 | 2021-02-04 | India | Puducherry | 39185 | 652 | 38240 | 293 | 11.882658 | 78.86498 | 2021-02-05 05:22:38 | Puducherry, India | ||
340237 | 340237 | 2021-02-03 | India | Puducherry | 39146 | 652 | 38215 | 279 | 11.882658 | 78.86498 | 2021-02-04 05:22:26 | Puducherry, India | ||
1684463 | 1684463 | 2021-02-02 | India | Puducherry | 39123 | 651 | 38186 | 286 | 11.882658 | 78.86498 | 2021-02-03 05:22:52 | Puducherry, India | ||
1676433 | 1676433 | 2021-02-01 | India | Puducherry | 39096 | 651 | 38160 | 285 | 11.882658 | 78.86498 | 2021-02-02 05:22:49 | Puducherry, India | ||
1459721 | 1459721 | 2021-01-31 | India | Puducherry | 39068 | 648 | 38135 | 285 | 11.882658 | 78.86498 | 2021-02-01 05:22:53 | Puducherry, India | ||
2211629 | 2211629 | 2021-01-30 | India | Puducherry | 39047 | 647 | 38094 | 306 | 11.882658 | 78.86498 | 2021-01-31 05:22:42 | Puducherry, India | ||
1897116 | 1897116 | 2021-01-29 | India | Puducherry | 39004 | 647 | 38062 | 295 | 11.882658 | 78.86498 | 2021-01-30 05:22:49 | Puducherry, India | ||
2481932 | 2481932 | 2021-01-28 | India | Puducherry | 38973 | 647 | 38035 | 291 | 11.882658 | 78.86498 | 2021-01-29 05:22:23 | Puducherry, India | ||
3153567 | 3153567 | 2021-01-27 | India | Puducherry | 38934 | 646 | 38006 | 282 | 11.882658 | 78.86498 | 2021-01-28 05:22:24 | Puducherry, India | ||
12302 | 12302 | 2021-01-26 | India | Puducherry | 38910 | 645 | 37970 | 295 | 11.882658 | 78.86498 | 2021-01-27 05:23:41 | Puducherry, India | ||
2567626 | 2567626 | 2021-01-25 | India | Puducherry | 38878 | 645 | 37953 | 280 | 11.882658 | 78.86498 | 2021-01-26 05:22:02 | Puducherry, India | ||
1759258 | 1759258 | 2021-01-24 | India | Puducherry | 38860 | 645 | 37927 | 288 | 11.882658 | 78.86498 | 2021-01-25 05:22:16 | Puducherry, India | ||
2426865 | 2426865 | 2021-01-23 | India | Puducherry | 38830 | 644 | 37884 | 302 | 11.882658 | 78.86498 | 2021-01-24 05:22:35 | Puducherry, India | ||
2466767 | 2466767 | 2021-01-22 | India | Puducherry | 38794 | 643 | 37857 | 294 | 11.882658 | 78.86498 | 2021-01-23 05:22:03 | Puducherry, India | ||
435318 | 435318 | 2021-01-21 | India | Puducherry | 38772 | 643 | 37830 | 299 | 11.882658 | 78.86498 | 2021-01-22 05:22:10 | Puducherry, India | ||
1094050 | 1094050 | 2021-01-20 | India | Puducherry | 38737 | 643 | 37798 | 296 | 11.882658 | 78.86498 | 2021-01-21 05:22:01 | Puducherry, India | ||
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 |
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]);