Introduction

This database contains key information of all the bills that have been presented in LegCo since 1906.

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

Key Identifiers

This database has an InternalKey which has little value since there is only one data endpoint and it is not interchangeable with other databases. To locate the bill in other databases, it is advisable to use the First, Second and Third Reading dates as the filter parameters (e.g. Hansard database) or find the CommitteeID of the relevant bill committee using legcoplus::search_committee() from the package legcoplus (e.g. Meeting Schedule Database).

Total Count

The function in this database has 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 bills that have been discussed in LegCo
all_bills(count = TRUE)
## [1] 6015

This database is accessible with the following function:

all_bills()

all_bills() fetches the information of bills that have gone through LegCo.

# Fetch bills that passed third reading on February 20, 2019
all_bills(third_from = "2019-02-20")
##          InternalKey        OrdinanceTitleEng OrdinanceTitleChi
## 1 06657              Inland Revenue Ordinance          稅務條例
## 2 06661              Inland Revenue Ordinance          稅務條例
## 3 06662              Inland Revenue Ordinance          稅務條例
## 4 06669                         Appropriation              撥款
##                               OrdinanceContentUrlEng
## 1 https://www.elegislation.gov.hk/hk/cap112?_lang=en
## 2 https://www.elegislation.gov.hk/hk/cap112?_lang=en
## 3 https://www.elegislation.gov.hk/hk/cap112?_lang=en
## 4                                                   
##                                       OrdinanceContentUrlChi
## 1 https://www.elegislation.gov.hk/hk/cap112?_lang=zh-Hant-HK
## 2 https://www.elegislation.gov.hk/hk/cap112?_lang=zh-Hant-HK
## 3 https://www.elegislation.gov.hk/hk/cap112?_lang=zh-Hant-HK
## 4                                                           
##                                                                                                                             BillTitleEng
## 1                                                                                           Inland Revenue (Amendment) (No. 7) Bill 2018
## 2 Inland Revenue and MPF Schemes Legislation (Tax Deductions for Annuity Premiums and MPF Voluntary Contributions) (Amendment) Bill 2018
## 3                                                                 Inland Revenue (Profits Tax Exemption for Funds) (Amendment) Bill 2018
## 4                                                                                                                Appropriation Bill 2019
##                                                                         BillTitleChi
## 1                                                    2018年稅務(修訂)(第7號)條例草案
## 2 2018年稅務及強積金計劃法例(關於年金保費及強積金自願性供款的稅務扣除)(修訂)條例草案
## 3                                       2018年稅務(豁免基金繳付利得稅)(修訂)條例草案
## 4                                                                 2019年撥款條例草案
##                                       ProposedbyEng        ProposedbyChi
## 1 Secretary for Financial Services and the Treasury 財經事務及庫務局局長
## 2 Secretary for Financial Services and the Treasury 財經事務及庫務局局長
## 3 Secretary for Financial Services and the Treasury 財經事務及庫務局局長
## 4                               Financial Secretary           財政司司長
##       BillGazetteDate
## 1 2018-11-02T00:00:00
## 2 2018-12-07T00:00:00
## 3 2018-12-07T00:00:00
## 4 2019-02-27T00:00:00
##                                               BillContentUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/bills/b201811022.pdf
## 2 https://www.legco.gov.hk/yr18-19/english/bills/b201812071.pdf
## 3 https://www.legco.gov.hk/yr18-19/english/bills/b201812072.pdf
## 4 https://www.legco.gov.hk/yr18-19/english/bills/b201902271.pdf
##                                               BillContentUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/bills/b201811022.pdf
## 2 https://www.legco.gov.hk/yr18-19/chinese/bills/b201812071.pdf
## 3 https://www.legco.gov.hk/yr18-19/chinese/bills/b201812072.pdf
## 4 https://www.legco.gov.hk/yr18-19/chinese/bills/b201902271.pdf
##   BillGazetteDate2 BillContentUrl2Eng BillContentUrl2Chi BillGazetteDate3
## 1               NA                                                     NA
## 2               NA                                                     NA
## 3               NA                                                     NA
## 4               NA                                                     NA
##   BillContentUrl3Eng BillContentUrl3Chi OrdinanceGazetteDate
## 1                                        2019-03-01T00:00:00
## 2                                        2019-03-29T00:00:00
## 3                                        2019-03-01T00:00:00
## 4                                        2019-05-24T00:00:00
##   OrdinanceYearNumberEng OrdinanceYearNumberChi
## 1     Ord. No. 6 of 2019        2019年第6號條例
## 2     Ord. No. 7 of 2019        2019年第7號條例
## 3     Ord. No. 5 of 2019        2019年第5號條例
## 4     Ord. No. 8 of 2019        2019年第8號條例
##                                    OrdinaceGazetteContentUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/ord/2019ord006-e.pdf
## 2 https://www.legco.gov.hk/yr18-19/english/ord/2019ord007-e.pdf
## 3 https://www.legco.gov.hk/yr18-19/english/ord/2019ord005-e.pdf
## 4 https://www.legco.gov.hk/yr18-19/english/ord/2019ord008-e.pdf
##                                   OrdinanceGazetteContentUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/ord/2019ord006-c.pdf
## 2 https://www.legco.gov.hk/yr18-19/chinese/ord/2019ord007-c.pdf
## 3 https://www.legco.gov.hk/yr18-19/chinese/ord/2019ord005-c.pdf
## 4 https://www.legco.gov.hk/yr18-19/chinese/ord/2019ord008-c.pdf
##    LegcoBriefFileReference
## 1   TsyB R 00/800/24/0 (C)
## 2                INS/2/18C
## 3 ASST/3/1/5C (2018) Pt.19
## 4                         
##                                                                                              LegcoBriefUrlEng
## 1 http://library.legco.gov.hk:1080/search~S10?/.bills/br/.bills/br/1,1,1,B/l962~bills/br&FF=&1,0,,0,0
## 2 http://library.legco.gov.hk:1080/search~S10?/.bills/br/.bills/br/1,1,1,B/l962~bills/br&FF=&1,0,,0,0
## 3 http://library.legco.gov.hk:1080/search~S10?/.bills/br/.bills/br/1,1,1,B/l962~bills/br&FF=&1,0,,0,0
## 4                                                                                                            
##                                                                                              LegcoBriefUrlChi
## 1 http://library.legco.gov.hk:1080/search~S10?/.bills/br/.bills/br/1,1,1,B/l962~bills/br&FF=&1,0,,1,0
## 2 http://library.legco.gov.hk:1080/search~S10?/.bills/br/.bills/br/1,1,1,B/l962~bills/br&FF=&1,0,,1,0
## 3 http://library.legco.gov.hk:1080/search~S10?/.bills/br/.bills/br/1,1,1,B/l962~bills/br&FF=&1,0,,1,0
## 4                                                                                                            
##      FirstReadingDate
## 1 2018-11-14T00:00:00
## 2 2018-12-12T00:00:00
## 3 2018-12-12T00:00:00
## 4 2019-02-27T00:00:00
##                                                                         FirstReadingDateHansardUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20181114-translate-e.pdf#nameddest=b1r02
## 2 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20181212-translate-e.pdf#nameddest=b1r01
## 3 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20181212-translate-e.pdf#nameddest=b1r02
## 4 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190227-translate-e.pdf#nameddest=b1r01
##                                                                         FirstReadingDateHansardUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20181114-translate-c.pdf#nameddest=b1r02
## 2 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20181212-translate-c.pdf#nameddest=b1r01
## 3 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20181212-translate-c.pdf#nameddest=b1r02
## 4 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190227-translate-c.pdf#nameddest=b1r01
##   FirstReadingDate2 FirstReadingDate2HansardUrlEng
## 1                NA                               
## 2                NA                               
## 3                NA                               
## 4                NA                               
##   FirstReadingDate2HansardUrlChi
## 1                               
## 2                               
## 3                               
## 4                               
##                                                                                                                                      BillsCommitteeTitleEng
## 1                                                                                           Bills Committee on Inland Revenue (Amendment) (No. 7) Bill 2018
## 2 Bills Committee on Inland Revenue and MPF Schemes Legislation (Tax Deductions for Annuity Premiums and MPF Voluntary Contributions) (Amendment) Bill 2018
## 3                                                                 Bills Committee on Inland Revenue (Profits Tax Exemption for Funds) (Amendment) Bill 2018
## 4                                                                                                                                                          
##                                                                     BillsCommitteeTitleChi
## 1                                                    2018年稅務(修訂)(第7號)條例草案委員會
## 2 2018年稅務及強積金計劃法例(關於年金保費及強積金自願性供款的稅務扣除)(修訂)條例草案委員會
## 3                                       2018年稅務(豁免基金繳付利得稅)(修訂)條例草案委員會
## 4                                                                                         
##                                                BillsCommitteeUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/bc/bc03/general/bc03.htm
## 2 https://www.legco.gov.hk/yr18-19/english/bc/bc05/general/bc05.htm
## 3 https://www.legco.gov.hk/yr18-19/english/bc/bc06/general/bc06.htm
## 4                                                                  
##                                                BillsCommitteeUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/bc/bc03/general/bc03.htm
## 2 https://www.legco.gov.hk/yr18-19/chinese/bc/bc05/general/bc05.htm
## 3 https://www.legco.gov.hk/yr18-19/chinese/bc/bc06/general/bc06.htm
## 4                                                                  
##   BillsCommitteeFormationDate
## 1         2018-11-16T00:00:00
## 2         2018-12-14T00:00:00
## 3         2018-12-14T00:00:00
## 4                        <NA>
##                                                           BillsCommitteeReportUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/bc/bc03/reports/bc0320190220cb1-566-e.pdf
## 2 https://www.legco.gov.hk/yr18-19/english/bc/bc05/reports/bc0520190320cb1-693-e.pdf
## 3 https://www.legco.gov.hk/yr18-19/english/bc/bc06/reports/bc0620190220cb1-565-e.pdf
## 4                                                                                   
##                                                           BillsCommitteeReportUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/bc/bc03/reports/bc0320190220cb1-566-c.pdf
## 2 https://www.legco.gov.hk/yr18-19/chinese/bc/bc05/reports/bc0520190320cb1-693-c.pdf
## 3 https://www.legco.gov.hk/yr18-19/chinese/bc/bc06/reports/bc0620190220cb1-565-c.pdf
## 4                                                                                   
##     SecondReadingDate
## 1 2019-02-20T00:00:00
## 2 2019-03-20T00:00:00
## 3 2019-02-20T00:00:00
## 4 2019-04-17T00:00:00
##                                                                         SecondReadingDateHansardUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190220-translate-e.pdf#nameddest=b2d02a
## 2 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190320-translate-e.pdf#nameddest=b2d01a
## 3 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190220-translate-e.pdf#nameddest=b2d01a
## 4 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190417-translate-e.pdf#nameddest=b2d01a
##                                                                         SecondReadingDateHansardUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190220-translate-c.pdf#nameddest=b2d02a
## 2 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190320-translate-c.pdf#nameddest=b2d01a
## 3 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190220-translate-c.pdf#nameddest=b2d01a
## 4 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190417-translate-c.pdf#nameddest=b2d01a
##    SecondReadingDate2
## 1                <NA>
## 2                <NA>
## 3                <NA>
## 4 2019-04-18T00:00:00
##                                                                        SecondReadingDate2HansardUrlEng
## 1                                                                                                     
## 2                                                                                                     
## 3                                                                                                     
## 4 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190418-translate-e.pdf#nameddest=b2d01a
##                                                                        SecondReadingDate2HansardUrlChi
## 1                                                                                                     
## 2                                                                                                     
## 3                                                                                                     
## 4 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190418-translate-c.pdf#nameddest=b2d01a
##    SecondReadingDate3
## 1                <NA>
## 2                <NA>
## 3                <NA>
## 4 2019-05-08T00:00:00
##                                                                        SecondReadingDate3HansardUrlEng
## 1                                                                                                     
## 2                                                                                                     
## 3                                                                                                     
## 4 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190508-translate-e.pdf#nameddest=b2d01a
##                                                                        SecondReadingDate3HansardUrlChi
## 1                                                                                                     
## 2                                                                                                     
## 3                                                                                                     
## 4 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190508-translate-c.pdf#nameddest=b2d01a
##    SecondReadingDate4
## 1                <NA>
## 2                <NA>
## 3                <NA>
## 4 2019-05-09T00:00:00
##                                                                        SecondReadingDate4HansardUrlEng
## 1                                                                                                     
## 2                                                                                                     
## 3                                                                                                     
## 4 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190509-translate-e.pdf#nameddest=cwc01a
##                                                                        SecondReadingDate4HansardUrlChi
## 1                                                                                                     
## 2                                                                                                     
## 3                                                                                                     
## 4 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190509-translate-c.pdf#nameddest=cwc01a
##    SecondReadingDate5 SecondReadingDate5HansardUrlEng
## 1                <NA>                                
## 2                <NA>                                
## 3                <NA>                                
## 4 2019-05-15T00:00:00                                
##   SecondReadingDate5HansardUrlChi    ThirdReadingDate
## 1                                 2019-02-20T00:00:00
## 2                                 2019-03-20T00:00:00
## 3                                 2019-02-20T00:00:00
## 4                                 2019-05-16T00:00:00
##                                                                          ThirdReadingDateHansardUrlEng
## 1 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190220-translate-e.pdf#nameddest=b3r02a
## 2 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190320-translate-e.pdf#nameddest=b3r01a
## 3 https://www.legco.gov.hk/yr18-19/english/counmtg/hansard/cm20190220-translate-e.pdf#nameddest=b3r01a
## 4                                                                                                     
##                                                                          ThirdReadingDateHansardUrlChi
## 1 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190220-translate-c.pdf#nameddest=b3r02a
## 2 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190320-translate-c.pdf#nameddest=b3r01a
## 3 https://www.legco.gov.hk/yr18-19/chinese/counmtg/hansard/cm20190220-translate-c.pdf#nameddest=b3r01a
## 4                                                                                                     
##   AdditionalInformationEng AdditionalInformationChi
## 1                                                  
## 2                                                  
## 3                                                  
## 4                                                  
##                                       RemarksEng
## 1                                               
## 2                                               
## 3                                               
## 4 Read Hansard of 16 May 2019 for Second Reading
##                          RemarksChi
## 1                                  
## 2                                  
## 3                                  
## 4 二讀請參閱2019年5月16日的會議紀錄