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

72 rows where agency_id = "EEOC" and document_type = "Other" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

posted_year 14

  • 2015 27
  • 2016 17
  • 2012 4
  • 2017 4
  • 2008 3
  • 2009 3
  • 2010 3
  • 2013 3
  • 2007 2
  • 2014 2
  • 2011 1
  • 2020 1
  • 2022 1
  • 2023 1

document_type 1

  • Other · 72 ✖

agency_id 1

  • EEOC · 72 ✖
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
EEOC-2023-0005-0001 EEOC Proposed Enforcement Guidance on Harassment in the Workplace EEOC-2023-0005 Proposed Enforcement Guidance on Harassment in the Workplace Other   2023-09-29T04:00:00Z 2023 9 2023-09-29T04:00:00Z 2023-11-02T03:59:59Z 2024-02-17T02:01:06Z   0 0 090000648600297c
EEOC-2022-0004-0001 EEOC Draft EEOC Strategic Plan 2022-2026 EEOC-2022-0004 FY 2022-2026 Draft Strategic Plan for Public Comment 11.3.2022.draft Other   2022-11-04T04:00:00Z 2022 11 2022-11-04T04:00:00Z 2022-12-06T04:59:59Z 2022-12-06T02:01:09Z   0 0 0900006485484eea
EEOC-2020-0007-0001 EEOC Proposed Updated Compliance Manual on Religious Discrimination EEOC-2020-0007 Proposed Updated Compliance Manual on Religious Discrimination 11-17-20 Other   2020-11-17T05:00:00Z 2020 11 2020-11-17T05:00:00Z 2020-12-18T04:59:59Z 2020-12-19T02:04:05Z   0 0 0900006484964c8d
EEOC-2017-0005-0001 EEOC Draft U.S. Equal Employment Opportunity Commission (EEOC) Strategic Plan for Fiscal Years 2018-2022 for Public Input EEOC-2017-0005 Draft EEOC Strategic Plan 2018-2022 12072017 Other   2017-12-08T05:00:00Z 2017 12 2017-12-08T05:00:00Z 2018-01-09T04:59:59Z 2018-01-09T14:00:31Z   0 0 0900006482cf2435
EEOC-2017-0003-0001 EEOC Selected Topics in Age Discrimination Under the Age Discrimination in Employment Act of 1967 (ADEA)- Draft for Public Input EEOC-2017-0003 EEOC-Proposed-ADEA-Guidance Other   2017-10-10T00:00:00Z 2017 10     2017-10-10T19:41:41Z   0 1 0900006482bb428e
EEOC-2016-0009-0024 EEOC Proposed Enforcement Guidance on Unlawful Harassment EEOC-2016-0009 J Ho - Harassment EG comment - redacted Other   2017-01-19T00:00:00Z 2017 1     2017-01-24T18:30:16Z   0 1 09000064824824bd
EEOC-2016-0009-0001 EEOC Proposed Enforcement Guidance on Unlawful Harassment EEOC-2016-0009 EEOC Proposed EG on Unlawful Harassment for Public Input Other   2017-01-10T05:00:00Z 2017 1 2017-01-10T05:00:00Z 2017-03-22T03:59:59Z 2017-03-23T01:00:20Z   0 0 0900006482458186
EEOC-2016-0004-0007 EEOC Proposed Enforcement Guidance on National Origin Discrimination EEOC-2016-0004 Proposed Enforcement Guidance on National Origin Discrimination; Extension of Comment Period Other   2016-06-29T04:00:00Z 2016 6 2016-06-29T04:00:00Z   2016-06-29T21:53:32Z   0 0 090000648207b0c0
EEOC-2016-0002-0330 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Elizabeth Hirsh Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:41Z   0 0 0900006481f7abb0
EEOC-2016-0002-0334 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Hilary O_ Shelton Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:12Z   0 0 0900006481f7abb4
EEOC-2016-0002-0335 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Janese Murray Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:17Z   0 0 0900006481f7abb5
EEOC-2016-0002-0338 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Margot Dorfman Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:34Z   0 0 0900006481f7abb8
EEOC-2016-0002-0327 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Betsey Stevenson Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:27Z   0 0 0900006481f7abad
EEOC-2016-0002-0329 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of David Fortney Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:36Z   0 0 0900006481f7abaf
EEOC-2016-0002-0331 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Elizabeth Milito Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:47Z   0 0 0900006481f7abb1
EEOC-2016-0002-0328 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Camille Olson Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:31Z   0 0 0900006481f7abae
EEOC-2016-0002-0336 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Jocelyn Frye Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:22Z   0 0 0900006481f7abb6
EEOC-2016-0002-0326 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Ariane Hegewisch Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:21Z   0 0 0900006481f7ade1
EEOC-2016-0002-0332 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Emily Martin Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:57Z   0 0 0900006481f7abb2
EEOC-2016-0002-0337 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Lisa Maatz Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:28Z   0 0 0900006481f7abb7
EEOC-2016-0002-0333 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Gary Siniscalco Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:06Z   0 0 0900006481f7abb3
EEOC-2016-0002-0339 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Michael Eastman Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:31:40Z   0 0 0900006481f7abb9
EEOC-2016-0002-0325 EEOC Proposed Revisions to EEO-1 EEOC-2016-0002 Statement of Amanda Wood Other   2016-04-20T04:00:00Z 2016 4 2016-04-20T04:00:00Z   2016-04-20T21:30:11Z   0 0 0900006481f7ade0
EEOC-2016-0001-0001 EEOC Proposed Enforcement Guidance on Retaliation and Related Issues EEOC-2016-0001 Draft retaliation guidance for public input 1_21_201 Other   2016-01-21T05:00:00Z 2016 1 2016-01-21T05:00:00Z 2016-02-25T04:59:59Z 2016-03-21T21:00:31Z   0 0 0900006481e26135
EEOC-2015-0010-0001 EEOC Semiannual Regulatory Agenda - Fall 2015 EEOC-2015-0010 Semiannual Regulatory Agenda - Fall 2015 Other   2015-11-24T05:00:00Z 2015 11 2015-11-24T05:00:00Z   2015-11-25T14:28:08Z   0 0 0900006481d712f6
EEOC-2015-0010-0002 EEOC Semiannual Regulatory Agenda - Fall 2015 EEOC-2015-0010 Regulatory Plan - Fall 2015 Other   2015-11-24T05:00:00Z 2015 11 2015-11-24T05:00:00Z   2015-11-25T14:28:08Z   0 0 0900006481d712f7
EEOC-2015-0006-0322 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Employers Health_Comments on ADA NPRM Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:20Z   0 0 0900006481b55ca3
EEOC-2015-0006-0332 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Congressman Brady_Comments dated 6-17-15 Massachusetts Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:19Z   0 0 0900006481b55d02
EEOC-2015-0006-0327 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments dated 6-4-15 Hennepin Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:50Z   0 0 0900006481b55cfc
EEOC-2015-0006-0325 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Carin Memmer_Comments received 6-6-2015 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:36Z   0 0 0900006481b55863
EEOC-2015-0006-0326 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 City of Phoenix_Comments received 6-9-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:44Z   0 0 0900006481b55866
EEOC-2015-0006-0328 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments dated 6-19-15 from Bazelon Center Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:56Z   0 0 0900006481b55cfd
EEOC-2015-0006-0336 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 MD Disability Law_Comments dated 6-20-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:53Z   0 0 0900006481b55d34
EEOC-2015-0006-0329 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments dates 6-8-15 Phoenix Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:02Z   0 0 0900006481b55cfe
EEOC-2015-0006-0320 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments dated 6-19-15 from Bazelon Center Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:08Z   0 0 0900006481b55831
EEOC-2015-0006-0319 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Alston and Bird_Comments received 6-19-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:01Z   0 0 0900006481b5582c
EEOC-2015-0006-0323 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Senator Lewis MA_Comments dated 6-11-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:26Z   0 0 0900006481b55860
EEOC-2015-0006-0338 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Simply Health_Comments dated 6-19-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:13:08Z   0 0 0900006481b55d37
EEOC-2015-0006-0333 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Eby Brown_Comments dated 6-12-15_1 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:27Z   0 0 0900006481b55d03
EEOC-2015-0006-0324 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Barnes and Thronburg_Comments dated 6-18-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:31Z   0 0 0900006481b55862
EEOC-2015-0006-0335 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Foundations Health_Comments dated 6-16-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:41Z   0 0 0900006481b55d05
EEOC-2015-0006-0337 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 SelfHelpWorks_Comments ADA 6-8-2015 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:59Z   0 0 0900006481b55d36
EEOC-2015-0006-0334 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 FDIC_Comments dated 6-17-15 Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:34Z   0 0 0900006481b55d04
EEOC-2015-0006-0330 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments dates 6-18-15 Minneapolis Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:07Z   0 0 0900006481b55cff
EEOC-2015-0006-0321 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments from Tyson Foods Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:11:14Z   0 0 0900006481b55c9c
EEOC-2015-0006-0331 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Comments dates 6-22-15 Rally Other   2015-06-25T04:00:00Z 2015 6 2015-06-25T04:00:00Z   2015-06-25T18:12:13Z   0 0 0900006481b55d01
EEOC-2015-0006-0155 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 NCD Comments dated 6-4-15 Other   2015-06-23T04:00:00Z 2015 6 2015-06-23T04:00:00Z   2015-06-23T14:52:53Z   0 0 0900006481b50040
EEOC-2015-0006-0152 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Bravo Wellness Comments on ADA 5-21-15 Other   2015-06-23T04:00:00Z 2015 6 2015-06-23T04:00:00Z   2015-06-23T14:47:55Z   0 0 0900006481b501ac
EEOC-2015-0006-0154 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Jensen_Comments received 5-1-15 Other   2015-06-23T04:00:00Z 2015 6 2015-06-23T04:00:00Z   2015-06-23T14:52:44Z   0 0 0900006481b501b2
EEOC-2015-0006-0153 EEOC Amendments to Regulations Under American with Disabilities Act EEOC-2015-0006 Barnes Wellness Program comments received 6-1-2015 Other   2015-06-23T04:00:00Z 2015 6 2015-06-23T04:00:00Z   2015-06-23T14:50:49Z   0 0 0900006481b501b0
EEOC-2015-0007-0001 EEOC Semiannual Regulatory Agenda - Spring 2015 EEOC-2015-0007 Semiannual Regulatory Agenda - Spring 2015 Other   2015-05-27T04:00:00Z 2015 5 2015-05-27T04:00:00Z   2015-05-27T16:58:10Z   0 0 0900006481b05f55
EEOC-2014-0005-0001 EEOC Semiannual Regulatory Agenda - Spring 2014 EEOC-2014-0005 Semiannual Regulatory Agenda - Spring 2014 Other   2014-05-23T04:00:00Z 2014 5 2014-05-23T04:00:00Z   2014-05-24T00:28:38Z   0 0 0900006481710805
EEOC-2014-0001-0001 EEOC Revised EEO Management Directive 110 EEOC-2014-0001 MD-110 Draft for public comment Other   2014-02-20T05:00:00Z 2014 2 2014-02-20T05:00:00Z 2014-04-26T03:59:59Z 2014-04-27T01:02:13Z   0 0 0900006481585946
EEOC-2013-0004-0001 EEOC Semiannual Regulatory Agenda - Fall 2013 EEOC-2013-0004 Semiannual Regulatory Agenda - Fall 2013 Other   2013-11-26T05:00:00Z 2013 11 2013-11-26T05:00:00Z   2013-11-26T23:29:08Z   0 0 090000648149ab81
EEOC-2013-0004-0002 EEOC Semiannual Regulatory Agenda - Fall 2013 EEOC-2013-0004 Regulatory Plan - Fall 2013 Other   2013-11-26T05:00:00Z 2013 11 2013-11-26T05:00:00Z   2013-11-26T23:29:09Z   0 0 090000648149ab82
EEOC-2013-0003-0001 EEOC Semiannual Regulatory Agenda - Spring 2013 EEOC-2013-0003 Semiannual Regulatory Agenda - Spring 2013 Other   2013-07-03T04:00:00Z 2013 7 2013-07-03T04:00:00Z   2013-07-03T17:30:55Z   0 0 09000064813562c4
EEOC-2012-0005-0002 EEOC Semiannual Regulatory Agenda - Fall 2012 EEOC-2012-0005 Regulatory Plan - Fall 2012 Other   2012-12-24T05:00:00Z 2012 12 2012-12-24T05:00:00Z   2013-01-11T16:39:57Z   0 0 090000648119910e
EEOC-2012-0005-0001 EEOC Semiannual Regulatory Agenda - Fall 2012 EEOC-2012-0005 Semiannual Regulatory Agenda - Fall 2012 Other   2012-12-24T05:00:00Z 2012 12 2012-12-24T05:00:00Z   2012-12-27T19:15:31Z   0 0 090000648119910d
EEOC-2012-0001-0001 EEOC Semiannual Regulatory Agenda and Plan- Fall 2011 EEOC-2012-0001 Semiannual Regulatory Agenda - Fall 2011 Other   2012-01-20T05:00:00Z 2012 1 2012-01-20T05:00:00Z   2012-02-14T17:11:16Z   0 0 0900006480f9e3c5
EEOC-2012-0001-0002 EEOC Semiannual Regulatory Agenda and Plan- Fall 2011 EEOC-2012-0001 Regulatory Plan - Fall 2011 Other   2012-01-20T05:00:00Z 2012 1 2012-01-20T05:00:00Z   2012-01-20T16:03:29Z   0 0 0900006480f9e3c6
EEOC-2011-0016-0001 EEOC Semiannual Regulatory Agenda - Spring 2011 EEOC-2011-0016 Semiannual Regulatory Agenda - Spring 2011 Other   2011-07-07T04:00:00Z 2011 7 2011-07-07T04:00:00Z   2011-07-07T15:06:05Z   0 0 0900006480ebafbf
EEOC-2010-0007-0001 EEOC Semiannual Regulatory Agenda - Fall 2010 EEOC-2010-0007 Semiannual Regulatory Agenda - Fall 2010 Other NA 2010-12-20T05:00:00Z 2010 12 2010-12-20T05:00:00Z   2010-12-20T17:30:36Z   0 0 0900006480bba9ed
EEOC-2010-0007-0002 EEOC Semiannual Regulatory Agenda - Fall 2010 EEOC-2010-0007 Regulatory Plan - Fall 2010 Other NA 2010-12-20T05:00:00Z 2010 12 2010-12-20T05:00:00Z   2010-12-20T17:30:36Z   0 0 0900006480bba9ee
EEOC-2010-0005-0001 EEOC Semiannual Regulatory Agenda - Spring 2010 EEOC-2010-0005 Semiannual Regulatory Agenda - Spring 2010 Other NA 2010-04-26T04:00:00Z 2010 4     2010-04-26T17:39:07Z   0 0 0900006480adf5fa
EEOC-2009-0013-0002 EEOC Semiannual Regulatory Agenda - Fall 2009 EEOC-2009-0013 Regulatory Plan - Fall 2009 Other NA 2009-12-07T11:28:59Z 2009 12     2009-12-08T22:46:31Z   0 0 0900006480a64d6a
EEOC-2009-0013-0001 EEOC Semiannual Regulatory Agenda - Fall 2009 EEOC-2009-0013 Semiannual Regulatory Agenda - Fall 2009 Other NA 2009-12-07T11:28:56Z 2009 12     2009-12-08T22:45:34Z   0 0 0900006480a64d69
EEOC-2009-0010-0001 EEOC Semiannual Regulatory Agenda - Spring 2009 EEOC-2009-0010 Semiannual Regulatory Agenda - Spring 2009 Other NA 2009-05-10T16:40:01Z 2009 5     2009-05-10T23:29:45Z   0 0 09000064809844c1
EEOC-2008-0014-0002 EEOC Semiannual Regulatory Agenda - Fall 2008 EEOC-2008-0014 Regulatory Plan - Fall 2008 Other NA 2008-11-23T18:11:00Z 2008 11     2008-12-20T15:43:11Z   0 0 09000064807bb92b
EEOC-2008-0014-0001 EEOC Semiannual Regulatory Agenda - Fall 2008 EEOC-2008-0014 Semiannual Regulatory Agenda - Fall 2008 Other NA 2008-11-23T18:10:56Z 2008 11     2008-12-20T15:43:10Z   0 0 09000064807bb92a
EEOC-2008-0008-0001 EEOC Semiannual Regulatory Agenda - Spring 2008 EEOC-2008-0008 Semiannual Regulatory Agenda - Spring 2008 Other NA 2008-05-06T23:09:57Z 2008 5     2008-05-06T23:17:49Z   0 0 090000648054de8e
EEOC-2007-0024-0002 EEOC Semiannual Regulatory Agenda - Fall 2007 EEOC-2007-0024 Regulatory Plan - Fall 2007 Other NA 2007-12-10T14:41:47Z 2007 12     2008-01-08T21:04:41Z   0 0 0900006480375b15
EEOC-2007-0024-0001 EEOC Semiannual Regulatory Agenda - Fall 2007 EEOC-2007-0024 Semiannual Regulatory Agenda - Fall 2007 Other NA 2007-12-10T14:41:43Z 2007 12     2008-01-08T21:04:40Z   0 0 0900006480375b14

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