johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
103 rows where confirmed = 7532 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454806 | 454806 | 2022-12-21 | US | Virginia | Staunton | 51790 | 7532 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-22 04:20:56 | Staunton, Virginia, US | |
292961 | 292961 | 2022-11-15 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-16 04:21:09 | Latah, Idaho, US | |
3597991 | 3597991 | 2022-11-14 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-15 04:21:16 | Latah, Idaho, US | |
312849 | 312849 | 2022-11-13 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-14 04:21:09 | Latah, Idaho, US | |
64010 | 64010 | 2022-11-12 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-13 04:21:14 | Latah, Idaho, US | |
2928172 | 2928172 | 2022-11-11 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-12 04:20:41 | Latah, Idaho, US | |
2507008 | 2507008 | 2022-11-10 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-11 04:21:22 | Latah, Idaho, US | |
2431883 | 2431883 | 2022-11-09 | US | Idaho | Latah | 16057 | 7532 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-10 04:21:16 | Latah, Idaho, US | |
2162962 | 2162962 | 2022-10-16 | US | Virginia | Winchester | 51840 | 7532 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-17 04:20:31 | Winchester, Virginia, US | |
519159 | 519159 | 2022-10-15 | US | Virginia | Winchester | 51840 | 7532 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-16 04:22:39 | Winchester, Virginia, US | |
2036216 | 2036216 | 2022-10-14 | US | Virginia | Winchester | 51840 | 7532 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-15 04:22:00 | Winchester, Virginia, US | |
3376136 | 3376136 | 2022-09-17 | US | Puerto Rico | Quebradillas | 72115 | 7532 | 0 | 0 | 18.439692 | -66.926113 | 2022-09-18 04:22:50 | Quebradillas, Puerto Rico, US | |
2011415 | 2011415 | 2022-08-04 | US | Puerto Rico | Barranquitas | 72019 | 7532 | 0 | 0 | 18.201592 | -66.30963 | 2022-08-05 04:20:52 | Barranquitas, Puerto Rico, US | |
676748 | 676748 | 2022-07-30 | US | North Dakota | Stutsman | 38093 | 7532 | 97 | 0 | 46.97962541 | -98.95637318 | 2022-07-31 04:21:02 | Stutsman, North Dakota, US | |
1785947 | 1785947 | 2022-07-29 | US | North Dakota | Stutsman | 38093 | 7532 | 97 | 0 | 46.97962541 | -98.95637318 | 2022-07-30 04:20:42 | Stutsman, North Dakota, US | |
2597401 | 2597401 | 2022-07-25 | US | Virginia | Louisa | 51109 | 7532 | 85 | 0 | 37.97850256 | -77.96274807 | 2022-07-26 04:20:58 | Louisa, Virginia, US | |
897668 | 897668 | 2022-07-24 | US | Louisiana | Morehouse | 22067 | 7532 | 134 | 0 | 32.81686191 | -91.80421614 | 2022-07-25 04:20:51 | Morehouse, Louisiana, US | |
92662 | 92662 | 2022-07-23 | US | Louisiana | Morehouse | 22067 | 7532 | 134 | 0 | 32.81686191 | -91.80421614 | 2022-07-24 04:20:47 | Morehouse, Louisiana, US | |
901684 | 901684 | 2022-07-22 | US | Louisiana | Morehouse | 22067 | 7532 | 134 | 0 | 32.81686191 | -91.80421614 | 2022-07-23 04:20:53 | Morehouse, Louisiana, US | |
3001454 | 3001454 | 2022-05-24 | US | Nevada | Nye | 32023 | 7532 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-25 04:20:56 | Nye, Nevada, US | |
3595175 | 3595175 | 2022-05-23 | US | Nevada | Nye | 32023 | 7532 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-24 04:20:57 | Nye, Nevada, US | |
1111723 | 1111723 | 2022-05-21 | US | Nevada | Nye | 32023 | 7532 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-22 04:20:52 | Nye, Nevada, US | |
1171347 | 1171347 | 2022-05-20 | US | Nevada | Nye | 32023 | 7532 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-21 04:20:58 | Nye, Nevada, US | |
3898110 | 3898110 | 2022-05-19 | US | Nevada | Nye | 32023 | 7532 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-20 04:20:57 | Nye, Nevada, US | |
1186894 | 1186894 | 2022-05-18 | US | Nevada | Nye | 32023 | 7532 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-19 04:20:54 | Nye, Nevada, US | |
2334809 | 2334809 | 2022-05-08 | US | Virginia | Wythe | 51197 | 7532 | 149 | 0 | 36.91582035 | -81.07834059 | 2022-05-09 04:20:54 | Wythe, Virginia, US | |
363771 | 363771 | 2022-05-07 | US | Virginia | Wythe | 51197 | 7532 | 149 | 0 | 36.91582035 | -81.07834059 | 2022-05-08 04:20:49 | Wythe, Virginia, US | |
1401122 | 1401122 | 2022-05-06 | US | Virginia | Wythe | 51197 | 7532 | 149 | 0 | 36.91582035 | -81.07834059 | 2022-05-07 04:21:09 | Wythe, Virginia, US | |
2309188 | 2309188 | 2022-04-20 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-21 04:20:46 | Dunklin, Missouri, US | |
2253327 | 2253327 | 2022-04-19 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-20 04:20:45 | Dunklin, Missouri, US | |
1847877 | 1847877 | 2022-04-18 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-19 04:21:00 | Dunklin, Missouri, US | |
3418821 | 3418821 | 2022-04-17 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-18 04:21:12 | Dunklin, Missouri, US | |
305770 | 305770 | 2022-04-16 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-17 04:20:59 | Dunklin, Missouri, US | |
2671715 | 2671715 | 2022-04-15 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-16 04:20:48 | Dunklin, Missouri, US | |
1225500 | 1225500 | 2022-04-14 | US | Missouri | Dunklin | 29069 | 7532 | 117 | 0 | 36.27167174 | -90.09122243 | 2022-04-15 04:20:57 | Dunklin, Missouri, US | |
3868766 | 3868766 | 2022-04-05 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-04-06 04:20:49 | Marion, Iowa, US | |
2750108 | 2750108 | 2022-04-04 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-04-05 04:20:48 | Marion, Iowa, US | |
3731454 | 3731454 | 2022-04-03 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-04-04 04:20:51 | Marion, Iowa, US | |
500889 | 500889 | 2022-04-02 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-04-03 04:20:48 | Marion, Iowa, US | |
3351874 | 3351874 | 2022-04-01 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-04-02 04:20:47 | Marion, Iowa, US | |
1541179 | 1541179 | 2022-03-31 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-04-01 04:20:28 | Marion, Iowa, US | |
2479192 | 2479192 | 2022-03-30 | US | Iowa | Marion | 19125 | 7532 | 122 | 0 | 41.33445101 | -93.09934783 | 2022-03-31 04:20:56 | Marion, Iowa, US | |
2478608 | 2478608 | 2022-03-30 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-31 04:20:56 | Logan, Colorado, US | |
158649 | 158649 | 2022-03-29 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-30 04:20:45 | Logan, Colorado, US | |
1437220 | 1437220 | 2022-03-28 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-29 04:20:46 | Logan, Colorado, US | |
876901 | 876901 | 2022-03-27 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-28 04:20:33 | Logan, Colorado, US | |
2164184 | 2164184 | 2022-03-26 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-27 04:20:47 | Logan, Colorado, US | |
1721120 | 1721120 | 2022-03-25 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-26 04:20:23 | Logan, Colorado, US | |
1468737 | 1468737 | 2022-03-24 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-25 04:20:46 | Logan, Colorado, US | |
3022911 | 3022911 | 2022-03-23 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-24 04:20:43 | Logan, Colorado, US | |
1905833 | 1905833 | 2022-03-22 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-23 04:20:48 | Logan, Colorado, US | |
3240940 | 3240940 | 2022-03-21 | US | Oregon | Columbia | 41009 | 7532 | 78 | 0 | 45.94464254 | -123.08908980000001 | 2022-03-22 04:20:54 | Columbia, Oregon, US | |
3238964 | 3238964 | 2022-03-21 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-22 04:20:54 | Logan, Colorado, US | |
25037 | 25037 | 2022-03-20 | US | Colorado | Logan | 8075 | 7532 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-21 04:20:50 | Logan, Colorado, US | |
3046720 | 3046720 | 2022-02-26 | US | California | Calaveras | 6009 | 7532 | 110 | 0 | 38.20537103 | -120.55291299999999 | 2022-02-27 04:21:04 | Calaveras, California, US | |
575375 | 575375 | 2022-02-25 | US | California | Calaveras | 6009 | 7532 | 110 | 0 | 38.20537103 | -120.55291299999999 | 2022-02-26 04:21:12 | Calaveras, California, US | |
3823283 | 3823283 | 2022-02-16 | US | South Carolina | Union | 45087 | 7532 | 138 | 0 | 34.68835752 | -81.61730349 | 2022-02-17 04:20:56 | Union, South Carolina, US | |
3675188 | 3675188 | 2022-02-15 | US | Wisconsin | Clark | 55019 | 7532 | 116 | 0 | 44.73483377 | -90.61207486 | 2022-02-16 04:21:10 | Clark, Wisconsin, US | |
3075089 | 3075089 | 2022-02-09 | US | Illinois | Saline | 17165 | 7532 | 84 | 0 | 37.75332999 | -88.54119706 | 2022-02-10 04:21:14 | Saline, Illinois, US | |
980900 | 980900 | 2022-02-01 | US | Missouri | Polk | 29167 | 7532 | 84 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-02 04:21:09 | Polk, Missouri, US | |
2053090 | 2053090 | 2022-01-25 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-26 04:21:07 | Jasper, Iowa, US | |
1228821 | 1228821 | 2022-01-24 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-25 04:21:05 | Jasper, Iowa, US | |
1142120 | 1142120 | 2022-01-23 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-24 04:21:12 | Jasper, Iowa, US | |
2834038 | 2834038 | 2022-01-22 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-23 04:21:13 | Jasper, Iowa, US | |
3426156 | 3426156 | 2022-01-21 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-22 04:21:13 | Jasper, Iowa, US | |
1961764 | 1961764 | 2022-01-20 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-21 04:21:09 | Jasper, Iowa, US | |
3227659 | 3227659 | 2022-01-19 | US | Iowa | Jasper | 19099 | 7532 | 97 | 0 | 41.68576082 | -93.05567785 | 2022-01-20 04:21:07 | Jasper, Iowa, US | |
555163 | 555163 | 2022-01-16 | US | Alabama | Franklin | 1059 | 7532 | 116 | 0 | 34.44235334 | -87.84289505 | 2022-01-17 04:21:08 | Franklin, Alabama, US | |
1703329 | 1703329 | 2022-01-03 | US | Tennessee | Obion | 47131 | 7532 | 146 | 0 | 36.35732446 | -89.14921589 | 2022-01-04 04:22:17 | Obion, Tennessee, US | |
3521812 | 3521812 | 2022-01-02 | US | North Carolina | Watauga | 37189 | 7532 | 44 | 0 | 36.23103603 | -81.70033724 | 2022-01-03 02:22:25 | Watauga, North Carolina, US | |
2169942 | 2169942 | 2022-01-01 | US | North Carolina | Watauga | 37189 | 7532 | 44 | 0 | 36.23103603 | -81.70033724 | 2022-01-02 04:20:52 | Watauga, North Carolina, US | |
2779373 | 2779373 | 2021-12-31 | US | North Carolina | Watauga | 37189 | 7532 | 44 | 0 | 36.23103603 | -81.70033724 | 2022-01-01 04:22:14 | Watauga, North Carolina, US | |
4001030 | 4001030 | 2021-12-30 | US | North Carolina | Watauga | 37189 | 7532 | 44 | 0 | 36.23103603 | -81.70033724 | 2021-12-31 04:21:50 | Watauga, North Carolina, US | |
3830955 | 3830955 | 2021-12-21 | US | Ohio | Logan | 39091 | 7532 | 139 | 0 | 40.38996525 | -83.76784341 | 2021-12-22 04:21:54 | Logan, Ohio, US | |
2904271 | 2904271 | 2021-12-19 | US | California | Lassen | 6035 | 7532 | 54 | 0 | 40.67311306 | -120.59350990000002 | 2021-12-20 04:21:43 | Lassen, California, US | |
1233100 | 1233100 | 2021-11-28 | US | Kentucky | Shelby | 21211 | 7532 | 115 | 0 | 38.21476019 | -85.194223 | 2021-11-29 04:22:30 | Shelby, Kentucky, US | |
1324091 | 1324091 | 2021-11-14 | US | Mississippi | Washington | 28151 | 7532 | 167 | 0 | 33.28392041 | -90.94196237 | 2021-11-15 04:21:36 | Washington, Mississippi, US | |
688217 | 688217 | 2021-11-13 | US | Mississippi | Washington | 28151 | 7532 | 167 | 0 | 33.28392041 | -90.94196237 | 2021-11-14 04:21:31 | Washington, Mississippi, US | |
716326 | 716326 | 2021-11-12 | US | Mississippi | Washington | 28151 | 7532 | 167 | 0 | 33.28392041 | -90.94196237 | 2021-11-13 04:21:38 | Washington, Mississippi, US | |
498340 | 498340 | 2021-11-06 | US | Pennsylvania | Mifflin | 42087 | 7532 | 204 | 0 | 40.61116939 | -77.61070738 | 2021-11-07 04:21:53 | Mifflin, Pennsylvania, US | |
1275170 | 1275170 | 2021-10-03 | US | Georgia | Thomas | 13275 | 7532 | 167 | 0 | 30.86392347 | -83.91847289 | 2021-10-04 04:21:31 | Thomas, Georgia, US | |
3928923 | 3928923 | 2021-10-02 | US | Georgia | Thomas | 13275 | 7532 | 167 | 0 | 30.86392347 | -83.91847289 | 2021-10-03 04:21:24 | Thomas, Georgia, US | |
2132903 | 2132903 | 2021-10-01 | US | Georgia | Thomas | 13275 | 7532 | 167 | 0 | 30.86392347 | -83.91847289 | 2021-10-02 04:21:25 | Thomas, Georgia, US | |
1337803 | 1337803 | 2021-09-28 | US | Wisconsin | Barron | 55005 | 7532 | 86 | 0 | 45.42372701 | -91.84833627 | 2021-09-29 04:21:45 | Barron, Wisconsin, US | |
2077674 | 2077674 | 2021-09-26 | US | Minnesota | Kandiyohi | 27067 | 7532 | 92 | 0 | 45.1526059 | -95.00586446 | 2021-09-27 04:21:16 | Kandiyohi, Minnesota, US | |
1726226 | 1726226 | 2021-09-25 | US | Minnesota | Kandiyohi | 27067 | 7532 | 92 | 0 | 45.1526059 | -95.00586446 | 2021-09-26 04:21:29 | Kandiyohi, Minnesota, US | |
1922946 | 1922946 | 2021-09-24 | US | Minnesota | Kandiyohi | 27067 | 7532 | 92 | 0 | 45.1526059 | -95.00586446 | 2021-09-25 04:21:31 | Kandiyohi, Minnesota, US | |
1375572 | 1375572 | 2021-09-15 | US | Indiana | Dubois | 18037 | 7532 | 123 | 0 | 38.36597551 | -86.87924170000002 | 2021-09-16 04:22:19 | Dubois, Indiana, US | |
2901213 | 2901213 | 2021-08-12 | US | Louisiana | St. Charles | 22089 | 7532 | 103 | 0 | 29.90709658 | -90.35555967 | 2021-08-13 04:21:24 | St. Charles, Louisiana, US | |
3685701 | 3685701 | 2021-08-02 | US | New York | Ontario | 36069 | 7532 | 93 | 0 | 42.85145728 | -77.30874425 | 2021-08-03 04:21:39 | Ontario, New York, US | |
3388960 | 3388960 | 2021-07-29 | US | Wisconsin | Portage | 55097 | 7532 | 75 | 0 | 44.47558711 | -89.50152965 | 2021-07-30 04:21:34 | Portage, Wisconsin, US | |
2822356 | 2822356 | 2021-05-10 | US | Maryland | Wicomico | 24045 | 7532 | 153 | 0 | 38.37301947 | -75.62705831 | 2021-05-11 04:20:41 | Wicomico, Maryland, US | |
3964392 | 3964392 | 2021-03-10 | US | Missouri | Cape Girardeau | 29031 | 7532 | 131 | 0 | 37.38489388 | -89.6843587 | 2021-03-11 05:25:48 | Cape Girardeau, Missouri, US | |
3665480 | 3665480 | 2021-03-09 | US | Missouri | Cape Girardeau | 29031 | 7532 | 131 | 0 | 37.38489388 | -89.6843587 | 2021-03-10 05:24:35 | Cape Girardeau, Missouri, US | |
1679148 | 1679148 | 2021-02-01 | US | Pennsylvania | Mercer | 42085 | 7532 | 223 | 0 | 7309 | 41.30248872 | -80.25816981 | 2021-02-02 05:22:49 | Mercer, Pennsylvania, US |
190066 | 190066 | 2021-01-11 | Italy | Valle d'Aosta | 7532 | 391 | 6699 | 442 | 45.73750286 | 7.320149366 | 2021-01-12 05:22:15 | Valle d'Aosta, Italy | ||
1057450 | 1057450 | 2020-10-23 | Ukraine | Poltava Oblast | 7532 | 139 | 2455 | 4938 | 49.5883 | 34.5514 | 2020-10-24 04:24:46 | Poltava Oblast, Ukraine | ||
2662442 | 2662442 | 2020-09-04 | US | Florida | Brevard | 12009 | 7532 | 228 | 0 | 7304 | 28.29409504 | -80.73091022 | 2020-09-05 04:28:19 | Brevard, Florida, US |
3612595 | 3612595 | 2020-08-06 | Haiti | 7532 | 171 | 4832 | 2529 | 18.9712 | -72.2852 | 2020-08-07 04:35:11 | Haiti | |||
1925284 | 1925284 | 2020-07-30 | US | Texas | Cameron | 48061 | 7532 | 304 | 0 | 9120 | 26.14524221 | -97.48140372 | 2020-07-31 04:35:18 | Cameron, Texas, 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]);