GitHub
GitHub

Periods

Periods semantic contract, with monthly periods as atomic units for reporting and analytics.

Semantic Contract

Definitions

ColumnDescription
idUnique identifier for the period.
periodNumeric representation of the period (e.g., YYYYMM, such as 202601 for January 2026).
dateRepresentative date for the period defined as the first day of the month.

Sample & Implementation

A list of Monthly Periods
idperioddate
02500
125012025-01-01
225022025-02-01
325032025-03-01
425042025-04-01
525052025-05-01
625062025-06-01
725072025-07-01
825082025-08-01
925092025-09-01
1025102025-10-01
1125112025-11-01
1225122025-12-01
1326012026-01-01
1426022026-02-01
1526032026-03-01
1626042026-04-01
1726052026-05-01
1826062026-06-01
1926072026-07-01
2026082026-08-01
2126092026-09-01
2226102026-10-01
2326112026-11-01
2426122026-12-01
2527012027-01-01
2627022027-02-01
2727032027-03-01
2827042027-04-01
2927052027-05-01
3027062027-06-01
3127072027-07-01
3227082027-08-01
3327092027-09-01
3427102027-10-01
3527112027-11-01
3627122027-12-01
CREATE TABLE IF NOT EXISTS periods (
    id INTEGER PRIMARY KEY,
    period INTEGER NOT NULL,
    date DATE
)

Data Format

Field

Type

Dependencies

  • None.

On this page

Semantic Contract
Definitions
Sample & Implementation
Data Format
Dependencies