Load all CAP data tables from S3 — get_cap

Reads every coaching action plan (CAP) data table that was written by the new_update_caps_26 automation and returns them as a named list of tibbles. Tables are stored as Parquet files in the coaching-data-tl S3 bucket.

The returned list contains the following elements:

ids: One row per unique CAP (teacher × cycle). Includes cap_id, teacher_name, district, school, start_date, end_date, cycle_num, coach, content_area, and sheet_id.
area_of_focus: IPG indicator and rationale for each CAP.
smart_goals: The full SMART goal string for each CAP.
metrics: Observable evidence of success ratings, long format.
action_plans: Menu of coaching moves selected for each CAP.
progress_monitoring: Per-date progress monitoring ratings, long format.
decision_log: Decision log entries grouped by date and category.
reflections: Post-cycle reflection question / response pairs.

get_cap_data(
  cycle = 1L,
  tables = c("ids", "area_of_focus", "smart_goals", "metrics", "action_plans",
    "progress_monitoring", "decision_log", "reflections")
)

Arguments

cycle: Integer scalar (1, 2, or 3). Which coaching cycle's data to return. Defaults to 1.
tables: Character vector naming which tables to load. Defaults to all eight tables. Valid values are "ids", "area_of_focus", "smart_goals", "metrics", "action_plans", "progress_monitoring", "decision_log", and "reflections".

Value

A named list of tibbles.