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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687404 | 3687404 | 2022-01-13 | India | Assam | 635050 | 6189 | 0 | 26.357149 | 92.83044100000001 | 2022-01-14 04:21:54 | Assam, India | |||
3612988 | 3612988 | 2022-01-12 | India | Assam | 635050 | 6189 | 0 | 26.357149 | 92.83044100000001 | 2022-01-13 08:00:09 | Assam, India | |||
1113513 | 1113513 | 2022-01-11 | India | Assam | 628939 | 6183 | 0 | 26.357149 | 92.83044100000001 | 2022-01-12 04:21:44 | Assam, India | |||
1692241 | 1692241 | 2022-01-10 | India | Assam | 628939 | 6183 | 0 | 26.357149 | 92.83044100000001 | 2022-01-11 04:22:01 | Assam, India | |||
126656 | 126656 | 2022-01-09 | India | Assam | 626741 | 6181 | 0 | 26.357149 | 92.83044100000001 | 2022-01-10 04:22:07 | Assam, India | |||
1215491 | 1215491 | 2022-01-08 | India | Assam | 625753 | 6180 | 0 | 26.357149 | 92.83044100000001 | 2022-01-09 04:21:46 | Assam, India | |||
1389584 | 1389584 | 2022-01-07 | India | Assam | 624499 | 6178 | 0 | 26.357149 | 92.83044100000001 | 2022-01-08 04:21:53 | Assam, India | |||
2609971 | 2609971 | 2022-01-06 | India | Assam | 623332 | 6176 | 0 | 26.357149 | 92.83044100000001 | 2022-01-07 04:22:09 | Assam, India | |||
1281913 | 1281913 | 2022-01-05 | India | Assam | 622488 | 6174 | 0 | 26.357149 | 92.83044100000001 | 2022-01-06 04:22:09 | Assam, India | |||
1285929 | 1285929 | 2022-01-04 | India | Assam | 621897 | 6170 | 0 | 26.357149 | 92.83044100000001 | 2022-01-05 04:21:59 | Assam, India | |||
1700273 | 1700273 | 2022-01-03 | India | Assam | 621422 | 6167 | 0 | 26.357149 | 92.83044100000001 | 2022-01-04 04:22:17 | Assam, India | |||
3519356 | 3519356 | 2022-01-02 | India | Assam | 621071 | 6165 | 0 | 26.357149 | 92.83044100000001 | 2022-01-03 02:22:25 | Assam, India | |||
2167486 | 2167486 | 2022-01-01 | India | Assam | 620915 | 6165 | 0 | 26.357149 | 92.83044100000001 | 2022-01-02 04:20:52 | Assam, India | |||
2776917 | 2776917 | 2021-12-31 | India | Assam | 620765 | 6164 | 0 | 26.357149 | 92.83044100000001 | 2022-01-01 04:22:14 | Assam, India | |||
3998574 | 3998574 | 2021-12-30 | India | Assam | 620573 | 6164 | 0 | 26.357149 | 92.83044100000001 | 2021-12-31 04:21:50 | Assam, India | |||
1668381 | 1668381 | 2021-12-29 | India | Assam | 620472 | 6162 | 0 | 26.357149 | 92.83044100000001 | 2021-12-30 04:21:25 | Assam, India | |||
1432490 | 1432490 | 2021-12-28 | India | Assam | 620357 | 6160 | 0 | 26.357149 | 92.83044100000001 | 2021-12-29 03:21:43 | Assam, India | |||
730451 | 730451 | 2021-12-27 | India | Assam | 620237 | 6158 | 0 | 26.357149 | 92.83044100000001 | 2021-12-28 04:21:47 | Assam, India | |||
2111623 | 2111623 | 2021-12-26 | India | Assam | 620134 | 6156 | 0 | 26.357149 | 92.83044100000001 | 2021-12-27 04:21:58 | Assam, India | |||
3604995 | 3604995 | 2021-12-25 | India | Assam | 620081 | 6155 | 0 | 26.357149 | 92.83044100000001 | 2021-12-26 04:21:50 | Assam, India | |||
2963313 | 2963313 | 2021-12-24 | India | Assam | 620025 | 6155 | 0 | 26.357149 | 92.83044100000001 | 2021-12-25 04:21:37 | Assam, India | |||
3816345 | 3816345 | 2021-12-23 | India | Assam | 619932 | 6153 | 0 | 26.357149 | 92.83044100000001 | 2021-12-24 04:21:34 | Assam, India | |||
798353 | 798353 | 2021-12-22 | India | Assam | 619819 | 6152 | 0 | 26.357149 | 92.83044100000001 | 2021-12-23 04:21:21 | Assam, India | |||
3828393 | 3828393 | 2021-12-21 | India | Assam | 619700 | 6150 | 0 | 26.357149 | 92.83044100000001 | 2021-12-22 04:21:54 | Assam, India | |||
1254696 | 1254696 | 2021-12-20 | India | Assam | 619586 | 6149 | 0 | 26.357149 | 92.83044100000001 | 2021-12-21 03:21:27 | Assam, India | |||
2903639 | 2903639 | 2021-12-19 | India | Assam | 619492 | 6147 | 0 | 26.357149 | 92.83044100000001 | 2021-12-20 04:21:43 | Assam, India | |||
1258712 | 1258712 | 2021-12-18 | India | Assam | 619298 | 6141 | 0 | 26.357149 | 92.83044100000001 | 2021-12-19 04:21:11 | Assam, India | |||
2398740 | 2398740 | 2021-12-17 | India | Assam | 619168 | 6141 | 0 | 26.357149 | 92.83044100000001 | 2021-12-18 02:22:20 | Assam, India | |||
1716278 | 1716278 | 2021-12-16 | India | Assam | 619168 | 6141 | 0 | 26.357149 | 92.83044100000001 | 2021-12-17 04:22:14 | Assam, India | |||
3496112 | 3496112 | 2021-12-15 | India | Assam | 618988 | 6137 | 0 | 26.357149 | 92.83044100000001 | 2021-12-16 04:22:11 | Assam, India | |||
2087897 | 2087897 | 2021-12-14 | India | Assam | 618857 | 6135 | 0 | 26.357149 | 92.83044100000001 | 2021-12-15 03:22:16 | Assam, India | |||
782314 | 782314 | 2021-12-13 | India | Assam | 618716 | 6133 | 0 | 26.357149 | 92.83044100000001 | 2021-12-14 04:22:38 | Assam, India | |||
1660349 | 1660349 | 2021-12-12 | India | Assam | 618575 | 6133 | 0 | 26.357149 | 92.83044100000001 | 2021-12-13 04:22:02 | Assam, India | |||
1664365 | 1664365 | 2021-12-11 | India | Assam | 618441 | 6130 | 0 | 26.357149 | 92.83044100000001 | 2021-12-12 04:22:12 | Assam, India | |||
3655517 | 3655517 | 2021-12-10 | India | Assam | 618329 | 6130 | 0 | 26.357149 | 92.83044100000001 | 2021-12-11 04:22:45 | Assam, India | |||
1077848 | 1077848 | 2021-12-09 | India | Assam | 618188 | 6129 | 0 | 26.357149 | 92.83044100000001 | 2021-12-10 04:22:28 | Assam, India | |||
550697 | 550697 | 2021-12-08 | India | Assam | 618042 | 6127 | 0 | 26.357149 | 92.83044100000001 | 2021-12-09 04:22:49 | Assam, India | |||
404217 | 404217 | 2021-12-07 | India | Assam | 617908 | 6127 | 0 | 26.357149 | 92.83044100000001 | 2021-12-08 04:22:46 | Assam, India | |||
1030299 | 1030299 | 2021-12-06 | India | Assam | 617758 | 6126 | 0 | 26.357149 | 92.83044100000001 | 2021-12-07 04:22:34 | Assam, India | |||
1740462 | 1740462 | 2021-12-05 | India | Assam | 617576 | 6120 | 0 | 26.357149 | 92.83044100000001 | 2021-12-06 04:22:34 | Assam, India | |||
137894 | 137894 | 2021-12-04 | India | Assam | 617306 | 6113 | 0 | 26.357149 | 92.83044100000001 | 2021-12-05 04:22:25 | Assam, India | |||
2195547 | 2195547 | 2021-12-03 | India | Assam | 617306 | 6113 | 0 | 26.357149 | 92.83044100000001 | 2021-12-04 04:22:18 | Assam, India | |||
253 | 253 | 2021-12-02 | India | Assam | 617163 | 6111 | 0 | 26.357149 | 92.83044100000001 | 2021-12-03 04:23:05 | Assam, India | |||
1144852 | 1144852 | 2021-12-01 | India | Assam | 617039 | 6108 | 0 | 26.357149 | 92.83044100000001 | 2021-12-02 04:22:37 | Assam, India | |||
3401364 | 3401364 | 2021-11-30 | India | Assam | 616852 | 6103 | 0 | 26.357149 | 92.83044100000001 | 2021-12-01 04:22:29 | Assam, India | |||
149907 | 149907 | 2021-11-29 | India | Assam | 616708 | 6098 | 0 | 26.357149 | 92.83044100000001 | 2021-11-30 04:22:53 | Assam, India | |||
1231553 | 1231553 | 2021-11-28 | India | Assam | 616568 | 6092 | 0 | 26.357149 | 92.83044100000001 | 2021-11-29 04:22:30 | Assam, India | |||
1358260 | 1358260 | 2021-11-27 | India | Assam | 616435 | 6091 | 0 | 26.357149 | 92.83044100000001 | 2021-11-28 04:22:43 | Assam, India | |||
758251 | 758251 | 2021-11-26 | India | Assam | 616312 | 6086 | 0 | 26.357149 | 92.83044100000001 | 2021-11-27 04:22:45 | Assam, India | |||
1802668 | 1802668 | 2021-11-25 | India | Assam | 616137 | 6086 | 0 | 26.357149 | 92.83044100000001 | 2021-11-26 04:22:33 | Assam, India | |||
904102 | 904102 | 2021-11-24 | India | Assam | 615995 | 6081 | 0 | 26.357149 | 92.83044100000001 | 2021-11-25 04:22:33 | Assam, India | |||
3069952 | 3069952 | 2021-11-23 | India | Assam | 615781 | 6079 | 0 | 26.357149 | 92.83044100000001 | 2021-11-24 04:22:14 | Assam, India | |||
3749050 | 3749050 | 2021-11-22 | India | Assam | 615574 | 6077 | 0 | 26.357149 | 92.83044100000001 | 2021-11-23 04:22:39 | Assam, India | |||
1014257 | 1014257 | 2021-11-21 | India | Assam | 615382 | 6072 | 0 | 26.357149 | 92.83044100000001 | 2021-11-22 04:22:20 | Assam, India | |||
722421 | 722421 | 2021-11-20 | India | Assam | 615291 | 6071 | 0 | 26.357149 | 92.83044100000001 | 2021-11-21 04:22:13 | Assam, India | |||
161951 | 161951 | 2021-11-19 | India | Assam | 615053 | 6066 | 0 | 26.357149 | 92.83044100000001 | 2021-11-20 04:22:17 | Assam, India | |||
3288838 | 3288838 | 2021-11-18 | India | Assam | 614863 | 6065 | 0 | 26.357149 | 92.83044100000001 | 2021-11-19 04:21:40 | Assam, India | |||
447294 | 447294 | 2021-11-17 | India | Assam | 614663 | 6061 | 0 | 26.357149 | 92.83044100000001 | 2021-11-18 04:21:33 | Assam, India | |||
3342544 | 3342544 | 2021-11-16 | India | Assam | 614413 | 6056 | 0 | 26.357149 | 92.83044100000001 | 2021-11-17 04:21:48 | Assam, India | |||
2287380 | 2287380 | 2021-11-15 | India | Assam | 614166 | 6052 | 0 | 26.357149 | 92.83044100000001 | 2021-11-16 04:21:10 | Assam, India | |||
1322154 | 1322154 | 2021-11-14 | India | Assam | 613913 | 6049 | 0 | 26.357149 | 92.83044100000001 | 2021-11-15 04:21:36 | Assam, India | |||
686280 | 686280 | 2021-11-13 | India | Assam | 613784 | 6047 | 0 | 26.357149 | 92.83044100000001 | 2021-11-14 04:21:31 | Assam, India | |||
714389 | 714389 | 2021-11-12 | India | Assam | 613563 | 6043 | 0 | 26.357149 | 92.83044100000001 | 2021-11-13 04:21:38 | Assam, India | |||
28339 | 28339 | 2021-11-11 | India | Assam | 613312 | 6042 | 0 | 26.357149 | 92.83044100000001 | 2021-11-12 04:22:01 | Assam, India | |||
2844778 | 2844778 | 2021-11-10 | India | Assam | 613061 | 6035 | 0 | 26.357149 | 92.83044100000001 | 2021-11-11 04:21:45 | Assam, India | |||
87048 | 87048 | 2021-11-09 | India | Assam | 612798 | 6034 | 0 | 26.357149 | 92.83044100000001 | 2021-11-10 04:21:38 | Assam, India | |||
3639476 | 3639476 | 2021-11-08 | India | Assam | 612551 | 6031 | 0 | 26.357149 | 92.83044100000001 | 2021-11-09 04:21:36 | Assam, India | |||
2000584 | 2000584 | 2021-11-07 | India | Assam | 612271 | 6028 | 0 | 26.357149 | 92.83044100000001 | 2021-11-08 04:21:43 | Assam, India | |||
495575 | 495575 | 2021-11-06 | India | Assam | 612134 | 6026 | 0 | 26.357149 | 92.83044100000001 | 2021-11-07 04:21:53 | Assam, India | |||
3121430 | 3121430 | 2021-11-05 | India | Assam | 611895 | 6024 | 0 | 26.357149 | 92.83044100000001 | 2021-11-06 04:21:51 | Assam, India | |||
698328 | 698328 | 2021-11-04 | India | Assam | 611656 | 6019 | 0 | 26.357149 | 92.83044100000001 | 2021-11-05 04:21:54 | Assam, India | |||
276106 | 276106 | 2021-11-03 | India | Assam | 611487 | 6015 | 0 | 26.357149 | 92.83044100000001 | 2021-11-04 04:22:20 | Assam, India | |||
43631 | 43631 | 2021-11-02 | India | Assam | 611211 | 6011 | 0 | 26.357149 | 92.83044100000001 | 2021-11-03 06:22:09 | Assam, India | |||
3511327 | 3511327 | 2021-11-01 | India | Assam | 610941 | 6004 | 0 | 26.357149 | 92.83044100000001 | 2021-11-02 04:22:03 | Assam, India | |||
287919 | 287919 | 2021-10-31 | India | Assam | 610645 | 5997 | 0 | 26.357149 | 92.83044100000001 | 2021-11-01 04:22:01 | Assam, India | |||
2720925 | 2720925 | 2021-10-30 | India | Assam | 610433 | 5996 | 0 | 26.357149 | 92.83044100000001 | 2021-10-31 04:22:08 | Assam, India | |||
567027 | 567027 | 2021-10-29 | India | Assam | 610150 | 5992 | 0 | 26.357149 | 92.83044100000001 | 2021-10-30 04:22:03 | Assam, India | |||
4269 | 4269 | 2021-10-28 | India | Assam | 609828 | 5989 | 0 | 26.357149 | 92.83044100000001 | 2021-10-29 04:22:03 | Assam, India | |||
534659 | 534659 | 2021-10-27 | India | Assam | 609506 | 5987 | 0 | 26.357149 | 92.83044100000001 | 2021-10-28 04:22:08 | Assam, India | |||
3492096 | 3492096 | 2021-10-26 | India | Assam | 609262 | 5981 | 0 | 26.357149 | 92.83044100000001 | 2021-10-27 04:22:32 | Assam, India | |||
3793818 | 3793818 | 2021-10-25 | India | Assam | 608915 | 5978 | 0 | 26.357149 | 92.83044100000001 | 2021-10-26 04:22:09 | Assam, India | |||
682264 | 682264 | 2021-10-24 | India | Assam | 608589 | 5973 | 0 | 26.357149 | 92.83044100000001 | 2021-10-25 04:22:31 | Assam, India | |||
770272 | 770272 | 2021-10-23 | India | Assam | 608450 | 5967 | 0 | 26.357149 | 92.83044100000001 | 2021-10-24 04:21:22 | Assam, India | |||
653919 | 653919 | 2021-10-22 | India | Assam | 608126 | 5964 | 0 | 26.357149 | 92.83044100000001 | 2021-10-23 04:21:32 | Assam, India | |||
2123666 | 2123666 | 2021-10-21 | India | Assam | 607811 | 5962 | 0 | 26.357149 | 92.83044100000001 | 2021-10-22 04:21:14 | Assam, India | |||
443278 | 443278 | 2021-10-20 | India | Assam | 607427 | 5958 | 0 | 26.357149 | 92.83044100000001 | 2021-10-21 04:21:18 | Assam, India | |||
597597 | 597597 | 2021-10-19 | India | Assam | 607119 | 5957 | 0 | 26.357149 | 92.83044100000001 | 2021-10-20 04:21:00 | Assam, India | |||
2043774 | 2043774 | 2021-10-18 | India | Assam | 606766 | 5957 | 0 | 26.357149 | 92.83044100000001 | 2021-10-19 04:20:54 | Assam, India | |||
1909135 | 1909135 | 2021-10-17 | India | Assam | 606468 | 5950 | 0 | 26.357149 | 92.83044100000001 | 2021-10-18 04:21:10 | Assam, India | |||
934724 | 934724 | 2021-10-16 | India | Assam | 606263 | 5944 | 0 | 26.357149 | 92.83044100000001 | 2021-10-17 04:21:29 | Assam, India | |||
2943279 | 2943279 | 2021-10-15 | India | Assam | 605944 | 5939 | 0 | 26.357149 | 92.83044100000001 | 2021-10-16 04:21:15 | Assam, India | |||
491559 | 491559 | 2021-10-14 | India | Assam | 605847 | 5938 | 0 | 26.357149 | 92.83044100000001 | 2021-10-15 04:21:26 | Assam, India | |||
633847 | 633847 | 2021-10-13 | India | Assam | 605640 | 5936 | 0 | 26.357149 | 92.83044100000001 | 2021-10-14 04:21:29 | Assam, India | |||
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 |
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]);