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 = "Jammu and Kashmir" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435972 | 3435972 | 2020-07-11 | India | Jammu and Kashmir | 10156 | 169 | 5895 | 4092 | 33.75943 | 76.612638 | 2020-07-12 04:34:30 | Jammu and Kashmir, India | ||
3237470 | 3237470 | 2020-07-10 | India | Jammu and Kashmir | 9888 | 159 | 5786 | 3943 | 33.75943 | 76.612638 | 2020-07-11 04:34:26 | Jammu and Kashmir, India | ||
1005455 | 1005455 | 2020-07-09 | India | Jammu and Kashmir | 9501 | 154 | 5695 | 3652 | 33.75943 | 76.612638 | 2020-07-10 04:34:24 | Jammu and Kashmir, India | ||
2222671 | 2222671 | 2020-07-08 | India | Jammu and Kashmir | 9261 | 149 | 5567 | 3545 | 33.75943 | 76.612638 | 2020-07-09 04:34:23 | Jammu and Kashmir, India | ||
887280 | 887280 | 2020-07-07 | India | Jammu and Kashmir | 8931 | 143 | 5399 | 3389 | 33.75943 | 76.612638 | 2020-07-08 05:33:48 | Jammu and Kashmir, India | ||
2684840 | 2684840 | 2020-07-06 | India | Jammu and Kashmir | 8675 | 138 | 5318 | 3219 | 33.75943 | 76.612638 | 2020-07-07 04:34:00 | Jammu and Kashmir, India | ||
415305 | 415305 | 2020-07-05 | India | Jammu and Kashmir | 8429 | 132 | 5255 | 3042 | 33.75943 | 76.612638 | 2020-07-06 04:33:57 | Jammu and Kashmir, India | ||
529867 | 529867 | 2020-07-04 | India | Jammu and Kashmir | 8246 | 127 | 5143 | 2976 | 33.75943 | 76.612638 | 2020-07-05 04:33:46 | Jammu and Kashmir, India | ||
2234528 | 2234528 | 2020-07-03 | India | Jammu and Kashmir | 8019 | 119 | 5075 | 2825 | 33.75943 | 76.612638 | 2020-07-04 04:33:51 | Jammu and Kashmir, India | ||
3045322 | 3045322 | 2020-07-02 | India | Jammu and Kashmir | 7849 | 115 | 4974 | 2760 | 33.75943 | 76.612638 | 2020-07-03 04:33:54 | Jammu and Kashmir, India | ||
303013 | 303013 | 2020-07-01 | India | Jammu and Kashmir | 7695 | 105 | 4856 | 2734 | 33.75943 | 76.612638 | 2020-07-02 04:33:46 | Jammu and Kashmir, India | ||
2974391 | 2974391 | 2020-06-30 | India | Jammu and Kashmir | 7497 | 101 | 4722 | 2674 | 33.75943 | 76.612638 | 2020-07-01 04:33:52 | Jammu and Kashmir, India | ||
2632868 | 2632868 | 2020-06-29 | India | Jammu and Kashmir | 7237 | 95 | 4585 | 2557 | 33.75943 | 76.612638 | 2020-06-30 04:33:48 | Jammu and Kashmir, India | ||
2306431 | 2306431 | 2020-06-28 | India | Jammu and Kashmir | 7093 | 94 | 4316 | 2683 | 33.75943 | 76.612638 | 2020-06-29 04:33:44 | Jammu and Kashmir, India | ||
2039766 | 2039766 | 2020-06-27 | India | Jammu and Kashmir | 6966 | 93 | 4225 | 2648 | 33.75943 | 76.612638 | 2020-06-28 04:34:04 | Jammu and Kashmir, India | ||
1136047 | 1136047 | 2020-06-26 | India | Jammu and Kashmir | 6762 | 91 | 4080 | 2591 | 33.75943 | 76.612638 | 2020-06-27 04:33:35 | Jammu and Kashmir, India | ||
2625034 | 2625034 | 2020-06-25 | India | Jammu and Kashmir | 6549 | 90 | 3967 | 2492 | 33.75943 | 76.612638 | 2020-06-26 04:33:43 | Jammu and Kashmir, India | ||
2700674 | 2700674 | 2020-06-24 | India | Jammu and Kashmir | 6422 | 88 | 3818 | 2516 | 33.75943 | 76.612638 | 2020-06-25 05:26:54 | Jammu and Kashmir, India | ||
1522359 | 1522359 | 2020-06-23 | India | Jammu and Kashmir | 6236 | 87 | 3642 | 2507 | 33.75943 | 76.612638 | 2020-06-24 04:33:28 | Jammu and Kashmir, India | ||
1510553 | 1510553 | 2020-06-22 | India | Jammu and Kashmir | 6088 | 85 | 3531 | 2472 | 33.75943 | 76.612638 | 2020-06-23 04:33:22 | Jammu and Kashmir, India | ||
3249292 | 3249292 | 2020-06-21 | India | Jammu and Kashmir | 5956 | 82 | 3382 | 2492 | 33.75943 | 76.612638 | 2020-06-22 04:33:20 | Jammu and Kashmir, India | ||
2437885 | 2437885 | 2020-06-20 | India | Jammu and Kashmir | 5834 | 81 | 3336 | 2417 | 33.75943 | 76.612638 | 2020-06-21 04:33:19 | Jammu and Kashmir, India | ||
1691463 | 1691463 | 2020-06-19 | India | Jammu and Kashmir | 5680 | 75 | 3194 | 2411 | 33.75943 | 76.612638 | 2020-06-20 04:33:19 | Jammu and Kashmir, India | ||
3682612 | 3682612 | 2020-06-18 | India | Jammu and Kashmir | 5555 | 71 | 3144 | 2340 | 33.75943 | 76.612638 | 2020-06-19 04:33:17 | Jammu and Kashmir, India | ||
1195815 | 1195815 | 2020-06-17 | India | Jammu and Kashmir | 5406 | 65 | 2914 | 2427 | 33.75943 | 76.612638 | 2020-06-18 04:33:18 | Jammu and Kashmir, India | ||
2386578 | 2386578 | 2020-06-16 | India | Jammu and Kashmir | 5298 | 63 | 2781 | 2454 | 33.75943 | 76.612638 | 2020-06-17 04:33:21 | Jammu and Kashmir, India | ||
287141 | 287141 | 2020-06-15 | India | Jammu and Kashmir | 5220 | 62 | 2604 | 2554 | 33.75943 | 76.612638 | 2020-06-16 04:33:09 | Jammu and Kashmir, India | ||
1837092 | 1837092 | 2020-06-14 | India | Jammu and Kashmir | 4878 | 55 | 2269 | 2554 | 33.75943 | 76.612638 | 2020-06-15 03:33:14 | Jammu and Kashmir, India | ||
3061144 | 3061144 | 2020-06-13 | India | Jammu and Kashmir | 4730 | 53 | 2086 | 2591 | 33.75943 | 76.612638 | 2020-06-14 03:33:15 | Jammu and Kashmir, India | ||
737464 | 737464 | 2020-06-12 | India | Jammu and Kashmir | 4574 | 52 | 1820 | 2702 | 33.75943 | 76.612638 | 2020-06-13 03:33:14 | Jammu and Kashmir, India | ||
1273434 | 1273434 | 2020-06-11 | India | Jammu and Kashmir | 4574 | 52 | 1820 | 2702 | 33.75943 | 76.612638 | 2020-06-12 05:09:52 | Jammu and Kashmir, India | ||
2863877 | 2863877 | 2020-06-10 | India | Jammu and Kashmir | 4346 | 48 | 1506 | 2792 | 33.75943 | 76.612638 | 2020-06-11 03:33:41 | Jammu and Kashmir, 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]);