meetings

id

Row identifier

minister

Minister whose diary this entry is from

date

Date of the meeting

year

Diary year

time

Start/end time of the meeting

meeting

Description of the meeting

location

Location of the meeting

attendees

Who attended

portfolio

Ministerial portfolio the meeting relates to

source_url

Link to the original source PDF on beehive.govt.nz

is_date_imputed

1 if the date was not directly extractable from the source PDF and was inferred (e.g. from context or filename); 0 otherwise

196,957 rows sorted by date descending

This data as json, CSV (advanced)

Next page

CREATE TABLE "meetings" (
"id" INTEGER,
  "minister" TEXT,
  "date" TEXT,
  "year" TEXT,
  "time" TEXT,
  "meeting" TEXT,
  "location" TEXT,
  "attendees" TEXT,
  "portfolio" TEXT,
  "source_url" TEXT,
  "is_date_imputed" INTEGER
);
CREATE INDEX idx_minister ON meetings(minister);
CREATE INDEX idx_date ON meetings(date);