johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
348 rows where deaths = 795 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755390 | 2755390 | 2022-12-29 | US | Ohio | Lake | 39085 | 60243 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-30 04:21:04 | Lake, Ohio, US | |
1076396 | 1076396 | 2022-12-28 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-29 04:21:01 | Lake, Ohio, US | |
330393 | 330393 | 2022-12-27 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-28 04:21:04 | Lake, Ohio, US | |
220466 | 220466 | 2022-12-26 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-27 04:21:07 | Lake, Ohio, US | |
3224923 | 3224923 | 2022-12-25 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-26 04:21:06 | Lake, Ohio, US | |
1020837 | 1020837 | 2022-12-24 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-25 04:21:04 | Lake, Ohio, US | |
692860 | 692860 | 2022-12-23 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-24 04:21:02 | Lake, Ohio, US | |
2182070 | 2182070 | 2022-12-22 | US | Ohio | Lake | 39085 | 59956 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-23 04:21:04 | Lake, Ohio, US | |
453874 | 453874 | 2022-12-21 | US | Ohio | Lake | 39085 | 59557 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-22 04:20:56 | Lake, Ohio, US | |
2953873 | 2953873 | 2022-12-20 | US | Ohio | Lake | 39085 | 59557 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-21 04:21:03 | Lake, Ohio, US | |
3176275 | 3176275 | 2022-12-19 | US | Ohio | Lake | 39085 | 59557 | 795 | 0 | 41.69710807 | -81.23676539 | 2022-12-20 04:21:04 | Lake, Ohio, US | |
1620296 | 1620296 | 2022-11-22 | Japan | Shizuoka | 555862 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-23 04:21:06 | Shizuoka, Japan | |||
3460184 | 3460184 | 2022-11-21 | Japan | Shizuoka | 554145 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-22 04:20:47 | Shizuoka, Japan | |||
1640369 | 1640369 | 2022-11-20 | Japan | Shizuoka | 553145 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-21 04:21:05 | Shizuoka, Japan | |||
2063926 | 2063926 | 2022-11-19 | Japan | Shizuoka | 551403 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-20 04:21:08 | Shizuoka, Japan | |||
1755320 | 1755320 | 2022-11-18 | Japan | Shizuoka | 549479 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-19 04:21:14 | Shizuoka, Japan | |||
3026313 | 3026313 | 2022-11-17 | Japan | Shizuoka | 547611 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-18 04:21:15 | Shizuoka, Japan | |||
2486024 | 2486024 | 2022-11-16 | Japan | Shizuoka | 545345 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-17 04:21:11 | Shizuoka, Japan | |||
2430929 | 2430929 | 2022-11-09 | Japan | Hiroshima | 479400 | 795 | 0 | 34.605309 | 132.788719 | 2022-11-10 04:21:16 | Hiroshima, Japan | |||
2406156 | 2406156 | 2022-08-21 | US | Virginia | Chesterfield | 51041 | 87988 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-22 04:20:38 | Chesterfield, Virginia, US | |
3801234 | 3801234 | 2022-08-20 | US | Virginia | Chesterfield | 51041 | 87988 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-21 04:20:44 | Chesterfield, Virginia, US | |
2366820 | 2366820 | 2022-08-19 | US | Virginia | Chesterfield | 51041 | 87988 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-20 04:21:01 | Chesterfield, Virginia, US | |
1164491 | 1164491 | 2022-08-18 | US | Virginia | Chesterfield | 51041 | 87909 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-19 04:20:54 | Chesterfield, Virginia, US | |
2497356 | 2497356 | 2022-08-15 | US | Virginia | Chesterfield | 51041 | 87548 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-16 04:20:58 | Chesterfield, Virginia, US | |
3650906 | 3650906 | 2022-08-14 | US | Virginia | Chesterfield | 51041 | 87389 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-15 04:20:59 | Chesterfield, Virginia, US | |
1971912 | 1971912 | 2022-08-13 | US | Virginia | Chesterfield | 51041 | 87389 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-14 04:20:55 | Chesterfield, Virginia, US | |
2891721 | 2891721 | 2022-08-12 | US | Virginia | Chesterfield | 51041 | 87389 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-13 04:20:52 | Chesterfield, Virginia, US | |
3911326 | 3911326 | 2022-08-11 | US | Virginia | Chesterfield | 51041 | 87308 | 795 | 0 | 37.37373208 | -77.5868014 | 2022-08-12 04:20:54 | Chesterfield, Virginia, US | |
3908584 | 3908584 | 2022-08-11 | US | California | San Mateo | 6081 | 172855 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-12 04:20:54 | San Mateo, California, US | |
1346901 | 1346901 | 2022-08-10 | US | California | San Mateo | 6081 | 172197 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-11 04:20:49 | San Mateo, California, US | |
1086656 | 1086656 | 2022-08-09 | US | California | San Mateo | 6081 | 172181 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-10 04:20:57 | San Mateo, California, US | |
3544071 | 3544071 | 2022-08-08 | US | California | San Mateo | 6081 | 172170 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-09 04:20:34 | San Mateo, California, US | |
3543564 | 3543564 | 2022-08-08 | Malta | 113288 | 795 | 0 | 35.9375 | 14.3754 | 2022-08-09 04:20:34 | Malta | ||||
1070474 | 1070474 | 2022-08-07 | US | California | San Mateo | 6081 | 171282 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-08 04:21:08 | San Mateo, California, US | |
1069967 | 1069967 | 2022-08-07 | Malta | 113246 | 795 | 0 | 35.9375 | 14.3754 | 2022-08-08 04:21:08 | Malta | ||||
1941062 | 1941062 | 2022-08-06 | US | California | San Mateo | 6081 | 171275 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-07 04:20:54 | San Mateo, California, US | |
1940555 | 1940555 | 2022-08-06 | Malta | 113220 | 795 | 0 | 35.9375 | 14.3754 | 2022-08-07 04:20:54 | Malta | ||||
880861 | 880861 | 2022-08-05 | US | California | San Mateo | 6081 | 171264 | 795 | 0 | 37.4228808 | -122.3275546 | 2022-08-06 04:20:56 | San Mateo, California, US | |
880354 | 880354 | 2022-08-05 | Malta | 113170 | 795 | 0 | 35.9375 | 14.3754 | 2022-08-06 04:20:56 | Malta | ||||
2008765 | 2008765 | 2022-08-04 | Malta | 113120 | 795 | 0 | 35.9375 | 14.3754 | 2022-08-05 04:20:52 | Malta | ||||
1098192 | 1098192 | 2022-08-03 | Malta | 113056 | 795 | 0 | 35.9375 | 14.3754 | 2022-08-04 04:20:58 | Malta | ||||
1490257 | 1490257 | 2022-07-26 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-27 04:21:04 | Erie, Pennsylvania, US | |
2596703 | 2596703 | 2022-07-25 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-26 04:20:58 | Erie, Pennsylvania, US | |
898818 | 898818 | 2022-07-24 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-25 04:20:51 | Erie, Pennsylvania, US | |
93812 | 93812 | 2022-07-23 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-24 04:20:47 | Erie, Pennsylvania, US | |
902834 | 902834 | 2022-07-22 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-23 04:20:53 | Erie, Pennsylvania, US | |
672970 | 672970 | 2022-07-21 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-22 04:21:15 | Erie, Pennsylvania, US | |
1610933 | 1610933 | 2022-07-20 | US | Pennsylvania | Erie | 42049 | 62453 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-21 04:21:10 | Erie, Pennsylvania, US | |
961566 | 961566 | 2022-07-19 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-20 04:20:59 | Erie, Pennsylvania, US | |
3212953 | 3212953 | 2022-07-18 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-19 04:20:58 | Erie, Pennsylvania, US | |
3212493 | 3212493 | 2022-07-18 | US | New Mexico | San Juan | 35045 | 44718 | 795 | 0 | 36.50838318 | -108.320437 | 2022-07-19 04:20:58 | San Juan, New Mexico, US | |
3408128 | 3408128 | 2022-07-17 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-18 04:20:59 | Erie, Pennsylvania, US | |
2154328 | 2154328 | 2022-07-16 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-17 04:21:15 | Erie, Pennsylvania, US | |
2421561 | 2421561 | 2022-07-15 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-16 04:21:05 | Erie, Pennsylvania, US | |
3431636 | 3431636 | 2022-07-14 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-15 04:20:53 | Erie, Pennsylvania, US | |
3430936 | 3430936 | 2022-07-14 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-15 04:20:53 | St. Louis City, Missouri, US | |
3112156 | 3112156 | 2022-07-13 | US | Pennsylvania | Erie | 42049 | 62108 | 795 | 0 | 41.99253829 | -80.03301954 | 2022-07-14 04:20:57 | Erie, Pennsylvania, US | |
3111456 | 3111456 | 2022-07-13 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-14 04:20:57 | St. Louis City, Missouri, US | |
631879 | 631879 | 2022-07-12 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-13 04:20:58 | St. Louis City, Missouri, US | |
1213523 | 1213523 | 2022-07-11 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-12 04:20:51 | St. Louis City, Missouri, US | |
2791005 | 2791005 | 2022-07-10 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-11 04:20:46 | St. Louis City, Missouri, US | |
2788930 | 2788930 | 2022-07-10 | Germany | Bremen | 223349 | 795 | 0 | 53.0793 | 8.8017 | 2022-07-11 04:20:46 | Bremen, Germany | |||
143958 | 143958 | 2022-07-09 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-10 04:20:54 | St. Louis City, Missouri, US | |
141883 | 141883 | 2022-07-09 | Germany | Bremen | 223349 | 795 | 0 | 53.0793 | 8.8017 | 2022-07-10 04:20:54 | Bremen, Germany | |||
1419058 | 1419058 | 2022-07-08 | US | Missouri | St. Louis City | 29510 | 63998 | 795 | 0 | 38.63555736 | -90.24349225 | 2022-07-09 04:20:59 | St. Louis City, Missouri, US | |
1416983 | 1416983 | 2022-07-08 | Germany | Bremen | 223349 | 795 | 0 | 53.0793 | 8.8017 | 2022-07-09 04:20:59 | Bremen, Germany | |||
2742822 | 2742822 | 2022-07-07 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-08 04:20:56 | Hinds, Mississippi, US | |
1201617 | 1201617 | 2022-07-06 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-07 04:20:55 | Hinds, Mississippi, US | |
3968360 | 3968360 | 2022-07-05 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-06 04:20:58 | Hinds, Mississippi, US | |
3079871 | 3079871 | 2022-07-04 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-05 04:20:45 | Hinds, Mississippi, US | |
1769153 | 1769153 | 2022-07-03 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-04 04:20:54 | Hinds, Mississippi, US | |
3367139 | 3367139 | 2022-07-02 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-03 04:20:59 | Hinds, Mississippi, US | |
595468 | 595468 | 2022-07-01 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-02 04:21:16 | Hinds, Mississippi, US | |
3941869 | 3941869 | 2022-06-30 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-07-01 04:21:10 | Hinds, Mississippi, US | |
2491827 | 2491827 | 2022-06-29 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-06-30 04:21:01 | Hinds, Mississippi, US | |
2241209 | 2241209 | 2022-06-28 | US | Mississippi | Hinds | 28049 | 55667 | 795 | 0 | 32.2656285 | -90.44435448 | 2022-06-29 04:20:59 | Hinds, Mississippi, US | |
169515 | 169515 | 2022-06-21 | US | Washington | Yakima | 53077 | 73757 | 795 | 0 | 46.45738486 | -120.7380126 | 2022-06-22 04:20:54 | Yakima, Washington, US | |
1766798 | 1766798 | 2022-06-20 | US | Washington | Yakima | 53077 | 73757 | 795 | 0 | 46.45738486 | -120.7380126 | 2022-06-21 04:20:56 | Yakima, Washington, US | |
3272984 | 3272984 | 2022-06-19 | US | Washington | Yakima | 53077 | 73757 | 795 | 0 | 46.45738486 | -120.7380126 | 2022-06-20 04:21:01 | Yakima, Washington, US | |
3400896 | 3400896 | 2022-06-18 | US | Washington | Yakima | 53077 | 73757 | 795 | 0 | 46.45738486 | -120.7380126 | 2022-06-19 04:20:51 | Yakima, Washington, US | |
2314773 | 2314773 | 2022-06-17 | US | Washington | Yakima | 53077 | 73757 | 795 | 0 | 46.45738486 | -120.7380126 | 2022-06-18 04:21:10 | Yakima, Washington, US | |
3727236 | 3727236 | 2022-06-07 | US | Illinois | Madison | 17119 | 73650 | 795 | 0 | 38.83042506 | -89.90422563 | 2022-06-08 04:20:55 | Madison, Illinois, US | |
3888638 | 3888638 | 2022-06-06 | US | Illinois | Madison | 17119 | 73555 | 795 | 0 | 38.83042506 | -89.90422563 | 2022-06-07 04:21:08 | Madison, Illinois, US | |
3508407 | 3508407 | 2022-06-05 | US | Illinois | Madison | 17119 | 73277 | 795 | 0 | 38.83042506 | -89.90422563 | 2022-06-06 04:20:57 | Madison, Illinois, US | |
3528484 | 3528484 | 2022-06-04 | US | Illinois | Madison | 17119 | 73277 | 795 | 0 | 38.83042506 | -89.90422563 | 2022-06-05 04:20:55 | Madison, Illinois, US | |
3134570 | 3134570 | 2022-06-03 | US | Illinois | Madison | 17119 | 73277 | 795 | 0 | 38.83042506 | -89.90422563 | 2022-06-04 04:20:58 | Madison, Illinois, US | |
3579645 | 3579645 | 2022-06-02 | US | Illinois | Madison | 17119 | 73192 | 795 | 0 | 38.83042506 | -89.90422563 | 2022-06-03 04:20:58 | Madison, Illinois, US | |
974198 | 974198 | 2022-06-01 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-06-02 05:20:39 | Utah, Utah, US | |
232505 | 232505 | 2022-05-31 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-06-01 04:20:55 | Utah, Utah, US | |
3189270 | 3189270 | 2022-05-30 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-05-31 04:20:51 | Utah, Utah, US | |
3201419 | 3201419 | 2022-05-29 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-05-30 04:20:50 | Utah, Utah, US | |
2728297 | 2728297 | 2022-05-28 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-05-29 04:20:53 | Utah, Utah, US | |
1317478 | 1317478 | 2022-05-27 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-05-28 04:21:07 | Utah, Utah, US | |
1853270 | 1853270 | 2022-05-26 | US | Utah | Utah | 49049 | 204715 | 795 | 0 | 40.1166722 | -111.6657662 | 2022-05-27 04:20:56 | Utah, Utah, US | |
3446541 | 3446541 | 2022-05-11 | US | Minnesota | Anoka | 27003 | 100472 | 795 | 0 | 45.27476015 | -93.24604565 | 2022-05-12 04:20:54 | Anoka, Minnesota, US | |
3537158 | 3537158 | 2022-05-10 | US | Minnesota | Anoka | 27003 | 100372 | 795 | 0 | 45.27476015 | -93.24604565 | 2022-05-11 04:20:48 | Anoka, Minnesota, US | |
223693 | 223693 | 2022-05-09 | US | Minnesota | Anoka | 27003 | 100078 | 795 | 0 | 45.27476015 | -93.24604565 | 2022-05-10 04:20:50 | Anoka, Minnesota, US | |
2333078 | 2333078 | 2022-05-08 | US | Minnesota | Anoka | 27003 | 99938 | 795 | 0 | 45.27476015 | -93.24604565 | 2022-05-09 04:20:54 | Anoka, Minnesota, US | |
362040 | 362040 | 2022-05-07 | US | Minnesota | Anoka | 27003 | 99938 | 795 | 0 | 45.27476015 | -93.24604565 | 2022-05-08 04:20:49 | Anoka, Minnesota, US | |
1399391 | 1399391 | 2022-05-06 | US | Minnesota | Anoka | 27003 | 99938 | 795 | 0 | 45.27476015 | -93.24604565 | 2022-05-07 04:21:09 | Anoka, Minnesota, 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]);