documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
- comment_end_date
- A FULL UTC INSTANT, not a calendar date, despite the column name: '2026-08-29T03:59:59Z' is 11:59:59 PM EASTERN on 2026-08-28. Federal comment periods close at 11:59:59 PM Eastern, so the UTC calendar date is ONE DAY LATER than the official deadline on every end-of-day close — 444,689 of the 444,690 populated rows (measured 2026-09-06). Convert to America/New_York before presenting a deadline, and compare with julianday(comment_end_date) > julianday('now'): a plain > datetime('now') is a TEXT comparison between two different formats and keeps already-closed dockets matching for up to ~20 hours. The sibling column on open_comments.documents WAS corrected to an Eastern calendar date (queue #498); this one is unchanged and still an instant — the two databases do not agree on grain. (queue #644)
- comment_start_date
- A FULL UTC INSTANT, not a calendar date, despite the column name — same grain as comment_end_date on this table. Convert to America/New_York before presenting it. (queue #644)
29,537 rows where document_type = "Other" and posted_year = 2017 sorted by posted_date descending
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FAA-2017-1039-0002 | FAA | Rafael Dubena - Exemption/Rulemaking FAA-2017-1039 | U.S. DOT/FAA - Record of Communication | Other | Record of Meeting/Phone Conversation | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2024-11-07T01:15:29Z | 1 | 0 | 0900006482d7f2bf | ||
| FAA-2017-1254-0001 | FAA | Michelle Silva - Exemption/Rulemaking FAA-2017-1254 | Michelle Silva - Exemption/Rulemaking | Other | Petition(s) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2024-11-07T01:16:09Z | 1 | 0 | 0900006482d7f85d | ||
| FAA-2015-0971-0071 | FAA | Airlines for America - Exemption/Rulemaking FAA-2015-0971 | Volga-Dnepr Airlines LLC - Letter of Intent | Other | Letter(s) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2024-11-07T01:16:20Z | 1 | 0 | 0900006482d8211f | ||
| FAA-2017-0849-0003 | FAA | Lockheed Martin Aeronautics Company - Exemption/Rulemaking FAA-2017-0849 | U.S. DOT/FAA - Decision | Other | Decision | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2024-11-07T01:15:27Z | 1 | 0 | 0900006482d7ff69 | ||
| FDA-2017-V-7020-0002 | FDA | Laser Light Show FDA-2017-V-7020 | Acknowledgment Letter from FDA DDM to W6 Restaurant Group LTD | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:38:57Z | 0 | 0 | 0900006482d83ab8 | ||
| FDA-2017-H-6960-0001 | FDA | DAB Civil Money Penalty; Chrisman L.P. Gas, Inc. d/b/a C-Mart; CLOSED 01/22/2018 FDA-2017-H-6960 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:59:43Z | 0 | 0 | 0900006482d84c25 | ||
| FDA-2017-H-6973-0001 | FDA | DAB Civil Money Penalty; Allgood’s Quick Stop, Inc.d/b/a Allgoods Quick Stop; CLOSED 04/20/2018 FDA-2017-H-6973 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T19:30:07Z | 0 | 0 | 0900006482d84ca5 | ||
| FDA-2017-V-7020-0001 | FDA | Laser Light Show FDA-2017-V-7020 | Variance Application from W6 Restaurant Group LTD | Other | Application for Variance (VAR) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:38:51Z | 0 | 0 | 0900006482d83ab6 | ||
| FDA-2017-P-7031-0002 | FDA | Requests that the FDA determnine a new Reference Standard Drug (RS) for Generic Drug Product for Thiamine Hydrochloride Injection 100 m/g ml vial, NDA N080556 for listing in the Approved Drug Products with Therapeutics Equivalence Evaluations (Orange Book). FDA-2017-P-7031 | Acknowledgment Letter from FDA DDM to JRRapoza Associates, Inc | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T17:34:05Z | 0 | 0 | 0900006482d8388f | ||
| FDA-2017-P-7032-0001 | FDA | Requests that the FDA determine that the drug product, Esomeprazole Magnesium Delayed Release Capsules, USP 10 mg, is suitable for consideration in an Abbreviated New Drug Application FDA-2017-P-7032 | Citizen Petition from Jubilant Generics Limited | Other | Citizen Petition | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-06-28T03:59:59Z | 2018-01-02T16:48:06Z | 0 | 0 | 0900006482d843bf | |
| FDA-2017-V-7023-0001 | FDA | Laser Light Show FDA-2017-V-7023 | Variance Application from Platinum AVL | Other | Application for Variance (VAR) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:37:20Z | 0 | 0 | 0900006482d83c59 | ||
| FDA-1977-N-0025-0007 | FDA | Internal, Analgesic, Antipyretic & Antirheumatic Drug Products - OPEN FDA-1977-N-0025 | Supplement from Wyeth Consumer Healthcare | Other | Supplement (SUP) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2019-02-01T15:40:00Z | 0 | 0 | 09000064805da2f9 | ||
| FDA-2017-H-6986-0001 | FDA | DAB Civil Money Penalty; Oska Inc. d/b/a 7-Eleven Store 34827B; CLOSED 02/01/2018 FDA-2017-H-6986 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T20:05:43Z | 0 | 0 | 0900006482d85162 | ||
| FDA-2017-V-7021-0002 | FDA | Laser Light Show FDA-2017-V-7021 | Acknowledgment Letter from FDA DDM to Trio Nightclub | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:41:48Z | 0 | 0 | 0900006482d83abe | ||
| FDA-2014-P-0646-0011 | FDA | Requests That the FDA Declare That the Drug Trazodone Hydrochloride Oral Solution (10mg/mL) is Suitable for Submission as an Abbreviated New Drug Application (ANDA). FDA-2014-P-0646 | Letter from Kamat Pharmatech to FDA DDM | Other | Letter(s) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:42:48Z | 0 | 0 | 0900006482d8388b | ||
| FDA-2017-P-7032-0002 | FDA | Requests that the FDA determine that the drug product, Esomeprazole Magnesium Delayed Release Capsules, USP 10 mg, is suitable for consideration in an Abbreviated New Drug Application FDA-2017-P-7032 | Acknowledgment Letter from FDA DDM to Jubilant Generics Limited | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-01-02T16:48:30Z | 0 | 0 | 0900006482d843c1 | ||
| FDA-2017-H-6948-0001 | FDA | DAB Civil Money Penalty; Log Cabin Resorts, Inc., d/b/a Northwest Tobacco Emporium; CLOSED 03/23/2018 FDA-2017-H-6948 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:48:22Z | 0 | 0 | 0900006482d84e08 | ||
| FDA-2017-P-7033-0001 | FDA | Requests that the FDA determine that the drug product, Oxcarbazepine Oral Tablet 450 mg (dual scored) is suitable for consideration in an Abbreviated New Drug Application FDA-2017-P-7033 | Citizen Petition from Jubliant Generics Limited | Other | Citizen Petition | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-06-28T03:59:59Z | 2018-01-02T16:50:17Z | 0 | 0 | 0900006482d84d79 | |
| FDA-2017-H-6958-0001 | FDA | DAB Civil Money Penalty; Harsh Inc. d/b/a 7-Eleven 36365A; CLOSED 02/02/2018 FDA-2017-H-6958 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:54:54Z | 0 | 0 | 0900006482d84e3e | ||
| FDA-2017-H-6952-0001 | FDA | DAB Civil Money Penalty; Dolgencorp LLC d/b/a Dollar General 10867; CLOSED 01/11/2018 FDA-2017-H-6952 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:47:45Z | 0 | 0 | 0900006482d84e02 | ||
| FDA-2017-D-6530-0002 | FDA | Formal Meetings Between the Food and Drug Administration and Sponsors or Applicants of Prescription Drug User Fee Act Products FDA-2017-D-6530 | Formal Meetings Between the FDA and Sponsors or Applicants of PDUFA Products Guidance for Industry DRAFT GUIDANCE | Other | Guidance | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-03-30T03:59:59Z | 2024-11-07T01:15:37Z | 1 | 0 | 0900006482d7eb25 | |
| FDA-2017-D-6564-0002 | FDA | Best Practices for Communication Between Investigational New Drug Application Sponsors and the Food and Drug Administration FDA-2017-D-6564 | Best Practices for Communication Between IND Sponsors and FDA During Drug Development Guidance for Industry and Review Staff | Other | Guidance | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2024-11-07T01:15:37Z | 1 | 0 | 0900006482d7eb23 | ||
| FDA-2017-P-7033-0002 | FDA | Requests that the FDA determine that the drug product, Oxcarbazepine Oral Tablet 450 mg (dual scored) is suitable for consideration in an Abbreviated New Drug Application FDA-2017-P-7033 | Acknowledgment Letter from FDA DDM to Jubilant Generics Limited | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-01-02T16:50:45Z | 0 | 0 | 0900006482d84da4 | ||
| FDA-2017-P-7034-0001 | FDA | Requests that the FDA determine that the drug product, Valacyclovir Hydrochloride Oral Tablet EQ 250 mg and 750 mg base are suitable for consideration in an Abbreviated New Drug Application. FDA-2017-P-7034 | Citizen Petition from Jubilant Generics Limited | Other | Citizen Petition | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-06-28T03:59:59Z | 2018-01-02T16:52:40Z | 0 | 0 | 0900006482d84d2a | |
| FDA-2017-P-7031-0001 | FDA | Requests that the FDA determnine a new Reference Standard Drug (RS) for Generic Drug Product for Thiamine Hydrochloride Injection 100 m/g ml vial, NDA N080556 for listing in the Approved Drug Products with Therapeutics Equivalence Evaluations (Orange Book). FDA-2017-P-7031 | Citizen Petition from JRRapoza Associates, Inc | Other | Citizen Petition | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-06-28T03:59:59Z | 2017-12-29T17:33:49Z | 0 | 0 | 0900006482d8388d | |
| FDA-2016-N-0832-0057 | FDA | Phibro Animal Health Corp.; Carbadox in Medicated Swine Feed; Opportunity for Hearing FDA-2016-N-0832 | Letter from Phibro Animal Health Corporation | Other | Letter(s) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T15:57:53Z | 0 | 0 | 0900006482d83a18 | ||
| FDA-2017-V-7023-0002 | FDA | Laser Light Show FDA-2017-V-7023 | Acknowledgement Letter from FDA DDM to Platinum AVL | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:37:25Z | 0 | 0 | 0900006482d83c5c | ||
| FDA-2017-V-7028-0002 | FDA | Laser Light Show FDA-2017-V-7028 | Acknowledgement Letter from FDA DDM to Richard Nguyen | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:19:48Z | 0 | 0 | 0900006482d84abf | ||
| FDA-2017-H-6963-0001 | FDA | DAB Civil Money Penalty; Bostick, Bowers Padgett, LTD. d/b/a Bobops 2; CLOSED 02/09/2018 FDA-2017-H-6963 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T19:24:17Z | 0 | 0 | 0900006482d84efa | ||
| FDA-2017-P-7034-0002 | FDA | Requests that the FDA determine that the drug product, Valacyclovir Hydrochloride Oral Tablet EQ 250 mg and 750 mg base are suitable for consideration in an Abbreviated New Drug Application. FDA-2017-P-7034 | Acknowledgment Letter from FDA DDM to Jubilant Generics Limited | Other | Acknowledgement Letter/Receipt | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-01-02T16:53:05Z | 0 | 0 | 0900006482d84d2c | ||
| FDA-2017-H-6953-0001 | FDA | DAB Civil Money Penalty; Rakesh Kapadia d/b/a B and B Corner; CLOSED 02/14/2018 FDA-2017-H-6953 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:45:41Z | 0 | 0 | 0900006482d84e38 | ||
| FDA-2017-V-7021-0001 | FDA | Laser Light Show FDA-2017-V-7021 | Variance Application from Trio Nightclub | Other | Application for Variance (VAR) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T16:41:43Z | 0 | 0 | 0900006482d83abc | ||
| FDA-2017-V-7028-0001 | FDA | Laser Light Show FDA-2017-V-7028 | Variance Application from RICHARD NGUYEN | Other | Application for Variance (VAR) | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T18:19:42Z | 0 | 0 | 0900006482d837cd | ||
| FDA-2017-H-6972-0001 | FDA | DAB Civil Money Penalty; Lugo Puig, Inc. d/b/a Stop N Shop; CLOSED 03/13/2018 FDA-2017-H-6972 | Complaint | Other | Complaint | 2017-12-29T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2017-12-29T19:11:59Z | 0 | 0 | 0900006482d84ef4 | ||
| DOT-OST-2016-0188-0010 | DOT | Western Air Charter Inc. d/b/a Jet Edge - Determination of Authority - Commuter Air Carrier Authority DOT-OST-2016-0188 | 2017-12-24 Order to Show Cause Proposing Issuance of Commuter Air Carrier Authority | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:51Z | 1 | 0 | 0900006482d7c0fa | ||
| DOT-OST-2017-0195-0004 | DOT | French SAS - Exemption/Foreign Air Carrier Permit - U.S.-EU Open Skies DOT-OST-2017-0195 | Supplement No. 1 to Application of French SAS for an Exemption and Foreign Air Carrier Permit | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:34Z | 1 | 0 | 0900006482d7b442 | ||
| DOT-OST-2017-0109-0031 | DOT | Essential Air Service at St. George, Alaska DOT-OST-2017-0109 | The City of St. George, Alaska (Community Comments) | Other | Correspondence | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:24Z | 1 | 0 | 0900006482d7b300 | ||
| DOT-OST-2014-0166-0009 | DOT | Mike Borsetti et al. - Complaint Against British Airways Plc DOT-OST-2014-0166 | Contingent Answer of British Airways PLC | Other | Answer | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:29Z | 1 | 0 | 0900006482d78c64 | ||
| EPA-HQ-ORD-2014-0211-0046 | EPA | Announcement on the Availability of the IRIS Program General Comments Docket EPA-HQ-ORD-2014-0211 | Memo authorizing the opening of a comment period for this docket. | Other | Memorandum to Open a Docket | 2017-12-28T05:00:00Z | 2017 | 12 | 2018-01-01T05:00:00Z | 2019-01-01T04:59:59Z | 2018-10-24T01:03:41Z | 0 | 0 | 0900006482d76d86 | |
| EPA-HQ-OPP-2017-0402-0002 | EPA | Receipt of an Application for a New Plant-Incorporated Protectant (PIP): Bacillus thuringiensis Cry51Aa2.834_16 in cotton EPA-HQ-OPP-2017-0402 | Public Participation for New Plant-Incorporated Protectant (PIP): Bacillus thuringiensis Cry51Aa2.834_16 | Other | Public Participation | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-29T05:00:00Z | 2018-01-14T04:59:59Z | 2018-01-02T21:15:04Z | 0 | 0 | 0900006482d7d39e | |
| FAA-2000-8419-0020 | FAA | Exemption/Rulemaking - U. S. Department of the Air Force FAA-2000-8419 | U.S. Department of the Air Force - Exemption/Rulemaking | Other | Petition(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:31Z | 1 | 0 | 0900006482d7bacb | ||
| FAA-2015-0971-0070 | FAA | Airlines for America - Exemption/Rulemaking FAA-2015-0971 | AirSERBIA - Letter of Intent | Other | Correspondence | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:31Z | 1 | 0 | 0900006482d7b951 | ||
| FAA-2017-0964-0003 | FAA | Sierra Pacific Airlines, Inc. - Exemption/Rulemaking FAA-2017-0964 | Sierra Pacific Airlines, Inc. - Amendment | Other | Amendment | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:52Z | 1 | 0 | 0900006482d78a9b | ||
| FAA-2015-5565-0005 | FAA | APJ LLC - d/b/a QA Productions - Exemption/Rulemaking FAA-2015-5565 | APJ LLC d/b/a QA Productions - Exemption/Rulemaking | Other | Petition for Exemption on Section 333 | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:04:05Z | 0 | 0 | 0900006482d78bf2 | ||
| FAA-2017-0468-0004 | FAA | Sierra Pacific Airlines, Inc. - Exemption/Rulemaking FAA-2017-0468 | U.S. DOT/FAA - Record of Conversation | Other | Record of Meeting/Phone Conversation | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:29Z | 1 | 0 | 0900006482d7c7c9 | ||
| FDA-1980-N-0038-0138 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Certain Topical Anti-Infective Drug Products; Vioform-Hydrocortisone (Iodochlorhydroxyquin and Hydrocortisone) Request of CIBA-GEIGY Corporation for Hearing Vol I re: Supplement from CIBA-GEIGY (Wald, Harkrader & Ross) (Vol 1 of 3) | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T18:11:59Z | 0 | 0 | 09000064805b963e | |||
| FDA-2017-P-4039-0003 | FDA | Requests that the FDA foster a transition to opioid analgesics with abuse-deterrent labeling (ADOs) by requiring manufacturers of certain oral opioid analgesics not in abuse-deterrent formulations to convert their products to ADOs within three years of the date of this Citizen Petition or else have their products removed from the market on July 3, 2020 FDA-2017-P-4039 | Interim Response Letter from FDA CDER to Center for Lawful Access and Abuse Deterrence | Other | Letter(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T21:28:04Z | 0 | 0 | 0900006482d7f298 | ||
| FDA-2015-V-0429-0003 | FDA | Variance Request for commercial purposes in digital cinema. FDA-2015-V-0429 | Approval Letter from FDA CDRH to Power Technology, Inc. | Other | Approval for Variance (VRA) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:21:49Z | 0 | 0 | 0900006482d7b398 | ||
| FDA-2017-H-6956-0001 | FDA | DAB Civil Money Penalty; Sunrise Blvd Petroleum Corp. d/b/a BP Shop; CLOSED 02/14/2018 FDA-2017-H-6956 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:55:12Z | 0 | 0 | 0900006482d7b912 | ||
| FDA-2017-H-6957-0001 | FDA | DAB Civil Money Penalty; Cool Wave LLC d/b/a Chevron; CLOSED 01/30/2018 FDA-2017-H-6957 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T18:31:50Z | 0 | 0 | 0900006482d7c0f5 | ||
| FDA-2017-H-6954-0001 | FDA | DAB Civil Money Penalty; Sherry II LLC d/b/a Discount Tobacco; CLOSED 01/18/2018 FDA-2017-H-6954 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:25:41Z | 0 | 0 | 0900006482d7b39a | ||
| FDA-2017-H-6962-0001 | FDA | DAB Civil Money Penalty; Issa Sawage d/b/a U Pump It; CLOSED 01/18/2018 FDA-2017-H-6962 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T19:21:49Z | 0 | 0 | 0900006482d7db54 | ||
| FDA-2005-D-0140-0010 | FDA | Guidance for Industry: Nucleic Acid Testing (NAT) for Human Immunodeficiency Virus Type 1 (HIV-1) and Hepatitis C Virus (HCV): Testing, Product Disposition, and Donor Deferral and Reentry;' FDA-2005-D-0140 | Nucleic Acid Testing (NAT) for Human Immunodeficiency Virus Type 1 (HIV-1) and Hepatitis C Virus (HCV): Testing, Product Disposition, and Donor Deferral and Reentry: Guidance for Industry | Other | Guidance | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:24Z | 1 | 0 | 0900006482d7ee3c | ||
| FDA-2017-H-6965-0001 | FDA | DAB Civil Money Penalty; Ise Grocery, Inc. d/b/a Samoset Grocery; CLOSED 06/26/2018 FDA-2017-H-6965 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T19:25:13Z | 0 | 0 | 0900006482d7e13f | ||
| FDA-1980-N-0038-0156 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Request for Hearing from Clay-Park Labs, Inc. | Other | Request for Hearing | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T19:23:17Z | 0 | 0 | 09000064805b964a | |||
| FDA-1980-N-0038-0141 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Letter from Miles Laboratories, Inc. to FDA/DDM | Other | Letter(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T18:13:51Z | 0 | 0 | 09000064805b963f | |||
| FDA-1980-N-0038-0153 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Answer Letter from Arthur Hull Hayes, Jr. to American Academy of Dermatology, Inc. | Other | Answer | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T19:21:20Z | 0 | 0 | 09000064805b9647 | |||
| FDA-1980-N-0038-0155 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Letter from Linda M. Quinones to American Academy of Dermatology, Inc. | Other | Letter(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T19:22:12Z | 0 | 0 | 09000064805b9649 | |||
| FDA-1980-N-0038-0148 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from Burroughs Wellcome Co. (Vol. 1 of 5) | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2020-01-31T06:55:40Z | 0 | 0 | 09000064805b9646 | |||
| FDA-1980-N-0038-0133 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from Merck Sharp & Dohme Research Labs (Vol. 1 of 4) | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T18:05:18Z | 0 | 0 | 09000064805b963c | |||
| FDA-1980-N-0038-0142 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Withdrawal Letter from Miles Laboratories, Inc. | Other | Withdrawal | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T18:19:41Z | 0 | 0 | 09000064805b9640 | |||
| FDA-2017-H-6964-0001 | FDA | DAB Civil Money Penalty; Aliciia Inc. d/b/a Westview Sunoco; CLOSED 02/21/2018 FDA-2017-H-6964 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T19:23:34Z | 0 | 0 | 0900006482d7db87 | ||
| FDA-2017-V-6985-0001 | FDA | Laser Light Show FDA-2017-V-6985 | Variance Application from Aka Booking Agency | Other | Application for Variance (VAR) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:15:52Z | 0 | 0 | 0900006482d73063 | ||
| FDA-2017-H-6966-0001 | FDA | DAB Civil Money Penalty; Girard Neighborhood Food Market Inc. d/b/a Girard Neighborhood Food Market; CLOSED 03/22/2018 FDA-2017-H-6966 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T19:32:32Z | 0 | 0 | 0900006482d7e147 | ||
| FDA-1980-N-0038-0147 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from Mayrand, Inc. Pharmaceuticals | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2020-01-31T06:55:39Z | 0 | 0 | 09000064805b9645 | |||
| FDA-1980-N-0038-0145 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from UAD Laboratories, Inc. | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2020-01-31T06:55:40Z | 0 | 0 | 09000064805b9643 | |||
| FDA-1980-N-0038-0119 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from National Pharmaceutical Alliance | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T18:02:14Z | 0 | 0 | 09000064805b962f | |||
| FDA-1980-N-0038-0143 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Correction from the Lemmon Company | Other | Correction(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2018-01-02T20:45:08Z | 0 | 0 | 09000064805b9641 | |||
| FDA-1980-N-0038-0137 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | The Proposal to Withdraw the New Drug Application for Terra-Cortril Topical Ointment (NDA 61-011, Section 446.567(a)) - Submission of Data for Terra-Cortril Topical Ointment re Supplement from Pfizer Inc. | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T18:11:19Z | 0 | 0 | 09000064805b963d | |||
| FDA-1980-N-0038-0144 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from Marnel Pharmaceuticals, Inc. | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2020-01-31T07:27:06Z | 0 | 0 | 09000064805b9642 | |||
| FDA-1980-N-0038-0146 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from Dermik Laboratories, Inc. | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2020-01-31T06:55:40Z | 0 | 0 | 09000064805b9644 | |||
| FDA-1980-N-0038-0154 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Amendment from BYK-Gulden, Inc. (Covington & Burling) | Other | Amendment | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T19:21:07Z | 0 | 0 | 09000064805b9648 | |||
| FDA-2017-V-6985-0002 | FDA | Laser Light Show FDA-2017-V-6985 | Acknowledgement Letter from FDA DDM to AKA Booking Agency | Other | Acknowledgement Letter/Receipt | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:15:57Z | 0 | 0 | 0900006482d73066 | ||
| FDA-2017-H-6951-0001 | FDA | DAB Civil Money Penalty; ARO Investments, LLC d/b/a Sunoco; CLOSED 02/14/2018 FDA-2017-H-6951 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T18:19:30Z | 0 | 0 | 0900006482d7c150 | ||
| FDA-2017-V-4971-0003 | FDA | Laser Light Show FDA-2017-V-4971 | Response Letter from FDA CDRH to Charles Gardner | Other | Agency Response | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T18:12:31Z | 0 | 0 | 0900006482d7c89e | ||
| FDA-1980-N-0038-0157 | FDA | Anti-Infective Drug Products for Dermatologic Use FDA-1980-N-0038 | Supplement from Syntex Laboratories (Kleinfeld, Kaplan and Becker) | Other | Supplement (SUP) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T19:24:45Z | 0 | 0 | 09000064805b964b | |||
| FDA-2014-V-2139-0003 | FDA | Laser Light Show FDA-2014-V-2139 | Approval Letter from FDA DDM to Laserdock Limited | Other | Approval for Variance (VRA) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T18:20:46Z | 0 | 0 | 0900006482d7c8a0 | ||
| FDA-2017-H-6961-0001 | FDA | DAB Civil Money Penalty; Speedway LLC d/b/a Speedway 2879; CLOSED 01/29/2018 FDA-2017-H-6961 | Complaint | Other | Complaint | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T18:33:17Z | 0 | 0 | 0900006482d7c7a2 | ||
| FMCSA-2017-0351-0003 | FMCSA | In the Matter of Rose Transport, Inc. - Petition for Reconsideration of Default FMCSA-2017-0351 | In the Matter of Rose Transport, Inc. - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:31Z | 1 | 0 | 0900006482d7b95a | ||
| FMCSA-2017-0304-0003 | FMCSA | In the Matter of Doug Goossen dba Goossen Farms - Field Administrator’s Consent to Arbitration or Motion for Default FMCSA-2017-0304 | In the Matter of Doug Goossen dba Goossen Farms - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:55Z | 1 | 0 | 0900006482d7bba3 | ||
| FMCSA-2017-0268-0003 | FMCSA | In the Matter of Carlos Reyes Martinez & Jose Florentino Balboa Reyes dba Fruteria El Huerto Del Eden FMCSA-2017-0268 | In the Matter of Carlos Reyes Martinez & Jose Florentino Balboa Reyes dba Fruteria El Huerto Del Eden - Order Dismissing Matter Based on Full Payment | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:40Z | 1 | 0 | 0900006482d7bfce | ||
| FMCSA-2014-0224-0005 | FMCSA | SSC - In the Matter of James W. Copeland - Field Administrator's Objection to Request for Hearing FMCSA-2014-0224 | In the Matter of Five Sisters Horse Farm - Order Dismissing Matter and Closing Docket | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:05Z | 1 | 0 | 0900006482d7c490 | ||
| FMCSA-2016-0427-0005 | FMCSA | In the Matter of Ekorb Enterprises, LLC - Consent to Arbitration FMCSA-2016-0427 | In the Matter of Ekorb Enterprises, LLC - Notification of Settlement | Other | Notification of Settlement | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:27Z | 1 | 0 | 0900006482d7ea3d | ||
| FMCSA-2017-0100-0003 | FMCSA | MSC - In the Matter of Zvjezdan Zivkovic d/b/a Iowa Carriers - Petition for Reconsideration of Default FMCSA-2017-0100 | In the Matter of Zvjezdan Zivkovic dba Iowa Carriers - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:37Z | 1 | 0 | 0900006482d7b9f9 | ||
| FMCSA-2017-0299-0003 | FMCSA | In the Matter of Kehm Oil Company - Consent to Binding Arbitration FMCSA-2017-0299 | In the Matter of Kehm Oil Company - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:40Z | 1 | 0 | 0900006482d7bf2b | ||
| FMCSA-2016-0370-0003 | FMCSA | In the Matter of Sebmar Logistics, Inc. - Petition for Reconsideration of Default FMCSA-2016-0370 | In the Matter of Sebmar Logistics, Inc. - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2017-12-28T15:42:01Z | 0 | 0 | 0900006482d7aee1 | ||
| FMCSA-2014-0001-0004 | FMCSA | ESC - In the Matter of VAR Transport, Inc. - RFA’s Submission of Evidence FMCSA-2014-0001 | In the Matter of VAR Transport, Inc- Opposition to Petition for Reconsideration and Motion to Strike | Other | Objection(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:18Z | 1 | 0 | 0900006482d7d0f8 | ||
| FMCSA-2014-0433-0004 | FMCSA | SSC - In the Matter of M&K Transport, Inc. - Field Administrator’s Submission of Written Evidence and Argument in Support of Notice of Claim FMCSA-2014-0433 | In the Matter of M & K Transport, Inc. - Order Dismissing Proceeding and Closing Docket | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:05Z | 1 | 0 | 0900006482d7c441 | ||
| FMCSA-2016-0337-0005 | FMCSA | WSC - In the Matter of HWY Trucking Inc. - Field Administrator’s Submission of Evidence FMCSA-2016-0337 | In the Matter of HWY Trucking, Inc. - Final Order | Other | Final Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:28Z | 1 | 0 | 0900006482d7ebd9 | ||
| FMCSA-2017-0311-0003 | FMCSA | In the Matter Qulaten Trucking LLC - Petition for Reconsideration of Default FMCSA-2017-0311 | In the Matter of Qulaten Trucking, LLC - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:31Z | 1 | 0 | 0900006482d7ba55 | ||
| FMCSA-2017-0214-0004 | FMCSA | In the Matter of Middlebury Fence Co., LLC - Objection to Request for Hearing and Motion for Final Agency Order FMCSA-2017-0214 | In the Matter of Middlebury Fence Co., LLC - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:25Z | 1 | 0 | 0900006482d7be5d | ||
| FMCSA-2017-0101-0003 | FMCSA | WSC - In the Matter of Laurel Transport - Petition for Reconsideration of Default FMCSA-2017-0101 | In the Matter of Veva's Enterprises Incorporated dba Laurel Transport - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:32Z | 1 | 0 | 0900006482d7ba94 | ||
| FMCSA-2017-0325-0004 | FMCSA | SSC - In the Matter of - G Enterprises, Inc. Field Administrator's Motion for Extension of Time FMCSA-2017-0325 | In the Matter of G Enterprises, Inc. - Order Terminating Proceeding and Closing Docket | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:31Z | 1 | 0 | 0900006482d7bb0f | ||
| FMCSA-2016-0326-0005 | FMCSA | In the Matter of A & S Express Transport LLC - Field Administrator’s Motion for Default and Final Agency Order FMCSA-2016-0326 | In the Matter of A & S Express Transport LLC - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:55Z | 1 | 0 | 0900006482d7bc31 | ||
| FMCSA-2013-0248-0004 | FMCSA | ESC - In the Matter of Coastal Coach, Inc. - Regional Field Administrator's Submission of Evidence FMCSA-2013-0248 | In the Matter of Coastal Coach, Inc. - Final Order on Submission of Evidence - Revised Certificate of Service | Other | Final Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:24Z | 1 | 0 | 0900006482d7e272 | ||
| FMCSA-2016-0399-0005 | FMCSA | In the Matter of Arthur C. Roncher dba Roncher Trucking - Submission of Evidence FMCSA-2016-0399 | In the Matter of Arthur C. Roncher dba Roncher Trucking - Opposition to Petition for Reconsideration | Other | Objection(s) | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:03Z | 1 | 0 | 0900006482d7e279 | ||
| FMCSA-2017-0195-0006 | FMCSA | ESC - In the Matter of Pete Broody dba Pete Broody Tires - Consent to Binding Arbitration FMCSA-2017-0195 | In the Matter of Pete Broody dba Pete Broody Tires - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:55Z | 1 | 0 | 0900006482d7bc9e | ||
| FMCSA-2017-0221-0003 | FMCSA | In the Matter of The Greater New Liberty MB Church dba TGAND Tours - Field Administrator’s Consent to Arbitration FMCSA-2017-0221 | In the Matter of The Greater New Liberty MB Church dba TG and Tours - Order Approving Settlement | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:55Z | 1 | 0 | 0900006482d7be28 | ||
| FMCSA-2016-0205-0005 | FMCSA | In the Matter of Juan M. Sanchotena dba Sanchotena Express - Field Administrator’s Consent to Binding Arbitration FMCSA-2016-0205 | In the Matter of Juan M. Sanchotena dba Sanchotena Express - Order Dismissing Matter Based on Full Payment | Other | Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:15:41Z | 1 | 0 | 0900006482d7c056 | ||
| FMCSA-2016-0387-0003 | FMCSA | In the Matter of Just Call Me, LLC - Submission of Evidence FMCSA-2016-0387 | In the Matter of Just Call Me, LLC - Final Order | Other | Final Order | 2017-12-28T05:00:00Z | 2017 | 12 | 2017-12-28T05:00:00Z | 2024-11-07T01:16:19Z | 1 | 0 | 0900006482d7b10d |
Advanced export
JSON shape: default, array, newline-delimited, object
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);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;