Quake3World.com Forums
     General Discussion
        no coronavirus thread ?


Post new topicReply to topic
Login | Profile | | FAQ | Search | IRC




Previous topic | Next topic 
Topic Starter Topic: Re: no coronavirus thread ?

Just another Earthling
Just another Earthling
Joined: 20 Jul 2001
Posts: 12925
PostPosted: 09-19-2020 02:00 PM           Profile Send private message  E-mail  Edit post Reply with quote


Doombrain wrote:
we don't need your numbers ffs


Chill Doombrain :p



_________________
Physicist of Q3W


Top
                 

Digital Nausea
Digital Nausea
Joined: 10 Feb 2001
Posts: 24709
PostPosted: 09-22-2020 12:09 PM           Profile   Send private message  E-mail  Edit post Reply with quote


xer0s wrote:
I feel people don’t realize the vaccine isn’t going to be a miracle solution. First of all, despite what Trump says, it won’t be available for everyone until next summer at the earliest. And even then, it’s not going to be a switch that gets flipped. You’ll get one shot, wait a month, then get another. And then it’ll take several weeks or a few months before you’re possibly immune. This isn’t a fairytale with a magical happy ending. The universe doesn’t give a fuck about us. Some generations just live in shitty times. It’s happened for thousands of years. I’m afraid we might just be in one of those times...


Ahem...

https://www.cnbc.com/2020/09/22/coronav ... pert-.html




Top
                 

Legend
Legend
Joined: 04 Jan 2006
Posts: 16498
PostPosted: 09-22-2020 12:13 PM           Profile Send private message  E-mail  Edit post Reply with quote


Most virologists and vaccine experts have been saying the same thing for months, keep up :p




Top
                 

Digital Nausea
Digital Nausea
Joined: 10 Feb 2001
Posts: 24709
PostPosted: 09-22-2020 12:19 PM           Profile   Send private message  E-mail  Edit post Reply with quote


I said it first!




Top
                 

Etile
Etile
Joined: 19 Nov 2003
Posts: 34898
PostPosted: 09-26-2020 04:25 AM           Profile Send private message  E-mail  Edit post Reply with quote


the plot thickens

https://hubpages.com/politics/Pfizer-Ch ... ic-is-Over

at this point i don't really know what to think. sounds like the experts don't agree :|




Top
                 

Kempston Joy
Kempston Joy
Joined: 11 Aug 2000
Posts: 48594
PostPosted: 09-26-2020 05:02 AM           Profile   Send private message  E-mail  Edit post Reply with quote


seremtan wrote:
the plot thickens

https://hubpages.com/politics/Pfizer-Ch ... ic-is-Over

at this point i don't really know what to think. sounds like the experts don't agree :|


Someone better tell India because people are dying in the back of cars and the streets right now.

Edit: Also i've had three tests, my sons one each and my wife has had one. All came back negative.

Edit edit: Also he looks like a gammon mutha fucker.




Top
                 

Unquantifiable Abstract
Unquantifiable Abstract
Joined: 31 Dec 1969
Posts: 52132
PostPosted: 09-26-2020 08:37 AM           Profile   Send private message  E-mail  Edit post Reply with quote


seremtan wrote:
the plot thickens

https://hubpages.com/politics/Pfizer-Ch ... ic-is-Over

at this point i don't really know what to think. sounds like the experts don't agree :|


Thank fuck for that - time to go to the pub




Top
                 

Arrr?
Arrr?
Joined: 09 Feb 2001
Posts: 35460
PostPosted: 09-26-2020 09:55 AM           Profile Send private message  E-mail  Edit post Reply with quote


I'm not sure I'm willing to take one dude's word for it on this....




Top
                 

Etile
Etile
Joined: 19 Nov 2003
Posts: 34898
PostPosted: 09-26-2020 01:35 PM           Profile Send private message  E-mail  Edit post Reply with quote


indeed

though i'm wondering why, in spite of the confirmed case curve heading upward again the UK (since early August), the death curve remains flat...




Top
                 

Welfare Recipient
Welfare Recipient
Joined: 02 Mar 2007
Posts: 20936
PostPosted: 09-26-2020 03:17 PM           Profile Send private message  E-mail  Edit post Reply with quote


Better treatment obviously... Moron...




Top
                 

Cool #9
Cool #9
Joined: 01 Dec 2000
Posts: 44131
PostPosted: 09-27-2020 02:13 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Better treatment, being prepared better, different demographic getting infected. There's lots of reasons why it could vary.




Top
                 

Canadian Shaft
Canadian Shaft
Joined: 01 Mar 2001
Posts: 19998
PostPosted: 09-27-2020 05:42 AM           Profile Send private message  E-mail  Edit post Reply with quote


and masks mitigating viral load




Top
                 

Welfare Recipient
Welfare Recipient
Joined: 02 Mar 2007
Posts: 20936
PostPosted: 09-27-2020 06:38 AM           Profile Send private message  E-mail  Edit post Reply with quote


I got a huge load for u homo...




Top
                 

Kempston Joy
Kempston Joy
Joined: 11 Aug 2000
Posts: 48594
PostPosted: 09-27-2020 08:21 AM           Profile   Send private message  E-mail  Edit post Reply with quote


seremtan wrote:
indeed

though i'm wondering why, in spite of the confirmed case curve heading upward again the UK (since early August), the death curve remains flat...


As above, but i think the main reason is we knew it was coming.

also - give it time.




Top
                 

Just another Earthling
Just another Earthling
Joined: 20 Jul 2001
Posts: 12925
PostPosted: 09-27-2020 03:47 PM           Profile Send private message  E-mail  Edit post Reply with quote


Made the million :tear:



_________________
Physicist of Q3W


Last edited by Whiskey 7 on 10-09-2020 11:16 PM, edited 3 times in total.

Top
                 

Unquantifiable Abstract
Unquantifiable Abstract
Joined: 31 Dec 1969
Posts: 52132
PostPosted: 09-28-2020 02:29 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Big day!




Top
                 

Cool #9
Cool #9
Joined: 01 Dec 2000
Posts: 44131
PostPosted: 10-05-2020 12:32 AM           Profile   Send private message  E-mail  Edit post Reply with quote


My country is doing really shitty right now. The government is fucking up in many areas.

For instance, there is a crushing shortage in testing capacity. I have been having a sore throat and runny nose the past couple of days, but getting tested for COVID is pretty much impossible right now. Yesterday when I checked, the only available spot would be next Tuesday, at 6pm in a city that's about 80 minutes driving from where I live. Today I checked again, and there were no available spots at all. It's ridiculous. I don't really have to be anywhere, so I'm just staying at home, but something needs to change here.




Top
                 

Etile
Etile
Joined: 19 Nov 2003
Posts: 34898
PostPosted: 10-05-2020 01:00 AM           Profile Send private message  E-mail  Edit post Reply with quote


look on the bright side though: no one outside your country cares what goes on there, so you avoid all the bad publicity




Top
                 

Cool #9
Cool #9
Joined: 01 Dec 2000
Posts: 44131
PostPosted: 10-05-2020 07:36 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Yes, otherwise you get things like these :olo:




Top
                 

Lead Pipe Mafia
Lead Pipe Mafia
Joined: 15 Oct 2007
Posts: 5943
PostPosted: 10-05-2020 08:20 AM           Profile   Send private message  E-mail  Edit post Reply with quote


lol, who needs to pay someone to manage a database when we can just use excel!?




Top
                 

Unquantifiable Abstract
Unquantifiable Abstract
Joined: 31 Dec 1969
Posts: 52132
PostPosted: 10-05-2020 09:30 AM           Profile   Send private message  E-mail  Edit post Reply with quote


:olo:

Fuck me...I live in a country run by absolute mongos




Top
                 

Cool #9
Cool #9
Joined: 01 Dec 2000
Posts: 44131
PostPosted: 10-05-2020 09:58 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Best thing is, the solution was not to migrate to a decent database, no, they moved part of the data to a new excel sheet so they've got plenty of rows columns left :tard:




Top
                 

Digital Nausea
Digital Nausea
Joined: 10 Feb 2001
Posts: 24709
PostPosted: 10-05-2020 10:31 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Don Carlos wrote:
:olo:

Fuck me...I live in a country run by absolute mongos


Better than a country run by mangos...




Last edited by xer0s on 10-05-2020 10:56 AM, edited 1 time in total.

Top
                 

Cool #9
Cool #9
Joined: 01 Dec 2000
Posts: 44131
PostPosted: 10-05-2020 10:44 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Don Carlos wrote:
:olo:

Fuck me...I live in a country run by absolute mongos

lol, at my company, we actually run the software we build on a database named MongoDB, which is a very high performance database system :)




Top
                 

Digital Nausea
Digital Nausea
Joined: 10 Feb 2001
Posts: 24709
PostPosted: 10-05-2020 10:55 AM           Profile   Send private message  E-mail  Edit post Reply with quote





Top
                 

Etile
Etile
Joined: 19 Nov 2003
Posts: 34898
PostPosted: 10-05-2020 12:35 PM           Profile Send private message  E-mail  Edit post Reply with quote


Eraser wrote:
Yes, otherwise you get things like these :olo:
*tweet*


on a related note, the csv used to power the Johns Hopkins dashboard is structured with dates (at the day level) as column headers, with countries in rows (and to make matters worse, the daily case values are running totals, not daily counts). at end of sept, the righthand-most column in the dataset was IV :dork: this means that to do any viz oneself (i.e. in Tableau or PowerBI or whatever) you have to pivot the date columns, then add new date columns to the pivot every time you update your own copy from Github (and fix the date column because they didn't use the right format :mad: )

as someone who works in data and data viz, this imho this is really shit practice. they only need three columns: date, country, cases. Excel has way more rows than columns available




Top
                 

Just another Earthling
Just another Earthling
Joined: 20 Jul 2001
Posts: 12925
PostPosted: 10-09-2020 11:14 PM           Profile Send private message  E-mail  Edit post Reply with quote


Where are we at I wonder?

Cases worldwide

19 September 30,697,734

28 September 33,297,042

10 October 37,121,450

Total deaths
• World 1,072,852
• USA 218,648
• Brazil 149,692
• India 107,450

Source #1 Source #2



_________________
Physicist of Q3W


Top
                 

Unquantifiable Abstract
Unquantifiable Abstract
Joined: 31 Dec 1969
Posts: 52132
PostPosted: 10-10-2020 02:54 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Strong numbers




Top
                 

Etile
Etile
Joined: 19 Nov 2003
Posts: 34898
PostPosted: 10-10-2020 01:22 PM           Profile Send private message  E-mail  Edit post Reply with quote


Eraser wrote:
Yes, otherwise you get things like these :olo:


also, Excel maxes out at 16,384 columns. even with a column per day since the first case there should still be plenty left over

were they using a column per hour? minute? wtf?




Top
                 

Cool #9
Cool #9
Joined: 01 Dec 2000
Posts: 44131
PostPosted: 10-12-2020 04:03 AM           Profile   Send private message  E-mail  Edit post Reply with quote


seremtan wrote:
Eraser wrote:
Yes, otherwise you get things like these :olo:


also, Excel maxes out at 16,384 columns. even with a column per day since the first case there should still be plenty left over

were they using a column per hour? minute? wtf?


Famous (only slightly) mathematician Matt Parker explains it very well in this video:
https://www.youtube.com/watch?v=zUp8pkoeMss

For some reason he poured it into some faux news reporting shape for comedic purposes, which distracts a bit from the issue at hand, so I'll give you the quick rundown:

- The claim that columns maxed out is unsubstantiated. The BBC reported this, but hasn't been verified.
- What is known is that an older version of the Excel file format was used (the pre-Office 2007 .xls format), which caps its number of rows at 65,536 (versus 1,048,576 for Office 2007's .xlsx).
- It turns out one case of COVID used more than one row. Official reports say that there was room for about 1400 cases which means there were about 46 or 47 rows per case.
- Because each case had a variable number of rows, it took a long time before someone noticed something was off.




Top
                 

Etile
Etile
Joined: 19 Nov 2003
Posts: 34898
PostPosted: 10-12-2020 01:05 PM           Profile Send private message  E-mail  Edit post Reply with quote


the part where someone was using columns as rows was especially lolworthy

that said, general understanding of how data ought to be structured is thin on the ground even among people who you'd expect to know better. i've lost count of the number of times i've been asked to build visualisations of datasets in Tableau only to find i have to restructure their shitty clusterfuck of a dataset before i can even start :|




Top
                 

Canadian Shaft
Canadian Shaft
Joined: 01 Mar 2001
Posts: 19998
PostPosted: 10-15-2020 11:07 AM           Profile Send private message  E-mail  Edit post Reply with quote





Top
                 

Digital Nausea
Digital Nausea
Joined: 10 Feb 2001
Posts: 24709
PostPosted: 10-15-2020 11:27 AM           Profile   Send private message  E-mail  Edit post Reply with quote


Interesting. These super spreader events are the real problem. I can now envision all these Italians sitting down for family meals, screaming at each other from across the table as meatballs crumbs and Covid particles fly through the air...




Top
                 

Welfare Recipient
Welfare Recipient
Joined: 02 Mar 2007
Posts: 20936
PostPosted: 10-15-2020 05:56 PM           Profile Send private message  E-mail  Edit post Reply with quote


Racist pos... I'm half Italian... Southern poverty law center called...




Top
                 

Canadian Shaft
Canadian Shaft
Joined: 01 Mar 2001
Posts: 19998
PostPosted: 10-15-2020 06:05 PM           Profile Send private message  E-mail  Edit post Reply with quote


scared? wrote:
Racist pos... I'm half Italian... Southern poverty law center called...

you're half balled :olo:




Top
                 
Quake3World.com | Forum Index | General Discussion


Post new topic Reply to topic


cron
Quake3World.com
© ZeniMax. Zenimax, QUAKE III ARENA, Id Software and associated trademarks are trademarks of the ZeniMax group of companies. All rights reserved.
This is an unofficial fan website without any affiliation with or endorsement by ZeniMax.
All views and opinions expressed are those of the author.