johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Tripura" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
287403 | 287403 | 2020-06-15 | India | Tripura | 1086 | 1 | 433 | 652 | 23.746782999999997 | 91.743565 | 2020-06-16 04:33:09 | 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 | ||
415567 | 415567 | 2020-07-05 | India | Tripura | 1568 | 1 | 1202 | 365 | 23.746782999999997 | 91.743565 | 2020-07-06 04:33:57 | 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 | ||
737726 | 737726 | 2020-06-12 | India | Tripura | 913 | 1 | 278 | 634 | 23.746782999999997 | 91.743565 | 2020-06-13 03:33:14 | 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 | ||
1005717 | 1005717 | 2020-07-09 | India | Tripura | 1776 | 1 | 1338 | 437 | 23.746782999999997 | 91.743565 | 2020-07-10 04:34:24 | 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 | ||
1196077 | 1196077 | 2020-06-17 | India | Tripura | 1135 | 1 | 556 | 578 | 23.746782999999997 | 91.743565 | 2020-06-18 04:33:18 | 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 | ||
1510815 | 1510815 | 2020-06-22 | India | Tripura | 1237 | 1 | 782 | 454 | 23.746782999999997 | 91.743565 | 2020-06-23 04:33:22 | Tripura, India | ||
1522621 | 1522621 | 2020-06-23 | India | Tripura | 1259 | 1 | 807 | 451 | 23.746782999999997 | 91.743565 | 2020-06-24 04:33:28 | Tripura, India | ||
1691725 | 1691725 | 2020-06-19 | India | Tripura | 1178 | 1 | 657 | 520 | 23.746782999999997 | 91.743565 | 2020-06-20 04:33:19 | Tripura, India | ||
1837354 | 1837354 | 2020-06-14 | India | Tripura | 1046 | 1 | 315 | 730 | 23.746782999999997 | 91.743565 | 2020-06-15 03:33:14 | Tripura, India | ||
2040028 | 2040028 | 2020-06-27 | India | Tripura | 1334 | 1 | 1071 | 262 | 23.746782999999997 | 91.743565 | 2020-06-28 04:34:04 | Tripura, India | ||
2222933 | 2222933 | 2020-07-08 | India | Tripura | 1761 | 1 | 1324 | 436 | 23.746782999999997 | 91.743565 | 2020-07-09 04:34:23 | Tripura, India | ||
2234790 | 2234790 | 2020-07-03 | India | Tripura | 1525 | 1 | 1199 | 325 | 23.746782999999997 | 91.743565 | 2020-07-04 04:33:51 | Tripura, India | ||
2306693 | 2306693 | 2020-06-28 | India | Tripura | 1346 | 1 | 1079 | 266 | 23.746782999999997 | 91.743565 | 2020-06-29 04:33:44 | Tripura, India | ||
2386840 | 2386840 | 2020-06-16 | India | Tripura | 1092 | 1 | 433 | 658 | 23.746782999999997 | 91.743565 | 2020-06-17 04:33:21 | Tripura, India | ||
2438147 | 2438147 | 2020-06-20 | India | Tripura | 1186 | 1 | 680 | 505 | 23.746782999999997 | 91.743565 | 2020-06-21 04:33:19 | Tripura, India | ||
2625296 | 2625296 | 2020-06-25 | India | Tripura | 1290 | 1 | 1019 | 270 | 23.746782999999997 | 91.743565 | 2020-06-26 04:33:43 | Tripura, India | ||
2633130 | 2633130 | 2020-06-29 | India | Tripura | 1380 | 1 | 1085 | 294 | 23.746783 | 91.743565 | 2020-06-30 04:33:48 | Tripura, India | ||
2685102 | 2685102 | 2020-07-06 | India | Tripura | 1680 | 1 | 1219 | 460 | 23.746782999999997 | 91.743565 | 2020-07-07 04:34:00 | Tripura, India | ||
2700936 | 2700936 | 2020-06-24 | India | Tripura | 1259 | 1 | 897 | 361 | 23.746782999999997 | 91.743565 | 2020-06-25 05:26:54 | Tripura, India | ||
2864137 | 2864137 | 2020-06-10 | India | Tripura | 864 | 1 | 192 | 671 | 23.746783 | 91.743565 | 2020-06-11 03:33:41 | Tripura, India | ||
2974653 | 2974653 | 2020-06-30 | India | Tripura | 1388 | 1 | 1086 | 301 | 23.746782999999997 | 91.743565 | 2020-07-01 04:33:52 | Tripura, India | ||
3045584 | 3045584 | 2020-07-02 | India | Tripura | 1435 | 1 | 1146 | 288 | 23.746783 | 91.743565 | 2020-07-03 04:33:54 | Tripura, India | ||
3061406 | 3061406 | 2020-06-13 | India | Tripura | 961 | 1 | 278 | 682 | 23.746782999999997 | 91.743565 | 2020-06-14 03:33:15 | Tripura, India | ||
3237732 | 3237732 | 2020-07-10 | India | Tripura | 1918 | 1 | 1372 | 545 | 23.746782999999997 | 91.743565 | 2020-07-11 04:34:26 | Tripura, India | ||
3249554 | 3249554 | 2020-06-21 | India | Tripura | 1221 | 1 | 759 | 461 | 23.746782999999997 | 91.743565 | 2020-06-22 04:33:20 | Tripura, India | ||
3436234 | 3436234 | 2020-07-11 | India | Tripura | 1918 | 1 | 1372 | 545 | 23.746783 | 91.743565 | 2020-07-12 03:34:27 | Tripura, India | ||
3682874 | 3682874 | 2020-06-18 | India | Tripura | 1155 | 1 | 639 | 515 | 23.746782999999997 | 91.743565 | 2020-06-19 04:33:17 | Tripura, India | ||
2158935 | 2158935 | 2020-07-14 | India | Tripura | 2170 | 2 | 1538 | 630 | 23.746782999999997 | 91.743565 | 2020-07-15 04:34:39 | Tripura, India | ||
3491576 | 3491576 | 2020-07-13 | India | Tripura | 2080 | 2 | 1475 | 603 | 23.746782999999997 | 91.743565 | 2020-07-14 04:34:46 | Tripura, India | ||
3737839 | 3737839 | 2020-07-12 | India | Tripura | 2054 | 2 | 1421 | 631 | 23.746782999999997 | 91.743565 | 2020-07-13 04:43:04 | Tripura, India | ||
367623 | 367623 | 2020-07-16 | India | Tripura | 2283 | 3 | 1604 | 676 | 23.746783 | 91.743565 | 2020-07-17 04:34:50 | Tripura, India | ||
2708813 | 2708813 | 2020-07-17 | India | Tripura | 2366 | 3 | 1684 | 679 | 23.746782999999997 | 91.743565 | 2020-07-18 04:34:45 | Tripura, India | ||
2748291 | 2748291 | 2020-07-15 | India | Tripura | 2268 | 3 | 1604 | 661 | 23.746783 | 91.743565 | 2020-07-16 04:44:59 | 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 | ||
3205511 | 3205511 | 2020-07-18 | India | Tripura | 2654 | 5 | 1735 | 914 | 23.746782999999997 | 91.743565 | 2020-07-19 04:34:58 | 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 | ||
1707726 | 1707726 | 2020-07-21 | India | Tripura | 3331 | 8 | 1926 | 1397 | 23.746782999999997 | 91.743565 | 2020-07-22 04:34:42 | Tripura, India | ||
844987 | 844987 | 2020-07-22 | India | Tripura | 3449 | 9 | 2032 | 1408 | 23.746783 | 91.743565 | 2020-07-23 05:15:04 | Tripura, India | ||
62170 | 62170 | 2020-07-23 | India | Tripura | 3656 | 10 | 2072 | 1574 | 23.746783 | 91.743565 | 2020-07-24 05:30:40 | Tripura, India | ||
1502996 | 1502996 | 2020-07-25 | India | Tripura | 3862 | 11 | 2209 | 1642 | 23.746783 | 91.743565 | 2020-07-26 04:35:00 | Tripura, India | ||
2563967 | 2563967 | 2020-07-24 | India | Tripura | 3759 | 11 | 2131 | 1617 | 23.746783 | 91.743565 | 2020-07-25 04:47:39 | Tripura, India | ||
442753 | 442753 | 2020-07-26 | India | Tripura | 3900 | 13 | 2361 | 1526 | 23.746783 | 91.743565 | 2020-07-27 04:35:02 | Tripura, India | ||
177439 | 177439 | 2020-07-27 | India | Tripura | 4049 | 17 | 2467 | 1565 | 23.746783 | 91.743565 | 2020-07-28 04:58:43 | Tripura, India | ||
3185389 | 3185389 | 2020-07-28 | India | Tripura | 4049 | 17 | 2467 | 1565 | 23.746783 | 91.743565 | 2020-07-29 04:35:11 | Tripura, India | ||
1928604 | 1928604 | 2020-07-30 | India | Tripura | 4706 | 21 | 2962 | 1723 | 23.746783 | 91.743565 | 2020-07-31 04:35:18 | Tripura, India | ||
2958772 | 2958772 | 2020-07-29 | India | Tripura | 4485 | 21 | 2678 | 1786 | 23.746783 | 91.743565 | 2020-07-30 04:35:05 | Tripura, India | ||
3264898 | 3264898 | 2020-07-31 | India | Tripura | 4978 | 21 | 3327 | 1630 | 23.746783 | 91.743565 | 2020-08-01 04:36:27 | Tripura, India | ||
753733 | 753733 | 2020-08-01 | India | Tripura | 5233 | 23 | 3463 | 1747 | 23.746783 | 91.743565 | 2020-08-02 04:34:47 | Tripura, India | ||
2808165 | 2808165 | 2020-08-02 | India | Tripura | 5374 | 27 | 3605 | 1742 | 23.746783 | 91.743565 | 2020-08-03 04:34:35 | Tripura, India | ||
2740413 | 2740413 | 2020-08-03 | India | Tripura | 5505 | 28 | 3675 | 1802 | 23.746783 | 91.743565 | 2020-08-04 04:41:59 | Tripura, India | ||
98530 | 98530 | 2020-08-04 | India | Tripura | 5628 | 30 | 3725 | 1873 | 23.746783 | 91.743565 | 2020-08-05 04:34:43 | Tripura, India | ||
3793294 | 3793294 | 2020-08-05 | India | Tripura | 5725 | 31 | 3793 | 1901 | 23.746783 | 91.743565 | 2020-08-06 04:35:02 | Tripura, India | ||
3612464 | 3612464 | 2020-08-06 | India | Tripura | 5853 | 36 | 3860 | 1957 | 23.746783 | 91.743565 | 2020-08-07 04:35:11 | Tripura, India | ||
458779 | 458779 | 2020-08-07 | India | Tripura | 5999 | 37 | 4084 | 1878 | 23.746783 | 91.743565 | 2020-08-08 04:34:53 | Tripura, India | ||
371595 | 371595 | 2020-08-08 | India | Tripura | 6146 | 41 | 4176 | 1929 | 23.746783 | 91.743565 | 2020-08-09 04:34:54 | Tripura, India | ||
3923427 | 3923427 | 2020-08-09 | India | Tripura | 6208 | 42 | 4443 | 1723 | 23.746783 | 91.743565 | 2020-08-10 04:34:55 | Tripura, India | ||
662267 | 662267 | 2020-08-11 | India | Tripura | 6482 | 43 | 4838 | 1601 | 23.746783 | 91.743565 | 2020-08-12 04:27:29 | Tripura, India | ||
1920618 | 1920618 | 2020-08-10 | India | Tripura | 6372 | 43 | 4656 | 1673 | 23.746783 | 91.743565 | 2020-08-11 04:35:08 | Tripura, India | ||
3531418 | 3531418 | 2020-08-12 | India | Tripura | 6603 | 44 | 4912 | 1647 | 23.746783 | 91.743565 | 2020-08-13 04:29:15 | Tripura, India | ||
582799 | 582799 | 2020-08-13 | India | Tripura | 6767 | 46 | 5015 | 1706 | 23.746783 | 91.743565 | 2020-08-14 04:51:19 | Tripura, India | ||
1612215 | 1612215 | 2020-08-14 | India | Tripura | 6934 | 50 | 5088 | 1796 | 23.746783 | 91.743565 | 2020-08-15 04:27:31 | Tripura, India | ||
145940 | 145940 | 2020-08-15 | India | Tripura | 7061 | 55 | 5151 | 1855 | 23.746783 | 91.743565 | 2020-08-16 04:27:42 | Tripura, India | ||
1555938 | 1555938 | 2020-08-16 | India | Tripura | 7204 | 59 | 5286 | 1859 | 23.746783 | 91.743565 | 2020-08-17 04:27:20 | Tripura, India | ||
837580 | 837580 | 2020-08-17 | India | Tripura | 7409 | 62 | 5404 | 1943 | 23.746783 | 91.743565 | 2020-08-18 04:27:56 | Tripura, India | ||
206222 | 206222 | 2020-08-19 | India | Tripura | 7835 | 65 | 5565 | 2205 | 23.746783 | 91.743565 | 2020-08-20 04:27:43 | Tripura, India | ||
3177976 | 3177976 | 2020-08-18 | India | Tripura | 7645 | 65 | 5497 | 2083 | 23.746783 | 91.743565 | 2020-08-19 04:27:00 | Tripura, India | ||
3484273 | 3484273 | 2020-08-20 | India | Tripura | 8091 | 69 | 5649 | 2373 | 23.746783 | 91.743565 | 2020-08-21 04:27:41 | Tripura, India | ||
1479524 | 1479524 | 2020-08-21 | India | Tripura | 8371 | 70 | 6061 | 2240 | 23.746783 | 91.743565 | 2020-08-22 04:27:49 | Tripura, India | ||
2299417 | 2299417 | 2020-08-22 | India | Tripura | 8702 | 72 | 6182 | 2448 | 23.746783 | 91.743565 | 2020-08-23 04:27:48 | Tripura, India | ||
2215635 | 2215635 | 2020-08-23 | India | Tripura | 8902 | 73 | 6341 | 2488 | 23.746783 | 91.743565 | 2020-08-24 04:27:56 | Tripura, India | ||
2991240 | 2991240 | 2020-08-24 | India | Tripura | 9195 | 78 | 6414 | 2703 | 23.746783 | 91.743565 | 2020-08-25 04:28:02 | Tripura, India | ||
3562536 | 3562536 | 2020-08-25 | India | Tripura | 9523 | 83 | 6574 | 2866 | 23.746783 | 91.743565 | 2020-08-26 04:28:11 | Tripura, India | ||
1996612 | 1996612 | 2020-08-26 | India | Tripura | 9908 | 85 | 6697 | 3126 | 23.746783 | 91.743565 | 2020-08-27 04:28:15 | Tripura, India | ||
2510152 | 2510152 | 2020-08-27 | India | Tripura | 10414 | 89 | 6839 | 3486 | 23.746783 | 91.743565 | 2020-08-28 04:28:11 | Tripura, India | ||
1523151 | 1523151 | 2020-08-28 | India | Tripura | 10857 | 94 | 7037 | 3726 | 23.746783 | 91.743565 | 2020-08-29 04:28:19 | Tripura, India | ||
609656 | 609656 | 2020-08-29 | India | Tripura | 11307 | 98 | 7232 | 3977 | 23.746783 | 91.743565 | 2020-08-30 04:28:22 | Tripura, India | ||
3931994 | 3931994 | 2020-08-30 | India | Tripura | 11644 | 103 | 7433 | 4108 | 23.746783 | 91.743565 | 2020-08-31 04:28:27 | Tripura, India | ||
194035 | 194035 | 2020-08-31 | India | Tripura | 12153 | 113 | 7674 | 4366 | 23.746783 | 91.743565 | 2020-09-01 04:28:31 | Tripura, India | ||
2059850 | 2059850 | 2020-09-01 | India | Tripura | 12702 | 118 | 7847 | 4737 | 23.746783 | 91.743565 | 2020-09-02 04:28:25 | Tripura, India | ||
1105521 | 1105521 | 2020-09-02 | India | Tripura | 13292 | 126 | 8033 | 5133 | 23.746783 | 91.743565 | 2020-09-03 04:28:22 | Tripura, India | ||
1354284 | 1354284 | 2020-09-03 | India | Tripura | 13816 | 129 | 8212 | 5475 | 23.746783 | 91.743565 | 2020-09-04 04:28:26 | Tripura, India | ||
2661744 | 2661744 | 2020-09-04 | India | Tripura | 14507 | 136 | 8483 | 5888 | 23.746783 | 91.743565 | 2020-09-05 04:28:19 | Tripura, India | ||
813544 | 813544 | 2020-09-05 | India | Tripura | 15109 | 144 | 8745 | 6220 | 23.746783 | 91.743565 | 2020-09-06 04:28:33 | Tripura, India | ||
3161589 | 3161589 | 2020-09-06 | India | Tripura | 15508 | 149 | 9048 | 6311 | 23.746783 | 91.743565 | 2020-09-07 04:28:30 | Tripura, India | ||
427304 | 427304 | 2020-09-07 | India | Tripura | 16135 | 152 | 9342 | 6641 | 23.746783 | 91.743565 | 2020-09-08 04:28:25 | Tripura, India | ||
1243725 | 1243725 | 2020-09-08 | India | Tripura | 16717 | 161 | 9653 | 6903 | 23.746783 | 91.743565 | 2020-09-09 04:28:48 | Tripura, India | ||
1173151 | 1173151 | 2020-09-10 | India | Tripura | 17811 | 173 | 10255 | 7383 | 23.746783 | 91.743565 | 2020-09-11 04:46:23 | Tripura, India | ||
2171516 | 2171516 | 2020-09-09 | India | Tripura | 17252 | 173 | 9993 | 7086 | 23.746783 | 91.743565 | 2020-09-10 04:29:01 | Tripura, India | ||
1444550 | 1444550 | 2020-09-11 | India | Tripura | 18281 | 182 | 10734 | 7365 | 23.746783 | 91.743565 | 2020-09-12 04:25:05 | Tripura, India | ||
546721 | 546721 | 2020-09-12 | India | Tripura | 18910 | 194 | 11132 | 7584 | 23.746783 | 91.743565 | 2020-09-13 04:30:52 | Tripura, India | ||
344243 | 344243 | 2020-09-14 | India | Tripura | 19165 | 200 | 11536 | 7429 | 23.746783 | 91.743565 | 2020-09-15 03:22:50 | Tripura, India | ||
2868682 | 2868682 | 2020-09-13 | India | Tripura | 19165 | 200 | 11536 | 7429 | 23.746783 | 91.743565 | 2020-09-14 04:26:00 | Tripura, India | ||
2728971 | 2728971 | 2020-09-15 | India | Tripura | 20150 | 217 | 12435 | 7498 | 23.746783 | 91.743565 | 2020-09-16 04:22:53 | Tripura, India | ||
666246 | 666246 | 2020-09-16 | India | Tripura | 20676 | 222 | 12956 | 7498 | 23.746783 | 91.743565 | 2020-09-17 04:22:00 | Tripura, India | ||
1121557 | 1121557 | 2020-09-17 | India | Tripura | 20949 | 228 | 13559 | 7162 | 23.746783 | 91.743565 | 2020-09-18 05:05:00 | 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]);