hearing_witnesses

Witnesses who testified at committee hearings, with parsed name, title, organization, and location.

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

51 rows where package_id = "CHRG-112jhrg85228" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

organization >30

id package_id name ▼ title organization organization_normalized location
60557 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Alexis Lantz planning and policy director Los Angeles County Bicycle Coalition LOS ANGELES COUNTY BICYCLE COALITION  
60554 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Andrew Fox P. mayor MAYOR City of Thousand Oaks, CA
60564 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Ann Mesnikoff director Green Transportation Campaign, Sierra Club GREEN TRANSPORTATION CAMPAIGN, SIERRA CLUB  
60531 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Anne Mayer executive director Riverside County Transportation Commission RIVERSIDE COUNTY TRANSPORTATION COMMISSION  
60543 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Anne Mayer executive director, executive director; Stern, board member; Gimbel, member Riverside County Transportation Commission (RCTC), articles................157-160 Krause, Daniel, Ryan, Michael, Californians for High- Speed Rail RIVERSIDE COUNTY TRANSPORTATION COMMISSION (RCTC), ARTICLES................157-160 KRAUSE, DANIEL, RYAN, MICHAEL, CALIFORNIANS FOR HIGH- SPEED RAIL  
60535 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Art Pulaski executive secretary-treasurer California Labor Federation CALIFORNIA LABOR FEDERATION  
60569 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Betsy A. Lindsay president/CEO UltraSystems Environmental ULTRASYSTEMS ENVIRONMENTAL  
60542 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 BlueGreen Alliance Partners        
60539 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Bonnie Lowenthal   chair, Assembly Committee on Transportation CHAIR, ASSEMBLY COMMITTEE ON TRANSPORTATION  
60562 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Cesar Diaz legislative director State Building and Construction Trades Council of California STATE BUILDING AND CONSTRUCTION TRADES COUNCIL OF CALIFORNIA  
60525 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Cindy McKim director California Department of Transportation (CALTRANS) CALIFORNIA DEPARTMENT OF TRANSPORTATION (CALTRANS)  
60545 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Cindy McKim director, Michael T., general manager Department of Transportation, State of California.............................................165-175 Burns, Santa Clara Valley Transportation Authority..................................176-189 Dillard, Joyce DEPARTMENT OF TRANSPORTATION, STATE OF CALIFORNIA.............................................165-175 BURNS, SANTA CLARA VALLEY TRANSPORTATION AUTHORITY..................................176-189 DILLARD, JOYCE  
60534 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Curt Pringle chairman California High-Speed Rail Authority CALIFORNIA HIGH-SPEED RAIL AUTHORITY  
60541 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 David Foster executive director BlueGreen Alliances BLUEGREEN ALLIANCES  
60538 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Debra L. Hale executive director Transportation Agency for Monterey County, CA; chair, American Public Works Association (APWA) TRANSPORTATION AGENCY FOR MONTEREY COUNTY, CA; CHAIR, AMERICAN PUBLIC WORKS ASSOCIATION (APWA)  
60536 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Don Knabe chairman Metropolitan Transportation Authority METROPOLITAN TRANSPORTATION AUTHORITY  
60560 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Gary L. Gallegos executive director San Diego Association of Governments (SANDAG) SAN DIEGO ASSOCIATION OF GOVERNMENTS (SANDAG)  
60552 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Genaro Mejia   PE, American Society of Civil Engineers (ASCE) PE, AMERICAN SOCIETY OF CIVIL ENGINEERS (ASCE)  
60566 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Genevieve Giuliano Ph.D., vice president Research Education and Training Reauthorization Coalition (RETRC) RESEARCH EDUCATION AND TRAINING REAUTHORIZATION COALITION (RETRC)  
60568 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Geraldine Knatz executive director The Port of Los Angeles THE PORT OF LOS ANGELES  
60522 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Hon. Antonio R. Villaraigosa   mayor, City of Los Angeles MAYOR, CITY OF LOS ANGELES  
60521 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Hon. Don Knabe chairman Los Angeles Metropolitan Transportation Authority; and Los Angeles County Supervisor, 4th District, County of Los Angeles LOS ANGELES METROPOLITAN TRANSPORTATION AUTHORITY; AND LOS ANGELES COUNTY SUPERVISOR, 4TH DISTRICT, COUNTY OF LOS ANGELES  
60571 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Hon. Tim Spohn city council member, and chairman, board of directors City of Industry, California, Alameda Corridor-East Construction Authority CITY OF INDUSTRY, CALIFORNIA, ALAMEDA CORRIDOR-EAST CONSTRUCTION AUTHORITY  
60553 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Jim Gosnell executive director West Coast Corridor Coalition WEST COAST CORRIDOR COALITION  
60561 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Jim Kemp executive director Santa Barbara County Association of Governments (SBCAG) SANTA BARBARA COUNTY ASSOCIATION OF GOVERNMENTS (SBCAG)  
60523 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Joseph A. Czyzyk   chair, Los Angeles Area Chamber of Commerce CHAIR, LOS ANGELES AREA CHAMBER OF COMMERCE  
60555 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Karin Wang vice president, executive director, president and CEO; and Blackwell, founder and CEO Programs & Communications, Asian Pacific American Legal Center; Porchas, Francisca, lead organizer, Labor/Community Strategy Center and Bus Riders Union; Walton, Gloria, Strategic Concepts in Organizing & Policy Education (S.C.O.P.E.); Henderson, Wade, Angela Glover, PolicyLink PROGRAMS & COMMUNICATIONS, ASIAN PACIFIC AMERICAN LEGAL CENTER; PORCHAS, FRANCISCA, LEAD ORGANIZER, LABOR/COMMUNITY STRATEGY CENTER AND BUS RIDERS UNION; WALTON, GLORIA, STRATEGIC CONCEPTS IN ORGANIZING & POLICY EDUCATION (S.C.O.P.E.); HENDERSON, WADE, ANGELA GLOVER, POLICYLINK  
60526 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Kathryn Phillips director California Transportation and Air Initiative, Environmental Defense Fund CALIFORNIA TRANSPORTATION AND AIR INITIATIVE, ENVIRONMENTAL DEFENSE FUND  
60547 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Kathryn Phillips director CA Transportation and Air Initiative, Environmental Defense Fund CA TRANSPORTATION AND AIR INITIATIVE, ENVIRONMENTAL DEFENSE FUND  
60559 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Laura Cohen western regional director Rails-to-Trails Conservancy RAILS-TO-TRAILS CONSERVANCY  
60537 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Mary Leslie president Los Angeles Business Council LOS ANGELES BUSINESS COUNCIL  
60546 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Paul Styers   Con-way Freight CON-WAY FREIGHT  
60563 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Peter Greenwald senior policy advisor South Coast Air Quality Management District SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT  
60530 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Report of the National Surface Transportation Policy and Revenue Study Commission   January 2008 JANUARY 2008  
60524 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Robbie Hunter   council representative, Los Angeles/Orange Counties Building & Construction Trades Council COUNCIL REPRESENTATIVE, LOS ANGELES/ORANGE COUNTIES BUILDING & CONSTRUCTION TRADES COUNCIL  
60544 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Robert E. Ham director of Intergovernmental Relations     County of Imperial, CA
60551 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Rodrigo Garcia vice president, Associated Professionals and Contractors (APAC); chairman of the board, Deborah A., director Hispanic Engineers Business Corporation (HEBC).....................214-216 Hubsmith, Safe Routes to School National Partnership HISPANIC ENGINEERS BUSINESS CORPORATION (HEBC).....................214-216 HUBSMITH, SAFE ROUTES TO SCHOOL NATIONAL PARTNERSHIP  
60558 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Roland (Rolly) Rothman   Rothman Engineering, Inc., Professional Engineers in California Government ROTHMAN ENGINEERING, INC., PROFESSIONAL ENGINEERS IN CALIFORNIA GOVERNMENT  
60570 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Russell Goldsmith chairman The Los Angeles Coalition THE LOS ANGELES COALITION  
60565 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 St. Amant president and chief operating officer David, Econolite Group, Inc DAVID, ECONOLITE GROUP, INC  
60533 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Statements: Brummett Ronald E., executive director Kern Council of Governments KERN COUNCIL OF GOVERNMENTS  
60550 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Steve Chavez Lodge director of Public Affairs Hill International HILL INTERNATIONAL  
60529 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Steve Heminger executive director Metropolitan Transportation Commission METROPOLITAN TRANSPORTATION COMMISSION  
60528 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Summary of Goals and Projects   December 20, 2010 DECEMBER 20, 2010  
60567 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Tami Friedrich board member, Citizens for Reliable and Safe Highways (CRASH) and California volunteer coordinator Truck Safety Coalition TRUCK SAFETY COALITION  
60556 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Terence M. O'Sullivan general president Laborers International Union of North America LABORERS INTERNATIONAL UNION OF NORTH AMERICA  
60532 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 The 91 Project Brochure        
60549 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Tom Tietz executive director, vice president of Marketing & Government Relations (on behalf of FP<SUP>2</SUP>, Inc.) California Nevada Cement Association...............................................206-208 Vandermost, Phil CALIFORNIA NEVADA CEMENT ASSOCIATION...............................................206-208 VANDERMOST, PHIL  
60540 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Tracy Rafter CEO Rafter Group, Inc., Los Angeles County Business Federation (BizFed) RAFTER GROUP, INC., LOS ANGELES COUNTY BUSINESS FEDERATION (BIZFED)  
60548 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Various transportation members and supporters   February 11, 2011......................................................198-203 Okerblom, Eilene FEBRUARY 11, 2011......................................................198-203 OKERBLOM, EILENE Santa Maria, CA
60527 IMPROVING AND REFORMING OUR NATION'S SURFACE TRANSPORTATION PROGRAMS TO SUPPORT JOB CREATION AND THE ECONOMY CHRG-112jhrg85228 Will Kempton CEO Orange County Transportation Authority ORANGE COUNTY TRANSPORTATION AUTHORITY  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_witnesses (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT,
    title TEXT,
    organization TEXT,
    organization_normalized TEXT,
    location TEXT
);
CREATE INDEX idx_hw_package ON hearing_witnesses(package_id);
CREATE INDEX idx_hw_name ON hearing_witnesses(name);
CREATE INDEX idx_hw_org ON hearing_witnesses(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_hw_org_norm ON hearing_witnesses(organization_normalized) WHERE organization_normalized IS NOT NULL;