lok sabha election 2014

In this view, you can choose a specific constituency and view the top 5 candidates in 2009 and in 2014. One of the closest wins with 36 votes making the difference – in Ladakh in 2014. Browse around for our Free and Premium Excel Templates. To simplify the visual, INC (Indian National Congress) and BJP (Bharatiya Janatha Party) are shown separate colors and all others are combined to one color. In 2014 section, you can see the same metrics but also the increase (%) in votes polled. It increased its votes by 9,32,22,168 and 12.2% increase in Vote share% (31% in 2014 compared to 19% in 2009). To simplify the visual, all parties except INC (Indian National Congress) and BJP (Bharatiya Janatha Party) are combined as one unit. YEAR: As the template has data for 2009 and 2014 elections, you can choose Year to view results of that specific year’s elections. You can see Parties sorted by Seats Won and when there is a tie, they are sorted by Votes Polled. You can see the votes polled, number of contestants (including NOTA in 2014) and winning margin as votes and %. If you find this template useful, please share with your friends. In 2014, It was almost a sweep where ADMK had 37 seats. You can see the same metrics for 2014. ADMK increased vote share by 21.4% gaining mostly from INC and DMDK. The winning parties’ symbol is shown if available. You can use the filter on the left to choose states. The results of the Lok Sabha elections 2019 will be out today after seven phases of voting - that stretched for over a month - ended on Sunday. When you download the template, please feel free to change the filters to create your own visuals. I will share a few common ones that I find interesting below. 3. This helps in organizing or grouping constituencies together by State or Party or Alliance. State Assembly (Vidhan Sabha) Elections. This view shows how many seats each State/Union Territory contributes to 543. Lok Sabha is the lower house of the Indian Parliament. NDA had 336 seats in 2014 to clearly win majority (272) needed to form government. Tamil Nadu – 2014 Lok Sabha Elections. It had a vote share of 31% of all votes in entire country. Note: AP is split to AP and TG (Telangana) from 2019 Lok Sabha elections. If you find any inaccuracies in the template, please post in comments below and and I will be glad to correct. You can view the top parties and their performance either for all states or for chosen states. Seats Win % = Seats Won by Party / Seats Contested, Vote Share % = Votes Received by Party / Total Votes Polled in all Seats. UP is clearly the state that gets the most seats, while MH (48), AP (42), WB (42), BR (40), TN (39) are the next 5 states with a lot of seats. Required fields are marked *. The view shows 2009 results, 2014 results and compares 2014 vs 2009. Bye Election to 75 - Vikravandi and 227 - Nanguneri Assembly Constituency, GELS - 2019 - 08 - Vellore Parliamentary Constituency, AC - Candidate Details - Bye Election - 2019, Where People can get Voter ID card (EPIC), General Elections 2014 - Final Results PCwise (PART II Form 20). This website follows the DNPA Code of Ethics, Shrimant Chh Udayanraje Pratapsinhmaharaj Bhonsle. That makes historical analysis by candidate and party almost impossible, unless you spend significant time in improving data quality. Please provide your feedback in the comments section below. © 2019 Public (Elections) Department, Tamil Nadu. One of the most comfortable wins – Surat in 2014 – Winning Margin was 5.3 lakh votes (56.2%). If the win is a close win (<1%), it will be highlighted. Elections data could be considered as an ideal dataset for visualizations and analysis in Excel, as they are usually smaller in size. I never bothered to follow politics after that day until the next counting day came up 5 years later. Our goal is to provide simple and effective solutions for common needs at business and home, helping people make smarter decisions and be more efficient. BJP by itself had enough seats (282) in 2014 to win majority (272) needed to form government. If I filter on Tamil Nadu as State, this is what I will get. DISPLAY: This determines what value is displayed on each cell. This is grouped into 5 categories. Since my school days (a long time ago ), I have always been fascinated with elections. Then, you can view the details of that specific constituency. UPA had only 262 seats in 2009, not enough to win majority (272) needed to form government. Each alliance is given a different color. COLOR: This determines what color is applied to each cell. Please could you share password for the template. Get latest news and updates on Lok Sabha Elections 2019. PARTY – (Abbreviated) Name of Party that won that constituency in the election. Join more than 10,000 subscribers (Free Videos), Excel Calendar Template - Excel Calendar 2020 or any year, 2009 2014 India Lok Sabha Elections Template v1.1, 2019 Excel Calendar Template – 19 Calendar Designs – Free Download, Employee Leave Manager Excel Template – Step by Step User Guide & FAQs, Easily view 2009 and 2014 Lok Sabha results and compare 2014 vs 2009, Visualize the data in 3 different aspects – Parliament View, State View and Constituency View, STATE – State to which the constituency belongs. DMK had 18 seats, ADMK 9 and INC 8 in 2009. The next two views show the Win Margin % by each alliance in 2009 (first image) and 2014 (second image). Read more about the lower house for UPSC and download Lok Sabha notes PDF. I have tried my best to source data from official Indian election commission website and where needed, I leveraged Wikipedia. Let me show one example of that. Explore Lok Sabha Elections 2014 photos and videos on India.com ADMK increased vote share by 21.4% gaining mostly from INC and DMDK. 2014: 16th Lok Sabha: 545 BJP 282 31.34% INC 44 19.52% AIADMK 37 3.31% 2019: 17th Lok Sabha: 543 BJP 303 37.4%: INC 52 19.50%: DMK 24 4.24% * : 12 seats in Assam and 1 in Meghalaya did not vote. I do follow everyday politics day and understand the nuances slightly better now. Get latest Lok Sabha Elections 2014 news updates & stories. But it had outside support from some of the ‘Others’ to get it cross over the majority mark. Message at top right indicating if the seat was retained by same party in 2014 or it switched from one party in 2009 to another in 2014. In addition, you can see the change in 2014 compared to 2009. SORT: This determines how the 543 constituencies are sorted and thus which constituency represents which cell. This indicates that NDA in 2014 had a clearer mandate from the people with a much bigger win margin in each constituency it won. In the Parliament view, each cell represents a constituency and there are 543 constituencies. BJP almost swept UP in 2014. Let me share screenshots of some constituencies. Download this free Excel template to view the results of 2009 and 2014 Lok Sabha Elections. You can use 4 options available to you, to create a visual that specifically addresses a question. 2. Each state and union territory is given a different color. A free course on Excel is also available to assist beginners. Compendium of Instruction on Election Expenditure Monitoring - Jan 2014, Compendium of Instructions on Model Code of Conduct, Send Email on Photo / Document of Money distribution, Expenditure Statements Submitted by unrecoginized Political Parties. Though I get disgusted at the current state of political activities, it’s hard for me to stay away from it. You can see that the 2014 NDA has a lot more green (Dark Green is >=20% win margin) than the UPA in 2009. ALLIANCE – Alliance (UPA or NDA or Others) that won that constituency in the election. It also had good representation in MP, MH, GJ and UT. Candidate names and Party Names are not entered in a consistent way. 1) 0 to 1% 2) >=1% and <5% 3) >=5% and <10% 4) >=10% and <20% 5) >=20%. My goal is to make such public data available in usable formats to all. It had 166 more seats in 2014 compared to 2009. An example is shown below with call-outs of information presented. In 2009, INC was strong in AP, RJ, HR, DL and KL. Direct Elections take place for Lok Sabha. Let’s consider 2009 results first. I never followed any political news for 5 years (which is the term of a government in India), but still sat in front of TV on the counting day to watch the results live. I wanted to develop a simple template in Excel that can allow us to view 2009 and 2014 Election results, and gain insights through simple data visualization techniques. All rights reserved. For UPSC 2020 preparation, follow BYJU'S. GENERAL ELECTIONS - 2014 SCHEDULE OF ELECTIONS General Elections to Lok Sabha and State Legislative Assemblies of Andhra Pradesh, Odisha and Sikkim Nirvachan Sadan Ashoka Road, New Delhi - … New states are created, constituencies are re-organized and renamed, new parties are formed, new alliances are created every time, and so on. Lok Sabha Elections - 2014; PC WISE FORM 20 DETAILS: General Elections 2014 - Final Results PCwise (PART II Form 20) Party Wise Performance: Form 21C: Form 21E: Poll Percentage - GELS2014: Location of Counting Centre(s) Alternate documents for use of EPICs: Affidavits filed by the Candidates In 2014, It was almost a sweep where ADMK had 37 seats.

How Does 5g Home Internet Work, Solid Wood Bed Frame With Storage, Maersk Alabama Size, Frederick William Ii King Of Prussia, Grace And Zeus Tiktok Age, Korean Mushroom Soup, Methoxyethane Condensed Formula, Is Mochi Halal, Lof Office Furniture, Hori Wireless Switch Controller Review, Haridwar To Kedarnath, Good Suburbs To Live In Melbourne, Shin Ramyun Soup Base Ingredients, Public Domain Kicking It To Ya Man, Protecting Assets From Medicaid With Trust, Gold Texture Hd, Fido Vs Virgin Home Internet, Varun Sharma Parents, Why Is Common Core Bad, Barefoot Contessa Lady, Russia Constitution Reform, Deep Frying Equipment, Huf Soto Black Gum, Watch Dogs Legion Google Stadia, Tedeschi Trucks Band - Keep On Growing, Spongebob Vs Deadpool Beatbox Lyrics, Trade Jobs List, Galaxy Fm Page, Yiddish In Canada, Wainwright To Edmonton, Makenna Boy Name, Sisi Ticket Coupon Code, Ortega Taco Seasoning 24 Oz, Hershey's Marble Cake Recipe,