daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Karnataka" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | India | Karnataka | 2996833 | 38216 | 0 | 14.705179999999999 | 76.166436 | 2021-12-03 04:23:05 | Karnataka, India | |||
2021-10-28 | India | Karnataka | 2987313 | 38054 | 0 | 14.705179999999999 | 76.166436 | 2021-10-29 04:22:03 | Karnataka, India | |||
2021-09-18 | India | Karnataka | 2967083 | 37587 | 0 | 14.705179999999999 | 76.166436 | 2021-09-19 04:21:34 | Karnataka, India | |||
2022-03-20 | India | Karnataka | 3944714 | 40037 | 0 | 14.705179999999999 | 76.166436 | 2022-03-21 04:20:50 | Karnataka, India | |||
2021-11-11 | India | Karnataka | 2991142 | 38138 | 0 | 14.705179999999999 | 76.166436 | 2021-11-12 04:22:01 | Karnataka, India | |||
2021-08-25 | India | Karnataka | 2942250 | 37206 | 0 | 14.705179999999999 | 76.166436 | 2021-08-26 04:21:28 | Karnataka, India | |||
2021-11-02 | India | Karnataka | 2988760 | 38089 | 0 | 14.705179999999999 | 76.166436 | 2021-11-03 06:22:09 | Karnataka, India | |||
2021-09-01 | India | Karnataka | 2950604 | 37339 | 0 | 14.705179999999999 | 76.166436 | 2021-09-02 04:21:15 | Karnataka, India | |||
2022-02-07 | India | Karnataka | 3902309 | 39396 | 0 | 14.705179999999999 | 76.166436 | 2022-02-08 04:21:15 | Karnataka, India | |||
2021-11-09 | India | Karnataka | 2990528 | 38122 | 0 | 14.705179999999999 | 76.166436 | 2021-11-10 04:21:38 | Karnataka, India | |||
2022-01-14 | India | Karnataka | 3153247 | 38411 | 0 | 14.705179999999999 | 76.166436 | 2022-01-15 04:21:07 | Karnataka, India | |||
2021-08-15 | India | Karnataka | 2929464 | 36979 | 0 | 14.705179999999999 | 76.166436 | 2021-08-16 04:21:31 | Karnataka, India | |||
2020-07-19 | India | Karnataka | 63772 | 1331 | 23065 | 39376 | 14.705179999999999 | 76.166436 | 2020-07-20 05:34:40 | Karnataka, India | ||
2022-01-09 | India | Karnataka | 3051958 | 38370 | 0 | 14.705179999999999 | 76.166436 | 2022-01-10 04:22:07 | Karnataka, India | |||
2021-12-04 | India | Karnataka | 2997246 | 38220 | 0 | 14.705179999999999 | 76.166436 | 2021-12-05 04:22:25 | Karnataka, India | |||
2021-11-29 | India | Karnataka | 2995857 | 38203 | 0 | 14.705179999999999 | 76.166436 | 2021-11-30 04:22:53 | Karnataka, India | |||
2022-03-29 | India | Karnataka | 3945401 | 40052 | 0 | 14.705179999999999 | 76.166436 | 2022-03-30 04:20:45 | Karnataka, India | |||
2021-11-19 | India | Karnataka | 2993139 | 38169 | 0 | 14.705179999999999 | 76.166436 | 2021-11-20 04:22:17 | Karnataka, India | |||
2021-09-02 | India | Karnataka | 2951844 | 37361 | 0 | 14.705179999999999 | 76.166436 | 2021-09-03 04:21:20 | Karnataka, India | |||
2022-02-13 | India | Karnataka | 3926669 | 39640 | 0 | 14.705179999999999 | 76.166436 | 2022-02-14 04:20:51 | Karnataka, India | |||
2022-02-11 | India | Karnataka | 3921095 | 39575 | 0 | 14.705179999999999 | 76.166436 | 2022-02-12 04:21:06 | Karnataka, India | |||
2021-08-17 | India | Karnataka | 2931827 | 37039 | 0 | 14.705179999999999 | 76.166436 | 2021-08-18 04:21:35 | Karnataka, India | |||
2021-09-04 | India | Karnataka | 2954047 | 37401 | 0 | 14.705179999999999 | 76.166436 | 2021-09-05 04:21:33 | Karnataka, India | |||
2022-03-15 | India | Karnataka | 3944041 | 40024 | 0 | 14.705179999999999 | 76.166436 | 2022-03-16 04:20:50 | Karnataka, India | |||
2021-11-03 | India | Karnataka | 2989014 | 38091 | 0 | 14.705179999999999 | 76.166436 | 2021-11-04 04:22:20 | Karnataka, India | |||
2020-06-15 | India | Karnataka | 7213 | 89 | 4135 | 2989 | 14.705179999999999 | 76.166436 | 2020-06-16 04:33:09 | Karnataka, India | ||
2021-10-31 | India | Karnataka | 2988333 | 38082 | 0 | 14.705179999999999 | 76.166436 | 2021-11-01 04:22:01 | Karnataka, India | |||
2020-07-01 | India | Karnataka | 16514 | 253 | 8063 | 8198 | 14.705179999999999 | 76.166436 | 2020-07-02 04:33:46 | Karnataka, India | ||
2022-04-16 | India | Karnataka | 3946315 | 40057 | 0 | 14.705179999999999 | 76.166436 | 2022-04-17 04:20:59 | Karnataka, India | |||
2022-02-12 | India | Karnataka | 3924297 | 39613 | 0 | 14.705179999999999 | 76.166436 | 2022-02-13 04:21:00 | Karnataka, India | |||
2020-07-20 | India | Karnataka | 67420 | 1403 | 23795 | 42222 | 14.705179999999999 | 76.166436 | 2020-07-21 04:38:46 | Karnataka, India | ||
2022-03-18 | India | Karnataka | 3944432 | 40033 | 0 | 14.705179999999999 | 76.166436 | 2022-03-19 04:20:47 | Karnataka, India | |||
2022-03-11 | India | Karnataka | 3943506 | 40016 | 0 | 14.705179999999999 | 76.166436 | 2022-03-12 04:20:50 | Karnataka, India | |||
2021-12-07 | India | Karnataka | 2998699 | 38243 | 0 | 14.705179999999999 | 76.166436 | 2021-12-08 04:22:46 | Karnataka, India | |||
2020-07-05 | India | Karnataka | 23474 | 372 | 9847 | 13255 | 14.705179999999999 | 76.166436 | 2020-07-06 04:33:57 | Karnataka, India | ||
2021-10-10 | India | Karnataka | 2981027 | 37885 | 0 | 14.705179999999999 | 76.166436 | 2021-10-11 04:21:31 | Karnataka, India | |||
2021-10-20 | India | Karnataka | 2984484 | 37976 | 0 | 14.705179999999999 | 76.166436 | 2021-10-21 04:21:18 | Karnataka, India | |||
2021-11-17 | India | Karnataka | 2992584 | 38161 | 0 | 14.705179999999999 | 76.166436 | 2021-11-18 04:21:33 | Karnataka, India | |||
2022-02-02 | India | Karnataka | 3844338 | 39137 | 0 | 14.705179999999999 | 76.166436 | 2022-02-03 04:21:21 | Karnataka, India | |||
2021-10-07 | India | Karnataka | 2979773 | 37861 | 0 | 14.705179999999999 | 76.166436 | 2021-10-08 04:21:25 | Karnataka, India | |||
2021-10-14 | India | Karnataka | 2982399 | 37922 | 0 | 14.705179999999999 | 76.166436 | 2021-10-15 04:21:26 | Karnataka, India | |||
2021-11-06 | India | Karnataka | 2989713 | 38107 | 0 | 14.705179999999999 | 76.166436 | 2021-11-07 04:21:53 | Karnataka, India | |||
2022-04-02 | India | Karnataka | 3945610 | 40054 | 0 | 14.705179999999999 | 76.166436 | 2022-04-03 04:20:48 | Karnataka, India | |||
2021-08-14 | India | Karnataka | 2928033 | 36958 | 0 | 14.705179999999999 | 76.166436 | 2021-08-15 04:21:41 | Karnataka, India | |||
2021-08-19 | India | Karnataka | 2934624 | 37088 | 0 | 14.705179999999999 | 76.166436 | 2021-08-20 04:21:33 | Karnataka, India | |||
2020-07-04 | India | Karnataka | 21549 | 335 | 9244 | 11970 | 14.705179999999999 | 76.166436 | 2020-07-05 04:33:46 | Karnataka, India | ||
2021-10-27 | India | Karnataka | 2986835 | 38037 | 0 | 14.705179999999999 | 76.166436 | 2021-10-28 04:22:08 | Karnataka, India | |||
2021-12-08 | India | Karnataka | 2999098 | 38249 | 0 | 14.705179999999999 | 76.166436 | 2021-12-09 04:22:49 | Karnataka, India | |||
2022-01-16 | India | Karnataka | 3220087 | 38431 | 0 | 14.705179999999999 | 76.166436 | 2022-01-17 04:21:08 | Karnataka, India | |||
2021-10-29 | India | Karnataka | 2987694 | 38061 | 0 | 14.705179999999999 | 76.166436 | 2021-10-30 04:22:03 | Karnataka, India | |||
2022-02-25 | India | Karnataka | 3939915 | 39900 | 0 | 14.705179999999999 | 76.166436 | 2022-02-26 04:21:12 | Karnataka, India | |||
2021-10-19 | India | Karnataka | 2984022 | 37967 | 0 | 14.705179999999999 | 76.166436 | 2021-10-20 04:21:00 | Karnataka, India | |||
2021-09-23 | India | Karnataka | 2971044 | 37683 | 0 | 14.705179999999999 | 76.166436 | 2021-09-24 04:21:44 | Karnataka, India | |||
2021-10-13 | India | Karnataka | 2982089 | 37916 | 0 | 14.705179999999999 | 76.166436 | 2021-10-14 04:21:29 | Karnataka, India | |||
2021-09-07 | India | Karnataka | 2956988 | 37441 | 0 | 14.705179999999999 | 76.166436 | 2021-09-08 04:21:31 | Karnataka, India | |||
2021-08-09 | India | Karnataka | 2919711 | 36817 | 0 | 14.705179999999999 | 76.166436 | 2021-08-10 04:21:27 | Karnataka, India | |||
2021-10-22 | India | Karnataka | 2985227 | 37995 | 0 | 14.705179999999999 | 76.166436 | 2021-10-23 04:21:32 | Karnataka, India | |||
2021-10-24 | India | Karnataka | 2985986 | 38007 | 0 | 14.705179999999999 | 76.166436 | 2021-10-25 04:22:31 | Karnataka, India | |||
2021-11-13 | India | Karnataka | 2991614 | 38143 | 0 | 14.705179999999999 | 76.166436 | 2021-11-14 04:21:31 | Karnataka, India | |||
2022-03-17 | India | Karnataka | 3944326 | 40028 | 0 | 14.705179999999999 | 76.166436 | 2022-03-18 04:20:55 | Karnataka, India | |||
2021-11-04 | India | Karnataka | 2989275 | 38095 | 0 | 14.705179999999999 | 76.166436 | 2021-11-05 04:21:54 | Karnataka, India | |||
2021-09-29 | India | Karnataka | 2975067 | 37780 | 0 | 14.705179999999999 | 76.166436 | 2021-09-30 04:21:20 | Karnataka, India | |||
2021-11-12 | India | Karnataka | 2991369 | 38140 | 0 | 14.705179999999999 | 76.166436 | 2021-11-13 04:21:38 | Karnataka, India | |||
2021-11-20 | India | Karnataka | 2993352 | 38174 | 0 | 14.705179999999999 | 76.166436 | 2021-11-21 04:22:13 | Karnataka, India | |||
2021-12-27 | India | Karnataka | 3004876 | 38316 | 0 | 14.705179999999999 | 76.166436 | 2021-12-28 04:21:47 | Karnataka, India | |||
2020-06-12 | India | Karnataka | 6245 | 72 | 2977 | 3196 | 14.705179999999999 | 76.166436 | 2020-06-13 03:33:14 | Karnataka, India | ||
2022-04-23 | India | Karnataka | 3946874 | 40057 | 0 | 14.705179999999999 | 76.166436 | 2022-04-24 04:20:56 | Karnataka, India | |||
2021-11-26 | India | Karnataka | 2994963 | 38193 | 0 | 14.705179999999999 | 76.166436 | 2021-11-27 04:22:45 | Karnataka, India | |||
2021-10-23 | India | Karnataka | 2985598 | 38002 | 0 | 14.705179999999999 | 76.166436 | 2021-10-24 04:21:22 | Karnataka, India | |||
2021-12-13 | India | Karnataka | 3000671 | 38268 | 0 | 14.705179999999999 | 76.166436 | 2021-12-14 04:22:38 | Karnataka, India | |||
2021-12-22 | India | Karnataka | 3003265 | 38299 | 0 | 14.705179999999999 | 76.166436 | 2021-12-23 04:21:21 | Karnataka, India | |||
2021-09-20 | India | Karnataka | 2968543 | 37627 | 0 | 14.705179999999999 | 76.166436 | 2021-09-21 04:21:26 | Karnataka, India | |||
2022-03-27 | India | Karnataka | 3945311 | 40050 | 0 | 14.705179999999999 | 76.166436 | 2022-03-28 04:20:33 | Karnataka, India | |||
2020-07-07 | India | Karnataka | 26815 | 416 | 11098 | 15301 | 14.705179999999999 | 76.166436 | 2020-07-08 05:33:48 | Karnataka, India | ||
2021-11-24 | India | Karnataka | 2994255 | 38185 | 0 | 14.705179999999999 | 76.166436 | 2021-11-25 04:22:33 | Karnataka, India | |||
2022-03-08 | India | Karnataka | 3942927 | 40004 | 0 | 14.705179999999999 | 76.166436 | 2022-03-09 04:20:59 | Karnataka, India | |||
2021-10-16 | India | Karnataka | 2983133 | 37937 | 0 | 14.705179999999999 | 76.166436 | 2021-10-17 04:21:29 | Karnataka, India | |||
2022-02-28 | India | Karnataka | 3941063 | 39950 | 0 | 14.705179999999999 | 76.166436 | 2022-03-01 04:21:09 | Karnataka, India | |||
2022-03-12 | India | Karnataka | 3943642 | 40018 | 0 | 14.705179999999999 | 76.166436 | 2022-03-13 04:20:49 | Karnataka, India | |||
2022-02-01 | India | Karnataka | 3823833 | 39056 | 0 | 14.705179999999999 | 76.166436 | 2022-02-02 04:21:09 | Karnataka, India | |||
2021-10-04 | India | Karnataka | 2978286 | 37832 | 0 | 14.705179999999999 | 76.166436 | 2021-10-05 04:21:27 | Karnataka, India | |||
2020-07-09 | India | Karnataka | 31105 | 486 | 12833 | 17786 | 14.705179999999999 | 76.166436 | 2020-07-10 04:34:24 | Karnataka, India | ||
2021-11-21 | India | Karnataka | 2993599 | 38175 | 0 | 14.705179999999999 | 76.166436 | 2021-11-22 04:22:20 | Karnataka, India | |||
2021-12-06 | India | Karnataka | 2998400 | 38237 | 0 | 14.705179999999999 | 76.166436 | 2021-12-07 04:22:34 | Karnataka, India | |||
2022-02-23 | India | Karnataka | 3938699 | 39866 | 0 | 14.705179999999999 | 76.166436 | 2022-02-24 04:21:14 | Karnataka, India | |||
2021-12-09 | India | Karnataka | 2999471 | 38253 | 0 | 14.705179999999999 | 76.166436 | 2021-12-10 04:22:28 | Karnataka, India | |||
2022-01-11 | India | Karnataka | 3063656 | 38374 | 0 | 14.705179999999999 | 76.166436 | 2022-01-12 04:21:44 | Karnataka, India | |||
2020-06-26 | India | Karnataka | 11005 | 180 | 6916 | 3909 | 14.705179999999999 | 76.166436 | 2020-06-27 04:33:35 | Karnataka, India | ||
2022-01-23 | India | Karnataka | 3517682 | 38582 | 0 | 14.705179999999999 | 76.166436 | 2022-01-24 04:21:12 | Karnataka, India | |||
2021-12-01 | India | Karnataka | 2996470 | 38213 | 0 | 14.705179999999999 | 76.166436 | 2021-12-02 04:22:37 | Karnataka, India | |||
2020-06-17 | India | Karnataka | 7734 | 102 | 4804 | 2828 | 14.705179999999999 | 76.166436 | 2020-06-18 04:33:18 | Karnataka, India | ||
2022-01-08 | India | Karnataka | 3039958 | 38366 | 0 | 14.705179999999999 | 76.166436 | 2022-01-09 04:21:46 | Karnataka, India | |||
2022-04-14 | India | Karnataka | 3946221 | 40057 | 0 | 14.705179999999999 | 76.166436 | 2022-04-15 04:20:57 | Karnataka, India | |||
2022-01-24 | India | Karnataka | 3564108 | 38614 | 0 | 14.705179999999999 | 76.166436 | 2022-01-25 04:21:05 | Karnataka, India | |||
2021-11-28 | India | Karnataka | 2995600 | 38198 | 0 | 14.705179999999999 | 76.166436 | 2021-11-29 04:22:30 | Karnataka, India | |||
2021-09-27 | India | Karnataka | 2973899 | 37746 | 0 | 14.705179999999999 | 76.166436 | 2021-09-28 04:21:28 | Karnataka, India | |||
2021-12-20 | India | Karnataka | 3002649 | 38290 | 0 | 14.705179999999999 | 76.166436 | 2021-12-21 03:21:27 | Karnataka, India | |||
2021-12-18 | India | Karnataka | 3001792 | 38282 | 0 | 14.705179999999999 | 76.166436 | 2021-12-19 04:21:11 | Karnataka, India | |||
2021-09-09 | India | Karnataka | 2959164 | 37462 | 0 | 14.705179999999999 | 76.166436 | 2021-09-10 04:21:20 | Karnataka, India | |||
2020-06-11 | India | Karnataka | 6245 | 72 | 2977 | 3196 | 14.705179999999999 | 76.166436 | 2020-06-12 05:09:52 | Karnataka, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;