Lok Sabha Election Results 2019 🏆

11 April to 19 May 2019 to elect the members of the 17th Lok Sabha

@kaggle.bhanupratapbiswas_lok_sabha_results_2019

Table List

1 table(51.44 KB)

Lok Shabha Result 2019

@kaggle.bhanupratapbiswas_lok_sabha_results_2019.lok_shabha_result_2019

51.44 KB
542 rows
16 columns

n__id Id	sl_no SL No	year Year	month Month	state_name State Name	constituency_name Constituency Name	candidate_name Candidate Name	sex Sex	party Party	constituency_type Constituency Type	total_electors Total Electors	valid_votes Valid Votes	candidate_votes Candidate Votes	turnout Turnout %	candidate_vote_share Candidate Vote Share %	winning_margin Winning Margin %
1	1	2019	4	Andaman & Nicobar Islands	ANDAMAN & NICOBAR ISLANDS	KULDEEP RAI SHARMA	M	INC	GEN	317878	207296	95308	65.21	45.98	0.68
2	2	2019	4	Andhra Pradesh	ARUKU	GODDETI. MADHAVI	F	YSRCP	ST	1449334	1066978	557561	73.62	52.26	20.75
3	3	2019	4	Andhra Pradesh	SRIKAKULAM	KINJARAPU RAM MOHAN NAIDU	M	TDP	GEN	1540170	1157329	534544	75.14	46.19	0.57
4	4	2019	4	Andhra Pradesh	VIZIANAGARAM	BELLANA CHANDRA SEKHAR	M	YSRCP	GEN	1499300	1217890	578418	81.23	47.49	3.94
5	5	2019	4	Andhra Pradesh	VISAKHAPATNAM	M V V SATYANARAYANA	M	YSRCP	GEN	1825769	1239754	436906	67.9	35.24	0.36
6	6	2019	4	Andhra Pradesh	ANAKAPALLI	DR.BEESETTI VENKATA SATYAVATHI	F	YSRCP	GEN	1517497	1238491	586226	81.61	47.33	7.2
7	7	2019	4	Andhra Pradesh	KAKINADA	VANGA GEETHAVISWANATH	F	YSRCP	GEN	1563226	1234655	537630	78.98	43.54	2.08
8	8	2019	4	Andhra Pradesh	AMALAPURAM	CHINTA ANURADHA	F	YSRCP	SC	1458788	1230903	485313	84.38	39.43	3.25
9	9	2019	4	Andhra Pradesh	RAJAHMUNDRY	MARGANI BHARAT	M	YSRCP	GEN	1436010	1250427	582024	87.08	46.55	9.73
10	10	2019	4	Andhra Pradesh	NARSAPURAM	KANUMURU RAGHU RAMA KRISHNA RAJU	M	YSRCP	GEN	1438922	1174441	447594	81.62	38.11	2.72


CREATE TABLE lok_shabha_result_2019 (
  "n__id" BIGINT,
  "sl_no" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "state_name" VARCHAR,
  "constituency_name" VARCHAR,
  "candidate_name" VARCHAR,
  "sex" VARCHAR,
  "party" VARCHAR,
  "constituency_type" VARCHAR,
  "total_electors" BIGINT,
  "valid_votes" BIGINT,
  "candidate_votes" BIGINT,
  "turnout" DOUBLE,
  "candidate_vote_share" DOUBLE,
  "winning_margin" DOUBLE
);