For the data diction do you want to do the first 10 and I’ll do the second 10?
Yeah, I have an integration to do for Bell that will take the rest of the day though so I won't get to it until tomorrow and I can focus on one thing.
Hey Luke, So James said there were 20 columns but when I exported it into a csv there are 59. I think I am looking at the wrong thing
Or did he mean "adverse events" in bigquery?
Yeah he meant that we'll be using 20 columns, exactly the 20 that are in the adverse events table
when you downloaded it from the fda website did you only do one dataset? between the two data sets there should be 78 rows
For "animal and veterinary" I am showing 58
oh no, for the Data Category were doing "Human Drug" and for datasets "Drugs@FDA" and "Event"
Can I get 10 minutes before the meeting starts? I'm going to mess around with it until then
Do you want to just hop on a quick call now? I'm not going to be on the meeting, I've been coughing out my lungs since last night so I'm trying to head over to urgent care after a bit
It's ok, I'm waiting to hear back for my appointment request, not trying to wait in their lobby
We can do it later in the week if I don't figure it out. Probably better for you not to talk
Ok, I'll be on and off slack so if you do have questions, that hopefully I can answer, just let me know
Thank you! Unfortunately, I've had respiratory viruses enough that I'm nearly positive that's what it is
Not yet, I've been struggling so much the last week I haven't even bother to look at it. Planning on doing it before our meeting block. Have you?
I operate better with like an example lol. I'm not sure what we're looking for here
I'll try to start on it soon, after this meeting im jumping into. Can do it in a google sheet and send it over if that'd be helpful
yeah of course. Ok I should be out of this meeting just before noon. might need to take a little break after though and i'll get started
I think you just told me respiratory illness and that you were going to urgent care.
Ok I just shared the excel sheet with you. Most of it should be filled out we really just have to do the definition. James has all of them shown as strings in the bigquery app he's using but of course while youre looking through the excel file if it doesn't look like a string please change
I highlighted you in blue if you want to do those ones, I filled in the first one completely for what we'll be doing as an example, and I'll do the pink ones
Got it. Kind of what we were doing for the internal data dictionary. I was overthinking it. Thanks!
Oh so yeah it turned out to be bronchitis, and this weekend since my immune system is so low I ended up getting an infection in one of my eyes. So I've been really struggling lately haha
Damn! an eye infection! Those are the worst
it's awful! it's so itchy, and vision in it's a little blurry
I know it's expensive but mucinex is fucking awesome
Do you wear contacts or is it galsses only?
oh yeah I've been taking so much mucinex. I'm finally on a steroid inhaler that has been helping
I thought maybe the contacts got you the infection
oh no, it's jsut from normal bacteria we always experience, but our immune system doesn't let it effect us.
I watched that movie Saltburn this weekend. Wild
People were going off on how disturbing it was so i was expecting a little more
The first one got me but then I was expecting it to continue lol
yeah same here. there were like two scenes that were gross, but not as much as peple had made it out to be
I thought the scene were he pulled the ventilator out was going to escalate and Idk if I could have handled that. Good movie though. I was a fan. Murder on teh dance floor has been stuck in my head for the past three days though
Mine says waiting for host to start but IDK if my zoom is just slow
Oh we’re rescheduling it to next week, Nicks sick
This is the most convoluted demo I've ever been on haha
Can you try to do an action in leadspedia? IDK if it's down or just down for me
I've been using LP this morning for financials and haven't had any issues with it
this is the url I use https://personalinjury.leadspedia.net/
I was inspecting Leadspedia and I believe it triggered the phishing flag bc the headers are using PHP 5.6 which is from 2014....
I don't know much but I know that is old.
I honestly have no idea what's going on with it. I don't think Ryans available this morning
Nick's kinda goin for it but Ryan doesn't have his calendar blocked off. What a mess. Whatever
At this point I'm very over it and probably will retain nothing. At least it's Friday
Do you know, are there schema things we're suppose to be working on before our next data dictionary/AI project meeting?
I think so I haven't done it in dbdiagram yet but I have it in the ML data dictionary
Straight up. I just want some fried food and some cold beer
https://deadline.com/2024/01/man-surfboard-flooded-freeway-california-1235801490/
I meant to ask earlier but forgot, do you usually put the campaigns in typeform?
I do for media spend. Sorry I didn’t see this until just now
No worries! Would you mind adding these theee: New Jersey Juv Abuse Eric Olsen Sexual abuse ADM securities - the same is something like that, I just can’t bring it up at the moment
If it’s not a pain to do, if you want to record a video doing them, I can enter them in type form moving forward. I know we’ve gone over it before it’s just been so long I don’t really recall how to
Added. I didn't see the message til I did them. It's super easy, it's just adding them into the options. I can take a video next time.
Hey Luke, do you have 5? I'm about to add a vertical in typeform
do you mind hopping on a call together real quick
or I can go in later, I feel pretty sure that we both cant be doing editing at the same time
hey I'm finished, it was pretty easy. I have to go back and check on the verticle names but I'm going to do that later
hey I have a quick stupid question for you, I remember what you said about adding a campaign to type form, but where is there editor that you go to type the new campaign name in for reach option?
I'm not sure I understant the question. Want to hop on for a sec?
Hey, do you know, is there a newer folder in looker enterprise Ryan has been using? He showed me a couple of the new graphs, but I don't see them in my shared folder "Shield Financials"
its running a little slow but its still working for me
Thanks, sorry, didn't notice the stop sign til I hit send
haha no worries, I'm finally getting through the mountain of items that've been coming in. Just going to spend the next couple of hours working on those visualizations
all the interactions in this meeting feel so tense
and Vikki treats us like we're idiots lol
what why?? I thought you guys were on good terms
we're on fine terms he just doesn't like me
ah ok. It's ok I don't think he likes many people. He definitely doesn't like me either
he tried to blame some shit on me and I just told him if he did his job correctly then it would have been a non issue
He gave us the wrong retainer and was pissed that Clients got signed on it
Since I loaded it into lawruler he blamed me🤷♀️
yeah they are. Especially Patsy, shes too new here to be this firm on items
Like tell me all the situations you've run into this. We do shit a certain way for a reason. We don't make it complex just for fun
exactlyyyy. Yeah we don't love the naming convention either, but when you actually take time and get to know all clients it makes sense
I almost feel bad for her, I think it's obvious shes gets overwhelmed which is fair with how new she is, but it's like girl you'll get it evetnually
Thanks for adding those new vertical to typeform
appreciate you reminding me how to
I’m mostly surprised to hear Sean was a COO
That company was a fully funded shitshow lol
Hey Brian, I heard you’re working on a SQL statement for lawruler and wanted to see if you needed any help
That got pushed to tomorrow, I’m dealing with this Leadspedia lead routing thing for Broughton.
I’m not sure if I need help yet, I haven’t hit a block I just haven’t spent enough time to hit a block on it yet. Thank you!
Oh for sure, yeah just lmk if you do hit any blocks, and we can jump on a quick call, but sounds like you’ve got it covered!
Haha ik. This might not be as technical as we thought it would be
If Temecula wines were good those wineries would be sick
absolutely agree! The wineries are gorgeous, but the wines always trash
Hey @Brian Hirst do you have a few free moments? I'm working on this dbt project and have been running into a roadblock
I can’t make the byte code meeting. I’m having some delivery issues. Thought they’d be fixed by now
No worries, good luck I know that can be fustrating!
Good luck to you too! Hopefully it’s simple
Mark Maniora told me Ryan jsut called him and said he'd be taking over some of Korbin's tasks
I’m not too surprised, he was terrible at his job, but still
Well he asked me about something and I said "doesn't Korbin normally do that?" and he followed with that
I don't think I could last in Vegas. That place sounds cursed
Oh there’s no way I’d ever go there. The nightmare stories I’ve already heard from The office
not to send screenshots but this is wild. and Mark doesn't care lol
Huh it’s almost like they shouldn’t have left San Diego haha
I bet they're ok with a little crack smoking every now and again
I mean it makes you really productive right? At least for a short time