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

45 rows where agency_id = "CMS", document_type = "Rule" and posted_year = 2012 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 1

  • 2012 · 45 ✖

document_type 1

  • Rule · 45 ✖

agency_id 1

  • CMS · 45 ✖
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
CMS-2012-0061-0150 CMS Medicaid Program; Payments for Services Furnished by Certain Primary Care Physicians and Charges for Vaccine Administration Under the Vaccines for Children Program (CMS-2370-P) CMS-2012-0061 Medicaid Program: Payments for Services Furnished by Certain Primary Care Physicians and Charges for Vaccine Administration under the Vaccines for Children Program; Correction Rule   2012-12-14T05:00:00Z 2012 12 2012-12-14T05:00:00Z   2012-12-14T14:48:36Z 2012-29640 0 0 090000648118c4cb
CMS-2013-0007-0001 CMS Health Information Technology: Revisions to the 2014 Edition Electronic Health Record Certification Criteria; and Medicare and Medicaid Programs; Revisions to the Electronic Health Record Incentive Program (CMS-0046-IFC) CMS-2013-0007 Health Information Technology; and Medicare and Medicaid Programs: Electronic Health Record Certification Criteria; Electronic Health Record Incentive Program Rule   2012-12-07T05:00:00Z 2012 12 2012-12-07T05:00:00Z 2013-02-06T04:59:59Z 2013-01-23T03:11:15Z 2012-29607 0 0 0900006481182568
CMS-2012-0083-3524 CMS Medicare Program; Revisions to Payment Policies Under the Physician Fee Schedule, DME Face-to-Face Encounters, Elimination of the Requirement for Termination of Non-Random Prepayment Complex Medical Review and Other Revisions to Part B for CY 2013 (CMS-1590-P) CMS-2012-0083 Medicare Program: Revisions to Payment Policies Under the Physician Fee Schedule, DME Face to Face Encounters, Elimination of the Requirement for Termination of Non-Random Prepayment Complex Medical Review and Other Revisions to Part B for CY 2013 Rule   2012-11-16T05:00:00Z 2012 11 2012-11-16T05:00:00Z 2013-01-01T04:59:59Z 2013-01-19T03:06:05Z 2012-26900 0 0 0900006481169eb0
CMS-2012-0084-0625 CMS Hospital Outpatient Prospective and Ambulatory Surgical Center Payment Systems and Quality Reporting Programs; Electronic Reporting Pilot; Inpatient Rehabilitation Facilities Quality Reporting Program; Quality Improvement Organization Regulations CMS-2012-0084 Medicare and Medicaid Programs: Hospital Outpatient Prospective Payment and Ambulatory Surgical Center Payment Systems and Quality Reporting Programs; Electronic Reporting Pilot; etc. Rule   2012-11-15T05:00:00Z 2012 11 2012-11-15T05:00:00Z 2013-01-01T04:59:59Z 2013-01-01T03:01:25Z 2012-26902 0 0 09000064811684c9
CMS-2012-0080-0063 CMS Medicare Program; End-Stage Renal Disease Prospective Payment System, Quality Incentive Program, and Bad Debt Reductions for all Medicare Providers CMS-2012-0080 Medicare Program: End-Stage Renal Disease Prospective Payment System, Quality Incentive Program, and Bad Debt Reductions for all Medicare Providers Rule   2012-11-09T05:00:00Z 2012 11 2012-11-09T05:00:00Z   2013-02-12T19:06:44Z 2012-26903 0 0 09000064811641b2
CMS-2012-0082-0139 CMS Medicare Program; Home Health Prospective Payment System Rate Update for Calendar Year 2013, Hospice Quality Reporting Requirements, and Survey and Enforcement Requirements for Home Health Agencies (CMS-1358-P) CMS-2012-0082 Medicare Program: Home Health Prospective Payment System Rate Update for Calendar Year 2013, Hospice Quality Reporting Requirements, and Survey and Enforcement Requirements for Home Health Agencies Rule   2012-11-08T05:00:00Z 2012 11 2012-11-08T05:00:00Z   2016-01-19T19:57:06Z 2012-26904 0 0 0900006481162a13
CMS-2012-0061-0151 CMS Medicaid Program; Payments for Services Furnished by Certain Primary Care Physicians and Charges for Vaccine Administration Under the Vaccines for Children Program (CMS-2370-P) CMS-2012-0061 Medicaid Program: Payments for Services Furnished by Certain Primary Care Physicians and Charges for Vaccine Administration under the Vaccines for Children Program Rule   2012-11-06T05:00:00Z 2012 11 2012-11-06T05:00:00Z   2016-01-19T20:00:04Z 2012-26507 0 0 090000648115f379
CMS-2012-0083-3456 CMS Medicare Program; Revisions to Payment Policies Under the Physician Fee Schedule, DME Face-to-Face Encounters, Elimination of the Requirement for Termination of Non-Random Prepayment Complex Medical Review and Other Revisions to Part B for CY 2013 (CMS-1590-P) CMS-2012-0083 Medicare Program; Revisions to Payment Policies Under the Physician Fee Schedule, DME (CMS-1590-FC) Rule Final Rule with Request for Comments 2012-11-02T04:00:00Z 2012 11 2012-11-02T04:00:00Z 2012-11-16T04:59:59Z 2013-01-10T03:01:27Z   0 0 090000648115a0fd
CMS-2012-0061-0149 CMS Medicaid Program; Payments for Services Furnished by Certain Primary Care Physicians and Charges for Vaccine Administration Under the Vaccines for Children Program (CMS-2370-P) CMS-2012-0061 Medicaid Program; Payments for Services Furnished by Certain Primary Care Physicians and Charges for Vaccine Administration under the Vaccines for Children Program (CMS-2370-F) Rule Final Rule 2012-11-02T04:00:00Z 2012 11 2012-11-02T04:00:00Z   2012-11-02T16:14:38Z   0 0 090000648115aa33
CMS-2012-0084-0624 CMS Hospital Outpatient Prospective and Ambulatory Surgical Center Payment Systems and Quality Reporting Programs; Electronic Reporting Pilot; Inpatient Rehabilitation Facilities Quality Reporting Program; Quality Improvement Organization Regulations CMS-2012-0084 Proposed Changes to Hospital Outpatient Prospective Payment System and CY 2013 Payment Rates; Ambulatory Surgical Center Payment System and CY 2013 Payment Rates CMS-1589-FC Rule Final Rule with Request for Comments 2012-11-01T04:00:00Z 2012 11 2012-11-01T04:00:00Z 2012-11-16T04:59:59Z 2013-01-15T03:02:32Z   0 0 09000064811599ed
CMS-2012-0052-0418 CMS Medicare Program; Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long-Term Care Hospital Prospective Payment System and Fiscal Year 2013 Rates; Hospitals’ Resident Caps for Graduate Medical Education Payment Purposes; Quality Reporting Requirements for Specific Providers and for Ambulatory Surgical Centers CMS-2012-0052 Medicare Program: Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long Term Care Hospital Prospective Payment System and Fiscal Year 2013 Rates; Hospitals' ResidentCaps for Graduate Medical Education Payment Purposes, etc.; Corrections Rule   2012-10-29T04:00:00Z 2012 10 2012-10-29T04:00:00Z   2012-10-31T13:44:11Z 2012-26505 0 0 09000064811543a1
CMS-2012-0022-1129 CMS Electronic Health Record Incentive Program – Stage 2 "Meaningful Use" CMS-2012-0022 Medicare and Medicaid Programs: Electronic Health Record Incentive Program - Stage 2; Corrections Rule   2012-10-23T04:00:00Z 2012 10 2012-10-23T04:00:00Z   2012-10-31T13:49:14Z 2012-25975 0 0 090000648114c523
CMS-2012-0052-0417 CMS Medicare Program; Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long-Term Care Hospital Prospective Payment System and Fiscal Year 2013 Rates; Hospitals’ Resident Caps for Graduate Medical Education Payment Purposes; Quality Reporting Requirements for Specific Providers and for Ambulatory Surgical Centers CMS-2012-0052 Medicare Program: Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long Term Care Hospital Prospective Payment System and Fiscal Year 2013 Rates; Hospitals' Resident Caps for Graduate Medical Education Payment Purposes; etc. Rule   2012-10-17T04:00:00Z 2012 10 2012-10-17T04:00:00Z   2012-10-31T13:40:44Z 2012-25464 0 0 0900006481144d3f
CMS-2012-0043-0202 CMS Administrative Simplification: Adoption of a Standard for a Unique Health Plan Identifier, Addition to the National Provider Identifier Requirements and ICD-10 Compliance Date Delay CMS-2012-0043 Administrative Simplification: Adoption of a Standard for a Unique Health Plan Identifier; Addition to the National Provider Identifier Requirements; and a Change to the Compliance Date for the International Classification of Diseases, 10th Edition Medical Data Code Sets; Corrections Rule   2012-10-04T04:00:00Z 2012 10 2012-10-04T04:00:00Z   2012-10-05T13:16:25Z 2012-24329 0 0 090000648113401d
CMS-2013-0043-0004 CMS Medicare Program; Extension of the Payment Adjustment for Low-volume Hospitals and the Medicare-dependent Hospital (MDH) Program Under the Hospital Inpatient Prospective Payment Systems (IPPS) for Acute Care Hospitals for Fiscal Year 2013 (CMS-1588-N) CMS-2013-0043 Medicare Programs: Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and Long Term Care Hospital Prospective Payment System, etc. Rule   2012-10-03T04:00:00Z 2012 10 2012-10-03T04:00:00Z   2016-01-19T19:58:59Z 2012-24307 0 0 0900006481132835
CMS-2012-0043-0201 CMS Administrative Simplification: Adoption of a Standard for a Unique Health Plan Identifier, Addition to the National Provider Identifier Requirements and ICD-10 Compliance Date Delay CMS-2012-0043 Administrative Simplification: Adoption of Standard for Unique Health Plan Identifier; Addition to National Provider Identifier Requirements, etc. Rule   2012-09-05T04:00:00Z 2012 9 2012-09-05T04:00:00Z   2012-09-05T19:38:37Z 2012-21238 0 0 0900006481105d29
CMS-2012-0022-1128 CMS Electronic Health Record Incentive Program – Stage 2 "Meaningful Use" CMS-2012-0022 Medicare and Medicaid Programs: Electronic Health Record Incentive Program-Stage 2 Rule   2012-09-04T04:00:00Z 2012 9 2012-09-04T04:00:00Z   2012-09-04T17:49:47Z 2012-21050 0 0 09000064811006af
CMS-2012-0052-0416 CMS Medicare Program; Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long-Term Care Hospital Prospective Payment System and Fiscal Year 2013 Rates; Hospitals’ Resident Caps for Graduate Medical Education Payment Purposes; Quality Reporting Requirements for Specific Providers and for Ambulatory Surgical Centers CMS-2012-0052 Medicare Program: Hospital Inpatient Prospective Payment Systems, etc. Rule   2012-08-31T04:00:00Z 2012 8 2012-08-31T04:00:00Z   2012-08-31T14:57:17Z 2012-19079 0 0 09000064810fd59c
CMS-2012-0138-0001 CMS Pre-Existing Condition Insurance Plan Program (CMS-9995-IFC2) CMS-2012-0138 Pre-Existing Condition Insurance Plan Program Rule   2012-08-30T04:00:00Z 2012 8 2012-08-30T04:00:00Z 2012-10-30T03:59:59Z 2012-11-30T03:01:42Z 2012-21519 0 0 09000064810fb0e0
CMS-2012-0100-0002 CMS Adoption of Operating Rules for Electronic Funds Transfer (EFT) and Remittance Advice CMS-2012-0100 Administrative Simplification: Health Care Electronic Funds Transfers and Remittance Advice Transactions Rule   2012-08-10T04:00:00Z 2012 8 2012-08-10T04:00:00Z 2012-10-10T03:59:59Z 2012-10-11T02:01:10Z 2012-19557 0 0 09000064810cd454
CMS-2012-0071-0082 CMS Patient Protection and Affordable Care Act; Data Collection to Support Standards Related to Essential Health Benefits; Recognition of Entities for the Accreditation of Qualified Health Plans CMS-2012-0071 Patient Protection and Affordable Care Act: Data Collection to Define Essential Health Benefits; Recognition of Entities for Accreditation of Qualified Health Plans Rule   2012-07-20T04:00:00Z 2012 7 2012-07-20T04:00:00Z   2012-08-02T15:32:35Z 2012-17831 0 0 09000064810a6fd7
CMS-2011-0157-0517 CMS Medicare Program; Proposed Changes to the Medicare Advantage and the Medicare Prescription Drug Benefit Programs for Contract Year 2013 and Other Proposed Changes; Considering Changes to the Conditions of Participation for Long Term Care Facilities CMS-2011-0157 Medicare Program: Changes to Medicare Advantage and Medicare Prescription Drug Benefit Programs for Contract Year 2013 and Other Changes; Corrections Rule   2012-06-01T04:00:00Z 2012 6 2012-06-01T04:00:00Z   2012-06-05T12:40:11Z 2012-13362 0 0 0900006481024d84
CMS-2011-0118-0006 CMS Medicaid and Children's Health Insurance Program; Disallowance of Claims for FFP and Technical Corrections (CMS-2292-P) CMS-2011-0118 Medicaid and Childrens Health Insurance Programs: Disallowance of Claims for FFP and Technical Corrections Rule   2012-05-29T04:00:00Z 2012 5 2012-05-29T04:00:00Z   2012-05-30T14:04:33Z 2012-12637 0 0 090000648101f869
CMS-2011-0179-0051 CMS Medical Loss Ratio Requirements CMS-2011-0179 Medical Loss Ratio Requirements under Patient Protection and Affordable Care Act Rule   2012-05-16T04:00:00Z 2012 5 2012-05-16T04:00:00Z   2016-01-19T20:01:05Z 2012-11753 0 0 0900006481010707
CMS-2011-0161-0095 CMS Regulatory Provisions to Promote Program Efficiency, Transparency, and Burden Reduction CMS-2011-0161 Medicare and Medicaid Programs: Regulatory Provisions to Promote Program Efficiency, Transparency, and Burden Reduction Rule   2012-05-16T04:00:00Z 2012 5 2012-05-16T04:00:00Z   2016-01-19T20:00:47Z 2012-11543 0 0 09000064810106b8
CMS-2011-0160-0463 CMS Reform of Hospital and Critical Access Hospitals Conditions of Participation CMS-2011-0160 Medicare and Medicaid Programs: Reform of Hospital and Critical Access Hospital Conditions of Participation Rule   2012-05-16T04:00:00Z 2012 5 2012-05-16T04:00:00Z   2012-05-25T13:01:51Z 2012-11548 0 0 090000648101069b
CMS-2011-0019-0144 CMS Medicaid Program; Community First Choice Option CMS-2011-0019 Medicaid Program; Community First Choice Option Rule   2012-05-07T04:00:00Z 2012 5 2012-05-10T04:00:00Z   2012-05-10T19:13:24Z 2012-10294 0 0 090000648100a0a2
CMS-2011-0139-0516 CMS Medicaid Program; Eligibility Changes under the Affordable Care Act of 2010 (CMS-2349-P) CMS-2011-0139 Medicaid Program; Community First Choice Option Rule   2012-05-07T00:00:00Z 2012 5     2012-05-10T19:10:46Z   0 1 090000648100625a
CMS-2010-0187-0029 CMS Medicare and Medicaid Programs; Changes in Provider and Supplier Enrollment, Ordering and Referring, and Documentation Requirements; and Changes in Provider Agreements CMS-2010-0187 Medicare and Medicaid Programs: Changes in Provider and Supplier Enrollment, Ordering and Referring, and Documentation Requirements; and Changes in Provider Agreements Rule   2012-04-27T04:00:00Z 2012 4 2012-04-27T04:00:00Z   2012-04-30T17:36:10Z 2012-09994 0 0 0900006480ffeb4e
CMS-2011-0019-0143 CMS Medicaid Program; Community First Choice Option CMS-2011-0019 Medicaid Program; Community First Choice Option Rule Final Rule 2012-04-27T04:00:00Z 2012 4 2012-04-27T04:00:00Z   2012-04-27T13:43:46Z   0 0 0900006480ffeca9
CMS-2011-0130-0539 CMS Hospital Outpatient Prospective Payment; Ambulatory Surgical Center Payment; Hospital Value-Based Purchasing Program; Physician Self-Referral; and Provider Agreement Regulations on Patient Notification Requirements CMS-2011-0130 Medicare and Medicaid Programs: Hospital Outpatient Prospective Payment; Ambulatory Surgical Center Payment; Hospital Value-Based Purchasing Program, etc.; Correction Rule   2012-04-24T04:00:00Z 2012 4 2012-04-24T04:00:00Z   2012-04-24T14:53:59Z 2012-09837 0 0 0900006480ff7394
CMS-2011-0157-0516 CMS Medicare Program; Proposed Changes to the Medicare Advantage and the Medicare Prescription Drug Benefit Programs for Contract Year 2013 and Other Proposed Changes; Considering Changes to the Conditions of Participation for Long Term Care Facilities CMS-2011-0157 Changes to the Medicare Advantage and the Medicare Prescription Drug Benefit Programs for Contract Year 2013 and Other Changes Rule   2012-04-12T04:00:00Z 2012 4 2012-04-12T04:00:00Z 2012-06-12T03:59:59Z 2012-06-16T02:02:05Z 2012-08071 0 0 0900006480fee2d1
CMS-2016-0004-0004 CMS CFR Corrections CMS-2016-0004 Acquisition, Protection, and Disclosure of Quality Improvement Organization Information; CFR Correction Rule   2012-04-04T04:00:00Z 2012 4 2012-04-04T04:00:00Z   2016-01-19T20:01:15Z 2012-08184 0 0 0900006480fe86c7
CMS-2011-0139-0489 CMS Medicaid Program; Eligibility Changes under the Affordable Care Act of 2010 (CMS-2349-P) CMS-2011-0139 Eligibility Changes under Affordable Care Act Rule   2012-03-23T04:00:00Z 2012 3 2012-03-23T04:00:00Z 2012-05-08T03:59:59Z 2012-05-17T02:00:19Z 2012-06560 0 0 0900006480fdf391
CMS-2011-0016-0108 CMS Student Health Insurance Coverage CMS-2011-0016 Student Health Insurance Coverage Rule   2012-03-21T04:00:00Z 2012 3 2012-03-21T04:00:00Z   2012-03-21T18:32:45Z 2012-06359 0 0 0900006480fdc8f3
CMS-2011-0045-0016 CMS Medicare Program; Revisions to the Durable Medical Equipment, Prosthetics, Orthotics, and Supplies (DMEPOS) Suppliers Safeguards CMS-2011-0045 Medicare Program: Revisions to Durable Medical Equipment, Prosthetics, Orthotics, and Supplies Supplier Safeguards Rule   2012-03-14T04:00:00Z 2012 3 2012-03-14T04:00:00Z   2012-03-20T14:00:23Z 2012-05913 0 0 0900006480fd6e70
CMS-2010-0241-0040 CMS Application, Review, and Reporting Process for Waivers for State Innovation CMS-2010-0241 Medicaid Program; Review and Approval Process for Section 1115 Demonstrations Rule   2012-02-27T05:00:00Z 2012 2 2012-02-27T05:00:00Z   2012-03-05T16:07:50Z 2012-04354 0 0 0900006480fc30bf
CMS-2010-0241-0038 CMS Application, Review, and Reporting Process for Waivers for State Innovation CMS-2010-0241 Application, Review, and Reporting Process for Waivers for State Innovation Rule   2012-02-27T05:00:00Z 2012 2 2012-02-27T05:00:00Z   2012-02-27T14:47:41Z 2012-04395 0 0 0900006480fc30c4
CMS-2010-0241-0039 CMS Application, Review, and Reporting Process for Waivers for State Innovation CMS-2010-0241 Medicaid Program; Review and Approval Process for Section 1115 Demonstrations (CMS-2325-F) Rule Final Rule 2012-02-27T05:00:00Z 2012 2 2012-02-27T05:00:00Z   2012-02-27T14:52:34Z   0 0 0900006480fbda9b
CMS-2011-0023-0030 CMS Application, Review, and Reporting Process for Waivers for State Innovation CMS-2011-0023 Application, Review, and Reporting Process for Waivers for State Innovation Rule Final Rule 2012-02-23T05:00:00Z 2012 2 2012-02-23T05:00:00Z   2012-02-23T14:05:30Z   0 0 0900006480fbea4e
CMS-2011-0053-0302 CMS FY 2012 Changes to the Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long Term Care Hospital Prospective Payment System and FY 2012 Rates CMS-2011-0053 Medicare Program: Hospital Inpatient Prospective Payment Systems for Acute Care Hospitals and the Long Term Care Hospital Prospective Payment System and Fiscal Year 2012 Rates; Corrections Rule   2012-02-01T05:00:00Z 2012 2 2012-02-01T05:00:00Z   2012-02-02T14:37:31Z 2012-02220 0 0 0900006480fab109
CMS-2008-0056-0141 CMS Medicare Program; Revisions to the Medicare Advantage and Prescription Drug Benefit Programs CMS-2008-0056 Medicare Advantage and Prescription Drug Benefit Programs: Negotiated Pricing and Remaining Revisions; Payments to Sponsors of Retiree Prescription Drug Plans Rule   2012-01-12T05:00:00Z 2012 1 2012-01-12T05:00:00Z   2014-08-15T01:05:29Z 2012-00473 0 0 0900006480f93e77
CMS-2012-0002-0001 CMS Administrative Simplification: Adoption of Standards for Health Care Electronic Funds Transfers (EFTs) and Remittance Advice CMS-2012-0002 Administrative Simplification: Adoption of Standards for Health Care Electronic Funds Transfers and Remittance Advice Rule   2012-01-10T05:00:00Z 2012 1 2012-01-10T05:00:00Z 2012-03-13T03:59:59Z 2012-02-08T20:56:17Z 2012-00132 0 0 0900006480fb06de
CMS-2011-0130-0538 CMS Hospital Outpatient Prospective Payment; Ambulatory Surgical Center Payment; Hospital Value-Based Purchasing Program; Physician Self-Referral; and Provider Agreement Regulations on Patient Notification Requirements CMS-2011-0130 Medicare and Medicaid Programs: Hospital Outpatient Prospective Payment; Ambulatory Surgical Center Payment; etc., Corrections Rule   2012-01-04T05:00:00Z 2012 1 2012-01-04T05:00:00Z   2012-01-04T15:11:25Z 2011-33751 0 0 0900006480f8d78a
CMS-2011-0131-1046 CMS Medicare Program; Payment Policies Under the Physician Fee Schedule and Other Revisions to Part B for CY 2012 CMS-2011-0131 Medicare Program: Payment Policies under the Physician Fee Schedule, Five Year Review of Work Relative Value Units, etc.; Corrections Rule   2012-01-04T05:00:00Z 2012 1 2012-01-04T05:00:00Z   2012-01-04T14:40:26Z 2011-33757 0 0 0900006480f8d7c8

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