db_earthquakes.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Part 2: Creating Database and Computing Spatial Statistics\n",
    "\n",
    "This is part 2 of our 3-part series on Retrieving, Analyzing and Visualizing georeferenced data of earthquakes. We are using the CSV file of the [selected dataset](https://raw.github.com/vincentarelbundock/Rdatasets/master/doc/datasets/quakes.html). This dataset contains location data (longitude and latitude), depth and magnitude of earthquake events that occurred near [Fiji](https://es.wikipedia.org/wiki/Fiyi) since 1964. Next, we will create a database and populate it using this CSV file. Finally, we will query the database and compute some statistics.\n",
    "\n",
    "We will import all the required Python libraries."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3\n",
    "import requests\n",
    "import csv\n",
    "import ssl\n",
    "from contextlib import closing\n",
    "import numpy as np\n",
    "import itertools"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Exploring the dataset\n",
    "\n",
    "Although we can use [pandas](https://pandas.pydata.org/) to explore our dataset, the challenge of this exercise is to use standard Python libraries. First,  we will locate the URL of the CSV file containing the data, next we will examine the dataset content.\n",
    "\n",
    "We will use the HTML link of the selected dataset to obtain the URL of its CSV file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The URL of the CSV file is:  https://raw.github.com/vincentarelbundock/Rdatasets/master/csv/datasets/quakes.csv\n"
     ]
    }
   ],
   "source": [
    "with open('datasets.csv', 'rt') as f:\n",
    "     reader = csv.reader(f, delimiter=',') \n",
    "     for row in reader:\n",
    "          for field in row:\n",
    "              if field == \"https://raw.github.com/vincentarelbundock/Rdatasets/master/doc/datasets/quakes.html\":\n",
    "                  url = row[10]\n",
    "print('The URL of the CSV file is: ', url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's review the content of the dataset. \n",
    "\n",
    "According to the `quakes.html` document, the description of the column names is as follows:\n",
    "\n",
    "* ***lat***: Latitude of event\n",
    "* ***long***: Longitude\n",
    "* ***depth***: Depth (km)\n",
    "* ***stations***: Number of stations reporting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['', 'lat', 'long', 'depth', 'mag', 'stations']\n",
      "['1', '-20.42', '181.62', '562', '4.8', '41']\n",
      "['2', '-20.62', '181.03', '650', '4.2', '15']\n",
      "['3', '-26', '184.1', '42', '5.4', '43']\n",
      "['4', '-17.97', '181.66', '626', '4.1', '19']\n",
      "['5', '-20.42', '181.96', '649', '4', '11']\n",
      "['6', '-19.68', '184.31', '195', '4', '12']\n",
      "['7', '-11.7', '166.1', '82', '4.8', '43']\n",
      "['8', '-28.11', '181.93', '194', '4.4', '15']\n",
      "['9', '-28.74', '181.74', '211', '4.7', '35']\n",
      "['10', '-17.47', '179.59', '622', '4.3', '19']\n",
      "['11', '-21.44', '180.69', '583', '4.4', '13']\n",
      "['12', '-12.26', '167', '249', '4.6', '16']\n",
      "['13', '-18.54', '182.11', '554', '4.4', '19']\n",
      "['14', '-21', '181.66', '600', '4.4', '10']\n",
      "['15', '-20.7', '169.92', '139', '6.1', '94']\n",
      "['16', '-15.94', '184.95', '306', '4.3', '11']\n",
      "['17', '-13.64', '165.96', '50', '6', '83']\n",
      "['18', '-17.83', '181.5', '590', '4.5', '21']\n",
      "['19', '-23.5', '179.78', '570', '4.4', '13']\n",
      "['20', '-22.63', '180.31', '598', '4.4', '18']\n",
      "['21', '-20.84', '181.16', '576', '4.5', '17']\n",
      "['22', '-10.98', '166.32', '211', '4.2', '12']\n",
      "['23', '-23.3', '180.16', '512', '4.4', '18']\n",
      "['24', '-30.2', '182', '125', '4.7', '22']\n",
      "['25', '-19.66', '180.28', '431', '5.4', '57']\n",
      "['26', '-17.94', '181.49', '537', '4', '15']\n",
      "['27', '-14.72', '167.51', '155', '4.6', '18']\n",
      "['28', '-16.46', '180.79', '498', '5.2', '79']\n",
      "['29', '-20.97', '181.47', '582', '4.5', '25']\n",
      "['30', '-19.84', '182.37', '328', '4.4', '17']\n",
      "['31', '-22.58', '179.24', '553', '4.6', '21']\n",
      "['32', '-16.32', '166.74', '50', '4.7', '30']\n",
      "['33', '-15.55', '185.05', '292', '4.8', '42']\n",
      "['34', '-23.55', '180.8', '349', '4', '10']\n",
      "['35', '-16.3', '186', '48', '4.5', '10']\n",
      "['36', '-25.82', '179.33', '600', '4.3', '13']\n",
      "['37', '-18.73', '169.23', '206', '4.5', '17']\n",
      "['38', '-17.64', '181.28', '574', '4.6', '17']\n",
      "['39', '-17.66', '181.4', '585', '4.1', '17']\n",
      "['40', '-18.82', '169.33', '230', '4.4', '11']\n",
      "['41', '-37.37', '176.78', '263', '4.7', '34']\n",
      "['42', '-15.31', '186.1', '96', '4.6', '32']\n",
      "['43', '-24.97', '179.82', '511', '4.4', '23']\n",
      "['44', '-15.49', '186.04', '94', '4.3', '26']\n",
      "['45', '-19.23', '169.41', '246', '4.6', '27']\n",
      "['46', '-30.1', '182.3', '56', '4.9', '34']\n",
      "['47', '-26.4', '181.7', '329', '4.5', '24']\n",
      "['48', '-11.77', '166.32', '70', '4.4', '18']\n",
      "['49', '-24.12', '180.08', '493', '4.3', '21']\n",
      "['50', '-18.97', '185.25', '129', '5.1', '73']\n",
      "['51', '-18.75', '182.35', '554', '4.2', '13']\n",
      "['52', '-19.26', '184.42', '223', '4', '15']\n",
      "['53', '-22.75', '173.2', '46', '4.6', '26']\n",
      "['54', '-21.37', '180.67', '593', '4.3', '13']\n",
      "['55', '-20.1', '182.16', '489', '4.2', '16']\n",
      "['56', '-19.85', '182.13', '562', '4.4', '31']\n",
      "['57', '-22.7', '181', '445', '4.5', '17']\n",
      "['58', '-22.06', '180.6', '584', '4', '11']\n",
      "['59', '-17.8', '181.35', '535', '4.4', '23']\n",
      "['60', '-24.2', '179.2', '530', '4.3', '12']\n",
      "['61', '-20.69', '181.55', '582', '4.7', '35']\n",
      "['62', '-21.16', '182.4', '260', '4.1', '12']\n",
      "['63', '-13.82', '172.38', '613', '5', '61']\n",
      "['64', '-11.49', '166.22', '84', '4.6', '32']\n",
      "['65', '-20.68', '181.41', '593', '4.9', '40']\n",
      "['66', '-17.1', '184.93', '286', '4.7', '25']\n",
      "['67', '-20.14', '181.6', '587', '4.1', '13']\n",
      "['68', '-21.96', '179.62', '627', '5', '45']\n",
      "['69', '-20.42', '181.86', '530', '4.5', '27']\n",
      "['70', '-15.46', '187.81', '40', '5.5', '91']\n",
      "['71', '-15.31', '185.8', '152', '4', '11']\n",
      "['72', '-19.86', '184.35', '201', '4.5', '30']\n",
      "['73', '-11.55', '166.2', '96', '4.3', '14']\n",
      "['74', '-23.74', '179.99', '506', '5.2', '75']\n",
      "['75', '-17.7', '181.23', '546', '4.4', '35']\n",
      "['76', '-23.54', '180.04', '564', '4.3', '15']\n",
      "['77', '-19.21', '184.7', '197', '4.1', '11']\n",
      "['78', '-12.11', '167.06', '265', '4.5', '23']\n",
      "['79', '-21.81', '181.71', '323', '4.2', '15']\n",
      "['80', '-28.98', '181.11', '304', '5.3', '60']\n",
      "['81', '-34.02', '180.21', '75', '5.2', '65']\n",
      "['82', '-23.84', '180.99', '367', '4.5', '27']\n",
      "['83', '-19.57', '182.38', '579', '4.6', '38']\n",
      "['84', '-20.12', '183.4', '284', '4.3', '15']\n",
      "['85', '-17.7', '181.7', '450', '4', '11']\n",
      "['86', '-19.66', '184.31', '170', '4.3', '15']\n",
      "['87', '-21.5', '170.5', '117', '4.7', '32']\n",
      "['88', '-23.64', '179.96', '538', '4.5', '26']\n",
      "['89', '-15.43', '186.3', '123', '4.2', '16']\n",
      "['90', '-15.41', '186.44', '69', '4.3', '42']\n",
      "['91', '-15.48', '167.53', '128', '5.1', '61']\n",
      "['92', '-13.36', '167.06', '236', '4.7', '22']\n",
      "['93', '-20.64', '182.02', '497', '5.2', '64']\n",
      "['94', '-19.72', '169.71', '271', '4.2', '14']\n",
      "['95', '-15.44', '185.26', '224', '4.2', '21']\n",
      "['96', '-19.73', '182.4', '375', '4', '18']\n",
      "['97', '-27.24', '181.11', '365', '4.5', '21']\n",
      "['98', '-18.16', '183.41', '306', '5.2', '54']\n",
      "['99', '-13.66', '166.54', '50', '5.1', '45']\n",
      "['100', '-24.57', '179.92', '484', '4.7', '33']\n",
      "['101', '-16.98', '185.61', '108', '4.1', '12']\n",
      "['102', '-26.2', '178.41', '583', '4.6', '25']\n",
      "['103', '-21.88', '180.39', '608', '4.7', '30']\n",
      "['104', '-33', '181.6', '72', '4.7', '22']\n",
      "['105', '-21.33', '180.69', '636', '4.6', '29']\n",
      "['106', '-19.44', '183.5', '293', '4.2', '15']\n",
      "['107', '-34.89', '180.6', '42', '4.4', '25']\n",
      "['108', '-20.24', '169.49', '100', '4.6', '22']\n",
      "['109', '-22.55', '185.9', '42', '5.7', '76']\n",
      "['110', '-36.95', '177.81', '146', '5', '35']\n",
      "['111', '-15.75', '185.23', '280', '4.5', '28']\n",
      "['112', '-16.85', '182.31', '388', '4.2', '14']\n",
      "['113', '-19.06', '182.45', '477', '4', '16']\n",
      "['114', '-26.11', '178.3', '617', '4.8', '39']\n",
      "['115', '-26.2', '178.35', '606', '4.4', '21']\n",
      "['116', '-26.13', '178.31', '609', '4.2', '25']\n",
      "['117', '-13.66', '172.23', '46', '5.3', '67']\n",
      "['118', '-13.47', '172.29', '64', '4.7', '14']\n",
      "['119', '-14.6', '167.4', '178', '4.8', '52']\n",
      "['120', '-18.96', '169.48', '248', '4.2', '13']\n",
      "['121', '-14.65', '166.97', '82', '4.8', '28']\n",
      "['122', '-19.9', '178.9', '81', '4.3', '11']\n",
      "['123', '-22.05', '180.4', '606', '4.7', '27']\n",
      "['124', '-19.22', '182.43', '571', '4.5', '23']\n",
      "['125', '-31.24', '180.6', '328', '4.4', '18']\n",
      "['126', '-17.93', '167.89', '49', '5.1', '43']\n",
      "['127', '-19.3', '183.84', '517', '4.2', '21']\n",
      "['128', '-26.53', '178.57', '600', '5', '69']\n",
      "['129', '-27.72', '181.7', '94', '4.8', '59']\n",
      "['130', '-19.19', '183.51', '307', '4.3', '19']\n",
      "['131', '-17.43', '185.43', '189', '4.5', '22']\n",
      "['132', '-17.05', '181.22', '527', '4.2', '24']\n",
      "['133', '-19.52', '168.98', '63', '4.5', '21']\n",
      "['134', '-23.71', '180.3', '510', '4.6', '30']\n",
      "['135', '-21.3', '180.82', '624', '4.3', '14']\n",
      "['136', '-16.24', '168.02', '53', '4.7', '12']\n",
      "['137', '-16.14', '187.32', '42', '5.1', '68']\n",
      "['138', '-23.95', '182.8', '199', '4.6', '14']\n",
      "['139', '-25.2', '182.6', '149', '4.9', '31']\n",
      "['140', '-18.84', '184.16', '210', '4.2', '17']\n",
      "['141', '-12.66', '169.46', '658', '4.6', '43']\n",
      "['142', '-20.65', '181.4', '582', '4', '14']\n",
      "['143', '-13.23', '167.1', '220', '5', '46']\n",
      "['144', '-29.91', '181.43', '205', '4.4', '34']\n",
      "['145', '-14.31', '173.5', '614', '4.2', '23']\n",
      "['146', '-20.1', '184.4', '186', '4.2', '10']\n",
      "['147', '-17.8', '185.17', '97', '4.4', '22']\n",
      "['148', '-21.27', '173.49', '48', '4.9', '42']\n",
      "['149', '-23.58', '180.17', '462', '5.3', '63']\n",
      "['150', '-17.9', '181.5', '573', '4', '19']\n",
      "['151', '-23.34', '184.5', '56', '5.7', '106']\n",
      "['152', '-15.56', '167.62', '127', '6.4', '122']\n",
      "['153', '-23.83', '182.56', '229', '4.3', '24']\n",
      "['154', '-11.8', '165.8', '112', '4.2', '20']\n",
      "['155', '-15.54', '167.68', '140', '4.7', '16']\n",
      "['156', '-20.65', '181.32', '597', '4.7', '39']\n",
      "['157', '-11.75', '166.07', '69', '4.2', '14']\n",
      "['158', '-24.81', '180', '452', '4.3', '19']\n",
      "['159', '-20.9', '169.84', '93', '4.9', '31']\n",
      "['160', '-11.34', '166.24', '103', '4.6', '30']\n",
      "['161', '-17.98', '180.5', '626', '4.1', '19']\n",
      "['162', '-24.34', '179.52', '504', '4.8', '34']\n",
      "['163', '-13.86', '167.16', '202', '4.6', '30']\n",
      "['164', '-35.56', '180.2', '42', '4.6', '32']\n",
      "['165', '-35.48', '179.9', '59', '4.8', '35']\n",
      "['166', '-34.2', '179.43', '40', '5', '37']\n",
      "['167', '-26', '182.12', '205', '5.6', '98']\n",
      "['168', '-19.89', '183.84', '244', '5.3', '73']\n",
      "['169', '-23.43', '180', '553', '4.7', '41']\n",
      "['170', '-18.89', '169.42', '239', '4.5', '27']\n",
      "['171', '-17.82', '181.83', '640', '4.3', '24']\n",
      "['172', '-25.68', '180.34', '434', '4.6', '41']\n",
      "['173', '-20.2', '180.9', '627', '4.1', '11']\n",
      "['174', '-15.2', '184.68', '99', '4.1', '14']\n",
      "['175', '-15.03', '182.29', '399', '4.1', '10']\n",
      "['176', '-32.22', '180.2', '216', '5.7', '90']\n",
      "['177', '-22.64', '180.64', '544', '5', '50']\n",
      "['178', '-17.42', '185.16', '206', '4.5', '22']\n",
      "['179', '-17.84', '181.48', '542', '4.1', '20']\n",
      "['180', '-15.02', '184.24', '339', '4.6', '27']\n",
      "['181', '-18.04', '181.75', '640', '4.5', '47']\n",
      "['182', '-24.6', '183.5', '67', '4.3', '25']\n",
      "['183', '-19.88', '184.3', '161', '4.4', '17']\n",
      "['184', '-20.3', '183', '375', '4.2', '15']\n",
      "['185', '-20.45', '181.85', '534', '4.1', '14']\n",
      "['186', '-17.67', '187.09', '45', '4.9', '62']\n",
      "['187', '-22.3', '181.9', '309', '4.3', '11']\n",
      "['188', '-19.85', '181.85', '576', '4.9', '54']\n",
      "['189', '-24.27', '179.88', '523', '4.6', '24']\n",
      "['190', '-15.85', '185.13', '290', '4.6', '29']\n",
      "['191', '-20.02', '184.09', '234', '5.3', '71']\n",
      "['192', '-18.56', '169.31', '223', '4.7', '35']\n",
      "['193', '-17.87', '182', '569', '4.6', '12']\n",
      "['194', '-24.08', '179.5', '605', '4.1', '21']\n",
      "['195', '-32.2', '179.61', '422', '4.6', '41']\n",
      "['196', '-20.36', '181.19', '637', '4.2', '23']\n",
      "['197', '-23.85', '182.53', '204', '4.6', '27']\n",
      "['198', '-24', '182.75', '175', '4.5', '14']\n",
      "['199', '-20.41', '181.74', '538', '4.3', '31']\n",
      "['200', '-17.72', '180.3', '595', '5.2', '74']\n",
      "['201', '-19.67', '182.18', '360', '4.3', '23']\n",
      "['202', '-17.7', '182.2', '445', '4', '12']\n",
      "['203', '-16.23', '183.59', '367', '4.7', '35']\n",
      "['204', '-26.72', '183.35', '190', '4.5', '36']\n",
      "['205', '-12.95', '169.09', '629', '4.5', '19']\n",
      "['206', '-21.97', '182.32', '261', '4.3', '13']\n",
      "['207', '-21.96', '180.54', '603', '5.2', '66']\n",
      "['208', '-20.32', '181.69', '508', '4.5', '14']\n",
      "['209', '-30.28', '180.62', '350', '4.7', '32']\n",
      "['210', '-20.2', '182.3', '533', '4.2', '11']\n",
      "['211', '-30.66', '180.13', '411', '4.7', '42']\n",
      "['212', '-16.17', '184.1', '338', '4.3', '13']\n",
      "['213', '-28.25', '181.71', '226', '4.1', '19']\n",
      "['214', '-20.47', '185.68', '93', '5.4', '85']\n",
      "['215', '-23.55', '180.27', '535', '4.3', '22']\n",
      "['216', '-20.94', '181.58', '573', '4.3', '21']\n",
      "['217', '-26.67', '182.4', '186', '4.2', '17']\n",
      "['218', '-18.13', '181.52', '618', '4.6', '41']\n",
      "['219', '-20.21', '183.83', '242', '4.4', '29']\n",
      "['220', '-18.31', '182.39', '342', '4.2', '14']\n",
      "['221', '-16.52', '185.7', '90', '4.7', '30']\n",
      "['222', '-22.36', '171.65', '130', '4.6', '39']\n",
      "['223', '-22.43', '184.48', '65', '4.9', '48']\n",
      "['224', '-20.37', '182.1', '397', '4.2', '22']\n",
      "['225', '-23.77', '180.16', '505', '4.5', '26']\n",
      "['226', '-13.65', '166.66', '71', '4.9', '52']\n",
      "['227', '-21.55', '182.9', '207', '4.2', '18']\n",
      "['228', '-16.24', '185.75', '154', '4.5', '22']\n",
      "['229', '-23.73', '182.53', '232', '5', '55']\n",
      "['230', '-22.34', '171.52', '106', '5', '43']\n",
      "['231', '-19.4', '180.94', '664', '4.7', '34']\n",
      "['232', '-24.64', '180.81', '397', '4.3', '24']\n",
      "['233', '-16', '182.82', '431', '4.4', '16']\n",
      "['234', '-19.62', '185.35', '57', '4.9', '31']\n",
      "['235', '-23.84', '180.13', '525', '4.5', '15']\n",
      "['236', '-23.54', '179.93', '574', '4', '12']\n",
      "['237', '-28.23', '182.68', '74', '4.4', '20']\n",
      "['238', '-21.68', '180.63', '617', '5', '63']\n",
      "['239', '-13.44', '166.53', '44', '4.7', '27']\n",
      "['240', '-24.96', '180.22', '470', '4.8', '41']\n",
      "['241', '-20.08', '182.74', '298', '4.5', '33']\n",
      "['242', '-24.36', '182.84', '148', '4.1', '16']\n",
      "['243', '-14.7', '166', '48', '5.3', '16']\n",
      "['244', '-18.2', '183.68', '107', '4.8', '52']\n",
      "['245', '-16.65', '185.51', '218', '5', '52']\n",
      "['246', '-18.11', '181.67', '597', '4.6', '28']\n",
      "['247', '-17.95', '181.65', '619', '4.3', '26']\n",
      "['248', '-15.5', '186.9', '46', '4.7', '18']\n",
      "['249', '-23.36', '180.01', '553', '5.3', '61']\n",
      "['250', '-19.15', '169.5', '150', '4.2', '12']\n",
      "['251', '-10.97', '166.26', '180', '4.7', '26']\n",
      "['252', '-14.85', '167.24', '97', '4.5', '26']\n",
      "['253', '-17.8', '181.38', '587', '5.1', '47']\n",
      "['254', '-22.5', '170.4', '106', '4.9', '38']\n",
      "['255', '-29.1', '182.1', '179', '4.4', '19']\n",
      "['256', '-20.32', '180.88', '680', '4.2', '22']\n",
      "['257', '-16.09', '184.89', '304', '4.6', '34']\n",
      "['258', '-19.18', '169.33', '254', '4.7', '35']\n",
      "['259', '-23.81', '179.36', '521', '4.2', '23']\n",
      "['260', '-23.79', '179.89', '526', '4.9', '43']\n",
      "['261', '-19.02', '184.23', '270', '5.1', '72']\n",
      "['262', '-20.9', '181.51', '548', '4.7', '32']\n",
      "['263', '-19.06', '169.01', '158', '4.4', '10']\n",
      "['264', '-17.88', '181.47', '562', '4.4', '27']\n",
      "['265', '-19.41', '183.05', '300', '4.2', '16']\n",
      "['266', '-26.17', '184.2', '65', '4.9', '37']\n",
      "['267', '-14.95', '167.24', '130', '4.6', '16']\n",
      "['268', '-18.73', '168.8', '82', '4.4', '14']\n",
      "['269', '-20.21', '182.37', '482', '4.6', '37']\n",
      "['270', '-21.29', '180.85', '607', '4.5', '23']\n",
      "['271', '-19.76', '181.41', '105', '4.4', '15']\n",
      "['272', '-22.09', '180.38', '590', '4.9', '35']\n",
      "['273', '-23.8', '179.9', '498', '4.1', '12']\n",
      "['274', '-20.16', '181.99', '504', '4.2', '11']\n",
      "['275', '-22.13', '180.38', '577', '5.7', '104']\n",
      "['276', '-17.44', '181.4', '529', '4.6', '25']\n",
      "['277', '-23.33', '180.18', '528', '5', '59']\n",
      "['278', '-24.78', '179.22', '492', '4.3', '16']\n",
      "['279', '-22', '180.52', '561', '4.5', '19']\n",
      "['280', '-19.13', '182.51', '579', '5.2', '56']\n",
      "['281', '-30.72', '180.1', '413', '4.4', '22']\n",
      "['282', '-22.32', '180.54', '565', '4.2', '12']\n",
      "['283', '-16.45', '177.77', '138', '4.6', '17']\n",
      "['284', '-17.7', '185', '383', '4', '10']\n",
      "['285', '-17.95', '184.68', '260', '4.4', '21']\n",
      "['286', '-24.4', '179.85', '522', '4.7', '29']\n",
      "['287', '-19.3', '180.6', '671', '4.2', '16']\n",
      "['288', '-21.13', '185.32', '123', '4.7', '36']\n",
      "['289', '-18.07', '181.57', '572', '4.5', '26']\n",
      "['290', '-20.6', '182.28', '529', '5', '50']\n",
      "['291', '-18.48', '181.49', '641', '5', '49']\n",
      "['292', '-13.34', '166.2', '67', '4.8', '18']\n",
      "['293', '-20.92', '181.5', '546', '4.6', '31']\n",
      "['294', '-25.31', '179.69', '507', '4.6', '35']\n",
      "['295', '-15.24', '186.21', '158', '5', '57']\n",
      "['296', '-16.4', '185.86', '148', '5', '47']\n",
      "['297', '-24.57', '178.4', '562', '5.6', '80']\n",
      "['298', '-17.94', '181.51', '601', '4', '16']\n",
      "['299', '-30.64', '181.2', '175', '4', '16']\n",
      "['300', '-18.64', '169.32', '260', '4.6', '23']\n",
      "['301', '-13.09', '169.28', '654', '4.4', '22']\n",
      "['302', '-19.68', '184.14', '242', '4.8', '40']\n",
      "['303', '-16.44', '185.74', '126', '4.7', '30']\n",
      "['304', '-21.09', '181.38', '555', '4.6', '15']\n",
      "['305', '-14.99', '171.39', '637', '4.3', '21']\n",
      "['306', '-23.3', '179.7', '500', '4.7', '29']\n",
      "['307', '-17.68', '181.36', '515', '4.1', '19']\n",
      "['308', '-22', '180.53', '583', '4.9', '20']\n",
      "['309', '-21.38', '181.39', '501', '4.6', '36']\n",
      "['310', '-32.62', '181.5', '55', '4.8', '26']\n",
      "['311', '-13.05', '169.58', '644', '4.9', '68']\n",
      "['312', '-12.93', '169.63', '641', '5.1', '57']\n",
      "['313', '-18.6', '181.91', '442', '5.4', '82']\n",
      "['314', '-21.34', '181.41', '464', '4.5', '21']\n",
      "['315', '-21.48', '183.78', '200', '4.9', '54']\n",
      "['316', '-17.4', '181.02', '479', '4.4', '14']\n",
      "['317', '-17.32', '181.03', '497', '4.1', '13']\n",
      "['318', '-18.77', '169.24', '218', '5.3', '53']\n",
      "['319', '-26.16', '179.5', '492', '4.5', '25']\n",
      "['320', '-12.59', '167.1', '325', '4.9', '26']\n",
      "['321', '-14.82', '167.32', '123', '4.8', '28']\n",
      "['322', '-21.79', '183.48', '210', '5.2', '69']\n",
      "['323', '-19.83', '182.04', '575', '4.4', '23']\n",
      "['324', '-29.5', '182.31', '129', '4.4', '14']\n",
      "['325', '-12.49', '166.36', '74', '4.9', '55']\n",
      "['326', '-26.1', '182.3', '49', '4.4', '11']\n",
      "['327', '-21.04', '181.2', '483', '4.2', '10']\n",
      "['328', '-10.78', '165.77', '93', '4.6', '20']\n",
      "['329', '-20.76', '185.77', '118', '4.6', '15']\n",
      "['330', '-11.41', '166.24', '83', '5.3', '55']\n",
      "['331', '-19.1', '183.87', '61', '5.3', '42']\n",
      "['332', '-23.91', '180', '534', '4.5', '11']\n",
      "['333', '-27.33', '182.6', '42', '4.4', '11']\n",
      "['334', '-12.25', '166.6', '219', '5', '28']\n",
      "['335', '-23.49', '179.07', '544', '5.1', '58']\n",
      "['336', '-27.18', '182.18', '56', '4.5', '14']\n",
      "['337', '-25.8', '182.1', '68', '4.5', '26']\n",
      "['338', '-27.19', '182.18', '69', '5.4', '68']\n",
      "['339', '-27.27', '182.38', '45', '4.5', '16']\n",
      "['340', '-27.1', '182.18', '43', '4.7', '17']\n",
      "['341', '-27.22', '182.28', '65', '4.2', '14']\n",
      "['342', '-27.38', '181.7', '80', '4.8', '13']\n",
      "['343', '-27.27', '182.5', '51', '4.5', '13']\n",
      "['344', '-27.54', '182.5', '68', '4.3', '12']\n",
      "['345', '-27.2', '182.39', '69', '4.3', '14']\n",
      "['346', '-27.71', '182.47', '103', '4.3', '11']\n",
      "['347', '-27.6', '182.4', '61', '4.6', '11']\n",
      "['348', '-27.38', '182.39', '69', '4.5', '12']\n",
      "['349', '-21.54', '185.48', '51', '5', '29']\n",
      "['350', '-27.21', '182.43', '55', '4.6', '10']\n",
      "['351', '-28.96', '182.61', '54', '4.6', '15']\n",
      "['352', '-12.01', '166.29', '59', '4.9', '27']\n",
      "['353', '-17.46', '181.32', '573', '4.1', '17']\n",
      "['354', '-30.17', '182.02', '56', '5.5', '68']\n",
      "['355', '-27.27', '182.36', '65', '4.7', '21']\n",
      "['356', '-17.79', '181.32', '587', '5', '49']\n",
      "['357', '-22.19', '171.4', '150', '5.1', '49']\n",
      "['358', '-17.1', '182.68', '403', '5.5', '82']\n",
      "['359', '-27.18', '182.53', '60', '4.6', '21']\n",
      "['360', '-11.64', '166.47', '130', '4.7', '19']\n",
      "['361', '-17.98', '181.58', '590', '4.2', '14']\n",
      "['362', '-16.9', '185.72', '135', '4', '22']\n",
      "['363', '-21.98', '179.6', '583', '5.4', '67']\n",
      "['364', '-32.14', '179.9', '406', '4.3', '19']\n",
      "['365', '-18.8', '169.21', '221', '4.4', '16']\n",
      "['366', '-26.78', '183.61', '40', '4.6', '22']\n",
      "['367', '-20.43', '182.37', '502', '5.1', '48']\n",
      "['368', '-18.3', '183.2', '103', '4.5', '14']\n",
      "['369', '-15.83', '182.51', '423', '4.2', '21']\n",
      "['370', '-23.44', '182.93', '158', '4.1', '20']\n",
      "['371', '-23.73', '179.99', '527', '5.1', '49']\n",
      "['372', '-19.89', '184.08', '219', '5.4', '105']\n",
      "['373', '-17.59', '181.09', '536', '5.1', '61']\n",
      "['374', '-19.77', '181.4', '630', '5.1', '54']\n",
      "['375', '-20.31', '184.06', '249', '4.4', '21']\n",
      "['376', '-15.33', '186.75', '48', '5.7', '123']\n",
      "['377', '-18.2', '181.6', '553', '4.4', '14']\n",
      "['378', '-15.36', '186.66', '112', '5.1', '57']\n",
      "['379', '-15.29', '186.42', '153', '4.6', '31']\n",
      "['380', '-15.36', '186.71', '130', '5.5', '95']\n",
      "['381', '-16.24', '167.95', '188', '5.1', '68']\n",
      "['382', '-13.47', '167.14', '226', '4.4', '26']\n",
      "['383', '-25.5', '182.82', '124', '5', '25']\n",
      "['384', '-14.32', '167.33', '204', '5', '49']\n",
      "['385', '-20.04', '182.01', '605', '5.1', '49']\n",
      "['386', '-28.83', '181.66', '221', '5.1', '63']\n",
      "['387', '-17.82', '181.49', '573', '4.2', '14']\n",
      "['388', '-27.23', '180.98', '401', '4.5', '39']\n",
      "['389', '-10.72', '165.99', '195', '4', '14']\n",
      "['390', '-27', '183.88', '56', '4.9', '36']\n",
      "['391', '-20.36', '186.16', '102', '4.3', '21']\n",
      "['392', '-27.17', '183.68', '44', '4.8', '27']\n",
      "['393', '-20.94', '181.26', '556', '4.4', '21']\n",
      "['394', '-17.46', '181.9', '417', '4.2', '14']\n",
      "['395', '-21.04', '181.2', '591', '4.9', '45']\n",
      "['396', '-23.7', '179.6', '646', '4.2', '21']\n",
      "['397', '-17.72', '181.42', '565', '5.3', '89']\n",
      "['398', '-15.87', '188.13', '52', '5', '30']\n",
      "['399', '-17.84', '181.3', '535', '5.7', '112']\n",
      "['400', '-13.45', '170.3', '641', '5.3', '93']\n",
      "['401', '-30.8', '182.16', '41', '4.7', '24']\n",
      "['402', '-11.63', '166.14', '109', '4.6', '36']\n",
      "['403', '-30.4', '181.4', '40', '4.3', '17']\n",
      "['404', '-26.18', '178.59', '548', '5.4', '65']\n",
      "['405', '-15.7', '184.5', '118', '4.4', '30']\n",
      "['406', '-17.95', '181.5', '593', '4.3', '16']\n",
      "['407', '-20.51', '182.3', '492', '4.3', '23']\n",
      "['408', '-15.36', '167.51', '123', '4.7', '28']\n",
      "['409', '-23.61', '180.23', '475', '4.4', '26']\n",
      "['410', '-33.2', '181.6', '153', '4.2', '21']\n",
      "['411', '-17.68', '186.8', '112', '4.5', '35']\n",
      "['412', '-22.24', '184.56', '99', '4.8', '57']\n",
      "['413', '-20.07', '169.14', '66', '4.8', '37']\n",
      "['414', '-25.04', '180.1', '481', '4.3', '15']\n",
      "['415', '-21.5', '185.2', '139', '4.4', '15']\n",
      "['416', '-14.28', '167.26', '211', '5.1', '51']\n",
      "['417', '-14.43', '167.26', '151', '4.4', '17']\n",
      "['418', '-32.7', '181.7', '211', '4.4', '40']\n",
      "['419', '-34.1', '181.8', '246', '4.3', '23']\n",
      "['420', '-19.7', '186.2', '47', '4.8', '19']\n",
      "['421', '-24.19', '180.38', '484', '4.3', '27']\n",
      "['422', '-26.6', '182.77', '119', '4.5', '29']\n",
      "['423', '-17.04', '186.8', '70', '4.1', '22']\n",
      "['424', '-22.1', '179.71', '579', '5.1', '58']\n",
      "['425', '-32.6', '180.9', '57', '4.7', '44']\n",
      "['426', '-33', '182.4', '176', '4.6', '28']\n",
      "['427', '-20.58', '181.24', '602', '4.7', '44']\n",
      "['428', '-20.61', '182.6', '488', '4.6', '12']\n",
      "['429', '-19.47', '169.15', '149', '4.4', '15']\n",
      "['430', '-17.47', '180.96', '546', '4.2', '23']\n",
      "['431', '-18.4', '183.4', '343', '4.1', '10']\n",
      "['432', '-23.33', '180.26', '530', '4.7', '22']\n",
      "['433', '-18.55', '182.23', '563', '4', '17']\n",
      "['434', '-26.16', '178.47', '537', '4.8', '33']\n",
      "['435', '-21.8', '183.2', '325', '4.4', '19']\n",
      "['436', '-27.63', '182.93', '80', '4.3', '14']\n",
      "['437', '-18.89', '169.48', '259', '4.4', '21']\n",
      "['438', '-20.3', '182.3', '476', '4.5', '10']\n",
      "['439', '-20.56', '182.04', '499', '4.5', '29']\n",
      "['440', '-16.1', '185.32', '257', '4.7', '30']\n",
      "['441', '-12.66', '166.37', '165', '4.3', '18']\n",
      "['442', '-21.05', '184.68', '136', '4.7', '29']\n",
      "['443', '-17.97', '168.52', '146', '4.8', '33']\n",
      "['444', '-19.83', '182.54', '524', '4.6', '14']\n",
      "['445', '-22.55', '183.81', '82', '5.1', '68']\n",
      "['446', '-22.28', '183.52', '90', '4.7', '19']\n",
      "['447', '-15.72', '185.64', '138', '4.3', '21']\n",
      "['448', '-20.85', '181.59', '499', '5.1', '91']\n",
      "['449', '-21.11', '181.5', '538', '5.5', '104']\n",
      "['450', '-25.31', '180.15', '467', '4.5', '25']\n",
      "['451', '-26.46', '182.5', '184', '4.3', '11']\n",
      "['452', '-24.09', '179.68', '538', '4.3', '21']\n",
      "['453', '-16.96', '167.7', '45', '4.7', '23']\n",
      "['454', '-23.19', '182.8', '237', '4.3', '18']\n",
      "['455', '-20.81', '184.7', '162', '4.3', '20']\n",
      "['456', '-15.03', '167.32', '136', '4.6', '20']\n",
      "['457', '-18.06', '181.59', '604', '4.5', '23']\n",
      "['458', '-19', '185.6', '107', '4.5', '15']\n",
      "['459', '-23.53', '179.99', '538', '5.4', '87']\n",
      "['460', '-18.18', '180.63', '639', '4.6', '39']\n",
      "['461', '-15.66', '186.8', '45', '4.4', '11']\n",
      "['462', '-18', '180.62', '636', '5', '100']\n",
      "['463', '-18.08', '180.7', '628', '5.2', '72']\n",
      "['464', '-18.05', '180.86', '632', '4.4', '15']\n",
      "['465', '-29.9', '181.16', '215', '5.1', '51']\n",
      "['466', '-20.9', '181.9', '556', '4.4', '17']\n",
      "['467', '-15.61', '167.5', '135', '4.4', '21']\n",
      "['468', '-16.03', '185.43', '297', '4.8', '25']\n",
      "['469', '-17.68', '181.11', '568', '4.4', '22']\n",
      "['470', '-31.94', '180.57', '168', '4.7', '39']\n",
      "['471', '-19.14', '184.36', '269', '4.7', '31']\n",
      "['472', '-18', '185.48', '143', '4.4', '29']\n",
      "['473', '-16.95', '185.94', '95', '4.3', '12']\n",
      "['474', '-10.79', '166.06', '142', '5', '40']\n",
      "['475', '-20.83', '185.9', '104', '4.5', '19']\n",
      "['476', '-32.9', '181.6', '169', '4.6', '27']\n",
      "['477', '-37.93', '177.47', '65', '5.4', '65']\n",
      "['478', '-29.09', '183.2', '54', '4.6', '23']\n",
      "['479', '-23.56', '180.23', '474', '4.5', '13']\n",
      "['480', '-19.6', '185.2', '125', '4.4', '13']\n",
      "['481', '-21.39', '180.68', '617', '4.5', '18']\n",
      "['482', '-14.85', '184.87', '294', '4.1', '10']\n",
      "['483', '-22.7', '183.3', '180', '4', '13']\n",
      "['484', '-32.42', '181.21', '47', '4.9', '39']\n",
      "['485', '-17.9', '181.3', '593', '4.1', '13']\n",
      "['486', '-23.58', '183.4', '94', '5.2', '79']\n",
      "['487', '-34.4', '180.5', '201', '4.4', '41']\n",
      "['488', '-17.61', '181.2', '537', '4.1', '11']\n",
      "['489', '-21.07', '181.13', '594', '4.9', '43']\n",
      "['490', '-13.84', '170.62', '638', '4.6', '20']\n",
      "['491', '-30.24', '181.63', '80', '4.5', '17']\n",
      "['492', '-18.49', '169.04', '211', '4.8', '30']\n",
      "['493', '-23.45', '180.23', '520', '4.2', '19']\n",
      "['494', '-16.04', '183.54', '384', '4.2', '23']\n",
      "['495', '-17.14', '185.31', '223', '4.1', '15']\n",
      "['496', '-22.54', '172.91', '54', '5.5', '71']\n",
      "['497', '-15.9', '185.3', '57', '4.4', '19']\n",
      "['498', '-30.04', '181.2', '49', '4.8', '20']\n",
      "['499', '-24.03', '180.22', '508', '4.2', '23']\n",
      "['500', '-18.89', '184.46', '242', '4.8', '36']\n",
      "['501', '-16.51', '187.1', '62', '4.9', '46']\n",
      "['502', '-20.1', '186.3', '63', '4.6', '19']\n",
      "['503', '-21.06', '183.81', '203', '4.5', '34']\n",
      "['504', '-13.07', '166.87', '132', '4.4', '24']\n",
      "['505', '-23.46', '180.09', '543', '4.6', '28']\n",
      "['506', '-19.41', '182.3', '589', '4.2', '19']\n",
      "['507', '-11.81', '165.98', '51', '4.7', '28']\n",
      "['508', '-11.76', '165.96', '45', '4.4', '51']\n",
      "['509', '-12.08', '165.76', '63', '4.5', '51']\n",
      "['510', '-25.59', '180.02', '485', '4.9', '48']\n",
      "['511', '-26.54', '183.63', '66', '4.7', '34']\n",
      "['512', '-20.9', '184.28', '58', '5.5', '92']\n",
      "['513', '-16.99', '187', '70', '4.7', '30']\n",
      "['514', '-23.46', '180.17', '541', '4.6', '32']\n",
      "['515', '-17.81', '181.82', '598', '4.1', '14']\n",
      "['516', '-15.17', '187.2', '50', '4.7', '28']\n",
      "['517', '-11.67', '166.02', '102', '4.6', '21']\n",
      "['518', '-20.75', '184.52', '144', '4.3', '25']\n",
      "['519', '-19.5', '186.9', '58', '4.4', '20']\n",
      "['520', '-26.18', '179.79', '460', '4.7', '44']\n",
      "['521', '-20.66', '185.77', '69', '4.3', '25']\n",
      "['522', '-19.22', '182.54', '570', '4.1', '22']\n",
      "['523', '-24.68', '183.33', '70', '4.7', '30']\n",
      "['524', '-15.43', '167.38', '137', '4.5', '16']\n",
      "['525', '-32.45', '181.15', '41', '5.5', '81']\n",
      "['526', '-21.31', '180.84', '586', '4.5', '17']\n",
      "['527', '-15.44', '167.18', '140', '4.6', '44']\n",
      "['528', '-13.26', '167.01', '213', '5.1', '70']\n",
      "['529', '-15.26', '183.13', '393', '4.4', '28']\n",
      "['530', '-33.57', '180.8', '51', '4.7', '35']\n",
      "['531', '-15.77', '167.01', '64', '5.5', '73']\n",
      "['532', '-15.79', '166.83', '45', '4.6', '39']\n",
      "['533', '-21', '183.2', '296', '4', '16']\n",
      "['534', '-16.28', '166.94', '50', '4.6', '24']\n",
      "['535', '-23.28', '184.6', '44', '4.8', '34']\n",
      "['536', '-16.1', '167.25', '68', '4.7', '36']\n",
      "['537', '-17.7', '181.31', '549', '4.7', '33']\n",
      "['538', '-15.96', '166.69', '150', '4.2', '20']\n",
      "['539', '-15.95', '167.34', '47', '5.4', '87']\n",
      "['540', '-17.56', '181.59', '543', '4.6', '34']\n",
      "['541', '-15.9', '167.42', '40', '5.5', '86']\n",
      "['542', '-15.29', '166.9', '100', '4.2', '15']\n",
      "['543', '-15.86', '166.85', '85', '4.5', '22']\n",
      "['544', '-16.2', '166.8', '98', '4.5', '21']\n",
      "['545', '-15.71', '166.91', '58', '4.8', '20']\n",
      "['546', '-16.45', '167.54', '125', '4.6', '18']\n",
      "['547', '-11.54', '166.18', '89', '5.4', '80']\n",
      "['548', '-19.61', '181.91', '590', '4.6', '34']\n",
      "['549', '-15.61', '187.15', '49', '5', '30']\n",
      "['550', '-21.16', '181.41', '543', '4.3', '17']\n",
      "['551', '-20.65', '182.22', '506', '4.3', '24']\n",
      "['552', '-20.33', '168.71', '40', '4.8', '38']\n",
      "['553', '-15.08', '166.62', '42', '4.7', '23']\n",
      "['554', '-23.28', '184.61', '76', '4.7', '36']\n",
      "['555', '-23.44', '184.6', '63', '4.8', '27']\n",
      "['556', '-23.12', '184.42', '104', '4.2', '17']\n",
      "['557', '-23.65', '184.46', '93', '4.2', '16']\n",
      "['558', '-22.91', '183.95', '64', '5.9', '118']\n",
      "['559', '-22.06', '180.47', '587', '4.6', '28']\n",
      "['560', '-13.56', '166.49', '83', '4.5', '25']\n",
      "['561', '-17.99', '181.57', '579', '4.9', '49']\n",
      "['562', '-23.92', '184.47', '40', '4.7', '17']\n",
      "['563', '-30.69', '182.1', '62', '4.9', '25']\n",
      "['564', '-21.92', '182.8', '273', '5.3', '78']\n",
      "['565', '-25.04', '180.97', '393', '4.2', '21']\n",
      "['566', '-19.92', '183.91', '264', '4.2', '23']\n",
      "['567', '-27.75', '182.26', '174', '4.5', '18']\n",
      "['568', '-17.71', '181.18', '574', '5.2', '67']\n",
      "['569', '-19.6', '183.84', '309', '4.5', '23']\n",
      "['570', '-34.68', '179.82', '75', '5.6', '79']\n",
      "['571', '-14.46', '167.26', '195', '5.2', '87']\n",
      "['572', '-18.85', '187.55', '44', '4.8', '35']\n",
      "['573', '-17.02', '182.41', '420', '4.5', '29']\n",
      "['574', '-20.41', '186.51', '63', '5', '28']\n",
      "['575', '-18.18', '182.04', '609', '4.4', '26']\n",
      "['576', '-16.49', '187.8', '40', '4.5', '18']\n",
      "['577', '-17.74', '181.31', '575', '4.6', '42']\n",
      "['578', '-20.49', '181.69', '559', '4.5', '24']\n",
      "['579', '-18.51', '182.64', '405', '5.2', '74']\n",
      "['580', '-27.28', '183.4', '70', '5.1', '54']\n",
      "['581', '-15.9', '167.16', '41', '4.8', '42']\n",
      "['582', '-20.57', '181.33', '605', '4.3', '18']\n",
      "['583', '-11.25', '166.36', '130', '5.1', '55']\n",
      "['584', '-20.04', '181.87', '577', '4.7', '19']\n",
      "['585', '-20.89', '181.25', '599', '4.6', '20']\n",
      "['586', '-16.62', '186.74', '82', '4.8', '51']\n",
      "['587', '-20.09', '168.75', '50', '4.6', '23']\n",
      "['588', '-24.96', '179.87', '480', '4.4', '25']\n",
      "['589', '-20.95', '181.42', '559', '4.6', '27']\n",
      "['590', '-23.31', '179.27', '566', '5.1', '49']\n",
      "['591', '-20.95', '181.06', '611', '4.3', '20']\n",
      "['592', '-21.58', '181.9', '409', '4.4', '19']\n",
      "['593', '-13.62', '167.15', '209', '4.7', '30']\n",
      "['594', '-12.72', '166.28', '70', '4.8', '47']\n",
      "['595', '-21.79', '185', '74', '4.1', '15']\n",
      "['596', '-20.48', '169.76', '134', '4.6', '33']\n",
      "['597', '-12.84', '166.78', '150', '4.9', '35']\n",
      "['598', '-17.02', '182.93', '406', '4', '17']\n",
      "['599', '-23.89', '182.39', '243', '4.7', '32']\n",
      "['600', '-23.07', '184.03', '89', '4.7', '32']\n",
      "['601', '-27.98', '181.96', '53', '5.2', '89']\n",
      "['602', '-28.1', '182.25', '68', '4.6', '18']\n",
      "['603', '-21.24', '180.81', '605', '4.6', '34']\n",
      "['604', '-21.24', '180.86', '615', '4.9', '23']\n",
      "['605', '-19.89', '174.46', '546', '5.7', '99']\n",
      "['606', '-32.82', '179.8', '176', '4.7', '26']\n",
      "['607', '-22', '185.5', '52', '4.4', '18']\n",
      "['608', '-21.57', '185.62', '66', '4.9', '38']\n",
      "['609', '-24.5', '180.92', '377', '4.8', '43']\n",
      "['610', '-33.03', '180.2', '186', '4.6', '27']\n",
      "['611', '-30.09', '182.4', '51', '4.4', '18']\n",
      "['612', '-22.75', '170.99', '67', '4.8', '35']\n",
      "['613', '-17.99', '168.98', '234', '4.7', '28']\n",
      "['614', '-19.6', '181.87', '597', '4.2', '18']\n",
      "['615', '-15.65', '186.26', '64', '5.1', '54']\n",
      "['616', '-17.78', '181.53', '511', '4.8', '56']\n",
      "['617', '-22.04', '184.91', '47', '4.9', '47']\n",
      "['618', '-20.06', '168.69', '49', '5.1', '49']\n",
      "['619', '-18.07', '181.54', '546', '4.3', '28']\n",
      "['620', '-12.85', '165.67', '75', '4.4', '30']\n",
      "['621', '-33.29', '181.3', '60', '4.7', '33']\n",
      "['622', '-34.63', '179.1', '278', '4.7', '24']\n",
      "['623', '-24.18', '179.02', '550', '5.3', '86']\n",
      "['624', '-23.78', '180.31', '518', '5.1', '71']\n",
      "['625', '-22.37', '171.5', '116', '4.9', '38']\n",
      "['626', '-23.97', '179.91', '518', '4.5', '23']\n",
      "['627', '-34.12', '181.75', '75', '4.7', '41']\n",
      "['628', '-25.25', '179.86', '491', '4.2', '23']\n",
      "['629', '-22.87', '172.65', '56', '5.1', '50']\n",
      "['630', '-18.48', '182.37', '376', '4.8', '57']\n",
      "['631', '-21.46', '181.02', '584', '4.2', '18']\n",
      "['632', '-28.56', '183.47', '48', '4.8', '56']\n",
      "['633', '-28.56', '183.59', '53', '4.4', '20']\n",
      "['634', '-21.3', '180.92', '617', '4.5', '26']\n",
      "['635', '-20.08', '183.22', '294', '4.3', '18']\n",
      "['636', '-18.82', '182.21', '417', '5.6', '129']\n",
      "['637', '-19.51', '183.97', '280', '4', '16']\n",
      "['638', '-12.05', '167.39', '332', '5', '36']\n",
      "['639', '-17.4', '186.54', '85', '4.2', '28']\n",
      "['640', '-23.93', '180.18', '525', '4.6', '31']\n",
      "['641', '-21.23', '181.09', '613', '4.6', '18']\n",
      "['642', '-16.23', '167.91', '182', '4.5', '28']\n",
      "['643', '-28.15', '183.4', '57', '5', '32']\n",
      "['644', '-20.81', '185.01', '79', '4.7', '42']\n",
      "['645', '-20.72', '181.41', '595', '4.6', '36']\n",
      "['646', '-23.29', '184', '164', '4.8', '50']\n",
      "['647', '-38.46', '176.03', '148', '4.6', '44']\n",
      "['648', '-15.48', '186.73', '82', '4.4', '17']\n",
      "['649', '-37.03', '177.52', '153', '5.6', '87']\n",
      "['650', '-20.48', '181.38', '556', '4.2', '13']\n",
      "['651', '-18.12', '181.88', '649', '5.4', '88']\n",
      "['652', '-18.17', '181.98', '651', '4.8', '43']\n",
      "['653', '-11.4', '166.07', '93', '5.6', '94']\n",
      "['654', '-23.1', '180.12', '533', '4.4', '27']\n",
      "['655', '-14.28', '170.34', '642', '4.7', '29']\n",
      "['656', '-22.87', '171.72', '47', '4.6', '27']\n",
      "['657', '-17.59', '180.98', '548', '5.1', '79']\n",
      "['658', '-27.6', '182.1', '154', '4.6', '22']\n",
      "['659', '-17.94', '180.6', '627', '4.5', '29']\n",
      "['660', '-17.88', '180.58', '622', '4.2', '23']\n",
      "['661', '-30.01', '180.8', '286', '4.8', '43']\n",
      "['662', '-19.19', '182.3', '390', '4.9', '48']\n",
      "['663', '-18.14', '180.87', '624', '5.5', '105']\n",
      "['664', '-23.46', '180.11', '539', '5', '41']\n",
      "['665', '-18.44', '181.04', '624', '4.2', '21']\n",
      "['666', '-18.21', '180.87', '631', '5.2', '69']\n",
      "['667', '-18.26', '180.98', '631', '4.8', '36']\n",
      "['668', '-15.85', '184.83', '299', '4.4', '30']\n",
      "['669', '-23.82', '180.09', '498', '4.8', '40']\n",
      "['670', '-18.6', '184.28', '255', '4.4', '31']\n",
      "['671', '-17.8', '181.32', '539', '4.1', '12']\n",
      "['672', '-10.78', '166.1', '195', '4.9', '45']\n",
      "['673', '-18.12', '181.71', '594', '4.6', '24']\n",
      "['674', '-19.34', '182.62', '573', '4.5', '32']\n",
      "['675', '-15.34', '167.1', '128', '5.3', '18']\n",
      "['676', '-24.97', '182.85', '137', '4.8', '40']\n",
      "['677', '-15.97', '186.08', '143', '4.6', '41']\n",
      "['678', '-23.47', '180.24', '511', '4.8', '37']\n",
      "['679', '-23.11', '179.15', '564', '4.7', '17']\n",
      "['680', '-20.54', '181.66', '559', '4.9', '50']\n",
      "['681', '-18.92', '169.37', '248', '5.3', '60']\n",
      "['682', '-20.16', '184.27', '210', '4.4', '27']\n",
      "['683', '-25.48', '180.94', '390', '4.6', '33']\n",
      "['684', '-18.19', '181.74', '616', '4.3', '17']\n",
      "['685', '-15.35', '186.4', '98', '4.4', '17']\n",
      "['686', '-18.69', '169.1', '218', '4.2', '27']\n",
      "['687', '-18.89', '181.24', '655', '4.1', '14']\n",
      "['688', '-17.61', '183.32', '356', '4.2', '15']\n",
      "['689', '-20.93', '181.54', '564', '5', '64']\n",
      "['690', '-17.6', '181.5', '548', '4.1', '10']\n",
      "['691', '-17.96', '181.4', '655', '4.3', '20']\n",
      "['692', '-18.8', '182.41', '385', '5.2', '67']\n",
      "['693', '-20.61', '182.44', '518', '4.2', '10']\n",
      "['694', '-20.74', '181.53', '598', '4.5', '36']\n",
      "['695', '-25.23', '179.86', '476', '4.4', '29']\n",
      "['696', '-23.9', '179.9', '579', '4.4', '16']\n",
      "['697', '-18.07', '181.58', '603', '5', '65']\n",
      "['698', '-15.43', '185.19', '249', '4', '11']\n",
      "['699', '-14.3', '167.32', '208', '4.8', '25']\n",
      "['700', '-18.04', '181.57', '587', '5', '51']\n",
      "['701', '-13.9', '167.18', '221', '4.2', '21']\n",
      "['702', '-17.64', '177.01', '545', '5.2', '91']\n",
      "['703', '-17.98', '181.51', '586', '5.2', '68']\n",
      "['704', '-25', '180', '488', '4.5', '10']\n",
      "['705', '-19.45', '184.48', '246', '4.3', '15']\n",
      "['706', '-16.11', '187.48', '61', '4.5', '19']\n",
      "['707', '-23.73', '179.98', '524', '4.6', '11']\n",
      "['708', '-17.74', '186.78', '104', '5.1', '71']\n",
      "['709', '-21.56', '183.23', '271', '4.4', '36']\n",
      "['710', '-20.97', '181.72', '487', '4.3', '16']\n",
      "['711', '-15.45', '186.73', '83', '4.7', '37']\n",
      "['712', '-15.93', '167.91', '183', '5.6', '109']\n",
      "['713', '-21.47', '185.86', '55', '4.9', '46']\n",
      "['714', '-21.44', '170.45', '166', '5.1', '22']\n",
      "['715', '-22.16', '180.49', '586', '4.6', '13']\n",
      "['716', '-13.36', '172.76', '618', '4.4', '18']\n",
      "['717', '-21.22', '181.51', '524', '4.8', '49']\n",
      "['718', '-26.1', '182.5', '133', '4.2', '17']\n",
      "['719', '-18.35', '185.27', '201', '4.7', '57']\n",
      "['720', '-17.2', '182.9', '383', '4.1', '11']\n",
      "['721', '-22.42', '171.4', '86', '4.7', '33']\n",
      "['722', '-17.91', '181.48', '555', '4', '17']\n",
      "['723', '-26.53', '178.3', '605', '4.9', '43']\n",
      "['724', '-26.5', '178.29', '609', '5', '50']\n",
      "['725', '-16.31', '168.08', '204', '4.5', '16']\n",
      "['726', '-18.76', '169.71', '287', '4.4', '23']\n",
      "['727', '-17.1', '182.8', '390', '4', '14']\n",
      "['728', '-19.28', '182.78', '348', '4.5', '30']\n",
      "['729', '-23.5', '180', '550', '4.7', '23']\n",
      "['730', '-21.26', '181.69', '487', '4.4', '20']\n",
      "['731', '-17.97', '181.48', '578', '4.7', '43']\n",
      "['732', '-26.02', '181.2', '361', '4.7', '32']\n",
      "['733', '-30.3', '180.8', '275', '4', '14']\n",
      "['734', '-24.89', '179.67', '498', '4.2', '14']\n",
      "['735', '-14.57', '167.24', '162', '4.5', '18']\n",
      "['736', '-15.4', '186.87', '78', '4.7', '44']\n",
      "['737', '-22.06', '183.95', '134', '4.5', '17']\n",
      "['738', '-25.14', '178.42', '554', '4.1', '15']\n",
      "['739', '-20.3', '181.4', '608', '4.6', '13']\n",
      "['740', '-25.28', '181.17', '367', '4.3', '25']\n",
      "['741', '-20.63', '181.61', '599', '4.6', '30']\n",
      "['742', '-19.02', '186.83', '45', '5.2', '65']\n",
      "['743', '-22.1', '185.3', '50', '4.6', '22']\n",
      "['744', '-38.59', '175.7', '162', '4.7', '36']\n",
      "['745', '-19.3', '183', '302', '5', '65']\n",
      "['746', '-31.03', '181.59', '57', '5.2', '49']\n",
      "['747', '-30.51', '181.3', '203', '4.4', '20']\n",
      "['748', '-22.55', '183.34', '66', '4.6', '18']\n",
      "['749', '-22.14', '180.64', '591', '4.5', '18']\n",
      "['750', '-25.6', '180.3', '440', '4', '12']\n",
      "['751', '-18.04', '181.84', '611', '4.2', '20']\n",
      "['752', '-21.29', '185.77', '57', '5.3', '69']\n",
      "['753', '-21.08', '180.85', '627', '5.9', '119']\n",
      "['754', '-20.64', '169.66', '89', '4.9', '42']\n",
      "['755', '-24.41', '180.03', '500', '4.5', '34']\n",
      "['756', '-12.16', '167.03', '264', '4.4', '14']\n",
      "['757', '-17.1', '185.9', '127', '5.4', '75']\n",
      "['758', '-21.13', '185.6', '85', '5.3', '86']\n",
      "['759', '-12.34', '167.43', '50', '5.1', '47']\n",
      "['760', '-16.43', '186.73', '75', '4.1', '20']\n",
      "['761', '-20.7', '184.3', '182', '4.3', '17']\n",
      "['762', '-21.18', '180.92', '619', '4.5', '18']\n",
      "['763', '-17.78', '185.33', '223', '4.1', '10']\n",
      "['764', '-21.57', '183.86', '156', '5.1', '70']\n",
      "['765', '-13.7', '166.75', '46', '5.3', '71']\n",
      "['766', '-12.27', '167.41', '50', '4.5', '29']\n",
      "['767', '-19.1', '184.52', '230', '4.1', '16']\n",
      "['768', '-19.85', '184.51', '184', '4.4', '26']\n",
      "['769', '-11.37', '166.55', '188', '4.7', '24']\n",
      "['770', '-20.7', '186.3', '80', '4', '10']\n",
      "['771', '-20.24', '185.1', '86', '5.1', '61']\n",
      "['772', '-16.4', '182.73', '391', '4', '16']\n",
      "['773', '-19.6', '184.53', '199', '4.3', '21']\n",
      "['774', '-21.63', '180.77', '592', '4.3', '21']\n",
      "['775', '-21.6', '180.5', '595', '4', '22']\n",
      "['776', '-21.77', '181', '618', '4.1', '10']\n",
      "['777', '-21.8', '183.6', '213', '4.4', '17']\n",
      "['778', '-21.05', '180.9', '616', '4.3', '10']\n",
      "['779', '-10.8', '165.8', '175', '4.2', '12']\n",
      "['780', '-17.9', '181.5', '589', '4', '12']\n",
      "['781', '-22.26', '171.44', '83', '4.5', '25']\n",
      "['782', '-22.33', '171.46', '119', '4.7', '32']\n",
      "['783', '-24.04', '184.85', '70', '5', '48']\n",
      "['784', '-20.4', '186.1', '74', '4.3', '22']\n",
      "['785', '-15', '184.62', '40', '5.1', '54']\n",
      "['786', '-27.87', '183.4', '87', '4.7', '34']\n",
      "['787', '-14.12', '166.64', '63', '5.3', '69']\n",
      "['788', '-23.61', '180.27', '537', '5', '63']\n",
      "['789', '-21.56', '185.5', '47', '4.5', '29']\n",
      "['790', '-21.19', '181.58', '490', '5', '77']\n",
      "['791', '-18.07', '181.65', '593', '4.1', '16']\n",
      "['792', '-26', '178.43', '644', '4.9', '27']\n",
      "['793', '-20.21', '181.9', '576', '4.1', '16']\n",
      "['794', '-28', '182', '199', '4', '16']\n",
      "['795', '-20.74', '180.7', '589', '4.4', '27']\n",
      "['796', '-31.8', '180.6', '178', '4.5', '19']\n",
      "['797', '-18.91', '169.46', '248', '4.4', '33']\n",
      "['798', '-20.45', '182.1', '500', '4.5', '37']\n",
      "['799', '-22.9', '183.8', '71', '4.3', '19']\n",
      "['800', '-18.11', '181.63', '568', '4.3', '36']\n",
      "['801', '-23.8', '184.7', '42', '5', '36']\n",
      "['802', '-23.42', '180.21', '510', '4.5', '37']\n",
      "['803', '-23.2', '184.8', '97', '4.5', '13']\n",
      "['804', '-12.93', '169.52', '663', '4.4', '30']\n",
      "['805', '-21.14', '181.06', '625', '4.5', '35']\n",
      "['806', '-19.13', '184.97', '210', '4.1', '22']\n",
      "['807', '-21.08', '181.3', '557', '4.9', '78']\n",
      "['808', '-20.07', '181.75', '582', '4.7', '27']\n",
      "['809', '-20.9', '182.02', '402', '4.3', '18']\n",
      "['810', '-25.04', '179.84', '474', '4.6', '32']\n",
      "['811', '-21.85', '180.89', '577', '4.6', '43']\n",
      "['812', '-19.34', '186.59', '56', '5.2', '49']\n",
      "['813', '-15.83', '167.1', '43', '4.5', '19']\n",
      "['814', '-23.73', '183', '118', '4.3', '11']\n",
      "['815', '-18.1', '181.72', '544', '4.6', '52']\n",
      "['816', '-22.12', '180.49', '532', '4', '14']\n",
      "['817', '-15.39', '185.1', '237', '4.5', '39']\n",
      "['818', '-16.21', '186.52', '111', '4.8', '30']\n",
      "['819', '-21.75', '180.67', '595', '4.6', '30']\n",
      "['820', '-22.1', '180.4', '603', '4.1', '11']\n",
      "['821', '-24.97', '179.54', '505', '4.9', '50']\n",
      "['822', '-19.36', '186.36', '100', '4.7', '40']\n",
      "['823', '-22.14', '179.62', '587', '4.1', '23']\n",
      "['824', '-21.48', '182.44', '364', '4.3', '20']\n",
      "['825', '-18.54', '168.93', '100', '4.4', '17']\n",
      "['826', '-21.62', '182.4', '350', '4', '12']\n",
      "['827', '-13.4', '166.9', '228', '4.8', '15']\n",
      "['828', '-15.5', '185.3', '93', '4.4', '25']\n",
      "['829', '-15.67', '185.23', '66', '4.4', '34']\n",
      "['830', '-21.78', '183.11', '225', '4.6', '21']\n",
      "['831', '-30.63', '180.9', '334', '4.2', '28']\n",
      "['832', '-15.7', '185.1', '70', '4.1', '15']\n",
      "['833', '-19.2', '184.37', '220', '4.2', '18']\n",
      "['834', '-19.7', '182.44', '397', '4', '12']\n",
      "['835', '-19.4', '182.29', '326', '4.1', '15']\n",
      "['836', '-15.85', '185.9', '121', '4.1', '17']\n",
      "['837', '-17.38', '168.63', '209', '4.7', '29']\n",
      "['838', '-24.33', '179.97', '510', '4.8', '44']\n",
      "['839', '-20.89', '185.26', '54', '5.1', '44']\n",
      "['840', '-18.97', '169.44', '242', '5', '41']\n",
      "['841', '-17.99', '181.62', '574', '4.8', '38']\n",
      "['842', '-15.8', '185.25', '82', '4.4', '39']\n",
      "['843', '-25.42', '182.65', '102', '5', '36']\n",
      "['844', '-21.6', '169.9', '43', '5.2', '56']\n",
      "['845', '-26.06', '180.05', '432', '4.2', '19']\n",
      "['846', '-17.56', '181.23', '580', '4.1', '16']\n",
      "['847', '-25.63', '180.26', '464', '4.8', '60']\n",
      "['848', '-25.46', '179.98', '479', '4.5', '27']\n",
      "['849', '-22.23', '180.48', '581', '5', '54']\n",
      "['850', '-21.55', '181.39', '513', '5.1', '81']\n",
      "['851', '-15.18', '185.93', '77', '4.1', '16']\n",
      "['852', '-13.79', '166.56', '68', '4.7', '41']\n",
      "['853', '-15.18', '167.23', '71', '5.2', '59']\n",
      "['854', '-18.78', '186.72', '68', '4.8', '48']\n",
      "['855', '-17.9', '181.41', '586', '4.5', '33']\n",
      "['856', '-18.5', '185.4', '243', '4', '11']\n",
      "['857', '-14.82', '171.17', '658', '4.7', '49']\n",
      "['858', '-15.65', '185.17', '315', '4.1', '15']\n",
      "['859', '-30.01', '181.15', '210', '4.3', '17']\n",
      "['860', '-13.16', '167.24', '278', '4.3', '17']\n",
      "['861', '-21.03', '180.78', '638', '4', '14']\n",
      "['862', '-21.4', '180.78', '615', '4.7', '51']\n",
      "['863', '-17.93', '181.89', '567', '4.1', '27']\n",
      "['864', '-20.87', '181.7', '560', '4.2', '13']\n",
      "['865', '-12.01', '166.66', '99', '4.8', '36']\n",
      "['866', '-19.1', '169.63', '266', '4.8', '31']\n",
      "['867', '-22.85', '181.37', '397', '4.2', '15']\n",
      "['868', '-17.08', '185.96', '180', '4.2', '29']\n",
      "['869', '-21.14', '174.21', '40', '5.7', '78']\n",
      "['870', '-12.23', '167.02', '242', '6', '132']\n",
      "['871', '-20.91', '181.57', '530', '4.2', '20']\n",
      "['872', '-11.38', '167.05', '133', '4.5', '32']\n",
      "['873', '-11.02', '167.01', '62', '4.9', '36']\n",
      "['874', '-22.09', '180.58', '580', '4.4', '22']\n",
      "['875', '-17.8', '181.2', '530', '4', '15']\n",
      "['876', '-18.94', '182.43', '566', '4.3', '20']\n",
      "['877', '-18.85', '182.2', '501', '4.2', '23']\n",
      "['878', '-21.91', '181.28', '548', '4.5', '30']\n",
      "['879', '-22.03', '179.77', '587', '4.8', '31']\n",
      "['880', '-18.1', '181.63', '592', '4.4', '28']\n",
      "['881', '-18.4', '184.84', '221', '4.2', '18']\n",
      "['882', '-21.2', '181.4', '560', '4.2', '12']\n",
      "['883', '-12', '166.2', '94', '5', '31']\n",
      "['884', '-11.7', '166.3', '139', '4.2', '15']\n",
      "['885', '-26.72', '182.69', '162', '5.2', '64']\n",
      "['886', '-24.39', '178.98', '562', '4.5', '30']\n",
      "['887', '-19.64', '169.5', '204', '4.6', '35']\n",
      "['888', '-21.35', '170.04', '56', '5', '22']\n",
      "['889', '-22.82', '184.52', '49', '5', '52']\n",
      "['890', '-38.28', '177.1', '100', '5.4', '71']\n",
      "['891', '-12.57', '167.11', '231', '4.8', '28']\n",
      "['892', '-22.24', '180.28', '601', '4.2', '21']\n",
      "['893', '-13.8', '166.53', '42', '5.5', '70']\n",
      "['894', '-21.07', '183.78', '180', '4.3', '25']\n",
      "['895', '-17.74', '181.25', '559', '4.1', '16']\n",
      "['896', '-23.87', '180.15', '524', '4.4', '22']\n",
      "['897', '-21.29', '185.8', '69', '4.9', '74']\n",
      "['898', '-22.2', '180.58', '594', '4.5', '45']\n",
      "['899', '-15.24', '185.11', '262', '4.9', '56']\n",
      "['900', '-17.82', '181.27', '538', '4', '33']\n",
      "['901', '-32.14', '180', '331', '4.5', '27']\n",
      "['902', '-19.3', '185.86', '48', '5', '40']\n",
      "['903', '-33.09', '180.94', '47', '4.9', '47']\n",
      "['904', '-20.18', '181.62', '558', '4.5', '31']\n",
      "['905', '-17.46', '181.42', '524', '4.2', '16']\n",
      "['906', '-17.44', '181.33', '545', '4.2', '37']\n",
      "['907', '-24.71', '179.85', '477', '4.2', '34']\n",
      "['908', '-21.53', '170.52', '129', '5.2', '30']\n",
      "['909', '-19.17', '169.53', '268', '4.3', '21']\n",
      "['910', '-28.05', '182.39', '117', '5.1', '43']\n",
      "['911', '-23.39', '179.97', '541', '4.6', '50']\n",
      "['912', '-22.33', '171.51', '112', '4.6', '14']\n",
      "['913', '-15.28', '185.98', '162', '4.4', '36']\n",
      "['914', '-20.27', '181.51', '609', '4.4', '32']\n",
      "['915', '-10.96', '165.97', '76', '4.9', '64']\n",
      "['916', '-21.52', '169.75', '61', '5.1', '40']\n",
      "['917', '-19.57', '184.47', '202', '4.2', '28']\n",
      "['918', '-23.08', '183.45', '90', '4.7', '30']\n",
      "['919', '-25.06', '182.8', '133', '4', '14']\n",
      "['920', '-17.85', '181.44', '589', '5.6', '115']\n",
      "['921', '-15.99', '167.95', '190', '5.3', '81']\n",
      "['922', '-20.56', '184.41', '138', '5', '82']\n",
      "['923', '-17.98', '181.61', '598', '4.3', '27']\n",
      "['924', '-18.4', '181.77', '600', '4.1', '11']\n",
      "['925', '-27.64', '182.22', '162', '5.1', '67']\n",
      "['926', '-20.99', '181.02', '626', '4.5', '36']\n",
      "['927', '-14.86', '167.32', '137', '4.9', '22']\n",
      "['928', '-29.33', '182.72', '57', '5.4', '61']\n",
      "['929', '-25.81', '182.54', '201', '4.7', '40']\n",
      "['930', '-14.1', '166.01', '69', '4.8', '29']\n",
      "['931', '-17.63', '185.13', '219', '4.5', '28']\n",
      "['932', '-23.47', '180.21', '553', '4.2', '23']\n",
      "['933', '-23.92', '180.21', '524', '4.6', '50']\n",
      "['934', '-20.88', '185.18', '51', '4.6', '28']\n",
      "['935', '-20.25', '184.75', '107', '5.6', '121']\n",
      "['936', '-19.33', '186.16', '44', '5.4', '110']\n",
      "['937', '-18.14', '181.71', '574', '4', '20']\n",
      "['938', '-22.41', '183.99', '128', '5.2', '72']\n",
      "['939', '-20.77', '181.16', '568', '4.2', '12']\n",
      "['940', '-17.95', '181.73', '583', '4.7', '57']\n",
      "['941', '-20.83', '181.01', '622', '4.3', '15']\n",
      "['942', '-27.84', '182.1', '193', '4.8', '27']\n",
      "['943', '-19.94', '182.39', '544', '4.6', '30']\n",
      "['944', '-23.6', '183.99', '118', '5.4', '88']\n",
      "['945', '-23.7', '184.13', '51', '4.8', '27']\n",
      "['946', '-30.39', '182.4', '63', '4.6', '22']\n",
      "['947', '-18.98', '182.32', '442', '4.2', '22']\n",
      "['948', '-27.89', '182.92', '87', '5.5', '67']\n",
      "['949', '-23.5', '184.9', '61', '4.7', '16']\n",
      "['950', '-23.73', '184.49', '60', '4.7', '35']\n",
      "['951', '-17.93', '181.62', '561', '4.5', '32']\n",
      "['952', '-35.94', '178.52', '138', '5.5', '78']\n",
      "['953', '-18.68', '184.5', '174', '4.5', '34']\n",
      "['954', '-23.47', '179.95', '543', '4.1', '21']\n",
      "['955', '-23.49', '180.06', '530', '4', '23']\n",
      "['956', '-23.85', '180.26', '497', '4.3', '32']\n",
      "['957', '-27.08', '183.44', '63', '4.7', '27']\n",
      "['958', '-20.88', '184.95', '82', '4.9', '50']\n",
      "['959', '-20.97', '181.2', '605', '4.5', '31']\n",
      "['960', '-21.71', '183.58', '234', '4.7', '55']\n",
      "['961', '-23.9', '184.6', '41', '4.5', '22']\n",
      "['962', '-15.78', '167.44', '40', '4.8', '42']\n",
      "['963', '-12.57', '166.72', '137', '4.3', '20']\n",
      "['964', '-19.69', '184.23', '223', '4.1', '23']\n",
      "['965', '-22.04', '183.95', '109', '5.4', '61']\n",
      "['966', '-17.99', '181.59', '595', '4.1', '26']\n",
      "['967', '-23.5', '180.13', '512', '4.8', '40']\n",
      "['968', '-21.4', '180.74', '613', '4.2', '20']\n",
      "['969', '-15.86', '166.98', '60', '4.8', '25']\n",
      "['970', '-23.95', '184.64', '43', '5.4', '45']\n",
      "['971', '-25.79', '182.38', '172', '4.4', '14']\n",
      "['972', '-23.75', '184.5', '54', '5.2', '74']\n",
      "['973', '-24.1', '184.5', '68', '4.7', '23']\n",
      "['974', '-18.56', '169.05', '217', '4.9', '35']\n",
      "['975', '-23.3', '184.68', '102', '4.9', '27']\n",
      "['976', '-17.03', '185.74', '178', '4.2', '32']\n",
      "['977', '-20.77', '183.71', '251', '4.4', '47']\n",
      "['978', '-28.1', '183.5', '42', '4.4', '17']\n",
      "['979', '-18.83', '182.26', '575', '4.3', '11']\n",
      "['980', '-23', '170.7', '43', '4.9', '20']\n",
      "['981', '-20.82', '181.67', '577', '5', '67']\n",
      "['982', '-22.95', '170.56', '42', '4.7', '21']\n",
      "['983', '-28.22', '183.6', '75', '4.9', '49']\n",
      "['984', '-27.99', '183.5', '71', '4.3', '22']\n",
      "['985', '-15.54', '187.15', '60', '4.5', '17']\n",
      "['986', '-12.37', '166.93', '291', '4.2', '16']\n",
      "['987', '-22.33', '171.66', '125', '5.2', '51']\n",
      "['988', '-22.7', '170.3', '69', '4.8', '27']\n",
      "['989', '-17.86', '181.3', '614', '4', '12']\n",
      "['990', '-16', '184.53', '108', '4.7', '33']\n",
      "['991', '-20.73', '181.42', '575', '4.3', '18']\n",
      "['992', '-15.45', '181.42', '409', '4.3', '27']\n",
      "['993', '-20.05', '183.86', '243', '4.9', '65']\n",
      "['994', '-17.95', '181.37', '642', '4', '17']\n",
      "['995', '-17.7', '188.1', '45', '4.2', '10']\n",
      "['996', '-25.93', '179.54', '470', '4.4', '22']\n",
      "['997', '-12.28', '167.06', '248', '4.7', '35']\n",
      "['998', '-20.13', '184.2', '244', '4.5', '34']\n",
      "['999', '-17.4', '187.8', '40', '4.5', '14']\n",
      "['1000', '-21.59', '170.56', '165', '6', '119']\n"
     ]
    }
   ],
   "source": [
    "csv_url = url\n",
    "\n",
    "with requests.Session() as s:\n",
    "    download = s.get(csv_url)\n",
    "    decoded_content = download.content.decode('utf-8')\n",
    "    cr = csv.reader(decoded_content.splitlines(), delimiter=',', quotechar='\"')\n",
    "    datalist = list(cr)\n",
    "    for row in datalist:\n",
    "        print(row)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating the database and table\n",
    "\n",
    "We opted to create a [sqlite](https://www.sqlite.org/index.html) database because is lightweight in terms of setup, database administration and required resource. Once the database is created, we will create a table named `quakes` with the same column names of the dataset examined previously. To do that we will use the [SQL CREATE TABLE Statement](https://www.w3schools.com/sql/sql_create_table.asp)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create database\n",
    "conn = sqlite3.connect('eartquakes.sqlite')\n",
    "cur = conn.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sqlite3.Cursor at 0x3fb62790a0>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create table\n",
    "cur.execute('''CREATE TABLE IF NOT EXISTS quakes\n",
    "    (id INTEGER PRIMARY KEY, lat REAL, lon REAL, depth INTEGER,\n",
    "    mag REAL, stations INTEGER)''')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Populating the database with earthquake data\n",
    "\n",
    "In this part, we will get and read the dataset for the URL and use these data to populate the database. Then we will drop some line codes and SQL statements to calculate: total earthquakes, average magnitude and depth, and strong and first minor earthquake."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "%%capture\n",
    "\n",
    "url = url\n",
    "# get and read data (on line)\n",
    "with closing(requests.get(url, stream=True)) as r:\n",
    "    f = (line.decode('utf-8') for line in r.iter_lines())\n",
    "    reader = csv.reader(f, delimiter=',', quotechar='\"')\n",
    "    next(reader)\n",
    "    \n",
    "    # populate the database\n",
    "    list = []\n",
    "    for row in reader:\n",
    "        list.append(row)\n",
    "    for item in list:\n",
    "        cur.execute('INSERT OR IGNORE INTO quakes (id, lat, lon, depth, mag, stations) VALUES ( ?, ?, ?, ?, ?, ?)', ( item[0],item[1],item[2],item[3],item[4],item[5], ) )\n",
    "    conn.commit()\n",
    "    \n",
    "    # total earthquakes\n",
    "    cur.execute(\"SELECT COUNT(*) from quakes\")\n",
    "    for row in cur:\n",
    "        count = row[0]\n",
    "    \n",
    "    # average magnitude\n",
    "    cur.execute(\"SELECT AVG(mag) from quakes\")\n",
    "    for row in cur:\n",
    "        magAvg = row[0]\n",
    "    \n",
    "    # average depth\n",
    "    cur.execute(\"SELECT AVG(depth) from quakes\")\n",
    "    for row in cur:\n",
    "        depAvg = row[0]\n",
    "    \n",
    "    # strong and first minor earthquake in the dataset\n",
    "    cur.execute(\"SELECT MAX(mag), id, lat, lon, depth FROM quakes\")\n",
    "    for row in cur:\n",
    "        mag = row[0]\n",
    "        id = row[1]\n",
    "        lat = row[2]\n",
    "        lon = row[3]\n",
    "        depth = row[4]\n",
    "    cur.execute(\"SELECT MIN(mag), id, lat, lon, depth FROM quakes\")\n",
    "    for row in cur:\n",
    "        mag2 = row[0]\n",
    "        id2 = row[1]\n",
    "        lat2 = row[2]\n",
    "        lon2 = row[3]\n",
    "        depth2 = row[4]\n",
    "\n",
    "    # id and magnitude dictionary\n",
    "    cur.execute(\"SELECT id, mag FROM quakes\")\n",
    "    dict = {rows[0]:rows[1] for rows in cur}\n",
    "    cur.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Printing the results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Number of earthquakes: 1000\n",
      "\n",
      "Average magnitude (Richter): 4.6\n",
      "\n",
      "Average depth (km): 311.37\n",
      "\n",
      "Strong earthquake: ID:152, latitude:-15.56, longitude:167.62, magnitude(Richter):6.4, depth(km):127\n",
      "\n",
      "First Minor earthquake: ID:5, latitude:-20.42, longitude:181.96, magnitude(Richter):4.0, depth (km):649\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print()\n",
    "print(\"Number of earthquakes: \"+str(count)+\"\\n\")\n",
    "print(\"Average magnitude (Richter): \"+str(round(magAvg,1))+\"\\n\")\n",
    "print(\"Average depth (km): \"+str(round(depAvg,2))+\"\\n\")\n",
    "print(\"Strong earthquake: ID:\"+str(id)+\", latitude:\"+str(lat)+\", longitude:\"+str(lon)+\\\n",
    "      \", magnitude(Richter):\"+str(mag)+\", depth(km):\"+str(depth)+\"\\n\")\n",
    "print(\"First Minor earthquake: ID:\"+str(id2)+\", latitude:\"\\\n",
    "      +str(lat2)+\", longitude:\"+str(lon2)+\", magnitude(Richter):\"+str(mag2)+\\\n",
    "      \", depth (km):\"+str(depth2)+\"\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Calculating Distances\n",
    "\n",
    "Next, we will calculate the distance between the largest and smallest earthquake magnitude. To do that we will use the [Haversine Distance](https://en.wikipedia.org/wiki/Haversine_formula) which calculates the shortest distance between two coordinates. This is pretty similar to the [Euclidian Distance](https://en.wikipedia.org/wiki/Euclidean_distance), except it allows us to account for the spherical shape of the Earth."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Distance between the strongest earthquake (ID:152) and the weakest earthquake (ID:5): 1609.06 km.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Haversine distance formula\n",
    "import math\n",
    "x_dist = math.radians(lon2-lon)\n",
    "y_dist = math.radians(lat2-lat)\n",
    "y1_rad = math.radians(lat)\n",
    "y2_rad = math.radians(lat2)\n",
    "a = math.sin(y_dist/2)**2 + math.sin(x_dist/2)**2 \\\n",
    "* math.cos(y1_rad) * math.cos(y2_rad)\n",
    "c = 2*math.asin(math.sqrt(a))\n",
    "distance = c * 6371 # kilometers\n",
    "print()\n",
    "print(\"Distance between the strongest the earthquake (ID:\"+str(id) +\") and the weakest earthquake \\\n",
    "(ID:\"+str(id2)+\"): \"+str(round(distance,2))+\" km.\\n\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Classifying Earthquakes by Magnitude\n",
    "\n",
    "In this section, we are going to classify the earthquakes by magnitude according to the [Mercalli Intensity Scale](https://en.wikipedia.org/wiki/Modified_Mercalli_intensity_scale). We will iterate through the dictionary created previously containing id and magnitude data of each event, then we will filter these events according to the Mercalli Scale threshold and calculate the percentage of occurrence."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [],
   "source": [
    "# dictionary length\n",
    "dictLen= len(dict)\n",
    "\n",
    "# calculate percentage mercaly intensity I\n",
    "mer_I = [item for item, occurrences in dict.items() if occurrences < 2.0]\n",
    "merIPerc = round((len(mer_I)/dictLen)*100, 2)\n",
    "\n",
    "# calculate percentage mercaly intensity II\n",
    "mer_II = [item for item, occurrences in dict.items() if occurrences >= 2.0 and occurrences <= 2.9 ]\n",
    "merIIPerc = round((len(mer_II)/dictLen)*100,2)\n",
    "\n",
    "# calculate percentage mercaly intensity III\n",
    "mer_III = [item for item, occurrences in dict.items() if occurrences >= 3.0 and occurrences <= 3.9 ]\n",
    "merIIIPerc = round((len(mer_III)/dictLen)*100,2)\n",
    "\n",
    "# calculate percentage mercaly intensity IV\n",
    "mer_IV = [item for item, occurrences in dict.items() if occurrences >= 4.0 and occurrences <= 4.9 ]\n",
    "merIVPerc = round((len(mer_IV)/dictLen)*100,2)\n",
    "\n",
    "# calculate percentage mercaly intensity V\n",
    "mer_V = [item for item, occurrences in dict.items() if occurrences >= 5.0 and occurrences <= 5.9 ]\n",
    "merVPerc = round((len(mer_V)/dictLen)*100,2)\n",
    "\n",
    "# calculate percentage mercaly intensity VI\n",
    "mer_VI = [item for item, occurrences in dict.items() if occurrences >= 6.0 and occurrences <= 6.9 ]\n",
    "merVIPerc = round((len(mer_VI)/dictLen)*100,2)\n",
    "\n",
    "# calculate percentage mercaly intensity VII\n",
    "mer_VII = [item for item, occurrences in dict.items() if occurrences >= 7.0 and occurrences <= 7.9 ]\n",
    "merVIIPerc = round((len(mer_VII)/dictLen)*100,2)\n",
    "\n",
    "# calculate percentage mercaly intensity VIII\n",
    "mer_VIII = [item for item, occurrences in dict.items() if occurrences >= 8.0]\n",
    "merVIIIPerc = round((len(mer_VIII)/dictLen)*100,2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Printing the results\n",
    "\n",
    "We can observe that ***80 percent*** of the earthquakes in the study area are of [Mercalli Intensity Scale](https://en.wikipedia.org/wiki/Modified_Mercalli_intensity_scale) ***IV-V***. These kinds of events are classified as light to moderate earthquakes. According to [Wikipedia](https://en.wikipedia.org/wiki/Modified_Mercalli_intensity_scale) they are felt indoors by many (IV. Light) and felt by nearly everyone (V. Moderate)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.0 % of earthquakes are Mercalli Intensity Scale I\n",
      "\n",
      "0.0 % of earthquakes are Mercalli Intensity Scale II–III\n",
      "\n",
      "0.0 % of earthquakes are Mercalli Intensity Scale III–IV\n",
      "\n",
      "80.2 % of earthquakes are Mercalli Intensity Scale IV-V\n",
      "\n",
      "19.3 % of earthquakes are Mercalli Intensity Scale V-VI\n",
      "\n",
      "0.5 % of earthquakes are Mercalli Intensity Scale VI-VII\n",
      "\n",
      "0.0 % of earthquakes are Mercalli Intensity Scale VII-VIII\n",
      "\n",
      "0.0 % of earthquakes are Mercalli Intensity Scale VIII or higher\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# list to store percentages\n",
    "perlst = [merIPerc, merIIPerc, merIIIPerc, merIVPerc, merVPerc, merVIPerc, merVIIPerc, merVIIIPerc]\n",
    "\n",
    "# list of scale labels\n",
    "lablst = ['I', 'II–III', 'III–IV', 'IV-V', 'V-VI', 'VI-VII', 'VII-VIII', 'VIII or higher']\n",
    "\n",
    "    \n",
    "for perc, label in zip(perlst, lablst):\n",
    "    print('{} % of earthquakes are Mercalli Intensity Scale {}\\n'.format(perc, label))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "***Execute `map_earthquakes.ipynb` to built a web map depicting earthquakes events.***"
   ]
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}