johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
175 rows where confirmed = 4549 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1077478 | 1077478 | 2022-12-28 | US | Wisconsin | Marquette | 55077 | 4549 | 67 | 0 | 43.81911946 | -89.40073763 | 2022-12-29 04:21:01 | Marquette, Wisconsin, US | |
1152556 | 1152556 | 2022-12-12 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-13 04:21:01 | Goshen, Wyoming, US | |
872410 | 872410 | 2022-12-11 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-12 04:21:01 | Goshen, Wyoming, US | |
260940 | 260940 | 2022-12-10 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-11 04:20:50 | Goshen, Wyoming, US | |
3939654 | 3939654 | 2022-12-09 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-10 04:21:02 | Goshen, Wyoming, US | |
3380986 | 3380986 | 2022-12-08 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-09 04:21:05 | Goshen, Wyoming, US | |
1988257 | 1988257 | 2022-12-07 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-08 04:21:07 | Goshen, Wyoming, US | |
3717780 | 3717780 | 2022-12-06 | US | Wyoming | Goshen | 56015 | 4549 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-12-07 04:20:58 | Goshen, Wyoming, US | |
488143 | 488143 | 2022-11-25 | US | Arkansas | Polk | 5113 | 4549 | 158 | 0 | 34.48254879 | -94.22728802 | 2022-11-26 04:21:11 | Polk, Arkansas, US | |
3523972 | 3523972 | 2022-11-24 | US | Arkansas | Polk | 5113 | 4549 | 158 | 0 | 34.48254879 | -94.22728802 | 2022-11-25 04:21:06 | Polk, Arkansas, US | |
3312755 | 3312755 | 2022-11-23 | US | Arkansas | Polk | 5113 | 4549 | 158 | 0 | 34.48254879 | -94.22728802 | 2022-11-24 04:21:09 | Polk, Arkansas, US | |
1831345 | 1831345 | 2022-10-25 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-26 04:22:19 | Dickinson, Iowa, US | |
795606 | 795606 | 2022-10-24 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-25 04:21:53 | Dickinson, Iowa, US | |
3278061 | 3278061 | 2022-10-23 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-24 04:22:29 | Dickinson, Iowa, US | |
2269099 | 2269099 | 2022-10-22 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-23 04:22:46 | Dickinson, Iowa, US | |
1593399 | 1593399 | 2022-10-21 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-22 04:22:53 | Dickinson, Iowa, US | |
2273115 | 2273115 | 2022-10-20 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-21 04:22:23 | Dickinson, Iowa, US | |
199450 | 199450 | 2022-10-19 | US | Iowa | Dickinson | 19059 | 4549 | 76 | 0 | 43.37787725 | -95.1510206 | 2022-10-20 04:22:59 | Dickinson, Iowa, US | |
2347006 | 2347006 | 2022-08-31 | US | Wisconsin | Richland | 55103 | 4549 | 52 | 0 | 43.3762778 | -90.43012729 | 2022-09-01 04:21:03 | Richland, Wisconsin, US | |
1683816 | 1683816 | 2022-08-29 | US | Virginia | Buckingham | 51029 | 4549 | 60 | 0 | 37.57242268 | -78.52518834 | 2022-08-30 04:21:03 | Buckingham, Virginia, US | |
3954026 | 3954026 | 2022-08-17 | US | Wisconsin | Burnett | 55013 | 4549 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-08-18 04:21:11 | Burnett, Wisconsin, US | |
2597185 | 2597185 | 2022-07-25 | US | Texas | Lamb | 48279 | 4549 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-07-26 04:20:58 | Lamb, Texas, US | |
2595709 | 2595709 | 2022-07-25 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-26 04:20:58 | Ogemaw, Michigan, US | |
897824 | 897824 | 2022-07-24 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-25 04:20:51 | Ogemaw, Michigan, US | |
92818 | 92818 | 2022-07-23 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-24 04:20:47 | Ogemaw, Michigan, US | |
901840 | 901840 | 2022-07-22 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-23 04:20:53 | Ogemaw, Michigan, US | |
671976 | 671976 | 2022-07-21 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-22 04:21:15 | Ogemaw, Michigan, US | |
1609939 | 1609939 | 2022-07-20 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-21 04:21:10 | Ogemaw, Michigan, US | |
962434 | 962434 | 2022-07-19 | US | Wisconsin | Crawford | 55023 | 4549 | 29 | 0 | 43.23870316 | -90.93073686 | 2022-07-20 04:20:59 | Crawford, Wisconsin, US | |
960572 | 960572 | 2022-07-19 | US | Michigan | Ogemaw | 26129 | 4549 | 109 | 0 | 44.33481032 | -84.12725175 | 2022-07-20 04:20:59 | Ogemaw, Michigan, US | |
1763972 | 1763972 | 2022-06-20 | US | Colorado | Otero | 8089 | 4549 | 130 | 0 | 37.9014485 | -103.7173385 | 2022-06-21 04:20:56 | Otero, Colorado, US | |
948032 | 948032 | 2022-06-14 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-15 04:20:54 | Crawford, Iowa, US | |
2980440 | 2980440 | 2022-06-13 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-14 04:20:52 | Crawford, Iowa, US | |
2980238 | 2980238 | 2022-06-13 | US | Illinois | De Witt | 17039 | 4549 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-06-14 04:20:52 | De Witt, Illinois, US | |
2236566 | 2236566 | 2022-06-12 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-13 04:21:14 | Crawford, Iowa, US | |
3142764 | 3142764 | 2022-06-11 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-12 04:20:53 | Crawford, Iowa, US | |
1947264 | 1947264 | 2022-06-10 | US | Puerto Rico | Naguabo | 72103 | 4549 | 0 | 0 | 18.230637 | -65.753897 | 2022-06-11 04:21:01 | Naguabo, Puerto Rico, US | |
1945680 | 1945680 | 2022-06-10 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-11 04:21:01 | Crawford, Iowa, US | |
3158819 | 3158819 | 2022-06-09 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-10 04:20:55 | Crawford, Iowa, US | |
1422286 | 1422286 | 2022-06-08 | US | Iowa | Crawford | 19047 | 4549 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-06-09 04:20:54 | Crawford, Iowa, US | |
3726651 | 3726651 | 2022-06-07 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-08 04:20:55 | North Slope, Alaska, US | |
3888053 | 3888053 | 2022-06-06 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-07 04:21:08 | North Slope, Alaska, US | |
3507822 | 3507822 | 2022-06-05 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-06 04:20:57 | North Slope, Alaska, US | |
3527899 | 3527899 | 2022-06-04 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-05 04:20:55 | North Slope, Alaska, US | |
3133985 | 3133985 | 2022-06-03 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-04 04:20:58 | North Slope, Alaska, US | |
3579060 | 3579060 | 2022-06-02 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-03 04:20:58 | North Slope, Alaska, US | |
971353 | 971353 | 2022-06-01 | US | Alaska | North Slope | 2185 | 4549 | 13 | 0 | 69.31479216 | -153.4836093 | 2022-06-02 05:20:39 | North Slope, Alaska, US | |
3186536 | 3186536 | 2022-05-30 | US | California | Colusa | 6011 | 4549 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-31 04:20:51 | Colusa, California, US | |
1850980 | 1850980 | 2022-05-26 | US | Illinois | Ford | 17053 | 4549 | 67 | 0 | 40.59706922 | -88.22350769 | 2022-05-27 04:20:56 | Ford, Illinois, US | |
3596236 | 3596236 | 2022-05-23 | US | Texas | Robertson | 48395 | 4549 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-05-24 04:20:57 | Robertson, Texas, US | |
1185751 | 1185751 | 2022-05-18 | US | Illinois | Johnson | 17087 | 4549 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-05-19 04:20:54 | Johnson, Illinois, US | |
1506517 | 1506517 | 2022-05-16 | US | Tennessee | Benton | 47005 | 4549 | 93 | 0 | 36.07110411 | -88.06849355 | 2022-05-17 04:20:59 | Benton, Tennessee, US | |
1159944 | 1159944 | 2022-04-29 | US | Puerto Rico | Yabucoa | 72151 | 4549 | 0 | 0 | 18.070399 | -65.896289 | 2022-04-30 04:21:05 | Yabucoa, Puerto Rico, US | |
1848106 | 1848106 | 2022-04-18 | US | Nebraska | Washington | 31177 | 4549 | 43 | 0 | 41.52815707 | -96.22019892 | 2022-04-19 04:21:00 | Washington, Nebraska, US | |
2801328 | 2801328 | 2022-04-06 | US | California | Inyo | 6027 | 4549 | 56 | 0 | 36.51112084 | -117.41119779999998 | 2022-04-07 04:20:53 | Inyo, California, US | |
1439721 | 1439721 | 2022-03-28 | US | Texas | Jones | 48253 | 4549 | 92 | 0 | 32.73997145 | -99.87861576 | 2022-03-29 04:20:46 | Jones, Texas, US | |
26531 | 26531 | 2022-03-20 | US | Nebraska | Washington | 31177 | 4549 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-03-21 04:20:50 | Washington, Nebraska, US | |
1658541 | 1658541 | 2022-03-19 | US | Nebraska | Washington | 31177 | 4549 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-03-20 04:20:45 | Washington, Nebraska, US | |
338067 | 338067 | 2022-03-18 | US | Nebraska | Washington | 31177 | 4549 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-03-19 04:20:47 | Washington, Nebraska, US | |
1645987 | 1645987 | 2022-03-03 | US | Michigan | Cheboygan | 26031 | 4549 | 100 | 0 | 45.44787015 | -84.50122149 | 2022-03-04 04:21:09 | Cheboygan, Michigan, US | |
2526990 | 2526990 | 2022-03-02 | US | Michigan | Cheboygan | 26031 | 4549 | 100 | 0 | 45.44787015 | -84.50122149 | 2022-03-03 04:21:01 | Cheboygan, Michigan, US | |
2736404 | 2736404 | 2022-02-27 | US | Virginia | New Kent | 51127 | 4549 | 31 | 0 | 37.50694406 | -76.99828634 | 2022-02-28 04:21:05 | New Kent, Virginia, US | |
3049557 | 3049557 | 2022-02-26 | US | Virginia | New Kent | 51127 | 4549 | 31 | 0 | 37.50694406 | -76.99828634 | 2022-02-27 04:21:04 | New Kent, Virginia, US | |
3048902 | 3048902 | 2022-02-26 | US | Puerto Rico | Cabo Rojo | 72023 | 4549 | 0 | 0 | 18.040993 | -67.154391 | 2022-02-27 04:21:04 | Cabo Rojo, Puerto Rico, US | |
578212 | 578212 | 2022-02-25 | US | Virginia | New Kent | 51127 | 4549 | 31 | 0 | 37.50694406 | -76.99828634 | 2022-02-26 04:21:12 | New Kent, Virginia, US | |
1301523 | 1301523 | 2022-02-17 | US | West Virginia | Barbour | 54001 | 4549 | 68 | 0 | 39.1307219 | -80.00350858 | 2022-02-18 04:21:04 | Barbour, West Virginia, US | |
3821902 | 3821902 | 2022-02-16 | US | Kentucky | Powell | 21197 | 4549 | 33 | 0 | 37.83218794 | -83.82553961 | 2022-02-17 04:20:56 | Powell, Kentucky, US | |
3672025 | 3672025 | 2022-02-15 | US | Alabama | Fayette | 1057 | 4549 | 89 | 0 | 33.72076938 | -87.73886638 | 2022-02-16 04:21:10 | Fayette, Alabama, US | |
319122 | 319122 | 2022-02-12 | US | Texas | Reeves | 48389 | 4549 | 70 | 0 | 31.32323325 | -103.69038959999999 | 2022-02-13 04:21:00 | Reeves, Texas, US | |
1467264 | 1467264 | 2022-02-10 | US | Texas | Montague | 48337 | 4549 | 116 | 0 | 33.67521893 | -97.72500958 | 2022-02-11 04:21:09 | Montague, Texas, US | |
1464992 | 1464992 | 2022-02-10 | US | Georgia | Worth | 13321 | 4549 | 104 | 0 | 31.55162306 | -83.85090513 | 2022-02-11 04:21:09 | Worth, Georgia, US | |
3227825 | 3227825 | 2022-01-19 | US | Kentucky | Bourbon | 21017 | 4549 | 45 | 0 | 38.2054607 | -84.21827874 | 2022-01-20 04:21:07 | Bourbon, Kentucky, US | |
3467541 | 3467541 | 2022-01-18 | US | Virginia | Lee | 51105 | 4549 | 71 | 0 | 36.70586667 | -83.12606515 | 2022-01-19 04:21:23 | Lee, Virginia, US | |
3616548 | 3616548 | 2022-01-12 | US | West Virginia | Hampshire | 54027 | 4549 | 60 | 0 | 39.32103553 | -78.60826476 | 2022-01-13 08:00:09 | Hampshire, West Virginia, US | |
3521065 | 3521065 | 2022-01-02 | US | Michigan | Emmet | 26047 | 4549 | 60 | 0 | 45.52625509 | -84.89083249 | 2022-01-03 02:22:25 | Emmet, Michigan, US | |
2170496 | 2170496 | 2022-01-01 | US | Tennessee | DeKalb | 47041 | 4549 | 85 | 0 | 35.97616272 | -85.83689361 | 2022-01-02 04:20:52 | DeKalb, Tennessee, US | |
2169195 | 2169195 | 2022-01-01 | US | Michigan | Emmet | 26047 | 4549 | 60 | 0 | 45.52625509 | -84.89083249 | 2022-01-02 04:20:52 | Emmet, Michigan, US | |
2778626 | 2778626 | 2021-12-31 | US | Michigan | Emmet | 26047 | 4549 | 60 | 0 | 45.52625509 | -84.89083249 | 2022-01-01 04:22:14 | Emmet, Michigan, US | |
4000283 | 4000283 | 2021-12-30 | US | Michigan | Emmet | 26047 | 4549 | 60 | 0 | 45.52625509 | -84.89083249 | 2021-12-31 04:21:50 | Emmet, Michigan, US | |
3998782 | 3998782 | 2021-12-30 | Netherlands | Unknown | 4549 | 32 | 0 | 2021-12-31 04:21:50 | Unknown, Netherlands | |||||
1670090 | 1670090 | 2021-12-29 | US | Michigan | Emmet | 26047 | 4549 | 60 | 0 | 45.52625509 | -84.89083249 | 2021-12-30 04:21:25 | Emmet, Michigan, US | |
552207 | 552207 | 2021-12-08 | US | Kentucky | Lincoln | 21137 | 4549 | 105 | 0 | 37.45475628 | -84.6565327 | 2021-12-09 04:22:49 | Lincoln, Kentucky, US | |
407575 | 407575 | 2021-12-07 | US | Vermont | Bennington | 50003 | 4549 | 37 | 0 | 43.03519828 | -73.09048868 | 2021-12-08 04:22:46 | Bennington, Vermont, US | |
1032417 | 1032417 | 2021-12-06 | US | Nebraska | Adams | 31001 | 4549 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2021-12-07 04:22:34 | Adams, Nebraska, US | |
1233501 | 1233501 | 2021-11-28 | US | Missouri | Barry | 29009 | 4549 | 65 | 0 | 36.70978521 | -93.82919888 | 2021-11-29 04:22:30 | Barry, Missouri, US | |
1232125 | 1232125 | 2021-11-28 | US | Arkansas | Jackson | 5067 | 4549 | 46 | 0 | 35.59802983 | -91.21494602 | 2021-11-29 04:22:30 | Jackson, Arkansas, US | |
1360208 | 1360208 | 2021-11-27 | US | Missouri | Barry | 29009 | 4549 | 65 | 0 | 36.70978521 | -93.82919888 | 2021-11-28 04:22:43 | Barry, Missouri, US | |
760199 | 760199 | 2021-11-26 | US | Missouri | Barry | 29009 | 4549 | 65 | 0 | 36.70978521 | -93.82919888 | 2021-11-27 04:22:45 | Barry, Missouri, US | |
1804616 | 1804616 | 2021-11-25 | US | Missouri | Barry | 29009 | 4549 | 65 | 0 | 36.70978521 | -93.82919888 | 2021-11-26 04:22:33 | Barry, Missouri, US | |
906050 | 906050 | 2021-11-24 | US | Missouri | Barry | 29009 | 4549 | 65 | 0 | 36.70978521 | -93.82919888 | 2021-11-25 04:22:33 | Barry, Missouri, US | |
1016341 | 1016341 | 2021-11-21 | US | Montana | Lake | 30047 | 4549 | 73 | 0 | 47.64514965 | -114.0898013 | 2021-11-22 04:22:20 | Lake, Montana, US | |
1016037 | 1016037 | 2021-11-21 | US | Minnesota | Brown | 27015 | 4549 | 57 | 0 | 44.24205652 | -94.72562874 | 2021-11-22 04:22:20 | Brown, Minnesota, US | |
724505 | 724505 | 2021-11-20 | US | Montana | Lake | 30047 | 4549 | 73 | 0 | 47.64514965 | -114.0898013 | 2021-11-21 04:22:13 | Lake, Montana, US | |
724201 | 724201 | 2021-11-20 | US | Minnesota | Brown | 27015 | 4549 | 57 | 0 | 44.24205652 | -94.72562874 | 2021-11-21 04:22:13 | Brown, Minnesota, US | |
164035 | 164035 | 2021-11-19 | US | Montana | Lake | 30047 | 4549 | 73 | 0 | 47.64514965 | -114.0898013 | 2021-11-20 04:22:17 | Lake, Montana, US | |
163731 | 163731 | 2021-11-19 | US | Minnesota | Brown | 27015 | 4549 | 57 | 0 | 44.24205652 | -94.72562874 | 2021-11-20 04:22:17 | Brown, Minnesota, US | |
3641306 | 3641306 | 2021-11-08 | US | Minnesota | Pine | 27115 | 4549 | 36 | 0 | 46.12105238 | -92.74070188 | 2021-11-09 04:21:36 | Pine, Minnesota, US | |
2002112 | 2002112 | 2021-11-07 | US | Kentucky | Montgomery | 21173 | 4549 | 59 | 0 | 38.03253032 | -83.9145241 | 2021-11-08 04:21:43 | Montgomery, Kentucky, US | |
497103 | 497103 | 2021-11-06 | US | Kentucky | Montgomery | 21173 | 4549 | 58 | 0 | 38.03253032 | -83.9145241 | 2021-11-07 04:21:53 | Montgomery, Kentucky, US | |
773847 | 773847 | 2021-10-23 | US | West Virginia | Mingo | 54059 | 4549 | 79 | 0 | 37.73048351 | -82.13338365 | 2021-10-24 04:21:22 | Mingo, West Virginia, 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]);