Welcome To CT

My Left Nutmeg

A community-driven blog featuring news and commentary on local, state, and national politics.

helphaiti

Donate to CT Dems
Enable ActBlue
for CT Races
$
John Larson
(1st CD)
$
Joe Courtney
(2nd CD)
$
Rosa DeLauro
(3rd CD)
$
Jim Himes
(4th CD)
$
Chris Murphy
(5th CD)
$
Ads on My Left Nutmeg
 


 
Contact Info
To contact the site admin email ctblogger at ctblogger@yahoo.com

Resources
2007 Legislative "Heroes and Zeroes"
2007 "Worst Republicans In The State"
2007 "Worst Democrats In The State"
CT Congressional Delegation and the Progressive Agenda
CT Clean Elections Funding Explained
Federal Legislative Advocacy Toolkit
State Legislative Advocacy Toolkit
 
 
My Left Nutmeg

You Have The Power

by: BranfordBoy

Fri Sep 29, 2006 at 10:55:41 AM EDT


There's been a lot of talk here lately about what to do for the Lamont campaign -- all of which I endorse. Today, however, I would like to propose an alternate or parallel effort that will help not just Ned Lamont, but all progressive Democrats in the state, the ones who are running now and the ones who will run in the future.

You see, I have been troubled by the fact that our efforts on phonebanking and canvassing are, in a very real sense, "lost" when we head home for the day. The little nuggets of data each of us, as individuals, generate through these efforts is fed into the gaping maw of the campaign's database operation. The hope is that the intelligence will be put to good use, but you and I have no guarantee of that.

And campaign data operations are notoriously balkanized. In theory, there is an effort by the Party to gather and consolidate voter information generated by various campaigns around the state. But candidates are reluctant to share the fruits of their campaigns' labors. "Why," the reasoning goes, "should I provide my field intelligence to a central clearinghouse where a future primary challenger can have access to it and use it against me?"

That's one way in which your efforts get lost. Here's another: Let's say that at some future date, some brave progressive decides to take on Dodd (not saying that someone should, just trying to come up with a ferinstance) and you decide to back that candidate. Can you use the work you did for Lamont? No. It's "lost." You will have to volunteer for the new campaign and do it all over again.

So what to do about it?

BranfordBoy :: You Have The Power
My solution (which is tentative and evolving even as I type) is to resurrect the concept of the "precinct captain."

Back in the days when the Irish ward bosses of New York were inventing modern retail politics, the precinct captains and ward heelers were vital cogs in The Machine. They were tasked with identifying, staying on top of, and herding to the polls the people within a very narrow geographical area, usually one in which they lived. It was a great system. And it worked. It worked in the service of a corrupt machine, but the corruption was in the hearts of the men who ran the machine, not in the system itself.

My Left Nutmeg, at vast expense (okay, 300 bucks) has acquired the voter rolls for the entire state of Connecticut. This is the latest list, containing (I am assured) all those new voters and new Dems who were energized by the Lamont campaign. BTW, I obtained it without any subterfuge. This is public information and anyone who cares to pay for it can get it. More important, anyone who cares to get it can turn around and share it with others, as I intend to do with you.

The voter rolls tell you how people are registered (D, R or U), when they registered, their date of birth, and their voting activity (not how they voted but if and when) for the last ten elections. It's not perfect and there are errors: For example, in my little neck of the woods, the list shows both the current and former owners of a nearby house all living together.

So this is what I propose: That each MLN reader make a commitment to become their own precinct captain. Make a commitment to get to know, intimately, the Democrats (and Rs andd Us, too) on your block, on your street, within a three block radius, in your condo development -- you pick your own parameters.

There is a vast difference between calling and saying, "Hi, I'm Susie Q, a volunteer with the Blotnik campaign," and saying "Hi, I'm Susie Q, your neighbor at 123 Elm Street." The conversation will flow much more easily and the information gleaned will be more detailed and more valuable. And since this is an ongoing project, you will be able, over time, to gather a considerable amount of valuable data. Who has kids? Who is active in local politics? Who is passionately pro-choice?

First, you need your local voter information and that's where My Left Nutmeg comes in. MLN will provide you, via email and free, your local voter rolls. Actually, a lot more than that.

See, the state roll is divided into four sections, each containing a whole bunch of towns. First, I thought of doing it just town by town (which I think has some obvious strategic advantages), but I discovered that would be A LOT of work. So I decided to distribute it in chunks for now. If I can figure a way to create 169 separate town databases, I will, but for now... You will get not only the info on your own town but a lot of other towns as well.

For that reason, I encourage you to look into getting just your own town's data from your local registrar or town hall. Some towns give it for free, others charge (it was $20 in Branford). But I know from experience that it's much more manageable.

Once you get the information, you will still have a lot of work to do, so until this little scheme matures and becomes more "user friendly," this may not be for everyone.

You will need some basic computer and database know-how. The data comes as zipped files which when opened reveal a "Unix executable file," which is something I'd never heard of. On my Mac system, I discovered that I could open the file in Word, save it as a text file, and thus open it in FileMaker Pro as a database. Something similar could be done, I suppose, in Excel.

I would suggest that you make your first project to export just the data you are interested in (your condo development, the three streets around your house, etc.) to a separate database where it will be much more manageable.

Next, you will have to create your own way of dealing with what is a rather unweildy set of data (there are over 40 fields in each record). In FileMaker, I was able to create a layout that captures the most important data and then add additional fields, including a "Notes" field that lets me make note of things like "Lamont lawn sign" or "has kids" or "pro-Joe." There may be (in fact, I am sure there must be) better ways to do it. The important thing at this point is to get started. Perhaps, if this project catches on, people can contribute their techniques and layouts and make them available to everyone.

If you become your own precinct captain, you will develop a depth of voter intelligence that will be invaluable to any campaign you choose to work with. And since you control the information, it will not get "lost." Instead of helping just one campaign, it can help many -- from a DTC primary right up to president. And with each campaign, your date will get richer and more detailed.

Also, what I am proposing is not meant as a substitute for volunteering for Lamont or DeStefano or whoever, but as an addition. The process of information gathering that I am proposing is not limited to an election cycle; it is ongoing. I think there is a lot we can accomplish with this project between now and election day (and I hope to post some more detailed suggestions in the coming days), but the real fruits of the effort may not become apparent until the next election -- and that's okay. Like I say, the important thing is to get started.

Also, I have decided to institute a certain level of "quality control." I certainly have no interest in aiding and abetting Lieberman's GOTV effort. So this is what I propose:

If you would like the chunk of the state voter rolls containing your town, send an email to myleftnutmeg -AT- gmail -DOT- com. Tell me your name, your town, and give me your phone number. That will give us a chance to chat about what we can do to advance the progressive cause in the state. It will also, I trust, serve to weed out the wackos and provocateurs.

I will then email you the zipped file with the data. Simple, right?

As you can tell, if you've made it this far, this is very much a work in progress. Any suggestions for how to refine and improve it are welcomed in the comments.

Tags: , (All Tags)
Print Friendly View Send As Email
You Have The Power | 11 comments
This an is incredibly important project. (0.00 / 0)
I would be willing to contribute $$ to it.

After you get some responses, what's really important to know is which towns/neighborhoods are represented on MLN and which ones are not. We'd need a way to fill in the geographical gaps. Do you have a sense already of where they are BB?


Similar project ongoing in Milford (0.00 / 0)
I am compiling a database (excel for now) to which I add lawn sign info, volunteerism history, email addresses, attendance at meet the candidate forums (when available), etc.

I started out with the Registrar's list, and plan to do a merge to update addresses and other changes. 

Of course, I don't have any info from the Lamont phonebanking we did, since that was campaign-specific and not to be shared.

You are absolutely right about calling in your own town, it gives you something real to talk about and adds credibility. I tell people who I am, where I live, where I work, anything that will make them more comfortable getting the call.  This was particularly important during the robocalls onslaught prior to the Primary.

You still need to keep it brief, and get along to the next call, but the buy-in can be tremendous.

"I am not a Blogger...But I play one on the internet."


Tech help (0.00 / 0)
Is there any way to convert the 'Unix executable file' directly to an Excel file? Most people have Excel and I'm sure if one person comes up with an example for their neighborhood the idea would spread more quickly if people could plug-n-play the Excel format for their own corner of the world.

You are probably a lot more tech savvy than most - you want to make the tech as easy as possible so people can give it a try.

Any Unix to Excel converters or tech people out there?


First lesson learned (0.00 / 0)
Turns out the four chunks of the file are too large to email.

So first challenge will be to whittle them down to size.

I considered Excel. My concern is that Microshaft tries to make sure that various versions of Excel can't recognize each other.


[ Parent ]
Google Spreadsheet (0.00 / 0)
Google has a basic online spreadsheet that people can access over the internet. I'm not familiar with the details but this is the kind of project it would be perfect for - simple info, easy to share.

https://www.google.c...


[ Parent ]
security of this sort of spreadsheet (0.00 / 0)
If this is residing on a google server somewhere and you are uploading data you want to keep confidential, I think it's worth considering how easy it would be to access.

Sharing anything in a microsoft file format is easy enough to do.


[ Parent ]
Democratizing voter files (0.00 / 0)
I was more thinking of publishing the raw voter files that are public record on the Google Spreadsheet, not the individual information on block call sheets and any individual actions. Who knows what kind of tools average people would develop if the voter files that Branford Boy paid $300 dollars for were available for free to average Democrats?

I think Democratic consultants charge big money for their proprietary tools based on voter file information - the more you can make that information open-source and available the more power is in peoples hands, not consultants.


[ Parent ]
Problems, challenges (0.00 / 0)
The more open-source this type of data becomes the more it becomes susceptible to sabotage.

Also, people who discover that information about them, like whether they have kids, their positions on various issues, who they voted for, etc. is on a "public" or "quasi-public" database might very understandably get upset.

I agree that it would be great if this type of ongoing data collection could be made available to progressive cnadidates and movements as widely as possible, but safeguards need to be developed, both for the data itself and the rights of individual voters. Those kinds of issues don't arise when individuals maintain individual databases. In a way, it's sort of like a personal diary -- "today I talked with Jim, found out he opposes school vouchers."


[ Parent ]
More lessons learned (0.00 / 0)
I broke out Ansonia as a separate file (one down, 168 to go!), turned it into an Excel file, zipped it, and was able to email it, although it took a while. I'm concerned that some larger towns, even when zipped, may be impossible to email.

[ Parent ]
Troubles (0.00 / 0)
I looked online for any tips in converting 'unix executable files' to Excel and found the files in question may have been stripped of their proper file extension in coversion/copying and only require a new file suffix (.xls, .doc, .ppt, etc.) to display properly.

From Northbrook28.net (a tech help site):

Q: I have a Unix Executable file, HELP?
"On occasion you might get a file that claims to be a Unix Executable file in your Documents and or home folder, chances are that it is NOT a Unix Executable but instead it is a document that you have worked on that has lost it\'s Application type attributes. The easiest way to fix that is to give the document an application type suffix. You can do that by clicking on the name of the file and adding the suffix. Check below for some common suffix types.

Microsoft Word - .doc
Microsoft Excel - .xls
Microsoft Powerpoint - .ppt
Appleworks - .cwk
Pages - .pages
MP3 - .mp3
HTML - .htm or .html
http://www.northbroo...

More here...
http://216.239.51.10...

try changing the file name extensions to .xls - that might save you a ton of work.


[ Parent ]
once in excel easy to subdivide, READ ONLY, and working copies (0.00 / 0)
If you have a town in excel and it's too large, it's probably too large for the person on the other end to do anything meaningful with it anyhow (too much for one person to research and fill in the good info).

SO - once in excel, using the menus on the spreadsheet, go to DATA/SORT, click on the button that says the spreadsheet has a title row, and select the criteria for sorting.

You could sort and divide by zip code, or if too large, by polling place.  Then just cut and paste that section onto a new worksheet (insert new worksheet), rename the worksheet tab (right click on it), and then copy that worksheet page into a new document.  I would also put a note in that worksheet page, copied into "x document".

store all the subdocs from the big master town spreadsheet in the same "folder" so you can keep track of your work to date.  You know what's been split out of the file, and you have a master document that has all the info in one placed.

READ ONLY FILES:  By the way, if the original document you receive is in a READ ONLY format, you can't mess with it without SAVE AS (choose new name and location).  Then it becomes a regular document and you can add or delete data.

I suggest that anyone receiving a document from BranfordBoy FIRST save it to a folder for the project, untouched.  Then do a SAVE AS and rename it - this gives you a working document that if you screw it up, still leaves you with intact data.


[ Parent ]
You Have The Power | 11 comments
 
5 user(s) logged on.
Menu

Make a New Account

Username:

Password:



Forget your username or password?


Spotlight

Use the Spotlight tool to send a diary to offline journalists, with your feedback or suggestions.
(What is Spotlight?)


Search


   Advanced
My Left Nutmeg Feeds

Links
Connecticut's War Dead

MLN Facebook Group

Blogroll
Powered By
- SoapBlox

Connecticut Blogs
- Capitol Watch
- Colin McEnroe
- Connecticut2.com
- Connecticut Bob
- ConnecticutBlog
- CT Blue Blog
- CT Energy Blog
- CT Local Politics
- CT News Junkie
- CT Smart Growth
- CT Voices for Civil Justice
- CT Voters Count
- CT Weblogs
- CT Working Families Party
- CT Young Dems
- Cool Justice Report
- DanMalloy.com
- Democracy for CT
- Drinking Liberally (New Milford)
- East Haven Politics
- Emboldened
- Hat City Blog (Danbury)
- The Laurel
- LieberWatch
- NB Politicus (New Britain)
- New Haven Independent
- Nutmeg Grater
- Only In Bridgeport
- Political Capitol (Brian Lockhart)
- Rep. David McCluskey
- Rep. Tim O'Brien
- State Sen. Gary Lebeau
- Saramerica
- Stamford Talk
- Spazeboy
- The 40 Year Plan
- The Trough (Ted Mann: New London Day)
- Undercurrents (Hartford IMC)
- Wesleying
- Yale Democrats

CT Sites
- Clean Up CT
- CT Citizen Action Group
- CT Democratic Party
- CT For Lieberman Party
- CT General Assembly
- CT Secretary of State
- CT-N (Connecticut Network)
- Healthcare4every1.org
- Judith Blei Government Relations
- Love Makes A Family CT

CT Candidates
- Joe Courtney (CD2)
- Jim Himes (CD4)
- Chris Murphy (CD5)
- Jonathan Harris (SD5)
- John Hartwell (SD26)
- Tim O'Brien (HD24)
- Matt Lesser (HD100) - Deb Heinrich (HD101)
- Lonnie Reed (HD102)
- Di Masters (HD111)
- Michelle Mount (HD112)
- Kim Fawcett (HD133)

Other State Blogs
- Alabama
- Arizona
- California
- Colorado
- Delaware
- Florida
- Georgia
- Idaho
- Illinois
- Indiana
- Iowa
- Kentucky
- Louisiana
- Maine
- Maryland
- Massachusetts
- Michigan
- Minnesota
- Missouri
- Missouri
- Montana
- Nebraska
- Nevada
- New Hampshire
- New Jersey
- New Mexico
- New York
- New York
- North Carolina
- Ohio
- Ohio
- Oklahoma
- Oregon
- Pennsylvania
- Rhode Island
- South Dakota
- Tennessee
- Texas
- Texas
- Utah
- Vermont
- Virginia
- Washington
- West Virginia
- Wisconsin

More blogs about connecticut+politics.
Technorati Blog Finder


 
Powered By
MLN is powered by SoapBlox
 
Return to front page

Powered by: SoapBlox