Project Request: Build me an election dashboard for upcoming local commission election.

Hi.

Bear with me.

I am a little discombobulated about what I need, which is why I'm hoping you might be able to distill what I found and then help me execute it, with the right strategy.

so I live in Pompano Beach, Florida, and there's an upcoming, commissioner election in November.

I forget the exact date, and what I want to do is I'm going to share my screen with you now.

Okay, first of all, let me just.

Well, yeah, let me share my screen first.

Okay, so I'm not sure where to start because I don't want to be overwhelming because I'm overwhelmed myself.

I came across this site called Plural Policy, which is really expensive.

I can't afford it and it's overdone for what I need.

So you can look up a bill or you can enter your address and it'll tell you your legislators, not commissioners, not anything like that.

And then you can like, clip on them, click on them, and it'll tell you, you know, their main things that Representative Florida House, his email, all that stuff.

and then it has.

You can like track his votes and you can see his activity vote history, which I think is really interesting.

what was this about?

Save our homes from excessive property taxes.

Okay, whatever.

but this isn't.

I don't need something this in depth.

This is like really expensive and I know it.

I'm trying to think of something more like Claude and Python and stuff like that, or however you would want to do it.

But basically this is.

This is.

I do want the, Chip lamarca column and I do want the voting history and I'd also like the bill sponsored and activity now to take you to.

Now, this is what I drew up in figma.

It's really freaking ugly.

I know.

This is just because what FIGMA came up with, I was using FIGMA made.

So basically I was thinking something like this.

These are the commissioners.

He's not up for reelection this year, but I'd still like to see, his attendance rate, what he's voting for.

I want to take the agendas and I want to make them transparent for Pompano beach citizens.

So like six days until the next meeting.

Commission meeting.

I'll show you one that's already done with Claude.

So here's one with Claude.

I don't like the way it looks.

I can make something to make it look better for you.

but basically it's saying this is just mock data for demonstration.

To use real data.

Open your.

Blah, blah.

That's like code stuff.

so we have all these agendas on legistar, and the clerk is telling me that I have to go through all of these meeting details and agendas to find the votes for everything, which is.

I know he can find another way to do it.

So I'm trying to get him to give me a Google sheet of the votes and stuff like this.

See, this is what I've been.

I was manually doing it and what an idiot I am.

I thought it'd be Easier because I'd be able to upload it to Claude and then Claude would be able to execute it.

No, no, didn't work like that.

So.

So, like, you can see the motions.

I, like, actually got out of the agendas.

I wasted so much time doing this.

But basically what I wanted was, the agenda date for only the commission meetings.

motion by who?

I don't really care about the motion.

I don't really care about the second by.

I care about the vote method, the result, and then the vote of each.

Each commissioner and mayor.

I care about the fiscal impact.

And then I like the notes that are there.

just so I have them in there.

But this is, like, less important.

I tried to make.

I'm not.

I'm not a coder and I'm not good at math.

I'm a writer.

So, like, this is why it's all fucked up.

but I wanted to see, like, what the largest fiscal impact is because they're doing a lot of development right now, and that's like, they give $0 to homelessness, but they're giving hundreds of billions of dollars to developers.

So I want to show this in a data format.

That's not me saying my opinion.

I want to prove that this is what's happening.

And so I'm asking the clerk for that.

you can see, like, this is just one of the voting dashboards.

I can make my own in figma.

That's not ugly.

And you can make it a little prettier maybe, how many votes they've had in the past 12 months.

Commission meetings.

Prediction accuracy.

I would really like to predict who's going to vote for what.

And I know that there's three that always vote the same and there's two that always vote the same.

So this prediction should be easier.

voting patterns by category.

Budget, zoning, appointments.

I don't know what those would be.

The commissioners.

approval rate.

I don't know.

I don't know how I get that attendance.

I don't really care about that.

I care more about their votes and, yeah, I care about what they're voting for.

So, like a vote title and a vote description.

this was another one that I made.

I just didn't show you the other things.

Okay, so recent votes.

Can we just go to this artifact?

it is published.

Okay, so recent votes.

Recent commission votes.

Zoning amendment.

I hate how these titles are so vague.

but it shows basically who voted for what recent commission votes.

I would rather just know what passed and what didn't.

Because that seems redundant since we have this up here that shows who voted for what.

I would rather have something more interesting than that, but I guess recent votes pass 5 to 1.

I would also like the implications of the vote, which I guess I could fill in myself.

Predictions.

Predictions are based on historical voting patterns and machine learning, blah, blah, blah.

Okay, I love this one.

Upcoming vote pro vote predictions based on the agenda.

And you can just see, you know, the key factors are the budget category.

I can give you some key factors to consider.

Commissioner profiles.

I had commissioner profiles in here, but I can't find them.

Maybe they're in Pages.

No.

Dashboard?

Mobile?

No.

Well, I'm not going to waste your time.

I, would like commissioner profiles like you saw on plural site.

Where is it?

Well, I'll find it set up.

And then it's like.

See, it's saying like, low Google sheets would be the easiest.

I'm not going through Legislar and I don't want you to either, because it'll cost me a billion dollars.

so I'm gonna ask.

Can you tell me what to ask the clerk for?

Because what I was gonna ask him for is.

I'll just read it to you from my phone.

Is.

I was gonna say.

And we have a good relationship.

So I was gonna say to him, sorry, last email.

My thinking was, not knowing your software is that you could pull agendas for the last two years in your folder view and then search for vote.

And then all the ones with votes can be exported to a zip file or preferably, preferably in the form of Google sheets.

And then I was gonna tell them what I was looking for.

So if you could tell me if you're interested in this.

If you could tell me what I'm looking for.

Like the things I need, which I guess I should do myself.

And then tell me what you need from him.

So you don't have to go through Legisar and pull all this shit.

and then obviously how much it would cost and how long it would take.

and that's not it.

That's just the first part of the project.

The second part of the project is I've analyzed the financials of all the commissioners.

And, this is a doc, so it's more of like a.

See, Like I had.

I exported all the finances from all the past years of when they reelected.

And like, this guy got $73,000 all from business developers.

I want that shown.

And no one sees this because it's hidden.

So.

So, I have all that information here, and I even have the bundling, you know, I have all this information, and I would like to turn it into a dashboard to sort of go cohesively with the other dashboard I'm trying to build so you can see who's voting for who.

Who's voting for what based on who's funded them.

Is this too complicated of a project, do