johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Puducherry" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, latitude, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
276 | 276 | 2021-12-02 | India | Puducherry | 128998 | 1873 | 0 | 11.882658000000001 | 78.86498 | 2021-12-03 04:23:05 | Puducherry, India | |||
4292 | 4292 | 2021-10-28 | India | Puducherry | 127891 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-10-29 04:22:03 | 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 | ||
12302 | 12302 | 2021-01-26 | India | Puducherry | 38910 | 645 | 37970 | 295 | 11.882658 | 78.86498 | 2021-01-27 05:23:41 | Puducherry, India | ||
16317 | 16317 | 2021-09-18 | India | Puducherry | 125384 | 1829 | 0 | 11.882658000000001 | 78.86498 | 2021-09-19 04:21:34 | Puducherry, India | |||
20332 | 20332 | 2021-05-28 | India | Puducherry | 101900 | 1476 | 86528 | 13896 | 11.882658 | 78.86498 | 2021-05-29 04:20:41 | Puducherry, India | ||
24347 | 24347 | 2022-03-20 | India | Puducherry | 165772 | 1962 | 0 | 11.882658000000001 | 78.86498 | 2022-03-21 04:20:50 | Puducherry, India | |||
28362 | 28362 | 2021-11-11 | India | Puducherry | 128332 | 1863 | 0 | 11.882658000000001 | 78.86498 | 2021-11-12 04:22:01 | Puducherry, India | |||
32378 | 32378 | 2021-08-25 | India | Puducherry | 123078 | 1809 | 0 | 11.882658000000001 | 78.86498 | 2021-08-26 04:21:28 | Puducherry, India | |||
36392 | 36392 | 2021-04-12 | India | Puducherry | 44555 | 693 | 41268 | 2594 | 11.882658 | 78.86498 | 2021-04-13 04:20:37 | Puducherry, India | ||
43654 | 43654 | 2021-11-02 | India | Puducherry | 128077 | 1859 | 0 | 11.882658000000001 | 78.86498 | 2021-11-03 06:22:09 | Puducherry, India | |||
50753 | 50753 | 2021-05-29 | India | Puducherry | 102896 | 1497 | 88246 | 13153 | 11.882658 | 78.86498 | 2021-05-30 04:20:55 | Puducherry, India | ||
54767 | 54767 | 2021-03-07 | India | Puducherry | 39868 | 670 | 39022 | 176 | 11.882658 | 78.86498 | 2021-03-08 05:24:48 | Puducherry, India | ||
62081 | 62081 | 2020-07-23 | India | Puducherry | 2420 | 34 | 1400 | 986 | 11.882658 | 78.86498 | 2020-07-24 05:30:40 | Puducherry, India | ||
63008 | 63008 | 2022-11-12 | India | Puducherry | 175466 | 1975 | 0 | 11.882658 | 78.86498 | 2022-11-13 04:21:14 | Puducherry, India | |||
67023 | 67023 | 2021-09-01 | India | Puducherry | 123710 | 1813 | 0 | 11.882658000000001 | 78.86498 | 2021-09-02 04:21:15 | Puducherry, India | |||
71037 | 71037 | 2022-02-07 | India | Puducherry | 164376 | 1950 | 0 | 11.882658000000001 | 78.86498 | 2022-02-08 04:21:15 | 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 | ||
79050 | 79050 | 2020-10-14 | India | Puducherry | 32245 | 568 | 27152 | 4525 | 11.882658 | 78.86498 | 2020-10-15 04:24:28 | Puducherry, India | ||
83057 | 83057 | 2021-05-25 | India | Puducherry | 98219 | 1408 | 81336 | 15475 | 11.882658 | 78.86498 | 2021-05-26 04:20:35 | Puducherry, India | ||
87071 | 87071 | 2021-11-09 | India | Puducherry | 128263 | 1862 | 0 | 11.882658000000001 | 78.86498 | 2021-11-10 04:21:38 | Puducherry, India | |||
91088 | 91088 | 2022-07-23 | India | Puducherry | 169929 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-24 04:20:47 | Puducherry, India | |||
98432 | 98432 | 2020-08-04 | India | Puducherry | 4147 | 58 | 2537 | 1552 | 11.882658 | 78.86498 | 2020-08-05 04:34:43 | Puducherry, India | ||
99272 | 99272 | 2022-01-14 | India | Puducherry | 135337 | 1884 | 0 | 11.882658000000001 | 78.86498 | 2022-01-15 04:21:07 | Puducherry, India | |||
103288 | 103288 | 2021-08-15 | India | Puducherry | 122282 | 1805 | 0 | 11.882658000000001 | 78.86498 | 2021-08-16 04:21:31 | Puducherry, India | |||
107413 | 107413 | 2021-06-19 | India | Puducherry | 114596 | 1720 | 109083 | 3793 | 11.882658 | 78.86498 | 2021-06-20 04:21:48 | Puducherry, India | ||
114698 | 114698 | 2022-09-06 | India | Puducherry | 173094 | 1969 | 0 | 11.882658 | 78.86498 | 2022-09-07 04:20:59 | Puducherry, India | |||
122024 | 122024 | 2020-07-19 | India | Puducherry | 1999 | 28 | 1154 | 817 | 11.882658000000001 | 78.86498 | 2020-07-20 05:34:40 | 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 | ||
126679 | 126679 | 2022-01-09 | India | Puducherry | 130722 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-10 04:22:07 | Puducherry, India | |||
130696 | 130696 | 2022-10-04 | India | Puducherry | 174710 | 1974 | 0 | 11.882658 | 78.86498 | 2022-10-05 04:23:06 | Puducherry, India | |||
137917 | 137917 | 2021-12-04 | India | Puducherry | 129028 | 1874 | 0 | 11.882658000000001 | 78.86498 | 2021-12-05 04:22:25 | Puducherry, India | |||
141934 | 141934 | 2022-07-09 | India | Puducherry | 167531 | 1962 | 0 | 11.882658 | 78.86498 | 2022-07-10 04:20:54 | Puducherry, India | |||
145934 | 145934 | 2020-08-15 | India | Puducherry | 7354 | 106 | 4224 | 3024 | 11.882658 | 78.86498 | 2020-08-16 04:27:42 | Puducherry, India | ||
149930 | 149930 | 2021-11-29 | India | Puducherry | 128893 | 1872 | 0 | 11.882658000000001 | 78.86498 | 2021-11-30 04:22:53 | 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 | ||
157959 | 157959 | 2022-03-29 | India | Puducherry | 165774 | 1962 | 0 | 11.882658000000001 | 78.86498 | 2022-03-30 04:20:45 | Puducherry, India | |||
161974 | 161974 | 2021-11-19 | India | Puducherry | 128588 | 1869 | 0 | 11.882658000000001 | 78.86498 | 2021-11-20 04:22:17 | Puducherry, India | |||
165991 | 165991 | 2022-06-21 | India | Puducherry | 166107 | 1962 | 0 | 11.882658 | 78.86498 | 2022-06-22 04:20:54 | Puducherry, India | |||
170006 | 170006 | 2021-04-16 | India | Puducherry | 46393 | 702 | 42115 | 3576 | 11.882658 | 78.86498 | 2021-04-17 04:20:40 | Puducherry, India | ||
177342 | 177342 | 2020-07-27 | India | Puducherry | 2872 | 43 | 1720 | 1109 | 11.882658 | 78.86498 | 2020-07-28 04:58:43 | Puducherry, India | ||
177988 | 177988 | 2021-09-02 | India | Puducherry | 123802 | 1815 | 0 | 11.882658000000001 | 78.86498 | 2021-09-03 04:21:20 | 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 | ||
186017 | 186017 | 2022-02-13 | India | Puducherry | 165243 | 1957 | 0 | 11.882658000000001 | 78.86498 | 2022-02-14 04:20:51 | 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 | ||
194029 | 194029 | 2020-08-31 | India | Puducherry | 14411 | 228 | 9334 | 4849 | 11.882658 | 78.86498 | 2020-09-01 04:28:31 | Puducherry, India | ||
198205 | 198205 | 2022-10-19 | India | Puducherry | 175133 | 1974 | 0 | 11.882658 | 78.86498 | 2022-10-20 04:22:59 | 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 | ||
206216 | 206216 | 2020-08-19 | India | Puducherry | 8750 | 129 | 5312 | 3309 | 11.882658 | 78.86498 | 2020-08-20 04:27:43 | 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 | ||
217926 | 217926 | 2022-12-26 | India | Puducherry | 175505 | 1975 | 0 | 11.882658 | 78.86498 | 2022-12-27 04:21:07 | Puducherry, India | |||
221942 | 221942 | 2022-05-09 | India | Puducherry | 165797 | 1962 | 0 | 11.882658 | 78.86498 | 2022-05-10 04:20:50 | Puducherry, India | |||
229173 | 229173 | 2022-05-31 | India | Puducherry | 165859 | 1962 | 0 | 11.882658 | 78.86498 | 2022-06-01 04:20:55 | Puducherry, India | |||
233189 | 233189 | 2022-02-11 | India | Puducherry | 165071 | 1957 | 0 | 11.882658000000001 | 78.86498 | 2022-02-12 04:21:06 | 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 | ||
241217 | 241217 | 2021-04-02 | India | Puducherry | 41941 | 684 | 39837 | 1420 | 11.882658 | 78.86498 | 2021-04-03 04:20:44 | Puducherry, India | ||
245231 | 245231 | 2021-08-17 | India | Puducherry | 122391 | 1805 | 0 | 11.882658000000001 | 78.86498 | 2021-08-18 04:21:35 | Puducherry, India | |||
249245 | 249245 | 2021-09-04 | India | Puducherry | 124049 | 1816 | 0 | 11.882658000000001 | 78.86498 | 2021-09-05 04:21:33 | Puducherry, India | |||
253260 | 253260 | 2022-09-08 | India | Puducherry | 173202 | 1969 | 0 | 11.882658 | 78.86498 | 2022-09-09 04:21:11 | Puducherry, India | |||
257276 | 257276 | 2022-12-10 | India | Puducherry | 175497 | 1975 | 0 | 11.882658 | 78.86498 | 2022-12-11 04:20:50 | Puducherry, India | |||
261479 | 261479 | 2022-03-15 | India | Puducherry | 165764 | 1962 | 0 | 11.882658000000001 | 78.86498 | 2022-03-16 04:20:50 | 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 | ||
276129 | 276129 | 2021-11-03 | India | Puducherry | 128106 | 1859 | 0 | 11.882658000000001 | 78.86498 | 2021-11-04 04:22:20 | 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 | ||
287304 | 287304 | 2020-06-15 | India | Puducherry | 202 | 5 | 95 | 102 | 11.882658000000001 | 78.86498 | 2020-06-16 04:33:09 | Puducherry, India | ||
287942 | 287942 | 2021-10-31 | India | Puducherry | 128013 | 1857 | 0 | 11.882658000000001 | 78.86498 | 2021-11-01 04:22:01 | Puducherry, India | |||
291959 | 291959 | 2022-11-15 | India | Puducherry | 175475 | 1975 | 0 | 11.882658 | 78.86498 | 2022-11-16 04:21:09 | Puducherry, India | |||
295974 | 295974 | 2021-07-15 | India | Puducherry | 119405 | 1773 | 116325 | 1307 | 11.882658 | 78.86498 | 2021-07-16 04:21:22 | Puducherry, India | ||
303176 | 303176 | 2020-07-01 | India | Puducherry | 714 | 12 | 272 | 430 | 11.882658000000001 | 78.86498 | 2020-07-02 04:33:46 | Puducherry, India | ||
303815 | 303815 | 2022-04-16 | India | Puducherry | 165777 | 1962 | 0 | 11.882658000000001 | 78.86498 | 2022-04-17 04:20:59 | Puducherry, India | |||
307831 | 307831 | 2022-12-13 | India | Puducherry | 175501 | 1975 | 0 | 11.882658 | 78.86498 | 2022-12-14 04:21:04 | Puducherry, India | |||
311847 | 311847 | 2022-11-13 | India | Puducherry | 175466 | 1975 | 0 | 11.882658 | 78.86498 | 2022-11-14 04:21:09 | Puducherry, India | |||
315863 | 315863 | 2022-02-12 | India | Puducherry | 165152 | 1957 | 0 | 11.882658000000001 | 78.86498 | 2022-02-13 04:21:00 | Puducherry, India | |||
319879 | 319879 | 2022-10-30 | India | Puducherry | 175375 | 1974 | 0 | 11.882658 | 78.86498 | 2022-10-31 04:21:36 | Puducherry, India | |||
327119 | 327119 | 2020-07-20 | India | Puducherry | 2092 | 29 | 1265 | 798 | 11.882658000000001 | 78.86498 | 2020-07-21 04:38:46 | Puducherry, India | ||
327853 | 327853 | 2022-12-27 | India | Puducherry | 175505 | 1975 | 0 | 11.882658 | 78.86498 | 2022-12-28 04:21:04 | Puducherry, India | |||
331868 | 331868 | 2021-08-04 | India | Puducherry | 121252 | 1798 | 118547 | 907 | 11.882658 | 78.86498 | 2021-08-05 04:21:51 | Puducherry, India | ||
335883 | 335883 | 2022-03-18 | India | Puducherry | 165766 | 1962 | 0 | 11.882658000000001 | 78.86498 | 2022-03-19 04:20:47 | 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 | ||
344237 | 344237 | 2020-09-14 | India | Puducherry | 19833 | 385 | 14570 | 4878 | 11.882658 | 78.86498 | 2020-09-15 03:22:50 | Puducherry, India | ||
348243 | 348243 | 2022-12-14 | India | Puducherry | 175501 | 1975 | 0 | 11.882658 | 78.86498 | 2022-12-15 04:20:58 | Puducherry, India | |||
352258 | 352258 | 2021-03-11 | India | Puducherry | 39954 | 670 | 39108 | 176 | 11.882658 | 78.86498 | 2021-03-12 05:26:50 | Puducherry, India | ||
356273 | 356273 | 2022-03-11 | India | Puducherry | 165757 | 1962 | 0 | 11.882658000000001 | 78.86498 | 2022-03-12 04:20:50 | Puducherry, India | |||
360289 | 360289 | 2022-05-07 | India | Puducherry | 165797 | 1962 | 0 | 11.882658 | 78.86498 | 2022-05-08 04:20:49 | Puducherry, India | |||
367524 | 367524 | 2020-07-16 | India | Puducherry | 1743 | 22 | 947 | 774 | 11.882658 | 78.86498 | 2020-07-17 04:34:50 | Puducherry, India | ||
371497 | 371497 | 2020-08-08 | India | Puducherry | 5123 | 80 | 3054 | 1989 | 11.882658 | 78.86498 | 2020-08-09 04:34:54 | Puducherry, India | ||
372143 | 372143 | 2022-09-13 | India | Puducherry | 173460 | 1969 | 0 | 11.882658 | 78.86498 | 2022-09-14 04:20:44 | 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 | ||
380155 | 380155 | 2021-04-30 | India | Puducherry | 58622 | 805 | 48298 | 9519 | 11.882658 | 78.86498 | 2021-05-01 04:20:47 | Puducherry, India | ||
384170 | 384170 | 2022-09-23 | India | Puducherry | 174248 | 1973 | 0 | 11.882658 | 78.86498 | 2022-09-24 04:21:40 | Puducherry, India | |||
388185 | 388185 | 2021-04-04 | India | Puducherry | 42359 | 684 | 40083 | 1592 | 11.882658 | 78.86498 | 2021-04-05 04:20:35 | 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 | ||
396211 | 396211 | 2022-10-07 | India | Puducherry | 174822 | 1974 | 0 | 11.882658 | 78.86498 | 2022-10-08 04:22:56 | Puducherry, India | |||
400226 | 400226 | 2021-06-29 | India | Puducherry | 116985 | 1748 | 112892 | 2345 | 11.882658 | 78.86498 | 2021-06-30 04:21:41 | Puducherry, India | ||
404240 | 404240 | 2021-12-07 | India | Puducherry | 129105 | 1876 | 0 | 11.882658000000001 | 78.86498 | 2021-12-08 04:22:46 | Puducherry, India | |||
408256 | 408256 | 2021-07-28 | India | Puducherry | 120627 | 1792 | 117912 | 923 | 11.882658 | 78.86498 | 2021-07-29 04:21:33 | Puducherry, India | ||
415468 | 415468 | 2020-07-05 | India | Puducherry | 802 | 12 | 331 | 459 | 11.882658000000001 | 78.86498 | 2020-07-06 04:33:57 | Puducherry, India | ||
419282 | 419282 | 2022-09-18 | India | Puducherry | 173891 | 1970 | 0 | 11.882658 | 78.86498 | 2022-09-19 04:21:49 | Puducherry, India | |||
423297 | 423297 | 2021-10-10 | India | Puducherry | 127053 | 1846 | 0 | 11.882658000000001 | 78.86498 | 2021-10-11 04:21:31 | Puducherry, India | |||
427298 | 427298 | 2020-09-07 | India | Puducherry | 17316 | 325 | 12135 | 4856 | 11.882658 | 78.86498 | 2020-09-08 04:28:25 | 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]);