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.

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

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": "8-f05a19114fba48798dcfcfdf019ffdd4",
  "type": "stat",
  "last_updated_on": "2022-10-27T10:22:21.849550+05:30",
  "idly_two": {
    "max": 76,
    "min": 20,
    "mean": 33.59,
    "median": 30,
    "mode": 30,
    "sd": 11.88
  },
  "masala_dosa": {
    "max": 113,
    "min": 40,
    "mean": 61.96,
    "median": 55,
    "mode": 50,
    "sd": 21.16
  },
  "vada": {
    "max": 56,
    "min": 15,
    "mean": 28.28,
    "median": 25,
    "mode": 25,
    "sd": 8.92
  },
  "regular_coffee": {
    "max": 41,
    "min": 10,
    "mean": 16.93,
    "median": 15,
    "mode": 15,
    "sd": 8.23
  }
}

Code

The code and data is on Github thejeshgn/idvc.

Do you like this post? Please rate, its just a click :) 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...