daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Telangana" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-18 | India | Telangana | 169169 | 1025 | 137508 | 30636 | 18.1124 | 79.0193 | 2020-09-19 04:22:00 | Telangana, India | ||
2020-09-19 | India | Telangana | 171306 | 1033 | 139700 | 30573 | 18.1124 | 79.0193 | 2020-09-20 04:22:00 | Telangana, India | ||
2020-09-20 | India | Telangana | 172608 | 1042 | 141930 | 29636 | 18.1124 | 79.0193 | 2020-09-21 04:23:00 | Telangana, India | ||
2020-09-21 | India | Telangana | 174774 | 1052 | 144073 | 29649 | 18.1124 | 79.0193 | 2020-09-22 04:23:00 | Telangana, India | ||
2020-09-22 | India | Telangana | 177070 | 1062 | 146135 | 29873 | 18.1124 | 79.0193 | 2020-09-23 04:23:00 | Telangana, India | ||
2020-09-23 | India | Telangana | 179246 | 1070 | 148139 | 30037 | 18.1124 | 79.0193 | 2020-09-24 04:23:00 | Telangana, India | ||
2020-09-24 | India | Telangana | 181627 | 1080 | 150160 | 30387 | 18.1124 | 79.0193 | 2020-09-25 04:23:00 | Telangana, India | ||
2020-09-25 | India | Telangana | 183866 | 1091 | 152441 | 30334 | 18.1124 | 79.0193 | 2020-09-26 04:23:00 | Telangana, India | ||
2020-09-26 | India | Telangana | 185833 | 1100 | 154499 | 30234 | 18.1124 | 79.0193 | 2020-09-27 04:23:00 | Telangana, India | ||
2020-09-27 | India | Telangana | 187211 | 1107 | 156431 | 29673 | 18.1124 | 79.0193 | 2020-09-28 04:23:00 | Telangana, India | ||
2020-09-28 | India | Telangana | 189283 | 1116 | 158690 | 29477 | 18.1124 | 79.0193 | 2020-09-29 04:23:42 | Telangana, India | ||
2020-09-29 | India | Telangana | 191386 | 1127 | 160933 | 29326 | 18.1124 | 79.0193 | 2020-09-30 04:23:33 | Telangana, India | ||
2020-09-30 | India | Telangana | 193600 | 1135 | 163407 | 29058 | 18.1124 | 79.0193 | 2020-10-01 04:23:42 | Telangana, India | ||
2020-10-01 | India | Telangana | 195609 | 1145 | 165844 | 28620 | 18.1124 | 79.0193 | 2020-10-02 04:23:51 | Telangana, India | ||
2020-10-02 | India | Telangana | 197327 | 1153 | 167846 | 28328 | 18.1124 | 79.0193 | 2020-10-03 04:23:40 | Telangana, India | ||
2020-10-03 | India | Telangana | 199276 | 1163 | 170212 | 27901 | 18.1124 | 79.0193 | 2020-10-04 04:23:44 | Telangana, India | ||
2020-10-04 | India | Telangana | 200611 | 1171 | 172388 | 27052 | 18.1124 | 79.0193 | 2020-10-05 04:23:33 | Telangana, India | ||
2020-10-05 | India | Telangana | 202594 | 1181 | 174769 | 26644 | 18.1124 | 79.0193 | 2020-10-06 04:23:33 | Telangana, India | ||
2020-10-06 | India | Telangana | 204748 | 1189 | 177008 | 26551 | 18.1124 | 79.0193 | 2020-10-07 04:23:40 | Telangana, India | ||
2020-10-07 | India | Telangana | 206644 | 1201 | 179075 | 26368 | 18.1124 | 79.0193 | 2020-10-08 04:23:56 | Telangana, India | ||
2020-10-08 | India | Telangana | 208535 | 1208 | 180953 | 26374 | 18.1124 | 79.0193 | 2020-10-09 04:23:59 | Telangana, India | ||
2020-10-09 | India | Telangana | 210346 | 1217 | 183025 | 26104 | 18.1124 | 79.0193 | 2020-10-10 04:23:57 | Telangana, India | ||
2020-10-10 | India | Telangana | 212063 | 1222 | 185128 | 25713 | 18.1124 | 79.0193 | 2020-10-11 04:23:46 | Telangana, India | ||
2020-10-11 | India | Telangana | 213084 | 1228 | 187342 | 24514 | 18.1124 | 79.0193 | 2020-10-12 04:23:45 | Telangana, India | ||
2020-10-12 | India | Telangana | 214792 | 1233 | 189351 | 24208 | 18.1124 | 79.0193 | 2020-10-13 04:24:02 | Telangana, India | ||
2020-10-13 | India | Telangana | 216238 | 1241 | 191269 | 23728 | 18.1124 | 79.0193 | 2020-10-14 04:24:05 | Telangana, India | ||
2020-10-14 | India | Telangana | 217670 | 1249 | 193218 | 23203 | 18.1124 | 79.0193 | 2020-10-15 04:24:28 | Telangana, India | ||
2020-10-15 | India | Telangana | 219224 | 1256 | 194653 | 23315 | 18.1124 | 79.0193 | 2020-10-16 04:24:01 | Telangana, India | ||
2020-10-16 | India | Telangana | 220675 | 1265 | 196636 | 22774 | 18.1124 | 79.0193 | 2020-10-17 04:24:12 | Telangana, India | ||
2020-10-17 | India | Telangana | 222111 | 1271 | 198790 | 22050 | 18.1124 | 79.0193 | 2020-10-18 04:24:25 | Telangana, India | ||
2020-10-18 | India | Telangana | 223059 | 1275 | 200686 | 21098 | 18.1124 | 79.0193 | 2020-10-19 04:24:16 | Telangana, India | ||
2020-10-19 | India | Telangana | 224545 | 1282 | 202577 | 20686 | 18.1124 | 79.0193 | 2020-10-20 04:24:22 | Telangana, India | ||
2020-10-20 | India | Telangana | 226124 | 1287 | 204388 | 20449 | 18.1124 | 79.0193 | 2020-10-21 04:24:14 | Telangana, India | ||
2020-10-21 | India | Telangana | 227580 | 1292 | 206105 | 20183 | 18.1124 | 79.0193 | 2020-10-22 04:24:27 | Telangana, India | ||
2020-10-22 | India | Telangana | 229001 | 1298 | 207326 | 20377 | 18.1124 | 79.0193 | 2020-10-23 04:24:46 | Telangana, India | ||
2020-10-23 | India | Telangana | 230274 | 1303 | 209034 | 19937 | 18.1124 | 79.0193 | 2020-10-24 04:24:46 | Telangana, India | ||
2020-10-24 | India | Telangana | 231252 | 1307 | 210480 | 19465 | 18.1124 | 79.0193 | 2020-10-25 04:24:36 | Telangana, India | ||
2020-10-25 | India | Telangana | 231834 | 1311 | 211912 | 18611 | 18.1124 | 79.0193 | 2020-10-26 04:25:02 | Telangana, India | ||
2020-10-26 | India | Telangana | 232671 | 1315 | 213466 | 17890 | 18.1124 | 79.0193 | 2020-10-27 04:24:45 | Telangana, India | ||
2020-10-27 | India | Telangana | 234152 | 1319 | 214917 | 17916 | 18.1124 | 79.0193 | 2020-10-28 04:24:39 | Telangana, India | ||
2020-10-28 | India | Telangana | 235656 | 1324 | 216353 | 17979 | 18.1124 | 79.0193 | 2020-10-29 04:24:49 | Telangana, India | ||
2020-10-29 | India | Telangana | 237187 | 1330 | 217401 | 18456 | 18.1124 | 79.0193 | 2020-10-30 04:24:49 | Telangana, India | ||
2020-10-30 | India | Telangana | 238632 | 1336 | 218887 | 18409 | 18.1124 | 79.0193 | 2020-10-31 04:24:44 | Telangana, India | ||
2020-10-31 | India | Telangana | 240048 | 1341 | 220466 | 18241 | 18.1124 | 79.0193 | 2020-11-01 04:36:19 | Telangana, India | ||
2020-11-01 | India | Telangana | 240970 | 1348 | 221992 | 17630 | 18.1124 | 79.0193 | 2020-11-02 05:25:04 | Telangana, India | ||
2020-11-02 | India | Telangana | 242506 | 1351 | 223413 | 17742 | 18.1124 | 79.0193 | 2020-11-03 06:00:16 | Telangana, India | ||
2020-11-03 | India | Telangana | 244143 | 1357 | 224686 | 18100 | 18.1124 | 79.0193 | 2020-11-04 05:25:09 | Telangana, India | ||
2020-11-04 | India | Telangana | 245682 | 1362 | 225664 | 18656 | 18.1124 | 79.0193 | 2020-11-05 06:05:03 | Telangana, India | ||
2020-11-05 | India | Telangana | 247284 | 1366 | 226646 | 19272 | 18.1124 | 79.0193 | 2020-11-06 05:24:55 | Telangana, India | ||
2020-11-06 | India | Telangana | 248891 | 1372 | 227583 | 19936 | 18.1124 | 79.0193 | 2020-11-07 05:24:52 | Telangana, India | ||
2020-11-07 | India | Telangana | 250331 | 1377 | 229064 | 19890 | 18.1124 | 79.0193 | 2020-11-08 05:24:56 | Telangana, India | ||
2020-11-08 | India | Telangana | 251188 | 1381 | 230568 | 19239 | 18.1124 | 79.0193 | 2020-11-09 05:25:45 | Telangana, India | ||
2020-11-09 | India | Telangana | 252455 | 1385 | 232489 | 18581 | 18.1124 | 79.0193 | 2020-11-10 05:40:07 | Telangana, India | ||
2020-11-10 | India | Telangana | 253651 | 1390 | 234234 | 18027 | 18.1124 | 79.0193 | 2020-11-11 05:25:30 | Telangana, India | ||
2020-11-11 | India | Telangana | 254666 | 1393 | 235950 | 17323 | 18.1124 | 79.0193 | 2020-11-12 05:25:55 | Telangana, India | ||
2020-11-12 | India | Telangana | 255663 | 1397 | 237172 | 17094 | 18.1124 | 79.0193 | 2020-11-13 05:25:30 | Telangana, India | ||
2020-11-13 | India | Telangana | 256713 | 1401 | 238908 | 16404 | 18.1124 | 79.0193 | 2020-11-14 05:25:37 | Telangana, India | ||
2020-11-14 | India | Telangana | 257374 | 1404 | 240545 | 15425 | 18.1124 | 79.0193 | 2020-11-15 05:26:53 | Telangana, India | ||
2020-11-15 | India | Telangana | 257876 | 1407 | 242084 | 14385 | 18.1124 | 79.0193 | 2020-11-16 05:25:57 | Telangana, India | ||
2020-11-16 | India | Telangana | 258828 | 1410 | 243686 | 13732 | 18.1124 | 79.0193 | 2020-11-17 05:25:54 | Telangana, India | ||
2020-11-17 | India | Telangana | 259776 | 1415 | 245293 | 13068 | 18.1124 | 79.0193 | 2020-11-18 05:40:31 | Telangana, India | ||
2020-11-18 | India | Telangana | 260834 | 1419 | 246733 | 12682 | 18.1124 | 79.0193 | 2020-11-19 05:25:23 | Telangana, India | ||
2020-11-19 | India | Telangana | 261728 | 1423 | 247790 | 12515 | 18.1124 | 79.0193 | 2020-11-20 05:26:28 | Telangana, India | ||
2020-11-20 | India | Telangana | 262653 | 1426 | 249157 | 12070 | 18.1124 | 79.0193 | 2020-11-21 05:25:51 | Telangana, India | ||
2020-11-21 | India | Telangana | 263526 | 1430 | 250453 | 11643 | 18.1124 | 79.0193 | 2020-11-22 05:25:45 | Telangana, India | ||
2020-11-22 | India | Telangana | 264128 | 1433 | 251468 | 11227 | 18.1124 | 79.0193 | 2020-11-23 05:25:26 | Telangana, India | ||
2020-11-23 | India | Telangana | 265049 | 1437 | 252565 | 11047 | 18.1124 | 79.0193 | 2020-11-24 05:27:31 | Telangana, India | ||
2020-11-24 | India | Telangana | 266042 | 1441 | 253715 | 10886 | 18.1124 | 79.0193 | 2020-11-25 05:27:20 | Telangana, India | ||
2020-11-25 | India | Telangana | 266904 | 1444 | 254676 | 10784 | 18.1124 | 79.0193 | 2020-11-26 05:27:44 | Telangana, India | ||
2020-11-26 | India | Telangana | 267665 | 1448 | 255378 | 10839 | 18.1124 | 79.0193 | 2020-11-27 05:26:53 | Telangana, India | ||
2020-11-27 | India | Telangana | 268418 | 1451 | 256330 | 10637 | 18.1124 | 79.0193 | 2020-11-28 05:25:50 | Telangana, India | ||
2020-11-28 | India | Telangana | 269223 | 1455 | 257278 | 10490 | 18.1124 | 79.0193 | 2020-11-29 05:25:55 | Telangana, India | ||
2020-11-29 | India | Telangana | 269816 | 1458 | 258336 | 10022 | 18.1124 | 79.0193 | 2020-11-30 05:26:13 | Telangana, India | ||
2020-11-30 | India | Telangana | 270318 | 1461 | 259230 | 9627 | 18.1124 | 79.0193 | 2020-12-01 05:26:18 | Telangana, India | ||
2020-12-01 | India | Telangana | 270883 | 1462 | 260155 | 9266 | 18.1124 | 79.0193 | 2020-12-02 05:27:41 | Telangana, India | ||
2020-12-02 | India | Telangana | 271492 | 1465 | 261028 | 8999 | 18.1124 | 79.0193 | 2020-12-03 05:28:22 | Telangana, India | ||
2020-12-03 | India | Telangana | 272123 | 1467 | 261830 | 8826 | 18.1124 | 79.0193 | 2020-12-04 05:27:27 | Telangana, India | ||
2020-12-04 | India | Telangana | 272719 | 1470 | 262751 | 8498 | 18.1124 | 79.0193 | 2020-12-05 05:27:36 | Telangana, India | ||
2020-12-05 | India | Telangana | 273341 | 1472 | 263744 | 8125 | 18.1124 | 79.0193 | 2020-12-06 05:26:18 | Telangana, India | ||
2020-12-06 | India | Telangana | 273858 | 1474 | 264606 | 7778 | 18.1124 | 79.0193 | 2020-12-07 05:26:14 | Telangana, India | ||
2020-12-07 | India | Telangana | 274540 | 1477 | 265367 | 7696 | 18.1124 | 79.0193 | 2020-12-08 05:27:42 | Telangana, India | ||
2020-12-08 | India | Telangana | 275261 | 1480 | 266120 | 7661 | 18.1124 | 79.0193 | 2020-12-09 05:28:01 | Telangana, India | ||
2020-12-09 | India | Telangana | 275904 | 1482 | 266925 | 7497 | 18.1124 | 79.0193 | 2020-12-10 05:26:19 | Telangana, India | ||
2020-12-10 | India | Telangana | 276516 | 1485 | 267427 | 7604 | 18.1124 | 79.0193 | 2020-12-11 05:26:59 | Telangana, India | ||
2020-12-11 | India | Telangana | 277151 | 1489 | 267992 | 7670 | 18.1124 | 79.0193 | 2020-12-12 05:26:19 | Telangana, India | ||
2020-12-12 | India | Telangana | 277724 | 1493 | 268601 | 7630 | 18.1124 | 79.0193 | 2020-12-13 05:27:20 | Telangana, India | ||
2020-12-13 | India | Telangana | 278108 | 1496 | 269232 | 7380 | 18.1124 | 79.0193 | 2020-12-14 05:26:27 | Telangana, India | ||
2020-12-14 | India | Telangana | 278599 | 1499 | 269828 | 7272 | 18.1124 | 79.0193 | 2020-12-15 05:26:38 | Telangana, India | ||
2020-12-15 | India | Telangana | 279135 | 1502 | 270450 | 7183 | 18.1124 | 79.0193 | 2020-12-16 05:28:04 | Telangana, India | ||
2020-12-16 | India | Telangana | 279644 | 1505 | 270967 | 7172 | 18.1124 | 79.0193 | 2020-12-17 05:28:12 | Telangana, India | ||
2020-12-17 | India | Telangana | 280195 | 1506 | 271649 | 7040 | 18.1124 | 79.0193 | 2020-12-18 05:28:18 | Telangana, India | ||
2020-12-18 | India | Telangana | 280822 | 1510 | 272370 | 6942 | 18.1124 | 79.0193 | 2020-12-19 05:27:52 | Telangana, India | ||
2020-12-19 | India | Telangana | 281414 | 1513 | 273013 | 6888 | 18.1124 | 79.0193 | 2020-12-20 05:27:32 | Telangana, India | ||
2020-12-20 | India | Telangana | 281730 | 1515 | 273625 | 6590 | 18.1124 | 79.0193 | 2020-12-21 05:27:58 | Telangana, India | ||
2020-12-21 | India | Telangana | 282347 | 1518 | 274260 | 6569 | 18.1124 | 79.0193 | 2020-12-22 05:22:33 | Telangana, India | ||
2020-12-22 | India | Telangana | 282982 | 1522 | 274833 | 6627 | 18.1124 | 79.0193 | 2020-12-23 05:22:03 | Telangana, India | ||
2020-12-23 | India | Telangana | 283556 | 1524 | 275217 | 6815 | 18.1124 | 79.0193 | 2020-12-24 05:23:04 | Telangana, India | ||
2020-12-24 | India | Telangana | 284074 | 1527 | 275708 | 6839 | 18.1124 | 79.0193 | 2020-12-25 05:22:48 | Telangana, India | ||
2020-12-25 | India | Telangana | 284391 | 1529 | 276244 | 6618 | 18.1124 | 79.0193 | 2020-12-26 05:22:28 | Telangana, India | ||
2020-12-26 | India | Telangana | 284863 | 1531 | 276753 | 6579 | 18.1124 | 79.0193 | 2020-12-27 05:22:55 | Telangana, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;