A script to merge a list of US Opera Companies with their corresponding IRS 990 data
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Merged_Opera_Dataset_by_EIN.csv
Opera_Companies_Canada_List_2017.csv
Opera_Companies_List_2017.csv
Opera_Companies_No_Financials_List_2017.csv
Opera_Company_IRS_990_Merge.Rmd
Opera_Company_IRS_990_Merge.nb.html
README.md

README.md

Basic Information- Introduction

  1. Data File Name:
    Opera-Company-IRS-990-Merge
  2. Dataset Name:
    N/A
  3. Other Files Related to These Data (Other Files in Set, e.g.):
  • "Exempt Organizations Business Master File Extract (EO BMF)"
  • "Opera_Companies_List_2017" can be found in this repository.
  • "Opera_Companies_No_Financials_List_2017" can be found in this repository
  • "Opera_Companies_Canada_List_2017" can be found in this repository
  • "Merged_Opera_Dataset_by_EIN" can be found in this repository. Note: this dataset is the result of running the script.
  1. Author(s) Names (or person responsible for collecting the data):
  • Emily Edwards
  • Jonathan Cain
  1. Author(s) ORCID IDs:
    Jonathan Cain ORCID: 0000-0002-8694-1420
  2. Contact Information:
  • Emily Edwards
    Planning, Public Policy and Management Masters Candidate
    University of Oregon
    Email:
    eedward3@uoregon.edu
  • Jonathan Cain
    Research and Instructional Services
    University of Oregon
    Mail:
    1229 University of Oregon
    Libraries, Eugene, OR 97403-1299
    Email:
    jocain@uoregon.edu
  1. Date(s) of Data Collection:
    01/2017-02/2017
  2. Date File was Created:
    2/17/2017
  3. Date(s) and Nature of Updates:
    N/A

Basic Information- Data Use

  1. Citations of Publications Using These Data:
    N/A
  2. Digital Object Identifiers (DOIs) of Publications Using These Data:
    10.5281/zenodo.303273
  3. Purpose of Collection:
    The purpose of this script is to merge a compiled list of all Opera Companies in the US with their corresponding IRS 990 data, if available.

Basic Information- Data Description

  1. Key Words and Definitions:
  • IRS: Internal Revenue Service in the US
  • Form 990: The "Return of Organization Exempt From Income Tax", of Form 990 is a United States Internal Revenue Service form that provides the public with financial information about a nonprofit organization. It is often the only source of such information.
  • EIN: Employer Identification Number given to registered tax exempt nonprofit organizations
  1. Example Data in Set:
EIN NAME ICO STREET CITY STATE ZIP GROUP SUBSECTION AFFILIATION CLASSIFICATION ETC...
231352001 ACADEMY OF VOCAL ARTS 1920 SPRUCE ST PHILADELPHIA PA 19103-6613 0 3 3 1000
43519499 ACTING SINGERS PROJECT DAVID WALTHER 126 NEWBURG ST ROSLINDALE MA 02131-3319 0 3 3 2000
  1. Lineage of Dataset:
    N/A
  2. Geographic Information:
    North America

Methodological Information

  1. Method description, links or references to publications or other documentation containing experimental design or protocols used in data collection:
  1. Any instrument-specific information needed to understand or interpret the data:
    N/A
  2. Standards and calibration information, if appropriate:
    N/A
  3. Describe any quality-assurance procedures performed on the data:
    N/A
  4. Definitions of codes or symbols used to note or characterize low quality/questionable/outliers that people should be aware of:
    N/A
  5. People involved with sample collection, processing, analysis and/or submission:
    N/A

Data-Specific Information

  1. Full names and definitions (spell out abbreviated words) of column headings for tabular data:
  • EIN: Employer Identification Number through the Internal Revenue Service
  • NAME.x: Name of the company as listed in the Opera Company dataset
  • NAME.y: Name of the company as provided by IRS data
  • ICO: In care of name; to who any correspondence should be directed towards
  • STREET: Street address
  • CITY: City
  • STATE: State
  • ZIP: Zip code
  • GROUP: Group Extension Number
  • SUBSECTION: Subsection Code
  • AFFILIATION: Affiliation Code
  • CLASSIFICATION: Classification Code(s)
  • RULING: Ruling date
  • DEDUCTIBILITY: Deductibility Code
  • FOUNDATION: Foundation Code
  • ACTIVITY: Activity Code(s)
  • ORGANIZATION: Organization Code
  • STATUS: Exempt Organization Status Code
  • TAX_PERIOD: Tax period
  • ASSET_CD: Asset Code
  • INCOME_CD: Income Code
  • FILING_REQ_CD: Filing Requirement Code
  • PF_FILING_REQ_CD: PF Filing Requirement Code
  • ACCT_PD: Accounting period
  • ASSET_AMT: Asset amount
  • INCOME_AMT: Income amount
  • REVENUE_AMT: Form 990 revenue amount
  • NTEE_CD: National Taxonomy of Exempt Entities (NTEE) Code
  • SORT_NAME: Sort name
  1. Units of measurement:
    N/A
  2. Definitions for codes or symbols used to record missing data:
  • NO EIN: An EIN was not available for that Opera Company, however they are a nonprofit organization
  • N/A: There was no data available to merge with that Opera Company
  1. Specialized formats or abbreviations used:
    N/A

Sharing/Access Information

  1. Licenses or restrictions placed on the data:
    Open
  2. Links to publications that cite or use the data:
    N/A
  3. Links to other publicly accessible locations of the data:
    N/A
  4. Recommended citation for the data:
    Edwards, E. & Cain, J. (2017). Opera_Company_IRS_990_Merge. [Data Compilation]. doi:10.5281/zenodo.303273
  5. Information about funding sources that supported the collection of the data:
    N/A