johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Tripura" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
282 | 282 | 2021-12-02 | India | Tripura | 84835 | 825 | 0 | 23.746782999999997 | 91.743565 | 2021-12-03 04:23:05 | Tripura, India | |||
4298 | 4298 | 2021-10-28 | India | Tripura | 84449 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-29 04:22:03 | Tripura, India | |||
16323 | 16323 | 2021-09-18 | India | Tripura | 83840 | 808 | 0 | 23.746782999999997 | 91.743565 | 2021-09-19 04:21:34 | Tripura, India | |||
24353 | 24353 | 2022-03-20 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-21 04:20:50 | Tripura, India | |||
28368 | 28368 | 2021-11-11 | India | Tripura | 84644 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-12 04:22:01 | Tripura, India | |||
32384 | 32384 | 2021-08-25 | India | Tripura | 82498 | 793 | 0 | 23.746782999999997 | 91.743565 | 2021-08-26 04:21:28 | Tripura, India | |||
43660 | 43660 | 2021-11-02 | India | Tripura | 84531 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-03 06:22:09 | Tripura, India | |||
67029 | 67029 | 2021-09-01 | India | Tripura | 83065 | 802 | 0 | 23.746782999999997 | 91.743565 | 2021-09-02 04:21:15 | Tripura, India | |||
71043 | 71043 | 2022-02-07 | India | Tripura | 100697 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-08 04:21:15 | Tripura, India | |||
87077 | 87077 | 2021-11-09 | India | Tripura | 84624 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-10 04:21:38 | Tripura, India | |||
99278 | 99278 | 2022-01-14 | India | Tripura | 89767 | 835 | 0 | 23.746782999999997 | 91.743565 | 2022-01-15 04:21:07 | Tripura, India | |||
103294 | 103294 | 2021-08-15 | India | Tripura | 81311 | 781 | 0 | 23.746782999999997 | 91.743565 | 2021-08-16 04:21:31 | Tripura, India | |||
122122 | 122122 | 2020-07-19 | India | Tripura | 2878 | 5 | 1759 | 1114 | 23.746782999999997 | 91.743565 | 2020-07-20 05:34:40 | Tripura, India | ||
126685 | 126685 | 2022-01-09 | India | Tripura | 85936 | 830 | 0 | 23.746782999999997 | 91.743565 | 2022-01-10 04:22:07 | Tripura, India | |||
137923 | 137923 | 2021-12-04 | India | Tripura | 84844 | 825 | 0 | 23.746782999999997 | 91.743565 | 2021-12-05 04:22:25 | Tripura, India | |||
149936 | 149936 | 2021-11-29 | India | Tripura | 84791 | 823 | 0 | 23.746782999999997 | 91.743565 | 2021-11-30 04:22:53 | Tripura, India | |||
157965 | 157965 | 2022-03-29 | India | Tripura | 100873 | 920 | 0 | 23.746782999999997 | 91.743565 | 2022-03-30 04:20:45 | Tripura, India | |||
161980 | 161980 | 2021-11-19 | India | Tripura | 84708 | 818 | 0 | 23.746782999999997 | 91.743565 | 2021-11-20 04:22:17 | Tripura, India | |||
177994 | 177994 | 2021-09-02 | India | Tripura | 83127 | 803 | 0 | 23.746782999999997 | 91.743565 | 2021-09-03 04:21:20 | Tripura, India | |||
186023 | 186023 | 2022-02-13 | India | Tripura | 100794 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-14 04:20:51 | Tripura, India | |||
233195 | 233195 | 2022-02-11 | India | Tripura | 100778 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-12 04:21:06 | Tripura, India | |||
245237 | 245237 | 2021-08-17 | India | Tripura | 81584 | 782 | 0 | 23.746782999999997 | 91.743565 | 2021-08-18 04:21:35 | Tripura, India | |||
249251 | 249251 | 2021-09-04 | India | Tripura | 83284 | 803 | 0 | 23.746782999999997 | 91.743565 | 2021-09-05 04:21:33 | Tripura, India | |||
261485 | 261485 | 2022-03-15 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-16 04:20:50 | Tripura, India | |||
276135 | 276135 | 2021-11-03 | India | Tripura | 84548 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-04 04:22:20 | Tripura, India | |||
287403 | 287403 | 2020-06-15 | India | Tripura | 1086 | 1 | 433 | 652 | 23.746782999999997 | 91.743565 | 2020-06-16 04:33:09 | Tripura, India | ||
287948 | 287948 | 2021-10-31 | India | Tripura | 84504 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-01 04:22:01 | Tripura, India | |||
303275 | 303275 | 2020-07-01 | India | Tripura | 1396 | 1 | 1093 | 302 | 23.746782999999997 | 91.743565 | 2020-07-02 04:33:46 | Tripura, India | ||
303821 | 303821 | 2022-04-16 | India | Tripura | 100878 | 922 | 0 | 23.746782999999997 | 91.743565 | 2022-04-17 04:20:59 | Tripura, India | |||
315869 | 315869 | 2022-02-12 | India | Tripura | 100790 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-13 04:21:00 | Tripura, India | |||
327217 | 327217 | 2020-07-20 | India | Tripura | 3079 | 7 | 1845 | 1227 | 23.746782999999997 | 91.743565 | 2020-07-21 04:38:46 | Tripura, India | ||
335889 | 335889 | 2022-03-18 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-19 04:20:47 | Tripura, India | |||
356279 | 356279 | 2022-03-11 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-12 04:20:50 | Tripura, India | |||
404246 | 404246 | 2021-12-07 | India | Tripura | 84874 | 826 | 0 | 23.746782999999997 | 91.743565 | 2021-12-08 04:22:46 | Tripura, India | |||
415567 | 415567 | 2020-07-05 | India | Tripura | 1568 | 1 | 1202 | 365 | 23.746782999999997 | 91.743565 | 2020-07-06 04:33:57 | Tripura, India | ||
423303 | 423303 | 2021-10-10 | India | Tripura | 84260 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-11 04:21:31 | Tripura, India | |||
443307 | 443307 | 2021-10-20 | India | Tripura | 84351 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-21 04:21:18 | Tripura, India | |||
447323 | 447323 | 2021-11-17 | India | Tripura | 84692 | 817 | 0 | 23.746782999999997 | 91.743565 | 2021-11-18 04:21:33 | Tripura, India | |||
459332 | 459332 | 2022-02-02 | India | Tripura | 100522 | 914 | 0 | 23.746782999999997 | 91.743565 | 2022-02-03 04:21:21 | Tripura, India | |||
467364 | 467364 | 2021-10-07 | India | Tripura | 84223 | 815 | 0 | 23.746782999999997 | 91.743565 | 2021-10-08 04:21:25 | Tripura, India | |||
491588 | 491588 | 2021-10-14 | India | Tripura | 84295 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-15 04:21:26 | Tripura, India | |||
495604 | 495604 | 2021-11-06 | India | Tripura | 84570 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-07 04:21:53 | Tripura, India | |||
499621 | 499621 | 2022-04-02 | India | Tripura | 100877 | 921 | 0 | 23.746782999999997 | 91.743565 | 2022-04-03 04:20:48 | Tripura, India | |||
507652 | 507652 | 2021-08-14 | India | Tripura | 81259 | 780 | 0 | 23.746782999999997 | 91.743565 | 2021-08-15 04:21:41 | Tripura, India | |||
511666 | 511666 | 2021-08-19 | India | Tripura | 81826 | 785 | 0 | 23.746782999999997 | 91.743565 | 2021-08-20 04:21:33 | Tripura, India | |||
530129 | 530129 | 2020-07-04 | India | Tripura | 1546 | 1 | 1202 | 343 | 23.746782999999997 | 91.743565 | 2020-07-05 04:33:46 | Tripura, India | ||
534688 | 534688 | 2021-10-27 | India | Tripura | 84438 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-28 04:22:08 | Tripura, India | |||
550726 | 550726 | 2021-12-08 | India | Tripura | 84888 | 826 | 0 | 23.746782999999997 | 91.743565 | 2021-12-09 04:22:49 | Tripura, India | |||
554742 | 554742 | 2022-01-16 | India | Tripura | 91576 | 840 | 0 | 23.746782999999997 | 91.743565 | 2022-01-17 04:21:08 | Tripura, India | |||
567056 | 567056 | 2021-10-29 | India | Tripura | 84459 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-30 04:22:03 | Tripura, India | |||
574785 | 574785 | 2022-02-25 | India | Tripura | 100859 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-26 04:21:12 | Tripura, India | |||
597626 | 597626 | 2021-10-19 | India | Tripura | 84349 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-20 04:21:00 | Tripura, India | |||
601642 | 601642 | 2021-09-23 | India | Tripura | 84014 | 810 | 0 | 23.746782999999997 | 91.743565 | 2021-09-24 04:21:44 | Tripura, India | |||
633876 | 633876 | 2021-10-13 | India | Tripura | 84291 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-14 04:21:29 | Tripura, India | |||
641906 | 641906 | 2021-09-07 | India | Tripura | 83414 | 803 | 0 | 23.746782999999997 | 91.743565 | 2021-09-08 04:21:31 | Tripura, India | |||
649934 | 649934 | 2021-08-09 | India | Tripura | 80416 | 771 | 0 | 23.746782999999997 | 91.743565 | 2021-08-10 04:21:27 | Tripura, India | |||
653948 | 653948 | 2021-10-22 | India | Tripura | 84376 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-23 04:21:32 | Tripura, India | |||
682293 | 682293 | 2021-10-24 | India | Tripura | 84389 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-25 04:22:31 | Tripura, India | |||
686309 | 686309 | 2021-11-13 | India | Tripura | 84665 | 817 | 0 | 23.746782999999997 | 91.743565 | 2021-11-14 04:21:31 | Tripura, India | |||
694342 | 694342 | 2022-03-17 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-18 04:20:55 | Tripura, India | |||
698357 | 698357 | 2021-11-04 | India | Tripura | 84557 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-05 04:21:54 | Tripura, India | |||
706387 | 706387 | 2021-09-29 | India | Tripura | 84127 | 813 | 0 | 23.746782999999997 | 91.743565 | 2021-09-30 04:21:20 | Tripura, India | |||
714418 | 714418 | 2021-11-12 | India | Tripura | 84655 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-13 04:21:38 | Tripura, India | |||
722450 | 722450 | 2021-11-20 | India | Tripura | 84720 | 818 | 0 | 23.746782999999997 | 91.743565 | 2021-11-21 04:22:13 | Tripura, India | |||
730480 | 730480 | 2021-12-27 | India | Tripura | 85028 | 829 | 0 | 23.746782999999997 | 91.743565 | 2021-12-28 04:21:47 | Tripura, India | |||
737726 | 737726 | 2020-06-12 | India | Tripura | 913 | 1 | 278 | 634 | 23.746782999999997 | 91.743565 | 2020-06-13 03:33:14 | Tripura, India | ||
746297 | 746297 | 2022-04-23 | India | Tripura | 100879 | 922 | 0 | 23.746782999999997 | 91.743565 | 2022-04-24 04:20:56 | Tripura, India | |||
758280 | 758280 | 2021-11-26 | India | Tripura | 84771 | 820 | 0 | 23.746782999999997 | 91.743565 | 2021-11-27 04:22:45 | Tripura, India | |||
770301 | 770301 | 2021-10-23 | India | Tripura | 84384 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-24 04:21:22 | Tripura, India | |||
782343 | 782343 | 2021-12-13 | India | Tripura | 84934 | 826 | 0 | 23.746782999999997 | 91.743565 | 2021-12-14 04:22:38 | Tripura, India | |||
798382 | 798382 | 2021-12-22 | India | Tripura | 84990 | 828 | 0 | 23.746782999999997 | 91.743565 | 2021-12-23 04:21:21 | Tripura, India | |||
809544 | 809544 | 2021-09-20 | India | Tripura | 83905 | 809 | 0 | 23.746782999999997 | 91.743565 | 2021-09-21 04:21:26 | Tripura, India | |||
876217 | 876217 | 2022-03-27 | India | Tripura | 100872 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-28 04:20:33 | Tripura, India | |||
887542 | 887542 | 2020-07-07 | India | Tripura | 1704 | 1 | 1248 | 455 | 23.746782999999997 | 91.743565 | 2020-07-08 05:33:48 | Tripura, India | ||
904131 | 904131 | 2021-11-24 | India | Tripura | 84759 | 820 | 0 | 23.746782999999997 | 91.743565 | 2021-11-25 04:22:33 | Tripura, India | |||
919637 | 919637 | 2022-03-08 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-09 04:20:59 | Tripura, India | |||
934753 | 934753 | 2021-10-16 | India | Tripura | 84305 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-17 04:21:29 | Tripura, India | |||
942786 | 942786 | 2022-02-28 | India | Tripura | 100862 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-01 04:21:09 | Tripura, India | |||
950818 | 950818 | 2022-03-12 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-13 04:20:49 | Tripura, India | |||
978901 | 978901 | 2022-02-01 | India | Tripura | 100454 | 913 | 0 | 23.746782999999997 | 91.743565 | 2022-02-02 04:21:09 | Tripura, India | |||
986931 | 986931 | 2021-10-04 | India | Tripura | 84192 | 815 | 0 | 23.746782999999997 | 91.743565 | 2021-10-05 04:21:27 | Tripura, India | |||
1005717 | 1005717 | 2020-07-09 | India | Tripura | 1776 | 1 | 1338 | 437 | 23.746782999999997 | 91.743565 | 2020-07-10 04:34:24 | Tripura, India | ||
1014286 | 1014286 | 2021-11-21 | India | Tripura | 84721 | 818 | 0 | 23.746782999999997 | 91.743565 | 2021-11-22 04:22:20 | Tripura, India | |||
1030328 | 1030328 | 2021-12-06 | India | Tripura | 84866 | 825 | 0 | 23.746782999999997 | 91.743565 | 2021-12-07 04:22:34 | Tripura, India | |||
1057802 | 1057802 | 2022-02-23 | India | Tripura | 100856 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-24 04:21:14 | Tripura, India | |||
1077877 | 1077877 | 2021-12-09 | India | Tripura | 84898 | 826 | 0 | 23.746782999999997 | 91.743565 | 2021-12-10 04:22:28 | Tripura, India | |||
1113542 | 1113542 | 2022-01-11 | India | Tripura | 86515 | 831 | 0 | 23.746782999999997 | 91.743565 | 2022-01-12 04:21:44 | Tripura, India | |||
1136309 | 1136309 | 2020-06-26 | India | Tripura | 1325 | 1 | 1055 | 269 | 23.746782999999997 | 91.743565 | 2020-06-27 04:33:35 | Tripura, India | ||
1140865 | 1140865 | 2022-01-23 | India | Tripura | 98195 | 872 | 0 | 23.746782999999997 | 91.743565 | 2022-01-24 04:21:12 | Tripura, India | |||
1144881 | 1144881 | 2021-12-01 | India | Tripura | 84820 | 824 | 0 | 23.746782999999997 | 91.743565 | 2021-12-02 04:22:37 | Tripura, India | |||
1196077 | 1196077 | 2020-06-17 | India | Tripura | 1135 | 1 | 556 | 578 | 23.746782999999997 | 91.743565 | 2020-06-18 04:33:18 | Tripura, India | ||
1215520 | 1215520 | 2022-01-08 | India | Tripura | 85760 | 830 | 0 | 23.746782999999997 | 91.743565 | 2022-01-09 04:21:46 | Tripura, India | |||
1223551 | 1223551 | 2022-04-14 | India | Tripura | 100878 | 922 | 0 | 23.746782999999997 | 91.743565 | 2022-04-15 04:20:57 | Tripura, India | |||
1227566 | 1227566 | 2022-01-24 | India | Tripura | 98899 | 879 | 0 | 23.746782999999997 | 91.743565 | 2022-01-25 04:21:05 | Tripura, India | |||
1231582 | 1231582 | 2021-11-28 | India | Tripura | 84787 | 821 | 0 | 23.746782999999997 | 91.743565 | 2021-11-29 04:22:30 | Tripura, India | |||
1235598 | 1235598 | 2021-09-27 | India | Tripura | 84085 | 811 | 0 | 23.746782999999997 | 91.743565 | 2021-09-28 04:21:28 | Tripura, India | |||
1254725 | 1254725 | 2021-12-20 | India | Tripura | 84973 | 827 | 0 | 23.746782999999997 | 91.743565 | 2021-12-21 03:21:27 | Tripura, India | |||
1258741 | 1258741 | 2021-12-18 | India | Tripura | 84958 | 827 | 0 | 23.746782999999997 | 91.743565 | 2021-12-19 04:21:11 | Tripura, India | |||
1262757 | 1262757 | 2021-09-09 | India | Tripura | 83523 | 805 | 0 | 23.746782999999997 | 91.743565 | 2021-09-10 04:21:20 | Tripura, India | |||
1273696 | 1273696 | 2020-06-11 | India | Tripura | 913 | 1 | 278 | 634 | 23.746782999999997 | 91.743565 | 2020-06-12 05:09:52 | Tripura, 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]);