johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where country_or_region = "Mainland China" and province_or_state = "Fujian" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3752842 | 3752842 | 2020-03-10 | Mainland China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-07T13:03:05 | ||||
657709 | 657709 | 2020-03-09 | Mainland China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-07T13:03:05 | ||||
1527223 | 1527223 | 2020-03-08 | Mainland China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-07T13:03:05 | ||||
62494 | 62494 | 2020-03-07 | Mainland China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-07T13:03:05 | ||||
3177498 | 3177498 | 2020-03-06 | Mainland China | Fujian | 296 | 1 | 284 | 26.0789 | 117.9874 | 2020-03-06T12:53:03 | ||||
40153 | 40153 | 2020-03-05 | Mainland China | Fujian | 296 | 1 | 277 | 26.0789 | 117.9874 | 2020-03-05T09:33:03 | ||||
98821 | 98821 | 2020-03-04 | Mainland China | Fujian | 296 | 1 | 270 | 26.0789 | 117.9874 | 2020-03-04T12:53:03 | ||||
261035 | 261035 | 2020-03-03 | Mainland China | Fujian | 296 | 1 | 260 | 26.0789 | 117.9874 | 2020-03-03T13:43:03 | ||||
1152651 | 1152651 | 2020-03-02 | Mainland China | Fujian | 296 | 1 | 255 | 26.0789 | 117.9874 | 2020-03-02T12:53:02 | ||||
562512 | 562512 | 2020-03-01 | Mainland China | Fujian | 296 | 1 | 247 | 26.0789 | 117.9874 | 2020-03-01T09:43:03 | ||||
3205801 | 3205801 | 2020-02-29 | Mainland China | Fujian | 296 | 1 | 243 | 26.0789 | 117.9874 | 2020-02-29T15:33:03 | ||||
2883924 | 2883924 | 2020-02-28 | Mainland China | Fujian | 296 | 1 | 235 | 26.0789 | 117.9874 | 2020-02-28T09:13:10 | ||||
617408 | 617408 | 2020-02-27 | Mainland China | Fujian | 296 | 1 | 228 | 26.0789 | 117.9874 | 2020-02-27T10:03:07 | ||||
2509764 | 2509764 | 2020-02-26 | Mainland China | Fujian | 294 | 1 | 218 | 26.0789 | 117.9874 | 2020-02-26T10:33:02 | ||||
479147 | 479147 | 2020-02-25 | Mainland China | Fujian | 294 | 1 | 199 | 26.0789 | 117.9874 | 2020-02-25T10:03:07 | ||||
3551210 | 3551210 | 2020-02-24 | Mainland China | Fujian | 293 | 1 | 183 | 26.0789 | 117.9874 | 2020-02-24T10:23:02 | ||||
3173354 | 3173354 | 2020-02-23 | Mainland China | Fujian | 293 | 1 | 170 | 26.0789 | 117.9874 | 2020-02-23T10:33:03 | ||||
1085643 | 1085643 | 2020-02-22 | Mainland China | Fujian | 293 | 1 | 162 | 26.0789 | 117.9874 | 2020-02-22T14:03:04 | ||||
2135724 | 2135724 | 2020-02-21 | Mainland China | Fujian | 293 | 1 | 149 | 26.0789 | 117.9874 | 2020-02-21T11:43:01 | ||||
2263466 | 2263466 | 2020-02-20 | Mainland China | Fujian | 293 | 1 | 126 | 26.0789 | 117.9874 | 2020-02-20T12:23:02 | ||||
1720058 | 1720058 | 2020-02-19 | Mainland China | Fujian | 293 | 0 | 112 | 26.0789 | 117.9874 | 2020-02-19T11:53:02 | ||||
1783090 | 1783090 | 2020-02-18 | Mainland China | Fujian | 292 | 0 | 93 | 26.0789 | 117.9874 | 2020-02-18T09:43:08 | ||||
1243364 | 1243364 | 2020-02-17 | Mainland China | Fujian | 290 | 0 | 90 | 26.0789 | 117.9874 | 2020-02-17T10:23:04 | ||||
1888717 | 1888717 | 2020-02-16 | Mainland China | Fujian | 287 | 0 | 82 | 26.0789 | 117.9874 | 2020-02-16T12:03:06 | ||||
107042 | 107042 | 2020-02-15 | Mainland China | Fujian | 285 | 0 | 71 | 26.0789 | 117.9874 | 2020-02-15T13:03:04 | ||||
1192461 | 1192461 | 2020-02-14 | Mainland China | Fujian | 281 | 0 | 63 | 26.0789 | 117.9874 | 2020-02-14T11:13:22 | ||||
1559667 | 1559667 | 2020-02-13 | Mainland China | Fujian | 279 | 0 | 57 | 26.0789 | 117.9874 | 2020-02-13T10:33:23 | ||||
2567257 | 2567257 | 2020-02-12 | Mainland China | Fujian | 272 | 0 | 53 | 26.0789 | 117.9874 | 2020-02-12T11:53:02 | ||||
3197716 | 3197716 | 2020-02-11 | Mainland China | Fujian | 267 | 0 | 45 | 26.0789 | 117.9874 | 2020-02-11T14:03:05 | ||||
3089015 | 3089015 | 2020-02-10 | Mainland China | Fujian | 261 | 0 | 39 | 26.0789 | 117.9874 | 2020-02-10T14:03:05 | ||||
3362384 | 3362384 | 2020-02-09 | Mainland China | Fujian | 250 | 0 | 35 | 26.0789 | 117.9874 | 2020-02-09T09:13:11 | ||||
1366054 | 1366054 | 2020-02-08 | Mainland China | Fujian | 239 | 0 | 24 | 26.0789 | 117.9874 | 2020-02-08T08:13:10 | ||||
3222013 | 3222013 | 2020-02-07 | Mainland China | Fujian | 224 | 0 | 20 | 26.0789 | 117.9874 | 2020-02-07T13:23:03 | ||||
566682 | 566682 | 2020-02-06 | Mainland China | Fujian | 215 | 0 | 14 | 26.0789 | 117.9874 | 2020-02-06T11:03:19 | ||||
2091674 | 2091674 | 2020-02-05 | Mainland China | Fujian | 205 | 0 | 11 | 26.0789 | 117.9874 | 2020-02-05T12:33:01 | ||||
3471891 | 3471891 | 2020-02-04 | Mainland China | Fujian | 194 | 0 | 3 | 26.0789 | 117.9874 | 2020-02-04T12:13:11 | ||||
2860555 | 2860555 | 2020-02-03 | Mainland China | Fujian | 179 | 0 | 1 | 26.0789 | 117.9874 | 2020-02-03T11:33:13 | ||||
2379241 | 2379241 | 2020-02-02 | Mainland China | Fujian | 159 | 0 | 0 | 26.0789 | 117.9874 | 2020-02-02T03:43:01 | ||||
3413153 | 3413153 | 2020-02-01 | Mainland China | Fujian | 144 | 0 | 0 | 26.0789 | 117.9874 | 2/1/2020 5:37 | ||||
3761188 | 3761188 | 2020-01-31 | Mainland China | Fujian | 120 | 0 | 0 | 26.0789 | 117.9874 | 1/31/2020 23:59 | ||||
1527503 | 1527503 | 2020-01-30 | Mainland China | Fujian | 101 | 0 | 0 | 26.0789 | 117.9874 | 1/30/20 16:00 | ||||
197851 | 197851 | 2020-01-29 | Mainland China | Fujian | 84 | 0 | 0 | 26.0789 | 117.9874 | 1/29/20 19:30 | ||||
1305764 | 1305764 | 2020-01-28 | Mainland China | Fujian | 80 | 0 | 0 | 26.0789 | 117.9874 | 1/28/20 23:00 | ||||
3753067 | 3753067 | 2020-01-27 | Mainland China | Fujian | 59 | 0 | 0 | 26.0789 | 117.9874 | 1/27/20 23:59 | ||||
415844 | 415844 | 2020-01-26 | Mainland China | Fujian | 35 | 0 | 0 | 26.0789 | 117.9874 | 1/26/20 16:00 | ||||
2938946 | 2938946 | 2020-01-25 | Mainland China | Fujian | 18 | 0 | 0 | 26.0789 | 117.9874 | 1/25/20 17:00 | ||||
197771 | 197771 | 2020-01-24 | Mainland China | Fujian | 10 | 0 | 0 | 26.0789 | 117.9874 | 1/24/20 17:00 | ||||
864380 | 864380 | 2020-01-23 | Mainland China | Fujian | 5 | 0 | 0 | 26.0789 | 117.9874 | 1/23/20 17:00 | ||||
1802343 | 1802343 | 2020-01-22 | Mainland China | Fujian | 1 | 0 | 0 | 26.0789 | 117.9874 | 1/22/2020 17:00 |
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]);