documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
47 rows where docket_id = "FAR-2012-0076" and posted_year = 2013 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_date, posted_month, comment_start_date, comment_end_date, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FAR-2012-0076-0090 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Contractor Use of Interagency Fleet Management System Vehicles; OMB Control No. 9000–0032 | Notice | Notice of Intent | 2013-10-29T04:00:00Z | 2013 | 10 | 2013-10-29T04:00:00Z | 2013-11-30T04:59:59Z | 2013-10-30T20:21:09Z | 2013-25213 | 0 | 0 | 0900006481465258 |
| FAR-2012-0076-0131 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Responsibility Matters; OMB Control No: 9000-0174 | Notice | Notice of Intent | 2013-09-11T04:00:00Z | 2013 | 9 | 2013-09-11T04:00:00Z | 2013-10-12T03:59:59Z | 2014-06-10T21:40:31Z | 2013-22016 | 0 | 0 | 09000064813f313c |
| FAR-2012-0076-0088 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Commercial Item Acquisitions; OMB Control No. 9000–0136 | Notice | Notice of Intent | 2013-08-30T04:00:00Z | 2013 | 8 | 2013-08-30T04:00:00Z | 2013-10-01T03:59:59Z | 2013-09-16T13:05:45Z | 2013-21183 | 0 | 0 | 09000064813d250c |
| FAR-2012-0076-0130 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Report of Shipment; OMB Control No: 9000-0056 | Notice | Notice of Intent | 2013-08-13T04:00:00Z | 2013 | 8 | 2013-08-13T04:00:00Z | 2013-09-13T03:59:59Z | 2014-06-10T21:37:35Z | 2013-19568 | 0 | 0 | 09000064813aef95 |
| FAR-2012-0076-0129 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Limitations on Pass-Through Charges; OMB Control No: 9000-0173 | Notice | Notice of Intent | 2013-07-30T04:00:00Z | 2013 | 7 | 2013-07-30T04:00:00Z | 2013-08-30T03:59:59Z | 2014-05-09T14:43:49Z | 2013-18218 | 0 | 0 | 0900006481384e28 |
| FAR-2012-0076-0128 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Anti-Kickback Procedures; OMB Control No: 9000-0091 | Notice | Notice of Intent | 2013-07-26T04:00:00Z | 2013 | 7 | 2013-07-26T04:00:00Z | 2013-08-27T03:59:59Z | 2014-05-09T14:40:38Z | 2013-17939 | 0 | 0 | 090000648137f95a |
| FAR-2012-0076-0089 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Rights in Data and Copyrights; OMB Control No: 9000-0090 | Notice | Notice of Intent | 2013-07-26T04:00:00Z | 2013 | 7 | 2013-07-26T04:00:00Z | 2013-09-25T03:59:59Z | 2013-09-30T22:11:39Z | 2013-17941 | 0 | 0 | 090000648137f91d |
| FAR-2012-0076-0126 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Bankruptcy; OMB Control No: 9000-0108 | Notice | Notice of Intent | 2013-07-19T04:00:00Z | 2013 | 7 | 2013-07-19T04:00:00Z | 2013-08-20T03:59:59Z | 2014-05-08T21:33:13Z | 2013-17390 | 0 | 0 | 0900006481370449 |
| FAR-2012-0076-0127 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Contract Funding, Limitation of Costs/Funds; OMB Control No: 9000-0074 | Notice | Notice of Intent | 2013-07-19T04:00:00Z | 2013 | 7 | 2013-07-19T04:00:00Z | 2013-08-20T03:59:59Z | 2014-05-09T14:22:16Z | 2013-17389 | 0 | 0 | 0900006481370669 |
| FAR-2012-0076-0125 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Right of First Refusal of Employment; OMB Control No: 9000-0114 | Notice | Notice of Intent | 2013-06-26T04:00:00Z | 2013 | 6 | 2013-06-26T04:00:00Z | 2013-07-27T03:59:59Z | 2014-05-08T21:30:37Z | 2013-15298 | 0 | 0 | 0900006481341695 |
| FAR-2012-0076-0124 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Notification of Ownership Changes; OMB Control No: 9000-0115 | Notice | Notice of Intent | 2013-06-26T04:00:00Z | 2013 | 6 | 2013-06-26T04:00:00Z | 2013-07-27T03:59:59Z | 2014-05-08T21:27:25Z | 2013-15300 | 0 | 0 | 09000064813415c8 |
| FAR-2012-0076-0122 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Commerce Patent Regulations; OMB Control No: 9000-0095 | Notice | Notice of Intent | 2013-05-24T04:00:00Z | 2013 | 5 | 2013-05-24T04:00:00Z | 2013-06-25T03:59:59Z | 2014-05-08T21:21:39Z | 2013-12348 | 0 | 0 | 09000064812f7f6e |
| FAR-2012-0076-0123 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Make-or-Buy Program; OMB Control No: 9000-0078 | Notice | Notice of Intent | 2013-05-24T04:00:00Z | 2013 | 5 | 2013-05-24T04:00:00Z | 2013-06-25T03:59:59Z | 2014-05-08T21:24:36Z | 2013-12353 | 0 | 0 | 09000064812f7ffa |
| FAR-2012-0076-0121 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Travel Costs; OMB Control No: 9000-0088 | Notice | Notice of Intent | 2013-05-24T04:00:00Z | 2013 | 5 | 2013-05-24T04:00:00Z | 2013-06-25T03:59:59Z | 2014-05-08T21:18:44Z | 2013-12345 | 0 | 0 | 09000064812f7ede |
| FAR-2012-0076-0120 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Pollution Prevention and Right-to-Know Information; OMB Control No: 9000-0147 | Notice | Notice of Intent | 2013-05-22T04:00:00Z | 2013 | 5 | 2013-05-22T04:00:00Z | 2013-06-22T03:59:59Z | 2014-05-08T21:15:41Z | 2013-12196 | 0 | 0 | 09000064812f20cc |
| FAR-2012-0076-0119 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Indirect Cost Rates; OMB Control No: 9000-0069 | Notice | Notice of Intent | 2013-05-01T04:00:00Z | 2013 | 5 | 2013-05-01T04:00:00Z | 2013-06-01T03:59:59Z | 2014-05-08T21:06:56Z | 2013-10208 | 0 | 0 | 09000064812af984 |
| FAR-2012-0076-0117 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Bid Guarantees, Performance and Payment Bonds, and Alternative Payment Protections; OMB Control No: 9000-0045 | Notice | Notice of Intent | 2013-05-01T04:00:00Z | 2013 | 5 | 2013-05-01T04:00:00Z | 2013-06-01T03:59:59Z | 2014-05-08T20:59:32Z | 2013-10210 | 0 | 0 | 09000064812af7eb |
| FAR-2012-0076-0118 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Quality Assurance Requirements; OMB Control No: 9000-0077 | Notice | Notice of Intent | 2013-05-01T04:00:00Z | 2013 | 5 | 2013-05-01T04:00:00Z | 2013-06-01T03:59:59Z | 2014-05-08T21:02:03Z | 2013-10205 | 0 | 0 | 09000064812af8f0 |
| FAR-2012-0076-0087 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Contractor Use of Interagency Fleet Management System Vehicles: OMB Control No: 9000-0032 | Notice | Notice of Intent | 2013-04-23T04:00:00Z | 2013 | 4 | 2013-04-23T04:00:00Z | 2013-06-25T03:59:59Z | 2013-06-25T16:01:49Z | 2013-09446 | 0 | 0 | 09000064812a27d4 |
| FAR-2012-0076-0116 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Prompt Payment; OMB Control No: 9000-0102 | Notice | Notice of Intent | 2013-04-02T04:00:00Z | 2013 | 4 | 2013-04-02T04:00:00Z | 2013-05-03T03:59:59Z | 2014-05-08T20:56:59Z | 2013-07589 | 0 | 0 | 0900006481258f13 |
| FAR-2012-0076-0086 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Information Regarding Responsibility Matters | Notice | 2013-03-27T04:00:00Z | 2013 | 3 | 2013-03-27T04:00:00Z | 2013-05-29T03:59:59Z | 2013-05-30T13:58:31Z | 2013-06917 | 0 | 0 | 0900006481247a28 | |
| FAR-2012-0076-0085 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Commercial Item Acquisitions; OMB Control No. 9000-0136 | Notice | Notice of Intent | 2013-03-26T04:00:00Z | 2013 | 3 | 2013-03-26T04:00:00Z | 2013-05-29T03:59:59Z | 2013-05-30T13:42:29Z | 2013-06856 | 0 | 0 | 09000064812454ec |
| FAR-2012-0076-0114 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Taxpayer Identification Number Information; OMB Control No: 9000-0097 | Notice | Notice of Intent | 2013-03-26T04:00:00Z | 2013 | 3 | 2013-03-26T04:00:00Z | 2013-04-26T03:59:59Z | 2014-05-08T20:50:13Z | 2013-06859 | 0 | 0 | 0900006481245465 |
| FAR-2012-0076-0113 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Buy American Act-Free Trade Agreements-Israeli Trade Act Certificate; OMB Control No: 9000-0130 | Notice | Notice of Intent | 2013-03-26T04:00:00Z | 2013 | 3 | 2013-03-26T04:00:00Z | 2013-04-26T03:59:59Z | 2014-05-08T20:46:51Z | 2013-06927 | 0 | 0 | 0900006481245432 |
| FAR-2012-0076-0111 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Change Order Accounting; OMB Control No: 9000-0026 | Notice | Notice of Intent | 2013-03-26T04:00:00Z | 2013 | 3 | 2013-03-26T04:00:00Z | 2013-04-26T03:59:59Z | 2014-05-08T20:39:36Z | 2013-06919 | 0 | 0 | 09000064812451dd |
| FAR-2012-0076-0112 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Use of Data Universal Numbering System as Primary Contractor Identification; OMB Control No: 9000-0145 | Notice | Notice of Intent | 2013-03-26T04:00:00Z | 2013 | 3 | 2013-03-26T04:00:00Z | 2013-04-26T03:59:59Z | 2014-05-08T20:43:11Z | 2013-06921 | 0 | 0 | 09000064812453e4 |
| FAR-2012-0076-0115 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Use of Project Labor Agreements for Federal Construction Projects; OMB Control No: 9000-0175 | Notice | Notice of Intent | 2013-03-26T04:00:00Z | 2013 | 3 | 2013-03-26T04:00:00Z | 2013-04-26T03:59:59Z | 2014-05-08T20:54:14Z | 2013-06924 | 0 | 0 | 09000064812454b2 |
| FAR-2012-0076-0109 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Subcontracting Plans/Individual Subcontract Report; OMB Control No: 9000-0006 | Notice | Notice of Intent | 2013-03-22T04:00:00Z | 2013 | 3 | 2013-03-22T04:00:00Z | 2013-04-23T03:59:59Z | 2014-05-08T17:01:46Z | 2013-06581 | 0 | 0 | 090000648123d38f |
| FAR-2012-0076-0107 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Debarment and Suspension; OMB Control No: 9000-0094 | Notice | Notice of Intent | 2013-03-22T04:00:00Z | 2013 | 3 | 2013-03-22T04:00:00Z | 2013-04-23T03:59:59Z | 2014-05-08T16:49:28Z | 2013-06626 | 0 | 0 | 090000648123d341 |
| FAR-2012-0076-0110 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Contractors' Purchasing Systems Reviews; OMB Control No: 9000-0132 | Notice | Notice of Intent | 2013-03-22T04:00:00Z | 2013 | 3 | 2013-03-22T04:00:00Z | 2013-04-23T03:59:59Z | 2014-05-08T20:36:56Z | 2013-06578 | 0 | 0 | 090000648123d3d9 |
| FAR-2012-0076-0084 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Right of First Refusal of Employment; OMB Control No. 9000-0114 | Notice | Notice of Intent | 2013-03-22T04:00:00Z | 2013 | 3 | 2013-03-22T04:00:00Z | 2013-05-22T03:59:59Z | 2013-05-30T13:36:27Z | 2013-06580 | 0 | 0 | 090000648123d3d8 |
| FAR-2012-0076-0108 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Summary Subcontract Report; OMB Control No: 9000-0007 | Notice | Notice of Intent | 2013-03-22T04:00:00Z | 2013 | 3 | 2013-03-22T04:00:00Z | 2013-04-23T03:59:59Z | 2014-05-08T16:52:36Z | 2013-06584 | 0 | 0 | 090000648123d344 |
| FAR-2012-0076-0106 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulations; Extraordinary Contractual Action Requests; OMB Control No: 9000-0029 | Notice | Notice of Intent | 2013-03-21T04:00:00Z | 2013 | 3 | 2013-03-21T04:00:00Z | 2013-04-23T03:59:59Z | 2014-05-08T16:40:08Z | 2013-06516 | 0 | 0 | 09000064812390b9 |
| FAR-2012-0076-0105 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Service Contracts Reporting Requirements; OMB Control No: 9000-0179 | Notice | Notice of Intent | 2013-03-14T04:00:00Z | 2013 | 3 | 2013-03-14T04:00:00Z | 2013-04-16T03:59:59Z | 2014-05-08T16:34:30Z | 2013-05787 | 0 | 0 | 090000648122a7e3 |
| FAR-2012-0076-0104 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Cost Accounting Standards Administration; OMB Control No: 9000-0129 | Notice | Notice of Intent | 2013-02-28T05:00:00Z | 2013 | 2 | 2013-02-28T05:00:00Z | 2013-04-02T03:59:59Z | 2014-05-08T16:27:58Z | 2013-04488 | 0 | 0 | 090000648120f836 |
| FAR-2012-0076-0103 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Schedules for Construction Contracts; OMB Control No: 9000-0058 | Notice | Notice of Intent | 2013-02-25T05:00:00Z | 2013 | 2 | 2013-02-25T05:00:00Z | 2013-03-28T03:59:59Z | 2014-05-08T16:11:48Z | 2013-04194 | 0 | 0 | 09000064812068ec |
| FAR-2012-0076-0102 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Central Contractor Registration; OMB Control No: 9000-0159 | Notice | Notice of Intent | 2013-02-22T05:00:00Z | 2013 | 2 | 2013-02-22T05:00:00Z | 2013-04-24T03:59:59Z | 2014-05-08T15:53:53Z | 2013-04110 | 0 | 0 | 09000064812035f2 |
| FAR-2012-0076-0101 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Economic Price Adjustment; OMB Control No: 9000-0068 | Notice | Notice of Intent | 2013-02-22T05:00:00Z | 2013 | 2 | 2013-02-22T05:00:00Z | 2013-03-26T03:59:59Z | 2014-05-08T15:47:37Z | 2013-04111 | 0 | 0 | 090000648120349b |
| FAR-2012-0076-0083 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Report of Shipment; OMB Control No. 9000-0056 | Notice | Notice of Intent | 2013-02-20T05:00:00Z | 2013 | 2 | 2013-02-20T05:00:00Z | 2013-04-23T03:59:59Z | 2013-06-25T01:35:12Z | 2013-03871 | 0 | 0 | 09000064811fe465 |
| FAR-2012-0076-0098 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Price Redetermination; OMB Control No: 9000-0071 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:23:58Z | 2013-01476 | 0 | 0 | 09000064811d7c76 |
| FAR-2012-0076-0096 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Permits, Authorities, or Franchises; OMB Control No: 9000-0053 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:15:55Z | 2013-01475 | 0 | 0 | 09000064811d7b24 |
| FAR-2012-0076-0099 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Payments; OMB Control No: 9000-0070 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:37:38Z | 2013-01438 | 0 | 0 | 09000064811d7c79 |
| FAR-2012-0076-0100 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Economic Purchase Quantity-Supplies; OMB Control No: 9000-0082 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:42:22Z | 2013-01451 | 0 | 0 | 09000064811d7cf2 |
| FAR-2012-0076-0082 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Prompt Payment: OMB Control No. 9000-0102 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-03-27T03:59:59Z | 2013-03-26T14:06:52Z | 2013-01565 | 0 | 0 | 09000064811d7bd8 |
| FAR-2012-0076-0095 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Qualification Requirements; OMB Control No: 9000-0083 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:12:03Z | 2013-01557 | 0 | 0 | 09000064811d7a76 |
| FAR-2012-0076-0097 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Advance Payments; OMB Control No: 9000-0073 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:19:04Z | 2013-01465 | 0 | 0 | 09000064811d7bd1 |
| FAR-2012-0076-0094 | FAR | Information Collections FAR-2012-0076 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Federal Acquisition Regulation; Drug-Free Workplace; OMB Control No: 9000-0101 | Notice | Notice of Intent | 2013-01-25T05:00:00Z | 2013 | 1 | 2013-01-25T05:00:00Z | 2013-02-26T04:59:59Z | 2014-05-08T15:09:44Z | 2013-01452 | 0 | 0 | 09000064811d7997 |
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;