Data Dictionary

ID
Location ID
Type
int4
Description

Unique identifier of the location where the facility is located. Refer to Locations spreadsheet

ID
Course_ID
Type
int4
Description

Unique identifier of the course

ID
Course Title
Type
text
Description

Title of a drop-in course

ID
Age Min
Type
text
Description

Minimum age required to register for the course minimum allowable age in months

ID
Age Max
Type
text
Description

Maximum age limit to register for the course, maximum allowable age in months

ID
Date Range
Type
text
Description

Calendar range when the course runs

ID
Start Hour
Type
int4
Description

Start hour (24 hours range)

ID
Start Minute
Type
int4
Description

Start min

ID
End Hour
Type
int4
Description

End hour (24 hours range)

ID
End Min
Type
int4
Description

End min

ID
First Date
Type
date
Description

First date when the course runs.

ID
Last Date
Type
date
Description

Last date of the course

ID
DayOftheWeek
Type
text
Description

Week day of the course

Additional Information

Field Value
Data last updated 2 July 2025
Metadata last updated 2 April 2026
Created 2 July 2025
Format XLSX
License No License Provided
Datastore activeTrue
Datastore cache{'CSV': '90f7fffe-658b-4a79-bce3-a91c1b5886de', 'XML': '5b208f61-3b0e-4992-9435-94e420234415', 'JSON': '067b41e7-ac8a-4d3f-ad08-089f8cd70316'}
Datastore cache last update39 minutes ago
Extract jobAirflow: Integration Pipeline registered-programs-and-drop-in-courses-offering
Has viewsTrue
Idc99ec04f-4540-482c-9ee4-efb38774eab4
Is previewTrue
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Package id1a5be46a-4039-48cd-a2d2-8e702abf9516
Position1
Record count31,678
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline registered-programs-and-drop-in-courses-offering
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID