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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687427 | 3687427 | 2022-01-13 | India | Puducherry | 132759 | 1883 | 0 | 11.882658000000001 | 78.86498 | 2022-01-14 04:21:54 | Puducherry, India | |||
3613011 | 3613011 | 2022-01-12 | India | Puducherry | 132759 | 1883 | 0 | 11.882658000000001 | 78.86498 | 2022-01-13 08:00:09 | Puducherry, India | |||
1113536 | 1113536 | 2022-01-11 | India | Puducherry | 131211 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-12 04:21:44 | Puducherry, India | |||
1692264 | 1692264 | 2022-01-10 | India | Puducherry | 131211 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-11 04:22:01 | Puducherry, India | |||
126679 | 126679 | 2022-01-09 | India | Puducherry | 130722 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-10 04:22:07 | Puducherry, India | |||
1215514 | 1215514 | 2022-01-08 | India | Puducherry | 130278 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-09 04:21:46 | Puducherry, India | |||
1389607 | 1389607 | 2022-01-07 | India | Puducherry | 129998 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-08 04:21:53 | Puducherry, India | |||
2609994 | 2609994 | 2022-01-06 | India | Puducherry | 129821 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-07 04:22:09 | Puducherry, India | |||
1281936 | 1281936 | 2022-01-05 | India | Puducherry | 129692 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-06 04:22:09 | Puducherry, India | |||
1285952 | 1285952 | 2022-01-04 | India | Puducherry | 129619 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-05 04:21:59 | Puducherry, India | |||
1700296 | 1700296 | 2022-01-03 | India | Puducherry | 129553 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-04 04:22:17 | Puducherry, India | |||
3519379 | 3519379 | 2022-01-02 | India | Puducherry | 129527 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-03 02:22:25 | Puducherry, India | |||
2167509 | 2167509 | 2022-01-01 | India | Puducherry | 129500 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-02 04:20:52 | Puducherry, India | |||
2776940 | 2776940 | 2021-12-31 | India | Puducherry | 129478 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2022-01-01 04:22:14 | Puducherry, India | |||
3998597 | 3998597 | 2021-12-30 | India | Puducherry | 129461 | 1881 | 0 | 11.882658000000001 | 78.86498 | 2021-12-31 04:21:50 | Puducherry, India | |||
1668404 | 1668404 | 2021-12-29 | India | Puducherry | 129446 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-30 04:21:25 | Puducherry, India | |||
1432513 | 1432513 | 2021-12-28 | India | Puducherry | 129434 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-29 03:21:43 | Puducherry, India | |||
730474 | 730474 | 2021-12-27 | India | Puducherry | 129425 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-28 04:21:47 | Puducherry, India | |||
2111646 | 2111646 | 2021-12-26 | India | Puducherry | 129415 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-27 04:21:58 | Puducherry, India | |||
3605018 | 3605018 | 2021-12-25 | India | Puducherry | 129406 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-26 04:21:50 | Puducherry, India | |||
2963336 | 2963336 | 2021-12-24 | India | Puducherry | 129394 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-25 04:21:37 | Puducherry, India | |||
3816368 | 3816368 | 2021-12-23 | India | Puducherry | 129374 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-24 04:21:34 | Puducherry, India | |||
798376 | 798376 | 2021-12-22 | India | Puducherry | 129366 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-23 04:21:21 | Puducherry, India | |||
3828416 | 3828416 | 2021-12-21 | India | Puducherry | 129345 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-22 04:21:54 | Puducherry, India | |||
1254719 | 1254719 | 2021-12-20 | India | Puducherry | 129325 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-21 03:21:27 | Puducherry, India | |||
2903662 | 2903662 | 2021-12-19 | India | Puducherry | 129315 | 1880 | 0 | 11.882658000000001 | 78.86498 | 2021-12-20 04:21:43 | Puducherry, India | |||
1258735 | 1258735 | 2021-12-18 | India | Puducherry | 129292 | 1879 | 0 | 11.882658000000001 | 78.86498 | 2021-12-19 04:21:11 | Puducherry, India | |||
2398763 | 2398763 | 2021-12-17 | India | Puducherry | 129285 | 1879 | 0 | 11.882658000000001 | 78.86498 | 2021-12-18 02:22:20 | Puducherry, India | |||
1716301 | 1716301 | 2021-12-16 | India | Puducherry | 129285 | 1879 | 0 | 11.882658000000001 | 78.86498 | 2021-12-17 04:22:14 | Puducherry, India | |||
3496135 | 3496135 | 2021-12-15 | India | Puducherry | 129261 | 1878 | 0 | 11.882658000000001 | 78.86498 | 2021-12-16 04:22:11 | Puducherry, India | |||
2087920 | 2087920 | 2021-12-14 | India | Puducherry | 129248 | 1878 | 0 | 11.882658000000001 | 78.86498 | 2021-12-15 03:22:16 | Puducherry, India | |||
782337 | 782337 | 2021-12-13 | India | Puducherry | 129224 | 1877 | 0 | 11.882658000000001 | 78.86498 | 2021-12-14 04:22:38 | Puducherry, India | |||
1660372 | 1660372 | 2021-12-12 | India | Puducherry | 129217 | 1877 | 0 | 11.882658000000001 | 78.86498 | 2021-12-13 04:22:02 | Puducherry, India | |||
1664388 | 1664388 | 2021-12-11 | India | Puducherry | 129202 | 1877 | 0 | 11.882658000000001 | 78.86498 | 2021-12-12 04:22:12 | Puducherry, India | |||
3655540 | 3655540 | 2021-12-10 | India | Puducherry | 129180 | 1877 | 0 | 11.882658000000001 | 78.86498 | 2021-12-11 04:22:45 | Puducherry, India | |||
1077871 | 1077871 | 2021-12-09 | India | Puducherry | 129156 | 1877 | 0 | 11.882658000000001 | 78.86498 | 2021-12-10 04:22:28 | Puducherry, India | |||
550720 | 550720 | 2021-12-08 | India | Puducherry | 129128 | 1876 | 0 | 11.882658000000001 | 78.86498 | 2021-12-09 04:22:49 | Puducherry, India | |||
404240 | 404240 | 2021-12-07 | India | Puducherry | 129105 | 1876 | 0 | 11.882658000000001 | 78.86498 | 2021-12-08 04:22:46 | Puducherry, India | |||
1030322 | 1030322 | 2021-12-06 | India | Puducherry | 129093 | 1875 | 0 | 11.882658000000001 | 78.86498 | 2021-12-07 04:22:34 | Puducherry, India | |||
1740485 | 1740485 | 2021-12-05 | India | Puducherry | 129085 | 1875 | 0 | 11.882658000000001 | 78.86498 | 2021-12-06 04:22:34 | Puducherry, India | |||
137917 | 137917 | 2021-12-04 | India | Puducherry | 129028 | 1874 | 0 | 11.882658000000001 | 78.86498 | 2021-12-05 04:22:25 | Puducherry, India | |||
2195570 | 2195570 | 2021-12-03 | India | Puducherry | 129028 | 1874 | 0 | 11.882658000000001 | 78.86498 | 2021-12-04 04:22:18 | Puducherry, India | |||
276 | 276 | 2021-12-02 | India | Puducherry | 128998 | 1873 | 0 | 11.882658000000001 | 78.86498 | 2021-12-03 04:23:05 | Puducherry, India | |||
1144875 | 1144875 | 2021-12-01 | India | Puducherry | 128965 | 1873 | 0 | 11.882658000000001 | 78.86498 | 2021-12-02 04:22:37 | Puducherry, India | |||
3401387 | 3401387 | 2021-11-30 | India | Puducherry | 128924 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-12-01 04:22:29 | Puducherry, India | |||
149930 | 149930 | 2021-11-29 | India | Puducherry | 128893 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-11-30 04:22:53 | Puducherry, India | |||
1231576 | 1231576 | 2021-11-28 | India | Puducherry | 128881 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-11-29 04:22:30 | Puducherry, India | |||
1358283 | 1358283 | 2021-11-27 | India | Puducherry | 128860 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-11-28 04:22:43 | Puducherry, India | |||
758274 | 758274 | 2021-11-26 | India | Puducherry | 128825 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-11-27 04:22:45 | Puducherry, India | |||
1802691 | 1802691 | 2021-11-25 | India | Puducherry | 128794 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-11-26 04:22:33 | Puducherry, India | |||
904125 | 904125 | 2021-11-24 | India | Puducherry | 128745 | 1870 | 0 | 11.882658000000001 | 78.86498 | 2021-11-25 04:22:33 | Puducherry, India | |||
3069975 | 3069975 | 2021-11-23 | India | Puducherry | 128718 | 1870 | 0 | 11.882658000000001 | 78.86498 | 2021-11-24 04:22:14 | Puducherry, India | |||
3749073 | 3749073 | 2021-11-22 | India | Puducherry | 128680 | 1870 | 0 | 11.882658000000001 | 78.86498 | 2021-11-23 04:22:39 | Puducherry, India | |||
1014280 | 1014280 | 2021-11-21 | India | Puducherry | 128663 | 1870 | 0 | 11.882658000000001 | 78.86498 | 2021-11-22 04:22:20 | Puducherry, India | |||
722444 | 722444 | 2021-11-20 | India | Puducherry | 128631 | 1869 | 0 | 11.882658000000001 | 78.86498 | 2021-11-21 04:22:13 | Puducherry, India | |||
161974 | 161974 | 2021-11-19 | India | Puducherry | 128588 | 1869 | 0 | 11.882658000000001 | 78.86498 | 2021-11-20 04:22:17 | Puducherry, India | |||
3288861 | 3288861 | 2021-11-18 | India | Puducherry | 128561 | 1867 | 0 | 11.882658000000001 | 78.86498 | 2021-11-19 04:21:40 | Puducherry, India | |||
447317 | 447317 | 2021-11-17 | India | Puducherry | 128520 | 1867 | 0 | 11.882658000000001 | 78.86498 | 2021-11-18 04:21:33 | Puducherry, India | |||
3342567 | 3342567 | 2021-11-16 | India | Puducherry | 128495 | 1866 | 0 | 11.882658000000001 | 78.86498 | 2021-11-17 04:21:48 | Puducherry, India | |||
2287403 | 2287403 | 2021-11-15 | India | Puducherry | 128462 | 1866 | 0 | 11.882658000000001 | 78.86498 | 2021-11-16 04:21:10 | Puducherry, India | |||
1322177 | 1322177 | 2021-11-14 | India | Puducherry | 128444 | 1865 | 0 | 11.882658000000001 | 78.86498 | 2021-11-15 04:21:36 | Puducherry, India | |||
686303 | 686303 | 2021-11-13 | India | Puducherry | 128401 | 1863 | 0 | 11.882658000000001 | 78.86498 | 2021-11-14 04:21:31 | Puducherry, India | |||
714412 | 714412 | 2021-11-12 | India | Puducherry | 128369 | 1863 | 0 | 11.882658000000001 | 78.86498 | 2021-11-13 04:21:38 | Puducherry, India | |||
28362 | 28362 | 2021-11-11 | India | Puducherry | 128332 | 1863 | 0 | 11.882658000000001 | 78.86498 | 2021-11-12 04:22:01 | Puducherry, India | |||
2844801 | 2844801 | 2021-11-10 | India | Puducherry | 128302 | 1863 | 0 | 11.882658000000001 | 78.86498 | 2021-11-11 04:21:45 | Puducherry, India | |||
87071 | 87071 | 2021-11-09 | India | Puducherry | 128263 | 1862 | 0 | 11.882658000000001 | 78.86498 | 2021-11-10 04:21:38 | Puducherry, India | |||
3639499 | 3639499 | 2021-11-08 | India | Puducherry | 128224 | 1862 | 0 | 11.882658000000001 | 78.86498 | 2021-11-09 04:21:36 | Puducherry, India | |||
2000607 | 2000607 | 2021-11-07 | India | Puducherry | 128200 | 1862 | 0 | 11.882658000000001 | 78.86498 | 2021-11-08 04:21:43 | Puducherry, India | |||
495598 | 495598 | 2021-11-06 | India | Puducherry | 128165 | 1862 | 0 | 11.882658000000001 | 78.86498 | 2021-11-07 04:21:53 | Puducherry, India | |||
3121453 | 3121453 | 2021-11-05 | India | Puducherry | 128145 | 1861 | 0 | 11.882658000000001 | 78.86498 | 2021-11-06 04:21:51 | Puducherry, India | |||
698351 | 698351 | 2021-11-04 | India | Puducherry | 128134 | 1860 | 0 | 11.882658000000001 | 78.86498 | 2021-11-05 04:21:54 | Puducherry, India | |||
276129 | 276129 | 2021-11-03 | India | Puducherry | 128106 | 1859 | 0 | 11.882658000000001 | 78.86498 | 2021-11-04 04:22:20 | Puducherry, India | |||
43654 | 43654 | 2021-11-02 | India | Puducherry | 128077 | 1859 | 0 | 11.882658000000001 | 78.86498 | 2021-11-03 06:22:09 | Puducherry, India | |||
3511350 | 3511350 | 2021-11-01 | India | Puducherry | 128056 | 1858 | 0 | 11.882658000000001 | 78.86498 | 2021-11-02 04:22:03 | Puducherry, India | |||
287942 | 287942 | 2021-10-31 | India | Puducherry | 128013 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-11-01 04:22:01 | Puducherry, India | |||
2720948 | 2720948 | 2021-10-30 | India | Puducherry | 127975 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-31 04:22:08 | Puducherry, India | |||
567050 | 567050 | 2021-10-29 | India | Puducherry | 127936 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-30 04:22:03 | Puducherry, India | |||
4292 | 4292 | 2021-10-28 | India | Puducherry | 127891 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-29 04:22:03 | Puducherry, India | |||
534682 | 534682 | 2021-10-27 | India | Puducherry | 127846 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-28 04:22:08 | Puducherry, India | |||
3492119 | 3492119 | 2021-10-26 | India | Puducherry | 127806 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-27 04:22:32 | Puducherry, India | |||
3793841 | 3793841 | 2021-10-25 | India | Puducherry | 127765 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-26 04:22:09 | Puducherry, India | |||
682287 | 682287 | 2021-10-24 | India | Puducherry | 127735 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-25 04:22:31 | Puducherry, India | |||
770295 | 770295 | 2021-10-23 | India | Puducherry | 127674 | 1855 | 0 | 11.882658000000001 | 78.86498 | 2021-10-24 04:21:22 | Puducherry, India | |||
653942 | 653942 | 2021-10-22 | India | Puducherry | 127621 | 1853 | 0 | 11.882658000000001 | 78.86498 | 2021-10-23 04:21:32 | Puducherry, India | |||
2123689 | 2123689 | 2021-10-21 | India | Puducherry | 127564 | 1852 | 0 | 11.882658000000001 | 78.86498 | 2021-10-22 04:21:14 | Puducherry, India | |||
443301 | 443301 | 2021-10-20 | India | Puducherry | 127521 | 1852 | 0 | 11.882658000000001 | 78.86498 | 2021-10-21 04:21:18 | Puducherry, India | |||
597620 | 597620 | 2021-10-19 | India | Puducherry | 127479 | 1852 | 0 | 11.882658000000001 | 78.86498 | 2021-10-20 04:21:00 | Puducherry, India | |||
2043797 | 2043797 | 2021-10-18 | India | Puducherry | 127424 | 1850 | 0 | 11.882658000000001 | 78.86498 | 2021-10-19 04:20:54 | Puducherry, India | |||
1909158 | 1909158 | 2021-10-17 | India | Puducherry | 127396 | 1850 | 0 | 11.882658000000001 | 78.86498 | 2021-10-18 04:21:10 | Puducherry, India | |||
934747 | 934747 | 2021-10-16 | India | Puducherry | 127344 | 1849 | 0 | 11.882658000000001 | 78.86498 | 2021-10-17 04:21:29 | Puducherry, India | |||
2943302 | 2943302 | 2021-10-15 | India | Puducherry | 127296 | 1849 | 0 | 11.882658000000001 | 78.86498 | 2021-10-16 04:21:15 | Puducherry, India | |||
491582 | 491582 | 2021-10-14 | India | Puducherry | 127259 | 1849 | 0 | 11.882658000000001 | 78.86498 | 2021-10-15 04:21:26 | Puducherry, India | |||
633870 | 633870 | 2021-10-13 | India | Puducherry | 127210 | 1849 | 0 | 11.882658000000001 | 78.86498 | 2021-10-14 04:21:29 | Puducherry, India | |||
1491548 | 1491548 | 2021-10-12 | India | Puducherry | 127151 | 1848 | 0 | 11.882658000000001 | 78.86498 | 2021-10-13 04:20:51 | Puducherry, India | |||
3007281 | 3007281 | 2021-10-11 | India | Puducherry | 127095 | 1848 | 0 | 11.882658000000001 | 78.86498 | 2021-10-12 04:21:09 | Puducherry, India | |||
423297 | 423297 | 2021-10-10 | India | Puducherry | 127053 | 1846 | 0 | 11.882658000000001 | 78.86498 | 2021-10-11 04:21:31 | Puducherry, India | |||
2876154 | 2876154 | 2021-10-09 | India | Puducherry | 126977 | 1846 | 0 | 11.882658000000001 | 78.86498 | 2021-10-10 04:21:38 | Puducherry, India | |||
2959320 | 2959320 | 2021-10-08 | India | Puducherry | 126893 | 1845 | 0 | 11.882658000000001 | 78.86498 | 2021-10-09 04:21:34 | Puducherry, India | |||
467358 | 467358 | 2021-10-07 | India | Puducherry | 126806 | 1844 | 0 | 11.882658000000001 | 78.86498 | 2021-10-08 04:21:25 | Puducherry, India | |||
2458738 | 2458738 | 2021-10-06 | India | Puducherry | 126742 | 1844 | 0 | 11.882658000000001 | 78.86498 | 2021-10-07 04:21:36 | 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]);