Voting Result Database

This data set contains voting results of the Council, House Committee, Finance Committee and its Subcommittees since the Fifth Legislative Council. It consists of the motions moved, questions put, division of votes and votes of individual Members. For use of the data provided by the Legislative Council, please note the disclaimer and copyright notice.

The information can be obtained in the form of open data via web application programming interface (API) as described in this page.

For enquiry, please e-mail to enquiry@legco.gov.hk.

Expand all

Usage tips of Web Application Programming Interface (API)

Note:
When Chinese characters are used in a web api command, please perform URL encoding for it first, or use a browser such as Chrome that can encode Chinese characters automatically.

The open data web api can be run at:

https://app.legco.gov.hk/vrdb/odata/vVotingResult (JSON format)
https://app.legco.gov.hk/vrdb/odata/vVotingResult?$format=xml (XML format)

To get the meta data schema of the dataset, please run the following:

https://app.legco.gov.hk/vrdb/odata/$metadata

The following query string options can be applied:

$format - specify whether the data to be returned in json or xml format, e.g. $format=json
$top=N - select only the first N entries of the set, where N is a positive integer, e.g. $top=10
$skip=N - select only the remaining entries (starting with Entry N+1) where N is a positive integer, e.g. $skip=10
$orderby - what values are used to order the retrieved data, e.g. $orderby=vote_time
$select - select specific fields to be returned, e.g. $select=motion_en,name_en,vote
$filter - select specific entries according to provided conditions, e.g. $filter=year(start_date) eq 2014
$inlinecount - specify "$inlinecount=allpages" to include the total number of records in the returned data

For available operators and functions to be used with $filter option, please refer to the documentation of the Open Data Protocol.

Examples

The following examples illustrate some of the ways to retrieve data according to the Open Data Protocol.

To select the voting results of particular Council Meeting, say 17 Oct 2012 (by default in JSON format):
https://app.legco.gov.hk/vrdb/odata/vVotingResult?&$filter=type eq 'Council Meeting' and start_date eq datetime'2012-10-17'
(Notes: The supported value for "type" can be "Council Meeting", "House Committee", "Finance Committee", "Establishment Subcommittee" and "Public Works Subcommittee".)
To select all voting records in XML format with the English motion containing "stamp duty", together with the total number of records that match the criteria:
https://app.legco.gov.hk/vrdb/odata/vVotingResult?$inlinecount=allpages&$format=xml&$filter=substringof('stamp duty', motion_en)
To select all voting records of Hon Jasper Tsang in XML format for Council Meetings of the 5th Term and order the records by vote time in descending order:
https://app.legco.gov.hk/vrdb/odata/vVotingResult?$format=xml&$orderby=vote_time desc&$filter=type eq 'Council Meeting' and term_no eq 5 and substringof('Tsang Yok-sing', name_en)

Data Resources

Voting results of Council meetings of the Seventh Legislative Council