home / openregs

oira_meeting_attendees

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

8 rows where meeting_id = 1033923

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: attendee_org, is_government

Link rowid ▼ meeting_id attendee_name attendee_org participation_type is_government
853 853 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Kendra Pinto Earthworks Teleconference 0
854 854 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Lauren Pagel Earthworks Teleconference 0
855 855 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Melissa Ostroff Earthworks Teleconference 0
856 856 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Hanna Mitchell Earthworks Teleconference 0
857 857 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Josh Eisenfeld Earthworks Teleconference 0
858 858 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Andrew Forkes-Gudmundson Earthworks Teleconference 0
859 859 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Matthew Oreska OMB Teleconference 1
860 860 Greenhouse Gas Endangerment Finding and Motor Vehicle Reconsideration Rule 1033923 Beth Miller EPA Teleconference 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE oira_meeting_attendees (
    meeting_id TEXT REFERENCES oira_meetings(meeting_id),
    attendee_name TEXT,
    attendee_org TEXT,
    participation_type TEXT,
    is_government INTEGER DEFAULT 0
);
CREATE INDEX idx_oira_attendees_mid ON oira_meeting_attendees(meeting_id);
CREATE INDEX idx_oira_attendees_org ON oira_meeting_attendees(attendee_org);
Powered by Datasette · Queries took 558.41ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API