I specialize in what is called computer-assisted reporting. Journalists in the past were often hack novelists. I'm a hack computer programmer. I use computers to collect, organize, analyze and present large amounts of information.
This past April I returned to my alma mater, DePaul University. It was a thrill to see the school's new Center for Journalism Integrity and Excellence, which was recently established by veteran journalists Carol Marin and Don Moseley. I got my start in journalism thanks to Carol and Don at an internship program they established at DePaul. As part of the trip, I was honored alongside Lester Holt of NBC News in the center's inaugural round of journalism awards.
Today the California Civic Data Coalition released a new open-source tool that enables the Django web framework to more quickly export comma-delimited data. Version 2.0 of django-postgres-copy, now available on the Python Package Index, extends Django’s database tools to support PostgreSQL’s powerful COPY TO command. Found only in PostgreSQL, COPY TO can write out tables with millions of rows in a matter of seconds.
Even with a new law that has boosted kindergarten vaccination rates to record highs, hundreds of schools across California still have so many children lacking full immunization that they pose an increased risk of disease outbreaks, according to a Times analysis of state data. Look up each kindergarten’s 2016-17 rate below. The state does not release data for schools with fewer than 20 students.
Muck Rack makes it simple to find people, tweets, or articles that mention any name, keyword, company, hashtag etc. We've compiled this guide to help you make the most of your search.
Selecting a term
Start searching tweets, articles from media outlets, articles mentioned in tweets, journalists'
names, titles and bios with some suggested searches:
Companies or Topics (e.g. iPhone, Microsoft)
Phrases (e.g. "cloud computing") — use quotes to keep the terms together
Twitter handles (e.g. @username) — returns those who have mentioned or replied to
Names (e.g. "David Pogue")
Hashtags (e.g. #sxsw, #london2012)
Bio details (e.g. vegan, Olympics, father)
Muck Rack's Advanced Search allows for many boolean operators.
Find results that mention multiple specified terms, use AND or
+. For example, ensure each result contains both Elon Musk and Mark Zuckerberg by
searching Obama AND Romney or Obama + Romney.
Use the operators OR or , to broaden your search when you'd like either of
multiple terms to appear in results. (This is the default behavior of our search when no operators
are used.) For example, search for democrat OR republican to find results that refer to
Democrats and/or Republicans.
Use NOT or - to subtract results from your search. For
example, searching Disney will yield results about the Walt Disney Company as well as Walt Disney
World Resort. To exclude mentions of Disney World, search for Disney -World or Disney
When using one of these operators with a phrase, enclose it in quotation marks. For example, you can
find results about smartphones excluding Apple's iPhone 4S by searching smartphone -"iPhone
Exact case matching or punctuation
If you're searching for a brand name or keyword that relies on specific punctuation marks or capitalization, you can
find results that match your exact query by adding matchcase: before the keyword you're searching for, like matchcase:E*TRADE .
Use parentheses to separate multiple
boolean phrases. For example, to find journalists talking about having fun in Disney World or
Disneyland, search for ("disney world" OR disneyland) AND fun.
An asterisk can be used to search for any variation of a root word truncated by the asterisk. For example, searching for admin* will return results for administrator, administration, administer, administered, etc.
A near operator is an AND operator where you can control the distance between the words. You can vary the distance the near operation uses by adding a forward slash and number (between 0-99) such as strawberries NEAR/10 "whipped cream", which means the strawberries must exist within 10 words of "whipped cream".