Database

What you can do to make your database more secure

There’s a story making the rounds about a group in Utah calling itself “Concerned Citizens of the United States” who sent a list of 1,300 mostly Latino names to the press and law enforcement agencies in Utah.  The list is apparently a list of people that the group claims are undocumented, and includes a pretty chilling set of personal information: names, addresses, workplaces, social security numbers, even kids’ names and due dates for pregnant women on the list.  As you can probably guess, the group is demanding that the people on the list be deported immediately.  You can read the full article here.

When I read it, my first reaction was revulsion and disgust at the gall of this group to do something like this.  History is unfortunately replete with examples of such lists, from the Holocaust, to the internment of immigrant groups, to the persecution of organizers at recent political convention protests.  Or even the TSA’s no fly list that keeps accidentally listing people.  And unlike other forms of persecution – racial profiling laws, etc. – lists have an especially chilling power because they’re personal.  A list like this comes out and you wonder – am I on the list?  Will I be?  And, maybe most importantly, how did they get this information and what happened to my – to our – right to privacy?

Thinking about this question – where the information came from – I suspected, as the article does, that the lists are likely coming from state agencies.  I can’t think of other data sources that would have information like social security, children’s names, and mother’s due dates.  However, thinking about this also made me think about the organizing groups that PTP works with, and the safety and security of their lists.

Whether you’re using PowerBase or not, there are a couple of simple things you can do to make your organization’s data safer.  These tips won’t protect you 100% - our organizations are simply too open to prevent malicious individuals from compromising our data, but they will help ensure that you’re doing what you can to limit the exposure of your members in the event that your data is compromised.

  1. Don’t store data that you shouldn’t be collecting in the first place.  At the top of my list of things not to ever collect: a) social security numbers; b) credit card or banking information; c) immigration status
  2. Use strong passwords, and change them frequently.  Also, don’t use the same password for everything/everyone.  There are far too many progressive organizations that use the same passwords for everything, and often those passwords are some variant on “justice.” Click here for a nice tutorial on creating good passwords
  3. Restrict access where it makes sense.  Most database systems enable you to create different types of permission for different users.  Use this feature, but use it with care – you want to be sure that your staff have access to the information that they need – if they don’t, you’ll be creating a barrier to effectively using your database.  At the same time, I’d be willing to bet that not everyone in your organization needs access to everything.  For example, if you have volunteers and members doing data entry for you, consider a permission level that gives them the ability to enter data, but not the ability to read/export data [i.e. write access, but not read access]
  4. Develop and use privacy and technology use policies so that everyone in your organization understands your organization’s perspective on your technology resources, and in particular your data practices.  Your policies should include a clear description of who has access to what information, and who information can be shared with

Are these practices going to solve all your data security problems?  No.  What they will do is get you and your organization on the path to building a culture where you’re taking appropriate care to safe-guard the information that’s critical to your organization’s success.

Trackback URL for this post:

http://www.progressivetech.org/trackback/457

social networking software

Great post! I really liked the content and disposition in your topic!
Filed under Database, PowerBase

Bad Telephone numbers for phone canvassers

I recently heard a comment from Roberto in New Mexico about the low quality of the telephone numbers in a voter file from a nationally known data provder.  One of the causes may be the demise of land line phones.

The Center for Disease Control  published a report on the issue this month. It turns out that (in their words) "In the last 6 months of 2007, nearly one out of every six households (15.8%) did not have a landline telephone, but did have at least one wireless telephone".  This was around 5% in the first half of 2004. People without landlines tend to be poorer, younger and renting. The future?  More cell phones and less reliable lists from data providers.

 Graph of Wireless Phone Growth since 2004

 Read the whole thing at

http://www.cdc.gov/nchs/data/nhis/earlyrelease/wireless200805.pdf

Source: Blumberg SJ, Luke JV. Wireless substitution: Early release of estimates from the National Health Interview Survey, July-December 2007. National Center for Health Statistics. Available from:

http://www.cdc.gov/nchs/nhis.htm. May 13, 2008.

 

Filed under Database, voter

Voter Tech Training a Resounding Success

On May 1, 2008, PTP wrapped up our first Voter Tech Training where community organizers from 24 organizations across the country gathered to learn state of the art technology tools and techniques for integrating voter and base-building organizing databases.

showing voter activitiesMany organizers are wrestling with understanding the relationship between the data cycles of voter engagement and base-building organizing. The Voter Tech Training group tackled this head on, and created what is possibly the most fully articulated description of various voter engagement activities and their related data needs. Members of PTP’s Power on Network can access that document at the Power on Network website http://network.progressivetech.org. If you’re not a member of the Network, click here to request membership.

Data models weren’t the only topic of conversation at the Voter Tech Training. Organizers also learned the nuts and bolts of cleaning, de-duplicating, and merging lists, and had the opportunity for some hands-on training with the Voter Activation Network online voter file interface.

Given the overwhelmingly positive feedback we’ve received, we’re planning to offer the Voter Tech Training again in August right before the heavy voter contact operations kick off. To get updates about the next Voter Tech Training leave a note in the comments here.

Filed under Database, Organizing, voter

The value of a database

I had a conversation yesterday with someone who's trying to wrap his head around how to talk with organizers in his organization about what a database does and what value it provides - why they should use it, and how to think about using it.

As I talked with him about his database questions, I realized that it might be a useful exercise to get this out on the net somewhere. Although I suspect that most of us who do tech work with organizers have had some version of this conversation many many times, I don’t know that I’ve seen it in print, so here goes:

I usually start by asking organizers how many people they can track without any additional technology - no paper, no clipboards, no computers, etc. Most folks think about it for a minute and say somewhere between 10 to 20, and that number trends downward as we get into the details of what they feel is important to keep track of – add in things like occupation, number of children, personal history or stories related to the issues in question and folks rapidly downgrade their initial estimates.

Then I ask how many people they can keep track of using the original organizer's database - the clipboard and various paper forms - and the number usually jumps up to around 40-50 or higher depending on how long the person's been an organizer and how meticulous they are about record keeping.

Then I'll ask how many people the organization usually turns out at events like direct actions, press conferences, etc. Organizations without databases, working in urban areas, tend to turn out 30-50 people if they don't have a good data management process. Organizer's math suggests this means that they're capable of making around 100 contacts to turnout those 30 people.

I wrap it up by saying something like "you've been turning out around 30 people to most of your events for the last several years - and what's it going to take for you to build at a bigger scale so you can demonstrate more power and really move your agenda?" The clear answer is always more people and it doesn't take a whole lot to go from more people to a better way of managing member info. Bottom line is that if you want to contact more people, you need a system to track the information that goes beyond the limits of paper and personal memory.

Filed under Database, Organizing

Does your database know which side of street you're on?

One of the biggest challenges organizers face with a database is generating good, usable lists for organizers to use when talking with people door to door.  Setting aside (for now) the challenges related to quality of information on the lists, I'm interested in how you all deal with the other challenges related to generating good lists:

  • how do you generate lists so that your organizers and canvassers don't have to go back and forth across streets because your database printed the street numbers consecutively?
  • How do you decide what information to include on the sheets?  Do you have a standard set of information that is on every sheet?
  • Do you train people on using the sheets?  How?  What does your training include beyond talking through the at the door rap?

We're in the middle of a COaTI right now, and as a result, I'm talking with lots of groups about their database questions and challenges.  These types of questions come up pretty often, so I thought I'd kick them out to all of you to see if we can start a broader conversation about what it takes to really integrate a database into community organizing work.

Filed under Database

New Release of ODB

Rich Cowan says that he is getting closer to completing the Release 1.0 of Organizers' Database (ODB), an organizing database that works well for smaller groups. It uses the MS Access database engine. It's free to download, has a track record and it seems to be becoming open source.

Filed under Database

Database of the future?

PTP's board - made up of a majority of organizers - has decided that the lack of a decent database solution is hobbling organizations as they attempt to grow. From what we're seeing, a major obstacle to successful mobilizing is the lack of an easy to use database in this sector. While there have been products put together in the nineties, as standalone applications they are no longer meeting the needs of organizing as organizations need to straddle both the offline and online organizing environment. Although the vast majority of the people that community organizing works with are off the 'net, organizers still have a need to move up to a platform that allows them to work in both sectors. This need will increase in the next five years. Finding and developing the application is only a part of the project, though. Without training and technical support, it will fail. Consequently, we are going to put together a comprehensive project plan which will be used in a proposal to seek funding from foundations and major donors.

We've got an interest in the CivicCRM project of SocialSource Foundation because, once it is successfully built, it would make a great platform for this project. We still have some homework to do, but we think it's a good candidate and we're glad that they are investing in this development.

Filed under Database, Organizing

New database application for organizers?

We’ve been looking into the database problems that community organizing groups had with list enhancement projects last fall. It points up the real problems that groups have with their database software. While the activities of community organizing don’t vary much from one organization to another, the same cannot be said for their software, in fact we estimate that 60-75% have custom software.

They are using spreadsheet programs, custom-built applications written in MS Access or Filemaker Pro, modified versions of ebase, donorperfect, organizer’s toolbox, ms Outlook and a few scattered mySQL applications.

Bluntly stated, the situation is a mess – a mess because, without some effort to standardize, it’s nigh on to impossible for groups to share their experiences with each other. The training costs are enormous. There is no economy of scale for the community. PTP is interested in getting a community of practice going within the organizer’s community, but the ability to share best practices will be terribly hindered unless and until a more common technology platform is developed.

Filed under Database
Syndicate content

Site developed in Powered by Drupal, an open source content management system by Palante Technology