PeerGalaxy

Oregon's Peer Support Directory

PeerGalaxy Public Data Explorer

Public Data Sets & Resources

New Tools Coming Soon!

If you have a data set to share or that you would like to see,

email us: webmail@peergalaxy.com

DISCLAIMER: Any content including but not limited to information and links on this page, and any content linking to or from this page, is provided solely as a courtesy *and* may contain errors or omissions *and* does not have any guaranty, guarantees, warranty or warranties of any kind whatsoever. We accept no liability of any kind whatsoever. There can be risks from using or installing software. You are hereby notified and advised to seek counsel from qualified professionals at your own risk and expense. You are hereby notified and advised to verify information accuracy before use.

Definitions

Definitions

API
- Acronym that stands for Application Programming Interface, a software intermediary that allows two applications to exchange information such as instructions, questions (queries) and answers (responses).
Data
- Factual information used for reference, analysis or decision support
Database
- A collection of information that has been organized, often in rows (records) and columns
Data Set
- A collection of information related to a topic
Data Warehouse
- Integrated storage of large amounts of data from one or more sources for analysis
Data Democratization
- Making data accessible to all people with education on how to work with data, regardless of technical background
Pivot Table
- A table with information stored in rows and columns, with the ability to group under headers for analysis. For example: if one has a table of people, one could group by age ranges (0-5yo, 5-15yo, 15-25yo, etc.)
Query
- A question. A question to a database. For example, return all records where age is between 0 and 18.
Spreadsheet
- A document, and/or the software producing such a document — either electronic (file) or hard copy (printed) — where data is organized on a sheet with gridlines in cells at the intersection of rows and columns. Cells may contain numbers, text, links, or formulas (to calculate a value). Typically the cells arranged horizontally side to side in a row form a record and each cell contains a value under a column heading – for example, name and birth date. Most software uses numbers to reference the rows and letters to reference the column headings. The first cell is usually A1.
SQL (Structured Query Language)
- Common commands used to form a query (question) or send an instruction to a database. Example: SELECT * WHERE NAME = ‘JONATHAN’
Software
- Instructions to a computer device

Tools and Tutorials

DataVerse API Guide
- https://guides.dataverse.org/en/latest/api/index.html
APIs for Dummies by IBM
- https://www.ibm.com/downloads/cas/GJ5QVQ7X
Power Query for Microsoft Excel spreadsheet software
- https://support.microsoft.com/en-us/office/power-query-for-excel-help-2b433a85-ddfb-420b-9cda-fe0e60b82a94
OData.org
- https://www.odata.org/
CData API Server
- https://www.cdata.com/apiserver/
- Import OData into Google Sheets
  - https://www.cdata.com/kb/tech/access-odata-gsheets-import.rst
- Google API Connector
  - https://workspace.google.com/marketplace/app/api_connector/95804724197

US Federal Government

US Federal Government

GovInfo.gov (website + API )
- https://www.govinfo.gov/
API.data.gov (website + API )
- https://api.data.gov/
Government Manual “GOVMAN” (Last updated Dec 2022)
- https://www.govinfo.gov/content/pkg/GOVMAN-2022-12-31/pdf/GOVMAN-2022-12-31.pdf
Sitemaps for GovInfo
- https://www.govinfo.gov/sitemaps

US Legislative Branch

US Congress (web page links)
- https://www.congress.gov/
- Congressional Member Organizations (CMOs) (Last updated May 2023)
  - https://cha.house.gov/sites/evo-subsites/republicans-cha.house.gov/files/evo-media-document/2023.05.12_cmo-list.pdf
- Congressional Committee Maps
  - http://committeemaps.org/index.html

- US Senate
  - All Sessions (web page table + PDF)
    - https://www.senate.gov/reference/Index/Sessions.htm
- US House
  - All Sessions (web page table)
    - https://history.house.gov/Institution/Session-Dates/All/
  - House Directory
    - https://directory.house.gov/

US Executive Branch

Office of the President
- 2022
  - https://www.whitehouse.gov/administration/executive-office-of-the-president/
White House
Cabinet Members
- 2022

US Judicial Branch

US Supreme Court

US Organization Charts

US Government

US Government – Org Chart image links
- https://kottke.org/plus/misc/images/us-govt-org-chart.jpg
- https://mrbelloblog.com/wp-content/uploads/2011/10/The-Government-of-the-United-States-762×1024.jpg

US Legislative Branch

US Congress – Org Chart image link
- https://slideplayer.com/slide/15068436/91/images/13/Congress+Organization+Chart.jpg

US Executive Branch

US Dept of Justice – Org Chart image link
- https://www.justice.gov/agencies/chart

US Judicial Branch

US Federal Court System – Org Chart image links

US Data & Transparency

Data.gov
- https://data.gov/
FOIA.gov (Freedom of Information Act)
- https://www.foia.gov/
US Office of Personnel Management
- Healthcare & Insurance
  - https://www.opm.gov/healthcare-insurance/healthcare/transparency-in-healthcare/public-use-files/#url=Overview
US Dept of Health and Human Services
- Hospital Price Transparency
  - https://www.cms.gov/hospital-price-transparency
US Dept of Justice Transparency
- https://www.justice.gov/oip/government-transparency
US Dept of State Transparency, Key Topics
- https://www.state.gov/key-topics-division-for-international-finance-and-development/
US Federal Election Commission
- https://api.open.fec.gov/developers/
USAspending.gov
- https://www.usaspending.gov/
OpenTheBooks.com
- https://www.openthebooks.com/
FollowTheMoney.org
- https://www.followthemoney.org/
OpenSecrets.org
- https://www.opensecrets.org/
LilSis
- https://littlesis.org/
Ballotopedia List of State Transparency Websites
- https://ballotpedia.org/List_of_transparency_websites
ProPublica.org
- https://www.propublica.org/

Oregon Data & Transparency

Oregon Open Data Portal
- https://data.oregon.gov/
Oregon Legislative Information
- https://www.oregonlegislature.gov/citizen_engagement/Pages/data.aspx
Oregon Transparency
- https://www.oregon.gov/transparency/pages/index.aspx
Oregon Housing Data
- https://www.oregon.gov/ohcs/development/Pages/housing-data-analysis.aspx
Oregon Criminal Justice Commission Statistics & Dashboards
- https://www.oregon.gov/cjc/sac/pages/dashboards.aspx
Oregon Public Meetings
- https://www.oregon.gov/transparency/Pages/Public-Meetings.aspx
Oregon Wildfire Dashboards (2021)
- https://wildfire.oregon.gov/pages/current-conditions.aspx
- https://oregon-oem-geo.hub.arcgis.com/
Oregon Boards & Commissions (2018 edition, PDF Format, 266 pages)
- https://www.oregon.gov/gov/Documents/Board%20Book%202018.pdf
Oregon Secretary of State: Elections Data
- https://sos.oregon.gov/elections/Pages/electionsstatistics.aspx

Oregon Explorer

Oregon Explorer
- https://oregonexplorer.info/
Rural Communities Reporter
- https://oe.oregonexplorer.info/rural/CommunitiesReporter/

Oregon State Organization Charts

Oregon State

Oregon State Government
- Ballotopedia Image (PNG format)
  - https://cdn.ballotpedia.org/images/e/e2/OrganizationChart_OR_2020.png
- Uplift Oregon
  - https://www.upliftoregon.org/wp-content/uploads/State-of-Oregon-Organization-Chart.pdf
Oregon Executive Branch
- Ballotopedia Image (PNG format)
  - https://ballotpedia.org/File:OrganizationChart_OR_2020.png
- Oregon.gov (link only, not an org chart)
  - https://www.oregon.gov
- Oregon Department of Justice (link only, not an org chart)
  - https://www.doj.state.or.us/oregon-department-of-justice/divisions/divisions-overview/
Oregon Legislative Branch
- Oregon Legislative Info System / Citizen (PNG format)
  - https://www.oregonlegislature.gov/PublishingImages/legislativeBody1000x585.png
Oregon Judicial Branch
- Ballotopedia Image (PNG format)
  - https://ballotpedia.s3.amazonaws.com/images/thumb/1/16/Oregon_State_Court_Flow_Chart.png/400px-Oregon_State_Court_Flow_Chart.png
- Oregon Judicial Department Image (JPG format)
  - https://www.courts.oregon.gov/about/PublishingImages/OJD%20Administrative%20Authority%20Organization.jpg
- Oregon Judicial Overview (PDF format)
  - https://olis.oregonlegislature.gov/liz/2019R1/Downloads/CommitteeMeetingDocument/182953

Oregon Local Government

Oregon Local Governments

County Governments
- Association of Oregon Counties (AOC)
  - Contacts Sheet:
    - https://drive.google.com/file/d/1EwCPiiPdJepkKVAdzH5juDxB4_f_P9p7/view
  - County Structures Sheet:
    - https://drive.google.com/file/d/1rVk4kPNEO6sjPudc1wHoNHcU1ZHFcHvX/view
  - Counties Booklet (2021-2022)
    - https://drive.google.com/file/d/1XhGRb67XFJCJHBTT_V-DGYUVByjLycLi/view?usp=sharing

Other Public Data Sets and Resources

Harvard Dataverse
- https://dataverse.harvard.edu/
Recreation Information Database (RIDB)
- https://ridb.recreation.gov/landing
IRS Database
- Tax Exempt Organization Search
  - https://www.irs.gov/charities-non-profits/tax-exempt-organization-search
- IRS Foundations and Charitable Trusts
  - https://www.irs.gov/statistics/soi-tax-stats-domestic-private-foundation-and-charitable-trust-statistics
- IRS Data Book
  - https://www.irs.gov/statistics/soi-tax-stats-irs-data-book-index-of-tables

Beyond Our Planet

NASA Exoplanet Catalog
- https://exoplanets.nasa.gov/discovery/exoplanet-catalog/

Translate »