johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
326 rows where deaths = 804 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756304 | 2756304 | 2022-12-29 | US | Virginia | Prince William | 51153 | 122787 | 804 | 0 | 38.70916224 | -77.48713689 | 2022-12-30 04:21:04 | Prince William, Virginia, US | |
1077310 | 1077310 | 2022-12-28 | US | Virginia | Prince William | 51153 | 122787 | 804 | 0 | 38.70916224 | -77.48713689 | 2022-12-29 04:21:01 | Prince William, Virginia, US | |
2556610 | 2556610 | 2022-11-29 | Japan | Shizuoka | 571985 | 804 | 0 | 34.916975 | 138.407784 | 2022-11-30 04:21:07 | Shizuoka, Japan | |||
3756967 | 3756967 | 2022-10-13 | US | West Virginia | Kanawha | 54039 | 56070 | 804 | 0 | 38.33860077 | -81.52857054 | 2022-10-14 04:22:28 | Kanawha, West Virginia, US | |
3251674 | 3251674 | 2022-10-11 | US | Louisiana | Ouachita | 22073 | 59509 | 804 | 0 | 32.47645559 | -92.15704172 | 2022-10-12 04:22:51 | Ouachita, Louisiana, US | |
3994709 | 3994709 | 2022-09-27 | Malta | 114605 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-28 04:23:01 | Malta | ||||
2769037 | 2769037 | 2022-09-26 | Malta | 114583 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-27 04:23:01 | Malta | ||||
1976690 | 1976690 | 2022-09-25 | Malta | 114567 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-26 04:20:52 | Malta | ||||
2649857 | 2649857 | 2022-09-24 | Malta | 114550 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-25 04:23:31 | Malta | ||||
384297 | 384297 | 2022-09-23 | Malta | 114534 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-24 04:21:40 | Malta | ||||
1624363 | 1624363 | 2022-09-22 | Malta | 114503 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-23 04:23:13 | Malta | ||||
1370567 | 1370567 | 2022-09-21 | Malta | 114470 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-22 04:22:56 | Malta | ||||
2016797 | 2016797 | 2022-09-20 | Malta | 114443 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-21 04:23:22 | Malta | ||||
3570670 | 3570670 | 2022-09-19 | Malta | 114425 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-20 04:22:48 | Malta | ||||
419409 | 419409 | 2022-09-18 | Malta | 114411 | 804 | 0 | 35.9375 | 14.3754 | 2022-09-19 04:21:49 | Malta | ||||
2343835 | 2343835 | 2022-08-31 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-09-01 04:21:03 | Tuscaloosa, Alabama, US | |
3776577 | 3776577 | 2022-08-30 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-31 04:20:57 | Erie, Pennsylvania, US | |
3774315 | 3774315 | 2022-08-30 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-31 04:20:57 | Tuscaloosa, Alabama, US | |
1683173 | 1683173 | 2022-08-29 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-30 04:21:03 | Erie, Pennsylvania, US | |
1680911 | 1680911 | 2022-08-29 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-30 04:21:03 | Tuscaloosa, Alabama, US | |
1879657 | 1879657 | 2022-08-28 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-29 04:21:06 | Erie, Pennsylvania, US | |
1877395 | 1877395 | 2022-08-28 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-29 04:21:06 | Tuscaloosa, Alabama, US | |
2098784 | 2098784 | 2022-08-27 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-28 04:21:02 | Erie, Pennsylvania, US | |
2096522 | 2096522 | 2022-08-27 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-28 04:21:02 | Tuscaloosa, Alabama, US | |
1534599 | 1534599 | 2022-08-26 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-27 04:20:57 | Erie, Pennsylvania, US | |
1532337 | 1532337 | 2022-08-26 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-27 04:20:57 | Tuscaloosa, Alabama, US | |
2831486 | 2831486 | 2022-08-25 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-26 04:21:02 | Erie, Pennsylvania, US | |
2830786 | 2830786 | 2022-08-25 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-26 04:21:02 | St. Louis City, Missouri, US | |
2829224 | 2829224 | 2022-08-25 | US | Alabama | Tuscaloosa | 1125 | 63829 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-26 04:21:02 | Tuscaloosa, Alabama, US | |
2326019 | 2326019 | 2022-08-24 | US | Pennsylvania | Erie | 42049 | 64540 | 804 | 0 | 41.99253829 | -80.03301954 | 2022-08-25 04:21:13 | Erie, Pennsylvania, US | |
2325319 | 2325319 | 2022-08-24 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-25 04:21:13 | St. Louis City, Missouri, US | |
2323757 | 2323757 | 2022-08-24 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-25 04:21:13 | Tuscaloosa, Alabama, US | |
1252728 | 1252728 | 2022-08-23 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-24 04:20:46 | St. Louis City, Missouri, US | |
1251166 | 1251166 | 2022-08-23 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-24 04:20:46 | Tuscaloosa, Alabama, US | |
2854832 | 2854832 | 2022-08-22 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-23 04:20:56 | St. Louis City, Missouri, US | |
2853270 | 2853270 | 2022-08-22 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-23 04:20:56 | Tuscaloosa, Alabama, US | |
2404804 | 2404804 | 2022-08-21 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-22 04:20:38 | St. Louis City, Missouri, US | |
2403242 | 2403242 | 2022-08-21 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-22 04:20:38 | Tuscaloosa, Alabama, US | |
3799882 | 3799882 | 2022-08-20 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-21 04:20:44 | St. Louis City, Missouri, US | |
3798320 | 3798320 | 2022-08-20 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-21 04:20:44 | Tuscaloosa, Alabama, US | |
2365468 | 2365468 | 2022-08-19 | US | Missouri | St. Louis City | 29510 | 68055 | 804 | 0 | 38.63555736 | -90.24349225 | 2022-08-20 04:21:01 | St. Louis City, Missouri, US | |
2363906 | 2363906 | 2022-08-19 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-20 04:21:01 | Tuscaloosa, Alabama, US | |
1161577 | 1161577 | 2022-08-18 | US | Alabama | Tuscaloosa | 1125 | 63196 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-19 04:20:54 | Tuscaloosa, Alabama, US | |
3950901 | 3950901 | 2022-08-17 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-18 04:21:11 | Tuscaloosa, Alabama, US | |
991403 | 991403 | 2022-08-16 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-17 04:20:59 | Tuscaloosa, Alabama, US | |
2494442 | 2494442 | 2022-08-15 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-16 04:20:58 | Tuscaloosa, Alabama, US | |
3647992 | 3647992 | 2022-08-14 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-15 04:20:59 | Tuscaloosa, Alabama, US | |
1968998 | 1968998 | 2022-08-13 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-14 04:20:55 | Tuscaloosa, Alabama, US | |
2888807 | 2888807 | 2022-08-12 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-13 04:20:52 | Tuscaloosa, Alabama, US | |
3908412 | 3908412 | 2022-08-11 | US | Alabama | Tuscaloosa | 1125 | 62635 | 804 | 0 | 33.28726072 | -87.52556818 | 2022-08-12 04:20:54 | Tuscaloosa, Alabama, US | |
3545134 | 3545134 | 2022-08-08 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-09 04:20:34 | Ingham, Michigan, US | |
1071537 | 1071537 | 2022-08-07 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-08 04:21:08 | Ingham, Michigan, US | |
1942125 | 1942125 | 2022-08-06 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-07 04:20:54 | Ingham, Michigan, US | |
881924 | 881924 | 2022-08-05 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-06 04:20:56 | Ingham, Michigan, US | |
2010335 | 2010335 | 2022-08-04 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-05 04:20:52 | Ingham, Michigan, US | |
1099928 | 1099928 | 2022-08-03 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-08-04 04:20:58 | Hinds, Mississippi, US | |
1099762 | 1099762 | 2022-08-03 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-04 04:20:58 | Ingham, Michigan, US | |
1406853 | 1406853 | 2022-08-02 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-08-03 04:20:59 | Hinds, Mississippi, US | |
1406687 | 1406687 | 2022-08-02 | US | Michigan | Ingham | 26065 | 72840 | 804 | 0 | 42.59716886 | -84.37472069 | 2022-08-03 04:20:59 | Ingham, Michigan, US | |
3618891 | 3618891 | 2022-08-01 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-08-02 04:20:53 | Hinds, Mississippi, US | |
3873371 | 3873371 | 2022-07-31 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-08-01 04:21:03 | Hinds, Mississippi, US | |
676125 | 676125 | 2022-07-30 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-07-31 04:21:02 | Hinds, Mississippi, US | |
1785324 | 1785324 | 2022-07-29 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-07-30 04:20:42 | Hinds, Mississippi, US | |
1067687 | 1067687 | 2022-07-28 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-07-29 04:20:45 | Hinds, Mississippi, US | |
2337206 | 2337206 | 2022-07-27 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-07-28 04:20:56 | Hinds, Mississippi, US | |
1489396 | 1489396 | 2022-07-26 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-07-27 04:21:04 | Hinds, Mississippi, US | |
2595842 | 2595842 | 2022-07-25 | US | Mississippi | Hinds | 28049 | 59277 | 804 | 0 | 32.2656285 | -90.44435448 | 2022-07-26 04:20:58 | Hinds, Mississippi, US | |
672510 | 672510 | 2022-07-21 | US | New Mexico | San Juan | 35045 | 44959 | 804 | 0 | 36.50838318 | -108.320437 | 2022-07-22 04:21:15 | San Juan, New Mexico, US | |
670195 | 670195 | 2022-07-21 | Germany | Bremen | 233231 | 804 | 0 | 53.0793 | 8.8017 | 2022-07-22 04:21:15 | Bremen, Germany | |||
1609281 | 1609281 | 2022-07-20 | US | Illinois | Madison | 17119 | 77534 | 804 | 0 | 38.83042506 | -89.90422563 | 2022-07-21 04:21:10 | Madison, Illinois, US | |
1608158 | 1608158 | 2022-07-20 | Germany | Bremen | 232160 | 804 | 0 | 53.0793 | 8.8017 | 2022-07-21 04:21:10 | Bremen, Germany | |||
961576 | 961576 | 2022-07-19 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-20 04:20:59 | Lackawanna, Pennsylvania, US | |
959914 | 959914 | 2022-07-19 | US | Illinois | Madison | 17119 | 77438 | 804 | 0 | 38.83042506 | -89.90422563 | 2022-07-20 04:20:59 | Madison, Illinois, US | |
3212963 | 3212963 | 2022-07-18 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-19 04:20:58 | Lackawanna, Pennsylvania, US | |
3408138 | 3408138 | 2022-07-17 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-18 04:20:59 | Lackawanna, Pennsylvania, US | |
2154338 | 2154338 | 2022-07-16 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-17 04:21:15 | Lackawanna, Pennsylvania, US | |
2421571 | 2421571 | 2022-07-15 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-16 04:21:05 | Lackawanna, Pennsylvania, US | |
3431646 | 3431646 | 2022-07-14 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-15 04:20:53 | Lackawanna, Pennsylvania, US | |
3112166 | 3112166 | 2022-07-13 | US | Pennsylvania | Lackawanna | 42069 | 48775 | 804 | 0 | 41.43564672 | -75.60379201 | 2022-07-14 04:20:57 | Lackawanna, Pennsylvania, US | |
2493296 | 2493296 | 2022-06-29 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-30 04:21:01 | Utah, Utah, US | |
2242678 | 2242678 | 2022-06-28 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-29 04:20:59 | Utah, Utah, US | |
2150920 | 2150920 | 2022-06-27 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-28 04:20:58 | Utah, Utah, US | |
478721 | 478721 | 2022-06-26 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-27 04:21:00 | Utah, Utah, US | |
942096 | 942096 | 2022-06-25 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-26 04:21:02 | Utah, Utah, US | |
3349916 | 3349916 | 2022-06-24 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-25 04:20:57 | Utah, Utah, US | |
3346492 | 3346492 | 2022-06-24 | Cote d'Ivoire | 82953 | 804 | 0 | 7.54 | -5.5471 | 2022-06-25 04:20:57 | Cote d'Ivoire | ||||
1651657 | 1651657 | 2022-06-23 | US | Utah | Utah | 49049 | 208734 | 804 | 0 | 40.1166722 | -111.6657662 | 2022-06-24 04:20:58 | Utah, Utah, US | |
1650573 | 1650573 | 2022-06-23 | US | New Mexico | Dona Ana | 35013 | 66005 | 804 | 0 | 32.35275771 | -106.8329387 | 2022-06-24 04:20:58 | Dona Ana, New Mexico, US | |
1648233 | 1648233 | 2022-06-23 | Cote d'Ivoire | 82905 | 804 | 0 | 7.54 | -5.5471 | 2022-06-24 04:20:58 | Cote d'Ivoire | ||||
2187468 | 2187468 | 2022-06-22 | Cote d'Ivoire | 82842 | 804 | 0 | 7.54 | -5.5471 | 2022-06-23 04:20:55 | Cote d'Ivoire | ||||
3159335 | 3159335 | 2022-06-09 | US | Minnesota | Anoka | 27003 | 103350 | 804 | 0 | 45.27476015 | -93.24604565 | 2022-06-10 04:20:55 | Anoka, Minnesota, US | |
1422802 | 1422802 | 2022-06-08 | US | Minnesota | Anoka | 27003 | 103240 | 804 | 0 | 45.27476015 | -93.24604565 | 2022-06-09 04:20:54 | Anoka, Minnesota, US | |
3727916 | 3727916 | 2022-06-07 | US | Minnesota | Anoka | 27003 | 103173 | 804 | 0 | 45.27476015 | -93.24604565 | 2022-06-08 04:20:55 | Anoka, Minnesota, US | |
2087395 | 2087395 | 2022-05-15 | US | Washington | Clark | 53011 | 91435 | 804 | 0 | 45.77568046 | -122.4829204 | 2022-05-16 04:20:47 | Clark, Washington, US | |
2084610 | 2084610 | 2022-05-15 | US | Colorado | Pueblo | 8101 | 49218 | 804 | 0 | 38.17359144 | -104.5127437 | 2022-05-16 04:20:47 | Pueblo, Colorado, US | |
3358105 | 3358105 | 2022-05-14 | US | Washington | Clark | 53011 | 91435 | 804 | 0 | 45.77568046 | -122.4829204 | 2022-05-15 04:20:53 | Clark, Washington, US | |
3356922 | 3356922 | 2022-05-14 | US | New York | Oneida | 36065 | 58360 | 804 | 0 | 43.24375382 | -75.43710392 | 2022-05-15 04:20:53 | Oneida, New York, US | |
3355320 | 3355320 | 2022-05-14 | US | Colorado | Pueblo | 8101 | 49190 | 804 | 0 | 38.17359144 | -104.5127437 | 2022-05-15 04:20:53 | Pueblo, Colorado, US | |
661750 | 661750 | 2022-05-13 | US | Washington | Clark | 53011 | 91435 | 804 | 0 | 45.77568046 | -122.4829204 | 2022-05-14 04:20:48 | Clark, Washington, US | |
658965 | 658965 | 2022-05-13 | US | Colorado | Pueblo | 8101 | 49175 | 804 | 0 | 38.17359144 | -104.5127437 | 2022-05-14 04:20:48 | Pueblo, Colorado, US |
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]);