Voit lisätä twiitteihisi sijainnin, esimerkiksi kaupungin tai tarkemman paikan, verkosta ja kolmannen osapuolen sovellusten kautta. Halutessasi voit poistaa twiittisi sijaintihistorian myöhemmin. Lue lisää
In the UK the number of cases rose rapidly. But the public – and authorities – are only learning this now because these cases were only published now as a backlog. The reason was apparently that the database is managed in Excel and the number of columns had reached the maximum.pic.twitter.com/X4a8keSEHK
Here is the article https://www.dailymail.co.uk/news/article-8805697/Furious-blame-game-16-000-Covid-cases-missed-Excel-glitch.html … Glad that they are apparently now working on a solution. Not one, but several Excel spreadsheets…pic.twitter.com/byfG35zMIG
It is now also the main headline at the BBC: https://www.bbc.co.uk/news/uk-54412581 … At the end of last week confirmed cases were "actually nearer 11,000" – about 4,000 more than reported. This is very, very bad and also means that the outbreak is much more rapid than thought.pic.twitter.com/JzGSJ3GgGy
Poorly managed is not just a huge problem in the COVID-19 pandemic – and helping to improve this situation is one of our main motivations to build http://OurWorldInData.org https://twitter.com/MaxCRoser/status/1313112825385095168 …
The BBC has now published details on how the Excel screwup happened: https://www.bbc.co.uk/news/uk-54422505 …pic.twitter.com/LNaXqGRNPQ
There’s lots of counties that would have shoved those cases under the table forever rather than have the headlines. I know, I was born in one. It’s actually a weird credit to Britain that authorities have admitted them.
There's a weird notch in the graphs that would have been hard to explain otherwise. But I know what you mean..
What's the best technical solution Max? How can the government manage this better?
Use an actual database?
What? Excel? I can not believe this...
I had read it was max file size, not max number of columns. Seems more likely.
Excel has an ~16K column limit. We've got about 250 days of case/hospitalisation data. If each monitoring region reports daily and reports 1 column of data each day you'd only need daily reports from about 70 regions to use up your 16k columns... Seems plausible.
Twitter saattaa olla ruuhkautunut tai ongelma on muuten hetkellinen. Yritä uudelleen tai käy Twitterin tilasivulla saadaksesi lisätietoja.
