daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,836 rows where "day" is on date 2020-07-05 sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day, last_update
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-05 | Japan | Port Quarantine | 342 | 1 | 197 | 144 | 2020-07-06 04:33:57 | Port Quarantine, Japan | ||||
2020-07-05 | Colombia | Unknown | 148 | 0 | 0 | 148 | 2020-07-06 04:33:57 | Unknown, Colombia | ||||
2020-07-05 | Germany | Unknown | 1110 | 0 | 0 | 1110 | 2020-07-06 04:33:57 | Unknown, Germany | ||||
2020-07-05 | India | Unknown | 4913 | 0 | 0 | 4913 | 2020-07-06 04:33:57 | Unknown, India | ||||
2020-07-05 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-07-06 04:33:57 | Unknown, Japan | ||||
2020-07-05 | Peru | Unknown | 0 | 0 | 193957 | 0 | 2020-07-06 04:33:57 | Unknown, Peru | ||||
2020-07-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-06 04:33:57 | Unknown, Spain | ||||
2020-07-05 | Diamond Princess | 712 | 13 | 651 | 48 | 2020-07-06 04:33:57 | Diamond Princess | |||||
2020-07-05 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-07-06 04:33:57 | MS Zaandam | |||||
2020-07-05 | Chile | Unknown | 0 | 0 | 109 | 0 | 2020-07-03 15:33:50 | Unknown, Chile | ||||
2020-07-05 | China | Unknown | 3544 | 0 | 0 | 0 | 2020-07-06 04:33:57 | Unknown, China | ||||
2020-07-05 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-07-06 04:33:57 | Unknown, Malaysia | ||||
2020-07-05 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-07-06 04:33:57 | Unknown, Ukraine | ||||
2020-07-05 | Spain | C. Valenciana | 11630 | 1432 | 9970 | 228 | 39.484 | -0.7533 | 2020-07-06 04:33:57 | C. Valenciana, Spain | ||
2020-07-05 | Spain | Aragon | 6412 | 912 | 3772 | 1728 | 41.5976 | -0.9057 | 2020-07-06 04:33:57 | Aragon, Spain | ||
2020-07-05 | Ghana | 20085 | 122 | 14870 | 5093 | 7.9465 | -1.0232 | 2020-07-06 04:33:57 | Ghana | |||
2020-07-05 | Spain | Murcia | 1697 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-06 04:33:57 | Murcia, Spain | ||
2020-07-05 | United Kingdom | England | 245483 | 48862 | 0 | 205836 | 52.3555 | -1.1743 | 2020-07-06 04:33:57 | England, United Kingdom | ||
2020-07-05 | Burkina Faso | 987 | 53 | 854 | 80 | 12.2383 | -1.5616 | 2020-07-06 04:33:57 | Burkina Faso | |||
2020-07-05 | Spain | Navarra | 5477 | 528 | 3905 | 1044 | 42.6954 | -1.6761 | 2020-07-06 04:33:57 | Navarra, Spain | ||
2020-07-05 | Mauritania | 4879 | 130 | 1844 | 2905 | 21.0079 | -10.9408 | 2020-07-06 04:33:57 | Mauritania | |||
2020-07-05 | US | South Dakota | Walworth | 46129 | 15 | 0 | 0 | 15 | 45.43019636 | -100.0307514 | 2020-07-06 04:33:57 | Walworth, South Dakota, US |
2020-07-05 | US | South Dakota | Campbell | 46021 | 1 | 0 | 0 | 1 | 45.77074915 | -100.0510181 | 2020-07-06 04:33:57 | Campbell, South Dakota, US |
2020-07-05 | US | South Dakota | Sully | 46119 | 1 | 0 | 0 | 1 | 44.71571812 | -100.1278092 | 2020-07-06 04:33:57 | Sully, South Dakota, US |
2020-07-05 | US | Texas | Childress | 48075 | 8 | 0 | 0 | 7 | 34.529304100000004 | -100.2077916 | 2020-07-06 04:33:57 | Childress, Texas, US |
2020-07-05 | US | North Dakota | Emmons | 38029 | 4 | 1 | 0 | 3 | 46.28398398 | -100.2389766 | 2020-07-06 04:33:57 | Emmons, North Dakota, US |
2020-07-05 | US | Texas | Wheeler | 48483 | 13 | 0 | 0 | 19 | 35.40114335 | -100.2699514 | 2020-07-06 04:33:57 | Wheeler, Texas, US |
2020-07-05 | US | Texas | Collingsworth | 48087 | 4 | 0 | 0 | 6 | 34.96489496 | -100.2700111 | 2020-07-06 04:33:57 | Collingsworth, Texas, US |
2020-07-05 | US | Texas | Hemphill | 48211 | 10 | 0 | 0 | 15 | 35.83764858 | -100.2703577 | 2020-07-06 04:33:57 | Hemphill, Texas, US |
2020-07-05 | US | Texas | Lipscomb | 48295 | 12 | 0 | 0 | 11 | 36.27783108 | -100.2733151 | 2020-07-06 04:33:57 | Lipscomb, Texas, US |
2020-07-05 | US | Texas | Cottle | 48101 | 1 | 1 | 0 | 3 | 34.07783319 | -100.2785062 | 2020-07-06 04:33:57 | Cottle, Texas, US |
2020-07-05 | US | Texas | Edwards | 48137 | 1 | 0 | 0 | 2 | 29.98202582 | -100.304252 | 2020-07-06 04:33:57 | Edwards, Texas, US |
2020-07-05 | US | Texas | Maverick | 48323 | 340 | 5 | 0 | 514 | 28.7429195 | -100.3157686 | 2020-07-06 04:33:57 | Maverick, Texas, US |
2020-07-05 | US | North Dakota | Sheridan | 38083 | 1 | 0 | 0 | 1 | 47.57700669 | -100.3426391 | 2020-07-06 04:33:57 | Sheridan, North Dakota, US |
2020-07-05 | US | Kansas | Meade | 20119 | 30 | 0 | 0 | 30 | 37.23859987 | -100.364831 | 2020-07-06 04:33:57 | Meade, Kansas, US |
2020-07-05 | Mexico | Queretaro | 2170 | 325 | 1595 | 250 | 20.5888 | -100.3899 | 2020-07-06 04:33:57 | Queretaro, Mexico | ||
2020-07-05 | US | Nebraska | Frontier | 31063 | 1 | 0 | 0 | 1 | 40.52993007 | -100.3924658 | 2020-07-06 04:33:57 | Frontier, Nebraska, US |
2020-07-05 | US | Texas | Fisher | 48151 | 9 | 1 | 0 | 10 | 32.74281316 | -100.4019302 | 2020-07-06 04:33:57 | Fisher, Texas, US |
2020-07-05 | US | Texas | Nolan | 48353 | 47 | 0 | 0 | 45 | 32.30365282 | -100.4060208 | 2020-07-06 04:33:57 | Nolan, Texas, US |
2020-07-05 | US | Texas | Kinney | 48271 | 2 | 0 | 0 | 2 | 29.34967888 | -100.4186638 | 2020-07-06 04:33:57 | Kinney, Texas, US |
2020-07-05 | US | Kansas | Gray | 20069 | 31 | 0 | 0 | 31 | 37.73836671 | -100.4369088 | 2020-07-06 04:33:57 | Gray, Kansas, US |
2020-07-05 | US | Kansas | Sheridan | 20179 | 5 | 0 | 0 | 5 | 39.35018161 | -100.4418259 | 2020-07-06 04:33:57 | Sheridan, Kansas, US |
2020-07-05 | US | Texas | Tom Green | 48451 | 180 | 5 | 0 | 620 | 31.40464436 | -100.462443 | 2020-07-06 04:33:57 | Tom Green, Texas, US |
2020-07-05 | US | North Dakota | Burleigh | 38015 | 331 | 0 | 0 | 322 | 46.97847375 | -100.4645214 | 2020-07-06 04:33:57 | Burleigh, North Dakota, US |
2020-07-05 | US | Kansas | Lane | 20101 | 5 | 0 | 0 | 5 | 38.48119447 | -100.4660754 | 2020-07-06 04:33:57 | Lane, Kansas, US |
2020-07-05 | US | Oklahoma | Beaver | 40007 | 32 | 0 | 0 | 32 | 36.7496847 | -100.4758872 | 2020-07-06 04:33:57 | Beaver, Oklahoma, US |
2020-07-05 | US | Nebraska | Red Willow | 31145 | 8 | 0 | 0 | 8 | 40.17556879999999 | -100.476998 | 2020-07-06 04:33:57 | Red Willow, Nebraska, US |
2020-07-05 | US | Nebraska | Logan | 31113 | 0 | 0 | 0 | 0 | 41.56650314 | -100.4817851 | 2020-07-06 04:33:57 | Logan, Nebraska, US |
2020-07-05 | US | Kansas | Gove | 20063 | 2 | 0 | 0 | 2 | 38.91588178 | -100.4829321 | 2020-07-06 04:33:57 | Gove, Kansas, US |
2020-07-05 | US | Texas | Coke | 48081 | 4 | 1 | 0 | 4 | 31.88911733 | -100.5297533 | 2020-07-06 04:33:57 | Coke, Texas, US |
2020-07-05 | US | Texas | Sutton | 48435 | 10 | 0 | 0 | 11 | 30.49856623 | -100.5382014 | 2020-07-06 04:33:57 | Sutton, Texas, US |
2020-07-05 | US | Texas | Schleicher | 48413 | 19 | 0 | 0 | 21 | 30.89740592 | -100.5384842 | 2020-07-06 04:33:57 | Schleicher, Texas, US |
2020-07-05 | US | Nebraska | Thomas | 31171 | 1 | 0 | 0 | 1 | 41.91358968 | -100.5556632 | 2020-07-06 04:33:57 | Thomas, Nebraska, US |
2020-07-05 | US | North Dakota | McHenry | 38049 | 5 | 1 | 0 | 4 | 48.23104458 | -100.6324822 | 2020-07-06 04:33:57 | McHenry, North Dakota, US |
2020-07-05 | US | Texas | Hall | 48191 | 3 | 1 | 0 | 1 | 34.5307555 | -100.6813852 | 2020-07-06 04:33:57 | Hall, Texas, US |
2020-07-05 | US | South Dakota | Todd | 46121 | 57 | 1 | 0 | 56 | 43.19338568 | -100.7195503 | 2020-07-06 04:33:57 | Todd, South Dakota, US |
2020-07-05 | US | South Dakota | Stanley | 46117 | 14 | 0 | 0 | 14 | 44.41381872 | -100.7349153 | 2020-07-06 04:33:57 | Stanley, South Dakota, US |
2020-07-05 | US | Kansas | Finney | 20055 | 1575 | 10 | 0 | 1565 | 38.04340344 | -100.7381938 | 2020-07-06 04:33:57 | Finney, Kansas, US |
2020-07-05 | US | Nebraska | Lincoln | 31111 | 58 | 2 | 0 | 56 | 41.04658298 | -100.7475374 | 2020-07-06 04:33:57 | Lincoln, Nebraska, US |
2020-07-05 | US | South Dakota | Mellette | 46095 | 7 | 0 | 0 | 7 | 43.58078848 | -100.7563186 | 2020-07-06 04:33:57 | Mellette, South Dakota, US |
2020-07-05 | US | Texas | Dickens | 48125 | 2 | 0 | 0 | 2 | 33.61616822 | -100.7788855 | 2020-07-06 04:33:57 | Dickens, Texas, US |
2020-07-05 | US | Texas | Motley | 48345 | 0 | 0 | 0 | 1 | 34.07408766 | -100.779722 | 2020-07-06 04:33:57 | Motley, Texas, US |
2020-07-05 | US | Texas | Gray | 48179 | 90 | 4 | 0 | 117 | 35.40081878 | -100.8129222 | 2020-07-06 04:33:57 | Gray, Texas, US |
2020-07-05 | US | Texas | Roberts | 48393 | 2 | 0 | 0 | 4 | 35.83809685 | -100.813175 | 2020-07-06 04:33:57 | Roberts, Texas, US |
2020-07-05 | US | Texas | Donley | 48129 | 20 | 0 | 0 | 27 | 34.96517499 | -100.8140093 | 2020-07-06 04:33:57 | Donley, Texas, US |
2020-07-05 | US | Texas | Ochiltree | 48357 | 56 | 2 | 0 | 51 | 36.27829105 | -100.8158184 | 2020-07-06 04:33:57 | Ochiltree, Texas, US |
2020-07-05 | US | North Dakota | Bottineau | 38009 | 5 | 0 | 0 | 5 | 48.79106111 | -100.8378166 | 2020-07-06 04:33:57 | Bottineau, North Dakota, US |
2020-07-05 | US | Kansas | Seward | 20175 | 1033 | 2 | 0 | 1031 | 37.19324632 | -100.8507201 | 2020-07-06 04:33:57 | Seward, Kansas, US |
2020-07-05 | US | South Dakota | Dewey | 46041 | 8 | 0 | 0 | 8 | 45.15639647 | -100.8709139 | 2020-07-06 04:33:57 | Dewey, South Dakota, US |
2020-07-05 | US | Kansas | Haskell | 20081 | 28 | 0 | 0 | 28 | 37.5620394 | -100.8710738 | 2020-07-06 04:33:57 | Haskell, Kansas, US |
2020-07-05 | US | Kansas | Scott | 20171 | 16 | 0 | 0 | 16 | 38.48222076 | -100.9066539 | 2020-07-06 04:33:57 | Scott, Kansas, US |
2020-07-05 | US | Texas | Scurry | 48415 | 5 | 0 | 0 | 59 | 32.74613808 | -100.9162664 | 2020-07-06 04:33:57 | Scurry, Texas, US |
2020-07-05 | US | Texas | Mitchell | 48335 | 13 | 0 | 0 | 12 | 32.30623474 | -100.9212058 | 2020-07-06 04:33:57 | Mitchell, Texas, US |
2020-07-05 | US | Texas | Irion | 48235 | 3 | 0 | 0 | 2 | 31.30375559 | -100.982439 | 2020-07-06 04:33:57 | Irion, Texas, US |
2020-07-05 | Mexico | San Luis Potosi | 3641 | 180 | 2754 | 707 | 22.1565 | -100.9855 | 2020-07-06 04:33:57 | San Luis Potosi, Mexico | ||
2020-07-05 | US | Nebraska | Hitchcock | 31087 | 1 | 0 | 0 | 1 | 40.17609175 | -101.0416477 | 2020-07-06 04:33:57 | Hitchcock, Nebraska, US |
2020-07-05 | US | North Dakota | Sioux | 38085 | 24 | 0 | 0 | 25 | 46.11323337 | -101.0440149 | 2020-07-06 04:33:57 | Sioux, North Dakota, US |
2020-07-05 | US | Texas | Sterling | 48431 | 0 | 0 | 0 | 1 | 31.82781912 | -101.0500746 | 2020-07-06 04:33:57 | Sterling, Texas, US |
2020-07-05 | US | Kansas | Thomas | 20193 | 16 | 0 | 0 | 16 | 39.35107575 | -101.0553705 | 2020-07-06 04:33:57 | Thomas, Kansas, US |
2020-07-05 | US | Nebraska | McPherson | 31117 | 0 | 0 | 0 | 0 | 41.56797682 | -101.0599362 | 2020-07-06 04:33:57 | McPherson, Nebraska, US |
2020-07-05 | US | Nebraska | Hayes | 31085 | 0 | 0 | 0 | 0 | 40.52451972 | -101.0603568 | 2020-07-06 04:33:57 | Hayes, Nebraska, US |
2020-07-05 | US | Nebraska | Cherry | 31031 | 2 | 0 | 0 | 2 | 42.54502621 | -101.1244332 | 2020-07-06 04:33:57 | Cherry, Nebraska, US |
2020-07-05 | US | Nebraska | Hooker | 31091 | 1 | 0 | 0 | 1 | 41.91586243 | -101.1354293 | 2020-07-06 04:33:57 | Hooker, Nebraska, US |
2020-07-05 | US | Kansas | Logan | 20109 | 1 | 0 | 0 | 1 | 38.91735806 | -101.148475 | 2020-07-06 04:33:57 | Logan, Kansas, US |
2020-07-05 | US | Texas | Val Verde | 48465 | 74 | 0 | 0 | 285 | 29.89149232 | -101.1525205 | 2020-07-06 04:33:57 | Val Verde, Texas, US |
2020-07-05 | US | South Dakota | Corson | 46031 | 19 | 0 | 0 | 19 | 45.70889983 | -101.1970473 | 2020-07-06 04:33:57 | Corson, South Dakota, US |
2020-07-05 | US | Texas | Briscoe | 48045 | 3 | 0 | 0 | 7 | 34.53026962 | -101.2084947 | 2020-07-06 04:33:57 | Briscoe, Texas, US |
2020-07-05 | Mexico | Guanajuato | 9271 | 419 | 7013 | 1839 | 21.019 | -101.2574 | 2020-07-06 04:33:57 | Guanajuato, Mexico | ||
2020-07-05 | US | North Dakota | Morton | 38059 | 103 | 2 | 0 | 101 | 46.71681782 | -101.2822377 | 2020-07-06 04:33:57 | Morton, North Dakota, US |
2020-07-05 | US | Texas | Garza | 48169 | 13 | 0 | 0 | 12 | 33.17969345 | -101.2984114 | 2020-07-06 04:33:57 | Garza, Texas, US |
2020-07-05 | US | Texas | Crosby | 48107 | 21 | 1 | 0 | 25 | 33.61431553 | -101.3000364 | 2020-07-06 04:33:57 | Crosby, Texas, US |
2020-07-05 | US | Texas | Floyd | 48153 | 33 | 1 | 0 | 35 | 34.07227468 | -101.3031546 | 2020-07-06 04:33:57 | Floyd, Texas, US |
2020-07-05 | US | Kansas | Grant | 20067 | 53 | 1 | 0 | 52 | 37.56227336 | -101.3079758 | 2020-07-06 04:33:57 | Grant, Kansas, US |
2020-07-05 | US | Kansas | Stevens | 20189 | 32 | 0 | 0 | 32 | 37.1923008 | -101.3118967 | 2020-07-06 04:33:57 | Stevens, Kansas, US |
2020-07-05 | US | North Dakota | McLean | 38055 | 11 | 0 | 0 | 11 | 47.60766714 | -101.3182418 | 2020-07-06 04:33:57 | McLean, North Dakota, US |
2020-07-05 | US | Kansas | Kearny | 20093 | 48 | 1 | 0 | 47 | 38.00017981 | -101.321681 | 2020-07-06 04:33:57 | Kearny, Kansas, US |
2020-07-05 | US | North Dakota | Oliver | 38065 | 2 | 0 | 0 | 2 | 47.11530482 | -101.3406158 | 2020-07-06 04:33:57 | Oliver, North Dakota, US |
2020-07-05 | US | Texas | Carson | 48065 | 5 | 0 | 0 | 7 | 35.40365929 | -101.3542669 | 2020-07-06 04:33:57 | Carson, Texas, US |
2020-07-05 | US | Texas | Hansford | 48195 | 28 | 2 | 0 | 29 | 36.27743284 | -101.3545796 | 2020-07-06 04:33:57 | Hansford, Texas, US |
2020-07-05 | US | Texas | Hutchinson | 48233 | 77 | 0 | 0 | 70 | 35.84006574 | -101.3546643 | 2020-07-06 04:33:57 | Hutchinson, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;