ProPublica's Free the Files Data Readme

File Name: ftf-all-filings.tsv

Source: ProPublica/FCC

Years Covered: 2012

Size: 24.1MB

Fields: 12

Rows: 66,225

This is political ad filing data compiled by ProPublica for our Free the Files project. For more information on this data, click here.

FIELD DESCRIPTIONS

id: ID for this filing in our database, for querying individual filings.

filing_type: Type of filing when filed with the FCC.

contract_number: Contract number for an ad buy, as reviewed and verified by our readers.

url: Path to the filing on the FCC's site. The prefix to these paths is https://stations.fcc.gov/.

committee: The committee object for the committee that purchased the ad, as reviewed and verified by our readers.

agency: The agency who made the ad purchase, as reviewed and verified by our readers.

callsign: Call sign for the TV station at which the ad was placed.

dc_slug: ID for the document in DocumentCloud. To access the document directly from DocumentCloud, use http://documentcloud.org/documents/ + dc_slug.

thumbnail_url: Thumbnail image for the document as created by DocumentCloud.

gross_amount: Amount the ad was purchased for, as reviewed and verified by our readers. NOTE: The gross_amount field should be used with caution and labeled as an estimate, since duplicate orders and invoices may inadvertently be verified by our users.

market_id: ID in our database for the market in which the ad was placed.

upload_date: Date that the filing was uploaded to the FCC. This field is occasionally null.

LICENSE

Using the attached data acknowledges that you've agreed to these terms:

• You can't charge people money to look at the data, or sell advertising specifically against it.
• If you use the data for a printed table, chart, graphic or map, you must cite ProPublica and and link to us if you publish online.
• You acknowledge that the data you use may contain errors and omissions, and you are solely responsible for checking our site for any corrections or updates.
• You can't resell the data.
• Before you e-mail us a question, please make sure you've read the explanation of our fields as well as our methodology.
• If you have any questions, e-mail data@propublica.org.