johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
431 rows where deaths = 823 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2273897 | 2273897 | 2022-10-20 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-21 04:22:23 | St. Louis City, Missouri, US | |
200232 | 200232 | 2022-10-19 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-20 04:22:59 | St. Louis City, Missouri, US | |
2758893 | 2758893 | 2022-10-18 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-19 04:22:26 | St. Louis City, Missouri, US | |
2026727 | 2026727 | 2022-10-17 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-18 04:22:42 | St. Louis City, Missouri, US | |
2161505 | 2161505 | 2022-10-16 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-17 04:20:31 | St. Louis City, Missouri, US | |
517702 | 517702 | 2022-10-15 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-16 04:22:39 | St. Louis City, Missouri, US | |
2034759 | 2034759 | 2022-10-14 | US | Missouri | St. Louis City | 29510 | 70946 | 823 | 0 | 38.63555736 | -90.24349225 | 2022-10-15 04:22:00 | St. Louis City, Missouri, US | |
3754495 | 3754495 | 2022-10-13 | US | Illinois | Madison | 17119 | 82487 | 823 | 0 | 38.83042506 | -89.90422563 | 2022-10-14 04:22:28 | Madison, Illinois, US | |
3253473 | 3253473 | 2022-10-11 | US | Virginia | Chesterfield | 51041 | 91599 | 823 | 0 | 37.37373208 | -77.5868014 | 2022-10-12 04:22:51 | Chesterfield, Virginia, US | |
3996448 | 3996448 | 2022-09-27 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-28 04:23:01 | Hinds, Mississippi, US | |
2770776 | 2770776 | 2022-09-26 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-27 04:23:01 | Hinds, Mississippi, US | |
2768818 | 2768818 | 2022-09-26 | Cote d'Ivoire | 87135 | 823 | 0 | 7.54 | -5.5471 | 2022-09-27 04:23:01 | Cote d'Ivoire | ||||
1978429 | 1978429 | 2022-09-25 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-26 04:20:52 | Hinds, Mississippi, US | |
1976471 | 1976471 | 2022-09-25 | Cote d'Ivoire | 87135 | 823 | 0 | 7.54 | -5.5471 | 2022-09-26 04:20:52 | Cote d'Ivoire | ||||
2651596 | 2651596 | 2022-09-24 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-25 04:23:31 | Hinds, Mississippi, US | |
2649638 | 2649638 | 2022-09-24 | Cote d'Ivoire | 87129 | 823 | 0 | 7.54 | -5.5471 | 2022-09-25 04:23:31 | Cote d'Ivoire | ||||
386036 | 386036 | 2022-09-23 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-24 04:21:40 | Hinds, Mississippi, US | |
384078 | 384078 | 2022-09-23 | Cote d'Ivoire | 87123 | 823 | 0 | 7.54 | -5.5471 | 2022-09-24 04:21:40 | Cote d'Ivoire | ||||
1626102 | 1626102 | 2022-09-22 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-23 04:23:13 | Hinds, Mississippi, US | |
1624144 | 1624144 | 2022-09-22 | Cote d'Ivoire | 87094 | 823 | 0 | 7.54 | -5.5471 | 2022-09-23 04:23:13 | Cote d'Ivoire | ||||
1372306 | 1372306 | 2022-09-21 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-22 04:22:56 | Hinds, Mississippi, US | |
1370348 | 1370348 | 2022-09-21 | Cote d'Ivoire | 87081 | 823 | 0 | 7.54 | -5.5471 | 2022-09-22 04:22:56 | Cote d'Ivoire | ||||
2018536 | 2018536 | 2022-09-20 | US | Mississippi | Hinds | 28049 | 63067 | 823 | 0 | 32.2656285 | -90.44435448 | 2022-09-21 04:23:22 | Hinds, Mississippi, US | |
2016578 | 2016578 | 2022-09-20 | Cote d'Ivoire | 87073 | 823 | 0 | 7.54 | -5.5471 | 2022-09-21 04:23:22 | Cote d'Ivoire | ||||
1891355 | 1891355 | 2022-09-14 | US | New Mexico | San Juan | 35045 | 47105 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-15 04:21:02 | San Juan, New Mexico, US | |
1890843 | 1890843 | 2022-09-14 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-15 04:21:02 | Anoka, Minnesota, US | |
1888831 | 1888831 | 2022-09-14 | Bahamas | 37156 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-15 04:21:02 | Bahamas | ||||
374410 | 374410 | 2022-09-13 | US | New Mexico | San Juan | 35045 | 47092 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-14 04:20:44 | San Juan, New Mexico, US | |
373898 | 373898 | 2022-09-13 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-14 04:20:44 | Anoka, Minnesota, US | |
371886 | 371886 | 2022-09-13 | Bahamas | 37156 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-14 04:20:44 | Bahamas | ||||
2397012 | 2397012 | 2022-09-12 | US | New Mexico | San Juan | 35045 | 47083 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-13 04:20:57 | San Juan, New Mexico, US | |
2396500 | 2396500 | 2022-09-12 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-13 04:20:57 | Anoka, Minnesota, US | |
2394491 | 2394491 | 2022-09-12 | Bahamas | 37156 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-13 04:20:57 | Bahamas | ||||
3768090 | 3768090 | 2022-09-11 | US | New Mexico | San Juan | 35045 | 47054 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-12 04:20:58 | San Juan, New Mexico, US | |
3767578 | 3767578 | 2022-09-11 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-12 04:20:58 | Anoka, Minnesota, US | |
3765569 | 3765569 | 2022-09-11 | Bahamas | 37146 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-12 04:20:58 | Bahamas | ||||
3826665 | 3826665 | 2022-09-10 | US | New Mexico | San Juan | 35045 | 47054 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-11 04:20:50 | San Juan, New Mexico, US | |
3826153 | 3826153 | 2022-09-10 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-11 04:20:50 | Anoka, Minnesota, US | |
3824144 | 3824144 | 2022-09-10 | Bahamas | 37125 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-11 04:20:50 | Bahamas | ||||
965122 | 965122 | 2022-09-09 | US | New Mexico | San Juan | 35045 | 47054 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-10 04:21:10 | San Juan, New Mexico, US | |
964610 | 964610 | 2022-09-09 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-10 04:21:10 | Anoka, Minnesota, US | |
962601 | 962601 | 2022-09-09 | Bahamas | 37125 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-10 04:21:10 | Bahamas | ||||
255524 | 255524 | 2022-09-08 | US | New Mexico | San Juan | 35045 | 47038 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-09 04:21:11 | San Juan, New Mexico, US | |
255012 | 255012 | 2022-09-08 | US | Minnesota | Anoka | 27003 | 110960 | 823 | 0 | 45.27476015 | -93.24604565 | 2022-09-09 04:21:11 | Anoka, Minnesota, US | |
253003 | 253003 | 2022-09-08 | Bahamas | 37101 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-09 04:21:11 | Bahamas | ||||
3747322 | 3747322 | 2022-09-07 | US | New Mexico | San Juan | 35045 | 47013 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-08 04:21:02 | San Juan, New Mexico, US | |
3744801 | 3744801 | 2022-09-07 | Bahamas | 37101 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-08 04:21:02 | Bahamas | ||||
116962 | 116962 | 2022-09-06 | US | New Mexico | San Juan | 35045 | 46995 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-07 04:20:59 | San Juan, New Mexico, US | |
114441 | 114441 | 2022-09-06 | Bahamas | 37101 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-07 04:20:59 | Bahamas | ||||
2635934 | 2635934 | 2022-09-05 | US | New Mexico | San Juan | 35045 | 46932 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-06 04:21:02 | San Juan, New Mexico, US | |
2635405 | 2635405 | 2022-09-05 | US | Michigan | Ottawa | 26139 | 82644 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-09-06 04:21:02 | Ottawa, Michigan, US | |
2633413 | 2633413 | 2022-09-05 | Bahamas | 37101 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-06 04:21:02 | Bahamas | ||||
2989498 | 2989498 | 2022-09-04 | US | New Mexico | San Juan | 35045 | 46932 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-05 04:21:01 | San Juan, New Mexico, US | |
2988969 | 2988969 | 2022-09-04 | US | Michigan | Ottawa | 26139 | 82644 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-09-05 04:21:01 | Ottawa, Michigan, US | |
2986977 | 2986977 | 2022-09-04 | Bahamas | 37081 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-05 04:21:01 | Bahamas | ||||
2715183 | 2715183 | 2022-09-03 | US | New Mexico | San Juan | 35045 | 46932 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-04 04:21:22 | San Juan, New Mexico, US | |
2714654 | 2714654 | 2022-09-03 | US | Michigan | Ottawa | 26139 | 82644 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-09-04 04:21:22 | Ottawa, Michigan, US | |
2712662 | 2712662 | 2022-09-03 | Bahamas | 37081 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-04 04:21:22 | Bahamas | ||||
1395888 | 1395888 | 2022-09-02 | US | New Mexico | San Juan | 35045 | 46932 | 823 | 0 | 36.50838318 | -108.320437 | 2022-09-03 04:21:04 | San Juan, New Mexico, US | |
1395359 | 1395359 | 2022-09-02 | US | Michigan | Ottawa | 26139 | 82644 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-09-03 04:21:04 | Ottawa, Michigan, US | |
1393367 | 1393367 | 2022-09-02 | Bahamas | 37081 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-03 04:21:04 | Bahamas | ||||
3549188 | 3549188 | 2022-09-01 | US | Michigan | Ottawa | 26139 | 82644 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-09-02 04:21:07 | Ottawa, Michigan, US | |
3547196 | 3547196 | 2022-09-01 | Bahamas | 37081 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-02 04:21:07 | Bahamas | ||||
2345108 | 2345108 | 2022-08-31 | US | Michigan | Ottawa | 26139 | 82644 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-09-01 04:21:03 | Ottawa, Michigan, US | |
2343116 | 2343116 | 2022-08-31 | Bahamas | 37075 | 823 | 0 | 25.025885 | -78.035889 | 2022-09-01 04:21:03 | Bahamas | ||||
3773596 | 3773596 | 2022-08-30 | Bahamas | 37059 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-31 04:20:57 | Bahamas | ||||
1680192 | 1680192 | 2022-08-29 | Bahamas | 37059 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-30 04:21:03 | Bahamas | ||||
1876676 | 1876676 | 2022-08-28 | Bahamas | 37044 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-29 04:21:06 | Bahamas | ||||
2095803 | 2095803 | 2022-08-27 | Bahamas | 37044 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-28 04:21:02 | Bahamas | ||||
1531618 | 1531618 | 2022-08-26 | Bahamas | 37044 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-27 04:20:57 | Bahamas | ||||
2828505 | 2828505 | 2022-08-25 | Bahamas | 37032 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-26 04:21:02 | Bahamas | ||||
2323244 | 2323244 | 2022-08-24 | Germany | Bremen | 248456 | 823 | 0 | 53.0793 | 8.8017 | 2022-08-25 04:21:13 | Bremen, Germany | |||
2323038 | 2323038 | 2022-08-24 | Bahamas | 36996 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-25 04:21:13 | Bahamas | ||||
1254228 | 1254228 | 2022-08-23 | US | Washington | Yakima | 53077 | 79242 | 823 | 0 | 46.45738486 | -120.7380126 | 2022-08-24 04:20:46 | Yakima, Washington, US | |
1250447 | 1250447 | 2022-08-23 | Bahamas | 36996 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-24 04:20:46 | Bahamas | ||||
2856332 | 2856332 | 2022-08-22 | US | Washington | Yakima | 53077 | 79242 | 823 | 0 | 46.45738486 | -120.7380126 | 2022-08-23 04:20:56 | Yakima, Washington, US | |
2854543 | 2854543 | 2022-08-22 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-23 04:20:56 | Ottawa, Michigan, US | |
2852551 | 2852551 | 2022-08-22 | Bahamas | 36983 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-23 04:20:56 | Bahamas | ||||
2406304 | 2406304 | 2022-08-21 | US | Washington | Yakima | 53077 | 79107 | 823 | 0 | 46.45738486 | -120.7380126 | 2022-08-22 04:20:38 | Yakima, Washington, US | |
2404515 | 2404515 | 2022-08-21 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-22 04:20:38 | Ottawa, Michigan, US | |
2402523 | 2402523 | 2022-08-21 | Bahamas | 36983 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-22 04:20:38 | Bahamas | ||||
3801382 | 3801382 | 2022-08-20 | US | Washington | Yakima | 53077 | 79107 | 823 | 0 | 46.45738486 | -120.7380126 | 2022-08-21 04:20:44 | Yakima, Washington, US | |
3799593 | 3799593 | 2022-08-20 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-21 04:20:44 | Ottawa, Michigan, US | |
3797601 | 3797601 | 2022-08-20 | Bahamas | 36983 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-21 04:20:44 | Bahamas | ||||
2366968 | 2366968 | 2022-08-19 | US | Washington | Yakima | 53077 | 79107 | 823 | 0 | 46.45738486 | -120.7380126 | 2022-08-20 04:21:01 | Yakima, Washington, US | |
2365179 | 2365179 | 2022-08-19 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-20 04:21:01 | Ottawa, Michigan, US | |
2363187 | 2363187 | 2022-08-19 | Bahamas | 36958 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-20 04:21:01 | Bahamas | ||||
1162850 | 1162850 | 2022-08-18 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-19 04:20:54 | Ottawa, Michigan, US | |
1160858 | 1160858 | 2022-08-18 | Bahamas | 36958 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-19 04:20:54 | Bahamas | ||||
3952174 | 3952174 | 2022-08-17 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-18 04:21:11 | Ottawa, Michigan, US | |
3950182 | 3950182 | 2022-08-17 | Bahamas | 36944 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-18 04:21:11 | Bahamas | ||||
993248 | 993248 | 2022-08-16 | US | New York | Oneida | 36065 | 62060 | 823 | 0 | 43.24375382 | -75.43710392 | 2022-08-17 04:20:59 | Oneida, New York, US | |
992676 | 992676 | 2022-08-16 | US | Michigan | Ottawa | 26139 | 81987 | 823 | 0 | 42.95996803 | -85.9969107 | 2022-08-17 04:20:59 | Ottawa, Michigan, US | |
990684 | 990684 | 2022-08-16 | Bahamas | 36936 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-17 04:20:59 | Bahamas | ||||
2496287 | 2496287 | 2022-08-15 | US | New York | Oneida | 36065 | 62013 | 823 | 0 | 43.24375382 | -75.43710392 | 2022-08-16 04:20:58 | Oneida, New York, US | |
2493723 | 2493723 | 2022-08-15 | Bahamas | 36932 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-16 04:20:58 | Bahamas | ||||
3649837 | 3649837 | 2022-08-14 | US | New York | Oneida | 36065 | 61975 | 823 | 0 | 43.24375382 | -75.43710392 | 2022-08-15 04:20:59 | Oneida, New York, US | |
3647273 | 3647273 | 2022-08-14 | Bahamas | 36905 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-15 04:20:59 | Bahamas | ||||
1970843 | 1970843 | 2022-08-13 | US | New York | Oneida | 36065 | 61927 | 823 | 0 | 43.24375382 | -75.43710392 | 2022-08-14 04:20:55 | Oneida, New York, US | |
1968279 | 1968279 | 2022-08-13 | Bahamas | 36905 | 823 | 0 | 25.025885 | -78.035889 | 2022-08-14 04:20:55 | Bahamas |
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]);