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 = "Assam" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491525 | 1491525 | 2021-10-12 | India | Assam | 605465 | 5934 | 0 | 26.357149 | 92.83044100000001 | 2021-10-13 04:20:51 | Assam, India | |||
3007258 | 3007258 | 2021-10-11 | India | Assam | 605239 | 5931 | 0 | 26.357149 | 92.83044100000001 | 2021-10-12 04:21:09 | Assam, India | |||
423274 | 423274 | 2021-10-10 | India | Assam | 604969 | 5926 | 0 | 26.357149 | 92.83044100000001 | 2021-10-11 04:21:31 | Assam, India | |||
2876131 | 2876131 | 2021-10-09 | India | Assam | 604809 | 5921 | 0 | 26.357149 | 92.83044100000001 | 2021-10-10 04:21:38 | Assam, India | |||
2959297 | 2959297 | 2021-10-08 | India | Assam | 604536 | 5916 | 0 | 26.357149 | 92.83044100000001 | 2021-10-09 04:21:34 | Assam, India | |||
467335 | 467335 | 2021-10-07 | India | Assam | 604218 | 5911 | 0 | 26.357149 | 92.83044100000001 | 2021-10-08 04:21:25 | Assam, India | |||
2458715 | 2458715 | 2021-10-06 | India | Assam | 603923 | 5903 | 0 | 26.357149 | 92.83044100000001 | 2021-10-07 04:21:36 | Assam, India | |||
3832409 | 3832409 | 2021-10-05 | India | Assam | 603623 | 5897 | 0 | 26.357149 | 92.83044100000001 | 2021-10-06 04:21:33 | Assam, India | |||
986902 | 986902 | 2021-10-04 | India | Assam | 603238 | 5890 | 0 | 26.357149 | 92.83044100000001 | 2021-10-05 04:21:27 | Assam, India | |||
1274212 | 1274212 | 2021-10-03 | India | Assam | 602905 | 5881 | 0 | 26.357149 | 92.83044100000001 | 2021-10-04 04:21:31 | Assam, India | |||
3927965 | 3927965 | 2021-10-02 | India | Assam | 602712 | 5880 | 0 | 26.357149 | 92.83044100000001 | 2021-10-03 04:21:24 | Assam, India | |||
2131945 | 2131945 | 2021-10-01 | India | Assam | 602466 | 5876 | 0 | 26.357149 | 92.83044100000001 | 2021-10-02 04:21:25 | Assam, India | |||
2772902 | 2772902 | 2021-09-30 | India | Assam | 602163 | 5873 | 0 | 26.357149 | 92.83044100000001 | 2021-10-01 04:21:35 | Assam, India | |||
706358 | 706358 | 2021-09-29 | India | Assam | 601787 | 5868 | 0 | 26.357149 | 92.83044100000001 | 2021-09-30 04:21:20 | Assam, India | |||
1334200 | 1334200 | 2021-09-28 | India | Assam | 601421 | 5861 | 0 | 26.357149 | 92.83044100000001 | 2021-09-29 04:21:45 | Assam, India | |||
1235569 | 1235569 | 2021-09-27 | India | Assam | 601031 | 5851 | 0 | 26.357149 | 92.83044100000001 | 2021-09-28 04:21:28 | Assam, India | |||
2075870 | 2075870 | 2021-09-26 | India | Assam | 600619 | 5843 | 0 | 26.357149 | 92.83044100000001 | 2021-09-27 04:21:16 | Assam, India | |||
1724422 | 1724422 | 2021-09-25 | India | Assam | 600423 | 5838 | 0 | 26.357149 | 92.83044100000001 | 2021-09-26 04:21:29 | Assam, India | |||
1921142 | 1921142 | 2021-09-24 | India | Assam | 600048 | 5834 | 0 | 26.357149 | 92.83044100000001 | 2021-09-25 04:21:31 | Assam, India | |||
601613 | 601613 | 2021-09-23 | India | Assam | 599642 | 5827 | 0 | 26.357149 | 92.83044100000001 | 2021-09-24 04:21:44 | Assam, India | |||
3011274 | 3011274 | 2021-09-22 | India | Assam | 599271 | 5817 | 0 | 26.357149 | 92.83044100000001 | 2021-09-23 04:21:43 | Assam, India | |||
3757412 | 3757412 | 2021-09-21 | India | Assam | 598864 | 5813 | 0 | 26.357149 | 92.83044100000001 | 2021-09-22 04:21:45 | Assam, India | |||
809515 | 809515 | 2021-09-20 | India | Assam | 598423 | 5807 | 0 | 26.357149 | 92.83044100000001 | 2021-09-21 04:21:26 | Assam, India | |||
1814714 | 1814714 | 2021-09-19 | India | Assam | 597968 | 5797 | 0 | 26.357149 | 92.83044100000001 | 2021-09-20 04:21:22 | Assam, India | |||
16294 | 16294 | 2021-09-18 | India | Assam | 597709 | 5790 | 0 | 26.357149 | 92.83044100000001 | 2021-09-19 04:21:34 | Assam, India | |||
2617979 | 2617979 | 2021-09-17 | India | Assam | 597344 | 5788 | 0 | 26.357149 | 92.83044100000001 | 2021-09-18 04:21:24 | Assam, India | |||
2808687 | 2808687 | 2021-09-16 | India | Assam | 597074 | 5779 | 0 | 26.357149 | 92.83044100000001 | 2021-09-17 04:21:46 | Assam, India | |||
1374432 | 1374432 | 2021-09-15 | India | Assam | 596606 | 5775 | 0 | 26.357149 | 92.83044100000001 | 2021-09-16 04:22:19 | Assam, India | |||
2462731 | 2462731 | 2021-09-14 | India | Assam | 596162 | 5767 | 0 | 26.357149 | 92.83044100000001 | 2021-09-15 03:22:37 | Assam, India | |||
1385570 | 1385570 | 2021-09-13 | India | Assam | 595669 | 5758 | 0 | 26.357149 | 92.83044100000001 | 2021-09-14 04:21:41 | Assam, India | |||
1884939 | 1884939 | 2021-09-12 | India | Assam | 595105 | 5751 | 0 | 26.357149 | 92.83044100000001 | 2021-09-13 04:21:15 | Assam, India | |||
3805842 | 3805842 | 2021-09-11 | India | Assam | 594846 | 5740 | 0 | 26.357149 | 92.83044100000001 | 2021-09-12 04:21:13 | Assam, India | |||
3448782 | 3448782 | 2021-09-10 | India | Assam | 594347 | 5732 | 0 | 26.357149 | 92.83044100000001 | 2021-09-11 04:21:30 | Assam, India | |||
1262728 | 1262728 | 2021-09-09 | India | Assam | 593951 | 5727 | 0 | 26.357149 | 92.83044100000001 | 2021-09-10 04:21:20 | Assam, India | |||
2279098 | 2279098 | 2021-09-08 | India | Assam | 593514 | 5723 | 0 | 26.357149 | 92.83044100000001 | 2021-09-09 04:21:27 | Assam, India | |||
641877 | 641877 | 2021-09-07 | India | Assam | 593087 | 5719 | 0 | 26.357149 | 92.83044100000001 | 2021-09-08 04:21:31 | Assam, India | |||
3193940 | 3193940 | 2021-09-06 | India | Assam | 592616 | 5710 | 0 | 26.357149 | 92.83044100000001 | 2021-09-07 04:21:35 | Assam, India | |||
3280808 | 3280808 | 2021-09-05 | India | Assam | 591980 | 5699 | 0 | 26.357149 | 92.83044100000001 | 2021-09-06 04:21:22 | Assam, India | |||
249222 | 249222 | 2021-09-04 | India | Assam | 591659 | 5693 | 0 | 26.357149 | 92.83044100000001 | 2021-09-05 04:21:33 | Assam, India | |||
3974503 | 3974503 | 2021-09-03 | India | Assam | 591117 | 5683 | 0 | 26.357149 | 92.83044100000001 | 2021-09-04 04:21:28 | Assam, India | |||
177965 | 177965 | 2021-09-02 | India | Assam | 590553 | 5677 | 0 | 26.357149 | 92.83044100000001 | 2021-09-03 04:21:20 | Assam, India | |||
67000 | 67000 | 2021-09-01 | India | Assam | 589999 | 5671 | 0 | 26.357149 | 92.83044100000001 | 2021-09-02 04:21:15 | Assam, India | |||
2067842 | 2067842 | 2021-08-31 | India | Assam | 589426 | 5660 | 0 | 26.357149 | 92.83044100000001 | 2021-09-01 04:21:38 | Assam, India | |||
1775296 | 1775296 | 2021-08-30 | India | Assam | 588856 | 5655 | 0 | 26.357149 | 92.83044100000001 | 2021-08-31 04:21:46 | Assam, India | |||
3891870 | 3891870 | 2021-08-29 | India | Assam | 588318 | 5640 | 0 | 26.357149 | 92.83044100000001 | 2021-08-30 04:21:23 | Assam, India | |||
2792973 | 2792973 | 2021-08-28 | India | Assam | 588025 | 5636 | 0 | 26.357149 | 92.83044100000001 | 2021-08-29 04:21:14 | Assam, India | |||
2923132 | 2923132 | 2021-08-27 | India | Assam | 587439 | 5627 | 0 | 26.357149 | 92.83044100000001 | 2021-08-28 04:21:28 | Assam, India | |||
1596146 | 1596146 | 2021-08-26 | India | Assam | 586940 | 5618 | 0 | 26.357149 | 92.83044100000001 | 2021-08-27 04:21:37 | Assam, India | |||
32355 | 32355 | 2021-08-25 | India | Assam | 586378 | 5607 | 0 | 26.357149 | 92.83044100000001 | 2021-08-26 04:21:28 | Assam, India | |||
3105394 | 3105394 | 2021-08-24 | India | Assam | 585689 | 5600 | 0 | 26.357149 | 92.83044100000001 | 2021-08-25 04:21:41 | Assam, India | |||
3165565 | 3165565 | 2021-08-23 | India | Assam | 585134 | 5587 | 0 | 26.357149 | 92.83044100000001 | 2021-08-24 04:21:19 | Assam, India | |||
2175492 | 2175492 | 2021-08-22 | India | Assam | 584434 | 5576 | 0 | 26.357149 | 92.83044100000001 | 2021-08-23 04:21:27 | Assam, India | |||
3555588 | 3555588 | 2021-08-21 | India | Assam | 584098 | 5566 | 0 | 26.357149 | 92.83044100000001 | 2021-08-22 04:21:29 | Assam, India | |||
1853930 | 1853930 | 2021-08-20 | India | Assam | 583458 | 5551 | 0 | 26.357149 | 92.83044100000001 | 2021-08-21 04:21:38 | Assam, India | |||
511637 | 511637 | 2021-08-19 | India | Assam | 582750 | 5538 | 0 | 26.357149 | 92.83044100000001 | 2021-08-20 04:21:33 | Assam, India | |||
2518116 | 2518116 | 2021-08-18 | India | Assam | 582037 | 5528 | 0 | 26.357149 | 92.83044100000001 | 2021-08-19 04:21:15 | Assam, India | |||
245208 | 245208 | 2021-08-17 | India | Assam | 581398 | 5513 | 0 | 26.357149 | 92.83044100000001 | 2021-08-18 04:21:35 | Assam, India | |||
1604171 | 1604171 | 2021-08-16 | India | Assam | 580657 | 5502 | 0 | 26.357149 | 92.83044100000001 | 2021-08-17 04:21:49 | Assam, India | |||
103265 | 103265 | 2021-08-15 | India | Assam | 579899 | 5492 | 0 | 26.357149 | 92.83044100000001 | 2021-08-16 04:21:31 | Assam, India | |||
507623 | 507623 | 2021-08-14 | India | Assam | 579488 | 5482 | 0 | 26.357149 | 92.83044100000001 | 2021-08-15 04:21:41 | Assam, India | |||
1483495 | 1483495 | 2021-08-13 | India | Assam | 578733 | 5471 | 0 | 26.357149 | 92.83044100000001 | 2021-08-14 04:21:25 | Assam, India | |||
2899625 | 2899625 | 2021-08-12 | India | Assam | 577970 | 5451 | 0 | 26.357149 | 92.83044100000001 | 2021-08-13 04:21:24 | Assam, India | |||
1342229 | 1342229 | 2021-08-11 | India | Assam | 577035 | 5434 | 0 | 26.357149 | 92.83044100000001 | 2021-08-12 04:21:25 | Assam, India | |||
2351376 | 2351376 | 2021-08-10 | India | Assam | 576149 | 5420 | 0 | 26.357149 | 92.83044100000001 | 2021-08-11 04:21:58 | Assam, India | |||
649905 | 649905 | 2021-08-09 | India | Assam | 575220 | 5404 | 0 | 26.357149 | 92.83044100000001 | 2021-08-10 04:21:27 | Assam, India | |||
589567 | 589567 | 2021-08-08 | India | Assam | 574100 | 5387 | 0 | 26.357149 | 92.830441 | 2021-08-09 04:21:24 | Assam, India | |||
2203579 | 2203579 | 2021-08-07 | India | Assam | 573532 | 5372 | 0 | 26.357149 | 92.830441 | 2021-08-08 04:21:33 | Assam, India | |||
1117529 | 1117529 | 2021-08-06 | India | Assam | 572546 | 5357 | 0 | 26.357149 | 92.830441 | 2021-08-07 04:21:30 | Assam, India | |||
1956466 | 1956466 | 2021-08-05 | India | Assam | 571571 | 5343 | 0 | 26.357149 | 92.830441 | 2021-08-06 04:21:18 | Assam, India | |||
331845 | 331845 | 2021-08-04 | India | Assam | 570504 | 5326 | 552955 | 12223 | 26.357149 | 92.830441 | 2021-08-05 04:21:51 | Assam, India | ||
3468116 | 3468116 | 2021-08-03 | India | Assam | 569439 | 5307 | 551692 | 12440 | 26.357149 | 92.830441 | 2021-08-04 04:21:25 | Assam, India | ||
3683390 | 3683390 | 2021-08-02 | India | Assam | 568257 | 5294 | 550534 | 12429 | 26.357149 | 92.830441 | 2021-08-03 04:21:39 | Assam, India | ||
3015289 | 3015289 | 2021-08-01 | India | Assam | 566982 | 5275 | 549065 | 12642 | 26.357149 | 92.830441 | 2021-08-02 04:21:36 | Assam, India | ||
3903912 | 3903912 | 2021-07-31 | India | Assam | 566198 | 5260 | 547616 | 13322 | 26.357149 | 92.830441 | 2021-08-01 04:21:50 | Assam, India | ||
3296117 | 3296117 | 2021-07-30 | India | Assam | 565209 | 5241 | 546136 | 13832 | 26.357149 | 92.830441 | 2021-07-31 04:21:35 | Assam, India | ||
3385328 | 3385328 | 2021-07-29 | India | Assam | 564030 | 5221 | 544695 | 14114 | 26.357149 | 92.830441 | 2021-07-30 04:21:34 | Assam, India | ||
408233 | 408233 | 2021-07-28 | India | Assam | 562731 | 5201 | 543031 | 14499 | 26.357149 | 92.830441 | 2021-07-29 04:21:33 | Assam, India | ||
1306094 | 1306094 | 2021-07-27 | India | Assam | 561455 | 5180 | 541240 | 15035 | 26.357149 | 92.830441 | 2021-07-28 04:21:39 | Assam, India | ||
3218237 | 3218237 | 2021-07-26 | India | Assam | 560019 | 5162 | 539928 | 14929 | 26.357149 | 92.830441 | 2021-07-27 04:21:18 | Assam, India | ||
1378446 | 1378446 | 2021-07-25 | India | Assam | 558491 | 5136 | 538098 | 15257 | 26.357149 | 92.830441 | 2021-07-26 04:21:28 | Assam, India | ||
1330186 | 1330186 | 2021-07-24 | India | Assam | 557437 | 5114 | 536597 | 15726 | 26.357149 | 92.830441 | 2021-07-25 04:22:12 | Assam, India | ||
3137490 | 3137490 | 2021-07-23 | India | Assam | 555842 | 5091 | 532940 | 17811 | 26.357149 | 92.830441 | 2021-07-24 00:21:36 | Assam, India | ||
3476250 | 3476250 | 2021-07-22 | India | Assam | 554221 | 5076 | 532940 | 16205 | 26.357149 | 92.830441 | 2021-07-23 04:21:29 | Assam, India | ||
3331469 | 3331469 | 2021-07-21 | India | Assam | 552425 | 5054 | 530678 | 16693 | 26.357149 | 92.830441 | 2021-07-22 04:21:19 | Assam, India | ||
2371450 | 2371450 | 2021-07-20 | India | Assam | 550878 | 5029 | 528252 | 17597 | 26.357149 | 92.830441 | 2021-07-21 04:21:40 | Assam, India | ||
483529 | 483529 | 2021-07-19 | India | Assam | 549080 | 5019 | 526607 | 17454 | 26.357149 | 92.830441 | 2021-07-20 04:21:48 | Assam, India | ||
2673752 | 2673752 | 2021-07-18 | India | Assam | 547283 | 4999 | 524469 | 17815 | 26.357149 | 92.830441 | 2021-07-19 04:21:24 | Assam, India | ||
3706064 | 3706064 | 2021-07-17 | India | Assam | 545954 | 4984 | 522192 | 18778 | 26.357149 | 92.830441 | 2021-07-18 04:22:07 | Assam, India | ||
2947295 | 2947295 | 2021-07-16 | India | Assam | 544227 | 4961 | 519697 | 19569 | 26.357149 | 92.830441 | 2021-07-17 04:22:22 | Assam, India | ||
295951 | 295951 | 2021-07-15 | India | Assam | 542445 | 4937 | 517041 | 20467 | 26.357149 | 92.830441 | 2021-07-16 04:21:22 | Assam, India | ||
3631896 | 3631896 | 2021-07-14 | India | Assam | 540453 | 4910 | 514543 | 21000 | 26.357149 | 92.830441 | 2021-07-15 04:21:48 | Assam, India | ||
578771 | 578771 | 2021-07-13 | India | Assam | 538407 | 4888 | 511888 | 21631 | 26.357149 | 92.830441 | 2021-07-14 04:21:35 | Assam, India | ||
3741020 | 3741020 | 2021-07-12 | India | Assam | 536238 | 4865 | 510432 | 20941 | 26.357149 | 92.830441 | 2021-07-13 04:21:18 | Assam, India | ||
3659533 | 3659533 | 2021-07-11 | India | Assam | 533663 | 4828 | 507516 | 21319 | 26.357149 | 92.830441 | 2021-07-12 04:21:34 | Assam, India | ||
625817 | 625817 | 2021-07-10 | India | Assam | 532084 | 4812 | 504723 | 22549 | 26.357149 | 92.830441 | 2021-07-11 04:21:43 | Assam, India | ||
829536 | 829536 | 2021-07-09 | India | Assam | 529693 | 4788 | 501869 | 23036 | 26.357149 | 92.830441 | 2021-07-10 04:21:25 | Assam, India | ||
778300 | 778300 | 2021-07-08 | India | Assam | 527200 | 4764 | 499388 | 23048 | 26.357149 | 92.830441 | 2021-07-09 04:21:21 | Assam, India | ||
1440522 | 1440522 | 2021-07-07 | India | Assam | 524556 | 4743 | 496442 | 23371 | 26.357149 | 92.830441 | 2021-07-08 04:21:26 | Assam, India | ||
2693627 | 2693627 | 2021-07-06 | India | Assam | 522267 | 4717 | 493306 | 24244 | 26.357149 | 92.830441 | 2021-07-07 04:21:20 | Assam, India | ||
1932376 | 1932376 | 2021-07-05 | India | Assam | 519834 | 4683 | 491561 | 23590 | 26.357149 | 92.830441 | 2021-07-06 04:21:32 | Assam, 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]);