31:T196a,raw = [ { "year": "2011", "quarter": "1", "data_status": "F", "jobs_total": "449767", "jobs_under_50k": "379655", "jobs_over_50k": "70112" }, { "year": "2011", "quarter": "2", "data_status": "F", "jobs_total": "489931", "jobs_under_50k": "418201", "jobs_over_50k": "71730" }, { "year": "2011", "quarter": "3", "data_status": "F", "jobs_total": "506388", "jobs_under_50k": "433015", "jobs_over_50k": "73373" }, { "year": "2011", "quarter": "4", "data_status": "F", "jobs_total": "486448", "jobs_under_50k": "412739", "jobs_over_50k": "73709" }, { "year": "2012", "quarter": "1", "data_status": "F", "jobs_total": "463433", "jobs_under_50k": "387827", "jobs_over_50k": "75606" }, { "year": "2012", "quarter": "2", "data_status": "F", "jobs_total": "504358", "jobs_under_50k": "427178", "jobs_over_50k": "77180" }, { "year": "2012", "quarter": "3", "data_status": "F", "jobs_total": "515200", "jobs_under_50k": "438422", "jobs_over_50k": "76778" }, { "year": "2012", "quarter": "4", "data_status": "F", "jobs_total": "498219", "jobs_under_50k": "418822", "jobs_over_50k": "79397" }, { "year": "2013", "quarter": "1", "data_status": "F", "jobs_total": "472722", "jobs_under_50k": "393208", "jobs_over_50k": "79514" }, { "year": "2013", "quarter": "2", "data_status": "F", "jobs_total": "517534", "jobs_under_50k": "435981", "jobs_over_50k": "81553" }, { "year": "2013", "quarter": "3", "data_status": "F", "jobs_total": "526931", "jobs_under_50k": "444581", "jobs_over_50k": "82350" }, { "year": "2013", "quarter": "4", "data_status": "F", "jobs_total": "501324", "jobs_under_50k": "417511", "jobs_over_50k": "83813" }, { "year": "2014", "quarter": "1", "data_status": "F", "jobs_total": "473853", "jobs_under_50k": "389748", "jobs_over_50k": "84105" }, { "year": "2014", "quarter": "2", "data_status": "F", "jobs_total": "521743", "jobs_under_50k": "435246", "jobs_over_50k": "86497" }, { "year": "2014", "quarter": "3", "data_status": "F", "jobs_total": "537790", "jobs_under_50k": "450474", "jobs_over_50k": "87316" }, { "year": "2014", "quarter": "4", "data_status": "F", "jobs_total": "515893", "jobs_under_50k": "426089", "jobs_over_50k": "89804" }, { "year": "2015", "quarter": "1", "data_status": "F", "jobs_total": "492932", "jobs_under_50k": "401616", "jobs_over_50k": "91316" }, { "year": "2015", "quarter": "2", "data_status": "F", "jobs_total": "534177", "jobs_under_50k": "440772", "jobs_over_50k": "93405" }, { "year": "2015", "quarter": "3", "data_status": "F", "jobs_total": "541873", "jobs_under_50k": "446789", "jobs_over_50k": "95084" }, { "year": "2015", "quarter": "4", "data_status": "F", "jobs_total": "522773", "jobs_under_50k": "425233", "jobs_over_50k": "97540" }, { "year": "2016", "quarter": "1", "data_status": "F", "jobs_total": "495809", "jobs_under_50k": "398907", "jobs_over_50k": "96902" }, { "year": "2016", "quarter": "2", "data_status": "F", "jobs_total": "537782", "jobs_under_50k": "438949", "jobs_over_50k": "98833" }, { "year": "2016", "quarter": "3", "data_status": "F", "jobs_total": "549725", "jobs_under_50k": "449725", "jobs_over_50k": "100000" }, { "year": "2016", "quarter": "4", "data_status": "F", "jobs_total": "525869", "jobs_under_50k": "425006", "jobs_over_50k": "100863" }, { "year": "2017", "quarter": "1", "data_status": "F", "jobs_total": "502234", "jobs_under_50k": "398884", "jobs_over_50k": "103350" }, { "year": "2017", "quarter": "2", "data_status": "F", "jobs_total": "548442", "jobs_under_50k": "442337", "jobs_over_50k": "106105" }, { "year": "2017", "quarter": "3", "data_status": "F", "jobs_total": "552752", "jobs_under_50k": "447084", "jobs_over_50k": "105668" }, { "year": "2017", "quarter": "4", "data_status": "F", "jobs_total": "531688", "jobs_under_50k": "424038", "jobs_over_50k": "107650" }, { "year": "2018", "quarter": "1", "data_status": "F", "jobs_total": "508217", "jobs_under_50k": "399824", "jobs_over_50k": "108393" }, { "year": "2018", "quarter": "2", "data_status": "F", "jobs_total": "553556", "jobs_under_50k": "443182", "jobs_over_50k": "110374" }, { "year": "2018", "quarter": "3", "data_status": "F", "jobs_total": "560902", "jobs_under_50k": "449188", "jobs_over_50k": "111714" }, { "year": "2018", "quarter": "4", "data_status": "F", "jobs_total": "542250", "jobs_under_50k": "427455", "jobs_over_50k": "114795" }, { "year": "2019", "quarter": "1", "data_status": "F", "jobs_total": "515167", "jobs_under_50k": "399399", "jobs_over_50k": "115768" }, { "year": "2019", "quarter": "2", "data_status": "F", "jobs_total": "559587", "jobs_under_50k": "441466", "jobs_over_50k": "118121" }, { "year": "2019", "quarter": "3", "data_status": "F", "jobs_total": "566562", "jobs_under_50k": "447094", "jobs_over_50k": "119468" }, { "year": "2019", "quarter": "4", "data_status": "F", "jobs_total": "549048", "jobs_under_50k": "426375", "jobs_over_50k": "122673" }, { "year": "2020", "quarter": "1", "data_status": "F", "jobs_total": "521824", "jobs_under_50k": "398786", "jobs_over_50k": "123038" }, { "year": "2020", "quarter": "2", "data_status": "F", "jobs_total": "521807", "jobs_under_50k": "396471", "jobs_over_50k": "125336" }, { "year": "2020", "quarter": "3", "data_status": "F", "jobs_total": "545175", "jobs_under_50k": "418035", "jobs_over_50k": "127140" }, { "year": "2020", "quarter": "4", "data_status": "P", "jobs_total": "541703", "jobs_under_50k": "409254", "jobs_over_50k": "132449" } ]32:T566,chart = () => embed({ config: baseConfig, data: {values: data}, width: Math.min(width, 600), height: 400, autosize: "fit", layer: [ { mark: { type: 'bar', color: '#cebc9f', opacity: 0.7, }, encoding: { x: {"field": "date", "type": "ordinal", title: '', axis: {grid: false, values: xLabels, labelAngle: 0, gridDash: [1,1]}}, y: {"field": "jobs_total", "type": "quantitative", title: 'Number of Montana jobs', axis: {grid: true, format: 's', domain: false, gridDash: [2,2]}, scale: {domain: [0, 800000]} } } }, { mark: { type: 'bar', color: '#806f47', opacity: 0.5, }, encoding: { x: {"field": "date", "type": "ordinal"}, y: {"field": "jobs_over_50k", "type": "quantitative"} } }, ] .concat(makeAnnotationLayers(annotations)) .concat([{ mark: {type: 'bar', color: '#F85028'}, data: {values: [ {date: '2021-Q1', 'jobs_over_50k': 0}, {date: '2021-Q2', 'jobs_over_50k': 0}, {date: '2021-Q3', 'jobs_over_50k': 0}, {date: '2021-Q4', 'jobs_over_50k': gianforteGoal} ]}, encoding: { x: {"field": "date", "type": "ordinal"}, y: {"field": "jobs_over_50k", "type": "quantitative"} } }]) }, { actions: false, } )33:[] 2f:{"title":"Montana job creation, 2011 to 2020","cells":[{"id":0,"value":"md`# Montana job creation, 2011 to 2020\n\nData from records request to Montana Dept. of Labor & Industry, June 2021.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":152,"value":"chartEmbed = html`\n

\n \n

Montana job counts by quarter

Figures reflect wage-based employment.

${await makeLegend()}

${await chart()}

Data: Montana Dept. of Labor & Industry. Chart: Eric Dietrich / MTFP

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"data = {\n const parseDate = d3.timeParse(\"%Y-%q\")\n const formatDate = d3.timeFormat('%Y-%m-%d')\n return raw.map(d => ({\n // ...d,\n // date: formatDate(parseDate(`${d.year}-${d.quarter}`)),\n date: `${d.year}-Q${d.quarter}`,\n quarter: d.quarter,\n jobs_total: d.jobs_total,\n jobs_over_50k: d.jobs_over_50k,\n }))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"gianforteGoal = +data.slice(-1)[0]['jobs_over_50k'] + 10000","pinned":false,"hidden":false,"mode":"ojs"},{"id":127,"value":"annotations = [\n // {label: 'COVID-19 pandemic begins', date: '2020-Q1'},\n {label: 'Gianforte\\'s goal', date: '2021-Q4'},\n {label: 'Gianforte takes office', date: '2021-Q1'},\n {label: 'Bullock takes office', date: '2013-Q1'},\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":137,"value":"xLabels = (width > 500) ? \n [\n '2011-Q1',\n '2012-Q1',\n '2013-Q1',\n '2014-Q1',\n '2015-Q1',\n '2016-Q1',\n '2017-Q1',\n '2018-Q1',\n '2019-Q1',\n '2020-Q1',\n '2021-Q1',\n ] :\n // fewer labels on small screens\n [\n '2011-Q1',\n '2013-Q1',\n '2015-Q1',\n '2017-Q1',\n '2019-Q1',\n '2021-Q1',\n ]","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"makeLegend = (color, barLabel, lineLabel, width=2) => html`

\n \n Jobs paying $50k or less\n\n \n Jobs paying more than $50k/year\n\n \n Governor's Q4 2021 goal for $50k+ jobs\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":128,"value":"makeAnnotationLayers = (annotations) => [\n {\n mark: {type: 'rule', opacity: 0.5},\n data: {values: annotations},\n encoding: {\n x: {field: 'date', type: 'ordinal'}\n }\n },\n {\n mark: { type:'text', angle: 90, dy: -7, dx: 3, align: 'left'},\n data: {values: annotations},\n encoding: {\n x: {field: 'date', type: 'ordinal'},\n y: {value: 0,},\n text: {field: 'label', type: 'nominal'}\n }\n }\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":79,"value":"baseConfig = ({\n \"view\": {\n \"stroke\": \"transparent\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":66,"value":"embed = require(\"vega-embed@6\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}