oira_meeting_attendees

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

10 rows where meeting_id = 1002

✎ 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
76 76 Clean Water Rule: Definition of "Waters of the United States" 1002 Vlad Dorjets OMB/OIRA In Person 1
77 77 Clean Water Rule: Definition of "Waters of the United States" 1002 Tera Fong OMB In Person 1
78 78 Clean Water Rule: Definition of "Waters of the United States" 1002 Erin Burke OMB In Person 1
79 79 Clean Water Rule: Definition of "Waters of the United States" 1002 Katie Renshaw CEQ In Person 0
80 80 Clean Water Rule: Definition of "Waters of the United States" 1002 Jim Laity OMB/OIRA In Person 1
81 81 Clean Water Rule: Definition of "Waters of the United States" 1002 Eric Fry Peabody Energy In Person 0
82 82 Clean Water Rule: Definition of "Waters of the United States" 1002 John P. Jones Alpha Natural Resources In Person 0
83 83 Clean Water Rule: Definition of "Waters of the United States" 1002 Rusty Ashcroft Alliance Coal In Person 0
84 84 Clean Water Rule: Definition of "Waters of the United States" 1002 Joe Friedlander North America Coal In Person 0
85 85 Clean Water Rule: Definition of "Waters of the United States" 1002 Ruth Demeter Peabody Energy 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);