johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
382 rows where deaths = 847 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756377 | 2756377 | 2022-12-29 | US | Washington | Yakima | 53077 | 82272 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-30 04:21:04 | Yakima, Washington, US | |
2752896 | 2752896 | 2022-12-29 | Japan | Gifu | 446219 | 847 | 0 | 35.778671 | 137.055925 | 2022-12-30 04:21:04 | Gifu, Japan | |||
1077383 | 1077383 | 2022-12-28 | US | Washington | Yakima | 53077 | 82272 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-29 04:21:01 | Yakima, Washington, US | |
331380 | 331380 | 2022-12-27 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-28 04:21:04 | Yakima, Washington, US | |
221453 | 221453 | 2022-12-26 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-27 04:21:07 | Yakima, Washington, US | |
3225910 | 3225910 | 2022-12-25 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-26 04:21:06 | Yakima, Washington, US | |
1021824 | 1021824 | 2022-12-24 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-25 04:21:04 | Yakima, Washington, US | |
693847 | 693847 | 2022-12-23 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-24 04:21:02 | Yakima, Washington, US | |
2183057 | 2183057 | 2022-12-22 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-23 04:21:04 | Yakima, Washington, US | |
454861 | 454861 | 2022-12-21 | US | Washington | Yakima | 53077 | 82159 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-22 04:20:56 | Yakima, Washington, US | |
1966292 | 1966292 | 2022-11-30 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-12-01 04:21:03 | Dakota, Minnesota, US | |
1965157 | 1965157 | 2022-11-30 | US | California | San Mateo | 6081 | 184295 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-12-01 04:21:03 | San Mateo, California, US | |
2558306 | 2558306 | 2022-11-29 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-30 04:21:07 | Dakota, Minnesota, US | |
2557171 | 2557171 | 2022-11-29 | US | California | San Mateo | 6081 | 184284 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-30 04:21:07 | San Mateo, California, US | |
1241918 | 1241918 | 2022-11-28 | US | New York | Oneida | 36065 | 66535 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-29 04:21:05 | Oneida, New York, US | |
1241380 | 1241380 | 2022-11-28 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-29 04:21:05 | Dakota, Minnesota, US | |
1240245 | 1240245 | 2022-11-28 | US | California | San Mateo | 6081 | 183561 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-29 04:21:05 | San Mateo, California, US | |
3553906 | 3553906 | 2022-11-27 | US | New York | Oneida | 36065 | 66517 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-28 04:21:02 | Oneida, New York, US | |
3553368 | 3553368 | 2022-11-27 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-28 04:21:02 | Dakota, Minnesota, US | |
3552233 | 3552233 | 2022-11-27 | US | California | San Mateo | 6081 | 183539 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-28 04:21:02 | San Mateo, California, US | |
2102386 | 2102386 | 2022-11-26 | US | New York | Oneida | 36065 | 66509 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-27 04:21:05 | Oneida, New York, US | |
2101848 | 2101848 | 2022-11-26 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-27 04:21:05 | Dakota, Minnesota, US | |
2100713 | 2100713 | 2022-11-26 | US | California | San Mateo | 6081 | 183529 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-27 04:21:05 | San Mateo, California, US | |
489877 | 489877 | 2022-11-25 | US | New York | Oneida | 36065 | 66501 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-26 04:21:11 | Oneida, New York, US | |
489339 | 489339 | 2022-11-25 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-26 04:21:11 | Dakota, Minnesota, US | |
488204 | 488204 | 2022-11-25 | US | California | San Mateo | 6081 | 183518 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-26 04:21:11 | San Mateo, California, US | |
3525706 | 3525706 | 2022-11-24 | US | New York | Oneida | 36065 | 66483 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-25 04:21:06 | Oneida, New York, US | |
3525168 | 3525168 | 2022-11-24 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-25 04:21:06 | Dakota, Minnesota, US | |
3524033 | 3524033 | 2022-11-24 | US | California | San Mateo | 6081 | 183511 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-25 04:21:06 | San Mateo, California, US | |
3314489 | 3314489 | 2022-11-23 | US | New York | Oneida | 36065 | 66461 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-24 04:21:09 | Oneida, New York, US | |
3313951 | 3313951 | 2022-11-23 | US | Minnesota | Dakota | 27037 | 131793 | 847 | 0 | 44.67172617 | -93.06299363 | 2022-11-24 04:21:09 | Dakota, Minnesota, US | |
3312816 | 3312816 | 2022-11-23 | US | California | San Mateo | 6081 | 183506 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-24 04:21:09 | San Mateo, California, US | |
1622530 | 1622530 | 2022-11-22 | US | New York | Oneida | 36065 | 66439 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-23 04:21:06 | Oneida, New York, US | |
1621975 | 1621975 | 2022-11-22 | US | Minnesota | Anoka | 27003 | 114469 | 847 | 0 | 45.27476015 | -93.24604565 | 2022-11-23 04:21:06 | Anoka, Minnesota, US | |
1620857 | 1620857 | 2022-11-22 | US | California | San Mateo | 6081 | 183494 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-23 04:21:06 | San Mateo, California, US | |
3462418 | 3462418 | 2022-11-21 | US | New York | Oneida | 36065 | 66429 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-22 04:20:47 | Oneida, New York, US | |
3461863 | 3461863 | 2022-11-21 | US | Minnesota | Anoka | 27003 | 114469 | 847 | 0 | 45.27476015 | -93.24604565 | 2022-11-22 04:20:47 | Anoka, Minnesota, US | |
3460745 | 3460745 | 2022-11-21 | US | California | San Mateo | 6081 | 182778 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-22 04:20:47 | San Mateo, California, US | |
1642603 | 1642603 | 2022-11-20 | US | New York | Oneida | 36065 | 66418 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-21 04:21:05 | Oneida, New York, US | |
1642048 | 1642048 | 2022-11-20 | US | Minnesota | Anoka | 27003 | 114469 | 847 | 0 | 45.27476015 | -93.24604565 | 2022-11-21 04:21:05 | Anoka, Minnesota, US | |
1640930 | 1640930 | 2022-11-20 | US | California | San Mateo | 6081 | 182761 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-21 04:21:05 | San Mateo, California, US | |
2066160 | 2066160 | 2022-11-19 | US | New York | Oneida | 36065 | 66402 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-20 04:21:08 | Oneida, New York, US | |
2065605 | 2065605 | 2022-11-19 | US | Minnesota | Anoka | 27003 | 114469 | 847 | 0 | 45.27476015 | -93.24604565 | 2022-11-20 04:21:08 | Anoka, Minnesota, US | |
2064487 | 2064487 | 2022-11-19 | US | California | San Mateo | 6081 | 182754 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-20 04:21:08 | San Mateo, California, US | |
1757554 | 1757554 | 2022-11-18 | US | New York | Oneida | 36065 | 66378 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-19 04:21:14 | Oneida, New York, US | |
1756999 | 1756999 | 2022-11-18 | US | Minnesota | Anoka | 27003 | 114469 | 847 | 0 | 45.27476015 | -93.24604565 | 2022-11-19 04:21:14 | Anoka, Minnesota, US | |
1755881 | 1755881 | 2022-11-18 | US | California | San Mateo | 6081 | 182744 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-19 04:21:14 | San Mateo, California, US | |
3028547 | 3028547 | 2022-11-17 | US | New York | Oneida | 36065 | 66352 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-18 04:21:15 | Oneida, New York, US | |
3027992 | 3027992 | 2022-11-17 | US | Minnesota | Anoka | 27003 | 114469 | 847 | 0 | 45.27476015 | -93.24604565 | 2022-11-18 04:21:15 | Anoka, Minnesota, US | |
3026874 | 3026874 | 2022-11-17 | US | California | San Mateo | 6081 | 182741 | 847 | 0 | 37.4228808 | -122.3275546 | 2022-11-18 04:21:15 | San Mateo, California, US | |
2488258 | 2488258 | 2022-11-16 | US | New York | Oneida | 36065 | 66303 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-17 04:21:11 | Oneida, New York, US | |
294269 | 294269 | 2022-11-15 | US | New York | Oneida | 36065 | 66283 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-16 04:21:09 | Oneida, New York, US | |
3599299 | 3599299 | 2022-11-14 | US | New York | Oneida | 36065 | 66266 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-15 04:21:16 | Oneida, New York, US | |
314157 | 314157 | 2022-11-13 | US | New York | Oneida | 36065 | 66252 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-14 04:21:09 | Oneida, New York, US | |
65318 | 65318 | 2022-11-12 | US | New York | Oneida | 36065 | 66245 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-13 04:21:14 | Oneida, New York, US | |
2929480 | 2929480 | 2022-11-11 | US | New York | Oneida | 36065 | 66229 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-12 04:20:41 | Oneida, New York, US | |
2508316 | 2508316 | 2022-11-10 | US | New York | Oneida | 36065 | 66201 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-11 04:21:22 | Oneida, New York, US | |
2434216 | 2434216 | 2022-11-09 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-10 04:21:16 | Utah, Utah, US | |
2433191 | 2433191 | 2022-11-09 | US | New York | Oneida | 36065 | 66176 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-10 04:21:16 | Oneida, New York, US | |
482872 | 482872 | 2022-11-08 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-09 04:21:22 | Utah, Utah, US | |
481847 | 481847 | 2022-11-08 | US | New York | Oneida | 36065 | 66143 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-09 04:21:22 | Oneida, New York, US | |
480245 | 480245 | 2022-11-08 | US | Colorado | Pueblo | 8101 | 58461 | 847 | 0 | 38.17359144 | -104.5127437 | 2022-11-09 04:21:22 | Pueblo, Colorado, US | |
2442022 | 2442022 | 2022-11-07 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-08 04:21:21 | Utah, Utah, US | |
2440997 | 2440997 | 2022-11-07 | US | New York | Oneida | 36065 | 66111 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-08 04:21:21 | Oneida, New York, US | |
2439395 | 2439395 | 2022-11-07 | US | Colorado | Pueblo | 8101 | 58394 | 847 | 0 | 38.17359144 | -104.5127437 | 2022-11-08 04:21:21 | Pueblo, Colorado, US | |
1053120 | 1053120 | 2022-11-06 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-07 04:21:26 | Utah, Utah, US | |
1052095 | 1052095 | 2022-11-06 | US | New York | Oneida | 36065 | 66084 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-07 04:21:26 | Oneida, New York, US | |
621144 | 621144 | 2022-11-05 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-06 04:21:24 | Utah, Utah, US | |
620119 | 620119 | 2022-11-05 | US | New York | Oneida | 36065 | 66055 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-06 04:21:24 | Oneida, New York, US | |
1025648 | 1025648 | 2022-11-04 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-05 04:21:52 | Utah, Utah, US | |
1024623 | 1024623 | 2022-11-04 | US | New York | Oneida | 36065 | 66017 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-05 04:21:52 | Oneida, New York, US | |
434639 | 434639 | 2022-11-03 | US | Utah | Utah | 49049 | 220199 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-04 04:22:11 | Utah, Utah, US | |
433614 | 433614 | 2022-11-03 | US | New York | Oneida | 36065 | 65971 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-04 04:22:11 | Oneida, New York, US | |
852881 | 852881 | 2022-11-02 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-03 04:22:05 | Utah, Utah, US | |
851856 | 851856 | 2022-11-02 | US | New York | Oneida | 36065 | 65924 | 847 | 0 | 43.24375382 | -75.43710392 | 2022-11-03 04:22:05 | Oneida, New York, US | |
713732 | 713732 | 2022-11-01 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-02 04:22:09 | Utah, Utah, US | |
3288181 | 3288181 | 2022-10-31 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-11-01 04:22:36 | Utah, Utah, US | |
323214 | 323214 | 2022-10-30 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-10-31 04:21:36 | Utah, Utah, US | |
915490 | 915490 | 2022-10-29 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-10-30 04:22:14 | Utah, Utah, US | |
1369759 | 1369759 | 2022-10-28 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-10-29 04:21:13 | Utah, Utah, US | |
3041614 | 3041614 | 2022-10-27 | US | Utah | Utah | 49049 | 219885 | 847 | 0 | 40.1166722 | -111.6657662 | 2022-10-28 04:22:31 | Utah, Utah, US | |
1832837 | 1832837 | 2022-10-25 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-26 04:22:19 | Lackawanna, Pennsylvania, US | |
797098 | 797098 | 2022-10-24 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-25 04:21:53 | Lackawanna, Pennsylvania, US | |
3279553 | 3279553 | 2022-10-23 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-24 04:22:29 | Lackawanna, Pennsylvania, US | |
2270591 | 2270591 | 2022-10-22 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-23 04:22:46 | Lackawanna, Pennsylvania, US | |
1594891 | 1594891 | 2022-10-21 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-22 04:22:53 | Lackawanna, Pennsylvania, US | |
2274607 | 2274607 | 2022-10-20 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-21 04:22:23 | Lackawanna, Pennsylvania, US | |
200942 | 200942 | 2022-10-19 | US | Pennsylvania | Lackawanna | 42069 | 54165 | 847 | 0 | 41.43564672 | -75.60379201 | 2022-10-20 04:22:59 | Lackawanna, Pennsylvania, US | |
2395484 | 2395484 | 2022-09-12 | US | Florida | Bay | 12005 | 53174 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-13 04:20:57 | Bay, Florida, US | |
3766562 | 3766562 | 2022-09-11 | US | Florida | Bay | 12005 | 53174 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-12 04:20:58 | Bay, Florida, US | |
3825137 | 3825137 | 2022-09-10 | US | Florida | Bay | 12005 | 53174 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-11 04:20:50 | Bay, Florida, US | |
963594 | 963594 | 2022-09-09 | US | Florida | Bay | 12005 | 53174 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-10 04:21:10 | Bay, Florida, US | |
253996 | 253996 | 2022-09-08 | US | Florida | Bay | 12005 | 52693 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-09 04:21:11 | Bay, Florida, US | |
3745794 | 3745794 | 2022-09-07 | US | Florida | Bay | 12005 | 52693 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-08 04:21:02 | Bay, Florida, US | |
115434 | 115434 | 2022-09-06 | US | Florida | Bay | 12005 | 52693 | 847 | 0 | 30.26548745 | -85.62122584 | 2022-09-07 04:20:59 | Bay, Florida, US | |
2343750 | 2343750 | 2022-08-31 | Sweden | Ostergotland | 96947 | 847 | 0 | 58.3454 | 15.5198 | 2022-09-01 04:21:03 | Ostergotland, Sweden | |||
3774230 | 3774230 | 2022-08-30 | Sweden | Ostergotland | 96947 | 847 | 0 | 58.3454 | 15.5198 | 2022-08-31 04:20:57 | Ostergotland, Sweden | |||
1680826 | 1680826 | 2022-08-29 | Sweden | Ostergotland | 96947 | 847 | 0 | 58.3454 | 15.5198 | 2022-08-30 04:21:03 | Ostergotland, Sweden | |||
1877310 | 1877310 | 2022-08-28 | Sweden | Ostergotland | 96947 | 847 | 0 | 58.3454 | 15.5198 | 2022-08-29 04:21:06 | Ostergotland, Sweden | |||
2096437 | 2096437 | 2022-08-27 | Sweden | Ostergotland | 96947 | 847 | 0 | 58.3454 | 15.5198 | 2022-08-28 04:21:02 | Ostergotland, Sweden |
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]);