After the Rainbow — Pride Coverage, 2015–2026

"I'm building a MotherDuck Dive for the DiveMaxxing hackathon analyzing 11 years of LGBTQ+ Pride news coverage using GDELT data. Help me build the BigQuery → MotherDuck pipeline: pull Pride-related articles from gdelt-bq.gdeltv2.gkg, May–July each year 2015–2026, filtered to a curated list of 85 US news outlets, and load it into MotherDuck."

"Build an interactive dashboard Dive on this data: a bar chart of article volume per year colored by sentiment, a theme breakdown that responds to clicking a year, an outlet comparison line chart, and an organization explorer with year tabs. Use live SQL via useSQLQuery."

"Now make a second editorial version — an NYT-style scrolling data essay where the story leads and the data is supporting evidence. Light cream newsprint aesthetic, Playfair Display + Lora, narrow article column, with restrained Pride color accents. Keep all the interactive widgets but frame them as evidence below editorial paragraphs."

"Verify every factual claim against the data before writing it. Check the actual volume peak year, the Disney mention counts across years, which themes appear in which years, and the outlet sentiment averages. Correct the narrative to match what the data actually shows."

"Fix the sentiment color system so it's intuitive — green for neutral/positive, amber for mid, red for strongly negative, not flipped. Apply it to the bar chart, theme badges, and org badges."

"The outlet line chart is wonky where outlets have missing years. Either fix it or add a footnote explaining the data gaps. Also make GDELT secondary in prominent text so non-technical readers aren't hit with the acronym in headlines."

"Add scannable bold highlights to key insights in each editorial paragraph, and have each bolded phrase cycle through a different Pride flag color as you read down the article."
That's seven prompts, in order, that honestly represent the build. Add or trim to taste.