Science Giving: science_federal_giving.csv

Table actions

This directory contains the data behind the story When Scientists Donate To Politicians, It’s Usually To Democrats.

The data in science_federal_giving.csv is from the Federal Election Commission, filtered to donations form the following occupations from 2007 to 2016: computer and information scientists mathematical scientists agricultural and food scientists biological and medical scientists environmental life scientists chemists Earth scientists, geologists and oceanographers physicists and astronomers other physical and related scientists aerospace, aeronautical or astronautical engineers chemical engineers civil, architectural or sanitary engineers electrical or computer hardware engineers industrial engineers mechanical engineers other engineers * statisticians

Header Definition
cmte_nm Committee name
cmte_id Committee identification, assigned
cmte_tp Committee type. List of committee type codes
cmte_pty Committee party. List of party codes
cand_name Candidate name
cand_pty_affiliation Political party affiliation reported by the candidate
cand_office_st Candidate state
cand_office Candidate office. H = House, P = President, S = Senate
cand_office_district Candidate district
cand_status Candidate status. C = Statutory candidate, F = Statutory candidate for future election, N = Not yet a statutory candidate, P = Statutory candidate in prior cycle
rpt_tp Report type. Report type codes
transaction_pgi The code for which the contribution was made. EYYYY (election plus election year). P = Primary, G = General, O = Other, C = Convention, R = Runoff, S = Special, E = Recount
transaction_tp Transaction type. Type codes
entity_tp Entity type. Only valid for electronic filings received after April 2002. CAN = Candidate, CCM = Candidate Committee, COM = Committee, IND = Individual (a person), ORG = Organization (not a committee and not a person), PAC = Political Action Committee, PTY = Party Organization
cleaned_name Contributor/lender/transfer name
city City/town
state State
zip_code Zip code
employer Employer
cleaned_occupation Occupation
classification Classification of occupation
transaction_dt Transaction date (MMDDYYYY)
cycle Election cycle
transaction_amt Transaction amount
2016_dollars Transation amount adjusted for inflation
other_id Other identification number. For contributions from individuals this column is null. For contributions from candidates or other committees this column will contain that contributor's FEC ID.
tran_id Transaction ID
file_num A unique identifier associated with each itemization or transaction appearing in an FEC electronic file. Only valid for electronic filings.
memo_cd 'X' indicates that the amount is not to be included in the itemization total.
memo_text A description of the activity.
sub_id FEC record number

Source: Federal Election Commission

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

2 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ version https://git-lfs.github.com/spec/v1
1 1 oid sha256:f3a6c08c8e1cf2a57f392ef6a9ad3aa0602817e7216d979205152398e2b9400b
2 2 size 121407075

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "science-giving/science_federal_giving" (
"version https://git-lfs.github.com/spec/v1" TEXT
);