home / fixtures / facetable_by_state

Menu

facetable_by_state (view)

3 rows

View and edit SQL

Export data

facetable_by_state

All rows in this view

TSV All 3 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 3 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 3 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 3 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 3 rows
    One JSON object per line
    View Download
  • testall All 3 rows
    View Download
  • testnone All 3 rows
    View Download
  • testresponse All 3 rows
    View Download

Suggested facets
  • avg_on_earth
state row_count planet_total avg_on_earth
CA 10 10 1.0
MC 1 2 0.0
MI 4 4 1.0
View definition
CREATE VIEW facetable_by_state AS
    SELECT
        state,
        count(*) AS row_count,
        sum(planet_int) AS planet_total,
        avg(on_earth) AS avg_on_earth
    FROM facetable
    GROUP BY state;
Powered by Datasette · Queries took 16.504ms