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

5 rows where agency_id = "OSHA", document_type = "Rule" and posted_year = 2007 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 1

  • 2007 · 5 ✖

document_type 1

  • Rule · 5 ✖

agency_id 1

  • OSHA · 5 ✖
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
OSHA-2007-0040-0003 OSHA Updating OSHA Standards Based on National Consensus Standards OSHA-2007-0040 Updating OSHA Standards Based on National Consensus Standards; Direct Final Rule Rule Direct Final 2007-12-14T05:00:00Z 2007 12 2007-12-14T05:00:00Z 2008-01-15T04:59:59Z 2011-06-11T14:19:32Z E7-24181 0 0 0900006480379dd1
OSHA-S042-2006-0667-0469 OSHA COST OF PERSONAL PROTECTIVE EQUIPMENT OSHA-S042-2006-0667 Employer Payment for Personal Protective Equipment Rule Final Rule 2007-11-15T05:00:00Z 2007 11 2007-11-15T05:00:00Z   2011-06-11T14:57:17Z 07-05608 0 0 0900006480364756
OSHA-2007-0028-0001 OSHA Procedures for the Handling of Retaliation Complaints under the Employee Protection Provisions of Six Federal Environmental Statutes and Section 211 of the Energy Reorganization Act of 1974, as amended OSHA-2007-0028 Procedures for the Handling of Retaliation Complaints Under the Employee Protection Provisions of Six Federal Environmental Statutes and Section 211 of the Energy Reorganization Act of 1974, as Amended. Action: Interim final rule; request for comments. Rule Correction 2007-08-10T04:00:00Z 2007 8 2007-08-10T04:00:00Z 2007-10-10T03:59:59Z 2014-04-08T20:20:43Z E7-15539 0 0 09000064802746cd
OSHA-S108C-2006-0688-0133 OSHA ELECTRICAL STDS OSHA-S108C-2006-0688 Electrical Standard; Approval of Information Collection Requirements Rule Final Rule 2007-07-23T04:00:00Z 2007 7 2007-07-23T04:00:00Z   2011-06-11T14:57:27Z E7-14113 0 0 090000648026c936
OSHA-2007-0015-0001 OSHA Electrical Standard; Final Rule OSHA-2007-0015 Electrical Standard Rule Final Rule 2007-02-16T05:00:00Z 2007 2 2007-02-16T05:00:00Z   2013-01-23T18:11:43Z E7-01360 0 0 0900006480206072

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