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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
443289 | 443289 | 2021-10-20 | India | Jharkhand | 348486 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-21 04:21:18 | Jharkhand, India | |||
597608 | 597608 | 2021-10-19 | India | Jharkhand | 348461 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-20 04:21:00 | Jharkhand, India | |||
2043785 | 2043785 | 2021-10-18 | India | Jharkhand | 348444 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-19 04:20:54 | Jharkhand, India | |||
1909146 | 1909146 | 2021-10-17 | India | Jharkhand | 348430 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-18 04:21:10 | Jharkhand, India | |||
934735 | 934735 | 2021-10-16 | India | Jharkhand | 348423 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-17 04:21:29 | Jharkhand, India | |||
2943290 | 2943290 | 2021-10-15 | India | Jharkhand | 348415 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-16 04:21:15 | Jharkhand, India | |||
491570 | 491570 | 2021-10-14 | India | Jharkhand | 348406 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-15 04:21:26 | Jharkhand, India | |||
633858 | 633858 | 2021-10-13 | India | Jharkhand | 348395 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-14 04:21:29 | Jharkhand, India | |||
1491536 | 1491536 | 2021-10-12 | India | Jharkhand | 348381 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-13 04:20:51 | Jharkhand, India | |||
3007269 | 3007269 | 2021-10-11 | India | Jharkhand | 348365 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-12 04:21:09 | Jharkhand, India | |||
423285 | 423285 | 2021-10-10 | India | Jharkhand | 348352 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-11 04:21:31 | Jharkhand, India | |||
2876142 | 2876142 | 2021-10-09 | India | Jharkhand | 348343 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-10 04:21:38 | Jharkhand, India | |||
2959308 | 2959308 | 2021-10-08 | India | Jharkhand | 348334 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-09 04:21:34 | Jharkhand, India | |||
467346 | 467346 | 2021-10-07 | India | Jharkhand | 348314 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-08 04:21:25 | Jharkhand, India | |||
2458726 | 2458726 | 2021-10-06 | India | Jharkhand | 348287 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-07 04:21:36 | Jharkhand, India | |||
3832420 | 3832420 | 2021-10-05 | India | Jharkhand | 348280 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-06 04:21:33 | Jharkhand, India | |||
986913 | 986913 | 2021-10-04 | India | Jharkhand | 348272 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-05 04:21:27 | Jharkhand, India | |||
1274223 | 1274223 | 2021-10-03 | India | Jharkhand | 348264 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-04 04:21:31 | Jharkhand, India | |||
3927976 | 3927976 | 2021-10-02 | India | Jharkhand | 348255 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-03 04:21:24 | Jharkhand, India | |||
2131956 | 2131956 | 2021-10-01 | India | Jharkhand | 348238 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-02 04:21:25 | Jharkhand, India | |||
2772913 | 2772913 | 2021-09-30 | India | Jharkhand | 348226 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-01 04:21:35 | Jharkhand, India | |||
706369 | 706369 | 2021-09-29 | India | Jharkhand | 348215 | 5135 | 0 | 23.654536 | 85.557631 | 2021-09-30 04:21:20 | Jharkhand, India | |||
1334211 | 1334211 | 2021-09-28 | India | Jharkhand | 348209 | 5135 | 0 | 23.654536 | 85.557631 | 2021-09-29 04:21:45 | Jharkhand, India | |||
1235580 | 1235580 | 2021-09-27 | India | Jharkhand | 348198 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-28 04:21:28 | Jharkhand, India | |||
2075881 | 2075881 | 2021-09-26 | India | Jharkhand | 348194 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-27 04:21:16 | Jharkhand, India | |||
1724433 | 1724433 | 2021-09-25 | India | Jharkhand | 348189 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-26 04:21:29 | Jharkhand, India | |||
1921153 | 1921153 | 2021-09-24 | India | Jharkhand | 348174 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-25 04:21:31 | Jharkhand, India | |||
601624 | 601624 | 2021-09-23 | India | Jharkhand | 348162 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-24 04:21:44 | Jharkhand, India | |||
3011285 | 3011285 | 2021-09-22 | India | Jharkhand | 348146 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-23 04:21:43 | Jharkhand, India | |||
3757423 | 3757423 | 2021-09-21 | India | Jharkhand | 348139 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-22 04:21:45 | Jharkhand, India | |||
809526 | 809526 | 2021-09-20 | India | Jharkhand | 348125 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-21 04:21:26 | Jharkhand, India | |||
1814725 | 1814725 | 2021-09-19 | India | Jharkhand | 348116 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-20 04:21:22 | Jharkhand, India | |||
16305 | 16305 | 2021-09-18 | India | Jharkhand | 348114 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-19 04:21:34 | Jharkhand, India | |||
2617990 | 2617990 | 2021-09-17 | India | Jharkhand | 348111 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-18 04:21:24 | Jharkhand, India | |||
2808698 | 2808698 | 2021-09-16 | India | Jharkhand | 348102 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-17 04:21:46 | Jharkhand, India | |||
1374443 | 1374443 | 2021-09-15 | India | Jharkhand | 348096 | 5133 | 0 | 23.654536 | 85.557631 | 2021-09-16 04:22:19 | Jharkhand, India | |||
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 |
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]);