Updated on Monday (12/17) morning, below are 8 slides covering (click on any slide for larger version):

1. Voting results: 57% said YES in Round 1
2. Projections for Round 2: Expected 30% turnout with 64% YES vote - yielding overall result, across both rounds, at 60% YES
3. Participation Rates: 32% in Round 1 - pretty low
4. Detailed/underlying data (any corrections welcome)

1. Voting Results

The voting results are compiled from the Ikhwan website (given their accuracy in presidential elections, I will use their voting data for now).  The registered voters for this referendum comes from Egypt Independent.  All other data comes from previous analyses that can be found sourced elsewhere on the website.

2. Projections for Round 2 (and more detailed results)

The below is my humble attempt at just making projections based on historic data so it obviously does not isolate certain factors that may have existed during one election vs another - more importantly, it does not factor any effects that may have taken place since the presidential elections through today and/or any effects that on the ground campaigning may have over the coming week.

It really does not entail much more than taking data and extrapolating it so take it at face value but it is interesting in either of two cases:

1. If it is right: Then we are starting to see some voting trends across governorates and parties can begin to capitalize on this and target campaigns.  Or, I just got lucky and it was some other factors/data/variables.

2. If it is wrong: Then we see deviations in Egypt's voting across the elections and it illustrates changing tendencies and fluid loyalties.  Or, my methodology/analysis was flawed.

The biggest caveat of all the analysis on this website (thus far at least) is that it is based on governorates level data and results.  For example, in Cairo there are 43 marakiz which would allow for a much more granular analysis.




3. Participation Rates


4. Detailed/underling data

Slide 3: For governorates that have not yet voted, registered voter count is based on Rnd2 of presidential elections.  For governorates that have voted already, Ahram published an atricle which had their updated registerd voter count.

Slide 8: The March 2011 referendum registered voter count is based on the parliamentary election data I found on the elections.eg website. I have not been able to find registered voters for the Mar-11 referendum, and have been told there isn't one but please let me know if you have it.
 


Comments

12/17/2012 06:04

The question you ask, 'is it all about the local?' is very important. If the local interest is the determining factor how does it explain A) decent referendum '11 turnout, and B) relatively good turnout for presidential elections C) different participation rates in the two rounds. I need polling data on attitudes to back this up, but what I've been suggesting is a 'competition effect' is responsible and your information here seems to support it. Competition in the presidential elections and the parliamentary elections was quite high, and correspondingly the turnout was high. My question then is, how has round one affected the attitudes of voters in round two? Does the ten-point gap created by round one make voters in the remaining governorates think competition is higher or lower? Yesterday I had guessed voters would see the Yes votes success on Saturday as having secured a margin guaranteeing adoption of the constitution, in turn decreasing competition, and lowering turnout below 32% which is sort of a base for two, but in itself an indicator of the entire atmosphere surrounding the vote. A lower than 32% turnout would seem to indicate to me the competition is in play. But it is obviously in contradiction to your prediction of higher turnout at 36%, however, if you're right and the natural state of turnout was always going to be higher in round two than one, but competition is seen as being decreased by round one, then perhaps we'll land right back around 32% for round two governorates.

What would be helpful is if half the round two governorates could vote first, and vice-versa, in the next election so we could compare turnout before/after with the other half acting as a control group. This would help us decide if the competition effect was driving participation up or down. Here's the post I wrote yesterday. Thanks for your work. -Troy http://troycarter.me/2012/12/16/why-many-meh-during-constitutional-referendum-in-egypt/

Reply
03/22/2013 08:26

Interesting stuff. Choosing the right medium to invest is very much needed

Reply
04/17/2013 09:22

This would help us decide if the competition effect was driving participation up or down

Reply
12/18/2012 12:25

So what we see in Round One, and maybe carried through Round Two, is a 234-article Constitution, pushed through in three weeks, approved by 18% of the population . . . .

Which provides a rather better foundation for a crisis of legitimacy than of a government.

Reply
04/17/2013 09:20

The information was very informative and helpful.

Reply

Things are very open and intensely clear explanation of issues. was truly information. Your website is very beneficial. Appreciate your sharing

Reply
04/17/2013 09:24

I want to thank you for this great article

Reply
03/06/2013 02:38

Nice to be visiting your blog again, it has been months for me. Well this article that i've been waited for so long

Reply
03/13/2013 04:30

Your statistic is great and i can see a lot of things from your article.

Reply
03/19/2013 06:53

Now I really understand some things I did not understand before. Thanks a lot!

Reply
03/19/2013 06:58

These statistics are much clear for me now, I really did not know that things are this way.

Reply

Well this article that i've been waited for so long

Reply
03/21/2013 00:02

I am so happy to read this. This is the kind of manual that needs to be given and not the random misinformation that's at the other blogs. Thanks for sharing

Reply
03/24/2013 22:00

I have been researching every aspect of a possible career move. This post is very helpful and shows that you have a lot of knowledge on the topic. Do you have any others?

Reply

Very good article, well written and very thought out.This is my first opportunity to visit this website I found some interesting things and I will apply to the development of my blog

Reply
03/25/2013 12:38

This topic is the one that I have been looking into from last 3 days and your insight is extremely useful. Thanks for sharing this information.

Reply
04/08/2013 11:24

I want to thank you for this great article.I enjoyed every little bit part of it and I will be waiting for the new updates.Really loved reading your we blog post. The information was very informative and helpful.

Reply
04/09/2013 03:10

I will be back soon on your site again so please continue sharing your great post

Reply
04/11/2013 03:47

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place.

Reply
04/11/2013 10:28

The thing is that a lot of people don't actually know the optimal way to keep any balanced proper diet menu.I just want you to know That this blog really gonna help me to broaden my knowledge.Thanks

Reply
04/18/2013 22:04

For sports that require fake oakley sunglasses a mix of eye-hand coordination fake oakleys and clear vision, for example tennis,

Reply
04/20/2013 02:30

Your post was really nice and the information that you giving your post that was really cool and amazing.

Reply

Thank you for taking the time to publish this information very useful! I've been looking for books of this nature for a way too long

Reply
05/29/2013 05:26

nice, Thank you for taking the time to publish this information very useful! I've been looking for books of this nature for a way too long

Reply
06/01/2013 11:42

Thanks for writing this. I really feel as though I know so much more about this than I did before. Your blog really brought some things to light that I never would have thought about before reading it.

Reply
cara cepat hamil
06/09/2013 12:20

That is very interesting Smile I love reading and I am always searching for informative information like this. This is exactly what I was looking for. Thanks for sharing this great.

Reply
06/09/2013 20:36

It is amazing posting and incredible work, It has suitable information, I presently wanted to say that you have really so motivating and very informative post. Thanks for wonderful posting

Reply


Great Post. I have not been visiting the site recently. Took a visit again and there were some great comments on the site. Excellent post. Keep up the good work.

Reply
06/09/2013 20:40

Thanks for writing this. I really feel as though I know so much more about this than I did before. Your blog really brought some things to light that I never would have thought about before reading it.

Reply
06/09/2013 20:42

Thanks for your great article friend, i get new information, new ideas to do somethings, i hope you will share again, i keep waiting for next post, thanks.

Reply
06/09/2013 20:44

thanks for sharing

Reply
06/09/2013 20:47

That is very interesting Smile I love reading and I am always searching for informative information like this. This is exactly what I was looking for. Thanks for sharing this great.

Reply



Leave a Reply