Life Data Structure

How you can convert your data to our structure

https://www.loom.com/share/25d3607a99d748d6940ebc10b6acb23f

Shape of Data Schema

field name	data type	mandatory	description
id	string	Yes	An unique id for the entry in the base (It can we sl.no also)
title	string	Yes	Title of the entry
category	choice	Yes	one of [oxygen,medicine,hospital,ambulance,helpline,vaccine,food]
phone_1	string	Yes	Primary contact number
district	choice	Yes	An option from https://docs.google.com/spreadsheets/d/1I_V1K4pEoz1omlMaYC7tZScMYMlGAYBXzVpuvspws7E/edit#gid=717318514
state	choice	Yes	An option from https://docs.google.com/spreadsheets/d/1I_V1K4pEoz1omlMaYC7tZScMYMlGAYBXzVpuvspws7E/edit#gid=559639268
resource type	choice	No	An Option from https://docs.google.com/spreadsheets/d/1I_V1K4pEoz1omlMaYC7tZScMYMlGAYBXzVpuvspws7E/edit#gid=1514280610
address	string	No	Address of the resource
pincode	string	No	pincode of the resource
description	string	No	A text field that could be used to explain more
phone_2	string	No	Additional phone number
email	string	No	email for the resource
quantity_available	string	No	Quantity / Avilability status of the resource
price	string	No	Cost for the resource
source_link	string	No	Link to the source
comment	string	No	Review comments
created_by	string	No	Name or the source / individual
created_on	string	No	Last verified date time in iso 8601 format
verified_by	string	No	Name of the verifier
last_verified_on	string	No	Last verified date time in iso 8601 format
verification_status	string	No	unavailable, available, unreachable, bogus, not verified, verified, 3rd_party_verified
city	string	No	City of the resource
hospital_available_normal_beds	string	No	available normal beds - add only for hospitals
hospital_available_oxygen_beds	string	No	available oxygen beds - add only for hospitals
hospital_available_icu_beds	string	No	available icu beds - add only for hospitals
hospital_available_ventilator_beds	string	No	available ventilator beds - add only for hospitals
latitude	string	No	latitude of the resource
longitude	string	No	longitude of the resource

Sample output from the master database

[
  {
    "id": 91089,
    "state_name": "Maharashtra",
    "district_name": "Mumbai City",
    "data_source": "source_url",
    "data_name": "Care",
    "external_id": "b6a0e2f7-920e-453b-83ae-db42b93b0cb0",
    "created_date": "2021-04-28T23:48:18.857267+05:30",
    "modified_date": "2021-04-28T23:48:18.857291+05:30",
    "deleted": false,
    "data_id": 1046,
    "title": "Sageer Ahmed",
    "category": "oxygen",
    "resource_type": "",
    "description": "free provision of oxygen, but currently no supplies. waiting for returns from recovered patients.",
    "address": "SHREE CHANDRA PRABHU JAIN DERASAR TRUST, Jain mandir road, near Vodafone gallery, bandra west Mumbai 400050.",
    "phone_1": "9945333356",
    "phone_2": "",
    "email": "",
    "quantity_available": "",
    "price": "",
    "source_link": "https://twitter.com/intent/tweet?url=https%3A%2F%2Findiacovidresources.in%2F&text=",
    "comment": "Unavailable Stock",
    "created_on": "",
    "created_by": "",
    "Verified_by": "",
    "last_verified_on": "April 25, 2021 7:24 PM",
    "downvotes": 0,
    "upvotes": 0,
    "created_job": 1,
    "district": 378,
    "state": 22,
    "latitude":"26.458649",
    "longitude":"80.3041843"
  },
]