25:["$","title",null,{"children":"Strikes in the US | Andrew Witherspoon | Observable"}] 49:T6de,chart = { let margin = { top: 30, left: 30, bottom: 50, right: 30 }; let height = 1000 - margin.top - margin.bottom; let width = 1000 - margin.left - margin.right; let xScale = d3 .scaleTime() .range([0, width]) .domain([ d3.min(chartData, (d) => d.stoppage_start), d3.max(chartData, (d) => d.stoppage_end) ]); let yScale = d3 .scaleLinear() .range([0, height]) .domain([ 0, d3.max(chartData, (d) => d.y_pos) + chartData[chartData.length - 1].workers ]); let colorScale = d3.scaleOrdinal(d3.schemeCategory10); const svg = d3 .create("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); let plot = svg .append("g") .attr("transform", `translate(${margin.left},${margin.top})`); let xAxisBottom = plot .append("g") .classed("axis x-axis", true) .attr("transform", "translate(0," + (height + 5) + ")") .call(d3.axisBottom(xScale).tickSize(5)); let xAxisTop = plot .append("g") .classed("axis x-axis", true) .attr("transform", "translate(0," + -5 + ")") .call(d3.axisTop(xScale).tickSize(5)); let strikeGroup = plot .selectAll(".strike-group") .data(chartData) .enter() .append("g") .attr("class", (d, i) => `s-${i} strike-group`) .on("mouseover", (e, d) => console.log(d)); let strikeBar = strikeGroup .append("rect") .attr("x", (d) => xScale(d.stoppage_start)) .attr("y", (d) => yScale(d.y_pos)) .attr("height", (d, i) => yScale(d.workers)) .attr("width", (d) => xScale(d.stoppage_end) - xScale(d.stoppage_start)) .attr("fill", (d) => colorScale(d.sectorName)); return svg.node(); }4a:T895,sectorChart = { let margin = { top: 30, left: 200, bottom: 50, right: 45 }; let height = 800 - margin.top - margin.bottom; let width = 620 - margin.left - margin.right; let xScale = d3 .scaleLinear() .range([0, width]) .domain([0, d3.max(sectorToChart, (d) => d.daysMedian)]); let yScale = d3 .scaleLinear() .range([0, height]) .domain([ 0, d3.max(sectorToChart, (d) => d.y_pos) + sectorToChart[sectorToChart.length - 1].workersTotal ]); const svg = d3 .create("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); let plot = svg .append("g") .attr("transform", `translate(${margin.left},${margin.top})`); // let xAxisBottom = plot // .append("g") // .classed("axis x-axis", true) // .attr("transform", "translate(0," + (height + 5) + ")") // .call(d3.axisBottom(xScale).tickSize(5)); // let xAxisTop = plot // .append("g") // .classed("axis x-axis", true) // .attr("transform", "translate(0," + -5 + ")") // .call(d3.axisTop(xScale).tickSize(5)); let strikeGroup = plot .selectAll(".strike-group") .data(sectorToChart) .enter() .append("g") .attr("class", (d, i) => `s-${i} strike-group`) .on("mouseover", (e, d) => console.log(d)); let sectorName = strikeGroup .append("text") .text((d) => d.name) .attr("x", -10) .attr("y", (d) => yScale(d.y_pos + d.workersTotal / 2) + 4) .attr("text-anchor", "end") .attr("font-size", "10"); let dayCount = strikeGroup .append("text") .text((d, i) => i == 0 ? `${parseInt(d.daysMedian.toFixed(0))} days` : parseInt(d.daysMedian.toFixed(0)) ) .attr("x", (d) => xScale(d.daysMedian) + 5) .attr("y", (d) => yScale(d.y_pos + d.workersTotal / 2) + 4) .attr("text-anchor", "start") .attr("font-size", "10"); let strikeBar = strikeGroup .append("rect") .attr("x", (d) => xScale(0)) .attr("y", (d) => yScale(d.y_pos)) .attr("height", (d, i) => yScale(d.workersTotal)) .attr("width", (d) => xScale(d.daysMedian)); return svg.node(); }4b:[{"id":"afc21da073c2852e7869cb133ab7474ba3f12a929fdf3217158203509846e3f4de2168c94f6165617878775ffd1617449419fd5f5eded82062c4aadf12499b89","href":"https://static.observableusercontent.com/files/afc21da073c2852e7869cb133ab7474ba3f12a929fdf3217158203509846e3f4de2168c94f6165617878775ffd1617449419fd5f5eded82062c4aadf12499b89","name":"annual-listing.xlsx - To chart.csv","type":"text/csv","lastModified":1692045510702.752,"size":1109},{"id":"36021bc893fde7b0b93c5356f47045fb847c0ff1ce5161ca33c5a7a785aa470d485d88d242e7237f256e78f5381e38786875b1bae0ff8d53aadd802420366c91","href":"https://static.observableusercontent.com/files/36021bc893fde7b0b93c5356f47045fb847c0ff1ce5161ca33c5a7a785aa470d485d88d242e7237f256e78f5381e38786875b1bae0ff8d53aadd802420366c91","name":"data@2.json","type":"application/json","lastModified":1692129664385.762,"size":2714759},{"id":"9a16b49f3086f3af728bc0406d3c5e25760433a1fa34c1f89b7d3f5b873269e0a33a3f37d06a6b78f0dd33d99f601469bb9587e2809f99f257491413e20496c0","href":"https://static.observableusercontent.com/files/9a16b49f3086f3af728bc0406d3c5e25760433a1fa34c1f89b7d3f5b873269e0a33a3f37d06a6b78f0dd33d99f601469bb9587e2809f99f257491413e20496c0","name":"sectorDict.json","type":"application/json","lastModified":1691784439974.032,"size":915},{"id":"fe385a5b6db2a11e15a14cf8e40c9a434cf4ff3c90cf5e9f6fcc2e64794ca5e3db6f2a0398dd6105dea2a8031b9f4674da0f9c80f58713e8887cd65bfc4cad87","href":"https://static.observableusercontent.com/files/fe385a5b6db2a11e15a14cf8e40c9a434cf4ff3c90cf5e9f6fcc2e64794ca5e3db6f2a0398dd6105dea2a8031b9f4674da0f9c80f58713e8887cd65bfc4cad87","name":"data.json","type":"application/json","lastModified":1691782264083.737,"size":188866},{"id":"61a683467820b299e3b5c3676ef0c29cdd8b92da15e061edc924e8b263053665154ee210cd1cfe8b7673686196e3a9a05baa4131a78cd773c8ae17f003858aa8","href":"https://static.observableusercontent.com/files/61a683467820b299e3b5c3676ef0c29cdd8b92da15e061edc924e8b263053665154ee210cd1cfe8b7673686196e3a9a05baa4131a78cd773c8ae17f003858aa8","name":"sectorDict@1.json","type":"application/json","lastModified":1692026097193.041,"size":866}] 29:{"id":"30d543796834e39c","slug":null,"title":"Strikes in the US","thumbnail":"ed9d8b0d09e3a39b1cec414dc329b3d5739f9687b562603873257d7c092bfa3a","access_level":"public","create_time":"$D2023-08-01T21:23:31.487Z","update_time":"$D2023-08-16T15:24:50.240Z","view_time":null,"first_public_time":"$D2023-08-01T21:23:31.487Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"e9d0700f86f0bd9d","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":815,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"60290e9aa8cc207b","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"60290e9aa8cc207b","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Strikes in the US","cells":[{"id":0,"value":"# Strikes in the US\nLooking into [BLS data](https://www.bls.gov/wsp/) on work stoppages in the US.\n- [Strikes involving 1,000+ workers from 1993 to now](https://www.bls.gov/web/wkstp/monthly-listing.htm)\n- [Annual work stoppages from 1947-now](https://www.bls.gov/web/wkstp/annual-listing.htm)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"***\n## Visualizations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":579,"value":"**Annual worker days idle from strikes**
\nAmong strikes involving 1,000+ workers, 1947-2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":580,"value":"Plot.plot({\n marginLeft: 70,\n marks: [\n Plot.auto(await FileAttachment(\"annual-listing.xlsx - To chart.csv\").csv({typed: true}), {x: \"year\", y: \"idle_days\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":243,"value":"**20 longest strikes**
\nAmong strikes involving 1,000+ workers, 1993-present","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":247,"value":"Plot.plot({\n marginLeft: 300,\n marginRight: 100,\n color: { type: \"categorical\", legend: true },\n marks: [\n Plot.barX(\n strikeDataParsed.sort((a, b) => b.days - a.days).filter((d, i) => i < 20),\n {\n x: \"days\",\n y: \"org\",\n fill: \"sectorName\",\n sort: { y: \"x\", reverse: true }\n }\n ),\n Plot.text(\n strikeDataParsed.sort((a, b) => b.days - a.days).filter((d, i) => i < 20),\n {\n x: \"days\",\n y: \"org\",\n text: (d) =>\n `${formatNumber(\n d.days\n )} (${d.stoppage_start.getUTCFullYear()} - ${d.stoppage_end.getUTCFullYear()})`,\n dx: 3,\n textAnchor: \"start\"\n }\n ),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"**20 strikes with the most idle employee days**
\nAmong strikes involving 1,000+ workers, 1993-present","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":316,"value":"Plot.plot({\n marginLeft: 300,\n marginRight: 150,\n color: { type: \"categorical\", legend: true },\n marks: [\n Plot.barX(\n strikeDataParsed\n .sort((a, b) => b.days_idle - a.days_idle)\n .filter((d, i) => i < 20),\n {\n x: \"days_idle\",\n y: \"org\",\n fill: \"sectorName\",\n sort: { y: \"x\", reverse: true }\n }\n ),\n Plot.text(\n strikeDataParsed\n .sort((a, b) => b.days_idle - a.days_idle)\n .filter((d, i) => i < 20),\n {\n x: \"days_idle\",\n y: \"org\",\n text: (d) =>\n `${formatNumber(d.days_idle)} (${d.workers / 1000}k ppl, ${\n d.days\n } days)`,\n dx: 3,\n textAnchor: \"start\"\n }\n ),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"**Number of US strikes by sector**
\nAmong strikes involving 1,000+ workers, 1993-present","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":123,"value":"Plot.plot({\n marginLeft: 220,\n marginRight: 50,\n x: { label: \"Number of strikes\" },\n y: { grid: false, label: \"\" },\n marks: [\n Plot.barX(strikesBySector, {\n y: \"name\",\n x: \"count\",\n sort: { y: \"x\", reverse: true }\n }),\n Plot.text(strikesBySector, {\n x: \"count\",\n y: \"name\",\n text: (d) => d.count,\n dy: 2,\n dx: 3,\n textAnchor: \"start\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"**Median length of US strikes by sector**
\nAmong strikes involving 1,000+ workers, 1993-present","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":222,"value":"Plot.plot({\n marginLeft: 220,\n marginRight: 50,\n x: { label: \"Days\" },\n y: { grid: false, label: \"\" },\n marks: [\n Plot.barX(strikesBySector, {\n y: \"name\",\n x: \"daysMedian\",\n sort: { y: \"x\", reverse: true }\n }),\n Plot.text(strikesBySector, {\n x: \"daysMedian\",\n y: \"name\",\n text: (d) => d.daysMedian.toFixed(0),\n dy: 2,\n dx: 3,\n textAnchor: \"start\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"**Histogram of strikes by number of days**
\nAmong strikes involving 1,000+ workers, 1993-present. The median number of days per strike in the dataset is ${d3.median(strikeDataParsed, d=> d.days)} days. The most common is ${d3.mode(strikeDataParsed, d=> d.days)} day.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":710,"value":"Plot.plot({\n marks: [\n Plot.rectY(\n strikeDataParsed,\n Plot.binX(\n { y: \"count\" },\n { x: \"days\", thresholds: 100, domain: [0, 1000] }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"**Histogram of strikes by number of workers involved**
\nAmong strikes involving 1,000+ workers, 1993-present. The median number of workers per strike in the dataset is ${formatNumber(d3.median(strikeDataParsed, d=> d.workers))} workers. The most common is ${formatNumber(d3.mode(strikeDataParsed, d=> d.workers))} workers. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":722,"value":"Plot.plot({\n marks: [\n Plot.rectY(\n strikeDataParsed,\n Plot.binX(\n { y: \"count\" },\n { x: \"workers\", thresholds: 200, domain: [0, 100000] }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"**Distribution of the lengths of strike by sector**
\nAmong strikes involving 1,000+ workers, 1993-present","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":327,"value":"Plot.plot({\n marginLeft: 220,\n x: { domain: [0, 150], clamp: true },\n y: { label: \"\" },\n r: { range: [1, 15] },\n marks: [\n // Plot.dot(strikeDataParsed, {\n // x: \"days\",\n // fy: \"sectorName\",\n // r: \"workers\",\n // opacity: 0.5,\n // sort: { fy: \"x\", reverse: true }\n // })\n Plot.tickX(strikeDataParsed, {\n x: \"days\",\n fy: \"sectorName\",\n opacity: 0.5\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"Plot.plot({\n height: 2000,\n marginLeft: 220,\n x: { domain: [0, 150], clamp: true, grid: true },\n r: { range: [1, 10] },\n marks: [\n Plot.dotX(\n strikeDataParsed,\n Plot.dodgeY({\n x: \"days\",\n fy: \"sectorName\",\n title: \"name\",\n r: \"workers\",\n fill: \"sectorName\",\n anchor: \"middle\",\n sort: { fy: \"x\", reverse: true }\n })\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"**Relationship between length of strike and number of workers**
\nAmong strikes involving 1,000+ workers, 1993-present. Circles sized by number of workers and colored by sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":450,"value":"Plot.plot({\n height: 700,\n width: 700,\n marginLeft: 50,\n color: { legend: true },\n x: { type: \"log\", clamp: true },\n y: { type: \"log\", clamp: true },\n marks: [\n Plot.dot(strikeDataParsed, {\n x: \"days\",\n y: \"workers\",\n r: \"workers\",\n fill: \"sectorName\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":480,"value":"**Relationship between length of strike and number of workers, by sector**
\nAmong strikes involving 1,000+ workers, 1993-present. Circles sized by number of strikes.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":465,"value":"Plot.plot({\n height: 700,\n width: 700,\n color: { legend: true },\n x: { domain: [0, 50], clamp: true, grid: true },\n y: { domain: [0, 10000], clamp: true, grid: true },\n marks: [\n Plot.dot(strikesBySector, {\n x: \"daysMedian\",\n y: \"workersMedian\",\n r: \"count\",\n fill: \"name\"\n }),\n Plot.text(strikesBySector, {\n x: \"daysMedian\",\n y: \"workersMedian\",\n text: \"name\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"**Timeline of strikes since `${selectedYear}`**
\nAmong strikes involving 1,000+ workers. Each bar is a strike, sized vertically by number of workers and colored by its sector. Some strikes that are only a few days long are too short to visually render.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":564,"value":"viewof selectedYear = Inputs.range([1993, 2023], {\n label: \"Select a start year\",\n step: 1,\n value: 1993\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":482,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":636,"value":"**Median length of strikes by sector since 1993**
\nAmong strikes involving 1,000+ workers. Each bar is a sector, sized vertically by number of workers involved. Ranging from 1.1m *(manufacturing)* to 1,200 *(agriculture, forestry, fishing, and hunting)*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":638,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":616,"value":"**Table of all the strikes since 1993**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"strikeDataParsed","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":666,"value":"**Table of strikes by sector**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":671,"value":"strikesBySector","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"***\n## Parsing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":27,"value":"strikeDataParsed = strikeDataRaw.map((d) => {\n let start = parseTime(d.stoppage_start);\n let end = d.stoppage_end == \"[4]\" ? new Date() : parseTime(d.stoppage_end);\n let days =\n (new Date(end).getTime() - new Date(start).getTime()) / (1000 * 3600 * 24);\n d.stoppage_start = start;\n d.stoppage_end = end;\n d.days = parseInt((days + 1).toFixed(0));\n\n let naics = d.industry.toString();\n d.naics = naics;\n d.sector = naics.substring(0, 2);\n d.subsector = naics.substring(0, 3);\n d.sectorName = sectorDict[d.sector];\n delete d.industry;\n return d;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"strikesBySector = sectors\n .map((s) => {\n let data = strikeDataParsed.filter((f) => f.sectorName == s);\n let obj = {\n name: s,\n count: data.length,\n workersTotal: d3.sum(data, (d) => d.workers),\n daysIdleTotal: d3.sum(data, (d) => d.days_idle),\n daysTotal: d3.sum(data, (d) => d.days_idle),\n workersMedian: d3.median(data, (d) => d.workers),\n daysIdleMedian: d3.median(data, (d) => d.days_idle),\n daysMedian: d3.median(data, (d) => d.days),\n data\n };\n return obj;\n })\n .filter((f) => f.count > 0)\n .sort((a, b) => b.daysMedian - a.daysMedian)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"sectorToChart = strikesBySector.map((d, i) => {\n d.y_pos =\n i == 0\n ? 0\n : i == 1\n ? strikesBySector[i - 1].workersTotal + 50000\n : strikesBySector[i - 1].y_pos +\n strikesBySector[i - 1].workersTotal +\n 50000;\n return d;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":514,"value":"dataToChart = strikeDataParsed\n .filter((f) => f.stoppage_end > new Date(selectedYear, 0, 1))\n .sort((a, b) => a.stoppage_end - b.stoppage_end)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"value":"chartData = dataToChart.map((d, i) => {\n d.y_pos =\n i == 0\n ? 0\n : i == 1\n ? dataToChart[i - 1].workers\n : dataToChart[i - 1].y_pos + dataToChart[i - 1].workers;\n return d;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"***\n## Data and utilities","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":23,"value":"strikeDataRaw = FileAttachment(\"data.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"annualData = FileAttachment(\"annual-listing.xlsx - To chart.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":794,"value":"annualToChart = annualData.map((d) => {\n let obj = {\n date: d.year,\n value: parseInt(d.idle_days)\n };\n return obj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"parseTime = d3.timeParse(\"%Y-%m-%-d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"sectorDict = FileAttachment(\"sectorDict@1.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"sectors = [...new Set(Object.values(sectorDict))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":695,"value":"ilrData = FileAttachment(\"data@2.json\")\n .json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"function formatNumber(x) {\n return x.toString().replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 24:null