forerad

Utilities for collecting and analyzing with Citibike data in Python
Log | Files | Refs | README

20231030_01_HoM9F-create-the-initial-schema.sql (294B)

      1 -- Create the initial schema
      2 -- depends: 
      3 CREATE TABLE hourly_volume_rollup (
      4     datetime NUMERIC NOT NULL PRIMARY KEY,
      5     local_date TEXT NOT NULL,
      6     queens_trips NUMERIC,
      7     brooklyn_trips NUMERIC,
      8     manhattan_trips NUMERIC,
      9     bronx_trips NUMERIC,
     10     staten_island_trips NUMERIC
     11 );