daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Ladakh" sorted by fips
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 | Ladakh | 21642 | 214 | 0 | 34.1526 | 77.5771 | 2021-12-03 04:23:05 | Ladakh, India | |||
2021-10-28 | India | Ladakh | 20930 | 208 | 0 | 34.1526 | 77.5771 | 2021-10-29 04:22:03 | Ladakh, India | |||
2020-10-25 | India | Ladakh | 5933 | 71 | 5126 | 736 | 34.1526 | 77.5771 | 2020-10-26 04:25:02 | Ladakh, India | ||
2021-01-26 | India | Ladakh | 9688 | 129 | 9508 | 51 | 34.1526 | 77.5771 | 2021-01-27 05:23:41 | Ladakh, India | ||
2021-09-18 | India | Ladakh | 20702 | 207 | 0 | 34.1526 | 77.5771 | 2021-09-19 04:21:34 | Ladakh, India | |||
2021-05-28 | India | Ladakh | 18310 | 187 | 16517 | 1606 | 34.1526 | 77.5771 | 2021-05-29 04:20:41 | Ladakh, India | ||
2022-03-20 | India | Ladakh | 28205 | 228 | 0 | 34.1526 | 77.5771 | 2022-03-21 04:20:50 | Ladakh, India | |||
2021-11-11 | India | Ladakh | 21098 | 209 | 0 | 34.1526 | 77.5771 | 2021-11-12 04:22:01 | Ladakh, India | |||
2021-08-25 | India | Ladakh | 20515 | 207 | 0 | 34.1526 | 77.5771 | 2021-08-26 04:21:28 | Ladakh, India | |||
2021-04-12 | India | Ladakh | 10905 | 131 | 10053 | 721 | 34.1526 | 77.5771 | 2021-04-13 04:20:37 | Ladakh, India | ||
2021-11-02 | India | Ladakh | 20979 | 208 | 0 | 34.1526 | 77.5771 | 2021-11-03 06:22:09 | Ladakh, India | |||
2021-05-29 | India | Ladakh | 18448 | 187 | 16658 | 1603 | 34.1526 | 77.5771 | 2021-05-30 04:20:55 | Ladakh, India | ||
2021-03-07 | India | Ladakh | 9831 | 130 | 9657 | 44 | 34.1526 | 77.5771 | 2021-03-08 05:24:48 | Ladakh, India | ||
2020-07-23 | India | Ladakh | 1210 | 2 | 1025 | 183 | 34.1526 | 77.5771 | 2020-07-24 05:30:40 | Ladakh, India | ||
2022-11-12 | India | Ladakh | 29396 | 231 | 0 | 34.1526 | 77.5771 | 2022-11-13 04:21:14 | Ladakh, India | |||
2021-09-01 | India | Ladakh | 20567 | 207 | 0 | 34.1526 | 77.5771 | 2021-09-02 04:21:15 | Ladakh, India | |||
2022-02-07 | India | Ladakh | 26992 | 226 | 0 | 34.1526 | 77.5771 | 2022-02-08 04:21:15 | Ladakh, India | |||
2020-12-03 | India | Ladakh | 8691 | 119 | 7713 | 859 | 34.1526 | 77.5771 | 2020-12-04 05:27:27 | Ladakh, India | ||
2020-10-14 | India | Ladakh | 5304 | 64 | 4261 | 979 | 34.1526 | 77.5771 | 2020-10-15 04:24:28 | Ladakh, India | ||
2021-05-25 | India | Ladakh | 17810 | 179 | 16070 | 1561 | 34.1526 | 77.5771 | 2021-05-26 04:20:35 | Ladakh, India | ||
2021-11-09 | India | Ladakh | 21072 | 209 | 0 | 34.1526 | 77.5771 | 2021-11-10 04:21:38 | Ladakh, India | |||
2022-07-23 | India | Ladakh | 28750 | 228 | 0 | 34.1526 | 77.5771 | 2022-07-24 04:20:47 | Ladakh, India | |||
2020-08-04 | India | Ladakh | 1534 | 7 | 1127 | 400 | 34.1526 | 77.5771 | 2020-08-05 04:34:43 | Ladakh, India | ||
2022-01-14 | India | Ladakh | 23079 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-15 04:21:07 | Ladakh, India | |||
2021-08-15 | India | Ladakh | 20451 | 207 | 0 | 34.1526 | 77.5771 | 2021-08-16 04:21:31 | Ladakh, India | |||
2021-06-19 | India | Ladakh | 19783 | 201 | 19150 | 432 | 34.1526 | 77.5771 | 2021-06-20 04:21:48 | Ladakh, India | ||
2022-09-06 | India | Ladakh | 29254 | 230 | 0 | 34.1526 | 77.5771 | 2022-09-07 04:20:59 | Ladakh, India | |||
2020-07-19 | India | Ladakh | 1178 | 2 | 1003 | 173 | 34.1526 | 77.5771 | 2020-07-20 05:34:40 | Ladakh, India | ||
2020-11-18 | India | Ladakh | 7623 | 94 | 6605 | 924 | 34.1526 | 77.5771 | 2020-11-19 05:25:23 | Ladakh, India | ||
2022-01-09 | India | Ladakh | 22561 | 221 | 0 | 34.1526 | 77.5771 | 2022-01-10 04:22:07 | Ladakh, India | |||
2022-10-04 | India | Ladakh | 29345 | 231 | 0 | 34.1526 | 77.5771 | 2022-10-05 04:23:06 | Ladakh, India | |||
2021-12-04 | India | Ladakh | 21669 | 215 | 0 | 34.1526 | 77.5771 | 2021-12-05 04:22:25 | Ladakh, India | |||
2022-07-09 | India | Ladakh | 28561 | 228 | 0 | 34.1526 | 77.5771 | 2022-07-10 04:20:54 | Ladakh, India | |||
2020-08-15 | India | Ladakh | 1909 | 10 | 1307 | 592 | 34.1526 | 77.5771 | 2020-08-16 04:27:42 | Ladakh, India | ||
2021-11-29 | India | Ladakh | 21540 | 214 | 0 | 34.1526 | 77.5771 | 2021-11-30 04:22:53 | Ladakh, India | |||
2021-01-08 | India | Ladakh | 9600 | 127 | 9258 | 215 | 34.1526 | 77.5771 | 2021-01-09 05:22:18 | Ladakh, India | ||
2022-03-29 | India | Ladakh | 28222 | 228 | 0 | 34.1526 | 77.5771 | 2022-03-30 04:20:45 | Ladakh, India | |||
2021-11-19 | India | Ladakh | 21298 | 212 | 0 | 34.1526 | 77.5771 | 2021-11-20 04:22:17 | Ladakh, India | |||
2022-06-21 | India | Ladakh | 28328 | 228 | 0 | 34.1526 | 77.5771 | 2022-06-22 04:20:54 | Ladakh, India | |||
2021-04-16 | India | Ladakh | 11709 | 132 | 10214 | 1363 | 34.1526 | 77.5771 | 2021-04-17 04:20:40 | Ladakh, India | ||
2020-07-27 | India | Ladakh | 1306 | 4 | 1066 | 236 | 34.1526 | 77.5771 | 2020-07-28 04:58:43 | Ladakh, India | ||
2021-09-02 | India | Ladakh | 20573 | 207 | 0 | 34.1526 | 77.5771 | 2021-09-03 04:21:20 | Ladakh, India | |||
2021-02-21 | India | Ladakh | 9786 | 130 | 9617 | 39 | 34.1526 | 77.5771 | 2021-02-22 05:24:21 | Ladakh, India | ||
2022-02-13 | India | Ladakh | 27477 | 226 | 0 | 34.1526 | 77.5771 | 2022-02-14 04:20:51 | Ladakh, India | |||
2021-01-11 | India | Ladakh | 9621 | 127 | 9311 | 183 | 34.1526 | 77.5771 | 2021-01-12 05:22:15 | Ladakh, India | ||
2020-08-31 | India | Ladakh | 2681 | 34 | 1874 | 773 | 34.1526 | 77.5771 | 2020-09-01 04:28:31 | Ladakh, India | ||
2022-10-19 | India | Ladakh | 29377 | 231 | 0 | 34.1526 | 77.5771 | 2022-10-20 04:22:59 | Ladakh, India | |||
2020-12-25 | India | Ladakh | 9355 | 126 | 9020 | 209 | 34.1526 | 77.5771 | 2020-12-26 05:22:28 | Ladakh, India | ||
2020-08-19 | India | Ladakh | 2048 | 18 | 1397 | 633 | 34.1526 | 77.5771 | 2020-08-20 04:27:43 | Ladakh, India | ||
2020-10-29 | India | Ladakh | 6139 | 74 | 5438 | 627 | 34.1526 | 77.5771 | 2020-10-30 04:24:49 | Ladakh, India | ||
2022-12-26 | India | Ladakh | 29412 | 231 | 0 | 34.1526 | 77.5771 | 2022-12-27 04:21:07 | Ladakh, India | |||
2022-05-09 | India | Ladakh | 28249 | 228 | 0 | 34.1526 | 77.5771 | 2022-05-10 04:20:50 | Ladakh, India | |||
2022-05-31 | India | Ladakh | 28268 | 228 | 0 | 34.1526 | 77.5771 | 2022-06-01 04:20:55 | Ladakh, India | |||
2022-02-11 | India | Ladakh | 27339 | 226 | 0 | 34.1526 | 77.5771 | 2022-02-12 04:21:06 | Ladakh, India | |||
2021-01-18 | India | Ladakh | 9657 | 128 | 9448 | 81 | 34.1526 | 77.5771 | 2021-01-19 05:22:15 | Ladakh, India | ||
2021-04-02 | India | Ladakh | 10189 | 130 | 9781 | 278 | 34.1526 | 77.5771 | 2021-04-03 04:20:44 | Ladakh, India | ||
2021-08-17 | India | Ladakh | 20466 | 207 | 0 | 34.1526 | 77.5771 | 2021-08-18 04:21:35 | Ladakh, India | |||
2021-09-04 | India | Ladakh | 20578 | 207 | 0 | 34.1526 | 77.5771 | 2021-09-05 04:21:33 | Ladakh, India | |||
2022-09-08 | India | Ladakh | 29265 | 230 | 0 | 34.1526 | 77.5771 | 2022-09-09 04:21:11 | Ladakh, India | |||
2022-12-10 | India | Ladakh | 29407 | 231 | 0 | 34.1526 | 77.5771 | 2022-12-11 04:20:50 | Ladakh, India | |||
2022-03-15 | India | Ladakh | 28190 | 228 | 0 | 34.1526 | 77.5771 | 2022-03-16 04:20:50 | Ladakh, India | |||
2020-11-10 | India | Ladakh | 7063 | 85 | 6058 | 920 | 34.1526 | 77.5771 | 2020-11-11 05:25:30 | Ladakh, India | ||
2021-11-03 | India | Ladakh | 20995 | 208 | 0 | 34.1526 | 77.5771 | 2021-11-04 04:22:20 | Ladakh, India | |||
2021-02-24 | India | Ladakh | 9807 | 130 | 9624 | 53 | 34.1526 | 77.5771 | 2021-02-25 05:24:57 | Ladakh, India | ||
2020-06-15 | India | Ladakh | 555 | 1 | 82 | 472 | 34.1526 | 77.5771 | 2020-06-16 04:33:09 | Ladakh, India | ||
2021-10-31 | India | Ladakh | 20962 | 208 | 0 | 34.1526 | 77.5771 | 2021-11-01 04:22:01 | Ladakh, India | |||
2022-11-15 | India | Ladakh | 29397 | 231 | 0 | 34.1526 | 77.5771 | 2022-11-16 04:21:09 | Ladakh, India | |||
2021-07-15 | India | Ladakh | 20234 | 206 | 19920 | 108 | 34.1526 | 77.5771 | 2021-07-16 04:21:22 | Ladakh, India | ||
2020-07-01 | India | Ladakh | 990 | 1 | 694 | 295 | 34.1526 | 77.5771 | 2020-07-02 04:33:46 | Ladakh, India | ||
2022-04-16 | India | Ladakh | 28239 | 228 | 0 | 34.1526 | 77.5771 | 2022-04-17 04:20:59 | Ladakh, India | |||
2022-12-13 | India | Ladakh | 29407 | 231 | 0 | 34.1526 | 77.5771 | 2022-12-14 04:21:04 | Ladakh, India | |||
2022-11-13 | India | Ladakh | 29396 | 231 | 0 | 34.1526 | 77.5771 | 2022-11-14 04:21:09 | Ladakh, India | |||
2022-02-12 | India | Ladakh | 27400 | 226 | 0 | 34.1526 | 77.5771 | 2022-02-13 04:21:00 | Ladakh, India | |||
2022-10-30 | India | Ladakh | 29390 | 231 | 0 | 34.1526 | 77.5771 | 2022-10-31 04:21:36 | Ladakh, India | |||
2020-07-20 | India | Ladakh | 1195 | 2 | 1007 | 186 | 34.1526 | 77.5771 | 2020-07-21 04:38:46 | Ladakh, India | ||
2022-12-27 | India | Ladakh | 29412 | 231 | 0 | 34.1526 | 77.5771 | 2022-12-28 04:21:04 | Ladakh, India | |||
2021-08-04 | India | Ladakh | 20365 | 207 | 20091 | 67 | 34.1526 | 77.5771 | 2021-08-05 04:21:51 | Ladakh, India | ||
2022-03-18 | India | Ladakh | 28200 | 228 | 0 | 34.1526 | 77.5771 | 2022-03-19 04:20:47 | Ladakh, India | |||
2021-02-03 | India | Ladakh | 9735 | 130 | 9535 | 70 | 34.1526 | 77.5771 | 2021-02-04 05:22:26 | Ladakh, India | ||
2020-09-14 | India | Ladakh | 3345 | 40 | 2436 | 869 | 34.1526 | 77.5771 | 2020-09-15 03:22:50 | Ladakh, India | ||
2022-12-14 | India | Ladakh | 29407 | 231 | 0 | 34.1526 | 77.5771 | 2022-12-15 04:20:58 | Ladakh, India | |||
2021-03-11 | India | Ladakh | 9840 | 130 | 9669 | 41 | 34.1526 | 77.5771 | 2021-03-12 05:26:50 | Ladakh, India | ||
2022-03-11 | India | Ladakh | 28160 | 228 | 0 | 34.1526 | 77.5771 | 2022-03-12 04:20:50 | Ladakh, India | |||
2022-05-07 | India | Ladakh | 28248 | 228 | 0 | 34.1526 | 77.5771 | 2022-05-08 04:20:49 | Ladakh, India | |||
2020-07-16 | India | Ladakh | 1147 | 1 | 970 | 176 | 34.1526 | 77.5771 | 2020-07-17 04:34:50 | Ladakh, India | ||
2020-08-08 | India | Ladakh | 1639 | 9 | 1214 | 416 | 34.1526 | 77.5771 | 2020-08-09 04:34:54 | Ladakh, India | ||
2022-09-13 | India | Ladakh | 29294 | 230 | 0 | 34.1526 | 77.5771 | 2022-09-14 04:20:44 | Ladakh, India | |||
2020-11-06 | India | Ladakh | 6718 | 80 | 5854 | 784 | 34.1526 | 77.5771 | 2020-11-07 05:24:52 | Ladakh, India | ||
2021-04-30 | India | Ladakh | 13969 | 143 | 12376 | 1450 | 34.1526 | 77.5771 | 2021-05-01 04:20:47 | Ladakh, India | ||
2022-09-23 | India | Ladakh | 29323 | 231 | 0 | 34.1526 | 77.5771 | 2022-09-24 04:21:40 | Ladakh, India | |||
2021-04-04 | India | Ladakh | 10255 | 130 | 9802 | 323 | 34.1526 | 77.5771 | 2021-04-05 04:20:35 | Ladakh, India | ||
2020-11-27 | India | Ladakh | 8272 | 114 | 7254 | 904 | 34.1526 | 77.5771 | 2020-11-28 05:25:50 | Ladakh, India | ||
2022-10-07 | India | Ladakh | 29359 | 231 | 0 | 34.1526 | 77.5771 | 2022-10-08 04:22:56 | Ladakh, India | |||
2021-06-29 | India | Ladakh | 20038 | 202 | 19565 | 271 | 34.1526 | 77.5771 | 2021-06-30 04:21:41 | Ladakh, India | ||
2021-12-07 | India | Ladakh | 21735 | 215 | 0 | 34.1526 | 77.5771 | 2021-12-08 04:22:46 | Ladakh, India | |||
2021-07-28 | India | Ladakh | 20320 | 207 | 20049 | 64 | 34.1526 | 77.5771 | 2021-07-29 04:21:33 | Ladakh, India | ||
2020-07-05 | India | Ladakh | 1005 | 1 | 826 | 178 | 34.1526 | 77.5771 | 2020-07-06 04:33:57 | Ladakh, India | ||
2022-09-18 | India | Ladakh | 29308 | 230 | 0 | 34.1526 | 77.5771 | 2022-09-19 04:21:49 | Ladakh, India | |||
2021-10-10 | India | Ladakh | 20852 | 208 | 0 | 34.1526 | 77.5771 | 2021-10-11 04:21:31 | Ladakh, India | |||
2020-09-07 | India | Ladakh | 3064 | 35 | 2211 | 818 | 34.1526 | 77.5771 | 2020-09-08 04:28:25 | Ladakh, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;