3f:null 40:["$","title",null,{"children":"Oil and Gas usage by industry | Christian Klettner | Observable"}] 46:[{"id":"577470cf423339f2301efb9f8b8c963b6fd683ed401de5a89e119b9aab0b45dad9f9ad9bdd9324e08f92d0f40237bdc1d06b91050c3cf4c47457f3ce37bb9a10","href":"https://static.observableusercontent.com/files/577470cf423339f2301efb9f8b8c963b6fd683ed401de5a89e119b9aab0b45dad9f9ad9bdd9324e08f92d0f40237bdc1d06b91050c3cf4c47457f3ce37bb9a10","name":"Oil&Gas.csv","type":"text/csv","lastModified":1789599042798,"size":4177}] 44:{"id":"3a7804a4e1422052","slug":"oil-and-gas-usage-by-industry","title":"Oil and Gas usage by industry","thumbnail":"fefe6f3f9ae9fa9196bd700b1fce165dc29f635a3632689ad15a9839cc7744e4","access_level":"public","create_time":"$D2026-09-16T22:38:35.562Z","update_time":"$D2026-09-16T23:11:16.751Z","view_time":null,"first_public_time":"$D2026-09-16T23:01:12.522Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1e6bbbc1fea19b9b","login":"klettsch","name":"Christian Klettner","avatar_url":"https://avatars-next.observableusercontent.com/a2034439cf44a563da383de835ee021f6b6b0fe384e6da3aac36176d6f7b8a0a","tier":"starter_2024","bio":"Risk, finance, economic modelling, forecasting and stress testing","following":false},"version":51,"publish_version":51,"role":null,"authored":false,"authors":[{"type":"individual","id":"9c99afc3bb345c32","login":"klettsch","name":"Christian Klettner","avatar_url":"https://avatars-next.observableusercontent.com/0d0f4aae093b36282a186ea737feb66dc7f5bb69d65e30cc5a159c34f0a77f47","tier":null,"bio":"Risk, finance, economic modelling, forecasting and stress testing","following":false}],"members":[{"type":"team","id":"1e6bbbc1fea19b9b","login":"klettsch","name":"Christian Klettner","avatar_url":"https://avatars-next.observableusercontent.com/a2034439cf44a563da383de835ee021f6b6b0fe384e6da3aac36176d6f7b8a0a","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Oil and Gas usage by industry","cells":[{"id":1,"value":"# Oil and Gas usage by industry\n\nAustralian Oil and gas purchases by industry as a percentage of total inputs, for 2023-24.\n\nThis is an imperfect measure as it combines oil and gas in parts coal (note that manufacturing products from coal is relatively rare these days):\n\n - oil and gas extraction is crude oil and gas as extracted in Australia\n - petroleum and coal product manufacturing, which includes refined oils and petroleums as used industry\n\nABS National Accounts Supply and Use Tables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"const data = await FileAttachment(\"Oil&Gas.csv\").csv({ typed: true }).\n then(data=> data.map(d => ({ ...d,\n Intensity: (d[\"Oil and gas extraction\"] + d[\"Petroleum and coal product manufacturing\"])/\n (d[\"Intermediate inputs\"] + d[\"Primary inputs\"])\n })))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"Inputs.table(data,\n { columns: [\"Industry Code\", \"Industry\", \"Intensity\", \"Oil and gas extraction\", \"Petroleum and coal product manufacturing\"],\n header: {\"Industry Code\": \"\",\n Intensity: html`Oil & Gas
(% Inputs)`,\n \"Oil and gas extraction\": html`Oil and gas
extraction
($m)`,\n \"Petroleum and coal product manufacturing\": html`Petroleum and coal
product
manufacturing
($m)`},\n width: { \"Industry Code\": 30, Industry: 400 },\n sort: data.sort((a,b) => b.Intensity - a.Intensity),\n format: {\n \"Industry Code\": d => d3.format(\"03i\")(d),\n Intensity: d => d3.format(\"0.2%\")(d) },\n rows: 70\n })","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W46","stdlib":"2"}} 45:"$44:body"