Meeting Attendance Database

2022-10-28

Source: vignettes/attn.Rmd

Introduction

This database contains the attendance record of Council and committee open meetings since the sixth term.

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

Key Identifiers

Here are the key identifies that is useful for locating the necessary data from the Attendance Database:

  • CommitteeID is the numerical ID of a LegCo committee. It is same as the one in the Meeting Schedule Database.

  • MeetID is the numerical ID of a Council or committee meeting. It is same as the one in the Meeting Schedule Database.

  • MemberID is the numerical ID of a LegCo member. It is same as the one in the Meeting Schedule Database. Note that it is a separate identifier from the SpeakerID of the Hansard 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 members absent from the Council meeting on May 22, 2019
attendance(meet_id = 136897, from = "2019-05-22", to = "2019-05-22", attn = "a", count = TRUE)
## [1] "2"

This database is accessible with the following function:

attendance()

attendance() fetches the attendance record of one or more LegCo meeting(s), or the attendance record of one of more LegCo member(s), or both.

# Fetch members who were absent from the Subcommittee on Issues Relating to Bazaars meetings on October 13, 2017
attendance(committee_id = 2704, from = "2017-10-13", to = "2017-10-13", attn = "a")
##   CommitteeID MeetID                                    MeetingNameEnglish
## 1        2704 127931 Meeting of Subcommittee on Issues Relating to Bazaars
## 2        2704 127931 Meeting of Subcommittee on Issues Relating to Bazaars
## 3        2704 127931 Meeting of Subcommittee on Issues Relating to Bazaars
## 4        2704 127931 Meeting of Subcommittee on Issues Relating to Bazaars
## 5        2704 127931 Meeting of Subcommittee on Issues Relating to Bazaars
##       MeetingNameChinese MeetingStartDateTime MemberID      MemberNameEnglish
## 1 墟市事宜小組委員會會議  2017-10-13 08:30:00      750 Hon Steven HO Chun-yin
## 2 墟市事宜小組委員會會議  2017-10-13 08:30:00      759      Hon Kenneth LEUNG
## 3 墟市事宜小組委員會會議  2017-10-13 08:30:00      776       Hon CHU Hoi-dick
## 4 墟市事宜小組委員會會議  2017-10-13 08:30:00      779        Hon HO Kai-ming
## 5 墟市事宜小組委員會會議  2017-10-13 08:30:00      791     Hon LUK Chung-hung
##   MemberNameChinese PresentAbsent
## 1        何俊賢議員        Absent
## 2        梁繼昌議員        Absent
## 3        朱凱廸議員        Absent
## 4        何啟明議員        Absent
## 5        陸頌雄議員        Absent
# Fetch the meetings that Hon Chu Hoi-dick was absent from
v <- attendance(member_id = 776, attn = "a")
head(v)
##   CommitteeID MeetID              MeetingNameEnglish MeetingNameChinese
## 1        2548 120628 Regular House Committee Meeting     內務委員會例會
## 2        2548 120629      Meeting of House Committee     內務委員會會議
## 3        2548 120630      Meeting of House Committee     內務委員會會議
## 4        2548 120631      Meeting of House Committee     內務委員會會議
## 5        2548 120632      Meeting of House Committee     內務委員會會議
## 6        2548 120639      Meeting of House Committee     內務委員會會議
##   MeetingStartDateTime MemberID MemberNameEnglish MemberNameChinese
## 1  2017-01-06 14:30:00      776  Hon CHU Hoi-dick        朱凱廸議員
## 2  2017-01-13 14:30:00      776  Hon CHU Hoi-dick        朱凱廸議員
## 3  2017-01-20 14:30:00      776  Hon CHU Hoi-dick        朱凱廸議員
## 4  2017-02-03 14:30:00      776  Hon CHU Hoi-dick        朱凱廸議員
## 5  2017-02-10 14:30:00      776  Hon CHU Hoi-dick        朱凱廸議員
## 6  2017-05-12 14:30:00      776  Hon CHU Hoi-dick        朱凱廸議員
##   PresentAbsent
## 1        Absent
## 2        Absent
## 3        Absent
## 4        Absent
## 5        Absent
## 6        Absent