johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
357 rows where deaths = 827 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2431346 | 2431346 | 2022-11-09 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-10 04:21:16 | Tuscaloosa, Alabama, US | |
480002 | 480002 | 2022-11-08 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-09 04:21:22 | Tuscaloosa, Alabama, US | |
2439152 | 2439152 | 2022-11-07 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-08 04:21:21 | Tuscaloosa, Alabama, US | |
1050250 | 1050250 | 2022-11-06 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-07 04:21:26 | Tuscaloosa, Alabama, US | |
618274 | 618274 | 2022-11-05 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-06 04:21:24 | Tuscaloosa, Alabama, US | |
1022778 | 1022778 | 2022-11-04 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-05 04:21:52 | Tuscaloosa, Alabama, US | |
431769 | 431769 | 2022-11-03 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-04 04:22:11 | Tuscaloosa, Alabama, US | |
850011 | 850011 | 2022-11-02 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-03 04:22:05 | Tuscaloosa, Alabama, US | |
849454 | 849454 | 2022-11-02 | Cote d'Ivoire | 87781 | 827 | 0 | 7.54 | -5.5471 | 2022-11-03 04:22:05 | Cote d'Ivoire | ||||
710862 | 710862 | 2022-11-01 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-02 04:22:09 | Tuscaloosa, Alabama, US | |
710305 | 710305 | 2022-11-01 | Cote d'Ivoire | 87781 | 827 | 0 | 7.54 | -5.5471 | 2022-11-02 04:22:09 | Cote d'Ivoire | ||||
3285311 | 3285311 | 2022-10-31 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-01 04:22:36 | Tuscaloosa, Alabama, US | |
3284754 | 3284754 | 2022-10-31 | Cote d'Ivoire | 87774 | 827 | 0 | 7.54 | -5.5471 | 2022-11-01 04:22:36 | Cote d'Ivoire | ||||
320344 | 320344 | 2022-10-30 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-31 04:21:36 | Tuscaloosa, Alabama, US | |
319787 | 319787 | 2022-10-30 | Cote d'Ivoire | 87773 | 827 | 0 | 7.54 | -5.5471 | 2022-10-31 04:21:36 | Cote d'Ivoire | ||||
912620 | 912620 | 2022-10-29 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-30 04:22:14 | Tuscaloosa, Alabama, US | |
912063 | 912063 | 2022-10-29 | Cote d'Ivoire | 87753 | 827 | 0 | 7.54 | -5.5471 | 2022-10-30 04:22:14 | Cote d'Ivoire | ||||
1366889 | 1366889 | 2022-10-28 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-29 04:21:13 | Tuscaloosa, Alabama, US | |
1366332 | 1366332 | 2022-10-28 | Cote d'Ivoire | 87753 | 827 | 0 | 7.54 | -5.5471 | 2022-10-29 04:21:13 | Cote d'Ivoire | ||||
3038744 | 3038744 | 2022-10-27 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-28 04:22:31 | Tuscaloosa, Alabama, US | |
3038187 | 3038187 | 2022-10-27 | Cote d'Ivoire | 87731 | 827 | 0 | 7.54 | -5.5471 | 2022-10-28 04:22:31 | Cote d'Ivoire | ||||
539164 | 539164 | 2022-10-26 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-27 04:22:01 | Tuscaloosa, Alabama, US | |
538607 | 538607 | 2022-10-26 | Cote d'Ivoire | 87720 | 827 | 0 | 7.54 | -5.5471 | 2022-10-27 04:22:01 | Cote d'Ivoire | ||||
1830565 | 1830565 | 2022-10-25 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-26 04:22:19 | Tuscaloosa, Alabama, US | |
1830008 | 1830008 | 2022-10-25 | Cote d'Ivoire | 87720 | 827 | 0 | 7.54 | -5.5471 | 2022-10-26 04:22:19 | Cote d'Ivoire | ||||
794826 | 794826 | 2022-10-24 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-25 04:21:53 | Tuscaloosa, Alabama, US | |
794269 | 794269 | 2022-10-24 | Cote d'Ivoire | 87700 | 827 | 0 | 7.54 | -5.5471 | 2022-10-25 04:21:53 | Cote d'Ivoire | ||||
3277281 | 3277281 | 2022-10-23 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-24 04:22:29 | Tuscaloosa, Alabama, US | |
3276724 | 3276724 | 2022-10-23 | Cote d'Ivoire | 87700 | 827 | 0 | 7.54 | -5.5471 | 2022-10-24 04:22:29 | Cote d'Ivoire | ||||
2268319 | 2268319 | 2022-10-22 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-23 04:22:46 | Tuscaloosa, Alabama, US | |
2267762 | 2267762 | 2022-10-22 | Cote d'Ivoire | 87693 | 827 | 0 | 7.54 | -5.5471 | 2022-10-23 04:22:46 | Cote d'Ivoire | ||||
1592619 | 1592619 | 2022-10-21 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-22 04:22:53 | Tuscaloosa, Alabama, US | |
1592062 | 1592062 | 2022-10-21 | Cote d'Ivoire | 87691 | 827 | 0 | 7.54 | -5.5471 | 2022-10-22 04:22:53 | Cote d'Ivoire | ||||
2273736 | 2273736 | 2022-10-20 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-21 04:22:23 | Hinds, Mississippi, US | |
2272335 | 2272335 | 2022-10-20 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-21 04:22:23 | Tuscaloosa, Alabama, US | |
2271778 | 2271778 | 2022-10-20 | Cote d'Ivoire | 87676 | 827 | 0 | 7.54 | -5.5471 | 2022-10-21 04:22:23 | Cote d'Ivoire | ||||
200071 | 200071 | 2022-10-19 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-20 04:22:59 | Hinds, Mississippi, US | |
198113 | 198113 | 2022-10-19 | Cote d'Ivoire | 87657 | 827 | 0 | 7.54 | -5.5471 | 2022-10-20 04:22:59 | Cote d'Ivoire | ||||
2760245 | 2760245 | 2022-10-18 | US | Virginia | Chesterfield | 51041 | 91913 | 827 | 0 | 37.37373208 | -77.5868014 | 2022-10-19 04:22:26 | Chesterfield, Virginia, US | |
2758732 | 2758732 | 2022-10-18 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-19 04:22:26 | Hinds, Mississippi, US | |
2756774 | 2756774 | 2022-10-18 | Cote d'Ivoire | 87602 | 827 | 0 | 7.54 | -5.5471 | 2022-10-19 04:22:26 | Cote d'Ivoire | ||||
2028079 | 2028079 | 2022-10-17 | US | Virginia | Chesterfield | 51041 | 91858 | 827 | 0 | 37.37373208 | -77.5868014 | 2022-10-18 04:22:42 | Chesterfield, Virginia, US | |
2026566 | 2026566 | 2022-10-17 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-18 04:22:42 | Hinds, Mississippi, US | |
2024608 | 2024608 | 2022-10-17 | Cote d'Ivoire | 87602 | 827 | 0 | 7.54 | -5.5471 | 2022-10-18 04:22:42 | Cote d'Ivoire | ||||
2161344 | 2161344 | 2022-10-16 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-17 04:20:31 | Hinds, Mississippi, US | |
2159386 | 2159386 | 2022-10-16 | Cote d'Ivoire | 87598 | 827 | 0 | 7.54 | -5.5471 | 2022-10-17 04:20:31 | Cote d'Ivoire | ||||
517541 | 517541 | 2022-10-15 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-16 04:22:39 | Hinds, Mississippi, US | |
515583 | 515583 | 2022-10-15 | Cote d'Ivoire | 87535 | 827 | 0 | 7.54 | -5.5471 | 2022-10-16 04:22:39 | Cote d'Ivoire | ||||
2034598 | 2034598 | 2022-10-14 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-15 04:22:00 | Hinds, Mississippi, US | |
3755286 | 3755286 | 2022-10-13 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-14 04:22:28 | Hinds, Mississippi, US | |
3216111 | 3216111 | 2022-10-12 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-13 04:22:39 | Hinds, Mississippi, US | |
255567 | 255567 | 2022-09-08 | US | New York | Oneida | 36065 | 63085 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-09 04:21:11 | Oneida, New York, US | |
3747365 | 3747365 | 2022-09-07 | US | New York | Oneida | 36065 | 63017 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-08 04:21:02 | Oneida, New York, US | |
117005 | 117005 | 2022-09-06 | US | New York | Oneida | 36065 | 62970 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-07 04:20:59 | Oneida, New York, US | |
2635977 | 2635977 | 2022-09-05 | US | New York | Oneida | 36065 | 62938 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-06 04:21:02 | Oneida, New York, US | |
2989541 | 2989541 | 2022-09-04 | US | New York | Oneida | 36065 | 62901 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-05 04:21:01 | Oneida, New York, US | |
2715226 | 2715226 | 2022-09-03 | US | New York | Oneida | 36065 | 62865 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-04 04:21:22 | Oneida, New York, US | |
1395931 | 1395931 | 2022-09-02 | US | New York | Oneida | 36065 | 62824 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-03 04:21:04 | Oneida, New York, US | |
3550977 | 3550977 | 2022-09-01 | US | Washington | Yakima | 53077 | 79642 | 827 | 0 | 46.45738486 | -120.7380126 | 2022-09-02 04:21:07 | Yakima, Washington, US | |
3549760 | 3549760 | 2022-09-01 | US | New York | Oneida | 36065 | 62779 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-02 04:21:07 | Oneida, New York, US | |
2346897 | 2346897 | 2022-08-31 | US | Washington | Yakima | 53077 | 79642 | 827 | 0 | 46.45738486 | -120.7380126 | 2022-09-01 04:21:03 | Yakima, Washington, US | |
1349599 | 1349599 | 2022-08-10 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-11 04:20:49 | Utah, Utah, US | |
1089354 | 1089354 | 2022-08-09 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-10 04:20:57 | Utah, Utah, US | |
3546769 | 3546769 | 2022-08-08 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-09 04:20:34 | Utah, Utah, US | |
1073172 | 1073172 | 2022-08-07 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-08 04:21:08 | Utah, Utah, US | |
1943760 | 1943760 | 2022-08-06 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-07 04:20:54 | Utah, Utah, US | |
883559 | 883559 | 2022-08-05 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-06 04:20:56 | Utah, Utah, US | |
2011970 | 2011970 | 2022-08-04 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-05 04:20:52 | Utah, Utah, US | |
1648941 | 1648941 | 2022-06-23 | US | California | Merced | 6047 | 75148 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-24 04:20:58 | Merced, California, US | |
2188176 | 2188176 | 2022-06-22 | US | California | Merced | 6047 | 74836 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-23 04:20:55 | Merced, California, US | |
2187861 | 2187861 | 2022-06-22 | Russia | Sakhalin Oblast | 64967 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-23 04:20:55 | Sakhalin Oblast, Russia | |||
166607 | 166607 | 2022-06-21 | US | California | Merced | 6047 | 74804 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-22 04:20:54 | Merced, California, US | |
166292 | 166292 | 2022-06-21 | Russia | Sakhalin Oblast | 64962 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-22 04:20:54 | Sakhalin Oblast, Russia | |||
1763890 | 1763890 | 2022-06-20 | US | California | Merced | 6047 | 74778 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-21 04:20:56 | Merced, California, US | |
1763575 | 1763575 | 2022-06-20 | Russia | Sakhalin Oblast | 64961 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-21 04:20:56 | Sakhalin Oblast, Russia | |||
3270076 | 3270076 | 2022-06-19 | US | California | Merced | 6047 | 74362 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-20 04:21:01 | Merced, California, US | |
3269761 | 3269761 | 2022-06-19 | Russia | Sakhalin Oblast | 64958 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-20 04:21:01 | Sakhalin Oblast, Russia | |||
3397988 | 3397988 | 2022-06-18 | US | California | Merced | 6047 | 74352 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-19 04:20:51 | Merced, California, US | |
3397673 | 3397673 | 2022-06-18 | Russia | Sakhalin Oblast | 64947 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-19 04:20:51 | Sakhalin Oblast, Russia | |||
2311865 | 2311865 | 2022-06-17 | US | California | Merced | 6047 | 74348 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-18 04:21:10 | Merced, California, US | |
2311550 | 2311550 | 2022-06-17 | Russia | Sakhalin Oblast | 64935 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-18 04:21:10 | Sakhalin Oblast, Russia | |||
559054 | 559054 | 2022-06-16 | Russia | Sakhalin Oblast | 64929 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-17 04:20:56 | Sakhalin Oblast, Russia | |||
3982856 | 3982856 | 2022-06-15 | Russia | Sakhalin Oblast | 64924 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-16 04:20:55 | Sakhalin Oblast, Russia | |||
3582048 | 3582048 | 2022-06-02 | US | Virginia | Virginia Beach | 51810 | 94296 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-06-03 04:20:58 | Virginia Beach, Virginia, US | |
974341 | 974341 | 2022-06-01 | US | Virginia | Virginia Beach | 51810 | 94148 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-06-02 05:20:39 | Virginia Beach, Virginia, US | |
232648 | 232648 | 2022-05-31 | US | Virginia | Virginia Beach | 51810 | 93999 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-06-01 04:20:55 | Virginia Beach, Virginia, US | |
230291 | 230291 | 2022-05-31 | US | Illinois | Winnebago | 17201 | 81468 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-06-01 04:20:55 | Winnebago, Illinois, US | |
3189413 | 3189413 | 2022-05-30 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-31 04:20:51 | Virginia Beach, Virginia, US | |
3188121 | 3188121 | 2022-05-30 | US | Nebraska | Unassigned | 90031 | 7920 | 827 | 0 | 42.8997274 | 0.0 | 2022-05-31 04:20:51 | Unassigned, Nebraska, US | |
3187056 | 3187056 | 2022-05-30 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-31 04:20:51 | Winnebago, Illinois, US | |
3201562 | 3201562 | 2022-05-29 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-30 04:20:50 | Virginia Beach, Virginia, US | |
3200270 | 3200270 | 2022-05-29 | US | Nebraska | Unassigned | 90031 | 7920 | 827 | 0 | 42.8997274 | 0.0 | 2022-05-30 04:20:50 | Unassigned, Nebraska, US | |
3199205 | 3199205 | 2022-05-29 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-30 04:20:50 | Winnebago, Illinois, US | |
2728440 | 2728440 | 2022-05-28 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-29 04:20:53 | Virginia Beach, Virginia, US | |
2727148 | 2727148 | 2022-05-28 | US | Nebraska | Unassigned | 90031 | 7998 | 827 | 0 | 42.8997274 | 0.0 | 2022-05-29 04:20:53 | Unassigned, Nebraska, US | |
2726083 | 2726083 | 2022-05-28 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-29 04:20:53 | Winnebago, Illinois, US | |
1317621 | 1317621 | 2022-05-27 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-28 04:21:07 | Virginia Beach, Virginia, US | |
1315264 | 1315264 | 2022-05-27 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-28 04:21:07 | Winnebago, Illinois, US | |
1853413 | 1853413 | 2022-05-26 | US | Virginia | Virginia Beach | 51810 | 93356 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-27 04:20:56 | Virginia Beach, Virginia, US | |
1851056 | 1851056 | 2022-05-26 | US | Illinois | Winnebago | 17201 | 80876 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-27 04:20:56 | Winnebago, Illinois, 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]);