{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "# Goa Odyssey 2026 \u2014 Interactive Data Playground\n",
        "Explore the 5-day Bengaluru \u2194 Goa round-trip dataset (`1,290 km`, `27` trip checkpoints, `46` GNSS telemetry fixes, `8,299` daemon reliability ticks, and `123` concierge activity pings).\n",
        "Download `goa_telemetry_public.sqlite` alongside this notebook and run the cells below!"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {},
      "outputs": [],
      "source": [
        "import sqlite3\n",
        "import pandas as pd\n\n",
        "conn = sqlite3.connect('goa_telemetry_public.sqlite')\n",
        "print('=== Zone Summary ===')\n",
        "display(pd.read_sql('SELECT * FROM v_zone_summary', conn))\n",
        "print('=== Concierge Intents ===')\n",
        "display(pd.read_sql('SELECT * FROM v_concierge_intent_summary', conn))\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {},
      "outputs": [],
      "source": [
        "ody = pd.read_sql('SELECT * FROM trip_odyssey_waypoints', conn)\n",
        "print(f'Total Odyssey Distance: {ody[\"cum_km\"].iloc[-1]:.1f} km across {len(ody)} checkpoints')\n",
        "ody[['timestamp_ist', 'place', 'cum_km', 'evidence', 'notes']].head(12)\n"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "name": "python",
      "version": "3.11"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}