johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
147 rows where confirmed = 6158 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1152424 | 1152424 | 2022-12-12 | US | West Virginia | Brooke | 54009 | 6158 | 109 | 0 | 40.27367263 | -80.57915332 | 2022-12-13 04:21:01 | Brooke, West Virginia, US | |
1151880 | 1151880 | 2022-12-12 | US | Tennessee | Crockett | 47033 | 6158 | 89 | 0 | 35.81830662 | -89.14916269 | 2022-12-13 04:21:01 | Crockett, Tennessee, US | |
1640873 | 1640873 | 2022-11-20 | US | Arkansas | Randolph | 5121 | 6158 | 100 | 0 | 36.3415714 | -91.02455531 | 2022-11-21 04:21:05 | Randolph, Arkansas, US | |
2064430 | 2064430 | 2022-11-19 | US | Arkansas | Randolph | 5121 | 6158 | 100 | 0 | 36.3415714 | -91.02455531 | 2022-11-20 04:21:08 | Randolph, Arkansas, US | |
3027002 | 3027002 | 2022-11-17 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-18 04:21:15 | Holmes, Florida, US | |
2486713 | 2486713 | 2022-11-16 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-17 04:21:11 | Holmes, Florida, US | |
292724 | 292724 | 2022-11-15 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-16 04:21:09 | Holmes, Florida, US | |
3597754 | 3597754 | 2022-11-14 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-15 04:21:16 | Holmes, Florida, US | |
312612 | 312612 | 2022-11-13 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-14 04:21:09 | Holmes, Florida, US | |
63773 | 63773 | 2022-11-12 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-13 04:21:14 | Holmes, Florida, US | |
2927935 | 2927935 | 2022-11-11 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-12 04:20:41 | Holmes, Florida, US | |
2506771 | 2506771 | 2022-11-10 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-11 04:21:22 | Holmes, Florida, US | |
2431646 | 2431646 | 2022-11-09 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-10 04:21:16 | Holmes, Florida, US | |
480302 | 480302 | 2022-11-08 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-09 04:21:22 | Holmes, Florida, US | |
2439452 | 2439452 | 2022-11-07 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-08 04:21:21 | Holmes, Florida, US | |
1050550 | 1050550 | 2022-11-06 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-07 04:21:26 | Holmes, Florida, US | |
618574 | 618574 | 2022-11-05 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-06 04:21:24 | Holmes, Florida, US | |
1023078 | 1023078 | 2022-11-04 | US | Florida | Holmes | 12059 | 6158 | 103 | 0 | 30.86747479 | -85.81319222 | 2022-11-05 04:21:52 | Holmes, Florida, US | |
320413 | 320413 | 2022-10-30 | US | Arkansas | Conway | 5029 | 6158 | 74 | 0 | 35.26205537 | -92.70506566 | 2022-10-31 04:21:36 | Conway, Arkansas, US | |
3277373 | 3277373 | 2022-10-23 | US | Arkansas | Lawrence | 5075 | 6158 | 87 | 0 | 36.04188196 | -91.10867198 | 2022-10-24 04:22:29 | Lawrence, Arkansas, US | |
2268411 | 2268411 | 2022-10-22 | US | Arkansas | Lawrence | 5075 | 6158 | 87 | 0 | 36.04188196 | -91.10867198 | 2022-10-23 04:22:46 | Lawrence, Arkansas, US | |
1592711 | 1592711 | 2022-10-21 | US | Arkansas | Lawrence | 5075 | 6158 | 87 | 0 | 36.04188196 | -91.10867198 | 2022-10-22 04:22:53 | Lawrence, Arkansas, US | |
2028152 | 2028152 | 2022-10-17 | US | Virginia | Prince Edward | 51147 | 6158 | 80 | 0 | 37.22554789 | -78.43597949 | 2022-10-18 04:22:42 | Prince Edward, Virginia, US | |
963388 | 963388 | 2022-09-09 | US | Arkansas | Columbia | 5027 | 6158 | 99 | 0 | 33.21230701 | -93.22642793 | 2022-09-10 04:21:10 | Columbia, Arkansas, US | |
2494548 | 2494548 | 2022-08-15 | US | Arkansas | Ouachita | 5103 | 6158 | 110 | 0 | 33.58839816 | -92.87795984 | 2022-08-16 04:20:58 | Ouachita, Arkansas, US | |
1073447 | 1073447 | 2022-08-07 | US | Wisconsin | Jackson | 55053 | 6158 | 43 | 0 | 44.31864893 | -90.80566792 | 2022-08-08 04:21:08 | Jackson, Wisconsin, US | |
1944035 | 1944035 | 2022-08-06 | US | Wisconsin | Jackson | 55053 | 6158 | 43 | 0 | 44.31864893 | -90.80566792 | 2022-08-07 04:20:54 | Jackson, Wisconsin, US | |
883834 | 883834 | 2022-08-05 | US | Wisconsin | Jackson | 55053 | 6158 | 43 | 0 | 44.31864893 | -90.80566792 | 2022-08-06 04:20:56 | Jackson, Wisconsin, US | |
3213323 | 3213323 | 2022-07-18 | US | Texas | Calhoun | 48057 | 6158 | 51 | 0 | 28.47048236 | -96.61633945 | 2022-07-19 04:20:58 | Calhoun, Texas, US | |
3409015 | 3409015 | 2022-07-17 | US | Wisconsin | Kewaunee | 55061 | 6158 | 60 | 0 | 44.51727459 | -87.61468386 | 2022-07-18 04:20:59 | Kewaunee, Wisconsin, US | |
2155215 | 2155215 | 2022-07-16 | US | Wisconsin | Kewaunee | 55061 | 6158 | 60 | 0 | 44.51727459 | -87.61468386 | 2022-07-17 04:21:15 | Kewaunee, Wisconsin, US | |
2422448 | 2422448 | 2022-07-15 | US | Wisconsin | Kewaunee | 55061 | 6158 | 60 | 0 | 44.51727459 | -87.61468386 | 2022-07-16 04:21:05 | Kewaunee, Wisconsin, US | |
3112894 | 3112894 | 2022-07-13 | US | Virginia | Salem | 51775 | 6158 | 99 | 0 | 37.2836193 | -80.06219455 | 2022-07-14 04:20:57 | Salem, Virginia, US | |
3967493 | 3967493 | 2022-07-05 | US | Idaho | Jefferson | 16051 | 6158 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-06 04:20:58 | Jefferson, Idaho, US | |
3079004 | 3079004 | 2022-07-04 | US | Idaho | Jefferson | 16051 | 6158 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-05 04:20:45 | Jefferson, Idaho, US | |
1768286 | 1768286 | 2022-07-03 | US | Idaho | Jefferson | 16051 | 6158 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-04 04:20:54 | Jefferson, Idaho, US | |
3366272 | 3366272 | 2022-07-02 | US | Idaho | Jefferson | 16051 | 6158 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-03 04:20:59 | Jefferson, Idaho, US | |
594601 | 594601 | 2022-07-01 | US | Idaho | Jefferson | 16051 | 6158 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-02 04:21:16 | Jefferson, Idaho, US | |
3984352 | 3984352 | 2022-06-15 | US | Minnesota | Meeker | 27093 | 6158 | 75 | 0 | 45.12328869 | -94.52839455 | 2022-06-16 04:20:55 | Meeker, Minnesota, US | |
947669 | 947669 | 2022-06-14 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-15 04:20:54 | Harris, Georgia, US | |
2980077 | 2980077 | 2022-06-13 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-14 04:20:52 | Harris, Georgia, US | |
2236203 | 2236203 | 2022-06-12 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-13 04:21:14 | Harris, Georgia, US | |
3142401 | 3142401 | 2022-06-11 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-12 04:20:53 | Harris, Georgia, US | |
1945317 | 1945317 | 2022-06-10 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-11 04:21:01 | Harris, Georgia, US | |
3159571 | 3159571 | 2022-06-09 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-10 04:20:55 | Miller, Missouri, US | |
3158456 | 3158456 | 2022-06-09 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-10 04:20:55 | Harris, Georgia, US | |
1423038 | 1423038 | 2022-06-08 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-09 04:20:54 | Miller, Missouri, US | |
1421923 | 1421923 | 2022-06-08 | US | Georgia | Harris | 13145 | 6158 | 114 | 0 | 32.73709786 | -84.90538572 | 2022-06-09 04:20:54 | Harris, Georgia, US | |
3728152 | 3728152 | 2022-06-07 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-08 04:20:55 | Miller, Missouri, US | |
3889554 | 3889554 | 2022-06-06 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-07 04:21:08 | Miller, Missouri, US | |
3509323 | 3509323 | 2022-06-05 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-06 04:20:57 | Miller, Missouri, US | |
3529400 | 3529400 | 2022-06-04 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-05 04:20:55 | Miller, Missouri, US | |
3135486 | 3135486 | 2022-06-03 | US | Missouri | Miller | 29131 | 6158 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-04 04:20:58 | Miller, Missouri, US | |
3586001 | 3586001 | 2022-05-17 | US | Virginia | Hopewell | 51670 | 6158 | 118 | 0 | 37.29186313 | -77.29754684 | 2022-05-18 04:20:50 | Hopewell, Virginia, US | |
3583912 | 3583912 | 2022-05-17 | US | Kansas | Cherokee | 20021 | 6158 | 86 | 0 | 37.16928494 | -94.8462897 | 2022-05-18 04:20:50 | Cherokee, Kansas, US | |
1504869 | 1504869 | 2022-05-16 | US | Kansas | Cherokee | 20021 | 6158 | 86 | 0 | 37.16928494 | -94.8462897 | 2022-05-17 04:20:59 | Cherokee, Kansas, US | |
2086574 | 2086574 | 2022-05-15 | US | Oregon | Crook | 41013 | 6158 | 79 | 0 | 44.14230227 | -120.356297 | 2022-05-16 04:20:47 | Crook, Oregon, US | |
2085228 | 2085228 | 2022-05-15 | US | Kansas | Cherokee | 20021 | 6158 | 86 | 0 | 37.16928494 | -94.8462897 | 2022-05-16 04:20:47 | Cherokee, Kansas, US | |
3357284 | 3357284 | 2022-05-14 | US | Oregon | Crook | 41013 | 6158 | 79 | 0 | 44.14230227 | -120.356297 | 2022-05-15 04:20:53 | Crook, Oregon, US | |
3355938 | 3355938 | 2022-05-14 | US | Kansas | Cherokee | 20021 | 6158 | 86 | 0 | 37.16928494 | -94.8462897 | 2022-05-15 04:20:53 | Cherokee, Kansas, US | |
660929 | 660929 | 2022-05-13 | US | Oregon | Crook | 41013 | 6158 | 79 | 0 | 44.14230227 | -120.356297 | 2022-05-14 04:20:48 | Crook, Oregon, US | |
659583 | 659583 | 2022-05-13 | US | Kansas | Cherokee | 20021 | 6158 | 86 | 0 | 37.16928494 | -94.8462897 | 2022-05-14 04:20:48 | Cherokee, Kansas, US | |
3917890 | 3917890 | 2022-05-01 | US | Mississippi | Tishomingo | 28141 | 6158 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-05-02 04:21:10 | Tishomingo, Mississippi, US | |
2842694 | 2842694 | 2022-04-30 | US | Mississippi | Tishomingo | 28141 | 6158 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-05-01 04:20:57 | Tishomingo, Mississippi, US | |
1159007 | 1159007 | 2022-04-29 | US | Mississippi | Tishomingo | 28141 | 6158 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-04-30 04:21:05 | Tishomingo, Mississippi, US | |
1698189 | 1698189 | 2022-04-28 | US | Mississippi | Tishomingo | 28141 | 6158 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-04-29 04:20:59 | Tishomingo, Mississippi, US | |
3853672 | 3853672 | 2022-04-27 | US | Mississippi | Tishomingo | 28141 | 6158 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-04-28 04:20:47 | Tishomingo, Mississippi, US | |
1328102 | 1328102 | 2022-04-26 | US | Mississippi | Tishomingo | 28141 | 6158 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-04-27 04:20:52 | Tishomingo, Mississippi, US | |
749097 | 749097 | 2022-04-23 | US | Puerto Rico | Juncos | 72077 | 6158 | 0 | 0 | 18.223793 | -65.909109 | 2022-04-24 04:20:56 | Juncos, Puerto Rico, US | |
3321099 | 3321099 | 2022-04-07 | US | Georgia | Peach | 13225 | 6158 | 133 | 0 | 32.56934316 | -83.82937 | 2022-04-08 04:20:48 | Peach, Georgia, US | |
2166499 | 2166499 | 2022-03-26 | US | Tennessee | Haywood | 47075 | 6158 | 99 | 0 | 35.58332824 | -89.28536625 | 2022-03-27 04:20:47 | Haywood, Tennessee, US | |
1723435 | 1723435 | 2022-03-25 | US | Tennessee | Haywood | 47075 | 6158 | 99 | 0 | 35.58332824 | -89.28536625 | 2022-03-26 04:20:23 | Haywood, Tennessee, US | |
1471079 | 1471079 | 2022-03-24 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-25 04:20:46 | Morgan, Tennessee, US | |
3025253 | 3025253 | 2022-03-23 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-24 04:20:43 | Morgan, Tennessee, US | |
1908175 | 1908175 | 2022-03-22 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-23 04:20:48 | Morgan, Tennessee, US | |
3241306 | 3241306 | 2022-03-21 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-22 04:20:54 | Morgan, Tennessee, US | |
27379 | 27379 | 2022-03-20 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-21 04:20:50 | Morgan, Tennessee, US | |
1659389 | 1659389 | 2022-03-19 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-20 04:20:45 | Morgan, Tennessee, US | |
338915 | 338915 | 2022-03-18 | US | Tennessee | Morgan | 47129 | 6158 | 80 | 0 | 36.13248031 | -84.64880098 | 2022-03-19 04:20:47 | Morgan, Tennessee, US | |
2474302 | 2474302 | 2022-02-03 | US | Alabama | Bibb | 1007 | 6158 | 96 | 0 | 32.99642064 | -87.12511459999996 | 2022-02-04 04:21:10 | Bibb, Alabama, US | |
459727 | 459727 | 2022-02-02 | US | Alabama | Bibb | 1007 | 6158 | 96 | 0 | 32.99642064 | -87.12511459999996 | 2022-02-03 04:21:21 | Bibb, Alabama, US | |
3303605 | 3303605 | 2022-01-30 | US | Virginia | Pulaski | 51155 | 6158 | 111 | 0 | 37.06474963 | -80.71229738 | 2022-01-31 04:21:09 | Pulaski, Virginia, US | |
3065396 | 3065396 | 2022-01-29 | US | Virginia | Pulaski | 51155 | 6158 | 111 | 0 | 37.06474963 | -80.71229738 | 2022-01-30 04:21:26 | Pulaski, Virginia, US | |
3064941 | 3064941 | 2022-01-29 | US | Tennessee | Grainger | 47057 | 6158 | 98 | 0 | 36.27469206 | -83.51254721 | 2022-01-30 04:21:26 | Grainger, Tennessee, US | |
3813330 | 3813330 | 2022-01-28 | US | Virginia | Pulaski | 51155 | 6158 | 111 | 0 | 37.06474963 | -80.71229738 | 2022-01-29 04:21:10 | Pulaski, Virginia, US | |
3228189 | 3228189 | 2022-01-19 | US | Minnesota | Lyon | 27083 | 6158 | 69 | 0 | 44.41327865 | -95.83806103 | 2022-01-20 04:21:07 | Lyon, Minnesota, US | |
3467717 | 3467717 | 2022-01-18 | US | Wisconsin | Door | 55029 | 6158 | 53 | 0 | 44.95856458 | -87.30002707 | 2022-01-19 04:21:23 | Door, Wisconsin, US | |
1389669 | 1389669 | 2022-01-07 | Japan | Miyazaki | 6158 | 41 | 0 | 32.193203999999994 | 131.299374 | 2022-01-08 04:21:53 | Miyazaki, Japan | |||
3521672 | 3521672 | 2022-01-02 | US | New York | Greene | 36039 | 6158 | 98 | 0 | 42.275797 | -74.12384884 | 2022-01-03 02:22:25 | Greene, New York, US | |
2169802 | 2169802 | 2022-01-01 | US | New York | Greene | 36039 | 6158 | 98 | 0 | 42.275797 | -74.12384884 | 2022-01-02 04:20:52 | Greene, New York, US | |
2779233 | 2779233 | 2021-12-31 | US | New York | Greene | 36039 | 6158 | 97 | 0 | 42.275797 | -74.12384884 | 2022-01-01 04:22:14 | Greene, New York, US | |
801691 | 801691 | 2021-12-22 | US | Texas | Wood | 48499 | 6158 | 238 | 0 | 32.78722382 | -95.38236368 | 2021-12-23 04:21:21 | Wood, Texas, US | |
3830677 | 3830677 | 2021-12-21 | US | New Mexico | Rio Arriba | 35039 | 6158 | 91 | 0 | 36.51072137 | -106.69316740000001 | 2021-12-22 04:21:54 | Rio Arriba, New Mexico, US | |
2401075 | 2401075 | 2021-12-17 | US | New York | Otsego | 36077 | 6158 | 71 | 0 | 42.63492579 | -75.03151402 | 2021-12-18 02:22:20 | Otsego, New York, US | |
2400229 | 2400229 | 2021-12-17 | US | Kentucky | Harlan | 21095 | 6158 | 149 | 0 | 36.85699301 | -83.21899516 | 2021-12-18 02:22:20 | Harlan, Kentucky, US | |
3750618 | 3750618 | 2021-11-22 | US | Louisiana | Beauregard | 22011 | 6158 | 124 | 0 | 30.64836518 | -93.34173616 | 2021-11-23 04:22:39 | Beauregard, Louisiana, US | |
2290539 | 2290539 | 2021-11-15 | US | Texas | Erath | 48143 | 6158 | 103 | 0 | 32.23602653 | -98.21773417 | 2021-11-16 04:21:10 | Erath, Texas, US | |
1325313 | 1325313 | 2021-11-14 | US | Texas | Erath | 48143 | 6158 | 103 | 0 | 32.23602653 | -98.21773417 | 2021-11-15 04:21:36 | Erath, Texas, US | |
689439 | 689439 | 2021-11-13 | US | Texas | Erath | 48143 | 6158 | 102 | 0 | 32.23602653 | -98.21773417 | 2021-11-14 04:21:31 | Erath, Texas, US | |
2848096 | 2848096 | 2021-11-10 | US | Texas | Upshur | 48459 | 6158 | 145 | 0 | 32.73706798 | -94.93999853 | 2021-11-11 04:21:45 | Upshur, 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]);