Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Build a list of P&C websites and expose it via the admin site to improve pre-election data collection #3277

Open
keithamoss opened this issue Oct 26, 2024 · 0 comments

Comments

@keithamoss
Copy link
Owner

  • Build a definitive database over time for all booths, all elections
  • Expose websites relevant to the jurisdiction
  • Allow users to tick off that they're checked, filter out websites with booths where we already have data points
  • Something like the old 'Polling place types' interface
SELECT pp.premises, s.name, s.website, s.email, s.status, s.submitter_type FROM "demsausage"."app_stalls" AS s, "demsausage"."app_pollingplaces" AS pp WHERE ("website" IS DISTINCT FROM '') AND s.polling_place_id = pp.id ORDER BY pp.id DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant