2f:T4d1,{ const tidy_data = tidy( perceived, filter(d => d.type != "High level of perceived anti-social behaviour"), pivotWider({ namesFrom: 'year', valuesFrom: 'percent' }), mutate({ change: d => d['2023'] - d['2013'] }) ) const plot = Plot.plot({ style: {fontSize: "14px", fontFamily: "'Open Sans', sans-serif"}, marginLeft: 380, marginBottom: 50, x: {grid: true, domain: [0,30], label: "Percentage point change", labelOffset: 50, tickSize: 0}, y: {label: null, domain: d3.sort(tidy_data, d => d["change"]).map(d => d.type), tickSize: 0}, marks: [ Plot.link(tidy_data, {x1: "2023", y1: "type", x2: "2013", y2: "type", stroke: d => d.change > 0 ? "#F66068" : "#206095", strokeWidth: 1.5}), Plot.dot(tidy_data, {x: "2023", y: "type", r: 5, fill: d => d.change > 0 ? "#F66068" : "#206095", title: (d) => `${d.type} \n ${d.change} percentage points`}) ], caption: html`

Source: ONS – Crime Survey for England & Wales

`, tooltip: {opacity: 0.7} }) return plot }30:T4f7,{ const tidy_data = tidy( experienced, filter(d => d.type != "Personally experienced/witnessed anti-social behaviour in local area"), pivotWider({ namesFrom: 'year', valuesFrom: 'percent' }), mutate({ change: d => d['2023'] - d['2013'] }) ) const plot = Plot.plot({ style: {fontSize: "14px", fontFamily: "'Open Sans', sans-serif"}, marginLeft: 420, marginBottom: 50, x: {grid: true, domain: [0,30], label: "Percentage point change", labelOffset: 50, tickSize: 0}, y: {label: null, domain: d3.sort(tidy_data, d => -d["change"]).map(d => d.type), tickSize: 0}, marks: [ Plot.link(tidy_data, {x1: "2023", y1: "type", x2: "2013", y2: "type", stroke: d => d.change > 0 ? "#F66068" : "#206095", strokeWidth: 1.5}), Plot.dot(tidy_data, {x: "2023", y: "type", r: 5, fill: d => d.change > 0 ? "#F66068" : "#206095", title: (d) => `${d.type} \n ${Math.round(d.change)} percentage points`}) ], caption: html`

Source: ONS – Crime Survey for England & Wales

`, tooltip: {opacity: 0.7} }) return plot }31:[{"id":"d7b42d486b8f7a2f2429fc77cd7e48a90d7a19133cac9409fd7ae8e22fe13693e09871a111d4ce789c55d3033f93f70b0777ed1cbbe2d61e971fa7a8dfeb6080","href":"https://static.observableusercontent.com/files/d7b42d486b8f7a2f2429fc77cd7e48a90d7a19133cac9409fd7ae8e22fe13693e09871a111d4ce789c55d3033f93f70b0777ed1cbbe2d61e971fa7a8dfeb6080","name":"perceived_ASB.csv","type":"text/csv","lastModified":1693485350673.746,"size":1151},{"id":"f7cfcfce97d1d799a0d672548d146c1e2d76776aa1318ac484bd28858452d7090dca111472f8bdfbca4e912864e852724c00e8926a957bf7a88c394bff76aca0","href":"https://static.observableusercontent.com/files/f7cfcfce97d1d799a0d672548d146c1e2d76776aa1318ac484bd28858452d7090dca111472f8bdfbca4e912864e852724c00e8926a957bf7a88c394bff76aca0","name":"experienced_ASB.csv","type":"text/csv","lastModified":1693485350698.933,"size":1365}] 2d:{"title":"Anti-social behaviour (ASB)","cells":[{"id":0,"value":"# Anti-social behaviour (ASB)","pinned":false,"hidden":false,"mode":"md"},{"id":36,"value":"### Perception of ASB\nIn the year ending March 2023, 8% of adults perceived there to be a high level of anti-social behaviour (ASB) in their local area. This is a 5 percentage point ${textcolor(\"decline\", {background: '#206095', color: '#FFFFFF'})} on the year ending March 2013. \n\nCompared with 10 years ago, the proportion of adults perceiving problems in all types of ASB has fallen.","pinned":false,"hidden":false,"mode":"md"},{"id":100,"value":"**Percentage saying there is a very/fairly big problem in their area**","pinned":false,"hidden":false,"mode":"md"},{"id":18,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":135,"value":"Inputs.table(perceived_wide, {\n columns: [\n \"type\",\n \"2013\",\n \"2023\"\n ],\n header: {\n type: \"Perceived ASB\"\n },\n format: {\n \"2013\": x => d3.format(\".0%\")(x/100),\n \"2023\": x => d3.format(\".0%\")(x/100)\n },\n width: {\n type: 350\n },\n sort: \"2023\", \n reverse: true,\n maxWidth: 650,\n layout: \"fixed\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":180,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":65,"value":"### Experienced/witnessed ASB\n34% of adults indicated that they had personally experienced or witnessed at least one of the ASB problems asked about in their local area in the previous year. This an ${textcolor(\"increase\", {background: '#F66068', color: '#FFFFFF'})} of 5 percentage points on the year ending March 2013.\n\nThe percentage of adults experiencing or witnessing anti-social behaviour increased for nearly all types of ASB. 'People using or dealing drugs', 'Vehicle related behaviour', and 'Litter, rubbish or dog-fouling' rose by between 5 and 7 percentage points since the year ending March 2013.","pinned":false,"hidden":false,"mode":"md"},{"id":103,"value":"**Types of anti-social behaviour experienced/witnessed**","pinned":false,"hidden":false,"mode":"md"},{"id":57,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":153,"value":"Inputs.table(experienced_wide, {\n columns: [\n \"type\",\n \"2013\",\n \"2023\"\n ],\n header: {\n type: \"Experienced ASB\"\n },\n format: {\n \"2013\": x => d3.format(\".0%\")(x/100),\n \"2023\": x => d3.format(\".0%\")(x/100)\n },\n width: {\n type: 350\n },\n sort: \"2023\", \n reverse: true,\n maxWidth: 650,\n layout: \"fixed\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"---\n## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":14,"value":"import {tidy, select, filter, mutate, pivotWider} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"import {textcolor} from \"@observablehq/text-color-annotations-in-markdown\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3,"value":"perceived = d3.csvParse(await FileAttachment(\"perceived_ASB.csv\").text(), d => ({\n type: d.type,\n year: +d.year,\n percent: +d.percent\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"experienced = d3.csvParse(await FileAttachment(\"experienced_ASB.csv\").text(), d => ({\n type: d.type,\n year: +d.year,\n percent: +d.percent\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"perceived_wide = tidy(\n perceived,\n filter(d => d.type != \"High level of perceived anti-social behaviour\"),\n pivotWider({ namesFrom: 'year', valuesFrom: ['percent'] })\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":155,"value":"experienced_wide = tidy(\n experienced,\n filter(d => d.type != \"Personally experienced/witnessed anti-social behaviour in local area\"),\n pivotWider({ namesFrom: 'year', valuesFrom: 'percent' })\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"style = html``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}