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

10 rows where agency_id = "FSIS", document_type = "Proposed Rule" and posted_year = 2012 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 1

  • 2012 · 10 ✖

document_type 1

  • Proposed Rule · 10 ✖

agency_id 1

  • FSIS · 10 ✖
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
FSIS-2009-0022-0001 FSIS Electronic Import Inspection Applications; Electronic Foreign Imported Product and Establishment Certificates; Requirements for Official Import Inspection Marks and Devices; and Sanitation Standard Operating Procedures(SOPs) Requirements for Official Import Inspection Establishments FSIS-2009-0022 Electronic Import Inspection Application and Certification of Imported Products and Foreign Establishments Proposed Rule   2012-11-27T05:00:00Z 2012 11 2012-11-27T05:00:00Z 2013-01-29T04:59:59Z 2013-04-05T02:05:25Z 2012-28751 0 0 09000064811749e6
FSIS-2012-0019-0001 FSIS Eligibility of the Republic of Korea (Korea) to Export Poultry Products to the United States FSIS-2012-0019 Eligibility of Republic of Korea to Export Poultry Products to United States Proposed Rule   2012-11-27T05:00:00Z 2012 11 2012-11-27T05:00:00Z 2013-01-29T04:59:59Z 2013-01-29T03:01:09Z 2012-28746 0 0 0900006481174a71
FSIS-2009-0019-0001 FSIS HACCP Systems Validation FSIS-2009-0019 Hazard Analysis Critical Control Point Systems Validation Proposed Rule   2012-05-09T04:00:00Z 2012 5 2012-05-09T04:00:00Z 2012-08-10T03:59:59Z 2012-09-20T02:00:49Z 2012-10895 0 0 0900006481008cec
FSIS-2011-0018-0001 FSIS Food Ingredients and Sources of Radiation Listed and Approved for Use in the Production of Meat and Poultry Products FSIS-2011-0018 Food Ingredients and Sources of Radiation: Listed and Approved for Use in Production of Meat and Poultry Products Proposed Rule   2012-05-07T04:00:00Z 2012 5 2012-05-07T04:00:00Z 2012-07-07T03:59:59Z 2012-08-08T02:02:03Z 2012-10871 0 0 0900006481006586
FSIS-2011-0012-0903 FSIS Poultry Slaughter Inspection FSIS-2011-0012 Modernization of Poultry Slaughter Inspection Proposed Rule   2012-04-26T04:00:00Z 2012 4 2012-04-26T04:00:00Z 2012-05-30T03:59:59Z 2012-12-12T03:01:00Z 2012-10111 0 0 0900006480ffd3ce
FSIS-2011-0032-0006 FSIS Additional Changes to the Schedule of Operations Regulations. FSIS-2011-0032 Additional Changes to the Schedule of Operations Regulations Proposed Rule   2012-04-02T04:00:00Z 2012 4 2012-04-02T04:00:00Z 2012-04-19T03:59:59Z 2012-04-05T14:09:07Z 2012-07753 0 0 0900006480fe64a9
FSIS-2011-0032-0001 FSIS Additional Changes to the Schedule of Operations Regulations. FSIS-2011-0032 Additional Changes to the Schedule of Operations Regulations Proposed Rule   2012-03-19T04:00:00Z 2012 3 2012-03-19T04:00:00Z 2012-04-19T03:59:59Z 2012-04-19T12:01:44Z 2012-06372 0 0 0900006480fdad67
FSIS-2012-0016-0001 FSIS National Advisory Committee on Meat and Poultry Inspection FSIS-2012-0016 Modernization of Poultry Slaughter Inspection: Meetings; National Advisory Committee on Meat and Poultry Inspection Proposed Rule   2012-03-07T05:00:00Z 2012 3 2012-03-07T05:00:00Z   2012-03-15T18:17:40Z 2012-05656 0 0 0900006480fd08db
FSIS-2011-0012-0001 FSIS Poultry Slaughter Inspection FSIS-2011-0012 Modernization of Poultry Slaughter Inspection Proposed Rule   2012-01-27T05:00:00Z 2012 1 2012-01-27T05:00:00Z 2012-04-27T03:59:59Z 2019-04-06T01:02:35Z 2012-01516 0 0 0900006480fa7017
FSIS-2009-0026-0001 FSIS Electronic Export Application and Certification Fee; Flexibility in the Requirements for Export Inspection Marks, Devices, and Certificates; Egg Products Export Certification FSIS-2009-0026 Electronic Export Applications and Certification Charges: Flexibility in Requirements for Export Inspection Marks, Devices, and Certificates; Egg Products Proposed Rule   2012-01-23T05:00:00Z 2012 1 2012-01-23T05:00:00Z 2012-03-24T03:59:59Z 2012-01-23T19:01:11Z 2012-01158 0 0 0900006480fa1293

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 897.24ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API