datamade / api.opencivicdata.org

:cloud: deployment stuff for api.opencivicdata.org
3 stars 3 forks source link

votelist contains many duplicates #33

Open fgregg opened 5 years ago

fgregg commented 5 years ago

https://ocd.datamade.us/votes/?votes__option=yes&votes__option=no&organization__id=ocd-organization/ef168607-9135-4177-ad8e-c1f7a4806c3a&bill__legislative_session__identifier=2015&page=2

organization  
name "Chicago City Council"
id "ocd-organization/ef168607-9135-4177-ad8e-c1f7a4806c3a"
updated_at "2017-02-21T11:30:42.761039+00:00"
id "ocd-vote/b073135f-d8d7-4622-a062-940a6926c2b4"
extras {}
counts []
bill  
identifier "O2016-6083"
id "ocd-bill/0690a825-e9fa-44ab-bb5a-1fc15805d29f"
created_at "2016-09-15T00:49:46.212032+00:00"
start_date "2016-09-14"
result "pass"
motion_text "Passed"
motion_classification []
1  
organization  
name "Chicago City Council"
id "ocd-organization/ef168607-9135-4177-ad8e-c1f7a4806c3a"
updated_at "2017-02-21T11:30:42.761039+00:00"
id "ocd-vote/b073135f-d8d7-4622-a062-940a6926c2b4"
extras {}
counts []
bill  
identifier "O2016-6083"
id "ocd-bill/0690a825-e9fa-44ab-bb5a-1fc15805d29f"
created_at "2016-09-15T00:49:46.212032+00:00"
start_date "2016-09-14"
result "pass"
motion_text "Passed"
motion_classification []
fgregg commented 5 years ago

@evz had the nice idea that it might be showing a response for each option. When I remove the option level filters, the dupes go away. https://ocd.datamade.us/votes/?votes__option=yes&votes__option=no&organization__id=ocd-organization/ef168607-9135-4177-ad8e-c1f7a4806c3a&bill__legislative_session__identifier=2015&page=2