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

109,242 rows sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: organization

id package_id name ▼ title organization location
103317 - CHRG-118hhrg54226 " Oak Ridge National Laboratory technology      
77684 UPDATE ON LOW-LEVEL RADIOACTIVE WASTE DISPOSAL ISSUES CHRG-114hhrg99436 "Low-Level Waste Compacts" Map      
77670 PROTECTING INFANTS: ENDING TAXPAYER FUNDING FOR ABORTION PROVIDERS WHO VIOLATE THE LAW CHRG-114hhrg99411 "Planned Parenthood Foundation of America Chart   " Source: The Center for Medical Progress  
92641 PROTECTING THE RFS: THE TRUMP ADMINISTRATION'S ABUSE OF SECRET WAIVERS CHRG-116hhrg43775 "U.S. Consumption of Ethanol and Biodiesel is at/near Record Levels Table   " Energy Information Administration  
24354 PROJECT BIOSHIELD REAUTHORIZATION ISSUES HEARING BEFORE THE SUBCOMMITTEE ON HEALTH OF THE COMMITTEE ON ENERGY AND COMMERCE HOUSE OF REPRESENTATIVES ONE HUNDRED NINTH CONGRESS SECOND SESSION CHRG-109hhrg29726 $160 million for advanced research and development. Yes budget and radiological/nuclear advanced research and development. It is meant to be in league with the implementation of the BioShield purchasing. It is part of the pulling effort there to get these products closer to the BioShield contracting point. MR. ROGER sir. MR. ROGERS. And for naturally occurring. So it wouldn't have the same target set, maybe, as a BioShield-- MR. AZAR. No, that $160 million is actually focused on chemical, bio  
35094 THE PROPOSED DELTA/NORTHWEST MERGER: THE IMPACT ON WORKERS CHRG-110hhrg43660 '' April 2008 Benefits      
42522 WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 '' April 2008 Benefits      
24328 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 '' and accompanying letters 0593      
35500 EXAMINING THE ROLE OF MUSEUMS AND LIBRARIES IN STRENGTHENING COMMUNITIES CHRG-110hhrg44215 '' by Dr. Jolly Scientists   St. Pioneer Press, August 17, 2008  
30095 PREPARING TEACHERS FOR THE CLASSROOM: THE ROLE OF THE HIGHER EDUCATION ACT AND NO CHILD LEFT BEHIND CHRG-110hhrg35187 '' by Linda Darling Hammond Teaching professor Stanford University  
35507 EXAMINING THE ROLE OF MUSEUMS AND LIBRARIES IN STRENGTHENING COMMUNITIES CHRG-110hhrg44215 '' dated November 29 Residents   2004  
34220 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 '' from the San Rafael Raid   CA, Independent Journal, April 26, 2007  
34219 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 '' from the San Rafael Raids   CA, Independent Journal, April 5, 2007  
29673 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 '' published in the International Journal of Occupational Health Negligence   dated Jan.-Mar. 2007  
76585 HEARING TO REVIEW THE 2015 FIRE SEASON AND LONG-TERM TRENDS CHRG-114hhrg97183 (Ret.) Priddy Director of Government Affairs COL Ronald N.,  
2558 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 1995 Status of the Nation's Surface Transportation System: Condition and Performance Report      
50407 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 1LT Tulsi Gabbard Tamayo   Hawaii Army National Guard  
25961 BACK FROM THE BATTLEFIELD, PART II: SEAMLESS TRANSITION TO CIVILIAN LIFE CHRG-109shrg22553 1st Lieutenant John A. Fernandez   (RET), Veteran of Operation Iraqi Freedom  
3641 IMPACTS OF THE CURRENT SOCIAL SECURITY SYSTEM CHRG-106hhrg57366 2030 Center   Liz Kramer  
4991 EFFORTS TO INFORM THE PUBLIC ABOUT SOCIAL SECURITY CHRG-106hhrg66357 2030 Center   Hans Riemer  
75194 A PRESENTATION BY NATIONAL 4-H CONFERENCE PARTICIPANTS CONCERNING THE FUTURE OF AGRICULTURE IN THE UNITED STATES CHRG-114hhrg94334 4-H Presenters: Rogers   Harley Hamilton, TX
6382 CLEAN AIR ACT: SULFUR IN THE TIER 2 STANDARDS FOR AUTOMOBILES CHRG-106shrg59385 53 Charts.........................................49-51   54, 58-62 Letters: Several Governors........................................ 38-47 Environmental Council of the States  
5427 INTERNET TAX ISSUES CHRG-106hhrg67448 60 Plus Association   James L. Martin  
21030 UNITED NATIONS CONVENTION ON THE LAW OF THE SEA CHRG-108shrg94598 A Bad Treaty Returns...............................129-145 Article      
35901 THE U.S. DEPARTMENT OF VETERANS AFFAIRS SUICIDE HOTLINE CHRG-110hhrg44931 A Health Net Co. MHN M.D., Chief Medical Officer San Rafael, CA, Ian A. Shaffer  
13230 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 A Layman's Guide to the General Circulation Models Used in the National Assessment...........................106-125 Responses to additional questions from: Senator Campbell Report      
4382 U.S.--LIBYA RELATIONS: A NEW ERA? CHRG-106hhrg63272 A Omar Turbi   Libyan American Human Rights Activist  
61849 DISASTER RECOVERY: EVALUATING THE ROLE OF AMERICA'S SMALL BUSINESS IN REBUILDING THEIR COMMUNITIES CHRG-112shrg73458 A Panel Jr., Albert B., Associate Administrator consisting of: Sligh, Mission Support Bureau, Federal Emergency Management Agency, U.S. Department of Homeland Security  
12020 NOMINATION HEARING FOR MARY KIRTLEY WATERS, LOU GALLEGOS, AND J.B. PENN CHRG-107shrg79495 A Panel including: Gallegos Nominated for Assistant Secretary for Administration Lou, of Rio Rancho, New Mexico, U.S. Department of Agriculture  
87582 KEEP WHAT YOU CATCH: PROMOTING TRADITIONAL SUBSISTENCE ACTIVITIES IN NATIVE COMMUNITIES CHRG-115shrg33836 A-Dae Romero-Briones J.D., LL.M, Director of Programs Native Agriculture and Food Systems, First Nations Development Institute  
959 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 A. Alan Moghissi President Institute for Regulatory Science, Columbia, Maryland  
106400 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 A. Aukahi Austin Seabury Ph.D., Executive Director/Licensed Clinical Psychologist I Ola Lahui, Inc  
55530 AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 A. Barry Rand Chief Executive Officer, President, AARP Board of Directors AARP Accompanied by, Lee Hammond  
55063 EDUCATION REFORMS: EXAMINING THE FEDERAL ROLE IN PUBLIC SCHOOL ACCOUNTABILITY CHRG-112hhrg68265 A. Blaine Hawley   principal, Red Pump Elementary School Bel Air, MD
20328 CLEAN AIR ACT: ALTERNATIVE FUELS AND FUEL ADDITIVES CHRG-108shrg91499 A. Blakeman Early   consultant, The American Lung Association  
28287 THE IMPACT OF THE ELIMINATION OF MTBE CHRG-109shrg42273 A. Blakeman Early   American Lung Association  
21087 IMPACT OF ENVIRONMENTAL REGULATIONS ON OIL REFINING CHRG-108shrg94606 A. Blakeman ``Blake Early   '' American Lung Association  
8105 AVIATION AND THE INTERNET CHRG-106shrg83343 A. Bradley Mims Deputy Assistant Secretary Aviation and International Affairs, U.S. Department of Transportation  
11777 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 A. Brian Wallace chairman Washoe Tribe of Nevada and California  
25994 TO REVIEW THE AGRICULTURAL RISK PROTECTION ACT OF 2000 AND RELATED CROP INSURANCE ISSUES CHRG-109shrg22647 A. Bruce Babcock Director Center for Agriculture and Rural Development, Iowa State University, Ames, Iowa  
44956 PROTECTING EMPLOYEES, EMPLOYERS AND THE PUBLIC: H1N1 AND SICK LEAVE POLICIES CHRG-111hhrg53372 A. Bruce Clarke J.D., president and CEO, Capital Associated Industries Inc  
32643 EXPLORING OPTIONS FOR IMPROVING THE MEDICARE PHYSICIAN PAYMENT SYSTEM CHRG-110hhrg39511 A. Bruce Steinwald Director Health Care, Government Accountability Office Washington, DC
36388 OPTIONS TO IMPROVE QUALITY AND EFFICIENCY AMONG MEDICARE PHYSICIANS CHRG-110hhrg46971 A. Bruce Steinwald Director Health Care, government Accountability Office  
70743 ADVANCING REFORM: MEDICARE PHYSICIANS PAYMENTS CHRG-113shrg87885 A. Bruce Steinwald president MBA, Bruce Steinwald Consulting Washington, DC
56428 EXPIRING MEDICARE PROVIDER PAYMENT POLICIES CHRG-112hhrg72281 A. Bruce Steinwald President   Steinwald Consulting Testimony  
56564 CYBERSECURITY: THREATS TO THE FINANCIAL SECTOR CHRG-112hhrg72601 A. Bryan Sartin Director Investigative Response, Verizon  
57483 INTERNATIONAL PATENT ISSUES: PROMOTING A LEVEL PLAYING FIELD FOR AMERICAN INDUSTRY ABROAD CHRG-112hhrg73965 A. Christal Sheppard Ph.D. J.D., Assistant Professor University of Nebraska College of Law  
27033 FEDERAL STRATEGIES TO END BORDER VIOLENCE CHRG-109shrg28338 A. D'Wayne Jernigan Sheriff Val Verde County, Texas  
72069 FUGITIVE METHANE EMISSIONS FROM OIL AND GAS OPERATIONS CHRG-113shrg96024 A. Daniel Hill Ph.D., P.E., Department Head Petroleum Engineering, Texas A&M University  
15966 CAN A PROCESS BE DEVELOPED TO SETTLE MATTERS RELATING TO THE INDIAN TRUST FUND LAWSUIT? CHRG-108hhrg88177 A. David Lester Executive Director Council of Energy Resource Tribes  
29574 ROYALTIES AT RISK CHRG-110hhrg34376 A. David Lester Executive Director Council of Energy Resource Tribes  
70870 STANDARD-ESSENTIAL PATENT DISPUTES AND ANTITRUST LAW CHRG-113shrg88369 A. Douglas Melamed Senior Vice President and General Counsel Intel Corporation, Santa Clara, California  
15558 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 A. Durand Jones Deputy Director, National Park Service, D.C U.S. Department of the Interior, Washington  
15830 H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 A. Durand Jones Deputy Director, National Park Service, D.C U.S. Department of the Interior, Washington  
31006 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 A. Gary Muller president and chief executive officer   West Jefferson Medical Center Marrero, LA
1387 YEAR 2000 PROBLEM AND TELECOMMUNICATIONS SYSTEMS CHRG-105hhrg51590 A. Gerard Roth GTE      
46017 REFORMING THE JUVENILE JUSTICE SYSTEM TO IMPROVE CHILDREN'S LIVES AND PUBLIC SAFETY CHRG-111hhrg55917 A. Hasan Davis Esq., deputy commissioner for operations Kentucky Department of Juvenile Justice  
66628 LEGISLATION TO FURTHER REDUCE IMPEDIMENTS TO CAPITAL FORMATION CHRG-113hhrg86681 A. Heath Abshure Arkansas Securities Commissioner, on behalf of the North American Securities Administrators Association    
78482 EXAMINING HEROIN AND OPIATE ABUSE IN SOUTHWESTERN PENNSYLVANIA CHRG-114shrg21277 A. Jack Kabazie M.D., system director Division of Pain Medicine, Allegheny Health Network Pittsburgh, PA
11523 TREATMENT, EDUCATION, AND PREVENTION: ADDING TO THE ARSENAL IN THE WAR ON DRUGS CHRG-107shrg76915 A. James Walton Jr., Commissioner Department of Public Safety, State of Vermont Waterbury, VT
56925 [H.A.S.C. No. 112-94]DOING BUSINESS WITH DOD: UNIQUE CHALLENGES FACED BY SMALL AND MID-SIZED BUSINESSES CHRG-112hhrg72932 A. John Shoraka Acting Associate Administrator for Government Contracting and Business Development U.S. Small Business Administration  
38971 POST-CATASTROPHE CRISIS: ADDRESSING THE DRAMATIC NEED AND SCANT AVAILABILITY OF MENTAL HEALTH CARE IN THE GULF COAST CHRG-110shrg38986 A. Kathryn Power M.Ed., Director, Center for Mental Health Services, Substance Abuse and Mental Health Services Administration, U.S. Department of Health and Human Services    
40689 GLOBAL WARMING AND WILDLIFE CHRG-110shrg53823 A. Lee Foote Associate Professor University of Alberta  
68426 EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 A. Mark Fendrick M.D., Director University of Michigan Center for Value-Based Insurance Design  
85271 MEDICARE ADVANTAGE HEARING ON PROMOTING INTEGRATED AND COORDINATED CARE FOR MEDICARE BENEFICIARIES CHRG-115hhrg33429 A. Mark Fendrick Executive Director MD, University of Michigan Center for Value-Based Insurance Design  
73986 THE FUTURE OF HOUSING IN AMERICA: GOVERNMENT REGULATIONS AND THE HIGH COST OF HOUSING CHRG-114hhrg23889 A. Mechele Dickerson Professor The University of Texas at Austin School of Law  
14033 ICANN GOVERNANCE CHRG-107shrg87255 A. Michael Froomkin Professor of Law University of Miami School of Law  
50722 A FRESH START FOR NEW STARTS CHRG-111shrg54280 A. Nicole Clowers Acting Director Physical Infrastructure Issues, Government Accountability Office  
61323 THE NEED FOR NATIONAL MORTGAGE SERVICING STANDARDS CHRG-112shrg70857 A. Nicole Clowers Acting Director Financial Markets and Community Investment, Government Accountability Office  
64504 WHO IS TOO BIG TO FAIL? GAO'S ASSESSMENT OF THE FINANCIAL STABILITY OVERSIGHT COUNCIL AND THE OFFICE OF FINANCIAL RESEARCH CHRG-113hhrg80873 A. Nicole Clowers Director Financial Markets and Community Investment, U.S. Government Accountability Office  
68913 OVERSIGHT OF THE FINANCIAL STABILITY OVERSIGHT COUNCIL CHRG-113hhrg91162 A. Nicole Clowers Director Financial Markets and Community Investment Team, U.S. Government Accountability Office  
85814 EXAMINING THE AVAILABILITY OF SAFE KITS AT HOSPITALS IN THE UNITED STATES CHRG-115hhrg36850 A. Nicole Clowers Managing Director Healthcare, Government Accountability Office  
91851 ACCOUNTABILITY IN CRISIS: GAO'S RECOMMENDATIONS TO IMPROVE THE FEDERAL CORONAVIRUS RESPONSE CHRG-116hhrg41892 A. Nicole Clowers Managing Director The Healthcare Team (accompanying)  
6957 IRAN'S BALLISTIC MISSILE AND WEAPONS OF MASS DESTRUCTION PROGRAMS CHRG-106shrg68305 A. Norman Schindler Deputy Director DCI Nonproliferation Center  
87997 THE FRONT LINES OF THE OPIOID CRISIS: PERSPECTIVES FROM STATES, COMMUNITIES, AND PROVIDERS CHRG-115shrg48380 A. Omar Abubaker D.M.D, Ph.D., Professor and S. Elmer Bear Chair Virginia Commonwealth University School of Dentistry Richmond, VA
107801 AMERICA BUILDS: MARITIME INFRASTRUCTURE CHRG-119hhrg59733 A. Paul Anderson President and Chief Executive Officer Port Tampa Bay,  
46307 HEARING TO REVIEW PROPOSALS TO ESTABLISH EXCHANGES TRADING ``MOVIE FUTURES'' CHRG-111hhrg56431 A. Robert Pisano President and interim CEO, D.C Motion Picture Association of America, Inc., Washington  
39656 ROGUE ONLINE PHARMACIES: THE GROWING PROBLEM OF INTERNET DRUG TRAFFICKING CHRG-110shrg43987 A. Thomas McLellan Chief Executive Officer Treatment Research Institute, Philadelphia, Pennsylvania, statement  
40111 CREDIT CARDS AND BANKRUPTCY: OPPORTUNITIES FOR REFORM CHRG-110shrg48088 A. Thomas Small   U.S. Bankruptcy Judge, Eastern District of North Carolina, on behalf of the National Bankruptcy Conference, Wilson, North Carolina  
51798 COULD BANKRUPTCY REFORM HELP PRESERVE SMALL BUSINESS JOBS? CHRG-111shrg58267 A. Thomas Small   Judge, Eastern District of North Carolina, Co- Chair National Bankruptcy Conference, Small Business Working Group  
52254 CHALLENGES AND OPPORTUNITIES IN THE NASA FISCAL YEAR 2011 BUDGET PROPOSAL CHRG-111shrg64486 A. Thomas Young Former Director, NASA Goddard Space Flight Center and President and Chief Operating Officer Martin Marietta Corporation  
71692 FORECASTING SUCCESS: ACHIEVING U.S. WEATHER READINESS FOR THE LONG TERM CHRG-113shrg93659 A. Thomas Young   Chair, Satellite Independent Review Team, NOAA  
41540 ADMINISTRATION'S PROPOSAL TO REAUTHORIZE THE FEDERAL AVIATION ADMINISTRATION ( PART II ) CHRG-110shrg79905 A.A.E. Barclay President, American Association of Airport Executives; on Behalf of the Airport Legislative Alliance Charles ``Chip'' M.  
41273 IMPROVING AIR SERVICES TO SMALL AND RURAL COMMUNITIES CHRG-110shrg75608 A.A.E. Courtney Mark F., Airport Director Lynchburg Regional Airport  
34560 HIDDEN TRAGEDY: UNDERREPORTING OF WORKPLACE INJURIES AND ILLNESSES CHRG-110hhrg42881 A.C. Span former employee Bashas' Distribution Center  
86606 HEARING ON THE NOMINATIONS OF KENNETH E. ALLEN, A.D. FRAZIER, JEFFREY SMITH, AND JAMES R. THOMPSON III TO BE MEMBERS OF THE BOARD OF DIRECTORS OF THE TENNESSEE VALLEY AUTHORITY CHRG-115shrg27748 A.D. Frazier nominated to be a Member of the Board of Directors of the Tennessee Valley Authority    
87617 REAUTHORIZATION OF THE MAGNUSON-STEVENS FISHERY CONSERVATION AND MANAGEMENT ACT: OVERSIGHT OF FISHERIES MANAGEMENT SUCCESSES AND CHALLENGES (PART 2) CHRG-115shrg34304 A.G. "Spud" Woodward Director Coastal Resources Division, Georgia Department of Natural Resources  
37698 THE RECENT SALMONELLA OUTBREAK: LESSONS LEARNED AND CONSEQUENCES TO INDUSTRY AND PUBLIC HEALTH CHRG-110hhrg61557 A.G. Kawamura Secretary Department of Food and Agriculture, State of California  
16402 IMPACT OF THE SECTION 201 SAFEGUARD ACTION ON CERTAIN STEEL PRODUCTS CHRG-108hhrg89863 A.J. Rose Manufacturing Company   David Pritchard  
16574 IMPROVING THE QUALITY AND EFFICIENCY OF COMMODITY DISTRIBUTION TO FEDERAL CHILD NUTRITION PROGRAMS CHRG-108hhrg90141 A.J. Yates Administrator, Agricultural Marketing Service U.S. Department of Agriculture  
50632 IMPROVING TRANSPARENCY AND ACCESSIBILITY OF FEDERAL CONTRACTING DATABASES CHRG-111shrg53844 A.R. Trey Hodgkins Vice President III, National Security and Procurement Policy, TechAmerica  
55499 [H.A.S.C. No. 112-66]CHALLENGES TO DOING BUSINESS WITH THE DEPARTMENT OF DEFENSE CHRG-112hhrg70782 A.R. ``Trey Hodgkins Senior Vice President for National Security and Procurement Policy '' III, TechAmerica  
91800 [H.A.S.C. No. 116-44] Shattered Families, Shattered Service: Taking Military Domestic Violence Out Of The Shadows CHRG-116hhrg41472 A.T. Johnston Deputy Assistant Secretary of Defense for Military and Community and Family Policy Department of Defense; and Kenneth Noyes, Associate Director DOD Family Advocacy Program (Military Family Readiness Policy), Department of Defense  
56567 CYBERSECURITY: THREATS TO THE FINANCIAL SECTOR CHRG-112hhrg72601 A.T. Smith Assistant Director, United States Secret Service    
16819 THE ROLE OF FCRA IN THE CREDIT GRANTING PROCESS CHRG-108hhrg91542 A.W. III Pickel President and CEO, President-Elect Leader Mortgage Company, Lenexa, KS, National Association of Mortgage Brokers  
17554 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 A.W. III Pickel President National Association of Mortgage Brokers  
24693 TRANSFORMING THE FEDERAL HOUSING ADMINISTRATION FOR THE 21ST CENTURY CHRG-109hhrg30534 A.W. III Pickel past President National Association of Mortgage Brokers  
28569 FHA: ISSUES FOR THE FUTURE CHRG-109shrg49425 A.W. Pickel President and Chief Executive Officer III, LeaderOne Financial Corporation, on behalf of the National Association of Mortgage Brokers  
20284 AIR SERVICE TO SMALL AND RURAL COMMUNITIES CHRG-108shrg91290 AAE Frallic Bruce A., Executive Director Gulfport-Biloxi International Airport  
3293 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg54718 AASHTO Resolution      

Next page

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,
    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 != '';