« Data Issues | Main
Saturday
Jun022007

About FEC Data Mart

I've implemented a data mart based on campaign finance data from the Federal Election Commission (FEC) and will be blogging about the project from two perspectives:

  1. Leading up to the 2008 elections, I'll post the results of my analysis on an ongoing basis. I hope this will be of interest to the general public.
  2. Of potential interest to fellow SQL Server practitioners, I'll post various MDX and SQL code samples, and discuss the technical challenges I encounter.

The FEC web site allows the public to query this data based on a number of parameters. However, the query results are incredibly flaky, which provided the original inspiration for this project. (And now that I'm acquainted with the data, the flakiness comes as no surprise -- the data is dirty. I've done some cleaning but it's work in process.) 

I discovered there are a handful of other sites that have embarked down this same path. However, I have found the reports they publish to be lacking, hence this project. 

The relational data mart is implemented using SQL Server 2005, with an Analysis Services cube sitting on top. If a sponsor should emerge (hint, Microsoft), I'll make the database available for online querying. 

Stay tuned.

Links:

FEC downloads

 

PrintView Printer Friendly Version

EmailEmail Article to Friend

References (85)

References allow you to track sources for this article, as well as articles that were written in response to this article.
  • Response
    Response: Very Nice Overview
    Enjoyed checking on this content resource, very nice, useful, interesting and to the point. Very much appreciate that You ve shared this info
  • Response
    Response: greatings
    Agree
  • Response
    Response: Kip
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Cheap Rams Jerseys
    Football is seriously one of the largest sports in America. It has a important following.
  • Response
    Response: my.opera.com
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Vivyanne
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    An further good appearance having a square scarf which is especially most beneficial for your cooler, wintertime months starts off in just the identical fashion as at two above. This time although, the key component in the fabric is put to the entrance with the neck as well as the two ...
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: lunch cooler
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Stefan
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: bradley kurgis
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Fifa 14 Coins Hack
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: 42nd street photo
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Stefan Glaenzer
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Linda Sabeh
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Jospeh Sabeh Jr
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: jospeh sabeh jr
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Jospeh Sabeh Jr
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: United Cash Loans
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: judge ray harding
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: United Cash Loans
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Stefan
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: website link
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: try this
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: luxury yacht
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Smart Search
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: ZQuiet Usa
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: Toronto Star
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Information shops are little cuts of the information warehouse. Though information warehouses have a venture wide profundity, the data in information stores relates to a solitary office. In a few arrangements, every division or specialty unit is viewed as the manager of its information store including all the fittings, programming and ...
  • Response
    Response: ZQuiet Guatemala
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: ZQuiet
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: http://test.com
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: forex
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: ZQuiet España
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: ZQuiet Reviews
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: ZQuiet Reviews
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: bitly.com
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: 21 day fix t25
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
    Response: 21 day fix t25
    tomchester.net - FEC Data Mart - About FEC Data Mart
  • Response
  • Response
  • Response
    Response: drollmax

Reader Comments (3)

If you are willing to buy real estate, you will have to receive the credit loans. Moreover, my sister commonly utilizes a student loan, which occurs to be the most fast.

June 14, 2010 | Unregistered CommenterWoodardEve

Go the Salvatorre Ferragamo way- Need to pep up your day at work? Do it with style and rightly so coach purse outlet. Get a smart and sassy fashion handbag inspired by a Salvatore Ferragamo. Make sure it comes with a dual buckle in pastel shades of lime greens and lemon yellows. The entire look should be compact yet the coach outlet store online interiors should be spacious with loads of compartments.

Go the Guess way- Need a tiny and trendy handbag for an evening out at the coffee shop then make it look like an exclusive piece from the coach purses outlet Guess fraternity. Single straps that have a silver tone, lots of studs on elegant faux patent leather can take you places! Look out for embellishments and rhinestones that louis vuitton add a designer element to your piece.

Go the Prada way-If you need a fashion handbag that is large on space and louis vuitton outlet also chic then go in for pretty pinks with elegant top and center stitched detailing. Ensure it comes with magnetic snap closures for easy access when you are on the go. This spacious cheap coach purses can look sophisticated when accented with silver tone rings.

Go the Calvin Klein way- If you have a fetish for clutch bags, then go in for a silver colored one or make it pure black to match your exclusive gowns. Get a long frame for a classic look. A smooth and sleek curved clasp would be the icing on the cake to achieve this look. Look for an inbuilt shoulder strap, which makes it more versatile.

If you are not fortunate enough to own a trendy designer-labeled louis vuitton outlet then you can source stores that offer beautiful creations on the lines of a Gucci or a Christian Dior. Perfected with precision, these fashion handbags are bound to save you a few bucks and you can be a fashion diva without really spending like one!

A trip through any trendy mall will reveal a plethora of brands that offer a multitude of designs, shapes, textures and sizes. Dolce and Gabbana, Fendi, Christian Dior, Louis Vuitton, Chanel, Versace and coach purses many such brands have rewritten the traditional norms of fashion and the way handbags are being made today.

When fashion goes the designer way; it does not always adhere to branded clothes or branded shoes. Women are known to carry one-of-a-kind coach purse to add some bling to any subtle outfit. All fashionistas spend hours scrounging through the most sought-after branded outlets in their search for the ultimate trendy louis vuitton outlet. An important part of any ensemble, designer handbags can either make or break your entire look! It’s about finding the right match and using it with great élan.

November 23, 2011 | Unregistered Commentercoach purse outlet

Tory burch flats are a very good investment when it comes to shoes, these kind of replica replica tory burch replica tory burch shoes sale boots tory burch boots tory burch replica shoes for sale reva tory burch outlet tory tory burch boots online burch reva flats shoes tory tory burch outlet online tory burch factory outlet online store burch outlet online tory burch boots cheap fake will last a long time.If tory burch boots replica tory burch sale replica you are looking for a fashionable,modern tory burch boots online shop and be up fake tory burch boots replica tory burch flip flops replica tory burch bags to date with the latest flat styles without tory burch outlet online replica tory burch flip flops going over your tory burch flip flops budget, tory burch tory burch flats flats are the right option tory burch outlet sale online replica tory burch flats for tory tory burch replica flats burch replica boots you.Tory burch flats are are well designed with a a large,metallic, tory burch replica bag circular logo placed near the replica tory burch bags toe does little more than draw the eye along the length of replica tory burch boots the foot, the ballet flats are available in assorted colors,from grass green to orchid pink, purple and papeete turquoise,stylisy and colorful.Tory burch flats are perfect for busy days about town when compromising on style is not an option.The best choice in tory burch flats is the reva flat. This type goes with any style and shall remain a Tory burch boots classic for years to come. Before you head out to buy your tory burch flats, This will ensure that you are getting shoes of the best quality of materials that will be comfortable for tory burch replica shoes your feet.Tory burch flats are the closest to what i would call a must-have pair of shoes.

December 2, 2011 | Unregistered Commenterhemin

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>