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 = "Andhra Pradesh" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435802 | 3435802 | 2020-07-11 | India | Andhra Pradesh | 27235 | 309 | 14393 | 12533 | 15.9129 | 79.74 | 2020-07-12 04:34:30 | Andhra Pradesh, India | ||
3237300 | 3237300 | 2020-07-10 | India | Andhra Pradesh | 25422 | 292 | 13194 | 11936 | 15.9129 | 79.74 | 2020-07-11 04:34:26 | Andhra Pradesh, India | ||
1005285 | 1005285 | 2020-07-09 | India | Andhra Pradesh | 23814 | 277 | 12154 | 11383 | 15.9129 | 79.74 | 2020-07-10 04:34:24 | Andhra Pradesh, India | ||
2222501 | 2222501 | 2020-07-08 | India | Andhra Pradesh | 22259 | 264 | 11101 | 10894 | 15.9129 | 79.74 | 2020-07-09 04:34:23 | Andhra Pradesh, India | ||
887110 | 887110 | 2020-07-07 | India | Andhra Pradesh | 21197 | 252 | 9745 | 11200 | 15.9129 | 79.74 | 2020-07-08 05:33:48 | Andhra Pradesh, India | ||
2684670 | 2684670 | 2020-07-06 | India | Andhra Pradesh | 20019 | 239 | 8920 | 10860 | 15.9129 | 79.74 | 2020-07-07 04:34:00 | Andhra Pradesh, India | ||
415135 | 415135 | 2020-07-05 | India | Andhra Pradesh | 18697 | 232 | 8422 | 10043 | 15.9129 | 79.74 | 2020-07-06 04:33:57 | Andhra Pradesh, India | ||
529697 | 529697 | 2020-07-04 | India | Andhra Pradesh | 17699 | 218 | 8008 | 9473 | 15.9129 | 79.74 | 2020-07-05 04:33:46 | Andhra Pradesh, India | ||
2234358 | 2234358 | 2020-07-03 | India | Andhra Pradesh | 16934 | 206 | 7632 | 9096 | 15.9129 | 79.74 | 2020-07-04 04:33:51 | Andhra Pradesh, India | ||
3045152 | 3045152 | 2020-07-02 | India | Andhra Pradesh | 16097 | 198 | 7313 | 8586 | 15.9129 | 79.74 | 2020-07-03 04:33:54 | Andhra Pradesh, India | ||
302843 | 302843 | 2020-07-01 | India | Andhra Pradesh | 15252 | 193 | 6988 | 8071 | 15.9129 | 79.74 | 2020-07-02 04:33:46 | Andhra Pradesh, India | ||
2974221 | 2974221 | 2020-06-30 | India | Andhra Pradesh | 14595 | 187 | 6511 | 7897 | 15.9129 | 79.74 | 2020-07-01 04:33:52 | Andhra Pradesh, India | ||
2632698 | 2632698 | 2020-06-29 | India | Andhra Pradesh | 13891 | 180 | 6232 | 7479 | 15.9129 | 79.74 | 2020-06-30 04:33:48 | Andhra Pradesh, India | ||
2306261 | 2306261 | 2020-06-28 | India | Andhra Pradesh | 13241 | 169 | 5908 | 7164 | 15.9129 | 79.74 | 2020-06-29 04:33:44 | Andhra Pradesh, India | ||
2039596 | 2039596 | 2020-06-27 | India | Andhra Pradesh | 12285 | 157 | 5480 | 6648 | 15.9129 | 79.74 | 2020-06-28 04:34:04 | Andhra Pradesh, India | ||
1135877 | 1135877 | 2020-06-26 | India | Andhra Pradesh | 11489 | 148 | 5196 | 6145 | 15.9129 | 79.74 | 2020-06-27 04:33:35 | Andhra Pradesh, India | ||
2624864 | 2624864 | 2020-06-25 | India | Andhra Pradesh | 10884 | 136 | 4988 | 5760 | 15.9129 | 79.74 | 2020-06-26 04:33:43 | Andhra Pradesh, India | ||
2700504 | 2700504 | 2020-06-24 | India | Andhra Pradesh | 10331 | 124 | 4779 | 5428 | 15.9129 | 79.74 | 2020-06-25 05:26:54 | Andhra Pradesh, India | ||
1522189 | 1522189 | 2020-06-23 | India | Andhra Pradesh | 10002 | 119 | 4599 | 5284 | 15.9129 | 79.74 | 2020-06-24 04:33:28 | Andhra Pradesh, India | ||
1510383 | 1510383 | 2020-06-22 | India | Andhra Pradesh | 9372 | 111 | 4495 | 4766 | 15.9129 | 79.74 | 2020-06-23 04:33:22 | Andhra Pradesh, India | ||
3249122 | 3249122 | 2020-06-21 | India | Andhra Pradesh | 8999 | 106 | 4331 | 4562 | 15.9129 | 79.74 | 2020-06-22 04:33:20 | Andhra Pradesh, India | ||
2437715 | 2437715 | 2020-06-20 | India | Andhra Pradesh | 8452 | 101 | 4111 | 4240 | 15.9129 | 79.74 | 2020-06-21 04:33:19 | Andhra Pradesh, India | ||
1691293 | 1691293 | 2020-06-19 | India | Andhra Pradesh | 7961 | 96 | 3917 | 3948 | 15.9129 | 79.74 | 2020-06-20 04:33:19 | Andhra Pradesh, India | ||
3682442 | 3682442 | 2020-06-18 | India | Andhra Pradesh | 7518 | 92 | 3789 | 3637 | 15.9129 | 79.74 | 2020-06-19 04:33:17 | Andhra Pradesh, India | ||
1195645 | 1195645 | 2020-06-17 | India | Andhra Pradesh | 7071 | 90 | 3641 | 3340 | 15.9129 | 79.74 | 2020-06-18 04:33:18 | Andhra Pradesh, India | ||
2386408 | 2386408 | 2020-06-16 | India | Andhra Pradesh | 6841 | 88 | 3509 | 3244 | 15.9129 | 79.74 | 2020-06-17 04:33:21 | Andhra Pradesh, India | ||
286971 | 286971 | 2020-06-15 | India | Andhra Pradesh | 6456 | 88 | 3316 | 3052 | 15.9129 | 79.74 | 2020-06-16 04:33:09 | Andhra Pradesh, India | ||
1836922 | 1836922 | 2020-06-14 | India | Andhra Pradesh | 5965 | 82 | 3195 | 2688 | 15.9129 | 79.74 | 2020-06-15 03:33:14 | Andhra Pradesh, India | ||
3060974 | 3060974 | 2020-06-13 | India | Andhra Pradesh | 5680 | 80 | 3105 | 2495 | 15.9129 | 79.74 | 2020-06-14 03:33:15 | Andhra Pradesh, India | ||
737294 | 737294 | 2020-06-12 | India | Andhra Pradesh | 5429 | 80 | 3048 | 2301 | 15.9129 | 79.74 | 2020-06-13 03:33:14 | Andhra Pradesh, India | ||
1273264 | 1273264 | 2020-06-11 | India | Andhra Pradesh | 5429 | 80 | 3048 | 2301 | 15.9129 | 79.74 | 2020-06-12 05:09:52 | Andhra Pradesh, India | ||
2863708 | 2863708 | 2020-06-10 | India | Andhra Pradesh | 5070 | 77 | 2802 | 2191 | 15.9129 | 79.74 | 2020-06-11 03:33:41 | Andhra Pradesh, 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]);