About this Dataset

Judicial Appointments Commission - Junior Dataset

Publisher name: Judicial Appointments Commission
Last updated: 2022-07-01T04:01:07Z

Tables

2022-01-31 Organogram (Junior)

@ukgov.judicial_appointments_commission_junior_dataset.n_2022_01_31_organogram_junior

9.47 KB
30 rows
11 columns


CREATE TABLE n_2022_01_31_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2022-01-31 Organogram (Senior)

@ukgov.judicial_appointments_commission_junior_dataset.n_2022_01_31_organogram_senior

16.21 KB
2 rows
20 columns


CREATE TABLE n_2022_01_31_organogram_senior (
  "post_unique_reference" VARCHAR,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "job_title" VARCHAR,
  "job_team_function" VARCHAR,
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "contact_phone" DOUBLE,
  "contact_e_mail" VARCHAR,
  "reports_to_senior_post" VARCHAR,
  "salary_cost_of_reports" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);

2022-04-30 Organogram (Junior)

@ukgov.judicial_appointments_commission_junior_dataset.n_2022_04_30_organogram_junior

9.48 KB
31 rows
11 columns


CREATE TABLE n_2022_04_30_organogram_junior (
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "reporting_senior_post" VARCHAR,
  "grade" VARCHAR,
  "payscale_minimum" BIGINT,
  "payscale_maximum" BIGINT,
  "generic_job_title" VARCHAR,
  "number_of_posts_in_fte" DOUBLE,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR
);

2022-04-30 Organogram (Senior)

@ukgov.judicial_appointments_commission_junior_dataset.n_2022_04_30_organogram_senior

16.21 KB
2 rows
20 columns


CREATE TABLE n_2022_04_30_organogram_senior (
  "post_unique_reference" VARCHAR,
  "name" VARCHAR,
  "grade_or_equivalent" VARCHAR,
  "job_title" VARCHAR,
  "job_team_function" VARCHAR,
  "parent_department" VARCHAR,
  "organisation" VARCHAR,
  "unit" VARCHAR,
  "contact_phone" DOUBLE,
  "contact_e_mail" VARCHAR,
  "reports_to_senior_post" VARCHAR,
  "salary_cost_of_reports" BIGINT,
  "fte" DOUBLE,
  "actual_pay_floor" VARCHAR,
  "actual_pay_ceiling" VARCHAR,
  "unnamed_15" VARCHAR,
  "professional_occupational_group" VARCHAR,
  "office_region" VARCHAR,
  "notes" VARCHAR,
  "valid" BIGINT
);