NoSQL_analysis_starter.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "9a57c4c6",
   "metadata": {},
   "source": [
    "# Eat Safe, Love"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "064ef857",
   "metadata": {},
   "source": [
    "## Notebook Set Up"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3ecdd008",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import dependencies\n",
    "from pymongo import MongoClient, GEO2D\n",
    "import pandas as pd\n",
    "from pprint import pprint"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "59390c4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create an instance of MongoClient\n",
    "mongo = MongoClient(port=27017)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "71e373c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# assign the uk_food database to a variable name\n",
    "db = mongo['uk_food']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "18ab463c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['establishments']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# review the collections in our database\n",
    "db.list_collection_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "11c9f11b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# assign the collection to a variable\n",
    "establishments = db['establishments']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d5671434",
   "metadata": {},
   "source": [
    "## Part 3: Exploratory Analysis\n",
    "Unless otherwise stated, for each question: \n",
    "* Use `count_documents` to display the number of documents contained in the result.\n",
    "* Display the first document in the results using `pprint`.\n",
    "* Convert the result to a Pandas DataFrame, print the number of rows in the DataFrame, and display the first 10 rows."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "314bd884",
   "metadata": {},
   "source": [
    "### 1. Which establishments have a hygiene score equal to 20?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c2da7648",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "41\n",
      "{'AddressLine1': '5-6 Southfields Road',\n",
      " 'AddressLine2': 'Eastbourne',\n",
      " 'AddressLine3': 'East Sussex',\n",
      " 'AddressLine4': '',\n",
      " 'BusinessName': 'The Chase Rest Home',\n",
      " 'BusinessType': 'Caring Premises',\n",
      " 'BusinessTypeID': 5,\n",
      " 'ChangesByServerID': 0,\n",
      " 'Distance': 4613.888288172291,\n",
      " 'FHRSID': 110681,\n",
      " 'LocalAuthorityBusinessID': '4029',\n",
      " 'LocalAuthorityCode': '102',\n",
      " 'LocalAuthorityEmailAddress': 'Customerfirst@eastbourne.gov.uk',\n",
      " 'LocalAuthorityName': 'Eastbourne',\n",
      " 'LocalAuthorityWebSite': 'http://www.eastbourne.gov.uk/foodratings',\n",
      " 'NewRatingPending': False,\n",
      " 'Phone': '',\n",
      " 'PostCode': 'BN21 1BU',\n",
      " 'RatingDate': '2021-09-23T00:00:00',\n",
      " 'RatingKey': 'fhrs_0_en-gb',\n",
      " 'RatingValue': '0',\n",
      " 'RightToReply': '',\n",
      " 'SchemeType': 'FHRS',\n",
      " '_id': ObjectId('641490153cf154af413612be'),\n",
      " 'geocode': {'latitude': Decimal128('50.769705'),\n",
      "             'longitude': Decimal128('0.27694')},\n",
      " 'links': [{'href': 'https://api.ratings.food.gov.uk/establishments/110681',\n",
      "            'rel': 'self'}],\n",
      " 'meta': {'dataSource': None,\n",
      "          'extractDate': '0001-01-01T00:00:00',\n",
      "          'itemCount': 0,\n",
      "          'pageNumber': 0,\n",
      "          'pageSize': 0,\n",
      "          'returncode': None,\n",
      "          'totalCount': 0,\n",
      "          'totalPages': 0},\n",
      " 'scores': {'ConfidenceInManagement': 20,\n",
      "            'Hygeine': None,\n",
      "            'Hygiene': 20,\n",
      "            'Structural': 20}}\n"
     ]
    }
   ],
   "source": [
    "# Find the establishments with a hygiene score of 20\n",
    "query = {'scores.Hygiene': {'$eq': 20}}\n",
    "result = list(establishments.find(query))\n",
    "\n",
    "# Use count_documents to display the number of documents in the result\n",
    "print(establishments.count_documents({'scores.Hygiene': {'$eq': 20}}))\n",
    "# Display the first document in the results using pprint\n",
    "pprint(result[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "a6e5cece",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of rows: 41\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>FHRSID</th>\n",
       "      <th>ChangesByServerID</th>\n",
       "      <th>LocalAuthorityBusinessID</th>\n",
       "      <th>BusinessName</th>\n",
       "      <th>BusinessType</th>\n",
       "      <th>BusinessTypeID</th>\n",
       "      <th>AddressLine1</th>\n",
       "      <th>AddressLine2</th>\n",
       "      <th>AddressLine3</th>\n",
       "      <th>...</th>\n",
       "      <th>LocalAuthorityWebSite</th>\n",
       "      <th>LocalAuthorityEmailAddress</th>\n",
       "      <th>scores</th>\n",
       "      <th>SchemeType</th>\n",
       "      <th>geocode</th>\n",
       "      <th>RightToReply</th>\n",
       "      <th>Distance</th>\n",
       "      <th>NewRatingPending</th>\n",
       "      <th>meta</th>\n",
       "      <th>links</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>641490153cf154af413612be</td>\n",
       "      <td>110681</td>\n",
       "      <td>0</td>\n",
       "      <td>4029</td>\n",
       "      <td>The Chase Rest Home</td>\n",
       "      <td>Caring Premises</td>\n",
       "      <td>5</td>\n",
       "      <td>5-6 Southfields Road</td>\n",
       "      <td>Eastbourne</td>\n",
       "      <td>East Sussex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.eastbourne.gov.uk/foodratings</td>\n",
       "      <td>Customerfirst@eastbourne.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 20, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.27694, 'latitude': 50.769705}</td>\n",
       "      <td></td>\n",
       "      <td>4613.888288</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>641490153cf154af41361643</td>\n",
       "      <td>612039</td>\n",
       "      <td>0</td>\n",
       "      <td>1970/FOOD</td>\n",
       "      <td>Brenalwood</td>\n",
       "      <td>Caring Premises</td>\n",
       "      <td>5</td>\n",
       "      <td>Hall Lane</td>\n",
       "      <td>Walton-on-the-Naze</td>\n",
       "      <td>Essex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.tendringdc.gov.uk/</td>\n",
       "      <td>fhsadmin@tendringdc.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 15, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 1.278721, 'latitude': 51.857536}</td>\n",
       "      <td></td>\n",
       "      <td>4617.965824</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>641490153cf154af41361948</td>\n",
       "      <td>730933</td>\n",
       "      <td>0</td>\n",
       "      <td>1698/FOOD</td>\n",
       "      <td>Melrose Hotel</td>\n",
       "      <td>Hotel/bed &amp; breakfast/guest house</td>\n",
       "      <td>7842</td>\n",
       "      <td>53 Marine Parade East</td>\n",
       "      <td>Clacton On Sea</td>\n",
       "      <td>Essex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.tendringdc.gov.uk/</td>\n",
       "      <td>fhsadmin@tendringdc.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 20, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 1.15927, 'latitude': 51.789429}</td>\n",
       "      <td></td>\n",
       "      <td>4619.656144</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>641490153cf154af41361b38</td>\n",
       "      <td>172735</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000023858</td>\n",
       "      <td>Seaford Pizza</td>\n",
       "      <td>Takeaway/sandwich shop</td>\n",
       "      <td>7844</td>\n",
       "      <td>4 High Street</td>\n",
       "      <td>Seaford</td>\n",
       "      <td>East Sussex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.lewes-eastbourne.gov.uk/</td>\n",
       "      <td>ehealth.ldc@lewes-eastbourne.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 10, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.10202, 'latitude': 50.770885}</td>\n",
       "      <td></td>\n",
       "      <td>4620.421725</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>641490153cf154af41361b46</td>\n",
       "      <td>172953</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000024532</td>\n",
       "      <td>Golden Palace</td>\n",
       "      <td>Restaurant/Cafe/Canteen</td>\n",
       "      <td>1</td>\n",
       "      <td>5 South Street</td>\n",
       "      <td>Seaford</td>\n",
       "      <td>East Sussex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.lewes-eastbourne.gov.uk/</td>\n",
       "      <td>ehealth.ldc@lewes-eastbourne.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 10, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.101446, 'latitude': 50.770724}</td>\n",
       "      <td></td>\n",
       "      <td>4620.437179</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>641490153cf154af413624e4</td>\n",
       "      <td>512854</td>\n",
       "      <td>0</td>\n",
       "      <td>12/00816/BUTH</td>\n",
       "      <td>Ashby's Butchers</td>\n",
       "      <td>Retailers - other</td>\n",
       "      <td>4613</td>\n",
       "      <td>777 Southchurch Road</td>\n",
       "      <td>Southend-On-Sea</td>\n",
       "      <td>Essex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.southend.gov.uk</td>\n",
       "      <td>EnvironmentalHealth@southend.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 20, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.736349, 'latitude': 51.541448}</td>\n",
       "      <td></td>\n",
       "      <td>4625.565258</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>641490153cf154af41362707</td>\n",
       "      <td>1537089</td>\n",
       "      <td>0</td>\n",
       "      <td>22/00224/RESTUN</td>\n",
       "      <td>South Sea Express Cuisine</td>\n",
       "      <td>Restaurant/Cafe/Canteen</td>\n",
       "      <td>1</td>\n",
       "      <td>33 Alexandra Street</td>\n",
       "      <td>Southend-on-sea</td>\n",
       "      <td>Essex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.southend.gov.uk</td>\n",
       "      <td>EnvironmentalHealth@southend.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 20, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.7121671, 'latitude': 51.5350065}</td>\n",
       "      <td></td>\n",
       "      <td>4626.200132</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>641490153cf154af41363c33</td>\n",
       "      <td>155648</td>\n",
       "      <td>0</td>\n",
       "      <td>EH/00006058</td>\n",
       "      <td>Golden Palace</td>\n",
       "      <td>Takeaway/sandwich shop</td>\n",
       "      <td>7844</td>\n",
       "      <td>7 London Road</td>\n",
       "      <td>Rayleigh</td>\n",
       "      <td>Essex</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.rochford.gov.uk</td>\n",
       "      <td>customerservices@rochford.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 15, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.602364, 'latitude': 51.591515}</td>\n",
       "      <td></td>\n",
       "      <td>4632.276890</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>641490153cf154af41364076</td>\n",
       "      <td>1012883</td>\n",
       "      <td>0</td>\n",
       "      <td>17/00110/MIXED/S</td>\n",
       "      <td>The Tulip Tree</td>\n",
       "      <td>Restaurant/Cafe/Canteen</td>\n",
       "      <td>1</td>\n",
       "      <td>3 The Village</td>\n",
       "      <td>Chiddingstone</td>\n",
       "      <td>KENT</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.sevenoaks.gov.uk/</td>\n",
       "      <td>environmental.health@sevenoaks.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 5, 'ConfidenceIn...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.146449998021126, 'latitude': 5...</td>\n",
       "      <td></td>\n",
       "      <td>4633.934041</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>641490153cf154af41364884</td>\n",
       "      <td>644109</td>\n",
       "      <td>0</td>\n",
       "      <td>41811</td>\n",
       "      <td>F &amp; S</td>\n",
       "      <td>Retailers - other</td>\n",
       "      <td>4613</td>\n",
       "      <td></td>\n",
       "      <td>81 Southernhay</td>\n",
       "      <td>Basildon</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.basildon.gov.uk</td>\n",
       "      <td>ehs@basildon.gov.uk</td>\n",
       "      <td>{'Hygiene': 20, 'Structural': 20, 'ConfidenceI...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.462307, 'latitude': 51.57005}</td>\n",
       "      <td></td>\n",
       "      <td>4636.552523</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        _id   FHRSID  ChangesByServerID  \\\n",
       "0  641490153cf154af413612be   110681                  0   \n",
       "1  641490153cf154af41361643   612039                  0   \n",
       "2  641490153cf154af41361948   730933                  0   \n",
       "3  641490153cf154af41361b38   172735                  0   \n",
       "4  641490153cf154af41361b46   172953                  0   \n",
       "5  641490153cf154af413624e4   512854                  0   \n",
       "6  641490153cf154af41362707  1537089                  0   \n",
       "7  641490153cf154af41363c33   155648                  0   \n",
       "8  641490153cf154af41364076  1012883                  0   \n",
       "9  641490153cf154af41364884   644109                  0   \n",
       "\n",
       "  LocalAuthorityBusinessID               BusinessName  \\\n",
       "0                     4029        The Chase Rest Home   \n",
       "1                1970/FOOD                 Brenalwood   \n",
       "2                1698/FOOD              Melrose Hotel   \n",
       "3             PI/000023858              Seaford Pizza   \n",
       "4             PI/000024532              Golden Palace   \n",
       "5            12/00816/BUTH           Ashby's Butchers   \n",
       "6          22/00224/RESTUN  South Sea Express Cuisine   \n",
       "7              EH/00006058              Golden Palace   \n",
       "8         17/00110/MIXED/S             The Tulip Tree   \n",
       "9                    41811                      F & S   \n",
       "\n",
       "                        BusinessType  BusinessTypeID           AddressLine1  \\\n",
       "0                    Caring Premises               5   5-6 Southfields Road   \n",
       "1                    Caring Premises               5              Hall Lane   \n",
       "2  Hotel/bed & breakfast/guest house            7842  53 Marine Parade East   \n",
       "3             Takeaway/sandwich shop            7844          4 High Street   \n",
       "4            Restaurant/Cafe/Canteen               1         5 South Street   \n",
       "5                  Retailers - other            4613   777 Southchurch Road   \n",
       "6            Restaurant/Cafe/Canteen               1    33 Alexandra Street   \n",
       "7             Takeaway/sandwich shop            7844          7 London Road   \n",
       "8            Restaurant/Cafe/Canteen               1          3 The Village   \n",
       "9                  Retailers - other            4613                          \n",
       "\n",
       "         AddressLine2 AddressLine3  ...  \\\n",
       "0          Eastbourne  East Sussex  ...   \n",
       "1  Walton-on-the-Naze        Essex  ...   \n",
       "2      Clacton On Sea        Essex  ...   \n",
       "3             Seaford  East Sussex  ...   \n",
       "4             Seaford  East Sussex  ...   \n",
       "5     Southend-On-Sea        Essex  ...   \n",
       "6     Southend-on-sea        Essex  ...   \n",
       "7            Rayleigh        Essex  ...   \n",
       "8       Chiddingstone         KENT  ...   \n",
       "9      81 Southernhay     Basildon  ...   \n",
       "\n",
       "                      LocalAuthorityWebSite  \\\n",
       "0  http://www.eastbourne.gov.uk/foodratings   \n",
       "1             http://www.tendringdc.gov.uk/   \n",
       "2             http://www.tendringdc.gov.uk/   \n",
       "3       http://www.lewes-eastbourne.gov.uk/   \n",
       "4       http://www.lewes-eastbourne.gov.uk/   \n",
       "5                http://www.southend.gov.uk   \n",
       "6                http://www.southend.gov.uk   \n",
       "7                http://www.rochford.gov.uk   \n",
       "8              http://www.sevenoaks.gov.uk/   \n",
       "9                http://www.basildon.gov.uk   \n",
       "\n",
       "              LocalAuthorityEmailAddress  \\\n",
       "0        Customerfirst@eastbourne.gov.uk   \n",
       "1             fhsadmin@tendringdc.gov.uk   \n",
       "2             fhsadmin@tendringdc.gov.uk   \n",
       "3    ehealth.ldc@lewes-eastbourne.gov.uk   \n",
       "4    ehealth.ldc@lewes-eastbourne.gov.uk   \n",
       "5    EnvironmentalHealth@southend.gov.uk   \n",
       "6    EnvironmentalHealth@southend.gov.uk   \n",
       "7       customerservices@rochford.gov.uk   \n",
       "8  environmental.health@sevenoaks.gov.uk   \n",
       "9                    ehs@basildon.gov.uk   \n",
       "\n",
       "                                              scores SchemeType  \\\n",
       "0  {'Hygiene': 20, 'Structural': 20, 'ConfidenceI...       FHRS   \n",
       "1  {'Hygiene': 20, 'Structural': 15, 'ConfidenceI...       FHRS   \n",
       "2  {'Hygiene': 20, 'Structural': 20, 'ConfidenceI...       FHRS   \n",
       "3  {'Hygiene': 20, 'Structural': 10, 'ConfidenceI...       FHRS   \n",
       "4  {'Hygiene': 20, 'Structural': 10, 'ConfidenceI...       FHRS   \n",
       "5  {'Hygiene': 20, 'Structural': 20, 'ConfidenceI...       FHRS   \n",
       "6  {'Hygiene': 20, 'Structural': 20, 'ConfidenceI...       FHRS   \n",
       "7  {'Hygiene': 20, 'Structural': 15, 'ConfidenceI...       FHRS   \n",
       "8  {'Hygiene': 20, 'Structural': 5, 'ConfidenceIn...       FHRS   \n",
       "9  {'Hygiene': 20, 'Structural': 20, 'ConfidenceI...       FHRS   \n",
       "\n",
       "                                             geocode RightToReply  \\\n",
       "0      {'longitude': 0.27694, 'latitude': 50.769705}                \n",
       "1     {'longitude': 1.278721, 'latitude': 51.857536}                \n",
       "2      {'longitude': 1.15927, 'latitude': 51.789429}                \n",
       "3      {'longitude': 0.10202, 'latitude': 50.770885}                \n",
       "4     {'longitude': 0.101446, 'latitude': 50.770724}                \n",
       "5     {'longitude': 0.736349, 'latitude': 51.541448}                \n",
       "6   {'longitude': 0.7121671, 'latitude': 51.5350065}                \n",
       "7     {'longitude': 0.602364, 'latitude': 51.591515}                \n",
       "8  {'longitude': 0.146449998021126, 'latitude': 5...                \n",
       "9      {'longitude': 0.462307, 'latitude': 51.57005}                \n",
       "\n",
       "      Distance NewRatingPending  \\\n",
       "0  4613.888288            False   \n",
       "1  4617.965824            False   \n",
       "2  4619.656144            False   \n",
       "3  4620.421725            False   \n",
       "4  4620.437179            False   \n",
       "5  4625.565258            False   \n",
       "6  4626.200132            False   \n",
       "7  4632.276890            False   \n",
       "8  4633.934041            False   \n",
       "9  4636.552523            False   \n",
       "\n",
       "                                                meta  \\\n",
       "0  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "1  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "2  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "3  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "4  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "5  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "6  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "7  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "8  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "9  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "\n",
       "                                               links  \n",
       "0  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "1  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "2  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "3  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "4  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "5  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "6  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "7  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "8  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "9  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "\n",
       "[10 rows x 28 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the result to a Pandas DataFrame\n",
    "hygiene_20_df = pd.DataFrame(result)\n",
    "\n",
    "# Display the number of rows in the DataFrame\n",
    "print(f\"Number of rows: {len(hygiene_20_df)}\")\n",
    "# Display the first 10 rows of the DataFrame\n",
    "hygiene_20_df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ef4395a",
   "metadata": {},
   "source": [
    "### 2. Which establishments in London have a `RatingValue` greater than or equal to 4?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "afb8aeb0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'_id': ObjectId('641490153cf154af4135f78d'),\n",
       " 'FHRSID': 1043695,\n",
       " 'ChangesByServerID': 0,\n",
       " 'LocalAuthorityBusinessID': 'PI/000073616',\n",
       " 'BusinessName': 'The Pavilion',\n",
       " 'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       " 'BusinessTypeID': 1,\n",
       " 'AddressLine1': 'East Cliff Pavilion',\n",
       " 'AddressLine2': 'Wear Bay Road',\n",
       " 'AddressLine3': 'Folkestone',\n",
       " 'AddressLine4': 'Kent',\n",
       " 'PostCode': 'CT19 6BL',\n",
       " 'Phone': '',\n",
       " 'RatingValue': Decimal128('5'),\n",
       " 'RatingKey': 'fhrs_5_en-gb',\n",
       " 'RatingDate': '2018-04-04T00:00:00',\n",
       " 'LocalAuthorityCode': '188',\n",
       " 'LocalAuthorityName': 'Folkestone and Hythe',\n",
       " 'LocalAuthorityWebSite': 'http://www.folkestone-hythe.gov.uk',\n",
       " 'LocalAuthorityEmailAddress': 'foodteam@folkestone-hythe.gov.uk',\n",
       " 'scores': {'Hygiene': 5,\n",
       "  'Structural': 5,\n",
       "  'ConfidenceInManagement': 5,\n",
       "  'Hygeine': None},\n",
       " 'SchemeType': 'FHRS',\n",
       " 'geocode': {'longitude': Decimal128('1.195625'),\n",
       "  'latitude': Decimal128('51.083812')},\n",
       " 'RightToReply': '',\n",
       " 'Distance': 4591.765489457773,\n",
       " 'NewRatingPending': False,\n",
       " 'meta': {'dataSource': None,\n",
       "  'extractDate': '0001-01-01T00:00:00',\n",
       "  'itemCount': 0,\n",
       "  'returncode': None,\n",
       "  'totalCount': 0,\n",
       "  'totalPages': 0,\n",
       "  'pageSize': 0,\n",
       "  'pageNumber': 0},\n",
       " 'links': [{'rel': 'self',\n",
       "   'href': 'https://api.ratings.food.gov.uk/establishments/1043695'}]}"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "establishments.find_one()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "169bf147",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'_id': ObjectId('641490153cf154af41362cdb'),\n",
       "  'FHRSID': 621707,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000025307',\n",
       "  'BusinessName': \"Charlie's\",\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Oak Apple Farm Building 103 Sheernes Docks',\n",
       "  'AddressLine2': 'Sheppy Kent',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'ME12',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '4',\n",
       "  'RatingKey': 'fhrs_4_en-gb',\n",
       "  'RatingDate': '2021-10-18T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 5,\n",
       "   'Structural': 10,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.508551'),\n",
       "   'latitude': Decimal128('51.369321')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4627.439467780196,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'https://api.ratings.food.gov.uk/establishments/621707'}]},\n",
       " {'_id': ObjectId('641490153cf154af41363001'),\n",
       "  'FHRSID': 1130836,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000034075',\n",
       "  'BusinessName': 'Mv City Cruises Erasmus',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Cherry Garden Pier',\n",
       "  'AddressLine2': 'Cherry Garden Street Rotherhithe',\n",
       "  'AddressLine3': 'Charlton',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'TN4 8HR',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-05-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.249255999922752'),\n",
       "   'latitude': Decimal128('51.1236228942871')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4627.8731788858,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1130836'}]},\n",
       " {'_id': ObjectId('641490153cf154af41363b4e'),\n",
       "  'FHRSID': 293783,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000002614',\n",
       "  'BusinessName': 'Benfleet Motor Yacht Club',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Ferry Road',\n",
       "  'AddressLine2': 'South Benfleet Essex',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'SS7 1NF',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '4',\n",
       "  'RatingKey': 'fhrs_4_en-gb',\n",
       "  'RatingDate': '2018-11-02T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 10,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.561954'),\n",
       "   'latitude': Decimal128('51.543831')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4631.968418191259,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/293783'}]},\n",
       " {'_id': ObjectId('641490153cf154af4136415b'),\n",
       "  'FHRSID': 1523645,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000038853',\n",
       "  'BusinessName': 'Gourmet Kitchen',\n",
       "  'BusinessType': 'Takeaway/sandwich shop',\n",
       "  'BusinessTypeID': 7844,\n",
       "  'AddressLine1': '1 London Gateway',\n",
       "  'AddressLine2': 'London Gateway Drive Stanford-Le-Hope',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'SS17 9DY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '3',\n",
       "  'RatingKey': 'fhrs_3_en-gb',\n",
       "  'RatingDate': '2022-05-05T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 5,\n",
       "   'Structural': 10,\n",
       "   'ConfidenceInManagement': 10,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.4596371'),\n",
       "   'latitude': Decimal128('51.5100659')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4634.42812137316,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1523645'}]},\n",
       " {'_id': ObjectId('641490153cf154af4136494d'),\n",
       "  'FHRSID': 294474,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000014647',\n",
       "  'BusinessName': 'Tilbury Seafarers Centre',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'Tenants Row Tilbury Docks',\n",
       "  'AddressLine2': 'Tilbury Essex',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'RM18 7EH',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-11-02T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.346325'),\n",
       "   'latitude': Decimal128('51.464078')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4636.847649796817,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/294474'}]},\n",
       " {'_id': ObjectId('641490153cf154af4136494e'),\n",
       "  'FHRSID': 1315095,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000036464',\n",
       "  'BusinessName': 'Coombs Catering t/a The Lock and Key',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'Leslie Ford House',\n",
       "  'AddressLine2': 'Tilbury',\n",
       "  'AddressLine3': 'Charlton',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'RM18 7EH',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2020-12-04T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.346336990594864'),\n",
       "   'latitude': Decimal128('51.4640655517578')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4636.846754121153,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1315095'}]},\n",
       " {'_id': ObjectId('641490163cf154af41365056'),\n",
       "  'FHRSID': 294900,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000019066',\n",
       "  'BusinessName': 'Mv Valulla',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Reeds River Cruises LtdKings ReachRiver ThamesSouthwark',\n",
       "  'AddressLine2': 'London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'RM15 5QY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2016-08-23T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.287555'),\n",
       "   'latitude': Decimal128('51.504071')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4640.460834256174,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/294900'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367160'),\n",
       "  'FHRSID': 1252616,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000035653',\n",
       "  'BusinessName': 'Froottree',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Tereza Joanne King George V Lock',\n",
       "  'AddressLine2': 'Woolwich Manor Way London',\n",
       "  'AddressLine3': 'Charlton',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2NJ',\n",
       "  'Phone': '',\n",
       "  'RatingValue': 'AwaitingInspection',\n",
       "  'RatingKey': 'fhrs_awaitinginspection_en-gb',\n",
       "  'RatingDate': '1901-01-01T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': None,\n",
       "   'Structural': None,\n",
       "   'ConfidenceInManagement': None,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0693250000476837'),\n",
       "   'latitude': Decimal128('51.5011100769043')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4648.300000043045,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1252616'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367163'),\n",
       "  'FHRSID': 293756,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000002538',\n",
       "  'BusinessName': 'Tereza Joanne',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Funcraft UK Ltd King George V Dock Woolwich Manor Way',\n",
       "  'AddressLine2': 'London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2NJ',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-07-09T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.069286'),\n",
       "   'latitude': Decimal128('51.501121')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4648.301822363946,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/293756'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367529'),\n",
       "  'FHRSID': 878523,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000029844',\n",
       "  'BusinessName': 'Brick Lane Brews',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'Air side London City Airport',\n",
       "  'AddressLine2': 'London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PX',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '4',\n",
       "  'RatingKey': 'fhrs_4_en-gb',\n",
       "  'RatingDate': '2019-01-18T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 10,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.048006'),\n",
       "   'latitude': Decimal128('51.503733')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.1734848484375,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/878523'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367534'),\n",
       "  'FHRSID': 902473,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000029852',\n",
       "  'BusinessName': 'Pret A Manger',\n",
       "  'BusinessType': 'Takeaway/sandwich shop',\n",
       "  'BusinessTypeID': 7844,\n",
       "  'AddressLine1': 'Retail Unit 2 Gate 3',\n",
       "  'AddressLine2': 'West Pier London City Airport',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PX',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '2',\n",
       "  'RatingKey': 'fhrs_2_en-gb',\n",
       "  'RatingDate': '2021-12-06T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 5,\n",
       "   'Structural': 15,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.048006'),\n",
       "   'latitude': Decimal128('51.503733')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.1734848484375,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/902473'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367543'),\n",
       "  'FHRSID': 294606,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000016185',\n",
       "  'BusinessName': 'WH Smith',\n",
       "  'BusinessType': 'Retailers - other',\n",
       "  'BusinessTypeID': 4613,\n",
       "  'AddressLine1': 'London City Airport',\n",
       "  'AddressLine2': 'Silvertown London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PX',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2017-07-17T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0479655750095844'),\n",
       "   'latitude': Decimal128('51.5041122436523')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.188850403149,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/294606'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367546'),\n",
       "  'FHRSID': 295105,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000020747',\n",
       "  'BusinessName': 'Cabin Bar',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'London City Airport',\n",
       "  'AddressLine2': 'Airside Outside Ledger Building London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PX',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '2',\n",
       "  'RatingKey': 'fhrs_2_en-gb',\n",
       "  'RatingDate': '2022-06-30T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 10,\n",
       "   'Structural': 15,\n",
       "   'ConfidenceInManagement': 10,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.047966'),\n",
       "   'latitude': Decimal128('51.504112')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.188825980348,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/295105'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367547'),\n",
       "  'FHRSID': 293772,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000002585',\n",
       "  'BusinessName': 'The Nuance Group (UK) Limited',\n",
       "  'BusinessType': 'Retailers - other',\n",
       "  'BusinessTypeID': 4613,\n",
       "  'AddressLine1': 'Duty Free Shop Passenger Terminal',\n",
       "  'AddressLine2': 'London City AirportRoyal DocksLondon',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PX',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2017-07-17T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.047966'),\n",
       "   'latitude': Decimal128('51.504112')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.188825980348,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/293772'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367548'),\n",
       "  'FHRSID': 295107,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000020749',\n",
       "  'BusinessName': 'City Bar & Grill',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'London City Airport (Airside)',\n",
       "  'AddressLine2': 'London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PX',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-12-06T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0479655750095844'),\n",
       "   'latitude': Decimal128('51.5041122436523')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.188850403149,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/295107'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367725'),\n",
       "  'FHRSID': 294523,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000015222',\n",
       "  'BusinessName': 'Jet Centre',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'London City Airport',\n",
       "  'AddressLine2': 'Royal Docks London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PJ',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2022-02-11T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0405181497335434'),\n",
       "   'latitude': Decimal128('51.5048065185547')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.48586971274,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/294523'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367727'),\n",
       "  'FHRSID': 294616,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000016269',\n",
       "  'BusinessName': 'Caffè Nero',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': 1,\n",
       "  'AddressLine1': 'London City Airport Airside Departure Lounge',\n",
       "  'AddressLine2': 'Royal Docks London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 2PJ',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-11-12T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 5,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.040518'),\n",
       "   'latitude': Decimal128('51.504808')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4649.485929427517,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/294616'}]},\n",
       " {'_id': ObjectId('641490163cf154af413679c4'),\n",
       "  'FHRSID': 1427985,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000037871',\n",
       "  'BusinessName': 'Mv Sunborn Yacht Hotel',\n",
       "  'BusinessType': 'Hotel/bed & breakfast/guest house',\n",
       "  'BusinessTypeID': 7842,\n",
       "  'AddressLine1': 'Western Gateway',\n",
       "  'AddressLine2': 'Royal Victoria Dock',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 1XL',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-11-19T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 5,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.027107'),\n",
       "   'latitude': Decimal128('51.50817')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.0981296859945,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1427985'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367bd8'),\n",
       "  'FHRSID': 934211,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000030457',\n",
       "  'BusinessName': 'Good Hotel London',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Western Gateway Royal Victoria Dock',\n",
       "  'AddressLine2': 'Floating Platform next to Emirates Cable Car',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 1FA',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-07-16T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 5,\n",
       "   'Structural': 5,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.01792'),\n",
       "   'latitude': Decimal128('51.507681')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.415301460256,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/934211'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367bf7'),\n",
       "  'FHRSID': 1392440,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000037382',\n",
       "  'BusinessName': 'La Nonna lina',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Dock Road',\n",
       "  'AddressLine2': 'London',\n",
       "  'AddressLine3': 'Charlton',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 1AG',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '4',\n",
       "  'RatingKey': 'fhrs_4_en-gb',\n",
       "  'RatingDate': '2021-10-01T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 10,\n",
       "   'ConfidenceInManagement': 5,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0157549995929003'),\n",
       "   'latitude': Decimal128('51.5059814453125')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.4320658321685,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1392440'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367bfa'),\n",
       "  'FHRSID': 558640,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000024155',\n",
       "  'BusinessName': 'Wake Up Docklands Limited',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Western Beach Royal Victoria Docks',\n",
       "  'AddressLine2': 'London',\n",
       "  'AddressLine3': 'Charlton',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E16 1AG',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-11-05T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.015742'),\n",
       "   'latitude': Decimal128('51.505992')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.432926312135,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/558640'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367dbc'),\n",
       "  'FHRSID': 1498024,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000038347',\n",
       "  'BusinessName': 'MV Venus Clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Trinity Buoy Wharf',\n",
       "  'AddressLine2': 'Orchard Place',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2022-02-25T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.00890800673629534'),\n",
       "   'latitude': Decimal128('51.507771887145')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.747348950763,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1498024'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e0a'),\n",
       "  'FHRSID': 1090023,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033479',\n",
       "  'BusinessName': 'MV Jupiter clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090023'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e0b'),\n",
       "  'FHRSID': 1090021,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033477',\n",
       "  'BusinessName': 'MV Monsoon clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090021'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e0c'),\n",
       "  'FHRSID': 1090017,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033472',\n",
       "  'BusinessName': 'MV Moon clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers 3rd flr Clippers House',\n",
       "  'AddressLine2': 'Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-09-25T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0078159999102354'),\n",
       "   'latitude': Decimal128('51.5082588195801')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805001170512,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090017'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e0d'),\n",
       "  'FHRSID': 1090022,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033478',\n",
       "  'BusinessName': 'MV Meteor clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090022'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e0e'),\n",
       "  'FHRSID': 1090019,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033475',\n",
       "  'BusinessName': 'MV Tornado clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-05-02T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090019'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e0f'),\n",
       "  'FHRSID': 1090018,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033473',\n",
       "  'BusinessName': 'MV Mercury clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers 3rd flr Clippers House',\n",
       "  'AddressLine2': 'Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0078159999102354'),\n",
       "   'latitude': Decimal128('51.5082588195801')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805001170512,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090018'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e10'),\n",
       "  'FHRSID': 1090020,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033476',\n",
       "  'BusinessName': 'MV Typhoon clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090020'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e11'),\n",
       "  'FHRSID': 1090027,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033483',\n",
       "  'BusinessName': 'MV Cyclone clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090027'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e12'),\n",
       "  'FHRSID': 1090025,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033481',\n",
       "  'BusinessName': 'MV Hurricane clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090025'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e13'),\n",
       "  'FHRSID': 1090028,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033484',\n",
       "  'BusinessName': 'MV Neptune clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-05-02T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090028'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e14'),\n",
       "  'FHRSID': 1090016,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033470',\n",
       "  'BusinessName': 'MV Sun clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers 3rd flr Clippers House',\n",
       "  'AddressLine2': 'Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-12-14T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.0078159999102354'),\n",
       "   'latitude': Decimal128('51.5082588195801')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805001170512,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090016'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e15'),\n",
       "  'FHRSID': 1090026,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033482',\n",
       "  'BusinessName': 'MV Aurora clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2021-12-03T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090026'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e16'),\n",
       "  'FHRSID': 1450220,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000038259',\n",
       "  'BusinessName': 'Canary Wharf 1V',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Trinity Buoy Wharf',\n",
       "  'AddressLine2': '64 Orchard Place',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2022-02-25T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007815'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805044246847,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1450220'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e17'),\n",
       "  'FHRSID': 1090024,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000033480',\n",
       "  'BusinessName': 'MV Galaxy clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2018-05-02T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/1090024'}]},\n",
       " {'_id': ObjectId('641490163cf154af41367e20'),\n",
       "  'FHRSID': 293758,\n",
       "  'ChangesByServerID': 0,\n",
       "  'LocalAuthorityBusinessID': 'PI/000002546',\n",
       "  'BusinessName': 'Mv Storm Clipper',\n",
       "  'BusinessType': 'Other catering premises',\n",
       "  'BusinessTypeID': 7841,\n",
       "  'AddressLine1': 'Thames Clippers Unit 12 The Riverside Building',\n",
       "  'AddressLine2': '64 Orchard Place Trinity Buoy Wharf London',\n",
       "  'AddressLine3': '',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'E14 0JY',\n",
       "  'Phone': '',\n",
       "  'RatingValue': '5',\n",
       "  'RatingKey': 'fhrs_5_en-gb',\n",
       "  'RatingDate': '2019-01-11T00:00:00',\n",
       "  'LocalAuthorityCode': '508',\n",
       "  'LocalAuthorityName': 'City of London Corporation',\n",
       "  'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
       "  'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
       "  'scores': {'Hygiene': 0,\n",
       "   'Structural': 0,\n",
       "   'ConfidenceInManagement': 0,\n",
       "   'Hygeine': None},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.007816'),\n",
       "   'latitude': Decimal128('51.508259')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4650.805007769328,\n",
       "  'NewRatingPending': False,\n",
       "  'meta': {'dataSource': None,\n",
       "   'extractDate': '0001-01-01T00:00:00',\n",
       "   'itemCount': 0,\n",
       "   'returncode': None,\n",
       "   'totalCount': 0,\n",
       "   'totalPages': 0,\n",
       "   'pageSize': 0,\n",
       "   'pageNumber': 0},\n",
       "  'links': [{'rel': 'self',\n",
       "    'href': 'http://api.ratings.food.gov.uk/establishments/293758'}]}]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#testing the queries\n",
    "list(establishments.find({'LocalAuthorityName' :{'$regex': \"London\"}}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "d16c2e36",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#### NOTE TO GRADER, I accidentally re-ran this cell after updating ratingValue to numeric, so it's showing as if it returned nothing. However, originally this cell returned a value showing that ratingValue was a string\n",
    "#testing the queries\n",
    "#RatingValue is stored as a string, will need to update all RatingValue entries to int in order to do comparisons (greater than or eq)\n",
    "list(establishments.find({'RatingValue': {'$regex': '4'}}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "116274d0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'_id': ObjectId('641490153cf154af4135f78d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f78e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f78f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f792'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f793'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f794'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f795'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f796'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f797'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f798'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f799'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f79a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f79b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f79c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f79d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f79e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f79f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7a9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7aa'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ab'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ac'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ad'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ae'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7af'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b6'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7b9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ba'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7bc'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f7bd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7be'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7bf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7c8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ca'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7cb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7cc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7cd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ce'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7cf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7d1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7d2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7d3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7d5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7d6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7d9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7da'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7db'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7dc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7dd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7de'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7df'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e0'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7e9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ea'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7eb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ec'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ed'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ee'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7f9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7fa'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7fb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7fc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7fd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7fe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f7ff'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f800'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f801'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f802'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f803'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f804'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f805'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f806'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f807'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f808'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f809'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f80a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f80b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f80c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f80d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f80e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f80f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f810'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f811'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f812'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f813'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f814'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f815'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f816'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f817'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f818'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f819'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f81a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f81b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f81c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f81d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f81e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f81f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f820'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f821'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f822'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f823'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f824'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f825'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f826'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f827'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f828'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f829'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f82a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f82b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f82c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f82d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f82e'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f82f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f830'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f833'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f834'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f835'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f836'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f837'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f838'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f839'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f83a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f83b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f83c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f83d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f83e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f83f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f840'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f841'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f842'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f843'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f844'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f846'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f847'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f848'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f849'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f84a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f84b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f84c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f84d'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f84e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f84f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f850'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f852'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f853'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f854'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f855'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f856'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f857'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f858'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f859'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f85a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f85b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f85c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f85d'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f85e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f85f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f860'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f861'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f862'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f863'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f864'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f865'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f866'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f867'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f868'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f869'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f86a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f86b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f86c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f86d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f86e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f86f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f870'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f871'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f872'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f873'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f874'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f875'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f876'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f877'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f878'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f879'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f87a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f87b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f87c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f87d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f87e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f87f'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f880'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f881'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f882'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f883'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f884'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f885'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f886'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f887'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f888'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f889'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f88a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f88b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f88c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f88d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f88e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f88f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f890'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f891'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f892'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f893'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f894'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f895'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f896'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f897'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f898'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f899'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f89a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f89b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f89c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f89d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f89e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f89f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8a9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8aa'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ab'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ac'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ad'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ae'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8af'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8b9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ba'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8bb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8bc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8bd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8be'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8bf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8c9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ca'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8cb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8cd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ce'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8cf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d8'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f8d9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8da'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8db'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f8dc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8de'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8e9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ea'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ec'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8f1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8f2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8f3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8f5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8f8'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f8f9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8fe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f8ff'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f900'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f901'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f902'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f903'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f904'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f905'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f906'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f907'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f908'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f909'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f90a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f90b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f90c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f90e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f90f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f910'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f911'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f912'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f913'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f914'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f915'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f916'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f917'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f918'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f919'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f91a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f91b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f91c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f91d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f91e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f91f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f920'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f922'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f923'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f924'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f926'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f927'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f928'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f929'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f92a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f92b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f92c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f92d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f92e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f92f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f930'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f931'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f932'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f933'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f934'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f935'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f936'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f938'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f939'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f93b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f93e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f93f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f940'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f941'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f942'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f944'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f945'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f946'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f947'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f948'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f949'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f94a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f94b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f94c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f94d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f94e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f94f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f950'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f951'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f952'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f953'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f954'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f955'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f956'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f957'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f958'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f959'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f95a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f95b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f95c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f95d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f95e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f95f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f960'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f961'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f962'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f963'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f964'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f965'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f966'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f967'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f968'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f969'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f96a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f96b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f96c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f96d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f96e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f96f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f971'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f972'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f973'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f974'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f975'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f976'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f977'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f978'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f979'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f97a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f97b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f97c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f97d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f97e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f97f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f980'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f981'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f982'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f983'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f984'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f985'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f986'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f987'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f988'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f989'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f98a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f98b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f98c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f98d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f98e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f98f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f990'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f992'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f993'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f994'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f995'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f996'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f997'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f998'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f999'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f99a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f99b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f99c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f99d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f99e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f99f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9a9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9aa'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ab'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ac'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ad'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ae'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9af'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9b9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ba'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9bb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9bc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9bd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9be'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9bf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9c9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ca'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9cb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9cc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9cd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ce'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9d9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9da'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9db'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9dc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9dd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9de'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9df'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e7'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9e9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ea'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9eb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ec'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ed'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ee'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ef'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f5'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9f9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9fa'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9fb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9fc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9fd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9fe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135f9ff'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa00'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa01'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa02'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa03'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa04'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa05'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa06'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa07'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa08'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa09'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa0a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa0b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa0c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa0d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa0e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa0f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa10'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa11'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa12'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa13'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa14'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa15'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa16'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa17'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa18'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa19'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa1a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa1b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa1c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa1d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa1e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa1f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa20'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa21'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa22'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa23'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa24'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa25'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa26'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa27'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa28'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa29'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa2a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa2b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa2c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa2d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa2e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa2f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa30'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa31'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa32'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa33'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa34'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa35'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa36'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa37'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa38'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa39'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa3a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa3b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa3c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa3d'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa3e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa3f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa40'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa41'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa42'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa43'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa44'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa45'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa46'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa47'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa48'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa49'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa4a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa4b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa4c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa4d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa4e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa4f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa50'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa51'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa52'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa53'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa54'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa55'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa56'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa57'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa58'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa59'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa5a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa5b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa5d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa5e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa5f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa60'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa61'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa62'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa63'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa64'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa65'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa66'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa67'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa68'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa69'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa6a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa6b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa6c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa6d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa6e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa6f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa70'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa71'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa72'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa73'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa74'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa75'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa77'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa78'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa79'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa7b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa7c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa7d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa7f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa80'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa81'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa82'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa83'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa84'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa85'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa86'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa87'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa88'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa89'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa8a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa8d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa8e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa8f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa91'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa92'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa93'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa94'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa95'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa96'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa97'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa98'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa99'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa9a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa9b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa9c'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fa9d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa9e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fa9f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faa9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faaa'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faab'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faac'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faad'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faae'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fab9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faba'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fabb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fabc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fabd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fabe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fabf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fac8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135facb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135facc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135face'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135facf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fad9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fadb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fadc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fade'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fadf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fae0'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fae2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fae3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fae4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fae8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fae9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faeb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faec'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faed'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faee'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faef'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faf2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faf5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faf6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faf7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faf9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fafb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fafd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fafe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135faff'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb01'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb03'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb04'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb05'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb06'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb07'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb08'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb09'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb0a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb0b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb0c'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb0d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb11'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb16'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb17'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb1d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb1e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb21'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb22'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb23'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb25'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb27'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb28'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb29'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb2b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb30'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb32'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb35'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb37'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb38'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb3a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb3b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb3c'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb42'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb43'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb44'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb45'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb46'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb47'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb4f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb50'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb51'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb56'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb59'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb5a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb5f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb60'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb63'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb64'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb66'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb67'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb68'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb69'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb6b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb6c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb6d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb6e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb6f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb70'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb71'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb72'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb74'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb75'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb76'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fb77'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb78'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb7b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb7c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb7d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb7e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb80'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb81'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb83'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb84'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb85'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb86'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb87'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb88'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb89'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb8a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb8b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb8c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb8d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb8e'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb8f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb90'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb91'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb92'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb93'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb95'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb97'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb98'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb99'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb9a'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb9b'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb9c'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb9d'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fb9f'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fba9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbab'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbac'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbad'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbae'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbaf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbb9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbba'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbbb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbbc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbbd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbbe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbc9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbca'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbcb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbcc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbcd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbce'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbcf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbd9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbda'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbdb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbdc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbdd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbde'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbdf'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe7'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbe9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbeb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbec'), 'RatingValue': False},\n",
       " {'_id': ObjectId('641490153cf154af4135fbed'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbee'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbef'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf0'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf1'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf2'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf3'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf4'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf5'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf6'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf7'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf8'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbf9'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbfa'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbfb'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbfc'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbfd'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbfe'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fbff'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fc00'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fc02'), 'RatingValue': True},\n",
       " {'_id': ObjectId('641490153cf154af4135fc03'), 'RatingValue': True},\n",
       " ...]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#the next several cells are data cleanup, turning all non-numeric strings in RatingValue to '0'\n",
    "#this output verifies that all RatingValues are now numeric (note that the next several cells were needed in order to convert all string entries to numbers)\n",
    "list(establishments.aggregate([{\n",
    "    \n",
    "    '$project': \n",
    "        {\n",
    "\n",
    "                'RatingValue': {'$isNumber': '$RatingValue'}\n",
    "                 \n",
    "        }\n",
    "     \n",
    "}]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "abfec57a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d3feab200>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all RatingValues to decimal\n",
    "establishments.update_many({}, [ {'$set':{'RatingValue': {'$toDecimal': '$RatingValue'} }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "75a8b245",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d3b2ee2c0>"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all empty RatingValues to 0\n",
    "establishments.update_many({'RatingValue':''}, [ {'$set':{'RatingValue': 0 }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "6406c0ab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d3dde99c0>"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all 'AwaitingInspection' Rating Values to None\n",
    "establishments.update_many({'RatingValue':'AwaitingInspection'}, [ {'$set':{'RatingValue': None }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "cc89fec4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d397bad40>"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all 'Awaiting Inspection' Rating Values to None\n",
    "establishments.update_many({'RatingValue':'Awaiting Inspection'}, [ {'$set':{'RatingValue': None }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "82d4256e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d410039c0>"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all 'Exempt' Rating Values to None\n",
    "establishments.update_many({'RatingValue':'Exempt'}, [ {'$set':{'RatingValue': None }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "5e6b064c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d397bac00>"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all 'AwaitingPublication' Rating Values to None\n",
    "establishments.update_many({'RatingValue':'AwaitingPublication'}, [ {'$set':{'RatingValue': None }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "1f465f0d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x20d41008400>"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#set all 'Pass' Rating Values to None\n",
    "establishments.update_many({'RatingValue':'Pass'}, [ {'$set':{'RatingValue': None }}])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "7ae092d4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31257"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#testing that 'RatingValue' can now be compared numerically\n",
    "len(list(establishments.find({'RatingValue': {'$gte': 4}})))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "93c63829",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "33\n",
      "{'AddressLine1': 'Oak Apple Farm Building 103 Sheernes Docks',\n",
      " 'AddressLine2': 'Sheppy Kent',\n",
      " 'AddressLine3': '',\n",
      " 'AddressLine4': '',\n",
      " 'BusinessName': \"Charlie's\",\n",
      " 'BusinessType': 'Other catering premises',\n",
      " 'BusinessTypeID': 7841,\n",
      " 'ChangesByServerID': 0,\n",
      " 'Distance': 4627.439467780196,\n",
      " 'FHRSID': 621707,\n",
      " 'LocalAuthorityBusinessID': 'PI/000025307',\n",
      " 'LocalAuthorityCode': '508',\n",
      " 'LocalAuthorityEmailAddress': 'publicprotection@cityoflondon.gov.uk',\n",
      " 'LocalAuthorityName': 'City of London Corporation',\n",
      " 'LocalAuthorityWebSite': 'http://www.cityoflondon.gov.uk/Corporation/homepage.htm',\n",
      " 'NewRatingPending': False,\n",
      " 'Phone': '',\n",
      " 'PostCode': 'ME12',\n",
      " 'RatingDate': '2021-10-18T00:00:00',\n",
      " 'RatingKey': 'fhrs_4_en-gb',\n",
      " 'RatingValue': Decimal128('4'),\n",
      " 'RightToReply': '',\n",
      " 'SchemeType': 'FHRS',\n",
      " '_id': ObjectId('641490153cf154af41362cdb'),\n",
      " 'geocode': {'latitude': Decimal128('51.369321'),\n",
      "             'longitude': Decimal128('0.508551')},\n",
      " 'links': [{'href': 'https://api.ratings.food.gov.uk/establishments/621707',\n",
      "            'rel': 'self'}],\n",
      " 'meta': {'dataSource': None,\n",
      "          'extractDate': '0001-01-01T00:00:00',\n",
      "          'itemCount': 0,\n",
      "          'pageNumber': 0,\n",
      "          'pageSize': 0,\n",
      "          'returncode': None,\n",
      "          'totalCount': 0,\n",
      "          'totalPages': 0},\n",
      " 'scores': {'ConfidenceInManagement': 5, 'Hygiene': 5, 'Structural': 10}}\n"
     ]
    }
   ],
   "source": [
    "# Find the establishments with London as the Local Authority and has a RatingValue greater than or equal to 4.\n",
    "query = {'LocalAuthorityName' :{'$regex': \"London\"},\n",
    "         'RatingValue': {'$gte': 4}\n",
    "         }\n",
    "results = list(establishments.find(query))\n",
    "# Use count_documents to display the number of documents in the result\n",
    "print(establishments.count_documents(query))\n",
    "# Display the first document in the results using pprint\n",
    "pprint(results[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "07e24ccb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of rows: 33\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>FHRSID</th>\n",
       "      <th>ChangesByServerID</th>\n",
       "      <th>LocalAuthorityBusinessID</th>\n",
       "      <th>BusinessName</th>\n",
       "      <th>BusinessType</th>\n",
       "      <th>BusinessTypeID</th>\n",
       "      <th>AddressLine1</th>\n",
       "      <th>AddressLine2</th>\n",
       "      <th>AddressLine3</th>\n",
       "      <th>...</th>\n",
       "      <th>LocalAuthorityWebSite</th>\n",
       "      <th>LocalAuthorityEmailAddress</th>\n",
       "      <th>scores</th>\n",
       "      <th>SchemeType</th>\n",
       "      <th>geocode</th>\n",
       "      <th>RightToReply</th>\n",
       "      <th>Distance</th>\n",
       "      <th>NewRatingPending</th>\n",
       "      <th>meta</th>\n",
       "      <th>links</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>641490153cf154af41362cdb</td>\n",
       "      <td>621707</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000025307</td>\n",
       "      <td>Charlie's</td>\n",
       "      <td>Other catering premises</td>\n",
       "      <td>7841</td>\n",
       "      <td>Oak Apple Farm Building 103 Sheernes Docks</td>\n",
       "      <td>Sheppy Kent</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 5, 'Structural': 10, 'ConfidenceIn...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.508551, 'latitude': 51.369321}</td>\n",
       "      <td></td>\n",
       "      <td>4627.439468</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'https://api.ratings....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>641490153cf154af41363001</td>\n",
       "      <td>1130836</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000034075</td>\n",
       "      <td>Mv City Cruises Erasmus</td>\n",
       "      <td>Other catering premises</td>\n",
       "      <td>7841</td>\n",
       "      <td>Cherry Garden Pier</td>\n",
       "      <td>Cherry Garden Street Rotherhithe</td>\n",
       "      <td>Charlton</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.249255999922752, 'latitude': 5...</td>\n",
       "      <td></td>\n",
       "      <td>4627.873179</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>641490153cf154af41363b4e</td>\n",
       "      <td>293783</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000002614</td>\n",
       "      <td>Benfleet Motor Yacht Club</td>\n",
       "      <td>Other catering premises</td>\n",
       "      <td>7841</td>\n",
       "      <td>Ferry Road</td>\n",
       "      <td>South Benfleet Essex</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.561954, 'latitude': 51.543831}</td>\n",
       "      <td></td>\n",
       "      <td>4631.968418</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>641490153cf154af4136494d</td>\n",
       "      <td>294474</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000014647</td>\n",
       "      <td>Tilbury Seafarers Centre</td>\n",
       "      <td>Restaurant/Cafe/Canteen</td>\n",
       "      <td>1</td>\n",
       "      <td>Tenants Row Tilbury Docks</td>\n",
       "      <td>Tilbury Essex</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.346325, 'latitude': 51.464078}</td>\n",
       "      <td></td>\n",
       "      <td>4636.847650</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>641490153cf154af4136494e</td>\n",
       "      <td>1315095</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000036464</td>\n",
       "      <td>Coombs Catering t/a The Lock and Key</td>\n",
       "      <td>Restaurant/Cafe/Canteen</td>\n",
       "      <td>1</td>\n",
       "      <td>Leslie Ford House</td>\n",
       "      <td>Tilbury</td>\n",
       "      <td>Charlton</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.346336990594864, 'latitude': 5...</td>\n",
       "      <td></td>\n",
       "      <td>4636.846754</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>641490163cf154af41365056</td>\n",
       "      <td>294900</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000019066</td>\n",
       "      <td>Mv Valulla</td>\n",
       "      <td>Other catering premises</td>\n",
       "      <td>7841</td>\n",
       "      <td>Reeds River Cruises LtdKings ReachRiver Thames...</td>\n",
       "      <td>London</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.287555, 'latitude': 51.504071}</td>\n",
       "      <td></td>\n",
       "      <td>4640.460834</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>641490163cf154af41367163</td>\n",
       "      <td>293756</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000002538</td>\n",
       "      <td>Tereza Joanne</td>\n",
       "      <td>Other catering premises</td>\n",
       "      <td>7841</td>\n",
       "      <td>Funcraft UK Ltd King George V Dock Woolwich Ma...</td>\n",
       "      <td>London</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.069286, 'latitude': 51.501121}</td>\n",
       "      <td></td>\n",
       "      <td>4648.301822</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>641490163cf154af41367529</td>\n",
       "      <td>878523</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000029844</td>\n",
       "      <td>Brick Lane Brews</td>\n",
       "      <td>Restaurant/Cafe/Canteen</td>\n",
       "      <td>1</td>\n",
       "      <td>Air side London City Airport</td>\n",
       "      <td>London</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 10, 'Structural': 5, 'ConfidenceIn...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.048006, 'latitude': 51.503733}</td>\n",
       "      <td></td>\n",
       "      <td>4649.173485</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>641490163cf154af41367543</td>\n",
       "      <td>294606</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000016185</td>\n",
       "      <td>WH Smith</td>\n",
       "      <td>Retailers - other</td>\n",
       "      <td>4613</td>\n",
       "      <td>London City Airport</td>\n",
       "      <td>Silvertown London</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.0479655750095844, 'latitude': ...</td>\n",
       "      <td></td>\n",
       "      <td>4649.188850</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>641490163cf154af41367547</td>\n",
       "      <td>293772</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000002585</td>\n",
       "      <td>The Nuance Group (UK) Limited</td>\n",
       "      <td>Retailers - other</td>\n",
       "      <td>4613</td>\n",
       "      <td>Duty Free Shop Passenger Terminal</td>\n",
       "      <td>London City AirportRoyal DocksLondon</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.cityoflondon.gov.uk/Corporation/hom...</td>\n",
       "      <td>publicprotection@cityoflondon.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.047966, 'latitude': 51.504112}</td>\n",
       "      <td></td>\n",
       "      <td>4649.188826</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        _id   FHRSID  ChangesByServerID  \\\n",
       "0  641490153cf154af41362cdb   621707                  0   \n",
       "1  641490153cf154af41363001  1130836                  0   \n",
       "2  641490153cf154af41363b4e   293783                  0   \n",
       "3  641490153cf154af4136494d   294474                  0   \n",
       "4  641490153cf154af4136494e  1315095                  0   \n",
       "5  641490163cf154af41365056   294900                  0   \n",
       "6  641490163cf154af41367163   293756                  0   \n",
       "7  641490163cf154af41367529   878523                  0   \n",
       "8  641490163cf154af41367543   294606                  0   \n",
       "9  641490163cf154af41367547   293772                  0   \n",
       "\n",
       "  LocalAuthorityBusinessID                          BusinessName  \\\n",
       "0             PI/000025307                             Charlie's   \n",
       "1             PI/000034075               Mv City Cruises Erasmus   \n",
       "2             PI/000002614             Benfleet Motor Yacht Club   \n",
       "3             PI/000014647              Tilbury Seafarers Centre   \n",
       "4             PI/000036464  Coombs Catering t/a The Lock and Key   \n",
       "5             PI/000019066                            Mv Valulla   \n",
       "6             PI/000002538                         Tereza Joanne   \n",
       "7             PI/000029844                      Brick Lane Brews   \n",
       "8             PI/000016185                              WH Smith   \n",
       "9             PI/000002585         The Nuance Group (UK) Limited   \n",
       "\n",
       "              BusinessType  BusinessTypeID  \\\n",
       "0  Other catering premises            7841   \n",
       "1  Other catering premises            7841   \n",
       "2  Other catering premises            7841   \n",
       "3  Restaurant/Cafe/Canteen               1   \n",
       "4  Restaurant/Cafe/Canteen               1   \n",
       "5  Other catering premises            7841   \n",
       "6  Other catering premises            7841   \n",
       "7  Restaurant/Cafe/Canteen               1   \n",
       "8        Retailers - other            4613   \n",
       "9        Retailers - other            4613   \n",
       "\n",
       "                                        AddressLine1  \\\n",
       "0         Oak Apple Farm Building 103 Sheernes Docks   \n",
       "1                                 Cherry Garden Pier   \n",
       "2                                         Ferry Road   \n",
       "3                          Tenants Row Tilbury Docks   \n",
       "4                                  Leslie Ford House   \n",
       "5  Reeds River Cruises LtdKings ReachRiver Thames...   \n",
       "6  Funcraft UK Ltd King George V Dock Woolwich Ma...   \n",
       "7                       Air side London City Airport   \n",
       "8                                London City Airport   \n",
       "9                  Duty Free Shop Passenger Terminal   \n",
       "\n",
       "                           AddressLine2 AddressLine3  ...  \\\n",
       "0                           Sheppy Kent               ...   \n",
       "1      Cherry Garden Street Rotherhithe     Charlton  ...   \n",
       "2                  South Benfleet Essex               ...   \n",
       "3                         Tilbury Essex               ...   \n",
       "4                               Tilbury     Charlton  ...   \n",
       "5                                London               ...   \n",
       "6                                London               ...   \n",
       "7                                London               ...   \n",
       "8                     Silvertown London               ...   \n",
       "9  London City AirportRoyal DocksLondon               ...   \n",
       "\n",
       "                               LocalAuthorityWebSite  \\\n",
       "0  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "1  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "2  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "3  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "4  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "5  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "6  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "7  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "8  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "9  http://www.cityoflondon.gov.uk/Corporation/hom...   \n",
       "\n",
       "             LocalAuthorityEmailAddress  \\\n",
       "0  publicprotection@cityoflondon.gov.uk   \n",
       "1  publicprotection@cityoflondon.gov.uk   \n",
       "2  publicprotection@cityoflondon.gov.uk   \n",
       "3  publicprotection@cityoflondon.gov.uk   \n",
       "4  publicprotection@cityoflondon.gov.uk   \n",
       "5  publicprotection@cityoflondon.gov.uk   \n",
       "6  publicprotection@cityoflondon.gov.uk   \n",
       "7  publicprotection@cityoflondon.gov.uk   \n",
       "8  publicprotection@cityoflondon.gov.uk   \n",
       "9  publicprotection@cityoflondon.gov.uk   \n",
       "\n",
       "                                              scores SchemeType  \\\n",
       "0  {'Hygiene': 5, 'Structural': 10, 'ConfidenceIn...       FHRS   \n",
       "1  {'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...       FHRS   \n",
       "2  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "3  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "4  {'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...       FHRS   \n",
       "5  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "6  {'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...       FHRS   \n",
       "7  {'Hygiene': 10, 'Structural': 5, 'ConfidenceIn...       FHRS   \n",
       "8  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "9  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "\n",
       "                                             geocode RightToReply  \\\n",
       "0     {'longitude': 0.508551, 'latitude': 51.369321}                \n",
       "1  {'longitude': 0.249255999922752, 'latitude': 5...                \n",
       "2     {'longitude': 0.561954, 'latitude': 51.543831}                \n",
       "3     {'longitude': 0.346325, 'latitude': 51.464078}                \n",
       "4  {'longitude': 0.346336990594864, 'latitude': 5...                \n",
       "5     {'longitude': 0.287555, 'latitude': 51.504071}                \n",
       "6     {'longitude': 0.069286, 'latitude': 51.501121}                \n",
       "7     {'longitude': 0.048006, 'latitude': 51.503733}                \n",
       "8  {'longitude': 0.0479655750095844, 'latitude': ...                \n",
       "9     {'longitude': 0.047966, 'latitude': 51.504112}                \n",
       "\n",
       "      Distance NewRatingPending  \\\n",
       "0  4627.439468            False   \n",
       "1  4627.873179            False   \n",
       "2  4631.968418            False   \n",
       "3  4636.847650            False   \n",
       "4  4636.846754            False   \n",
       "5  4640.460834            False   \n",
       "6  4648.301822            False   \n",
       "7  4649.173485            False   \n",
       "8  4649.188850            False   \n",
       "9  4649.188826            False   \n",
       "\n",
       "                                                meta  \\\n",
       "0  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "1  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "2  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "3  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "4  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "5  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "6  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "7  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "8  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "9  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "\n",
       "                                               links  \n",
       "0  [{'rel': 'self', 'href': 'https://api.ratings....  \n",
       "1  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "2  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "3  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "4  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "5  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "6  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "7  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "8  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "9  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "\n",
       "[10 rows x 28 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the result to a Pandas DataFrame\n",
    "london_rating_4_df = pd.DataFrame(results)\n",
    "# Display the number of rows in the DataFrame\n",
    "print(f\"Number of rows: {len(london_rating_4_df)}\")\n",
    "# Display the first 10 rows of the DataFrame\n",
    "london_rating_4_df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4e570caf",
   "metadata": {},
   "source": [
    "### 3. What are the top 5 establishments with a `RatingValue` rating value of '5', sorted by lowest hygiene score, nearest to the new restaurant added, \"Penang Flavours\"?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "3d0fde3d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'_id': ObjectId('6418df9bc58868663d8a9f9f'),\n",
       "  'BusinessName': 'Penang Flavours',\n",
       "  'BusinessType': 'Restaurant/Cafe/Canteen',\n",
       "  'BusinessTypeID': '1',\n",
       "  'AddressLine1': 'Penang Flavours',\n",
       "  'AddressLine2': '146A Plumstead Rd',\n",
       "  'AddressLine3': 'London',\n",
       "  'AddressLine4': '',\n",
       "  'PostCode': 'SE18 7DY',\n",
       "  'Phone': '',\n",
       "  'LocalAuthorityCode': '511',\n",
       "  'LocalAuthorityName': 'Greenwich',\n",
       "  'LocalAuthorityWebSite': 'http://www.royalgreenwich.gov.uk',\n",
       "  'LocalAuthorityEmailAddress': 'health@royalgreenwich.gov.uk',\n",
       "  'scores': {'Hygiene': '', 'Structural': '', 'ConfidenceInManagement': ''},\n",
       "  'SchemeType': 'FHRS',\n",
       "  'geocode': {'longitude': Decimal128('0.08384000'),\n",
       "   'latitude': Decimal128('51.49014200')},\n",
       "  'RightToReply': '',\n",
       "  'Distance': 4623.972328074718,\n",
       "  'NewRatingPending': True,\n",
       "  'RatingValue': None}]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#find penang flavor's lat and lon\n",
    "list(establishments.find({'BusinessName':'Penang Flavours'}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "18fd0baa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'AddressLine1': '130 - 132 Plumstead High Street',\n",
      "  'AddressLine2': '',\n",
      "  'AddressLine3': 'Plumstead',\n",
      "  'AddressLine4': 'Greenwich',\n",
      "  'BusinessName': 'Volunteer',\n",
      "  'BusinessType': 'Pub/bar/nightclub',\n",
      "  'BusinessTypeID': 7843,\n",
      "  'ChangesByServerID': 0,\n",
      "  'Distance': 4646.965634598608,\n",
      "  'FHRSID': 694609,\n",
      "  'LocalAuthorityBusinessID': 'PI/000116619',\n",
      "  'LocalAuthorityCode': '511',\n",
      "  'LocalAuthorityEmailAddress': 'health@royalgreenwich.gov.uk',\n",
      "  'LocalAuthorityName': 'Greenwich',\n",
      "  'LocalAuthorityWebSite': 'http://www.royalgreenwich.gov.uk',\n",
      "  'NewRatingPending': False,\n",
      "  'Phone': '',\n",
      "  'PostCode': 'SE18 1JQ',\n",
      "  'RatingDate': '2019-08-05T00:00:00',\n",
      "  'RatingKey': 'fhrs_5_en-gb',\n",
      "  'RatingValue': Decimal128('5'),\n",
      "  'RightToReply': '',\n",
      "  'SchemeType': 'FHRS',\n",
      "  '_id': ObjectId('641490163cf154af41366b1d'),\n",
      "  'geocode': {'latitude': Decimal128('51.4873437'),\n",
      "              'longitude': Decimal128('0.09208')},\n",
      "  'links': [{'href': 'http://api.ratings.food.gov.uk/establishments/694609',\n",
      "             'rel': 'self'}],\n",
      "  'meta': {'dataSource': None,\n",
      "           'extractDate': '0001-01-01T00:00:00',\n",
      "           'itemCount': 0,\n",
      "           'pageNumber': 0,\n",
      "           'pageSize': 0,\n",
      "           'returncode': None,\n",
      "           'totalCount': 0,\n",
      "           'totalPages': 0},\n",
      "  'scores': {'ConfidenceInManagement': 0, 'Hygiene': 0, 'Structural': 0}},\n",
      " {'AddressLine1': 'Plumstead Manor School Old Mill Road',\n",
      "  'AddressLine2': '',\n",
      "  'AddressLine3': 'Plumstead',\n",
      "  'AddressLine4': 'Greenwich',\n",
      "  'BusinessName': 'Plumstead Manor Nursery',\n",
      "  'BusinessType': 'Caring Premises',\n",
      "  'BusinessTypeID': 5,\n",
      "  'ChangesByServerID': 0,\n",
      "  'Distance': 4646.9740101340385,\n",
      "  'FHRSID': 695241,\n",
      "  'LocalAuthorityBusinessID': 'PI/000179088',\n",
      "  'LocalAuthorityCode': '511',\n",
      "  'LocalAuthorityEmailAddress': 'health@royalgreenwich.gov.uk',\n",
      "  'LocalAuthorityName': 'Greenwich',\n",
      "  'LocalAuthorityWebSite': 'http://www.royalgreenwich.gov.uk',\n",
      "  'NewRatingPending': False,\n",
      "  'Phone': '',\n",
      "  'PostCode': 'SE18 1QG',\n",
      "  'RatingDate': '2021-06-16T00:00:00',\n",
      "  'RatingKey': 'fhrs_5_en-gb',\n",
      "  'RatingValue': Decimal128('5'),\n",
      "  'RightToReply': '',\n",
      "  'SchemeType': 'FHRS',\n",
      "  '_id': ObjectId('641490163cf154af41366b36'),\n",
      "  'geocode': {'latitude': Decimal128('51.481517791748'),\n",
      "              'longitude': Decimal128('0.0859939977526665')},\n",
      "  'links': [{'href': 'http://api.ratings.food.gov.uk/establishments/695241',\n",
      "             'rel': 'self'}],\n",
      "  'meta': {'dataSource': None,\n",
      "           'extractDate': '0001-01-01T00:00:00',\n",
      "           'itemCount': 0,\n",
      "           'pageNumber': 0,\n",
      "           'pageSize': 0,\n",
      "           'returncode': None,\n",
      "           'totalCount': 0,\n",
      "           'totalPages': 0},\n",
      "  'scores': {'ConfidenceInManagement': 5, 'Hygiene': 0, 'Structural': 0}},\n",
      " {'AddressLine1': '35 Lakedale Road',\n",
      "  'AddressLine2': '',\n",
      "  'AddressLine3': 'Plumstead',\n",
      "  'AddressLine4': 'Greenwich',\n",
      "  'BusinessName': 'Atlantic Fish Bar',\n",
      "  'BusinessType': 'Takeaway/sandwich shop',\n",
      "  'BusinessTypeID': 7844,\n",
      "  'ChangesByServerID': 0,\n",
      "  'Distance': 4646.974611855838,\n",
      "  'FHRSID': 694478,\n",
      "  'LocalAuthorityBusinessID': 'PI/000086506',\n",
      "  'LocalAuthorityCode': '511',\n",
      "  'LocalAuthorityEmailAddress': 'health@royalgreenwich.gov.uk',\n",
      "  'LocalAuthorityName': 'Greenwich',\n",
      "  'LocalAuthorityWebSite': 'http://www.royalgreenwich.gov.uk',\n",
      "  'NewRatingPending': False,\n",
      "  'Phone': '',\n",
      "  'PostCode': 'SE18 1PR',\n",
      "  'RatingDate': '2021-06-16T00:00:00',\n",
      "  'RatingKey': 'fhrs_5_en-gb',\n",
      "  'RatingValue': Decimal128('5'),\n",
      "  'RightToReply': '',\n",
      "  'SchemeType': 'FHRS',\n",
      "  '_id': ObjectId('641490163cf154af41366b39'),\n",
      "  'geocode': {'latitude': Decimal128('51.4867296'),\n",
      "              'longitude': Decimal128('0.0912164')},\n",
      "  'links': [{'href': 'http://api.ratings.food.gov.uk/establishments/694478',\n",
      "             'rel': 'self'}],\n",
      "  'meta': {'dataSource': None,\n",
      "           'extractDate': '0001-01-01T00:00:00',\n",
      "           'itemCount': 0,\n",
      "           'pageNumber': 0,\n",
      "           'pageSize': 0,\n",
      "           'returncode': None,\n",
      "           'totalCount': 0,\n",
      "           'totalPages': 0},\n",
      "  'scores': {'ConfidenceInManagement': 5, 'Hygiene': 0, 'Structural': 0}},\n",
      " {'AddressLine1': '144 - 146 Plumstead High Street',\n",
      "  'AddressLine2': '',\n",
      "  'AddressLine3': 'Plumstead',\n",
      "  'AddressLine4': 'Greenwich',\n",
      "  'BusinessName': 'Iceland',\n",
      "  'BusinessType': 'Retailers - supermarkets/hypermarkets',\n",
      "  'BusinessTypeID': 7840,\n",
      "  'ChangesByServerID': 0,\n",
      "  'Distance': 4646.946071297699,\n",
      "  'FHRSID': 695223,\n",
      "  'LocalAuthorityBusinessID': 'PI/000178842',\n",
      "  'LocalAuthorityCode': '511',\n",
      "  'LocalAuthorityEmailAddress': 'health@royalgreenwich.gov.uk',\n",
      "  'LocalAuthorityName': 'Greenwich',\n",
      "  'LocalAuthorityWebSite': 'http://www.royalgreenwich.gov.uk',\n",
      "  'NewRatingPending': False,\n",
      "  'Phone': '',\n",
      "  'PostCode': 'SE18 1JQ',\n",
      "  'RatingDate': '2019-11-13T00:00:00',\n",
      "  'RatingKey': 'fhrs_5_en-gb',\n",
      "  'RatingValue': Decimal128('5'),\n",
      "  'RightToReply': '',\n",
      "  'SchemeType': 'FHRS',\n",
      "  '_id': ObjectId('641490163cf154af41366af2'),\n",
      "  'geocode': {'latitude': Decimal128('51.4871482849121'),\n",
      "              'longitude': Decimal128('0.0924199968576431')},\n",
      "  'links': [{'href': 'http://api.ratings.food.gov.uk/establishments/695223',\n",
      "             'rel': 'self'}],\n",
      "  'meta': {'dataSource': None,\n",
      "           'extractDate': '0001-01-01T00:00:00',\n",
      "           'itemCount': 0,\n",
      "           'pageNumber': 0,\n",
      "           'pageSize': 0,\n",
      "           'returncode': None,\n",
      "           'totalCount': 0,\n",
      "           'totalPages': 0},\n",
      "  'scores': {'ConfidenceInManagement': 5, 'Hygiene': 0, 'Structural': 5}},\n",
      " {'AddressLine1': 'Restaurant And Premises 107A Plumstead High Street',\n",
      "  'AddressLine2': '',\n",
      "  'AddressLine3': 'Plumstead',\n",
      "  'AddressLine4': 'Greenwich',\n",
      "  'BusinessName': 'Howe and Co Fish and Chips - Van 17',\n",
      "  'BusinessType': 'Mobile caterer',\n",
      "  'BusinessTypeID': 7846,\n",
      "  'ChangesByServerID': 0,\n",
      "  'Distance': 4646.95593107927,\n",
      "  'FHRSID': 1380578,\n",
      "  'LocalAuthorityBusinessID': '14425',\n",
      "  'LocalAuthorityCode': '511',\n",
      "  'LocalAuthorityEmailAddress': 'health@royalgreenwich.gov.uk',\n",
      "  'LocalAuthorityName': 'Greenwich',\n",
      "  'LocalAuthorityWebSite': 'http://www.royalgreenwich.gov.uk',\n",
      "  'NewRatingPending': False,\n",
      "  'Phone': '',\n",
      "  'PostCode': 'SE18 1SE',\n",
      "  'RatingDate': '2021-11-11T00:00:00',\n",
      "  'RatingKey': 'fhrs_5_en-gb',\n",
      "  'RatingValue': Decimal128('5'),\n",
      "  'RightToReply': '',\n",
      "  'SchemeType': 'FHRS',\n",
      "  '_id': ObjectId('641490163cf154af41366b08'),\n",
      "  'geocode': {'latitude': Decimal128('51.4875335693359'),\n",
      "              'longitude': Decimal128('0.0925370007753372')},\n",
      "  'links': [{'href': 'http://api.ratings.food.gov.uk/establishments/1380578',\n",
      "             'rel': 'self'}],\n",
      "  'meta': {'dataSource': None,\n",
      "           'extractDate': '0001-01-01T00:00:00',\n",
      "           'itemCount': 0,\n",
      "           'pageNumber': 0,\n",
      "           'pageSize': 0,\n",
      "           'returncode': None,\n",
      "           'totalCount': 0,\n",
      "           'totalPages': 0},\n",
      "  'scores': {'ConfidenceInManagement': 0, 'Hygiene': 0, 'Structural': 0}}]\n"
     ]
    }
   ],
   "source": [
    "#query for question 3\n",
    "#list the top 5 restaurants near penang flavours within the degree search parameters, sorted by hygiene score ascending\n",
    "degree_search = 0.01\n",
    "latitude = 51.49014200\n",
    "longitude = 0.08384000\n",
    "query = {'RatingValue': {'$eq': 5},\n",
    "         'geocode.latitude':{'$gte': (latitude - degree_search), '$lte': (latitude + degree_search)},\n",
    "         'geocode.longitude':{'$gte': (longitude - degree_search), '$lte': (longitude + degree_search)}\n",
    "         }\n",
    "sort =  [('scores.Hygiene', 1)] # for sorting, 1 is ascending, -1 is descending\n",
    "limit = 5\n",
    "results = list(establishments.find(query).sort(sort).limit(limit))\n",
    "pprint(results)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "a6ad16f7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>FHRSID</th>\n",
       "      <th>ChangesByServerID</th>\n",
       "      <th>LocalAuthorityBusinessID</th>\n",
       "      <th>BusinessName</th>\n",
       "      <th>BusinessType</th>\n",
       "      <th>BusinessTypeID</th>\n",
       "      <th>AddressLine1</th>\n",
       "      <th>AddressLine2</th>\n",
       "      <th>AddressLine3</th>\n",
       "      <th>...</th>\n",
       "      <th>LocalAuthorityWebSite</th>\n",
       "      <th>LocalAuthorityEmailAddress</th>\n",
       "      <th>scores</th>\n",
       "      <th>SchemeType</th>\n",
       "      <th>geocode</th>\n",
       "      <th>RightToReply</th>\n",
       "      <th>Distance</th>\n",
       "      <th>NewRatingPending</th>\n",
       "      <th>meta</th>\n",
       "      <th>links</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>641490163cf154af41366b1d</td>\n",
       "      <td>694609</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000116619</td>\n",
       "      <td>Volunteer</td>\n",
       "      <td>Pub/bar/nightclub</td>\n",
       "      <td>7843</td>\n",
       "      <td>130 - 132 Plumstead High Street</td>\n",
       "      <td></td>\n",
       "      <td>Plumstead</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.royalgreenwich.gov.uk</td>\n",
       "      <td>health@royalgreenwich.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.09208, 'latitude': 51.4873437}</td>\n",
       "      <td></td>\n",
       "      <td>4646.965635</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>641490163cf154af41366b36</td>\n",
       "      <td>695241</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000179088</td>\n",
       "      <td>Plumstead Manor Nursery</td>\n",
       "      <td>Caring Premises</td>\n",
       "      <td>5</td>\n",
       "      <td>Plumstead Manor School Old Mill Road</td>\n",
       "      <td></td>\n",
       "      <td>Plumstead</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.royalgreenwich.gov.uk</td>\n",
       "      <td>health@royalgreenwich.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.0859939977526665, 'latitude': ...</td>\n",
       "      <td></td>\n",
       "      <td>4646.974010</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>641490163cf154af41366b39</td>\n",
       "      <td>694478</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000086506</td>\n",
       "      <td>Atlantic Fish Bar</td>\n",
       "      <td>Takeaway/sandwich shop</td>\n",
       "      <td>7844</td>\n",
       "      <td>35 Lakedale Road</td>\n",
       "      <td></td>\n",
       "      <td>Plumstead</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.royalgreenwich.gov.uk</td>\n",
       "      <td>health@royalgreenwich.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.0912164, 'latitude': 51.4867296}</td>\n",
       "      <td></td>\n",
       "      <td>4646.974612</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>641490163cf154af41366af2</td>\n",
       "      <td>695223</td>\n",
       "      <td>0</td>\n",
       "      <td>PI/000178842</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>Retailers - supermarkets/hypermarkets</td>\n",
       "      <td>7840</td>\n",
       "      <td>144 - 146 Plumstead High Street</td>\n",
       "      <td></td>\n",
       "      <td>Plumstead</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.royalgreenwich.gov.uk</td>\n",
       "      <td>health@royalgreenwich.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.0924199968576431, 'latitude': ...</td>\n",
       "      <td></td>\n",
       "      <td>4646.946071</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>641490163cf154af41366b08</td>\n",
       "      <td>1380578</td>\n",
       "      <td>0</td>\n",
       "      <td>14425</td>\n",
       "      <td>Howe and Co Fish and Chips - Van 17</td>\n",
       "      <td>Mobile caterer</td>\n",
       "      <td>7846</td>\n",
       "      <td>Restaurant And Premises 107A Plumstead High St...</td>\n",
       "      <td></td>\n",
       "      <td>Plumstead</td>\n",
       "      <td>...</td>\n",
       "      <td>http://www.royalgreenwich.gov.uk</td>\n",
       "      <td>health@royalgreenwich.gov.uk</td>\n",
       "      <td>{'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...</td>\n",
       "      <td>FHRS</td>\n",
       "      <td>{'longitude': 0.0925370007753372, 'latitude': ...</td>\n",
       "      <td></td>\n",
       "      <td>4646.955931</td>\n",
       "      <td>False</td>\n",
       "      <td>{'dataSource': None, 'extractDate': '0001-01-0...</td>\n",
       "      <td>[{'rel': 'self', 'href': 'http://api.ratings.f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        _id   FHRSID  ChangesByServerID  \\\n",
       "0  641490163cf154af41366b1d   694609                  0   \n",
       "1  641490163cf154af41366b36   695241                  0   \n",
       "2  641490163cf154af41366b39   694478                  0   \n",
       "3  641490163cf154af41366af2   695223                  0   \n",
       "4  641490163cf154af41366b08  1380578                  0   \n",
       "\n",
       "  LocalAuthorityBusinessID                         BusinessName  \\\n",
       "0             PI/000116619                            Volunteer   \n",
       "1             PI/000179088              Plumstead Manor Nursery   \n",
       "2             PI/000086506                    Atlantic Fish Bar   \n",
       "3             PI/000178842                              Iceland   \n",
       "4                    14425  Howe and Co Fish and Chips - Van 17   \n",
       "\n",
       "                            BusinessType  BusinessTypeID  \\\n",
       "0                      Pub/bar/nightclub            7843   \n",
       "1                        Caring Premises               5   \n",
       "2                 Takeaway/sandwich shop            7844   \n",
       "3  Retailers - supermarkets/hypermarkets            7840   \n",
       "4                         Mobile caterer            7846   \n",
       "\n",
       "                                        AddressLine1 AddressLine2  \\\n",
       "0                    130 - 132 Plumstead High Street                \n",
       "1               Plumstead Manor School Old Mill Road                \n",
       "2                                   35 Lakedale Road                \n",
       "3                    144 - 146 Plumstead High Street                \n",
       "4  Restaurant And Premises 107A Plumstead High St...                \n",
       "\n",
       "  AddressLine3  ...             LocalAuthorityWebSite  \\\n",
       "0    Plumstead  ...  http://www.royalgreenwich.gov.uk   \n",
       "1    Plumstead  ...  http://www.royalgreenwich.gov.uk   \n",
       "2    Plumstead  ...  http://www.royalgreenwich.gov.uk   \n",
       "3    Plumstead  ...  http://www.royalgreenwich.gov.uk   \n",
       "4    Plumstead  ...  http://www.royalgreenwich.gov.uk   \n",
       "\n",
       "     LocalAuthorityEmailAddress  \\\n",
       "0  health@royalgreenwich.gov.uk   \n",
       "1  health@royalgreenwich.gov.uk   \n",
       "2  health@royalgreenwich.gov.uk   \n",
       "3  health@royalgreenwich.gov.uk   \n",
       "4  health@royalgreenwich.gov.uk   \n",
       "\n",
       "                                              scores SchemeType  \\\n",
       "0  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "1  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "2  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "3  {'Hygiene': 0, 'Structural': 5, 'ConfidenceInM...       FHRS   \n",
       "4  {'Hygiene': 0, 'Structural': 0, 'ConfidenceInM...       FHRS   \n",
       "\n",
       "                                             geocode RightToReply  \\\n",
       "0     {'longitude': 0.09208, 'latitude': 51.4873437}                \n",
       "1  {'longitude': 0.0859939977526665, 'latitude': ...                \n",
       "2   {'longitude': 0.0912164, 'latitude': 51.4867296}                \n",
       "3  {'longitude': 0.0924199968576431, 'latitude': ...                \n",
       "4  {'longitude': 0.0925370007753372, 'latitude': ...                \n",
       "\n",
       "      Distance NewRatingPending  \\\n",
       "0  4646.965635            False   \n",
       "1  4646.974010            False   \n",
       "2  4646.974612            False   \n",
       "3  4646.946071            False   \n",
       "4  4646.955931            False   \n",
       "\n",
       "                                                meta  \\\n",
       "0  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "1  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "2  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "3  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "4  {'dataSource': None, 'extractDate': '0001-01-0...   \n",
       "\n",
       "                                               links  \n",
       "0  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "1  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "2  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "3  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "4  [{'rel': 'self', 'href': 'http://api.ratings.f...  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert result to Pandas DataFrame\n",
    "near_penang_df = pd.DataFrame(results)\n",
    "near_penang_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "67281254",
   "metadata": {},
   "source": [
    "### 4. How many establishments in each Local Authority area have a hygiene score of 0?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "4eeb227e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of documents in result: 87\n",
      "[{'_id': {'LocalAuthorityName': 'Thanet'}, 'count': 1130},\n",
      " {'_id': {'LocalAuthorityName': 'Greenwich'}, 'count': 882},\n",
      " {'_id': {'LocalAuthorityName': 'Maidstone'}, 'count': 713},\n",
      " {'_id': {'LocalAuthorityName': 'Newham'}, 'count': 711},\n",
      " {'_id': {'LocalAuthorityName': 'Swale'}, 'count': 686},\n",
      " {'_id': {'LocalAuthorityName': 'Chelmsford'}, 'count': 680},\n",
      " {'_id': {'LocalAuthorityName': 'Medway'}, 'count': 672},\n",
      " {'_id': {'LocalAuthorityName': 'Bexley'}, 'count': 607},\n",
      " {'_id': {'LocalAuthorityName': 'Southend-On-Sea'}, 'count': 586},\n",
      " {'_id': {'LocalAuthorityName': 'Tendring'}, 'count': 542}]\n"
     ]
    }
   ],
   "source": [
    "# , 'LocalAuthorityName': {'$regex': \"London\"}\n",
    "# Create a pipeline that: \n",
    "# 1. Matches establishments with a hygiene score of 0\n",
    "# 2. Groups the matches by Local Authority\n",
    "# 3. Sorts the matches from highest to lowest\n",
    "match_query = {'$match': {'scores.Hygiene': {'$eq': 0}}}\n",
    "group_query = {'$group': {'_id': {'LocalAuthorityName': '$LocalAuthorityName'},\n",
    "                          'count':{'$sum':1}\n",
    "                          }}\n",
    "sort_values = {'$sort': {'count': -1}}\n",
    "\n",
    "pipeline = [match_query, group_query, sort_values]\n",
    "results = list(establishments.aggregate(pipeline))\n",
    "results\n",
    "# Print the number of documents in the result\n",
    "print(f\"Number of documents in result: {establishments.count_documents(query)}\")\n",
    "# Print the first 10 results\n",
    "pprint(results[0:10])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "5ec9e8a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "28"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#debug verification\n",
    "query = {'scores.Hygiene': {'$eq': 0}, 'LocalAuthorityName': {'$regex': \"London\"}}\n",
    "len(list(establishments.find(query)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "d8aab364",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'LocalAuthorityName': 'Thanet'}</td>\n",
       "      <td>1130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'LocalAuthorityName': 'Greenwich'}</td>\n",
       "      <td>882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{'LocalAuthorityName': 'Maidstone'}</td>\n",
       "      <td>713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{'LocalAuthorityName': 'Newham'}</td>\n",
       "      <td>711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{'LocalAuthorityName': 'Swale'}</td>\n",
       "      <td>686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{'LocalAuthorityName': 'Chelmsford'}</td>\n",
       "      <td>680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{'LocalAuthorityName': 'Medway'}</td>\n",
       "      <td>672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{'LocalAuthorityName': 'Bexley'}</td>\n",
       "      <td>607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{'LocalAuthorityName': 'Southend-On-Sea'}</td>\n",
       "      <td>586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{'LocalAuthorityName': 'Tendring'}</td>\n",
       "      <td>542</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         _id  count\n",
       "0           {'LocalAuthorityName': 'Thanet'}   1130\n",
       "1        {'LocalAuthorityName': 'Greenwich'}    882\n",
       "2        {'LocalAuthorityName': 'Maidstone'}    713\n",
       "3           {'LocalAuthorityName': 'Newham'}    711\n",
       "4            {'LocalAuthorityName': 'Swale'}    686\n",
       "5       {'LocalAuthorityName': 'Chelmsford'}    680\n",
       "6           {'LocalAuthorityName': 'Medway'}    672\n",
       "7           {'LocalAuthorityName': 'Bexley'}    607\n",
       "8  {'LocalAuthorityName': 'Southend-On-Sea'}    586\n",
       "9         {'LocalAuthorityName': 'Tendring'}    542"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the result to a Pandas DataFrame\n",
    "hygiene_0_by_authority_df = pd.DataFrame(results)\n",
    "hygiene_0_by_authority_df\n",
    "# Display the number of rows in the DataFrame\n",
    "len(hygiene_0_by_authority_df)\n",
    "# Display the first 10 rows of the DataFrame\n",
    "hygiene_0_by_authority_df.head(10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0c1a67e0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}