Idly Dose Vada Coffee Price Survey

This is my survey of Idly Dose Vada Coffee Prices across darshinis in Bangalore. Idea is to collect the data over time across Bangalore for fun and analysis.

Table of Contents

1 Collection
2 Live Charts
3 Data
4 Stats
- 4.1 current_stats
- 4.2 stats_2022
5 Code

Collection

It uses Kobo toolbox for collection and hence you need a free account for submission.

Multiple submissions are okay. Here is the web submission form that you can use both online and offline. If you have the KoboCollect app installed then you can download the form and use it. Here is the project page on Kobo.

Live Charts

Showing data from current year, 2023

Data

Data is licensed under Open Data Commons Open Database License (ODbL)
The data is available in JSON format and SQLite format.

Each document looks like this

{
    "id": "20df46da-637a-47ae-8f57-de4ac38e30dc",
    "key": "20df46da-637a-47ae-8f57-de4ac38e30dc",
    "value":
    {
        "_id": "20df46da-637a-47ae-8f57-de4ac38e30dc",
        "_rev": "3-b81deb73a91c71b5d4eea17b32d33a89",
        "type": "data",
        "name_of_restaurant": "Sagar Fast Food",
        "idly_two": 30,
        "masala_dosa": 50,
        "vada": 30,
        "regular_coffee": null,
        "mini_coffee": 13,
        "ac": "no",
        "type_of_restaurant":
        [
            "standing_sitting_inside"
        ],
        "lat": "12.9306728",
        "lng": "77.6228462",
        "submission_time": "2022-05-29T14:43:06.00+05:30",
        "submitted_by": "thejeshgn"
    }
}

Stats

current_stats

We generate stats every time we update the data. "current_stats" shows the current year's stats. The document looks like this.

{
    "_id": "current_stats",
    "_rev": "11-2069593d4e60d21fce4798b4c7df8b6a",
    "type": "stat",
    "last_updated_on": "2023-03-23T20:58:48.539125+05:30",
    "idly_two":
    {
        "max": 80.0,
        "min": 20.0,
        "mean": 35.0,
        "median": 30.0,
        "mode": 30.0,
        "sd": 16.83
    },
    "masala_dosa":
    {
        "max": 150.0,
        "min": 50.0,
        "mean": 70.5,
        "median": 57.5,
        "mode": 50.0,
        "sd": 32.36
    },
    "vada":
    {
        "max": 53.0,
        "min": 25.0,
        "mean": 33.0,
        "median": 30.0,
        "mode": 25.0,
        "sd": 10.39
    },
    "regular_coffee":
    {
        "max": 50.0,
        "min": 10.0,
        "mean": 19.0,
        "median": 14.0,
        "mode": 12.0,
        "sd": 12.62
    }
}

stats_2022

{
  "_id": "stats_2022",
  "_rev": "1-4f49fc483eaa0b8a00a46578433447fb",
  "type": "stat",
  "last_updated_on": "2022-12-31T23:56:51.111023+05:30",
  "idly_two": {
    "max": 76,
    "min": 20,
    "mean": 33.5,
    "median": 30,
    "mode": 30,
    "sd": 12.18
  },
  "masala_dosa": {
    "max": 113,
    "min": 40,
    "mean": 61.96,
    "median": 55,
    "mode": 50,
    "sd": 20.17
  },
  "vada": {
    "max": 56,
    "min": 15,
    "mean": 28.53,
    "median": 25,
    "mode": 25,
    "sd": 8.78
  },
  "regular_coffee": {
    "max": 41,
    "min": 10,
    "mean": 16.43,
    "median": 15,
    "mode": 15,
    "sd": 7.67
  }
}

Code

The code and data is on Github thejeshgn/idvc.