I think that's why we're here. Mr. Brennan. President. Mr. McDowell. Yes. President. President. Here. Reverend McDowell, we're going to say a few words to start this deliberation about bus stops and bike lanes. But I'm glad each person is here today. We've got a little congregation, you know. I don't know, I just take up an offering. I think that's why they're here. You got the wrong congregation. We could be the wrong or the right congregation. Let the ushers come forward. Thank you for being here today and thank you for being a part of this city and thank you for being a part as we continue to grow and advance. Let us bow our heads. O Lord, for a whole presence in our lives, for the ability to move, for the ability for our sitting to continue to prosper and grow, we simply say, thank you. We know that there are hurdles. We know that there are vicissitudes, but we also know that this is not a hopeless situation. We are filled with hope and admiration of what is to come and what is taking place. Bless us individually and yet collectively. Allow your presence to fall afresh upon us. We ask it and claim it in the creator's name. Amen. Well, at this time, we will move forward with city council discussion, the first item being the fiscal year 2023-2024, accommodations, tax committee recommendations. Mr. Hal Stevenson, committee chair is here. Hi, Hal. Oh, my apologies, sir. Yes, sir. Yes. Just one moment for us, Hal. With that adoption, Mayor, we would ask that you won't add Project Tango to the executive session item under what's it under in the last committee that came out of committee economic development. Yes, I think the special of matters is that you can propose an expansion of the business service for five years. Thank you. So that would be our request to add Project Tango to this agenda under executive session. Is there a motion? Just a moment. Second. You got a motion to second. Can you read the as well, please? Mr. Brown. Hi. Hi, Mr. Brown. Yes. Mr. McDowell. Yes. Mr. DeWall. Hi. Hi. Mr. Stevens. Good afternoon, Mr. Mayor. Well, I didn't get to see you. I haven't agreed to you all, but I appreciate what you all do. As the chairman of the accommodations tax committee, we have forwarded and had our meeting forwarded our recommendations as far as the financial part, which I'm assuming y'all have entered packets. And you may have received an email I wrote the day that we met that I sent out to the staff with calls. I might not be able to remember it the next day if I didn't do it. So I'm going to go from that as far as a report and then let y'all add any questions that that's up there. We came, we said, I'll just read it. There was a unanimous sentiment from the diverse committee that was the basis for our recommendations, natural right. There was a little talk about the economy and we wanted to make that statement as a committee. I think we recommended full funding on what they're asked for. Merriam Atria and Lake Murray Country do a great job as well with their organization. As we look through her report, as we noticed that Lexington, Town and County were probably not paying as much as we wanted. So we wanted to make a statement that the County and City of Lexington, Town of Lexington would pay more. I understand Merriam that that is in fact the case. She took that advice and went after them and they have and I'm sure she could have more to say about that. Broke it. We get $20,000 to the zoo. This was a little bit of departure from what we'd normally done last year. We do 85% to experience Columbia and 15% to Lake Murray Country without taking anything from anywhere else. But we felt like with the zoo and what they're doing that it was a no-brainer than asking for $20,000. Finally, you guys just consider a million dollars out of the fund to repay bonds, I believe. I don't know the details of that. That conversation today. The reason that the ATAC committee has really only considered marketing organizations like the Spirits of Columbia or Lake Murray Country is because of the Tourism Expandentary Review Committee. The rules around that are written pretty quickly. We work here and Tina gave us the opinion of city staff and attorneys that you can, in fact, as city council designate to take some of that money. We're not lawyers and that's business that y'all can take on yourselves. But that's why we've been so focused on just those two organizations. We recommend it against, of course, coming out of the fund. We think we live in a fabulous region and that we have got to have money to communicate that outside of the city and in the city, frankly, because we have a tendency sometimes to put ourselves down internally. So we are always, we'll always promote and advocate for more money for tourism, marketing, expenditure. So with that, I'll say one thing that I said in my letter personally, as a property owner in the VISTA, I personally have not had a problem coming up with some sort of help get property owners together to help perhaps pay some of the trade on getting Finley Park upgraded because it will benefit us all greatly down there. So that's just an aside and not only agenda, but I want to know that first one. Part of the benefit of the public house that you mentioned, that debt service, it's the purpose of the H-Tax Fund, the debt service was Finley Park. So just for the public's understanding of that a million dollars, that was what it was for. Yeah, I understand. And I know y'all understand more than everybody in here in the reform. So you know, we don't have a whole lot of power on the H-Tax Committee. So when we make recommendations, we have numerous times had that change to council level and didn't hurt feelings or just it might be repeated. Yes, yes, I expected fully to be done. I know y'all got to deliberate these things and more tell than we did, but we thought it was worth sending that across just for posterity sake. Um, for me, the Jesse Bullets here, he's on the committee with me. I'm not seeing anybody else in the committee. I know it would be more active, which we're talking to Dana and you can see a little bit about trying to be more engaged and more helpful. I'll be glad to answer any questions if there are any. Do you want to have any questions, Mr. Stevens? Thank you. With that, we'll move forward with the fiscal year 2023-2024 hospitality tax committee recommendations. Mr. Matthew Bridges, primarily chair. Nice, Matthew Bridges. I'm the chairman of the H-Tax Committee this year. Uh, take questions you have. They love you. You are. That's the hip thing, Terry. I wanted to thank y'all very much for continuing to trust us with listening to our local festivals and other drivers that will bring people into the restaurants who pay their 2% back. And these events are very important to bring people into the city and to retaining, to keeping them here and getting them into our restaurants. That means that last year we had an odd year, and thank you very much for allowing us to have 2 interviews coming out of COVID. We thought that was very important. We felt that the applications were down from previous pre-COVID levels. And there were 7 organizations that were out of interviews. So 2023 we had 62 organizations funded. This year we were slightly down from that. We do feel that the message was out there. We just have lost some organizations permanently due to COVID and for various other reasons. So we had a total of 57 applicants. And three of those are major entertainment districts. I just wanted to touch on that. I'm sure there'll be questions about that. The committee felt that it was, while they're very unique in their locations and what they're able to do, that we should fund them equally as possible. You'll see that there's 10,000 extra because of our committee guideline for one of them not asking for the level that we funded the other two for. That being said, with 57 applicants, I'm sure there are some specific questions about specific organization. Do you want to have any questions? If you explain to the line, street, allocation, if it was 80,000 a year, do you know what I mean? 60 corrects. If they still have a carryover at the time of our meeting and putting in our recommendations, they still had over 60% carryover from the previous year. So we wanted to talk to you. Matt, help me to understand the Carnegie International Festival. The 2023 was about 100,000, the question of 150, and we're back at the 2023 year. Because of the success of what is taking place in the club, what was the rationale? He keep it at the center. Well, I'm sorry, I'm having to, can't, 57, I'm having a hard time remembering. If I remember correctly, of course, we did spend all the money. Like I said, I'm old, so I'm trying to remember. We do feel like we're doing a good job, but we ended up spreading money across to as many applicants as we could. Clearly, if we had increased them significantly, that would have been 100,000 to 100,000. We would have had to take from other groups. So they're doing a great job. 100,000 dollars goes a long way with them. And did we do similarly with other agencies as we increased one and increased the other, as they're related to the 2023 comparatively to 2024? Did we similarly do the same thing? They're all very unique, with very unique expenditures and needs. So I can't say that we used a good, better approach for each one. All right, that's what I was going to say. Well, I guess the reason I'm asking is that I have been a friend and a tender of Columbia International, in addition to a lot of these other things that are listed. And as you know, I think as you know, that becomes one of the largest kinds of events. I don't have the exact fees brought, but I'm sure it's probably over 15, 21, 20, 21,000. Easily 20,000. Okay, I got it. That's good. Okay. Sir, Mayor. Thank you, sir. Matthew. Yes. Thanks for all your leadership on the H-Hacks. I know that's two or three days of your life that we're very, very welcoming. Let me ask you something. So you mentioned Divine Street and a carryover, carry forward, I should say. Is that carry forward information from other groups provided in our info? We did it when it was reviewing. Any of those, they give it to you, but we know they give it to you. Okay, in your, from what you can remember from the 57 applicants, how many others had carry forward balances? It would be a minority of 20%. 20%. And I would say Divine Street was the biggest. Okay, but didn't you keep that in mind when giving a new number to those other groups that had carry forwards? Correct. That's a great current question we have for each applicant. Did they tell, they give a reason? Was there like an overwhelming reason why there was a carryover? There was no reason given. Thank you. I wanted to know a little bit about this without relying on our research foundation. It's not intuitive to ask how that's connected to the Cobra Center's art season. Is that simply the organization that the Cobra Center is working with to funnel that money through? It's where the university moved to the Cobra Center owner. So that's their overarching administration unit. And that was owned by the university? Yeah. So just out of curiosity, based on what you were talking about earlier, and that had a pretty significant impact on the assets that the university has already. The additional programming that they were going to have this year in addition to, and it was our understanding that their funding has been reduced by the university. And when they moved from the original structure over to this area, their funding based on what that area has to give them. Sounds like our friends at the University of South Carolina Foundation need to give a little money to them considering that they have plenty to buy a property to take it off the tax roll. How much are your organizations to use that center, including the city? I think the only trend I'm seeing going back to the Council on this is almost all of the organizations are getting this increased. So I think we should revisit the Columbia International Festival to see consistency, how we can kind of be a little bit more equitable with that. Is there any way we can differentiate between the Columbia? It is a large part. The ballet, both companies. That was a significant increase in one and decrease in the other. They actually gave the exact same thing, but we're going to talk about that afterwards. All right. Thank you very much. Thank you, sir. You're all right, man. Thank you. Any other questions to understand the fact right now? Some music academy. Can you talk a little bit more about what they were using the dollars for? Yes, multiple concerts. They're bringing in an international artist. They do. They do it at the Koger Center, although I guess they have an ABC program, I think they're called Koger Center. But they do a terrific job and they bring in a wonderful group of performers. Sorry. We're lucky to get in the Columbia area. We don't have any concerns with their content. Any other questions? Will we come in? So the restaurant association, why is it that we didn't recommend them getting the full amount given that those are the folks that generate this funding? Well, we increased them $10,000 from last year. So we didn't give them the 50. Again, we would have had to take that from somebody else, but we did increase them by $10,000. We did not meet the majority of the requested amounts. We did not fully fund the majority of those requests. How many folks applied? We basically funded everybody's salary.  And a lot of the reason why we don't fully fund the majority is because their request was for $4.8 million. We fully funded everyone. We would not have enough money. Any other questions from Council? Yes, the purpose of the discussion is different. Can you expand on that? How does something qualify or not qualify if it's a ticketed event? Given our guidelines that we have created in the past that have dictated what we fund, that's generally not been an item that we would. That could always change given a certain event. Our guidelines for determining these are that a closed ticket event is not going to have the draw and that something open to the public would be. By ticketed, that doesn't mean we don't give money to anybody who charges entry. It's like this club is having the songwriters guild or something. The only people who are going to come are the guild members and their family members.  Thank you. Do you have a question? Are you all good? Thank you, sir. I knew it's been a difficult job, but I'm happy to have her. We can continue with a line item discussion. The fiscal year 2023-2024 hospitality tax line item agency request in Missy Cawthorne's absence. Jim and I are going to try to help y'all with this. Jim's going to do his best. I would also like to say to how, to Matthew, to Terry, to pass everything from the committees. Thank you. I know that Tina and staff in Missy have worked with y'all. I know it's a lot, especially for some of these committee meetings to keep coming in, and I know some of y'all have probably been on them in years past as well. It's a huge effort, so I see all this from afar, but I appreciate all that y'all do. It makes it a lot easier for the council. We wouldn't have a budget to hire enough people to do all that, so it is a great service, so I thank y'all. We'll start with accommodations tax. This was presented to y'all. It was in last week's budget, and all the documents that came to y'all on the various different budgets. I wasn't particularly going to go through each and every line item unless y'all would like to, but I wouldn't want to point out. I think the wrong hospitality line item needs requests is where we would be even finished y'all before we do the overall. The line item measures. Thank you, sir. We skipped to almost last. I would argue, this is y'all's show here, so I'm just here to kind of take records and tell you kind of what we have. The total request was the $2,880 for these. Y'all have an available allocation $2,276, but I would add, Mayor, we've talked about this before, maybe several of us, and we just kind of go back. We do have within there, we have allocated $1 million to the violence, so we have talked about splitting that up over two years. So we actually have $2,776,935 to stress. Can you get back to the last line? So the number we actually got is $2,275 for those line item agencies. We've seen what we're going to have some discussion of. Have we decided the, I guess, the order of the Ballard installation, Ballard installation, or is that still being talked about since now that we're splitting it for two years? Part of it, what we can do on Main Street, because that's where the majority of our vents are, we'll only take a partial of that, and I think the next ones will get a five points to reduce the floodwaves to the storm fronts, which I think is a priority. Right now, Layland Street, we have all the, you know, the chemical weapons that we still have to be back for. Well, I want to, so I support that. The way we looked at it, I think when we were adding up costs per ballot, you know, the like five things that we were working out, we could hit those two areas first. One, from a safety, most safety standpoint, and one more with flooding as well, that'll help the merchants. How much, how much is modeling going to help the flooding? Because people drop through, and so we can't get down, create more rain, so it's then a rolling into the storm fronts. So if we can eliminate people from even getting down there, then we have, have a wage preserved that is restaurants that we tell if you continue with water. Yeah, that's your question. Does that, does that mean then that DOT cares for the head? No, that's us. All right. That's our enhancement. Okay. You know, as Will says, they're going to be digging up the roadstone, so there may be some cost savings while what they're doing for us to add those components in. All right. And of course, these are not permanent bullets. They open down. That's what I'm saying. Yeah. Road control. We'll get one for your car. So you're going to have to remote control. Thank you. Any questions for Jeff? So do y'all have a assessment through the line arms? Yes, we do. Do you hear that? Yeah. I think I want to make sure that the questions that we started going through all these. Is that for information only or are we doing like this? I think we can just, I'd like us to go through it so we can vote on it next week to be honest with you. Yeah. The mayor makes a good point. We're not voting on this today. And that's for next week's vote. And we can actually get it done before July 1 works. Now y'all can clap now. So just for clarification, the new number is 2-7? 2-7-7-7-6. We make some slight adjustments. We can get it right there. So that's the one we're going to leave it short. We're going to go, yeah. So we're going to go through the line items. Recommendations for campuses would be number one, the Museum of Arts, age 50, Columbia Regional Festival Association 255, Adventure 450. We have a 200 one, excuse me, 175. Historic Columbia 750. One is Columbia Arts, $100,000 for grant writing, specifically for grant writing. That was council driven decision. And then $100,000 for the Philharmonic. Well, you got that one more time? Age 50 for Columbia Museum of Art, 255 for CMFA, 450 for Adventure, 175 for SC 63, Historic Columbia 750, one Columbia Art writing, and then the Philharmonic out here. The Philharmonic was at $100,000? Yes, ma'am. So where's the funding for hold back for future public safety? That's in the host of talent. That's designated for those three areas that we just got to talk. Y'all good with that? Yes, yes. All right, y'all want to get a hospitality tax committee recommendations? I would be, the two that I'd like to call out is I'd like to have the council consider for the Coder Center, us going back to the USC and asking them to support that. So is your recommendation to give them what they had last year and ask USC to build a gap? Correct. So that would be line item 42, 25K. Need the recommendations of this one. Ellen, you go back and make sure everybody's on board. And I'd like to increase the international festival and meet their needs at around 50. Well, that's a 50% increase that we've got to come up with somewhere. You know, I mean, that 50K, it's only got 15 hours. Look at that per side. What was that per side? She's on item 42. Yeah, I'm looking for it. From 40 to 25. So that gives you 15. Well ballet, my suggestion on the ballet is to have line item 14 and 15 reflect each other 150. So we're just moving. We're making an equal. So instead of 180. Pick up five grand. So instead of 180 and 125, is it ready? 150 each. 150 each. That gives you another five grand. So now you're up to 20. And also another ballet item three. Then for the elderly, could we? The elderly, sir. Item 17, of course. I would suggest we take out the 12,000 for the Lurie Center based on our moving. Condolabation. And other ballet. So can we can we then say it was just number 38? Yeah. Can we get the international festival at 125? That's that's that's the city. That's a 25% increase over the last year. Here to 130. 130? 130. And then that's good to have that come. You're on. I would be able to get that. Yeah. I'm sorry. 30. And the only one. So we've taken out the 12, right? The 30. Yeah. The only other one that I would put out there and I'm not super on up on it. But I do think that if these dollars come from restaurants. Then it should be investing in the next week. So why don't we move that to that and that would give them 50. Well, let's just make it 50 what they asked for. And I'll leave us 4,500. So I have another maybe and this just came up for the committee. So I know that the ATACs were potentially making an additional allocations to the zoo. And then they also requested for their park district zoo and garden appetite. I would recommend not move it 20,000 on the ATAC. Did you not do it? Not do it. Not made. I have to leave it in the hospital. I'll leave it there. I got it. Okay. So. What was the item right prior to that one? Dot to bustles for the restaurant. The Lurie Center. I got the item. I don't know. I already ate the Lurie Center. But the restaurant. Restaurant waiting for access. 26, make that 50, increase that by 10. 50. 26. So the Lurie Center. Lurie would be around 38. Because of the other effort. Where you go? You all good? Yes, sir. All right. We need to recap that or you don't catch it. I think those ladies sitting over there have our back pretty good. Y'all good? You captured it. Didn't you do? Yeah. Thank you. Thank you. Well, also. Jeff, you ready to go down? I actually do got a number. So I have to go back through and Erica. I'm probably going to go over this video afterwards to make sure. Thanks, Alex. Okay. I think there was the other item that we printed for them. But I didn't need that for this purpose. Oh, I have. What's that? This is 60. It was a man. And they only have been extended. Yeah. I'll keep you. Yeah. Yeah. That was it. I'm scared. We've already got. We've already got. We've already got. We've already got. We've got. We've got. We've got. We've got. We've got. We've got. Okay. I want to take it on the air already. We've got it. We've got it. It was already. We have a change in the road. So, we're in ATACs. So what we got here, so the 2.7, I know that there's more money there, I would like us to communicate about a million dollars back and hold it for the next quarter of the next quarter of the year. So that if tourist related items, promotion items come off, they can come back to us. I don't want to... I mean because some of this is carried forward. We have to use it in a period of time. So I would recommend that we give 400 to Lake Murray And then we give 2.3 to the CBB and leave the balance in the account for us to look at at their later date. And say that again, please. Yeah. 2.3 to the CBB, 400 to Lake Murray Country. That's a 2.7 out of that to leave the balance of funding in the account for later date. That'll leave a million. Some of these marketing projects and other things and there does probably be some events that are going to pop up and we need somewhere to get to that. We need to point out that this also includes in special projects, 230,000 for restaurants. Yeah. And 800. We got that right there. 800 is heading to 3,000 for. Where is that? Yeah. Right there. 230. Right here. And it's also on. I'm sorry, we had set a million for the debt service. It's actually turned out we've issued bonds. It's just 873,000. I can find it that I would just want to. I hear the committee's. Wish to learn a little bit more about Lexington. So I would just want to know what the final. Investment from Lexington is for Lake Murray. Given that they do benefit a lot from it. Don't worry. That's all the things. But yeah, I do. I do agree that they need to also invest. When do you think the public facilities project would be up. Up and over. Henry. In the restaurant. Yeah. Very nice. I think Henry has looked at his full spots. I think he's prepared to bring us a recommendation. And I think it'd be something to happen pretty quick. Perfect. Thank you. Jeff. That's right. $200,000. Right. 230. All right. Sounds good. We're still can't, that's all the money. And I think it'd be something to happen pretty quick. Thank you. Jeff, that's right. $200,000. 20,000. That sounds good. Not today. So. Like you have good direction. We do. If you are a good world. My name will work back next week in the second meeting. Budget. So basically, folks, we're pretty much that. I want to thank staff, Jeff, you and Missy and city manager and mayor and all that are involved in putting all this together. This has been an arduous task not only for this council because we've met seemingly for the last six months every Tuesday and it's it's been it's been very it's been very enlightening so thank you all so much for what you've done to make this a lack of a better word a easy read for us thank you all so much and of course after saying that all of you who gave a hand clap


It's July and it's getting hot, just like the deals at Appalachian Wireless. All month get the Simpsons Galaxy S8 for just a penny with a two-year agreement. But don't wait because the deal ends soon. Better service, bigger savings. That's today's Appalachian Wireless. Officials with the Kentucky Department of Fish and Wildlife are speaking out against the growing number of people feeding black bears in southeast Kentucky. They can find food on their own. You know, you don't need to worry about if they're able to or not. They'll find it. They'll be fine. They don't need our help for anything. Tristan Curry, a biologist with the Bear Program, is specifically talking about people setting food out alongside the road on Black Mountain in Harlan County and Pine Mountain in Letcher County. Number one, it's illegal. And number two, it's hurting the bears. Whenever these bears do get habituated and acclimated to human food, when people are feeding them roadside through their windows or setting food out for them, is it gets to the point you're increasing contact with people. And with that increased contact is increased chances of somebody getting injured. Bears become to expect food from people at that point. Curry says that when that happens, it's nearly impossible to rehabilitate the bear. Because once they get to the point where they become dependent on human foods, that's when ever we'll have to come in and it usually ends in euthanasia for the bear. And he says what people don't understand is it only takes a couple times feeding a bear to end that bear's life. It can happen in a couple weeks time. It can go from being a wild bear and acting naturally to standing up on the side of vehicles, climbing in the back of them. We had reports yesterday of a bear climbing on to the windows of vehicles that had to wind it down. In fact, just yesterday, a black bear had to be euthanized. That bear particularly, we had several photos and videos of it climbing onto the windowsills of vehicles, onto the back of vehicles and approaching people regardless if they had food in their hand or on the ground or not. In the second part of this story, we will talk to the law enforcement side of fish and wildlife and see what steps they are taking to address illegal feeding of both black bears. On Black Mountain, I'm Shannon Deskins, EKB News.


Hey, people are getting excited, entrance agent prospecting 101, two hour deep dive into everything prospecting. Matt's over here designing a last minute graphic, last chance for you to get in. This is 20 something pages and we're gonna spend a lot of time together going through everything prospecting related. We're getting the studio set up. How about that backdrop? Newkodiaskins.com, little tablecloth, the new mics.  It's 47 bucks. Go to kodiaskins.com to register. I'm doing this because a new agent personally told me after seven weeks, he made $152 and I wanted to throw up. And now tonight, I'm gonna fix that so that you can start making some money and I'm gonna tell you every way, every way in detail how I made 117K at 19 and how you can too by joining this.


Okay, stop me if you've heard something like this before. Two teenagers meet, and one, or both of them, have cancer slash some other incurable, deadly disease. They might argue a bit, but they discover that they have strong, romantic feelings for each other and start a relationship. Then one of them dies, and everything is sad. But they got to have a good last few months, and the surviving one has learned a lot about the value of human life, so it's not all bad. Obviously, I'm being a bit vague with this description, but I think it's safe to assume that all of you were reminded of at least one or two books that have come out in recent years. A Walk to Remember, The Fault in Our Stars, Me and Earl in the Dying Girl, Before I Die, Everything Everything, and Keith are all based on this formula, though with some variations and some subversion. And if you count books that aren't about teenagers or are similar but don't deal with terminal illness, then we can include Me Before You, It's Kind of a Funny Story, and If I Stay. There are a lot of these, and they've been around for a while. A Walk to Remember is about 20 years old now. The genre has just exploded in popularity in the last decade. You want to know the really crazy thing? These are all just books that were successful and turned into movies. If we expand the search into similar books that were less successful and weren't adapted then the list gets... just so long. It's an entire subgenre now, primarily in the YA category, and sometimes it's referred to as sick-lit. Honestly, that's kinda gross. Now that sounds weird, so let me explain. But before I can explain, you have to let me set the stage. Themes of death have been explored in fiction since forever, and themes of young love have been around just as long. Combining the two goes back pretty far as well. Just think of Romeo and Juliet. There might not have been illness involved, but their romance was doomed from the start. This sort of story takes a lot of boxes that appeal to all of us, particularly teenagers and young people. Despair, loneliness, existential dread, the thrill of your first love, living in the moment, and knowing exactly what the future will bring all strike a chord within us. Even if the future is going to bring pain, just knowing when and how you'll die sounds pretty great to a lot of people, it takes away the stress of worrying. None of this is inherently bad so far. When you include the romance aspect of it, the wish fulfillment becomes even more obvious. Love is a powerful emotion that we can empathize with, especially when it's in young people who are experiencing it for the first time. That's part of the reason that sicklet features teenagers as main characters such a large proportion of the time, and why they're so often the target audience. They also usually have lower standards, but we'll ignore that. Then when you add in the large role that death plays in the story, the emotion is pushed up to eleven since it's not only their first love, but most likely their last, and they all know it's the entire time.  All the illness and death only exists to amplify the pre-existing drama. All the books I brought up earlier are romance stories first and foremost with everything else taking a back seat. This in turn is amplified further by the power of fiction where things always happen at the most dramatic moment or in the most dramatic way. I'm deciding to call it tragedy porn. I don't know if that phrase has been used before and I refuse to check, so just tell all your friends that I came up with it. And hey, I'm not knocking anybody who enjoys this type of story. I like a good tragedy now and then, and I enjoy a well-written romance as much as the next guy. And even if I didn't, we all have subjective tastes, and I'm not judging anybody for that. I just want to talk about some of the underlying themes with some of these stories, which are a little bit less okay. Let's take a minute to examine the most well-known recent example of this trend, The Fault in Our Stars. This book came out in 2012, and the movie adaptation followed in 2014. There's also a Bollywood adaptation coming in November. Really. It was written by John Green, who you might be familiar with from his other books as well as his work here on YouTube. It's by far the most popular example of this genre, along with being one of the least subversive, so I think it works great as a sort of generic template. The story follows a 16-year-old girl with cancer named Hazel.  While there, she meets another teenager in remission named Gus, and the two strike up a friendship. Obviously. This turns to a romantic relationship pretty fast. Obviously. Meanwhile, Hazel's condition appears to be getting worse, and she winds up spending time in the ICU. Hazel spends a lot of her time reading a book called An Imperial Affliction, but it ends mid-sentence, and the author refuses to tell anyone what happens next. Gus manages to get into contact with the author and uses his wish from the Make-A-Wish Foundation to get him and Hazel a trip to Amsterdam to meet him. Unfortunately, the author, a man named Peter Van Houten, is an old, bitter alcoholic who repeatedly insults their condition and refuses to tell them anything. They leave angry, but wind up enjoying the rest of their trip. They lose their virginity to each other, confess their love, and head back to the US. You know, teenager stuff. When they're back in the US, Gus reveals that his cancer has come back with a vengeance. His health worsens, and he dies only a few weeks after this. Hazel is heartbroken, and it's made even worse by her own deteriorating health. Van Houten shows up at Gus' funeral to apologize, and Hazel sees his actions in a new light, but she's still angry with him. At the end of the book, Hazel receives a letter that Gus wrote as an obituary for her, wherein he states that we don't get to decide whether or not we get hurt in life, but we do get to decide who hurts us. It ends with Hazel saying she's happy with the choice she made, and she has no regrets. Overall, I think the book is... fine? I can appreciate the actual prose of it.  At first, I thought it was weird that Hazel would be so humorous when she's dying, but partway through I realized that she was using it as a defense mechanism. The story and characters are mostly pretty paint by numbers, and I'm definitely NOT in the target audience, but I can appreciate that there was genuine effort and skill here. It wasn't a quick cash grab. The surface message is very good too.  This book is a very clear refutation of that, and that's a great thing to get out there to young people. But let's talk about the more problematic messages that these types of stories are sending unintentionally. Like I said before, everything is designed for maximum drama in the land of sicklet. The emotions and personalities are exaggerated to help get across the message, or just to make the reader feel more of whatever emotion is being pushed at the moment. The ending of The Fault in Our Stars wouldn't have seemed nearly as sad if Hazel and Augustus had stayed together for eight months, and then broken up when they realized that they had nothing in common except the cancer. Even if that would have been a lot more realistic.  There's no examination of what it takes to maintain a healthy relationship over the long term, which, let's be real, most young people could use a lesson in. Most people in general, really. If you're familiar with the comedian Jim Jeffries, then you might have heard this joke.  This is just a humorous take on the same idea, and it pretty clearly points out all of the strangeness in it. People are very interested in the beginning of a relationship and the end of it because that's when emotions are highest. The middle part is boring and no one cares about it, so that gets left by the wayside. But that's not the real issue here. It's a bit problematic, and it's not limited to this particular subgenre, but it's not the end of the world. The real problem is the title of this video, the romanticization of terminal illnesses like cancer. That probably sounds confusing, so let me explain. Cancer is a horrific illness that kills you extremely slowly, and most sicklet books acknowledge that. But at the same time, don't these stories also make cancer look kind of awesome? Look at the faults in our stars. Hazel falls in love with Gus, which is unambiguously a good thing, and it makes her happy for a while before he dies. If that's the case, shouldn't Hazel be glad she got cancer? If she never got cancer, she wouldn't have met Gus after all. On the surface, the book portrays cancer as a horrible thing, and let's be clear, it is. But that conflicts with the core theme of the entire book, that we shouldn't hesitate to form relationships with others just because we're afraid of being hurt, because the happiness makes the pain worth it. The love Hazel shared with Gus was good, therefore the fact that she met him was good. But she wouldn't have met him if they didn't both get cancer. Maybe an argument can be made that the message is really that you should just make the best of whatever happens to you, but again, cancer is portrayed as being an absolutely horrible illness that eats your body over the course of months or years. If all of that sounds like it contradicts the idea that Hazel's cancer led to something good, that's because it does. I know for a fact that John Green wasn't trying to secretly indoctrinate our youth into wanting cancer. In fact, the book was inspired by one of his friends who died of cancer. And he said later that he wrote this book as a response to illness being romanticized in literature. It's just that I think he did a bad job of it. The cute teenage romance, which I want to reiterate is outright said to be a good thing and worth the cost, is dependent on the characters getting cancer. Then look at Before I Die, another one of these books where a young woman named Tessa wants to experience the dangerous and fun side of life before her cancer kills her.  Her actions aren't always portrayed as harmless, to be sure, but her condition undeniably gives her a level of freedom most of us would love to have. She doesn't have to worry about her grades or her job or taking care of her health or maintaining any of her relationships.  It's grade A wish fulfillment right there, even if it's tempered by the fact that she'll die soon. Recently, a movie called Five Feet Apart appeared in American theaters, and strangely enough, it isn't, based on a book. It's all about two teenagers with cystic fibrosis who have to stay six feet apart at all times or risk infecting each other, but they decide to, quote, take one foot back and only stay five feet apart at all times. This, along with a couple other decisions from the film, is extremely dangerous, but it's portrayed as being liberating and fun, which some people with CF have taken umbrage with. What I'm saying is that the illness is all just a plot device. In all of these examples, it's trivialized to make a teen love story at best and outright making deadly illnesses look like the key to happiness at worst, since, as all teen romance stories have taught us, finding your true love when you're 16 is the real measure of success in life. And it gets worse. See, these types of stories don't just romanticize terminal diseases. They often romanticize dying of them too. At the end of Five Feet Apart, Cole Sprouse, I know his character has a name, but I'm calling him Cole Sprouse, reveals that he'll die soon.  It's not a very good movie. In A Walk to Remember, Jamie dies, but Landon now believes in miracles, and he's a better person. In Me and Earl and the Dying Girl, Rachel's death convinces Greg to be himself and follow his dreams. And I've already spent enough time talking about The Fault in Our Stars. In all these cases, the death that functions as the main emotional beat of the story is shown to have positive impact. There's never an example of someone getting depression after watching their loved one die and then succumbing to substance abuse, at least not outside of a tragic backstory. Sicklet isn't just about death. It's about having a pretty death. A death where you get to experience happiness, follow some of your dreams, and then have everyone be sad that you're gone. Dying was a good thing all along. There's never a story about someone becoming ill and dying right away before getting to do anything, because, well, that'd be boring. The thing that makes life worth living is not the end of it.  This next part talks about suicide, so if that bothers you, skip to this time. Among suicidal people, it's very common to experience the feeling that they're a burden to others, or they feel guilt over something, or sometimes they feel that if they kill themselves, then others will feel bad for the way they treated them in life. And the reason why most of those who suffer from suicidal urges don't wind up going through with it is because going through with it is scary. I can tell you from personal experience that if you told someone suicidal that they had cancer, they would most likely be relieved. They'd see an end to the pain, a light at the end of the tunnel. A commonly known factoid is that men die of suicide more often than women do, even though women attempt it more. The primary reason for this is that women's preferred method is self-poisoning, while men use more violent methods like shooting themselves. When survivors are asked about why they used poisoning, they often express a concern over who would find their body. They didn't want whoever found them to see a violent scene.  So in other words, romanticizing dying of cancer also romanticizes certain types of suicide, at least in the minds of those who are already struggling with suicidal urges. To a mentally healthy person, this probably wouldn't make that much of a difference. It's not at all uncommon for those suffering from depression to self-harm as a sort of cry for help. So if people start to put out the idea that when you start to die, you'll find your true love, well, you can see how that could affect a few people who already have severe problems. And I'm not blaming Hollywood or the publishing industry for the increase in teen suicides, so put your pitchforks down. I am, however, pointing out that they're taking advantage of a rise in depression and suicidal behavior, albeit unknowingly. And this is even more of a problem because these messages are wrapped up in others that are actually positive, like the Fault in Our Stars' message about not isolating yourself out of fear of getting hurt. The positive distracts people from the negative. And like I mentioned before, I think this is totally unintentional. I think authors just don't realize what they're doing, and in most cases are trying to write something that refutes pessimistic thinking. I would ask them to stop and find a better way of doing it, but I'm not going to bother. Partially because one YouTube video isn't going to reach many people, and partially because it's not going to convince Hollywood or the publishing industry to stop sucking on a golden tit. Sicklit stories are published by publishers and filmed by movie studios because they make money. They're businesses, and businesses are fueled by money. Any unsavory messages, even if they're unintentional, take a backseat to profit 100% of the time. And if you disagree with my conclusions here, that's fine. One of the wonderful things about all forms of art is that we can all see the same thing and come away with different interpretations. So let me end this by telling you to be aware of the sorts of messages that you're absorbing or promoting, even if they are unintentional. Thanks for watching, and thanks to Desk Brennan and all my other patrons. I couldn't do it without you guys. I'll see you next time. And if you are a loved one who's experiencing suicidal urges, please check out one of the resources below.


Well, this doesn't come as a surprise. You guys have known for the longest time that YouTube and major social media platforms like Facebook, like Twitter have been starting to censor people that they disagree with. Now, there's two camps over here. You have Camp A, the states from a libertarian camp, but it's a private company and this private company can do whatever they like. And I'm, I'm more or less on that side, but however, you also have the camp was saying, wait a second. This doesn't even behave like a private company anymore. You have government involvement, it's publicly traded companies. And for the, for the most part, it's not a free market. It's not a free market. You have governing bodies that are deciding how these private corporations behave. It's one thing if your private corporation, specifically not even a publicly traded company where you have 100% control over what your company does, no shareholders, no government regulations, etc. In this case, if we're looking at YouTube, which is Google, if we're looking at Twitter, these are publicly traded companies that are intertwined with government regulation, government policy senators, etc. And people make the case that this is more or less like a public utility company, such as the telephone. Recently, what has happened is YouTube is trying to silence the Mises institution. So yesterday, YouTube removed the Mises Institute video. The decision apparently lasts for all of eternity and cannot be appealed to an actual human. And it comes with a friendly warning because it's the first time this is just a warning. If this happens again, your channel will get a strike and you won't be able to do things like upload posts or livestream for one whole week. The video in question is a video from Tom Woods. If you guys aren't familiar with Tom Woods, well, fuck, have you been hiding underneath a rock? Go check out Tom's channel. His podcast is amazing. The video is Tom Woods titled The COVID Cult with more than 1.5 million views was recorded at a live event in Texas two weeks ago. It offered challenges to the official narrative surrounding the coronavirus, particularly with respect to the mask mandates. Woods talk featured several charts showing rises in COVID cases across multiple cities and countries, not long after imposing the mask rule, demonstrating how such rules apparently have little effect on slowing transmissions of the virus. Now, I'm not here to debate whether you agree with COVID or not, whether you agree with a mask or not. That's not the question. The question is very simple. We need to live in a society that promotes discourse, that promotes communication, that promotes different view points. We are at a point where we're seeing a precipice with technocrats, technology companies are the government. There's, you know, we have an illusionary appearance over here that, oh, we have YouTube and Google and Twitter. These, these are, no, they're not. No, they're not.  So this also happened yesterday, guys. YouTube also bans one American news as Democratic senators demand for more censorship. YouTube has suspended the pro president Trump, one American news network from uploading and posting new video material to YouTube for one week. The decision was handed down at the time when a cluster of cable and other news TV outlets, including OANN News Max are broadcasting and mobilizing Americans about the truth of the Trump administration fight to serve a second term by overturning the fraud of the 2020 presidential election. So YouTube said this on the issue for its November 24th banning of the OANN was for violating our COVID misinformation policies according to YouTube spokesperson Ivy Cho. In quotation, guys, in August 2020. When YouTube updated its policy regarding the misinformation and manipulating the media, the platform notably refused to prohibit users from posting false content on the outcome of the election or the manner in which states the local officials can't vote. As a result, the platform is now home to an onslaught of videos aiming to undermine the legitimacy of the election. For example, one YouTube video claiming evidence of voter fraud. What we're seeing here, guys, is like I mentioned earlier, we're having a technocratic elitist coupled with the government. Nothing new.  Absolutely all.  Nothing new. And what we're seeing is if you don't play by our rules, we were censoring you. If you don't think as we think we will censor you. So what we're seeing today, we have a huge group of people who are saying we have to stop YouTube. We have to stop Twitter. We have to stop Google from censoring us. Now I like to look at nature when it comes to stuff like this in nature. If we look at apex predators, if we look at how ecology evolves, we always see that a superior technology comes out, whether that is a mammal, whether that is a virus, whether that is a bacteria. And this superior apex, you can call it predator. I like to call evolutionary design is superior to the old technologies of that ecology and it overtakes it. And over time, it becomes dominant until a new form of technology appears. Now, when we have a group of people trying to fight YouTube and Google saying you can't censor us, it's a great fight. However, it's the wrong fight in my mind. The proper way to spend your energy and your time. Remember, time is the most important commodity and resource we have. We can't buy more time. We can always make more money. Instead of us trying to fight YouTube and fight Google and they can do what they want.  What we need to do is create better technologies. This is why I'm so bullish on the future of Web three and real decentralization and real monetization of social networks is we create better technology. So you you create a system, a free market where you let the market participants decide what we're going to have in the future is like, Hey, and, you know, maybe we're a couple of years away from now.  It was great. I love, you know, when YouTube was a wild wild west with like conspiracy and cat videos and like you can do, say what you want, do what you want. Like that was like the golden time when we go into the future, there's going to be a time where you're going to have this decision.  And so the actual technology being built is the solution. It's not lobbying. It's not screaming at Google, YouTube and Twitter. It's a very notion of let's take this energy and let's build something better because listen, these are just recent examples with me sees institution with one America, it's going to continue. And regardless of how loud you scream, regardless of how much you don't like what they're doing, it's not going to change the status quo. What you can do right now, whether you are a creator, whether a user is start helping other types of companies who offer better alternatives within the free market to create better solutions. And that's how I see us overcoming what's happening today. It's not, let's get more regulation. It's not, hey, let's knock on the shareholders door. No, it's create better technologies to supersede the old technologies. So I'll leave it at that, guys, YouTube continuing its massacre of freedom of speech. Yay, nothing new. Actually, a couple of things from you guys. Leave a comment below this video. Let me know your thoughts about this and I will see you later on tonight. Peace out.


Welcome back to Tennis Talk, my name's Cam Williams, and we have another big event this week on the women's tour leading into the US Open. The WTA 1000 event in Cincinnati, the Cincinnati Masters, and we had that playing in New York last year, so it was a change of venue after last year's US Open got pushed a little bit back. So Cincinnati is back at home, but there are some players that are not playing this event, so let's go to the withdrawal list. So having a look at the withdrawals now, we've only got two big names really that are not playing. Sophia Kennan, she's not playing, and Serena Williams also pulling out of this one. Alright, starting at the top of the draw, and there's a stacked draw here, we have a lot of top 10 players playing. World number one, Ash Barty. She's going to get a buy in the first round. The top eight seeds actually get a buy in the first round. She buys a qualifier in the second round no matter what, because we've got two qualifiers going at it in the first round. Then we've got Risk versus another qualifier. Winner of that plays either another qualifier or the 14th seed as a ranker in the second round, so you can already see a lot of qualifiers in this part of the draw. Then we've got the number nine seed and French Open Champion, Kredgikova, playing against Kazakina, who's been very, very good of late, very fun first round matchup there. Winner of that match takes on either the Wild Card McNally or Jastremska in the second round. Then we have another qualifier in this part of the draw, taking on the Wild Card Sloane Stevens. Winner of that match takes on the number eight seed, Muga Ruta. So a lot of qualies in this part of the draw, but the players that are not qualifiers are actually very dangerous, the top players. So of course we're going to be watching Barty this week. Didn't have a great Olympic campaign, but still is the Miami Open Champion from the start of the year and of course won Wimbledon, so you've got to watch out for her. Also Muga Ruta had a great start to the year on the hardcourt, almost beat Osaka at the Australian Open, so you've got to watch out for her on every hardcourt event. And I'm also looking out for Azarenka, the number 14 seed defending champion of course. She won this tournament last year after Osaka with Drew from the final. So interested to see how she can do this year because she plays well in the North American hardcourt season. She has a tough draw, but we'll see her maybe play Barty in the third round, keeping an eye on Azarenka. Going to the second part of the draw now, we've got the number four seed, Spinalina. She gets a buy in the first round. She'll take on the winner of one of the best first round matches going around, Sakari versus Kerber. Circle that one as one to watch. That is a huge first round matchup, and the winner of that gets to play the fourth seed. Then we've got Oztapenko versus Zedinsek. Winner of that match takes on either Alexandroba or the number 13 seed Brady in the second round. Then we've got the number 11 seed, Kovitava, taking on Keyes in the first round. Another one to watch. Winner of that match takes on either Kudomitoba or a qualifier in the second round. Then we've got Jabor versus Kondivate. Winner of that takes on the number six seed, Sfiontek in the second round. So players to watch out for, you've got to watch out for Sfiontek. Didn't have the greatest Olympic run. She actually lost pretty early on and was pretty disappointed with her efforts, but she can definitely rebound here on the North American hardcourt season. Got to watch out for her. Also going to keep an eye on Svetolina as well. She had a terrible week last week in Canada, but she is still the bronze medalist at the Olympics. So you've got to keep an eye on her this week. Maybe she can rebound from last week. And also keep an eye on Jabor. Had a really good week last week in Canada. So really interesting to see how she does. She might be setting up a blockbuster second round with Sfiontek. So keep an eye on Jabor because she is in some form. Heading to the bottom half of the draw now and we've got Pushkova, the number five seed. She gets a buy in the first round. She'll buy the winner of Puttenseva, who takes on a qualifier in the first round. Then we've got Pagola versus a special entry player that has not been announced. Very random that we see that. Winner of that match will take on either Lynette or the number 12 seed, Halep in the second round. So Simone Halep after falling down to the rankings is now having to play first round matches. Then we've got the 15th seed, Mertens taking on Potoroska. Winner of that match takes on either the Wildcard Stoza or Rabakina in the second round. Then we've got Bodosa versus Martic. Winner of that plays the number three seed, Sabalenka. So we're going to be watching out for the big guns in this one. Sabalenka had a great week last week in Canada and so did Pushkova. They actually played each other in Canada so they could be playing again in the quarter finals of this one. And you've got to watch out for Simone Halep. Still on the comeback trail, had a pretty disappointing result last week losing to the informed Danielle Collins. But Halep, you've got to watch out for her. Number 12 seed, we know she's better than that at her best. So watch out for her. She could set up a third round meeting between herself and Pushkova, maybe a Sabalenka quarter final as well. So keep an eye on Halep in this one as well. And the bottom quarter of the draw now, it's pretty stacked. We've got Andrescu, the number seven seed, getting a buy in the first round. She was taking the winner of Mukava versus Conta who were going at it in the first round. Then we've got Collins versus Rogers. Winner of that takes on one of the best first round matches going around. Vondrosava versus number 10 seed Benchage. A replay of the gold medal Olympic match only a couple of weeks ago. So keep an eye on that one. Can Vondrosova get some revenge? Then we've got the 16 seed Pavachenkova taking on the wild card para. Winner of that plays either the wild card Taikman or Kostya in the second round. Then we've got a qualifier versus Coco Golf. Winner of that match takes on the number two seed, Naomi Osaka. So a lot of players will watch out for in this one because it is an absolute stacked part of the draw. Obviously, you've got to watch out for Osaka. She made the final here last year. She's a US Open champion. She's the Australian Open champion as well. So we know she loves playing on the hard courts, also on Drescu. Disappointing last week in her match, Rain Delay did affect her. She's playing again on the hard courts and she is really defending a lot of points at the US Open in a couple of weeks. So keep an eye on Drescu and you've got to watch out for Belinda Benchage. Coming off her gold medal win a couple of weeks ago. Can she back it up in her first tournament back since the Olympics? So there you have it. There is the draw for the Cincinnati Masters for the WTA massive event. Stacked event, lots of big names. Anybody could win it really. It's a very, very stacked event and very even event as well. A lot of blockbusters that could be happening in the second, third, fourth rounds, quarterfinals.  Let me know down in the comments below. Who do you think is going to win this event? I mean, for me, it's a flip of the coin. Very hard to pick one winner, but let me know down in the comments below who you're picking for this week. So having a look at the draw, it's again said very, very tough for me to pick. But I'm going to go with the eager Sviontek. I think she has a pretty good draw. Top half of the draw is not as stacked as the bottom half. The bottom half of the draw has some absolute killers. And I think the top half of the draw is a little bit more manageable. But Sviontek might have to play Jaborra in the second round. That won't be easy. But I'm going to go with Sviontek to win this one. She hasn't won a WTA 1000 event on a hard court before. So I'm going to pick her to win her first one. But again, it's going to be very tough. Literally anyone could win this event. It's that open again. Let me know down in the comments below. Who is winning Cincinnati for the women this week? So the WTA 1000 event in Cincinnati. It's back in Cincinnati. And it has a stacked field.


What's up everybody? Jason here for jazby's casebase.com 2023 Bowman's Best University Football Delight Just sold out two box break number 15 random letter remember first name first letter guys, so you guys know how it works There's all the letters with combos roll It is a six and a one seven times one two three four five six seven seven times seven Nicholas down the Chad seven times one two three four We done a lm All right seven times seven times Nick you got SV Ryan with J Travis with D Simon with R David with K Steven with C Steve lot with M Kev with OP Steve with E all the letters not listed Nicholas with T Michael with FG Ethan with W Michael with a Steve with B and then Chad with lm All right that anti football guys is getting really close I'd say we sell a couple more teams guys. We can put this into an R&B and it really won't be that expensive I mean 49ers and Steelers will make it you know close to maybe $85 spot alone, but if we can trim down the remaining 50 60 70 dollar teams guys It could be we can get that done tonight guys Six of what you got I guess All right guys We go last two boxes here guys Cool photo for Ruben Owens our shooter sandwich the 50 letter s going to Nicholas And then we got Travis Hunter to 25 letter T going Nicholas. That's back-to-back kiss there, buddy Ruben Owens for letter R going to Simon to Monte Barnes letter J going to Ryan And then Jared versey another one for letter J going to Ryan I we got John Reese plumly and Jason Marshall letter J just killing this first box My first one letter D Dominic Lovelet or love it sorry out of 25 And how about another one for letter D? Devon Leary letter D Travis Both autographs there and then elements of the game to 75 Carson back For letter C going to Steve Steven. I should say Wilkerson. All right, that's the first box Cam rising for Utah letter C and then Javante Barnes to 50 letter J Are we got Dallas Turner for letter D and then Frank Gord jr. To 150 letter F Going to Michael L In Mecca to 100 for letter E and then Jarquist hundred for letter J Letter E is Steve Lockwood all edit letters not listed and then we have Carson Beck Letter C and then our first autograph is Graham Mertz letter G Which is Michael L FG combo and behind Jason Marshall for letter J who killed it Dante more for letter D He killed it in this one D and J just killed it in this one. There you go pro duck now Transfer to Oregon. All right, there you go So not the craziest boxes guys, but again, those was the last two of the case the case was pretty massive though So again next one that's up there number 16 is from a different case and should be some really really nice stuff I think in that one guys appreciate it. Jasper's case breaks calm


Hello, welcome to SSUnitex to seal this site and this is container son of PySpark tutorial. So in this video we are going to see what is the difference between stuck type and map type. So in the earlier of this video series we have already seen about the stuck data type and map type. If you haven't watched those videos then I would strongly recommend to watch those videos before going forward. So first we will see about the stuck type and then we will see about the map type. Then what is the difference between these two? So the main difference between stuck type and map type is that stuck type we define all possible key in the schema and each value can have different values and in the other hand for the map type we define the type of key and value. This is the pair we have to define here. So when to use stuck and when to use map. So let's assume we are having the data set which is having two columns like address ID and address. Under the address we have like fixed columns like it will be having address 1, it will be having city and it will be having country. So we are having something kind of fixed so on those scenarios we can use the stuck type. But in the other hand you can see we are having an employee data set and on that data set we can see we have employee ID and the accessories that is issued for that particular employee. So here you could see we are having laptop, we are having mobile for employee ID 1 and we are having headphone but for employee 2 only laptop and mobile has been issued. So on those scenarios we cannot specify the stuck type here because it is going to vary person to person. So on those scenarios we could use the map type. So in the map type we will be going to specify the key and value data types. So here the key value data type will be string only because laptop is string and apple is string. So if you are having these two type of data sets only then you can use stuck type and map type and this is the only difference between these two. Let me quickly go inside the browser and we will try to see in practical. So here as we have already seen in the slide we are going to create one of the data frame and it could be having two columns with address ID and address. Under address it will be having additional three columns with address 1, city and country. So let me try to create this data frame and we will see the output of this. So it will be going to have two columns. First is address ID and second will be address. So here under the address we can see it is having address 1, city and noida. So similarly how we can get three columns from this. So how we can parse this json. So we can simply use like df data frame that we have created df st dot. Then we can go with the select. Let me select all the column first. In the second column we can specify df dot address then dot which column we want under the address we want to address one column. So let me put this into another data frame and let me use display of this data frame one. Let me execute and we will see the output of this. Okay it is saying it is not defined because this is not df this is df st for the stack type. Let me execute it again. So now we can see it is having one additional column here and it is fetching address one. We can also provide the alias name like dot alias and here we can specify like address one. So this is we can provide the alias name. On the same hand if we want city then instead of using this address one we can go with the city. So it will be fetching the city there. Similarly if you want country then we can specify country. So it will be going to fetch country there. Now you can see. So by using this we can simply parse this json. Let me quickly go for the map type. So as I told you we have to specify the map type because the items are not static. So the key pair could be going to increase or decrease person to person. So on those scenario it will be having two columns first will be employee ID and second will be item. And here under the item we are going to specify the map type of key and value pair. So here this will be map type and the key data type will be string and the value data type will be again string. So this is we could specify. Let me try to execute this and we will see the output of this. So now we can see it is having the output like this. So on those scenarios how we can parse this. So for parsing any map type column we could use the explode function. So df empty is the data frame dot let me select and here let me specify as tick. And so second we have to explore this items column. So before that we have to import the export function. So we can go with pyspark dot SQL dot functions then import and here we can go with explode. Now here we could use the explode function and which column we want to explore. So we want to explore this items column. So we can simply specify items here. Let me execute it. So let me use the display of this. So we'll see the output of this explode function. So it will be going to parse. Okay. So here let me remove this bracket and let me add the bracket here. Execute it again. So as you could see this has been passed. Now it is having two columns. One is the key and second is the value and ID one is having total three items. So it is repeated three times and ID two is having two items. So it is repeated two times. So I hope guys you have understood how we can use the stuck type and map type and what is the difference between those two and on which scenario we should be using the stuck type and on which scenario we could be using map type. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. See you in the next video.


Khande West, also known as whatever Khande West is called these days, I think that he is metabolizing a lot of energies, a lot of different energies that are kind of hard to hold together. And so sometimes, because he's, he's, you know, a very gifted person at, at channeling things from into music from, from the collective. And so that because he's metabolizing so much energy, that energy can move him around sometimes into places that seem, you know, a little unhinged, that, that kind of deviate from, you know, and he's looking for, for an anchor, he's looking for, for a tether, and grasping on to things that may not actually be that reliable. And I guess I would, um, yeah, and also because he's, you know, so famous, I mean, he's part of those energies is all the projections that are loaded onto him, and the judgments. I don't envy him. And, you know, if he goes off on something and becomes unhinged and goes through that journey, then I pray for him that he will be received with welcome and love upon his return. Thank you. David Ike. He is his, his role is to apply a certain lens and inhabit a certain mythology about the way that the world works. And to develop that, because it is a mythology or a world story that is an important way station for a lot of people as they exit the old story and are in some sort of search for a new one. And here's a way station. And that mythology that he offers, I don't mean that mythology in the sense of it's just fantasy. It offers, it illuminates a lot about the world. And it also obscures a lot about the world. And there's a lot of truth that is unavailable from within the, the capital C conspiracy theory. To explain the workings of the world. And there's also a lot of truth in it. And ultimately, there are world stories that contain and include the one that he offers in a much, much bigger picture. Daryl Davis. Daryl Davis. I don't know who that is.  Oh, yeah, yeah, yeah, I know who that is. Yeah. Yeah, he is a servant of the spiritual being called the universal brotherhood of man. And his soul's journey is the journey of the world. And it's a journey of his soul's journey is part of a mass movement now, to learn to see the divine in all human beings, and to refuse the degrading stories that we are offered about our fellows. And so he's helping create the template for that, or strengthen the template for reverence, for, for seeing beneath the opinions, however hateful they may be, and not accepting those as who you really are. Your videos froze for a second. I want to ask one more. And then I'm going to pass the game. This is a fun game, by the way. This is a fun game. Elon Musk. Yeah. Yeah. I've been talking about a receptacle for people's projections and judgments. He's kind of a mythic figure, in the sense that he's larger than life, which makes him a projection screen for, you know, all kinds of of archetypes that people associate with him. He's somebody who's who's very adept at holding a reality for others to step into. That's how he creates these companies. When he says something shall be, people believe him. And I wrote one essay that referenced him quite a lot. That if most people if you say, well, you know, what's the future going to be like? They take that as an invitation to predict. Whereas Elon Musk will take that as an invitation to create. Oh, I'll tell you what it'll be like. Here's what we're going to do. Here's what's going to happen. Because I have agency in this. So one reason that he's so appealing to people is that is his strong embodiment of sovereignty, of agency, sovereignty, meaning, actually, the word actually means above the king, above rule, above the rain. So sovereign is super, right? Super rain, like, so you're, you're not a subject. And that kind of, and okay, and there's I'm sure many, many other dimensions to his personality. I've never met him, you know, but I know people who know him. And I'm sure he's, I know that he's a complicated person, etc, etc. But, you know, as a public figure, as a mythic figure, you know, this is, this is, and as a human being, this is one of the things that he brings to the world as a reminder of our agency. And, you know, he doesn't, in my opinion, he doesn't always use that for good things, that, that, you know, that I support, and that are part of my vision of the future. And sometimes he does. And, but it's that that the, but his appeal, his charisma is because of his embodiment of that principle of sovereignty. He has no problem being here. And saying here's how it will be. Aspen, do you want to throw one in there? Or do you want to go on with your question about? Do I want to throw it in there? I don't think I have one off the top of my head. I'm just really enjoying this. I mean, the Kanye West, wow, that really pulled me away the metabolizing of energy that feels so true. When I hear it, and I just love this. See, let me tell you what how I'm doing what I'm doing here. It's really simple. I just find a part of me that loves these people. Yeah, the true nature of someone is only available through love. Otherwise, there's going to be a lot of projections, you know, of one's one's own shadow. But if you find the part of you that that loves them, then you can see so much, so much more.


It's time for an IonMPI and special thanks for Digki for helping IonMPI happen This has been a fantastic partnership, and we are pleased to have the next IonMPI All right, we'll intro like that. I can't get wrong and Stay tuned because we will have a special treat you asked for it We have the extended version of that we'll do that right after we finish showing this week's IonMPI What is it? Okay? Well, this IonMPI is actually kind of interesting because last week we did an ST chip and Normally I try to like switch it up But I was subscribed to Digki's new products RSS feed which I recommend people go to it's in the post that will come up afterwards and I got a notice of a new STM32l4 chip and I'm also interested in new mic controllers because You definitely see like companies coming up with new chips when they see what competitors are doing and they come out with something a Little bit better. Just a little bit like a skateboard trick Improvement over the SAMD 51 and this is the STM32l4 P5 which is a totally fresh new Cortex M4 chip set from the STM32. So it's got kind of what I like It's an M4 you know with FPU and it's running at 120 megahertz and it's got a lot of pins But it comes in a bunch of different packages from like a 48 QFN all the way up to like a 196 BGA It's got like, you know five mega sample per second ADC. It's got dual DACs It's got like built-in op-amps for some reason all these like cool peripherals Do you expect it's got CAN bus which is a nice addition as he has a nice well documented CAN bus It's got full speed USB not high speeds. It's like the one thing that is kind of standard Yeah, I got a discovery board. There's also a nuclear board. You can get the chips right now They're only available the kind of two sizes, but more package the day sheet says there's more packages coming So there's this massive 144 QFP which is on the Nucleo 144 and there's also this discovery board which has the BGA which I think it's it's actually this chip in the middle here It's like a super maybe it's this chip Hold on It's this chip. Yeah, so this is like a help ultra fine pitch It's like a point probably a point four point five millimeter BGA The discovery has like all this RAM built-in, you know You like flash and and memory because it has external memory control that you can use You can it's got you know up to about a megabyte of flash 320 kilobyte of s-terms It's a nice little upgrade But the really interesting thing I saw because it's kind of got all the standard stuff, right? So what peripherals are they added that are kind of new and unique and what they added that's new is a TFT controller So this is a little unusual Sometimes we'll get chips that have like an 8-bit controller like a like a 6800 or 8080 TFT so okay, you know, you want control in iLine 93 41 This series of chips comes with a full 24-bit LCD TFT controller with the full h-sync v-sync Data enable and clock. This is unusual. I haven't really seen I don't think I've seen the Cortex m4 that has a full 24-bit LCD TFT controller and it usually that's reserved for like the Cortex m7s like we saw this added to Like the IMX RT series or the STM 32 f7 or h7 series those might have it This is interesting because the Cortex m4 so it's a you know lower power lower cost and It has a built-in graphics like pallet driver. There's all sorts of things. That's all the cool stuff Yeah, this is all the extras you can see there's that display driver And of course, you know touch you can have capacitive touch as well for it It's got you know parallel interface got camera input So all that stuff is is pretty standard, but the TFT. I think was very interesting especially since you can connect that up to a TFT to HDMI converter and Turn it into an HDMI output and again, you know that the way they manage it is there's graphic controller that has a pallet 256 colors at a time 24 bits and that's how you can actually fit You know a 480 by 272 or 320 by 320 display in memory It's still have enough memory to do what other you know connectivity wireless or Bluetooth. So nice little chip I am super interested. That's why I got the dev boards. I think we'll probably get circuit Python running on these Since it's a l4 series and we support the F4s it shouldn't be too difficult to get it working at least the basics You can pick up chips From did you key right now in addition to the nucleo board and the discovery board which I recommend because of course They're all put together and like ST dev boards are really cheap You get a lot like they're only like 20 30 bucks We get like the debugger the RAM that you know Arduino compatible footprints little adapter those plug-in grove connectors But the STM 32 L 4 p5 is the series so search for that And more packages are coming so far There's only two packages like a tons of pins But they're definitely coming out with the gonna be smaller and cheaper 48 Q of fans, and I'm very excited for those Okay, and that was I on MPI. That's right Now you all asked for it you said I like that song so much but I want more I want more so we'll premiere extended version of I am pay I The full Made by Tom who's in the UK who works with Ada for you. Here we go You know I do read the comments and someone said I want that and I said absolutely. It's great sounds. I was on MPI It's a bop. Okay