johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
282 rows where deaths = 868 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756185 | 2756185 | 2022-12-29 | US | Utah | Utah | 49049 | 224042 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-30 04:21:04 | Utah, Utah, US | |
2755577 | 2755577 | 2022-12-29 | US | Pennsylvania | Erie | 42049 | 70303 | 868 | 0 | 41.99253829 | -80.03301954 | 2022-12-30 04:21:04 | Erie, Pennsylvania, US | |
2753558 | 2753558 | 2022-12-29 | US | Colorado | Pueblo | 8101 | 60954 | 868 | 0 | 38.17359144 | -104.5127437 | 2022-12-30 04:21:04 | Pueblo, Colorado, US | |
1077191 | 1077191 | 2022-12-28 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-29 04:21:01 | Utah, Utah, US | |
1076583 | 1076583 | 2022-12-28 | US | Pennsylvania | Erie | 42049 | 70303 | 868 | 0 | 41.99253829 | -80.03301954 | 2022-12-29 04:21:01 | Erie, Pennsylvania, US | |
331188 | 331188 | 2022-12-27 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-28 04:21:04 | Utah, Utah, US | |
330590 | 330590 | 2022-12-27 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-28 04:21:04 | Lackawanna, Pennsylvania, US | |
221261 | 221261 | 2022-12-26 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-27 04:21:07 | Utah, Utah, US | |
220663 | 220663 | 2022-12-26 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-27 04:21:07 | Lackawanna, Pennsylvania, US | |
3225718 | 3225718 | 2022-12-25 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-26 04:21:06 | Utah, Utah, US | |
3225120 | 3225120 | 2022-12-25 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-26 04:21:06 | Lackawanna, Pennsylvania, US | |
1021632 | 1021632 | 2022-12-24 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-25 04:21:04 | Utah, Utah, US | |
1021034 | 1021034 | 2022-12-24 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-25 04:21:04 | Lackawanna, Pennsylvania, US | |
693655 | 693655 | 2022-12-23 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-24 04:21:02 | Utah, Utah, US | |
693057 | 693057 | 2022-12-23 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-24 04:21:02 | Lackawanna, Pennsylvania, US | |
2182865 | 2182865 | 2022-12-22 | US | Utah | Utah | 49049 | 223686 | 868 | 0 | 40.1166722 | -111.6657662 | 2022-12-23 04:21:04 | Utah, Utah, US | |
2182267 | 2182267 | 2022-12-22 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-23 04:21:04 | Lackawanna, Pennsylvania, US | |
454071 | 454071 | 2022-12-21 | US | Pennsylvania | Lackawanna | 42069 | 56246 | 868 | 0 | 41.43564672 | -75.60379201 | 2022-12-22 04:20:56 | Lackawanna, Pennsylvania, US | |
453106 | 453106 | 2022-12-21 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-22 04:20:56 | Dakota, Minnesota, US | |
2953105 | 2953105 | 2022-12-20 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-21 04:21:03 | Dakota, Minnesota, US | |
3175507 | 3175507 | 2022-12-19 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-20 04:21:04 | Dakota, Minnesota, US | |
1630024 | 1630024 | 2022-12-18 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-19 04:21:03 | Dakota, Minnesota, US | |
505403 | 505403 | 2022-12-17 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-18 04:21:03 | Dakota, Minnesota, US | |
3325975 | 3325975 | 2022-12-16 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-17 04:21:04 | Dakota, Minnesota, US | |
544487 | 544487 | 2022-12-15 | US | Minnesota | Dakota | 27037 | 133095 | 868 | 0 | 44.67172617 | -93.06299363 | 2022-12-16 04:21:01 | Dakota, Minnesota, US | |
2416559 | 2416559 | 2022-12-05 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-12-06 04:21:03 | Ottawa, Michigan, US | |
720167 | 720167 | 2022-12-04 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-12-05 04:20:58 | Ottawa, Michigan, US | |
2818456 | 2818456 | 2022-12-03 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-12-04 04:20:56 | Ottawa, Michigan, US | |
835312 | 835312 | 2022-12-02 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-12-03 04:21:02 | Ottawa, Michigan, US | |
2137842 | 2137842 | 2022-12-01 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-12-02 04:21:07 | Ottawa, Michigan, US | |
1966258 | 1966258 | 2022-11-30 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-12-01 04:21:03 | Ottawa, Michigan, US | |
2558272 | 2558272 | 2022-11-29 | US | Michigan | Ottawa | 26139 | 85517 | 868 | 0 | 42.95996803 | -85.9969107 | 2022-11-30 04:21:07 | Ottawa, Michigan, US | |
2485769 | 2485769 | 2022-11-16 | Chile | Arica y Parinacota | 74077 | 868 | 0 | -18.594 | -69.4785 | 2022-11-17 04:21:11 | Arica y Parinacota, Chile | |||
291780 | 291780 | 2022-11-15 | Chile | Arica y Parinacota | 73992 | 868 | 0 | -18.594 | -69.4785 | 2022-11-16 04:21:09 | Arica y Parinacota, Chile | |||
3596810 | 3596810 | 2022-11-14 | Chile | Arica y Parinacota | 73956 | 868 | 0 | -18.594 | -69.4785 | 2022-11-15 04:21:16 | Arica y Parinacota, Chile | |||
311668 | 311668 | 2022-11-13 | Chile | Arica y Parinacota | 73924 | 868 | 0 | -18.594 | -69.4785 | 2022-11-14 04:21:09 | Arica y Parinacota, Chile | |||
62829 | 62829 | 2022-11-12 | Chile | Arica y Parinacota | 73851 | 868 | 0 | -18.594 | -69.4785 | 2022-11-13 04:21:14 | Arica y Parinacota, Chile | |||
539820 | 539820 | 2022-10-26 | US | Illinois | Winnebago | 17201 | 93716 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-27 04:22:01 | Winnebago, Illinois, US | |
1831221 | 1831221 | 2022-10-25 | US | Illinois | Winnebago | 17201 | 93655 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-26 04:22:19 | Winnebago, Illinois, US | |
795482 | 795482 | 2022-10-24 | US | Illinois | Winnebago | 17201 | 93614 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-25 04:21:53 | Winnebago, Illinois, US | |
3277937 | 3277937 | 2022-10-23 | US | Illinois | Winnebago | 17201 | 93481 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-24 04:22:29 | Winnebago, Illinois, US | |
2268975 | 2268975 | 2022-10-22 | US | Illinois | Winnebago | 17201 | 93481 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-23 04:22:46 | Winnebago, Illinois, US | |
1593275 | 1593275 | 2022-10-21 | US | Illinois | Winnebago | 17201 | 93481 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-22 04:22:53 | Winnebago, Illinois, US | |
2272991 | 2272991 | 2022-10-20 | US | Illinois | Winnebago | 17201 | 93431 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-21 04:22:23 | Winnebago, Illinois, US | |
199326 | 199326 | 2022-10-19 | US | Illinois | Winnebago | 17201 | 93293 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-20 04:22:59 | Winnebago, Illinois, US | |
198824 | 198824 | 2022-10-19 | US | California | Merced | 6047 | 84376 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-20 04:22:59 | Merced, California, US | |
2757987 | 2757987 | 2022-10-18 | US | Illinois | Winnebago | 17201 | 93278 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-19 04:22:26 | Winnebago, Illinois, US | |
2757485 | 2757485 | 2022-10-18 | US | California | Merced | 6047 | 84369 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-19 04:22:26 | Merced, California, US | |
2025821 | 2025821 | 2022-10-17 | US | Illinois | Winnebago | 17201 | 93262 | 868 | 0 | 42.33641854 | -89.16085327 | 2022-10-18 04:22:42 | Winnebago, Illinois, US | |
2025319 | 2025319 | 2022-10-17 | US | California | Merced | 6047 | 84252 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-18 04:22:42 | Merced, California, US | |
2160097 | 2160097 | 2022-10-16 | US | California | Merced | 6047 | 84251 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-17 04:20:31 | Merced, California, US | |
516294 | 516294 | 2022-10-15 | US | California | Merced | 6047 | 84250 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-16 04:22:39 | Merced, California, US | |
2033351 | 2033351 | 2022-10-14 | US | California | Merced | 6047 | 84248 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-15 04:22:00 | Merced, California, US | |
3756611 | 3756611 | 2022-10-13 | US | Texas | Jefferson | 48245 | 60445 | 868 | 0 | 29.8832777 | -94.16434171 | 2022-10-14 04:22:28 | Jefferson, Texas, US | |
3754039 | 3754039 | 2022-10-13 | US | California | Merced | 6047 | 84243 | 868 | 0 | 37.18922369 | -120.7209035 | 2022-10-14 04:22:28 | Merced, California, US | |
3217436 | 3217436 | 2022-10-12 | US | Texas | Jefferson | 48245 | 60445 | 868 | 0 | 29.8832777 | -94.16434171 | 2022-10-13 04:22:39 | Jefferson, Texas, US | |
117070 | 117070 | 2022-09-06 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-07 04:20:59 | Forsyth, North Carolina, US | |
2636042 | 2636042 | 2022-09-05 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-06 04:21:02 | Forsyth, North Carolina, US | |
2989606 | 2989606 | 2022-09-04 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-05 04:21:01 | Forsyth, North Carolina, US | |
2715291 | 2715291 | 2022-09-03 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-04 04:21:22 | Forsyth, North Carolina, US | |
1395996 | 1395996 | 2022-09-02 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-03 04:21:04 | Forsyth, North Carolina, US | |
3549825 | 3549825 | 2022-09-01 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-02 04:21:07 | Forsyth, North Carolina, US | |
2345745 | 2345745 | 2022-08-31 | US | North Carolina | Forsyth | 37067 | 110261 | 868 | 0 | 36.12859861 | -80.25459052 | 2022-09-01 04:21:03 | Forsyth, North Carolina, US | |
1251574 | 1251574 | 2022-08-23 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-24 04:20:46 | Hall, Georgia, US | |
2853678 | 2853678 | 2022-08-22 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-23 04:20:56 | Hall, Georgia, US | |
2403650 | 2403650 | 2022-08-21 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-22 04:20:38 | Hall, Georgia, US | |
3798728 | 3798728 | 2022-08-20 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-21 04:20:44 | Hall, Georgia, US | |
2364314 | 2364314 | 2022-08-19 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-20 04:21:01 | Hall, Georgia, US | |
1161985 | 1161985 | 2022-08-18 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-19 04:20:54 | Hall, Georgia, US | |
3951309 | 3951309 | 2022-08-17 | US | Georgia | Hall | 13139 | 58637 | 868 | 0 | 34.32207823 | -83.81896936 | 2022-08-18 04:21:11 | Hall, Georgia, US | |
3911425 | 3911425 | 2022-08-11 | US | Virginia | Virginia Beach | 51810 | 103321 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-12 04:20:54 | Virginia Beach, Virginia, US | |
1349742 | 1349742 | 2022-08-10 | US | Virginia | Virginia Beach | 51810 | 103213 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-11 04:20:49 | Virginia Beach, Virginia, US | |
1089497 | 1089497 | 2022-08-09 | US | Virginia | Virginia Beach | 51810 | 103080 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-10 04:20:57 | Virginia Beach, Virginia, US | |
3546912 | 3546912 | 2022-08-08 | US | Virginia | Virginia Beach | 51810 | 102988 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-09 04:20:34 | Virginia Beach, Virginia, US | |
3546586 | 3546586 | 2022-08-08 | US | Texas | Galveston | 48167 | 110351 | 868 | 0 | 29.40167322 | -94.90469073 | 2022-08-09 04:20:34 | Galveston, Texas, US | |
1073315 | 1073315 | 2022-08-07 | US | Virginia | Virginia Beach | 51810 | 102672 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-08 04:21:08 | Virginia Beach, Virginia, US | |
1943903 | 1943903 | 2022-08-06 | US | Virginia | Virginia Beach | 51810 | 102672 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-07 04:20:54 | Virginia Beach, Virginia, US | |
883702 | 883702 | 2022-08-05 | US | Virginia | Virginia Beach | 51810 | 102672 | 868 | 0 | 36.73285734 | -76.04566934 | 2022-08-06 04:20:56 | Virginia Beach, Virginia, US | |
3618621 | 3618621 | 2022-08-01 | US | Louisiana | St. Tammany | 22103 | 81316 | 868 | 0 | 30.40942847 | -89.95642711 | 2022-08-02 04:20:53 | St. Tammany, Louisiana, US | |
3365396 | 3365396 | 2022-07-02 | Malaysia | Terengganu | 126678 | 868 | 0 | 5.3117 | 103.1324 | 2022-07-03 04:20:59 | Terengganu, Malaysia | |||
593725 | 593725 | 2022-07-01 | Malaysia | Terengganu | 126660 | 868 | 0 | 5.3117 | 103.1324 | 2022-07-02 04:21:16 | Terengganu, Malaysia | |||
3940126 | 3940126 | 2022-06-30 | Malaysia | Terengganu | 126643 | 868 | 0 | 5.3117 | 103.1324 | 2022-07-01 04:21:10 | Terengganu, Malaysia | |||
2490084 | 2490084 | 2022-06-29 | Malaysia | Terengganu | 126618 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-30 04:21:01 | Terengganu, Malaysia | |||
2239466 | 2239466 | 2022-06-28 | Malaysia | Terengganu | 126595 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-29 04:20:59 | Terengganu, Malaysia | |||
2147708 | 2147708 | 2022-06-27 | Malaysia | Terengganu | 126575 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-28 04:20:58 | Terengganu, Malaysia | |||
475509 | 475509 | 2022-06-26 | Malaysia | Terengganu | 126545 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-27 04:21:00 | Terengganu, Malaysia | |||
938884 | 938884 | 2022-06-25 | Malaysia | Terengganu | 126528 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-26 04:21:02 | Terengganu, Malaysia | |||
3346704 | 3346704 | 2022-06-24 | Malaysia | Terengganu | 126510 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-25 04:20:57 | Terengganu, Malaysia | |||
1648445 | 1648445 | 2022-06-23 | Malaysia | Terengganu | 126490 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-24 04:20:58 | Terengganu, Malaysia | |||
2189743 | 2189743 | 2022-06-22 | US | Nebraska | Unassigned | 90031 | 10245 | 868 | 0 | 42.8997274 | 0.0 | 2022-06-23 04:20:55 | Unassigned, Nebraska, US | |
2188080 | 2188080 | 2022-06-22 | US | Arkansas | Benton | 5007 | 68583 | 868 | 0 | 36.33644656 | -94.25680817 | 2022-06-23 04:20:55 | Benton, Arkansas, US | |
2187680 | 2187680 | 2022-06-22 | Malaysia | Terengganu | 126482 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-23 04:20:55 | Terengganu, Malaysia | |||
166511 | 166511 | 2022-06-21 | US | Arkansas | Benton | 5007 | 68534 | 868 | 0 | 36.33644656 | -94.25680817 | 2022-06-22 04:20:54 | Benton, Arkansas, US | |
166111 | 166111 | 2022-06-21 | Malaysia | Terengganu | 126465 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-22 04:20:54 | Terengganu, Malaysia | |||
1763794 | 1763794 | 2022-06-20 | US | Arkansas | Benton | 5007 | 68499 | 868 | 0 | 36.33644656 | -94.25680817 | 2022-06-21 04:20:56 | Benton, Arkansas, US | |
1763394 | 1763394 | 2022-06-20 | Malaysia | Terengganu | 126451 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-21 04:20:56 | Terengganu, Malaysia | |||
3269980 | 3269980 | 2022-06-19 | US | Arkansas | Benton | 5007 | 68479 | 868 | 0 | 36.33644656 | -94.25680817 | 2022-06-20 04:21:01 | Benton, Arkansas, US | |
3269580 | 3269580 | 2022-06-19 | Malaysia | Terengganu | 126437 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-20 04:21:01 | Terengganu, Malaysia | |||
3397492 | 3397492 | 2022-06-18 | Malaysia | Terengganu | 126430 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-19 04:20:51 | Terengganu, Malaysia | |||
2311369 | 2311369 | 2022-06-17 | Malaysia | Terengganu | 126414 | 868 | 0 | 5.3117 | 103.1324 | 2022-06-18 04:21:10 | Terengganu, Malaysia |
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]);