read.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3\n",
    "import pandas as pd\n",
    "import wget\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://hitchmap.com/dump.sqlite'\n",
    "filename = 'dump.sqlite'\n",
    "if os.path.exists(filename):\n",
    "        os.remove(filename)\n",
    "filename = wget.download(url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "points = pd.read_sql('select * from points', sqlite3.connect(filename))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>rating</th>\n",
       "      <th>country</th>\n",
       "      <th>wait</th>\n",
       "      <th>name</th>\n",
       "      <th>comment</th>\n",
       "      <th>datetime</th>\n",
       "      <th>reviewed</th>\n",
       "      <th>banned</th>\n",
       "      <th>ip</th>\n",
       "      <th>dest_lat</th>\n",
       "      <th>dest_lon</th>\n",
       "      <th>signal</th>\n",
       "      <th>ride_datetime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>40.974714</td>\n",
       "      <td>27.511654</td>\n",
       "      <td>3.0</td>\n",
       "      <td>TR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tamergem (Hitchwiki)</td>\n",
       "      <td>If you avoid the mini busses, you can get on a...</td>\n",
       "      <td>2011-05-26 10:06:17.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>32.072756</td>\n",
       "      <td>34.793444</td>\n",
       "      <td>4.0</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>41.727928</td>\n",
       "      <td>27.220731</td>\n",
       "      <td>4.0</td>\n",
       "      <td>TR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>41.099858</td>\n",
       "      <td>29.007339</td>\n",
       "      <td>3.0</td>\n",
       "      <td>TR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Xavierallard (Hitchwiki)</td>\n",
       "      <td>There is a lot of traffic there and little spa...</td>\n",
       "      <td>2011-03-15 12:52:11.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>30.169989</td>\n",
       "      <td>66.999612</td>\n",
       "      <td>3.0</td>\n",
       "      <td>PK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58320</th>\n",
       "      <td>10240600186011759</td>\n",
       "      <td>45.046840</td>\n",
       "      <td>19.106699</td>\n",
       "      <td>5.0</td>\n",
       "      <td>RS</td>\n",
       "      <td>5.0</td>\n",
       "      <td>None</td>\n",
       "      <td>Had to walk across the border and got a strang...</td>\n",
       "      <td>2024-10-15 06:25:53.899667</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58321</th>\n",
       "      <td>3290834975192029748</td>\n",
       "      <td>44.663334</td>\n",
       "      <td>20.612379</td>\n",
       "      <td>5.0</td>\n",
       "      <td>RS</td>\n",
       "      <td>5.0</td>\n",
       "      <td>None</td>\n",
       "      <td>Waited there around five minutes to get a ride...</td>\n",
       "      <td>2024-10-15 08:51:56.435985</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58322</th>\n",
       "      <td>96157684005133433</td>\n",
       "      <td>43.749490</td>\n",
       "      <td>21.450216</td>\n",
       "      <td>4.0</td>\n",
       "      <td>RS</td>\n",
       "      <td>5.0</td>\n",
       "      <td>None</td>\n",
       "      <td>It was really slow on a saturday, but I think ...</td>\n",
       "      <td>2024-10-15 08:56:06.882096</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58323</th>\n",
       "      <td>202727738160122188</td>\n",
       "      <td>40.600008</td>\n",
       "      <td>22.680523</td>\n",
       "      <td>5.0</td>\n",
       "      <td>GR</td>\n",
       "      <td>30.0</td>\n",
       "      <td>None</td>\n",
       "      <td>Great spot to get to athens, a trucker took me...</td>\n",
       "      <td>2024-10-15 13:01:17.874572</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>39.387917</td>\n",
       "      <td>22.766762</td>\n",
       "      <td>sign</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58324</th>\n",
       "      <td>2148346544944746392</td>\n",
       "      <td>41.095965</td>\n",
       "      <td>16.769201</td>\n",
       "      <td>5.0</td>\n",
       "      <td>IT</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Eha</td>\n",
       "      <td>From the bus stop its around 30-40min walk. Th...</td>\n",
       "      <td>2024-10-15 16:55:39.660721</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>41.095847</td>\n",
       "      <td>16.769085</td>\n",
       "      <td>ask</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>58325 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id        lat        lon  rating country  wait  \\\n",
       "0                        0  40.974714  27.511654     3.0      TR   NaN   \n",
       "1                        1  32.072756  34.793444     4.0      IL   NaN   \n",
       "2                        2  41.727928  27.220731     4.0      TR   NaN   \n",
       "3                        3  41.099858  29.007339     3.0      TR   NaN   \n",
       "4                        4  30.169989  66.999612     3.0      PK   NaN   \n",
       "...                    ...        ...        ...     ...     ...   ...   \n",
       "58320    10240600186011759  45.046840  19.106699     5.0      RS   5.0   \n",
       "58321  3290834975192029748  44.663334  20.612379     5.0      RS   5.0   \n",
       "58322    96157684005133433  43.749490  21.450216     4.0      RS   5.0   \n",
       "58323   202727738160122188  40.600008  22.680523     5.0      GR  30.0   \n",
       "58324  2148346544944746392  41.095965  16.769201     5.0      IT  10.0   \n",
       "\n",
       "                           name  \\\n",
       "0          Tamergem (Hitchwiki)   \n",
       "1                          None   \n",
       "2                          None   \n",
       "3      Xavierallard (Hitchwiki)   \n",
       "4                          None   \n",
       "...                         ...   \n",
       "58320                      None   \n",
       "58321                      None   \n",
       "58322                      None   \n",
       "58323                      None   \n",
       "58324                       Eha   \n",
       "\n",
       "                                                 comment  \\\n",
       "0      If you avoid the mini busses, you can get on a...   \n",
       "1                                                   None   \n",
       "2                                                   None   \n",
       "3      There is a lot of traffic there and little spa...   \n",
       "4                                                   None   \n",
       "...                                                  ...   \n",
       "58320  Had to walk across the border and got a strang...   \n",
       "58321  Waited there around five minutes to get a ride...   \n",
       "58322  It was really slow on a saturday, but I think ...   \n",
       "58323  Great spot to get to athens, a trucker took me...   \n",
       "58324  From the bus stop its around 30-40min walk. Th...   \n",
       "\n",
       "                         datetime  reviewed  banned ip   dest_lat   dest_lon  \\\n",
       "0      2011-05-26 10:06:17.000000         1       0           NaN        NaN   \n",
       "1                            None         1       0           NaN        NaN   \n",
       "2                            None         1       0           NaN        NaN   \n",
       "3      2011-03-15 12:52:11.000000         1       0           NaN        NaN   \n",
       "4                            None         1       0           NaN        NaN   \n",
       "...                           ...       ...     ... ..        ...        ...   \n",
       "58320  2024-10-15 06:25:53.899667         0       0           NaN        NaN   \n",
       "58321  2024-10-15 08:51:56.435985         0       0           NaN        NaN   \n",
       "58322  2024-10-15 08:56:06.882096         0       0           NaN        NaN   \n",
       "58323  2024-10-15 13:01:17.874572         0       0     39.387917  22.766762   \n",
       "58324  2024-10-15 16:55:39.660721         0       0     41.095847  16.769085   \n",
       "\n",
       "      signal ride_datetime  \n",
       "0       None          None  \n",
       "1       None          None  \n",
       "2       None          None  \n",
       "3       None          None  \n",
       "4       None          None  \n",
       "...      ...           ...  \n",
       "58320   None          None  \n",
       "58321   None          None  \n",
       "58322   None          None  \n",
       "58323   sign          None  \n",
       "58324    ask          None  \n",
       "\n",
       "[58325 rows x 16 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "points"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Duplicate Reports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "duplicates = pd.read_sql('select * from duplicates', sqlite3.connect(filename))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>from_lat</th>\n",
       "      <th>from_lon</th>\n",
       "      <th>to_lat</th>\n",
       "      <th>to_lon</th>\n",
       "      <th>accepted</th>\n",
       "      <th>reviewed</th>\n",
       "      <th>ip</th>\n",
       "      <th>datetime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>51.404352</td>\n",
       "      <td>5.538128</td>\n",
       "      <td>51.404547</td>\n",
       "      <td>5.537270</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-06-04 12:50:01.864103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>51.404627</td>\n",
       "      <td>5.542442</td>\n",
       "      <td>51.404547</td>\n",
       "      <td>5.537270</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-06-04 12:50:53.136541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>52.302417</td>\n",
       "      <td>13.019185</td>\n",
       "      <td>52.302168</td>\n",
       "      <td>13.019915</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-06-04 13:28:37.130403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>52.302286</td>\n",
       "      <td>13.019443</td>\n",
       "      <td>52.302168</td>\n",
       "      <td>13.019915</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-06-04 13:29:43.554062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>52.301984</td>\n",
       "      <td>13.020387</td>\n",
       "      <td>52.302168</td>\n",
       "      <td>13.019915</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-06-04 13:30:04.085706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>257</td>\n",
       "      <td>43.549067</td>\n",
       "      <td>3.797458</td>\n",
       "      <td>43.548466</td>\n",
       "      <td>3.794457</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-10-16 23:04:34.210893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>258</td>\n",
       "      <td>43.546612</td>\n",
       "      <td>3.794251</td>\n",
       "      <td>43.548466</td>\n",
       "      <td>3.794457</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-10-16 23:04:52.557401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>259</td>\n",
       "      <td>43.543631</td>\n",
       "      <td>3.791973</td>\n",
       "      <td>43.544229</td>\n",
       "      <td>3.792824</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-10-16 23:05:33.139895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>260</td>\n",
       "      <td>43.569894</td>\n",
       "      <td>3.837155</td>\n",
       "      <td>43.569668</td>\n",
       "      <td>3.837168</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-10-16 23:08:06.911770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>261</td>\n",
       "      <td>43.607502</td>\n",
       "      <td>3.930711</td>\n",
       "      <td>43.607584</td>\n",
       "      <td>3.930733</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>2024-10-16 23:08:46.576738</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>261 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id   from_lat   from_lon     to_lat     to_lon  accepted  reviewed ip  \\\n",
       "0      1  51.404352   5.538128  51.404547   5.537270         0         0      \n",
       "1      2  51.404627   5.542442  51.404547   5.537270         0         0      \n",
       "2      3  52.302417  13.019185  52.302168  13.019915         0         0      \n",
       "3      4  52.302286  13.019443  52.302168  13.019915         0         0      \n",
       "4      5  52.301984  13.020387  52.302168  13.019915         0         0      \n",
       "..   ...        ...        ...        ...        ...       ...       ... ..   \n",
       "256  257  43.549067   3.797458  43.548466   3.794457         0         0      \n",
       "257  258  43.546612   3.794251  43.548466   3.794457         0         0      \n",
       "258  259  43.543631   3.791973  43.544229   3.792824         0         0      \n",
       "259  260  43.569894   3.837155  43.569668   3.837168         0         0      \n",
       "260  261  43.607502   3.930711  43.607584   3.930733         0         0      \n",
       "\n",
       "                       datetime  \n",
       "0    2024-06-04 12:50:01.864103  \n",
       "1    2024-06-04 12:50:53.136541  \n",
       "2    2024-06-04 13:28:37.130403  \n",
       "3    2024-06-04 13:29:43.554062  \n",
       "4    2024-06-04 13:30:04.085706  \n",
       "..                          ...  \n",
       "256  2024-10-16 23:04:34.210893  \n",
       "257  2024-10-16 23:04:52.557401  \n",
       "258  2024-10-16 23:05:33.139895  \n",
       "259  2024-10-16 23:08:06.911770  \n",
       "260  2024-10-16 23:08:46.576738  \n",
       "\n",
       "[261 rows x 9 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "duplicates"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Hitchwiki Link Reports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "hitchwiki = pd.read_sql('select * from hitchwiki', sqlite3.connect(filename))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>datetime</th>\n",
       "      <th>ip</th>\n",
       "      <th>reviewed</th>\n",
       "      <th>accepted</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2024-10-06 18:24:47.132179</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.933708</td>\n",
       "      <td>5.767576</td>\n",
       "      <td>https://hitchwiki.org/en/Nijmegen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2024-10-06 21:14:18.963484</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.080704</td>\n",
       "      <td>13.739565</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2024-10-06 21:14:32.065375</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.084109</td>\n",
       "      <td>13.739015</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2024-10-06 21:16:23.743380</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.099993</td>\n",
       "      <td>13.735995</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2024-10-06 21:17:05.122037</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.087462</td>\n",
       "      <td>13.737961</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2024-10-06 21:18:25.952505</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.066320</td>\n",
       "      <td>13.739305</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2024-10-06 21:21:09.831569</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.061034</td>\n",
       "      <td>13.569124</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2024-10-06 21:22:31.652014</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.073075</td>\n",
       "      <td>13.668172</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2024-10-06 21:23:05.069949</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.108617</td>\n",
       "      <td>13.733333</td>\n",
       "      <td>https://hitchwiki.org/en/Dresden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2024-10-06 21:26:06.883500</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.302168</td>\n",
       "      <td>13.019915</td>\n",
       "      <td>https://hitchwiki.org/en/Potsdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2024-10-06 21:26:14.348550</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.301472</td>\n",
       "      <td>13.018413</td>\n",
       "      <td>https://hitchwiki.org/en/Potsdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2024-10-06 21:26:50.482482</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.384637</td>\n",
       "      <td>13.152114</td>\n",
       "      <td>https://hitchwiki.org/en/Potsdam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2024-10-07 08:20:28.347678</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.277918</td>\n",
       "      <td>8.903351</td>\n",
       "      <td>https://hitchwiki.org/en/Minden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2024-10-10 08:41:58.120983</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.213328</td>\n",
       "      <td>8.816310</td>\n",
       "      <td>https://hitchwiki.org/en/Bad_Oeynhausen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2024-10-10 08:42:17.096334</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.213090</td>\n",
       "      <td>8.815155</td>\n",
       "      <td>https://hitchwiki.org/en/Bad_Oeynhausen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2024-10-10 08:46:48.633340</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.206292</td>\n",
       "      <td>8.782149</td>\n",
       "      <td>https://hitchwiki.org/en/Bad_Oeynhausen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2024-10-10 08:48:09.689177</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.206044</td>\n",
       "      <td>8.786252</td>\n",
       "      <td>https://hitchwiki.org/en/Bad_Oeynhausen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2024-10-10 08:58:59.665883</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.210461</td>\n",
       "      <td>8.872894</td>\n",
       "      <td>https://hitchwiki.org/en/Porta_Westfalica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2024-10-10 09:01:02.726844</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.210131</td>\n",
       "      <td>8.875580</td>\n",
       "      <td>https://hitchwiki.org/en/Porta_Westfalica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2024-10-12 17:11:24.098818</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.964461</td>\n",
       "      <td>6.314725</td>\n",
       "      <td>https://hitchwiki.org/en/Doetinchem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2024-10-12 17:12:05.303873</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.967335</td>\n",
       "      <td>6.324772</td>\n",
       "      <td>https://hitchwiki.org/en/Doetinchem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2024-10-12 17:12:19.271530</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51.951164</td>\n",
       "      <td>6.274459</td>\n",
       "      <td>https://hitchwiki.org/en/Doetinchem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2024-10-13 10:07:35.486182</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-24.793967</td>\n",
       "      <td>-65.400431</td>\n",
       "      <td>https://hitchwiki.org/en/Salta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2024-10-16 19:06:09.090301</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.307242</td>\n",
       "      <td>10.513111</td>\n",
       "      <td>https://hitchwiki.org/en/Hitchwiki:Hitchmap_links</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2024-10-16 19:14:02.720468</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.307242</td>\n",
       "      <td>10.513111</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2024-10-16 19:23:32.001667</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.308097</td>\n",
       "      <td>10.626537</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2024-10-16 19:23:51.434639</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.311780</td>\n",
       "      <td>10.631203</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2024-10-16 19:25:53.622423</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.340256</td>\n",
       "      <td>10.358906</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2024-10-16 19:26:24.714684</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.339351</td>\n",
       "      <td>10.354754</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2024-10-16 19:27:20.350267</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.327275</td>\n",
       "      <td>10.468640</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2024-10-16 19:27:30.454229</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.321875</td>\n",
       "      <td>10.478080</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2024-10-16 19:28:27.162039</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.314275</td>\n",
       "      <td>10.556550</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2024-10-16 21:08:37.680124</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.281261</td>\n",
       "      <td>10.518309</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2024-10-16 23:00:09.040913</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.281261</td>\n",
       "      <td>10.518309</td>\n",
       "      <td>https://hitchwiki.org/en/Braunschweig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2024-10-16 23:01:23.079577</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.317665</td>\n",
       "      <td>-1.844665</td>\n",
       "      <td>https://hitchwiki.org/en/Donostia-San_Sebastián</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2024-10-16 23:02:28.807884</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.505577</td>\n",
       "      <td>1.352262</td>\n",
       "      <td>https://hitchwiki.org/en/Toulouse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2024-10-16 23:05:53.483616</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.548466</td>\n",
       "      <td>3.794457</td>\n",
       "      <td>https://hitchwiki.org/en/Toulouse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2024-10-16 23:06:07.433804</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.544229</td>\n",
       "      <td>3.792824</td>\n",
       "      <td>https://hitchwiki.org/en/Toulouse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2024-10-16 23:06:54.251766</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.544229</td>\n",
       "      <td>3.792824</td>\n",
       "      <td>https://hitchwiki.org/en/Montpellier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2024-10-16 23:07:14.298867</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.548466</td>\n",
       "      <td>3.794457</td>\n",
       "      <td>https://hitchwiki.org/en/Montpellier</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      datetime ip  reviewed  accepted        lat        lon  \\\n",
       "0   2024-10-06 18:24:47.132179            0         0  51.933708   5.767576   \n",
       "1   2024-10-06 21:14:18.963484            0         0  51.080704  13.739565   \n",
       "2   2024-10-06 21:14:32.065375            0         0  51.084109  13.739015   \n",
       "3   2024-10-06 21:16:23.743380            0         0  51.099993  13.735995   \n",
       "4   2024-10-06 21:17:05.122037            0         0  51.087462  13.737961   \n",
       "5   2024-10-06 21:18:25.952505            0         0  51.066320  13.739305   \n",
       "6   2024-10-06 21:21:09.831569            0         0  51.061034  13.569124   \n",
       "7   2024-10-06 21:22:31.652014            0         0  51.073075  13.668172   \n",
       "8   2024-10-06 21:23:05.069949            0         0  51.108617  13.733333   \n",
       "9   2024-10-06 21:26:06.883500            0         0  52.302168  13.019915   \n",
       "10  2024-10-06 21:26:14.348550            0         0  52.301472  13.018413   \n",
       "11  2024-10-06 21:26:50.482482            0         0  52.384637  13.152114   \n",
       "12  2024-10-07 08:20:28.347678            0         0  52.277918   8.903351   \n",
       "13  2024-10-10 08:41:58.120983            0         0  52.213328   8.816310   \n",
       "14  2024-10-10 08:42:17.096334            0         0  52.213090   8.815155   \n",
       "15  2024-10-10 08:46:48.633340            0         0  52.206292   8.782149   \n",
       "16  2024-10-10 08:48:09.689177            0         0  52.206044   8.786252   \n",
       "17  2024-10-10 08:58:59.665883            0         0  52.210461   8.872894   \n",
       "18  2024-10-10 09:01:02.726844            0         0  52.210131   8.875580   \n",
       "19  2024-10-12 17:11:24.098818            0         0  51.964461   6.314725   \n",
       "20  2024-10-12 17:12:05.303873            0         0  51.967335   6.324772   \n",
       "21  2024-10-12 17:12:19.271530            0         0  51.951164   6.274459   \n",
       "22  2024-10-13 10:07:35.486182            0         0 -24.793967 -65.400431   \n",
       "23  2024-10-16 19:06:09.090301            0         0  52.307242  10.513111   \n",
       "24  2024-10-16 19:14:02.720468            0         0  52.307242  10.513111   \n",
       "25  2024-10-16 19:23:32.001667            0         0  52.308097  10.626537   \n",
       "26  2024-10-16 19:23:51.434639            0         0  52.311780  10.631203   \n",
       "27  2024-10-16 19:25:53.622423            0         0  52.340256  10.358906   \n",
       "28  2024-10-16 19:26:24.714684            0         0  52.339351  10.354754   \n",
       "29  2024-10-16 19:27:20.350267            0         0  52.327275  10.468640   \n",
       "30  2024-10-16 19:27:30.454229            0         0  52.321875  10.478080   \n",
       "31  2024-10-16 19:28:27.162039            0         0  52.314275  10.556550   \n",
       "32  2024-10-16 21:08:37.680124            0         0  52.281261  10.518309   \n",
       "33  2024-10-16 23:00:09.040913            0         0  52.281261  10.518309   \n",
       "34  2024-10-16 23:01:23.079577            0         0  43.317665  -1.844665   \n",
       "35  2024-10-16 23:02:28.807884            0         0  43.505577   1.352262   \n",
       "36  2024-10-16 23:05:53.483616            0         0  43.548466   3.794457   \n",
       "37  2024-10-16 23:06:07.433804            0         0  43.544229   3.792824   \n",
       "38  2024-10-16 23:06:54.251766            0         0  43.544229   3.792824   \n",
       "39  2024-10-16 23:07:14.298867            0         0  43.548466   3.794457   \n",
       "\n",
       "                                                 link  \n",
       "0                   https://hitchwiki.org/en/Nijmegen  \n",
       "1                    https://hitchwiki.org/en/Dresden  \n",
       "2                    https://hitchwiki.org/en/Dresden  \n",
       "3                    https://hitchwiki.org/en/Dresden  \n",
       "4                    https://hitchwiki.org/en/Dresden  \n",
       "5                    https://hitchwiki.org/en/Dresden  \n",
       "6                    https://hitchwiki.org/en/Dresden  \n",
       "7                    https://hitchwiki.org/en/Dresden  \n",
       "8                    https://hitchwiki.org/en/Dresden  \n",
       "9                    https://hitchwiki.org/en/Potsdam  \n",
       "10                   https://hitchwiki.org/en/Potsdam  \n",
       "11                   https://hitchwiki.org/en/Potsdam  \n",
       "12                    https://hitchwiki.org/en/Minden  \n",
       "13            https://hitchwiki.org/en/Bad_Oeynhausen  \n",
       "14            https://hitchwiki.org/en/Bad_Oeynhausen  \n",
       "15            https://hitchwiki.org/en/Bad_Oeynhausen  \n",
       "16            https://hitchwiki.org/en/Bad_Oeynhausen  \n",
       "17          https://hitchwiki.org/en/Porta_Westfalica  \n",
       "18          https://hitchwiki.org/en/Porta_Westfalica  \n",
       "19                https://hitchwiki.org/en/Doetinchem  \n",
       "20                https://hitchwiki.org/en/Doetinchem  \n",
       "21                https://hitchwiki.org/en/Doetinchem  \n",
       "22                     https://hitchwiki.org/en/Salta  \n",
       "23  https://hitchwiki.org/en/Hitchwiki:Hitchmap_links  \n",
       "24              https://hitchwiki.org/en/Braunschweig  \n",
       "25              https://hitchwiki.org/en/Braunschweig  \n",
       "26              https://hitchwiki.org/en/Braunschweig  \n",
       "27              https://hitchwiki.org/en/Braunschweig  \n",
       "28              https://hitchwiki.org/en/Braunschweig  \n",
       "29              https://hitchwiki.org/en/Braunschweig  \n",
       "30              https://hitchwiki.org/en/Braunschweig  \n",
       "31              https://hitchwiki.org/en/Braunschweig  \n",
       "32              https://hitchwiki.org/en/Braunschweig  \n",
       "33              https://hitchwiki.org/en/Braunschweig  \n",
       "34    https://hitchwiki.org/en/Donostia-San_Sebastián  \n",
       "35                  https://hitchwiki.org/en/Toulouse  \n",
       "36                  https://hitchwiki.org/en/Toulouse  \n",
       "37                  https://hitchwiki.org/en/Toulouse  \n",
       "38               https://hitchwiki.org/en/Montpellier  \n",
       "39               https://hitchwiki.org/en/Montpellier  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hitchwiki"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "heatchmap",
   "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.10.14"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}