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 = "Karnataka" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435992 | 3435992 | 2020-07-11 | India | Karnataka | 36216 | 613 | 14716 | 20887 | 14.705179999999999 | 76.166436 | 2020-07-12 04:34:30 | Karnataka, India | ||
3237490 | 3237490 | 2020-07-10 | India | Karnataka | 33418 | 543 | 13836 | 19039 | 14.705179999999999 | 76.166436 | 2020-07-11 04:34:26 | Karnataka, India | ||
1005475 | 1005475 | 2020-07-09 | India | Karnataka | 31105 | 486 | 12833 | 17786 | 14.705179999999999 | 76.166436 | 2020-07-10 04:34:24 | Karnataka, India | ||
2222691 | 2222691 | 2020-07-08 | India | Karnataka | 28877 | 470 | 11876 | 16531 | 14.705179999999999 | 76.166436 | 2020-07-09 04:34:23 | Karnataka, India | ||
887300 | 887300 | 2020-07-07 | India | Karnataka | 26815 | 416 | 11098 | 15301 | 14.705179999999999 | 76.166436 | 2020-07-08 05:33:48 | Karnataka, India | ||
2684860 | 2684860 | 2020-07-06 | India | Karnataka | 25317 | 401 | 10527 | 14389 | 14.705179999999999 | 76.166436 | 2020-07-07 04:34:00 | Karnataka, India | ||
415325 | 415325 | 2020-07-05 | India | Karnataka | 23474 | 372 | 9847 | 13255 | 14.705179999999999 | 76.166436 | 2020-07-06 04:33:57 | Karnataka, India | ||
529887 | 529887 | 2020-07-04 | India | Karnataka | 21549 | 335 | 9244 | 11970 | 14.705179999999999 | 76.166436 | 2020-07-05 04:33:46 | Karnataka, India | ||
2234548 | 2234548 | 2020-07-03 | India | Karnataka | 19710 | 293 | 8805 | 10612 | 14.705179999999999 | 76.166436 | 2020-07-04 04:33:51 | Karnataka, India | ||
3045342 | 3045342 | 2020-07-02 | India | Karnataka | 18016 | 272 | 8334 | 9410 | 14.70518 | 76.166436 | 2020-07-03 04:33:54 | Karnataka, India | ||
303033 | 303033 | 2020-07-01 | India | Karnataka | 16514 | 253 | 8063 | 8198 | 14.705179999999999 | 76.166436 | 2020-07-02 04:33:46 | Karnataka, India | ||
2974411 | 2974411 | 2020-06-30 | India | Karnataka | 15242 | 246 | 7918 | 7078 | 14.705179999999999 | 76.166436 | 2020-07-01 04:33:52 | Karnataka, India | ||
2632888 | 2632888 | 2020-06-29 | India | Karnataka | 14295 | 226 | 7683 | 6386 | 14.70518 | 76.166436 | 2020-06-30 04:33:48 | Karnataka, India | ||
2306451 | 2306451 | 2020-06-28 | India | Karnataka | 13190 | 207 | 7507 | 5476 | 14.705179999999999 | 76.166436 | 2020-06-29 04:33:44 | Karnataka, India | ||
2039786 | 2039786 | 2020-06-27 | India | Karnataka | 11923 | 191 | 7287 | 4445 | 14.705179999999999 | 76.166436 | 2020-06-28 04:34:04 | Karnataka, India | ||
1136067 | 1136067 | 2020-06-26 | India | Karnataka | 11005 | 180 | 6916 | 3909 | 14.705179999999999 | 76.166436 | 2020-06-27 04:33:35 | Karnataka, India | ||
2625054 | 2625054 | 2020-06-25 | India | Karnataka | 10560 | 170 | 6670 | 3720 | 14.705179999999999 | 76.166436 | 2020-06-26 04:33:43 | Karnataka, India | ||
2700694 | 2700694 | 2020-06-24 | India | Karnataka | 10118 | 164 | 6151 | 3803 | 14.705179999999999 | 76.166436 | 2020-06-25 05:26:54 | Karnataka, India | ||
1522379 | 1522379 | 2020-06-23 | India | Karnataka | 9721 | 150 | 6004 | 3567 | 14.705179999999999 | 76.166436 | 2020-06-24 04:33:28 | Karnataka, India | ||
1510573 | 1510573 | 2020-06-22 | India | Karnataka | 9399 | 142 | 5730 | 3527 | 14.705179999999999 | 76.166436 | 2020-06-23 04:33:22 | Karnataka, India | ||
3249312 | 3249312 | 2020-06-21 | India | Karnataka | 9150 | 137 | 5618 | 3395 | 14.705179999999999 | 76.166436 | 2020-06-22 04:33:20 | Karnataka, India | ||
2437905 | 2437905 | 2020-06-20 | India | Karnataka | 8697 | 132 | 5391 | 3174 | 14.705179999999999 | 76.166436 | 2020-06-21 04:33:19 | Karnataka, India | ||
1691483 | 1691483 | 2020-06-19 | India | Karnataka | 8281 | 124 | 5210 | 2947 | 14.705179999999999 | 76.166436 | 2020-06-20 04:33:19 | Karnataka, India | ||
3682632 | 3682632 | 2020-06-18 | India | Karnataka | 7944 | 114 | 4983 | 2847 | 14.705179999999999 | 76.166436 | 2020-06-19 04:33:17 | Karnataka, India | ||
1195835 | 1195835 | 2020-06-17 | India | Karnataka | 7734 | 102 | 4804 | 2828 | 14.705179999999999 | 76.166436 | 2020-06-18 04:33:18 | Karnataka, India | ||
2386598 | 2386598 | 2020-06-16 | India | Karnataka | 7530 | 94 | 4456 | 2980 | 14.705179999999999 | 76.166436 | 2020-06-17 04:33:21 | Karnataka, India | ||
287161 | 287161 | 2020-06-15 | India | Karnataka | 7213 | 89 | 4135 | 2989 | 14.705179999999999 | 76.166436 | 2020-06-16 04:33:09 | Karnataka, India | ||
1837112 | 1837112 | 2020-06-14 | India | Karnataka | 6824 | 81 | 3648 | 3095 | 14.705179999999999 | 76.166436 | 2020-06-15 03:33:14 | Karnataka, India | ||
3061164 | 3061164 | 2020-06-13 | India | Karnataka | 6516 | 79 | 3440 | 2997 | 14.705179999999999 | 76.166436 | 2020-06-14 03:33:15 | Karnataka, India | ||
737484 | 737484 | 2020-06-12 | India | Karnataka | 6245 | 72 | 2977 | 3196 | 14.705179999999999 | 76.166436 | 2020-06-13 03:33:14 | Karnataka, India | ||
1273454 | 1273454 | 2020-06-11 | India | Karnataka | 6245 | 72 | 2977 | 3196 | 14.705179999999999 | 76.166436 | 2020-06-12 05:09:52 | Karnataka, India | ||
2863897 | 2863897 | 2020-06-10 | India | Karnataka | 5921 | 66 | 2604 | 3251 | 14.70518 | 76.166436 | 2020-06-11 03:33:41 | Karnataka, 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]);