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

Implement tools to upload external data to db & access it via scatterplot app #685

Open
5 tasks
sfsinger19103 opened this issue Jun 16, 2021 · 1 comment
Open
5 tasks
Assignees
Labels
enhancement New feature or request

Comments

@sfsinger19103
Copy link
Contributor

sfsinger19103 commented Jun 16, 2021

  • Given data by sub jurisdiction (e.g., census data), upsert data into ExternalData and ExternalDataSet tables.
  • Associate a record in ExternalDataSet to a particular Election
  • Given an election-jurisdiction pair, find -- in order -- all data categories available for major sub jurisdiction (e.g., Population by age, Population by race)
  • Given an e-j pair and a data category, find -- in order -- all available counts (labeled, e.g., by '30 to 49'), along with short source for attribution -- counts only for major subdivision, though.
  • Given e-j pair, data category and count label, get vector of counts (for analysis, display, etc.)

How to handle data missing from only some subdivisions? One option: just ignore it....

@sfsinger19103 sfsinger19103 added the enhancement New feature or request label Jun 16, 2021
@sfsinger19103 sfsinger19103 self-assigned this Jun 16, 2021
@sfsinger19103
Copy link
Contributor Author

sfsinger19103 commented Jun 16, 2021

Columns: Election_Id, Jurisdiction_Id, SubJurisdiction_Id, ShortDataSource, Category, Label, Value, InCategoryOrder, DataYear ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant