- Install PostgreSQL to your PC (Windows 10).
- Download data from the internet using Pandas.
- Create a database, table and a user.
- Load data onto the Postgres database and downloading data to Pandas.
Installing PostgreSQL to Your PC
Before we start, make sure you have admininstrator privilege to your PC. After downloading the installer from download Postgres for Windows , right click on the installer, and click "run as administrator". Go through the installation process and keep port number as 5432.Note: In Dataquest, they suggested using BigSQL's distribution of Postgres but I encountered lots of trouble with that so I am sticking to EnterpriseDB's distribution.
After successfully installing PostgreSQL, install psycopg2 library to Python:
pip install psycopg2
conda install psycopg2
For the subsequent steps, please follow the Jupyter Notebook below:
Create A Database, Table and User¶
Connect to Postgres¶
By default, the superuser is called postgres and a default database called postgres is created after installation. Password is also not required.Autocommit is set to True so that we can execute the CREATE DATABASE statement - otherwise it would result in an error.
In [1]:
import psycopg2
conn = psycopg2.connect(dbname = 'postgres',user = 'postgres')
conn.autocommit = True
cur = conn.cursor()
Loading the data¶
Instead of using csv, io, and urllib libraries to download the csv file, I am just going to use pandas.read_csv as it only takes one line of code and the data are readily summarisable.
In [2]:
import pandas as pd
df = pd.read_csv('https://dq-content.s3.amazonaws.com/251/storm_data.csv')
df.head()
Out[2]:
FID | YEAR | MONTH | DAY | AD_TIME | BTID | NAME | LAT | LONG | WIND_KTS | PRESSURE | CAT | BASIN | Shape_Leng | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2001 | 1957 | 8 | 8 | 1800Z | 63 | NOTNAMED | 22.5 | -140.0 | 50 | 0 | TS | Eastern Pacific | 1.140175 |
1 | 2002 | 1961 | 10 | 3 | 1200Z | 116 | PAULINE | 22.1 | -140.2 | 45 | 0 | TS | Eastern Pacific | 1.166190 |
2 | 2003 | 1962 | 8 | 29 | 0600Z | 124 | C | 18.0 | -140.0 | 45 | 0 | TS | Eastern Pacific | 2.102380 |
3 | 2004 | 1967 | 7 | 14 | 0600Z | 168 | DENISE | 16.6 | -139.5 | 45 | 0 | TS | Eastern Pacific | 2.121320 |
4 | 2005 | 1972 | 8 | 16 | 1200Z | 251 | DIANA | 18.5 | -139.8 | 70 | 0 | H1 | Eastern Pacific | 1.702939 |
Before we create the database and a table to store our data, we need to inspect our data to see what sort of columns and datatypes we need to use. We also need to clean up the data for any errors or formatting issues.
In [3]:
df.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 59228 entries, 0 to 59227 Data columns (total 14 columns): FID 59228 non-null int64 YEAR 59228 non-null int64 MONTH 59228 non-null int64 DAY 59228 non-null int64 AD_TIME 59228 non-null object BTID 59228 non-null int64 NAME 59228 non-null object LAT 59228 non-null float64 LONG 59228 non-null float64 WIND_KTS 59228 non-null int64 PRESSURE 59228 non-null int64 CAT 59228 non-null object BASIN 59228 non-null object Shape_Leng 59228 non-null float64 dtypes: float64(3), int64(7), object(4) memory usage: 6.3+ MB
In [4]:
df.describe()
Out[4]:
FID | YEAR | MONTH | DAY | BTID | LAT | LONG | WIND_KTS | PRESSURE | Shape_Leng | |
---|---|---|---|---|---|---|---|---|---|---|
count | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 |
mean | 29614.500000 | 1957.194874 | 8.540521 | 15.867326 | 648.398899 | 23.526400 | -83.196863 | 54.726802 | 372.336800 | 1.201987 |
std | 17097.795209 | 41.665792 | 1.364174 | 8.793432 | 372.376803 | 9.464955 | 37.282152 | 25.133577 | 480.562974 | 0.834497 |
min | 1.000000 | 1851.000000 | 1.000000 | 1.000000 | 1.000000 | 4.200000 | -180.000000 | 10.000000 | 0.000000 | 0.000000 |
25% | 14807.750000 | 1928.000000 | 8.000000 | 8.000000 | 344.000000 | 16.100000 | -108.500000 | 35.000000 | 0.000000 | 0.707107 |
50% | 29614.500000 | 1970.000000 | 9.000000 | 16.000000 | 606.000000 | 21.200000 | -81.200000 | 50.000000 | 0.000000 | 1.029563 |
75% | 44421.250000 | 1991.000000 | 9.000000 | 23.000000 | 920.000000 | 29.600000 | -62.200000 | 70.000000 | 990.000000 | 1.431782 |
max | 59228.000000 | 2008.000000 | 12.000000 | 31.000000 | 1410.000000 | 69.000000 | 180.000000 | 165.000000 | 1024.000000 | 11.180340 |
Since .describe only summaries the numerical columns of our data, we need to use some tricks to grab the charater limits of string/object columns: AD_TIME , NAME , BASIN
In [5]:
print('Max length of AD.TIME: ',df.AD_TIME.map(lambda x: len(x)).max())
Max length of AD.TIME: 5
In [6]:
print('Max length of NAME: ',df.NAME.map(lambda x: len(x)).max())
Max length of NAME: 9
In [7]:
print('Max length of BASIN: ',df.BASIN.map(lambda x: len(x)).max())
Max length of BASIN: 15
Getting Rid of the 'Z' in AD_TIME¶
In [8]:
df['AD_TIME'] = df['AD_TIME'].apply(lambda x: x[:4])
Lowercase Column Names¶
In [9]:
df.rename(str.lower, axis = 'columns', inplace=True)
df.head()
Out[9]:
fid | year | month | day | ad_time | btid | name | lat | long | wind_kts | pressure | cat | basin | shape_leng | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2001 | 1957 | 8 | 8 | 1800 | 63 | NOTNAMED | 22.5 | -140.0 | 50 | 0 | TS | Eastern Pacific | 1.140175 |
1 | 2002 | 1961 | 10 | 3 | 1200 | 116 | PAULINE | 22.1 | -140.2 | 45 | 0 | TS | Eastern Pacific | 1.166190 |
2 | 2003 | 1962 | 8 | 29 | 0600 | 124 | C | 18.0 | -140.0 | 45 | 0 | TS | Eastern Pacific | 2.102380 |
3 | 2004 | 1967 | 7 | 14 | 0600 | 168 | DENISE | 16.6 | -139.5 | 45 | 0 | TS | Eastern Pacific | 2.121320 |
4 | 2005 | 1972 | 8 | 16 | 1200 | 251 | DIANA | 18.5 | -139.8 | 70 | 0 | H1 | Eastern Pacific | 1.702939 |
Combine YEAR, MONTH, DAY and AD_TIME columns¶
In [10]:
df['hour'] = df['ad_time'].apply(lambda x:x[:2])
df['minute'] = df['ad_time'].apply(lambda x:x[2:])
#Create the datetime object for date_time using to_datetime()
df['date_time'] = pd.to_datetime(dict(year = df.year,month=df.month,day=df.day,hour=df.hour,minute=df.minute))
df.head()
Out[10]:
fid | year | month | day | ad_time | btid | name | lat | long | wind_kts | pressure | cat | basin | shape_leng | hour | minute | date_time | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2001 | 1957 | 8 | 8 | 1800 | 63 | NOTNAMED | 22.5 | -140.0 | 50 | 0 | TS | Eastern Pacific | 1.140175 | 18 | 00 | 1957-08-08 18:00:00 |
1 | 2002 | 1961 | 10 | 3 | 1200 | 116 | PAULINE | 22.1 | -140.2 | 45 | 0 | TS | Eastern Pacific | 1.166190 | 12 | 00 | 1961-10-03 12:00:00 |
2 | 2003 | 1962 | 8 | 29 | 0600 | 124 | C | 18.0 | -140.0 | 45 | 0 | TS | Eastern Pacific | 2.102380 | 06 | 00 | 1962-08-29 06:00:00 |
3 | 2004 | 1967 | 7 | 14 | 0600 | 168 | DENISE | 16.6 | -139.5 | 45 | 0 | TS | Eastern Pacific | 2.121320 | 06 | 00 | 1967-07-14 06:00:00 |
4 | 2005 | 1972 | 8 | 16 | 1200 | 251 | DIANA | 18.5 | -139.8 | 70 | 0 | H1 | Eastern Pacific | 1.702939 | 12 | 00 | 1972-08-16 12:00:00 |
Dropping Extra Columns¶
In [11]:
df.drop(['year','month','day','ad_time','hour','minute'], axis =1, inplace = True)
df.head()
Out[11]:
fid | btid | name | lat | long | wind_kts | pressure | cat | basin | shape_leng | date_time | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2001 | 63 | NOTNAMED | 22.5 | -140.0 | 50 | 0 | TS | Eastern Pacific | 1.140175 | 1957-08-08 18:00:00 |
1 | 2002 | 116 | PAULINE | 22.1 | -140.2 | 45 | 0 | TS | Eastern Pacific | 1.166190 | 1961-10-03 12:00:00 |
2 | 2003 | 124 | C | 18.0 | -140.0 | 45 | 0 | TS | Eastern Pacific | 2.102380 | 1962-08-29 06:00:00 |
3 | 2004 | 168 | DENISE | 16.6 | -139.5 | 45 | 0 | TS | Eastern Pacific | 2.121320 | 1967-07-14 06:00:00 |
4 | 2005 | 251 | DIANA | 18.5 | -139.8 | 70 | 0 | H1 | Eastern Pacific | 1.702939 | 1972-08-16 12:00:00 |
Rearrange Columns¶
We want to rearrange our columns so that the match the original
In [12]:
df = df[['fid','date_time','btid','name','lat','long','wind_kts','pressure','cat','basin','shape_leng']]
df.head()
Out[12]:
fid | date_time | btid | name | lat | long | wind_kts | pressure | cat | basin | shape_leng | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2001 | 1957-08-08 18:00:00 | 63 | NOTNAMED | 22.5 | -140.0 | 50 | 0 | TS | Eastern Pacific | 1.140175 |
1 | 2002 | 1961-10-03 12:00:00 | 116 | PAULINE | 22.1 | -140.2 | 45 | 0 | TS | Eastern Pacific | 1.166190 |
2 | 2003 | 1962-08-29 06:00:00 | 124 | C | 18.0 | -140.0 | 45 | 0 | TS | Eastern Pacific | 2.102380 |
3 | 2004 | 1967-07-14 06:00:00 | 168 | DENISE | 16.6 | -139.5 | 45 | 0 | TS | Eastern Pacific | 2.121320 |
4 | 2005 | 1972-08-16 12:00:00 | 251 | DIANA | 18.5 | -139.8 | 70 | 0 | H1 | Eastern Pacific | 1.702939 |
In [13]:
cur.execute('CREATE DATABASE ihw')
Create the table¶
We need to create a table with the right set of datatypes. The table needs to contain the following fields:fid - ID for the row integer
{year - Recorded year
month - Recorded month
day - Recorded date
ad_time - Recorded time in UTC } - To combine together as timestamp(postgres)
btid - Hurricane ID smallint
name - Name of the hurricane varchar(16)
lat - Latitude of the recorded location decimal(3,1) (because all the data are based in North America)
long - Longitude of the recorded location decimal(4,1)
wind_kts - Wind speed in knots per second smallint
pressure - Atmospheric pressure of the hurricane smallint
cat - Hurricane category varchar(2)
basin - The basin the hurricane is located varchar(9)
shape_leng - Hurricane shape length decimal(8,6)
In [14]:
# Reset connection to the new database 'ihw'
conn = psycopg2.connect(dbname = 'ihw',user = 'postgres')
conn.autocommit = True
cur = conn.cursor()
In [15]:
sql = """CREATE TABLE storm_data(
fid integer PRIMARY KEY,
date_time TIMESTAMP,
btid smallint,
name varchar(9),
lat decimal(3,1),
long decimal(4,1),
wind_kts smallint,
pressure smallint,
cat varchar(2),
basin varchar(15),
shape_leng decimal(8,6)
)
"""
cur.execute(sql)
Let's have a look at the resulting table
In [16]:
cur.execute('SELECT * FROM storm_data')
colnames = [desc[0] for desc in cur.description]
In [17]:
colnames
Out[17]:
['fid', 'date_time', 'btid', 'name', 'lat', 'long', 'wind_kts', 'pressure', 'cat', 'basin', 'shape_leng']
Creating a User¶
This user need to be able to update, read, and insert into the table
In [18]:
# create a user call dr_storm with password 'cyclone101'
cur.execute("CREATE USER dr_storm with PASSWORD 'cyclone101'")
# revoke all privileges on storm_data from dr_storm as default setting
cur.execute("REVOKE ALL ON storm_data FROM dr_storm")
# granting update, read(select), and insert on storm_data to dr_storm
cur.execute("GRANT UPDATE ON storm_data to dr_storm")
cur.execute("GRANT SELECT ON storm_data to dr_storm")
cur.execute("GRANT INSERT ON storm_data to dr_storm")
conn.commit()
Reconnect to the Database with dr_storm¶
In [19]:
# close existing connection
conn.close()
# reconnect with dr_storm
conn = psycopg2.connect(dbname = 'ihw',user = 'dr_storm',password = 'cyclone101')
cur = conn.cursor()
In [20]:
data_values = df.values.tolist()
data_values
Out[20]:
[[2001, Timestamp('1957-08-08 18:00:00'), 63, 'NOTNAMED', 22.5, -140.0, 50, 0, 'TS', 'Eastern Pacific', 1.140175], [2002, Timestamp('1961-10-03 12:00:00'), 116, 'PAULINE', 22.1, -140.2, 45, 0, 'TS', 'Eastern Pacific', 1.16619], [2003, Timestamp('1962-08-29 06:00:00'), 124, 'C', 18.0, -140.0, 45, 0, 'TS', 'Eastern Pacific', 2.10238], [2004, Timestamp('1967-07-14 06:00:00'), 168, 'DENISE', 16.6, -139.5, 45, 0, 'TS', 'Eastern Pacific', 2.12132], [2005, Timestamp('1972-08-16 12:00:00'), 251, 'DIANA', 18.5, -139.8, 70, 0, 'H1', 'Eastern Pacific', 1.702939], [2006, Timestamp('1976-07-22 00:00:00'), 312, 'DIANA', 18.6, -139.8, 30, 0, 'TD', 'Eastern Pacific', 1.6], [2007, Timestamp('1978-08-26 12:00:00'), 342, 'KRISTY', 21.4, -140.2, 45, 0, 'TS', 'Eastern Pacific', 1.3038399999999999], [2008, Timestamp('1980-09-24 18:00:00'), 371, 'KAY', 20.5, -140.2, 75, 0, 'H1', 'Eastern Pacific', 1.220656], [2009, Timestamp('1970-08-23 00:00:00'), 223, 'MAGGIE', 14.9, -139.4, 45, 0, 'TS', 'Eastern Pacific', 0.921954], [2010, Timestamp('1981-08-21 00:00:00'), 381, 'GREG', 18.7, -140.2, 45, 0, 'TS', 'Eastern Pacific', 0.921954], [2011, Timestamp('1970-08-23 06:00:00'), 223, 'MAGGIE', 15.1, -140.3, 45, 0, 'TS', 'Eastern Pacific', 0.921954], [2012, Timestamp('1981-09-18 12:00:00'), 384, 'JOVA', 19.7, -140.0, 60, 0, 'TS', 'Eastern Pacific', 1.746425], [2013, Timestamp('1971-07-10 06:00:00'), 233, 'DENISE', 14.0, -135.7, 100, 0, 'H3', 'Eastern Pacific', 1.676305], [2014, Timestamp('1982-07-16 12:00:00'), 393, 'DANIEL', 18.1, -140.0, 35, 0, 'TS', 'Eastern Pacific', 1.627882], [2015, Timestamp('1984-07-03 18:00:00'), 437, 'DOUGLAS', 18.1, -140.0, 30, 0, 'TD', 'Eastern Pacific', 1.315295], [2016, Timestamp('1988-08-09 00:00:00'), 522, 'HECTOR', 18.6, -140.0, 40, 1005, 'TS', 'Eastern Pacific', 1.403567], [2017, Timestamp('1971-07-10 12:00:00'), 233, 'DENISE', 14.5, -137.3, 100, 0, 'H3', 'Eastern Pacific', 1.9313209999999998], [2018, Timestamp('1989-07-21 00:00:00'), 534, 'ERICK', 17.2, -139.5, 30, 1012, 'TD', 'Eastern Pacific', 2.745906], [2019, Timestamp('1972-08-11 12:00:00'), 250, 'CELESTE', 15.4, -137.5, 75, 0, 'H1', 'Eastern Pacific', 0.8944270000000001], [2020, Timestamp('1992-07-24 06:00:00'), 590, 'GEORGETTE', 17.5, -139.4, 30, 1007, 'TD', 'Eastern Pacific', 2.10238], [2021, Timestamp('1972-08-11 18:00:00'), 250, 'CELESTE', 15.0, -138.3, 75, 0, 'H1', 'Eastern Pacific', 0.806226], [2022, Timestamp('1992-09-12 06:00:00'), 598, 'ORLENE', 22.6, -140.0, 40, 1002, 'TS', 'Eastern Pacific', 1.513275], [2023, Timestamp('1992-10-22 06:00:00'), 607, 'YOLANDA', 16.2, -140.2, 25, 1011, 'TD', 'Eastern Pacific', 1.6], [2024, Timestamp('1972-08-12 00:00:00'), 250, 'CELESTE', 14.6, -139.0, 80, 0, 'H1', 'Eastern Pacific', 0.806226], [2025, Timestamp('1993-07-22 18:00:00'), 613, 'EUGENE', 19.2, -139.8, 40, 997, 'TS', 'Eastern Pacific', 2.22036], [2026, Timestamp('1972-08-12 06:00:00'), 250, 'CELESTE', 14.2, -139.7, 80, 0, 'H1', 'Eastern Pacific', 0.806226], [2027, Timestamp('1972-08-12 12:00:00'), 250, 'CELESTE', 13.8, -140.4, 85, 0, 'H2', 'Eastern Pacific', 1.0198040000000002], [2028, Timestamp('1993-08-14 06:00:00'), 615, 'FERNANDA', 18.3, -139.6, 85, 973, 'H2', 'Eastern Pacific', 1.627882], [2029, Timestamp('1972-08-12 18:00:00'), 250, 'CELESTE', 13.6, -141.4, 85, 0, 'H2', 'Eastern Pacific', 1.204159], [2030, Timestamp('1994-08-31 06:00:00'), 635, 'KRISTY', 16.2, -139.8, 60, 992, 'TS', 'Eastern Pacific', 1.5033299999999998], [2031, Timestamp('1972-08-13 00:00:00'), 250, 'CELESTE', 13.5, -142.6, 85, 0, 'H2', 'Eastern Pacific', 1.315295], [2032, Timestamp('1994-09-10 00:00:00'), 636, 'LANE', 21.4, -140.0, 25, 1010, 'TD', 'Eastern Pacific', 1.403567], [2033, Timestamp('1997-07-11 18:00:00'), 666, 'DOLORES', 21.0, -140.0, 30, 1008, 'TD', 'Eastern Pacific', 1.442221], [2034, Timestamp('1973-10-06 00:00:00'), 272, 'KATHERINE', 14.6, -136.0, 50, 0, 'TS', 'Eastern Pacific', 1.334166], [2035, Timestamp('1973-10-06 06:00:00'), 272, 'KATHERINE', 14.3, -137.3, 45, 0, 'TS', 'Eastern Pacific', 1.4317819999999999], [2036, Timestamp('1999-08-14 00:00:00'), 698, 'DORA', 15.5, -139.7, 100, 960, 'H3', 'Eastern Pacific', 2.0], [2037, Timestamp('1973-10-06 12:00:00'), 272, 'KATHERINE', 14.0, -138.7, 45, 0, 'TS', 'Eastern Pacific', 1.4317819999999999], [2038, Timestamp('2000-07-28 18:00:00'), 708, 'DANIEL', 17.5, -139.6, 90, 968, 'H2', 'Eastern Pacific', 1.7720049999999998], [2039, Timestamp('1973-10-06 18:00:00'), 272, 'KATHERINE', 13.7, -140.1, 45, 0, 'TS', 'Eastern Pacific', 1.529706], [2040, Timestamp('2001-06-22 18:00:00'), 724, 'BARBARA', 16.8, -140.1, 30, 1006, 'TD', 'Eastern Pacific', 1.208305], [2041, Timestamp('1973-10-07 00:00:00'), 272, 'KATHERINE', 13.4, -141.6, 40, 0, 'TS', 'Eastern Pacific', 0.806226], [2042, Timestamp('1973-10-07 06:00:00'), 272, 'KATHERINE', 13.3, -142.4, 40, 0, 'TS', 'Eastern Pacific', 0.905539], [2043, Timestamp('2001-10-23 18:00:00'), 736, 'NARDA', 16.3, -139.6, 35, 1002, 'TS', 'Eastern Pacific', 1.603122], [2044, Timestamp('1974-08-23 00:00:00'), 282, 'IONE', 12.4, -135.6, 30, 0, 'TD', 'Eastern Pacific', 1.004988], [2045, Timestamp('2003-08-12 18:00:00'), 759, 'GUILLERMO', 16.3, -139.8, 25, 1008, 'L', 'Eastern Pacific', 1.7117240000000002], [2046, Timestamp('1974-08-23 06:00:00'), 282, 'IONE', 12.3, -136.6, 30, 0, 'TD', 'Eastern Pacific', 1.004988], [2047, Timestamp('2003-08-30 06:00:00'), 762, 'JIMENA', 17.3, -139.8, 85, 973, 'H2', 'Eastern Pacific', 1.5], [2048, Timestamp('1974-08-23 12:00:00'), 282, 'IONE', 12.4, -137.6, 30, 0, 'TD', 'Eastern Pacific', 0.806226], [2049, Timestamp('2004-09-02 12:00:00'), 775, 'GEORGETTE', 21.7, -140.2, 15, 1011, 'L', 'Eastern Pacific', 1.615549], [2050, Timestamp('1974-08-23 18:00:00'), 282, 'IONE', 12.5, -138.4, 65, 0, 'H1', 'Eastern Pacific', 0.921954], [2051, Timestamp('2006-07-16 18:00:00'), 797, 'BUD', 23.0, -139.8, 20, 1012, 'L', 'Eastern Pacific', 1.5811389999999999], [2052, Timestamp('1974-08-24 00:00:00'), 282, 'IONE', 12.7, -139.3, 75, 0, 'H1', 'Eastern Pacific', 0.8246209999999999], [2053, Timestamp('2008-07-21 00:00:00'), 830, 'ELIDA', 16.9, -140.0, 25, 1009, 'L', 'Eastern Pacific', 1.513275], [2054, Timestamp('1974-08-24 06:00:00'), 282, 'IONE', 12.9, -140.1, 100, 0, 'H3', 'Eastern Pacific', 0.9486829999999999], [2055, Timestamp('1950-08-29 18:00:00'), 12, 'NOTNAMED', 19.1, -140.3, 75, 0, 'H1', 'Eastern Pacific', 0.8246209999999999], [2056, Timestamp('1974-08-24 12:00:00'), 282, 'IONE', 13.2, -141.0, 90, 0, 'H2', 'Eastern Pacific', 0.632456], [2057, Timestamp('1950-08-30 00:00:00'), 12, 'NOTNAMED', 19.3, -141.1, 75, 0, 'H1', 'Eastern Pacific', 0.921954], [2058, Timestamp('1974-08-24 18:00:00'), 282, 'IONE', 13.4, -141.6, 90, 0, 'H2', 'Eastern Pacific', 0.5], [2059, Timestamp('1950-08-30 06:00:00'), 12, 'NOTNAMED', 19.5, -142.0, 75, 0, 'H1', 'Eastern Pacific', 1.0198040000000002], [2060, Timestamp('1974-08-25 00:00:00'), 282, 'IONE', 13.7, -142.0, 90, 0, 'H2', 'Eastern Pacific', 0.5], [2061, Timestamp('1957-07-23 06:00:00'), 62, 'KANOA', 17.9, -140.5, 75, 0, 'H1', 'Eastern Pacific', 1.3038399999999999], [2062, Timestamp('1957-07-23 12:00:00'), 62, 'KANOA', 18.0, -141.8, 75, 0, 'H1', 'Eastern Pacific', 1.140175], [2063, Timestamp('1974-08-25 06:00:00'), 282, 'IONE', 14.0, -142.4, 90, 0, 'H2', 'Eastern Pacific', 0.583095], [2064, Timestamp('1974-08-25 12:00:00'), 282, 'IONE', 14.3, -142.9, 90, 0, 'H2', 'Eastern Pacific', 0.565685], [2065, Timestamp('1957-07-23 18:00:00'), 62, 'KANOA', 18.3, -142.9, 75, 0, 'H1', 'Eastern Pacific', 1.140175], [2066, Timestamp('1957-09-09 12:00:00'), 66, 'NOTNAMED', 15.8, -140.5, 45, 0, 'TS', 'Eastern Pacific', 1.118034], [2067, Timestamp('1974-10-23 00:00:00'), 291, 'ROSALIE', 13.5, -136.0, 35, 0, 'TS', 'Eastern Pacific', 0.583095], [2068, Timestamp('1957-09-09 18:00:00'), 66, 'NOTNAMED', 16.3, -141.5, 45, 0, 'TS', 'Eastern Pacific', 0.984886], [2069, Timestamp('1974-10-23 06:00:00'), 291, 'ROSALIE', 13.2, -136.5, 35, 0, 'TS', 'Eastern Pacific', 0.538516], [2070, Timestamp('1974-10-23 12:00:00'), 291, 'ROSALIE', 13.0, -137.0, 35, 0, 'TS', 'Eastern Pacific', 1.004988], [2071, Timestamp('1957-09-10 00:00:00'), 66, 'NOTNAMED', 16.7, -142.4, 45, 0, 'TS', 'Eastern Pacific', 0.67082], [2072, Timestamp('1974-10-23 18:00:00'), 291, 'ROSALIE', 12.9, -138.0, 25, 0, 'TD', 'Eastern Pacific', 1.004988], [2073, Timestamp('1957-09-10 06:00:00'), 66, 'NOTNAMED', 17.0, -143.0, 45, 0, 'TS', 'Eastern Pacific', 0.583095], [2074, Timestamp('1976-07-18 18:00:00'), 311, 'CELESTE', 12.5, -135.7, 25, 0, 'TD', 'Eastern Pacific', 2.256103], [2075, Timestamp('1959-08-01 18:00:00'), 93, 'DOT', 15.7, -141.2, 60, 0, 'TS', 'Eastern Pacific', 0.608276], [2076, Timestamp('1959-08-02 00:00:00'), 93, 'DOT', 15.8, -141.8, 90, 0, 'H2', 'Eastern Pacific', 1.104536], [2077, Timestamp('1976-07-19 00:00:00'), 311, 'CELESTE', 13.0, -137.9, 25, 0, 'TD', 'Eastern Pacific', 1.236932], [2078, Timestamp('1959-08-02 06:00:00'), 93, 'DOT', 15.7, -142.9, 100, 0, 'H3', 'Eastern Pacific', 1.104536], [2079, Timestamp('1976-07-19 06:00:00'), 311, 'CELESTE', 13.3, -139.1, 25, 0, 'TD', 'Eastern Pacific', 0.44721400000000006], [2080, Timestamp('1962-08-29 12:00:00'), 124, 'C', 17.9, -142.1, 45, 0, 'TS', 'Eastern Pacific', 0.806226], [2081, Timestamp('1976-07-29 06:00:00'), 314, 'FERNANDA', 12.1, -136.3, 35, 0, 'TS', 'Eastern Pacific', 0.7], [2082, Timestamp('1962-08-29 18:00:00'), 124, 'C', 17.8, -142.9, 45, 0, 'TS', 'Eastern Pacific', 1.104536], [2083, Timestamp('1976-07-29 12:00:00'), 314, 'FERNANDA', 12.1, -137.0, 35, 0, 'TS', 'Eastern Pacific', 0.632456], [2084, Timestamp('1976-07-29 18:00:00'), 314, 'FERNANDA', 12.3, -137.6, 30, 0, 'TD', 'Eastern Pacific', 0.632456], [2085, Timestamp('1966-08-12 12:00:00'), 154, 'CONNIE', 17.6, -140.8, 45, 0, 'TS', 'Eastern Pacific', 0.905539], [2086, Timestamp('1976-07-30 00:00:00'), 314, 'FERNANDA', 12.5, -138.2, 30, 0, 'TD', 'Eastern Pacific', 0.9486829999999999], [2087, Timestamp('1966-08-12 18:00:00'), 154, 'CONNIE', 17.7, -141.7, 45, 0, 'TS', 'Eastern Pacific', 0.905539], [2088, Timestamp('1966-08-13 00:00:00'), 154, 'CONNIE', 17.8, -142.6, 45, 0, 'TS', 'Eastern Pacific', 0.7], [2089, Timestamp('1976-07-30 06:00:00'), 314, 'FERNANDA', 12.8, -139.1, 30, 0, 'TD', 'Eastern Pacific', 0.9486829999999999], [2090, Timestamp('1967-07-14 12:00:00'), 168, 'DENISE', 16.3, -141.6, 45, 0, 'TS', 'Eastern Pacific', 2.4083189999999997], [2091, Timestamp('1967-10-29 06:00:00'), 181, 'RAMONA', 15.8, -140.5, 25, 0, 'TD', 'Eastern Pacific', 0.608276], [2092, Timestamp('1976-07-30 12:00:00'), 314, 'FERNANDA', 13.1, -140.0, 30, 0, 'TD', 'Eastern Pacific', 1.204159], [2093, Timestamp('1976-07-30 18:00:00'), 314, 'FERNANDA', 13.2, -141.2, 30, 0, 'TD', 'Eastern Pacific', 1.403567], [2094, Timestamp('1967-10-29 12:00:00'), 181, 'RAMONA', 15.9, -141.1, 25, 0, 'TD', 'Eastern Pacific', 0.8], [2095, Timestamp('1967-10-29 18:00:00'), 181, 'RAMONA', 15.9, -141.9, 45, 0, 'TS', 'Eastern Pacific', 0.7071069999999999], [2096, Timestamp('1976-07-31 00:00:00'), 314, 'FERNANDA', 13.3, -142.6, 30, 0, 'TD', 'Eastern Pacific', 1.5033299999999998], [2097, Timestamp('1967-10-30 00:00:00'), 181, 'RAMONA', 16.0, -142.6, 45, 0, 'TS', 'Eastern Pacific', 0.412311], [2098, Timestamp('1976-09-22 00:00:00'), 320, 'KATE', 13.4, -141.1, 30, 0, 'TD', 'Eastern Pacific', 0.282843], [2099, Timestamp('1967-10-30 06:00:00'), 181, 'RAMONA', 16.1, -143.0, 45, 0, 'TS', 'Eastern Pacific', 0.316228], [2100, Timestamp('1976-09-22 06:00:00'), 320, 'KATE', 13.6, -141.3, 30, 0, 'TD', 'Eastern Pacific', 0.316228], [2101, Timestamp('1968-09-02 06:00:00'), 192, 'KATHLEEN', 15.5, -141.9, 25, 0, 'TD', 'Eastern Pacific', 1.077033], [2102, Timestamp('1976-09-22 12:00:00'), 320, 'KATE', 13.7, -141.6, 30, 0, 'TD', 'Eastern Pacific', 0.22360700000000003], [2103, Timestamp('1968-09-02 12:00:00'), 192, 'KATHLEEN', 15.9, -142.9, 25, 0, 'TD', 'Eastern Pacific', 0.9486829999999999], [2104, Timestamp('1976-09-22 18:00:00'), 320, 'KATE', 13.9, -141.7, 30, 0, 'TD', 'Eastern Pacific', 0.22360700000000003], [2105, Timestamp('1970-08-27 00:00:00'), 222, 'LORRAINE', 20.0, -141.0, 25, 0, 'TD', 'Eastern Pacific', 1.1], [2106, Timestamp('1976-09-23 00:00:00'), 320, 'KATE', 14.0, -141.9, 35, 0, 'TS', 'Eastern Pacific', 0.141421], [2107, Timestamp('1970-08-27 06:00:00'), 222, 'LORRAINE', 20.0, -142.1, 25, 0, 'TD', 'Eastern Pacific', 1.0], [2108, Timestamp('1976-09-23 06:00:00'), 320, 'KATE', 14.1, -141.8, 35, 0, 'TS', 'Eastern Pacific', 0.1], [2109, Timestamp('1976-09-23 12:00:00'), 320, 'KATE', 14.2, -141.8, 40, 0, 'TS', 'Eastern Pacific', 0.141421], [2110, Timestamp('1970-08-23 12:00:00'), 223, 'MAGGIE', 15.3, -141.2, 45, 0, 'TS', 'Eastern Pacific', 1.529706], [2111, Timestamp('1976-09-23 18:00:00'), 320, 'KATE', 14.3, -141.9, 45, 0, 'TS', 'Eastern Pacific', 0.141421], [2112, Timestamp('1970-08-23 18:00:00'), 223, 'MAGGIE', 15.6, -142.7, 45, 0, 'TS', 'Eastern Pacific', 1.456022], [2113, Timestamp('1976-09-24 00:00:00'), 320, 'KATE', 14.4, -142.0, 45, 0, 'TS', 'Eastern Pacific', 0.1], [2114, Timestamp('1971-07-11 00:00:00'), 233, 'DENISE', 16.0, -140.8, 95, 0, 'H2', 'Eastern Pacific', 1.208305], [2115, Timestamp('1976-09-24 06:00:00'), 320, 'KATE', 14.4, -142.1, 60, 0, 'TS', 'Eastern Pacific', 0.22360700000000003], [2116, Timestamp('1976-09-24 12:00:00'), 320, 'KATE', 14.3, -142.3, 60, 0, 'TS', 'Eastern Pacific', 0.1], [2117, Timestamp('1976-09-24 18:00:00'), 320, 'KATE', 14.2, -142.3, 65, 0, 'H1', 'Eastern Pacific', 0.141421], [2118, Timestamp('1971-07-11 06:00:00'), 233, 'DENISE', 16.5, -141.9, 95, 0, 'H2', 'Eastern Pacific', 1.118034], [2119, Timestamp('1976-09-25 00:00:00'), 320, 'KATE', 14.1, -142.4, 70, 0, 'H1', 'Eastern Pacific', 0.4], [2120, Timestamp('1971-07-11 12:00:00'), 233, 'DENISE', 17.0, -142.9, 90, 0, 'H2', 'Eastern Pacific', 1.029563], [2121, Timestamp('1976-09-25 06:00:00'), 320, 'KATE', 14.1, -142.8, 70, 0, 'H1', 'Eastern Pacific', 0.5], [2122, Timestamp('1971-08-06 12:00:00'), 237, 'HILARY', 19.8, -140.9, 45, 0, 'TS', 'Eastern Pacific', 0.72111], [2123, Timestamp('1976-09-25 12:00:00'), 320, 'KATE', 14.1, -143.3, 70, 0, 'H1', 'Eastern Pacific', 0.22360700000000003], [2124, Timestamp('1978-08-23 06:00:00'), 341, 'JOHN', 15.4, -138.2, 60, 0, 'TS', 'Eastern Pacific', 1.2], [2125, Timestamp('1971-08-06 18:00:00'), 237, 'HILARY', 20.2, -141.5, 25, 0, 'TD', 'Eastern Pacific', 1.0], [2126, Timestamp('1978-08-19 00:00:00'), 343, 'LANE', 13.2, -135.8, 30, 0, 'TD', 'Eastern Pacific', 1.004988], [2127, Timestamp('1972-08-16 18:00:00'), 251, 'DIANA', 18.4, -141.5, 60, 0, 'TS', 'Eastern Pacific', 1.8], [2128, Timestamp('1978-08-19 06:00:00'), 343, 'LANE', 13.3, -136.8, 30, 0, 'TD', 'Eastern Pacific', 1.104536], [2129, Timestamp('1972-08-27 00:00:00'), 253, 'FERNANDA', 19.8, -140.4, 50, 992, 'TS', 'Eastern Pacific', 1.5033299999999998], [2130, Timestamp('1978-08-19 12:00:00'), 343, 'LANE', 13.4, -137.9, 30, 0, 'TD', 'Eastern Pacific', 1.140175], [2131, Timestamp('1972-08-27 06:00:00'), 253, 'FERNANDA', 19.9, -141.9, 45, 0, 'TS', 'Eastern Pacific', 1.4142139999999999], [2132, Timestamp('1978-08-19 18:00:00'), 343, 'LANE', 13.7, -139.0, 35, 0, 'TS', 'Eastern Pacific', 1.063015], [2133, Timestamp('1973-07-25 18:00:00'), 265, 'DOREEN', 16.3, -140.4, 55, 0, 'TS', 'Eastern Pacific', 0.9], [2134, Timestamp('1978-08-20 00:00:00'), 343, 'LANE', 14.4, -139.8, 45, 0, 'TS', 'Eastern Pacific', 1.315295], [2135, Timestamp('1973-07-26 00:00:00'), 265, 'DOREEN', 16.3, -141.3, 50, 0, 'TS', 'Eastern Pacific', 1.204159], [2136, Timestamp('1978-08-20 06:00:00'), 343, 'LANE', 14.2, -141.1, 45, 0, 'TS', 'Eastern Pacific', 1.236932], [2137, Timestamp('1973-07-26 06:00:00'), 265, 'DOREEN', 16.4, -142.5, 50, 0, 'TS', 'Eastern Pacific', 1.204159], [2138, Timestamp('1974-08-27 00:00:00'), 282, 'IONE', 18.3, -143.4, 70, 0, 'H1', 'Eastern Pacific', 0.4], [2139, Timestamp('1978-08-20 12:00:00'), 343, 'LANE', 14.5, -142.3, 45, 0, 'TS', 'Eastern Pacific', 1.118034], [2140, Timestamp('1974-08-27 06:00:00'), 282, 'IONE', 18.7, -143.4, 70, 0, 'H1', 'Eastern Pacific', 0.316228], [2141, Timestamp('1978-08-27 06:00:00'), 344, 'MIRIAM', 13.5, -136.1, 35, 0, 'TS', 'Eastern Pacific', 1.4142139999999999], [2142, Timestamp('1974-10-16 12:00:00'), 290, 'PATRICIA', 16.8, -140.8, 25, 0, 'TD', 'Eastern Pacific', 1.104536], [2143, Timestamp('1978-08-27 12:00:00'), 344, 'MIRIAM', 13.3, -137.5, 35, 0, 'TS', 'Eastern Pacific', 1.4317819999999999], [2144, Timestamp('1974-10-16 18:00:00'), 290, 'PATRICIA', 16.9, -141.9, 25, 0, 'TD', 'Eastern Pacific', 1.104536], [2145, Timestamp('1978-08-27 18:00:00'), 344, 'MIRIAM', 12.7, -138.8, 35, 0, 'TS', 'Eastern Pacific', 1.236932], [2146, Timestamp('1976-07-22 06:00:00'), 312, 'DIANA', 18.6, -141.4, 30, 0, 'TD', 'Eastern Pacific', 1.4], [2147, Timestamp('1978-08-28 00:00:00'), 344, 'MIRIAM', 13.0, -140.0, 55, 0, 'TS', 'Eastern Pacific', 1.5], [2148, Timestamp('1978-07-17 18:00:00'), 337, 'FICO', 16.1, -140.5, 80, 0, 'H1', 'Eastern Pacific', 1.7117240000000002], [2149, Timestamp('1978-08-28 06:00:00'), 344, 'MIRIAM', 13.0, -141.5, 60, 0, 'TS', 'Eastern Pacific', 1.552417], [2150, Timestamp('1982-07-12 12:00:00'), 394, 'EMILIA', 10.0, -136.5, 30, 0, 'TD', 'Eastern Pacific', 1.3038399999999999], [2151, Timestamp('1978-07-18 00:00:00'), 337, 'FICO', 16.3, -142.2, 80, 0, 'H1', 'Eastern Pacific', 1.216553], [2152, Timestamp('1982-07-12 18:00:00'), 394, 'EMILIA', 10.1, -137.8, 35, 0, 'TS', 'Eastern Pacific', 1.3038399999999999], [2153, Timestamp('1978-08-23 18:00:00'), 341, 'JOHN', 15.5, -140.5, 60, 0, 'TS', 'Eastern Pacific', 1.204159], [2154, Timestamp('1978-08-24 00:00:00'), 341, 'JOHN', 15.4, -141.7, 65, 0, 'H1', 'Eastern Pacific', 1.3038399999999999], [2155, Timestamp('1982-07-13 00:00:00'), 394, 'EMILIA', 10.2, -139.1, 35, 0, 'TS', 'Eastern Pacific', 1.4317819999999999], [2156, Timestamp('1978-08-24 06:00:00'), 341, 'JOHN', 15.5, -143.0, 70, 0, 'H1', 'Eastern Pacific', 0.728011], [2157, Timestamp('1982-07-13 06:00:00'), 394, 'EMILIA', 10.5, -140.5, 35, 0, 'TS', 'Eastern Pacific', 1.486607], [2158, Timestamp('1982-07-13 12:00:00'), 394, 'EMILIA', 11.0, -141.9, 40, 0, 'TS', 'Eastern Pacific', 0.984886], [2159, Timestamp('1981-08-21 06:00:00'), 381, 'GREG', 18.9, -141.1, 45, 0, 'TS', 'Eastern Pacific', 1.811077], [2160, Timestamp('1982-07-13 18:00:00'), 394, 'EMILIA', 11.4, -142.8, 45, 0, 'TS', 'Eastern Pacific', 1.392839], [2161, Timestamp('1981-08-21 12:00:00'), 381, 'GREG', 18.7, -142.9, 35, 0, 'TS', 'Eastern Pacific', 0.806226], [2162, Timestamp('1981-09-18 18:00:00'), 384, 'JOVA', 19.3, -141.7, 50, 0, 'TS', 'Eastern Pacific', 2.0], [2163, Timestamp('1982-08-05 18:00:00'), 399, 'JOHN', 11.9, -135.9, 75, 0, 'H1', 'Eastern Pacific', 1.4142139999999999], [2164, Timestamp('1982-07-16 18:00:00'), 393, 'DANIEL', 17.8, -141.6, 35, 0, 'TS', 'Eastern Pacific', 1.529706], [2165, Timestamp('1982-08-06 00:00:00'), 399, 'JOHN', 12.1, -137.3, 85, 0, 'H2', 'Eastern Pacific', 1.3038399999999999], [2166, Timestamp('1982-07-30 12:00:00'), 396, 'GILMA', 16.8, -140.9, 75, 0, 'H1', 'Eastern Pacific', 2.009975], [2167, Timestamp('1982-08-06 06:00:00'), 399, 'JOHN', 12.2, -138.6, 90, 0, 'H2', 'Eastern Pacific', 1.3], [2168, Timestamp('1982-09-04 12:00:00'), 402, 'MIRIAM', 17.8, -140.7, 65, 0, 'H1', 'Eastern Pacific', 1.9313209999999998], [2169, Timestamp('1982-08-06 12:00:00'), 399, 'JOHN', 12.2, -139.9, 90, 0, 'H2', 'Eastern Pacific', 1.104536], [2170, Timestamp('1982-08-06 18:00:00'), 399, 'JOHN', 12.3, -141.0, 100, 0, 'H3', 'Eastern Pacific', 1.2], [2171, Timestamp('1982-09-04 18:00:00'), 402, 'MIRIAM', 18.5, -142.5, 45, 0, 'TS', 'Eastern Pacific', 1.802776], [2172, Timestamp('1982-08-07 00:00:00'), 399, 'JOHN', 12.3, -142.2, 100, 0, 'H3', 'Eastern Pacific', 1.104536], [2173, Timestamp('1982-09-15 18:00:00'), 405, 'EMA', 15.5, -142.5, 30, 0, 'TD', 'Eastern Pacific', 0.538516], [2174, Timestamp('1982-08-10 18:00:00'), 400, 'KRISTY', 10.7, -136.5, 65, 0, 'H1', 'Eastern Pacific', 1.4317819999999999], [2175, Timestamp('1982-09-16 00:00:00'), 405, 'EMA', 16.0, -142.3, 35, 0, 'TS', 'Eastern Pacific', 0.5099020000000001], [2176, Timestamp('1982-08-11 00:00:00'), 400, 'KRISTY', 10.4, -137.9, 60, 0, 'TS', 'Eastern Pacific', 1.7117240000000002], [2177, Timestamp('1982-09-16 06:00:00'), 405, 'EMA', 16.5, -142.2, 40, 0, 'TS', 'Eastern Pacific', 0.360555], [2178, Timestamp('1982-08-11 06:00:00'), 400, 'KRISTY', 10.2, -139.6, 55, 0, 'TS', 'Eastern Pacific', 1.9416490000000002], [2179, Timestamp('1982-09-16 12:00:00'), 405, 'EMA', 16.8, -142.0, 40, 0, 'TS', 'Eastern Pacific', 0.0], [2180, Timestamp('1982-08-11 12:00:00'), 400, 'KRISTY', 10.6, -141.5, 55, 0, 'TS', 'Eastern Pacific', 2.2022720000000002], [2181, Timestamp('1982-09-16 18:00:00'), 405, 'EMA', 16.8, -142.0, 40, 0, 'TS', 'Eastern Pacific', 0.0], [2182, Timestamp('1982-09-17 00:00:00'), 405, 'EMA', 16.8, -142.0, 40, 0, 'TS', 'Eastern Pacific', 0.0], [2183, Timestamp('1983-10-11 06:00:00'), 430, 'SONIA', 14.4, -136.5, 30, 0, 'TD', 'Eastern Pacific', 1.104536], [2184, Timestamp('1982-09-17 06:00:00'), 405, 'EMA', 16.8, -142.0, 40, 0, 'TS', 'Eastern Pacific', 0.0], [2185, Timestamp('1983-10-11 12:00:00'), 430, 'SONIA', 14.3, -137.6, 30, 0, 'TD', 'Eastern Pacific', 1.004988], [2186, Timestamp('1982-09-17 12:00:00'), 405, 'EMA', 16.8, -142.0, 40, 0, 'TS', 'Eastern Pacific', 1.118034], [2187, Timestamp('1982-09-17 18:00:00'), 405, 'EMA', 17.8, -141.5, 35, 0, 'TS', 'Eastern Pacific', 0.7615770000000001], [2188, Timestamp('1983-10-11 18:00:00'), 430, 'SONIA', 14.2, -138.6, 25, 0, 'TD', 'Eastern Pacific', 1.236932], [2189, Timestamp('1983-10-12 00:00:00'), 430, 'SONIA', 13.9, -139.8, 20, 0, 'TD', 'Eastern Pacific', 1.1704700000000001], [2190, Timestamp('1982-09-18 00:00:00'), 405, 'EMA', 18.5, -141.2, 35, 0, 'TS', 'Eastern Pacific', 0.781025], [2191, Timestamp('1983-10-12 06:00:00'), 430, 'SONIA', 13.5, -140.9, 20, 0, 'TD', 'Eastern Pacific', 1.077033], [2192, Timestamp('1983-08-01 06:00:00'), 419, 'GIL', 20.8, -141.0, 30, 0, 'TD', 'Eastern Pacific', 1.603122], [2193, Timestamp('1983-10-12 12:00:00'), 430, 'SONIA', 13.1, -141.9, 25, 0, 'TD', 'Eastern Pacific', 1.1704700000000001], [2194, Timestamp('1983-08-01 12:00:00'), 419, 'GIL', 20.9, -142.6, 30, 0, 'TD', 'Eastern Pacific', 1.104536], [2195, Timestamp('1984-08-17 06:00:00'), 445, 'KENNA', 12.5, -136.0, 35, 0, 'TS', 'Eastern Pacific', 0.8], [2196, Timestamp('1993-08-28 06:00:00'), 616, 'GREG', 21.3, -140.2, 30, 1009, 'TD', 'Eastern Pacific', 0.4], [2197, Timestamp('1983-09-27 18:00:00'), 426, 'NARDA', 17.1, -140.8, 25, 0, 'TD', 'Eastern Pacific', 1.612452], [2198, Timestamp('1984-08-17 12:00:00'), 445, 'KENNA', 12.5, -136.8, 35, 0, 'TS', 'Eastern Pacific', 1.0], [2199, Timestamp('1993-09-15 18:00:00'), 620, 'KENNETH', 21.9, -136.0, 45, 1000, 'TS', 'Eastern Pacific', 0.806226], [2200, Timestamp('1984-08-17 18:00:00'), 445, 'KENNA', 12.5, -137.8, 40, 0, 'TS', 'Eastern Pacific', 1.004988], [2201, Timestamp('1983-09-28 00:00:00'), 426, 'NARDA', 17.3, -142.4, 35, 0, 'TS', 'Eastern Pacific', 1.603122], [2202, Timestamp('1983-10-14 12:00:00'), 429, 'RAYMOND', 17.1, -141.0, 110, 0, 'H3', 'Eastern Pacific', 1.236932], [2203, Timestamp('1993-09-16 00:00:00'), 620, 'KENNETH', 22.3, -136.7, 40, 1003, 'TS', 'Eastern Pacific', 0.565685], [2204, Timestamp('1984-08-18 00:00:00'), 445, 'KENNA', 12.6, -138.8, 40, 0, 'TS', 'Eastern Pacific', 0.8], [2205, Timestamp('1983-10-14 18:00:00'), 429, 'RAYMOND', 17.4, -142.2, 120, 0, 'H4', 'Eastern Pacific', 1.315295], [2206, Timestamp('1993-09-16 06:00:00'), 620, 'KENNETH', 22.7, -137.1, 35, 1005, 'TS', 'Eastern Pacific', 0.5], [2207, Timestamp('1984-08-18 06:00:00'), 445, 'KENNA', 12.6, -139.6, 40, 0, 'TS', 'Eastern Pacific', 1.4142139999999999], [2208, Timestamp('1984-08-18 12:00:00'), 445, 'KENNA', 12.4, -141.0, 45, 0, 'TS', 'Eastern Pacific', 1.216553], [2209, Timestamp('1984-07-04 00:00:00'), 437, 'DOUGLAS', 18.3, -141.3, 30, 0, 'TD', 'Eastern Pacific', 1.118034], [2210, Timestamp('1993-09-16 12:00:00'), 620, 'KENNETH', 23.0, -137.5, 30, 1006, 'TD', 'Eastern Pacific', 0.42426400000000003], [2211, Timestamp('1984-08-18 18:00:00'), 445, 'KENNA', 12.2, -142.2, 50, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2212, Timestamp('1984-07-04 06:00:00'), 437, 'DOUGLAS', 18.5, -142.4, 25, 0, 'TD', 'Eastern Pacific', 1.1704700000000001], [2213, Timestamp('1993-09-16 18:00:00'), 620, 'KENNETH', 23.3, -137.8, 30, 1007, 'TD', 'Eastern Pacific', 0.360555], [2214, Timestamp('1985-08-05 00:00:00'), 466, 'LINDA', 17.9, -140.6, 40, 0, 'TS', 'Eastern Pacific', 0.6], [2215, Timestamp('1993-09-17 00:00:00'), 620, 'KENNETH', 23.6, -138.0, 30, 1008, 'TD', 'Eastern Pacific', 0.282843], [2216, Timestamp('1985-08-05 06:00:00'), 466, 'LINDA', 17.9, -141.2, 40, 0, 'TS', 'Eastern Pacific', 0.6], [2217, Timestamp('1993-09-17 06:00:00'), 620, 'KENNETH', 23.8, -138.2, 25, 1008, 'TD', 'Eastern Pacific', 0.44721400000000006], [2218, Timestamp('1985-08-05 12:00:00'), 466, 'LINDA', 17.9, -141.8, 40, 0, 'TS', 'Eastern Pacific', 0.5099020000000001], [2219, Timestamp('1994-09-09 06:00:00'), 636, 'LANE', 21.4, -136.4, 35, 1008, 'TS', 'Eastern Pacific', 1.3], [2220, Timestamp('1985-08-05 18:00:00'), 466, 'LINDA', 17.8, -142.3, 35, 0, 'TS', 'Eastern Pacific', 0.7], [2221, Timestamp('1994-09-09 12:00:00'), 636, 'LANE', 21.4, -137.7, 30, 1009, 'TD', 'Eastern Pacific', 1.204159], [2222, Timestamp('1994-09-09 18:00:00'), 636, 'LANE', 21.5, -138.9, 25, 1009, 'TD', 'Eastern Pacific', 1.104536], [2223, Timestamp('1985-08-06 00:00:00'), 466, 'LINDA', 17.8, -143.0, 30, 0, 'TD', 'Eastern Pacific', 0.9], [2224, Timestamp('1985-09-05 18:00:00'), 470, 'PAULINE', 18.5, -140.6, 75, 0, 'H1', 'Eastern Pacific', 1.4], [2225, Timestamp('1997-08-09 12:00:00'), 669, 'GUILLERMO', 21.3, -139.3, 45, 1000, 'TS', 'Eastern Pacific', 0.8485280000000001], [2226, Timestamp('1985-09-06 00:00:00'), 470, 'PAULINE', 18.5, -142.0, 75, 0, 'H1', 'Eastern Pacific', 1.0], [2227, Timestamp('1997-08-09 18:00:00'), 669, 'GUILLERMO', 21.9, -139.9, 45, 1002, 'TS', 'Eastern Pacific', 0.860233], [2228, Timestamp('1985-09-09 18:00:00'), 471, 'RICK', 18.0, -141.0, 125, 0, 'H4', 'Eastern Pacific', 1.029563], [2229, Timestamp('2001-09-09 06:00:00'), 729, 'GIL', 21.5, -136.2, 30, 1008, 'TD', 'Eastern Pacific', 1.280625], [2230, Timestamp('1985-09-10 00:00:00'), 471, 'RICK', 18.5, -141.9, 125, 0, 'H4', 'Eastern Pacific', 0.781025], [2231, Timestamp('2002-07-26 12:00:00'), 741, 'DOUGLAS', 21.4, -135.3, 25, 1008, 'TD', 'Eastern Pacific', 2.009975], [2232, Timestamp('1985-09-10 06:00:00'), 471, 'RICK', 19.0, -142.5, 110, 0, 'H3', 'Eastern Pacific', 0.781025], [2233, Timestamp('2002-07-26 18:00:00'), 741, 'DOUGLAS', 21.6, -137.3, 25, 1009, 'L', 'Eastern Pacific', 2.0], [2234, Timestamp('1985-09-10 12:00:00'), 471, 'RICK', 19.6, -143.0, 95, 0, 'H2', 'Eastern Pacific', 1.063015], [2235, Timestamp('2002-08-27 00:00:00'), 743, 'FAUSTO', 22.0, -135.6, 45, 1000, 'TS', 'Eastern Pacific', 1.523155], [2236, Timestamp('1986-07-21 06:00:00'), 482, 'ESTELLE', 15.4, -140.3, 115, 0, 'H4', 'Eastern Pacific', 2.0396080000000003], [2237, Timestamp('1986-07-21 12:00:00'), 482, 'ESTELLE', 15.8, -142.3, 115, 0, 'H4', 'Eastern Pacific', 1.9104970000000001], [2238, Timestamp('2002-08-27 06:00:00'), 743, 'FAUSTO', 22.6, -137.0, 40, 1002, 'TS', 'Eastern Pacific', 1.612452], [2239, Timestamp('2002-08-27 12:00:00'), 743, 'FAUSTO', 23.4, -138.4, 35, 1005, 'TS', 'Eastern Pacific', 1.664332], [2240, Timestamp('1986-09-23 00:00:00'), 492, 'ORLENE', 16.0, -140.7, 70, 0, 'H1', 'Eastern Pacific', 0.44721400000000006], [2241, Timestamp('2004-09-01 18:00:00'), 775, 'GEORGETTE', 21.3, -136.0, 20, 1010, 'L', 'Eastern Pacific', 1.2], [2242, Timestamp('1986-09-23 06:00:00'), 492, 'ORLENE', 16.4, -140.9, 70, 0, 'H1', 'Eastern Pacific', 0.42426400000000003], [2243, Timestamp('2004-09-02 00:00:00'), 775, 'GEORGETTE', 21.3, -137.2, 20, 1010, 'L', 'Eastern Pacific', 1.403567], [2244, Timestamp('1986-09-23 12:00:00'), 492, 'ORLENE', 16.7, -141.2, 65, 0, 'H1', 'Eastern Pacific', 0.632456], [2245, Timestamp('2004-09-02 06:00:00'), 775, 'GEORGETTE', 21.4, -138.6, 15, 1011, 'L', 'Eastern Pacific', 1.627882], [2246, Timestamp('1986-09-23 18:00:00'), 492, 'ORLENE', 16.9, -141.8, 60, 0, 'TS', 'Eastern Pacific', 0.5099020000000001], [2247, Timestamp('1986-09-24 00:00:00'), 492, 'ORLENE', 17.0, -142.3, 50, 0, 'TS', 'Eastern Pacific', 0.6], [2248, Timestamp('2006-07-16 00:00:00'), 797, 'BUD', 21.5, -135.2, 25, 1008, 'TD', 'Eastern Pacific', 1.676305], [2249, Timestamp('1986-09-24 06:00:00'), 492, 'ORLENE', 17.0, -142.9, 45, 0, 'TS', 'Eastern Pacific', 0.7], [2250, Timestamp('1988-07-31 06:00:00'), 521, 'GILMA', 17.2, -140.5, 25, 1009, 'TD', 'Eastern Pacific', 1.334166], [2251, Timestamp('2006-07-16 06:00:00'), 797, 'BUD', 22.0, -136.8, 25, 1009, 'TD', 'Eastern Pacific', 1.5811389999999999], [2252, Timestamp('2006-07-16 12:00:00'), 797, 'BUD', 22.5, -138.3, 20, 1010, 'L', 'Eastern Pacific', 1.5811389999999999], [2253, Timestamp('1988-07-31 12:00:00'), 521, 'GILMA', 17.5, -141.8, 25, 1009, 'TD', 'Eastern Pacific', 1.236932], [2254, Timestamp('1988-08-09 06:00:00'), 522, 'HECTOR', 18.7, -141.4, 35, 1005, 'TS', 'Eastern Pacific', 1.3038399999999999], [2255, Timestamp('2006-08-22 06:00:00'), 803, 'HECTOR', 22.6, -136.1, 40, 1005, 'TS', 'Eastern Pacific', 0.5099020000000001], [2256, Timestamp('2006-08-22 12:00:00'), 803, 'HECTOR', 22.7, -136.6, 35, 1007, 'TS', 'Eastern Pacific', 0.5099020000000001], [2257, Timestamp('1988-08-09 12:00:00'), 522, 'HECTOR', 18.8, -142.7, 30, 1011, 'TD', 'Eastern Pacific', 1.334166], [2258, Timestamp('2006-08-22 18:00:00'), 803, 'HECTOR', 22.8, -137.1, 35, 1007, 'TS', 'Eastern Pacific', 0.7], [2259, Timestamp('1990-09-14 18:00:00'), 560, 'MARIE', 17.4, -140.8, 100, 960, 'H3', 'Eastern Pacific', 1.004988], [2260, Timestamp('2006-08-23 00:00:00'), 803, 'HECTOR', 22.8, -137.8, 30, 1009, 'TD', 'Eastern Pacific', 0.905539], [2261, Timestamp('2006-08-23 06:00:00'), 803, 'HECTOR', 22.7, -138.7, 30, 1009, 'L', 'Eastern Pacific', 1.0], [2262, Timestamp('1990-09-15 00:00:00'), 560, 'MARIE', 17.3, -141.8, 100, 960, 'H3', 'Eastern Pacific', 0.9486829999999999], [2263, Timestamp('1990-09-15 06:00:00'), 560, 'MARIE', 17.0, -142.7, 100, 960, 'H3', 'Eastern Pacific', 0.9486829999999999], [2264, Timestamp('2006-08-23 12:00:00'), 803, 'HECTOR', 22.7, -139.7, 25, 1009, 'L', 'Eastern Pacific', 1.118034], [2265, Timestamp('1990-10-01 00:00:00'), 563, 'POLO', 16.2, -140.3, 45, 1000, 'TS', 'Eastern Pacific', 1.2], [2266, Timestamp('1950-08-28 00:00:00'), 12, 'NOTNAMED', 18.3, -135.8, 75, 0, 'H1', 'Eastern Pacific', 0.632456], [2267, Timestamp('1990-10-01 06:00:00'), 563, 'POLO', 16.2, -141.5, 40, 1003, 'TS', 'Eastern Pacific', 1.118034], [2268, Timestamp('1950-08-28 06:00:00'), 12, 'NOTNAMED', 18.5, -136.4, 75, 0, 'H1', 'Eastern Pacific', 0.608276], [2269, Timestamp('1990-10-01 12:00:00'), 563, 'POLO', 16.0, -142.6, 30, 1009, 'TD', 'Eastern Pacific', 1.029563], [2270, Timestamp('1950-08-28 12:00:00'), 12, 'NOTNAMED', 18.6, -137.0, 75, 0, 'H1', 'Eastern Pacific', 0.5099020000000001], [2271, Timestamp('1991-08-05 06:00:00'), 573, 'FEFA', 18.1, -140.3, 85, 972, 'H2', 'Eastern Pacific', 1.7], [2272, Timestamp('1950-08-28 18:00:00'), 12, 'NOTNAMED', 18.7, -137.5, 75, 0, 'H1', 'Eastern Pacific', 0.608276], [2273, Timestamp('1950-08-29 00:00:00'), 12, 'NOTNAMED', 18.8, -138.1, 75, 0, 'H1', 'Eastern Pacific', 0.7071069999999999], [2274, Timestamp('1991-08-05 12:00:00'), 573, 'FEFA', 18.1, -142.0, 80, 975, 'H1', 'Eastern Pacific', 1.204159], [2275, Timestamp('1950-08-29 06:00:00'), 12, 'NOTNAMED', 18.9, -138.8, 75, 0, 'H1', 'Eastern Pacific', 0.806226], [2276, Timestamp('1992-07-24 12:00:00'), 590, 'GEORGETTE', 17.6, -141.5, 30, 1008, 'TD', 'Eastern Pacific', 2.009975], [2277, Timestamp('1950-08-29 12:00:00'), 12, 'NOTNAMED', 19.0, -139.6, 75, 0, 'H1', 'Eastern Pacific', 0.7071069999999999], [2278, Timestamp('1992-08-08 00:00:00'), 593, 'JAVIER', 15.8, -140.8, 40, 1003, 'TS', 'Eastern Pacific', 1.802776], [2279, Timestamp('1954-09-06 06:00:00'), 38, 'NOTNAMED', 20.0, -135.9, 45, 0, 'TS', 'Eastern Pacific', 0.608276], [2280, Timestamp('1992-08-08 06:00:00'), 593, 'JAVIER', 15.7, -142.6, 40, 1004, 'TS', 'Eastern Pacific', 1.603122], [2281, Timestamp('1954-09-06 12:00:00'), 38, 'NOTNAMED', 20.6, -136.0, 45, 0, 'TS', 'Eastern Pacific', 0.860233], [2282, Timestamp('1992-09-24 12:00:00'), 601, 'ROSLYN', 18.3, -140.5, 60, 992, 'TS', 'Eastern Pacific', 1.403567], [2283, Timestamp('1957-07-22 06:00:00'), 62, 'KANOA', 17.3, -135.9, 75, 0, 'H1', 'Eastern Pacific', 1.216553], [2284, Timestamp('1992-09-24 18:00:00'), 601, 'ROSLYN', 18.2, -141.9, 55, 994, 'TS', 'Eastern Pacific', 1.3], [2285, Timestamp('1957-07-22 12:00:00'), 62, 'KANOA', 17.5, -137.1, 75, 0, 'H1', 'Eastern Pacific', 1.118034], [2286, Timestamp('1957-07-22 18:00:00'), 62, 'KANOA', 17.7, -138.2, 75, 0, 'H1', 'Eastern Pacific', 1.104536], [2287, Timestamp('1993-07-20 00:00:00'), 612, 'DORA', 17.4, -140.6, 25, 1010, 'TD', 'Eastern Pacific', 1.2], [2288, Timestamp('1957-07-23 00:00:00'), 62, 'KANOA', 17.8, -139.3, 75, 0, 'H1', 'Eastern Pacific', 1.204159], [2289, Timestamp('1993-07-20 06:00:00'), 612, 'DORA', 17.4, -141.8, 25, 1010, 'TD', 'Eastern Pacific', 1.7], [2290, Timestamp('1957-09-09 06:00:00'), 66, 'NOTNAMED', 15.5, -139.7, 45, 0, 'TS', 'Eastern Pacific', 0.8544], [2291, Timestamp('1993-07-23 00:00:00'), 613, 'EUGENE', 19.5, -142.0, 35, 1000, 'TS', 'Eastern Pacific', 2.517936], [2292, Timestamp('1958-07-20 18:00:00'), 77, 'NOTNAMED', 18.3, -135.8, 75, 0, 'H1', 'Eastern Pacific', 1.004988], [2293, Timestamp('1993-08-14 12:00:00'), 615, 'FERNANDA', 18.6, -141.2, 80, 976, 'H1', 'Eastern Pacific', 1.7], [2294, Timestamp('1958-07-21 00:00:00'), 77, 'NOTNAMED', 18.4, -136.8, 75, 0, 'H1', 'Eastern Pacific', 0.8], [2295, Timestamp('1994-07-22 06:00:00'), 629, 'FABIO', 16.5, -140.9, 25, 1008, 'TD', 'Eastern Pacific', 1.702939], [2296, Timestamp('1958-07-21 06:00:00'), 77, 'NOTNAMED', 18.4, -137.6, 75, 0, 'H1', 'Eastern Pacific', 0.7071069999999999], [2297, Timestamp('1959-07-20 12:00:00'), 90, 'NOTNAMED', 20.2, -135.7, 45, 0, 'TS', 'Eastern Pacific', 1.0], [2298, Timestamp('1994-08-31 12:00:00'), 635, 'KRISTY', 16.3, -141.3, 65, 0, 'H1', 'Eastern Pacific', 1.5033299999999998], [2299, Timestamp('1959-07-20 18:00:00'), 90, 'NOTNAMED', 20.2, -136.7, 45, 0, 'TS', 'Eastern Pacific', 0.905539], [2300, Timestamp('1994-08-31 18:00:00'), 635, 'KRISTY', 16.4, -142.8, 85, 0, 'H2', 'Eastern Pacific', 1.3038399999999999], [2301, Timestamp('1959-07-21 00:00:00'), 90, 'NOTNAMED', 20.3, -137.6, 45, 0, 'TS', 'Eastern Pacific', 0.806226], [2302, Timestamp('1995-07-17 00:00:00'), 645, 'BARBARA', 16.3, -140.5, 30, 1009, 'TD', 'Eastern Pacific', 1.0198040000000002], [2303, Timestamp('1959-07-21 06:00:00'), 90, 'NOTNAMED', 20.4, -138.4, 45, 0, 'TS', 'Eastern Pacific', 0.7071069999999999], [2304, Timestamp('1995-07-17 06:00:00'), 645, 'BARBARA', 16.5, -141.5, 30, 1009, 'TD', 'Eastern Pacific', 0.9486829999999999], [2305, Timestamp('1959-07-21 12:00:00'), 90, 'NOTNAMED', 20.5, -139.1, 45, 0, 'TS', 'Eastern Pacific', 0.806226], [2306, Timestamp('1995-07-17 12:00:00'), 645, 'BARBARA', 16.8, -142.4, 30, 1009, 'TD', 'Eastern Pacific', 1.044031], [2307, Timestamp('1959-07-21 18:00:00'), 90, 'NOTNAMED', 20.6, -139.9, 45, 0, 'TS', 'Eastern Pacific', 0.8], [2308, Timestamp('1997-07-21 12:00:00'), 668, 'FELICIA', 17.4, -140.8, 55, 990, 'TS', 'Eastern Pacific', 2.2022720000000002], [2309, Timestamp('1997-08-29 18:00:00'), 672, 'JIMENA', 20.6, -140.5, 30, 1008, 'TD', 'Eastern Pacific', 0.7071069999999999], [2310, Timestamp('1962-08-29 00:00:00'), 124, 'C', 18.0, -139.9, 45, 0, 'TS', 'Eastern Pacific', 0.1], [2311, Timestamp('1998-07-29 06:00:00'), 685, 'DARBY', 18.9, -140.6, 65, 990, 'H1', 'Eastern Pacific', 1.3], [2312, Timestamp('1963-09-14 12:00:00'), 134, 'IRAH', 21.1, -136.9, 45, 0, 'TS', 'Eastern Pacific', 1.104536], [2313, Timestamp('1998-07-29 12:00:00'), 685, 'DARBY', 19.4, -141.8, 60, 995, 'TS', 'Eastern Pacific', 1.4317819999999999], [2314, Timestamp('1963-09-14 18:00:00'), 134, 'IRAH', 21.0, -138.0, 45, 0, 'TS', 'Eastern Pacific', 1.004988], [2315, Timestamp('1966-08-11 06:00:00'), 154, 'CONNIE', 16.0, -135.7, 45, 0, 'TS', 'Eastern Pacific', 1.077033], [2316, Timestamp('1998-08-06 18:00:00'), 686, 'ESTELLE', 20.6, -140.3, 30, 1006, 'TD', 'Eastern Pacific', 1.4142139999999999], [2317, Timestamp('1966-08-11 12:00:00'), 154, 'CONNIE', 16.4, -136.7, 45, 0, 'TS', 'Eastern Pacific', 0.9486829999999999], [2318, Timestamp('1998-08-07 00:00:00'), 686, 'ESTELLE', 20.8, -141.7, 30, 1006, 'TD', 'Eastern Pacific', 1.216553], [2319, Timestamp('1999-08-14 06:00:00'), 698, 'DORA', 15.5, -141.7, 75, 975, 'H1', 'Eastern Pacific', 1.802776], [2320, Timestamp('1966-08-11 18:00:00'), 154, 'CONNIE', 16.7, -137.6, 45, 0, 'TS', 'Eastern Pacific', 0.9486829999999999], [2321, Timestamp('1966-08-12 00:00:00'), 154, 'CONNIE', 17.0, -138.5, 45, 0, 'TS', 'Eastern Pacific', 1.140175], [2322, Timestamp('2000-07-29 00:00:00'), 708, 'DANIEL', 18.0, -141.3, 80, 980, 'H1', 'Eastern Pacific', 1.6492419999999999], [2323, Timestamp('1966-08-12 06:00:00'), 154, 'CONNIE', 17.3, -139.6, 45, 0, 'TS', 'Eastern Pacific', 1.236932], [2324, Timestamp('2000-08-31 06:00:00'), 715, 'JOHN', 17.2, -140.6, 45, 999, 'TS', 'Eastern Pacific', 0.632456], [2325, Timestamp('1967-07-13 18:00:00'), 168, 'DENISE', 17.0, -135.4, 45, 0, 'TS', 'Eastern Pacific', 2.009975], [2326, Timestamp('2000-08-31 12:00:00'), 715, 'JOHN', 17.0, -141.2, 35, 1004, 'TS', 'Eastern Pacific', 0.5099020000000001], [2327, Timestamp('1967-07-14 00:00:00'), 168, 'DENISE', 16.8, -137.4, 45, 0, 'TS', 'Eastern Pacific', 2.109502], [2328, Timestamp('2000-08-31 18:00:00'), 715, 'JOHN', 17.1, -141.7, 35, 1006, 'TS', 'Eastern Pacific', 0.282843], [2329, Timestamp('1967-07-16 18:00:00'), 169, 'ELEANOR', 20.0, -136.3, 25, 0, 'TD', 'Eastern Pacific', 1.004988], [2330, Timestamp('2000-09-01 00:00:00'), 715, 'JOHN', 17.3, -141.9, 30, 1006, 'TD', 'Eastern Pacific', 0.1], [2331, Timestamp('1967-07-17 00:00:00'), 169, 'ELEANOR', 20.1, -137.3, 25, 0, 'TD', 'Eastern Pacific', 0.7071069999999999], [2332, Timestamp('2000-09-01 06:00:00'), 715, 'JOHN', 17.4, -141.9, 30, 1008, 'TD', 'Eastern Pacific', 0.1], [2333, Timestamp('1967-07-17 06:00:00'), 169, 'ELEANOR', 20.2, -138.0, 25, 0, 'TD', 'Eastern Pacific', 0.921954], [2334, Timestamp('2001-06-23 00:00:00'), 724, 'BARBARA', 17.3, -141.2, 30, 1006, 'TD', 'Eastern Pacific', 1.456022], [2335, Timestamp('1967-07-17 12:00:00'), 169, 'ELEANOR', 20.4, -138.9, 25, 0, 'TD', 'Eastern Pacific', 1.140175], [2336, Timestamp('1967-07-17 18:00:00'), 169, 'ELEANOR', 20.7, -140.0, 25, 0, 'TD', 'Eastern Pacific', 1.044031], [2337, Timestamp('2001-06-23 06:00:00'), 724, 'BARBARA', 17.7, -142.6, 30, 1007, 'TD', 'Eastern Pacific', 1.140175], [2338, Timestamp('1967-10-28 12:00:00'), 181, 'RAMONA', 15.5, -137.3, 25, 0, 'TD', 'Eastern Pacific', 1.3], [2339, Timestamp('1967-10-28 18:00:00'), 181, 'RAMONA', 15.5, -138.6, 25, 0, 'TD', 'Eastern Pacific', 1.3038399999999999], [2340, Timestamp('2001-10-24 00:00:00'), 736, 'NARDA', 16.4, -141.2, 30, 1004, 'TD', 'Eastern Pacific', 1.204159], [2341, Timestamp('1967-10-29 00:00:00'), 181, 'RAMONA', 15.6, -139.9, 25, 0, 'TD', 'Eastern Pacific', 0.632456], [2342, Timestamp('2001-10-24 06:00:00'), 736, 'NARDA', 16.5, -142.4, 30, 1004, 'TD', 'Eastern Pacific', 1.118034], [2343, Timestamp('2003-07-24 00:00:00'), 758, 'FELICIA', 17.8, -140.5, 20, 1010, 'L', 'Eastern Pacific', 1.9026299999999998], [2344, Timestamp('1968-08-12 12:00:00'), 187, 'FERNANDA', 19.5, -136.2, 45, 0, 'TS', 'Eastern Pacific', 1.16619], [2345, Timestamp('1968-08-12 18:00:00'), 187, 'FERNANDA', 20.1, -137.2, 45, 0, 'TS', 'Eastern Pacific', 1.0816649999999999], [2346, Timestamp('2003-07-24 06:00:00'), 758, 'FELICIA', 17.9, -142.4, 20, 1010, 'L', 'Eastern Pacific', 2.10238], [2347, Timestamp('1968-08-13 00:00:00'), 187, 'FERNANDA', 20.7, -138.1, 45, 0, 'TS', 'Eastern Pacific', 0.943398], [2348, Timestamp('2003-08-30 12:00:00'), 762, 'JIMENA', 17.3, -141.3, 85, 972, 'H2', 'Eastern Pacific', 1.6], [2349, Timestamp('2004-08-01 00:00:00'), 772, 'DARBY', 19.0, -140.4, 25, 1007, 'TD', 'Eastern Pacific', 1.627882], [2350, Timestamp('1969-07-23 06:00:00'), 203, 'CLAUDIA', 16.0, -136.7, 25, 0, 'TD', 'Eastern Pacific', 1.7088009999999998], [2351, Timestamp('2004-08-21 18:00:00'), 773, 'ESTELLE', 15.4, -141.2, 60, 990, 'TS', 'Eastern Pacific', 0.565685], [2352, Timestamp('1970-08-25 18:00:00'), 222, 'LORRAINE', 19.1, -136.2, 45, 0, 'TS', 'Eastern Pacific', 0.921954], [2353, Timestamp('2004-08-22 00:00:00'), 773, 'ESTELLE', 15.8, -141.6, 55, 995, 'TS', 'Eastern Pacific', 0.538516], [2354, Timestamp('1970-08-26 00:00:00'), 222, 'LORRAINE', 19.3, -137.1, 45, 0, 'TS', 'Eastern Pacific', 1.044031], [2355, Timestamp('2004-08-22 06:00:00'), 773, 'ESTELLE', 16.0, -142.1, 50, 996, 'TS', 'Eastern Pacific', 0.316228], [2356, Timestamp('1970-08-26 06:00:00'), 222, 'LORRAINE', 19.6, -138.1, 45, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2357, Timestamp('2004-08-22 12:00:00'), 773, 'ESTELLE', 16.1, -142.4, 35, 998, 'TS', 'Eastern Pacific', 0.412311], [2358, Timestamp('1970-08-26 12:00:00'), 222, 'LORRAINE', 19.8, -139.1, 45, 0, 'TS', 'Eastern Pacific', 0.921954], [2359, Timestamp('1970-08-26 18:00:00'), 222, 'LORRAINE', 20.0, -140.0, 25, 0, 'TD', 'Eastern Pacific', 1.0], [2360, Timestamp('2004-08-22 18:00:00'), 773, 'ESTELLE', 16.2, -142.8, 35, 998, 'TS', 'Eastern Pacific', 0.632456], [2361, Timestamp('1971-07-10 18:00:00'), 233, 'DENISE', 15.2, -139.1, 100, 0, 'H3', 'Eastern Pacific', 1.878829], [2362, Timestamp('2005-09-19 18:00:00'), 790, 'JOVA', 15.6, -142.7, 105, 955, 'H3', 'Eastern Pacific', 0.72111], [2363, Timestamp('2005-09-27 18:00:00'), 791, 'KENNETH', 15.2, -142.4, 45, 1005, 'TS', 'Eastern Pacific', 1.063015], [2364, Timestamp('1971-08-05 00:00:00'), 237, 'HILARY', 19.2, -136.1, 45, 0, 'TS', 'Eastern Pacific', 0.7071069999999999], [2365, Timestamp('2006-07-24 12:00:00'), 799, 'DANIEL', 16.2, -140.4, 80, 980, 'H1', 'Eastern Pacific', 0.9], [2366, Timestamp('1971-08-05 06:00:00'), 237, 'HILARY', 19.3, -136.8, 45, 0, 'TS', 'Eastern Pacific', 0.8], [2367, Timestamp('2006-07-24 18:00:00'), 799, 'DANIEL', 16.2, -141.3, 75, 985, 'H1', 'Eastern Pacific', 0.5], [2368, Timestamp('1971-08-05 12:00:00'), 237, 'HILARY', 19.3, -137.6, 45, 0, 'TS', 'Eastern Pacific', 0.905539], [2369, Timestamp('2006-07-25 00:00:00'), 799, 'DANIEL', 16.2, -141.8, 65, 994, 'H1', 'Eastern Pacific', 0.5], [2370, Timestamp('1971-08-05 18:00:00'), 237, 'HILARY', 19.4, -138.5, 45, 0, 'TS', 'Eastern Pacific', 0.905539], [2371, Timestamp('2006-07-25 06:00:00'), 799, 'DANIEL', 16.2, -142.3, 55, 999, 'TS', 'Eastern Pacific', 0.1], [2372, Timestamp('1971-08-06 00:00:00'), 237, 'HILARY', 19.5, -139.4, 45, 0, 'TS', 'Eastern Pacific', 0.806226], [2373, Timestamp('2006-07-25 12:00:00'), 799, 'DANIEL', 16.2, -142.4, 45, 1003, 'TS', 'Eastern Pacific', 0.2], [2374, Timestamp('1971-08-06 06:00:00'), 237, 'HILARY', 19.6, -140.2, 45, 0, 'TS', 'Eastern Pacific', 0.728011], [2375, Timestamp('2006-07-25 18:00:00'), 799, 'DANIEL', 16.2, -142.6, 35, 1004, 'TS', 'Eastern Pacific', 0.2], [2376, Timestamp('1972-08-11 06:00:00'), 250, 'CELESTE', 15.7, -136.4, 70, 0, 'H1', 'Eastern Pacific', 1.140175], [2377, Timestamp('2006-07-26 00:00:00'), 799, 'DANIEL', 16.2, -142.8, 30, 1006, 'TD', 'Eastern Pacific', 0.1], [2378, Timestamp('1972-08-15 18:00:00'), 251, 'DIANA', 18.8, -135.4, 70, 0, 'H1', 'Eastern Pacific', 1.702939], [2379, Timestamp('2006-07-26 06:00:00'), 799, 'DANIEL', 16.2, -142.9, 30, 1008, 'TD', 'Eastern Pacific', 0.2], [2380, Timestamp('1972-08-16 00:00:00'), 251, 'DIANA', 18.7, -137.1, 70, 0, 'H1', 'Eastern Pacific', 1.3038399999999999], [2381, Timestamp('2006-07-26 12:00:00'), 799, 'DANIEL', 16.2, -143.1, 25, 1009, 'TD', 'Eastern Pacific', 0.5099020000000001], [2382, Timestamp('1972-08-16 06:00:00'), 251, 'DIANA', 18.6, -138.4, 70, 0, 'H1', 'Eastern Pacific', 1.403567], [2383, Timestamp('2008-07-21 06:00:00'), 830, 'ELIDA', 16.7, -141.5, 25, 1009, 'L', 'Eastern Pacific', 1.7117240000000002], [2384, Timestamp('1972-08-26 06:00:00'), 253, 'FERNANDA', 19.8, -136.1, 65, 0, 'H1', 'Eastern Pacific', 1.403567], [2385, Timestamp('2008-08-14 18:00:00'), 834, 'HERNAN', 16.3, -140.6, 25, 1008, 'L', 'Eastern Pacific', 1.1704700000000001], [2386, Timestamp('1972-08-26 12:00:00'), 253, 'FERNANDA', 19.9, -137.5, 60, 0, 'TS', 'Eastern Pacific', 1.5033299999999998], [2387, Timestamp('1972-08-26 18:00:00'), 253, 'FERNANDA', 19.8, -139.0, 60, 0, 'TS', 'Eastern Pacific', 1.4], [2388, Timestamp('1973-07-24 12:00:00'), 265, 'DOREEN', 15.4, -135.7, 65, 0, 'H1', 'Eastern Pacific', 1.236932], [2389, Timestamp('2008-08-15 00:00:00'), 834, 'HERNAN', 15.9, -141.7, 25, 1008, 'L', 'Eastern Pacific', 1.140175], [2390, Timestamp('1973-07-24 18:00:00'), 265, 'DOREEN', 15.7, -136.9, 65, 0, 'H1', 'Eastern Pacific', 1.140175], [2391, Timestamp('2008-08-15 06:00:00'), 834, 'HERNAN', 15.6, -142.8, 25, 1008, 'L', 'Eastern Pacific', 1.216553], [2392, Timestamp('1954-09-08 00:00:00'), 38, 'NOTNAMED', 23.3, -140.3, 45, 0, 'TS', 'Eastern Pacific', 1.118034], [2393, Timestamp('1973-07-25 00:00:00'), 265, 'DOREEN', 16.0, -138.0, 70, 0, 'H1', 'Eastern Pacific', 0.7071069999999999], [2394, Timestamp('1954-09-08 06:00:00'), 38, 'NOTNAMED', 23.1, -141.4, 45, 0, 'TS', 'Eastern Pacific', 1.392839], [2395, Timestamp('1973-07-25 06:00:00'), 265, 'DOREEN', 16.1, -138.7, 70, 0, 'H1', 'Eastern Pacific', 0.806226], [2396, Timestamp('1973-07-25 12:00:00'), 265, 'DOREEN', 16.2, -139.5, 60, 0, 'TS', 'Eastern Pacific', 0.905539], [2397, Timestamp('1954-09-08 12:00:00'), 38, 'NOTNAMED', 22.6, -142.7, 45, 0, 'TS', 'Eastern Pacific', 1.6552950000000002], [2398, Timestamp('1957-08-09 00:00:00'), 63, 'NOTNAMED', 22.8, -141.1, 50, 0, 'TS', 'Eastern Pacific', 2.10238], [2399, Timestamp('1961-10-03 18:00:00'), 116, 'PAULINE', 22.7, -141.2, 45, 0, 'TS', 'Eastern Pacific', 1.063015], [2400, Timestamp('1963-09-15 12:00:00'), 134, 'IRAH', 21.5, -141.0, 25, 0, 'TD', 'Eastern Pacific', 1.334166], [2401, Timestamp('1988-07-31 00:00:00'), 521, 'GILMA', 16.9, -139.9, 30, 1008, 'TD', 'Eastern Pacific', 0.67082], [2402, Timestamp('1988-08-08 06:00:00'), 522, 'HECTOR', 18.0, -136.1, 60, 990, 'TS', 'Eastern Pacific', 1.3038399999999999], [2403, Timestamp('1988-08-08 12:00:00'), 522, 'HECTOR', 18.1, -137.4, 55, 994, 'TS', 'Eastern Pacific', 1.334166], [2404, Timestamp('1988-08-08 18:00:00'), 522, 'HECTOR', 18.4, -138.7, 45, 999, 'TS', 'Eastern Pacific', 1.315295], [2405, Timestamp('1989-07-20 18:00:00'), 534, 'ERICK', 16.7, -137.0, 30, 1009, 'TD', 'Eastern Pacific', 2.5495099999999997], [2406, Timestamp('1989-08-17 12:00:00'), 537, 'HENRIETTE', 19.0, -136.4, 30, 1006, 'TD', 'Eastern Pacific', 0.921954], [2407, Timestamp('1989-08-17 18:00:00'), 537, 'HENRIETTE', 19.2, -137.3, 30, 1009, 'TD', 'Eastern Pacific', 0.8246209999999999], [2408, Timestamp('1989-08-24 06:00:00'), 538, 'ISMAEL', 18.6, -135.5, 35, 1000, 'TS', 'Eastern Pacific', 1.004988], [2409, Timestamp('1989-08-24 12:00:00'), 538, 'ISMAEL', 18.7, -136.5, 30, 1004, 'TD', 'Eastern Pacific', 1.0198040000000002], [2410, Timestamp('1989-08-24 18:00:00'), 538, 'ISMAEL', 18.9, -137.5, 30, 1008, 'TD', 'Eastern Pacific', 1.004988], [2411, Timestamp('1989-08-25 00:00:00'), 538, 'ISMAEL', 19.0, -138.5, 25, 1010, 'TD', 'Eastern Pacific', 1.044031], [2412, Timestamp('1989-08-25 06:00:00'), 538, 'ISMAEL', 19.3, -139.5, 25, 1011, 'TD', 'Eastern Pacific', 1.0198040000000002], [2413, Timestamp('1990-08-24 06:00:00'), 557, 'JULIO', 17.8, -135.3, 30, 1008, 'TD', 'Eastern Pacific', 1.315295], [2414, Timestamp('1990-08-24 12:00:00'), 557, 'JULIO', 17.6, -136.6, 30, 1009, 'TD', 'Eastern Pacific', 1.3], [2415, Timestamp('1990-08-30 00:00:00'), 558, 'KENNA', 20.6, -135.9, 25, 1010, 'TD', 'Eastern Pacific', 1.0], [2416, Timestamp('1990-08-30 06:00:00'), 558, 'KENNA', 20.0, -136.7, 25, 1010, 'TD', 'Eastern Pacific', 1.208305], [2417, Timestamp('1990-09-12 12:00:00'), 560, 'MARIE', 16.0, -136.0, 90, 969, 'H2', 'Eastern Pacific', 0.67082], [2418, Timestamp('1990-09-12 18:00:00'), 560, 'MARIE', 16.3, -136.6, 85, 973, 'H2', 'Eastern Pacific', 0.640312], [2419, Timestamp('1990-09-13 00:00:00'), 560, 'MARIE', 16.7, -137.1, 90, 973, 'H2', 'Eastern Pacific', 0.67082], [2420, Timestamp('1990-09-13 06:00:00'), 560, 'MARIE', 17.0, -137.7, 90, 969, 'H2', 'Eastern Pacific', 0.583095], [2421, Timestamp('1990-09-13 12:00:00'), 560, 'MARIE', 17.3, -138.2, 95, 963, 'H2', 'Eastern Pacific', 0.5099020000000001], [2422, Timestamp('1990-09-13 18:00:00'), 560, 'MARIE', 17.4, -138.7, 100, 960, 'H3', 'Eastern Pacific', 0.5099020000000001], [2423, Timestamp('1990-09-14 00:00:00'), 560, 'MARIE', 17.5, -139.2, 100, 960, 'H3', 'Eastern Pacific', 0.412311], [2424, Timestamp('1990-09-14 06:00:00'), 560, 'MARIE', 17.4, -139.6, 100, 960, 'H3', 'Eastern Pacific', 0.5099020000000001], [2425, Timestamp('1990-09-14 12:00:00'), 560, 'MARIE', 17.5, -140.1, 100, 960, 'H3', 'Eastern Pacific', 0.7071069999999999], [2426, Timestamp('1990-09-30 12:00:00'), 563, 'POLO', 15.5, -139.3, 65, 987, 'H1', 'Eastern Pacific', 0.583095], [2427, Timestamp('1990-09-30 18:00:00'), 563, 'POLO', 16.0, -139.6, 50, 997, 'TS', 'Eastern Pacific', 0.728011], [2428, Timestamp('1991-07-20 12:00:00'), 572, 'ENRIQUE', 15.3, -139.0, 30, 1012, 'TD', 'Eastern Pacific', 0.583095], [2429, Timestamp('1991-07-20 18:00:00'), 572, 'ENRIQUE', 15.6, -139.5, 25, 1014, 'TD', 'Eastern Pacific', 0.22360700000000003], [2430, Timestamp('1991-07-21 00:00:00'), 572, 'ENRIQUE', 15.7, -139.7, 25, 1014, 'TD', 'Eastern Pacific', 0.0], [2431, Timestamp('1991-07-21 06:00:00'), 572, 'ENRIQUE', 15.7, -139.7, 25, 1014, 'TD', 'Eastern Pacific', 0.565685], [2432, Timestamp('1991-07-21 12:00:00'), 572, 'ENRIQUE', 16.1, -140.1, 25, 1014, 'TD', 'Eastern Pacific', 1.0], [2433, Timestamp('1991-08-04 12:00:00'), 573, 'FEFA', 18.0, -135.5, 90, 970, 'H2', 'Eastern Pacific', 1.6], [2434, Timestamp('1991-08-04 18:00:00'), 573, 'FEFA', 18.0, -137.1, 90, 970, 'H2', 'Eastern Pacific', 1.5033299999999998], [2435, Timestamp('1991-08-05 00:00:00'), 573, 'FEFA', 18.1, -138.6, 90, 970, 'H2', 'Eastern Pacific', 1.7], [2436, Timestamp('1963-09-15 18:00:00'), 134, 'IRAH', 21.8, -142.3, 25, 0, 'TD', 'Eastern Pacific', 1.360147], [2437, Timestamp('1991-10-08 00:00:00'), 578, 'KEVIN', 18.1, -135.9, 100, 960, 'H3', 'Eastern Pacific', 0.72111], [2438, Timestamp('1966-08-07 18:00:00'), 153, 'BLANCA', 22.9, -140.7, 25, 0, 'TD', 'Eastern Pacific', 1.476482], [2439, Timestamp('1991-10-08 06:00:00'), 578, 'KEVIN', 18.5, -136.5, 95, 963, 'H2', 'Eastern Pacific', 0.8944270000000001], [2440, Timestamp('1966-08-08 00:00:00'), 153, 'BLANCA', 23.6, -142.0, 25, 0, 'TD', 'Eastern Pacific', 1.1704700000000001], [2441, Timestamp('1991-10-08 12:00:00'), 578, 'KEVIN', 18.9, -137.3, 90, 966, 'H2', 'Eastern Pacific', 0.943398], [2442, Timestamp('1991-10-08 18:00:00'), 578, 'KEVIN', 19.4, -138.1, 85, 970, 'H2', 'Eastern Pacific', 1.029563], [2443, Timestamp('1997-08-29 00:00:00'), 672, 'JIMENA', 19.6, -138.2, 100, 960, 'H3', 'Eastern Pacific', 0.8485280000000001], [2444, Timestamp('1967-07-18 00:00:00'), 169, 'ELEANOR', 21.0, -141.0, 25, 0, 'TD', 'Eastern Pacific', 1.236932], [2445, Timestamp('1991-10-09 00:00:00'), 578, 'KEVIN', 19.9, -139.0, 80, 975, 'H1', 'Eastern Pacific', 1.118034], [2446, Timestamp('1997-08-29 06:00:00'), 672, 'JIMENA', 20.2, -138.8, 60, 980, 'TS', 'Eastern Pacific', 0.9486829999999999], [2447, Timestamp('1967-07-18 06:00:00'), 169, 'ELEANOR', 21.3, -142.2, 25, 0, 'TD', 'Eastern Pacific', 1.044031], [2448, Timestamp('1991-10-09 06:00:00'), 578, 'KEVIN', 20.4, -140.0, 75, 980, 'H1', 'Eastern Pacific', 1.16619], [2449, Timestamp('1997-08-29 12:00:00'), 672, 'JIMENA', 20.5, -139.7, 35, 999, 'TS', 'Eastern Pacific', 0.806226], [2450, Timestamp('1992-07-23 18:00:00'), 590, 'GEORGETTE', 17.5, -135.4, 40, 1002, 'TS', 'Eastern Pacific', 2.0], [2451, Timestamp('1968-08-13 18:00:00'), 187, 'FERNANDA', 21.3, -140.4, 25, 0, 'TD', 'Eastern Pacific', 0.67082], [2452, Timestamp('1974-10-15 12:00:00'), 290, 'PATRICIA', 16.8, -136.0, 25, 0, 'TD', 'Eastern Pacific', 1.4], [2453, Timestamp('1992-07-24 00:00:00'), 590, 'GEORGETTE', 17.5, -137.4, 35, 1005, 'TS', 'Eastern Pacific', 2.0], [2454, Timestamp('1998-07-28 12:00:00'), 685, 'DARBY', 17.7, -136.1, 85, 974, 'H2', 'Eastern Pacific', 1.529706], [2455, Timestamp('1992-08-07 06:00:00'), 593, 'JAVIER', 17.0, -135.5, 45, 998, 'TS', 'Eastern Pacific', 1.6492419999999999], [2456, Timestamp('1992-08-07 12:00:00'), 593, 'JAVIER', 16.6, -137.1, 40, 1001, 'TS', 'Eastern Pacific', 1.746425], [2457, Timestamp('1992-08-07 18:00:00'), 593, 'JAVIER', 16.2, -138.8, 40, 1002, 'TS', 'Eastern Pacific', 2.0396080000000003], [2458, Timestamp('1968-08-14 00:00:00'), 187, 'FERNANDA', 21.0, -141.0, 25, 0, 'TD', 'Eastern Pacific', 0.42426400000000003], [2459, Timestamp('1974-10-15 18:00:00'), 290, 'PATRICIA', 16.8, -137.4, 25, 0, 'TD', 'Eastern Pacific', 1.3], [2460, Timestamp('1992-08-22 06:00:00'), 594, 'KAY', 18.2, -135.5, 25, 1009, 'TD', 'Eastern Pacific', 1.612452], [2461, Timestamp('1984-08-25 06:00:00'), 446, 'LALA', 11.4, -136.4, 30, 0, 'TD', 'Eastern Pacific', 0.9], [2462, Timestamp('1992-08-22 12:00:00'), 594, 'KAY', 18.0, -137.1, 25, 1009, 'TD', 'Eastern Pacific', 1.513275], [2463, Timestamp('1992-08-30 06:00:00'), 596, 'MADELINE', 15.9, -136.4, 40, 1004, 'TS', 'Eastern Pacific', 1.3], [2464, Timestamp('1994-08-20 06:00:00'), 634, 'JOHN', 15.1, -135.6, 75, 979, 'H1', 'Eastern Pacific', 1.603122], [2465, Timestamp('1968-08-14 06:00:00'), 187, 'FERNANDA', 21.3, -141.3, 25, 0, 'TD', 'Eastern Pacific', 0.42426400000000003], [2466, Timestamp('1984-08-25 12:00:00'), 446, 'LALA', 11.4, -137.3, 30, 0, 'TD', 'Eastern Pacific', 0.905539], [2467, Timestamp('1998-07-28 18:00:00'), 685, 'DARBY', 18.0, -137.6, 75, 979, 'H1', 'Eastern Pacific', 1.6492419999999999], [2468, Timestamp('1994-08-20 12:00:00'), 634, 'JOHN', 15.0, -137.2, 90, 970, 'H2', 'Eastern Pacific', 1.7], [2469, Timestamp('1974-10-16 00:00:00'), 290, 'PATRICIA', 16.8, -138.7, 25, 0, 'TD', 'Eastern Pacific', 1.0], [2470, Timestamp('1998-07-29 00:00:00'), 685, 'DARBY', 18.4, -139.2, 70, 984, 'H1', 'Eastern Pacific', 1.486607], [2471, Timestamp('1974-10-16 06:00:00'), 290, 'PATRICIA', 16.8, -139.7, 25, 0, 'TD', 'Eastern Pacific', 1.1], [2472, Timestamp('1994-08-20 18:00:00'), 634, 'JOHN', 15.0, -138.9, 100, 960, 'H3', 'Eastern Pacific', 1.7], [2473, Timestamp('1984-08-25 18:00:00'), 446, 'LALA', 11.3, -138.2, 30, 0, 'TD', 'Eastern Pacific', 1.104536], [2474, Timestamp('1968-08-14 12:00:00'), 187, 'FERNANDA', 21.6, -141.6, 25, 0, 'TD', 'Eastern Pacific', 1.063015], [2475, Timestamp('1994-08-21 00:00:00'), 634, 'JOHN', 15.0, -140.6, 100, 0, 'H3', 'Eastern Pacific', 1.513275], [2476, Timestamp('1976-07-21 12:00:00'), 312, 'DIANA', 18.4, -136.4, 35, 0, 'TS', 'Eastern Pacific', 1.7117240000000002], [2477, Timestamp('1998-08-06 00:00:00'), 686, 'ESTELLE', 19.8, -136.1, 30, 1006, 'TD', 'Eastern Pacific', 1.4317819999999999], [2478, Timestamp('1984-08-26 00:00:00'), 446, 'LALA', 11.2, -139.3, 30, 0, 'TD', 'Eastern Pacific', 1.204159], [2479, Timestamp('1968-08-14 18:00:00'), 187, 'FERNANDA', 22.3, -142.4, 25, 0, 'TD', 'Eastern Pacific', 1.063015], [2480, Timestamp('1984-08-26 06:00:00'), 446, 'LALA', 11.1, -140.5, 30, 0, 'TD', 'Eastern Pacific', 0.806226], [2481, Timestamp('1994-08-21 06:00:00'), 634, 'JOHN', 14.8, -142.1, 115, 0, 'H4', 'Eastern Pacific', 1.7117240000000002], [2482, Timestamp('1976-07-21 18:00:00'), 312, 'DIANA', 18.6, -138.1, 30, 0, 'TD', 'Eastern Pacific', 1.7], [2483, Timestamp('1998-08-06 06:00:00'), 686, 'ESTELLE', 20.1, -137.5, 30, 1006, 'TD', 'Eastern Pacific', 1.529706], [2484, Timestamp('1976-08-14 18:00:00'), 315, 'GWEN', 22.5, -140.6, 30, 0, 'TD', 'Eastern Pacific', 2.19545], [2485, Timestamp('1984-08-26 12:00:00'), 446, 'LALA', 11.2, -141.3, 30, 0, 'TD', 'Eastern Pacific', 0.8246209999999999], [2486, Timestamp('1976-08-13 18:00:00'), 316, 'HYACINTH', 21.3, -135.8, 35, 0, 'TS', 'Eastern Pacific', 1.878829], [2487, Timestamp('1994-09-20 12:00:00'), 638, 'MIRIAM', 15.3, -135.8, 25, 1009, 'TD', 'Eastern Pacific', 1.204159], [2488, Timestamp('1984-08-26 18:00:00'), 446, 'LALA', 11.4, -142.1, 30, 0, 'TD', 'Eastern Pacific', 0.7071069999999999], [2489, Timestamp('1998-08-06 12:00:00'), 686, 'ESTELLE', 20.4, -139.0, 30, 1006, 'TD', 'Eastern Pacific', 1.315295], [2490, Timestamp('1992-08-30 12:00:00'), 596, 'MADELINE', 15.9, -137.7, 40, 1004, 'TS', 'Eastern Pacific', 1.1], [2491, Timestamp('1976-08-14 00:00:00'), 316, 'HYACINTH', 20.5, -137.5, 30, 0, 'TD', 'Eastern Pacific', 1.5811389999999999], [2492, Timestamp('1976-08-15 00:00:00'), 315, 'GWEN', 21.4, -142.5, 25, 0, 'TD', 'Eastern Pacific', 1.5], [2493, Timestamp('1994-09-20 18:00:00'), 638, 'MIRIAM', 15.2, -137.0, 25, 1010, 'TD', 'Eastern Pacific', 1.0198040000000002], [2494, Timestamp('1984-08-27 00:00:00'), 446, 'LALA', 11.5, -142.8, 30, 0, 'TD', 'Eastern Pacific', 0.6], [2495, Timestamp('1999-08-13 12:00:00'), 698, 'DORA', 15.5, -135.8, 115, 946, 'H4', 'Eastern Pacific', 1.9], [2496, Timestamp('1992-08-30 18:00:00'), 596, 'MADELINE', 15.9, -138.8, 30, 1006, 'TD', 'Eastern Pacific', 1.3038399999999999], [2497, Timestamp('1978-08-26 18:00:00'), 342, 'KRISTY', 21.3, -141.5, 40, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2498, Timestamp('1994-09-21 00:00:00'), 638, 'MIRIAM', 15.0, -138.0, 25, 1010, 'TD', 'Eastern Pacific', 0.7071069999999999], [2499, Timestamp('1999-08-13 18:00:00'), 698, 'DORA', 15.5, -137.7, 110, 950, 'H3', 'Eastern Pacific', 2.0], [2500, Timestamp('1994-09-21 06:00:00'), 638, 'MIRIAM', 14.9, -138.7, 25, 1011, 'TD', 'Eastern Pacific', 0.4], [2501, Timestamp('1980-09-25 00:00:00'), 371, 'KAY', 21.2, -141.2, 75, 0, 'H1', 'Eastern Pacific', 0.781025], [2502, Timestamp('1985-06-30 12:00:00'), 459, 'ENRIQUE', 14.0, -136.0, 25, 0, 'TD', 'Eastern Pacific', 0.905539], [2503, Timestamp('1978-07-03 12:00:00'), 335, 'DANIEL', 17.3, -135.8, 30, 0, 'TD', 'Eastern Pacific', 2.193171], [2504, Timestamp('1992-09-23 12:00:00'), 601, 'ROSLYN', 18.8, -135.9, 80, 978, 'H1', 'Eastern Pacific', 1.236932], [2505, Timestamp('1978-07-17 00:00:00'), 337, 'FICO', 16.5, -135.8, 115, 0, 'H4', 'Eastern Pacific', 1.603122], [2506, Timestamp('1985-06-30 18:00:00'), 459, 'ENRIQUE', 14.1, -136.9, 25, 0, 'TD', 'Eastern Pacific', 0.905539], [2507, Timestamp('1980-09-25 06:00:00'), 371, 'KAY', 21.7, -141.8, 75, 0, 'H1', 'Eastern Pacific', 0.565685], [2508, Timestamp('2000-07-28 06:00:00'), 708, 'DANIEL', 16.8, -136.4, 105, 961, 'H3', 'Eastern Pacific', 1.843909], [2509, Timestamp('1997-08-27 12:00:00'), 672, 'JIMENA', 13.6, -135.9, 115, 948, 'H4', 'Eastern Pacific', 0.8246209999999999], [2510, Timestamp('1985-07-01 00:00:00'), 459, 'ENRIQUE', 14.2, -137.8, 25, 0, 'TD', 'Eastern Pacific', 0.905539], [2511, Timestamp('1980-09-25 12:00:00'), 371, 'KAY', 22.1, -142.2, 70, 0, 'H1', 'Eastern Pacific', 0.5], [2512, Timestamp('1978-07-17 06:00:00'), 337, 'FICO', 16.6, -137.4, 105, 0, 'H3', 'Eastern Pacific', 1.5811389999999999], [2513, Timestamp('2000-07-28 12:00:00'), 708, 'DANIEL', 17.2, -138.2, 100, 963, 'H3', 'Eastern Pacific', 1.4317819999999999], [2514, Timestamp('1997-08-27 18:00:00'), 672, 'JIMENA', 14.4, -136.1, 115, 948, 'H4', 'Eastern Pacific', 0.728011], [2515, Timestamp('1992-09-23 18:00:00'), 601, 'ROSLYN', 18.5, -137.1, 75, 981, 'H1', 'Eastern Pacific', 1.118034], [2516, Timestamp('1985-07-01 06:00:00'), 459, 'ENRIQUE', 14.3, -138.7, 25, 0, 'TD', 'Eastern Pacific', 0.806226], [2517, Timestamp('1978-07-17 12:00:00'), 337, 'FICO', 16.1, -138.9, 90, 0, 'H2', 'Eastern Pacific', 1.6], [2518, Timestamp('1992-09-24 00:00:00'), 601, 'ROSLYN', 18.3, -138.2, 65, 985, 'H1', 'Eastern Pacific', 1.1], [2519, Timestamp('1997-09-15 00:00:00'), 676, 'MARTY', 12.4, -136.0, 35, 1004, 'TS', 'Eastern Pacific', 0.412311], [2520, Timestamp('1980-09-25 18:00:00'), 371, 'KAY', 22.5, -142.5, 70, 0, 'H1', 'Eastern Pacific', 0.5], [2521, Timestamp('2000-08-28 18:00:00'), 715, 'JOHN', 15.4, -138.2, 45, 1003, 'TS', 'Eastern Pacific', 0.42426400000000003], [2522, Timestamp('1992-09-24 06:00:00'), 601, 'ROSLYN', 18.3, -139.3, 65, 990, 'H1', 'Eastern Pacific', 1.2], [2523, Timestamp('2000-08-29 00:00:00'), 715, 'JOHN', 15.7, -138.5, 55, 1001, 'TS', 'Eastern Pacific', 0.565685], [2524, Timestamp('1980-09-26 00:00:00'), 371, 'KAY', 22.9, -142.8, 70, 0, 'H1', 'Eastern Pacific', 0.44721400000000006], [2525, Timestamp('1997-09-15 06:00:00'), 676, 'MARTY', 12.0, -136.1, 35, 1005, 'TS', 'Eastern Pacific', 0.141421], [2526, Timestamp('1978-08-22 18:00:00'), 341, 'JOHN', 15.6, -135.8, 65, 0, 'H1', 'Eastern Pacific', 1.204159], [2527, Timestamp('1985-07-01 12:00:00'), 459, 'ENRIQUE', 14.4, -139.5, 25, 0, 'TD', 'Eastern Pacific', 1.403567], [2528, Timestamp('1992-10-21 06:00:00'), 607, 'YOLANDA', 18.3, -135.7, 30, 1009, 'TD', 'Eastern Pacific', 1.16619], [2529, Timestamp('1980-09-26 06:00:00'), 371, 'KAY', 23.1, -143.2, 65, 0, 'H1', 'Eastern Pacific', 0.22360700000000003], [2530, Timestamp('2000-08-29 06:00:00'), 715, 'JOHN', 16.1, -138.9, 55, 1000, 'TS', 'Eastern Pacific', 0.583095], [2531, Timestamp('1978-08-23 00:00:00'), 341, 'JOHN', 15.5, -137.0, 65, 0, 'H1', 'Eastern Pacific', 1.204159], [2532, Timestamp('1985-07-01 18:00:00'), 459, 'ENRIQUE', 14.5, -140.9, 25, 0, 'TD', 'Eastern Pacific', 1.104536], [2533, Timestamp('1997-09-15 12:00:00'), 676, 'MARTY', 11.9, -136.2, 30, 1006, 'TD', 'Eastern Pacific', 0.141421], [2534, Timestamp('1980-09-26 12:00:00'), 371, 'KAY', 23.3, -143.3, 80, 0, 'H1', 'Eastern Pacific', 0.0], [2535, Timestamp('1997-09-15 18:00:00'), 676, 'MARTY', 11.8, -136.3, 30, 1006, 'TD', 'Eastern Pacific', 0.1], [2536, Timestamp('1985-07-02 00:00:00'), 459, 'ENRIQUE', 14.6, -142.0, 25, 0, 'TD', 'Eastern Pacific', 0.806226], [2537, Timestamp('1992-10-21 12:00:00'), 607, 'YOLANDA', 17.3, -136.3, 30, 1009, 'TD', 'Eastern Pacific', 1.280625], [2538, Timestamp('2000-08-29 12:00:00'), 715, 'JOHN', 16.6, -139.2, 55, 999, 'TS', 'Eastern Pacific', 0.538516], [2539, Timestamp('1978-08-23 12:00:00'), 341, 'JOHN', 15.4, -139.4, 55, 0, 'TS', 'Eastern Pacific', 1.104536], [2540, Timestamp('1980-09-26 18:00:00'), 371, 'KAY', 23.3, -143.3, 65, 0, 'H1', 'Eastern Pacific', 0.0], [2541, Timestamp('1985-07-02 06:00:00'), 459, 'ENRIQUE', 14.7, -142.8, 25, 0, 'TD', 'Eastern Pacific', 1.004988], [2542, Timestamp('2000-08-29 18:00:00'), 715, 'JOHN', 16.8, -139.7, 55, 998, 'TS', 'Eastern Pacific', 0.412311], [2543, Timestamp('1997-09-16 00:00:00'), 676, 'MARTY', 11.8, -136.4, 25, 1006, 'TD', 'Eastern Pacific', 0.22360700000000003], [2544, Timestamp('1980-09-27 00:00:00'), 371, 'KAY', 23.3, -143.3, 65, 0, 'H1', 'Eastern Pacific', 0.0], [2545, Timestamp('1978-08-25 12:00:00'), 342, 'KRISTY', 20.3, -136.5, 65, 0, 'H1', 'Eastern Pacific', 1.029563], [2546, Timestamp('1986-08-02 06:00:00'), 483, 'FRANK', 21.0, -140.5, 30, 0, 'TD', 'Eastern Pacific', 1.5811389999999999], [2547, Timestamp('1985-07-21 06:00:00'), 463, 'IGNACIO', 13.2, -135.5, 35, 0, 'TS', 'Eastern Pacific', 1.004988], [2548, Timestamp('1997-09-16 06:00:00'), 676, 'MARTY', 11.7, -136.6, 25, 1006, 'TD', 'Eastern Pacific', 0.316228], [2549, Timestamp('1992-10-21 18:00:00'), 607, 'YOLANDA', 16.5, -137.3, 25, 1010, 'TD', 'Eastern Pacific', 1.216553], [2550, Timestamp('1986-08-02 12:00:00'), 483, 'FRANK', 21.5, -142.0, 30, 0, 'TD', 'Eastern Pacific', 1.523155], [2551, Timestamp('1985-07-21 12:00:00'), 463, 'IGNACIO', 13.3, -136.5, 40, 0, 'TS', 'Eastern Pacific', 0.9], [2552, Timestamp('2000-08-30 00:00:00'), 715, 'JOHN', 16.9, -140.1, 55, 997, 'TS', 'Eastern Pacific', 0.360555], [2553, Timestamp('1978-08-25 18:00:00'), 342, 'KRISTY', 20.8, -137.4, 60, 0, 'TS', 'Eastern Pacific', 1.077033], [2554, Timestamp('1999-08-10 12:00:00'), 699, 'EUGENE', 13.7, -135.6, 85, 974, 'H2', 'Eastern Pacific', 1.1], [2555, Timestamp('1985-07-21 18:00:00'), 463, 'IGNACIO', 13.3, -137.4, 50, 0, 'TS', 'Eastern Pacific', 1.204159], [2556, Timestamp('1999-08-10 18:00:00'), 699, 'EUGENE', 13.7, -136.7, 85, 974, 'H2', 'Eastern Pacific', 1.4], [2557, Timestamp('2000-08-30 06:00:00'), 715, 'JOHN', 17.1, -140.4, 55, 996, 'TS', 'Eastern Pacific', 0.141421], [2558, Timestamp('1991-10-09 12:00:00'), 578, 'KEVIN', 21.0, -141.0, 65, 984, 'H1', 'Eastern Pacific', 1.063015], [2559, Timestamp('1980-09-23 12:00:00'), 371, 'KAY', 19.2, -135.7, 70, 0, 'H1', 'Eastern Pacific', 1.140175], [2560, Timestamp('2000-08-30 12:00:00'), 715, 'JOHN', 17.2, -140.5, 55, 996, 'TS', 'Eastern Pacific', 0.141421], [2561, Timestamp('1992-10-22 00:00:00'), 607, 'YOLANDA', 16.3, -138.5, 25, 1010, 'TD', 'Eastern Pacific', 1.702939], [2562, Timestamp('1985-07-22 00:00:00'), 463, 'IGNACIO', 13.4, -138.6, 60, 0, 'TS', 'Eastern Pacific', 1.004988], [2563, Timestamp('1993-07-19 00:00:00'), 612, 'DORA', 17.5, -135.6, 45, 1000, 'TS', 'Eastern Pacific', 1.2], [2564, Timestamp('1980-09-23 18:00:00'), 371, 'KAY', 19.5, -136.8, 70, 0, 'H1', 'Eastern Pacific', 1.140175], [2565, Timestamp('1991-10-09 18:00:00'), 578, 'KEVIN', 21.7, -141.8, 60, 988, 'TS', 'Eastern Pacific', 1.3453620000000002], [2566, Timestamp('1999-08-11 00:00:00'), 699, 'EUGENE', 13.7, -138.1, 80, 977, 'H1', 'Eastern Pacific', 1.204159], [2567, Timestamp('1985-07-22 06:00:00'), 463, 'IGNACIO', 13.5, -139.6, 60, 0, 'TS', 'Eastern Pacific', 0.538516], [2568, Timestamp('2000-08-30 18:00:00'), 715, 'JOHN', 17.3, -140.4, 60, 994, 'TS', 'Eastern Pacific', 0.141421], [2569, Timestamp('1980-09-24 00:00:00'), 371, 'KAY', 19.8, -137.9, 75, 0, 'H1', 'Eastern Pacific', 0.921954], [2570, Timestamp('1993-07-19 06:00:00'), 612, 'DORA', 17.5, -136.8, 35, 1005, 'TS', 'Eastern Pacific', 1.3], [2571, Timestamp('1999-08-11 06:00:00'), 699, 'EUGENE', 13.8, -139.3, 75, 979, 'H1', 'Eastern Pacific', 1.104536], [2572, Timestamp('1985-07-22 12:00:00'), 463, 'IGNACIO', 13.7, -140.1, 60, 0, 'TS', 'Eastern Pacific', 0.728011], [2573, Timestamp('1980-09-24 06:00:00'), 371, 'KAY', 20.0, -138.8, 80, 0, 'H1', 'Eastern Pacific', 1.044031], [2574, Timestamp('1991-10-10 00:00:00'), 578, 'KEVIN', 22.7, -142.7, 50, 992, 'TS', 'Eastern Pacific', 0.44721400000000006], [2575, Timestamp('2000-08-31 00:00:00'), 715, 'JOHN', 17.4, -140.3, 55, 996, 'TS', 'Eastern Pacific', 0.360555], [2576, Timestamp('1999-08-11 12:00:00'), 699, 'EUGENE', 13.9, -140.4, 75, 980, 'H1', 'Eastern Pacific', 1.104536], [2577, Timestamp('1993-07-19 12:00:00'), 612, 'DORA', 17.5, -138.1, 30, 1010, 'TD', 'Eastern Pacific', 1.3], [2578, Timestamp('1991-10-10 06:00:00'), 578, 'KEVIN', 23.1, -142.9, 45, 996, 'TS', 'Eastern Pacific', 0.989949], [2579, Timestamp('1980-09-24 12:00:00'), 371, 'KAY', 20.3, -139.8, 80, 0, 'H1', 'Eastern Pacific', 0.44721400000000006], [2580, Timestamp('2001-06-22 00:00:00'), 724, 'BARBARA', 15.6, -136.5, 45, 1001, 'TS', 'Eastern Pacific', 1.392839], [2581, Timestamp('1985-07-22 18:00:00'), 463, 'IGNACIO', 13.9, -140.8, 75, 0, 'H1', 'Eastern Pacific', 0.8544], [2582, Timestamp('1999-08-11 18:00:00'), 699, 'EUGENE', 14.0, -141.5, 75, 980, 'H1', 'Eastern Pacific', 1.0198040000000002], [2583, Timestamp('1981-08-19 12:00:00'), 381, 'GREG', 18.0, -136.2, 40, 0, 'TS', 'Eastern Pacific', 1.204159], [2584, Timestamp('1999-08-12 00:00:00'), 699, 'EUGENE', 14.2, -142.5, 75, 985, 'H1', 'Eastern Pacific', 1.118034], [2585, Timestamp('2001-06-22 06:00:00'), 724, 'BARBARA', 16.1, -137.8, 40, 1003, 'TS', 'Eastern Pacific', 1.2649110000000001], [2586, Timestamp('1981-08-19 18:00:00'), 381, 'GREG', 17.9, -137.4, 40, 0, 'TS', 'Eastern Pacific', 0.608276], [2587, Timestamp('1985-07-23 00:00:00'), 463, 'IGNACIO', 14.2, -141.6, 90, 0, 'H2', 'Eastern Pacific', 0.8246209999999999], [2588, Timestamp('1992-07-22 06:00:00'), 589, 'FRANK', 23.9, -140.6, 45, 1000, 'TS', 'Eastern Pacific', 0.8544], [2589, Timestamp('1993-07-19 18:00:00'), 612, 'DORA', 17.5, -139.4, 30, 1010, 'TD', 'Eastern Pacific', 1.204159], [2590, Timestamp('1981-08-20 00:00:00'), 381, 'GREG', 18.0, -138.0, 50, 0, 'TS', 'Eastern Pacific', 0.7], [2591, Timestamp('1993-07-22 00:00:00'), 613, 'EUGENE', 18.7, -135.3, 75, 981, 'H1', 'Eastern Pacific', 1.5033299999999998], [2592, Timestamp('2000-08-28 06:00:00'), 715, 'JOHN', 14.9, -137.4, 30, 1007, 'TD', 'Eastern Pacific', 0.44721400000000006], [2593, Timestamp('2001-06-22 12:00:00'), 724, 'BARBARA', 16.5, -139.0, 35, 1005, 'TS', 'Eastern Pacific', 1.140175], [2594, Timestamp('1992-09-12 12:00:00'), 598, 'ORLENE', 22.8, -141.5, 30, 1005, 'TD', 'Eastern Pacific', 1.403567], [2595, Timestamp('1985-07-23 06:00:00'), 463, 'IGNACIO', 14.4, -142.4, 100, 0, 'H3', 'Eastern Pacific', 0.608276], [2596, Timestamp('2000-08-28 12:00:00'), 715, 'JOHN', 15.1, -137.8, 35, 1005, 'TS', 'Eastern Pacific', 0.5], [2597, Timestamp('2001-09-09 12:00:00'), 729, 'GIL', 20.7, -137.2, 30, 1008, 'TD', 'Eastern Pacific', 0.3], [2598, Timestamp('1981-08-20 06:00:00'), 381, 'GREG', 18.0, -138.7, 65, 0, 'H1', 'Eastern Pacific', 0.632456], [2599, Timestamp('1993-07-22 06:00:00'), 613, 'EUGENE', 18.8, -136.8, 60, 987, 'TS', 'Eastern Pacific', 1.5], [2600, Timestamp('2001-10-23 06:00:00'), 736, 'NARDA', 16.2, -136.4, 55, 994, 'TS', 'Eastern Pacific', 1.702939], [2601, Timestamp('1993-08-28 12:00:00'), 616, 'GREG', 21.3, -140.6, 25, 1010, 'TD', 'Eastern Pacific', 0.4], [2602, Timestamp('1994-09-10 06:00:00'), 636, 'LANE', 21.3, -141.4, 25, 1010, 'TD', 'Eastern Pacific', 1.5033299999999998], [2603, Timestamp('1981-08-20 12:00:00'), 381, 'GREG', 18.2, -139.3, 65, 0, 'H1', 'Eastern Pacific', 0.583095], [2604, Timestamp('2002-08-22 06:00:00'), 744, 'ALIKA', 10.8, -139.8, 25, 1009, 'TD', 'Eastern Pacific', 1.403567], [2605, Timestamp('1985-07-23 12:00:00'), 463, 'IGNACIO', 14.5, -143.0, 110, 0, 'H3', 'Eastern Pacific', 0.8544], [2606, Timestamp('1981-08-20 18:00:00'), 381, 'GREG', 18.5, -139.8, 50, 0, 'TS', 'Eastern Pacific', 0.44721400000000006], [2607, Timestamp('1993-07-22 12:00:00'), 613, 'EUGENE', 18.8, -138.3, 45, 994, 'TS', 'Eastern Pacific', 1.552417], [2608, Timestamp('2001-10-23 12:00:00'), 736, 'NARDA', 16.3, -138.1, 40, 1002, 'TS', 'Eastern Pacific', 1.5], [2609, Timestamp('1985-09-08 06:00:00'), 471, 'RICK', 14.4, -136.4, 100, 0, 'H3', 'Eastern Pacific', 1.140175], [2610, Timestamp('2002-08-22 12:00:00'), 744, 'ALIKA', 10.7, -141.2, 25, 1009, 'TD', 'Eastern Pacific', 1.5], [2611, Timestamp('1997-07-12 00:00:00'), 666, 'DOLORES', 21.8, -141.2, 30, 1010, 'TD', 'Eastern Pacific', 1.552417], [2612, Timestamp('2003-07-23 06:00:00'), 758, 'FELICIA', 17.6, -136.1, 25, 1010, 'TD', 'Eastern Pacific', 1.5], [2613, Timestamp('1993-08-13 18:00:00'), 615, 'FERNANDA', 17.7, -136.1, 95, 965, 'H2', 'Eastern Pacific', 1.843909], [2614, Timestamp('1986-07-20 18:00:00'), 482, 'ESTELLE', 15.0, -136.3, 115, 0, 'H4', 'Eastern Pacific', 1.9104970000000001], [2615, Timestamp('1981-09-17 18:00:00'), 384, 'JOVA', 18.8, -136.0, 65, 0, 'H1', 'Eastern Pacific', 1.4317819999999999], [2616, Timestamp('2002-08-22 18:00:00'), 744, 'ALIKA', 10.7, -142.7, 30, 1009, 'TD', 'Eastern Pacific', 1.4], [2617, Timestamp('2002-10-24 18:00:00'), 751, 'LOWELL', 12.3, -135.5, 30, 1009, 'TD', 'Eastern Pacific', 1.315295], [2618, Timestamp('1993-08-14 00:00:00'), 615, 'FERNANDA', 18.1, -137.9, 90, 970, 'H2', 'Eastern Pacific', 1.7117240000000002], [2619, Timestamp('2003-07-23 12:00:00'), 758, 'FELICIA', 17.6, -137.6, 20, 1010, 'L', 'Eastern Pacific', 1.403567], [2620, Timestamp('1997-07-12 06:00:00'), 666, 'DOLORES', 22.2, -142.7, 30, 1010, 'TD', 'Eastern Pacific', 1.486607], [2621, Timestamp('1981-09-18 00:00:00'), 384, 'JOVA', 19.4, -137.3, 65, 0, 'H1', 'Eastern Pacific', 1.476482], [2622, Timestamp('1986-07-21 00:00:00'), 482, 'ESTELLE', 15.2, -138.2, 115, 0, 'H4', 'Eastern Pacific', 2.109502], [2623, Timestamp('2002-10-25 00:00:00'), 751, 'LOWELL', 12.5, -136.8, 30, 1009, 'TD', 'Eastern Pacific', 0.9], [2624, Timestamp('2003-07-23 18:00:00'), 758, 'FELICIA', 17.7, -139.0, 20, 1010, 'L', 'Eastern Pacific', 1.5033299999999998], [2625, Timestamp('1986-08-03 12:00:00'), 484, 'GEORGETTE', 8.9, -136.5, 35, 0, 'TS', 'Eastern Pacific', 1.6], [2626, Timestamp('1997-08-10 00:00:00'), 669, 'GUILLERMO', 22.6, -140.4, 40, 1005, 'TS', 'Eastern Pacific', 1.063015], [2627, Timestamp('2003-08-12 06:00:00'), 759, 'GUILLERMO', 16.3, -136.5, 30, 1007, 'TD', 'Eastern Pacific', 1.7], [2628, Timestamp('1986-08-03 18:00:00'), 484, 'GEORGETTE', 8.9, -138.1, 30, 0, 'TD', 'Eastern Pacific', 1.9104970000000001], [2629, Timestamp('1993-08-26 12:00:00'), 616, 'GREG', 19.7, -135.9, 50, 998, 'TS', 'Eastern Pacific', 0.632456], [2630, Timestamp('2002-10-25 06:00:00'), 751, 'LOWELL', 12.5, -137.7, 30, 1009, 'TD', 'Eastern Pacific', 1.1], [2631, Timestamp('1981-09-18 06:00:00'), 384, 'JOVA', 20.1, -138.6, 65, 0, 'H1', 'Eastern Pacific', 1.456022], [2632, Timestamp('1997-08-10 06:00:00'), 669, 'GUILLERMO', 23.3, -141.2, 35, 1006, 'TS', 'Eastern Pacific', 1.0816649999999999], [2633, Timestamp('2002-10-25 12:00:00'), 751, 'LOWELL', 12.5, -138.8, 30, 1009, 'TD', 'Eastern Pacific', 0.905539], [2634, Timestamp('2003-08-12 12:00:00'), 759, 'GUILLERMO', 16.3, -138.2, 30, 1007, 'TD', 'Eastern Pacific', 1.6], [2635, Timestamp('1986-08-04 00:00:00'), 484, 'GEORGETTE', 8.7, -140.0, 30, 0, 'TD', 'Eastern Pacific', 2.6], [2636, Timestamp('1982-07-15 18:00:00'), 393, 'DANIEL', 18.1, -136.0, 50, 0, 'TS', 'Eastern Pacific', 1.4], [2637, Timestamp('1998-08-07 06:00:00'), 686, 'ESTELLE', 21.0, -142.9, 30, 1006, 'TD', 'Eastern Pacific', 1.140175], [2638, Timestamp('2002-10-25 18:00:00'), 751, 'LOWELL', 12.6, -139.7, 30, 1009, 'TD', 'Eastern Pacific', 0.806226], [2639, Timestamp('2003-08-29 12:00:00'), 762, 'JIMENA', 16.6, -135.5, 65, 987, 'H1', 'Eastern Pacific', 1.4317819999999999], [2640, Timestamp('1982-07-16 00:00:00'), 393, 'DANIEL', 18.1, -137.4, 45, 0, 'TS', 'Eastern Pacific', 1.4], [2641, Timestamp('1986-09-21 00:00:00'), 492, 'ORLENE', 12.0, -138.7, 25, 0, 'TD', 'Eastern Pacific', 0.44721400000000006], [2642, Timestamp('2004-09-02 18:00:00'), 775, 'GEORGETTE', 22.3, -141.7, 15, 1011, 'L', 'Eastern Pacific', 1.523155], [2643, Timestamp('2002-10-26 00:00:00'), 751, 'LOWELL', 12.7, -140.5, 30, 1009, 'TD', 'Eastern Pacific', 0.7071069999999999], [2644, Timestamp('1982-07-16 06:00:00'), 393, 'DANIEL', 18.1, -138.8, 40, 0, 'TS', 'Eastern Pacific', 1.2], [2645, Timestamp('1993-08-26 18:00:00'), 616, 'GREG', 19.9, -136.5, 45, 999, 'TS', 'Eastern Pacific', 0.44721400000000006], [2646, Timestamp('1986-09-21 06:00:00'), 492, 'ORLENE', 12.4, -138.9, 30, 0, 'TD', 'Eastern Pacific', 0.583095], [2647, Timestamp('2006-07-17 00:00:00'), 797, 'BUD', 23.5, -141.3, 20, 1013, 'L', 'Eastern Pacific', 1.802776], [2648, Timestamp('1982-07-29 18:00:00'), 396, 'GILMA', 15.7, -135.8, 110, 0, 'H3', 'Eastern Pacific', 1.7262680000000001], [2649, Timestamp('1993-08-27 00:00:00'), 616, 'GREG', 20.1, -136.9, 45, 1000, 'TS', 'Eastern Pacific', 0.7071069999999999], [2650, Timestamp('2002-10-26 06:00:00'), 751, 'LOWELL', 12.8, -141.2, 30, 1009, 'TD', 'Eastern Pacific', 0.8246209999999999], [2651, Timestamp('2003-08-29 18:00:00'), 762, 'JIMENA', 16.9, -136.9, 75, 981, 'H1', 'Eastern Pacific', 1.4317819999999999], [2652, Timestamp('1986-09-21 12:00:00'), 492, 'ORLENE', 12.9, -139.2, 35, 0, 'TS', 'Eastern Pacific', 0.42426400000000003], [2653, Timestamp('2003-08-30 00:00:00'), 762, 'JIMENA', 17.2, -138.3, 85, 973, 'H2', 'Eastern Pacific', 1.5033299999999998], [2654, Timestamp('2006-08-23 18:00:00'), 803, 'HECTOR', 22.9, -140.8, 25, 1009, 'L', 'Eastern Pacific', 1.216553], [2655, Timestamp('1993-08-27 06:00:00'), 616, 'GREG', 20.6, -137.4, 45, 1001, 'TS', 'Eastern Pacific', 0.7615770000000001], [2656, Timestamp('1982-07-30 00:00:00'), 396, 'GILMA', 16.0, -137.5, 105, 0, 'H3', 'Eastern Pacific', 1.7720049999999998], [2657, Timestamp('2002-10-26 12:00:00'), 751, 'LOWELL', 13.0, -142.0, 30, 1009, 'TD', 'Eastern Pacific', 1.118034], [2658, Timestamp('1986-09-21 18:00:00'), 492, 'ORLENE', 13.2, -139.5, 35, 0, 'TS', 'Eastern Pacific', 0.640312], [2659, Timestamp('2006-08-24 00:00:00'), 803, 'HECTOR', 23.1, -142.0, 25, 1009, 'L', 'Eastern Pacific', 1.513275], [2660, Timestamp('1993-08-27 12:00:00'), 616, 'GREG', 20.9, -138.1, 45, 1002, 'TS', 'Eastern Pacific', 0.8246209999999999], [2661, Timestamp('2002-10-26 18:00:00'), 751, 'LOWELL', 12.5, -143.0, 30, 1009, 'TD', 'Eastern Pacific', 0.728011], [2662, Timestamp('1986-09-22 00:00:00'), 492, 'ORLENE', 13.6, -140.0, 65, 0, 'H1', 'Eastern Pacific', 0.67082], [2663, Timestamp('2004-07-31 06:00:00'), 772, 'DARBY', 18.8, -136.0, 35, 1002, 'TS', 'Eastern Pacific', 1.3], [2664, Timestamp('1982-07-30 06:00:00'), 396, 'GILMA', 16.5, -139.2, 95, 0, 'H2', 'Eastern Pacific', 1.7262680000000001], [2665, Timestamp('1994-06-22 18:00:00'), 624, 'ALETTA', 18.2, -135.4, 25, 1009, 'TD', 'Eastern Pacific', 1.7117240000000002], [2666, Timestamp('2003-05-25 12:00:00'), 753, 'ANDRES', 14.3, -136.2, 25, 1009, 'L', 'Eastern Pacific', 1.612452], [2667, Timestamp('1954-09-06 18:00:00'), 38, 'NOTNAMED', 21.3, -136.5, 45, 0, 'TS', 'Eastern Pacific', 0.8485280000000001], [2668, Timestamp('1986-09-22 06:00:00'), 492, 'ORLENE', 14.2, -140.3, 65, 0, 'H1', 'Eastern Pacific', 0.6], [2669, Timestamp('1994-06-23 00:00:00'), 624, 'ALETTA', 18.4, -137.1, 25, 1009, 'TD', 'Eastern Pacific', 1.204159], [2670, Timestamp('2004-07-31 12:00:00'), 772, 'DARBY', 18.8, -137.3, 30, 1005, 'TD', 'Eastern Pacific', 1.5033299999999998], [2671, Timestamp('1982-08-02 18:00:00'), 397, 'HECTOR', 20.6, -136.1, 25, 0, 'TD', 'Eastern Pacific', 0.905539], [2672, Timestamp('2003-05-25 18:00:00'), 753, 'ANDRES', 14.1, -137.8, 25, 1009, 'L', 'Eastern Pacific', 1.4], [2673, Timestamp('1954-09-07 00:00:00'), 38, 'NOTNAMED', 21.9, -137.1, 45, 0, 'TS', 'Eastern Pacific', 0.921954], [2674, Timestamp('1994-07-21 12:00:00'), 629, 'FABIO', 15.8, -136.0, 25, 1008, 'TD', 'Eastern Pacific', 1.513275], [2675, Timestamp('1986-09-22 12:00:00'), 492, 'ORLENE', 14.8, -140.3, 70, 0, 'H1', 'Eastern Pacific', 0.608276], [2676, Timestamp('2004-07-31 18:00:00'), 772, 'DARBY', 18.9, -138.8, 25, 1007, 'TD', 'Eastern Pacific', 1.603122], [2677, Timestamp('1982-08-03 00:00:00'), 397, 'HECTOR', 20.7, -137.0, 25, 0, 'TD', 'Eastern Pacific', 1.612452], [2678, Timestamp('2003-05-26 00:00:00'), 753, 'ANDRES', 14.1, -139.2, 25, 1009, 'L', 'Eastern Pacific', 1.334166], [2679, Timestamp('1994-07-21 18:00:00'), 629, 'FABIO', 16.0, -137.5, 25, 1008, 'TD', 'Eastern Pacific', 1.612452], [2680, Timestamp('1987-07-25 06:00:00'), 500, 'FERNANDA', 12.3, -136.4, 35, 0, 'TS', 'Eastern Pacific', 1.403567], [2681, Timestamp('1954-09-07 06:00:00'), 38, 'NOTNAMED', 22.5, -137.8, 45, 0, 'TS', 'Eastern Pacific', 1.0], [2682, Timestamp('2004-09-19 12:00:00'), 777, 'ISIS', 16.2, -136.2, 30, 1009, 'L', 'Eastern Pacific', 0.5099020000000001], [2683, Timestamp('1994-07-22 00:00:00'), 629, 'FABIO', 16.2, -139.1, 25, 1008, 'TD', 'Eastern Pacific', 1.824829], [2684, Timestamp('2004-09-19 18:00:00'), 777, 'ISIS', 16.1, -136.7, 30, 1009, 'L', 'Eastern Pacific', 0.7071069999999999], [2685, Timestamp('1987-07-25 12:00:00'), 500, 'FERNANDA', 12.4, -137.8, 45, 0, 'TS', 'Eastern Pacific', 1.104536], [2686, Timestamp('1994-08-30 18:00:00'), 635, 'KRISTY', 16.1, -136.6, 40, 1002, 'TS', 'Eastern Pacific', 1.6], [2687, Timestamp('1982-08-14 00:00:00'), 401, 'LANE', 17.3, -135.9, 25, 0, 'TD', 'Eastern Pacific', 0.984886], [2688, Timestamp('1954-09-07 12:00:00'), 38, 'NOTNAMED', 23.1, -138.6, 45, 0, 'TS', 'Eastern Pacific', 0.8246209999999999], [2689, Timestamp('2003-05-26 06:00:00'), 753, 'ANDRES', 14.4, -140.5, 20, 1010, 'L', 'Eastern Pacific', 1.4317819999999999], [2690, Timestamp('2004-09-20 00:00:00'), 777, 'ISIS', 16.0, -137.4, 30, 1009, 'L', 'Eastern Pacific', 0.8], [2691, Timestamp('1994-08-31 00:00:00'), 635, 'KRISTY', 16.1, -138.2, 50, 996, 'TS', 'Eastern Pacific', 1.603122], [2692, Timestamp('1987-07-25 18:00:00'), 500, 'FERNANDA', 12.5, -138.9, 45, 0, 'TS', 'Eastern Pacific', 0.905539], [2693, Timestamp('1954-09-07 18:00:00'), 38, 'NOTNAMED', 23.3, -139.4, 45, 0, 'TS', 'Eastern Pacific', 0.9], [2694, Timestamp('2004-09-20 06:00:00'), 777, 'ISIS', 16.0, -138.2, 30, 1009, 'L', 'Eastern Pacific', 0.8], [2695, Timestamp('1995-07-15 18:00:00'), 645, 'BARBARA', 15.7, -135.6, 65, 988, 'H1', 'Eastern Pacific', 1.1], [2696, Timestamp('2004-08-20 06:00:00'), 773, 'ESTELLE', 13.6, -136.3, 35, 1006, 'TS', 'Eastern Pacific', 1.044031], [2697, Timestamp('1982-08-14 06:00:00'), 401, 'LANE', 17.7, -136.8, 25, 0, 'TD', 'Eastern Pacific', 0.9486829999999999], [2698, Timestamp('1957-08-08 00:00:00'), 63, 'NOTNAMED', 21.1, -136.3, 60, 994, 'TS', 'Eastern Pacific', 1.392839], [2699, Timestamp('1987-07-26 00:00:00'), 500, 'FERNANDA', 12.6, -139.8, 55, 0, 'TS', 'Eastern Pacific', 0.905539], [2700, Timestamp('1995-07-16 00:00:00'), 645, 'BARBARA', 15.7, -136.7, 55, 995, 'TS', 'Eastern Pacific', 1.004988], [2701, Timestamp('2004-09-20 12:00:00'), 777, 'ISIS', 16.0, -139.0, 30, 1010, 'L', 'Eastern Pacific', 0.5], [2702, Timestamp('2004-08-20 12:00:00'), 773, 'ESTELLE', 13.9, -137.3, 35, 1005, 'TS', 'Eastern Pacific', 1.004988], [2703, Timestamp('1982-08-14 12:00:00'), 401, 'LANE', 18.0, -137.7, 25, 0, 'TD', 'Eastern Pacific', 0.67082], [2704, Timestamp('1957-08-08 06:00:00'), 63, 'NOTNAMED', 21.6, -137.6, 50, 0, 'TS', 'Eastern Pacific', 1.392839], [2705, Timestamp('2004-09-20 18:00:00'), 777, 'ISIS', 16.0, -139.5, 30, 1011, 'L', 'Eastern Pacific', 0.5], [2706, Timestamp('2004-08-20 18:00:00'), 773, 'ESTELLE', 14.0, -138.3, 45, 1000, 'TS', 'Eastern Pacific', 1.044031], [2707, Timestamp('1995-07-16 06:00:00'), 645, 'BARBARA', 15.8, -137.7, 45, 1000, 'TS', 'Eastern Pacific', 0.905539], [2708, Timestamp('1982-08-14 18:00:00'), 401, 'LANE', 18.3, -138.3, 25, 0, 'TD', 'Eastern Pacific', 1.360147], [2709, Timestamp('1987-07-26 06:00:00'), 500, 'FERNANDA', 12.7, -140.7, 55, 0, 'TS', 'Eastern Pacific', 1.004988], [2710, Timestamp('2005-08-16 06:00:00'), 786, 'FERNANDA', 17.1, -135.8, 20, 1008, 'L', 'Eastern Pacific', 1.204159], [2711, Timestamp('1957-08-08 12:00:00'), 63, 'NOTNAMED', 22.1, -138.9, 50, 0, 'TS', 'Eastern Pacific', 1.1704700000000001], [2712, Timestamp('1982-09-04 00:00:00'), 402, 'MIRIAM', 16.3, -136.7, 75, 0, 'H1', 'Eastern Pacific', 2.118962], [2713, Timestamp('2004-08-21 00:00:00'), 773, 'ESTELLE', 14.3, -139.3, 55, 994, 'TS', 'Eastern Pacific', 0.8544], [2714, Timestamp('2005-08-16 12:00:00'), 786, 'FERNANDA', 17.0, -137.0, 20, 1008, 'L', 'Eastern Pacific', 1.0198040000000002], [2715, Timestamp('1987-07-26 12:00:00'), 500, 'FERNANDA', 12.8, -141.7, 55, 0, 'TS', 'Eastern Pacific', 0.806226], [2716, Timestamp('1995-07-16 12:00:00'), 645, 'BARBARA', 15.9, -138.6, 40, 1005, 'TS', 'Eastern Pacific', 0.905539], [2717, Timestamp('2004-08-21 06:00:00'), 773, 'ESTELLE', 14.6, -140.1, 55, 992, 'TS', 'Eastern Pacific', 0.806226], [2718, Timestamp('1961-10-03 00:00:00'), 116, 'PAULINE', 21.3, -137.9, 45, 0, 'TS', 'Eastern Pacific', 1.236932], [2719, Timestamp('2005-08-16 18:00:00'), 786, 'FERNANDA', 16.8, -138.0, 20, 1008, 'L', 'Eastern Pacific', 1.0198040000000002], [2720, Timestamp('1987-07-26 18:00:00'), 500, 'FERNANDA', 12.9, -142.5, 55, 0, 'TS', 'Eastern Pacific', 0.806226], [2721, Timestamp('2004-08-21 12:00:00'), 773, 'ESTELLE', 15.0, -140.8, 60, 989, 'TS', 'Eastern Pacific', 0.565685], [2722, Timestamp('1982-09-04 06:00:00'), 402, 'MIRIAM', 17.0, -138.7, 70, 0, 'H1', 'Eastern Pacific', 2.154066], [2723, Timestamp('1961-10-03 06:00:00'), 116, 'PAULINE', 21.6, -139.1, 45, 0, 'TS', 'Eastern Pacific', 1.208305], [2724, Timestamp('1987-08-19 06:00:00'), 504, 'JOVA', 15.1, -136.3, 75, 0, 'H1', 'Eastern Pacific', 1.2], [2725, Timestamp('2005-08-17 00:00:00'), 786, 'FERNANDA', 16.6, -139.0, 20, 1010, 'L', 'Eastern Pacific', 1.004988], [2726, Timestamp('1995-07-16 18:00:00'), 645, 'BARBARA', 16.0, -139.5, 40, 1005, 'TS', 'Eastern Pacific', 1.044031], [2727, Timestamp('1982-09-18 06:00:00'), 405, 'EMA', 19.1, -140.7, 35, 0, 'TS', 'Eastern Pacific', 0.565685], [2728, Timestamp('1963-09-14 06:00:00'), 134, 'IRAH', 21.2, -135.2, 45, 0, 'TS', 'Eastern Pacific', 1.702939], [2729, Timestamp('2005-09-16 18:00:00'), 790, 'JOVA', 12.4, -135.7, 75, 979, 'H1', 'Eastern Pacific', 0.7071069999999999], [2730, Timestamp('1987-08-19 12:00:00'), 504, 'JOVA', 15.1, -137.5, 75, 0, 'H1', 'Eastern Pacific', 1.4], [2731, Timestamp('1997-07-10 18:00:00'), 666, 'DOLORES', 18.9, -135.5, 40, 1001, 'TS', 'Eastern Pacific', 1.456022], [2732, Timestamp('2005-08-17 06:00:00'), 786, 'FERNANDA', 16.5, -140.0, 20, 1010, 'L', 'Eastern Pacific', 1.004988], [2733, Timestamp('1987-08-19 18:00:00'), 504, 'JOVA', 15.1, -138.9, 65, 0, 'H1', 'Eastern Pacific', 1.603122], [2734, Timestamp('1963-09-15 00:00:00'), 134, 'IRAH', 21.1, -139.0, 45, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2735, Timestamp('1997-07-11 00:00:00'), 666, 'DOLORES', 19.3, -136.9, 35, 1005, 'TS', 'Eastern Pacific', 1.140175], [2736, Timestamp('2005-09-17 00:00:00'), 790, 'JOVA', 12.3, -136.4, 80, 977, 'H1', 'Eastern Pacific', 0.806226], [2737, Timestamp('1982-09-18 12:00:00'), 405, 'EMA', 19.5, -140.3, 35, 0, 'TS', 'Eastern Pacific', 0.583095], [2738, Timestamp('2005-09-23 00:00:00'), 791, 'KENNETH', 15.9, -136.0, 55, 994, 'TS', 'Eastern Pacific', 0.412311], [2739, Timestamp('1997-07-11 06:00:00'), 666, 'DOLORES', 19.6, -138.0, 30, 1007, 'TD', 'Eastern Pacific', 1.0816649999999999], [2740, Timestamp('2005-09-17 06:00:00'), 790, 'JOVA', 12.2, -137.2, 85, 974, 'H2', 'Eastern Pacific', 0.9], [2741, Timestamp('1987-08-20 00:00:00'), 504, 'JOVA', 15.0, -140.5, 45, 0, 'TS', 'Eastern Pacific', 1.5], [2742, Timestamp('1963-09-15 06:00:00'), 134, 'IRAH', 21.3, -140.0, 25, 0, 'TD', 'Eastern Pacific', 1.0198040000000002], [2743, Timestamp('1982-09-18 18:00:00'), 405, 'EMA', 20.0, -140.0, 30, 0, 'TD', 'Eastern Pacific', 0.806226], [2744, Timestamp('1997-07-11 12:00:00'), 666, 'DOLORES', 20.2, -138.9, 30, 1008, 'TD', 'Eastern Pacific', 1.360147], [2745, Timestamp('2005-09-23 06:00:00'), 791, 'KENNETH', 16.0, -136.4, 55, 994, 'TS', 'Eastern Pacific', 0.4], [2746, Timestamp('2005-09-17 12:00:00'), 790, 'JOVA', 12.2, -138.1, 85, 973, 'H2', 'Eastern Pacific', 0.583095], [2747, Timestamp('1987-08-20 06:00:00'), 504, 'JOVA', 15.0, -142.0, 40, 0, 'TS', 'Eastern Pacific', 1.8], [2748, Timestamp('1966-08-06 18:00:00'), 153, 'BLANCA', 21.1, -135.3, 45, 0, 'TS', 'Eastern Pacific', 1.403567], [2749, Timestamp('1997-07-20 18:00:00'), 668, 'FELICIA', 16.9, -135.6, 95, 965, 'H2', 'Eastern Pacific', 1.612452], [2750, Timestamp('2005-09-23 12:00:00'), 791, 'KENNETH', 16.0, -136.8, 55, 994, 'TS', 'Eastern Pacific', 0.4], [2751, Timestamp('1983-07-31 12:00:00'), 419, 'GIL', 20.8, -136.4, 30, 0, 'TD', 'Eastern Pacific', 1.513275], [2752, Timestamp('2005-09-17 18:00:00'), 790, 'JOVA', 12.5, -138.6, 85, 973, 'H2', 'Eastern Pacific', 0.806226], [2753, Timestamp('1988-08-01 18:00:00'), 520, 'FABIO', 12.9, -136.4, 75, 974, 'H1', 'Eastern Pacific', 1.104536], [2754, Timestamp('1997-07-21 00:00:00'), 668, 'FELICIA', 17.1, -137.2, 90, 972, 'H2', 'Eastern Pacific', 1.7117240000000002], [2755, Timestamp('1966-08-07 00:00:00'), 153, 'BLANCA', 21.2, -136.7, 45, 0, 'TS', 'Eastern Pacific', 1.4317819999999999], [2756, Timestamp('1983-07-31 18:00:00'), 419, 'GIL', 21.0, -137.9, 30, 0, 'TD', 'Eastern Pacific', 1.603122], [2757, Timestamp('2005-09-23 18:00:00'), 791, 'KENNETH', 16.0, -137.2, 50, 997, 'TS', 'Eastern Pacific', 0.5], [2758, Timestamp('2005-09-18 00:00:00'), 790, 'JOVA', 12.9, -139.3, 85, 973, 'H2', 'Eastern Pacific', 0.583095], [2759, Timestamp('1997-07-21 06:00:00'), 668, 'FELICIA', 17.3, -138.9, 70, 980, 'H1', 'Eastern Pacific', 1.9026299999999998], [2760, Timestamp('1988-08-02 00:00:00'), 520, 'FABIO', 13.0, -137.5, 80, 972, 'H1', 'Eastern Pacific', 1.0], [2761, Timestamp('1997-08-08 12:00:00'), 669, 'GUILLERMO', 18.9, -136.1, 55, 993, 'TS', 'Eastern Pacific', 1.0816649999999999], [2762, Timestamp('2005-09-24 00:00:00'), 791, 'KENNETH', 16.0, -137.7, 50, 997, 'TS', 'Eastern Pacific', 0.4], [2763, Timestamp('2005-09-18 06:00:00'), 790, 'JOVA', 13.2, -139.8, 85, 973, 'H2', 'Eastern Pacific', 0.5], [2764, Timestamp('1983-08-01 00:00:00'), 419, 'GIL', 20.9, -139.5, 30, 0, 'TD', 'Eastern Pacific', 1.5033299999999998], [2765, Timestamp('1966-08-07 06:00:00'), 153, 'BLANCA', 21.5, -138.1, 25, 0, 'TD', 'Eastern Pacific', 1.4317819999999999], [2766, Timestamp('1997-08-08 18:00:00'), 669, 'GUILLERMO', 19.5, -137.0, 55, 995, 'TS', 'Eastern Pacific', 1.029563], [2767, Timestamp('2005-09-24 06:00:00'), 791, 'KENNETH', 16.0, -138.1, 45, 1000, 'TS', 'Eastern Pacific', 0.316228], [2768, Timestamp('1988-08-02 06:00:00'), 520, 'FABIO', 13.0, -138.5, 85, 970, 'H2', 'Eastern Pacific', 1.118034], [2769, Timestamp('2005-09-18 12:00:00'), 790, 'JOVA', 13.5, -140.2, 90, 970, 'H2', 'Eastern Pacific', 0.5], [2770, Timestamp('1997-08-09 00:00:00'), 669, 'GUILLERMO', 20.0, -137.9, 50, 997, 'TS', 'Eastern Pacific', 0.989949], [2771, Timestamp('1983-09-27 00:00:00'), 426, 'NARDA', 16.9, -136.0, 30, 0, 'TD', 'Eastern Pacific', 1.513275], [2772, Timestamp('2005-09-24 12:00:00'), 791, 'KENNETH', 16.1, -138.4, 50, 996, 'TS', 'Eastern Pacific', 0.5099020000000001], [2773, Timestamp('1988-08-02 12:00:00'), 520, 'FABIO', 13.2, -139.6, 90, 966, 'H2', 'Eastern Pacific', 1.118034], [2774, Timestamp('1997-08-09 06:00:00'), 669, 'GUILLERMO', 20.7, -138.6, 45, 998, 'TS', 'Eastern Pacific', 0.921954], [2775, Timestamp('2005-09-24 18:00:00'), 791, 'KENNETH', 16.2, -138.9, 55, 994, 'TS', 'Eastern Pacific', 0.44721400000000006], [2776, Timestamp('2005-09-18 18:00:00'), 790, 'JOVA', 13.8, -140.6, 90, 970, 'H2', 'Eastern Pacific', 0.640312], [2777, Timestamp('1983-09-27 06:00:00'), 426, 'NARDA', 17.1, -137.5, 30, 0, 'TD', 'Eastern Pacific', 1.513275], [2778, Timestamp('1966-08-07 12:00:00'), 153, 'BLANCA', 22.1, -139.4, 25, 0, 'TD', 'Eastern Pacific', 1.526434], [2779, Timestamp('1997-08-28 00:00:00'), 672, 'JIMENA', 15.1, -136.3, 115, 948, 'H4', 'Eastern Pacific', 1.1704700000000001], [2780, Timestamp('1988-08-02 18:00:00'), 520, 'FABIO', 13.4, -140.7, 95, 960, 'H2', 'Eastern Pacific', 1.044031], [2781, Timestamp('2005-09-25 00:00:00'), 791, 'KENNETH', 16.4, -139.3, 65, 990, 'H1', 'Eastern Pacific', 0.141421], [2782, Timestamp('1968-08-13 06:00:00'), 187, 'FERNANDA', 21.2, -138.9, 45, 0, 'TS', 'Eastern Pacific', 0.8944270000000001], [2783, Timestamp('1997-08-28 06:00:00'), 672, 'JIMENA', 16.2, -136.7, 115, 948, 'H4', 'Eastern Pacific', 1.2649110000000001], [2784, Timestamp('1983-09-27 12:00:00'), 426, 'NARDA', 17.3, -139.0, 30, 0, 'TD', 'Eastern Pacific', 1.811077], [2785, Timestamp('2005-09-19 00:00:00'), 790, 'JOVA', 14.2, -141.1, 90, 969, 'H2', 'Eastern Pacific', 0.781025], [2786, Timestamp('1988-08-03 00:00:00'), 520, 'FABIO', 13.7, -141.7, 105, 950, 'H3', 'Eastern Pacific', 1.118034], [2787, Timestamp('2005-09-25 06:00:00'), 791, 'KENNETH', 16.5, -139.4, 65, 987, 'H1', 'Eastern Pacific', 0.282843], [2788, Timestamp('1997-08-28 12:00:00'), 672, 'JIMENA', 17.4, -137.1, 115, 948, 'H4', 'Eastern Pacific', 1.341641], [2789, Timestamp('1968-08-13 12:00:00'), 187, 'FERNANDA', 21.6, -139.7, 25, 0, 'TD', 'Eastern Pacific', 0.7615770000000001], [2790, Timestamp('1983-10-13 18:00:00'), 429, 'RAYMOND', 16.1, -136.6, 95, 0, 'H2', 'Eastern Pacific', 1.486607], [2791, Timestamp('2005-09-19 06:00:00'), 790, 'JOVA', 14.7, -141.7, 95, 965, 'H2', 'Eastern Pacific', 0.7071069999999999], [2792, Timestamp('1988-08-03 06:00:00'), 520, 'FABIO', 14.2, -142.7, 115, 944, 'H4', 'Eastern Pacific', 1.208305], [2793, Timestamp('2005-09-25 12:00:00'), 791, 'KENNETH', 16.3, -139.6, 65, 987, 'H1', 'Eastern Pacific', 0.412311], [2794, Timestamp('1997-08-28 18:00:00'), 672, 'JIMENA', 18.6, -137.7, 115, 948, 'H4', 'Eastern Pacific', 1.118034], [2795, Timestamp('1968-10-28 06:00:00'), 200, 'TARA', 21.5, -135.9, 25, 0, 'TD', 'Eastern Pacific', 0.984886], [2796, Timestamp('2005-09-19 12:00:00'), 790, 'JOVA', 15.2, -142.2, 100, 960, 'H3', 'Eastern Pacific', 0.640312], [2797, Timestamp('1988-09-21 00:00:00'), 527, 'WILA', 12.2, -142.0, 25, 0, 'TD', 'Eastern Pacific', 1.0198040000000002], [2798, Timestamp('1983-10-14 00:00:00'), 429, 'RAYMOND', 16.6, -138.0, 110, 0, 'H3', 'Eastern Pacific', 1.4142139999999999], [2799, Timestamp('2005-09-25 18:00:00'), 791, 'KENNETH', 15.9, -139.7, 65, 987, 'H1', 'Eastern Pacific', 0.282843], [2800, Timestamp('1976-08-14 06:00:00'), 315, 'GWEN', 24.0, -136.0, 30, 0, 'TD', 'Eastern Pacific', 3.0413810000000003], [2801, Timestamp('2005-09-26 06:00:00'), 791, 'KENNETH', 15.3, -140.1, 65, 988, 'H1', 'Eastern Pacific', 0.5099020000000001], [2802, Timestamp('2005-09-26 00:00:00'), 791, 'KENNETH', 15.7, -139.9, 65, 987, 'H1', 'Eastern Pacific', 0.44721400000000006], [2803, Timestamp('1989-07-16 12:00:00'), 533, 'DALILIA', 13.9, -135.8, 80, 978, 'H1', 'Eastern Pacific', 2.10238], [2804, Timestamp('1983-10-14 06:00:00'), 429, 'RAYMOND', 16.8, -139.4, 110, 0, 'H3', 'Eastern Pacific', 1.627882], [2805, Timestamp('2005-09-26 12:00:00'), 791, 'KENNETH', 14.8, -140.2, 60, 995, 'TS', 'Eastern Pacific', 0.5], [2806, Timestamp('2006-07-24 00:00:00'), 799, 'DANIEL', 15.5, -137.9, 95, 965, 'H2', 'Eastern Pacific', 1.2649110000000001], [2807, Timestamp('1976-08-14 12:00:00'), 315, 'GWEN', 23.5, -139.0, 30, 0, 'TD', 'Eastern Pacific', 1.886796], [2808, Timestamp('1989-07-16 18:00:00'), 533, 'DALILIA', 14.0, -137.9, 80, 977, 'H1', 'Eastern Pacific', 1.9026299999999998], [2809, Timestamp('2006-07-24 06:00:00'), 799, 'DANIEL', 15.9, -139.1, 85, 975, 'H2', 'Eastern Pacific', 1.334166], [2810, Timestamp('2005-09-26 18:00:00'), 791, 'KENNETH', 14.4, -140.5, 55, 1000, 'TS', 'Eastern Pacific', 0.44721400000000006], [2811, Timestamp('1984-07-02 18:00:00'), 437, 'DOUGLAS', 17.8, -135.4, 45, 0, 'TS', 'Eastern Pacific', 1.1], [2812, Timestamp('1978-08-26 00:00:00'), 342, 'KRISTY', 21.2, -138.4, 55, 0, 'TS', 'Eastern Pacific', 0.7071069999999999], [2813, Timestamp('1989-07-17 00:00:00'), 533, 'DALILIA', 14.1, -139.8, 75, 977, 'H1', 'Eastern Pacific', 2.022375], [2814, Timestamp('1984-07-03 00:00:00'), 437, 'DOUGLAS', 17.8, -136.5, 35, 0, 'TS', 'Eastern Pacific', 1.1], [2815, Timestamp('2008-07-05 18:00:00'), 827, 'BORIS', 16.0, -136.2, 20, 1007, 'L', 'Eastern Pacific', 1.004988], [2816, Timestamp('2005-09-27 00:00:00'), 791, 'KENNETH', 14.2, -140.9, 55, 1000, 'TS', 'Eastern Pacific', 0.5099020000000001], [2817, Timestamp('1978-08-26 06:00:00'), 342, 'KRISTY', 21.3, -139.1, 50, 0, 'TS', 'Eastern Pacific', 1.104536], [2818, Timestamp('1989-07-17 06:00:00'), 533, 'DALILIA', 14.4, -141.8, 65, 0, 'H1', 'Eastern Pacific', 1.702939], [2819, Timestamp('1984-07-03 06:00:00'), 437, 'DOUGLAS', 17.8, -137.6, 30, 0, 'TD', 'Eastern Pacific', 1.204159], [2820, Timestamp('2008-07-06 00:00:00'), 827, 'BORIS', 15.9, -137.2, 20, 1007, 'L', 'Eastern Pacific', 0.806226], [2821, Timestamp('1981-08-11 18:00:00'), 380, 'FERNANDA', 21.8, -135.7, 60, 0, 'TS', 'Eastern Pacific', 1.5811389999999999], [2822, Timestamp('2005-09-27 06:00:00'), 791, 'KENNETH', 14.3, -141.4, 55, 1000, 'TS', 'Eastern Pacific', 0.5], [2823, Timestamp('1990-09-28 18:00:00'), 563, 'POLO', 9.7, -137.1, 25, 1010, 'TD', 'Eastern Pacific', 0.806226], [2824, Timestamp('2005-09-27 12:00:00'), 791, 'KENNETH', 14.6, -141.8, 50, 1003, 'TS', 'Eastern Pacific', 0.8485280000000001], [2825, Timestamp('1981-08-12 00:00:00'), 380, 'FERNANDA', 22.7, -137.0, 50, 0, 'TS', 'Eastern Pacific', 0.781025], [2826, Timestamp('1984-07-03 12:00:00'), 437, 'DOUGLAS', 17.9, -138.8, 30, 0, 'TD', 'Eastern Pacific', 1.216553], [2827, Timestamp('2008-07-20 06:00:00'), 830, 'ELIDA', 17.3, -135.5, 25, 1008, 'L', 'Eastern Pacific', 1.603122], [2828, Timestamp('1990-09-29 00:00:00'), 563, 'POLO', 10.4, -137.5, 25, 1010, 'TD', 'Eastern Pacific', 0.9486829999999999], [2829, Timestamp('2008-07-20 12:00:00'), 830, 'ELIDA', 17.2, -137.1, 25, 1009, 'L', 'Eastern Pacific', 1.513275], [2830, Timestamp('2006-07-23 18:00:00'), 799, 'DANIEL', 15.1, -136.5, 105, 952, 'H3', 'Eastern Pacific', 1.456022], [2831, Timestamp('1981-08-12 06:00:00'), 380, 'FERNANDA', 23.3, -137.5, 40, 0, 'TS', 'Eastern Pacific', 0.565685], [2832, Timestamp('1990-09-29 06:00:00'), 563, 'POLO', 11.3, -137.8, 30, 1009, 'TD', 'Eastern Pacific', 1.044031], [2833, Timestamp('1985-08-02 18:00:00'), 466, 'LINDA', 15.8, -135.9, 30, 0, 'TD', 'Eastern Pacific', 0.7615770000000001], [2834, Timestamp('2008-07-20 18:00:00'), 830, 'ELIDA', 17.0, -138.6, 25, 1009, 'L', 'Eastern Pacific', 1.403567], [2835, Timestamp('1981-08-12 12:00:00'), 380, 'FERNANDA', 23.7, -137.9, 30, 0, 'TD', 'Eastern Pacific', 0.5], [2836, Timestamp('1990-09-29 12:00:00'), 563, 'POLO', 12.3, -138.1, 30, 1009, 'TD', 'Eastern Pacific', 1.0198040000000002], [2837, Timestamp('2006-08-03 12:00:00'), 801, 'FABIO', 15.1, -136.5, 25, 1009, 'L', 'Eastern Pacific', 1.702939], [2838, Timestamp('1985-08-03 00:00:00'), 466, 'LINDA', 16.1, -136.6, 30, 0, 'TD', 'Eastern Pacific', 0.632456], [2839, Timestamp('1981-08-12 18:00:00'), 380, 'FERNANDA', 24.1, -138.2, 30, 0, 'TD', 'Eastern Pacific', 0.538516], [2840, Timestamp('2006-08-03 18:00:00'), 801, 'FABIO', 15.0, -138.2, 25, 1009, 'L', 'Eastern Pacific', 1.4], [2841, Timestamp('1990-09-29 18:00:00'), 563, 'POLO', 13.3, -138.3, 45, 1000, 'TS', 'Eastern Pacific', 0.984886], [2842, Timestamp('2008-07-30 12:00:00'), 832, 'GENEVIEVE', 17.1, -136.4, 20, 1014, 'L', 'Eastern Pacific', 1.360147], [2843, Timestamp('1985-08-03 06:00:00'), 466, 'LINDA', 16.3, -137.2, 25, 0, 'TD', 'Eastern Pacific', 0.67082], [2844, Timestamp('2006-08-04 00:00:00'), 801, 'FABIO', 15.0, -139.6, 25, 1010, 'L', 'Eastern Pacific', 1.603122], [2845, Timestamp('1983-08-04 18:00:00'), 420, 'HENRIETTE', 21.3, -136.2, 45, 0, 'TS', 'Eastern Pacific', 0.860233], [2846, Timestamp('2008-07-30 18:00:00'), 832, 'GENEVIEVE', 16.7, -137.7, 20, 1014, 'L', 'Eastern Pacific', 1.236932], [2847, Timestamp('1990-09-30 00:00:00'), 563, 'POLO', 14.2, -138.7, 55, 994, 'TS', 'Eastern Pacific', 0.8544], [2848, Timestamp('1985-08-03 12:00:00'), 466, 'LINDA', 16.6, -137.8, 25, 0, 'TD', 'Eastern Pacific', 0.7615770000000001], [2849, Timestamp('2006-08-04 06:00:00'), 801, 'FABIO', 14.9, -141.2, 25, 1011, 'L', 'Eastern Pacific', 1.5], [2850, Timestamp('1990-09-30 06:00:00'), 563, 'POLO', 15.0, -139.0, 65, 987, 'H1', 'Eastern Pacific', 0.583095], [2851, Timestamp('2008-07-31 00:00:00'), 832, 'GENEVIEVE', 16.4, -138.9, 20, 1014, 'L', 'Eastern Pacific', 1.118034], [2852, Timestamp('1985-08-03 18:00:00'), 466, 'LINDA', 16.9, -138.5, 25, 0, 'TD', 'Eastern Pacific', 0.583095], [2853, Timestamp('1983-08-05 00:00:00'), 420, 'HENRIETTE', 21.8, -136.9, 40, 0, 'TS', 'Eastern Pacific', 1.029563], [2854, Timestamp('1985-08-04 00:00:00'), 466, 'LINDA', 17.2, -139.0, 25, 0, 'TD', 'Eastern Pacific', 0.728011], [2855, Timestamp('2006-08-04 12:00:00'), 801, 'FABIO', 14.9, -142.7, 25, 1012, 'L', 'Eastern Pacific', 1.403567], [2856, Timestamp('2008-08-13 12:00:00'), 834, 'HERNAN', 17.9, -136.1, 30, 1007, 'L', 'Eastern Pacific', 0.8544], [2857, Timestamp('2008-08-13 18:00:00'), 834, 'HERNAN', 17.6, -136.9, 25, 1008, 'L', 'Eastern Pacific', 0.8544], [2858, Timestamp('1983-08-05 06:00:00'), 420, 'HENRIETTE', 22.7, -137.4, 35, 0, 'TS', 'Eastern Pacific', 0.806226], [2859, Timestamp('1985-08-04 06:00:00'), 466, 'LINDA', 17.4, -139.7, 25, 0, 'TD', 'Eastern Pacific', 0.22360700000000003], [2860, Timestamp('2006-08-16 00:00:00'), 804, 'IOKE', 10.4, -142.5, 25, 1010, 'TD', 'Eastern Pacific', 1.4], [2861, Timestamp('1991-07-19 18:00:00'), 572, 'ENRIQUE', 15.3, -135.9, 30, 1008, 'TD', 'Eastern Pacific', 1.204159], [2862, Timestamp('1985-08-04 12:00:00'), 466, 'LINDA', 17.6, -139.8, 25, 0, 'TD', 'Eastern Pacific', 0.44721400000000006], [2863, Timestamp('2008-08-14 00:00:00'), 834, 'HERNAN', 17.3, -137.7, 25, 1008, 'L', 'Eastern Pacific', 0.8544], [2864, Timestamp('2007-07-18 00:00:00'), 817, 'COSME', 15.0, -136.0, 35, 1005, 'TS', 'Eastern Pacific', 1.204159], [2865, Timestamp('1983-08-05 12:00:00'), 420, 'HENRIETTE', 23.5, -137.5, 30, 0, 'TD', 'Eastern Pacific', 1.0], [2866, Timestamp('2008-08-14 06:00:00'), 834, 'HERNAN', 17.0, -138.5, 25, 1008, 'L', 'Eastern Pacific', 1.044031], [2867, Timestamp('1991-07-20 00:00:00'), 572, 'ENRIQUE', 15.2, -137.1, 30, 1009, 'TD', 'Eastern Pacific', 1.0], [2868, Timestamp('1985-08-04 18:00:00'), 466, 'LINDA', 17.8, -140.2, 40, 0, 'TS', 'Eastern Pacific', 0.412311], [2869, Timestamp('1991-07-20 06:00:00'), 572, 'ENRIQUE', 15.2, -138.1, 30, 1010, 'TD', 'Eastern Pacific', 0.905539], [2870, Timestamp('2007-07-18 06:00:00'), 817, 'COSME', 15.1, -137.2, 35, 1005, 'TS', 'Eastern Pacific', 1.1], [2871, Timestamp('1985-07-04 12:00:00'), 458, 'DOLORES', 23.8, -136.2, 25, 0, 'TD', 'Eastern Pacific', 0.565685], [2872, Timestamp('2008-08-14 12:00:00'), 834, 'HERNAN', 16.7, -139.5, 25, 1008, 'L', 'Eastern Pacific', 1.1704700000000001], [2873, Timestamp('1985-09-04 18:00:00'), 470, 'PAULINE', 18.0, -135.3, 65, 0, 'H1', 'Eastern Pacific', 1.315295], [2874, Timestamp('1992-09-06 00:00:00'), 599, 'INIKI', 11.9, -135.9, 25, 1010, 'TD', 'Eastern Pacific', 1.3038399999999999], [2875, Timestamp('2007-07-18 12:00:00'), 817, 'COSME', 15.1, -138.3, 35, 1005, 'TS', 'Eastern Pacific', 1.204159], [2876, Timestamp('1986-08-30 18:00:00'), 487, 'JAVIER', 23.8, -135.5, 30, 0, 'TD', 'Eastern Pacific', 0.984886], [2877, Timestamp('1957-09-09 00:00:00'), 66, 'NOTNAMED', 15.3, -139.0, 45, 0, 'TS', 'Eastern Pacific', 0.728011], [2878, Timestamp('1966-09-10 06:00:00'), 158, 'GRETCHEN', 14.4, -135.8, 45, 0, 'TS', 'Eastern Pacific', 0.860233], [2879, Timestamp('2007-07-18 18:00:00'), 817, 'COSME', 15.0, -139.5, 30, 1006, 'TD', 'Eastern Pacific', 1.216553], [2880, Timestamp('1992-09-06 06:00:00'), 599, 'INIKI', 12.0, -137.2, 25, 1010, 'TD', 'Eastern Pacific', 1.3038399999999999], [2881, Timestamp('1985-09-05 00:00:00'), 470, 'PAULINE', 18.2, -136.6, 65, 0, 'H1', 'Eastern Pacific', 1.5], [2882, Timestamp('1988-09-29 18:00:00'), 528, 'LANE', 22.5, -135.5, 25, 1014, 'TD', 'Eastern Pacific', 1.334166], [2883, Timestamp('2007-07-19 00:00:00'), 817, 'COSME', 15.2, -140.7, 30, 1008, 'TD', 'Eastern Pacific', 1.3038399999999999], [2884, Timestamp('1992-09-06 12:00:00'), 599, 'INIKI', 12.1, -138.5, 30, 1009, 'TD', 'Eastern Pacific', 1.3038399999999999], [2885, Timestamp('1988-09-30 00:00:00'), 528, 'LANE', 22.8, -136.8, 20, 1014, 'TD', 'Eastern Pacific', 1.2649110000000001], [2886, Timestamp('1985-09-05 06:00:00'), 470, 'PAULINE', 18.2, -138.1, 75, 0, 'H1', 'Eastern Pacific', 1.702939], [2887, Timestamp('1966-09-10 12:00:00'), 158, 'GRETCHEN', 13.9, -136.5, 45, 0, 'TS', 'Eastern Pacific', 1.615549], [2888, Timestamp('1992-09-06 18:00:00'), 599, 'INIKI', 12.2, -139.8, 30, 1008, 'TD', 'Eastern Pacific', 1.3038399999999999], [2889, Timestamp('1985-09-05 12:00:00'), 470, 'PAULINE', 18.3, -139.8, 75, 0, 'H1', 'Eastern Pacific', 0.8246209999999999], [2890, Timestamp('2007-07-19 06:00:00'), 817, 'COSME', 15.3, -142.0, 30, 1010, 'TD', 'Eastern Pacific', 1.612452], [2891, Timestamp('1988-09-30 06:00:00'), 528, 'LANE', 23.2, -138.0, 20, 1015, 'TD', 'Eastern Pacific', 1.140175], [2892, Timestamp('1966-09-10 18:00:00'), 158, 'GRETCHEN', 13.3, -138.0, 45, 0, 'TS', 'Eastern Pacific', 1.802776], [2893, Timestamp('1992-09-07 00:00:00'), 599, 'INIKI', 12.3, -141.1, 25, 1008, 'TD', 'Eastern Pacific', 0.6], [2894, Timestamp('2007-08-10 12:00:00'), 820, 'FLOSSIE', 12.6, -135.4, 70, 984, 'H1', 'Eastern Pacific', 1.2], [2895, Timestamp('1985-09-08 12:00:00'), 471, 'RICK', 15.3, -137.1, 115, 0, 'H4', 'Eastern Pacific', 1.063015], [2896, Timestamp('1990-07-29 18:00:00'), 554, 'HERNAN', 22.0, -136.0, 35, 1006, 'TS', 'Eastern Pacific', 1.063015], [2897, Timestamp('1966-09-11 00:00:00'), 158, 'GRETCHEN', 12.7, -139.7, 45, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2898, Timestamp('1992-09-07 06:00:00'), 599, 'INIKI', 12.3, -141.7, 25, 1007, 'TD', 'Eastern Pacific', 0.7071069999999999], [2899, Timestamp('2007-08-10 18:00:00'), 820, 'FLOSSIE', 12.6, -136.6, 80, 977, 'H1', 'Eastern Pacific', 1.1], [2900, Timestamp('1985-09-08 18:00:00'), 471, 'RICK', 16.0, -137.9, 120, 0, 'H4', 'Eastern Pacific', 1.063015], [2901, Timestamp('1990-07-30 00:00:00'), 554, 'HERNAN', 22.8, -136.7, 30, 1008, 'TD', 'Eastern Pacific', 1.0], [2902, Timestamp('1992-09-07 12:00:00'), 599, 'INIKI', 12.2, -142.4, 30, 1006, 'TD', 'Eastern Pacific', 0.608276], [2903, Timestamp('2007-08-11 00:00:00'), 820, 'FLOSSIE', 12.6, -137.7, 90, 970, 'H2', 'Eastern Pacific', 1.0], [2904, Timestamp('1966-09-11 06:00:00'), 158, 'GRETCHEN', 12.5, -140.7, 45, 0, 'TS', 'Eastern Pacific', 0.67082], [2905, Timestamp('1985-09-09 00:00:00'), 471, 'RICK', 16.7, -138.7, 120, 0, 'H4', 'Eastern Pacific', 0.860233], [2906, Timestamp('1967-10-28 00:00:00'), 181, 'RAMONA', 15.2, -135.8, 25, 0, 'TD', 'Eastern Pacific', 0.7071069999999999], [2907, Timestamp('2007-08-11 06:00:00'), 820, 'FLOSSIE', 12.6, -138.7, 100, 965, 'H3', 'Eastern Pacific', 1.004988], [2908, Timestamp('1994-07-11 00:00:00'), 627, 'DANIEL', 12.5, -135.6, 55, 994, 'TS', 'Eastern Pacific', 1.7262680000000001], [2909, Timestamp('1990-07-30 06:00:00'), 554, 'HERNAN', 23.6, -137.3, 30, 1009, 'TD', 'Eastern Pacific', 1.029563], [2910, Timestamp('1985-09-09 06:00:00'), 471, 'RICK', 17.2, -139.4, 125, 0, 'H4', 'Eastern Pacific', 0.8544], [2911, Timestamp('1967-10-28 06:00:00'), 181, 'RAMONA', 15.3, -136.5, 25, 0, 'TD', 'Eastern Pacific', 0.8246209999999999], [2912, Timestamp('2007-08-11 12:00:00'), 820, 'FLOSSIE', 12.7, -139.7, 115, 950, 'H4', 'Eastern Pacific', 0.921954], [2913, Timestamp('1994-07-11 06:00:00'), 627, 'DANIEL', 12.8, -137.3, 55, 994, 'TS', 'Eastern Pacific', 1.612452], [2914, Timestamp('1992-07-21 06:00:00'), 589, 'FRANK', 22.1, -136.4, 70, 986, 'H1', 'Eastern Pacific', 1.029563], [2915, Timestamp('1985-09-09 12:00:00'), 471, 'RICK', 17.5, -140.2, 125, 0, 'H4', 'Eastern Pacific', 0.943398], [2916, Timestamp('1968-07-30 18:00:00'), 186, 'ESTELLE', 14.8, -135.4, 25, 0, 'TD', 'Eastern Pacific', 1.3038399999999999], [2917, Timestamp('2007-08-11 18:00:00'), 820, 'FLOSSIE', 12.9, -140.6, 115, 950, 'H4', 'Eastern Pacific', 1.140175], [2918, Timestamp('1994-07-11 12:00:00'), 627, 'DANIEL', 13.0, -138.9, 55, 994, 'TS', 'Eastern Pacific', 1.529706], [2919, Timestamp('1985-09-16 18:00:00'), 472, 'SANDRA', 18.9, -135.2, 25, 0, 'TD', 'Eastern Pacific', 1.603122], [2920, Timestamp('1992-07-21 12:00:00'), 589, 'FRANK', 22.6, -137.3, 65, 990, 'H1', 'Eastern Pacific', 1.118034], [2921, Timestamp('1968-07-31 00:00:00'), 186, 'ESTELLE', 14.9, -136.7, 25, 0, 'TD', 'Eastern Pacific', 1.403567], [2922, Timestamp('2007-08-12 00:00:00'), 820, 'FLOSSIE', 13.2, -141.7, 120, 949, 'H4', 'Eastern Pacific', 1.315295], [2923, Timestamp('2008-07-02 00:00:00'), 828, 'CRISTINA', 13.8, -136.0, 20, 1009, 'L', 'Eastern Pacific', 0.583095], [2924, Timestamp('1968-07-31 06:00:00'), 186, 'ESTELLE', 15.0, -138.1, 25, 0, 'TD', 'Eastern Pacific', 1.5], [2925, Timestamp('1992-07-21 18:00:00'), 589, 'FRANK', 23.1, -138.3, 55, 994, 'TS', 'Eastern Pacific', 1.118034], [2926, Timestamp('1986-08-01 06:00:00'), 483, 'FRANK', 18.9, -135.3, 65, 0, 'H1', 'Eastern Pacific', 1.360147], [2927, Timestamp('1994-07-11 18:00:00'), 627, 'DANIEL', 13.3, -140.4, 55, 994, 'TS', 'Eastern Pacific', 1.118034], [2928, Timestamp('1968-08-31 18:00:00'), 192, 'KATHLEEN', 15.2, -135.4, 25, 0, 'TD', 'Eastern Pacific', 1.486607], [2929, Timestamp('2008-07-02 06:00:00'), 828, 'CRISTINA', 13.5, -136.5, 20, 1009, 'L', 'Eastern Pacific', 0.565685], [2930, Timestamp('1994-07-12 00:00:00'), 627, 'DANIEL', 13.5, -141.5, 55, 995, 'TS', 'Eastern Pacific', 1.216553], [2931, Timestamp('1992-07-22 00:00:00'), 589, 'FRANK', 23.6, -139.3, 50, 997, 'TS', 'Eastern Pacific', 1.334166], [2932, Timestamp('1986-08-01 12:00:00'), 483, 'FRANK', 19.3, -136.6, 65, 0, 'H1', 'Eastern Pacific', 1.360147], [2933, Timestamp('1968-09-01 00:00:00'), 192, 'KATHLEEN', 14.7, -136.8, 25, 0, 'TD', 'Eastern Pacific', 1.486607], [2934, Timestamp('2008-07-02 12:00:00'), 828, 'CRISTINA', 13.1, -136.9, 20, 1009, 'L', 'Eastern Pacific', 0.360555], [2935, Timestamp('1992-09-10 12:00:00'), 598, 'ORLENE', 21.4, -135.8, 85, 974, 'H2', 'Eastern Pacific', 0.5], [2936, Timestamp('1994-07-12 06:00:00'), 627, 'DANIEL', 13.7, -142.7, 55, 996, 'TS', 'Eastern Pacific', 1.3038399999999999], [2937, Timestamp('1986-08-01 18:00:00'), 483, 'FRANK', 19.7, -137.9, 50, 0, 'TS', 'Eastern Pacific', 1.3], [2938, Timestamp('2008-07-02 18:00:00'), 828, 'CRISTINA', 12.8, -137.1, 20, 1009, 'L', 'Eastern Pacific', 0.316228], [2939, Timestamp('1994-07-17 00:00:00'), 628, 'EMILIA', 9.6, -135.9, 55, 995, 'TS', 'Eastern Pacific', 1.529706], [2940, Timestamp('1992-09-10 18:00:00'), 598, 'ORLENE', 21.8, -136.1, 80, 977, 'H1', 'Eastern Pacific', 0.5], [2941, Timestamp('1968-09-01 06:00:00'), 192, 'KATHLEEN', 14.2, -138.2, 25, 0, 'TD', 'Eastern Pacific', 1.3], [2942, Timestamp('2008-08-04 12:00:00'), 833, 'KIKA', 10.4, -136.2, 20, 1010, 'TD', 'Eastern Pacific', 0.6], [2943, Timestamp('1994-07-17 06:00:00'), 628, 'EMILIA', 9.9, -137.4, 70, 988, 'H1', 'Eastern Pacific', 1.4142139999999999], [2944, Timestamp('1986-08-02 00:00:00'), 483, 'FRANK', 20.2, -139.1, 30, 0, 'TD', 'Eastern Pacific', 1.612452], [2945, Timestamp('1992-09-11 00:00:00'), 598, 'ORLENE', 22.2, -136.4, 75, 980, 'H1', 'Eastern Pacific', 0.42426400000000003], [2946, Timestamp('1968-09-01 12:00:00'), 192, 'KATHLEEN', 14.2, -139.5, 25, 0, 'TD', 'Eastern Pacific', 0.8944270000000001], [2947, Timestamp('2008-08-04 18:00:00'), 833, 'KIKA', 10.4, -136.8, 20, 1010, 'TD', 'Eastern Pacific', 0.7], [2948, Timestamp('1992-09-11 06:00:00'), 598, 'ORLENE', 22.5, -136.7, 65, 987, 'H1', 'Eastern Pacific', 0.538516], [2949, Timestamp('1994-07-17 12:00:00'), 628, 'EMILIA', 10.1, -138.8, 80, 979, 'H1', 'Eastern Pacific', 1.315295], [2950, Timestamp('1986-09-15 06:00:00'), 489, 'LESTER', 15.4, -135.6, 40, 0, 'TS', 'Eastern Pacific', 0.921954], [2951, Timestamp('1968-09-01 18:00:00'), 192, 'KATHLEEN', 14.6, -140.3, 25, 0, 'TD', 'Eastern Pacific', 0.806226], [2952, Timestamp('2008-08-05 00:00:00'), 833, 'KIKA', 10.4, -137.5, 20, 1010, 'TD', 'Eastern Pacific', 2.0396080000000003], [2953, Timestamp('1992-09-11 12:00:00'), 598, 'ORLENE', 22.7, -137.2, 60, 991, 'TS', 'Eastern Pacific', 0.7071069999999999], [2954, Timestamp('1994-07-17 18:00:00'), 628, 'EMILIA', 10.3, -140.1, 90, 968, 'H2', 'Eastern Pacific', 1.3038399999999999], [2955, Timestamp('1968-09-02 00:00:00'), 192, 'KATHLEEN', 15.0, -141.0, 25, 0, 'TD', 'Eastern Pacific', 1.029563], [2956, Timestamp('1986-09-15 12:00:00'), 489, 'LESTER', 16.0, -136.3, 45, 0, 'TS', 'Eastern Pacific', 0.860233], [2957, Timestamp('1992-09-11 18:00:00'), 598, 'ORLENE', 22.8, -137.9, 55, 994, 'TS', 'Eastern Pacific', 0.905539], [2958, Timestamp('1994-07-18 00:00:00'), 628, 'EMILIA', 10.4, -141.4, 100, 962, 'H3', 'Eastern Pacific', 1.315295], [2959, Timestamp('2008-08-05 06:00:00'), 833, 'KIKA', 10.0, -139.5, 20, 1009, 'TD', 'Eastern Pacific', 1.216553], [2960, Timestamp('1968-09-30 06:00:00'), 196, 'ORLA', 15.1, -136.3, 25, 0, 'TD', 'Eastern Pacific', 0.608276], [2961, Timestamp('1986-09-15 18:00:00'), 489, 'LESTER', 16.5, -137.0, 45, 0, 'TS', 'Eastern Pacific', 0.860233], [2962, Timestamp('1992-09-12 00:00:00'), 598, 'ORLENE', 22.7, -138.8, 45, 1000, 'TS', 'Eastern Pacific', 1.204159], [2963, Timestamp('2008-08-05 12:00:00'), 833, 'KIKA', 10.2, -140.7, 20, 1009, 'TD', 'Eastern Pacific', 1.1704700000000001], [2964, Timestamp('1970-08-22 06:00:00'), 223, 'MAGGIE', 14.4, -136.3, 45, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2965, Timestamp('1994-07-18 06:00:00'), 628, 'EMILIA', 10.6, -142.7, 115, 958, 'H4', 'Eastern Pacific', 1.104536], [2966, Timestamp('1986-09-16 00:00:00'), 489, 'LESTER', 17.0, -137.7, 40, 0, 'TS', 'Eastern Pacific', 0.921954], [2967, Timestamp('1994-07-23 12:00:00'), 630, 'GILMA', 12.0, -135.5, 90, 968, 'H2', 'Eastern Pacific', 1.702939], [2968, Timestamp('1986-09-16 06:00:00'), 489, 'LESTER', 17.6, -138.4, 35, 0, 'TS', 'Eastern Pacific', 0.8944270000000001], [2969, Timestamp('1970-08-22 12:00:00'), 223, 'MAGGIE', 14.6, -137.3, 45, 0, 'TS', 'Eastern Pacific', 1.0198040000000002], [2970, Timestamp('2008-08-05 18:00:00'), 833, 'KIKA', 9.8, -141.8, 20, 1010, 'TD', 'Eastern Pacific', 0.7071069999999999], [2971, Timestamp('1992-10-08 18:00:00'), 603, 'TINA', 23.8, -135.6, 30, 1009, 'TD', 'Eastern Pacific', 1.0], [2972, Timestamp('1994-07-23 18:00:00'), 630, 'GILMA', 12.1, -137.2, 115, 948, 'H4', 'Eastern Pacific', 1.702939], [2973, Timestamp('2008-08-06 00:00:00'), 833, 'KIKA', 9.7, -142.5, 25, 1008, 'TD', 'Eastern Pacific', 1.118034], [2974, Timestamp('1986-09-16 12:00:00'), 489, 'LESTER', 18.0, -139.2, 35, 0, 'TS', 'Eastern Pacific', 0.8944270000000001], [2975, Timestamp('1970-08-22 18:00:00'), 223, 'MAGGIE', 14.8, -138.3, 50, 0, 'TS', 'Eastern Pacific', 1.104536], [2976, Timestamp('1992-10-09 00:00:00'), 603, 'TINA', 23.8, -136.6, 30, 1010, 'TD', 'Eastern Pacific', 1.204159], [2977, Timestamp('1994-07-24 00:00:00'), 630, 'GILMA', 12.2, -138.9, 130, 935, 'H4', 'Eastern Pacific', 1.5], [2978, Timestamp('2008-10-18 18:00:00'), 839, 'MARIE', 10.7, -136.0, 25, 1009, 'L', 'Eastern Pacific', 1.004988], [2979, Timestamp('1992-10-09 06:00:00'), 603, 'TINA', 23.7, -137.8, 30, 1010, 'TD', 'Eastern Pacific', 1.204159], [2980, Timestamp('1986-09-16 18:00:00'), 489, 'LESTER', 18.4, -140.0, 30, 0, 'TD', 'Eastern Pacific', 0.8544], [2981, Timestamp('2008-10-19 00:00:00'), 839, 'MARIE', 10.6, -137.0, 25, 1009, 'L', 'Eastern Pacific', 1.0], [2982, Timestamp('1994-07-24 06:00:00'), 630, 'GILMA', 12.2, -140.4, 135, 0, 'H4', 'Eastern Pacific', 1.4142139999999999], [2983, Timestamp('1992-10-09 12:00:00'), 603, 'TINA', 23.8, -139.0, 30, 1010, 'TD', 'Eastern Pacific', 1.118034], [2984, Timestamp('1986-09-22 18:00:00'), 492, 'ORLENE', 15.4, -140.4, 70, 0, 'H1', 'Eastern Pacific', 0.67082], [2985, Timestamp('1994-07-24 12:00:00'), 630, 'GILMA', 12.0, -141.8, 135, 0, 'H4', 'Eastern Pacific', 1.5033299999999998], [2986, Timestamp('2008-10-19 06:00:00'), 839, 'MARIE', 10.6, -138.0, 20, 1010, 'L', 'Eastern Pacific', 1.0], [2987, Timestamp('1992-10-09 18:00:00'), 603, 'TINA', 24.0, -140.1, 30, 1010, 'TD', 'Eastern Pacific', 1.029563], [2988, Timestamp('1987-09-26 06:00:00'), 510, 'OTIS', 17.2, -135.7, 30, 0, 'TD', 'Eastern Pacific', 1.702939], [2989, Timestamp('1993-08-27 18:00:00'), 616, 'GREG', 21.1, -138.9, 35, 1005, 'TS', 'Eastern Pacific', 0.806226], [2990, Timestamp('1994-08-03 06:00:00'), 631, 'LI', 11.1, -140.0, 25, 0, 'TD', 'Eastern Pacific', 0.806226], [2991, Timestamp('1987-09-26 12:00:00'), 510, 'OTIS', 17.3, -137.4, 30, 0, 'TD', 'Eastern Pacific', 1.315295], [2992, Timestamp('1993-08-28 00:00:00'), 616, 'GREG', 21.2, -139.7, 30, 1008, 'TD', 'Eastern Pacific', 0.5099020000000001], [2993, Timestamp('1994-08-03 12:00:00'), 631, 'LI', 11.0, -140.8, 30, 0, 'TD', 'Eastern Pacific', 1.204159], [2994, Timestamp('1988-07-29 12:00:00'), 521, 'GILMA', 15.8, -136.0, 40, 1003, 'TS', 'Eastern Pacific', 0.22360700000000003], [2995, Timestamp('1994-08-03 18:00:00'), 631, 'LI', 10.9, -142.0, 25, 0, 'TD', 'Eastern Pacific', 1.513275], [2996, Timestamp('1988-07-29 18:00:00'), 521, 'GILMA', 15.9, -136.2, 45, 1000, 'TS', 'Eastern Pacific', 0.22360700000000003], [2997, Timestamp('1988-07-30 00:00:00'), 521, 'GILMA', 16.0, -136.4, 45, 1000, 'TS', 'Eastern Pacific', 0.0], [2998, Timestamp('1988-07-30 06:00:00'), 521, 'GILMA', 16.0, -136.4, 40, 1002, 'TS', 'Eastern Pacific', 0.412311], [2999, Timestamp('1988-07-30 12:00:00'), 521, 'GILMA', 16.1, -136.8, 35, 1005, 'TS', 'Eastern Pacific', 1.2649110000000001], [3000, Timestamp('1988-07-30 18:00:00'), 521, 'GILMA', 16.5, -138.0, 30, 1007, 'TD', 'Eastern Pacific', 1.9416490000000002], ...]
In [21]:
for line in data_values:
cur.execute("INSERT INTO storm_data VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",line)
conn.commit()
Checking Out the Inserted Data¶
We check by a simple select statement and a count of the number of rows in the table.
In [22]:
# LIMIT to 2 to safe time and space
cur.execute("SELECT * FROM storm_data LIMIT 2")
cur.fetchall()
Out[22]:
[(2001, datetime.datetime(1957, 8, 8, 18, 0), 63, 'NOTNAMED', Decimal('22.5'), Decimal('-140.0'), 50, 0, 'TS', 'Eastern Pacific', Decimal('1.140175')), (2002, datetime.datetime(1961, 10, 3, 12, 0), 116, 'PAULINE', Decimal('22.1'), Decimal('-140.2'), 45, 0, 'TS', 'Eastern Pacific', Decimal('1.166190'))]
In [23]:
# Checking the number of rows to be the same as our pandas dataframe loaded from the original csv
cur.execute("SELECT COUNT(*) FROM storm_data")
cur.fetchall()
Out[23]:
[(59228,)]
Loading SQL Result to Pandas¶
reference: https://gist.github.com/jakebrinkmann/de7fd185efe9a1f459946cf72def057e
In [24]:
import pandas.io.sql as iosql
sql = 'SELECT * FROM storm_data;'
df_sql = iosql.read_sql_query(sql,conn)
df_sql.head()
Out[24]:
fid | date_time | btid | name | lat | long | wind_kts | pressure | cat | basin | shape_leng | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2001 | 1957-08-08 18:00:00 | 63 | NOTNAMED | 22.5 | -140.0 | 50 | 0 | TS | Eastern Pacific | 1.140175 |
1 | 2002 | 1961-10-03 12:00:00 | 116 | PAULINE | 22.1 | -140.2 | 45 | 0 | TS | Eastern Pacific | 1.166190 |
2 | 2003 | 1962-08-29 06:00:00 | 124 | C | 18.0 | -140.0 | 45 | 0 | TS | Eastern Pacific | 2.102380 |
3 | 2004 | 1967-07-14 06:00:00 | 168 | DENISE | 16.6 | -139.5 | 45 | 0 | TS | Eastern Pacific | 2.121320 |
4 | 2005 | 1972-08-16 12:00:00 | 251 | DIANA | 18.5 | -139.8 | 70 | 0 | H1 | Eastern Pacific | 1.702939 |
In [25]:
df_sql.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 59228 entries, 0 to 59227 Data columns (total 11 columns): fid 59228 non-null int64 date_time 59228 non-null datetime64[ns] btid 59228 non-null int64 name 59228 non-null object lat 59228 non-null float64 long 59228 non-null float64 wind_kts 59228 non-null int64 pressure 59228 non-null int64 cat 59228 non-null object basin 59228 non-null object shape_leng 59228 non-null float64 dtypes: datetime64[ns](1), float64(3), int64(4), object(3) memory usage: 5.0+ MB
In [26]:
conn.close()
Load New Data¶
In [27]:
df2 = pd.read_csv('https://dq-content.s3.amazonaws.com/251/storm_data_additional.csv')
df2.head()
Out[27]:
FID | DATETIME | BTID | NAME | LAT | LONG | WIND_KTS | PRESSURE | CAT | BASIN | Shape_Leng | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | 97fc91afc6acbb8df4563a90b8b1c4fa | 1851-06-25 00:00:00 | 1 | NOTNAMED | 28.0 | -94.8 | 80 | 0 | H1 | North Atlantic | 0.600000 |
1 | 174b0313d3601872c6fd2c65150eef1c | 1851-06-25 06:00:00 | 1 | NOTNAMED | 28.0 | -95.4 | 80 | 0 | H1 | North Atlantic | 0.600000 |
2 | 74f4a8b3a417f9509ce5f285f5666a99 | 1851-06-25 12:00:00 | 1 | NOTNAMED | 28.0 | -96.0 | 80 | 0 | H1 | North Atlantic | 0.509902 |
3 | a17379f02b1d82946a49cd865931e8ad | 1851-06-25 18:00:00 | 1 | NOTNAMED | 28.1 | -96.5 | 80 | 0 | H1 | North Atlantic | 0.509902 |
4 | 013c8fb523008502e67c70c9ddc17dc5 | 1851-06-26 00:00:00 | 1 | NOTNAMED | 28.2 | -97.0 | 70 | 0 | H1 | North Atlantic | 0.608276 |
In [28]:
df.describe()
Out[28]:
fid | btid | lat | long | wind_kts | pressure | shape_leng | |
---|---|---|---|---|---|---|---|
count | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 |
mean | 29614.500000 | 648.398899 | 23.526400 | -83.196863 | 54.726802 | 372.336800 | 1.201987 |
std | 17097.795209 | 372.376803 | 9.464955 | 37.282152 | 25.133577 | 480.562974 | 0.834497 |
min | 1.000000 | 1.000000 | 4.200000 | -180.000000 | 10.000000 | 0.000000 | 0.000000 |
25% | 14807.750000 | 344.000000 | 16.100000 | -108.500000 | 35.000000 | 0.000000 | 0.707107 |
50% | 29614.500000 | 606.000000 | 21.200000 | -81.200000 | 50.000000 | 0.000000 | 1.029563 |
75% | 44421.250000 | 920.000000 | 29.600000 | -62.200000 | 70.000000 | 990.000000 | 1.431782 |
max | 59228.000000 | 1410.000000 | 69.000000 | 180.000000 | 165.000000 | 1024.000000 | 11.180340 |
In [29]:
df2.describe()
Out[29]:
BTID | LAT | LONG | WIND_KTS | PRESSURE | Shape_Leng | |
---|---|---|---|---|---|---|
count | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 | 59228.000000 |
mean | 648.398899 | 23.526400 | -83.196863 | 54.726802 | 372.336800 | 1.201987 |
std | 372.376803 | 9.464955 | 37.282152 | 25.133577 | 480.562974 | 0.834497 |
min | 1.000000 | 4.200000 | -180.000000 | 10.000000 | 0.000000 | 0.000000 |
25% | 344.000000 | 16.100000 | -108.500000 | 35.000000 | 0.000000 | 0.707107 |
50% | 606.000000 | 21.200000 | -81.200000 | 50.000000 | 0.000000 | 1.029563 |
75% | 920.000000 | 29.600000 | -62.200000 | 70.000000 | 990.000000 | 1.431782 |
max | 1410.000000 | 69.000000 | 180.000000 | 165.000000 | 1024.000000 | 11.180340 |
In [30]:
print('Max length of NAME: ',df2.NAME.map(lambda x: len(x)).max())
Max length of NAME: 9
In [31]:
print('Max length of BASIN: ',df2.BASIN.map(lambda x: len(x)).max())
Max length of BASIN: 15
In [32]:
print('Max length of fid: ',df2.FID.map(lambda x: len(x)).max())
Max length of fid: 32
The column of fid needs to changed VARCHAR(32)to accommadate the max length and data type changes.
ALTER Column fid to VARCHAR(32)¶
In [33]:
conn = psycopg2.connect(dbname = 'ihw',user = 'postgres')
cur = conn.cursor()
cur.execute("""
ALTER TABLE storm_data ALTER COLUMN fid TYPE VARCHAR(32);
""")
conn.commit()
Inserting New Data¶
In [34]:
# convert df2 to list
data_values2 = df2.values.tolist()
for line in data_values2:
cur.execute("INSERT INTO storm_data VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",line)
conn.commit()
Check the Total Number of Rows:¶
In [35]:
cur.execute("SELECT COUNT(*) FROM storm_data")
cur.fetchall()
Out[35]:
[(118456,)]
In [36]:
conn.close()
In [ ]: