johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
149 rows where confirmed = 6072 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454167 | 454167 | 2022-12-21 | US | Puerto Rico | Sabana Grande | 72121 | 6072 | 0 | 0 | 18.08282 | -66.943758 | 2022-12-22 04:20:56 | Sabana Grande, Puerto Rico, US | |
1985468 | 1985468 | 2022-12-07 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-08 04:21:07 | Haralson, Georgia, US | |
3714991 | 3714991 | 2022-12-06 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-07 04:20:58 | Haralson, Georgia, US | |
2415696 | 2415696 | 2022-12-05 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-06 04:21:03 | Haralson, Georgia, US | |
719304 | 719304 | 2022-12-04 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-05 04:20:58 | Haralson, Georgia, US | |
2817593 | 2817593 | 2022-12-03 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-04 04:20:56 | Haralson, Georgia, US | |
834449 | 834449 | 2022-12-02 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-03 04:21:02 | Haralson, Georgia, US | |
2136979 | 2136979 | 2022-12-01 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-02 04:21:07 | Haralson, Georgia, US | |
1965395 | 1965395 | 2022-11-30 | US | Georgia | Haralson | 13143 | 6072 | 183 | 0 | 33.79602175 | -85.21005667 | 2022-12-01 04:21:03 | Haralson, Georgia, US | |
2556992 | 2556992 | 2022-11-29 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-30 04:21:07 | Randolph, Alabama, US | |
1240066 | 1240066 | 2022-11-28 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-29 04:21:05 | Randolph, Alabama, US | |
3552054 | 3552054 | 2022-11-27 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-28 04:21:02 | Randolph, Alabama, US | |
2100534 | 2100534 | 2022-11-26 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-27 04:21:05 | Randolph, Alabama, US | |
488025 | 488025 | 2022-11-25 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-26 04:21:11 | Randolph, Alabama, US | |
3523854 | 3523854 | 2022-11-24 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-25 04:21:06 | Randolph, Alabama, US | |
3312637 | 3312637 | 2022-11-23 | US | Alabama | Randolph | 1111 | 6072 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-24 04:21:09 | Randolph, Alabama, US | |
3029844 | 3029844 | 2022-11-17 | US | Wisconsin | Green Lake | 55047 | 6072 | 70 | 0 | 43.80025981 | -89.04679553 | 2022-11-18 04:21:15 | Green Lake, Wisconsin, US | |
2489480 | 2489480 | 2022-11-16 | US | West Virginia | Brooke | 54009 | 6072 | 107 | 0 | 40.27367263 | -80.57915332 | 2022-11-17 04:21:11 | Brooke, West Virginia, US | |
295491 | 295491 | 2022-11-15 | US | West Virginia | Brooke | 54009 | 6072 | 107 | 0 | 40.27367263 | -80.57915332 | 2022-11-16 04:21:09 | Brooke, West Virginia, US | |
292367 | 292367 | 2022-11-15 | US | Alabama | Butler | 1013 | 6072 | 130 | 0 | 31.75300095 | -86.68057478 | 2022-11-16 04:21:09 | Butler, Alabama, US | |
3597397 | 3597397 | 2022-11-14 | US | Alabama | Butler | 1013 | 6072 | 130 | 0 | 31.75300095 | -86.68057478 | 2022-11-15 04:21:16 | Butler, Alabama, US | |
314835 | 314835 | 2022-11-13 | US | Tennessee | Crockett | 47033 | 6072 | 89 | 0 | 35.81830662 | -89.14916269 | 2022-11-14 04:21:09 | Crockett, Tennessee, US | |
312255 | 312255 | 2022-11-13 | US | Alabama | Butler | 1013 | 6072 | 130 | 0 | 31.75300095 | -86.68057478 | 2022-11-14 04:21:09 | Butler, Alabama, US | |
63416 | 63416 | 2022-11-12 | US | Alabama | Butler | 1013 | 6072 | 130 | 0 | 31.75300095 | -86.68057478 | 2022-11-13 04:21:14 | Butler, Alabama, US | |
2927578 | 2927578 | 2022-11-11 | US | Alabama | Butler | 1013 | 6072 | 130 | 0 | 31.75300095 | -86.68057478 | 2022-11-12 04:20:41 | Butler, Alabama, US | |
2506414 | 2506414 | 2022-11-10 | US | Alabama | Butler | 1013 | 6072 | 130 | 0 | 31.75300095 | -86.68057478 | 2022-11-11 04:21:22 | Butler, Alabama, US | |
3756659 | 3756659 | 2022-10-13 | US | Texas | Moore | 48341 | 6072 | 113 | 0 | 35.83769242 | -101.8930281 | 2022-10-14 04:22:28 | Moore, Texas, US | |
3217484 | 3217484 | 2022-10-12 | US | Texas | Moore | 48341 | 6072 | 113 | 0 | 35.83769242 | -101.8930281 | 2022-10-13 04:22:39 | Moore, Texas, US | |
3253333 | 3253333 | 2022-10-11 | US | Texas | Moore | 48341 | 6072 | 113 | 0 | 35.83769242 | -101.8930281 | 2022-10-12 04:22:51 | Moore, Texas, US | |
2970592 | 2970592 | 2022-10-10 | US | Texas | Moore | 48341 | 6072 | 113 | 0 | 35.83769242 | -101.8930281 | 2022-10-11 04:23:05 | Moore, Texas, US | |
3571077 | 3571077 | 2022-09-19 | US | Arkansas | Conway | 5029 | 6072 | 68 | 0 | 35.26205537 | -92.70506566 | 2022-09-20 04:22:48 | Conway, Arkansas, US | |
422341 | 422341 | 2022-09-18 | US | Tennessee | Unicoi | 47171 | 6072 | 100 | 0 | 36.10890856 | -82.43709629 | 2022-09-19 04:21:49 | Unicoi, Tennessee, US | |
1072536 | 1072536 | 2022-08-07 | US | Oregon | Wasco | 41065 | 6072 | 68 | 0 | 45.16292781 | -121.1670954 | 2022-08-08 04:21:08 | Wasco, Oregon, US | |
1943489 | 1943489 | 2022-08-06 | US | Tennessee | Wayne | 47181 | 6072 | 75 | 0 | 35.23868267 | -87.78644456 | 2022-08-07 04:20:54 | Wayne, Tennessee, US | |
1943124 | 1943124 | 2022-08-06 | US | Oregon | Wasco | 41065 | 6072 | 68 | 0 | 45.16292781 | -121.1670954 | 2022-08-07 04:20:54 | Wasco, Oregon, US | |
882923 | 882923 | 2022-08-05 | US | Oregon | Wasco | 41065 | 6072 | 68 | 0 | 45.16292781 | -121.1670954 | 2022-08-06 04:20:56 | Wasco, Oregon, US | |
2790482 | 2790482 | 2022-07-10 | US | Kentucky | Meade | 21163 | 6072 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-07-11 04:20:46 | Meade, Kentucky, US | |
2790168 | 2790168 | 2022-07-10 | US | Indiana | Randolph | 18135 | 6072 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-07-11 04:20:46 | Randolph, Indiana, US | |
143435 | 143435 | 2022-07-09 | US | Kentucky | Meade | 21163 | 6072 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-07-10 04:20:54 | Meade, Kentucky, US | |
143121 | 143121 | 2022-07-09 | US | Indiana | Randolph | 18135 | 6072 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-07-10 04:20:54 | Randolph, Indiana, US | |
1418535 | 1418535 | 2022-07-08 | US | Kentucky | Meade | 21163 | 6072 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-07-09 04:20:59 | Meade, Kentucky, US | |
1418221 | 1418221 | 2022-07-08 | US | Indiana | Randolph | 18135 | 6072 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-07-09 04:20:59 | Randolph, Indiana, US | |
2742460 | 2742460 | 2022-07-07 | US | Kentucky | Meade | 21163 | 6072 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-07-08 04:20:56 | Meade, Kentucky, US | |
1201255 | 1201255 | 2022-07-06 | US | Kentucky | Meade | 21163 | 6072 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-07-07 04:20:55 | Meade, Kentucky, US | |
1200451 | 1200451 | 2022-07-06 | US | Colorado | Morgan | 8087 | 6072 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-07-07 04:20:55 | Morgan, Colorado, US | |
3967998 | 3967998 | 2022-07-05 | US | Kentucky | Meade | 21163 | 6072 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-07-06 04:20:58 | Meade, Kentucky, US | |
596432 | 596432 | 2022-07-01 | US | Puerto Rico | Quebradillas | 72115 | 6072 | 0 | 0 | 18.439692 | -66.926113 | 2022-07-02 04:21:16 | Quebradillas, Puerto Rico, US | |
3943475 | 3943475 | 2022-06-30 | US | Virginia | Staunton | 51790 | 6072 | 117 | 0 | 38.15965544 | -79.05979937 | 2022-07-01 04:21:10 | Staunton, Virginia, US | |
1648907 | 1648907 | 2022-06-23 | US | Arkansas | Sevier | 5133 | 6072 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-24 04:20:58 | Sevier, Arkansas, US | |
3161121 | 3161121 | 2022-06-09 | US | West Virginia | Hampshire | 54027 | 6072 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-06-10 04:20:55 | Hampshire, West Virginia, US | |
1110020 | 1110020 | 2022-05-21 | US | American Samoa | 60 | 6072 | 30 | 0 | -14.271 | -170.132 | 2022-05-22 04:20:52 | American Samoa, US | ||
1169644 | 1169644 | 2022-05-20 | US | American Samoa | 60 | 6072 | 30 | 0 | -14.271 | -170.132 | 2022-05-21 04:20:58 | American Samoa, US | ||
1327066 | 1327066 | 2022-04-26 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-27 04:20:52 | Harris, Georgia, US | |
3723020 | 3723020 | 2022-04-25 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-26 04:20:51 | Harris, Georgia, US | |
2029712 | 2029712 | 2022-04-24 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-25 04:20:56 | Jerome, Idaho, US | |
2029588 | 2029588 | 2022-04-24 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-25 04:20:56 | Harris, Georgia, US | |
747287 | 747287 | 2022-04-23 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-24 04:20:56 | Jerome, Idaho, US | |
747163 | 747163 | 2022-04-23 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-24 04:20:56 | Harris, Georgia, US | |
3437772 | 3437772 | 2022-04-22 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-23 04:20:50 | Jerome, Idaho, US | |
3437648 | 3437648 | 2022-04-22 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-23 04:20:50 | Harris, Georgia, US | |
2893357 | 2893357 | 2022-04-21 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-22 04:20:45 | Jerome, Idaho, US | |
2893233 | 2893233 | 2022-04-21 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-22 04:20:45 | Harris, Georgia, US | |
2308229 | 2308229 | 2022-04-20 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-21 04:20:46 | Jerome, Idaho, US | |
2308105 | 2308105 | 2022-04-20 | US | Georgia | Harris | 13145 | 6072 | 112 | 0 | 32.73709786 | -84.90538572 | 2022-04-21 04:20:46 | Harris, Georgia, US | |
2253001 | 2253001 | 2022-04-19 | US | Maryland | Caroline | 24011 | 6072 | 80 | 0 | 38.87172293 | -75.82904158 | 2022-04-20 04:20:45 | Caroline, Maryland, US | |
2252368 | 2252368 | 2022-04-19 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-20 04:20:45 | Jerome, Idaho, US | |
1846918 | 1846918 | 2022-04-18 | US | Idaho | Jerome | 16053 | 6072 | 65 | 0 | 42.68891267 | -114.2655033 | 2022-04-19 04:21:00 | Jerome, Idaho, US | |
2481103 | 2481103 | 2022-03-30 | US | Texas | Jasper | 48241 | 6072 | 185 | 0 | 30.74685667 | -94.02667579 | 2022-03-31 04:20:56 | Jasper, Texas, US | |
2319802 | 2319802 | 2022-03-16 | US | Arkansas | Carroll | 5015 | 6072 | 97 | 0 | 36.34038560000001 | -93.54270261 | 2022-03-17 04:20:56 | Carroll, Arkansas, US | |
263466 | 263466 | 2022-03-15 | US | Missouri | Miller | 29131 | 6072 | 115 | 0 | 38.21450288 | -92.42610898 | 2022-03-16 04:20:50 | Miller, Missouri, US | |
921656 | 921656 | 2022-03-08 | US | Missouri | Stoddard | 29207 | 6072 | 122 | 0 | 36.85571651 | -89.9444155 | 2022-03-09 04:20:59 | Stoddard, Missouri, US | |
3913453 | 3913453 | 2022-02-20 | US | Kentucky | Lincoln | 21137 | 6072 | 118 | 0 | 37.45475628 | -84.6565327 | 2022-02-21 04:21:05 | Lincoln, Kentucky, US | |
3877011 | 3877011 | 2022-02-19 | US | Kentucky | Lincoln | 21137 | 6072 | 118 | 0 | 37.45475628 | -84.6565327 | 2022-02-20 04:21:00 | Lincoln, Kentucky, US | |
3857267 | 3857267 | 2022-02-18 | US | Kentucky | Lincoln | 21137 | 6072 | 118 | 0 | 37.45475628 | -84.6565327 | 2022-02-19 04:21:11 | Lincoln, Kentucky, US | |
1294649 | 1294649 | 2022-02-05 | US | Colorado | Delta | 8029 | 6072 | 131 | 0 | 38.86246243 | -107.86313419999999 | 2022-02-06 04:21:00 | Delta, Colorado, US | |
461597 | 461597 | 2022-02-02 | US | New Mexico | Unassigned | 90035 | 6072 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-02-03 04:21:21 | Unassigned, New Mexico, US | |
3607354 | 3607354 | 2021-12-25 | US | New York | Wyoming | 36121 | 6072 | 73 | 0 | 42.70145109 | -78.22199579 | 2021-12-26 04:21:50 | Wyoming, New York, US | |
2965672 | 2965672 | 2021-12-24 | US | New York | Wyoming | 36121 | 6072 | 73 | 0 | 42.70145109 | -78.22199579 | 2021-12-25 04:21:37 | Wyoming, New York, US | |
785960 | 785960 | 2021-12-13 | US | Wisconsin | Oneida | 55085 | 6072 | 103 | 0 | 45.70677897 | -89.51944105 | 2021-12-14 04:22:38 | Oneida, Wisconsin, US | |
1032472 | 1032472 | 2021-12-06 | US | Nebraska | Lincoln | 31111 | 6072 | 60 | 0 | 41.04658298 | -100.74753740000001 | 2021-12-07 04:22:34 | Lincoln, Nebraska, US | |
3190 | 3190 | 2021-12-02 | US | South Dakota | Codington | 46029 | 6072 | 88 | 0 | 44.97788119 | -97.18827677 | 2021-12-03 04:23:05 | Codington, South Dakota, US | |
290936 | 290936 | 2021-10-31 | US | Tennessee | Giles | 47055 | 6072 | 121 | 0 | 35.20222469 | -87.03992678 | 2021-11-01 04:22:01 | Giles, Tennessee, US | |
3795385 | 3795385 | 2021-10-25 | US | Louisiana | Beauregard | 22011 | 6072 | 123 | 0 | 30.64836518 | -93.34173616 | 2021-10-26 04:22:09 | Beauregard, Louisiana, US | |
653748 | 653748 | 2021-10-22 | Canada | New Brunswick | 6072 | 106 | 0 | 46.5653 | -66.4619 | 2021-10-23 04:21:32 | New Brunswick, Canada | |||
600841 | 600841 | 2021-10-19 | US | Texas | Matagorda | 48321 | 6072 | 153 | 0 | 28.81955746 | -96.01230294 | 2021-10-20 04:21:00 | Matagorda, Texas, US | |
937046 | 937046 | 2021-10-16 | US | New York | Madison | 36053 | 6072 | 101 | 0 | 42.91653905 | -75.67266639 | 2021-10-17 04:21:29 | Madison, New York, US | |
2076347 | 2076347 | 2021-09-26 | US | Alabama | Russell | 1113 | 6072 | 55 | 0 | 32.28725256 | -85.18415324 | 2021-09-27 04:21:16 | Russell, Alabama, US | |
604363 | 604363 | 2021-09-23 | US | Pennsylvania | Huntingdon | 42061 | 6072 | 143 | 0 | 40.42162652 | -77.97673273 | 2021-09-24 04:21:44 | Huntingdon, Pennsylvania, US | |
3013121 | 3013121 | 2021-09-22 | US | Mississippi | Bolivar | 28011 | 6072 | 144 | 0 | 33.79696941 | -90.87372121 | 2021-09-23 04:21:43 | Bolivar, Mississippi, US | |
1817460 | 1817460 | 2021-09-19 | US | Pennsylvania | Mifflin | 42087 | 6072 | 184 | 0 | 40.61116939 | -77.61070738 | 2021-09-20 04:21:22 | Mifflin, Pennsylvania, US | |
2809350 | 2809350 | 2021-09-16 | US | Colorado | Broomfield | 8014 | 6072 | 79 | 0 | 39.95998787 | -105.0566324 | 2021-09-17 04:21:46 | Broomfield, Colorado, US | |
2809338 | 2809338 | 2021-09-16 | US | California | Tuolumne | 6109 | 6072 | 89 | 0 | 38.02644018 | -119.95250929999999 | 2021-09-17 04:21:46 | Tuolumne, California, US | |
3196357 | 3196357 | 2021-09-06 | US | North Carolina | Richmond | 37153 | 6072 | 119 | 0 | 35.00417719 | -79.74491009 | 2021-09-07 04:21:35 | Richmond, North Carolina, US | |
3193772 | 3193772 | 2021-09-06 | Canada | Nova Scotia | 6072 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-07 04:21:35 | Nova Scotia, Canada | |||
3283225 | 3283225 | 2021-09-05 | US | North Carolina | Richmond | 37153 | 6072 | 119 | 0 | 35.00417719 | -79.74491009 | 2021-09-06 04:21:22 | Richmond, North Carolina, US | |
251639 | 251639 | 2021-09-04 | US | North Carolina | Richmond | 37153 | 6072 | 119 | 0 | 35.00417719 | -79.74491009 | 2021-09-05 04:21:33 | Richmond, North Carolina, US | |
3976920 | 3976920 | 2021-09-03 | US | North Carolina | Richmond | 37153 | 6072 | 119 | 0 | 35.00417719 | -79.74491009 | 2021-09-04 04:21:28 | Richmond, North Carolina, US | |
2178488 | 2178488 | 2021-08-22 | US | Tennessee | Franklin | 47051 | 6072 | 91 | 0 | 35.15634626 | -86.09201039 | 2021-08-23 04:21:27 | Franklin, Tennessee, US | |
248276 | 248276 | 2021-08-17 | US | Texas | Anderson | 48001 | 6072 | 135 | 0 | 31.81534745 | -95.65354823 | 2021-08-18 04:21:35 | Anderson, Texas, US | |
246514 | 246514 | 2021-08-17 | US | Iowa | Warren | 19181 | 6072 | 92 | 0 | 41.33559454 | -93.56007641 | 2021-08-18 04:21:35 | Warren, Iowa, 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]);