daily_reports (view)
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)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-18 | India | Tripura | 21484 | 235 | 14142 | 7107 | 23.746783 | 91.743565 | 2020-09-19 04:22:00 | Tripura, India | ||
2020-09-19 | India | Tripura | 22032 | 239 | 14810 | 6983 | 23.746783 | 91.743565 | 2020-09-20 04:22:00 | Tripura, India | ||
2020-09-20 | India | Tripura | 22275 | 245 | 15464 | 6566 | 23.746783 | 91.743565 | 2020-09-21 04:23:00 | Tripura, India | ||
2020-09-21 | India | Tripura | 22834 | 251 | 15883 | 6700 | 23.746783 | 91.743565 | 2020-09-22 04:23:00 | Tripura, India | ||
2020-09-22 | India | Tripura | 23338 | 253 | 16486 | 6599 | 23.746783 | 91.743565 | 2020-09-23 04:23:00 | Tripura, India | ||
2020-09-23 | India | Tripura | 23789 | 260 | 16978 | 6551 | 23.746783 | 91.743565 | 2020-09-24 04:23:00 | Tripura, India | ||
2020-09-24 | India | Tripura | 24130 | 265 | 17487 | 6378 | 23.746783 | 91.743565 | 2020-09-25 04:23:00 | Tripura, India | ||
2020-09-25 | India | Tripura | 24408 | 268 | 17992 | 6148 | 23.746783 | 91.743565 | 2020-09-26 04:23:00 | Tripura, India | ||
2020-09-26 | India | Tripura | 24728 | 270 | 18392 | 6066 | 23.746783 | 91.743565 | 2020-09-27 04:23:00 | Tripura, India | ||
2020-09-27 | India | Tripura | 24921 | 273 | 18959 | 5689 | 23.746783 | 91.743565 | 2020-09-28 04:23:00 | Tripura, India | ||
2020-09-28 | India | Tripura | 25353 | 276 | 19203 | 5874 | 23.746783 | 91.743565 | 2020-09-29 04:23:42 | Tripura, India | ||
2020-09-29 | India | Tripura | 25734 | 277 | 19692 | 5765 | 23.746783 | 91.743565 | 2020-09-30 04:23:33 | Tripura, India | ||
2020-09-30 | India | Tripura | 26066 | 283 | 20092 | 5691 | 23.746783 | 91.743565 | 2020-10-01 04:23:42 | Tripura, India | ||
2020-10-01 | India | Tripura | 26362 | 286 | 20596 | 5480 | 23.746783 | 91.743565 | 2020-10-02 04:23:51 | Tripura, India | ||
2020-10-02 | India | Tripura | 26552 | 289 | 20897 | 5366 | 23.746783 | 91.743565 | 2020-10-03 04:23:40 | Tripura, India | ||
2020-10-03 | India | Tripura | 26874 | 293 | 21410 | 5171 | 23.746783 | 91.743565 | 2020-10-04 04:23:44 | Tripura, India | ||
2020-10-04 | India | Tripura | 27033 | 299 | 21876 | 4858 | 23.746783 | 91.743565 | 2020-10-05 04:23:33 | Tripura, India | ||
2020-10-06 | India | Tripura | 27545 | 301 | 22623 | 4621 | 23.746783 | 91.743565 | 2020-10-07 04:23:40 | Tripura, India | ||
2020-10-05 | India | Tripura | 27308 | 301 | 22131 | 4876 | 23.746783 | 91.743565 | 2020-10-06 04:23:33 | Tripura, India | ||
2020-10-07 | India | Tripura | 27759 | 304 | 23066 | 4389 | 23.746783 | 91.743565 | 2020-10-08 04:23:56 | Tripura, India | ||
2020-10-08 | India | Tripura | 27982 | 311 | 23474 | 4197 | 23.746783 | 91.743565 | 2020-10-09 04:23:59 | Tripura, India | ||
2020-10-09 | India | Tripura | 28153 | 313 | 23801 | 4039 | 23.746783 | 91.743565 | 2020-10-10 04:23:57 | Tripura, India | ||
2020-10-10 | India | Tripura | 28352 | 315 | 24086 | 3951 | 23.746783 | 91.743565 | 2020-10-11 04:23:46 | Tripura, India | ||
2020-10-11 | India | Tripura | 28461 | 316 | 24403 | 3742 | 23.746783 | 91.743565 | 2020-10-12 04:23:45 | Tripura, India | ||
2020-10-12 | India | Tripura | 28678 | 317 | 24623 | 3738 | 23.746783 | 91.743565 | 2020-10-13 04:24:02 | Tripura, India | ||
2020-10-13 | India | Tripura | 28859 | 318 | 25041 | 3500 | 23.746783 | 91.743565 | 2020-10-14 04:24:05 | Tripura, India | ||
2020-10-14 | India | Tripura | 29031 | 319 | 25394 | 3318 | 23.746783 | 91.743565 | 2020-10-15 04:24:28 | Tripura, India | ||
2020-10-15 | India | Tripura | 29193 | 323 | 25765 | 3105 | 23.746783 | 91.743565 | 2020-10-16 04:24:01 | Tripura, India | ||
2020-10-16 | India | Tripura | 29327 | 326 | 26035 | 2966 | 23.746783 | 91.743565 | 2020-10-17 04:24:12 | Tripura, India | ||
2020-10-17 | India | Tripura | 29468 | 329 | 26222 | 2917 | 23.746783 | 91.743565 | 2020-10-18 04:24:25 | Tripura, India | ||
2020-10-18 | India | Tripura | 29553 | 331 | 26550 | 2672 | 23.746783 | 91.743565 | 2020-10-19 04:24:16 | Tripura, India | ||
2020-10-19 | India | Tripura | 29688 | 331 | 26748 | 2609 | 23.746783 | 91.743565 | 2020-10-20 04:24:22 | Tripura, India | ||
2020-10-20 | India | Tripura | 29800 | 332 | 27013 | 2455 | 23.746783 | 91.743565 | 2020-10-21 04:24:14 | Tripura, India | ||
2020-10-21 | India | Tripura | 29925 | 334 | 27252 | 2339 | 23.746783 | 91.743565 | 2020-10-22 04:24:27 | Tripura, India | ||
2020-10-22 | India | Tripura | 30070 | 339 | 27502 | 2229 | 23.746783 | 91.743565 | 2020-10-23 04:24:46 | Tripura, India | ||
2020-10-23 | India | Tripura | 30135 | 340 | 27740 | 2055 | 23.746783 | 91.743565 | 2020-10-24 04:24:46 | Tripura, India | ||
2020-10-25 | India | Tripura | 30257 | 343 | 28069 | 1845 | 23.746783 | 91.743565 | 2020-10-26 04:25:02 | Tripura, India | ||
2020-10-24 | India | Tripura | 30221 | 343 | 27886 | 1992 | 23.746783 | 91.743565 | 2020-10-25 04:24:36 | Tripura, India | ||
2020-10-27 | India | Tripura | 30453 | 344 | 28355 | 1754 | 23.746783 | 91.743565 | 2020-10-28 04:24:39 | Tripura, India | ||
2020-10-26 | India | Tripura | 30293 | 344 | 28153 | 1796 | 23.746783 | 91.743565 | 2020-10-27 04:24:45 | Tripura, India | ||
2020-10-28 | India | Tripura | 30566 | 345 | 28525 | 1696 | 23.746783 | 91.743565 | 2020-10-29 04:24:49 | Tripura, India | ||
2020-10-29 | India | Tripura | 30663 | 346 | 28737 | 1580 | 23.746783 | 91.743565 | 2020-10-30 04:24:49 | Tripura, India | ||
2020-10-31 | India | Tripura | 30794 | 346 | 29048 | 1400 | 23.746783 | 91.743565 | 2020-11-01 04:36:19 | Tripura, India | ||
2020-10-30 | India | Tripura | 30717 | 346 | 28878 | 1493 | 23.746783 | 91.743565 | 2020-10-31 04:24:44 | Tripura, India | ||
2020-11-01 | India | Tripura | 30852 | 348 | 29234 | 1270 | 23.746783 | 91.743565 | 2020-11-02 05:25:04 | Tripura, India | ||
2020-11-02 | India | Tripura | 30989 | 350 | 29318 | 1321 | 23.746783 | 91.743565 | 2020-11-03 06:00:16 | Tripura, India | ||
2020-11-03 | India | Tripura | 31105 | 353 | 29430 | 1322 | 23.746783 | 91.743565 | 2020-11-04 05:25:09 | Tripura, India | ||
2020-11-04 | India | Tripura | 31237 | 353 | 29545 | 1339 | 23.746783 | 91.743565 | 2020-11-05 06:05:03 | Tripura, India | ||
2020-11-05 | India | Tripura | 31347 | 354 | 29666 | 1327 | 23.746783 | 91.743565 | 2020-11-06 05:24:55 | Tripura, India | ||
2020-11-06 | India | Tripura | 31434 | 356 | 29792 | 1286 | 23.746783 | 91.743565 | 2020-11-07 05:24:52 | Tripura, India | ||
2020-11-07 | India | Tripura | 31517 | 357 | 29858 | 1302 | 23.746783 | 91.743565 | 2020-11-08 05:24:56 | Tripura, India | ||
2020-11-10 | India | Tripura | 31706 | 359 | 30058 | 1289 | 23.746783 | 91.743565 | 2020-11-11 05:25:30 | Tripura, India | ||
2020-11-08 | India | Tripura | 31543 | 359 | 29965 | 1219 | 23.746783 | 91.743565 | 2020-11-09 05:25:45 | Tripura, India | ||
2020-11-09 | India | Tripura | 31622 | 359 | 30009 | 1254 | 23.746783 | 91.743565 | 2020-11-10 05:40:07 | Tripura, India | ||
2020-11-11 | India | Tripura | 31765 | 359 | 30208 | 1198 | 23.746783 | 91.743565 | 2020-11-12 05:25:55 | Tripura, India | ||
2020-11-12 | India | Tripura | 31841 | 360 | 30314 | 1167 | 23.746783 | 91.743565 | 2020-11-13 05:25:30 | Tripura, India | ||
2020-11-13 | India | Tripura | 31919 | 362 | 30414 | 1143 | 23.746783 | 91.743565 | 2020-11-14 05:25:37 | Tripura, India | ||
2020-11-14 | India | Tripura | 31945 | 362 | 30478 | 1105 | 23.746783 | 91.743565 | 2020-11-15 05:26:53 | Tripura, India | ||
2020-11-18 | India | Tripura | 32217 | 364 | 30856 | 997 | 23.746783 | 91.743565 | 2020-11-19 05:25:23 | Tripura, India | ||
2020-11-15 | India | Tripura | 31962 | 364 | 30555 | 1043 | 23.746783 | 91.743565 | 2020-11-16 05:25:57 | Tripura, India | ||
2020-11-16 | India | Tripura | 32039 | 364 | 30631 | 1044 | 23.746783 | 91.743565 | 2020-11-17 05:25:54 | Tripura, India | ||
2020-11-17 | India | Tripura | 32112 | 364 | 30750 | 998 | 23.746783 | 91.743565 | 2020-11-18 05:40:31 | Tripura, India | ||
2020-11-19 | India | Tripura | 32292 | 365 | 30968 | 959 | 23.746783 | 91.743565 | 2020-11-20 05:26:28 | Tripura, India | ||
2020-11-20 | India | Tripura | 32367 | 366 | 31084 | 917 | 23.746783 | 91.743565 | 2020-11-21 05:25:51 | Tripura, India | ||
2020-11-21 | India | Tripura | 32415 | 366 | 31179 | 870 | 23.746783 | 91.743565 | 2020-11-22 05:25:45 | Tripura, India | ||
2020-11-22 | India | Tripura | 32434 | 369 | 31269 | 796 | 23.746783 | 91.743565 | 2020-11-23 05:25:26 | Tripura, India | ||
2020-11-27 | India | Tripura | 32641 | 370 | 31568 | 703 | 23.746783 | 91.743565 | 2020-11-28 05:25:50 | Tripura, India | ||
2020-11-23 | India | Tripura | 32493 | 370 | 31296 | 827 | 23.746783 | 91.743565 | 2020-11-24 05:27:31 | Tripura, India | ||
2020-11-26 | India | Tripura | 32610 | 370 | 31499 | 741 | 23.746783 | 91.743565 | 2020-11-27 05:26:53 | Tripura, India | ||
2020-11-24 | India | Tripura | 32528 | 370 | 31368 | 790 | 23.746783 | 91.743565 | 2020-11-25 05:27:20 | Tripura, India | ||
2020-11-30 | India | Tripura | 32726 | 370 | 31764 | 592 | 23.746783 | 91.743565 | 2020-12-01 05:26:18 | Tripura, India | ||
2020-11-25 | India | Tripura | 32578 | 370 | 31441 | 767 | 23.746783 | 91.743565 | 2020-11-26 05:27:44 | Tripura, India | ||
2020-11-28 | India | Tripura | 32674 | 370 | 31655 | 649 | 23.746783 | 91.743565 | 2020-11-29 05:25:55 | Tripura, India | ||
2020-11-29 | India | Tripura | 32695 | 370 | 31730 | 595 | 23.746783 | 91.743565 | 2020-11-30 05:26:13 | Tripura, India | ||
2020-12-03 | India | Tripura | 32836 | 372 | 31947 | 517 | 23.746783 | 91.743565 | 2020-12-04 05:27:27 | Tripura, India | ||
2020-12-02 | India | Tripura | 32803 | 372 | 31879 | 552 | 23.746783 | 91.743565 | 2020-12-03 05:28:22 | Tripura, India | ||
2020-12-05 | India | Tripura | 32891 | 372 | 32068 | 451 | 23.746783 | 91.743565 | 2020-12-06 05:26:18 | Tripura, India | ||
2020-12-01 | India | Tripura | 32764 | 372 | 31821 | 571 | 23.746783 | 91.743565 | 2020-12-02 05:27:41 | Tripura, India | ||
2020-12-04 | India | Tripura | 32860 | 372 | 32009 | 479 | 23.746783 | 91.743565 | 2020-12-05 05:27:36 | Tripura, India | ||
2020-12-06 | India | Tripura | 32897 | 373 | 32110 | 414 | 23.746783 | 91.743565 | 2020-12-07 05:26:14 | Tripura, India | ||
2020-12-08 | India | Tripura | 32945 | 373 | 32169 | 403 | 23.746783 | 91.743565 | 2020-12-09 05:28:01 | Tripura, India | ||
2020-12-07 | India | Tripura | 32925 | 373 | 32125 | 427 | 23.746783 | 91.743565 | 2020-12-08 05:27:42 | Tripura, India | ||
2020-12-09 | India | Tripura | 32976 | 373 | 32204 | 399 | 23.746783 | 91.743565 | 2020-12-10 05:26:19 | Tripura, India | ||
2020-12-10 | India | Tripura | 32997 | 374 | 32250 | 373 | 23.746783 | 91.743565 | 2020-12-11 05:26:59 | Tripura, India | ||
2020-12-11 | India | Tripura | 33015 | 375 | 32285 | 355 | 23.746783 | 91.743565 | 2020-12-12 05:26:19 | Tripura, India | ||
2020-12-12 | India | Tripura | 33038 | 376 | 32310 | 352 | 23.746783 | 91.743565 | 2020-12-13 05:27:20 | Tripura, India | ||
2020-12-14 | India | Tripura | 33057 | 376 | 32367 | 314 | 23.746783 | 91.743565 | 2020-12-15 05:26:38 | Tripura, India | ||
2020-12-13 | India | Tripura | 33048 | 376 | 32342 | 330 | 23.746783 | 91.743565 | 2020-12-14 05:26:27 | Tripura, India | ||
2020-12-15 | India | Tripura | 33081 | 378 | 32397 | 306 | 23.746783 | 91.743565 | 2020-12-16 05:28:04 | Tripura, India | ||
2020-12-18 | India | Tripura | 33144 | 378 | 32501 | 265 | 23.746783 | 91.743565 | 2020-12-19 05:27:52 | Tripura, India | ||
2020-12-17 | India | Tripura | 33119 | 378 | 32471 | 270 | 23.746783 | 91.743565 | 2020-12-18 05:28:18 | Tripura, India | ||
2020-12-19 | India | Tripura | 33167 | 378 | 32532 | 257 | 23.746783 | 91.743565 | 2020-12-20 05:27:32 | Tripura, India | ||
2020-12-16 | India | Tripura | 33098 | 378 | 32429 | 291 | 23.746783 | 91.743565 | 2020-12-17 05:28:12 | Tripura, India | ||
2020-12-21 | India | Tripura | 33188 | 380 | 32595 | 213 | 23.746783 | 91.743565 | 2020-12-22 05:22:33 | Tripura, India | ||
2020-12-20 | India | Tripura | 33175 | 380 | 32561 | 234 | 23.746783 | 91.743565 | 2020-12-21 05:27:58 | Tripura, India | ||
2020-12-22 | India | Tripura | 33203 | 383 | 32613 | 207 | 23.746783 | 91.743565 | 2020-12-23 05:22:03 | Tripura, India | ||
2020-12-23 | India | Tripura | 33216 | 384 | 32640 | 192 | 23.746783 | 91.743565 | 2020-12-24 05:23:04 | Tripura, India | ||
2020-12-24 | India | Tripura | 33225 | 384 | 32657 | 184 | 23.746783 | 91.743565 | 2020-12-25 05:22:48 | Tripura, India | ||
2020-12-25 | India | Tripura | 33226 | 385 | 32672 | 169 | 23.746783 | 91.743565 | 2020-12-26 05:22:28 | Tripura, India | ||
2020-12-29 | India | Tripura | 33258 | 385 | 32735 | 138 | 23.746783 | 91.743565 | 2020-12-30 05:22:34 | Tripura, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;