johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
103 rows where confirmed = 6232 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1241530 | 1241530 | 2022-11-28 | US | Mississippi | Winston | 28159 | 6232 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-11-29 04:21:05 | Winston, Mississippi, US | |
481207 | 481207 | 2022-11-08 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-09 04:21:22 | Alpena, Michigan, US | |
2440357 | 2440357 | 2022-11-07 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-08 04:21:21 | Alpena, Michigan, US | |
1051455 | 1051455 | 2022-11-06 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-07 04:21:26 | Alpena, Michigan, US | |
619479 | 619479 | 2022-11-05 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-06 04:21:24 | Alpena, Michigan, US | |
1023983 | 1023983 | 2022-11-04 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-05 04:21:52 | Alpena, Michigan, US | |
432974 | 432974 | 2022-11-03 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-04 04:22:11 | Alpena, Michigan, US | |
851216 | 851216 | 2022-11-02 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-03 04:22:05 | Alpena, Michigan, US | |
712067 | 712067 | 2022-11-01 | US | Michigan | Alpena | 26007 | 6232 | 151 | 0 | 45.03477666 | -83.62212411 | 2022-11-02 04:22:09 | Alpena, Michigan, US | |
1368749 | 1368749 | 2022-10-28 | US | New York | Schoharie | 36095 | 6232 | 40 | 0 | 42.58831742 | -74.4433903 | 2022-10-29 04:21:13 | Schoharie, New York, US | |
1831018 | 1831018 | 2022-10-25 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-26 04:22:19 | Pierce, Georgia, US | |
795279 | 795279 | 2022-10-24 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-25 04:21:53 | Pierce, Georgia, US | |
3277734 | 3277734 | 2022-10-23 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-24 04:22:29 | Pierce, Georgia, US | |
2268772 | 2268772 | 2022-10-22 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-23 04:22:46 | Pierce, Georgia, US | |
1593072 | 1593072 | 2022-10-21 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-22 04:22:53 | Pierce, Georgia, US | |
2272788 | 2272788 | 2022-10-20 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-21 04:22:23 | Pierce, Georgia, US | |
199123 | 199123 | 2022-10-19 | US | Georgia | Pierce | 13229 | 6232 | 141 | 0 | 31.35928155 | -82.21598442 | 2022-10-20 04:22:59 | Pierce, Georgia, US | |
2027759 | 2027759 | 2022-10-17 | US | Tennessee | Unicoi | 47171 | 6232 | 101 | 0 | 36.10890856 | -82.43709629 | 2022-10-18 04:22:42 | Unicoi, Tennessee, US | |
3995994 | 3995994 | 2022-09-27 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-28 04:23:01 | Sumner, Kansas, US | |
2770322 | 2770322 | 2022-09-26 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-27 04:23:01 | Sumner, Kansas, US | |
1977975 | 1977975 | 2022-09-25 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-26 04:20:52 | Sumner, Kansas, US | |
2651142 | 2651142 | 2022-09-24 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-25 04:23:31 | Sumner, Kansas, US | |
385582 | 385582 | 2022-09-23 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-24 04:21:40 | Sumner, Kansas, US | |
1625648 | 1625648 | 2022-09-22 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-23 04:23:13 | Sumner, Kansas, US | |
1371852 | 1371852 | 2022-09-21 | US | Kansas | Sumner | 20191 | 6232 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-09-22 04:22:56 | Sumner, Kansas, US | |
2017786 | 2017786 | 2022-09-20 | US | Illinois | Wayne | 17191 | 6232 | 89 | 0 | 38.42955355 | -88.42586459 | 2022-09-21 04:23:22 | Wayne, Illinois, US | |
255956 | 255956 | 2022-09-08 | US | Oregon | Wasco | 41065 | 6232 | 68 | 0 | 45.16292781 | -121.1670954 | 2022-09-09 04:21:11 | Wasco, Oregon, US | |
961112 | 961112 | 2022-07-19 | US | New Mexico | Taos | 35055 | 6232 | 96 | 0 | 36.58006022 | -105.6310198 | 2022-07-20 04:20:59 | Taos, New Mexico, US | |
2982359 | 2982359 | 2022-06-13 | US | Texas | Gray | 48179 | 6232 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-06-14 04:20:52 | Gray, Texas, US | |
3727774 | 3727774 | 2022-06-07 | US | Maine | Franklin | 23007 | 6232 | 62 | 0 | 44.97330019 | -70.44381045 | 2022-06-08 04:20:55 | Franklin, Maine, US | |
2049444 | 2049444 | 2022-05-25 | US | Maryland | Caroline | 24011 | 6232 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-05-26 04:20:50 | Caroline, Maryland, US | |
623455 | 623455 | 2022-05-22 | US | Maryland | Caroline | 24011 | 6232 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-05-26 04:20:50 | Caroline, Maryland, US | |
3722842 | 3722842 | 2022-04-25 | US | Colorado | Montezuma | 8083 | 6232 | 82 | 0 | 37.33859579 | -108.59588570000001 | 2022-04-26 04:20:51 | Montezuma, Colorado, US | |
1513368 | 1513368 | 2022-02-24 | US | Missouri | Saline | 29195 | 6232 | 98 | 0 | 39.13734288 | -93.20259964 | 2022-02-25 04:21:11 | Saline, Missouri, US | |
2327912 | 2327912 | 2022-02-04 | US | California | Glenn | 6021 | 6232 | 39 | 0 | 39.59875897 | -122.3938452 | 2022-02-05 04:21:05 | Glenn, California, US | |
3303277 | 3303277 | 2022-01-30 | US | Texas | DeWitt | 48123 | 6232 | 86 | 0 | 29.08101855 | -97.35681170000001 | 2022-01-31 04:21:09 | DeWitt, Texas, US | |
1781185 | 1781185 | 2022-01-27 | US | Mississippi | Copiah | 28029 | 6232 | 97 | 0 | 31.86977774 | -90.44565118 | 2022-01-28 04:21:09 | Copiah, Mississippi, US | |
1320068 | 1320068 | 2022-01-26 | US | Mississippi | Tippah | 28139 | 6232 | 90 | 0 | 34.76872156 | -88.90988194 | 2022-01-27 04:21:19 | Tippah, Mississippi, US | |
2054495 | 2054495 | 2022-01-25 | US | Oregon | Columbia | 41009 | 6232 | 67 | 0 | 45.94464254 | -123.08908980000001 | 2022-01-26 04:21:07 | Columbia, Oregon, US | |
799921 | 799921 | 2021-12-22 | US | Louisiana | Beauregard | 22011 | 6232 | 129 | 0 | 30.64836518 | -93.34173616 | 2021-12-23 04:21:21 | Beauregard, Louisiana, US | |
1255545 | 1255545 | 2021-12-20 | US | Georgia | Chattahoochee | 13053 | 6232 | 21 | 0 | 32.34341231 | -84.78809239 | 2021-12-21 03:21:27 | Chattahoochee, Georgia, US | |
407235 | 407235 | 2021-12-07 | US | Tennessee | Giles | 47055 | 6232 | 129 | 0 | 35.20222469 | -87.03992678 | 2021-12-08 04:22:46 | Giles, Tennessee, US | |
1033458 | 1033458 | 2021-12-06 | US | Texas | Erath | 48143 | 6232 | 108 | 0 | 32.23602653 | -98.21773417 | 2021-12-07 04:22:34 | Erath, Texas, US | |
449228 | 449228 | 2021-11-17 | US | Mississippi | Union | 28145 | 6232 | 96 | 0 | 34.49162015 | -89.00776006 | 2021-11-18 04:21:33 | Union, Mississippi, US | |
88075 | 88075 | 2021-11-09 | US | Idaho | Nez Perce | 16069 | 6232 | 99 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-10 04:21:38 | Nez Perce, Idaho, US | |
3514945 | 3514945 | 2021-11-01 | US | Wisconsin | Douglas | 55031 | 6232 | 66 | 0 | 46.43222285 | -91.91595768 | 2021-11-02 04:22:03 | Douglas, Wisconsin, US | |
289776 | 289776 | 2021-10-31 | US | Minnesota | Winona | 27169 | 6232 | 55 | 0 | 43.98772283 | -91.78081305 | 2021-11-01 04:22:01 | Winona, Minnesota, US | |
2722782 | 2722782 | 2021-10-30 | US | Minnesota | Winona | 27169 | 6232 | 55 | 0 | 43.98772283 | -91.78081305 | 2021-10-31 04:22:08 | Winona, Minnesota, US | |
568884 | 568884 | 2021-10-29 | US | Minnesota | Winona | 27169 | 6232 | 55 | 0 | 43.98772283 | -91.78081305 | 2021-10-30 04:22:03 | Winona, Minnesota, US | |
2126994 | 2126994 | 2021-10-21 | US | Texas | Wharton | 48481 | 6232 | 177 | 0 | 29.27765923 | -96.22319248 | 2021-10-22 04:21:14 | Wharton, Texas, US | |
2943848 | 2943848 | 2021-10-15 | US | Arkansas | Independence | 5063 | 6232 | 156 | 0 | 35.74242707 | -91.57001641 | 2021-10-16 04:21:15 | Independence, Arkansas, US | |
468945 | 468945 | 2021-10-07 | US | Louisiana | St. John the Baptist | 22095 | 6232 | 163 | 0 | 30.12597499 | -90.4753503 | 2021-10-08 04:21:25 | St. John the Baptist, Louisiana, US | |
2776220 | 2776220 | 2021-09-30 | US | Texas | Uvalde | 48463 | 6232 | 91 | 0 | 29.35739637 | -99.76229172 | 2021-10-01 04:21:35 | Uvalde, Texas, US | |
3758990 | 3758990 | 2021-09-21 | US | Louisiana | Natchitoches | 22069 | 6232 | 123 | 0 | 31.72321584 | -93.09816516 | 2021-09-22 04:21:45 | Natchitoches, Louisiana, US | |
1816394 | 1816394 | 2021-09-19 | US | Michigan | Cass | 26027 | 6232 | 83 | 0 | 41.91522292 | -85.99405727 | 2021-09-20 04:21:22 | Cass, Michigan, US | |
17974 | 17974 | 2021-09-18 | US | Michigan | Cass | 26027 | 6232 | 83 | 0 | 41.91522292 | -85.99405727 | 2021-09-19 04:21:34 | Cass, Michigan, US | |
2619659 | 2619659 | 2021-09-17 | US | Michigan | Cass | 26027 | 6232 | 83 | 0 | 41.91522292 | -85.99405727 | 2021-09-18 04:21:24 | Cass, Michigan, US | |
3282782 | 3282782 | 2021-09-05 | US | Missouri | Johnson | 29101 | 6232 | 64 | 0 | 38.74719601 | -93.80691168 | 2021-09-06 04:21:22 | Johnson, Missouri, US | |
1857647 | 1857647 | 2021-08-20 | United Kingdom | Isle of Man | 6232 | 37 | 0 | 54.2361 | -4.5481 | 2021-08-21 04:21:38 | Isle of Man, United Kingdom | |||
105676 | 105676 | 2021-08-15 | US | North Carolina | Pender | 37141 | 6232 | 72 | 0 | 34.52265624 | -77.90352133 | 2021-08-16 04:21:31 | Pender, North Carolina, US | |
510034 | 510034 | 2021-08-14 | US | North Carolina | Pender | 37141 | 6232 | 72 | 0 | 34.52265624 | -77.90352133 | 2021-08-15 04:21:41 | Pender, North Carolina, US | |
1485906 | 1485906 | 2021-08-13 | US | North Carolina | Pender | 37141 | 6232 | 72 | 0 | 34.52265624 | -77.90352133 | 2021-08-14 04:21:25 | Pender, North Carolina, US | |
2902986 | 2902986 | 2021-08-12 | US | Virginia | Augusta | 51015 | 6232 | 81 | 0 | 38.16404586 | -79.12461614 | 2021-08-13 04:21:24 | Augusta, Virginia, US | |
3685627 | 3685627 | 2021-08-02 | US | New Jersey | Salem | 34033 | 6232 | 189 | 0 | 39.58719656 | -75.34696629999998 | 2021-08-03 04:21:39 | Salem, New Jersey, US | |
3387831 | 3387831 | 2021-07-29 | US | Ohio | Belmont | 39013 | 6232 | 180 | 0 | 40.01625942 | -80.9924051 | 2021-07-30 04:21:34 | Belmont, Ohio, US | |
299494 | 299494 | 2021-07-15 | US | West Virginia | Harrison | 54033 | 6232 | 82 | 0 | 39.2853852 | -80.37919577 | 2021-07-16 04:21:22 | Harrison, West Virginia, US | |
3742785 | 3742785 | 2021-07-12 | US | Minnesota | Chisago | 27025 | 6232 | 52 | 0 | 45.5021011 | -92.90861945 | 2021-07-13 04:21:18 | Chisago, Minnesota, US | |
3662400 | 3662400 | 2021-07-11 | US | South Carolina | Cherokee | 45021 | 6232 | 158 | 0 | 35.05122251 | -81.61828622 | 2021-07-12 04:21:34 | Cherokee, South Carolina, US | |
3660673 | 3660673 | 2021-07-11 | US | Indiana | Dubois | 18037 | 6232 | 118 | 0 | 38.36597551 | -86.87924170000002 | 2021-07-12 04:21:34 | Dubois, Indiana, US | |
628684 | 628684 | 2021-07-10 | US | South Carolina | Cherokee | 45021 | 6232 | 158 | 0 | 35.05122251 | -81.61828622 | 2021-07-11 04:21:43 | Cherokee, South Carolina, US | |
626957 | 626957 | 2021-07-10 | US | Indiana | Dubois | 18037 | 6232 | 118 | 0 | 38.36597551 | -86.87924170000002 | 2021-07-11 04:21:43 | Dubois, Indiana, US | |
832403 | 832403 | 2021-07-09 | US | South Carolina | Cherokee | 45021 | 6232 | 158 | 0 | 35.05122251 | -81.61828622 | 2021-07-10 04:21:25 | Cherokee, South Carolina, US | |
830676 | 830676 | 2021-07-09 | US | Indiana | Dubois | 18037 | 6232 | 118 | 0 | 38.36597551 | -86.87924170000002 | 2021-07-10 04:21:25 | Dubois, Indiana, US | |
779440 | 779440 | 2021-07-08 | US | Indiana | Dubois | 18037 | 6232 | 118 | 0 | 38.36597551 | -86.87924170000002 | 2021-07-09 04:21:21 | Dubois, Indiana, US | |
3472887 | 3472887 | 2021-06-08 | US | California | Yuba | 6115 | 6232 | 50 | 0 | 39.26255932 | -121.3535644 | 2021-06-09 04:23:31 | Yuba, California, US | |
23088 | 23088 | 2021-05-28 | US | Puerto Rico | Caguas | 72025 | 6232 | 0 | 0 | 18.211615 | -66.050779 | 2021-05-29 04:20:41 | Caguas, Puerto Rico, US | |
2940895 | 2940895 | 2021-05-16 | US | Maryland | Cecil | 24015 | 6232 | 136 | 0 | 39.56647682 | -75.94627411 | 2021-05-17 04:20:34 | Cecil, Maryland, US | |
391568 | 391568 | 2021-04-04 | US | Virginia | Harrisonburg | 51660 | 6232 | 95 | 0 | 38.43542574 | -78.87536254 | 2021-04-05 04:20:35 | Harrisonburg, Virginia, US | |
244780 | 244780 | 2021-04-02 | US | Wisconsin | Calumet | 55015 | 6232 | 50 | 0 | 44.0816316 | -88.21780273 | 2021-04-03 04:20:44 | Calumet, Wisconsin, US | |
243074 | 243074 | 2021-04-02 | US | Mississippi | Lowndes | 28087 | 6232 | 144 | 0 | 33.47386518 | -88.44191529999998 | 2021-04-03 04:20:44 | Lowndes, Mississippi, US | |
1800115 | 1800115 | 2021-03-23 | US | Louisiana | Acadia | 22001 | 6232 | 188 | 0 | 30.2950649 | -92.41419698 | 2021-03-24 05:25:40 | Acadia, Louisiana, US | |
3068717 | 3068717 | 2021-02-27 | US | Puerto Rico | Carolina | 72031 | 6232 | 0 | 0 | 6232 | 18.374986 | -65.95683100000001 | 2021-02-28 05:22:20 | Carolina, Puerto Rico, US |
1679721 | 1679721 | 2021-02-01 | US | Texas | Wise | 48497 | 6232 | 98 | 0 | 6037 | 33.21570665 | -97.65460265 | 2021-02-02 05:22:49 | Wise, Texas, US |
1463009 | 1463009 | 2021-01-31 | US | Texas | Wise | 48497 | 6232 | 98 | 0 | 6037 | 33.21570665 | -97.65460265 | 2021-02-01 05:22:53 | Wise, Texas, US |
1462111 | 1462111 | 2021-01-31 | US | North Carolina | Rockingham | 37157 | 6232 | 43 | 0 | 6189 | 36.39593137 | -79.77504841 | 2021-02-01 05:22:53 | Rockingham, North Carolina, US |
2214917 | 2214917 | 2021-01-30 | US | Texas | Wise | 48497 | 6232 | 98 | 0 | 6037 | 33.21570665 | -97.65460265 | 2021-01-31 05:22:42 | Wise, Texas, US |
1898737 | 1898737 | 2021-01-29 | US | Maryland | Wicomico | 24045 | 6232 | 126 | 0 | 6106 | 38.37301947 | -75.62705831 | 2021-01-30 05:22:49 | Wicomico, Maryland, US |
2625768 | 2625768 | 2021-01-10 | France | Mayotte | 6232 | 56 | 2964 | 3212 | -12.8275 | 45.166244 | 2021-01-11 05:21:50 | Mayotte, France | ||
3899856 | 3899856 | 2021-01-09 | France | Mayotte | 6232 | 56 | 2964 | 3212 | -12.8275 | 45.166244 | 2021-01-10 05:22:12 | Mayotte, France | ||
3034982 | 3034982 | 2021-01-05 | US | Florida | Columbia | 12023 | 6232 | 119 | 0 | 6113 | 30.22509788 | -82.62160164 | 2021-01-06 05:22:16 | Columbia, Florida, US |
3778300 | 3778300 | 2020-12-27 | US | Alabama | St. Clair | 1115 | 6232 | 71 | 0 | 6161 | 33.71902176 | -86.31029372 | 2020-12-28 05:22:06 | St. Clair, Alabama, US |
927762 | 927762 | 2020-12-21 | Mali | 6232 | 225 | 3858 | 2149 | 17.570692 | -3.996166000000001 | 2020-12-22 05:22:33 | Mali | |||
3173304 | 3173304 | 2020-11-16 | China | Unknown | 6232 | 0 | 0 | 0 | 2020-11-17 05:25:54 | Unknown, China | ||||
3172291 | 3172291 | 2020-11-16 | US | Pennsylvania | Dauphin | 42043 | 6232 | 203 | 0 | 6029 | 40.41377078 | -76.77993242 | 2020-11-17 05:25:54 | Dauphin, Pennsylvania, US |
3412236 | 3412236 | 2020-11-01 | US | South Carolina | Berkeley | 45015 | 6232 | 95 | 0 | 6137 | 33.20222596 | -79.94654523 | 2020-11-02 05:25:04 | Berkeley, South Carolina, US |
2582181 | 2582181 | 2020-09-27 | Russia | Kalmykia Republic | 6232 | 71 | 3662 | 2499 | 46.2313018 | 45.3275745 | 2020-09-28 04:23:00 | Kalmykia Republic, Russia | ||
2871857 | 2871857 | 2020-09-13 | US | Texas | Lubbock | 48303 | 6232 | 108 | 0 | 9508 | 33.61008596 | -101.8204789 | 2020-09-14 04:26:00 | Lubbock, Texas, US |
1175079 | 1175079 | 2020-09-10 | US | Missouri | Jackson | 29095 | 6232 | 85 | 0 | 6147 | 39.01002188 | -94.34724536 | 2020-09-11 04:46:23 | Jackson, Missouri, US |
3162191 | 3162191 | 2020-09-06 | US | California | Sonoma | 6097 | 6232 | 85 | 0 | 6146 | 38.52746429 | -122.8862506 | 2020-09-07 04:28:30 | Sonoma, California, US |
2707844 | 2707844 | 2020-07-17 | US | California | Stanislaus | 6099 | 6232 | 94 | 0 | 6175 | 37.55862499 | -120.9970722 | 2020-07-18 04:34:45 | Stanislaus, California, 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]);