johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where deaths = 4752 and province_or_state = "Jammu and Kashmir" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, last_update, day (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
229160 | 229160 | 2022-05-31 | India | Jammu and Kashmir | 454249 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-01 04:20:55 | Jammu and Kashmir, India | |||
558740 | 558740 | 2022-06-16 | India | Jammu and Kashmir | 454420 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-17 04:20:56 | Jammu and Kashmir, India | |||
621812 | 621812 | 2022-05-22 | India | Jammu and Kashmir | 454212 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-26 04:20:50 | Jammu and Kashmir, India | |||
946783 | 946783 | 2022-06-14 | India | Jammu and Kashmir | 454373 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-15 04:20:54 | Jammu and Kashmir, India | |||
970853 | 970853 | 2022-06-01 | India | Jammu and Kashmir | 454255 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-02 05:20:39 | Jammu and Kashmir, India | |||
1109508 | 1109508 | 2022-05-21 | India | Jammu and Kashmir | 454191 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-22 04:20:52 | Jammu and Kashmir, India | |||
1169132 | 1169132 | 2022-05-20 | India | Jammu and Kashmir | 454176 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-21 04:20:58 | Jammu and Kashmir, India | |||
1184679 | 1184679 | 2022-05-18 | India | Jammu and Kashmir | 454159 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-19 04:20:54 | Jammu and Kashmir, India | |||
1314133 | 1314133 | 2022-05-27 | India | Jammu and Kashmir | 454227 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-28 04:21:07 | Jammu and Kashmir, India | |||
1421037 | 1421037 | 2022-06-08 | India | Jammu and Kashmir | 454301 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-09 04:20:54 | Jammu and Kashmir, India | |||
1503533 | 1503533 | 2022-05-16 | India | Jammu and Kashmir | 454148 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-17 04:20:59 | Jammu and Kashmir, India | |||
1849925 | 1849925 | 2022-05-26 | India | Jammu and Kashmir | 454220 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-27 04:20:56 | Jammu and Kashmir, India | |||
1944431 | 1944431 | 2022-06-10 | India | Jammu and Kashmir | 454325 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-11 04:21:01 | Jammu and Kashmir, India | |||
2047801 | 2047801 | 2022-05-25 | India | Jammu and Kashmir | 454212 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-26 04:20:50 | Jammu and Kashmir, India | |||
2083892 | 2083892 | 2022-05-15 | India | Jammu and Kashmir | 454146 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-16 04:20:47 | Jammu and Kashmir, India | |||
2235317 | 2235317 | 2022-06-12 | India | Jammu and Kashmir | 454348 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-13 04:21:14 | Jammu and Kashmir, India | |||
2311236 | 2311236 | 2022-06-17 | India | Jammu and Kashmir | 454442 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-18 04:21:10 | Jammu and Kashmir, India | |||
2724952 | 2724952 | 2022-05-28 | India | Jammu and Kashmir | 454234 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-29 04:20:53 | Jammu and Kashmir, India | |||
2979191 | 2979191 | 2022-06-13 | India | Jammu and Kashmir | 454355 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-14 04:20:52 | Jammu and Kashmir, India | |||
2999239 | 2999239 | 2022-05-24 | India | Jammu and Kashmir | 454207 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-25 04:20:56 | Jammu and Kashmir, India | |||
3133485 | 3133485 | 2022-06-03 | India | Jammu and Kashmir | 454271 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-04 04:20:58 | Jammu and Kashmir, India | |||
3141515 | 3141515 | 2022-06-11 | India | Jammu and Kashmir | 454337 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-12 04:20:53 | Jammu and Kashmir, India | |||
3157570 | 3157570 | 2022-06-09 | India | Jammu and Kashmir | 454314 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-10 04:20:55 | Jammu and Kashmir, India | |||
3185925 | 3185925 | 2022-05-30 | India | Jammu and Kashmir | 454248 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-31 04:20:51 | Jammu and Kashmir, India | |||
3198074 | 3198074 | 2022-05-29 | India | Jammu and Kashmir | 454242 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-30 04:20:50 | Jammu and Kashmir, India | |||
3269447 | 3269447 | 2022-06-19 | India | Jammu and Kashmir | 454501 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-20 04:21:01 | Jammu and Kashmir, India | |||
3397359 | 3397359 | 2022-06-18 | India | Jammu and Kashmir | 454469 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-19 04:20:51 | Jammu and Kashmir, India | |||
3507322 | 3507322 | 2022-06-05 | India | Jammu and Kashmir | 454280 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-06 04:20:57 | Jammu and Kashmir, India | |||
3527399 | 3527399 | 2022-06-04 | India | Jammu and Kashmir | 454276 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-05 04:20:55 | Jammu and Kashmir, India | |||
3578560 | 3578560 | 2022-06-02 | India | Jammu and Kashmir | 454262 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-03 04:20:58 | Jammu and Kashmir, India | |||
3582576 | 3582576 | 2022-05-17 | India | Jammu and Kashmir | 454153 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-18 04:20:50 | Jammu and Kashmir, India | |||
3592960 | 3592960 | 2022-05-23 | India | Jammu and Kashmir | 454204 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-24 04:20:57 | Jammu and Kashmir, India | |||
3726151 | 3726151 | 2022-06-07 | India | Jammu and Kashmir | 454290 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-08 04:20:55 | Jammu and Kashmir, India | |||
3887553 | 3887553 | 2022-06-06 | India | Jammu and Kashmir | 454283 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-07 04:21:08 | Jammu and Kashmir, India | |||
3895895 | 3895895 | 2022-05-19 | India | Jammu and Kashmir | 454170 | 4752 | 0 | 33.75943 | 76.612638 | 2022-05-20 04:20:57 | Jammu and Kashmir, India | |||
3982542 | 3982542 | 2022-06-15 | India | Jammu and Kashmir | 454398 | 4752 | 0 | 33.75943 | 76.612638 | 2022-06-16 04:20:55 | 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]);