library(readr)
library(readxl)
library(dplyr)
Attaching package: 'dplyr'The following objects are masked from 'package:stats':
filter, lagThe following objects are masked from 'package:base':
intersect, setdiff, setequal, unionEO_4_V2
Import the dataset
US_Executive_executive_orders_21_3_1_ <- read_csv("US-Executive-executive_orders_21.3 (1).csv")Rows: 4459 Columns: 18
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (3): president, signed_date, description
dbl (15): id, eo_number, pres_party, beg_term, end_term, year, month, day, c...
ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.EO_Cap_Code_Mapping <- read_excel("EO Cap Code Mapping.xlsx")
EO_All_WithText <- read_csv("EO_All_WithText.csv")New names:
Rows: 6648 Columns: 21
── Column specification
──────────────────────────────────────────────────────── Delimiter: "," chr
(14): citation, document_number, html_url, pdf_url, type, subtype, titl... dbl
(4): ...1, end_page, start_page, year lgl (1): not_received_for_publication
date (2): publication_date, signing_date
ℹ Use `spec()` to retrieve the full column specification for this data. ℹ
Specify the column types or set `show_col_types = FALSE` to quiet this message.
• `` -> `...1`Clean the data
US_Executive_executive_orders_21_3_1_new <- US_Executive_executive_orders_21_3_1_ %>%
filter(president %in% c("GWBUSH","OBAMA","TRUMP")) %>%rename("executive_order_number"= "eo_number")EO_Cap_Code_Mapping_new <- EO_Cap_Code_Mapping %>% rename("majortopic"= "majortopic_no", "subtopic"="subtopic_no")eo_data <- EO_All_WithText %>% filter(signing_date >= "2001-01-20" & signing_date <= "2021-01-19")Merge the dataset
merged_df <- left_join(US_Executive_executive_orders_21_3_1_new, EO_Cap_Code_Mapping_new, by=c("majortopic", "subtopic"))
merged_df <- merged_df %>% mutate(executive_order_number = as.character(executive_order_number)) %>% mutate (month= as.character(month)) %>% mutate (day = as.character(day))
merged_df_all <- left_join(eo_data, merged_df, by= "executive_order_number")
# Display the first few rows of the merged dataframe to inspect
print(head(merged_df_all))# A tibble: 6 × 43
...1 citation document_number end_page html_url pdf_url type subtype
<dbl> <chr> <chr> <dbl> <chr> <chr> <chr> <chr>
1 329 67 FR 39841 02-14807 39842 https://www.… https:… Pres… Execut…
2 330 67 FR 22337 02-11166 22338 https://www.… https:… Pres… Execut…
3 331 66 FR 8497 01-2851 8498 https://www.… https:… Pres… Execut…
4 332 69 FR 29843 04-11991 29844 https://www.… https:… Pres… Execut…
5 333 68 FR 26981 03-12661 26981 https://www.… https:… Pres… Execut…
6 334 68 FR 55255 03-24217 55256 https://www.… https:… Pres… Execut…
# ℹ 35 more variables: publication_date <date>, signing_date <date>,
# start_page <dbl>, title <chr>, disposition_notes <chr>,
# executive_order_number <chr>, not_received_for_publication <lgl>,
# month.x <chr>, day.x <chr>, year.x <dbl>, full_text_xml_url <chr>,
# text <chr>, full_text_html_url <chr>, id <dbl>, president <chr>,
# pres_party <dbl>, beg_term <dbl>, end_term <dbl>, signed_date <chr>,
# year.y <dbl>, month.y <chr>, day.y <chr>, congress <dbl>, divided <dbl>, …Check the missing values
# Check for NA values in the columns you mentioned
print(sum(is.na(merged_df_all$majortopic_title)))[1] 7print(sum(is.na(merged_df_all$subtopic_title)))[1] 7print(sum(is.na(merged_df_all$racial)))[1] 7subset(merged_df, is.na(`racial`)) %>% print.data.frame() id executive_order_number president pres_party beg_term end_term
1 4112 13638 OBAMA 100 0 0
2 4126 13652 OBAMA 100 0 0
3 4129 13655 OBAMA 100 0 0
4 4459 13982 TRUMP 200 0 1
signed_date year month day congress divided commemorative
1 20130315 2013 3 15 113 1 0
2 20130930 2013 9 30 113 1 0
3 20131223 2013 12 23 113 1 0
4 1/19/21 2021 1 19 117 1 0
description.x pap_majortopic
1 Amendments to Executive Order 12777 7
2 Continuance of Certain Federal Advisory Committees 2
3 Adjustments of Certain Rates of Pay 2
4 Care of Veterans With Service in Uzbekistan 16
pap_subtopic majortopic subtopic majortopic_title subtopic_title
1 710 7 710 <NA> <NA>
2 2011 2 2011 <NA> <NA>
3 2004 2 2004 <NA> <NA>
4 1609 16 1609 <NA> <NA>
description.y cap_notes racial
1 <NA> <NA> <NA>
2 <NA> <NA> <NA>
3 <NA> <NA> <NA>
4 <NA> <NA> <NA>subset(merged_df_all, is.na(`racial`))%>% print.data.frame() ...1 citation document_number end_page
1 4900 78 FR 80451 2013-31445 80462
2 4915 77 FR 77249 2012-31574 77249
3 4918 78 FR 649 2013-00002 660
4 5067 78 FR 61817 2013-24388 61820
5 5115 78 FR 17589 2013-06712 17590
6 5126 77 FR 76339 2012-31225 76340
7 6623 86 FR 6833 2021-01712 6834
html_url
1 https://www.federalregister.gov/documents/2013/12/31/2013-31445/adjustments-of-certain-rates-of-pay
2 https://www.federalregister.gov/documents/2012/12/31/2012-31574/reestablishment-of-advisory-commission
3 https://www.federalregister.gov/documents/2013/01/03/2013-00002/adjustments-of-certain-rates-of-pay
4 https://www.federalregister.gov/documents/2013/10/04/2013-24388/continuance-of-certain-federal-advisory-committees
5 https://www.federalregister.gov/documents/2013/03/21/2013-06712/amendments-to-executive-order-12777
6 https://www.federalregister.gov/documents/2012/12/28/2012-31225/closing-of-executive-departments-and-agencies-of-the-federal-government-on-monday-december-24-2012
7 https://www.federalregister.gov/documents/2021/01/25/2021-01712/care-of-veterans-with-service-in-uzbekistan
pdf_url
1 https://www.govinfo.gov/content/pkg/FR-2013-12-31/pdf/2013-31445.pdf
2 https://www.govinfo.gov/content/pkg/FR-2012-12-31/pdf/2012-31574.pdf
3 https://www.govinfo.gov/content/pkg/FR-2013-01-03/pdf/2013-00002.pdf
4 https://www.govinfo.gov/content/pkg/FR-2013-10-04/pdf/2013-24388.pdf
5 https://www.govinfo.gov/content/pkg/FR-2013-03-21/pdf/2013-06712.pdf
6 https://www.govinfo.gov/content/pkg/FR-2012-12-28/pdf/2012-31225.pdf
7 https://www.govinfo.gov/content/pkg/FR-2021-01-25/pdf/2021-01712.pdf
type subtype publication_date signing_date
1 Presidential Document Executive Order 2013-12-31 2013-12-23
2 Presidential Document Executive Order 2012-12-31 2012-12-21
3 Presidential Document Executive Order 2013-01-03 2012-12-27
4 Presidential Document Executive Order 2013-10-04 2013-09-30
5 Presidential Document Executive Order 2013-03-21 2013-03-15
6 Presidential Document Executive Order 2012-12-28 2012-12-21
7 Presidential Document Executive Order 2021-01-25 2021-01-19
start_page
1 80451
2 77249
3 649
4 61817
5 17589
6 76339
7 6833
title
1 Adjustments of Certain Rates of Pay
2 Reestablishment of Advisory Commission
3 Adjustments of Certain Rates of Pay
4 Continuance Of Certain Federal Advisory Committees
5 Amendments to Executive Order 12777
6 Closing of Executive Departments and Agencies of the Federal Government on Monday, December 24, 2012
7 Care of Veterans With Service in Uzbekistan
disposition_notes
1 Supersedes: EO 13641, April 5, 2013; EO 13686, December 19, 2014
2 Continued by: EO 13652, September 30, 2013;\n See: EO 13555, October 19, 2010
3 Supersedes: EO 13594, December 19, 2011;\n Superseded by EO 13641, April 5, 2013
4 Amends: EO 13043, April 16, 1997; EO 13231, October 16, 2001; EO 13515, October 14, 2009; EO 13538, April 19, 2010; EO 13600, February 9, 2012;\n Supersedes in part: EO 13585, September 30, 2011; EO 13591, November 23, 2011; EO 13708, September 30, 2015\n Continues: EO 11145, March 7, 1964; EO 11183, October 3, 1964; EO 11287, June 28, 1966; EO 11612, July 26, 1971; EO 12131, May 4, 1979; EO 12216, June 19, 1980; EO 12367, June 15, 1982; EO 12382, September 13, 1982; EO 12829, January 6, 1993; EO 12905, March 25, 1994; EO 12994, March 21, 1996; EO 13231, October 16, 2001; EO 13265, June 6, 2002; EO 13515, October 14, 2009; EO 13521, November 24, 2009; EO 13522, December 9, 2009; EO 13532, February 26, 2010; EO 13538, April 19, 2010; EO 13539, April 21, 2010; EO 13540, April 26, 2010; EO 13549, August 18, 2010; EO 13600, February 9, 2012; EO 13621, July 26, 2012; EO 13631, December 7, 2012; EO 13634, December 21, 2012; EO 13640, January 5, 2013;\n ee: EO 13498, February 5, 2009; EO 13544, June 10, 2010; EO 13555, October 19, 2010
5 <NA>
6 <NA>
7 <NA>
executive_order_number not_received_for_publication month.x day.x year.x
1 13655 NA 12 31 2013
2 13634 NA 12 31 2012
3 13635 NA 1 3 2013
4 13652 NA 10 4 2013
5 13638 NA 3 21 2013
6 13633 NA 12 28 2012
7 13982 NA 1 25 2021
full_text_xml_url
1 https://www.federalregister.gov/documents/full_text/xml/2013/12/31/2013-31445.xml
2 https://www.federalregister.gov/documents/full_text/xml/2012/12/31/2012-31574.xml
3 https://www.federalregister.gov/documents/full_text/xml/2013/01/03/2013-00002.xml
4 https://www.federalregister.gov/documents/full_text/xml/2013/10/04/2013-24388.xml
5 https://www.federalregister.gov/documents/full_text/xml/2013/03/21/2013-06712.xml
6 https://www.federalregister.gov/documents/full_text/xml/2012/12/28/2012-31225.xml
7 https://www.federalregister.gov/documents/full_text/xml/2021/01/25/2021-01712.xml
text
1 Executive Order 13655 of December 23, 2013Adjustments of Certain Rates of PayBy the authority vested in me as President by the Constitution and the laws of the United States of America, it is hereby ordered as follows:Section 1\n . \n Statutory Pay Systems.\n The rates of basic pay or salaries of the statutory pay systems (as defined in 5 U.S.C. 5302(1)), as adjusted under 5 U.S.C. 5303, are set forth on the schedules attached hereto and made a part hereof:\n (a) The General Schedule (5 U.S.C. 5332(a)) at Schedule 1;(b) The Foreign Service Schedule (22 U.S.C. 3963) at Schedule 2; and(c) The schedules for the Veterans Health Administration of the Department of Veterans Affairs (38 U.S.C. 7306, 7404; section 301(a) of Public Law 102-40) at Schedule 3.Sec. 2\n . \n Senior Executive Service.\n The ranges of rates of basic pay for senior executives in the Senior Executive Service, as established pursuant to 5 U.S.C. 5382, are set forth on Schedule 4 attached hereto and made a part hereof.\n Sec. 3\n . \n Certain Executive, Legislative, and Judicial Salaries.\n The rates of basic pay or salaries for the following offices and positions are set forth on the schedules attached hereto and made a part hereof:\n (a) The Executive Schedule (5 U.S.C. 5312-5318) at Schedule 5;(b) The Vice President (3 U.S.C. 104) and the Congress (2 U.S.C. 31) at Schedule 6; and(c) Justices and judges (28 U.S.C. 5, 44(d), 135, 252, and 461(a)) at Schedule 7.Sec. 4\n . \n Uniformed Services.\n The rates of monthly basic pay (37 U.S.C. 203(a)) for members of the uniformed services, as adjusted under 37 U.S.C. 1009, and the rate of monthly cadet or midshipman pay (37 U.S.C. 203(c)) are set forth on Schedule 8 attached hereto and made a part hereof.\n Sec. 5\n . \n Locality-Based Comparability Payments.\n (a) Pursuant to section 5304 of title 5, United States Code, and my authority to implement an alternative level of comparability payments under section 5304a of title 5, United States Code, locality-based comparability payments shall be paid in accordance with Schedule 9 attached hereto and made a part hereof.\n \n (b) The Director of the Office of Personnel Management shall take such actions as may be necessary to implement these payments and to publish appropriate notice of such payments in the \n Federal Register.\n Sec. 6\n . \n Administrative Law Judges.\n Pursuant to section 5372 of title 5, United States Code, the rates of basic pay for administrative law judges are set forth on Schedule 10 attached hereto and made a part hereof.\n Sec. 7\n . \n Effective Dates.\n Schedule 8 is effective January 1, 2014. The other schedules contained herein are effective on the first day of the first applicable pay period beginning on or after January 1, 2014.\n Sec. 8\n . \n Prior Order Superseded.\n Executive Order 13641 of April 5, 2013, is superseded as of the effective dates specified in section 7 of this order.\n OB#1.EPS THE WHITE HOUSE,December 23, 2013.Billing code 3295-F2-PED31DE13.195ED31DE13.196ED31DE13.197ED31DE13.198ED31DE13.199ED31DE13.200ED31DE13.201ED31DE13.202ED31DE13.203ED31DE13.204[FR Doc. 2013-31445Filed 12-30-13; 11:15 a.m.]Billing code 6325-01-C
2 Title 3—\n The President\n \n Executive Order 13634 of December 21, 2012Reestablishment of Advisory CommissionBy the authority vested in me as President by the Constitution and the laws of the United States of America, it is hereby ordered as follows:Section 1\n . \n Reestablishing the President's Advisory Commission on Educational Excellence for Hispanics.\n The President's Advisory Commission on Educational Excellence for Hispanics (Commission), as set forth under the provisions of Executive Order 13555 of October 19, 2010, is hereby reestablished and shall terminate on September 30, 2013, unless extended by the President. The same members who were serving on the Commission on October 19, 2012, are hereby reappointed to the Commission as reestablished by this order, as if the Commission had continued without termination through the date of this Executive Order.\n Sec. 2\n . \n General Provisions.\n (a) Nothing in this order shall be construed to impair or otherwise affect:\n (1) the authority granted by law to an executive department, agency, or the head thereof; or(2) the functions of the Director of the Office of Management and Budget relating to budgetary, administrative, or legislative proposals.(b) This order is not intended to, and does not, create any right or benefit, substantive or procedural, enforceable at law or in equity by any party against the United States, its departments, agencies, or entities, its officers, employees, or agents, or any other person.OB#1.EPS THE WHITE HOUSE, Washington, December 21, 2012.[FR Doc. 2012-31574Filed 12-28-12; 11:15 am]Billing code 3295-F3
3 Executive Order 13635 of December 27, 2012Adjustments of Certain Rates of PayBy the authority vested in me as President by the Constitution and the laws of the United States of America, including section 114(b) of the Continuing Appropriations Resolution, 2013 (Public Law 112-175), which provides that any statutory adjustments to current levels in certain pay schedules for civilian Federal employees may take effect on the first day of the first applicable pay period beginning after the date specified in section 106(3) of Public Law 112-175, it is hereby ordered as follows:Section 1\n . \n Statutory Pay Systems.\n The rates of basic pay or salaries of the statutory pay systems (as defined in 5 U.S.C. 5302(1)), as adjusted under 5 U.S.C. 5303, are set forth on the schedules attached hereto and made a part hereof:\n (a) The General Schedule (5 U.S.C. 5332(a)) at Schedule 1;(b) The Foreign Service Schedule (22 U.S.C. 3963) at Schedule 2; and(c) The schedules for the Veterans Health Administration of the Department of Veterans Affairs (38 U.S.C. 7306, 7404; section 301(a) of Public Law 102-40) at Schedule 3.Sec. 2\n . \n Senior Executive Service.\n The ranges of rates of basic pay for senior executives in the Senior Executive Service, as established pursuant to 5 U.S.C. 5382, are set forth on Schedule 4 attached hereto and made a part hereof.\n Sec. 3\n . \n Certain Executive, Legislative, and Judicial Salaries.\n The rates of basic pay or salaries for the following offices and positions are set forth on the schedules attached hereto and made a part hereof:\n (a) The Executive Schedule (5 U.S.C. 5312-5318) at Schedule 5;(b) The Vice President (3 U.S.C. 104) and the Congress (2 U.S.C. 31) at Schedule 6; and(c) Justices and judges (28 U.S.C. 5, 44(d), 135, 252, and 461(a), and section 140 of Public Law 97-92) at Schedule 7.Sec. 4\n . \n Uniformed Services.\n The rates of monthly basic pay (37 U.S.C. 203(a)) for members of the uniformed services, as adjusted under 37 U.S.C. 1009, and the rate of monthly cadet or midshipman pay (37 U.S.C. 203(c)) are set forth on Schedule 8 attached hereto and made a part hereof.\n Sec. 5\n . \n Locality-Based Comparability Payments.\n (a) Pursuant to section 5304 of title 5, United States Code, and my authority to implement an alternative level of comparability payments under section 5304a of title 5, United States Code, locality-based comparability payments shall be paid in accordance with Schedule 9 attached hereto and made a part hereof.\n \n (b) The Director of the Office of Personnel Management shall take such actions as may be necessary to implement these payments and to publish appropriate notice of such payments in the \n Federal Register\n .\n Sec. 6\n . \n Administrative Law Judges.\n Pursuant to section 5372 of title 5, United States Code, the rates of basic pay for administrative law judges are set forth on Schedule 10 attached hereto and made a part hereof.\n Sec. 7\n . \n Effective Dates.\n Schedule 8 is effective January 1, 2013. The other schedules contained herein are effective on the first day of the first applicable pay period beginning after the date specified in section 106(3) of Public Law 112-175.\n \n Sec. 8\n . \n Prior Order Superseded.\n Executive Order 13594 of December 19, 2011, is superseded as of the effective dates specified in section 7 of this order.\n OB#1.EPS THE WHITE HOUSE,Washington, December 27, 2012.Billing code 3295-F3-PED03JA13.079ED03JA13.080ED03JA13.081ED03JA13.082ED03JA13.083ED03JA13.084ED03JA13.085ED03JA13.086ED03JA13.087ED03JA13.088[FR Doc. 2013-00002Filed 1-2-13; 11:15 a.m.]Billing code 6325-01-C
4 Executive Order 13652 of September 30, 2013Continuance Of Certain Federal Advisory CommitteesBy the authority vested in me as President, by the Constitution and the laws of the United States of America, and consistent with the provisions of the Federal Advisory Committee Act, as amended (5 U.S.C. App.), it is hereby ordered as follows: Section 1.\n Each advisory committee listed below is continued until September 30, 2015.\n (a) Committee for the Preservation of the White House; Executive Order 11145, as amended (Department of the Interior).(b) President's Commission on White House Fellowships; Executive Order 11183, as amended (Office of Personnel Management).(c) President's Committee on the National Medal of Science; Executive Order 11287, as amended (National Science Foundation).(d) Federal Advisory Council on Occupational Safety and Health; Executive Order 11612, as amended (Department of Labor).(e) President's Export Council; Executive Order 12131, as amended (Department of Commerce).(f) President's Committee on the International Labor Organization; Executive Order 12216, as amended (Department of Labor).(g) President's Committee on the Arts and the Humanities; Executive Order 12367, as amended (National Endowment for the Arts).(h) President's National Security Telecommunications Advisory Committee; Executive Order 12382, as amended (Department of Homeland Security).(i) National Industrial Security Program Policy Advisory Committee; Executive Order 12829, as amended (National Archives and Records Administration).(j) Trade and Environment Policy Advisory Committee; Executive Order 12905, as amended (Office of the United States Trade Representative).(k) President's Committee for People with Intellectual Disabilities; Executive Order 12994, as amended (Department of Health and Human Services).(l) National Infrastructure Advisory Council; Executive Order 13231, as amended (Department of Homeland Security).(m) President's Council on Fitness, Sports, and Nutrition; Executive Order 13265, as amended (Department of Health and Human Services).(n) President's Advisory Council on Faith-Based and Neighborhood Partnerships; Executive Order 13498, re-established by Executive Order 13569, and continued by Executive Order 13640 (Department of Health and Human Services).(o) President's Advisory Commission on Asian Americans and Pacific Islanders; Executive Order 13515, as amended (Department of Education).(p) Presidential Commission for the Study of Bioethical Issues; Executive Order 13521 (Department of Health and Human Services).\n (q) National Council on Federal Labor-Management Relations; Executive Order 13522 (Office of Personnel Management).\n \n (r) President's Board of Advisors on Historically Black Colleges and Universities; Executive Order 13532, as amended (Department of Education).(s) President's Management Advisory Board; Executive Order 13538 (General Services Administration).(t) President's Council of Advisors on Science and Technology; Executive Order 13539, as amended (Department of Energy).(u) Interagency Task Force on Veterans Small Business Development; Executive Order 13540 (Small Business Administration).(v) Advisory Group on Prevention, Health Promotion, and Integrative and Public Health; Executive Order 13544, re-established by Executive Order 13631 (Department of Health and Human Services).(w) State, Local, Tribal, and Private Sector (SLTPS) Policy Advisory Committee; Executive Order 13549, as amended (National Archives and Records Administration).(x) President's Advisory Commission on Educational Excellence for Hispanics; Executive Order 13555, re-established by Executive Order 13634 (Department of Education).(y) President's Global Development Council; Executive Order 13600 (United States Agency for International Development).(z) President's Advisory Commission on Educational Excellence for African Americans; Executive Order 13621 (Department of Education).Sec. 2.\n Notwithstanding the provisions of any other Executive Order, the functions of the President under the Federal Advisory Committee Act that are applicable to the committees listed in section 1 of this order shall be performed by the head of the department or agency designated after each committee, in accordance with the regulations, guidelines, and procedures established by the Administrator of General Services.\n Sec. 3.\n Sections 1 and 2 of Executive Order 13585 of September 30, 2011, and sections 1, 2, and 4 of Executive Order 13591 of November 23, 2011, are superseded by sections 1 and 2 of this order.\n Sec. 4.\n Executive Order 13538 of April 19, 2010, is amended in section 4(c) by striking “The Executive Director shall serve as the Designated Federal Officer in accordance with the Federal Advisory Committee Act, as amended (5 U.S.C. App.) (FACA)” and inserting in lieu thereof “The PMAB shall also have a Designated Federal Officer (DFO) in accordance with the Federal Advisory Committee Act, as amended (5 U.S.C. App.) (FACA). The Executive Director may serve as the DFO”.\n Sec. 5.\n Executive Order 13043 of April 16, 1997, is amended by striking section 4 and renumbering the subsequent sections appropriately.\n Sec. 6.\n Executive Order 13231 of October 16, 2001, as amended, is further amended by striking section 3, except subsection (c) thereof, and inserting immediately preceding subsection (c), the following:\n \n “\n Sec. 3.\n \n The National Infrastructure Advisory Council.\n The National Infrastructure Advisory Council (NIAC), established on October 16, 2001, shall provide the President, through the Secretary of Homeland Security, with advice on the security and resilience of the critical infrastructure sectors and their functional systems, physical assets, and cyber networks.\n \n “(a) \n Membership.\n The NIAC shall be composed of not more than 30 members appointed by the President, taking appropriate account of the benefits of having members:\n \n “(i) from the private sector, including individuals with experience in banking and finance, transportation, energy, water, communications, health care services, food and agriculture, government facilities, emergency services organizations, institutions of higher education, environmental and climate resilience, and State, local, and tribal governments;\n \n “(ii) with senior executive leadership responsibilities for the availability and reliability, including security and resilience, of critical infrastructure sectors;“(iii) with expertise relevant to the functions of the NIAC; and“(iv) with experience equivalent to that of a chief executive of an organization.“Unless otherwise determined by the President, no full-time officer or employee of the executive branch shall be appointed to serve as a member of the NIAC. The President shall designate from among the members of the NIAC a Chair and a Vice Chair, who shall perform the functions of the Chair if the Chair is absent or disabled, or in the instance of a vacancy in the Chair.\n “(b) \n Functions of the NIAC.\n The NIAC shall meet periodically to:\n “(i) enhance the partnership of the public and private sectors in securing and enhancing the security and resilience of critical infrastructure and their supporting functional systems, physical assets, and cyber networks, and provide reports on this issue to the President, through the Secretary of Homeland Security, as appropriate;“(ii) propose and develop ways to encourage private industry to perform periodic risk assessments and implement risk-reduction programs;“(iii) monitor the development and operations of critical infrastructure sector coordinating councils and their information-sharing mechanisms and provide recommendations to the President, through the Secretary of Homeland Security, on how these organizations can best foster improved cooperation among the sectors, the Department of Homeland Security, and other Federal Government entities;“(iv) report to the President through the Secretary of Homeland Security, who shall ensure appropriate coordination with the Assistant to the President for Homeland Security and Counterterrorism, the Assistant to the President for Economic Policy, and the Assistant to the President for National Security Affairs under the terms of this order; and“(v) advise sector-specific agencies with critical infrastructure responsibilities to include issues pertaining to sector and government coordinating councils and their information sharing mechanisms.“In implementing this order, the NIAC shall not advise or otherwise act on matters pertaining to National Security and Emergency Preparedness (NS/EP) Communications and, with respect to any matters to which the NIAC is authorized by this order to provide advice or otherwise act on that may depend on or affect NS/EP Communications, shall coordinate with the National Security and Telecommunications Advisory Committee established by Executive Order 12382 of September 13, 1982, as amended.”.Sec. 7.\n Executive Order 13600 of February 9, 2012, is amended in section 3(b) by striking the “and” immediately preceding “the Chief Executive Officer of the Millennium Challenge Corporation” and by adding “, the United States Trade Representative, and the Chief Executive Officer of the Overseas Private Investment Corporation” immediately preceding “shall serve as non-voting members”. Executive Order 13600 is further amended in section 5(c) by adding “administrative” immediately preceding “matters and activities pertaining”.\n Sec. 8.\n Section 3(b) of Executive Order 13515 of October 14, 2009, as amended, is further amended by inserting in the list of agency members “the General Services Administration” and “the National Aeronautics and Space Administration” after “the Small Business Administration”, and redesignating the subsections of section 3(b) as appropriate. Subsection 3(b) is further amended by inserting at the end the following sentence:\n “The Initiative is encouraged to invite other affected agencies, such as the Consumer Financial Protection Bureau, the Corporation for National and Community Service, the Equal Employment Opportunity Commission, and the Federal Communications Commission to attend meetings and participate in the Initiative as appropriate.”.Sec. 9.\n This order shall be effective September 30, 2013.\n OB#1.EPS THE WHITE HOUSE,September 30, 2013.[FR Doc. 2013-24388Filed 10-3-13; 8:45 am]Billing code 3295-F4
5 Title 3—\n The President\n \n Executive Order 13638 of March 15, 2013Amendments to Executive Order 12777By the authority vested in me as President by the Constitution and the laws of the United States of America, it is hereby ordered as follows:Section 1\n . Section 4 of Executive Order 12777 of October 18, 1991, as amended (Implementation of Section 311 of the Federal Water Pollution Control Act of October 18, 1972, as Amended, and the Oil Pollution Act of 1990) is further amended by striking section 4 in its entirety and inserting in lieu thereof the following:\n \n “\n Sec. 4\n . \n Liability Limit Adjustment.\n (a)(1) The following functions vested in the President by section 1004(d) of OPA are delegated to the Secretary of the department in which the Coast Guard is operating, acting in consultation with the Administrator, the Secretary of Transportation, the Secretary of the Interior, and the Attorney General:\n (A) the adjustment of the limits of liability listed in section 1004(a) of OPA for vessels, onshore facilities, and deepwater ports subject to the DPA, to reflect significant increases in the Consumer Price Index;(B) the establishment of limits of liability under section 1004(d)(1), with respect to classes or categories of marine transportation-related onshore facilities, and the adjustment of any such limits of liability established under section 1004(d)(1), and of any limits of liability established under section 1004(d)(2) with respect to deepwater ports subject to the DPA, to reflect significant increases in the Consumer Price Index; and(C) the reporting to Congress on the desirability of adjusting limits of liability, with respect to vessels, marine transportation-related onshore facilities, and deepwater ports subject to the DPA.(2) The Administrator and the Secretary of Transportation will provide necessary regulatory analysis support to ensure timely regulatory Consumer Price Index adjustments by the Secretary of the department in which the Coast Guard is operating of the limits of liability listed in section 1004(a) of OPA for onshore facilities under subparagraph (a)(1)(A) of this section.(b) The following functions vested in the President by section 1004(d) of OPA are delegated to the Administrator, acting in consultation with the Secretary of the department in which the Coast Guard is operating, the Secretary of Transportation, the Secretary of the Interior, the Secretary of Energy, and the Attorney General:(1) the establishment of limits of liability under section 1004(d)(1), with respect to classes or categories of non-transportation-related onshore facilities, and the adjustment of any such limits of liability established under section 1004(d)(1) by the Administrator to reflect significant increases in the Consumer Price Index; and(2) the reporting to Congress on the desirability of adjusting limits of liability with respect to non-transportation-related onshore facilities.(c) The following functions vested in the President by section 1004(d) of OPA are delegated to the Secretary of Transportation, acting in consultation with the Secretary of the department in which the Coast Guard is operating, the Administrator, the Secretary of the Interior, and the Attorney General:\n (1) the establishment of limits of liability under section 1004(d)(1), with respect to classes or categories of non-marine transportation-related onshore \n \n facilities, and the adjustment of any such limits of liability established under section 1004(d)(1) by the Secretary of Transportation to reflect significant increases in the Consumer Price Index; and\n (2) the reporting to Congress on the desirability of adjusting limits of liability, with respect to non-marine transportation-related onshore facilities.(d) The following functions vested in the President by section 1004(d) of OPA are delegated to the Secretary of the Interior, acting in consultation with the Secretary of the department in which the Coast Guard is operating, the Administrator, the Secretary of Transportation, and the Attorney General:(1) the adjustment of limits of liability to reflect significant increases in the Consumer Price Index with respect to offshore facilities, including associated pipelines, other than deepwater ports subject to the DPA; and(2) the reporting to Congress on the desirability of adjusting limits of liability with respect to offshore facilities, including associated pipelines, other than deepwater ports subject to the DPA.”Sec. 2\n . (a) Nothing in this order shall be construed to impair or otherwise affect:\n (i) the authority granted by law to an executive department, agency, or the head thereof; or(ii) the functions of the Director of the Office of Management and Budget relating to budgetary, administrative, or legislative proposals.(b) This order is not intended to, and does not, create any right or benefit, substantive or procedural, enforceable at law or in equity by any party against the United States, its departments, agencies, or entities, its officers, employees, or agents, or any other person.OB#1.EPS THE WHITE HOUSE,March 15, 2013.[FR Doc. 2013-06712Filed 3-20-13; 11:15 am]Billing code 3295-F3
6 Title 3—The President\n Executive Order 13633 of December 21, 2012Closing of Executive Departments and Agencies of the Federal Government on Monday, December 24, 2012By the authority vested in me as President by the Constitution and the laws of the United States of America, it is hereby ordered as follows:Section 1. All executive branch departments and agencies of the Federal Government shall be closed and their employees excused from duty on Monday, December 24, 2012, the day before Christmas Day, except as provided in section 2 of this order.Sec. 2. The heads of executive branch departments and agencies may determine that certain offices and installations of their organizations, or parts thereof, must remain open and that certain employees must report for duty on December 24, 2012, for reasons of national security, defense, or other public need.Sec. 3. Monday, December 24, 2012, shall be considered as falling within the scope of Executive Order 11582 of February 11, 1971, and of 5 U.S.C. 5546 and 6103(b) and other similar statutes insofar as they relate to the pay and leave of employees of the United States.Sec. 4. The Director of the Office of Personnel Management shall take such actions as may be necessary to implement this order.Sec. 5. General Provisions. (a) This order shall be implemented consistent with applicable law and subject to the availability of appropriations.(b) Nothing in this order shall be construed to impair or otherwise affect:(i) the authority granted by law to an executive department or agency, or the head thereof; or(ii) the functions of the Director of the Office of Management and Budget relating to budgetary, administrative, or legislative proposals.(c) This order is not intended to, and does not, create any right or benefit, substantive or procedural, enforceable at law or in equity by any party against the United States, its departments, agencies, or entities, its officers, employees, or agents, or any other person.OB#1.EPS THE WHITE HOUSE, Washington, December 21, 2012.[FR Doc. 2012-31225Filed 12-21-12; 4:15 pm]Billing code 3295-F3
7 Executive Order 13982 of January 19, 2021Care of Veterans With Service in UzbekistanBy the authority vested in me as President by the Constitution and the laws of the United States of America, it is hereby ordered as follows:Section 1\n . The Secretary of Veterans Affairs, in consultation with the Secretary of Defense, shall consider whether to designate veterans who served on active duty in Uzbekistan between October 1, 2001, and December 31, 2005, as veterans who served on active duty in a theater of combat operations pursuant to section 1710(e)(1)(D) of title 38, United States Code.\n Sec. 2\n . Within 365 days of the date of this order, the Secretary of Defense shall conduct a rigorous study investigating toxic exposure by members of the Armed Forces deployed to the Karshi-Khanabad Air Base, Uzbekistan (Air Base), between October 1, 2001, and December 31, 2005. The Secretary of Defense shall submit a report summarizing the findings of the study to the President, through the Secretary of Veterans Affairs. The study shall include the following elements:\n (a) A detailed assessment of the conditions at the Air Base between October 1, 2001, and December 31, 2005, including identification of any toxic substances contaminating the Air Base during such period, the exact locations of the toxic substances, the time frames of exposure to the toxic substances, the service members exposed to the toxic substances, and the circumstances of such exposure.(b) A rigorous epidemiological study of any health consequences for members of the Armed Forces deployed to the Air Base between October 1, 2001, and December 31, 2005. This study shall be of equivalent rigor to studies used by the Department of Veterans Affairs to make determinations regarding diseases subject to presumptive service connections.(c) An assessment of any causal link between exposure to any toxic substances identified in subsection (a) of this section and any health consequences studied under subsection (b) of this section.Sec. 3\n . \n General Provisions.\n (a) Nothing in this order shall be construed to impair or otherwise affect:\n (i) the authority granted by law to an executive department or agency, or the head thereof; or(ii) the functions of the Director of the Office of Management and Budget related to budgetary, administrative, or legislative proposals.(b) This order shall be implemented in a manner consistent with applicable law and subject to the availability of appropriations.(c) This order is not intended to, and does not, create any right or benefit, substantive or procedural, enforceable at law or in equity by any party against the United States, its departments, agencies, or entities, its officers, employees, or agents, or any other person.Trump.EPS THE WHITE HOUSE,January 19, 2021.[FR Doc. 2021-01712 Filed 1-22-21; 8:45 am]Billing code 3295-F1-P
full_text_html_url id president pres_party beg_term end_term signed_date
1 <NA> 4129 OBAMA 100 0 0 20131223
2 <NA> NA <NA> NA NA NA <NA>
3 <NA> NA <NA> NA NA NA <NA>
4 <NA> 4126 OBAMA 100 0 0 20130930
5 <NA> 4112 OBAMA 100 0 0 20130315
6 <NA> NA <NA> NA NA NA <NA>
7 <NA> 4459 TRUMP 200 0 1 1/19/21
year.y month.y day.y congress divided commemorative
1 2013 12 23 113 1 0
2 NA <NA> <NA> NA NA NA
3 NA <NA> <NA> NA NA NA
4 2013 9 30 113 1 0
5 2013 3 15 113 1 0
6 NA <NA> <NA> NA NA NA
7 2021 1 19 117 1 0
description.x pap_majortopic
1 Adjustments of Certain Rates of Pay 2
2 <NA> NA
3 <NA> NA
4 Continuance of Certain Federal Advisory Committees 2
5 Amendments to Executive Order 12777 7
6 <NA> NA
7 Care of Veterans With Service in Uzbekistan 16
pap_subtopic majortopic subtopic majortopic_title subtopic_title
1 2004 2 2004 <NA> <NA>
2 NA NA NA <NA> <NA>
3 NA NA NA <NA> <NA>
4 2011 2 2011 <NA> <NA>
5 710 7 710 <NA> <NA>
6 NA NA NA <NA> <NA>
7 1609 16 1609 <NA> <NA>
description.y cap_notes racial
1 <NA> <NA> <NA>
2 <NA> <NA> <NA>
3 <NA> <NA> <NA>
4 <NA> <NA> <NA>
5 <NA> <NA> <NA>
6 <NA> <NA> <NA>
7 <NA> <NA> <NA>