johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "China" and province_or_state = "Unknown" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069841 | 3069841 | 2021-11-23 | China | Unknown | 12179 | 0 | 0 | 2021-11-24 04:22:14 | Unknown, China | |||||
3748939 | 3748939 | 2021-11-22 | China | Unknown | 12164 | 0 | 0 | 2021-11-23 04:22:39 | Unknown, China | |||||
1014146 | 1014146 | 2021-11-21 | China | Unknown | 12140 | 0 | 0 | 2021-11-22 04:22:20 | Unknown, China | |||||
722310 | 722310 | 2021-11-20 | China | Unknown | 12133 | 0 | 0 | 2021-11-21 04:22:13 | Unknown, China | |||||
161840 | 161840 | 2021-11-19 | China | Unknown | 12118 | 0 | 0 | 2021-11-20 04:22:17 | Unknown, China | |||||
3288727 | 3288727 | 2021-11-18 | China | Unknown | 12095 | 0 | 0 | 2021-11-19 04:21:40 | Unknown, China | |||||
447183 | 447183 | 2021-11-17 | China | Unknown | 12075 | 0 | 0 | 2021-11-18 04:21:33 | Unknown, China | |||||
3342433 | 3342433 | 2021-11-16 | China | Unknown | 12062 | 0 | 0 | 2021-11-17 04:21:48 | Unknown, China | |||||
2287269 | 2287269 | 2021-11-15 | China | Unknown | 12054 | 0 | 0 | 2021-11-16 04:21:10 | Unknown, China | |||||
1322043 | 1322043 | 2021-11-14 | China | Unknown | 12053 | 0 | 0 | 2021-11-15 04:21:36 | Unknown, China | |||||
686169 | 686169 | 2021-11-13 | China | Unknown | 12030 | 0 | 0 | 2021-11-14 04:21:31 | Unknown, China | |||||
714278 | 714278 | 2021-11-12 | China | Unknown | 12029 | 0 | 0 | 2021-11-13 04:21:38 | Unknown, China | |||||
28228 | 28228 | 2021-11-11 | China | Unknown | 12010 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, China | |||||
2844667 | 2844667 | 2021-11-10 | China | Unknown | 11991 | 0 | 0 | 2021-11-11 04:21:45 | Unknown, China | |||||
86937 | 86937 | 2021-11-09 | China | Unknown | 11960 | 0 | 0 | 2021-11-10 04:21:38 | Unknown, China | |||||
3639365 | 3639365 | 2021-11-08 | China | Unknown | 11898 | 0 | 0 | 2021-11-09 04:21:36 | Unknown, China | |||||
2000473 | 2000473 | 2021-11-07 | China | Unknown | 11873 | 0 | 0 | 2021-11-08 04:21:43 | Unknown, China | |||||
495464 | 495464 | 2021-11-06 | China | Unknown | 11844 | 0 | 0 | 2021-11-07 04:21:53 | Unknown, China | |||||
3121319 | 3121319 | 2021-11-05 | China | Unknown | 11823 | 0 | 0 | 2021-11-06 04:21:51 | Unknown, China | |||||
698217 | 698217 | 2021-11-04 | China | Unknown | 11786 | 0 | 0 | 2021-11-05 04:21:54 | Unknown, China | |||||
275995 | 275995 | 2021-11-03 | China | Unknown | 11758 | 0 | 0 | 2021-11-04 04:22:20 | Unknown, China | |||||
43520 | 43520 | 2021-11-02 | China | Unknown | 11743 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, China | |||||
3511216 | 3511216 | 2021-11-01 | China | Unknown | 11739 | 0 | 0 | 2021-11-02 04:22:03 | Unknown, China | |||||
287808 | 287808 | 2021-10-31 | China | Unknown | 11730 | 0 | 0 | 2021-11-01 04:22:01 | Unknown, China | |||||
2720814 | 2720814 | 2021-10-30 | China | Unknown | 11718 | 0 | 0 | 2021-10-31 04:22:08 | Unknown, China | |||||
566916 | 566916 | 2021-10-29 | China | Unknown | 11701 | 0 | 0 | 2021-10-30 04:22:03 | Unknown, China | |||||
4158 | 4158 | 2021-10-28 | China | Unknown | 11686 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, China | |||||
534548 | 534548 | 2021-10-27 | China | Unknown | 11665 | 0 | 0 | 2021-10-28 04:22:08 | Unknown, China | |||||
3491985 | 3491985 | 2021-10-26 | China | Unknown | 11648 | 0 | 0 | 2021-10-27 04:22:32 | Unknown, China | |||||
3793707 | 3793707 | 2021-10-25 | China | Unknown | 11628 | 0 | 0 | 2021-10-26 04:22:09 | Unknown, China | |||||
682153 | 682153 | 2021-10-24 | China | Unknown | 11620 | 0 | 0 | 2021-10-25 04:22:31 | Unknown, China | |||||
770161 | 770161 | 2021-10-23 | China | Unknown | 11610 | 0 | 0 | 2021-10-24 04:21:22 | Unknown, China | |||||
653808 | 653808 | 2021-10-22 | China | Unknown | 11596 | 0 | 0 | 2021-10-23 04:21:32 | Unknown, China | |||||
2123555 | 2123555 | 2021-10-21 | China | Unknown | 11571 | 0 | 0 | 2021-10-22 04:21:14 | Unknown, China | |||||
443167 | 443167 | 2021-10-20 | China | Unknown | 11546 | 0 | 0 | 2021-10-21 04:21:18 | Unknown, China | |||||
597486 | 597486 | 2021-10-19 | China | Unknown | 11528 | 0 | 0 | 2021-10-20 04:21:00 | Unknown, China | |||||
2043663 | 2043663 | 2021-10-18 | China | Unknown | 11513 | 0 | 0 | 2021-10-19 04:20:54 | Unknown, China | |||||
1909024 | 1909024 | 2021-10-17 | China | Unknown | 11505 | 0 | 0 | 2021-10-18 04:21:10 | Unknown, China | |||||
934613 | 934613 | 2021-10-16 | China | Unknown | 11498 | 0 | 0 | 2021-10-17 04:21:29 | Unknown, China | |||||
2943168 | 2943168 | 2021-10-15 | China | Unknown | 11485 | 0 | 0 | 2021-10-16 04:21:15 | Unknown, China | |||||
491448 | 491448 | 2021-10-14 | China | Unknown | 11463 | 0 | 0 | 2021-10-15 04:21:26 | Unknown, China | |||||
633736 | 633736 | 2021-10-13 | China | Unknown | 11443 | 0 | 0 | 2021-10-14 04:21:29 | Unknown, China | |||||
1491414 | 1491414 | 2021-10-12 | China | Unknown | 11428 | 0 | 0 | 2021-10-13 04:20:51 | Unknown, China | |||||
3007147 | 3007147 | 2021-10-11 | China | Unknown | 11415 | 0 | 0 | 2021-10-12 04:21:09 | Unknown, China | |||||
423163 | 423163 | 2021-10-10 | China | Unknown | 11408 | 0 | 0 | 2021-10-11 04:21:31 | Unknown, China | |||||
2876020 | 2876020 | 2021-10-09 | China | Unknown | 11397 | 0 | 0 | 2021-10-10 04:21:38 | Unknown, China | |||||
2959186 | 2959186 | 2021-10-08 | China | Unknown | 11377 | 0 | 0 | 2021-10-09 04:21:34 | Unknown, China | |||||
467224 | 467224 | 2021-10-07 | China | Unknown | 11365 | 0 | 0 | 2021-10-08 04:21:25 | Unknown, China | |||||
2458604 | 2458604 | 2021-10-06 | China | Unknown | 11354 | 0 | 0 | 2021-10-07 04:21:36 | Unknown, China | |||||
3832298 | 3832298 | 2021-10-05 | China | Unknown | 11343 | 0 | 0 | 2021-10-06 04:21:33 | Unknown, China | |||||
986791 | 986791 | 2021-10-04 | China | Unknown | 11328 | 0 | 0 | 2021-10-05 04:21:27 | Unknown, China | |||||
1274101 | 1274101 | 2021-10-03 | China | Unknown | 11317 | 0 | 0 | 2021-10-04 04:21:31 | Unknown, China | |||||
3927854 | 3927854 | 2021-10-02 | China | Unknown | 11304 | 0 | 0 | 2021-10-03 04:21:24 | Unknown, China | |||||
2131834 | 2131834 | 2021-10-01 | China | Unknown | 11295 | 0 | 0 | 2021-10-02 04:21:25 | Unknown, China | |||||
2772791 | 2772791 | 2021-09-30 | China | Unknown | 11276 | 0 | 0 | 2021-10-01 04:21:35 | Unknown, China | |||||
706247 | 706247 | 2021-09-29 | China | Unknown | 11257 | 0 | 0 | 2021-09-30 04:21:20 | Unknown, China | |||||
1334089 | 1334089 | 2021-09-28 | China | Unknown | 11238 | 0 | 0 | 2021-09-29 04:21:45 | Unknown, China | |||||
1235458 | 1235458 | 2021-09-27 | China | Unknown | 11234 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, China | |||||
2075759 | 2075759 | 2021-09-26 | China | Unknown | 11217 | 0 | 0 | 2021-09-27 04:21:16 | Unknown, China | |||||
1724311 | 1724311 | 2021-09-25 | China | Unknown | 11205 | 0 | 0 | 2021-09-26 04:21:29 | Unknown, China | |||||
1921031 | 1921031 | 2021-09-24 | China | Unknown | 11191 | 0 | 0 | 2021-09-25 04:21:31 | Unknown, China | |||||
601502 | 601502 | 2021-09-23 | China | Unknown | 11180 | 0 | 0 | 2021-09-24 04:21:44 | Unknown, China | |||||
3011163 | 3011163 | 2021-09-22 | China | Unknown | 11166 | 0 | 0 | 2021-09-23 04:21:43 | Unknown, China | |||||
3757301 | 3757301 | 2021-09-21 | China | Unknown | 11159 | 0 | 0 | 2021-09-22 04:21:45 | Unknown, China | |||||
809404 | 809404 | 2021-09-20 | China | Unknown | 11150 | 0 | 0 | 2021-09-21 04:21:26 | Unknown, China | |||||
1814603 | 1814603 | 2021-09-19 | China | Unknown | 11140 | 0 | 0 | 2021-09-20 04:21:22 | Unknown, China | |||||
16183 | 16183 | 2021-09-18 | China | Unknown | 11129 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, China | |||||
2617868 | 2617868 | 2021-09-17 | China | Unknown | 11120 | 0 | 0 | 2021-09-18 04:21:24 | Unknown, China | |||||
2808576 | 2808576 | 2021-09-16 | China | Unknown | 11103 | 0 | 0 | 2021-09-17 04:21:46 | Unknown, China | |||||
1374321 | 1374321 | 2021-09-15 | China | Unknown | 11103 | 0 | 0 | 2021-09-16 04:22:19 | Unknown, China | |||||
2462620 | 2462620 | 2021-09-14 | China | Unknown | 11100 | 0 | 0 | 2021-09-15 03:22:37 | Unknown, China | |||||
1385459 | 1385459 | 2021-09-13 | China | Unknown | 11097 | 0 | 0 | 2021-09-14 04:21:41 | Unknown, China | |||||
1884828 | 1884828 | 2021-09-12 | China | Unknown | 11072 | 0 | 0 | 2021-09-13 04:21:15 | Unknown, China | |||||
3805731 | 3805731 | 2021-09-11 | China | Unknown | 11033 | 0 | 0 | 2021-09-12 04:21:13 | Unknown, China | |||||
3448671 | 3448671 | 2021-09-10 | China | Unknown | 11017 | 0 | 0 | 2021-09-11 04:21:30 | Unknown, China | |||||
1262617 | 1262617 | 2021-09-09 | China | Unknown | 10997 | 0 | 0 | 2021-09-10 04:21:20 | Unknown, China | |||||
2278987 | 2278987 | 2021-09-08 | China | Unknown | 10991 | 0 | 0 | 2021-09-09 04:21:27 | Unknown, China | |||||
641766 | 641766 | 2021-09-07 | China | Unknown | 10980 | 0 | 0 | 2021-09-08 04:21:31 | Unknown, China | |||||
3193829 | 3193829 | 2021-09-06 | China | Unknown | 10973 | 0 | 0 | 2021-09-07 04:21:35 | Unknown, China | |||||
3280697 | 3280697 | 2021-09-05 | China | Unknown | 10960 | 0 | 0 | 2021-09-06 04:21:22 | Unknown, China | |||||
249111 | 249111 | 2021-09-04 | China | Unknown | 10940 | 0 | 0 | 2021-09-05 04:21:33 | Unknown, China | |||||
3974392 | 3974392 | 2021-09-03 | China | Unknown | 10925 | 0 | 0 | 2021-09-04 04:21:28 | Unknown, China | |||||
177854 | 177854 | 2021-09-02 | China | Unknown | 10907 | 0 | 0 | 2021-09-03 04:21:20 | Unknown, China | |||||
66889 | 66889 | 2021-09-01 | China | Unknown | 10889 | 0 | 0 | 2021-09-02 04:21:15 | Unknown, China | |||||
2067731 | 2067731 | 2021-08-31 | China | Unknown | 10877 | 0 | 0 | 2021-09-01 04:21:38 | Unknown, China | |||||
1775185 | 1775185 | 2021-08-30 | China | Unknown | 10867 | 0 | 0 | 2021-08-31 04:21:46 | Unknown, China | |||||
3891759 | 3891759 | 2021-08-29 | China | Unknown | 10847 | 0 | 0 | 2021-08-30 04:21:23 | Unknown, China | |||||
2792862 | 2792862 | 2021-08-28 | China | Unknown | 10831 | 0 | 0 | 2021-08-29 04:21:14 | Unknown, China | |||||
2923021 | 2923021 | 2021-08-27 | China | Unknown | 10825 | 0 | 0 | 2021-08-28 04:21:28 | Unknown, China | |||||
1596035 | 1596035 | 2021-08-26 | China | Unknown | 10806 | 0 | 0 | 2021-08-27 04:21:37 | Unknown, China | |||||
32244 | 32244 | 2021-08-25 | China | Unknown | 10791 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, China | |||||
3105283 | 3105283 | 2021-08-24 | China | Unknown | 10783 | 0 | 0 | 2021-08-25 04:21:41 | Unknown, China | |||||
3165454 | 3165454 | 2021-08-23 | China | Unknown | 10779 | 0 | 0 | 2021-08-24 04:21:19 | Unknown, China | |||||
2175381 | 2175381 | 2021-08-22 | China | Unknown | 10766 | 0 | 0 | 2021-08-23 04:21:27 | Unknown, China | |||||
3555477 | 3555477 | 2021-08-21 | China | Unknown | 10747 | 0 | 0 | 2021-08-22 04:21:29 | Unknown, China | |||||
1853819 | 1853819 | 2021-08-20 | China | Unknown | 10730 | 0 | 0 | 2021-08-21 04:21:38 | Unknown, China | |||||
511526 | 511526 | 2021-08-19 | China | Unknown | 10702 | 0 | 0 | 2021-08-20 04:21:33 | Unknown, China | |||||
2518005 | 2518005 | 2021-08-18 | China | Unknown | 10678 | 0 | 0 | 2021-08-19 04:21:15 | Unknown, China | |||||
245097 | 245097 | 2021-08-17 | China | Unknown | 10661 | 0 | 0 | 2021-08-18 04:21:35 | Unknown, China | |||||
1604060 | 1604060 | 2021-08-16 | China | Unknown | 10645 | 0 | 0 | 2021-08-17 04:21:49 | Unknown, 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]);