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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2728807 | 2728807 | 2020-09-15 | China | Fujian | 392 | 1 | 377 | 14 | 26.0789 | 117.9874 | 2020-09-16 04:22:53 | Fujian, China | ||
344079 | 344079 | 2020-09-14 | China | Fujian | 390 | 1 | 377 | 12 | 26.0789 | 117.9874 | 2020-09-15 03:22:50 | Fujian, China | ||
2868518 | 2868518 | 2020-09-13 | China | Fujian | 390 | 1 | 376 | 13 | 26.0789 | 117.9874 | 2020-09-14 04:26:00 | Fujian, China | ||
546557 | 546557 | 2020-09-12 | China | Fujian | 388 | 1 | 376 | 11 | 26.0789 | 117.9874 | 2020-09-13 04:30:52 | Fujian, China | ||
1444386 | 1444386 | 2020-09-11 | China | Fujian | 388 | 1 | 375 | 12 | 26.0789 | 117.9874 | 2020-09-12 04:25:05 | Fujian, China | ||
1172987 | 1172987 | 2020-09-10 | China | Fujian | 387 | 1 | 374 | 12 | 26.0789 | 117.9874 | 2020-09-11 04:46:23 | Fujian, China | ||
2171352 | 2171352 | 2020-09-09 | China | Fujian | 387 | 1 | 373 | 13 | 26.0789 | 117.9874 | 2020-09-10 04:29:01 | Fujian, China | ||
1243561 | 1243561 | 2020-09-08 | China | Fujian | 387 | 1 | 372 | 14 | 26.0789 | 117.9874 | 2020-09-09 04:28:48 | Fujian, China | ||
427140 | 427140 | 2020-09-07 | China | Fujian | 387 | 1 | 372 | 14 | 26.0789 | 117.9874 | 2020-09-08 04:28:25 | Fujian, China | ||
3161425 | 3161425 | 2020-09-06 | China | Fujian | 386 | 1 | 372 | 13 | 26.0789 | 117.9874 | 2020-09-07 04:28:30 | Fujian, China | ||
813380 | 813380 | 2020-09-05 | China | Fujian | 386 | 1 | 372 | 13 | 26.0789 | 117.9874 | 2020-09-06 04:28:33 | Fujian, China | ||
2661580 | 2661580 | 2020-09-04 | China | Fujian | 385 | 1 | 370 | 14 | 26.0789 | 117.9874 | 2020-09-05 04:28:19 | Fujian, China | ||
1354120 | 1354120 | 2020-09-03 | China | Fujian | 384 | 1 | 370 | 13 | 26.0789 | 117.9874 | 2020-09-04 04:28:26 | Fujian, China | ||
1105357 | 1105357 | 2020-09-02 | China | Fujian | 383 | 1 | 369 | 13 | 26.0789 | 117.9874 | 2020-09-03 04:28:22 | Fujian, China | ||
2059686 | 2059686 | 2020-09-01 | China | Fujian | 383 | 1 | 369 | 13 | 26.0789 | 117.9874 | 2020-09-02 04:28:25 | Fujian, China | ||
193871 | 193871 | 2020-08-31 | China | Fujian | 383 | 1 | 368 | 14 | 26.0789 | 117.9874 | 2020-09-01 04:28:31 | Fujian, China | ||
3931830 | 3931830 | 2020-08-30 | China | Fujian | 382 | 1 | 366 | 15 | 26.0789 | 117.9874 | 2020-08-31 04:28:27 | Fujian, China | ||
609492 | 609492 | 2020-08-29 | China | Fujian | 380 | 1 | 366 | 13 | 26.0789 | 117.9874 | 2020-08-30 04:28:22 | Fujian, China | ||
1522987 | 1522987 | 2020-08-28 | China | Fujian | 378 | 1 | 366 | 11 | 26.0789 | 117.9874 | 2020-08-29 04:28:19 | Fujian, China | ||
2509988 | 2509988 | 2020-08-27 | China | Fujian | 376 | 1 | 366 | 9 | 26.0789 | 117.9874 | 2020-08-28 04:28:11 | Fujian, China | ||
1996448 | 1996448 | 2020-08-26 | China | Fujian | 375 | 1 | 366 | 8 | 26.0789 | 117.9874 | 2020-08-27 04:28:15 | Fujian, China | ||
3562372 | 3562372 | 2020-08-25 | China | Fujian | 375 | 1 | 365 | 9 | 26.0789 | 117.9874 | 2020-08-26 04:28:11 | Fujian, China | ||
2991076 | 2991076 | 2020-08-24 | China | Fujian | 375 | 1 | 365 | 9 | 26.0789 | 117.9874 | 2020-08-25 04:28:02 | Fujian, China | ||
2215471 | 2215471 | 2020-08-23 | China | Fujian | 375 | 1 | 365 | 9 | 26.0789 | 117.9874 | 2020-08-24 04:27:56 | Fujian, China | ||
2299253 | 2299253 | 2020-08-22 | China | Fujian | 372 | 1 | 365 | 6 | 26.0789 | 117.9874 | 2020-08-23 04:27:48 | Fujian, China | ||
1479360 | 1479360 | 2020-08-21 | China | Fujian | 371 | 1 | 365 | 5 | 26.0789 | 117.9874 | 2020-08-22 04:27:49 | Fujian, China | ||
3484109 | 3484109 | 2020-08-20 | China | Fujian | 370 | 1 | 365 | 4 | 26.0789 | 117.9874 | 2020-08-21 04:27:41 | Fujian, China | ||
206058 | 206058 | 2020-08-19 | China | Fujian | 370 | 1 | 365 | 4 | 26.0789 | 117.9874 | 2020-08-20 04:27:43 | Fujian, China | ||
3177812 | 3177812 | 2020-08-18 | China | Fujian | 370 | 1 | 365 | 4 | 26.0789 | 117.9874 | 2020-08-19 04:27:00 | Fujian, China | ||
837416 | 837416 | 2020-08-17 | China | Fujian | 370 | 1 | 365 | 4 | 26.0789 | 117.9874 | 2020-08-18 04:27:56 | Fujian, China | ||
1555774 | 1555774 | 2020-08-16 | China | Fujian | 370 | 1 | 365 | 4 | 26.0789 | 117.9874 | 2020-08-17 04:27:20 | Fujian, China | ||
145776 | 145776 | 2020-08-15 | China | Fujian | 369 | 1 | 365 | 3 | 26.0789 | 117.9874 | 2020-08-16 04:27:42 | Fujian, China | ||
1612051 | 1612051 | 2020-08-14 | China | Fujian | 368 | 1 | 365 | 2 | 26.0789 | 117.9874 | 2020-08-15 04:27:31 | Fujian, China | ||
582635 | 582635 | 2020-08-13 | China | Fujian | 368 | 1 | 365 | 2 | 26.0789 | 117.9874 | 2020-08-14 04:51:19 | Fujian, China | ||
3531254 | 3531254 | 2020-08-12 | China | Fujian | 368 | 1 | 364 | 3 | 26.0789 | 117.9874 | 2020-08-13 04:29:15 | Fujian, China | ||
662103 | 662103 | 2020-08-11 | China | Fujian | 368 | 1 | 363 | 4 | 26.0789 | 117.9874 | 2020-08-12 04:27:29 | Fujian, China | ||
1920293 | 1920293 | 2020-08-10 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-11 04:35:08 | Fujian, China | ||
3923102 | 3923102 | 2020-08-09 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-10 04:34:55 | Fujian, China | ||
371270 | 371270 | 2020-08-08 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-09 04:34:54 | Fujian, China | ||
458454 | 458454 | 2020-08-07 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-08 04:34:53 | Fujian, China | ||
3612139 | 3612139 | 2020-08-06 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-07 04:35:11 | Fujian, China | ||
3792969 | 3792969 | 2020-08-05 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-06 04:35:02 | Fujian, China | ||
98205 | 98205 | 2020-08-04 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-05 04:34:43 | Fujian, China | ||
2740088 | 2740088 | 2020-08-03 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-04 04:41:59 | Fujian, China | ||
2807840 | 2807840 | 2020-08-02 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-03 04:34:35 | Fujian, China | ||
753408 | 753408 | 2020-08-01 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-02 04:34:47 | Fujian, China | ||
3264573 | 3264573 | 2020-07-31 | China | Fujian | 366 | 1 | 363 | 2 | 26.0789 | 117.9874 | 2020-08-01 04:36:27 | Fujian, China | ||
1928280 | 1928280 | 2020-07-30 | China | Fujian | 366 | 1 | 363 | 2 | 26.0789 | 117.9874 | 2020-07-31 04:35:18 | Fujian, China | ||
2958448 | 2958448 | 2020-07-29 | China | Fujian | 366 | 1 | 362 | 3 | 26.0789 | 117.9874 | 2020-07-30 04:35:05 | Fujian, China | ||
3185064 | 3185064 | 2020-07-28 | China | Fujian | 366 | 1 | 361 | 4 | 26.0789 | 117.9874 | 2020-07-29 04:35:11 | Fujian, China | ||
177116 | 177116 | 2020-07-27 | China | Fujian | 366 | 1 | 361 | 4 | 26.0789 | 117.9874 | 2020-07-28 04:58:43 | Fujian, China | ||
442429 | 442429 | 2020-07-26 | China | Fujian | 366 | 1 | 361 | 4 | 26.0789 | 117.9874 | 2020-07-27 04:35:02 | Fujian, China | ||
1502673 | 1502673 | 2020-07-25 | China | Fujian | 365 | 1 | 361 | 3 | 26.0789 | 117.9874 | 2020-07-26 04:35:00 | Fujian, China | ||
2563643 | 2563643 | 2020-07-24 | China | Fujian | 364 | 1 | 361 | 2 | 26.0789 | 117.9874 | 2020-07-25 04:47:39 | Fujian, China | ||
61865 | 61865 | 2020-07-23 | China | Fujian | 364 | 1 | 361 | 2 | 26.0789 | 117.9874 | 2020-07-24 05:30:40 | Fujian, China | ||
844663 | 844663 | 2020-07-22 | China | Fujian | 364 | 1 | 361 | 2 | 26.0789 | 117.9874 | 2020-07-23 05:15:04 | Fujian, China | ||
1707402 | 1707402 | 2020-07-21 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-22 04:34:42 | Fujian, China | ||
326893 | 326893 | 2020-07-20 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-21 04:38:46 | Fujian, China | ||
121798 | 121798 | 2020-07-19 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-20 05:34:40 | Fujian, China | ||
3205187 | 3205187 | 2020-07-18 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-19 04:34:58 | Fujian, China | ||
2708489 | 2708489 | 2020-07-17 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-18 04:34:45 | Fujian, China | ||
367305 | 367305 | 2020-07-16 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-17 04:34:50 | Fujian, China | ||
2747973 | 2747973 | 2020-07-15 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-16 04:44:59 | Fujian, China | ||
2158617 | 2158617 | 2020-07-14 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-15 04:34:39 | Fujian, China | ||
3491258 | 3491258 | 2020-07-13 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-14 04:34:46 | Fujian, China | ||
3737520 | 3737520 | 2020-07-12 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-13 04:43:04 | Fujian, China | ||
3435915 | 3435915 | 2020-07-11 | China | Fujian | 363 | 1 | 361 | 1 | 26.0789 | 117.9874 | 2020-07-12 04:34:30 | Fujian, China | ||
3237413 | 3237413 | 2020-07-10 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-11 04:34:26 | Fujian, China | ||
1005398 | 1005398 | 2020-07-09 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-10 04:34:24 | Fujian, China | ||
2222614 | 2222614 | 2020-07-08 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-09 04:34:23 | Fujian, China | ||
887223 | 887223 | 2020-07-07 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-08 05:33:48 | Fujian, China | ||
2684783 | 2684783 | 2020-07-06 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-07 04:34:00 | Fujian, China | ||
415248 | 415248 | 2020-07-05 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-06 04:33:57 | Fujian, China | ||
529810 | 529810 | 2020-07-04 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-05 04:33:46 | Fujian, China | ||
2234471 | 2234471 | 2020-07-03 | China | Fujian | 363 | 1 | 360 | 2 | 26.0789 | 117.9874 | 2020-07-04 04:33:51 | Fujian, China | ||
3045265 | 3045265 | 2020-07-02 | China | Fujian | 363 | 1 | 359 | 3 | 26.0789 | 117.9874 | 2020-07-03 04:33:54 | Fujian, China | ||
302956 | 302956 | 2020-07-01 | China | Fujian | 363 | 1 | 359 | 3 | 26.0789 | 117.9874 | 2020-07-02 04:33:46 | Fujian, China | ||
2974334 | 2974334 | 2020-06-30 | China | Fujian | 363 | 1 | 359 | 3 | 26.0789 | 117.9874 | 2020-07-01 04:33:52 | Fujian, China | ||
2632811 | 2632811 | 2020-06-29 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-30 04:33:48 | Fujian, China | ||
2306374 | 2306374 | 2020-06-28 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-29 04:33:44 | Fujian, China | ||
2039709 | 2039709 | 2020-06-27 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-28 04:34:04 | Fujian, China | ||
1135990 | 1135990 | 2020-06-26 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-27 04:33:35 | Fujian, China | ||
2624977 | 2624977 | 2020-06-25 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-26 04:33:43 | Fujian, China | ||
2700617 | 2700617 | 2020-06-24 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-25 05:26:54 | Fujian, China | ||
1522302 | 1522302 | 2020-06-23 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-24 04:33:28 | Fujian, China | ||
1510496 | 1510496 | 2020-06-22 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-23 04:33:22 | Fujian, China | ||
3249235 | 3249235 | 2020-06-21 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-22 04:33:20 | Fujian, China | ||
2437828 | 2437828 | 2020-06-20 | China | Fujian | 363 | 1 | 357 | 5 | 26.0789 | 117.9874 | 2020-06-21 04:33:19 | 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 | ||
3682555 | 3682555 | 2020-06-18 | China | Fujian | 362 | 1 | 357 | 4 | 26.0789 | 117.9874 | 2020-06-19 04:33:17 | 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 | ||
2386521 | 2386521 | 2020-06-16 | China | Fujian | 362 | 1 | 356 | 5 | 26.0789 | 117.9874 | 2020-06-17 04:33:21 | 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 | ||
1837035 | 1837035 | 2020-06-14 | China | Fujian | 362 | 1 | 356 | 5 | 26.0789 | 117.9874 | 2020-06-15 03:33:14 | 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 | ||
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 | ||
2863820 | 2863820 | 2020-06-10 | China | Fujian | 360 | 1 | 356 | 3 | 26.0789 | 117.9874 | 2020-06-11 03:33:41 | 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 | ||
217096 | 217096 | 2020-06-08 | China | Fujian | 359 | 1 | 356 | 2 | 26.0789 | 117.9874 | 2020-06-09 03:33:03 | 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]);