SmartSurvey API.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "from pandas import DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "survey_id = '286725'\n",
    "\n",
    "url1 = 'https://api.smartsurvey.io/v1/surveys/%s' % survey_id\n",
    "url2 = 'https://api.smartsurvey.io/v1/surveys/%s/responses' % survey_id\n",
    "\n",
    "params = {\n",
    "  'api_token':'5xgPHR5ZTyaBXYJDkLfoOEIhaArCkBOM',\n",
    "  'api_token_secret':'2JprHhwQVGTSNqn',\n",
    "  'include_labels': 'true'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "r1 = requests.get(url1,params=params)  # High Level Survey Data\n",
    "r2 = requests.get(url2,params=params)  # Low Level Survey Responses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "survey = r1.json()\n",
    "responses = r2.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102896,\n",
       "  'date_ended': '2017-02-08T08:30:00Z',\n",
       "  'date_modified': '2017-02-08T08:30:00Z',\n",
       "  'date_started': '2017-02-08T08:25:14Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52173823&edit=4qVrse370VTIynFJeofWgEsFCz22pchOQ51vO8ZtL8xog',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52173823',\n",
       "  'id': 52173823,\n",
       "  'ip_address': '79.79.254.176',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518128124,\n",
       "        'type': 'text',\n",
       "        'value': 'Sue Thompson'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518128125,\n",
       "        'type': 'text',\n",
       "        'value': 'thompsonsue@ymail.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282123,\n",
       "        'choice_title': 'Stansted',\n",
       "        'id': 518128127,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518128126,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283213,\n",
       "        'choice_title': 'No',\n",
       "        'id': 518128250,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283153,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518128292,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1102896,\n",
       "    'position': 11,\n",
       "    'questions': [{'answers': [{'choice_id': 37460681,\n",
       "        'choice_title': 'Comments:',\n",
       "        'id': 518129195,\n",
       "        'type': 'comment',\n",
       "        'value': 'i live under the present flight path and am kept awake or woken up by it, after a while lack of sleep catches up and can have a very bad and even dangerous effect upon me.'}],\n",
       "      'id': 4497534,\n",
       "      'number': 36,\n",
       "      'position': 8,\n",
       "      'title': 'What evidence do you have on the optimal reduction in noise quota limits that should be applied at each airport to achieve the environmental objective (section 12)?',\n",
       "      'type': 'file_upload'},\n",
       "     {'answers': [{'choice_id': 37436333,\n",
       "        'choice_title': 'Comments:',\n",
       "        'id': 518129194,\n",
       "        'type': 'comment',\n",
       "        'value': 'The villagers are all affected and complaining about the interference on our lives by the aircraft noise and fumes.'}],\n",
       "      'id': 4474756,\n",
       "      'number': 37,\n",
       "      'position': 9,\n",
       "      'title': 'What other evidence do you have that could improve the analysis in this impact assessment?',\n",
       "      'type': 'file_upload'}],\n",
       "    'title': 'Impact assessment (IA)'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102916,\n",
       "  'date_ended': '2017-02-08T08:10:41Z',\n",
       "  'date_modified': '2017-02-08T08:10:41Z',\n",
       "  'date_started': '2017-02-08T07:42:42Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52172670&edit=J8TUS6tZEOdqlEtNzTe3slhGE7ksdQeXP5VszT2ZIAMOB',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52172670',\n",
       "  'id': 52172670,\n",
       "  'ip_address': '82.132.245.125',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518118924,\n",
       "        'type': 'text',\n",
       "        'value': 'Clare Hillman'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518118925,\n",
       "        'type': 'text',\n",
       "        'value': 'Clarehillman@gmail.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518118927,\n",
       "        'type': 'checkbox'},\n",
       "       {'choice_id': 37282122,\n",
       "        'choice_title': 'Gatwick',\n",
       "        'id': 518118928,\n",
       "        'type': 'checkbox'},\n",
       "       {'choice_id': 37282123,\n",
       "        'choice_title': 'Stansted',\n",
       "        'id': 518118929,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518118926,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518119072,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894450,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518121109,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895376,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518121110,\n",
       "        'type': 'text',\n",
       "        'value': \"Unfortunately I dot have time to read the full document - a summary would make it more accessible for the public to have a say. But in principle airports are not environmentally friendly in any way - so no environmental policy could involve expanding it, or increasingy night flights and noise levels! The residents of west London already suffer massive noise and pollution and are now being told that we are irrelevant in the discussion about making much much more of both through both the planes and the traffic it generates. And in a horrible ironic twist, the latest excuse for this is Brexit, which the vast majority of us don't want anyway! Why don't you put your 'open Britain' airport where it is needed by those who want this. why should I be kept awake at night to try to save this country from a man made disaster?!\"}],\n",
       "      'id': 4415974,\n",
       "      'number': 9,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposed environmental objective for the next regime.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882707,\n",
       "        'choice_title': '3 - Neither agree or disagree',\n",
       "        'id': 518121256,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895134,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518121257,\n",
       "        'type': 'text',\n",
       "        'value': \"You don't say how long that is!\"}],\n",
       "      'id': 4415992,\n",
       "      'number': 11,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for the length of the regime.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895148,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518121874,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895155,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518121875,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895170,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518121876,\n",
       "        'type': 'text',\n",
       "        'value': 'A few lines to explain this would help people give better answers'}],\n",
       "      'id': 4416059,\n",
       "      'number': 14,\n",
       "      'position': 3,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposals for the quota count system.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883750,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518124086,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895503,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518124087,\n",
       "        'type': 'text',\n",
       "        'value': \"Reduce them further - they fly until midnight and start again before 6 and The planes going over us are huge. How about change the flight paths too, so they don't fly straight over rows of houses? there is a river and a group of reservoirs behind us. Why don't you fly your great pollution machines over those?\"}],\n",
       "      'id': 4416068,\n",
       "      'number': 16,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Heathrow’s movement limit.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36883874,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518124088,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895515,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518124089,\n",
       "        'type': 'text',\n",
       "        'value': \"Assuming they are the same as Heathrow then restrict them too, unless you can find flight paths that don't disturb people. There is more space there of course\"}],\n",
       "      'id': 4416089,\n",
       "      'number': 18,\n",
       "      'position': 4,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Gatwick’s movement limit.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36884057,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518124090,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895526,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518124091,\n",
       "        'type': 'text',\n",
       "        'value': 'If by raise you mean make longer then absolutely not. These planes are not quiet or or safe.'}],\n",
       "      'id': 4416095,\n",
       "      'number': 20,\n",
       "      'position': 6,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Stansted’s movement limit.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885025,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518124256,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895196,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518124257,\n",
       "        'type': 'text',\n",
       "        'value': 'Ban the noisy ones alrogether'}],\n",
       "      'id': 4416257,\n",
       "      'number': 22,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36885069,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518124258,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885144,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518124259,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283154,\n",
       "        'choice_title': 'No',\n",
       "        'id': 518124397,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.4.6 (KHTML, like Gecko) Version/10.0 Mobile/14D27 Safari/602.1'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102896,\n",
       "  'date_ended': '2017-02-08T03:16:45Z',\n",
       "  'date_modified': '2017-02-08T03:16:45Z',\n",
       "  'date_started': '2017-02-08T03:10:16Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52169255&edit=QwuF2s1C3FoW7RQvAdvjcrI2kV4XX8fGV3eyTKaWPRQmF',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52169255',\n",
       "  'id': 52169255,\n",
       "  'ip_address': '92.234.117.156',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518098179,\n",
       "        'type': 'text',\n",
       "        'value': 'Lucy'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518098180,\n",
       "        'type': 'text',\n",
       "        'value': 'lucysomner69@hotmail.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518098182,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518098181,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518098183,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894449,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518098199,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882708,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518098201,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895149,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518098203,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895156,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518098204,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883749,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518098302,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895503,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518098303,\n",
       "        'type': 'text',\n",
       "        'value': 'It is too noisy also in the day the planes fly too low so disrupt by causing noise and also TV ariel problems.'}],\n",
       "      'id': 4416068,\n",
       "      'number': 16,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Heathrow’s movement limit.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36883872,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518098304,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884055,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518098305,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885027,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518098332,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885071,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518098333,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885146,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518098334,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1090049,\n",
       "    'position': 9,\n",
       "    'questions': [{'answers': [{'choice_id': 37298518,\n",
       "        'choice_title': 'Comments:',\n",
       "        'id': 518098355,\n",
       "        'type': 'comment',\n",
       "        'value': 'Reduce noise and reduce low flying during the day.'}],\n",
       "      'id': 4416407,\n",
       "      'number': 27,\n",
       "      'position': 1,\n",
       "      'title': \"Add any further views on our proposals, or their potential impact on government's ability to fulfil the requirements of the public sector equality duty (note commercially sensitive information must be emailed to night.flights@dft.gsi.gov.uk only).\",\n",
       "      'type': 'file_upload'}],\n",
       "    'title': 'Additional comments'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283153,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518098357,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 7_1_2 like Mac OS X) AppleWebKit/537.51.2 (KHTML, like Gecko) Version/7.0 Mobile/11D257 Safari/9537.53'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '210',\n",
       "  'current_page_id': 1102896,\n",
       "  'date_ended': '2017-02-07T23:04:15Z',\n",
       "  'date_modified': '2017-02-07T23:04:15Z',\n",
       "  'date_started': '2017-02-07T22:59:27Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52166043&edit=DkxjbKZeOOtWZ1fiD3e4eeTRERGqEOOFpXcUR1yRwvRIt',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52166043',\n",
       "  'id': 52166043,\n",
       "  'ip_address': '143.159.174.38',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518077899,\n",
       "        'type': 'text',\n",
       "        'value': 'Olga Rego'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518077900,\n",
       "        'type': 'text',\n",
       "        'value': 'Olgargego@aol.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518077902,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518077901,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518077903,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894446,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518077957,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882705,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078045,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895146,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078145,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895153,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078146,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883746,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078201,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36883870,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078202,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884053,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078203,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885025,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078253,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885069,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078254,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885144,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518078255,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283153,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518078373,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.4.6 (KHTML, like Gecko) Mobile/14D27 [FBAN/FBIOS;FBAV/78.0.0.40.70;FBBV/48784289;FBRV/0;FBDV/iPhone7,2;FBMD/iPhone;FBSN/iOS;FBSV/10.2.1;FBSS/2;FBCR/O2;FBID/phone;FBLC/en_GB;FBOP/5]'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102916,\n",
       "  'date_ended': '2017-02-07T22:59:09Z',\n",
       "  'date_modified': '2017-02-07T22:59:09Z',\n",
       "  'date_started': '2017-02-07T22:39:10Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52165505&edit=O58fx78YiFiSRXAGVKmCtKdUOohmR8uGWBO04aCZDvgOB',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52165505',\n",
       "  'id': 52165505,\n",
       "  'ip_address': '94.7.16.124',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518073483,\n",
       "        'type': 'text',\n",
       "        'value': 'Julian West'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518073484,\n",
       "        'type': 'text',\n",
       "        'value': 'Julian.west@hotmail.co.uk'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518073486,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518073485,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518073513,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894450,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518074562,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895376,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518074563,\n",
       "        'type': 'text',\n",
       "        'value': 'I do not see how the environmental issues have been honestly reported. It is well documented that new planes are per kg more environmentally friendly however they require more power which equals a net increase in noise. In addition there will be major issues in the increase of airline traffic in an already congested area. This is without taking into consideration the rrmassive increase in traffic to a hugely congested region.'}],\n",
       "      'id': 4415974,\n",
       "      'number': 9,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposed environmental objective for the next regime.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882709,\n",
       "        'choice_title': '5 - Strongly disgree',\n",
       "        'id': 518075351,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895134,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518075352,\n",
       "        'type': 'text',\n",
       "        'value': \"The length of time suggested is almost immaterial. Flights will happen outside of these regimes. Allowing for less than 7 hours is ridiculous. Consider schools, shift workers, home workers, how do you think it is now? The noise of a plane going over results in having to pause a conversation. More noise in the Heathrow area just doesn't make sense.\"}],\n",
       "      'id': 4415992,\n",
       "      'number': 11,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for the length of the regime.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895148,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518076571,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895155,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518076572,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895170,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518076573,\n",
       "        'type': 'text',\n",
       "        'value': \"I'm completely opposed to the Heathrow expansion the impact to 100,000s of people is just inhuman. The current government was elected on the pledge that Heathrow would not be expanded. So what has happened. Why has this changed? Does anyone care that people are looking to move their family, remove their children from local schools.\"}],\n",
       "      'id': 4416059,\n",
       "      'number': 14,\n",
       "      'position': 3,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposals for the quota count system.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883750,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518077206,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895503,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518077207,\n",
       "        'type': 'text',\n",
       "        'value': 'Why should there be any more traffic to such a busy airport in an area that is heavily congested. One additional runway will not be enough. So why expand in this area when there is no scope to further extend. Anyone that knows anything about this area (speak to current or previous Mayor) they will tell you it makes no sense to extend this site.'}],\n",
       "      'id': 4416068,\n",
       "      'number': 16,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Heathrow’s movement limit.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36883872,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518077208,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884055,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518077209,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885025,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518077459,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895196,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518077460,\n",
       "        'type': 'text',\n",
       "        'value': 'This should happen anyway. However most new planes are larger and require more power. Just no more planes please.'}],\n",
       "      'id': 4416257,\n",
       "      'number': 22,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36885071,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518077461,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885146,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518077462,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1090049,\n",
       "    'position': 9,\n",
       "    'questions': [{'answers': [{'choice_id': 37298518,\n",
       "        'choice_title': 'Comments:',\n",
       "        'id': 518077718,\n",
       "        'type': 'comment',\n",
       "        'value': 'Why would anyone look to punish this area more than it is already. Please work to another solution that provides a long term solution.'}],\n",
       "      'id': 4416407,\n",
       "      'number': 27,\n",
       "      'position': 1,\n",
       "      'title': \"Add any further views on our proposals, or their potential impact on government's ability to fulfil the requirements of the public sector equality duty (note commercially sensitive information must be emailed to night.flights@dft.gsi.gov.uk only).\",\n",
       "      'type': 'file_upload'}],\n",
       "    'title': 'Additional comments'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283154,\n",
       "        'choice_title': 'No',\n",
       "        'id': 518077833,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Mobile/13G36 Twitter for iPhone'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102896,\n",
       "  'date_ended': '2017-02-07T21:52:12Z',\n",
       "  'date_modified': '2017-02-07T21:52:12Z',\n",
       "  'date_started': '2017-02-07T21:41:29Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52163805&edit=O48DJuEykSTqtM7ZYMdfYTEV5fJDwsqNT7yTnXdNlf4It',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52163805',\n",
       "  'id': 52163805,\n",
       "  'ip_address': '86.162.247.12',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518060756,\n",
       "        'type': 'text',\n",
       "        'value': 'Valerie Cumming Newell'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518060757,\n",
       "        'type': 'text',\n",
       "        'value': 'valerie@vcumming.clara.co.uk'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282123,\n",
       "        'choice_title': 'Stansted',\n",
       "        'id': 518060759,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518060758,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518060782,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894450,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518061417,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895376,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518061418,\n",
       "        'type': 'text',\n",
       "        'value': '•\\tthere should be an objective to phase out all night flights at Stansted by 2030, except in the case of genuine emergencies;\\r\\n•\\tthe limit on night flights should be from 11.00pm to 7.00am, so that the airport only operates within the definition of ‘night’ as specified by the World Health Organisation (WHO)’s Guidelines on Community Noise;\\r\\n•\\tthere should be a complete review / change to the current ‘averaging’ method for measuring aircraft noise so that the  official Government noise statistics start to represent what residents actually have to endure.'}],\n",
       "      'id': 4415974,\n",
       "      'number': 9,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposed environmental objective for the next regime.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882707,\n",
       "        'choice_title': '3 - Neither agree or disagree',\n",
       "        'id': 518061548,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895148,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518062405,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895155,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518062406,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895170,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518062407,\n",
       "        'type': 'text',\n",
       "        'value': 'Have on idea what this question means - it is deliberately phrased to prevent lay people (ie residents!) being able to comment and take a stance! Your wording precludes people from participating in the consultation process is therefore undemocratic, lacks transparency and is biased against residents.'}],\n",
       "      'id': 4416059,\n",
       "      'number': 14,\n",
       "      'position': 3,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposals for the quota count system.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883748,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518062669,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36883872,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518062670,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884057,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518062671,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895526,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518062672,\n",
       "        'type': 'text',\n",
       "        'value': 'The night flights proposals do not go nearly far enough to tackle the very serious impacts of night flights in terms of sleep disturbance for local residents around Stansted and under its flight paths. It becoming hellish!'}],\n",
       "      'id': 4416095,\n",
       "      'number': 20,\n",
       "      'position': 6,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Stansted’s movement limit.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885025,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518062752,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885069,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518062753,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885144,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518062754,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1090049,\n",
       "    'position': 9,\n",
       "    'questions': [{'answers': [{'choice_id': 37298518,\n",
       "        'choice_title': 'Comments:',\n",
       "        'id': 518063034,\n",
       "        'type': 'comment',\n",
       "        'value': 'As previously stated, the wording of some of your questions seem deliberately designed to prevent some people (ie residents with no technical knowledge of aircraft) from participating in this consultation process.'}],\n",
       "      'id': 4416407,\n",
       "      'number': 27,\n",
       "      'position': 1,\n",
       "      'title': \"Add any further views on our proposals, or their potential impact on government's ability to fulfil the requirements of the public sector equality duty (note commercially sensitive information must be emailed to night.flights@dft.gsi.gov.uk only).\",\n",
       "      'type': 'file_upload'}],\n",
       "    'title': 'Additional comments'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283153,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518063047,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1102896,\n",
       "    'position': 11,\n",
       "    'questions': [{'answers': [{'choice_id': 37436119,\n",
       "        'choice_title': 'Comments:',\n",
       "        'id': 518063579,\n",
       "        'type': 'comment',\n",
       "        'value': 'The whole process and documentation is deliberately over-complex and designed to prevent non-specialists from participating in the process. Therefore, the very people who are most affected (the residents) are the most excluded from the process.'}],\n",
       "      'id': 4474717,\n",
       "      'number': 32,\n",
       "      'position': 4,\n",
       "      'title': 'What evidence do you have on the amount of time needed for stakeholders to read and understand the regulations needed to implement our proposals (section 8.2.2)?',\n",
       "      'type': 'file_upload'}],\n",
       "    'title': 'Impact assessment (IA)'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102916,\n",
       "  'date_ended': '2017-02-07T21:33:08Z',\n",
       "  'date_modified': '2017-02-07T21:33:08Z',\n",
       "  'date_started': '2017-02-07T21:17:13Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52162881&edit=lAOehj7t0cOcOZk0nvbq23NygCjxED7ONDPPOmOwlto6a',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52162881',\n",
       "  'id': 52162881,\n",
       "  'ip_address': '213.212.80.106',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518053975,\n",
       "        'type': 'text',\n",
       "        'value': 'Julius Malewicz'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518053976,\n",
       "        'type': 'text',\n",
       "        'value': 'julius_451@hotmail.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518053978,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518053977,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518054001,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894450,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518054814,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895376,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518054815,\n",
       "        'type': 'text',\n",
       "        'value': 'Do you want to grow a city of angry sleep deprived men and women or not. Sleep is important.'}],\n",
       "      'id': 4415974,\n",
       "      'number': 9,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposed environmental objective for the next regime.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882708,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518055883,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895150,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518056313,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895154,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518056314,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895170,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518056315,\n",
       "        'type': 'text',\n",
       "        'value': 'These questions appear deliberately confusing.'}],\n",
       "      'id': 4416059,\n",
       "      'number': 14,\n",
       "      'position': 3,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposals for the quota count system.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883747,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518056924,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36883871,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518056925,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884054,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518056926,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885029,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518058287,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895196,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518058288,\n",
       "        'type': 'text',\n",
       "        'value': 'The prime mover when considering aircraft should always be safety. Quieter aircraft are not needed if there are less flights over London at night.'}],\n",
       "      'id': 4416257,\n",
       "      'number': 22,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36885073,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518058289,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895216,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518058290,\n",
       "        'type': 'text',\n",
       "        'value': 'The prime mover when considering aircraft should always be safety. Quieter aircraft are not needed if there are less flights over London at night.'}],\n",
       "      'id': 4416259,\n",
       "      'number': 24,\n",
       "      'position': 4,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on how noise quotas can best be set in order to encourage the use of quieter aircraft at Gatwick.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36885148,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518058291,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895215,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518058292,\n",
       "        'type': 'text',\n",
       "        'value': 'The prime mover when considering aircraft should always be safety. Quieter aircraft are not needed if there are less flights over London at night.'}],\n",
       "      'id': 4416262,\n",
       "      'number': 26,\n",
       "      'position': 6,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on how noise quotas can best be set in order to encourage the use of quieter aircraft at Stansted.',\n",
       "      'type': 'open_ended'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283154,\n",
       "        'choice_title': 'No',\n",
       "        'id': 518058504,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102916,\n",
       "  'date_ended': '2017-02-07T21:23:34Z',\n",
       "  'date_modified': '2017-02-07T21:23:34Z',\n",
       "  'date_started': '2017-02-07T21:21:11Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52163054&edit=7cctXUzTaaAKaWvzo4TWy1XT3ssJwbTNraiskn5FkJ15T',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52163054',\n",
       "  'id': 52163054,\n",
       "  'ip_address': '94.174.4.37',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518055215,\n",
       "        'type': 'text',\n",
       "        'value': 'Claire Campbell'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518055216,\n",
       "        'type': 'text',\n",
       "        'value': 'clairejcampbell@live.co.uk'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518055218,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518055217,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518055296,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894447,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518055327,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882707,\n",
       "        'choice_title': '3 - Neither agree or disagree',\n",
       "        'id': 518055358,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895147,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518055452,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895154,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518055453,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883750,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518055574,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895503,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518055575,\n",
       "        'type': 'text',\n",
       "        'value': \"Shouldn't be any flights between 11pm and 6am, at all\"}],\n",
       "      'id': 4416068,\n",
       "      'number': 16,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on our proposal for Heathrow’s movement limit.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36883872,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518055576,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884055,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518055577,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885029,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518055738,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895196,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518055739,\n",
       "        'type': 'text',\n",
       "        'value': \"'Encourage' is not strong enough -should implement with a deadline\"}],\n",
       "      'id': 4416257,\n",
       "      'number': 22,\n",
       "      'position': 2,\n",
       "      'sub_type': 'essay',\n",
       "      'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36885071,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518055740,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885146,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518055741,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283154,\n",
       "        'choice_title': 'No',\n",
       "        'id': 518055788,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/602.4.8 (KHTML, like Gecko) Version/10.0.3 Safari/602.4.8'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102896,\n",
       "  'date_ended': '2017-02-07T20:47:08Z',\n",
       "  'date_modified': '2017-02-07T20:47:08Z',\n",
       "  'date_started': '2017-02-07T20:44:35Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52161612&edit=2cGmCctqcex6pY5l1DMGQ6zXyjTPv0Ub88HuvCMGrM4c5',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52161612',\n",
       "  'id': 52161612,\n",
       "  'ip_address': '92.236.200.115',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518043818,\n",
       "        'type': 'text',\n",
       "        'value': 'Andrew Waite'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518043819,\n",
       "        'type': 'text',\n",
       "        'value': 'Ajaywaite@gmail.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518043821,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518043820,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518043825,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894448,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518043882,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882706,\n",
       "        'choice_title': '2 - Agree',\n",
       "        'id': 518043910,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895149,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518044034,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895156,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518044035,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883750,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518044170,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36883872,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518044171,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884055,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518044172,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885028,\n",
       "        'choice_title': '4 - Disagree',\n",
       "        'id': 518044380,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885071,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518044381,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885146,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518044382,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283153,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518044433,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': '',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_0_2 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) Mobile/14A456 [FBAN/FBIOS;FBAV/68.0.0.49.70;FBBV/41924288;FBRV/0;FBDV/iPhone7,2;FBMD/iPhone;FBSN/iOS;FBSV/10.0.2;FBSS/2;FBCR/EE;FBID/phone;FBLC/en_GB;FBOP/5]'},\n",
       " {'contact_email': '',\n",
       "  'contact_invitation_id': 0,\n",
       "  'contact_name': '',\n",
       "  'country': '208',\n",
       "  'current_page_id': 1102896,\n",
       "  'date_ended': '2017-02-07T19:41:04Z',\n",
       "  'date_modified': '2017-02-07T19:41:04Z',\n",
       "  'date_started': '2017-02-07T19:38:21Z',\n",
       "  'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52158999&edit=CBGvSnkOmOnw5F0ZSOyN86q5uCmlUwUuljxX0v6qxtyyh',\n",
       "  'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/',\n",
       "  'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52158999',\n",
       "  'id': 52158999,\n",
       "  'ip_address': '86.131.216.157',\n",
       "  'manual_entry': False,\n",
       "  'pages': [{'id': 1089799,\n",
       "    'position': 1,\n",
       "    'questions': [{'answers': [{'choice_id': 36871349,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518027042,\n",
       "        'type': 'text',\n",
       "        'value': 'Teresa Wildash'}],\n",
       "      'id': 4415657,\n",
       "      'number': 1,\n",
       "      'position': 1,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Name:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 36871360,\n",
       "        'choice_title': '&nbsp;',\n",
       "        'id': 518027043,\n",
       "        'type': 'text',\n",
       "        'value': 'teresawildash@gmail.com'}],\n",
       "      'id': 4415658,\n",
       "      'number': 2,\n",
       "      'position': 2,\n",
       "      'sub_type': 'single',\n",
       "      'title': 'Email:',\n",
       "      'type': 'open_ended'},\n",
       "     {'answers': [{'choice_id': 37282121,\n",
       "        'choice_title': 'Heathrow',\n",
       "        'id': 518027045,\n",
       "        'type': 'checkbox'}],\n",
       "      'id': 4472942,\n",
       "      'number': 3,\n",
       "      'position': 3,\n",
       "      'sub_type': 'checkbox',\n",
       "      'title': 'Your responses are mainly about (you may select more than one airport)?',\n",
       "      'type': 'multiple_choice'},\n",
       "     {'answers': [{'choice_id': 36887247,\n",
       "        'choice_title': 'an individual?',\n",
       "        'id': 518027044,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415659,\n",
       "      'number': 4,\n",
       "      'position': 4,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Are you responding as:',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Personal details'},\n",
       "   {'id': 1102880,\n",
       "    'position': 3,\n",
       "    'questions': [{'answers': [{'choice_id': 37283212,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518027091,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4472954,\n",
       "      'number': 7,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the consultation document?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'},\n",
       "   {'id': 1089815,\n",
       "    'position': 4,\n",
       "    'questions': [{'answers': [{'choice_id': 36894450,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518027143,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415734,\n",
       "      'number': 8,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Environmental objective'},\n",
       "   {'id': 1089920,\n",
       "    'position': 5,\n",
       "    'questions': [{'answers': [{'choice_id': 36882709,\n",
       "        'choice_title': '5 - Strongly disgree',\n",
       "        'id': 518027177,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4415985,\n",
       "      'number': 10,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Regime length'},\n",
       "   {'id': 1089923,\n",
       "    'position': 6,\n",
       "    'questions': [{'answers': [{'choice_id': 36895150,\n",
       "        'choice_title': '5 - Strongly disagree',\n",
       "        'id': 518027273,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416035,\n",
       "      'number': 12,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36895155,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518027274,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416040,\n",
       "      'number': 13,\n",
       "      'position': 2,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'The quota count system'},\n",
       "   {'id': 1089955,\n",
       "    'position': 7,\n",
       "    'questions': [{'answers': [{'choice_id': 36883746,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518027507,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416062,\n",
       "      'number': 15,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36883870,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518027508,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416073,\n",
       "      'number': 17,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36884055,\n",
       "        'choice_title': '3 - Neither agree nor disagree',\n",
       "        'id': 518027509,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416093,\n",
       "      'number': 19,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Movement limits'},\n",
       "   {'id': 1104385,\n",
       "    'position': 8,\n",
       "    'questions': [{'answers': [{'choice_id': 36885025,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518027592,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416254,\n",
       "      'number': 21,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885069,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518027593,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416258,\n",
       "      'number': 23,\n",
       "      'position': 3,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?',\n",
       "      'type': 'single_choice'},\n",
       "     {'answers': [{'choice_id': 36885144,\n",
       "        'choice_title': '1 - Strongly agree',\n",
       "        'id': 518027594,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4416261,\n",
       "      'number': 25,\n",
       "      'position': 5,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Noise quota limits'},\n",
       "   {'id': 1102916,\n",
       "    'position': 10,\n",
       "    'questions': [{'answers': [{'choice_id': 37283153,\n",
       "        'choice_title': 'Yes',\n",
       "        'id': 518027635,\n",
       "        'type': 'radio'}],\n",
       "      'id': 4473045,\n",
       "      'number': 28,\n",
       "      'position': 1,\n",
       "      'sub_type': 'radio',\n",
       "      'title': 'Do you wish to respond to the impact assessment?',\n",
       "      'type': 'single_choice'}],\n",
       "    'title': 'Response type'}],\n",
       "  'referer_url': 'https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/582863/night-flight-restrictions-at-heathrow-gatwick-and-stansted.pdf',\n",
       "  'saved': False,\n",
       "  'saved_continue_url': '',\n",
       "  'saved_email': '',\n",
       "  'saved_name': '',\n",
       "  'status': 'completed',\n",
       "  'survey_id': 286725,\n",
       "  'tracking_link_id': 308404,\n",
       "  'translation_id': 224421,\n",
       "  'user_agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_1) AppleWebKit/602.2.14 (KHTML, like Gecko) Version/10.0.1 Safari/602.2.14'}]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "responses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 318,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '143.159.188.77', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52142436', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102916, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/', 'saved_continue_url': '', 'date_started': '2017-02-07T14:36:27Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '210', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52142436&edit=EqtzjBVMCLdUeA1aoZqy5ZFsTSSKVfJIUBxijHm4cUvTE', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'David Bateman', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517897126}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Dljbateman@hotmail.com', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517897127}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517897129}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517897128}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517897176}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '4 - Disagree', 'choice_id': 36894449, 'type': 'radio', 'id': 517907110}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'we would like to see an earlier ban on night flights as a step towards the full ban included in the 3rd runway proposal.', 'choice_title': '&nbsp;', 'choice_id': 36895376, 'type': 'text', 'id': 517907111}], 'position': 2, 'number': 9, 'title': 'Any additional comments on our proposed environmental objective for the next regime.', 'id': 4415974}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '4 - Disagree', 'choice_id': 36882708, 'type': 'radio', 'id': 517908039}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'It should be reviewed more regularly to allow for public criticism', 'choice_title': '&nbsp;', 'choice_id': 36895134, 'type': 'text', 'id': 517908040}], 'position': 2, 'number': 11, 'title': 'Any additional comments on our proposal for the length of the regime.', 'id': 4415992}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895146, 'type': 'radio', 'id': 517909733}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895153, 'type': 'radio', 'id': 517909734}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36883746, 'type': 'radio', 'id': 517912192}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36883874, 'type': 'radio', 'id': 517912193}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'I believe Gatwick should be up scaled as it impacts less people', 'choice_title': '&nbsp;', 'choice_id': 36895515, 'type': 'text', 'id': 517912194}], 'position': 4, 'number': 18, 'title': 'Any additional comments on our proposal for Gatwick’s movement limit.', 'id': 4416089}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36884055, 'type': 'radio', 'id': 517912195}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885025, 'type': 'radio', 'id': 517912353}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885069, 'type': 'radio', 'id': 517912354}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885144, 'type': 'radio', 'id': 517912355}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'No', 'choice_id': 37283154, 'type': 'radio', 'id': 517913432}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T15:07:16Z', 'manual_entry': False, 'date_ended': '2017-02-07T15:07:16Z', 'user_agent': 'Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13G36 Safari/601.1', 'saved_name': '', 'referer_url': '', 'id': 52142436}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '86.182.248.72', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52143426', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102896, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6', 'saved_continue_url': '', 'date_started': '2017-02-07T14:50:36Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52143426&edit=wUMArrxZZDYL7xsDyCsN85go4yVauCKwjgv64o443KkhK', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Eur Ing David W Kent', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517904510}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'd.w.kent@homecall.co.uk', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517904511}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Stansted', 'choice_id': 37282123, 'type': 'checkbox', 'id': 517904513}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517904512}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517904747}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36894448, 'type': 'radio', 'id': 517907277}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Sound measurements are not typical of those experienced by an individual in this environment.\\r\\nNight flights should be eliminated completely.', 'choice_title': '&nbsp;', 'choice_id': 36895376, 'type': 'text', 'id': 517907278}], 'position': 2, 'number': 9, 'title': 'Any additional comments on our proposed environmental objective for the next regime.', 'id': 4415974}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '4 - Disagree', 'choice_id': 36882708, 'type': 'radio', 'id': 517907949}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Should be shorter to reflect comment on the disputed imposed new flight paths.', 'choice_title': '&nbsp;', 'choice_id': 36895134, 'type': 'text', 'id': 517907950}], 'position': 2, 'number': 11, 'title': 'Any additional comments on our proposal for the length of the regime.', 'id': 4415992}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '2 - Agree', 'choice_id': 36895147, 'type': 'radio', 'id': 517908533}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '2 - Agree', 'choice_id': 36895154, 'type': 'radio', 'id': 517908534}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Aim should be to stop all night flights', 'choice_title': '&nbsp;', 'choice_id': 36895170, 'type': 'text', 'id': 517908535}], 'position': 3, 'number': 14, 'title': 'Any additional comments on our proposals for the quota count system.', 'id': 4416059}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883748, 'type': 'radio', 'id': 517909893}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883872, 'type': 'radio', 'id': 517909894}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36884057, 'type': 'radio', 'id': 517909895}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'As a rural area the impact of existing flights on sleep intrusion is unacceptable; all should be stopped', 'choice_title': '&nbsp;', 'choice_id': 36895526, 'type': 'text', 'id': 517909896}], 'position': 6, 'number': 20, 'title': 'Any additional comments on our proposal for Stansted’s movement limit.', 'id': 4416095}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885025, 'type': 'radio', 'id': 517910746}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885069, 'type': 'radio', 'id': 517910747}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36885148, 'type': 'radio', 'id': 517910748}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Ban all night flights', 'choice_title': '&nbsp;', 'choice_id': 36895215, 'type': 'text', 'id': 517910749}], 'position': 6, 'number': 26, 'title': 'Any additional comments on how noise quotas can best be set in order to encourage the use of quieter aircraft at Stansted.', 'id': 4416262}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 9, 'questions': [{'type': 'file_upload', 'answers': [{'value': 'Existing night flights disrupt sleep and should be anned', 'choice_title': 'Comments:', 'choice_id': 37298518, 'type': 'comment', 'id': 517911813}], 'id': 4416407, 'number': 27, 'title': \"Add any further views on our proposals, or their potential impact on government's ability to fulfil the requirements of the public sector equality duty (note commercially sensitive information must be emailed to night.flights@dft.gsi.gov.uk only).\", 'position': 1}], 'title': 'Additional comments', 'id': 1090049}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283153, 'type': 'radio', 'id': 517911844}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T15:05:37Z', 'manual_entry': False, 'date_ended': '2017-02-07T15:05:37Z', 'user_agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'saved_name': '', 'referer_url': '', 'id': 52143426}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '143.159.188.77', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52142158', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102916, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6', 'saved_continue_url': '', 'date_started': '2017-02-07T14:32:34Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '210', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52142158&edit=HX7flKszWo8LnVAezWN1QTaLii0OYdZMkEMBSRDswQqxt', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'David Bateman', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517894406}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Dljbateman@hotmail.com', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517894407}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517894409}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517894408}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'No', 'choice_id': 37283213, 'type': 'radio', 'id': 517894577}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'No', 'choice_id': 37283154, 'type': 'radio', 'id': 517894618}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T14:34:14Z', 'manual_entry': False, 'date_ended': '2017-02-07T14:34:14Z', 'user_agent': 'Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13G36 Safari/601.1', 'saved_name': '', 'referer_url': '', 'id': 52142158}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '82.71.26.105', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52141425', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102916, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/', 'saved_continue_url': '', 'date_started': '2017-02-07T14:22:42Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52141425&edit=XCXaIlfcAuv7VMyV1lKJzi1VEbc3Bhm3Eh2fnFpYkcINN', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Nick Harvey', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517888017}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'naharvey@live.co.uk', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517888018}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517888020}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517888019}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'No', 'choice_id': 37283213, 'type': 'radio', 'id': 517888578}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'No', 'choice_id': 37283154, 'type': 'radio', 'id': 517888815}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T14:24:54Z', 'manual_entry': False, 'date_ended': '2017-02-07T14:24:54Z', 'user_agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36', 'saved_name': '', 'referer_url': '', 'id': 52141425}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '195.110.74.198', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52141217', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102896, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/', 'saved_continue_url': '', 'date_started': '2017-02-07T14:19:27Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52141217&edit=SY6ZgS6ozCIBRowaWayZOHPMG3XVhPAaUGp0GdBluP0lW', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Brendan Leddy', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517886428}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Leddybrendan@yahoo.ie', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517886429}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517886431}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517886430}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517886524}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36894450, 'type': 'radio', 'id': 517886615}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disgree', 'choice_id': 36882709, 'type': 'radio', 'id': 517886683}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895146, 'type': 'radio', 'id': 517886861}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895153, 'type': 'radio', 'id': 517886862}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36883746, 'type': 'radio', 'id': 517887071}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883872, 'type': 'radio', 'id': 517887072}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36884055, 'type': 'radio', 'id': 517887073}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885025, 'type': 'radio', 'id': 517887175}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36885071, 'type': 'radio', 'id': 517887176}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36885146, 'type': 'radio', 'id': 517887177}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 9, 'questions': [{'type': 'file_upload', 'answers': [{'value': 'This has confused the hell out of me - I am basically in favour of less flights, no flights at night and quieter planes all round.', 'choice_title': 'Comments:', 'choice_id': 37298518, 'type': 'comment', 'id': 517887697}], 'id': 4416407, 'number': 27, 'title': \"Add any further views on our proposals, or their potential impact on government's ability to fulfil the requirements of the public sector equality duty (note commercially sensitive information must be emailed to night.flights@dft.gsi.gov.uk only).\", 'position': 1}], 'title': 'Additional comments', 'id': 1090049}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283153, 'type': 'radio', 'id': 517887720}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T14:23:13Z', 'manual_entry': False, 'date_ended': '2017-02-07T14:23:13Z', 'user_agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.4.6 (KHTML, like Gecko) Mobile/14D27 [FBAN/FBIOS;FBAV/78.0.0.40.70;FBBV/48784289;FBRV/0;FBDV/iPhone8,2;FBMD/iPhone;FBSN/iOS;FBSV/10.2.1;FBSS/3;FBCR/EE;FBID/phone;FBLC/en_GB;FBOP/5]', 'saved_name': '', 'referer_url': '', 'id': 52141217}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '90.193.239.209', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52138641', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102916, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/', 'saved_continue_url': '', 'date_started': '2017-02-07T13:41:32Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52138641&edit=7ablBJ08KVeKrqPWTuL04XBlrv6MFF66AdxmYGHCkRGtQ', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Jonathan Mills', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517864174}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'jonmills54@gmail.com', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517864175}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517864177}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517864176}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517864248}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '4 - Disagree', 'choice_id': 36894449, 'type': 'radio', 'id': 517865241}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'The objective apperas to be skewed towards the airlines as opposed to local residents', 'choice_title': '&nbsp;', 'choice_id': 36895376, 'type': 'text', 'id': 517865242}], 'position': 2, 'number': 9, 'title': 'Any additional comments on our proposed environmental objective for the next regime.', 'id': 4415974}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disgree', 'choice_id': 36882709, 'type': 'radio', 'id': 517865480}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"It's too long - chnages should be made from October 2017\", 'choice_title': '&nbsp;', 'choice_id': 36895134, 'type': 'text', 'id': 517865481}], 'position': 2, 'number': 11, 'title': 'Any additional comments on our proposal for the length of the regime.', 'id': 4415992}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36895150, 'type': 'radio', 'id': 517866082}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895153, 'type': 'radio', 'id': 517866083}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36883750, 'type': 'radio', 'id': 517867494}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"THe night flight limits are too high and such flights should have been stopped many years ago. The only reason for these flights is the economic interest of airlines. It's 16 flights per night all of which disrupt residents sleep - they can all be rescheduled to the daytime.\", 'choice_title': '&nbsp;', 'choice_id': 36895503, 'type': 'text', 'id': 517867495}], 'position': 2, 'number': 16, 'title': 'Any additional comments on our proposal for Heathrow’s movement limit.', 'id': 4416068}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883872, 'type': 'radio', 'id': 517867496}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36884055, 'type': 'radio', 'id': 517867497}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885025, 'type': 'radio', 'id': 517867772}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885069, 'type': 'radio', 'id': 517867773}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885144, 'type': 'radio', 'id': 517867774}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'No', 'choice_id': 37283154, 'type': 'radio', 'id': 517868664}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T13:48:26Z', 'manual_entry': False, 'date_ended': '2017-02-07T13:48:26Z', 'user_agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0', 'saved_name': '', 'referer_url': 'http://hacan.org.uk/wp-content/uploads/2013/06/Night-Flight-Consultation-2017-HACAN-Briefing-1.pdf', 'id': 52138641}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '86.113.157.29', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52136693', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102896, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/', 'saved_continue_url': '', 'date_started': '2017-02-07T13:09:09Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52136693&edit=JgQNMKi6nIZBA4ZEoScVeM2swC3yCNXu2RBjG6Of5ekm4', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'S Arslan', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517848346}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Filars@Hotmail.Co. uk', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517848347}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517848349}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517848348}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517848407}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36894450, 'type': 'radio', 'id': 517849399}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"The Heathrow area is already has  toxic air by too many planes all day non stop. It destroy the environment and people's life ( mental and physical health )\", 'choice_title': '&nbsp;', 'choice_id': 36895376, 'type': 'text', 'id': 517849400}], 'position': 2, 'number': 9, 'title': 'Any additional comments on our proposed environmental objective for the next regime.', 'id': 4415974}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disgree', 'choice_id': 36882709, 'type': 'radio', 'id': 517849719}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36895150, 'type': 'radio', 'id': 517849834}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36895157, 'type': 'radio', 'id': 517849835}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36883750, 'type': 'radio', 'id': 517851636}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"How could you think people could go to sleep with the noise of the flight at 11.30pm?  Or can sleep in the morning 6am?  Thhis is for scheduled flights and it's already too many hours..plus there are many unscheduled flights which we have around 1am in the morning or just after 5am?\", 'choice_title': '&nbsp;', 'choice_id': 36895503, 'type': 'text', 'id': 517851637}], 'position': 2, 'number': 16, 'title': 'Any additional comments on our proposal for Heathrow’s movement limit.', 'id': 4416068}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36883874, 'type': 'radio', 'id': 517851638}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36885029, 'type': 'radio', 'id': 517852685}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"They need to fly higher, you must encourage new technologies for quieter aircrafts,  have to put first people's well being before than anything\", 'choice_title': '&nbsp;', 'choice_id': 36895196, 'type': 'text', 'id': 517852686}], 'position': 2, 'number': 22, 'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.', 'id': 4416257}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36885073, 'type': 'radio', 'id': 517852687}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283153, 'type': 'radio', 'id': 517852916}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T13:19:49Z', 'manual_entry': False, 'date_ended': '2017-02-07T13:19:49Z', 'user_agent': 'Mozilla/5.0 (Linux; Android 4.4.2; GT-N7100 Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36', 'saved_name': '', 'referer_url': '', 'id': 52136693}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '86.140.209.82', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52135243', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102896, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6', 'saved_continue_url': '', 'date_started': '2017-02-07T12:46:09Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52135243&edit=xusjVhWU6PgDzNJZayJAxXmaAWFmIviGwk8vKU48g8w6A', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'francesca Polaine', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517837556}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'francescapolaine@msn.com', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517837557}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Stansted', 'choice_id': 37282123, 'type': 'checkbox', 'id': 517837559}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517837558}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517837577}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '4 - Disagree', 'choice_id': 36894449, 'type': 'radio', 'id': 517838851}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '2 - Agree', 'choice_id': 36882706, 'type': 'radio', 'id': 517838877}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '2 - Agree', 'choice_id': 36895147, 'type': 'radio', 'id': 517839523}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '2 - Agree', 'choice_id': 36895154, 'type': 'radio', 'id': 517839524}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883748, 'type': 'radio', 'id': 517839782}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883872, 'type': 'radio', 'id': 517839783}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '4 - Disagree', 'choice_id': 36884056, 'type': 'radio', 'id': 517839784}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36885027, 'type': 'radio', 'id': 517839909}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36885071, 'type': 'radio', 'id': 517839910}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885144, 'type': 'radio', 'id': 517839911}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283153, 'type': 'radio', 'id': 517840513}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T12:53:54Z', 'manual_entry': False, 'date_ended': '2017-02-07T12:53:54Z', 'user_agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.4.6 (KHTML, like Gecko) Version/10.0 Mobile/14D27 Safari/602.1', 'saved_name': '', 'referer_url': '', 'id': 52135243}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '86.129.147.99', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52133067', 'contact_name': '', 'saved_email': 'superbizuk@gmail.com', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102896, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6/', 'saved_continue_url': '', 'date_started': '2017-02-07T12:08:16Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': True, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52133067&edit=6gVk1FdhyDorECsXHnOSJomuN0BwExzrBHyVNUd0oBUzn', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'Paul Mason', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517818471}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'superbizuk@gmail.com', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517818472}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517818474}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517818473}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517818552}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36894450, 'type': 'radio', 'id': 517827885}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"The proposal to effectively keep the current environment strategy is unreasonable as since the 2014 'tests' the operating procedures at Heathrow have changed.  \\r\\n\\r\\nLate departures with noisy. low flying planes, (under 3,000 feet - over TW11 8RP) are regularly flown after 1 am in the morning as well as disturbance of planes noisily preparing to land at four in the morning.  \\r\\n\\r\\nThis affects the sleep of hundreds of thousands of individuals.\", 'choice_title': '&nbsp;', 'choice_id': 36895376, 'type': 'text', 'id': 517827886}], 'position': 2, 'number': 9, 'title': 'Any additional comments on our proposed environmental objective for the next regime.', 'id': 4415974}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36882705, 'type': 'radio', 'id': 517829106}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Five years is reasonable at this stage, certainly around Heathrow, as there are so many variables, such as changing fleets of aircraft and the possibility of expansion of the airport.', 'choice_title': '&nbsp;', 'choice_id': 36895134, 'type': 'text', 'id': 517829107}], 'position': 2, 'number': 11, 'title': 'Any additional comments on our proposal for the length of the regime.', 'id': 4415992}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895146, 'type': 'radio', 'id': 517829579}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36895155, 'type': 'radio', 'id': 517829580}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36883750, 'type': 'radio', 'id': 517830539}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'They should be either stopped or reduced.', 'choice_title': '&nbsp;', 'choice_id': 36895503, 'type': 'text', 'id': 517830540}], 'position': 2, 'number': 16, 'title': 'Any additional comments on our proposal for Heathrow’s movement limit.', 'id': 4416068}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883872, 'type': 'radio', 'id': 517830541}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '2 - Agree', 'choice_id': 36884054, 'type': 'radio', 'id': 517830542}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885025, 'type': 'radio', 'id': 517836308}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'A financial charge to aircraft that exceed certain noise levels.  The charge increase according to the time eg between midnight and six.  \\r\\n\\r\\nAlso there should be better procedures for the way planes are flown.  For example, a late BA flight to Brazil, flown at 3,000 feet over Teddington at 1.10am and through Twitter I am aware people were woken by the same flight in Surbiton.  \\r\\n\\r\\nThe plane was excessively loud.  If it was a car it would have been the equivalent of a car being revved.  \\r\\nThis sort of behaviour should be fined.', 'choice_title': '&nbsp;', 'choice_id': 36895196, 'type': 'text', 'id': 517836309}], 'position': 2, 'number': 22, 'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.', 'id': 4416257}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885069, 'type': 'radio', 'id': 517836310}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Similar ideas as for Heathrow.', 'choice_title': '&nbsp;', 'choice_id': 36895216, 'type': 'text', 'id': 517836311}], 'position': 4, 'number': 24, 'title': 'Any additional comments on how noise quotas can best be set in order to encourage the use of quieter aircraft at Gatwick.', 'id': 4416259}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885144, 'type': 'radio', 'id': 517836312}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Similar ideas as for Heathrow.', 'choice_title': '&nbsp;', 'choice_id': 36895215, 'type': 'text', 'id': 517836313}], 'position': 6, 'number': 26, 'title': 'Any additional comments on how noise quotas can best be set in order to encourage the use of quieter aircraft at Stansted.', 'id': 4416262}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 9, 'questions': [{'type': 'file_upload', 'answers': [{'value': \"No other industrial country would allow so many people, hundreds of thousands), be harmed by severe noise pollution causing lack of sleep and therefore adding stress and mental problems.  This will also have an adverse effect of reducing work productivity and children's performance at schools.\", 'choice_title': 'Comments:', 'choice_id': 37298518, 'type': 'comment', 'id': 517838277}], 'id': 4416407, 'number': 27, 'title': \"Add any further views on our proposals, or their potential impact on government's ability to fulfil the requirements of the public sector equality duty (note commercially sensitive information must be emailed to night.flights@dft.gsi.gov.uk only).\", 'position': 1}], 'title': 'Additional comments', 'id': 1090049}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283153, 'type': 'radio', 'id': 517838372}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T12:48:57Z', 'manual_entry': False, 'date_ended': '2017-02-07T12:48:57Z', 'user_agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36', 'saved_name': 'Paul Mason', 'referer_url': '', 'id': 52133067}, {'contact_invitation_id': 0, 'contact_email': '', 'ip_address': '81.149.112.126', 'href': 'https://api.smartsurvey.io/v1/surveys/286725/responses/52133776', 'contact_name': '', 'saved_email': '', 'translation_id': 224421, 'status': 'completed', 'current_page_id': 1102896, 'entry_url': 'https://www.smartsurvey.co.uk/s/J6KX6', 'saved_continue_url': '', 'date_started': '2017-02-07T12:21:29Z', 'tracking_link_id': 308404, 'survey_id': 286725, 'country': '208', 'saved': False, 'edit_url': 'https://www.smartsurvey.co.uk/s/J6KX6/?uid=52133776&edit=pYZzQ3qIQCz1XryRCtOrpIfATFblolNakf1hmbuMDsptF', 'pages': [{'position': 1, 'questions': [{'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'James Jefferies', 'choice_title': '&nbsp;', 'choice_id': 36871349, 'type': 'text', 'id': 517825084}], 'position': 1, 'number': 1, 'title': 'Name:', 'id': 4415657}, {'sub_type': 'single', 'type': 'open_ended', 'answers': [{'value': 'jamesjefferies@hotmail.com', 'choice_title': '&nbsp;', 'choice_id': 36871360, 'type': 'text', 'id': 517825085}], 'position': 2, 'number': 2, 'title': 'Email:', 'id': 4415658}, {'sub_type': 'checkbox', 'type': 'multiple_choice', 'answers': [{'choice_title': 'Heathrow', 'choice_id': 37282121, 'type': 'checkbox', 'id': 517825087}], 'position': 3, 'number': 3, 'title': 'Your responses are mainly about (you may select more than one airport)?', 'id': 4472942}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'an individual?', 'choice_id': 36887247, 'type': 'radio', 'id': 517825086}], 'position': 4, 'number': 4, 'title': 'Are you responding as:', 'id': 4415659}], 'title': 'Personal details', 'id': 1089799}, {'position': 3, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283212, 'type': 'radio', 'id': 517825187}], 'position': 1, 'number': 7, 'title': 'Do you wish to respond to the consultation document?', 'id': 4472954}], 'title': 'Response type', 'id': 1102880}, {'position': 4, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36894450, 'type': 'radio', 'id': 517825558}], 'position': 1, 'number': 8, 'title': 'How strongly do you agree or disagree with our proposed environmental objective for the next regime?', 'id': 4415734}], 'title': 'Environmental objective', 'id': 1089815}, {'position': 5, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disgree', 'choice_id': 36882709, 'type': 'radio', 'id': 517827054}], 'position': 1, 'number': 10, 'title': 'How strongly do you agree or disagree with our proposal for the length of the next regime?', 'id': 4415985}], 'title': 'Regime length', 'id': 1089920}, {'position': 6, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36895150, 'type': 'radio', 'id': 517829982}], 'position': 1, 'number': 12, 'title': 'How strongly do you agree or disagree with our of the proposal to introduce a new QC/0.125 category for aircraft between 81 and 83.9 EPNdB?', 'id': 4416035}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36895153, 'type': 'radio', 'id': 517829983}], 'position': 2, 'number': 13, 'title': 'How strongly do you agree or disagree with  our proposal for all aircraft quieter than this to remain QC/0 but count towards the airports movement limit?', 'id': 4416040}], 'title': 'The quota count system', 'id': 1089923}, {'position': 7, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '5 - Strongly disagree', 'choice_id': 36883750, 'type': 'radio', 'id': 517832064}], 'position': 1, 'number': 15, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Heathrow?', 'id': 4416062}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': 'Any planes landing between 4:30am and 6:00am have a seriously detrimental effect on the quality of  sleep. The current arrangement is not acceptable. 6am first landing would be more reasonable.', 'choice_title': '&nbsp;', 'choice_id': 36895503, 'type': 'text', 'id': 517832065}], 'position': 2, 'number': 16, 'title': 'Any additional comments on our proposal for Heathrow’s movement limit.', 'id': 4416068}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36883872, 'type': 'radio', 'id': 517832066}], 'position': 3, 'number': 17, 'title': 'How strongly do you agree or disagree with the proposal for movement limits to remain unchanged at Gatwick?', 'id': 4416073}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36884055, 'type': 'radio', 'id': 517832067}], 'position': 5, 'number': 19, 'title': 'How strongly do you agree or disagree with the proposal to raise Stansted’s movement limits to reflect the current number of exempt aircraft in operation?', 'id': 4416093}], 'title': 'Movement limits', 'id': 1089955}, {'position': 8, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '1 - Strongly agree', 'choice_id': 36885025, 'type': 'radio', 'id': 517834611}], 'position': 1, 'number': 21, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Heathrow?:', 'id': 4416254}, {'sub_type': 'essay', 'type': 'open_ended', 'answers': [{'value': \"Be clear about what is meant by 'quieter aircraft'. If they are not quieter on approach then Richmond will not benefit.\", 'choice_title': '&nbsp;', 'choice_id': 36895196, 'type': 'text', 'id': 517834612}], 'position': 2, 'number': 22, 'title': 'Any additional comments on how noise quotas can be set in order to encourage the use of quieter aircraft at Heathrow.', 'id': 4416257}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36885071, 'type': 'radio', 'id': 517834613}], 'position': 3, 'number': 23, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Gatwick?', 'id': 4416258}, {'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': '3 - Neither agree nor disagree', 'choice_id': 36885146, 'type': 'radio', 'id': 517834614}], 'position': 5, 'number': 25, 'title': 'How strongly do you agree or disagree with our proposals to encourage the use of quieter aircraft at Stansted?', 'id': 4416261}], 'title': 'Noise quota limits', 'id': 1104385}, {'position': 10, 'questions': [{'sub_type': 'radio', 'type': 'single_choice', 'answers': [{'choice_title': 'Yes', 'choice_id': 37283153, 'type': 'radio', 'id': 517834920}], 'position': 1, 'number': 28, 'title': 'Do you wish to respond to the impact assessment?', 'id': 4473045}], 'title': 'Response type', 'id': 1102916}], 'date_modified': '2017-02-07T12:41:23Z', 'manual_entry': False, 'date_ended': '2017-02-07T12:41:23Z', 'user_agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36', 'saved_name': '', 'referer_url': '', 'id': 52133776}]"
      ]
     },
     "execution_count": 318,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "responses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "output = {}\n",
    "i = 0\n",
    "\n",
    "for response in responses:\n",
    "    \n",
    "    output[i] = {}\n",
    "    \n",
    "    for page in response['pages']:\n",
    "        \n",
    "        for question in page['questions']:\n",
    "\n",
    "            uid = question['number']\n",
    "            title = question['title']\n",
    "\n",
    "            if question['type'] == 'open_ended':\n",
    "                answer = question['answers'][0]['value']\n",
    "\n",
    "            if question['type'] == 'file_upload':\n",
    "                answer = question['answers'][0]['value']\n",
    "\n",
    "            if question['type'] == 'single_choice':\n",
    "                answer = question['answers'][0]['choice_title']\n",
    "\n",
    "            elif question['type'] == 'checkbox':\n",
    "                answer = question['answers'][0]['choice_title']\n",
    "\n",
    "            elif question['type'] == 'radio':\n",
    "                answer = question['answers'][0]['choice_title']\n",
    "\n",
    "            elif question['type'] == 'multiple_choice':\n",
    "                answer = ' '\n",
    "                for item in question['answers']:\n",
    "                    answer = answer + item['choice_title'] + ' '\n",
    "            \n",
    "            output[i][uid] = answer\n",
    "    \n",
    "    i += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0: {1: 'Sue Thompson',\n",
       "  2: 'thompsonsue@ymail.com',\n",
       "  3: ' Stansted ',\n",
       "  4: 'an individual?',\n",
       "  7: 'No',\n",
       "  28: 'Yes',\n",
       "  36: 'i live under the present flight path and am kept awake or woken up by it, after a while lack of sleep catches up and can have a very bad and even dangerous effect upon me.',\n",
       "  37: 'The villagers are all affected and complaining about the interference on our lives by the aircraft noise and fumes.'},\n",
       " 1: {1: 'Clare Hillman',\n",
       "  2: 'Clarehillman@gmail.com',\n",
       "  3: ' Heathrow Gatwick Stansted ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '5 - Strongly disagree',\n",
       "  9: \"Unfortunately I dot have time to read the full document - a summary would make it more accessible for the public to have a say. But in principle airports are not environmentally friendly in any way - so no environmental policy could involve expanding it, or increasingy night flights and noise levels! The residents of west London already suffer massive noise and pollution and are now being told that we are irrelevant in the discussion about making much much more of both through both the planes and the traffic it generates. And in a horrible ironic twist, the latest excuse for this is Brexit, which the vast majority of us don't want anyway! Why don't you put your 'open Britain' airport where it is needed by those who want this. why should I be kept awake at night to try to save this country from a man made disaster?!\",\n",
       "  10: '3 - Neither agree or disagree',\n",
       "  11: \"You don't say how long that is!\",\n",
       "  12: '3 - Neither agree nor disagree',\n",
       "  13: '3 - Neither agree nor disagree',\n",
       "  14: 'A few lines to explain this would help people give better answers',\n",
       "  15: '5 - Strongly disagree',\n",
       "  16: \"Reduce them further - they fly until midnight and start again before 6 and The planes going over us are huge. How about change the flight paths too, so they don't fly straight over rows of houses? there is a river and a group of reservoirs behind us. Why don't you fly your great pollution machines over those?\",\n",
       "  17: '5 - Strongly disagree',\n",
       "  18: \"Assuming they are the same as Heathrow then restrict them too, unless you can find flight paths that don't disturb people. There is more space there of course\",\n",
       "  19: '5 - Strongly disagree',\n",
       "  20: 'If by raise you mean make longer then absolutely not. These planes are not quiet or or safe.',\n",
       "  21: '1 - Strongly agree',\n",
       "  22: 'Ban the noisy ones alrogether',\n",
       "  23: '1 - Strongly agree',\n",
       "  25: '1 - Strongly agree',\n",
       "  28: 'No'},\n",
       " 2: {1: 'Lucy',\n",
       "  2: 'lucysomner69@hotmail.com',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '4 - Disagree',\n",
       "  10: '4 - Disagree',\n",
       "  12: '4 - Disagree',\n",
       "  13: '4 - Disagree',\n",
       "  15: '4 - Disagree',\n",
       "  16: 'It is too noisy also in the day the planes fly too low so disrupt by causing noise and also TV ariel problems.',\n",
       "  17: '3 - Neither agree nor disagree',\n",
       "  19: '3 - Neither agree nor disagree',\n",
       "  21: '3 - Neither agree nor disagree',\n",
       "  23: '3 - Neither agree nor disagree',\n",
       "  25: '3 - Neither agree nor disagree',\n",
       "  27: 'Reduce noise and reduce low flying during the day.',\n",
       "  28: 'Yes'},\n",
       " 3: {1: 'Olga Rego',\n",
       "  2: 'Olgargego@aol.com',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '1 - Strongly agree',\n",
       "  10: '1 - Strongly agree',\n",
       "  12: '1 - Strongly agree',\n",
       "  13: '1 - Strongly agree',\n",
       "  15: '1 - Strongly agree',\n",
       "  17: '1 - Strongly agree',\n",
       "  19: '1 - Strongly agree',\n",
       "  21: '1 - Strongly agree',\n",
       "  23: '1 - Strongly agree',\n",
       "  25: '1 - Strongly agree',\n",
       "  28: 'Yes'},\n",
       " 4: {1: 'Julian West',\n",
       "  2: 'Julian.west@hotmail.co.uk',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '5 - Strongly disagree',\n",
       "  9: 'I do not see how the environmental issues have been honestly reported. It is well documented that new planes are per kg more environmentally friendly however they require more power which equals a net increase in noise. In addition there will be major issues in the increase of airline traffic in an already congested area. This is without taking into consideration the rrmassive increase in traffic to a hugely congested region.',\n",
       "  10: '5 - Strongly disgree',\n",
       "  11: \"The length of time suggested is almost immaterial. Flights will happen outside of these regimes. Allowing for less than 7 hours is ridiculous. Consider schools, shift workers, home workers, how do you think it is now? The noise of a plane going over results in having to pause a conversation. More noise in the Heathrow area just doesn't make sense.\",\n",
       "  12: '3 - Neither agree nor disagree',\n",
       "  13: '3 - Neither agree nor disagree',\n",
       "  14: \"I'm completely opposed to the Heathrow expansion the impact to 100,000s of people is just inhuman. The current government was elected on the pledge that Heathrow would not be expanded. So what has happened. Why has this changed? Does anyone care that people are looking to move their family, remove their children from local schools.\",\n",
       "  15: '5 - Strongly disagree',\n",
       "  16: 'Why should there be any more traffic to such a busy airport in an area that is heavily congested. One additional runway will not be enough. So why expand in this area when there is no scope to further extend. Anyone that knows anything about this area (speak to current or previous Mayor) they will tell you it makes no sense to extend this site.',\n",
       "  17: '3 - Neither agree nor disagree',\n",
       "  19: '3 - Neither agree nor disagree',\n",
       "  21: '1 - Strongly agree',\n",
       "  22: 'This should happen anyway. However most new planes are larger and require more power. Just no more planes please.',\n",
       "  23: '3 - Neither agree nor disagree',\n",
       "  25: '3 - Neither agree nor disagree',\n",
       "  27: 'Why would anyone look to punish this area more than it is already. Please work to another solution that provides a long term solution.',\n",
       "  28: 'No'},\n",
       " 5: {1: 'Valerie Cumming Newell',\n",
       "  2: 'valerie@vcumming.clara.co.uk',\n",
       "  3: ' Stansted ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '5 - Strongly disagree',\n",
       "  9: '•\\tthere should be an objective to phase out all night flights at Stansted by 2030, except in the case of genuine emergencies;\\r\\n•\\tthe limit on night flights should be from 11.00pm to 7.00am, so that the airport only operates within the definition of ‘night’ as specified by the World Health Organisation (WHO)’s Guidelines on Community Noise;\\r\\n•\\tthere should be a complete review / change to the current ‘averaging’ method for measuring aircraft noise so that the  official Government noise statistics start to represent what residents actually have to endure.',\n",
       "  10: '3 - Neither agree or disagree',\n",
       "  12: '3 - Neither agree nor disagree',\n",
       "  13: '3 - Neither agree nor disagree',\n",
       "  14: 'Have on idea what this question means - it is deliberately phrased to prevent lay people (ie residents!) being able to comment and take a stance! Your wording precludes people from participating in the consultation process is therefore undemocratic, lacks transparency and is biased against residents.',\n",
       "  15: '3 - Neither agree nor disagree',\n",
       "  17: '3 - Neither agree nor disagree',\n",
       "  19: '5 - Strongly disagree',\n",
       "  20: 'The night flights proposals do not go nearly far enough to tackle the very serious impacts of night flights in terms of sleep disturbance for local residents around Stansted and under its flight paths. It becoming hellish!',\n",
       "  21: '1 - Strongly agree',\n",
       "  23: '1 - Strongly agree',\n",
       "  25: '1 - Strongly agree',\n",
       "  27: 'As previously stated, the wording of some of your questions seem deliberately designed to prevent some people (ie residents with no technical knowledge of aircraft) from participating in this consultation process.',\n",
       "  28: 'Yes',\n",
       "  32: 'The whole process and documentation is deliberately over-complex and designed to prevent non-specialists from participating in the process. Therefore, the very people who are most affected (the residents) are the most excluded from the process.'},\n",
       " 6: {1: 'Julius Malewicz',\n",
       "  2: 'julius_451@hotmail.com',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '5 - Strongly disagree',\n",
       "  9: 'Do you want to grow a city of angry sleep deprived men and women or not. Sleep is important.',\n",
       "  10: '4 - Disagree',\n",
       "  12: '5 - Strongly disagree',\n",
       "  13: '2 - Agree',\n",
       "  14: 'These questions appear deliberately confusing.',\n",
       "  15: '2 - Agree',\n",
       "  17: '2 - Agree',\n",
       "  19: '2 - Agree',\n",
       "  21: '5 - Strongly disagree',\n",
       "  22: 'The prime mover when considering aircraft should always be safety. Quieter aircraft are not needed if there are less flights over London at night.',\n",
       "  23: '5 - Strongly disagree',\n",
       "  24: 'The prime mover when considering aircraft should always be safety. Quieter aircraft are not needed if there are less flights over London at night.',\n",
       "  25: '5 - Strongly disagree',\n",
       "  26: 'The prime mover when considering aircraft should always be safety. Quieter aircraft are not needed if there are less flights over London at night.',\n",
       "  28: 'No'},\n",
       " 7: {1: 'Claire Campbell',\n",
       "  2: 'clairejcampbell@live.co.uk',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '2 - Agree',\n",
       "  10: '3 - Neither agree or disagree',\n",
       "  12: '2 - Agree',\n",
       "  13: '2 - Agree',\n",
       "  15: '5 - Strongly disagree',\n",
       "  16: \"Shouldn't be any flights between 11pm and 6am, at all\",\n",
       "  17: '3 - Neither agree nor disagree',\n",
       "  19: '3 - Neither agree nor disagree',\n",
       "  21: '5 - Strongly disagree',\n",
       "  22: \"'Encourage' is not strong enough -should implement with a deadline\",\n",
       "  23: '3 - Neither agree nor disagree',\n",
       "  25: '3 - Neither agree nor disagree',\n",
       "  28: 'No'},\n",
       " 8: {1: 'Andrew Waite',\n",
       "  2: 'Ajaywaite@gmail.com',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '3 - Neither agree nor disagree',\n",
       "  10: '2 - Agree',\n",
       "  12: '4 - Disagree',\n",
       "  13: '4 - Disagree',\n",
       "  15: '5 - Strongly disagree',\n",
       "  17: '3 - Neither agree nor disagree',\n",
       "  19: '3 - Neither agree nor disagree',\n",
       "  21: '4 - Disagree',\n",
       "  23: '3 - Neither agree nor disagree',\n",
       "  25: '3 - Neither agree nor disagree',\n",
       "  28: 'Yes'},\n",
       " 9: {1: 'Teresa Wildash',\n",
       "  2: 'teresawildash@gmail.com',\n",
       "  3: ' Heathrow ',\n",
       "  4: 'an individual?',\n",
       "  7: 'Yes',\n",
       "  8: '5 - Strongly disagree',\n",
       "  10: '5 - Strongly disgree',\n",
       "  12: '5 - Strongly disagree',\n",
       "  13: '3 - Neither agree nor disagree',\n",
       "  15: '1 - Strongly agree',\n",
       "  17: '1 - Strongly agree',\n",
       "  19: '3 - Neither agree nor disagree',\n",
       "  21: '1 - Strongly agree',\n",
       "  23: '1 - Strongly agree',\n",
       "  25: '1 - Strongly agree',\n",
       "  28: 'Yes'}}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'int' object is not iterable",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-295-526755feb39e>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0;32mfor\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m \u001b[0;32min\u001b[0m \u001b[0moutput\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m     \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtest\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: 'int' object is not iterable"
     ],
     "output_type": "error"
    }
   ],
   "source": [
    "f"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 315,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = DataFrame(output)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 316,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>David Bateman</td>\n",
       "      <td>Eur Ing David W Kent</td>\n",
       "      <td>David Bateman</td>\n",
       "      <td>Nick Harvey</td>\n",
       "      <td>Brendan Leddy</td>\n",
       "      <td>Jonathan Mills</td>\n",
       "      <td>S Arslan</td>\n",
       "      <td>francesca Polaine</td>\n",
       "      <td>Paul Mason</td>\n",
       "      <td>James Jefferies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dljbateman@hotmail.com</td>\n",
       "      <td>d.w.kent@homecall.co.uk</td>\n",
       "      <td>Dljbateman@hotmail.com</td>\n",
       "      <td>naharvey@live.co.uk</td>\n",
       "      <td>Leddybrendan@yahoo.ie</td>\n",
       "      <td>jonmills54@gmail.com</td>\n",
       "      <td>Filars@Hotmail.Co. uk</td>\n",
       "      <td>francescapolaine@msn.com</td>\n",
       "      <td>superbizuk@gmail.com</td>\n",
       "      <td>jamesjefferies@hotmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Stansted</td>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Stansted</td>\n",
       "      <td>Heathrow</td>\n",
       "      <td>Heathrow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "      <td>an individual?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4 - Disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>4 - Disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>4 - Disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>we would like to see an earlier ban on night f...</td>\n",
       "      <td>Sound measurements are not typical of those ex...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The objective apperas to be skewed towards the...</td>\n",
       "      <td>The Heathrow area is already has  toxic air by...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The proposal to effectively keep the current e...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4 - Disagree</td>\n",
       "      <td>4 - Disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5 - Strongly disgree</td>\n",
       "      <td>5 - Strongly disgree</td>\n",
       "      <td>5 - Strongly disgree</td>\n",
       "      <td>2 - Agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disgree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>It should be reviewed more regularly to allow ...</td>\n",
       "      <td>Should be shorter to reflect comment on the di...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>It's too long - chnages should be made from Oc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Five years is reasonable at this stage, certai...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>2 - Agree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>2 - Agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>2 - Agree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>2 - Agree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Aim should be to stop all night flights</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THe night flight limits are too high and such ...</td>\n",
       "      <td>How could you think people could go to sleep w...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>They should be either stopped or reduced.</td>\n",
       "      <td>Any planes landing between 4:30am and 6:00am h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>I believe Gatwick should be up scaled as it im...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4 - Disagree</td>\n",
       "      <td>2 - Agree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NaN</td>\n",
       "      <td>As a rural area the impact of existing flights...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>They need to fly higher, you must encourage ne...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A financial charge to aircraft that exceed cer...</td>\n",
       "      <td>Be clear about what is meant by 'quieter aircr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Similar ideas as for Heathrow.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>5 - Strongly disagree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>1 - Strongly agree</td>\n",
       "      <td>3 - Neither agree nor disagree</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Ban all night flights</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Similar ideas as for Heathrow.</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Existing night flights disrupt sleep and shoul...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This has confused the hell out of me - I am ba...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No other industrial country would allow so man...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    0  \\\n",
       "1                                       David Bateman   \n",
       "2                              Dljbateman@hotmail.com   \n",
       "3                                           Heathrow    \n",
       "4                                      an individual?   \n",
       "7                                                 Yes   \n",
       "8                                        4 - Disagree   \n",
       "9   we would like to see an earlier ban on night f...   \n",
       "10                                       4 - Disagree   \n",
       "11  It should be reviewed more regularly to allow ...   \n",
       "12                                 1 - Strongly agree   \n",
       "13                                 1 - Strongly agree   \n",
       "14                                                NaN   \n",
       "15                                 1 - Strongly agree   \n",
       "16                                                NaN   \n",
       "17                              5 - Strongly disagree   \n",
       "18  I believe Gatwick should be up scaled as it im...   \n",
       "19                     3 - Neither agree nor disagree   \n",
       "20                                                NaN   \n",
       "21                                 1 - Strongly agree   \n",
       "22                                                NaN   \n",
       "23                                 1 - Strongly agree   \n",
       "24                                                NaN   \n",
       "25                                 1 - Strongly agree   \n",
       "26                                                NaN   \n",
       "27                                                NaN   \n",
       "28                                                 No   \n",
       "\n",
       "                                                    1                       2  \\\n",
       "1                                Eur Ing David W Kent           David Bateman   \n",
       "2                             d.w.kent@homecall.co.uk  Dljbateman@hotmail.com   \n",
       "3                                           Stansted                Heathrow    \n",
       "4                                      an individual?          an individual?   \n",
       "7                                                 Yes                      No   \n",
       "8                      3 - Neither agree nor disagree                     NaN   \n",
       "9   Sound measurements are not typical of those ex...                     NaN   \n",
       "10                                       4 - Disagree                     NaN   \n",
       "11  Should be shorter to reflect comment on the di...                     NaN   \n",
       "12                                          2 - Agree                     NaN   \n",
       "13                                          2 - Agree                     NaN   \n",
       "14            Aim should be to stop all night flights                     NaN   \n",
       "15                     3 - Neither agree nor disagree                     NaN   \n",
       "16                                                NaN                     NaN   \n",
       "17                     3 - Neither agree nor disagree                     NaN   \n",
       "18                                                NaN                     NaN   \n",
       "19                              5 - Strongly disagree                     NaN   \n",
       "20  As a rural area the impact of existing flights...                     NaN   \n",
       "21                                 1 - Strongly agree                     NaN   \n",
       "22                                                NaN                     NaN   \n",
       "23                                 1 - Strongly agree                     NaN   \n",
       "24                                                NaN                     NaN   \n",
       "25                              5 - Strongly disagree                     NaN   \n",
       "26                              Ban all night flights                     NaN   \n",
       "27  Existing night flights disrupt sleep and shoul...                     NaN   \n",
       "28                                                Yes                      No   \n",
       "\n",
       "                      3                                                  4  \\\n",
       "1           Nick Harvey                                      Brendan Leddy   \n",
       "2   naharvey@live.co.uk                              Leddybrendan@yahoo.ie   \n",
       "3             Heathrow                                           Heathrow    \n",
       "4        an individual?                                     an individual?   \n",
       "7                    No                                                Yes   \n",
       "8                   NaN                              5 - Strongly disagree   \n",
       "9                   NaN                                                NaN   \n",
       "10                  NaN                               5 - Strongly disgree   \n",
       "11                  NaN                                                NaN   \n",
       "12                  NaN                                 1 - Strongly agree   \n",
       "13                  NaN                                 1 - Strongly agree   \n",
       "14                  NaN                                                NaN   \n",
       "15                  NaN                                 1 - Strongly agree   \n",
       "16                  NaN                                                NaN   \n",
       "17                  NaN                     3 - Neither agree nor disagree   \n",
       "18                  NaN                                                NaN   \n",
       "19                  NaN                     3 - Neither agree nor disagree   \n",
       "20                  NaN                                                NaN   \n",
       "21                  NaN                                 1 - Strongly agree   \n",
       "22                  NaN                                                NaN   \n",
       "23                  NaN                     3 - Neither agree nor disagree   \n",
       "24                  NaN                                                NaN   \n",
       "25                  NaN                     3 - Neither agree nor disagree   \n",
       "26                  NaN                                                NaN   \n",
       "27                  NaN  This has confused the hell out of me - I am ba...   \n",
       "28                   No                                                Yes   \n",
       "\n",
       "                                                    5  \\\n",
       "1                                      Jonathan Mills   \n",
       "2                                jonmills54@gmail.com   \n",
       "3                                           Heathrow    \n",
       "4                                      an individual?   \n",
       "7                                                 Yes   \n",
       "8                                        4 - Disagree   \n",
       "9   The objective apperas to be skewed towards the...   \n",
       "10                               5 - Strongly disgree   \n",
       "11  It's too long - chnages should be made from Oc...   \n",
       "12                              5 - Strongly disagree   \n",
       "13                                 1 - Strongly agree   \n",
       "14                                                NaN   \n",
       "15                              5 - Strongly disagree   \n",
       "16  THe night flight limits are too high and such ...   \n",
       "17                     3 - Neither agree nor disagree   \n",
       "18                                                NaN   \n",
       "19                     3 - Neither agree nor disagree   \n",
       "20                                                NaN   \n",
       "21                                 1 - Strongly agree   \n",
       "22                                                NaN   \n",
       "23                                 1 - Strongly agree   \n",
       "24                                                NaN   \n",
       "25                                 1 - Strongly agree   \n",
       "26                                                NaN   \n",
       "27                                                NaN   \n",
       "28                                                 No   \n",
       "\n",
       "                                                    6  \\\n",
       "1                                            S Arslan   \n",
       "2                               Filars@Hotmail.Co. uk   \n",
       "3                                           Heathrow    \n",
       "4                                      an individual?   \n",
       "7                                                 Yes   \n",
       "8                               5 - Strongly disagree   \n",
       "9   The Heathrow area is already has  toxic air by...   \n",
       "10                               5 - Strongly disgree   \n",
       "11                                                NaN   \n",
       "12                              5 - Strongly disagree   \n",
       "13                              5 - Strongly disagree   \n",
       "14                                                NaN   \n",
       "15                              5 - Strongly disagree   \n",
       "16  How could you think people could go to sleep w...   \n",
       "17                              5 - Strongly disagree   \n",
       "18                                                NaN   \n",
       "19                                                NaN   \n",
       "20                                                NaN   \n",
       "21                              5 - Strongly disagree   \n",
       "22  They need to fly higher, you must encourage ne...   \n",
       "23                              5 - Strongly disagree   \n",
       "24                                                NaN   \n",
       "25                                                NaN   \n",
       "26                                                NaN   \n",
       "27                                                NaN   \n",
       "28                                                Yes   \n",
       "\n",
       "                                 7  \\\n",
       "1                francesca Polaine   \n",
       "2         francescapolaine@msn.com   \n",
       "3                        Stansted    \n",
       "4                   an individual?   \n",
       "7                              Yes   \n",
       "8                     4 - Disagree   \n",
       "9                              NaN   \n",
       "10                       2 - Agree   \n",
       "11                             NaN   \n",
       "12                       2 - Agree   \n",
       "13                       2 - Agree   \n",
       "14                             NaN   \n",
       "15  3 - Neither agree nor disagree   \n",
       "16                             NaN   \n",
       "17  3 - Neither agree nor disagree   \n",
       "18                             NaN   \n",
       "19                    4 - Disagree   \n",
       "20                             NaN   \n",
       "21  3 - Neither agree nor disagree   \n",
       "22                             NaN   \n",
       "23  3 - Neither agree nor disagree   \n",
       "24                             NaN   \n",
       "25              1 - Strongly agree   \n",
       "26                             NaN   \n",
       "27                             NaN   \n",
       "28                             Yes   \n",
       "\n",
       "                                                    8  \\\n",
       "1                                          Paul Mason   \n",
       "2                                superbizuk@gmail.com   \n",
       "3                                           Heathrow    \n",
       "4                                      an individual?   \n",
       "7                                                 Yes   \n",
       "8                               5 - Strongly disagree   \n",
       "9   The proposal to effectively keep the current e...   \n",
       "10                                 1 - Strongly agree   \n",
       "11  Five years is reasonable at this stage, certai...   \n",
       "12                                 1 - Strongly agree   \n",
       "13                     3 - Neither agree nor disagree   \n",
       "14                                                NaN   \n",
       "15                              5 - Strongly disagree   \n",
       "16          They should be either stopped or reduced.   \n",
       "17                     3 - Neither agree nor disagree   \n",
       "18                                                NaN   \n",
       "19                                          2 - Agree   \n",
       "20                                                NaN   \n",
       "21                                 1 - Strongly agree   \n",
       "22  A financial charge to aircraft that exceed cer...   \n",
       "23                                 1 - Strongly agree   \n",
       "24                     Similar ideas as for Heathrow.   \n",
       "25                                 1 - Strongly agree   \n",
       "26                     Similar ideas as for Heathrow.   \n",
       "27  No other industrial country would allow so man...   \n",
       "28                                                Yes   \n",
       "\n",
       "                                                    9  \n",
       "1                                     James Jefferies  \n",
       "2                          jamesjefferies@hotmail.com  \n",
       "3                                           Heathrow   \n",
       "4                                      an individual?  \n",
       "7                                                 Yes  \n",
       "8                               5 - Strongly disagree  \n",
       "9                                                 NaN  \n",
       "10                               5 - Strongly disgree  \n",
       "11                                                NaN  \n",
       "12                              5 - Strongly disagree  \n",
       "13                                 1 - Strongly agree  \n",
       "14                                                NaN  \n",
       "15                              5 - Strongly disagree  \n",
       "16  Any planes landing between 4:30am and 6:00am h...  \n",
       "17                     3 - Neither agree nor disagree  \n",
       "18                                                NaN  \n",
       "19                     3 - Neither agree nor disagree  \n",
       "20                                                NaN  \n",
       "21                                 1 - Strongly agree  \n",
       "22  Be clear about what is meant by 'quieter aircr...  \n",
       "23                     3 - Neither agree nor disagree  \n",
       "24                                                NaN  \n",
       "25                     3 - Neither agree nor disagree  \n",
       "26                                                NaN  \n",
       "27                                                NaN  \n",
       "28                                                Yes  "
      ]
     },
     "execution_count": 316,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    ""
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3.0
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}