daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,284,537 rows where country_or_region = "US" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 3,284,537 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | US | Puerto Rico | Loiza | 72087 | 1587 | 0 | 0 | 18.425688 | -65.89943000000001 | 2021-12-03 04:23:05 | Loiza, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Luquillo | 72089 | 1086 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2021-12-03 04:23:05 | Luquillo, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Manati | 72091 | 1898 | 0 | 0 | 18.420473 | -66.490461 | 2021-12-03 04:23:05 | Manati, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Maricao | 72093 | 135 | 0 | 0 | 18.171795 | -66.942126 | 2021-12-03 04:23:05 | Maricao, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Maunabo | 72095 | 457 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-03 04:23:05 | Maunabo, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Mayaguez | 72097 | 3441 | 0 | 0 | 18.2013 | -67.1452 | 2021-12-03 04:23:05 | Mayaguez, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Moca | 72099 | 2155 | 0 | 0 | 18.377805 | -67.080952 | 2021-12-03 04:23:05 | Moca, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Morovis | 72101 | 1726 | 0 | 0 | 18.316963 | -66.420383 | 2021-12-03 04:23:05 | Morovis, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Naguabo | 72103 | 1367 | 0 | 0 | 18.230636999999998 | -65.753897 | 2021-12-03 04:23:05 | Naguabo, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Naranjito | 72105 | 1936 | 0 | 0 | 18.288019 | -66.252703 | 2021-12-03 04:23:05 | Naranjito, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-03 04:23:05 | Orocovis, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Out of PR | 72888 | 434 | 0 | 0 | 18.459681 | -67.336525 | 2021-10-10 23:21:42 | Out of PR, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Patillas | 72109 | 420 | 0 | 0 | 18.03174 | -66.012242 | 2021-12-03 04:23:05 | Patillas, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Penuelas | 72111 | 701 | 0 | 0 | 18.059645 | -66.721572 | 2021-12-03 04:23:05 | Penuelas, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Ponce | 72113 | 5038 | 0 | 0 | 18.059498 | -66.613748 | 2021-12-03 04:23:05 | Ponce, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Quebradillas | 72115 | 1258 | 0 | 0 | 18.439692 | -66.926113 | 2021-12-03 04:23:05 | Quebradillas, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Rincon | 72117 | 805 | 0 | 0 | 18.335442999999998 | -67.23174 | 2021-12-03 04:23:05 | Rincon, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Rio Grande | 72119 | 2925 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-03 04:23:05 | Rio Grande, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Sabana Grande | 72121 | 630 | 0 | 0 | 18.08282 | -66.943758 | 2021-12-03 04:23:05 | Sabana Grande, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Salinas | 72123 | 996 | 0 | 0 | 18.010386999999994 | -66.256592 | 2021-12-03 04:23:05 | Salinas, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | San German | 72125 | 953 | 0 | 0 | 18.111484 | -67.03858100000001 | 2021-12-03 04:23:05 | San German, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | San Juan | 72127 | 25217 | 0 | 0 | 18.386933 | -66.061128 | 2021-12-03 04:23:05 | San Juan, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | San Lorenzo | 72129 | 2167 | 0 | 0 | 18.147987 | -65.976392 | 2021-12-03 04:23:05 | San Lorenzo, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | San Sebastian | 72131 | 1907 | 0 | 0 | 18.328646 | -66.971214 | 2021-12-03 04:23:05 | San Sebastian, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Santa Isabel | 72133 | 652 | 0 | 0 | 17.994525 | -66.388913 | 2021-12-03 04:23:05 | Santa Isabel, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Toa Alta | 72135 | 4975 | 0 | 0 | 18.362406 | -66.246616 | 2021-12-03 04:23:05 | Toa Alta, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Toa Baja | 72137 | 5204 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-12-03 04:23:05 | Toa Baja, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Trujillo Alto | 72139 | 3913 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-12-03 04:23:05 | Trujillo Alto, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Utuado | 72141 | 1200 | 0 | 0 | 18.271214 | -66.702984 | 2021-12-03 04:23:05 | Utuado, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Vega Alta | 72143 | 2426 | 0 | 0 | 18.409346 | -66.33725 | 2021-12-03 04:23:05 | Vega Alta, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Vega Baja | 72145 | 3987 | 0 | 0 | 18.428262 | -66.397924 | 2021-12-03 04:23:05 | Vega Baja, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Vieques | 72147 | 204 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-03 04:23:05 | Vieques, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Villalba | 72149 | 906 | 0 | 0 | 18.127951 | -66.473115 | 2021-12-03 04:23:05 | Villalba, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Yabucoa | 72151 | 1371 | 0 | 0 | 18.070399 | -65.896289 | 2021-12-03 04:23:05 | Yabucoa, Puerto Rico, US | |
2021-12-02 | US | Puerto Rico | Yauco | 72153 | 1068 | 0 | 0 | 18.080374 | -66.858814 | 2021-12-03 04:23:05 | Yauco, Puerto Rico, US | |
2021-12-02 | US | Recovered | 0 | 0 | 0 | 0.0 | 0.0 | 2021-12-03 04:23:05 | Recovered, US | |||
2021-12-02 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-12-03 04:23:05 | Unassigned, South Carolina, US | |
2021-12-02 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-12-03 04:23:05 | Unassigned, South Dakota, US | |
2021-12-02 | US | Texas | King | 48269 | 31 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-12-03 04:23:05 | King, Texas, US | |
2021-12-02 | US | Texas | Loving | 48301 | 9 | 0 | 0 | 31.84947612 | -103.5818571 | 2021-12-03 04:23:05 | Loving, Texas, US | |
2021-12-02 | US | Texas | Unassigned | 90048 | 13638 | 0 | 0 | 36.27829105 | -99.97616148 | 2021-12-03 04:23:05 | Unassigned, Texas, US | |
2021-12-02 | US | Vermont | Unassigned | 90050 | 57 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Vermont, US | |
2021-12-02 | US | Virginia | Unassigned | 90051 | 0 | 0 | 0 | 39.20172582 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Virginia, US | |
2021-12-02 | US | Washington | San Juan | 53055 | 435 | 0 | 0 | 48.60182783 | -122.96745 | 2021-12-03 04:23:05 | San Juan, Washington, US | |
2021-12-02 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-12-02 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Wisconsin, US | |
2021-12-02 | US | Wyoming | Unassigned | 90056 | 0 | 0 | 0 | 44.79048913 | -110.6563997 | 2021-12-03 04:23:05 | Unassigned, Wyoming, US | |
2021-10-28 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-10-28 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-10-28 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2021-10-29 04:22:03 | Bristol Bay, Alaska, US | |
2021-10-28 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 488 | 0 | 0 | 58.62403337 | -156.21405890000003 | 2021-10-29 04:22:03 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2021-10-28 | US | Alaska | Skagway | 2230 | 82 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-10-29 04:22:03 | Skagway, Alaska, US | |
2021-10-28 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2021-10-29 04:22:03 | Valdez-Cordova, Alaska, US | |
2021-10-28 | US | Alaska | Wrangell | 2275 | 154 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-10-29 04:22:03 | Wrangell, Alaska, US | |
2021-10-28 | US | American Samoa | 60 | 4 | 0 | 0 | -14.270999999999999 | -170.132 | 2021-10-29 04:22:03 | American Samoa, US | ||
2021-10-28 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-10-29 04:22:03 | Out of AZ, Arizona, US | |
2021-10-28 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Arizona, US | |
2021-10-28 | US | Arkansas | Unassigned | 90005 | 5130 | 0 | 0 | 36.38177105 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Arkansas, US | |
2021-10-28 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-10-29 04:22:03 | Alpine, California, US | |
2021-10-28 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-29 04:22:03 | Out of CA, California, US | |
2021-10-28 | US | California | Sierra | 6091 | 195 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-10-29 04:22:03 | Sierra, California, US | |
2021-10-28 | US | California | Unassigned | 90006 | 222 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-29 04:22:03 | Unassigned, California, US | |
2021-10-28 | US | Colorado | Hinsdale | 8053 | 60 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-29 04:22:03 | Hinsdale, Colorado, US | |
2021-10-28 | US | Colorado | Jackson | 8057 | 114 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-10-29 04:22:03 | Jackson, Colorado, US | |
2021-10-28 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-10-29 04:22:03 | Out of CO, Colorado, US | |
2021-10-28 | US | Colorado | San Juan | 8111 | 93 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-10-29 04:22:03 | San Juan, Colorado, US | |
2021-10-28 | US | Colorado | Unassigned | 90008 | 100 | 0 | 0 | 40.87595412 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Colorado, US | |
2021-10-28 | US | Delaware | Unassigned | 90010 | 418 | 0 | 0 | 39.57992638 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Delaware, US | |
2021-10-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2021-10-28 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Hawaii, US | |
2021-10-28 | US | Idaho | Clark | 16033 | 81 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2021-10-29 04:22:03 | Clark, Idaho, US | |
2021-10-28 | US | Idaho | Unassigned | 90016 | 2 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2021-10-29 04:22:03 | Unassigned, Idaho, US | |
2021-10-28 | US | Illinois | Out of IL | 80017 | 14 | 0 | 0 | 42.36542373 | 0.0 | 2021-10-29 04:22:03 | Out of IL, Illinois, US | |
2021-10-28 | US | Iowa | Unassigned | 90019 | 399 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Iowa, US | |
2021-10-28 | US | Kansas | Out of KS | 80020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-10-29 04:22:03 | Out of KS, Kansas, US | |
2021-10-28 | US | Kansas | Unassigned | 90020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-10-29 04:22:03 | Unassigned, Kansas, US | |
2021-10-28 | US | Kentucky | Unassigned | 90021 | 9 | 0 | 0 | 38.97065142 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Kentucky, US | |
2021-10-28 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-29 04:22:03 | Out of LA, Louisiana, US | |
2021-10-28 | US | Louisiana | Unassigned | 90022 | 578 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Louisiana, US | |
2021-10-28 | US | Maine | Out of ME | 80023 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-08-07 22:34:20 | Out of ME, Maine, US | |
2021-10-28 | US | Maine | Unassigned | 90023 | 3 | 0 | 0 | 46.65926321 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Maine, US | |
2021-10-28 | US | Michigan | Unassigned | 90026 | 43 | 0 | 0 | 47.63197653 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Michigan, US | |
2021-10-28 | US | Minnesota | Cook | 27031 | 247 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-10-29 04:22:03 | Cook, Minnesota, US | |
2021-10-28 | US | Mississippi | Unassigned | 90028 | 0 | 0 | 0 | 34.88084463 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Mississippi, US | |
2021-10-28 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Missouri, US | |
2021-10-28 | US | Montana | Unassigned | 90030 | 0 | 0 | 0 | 48.78420029 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Montana, US | |
2021-10-28 | US | Nebraska | Banner | 31007 | 58 | 0 | 0 | 41.54634427 | -103.7114332 | 2021-10-29 04:22:03 | Banner, Nebraska, US | |
2021-10-28 | US | Nebraska | Blaine | 31009 | 39 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-29 04:22:03 | Blaine, Nebraska, US | |
2021-10-28 | US | Nebraska | Harlan | 31083 | 275 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-10-29 04:22:03 | Harlan, Nebraska, US | |
2021-10-28 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-10-29 04:22:03 | Hayes, Nebraska, US | |
2021-10-28 | US | Nebraska | Keya Paha | 31103 | 70 | 0 | 0 | 42.87990694 | -99.71343729 | 2021-10-29 04:22:03 | Keya Paha, Nebraska, US | |
2021-10-28 | US | Nebraska | Logan | 31113 | 97 | 0 | 0 | 41.56650314 | -100.4817851 | 2021-10-29 04:22:03 | Logan, Nebraska, US | |
2021-10-28 | US | Nebraska | Loup | 31115 | 60 | 0 | 0 | 41.91371961 | -99.45440415 | 2021-10-29 04:22:03 | Loup, Nebraska, US | |
2021-10-28 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-29 04:22:03 | Sioux, Nebraska, US | |
2021-10-28 | US | Nebraska | Wheeler | 31183 | 74 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-10-29 04:22:03 | Wheeler, Nebraska, US | |
2021-10-28 | US | Nevada | Eureka | 32011 | 164 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-10-29 04:22:03 | Eureka, Nevada, US | |
2021-10-28 | US | Nevada | Unassigned | 90032 | 0 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
2021-10-28 | US | New Jersey | Unassigned | 90034 | 587 | 0 | 0 | 41.13891592 | 0.0 | 2021-10-29 04:22:03 | Unassigned, New Jersey, US | |
2021-10-28 | US | New Mexico | Unassigned | 90035 | 4970 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-29 04:22:03 | Unassigned, New Mexico, US | |
2021-10-28 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2021-10-29 04:22:03 | Unassigned, North Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;