oira_meeting_attendees

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

9 rows where meeting_id = 1026473

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: attendee_org, participation_type, is_government

Link rowid ▼ meeting_id attendee_name attendee_org participation_type is_government
619 619 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Dylan Soares PERC In Person 0
620 620 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Brian Yablonski PERC Teleconference 0
621 621 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Jonathan Wood PERC In Person 0
622 622 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 McLean Albritton PERC In Person 0
623 623 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Charles Yudson DOI Teleconference 0
624 624 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Carey Galst DOI Teleconference 0
625 625 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Jason Goldberg DOI Teleconference 0
626 626 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Madonna Baucum DOI Teleconference 0
627 627 Regulations Pertaining to Endangered and Threatened Wildlife and Plants 1026473 Miraf Bisetegne OMB Teleconference 1

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);