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 = "Jharkhand" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462742 | 2462742 | 2021-09-14 | India | Jharkhand | 348086 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-15 03:22:37 | Jharkhand, India | |||
1385581 | 1385581 | 2021-09-13 | India | Jharkhand | 348079 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-14 04:21:41 | Jharkhand, India | |||
1884950 | 1884950 | 2021-09-12 | India | Jharkhand | 348073 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-13 04:21:15 | Jharkhand, India | |||
3805853 | 3805853 | 2021-09-11 | India | Jharkhand | 348062 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-12 04:21:13 | Jharkhand, India | |||
3448793 | 3448793 | 2021-09-10 | India | Jharkhand | 348055 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-11 04:21:30 | Jharkhand, India | |||
1262739 | 1262739 | 2021-09-09 | India | Jharkhand | 348039 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-10 04:21:20 | Jharkhand, India | |||
2279109 | 2279109 | 2021-09-08 | India | Jharkhand | 348012 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-09 04:21:27 | Jharkhand, India | |||
641888 | 641888 | 2021-09-07 | India | Jharkhand | 347989 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-08 04:21:31 | Jharkhand, India | |||
3193951 | 3193951 | 2021-09-06 | India | Jharkhand | 347975 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-07 04:21:35 | Jharkhand, India | |||
3280819 | 3280819 | 2021-09-05 | India | Jharkhand | 347957 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-06 04:21:22 | Jharkhand, India | |||
249233 | 249233 | 2021-09-04 | India | Jharkhand | 347942 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-05 04:21:33 | Jharkhand, India | |||
3974514 | 3974514 | 2021-09-03 | India | Jharkhand | 347933 | 5132 | 0 | 23.654536 | 85.557631 | 2021-09-04 04:21:28 | Jharkhand, India | |||
177976 | 177976 | 2021-09-02 | India | Jharkhand | 347922 | 5132 | 0 | 23.654536 | 85.557631 | 2021-09-03 04:21:20 | Jharkhand, India | |||
67011 | 67011 | 2021-09-01 | India | Jharkhand | 347894 | 5132 | 0 | 23.654536 | 85.557631 | 2021-09-02 04:21:15 | Jharkhand, India | |||
2067853 | 2067853 | 2021-08-31 | India | Jharkhand | 347867 | 5132 | 0 | 23.654536 | 85.557631 | 2021-09-01 04:21:38 | Jharkhand, India | |||
1775307 | 1775307 | 2021-08-30 | India | Jharkhand | 347855 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-31 04:21:46 | Jharkhand, India | |||
3891881 | 3891881 | 2021-08-29 | India | Jharkhand | 347842 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-30 04:21:23 | Jharkhand, India | |||
2792984 | 2792984 | 2021-08-28 | India | Jharkhand | 347829 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-29 04:21:14 | Jharkhand, India | |||
2923143 | 2923143 | 2021-08-27 | India | Jharkhand | 347815 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-28 04:21:28 | Jharkhand, India | |||
1596157 | 1596157 | 2021-08-26 | India | Jharkhand | 347794 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-27 04:21:37 | Jharkhand, India | |||
32366 | 32366 | 2021-08-25 | India | Jharkhand | 347763 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-26 04:21:28 | Jharkhand, India | |||
3105405 | 3105405 | 2021-08-24 | India | Jharkhand | 347755 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-25 04:21:41 | Jharkhand, India | |||
3165576 | 3165576 | 2021-08-23 | India | Jharkhand | 347748 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-24 04:21:19 | Jharkhand, India | |||
2175503 | 2175503 | 2021-08-22 | India | Jharkhand | 347730 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-23 04:21:27 | Jharkhand, India | |||
3555599 | 3555599 | 2021-08-21 | India | Jharkhand | 347725 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-22 04:21:29 | Jharkhand, India | |||
1853941 | 1853941 | 2021-08-20 | India | Jharkhand | 347707 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-21 04:21:38 | Jharkhand, India | |||
511648 | 511648 | 2021-08-19 | India | Jharkhand | 347690 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-20 04:21:33 | Jharkhand, India | |||
2518127 | 2518127 | 2021-08-18 | India | Jharkhand | 347667 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-19 04:21:15 | Jharkhand, India | |||
245219 | 245219 | 2021-08-17 | India | Jharkhand | 347635 | 5132 | 0 | 23.654536 | 85.557631 | 2021-08-18 04:21:35 | Jharkhand, India | |||
1604182 | 1604182 | 2021-08-16 | India | Jharkhand | 347620 | 5131 | 0 | 23.654536 | 85.557631 | 2021-08-17 04:21:49 | Jharkhand, India | |||
103276 | 103276 | 2021-08-15 | India | Jharkhand | 347585 | 5131 | 0 | 23.654536 | 85.557631 | 2021-08-16 04:21:31 | Jharkhand, India | |||
507634 | 507634 | 2021-08-14 | India | Jharkhand | 347558 | 5131 | 0 | 23.654536 | 85.557631 | 2021-08-15 04:21:41 | Jharkhand, India | |||
1483506 | 1483506 | 2021-08-13 | India | Jharkhand | 347530 | 5131 | 0 | 23.654536 | 85.557631 | 2021-08-14 04:21:25 | Jharkhand, India | |||
2899636 | 2899636 | 2021-08-12 | India | Jharkhand | 347498 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-13 04:21:24 | Jharkhand, India | |||
1342240 | 1342240 | 2021-08-11 | India | Jharkhand | 347454 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-12 04:21:25 | Jharkhand, India | |||
2351387 | 2351387 | 2021-08-10 | India | Jharkhand | 347440 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-11 04:21:58 | Jharkhand, India | |||
649916 | 649916 | 2021-08-09 | India | Jharkhand | 347406 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-10 04:21:27 | Jharkhand, India | |||
589578 | 589578 | 2021-08-08 | India | Jharkhand | 347392 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-09 04:21:24 | Jharkhand, India | |||
2203590 | 2203590 | 2021-08-07 | India | Jharkhand | 347373 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-08 04:21:33 | Jharkhand, India | |||
1117540 | 1117540 | 2021-08-06 | India | Jharkhand | 347336 | 5130 | 0 | 23.654536 | 85.557631 | 2021-08-07 04:21:30 | Jharkhand, India | |||
1956477 | 1956477 | 2021-08-05 | India | Jharkhand | 347304 | 5129 | 0 | 23.654536 | 85.557631 | 2021-08-06 04:21:18 | Jharkhand, India | |||
331856 | 331856 | 2021-08-04 | India | Jharkhand | 347276 | 5129 | 341924 | 223 | 23.654536 | 85.557631 | 2021-08-05 04:21:51 | Jharkhand, India | ||
3468127 | 3468127 | 2021-08-03 | India | Jharkhand | 347246 | 5129 | 341883 | 234 | 23.654536 | 85.557631 | 2021-08-04 04:21:25 | Jharkhand, India | ||
3683401 | 3683401 | 2021-08-02 | India | Jharkhand | 347223 | 5129 | 341855 | 239 | 23.654536 | 85.557631 | 2021-08-03 04:21:39 | Jharkhand, India | ||
3015300 | 3015300 | 2021-08-01 | India | Jharkhand | 347200 | 5129 | 341817 | 254 | 23.654536 | 85.557631 | 2021-08-02 04:21:36 | Jharkhand, India | ||
3903923 | 3903923 | 2021-07-31 | India | Jharkhand | 347173 | 5128 | 341793 | 252 | 23.654536 | 85.557631 | 2021-08-01 04:21:50 | Jharkhand, India | ||
3296128 | 3296128 | 2021-07-30 | India | Jharkhand | 347137 | 5128 | 341749 | 260 | 23.654536 | 85.557631 | 2021-07-31 04:21:35 | Jharkhand, India | ||
3385339 | 3385339 | 2021-07-29 | India | Jharkhand | 347105 | 5126 | 341720 | 259 | 23.654536 | 85.557631 | 2021-07-30 04:21:34 | Jharkhand, India | ||
408244 | 408244 | 2021-07-28 | India | Jharkhand | 347049 | 5126 | 341686 | 237 | 23.654536 | 85.557631 | 2021-07-29 04:21:33 | Jharkhand, India | ||
1306105 | 1306105 | 2021-07-27 | India | Jharkhand | 347022 | 5125 | 341650 | 247 | 23.654536 | 85.557631 | 2021-07-28 04:21:39 | Jharkhand, India | ||
3218248 | 3218248 | 2021-07-26 | India | Jharkhand | 346983 | 5124 | 341613 | 246 | 23.654536 | 85.557631 | 2021-07-27 04:21:18 | Jharkhand, India | ||
1378457 | 1378457 | 2021-07-25 | India | Jharkhand | 346946 | 5124 | 341568 | 254 | 23.654536 | 85.557631 | 2021-07-26 04:21:28 | Jharkhand, India | ||
1330197 | 1330197 | 2021-07-24 | India | Jharkhand | 346918 | 5124 | 341518 | 276 | 23.654536 | 85.557631 | 2021-07-25 04:22:12 | Jharkhand, India | ||
3137501 | 3137501 | 2021-07-23 | India | Jharkhand | 346885 | 5122 | 341419 | 344 | 23.654536 | 85.557631 | 2021-07-24 00:21:36 | Jharkhand, India | ||
3476261 | 3476261 | 2021-07-22 | India | Jharkhand | 346846 | 5122 | 341419 | 305 | 23.654536 | 85.557631 | 2021-07-23 04:21:29 | Jharkhand, India | ||
3331480 | 3331480 | 2021-07-21 | India | Jharkhand | 346824 | 5122 | 341387 | 315 | 23.654536 | 85.557631 | 2021-07-22 04:21:19 | Jharkhand, India | ||
2371461 | 2371461 | 2021-07-20 | India | Jharkhand | 346778 | 5122 | 341336 | 320 | 23.654536 | 85.557631 | 2021-07-21 04:21:40 | Jharkhand, India | ||
483540 | 483540 | 2021-07-19 | India | Jharkhand | 346745 | 5122 | 341287 | 336 | 23.654536 | 85.557631 | 2021-07-20 04:21:48 | Jharkhand, India | ||
2673763 | 2673763 | 2021-07-18 | India | Jharkhand | 346681 | 5120 | 341234 | 327 | 23.654536 | 85.557631 | 2021-07-19 04:21:24 | Jharkhand, India | ||
3706075 | 3706075 | 2021-07-17 | India | Jharkhand | 346649 | 5120 | 341192 | 337 | 23.654536 | 85.557631 | 2021-07-18 04:22:07 | Jharkhand, India | ||
2947306 | 2947306 | 2021-07-16 | India | Jharkhand | 346588 | 5120 | 341128 | 340 | 23.654536 | 85.557631 | 2021-07-17 04:22:22 | Jharkhand, India | ||
295962 | 295962 | 2021-07-15 | India | Jharkhand | 346533 | 5120 | 341077 | 336 | 23.654536 | 85.557631 | 2021-07-16 04:21:22 | Jharkhand, India | ||
3631907 | 3631907 | 2021-07-14 | India | Jharkhand | 346479 | 5120 | 341015 | 344 | 23.654536 | 85.557631 | 2021-07-15 04:21:48 | Jharkhand, India | ||
578782 | 578782 | 2021-07-13 | India | Jharkhand | 346411 | 5120 | 340944 | 347 | 23.654536 | 85.557631 | 2021-07-14 04:21:35 | Jharkhand, India | ||
3741031 | 3741031 | 2021-07-12 | India | Jharkhand | 346371 | 5119 | 340862 | 390 | 23.654536 | 85.557631 | 2021-07-13 04:21:18 | Jharkhand, India | ||
3659544 | 3659544 | 2021-07-11 | India | Jharkhand | 346328 | 5119 | 340798 | 411 | 23.654536 | 85.557631 | 2021-07-12 04:21:34 | Jharkhand, India | ||
625828 | 625828 | 2021-07-10 | India | Jharkhand | 346279 | 5119 | 340737 | 423 | 23.654536 | 85.557631 | 2021-07-11 04:21:43 | Jharkhand, India | ||
829547 | 829547 | 2021-07-09 | India | Jharkhand | 346223 | 5119 | 340655 | 449 | 23.654536 | 85.557631 | 2021-07-10 04:21:25 | Jharkhand, India | ||
778311 | 778311 | 2021-07-08 | India | Jharkhand | 346168 | 5119 | 340573 | 476 | 23.654536 | 85.557631 | 2021-07-09 04:21:21 | Jharkhand, India | ||
1440533 | 1440533 | 2021-07-07 | India | Jharkhand | 346113 | 5118 | 340463 | 532 | 23.654536 | 85.557631 | 2021-07-08 04:21:26 | Jharkhand, India | ||
2693638 | 2693638 | 2021-07-06 | India | Jharkhand | 346038 | 5118 | 340365 | 555 | 23.654536 | 85.557631 | 2021-07-07 04:21:20 | Jharkhand, India | ||
1932387 | 1932387 | 2021-07-05 | India | Jharkhand | 345983 | 5117 | 340257 | 609 | 23.654536 | 85.557631 | 2021-07-06 04:21:32 | Jharkhand, India | ||
1165118 | 1165118 | 2021-07-04 | India | Jharkhand | 345937 | 5115 | 340164 | 658 | 23.654536 | 85.557631 | 2021-07-05 04:21:28 | Jharkhand, India | ||
1495552 | 1495552 | 2021-07-03 | India | Jharkhand | 345885 | 5114 | 339966 | 805 | 23.654536 | 85.557631 | 2021-07-04 04:21:38 | Jharkhand, India | ||
2071867 | 2071867 | 2021-07-02 | India | Jharkhand | 345794 | 5113 | 339850 | 831 | 23.654536 | 85.557631 | 2021-07-03 04:21:37 | Jharkhand, India | ||
2764883 | 2764883 | 2021-07-01 | India | Jharkhand | 345706 | 5113 | 339739 | 854 | 23.654536 | 85.557631 | 2021-07-02 04:21:47 | Jharkhand, India | ||
1893091 | 1893091 | 2021-06-30 | India | Jharkhand | 345610 | 5113 | 339583 | 914 | 23.654536 | 85.557631 | 2021-07-01 04:21:19 | Jharkhand, India | ||
400214 | 400214 | 2021-06-29 | India | Jharkhand | 345525 | 5113 | 339463 | 949 | 23.654536 | 85.557631 | 2021-06-30 04:21:41 | Jharkhand, India | ||
3125457 | 3125457 | 2021-06-28 | India | Jharkhand | 345430 | 5111 | 339314 | 1005 | 23.654536 | 85.557631 | 2021-06-29 04:21:28 | Jharkhand, India | ||
2589952 | 2589952 | 2021-06-27 | India | Jharkhand | 345340 | 5111 | 339199 | 1030 | 23.654536 | 85.557631 | 2021-06-28 04:21:29 | Jharkhand, India | ||
3958456 | 3958456 | 2021-06-26 | India | Jharkhand | 345259 | 5110 | 339036 | 1113 | 23.654536 | 85.557631 | 2021-06-27 04:21:39 | Jharkhand, India | ||
1712275 | 1712275 | 2021-06-25 | India | Jharkhand | 345161 | 5107 | 338870 | 1184 | 23.654536 | 85.557631 | 2021-06-26 04:21:43 | Jharkhand, India | ||
2295400 | 2295400 | 2021-06-24 | India | Jharkhand | 345028 | 5106 | 338698 | 1224 | 23.654536 | 85.557631 | 2021-06-25 04:21:33 | Jharkhand, India | ||
2422840 | 2422840 | 2021-06-23 | India | Jharkhand | 344914 | 5104 | 338446 | 1364 | 23.654536 | 85.557631 | 2021-06-24 04:21:55 | Jharkhand, India | ||
562917 | 562917 | 2021-06-22 | India | Jharkhand | 344775 | 5102 | 338256 | 1417 | 23.654536 | 85.557631 | 2021-06-23 04:21:46 | Jharkhand, India | ||
3358619 | 3358619 | 2021-06-21 | India | Jharkhand | 344665 | 5100 | 338076 | 1489 | 23.654536 | 85.557631 | 2021-06-22 04:21:34 | Jharkhand, India | ||
2884318 | 2884318 | 2021-06-20 | India | Jharkhand | 344543 | 5099 | 337848 | 1596 | 23.654536 | 85.557631 | 2021-06-21 04:21:41 | Jharkhand, India | ||
107401 | 107401 | 2021-06-19 | India | Jharkhand | 344405 | 5099 | 337667 | 1639 | 23.654536 | 85.557631 | 2021-06-20 04:21:48 | Jharkhand, India | ||
1125544 | 1125544 | 2021-06-18 | India | Jharkhand | 344270 | 5097 | 337362 | 1811 | 23.654536 | 85.557631 | 2021-06-19 04:22:33 | Jharkhand, India | ||
2911122 | 2911122 | 2021-06-17 | India | Jharkhand | 344129 | 5095 | 337088 | 1946 | 23.654536 | 85.557631 | 2021-06-18 04:22:16 | Jharkhand, India | ||
3030240 | 3030240 | 2021-06-16 | India | Jharkhand | 343983 | 5092 | 336645 | 2246 | 23.654536 | 85.557631 | 2021-06-17 04:22:36 | Jharkhand, India | ||
2339346 | 2339346 | 2021-06-15 | India | Jharkhand | 343793 | 5089 | 336058 | 2646 | 23.654536 | 85.557631 | 2021-06-16 04:22:32 | Jharkhand, India | ||
1564042 | 1564042 | 2021-06-14 | India | Jharkhand | 343609 | 5085 | 335462 | 3062 | 23.654536 | 85.557631 | 2021-06-15 04:22:22 | Jharkhand, India | ||
3381325 | 3381325 | 2021-06-13 | India | Jharkhand | 343458 | 5084 | 334979 | 3395 | 23.654536 | 85.557631 | 2021-06-14 04:22:46 | Jharkhand, India | ||
1736459 | 1736459 | 2021-06-12 | India | Jharkhand | 343304 | 5082 | 334256 | 3966 | 23.654536 | 85.557631 | 2021-06-13 04:22:44 | Jharkhand, India | ||
3970500 | 3970500 | 2021-06-11 | India | Jharkhand | 343065 | 5082 | 333763 | 4220 | 23.654536 | 85.557631 | 2021-06-12 04:22:22 | Jharkhand, India | ||
2716922 | 2716922 | 2021-06-10 | India | Jharkhand | 342774 | 5081 | 333179 | 4514 | 23.654536 | 85.557631 | 2021-06-11 04:23:20 | Jharkhand, India | ||
522807 | 522807 | 2021-06-09 | India | Jharkhand | 342481 | 5076 | 332622 | 4783 | 23.654536 | 85.557631 | 2021-06-10 04:23:17 | Jharkhand, India | ||
3472247 | 3472247 | 2021-06-08 | India | Jharkhand | 342179 | 5073 | 332007 | 5099 | 23.654536 | 85.557631 | 2021-06-09 04:23:31 | Jharkhand, India | ||
3145531 | 3145531 | 2021-06-07 | India | Jharkhand | 341576 | 5060 | 331204 | 5312 | 23.654536 | 85.557631 | 2021-06-08 04:22:35 | Jharkhand, 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]);