{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Creates an International Travel Log\n", "\n", "Uses timezones to create an international travel log" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "from datetime import datetime, timezone, timedelta\n", "from dateutil.parser import parse\n", "from dateutil import tz\n", "from memair import Memair\n", "import time\n", "\n", "# Memair Access Token\n", "access_token = 'foo'\n", "start_date = datetime(2014,5,17).date()\n", "end_date = datetime.now().date()" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Collecting & processing locations\n", ". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . \n", "Finished collecting data\n" ] } ], "source": [ "home_country_timezones = ['America/Atikokan', 'America/Blanc-Sablon', 'America/Cambridge_Bay',\n", " 'America/Creston', 'America/Dawson', 'America/Dawson_Creek',\n", " 'America/Edmonton', 'America/Fort_Nelson', 'America/Glace_Bay',\n", " 'America/Goose_Bay', 'America/Halifax', 'America/Inuvik',\n", " 'America/Iqaluit', 'America/Moncton', 'America/Montreal',\n", " 'America/Nipigon', 'America/Pangnirtung', 'America/Rainy_River',\n", " 'America/Rankin_Inlet', 'America/Regina', 'America/Resolute',\n", " 'America/St_Johns', 'America/Swift_Current', 'America/Thunder_Bay',\n", " 'America/Toronto', 'America/Vancouver', 'America/Whitehorse',\n", " 'America/Winnipeg', 'America/Yellowknife']\n", "user = Memair(access_token)\n", "after = -1\n", "dates = {}\n", "\n", "print('Collecting & processing locations')\n", "\n", "while True:\n", " query = f'''\n", " query {{\n", " Locations(\n", " first: 10000\n", " after: {after}\n", " from_timestamp: \"{start_date}\"\n", " order: asc\n", " order_by: timestamp\n", " )\n", " {{\n", " id\n", " timestamp\n", " timezone\n", " }}\n", " }}\n", "\n", " '''\n", " response = user.query(query)\n", "\n", " if len(response['data']['Locations']) == 0:\n", " break\n", " \n", " for location in response['data']['Locations']:\n", " timezone = location['timezone']\n", " date = parse(location['timestamp']).astimezone(tz=tz.gettz(timezone)).date()\n", " if date not in dates.keys():\n", " dates[date] = {'first_tz': timezone, 'readings': 1}\n", " \n", " dates[date]['last_tz'] = timezone\n", " dates[date]['readings'] += 1\n", "\n", " after = response['data']['Locations'][-1]['id']\n", " time.sleep(1)\n", " print('. ', end='')\n", "\n", "print(f'\\nFinished collecting data')" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Date\tStatus\tReadings\n", "2014-05-17\tIn Canada\t811\n", "2014-05-18\tIn Canada\t687\n", "2014-05-19\tIn Canada\t739\n", "2014-05-20\tIn Canada\t841\n", "2014-05-21\tIn Canada\t850\n", "2014-05-22\tIn Canada\t763\n", "2014-05-23\tIn Canada\t571\n", "2014-05-24\tIn Canada\t615\n", "2014-05-25\tIn Canada\t698\n", "2014-05-26\tIn Canada\t620\n", "2014-05-27\tIn Canada\t711\n", "2014-05-28\tIn Canada\t876\n", "2014-05-29\tIn Canada\t763\n", "2014-05-30\tIn Canada\t908\n", "2014-05-31\tIn Canada\t747\n", "2014-06-01\tIn Canada\t396\n", "2014-06-02\tNo Data\t0\n", "2014-06-03\tNo Data\t0\n", "2014-06-04\tNo Data\t0\n", "2014-06-05\tNo Data\t0\n", "2014-06-06\tNo Data\t0\n", "2014-06-07\tNo Data\t0\n", "2014-06-08\tNo Data\t0\n", "2014-06-09\tNo Data\t0\n", "2014-06-10\tNo Data\t0\n", "2014-06-11\tNo Data\t0\n", "2014-06-12\tNo Data\t0\n", "2014-06-13\tNo Data\t0\n", "2014-06-14\tNo Data\t0\n", "2014-06-15\tNo Data\t0\n", "2014-06-16\tNo Data\t0\n", "2014-06-17\tNo Data\t0\n", "2014-06-18\tNo Data\t0\n", "2014-06-19\tNo Data\t0\n", "2014-06-20\tNo Data\t0\n", "2014-06-21\tNo Data\t0\n", "2014-06-22\tNo Data\t0\n", "2014-06-23\tNo Data\t0\n", "2014-06-24\tNo Data\t0\n", "2014-06-25\tNo Data\t0\n", "2014-06-26\tNo Data\t0\n", "2014-06-27\tNo Data\t0\n", "2014-06-28\tNo Data\t0\n", "2014-06-29\tNo Data\t0\n", "2014-06-30\tNo Data\t0\n", "2014-07-01\tNo Data\t0\n", "2014-07-02\tNo Data\t0\n", "2014-07-03\tNo Data\t0\n", "2014-07-04\tNo Data\t0\n", "2014-07-05\tNo Data\t0\n", "2014-07-06\tNo Data\t0\n", "2014-07-07\tNo Data\t0\n", "2014-07-08\tNo Data\t0\n", "2014-07-09\tNo Data\t0\n", "2014-07-10\tNo Data\t0\n", "2014-07-11\tNo Data\t0\n", "2014-07-12\tNo Data\t0\n", "2014-07-13\tNo Data\t0\n", "2014-07-14\tNo Data\t0\n", "2014-07-15\tNo Data\t0\n", "2014-07-16\tNo Data\t0\n", "2014-07-17\tNo Data\t0\n", "2014-07-18\tNo Data\t0\n", "2014-07-19\tNo Data\t0\n", "2014-07-20\tNo Data\t0\n", "2014-07-21\tNo Data\t0\n", "2014-07-22\tNo Data\t0\n", "2014-07-23\tNo Data\t0\n", "2014-07-24\tNo Data\t0\n", "2014-07-25\tNo Data\t0\n", "2014-07-26\tNo Data\t0\n", "2014-07-27\tNo Data\t0\n", "2014-07-28\tNo Data\t0\n", "2014-07-29\tNo Data\t0\n", "2014-07-30\tNo Data\t0\n", "2014-07-31\tNo Data\t0\n", "2014-08-01\tNo Data\t0\n", "2014-08-02\tNo Data\t0\n", "2014-08-03\tNo Data\t0\n", "2014-08-04\tNo Data\t0\n", "2014-08-05\tNo Data\t0\n", "2014-08-06\tNo Data\t0\n", "2014-08-07\tNo Data\t0\n", "2014-08-08\tNo Data\t0\n", "2014-08-09\tNo Data\t0\n", "2014-08-10\tNo Data\t0\n", "2014-08-11\tNo Data\t0\n", "2014-08-12\tNo Data\t0\n", "2014-08-13\tNo Data\t0\n", "2014-08-14\tNo Data\t0\n", "2014-08-15\tNo Data\t0\n", "2014-08-16\tNo Data\t0\n", "2014-08-17\tNo Data\t0\n", "2014-08-18\tNo Data\t0\n", "2014-08-19\tNo Data\t0\n", "2014-08-20\tNo Data\t0\n", "2014-08-21\tNo Data\t0\n", "2014-08-22\tNo Data\t0\n", "2014-08-23\tNo Data\t0\n", "2014-08-24\tNo Data\t0\n", "2014-08-25\tNo Data\t0\n", "2014-08-26\tNo Data\t0\n", "2014-08-27\tNo Data\t0\n", "2014-08-28\tNo Data\t0\n", "2014-08-29\tNo Data\t0\n", "2014-08-30\tNo Data\t0\n", "2014-08-31\tNo Data\t0\n", "2014-09-01\tNo Data\t0\n", "2014-09-02\tNo Data\t0\n", "2014-09-03\tNo Data\t0\n", "2014-09-04\tNo Data\t0\n", "2014-09-05\tNo Data\t0\n", "2014-09-06\tNo Data\t0\n", "2014-09-07\tNo Data\t0\n", "2014-09-08\tNo Data\t0\n", "2014-09-09\tNo Data\t0\n", "2014-09-10\tNo Data\t0\n", "2014-09-11\tNo Data\t0\n", "2014-09-12\tNo Data\t0\n", "2014-09-13\tNo Data\t0\n", "2014-09-14\tNo Data\t0\n", "2014-09-15\tNo Data\t0\n", "2014-09-16\tNo Data\t0\n", "2014-09-17\tNo Data\t0\n", "2014-09-18\tNo Data\t0\n", "2014-09-19\tNo Data\t0\n", "2014-09-20\tNo Data\t0\n", "2014-09-21\tNo Data\t0\n", "2014-09-22\tNo Data\t0\n", "2014-09-23\tNo Data\t0\n", "2014-09-24\tNo Data\t0\n", "2014-09-25\tNo Data\t0\n", "2014-09-26\tNo Data\t0\n", "2014-09-27\tNo Data\t0\n", "2014-09-28\tNo Data\t0\n", "2014-09-29\tNo Data\t0\n", "2014-09-30\tNo Data\t0\n", "2014-10-01\tNo Data\t0\n", "2014-10-02\tNo Data\t0\n", "2014-10-03\tNo Data\t0\n", "2014-10-04\tNo Data\t0\n", "2014-10-05\tNo Data\t0\n", "2014-10-06\tNo Data\t0\n", "2014-10-07\tNo Data\t0\n", "2014-10-08\tNo Data\t0\n", "2014-10-09\tNo Data\t0\n", "2014-10-10\tNo Data\t0\n", "2014-10-11\tNo Data\t0\n", "2014-10-12\tNo Data\t0\n", "2014-10-13\tNo Data\t0\n", "2014-10-14\tNo Data\t0\n", "2014-10-15\tNo Data\t0\n", "2014-10-16\tNo Data\t0\n", "2014-10-17\tNo Data\t0\n", "2014-10-18\tNo Data\t0\n", "2014-10-19\tNo Data\t0\n", "2014-10-20\tNo Data\t0\n", "2014-10-21\tNo Data\t0\n", "2014-10-22\tNo Data\t0\n", "2014-10-23\tNo Data\t0\n", "2014-10-24\tNo Data\t0\n", "2014-10-25\tNo Data\t0\n", "2014-10-26\tNo Data\t0\n", "2014-10-27\tNo Data\t0\n", "2014-10-28\tNo Data\t0\n", "2014-10-29\tIn Canada\t716\n", "2014-10-30\tIn Canada\t1415\n", "2014-10-31\tIn Canada\t1417\n", "2014-11-01\tIn Canada\t1392\n", "2014-11-02\tIn Canada\t1490\n", "2014-11-03\tIn Canada\t1419\n", "2014-11-04\tIn Canada\t1415\n", "2014-11-05\tIn Canada\t1412\n", "2014-11-06\tIn Canada\t1442\n", "2014-11-07\tIn Canada\t1430\n", "2014-11-08\tIn Canada\t1328\n", "2014-11-09\tIn Canada\t1398\n", "2014-11-10\tIn Canada\t1383\n", "2014-11-11\tIn Canada\t1426\n", "2014-11-12\tIn Canada\t1463\n", "2014-11-13\tIn Canada\t1479\n", "2014-11-14\tIn Canada\t1310\n", "2014-11-15\tIn Canada\t1415\n", "2014-11-16\tIn Canada\t1417\n", "2014-11-17\tIn Canada\t1386\n", "2014-11-18\tIn Canada\t1426\n", "2014-11-19\tIn Canada\t1411\n", "2014-11-20\tIn Canada\t1424\n", "2014-11-21\tIn Canada\t1407\n", "2014-11-22\tIn Canada\t1371\n", "2014-11-23\tIn Canada\t1370\n", "2014-11-24\tIn Canada\t1479\n", "2014-11-25\tIn Canada\t1435\n", "2014-11-26\tIn Canada\t1409\n", "2014-11-27\tIn Canada\t1456\n", "2014-11-28\tIn Canada\t1422\n", "2014-11-29\tIn Canada\t1319\n", "2014-11-30\tIn Canada\t1434\n", "2014-12-01\tIn Canada\t1439\n", "2014-12-02\tIn Canada\t1409\n", "2014-12-03\tIn Canada\t1373\n", "2014-12-04\tIn Canada\t1426\n", "2014-12-05\tLeft Canada\t1502\n", "2014-12-06\tOutside of Canada\t1208\n", "2014-12-07\tArrived in Canada\t1378\n", "2014-12-08\tIn Canada\t1399\n", "2014-12-09\tIn Canada\t1434\n", "2014-12-10\tIn Canada\t1393\n", "2014-12-11\tIn Canada\t1406\n", "2014-12-12\tIn Canada\t1438\n", "2014-12-13\tIn Canada\t1456\n", "2014-12-14\tIn Canada\t1057\n", "2014-12-15\tIn Canada\t1403\n", "2014-12-16\tIn Canada\t1446\n", "2014-12-17\tIn Canada\t1428\n", "2014-12-18\tIn Canada\t1421\n", "2014-12-19\tIn Canada\t1432\n", "2014-12-20\tIn Canada\t1423\n", "2014-12-21\tIn Canada\t1299\n", "2014-12-22\tIn Canada\t10\n", "2014-12-23\tOutside of Canada\t380\n", "2014-12-24\tOutside of Canada\t1181\n", "2014-12-25\tOutside of Canada\t1193\n", "2014-12-26\tOutside of Canada\t1305\n", "2014-12-27\tOutside of Canada\t1192\n", "2014-12-28\tOutside of Canada\t1024\n", "2014-12-29\tOutside of Canada\t1285\n", "2014-12-30\tOutside of Canada\t1178\n", "2014-12-31\tOutside of Canada\t1005\n", "2015-01-01\tOutside of Canada\t1272\n", "2015-01-02\tOutside of Canada\t1235\n", "2015-01-03\tOutside of Canada\t1363\n", "2015-01-04\tOutside of Canada\t526\n", "2015-01-05\tOutside of Canada\t2\n", "2015-01-06\tOutside of Canada\t261\n", "2015-01-07\tOutside of Canada\t1106\n", "2015-01-08\tOutside of Canada\t1284\n", "2015-01-09\tOutside of Canada\t1279\n", "2015-01-10\tOutside of Canada\t1176\n", "2015-01-11\tOutside of Canada\t1246\n", "2015-01-12\tOutside of Canada\t1401\n", "2015-01-13\tOutside of Canada\t1402\n", "2015-01-14\tOutside of Canada\t1297\n", "2015-01-15\tOutside of Canada\t1393\n", "2015-01-16\tOutside of Canada\t1418\n", "2015-01-17\tOutside of Canada\t875\n", "2015-01-18\tOutside of Canada\t1304\n", "2015-01-19\tOutside of Canada\t1030\n", "2015-01-20\tOutside of Canada\t1001\n", "2015-01-21\tOutside of Canada\t1402\n", "2015-01-22\tOutside of Canada\t1220\n", "2015-01-23\tOutside of Canada\t1163\n", "2015-01-24\tArrived in Canada\t1079\n", "2015-01-25\tIn Canada\t1441\n", "2015-01-26\tIn Canada\t1386\n", "2015-01-27\tIn Canada\t1411\n", "2015-01-28\tIn Canada\t1437\n", "2015-01-29\tIn Canada\t1367\n", "2015-01-30\tIn Canada\t1403\n", "2015-01-31\tIn Canada\t1336\n", "2015-02-01\tIn Canada\t1388\n", "2015-02-02\tIn Canada\t1415\n", "2015-02-03\tIn Canada\t1420\n", "2015-02-04\tIn Canada\t1392\n", "2015-02-05\tIn Canada\t1408\n", "2015-02-06\tIn Canada\t1434\n", "2015-02-07\tIn Canada\t1392\n", "2015-02-08\tIn Canada\t1424\n", "2015-02-09\tIn Canada\t1415\n", "2015-02-10\tIn Canada\t1352\n", "2015-02-11\tIn Canada\t1431\n", "2015-02-12\tIn Canada\t1400\n", "2015-02-13\tIn Canada\t1414\n", "2015-02-14\tIn Canada\t1242\n", "2015-02-15\tIn Canada\t1423\n", "2015-02-16\tIn Canada\t1527\n", "2015-02-17\tIn Canada\t1408\n", "2015-02-18\tIn Canada\t1422\n", "2015-02-19\tIn Canada\t1423\n", "2015-02-20\tIn Canada\t1406\n", "2015-02-21\tIn Canada\t1210\n", "2015-02-22\tIn Canada\t1275\n", "2015-02-23\tIn Canada\t1427\n", "2015-02-24\tIn Canada\t1425\n", "2015-02-25\tIn Canada\t1408\n", "2015-02-26\tIn Canada\t1405\n", "2015-02-27\tIn Canada\t1430\n", "2015-02-28\tIn Canada\t1408\n", "2015-03-01\tIn Canada\t1423\n", "2015-03-02\tIn Canada\t1426\n", "2015-03-03\tIn Canada\t1404\n", "2015-03-04\tIn Canada\t1117\n", "2015-03-05\tIn Canada\t1402\n", "2015-03-06\tIn Canada\t1421\n", "2015-03-07\tIn Canada\t1427\n", "2015-03-08\tIn Canada\t1353\n", "2015-03-09\tIn Canada\t1421\n", "2015-03-10\tIn Canada\t1431\n", "2015-03-11\tIn Canada\t1348\n", "2015-03-12\tIn Canada\t1431\n", "2015-03-13\tIn Canada\t1414\n", "2015-03-14\tIn Canada\t1414\n", "2015-03-15\tIn Canada\t1417\n", "2015-03-16\tIn Canada\t1428\n", "2015-03-17\tIn Canada\t1425\n", "2015-03-18\tIn Canada\t1407\n", "2015-03-19\tIn Canada\t1354\n", "2015-03-20\tIn Canada\t1324\n", "2015-03-21\tIn Canada\t1371\n", "2015-03-22\tIn Canada\t1489\n", "2015-03-23\tIn Canada\t1393\n", "2015-03-24\tIn Canada\t1404\n", "2015-03-25\tIn Canada\t1406\n", "2015-03-26\tIn Canada\t1370\n", "2015-03-27\tIn Canada\t1377\n", "2015-03-28\tIn Canada\t1347\n", "2015-03-29\tIn Canada\t1351\n", "2015-03-30\tIn Canada\t1421\n", "2015-03-31\tIn Canada\t1386\n", "2015-04-01\tIn Canada\t1393\n", "2015-04-02\tIn Canada\t1496\n", "2015-04-03\tIn Canada\t1415\n", "2015-04-04\tIn Canada\t1398\n", "2015-04-05\tIn Canada\t1405\n", "2015-04-06\tIn Canada\t1467\n", "2015-04-07\tIn Canada\t1408\n", "2015-04-08\tIn Canada\t1409\n", "2015-04-09\tIn Canada\t1425\n", "2015-04-10\tIn Canada\t1423\n", "2015-04-11\tIn Canada\t1413\n", "2015-04-12\tIn Canada\t1403\n", "2015-04-13\tIn Canada\t1373\n", "2015-04-14\tIn Canada\t1398\n", "2015-04-15\tIn Canada\t1406\n", "2015-04-16\tIn Canada\t1314\n", "2015-04-17\tLeft Canada\t891\n", "2015-04-18\tOutside of Canada\t78\n", "2015-04-19\tOutside of Canada\t366\n", "2015-04-20\tOutside of Canada\t694\n", "2015-04-21\tOutside of Canada\t1297\n", "2015-04-22\tOutside of Canada\t1218\n", "2015-04-23\tArrived in Canada\t1078\n", "2015-04-24\tIn Canada\t1409\n", "2015-04-25\tIn Canada\t1391\n", "2015-04-26\tIn Canada\t1414\n", "2015-04-27\tIn Canada\t1374\n", "2015-04-28\tIn Canada\t1411\n", "2015-04-29\tIn Canada\t1406\n", "2015-04-30\tIn Canada\t1403\n", "2015-05-01\tIn Canada\t1419\n", "2015-05-02\tIn Canada\t1373\n", "2015-05-03\tIn Canada\t1421\n", "2015-05-04\tIn Canada\t1379\n", "2015-05-05\tIn Canada\t1416\n", "2015-05-06\tIn Canada\t1390\n", "2015-05-07\tIn Canada\t1394\n", "2015-05-08\tIn Canada\t1415\n", "2015-05-09\tIn Canada\t1402\n", "2015-05-10\tIn Canada\t1412\n", "2015-05-11\tIn Canada\t1417\n", "2015-05-12\tIn Canada\t1389\n", "2015-05-13\tIn Canada\t1432\n", "2015-05-14\tIn Canada\t1413\n", "2015-05-15\tIn Canada\t1437\n", "2015-05-16\tIn Canada\t1399\n", "2015-05-17\tIn Canada\t1425\n", "2015-05-18\tIn Canada\t1392\n", "2015-05-19\tIn Canada\t1392\n", "2015-05-20\tIn Canada\t1407\n", "2015-05-21\tIn Canada\t1396\n", "2015-05-22\tIn Canada\t1374\n", "2015-05-23\tIn Canada\t1470\n", "2015-05-24\tIn Canada\t1358\n", "2015-05-25\tIn Canada\t1406\n", "2015-05-26\tIn Canada\t1393\n", "2015-05-27\tIn Canada\t1331\n", "2015-05-28\tIn Canada\t1389\n", "2015-05-29\tIn Canada\t1410\n", "2015-05-30\tIn Canada\t1395\n", "2015-05-31\tIn Canada\t1378\n", "2015-06-01\tIn Canada\t1345\n", "2015-06-02\tIn Canada\t1421\n", "2015-06-03\tIn Canada\t2338\n", "2015-06-04\tIn Canada\t3017\n", "2015-06-05\tIn Canada\t2084\n", "2015-06-06\tIn Canada\t1393\n", "2015-06-07\tIn Canada\t1349\n", "2015-06-08\tIn Canada\t2176\n", "2015-06-09\tIn Canada\t1393\n", "2015-06-10\tIn Canada\t1423\n", "2015-06-11\tIn Canada\t2068\n", "2015-06-12\tIn Canada\t1410\n", "2015-06-13\tIn Canada\t1363\n", "2015-06-14\tIn Canada\t1402\n", "2015-06-15\tIn Canada\t2888\n", "2015-06-16\tIn Canada\t1332\n", "2015-06-17\tIn Canada\t3409\n", "2015-06-18\tIn Canada\t1456\n", "2015-06-19\tIn Canada\t1957\n", "2015-06-20\tIn Canada\t1400\n", "2015-06-21\tIn Canada\t1390\n", "2015-06-22\tIn Canada\t3292\n", "2015-06-23\tIn Canada\t1397\n", "2015-06-24\tIn Canada\t2924\n", "2015-06-25\tIn Canada\t1395\n", "2015-06-26\tIn Canada\t2125\n", "2015-06-27\tIn Canada\t1383\n", "2015-06-28\tIn Canada\t1382\n", "2015-06-29\tIn Canada\t1405\n", "2015-06-30\tIn Canada\t1386\n", "2015-07-01\tIn Canada\t1406\n", "2015-07-02\tIn Canada\t1199\n", "2015-07-03\tIn Canada\t1410\n", "2015-07-04\tIn Canada\t1677\n", "2015-07-05\tIn Canada\t1902\n", "2015-07-06\tIn Canada\t1415\n", "2015-07-07\tIn Canada\t1332\n", "2015-07-08\tIn Canada\t2102\n", "2015-07-09\tIn Canada\t1365\n", "2015-07-10\tIn Canada\t2924\n", "2015-07-11\tIn Canada\t1380\n", "2015-07-12\tIn Canada\t1352\n", "2015-07-13\tIn Canada\t1241\n", "2015-07-14\tIn Canada\t1396\n", "2015-07-15\tIn Canada\t2120\n", "2015-07-16\tIn Canada\t1384\n", "2015-07-17\tIn Canada\t1224\n", "2015-07-18\tIn Canada\t2023\n", "2015-07-19\tIn Canada\t1688\n", "2015-07-20\tIn Canada\t2214\n", "2015-07-21\tIn Canada\t1423\n", "2015-07-22\tIn Canada\t1349\n", "2015-07-23\tIn Canada\t2733\n", "2015-07-24\tIn Canada\t1077\n", "2015-07-25\tIn Canada\t2732\n", "2015-07-26\tIn Canada\t1388\n", "2015-07-27\tIn Canada\t2423\n", "2015-07-28\tIn Canada\t1357\n", "2015-07-29\tIn Canada\t2150\n", "2015-07-30\tIn Canada\t2921\n", "2015-07-31\tIn Canada\t2131\n", "2015-08-01\tIn Canada\t1406\n", "2015-08-02\tIn Canada\t1363\n", "2015-08-03\tLeft Canada\t57703\n", "2015-08-04\tOutside of Canada\t5258\n", "2015-08-05\tOutside of Canada\t4869\n", "2015-08-06\tOutside of Canada\t25392\n", "2015-08-07\tOutside of Canada\t2289\n", "2015-08-08\tOutside of Canada\t4485\n", "2015-08-09\tArrived in Canada\t51056\n", "2015-08-10\tIn Canada\t2186\n", "2015-08-11\tIn Canada\t1367\n", "2015-08-12\tIn Canada\t1402\n", "2015-08-13\tIn Canada\t1286\n", "2015-08-14\tIn Canada\t1380\n", "2015-08-15\tIn Canada\t1376\n", "2015-08-16\tIn Canada\t1377\n", "2015-08-17\tIn Canada\t1394\n", "2015-08-18\tIn Canada\t1287\n", "2015-08-19\tIn Canada\t1398\n", "2015-08-20\tIn Canada\t1396\n", "2015-08-21\tIn Canada\t1415\n", "2015-08-22\tIn Canada\t1382\n", "2015-08-23\tIn Canada\t1342\n", "2015-08-24\tIn Canada\t1386\n", "2015-08-25\tIn Canada\t1371\n", "2015-08-26\tIn Canada\t1370\n", "2015-08-27\tIn Canada\t1263\n", "2015-08-28\tIn Canada\t1321\n", "2015-08-29\tIn Canada\t784\n", "2015-08-30\tIn Canada\t614\n", "2015-08-31\tIn Canada\t962\n", "2015-09-01\tIn Canada\t536\n", "2015-09-02\tNo Data\t0\n", "2015-09-03\tNo Data\t0\n", "2015-09-04\tIn Canada\t24\n", "2015-09-05\tIn Canada\t4\n", "2015-09-06\tIn Canada\t1422\n", "2015-09-07\tIn Canada\t1010\n", "2015-09-08\tNo Data\t0\n", "2015-09-09\tIn Canada\t6\n", "2015-09-10\tIn Canada\t49\n", "2015-09-11\tIn Canada\t71\n", "2015-09-12\tIn Canada\t71\n", "2015-09-13\tNo Data\t0\n", "2015-09-14\tIn Canada\t7\n", "2015-09-15\tNo Data\t0\n", "2015-09-16\tNo Data\t0\n", "2015-09-17\tIn Canada\t2\n", "2015-09-18\tNo Data\t0\n", "2015-09-19\tNo Data\t0\n", "2015-09-20\tIn Canada\t32\n", "2015-09-21\tIn Canada\t74\n", "2015-09-22\tIn Canada\t54\n", "2015-09-23\tIn Canada\t161\n", "2015-09-24\tIn Canada\t705\n", "2015-09-25\tIn Canada\t1462\n", "2015-09-26\tIn Canada\t898\n", "2015-09-27\tIn Canada\t730\n", "2015-09-28\tIn Canada\t709\n", "2015-09-29\tIn Canada\t661\n", "2015-09-30\tIn Canada\t745\n", "2015-10-01\tIn Canada\t748\n", "2015-10-02\tIn Canada\t832\n", "2015-10-03\tIn Canada\t698\n", "2015-10-04\tIn Canada\t1418\n", "2015-10-05\tIn Canada\t747\n", "2015-10-06\tIn Canada\t826\n", "2015-10-07\tIn Canada\t920\n", "2015-10-08\tIn Canada\t982\n", "2015-10-09\tIn Canada\t693\n", "2015-10-10\tIn Canada\t914\n", "2015-10-11\tIn Canada\t684\n", "2015-10-12\tIn Canada\t687\n", "2015-10-13\tIn Canada\t791\n", "2015-10-14\tIn Canada\t727\n", "2015-10-15\tIn Canada\t776\n", "2015-10-16\tIn Canada\t692\n", "2015-10-17\tIn Canada\t678\n", "2015-10-18\tIn Canada\t721\n", "2015-10-19\tIn Canada\t671\n", "2015-10-20\tIn Canada\t713\n", "2015-10-21\tIn Canada\t910\n", "2015-10-22\tIn Canada\t979\n", "2015-10-23\tIn Canada\t913\n", "2015-10-24\tIn Canada\t755\n", "2015-10-25\tIn Canada\t756\n", "2015-10-26\tIn Canada\t869\n", "2015-10-27\tIn Canada\t799\n", "2015-10-28\tIn Canada\t786\n", "2015-10-29\tIn Canada\t675\n", "2015-10-30\tIn Canada\t716\n", "2015-10-31\tIn Canada\t204\n", "2015-11-01\tIn Canada\t380\n", "2015-11-02\tIn Canada\t628\n", "2015-11-03\tIn Canada\t1074\n", "2015-11-04\tIn Canada\t1151\n", "2015-11-05\tIn Canada\t1133\n", "2015-11-06\tIn Canada\t1160\n", "2015-11-07\tIn Canada\t1175\n", "2015-11-08\tIn Canada\t4148\n", "2015-11-09\tIn Canada\t1132\n", "2015-11-10\tIn Canada\t1117\n", "2015-11-11\tIn Canada\t1173\n", "2015-11-12\tIn Canada\t1163\n", "2015-11-13\tIn Canada\t781\n", "2015-11-14\tIn Canada\t429\n", "2015-11-15\tIn Canada\t455\n", "2015-11-16\tIn Canada\t390\n", "2015-11-17\tIn Canada\t477\n", "2015-11-18\tIn Canada\t486\n", "2015-11-19\tIn Canada\t455\n", "2015-11-20\tIn Canada\t486\n", "2015-11-21\tIn Canada\t445\n", "2015-11-22\tIn Canada\t506\n", "2015-11-23\tIn Canada\t496\n", "2015-11-24\tIn Canada\t496\n", "2015-11-25\tIn Canada\t443\n", "2015-11-26\tIn Canada\t488\n", "2015-11-27\tIn Canada\t469\n", "2015-11-28\tIn Canada\t456\n", "2015-11-29\tIn Canada\t326\n", "2015-11-30\tIn Canada\t424\n", "2015-12-01\tIn Canada\t452\n", "2015-12-02\tIn Canada\t460\n", "2015-12-03\tIn Canada\t422\n", "2015-12-04\tIn Canada\t1310\n", "2015-12-05\tIn Canada\t432\n", "2015-12-06\tIn Canada\t393\n", "2015-12-07\tIn Canada\t672\n", "2015-12-08\tIn Canada\t1141\n", "2015-12-09\tIn Canada\t1453\n", "2015-12-10\tIn Canada\t1493\n", "2015-12-11\tIn Canada\t1178\n", "2015-12-12\tIn Canada\t1174\n", "2015-12-13\tArrived in Canada\t1185\n", "2015-12-14\tIn Canada\t582\n", "2015-12-15\tIn Canada\t477\n", "2015-12-16\tIn Canada\t662\n", "2015-12-17\tIn Canada\t703\n", "2015-12-18\tIn Canada\t740\n", "2015-12-19\tIn Canada\t467\n", "2015-12-20\tIn Canada\t714\n", "2015-12-21\tIn Canada\t650\n", "2015-12-22\tIn Canada\t669\n", "2015-12-23\tIn Canada\t731\n", "2015-12-24\tIn Canada\t816\n", "2015-12-25\tIn Canada\t690\n", "2015-12-26\tIn Canada\t878\n", "2015-12-27\tIn Canada\t941\n", "2015-12-28\tIn Canada\t1176\n", "2015-12-29\tIn Canada\t754\n", "2015-12-30\tIn Canada\t940\n", "2015-12-31\tIn Canada\t1484\n", "2016-01-01\tIn Canada\t1460\n", "2016-01-02\tIn Canada\t1603\n", "2016-01-03\tIn Canada\t747\n", "2016-01-04\tIn Canada\t862\n", "2016-01-05\tIn Canada\t880\n", "2016-01-06\tIn Canada\t673\n", "2016-01-07\tIn Canada\t687\n", "2016-01-08\tIn Canada\t605\n", "2016-01-09\tIn Canada\t723\n", "2016-01-10\tIn Canada\t618\n", "2016-01-11\tIn Canada\t530\n", "2016-01-12\tIn Canada\t2463\n", "2016-01-13\tIn Canada\t3890\n", "2016-01-14\tIn Canada\t4111\n", "2016-01-15\tIn Canada\t2922\n", "2016-01-16\tIn Canada\t3046\n", "2016-01-17\tIn Canada\t1684\n", "2016-01-18\tIn Canada\t4295\n", "2016-01-19\tIn Canada\t669\n", "2016-01-20\tIn Canada\t788\n", "2016-01-21\tIn Canada\t674\n", "2016-01-22\tIn Canada\t727\n", "2016-01-23\tIn Canada\t606\n", "2016-01-24\tIn Canada\t630\n", "2016-01-25\tIn Canada\t860\n", "2016-01-26\tIn Canada\t1012\n", "2016-01-27\tIn Canada\t715\n", "2016-01-28\tIn Canada\t679\n", "2016-01-29\tIn Canada\t670\n", "2016-01-30\tIn Canada\t1526\n", "2016-01-31\tIn Canada\t4445\n", "2016-02-01\tIn Canada\t1985\n", "2016-02-02\tIn Canada\t747\n", "2016-02-03\tIn Canada\t867\n", "2016-02-04\tIn Canada\t918\n", "2016-02-05\tIn Canada\t979\n", "2016-02-06\tIn Canada\t886\n", "2016-02-07\tIn Canada\t836\n", "2016-02-08\tIn Canada\t809\n", "2016-02-09\tIn Canada\t756\n", "2016-02-10\tIn Canada\t770\n", "2016-02-11\tIn Canada\t931\n", "2016-02-12\tIn Canada\t1198\n", "2016-02-13\tIn Canada\t714\n", "2016-02-14\tIn Canada\t882\n", "2016-02-15\tIn Canada\t857\n", "2016-02-16\tIn Canada\t1043\n", "2016-02-17\tIn Canada\t887\n", "2016-02-18\tIn Canada\t910\n", "2016-02-19\tIn Canada\t876\n", "2016-02-20\tIn Canada\t736\n", "2016-02-21\tIn Canada\t597\n", "2016-02-22\tIn Canada\t782\n", "2016-02-23\tIn Canada\t733\n", "2016-02-24\tIn Canada\t493\n", "2016-02-25\tIn Canada\t983\n", "2016-02-26\tIn Canada\t848\n", "2016-02-27\tIn Canada\t2647\n", "2016-02-28\tIn Canada\t4067\n", "2016-02-29\tIn Canada\t783\n", "2016-03-01\tIn Canada\t982\n", "2016-03-02\tIn Canada\t895\n", "2016-03-03\tIn Canada\t825\n", "2016-03-04\tIn Canada\t727\n", "2016-03-05\tIn Canada\t625\n", "2016-03-06\tIn Canada\t722\n", "2016-03-07\tIn Canada\t1640\n", "2016-03-08\tIn Canada\t763\n", "2016-03-09\tIn Canada\t1871\n", "2016-03-10\tIn Canada\t1080\n", "2016-03-11\tIn Canada\t760\n", "2016-03-12\tIn Canada\t451\n", "2016-03-13\tIn Canada\t746\n", "2016-03-14\tIn Canada\t763\n", "2016-03-15\tIn Canada\t667\n", "2016-03-16\tIn Canada\t1068\n", "2016-03-17\tLeft Canada\t30625\n", "2016-03-18\tOutside of Canada\t18187\n", "2016-03-19\tOutside of Canada\t15335\n", "2016-03-20\tOutside of Canada\t47295\n", "2016-03-21\tOutside of Canada\t59739\n", "2016-03-22\tOutside of Canada\t7001\n", "2016-03-23\tOutside of Canada\t12160\n", "2016-03-24\tOutside of Canada\t3573\n", "2016-03-25\tOutside of Canada\t21391\n", "2016-03-26\tArrived in Canada\t26242\n", "2016-03-27\tIn Canada\t456\n", "2016-03-28\tIn Canada\t796\n", "2016-03-29\tIn Canada\t709\n", "2016-03-30\tIn Canada\t832\n", "2016-03-31\tIn Canada\t671\n", "2016-04-01\tIn Canada\t814\n", "2016-04-02\tIn Canada\t511\n", "2016-04-03\tIn Canada\t498\n", "2016-04-04\tIn Canada\t657\n", "2016-04-05\tIn Canada\t723\n", "2016-04-06\tIn Canada\t718\n", "2016-04-07\tIn Canada\t731\n", "2016-04-08\tIn Canada\t707\n", "2016-04-09\tIn Canada\t583\n", "2016-04-10\tIn Canada\t1053\n", "2016-04-11\tIn Canada\t843\n", "2016-04-12\tIn Canada\t611\n", "2016-04-13\tIn Canada\t547\n", "2016-04-14\tIn Canada\t562\n", "2016-04-15\tIn Canada\t627\n", "2016-04-16\tIn Canada\t3634\n", "2016-04-17\tIn Canada\t1366\n", "2016-04-18\tIn Canada\t390\n", "2016-04-19\tIn Canada\t785\n", "2016-04-20\tIn Canada\t783\n", "2016-04-21\tIn Canada\t2111\n", "2016-04-22\tIn Canada\t610\n", "2016-04-23\tIn Canada\t398\n", "2016-04-24\tIn Canada\t456\n", "2016-04-25\tIn Canada\t757\n", "2016-04-26\tIn Canada\t823\n", "2016-04-27\tIn Canada\t612\n", "2016-04-28\tIn Canada\t831\n", "2016-04-29\tIn Canada\t771\n", "2016-04-30\tIn Canada\t568\n", "2016-05-01\tIn Canada\t789\n", "2016-05-02\tIn Canada\t695\n", "2016-05-03\tIn Canada\t701\n", "2016-05-04\tIn Canada\t737\n", "2016-05-05\tIn Canada\t718\n", "2016-05-06\tIn Canada\t789\n", "2016-05-07\tIn Canada\t566\n", "2016-05-08\tIn Canada\t625\n", "2016-05-09\tIn Canada\t678\n", "2016-05-10\tIn Canada\t698\n", "2016-05-11\tIn Canada\t855\n", "2016-05-12\tIn Canada\t1690\n", "2016-05-13\tIn Canada\t661\n", "2016-05-14\tIn Canada\t647\n", "2016-05-15\tIn Canada\t559\n", "2016-05-16\tIn Canada\t739\n", "2016-05-17\tIn Canada\t519\n", "2016-05-18\tIn Canada\t668\n", "2016-05-19\tIn Canada\t770\n", "2016-05-20\tIn Canada\t767\n", "2016-05-21\tIn Canada\t596\n", "2016-05-22\tIn Canada\t754\n", "2016-05-23\tIn Canada\t902\n", "2016-05-24\tIn Canada\t742\n", "2016-05-25\tIn Canada\t645\n", "2016-05-26\tIn Canada\t703\n", "2016-05-27\tIn Canada\t802\n", "2016-05-28\tIn Canada\t818\n", "2016-05-29\tIn Canada\t538\n", "2016-05-30\tIn Canada\t1804\n", "2016-05-31\tIn Canada\t740\n", "2016-06-01\tIn Canada\t884\n", "2016-06-02\tIn Canada\t737\n", "2016-06-03\tIn Canada\t1003\n", "2016-06-04\tIn Canada\t4932\n", "2016-06-05\tIn Canada\t15718\n", "2016-06-06\tIn Canada\t688\n", "2016-06-07\tIn Canada\t723\n", "2016-06-08\tIn Canada\t660\n", "2016-06-09\tIn Canada\t672\n", "2016-06-10\tIn Canada\t617\n", "2016-06-11\tIn Canada\t505\n", "2016-06-12\tIn Canada\t585\n", "2016-06-13\tIn Canada\t737\n", "2016-06-14\tIn Canada\t692\n", "2016-06-15\tIn Canada\t712\n", "2016-06-16\tIn Canada\t660\n", "2016-06-17\tIn Canada\t1181\n", "2016-06-18\tIn Canada\t712\n", "2016-06-19\tIn Canada\t542\n", "2016-06-20\tIn Canada\t720\n", "2016-06-21\tIn Canada\t623\n", "2016-06-22\tIn Canada\t1302\n", "2016-06-23\tIn Canada\t2356\n", "2016-06-24\tIn Canada\t1964\n", "2016-06-25\tIn Canada\t1670\n", "2016-06-26\tIn Canada\t1477\n", "2016-06-27\tIn Canada\t1907\n", "2016-06-28\tIn Canada\t823\n", "2016-06-29\tIn Canada\t900\n", "2016-06-30\tIn Canada\t930\n", "2016-07-01\tIn Canada\t992\n", "2016-07-02\tIn Canada\t646\n", "2016-07-03\tIn Canada\t958\n", "2016-07-04\tIn Canada\t699\n", "2016-07-05\tIn Canada\t676\n", "2016-07-06\tIn Canada\t868\n", "2016-07-07\tIn Canada\t874\n", "2016-07-08\tIn Canada\t854\n", "2016-07-09\tIn Canada\t1351\n", "2016-07-10\tIn Canada\t1109\n", "2016-07-11\tIn Canada\t644\n", "2016-07-12\tIn Canada\t728\n", "2016-07-13\tIn Canada\t618\n", "2016-07-14\tIn Canada\t648\n", "2016-07-15\tIn Canada\t679\n", "2016-07-16\tIn Canada\t559\n", "2016-07-17\tIn Canada\t508\n", "2016-07-18\tIn Canada\t619\n", "2016-07-19\tIn Canada\t728\n", "2016-07-20\tIn Canada\t773\n", "2016-07-21\tIn Canada\t694\n", "2016-07-22\tIn Canada\t855\n", "2016-07-23\tIn Canada\t754\n", "2016-07-24\tIn Canada\t639\n", "2016-07-25\tIn Canada\t896\n", "2016-07-26\tIn Canada\t802\n", "2016-07-27\tIn Canada\t809\n", "2016-07-28\tIn Canada\t711\n", "2016-07-29\tIn Canada\t888\n", "2016-07-30\tIn Canada\t938\n", "2016-07-31\tIn Canada\t834\n", "2016-08-01\tIn Canada\t626\n", "2016-08-02\tIn Canada\t861\n", "2016-08-03\tIn Canada\t773\n", "2016-08-04\tIn Canada\t791\n", "2016-08-05\tIn Canada\t707\n", "2016-08-06\tIn Canada\t697\n", "2016-08-07\tIn Canada\t517\n", "2016-08-08\tIn Canada\t741\n", "2016-08-09\tIn Canada\t817\n", "2016-08-10\tIn Canada\t449\n", "2016-08-11\tIn Canada\t837\n", "2016-08-12\tIn Canada\t4725\n", "2016-08-13\tIn Canada\t1116\n", "2016-08-14\tIn Canada\t902\n", "2016-08-15\tIn Canada\t807\n", "2016-08-16\tIn Canada\t816\n", "2016-08-17\tIn Canada\t442\n", "2016-08-18\tIn Canada\t852\n", "2016-08-19\tIn Canada\t1023\n", "2016-08-20\tIn Canada\t617\n", "2016-08-21\tIn Canada\t573\n", "2016-08-22\tIn Canada\t760\n", "2016-08-23\tIn Canada\t751\n", "2016-08-24\tIn Canada\t773\n", "2016-08-25\tIn Canada\t767\n", "2016-08-26\tIn Canada\t855\n", "2016-08-27\tIn Canada\t777\n", "2016-08-28\tIn Canada\t615\n", "2016-08-29\tIn Canada\t707\n", "2016-08-30\tIn Canada\t678\n", "2016-08-31\tIn Canada\t845\n", "2016-09-01\tIn Canada\t786\n", "2016-09-02\tIn Canada\t883\n", "2016-09-03\tIn Canada\t532\n", "2016-09-04\tIn Canada\t553\n", "2016-09-05\tIn Canada\t460\n", "2016-09-06\tIn Canada\t591\n", "2016-09-07\tIn Canada\t555\n", "2016-09-08\tIn Canada\t520\n", "2016-09-09\tIn Canada\t885\n", "2016-09-10\tIn Canada\t1022\n", "2016-09-11\tIn Canada\t879\n", "2016-09-12\tIn Canada\t1040\n", "2016-09-13\tIn Canada\t814\n", "2016-09-14\tIn Canada\t984\n", "2016-09-15\tIn Canada\t1025\n", "2016-09-16\tIn Canada\t947\n", "2016-09-17\tIn Canada\t1214\n", "2016-09-18\tIn Canada\t777\n", "2016-09-19\tIn Canada\t995\n", "2016-09-20\tIn Canada\t1197\n", "2016-09-21\tIn Canada\t1007\n", "2016-09-22\tIn Canada\t1334\n", "2016-09-23\tIn Canada\t1042\n", "2016-09-24\tIn Canada\t1118\n", "2016-09-25\tIn Canada\t1230\n", "2016-09-26\tIn Canada\t1411\n", "2016-09-27\tIn Canada\t1404\n", "2016-09-28\tIn Canada\t1377\n", "2016-09-29\tIn Canada\t1322\n", "2016-09-30\tIn Canada\t1663\n", "2016-10-01\tIn Canada\t2039\n", "2016-10-02\tIn Canada\t1837\n", "2016-10-03\tIn Canada\t1837\n", "2016-10-04\tIn Canada\t1933\n", "2016-10-05\tIn Canada\t1786\n", "2016-10-06\tIn Canada\t1853\n", "2016-10-07\tIn Canada\t2577\n", "2016-10-08\tIn Canada\t2138\n", "2016-10-09\tIn Canada\t2469\n", "2016-10-10\tIn Canada\t2359\n", "2016-10-11\tIn Canada\t1876\n", "2016-10-12\tIn Canada\t1840\n", "2016-10-13\tIn Canada\t1877\n", "2016-10-14\tIn Canada\t1920\n", "2016-10-15\tIn Canada\t1660\n", "2016-10-16\tIn Canada\t1854\n", "2016-10-17\tIn Canada\t1930\n", "2016-10-18\tIn Canada\t2066\n", "2016-10-19\tIn Canada\t2011\n", "2016-10-20\tIn Canada\t1832\n", "2016-10-21\tLeft Canada\t2073\n", "2016-10-22\tOutside of Canada\t640\n", "2016-10-23\tArrived in Canada\t2472\n", "2016-10-24\tIn Canada\t1771\n", "2016-10-25\tIn Canada\t1780\n", "2016-10-26\tIn Canada\t1740\n", "2016-10-27\tIn Canada\t1847\n", "2016-10-28\tIn Canada\t1873\n", "2016-10-29\tIn Canada\t2060\n", "2016-10-30\tIn Canada\t1774\n", "2016-10-31\tIn Canada\t1812\n", "2016-11-01\tIn Canada\t1885\n", "2016-11-02\tIn Canada\t1899\n", "2016-11-03\tIn Canada\t1833\n", "2016-11-04\tIn Canada\t1955\n", "2016-11-05\tIn Canada\t1999\n", "2016-11-06\tIn Canada\t2043\n", "2016-11-07\tIn Canada\t1601\n", "2016-11-08\tIn Canada\t1820\n", "2016-11-09\tIn Canada\t1567\n", "2016-11-10\tIn Canada\t1863\n", "2016-11-11\tIn Canada\t1871\n", "2016-11-12\tIn Canada\t852\n", "2016-11-13\tIn Canada\t1288\n", "2016-11-14\tIn Canada\t1637\n", "2016-11-15\tIn Canada\t1568\n", "2016-11-16\tIn Canada\t1399\n", "2016-11-17\tIn Canada\t1668\n", "2016-11-18\tIn Canada\t1444\n", "2016-11-19\tIn Canada\t1566\n", "2016-11-20\tLeft Canada\t1395\n", "2016-11-21\tOutside of Canada\t1711\n", "2016-11-22\tIn Canada\t1285\n", "2016-11-23\tIn Canada\t1569\n", "2016-11-24\tIn Canada\t1581\n", "2016-11-25\tIn Canada\t1572\n", "2016-11-26\tIn Canada\t1544\n", "2016-11-27\tIn Canada\t1584\n", "2016-11-28\tIn Canada\t1563\n", "2016-11-29\tIn Canada\t1916\n", "2016-11-30\tIn Canada\t3587\n", "2016-12-01\tIn Canada\t3537\n", "2016-12-02\tIn Canada\t2821\n", "2016-12-03\tIn Canada\t1508\n", "2016-12-04\tIn Canada\t1315\n", "2016-12-05\tIn Canada\t1690\n", "2016-12-06\tIn Canada\t1534\n", "2016-12-07\tIn Canada\t1613\n", "2016-12-08\tIn Canada\t1590\n", "2016-12-09\tIn Canada\t1534\n", "2016-12-10\tIn Canada\t1422\n", "2016-12-11\tIn Canada\t1417\n", "2016-12-12\tIn Canada\t1450\n", "2016-12-13\tIn Canada\t1272\n", "2016-12-14\tIn Canada\t1353\n", "2016-12-15\tIn Canada\t1238\n", "2016-12-16\tIn Canada\t1276\n", "2016-12-17\tIn Canada\t1580\n", "2016-12-18\tIn Canada\t1006\n", "2016-12-19\tIn Canada\t1200\n", "2016-12-20\tIn Canada\t1165\n", "2016-12-21\tIn Canada\t1377\n", "2016-12-22\tIn Canada\t1091\n", "2016-12-23\tIn Canada\t930\n", "2016-12-24\tIn Canada\t995\n", "2016-12-25\tIn Canada\t1809\n", "2016-12-26\tIn Canada\t99\n", "2016-12-27\tOutside of Canada\t1118\n", "2016-12-28\tOutside of Canada\t1408\n", "2016-12-29\tOutside of Canada\t1434\n", "2016-12-30\tOutside of Canada\t760\n", "2016-12-31\tOutside of Canada\t1093\n", "2017-01-01\tOutside of Canada\t1152\n", "2017-01-02\tOutside of Canada\t1337\n", "2017-01-03\tOutside of Canada\t1478\n", "2017-01-04\tOutside of Canada\t1424\n", "2017-01-05\tOutside of Canada\t1347\n", "2017-01-06\tOutside of Canada\t1153\n", "2017-01-07\tOutside of Canada\t1081\n", "2017-01-08\tOutside of Canada\t1314\n", "2017-01-09\tOutside of Canada\t1306\n", "2017-01-10\tOutside of Canada\t1100\n", "2017-01-11\tOutside of Canada\t1521\n", "2017-01-12\tOutside of Canada\t1472\n", "2017-01-13\tOutside of Canada\t1217\n", "2017-01-14\tOutside of Canada\t1089\n", "2017-01-15\tOutside of Canada\t1304\n", "2017-01-16\tOutside of Canada\t1447\n", "2017-01-17\tOutside of Canada\t1416\n", "2017-01-18\tOutside of Canada\t1830\n", "2017-01-19\tOutside of Canada\t1296\n", "2017-01-20\tOutside of Canada\t1475\n", "2017-01-21\tArrived in Canada\t1861\n", "2017-01-22\tIn Canada\t1188\n", "2017-01-23\tIn Canada\t1375\n", "2017-01-24\tIn Canada\t1221\n", "2017-01-25\tIn Canada\t1528\n", "2017-01-26\tIn Canada\t1347\n", "2017-01-27\tIn Canada\t1260\n", "2017-01-28\tIn Canada\t1256\n", "2017-01-29\tIn Canada\t964\n", "2017-01-30\tIn Canada\t1242\n", "2017-01-31\tIn Canada\t1023\n", "2017-02-01\tIn Canada\t781\n", "2017-02-02\tIn Canada\t892\n", "2017-02-03\tIn Canada\t1295\n", "2017-02-04\tIn Canada\t919\n", "2017-02-05\tIn Canada\t803\n", "2017-02-06\tIn Canada\t1227\n", "2017-02-07\tIn Canada\t1175\n", "2017-02-08\tIn Canada\t1301\n", "2017-02-09\tIn Canada\t1181\n", "2017-02-10\tIn Canada\t1386\n", "2017-02-11\tIn Canada\t1313\n", "2017-02-12\tIn Canada\t1183\n", "2017-02-13\tIn Canada\t1205\n", "2017-02-14\tIn Canada\t1176\n", "2017-02-15\tIn Canada\t1178\n", "2017-02-16\tIn Canada\t1149\n", "2017-02-17\tIn Canada\t1132\n", "2017-02-18\tIn Canada\t2255\n", "2017-02-19\tIn Canada\t1172\n", "2017-02-20\tIn Canada\t2038\n", "2017-02-21\tIn Canada\t1184\n", "2017-02-22\tIn Canada\t1190\n", "2017-02-23\tIn Canada\t1161\n", "2017-02-24\tIn Canada\t1094\n", "2017-02-25\tIn Canada\t1200\n", "2017-02-26\tIn Canada\t873\n", "2017-02-27\tIn Canada\t924\n", "2017-02-28\tIn Canada\t1208\n", "2017-03-01\tIn Canada\t1200\n", "2017-03-02\tIn Canada\t1110\n", "2017-03-03\tIn Canada\t1125\n", "2017-03-04\tIn Canada\t1212\n", "2017-03-05\tIn Canada\t1579\n", "2017-03-06\tIn Canada\t1158\n", "2017-03-07\tIn Canada\t1116\n", "2017-03-08\tIn Canada\t1115\n", "2017-03-09\tIn Canada\t1158\n", "2017-03-10\tIn Canada\t1225\n", "2017-03-11\tIn Canada\t1119\n", "2017-03-12\tIn Canada\t988\n", "2017-03-13\tIn Canada\t1874\n", "2017-03-14\tIn Canada\t1657\n", "2017-03-15\tIn Canada\t1710\n", "2017-03-16\tIn Canada\t2099\n", "2017-03-17\tIn Canada\t1239\n", "2017-03-18\tIn Canada\t1419\n", "2017-03-19\tIn Canada\t1237\n", "2017-03-20\tIn Canada\t1123\n", "2017-03-21\tIn Canada\t1156\n", "2017-03-22\tIn Canada\t1114\n", "2017-03-23\tIn Canada\t1136\n", "2017-03-24\tLeft Canada\t1755\n", "2017-03-25\tOutside of Canada\t2010\n", "2017-03-26\tArrived in Canada\t2050\n", "2017-03-27\tIn Canada\t1110\n", "2017-03-28\tIn Canada\t1088\n", "2017-03-29\tIn Canada\t1060\n", "2017-03-30\tIn Canada\t1087\n", "2017-03-31\tIn Canada\t1265\n", "2017-04-01\tIn Canada\t1124\n", "2017-04-02\tIn Canada\t1223\n", "2017-04-03\tIn Canada\t1198\n", "2017-04-04\tIn Canada\t1090\n", "2017-04-05\tIn Canada\t1181\n", "2017-04-06\tIn Canada\t1161\n", "2017-04-07\tIn Canada\t1166\n", "2017-04-08\tIn Canada\t1326\n", "2017-04-09\tIn Canada\t1245\n", "2017-04-10\tIn Canada\t1648\n", "2017-04-11\tIn Canada\t1215\n", "2017-04-12\tIn Canada\t1310\n", "2017-04-13\tIn Canada\t2090\n", "2017-04-14\tIn Canada\t1152\n", "2017-04-15\tIn Canada\t1136\n", "2017-04-16\tIn Canada\t1288\n", "2017-04-17\tIn Canada\t2012\n", "2017-04-18\tIn Canada\t1206\n", "2017-04-19\tIn Canada\t1259\n", "2017-04-20\tIn Canada\t1074\n", "2017-04-21\tIn Canada\t1219\n", "2017-04-22\tIn Canada\t1405\n", "2017-04-23\tIn Canada\t1514\n", "2017-04-24\tIn Canada\t1264\n", "2017-04-25\tIn Canada\t1265\n", "2017-04-26\tIn Canada\t1174\n", "2017-04-27\tIn Canada\t1139\n", "2017-04-28\tLeft Canada\t2354\n", "2017-04-29\tOutside of Canada\t1980\n", "2017-04-30\tArrived in Canada\t2844\n", "2017-05-01\tIn Canada\t1178\n", "2017-05-02\tIn Canada\t1199\n", "2017-05-03\tIn Canada\t1325\n", "2017-05-04\tIn Canada\t1267\n", "2017-05-05\tIn Canada\t1981\n", "2017-05-06\tIn Canada\t1891\n", "2017-05-07\tIn Canada\t1102\n", "2017-05-08\tIn Canada\t1304\n", "2017-05-09\tIn Canada\t1144\n", "2017-05-10\tIn Canada\t1112\n", "2017-05-11\tIn Canada\t1103\n", "2017-05-12\tIn Canada\t1134\n", "2017-05-13\tArrived in Canada\t1720\n", "2017-05-14\tIn Canada\t1322\n", "2017-05-15\tIn Canada\t1016\n", "2017-05-16\tIn Canada\t1217\n", "2017-05-17\tIn Canada\t1198\n", "2017-05-18\tIn Canada\t1301\n", "2017-05-19\tIn Canada\t1345\n", "2017-05-20\tIn Canada\t1451\n", "2017-05-21\tIn Canada\t1222\n", "2017-05-22\tIn Canada\t1257\n", "2017-05-23\tIn Canada\t1196\n", "2017-05-24\tIn Canada\t1294\n", "2017-05-25\tIn Canada\t1415\n", "2017-05-26\tIn Canada\t1388\n", "2017-05-27\tIn Canada\t1476\n", "2017-05-28\tIn Canada\t1414\n", "2017-05-29\tIn Canada\t1226\n", "2017-05-30\tIn Canada\t1345\n", "2017-05-31\tIn Canada\t1235\n", "2017-06-01\tIn Canada\t1724\n", "2017-06-02\tIn Canada\t1406\n", "2017-06-03\tIn Canada\t1526\n", "2017-06-04\tIn Canada\t1786\n", "2017-06-05\tIn Canada\t1340\n", "2017-06-06\tIn Canada\t1250\n", "2017-06-07\tIn Canada\t1539\n", "2017-06-08\tIn Canada\t1395\n", "2017-06-09\tIn Canada\t1375\n", "2017-06-10\tIn Canada\t1562\n", "2017-06-11\tIn Canada\t1460\n", "2017-06-12\tIn Canada\t1480\n", "2017-06-13\tIn Canada\t1495\n", "2017-06-14\tIn Canada\t1370\n", "2017-06-15\tIn Canada\t1423\n", "2017-06-16\tIn Canada\t1407\n", "2017-06-17\tIn Canada\t2033\n", "2017-06-18\tIn Canada\t2122\n", "2017-06-19\tIn Canada\t1500\n", "2017-06-20\tIn Canada\t1451\n", "2017-06-21\tIn Canada\t1348\n", "2017-06-22\tIn Canada\t1335\n", "2017-06-23\tIn Canada\t1328\n", "2017-06-24\tIn Canada\t2297\n", "2017-06-25\tIn Canada\t1410\n", "2017-06-26\tIn Canada\t1281\n", "2017-06-27\tIn Canada\t1418\n", "2017-06-28\tLeft Canada\t1912\n", "2017-06-29\tOutside of Canada\t1390\n", "2017-06-30\tArrived in Canada\t2181\n", "2017-07-01\tIn Canada\t2004\n", "2017-07-02\tIn Canada\t1610\n", "2017-07-03\tIn Canada\t1552\n", "2017-07-04\tIn Canada\t1357\n", "2017-07-05\tIn Canada\t1235\n", "2017-07-06\tIn Canada\t1412\n", "2017-07-07\tIn Canada\t1114\n", "2017-07-08\tIn Canada\t1354\n", "2017-07-09\tIn Canada\t1964\n", "2017-07-10\tIn Canada\t1919\n", "2017-07-11\tIn Canada\t1512\n", "2017-07-12\tIn Canada\t1659\n", "2017-07-13\tIn Canada\t1543\n", "2017-07-14\tIn Canada\t1917\n", "2017-07-15\tIn Canada\t2733\n", "2017-07-16\tIn Canada\t2603\n", "2017-07-17\tIn Canada\t1328\n", "2017-07-18\tIn Canada\t1503\n", "2017-07-19\tIn Canada\t1644\n", "2017-07-20\tIn Canada\t1682\n", "2017-07-21\tIn Canada\t1699\n", "2017-07-22\tIn Canada\t1904\n", "2017-07-23\tIn Canada\t1867\n", "2017-07-24\tIn Canada\t1373\n", "2017-07-25\tIn Canada\t1700\n", "2017-07-26\tIn Canada\t2933\n", "2017-07-27\tIn Canada\t1535\n", "2017-07-28\tIn Canada\t1803\n", "2017-07-29\tIn Canada\t1710\n", "2017-07-30\tIn Canada\t1529\n", "2017-07-31\tIn Canada\t1320\n", "2017-08-01\tIn Canada\t1264\n", "2017-08-02\tIn Canada\t1340\n", "2017-08-03\tIn Canada\t1331\n", "2017-08-04\tIn Canada\t1693\n", "2017-08-05\tIn Canada\t1285\n", "2017-08-06\tIn Canada\t1402\n", "2017-08-07\tIn Canada\t1620\n", "2017-08-08\tIn Canada\t1513\n", "2017-08-09\tIn Canada\t1919\n", "2017-08-10\tIn Canada\t1794\n", "2017-08-11\tIn Canada\t1542\n", "2017-08-12\tIn Canada\t1482\n", "2017-08-13\tIn Canada\t1559\n", "2017-08-14\tIn Canada\t1338\n", "2017-08-15\tIn Canada\t1416\n", "2017-08-16\tIn Canada\t1688\n", "2017-08-17\tIn Canada\t1498\n", "2017-08-18\tIn Canada\t1334\n", "2017-08-19\tIn Canada\t1505\n", "2017-08-20\tIn Canada\t1692\n", "2017-08-21\tIn Canada\t1523\n", "2017-08-22\tIn Canada\t866\n", "2017-08-23\tIn Canada\t513\n", "2017-08-24\tIn Canada\t790\n", "2017-08-25\tIn Canada\t884\n", "2017-08-26\tIn Canada\t913\n", "2017-08-27\tIn Canada\t1007\n", "2017-08-28\tIn Canada\t804\n", "2017-08-29\tIn Canada\t844\n", "2017-08-30\tIn Canada\t663\n", "2017-08-31\tIn Canada\t735\n", "2017-09-01\tIn Canada\t796\n", "2017-09-02\tIn Canada\t934\n", "2017-09-03\tIn Canada\t1227\n", "2017-09-04\tIn Canada\t673\n", "2017-09-05\tIn Canada\t935\n", "2017-09-06\tIn Canada\t825\n", "2017-09-07\tLeft Canada\t1375\n", "2017-09-08\tOutside of Canada\t2460\n", "2017-09-09\tArrived in Canada\t516\n", "2017-09-10\tIn Canada\t797\n", "2017-09-11\tLeft Canada\t1207\n", "2017-09-12\tArrived in Canada\t1053\n", "2017-09-13\tIn Canada\t702\n", "2017-09-14\tIn Canada\t991\n", "2017-09-15\tIn Canada\t720\n", "2017-09-16\tIn Canada\t821\n", "2017-09-17\tIn Canada\t1063\n", "2017-09-18\tIn Canada\t1101\n", "2017-09-19\tIn Canada\t666\n", "2017-09-20\tIn Canada\t763\n", "2017-09-21\tIn Canada\t829\n", "2017-09-22\tIn Canada\t1033\n", "2017-09-23\tLeft Canada\t1035\n", "2017-09-24\tOutside of Canada\t1956\n", "2017-09-25\tOutside of Canada\t2896\n", "2017-09-26\tOutside of Canada\t5589\n", "2017-09-27\tOutside of Canada\t900\n", "2017-09-28\tOutside of Canada\t776\n", "2017-09-29\tOutside of Canada\t925\n", "2017-09-30\tOutside of Canada\t1069\n", "2017-10-01\tOutside of Canada\t1982\n", "2017-10-02\tOutside of Canada\t581\n", "2017-10-03\tOutside of Canada\t1176\n", "2017-10-04\tOutside of Canada\t1256\n", "2017-10-05\tOutside of Canada\t1065\n", "2017-10-06\tOutside of Canada\t913\n", "2017-10-07\tOutside of Canada\t1187\n", "2017-10-08\tOutside of Canada\t1104\n", "2017-10-09\tOutside of Canada\t922\n", "2017-10-10\tOutside of Canada\t1432\n", "2017-10-11\tOutside of Canada\t982\n", "2017-10-12\tOutside of Canada\t1456\n", "2017-10-13\tOutside of Canada\t2850\n", "2017-10-14\tOutside of Canada\t5358\n", "2017-10-15\tOutside of Canada\t5199\n", "2017-10-16\tOutside of Canada\t5693\n", "2017-10-17\tOutside of Canada\t4167\n", "2017-10-18\tOutside of Canada\t5293\n", "2017-10-19\tOutside of Canada\t3753\n", "2017-10-20\tOutside of Canada\t5724\n", "2017-10-21\tOutside of Canada\t5554\n", "2017-10-22\tOutside of Canada\t5680\n", "2017-10-23\tOutside of Canada\t5020\n", "2017-10-24\tOutside of Canada\t5734\n", "2017-10-25\tOutside of Canada\t5697\n", "2017-10-26\tOutside of Canada\t5707\n", "2017-10-27\tOutside of Canada\t5736\n", "2017-10-28\tOutside of Canada\t3949\n", "2017-10-29\tOutside of Canada\t837\n", "2017-10-30\tOutside of Canada\t984\n", "2017-10-31\tOutside of Canada\t3366\n", "2017-11-01\tOutside of Canada\t5672\n", "2017-11-02\tOutside of Canada\t6555\n", "2017-11-03\tOutside of Canada\t8659\n", "2017-11-04\tOutside of Canada\t10416\n", "2017-11-05\tOutside of Canada\t9610\n", "2017-11-06\tOutside of Canada\t6132\n", "2017-11-07\tOutside of Canada\t6140\n", "2017-11-08\tOutside of Canada\t7544\n", "2017-11-09\tOutside of Canada\t7937\n", "2017-11-10\tOutside of Canada\t8670\n", "2017-11-11\tOutside of Canada\t10086\n", "2017-11-12\tOutside of Canada\t10325\n", "2017-11-13\tOutside of Canada\t10499\n", "2017-11-14\tOutside of Canada\t10478\n", "2017-11-15\tOutside of Canada\t10397\n", "2017-11-16\tOutside of Canada\t10361\n", "2017-11-17\tOutside of Canada\t10395\n", "2017-11-18\tOutside of Canada\t10505\n", "2017-11-19\tOutside of Canada\t10493\n", "2017-11-20\tOutside of Canada\t10170\n", "2017-11-21\tOutside of Canada\t10491\n", "2017-11-22\tOutside of Canada\t10313\n", "2017-11-23\tOutside of Canada\t2630\n", "2017-11-24\tOutside of Canada\t5101\n", "2017-11-25\tOutside of Canada\t6513\n", "2017-11-26\tOutside of Canada\t6625\n", "2017-11-27\tOutside of Canada\t3234\n", "2017-11-28\tOutside of Canada\t6804\n", "2017-11-29\tOutside of Canada\t6942\n", "2017-11-30\tOutside of Canada\t7228\n", "2017-12-01\tOutside of Canada\t8262\n", "2017-12-02\tOutside of Canada\t9631\n", "2017-12-03\tOutside of Canada\t11861\n", "2017-12-04\tOutside of Canada\t10512\n", "2017-12-05\tOutside of Canada\t5585\n", "2017-12-06\tOutside of Canada\t4998\n", "2017-12-07\tOutside of Canada\t3875\n", "2017-12-08\tOutside of Canada\t2617\n", "2017-12-09\tArrived in Canada\t1203\n", "2017-12-10\tLeft Canada\t742\n", "2017-12-11\tOutside of Canada\t1916\n", "2017-12-12\tOutside of Canada\t1402\n", "2017-12-13\tOutside of Canada\t1499\n", "2017-12-14\tOutside of Canada\t1844\n", "2017-12-15\tOutside of Canada\t1555\n", "2017-12-16\tOutside of Canada\t1441\n", "2017-12-17\tOutside of Canada\t1303\n", "2017-12-18\tOutside of Canada\t1390\n", "2017-12-19\tOutside of Canada\t1493\n", "2017-12-20\tOutside of Canada\t2039\n", "2017-12-21\tOutside of Canada\t1050\n", "2017-12-22\tOutside of Canada\t1272\n", "2017-12-23\tOutside of Canada\t1750\n", "2017-12-24\tOutside of Canada\t1379\n", "2017-12-25\tOutside of Canada\t1391\n", "2017-12-26\tOutside of Canada\t1588\n", "2017-12-27\tOutside of Canada\t1803\n", "2017-12-28\tOutside of Canada\t1692\n", "2017-12-29\tOutside of Canada\t1669\n", "2017-12-30\tOutside of Canada\t772\n", "2017-12-31\tArrived in Canada\t5162\n", "2018-01-01\tLeft Canada\t978\n", "2018-01-02\tOutside of Canada\t3803\n", "2018-01-03\tOutside of Canada\t3823\n", "2018-01-04\tOutside of Canada\t5409\n", "2018-01-05\tOutside of Canada\t4491\n", "2018-01-06\tOutside of Canada\t20765\n", "2018-01-07\tOutside of Canada\t45771\n", "2018-01-08\tOutside of Canada\t9474\n", "2018-01-09\tOutside of Canada\t16264\n", "2018-01-10\tOutside of Canada\t24987\n", "2018-01-11\tOutside of Canada\t8406\n", "2018-01-12\tOutside of Canada\t28375\n", "2018-01-13\tOutside of Canada\t19503\n", "2018-01-14\tOutside of Canada\t11815\n", "2018-01-15\tOutside of Canada\t11656\n", "2018-01-16\tOutside of Canada\t11022\n", "2018-01-17\tOutside of Canada\t9578\n", "2018-01-18\tOutside of Canada\t10925\n", "2018-01-19\tOutside of Canada\t9895\n", "2018-01-20\tOutside of Canada\t9696\n", "2018-01-21\tOutside of Canada\t11775\n", "2018-01-22\tOutside of Canada\t11389\n", "2018-01-23\tOutside of Canada\t9959\n", "2018-01-24\tOutside of Canada\t9740\n", "2018-01-25\tOutside of Canada\t9124\n", "2018-01-26\tOutside of Canada\t11193\n", "2018-01-27\tOutside of Canada\t10917\n", "2018-01-28\tOutside of Canada\t10680\n", "2018-01-29\tOutside of Canada\t11150\n", "2018-01-30\tOutside of Canada\t9452\n", "2018-01-31\tOutside of Canada\t10494\n", "2018-02-01\tOutside of Canada\t10875\n", "2018-02-02\tOutside of Canada\t7850\n", "2018-02-03\tOutside of Canada\t7613\n", "2018-02-04\tOutside of Canada\t10226\n", "2018-02-05\tOutside of Canada\t5213\n", "2018-02-06\tOutside of Canada\t5247\n", "2018-02-07\tOutside of Canada\t4049\n", "2018-02-08\tOutside of Canada\t4104\n", "2018-02-09\tOutside of Canada\t4965\n", "2018-02-10\tOutside of Canada\t5333\n", "2018-02-11\tOutside of Canada\t5111\n", "2018-02-12\tOutside of Canada\t5347\n", "2018-02-13\tOutside of Canada\t5476\n", "2018-02-14\tOutside of Canada\t5487\n", "2018-02-15\tOutside of Canada\t5442\n", "2018-02-16\tOutside of Canada\t5425\n", "2018-02-17\tOutside of Canada\t4544\n", "2018-02-18\tOutside of Canada\t7585\n", "2018-02-19\tOutside of Canada\t10854\n", "2018-02-20\tOutside of Canada\t10537\n", "2018-02-21\tOutside of Canada\t9805\n", "2018-02-22\tOutside of Canada\t10988\n", "2018-02-23\tOutside of Canada\t11005\n", "2018-02-24\tOutside of Canada\t10052\n", "2018-02-25\tOutside of Canada\t10370\n", "2018-02-26\tOutside of Canada\t9023\n", "2018-02-27\tOutside of Canada\t9977\n", "2018-02-28\tOutside of Canada\t10564\n", "2018-03-01\tOutside of Canada\t9773\n", "2018-03-02\tOutside of Canada\t5407\n", "2018-03-03\tOutside of Canada\t9168\n", "2018-03-04\tOutside of Canada\t9947\n", "2018-03-05\tOutside of Canada\t9094\n", "2018-03-06\tOutside of Canada\t9088\n", "2018-03-07\tOutside of Canada\t10233\n", "2018-03-08\tOutside of Canada\t9970\n", "2018-03-09\tOutside of Canada\t8226\n", "2018-03-10\tOutside of Canada\t10471\n", "2018-03-11\tOutside of Canada\t9792\n", "2018-03-12\tOutside of Canada\t6539\n", "2018-03-13\tOutside of Canada\t3475\n", "2018-03-14\tOutside of Canada\t4519\n", "2018-03-15\tOutside of Canada\t4645\n", "2018-03-16\tOutside of Canada\t4891\n", "2018-03-17\tOutside of Canada\t5613\n", "2018-03-18\tOutside of Canada\t5057\n", "2018-03-19\tOutside of Canada\t2015\n", "2018-03-20\tOutside of Canada\t2017\n", "2018-03-21\tOutside of Canada\t3535\n", "2018-03-22\tOutside of Canada\t2226\n", "2018-03-23\tOutside of Canada\t2323\n", "2018-03-24\tOutside of Canada\t1892\n", "2018-03-25\tOutside of Canada\t889\n", "2018-03-26\tOutside of Canada\t1294\n", "2018-03-27\tOutside of Canada\t2076\n", "2018-03-28\tOutside of Canada\t6521\n", "2018-03-29\tOutside of Canada\t4399\n", "2018-03-30\tOutside of Canada\t3971\n", "2018-03-31\tOutside of Canada\t2816\n", "2018-04-01\tOutside of Canada\t3557\n", "2018-04-02\tOutside of Canada\t3041\n", "2018-04-03\tOutside of Canada\t3490\n", "2018-04-04\tOutside of Canada\t1508\n", "2018-04-05\tOutside of Canada\t1308\n", "2018-04-06\tOutside of Canada\t1070\n", "2018-04-07\tOutside of Canada\t3662\n", "2018-04-08\tOutside of Canada\t5484\n", "2018-04-09\tOutside of Canada\t6403\n", "2018-04-10\tOutside of Canada\t2270\n", "2018-04-11\tOutside of Canada\t848\n", "2018-04-12\tOutside of Canada\t2480\n", "2018-04-13\tOutside of Canada\t1804\n", "2018-04-14\tOutside of Canada\t2066\n", "2018-04-15\tOutside of Canada\t3302\n", "2018-04-16\tOutside of Canada\t4046\n", "2018-04-17\tOutside of Canada\t2719\n", "2018-04-18\tOutside of Canada\t2264\n", "2018-04-19\tOutside of Canada\t6579\n", "2018-04-20\tOutside of Canada\t3765\n", "2018-04-21\tOutside of Canada\t1192\n", "2018-04-22\tOutside of Canada\t1206\n", "2018-04-23\tOutside of Canada\t1224\n", "2018-04-24\tOutside of Canada\t1414\n", "2018-04-25\tOutside of Canada\t1528\n", "2018-04-26\tOutside of Canada\t1085\n", "2018-04-27\tOutside of Canada\t1588\n", "2018-04-28\tOutside of Canada\t2216\n", "2018-04-29\tOutside of Canada\t3129\n", "2018-04-30\tOutside of Canada\t4156\n", "2018-05-01\tOutside of Canada\t4057\n", "2018-05-02\tOutside of Canada\t2494\n", "2018-05-03\tOutside of Canada\t1878\n", "2018-05-04\tOutside of Canada\t3165\n", "2018-05-05\tOutside of Canada\t4268\n", "2018-05-06\tOutside of Canada\t3899\n", "2018-05-07\tOutside of Canada\t6238\n", "2018-05-08\tOutside of Canada\t1874\n", "2018-05-09\tOutside of Canada\t2384\n", "2018-05-10\tOutside of Canada\t1990\n", "2018-05-11\tOutside of Canada\t1756\n", "2018-05-12\tOutside of Canada\t2110\n", "2018-05-13\tOutside of Canada\t3540\n", "2018-05-14\tOutside of Canada\t5877\n", "2018-05-15\tOutside of Canada\t4425\n", "2018-05-16\tOutside of Canada\t3820\n", "2018-05-17\tOutside of Canada\t2509\n", "2018-05-18\tOutside of Canada\t954\n", "2018-05-19\tOutside of Canada\t917\n", "2018-05-20\tOutside of Canada\t1778\n", "2018-05-21\tOutside of Canada\t844\n", "2018-05-22\tOutside of Canada\t1238\n", "2018-05-23\tOutside of Canada\t792\n", "2018-05-24\tOutside of Canada\t699\n", "2018-05-25\tOutside of Canada\t916\n", "2018-05-26\tOutside of Canada\t1772\n", "2018-05-27\tOutside of Canada\t1111\n", "2018-05-28\tOutside of Canada\t975\n", "2018-05-29\tOutside of Canada\t1182\n", "2018-05-30\tOutside of Canada\t1663\n", "2018-05-31\tOutside of Canada\t2522\n", "2018-06-01\tOutside of Canada\t1123\n", "2018-06-02\tOutside of Canada\t1322\n", "2018-06-03\tOutside of Canada\t1065\n", "2018-06-04\tOutside of Canada\t1097\n", "2018-06-05\tOutside of Canada\t795\n", "2018-06-06\tOutside of Canada\t1141\n", "2018-06-07\tOutside of Canada\t735\n", "2018-06-08\tOutside of Canada\t728\n", "2018-06-09\tOutside of Canada\t676\n", "2018-06-10\tOutside of Canada\t1433\n", "2018-06-11\tOutside of Canada\t1182\n", "2018-06-12\tOutside of Canada\t3708\n", "2018-06-13\tOutside of Canada\t5317\n", "2018-06-14\tOutside of Canada\t2132\n", "2018-06-15\tOutside of Canada\t953\n", "2018-06-16\tOutside of Canada\t833\n", "2018-06-17\tOutside of Canada\t918\n", "2018-06-18\tOutside of Canada\t1168\n", "2018-06-19\tOutside of Canada\t1117\n", "2018-06-20\tOutside of Canada\t885\n", "2018-06-21\tOutside of Canada\t1027\n", "2018-06-22\tOutside of Canada\t2046\n", "2018-06-23\tOutside of Canada\t2341\n", "2018-06-24\tOutside of Canada\t643\n", "2018-06-25\tOutside of Canada\t891\n", "2018-06-26\tOutside of Canada\t1553\n", "2018-06-27\tOutside of Canada\t3054\n", "2018-06-28\tOutside of Canada\t1736\n", "2018-06-29\tOutside of Canada\t2130\n", "2018-06-30\tOutside of Canada\t2658\n", "2018-07-01\tOutside of Canada\t4348\n", "2018-07-02\tOutside of Canada\t3479\n", "2018-07-03\tOutside of Canada\t1528\n", "2018-07-04\tOutside of Canada\t1261\n", "2018-07-05\tOutside of Canada\t1731\n", "2018-07-06\tOutside of Canada\t518\n", "2018-07-07\tOutside of Canada\t696\n", "2018-07-08\tOutside of Canada\t1834\n", "2018-07-09\tOutside of Canada\t893\n", "2018-07-10\tOutside of Canada\t3918\n", "2018-07-11\tOutside of Canada\t3080\n", "2018-07-12\tOutside of Canada\t3673\n", "2018-07-13\tOutside of Canada\t3576\n", "2018-07-14\tOutside of Canada\t4010\n", "2018-07-15\tOutside of Canada\t3958\n", "2018-07-16\tOutside of Canada\t4485\n", "2018-07-17\tOutside of Canada\t3104\n", "2018-07-18\tOutside of Canada\t2434\n", "2018-07-19\tOutside of Canada\t1033\n", "2018-07-20\tOutside of Canada\t268\n", "2018-07-21\tOutside of Canada\t645\n", "2018-07-22\tOutside of Canada\t976\n", "2018-07-23\tOutside of Canada\t632\n", "2018-07-24\tOutside of Canada\t854\n", "2018-07-25\tOutside of Canada\t740\n", "2018-07-26\tOutside of Canada\t879\n", "2018-07-27\tOutside of Canada\t788\n", "2018-07-28\tOutside of Canada\t829\n", "2018-07-29\tOutside of Canada\t676\n", "2018-07-30\tOutside of Canada\t887\n", "2018-07-31\tOutside of Canada\t613\n", "2018-08-01\tOutside of Canada\t717\n", "2018-08-02\tOutside of Canada\t1064\n", "2018-08-03\tOutside of Canada\t2581\n", "2018-08-04\tArrived in Canada\t1893\n", "2018-08-05\tIn Canada\t704\n", "2018-08-06\tIn Canada\t936\n", "2018-08-07\tIn Canada\t1421\n", "2018-08-08\tIn Canada\t815\n", "2018-08-09\tIn Canada\t1516\n", "2018-08-10\tIn Canada\t1075\n", "2018-08-11\tIn Canada\t648\n", "2018-08-12\tIn Canada\t1194\n", "2018-08-13\tIn Canada\t482\n", "2018-08-14\tIn Canada\t774\n", "2018-08-15\tIn Canada\t2908\n", "2018-08-16\tIn Canada\t3910\n", "2018-08-17\tIn Canada\t2918\n", "2018-08-18\tIn Canada\t1495\n", "2018-08-19\tIn Canada\t1331\n", "2018-08-20\tIn Canada\t1383\n", "2018-08-21\tIn Canada\t2270\n", "2018-08-22\tIn Canada\t1033\n", "2018-08-23\tLeft Canada\t1650\n", "2018-08-24\tOutside of Canada\t912\n", "2018-08-25\tArrived in Canada\t1059\n", "2018-08-26\tIn Canada\t2283\n", "2018-08-27\tIn Canada\t670\n", "2018-08-28\tLeft Canada\t1041\n", "2018-08-29\tOutside of Canada\t447\n", "2018-08-30\tArrived in Canada\t1650\n", "2018-08-31\tIn Canada\t822\n", "2018-09-01\tIn Canada\t900\n", "2018-09-02\tIn Canada\t636\n", "2018-09-03\tIn Canada\t776\n", "2018-09-04\tIn Canada\t923\n", "2018-09-05\tIn Canada\t515\n", "2018-09-06\tIn Canada\t1074\n", "2018-09-07\tIn Canada\t1100\n", "2018-09-08\tIn Canada\t913\n", "2018-09-09\tIn Canada\t2047\n", "2018-09-10\tIn Canada\t567\n", "2018-09-11\tIn Canada\t2487\n", "2018-09-12\tIn Canada\t553\n", "2018-09-13\tIn Canada\t444\n", "2018-09-14\tIn Canada\t864\n", "2018-09-15\tIn Canada\t756\n", "2018-09-16\tIn Canada\t2521\n", "2018-09-17\tIn Canada\t790\n", "2018-09-18\tIn Canada\t919\n", "2018-09-19\tIn Canada\t799\n", "2018-09-20\tIn Canada\t1040\n", "2018-09-21\tIn Canada\t801\n", "2018-09-22\tIn Canada\t912\n", "2018-09-23\tIn Canada\t1413\n", "2018-09-24\tIn Canada\t774\n", "2018-09-25\tIn Canada\t873\n", "2018-09-26\tLeft Canada\t1815\n", "2018-09-27\tArrived in Canada\t1079\n", "2018-09-28\tIn Canada\t1167\n", "2018-09-29\tIn Canada\t1014\n", "2018-09-30\tIn Canada\t995\n", "2018-10-01\tIn Canada\t1129\n", "2018-10-02\tIn Canada\t756\n", "2018-10-03\tIn Canada\t1241\n", "2018-10-04\tIn Canada\t734\n", "2018-10-05\tIn Canada\t1825\n", "2018-10-06\tIn Canada\t931\n", "2018-10-07\tIn Canada\t781\n", "2018-10-08\tIn Canada\t2278\n", "2018-10-09\tIn Canada\t694\n", "2018-10-10\tIn Canada\t795\n", "2018-10-11\tIn Canada\t984\n", "2018-10-12\tIn Canada\t2112\n", "2018-10-13\tIn Canada\t1014\n", "2018-10-14\tIn Canada\t1304\n", "2018-10-15\tIn Canada\t840\n", "2018-10-16\tIn Canada\t631\n", "2018-10-17\tIn Canada\t890\n", "2018-10-18\tIn Canada\t949\n", "2018-10-19\tIn Canada\t596\n", "2018-10-20\tIn Canada\t1003\n", "2018-10-21\tIn Canada\t2099\n", "2018-10-22\tIn Canada\t625\n", "2018-10-23\tIn Canada\t645\n", "2018-10-24\tIn Canada\t895\n", "2018-10-25\tIn Canada\t754\n", "2018-10-26\tIn Canada\t657\n", "2018-10-27\tIn Canada\t1673\n", "2018-10-28\tIn Canada\t888\n", "2018-10-29\tIn Canada\t644\n", "2018-10-30\tIn Canada\t817\n", "2018-10-31\tIn Canada\t808\n", "2018-11-01\tIn Canada\t854\n", "2018-11-02\tIn Canada\t2622\n", "2018-11-03\tIn Canada\t878\n", "2018-11-04\tIn Canada\t730\n", "2018-11-05\tIn Canada\t2044\n", "2018-11-06\tIn Canada\t1081\n", "2018-11-07\tIn Canada\t981\n", "2018-11-08\tIn Canada\t973\n", "2018-11-09\tIn Canada\t622\n", "2018-11-10\tIn Canada\t773\n", "2018-11-11\tIn Canada\t1001\n", "2018-11-12\tIn Canada\t1041\n", "2018-11-13\tIn Canada\t832\n", "2018-11-14\tIn Canada\t609\n", "2018-11-15\tIn Canada\t1329\n", "2018-11-16\tIn Canada\t1119\n", "2018-11-17\tIn Canada\t1444\n", "2018-11-18\tIn Canada\t1118\n", "2018-11-19\tIn Canada\t895\n", "2018-11-20\tIn Canada\t899\n", "2018-11-21\tIn Canada\t880\n", "2018-11-22\tIn Canada\t837\n", "2018-11-23\tIn Canada\t765\n", "2018-11-24\tIn Canada\t873\n", "2018-11-25\tIn Canada\t706\n", "2018-11-26\tIn Canada\t1574\n", "2018-11-27\tIn Canada\t631\n", "2018-11-28\tIn Canada\t887\n", "2018-11-29\tIn Canada\t877\n", "2018-11-30\tIn Canada\t945\n", "2018-12-01\tIn Canada\t2129\n", "2018-12-02\tIn Canada\t763\n", "2018-12-03\tIn Canada\t648\n", "2018-12-04\tIn Canada\t650\n", "2018-12-05\tIn Canada\t847\n", "2018-12-06\tIn Canada\t672\n", "2018-12-07\tIn Canada\t623\n", "2018-12-08\tIn Canada\t562\n", "2018-12-09\tIn Canada\t1521\n", "2018-12-10\tIn Canada\t628\n", "2018-12-11\tIn Canada\t1072\n", "2018-12-12\tIn Canada\t542\n", "2018-12-13\tIn Canada\t727\n", "2018-12-14\tIn Canada\t456\n", "2018-12-15\tIn Canada\t879\n", "2018-12-16\tIn Canada\t584\n", "2018-12-17\tIn Canada\t664\n", "2018-12-18\tIn Canada\t658\n", "2018-12-19\tIn Canada\t557\n", "2018-12-20\tIn Canada\t946\n", "2018-12-21\tIn Canada\t863\n", "2018-12-22\tIn Canada\t1098\n", "2018-12-23\tIn Canada\t839\n", "2018-12-24\tIn Canada\t1135\n", "2018-12-25\tIn Canada\t967\n", "2018-12-26\tIn Canada\t1019\n", "2018-12-27\tIn Canada\t1563\n", "2018-12-28\tIn Canada\t1170\n", "2018-12-29\tIn Canada\t1154\n", "2018-12-30\tIn Canada\t1710\n", "2018-12-31\tIn Canada\t1277\n", "2019-01-01\tIn Canada\t1051\n", "2019-01-02\tIn Canada\t1056\n", "2019-01-03\tIn Canada\t1063\n", "2019-01-04\tIn Canada\t1290\n", "2019-01-05\tIn Canada\t861\n", "2019-01-06\tIn Canada\t1132\n", "2019-01-07\tIn Canada\t640\n", "2019-01-08\tIn Canada\t2319\n", "2019-01-09\tIn Canada\t1021\n", "2019-01-10\tIn Canada\t4017\n", "2019-01-11\tIn Canada\t3556\n", "2019-01-12\tIn Canada\t1384\n", "2019-01-13\tIn Canada\t742\n", "2019-01-14\tIn Canada\t660\n", "2019-01-15\tIn Canada\t688\n", "2019-01-16\tIn Canada\t676\n", "2019-01-17\tIn Canada\t3035\n", "2019-01-18\tIn Canada\t637\n", "2019-01-19\tIn Canada\t680\n", "2019-01-20\tIn Canada\t655\n", "2019-01-21\tIn Canada\t2151\n", "2019-01-22\tIn Canada\t955\n", "2019-01-23\tIn Canada\t673\n", "2019-01-24\tIn Canada\t1337\n", "2019-01-25\tIn Canada\t2312\n", "2019-01-26\tIn Canada\t485\n", "2019-01-27\tIn Canada\t735\n", "2019-01-28\tIn Canada\t759\n", "2019-01-29\tIn Canada\t723\n", "2019-01-30\tIn Canada\t511\n", "2019-01-31\tIn Canada\t1021\n", "2019-02-01\tIn Canada\t735\n", "2019-02-02\tIn Canada\t889\n", "2019-02-03\tIn Canada\t700\n", "2019-02-04\tIn Canada\t722\n", "2019-02-05\tIn Canada\t843\n", "2019-02-06\tIn Canada\t864\n", "2019-02-07\tIn Canada\t625\n", "2019-02-08\tIn Canada\t1028\n", "2019-02-09\tIn Canada\t1134\n", "2019-02-10\tIn Canada\t765\n", "2019-02-11\tIn Canada\t783\n", "2019-02-12\tIn Canada\t696\n", "2019-02-13\tIn Canada\t502\n", "2019-02-14\tIn Canada\t693\n", "2019-02-15\tIn Canada\t869\n", "2019-02-16\tIn Canada\t766\n", "2019-02-17\tIn Canada\t1151\n", "2019-02-18\tIn Canada\t946\n", "2019-02-19\tIn Canada\t787\n", "2019-02-20\tIn Canada\t636\n", "2019-02-21\tIn Canada\t711\n", "2019-02-22\tIn Canada\t699\n", "2019-02-23\tIn Canada\t1895\n", "2019-02-24\tIn Canada\t884\n", "2019-02-25\tIn Canada\t2229\n", "2019-02-26\tIn Canada\t714\n", "2019-02-27\tIn Canada\t564\n", "2019-02-28\tIn Canada\t716\n", "2019-03-01\tIn Canada\t791\n", "2019-03-02\tIn Canada\t960\n", "2019-03-03\tIn Canada\t593\n", "2019-03-04\tIn Canada\t593\n", "2019-03-05\tIn Canada\t626\n", "2019-03-06\tIn Canada\t604\n", "2019-03-07\tIn Canada\t333\n", "2019-03-08\tIn Canada\t289\n", "2019-03-09\tIn Canada\t288\n", "2019-03-10\tIn Canada\t277\n", "2019-03-11\tIn Canada\t289\n", "2019-03-12\tIn Canada\t258\n", "2019-03-13\tIn Canada\t218\n", "2019-03-14\tIn Canada\t128\n", "2019-03-15\tIn Canada\t202\n", "2019-03-16\tIn Canada\t288\n", "2019-03-17\tIn Canada\t289\n", "2019-03-18\tIn Canada\t287\n", "2019-03-19\tIn Canada\t289\n", "2019-03-20\tIn Canada\t289\n", "2019-03-21\tIn Canada\t288\n", "2019-03-22\tIn Canada\t288\n", "2019-03-23\tIn Canada\t289\n", "2019-03-24\tIn Canada\t288\n", "2019-03-25\tIn Canada\t287\n", "2019-03-26\tIn Canada\t288\n", "2019-03-27\tIn Canada\t289\n", "2019-03-28\tIn Canada\t289\n", "2019-03-29\tIn Canada\t288\n", "2019-03-30\tIn Canada\t289\n", "2019-03-31\tIn Canada\t287\n", "2019-04-01\tIn Canada\t287\n", "2019-04-02\tIn Canada\t282\n", "2019-04-03\tIn Canada\t284\n", "2019-04-04\tIn Canada\t287\n", "2019-04-05\tIn Canada\t289\n", "2019-04-06\tIn Canada\t287\n", "2019-04-07\tIn Canada\t288\n", "2019-04-08\tIn Canada\t287\n", "2019-04-09\tIn Canada\t288\n", "2019-04-10\tIn Canada\t282\n", "2019-04-11\tIn Canada\t282\n", "2019-04-12\tIn Canada\t285\n", "2019-04-13\tIn Canada\t286\n", "2019-04-14\tIn Canada\t289\n", "2019-04-15\tIn Canada\t289\n", "2019-04-16\tIn Canada\t283\n", "2019-04-17\tIn Canada\t232\n", "2019-04-18\tIn Canada\t239\n", "2019-04-19\tIn Canada\t283\n", "2019-04-20\tIn Canada\t260\n", "2019-04-21\tIn Canada\t287\n", "2019-04-22\tIn Canada\t284\n", "2019-04-23\tIn Canada\t287\n", "2019-04-24\tIn Canada\t286\n", "2019-04-25\tIn Canada\t289\n", "2019-04-26\tIn Canada\t287\n", "2019-04-27\tIn Canada\t286\n", "2019-04-28\tIn Canada\t285\n", "2019-04-29\tIn Canada\t283\n", "2019-04-30\tIn Canada\t285\n", "2019-05-01\tIn Canada\t285\n", "2019-05-02\tIn Canada\t280\n", "2019-05-03\tIn Canada\t287\n", "2019-05-04\tIn Canada\t282\n", "2019-05-05\tIn Canada\t284\n", "2019-05-06\tIn Canada\t286\n", "2019-05-07\tIn Canada\t283\n", "2019-05-08\tIn Canada\t287\n", "2019-05-09\tIn Canada\t282\n", "2019-05-10\tIn Canada\t280\n", "2019-05-11\tIn Canada\t286\n", "2019-05-12\tIn Canada\t268\n", "2019-05-13\tIn Canada\t286\n", "2019-05-14\tIn Canada\t287\n", "2019-05-15\tIn Canada\t282\n", "2019-05-16\tIn Canada\t284\n", "2019-05-17\tIn Canada\t287\n", "2019-05-18\tIn Canada\t278\n", "2019-05-19\tIn Canada\t268\n", "2019-05-20\tIn Canada\t283\n", "2019-05-21\tIn Canada\t218\n" ] } ], "source": [ "LEFT = 'Left Canada'\n", "ARRIVED = 'Arrived in Canada'\n", "IN_COUNTY = 'In Canada'\n", "OUT_OF_COUNTRY = 'Outside of Canada'\n", "NO_DATA = 'No Data'\n", "\n", "delta = end_date - start_date\n", "\n", "print(f'Date\\tStatus\\tReadings')\n", "\n", "for i in range(delta.days + 1):\n", " date = start_date + timedelta(days=i)\n", " if date not in dates.keys():\n", " result = NO_DATA\n", " readings = 0\n", " else:\n", " readings = dates[date]['readings']\n", " if (dates[date]['first_tz'] in home_country_timezones) and (dates[date]['last_tz'] in home_country_timezones):\n", " result = IN_COUNTY\n", " elif (dates[date]['first_tz'] in home_country_timezones) and (dates[date]['last_tz'] not in home_country_timezones):\n", " result = LEFT\n", " elif (dates[date]['first_tz'] not in home_country_timezones) and (dates[date]['last_tz'] in home_country_timezones):\n", " result = ARRIVED\n", " elif (dates[date]['first_tz'] not in home_country_timezones) and (dates[date]['last_tz'] not in home_country_timezones):\n", " result = OUT_OF_COUNTRY\n", " else:\n", " result = 'error'\n", " \n", " print(f'{date}\\t{result}\\t{readings}')\n", " " ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.3" } }, "nbformat": 4, "nbformat_minor": 2 }