My Tulsa City Council Database

Using this City of Tulsa link as my source for data, I have created a relational Database in MS Access to define the make up of every council since 1990. I created it to help me glean insights into the amount of experience on each subsequent council after the 1st one in 1990. When I get back from vacation, I’ll look into exporting this into MySQL if anyone is interested.

I did a lot of the data entry by hand, so it is possible that there are errors, report them to me at roemermanonrecord at gmail dot com and I’ll correct them. Also if you want to take a stab at adding your own features, I’ll fold them in to my version…just email me your changes.

Right now it only has data about the council in the DB, but there is no reason why I cant add data regarding budgets, tax packages, censuses data, really anything that is relational to the council…we will work on that in future releases.

Here is the current layout of the tables, queries and some assumptions and constraints.
Tables:
* Council - defines councils from 1990 - today. from swear in date of the council until the swear in of the next one
* Councilors - defines the 40 councilors who have served over the past 19 years
* Council terms - defines the terms of each councilor (hard to look at since it must be linked to the Councilors table)

Queries:
* Council Makeup By Council Num - will tell you who was on each council. Enter 10 for the current council, 1 for the first one
* Total Combined experience By Council - Will tabulate the total experience (in years) of that council at the end of the term.
* Total Council History By Council Num. This is the same query as the previous but it doesn't add up the terms of service. It will show you who is on the current council, and what previous councils they have served on.
* Total Council history - Gives you all the past councils and their makeup all on one big listing
* TotalExp by Councilor - gives you the total experience of any councilor (in years), by name (must be exact)

There are a ton of other queries one could run, this is all I have for now.

Assumptions and constraints:
I credit the current council with an extra year of exp, assuming that they will finish out the term

If you want the avg length of service for any given council, you will have to calculate it yourself. There are several councils that had more than 9 councilors (due to deaths or resignations) so you have to determine what to divide by yourself.

No term is exactly 2 years...They are usually 1.9 years...sometimes a few days over 2 years.

[UPDATE]
Per Jeff Shaw, I've added a query that lets you look up all the councilors from a particular district. (Councilors by Dist)