Table Structure

The information in the table below shows the data points that are available for each city in the database. These points serve as a guide for users to ask relevant questions about them.

CREATE TABLE weather (
    city            TEXT         NOT NULL,
    state           TEXT         NOT NULL,
    latitude        DECIMAL(8,6) NOT NULL,
    longitude       DECIMAL(9,6) NOT NULL,
    timezone        TEXT         NOT NULL,
    time_offset     TEXT         NOT NULL,
    summary         TEXT         NOT NULL,
    temperature     DECIMAL(8,2) NOT NULL,
    dewpoint        DECIMAL(8,2) NOT NULL,
    wind_speed      DECIMAL(8,2) NOT NULL,
    wind_gust       DECIMAL(8,2) NOT NULL,
    wind_bearing    DECIMAL(8,2) NOT NULL,
    cloud_cover     DECIMAL(8,2) NOT NULL,
    humidity        DECIMAL(8,2) NOT NULL,
    pressure        DECIMAL(8,2) NOT NULL,
    visibility      DECIMAL(8,2) NOT NULL,
    date_updated    TIMESTAMP    NOT NULL,
PRIMARY KEY (city, state));