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 = "Ningxia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462611 | 2462611 | 2021-09-14 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-15 03:22:37 | Ningxia, China | |||
1385450 | 1385450 | 2021-09-13 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-14 04:21:41 | Ningxia, China | |||
1884819 | 1884819 | 2021-09-12 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-13 04:21:15 | Ningxia, China | |||
3805722 | 3805722 | 2021-09-11 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-12 04:21:13 | Ningxia, China | |||
3448662 | 3448662 | 2021-09-10 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-11 04:21:30 | Ningxia, China | |||
1262608 | 1262608 | 2021-09-09 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-10 04:21:20 | Ningxia, China | |||
2278978 | 2278978 | 2021-09-08 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-09 04:21:27 | Ningxia, China | |||
641757 | 641757 | 2021-09-07 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-08 04:21:31 | Ningxia, China | |||
3193820 | 3193820 | 2021-09-06 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-07 04:21:35 | Ningxia, China | |||
3280688 | 3280688 | 2021-09-05 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-06 04:21:22 | Ningxia, China | |||
249102 | 249102 | 2021-09-04 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-05 04:21:33 | Ningxia, China | |||
3974383 | 3974383 | 2021-09-03 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-04 04:21:28 | Ningxia, China | |||
177845 | 177845 | 2021-09-02 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-03 04:21:20 | Ningxia, China | |||
66880 | 66880 | 2021-09-01 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-02 04:21:15 | Ningxia, China | |||
2067722 | 2067722 | 2021-08-31 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-01 04:21:38 | Ningxia, China | |||
1775176 | 1775176 | 2021-08-30 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-31 04:21:46 | Ningxia, China | |||
3891750 | 3891750 | 2021-08-29 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-30 04:21:23 | Ningxia, China | |||
2792853 | 2792853 | 2021-08-28 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-29 04:21:14 | Ningxia, China | |||
2923012 | 2923012 | 2021-08-27 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-28 04:21:28 | Ningxia, China | |||
1596026 | 1596026 | 2021-08-26 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-27 04:21:37 | Ningxia, China | |||
32235 | 32235 | 2021-08-25 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-26 04:21:28 | Ningxia, China | |||
3105274 | 3105274 | 2021-08-24 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-25 04:21:41 | Ningxia, China | |||
3165445 | 3165445 | 2021-08-23 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-24 04:21:19 | Ningxia, China | |||
2175372 | 2175372 | 2021-08-22 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-23 04:21:27 | Ningxia, China | |||
3555468 | 3555468 | 2021-08-21 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-22 04:21:29 | Ningxia, China | |||
1853810 | 1853810 | 2021-08-20 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-21 04:21:38 | Ningxia, China | |||
511517 | 511517 | 2021-08-19 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-20 04:21:33 | Ningxia, China | |||
2517996 | 2517996 | 2021-08-18 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-19 04:21:15 | Ningxia, China | |||
245088 | 245088 | 2021-08-17 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-18 04:21:35 | Ningxia, China | |||
1604051 | 1604051 | 2021-08-16 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-17 04:21:49 | Ningxia, China | |||
103145 | 103145 | 2021-08-15 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-16 04:21:31 | Ningxia, China | |||
507503 | 507503 | 2021-08-14 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-15 04:21:41 | Ningxia, China | |||
1483375 | 1483375 | 2021-08-13 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-14 04:21:25 | Ningxia, China | |||
2899505 | 2899505 | 2021-08-12 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-13 04:21:24 | Ningxia, China | |||
1342109 | 1342109 | 2021-08-11 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-12 04:21:25 | Ningxia, China | |||
2351256 | 2351256 | 2021-08-10 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-11 04:21:58 | Ningxia, China | |||
649785 | 649785 | 2021-08-09 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-10 04:21:27 | Ningxia, China | |||
589447 | 589447 | 2021-08-08 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-09 04:21:24 | Ningxia, China | |||
2203459 | 2203459 | 2021-08-07 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-08 04:21:33 | Ningxia, China | |||
1117409 | 1117409 | 2021-08-06 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-07 04:21:30 | Ningxia, China | |||
1956346 | 1956346 | 2021-08-05 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-08-06 04:21:18 | Ningxia, China | |||
331725 | 331725 | 2021-08-04 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-05 04:21:51 | Ningxia, China | ||
3467996 | 3467996 | 2021-08-03 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-04 04:21:25 | Ningxia, China | ||
3683270 | 3683270 | 2021-08-02 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-03 04:21:39 | Ningxia, China | ||
3015169 | 3015169 | 2021-08-01 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-02 04:21:36 | Ningxia, China | ||
3903792 | 3903792 | 2021-07-31 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-01 04:21:50 | Ningxia, China | ||
3295997 | 3295997 | 2021-07-30 | China | Ningxia | 76 | 0 | 76 | 0 | 37.2692 | 106.1655 | 2021-07-31 04:21:35 | Ningxia, China | ||
3385208 | 3385208 | 2021-07-29 | China | Ningxia | 76 | 0 | 76 | 0 | 37.2692 | 106.1655 | 2021-07-30 04:21:34 | Ningxia, China | ||
408113 | 408113 | 2021-07-28 | China | Ningxia | 76 | 0 | 76 | 0 | 37.2692 | 106.1655 | 2021-07-29 04:21:33 | Ningxia, China | ||
1305974 | 1305974 | 2021-07-27 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-28 04:21:39 | Ningxia, China | ||
3218117 | 3218117 | 2021-07-26 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-27 04:21:18 | Ningxia, China | ||
1378326 | 1378326 | 2021-07-25 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-26 04:21:28 | Ningxia, China | ||
1330066 | 1330066 | 2021-07-24 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-25 04:22:12 | Ningxia, China | ||
3137370 | 3137370 | 2021-07-23 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-24 00:21:36 | Ningxia, China | ||
3476130 | 3476130 | 2021-07-22 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-23 04:21:29 | Ningxia, China | ||
3331349 | 3331349 | 2021-07-21 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-22 04:21:19 | Ningxia, China | ||
2371330 | 2371330 | 2021-07-20 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-21 04:21:40 | Ningxia, China | ||
483409 | 483409 | 2021-07-19 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-20 04:21:48 | Ningxia, China | ||
2673632 | 2673632 | 2021-07-18 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-19 04:21:24 | Ningxia, China | ||
3705944 | 3705944 | 2021-07-17 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-18 04:22:07 | Ningxia, China | ||
2947175 | 2947175 | 2021-07-16 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-17 04:22:22 | Ningxia, China | ||
295831 | 295831 | 2021-07-15 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-16 04:21:22 | Ningxia, China | ||
3631776 | 3631776 | 2021-07-14 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-15 04:21:48 | Ningxia, China | ||
578651 | 578651 | 2021-07-13 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-14 04:21:35 | Ningxia, China | ||
3740900 | 3740900 | 2021-07-12 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-13 04:21:18 | Ningxia, China | ||
3659413 | 3659413 | 2021-07-11 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-12 04:21:34 | Ningxia, China | ||
625697 | 625697 | 2021-07-10 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-11 04:21:43 | Ningxia, China | ||
829416 | 829416 | 2021-07-09 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-10 04:21:25 | Ningxia, China | ||
778180 | 778180 | 2021-07-08 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-09 04:21:21 | Ningxia, China | ||
1440402 | 1440402 | 2021-07-07 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-08 04:21:26 | Ningxia, China | ||
2693507 | 2693507 | 2021-07-06 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-07 04:21:20 | Ningxia, China | ||
1932256 | 1932256 | 2021-07-05 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-06 04:21:32 | Ningxia, China | ||
1164987 | 1164987 | 2021-07-04 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-05 04:21:28 | Ningxia, China | ||
1495421 | 1495421 | 2021-07-03 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-04 04:21:38 | Ningxia, China | ||
2071736 | 2071736 | 2021-07-02 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-03 04:21:37 | Ningxia, China | ||
2764752 | 2764752 | 2021-07-01 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-02 04:21:47 | Ningxia, China | ||
1892960 | 1892960 | 2021-06-30 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-01 04:21:19 | Ningxia, China | ||
400083 | 400083 | 2021-06-29 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-30 04:21:41 | Ningxia, China | ||
3125326 | 3125326 | 2021-06-28 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-29 04:21:28 | Ningxia, China | ||
2589821 | 2589821 | 2021-06-27 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-28 04:21:29 | Ningxia, China | ||
3958325 | 3958325 | 2021-06-26 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-27 04:21:39 | Ningxia, China | ||
1712144 | 1712144 | 2021-06-25 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-26 04:21:43 | Ningxia, China | ||
2295269 | 2295269 | 2021-06-24 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-25 04:21:33 | Ningxia, China | ||
2422709 | 2422709 | 2021-06-23 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-24 04:21:55 | Ningxia, China | ||
562786 | 562786 | 2021-06-22 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-23 04:21:46 | Ningxia, China | ||
3358488 | 3358488 | 2021-06-21 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-22 04:21:34 | Ningxia, China | ||
2884187 | 2884187 | 2021-06-20 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-21 04:21:41 | Ningxia, China | ||
107270 | 107270 | 2021-06-19 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-20 04:21:48 | Ningxia, China | ||
1125413 | 1125413 | 2021-06-18 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-19 04:22:33 | Ningxia, China | ||
2910991 | 2910991 | 2021-06-17 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-18 04:22:16 | Ningxia, China | ||
3030109 | 3030109 | 2021-06-16 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-17 04:22:36 | Ningxia, China | ||
2339215 | 2339215 | 2021-06-15 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-16 04:22:32 | Ningxia, China | ||
1563911 | 1563911 | 2021-06-14 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-15 04:22:22 | Ningxia, China | ||
3381194 | 3381194 | 2021-06-13 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-14 04:22:46 | Ningxia, China | ||
1736328 | 1736328 | 2021-06-12 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-13 04:22:44 | Ningxia, China | ||
3970369 | 3970369 | 2021-06-11 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-12 04:22:22 | Ningxia, China | ||
2716791 | 2716791 | 2021-06-10 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-11 04:23:20 | Ningxia, China | ||
522676 | 522676 | 2021-06-09 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-10 04:23:17 | Ningxia, China | ||
3472116 | 3472116 | 2021-06-08 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-09 04:23:31 | Ningxia, China | ||
3145400 | 3145400 | 2021-06-07 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-06-08 04:22:35 | Ningxia, 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]);