daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
289 rows where active = 789 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | Italy | Basilicata | 27547 | 592 | 26166 | 789 | 40.63947052 | 15.80514834 | 2021-08-05 04:21:51 | Basilicata, Italy | ||
2021-07-22 | Canada | British Columbia | 148730 | 1763 | 146178 | 789 | 53.7267 | -127.6476 | 2021-07-23 04:21:29 | British Columbia, Canada | ||
2021-07-21 | India | Haryana | 769640 | 9611 | 759240 | 789 | 29.20004 | 76.332824 | 2021-07-22 04:21:19 | Haryana, India | ||
2021-07-12 | India | Bihar | 723355 | 9619 | 712947 | 789 | 25.679658 | 85.60484 | 2021-07-13 04:21:18 | Bihar, India | ||
2021-07-04 | Latvia | 137631 | 2528 | 134314 | 789 | 56.8796 | 24.6032 | 2021-07-05 04:21:28 | Latvia | |||
2021-06-17 | Ukraine | Ternopil Oblast | 69940 | 1192 | 67959 | 789 | 49.5535 | 25.5948 | 2021-06-18 04:22:16 | Ternopil Oblast, Ukraine | ||
2021-06-15 | Russia | Khanty-Mansi Autonomous Okrug | 58436 | 801 | 56846 | 789 | 61.0259025 | 69.0982628 | 2021-06-16 04:22:32 | Khanty-Mansi Autonomous Okrug, Russia | ||
2021-06-12 | Russia | Smolensk Oblast | 32043 | 1060 | 30194 | 789 | 55.03434960000001 | 33.0192065 | 2021-06-13 04:22:44 | Smolensk Oblast, Russia | ||
2021-06-01 | Russia | Yamalo-Nenets Autonomous Okrug | 39122 | 419 | 37914 | 789 | 67.1471631 | 74.3415488 | 2021-06-02 04:24:34 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2021-06-01 | Russia | Astrakhan Oblast | 34315 | 781 | 32745 | 789 | 47.1878186 | 47.608851 | 2021-06-02 04:24:34 | Astrakhan Oblast, Russia | ||
2021-05-22 | Syria | 24052 | 1729 | 21534 | 789 | 34.802075 | 38.99681500000001 | 2021-05-23 04:20:51 | Syria | |||
2021-05-21 | Colombia | Casanare | 18333 | 429 | 17115 | 789 | 5.7589 | -71.5724 | 2021-05-22 04:20:45 | Casanare, Colombia | ||
2021-05-20 | Russia | Smolensk Oblast | 30413 | 968 | 28656 | 789 | 55.03434960000001 | 33.0192065 | 2021-05-21 04:20:43 | Smolensk Oblast, Russia | ||
2021-05-07 | Russia | Irkutsk Oblast | 67087 | 2296 | 64002 | 789 | 56.6370122 | 104.719221 | 2021-05-08 04:21:04 | Irkutsk Oblast, Russia | ||
2021-05-06 | Malaysia | Perak | 15266 | 49 | 14428 | 789 | 4.5921 | 101.0901 | 2021-05-07 04:20:40 | Perak, Malaysia | ||
2021-05-06 | Chile | Atacama | 18722 | 206 | 17727 | 789 | -27.5661 | -70.0503 | 2021-05-07 04:20:40 | Atacama, Chile | ||
2021-04-15 | Japan | Fukuoka | 19857 | 343 | 18725 | 789 | 33.526032 | 130.666949 | 2021-04-16 04:20:46 | Fukuoka, Japan | ||
2021-03-24 | Russia | Chuvashia Republic | 22477 | 1172 | 20516 | 789 | 55.4259922 | 47.0849429 | 2021-03-25 05:27:00 | Chuvashia Republic, Russia | ||
2021-03-06 | US | Indiana | Martin | 18101 | 803 | 14 | 0 | 789 | 38.7099921 | -86.80373186 | 2021-03-07 05:21:54 | Martin, Indiana, US |
2021-03-05 | US | Indiana | Martin | 18101 | 803 | 14 | 0 | 789 | 38.7099921 | -86.80373186 | 2021-03-06 04:23:41 | Martin, Indiana, US |
2021-03-04 | US | Indiana | Martin | 18101 | 803 | 14 | 0 | 789 | 38.7099921 | -86.80373186 | 2021-03-05 05:26:29 | Martin, Indiana, US |
2021-03-03 | US | Georgia | Heard | 13149 | 806 | 17 | 0 | 789 | 33.29686567 | -85.12886832 | 2021-03-04 05:24:24 | Heard, Georgia, US |
2021-03-02 | US | Texas | San Saba | 48411 | 796 | 19 | 0 | 789 | 31.1577796 | -98.81758731 | 2021-03-03 05:23:28 | San Saba, Texas, US |
2021-02-28 | US | Idaho | Valley | 16085 | 794 | 5 | 0 | 789 | 44.76728382 | -115.5676773 | 2021-03-01 05:23:01 | Valley, Idaho, US |
2021-02-27 | US | Kentucky | Hancock | 21091 | 803 | 14 | 0 | 789 | 37.83766422 | -86.78280584 | 2021-02-28 05:22:20 | Hancock, Kentucky, US |
2021-02-27 | US | Idaho | Valley | 16085 | 794 | 5 | 0 | 789 | 44.76728382 | -115.5676773 | 2021-02-28 05:22:20 | Valley, Idaho, US |
2021-02-26 | US | Kentucky | Hancock | 21091 | 803 | 14 | 0 | 789 | 37.83766422 | -86.78280584 | 2021-02-27 05:22:28 | Hancock, Kentucky, US |
2021-02-25 | US | Oklahoma | Latimer | 40077 | 798 | 9 | 0 | 789 | 34.87844729 | -95.25215049 | 2021-02-26 05:22:40 | Latimer, Oklahoma, US |
2021-02-25 | US | Kansas | Anderson | 20003 | 807 | 18 | 0 | 789 | 38.21413251 | -95.29272815 | 2021-02-26 05:22:40 | Anderson, Kansas, US |
2021-02-24 | US | Kansas | Anderson | 20003 | 807 | 18 | 0 | 789 | 38.21413251 | -95.29272815 | 2021-02-25 05:24:57 | Anderson, Kansas, US |
2021-02-23 | US | Nebraska | Thurston | 31173 | 799 | 10 | 0 | 789 | 42.15725356 | -96.54157099 | 2021-02-24 05:29:16 | Thurston, Nebraska, US |
2021-02-23 | US | Kentucky | Edmonson | 21061 | 807 | 18 | 0 | 789 | 37.21218923 | -86.23955613 | 2021-02-24 05:29:16 | Edmonson, Kentucky, US |
2021-02-19 | Barbados | 2677 | 30 | 1858 | 789 | 13.1939 | -59.5432 | 2021-02-20 05:22:51 | Barbados | |||
2021-02-18 | US | Puerto Rico | Loiza | 72087 | 789 | 0 | 0 | 789 | 18.425688 | -65.89943000000001 | 2021-02-19 05:24:16 | Loiza, Puerto Rico, US |
2021-02-18 | US | Nebraska | Thurston | 31173 | 799 | 10 | 0 | 789 | 42.15725356 | -96.54157099 | 2021-02-19 05:24:16 | Thurston, Nebraska, US |
2021-02-18 | Chile | Coquimbo | 19329 | 379 | 18161 | 789 | -29.959 | -71.3389 | 2021-02-19 05:24:16 | Coquimbo, Chile | ||
2021-02-17 | US | Texas | Morris | 48343 | 958 | 23 | 0 | 789 | 33.11304005 | -94.73255695 | 2021-02-18 05:22:58 | Morris, Texas, US |
2021-02-14 | US | Puerto Rico | Juana Diaz | 72075 | 789 | 0 | 0 | 789 | 18.050764 | -66.49458100000001 | 2021-02-15 05:24:49 | Juana Diaz, Puerto Rico, US |
2021-02-14 | US | Montana | Valley | 30105 | 799 | 10 | 0 | 789 | 48.36435097 | -106.6669635 | 2021-02-15 05:24:49 | Valley, Montana, US |
2021-02-14 | Togo | 5874 | 81 | 5004 | 789 | 8.6195 | 0.8248 | 2021-02-15 05:24:49 | Togo | |||
2021-02-13 | US | Puerto Rico | Fajardo | 72053 | 789 | 0 | 0 | 789 | 18.318373 | -65.666866 | 2021-02-14 05:23:43 | Fajardo, Puerto Rico, US |
2021-02-11 | US | Virginia | King William | 51101 | 795 | 6 | 0 | 789 | 37.70965316 | -77.09384941 | 2021-02-12 05:23:29 | King William, Virginia, US |
2021-02-10 | US | Illinois | Marshall | 17123 | 803 | 14 | 0 | 789 | 41.0327901 | -89.34510444 | 2021-02-11 05:23:55 | Marshall, Illinois, US |
2021-02-08 | US | Texas | La Salle | 48283 | 978 | 21 | 0 | 789 | 28.34453111 | -99.09908775 | 2021-02-09 05:23:30 | La Salle, Texas, US |
2021-02-07 | US | Texas | La Salle | 48283 | 978 | 21 | 0 | 789 | 28.34453111 | -99.09908775 | 2021-02-08 05:22:39 | La Salle, Texas, US |
2021-02-07 | US | Puerto Rico | Barranquitas | 72019 | 789 | 0 | 0 | 789 | 18.201592 | -66.30963 | 2021-02-08 05:22:39 | Barranquitas, Puerto Rico, US |
2021-02-06 | US | Texas | La Salle | 48283 | 978 | 21 | 0 | 789 | 28.34453111 | -99.09908775 | 2021-02-07 05:23:00 | La Salle, Texas, US |
2021-02-06 | US | Puerto Rico | Aguas Buenas | 72007 | 789 | 0 | 0 | 789 | 18.251619 | -66.126806 | 2021-02-07 05:23:00 | Aguas Buenas, Puerto Rico, US |
2021-02-05 | US | Texas | La Salle | 48283 | 978 | 21 | 0 | 789 | 28.34453111 | -99.09908775 | 2021-02-06 05:23:55 | La Salle, Texas, US |
2021-02-01 | US | Wisconsin | Pepin | 55091 | 796 | 7 | 0 | 789 | 44.58307413 | -91.99949611 | 2021-02-02 05:22:49 | Pepin, Wisconsin, US |
2021-02-01 | US | Missouri | Harrison | 29081 | 801 | 12 | 0 | 789 | 40.35570088 | -93.99222144 | 2021-02-02 05:22:49 | Harrison, Missouri, US |
2021-02-01 | US | Georgia | Wilkinson | 13319 | 810 | 21 | 0 | 789 | 32.80291082 | -83.17140684 | 2021-02-02 05:22:49 | Wilkinson, Georgia, US |
2021-01-31 | US | Wisconsin | Pepin | 55091 | 796 | 7 | 0 | 789 | 44.58307413 | -91.99949611 | 2021-02-01 05:22:53 | Pepin, Wisconsin, US |
2021-01-31 | Japan | Shizuoka | 4590 | 76 | 3725 | 789 | 34.916975 | 138.40778400000002 | 2021-02-01 05:22:53 | Shizuoka, Japan | ||
2021-01-30 | US | Wisconsin | Pepin | 55091 | 796 | 7 | 0 | 789 | 44.58307413 | -91.99949611 | 2021-01-31 05:22:42 | Pepin, Wisconsin, US |
2021-01-30 | US | Kentucky | Metcalfe | 21169 | 802 | 13 | 0 | 789 | 36.99459295 | -85.63123699 | 2021-01-31 05:22:42 | Metcalfe, Kentucky, US |
2021-01-28 | US | Vermont | Rutland | 50021 | 798 | 9 | 0 | 789 | 43.57723578 | -73.03741676 | 2021-01-29 05:22:23 | Rutland, Vermont, US |
2021-01-28 | Japan | Tochigi | 3687 | 41 | 2857 | 789 | 36.689912 | 139.819213 | 2021-01-29 05:22:23 | Tochigi, Japan | ||
2021-01-27 | US | Pennsylvania | Potter | 42105 | 807 | 18 | 0 | 789 | 41.74471626 | -77.89559864 | 2021-01-28 05:22:24 | Potter, Pennsylvania, US |
2021-01-25 | US | Virginia | Greene | 51079 | 793 | 4 | 0 | 789 | 38.29545894 | -78.46525378 | 2021-01-26 05:22:02 | Greene, Virginia, US |
2021-01-25 | US | Puerto Rico | Camuy | 72027 | 789 | 0 | 0 | 789 | 18.418578 | -66.860206 | 2021-01-26 05:22:02 | Camuy, Puerto Rico, US |
2021-01-25 | US | Missouri | Gasconade | 29073 | 821 | 32 | 0 | 789 | 38.43947277 | -91.50847147 | 2021-01-26 05:22:02 | Gasconade, Missouri, US |
2021-01-24 | US | Mississippi | Kemper | 28069 | 809 | 20 | 0 | 789 | 32.75462946 | -88.64105766 | 2021-01-25 05:22:16 | Kemper, Mississippi, US |
2021-01-24 | US | Michigan | Leelanau | 26089 | 799 | 10 | 0 | 789 | 44.94430054 | -85.80150326 | 2021-01-25 05:22:16 | Leelanau, Michigan, US |
2021-01-24 | US | Georgia | Evans | 13109 | 805 | 16 | 0 | 789 | 32.15328841 | -81.8870105 | 2021-01-25 05:22:16 | Evans, Georgia, US |
2021-01-23 | US | Michigan | Leelanau | 26089 | 799 | 10 | 0 | 789 | 44.94430054 | -85.80150326 | 2021-01-24 05:22:35 | Leelanau, Michigan, US |
2021-01-23 | US | Kentucky | Magoffin | 21153 | 790 | 1 | 0 | 789 | 37.70820545 | -83.0657714 | 2021-01-24 05:22:35 | Magoffin, Kentucky, US |
2021-01-23 | US | Georgia | Clinch | 13065 | 805 | 16 | 0 | 789 | 30.91395822 | -82.70432472 | 2021-01-24 05:22:35 | Clinch, Georgia, US |
2021-01-22 | US | Kentucky | Martin | 21159 | 800 | 11 | 0 | 789 | 37.79990579 | -82.51247478 | 2021-01-23 05:22:03 | Martin, Kentucky, US |
2021-01-21 | United Kingdom | Gibraltar | 3881 | 59 | 3033 | 789 | 36.1408 | -5.3536 | 2021-01-22 05:22:10 | Gibraltar, United Kingdom | ||
2021-01-21 | US | Michigan | Antrim | 26009 | 806 | 17 | 0 | 789 | 44.99690221 | -85.15503082 | 2021-01-22 05:22:10 | Antrim, Michigan, US |
2021-01-12 | US | Oklahoma | Major | 40093 | 793 | 4 | 0 | 789 | 36.31149996 | -98.53467076 | 2021-01-13 05:22:15 | Major, Oklahoma, US |
2021-01-09 | US | Iowa | Montgomery | 19137 | 811 | 22 | 0 | 789 | 41.03018714 | -95.15642896 | 2021-01-10 05:22:12 | Montgomery, Iowa, US |
2021-01-08 | US | Texas | Leon | 48289 | 1172 | 26 | 0 | 789 | 31.29872538 | -95.9936328 | 2021-01-09 05:22:18 | Leon, Texas, US |
2021-01-08 | US | Indiana | Benton | 18007 | 800 | 11 | 0 | 789 | 40.60626947 | -87.31093999 | 2021-01-09 05:22:18 | Benton, Indiana, US |
2021-01-08 | US | Florida | Glades | 12043 | 800 | 11 | 0 | 789 | 26.95635849 | -81.18996211 | 2021-01-09 05:22:18 | Glades, Florida, US |
2021-01-07 | US | California | Del Norte | 6015 | 793 | 2 | 0 | 789 | 41.74228275 | -123.8974063 | 2021-01-08 05:22:42 | Del Norte, California, US |
2021-01-06 | US | Missouri | Barton | 29011 | 797 | 8 | 0 | 789 | 37.50207671 | -94.34757022 | 2021-01-07 05:22:03 | Barton, Missouri, US |
2021-01-06 | US | Florida | Liberty | 12077 | 803 | 14 | 0 | 789 | 30.23766008 | -84.8829258 | 2021-01-07 05:22:03 | Liberty, Florida, US |
2021-01-04 | US | West Virginia | Grant | 54023 | 807 | 18 | 0 | 789 | 39.10314817 | -79.19440518 | 2021-01-05 05:21:49 | Grant, West Virginia, US |
2021-01-04 | US | Montana | Powell | 30077 | 794 | 5 | 0 | 789 | 46.85538891 | -112.9359164 | 2021-01-05 05:21:49 | Powell, Montana, US |
2021-01-03 | US | Montana | Powell | 30077 | 794 | 5 | 0 | 789 | 46.85538891 | -112.9359164 | 2021-01-04 05:22:02 | Powell, Montana, US |
2021-01-02 | US | Virginia | Alleghany | 51005 | 811 | 22 | 0 | 789 | 37.78636074 | -80.00222498 | 2021-01-03 05:22:52 | Alleghany, Virginia, US |
2021-01-02 | US | Puerto Rico | Las Piedras | 72085 | 789 | 0 | 0 | 789 | 18.187527 | -65.86946800000001 | 2021-01-03 05:22:52 | Las Piedras, Puerto Rico, US |
2021-01-02 | US | Montana | Powell | 30077 | 794 | 5 | 0 | 789 | 46.85538891 | -112.9359164 | 2021-01-03 05:22:52 | Powell, Montana, US |
2021-01-02 | US | Georgia | Telfair | 13271 | 828 | 39 | 0 | 789 | 31.92829517 | -82.93491155 | 2021-01-03 05:22:52 | Telfair, Georgia, US |
2020-12-29 | US | Texas | Live Oak | 48297 | 740 | 10 | 0 | 789 | 28.35101362 | -98.1246786 | 2020-12-30 05:22:34 | Live Oak, Texas, US |
2020-12-29 | US | South Dakota | Grant | 46051 | 817 | 28 | 0 | 789 | 45.1723937 | -96.77002276 | 2020-12-30 05:22:34 | Grant, South Dakota, US |
2020-12-29 | US | North Carolina | Chowan | 37041 | 809 | 20 | 0 | 789 | 36.12908077 | -76.60118385 | 2020-12-30 05:22:34 | Chowan, North Carolina, US |
2020-12-29 | US | Iowa | Palo Alto | 19147 | 797 | 8 | 0 | 789 | 43.08193849 | -94.67824621 | 2020-12-30 05:22:34 | Palo Alto, Iowa, US |
2020-12-28 | US | Kentucky | Henry | 21103 | 793 | 4 | 0 | 789 | 38.44942688 | -85.11587507 | 2020-12-29 05:22:37 | Henry, Kentucky, US |
2020-12-27 | US | Kansas | Marshall | 20117 | 810 | 21 | 0 | 789 | 39.78359669 | -96.52278974 | 2020-12-28 05:22:06 | Marshall, Kansas, US |
2020-12-26 | US | Puerto Rico | Aguadilla | 72005 | 789 | 0 | 0 | 789 | 18.459681 | -67.12081500000001 | 2020-12-27 05:22:55 | Aguadilla, Puerto Rico, US |
2020-12-26 | US | Kansas | Marshall | 20117 | 810 | 21 | 0 | 789 | 39.78359669 | -96.52278974 | 2020-12-27 05:22:55 | Marshall, Kansas, US |
2020-12-25 | US | Kansas | Marshall | 20117 | 810 | 21 | 0 | 789 | 39.78359669 | -96.52278974 | 2020-12-26 05:22:28 | Marshall, Kansas, US |
2020-12-24 | US | Kansas | Marshall | 20117 | 810 | 21 | 0 | 789 | 39.78359669 | -96.52278974 | 2020-12-25 05:22:48 | Marshall, Kansas, US |
2020-12-23 | US | Kansas | Marshall | 20117 | 810 | 21 | 0 | 789 | 39.78359669 | -96.52278974 | 2020-12-24 05:23:04 | Marshall, Kansas, US |
2020-12-22 | US | Kansas | Marshall | 20117 | 810 | 21 | 0 | 789 | 39.78359669 | -96.52278974 | 2020-12-23 05:22:03 | Marshall, Kansas, US |
2020-12-19 | US | Indiana | Blackford | 18009 | 811 | 22 | 0 | 789 | 40.47388153 | -85.32499702 | 2020-12-20 05:27:32 | Blackford, Indiana, US |
2020-12-19 | US | Alabama | Conecuh | 1035 | 805 | 16 | 0 | 789 | 31.43401703 | -86.99320044 | 2020-12-20 05:27:32 | Conecuh, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;