Skip to content
View jessmahone's full-sized avatar
2 followers · 3 following

Block or report jessmahone

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
jessmahone/README.md

Hi, I'm Jessica. 👋

Researcher turned analytics engineer. I spent 10+ years studying local news ecosystems, and somewhere along the way, I became more interested in building the systems that make the research possible than in the research itself.

📚 Projects

100 Communities Local News Database

Cleaned, normalized, and structured 16,000+ local news stories from 100 U.S. communities into a queryable database for research into local journalism health and content patterns.

Survey Data Pipeline: Google Sheets → R → Google Sheets

An R pipeline for analyzing survey data without touching the local file system. Raw data lives in Google Sheets, is processed in R, and results are written back to Google Sheets for use in downstream tools like Datawrapper.

Podcast Metadata Pipeline (in progress)

An analytics engineering pipeline transforming Podcast Index API data into content strategy and market opportunity data marts using R, dbt, and PostgreSQL.

News Classifier (future)

A generalizable, locally-run LLM pipeline for categorizing news content at scale.

🛠️ Tools

  • Languages: SQL, R, Python
  • Databases: PostgreSQL, MySQL, SQLite
  • Transformation: dbt
  • Analysis & Visualization: RMarkdown, Datawrapper, Tableau
  • Other: SPSS, Stata

🤝 Connect with Me

Popular repositories Loading

  1. local_news_100_communities local_news_100_communities Public

    Conversion of csv datasets into SQLite and Postgres databases

  2. jessmahone jessmahone Public

    This is my profile for my Github portfolio

  3. podcast-metadata-pipeline podcast-metadata-pipeline Public

    A dbt + PostgreSQL content metadata pipeline built on Podcast Index data

    R

  4. survey_data_pipeline survey_data_pipeline Public

    A simple Google Sheets -> R -> Google Sheets pipeline for analyzing survey data that does not require local files