johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
499778 | 499778 | 2022-04-02 | Micronesia | 1 | 0 | 0 | 7.4256 | 150.5508 | 2022-04-03 04:20:48 | Micronesia | ||||
499800 | 499800 | 2022-04-02 | Netherlands | Unknown | 20 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
499804 | 499804 | 2022-04-02 | New Zealand | Cook Islands | 2118 | 0 | 0 | -21.2367 | -159.7777 | 2022-04-03 04:20:48 | Cook Islands, New Zealand | |||
499975 | 499975 | 2022-04-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
499978 | 499978 | 2022-04-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-04-03 04:20:48 | Summer Olympics 2020 | ||||
500065 | 500065 | 2022-04-02 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
500077 | 500077 | 2022-04-02 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
500086 | 500086 | 2022-04-02 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2022-04-03 04:20:48 | Bristol Bay, Alaska, US | |
500106 | 500106 | 2022-04-02 | US | Alaska | Skagway | 2230 | 157 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2022-04-03 04:20:48 | Skagway, Alaska, US | |
500109 | 500109 | 2022-04-02 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2022-04-03 04:20:48 | Valdez-Cordova, Alaska, US | |
500124 | 500124 | 2022-04-02 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2022-04-03 04:20:48 | Out of AZ, Arizona, US | |
500128 | 500128 | 2022-04-02 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Arizona, US | |
500200 | 500200 | 2022-04-02 | US | Arkansas | Unassigned | 90005 | 26871 | 0 | 0 | 36.38177105 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Arkansas, US | |
500208 | 500208 | 2022-04-02 | US | California | Alpine | 6003 | 125 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2022-04-03 04:20:48 | Alpine, California, US | |
500237 | 500237 | 2022-04-02 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-04-03 04:20:48 | Out of CA, California, US | |
500294 | 500294 | 2022-04-02 | US | Colorado | Hinsdale | 8053 | 131 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-04-03 04:20:48 | Hinsdale, Colorado, US | |
500296 | 500296 | 2022-04-02 | US | Colorado | Jackson | 8057 | 166 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-04-03 04:20:48 | Jackson, Colorado, US | |
500314 | 500314 | 2022-04-02 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2022-04-03 04:20:48 | Out of CO, Colorado, US | |
500324 | 500324 | 2022-04-02 | US | Colorado | San Juan | 8111 | 202 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-04-03 04:20:48 | San Juan, Colorado, US | |
500329 | 500329 | 2022-04-02 | US | Colorado | Unassigned | 90008 | 139 | 0 | 0 | 40.87595412 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Colorado, US | |
500345 | 500345 | 2022-04-02 | US | Delaware | Unassigned | 90010 | 920 | 0 | 0 | 39.57992638 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Delaware, US | |
500346 | 500346 | 2022-04-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
500584 | 500584 | 2022-04-02 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Hawaii, US | |
500627 | 500627 | 2022-04-02 | US | Idaho | Unassigned | 90016 | 0 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2022-04-03 04:20:48 | Unassigned, Idaho, US | |
500701 | 500701 | 2022-04-02 | US | Illinois | Out of IL | 80017 | 9 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-03 04:20:48 | Out of IL, Illinois, US | |
500914 | 500914 | 2022-04-02 | US | Iowa | Unassigned | 90019 | 617 | 0 | 0 | 43.38107862 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Iowa, US | |
500999 | 500999 | 2022-04-02 | US | Kansas | Out of KS | 80020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2022-04-03 04:20:48 | Out of KS, Kansas, US | |
501026 | 501026 | 2022-04-02 | US | Kansas | Unassigned | 90020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2022-04-03 04:20:48 | Unassigned, Kansas, US | |
501192 | 501192 | 2022-04-02 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2022-04-03 04:20:48 | Out of LA, Louisiana, US | |
501211 | 501211 | 2022-04-02 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Louisiana, US | |
501229 | 501229 | 2022-04-02 | US | Maine | Out of ME | 80023 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-08-07 22:34:20 | Out of ME, Maine, US | |
501235 | 501235 | 2022-04-02 | US | Maine | Unassigned | 90023 | 11 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Maine, US | |
501360 | 501360 | 2022-04-02 | US | Michigan | Unassigned | 90026 | 17 | 0 | 0 | 47.63197653 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Michigan, US | |
501645 | 501645 | 2022-04-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Missouri, US | |
501705 | 501705 | 2022-04-02 | US | Montana | Unassigned | 90030 | 0 | 0 | 0 | 48.78420029 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Montana, US | |
501744 | 501744 | 2022-04-02 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-03 04:20:48 | Garden, Nebraska, US | |
501752 | 501752 | 2022-04-02 | US | Nebraska | Hayes | 31085 | 106 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-04-03 04:20:48 | Hayes, Nebraska, US | |
501761 | 501761 | 2022-04-02 | US | Nebraska | Keya Paha | 31103 | 119 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-04-03 04:20:48 | Keya Paha, Nebraska, US | |
501766 | 501766 | 2022-04-02 | US | Nebraska | Logan | 31113 | 148 | 0 | 0 | 41.56650314 | -100.4817851 | 2022-04-03 04:20:48 | Logan, Nebraska, US | |
501767 | 501767 | 2022-04-02 | US | Nebraska | Loup | 31115 | 87 | 0 | 0 | 41.91371961 | -99.45440415 | 2022-04-03 04:20:48 | Loup, Nebraska, US | |
501819 | 501819 | 2022-04-02 | US | Nevada | Unassigned | 90032 | 6357 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
501852 | 501852 | 2022-04-02 | US | New Jersey | Unassigned | 90034 | 3324 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-03 04:20:48 | Unassigned, New Jersey, US | |
501886 | 501886 | 2022-04-02 | US | New Mexico | Unassigned | 90035 | 6702 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-04-03 04:20:48 | Unassigned, New Mexico, US | |
502042 | 502042 | 2022-04-02 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2022-04-03 04:20:48 | Unassigned, North Carolina, US | |
502097 | 502097 | 2022-04-02 | US | North Dakota | Slope | 38087 | 63 | 0 | 0 | 46.44737738 | -103.4601547 | 2022-04-03 04:20:48 | Slope, North Dakota, US | |
502103 | 502103 | 2022-04-02 | US | North Dakota | Unassigned | 90038 | 0 | 0 | 0 | 48.814938700000006 | 0.0 | 2022-04-03 04:20:48 | Unassigned, North Dakota, US | |
502256 | 502256 | 2022-04-02 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-04-03 04:20:48 | Out of OK, Oklahoma, US | |
502307 | 502307 | 2022-04-02 | US | Oregon | Unassigned | 90041 | 0 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2022-04-03 04:20:48 | Unassigned, Oregon, US | |
502373 | 502373 | 2022-04-02 | US | Pennsylvania | Unassigned | 90042 | 0 | 0 | 0 | 41.99253829 | -80.34921611 | 2022-04-03 04:20:48 | Unassigned, Pennsylvania, US | |
502382 | 502382 | 2022-04-02 | US | Puerto Rico | Adjuntas | 72001 | 2130 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-04-03 04:20:48 | Adjuntas, Puerto Rico, US | |
502383 | 502383 | 2022-04-02 | US | Puerto Rico | Aguada | 72003 | 5932 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-04-03 04:20:48 | Aguada, Puerto Rico, US | |
502384 | 502384 | 2022-04-02 | US | Puerto Rico | Aguadilla | 72005 | 6678 | 0 | 0 | 18.459681 | -67.12081500000001 | 2022-04-03 04:20:48 | Aguadilla, Puerto Rico, US | |
502385 | 502385 | 2022-04-02 | US | Puerto Rico | Aguas Buenas | 72007 | 3737 | 0 | 0 | 18.251619 | -66.126806 | 2022-04-03 04:20:48 | Aguas Buenas, Puerto Rico, US | |
502386 | 502386 | 2022-04-02 | US | Puerto Rico | Aibonito | 72009 | 3379 | 0 | 0 | 18.131361 | -66.264131 | 2022-04-03 04:20:48 | Aibonito, Puerto Rico, US | |
502387 | 502387 | 2022-04-02 | US | Puerto Rico | Anasco | 72011 | 3313 | 0 | 0 | 18.287985 | -67.120611 | 2022-04-03 04:20:48 | Anasco, Puerto Rico, US | |
502388 | 502388 | 2022-04-02 | US | Puerto Rico | Arecibo | 72013 | 11810 | 0 | 0 | 18.406631 | -66.675077 | 2022-04-03 04:20:48 | Arecibo, Puerto Rico, US | |
502389 | 502389 | 2022-04-02 | US | Puerto Rico | Arroyo | 72015 | 1674 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-04-03 04:20:48 | Arroyo, Puerto Rico, US | |
502390 | 502390 | 2022-04-02 | US | Puerto Rico | Barceloneta | 72017 | 3031 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-04-03 04:20:48 | Barceloneta, Puerto Rico, US | |
502391 | 502391 | 2022-04-02 | US | Puerto Rico | Barranquitas | 72019 | 4260 | 0 | 0 | 18.201592 | -66.30963 | 2022-04-03 04:20:48 | Barranquitas, Puerto Rico, US | |
502392 | 502392 | 2022-04-02 | US | Puerto Rico | Bayamon | 72021 | 31048 | 0 | 0 | 18.34946 | -66.168435 | 2022-04-03 04:20:48 | Bayamon, Puerto Rico, US | |
502393 | 502393 | 2022-04-02 | US | Puerto Rico | Cabo Rojo | 72023 | 4648 | 0 | 0 | 18.040993 | -67.154391 | 2022-04-03 04:20:48 | Cabo Rojo, Puerto Rico, US | |
502394 | 502394 | 2022-04-02 | US | Puerto Rico | Caguas | 72025 | 20041 | 0 | 0 | 18.211615 | -66.050779 | 2022-04-03 04:20:48 | Caguas, Puerto Rico, US | |
502395 | 502395 | 2022-04-02 | US | Puerto Rico | Camuy | 72027 | 4464 | 0 | 0 | 18.418578 | -66.860206 | 2022-04-03 04:20:48 | Camuy, Puerto Rico, US | |
502396 | 502396 | 2022-04-02 | US | Puerto Rico | Canovanas | 72029 | 5929 | 0 | 0 | 18.328802 | -65.887612 | 2022-04-03 04:20:48 | Canovanas, Puerto Rico, US | |
502397 | 502397 | 2022-04-02 | US | Puerto Rico | Carolina | 72031 | 25742 | 0 | 0 | 18.374986 | -65.95683100000001 | 2022-04-03 04:20:48 | Carolina, Puerto Rico, US | |
502398 | 502398 | 2022-04-02 | US | Puerto Rico | Catano | 72033 | 3763 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-04-03 04:20:48 | Catano, Puerto Rico, US | |
502399 | 502399 | 2022-04-02 | US | Puerto Rico | Cayey | 72035 | 5363 | 0 | 0 | 18.102851 | -66.14914 | 2022-04-03 04:20:48 | Cayey, Puerto Rico, US | |
502400 | 502400 | 2022-04-02 | US | Puerto Rico | Ceiba | 72037 | 1231 | 0 | 0 | 18.251818 | -65.666416 | 2022-04-03 04:20:48 | Ceiba, Puerto Rico, US | |
502401 | 502401 | 2022-04-02 | US | Puerto Rico | Ciales | 72039 | 2351 | 0 | 0 | 18.28885 | -66.516475 | 2022-04-03 04:20:48 | Ciales, Puerto Rico, US | |
502402 | 502402 | 2022-04-02 | US | Puerto Rico | Cidra | 72041 | 5301 | 0 | 0 | 18.173559 | -66.161179 | 2022-04-03 04:20:48 | Cidra, Puerto Rico, US | |
502403 | 502403 | 2022-04-02 | US | Puerto Rico | Coamo | 72043 | 4153 | 0 | 0 | 18.097597 | -66.36014 | 2022-04-03 04:20:48 | Coamo, Puerto Rico, US | |
502404 | 502404 | 2022-04-02 | US | Puerto Rico | Comerio | 72045 | 2607 | 0 | 0 | 18.224687 | -66.221622 | 2022-04-03 04:20:48 | Comerio, Puerto Rico, US | |
502405 | 502405 | 2022-04-02 | US | Puerto Rico | Corozal | 72047 | 5542 | 0 | 0 | 18.304264 | -66.327738 | 2022-04-03 04:20:48 | Corozal, Puerto Rico, US | |
502406 | 502406 | 2022-04-02 | US | Puerto Rico | Culebra | 72049 | 157 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-03 04:20:48 | Culebra, Puerto Rico, US | |
502407 | 502407 | 2022-04-02 | US | Puerto Rico | Dorado | 72051 | 5987 | 0 | 0 | 18.436115 | -66.278669 | 2022-04-03 04:20:48 | Dorado, Puerto Rico, US | |
502408 | 502408 | 2022-04-02 | US | Puerto Rico | Fajardo | 72053 | 4043 | 0 | 0 | 18.318373 | -65.666866 | 2022-04-03 04:20:48 | Fajardo, Puerto Rico, US | |
502409 | 502409 | 2022-04-02 | US | Puerto Rico | Florida | 72054 | 2128 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-03 04:20:48 | Florida, Puerto Rico, US | |
502410 | 502410 | 2022-04-02 | US | Puerto Rico | Guanica | 72055 | 1345 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-04-03 04:20:48 | Guanica, Puerto Rico, US | |
502411 | 502411 | 2022-04-02 | US | Puerto Rico | Guayama | 72057 | 4309 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-04-03 04:20:48 | Guayama, Puerto Rico, US | |
502412 | 502412 | 2022-04-02 | US | Puerto Rico | Guayanilla | 72059 | 1857 | 0 | 0 | 18.039942 | -66.79186 | 2022-04-03 04:20:48 | Guayanilla, Puerto Rico, US | |
502413 | 502413 | 2022-04-02 | US | Puerto Rico | Guaynabo | 72061 | 14098 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2022-04-03 04:20:48 | Guaynabo, Puerto Rico, US | |
502414 | 502414 | 2022-04-02 | US | Puerto Rico | Gurabo | 72063 | 6785 | 0 | 0 | 18.266461 | -65.97970500000001 | 2022-04-03 04:20:48 | Gurabo, Puerto Rico, US | |
502415 | 502415 | 2022-04-02 | US | Puerto Rico | Hatillo | 72065 | 4866 | 0 | 0 | 18.410928 | -66.79632600000001 | 2022-04-03 04:20:48 | Hatillo, Puerto Rico, US | |
502416 | 502416 | 2022-04-02 | US | Puerto Rico | Hormigueros | 72067 | 1721 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-03 04:20:48 | Hormigueros, Puerto Rico, US | |
502417 | 502417 | 2022-04-02 | US | Puerto Rico | Humacao | 72069 | 7064 | 0 | 0 | 18.145211 | -65.810174 | 2022-04-03 04:20:48 | Humacao, Puerto Rico, US | |
502418 | 502418 | 2022-04-02 | US | Puerto Rico | Isabela | 72071 | 6269 | 0 | 0 | 18.44981 | -67.005093 | 2022-04-03 04:20:48 | Isabela, Puerto Rico, US | |
502419 | 502419 | 2022-04-02 | US | Puerto Rico | Jayuya | 72073 | 1883 | 0 | 0 | 18.211446 | -66.58878 | 2022-04-03 04:20:48 | Jayuya, Puerto Rico, US | |
502420 | 502420 | 2022-04-02 | US | Puerto Rico | Juana Diaz | 72075 | 5512 | 0 | 0 | 18.050764 | -66.49458100000001 | 2022-04-03 04:20:48 | Juana Diaz, Puerto Rico, US | |
502421 | 502421 | 2022-04-02 | US | Puerto Rico | Juncos | 72077 | 5771 | 0 | 0 | 18.223793 | -65.909109 | 2022-04-03 04:20:48 | Juncos, Puerto Rico, US | |
502422 | 502422 | 2022-04-02 | US | Puerto Rico | Lajas | 72079 | 2290 | 0 | 0 | 18.011661 | -67.040585 | 2022-04-03 04:20:48 | Lajas, Puerto Rico, US | |
502423 | 502423 | 2022-04-02 | US | Puerto Rico | Lares | 72081 | 3335 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-04-03 04:20:48 | Lares, Puerto Rico, US | |
502424 | 502424 | 2022-04-02 | US | Puerto Rico | Las Marias | 72083 | 1008 | 0 | 0 | 18.23679 | -66.98362 | 2022-04-03 04:20:48 | Las Marias, Puerto Rico, US | |
502425 | 502425 | 2022-04-02 | US | Puerto Rico | Las Piedras | 72085 | 4875 | 0 | 0 | 18.187527 | -65.86946800000001 | 2022-04-03 04:20:48 | Las Piedras, Puerto Rico, US | |
502426 | 502426 | 2022-04-02 | US | Puerto Rico | Loiza | 72087 | 2984 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-04-03 04:20:48 | Loiza, Puerto Rico, US | |
502427 | 502427 | 2022-04-02 | US | Puerto Rico | Luquillo | 72089 | 2295 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-04-03 04:20:48 | Luquillo, Puerto Rico, US | |
502428 | 502428 | 2022-04-02 | US | Puerto Rico | Manati | 72091 | 5415 | 0 | 0 | 18.420473 | -66.490461 | 2022-04-03 04:20:48 | Manati, Puerto Rico, US | |
502429 | 502429 | 2022-04-02 | US | Puerto Rico | Maricao | 72093 | 503 | 0 | 0 | 18.171795 | -66.942126 | 2022-04-03 04:20:48 | Maricao, Puerto Rico, US | |
502430 | 502430 | 2022-04-02 | US | Puerto Rico | Maunabo | 72095 | 1249 | 0 | 0 | 18.017889 | -65.922235 | 2022-04-03 04:20:48 | Maunabo, Puerto Rico, US | |
502431 | 502431 | 2022-04-02 | US | Puerto Rico | Mayaguez | 72097 | 9020 | 0 | 0 | 18.2013 | -67.1452 | 2022-04-03 04:20:48 | Mayaguez, Puerto Rico, US | |
502432 | 502432 | 2022-04-02 | US | Puerto Rico | Moca | 72099 | 5545 | 0 | 0 | 18.377805 | -67.080952 | 2022-04-03 04:20:48 | Moca, Puerto Rico, 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]);