21:null 22:["$","title",null,{"children":"Ambulance Response Times in E2 areas in Tower Hamlets | SOSS Bethnal Green | Observable"}] 27:T830,# Ambulance Response Times in E2 areas in Tower Hamlets ## 2024 Update ## Ambulance response times in E2 areas of Tower Hamlets before and after low traffic neighbourhoods Low traffic neighbourhoods (LTNs) have been in place and operational in Tower Hamlets since July 2021. ### What we did We wanted to see if ambulance response times have changed in one of the areas where LTNs have been installed, an area that makes up part of the E2 postcode district (see map below). ### How we did it We used ambulance response time data from a freedom of information request to the London Ambulance Service. Using this data, we analysed response times in the E2 district, where road changes have been made to [*Arnold Circus*](https://goo.gl/maps/nBEUSrePgZCaiqSo8), [*Barnet Grove*](https://goo.gl/maps/mFEyjG5Ur6aJiY3m9), [*Old Bethnal Green Road*](https://goo.gl/maps/g1c7QJnSNgFYVJS78), [*Columbia Road*](https://goo.gl/maps/aqU8hfciGSNH3hjD8) and [*Wellington Row*](https://goo.gl/maps/K5hhqaj7UwUFpjAr6).^{[1](#cell-1142)} *Disclaimers: This analysis was done by volunteers working with the [Save Our Safer Streets campaign](https://heartbg.uk). Where possible, we've sought advice and comment from third parties with relevant experience or expertise. We ask that Tower Hamlets council undertake professional and verified analysis to understand the impacts of the LTNs and to determine the borough's needs and how best to serve its communities.* *The data provided from the London Ambulance Service represent averages per month rather than response times to individual callouts ([unlike the data we used for the fire services analysis](https://i.heartbg.uk/LFB-response-time-analysis)). Thus, the analysis we've conducted must be seen as more partial and the conclusions we can draw provisional. In particular we aren't able to look at whether observed trends are statistically significant. However, the data available suggests the LTNs are not impacting ambulance response times.*28:T5d1,

Key Results

Category 1 response times remain stable after the installation of E2's LTNs : When we compare category 1 ambulance response times in the postcode areas associated with the E2 LTNs, we see ambulance response times falling after the LTN installations. There are falls in all these E2 areas—between 4 seconds (E2 0) and 92 seconds (E2 7).

Overall, with small variations in response times since the E2 LTNs (in aggregate, a reduction of 38 seconds vs 37 seconds for Tower Hamlets as a whole), it is unlikely that the new road layouts have had an adverse impact on category 1 ambulance responses.

Category 2 response times in the E2 LTN areas are comparable with Tower Hamlets as a whole: Category 2 response times increased across Tower Hamlets from March 2020. However, response times in the areas associated with the E2 LTNs were not as badly impacted as Tower Hamlets as a whole. In aggregate, the Tower Hamlets response times rose by 22 minutes, 8 seconds. For the E2 LTN areas the rise was 20 minutes, 47 seconds.

With marginal differences between the LTN areas and Tower Hamlets as a whole, it is unlikely that the new road layouts adversely impacted category 2 ambulance response times.

29:T4a8,meanResponseTimesPlot = Plot.plot({ color: { type: "categorical", legend: true, scheme: "pastel2", legend: "ramp" }, x: { type: "time", label: "month →", grid: true, thresholds: "d3.utcMonth", tickFormat: d3.utcFormat("%b %y") }, y: { type: "time", domain: [0,3900000], tickFormat: d3.utcFormat("%M:%S"), label: "↑ average response times (mins:secs)" }, marks: [ Plot.line(ambulanceRT2024, { x: "utctimestamp", y: "mean ms", filter: (d) => d.Area === areaCompare2, stroke: "Category", strokeWidth: 1, strokeOpacity: 0.8 }), Plot.line(ambulanceRT2024, { x: "utctimestamp", y: "mean ms", stroke: "Category", strokeWidth: 1.8, strokeOpacity: 1, filter: (d) => d.Area === areaSelect2, marker: "circle" }), Plot.line(ambulanceRT2024, { x: "utctimestamp", y: "mean ms", stroke: "Category", strokeWidth: 1.8, strokeOpacity: 1, filter: (d) => d.Area === areaSelect2, marker: "circle" }) ], //marginLeft: 100, width: 640, height: 480, inset: 20, insetBottom: 20, marginBottom: 50 })2a:T534,## Comparisons before and after the new road layouts To see whether the LTNs have impacted ambulance response times, we want to compare the response times before and after they were installed in the five E2 postcode areas. > __In summary, for the E2 postcode areas near to the LTNs, we can say category 1 responses fell after the LTNs were installed. For category 2 calls, response times increased but the increases were comparable to the increases seen in Tower Hamlets as a whole.__ We've based our analysis on Tower Hamlets' LTNs being operational from 1st June 2021 (though some of the new road layouts were being modified well after this date). Comparisons were thus made between the average response times in like-for-like periods before and after June 2021. Specifically, we compared the ambulance service data between Dec 2019 to May 2020 and Dec 2021 to May 2022. We chose these periods so that we could analyse data from the six months prior to the beginning of work on the LTN scheme. We analysed data from five postcode areas in the E2 postcode district and for Tower Hamlets as a whole. The comparisons were broken down into category 1 and 2 responses. *The updated FOI data from LAS in 2024 did not contain a breakdown of the number of callous by category. As such it was not possible to update this analysis*2b:T9a3,

	Before (Dec 2019-May 2020)		After (Dec 2021-May 2022)
	Number of calls	Average response time (min:sec)	Number of calls	Average response time (min:sec)	Difference (sec)
E2 0	73	05:54	98	05:50	↓ 0.04
E2 6	86	05:56	83	05:47	↓ 0.08
E2 7	44	07:14	58	05:42	↓ 1.32
E2 8	54	07:14	54	06:26	↓ 0.48
E2 9	73	06:12	94	05:37	↓ 0.35
E2 LTN areas	330	06:30	387	05:52	↓ 0.38
E2	382	06:14	387	05:58	↓ 0.16
Tower Hamlets	1,778	06:53	2,297	06:16	↓ 0.37

2c:T66c,ambulancePlot = Plot.plot({ x: { label: "", domain: ["Before-6-month", "After-6-month"], tickFormat: (d) => d.split("-")[0] }, y: { label: "Response times ↑ (secs)", grid: true, inset: 3, type: "utc", tickFormat: d3.utcFormat("%M:%S"), //domain: [0,580000] }, color: { type: "categorical", scheme: "pastel2" }, facet: { data: ambulanceRT, x: "type", label: null }, fx: { insetLeft: 0, insetRight: 0, //padding: 0.3 }, marks: [ Plot.frame({ strokeWidth: 0.2 }), // Average response times for specificied ward before and after LTNs Plot.barY(ambulanceRT, Plot.groupX( {y: "mean"}, { x: "period", y: "mean ms", //sort: null, fill: "period", fillOpacity: 0.6, filter: (d) => d.Category === 1, facet: "include" })), Plot.text(ambulanceRT, Plot.groupX( {y: "mean", text: "mean"}, { x: "period", y: "mean ms", //text: d3.utcFormat("%M:%S")(d3.mean(ambulanceRT.filter(d => d.Category === 1), d => d["mean ms"])),//d3.mean(ambulanceRT, d => d["mean ms"]), dy: 11, filter: (d) => d.Category === 1, facet: "include" })), ], marginLeft: 50, // space to the left of the chart //marginBottom: 30, // space to the left of the chart marginTop: 60, // space below the chart insetBottom: 33, // space between the x-axis and the marks insetTop: 5, // space between the x-axis and the marks insetLeft: 5, insetRight: 5, width: 580, height: 240 })2d:T9b5,

	Before (Dec 2019-May 2020)		After (Dec 2021-May 2022)
	Number of calls	Average response time (min:sec)	Number of calls	Average response time (min:sec)	Difference (sec)
E2 0	435	19:37	490	40:43	↑ 21.06
E2 6	281	20:32	255	40:18	↑ 19:46
E2 7	390	20:30	345	38:57	↑ 18:27
E2 8	495	20:33	403	40:16	↑ 19:42
E2 9	488	18:11	393	43:02	↑ 24:51
E2 LTN areas	2,089	19:52	1,886	40:39	↑ 20:47
E2	2,089	19:52	1,886	40:52	↑ 21:01
Tower Hamlets	11,418	22:38	10,958	44:46	↑ 22:08

2e:[{"id":"f1ee4a78b0403adaac527c4ee2730d6f7aac4b8abe8dabe3174ffec47f2dfe97ee13a8e6c2b0755f705d416ee2057c2130dc1906aaf660f57cd34632def967e3","href":"https://static.observableusercontent.com/files/f1ee4a78b0403adaac527c4ee2730d6f7aac4b8abe8dabe3174ffec47f2dfe97ee13a8e6c2b0755f705d416ee2057c2130dc1906aaf660f57cd34632def967e3","name":"ambulence_rt_dec_may@4.csv","type":"text/csv","lastModified":1728146423186.81,"size":72185},{"id":"85440d5670af29e20e80036480833d356ab4032ac87f7b7050cfb6a1457b469e8e8c9364e972b1ee69ec6afddf4f5185b31f6ff4b0676e9a3c7884229fe71185","href":"https://static.observableusercontent.com/files/85440d5670af29e20e80036480833d356ab4032ac87f7b7050cfb6a1457b469e8e8c9364e972b1ee69ec6afddf4f5185b31f6ff4b0676e9a3c7884229fe71185","name":"FOI 5203 - LAS Cat 1 and 2 Response Times.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1728146423186.81,"size":504560},{"id":"2f0c4b8f03cc893133453507851b62cb0e9cecc89200007db4ad9dd7a7db9c4d3e3ea9004ef67cce923e49181b26de8b7758742941a30e404d5c99641a4f7628","href":"https://static.observableusercontent.com/files/2f0c4b8f03cc893133453507851b62cb0e9cecc89200007db4ad9dd7a7db9c4d3e3ea9004ef67cce923e49181b26de8b7758742941a30e404d5c99641a4f7628","name":"FOI_6294_processed@1.csv","type":"text/csv","lastModified":1728154177123.748,"size":79721}] 25:{"id":"24731eacfacf7b82","slug":"ambulance-response-times-in-e2-areas-in-tower-haml","title":"Ambulance Response Times in E2 areas in Tower Hamlets","thumbnail":"b98ae99d388de7239c48bb5da0283dc68b8fd37368c2199244f1edb736c90dfe","access_level":"unlisted","create_time":"$D2024-10-05T16:40:23.186Z","update_time":"$D2024-10-12T08:21:06.331Z","view_time":null,"first_public_time":null,"has_unpublished_edits":null,"fork":{"id":"c423e5d178594bd5","slug":"ambulance-response-times-in-e2-areas-in-tower-hamlets","title":"Ambulance Response Times in E2 areas in Tower Hamlets","owner":{"id":"b2e8b22fd64f7967","login":"soss","name":"Save our Safer Streets"}},"stars":0,"starred":false,"owner":{"type":"team","id":"76caf694b487f571","login":"soss-bethnal-green","name":"SOSS Bethnal Green","avatar_url":"https://avatars-next.observableusercontent.com/58af5c81e5973b5a7720a84ace7f02e6fe880c4e86a82a6bb039ba73630dfc67","tier":"starter_2024"},"version":1521,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"13d2a4c5efe2133b","login":"soss-bethnal-green","name":"SOSS Bethnal Green","avatar_url":"https://avatars-next.observableusercontent.com/2ea3d9f7f40df2900fc77447d716ef6d8a737d75fb943fe701c69c40343fd7cd","tier":null}],"members":[{"type":"individual","id":"13d2a4c5efe2133b","login":"soss-bethnal-green","name":"SOSS Bethnal Green","avatar_url":"https://avatars-next.observableusercontent.com/2ea3d9f7f40df2900fc77447d716ef6d8a737d75fb943fe701c69c40343fd7cd","tier":null,"role":"editor"},{"type":"team","id":"76caf694b487f571","login":"soss-bethnal-green","name":"SOSS Bethnal Green","avatar_url":"https://avatars-next.observableusercontent.com/58af5c81e5973b5a7720a84ace7f02e6fe880c4e86a82a6bb039ba73630dfc67","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Ambulance Response Times in E2 areas in Tower Hamlets","cells":[{"id":0,"value":"$27","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1446,"value":"$28","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":190,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":730,"value":"Plot.plot({\n height: 20,\n //marginBottom: 6,\n marginTop: 1,\n marks: [\n Plot.text(\n [\"Map shows boundary of E2 postcode district in Tower Hamlets.\"],\n {\n frameAnchor: \"top\",\n fontSize: 10,\n //lineWidth: 20,\n //textAnchor: \"start\",\n lineHeight: 1.3,\n // monospace: true,\n //clip: true\n }\n )\n ],\n //x: { type: \"point\", align: 0, axis: \"top\", tickSize: 0 }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":474,"value":"## All ambulance responses in Tower Hamlets\nTo show how we reached the conclusions in our key results, let's start with the data we've worked with. \n\nIn the bar graph below, we can see monthly ambulance call-outs for five postcode areas in E2 between June 2019 to June 2022 (*E2 0*, and *E2 6*, *E2 7*, *E2 8* and *E2 9*) . These are postcode areas that correspond to the newly installed LTNs in E2.\n\nThe different colours indicate the different categories of response: *Category 1—Life-threatening* (green), *Category 2—Emergency* (orange).\n\n> *To see monthly ambulance responses for the different areas, choose from the drop down menu labelled \"*Choose area*\".*\n\n> *To compare the responses between the selected area and the larger *E2 postcode district* or *Tower Hamlets* overall, choose one of the \"*Compare with*\" options.*\n\n> *Incident count by category was not present in the FOI data made in 2024 so cannot be included in this chart.*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":337,"value":"viewof areaSelect1 = Inputs.select(new Map(areasMap), {value: \"E2 0\", label: \"Choose area\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":402,"value":"viewof areaCompare1 = Inputs.radio(new Map([\n [\"Tower Hamlets borough\", \"TH\"], \n [\"E2 postcode district\", \"E2\"], \n [\"None\", \"\"]\n]), {label: \"Comparison with:\", value: \"\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"\nPlot.plot({\n color: {\n type: \"categorical\",\n legend: true,\n scheme: \"pastel2\",\n legend: \"ramp\"\n },\n y: {\n label: \"↑ No. of responses in \" + areaSelect1,\n grid: true,\n //domain: [0,2700]\n },\n x: { \n type: \"time\",\n label: \"Month and Year →\",\n thresholds: \"d3.utcMonth\",\n tickFormat: d3.utcFormat(\"%b-%y\")\n },\n marks: [\n Plot.rectY(ambulanceRT, {x: \"utctimestamp\", y: \" incidents\", interval: d3.utcMonth, fill: \"Gray\", opacity: 0.2, filter: (d) => d.Area === areaCompare1}),\n Plot.rectY(ambulanceRT, {x: \"utctimestamp\", y: \" incidents\", interval: d3.utcMonth, fill: \"Category\", filter: (d) => d.Area === areaSelect1}),\n Plot.ruleY([0])\n ],\n marginLeft: 60,\n marginBottom: 45,\n inset: 10\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":394,"value":"## Average ambulance response times\nNow let's look at the response times.\n\nBelow you'll see a graph of average ambulance response times each month between June 2019 to June 2024. \n\nGreen lines are responses to Category 1 calls and orange to Category 2 calls.\n\n> *Use the drop down menu to view average response times for one of the five postcode areas, the postcode district (E2) or Tower Hamlets as a whole.*\n\n> *To compare the responses between an area and the larger *E2* postcode district or *Tower Hamlets*, choose one of the \"*Compare with*\" options.*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":202,"value":"viewof areaSelect2 = Inputs.select(new Map(areasMap), {value: 12, label: \"Choose area\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"viewof areaCompare2 = Inputs.radio(new Map([\n [\"Tower Hamlets borough\", \"TH\"], \n [\"E2 postcode district\", \"E2\"], \n [\"None\", \"\"]\n]), {label: \"Comparison with:\", value: \"\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"$29","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"You'll notice, Category 1 response times have remained relatively stable.\n\nThe response times for Category 2 calls begin to rise in all areas (including Tower Hamlets as a whole) from March 2020. As has been reported in the press, response times have continued to be higher than usual since this time.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":511,"value":"$2a","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":692,"value":"### A closer look at category 1 responses\nTaking a closer look at category 1 response times, these fell in all postcode areas as well as for the E2 postcode district and Tower Hamlets as a whole (see the right most column in Table 2).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":589,"value":"$2b","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":666,"value":"Plot.plot({\n height: 20,\n //marginBottom: 6,\n marginTop: 5,\n marks: [\n Plot.text(\n [\"Table 2. Category 1 responses and response times before and after the new road layouts.\"],\n {\n frameAnchor: \"top\",\n fontSize: 12,\n //lineWidth: 20,\n //textAnchor: \"start\",\n lineHeight: 1.3,\n // monospace: true,\n //clip: true\n }\n )\n ],\n //x: { type: \"point\", align: 0, axis: \"top\", tickSize: 0 }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1226,"value":"We calculated the aggregate before and after response times for the combined E2 postcode areas (i.e., E20, E2 6, E2 7, E2 8 and E2 9). For the combined E2 postcode areas, the aggregate response times fell by 38 seconds (see row 6 in table above). This is a second less that the decline for Tower Hamlets as a whole (37 sec).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1183,"value":"$2c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1102,"value":"These results suggest that for category 1 response times the changes in the E2 postcode areas have been comparable with changes in Tower Hamlets as a whole. From the available data, it appears the **LTNs have had negligible impact on category 1 response times** when compared to Tower Hamlets as a whole.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":696,"value":"### A closer look a category 2 responses\n\nFor category 2 responses, response times all went up, markedly. \n\nWe see in the table below that the smallest increase was 18 minutes 27 seconds (E2 7) and the largest was 24 minutes 51 seconds (E2 9). Across the borough (Tower Hamlets), the average increased from 22:38 to 44:46, up 22 minutes 8 seconds.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":600,"value":"$2d","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":701,"value":"Plot.plot({\n height: 20,\n //marginBottom: 6,\n marginTop: 5,\n marks: [\n Plot.text(\n [\"Table 3. Category 2 responses and response times before and after the new road layouts.\"],\n {\n frameAnchor: \"top\",\n fontSize: 13,\n //lineWidth: 20,\n //textAnchor: \"start\",\n lineHeight: 1.3,\n // monospace: true,\n //clip: true\n }\n )\n ],\n //x: { type: \"point\", align: 0, axis: \"top\", tickSize: 0 }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"We've already noted the increases in response times in all areas are likely due to the ambulance service's continued challenges. The increases though look to be comparable for all areas and for Tower Hamlets; all increase by around 20-25 minutes. When we compare the aggregate of the E2 LTN areas with the borough, we see the increase in response time for the E2 LTN areas (20:47) to be marginally lower than Tower Hamlets as a whole (22:08).\n\nFrom the available data, it appears the **increases in response times in the E2 LTN areas are comparable with the increases across Tower Hamlets as a whole**. In other words the **LTNs show no sign of further increasing category 2 response times**:\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1443,"value":"## More analysis\n- [Fire service response times](https://i.heartbg.uk/LFB-response-time-analysis)\n- [Air quality analysis](https://i.heartbg.uk/air-quality-analysis)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1142,"value":"## Footnote\n\n¹ The data we have for ambulance response times (obtained through our freedom of information request) is limited. Unlike our fire service response times where we know times for every journey, we only have mean response times per month for ambulances. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":228,"value":"operationalDate = new Date('2021-07-01') // Assumed date LTNs installed","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"meanCat1ResposeTime = d3.utcFormat(\"%M:%S\")(d3.mean(cat1AmbulanceRT, d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1349,"value":"meanCat1LTNBeforePeriod = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 1 && d.type === \"E2 LTN areas\" && d.period === \"Before-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1346,"value":"meanCat1LTNAfterPeriod = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 1 && d.type === \"E2 LTN areas\" && d.period === \"After-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1372,"value":"Cat1CountLTNBeforePeriod = d3.sum(ambulanceRT.filter(d => d.Category === 1 && d.type === \"E2 LTN areas\" && d.period === \"Before-6-month\"), d => d[\" incidents\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1383,"value":"Cat1CountLTNAfterPeriod = d3.sum(ambulanceRT.filter(d => d.Category === 1 && d.type === \"E2 LTN areas\" && d.period === \"After-6-month\"), d => d[\" incidents\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1413,"value":"meanCat2LTNBeforePeriod = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 2 && d.type === \"E2 LTN areas\" && d.period === \"Before-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1417,"value":"meanCat2LTNAfterPeriod = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 2 && d.type === \"E2 LTN areas\" && d.period === \"After-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1405,"value":"Cat2CountLTNBeforePeriod = d3.sum(ambulanceRT.filter(d => d.Category === 2 && d.type === \"E2 LTN areas\" && d.period === \"Before-6-month\"), d => d[\" incidents\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1409,"value":"Cat2CountLTNAfterPeriod = d3.sum(ambulanceRT.filter(d => d.Category === 2 && d.type === \"E2 LTN areas\" && d.period === \"After-6-month\"), d => d[\" incidents\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1379,"value":"Cat1CountE2PcDistrictBeforePeriod = d3.sum(ambulanceRT.filter(d => d.Category === 1 && d.type === \"E2 postcode district\" && d.period === \"Before-6-month\"), d => d[\" incidents\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1361,"value":"Cat1CountE2PcDistrictAfterPeriod = d3.sum(ambulanceRT.filter(d => d.Category === 1 && d.type === \"E2 postcode district\" && d.period === \"After-6-month\"), d => d[\" incidents\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"meanCat2ResposeTime = d3.utcFormat(\"%M:%S\")(d3.mean(cat2AmbulanceRT, d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1282,"value":"meanCat1THBefore = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 1 && d.Area === \"TH\" && d.period === \"Before-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1398,"value":"meanCat2THBefore1 = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 2 && d.Area === \"E2 6\" && d.period === \"Before-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1311,"value":"meanCat1THAfter = d3.utcFormat(\"%M:%S\")(d3.mean(ambulanceRT2024.filter(d => d.Category === 1 && d.Area === \"TH\" && d.period === \"After-6-month\"), d => d[\"mean ms\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"ambulanceRT = FileAttachment(\"ambulence_rt_dec_may@4.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1493,"value":"ambulanceRT2024 = FileAttachment(\"FOI_6294_processed@1.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"cat1AmbulanceRT = ambulanceRT2024.filter(d => d.Category === 1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"cat2AmbulanceRT = ambulanceRT2024.filter(d => d.Category === 2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"areasLongForm = [\n {name: \"Tower Hamlets borough\", area: \"TH\"},\n {name: \"E2 postcode district\", area: \"E2\"},\n {name: \"E2 0 postcode area\", area: \"E2 0\"},\n {name: \"E2 6 postcode area\", area: \"E2 6\"},\n {name: \"E2 7 postcode area\", area: \"E2 7\"},\n {name: \"E2 8 postcode area\", area: \"E2 8\"},\n {name: \"E2 9 postcode area\", area: \"E2 9\"},\n]","pinned":false,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"areasMap = [\n [\"E2 0 postcode area\", \"E2 0\"], \n [\"E2 6 postcode area\", \"E2 6\"],\n [\"E2 7 postcode area\", \"E2 7\"],\n [\"E2 8 postcode area\", \"E2 8\"],\n [\"E2 9 postcode area\", \"E2 9\"],\n [\"E2 postcode district\", \"E2\"], \n [\"Tower Hamlets borough\", \"TH\"], \n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1"}} 26:"$25:body"