johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
195 rows where confirmed = 5867 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 175
- United Kingdom 10
- Japan 3
- Mexico 2
- Comoros 1
- Iceland 1
- Russia 1
- Sao Tome and Principe 1
- Sierra Leone 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454701 | 454701 | 2022-12-21 | US | Virginia | Bristol | 51520 | 5867 | 100 | 0 | 36.6163024 | -82.16359122 | 2022-12-22 04:20:56 | Bristol, Virginia, US | |
2953205 | 2953205 | 2022-12-20 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-21 04:21:03 | Jasper, Mississippi, US | |
3175607 | 3175607 | 2022-12-19 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-20 04:21:04 | Jasper, Mississippi, US | |
1630124 | 1630124 | 2022-12-18 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-19 04:21:03 | Jasper, Mississippi, US | |
505503 | 505503 | 2022-12-17 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-18 04:21:03 | Jasper, Mississippi, US | |
3326075 | 3326075 | 2022-12-16 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-17 04:21:04 | Jasper, Mississippi, US | |
544587 | 544587 | 2022-12-15 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-16 04:21:01 | Jasper, Mississippi, US | |
350115 | 350115 | 2022-12-14 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-15 04:20:58 | Jasper, Mississippi, US | |
309703 | 309703 | 2022-12-13 | US | Mississippi | Jasper | 28061 | 5867 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-14 04:21:04 | Jasper, Mississippi, US | |
2557916 | 2557916 | 2022-11-29 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-30 04:21:07 | Neosho, Kansas, US | |
1240990 | 1240990 | 2022-11-28 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-29 04:21:05 | Neosho, Kansas, US | |
3552978 | 3552978 | 2022-11-27 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-28 04:21:02 | Neosho, Kansas, US | |
2101458 | 2101458 | 2022-11-26 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-27 04:21:05 | Neosho, Kansas, US | |
488949 | 488949 | 2022-11-25 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-26 04:21:11 | Neosho, Kansas, US | |
3524778 | 3524778 | 2022-11-24 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-25 04:21:06 | Neosho, Kansas, US | |
3313561 | 3313561 | 2022-11-23 | US | Kansas | Neosho | 20133 | 5867 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-11-24 04:21:09 | Neosho, Kansas, US | |
2434250 | 2434250 | 2022-11-09 | US | Virginia | Buchanan | 51027 | 5867 | 134 | 0 | 37.26818323 | -82.03749726 | 2022-11-10 04:21:16 | Buchanan, Virginia, US | |
541249 | 541249 | 2022-10-26 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-27 04:22:01 | Meigs, Ohio, US | |
1832650 | 1832650 | 2022-10-25 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-26 04:22:19 | Meigs, Ohio, US | |
796911 | 796911 | 2022-10-24 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-25 04:21:53 | Meigs, Ohio, US | |
3279366 | 3279366 | 2022-10-23 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-24 04:22:29 | Meigs, Ohio, US | |
2270404 | 2270404 | 2022-10-22 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-23 04:22:46 | Meigs, Ohio, US | |
1594704 | 1594704 | 2022-10-21 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-22 04:22:53 | Meigs, Ohio, US | |
2274420 | 2274420 | 2022-10-20 | US | Ohio | Meigs | 39105 | 5867 | 98 | 0 | 39.09224872 | -82.0305041 | 2022-10-21 04:22:23 | Meigs, Ohio, US | |
3995103 | 3995103 | 2022-09-27 | US | Arkansas | Ashley | 5003 | 5867 | 77 | 0 | 33.19153461 | -91.7698471 | 2022-09-28 04:23:01 | Ashley, Arkansas, US | |
422889 | 422889 | 2022-09-18 | US | Wisconsin | Green Lake | 55047 | 5867 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-09-19 04:21:49 | Green Lake, Wisconsin, US | |
3376913 | 3376913 | 2022-09-17 | US | Wisconsin | Green Lake | 55047 | 5867 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-09-18 04:22:50 | Green Lake, Wisconsin, US | |
2359021 | 2359021 | 2022-09-16 | US | Wisconsin | Green Lake | 55047 | 5867 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-09-17 04:20:19 | Green Lake, Wisconsin, US | |
3745635 | 3745635 | 2022-09-07 | US | Arkansas | Randolph | 5121 | 5867 | 95 | 0 | 36.3415714 | -91.02455531 | 2022-09-08 04:21:02 | Randolph, Arkansas, US | |
1251742 | 1251742 | 2022-08-23 | US | Illinois | Edgar | 17045 | 5867 | 60 | 0 | 39.6809186 | -87.74759563 | 2022-08-24 04:20:46 | Edgar, Illinois, US | |
3911564 | 3911564 | 2022-08-11 | US | Wisconsin | Langlade | 55067 | 5867 | 94 | 0 | 45.26271619 | -89.07483625 | 2022-08-12 04:20:54 | Langlade, Wisconsin, US | |
1099907 | 1099907 | 2022-08-03 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-08-04 04:20:58 | Attala, Mississippi, US | |
1406832 | 1406832 | 2022-08-02 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-08-03 04:20:59 | Attala, Mississippi, US | |
3620443 | 3620443 | 2022-08-01 | US | Virginia | King George | 51099 | 5867 | 45 | 0 | 38.26818502 | -77.15852768 | 2022-08-02 04:20:53 | King George, Virginia, US | |
3618870 | 3618870 | 2022-08-01 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-08-02 04:20:53 | Attala, Mississippi, US | |
3873350 | 3873350 | 2022-07-31 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-08-01 04:21:03 | Attala, Mississippi, US | |
676104 | 676104 | 2022-07-30 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-07-31 04:21:02 | Attala, Mississippi, US | |
1785303 | 1785303 | 2022-07-29 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-07-30 04:20:42 | Attala, Mississippi, US | |
1067666 | 1067666 | 2022-07-28 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-07-29 04:20:45 | Attala, Mississippi, US | |
2337185 | 2337185 | 2022-07-27 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-07-28 04:20:56 | Attala, Mississippi, US | |
1489375 | 1489375 | 2022-07-26 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-07-27 04:21:04 | Attala, Mississippi, US | |
2595821 | 2595821 | 2022-07-25 | US | Mississippi | Attala | 28007 | 5867 | 115 | 0 | 33.08658803 | -89.57838564 | 2022-07-26 04:20:58 | Attala, Mississippi, US | |
3408100 | 3408100 | 2022-07-17 | US | Oregon | Wasco | 41065 | 5867 | 63 | 0 | 45.16292781 | -121.1670954 | 2022-07-18 04:20:59 | Wasco, Oregon, US | |
2154300 | 2154300 | 2022-07-16 | US | Oregon | Wasco | 41065 | 5867 | 63 | 0 | 45.16292781 | -121.1670954 | 2022-07-17 04:21:15 | Wasco, Oregon, US | |
2421533 | 2421533 | 2022-07-15 | US | Oregon | Wasco | 41065 | 5867 | 63 | 0 | 45.16292781 | -121.1670954 | 2022-07-16 04:21:05 | Wasco, Oregon, US | |
2742884 | 2742884 | 2022-07-07 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-08 04:20:56 | Audrain, Missouri, US | |
1203196 | 1203196 | 2022-07-06 | US | Virginia | Page | 51139 | 5867 | 123 | 0 | 38.61807452 | -78.48797204 | 2022-07-07 04:20:55 | Page, Virginia, US | |
1201679 | 1201679 | 2022-07-06 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-07 04:20:55 | Audrain, Missouri, US | |
3968422 | 3968422 | 2022-07-05 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-06 04:20:58 | Audrain, Missouri, US | |
3079933 | 3079933 | 2022-07-04 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-05 04:20:45 | Audrain, Missouri, US | |
1769215 | 1769215 | 2022-07-03 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-04 04:20:54 | Audrain, Missouri, US | |
3367201 | 3367201 | 2022-07-02 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-03 04:20:59 | Audrain, Missouri, US | |
595530 | 595530 | 2022-07-01 | US | Missouri | Audrain | 29007 | 5867 | 114 | 0 | 39.215877 | -91.84242683 | 2022-07-02 04:21:16 | Audrain, Missouri, US | |
595224 | 595224 | 2022-07-01 | US | Maine | Sagadahoc | 23023 | 5867 | 35 | 0 | 43.95415864 | -69.85074999 | 2022-07-02 04:21:16 | Sagadahoc, Maine, US | |
2490481 | 2490481 | 2022-06-29 | US | Arkansas | Arkansas | 5001 | 5867 | 78 | 0 | 34.29145151 | -91.37277296 | 2022-06-30 04:21:01 | Arkansas, Arkansas, US | |
2150717 | 2150717 | 2022-06-27 | US | Texas | Dimmit | 48127 | 5867 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-06-28 04:20:58 | Dimmit, Texas, US | |
3727800 | 3727800 | 2022-06-07 | US | Maryland | Garrett | 24023 | 5867 | 115 | 0 | 39.52786077 | -79.27355126 | 2022-06-08 04:20:55 | Garrett, Maryland, US | |
1853401 | 1853401 | 2022-05-26 | US | Virginia | Scott | 51169 | 5867 | 111 | 0 | 36.71466456 | -82.60171704 | 2022-05-27 04:20:56 | Scott, Virginia, US | |
1186254 | 1186254 | 2022-05-18 | US | Louisiana | Grant | 22043 | 5867 | 94 | 0 | 31.59882456 | -92.56124347 | 2022-05-19 04:20:54 | Grant, Louisiana, US | |
3537176 | 3537176 | 2022-05-10 | US | Minnesota | Dodge | 27039 | 5867 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-05-11 04:20:48 | Dodge, Minnesota, US | |
2598766 | 2598766 | 2022-05-05 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-05-06 04:21:00 | Madison, Florida, US | |
3266215 | 3266215 | 2022-05-04 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-05-05 04:20:55 | Madison, Florida, US | |
1572854 | 1572854 | 2022-05-03 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-05-04 04:20:59 | Madison, Florida, US | |
464114 | 464114 | 2022-05-02 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-05-03 04:21:00 | Madison, Florida, US | |
3916753 | 3916753 | 2022-05-01 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-05-02 04:21:10 | Madison, Florida, US | |
2841557 | 2841557 | 2022-04-30 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-05-01 04:20:57 | Madison, Florida, US | |
1157870 | 1157870 | 2022-04-29 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-30 04:21:05 | Madison, Florida, US | |
1697052 | 1697052 | 2022-04-28 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-29 04:20:59 | Madison, Florida, US | |
3852535 | 3852535 | 2022-04-27 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-28 04:20:47 | Madison, Florida, US | |
1329173 | 1329173 | 2022-04-26 | US | Tennessee | Chester | 47023 | 5867 | 97 | 0 | 35.42527478 | -88.6095842 | 2022-04-27 04:20:52 | Chester, Tennessee, US | |
1327096 | 1327096 | 2022-04-26 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-27 04:20:52 | Monroe, Georgia, US | |
1326965 | 1326965 | 2022-04-26 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-27 04:20:52 | Madison, Florida, US | |
3725127 | 3725127 | 2022-04-25 | US | Tennessee | Chester | 47023 | 5867 | 97 | 0 | 35.42527478 | -88.6095842 | 2022-04-26 04:20:51 | Chester, Tennessee, US | |
3723050 | 3723050 | 2022-04-25 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-26 04:20:51 | Monroe, Georgia, US | |
3722919 | 3722919 | 2022-04-25 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-26 04:20:51 | Madison, Florida, US | |
2031695 | 2031695 | 2022-04-24 | US | Tennessee | Chester | 47023 | 5867 | 97 | 0 | 35.42527478 | -88.6095842 | 2022-04-25 04:20:56 | Chester, Tennessee, US | |
2029618 | 2029618 | 2022-04-24 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-25 04:20:56 | Monroe, Georgia, US | |
2029487 | 2029487 | 2022-04-24 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-25 04:20:56 | Madison, Florida, US | |
747193 | 747193 | 2022-04-23 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-24 04:20:56 | Monroe, Georgia, US | |
747062 | 747062 | 2022-04-23 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-24 04:20:56 | Madison, Florida, US | |
3437678 | 3437678 | 2022-04-22 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-23 04:20:50 | Monroe, Georgia, US | |
3437547 | 3437547 | 2022-04-22 | US | Florida | Madison | 12079 | 5867 | 97 | 0 | 30.44396917 | -83.47398594 | 2022-04-23 04:20:50 | Madison, Florida, US | |
2893263 | 2893263 | 2022-04-21 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-22 04:20:45 | Monroe, Georgia, US | |
2308135 | 2308135 | 2022-04-20 | US | Georgia | Monroe | 13207 | 5867 | 172 | 0 | 33.014289 | -83.92097166 | 2022-04-21 04:20:46 | Monroe, Georgia, US | |
2253589 | 2253589 | 2022-04-19 | US | New Hampshire | Unassigned | 90033 | 5867 | 2 | 0 | 44.69063265 | 0.0 | 2022-04-20 04:20:45 | Unassigned, New Hampshire, US | |
1848186 | 1848186 | 2022-04-18 | US | New Mexico | San Miguel | 35047 | 5867 | 56 | 0 | 35.48014807 | -104.8163562 | 2022-04-19 04:21:00 | San Miguel, New Mexico, US | |
160876 | 160876 | 2022-03-29 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-30 04:20:45 | Davison, South Dakota, US | |
1439447 | 1439447 | 2022-03-28 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-29 04:20:46 | Davison, South Dakota, US | |
879128 | 879128 | 2022-03-27 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-28 04:20:33 | Davison, South Dakota, US | |
2166411 | 2166411 | 2022-03-26 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-27 04:20:47 | Davison, South Dakota, US | |
1723347 | 1723347 | 2022-03-25 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-26 04:20:23 | Davison, South Dakota, US | |
1470964 | 1470964 | 2022-03-24 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-25 04:20:46 | Davison, South Dakota, US | |
3025138 | 3025138 | 2022-03-23 | US | South Dakota | Davison | 46035 | 5867 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-24 04:20:43 | Davison, South Dakota, US | |
3239127 | 3239127 | 2022-03-21 | US | Georgia | Emanuel | 13107 | 5867 | 157 | 0 | 32.59221302 | -82.30239915 | 2022-03-22 04:20:54 | Emanuel, Georgia, US | |
25200 | 25200 | 2022-03-20 | US | Georgia | Emanuel | 13107 | 5867 | 156 | 0 | 32.59221302 | -82.30239915 | 2022-03-21 04:20:50 | Emanuel, Georgia, US | |
1657210 | 1657210 | 2022-03-19 | US | Georgia | Emanuel | 13107 | 5867 | 156 | 0 | 32.59221302 | -82.30239915 | 2022-03-20 04:20:45 | Emanuel, Georgia, US | |
336736 | 336736 | 2022-03-18 | US | Georgia | Emanuel | 13107 | 5867 | 156 | 0 | 32.59221302 | -82.30239915 | 2022-03-19 04:20:47 | Emanuel, Georgia, US | |
953593 | 953593 | 2022-03-12 | US | Puerto Rico | Canovanas | 72029 | 5867 | 0 | 0 | 18.328802 | -65.887612 | 2022-03-13 04:20:49 | Canovanas, Puerto Rico, US | |
2143841 | 2143841 | 2022-03-09 | United Kingdom | Turks and Caicos Islands | 5867 | 36 | 0 | 21.69400000000001 | -71.7979 | 2022-03-10 04:20:48 | Turks and Caicos Islands, United Kingdom | |||
923352 | 923352 | 2022-03-08 | United Kingdom | Turks and Caicos Islands | 5867 | 36 | 0 | 21.69400000000001 | -71.7979 | 2022-03-09 04:20:59 | Turks and Caicos Islands, United Kingdom |
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]);