Introduction

This database contains the information of LegCo committees, namely the name of all LegCo committees established since the fifth term and their corresponding member lists and meeting schedule.

For more details of the database, see https://www.legco.gov.hk/odata/english/schedule-db.html.

Key Identifiers

Here are the key identifies that is useful for locating the neccessary data from the Meeting Schedule Database:

  • CommitteeID is the numerical ID of a LegCo committee.

  • SlotID is the numerical ID of a Council or committee meeting slot.

  • MemberID is the numerical ID of a LegCo member. Note that it is a seperate identifier from the SpeakerID of the Hansard Database.

  • TermID is the numerical ID of a LegCo term. Note that the nominal number of a TermID is less than that of the term number by 1, i.e. the TermID of the fifth term is 4.

  • SessionID is the numerical ID of a LegCo session. A LegCo session typically begins in October to September next year. As a term is four years, there are four sessions in one term.

  • MeetID is the numerical ID of a Council or committee meeting. Although similar, it is a seperate identifier from the SlotID and is only used to match with records from the Attendance Database.

Total Count

All functions in this database (except term()) have an option to return only the total count of the records matching the specified parameters instead of returning the data frame containing the result. To activate this option, specify count = TRUE:

# Fetch the total number of members in the Bills Committee on Fugitive Offenders and
# Mutual Legal Assistance in Criminal Matters Legislation (Amendment) Bill 2019
membership(committee_id = 3005, count = TRUE)
## [1] 62

This database is accessible with the following functions:

term()

term() fetches the details of one or more LegCo term(s).

# Fetch all LegCo terms
term()
##   TermID      Term           StartDate             EndDate
## 1      4 2012-2016 2012-10-01T00:00:00 2016-09-30T00:00:00
## 2      5 2016-2020 2016-10-01T00:00:00 2020-09-30T00:00:00

session()

session() fetches the details of one or more LegCo session(s).

# Fetch all LegCo sessions of the fifth term
session(term_id = 4)
##   SessionID SessionCode TermID           StartDate             EndDate
## 1        13   2012-2013      4 2012-10-01T00:00:00 2013-10-08T00:00:00
## 2        14   2013-2014      4 2013-10-09T00:00:00 2014-10-07T00:00:00
## 3        15   2014-2015      4 2014-10-08T00:00:00 2015-09-30T00:00:00
## 4        16   2015-2016      4 2015-10-14T00:00:00 2016-09-30T00:00:00

committee()

committee() fetches the details of one or more LegCo committee(s).

# Fetch all LegCo committees from the sixth term
v <- committee(term_id = 5)
head(v)
##   CommitteeID CommitteeCode
## 1        2660        AM-CFS
## 2        2662        AM-CMA
## 3        2663        AM-CPM
## 4        2659        AM-LCC
## 5        2675       AM-LCSQ
## 6        2615         AM-MA
##                                                                      NameEng
## 1                                       Committee on Facilities and Services
## 2                                   Committee on Members' Operating Expenses
## 3                                             Committee on Personnel Matters
## 4                                         The Legislative Council Commission
## 5                         Committee on the Use of Legislative Council Square
## 6 Subcommittee on Members' Remuneration and Operating Expenses Reimbursement
##                                      NameChi TermID
## 1                           設施及服務委員會      5
## 2                     議員工作開支事宜委員會      5
## 3                                 人事委員會      5
## 4                       立法會行政管理委員會      5
## 5                   立法會廣場使用事宜委員會      5
## 6 立法會議員酬金及工作開支償還款額小組委員會      5
##                                                             HomeUrlEng
## 1       http://www.legco.gov.hk/general/english/lcc/lcc_fs/fs_1620.htm
## 2     http://www.legco.gov.hk/general/english/lcc/lcc_moe/moe_1620.htm
## 3       http://www.legco.gov.hk/general/english/lcc/lcc_pm/pm_1620.htm
## 4             http://www.legco.gov.hk/general/english/lcc/lcc_1620.htm
## 5   http://www.legco.gov.hk/general/english/lcc/lcc_ulcs/ulcs_1620.htm
## 6 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/ma/general/ma.htm
##                                                             HomeUrlChi
## 1       http://www.legco.gov.hk/general/chinese/lcc/lcc_fs/fs_1620.htm
## 2     http://www.legco.gov.hk/general/chinese/lcc/lcc_moe/moe_1620.htm
## 3       http://www.legco.gov.hk/general/chinese/lcc/lcc_pm/pm_1620.htm
## 4             http://www.legco.gov.hk/general/chinese/lcc/lcc_1620.htm
## 5   http://www.legco.gov.hk/general/chinese/lcc/lcc_ulcs/ulcs_1620.htm
## 6 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/ma/general/ma.htm

membership()

membership() fetches the membership of one or more LegCo member(s) or the members of one or more committee(s).

# Fetch members of the Subcommittee on Issues Relating to Bazaars
v <- membership(committee_id = 2704)
head(v)
##   MemberID CommitteeID                                    NameEng
## 1      258        2704 Subcommittee on Issues Relating to Bazaars
## 2      835        2704 Subcommittee on Issues Relating to Bazaars
## 3      846        2704 Subcommittee on Issues Relating to Bazaars
## 4      274        2704 Subcommittee on Issues Relating to Bazaars
## 5      134        2704 Subcommittee on Issues Relating to Bazaars
## 6      853        2704 Subcommittee on Issues Relating to Bazaars
##              NameChi PostEng PostChi       PostStartDate
## 1 墟市事宜小組委員會  Member    委員 2016-12-03T00:00:00
## 2 墟市事宜小組委員會  Member    委員 2016-12-03T00:00:00
## 3 墟市事宜小組委員會  Member    委員 2016-12-03T00:00:00
## 4 墟市事宜小組委員會  Member    委員 2016-12-03T00:00:00
## 5 墟市事宜小組委員會  Member    委員 2016-12-03T00:00:00
## 6 墟市事宜小組委員會  Member    委員 2016-12-03T00:00:00
##           PostEndDate TermID TitleEng SurnameEng FirstnameEng EnglishName
## 1 2016-12-07T23:59:58      5 Prof Hon        LEE    Kok-long       Joseph
## 2                <NA>      5      Hon      LEUNG   Che-cheung            
## 3                <NA>      5      Hon      LEUNG                  Kenneth
## 4 2017-02-22T23:59:58      5   Dr Hon      LEUNG      Mei-fun   Priscilla
## 5                <NA>      5      Hon      LEUNG    Yiu-chung            
## 6                <NA>      5      Hon       LIAO  Cheung-kong      Martin
##   HonourableEng SurnameChi FirstnameChi TitleChi HonourableChi
## 1       SBS, JP         李         國麟     議員       SBS, JP
## 2   SBS, MH, JP         梁         志祥     議員   SBS, MH, JP
## 3                       梁         繼昌     議員              
## 4       SBS, JP         梁         美芬     議員       SBS, JP
## 5                       梁         耀忠     議員              
## 6       GBS, JP         廖         長江     議員       GBS, JP
# Fetch the committee membership of Hon Wu Chi-wai
v <- membership(member_id = 834)
head(v)
##   MemberID CommitteeID                        NameEng        NameChi
## 1      834        2025                House Committee     內務委員會
## 2      834        2045              Finance Committee     財務委員會
## 3      834        2095           Panel on Development 發展事務委員會
## 4      834        2079             Panel on Transport 交通事務委員會
## 5      834        2088          Panel on Home Affairs 民政事務委員會
## 6      834        2081 Panel on Environmental Affairs 環境事務委員會
##   PostEng PostChi       PostStartDate PostEndDate TermID TitleEng
## 1  Member    委員 2012-10-10T11:00:00        <NA>      4      Hon
## 2  Member    委員 2012-10-10T14:30:00        <NA>      4      Hon
## 3  Member    委員 2012-10-13T00:00:00        <NA>      4      Hon
## 4  Member    委員 2012-10-13T00:00:00        <NA>      4      Hon
## 5  Member    委員 2012-10-16T00:00:00        <NA>      4      Hon
## 6  Member    委員 2012-10-13T00:00:00        <NA>      4      Hon
##   SurnameEng FirstnameEng EnglishName HonourableEng SurnameChi
## 1         WU      Chi-wai                        MH         胡
## 2         WU      Chi-wai                        MH         胡
## 3         WU      Chi-wai                        MH         胡
## 4         WU      Chi-wai                        MH         胡
## 5         WU      Chi-wai                        MH         胡
## 6         WU      Chi-wai                        MH         胡
##   FirstnameChi TitleChi HonourableChi
## 1         志偉     議員            MH
## 2         志偉     議員            MH
## 3         志偉     議員            MH
## 4         志偉     議員            MH
## 5         志偉     議員            MH
## 6         志偉     議員            MH

member()

member() fetches the basic information of one or more LegCo members.

# Fetch full list of members
v <- member()
head(v)
##   MemberID  TitleEng SurnameEng FirstnameEng EnglishName HonourableEng
## 1      167       Hon         NG   Leung-sing                   SBS, JP
## 2      188       Hon        SIN    Chung-kai                   SBS, JP
## 3      924                KWONG      Chun-yu                          
## 4      847 Ir Dr Hon         LO     Wai-kwok               SBS, MH, JP
## 5      849       Hon       KWOK    Wai-keung                        JP
## 6      273       Hon       CHAN      Kin-por                   GBS, JP
##   SurnameChi FirstnameChi TitleChi HonourableChi LatestTermID
## 1         吳         亮星     議員       SBS, JP            4
## 2         單         仲偕     議員       SBS, JP            4
## 3         鄺         俊宇     議員                          5
## 4         盧         偉國     議員   SBS, MH, JP            5
## 5         郭         偉强     議員            JP            5
## 6         陳         健波     議員       GBS, JP            5

Note that member() only returns the latest term that the member has served as LatestTermID. To fetch all the terms served by a member since the fifth term, use member_term() instead.

member_term()

member_term() fetches the all the term served by one or more LegCo members.

#Fetches the term served by Hon Chan Kin-por and Kwong Chun-yu
member_term(id = c(273, 924))
##   MemberID TermID
## 1      273   4, 5
## 2      924      5

meeting()

meeting() fetches the meeting schedule of Council or committees. Note that this function does not take CommitteeID as a filtering parameter. Use meeting_committee() instead if needed.

# Fetch all meeting conducted on 
meeting(from = "2019-03-20", to = "2019-03-20")
##   SlotID MeetID
## 1 175978 133311
## 2 178278 135602
## 3 177295 134619
##                                                                                                             SubjectEng
## 1 Council meeting (Regular meeting)\n(or to be held immediately after the meeting for Chief Executive’s Question Time)
## 2                                                                Council meeting (The Chief Executive's Question Time)
## 3                                                                                 Meeting of Public Works Subcommittee
##                                                    SubjectChi
## 1 立法會會議 (例行會議)\n(或緊接行政長官質詢時間的會議後開始)
## 2                               立法會會議 (行政長官質詢時間)
## 3                                          工務小組委員會會議
##         StartDateTime MeetingTypeEng MeetingTypeChi VenueCode
## 1 2019-03-20T11:30:00           Open       公開會議   Chamber
## 2 2019-03-20T11:00:00           Open       公開會議   Chamber
## 3 2019-03-20T08:30:00           Open       公開會議      Rm 1
##        VenueNameEng VenueNameChi TermID
## 1           Chamber       會議廳      5
## 2           Chamber       會議廳      5
## 3 Conference Room 1      會議室1      5
##                                                              AgendaUrlEng
## 1   http://www.legco.gov.hk/yr18-19/english/counmtg/agenda/cm20190320.htm
## 2  http://www.legco.gov.hk/yr18-19/english/counmtg/agenda/cm20190320q.htm
## 3 http://www.legco.gov.hk/yr18-19/english/fc/pwsc/agenda/pwsc20190320.htm
##                                                              AgendaUrlChi
## 1   http://www.legco.gov.hk/yr18-19/chinese/counmtg/agenda/cm20190320.htm
## 2  http://www.legco.gov.hk/yr18-19/chinese/counmtg/agenda/cm20190320q.htm
## 3 http://www.legco.gov.hk/yr18-19/chinese/fc/pwsc/agenda/pwsc20190320.htm

meeting_committee()

meeting_committee() fetches the meeting schedule of Council or committees. Note that this function does not support dates as filtering parameters. Use meeting() instead if needed.

# Fetch all meetings of Subcommittee on Issues Relating to Bazaars
v <- meeting_committee(committee_id = 2704)
head(v)
##   CommitteeID SlotID                                            SubjectEng
## 1        2704 163894 Meeting of Subcommittee on Issues Relating to Bazaars
## 2        2704 164380 Meeting of Subcommittee on Issues Relating to Bazaars
## 3        2704 164386 Meeting of Subcommittee on Issues Relating to Bazaars
## 4        2704 164409 Meeting of Subcommittee on Issues Relating to Bazaars
## 5        2704 164058 Meeting of Subcommittee on Issues Relating to Bazaars
## 6        2704 163292 Meeting of Subcommittee on Issues Relating to Bazaars
##               SubjectChi       StartDateTime MeetingTypeEng MeetingTypeChi
## 1 墟市事宜小組委員會會議 2016-12-06T15:00:00           Open       公開會議
## 2 墟市事宜小組委員會會議 2016-12-20T09:00:00           Open       公開會議
## 3 墟市事宜小組委員會會議 2017-01-10T16:30:00           Open       公開會議
## 4 墟市事宜小組委員會會議 2017-01-21T09:00:00           Open       公開會議
## 5 墟市事宜小組委員會會議 2017-02-21T08:30:00           Open       公開會議
## 6 墟市事宜小組委員會會議 2017-05-22T14:30:00           Open       公開會議
##   VenueCode      VenueNameEng VenueNameChi TermID
## 1      Rm 3 Conference Room 3      會議室3      5
## 2      Rm 1 Conference Room 1      會議室1      5
## 3      Rm 3 Conference Room 3      會議室3      5
## 4      Rm 1 Conference Room 1      會議室1      5
## 5      Rm 3 Conference Room 3      會議室3      5
## 6      Rm 1 Conference Room 1      會議室1      5
##                                                                      AgendaUrlEng
## 1 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/hs02/agenda/hs0220161206.htm
## 2 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/hs02/agenda/hs0220161220.htm
## 3 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/hs02/agenda/hs0220170110.htm
## 4 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/hs02/agenda/hs0220170121.htm
## 5 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/hs02/agenda/hs0220170221.htm
## 6 http://www.legco.gov.hk/yr16-17/english/hc/sub_com/hs02/agenda/hs0220170522.htm
##                                                                      AgendaUrlChi
## 1 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/hs02/agenda/hs0220161206.htm
## 2 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/hs02/agenda/hs0220161220.htm
## 3 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/hs02/agenda/hs0220170110.htm
## 4 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/hs02/agenda/hs0220170121.htm
## 5 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/hs02/agenda/hs0220170221.htm
## 6 http://www.legco.gov.hk/yr16-17/chinese/hc/sub_com/hs02/agenda/hs0220170522.htm