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 = "Shaanxi" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181861 | 181861 | 2021-02-21 | China | Shaanxi | 547 | 3 | 534 | 10 | 35.1917 | 108.8701 | 2021-02-22 05:24:21 | Shaanxi, China | ||
742135 | 742135 | 2021-02-20 | China | Shaanxi | 547 | 3 | 534 | 10 | 35.1917 | 108.8701 | 2021-02-21 05:24:33 | Shaanxi, China | ||
471233 | 471233 | 2021-02-19 | China | Shaanxi | 547 | 3 | 534 | 10 | 35.1917 | 108.8701 | 2021-02-20 05:22:51 | Shaanxi, China | ||
1152943 | 1152943 | 2021-02-18 | China | Shaanxi | 547 | 3 | 534 | 10 | 35.1917 | 108.8701 | 2021-02-19 05:24:16 | Shaanxi, China | ||
3600863 | 3600863 | 2021-02-17 | China | Shaanxi | 547 | 3 | 532 | 12 | 35.1917 | 108.8701 | 2021-02-18 05:22:58 | Shaanxi, China | ||
3049998 | 3049998 | 2021-02-16 | China | Shaanxi | 547 | 3 | 531 | 13 | 35.1917 | 108.8701 | 2021-02-17 05:23:10 | Shaanxi, China | ||
1338097 | 1338097 | 2021-02-15 | China | Shaanxi | 547 | 3 | 531 | 13 | 35.1917 | 108.8701 | 2021-02-16 05:24:38 | Shaanxi, China | ||
2283248 | 2283248 | 2021-02-14 | China | Shaanxi | 545 | 3 | 531 | 11 | 35.1917 | 108.8701 | 2021-02-15 05:24:49 | Shaanxi, China | ||
2677648 | 2677648 | 2021-02-13 | China | Shaanxi | 544 | 3 | 530 | 11 | 35.1917 | 108.8701 | 2021-02-14 05:23:43 | Shaanxi, China | ||
3539281 | 3539281 | 2021-02-12 | China | Shaanxi | 543 | 3 | 529 | 11 | 35.1917 | 108.8701 | 2021-02-13 05:22:12 | Shaanxi, China | ||
2637544 | 2637544 | 2021-02-11 | China | Shaanxi | 543 | 3 | 529 | 11 | 35.1917 | 108.8701 | 2021-02-12 05:23:29 | Shaanxi, China | ||
3978399 | 3978399 | 2021-02-10 | China | Shaanxi | 543 | 3 | 529 | 11 | 35.1917 | 108.8701 | 2021-02-11 05:23:55 | Shaanxi, China | ||
1527719 | 1527719 | 2021-02-09 | China | Shaanxi | 543 | 3 | 524 | 16 | 35.1917 | 108.8701 | 2021-02-10 05:22:41 | Shaanxi, China | ||
613510 | 613510 | 2021-02-08 | China | Shaanxi | 542 | 3 | 519 | 20 | 35.1917 | 108.8701 | 2021-02-09 05:23:30 | Shaanxi, China | ||
1672279 | 1672279 | 2021-02-07 | China | Shaanxi | 542 | 3 | 517 | 22 | 35.1917 | 108.8701 | 2021-02-08 05:22:39 | Shaanxi, China | ||
974740 | 974740 | 2021-02-06 | China | Shaanxi | 542 | 3 | 516 | 23 | 35.1917 | 108.8701 | 2021-02-07 05:23:00 | Shaanxi, China | ||
1587998 | 1587998 | 2021-02-05 | China | Shaanxi | 542 | 3 | 516 | 23 | 35.1917 | 108.8701 | 2021-02-06 05:23:55 | Shaanxi, China | ||
790205 | 790205 | 2021-02-04 | China | Shaanxi | 541 | 3 | 516 | 22 | 35.1917 | 108.8701 | 2021-02-05 05:22:38 | Shaanxi, China | ||
340097 | 340097 | 2021-02-03 | China | Shaanxi | 541 | 3 | 515 | 23 | 35.1917 | 108.8701 | 2021-02-04 05:22:26 | Shaanxi, China | ||
1684323 | 1684323 | 2021-02-02 | China | Shaanxi | 541 | 3 | 512 | 26 | 35.1917 | 108.8701 | 2021-02-03 05:22:52 | Shaanxi, China | ||
1676293 | 1676293 | 2021-02-01 | China | Shaanxi | 540 | 3 | 512 | 25 | 35.1917 | 108.8701 | 2021-02-02 05:22:49 | Shaanxi, China | ||
1459581 | 1459581 | 2021-01-31 | China | Shaanxi | 539 | 3 | 511 | 25 | 35.1917 | 108.8701 | 2021-02-01 05:22:53 | Shaanxi, China | ||
2211489 | 2211489 | 2021-01-30 | China | Shaanxi | 539 | 3 | 511 | 25 | 35.1917 | 108.8701 | 2021-01-31 05:22:42 | Shaanxi, China | ||
1896976 | 1896976 | 2021-01-29 | China | Shaanxi | 537 | 3 | 511 | 23 | 35.1917 | 108.8701 | 2021-01-30 05:22:49 | Shaanxi, China | ||
2481792 | 2481792 | 2021-01-28 | China | Shaanxi | 536 | 3 | 511 | 22 | 35.1917 | 108.8701 | 2021-01-29 05:22:23 | Shaanxi, China | ||
3153427 | 3153427 | 2021-01-27 | China | Shaanxi | 536 | 3 | 510 | 23 | 35.1917 | 108.8701 | 2021-01-28 05:22:24 | Shaanxi, China | ||
12162 | 12162 | 2021-01-26 | China | Shaanxi | 535 | 3 | 509 | 23 | 35.1917 | 108.8701 | 2021-01-27 05:23:41 | Shaanxi, China | ||
2567486 | 2567486 | 2021-01-25 | China | Shaanxi | 535 | 3 | 508 | 24 | 35.1917 | 108.8701 | 2021-01-26 05:22:02 | Shaanxi, China | ||
1759118 | 1759118 | 2021-01-24 | China | Shaanxi | 534 | 3 | 508 | 23 | 35.1917 | 108.8701 | 2021-01-25 05:22:16 | Shaanxi, China | ||
2426725 | 2426725 | 2021-01-23 | China | Shaanxi | 534 | 3 | 505 | 26 | 35.1917 | 108.8701 | 2021-01-24 05:22:35 | Shaanxi, China | ||
2466627 | 2466627 | 2021-01-22 | China | Shaanxi | 533 | 3 | 505 | 25 | 35.1917 | 108.8701 | 2021-01-23 05:22:03 | Shaanxi, China | ||
435178 | 435178 | 2021-01-21 | China | Shaanxi | 533 | 3 | 504 | 26 | 35.1917 | 108.8701 | 2021-01-22 05:22:10 | Shaanxi, China | ||
1093910 | 1093910 | 2021-01-20 | China | Shaanxi | 533 | 3 | 504 | 26 | 35.1917 | 108.8701 | 2021-01-21 05:22:01 | Shaanxi, China | ||
908000 | 908000 | 2021-01-19 | China | Shaanxi | 533 | 3 | 503 | 27 | 35.1917 | 108.8701 | 2021-01-20 05:21:54 | Shaanxi, China | ||
237063 | 237063 | 2021-01-18 | China | Shaanxi | 531 | 3 | 502 | 26 | 35.1917 | 108.8701 | 2021-01-19 05:22:15 | Shaanxi, China | ||
3503180 | 3503180 | 2021-01-17 | China | Shaanxi | 530 | 3 | 502 | 25 | 35.1917 | 108.8701 | 2021-01-18 05:22:34 | Shaanxi, China | ||
3101263 | 3101263 | 2021-01-16 | China | Shaanxi | 527 | 3 | 502 | 22 | 35.1917 | 108.8701 | 2021-01-17 05:22:17 | Shaanxi, China | ||
3515225 | 3515225 | 2021-01-15 | China | Shaanxi | 527 | 3 | 501 | 23 | 35.1917 | 108.8701 | 2021-01-16 05:22:40 | Shaanxi, China | ||
3879398 | 3879398 | 2021-01-14 | China | Shaanxi | 526 | 3 | 500 | 23 | 35.1917 | 108.8701 | 2021-01-15 05:22:24 | Shaanxi, China | ||
3308025 | 3308025 | 2021-01-13 | China | Shaanxi | 524 | 3 | 500 | 21 | 35.1917 | 108.8701 | 2021-01-14 05:22:32 | Shaanxi, China | ||
774170 | 774170 | 2021-01-12 | China | Shaanxi | 524 | 3 | 500 | 21 | 35.1917 | 108.8701 | 2021-01-13 05:22:15 | Shaanxi, China | ||
189891 | 189891 | 2021-01-11 | China | Shaanxi | 524 | 3 | 499 | 22 | 35.1917 | 108.8701 | 2021-01-12 05:22:15 | Shaanxi, China | ||
2625694 | 2625694 | 2021-01-10 | China | Shaanxi | 523 | 3 | 498 | 22 | 35.1917 | 108.8701 | 2021-01-11 05:21:50 | Shaanxi, China | ||
3899782 | 3899782 | 2021-01-09 | China | Shaanxi | 522 | 3 | 497 | 22 | 35.1917 | 108.8701 | 2021-01-10 05:22:12 | Shaanxi, China | ||
153805 | 153805 | 2021-01-08 | China | Shaanxi | 521 | 3 | 494 | 24 | 35.1917 | 108.8701 | 2021-01-09 05:22:18 | Shaanxi, China | ||
2541229 | 2541229 | 2021-01-07 | China | Shaanxi | 521 | 3 | 494 | 24 | 35.1917 | 108.8701 | 2021-01-08 05:22:42 | Shaanxi, China | ||
2864538 | 2864538 | 2021-01-06 | China | Shaanxi | 521 | 3 | 493 | 25 | 35.1917 | 108.8701 | 2021-01-07 05:22:03 | Shaanxi, China | ||
3034125 | 3034125 | 2021-01-05 | China | Shaanxi | 519 | 3 | 491 | 25 | 35.1917 | 108.8701 | 2021-01-06 05:22:16 | Shaanxi, China | ||
1061670 | 1061670 | 2021-01-04 | China | Shaanxi | 516 | 3 | 491 | 22 | 35.1917 | 108.8701 | 2021-01-05 05:21:49 | Shaanxi, China | ||
3230273 | 3230273 | 2021-01-03 | China | Shaanxi | 516 | 3 | 490 | 23 | 35.1917 | 108.8701 | 2021-01-04 05:22:02 | Shaanxi, China | ||
2227343 | 2227343 | 2021-01-02 | China | Shaanxi | 510 | 3 | 490 | 17 | 35.1917 | 108.8701 | 2021-01-03 05:22:52 | Shaanxi, China | ||
1136707 | 1136707 | 2021-01-01 | China | Shaanxi | 508 | 3 | 490 | 15 | 35.1917 | 108.8701 | 2021-01-02 05:22:33 | Shaanxi, China | ||
3695313 | 3695313 | 2020-12-31 | China | Shaanxi | 507 | 3 | 490 | 14 | 35.1917 | 108.8701 | 2021-01-01 05:23:07 | Shaanxi, China | ||
1010128 | 1010128 | 2020-12-30 | China | Shaanxi | 506 | 3 | 489 | 14 | 35.1917 | 108.8701 | 2020-12-31 05:22:49 | Shaanxi, China | ||
766143 | 766143 | 2020-12-29 | China | Shaanxi | 505 | 3 | 489 | 13 | 35.1917 | 108.8701 | 2020-12-30 05:22:34 | Shaanxi, China | ||
3761407 | 3761407 | 2020-12-28 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-29 05:22:37 | Shaanxi, China | ||
3777727 | 3777727 | 2020-12-27 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-28 05:22:06 | Shaanxi, China | ||
2223332 | 2223332 | 2020-12-26 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-27 05:22:55 | Shaanxi, China | ||
202079 | 202079 | 2020-12-25 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-26 05:22:28 | Shaanxi, China | ||
3691302 | 3691302 | 2020-12-24 | China | Shaanxi | 504 | 3 | 487 | 14 | 35.1917 | 108.8701 | 2020-12-25 05:22:48 | Shaanxi, China | ||
2406654 | 2406654 | 2020-12-23 | China | Shaanxi | 504 | 3 | 487 | 14 | 35.1917 | 108.8701 | 2020-12-24 05:23:04 | Shaanxi, China | ||
3769700 | 3769700 | 2020-12-22 | China | Shaanxi | 504 | 3 | 485 | 16 | 35.1917 | 108.8701 | 2020-12-23 05:22:03 | Shaanxi, China | ||
927516 | 927516 | 2020-12-21 | China | Shaanxi | 504 | 3 | 485 | 16 | 35.1917 | 108.8701 | 2020-12-22 05:22:33 | Shaanxi, China | ||
2119537 | 2119537 | 2020-12-20 | China | Shaanxi | 504 | 3 | 485 | 16 | 35.1917 | 108.8701 | 2020-12-21 05:27:58 | Shaanxi, China | ||
2931044 | 2931044 | 2020-12-19 | China | Shaanxi | 504 | 3 | 485 | 16 | 35.1917 | 108.8701 | 2020-12-20 05:27:32 | Shaanxi, China | ||
1900990 | 1900990 | 2020-12-18 | China | Shaanxi | 502 | 3 | 485 | 14 | 35.1917 | 108.8701 | 2020-12-19 05:27:52 | Shaanxi, China | ||
2127816 | 2127816 | 2020-12-17 | China | Shaanxi | 502 | 3 | 485 | 14 | 35.1917 | 108.8701 | 2020-12-18 05:28:18 | Shaanxi, China | ||
3149416 | 3149416 | 2020-12-16 | China | Shaanxi | 502 | 3 | 483 | 16 | 35.1917 | 108.8701 | 2020-12-17 05:28:12 | Shaanxi, China | ||
1034197 | 1034197 | 2020-12-15 | China | Shaanxi | 502 | 3 | 483 | 16 | 35.1917 | 108.8701 | 2020-12-16 05:28:04 | Shaanxi, China | ||
1751091 | 1751091 | 2020-12-14 | China | Shaanxi | 502 | 3 | 482 | 17 | 35.1917 | 108.8701 | 2020-12-15 05:26:38 | Shaanxi, China | ||
3847611 | 3847611 | 2020-12-13 | China | Shaanxi | 502 | 3 | 482 | 17 | 35.1917 | 108.8701 | 2020-12-14 05:26:27 | Shaanxi, China | ||
845393 | 845393 | 2020-12-12 | China | Shaanxi | 502 | 3 | 481 | 18 | 35.1917 | 108.8701 | 2020-12-13 05:27:20 | Shaanxi, China | ||
860500 | 860500 | 2020-12-11 | China | Shaanxi | 502 | 3 | 481 | 18 | 35.1917 | 108.8701 | 2020-12-12 05:26:19 | Shaanxi, China | ||
1600042 | 1600042 | 2020-12-10 | China | Shaanxi | 502 | 3 | 480 | 19 | 35.1917 | 108.8701 | 2020-12-11 05:26:59 | Shaanxi, China | ||
2975051 | 2975051 | 2020-12-09 | China | Shaanxi | 502 | 3 | 480 | 19 | 35.1917 | 108.8701 | 2020-12-10 05:26:19 | Shaanxi, China | ||
1818611 | 1818611 | 2020-12-08 | China | Shaanxi | 502 | 3 | 480 | 19 | 35.1917 | 108.8701 | 2020-12-09 05:28:01 | Shaanxi, China | ||
2347247 | 2347247 | 2020-12-07 | China | Shaanxi | 502 | 3 | 479 | 20 | 35.1917 | 108.8701 | 2020-12-08 05:27:42 | Shaanxi, China | ||
1006117 | 1006117 | 2020-12-06 | China | Shaanxi | 502 | 3 | 478 | 21 | 35.1917 | 108.8701 | 2020-12-07 05:26:14 | Shaanxi, China | ||
1632126 | 1632126 | 2020-12-05 | China | Shaanxi | 502 | 3 | 474 | 25 | 35.1917 | 108.8701 | 2020-12-06 05:26:18 | Shaanxi, China | ||
3859654 | 3859654 | 2020-12-04 | China | Shaanxi | 501 | 3 | 474 | 24 | 35.1917 | 108.8701 | 2020-12-05 05:27:36 | Shaanxi, China | ||
74912 | 74912 | 2020-12-03 | China | Shaanxi | 501 | 3 | 471 | 27 | 35.1917 | 108.8701 | 2020-12-04 05:27:27 | Shaanxi, China | ||
738124 | 738124 | 2020-12-02 | China | Shaanxi | 501 | 3 | 469 | 29 | 35.1917 | 108.8701 | 2020-12-03 05:28:22 | Shaanxi, China | ||
2537218 | 2537218 | 2020-12-01 | China | Shaanxi | 500 | 3 | 468 | 29 | 35.1917 | 108.8701 | 2020-12-02 05:27:41 | Shaanxi, China | ||
1583987 | 1583987 | 2020-11-30 | China | Shaanxi | 499 | 3 | 468 | 28 | 35.1917 | 108.8701 | 2020-12-01 05:26:18 | Shaanxi, China | ||
3566390 | 3566390 | 2020-11-29 | China | Shaanxi | 498 | 3 | 463 | 32 | 35.1917 | 108.8701 | 2020-11-30 05:26:13 | Shaanxi, China | ||
2935055 | 2935055 | 2020-11-28 | China | Shaanxi | 498 | 3 | 463 | 32 | 35.1917 | 108.8701 | 2020-11-29 05:25:55 | Shaanxi, China | ||
392058 | 392058 | 2020-11-27 | China | Shaanxi | 497 | 3 | 460 | 34 | 35.1917 | 108.8701 | 2020-11-28 05:25:50 | Shaanxi, China | ||
923505 | 923505 | 2020-11-26 | China | Shaanxi | 497 | 3 | 455 | 39 | 35.1917 | 108.8701 | 2020-11-27 05:26:53 | Shaanxi, China | ||
1972410 | 1972410 | 2020-11-25 | China | Shaanxi | 496 | 3 | 455 | 38 | 35.1917 | 108.8701 | 2020-11-26 05:27:44 | Shaanxi, China | ||
1350141 | 1350141 | 2020-11-24 | China | Shaanxi | 496 | 3 | 453 | 40 | 35.1917 | 108.8701 | 2020-11-25 05:27:20 | Shaanxi, China | ||
678135 | 678135 | 2020-11-23 | China | Shaanxi | 495 | 3 | 449 | 43 | 35.1917 | 108.8701 | 2020-11-24 05:27:31 | Shaanxi, China | ||
3189811 | 3189811 | 2020-11-22 | China | Shaanxi | 493 | 3 | 447 | 43 | 35.1917 | 108.8701 | 2020-11-23 05:25:26 | Shaanxi, China | ||
3836305 | 3836305 | 2020-11-21 | China | Shaanxi | 492 | 3 | 447 | 42 | 35.1917 | 108.8701 | 2020-11-22 05:25:45 | Shaanxi, China | ||
2701333 | 2701333 | 2020-11-20 | China | Shaanxi | 490 | 3 | 444 | 43 | 35.1917 | 108.8701 | 2020-11-21 05:25:51 | Shaanxi, China | ||
821393 | 821393 | 2020-11-19 | China | Shaanxi | 490 | 3 | 443 | 44 | 35.1917 | 108.8701 | 2020-11-20 05:26:28 | Shaanxi, China | ||
122527 | 122527 | 2020-11-18 | China | Shaanxi | 487 | 3 | 443 | 41 | 35.1917 | 108.8701 | 2020-11-19 05:25:23 | Shaanxi, China | ||
3338415 | 3338415 | 2020-11-17 | China | Shaanxi | 487 | 3 | 443 | 41 | 35.1917 | 108.8701 | 2020-11-18 05:40:31 | Shaanxi, China | ||
3169460 | 3169460 | 2020-11-16 | China | Shaanxi | 487 | 3 | 439 | 45 | 35.1917 | 108.8701 | 2020-11-17 05:25:54 | Shaanxi, China | ||
2880028 | 2880028 | 2020-11-15 | China | Shaanxi | 487 | 3 | 439 | 45 | 35.1917 | 108.8701 | 2020-11-16 05:25:57 | Shaanxi, China | ||
2915006 | 2915006 | 2020-11-14 | China | Shaanxi | 486 | 3 | 438 | 45 | 35.1917 | 108.8701 | 2020-11-15 05:26:53 | Shaanxi, 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]);