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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436219 | 3436219 | 2020-07-11 | India | Telangana | 33402 | 348 | 20919 | 12135 | 18.1124 | 79.0193 | 2020-07-12 04:34:30 | Telangana, India | ||
3237717 | 3237717 | 2020-07-10 | India | Telangana | 32224 | 339 | 19205 | 12680 | 18.1124 | 79.0193 | 2020-07-11 04:34:26 | Telangana, India | ||
1005702 | 1005702 | 2020-07-09 | India | Telangana | 30946 | 331 | 18192 | 12423 | 18.1124 | 79.0193 | 2020-07-10 04:34:24 | Telangana, India | ||
2222918 | 2222918 | 2020-07-08 | India | Telangana | 29536 | 324 | 17279 | 11933 | 18.1124 | 79.0193 | 2020-07-09 04:34:23 | Telangana, India | ||
887527 | 887527 | 2020-07-07 | India | Telangana | 27612 | 313 | 16287 | 11012 | 18.1124 | 79.0193 | 2020-07-08 05:33:48 | Telangana, India | ||
2685087 | 2685087 | 2020-07-06 | India | Telangana | 25733 | 306 | 14781 | 10646 | 18.1124 | 79.0193 | 2020-07-07 04:34:00 | 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 | ||
530114 | 530114 | 2020-07-04 | India | Telangana | 22312 | 288 | 11537 | 10487 | 18.1124 | 79.0193 | 2020-07-05 04:33:46 | Telangana, India | ||
2234775 | 2234775 | 2020-07-03 | India | Telangana | 20462 | 283 | 10195 | 9984 | 18.1124 | 79.0193 | 2020-07-04 04:33:51 | Telangana, India | ||
3045569 | 3045569 | 2020-07-02 | India | Telangana | 18570 | 275 | 9069 | 9226 | 18.1124 | 79.0193 | 2020-07-03 04:33:54 | 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 | ||
2974638 | 2974638 | 2020-06-30 | India | Telangana | 16339 | 260 | 7294 | 8785 | 18.1124 | 79.0193 | 2020-07-01 04:33:52 | Telangana, India | ||
2633115 | 2633115 | 2020-06-29 | India | Telangana | 15394 | 253 | 5582 | 9559 | 18.1124 | 79.0193 | 2020-06-30 04:33:48 | Telangana, India | ||
2306678 | 2306678 | 2020-06-28 | India | Telangana | 14419 | 247 | 5172 | 9000 | 18.1124 | 79.0193 | 2020-06-29 04:33:44 | Telangana, India | ||
2040013 | 2040013 | 2020-06-27 | India | Telangana | 13436 | 243 | 4928 | 8265 | 18.1124 | 79.0193 | 2020-06-28 04:34:04 | Telangana, India | ||
1136294 | 1136294 | 2020-06-26 | India | Telangana | 12349 | 237 | 4766 | 7346 | 18.1124 | 79.0193 | 2020-06-27 04:33:35 | Telangana, India | ||
2625281 | 2625281 | 2020-06-25 | India | Telangana | 11364 | 230 | 4688 | 6446 | 18.1124 | 79.0193 | 2020-06-26 04:33:43 | Telangana, India | ||
2700921 | 2700921 | 2020-06-24 | India | Telangana | 10444 | 225 | 4361 | 5858 | 18.1124 | 79.0193 | 2020-06-25 05:26:54 | Telangana, India | ||
1522606 | 1522606 | 2020-06-23 | India | Telangana | 9553 | 220 | 4224 | 5109 | 18.1124 | 79.0193 | 2020-06-24 04:33:28 | Telangana, India | ||
1510800 | 1510800 | 2020-06-22 | India | Telangana | 8674 | 217 | 4005 | 4452 | 18.1124 | 79.0193 | 2020-06-23 04:33:22 | Telangana, India | ||
3249539 | 3249539 | 2020-06-21 | India | Telangana | 7802 | 210 | 3731 | 3861 | 18.1124 | 79.0193 | 2020-06-22 04:33:20 | Telangana, India | ||
2438132 | 2438132 | 2020-06-20 | India | Telangana | 7072 | 203 | 3506 | 3363 | 18.1124 | 79.0193 | 2020-06-21 04:33:19 | Telangana, India | ||
1691710 | 1691710 | 2020-06-19 | India | Telangana | 6526 | 198 | 3353 | 2975 | 18.1124 | 79.0193 | 2020-06-20 04:33:19 | Telangana, India | ||
3682859 | 3682859 | 2020-06-18 | India | Telangana | 6027 | 195 | 3301 | 2531 | 18.1124 | 79.0193 | 2020-06-19 04:33:17 | Telangana, India | ||
1196062 | 1196062 | 2020-06-17 | India | Telangana | 5675 | 192 | 3071 | 2412 | 18.1124 | 79.0193 | 2020-06-18 04:33:18 | Telangana, India | ||
2386825 | 2386825 | 2020-06-16 | India | Telangana | 5406 | 191 | 3027 | 2188 | 18.1124 | 79.0193 | 2020-06-17 04:33:21 | 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 | ||
1837339 | 1837339 | 2020-06-14 | India | Telangana | 4737 | 182 | 2352 | 2203 | 18.1124 | 79.0193 | 2020-06-15 03:33:14 | Telangana, India | ||
3061391 | 3061391 | 2020-06-13 | India | Telangana | 4484 | 174 | 2278 | 2032 | 18.1124 | 79.0193 | 2020-06-14 03:33:15 | Telangana, India | ||
737711 | 737711 | 2020-06-12 | India | Telangana | 4320 | 165 | 1993 | 2162 | 18.1124 | 79.0193 | 2020-06-13 03:33:14 | Telangana, India | ||
1273681 | 1273681 | 2020-06-11 | India | Telangana | 4320 | 165 | 1993 | 2162 | 18.1124 | 79.0193 | 2020-06-12 05:09:52 | Telangana, India | ||
2864122 | 2864122 | 2020-06-10 | India | Telangana | 3920 | 148 | 1809 | 1963 | 18.1124 | 79.0193 | 2020-06-11 03:33:41 | 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]);