johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Anhui" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069811 | 3069811 | 2021-11-23 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-24 04:22:14 | Anhui, China | |||
3748909 | 3748909 | 2021-11-22 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-23 04:22:39 | Anhui, China | |||
1014116 | 1014116 | 2021-11-21 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-22 04:22:20 | Anhui, China | |||
722280 | 722280 | 2021-11-20 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-21 04:22:13 | Anhui, China | |||
161810 | 161810 | 2021-11-19 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-20 04:22:17 | Anhui, China | |||
3288697 | 3288697 | 2021-11-18 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-19 04:21:40 | Anhui, China | |||
447153 | 447153 | 2021-11-17 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-18 04:21:33 | Anhui, China | |||
3342403 | 3342403 | 2021-11-16 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-17 04:21:48 | Anhui, China | |||
2287239 | 2287239 | 2021-11-15 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-16 04:21:10 | Anhui, China | |||
1322013 | 1322013 | 2021-11-14 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-15 04:21:36 | Anhui, China | |||
686139 | 686139 | 2021-11-13 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-14 04:21:31 | Anhui, China | |||
714248 | 714248 | 2021-11-12 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-13 04:21:38 | Anhui, China | |||
28198 | 28198 | 2021-11-11 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-12 04:22:01 | Anhui, China | |||
2844637 | 2844637 | 2021-11-10 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-11 04:21:45 | Anhui, China | |||
86907 | 86907 | 2021-11-09 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-10 04:21:38 | Anhui, China | |||
3639335 | 3639335 | 2021-11-08 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-09 04:21:36 | Anhui, China | |||
2000443 | 2000443 | 2021-11-07 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-08 04:21:43 | Anhui, China | |||
495434 | 495434 | 2021-11-06 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-07 04:21:53 | Anhui, China | |||
3121289 | 3121289 | 2021-11-05 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-06 04:21:51 | Anhui, China | |||
698187 | 698187 | 2021-11-04 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-05 04:21:54 | Anhui, China | |||
275965 | 275965 | 2021-11-03 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-04 04:22:20 | Anhui, China | |||
43490 | 43490 | 2021-11-02 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-03 06:22:09 | Anhui, China | |||
3511186 | 3511186 | 2021-11-01 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-02 04:22:03 | Anhui, China | |||
287778 | 287778 | 2021-10-31 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-11-01 04:22:01 | Anhui, China | |||
2720784 | 2720784 | 2021-10-30 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-31 04:22:08 | Anhui, China | |||
566886 | 566886 | 2021-10-29 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-30 04:22:03 | Anhui, China | |||
4128 | 4128 | 2021-10-28 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-29 04:22:03 | Anhui, China | |||
534518 | 534518 | 2021-10-27 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-28 04:22:08 | Anhui, China | |||
3491955 | 3491955 | 2021-10-26 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-27 04:22:32 | Anhui, China | |||
3793677 | 3793677 | 2021-10-25 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-26 04:22:09 | Anhui, China | |||
682123 | 682123 | 2021-10-24 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-25 04:22:31 | Anhui, China | |||
770131 | 770131 | 2021-10-23 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-24 04:21:22 | Anhui, China | |||
653778 | 653778 | 2021-10-22 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-23 04:21:32 | Anhui, China | |||
2123525 | 2123525 | 2021-10-21 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-22 04:21:14 | Anhui, China | |||
443137 | 443137 | 2021-10-20 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-21 04:21:18 | Anhui, China | |||
597456 | 597456 | 2021-10-19 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-20 04:21:00 | Anhui, China | |||
2043633 | 2043633 | 2021-10-18 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-19 04:20:54 | Anhui, China | |||
1908994 | 1908994 | 2021-10-17 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-18 04:21:10 | Anhui, China | |||
934583 | 934583 | 2021-10-16 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-17 04:21:29 | Anhui, China | |||
2943138 | 2943138 | 2021-10-15 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-16 04:21:15 | Anhui, China | |||
491418 | 491418 | 2021-10-14 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-15 04:21:26 | Anhui, China | |||
633706 | 633706 | 2021-10-13 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-14 04:21:29 | Anhui, China | |||
1491384 | 1491384 | 2021-10-12 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-13 04:20:51 | Anhui, China | |||
3007117 | 3007117 | 2021-10-11 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-12 04:21:09 | Anhui, China | |||
423133 | 423133 | 2021-10-10 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-11 04:21:31 | Anhui, China | |||
2875990 | 2875990 | 2021-10-09 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-10 04:21:38 | Anhui, China | |||
2959156 | 2959156 | 2021-10-08 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-09 04:21:34 | Anhui, China | |||
467194 | 467194 | 2021-10-07 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-08 04:21:25 | Anhui, China | |||
2458574 | 2458574 | 2021-10-06 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-07 04:21:36 | Anhui, China | |||
3832268 | 3832268 | 2021-10-05 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-06 04:21:33 | Anhui, China | |||
986761 | 986761 | 2021-10-04 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-05 04:21:27 | Anhui, China | |||
1274071 | 1274071 | 2021-10-03 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-04 04:21:31 | Anhui, China | |||
3927824 | 3927824 | 2021-10-02 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-03 04:21:24 | Anhui, China | |||
2131804 | 2131804 | 2021-10-01 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-02 04:21:25 | Anhui, China | |||
2772761 | 2772761 | 2021-09-30 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-10-01 04:21:35 | Anhui, China | |||
706217 | 706217 | 2021-09-29 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-30 04:21:20 | Anhui, China | |||
1334059 | 1334059 | 2021-09-28 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-29 04:21:45 | Anhui, China | |||
1235428 | 1235428 | 2021-09-27 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-28 04:21:28 | Anhui, China | |||
2075729 | 2075729 | 2021-09-26 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-27 04:21:16 | Anhui, China | |||
1724281 | 1724281 | 2021-09-25 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-26 04:21:29 | Anhui, China | |||
1921001 | 1921001 | 2021-09-24 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-25 04:21:31 | Anhui, China | |||
601472 | 601472 | 2021-09-23 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-24 04:21:44 | Anhui, China | |||
3011133 | 3011133 | 2021-09-22 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-23 04:21:43 | Anhui, China | |||
3757271 | 3757271 | 2021-09-21 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-22 04:21:45 | Anhui, China | |||
809374 | 809374 | 2021-09-20 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-21 04:21:26 | Anhui, China | |||
1814573 | 1814573 | 2021-09-19 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-20 04:21:22 | Anhui, China | |||
16153 | 16153 | 2021-09-18 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-19 04:21:34 | Anhui, China | |||
2617838 | 2617838 | 2021-09-17 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-18 04:21:24 | Anhui, China | |||
2808546 | 2808546 | 2021-09-16 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-17 04:21:46 | Anhui, China | |||
1374291 | 1374291 | 2021-09-15 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-16 04:22:19 | Anhui, China | |||
2462590 | 2462590 | 2021-09-14 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-15 03:22:37 | Anhui, China | |||
1385429 | 1385429 | 2021-09-13 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-14 04:21:41 | Anhui, China | |||
1884798 | 1884798 | 2021-09-12 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-13 04:21:15 | Anhui, China | |||
3805701 | 3805701 | 2021-09-11 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-12 04:21:13 | Anhui, China | |||
3448641 | 3448641 | 2021-09-10 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-11 04:21:30 | Anhui, China | |||
1262587 | 1262587 | 2021-09-09 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-10 04:21:20 | Anhui, China | |||
2278957 | 2278957 | 2021-09-08 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-09 04:21:27 | Anhui, China | |||
641736 | 641736 | 2021-09-07 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-08 04:21:31 | Anhui, China | |||
3193799 | 3193799 | 2021-09-06 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-07 04:21:35 | Anhui, China | |||
3280667 | 3280667 | 2021-09-05 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-06 04:21:22 | Anhui, China | |||
249081 | 249081 | 2021-09-04 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-05 04:21:33 | Anhui, China | |||
3974362 | 3974362 | 2021-09-03 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-04 04:21:28 | Anhui, China | |||
177824 | 177824 | 2021-09-02 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-03 04:21:20 | Anhui, China | |||
66859 | 66859 | 2021-09-01 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-02 04:21:15 | Anhui, China | |||
2067701 | 2067701 | 2021-08-31 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-09-01 04:21:38 | Anhui, China | |||
1775155 | 1775155 | 2021-08-30 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-31 04:21:46 | Anhui, China | |||
3891729 | 3891729 | 2021-08-29 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-30 04:21:23 | Anhui, China | |||
2792832 | 2792832 | 2021-08-28 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-29 04:21:14 | Anhui, China | |||
2922991 | 2922991 | 2021-08-27 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-28 04:21:28 | Anhui, China | |||
1596005 | 1596005 | 2021-08-26 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-27 04:21:37 | Anhui, China | |||
32214 | 32214 | 2021-08-25 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-26 04:21:28 | Anhui, China | |||
3105253 | 3105253 | 2021-08-24 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-25 04:21:41 | Anhui, China | |||
3165424 | 3165424 | 2021-08-23 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-24 04:21:19 | Anhui, China | |||
2175351 | 2175351 | 2021-08-22 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-23 04:21:27 | Anhui, China | |||
3555447 | 3555447 | 2021-08-21 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-22 04:21:29 | Anhui, China | |||
1853789 | 1853789 | 2021-08-20 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-21 04:21:38 | Anhui, China | |||
511496 | 511496 | 2021-08-19 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-20 04:21:33 | Anhui, China | |||
2517975 | 2517975 | 2021-08-18 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-19 04:21:15 | Anhui, China | |||
245067 | 245067 | 2021-08-17 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-18 04:21:35 | Anhui, China | |||
1604030 | 1604030 | 2021-08-16 | China | Anhui | 1008 | 6 | 0 | 31.8257 | 117.2264 | 2021-08-17 04:21:49 | Anhui, China |
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]);