johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
470 rows where deaths = 678 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754020 | 2754020 | 2022-12-29 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-30 04:21:04 | Madison, Indiana, US | |
1075026 | 1075026 | 2022-12-28 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-29 04:21:01 | Madison, Indiana, US | |
329023 | 329023 | 2022-12-27 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-28 04:21:04 | Madison, Indiana, US | |
219096 | 219096 | 2022-12-26 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-27 04:21:07 | Madison, Indiana, US | |
3223553 | 3223553 | 2022-12-25 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-26 04:21:06 | Madison, Indiana, US | |
1019467 | 1019467 | 2022-12-24 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-25 04:21:04 | Madison, Indiana, US | |
691490 | 691490 | 2022-12-23 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-24 04:21:02 | Madison, Indiana, US | |
2180700 | 2180700 | 2022-12-22 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-23 04:21:04 | Madison, Indiana, US | |
452504 | 452504 | 2022-12-21 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-22 04:20:56 | Madison, Indiana, US | |
2952503 | 2952503 | 2022-12-20 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-21 04:21:03 | Madison, Indiana, US | |
3174905 | 3174905 | 2022-12-19 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-20 04:21:04 | Madison, Indiana, US | |
1629422 | 1629422 | 2022-12-18 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-19 04:21:03 | Madison, Indiana, US | |
504801 | 504801 | 2022-12-17 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-18 04:21:03 | Madison, Indiana, US | |
3325373 | 3325373 | 2022-12-16 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-17 04:21:04 | Madison, Indiana, US | |
543885 | 543885 | 2022-12-15 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-16 04:21:01 | Madison, Indiana, US | |
349413 | 349413 | 2022-12-14 | US | Indiana | Madison | 18095 | 38433 | 678 | 0 | 40.16143691 | -85.71964711 | 2022-12-15 04:20:58 | Madison, Indiana, US | |
1984974 | 1984974 | 2022-12-07 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-08 04:21:07 | Sormland, Sweden | |||
3714497 | 3714497 | 2022-12-06 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-07 04:20:58 | Sormland, Sweden | |||
2415202 | 2415202 | 2022-12-05 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-06 04:21:03 | Sormland, Sweden | |||
718810 | 718810 | 2022-12-04 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-05 04:20:58 | Sormland, Sweden | |||
2817099 | 2817099 | 2022-12-03 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-04 04:20:56 | Sormland, Sweden | |||
833955 | 833955 | 2022-12-02 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-03 04:21:02 | Sormland, Sweden | |||
2136485 | 2136485 | 2022-12-01 | Sweden | Sormland | 68902 | 678 | 0 | 59.0336 | 16.7519 | 2022-12-02 04:21:07 | Sormland, Sweden | |||
3552387 | 3552387 | 2022-11-27 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-28 04:21:02 | Santa Rosa, Florida, US | |
2100867 | 2100867 | 2022-11-26 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-27 04:21:05 | Santa Rosa, Florida, US | |
488358 | 488358 | 2022-11-25 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-26 04:21:11 | Santa Rosa, Florida, US | |
3524187 | 3524187 | 2022-11-24 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-25 04:21:06 | Santa Rosa, Florida, US | |
3312970 | 3312970 | 2022-11-23 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-24 04:21:09 | Santa Rosa, Florida, US | |
1621011 | 1621011 | 2022-11-22 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-23 04:21:06 | Santa Rosa, Florida, US | |
3460899 | 3460899 | 2022-11-21 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-22 04:20:47 | Santa Rosa, Florida, US | |
1641084 | 1641084 | 2022-11-20 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-21 04:21:05 | Santa Rosa, Florida, US | |
2064641 | 2064641 | 2022-11-19 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-20 04:21:08 | Santa Rosa, Florida, US | |
1756035 | 1756035 | 2022-11-18 | US | Florida | Santa Rosa | 12113 | 56967 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-19 04:21:14 | Santa Rosa, Florida, US | |
3029850 | 3029850 | 2022-11-17 | US | Wisconsin | Kenosha | 55059 | 53371 | 678 | 0 | 42.57639354 | -88.04051686 | 2022-11-18 04:21:15 | Kenosha, Wisconsin, US | |
3027028 | 3027028 | 2022-11-17 | US | Florida | Santa Rosa | 12113 | 56833 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-18 04:21:15 | Santa Rosa, Florida, US | |
2486739 | 2486739 | 2022-11-16 | US | Florida | Santa Rosa | 12113 | 56833 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-17 04:21:11 | Santa Rosa, Florida, US | |
292750 | 292750 | 2022-11-15 | US | Florida | Santa Rosa | 12113 | 56833 | 678 | 0 | 30.6934145 | -87.02458128 | 2022-11-16 04:21:09 | Santa Rosa, Florida, US | |
313303 | 313303 | 2022-11-13 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-14 04:21:09 | Fayette, Kentucky, US | |
64464 | 64464 | 2022-11-12 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-13 04:21:14 | Fayette, Kentucky, US | |
2928626 | 2928626 | 2022-11-11 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-12 04:20:41 | Fayette, Kentucky, US | |
2507462 | 2507462 | 2022-11-10 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-11 04:21:22 | Fayette, Kentucky, US | |
2432337 | 2432337 | 2022-11-09 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-10 04:21:16 | Fayette, Kentucky, US | |
2431267 | 2431267 | 2022-11-09 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-10 04:21:16 | Vasternorrland, Sweden | |||
480993 | 480993 | 2022-11-08 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-09 04:21:22 | Fayette, Kentucky, US | |
479923 | 479923 | 2022-11-08 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-09 04:21:22 | Vasternorrland, Sweden | |||
2440143 | 2440143 | 2022-11-07 | US | Kentucky | Fayette | 21067 | 115677 | 678 | 0 | 38.0368225 | -84.45576892 | 2022-11-08 04:21:21 | Fayette, Kentucky, US | |
2439073 | 2439073 | 2022-11-07 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-08 04:21:21 | Vasternorrland, Sweden | |||
1050171 | 1050171 | 2022-11-06 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-07 04:21:26 | Vasternorrland, Sweden | |||
618195 | 618195 | 2022-11-05 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-06 04:21:24 | Vasternorrland, Sweden | |||
1022699 | 1022699 | 2022-11-04 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-05 04:21:52 | Vasternorrland, Sweden | |||
431690 | 431690 | 2022-11-03 | Sweden | Vasternorrland | 56363 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-04 04:22:11 | Vasternorrland, Sweden | |||
849932 | 849932 | 2022-11-02 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-03 04:22:05 | Vasternorrland, Sweden | |||
710783 | 710783 | 2022-11-01 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-02 04:22:09 | Vasternorrland, Sweden | |||
3285232 | 3285232 | 2022-10-31 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-11-01 04:22:36 | Vasternorrland, Sweden | |||
320265 | 320265 | 2022-10-30 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-10-31 04:21:36 | Vasternorrland, Sweden | |||
912541 | 912541 | 2022-10-29 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-10-30 04:22:14 | Vasternorrland, Sweden | |||
1366810 | 1366810 | 2022-10-28 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-10-29 04:21:13 | Vasternorrland, Sweden | |||
3038665 | 3038665 | 2022-10-27 | Sweden | Vasternorrland | 56224 | 678 | 0 | 63.4276 | 17.7292 | 2022-10-28 04:22:31 | Vasternorrland, Sweden | |||
2025292 | 2025292 | 2022-10-17 | US | Arkansas | Washington | 5143 | 76993 | 678 | 0 | 35.976844 | -94.21800746 | 2022-10-18 04:22:42 | Washington, Arkansas, US | |
3217575 | 3217575 | 2022-10-12 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-13 04:22:39 | Southwest Utah, Utah, US | ||
3214674 | 3214674 | 2022-10-12 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-13 04:22:39 | Etowah, Alabama, US | |
3253424 | 3253424 | 2022-10-11 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-12 04:22:51 | Southwest Utah, Utah, US | ||
3250523 | 3250523 | 2022-10-11 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-12 04:22:51 | Etowah, Alabama, US | |
2970683 | 2970683 | 2022-10-10 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-11 04:23:05 | Southwest Utah, Utah, US | ||
2967782 | 2967782 | 2022-10-10 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-11 04:23:05 | Etowah, Alabama, US | |
3100719 | 3100719 | 2022-10-09 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-10 04:22:32 | Southwest Utah, Utah, US | ||
3097818 | 3097818 | 2022-10-09 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-10 04:22:32 | Etowah, Alabama, US | |
4005944 | 4005944 | 2022-10-08 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-09 04:21:16 | Southwest Utah, Utah, US | ||
4003043 | 4003043 | 2022-10-08 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-09 04:21:16 | Etowah, Alabama, US | |
399541 | 399541 | 2022-10-07 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-08 04:22:56 | Southwest Utah, Utah, US | ||
396640 | 396640 | 2022-10-07 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-08 04:22:56 | Etowah, Alabama, US | |
2532658 | 2532658 | 2022-10-06 | US | Utah | Southwest Utah | 69287 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-07 04:23:08 | Southwest Utah, Utah, US | ||
2529757 | 2529757 | 2022-10-06 | US | Alabama | Etowah | 1055 | 32116 | 678 | 0 | 34.04567266 | -86.04051873 | 2022-10-07 04:23:08 | Etowah, Alabama, US | |
1814052 | 1814052 | 2022-10-05 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-06 04:21:22 | Southwest Utah, Utah, US | ||
134026 | 134026 | 2022-10-04 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-05 04:23:06 | Southwest Utah, Utah, US | ||
2688973 | 2688973 | 2022-10-03 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-04 04:22:55 | Southwest Utah, Utah, US | ||
2263040 | 2263040 | 2022-10-02 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-03 04:23:11 | Southwest Utah, Utah, US | ||
2998566 | 2998566 | 2022-10-01 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-02 04:21:23 | Southwest Utah, Utah, US | ||
856892 | 856892 | 2022-09-30 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-10-01 04:23:01 | Southwest Utah, Utah, US | ||
2378818 | 2378818 | 2022-09-29 | US | Utah | Southwest Utah | 69198 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-30 04:23:09 | Southwest Utah, Utah, US | ||
1563369 | 1563369 | 2022-09-28 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-29 04:22:34 | Southwest Utah, Utah, US | ||
3997912 | 3997912 | 2022-09-27 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-28 04:23:01 | Southwest Utah, Utah, US | ||
3994608 | 3994608 | 2022-09-27 | Italy | Molise | 89865 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-28 04:23:01 | Molise, Italy | |||
2772240 | 2772240 | 2022-09-26 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-27 04:23:01 | Southwest Utah, Utah, US | ||
2768936 | 2768936 | 2022-09-26 | Italy | Molise | 89771 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-27 04:23:01 | Molise, Italy | |||
1979893 | 1979893 | 2022-09-25 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-26 04:20:52 | Southwest Utah, Utah, US | ||
1976589 | 1976589 | 2022-09-25 | Italy | Molise | 89713 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-26 04:20:52 | Molise, Italy | |||
1976385 | 1976385 | 2022-09-25 | Chile | Atacama | 101174 | 678 | 0 | -27.5661 | -70.0503 | 2022-09-26 04:20:52 | Atacama, Chile | |||
2653060 | 2653060 | 2022-09-24 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-25 04:23:31 | Southwest Utah, Utah, US | ||
2649756 | 2649756 | 2022-09-24 | Italy | Molise | 89625 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-25 04:23:31 | Molise, Italy | |||
2649552 | 2649552 | 2022-09-24 | Chile | Atacama | 101122 | 678 | 0 | -27.5661 | -70.0503 | 2022-09-25 04:23:31 | Atacama, Chile | |||
387500 | 387500 | 2022-09-23 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-24 04:21:40 | Southwest Utah, Utah, US | ||
384196 | 384196 | 2022-09-23 | Italy | Molise | 89534 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-24 04:21:40 | Molise, Italy | |||
383992 | 383992 | 2022-09-23 | Chile | Atacama | 101041 | 678 | 0 | -27.5661 | -70.0503 | 2022-09-24 04:21:40 | Atacama, Chile | |||
1627566 | 1627566 | 2022-09-22 | US | Utah | Southwest Utah | 69106 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-23 04:23:13 | Southwest Utah, Utah, US | ||
1624262 | 1624262 | 2022-09-22 | Italy | Molise | 89432 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-23 04:23:13 | Molise, Italy | |||
1373770 | 1373770 | 2022-09-21 | US | Utah | Southwest Utah | 69019 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-22 04:22:56 | Southwest Utah, Utah, US | ||
1370466 | 1370466 | 2022-09-21 | Italy | Molise | 89298 | 678 | 0 | 41.55774754 | 14.65916051 | 2022-09-22 04:22:56 | Molise, Italy | |||
2020000 | 2020000 | 2022-09-20 | US | Utah | Southwest Utah | 69019 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-21 04:23:22 | Southwest Utah, Utah, US | ||
3573873 | 3573873 | 2022-09-19 | US | Utah | Southwest Utah | 69019 | 678 | 0 | 37.85447192 | -111.4418764 | 2022-09-20 04:22:48 | Southwest Utah, Utah, 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]);