SocrataOpenDataAnalysis

Algorithmia Platform License · Internet Access · Calls Other Algorithms

Try the API

{
  "querySettings": {
    "domain": "open.whitehouse.gov",
    "datasetFourByFour": "rcp4-3y7g",
    "queryString": "select * order by salary desc limit 100"
  },
  "queryResults": [
    {
      "employee_name": "Hash, Michael M.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY DIRECTOR",
      "employee_status": "Detailee",
      "salary": "179700.00"
    },
    {
      "employee_name": "Love, Timothy P.",
      "pay_basis": "Per Annum",
      "position_title": "POLICY DIRECTOR",
      "employee_status": "Detailee",
      "salary": "179700.00"
    },
    {
      "employee_name": "Axelrod, David M.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND SENIOR ADVISOR",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Barnes, Melody C.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DIRECTOR OF THE DOMESTIC POLICY COUNCIL",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Bauer, Robert F.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Brennan, John O.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT FOR HOMELAND SECURITY AND COUNTERTERRORISM",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Brown, Elizabeth M.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND STAFF SECRETARY",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Browner, Carol M.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT FOR ENERGY AND CLIMATE CHANGE",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Cutter, Stephanie ",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT FOR SPECIAL PROJECTS",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Donilon, Thomas E.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DEPUTY NATIONAL SECURITY ADVISOR",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Emanuel, Rahm I.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND CHIEF OF STAFF",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Favreau, Jonathan E.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DIRECTOR OF SPEECHWRITING",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Gaspard, Patrick H.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DIRECTOR OF POLITICAL AFFAIRS",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Gibbs, Robert L.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND PRESS SECRETARY",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Jarrett, Valerie B.",
      "pay_basis": "Per Annum",
      "position_title": "SENIOR ADVISOR AND ASSISTANT TO THE PRESIDENT FOR INTERGOVERNMENTAL AFFAIRS AND PUBLIC ENGAGEMENT",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Jones, James L.",
      "pay_basis": "Per Annum",
      "position_title": "NATIONAL SECURITY ADVISOR",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Lu, Christopher P.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND CABINET SECRETARY",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Mastromonaco, Alyssa M.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DIRECTOR OF SCHEDULING AND ADVANCE",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Messina, James A.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DEPUTY CHIEF OF STAFF FOR OPERATIONS",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Pfeiffer, Howard D.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DIRECTOR OF COMMUNICATIONS",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Rouse, Peter M.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND SENIOR ADVISOR",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Schiliro, Philip M.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DIRECTOR, OFFICE OF LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Sher, Susan S.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT, CHIEF OF STAFF TO THE FIRST LADY AND COUNSEL",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Summers, Lawrence H.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT FOR ECONOMIC POLICY AND DIRECTOR OF THE NATIONAL ECONOMIC COUNCIL",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Sutphen, Mona K.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT AND DEPUTY CHIEF OF STAFF FOR POLICY",
      "employee_status": "Employee",
      "salary": "172200.00"
    },
    {
      "employee_name": "Weiser, Philip J.",
      "pay_basis": "Per Annum",
      "position_title": "SENIOR ADVISOR FOR TECHNOLOGY AND INNOVATION TO THE NATIONAL ECONOMIC COUNCIL DIRECTOR",
      "employee_status": "Detailee",
      "salary": "172000.00"
    },
    {
      "employee_name": "Massey, Katherine",
      "pay_basis": "Per Annum",
      "position_title": "SENIOR POLICY DIRECTOR",
      "employee_status": "Detailee",
      "salary": "165000.00"
    },
    {
      "employee_name": "Kiley, Bradley J.",
      "pay_basis": "Per Annum",
      "position_title": "ASSISTANT TO THE PRESIDENT FOR MANAGEMENT AND ADMINISTRATION",
      "employee_status": "Employee",
      "salary": "162900.00"
    },
    {
      "employee_name": "Nabors, Robert L.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND SENIOR ADVISOR TO THE CHIEF OF STAFF",
      "employee_status": "Employee",
      "salary": "162500.00"
    },
    {
      "employee_name": "Davies, Susan M.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "DeParle, Nancy-Ann Min",
      "pay_basis": "Per Annum",
      "position_title": "COUNSELOR TO THE PRESIDENT AND DIRECTOR OF THE WHITE HOUSE OFFICE FOR HEALTH CARE REFORM",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "DeRosa, Mary B.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Konwinski, Lisa M.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Maher, Shawn P.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS AND SENATE LIAISION",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Ruemmler, Kathryn H.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Rundlet, Peter F.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY STAFF SECRETARY",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Turton, Daniel A.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS AND HOUSE LIAISON",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Verrilli, Donald B.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "158500.00"
    },
    {
      "employee_name": "Edwards, Lisa W.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSOCIATE COUNSEL FOR PRESIDENTIAL PERSONNEL",
      "employee_status": "Detailee",
      "salary": "155500.00"
    },
    {
      "employee_name": "Kramer, Douglas J.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSOCIATE COUNSEL FOR PRESIDENTIAL PERSONNEL",
      "employee_status": "Detailee",
      "salary": "155500.00"
    },
    {
      "employee_name": "McCarthy, Mary N.",
      "pay_basis": "Per Annum",
      "position_title": "POLICY ADVISOR",
      "employee_status": "Detailee",
      "salary": "155500.00"
    },
    {
      "employee_name": "Odintz, Joshua D.",
      "pay_basis": "Per Annum",
      "position_title": "CHIEF TAX COUNSEL",
      "employee_status": "Detailee",
      "salary": "155500.00"
    },
    {
      "employee_name": "Saunders, George T.",
      "pay_basis": "Per Annum",
      "position_title": "EXECUTIVE CLERK",
      "employee_status": "Employee",
      "salary": "155500.00"
    },
    {
      "employee_name": "Mu��oz, Cecilia",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF INTERGOVERNMENTAL AFFAIRS",
      "employee_status": "Employee",
      "salary": "153500.00"
    },
    {
      "employee_name": "Tchen, Christina M.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF THE OFFICE OF PUBLIC ENGAGEMENT",
      "employee_status": "Employee",
      "salary": "153500.00"
    },
    {
      "employee_name": "De Sio, Jr., Henry F.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT FOR MANAGEMENT AND ADMINISTRATION",
      "employee_status": "Employee",
      "salary": "153300.00"
    },
    {
      "employee_name": "Higginbottom, Heather A.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY DIRECTOR OF THE DOMESTIC POLICY COUNCIL",
      "employee_status": "Employee",
      "salary": "150000.00"
    },
    {
      "employee_name": "Psaki, Jennifer R.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY DIRECTOR OF COMMUNICATIONS",
      "employee_status": "Employee",
      "salary": "150000.00"
    },
    {
      "employee_name": "Smoot, Julianna S.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND WHITE HOUSE SOCIAL SECRETARY",
      "employee_status": "Employee",
      "salary": "150000.00"
    },
    {
      "employee_name": "Eisen, Norman L.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND SPECIAL COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "149000.00"
    },
    {
      "employee_name": "Lipton, David A.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR INTERNATIONAL ECONOMIC AFFAIRS",
      "employee_status": "Employee",
      "salary": "149000.00"
    },
    {
      "employee_name": "Bressler, Steven Y.",
      "pay_basis": "Per Annum",
      "position_title": "CLEARANCE ADVISOR",
      "employee_status": "Detailee",
      "salary": "148510.00"
    },
    {
      "employee_name": "Dalheim, Karen L.",
      "pay_basis": "Per Annum",
      "position_title": "ETHICS ADVISOR",
      "employee_status": "Detailee",
      "salary": "148510.00"
    },
    {
      "employee_name": "Farrell, Diana",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT FOR ECONOMIC POLICY",
      "employee_status": "Employee",
      "salary": "147500.00"
    },
    {
      "employee_name": "Furman, Jason L.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT  FOR ECONOMIC POLICY",
      "employee_status": "Employee",
      "salary": "147500.00"
    },
    {
      "employee_name": "Lippert, Mark W.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND CHIEF OF STAFF FOR NATIONAL SECURITY OPERATIONS",
      "employee_status": "Employee",
      "salary": "147500.00"
    },
    {
      "employee_name": "McDonough, Denis R.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND NATIONAL SECURITY COUNCIL CHIEF OF STAFF",
      "employee_status": "Employee",
      "salary": "147500.00"
    },
    {
      "employee_name": "Hogan, Nancy D.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF PRESIDENTIAL PERSONNEL",
      "employee_status": "Employee",
      "salary": "145000.00"
    },
    {
      "employee_name": "Rittner, Kathleen A.",
      "pay_basis": "Per Annum",
      "position_title": "ETHICS ADVISOR",
      "employee_status": "Detailee",
      "salary": "144868.00"
    },
    {
      "employee_name": "Droege, Philip C.",
      "pay_basis": "Per Annum",
      "position_title": "DIRECTOR OF RECORDS MANAGEMENT",
      "employee_status": "Employee",
      "salary": "140259.00"
    },
    {
      "employee_name": "Camu��ez, Michael C.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND SPECIAL COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "140000.00"
    },
    {
      "employee_name": "Frye, Jocelyn C.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF POLICY AND PROJECTS FOR THE FIRST LADY",
      "employee_status": "Employee",
      "salary": "140000.00"
    },
    {
      "employee_name": "Strautmanis, Michael A.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND CHIEF OF STAFF OF THE OFFICE OF INTERGOVERNMENTAL AFFAIRS AND PUBLIC ENGAGEMENT",
      "employee_status": "Employee",
      "salary": "139500.00"
    },
    {
      "employee_name": "Gottry, Heather C.",
      "pay_basis": "Per Annum",
      "position_title": "ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Detailee",
      "salary": "136134.00"
    },
    {
      "employee_name": "Vale, Elizabeth A.",
      "pay_basis": "Per Annum",
      "position_title": "WHITE HOUSE BUSINESS LIAISON",
      "employee_status": "Detailee",
      "salary": "132009.00"
    },
    {
      "employee_name": "Aldy, Jr., Joseph E.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR ENERGY AND ENVIRONMENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Andrias, Kate E.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Beinart, Diana H.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Burman, Kendall C.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Deese, Brian C.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR ECONOMIC POLICY",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Espinel, Zulima L.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Goodman, Mary B.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR FINANCIAL MARKETS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Gray, Danielle C.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Harris, Kimberley D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Heimbach, James T.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Kale, Katy A.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND DIRECTOR OF WHITE HOUSE OPERATIONS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Kang, Christopher D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Kennedy, Sean D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Kocher, Robert P.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR HEALTHCARE AND ECONOMIC POLICY",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Krass, Caroline D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND SPECIAL COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Kravis, Jonathan I.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Levine, Marne L.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR ECONOMIC POLICY AND CHIEF OF STAFF OF THE NATIONAL ECONOMIC COUNCIL",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Nathan, Alison J.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Papa, Gregory J.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Perez, Alejandro",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Samuels, Jonathan D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Shaw, Katherine",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND ASSOCIATE COUNSEL TO THE PRESIDENT",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Singiser, Dana E.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Stoneman, Shelly O.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Swire, Peter P.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR ECONOMIC POLICY",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Terrell, Louisa M.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Wilson, Denise R.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT FOR LEGISLATIVE AFFAIRS",
      "employee_status": "Employee",
      "salary": "130500.00"
    },
    {
      "employee_name": "Beliveau, Emmett S.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF ADVANCE AND OPERATIONS",
      "employee_status": "Employee",
      "salary": "130000.00"
    },
    {
      "employee_name": "Crutchfield, Danielle M.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DIRECTOR OF APPOINTMENTS AND SCHEDULING",
      "employee_status": "Employee",
      "salary": "130000.00"
    },
    {
      "employee_name": "McBride, Jonathan D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND DEPUTY DIRECTOR OF PRESIDENTIAL PERSONNEL",
      "employee_status": "Employee",
      "salary": "130000.00"
    },
    {
      "employee_name": "Nicholson, Jr., Marvin D.",
      "pay_basis": "Per Annum",
      "position_title": "SPECIAL ASSISTANT TO THE PRESIDENT AND TRIP DIRECTOR",
      "employee_status": "Employee",
      "salary": "130000.00"
    },
    {
      "employee_name": "Smith, Elizabeth S.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY ASSISTANT TO THE PRESIDENT AND DEPUTY CABINET SECRETARY",
      "employee_status": "Employee",
      "salary": "130000.00"
    },
    {
      "employee_name": "Utech, Daniel G.",
      "pay_basis": "Per Annum",
      "position_title": "ADVISOR",
      "employee_status": "Detailee",
      "salary": "130000.00"
    },
    {
      "employee_name": "Kalbaugh, David E.",
      "pay_basis": "Per Annum",
      "position_title": "DEPUTY EXECUTIVE CLERK",
      "employee_status": "Employee",
      "salary": "129758.00"
    },
    {
      "employee_name": "Fernkas, Robin E.",
      "pay_basis": "Per Annum",
      "position_title": "POLICY ADVISOR",
      "employee_status": "Detailee",
      "salary": "126251.00"
    }
  ],
  "numericColumns": [
    {
      "position": 3,
      "id": 134381418,
      "width": 142,
      "name": "Salary",
      "fieldName": "salary",
      "description": "The salary paid per period",
      "dataTypeName": "money",
      "renderTypeName": "money",
      "format": {},
      "fieldValues": [
        179700,
        179700,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172200,
        172000,
        165000,
        162900,
        162500,
        158500,
        158500,
        158500,
        158500,
        158500,
        158500,
        158500,
        158500,
        158500,
        155500,
        155500,
        155500,
        155500,
        155500,
        153500,
        153500,
        153300,
        150000,
        150000,
        150000,
        149000,
        149000,
        148510,
        148510,
        147500,
        147500,
        147500,
        147500,
        145000,
        144868,
        140259,
        140000,
        140000,
        139500,
        136134,
        132009,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130500,
        130000,
        130000,
        130000,
        130000,
        130000,
        130000,
        129758,
        126251
      ],
      "someStats": {
        "min": 126251,
        "median": 149000,
        "max": 179700,
        "variance": 298945449.3635357,
        "mean": 149589.99000000005,
        "sum": 14958999,
        "n": 100,
        "standardDeviation": 17290.039021457866
      }
    }
  ]
}

Install & Use

Use

curl -X POST -d '["open.whitehouse.gov","rcp4-3y7g","select * order by salary desc limit 100"]' -H 'Content-Type: application/json' -H 'Authorization: Simple YOUR_API_KEY' https://api.algorithmia.com/v1/algo/marksskram/SocrataOpenDataAnalysis/0.1.6
  
Curl Docs →