2c:null 2d:["$","title",null,{"children":"Tax - Databases 2023 - DRAFT!!! | Stu Murray | Observable"}] 32:T63d,newBaseData = model() .const() .called("income tax 1") .value(newTaxRates[0]["income tax 1"]) .end() .const() .called("income tax 2") .value(newTaxRates[0]["income tax 2"]) .end() .const() .called("income tax 3") .value(newTaxRates[0]["income tax 3"]) .end() .const() .called("income tax 4") .value(newTaxRates[0]["income tax 4"]) .end() .const() .called("income tax 5") .value(newTaxRates[0]["income tax 5"]) .end() .const() .called("income amount 1") .value(newTaxRates[0]["income amount 1"]) .end() .const() .called("income amount 2") .value(newTaxRates[0]["income amount 2"]) .end() .const() .called("income amount 3") .value(newTaxRates[0]["income amount 3"]) .end() .const() .called("income amount 4") .value(newTaxRates[0]["income amount 4"]) .end() .const() .called("income amount 5") .value(newTaxRates[0]["income amount 5"]) .end() .const() .called("corporation tax 1") .value(newTaxRates[0]["corporation tax 1"]) .end() .const() .called("corporation tax 2") .value(newTaxRates[0]["corporation tax 2"]) .end() .const() .called("corporation amount 1") .value(newTaxRates[0]["corporation amount 1"]) .end() .const() .called("corporation amount 2") .value(newTaxRates[0]["corporation amount 2"]) .end() .const() .called("VAT rate") .value(newTaxRates[0]["VAT rate"]) .end() .const() .called("excise rate") .value(newTaxRates[0]["excise rate"]) .end() .const() .called("import tax") .value(newTaxRates[0]["import tax"]) .end() .data(newTaxBasesWithMisc)33:Tac9,taxModel = model() .calc() .called("Total government revenue per capita") .does( (r) => r["Government revenue per capita (constant 2015 USD)"] * r["Total Government Revenues (Inc. SC)"] ) .end() .calc() .called("income tax per capita") .does( (r) => (r["Government revenue per capita (constant 2015 USD)"] * r["PIT"]) / r["Total Government Revenues (Inc. SC)"] ) .end() .calc() .called("income tax base") .does( (r) => r["income tax per capita"] / (r["income tax 1"] * r["income amount 1"] + r["income tax 2"] * r["income amount 2"] + r["income tax 3"] * r["income amount 3"] + r["income tax 4"] * r["income amount 4"] + r["income tax 5"] * r["income amount 5"]) ) .end() .calc() .called("corporation tax revenue") .does( (r) => (r["Government revenue per capita (constant 2015 USD)"] * r["CIT"]) / r["Total Government Revenues (Inc. SC)"] ) .end() .calc() .called("corporation tax base") .does( (r) => r["corporation tax revenue"] / (r["corporation tax 1"] * r["corporation amount 1"] + r["corporation tax 2"] * r["corporation amount 2"]) ) .end() .calc() .called("VAT revenue") .does( (r) => (r["Government revenue per capita (constant 2015 USD)"] * r["VAT (including sales tax in previous regimes)"]) / r["Total Government Revenues (Inc. SC)"] ) .end() .calc() .called("VAT base") .does((r) => r["VAT revenue"] / r["VAT rate"]) .end() .calc() .called("excise revenue") .does( (r) => (r["Government revenue per capita (constant 2015 USD)"] * r["Excise Taxes"]) / r["Total Government Revenues (Inc. SC)"] ) .end() .calc() .called("excise base") .does((r) => r["excise revenue"] / r["excise rate"]) .end() .calc() .called("import revenue") .does( (r) => (r["Government revenue per capita (constant 2015 USD)"] * r["Import Taxes"]) / r["Total Government Revenues (Inc. SC)"] ) .end() .calc() .called("import base") .does((r) => r["import revenue"] / r["import tax"]) .end() .calc() .called("misc. other") .does( (r) => r["Government revenue per capita (constant 2015 USD)"] * r["Total Government Revenues (Inc. SC)"] - (r["income tax per capita"] + r["corporation tax revenue"] + r["VAT revenue"] + r["excise revenue"] + r["import revenue"]) ) .end() .calc() .called("total tax revenue") .does( (r) => r["income tax per capita"] + r["corporation tax revenue"] + r["VAT revenue"] + r["excise revenue"] + r["import revenue"] + r["misc. other"] ) .end()34:T480,newTaxModel = model() .calc() .called("income tax per capita") .does( (r) => r["income tax base"] * (r["income tax 1"] * r["income amount 1"] + r["income tax 2"] * r["income amount 2"] + r["income tax 3"] * r["income amount 3"] + r["income tax 4"] * r["income amount 4"] + r["income tax 5"] * r["income amount 5"]) ) .end() .calc() .called("corporation tax revenue") .does( (r) => r["corporation tax base"] * (r["corporation tax 1"] * r["corporation amount 1"] + r["corporation tax 2"] * r["corporation amount 2"]) ) .end() .calc() .called("VAT revenue") .does((r) => r["VAT base"] * r["VAT rate"]) .end() .calc() .called("excise revenue") .does((r) => r["excise base"] * r["excise rate"]) .end() .calc() .called("import revenue") .does((r) => r["import base"] * r["import tax"]) .end() .calc() .called("total tax revenue") .does( (r) => r["income tax per capita"] + r["corporation tax revenue"] + r["VAT revenue"] + r["excise revenue"] + r["import revenue"] + r["misc. other"] ) .end()35:[{"id":"bfed5f6578aa2f81c18c376331dd2c971fca08e49a187fae571876fbc238b4c3186d9c71da5b824c776697359f273df7878520dcb9351bf9a6184526d83d4d6c","href":"https://static.observableusercontent.com/files/bfed5f6578aa2f81c18c376331dd2c971fca08e49a187fae571876fbc238b4c3186d9c71da5b824c776697359f273df7878520dcb9351bf9a6184526d83d4d6c","name":"uganda_base - Sheet1@2.tsv","type":"text/tab-separated-values","lastModified":1675023574988.419,"size":5814},{"id":"be17891a21abecf4ef2d02435be6457e4d1e5c8ac6d10c58a64d4b36383a706cbb6fdf561ca0e3111146225a8994126899effb9ab3dccdd6a235951b371c8444","href":"https://static.observableusercontent.com/files/be17891a21abecf4ef2d02435be6457e4d1e5c8ac6d10c58a64d4b36383a706cbb6fdf561ca0e3111146225a8994126899effb9ab3dccdd6a235951b371c8444","name":"kenya_base - Sheet1@3.tsv","type":"text/tab-separated-values","lastModified":1675023575094.376,"size":5671},{"id":"005cfa3bb655a836588bc08dbfc438aa6adb2331f104aab8933bafa636a1ce5443e151ef2d01ee806438529556ada013340e80ea4d4426e141da4fb357554752","href":"https://static.observableusercontent.com/files/005cfa3bb655a836588bc08dbfc438aa6adb2331f104aab8933bafa636a1ce5443e151ef2d01ee806438529556ada013340e80ea4d4426e141da4fb357554752","name":"senegal_base - Sheet1.tsv","type":"text/tab-separated-values","lastModified":1675022285672.678,"size":6013},{"id":"19aa76f46c4b52c3b192c14ce29f93900311d01f1a9f05af9b961fae4a5640a2674bc47fed9f75a94953888c0c76e589e8d300670ca6b7ffb36290166719d8f2","href":"https://static.observableusercontent.com/files/19aa76f46c4b52c3b192c14ce29f93900311d01f1a9f05af9b961fae4a5640a2674bc47fed9f75a94953888c0c76e589e8d300670ca6b7ffb36290166719d8f2","name":"nepal_base - Sheet1.tsv","type":"text/tab-separated-values","lastModified":1675022296529.881,"size":6847},{"id":"3f8508406d027c311a62d9a41a9a67d11ed113c5e59f389f1d96590df61e717b02c5143bb05e3444393f3ee9ba0b079d5c5b6f77fe7714e22500c7ea481ac34d","href":"https://static.observableusercontent.com/files/3f8508406d027c311a62d9a41a9a67d11ed113c5e59f389f1d96590df61e717b02c5143bb05e3444393f3ee9ba0b079d5c5b6f77fe7714e22500c7ea481ac34d","name":"ghana_base - Sheet1.tsv","type":"text/tab-separated-values","lastModified":1675022296929.094,"size":6526},{"id":"ef60b35606fa64a82a2f4a7897db09d0e94b21a7035c7ecb42b225de977d2ae07eb46d46a473fa622d6efed7ac0b651b03c9755ecde9ebf169750ccff25a5ada","href":"https://static.observableusercontent.com/files/ef60b35606fa64a82a2f4a7897db09d0e94b21a7035c7ecb42b225de977d2ae07eb46d46a473fa622d6efed7ac0b651b03c9755ecde9ebf169750ccff25a5ada","name":"malawi_base - Sheet1.tsv","type":"text/tab-separated-values","lastModified":1675022297079.909,"size":6097},{"id":"ad1112114c6e218ec44fb3b71b9ba87f78e4a52206df19e3340dba7a26912987ec6f360c9447aacc1e6baf4dfa16fa259f4cafba3c36fc7de2c9d71f5ea9e10d","href":"https://static.observableusercontent.com/files/ad1112114c6e218ec44fb3b71b9ba87f78e4a52206df19e3340dba7a26912987ec6f360c9447aacc1e6baf4dfa16fa259f4cafba3c36fc7de2c9d71f5ea9e10d","name":"zambia_base - Sheet1.tsv","type":"text/tab-separated-values","lastModified":1675022297237.993,"size":5834}] 30:{"id":"a7a2bf9f20c17203","slug":null,"title":"Tax - Databases 2023 - DRAFT!!!","thumbnail":"5cba5e3859963a6b7772e5293b9e60ddf6d27ce75830daa576d4cf11f87415fb","access_level":"public","create_time":"$D2023-01-29T19:57:03.328Z","update_time":"$D2023-01-30T23:23:06.129Z","view_time":null,"first_public_time":"$D2023-01-29T19:57:03.328Z","has_unpublished_edits":null,"fork":{"id":"41c0f5037696737d","slug":null,"title":"Tax - DRAFT!!!","owner":{"id":"8781e33d79a4bb92","login":"stuwilmur","name":"Stu Murray"}},"stars":0,"starred":false,"owner":{"type":"team","id":"8781e33d79a4bb92","login":"stuwilmur","name":"Stu Murray","avatar_url":"https://avatars-next.observableusercontent.com/b75116f0f53690768dc0e7c2700a4eaf7befae7b942ecd55d7f24c4c871761a5","tier":"starter_2024"},"version":703,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b81ee3cd10201b1a","login":"stuwilmur","name":"Stu Murray","avatar_url":"https://avatars-next.observableusercontent.com/b75116f0f53690768dc0e7c2700a4eaf7befae7b942ecd55d7f24c4c871761a5","tier":null}],"members":[{"type":"individual","id":"b81ee3cd10201b1a","login":"stuwilmur","name":"Stu Murray","avatar_url":"https://avatars-next.observableusercontent.com/b75116f0f53690768dc0e7c2700a4eaf7befae7b942ecd55d7f24c4c871761a5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Tax - Databases 2023 - DRAFT!!!","cells":[{"id":63,"value":"# Tax - Databases 2023 - DRAFT!!!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":209,"value":"## ${country}: New & old tax revenues\nSelect a country using the dropdown.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":555,"value":"viewof country = Inputs.select(countriesMap.keys(), {\n value: \"Ghana\",\n label: \"Country\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":582,"value":"This plot shows a comparison of the *old* tax revenues using dots, and the *new* values using lines.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":459,"value":"plotTidyTaxEstimates(taxEstimateTidy, newTaxEstimateTidy)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"## New tax rates and bases\nEdit the values in the tax rates and tax bases tables below to calculate new tax revenues and update the plot above","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":355,"value":"taxRatesTable = createTable(taxRates)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"taxBasesTable = createTable(taxBases)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"
The table below shows the full results of calculating the new tax revenues","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":448,"value":"htl.html`

New tax revenues

\n${Inputs.table(newTaxEstimate)}\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":611,"value":"## Old tax revenues","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":176,"value":"plotTidyTaxEstimate(taxEstimateTidy)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"htl.html`

Old tax revenues

\n${Inputs.table(taxEstimate)}\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":625,"value":"taxRatesTable.prepend(htl.html`New tax rates`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"taxBasesTable.prepend(htl.html`New tax bases`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":560,"value":"countriesMap = new Map([\n [\n \"Ghana\",\n FileAttachment(\"ghana_base - Sheet1.tsv\").tsv({\n typed: true\n })\n ],\n [\n \"Kenya\",\n FileAttachment(\"kenya_base - Sheet1@3.tsv\").tsv({\n typed: true\n })\n ],\n [\n \"Malawi\",\n FileAttachment(\"malawi_base - Sheet1.tsv\").tsv({\n typed: true\n })\n ],\n [\n \"Nepal\",\n FileAttachment(\"nepal_base - Sheet1.tsv\").tsv({\n typed: true\n })\n ],\n [\n \"Senegal\",\n FileAttachment(\"senegal_base - Sheet1.tsv\").tsv({\n typed: true\n })\n ],\n [\n \"Uganda\",\n FileAttachment(\"uganda_base - Sheet1@2.tsv\").tsv({\n typed: true\n })\n ],\n [\n \"Zambia\",\n FileAttachment(\"zambia_base - Sheet1.tsv\").tsv({\n typed: true\n })\n ]\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"baseData = countriesMap.get(country)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"taxBases = model()\n .select(\n \"Year\",\n \"income tax base\",\n \"corporation tax base\",\n \"VAT base\",\n \"excise base\",\n \"import base\"\n )\n .data(taxEstimate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"taxRates = model()\n .select(\n \"income tax 1\",\n \"income tax 2\",\n \"income tax 3\",\n \"income tax 4\",\n \"income tax 5\",\n \"income amount 1\",\n \"income amount 2\",\n \"income amount 3\",\n \"income amount 4\",\n \"income amount 5\",\n \"corporation tax 1\",\n \"corporation tax 2\",\n \"corporation amount 1\",\n \"corporation amount 2\",\n \"VAT rate\",\n \"import tax\",\n \"excise rate\"\n )\n .data(baseData.slice(0, 1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"taxEstimate = taxModel.data(baseData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"taxEstimateTidy = tidy(taxEstimate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"newTaxRates = observeTable(taxRatesTable)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"newTaxBases = observeTable(taxBasesTable)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"newTaxBasesWithMisc = model()\n .merge(model().select(\"misc. other\").data(taxEstimate))\n .data(newTaxBases)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"newTaxEstimate = newTaxModel.data(newBaseData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":451,"value":"newTaxEstimateTidy = tidy(newTaxEstimate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"function plotTidyTaxEstimate(tidyTaxEstimate) {\n return Plot.plot({\n color: {\n legend: true\n },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(tidyTaxEstimate, {\n x: \"Year\",\n y: \"revenue\",\n z: \"series\",\n stroke: \"series\",\n title: (d) => `${d.Year.getFullYear()} \\n ${d.series} : ${d.revenue}`\n })\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"function plotTidyTaxEstimates(tidyTaxEstimate1, tidyTaxEstimate2) {\n return Plot.plot({\n color: {\n legend: true\n },\n marks: [\n Plot.ruleY([0]),\n Plot.dotY(tidyTaxEstimate1, {\n x: \"Year\",\n y: \"revenue\",\n z: \"series\",\n stroke: \"series\",\n title: (d) =>\n `${d.Year.getFullYear()} (Old) \\n ${d.series} : ${d.revenue}`\n }),\n Plot.lineY(tidyTaxEstimate2, {\n x: \"Year\",\n y: \"revenue\",\n z: \"series\",\n stroke: \"series\",\n title: (d) =>\n `${d.Year.getFullYear()} (New) \\n ${d.series} : ${d.revenue}`\n })\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"function year2date(year) {\n return new Date(year, 0, 1);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"function tidy(taxEstimate) {\n return taxEstimate.flatMap((r) => [\n {\n series: \"income tax per capita\",\n revenue: r[\"income tax per capita\"],\n Year: year2date(r.Year)\n },\n {\n series: \"corporation tax revenue\",\n revenue: r[\"corporation tax revenue\"],\n Year: year2date(r.Year)\n },\n {\n series: \"VAT revenue\",\n revenue: r[\"VAT revenue\"],\n Year: year2date(r.Year)\n },\n {\n series: \"excise revenue\",\n revenue: r[\"excise revenue\"],\n Year: year2date(r.Year)\n },\n {\n series: \"import revenue\",\n revenue: r[\"import revenue\"],\n Year: year2date(r.Year)\n }\n ]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"import { Plot } from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"import { model } from \"@stuwilmur/mt\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"import { createTable, observeTable } from \"@stuwilmur/editable-table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"import { style } from \"@elisk/styles\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"style`\n .editable-table {\n overflow-y:scroll;\n max-height:300px;\n min-height:100px;\n min-width: 100%;\n display:block;\n }\n caption, figcaption {\n caption-side:top;\n position:sticky;\n text-align:left;\n bottom:0;\n background:white;\n border-top:solid 1px #ccc;\n color:#000;\n }\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 31:"$30:body"