johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
176 rows where confirmed = 6049 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3378421 | 3378421 | 2022-12-08 | US | Illinois | Richland | 17159 | 6049 | 77 | 0 | 38.71240969 | -88.08475366 | 2022-12-09 04:21:05 | Richland, Illinois, US | |
434292 | 434292 | 2022-11-03 | US | Tennessee | Crockett | 47033 | 6049 | 89 | 0 | 35.81830662 | -89.14916269 | 2022-11-04 04:22:11 | Crockett, Tennessee, US | |
541510 | 541510 | 2022-10-26 | US | Puerto Rico | Lajas | 72079 | 6049 | 0 | 0 | 18.011661 | -67.040585 | 2022-10-27 04:22:01 | Lajas, Puerto Rico, US | |
1627884 | 1627884 | 2022-09-22 | US | Wisconsin | Vilas | 55125 | 6049 | 99 | 0 | 46.05467334 | -89.51719204 | 2022-09-23 04:23:13 | Vilas, Wisconsin, US | |
372700 | 372700 | 2022-09-13 | US | Arkansas | Lawrence | 5075 | 6049 | 85 | 0 | 36.04188196 | -91.10867198 | 2022-09-14 04:20:44 | Lawrence, Arkansas, US | |
2398362 | 2398362 | 2022-09-12 | US | Wisconsin | Langlade | 55067 | 6049 | 97 | 0 | 45.26271619 | -89.07483625 | 2022-09-13 04:20:57 | Langlade, Wisconsin, US | |
2397804 | 2397804 | 2022-09-12 | US | Tennessee | Unicoi | 47171 | 6049 | 99 | 0 | 36.10890856 | -82.43709629 | 2022-09-13 04:20:57 | Unicoi, Tennessee, US | |
2395279 | 2395279 | 2022-09-12 | US | Arkansas | Conway | 5029 | 6049 | 68 | 0 | 35.26205537 | -92.70506566 | 2022-09-13 04:20:57 | Conway, Arkansas, US | |
3766357 | 3766357 | 2022-09-11 | US | Arkansas | Conway | 5029 | 6049 | 68 | 0 | 35.26205537 | -92.70506566 | 2022-09-12 04:20:58 | Conway, Arkansas, US | |
3824932 | 3824932 | 2022-09-10 | US | Arkansas | Conway | 5029 | 6049 | 68 | 0 | 35.26205537 | -92.70506566 | 2022-09-11 04:20:50 | Conway, Arkansas, US | |
1878402 | 1878402 | 2022-08-28 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-29 04:21:06 | Hart, Kentucky, US | |
2097529 | 2097529 | 2022-08-27 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-28 04:21:02 | Hart, Kentucky, US | |
1533344 | 1533344 | 2022-08-26 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-27 04:20:57 | Hart, Kentucky, US | |
2830231 | 2830231 | 2022-08-25 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-26 04:21:02 | Hart, Kentucky, US | |
2324764 | 2324764 | 2022-08-24 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-25 04:21:13 | Hart, Kentucky, US | |
1252173 | 1252173 | 2022-08-23 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-24 04:20:46 | Hart, Kentucky, US | |
1251770 | 1251770 | 2022-08-23 | US | Illinois | Lawrence | 17101 | 6049 | 44 | 0 | 38.71987914 | -87.72884035 | 2022-08-24 04:20:46 | Lawrence, Illinois, US | |
1251234 | 1251234 | 2022-08-23 | US | Arkansas | Columbia | 5027 | 6049 | 99 | 0 | 33.21230701 | -93.22642793 | 2022-08-24 04:20:46 | Columbia, Arkansas, US | |
2854277 | 2854277 | 2022-08-22 | US | Kentucky | Hart | 21099 | 6049 | 108 | 0 | 37.29943898 | -85.88461055 | 2022-08-23 04:20:56 | Hart, Kentucky, US | |
2853338 | 2853338 | 2022-08-22 | US | Arkansas | Columbia | 5027 | 6049 | 99 | 0 | 33.21230701 | -93.22642793 | 2022-08-23 04:20:56 | Columbia, Arkansas, US | |
992350 | 992350 | 2022-08-16 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-17 04:20:59 | Sumner, Kansas, US | |
2495389 | 2495389 | 2022-08-15 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-16 04:20:58 | Sumner, Kansas, US | |
3648939 | 3648939 | 2022-08-14 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-15 04:20:59 | Sumner, Kansas, US | |
1969945 | 1969945 | 2022-08-13 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-14 04:20:55 | Sumner, Kansas, US | |
2889754 | 2889754 | 2022-08-12 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-13 04:20:52 | Sumner, Kansas, US | |
3909359 | 3909359 | 2022-08-11 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-12 04:20:54 | Sumner, Kansas, US | |
1347676 | 1347676 | 2022-08-10 | US | Kansas | Sumner | 20191 | 6049 | 74 | 0 | 37.23682549 | -97.47721621 | 2022-08-11 04:20:49 | Sumner, Kansas, US | |
1101670 | 1101670 | 2022-08-03 | US | Wisconsin | Iowa | 55049 | 6049 | 30 | 0 | 43.00050278 | -90.13469017 | 2022-08-04 04:20:58 | Iowa, Wisconsin, US | |
1099912 | 1099912 | 2022-08-03 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-08-04 04:20:58 | Chickasaw, Mississippi, US | |
1406837 | 1406837 | 2022-08-02 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-08-03 04:20:59 | Chickasaw, Mississippi, US | |
1406609 | 1406609 | 2022-08-02 | US | Maine | Sagadahoc | 23023 | 6049 | 37 | 0 | 43.95415864 | -69.85074999 | 2022-08-03 04:20:59 | Sagadahoc, Maine, US | |
3618875 | 3618875 | 2022-08-01 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-08-02 04:20:53 | Chickasaw, Mississippi, US | |
3873355 | 3873355 | 2022-07-31 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-08-01 04:21:03 | Chickasaw, Mississippi, US | |
676109 | 676109 | 2022-07-30 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-07-31 04:21:02 | Chickasaw, Mississippi, US | |
1785308 | 1785308 | 2022-07-29 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-07-30 04:20:42 | Chickasaw, Mississippi, US | |
1067671 | 1067671 | 2022-07-28 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-07-29 04:20:45 | Chickasaw, Mississippi, US | |
2337190 | 2337190 | 2022-07-27 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-07-28 04:20:56 | Chickasaw, Mississippi, US | |
1489380 | 1489380 | 2022-07-26 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-07-27 04:21:04 | Chickasaw, Mississippi, US | |
2595826 | 2595826 | 2022-07-25 | US | Mississippi | Chickasaw | 28017 | 6049 | 97 | 0 | 33.91983202 | -88.9481545 | 2022-07-26 04:20:58 | Chickasaw, Mississippi, US | |
3080278 | 3080278 | 2022-07-04 | US | New Mexico | Taos | 35055 | 6049 | 95 | 0 | 36.58006022 | -105.6310198 | 2022-07-05 04:20:45 | Taos, New Mexico, US | |
3078705 | 3078705 | 2022-07-04 | US | Colorado | Morgan | 8087 | 6049 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-07-05 04:20:45 | Morgan, Colorado, US | |
1769560 | 1769560 | 2022-07-03 | US | New Mexico | Taos | 35055 | 6049 | 95 | 0 | 36.58006022 | -105.6310198 | 2022-07-04 04:20:54 | Taos, New Mexico, US | |
3367546 | 3367546 | 2022-07-02 | US | New Mexico | Taos | 35055 | 6049 | 95 | 0 | 36.58006022 | -105.6310198 | 2022-07-03 04:20:59 | Taos, New Mexico, US | |
595875 | 595875 | 2022-07-01 | US | New Mexico | Taos | 35055 | 6049 | 95 | 0 | 36.58006022 | -105.6310198 | 2022-07-02 04:21:16 | Taos, New Mexico, US | |
2491609 | 2491609 | 2022-06-29 | US | Maryland | Talbot | 24041 | 6049 | 90 | 0 | 38.76618159 | -76.10882561 | 2022-06-30 04:21:01 | Talbot, Maryland, US | |
2241724 | 2241724 | 2022-06-28 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-29 04:20:59 | Greene, North Carolina, US | |
2149966 | 2149966 | 2022-06-27 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-28 04:20:58 | Greene, North Carolina, US | |
477767 | 477767 | 2022-06-26 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-27 04:21:00 | Greene, North Carolina, US | |
941142 | 941142 | 2022-06-25 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-26 04:21:02 | Greene, North Carolina, US | |
3348962 | 3348962 | 2022-06-24 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-25 04:20:57 | Greene, North Carolina, US | |
1650703 | 1650703 | 2022-06-23 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-24 04:20:58 | Greene, North Carolina, US | |
2189938 | 2189938 | 2022-06-22 | US | North Carolina | Greene | 37079 | 6049 | 69 | 0 | 35.48544173 | -77.67578087 | 2022-06-23 04:20:55 | Greene, North Carolina, US | |
2189122 | 2189122 | 2022-06-22 | US | Louisiana | Grant | 22043 | 6049 | 95 | 0 | 31.59882456 | -92.56124347 | 2022-06-23 04:20:55 | Grant, Louisiana, US | |
169138 | 169138 | 2022-06-21 | US | Texas | Frio | 48163 | 6049 | 94 | 0 | 28.86751206 | -99.10804207 | 2022-06-22 04:20:54 | Frio, Texas, US | |
1763856 | 1763856 | 2022-06-20 | US | Arkansas | Sevier | 5133 | 6049 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-21 04:20:56 | Sevier, Arkansas, US | |
3270042 | 3270042 | 2022-06-19 | US | Arkansas | Sevier | 5133 | 6049 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-20 04:21:01 | Sevier, Arkansas, US | |
3397954 | 3397954 | 2022-06-18 | US | Arkansas | Sevier | 5133 | 6049 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-19 04:20:51 | Sevier, Arkansas, US | |
3896904 | 3896904 | 2022-05-19 | US | Idaho | Jefferson | 16051 | 6049 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-05-20 04:20:57 | Jefferson, Idaho, US | |
1185688 | 1185688 | 2022-05-18 | US | Idaho | Jefferson | 16051 | 6049 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-05-19 04:20:54 | Jefferson, Idaho, US | |
2535353 | 2535353 | 2022-05-12 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-13 04:20:51 | Randolph, Missouri, US | |
3446799 | 3446799 | 2022-05-11 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-12 04:20:54 | Randolph, Missouri, US | |
3537416 | 3537416 | 2022-05-10 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-11 04:20:48 | Randolph, Missouri, US | |
223951 | 223951 | 2022-05-09 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-10 04:20:50 | Randolph, Missouri, US | |
2333336 | 2333336 | 2022-05-08 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-09 04:20:54 | Randolph, Missouri, US | |
362298 | 362298 | 2022-05-07 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-08 04:20:49 | Randolph, Missouri, US | |
1399649 | 1399649 | 2022-05-06 | US | Missouri | Randolph | 29175 | 6049 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-07 04:21:09 | Randolph, Missouri, US | |
3418342 | 3418342 | 2022-04-17 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-18 04:21:12 | Johnson, Kentucky, US | |
305291 | 305291 | 2022-04-16 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-17 04:20:59 | Johnson, Kentucky, US | |
2671236 | 2671236 | 2022-04-15 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-16 04:20:48 | Johnson, Kentucky, US | |
1225021 | 1225021 | 2022-04-14 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-15 04:20:57 | Johnson, Kentucky, US | |
2444179 | 2444179 | 2022-04-13 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-13 23:21:06 | Johnson, Kentucky, US | |
1949936 | 1949936 | 2022-04-12 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-13 04:21:03 | Johnson, Kentucky, US | |
3207689 | 3207689 | 2022-04-11 | US | Kentucky | Johnson | 21115 | 6049 | 109 | 0 | 37.85106355 | -82.8264322 | 2022-04-12 04:20:49 | Johnson, Kentucky, US | |
3732575 | 3732575 | 2022-04-03 | US | North Carolina | Martin | 37117 | 6049 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-04 04:20:51 | Martin, North Carolina, US | |
502010 | 502010 | 2022-04-02 | US | North Carolina | Martin | 37117 | 6049 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-03 04:20:48 | Martin, North Carolina, US | |
3352995 | 3352995 | 2022-04-01 | US | North Carolina | Martin | 37117 | 6049 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-02 04:20:47 | Martin, North Carolina, US | |
1542300 | 1542300 | 2022-03-31 | US | North Carolina | Martin | 37117 | 6049 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-01 04:20:28 | Martin, North Carolina, US | |
2478790 | 2478790 | 2022-03-30 | US | Georgia | Harris | 13145 | 6049 | 111 | 0 | 32.73709786 | -84.90538572 | 2022-03-31 04:20:56 | Harris, Georgia, US | |
2528773 | 2528773 | 2022-03-02 | US | Virginia | Salem | 51775 | 6049 | 101 | 0 | 37.2836193 | -80.06219455 | 2022-03-03 04:21:01 | Salem, Virginia, US | |
3912878 | 3912878 | 2022-02-20 | US | Georgia | Peach | 13225 | 6049 | 119 | 0 | 32.56934316 | -83.82937 | 2022-02-21 04:21:05 | Peach, Georgia, US | |
3876436 | 3876436 | 2022-02-19 | US | Georgia | Peach | 13225 | 6049 | 119 | 0 | 32.56934316 | -83.82937 | 2022-02-20 04:21:00 | Peach, Georgia, US | |
3856692 | 3856692 | 2022-02-18 | US | Georgia | Peach | 13225 | 6049 | 119 | 0 | 32.56934316 | -83.82937 | 2022-02-19 04:21:11 | Peach, Georgia, US | |
2016074 | 2016074 | 2022-02-06 | US | Virginia | Louisa | 51109 | 6049 | 61 | 0 | 37.97850256 | -77.96274807 | 2022-02-07 04:21:05 | Louisa, Virginia, US | |
1297403 | 1297403 | 2022-02-05 | US | Virginia | Louisa | 51109 | 6049 | 61 | 0 | 37.97850256 | -77.96274807 | 2022-02-06 04:21:00 | Louisa, Virginia, US | |
2330731 | 2330731 | 2022-02-04 | US | Virginia | Louisa | 51109 | 6049 | 61 | 0 | 37.97850256 | -77.96274807 | 2022-02-05 04:21:05 | Louisa, Virginia, US | |
3062346 | 3062346 | 2022-01-29 | US | Alabama | Bibb | 1007 | 6049 | 96 | 0 | 32.99642064 | -87.12511459999996 | 2022-01-30 04:21:26 | Bibb, Alabama, US | |
1781576 | 1781576 | 2022-01-27 | US | New Mexico | Cibola | 35006 | 6049 | 167 | 0 | 34.91131525 | -107.998876 | 2022-01-28 04:21:09 | Cibola, New Mexico, US | |
2054357 | 2054357 | 2022-01-25 | US | Ohio | Henry | 39069 | 6049 | 102 | 0 | 41.333964200000004 | -84.06830637 | 2022-01-26 04:21:07 | Henry, Ohio, US | |
1230964 | 1230964 | 2022-01-24 | US | Virginia | Halifax | 51083 | 6049 | 128 | 0 | 36.76654925 | -78.93512622 | 2022-01-25 04:21:05 | Halifax, Virginia, US | |
3467473 | 3467473 | 2022-01-18 | US | Virginia | Accomack | 51001 | 6049 | 85 | 0 | 37.76707161 | -75.63234615 | 2022-01-19 04:21:23 | Accomack, Virginia, US | |
3465976 | 3465976 | 2022-01-18 | US | Mississippi | Covington | 28031 | 6049 | 98 | 0 | 31.63225413 | -89.55389939 | 2022-01-19 04:21:23 | Covington, Mississippi, US | |
3688616 | 3688616 | 2022-01-13 | US | Indiana | Scott | 18143 | 6049 | 85 | 0 | 38.68672078 | -85.74627859 | 2022-01-14 04:21:54 | Scott, Indiana, US | |
130128 | 130128 | 2022-01-09 | US | Virginia | Prince George | 51149 | 6049 | 53 | 0 | 37.18497668 | -77.22922187 | 2022-01-10 04:22:07 | Prince George, Virginia, US | |
1218963 | 1218963 | 2022-01-08 | US | Virginia | Prince George | 51149 | 6049 | 53 | 0 | 37.18497668 | -77.22922187 | 2022-01-09 04:21:46 | Prince George, Virginia, US | |
1393056 | 1393056 | 2022-01-07 | US | Virginia | Prince George | 51149 | 6049 | 53 | 0 | 37.18497668 | -77.22922187 | 2022-01-08 04:21:53 | Prince George, Virginia, US | |
3522441 | 3522441 | 2022-01-02 | US | Tennessee | White | 47185 | 6049 | 115 | 0 | 35.92929884 | -85.45591799 | 2022-01-03 02:22:25 | White, Tennessee, US | |
801352 | 801352 | 2021-12-22 | US | Tennessee | Carroll | 47017 | 6049 | 123 | 0 | 35.97366108 | -88.45189331 | 2021-12-23 04:21:21 | Carroll, Tennessee, US | |
2091171 | 2091171 | 2021-12-14 | US | Texas | Polk | 48373 | 6049 | 219 | 0 | 30.79472531 | -94.82766240000001 | 2021-12-15 03:22:16 | Polk, Texas, US | |
785588 | 785588 | 2021-12-13 | US | Texas | Polk | 48373 | 6049 | 219 | 0 | 30.79472531 | -94.82766240000001 | 2021-12-14 04:22:38 | Polk, Texas, US | |
3402542 | 3402542 | 2021-11-30 | US | Indiana | Jasper | 18073 | 6049 | 92 | 0 | 41.02078733 | -87.11553319 | 2021-12-01 04:22:29 | Jasper, Indiana, 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]);