documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

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

66 rows where document_type = "Other" and posted_year = 1995 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subtype, posted_month, comment_start_date, open_for_comment, posted_date (date), comment_start_date (date), last_modified (date)

posted_year 1

  • 1995 · 66 ✖

document_type 1

  • Other · 66 ✖

agency_id 1

id agency_id docket_id title document_type subtype posted_date ▲ posted_year posted_month comment_start_date comment_end_date last_modified fr_doc_num open_for_comment withdrawn object_id
FDA-1978-N-2157-0006 FDA Skin Protectant Drug Proposed Rulemaking for Diaper Rash FDA-1978-N-2157 Acknowledgement Letter FDA/DDM to The Proctor & Gamble Company Other Acknowledgement Letter/Receipt 1995-12-22T05:00:00Z 1995 12     2019-08-01T18:37:54Z   0 0 09000064805a6715
FDA-1978-N-2157-0004 FDA Skin Protectant Drug Proposed Rulemaking for Diaper Rash FDA-1978-N-2157 Acknowledgement Letter FDA/DDM to Huls America, Inc. Other Acknowledgement Letter/Receipt 1995-12-22T05:00:00Z 1995 12     2019-08-01T18:45:05Z   0 0 09000064805a6713
FDA-1978-N-2157-0005 FDA Skin Protectant Drug Proposed Rulemaking for Diaper Rash FDA-1978-N-2157 Acknowledgment Letter from FDA/DDM to Smith & Nephew United Inc. re: Citizen Petition from Smith & Nephew United, Inc. Other Acknowledgement Letter/Receipt 1995-12-22T05:00:00Z 1995 12     2019-06-03T13:50:38Z   0 0 09000064805a6714
FDA-1995-P-0044-0003 FDA Modify Advice Bioequivalence of generic ammonium lactate-CLOSED FDA-1995-P-0044 FDA/DDM to Westwood Squibb Pharmaceuticals, Inc Other ACK-Acknowledgement Letter 1995-11-27T05:00:00Z 1995 11     2008-05-16T23:07:30Z   0 0 090000648056143f
FDA-1978-N-0018-0144 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Letter from The Assembly State of New York, Albany to FDA Other Letter(s) 1995-11-22T05:00:00Z 1995 11     2019-07-23T18:14:02Z   0 0 090000648055a251
FDA-1995-P-0023-0001 FDA Add Terminal Dry-Heat Inactivation of Plasma-Derived Factor8-CLOSED FDA-1995-P-0023 HFA-305 to Columbia University of School of Public Health Other ACK-Acknowledgement Letter 1995-11-20T05:00:00Z 1995 11     2008-05-16T23:07:11Z   0 0 0900006480559662
FDA-1995-P-0010-0001 FDA Current Good Manufacturing Practices Regulations for Medicated Feeds FDA-1995-P-0010 Acknowledgement Letter to American Feed Industry Association and Animal Health Institute Other ACK-Acknowledgement Letter 1995-11-14T05:00:00Z 1995 11     2013-07-28T01:44:10Z   0 0 090000648055842e
FDA-1978-N-0018-0143 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Memorandum of Meeting Between FDA and Givaudan-Roure Corporation et al August 11, 1995 Other Memorandum 1995-11-01T05:00:00Z 1995 11     2019-07-23T16:14:40Z   0 0 090000648055a248
FDA-1995-P-0042-0001 FDA Regulate Caffeine Beverages as Drugs and/or Devices-CLOSED FDA-1995-P-0042 Acknowledgment Letter from FDA DMB to Competitive Enterprise Institute Other ACK-Acknowledgement Letter 1995-10-31T05:00:00Z 1995 10     2025-09-15T16:26:01Z   0 0 090000648056126b
FDA-1982-P-0001-0011 FDA Bacitracin Zinc Premix FDA-1982-P-0001 FDA/Associate Commissioner for Regulatory Affairs Other PDN-Petition Denial 1995-10-27T04:00:00Z 1995 10     2008-05-30T22:53:10Z   0 0 090000648050d497
FDA-1978-N-0018-0142 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Letter from FDA CDER to the Honorable Audrey I. Pheffer & Harvey Weisenberg, New York State Assembly Other Letter(s) 1995-10-26T04:00:00Z 1995 10     2019-07-23T16:02:30Z   0 0 090000648055a246
FDA-1995-P-0004-0001 FDA ANDA Suitability for 2.5mg Hydrocodone Bitrate & 5mg Phenylephrine-CLOSED FDA-1995-P-0004 Acknowledgement Letter from FDA DMB to Bock Pharmacal Co Other Acknowledgement Letter/Receipt 1995-10-12T04:00:00Z 1995 10     2024-06-06T01:00:29Z   0 0 09000064805583cb
FDA-1980-N-0074-0032 FDA Anticaries Drug Products for OTC Human Use; FDA-1980-N-0074 Letter from FDA HFD-811 to Cosmetic, Toiletry and Fragrance Association Other Letter(s) 1995-10-04T04:00:00Z 1995 10     2022-04-21T20:23:50Z   0 0 09000064805bb362
FDA-1995-S-0039-0001 FDA 75-Day Premarket Notifications for New Dietary Ingredients FDA-1995-S-0039 Memorandum from FDA/CFSAN Other M-Memorandum 1995-09-27T04:00:00Z 1995 9     2016-09-30T14:17:47Z   0 0 090000648055bacf
FDA-1991-P-0020-0001 FDA Ban the Advertising of Prescription Drugs - CLOSED FDA-1991-P-0020 Letter from FDA to Bass & Ullman on Behalf of National Association of Pharmaceutical Manufacturers Other Letter(s) 1995-08-28T04:00:00Z 1995 8     2023-11-16T21:52:45Z   0 0 09000064805284a2
FDA-1995-P-0006-0003 FDA ANDA for Butalbital, Acetaminophen, Caffeine and Hydrocodone-CLOSED FDA-1995-P-0006 Acknowledgment Letter from FDA DMB to Mikart, Inc. Other Acknowledgement Letter/Receipt 1995-08-21T04:00:00Z 1995 8     2025-09-19T00:46:55Z   0 0 0900006480558400
FDA-1995-P-0006-0002 FDA ANDA for Butalbital, Acetaminophen, Caffeine and Hydrocodone-CLOSED FDA-1995-P-0006 Acknowledgment Letter from FDA DMB to Mikart, Inc. Other Acknowledgement Letter/Receipt 1995-08-21T04:00:00Z 1995 8     2025-09-19T00:46:31Z   0 0 09000064805583ff
FDA-1995-P-0006-0004 FDA ANDA for Butalbital, Acetaminophen, Caffeine and Hydrocodone-CLOSED FDA-1995-P-0006 Acknowledgment Letter from FDA DMB to Mikart, Inc. Other Acknowledgement Letter/Receipt 1995-08-21T04:00:00Z 1995 8     2025-09-19T00:47:17Z   0 0 0900006480558401
FDA-1995-P-0006-0001 FDA ANDA for Butalbital, Acetaminophen, Caffeine and Hydrocodone-CLOSED FDA-1995-P-0006 Acknowledgment Letter from FDA DMB to Mikart, Inc. Other Acknowledgement Letter/Receipt 1995-08-18T04:00:00Z 1995 8     2025-09-19T00:45:55Z   0 0 09000064805583f5
FDA-1995-P-0002-0002 FDA Revise "Approved Drug Products" (known as "Orange Book")-CLOSED FDA-1995-P-0002 HFA-305 to Kleinfeld, Kaplan & Becker Other ACK-Acknowledgement Letter 1995-08-11T04:00:00Z 1995 8     2008-05-16T23:06:15Z   0 0 0900006480558353
FDA-1995-P-0360-0002 FDA Regulatory Action to Prohibit Misleading Food Labeling FDA-1995-P-0360 Acknowledgement Letter to Citizen Petition from Center for Science in the Public Interest Other Acknowledgement Letter/Receipt 1995-08-04T04:00:00Z 1995 8 2015-04-05T04:00:00Z   2015-04-05T13:56:53Z   0 0 0900006481a8be2c
FDA-1995-P-0360-0001 FDA Regulatory Action to Prohibit Misleading Food Labeling FDA-1995-P-0360 Citizen Petition from Center for Science in the Public Interest Other Citizen Petition 1995-08-04T04:00:00Z 1995 8 2015-04-05T04:00:00Z   2015-04-05T13:57:11Z   0 0 090000648059a009
FDA-1995-P-0016-0003 FDA Implied Nutrient Content Claim 'Healthy' & Health Claims-CLOSED FDA-1995-P-0016 HFA-305 Other ACK-Acknowledgement Letter 1995-07-28T04:00:00Z 1995 7     2008-05-16T23:06:36Z   0 0 0900006480558657
FDA-1988-V-0025-0001 FDA Variance re Laser light show projector (LIP-88-1) FDA-1988-V-0025 Approval for Variance from Laser Images Productions Other Approval for Variance (VRA) 1995-07-20T04:00:00Z 1995 7     2023-12-01T16:06:11Z   0 0 09000064804763b9
FDA-1995-P-0018-0002 FDA ANDA Suit for Hydrocodone Bitartrate & Acetaminophen-CLOSED FDA-1995-P-0018 Acknowledgment Letter from FDA DMB to Mikart, Inc. Other Acknowledgement Letter/Receipt 1995-07-20T04:00:00Z 1995 7     2025-07-07T17:49:13Z   0 0 09000064805592aa
FDA-1995-P-0018-0001 FDA ANDA Suit for Hydrocodone Bitartrate & Acetaminophen-CLOSED FDA-1995-P-0018 Acknowledgment Letter from FDA DMB to Mikart, Inc. Other Acknowledgement Letter/Receipt 1995-07-20T04:00:00Z 1995 7     2025-10-11T08:00:48Z   0 0 0900006480559274
FDA-1978-N-0018-0141 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Letter from FDA CDER to Paul Pierce Other Letter(s) 1995-07-13T04:00:00Z 1995 7     2019-07-31T14:03:30Z   0 0 090000648055a240
FDA-1995-P-0017-0001 FDA Oat Products and Coronary Heart Disease FDA-1995-P-0017 HFS-150 to The Quaker Oats Company Other ACK-Acknowledgement Letter 1995-07-06T04:00:00Z 1995 7     2008-05-16T23:06:49Z   0 0 0900006480558802
FDA-1995-P-0041-0001 FDA Exempt Medical Gases from the Requirements of 21 CFR 205-CLOSED FDA-1995-P-0041 Acknowledgment Letter from FDA DDM to Compressed Gas Association, Inc. Other Acknowledgement Letter/Receipt 1995-06-26T04:00:00Z 1995 6     2017-02-14T15:24:15Z   0 0 09000064805611af
FDA-1995-P-0051-0004 FDA Ban the Use of Lindane as a Treatment for Lice and Scabies-CLOSED FDA-1995-P-0051 Acknowledgment Letter from FDA DMB to Public Citzen Health Research Group Other Acknowledgement Letter/Receipt 1995-06-16T04:00:00Z 1995 6     2025-09-15T21:41:17Z   0 0 0900006480561e5c
FDA-2020-D-2006-0001 FDA FDA-2020-D-2006 Guidance for Industry: Letter to Manufacturers, Importers, and Distributors of Imported Candy and Candy Wrappers Other Guidance 1995-06-13T04:00:00Z 1995 6 2020-09-23T04:00:00Z   2024-11-06T23:39:05Z   1 0 09000064848746a5
FDA-1995-P-0058-0001 FDA Enforce SMDA & Existing Regs Re: Mfgs of dental lubricants-CLOSED FDA-1995-P-0058 Acknowledgment Letter from FDA DMB to Lerch, McDaniel & Kauo, PLC Other Acknowledgement Letter/Receipt 1995-06-06T04:00:00Z 1995 6     2025-09-09T09:00:16Z   0 0 090000648056c3d3
FDA-1995-P-0015-0001 FDA Amend Monograph on Antiemetic Drug Prods for OTC Human Use-CLOSED FDA-1995-P-0015 Acknowledgement Letter from FDA HFA-305 to Akin, Grump, Strauss, Hauer & Feld, L.L.P Other Acknowledgement Letter/Receipt 1995-05-30T04:00:00Z 1995 5     2022-08-17T18:52:38Z   0 0 0900006480558564
FDA-1978-N-0018-0140 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Memorandum of Telephone Conversation Between Dr. Weinstock, Brown University & Jeanne Rippere, FDA April 18, 1995 Other Memorandum 1995-05-11T04:00:00Z 1995 5     2019-07-31T14:07:58Z   0 0 090000648055a230
FDA-1978-N-0018-0139 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Memorandum of Telephone Conversation Between Dr. J. Ferguson, Boots Contract Manufacturing & Jeanne Rippere, FDA May 1, 1995 Other Memorandum 1995-05-11T04:00:00Z 1995 5     2019-07-23T13:31:51Z   0 0 090000648055a22d
FDA-1994-P-0013-0002 FDA Reference Amount of Wild Rice-CLOSED FDA-1994-P-0013 Letter from FDA CFSAN to Minnesota Cultivated Wild Rice Council- Envelope Other Letter(s) 1995-04-24T04:00:00Z 1995 4     2024-06-27T03:31:05Z   0 0 09000064804fc7db
FDA-1995-P-0043-0001 FDA Prescription Drug Advertisements-CLOSED FDA-1995-P-0043 Acknowledgement Letter to Sonnenreich, Roccograndi & Woo Other Acknowledgement Letter/Receipt 1995-04-24T04:00:00Z 1995 4     2012-09-20T17:09:08Z   0 0 090000648056133f
FDA-1994-P-0013-0001 FDA Reference Amount of Wild Rice-CLOSED FDA-1994-P-0013 Letter from FDA CFSAN to Minnesota Cultivated Wild Rice Council Other Letter(s) 1995-04-24T04:00:00Z 1995 4     2024-06-27T03:29:24Z   0 0 09000064804fc7a4
FDA-1981-N-0013-0012 FDA Oral Health Care Drug Products for OTC Human Use FDA-1981-N-0013 HFA-305 to SmithKline Beecham Consumer Healthcare Other ACK-Acknowledgement Letter 1995-04-14T04:00:00Z 1995 4     2008-05-30T22:52:38Z   0 0 09000064805aec25
FDA-1995-P-0035-0002 FDA Use URAA to Determine Approval eff date of ANDA's-CLOSED FDA-1995-P-0035 HFA-305 to Arnold & Porter Other ACK-Acknowledgement Letter 1995-03-31T05:00:00Z 1995 3     2008-05-16T23:07:26Z   0 0 090000648055af3a
FDA-1981-N-0013-0013 FDA Oral Health Care Drug Products for OTC Human Use FDA-1981-N-0013 HFA-305 to SmithKline Beecham Consumer Healthcare Other ACK-Acknowledgement Letter 1995-03-29T05:00:00Z 1995 3     2008-05-30T22:53:17Z   0 0 09000064805aec26
FDA-1978-N-0018-0138 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Memorandum of Meeting Between FDA and Givaudan-Roure, et al. March 6, 1995 Other Memorandum 1995-03-27T05:00:00Z 1995 3     2019-07-23T13:26:06Z   0 0 090000648055a22b
FDA-1995-G-0034-0001 FDA Hydrophobic Silica for Animal Feeds-CLOSED FDA-1995-G-0034 FDA/CVM to Degussa Corporation (Keller & Heckman) - Letter Other Letter(s) 1995-03-23T05:00:00Z 1995 3     2013-07-27T21:36:27Z   0 0 090000648055ae18
FDA-1995-P-0045-0002 FDA Permit the removal of fat from standardized foods FDA-1995-P-0045 Acknowledgment Letter from FDA DMB to Lyn O' Brien Nabors Other Acknowledgement Letter/Receipt 1995-03-20T05:00:00Z 1995 3     2025-07-21T21:30:16Z   0 0 09000064805614fe
FDA-2020-D-1968-0001 FDA FDA-2020-D-1968 CPG Sec. 355.300 Ion Generating Devices Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-06T23:38:56Z   1 0 0900006484868f5e
FDA-1995-P-0415-0001 FDA "MDI Albuterol" be submitted to a Joint A.C. for Hearing-CLOSED FDA-1995-P-0415 Acknowledgment Letter from FDA DDM to Schering Corporation Other Acknowledgement Letter/Receipt 1995-03-01T05:00:00Z 1995 3     2017-02-04T19:56:21Z   0 0 09000064805a6462
FDA-2020-D-1969-0001 FDA FDA-2020-D-1969 CPG Sec. 390.425 Records and Reports; Applicability - 21 CFR 1002.1 Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-12T23:25:11Z   1 0 0900006484868f60
FDA-2010-N-0551-0002 FDA FDA-2010-N-0551 CPG Sec. 393.200 Laser(s) as Medical Devices for Facelift, Wrinkle Removal, Acupuncture, Auricular Stimulation, etc. (CPG 7133.21) Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-30T04:00:00Z   2024-11-12T23:26:10Z   1 0 09000064848a4277
FDA-2020-D-1962-0001 FDA FDA-2020-D-1962 CPG Sec. 300.400 Contamination of Devices Labeled as Sterile Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-06T23:38:58Z   1 0 0900006484866867
FDA-1984-D-0144-0002 FDA CYTOTOXIC TESTING FOR ALLERGIC DISEASES CPG FDA-1984-D-0144 CPG Sec. 370.100 Cytotoxic Testing for Allergic Diseases (CPG 7124.27) Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-30T04:00:00Z   2024-11-06T23:39:54Z   1 0 09000064848a4275
FDA-2020-D-1964-0001 FDA FDA-2020-D-1964 CPG Sec. 335.500 Razor Blades, Manicuring Instruments - Not Considered Devices Under 201(h) Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-06T23:38:58Z   1 0 090000648486686b
FDA-2020-D-1970-0001 FDA FDA-2020-D-1970 CPG Sec. 391.200 Warning Statement in Advertisements for High-Intensity Mercury Vapor Discharge Lamps that are not Self-Extinguishing (21 CFR 1040.30(e)(3)*) Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-06T23:38:56Z   1 0 0900006484868f82
FDA-1984-D-0144-0001 FDA CYTOTOXIC TESTING FOR ALLERGIC DISEASES CPG FDA-1984-D-0144 CPG Sec. 370.100 Cytotoxic Testing for Allergic Diseases Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-30T04:00:00Z   2024-11-12T23:26:11Z   1 0 09000064848a4273
FDA-2020-D-1966-0001 FDA FDA-2020-D-1966 CPG Sec. 345.300 Menstrual Sponges Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-06T23:38:56Z   1 0 0900006484868f5a
FDA-2020-D-1967-0001 FDA FDA-2020-D-1967 CPG Sec. 355.200 Electrical Muscle Stimulators Other Guidance 1995-03-01T05:00:00Z 1995 3 2020-09-21T04:00:00Z   2024-11-12T23:25:06Z   1 0 0900006484868f5c
FDA-2020-D-1975-0001 FDA FDA-2020-D-1975 CPG Sec. 398.200 Hazardous Diagnostic X-ray Systems Other Guidance 1995-02-28T05:00:00Z 1995 2 2020-09-22T04:00:00Z   2024-11-12T23:25:06Z   1 0 0900006484868fa1
FDA-1995-P-0024-0001 FDA Refuse to Approve Any NDA for RU 486 used as abortifacient FDA-1995-P-0024 HFA-305 to McKenna & Cuneo Other ACK-Acknowledgement Letter 1995-02-28T05:00:00Z 1995 2     2008-05-16T23:07:15Z   0 0 0900006480559760
FDA-2020-D-1971-0001 FDA FDA-2020-D-1971 CPG Sec. 300.300 Ineffective Devices - 502(f)(I) Labeling Requirements Other Guidance 1995-02-28T05:00:00Z 1995 2 2020-09-21T04:00:00Z   2024-11-12T23:25:11Z   1 0 0900006484868f84
FDA-2020-D-1972-0001 FDA FDA-2020-D-1972 CPG Sec. 310.100 Pacemaker Reuse Other Guidance 1995-02-28T05:00:00Z 1995 2 2020-09-21T04:00:00Z   2024-11-06T23:38:56Z   1 0 0900006484868f86
FDA-2020-D-1974-0001 FDA FDA-2020-D-1974 CPG Sec. 397.100 Accuracy Requirements for Indication of Temporal-Maximum Ultrasonic Power, 21 CFR 1050.10(c)(1)(ii) Other Guidance 1995-02-28T05:00:00Z 1995 2 2020-09-22T04:00:00Z   2024-11-06T23:38:57Z   1 0 0900006484868f8a
FDA-1981-N-0012-0014 FDA OTC Weight Control Drug Products for Human Use FDA-1981-N-0012 HFA-305 to Caprice-Grestoke, Ltd. Other ACK-Acknowledgement Letter 1995-02-09T05:00:00Z 1995 2     2008-05-30T22:53:16Z   0 0 09000064805ae8d9
FDA-1981-N-0012-0012 FDA OTC Weight Control Drug Products for Human Use FDA-1981-N-0012 HFA-305 to Caprice-Grestoke, Ltd Other ACK-Acknowledgement Letter 1995-02-02T05:00:00Z 1995 2     2008-05-30T22:53:23Z   0 0 09000064805ae8d7
FDA-1981-N-0012-0013 FDA OTC Weight Control Drug Products for Human Use FDA-1981-N-0012 HFA-305 to Caprice-Grestoke, Ltd Other ACK-Acknowledgement Letter 1995-02-02T05:00:00Z 1995 2     2008-05-30T22:53:16Z   0 0 09000064805ae8d8
FDA-1995-P-0051-0003 FDA Ban the Use of Lindane as a Treatment for Lice and Scabies-CLOSED FDA-1995-P-0051 Acknowledgment Letter from FDA DMB to Cancer Prevention Coalition Other Acknowledgement Letter/Receipt 1995-01-24T05:00:00Z 1995 1     2025-09-15T21:40:34Z   0 0 0900006480561e5a
FDA-1978-N-0018-0137 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Letter from FDA CDER to The Cosmetic, Toiletry & Fragrance Association Other Letter(s) 1995-01-17T05:00:00Z 1995 1     2019-07-23T13:04:51Z   0 0 090000648055a1e9
FDA-1978-N-0018-0136 FDA Sunscreen Drug Products -OPEN FDA-1978-N-0018 Letter from FDA CDER to Nonprescription Drug Manufacturers Association Other Letter(s) 1995-01-17T05:00:00Z 1995 1     2019-07-22T18:10:56Z   0 0 090000648055a1e7

Advanced export

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

CSV options: 

CREATE TABLE documents (
    id TEXT PRIMARY KEY,
    agency_id TEXT,
    docket_id TEXT REFERENCES dockets(id),
    title TEXT,
    document_type TEXT,
    subtype TEXT,
    posted_date TEXT,
    posted_year INTEGER,
    posted_month INTEGER,
    comment_start_date TEXT,
    comment_end_date TEXT,
    last_modified TEXT,
    fr_doc_num TEXT,
    open_for_comment INTEGER,
    withdrawn INTEGER,
    object_id TEXT
);
CREATE INDEX idx_docs_agency ON documents(agency_id);
CREATE INDEX idx_docs_docket ON documents(docket_id);
CREATE INDEX idx_docs_date ON documents(posted_date);
CREATE INDEX idx_docs_year ON documents(posted_year);
CREATE INDEX idx_docs_type ON documents(document_type);
CREATE INDEX idx_docs_frnum ON documents(fr_doc_num);