SocrataOpenDataAnalysis

Algorithmia Platform License · Internet Access

This algorithm has Internet access.

This is necessary for algorithms that rely on external services, however it also implies that this algorithm is able to send your input data outside of the Algorithmia platform.
· Calls Other Algorithms

This algorithm has permission to call other algorithms.

This allows an algorithm to compose sophisticated functionality using other algorithms as building blocks, however it also carries the potential of incurring additional royalty and usage costs from any algorithm that it calls.

Run an Example

{
  "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