31:T416,embed_tables = md`

Initial Claims - Highest 5 States

${html`

${stackedbars}

`} ${ic_top_five ? html`

${table(sparkuniverse(ic_top_five), {"width" : "275px", "cols" : ["Rank", "State", "Last Six", "Current"]})}

` : ""}

`32:T554,stackedbars = { const x = vl.x().fieldQ("culmen_length_mm").scale({ zero: false }); const y = vl.y().fieldQ("flipper_length_mm").scale({ zero: false }); const color = vl.color().fieldN("species").scale({ scheme: "set2" }); const stackedBar = vl .layer( vl.markBar().encode( vl.x().fieldO("date").timeUnit("monthdate"), vl.y().sum("initial_claims").axis({ format: "s" }), //.stack("normalize").axis({ format: "%" }), vl.color().fieldN("state_abbreviation").scale({ range: stackedbarcolors }) ) .width(130) .height(100) ) const stackedBarOne = vl .layer( vl.markBar().encode( vl.x().fieldO("date").timeUnit("monthdate"), vl.y().sum("initial_claims").stack("normalize").axis({ format: "%" }), vl.color().fieldN("state_abbreviation").scale({ range: stackedbarcolors }) ) .width(130) .height(100) ) return vl.vconcat(stackedBar, stackedBarOne) .title("Total Initial Claims, U.S.") .data(ic_top_five_and_other) .config({concat: { spacing: 0 } , view:{stroke: "transparent"}, axisLeft: {title: "Initial Claims", orient: "right"}, axisBottom: {title: null}, header: {title: null}, legend: {title: null, direction: "horizontal", orient: "bottom"}}) .render(); }33:[{"id":"00f256dc5eade89272c18799c242604acda43049e282446e61788721355695dc2cfc6fbe6c92956af9453641b203a231693e4732d6f9e56dc9489b8f1eba4d9f","href":"https://static.observableusercontent.com/files/00f256dc5eade89272c18799c242604acda43049e282446e61788721355695dc2cfc6fbe6c92956af9453641b203a231693e4732d6f9e56dc9489b8f1eba4d9f","name":"Initial Claims All States (1).json","type":"application/json","lastModified":1604348512236.812,"size":37436},{"id":"3851cc0bb5a5491a32d03e2f843e3bc31febd14edaf106719f997e623efc0c163eea6c6f1ac6435370e55edd18a22f22649abd362fab1798fd846f1581a5bd02","href":"https://static.observableusercontent.com/files/3851cc0bb5a5491a32d03e2f843e3bc31febd14edaf106719f997e623efc0c163eea6c6f1ac6435370e55edd18a22f22649abd362fab1798fd846f1581a5bd02","name":"Initial Claims All States.json","type":"application/json","lastModified":1610074360125.354,"size":37461},{"id":"c4850c821992addbd5b58576e2bf25f91edeedb771559f47acba2c46410c00dbc275d7c2c3429956a609b3eeffed2f950542048ed96fd7cf4e2a459385c9fc4c","href":"https://static.observableusercontent.com/files/c4850c821992addbd5b58576e2bf25f91edeedb771559f47acba2c46410c00dbc275d7c2c3429956a609b3eeffed2f950542048ed96fd7cf4e2a459385c9fc4c","name":"Initial Claims All States@2.json","type":"application/json","lastModified":1613791594144.906,"size":38435}] 2f:{"title":"Demographic Update - Claims","cells":[{"id":0,"value":"title = md`# Demographic Update - Claims\n#### ${max_date.toLocaleDateString('en-gb', {\n year: 'numeric',\n month: 'short',\n day: 'numeric',\n timeZone: 'utc'\n})} | Source(s): FRED\n

\n\nThis document is a work in progress.\n\nTODO\n\n- Scale claims by population (claims per million?)\n- More descriptive title & tag-line\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":418,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":547,"value":"ic_top_five_and_other = other_states_sum_array.concat(top_five_states_sum_array)","pinned":false,"hidden":false,"mode":"ojs"},{"id":558,"value":"top_five_states_sum_array = Object.values(top_five_states_sum)","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"other_states_sum_array = Object.values(other_states_sum)","pinned":false,"hidden":false,"mode":"ojs"},{"id":563,"value":"stackedbarcolors = [ibm[2].hex, ibm[0].hex]","pinned":false,"hidden":false,"mode":"ojs"},{"id":681,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"md`### Calcs`","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"highest_claims = data_most_recent.filter(obj => {\n return obj.initial_claims === Math.max(...data_most_recent.map(o => o.initial_claims))\n})[0]","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"ic_top_five = data_most_recent.slice()\n .sort((a, b) => {\n return b.initial_claims - a.initial_claims\n })\n .slice(0, 5)","pinned":false,"hidden":false,"mode":"ojs"},{"id":108,"value":"ic_top_five_names = ic_top_five.map(d => d.state_name)","pinned":false,"hidden":false,"mode":"ojs"},{"id":112,"value":"ic_top_five_claims = data.filter((d) => ic_top_five_names.includes(d.state_name))","pinned":false,"hidden":false,"mode":"ojs"},{"id":521,"value":"all_states_sum = data.reduce(function(res, value) {\n if (!res[value.date]) {\n res[value.date] = { date: value.date, initial_claims: 0 };\n }\n res[value.date].initial_claims += value.initial_claims;\n return res;\n}, {});","pinned":false,"hidden":false,"mode":"ojs"},{"id":528,"value":"top_five_states_sum = ic_top_five_claims.reduce(function(res, value) {\n if (!res[value.date]) {\n res[value.date] = { date: value.date, state_name: \"Top Five\", state_abbreviation: \"Top Five\", initial_claims: 0 };\n }\n res[value.date].initial_claims += value.initial_claims;\n return res;\n}, {});","pinned":false,"hidden":false,"mode":"ojs"},{"id":537,"value":"other_states_sum = Object.values(top_five_states_sum).reduce(function(res, value) {\n if (!res[value.date]) {\n res[value.date] = { date: value.date, state_name: \"Other\", state_abbreviation: \"Other\", initial_claims: 0 };\n }\n res[value.date].initial_claims = (all_states_sum[value.date].initial_claims - value.initial_claims);\n return res;\n}, {});","pinned":false,"hidden":false,"mode":"ojs"},{"id":507,"value":"ic_dates = data.map(d => d.date).filter((date, i, self) => \n self.findIndex(d => d.getTime() === date.getTime()) === i\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":56,"value":"max_date = new Date(Math.max(...data.map(o => o.date)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"header_data = md`### Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":85,"value":"data_most_recent = data.filter(d => {\n return d.date >= max_date\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"data = {\n var data = []\n raw_data.forEach(function(item, index, array) {\n data.push({\n \"date\" : parseTime(raw_data[index][\"date\"]),\n \"state_name\" : raw_data[index][\"state_name\"],\n \"state_abbreviation\" : raw_data[index][\"state_abbreviation\"],\n \"initial_claims\" : parseInt(raw_data[index][\"initial_claims\"])\n })\n })\n \n data = data.filter((d) => !isNaN(d.initial_claims))\n \n return data\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"raw_data = FileAttachment(\"Initial Claims All States@2.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":87,"value":"md`### Helper Functions & Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":303,"value":"sparkuniverse(ic_top_five)","pinned":true,"hidden":false,"mode":"ojs"},{"id":121,"value":"function sparkuniverse(data) {\n const sparkbars = []\n data.forEach((d,i) => {\n const data = extractValues(d.state_name, \"initial_claims\")\n const sparkbar_ = bar(data, {\"width\": 100, \"height\" : 45, \"highlights\" : {\"end\" : ibm[0].hex}})\n sparkbars.push(\n {\"rank\" : bigtext(i + 1, {\"font\" : \"bold 25px 'Kumbh Sans'\", \"color\" : \"dimgray\"}),\n \"state\" : bigtext(d.state_abbreviation, {\"font\" : \"bold 25px 'Kumbh Sans'\", \"baseline\" : \"middle\", \"color\" : ibm[0].hex}),\n \"trend\" : sparkbar_,\n \"recent\" : bigtext(parseInt(d.initial_claims/1000).toString().concat(\"k\"), {\"font\" : \"bold 25px 'Kumbh Sans'\", \"baseline\" : \"middle\", \"color\" : ibm[0].hex})})\n })\n return sparkbars;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":114,"value":"function extractValues(state_name, variable) {\n return data.filter(d => {\n return d.state_name === state_name\n }).map(d => d[variable])\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"parseTime = d3.utcParse(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":175,"value":"function addVector(a,b){\n return a.map((e,i) => e + b[i]);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":424,"value":"format_percent = d3.format(Object.assign(d3.formatSpecifier(\"%\"), {align: \">\", precision: d3.precisionFixed(0.1)}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":482,"value":"style = await html`\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":595,"value":"ibm = colors.color_blind_safe.ibm","pinned":true,"hidden":false,"mode":"ojs"},{"id":593,"value":"import {colors} from \"@hamzaamjad/color-palettes\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":259,"value":"import { bar, bigtext, table } from \"@probitascap/tiny-charts\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":428,"value":"import { vl } from \"@vega/vega-lite-api\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}