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 = "Fujian" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1176919 | 1176919 | 2020-03-18 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
1463496 | 1463496 | 2020-03-15 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
1526926 | 1526926 | 2020-03-19 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
2111121 | 2111121 | 2020-03-14 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
2127461 | 2127461 | 2020-03-11 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
2255150 | 2255150 | 2020-03-16 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
2282893 | 2282893 | 2020-03-12 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
3765299 | 3765299 | 2020-03-13 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
3891347 | 3891347 | 2020-03-17 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
3733987 | 3733987 | 2020-03-20 | China | Fujian | 299 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-20T02:43:09 | ||||
339698 | 339698 | 2020-03-21 | China | Fujian | 303 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-21T01:13:10 | ||||
2910615 | 2910615 | 2020-03-22 | China | Fujian | 307 | 1 | 295 | 11 | 26.0789 | 117.9874 | 3/22/20 7:20 | Fujian, China | ||
2147048 | 2147048 | 2020-03-23 | China | Fujian | 313 | 1 | 295 | 17 | 26.0789 | 117.9874 | 2020-03-23 00:50:24 | Fujian, China | ||
1478989 | 1478989 | 2020-03-24 | China | Fujian | 318 | 1 | 295 | 22 | 26.0789 | 117.9874 | 2020-03-24 01:27:08 | Fujian, China | ||
1132481 | 1132481 | 2020-03-25 | China | Fujian | 322 | 1 | 295 | 26 | 26.0789 | 117.9874 | 2020-03-25 06:43:02 | Fujian, China | ||
919078 | 919078 | 2020-03-26 | China | Fujian | 328 | 1 | 295 | 32 | 26.0789 | 117.9874 | 2020-03-26 01:21:08 | Fujian, China | ||
808985 | 808985 | 2020-03-27 | China | Fujian | 331 | 1 | 295 | 35 | 26.0789 | 117.9874 | 2020-03-27 01:08:02 | Fujian, China | ||
3946935 | 3946935 | 2020-03-28 | China | Fujian | 337 | 1 | 295 | 41 | 26.0789 | 117.9874 | 3/28/20 1:35 | Fujian, China | ||
2875599 | 2875599 | 2020-03-29 | China | Fujian | 338 | 1 | 295 | 42 | 26.0789 | 117.9874 | 3/29/20 0:57 | Fujian, China | ||
1872362 | 1872362 | 2020-03-30 | China | Fujian | 340 | 1 | 295 | 44 | 26.0789 | 117.9874 | 3/30/20 0:32 | Fujian, China | ||
3815810 | 3815810 | 2020-03-31 | China | Fujian | 343 | 1 | 295 | 47 | 26.0789 | 117.9874 | 2020-03-31 02:10:31 | Fujian, China | ||
3364717 | 3364717 | 2020-04-01 | China | Fujian | 345 | 1 | 298 | 46 | 26.0789 | 117.9874 | 2020-04-01 11:54:10 | Fujian, China | ||
3701513 | 3701513 | 2020-04-02 | China | Fujian | 345 | 1 | 299 | 45 | 26.0789 | 117.9874 | 4/2/20 1:38 | Fujian, China | ||
3740483 | 3740483 | 2020-04-03 | China | Fujian | 349 | 1 | 300 | 48 | 26.0789 | 117.9874 | 2020-04-03 02:47:58 | Fujian, China | ||
589028 | 589028 | 2020-04-05 | China | Fujian | 350 | 1 | 303 | 46 | 26.0789 | 117.9874 | 2020-04-05 01:58:42 | Fujian, China | ||
1750672 | 1750672 | 2020-04-04 | China | Fujian | 350 | 1 | 301 | 48 | 26.0789 | 117.9874 | 4/4/20 1:07 | Fujian, China | ||
3627340 | 3627340 | 2020-04-06 | China | Fujian | 350 | 1 | 305 | 44 | 26.0789 | 117.9874 | 4/6/20 1:14 | Fujian, China | ||
1250139 | 1250139 | 2020-04-10 | China | Fujian | 351 | 1 | 311 | 39 | 26.0789 | 117.9874 | 2020-04-10 01:01:27 | Fujian, China | ||
2566954 | 2566954 | 2020-04-11 | China | Fujian | 351 | 1 | 317 | 33 | 26.0789 | 117.9874 | 2020-04-11 01:53:14 | Fujian, China | ||
3021658 | 3021658 | 2020-04-07 | China | Fujian | 351 | 1 | 305 | 45 | 26.0789 | 117.9874 | 2020-04-07 00:55:26 | Fujian, China | ||
3561983 | 3561983 | 2020-04-08 | China | Fujian | 351 | 1 | 308 | 42 | 26.0789 | 117.9874 | 2020-04-08 12:26:31 | Fujian, China | ||
3949876 | 3949876 | 2020-04-09 | China | Fujian | 351 | 1 | 308 | 42 | 26.0789 | 117.9874 | 2020-04-08 12:26:31 | Fujian, China | ||
43091 | 43091 | 2020-04-13 | China | Fujian | 352 | 1 | 325 | 26 | 26.0789 | 117.9874 | 2020-04-13 09:36:31 | Fujian, China | ||
2578117 | 2578117 | 2020-04-12 | China | Fujian | 352 | 1 | 321 | 30 | 26.0789 | 117.9874 | 2020-04-12 02:25:00 | Fujian, China | ||
860078 | 860078 | 2020-04-15 | China | Fujian | 353 | 1 | 331 | 21 | 26.0789 | 117.9874 | 2020-04-15 01:53:31 | Fujian, China | ||
934184 | 934184 | 2020-04-16 | China | Fujian | 353 | 1 | 333 | 19 | 26.0789 | 117.9874 | 2020-04-16 02:06:52 | Fujian, China | ||
3337994 | 3337994 | 2020-04-14 | China | Fujian | 353 | 1 | 329 | 23 | 26.0789 | 117.9874 | 2020-04-14 01:59:13 | Fujian, China | ||
50190 | 50190 | 2020-04-17 | China | Fujian | 354 | 1 | 334 | 19 | 26.0789 | 117.9874 | 2020-04-17 00:50:50 | Fujian, China | ||
137354 | 137354 | 2020-04-29 | China | Fujian | 355 | 1 | 353 | 1 | 26.0789 | 117.9874 | 2020-04-30 02:32:27 | Fujian, China | ||
271568 | 271568 | 2020-04-28 | China | Fujian | 355 | 1 | 352 | 2 | 26.0789 | 117.9874 | 2020-04-29 02:32:29 | Fujian, China | ||
418718 | 418718 | 2020-04-18 | China | Fujian | 355 | 1 | 336 | 18 | 26.0789 | 117.9874 | 2020-04-18 00:51:42 | Fujian, China | ||
522256 | 522256 | 2020-04-21 | China | Fujian | 355 | 1 | 341 | 13 | 26.0789 | 117.9874 | 2020-04-21 01:21:43 | Fujian, China | ||
1199191 | 1199191 | 2020-04-22 | China | Fujian | 355 | 1 | 342 | 12 | 26.0789 | 117.9874 | 2020-04-22 02:32:25 | Fujian, China | ||
1385030 | 1385030 | 2020-04-19 | China | Fujian | 355 | 1 | 339 | 15 | 26.0789 | 117.9874 | 2020-04-19 02:06:27 | Fujian, China | ||
1459162 | 1459162 | 2020-04-24 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
2473338 | 2473338 | 2020-04-20 | China | Fujian | 355 | 1 | 339 | 15 | 26.0789 | 117.9874 | 2020-04-19 02:06:27 | Fujian, China | ||
2524748 | 2524748 | 2020-04-23 | China | Fujian | 355 | 1 | 346 | 8 | 26.0789 | 117.9874 | 2020-04-24 01:43:34 | Fujian, China | ||
3502761 | 3502761 | 2020-04-25 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
3589230 | 3589230 | 2020-04-27 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
3592412 | 3592412 | 2020-04-26 | China | Fujian | 355 | 1 | 349 | 5 | 26.0789 | 117.9874 | 2020-04-25 01:01:53 | Fujian, China | ||
114130 | 114130 | 2020-05-08 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-09 02:32:35 | Fujian, China | ||
228607 | 228607 | 2020-04-30 | China | Fujian | 356 | 1 | 353 | 2 | 26.0789 | 117.9874 | 2020-05-01 02:32:28 | Fujian, China | ||
268282 | 268282 | 2020-05-21 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-22 02:36:51 | Fujian, China | ||
875562 | 875562 | 2020-05-24 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-25 02:32:44 | Fujian, China | ||
997753 | 997753 | 2020-05-23 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-24 02:32:43 | Fujian, China | ||
1184126 | 1184126 | 2020-05-01 | China | Fujian | 356 | 1 | 353 | 2 | 26.0789 | 117.9874 | 2020-05-02 02:32:27 | Fujian, China | ||
1404391 | 1404391 | 2020-05-14 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-15 02:33:02 | Fujian, China | ||
1431865 | 1431865 | 2020-05-20 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-21 02:32:48 | Fujian, China | ||
1829501 | 1829501 | 2020-05-16 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-17 02:32:32 | Fujian, China | ||
1864776 | 1864776 | 2020-05-22 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-23 02:32:42 | Fujian, China | ||
1931834 | 1931834 | 2020-05-05 | China | Fujian | 356 | 1 | 353 | 2 | 26.0789 | 117.9874 | 2020-05-06 02:32:31 | Fujian, China | ||
2043232 | 2043232 | 2020-05-02 | China | Fujian | 356 | 1 | 353 | 2 | 26.0789 | 117.9874 | 2020-05-03 02:32:28 | Fujian, China | ||
2110794 | 2110794 | 2020-05-06 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-07 02:32:28 | Fujian, China | ||
2278556 | 2278556 | 2020-05-03 | China | Fujian | 356 | 1 | 353 | 2 | 26.0789 | 117.9874 | 2020-05-04 02:32:28 | Fujian, China | ||
2390135 | 2390135 | 2020-05-19 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-20 02:32:19 | Fujian, China | ||
2581391 | 2581391 | 2020-05-12 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-13 03:32:26 | Fujian, China | ||
2899081 | 2899081 | 2020-05-09 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-10 02:32:30 | Fujian, China | ||
3084697 | 3084697 | 2020-05-04 | China | Fujian | 356 | 1 | 353 | 2 | 26.0789 | 117.9874 | 2020-05-05 02:32:34 | Fujian, China | ||
3260873 | 3260873 | 2020-05-18 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-19 02:32:18 | Fujian, China | ||
3276217 | 3276217 | 2020-05-15 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-16 02:32:19 | Fujian, China | ||
3295573 | 3295573 | 2020-05-07 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-08 02:32:32 | Fujian, China | ||
3330925 | 3330925 | 2020-05-11 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-12 03:32:27 | Fujian, China | ||
3416267 | 3416267 | 2020-05-17 | China | Fujian | 356 | 1 | 355 | 0 | 26.0789 | 117.9874 | 2020-05-18 02:32:21 | Fujian, China | ||
3459540 | 3459540 | 2020-05-10 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-11 02:32:30 | Fujian, China | ||
3847184 | 3847184 | 2020-05-13 | China | Fujian | 356 | 1 | 354 | 1 | 26.0789 | 117.9874 | 2020-05-14 03:32:28 | Fujian, China | ||
1041152 | 1041152 | 2020-05-26 | China | Fujian | 357 | 1 | 355 | 1 | 26.0789 | 117.9874 | 2020-05-27 02:32:31 | Fujian, China | ||
1104882 | 1104882 | 2020-05-25 | China | Fujian | 357 | 1 | 355 | 1 | 26.0789 | 117.9874 | 2020-05-26 02:32:35 | Fujian, China | ||
805259 | 805259 | 2020-06-01 | China | Fujian | 358 | 1 | 356 | 1 | 26.0789 | 117.9874 | 2020-06-02 02:33:08 | Fujian, China | ||
1269646 | 1269646 | 2020-06-05 | China | Fujian | 358 | 1 | 356 | 1 | 26.0789 | 117.9874 | 2020-06-06 02:33:00 | Fujian, China | ||
1281125 | 1281125 | 2020-06-04 | China | Fujian | 358 | 1 | 356 | 1 | 26.0789 | 117.9874 | 2020-06-05 02:33:06 | Fujian, China | ||
1790317 | 1790317 | 2020-05-29 | China | Fujian | 358 | 1 | 355 | 2 | 26.0789 | 117.9874 | 2020-05-30 02:32:48 | Fujian, China | ||
1793883 | 1793883 | 2020-05-31 | China | Fujian | 358 | 1 | 355 | 2 | 26.0789 | 117.9874 | 2020-06-01 02:32:46 | Fujian, China | ||
2548189 | 2548189 | 2020-05-27 | China | Fujian | 358 | 1 | 355 | 2 | 26.0789 | 117.9874 | 2020-05-28 02:32:31 | Fujian, China | ||
2555722 | 2555722 | 2020-06-02 | China | Fujian | 358 | 1 | 356 | 1 | 26.0789 | 117.9874 | 2020-06-03 02:33:13 | Fujian, China | ||
2712197 | 2712197 | 2020-05-28 | China | Fujian | 358 | 1 | 355 | 2 | 26.0789 | 117.9874 | 2020-05-29 02:32:50 | Fujian, China | ||
3638776 | 3638776 | 2020-05-30 | China | Fujian | 358 | 1 | 355 | 2 | 26.0789 | 117.9874 | 2020-05-31 02:32:45 | Fujian, China | ||
3866680 | 3866680 | 2020-06-03 | China | Fujian | 358 | 1 | 356 | 1 | 26.0789 | 117.9874 | 2020-06-04 02:33:14 | Fujian, China | ||
217096 | 217096 | 2020-06-08 | China | Fujian | 359 | 1 | 356 | 2 | 26.0789 | 117.9874 | 2020-06-09 03:33:03 | Fujian, China | ||
573949 | 573949 | 2020-06-06 | China | Fujian | 359 | 1 | 356 | 2 | 26.0789 | 117.9874 | 2020-06-07 03:53:30 | Fujian, China | ||
1210669 | 1210669 | 2020-06-09 | China | Fujian | 359 | 1 | 356 | 2 | 26.0789 | 117.9874 | 2020-06-10 04:07:00 | Fujian, China | ||
2799893 | 2799893 | 2020-06-07 | China | Fujian | 359 | 1 | 356 | 2 | 26.0789 | 117.9874 | 2020-06-08 03:33:22 | Fujian, China | ||
2863820 | 2863820 | 2020-06-10 | China | Fujian | 360 | 1 | 356 | 3 | 26.0789 | 117.9874 | 2020-06-11 03:33:41 | Fujian, China | ||
737407 | 737407 | 2020-06-12 | China | Fujian | 361 | 1 | 356 | 4 | 26.0789 | 117.9874 | 2020-06-13 03:33:14 | Fujian, China | ||
1273377 | 1273377 | 2020-06-11 | China | Fujian | 361 | 1 | 356 | 4 | 26.0789 | 117.9874 | 2020-06-12 05:09:52 | Fujian, China | ||
3061087 | 3061087 | 2020-06-13 | China | Fujian | 361 | 1 | 356 | 4 | 26.0789 | 117.9874 | 2020-06-14 03:33:15 | Fujian, China | ||
287084 | 287084 | 2020-06-15 | China | Fujian | 362 | 1 | 356 | 5 | 26.0789 | 117.9874 | 2020-06-16 04:33:09 | Fujian, China | ||
1195758 | 1195758 | 2020-06-17 | China | Fujian | 362 | 1 | 356 | 5 | 26.0789 | 117.9874 | 2020-06-18 04:33:18 | Fujian, China | ||
1691406 | 1691406 | 2020-06-19 | China | Fujian | 362 | 1 | 357 | 4 | 26.0789 | 117.9874 | 2020-06-20 04:33:19 | Fujian, China | ||
1837035 | 1837035 | 2020-06-14 | China | Fujian | 362 | 1 | 356 | 5 | 26.0789 | 117.9874 | 2020-06-15 03:33:14 | Fujian, China | ||
2386521 | 2386521 | 2020-06-16 | China | Fujian | 362 | 1 | 356 | 5 | 26.0789 | 117.9874 | 2020-06-17 04:33:21 | Fujian, 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]);