Switch branches/tags
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
LICENSE.md
README.md
VolIII_DetailsOfAssemblySegmentsOfPC.pdf
actopc.pl
compress.pl
orid-b.sql
orid.csv

README.md

Data on religion and politics in India

orid

This table contains the ID matching and integration table for Orissa. Each row is the equivalent of a booth. Since the databse only contains data from one year for Orissa so far, this is rather straightforward - no actual cross-year matching is necessary.

Variables

name description
pc_id_09 ID code of the parliamentary constituency that booth falls in, as assigned by the Election Commission in 2009 (post-delimitation) - this ID code stays the same for subsequent elections, even though the assembly segments' names might vary
pc_name_09 Name of that parliamentary constituency, as assigned by the Election Commission in 2009
pc_reserved_09 Reservation status of that parliamentary constituency, as assigned by the Election Commission in 2009
ac_id_09 ID code of the assembly segment that booth falls in, as assigned by the Election Commission in 2009 (post-delimitation) - this ID code stays the same for subsequent elections, even though the assembly segments' names might vary
ac_name_14 Name of that assembly segment, as assigned by the Election Commission in 2014
ac_reserved_14 Reservation status of that assembly segment, as assigned by the Election Commission in 2014
booth_id_14 ID code of the polling booth, as assigned by the Election Commission in 2014
booth_name_14 Name of the polling booth as listed on the cover sheet of the electoral rolls of 2014
address_14 Address of the polling booth as listed on the cover sheet of the electoral rolls of 2014
district_14 District into which this booth falls as listed on the cover sheet of the electoral rolls of 2014
division_14 Sub division into which this booth falls as listed on the cover sheet of the electoral rolls of 2014
tehsil_14 Tehsil into which this booth falls as listed on the cover sheet of the electoral rolls of 2014
block_14 Development block into which this booth falls as listed on the cover sheet of the electoral rolls of 2014
thana_14 Police station under whose jurisdiction this booth falls as listed on the cover sheet of the electoral rolls of 2014
panchayat_14 Gram panchayat into which this booth falls as listed on the cover sheet of the electoral rolls of 2014
village_14 Village / main road / colony into which this booth falls as listed on the cover sheet of the electoral rolls of 2014
parts_14 'Parts' (usually streets) covered by this booth as listed on the cover sheet of the electoral rolls of 2014
pincode_14 Pincode of this booth as listed on the cover sheet of the electoral rolls of 2014

Processing

I am grateful to Sitansu Mahapatra of Datameet, who translated from Odiya for me. Thank you!

The original entries for this table stem mostly from the various processing scripts of other tables. They are then compressed using compress.pl on an otherwise complete dataset SQLite file (this is the reason why combined.sql is split into combined-a.sql and combined-b.sql - so that compress.pl can be run in between if necessary). In other words: whenever any changes or additions happen to the dataset that concerns ID matching and integration, this script has to be re-run, and its output orid.sql incorporated into the table. If you are just downloading the whole dataset, though, this comes with the current version of orid.sql, which is automatically run at the right place by subsequently running combined-a.sql and combined-b.sql. So you should be fine...

One thing was added directly in here, though:

License

While the database in its entirety is subject to an ODC Open Database License, as explained in the main README and LICENSE files, the content of this specific table is factual data, and as such only subject to a simple ODC Database Contents License. Code used for crawling and compilation is subject to a CC-BY-NC-SA 4.0 license.

What this means in the case of ID tables such as this one is basically: the names of electoral precincts and the like can be used without restrictions, but if you rely on the cross-year and cross-ID matching that this table is meant to facilitate, you are bound by the ODbL attribution and share alike provisions.