oira_meeting_attendees

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

10 rows where meeting_id = 1036823

✎ 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
920 920 340B Rebate Guidance 1036823 William Connelly Amgen Teleconference 0
921 921 340B Rebate Guidance 1036823 Will Diaz Amgen Teleconference 0
922 922 340B Rebate Guidance 1036823 Ruth Hoffman Amgen Teleconference 0
923 923 340B Rebate Guidance 1036823 Kelsey Lang Amgen Teleconference 0
924 924 340B Rebate Guidance 1036823 Salah Mehmood Amgen Teleconference 0
925 925 340B Rebate Guidance 1036823 Dan Cline OMB Teleconference 1
926 926 340B Rebate Guidance 1036823 Hester Grippando OMB Teleconference 1
927 927 340B Rebate Guidance 1036823 Maggie DeSisto OMB Teleconference 1
928 928 340B Rebate Guidance 1036823 Al Danzy HHS Teleconference 0
929 929 340B Rebate Guidance 1036823 William O'Brien Amgen 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);