Jonathan Soma

tabletop. Tabletop.js gives spreadsheets legs

mapsheet. Easily create interactive maps from data in Google Spreadsheets. Supports Google Maps, Leaflet, Mapbox, MapQuest, etc.

natural-pdf. A friendly library for working with PDFs

selenium-github-actions. Python

persine. Persine is an automated tool to study and reverse-engineer algorithmic recommendation systems.

flatware. S3 caching of Google Spreadsheets for Tabletop.js

fuzzy_pandas. Fuzzy matches and merging of datasets in pandas using csvmatch

kull. A tool to interactively select text regions of PDFs and images. Mostly for use with PDFQuery or tesseract (UZN/OCR zone files)

gs-spreadsheet-manager. A slightly more object-oriented, ORM-y, and altogether pleasant way of dealing with Google Spreadsheets when using Google Apps Script.

spotify-langchain-gpt. Building Spotify playlists based on vibes using LangChain and GPT

nicar25-ai-images-video. Jupyter Notebook

designingviz. A step-by-step design guide for data visualizations

raphael-radar. Raphael Radar is a JavaScript library to draw a controlable radar chart using Raphael.js, a JavaScript library to draw SVG

py-reform. A Python library for dewarping/straightening/reformatting document images and PDFs

action-electron-forge. :electron: GitHub Action for building and releasing Electron apps

tesseract-uzn. Simplify using uzn files with tesseract for OCR

hexagon-grids-for-adobe-illustrator. A simple script to automatically build hexagon grids in Illustrator, for things like D3 hex cartogram visualizations

simplified-scrollama-scrollytelling. Non-d3, barebones version of scrollama.js scrollytelling examples

python-disease-modeling. A walkthrough of how SIR infectious disease modeling works, along with a do-it-yourself Python COVID model that you can use to simulate a lockdown.

ai2html-walkthroughs. Code samples for ai2html walkthroughs

storytelling-2015. HTML

NICAR20-geocoding-apis. Geocoding APIs repo for NICAR20 session

clipped-and-georeferenced-images-from-google-earth-in-qgis-3. Georeference images from Google Earth in QGIS 3, then clip them so they aren't shaped all weird.

nicar23-huggingface. Jupyter Notebook

data-studio-projects.

autoscraper-changes. Tiny template that uses GitHub Actions and Python to automatically scrape the BBC's homepage every four hours.

ire24-scraping. Tutorials for IRE 2024 about using Playwright to scrape state-level license and violations data

nicar25-ai-newsroom. Jupyter Notebook

nicar25-passive-scraping. Passive scraping for social media (HAR and WACZ to the rescue)

d3-topojson-data-guide. How to wrangle your data into a useable TopoJSON format for making D3 visualizations

chatgpt-for-educators. Slides for a talk about the use and abuse of ChatGPT in the classroom

page-templates. HTML

NICAR20-intro-d3. Base for an introductory walkthrough of D3's features for NICAR 2020

mediaparty-folktales. Notes and code for learning Hungarian folktales through semantic search and GPT: Media Party 2023 lightning talk

abraji24-ai-audio-video. HTML

hardboiled. A node.js detective kit for investigating how web sites are built.

interactives-class-content.

nicar23-building-ai-editors. Conceptual framework for building AI editors to help with journalism workflows

nicar24-beyond-chatgpt. Jupyter Notebook

playfair-projects. Common repository of projects for Playfair

2023-abraji-ai-workshop. Journalism in AI workshop for Abraji 2023

abraji25-pdfs. Jupyter Notebook

quarto-tutorial. Quarto framework tutorial for C+J/European Data Journalism Conf 2023

data-studio-projects-2022. Projects for Columbia J School's Data Studio 2022

lede-notes. Notes from Summer 2015's Lede Python class

dataharvest25-ai-images-video. Jupyter Notebook

NICAR20-apis. Jupyter Notebook

nb2jekyll. Use nbconvert to convert IPython/Jupyter Notebooks into Jekyll-compatible Markdown + Front Matter

final_final_v2_truefinal. JavaScript

lede-projects-2023. Projects for Lede Program 2023

excel-tutorials.

bad-air-cities. An auto-updating website of major cities' air quality index

2023-ona-before-beyond-chatgpt. Slides and links for AI Tools from Before (and Beyond!) ChatGPT (ONA 2023)

data-studio-projects-2024. Python

lede-projects-2022. Projects for Lede Program 2022

data-studio-projects-2023. Projects for Columbia Journalism School's Data Studio course, Spring 2023