# _tables

name: seattle-weather
schema:
{"name": "seattle-weather", "columns": [{"name": "date", "notnull": true, "type": "TEXT"}, {"name": "precipitation", "notnull": true, "type": "REAL"}, {"name": "temp_max", "notnull": true, "type": "REAL"}, {"name": "temp_min", "notnull": true, "type": "REAL"}, {"name": "wind", "notnull": true, "type": "REAL"}, {"name": "weather", "notnull": true, "type": "TEXT"}], "nrows": 1461}


name: dehli-weather
schema:
{"name": "dehli-weather", "columns": [{"name": "datetime_utc", "notnull": true, "type": "TEXT"}, {"name": "conds", "notnull": false, "type": "TEXT"}, {"name": "dewptm", "notnull": false, "type": "INTEGER"}, {"name": "fog", "notnull": true, "type": "INTEGER"}, {"name": "hail", "notnull": true, "type": "INTEGER"}, {"name": "heatindexm", "notnull": false, "type": "REAL"}, {"name": "hum", "notnull": false, "type": "TEXT"}, {"name": "precipm", "notnull": false, "type": "INTEGER"}, {"name": "pressurem", "notnull": false, "type": "REAL"}, {"name": "rain", "notnull": true, "type": "INTEGER"}, {"name": "snow", "notnull": true, "type": "INTEGER"}, {"name": "tempm", "notnull": false, "type": "INTEGER"}, {"name": "thunder", "notnull": true, "type": "INTEGER"}, {"name": "tornado", "notnull": true, "type": "INTEGER"}, {"name": "vism", "notnull": false, "type": "REAL"}, {"name": "wdird", "notnull": false, "type": "INTEGER"}, {"name": "wdire", "notnull": false, "type": "TEXT"}, {"name": "wgustm", "notnull": false, "type": "REAL"}, {"name": "windchillm", "notnull": false, "type": "REAL"}, {"name": "wspdm", "notnull": false, "type": "REAL"}], "title": "Weather data for New Dehli", "description": null, "nrows": 100990}


name: smhi-bromma-20190408-luftfuktighet
schema:
{"name": "smhi-bromma-20190408-luftfuktighet", "columns": [{"name": "datum", "notnull": true, "type": "TEXT"}, {"name": "tid__utc_", "notnull": true, "type": "TEXT"}, {"name": "luftfuktighet", "notnull": true, "type": "INTEGER"}, {"name": "kvalitet", "notnull": true, "type": "TEXT"}], "nrows": 3137}


name: smhi-bromma-20190408-lufttemperatur
schema:
{"name": "smhi-bromma-20190408-lufttemperatur", "columns": [{"name": "datum", "notnull": true, "type": "TEXT"}, {"name": "tid__utc_", "notnull": true, "type": "TEXT"}, {"name": "lufttemperatur", "notnull": true, "type": "REAL"}, {"name": "kvalitet", "notnull": true, "type": "TEXT"}], "nrows": 3131}


# _views

name: tempfukt
schema:
{"name": "tempfukt", "description": "", "query": {"select": "lufttemperatur, luftfuktighet", "columns": ["lufttemperatur", "luftfuktighet"], "from": "\"smhi-bromma-20190408-lufttemperatur\" as t, \"smhi-bromma-20190408-luftfuktighet\" as f", "where": "t.datum=f.datum and t.tid__utc_==f.tid__utc_", "orderby": "t.datum, t.tid__utc_", "limit": null}, "sources": ["smhi-bromma-20190408-lufttemperatur", "smhi-bromma-20190408-luftfuktighet"], "columns": [{"name": "lufttemperatur", "type": "REAL"}, {"name": "luftfuktighet", "type": "INTEGER"}]}


name: many
schema:
{"name": "many", "description": null, "query": {"select": "fog, hail, hum, tempm", "columns": ["fog", "hail", "hum", "tempm"], "from": "\"dehli-weather\"", "where": "", "orderby": "", "limit": null}, "sources": ["dehli-weather"], "columns": [{"name": "fog", "type": "INTEGER"}, {"name": "hail", "type": "INTEGER"}, {"name": "hum", "type": "TEXT"}, {"name": "tempm", "type": "INTEGER"}], "title": "fog, hail, hum, tempm"}


name: tf5
schema:
{"name": "tf5", "description": "", "query": {"select": "lufttemperatur as \"t+\", luftfuktighet as \"f?\"", "columns": ["t+", "f?"], "from": "\"smhi-bromma-20190408-lufttemperatur\" as t, \"smhi-bromma-20190408-luftfuktighet\" as f", "where": "t.datum=f.datum and t.tid__utc_==f.tid__utc_", "orderby": "t.datum, t.tid__utc_", "limit": null}, "sources": ["smhi-bromma-20190408-lufttemperatur", "smhi-bromma-20190408-luftfuktighet"], "columns": [{"name": "t+", "type": "REAL"}, {"name": "f?", "type": "INTEGER"}]}


