oira_meeting_attendees

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

11 rows where meeting_id = 1004

✎ 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
122 122 Clean Water Rule: Definition of "Waters of the United States" 1004 Vlad Dorjets OMB/OIRA In Person 1
123 123 Clean Water Rule: Definition of "Waters of the United States" 1004 Tera Fong OMB In Person 1
124 124 Clean Water Rule: Definition of "Waters of the United States" 1004 Erin Burke OMB In Person 1
125 125 Clean Water Rule: Definition of "Waters of the United States" 1004 Sharon Cooperstein EPA In Person 0
126 126 Clean Water Rule: Definition of "Waters of the United States" 1004 Katie Renshaw CEQ In Person 0
127 127 Clean Water Rule: Definition of "Waters of the United States" 1004 Jim Laity OMB/OIRA In Person 1
128 128 Clean Water Rule: Definition of "Waters of the United States" 1004 Stacey McKinley The McKinley Group In Person 0
129 129 Clean Water Rule: Definition of "Waters of the United States" 1004 Clifton Taylor Richland Communities In Person 0
130 130 Clean Water Rule: Definition of "Waters of the United States" 1004 Ellen Tarquinio CEQ In Person 0
131 131 Clean Water Rule: Definition of "Waters of the United States" 1004 Kia Dennis SBA Advocacy In Person 0
132 132 Clean Water Rule: Definition of "Waters of the United States" 1004 Brian Plant Remy Moose Manley In Person 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);