Python Client for Government of India’s Open Government Data OGD platform API
datagovindia is a Python client library for accessing resources from the Government of India’s Open Government Data OGD platform. It provides a simple and intuitive interface to search, discover and download data from the platform.
A data.gov.in API key is required to use this library. You can get your API key from data.gov.in.
### Install from PyPI
pip install -U datagovindiaSaving your API key as an environment variable named DATAGOVINDIA_API_KEY will allow the library to automatically retrieve your API key when needed.
export DATAGOVINDIA_API_KEY=your_api_key_hereor you can specify your API key in every command using the --api-key flag.
You can sync the latest metadata from data.gov.in to ensure that the library is up-to-date with the latest resources.
However, if you want to download data with resource IDs directly and don't need to search for resources, you can skip this step.
# In a python environment
from datagovindia import DataGovIndia
datagovin = DataGovIndia() # Specify API key if not set as an environment variable
datagovin.sync_metadata()Note: Updating the library's metadata from data.gov.in ensures synchronization with the latest data. While this step is optional (especially if you're focused only on data downloads), it's beneficial due to the OGD platform's lack of a search API for resources.
# To update metadata from the command line:
$ datagovindia sync-metadata # Specify API key if not set as an environment variableOutput:
Updated 198465/198465 resources: [===============================================>] - ETA: 0s
Finished updating 198465 records in 62 seconds.search_data = datagovin.search('mgnrega') # Returns a dataframe with search results. Searches in resource title by default
search_data = datagovin.search('mgnrega', search_fields=['title', 'description']) # Search in multiple fields# Search for resources with the keyword 'mgnrega'
$ datagovindia search mgnrega # Returns a dataframe with search results
# Search for resources in the title and description fields only and save the results to a csv/xlsx/json file
$ datagovindia search mgnrega -f title -f description --output mgnrega.csv
# Preview the first n results of a search
$ datagovindia search mgnrega --preview --limit 5Output:
| resource_id | title | description | org_type | fields | orgs | source | sectors | date_created | date_updated |
|---|---|---|---|---|---|---|---|---|---|
| ee03643a-ee4c-48c2-ac30-9f2ff26ab722 | District-wise MGNREGA Data at a Glance from 01.04.2023 to 31.08.2023 | District-wise MGNREGA Data at a Glance from 01.04.2023 to 31.08.2023 | Central | ['document_id', 'sno_', 'state_name', 'district_name', 'total_no__of_jobcards_issued', 'total_no__of_workers', 'total_no__of_active_job_cards', 'total_no__of_active_workers', 'sc_workers_against_active_workers', 'st_workers_against_active_workers', 'approved_labour_budget', 'persondays_of_central_liability_so_far', 'sc_persondays', 'st_persondays', 'women_persondays', 'average_days_of_employment_provided_per_household', 'average_wage_rate_per_day_per_person_rs__', 'total_no_of_hhs_completed_100_days_of_wage_employment', 'total_households_worked', 'total_individuals_worked', 'differently_abled_persons_worked', 'number_of_gps_with_nil_exp', 'total_no__of_works_takenup__new_spill_over_', 'number_of_ongoing_works', 'number_of_completed_works', '__of_nrm_expenditure_public___individual_', '__of_category_b_works', '__of_expenditure_on_agriculture___agriculture_allied_works', 'total_exp_rs__in_lakhs__', 'wages_rs__in_lakhs_', 'material_and_skilled_wages_rs__in_lakhs_', 'total_adm_expenditure__rs__in_lakhs__', 'resource_uuid'] | ['Ministry of Rural Development', 'Department of Land Resources (DLR)'] | data.gov.in | ['Rural', 'Land Resources'] | 2023-09-19T06:43:03+00:00 | 2023-09-19T10:39:44+00:00 |
| d1d29e37-1d60-46da-9902-52340abbfb13 | State/UTs-wise Expenditure on Water Related Works under Mahatma Gandhi National Rural Employment Guarantee Scheme (MGNREGA) from 2019-20 to 2021-22 | State/UTs-wise Expenditure on Water Related Works under Mahatma Gandhi National Rural Employment Guarantee Scheme (MGNREGA) from 2019-20 to 2021-22 | Central | ['document_id', 'sl__no_', 'state_ut', '_2019_2020___water_conservation_and_water_harvesting___completed___number_of_works', '_2019_2020___water_conservation_and_water_harvesting___completed___expenditure__rs__in_lakh_', '_2019_2020___water_conservation_and_water_harvesting___ongoing___number_of_works', '_2019_2020___water_conservation_and_water_harvesting___ongoing___expenditure__rs__in_lakh_', '_2020_2021___water_conservation_and_water_harvesting___completed___number_of_works', '_2020_2021___water_conservation_and_water_harvesting___completed___expenditure__rs__in_lakh_', '_2020_2021___water_conservation_and_water_harvesting___ongoing___number', '_2020_2021___water_conservation_and_water_harvesting___ongoing___expenditure__rs__in_lakh_', '_2021_2022__as_on_10_03_2022____water_conservation_and_water_harvesting___completed___number_of_works', '_2021_2022__as_on_10_03_2022____water_conservation_and_water_harvesting___completed___expenditure__rs__in_lakh_', '_2021_2022__as_on_10_03_2022____water_conservation_and_water_harvesting___ongoing___number_of_works', '_2021_2022__as_on_10_03_2022____water_conservation_and_water_harvesting___ongoing___expenditure__rs__in_lakh_', 'resource_uuid'] | ['Rajya Sabha'] | data.gov.in | ['All'] | 2022-09-15T07:24:33+00:00 | 2022-09-15T12:37:43+00:00 |
| c0350589-65a7-4166-996a-ba5845c398fe | State/UT-wise Central Funds Sanctioned/Released for Wage, Material & Admin Component under MGNREGA from 2018-19 to 2021-22 | State/UT-wise Central Funds Sanctioned/Released for Wage, Material & Admin Component under MGNREGA from 2018-19 to 2021-22 | Central | ['document_id', 'sl__no_', 'state_ut', 'fy_2018_19', 'fy_2019_20', 'fy_2020_21', 'fy_2021_22__as_on_26_07_2021_', 'resource_uuid'] | ['Rajya Sabha'] | data.gov.in | ['All'] | 2022-04-01T05:41:11+00:00 | 2022-04-29T14:13:43+00:00 |
| 0fecf99b-2c7c-46db-9f7d-c4bdacf040fc | State/UT-wise List of Total Number of Active ST Worker and ST Person Days Generated under Mahatma Gandhi National Rural Employment Guarantee Act (MGNREGA) during 2019-20 and 2020-21 (From: Ministry of Tribal Affairs) | State/UT-wise List of Total Number of Active ST Worker and ST Person Days Generated under Mahatma Gandhi National Rural Employment Guarantee Act (MGNREGA) during 2019-20 and 2020-21 (From: Ministry of Tribal Affairs) | Central | ['document_id', '_sl__no_', 'state_ut', 'total_number_of_active_st_worker__in_lakh_', 'st_person_days_generated__in_lakh___2019_20_', 'st_person_days_generated__in_lakhs___2020_21_', 'resource_uuid'] | ['Rajya Sabha'] | data.gov.in | ['All'] | 2021-12-15T14:23:27+00:00 | 2022-02-28T10:15:14+00:00 |
| aeca8112-5fd4-4c91-92dc-d72b2c7b969e | State/UT-wise Central Fund Released and Expenditure Reported under MGNREGA from 2017-18 to 2019-20 (From: Ministry of Rural Development) | State/UT-wise Central Fund Released and Expenditure Reported under MGNREGA from 2017-18 to 2019-20 (From: Ministry of Rural Development) | Central | ['document_id', '_s__no_', 'state_ut', 'central_fund_released___2017_18__', 'central_fund_released___2018_19__', 'central_fund_released___2019_20', '_expenditure___2017_18', '_expenditure___2018_19', '_expenditure___2019_20', 'resource_uuid'] | ['Rajya Sabha'] | data.gov.in | ['All'] | 2021-03-04T07:17:46+00:00 | 2021-03-23T15:15:05+00:00 |
| 7efb084d-b562-4b9f-8a3a-d0808a54d609 | State/UT-wise Persondays Generated under MGNREGA including West Bengal from 2017-18 to 2019-20 (From: Ministry of Rural Development) | State/UT-wise Persondays Generated under MGNREGA including West Bengal from 2017-18 to 2019-20 (From: Ministry of Rural Development) | Central | ['document_id', '_sl_no', 'state_ut', '_2017_18', '_2018_19', '_2019_20', 'resource_uuid'] | ['Rajya Sabha'] | data.gov.in | ['All'] | 2021-03-04T06:52:05+00:00 | 2021-03-23T14:53:45+00:00 |
| 6ae541ca-903e-4a6a-be62-48dedea02223 | Average Mahatma Gandhi National Rural Employment Guarantee Act (MGNREGA) wages from 2014-15 to 2018-19 (From : Ministry of Rural Development) | Average Mahatma Gandhi National Rural Employment Guarantee Act (MGNREGA) wages from 2014-15 to 2018-19 (From : Ministry of Rural Development) | Central | ['document_id', 'financial_year', 'average_wage_rate_per_day_per_person__rs__', 'resource_uuid'] | ['Rajya Sabha'] | data.gov.in | ['All'] | 2021-03-04T04:45:12+00:00 | 2021-03-23T13:10:05+00:00 |
# In a python environment
datagovin.get_resource_info("5c2f62fe-5afa-4119-a499-fec9d604d5bd")# From the command line
$ datagovindia get-resource-info 5c2f62fe-5afa-4119-a499-fec9d604d5bdOutput:
{
"index_name": "5c2f62fe-5afa-4119-a499-fec9d604d5bd",
"title": "All India Pincode Directory till last month",
"desc": "All India Pincode Directory till last month",
"org_type": "Central",
"org": [
"Ministry of Communications",
"Department of Posts"
],
"sector": [
"Post"
],
"source": "data.gov.in",
"catalog_uuid": "709e9d78-bf11-487d-93fd-d547d24cc0ef",
"visualizable": false,
"active": false,
"created": 1608423011,
"updated": 1659003955,
"created_date": "2020-12-20",
"updated_date": "2022-07-28T10:25:55Z",
"field": [
{
"id": "circlename",
"name": "circlename",
"type": "keyword"
},
{
"id": "regionname",
"name": "regionname",
"type": "keyword"
},
{
"id": "divisionname",
"name": "divisionname",
"type": "keyword"
},
{
"id": "officename",
"name": "officename",
"type": "keyword"
},
{
"id": "pincode",
"name": "pincode",
"type": "double"
},
{
"id": "officetype",
"name": "officetype",
"type": "keyword"
},
{
"id": "delivery",
"name": "delivery",
"type": "keyword"
},
{
"id": "district",
"name": "district",
"type": "keyword"
},
{
"id": "statename",
"name": "statename",
"type": "keyword"
},
{
"id": "latitude",
"name": "latitude",
"type": "keyword"
},
{
"id": "longitude",
"name": "longitude",
"type": "keyword"
}
],
"total": 165307
}# In a python environment
data = datagovin.get_data("5c2f62fe-5afa-4119-a499-fec9d604d5bd")# Download data as a json, csv or xlsx file by specifying the --output filepath
$ datagovindia get-data 5c2f62fe-5afa-4119-a499-fec9d604d5bd --output pincode.csv datagovindia is licensed under the MIT License. See the LICENSE file for more details.