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 = "Jiangxi" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129 | 129 | 2021-12-02 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2021-12-03 04:23:05 | Jiangxi, China | |||
4145 | 4145 | 2021-10-28 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-10-29 04:22:03 | Jiangxi, China | |||
8149 | 8149 | 2020-10-25 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-10-26 04:25:02 | Jiangxi, China | ||
12156 | 12156 | 2021-01-26 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-01-27 05:23:41 | Jiangxi, China | ||
16170 | 16170 | 2021-09-18 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-09-19 04:21:34 | Jiangxi, China | |||
20185 | 20185 | 2021-05-28 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-05-29 04:20:41 | Jiangxi, China | ||
24200 | 24200 | 2022-03-20 | China | Jiangxi | 969 | 1 | 0 | 27.614 | 115.7221 | 2022-03-21 04:20:50 | Jiangxi, China | |||
28215 | 28215 | 2021-11-11 | China | Jiangxi | 954 | 1 | 0 | 27.614 | 115.7221 | 2021-11-12 04:22:01 | Jiangxi, China | |||
32231 | 32231 | 2021-08-25 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-08-26 04:21:28 | Jiangxi, China | |||
36245 | 36245 | 2021-04-12 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-04-13 04:20:37 | Jiangxi, China | ||
43112 | 43112 | 2020-04-13 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-04-10 01:22:42 | Jiangxi, China | ||
43507 | 43507 | 2021-11-02 | China | Jiangxi | 943 | 1 | 0 | 27.614 | 115.7221 | 2021-11-03 06:22:09 | Jiangxi, China | |||
50211 | 50211 | 2020-04-17 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-04-10 01:22:42 | Jiangxi, China | ||
50606 | 50606 | 2021-05-29 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-05-30 04:20:55 | Jiangxi, China | ||
54620 | 54620 | 2021-03-07 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-03-08 05:24:48 | Jiangxi, China | ||
61925 | 61925 | 2020-07-23 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-07-24 05:30:40 | Jiangxi, China | ||
62861 | 62861 | 2022-11-12 | China | Jiangxi | 1506 | 1 | 0 | 27.614 | 115.7221 | 2022-11-13 04:21:14 | Jiangxi, China | |||
66876 | 66876 | 2021-09-01 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-09-02 04:21:15 | Jiangxi, China | |||
70890 | 70890 | 2022-02-07 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-02-08 04:21:15 | Jiangxi, China | |||
74906 | 74906 | 2020-12-03 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-12-04 05:27:27 | Jiangxi, China | ||
78905 | 78905 | 2020-10-14 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-10-15 04:24:28 | Jiangxi, China | ||
82910 | 82910 | 2021-05-25 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-05-26 04:20:35 | Jiangxi, China | ||
86924 | 86924 | 2021-11-09 | China | Jiangxi | 953 | 1 | 0 | 27.614 | 115.7221 | 2021-11-10 04:21:38 | Jiangxi, China | |||
90941 | 90941 | 2022-07-23 | China | Jiangxi | 1436 | 1 | 0 | 27.614 | 115.7221 | 2022-07-24 04:20:47 | Jiangxi, China | |||
98269 | 98269 | 2020-08-04 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-08-05 04:34:43 | Jiangxi, China | ||
99125 | 99125 | 2022-01-14 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-01-15 04:21:07 | Jiangxi, China | |||
103141 | 103141 | 2021-08-15 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-08-16 04:21:31 | Jiangxi, China | |||
107266 | 107266 | 2021-06-19 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-06-20 04:21:48 | Jiangxi, China | ||
114151 | 114151 | 2020-05-08 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-05-09 02:32:35 | Jiangxi, China | ||
114551 | 114551 | 2022-09-06 | China | Jiangxi | 1486 | 1 | 0 | 27.614 | 115.7221 | 2022-09-07 04:20:59 | Jiangxi, China | |||
121862 | 121862 | 2020-07-19 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-07-20 05:34:40 | Jiangxi, China | ||
122521 | 122521 | 2020-11-18 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-11-19 05:25:23 | Jiangxi, China | ||
126532 | 126532 | 2022-01-09 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-01-10 04:22:07 | Jiangxi, China | |||
130549 | 130549 | 2022-10-04 | China | Jiangxi | 1495 | 1 | 0 | 27.614 | 115.7221 | 2022-10-05 04:23:06 | Jiangxi, China | |||
137375 | 137375 | 2020-04-29 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-04-30 02:32:27 | Jiangxi, China | ||
137770 | 137770 | 2021-12-04 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2021-12-05 04:22:25 | Jiangxi, China | |||
141787 | 141787 | 2022-07-09 | China | Jiangxi | 1400 | 1 | 0 | 27.614 | 115.7221 | 2022-07-10 04:20:54 | Jiangxi, China | |||
145790 | 145790 | 2020-08-15 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-08-16 04:27:42 | Jiangxi, China | ||
149783 | 149783 | 2021-11-29 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2021-11-30 04:22:53 | Jiangxi, China | |||
153799 | 153799 | 2021-01-08 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-01-09 05:22:18 | Jiangxi, China | ||
157812 | 157812 | 2022-03-29 | China | Jiangxi | 1035 | 1 | 0 | 27.614 | 115.7221 | 2022-03-30 04:20:45 | Jiangxi, China | |||
161827 | 161827 | 2021-11-19 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2021-11-20 04:22:17 | Jiangxi, China | |||
165844 | 165844 | 2022-06-21 | China | Jiangxi | 1384 | 1 | 0 | 27.614 | 115.7221 | 2022-06-22 04:20:54 | Jiangxi, China | |||
169859 | 169859 | 2021-04-16 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-04-17 04:20:40 | Jiangxi, China | ||
177180 | 177180 | 2020-07-27 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-07-28 04:58:43 | Jiangxi, China | ||
177841 | 177841 | 2021-09-02 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-09-03 04:21:20 | Jiangxi, China | |||
181855 | 181855 | 2021-02-21 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-02-22 05:24:21 | Jiangxi, China | ||
185870 | 185870 | 2022-02-13 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-02-14 04:20:51 | Jiangxi, China | |||
189885 | 189885 | 2021-01-11 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-01-12 05:22:15 | Jiangxi, China | ||
193885 | 193885 | 2020-08-31 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-09-01 04:28:31 | Jiangxi, China | ||
198058 | 198058 | 2022-10-19 | China | Jiangxi | 1495 | 1 | 0 | 27.614 | 115.7221 | 2022-10-20 04:22:59 | Jiangxi, China | |||
202073 | 202073 | 2020-12-25 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-12-26 05:22:28 | Jiangxi, China | ||
206072 | 206072 | 2020-08-19 | China | Jiangxi | 935 | 1 | 931 | 3 | 27.614 | 115.7221 | 2020-08-20 04:27:43 | Jiangxi, China | ||
210057 | 210057 | 2020-10-29 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-10-30 04:24:49 | Jiangxi, China | ||
217150 | 217150 | 2020-06-08 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-06-09 03:33:03 | Jiangxi, China | ||
217779 | 217779 | 2022-12-26 | China | Jiangxi | 1971 | 1 | 0 | 27.614 | 115.7221 | 2022-12-27 04:21:07 | Jiangxi, China | |||
221795 | 221795 | 2022-05-09 | China | Jiangxi | 1383 | 1 | 0 | 27.614 | 115.7221 | 2022-05-10 04:20:50 | Jiangxi, China | |||
228628 | 228628 | 2020-04-30 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-05-01 02:32:28 | Jiangxi, China | ||
229026 | 229026 | 2022-05-31 | China | Jiangxi | 1383 | 1 | 0 | 27.614 | 115.7221 | 2022-06-01 04:20:55 | Jiangxi, China | |||
233042 | 233042 | 2022-02-11 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-02-12 04:21:06 | Jiangxi, China | |||
237057 | 237057 | 2021-01-18 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-01-19 05:22:15 | Jiangxi, China | ||
241070 | 241070 | 2021-04-02 | China | Jiangxi | 937 | 1 | 935 | 1 | 27.614 | 115.7221 | 2021-04-03 04:20:44 | Jiangxi, China | ||
245084 | 245084 | 2021-08-17 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-08-18 04:21:35 | Jiangxi, China | |||
249098 | 249098 | 2021-09-04 | China | Jiangxi | 937 | 1 | 0 | 27.614 | 115.7221 | 2021-09-05 04:21:33 | Jiangxi, China | |||
253113 | 253113 | 2022-09-08 | China | Jiangxi | 1489 | 1 | 0 | 27.614 | 115.7221 | 2022-09-09 04:21:11 | Jiangxi, China | |||
257129 | 257129 | 2022-12-10 | China | Jiangxi | 1545 | 1 | 0 | 27.614 | 115.7221 | 2022-12-11 04:20:50 | Jiangxi, China | |||
261332 | 261332 | 2022-03-15 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-03-16 04:20:50 | Jiangxi, China | |||
268311 | 268311 | 2020-05-21 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-05-22 02:36:51 | Jiangxi, China | ||
271589 | 271589 | 2020-04-28 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2020-04-29 02:32:29 | Jiangxi, China | ||
271972 | 271972 | 2020-11-10 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-11-11 05:25:30 | Jiangxi, China | ||
275982 | 275982 | 2021-11-03 | China | Jiangxi | 943 | 1 | 0 | 27.614 | 115.7221 | 2021-11-04 04:22:20 | Jiangxi, China | |||
279998 | 279998 | 2021-02-24 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-02-25 05:24:57 | Jiangxi, China | ||
287146 | 287146 | 2020-06-15 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-06-16 04:33:09 | Jiangxi, China | ||
287795 | 287795 | 2021-10-31 | China | Jiangxi | 939 | 1 | 0 | 27.614 | 115.7221 | 2021-11-01 04:22:01 | Jiangxi, China | |||
291812 | 291812 | 2022-11-15 | China | Jiangxi | 1506 | 1 | 0 | 27.614 | 115.7221 | 2022-11-16 04:21:09 | Jiangxi, China | |||
295827 | 295827 | 2021-07-15 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-07-16 04:21:22 | Jiangxi, China | ||
303018 | 303018 | 2020-07-01 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-07-02 04:33:46 | Jiangxi, China | ||
303668 | 303668 | 2022-04-16 | China | Jiangxi | 1071 | 1 | 0 | 27.614 | 115.7221 | 2022-04-17 04:20:59 | Jiangxi, China | |||
307684 | 307684 | 2022-12-13 | China | Jiangxi | 1547 | 1 | 0 | 27.614 | 115.7221 | 2022-12-14 04:21:04 | Jiangxi, China | |||
311700 | 311700 | 2022-11-13 | China | Jiangxi | 1506 | 1 | 0 | 27.614 | 115.7221 | 2022-11-14 04:21:09 | Jiangxi, China | |||
315716 | 315716 | 2022-02-12 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-02-13 04:21:00 | Jiangxi, China | |||
319732 | 319732 | 2022-10-30 | China | Jiangxi | 1495 | 1 | 0 | 27.614 | 115.7221 | 2022-10-31 04:21:36 | Jiangxi, China | |||
326957 | 326957 | 2020-07-20 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-07-21 04:38:46 | Jiangxi, China | ||
327706 | 327706 | 2022-12-27 | China | Jiangxi | 1971 | 1 | 0 | 27.614 | 115.7221 | 2022-12-28 04:21:04 | Jiangxi, China | |||
331721 | 331721 | 2021-08-04 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-08-05 04:21:51 | Jiangxi, China | ||
335736 | 335736 | 2022-03-18 | China | Jiangxi | 962 | 1 | 0 | 27.614 | 115.7221 | 2022-03-19 04:20:47 | Jiangxi, China | |||
339651 | 339651 | 2020-03-21 | China | Jiangxi | 935 | 1 | 934 | 27.614 | 115.7221 | 2020-03-12T02:13:04 | ||||
340091 | 340091 | 2021-02-03 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-02-04 05:22:26 | Jiangxi, China | ||
344093 | 344093 | 2020-09-14 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-09-15 03:22:50 | Jiangxi, China | ||
348096 | 348096 | 2022-12-14 | China | Jiangxi | 1547 | 1 | 0 | 27.614 | 115.7221 | 2022-12-15 04:20:58 | Jiangxi, China | |||
352111 | 352111 | 2021-03-11 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2021-03-12 05:26:50 | Jiangxi, China | ||
356126 | 356126 | 2022-03-11 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-03-12 04:20:50 | Jiangxi, China | |||
360142 | 360142 | 2022-05-07 | China | Jiangxi | 1383 | 1 | 0 | 27.614 | 115.7221 | 2022-05-08 04:20:49 | Jiangxi, China | |||
367366 | 367366 | 2020-07-16 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-07-17 04:34:50 | Jiangxi, China | ||
371334 | 371334 | 2020-08-08 | China | Jiangxi | 932 | 1 | 931 | 0 | 27.614 | 115.7221 | 2020-08-09 04:34:54 | Jiangxi, China | ||
371996 | 371996 | 2022-09-13 | China | Jiangxi | 1493 | 1 | 0 | 27.614 | 115.7221 | 2022-09-14 04:20:44 | Jiangxi, China | |||
375999 | 375999 | 2020-11-06 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-11-07 05:24:52 | Jiangxi, China | ||
380008 | 380008 | 2021-04-30 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-05-01 04:20:47 | Jiangxi, China | ||
384023 | 384023 | 2022-09-23 | China | Jiangxi | 1495 | 1 | 0 | 27.614 | 115.7221 | 2022-09-24 04:21:40 | Jiangxi, China | |||
388038 | 388038 | 2021-04-04 | China | Jiangxi | 937 | 1 | 936 | 0 | 27.614 | 115.7221 | 2021-04-05 04:20:35 | Jiangxi, 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]);