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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435975 | 3435975 | 2020-07-11 | India | Jharkhand | 3613 | 23 | 2243 | 1347 | 23.654536 | 85.557631 | 2020-07-12 04:34:30 | Jharkhand, India | ||
3237473 | 3237473 | 2020-07-10 | India | Jharkhand | 3419 | 23 | 2224 | 1172 | 23.654536 | 85.557631 | 2020-07-11 04:34:26 | Jharkhand, India | ||
1005458 | 1005458 | 2020-07-09 | India | Jharkhand | 3246 | 23 | 2208 | 1015 | 23.654536 | 85.557631 | 2020-07-10 04:34:24 | Jharkhand, India | ||
2222674 | 2222674 | 2020-07-08 | India | Jharkhand | 3096 | 22 | 2170 | 904 | 23.654536 | 85.557631 | 2020-07-09 04:34:23 | Jharkhand, India | ||
887283 | 887283 | 2020-07-07 | India | Jharkhand | 2996 | 22 | 2104 | 870 | 23.654536 | 85.557631 | 2020-07-08 05:33:48 | Jharkhand, India | ||
2684843 | 2684843 | 2020-07-06 | India | Jharkhand | 2847 | 20 | 2068 | 759 | 23.654536 | 85.557631 | 2020-07-07 04:34:00 | Jharkhand, India | ||
415308 | 415308 | 2020-07-05 | India | Jharkhand | 2781 | 19 | 2045 | 717 | 23.654536 | 85.557631 | 2020-07-06 04:33:57 | Jharkhand, India | ||
529870 | 529870 | 2020-07-04 | India | Jharkhand | 2739 | 17 | 2035 | 687 | 23.654536 | 85.557631 | 2020-07-05 04:33:46 | Jharkhand, India | ||
2234531 | 2234531 | 2020-07-03 | India | Jharkhand | 2695 | 15 | 2001 | 679 | 23.654536 | 85.557631 | 2020-07-04 04:33:51 | Jharkhand, India | ||
3045325 | 3045325 | 2020-07-02 | India | Jharkhand | 2584 | 15 | 1983 | 586 | 23.654536 | 85.557631 | 2020-07-03 04:33:54 | Jharkhand, India | ||
303016 | 303016 | 2020-07-01 | India | Jharkhand | 2521 | 15 | 1931 | 575 | 23.654536 | 85.557631 | 2020-07-02 04:33:46 | Jharkhand, India | ||
2974394 | 2974394 | 2020-06-30 | India | Jharkhand | 2490 | 15 | 1884 | 591 | 23.654536 | 85.557631 | 2020-07-01 04:33:52 | Jharkhand, India | ||
2632871 | 2632871 | 2020-06-29 | India | Jharkhand | 2426 | 15 | 1845 | 566 | 23.654536 | 85.557631 | 2020-06-30 04:33:48 | Jharkhand, India | ||
2306434 | 2306434 | 2020-06-28 | India | Jharkhand | 2364 | 12 | 1793 | 559 | 23.654536 | 85.557631 | 2020-06-29 04:33:44 | Jharkhand, India | ||
2039769 | 2039769 | 2020-06-27 | India | Jharkhand | 2339 | 12 | 1724 | 603 | 23.654536 | 85.557631 | 2020-06-28 04:34:04 | Jharkhand, India | ||
1136050 | 1136050 | 2020-06-26 | India | Jharkhand | 2290 | 12 | 1643 | 635 | 23.654536 | 85.557631 | 2020-06-27 04:33:35 | Jharkhand, India | ||
2625037 | 2625037 | 2020-06-25 | India | Jharkhand | 2262 | 12 | 1605 | 645 | 23.654536 | 85.557631 | 2020-06-26 04:33:43 | Jharkhand, India | ||
2700677 | 2700677 | 2020-06-24 | India | Jharkhand | 2207 | 11 | 1570 | 626 | 23.654536 | 85.557631 | 2020-06-25 05:26:54 | Jharkhand, India | ||
1522362 | 1522362 | 2020-06-23 | India | Jharkhand | 2185 | 11 | 1520 | 654 | 23.654536 | 85.557631 | 2020-06-24 04:33:28 | Jharkhand, India | ||
1510556 | 1510556 | 2020-06-22 | India | Jharkhand | 2137 | 11 | 1469 | 657 | 23.654536 | 85.557631 | 2020-06-23 04:33:22 | Jharkhand, India | ||
3249295 | 3249295 | 2020-06-21 | India | Jharkhand | 2073 | 11 | 1406 | 656 | 23.654536 | 85.557631 | 2020-06-22 04:33:20 | Jharkhand, India | ||
2437888 | 2437888 | 2020-06-20 | India | Jharkhand | 1965 | 11 | 1335 | 619 | 23.654536 | 85.557631 | 2020-06-21 04:33:19 | Jharkhand, India | ||
1691466 | 1691466 | 2020-06-19 | India | Jharkhand | 1965 | 11 | 1332 | 622 | 23.654536 | 85.557631 | 2020-06-20 04:33:19 | Jharkhand, India | ||
3682615 | 3682615 | 2020-06-18 | India | Jharkhand | 1920 | 11 | 1198 | 711 | 23.654536 | 85.557631 | 2020-06-19 04:33:17 | Jharkhand, India | ||
1195818 | 1195818 | 2020-06-17 | India | Jharkhand | 1895 | 10 | 1151 | 734 | 23.654536 | 85.557631 | 2020-06-18 04:33:18 | Jharkhand, India | ||
2386581 | 2386581 | 2020-06-16 | India | Jharkhand | 1839 | 9 | 1121 | 709 | 23.654536 | 85.557631 | 2020-06-17 04:33:21 | Jharkhand, India | ||
287144 | 287144 | 2020-06-15 | India | Jharkhand | 1763 | 8 | 905 | 850 | 23.654536 | 85.557631 | 2020-06-16 04:33:09 | Jharkhand, India | ||
1837095 | 1837095 | 2020-06-14 | India | Jharkhand | 1711 | 8 | 816 | 887 | 23.654536 | 85.557631 | 2020-06-15 03:33:14 | Jharkhand, India | ||
3061147 | 3061147 | 2020-06-13 | India | Jharkhand | 1617 | 8 | 672 | 937 | 23.654536 | 85.557631 | 2020-06-14 03:33:15 | Jharkhand, India | ||
737467 | 737467 | 2020-06-12 | India | Jharkhand | 1599 | 8 | 630 | 961 | 23.654536 | 85.557631 | 2020-06-13 03:33:14 | Jharkhand, India | ||
1273437 | 1273437 | 2020-06-11 | India | Jharkhand | 1599 | 8 | 630 | 961 | 23.654536 | 85.557631 | 2020-06-12 05:09:52 | Jharkhand, India | ||
2863880 | 2863880 | 2020-06-10 | India | Jharkhand | 1411 | 8 | 559 | 844 | 23.654536 | 85.557631 | 2020-06-11 03:33:41 | 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]);