Queries for Metro Issue No. 342

metro_queries.md

Get all actions sponsored by current Metro committees

select a.date, s.url from
opencivicdata_billaction as a
join opencivicdata_bill as b
on a.bill_id=b.id
join opencivicdata_billsource as s
on s.bill_id=b.id
where organization_id in ('ocd-organization/511270c2-f9d1-4c28-93ba-b28353454c39','ocd-organization/83c75785-fcc4-4716-8fa9-40a7385ee8be','ocd-organization/5647793a-2447-481b-8b7b-e4f63e08fbc7','ocd-organization/6d61370f-3919-41e7-b30c-d77e7614390e','ocd-organization/caa886f8-9af7-4806-a7f9-ebbc3e5b8887','ocd-organization/253d87a6-5f10-4908-9479-5ab9b197c6f1') and s.note='api' order by a.date desc;

Returns 0 results.

Get all actions sponsored by the Metro Board of Directors

select a.date, s.url from
opencivicdata_billaction as a
join opencivicdata_bill as b
on a.bill_id=b.id
join opencivicdata_billsource as s
on s.bill_id=b.id
where organization_id='ocd-organization/42e23f04-de78-436a-bec5-ab240c1b977c' and s.note='api' order by a.date desc;

Returns over 500 results, including results for 2018.