oira_meeting_attendees

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

11 rows where meeting_id = 1013973

✎ 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
282 282 340B Rebate Guidance 1013973 Don Dempsey OMB Teleconference 1
283 283 340B Rebate Guidance 1013973 Al Danzy HHS Teleconference 0
284 284 340B Rebate Guidance 1013973 Chantelle Britton HHS Teleconference 0
285 285 340B Rebate Guidance 1013973 Crystal Kuntz Biotechnology Innovation Organization (BIO) Teleconference 0
286 286 340B Rebate Guidance 1013973 Perry Knight Johnson & Johnson Teleconference 0
287 287 340B Rebate Guidance 1013973 Sherri Cirota Alkermes Teleconference 0
288 288 340B Rebate Guidance 1013973 Melody Calkins Biotechnology Innovation Organization (BIO) Teleconference 0
289 289 340B Rebate Guidance 1013973 Jacqueline Roche Johnson & Johnson Teleconference 0
290 290 340B Rebate Guidance 1013973 Jack Geisser Biotechnology Innovation Organization (BIO) Teleconference 0
291 291 340B Rebate Guidance 1013973 Rebecca Hancock Johnson & Johnson Teleconference 0
292 292 340B Rebate Guidance 1013973 Dan Cline 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);