johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
230 rows where confirmed = 2952 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755956 | 2755956 | 2022-12-29 | US | Texas | Childress | 48075 | 2952 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-30 04:21:04 | Childress, Texas, US | |
2753422 | 2753422 | 2022-12-29 | US | Arkansas | Perry | 5105 | 2952 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-30 04:21:04 | Perry, Arkansas, US | |
1076962 | 1076962 | 2022-12-28 | US | Texas | Childress | 48075 | 2952 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-29 04:21:01 | Childress, Texas, US | |
1074428 | 1074428 | 2022-12-28 | US | Arkansas | Perry | 5105 | 2952 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-29 04:21:01 | Perry, Arkansas, US | |
328797 | 328797 | 2022-12-27 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-28 04:21:04 | Towns, Georgia, US | |
218870 | 218870 | 2022-12-26 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-27 04:21:07 | Towns, Georgia, US | |
3223327 | 3223327 | 2022-12-25 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-26 04:21:06 | Towns, Georgia, US | |
1019241 | 1019241 | 2022-12-24 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-25 04:21:04 | Towns, Georgia, US | |
691264 | 691264 | 2022-12-23 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-24 04:21:02 | Towns, Georgia, US | |
2180474 | 2180474 | 2022-12-22 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-23 04:21:04 | Towns, Georgia, US | |
452278 | 452278 | 2022-12-21 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-22 04:20:56 | Towns, Georgia, US | |
3462897 | 3462897 | 2022-11-21 | US | Puerto Rico | Ceiba | 72037 | 2952 | 0 | 0 | 18.251818 | -65.666416 | 2022-11-22 04:20:47 | Ceiba, Puerto Rico, US | |
1643082 | 1643082 | 2022-11-20 | US | Puerto Rico | Ceiba | 72037 | 2952 | 0 | 0 | 18.251818 | -65.666416 | 2022-11-21 04:21:05 | Ceiba, Puerto Rico, US | |
314860 | 314860 | 2022-11-13 | US | Tennessee | Houston | 47083 | 2952 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-11-14 04:21:09 | Houston, Tennessee, US | |
66021 | 66021 | 2022-11-12 | US | Tennessee | Houston | 47083 | 2952 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-11-13 04:21:14 | Houston, Tennessee, US | |
2930183 | 2930183 | 2022-11-11 | US | Tennessee | Houston | 47083 | 2952 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-11-12 04:20:41 | Houston, Tennessee, US | |
2509019 | 2509019 | 2022-11-10 | US | Tennessee | Houston | 47083 | 2952 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-11-11 04:21:22 | Houston, Tennessee, US | |
1592883 | 1592883 | 2022-10-21 | US | Connecticut | Unassigned | 90009 | 2952 | 8 | 0 | 41.85853803 | 0.0 | 2022-10-22 04:22:53 | Unassigned, Connecticut, US | |
2757595 | 2757595 | 2022-10-18 | US | Connecticut | Unassigned | 90009 | 2952 | 8 | 0 | 41.85853803 | 0.0 | 2022-10-19 04:22:26 | Unassigned, Connecticut, US | |
2968060 | 2968060 | 2022-10-10 | US | Colorado | Prowers | 8099 | 2952 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-10-11 04:23:05 | Prowers, Colorado, US | |
3748139 | 3748139 | 2022-09-07 | US | Texas | Blanco | 48031 | 2952 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-09-08 04:21:02 | Blanco, Texas, US | |
2346169 | 2346169 | 2022-08-31 | US | Puerto Rico | Guanica | 72055 | 2952 | 0 | 0 | 17.982429 | -66.919643 | 2022-09-01 04:21:03 | Guanica, Puerto Rico, US | |
1534342 | 1534342 | 2022-08-26 | US | North Dakota | McLean | 38055 | 2952 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-08-27 04:20:57 | McLean, North Dakota, US | |
633275 | 633275 | 2022-07-12 | US | Virginia | Lexington | 51678 | 2952 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-07-13 04:20:58 | Lexington, Virginia, US | |
1203174 | 1203174 | 2022-07-06 | US | Virginia | Lexington | 51678 | 2952 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-07-07 04:20:55 | Lexington, Virginia, US | |
476893 | 476893 | 2022-06-26 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-27 04:21:00 | Metcalfe, Kentucky, US | |
940268 | 940268 | 2022-06-25 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-26 04:21:02 | Metcalfe, Kentucky, US | |
3348088 | 3348088 | 2022-06-24 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-25 04:20:57 | Metcalfe, Kentucky, US | |
1649829 | 1649829 | 2022-06-23 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-24 04:20:58 | Metcalfe, Kentucky, US | |
2189064 | 2189064 | 2022-06-22 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-23 04:20:55 | Metcalfe, Kentucky, US | |
167495 | 167495 | 2022-06-21 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-22 04:20:54 | Metcalfe, Kentucky, US | |
1764778 | 1764778 | 2022-06-20 | US | Kentucky | Metcalfe | 21169 | 2952 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-21 04:20:56 | Metcalfe, Kentucky, US | |
950216 | 950216 | 2022-06-14 | US | Virginia | Lexington | 51678 | 2952 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-06-15 04:20:54 | Lexington, Virginia, US | |
1422836 | 1422836 | 2022-06-08 | US | Minnesota | Koochiching | 27071 | 2952 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-06-09 04:20:54 | Koochiching, Minnesota, US | |
3510430 | 3510430 | 2022-06-05 | US | Texas | Callahan | 48059 | 2952 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-06-06 04:20:57 | Callahan, Texas, US | |
3186645 | 3186645 | 2022-05-30 | US | Colorado | Rio Grande | 8105 | 2952 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-05-31 04:20:51 | Rio Grande, Colorado, US | |
3198794 | 3198794 | 2022-05-29 | US | Colorado | Rio Grande | 8105 | 2952 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-05-30 04:20:50 | Rio Grande, Colorado, US | |
3268233 | 3268233 | 2022-05-04 | US | Puerto Rico | Comerio | 72045 | 2952 | 0 | 0 | 18.224687 | -66.221622 | 2022-05-05 04:20:55 | Comerio, Puerto Rico, US | |
3915828 | 3915828 | 2022-05-01 | China | Heilongjiang | 2952 | 13 | 0 | 47.862 | 127.7615 | 2022-05-02 04:21:10 | Heilongjiang, China | |||
746991 | 746991 | 2022-04-23 | US | Colorado | Park | 8093 | 2952 | 20 | 0 | 39.120926000000004 | -105.7182065 | 2022-04-24 04:20:56 | Park, Colorado, US | |
1951146 | 1951146 | 2022-04-12 | US | Oregon | Morrow | 41049 | 2952 | 33 | 0 | 45.41846568 | -119.584546 | 2022-04-13 04:21:03 | Morrow, Oregon, US | |
1950210 | 1950210 | 2022-04-12 | US | Minnesota | Aitkin | 27001 | 2952 | 61 | 0 | 46.60962049 | -93.41168259999999 | 2022-04-13 04:21:03 | Aitkin, Minnesota, US | |
3208899 | 3208899 | 2022-04-11 | US | Oregon | Morrow | 41049 | 2952 | 33 | 0 | 45.41846568 | -119.584546 | 2022-04-12 04:20:49 | Morrow, Oregon, US | |
1578785 | 1578785 | 2022-04-10 | US | Oregon | Morrow | 41049 | 2952 | 33 | 0 | 45.41846568 | -119.584546 | 2022-04-11 04:21:02 | Morrow, Oregon, US | |
1655027 | 1655027 | 2022-04-09 | US | Oregon | Morrow | 41049 | 2952 | 33 | 0 | 45.41846568 | -119.584546 | 2022-04-10 04:20:52 | Morrow, Oregon, US | |
2118349 | 2118349 | 2022-04-08 | US | Oregon | Morrow | 41049 | 2952 | 33 | 0 | 45.41846568 | -119.584546 | 2022-04-09 04:20:42 | Morrow, Oregon, US | |
1723260 | 1723260 | 2022-03-25 | US | Puerto Rico | Salinas | 72123 | 2952 | 0 | 0 | 18.010386999999994 | -66.256592 | 2022-03-26 04:20:23 | Salinas, Puerto Rico, US | |
3023838 | 3023838 | 2022-03-23 | US | Maine | Piscataquis | 23021 | 2952 | 31 | 0 | 45.83839062 | -69.2860223 | 2022-03-24 04:20:43 | Piscataquis, Maine, US | |
920860 | 920860 | 2022-03-08 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-09 04:20:59 | Cherokee, Iowa, US | |
1550878 | 1550878 | 2022-03-07 | US | South Dakota | Todd | 46121 | 2952 | 49 | 0 | 43.19338568 | -100.71955030000001 | 2022-03-08 04:20:54 | Todd, South Dakota, US | |
1549147 | 1549147 | 2022-03-07 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-08 04:20:54 | Cherokee, Iowa, US | |
2202547 | 2202547 | 2022-03-06 | US | South Dakota | Todd | 46121 | 2952 | 49 | 0 | 43.19338568 | -100.71955030000001 | 2022-03-07 04:20:47 | Todd, South Dakota, US | |
2200816 | 2200816 | 2022-03-06 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-07 04:20:47 | Cherokee, Iowa, US | |
2095004 | 2095004 | 2022-03-05 | US | South Dakota | Todd | 46121 | 2952 | 49 | 0 | 43.19338568 | -100.71955030000001 | 2022-03-06 04:20:49 | Todd, South Dakota, US | |
2093273 | 2093273 | 2022-03-05 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-06 04:20:49 | Cherokee, Iowa, US | |
2668704 | 2668704 | 2022-03-04 | US | South Dakota | Todd | 46121 | 2952 | 49 | 0 | 43.19338568 | -100.71955030000001 | 2022-03-05 04:21:10 | Todd, South Dakota, US | |
2666973 | 2666973 | 2022-03-04 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-05 04:21:10 | Cherokee, Iowa, US | |
1645538 | 1645538 | 2022-03-03 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-04 04:21:09 | Cherokee, Iowa, US | |
2526541 | 2526541 | 2022-03-02 | US | Iowa | Cherokee | 19035 | 2952 | 60 | 0 | 42.73538914 | -95.62389402 | 2022-03-03 04:21:01 | Cherokee, Iowa, US | |
1298520 | 1298520 | 2022-02-17 | US | Arkansas | Bradley | 5011 | 2952 | 44 | 0 | 33.46755808 | -92.15980837 | 2022-02-18 04:21:04 | Bradley, Arkansas, US | |
2643461 | 2643461 | 2022-02-14 | US | Minnesota | Chippewa | 27023 | 2952 | 46 | 0 | 45.02343421 | -95.56403693 | 2022-02-15 04:21:09 | Chippewa, Minnesota, US | |
1782914 | 1782914 | 2022-01-27 | US | Wisconsin | Ashland | 55003 | 2952 | 29 | 0 | 46.31956891 | -90.67837132 | 2022-01-28 04:21:09 | Ashland, Wisconsin, US | |
3226335 | 3226335 | 2022-01-19 | France | Saint Barthelemy | 2952 | 6 | 0 | 17.9 | -62.8333 | 2022-01-20 04:21:07 | Saint Barthelemy, France | |||
3464060 | 3464060 | 2022-01-18 | France | Saint Barthelemy | 2952 | 6 | 0 | 17.9 | -62.8333 | 2022-01-19 04:21:23 | Saint Barthelemy, France | |||
1471999 | 1471999 | 2022-01-17 | France | Saint Barthelemy | 2952 | 6 | 0 | 17.9 | -62.8333 | 2022-01-18 04:21:04 | Saint Barthelemy, France | |||
3843531 | 3843531 | 2022-01-15 | US | Texas | Bandera | 48019 | 2952 | 65 | 0 | 29.74619598 | -99.24598147 | 2022-01-16 04:21:12 | Bandera, Texas, US | |
3688961 | 3688961 | 2022-01-13 | US | Kentucky | Washington | 21229 | 2952 | 53 | 0 | 37.75599461 | -85.17407732 | 2022-01-14 04:21:54 | Washington, Kentucky, US | |
1694288 | 1694288 | 2022-01-10 | US | Missouri | Ste. Genevieve | 29186 | 2952 | 35 | 0 | 37.89090059 | -90.1949941 | 2022-01-11 04:22:01 | Ste. Genevieve, Missouri, US | |
1256160 | 1256160 | 2021-12-20 | US | Kentucky | Casey | 21045 | 2952 | 61 | 0 | 37.32533118 | -84.92726209 | 2021-12-21 03:21:27 | Casey, Kentucky, US | |
2401591 | 2401591 | 2021-12-17 | US | Puerto Rico | Rio Grande | 72119 | 2952 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-18 02:22:20 | Rio Grande, Puerto Rico, US | |
1718293 | 1718293 | 2021-12-16 | US | Missouri | Morgan | 29141 | 2952 | 75 | 0 | 38.4181765 | -92.88791859 | 2021-12-17 04:22:14 | Morgan, Missouri, US | |
2089390 | 2089390 | 2021-12-14 | US | Kentucky | Henry | 21103 | 2952 | 36 | 0 | 38.44942688 | -85.11587507 | 2021-12-15 03:22:16 | Henry, Kentucky, US | |
553718 | 553718 | 2021-12-08 | US | Tennessee | Grundy | 47061 | 2952 | 44 | 0 | 35.38433717 | -85.72142731 | 2021-12-09 04:22:49 | Grundy, Tennessee, US | |
1031464 | 1031464 | 2021-12-06 | US | Indiana | Franklin | 18047 | 2952 | 44 | 0 | 39.4142482 | -85.06062647 | 2021-12-07 04:22:34 | Franklin, Indiana, US | |
3402765 | 3402765 | 2021-11-30 | US | Kansas | Neosho | 20133 | 2952 | 53 | 0 | 37.55862897 | -95.30670046 | 2021-12-01 04:22:29 | Neosho, Kansas, US | |
151308 | 151308 | 2021-11-29 | US | Kansas | Neosho | 20133 | 2952 | 53 | 0 | 37.55862897 | -95.30670046 | 2021-11-30 04:22:53 | Neosho, Kansas, US | |
3072239 | 3072239 | 2021-11-23 | US | New Mexico | San Miguel | 35047 | 2952 | 29 | 0 | 35.48014807 | -104.8163562 | 2021-11-24 04:22:14 | San Miguel, New Mexico, US | |
1015328 | 1015328 | 2021-11-21 | US | Illinois | Hancock | 17067 | 2952 | 35 | 0 | 40.40423981 | -91.16313899 | 2021-11-22 04:22:20 | Hancock, Illinois, US | |
723492 | 723492 | 2021-11-20 | US | Illinois | Hancock | 17067 | 2952 | 35 | 0 | 40.40423981 | -91.16313899 | 2021-11-21 04:22:13 | Hancock, Illinois, US | |
163022 | 163022 | 2021-11-19 | US | Illinois | Hancock | 17067 | 2952 | 35 | 0 | 40.40423981 | -91.16313899 | 2021-11-20 04:22:17 | Hancock, Illinois, US | |
279679 | 279679 | 2021-11-03 | US | West Virginia | McDowell | 54047 | 2952 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-11-04 04:22:20 | McDowell, West Virginia, US | |
279446 | 279446 | 2021-11-03 | US | Texas | Young | 48503 | 2952 | 68 | 0 | 33.17659707 | -98.68790885 | 2021-11-04 04:22:20 | Young, Texas, US | |
3512230 | 3512230 | 2021-11-01 | US | Georgia | Jeff Davis | 13161 | 2952 | 59 | 0 | 31.80405727 | -82.63724870000001 | 2021-11-02 04:22:03 | Jeff Davis, Georgia, US | |
2721491 | 2721491 | 2021-10-30 | US | Arkansas | Hempstead | 5057 | 2952 | 39 | 0 | 33.73325583 | -93.66935133 | 2021-10-31 04:22:08 | Hempstead, Arkansas, US | |
1910133 | 1910133 | 2021-10-17 | US | Idaho | Blaine | 16013 | 2952 | 23 | 0 | 43.4085812 | -113.9752658 | 2021-10-18 04:21:10 | Blaine, Idaho, US | |
2944936 | 2944936 | 2021-10-15 | US | Maryland | Garrett | 24023 | 2952 | 77 | 0 | 39.52786077 | -79.27355126 | 2021-10-16 04:21:15 | Garrett, Maryland, US | |
1493393 | 1493393 | 2021-10-12 | US | Mississippi | Chickasaw | 28017 | 2952 | 67 | 0 | 33.91983202 | -88.9481545 | 2021-10-13 04:20:51 | Chickasaw, Mississippi, US | |
3835814 | 3835814 | 2021-10-05 | US | Virginia | Dinwiddie | 51053 | 2952 | 51 | 0 | 37.07544585 | -77.63451754 | 2021-10-06 04:21:33 | Dinwiddie, Virginia, US | |
2774923 | 2774923 | 2021-09-30 | US | Missouri | Perry | 29157 | 2952 | 32 | 0 | 37.70660776 | -89.82741088 | 2021-10-01 04:21:35 | Perry, Missouri, US | |
1334818 | 1334818 | 2021-09-28 | US | California | Colusa | 6011 | 2952 | 18 | 0 | 39.17881957 | -122.2331726 | 2021-09-29 04:21:45 | Colusa, California, US | |
1921668 | 1921668 | 2021-09-24 | US | Arizona | La Paz | 4012 | 2952 | 86 | 0 | 33.72854224 | -113.98100290000001 | 2021-09-25 04:21:31 | La Paz, Arizona, US | |
604512 | 604512 | 2021-09-23 | US | South Carolina | Hampton | 45049 | 2952 | 67 | 0 | 32.77419582 | -81.13845571 | 2021-09-24 04:21:44 | Hampton, South Carolina, US | |
603484 | 603484 | 2021-09-23 | US | Mississippi | Clay | 28025 | 2952 | 73 | 0 | 33.65358105 | -88.77784255 | 2021-09-24 04:21:44 | Clay, Mississippi, US | |
3757478 | 3757478 | 2021-09-21 | Japan | Fukui | 2952 | 36 | 0 | 35.846614 | 136.22465400000002 | 2021-09-22 04:21:45 | Fukui, Japan | |||
812049 | 812049 | 2021-09-20 | US | Ohio | Hocking | 39073 | 2952 | 73 | 0 | 39.49537927 | -82.47991446 | 2021-09-21 04:21:26 | Hocking, Ohio, US | |
1386275 | 1386275 | 2021-09-13 | US | Colorado | Pitkin | 8097 | 2952 | 5 | 0 | 39.21720112 | -106.9310027 | 2021-09-14 04:21:41 | Pitkin, Colorado, US | |
1386104 | 1386104 | 2021-09-13 | US | Arkansas | Conway | 5029 | 2952 | 41 | 0 | 35.26205537 | -92.70506566 | 2021-09-14 04:21:41 | Conway, Arkansas, US | |
1887517 | 1887517 | 2021-09-12 | US | Ohio | Van Wert | 39161 | 2952 | 72 | 0 | 40.8554138 | -84.59111700000003 | 2021-09-13 04:21:15 | Van Wert, Ohio, US | |
1263137 | 1263137 | 2021-09-09 | US | Alabama | Butler | 1013 | 2952 | 76 | 0 | 31.75300095 | -86.68057478 | 2021-09-10 04:21:20 | Butler, Alabama, US | |
2281478 | 2281478 | 2021-09-08 | US | North Carolina | Greene | 37079 | 2952 | 50 | 0 | 35.48544173 | -77.67578087 | 2021-09-09 04:21:27 | Greene, North Carolina, 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]);