Data Analysis for Tampa Bay Times
More than 200 Republicans have donated to get abortion on Florida ballots
I used Python, SQL and Excel to join campaign contribution data to Florida's voter data to learn the demographics of Floridians supporting the pro-abortion access campaign.
A campaign to let Floridians vote on abortion rights protections raised more than $17 million in 2023, largely funded by women, a Tampa Bay Times analysis of new data shows. And while donors are overwhelmingly Democratic, money has also come from more than 200 Republicans in the state.
“Personally, I tend to vote Republican in most cases, but abortion is a sticking point for me, and I appreciate that I will have an opportunity to vote to keep this issue separate,” said Jennifer Ninesling, a 57-year-old Republican in Melbourne who made two donations totaling $603.
#Python #SQL #Postgres #ExcelIt’s not your vote that Biden and Trump seek on Florida’s social media. So what is it?
I used Python, SQL and Excel to analyze political advertising data from Facebook and Instagram to learn that unlike previous election cycles, presidential candidates are not battling out for votes in Florida but still seeking donations from the state.
“Floridians are being asked to donate to pay for ads — both digital and TV — that are aimed at convincing voters outside the state,” said Travis Ridout, a director at Wesleyan Media Project.
#Python #SQL #Postgres #DatawrapperFlorida polling average: president, Senate, abortion and marijuana
I collected polls for president, senate and the abortion and marijuana amendments in Florida to make semi-automated charts showing individual poll results along with an average weighted by recency and pollster quality, according to ratings from news outlet FiveThirtyEight.
Here are the latest Florida polls for the 2024 general election races for U.S. president, U.S. senator, Amendment 3 to legalize recreational marijuana and Amendment 4 to protect abortion access.
Former President Donald Trump and U.S. Sen. Rick Scott, both Republicans, lead their Democratic opponents, according to a Tampa Bay Times average of more than a dozen polls since late August.
Trump and Scott are polling ahead of Vice President Kamala Harris and former U.S. Rep. Debbie Mucarsel-Powell in the races for president and U.S. Senate, respectively.
Polls also show strong support for the state’s two major ballot initiatives, on marijuana and abortion. They need 60% of the vote to pass.
These charts show individual poll results along with an average weighted by recency and pollster quality, according to ratings from news outlet FiveThirtyEight.
Surveys aim to capture a snapshot of public opinion at a certain point in time. Most polls have a margin of sampling error of a few percentage points, meaning they are expected to slightly over- or under-estimate popularity due to randomness alone.
Election outcomes can differ significantly from poll results. In 2020, major polls generally underestimated Trump’s performance in Florida.
Tampa Bay traffic jams as thousands evacuate before Hurricane Milton.
Used Python to query APIs, informing reporting during Tampa Bay’s most intense hurricane season in a century, covering three hurricanes in one year. Delivered urgent real-time traffic updates during evacuations and storm-related road closures, while also providing historical storm data to contextualize the events.
#Python #API #DatawrapperKamala Harris inspired a coconut craze. In Florida, the tree has a history.
In a viral video of remarks the vice president made in May last year, Harris recalls her mother saying, “You think you just fell out of a coconut tree?” Harris laughed, then said, ”You exist in the context of all in which you live and what came before you.”
#Python #QGIS #DatawrapperWhy Florida medical marijuana companies are pushing so hard for recreational pot
I used Python and Google Pinpoint to scrape a government website and the content of PDF files.
As legal marijuana dispensaries hope Floridians vote in November to allow recreational weed, they face a troubling trend: Right now, their flow of new customers is drying up.
The state’s medical marijuana industry is stagnating, data shows. Experts say a slowdown in new patients means the success of the largest marijuana companies in the state could depend on the proposed amendment.
Florida Democrats hope this Tampa race helps end a GOP supermajority.
Used SQL and Python to analyze voter registration data, campaign finance data and historical voting reports and to draw insights on Democrats' chances in Florida during the 2024 general election.
#Python #Mapshaper #Datawrapper #SQLAbortion, weed donors make Florida ballot questions highest-funded in US
Used Python and Excel to analyse campaign finance data from Florida Department of State and Open Secrets to uncover trends in the highest funded ballot questions in the US.
#Python #Excel #DatawrapperCalls to Florida gambling help line doubled after launch of online sports betting.
I sourced hotline data to reveal a spike in gambling addiction following a controversial launch of sports betting in Florida. Jennifer Kruse, executive director of the Florida Council on Compulsive Gambling, said increased access to online gambling is likely one factor for the spike in calls to the help line. But she cautioned that it’s too soon to fully evaluate the impact of the Hard Rock app’s launch.
Excel #DatawrapperNot Democrats, not Republicans. Who are Florida’s independent voters?
Polling independent voters is very expensive so their behaviour is opaque. I used SQL to create a dataset of voters who had switched their party affiliation since the last election and understand independent voter trends.
#Python #SQL #Postgres #ExcelIVY NYAYIEKA | Times • Source: Office Of Medical Marijuana Use
4/20 is the busiest time of year for Florida’s medical marijuana dispensaries
I used Python and Google Pinpoint to scrape a government website and the content of PDF files. The data analysis revealed the consumption of medical marijuana spiked on April 20th every year
#Python #Excel #Google Pinpoint #Web Scraping #Datawrapper
After Florida left voting system, tips about illegal voters plummeted
When Gov. Ron DeSantis opted last year to remove Florida from a multistate voter data-sharing agreement, advocates and elections officials feared it would become harder to detect illegal voting.
New data shows they might be right.
DeSantis’ voter fraud unit last year received 93% fewer referrals from other states about double-voters than it did the year before, an analysis by the Times/Herald shows.
Data Analysis for CJS
Banned Books
I collected historical data on banning of books globally, categorised them and made plots on Python and R/ggplot which I transformed in Adobe Illustrator. I also zoomed in on banning in the United States
#Python R/ggplot #Scrollytelling #Excel Adobe Illustrator #Regex #Flourish #HTML/CSS #ai2html
Water Woes in the Bronx
Explored NYC data and found it bizarre that water problems featured prominently. I spoke to experts and residents, ran data analysis, made visualizations, wrote the story, and published it on Rentwire.
#Python #Datawrapper #GISMapping #Excel
Stock options offer tax advantages for tech companies.
I automated the extraction of details from the cash flow statements of different companies for SEC filings. By analysing the top 100 companies by market capitalization in the United States, I found that companies are receiving significant tax benefits from granting stock options. Notably, technology companies exhibited markedly lower effective tax rates compared to their non-tech counterparts, a disparity that was statistically significant even when controlling for all other variables.
Python Playwright R/ggplot Regex #Datawrapper Scraping
3D printing will reduce cost and time necessary for ship repair but impact on labour force is complex.
Analysis in which I explore trends in the shipbuilding and repair industry as 3D printing takes root.
R/ggplot Adobe Illustrator #Python #ai2html #HTML/CSS #SentimentAnalysis Scraping Spotify
Nairobi Sunshine
Scraped data on daily temperature, daily sunshine duration and daily shadow lengths to write a satirical data journalism piece about why Nairobi receives the best sunshine
#Python R/ggplot #Datawrapper #Adobe Illustrator #Canva #Regex #HTML/CSS #ai2html
Modelling education outcomes across Kenyan counties
I collected data on education access levels across Kenyan counties and joined it to socioeconomic factors that contribute to access, making a model through multiple regression analysis that can predict access levels by 95%. Given the strong model, the outliers are remarkable.
Python R/ggplot Adobe Illustrator Regex Regression Analysis QGIS Tabula #HTML/CSS
Scraping Kenya Government Gazette Data
Creating a database with a list of the issue of new land title deeds in Kenya: This is a project scraping HTML pages of weekly Kenya Gazette notices starting from 2010 in order to retrieve and categorise land-related notices. The result is a database with more than 200,000 rows of land-related notice entries.
Python Pandas Regex Scraping #HTML/CSS #QuartoYoung Kenyans, especially women, are using a tiktok challenge to discuss dangers they faced in high school
For this project, I scraped TikTok and analysed all the videos in the why are you lying challenge, creating a database with necessary columns such as video links, creators, number of likes etc. Through the challenge trend on tiktok, hundreds of young Kenyans talked about mistreatment in their high schools. I then further categorised the videos one by one, spoke to affected alumni and experts and wrote the story whose publication is upcoming.
Python Excel Regex Scraping TikTok Pandas
Cost of education in Kenya continues to rise but teachers still earn minimum wage
In addition to scraping the government statistics website to make a database of cost of living trends across time, I called all the top ranked schools in primary education to find out the cost of kindergarten.
Python R/ggplot Adobe Illustrator Regex #Datawrapper Scraping #HTML/CSS #ai2html
anthem analysis
I analyzed data for national anthems across the world in terms of musical qualities and then in terms of lyrics to see the impact of religion, colonisation and geography on trends in danceability, positivity and mood.
R/ggplot Adobe Illustrator #Python #ai2html #HTML/CSS #SentimentAnalysis Scraping Spotify
NYC parks are battling graffiti's comeback after the pandemic
In Riverside Park, spring is an almost season. Yellow and white flowers are almost blooming. The cherry blossoms are almost pink, the sun is almost egg-yolk yellow. All the colors nature offers almost make up for the art that was lost when Amtrak painted over historic graffiti in the park’s Freedom Tunnel...
Python R/ggplot Adobe Illustrator Photography #Datawrapper #Flourish #HTML/CSS
Impact of election years on Kenya's national examination results
This is an analysis to investigate impact of election years on Kenya's national examination results. There were data collection constraints which made it impossible to make a global conclusion from the analysis. For the data available, whether or not it is an election year does not affect the grades of candidates scoring the highest marks in Kenya's national examinations. Additionally, top candidates taking their national examinations in Kenya on election years are not likely to get higher or lower scores than candidates taking their exams on years when there are no elections.
Python Excel Regex Scraping TikTok PandasNews Stories
Running as Equals
CNN
As an ambitious, determined teenager, Annet Negesa urged her body to run faster, and her body, always loyal, obliged her...
Remote working is a lifeline for Kenya’s beach resorts
Economist
On beach beds under palm trees in Kenya’s Diani Beach, the usual throng of swimsuit-clad tourists dozing in the sun has been replaced by a more industrious crowd of laptop-bashers. Over the sound of the ocean comes the murmur of business jargon. Above the gurgling call of black-and-white colobus monkeys reverberates the cry of the anguished executive: “I’ll circle back by COB.”...Matatu Women: Going it Alone in Nairobi
Commonwealthwriters Forum
Monica’s life seems lonely to me. Not in the way that standing at the airport alone, after your lover says goodbye, is lonely. It is lonely in the pleasurable way that reading a book is. Every weekday at four a.m., Monica gets up. With only Nairobi’s cold morning breeze for company, she leaves her house and heads to Nyayo Estate Gate B: a twenty minute walk.Woman, Kenyan and on the campaign trail
Huffpost
To put up her campaign posters, Cynthia Kihu, 26, cannot afford the luxury of shunning darkness. At 10p.m., she ventures out into the Nairobi night which grows frigid as if punishing her for enjoying the sunshine that flirted with her during the day.Media Production and Staffing
Uganda's Fight Against Massive COVID Vaccine Inequity
VICE News
Global health officials say African countries are hard hit by vaccine apartheid. While developed countries re-open and COVID-19 infections are on the decline, low-income countries are now facing crushing third waves. Globally, less than 2% of vaccines for COVID-19 have been administered in Africa. VICE News goes to Bidibidi, Uganda's largest refugee settlement to follow the limited rollout there and see how health workers there are scrambling to manage logistics and vaccine skepticism.
Millions of lives at risk as famine stalks Horn of Africa
ABC News
In northern Kenya's drought-stricken Turkana County, a group of children carried sacks of palm fruit atop their heads as they walked across the parched earth back to their tiny village.
In a New Country, a Single Mother Sharpens Her Business Skills
NYT
As violence broke out in South Sudan, Esther Meling left with her family, some clothes and two pans. In Uganda, she found help starting over.Business Features Production
Meet Fadi: a businesswoman and mother who's defying the odds
Cameroon
After losing her brother and baby due to conflict in Cameroon, Fadi is rebuilding her life by setting up her shop. Now her business is the only one in the village run by a woman.
Photo story: a day in the life of a mobile health van in Yemen
Yemen
At 7:00 in the morning, the mobile health team – which includes a doctor, vaccinator, pharmacist, nutritionist, midwife, and community health supervisor – prepares itself for the journey ahead. In the EU-funded health center, IRC’s health team pharmacist Abdulbari Nasr decides on the medicine and supplies he’s going to take with him for the day.
Meet Abigail: the business owner who started her own beauty salon after conflict changed her life
Nigeria
“Our society does not provide a lot of job opportunities for women. Most women are not used to doing business to make some money. They end up staying at home to take care of their children and the house chores.”Memoirs
Needing
Down River Road
The food at our office canteen tasted a lot like my job felt—bland. I cannot say that it was always bad. But I’d lived with a Senegalese woman and a Zanzibari woman for a total of two years and the transition from their delicious food to the canteen was brutal...
Places
Okasungora
I feel sometimes when I travel that my soul stays in Nairobi and has to catch up with me the way the words of a long distance sort-of-friend lag in the air between you during a phone call. Maybe in that time when my soul is outside of my body journeying towards me, fire and water and wind find it naked and mold it into something else. Sometimes in the protestant way i believe my life to be a result of an algorithm, and that there is no way for me to change how things turn out. Waiting on my soul in new places causes some mutation, reminds me that i can alter the computer code. In the year leading up to April 2020, I decided to diarise some of my soul’s journey as my body moved...
Adili
the point of this project is to say i spent a year taking a greedy gasp of air, squeezing my nostrils and diving into myself and retrieving knives i left in my body.
© 2023 — Ivy Nyayieka
