Look into additional tabulation status info AP is feeding with race data

[alykat]

Keep an eye on it through the first few primaries. If it seems to be filled in consistently, maybe we try to reflect it in the graphics.

Will need to update to v3 of the API first #33

[alykat]

Status info we're interested in:

Race call status

Documentation: https://developer.ap.org/ap-elections-api/docs/RaceCallStatus.htm (both "Called Status" and "AP Decision Status" where available)

For notifications, I think we'd be most interested in:

• Called
• Runoff
• Uncalled
• Too close to call
• Unable to call
• Awaiting ranked choice results

Tabulation status

Documentation: https://developer.ap.org/ap-elections-api/docs/Tabulation_Status.htm

For notifications, I think we'd be most interested in:

• Polls closed / awaiting first report (maybe)
• Active tabulation (might be more useful than polls closed)
• Tabulation paused
• End of tabulation

There is a little more detail here: https://developer.ap.org/ap-elections-api/docs/Release_Notes.htm

[alykat]

Load race data into a Google Sheet Some ability to flag races for priority Log/update status as we check for new data Then notify status changes for priority races to a slack channel?

[abidishajia]

For this @alykat:

1. Loading/Updating race data into a Google sheet - does this mean the config sheet?
2. How do we define priority races? And how do we want to flag them?
3. Do we want to use the slackbot to send updates to 2024-elex-dev

[alykat]

1. I'd start with a separate sheet, to avoid any risk of damaging the main config sheet

2. Priority races would be ones that are more newsworthy / more competitive. a. For the general election, I'd say all presidential, senate and gov races are priority by default, and then we'd need to define a subset of house races. So in that case, maybe we'd preload all the races and their AP IDs into a spreadsheet and handle the flagging there. b. Not sure how best to handle that in a manageable way for primaries, since the universe of races changes so much. Maybe we don't bother for this round? OR, to test a proof of concept, set a blanket rule for now that any senate and gov races are priority, and don't worry about setting up some other way of flagging priority.

3. For an initial phase, let's send them to the test channel? And then we can tune what makes sense for notifications to the dev channel?