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 = "Telangana" sorted by country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region ▼ | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
281 | 281 | 2021-12-02 | India | Telangana | 676376 | 3995 | 0 | 18.1124 | 79.0193 | 2021-12-03 04:23:05 | Telangana, India | |||
4297 | 4297 | 2021-10-28 | India | Telangana | 671000 | 3952 | 0 | 18.1124 | 79.0193 | 2021-10-29 04:22:03 | Telangana, India | |||
8299 | 8299 | 2020-10-25 | India | Telangana | 231834 | 1311 | 211912 | 18611 | 18.1124 | 79.0193 | 2020-10-26 04:25:02 | Telangana, India | ||
12307 | 12307 | 2021-01-26 | India | Telangana | 293737 | 1593 | 289325 | 2819 | 18.1124 | 79.0193 | 2021-01-27 05:23:41 | Telangana, India | ||
16322 | 16322 | 2021-09-18 | India | Telangana | 663281 | 3903 | 0 | 18.1124 | 79.0193 | 2021-09-19 04:21:34 | Telangana, India | |||
20337 | 20337 | 2021-05-28 | India | Telangana | 571044 | 3226 | 530025 | 37793 | 18.1124 | 79.0193 | 2021-05-29 04:20:41 | Telangana, India | ||
24352 | 24352 | 2022-03-20 | India | Telangana | 790791 | 4111 | 0 | 18.1124 | 79.0193 | 2022-03-21 04:20:50 | Telangana, India | |||
28367 | 28367 | 2021-11-11 | India | Telangana | 673140 | 3971 | 0 | 18.1124 | 79.0193 | 2021-11-12 04:22:01 | Telangana, India | |||
32383 | 32383 | 2021-08-25 | India | Telangana | 656098 | 3864 | 0 | 18.1124 | 79.0193 | 2021-08-26 04:21:28 | Telangana, India | |||
36397 | 36397 | 2021-04-12 | India | Telangana | 332581 | 1772 | 306678 | 24131 | 18.1124 | 79.0193 | 2021-04-13 04:20:37 | Telangana, India | ||
43659 | 43659 | 2021-11-02 | India | Telangana | 671790 | 3959 | 0 | 18.1124 | 79.0193 | 2021-11-03 06:22:09 | Telangana, India | |||
50758 | 50758 | 2021-05-29 | India | Telangana | 574026 | 3247 | 533862 | 36917 | 18.1124 | 79.0193 | 2021-05-30 04:20:55 | Telangana, India | ||
54772 | 54772 | 2021-03-07 | India | Telangana | 300011 | 1642 | 296562 | 1807 | 18.1124 | 79.0193 | 2021-03-08 05:24:48 | Telangana, India | ||
62156 | 62156 | 2020-07-23 | India | Telangana | 50826 | 447 | 39327 | 11052 | 18.1124 | 79.0193 | 2020-07-24 05:30:40 | Telangana, India | ||
63013 | 63013 | 2022-11-12 | India | Telangana | 840829 | 4111 | 0 | 18.1124 | 79.0193 | 2022-11-13 04:21:14 | Telangana, India | |||
67028 | 67028 | 2021-09-01 | India | Telangana | 658376 | 3876 | 0 | 18.1124 | 79.0193 | 2021-09-02 04:21:15 | Telangana, India | |||
71042 | 71042 | 2022-02-07 | India | Telangana | 778910 | 4101 | 0 | 18.1124 | 79.0193 | 2022-02-08 04:21:15 | Telangana, India | |||
75056 | 75056 | 2020-12-03 | India | Telangana | 272123 | 1467 | 261830 | 8826 | 18.1124 | 79.0193 | 2020-12-04 05:27:27 | Telangana, India | ||
79055 | 79055 | 2020-10-14 | India | Telangana | 217670 | 1249 | 193218 | 23203 | 18.1124 | 79.0193 | 2020-10-15 04:24:28 | Telangana, India | ||
83062 | 83062 | 2021-05-25 | India | Telangana | 560141 | 3169 | 518266 | 38706 | 18.1124 | 79.0193 | 2021-05-26 04:20:35 | Telangana, India | ||
87076 | 87076 | 2021-11-09 | India | Telangana | 672823 | 3968 | 0 | 18.1124 | 79.0193 | 2021-11-10 04:21:38 | Telangana, India | |||
91093 | 91093 | 2022-07-23 | India | Telangana | 813772 | 4111 | 0 | 18.1124 | 79.0193 | 2022-07-24 04:20:47 | Telangana, India | |||
98515 | 98515 | 2020-08-04 | India | Telangana | 70958 | 576 | 50814 | 19568 | 18.1124 | 79.0193 | 2020-08-05 04:34:43 | Telangana, India | ||
99277 | 99277 | 2022-01-14 | India | Telangana | 705199 | 4052 | 0 | 18.1124 | 79.0193 | 2022-01-15 04:21:07 | Telangana, India | |||
103293 | 103293 | 2021-08-15 | India | Telangana | 652380 | 3842 | 0 | 18.1124 | 79.0193 | 2021-08-16 04:21:31 | Telangana, India | |||
107418 | 107418 | 2021-06-19 | India | Telangana | 612196 | 3556 | 590072 | 18568 | 18.1124 | 79.0193 | 2021-06-20 04:21:48 | Telangana, India | ||
114703 | 114703 | 2022-09-06 | India | Telangana | 835337 | 4111 | 0 | 18.1124 | 79.0193 | 2022-09-07 04:20:59 | Telangana, India | |||
122107 | 122107 | 2020-07-19 | India | Telangana | 45076 | 415 | 32438 | 12223 | 18.1124 | 79.0193 | 2020-07-20 05:34:40 | Telangana, India | ||
122671 | 122671 | 2020-11-18 | India | Telangana | 260834 | 1419 | 246733 | 12682 | 18.1124 | 79.0193 | 2020-11-19 05:25:23 | Telangana, India | ||
126684 | 126684 | 2022-01-09 | India | Telangana | 694030 | 4042 | 0 | 18.1124 | 79.0193 | 2022-01-10 04:22:07 | Telangana, India | |||
130701 | 130701 | 2022-10-04 | India | Telangana | 838182 | 4111 | 0 | 18.1124 | 79.0193 | 2022-10-05 04:23:06 | Telangana, India | |||
137922 | 137922 | 2021-12-04 | India | Telangana | 676574 | 3997 | 0 | 18.1124 | 79.0193 | 2021-12-05 04:22:25 | Telangana, India | |||
141939 | 141939 | 2022-07-09 | India | Telangana | 805665 | 4111 | 0 | 18.1124 | 79.0193 | 2022-07-10 04:20:54 | Telangana, India | |||
145939 | 145939 | 2020-08-15 | India | Telangana | 91361 | 693 | 68126 | 22542 | 18.1124 | 79.0193 | 2020-08-16 04:27:42 | Telangana, India | ||
149935 | 149935 | 2021-11-29 | India | Telangana | 675798 | 3990 | 0 | 18.1124 | 79.0193 | 2021-11-30 04:22:53 | Telangana, India | |||
153950 | 153950 | 2021-01-08 | India | Telangana | 289135 | 1561 | 282574 | 5000 | 18.1124 | 79.0193 | 2021-01-09 05:22:18 | Telangana, India | ||
157964 | 157964 | 2022-03-29 | India | Telangana | 791213 | 4111 | 0 | 18.1124 | 79.0193 | 2022-03-30 04:20:45 | Telangana, India | |||
161979 | 161979 | 2021-11-19 | India | Telangana | 674318 | 3979 | 0 | 18.1124 | 79.0193 | 2021-11-20 04:22:17 | Telangana, India | |||
165996 | 165996 | 2022-06-21 | India | Telangana | 796704 | 4111 | 0 | 18.1124 | 79.0193 | 2022-06-22 04:20:54 | Telangana, India | |||
170011 | 170011 | 2021-04-16 | India | Telangana | 346331 | 1809 | 311008 | 33514 | 18.1124 | 79.0193 | 2021-04-17 04:20:40 | Telangana, India | ||
177670 | 177670 | 2020-07-27 | India | Telangana | 54059 | 463 | 41332 | 12264 | 18.1124 | 79.0193 | 2020-07-28 03:35:13 | Telangana, India | ||
177993 | 177993 | 2021-09-02 | India | Telangana | 658689 | 3878 | 0 | 18.1124 | 79.0193 | 2021-09-03 04:21:20 | Telangana, India | |||
182007 | 182007 | 2021-02-21 | India | Telangana | 297712 | 1625 | 294386 | 1701 | 18.1124 | 79.0193 | 2021-02-22 05:24:21 | Telangana, India | ||
186022 | 186022 | 2022-02-13 | India | Telangana | 783448 | 4107 | 0 | 18.1124 | 79.0193 | 2022-02-14 04:20:51 | Telangana, India | |||
190036 | 190036 | 2021-01-11 | India | Telangana | 290309 | 1568 | 284217 | 4524 | 18.1124 | 79.0193 | 2021-01-12 05:22:15 | Telangana, India | ||
194034 | 194034 | 2020-08-31 | India | Telangana | 127697 | 836 | 95162 | 31699 | 18.1124 | 79.0193 | 2020-09-01 04:28:31 | Telangana, India | ||
198210 | 198210 | 2022-10-19 | India | Telangana | 839329 | 4111 | 0 | 18.1124 | 79.0193 | 2022-10-20 04:22:59 | Telangana, India | |||
202223 | 202223 | 2020-12-25 | India | Telangana | 284391 | 1529 | 276244 | 6618 | 18.1124 | 79.0193 | 2020-12-26 05:22:28 | Telangana, India | ||
206221 | 206221 | 2020-08-19 | India | Telangana | 97424 | 729 | 75186 | 21509 | 18.1124 | 79.0193 | 2020-08-20 04:27:43 | Telangana, India | ||
210207 | 210207 | 2020-10-29 | India | Telangana | 237187 | 1330 | 217401 | 18456 | 18.1124 | 79.0193 | 2020-10-30 04:24:49 | Telangana, India | ||
217931 | 217931 | 2022-12-26 | India | Telangana | 841307 | 4111 | 0 | 18.1124 | 79.0193 | 2022-12-27 04:21:07 | Telangana, India | |||
221947 | 221947 | 2022-05-09 | India | Telangana | 792361 | 4111 | 0 | 18.1124 | 79.0193 | 2022-05-10 04:20:50 | Telangana, India | |||
229178 | 229178 | 2022-05-31 | India | Telangana | 793277 | 4111 | 0 | 18.1124 | 79.0193 | 2022-06-01 04:20:55 | Telangana, India | |||
233194 | 233194 | 2022-02-11 | India | Telangana | 782336 | 4106 | 0 | 18.1124 | 79.0193 | 2022-02-12 04:21:06 | Telangana, India | |||
237208 | 237208 | 2021-01-18 | India | Telangana | 292128 | 1581 | 286542 | 4005 | 18.1124 | 79.0193 | 2021-01-19 05:22:15 | Telangana, India | ||
241222 | 241222 | 2021-04-02 | India | Telangana | 310819 | 1712 | 302207 | 6900 | 18.1124 | 79.0193 | 2021-04-03 04:20:44 | Telangana, India | ||
245236 | 245236 | 2021-08-17 | India | Telangana | 653202 | 3847 | 0 | 18.1124 | 79.0193 | 2021-08-18 04:21:35 | Telangana, India | |||
249250 | 249250 | 2021-09-04 | India | Telangana | 659313 | 3883 | 0 | 18.1124 | 79.0193 | 2021-09-05 04:21:33 | Telangana, India | |||
253265 | 253265 | 2022-09-08 | India | Telangana | 835619 | 4111 | 0 | 18.1124 | 79.0193 | 2022-09-09 04:21:11 | Telangana, India | |||
257281 | 257281 | 2022-12-10 | India | Telangana | 841191 | 4111 | 0 | 18.1124 | 79.0193 | 2022-12-11 04:20:50 | Telangana, India | |||
261484 | 261484 | 2022-03-15 | India | Telangana | 790499 | 4111 | 0 | 18.1124 | 79.0193 | 2022-03-16 04:20:50 | Telangana, India | |||
272122 | 272122 | 2020-11-10 | India | Telangana | 253651 | 1390 | 234234 | 18027 | 18.1124 | 79.0193 | 2020-11-11 05:25:30 | Telangana, India | ||
276134 | 276134 | 2021-11-03 | India | Telangana | 671946 | 3960 | 0 | 18.1124 | 79.0193 | 2021-11-04 04:22:20 | Telangana, India | |||
280150 | 280150 | 2021-02-24 | India | Telangana | 298264 | 1630 | 294782 | 1852 | 18.1124 | 79.0193 | 2021-02-25 05:24:57 | Telangana, India | ||
287388 | 287388 | 2020-06-15 | India | Telangana | 5193 | 187 | 2766 | 2240 | 18.1124 | 79.0193 | 2020-06-16 04:33:09 | Telangana, India | ||
287947 | 287947 | 2021-10-31 | India | Telangana | 671463 | 3956 | 0 | 18.1124 | 79.0193 | 2021-11-01 04:22:01 | Telangana, India | |||
291964 | 291964 | 2022-11-15 | India | Telangana | 840914 | 4111 | 0 | 18.1124 | 79.0193 | 2022-11-16 04:21:09 | Telangana, India | |||
295979 | 295979 | 2021-07-15 | India | Telangana | 634605 | 3747 | 620757 | 10101 | 18.1124 | 79.0193 | 2021-07-16 04:21:22 | Telangana, India | ||
303260 | 303260 | 2020-07-01 | India | Telangana | 17357 | 267 | 8082 | 9008 | 18.1124 | 79.0193 | 2020-07-02 04:33:46 | Telangana, India | ||
303820 | 303820 | 2022-04-16 | India | Telangana | 791619 | 4111 | 0 | 18.1124 | 79.0193 | 2022-04-17 04:20:59 | Telangana, India | |||
307836 | 307836 | 2022-12-13 | India | Telangana | 841213 | 4111 | 0 | 18.1124 | 79.0193 | 2022-12-14 04:21:04 | Telangana, India | |||
311852 | 311852 | 2022-11-13 | India | Telangana | 840863 | 4111 | 0 | 18.1124 | 79.0193 | 2022-11-14 04:21:09 | Telangana, India | |||
315868 | 315868 | 2022-02-12 | India | Telangana | 783019 | 4106 | 0 | 18.1124 | 79.0193 | 2022-02-13 04:21:00 | Telangana, India | |||
319884 | 319884 | 2022-10-30 | India | Telangana | 840135 | 4111 | 0 | 18.1124 | 79.0193 | 2022-10-31 04:21:36 | Telangana, India | |||
327202 | 327202 | 2020-07-20 | India | Telangana | 46274 | 422 | 34323 | 11529 | 18.1124 | 79.0193 | 2020-07-21 04:38:46 | Telangana, India | ||
327858 | 327858 | 2022-12-27 | India | Telangana | 841312 | 4111 | 0 | 18.1124 | 79.0193 | 2022-12-28 04:21:04 | Telangana, India | |||
331873 | 331873 | 2021-08-04 | India | Telangana | 647229 | 3814 | 634612 | 8803 | 18.1124 | 79.0193 | 2021-08-05 04:21:51 | Telangana, India | ||
335888 | 335888 | 2022-03-18 | India | Telangana | 790689 | 4111 | 0 | 18.1124 | 79.0193 | 2022-03-19 04:20:47 | Telangana, India | |||
340242 | 340242 | 2021-02-03 | India | Telangana | 295101 | 1606 | 291510 | 1985 | 18.1124 | 79.0193 | 2021-02-04 05:22:26 | Telangana, India | ||
344242 | 344242 | 2020-09-14 | India | Telangana | 158513 | 974 | 127007 | 30532 | 18.1124 | 79.0193 | 2020-09-15 03:22:50 | Telangana, India | ||
348248 | 348248 | 2022-12-14 | India | Telangana | 841219 | 4111 | 0 | 18.1124 | 79.0193 | 2022-12-15 04:20:58 | Telangana, India | |||
352263 | 352263 | 2021-03-11 | India | Telangana | 300717 | 1650 | 297195 | 1872 | 18.1124 | 79.0193 | 2021-03-12 05:26:50 | Telangana, India | ||
356278 | 356278 | 2022-03-11 | India | Telangana | 790224 | 4111 | 0 | 18.1124 | 79.0193 | 2022-03-12 04:20:50 | Telangana, India | |||
360294 | 360294 | 2022-05-07 | India | Telangana | 792295 | 4111 | 0 | 18.1124 | 79.0193 | 2022-05-08 04:20:49 | Telangana, India | |||
367608 | 367608 | 2020-07-16 | India | Telangana | 41018 | 396 | 27295 | 13327 | 18.1124 | 79.0193 | 2020-07-17 04:34:50 | Telangana, India | ||
371580 | 371580 | 2020-08-08 | India | Telangana | 79495 | 627 | 55999 | 22869 | 18.1124 | 79.0193 | 2020-08-09 04:34:54 | Telangana, India | ||
372148 | 372148 | 2022-09-13 | India | Telangana | 836181 | 4111 | 0 | 18.1124 | 79.0193 | 2022-09-14 04:20:44 | Telangana, India | |||
376149 | 376149 | 2020-11-06 | India | Telangana | 248891 | 1372 | 227583 | 19936 | 18.1124 | 79.0193 | 2020-11-07 05:24:52 | Telangana, India | ||
380160 | 380160 | 2021-04-30 | India | Telangana | 443360 | 2312 | 362160 | 78888 | 18.1124 | 79.0193 | 2021-05-01 04:20:47 | Telangana, India | ||
384175 | 384175 | 2022-09-23 | India | Telangana | 837227 | 4111 | 0 | 18.1124 | 79.0193 | 2022-09-24 04:21:40 | Telangana, India | |||
388190 | 388190 | 2021-04-04 | India | Telangana | 313237 | 1723 | 302768 | 8746 | 18.1124 | 79.0193 | 2021-04-05 04:20:35 | Telangana, India | ||
392202 | 392202 | 2020-11-27 | India | Telangana | 268418 | 1451 | 256330 | 10637 | 18.1124 | 79.0193 | 2020-11-28 05:25:50 | Telangana, India | ||
396216 | 396216 | 2022-10-07 | India | Telangana | 838376 | 4111 | 0 | 18.1124 | 79.0193 | 2022-10-08 04:22:56 | Telangana, India | |||
400231 | 400231 | 2021-06-29 | India | Telangana | 622593 | 3651 | 605455 | 13487 | 18.1124 | 79.0193 | 2021-06-30 04:21:41 | Telangana, India | ||
404245 | 404245 | 2021-12-07 | India | Telangana | 677341 | 4001 | 0 | 18.1124 | 79.0193 | 2021-12-08 04:22:46 | Telangana, India | |||
408261 | 408261 | 2021-07-28 | India | Telangana | 643093 | 3793 | 629986 | 9314 | 18.1124 | 79.0193 | 2021-07-29 04:21:33 | Telangana, India | ||
415552 | 415552 | 2020-07-05 | India | Telangana | 23902 | 295 | 12703 | 10904 | 18.1124 | 79.0193 | 2020-07-06 04:33:57 | Telangana, India | ||
419287 | 419287 | 2022-09-18 | India | Telangana | 836692 | 4111 | 0 | 18.1124 | 79.0193 | 2022-09-19 04:21:49 | Telangana, India | |||
423302 | 423302 | 2021-10-10 | India | Telangana | 667887 | 3930 | 0 | 18.1124 | 79.0193 | 2021-10-11 04:21:31 | Telangana, India | |||
427303 | 427303 | 2020-09-07 | India | Telangana | 145163 | 906 | 112587 | 31670 | 18.1124 | 79.0193 | 2020-09-08 04:28:25 | Telangana, 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]);