items
1 row where ayes = 1 and majority = "aye"
This data as json, CSV (advanced)
id ▼ | name | ayes | nays | majority |
---|---|---|---|---|
18-410 | Mayor Spencer stated a motion is needed to consider the remaining item [referral: paragraph no. 18-412]; 12 speaker slips remain on the current item. | 1 | 0 | aye |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [items] ( [id] TEXT PRIMARY KEY, [name] TEXT, [ayes] INTEGER, [nays] INTEGER, [majority] TEXT );