Skip to content

Trustees of Princeton University

The public dataset bigquery-public-data.irs_990 contains filings data for IRS Form 990, for organizations exempt from paying income tax in the U.S. (e.g. "non profits"). One such company is TRUSTEES OF PRINCETON UNIVERSITY identified by ein = 210634501.

See how much investment income Princeton University reported in each year they filed form 990. The column of interest is invstmntinc and the tables of interest are irs_990_2012, irs_990_2013, irs_990_2014, irs_990_2015, irs_990_2016 and , irs_990_2017.

Expected Result
ein invstmntinc table_id
210634501 624637000 irs_990_2012
210634501 366150000 irs_990_2013
210634501 150041000 irs_990_2014
210634501 1227923000 irs_990_2015
210634501 1876950000 irs_990_2016
210634501 1296466000 irs_990_2017
Where is the irs_990 dataset?

Search for "irs_990" in the explorer pane and it should come up. (See how to find public datasets.)

See the solution