31:[] 2f:{"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"},{"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"},{"id":34,"value":"html`${data.rows.map(row => ``).join()}

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

`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":4,"value":"vegalite = require(\"@observablehq/vega-lite@0.1\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require(\"d3-fetch@1\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}