openregs: documents: 8 rows where agency_id = "FSIS", document_type = "Rule" and posted_year = 2006 sorted by posted

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 agency_id = "FSIS", document_type = "Rule" and posted_year = 2006 sorted by posted_date descending

descending

id	agency_id	docket_id	title	document_type	posted_date ▲	posted_year	posted_month	comment_start_date	comment_end_date	last_modified	fr_doc_num	object_id
FSIS-2006-0026-0001	FSIS	Notification of requirements for facilities and conditions for inspection; space for satellite dishes FSIS-2006-0026	Facilities for Inspection	Rule	2006-10-06T04:00:00Z	2006	10	2006-10-06T04:00:00Z		2006-10-06T11:47:18Z	E6-16610	09000064801d2731
FSIS-2005-0026-0001	FSIS	Frequency of Foreign Inspection System Supervision Visits to Certified Establishments FSIS-2005-0026	Frequency of Foreign Inspection System Supervisory Visits to Certified Foreign Establishments	Rule	2006-08-03T04:00:00Z	2006	8	2006-08-03T04:00:00Z		2011-06-11T17:26:18Z	E6-12565	09000064801adc85
FSIS-2005-0035-0001	FSIS	Reassessment of HACCP Plans to Address the Use & Labeling of Ingredients of Potential Public Health Concern FSIS-2005-0035	The Use of Ingredients of Potential Public Health Concern	Rule	2006-05-08T04:00:00Z	2006	5	2006-05-08T04:00:00Z	2006-07-08T03:59:59Z	2006-09-02T18:01:17Z	E6-06743	090000648016da7a
FSIS-2005-0034-0050	FSIS	Addition of The People’s Republic of China to the List of Countries Eligible to Export Poultry and Poultry Products to the to the United States FSIS-2005-0034	Addition of the Peoples Republic of China to the List of Countries Eligible To Export Processed Poultry Products to the United States	Rule	2006-04-24T04:00:00Z	2006	4	2006-04-24T04:00:00Z		2011-06-11T17:26:19Z	06-03889	0900006480163bef
FSIS-2005-0040-0315	FSIS	Ante-mortem Inspection of Horses FSIS-2005-0040	Ante-Mortem Inspection of Horses; Correction	Rule	2006-03-14T05:00:00Z	2006	3	2006-03-14T05:00:00Z		2011-06-11T17:26:20Z	06-02418	0900006480145216
FSIS-2005-0040-0001	FSIS	Ante-mortem Inspection of Horses FSIS-2005-0040	Ante-Mortem Inspection of Horses	Rule	2006-02-08T05:00:00Z	2006	2	2006-02-08T05:00:00Z	2006-03-11T04:59:59Z	2011-06-11T17:26:20Z	06-01101	090000648012b0a7
FSIS-2005-0025-0001	FSIS	Increases in Fees for Meat, Poultry and Egg Products Inspection Services—FY 2006 – 2008 FSIS-2005-0025	Changes in Fees for Meat, Poultry, and Egg Products Inspection Services--Fiscal Years 2006-2008	Rule	2006-01-13T05:00:00Z	2006	1	2006-01-13T05:00:00Z		2011-06-11T17:26:17Z	06-00321	0900006480110cb5
FSIS-2005-0038-0001	FSIS	Food Labeling; Nutrient Content Claims, Definition of the Term "Healthy" FSIS-2005-0038	Food Labeling; Nutrient Content Claims, Definition of the Term: ``Healthy	Rule	2006-01-11T05:00:00Z	2006	1	2006-01-11T05:00:00Z	2006-02-11T04:59:59Z	2011-06-11T17:26:19Z	06-00268	090000648010de2c

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;