home / openregs

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

8 rows where docket_id = "FDA-2018-C-1007" and posted_year = 2022 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: posted_date, posted_month, last_modified, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

document_type 2

  • Supporting & Related Material 6
  • Rule 2

posted_year 1

  • 2022 · 8 ✖

agency_id 1

  • FDA 8
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-2018-C-1007-0014 FDA None FDA-2018-C-1007 Listing of Color Additives; of Color Additives Exempt From Certification; Antarctic Krill Meal; Confirmation of Effective Date Rule Confirmation of Effective Date 2022-09-07T04:00:00Z 2022 9 2022-09-07T04:00:00Z   2022-09-07T13:53:16Z 2022-19277 0 0 09000064852bf710
FDA-2018-C-1007-0013 FDA None FDA-2018-C-1007 Listing of Color Additives Exempt From Certification; Antarctic Krill Meal Rule Final Rule 2022-05-10T04:00:00Z 2022 5 2022-05-10T04:00:00Z 2022-06-10T03:59:59Z 2022-09-07T15:58:49Z 2022-10025 0 0 0900006485066a09
FDA-2018-C-1007-0011 FDA None FDA-2018-C-1007 Reference 5 - Memorandum from T. Thurmond, Toxicology Review Team, Division of Petition Review (DPR), OFAS, CFSAN, FDA to F. Ellison, DPR, OFAS, CFSAN, FDA, February 3, 2009. RE Listing of Color Additives Exempt From Certification; Antarctic Krill Meal Supporting & Related Material Background Material 2022-05-09T04:00:00Z 2022 5     2022-05-12T16:46:03Z   0 0 0900006485063f3c
FDA-2018-C-1007-0009 FDA None FDA-2018-C-1007 Reference 3 - Memorandum from L. Post, Target Animal Review, Division of Animal Feeds, Office of Surveillance and Compliance, Center for Veterinary Medicine, FDA to S. DiFranco, DFI, OFAS, CFSAN, FDA, July 30, 2019. RE Listing of Color Additives Exempt From Certification; Antarctic Krill Meal Supporting & Related Material Background Material 2022-05-09T04:00:00Z 2022 5     2022-05-12T18:13:13Z   0 0 0900006485063f3d
FDA-2018-C-1007-0012 FDA None FDA-2018-C-1007 Reference 6 - Memorandum from M. Pfeil, Environmental Review Team, Division of Science and Technology, OFAS, CFSAN, FDA to S. DiFranco, DFI, OFAS, CFSAN, FDA, March 23, 2020. RE Listing of Color Additives Exempt From Certification; Antarctic Krill Meal Supporting & Related Material Background Material 2022-05-09T04:00:00Z 2022 5     2022-05-12T16:46:08Z   0 0 0900006485063f39
FDA-2018-C-1007-0007 FDA None FDA-2018-C-1007 Reference 1 - Memorandum from E. MirandaBermudez, Color Technology Branch, Division of Color Certification and Technology (DCCT), Office of Cosmetics and Colors (OCAC), Center for Food Safety and Applied Nutrition (CFSAN), FDA to S. DiFranco, Division of Food Ingredients (DFI), Office of Food Additive Safety (OFAS), CFSAN, FDA, March 14, 2020. RE Listing of Color Additives Exempt From Certificatio Supporting & Related Material Background Material 2022-05-09T04:00:00Z 2022 5     2022-05-12T16:46:08Z   0 0 0900006485063f3b
FDA-2018-C-1007-0008 FDA None FDA-2018-C-1007 Reference 2 - Memorandum from D. Doell, Chemistry Review Team, DFI, OFAS, CFSAN, FDA to S. DiFranco, DFI, OFAS, CFSAN, FDA, March 11, 2020. RE Listing of Color Additives Exempt From Certification; Antarctic Krill Meal Supporting & Related Material Background Material 2022-05-09T04:00:00Z 2022 5     2022-05-12T18:13:08Z   0 0 0900006485063f37
FDA-2018-C-1007-0010 FDA None FDA-2018-C-1007 Reference 4 - Memorandum from T. Thurmond, Toxicology Review Team, DFI, OFAS, CFSAN, FDA to S. DiFranco, DFI, OFAS, CFSAN, FDA, March 14, 2020. RE Listing of Color Additives Exempt From Certification; Antarctic Krill Meal Supporting & Related Material Background Material 2022-05-09T04:00:00Z 2022 5     2022-05-12T16:46:08Z   0 0 0900006485063f38

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);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;
Powered by Datasette · Queries took 1567.129ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API