Introduction

The Calendar web page shows the schedule of meetings and activities of the Legislative Council of the current month, next three months, and past three months. There, links to corresponding home pages of the committees as well as available agendas are provided. When users follows a home page, they can find out the membership of the committee.

The meeting schedules since the Fifth Term can be obtained in the form of open data via web application programming interface (API) as described in this page.

Any comments are welcomed (please e-mail to pid@legco.gov.hk).

Web Application Programming Interface (API)

Note:

For Internet Explorer users, please uncheck "Turn on feed reading view" in the "Settings" of the "Feed and Web slices" section under the "Content" tab of the Internet Options, and then re-start the browser in order to view data in XML format.
Some browsers such as the Internet Explorer will download the data in JSON format instead of displaying them in the browsers. If you encounter such a case, you may download the file and open it with a text editor, or try to use some other browsers such as Chrome.
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 web api provides the following information:

Tterm (Legislative Council terms)
Tsession (Legislative Council sessions)
Tcommittee (committees)
Tmembership (committee membership)
Tmember (Legislative Council Members)
Tmember_term (which term(s) a Member belongs to)
Tmeeting (meeting schedule)
Tmeeting_committee (which committee(s) holds a meeting)

Corresponding to the above information, the open data web api can be run at:

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

https://app.legco.gov.hk/ScheduleDB/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=start_date_time
$select - select specific fields to be returned, e.g. $select=surname_eng,surname_chi,firstname_eng,firstname_chi
$filter - select specific entries according to provided conditions, e.g. $filter=substringof('Council Meeting',name_eng) eq true
$inlinecount - specify "$inlinecount=allpages" to include the total number of records in the returned data
$expand - link up data

For the 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 101st to 120th meeting records (by default in JSON format):
https://app.legco.gov.hk/ScheduleDB/odata/Tmeeting?$skip=100&$top=20
To select the English subject and meeting date/time in XML format from the first 20 meeting records ordered by the English subject:
https://app.legco.gov.hk/ScheduleDB/odata/Tmeeting?$top=20&$format=xml&$select=subject_eng,start_date_time&$orderby=subject_eng
To select all meetings held on 27 May 2014 in XML format, together with the total number of records that match the criteria:
https://app.legco.gov.hk/ScheduleDB/odata/Tmeeting?$format=xml&$inlinecount=allpages&$filter=year(start_date_time) eq 2014 and month(start_date_time) eq 5 and day(start_date_time) eq 27
To select all Council meetings in XML format, together with the total number of records that match the criteria:
https://app.legco.gov.hk/ScheduleDB/odata/Tmeeting?$format=xml&$inlinecount=allpages&$filter=substringof('council meeting',subject_eng) eq true
To select all committees and their membership in JSON format with the English committee name containing "Panel on", together with the total number of records that match the criterion:
https://app.legco.gov.hk/ScheduleDB/odata/Tcommittee?$expand=Tmembership&$format=json&$inlinecount=allpages&$filter=substringof('panel on',name_eng) eq true
To select all Members of the Fifth Term of the Legislative Council (term ID equal 4) in XML format:
https://app.legco.gov.hk/ScheduleDB/odata/Tmember_term?$expand=Tmember&$filter=term_id+eq+4&$format=xml
To select the membership in JSON format of a committee with the committee code equal to "PL/PS" and display the term, English surname, English first name, English post title, post start date, and post end date in the results:
https://app.legco.gov.hk/ScheduleDB/odata/Tcommittee?$expand=Tmembership/Tmember,Tmembership/Tterm&$format=json&$filter=committee_code eq 'PL/PS'&$select=Tmembership/Tterm/term,Tmembership/Tmember/surname_eng, Tmembership/Tmember/firstname_eng,Tmembership/post_eng,Tmembership/post_start_date, Tmembership/post_end_date
To select the membership in JSON format of a committee with the committee ID equal to "2158" and the membership in the Fifth Term (2012-2016, term id equal 4), and display the term, English surname, English first name, English post title, post start date, post end date in the results in ascending order of Members' sequence numbers:
https://app.legco.gov.hk/ScheduleDB/odata/Tmembership?$expand=Tmember,Tterm&$format=json&$filter=committee_id eq 2158 and term_id eq 4 &$select=Tterm/term,Tmember/surname_eng,Tmember/firstname_eng,post_eng,post_start_date, post_end_date&$orderby=Tmember/seq_num
To select the meetings in JSON format of a committee with the committee ID equal to "2158", and display the start date/time, English venue name, English agenda URL in the results in ascending order of the start date/time:
https://app.legco.gov.hk/ScheduleDB/odata/Tmeeting_committee?$expand=Tmeeting&$format=json&$filter=committee_id eq 2158&$select=Tmeeting/start_date_time,Tmeeting/venue_name_eng,Tmeeting/agenda_url_eng &$orderby=Tmeeting/start_date_time