2d:null 2e:["$","title",null,{"children":"Datasette and Vega | John Muyskens | Observable"}] 33:[] 31:{"id":"17d7c8b2296cdeb0","slug":"datasette-and-vega","title":"Datasette and Vega","thumbnail":null,"access_level":"public","create_time":"$D2018-02-04T01:49:09.710Z","update_time":"$D2018-02-21T21:00:55.119Z","view_time":null,"first_public_time":"$D2018-02-07T21:53:20.542Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"005b77629f9df560","login":"jmuyskens","name":"John Muyskens","avatar_url":"https://avatars-next.observableusercontent.com/3c35c79dc6869747f90be0c3a417c733a9ca65b6fc81825b82cacecb7f64fd50","tier":"starter_2024"},"version":41,"publish_version":41,"role":null,"authored":false,"authors":[{"type":"individual","id":"719376c8720885af","login":"jmuyskens","name":"John Muyskens","avatar_url":"https://avatars-next.observableusercontent.com/3c35c79dc6869747f90be0c3a417c733a9ca65b6fc81825b82cacecb7f64fd50","tier":null}],"members":[{"type":"individual","id":"719376c8720885af","login":"jmuyskens","name":"John Muyskens","avatar_url":"https://avatars-next.observableusercontent.com/3c35c79dc6869747f90be0c3a417c733a9ca65b6fc81825b82cacecb7f64fd50","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Datasette and Vega","cells":[{"id":0,"value":"md`# Datasette and Vega\nThis uses 538 dataset [Actions under the Antiquities Act](https://github.com/fivethirtyeight/data/tree/master/antiquities-act)\n\n[This data is queryable as a Datasette](https://fivethirtyeight.datasettes.com/fivethirtyeight-2628db9/antiquities-act%2Factions_under_antiquities_act)\n\nWe run the following SQL query [in Datasette](https://fivethirtyeight.datasettes.com/fivethirtyeight-2628db9?sql=SELECT+states%2C+SUM%28acres_affected%29+%0D%0AFROM+%5Bantiquities-act%2Factions_under_antiquities_act%5D+%0D%0AGROUP+BY+states+%0D%0AORDER+BY+SUM%28acres_affected%29+%0D%0ADESC+LIMIT+20%3B):\n\n\tSELECT states, SUM(acres_affected) \n\tFROM [antiquities-act/actions_under_antiquities_act] \n\tGROUP BY states \n\tORDER BY SUM(acres_affected) DESC\n\tLIMIT 20;\n\nNote that this query is purely for demonstration purposes and isn't meaningful because \"acres affected\" could represent an increase or decrease in area.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"data = d3.json(\"https://fivethirtyeight.datasettes.com/fivethirtyeight-2628db9.json?sql=select+states%2C+SUM%28acres_affected%29+from+%5Bantiquities-act%2Factions_under_antiquities_act%5D+group+by+states+order+by+SUM%28acres_affected%29+desc+LIMIT+20\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"html`${data.rows.map(row => ``).join()}

State	Acres affected
${row[0]}	${row[1]}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"vegalite({\n \"$schema\": \"https://vega.github.io/schema/vega-lite/v2.json\",\n \"description\": \"A simple bar chart with embedded data.\",\n \"width\": 300,\n \"title\": \"National Landmarks acres affected\",\n \"data\": {\n \"url\": \"https://fivethirtyeight.datasettes.com/fivethirtyeight-2628db9.json?sql=select+states%2C+SUM%28acres_affected%29+from+%5Bantiquities-act%2Factions_under_antiquities_act%5D+group+by+states+order+by+SUM%28acres_affected%29+desc+LIMIT+20\",\n \"format\": {\"property\": \"rows\"}\n },\n \"mark\": \"bar\",\n \"encoding\": {\n \"y\": {\"field\": \"0\", \"type\": \"ordinal\", \"sort\": {\"field\": \"1\"}, \"title\": \"hi\"},\n \"x\": {\"field\": \"1\", \"type\": \"quantitative\"}\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"vegalite = require(\"@observablehq/vega-lite@0.1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"d3 = require(\"d3-fetch@1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"