# _tables

name: iris_flower_measurements
schema:
{"name": "iris_flower_measurements", "columns": [{"name": "sepal_length", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 35}, "min": {"title": "Minimum", "value": 4.3}, "mean": {"title": "Mean", "value": 5.843333333333334}, "median": {"title": "Median", "value": 5.8}, "max": {"title": "Maximum", "value": 7.9}, "stdev": {"title": "Standard deviation", "value": 0.8280661279778629}}}, {"name": "sepal_width", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 23}, "min": {"title": "Minimum", "value": 2.0}, "mean": {"title": "Mean", "value": 3.0573333333333332}, "median": {"title": "Median", "value": 3.0}, "max": {"title": "Maximum", "value": 4.4}, "stdev": {"title": "Standard deviation", "value": 0.4358662849366982}}}, {"name": "petal_length", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 43}, "min": {"title": "Minimum", "value": 1.0}, "mean": {"title": "Mean", "value": 3.758}, "median": {"title": "Median", "value": 4.3}, "max": {"title": "Maximum", "value": 6.9}, "stdev": {"title": "Standard deviation", "value": 1.7652982332594664}}}, {"name": "petal_width", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 22}, "min": {"title": "Minimum", "value": 0.1}, "mean": {"title": "Mean", "value": 1.1993333333333334}, "median": {"title": "Median", "value": 1.3}, "max": {"title": "Maximum", "value": 2.5}, "stdev": {"title": "Standard deviation", "value": 0.7622376689603465}}}, {"name": "class", "notnull": true, "type": "TEXT", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 3, "info": ["Iris-versicolor", "Iris-virginica", "Iris-setosa"]}, "min": {"title": "Lexical minimum", "value": "Iris-setosa"}, "max": {"title": "Lexical maximum", "value": "Iris-virginica"}}}], "nrows": 150}


name: dow_jones_index
schema:
{"name": "dow_jones_index", "columns": [{"name": "quarter", "notnull": true, "type": "INTEGER", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 2, "info": [1, 2]}, "min": {"title": "Minimum", "value": 1}, "mean": {"title": "Mean", "value": 1.52}, "median": {"title": "Median", "value": 2}, "max": {"title": "Maximum", "value": 2}, "stdev": {"title": "Standard deviation", "value": 0.4999332398688526}}}, {"name": "stock", "notnull": true, "type": "TEXT", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 30}, "min": {"title": "Lexical minimum", "value": "AA"}, "max": {"title": "Lexical maximum", "value": "XOM"}}}, {"name": "date", "notnull": true, "type": "TEXT", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 25}, "min": {"title": "Lexical minimum", "value": "2011-01-07"}, "max": {"title": "Lexical maximum", "value": "2011-06-24"}}}, {"name": "open", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 722}, "min": {"title": "Minimum", "value": 10.59}, "mean": {"title": "Mean", "value": 53.65184}, "median": {"title": "Median", "value": 45.94}, "max": {"title": "Maximum", "value": 172.11}, "stdev": {"title": "Standard deviation", "value": 32.638851869352465}}}, {"name": "high", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 713}, "min": {"title": "Minimum", "value": 10.94}, "mean": {"title": "Mean", "value": 54.66998666666667}, "median": {"title": "Median", "value": 46.88}, "max": {"title": "Maximum", "value": 173.54}, "stdev": {"title": "Standard deviation", "value": 33.215993547832475}}}, {"name": "low", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 711}, "min": {"title": "Minimum", "value": 10.4}, "mean": {"title": "Mean", "value": 52.64016}, "median": {"title": "Median", "value": 44.77}, "max": {"title": "Maximum", "value": 167.82}, "stdev": {"title": "Standard deviation", "value": 32.11927743819801}}}, {"name": "close", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 711}, "min": {"title": "Minimum", "value": 10.52}, "mean": {"title": "Mean", "value": 53.72926666666667}, "median": {"title": "Median", "value": 45.86}, "max": {"title": "Maximum", "value": 170.58}, "stdev": {"title": "Standard deviation", "value": 32.78878668954249}}}, {"name": "volume", "notnull": true, "type": "INTEGER", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 750}, "min": {"title": "Minimum", "value": 9718851}, "mean": {"title": "Mean", "value": 117547801.40666667}, "median": {"title": "Median", "value": 53025186}, "max": {"title": "Maximum", "value": 1453438639}, "stdev": {"title": "Standard deviation", "value": 158438089.36082223}}}, {"name": "percent_change_price", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 745}, "min": {"title": "Minimum", "value": -15.4229}, "mean": {"title": "Mean", "value": 0.05026241}, "median": {"title": "Median", "value": 0.0}, "max": {"title": "Maximum", "value": 9.88223}, "stdev": {"title": "Standard deviation", "value": 2.5178092070482716}}}, {"name": "percent_change_volume_over_last_wk", "notnull": false, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": 30}, "nonnulls": {"title": "Non-NULL values", "value": 720}, "uniques": {"title": "Unique values", "value": 720}, "min": {"title": "Minimum", "value": -61.43317522}, "mean": {"title": "Mean", "value": 5.5936265450625}, "median": {"title": "Median", "value": 0.491083418}, "max": {"title": "Maximum", "value": 327.4089238}, "stdev": {"title": "Standard deviation", "value": 40.54347818664318}}}, {"name": "previous_weeks_volume", "notnull": false, "type": "INTEGER", "statistics": {"nulls": {"title": "NULL values", "value": 30}, "nonnulls": {"title": "Non-NULL values", "value": 720}, "uniques": {"title": "Unique values", "value": 720}, "min": {"title": "Minimum", "value": 9718851}, "mean": {"title": "Mean", "value": 117387644.83472222}, "median": {"title": "Median", "value": 52881329}, "max": {"title": "Maximum", "value": 1453438639}, "stdev": {"title": "Standard deviation", "value": 159232227.99587056}}}, {"name": "next_weeks_open", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 720}, "min": {"title": "Minimum", "value": 10.52}, "mean": {"title": "Mean", "value": 53.70244}, "median": {"title": "Median", "value": 46.0}, "max": {"title": "Maximum", "value": 172.11}, "stdev": {"title": "Standard deviation", "value": 32.778110524441004}}}, {"name": "next_weeks_close", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 715}, "min": {"title": "Minimum", "value": 10.52}, "mean": {"title": "Mean", "value": 53.88908}, "median": {"title": "Median", "value": 46.0}, "max": {"title": "Maximum", "value": 174.54}, "stdev": {"title": "Standard deviation", "value": 33.016676574062714}}}, {"name": "percent_change_next_weeks_price", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 745}, "min": {"title": "Minimum", "value": -15.4229}, "mean": {"title": "Mean", "value": 0.23846810386666667}, "median": {"title": "Median", "value": 0.0919963}, "max": {"title": "Maximum", "value": 9.88223}, "stdev": {"title": "Standard deviation", "value": 2.679538347014115}}}, {"name": "days_to_next_dividend", "notnull": true, "type": "INTEGER", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 105}, "min": {"title": "Minimum", "value": 0}, "mean": {"title": "Mean", "value": 52.525333333333336}, "median": {"title": "Median", "value": 47}, "max": {"title": "Maximum", "value": 336}, "stdev": {"title": "Standard deviation", "value": 46.3350977114411}}}, {"name": "percent_return_next_dividend", "notnull": true, "type": "REAL", "statistics": {"nulls": {"title": "NULL values", "value": false}, "uniques": {"title": "Unique values", "value": 729}, "min": {"title": "Minimum", "value": 0.0655738}, "mean": {"title": "Mean", "value": 0.6918255848}, "median": {"title": "Median", "value": 0.680934}, "max": {"title": "Maximum", "value": 1.56421}, "stdev": {"title": "Standard deviation", "value": 0.305481871477662}}}], "nrows": 750}


# _views

name: iris-setosa
schema:
{"name": "iris-setosa", "title": null, "description": null, "query": {"select": "sepal_length, sepal_width, petal_length, petal_width", "columns": ["sepal_length", "sepal_width", "petal_length", "petal_width"], "from": "iris_flower_measurements", "where": "class='Iris-setosa'", "orderby": null, "limit": null, "offset": null}, "sources": ["iris_flower_measurements"], "columns": [{"name": "sepal_length", "type": "REAL"}, {"name": "sepal_width", "type": "REAL"}, {"name": "petal_length", "type": "REAL"}, {"name": "petal_width", "type": "REAL"}]}


