34:["$","title",null,{"children":"Blavatnik Index of Public Administration 2024 - Metrics tables | Blavatnik Index of Public Administration | Observable"}] 3c:T4dd,metrics_table = function(structure_id) { const metrics_data = metrics_filter(structure_id) return Inputs.table(metrics_data, { select: false, columns: ["indicator", "metric_label", "data_source", "source_variable", "collection_type", "ref_year", "transformation", "n_countries"], header: { "indicator" : "Indicator", "metric_label": "Metric", "data_source": "Source", "source_variable": "Source variable", "collection_type": "Data type", "ref_year": "Ref year(s)", "transformation": "Data transformation", "n_countries": "Number of countries" }, format: { "indicator" : (d) => html`${d}`, "metric_label": (d) => html`${d}`, "data_source": (d) => html`${d}`, "source_variable": (d) => html`${d}`, "collection_type": (d) => html`${d}`, "ref_year": (d) => html`${d}`, "transformation": (d) => html`${d}`, "n_countries": (d) => html`${d}` } }) }3d:[{"id":"bbafac764e3437ebf592f189ba57e74edf00132cece414b8dc42c609a8acd801d20c5d8700a5e89b687269d133a983e15a6ab75f9cbaaccc471fcfc117948877","href":"https://static.observableusercontent.com/files/bbafac764e3437ebf592f189ba57e74edf00132cece414b8dc42c609a8acd801d20c5d8700a5e89b687269d133a983e15a6ab75f9cbaaccc471fcfc117948877","name":"source_summary.csv","type":"text/csv","lastModified":1733093345466.748,"size":2386},{"id":"669739f8706218baa37ddfb09383cca4ae77d1f061814f2be5b02e1a26faa880a010435acc7818a38213037ee45082acbc5ae40cc8bdd4dcbefc10ae60db29bd","href":"https://static.observableusercontent.com/files/669739f8706218baa37ddfb09383cca4ae77d1f061814f2be5b02e1a26faa880a010435acc7818a38213037ee45082acbc5ae40cc8bdd4dcbefc10ae60db29bd","name":"metrics_summary.csv","type":"text/csv","lastModified":1733093348726.461,"size":15135},{"id":"5dfc495d0f2fc9d42a02443214c8c8441a0cca1f61ac15dfe563200992fb04c6490d73a90792f72b9932c82e3159ad267aefea47f081bdeac1c1db0329f58ccc","href":"https://static.observableusercontent.com/files/5dfc495d0f2fc9d42a02443214c8c8441a0cca1f61ac15dfe563200992fb04c6490d73a90792f72b9932c82e3159ad267aefea47f081bdeac1c1db0329f58ccc","name":"source_summary@1.csv","type":"text/csv","lastModified":1733093567715.147,"size":2390},{"id":"e7958dd8fc6ebc1e60338c9f4dfa994b59007c3ab2c4c4f2803ad0f652196601488be8565772b61d7e8a6d6cad559c284c88345e3afd3f87a7433ba6ff159a7c","href":"https://static.observableusercontent.com/files/e7958dd8fc6ebc1e60338c9f4dfa994b59007c3ab2c4c4f2803ad0f652196601488be8565772b61d7e8a6d6cad559c284c88345e3afd3f87a7433ba6ff159a7c","name":"metrics_summary@1.csv","type":"text/csv","lastModified":1733094156581.264,"size":15127}] 38:{"id":"2177341885e29e54","slug":"blavatnik-index-2024-sources-metrics","title":"Blavatnik Index of Public Administration 2024 - Metrics tables","thumbnail":"2573c4d46a3ce6da0362b77c7d793effbabd80bdc6adecbc304032e611f8517b","access_level":"public","create_time":"$D2024-12-01T22:47:05.874Z","update_time":"$D2024-12-11T17:03:12.611Z","view_time":null,"first_public_time":"$D2024-12-11T17:37:10.787Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"64788a9292762d5c","login":"blavatnik-index","name":"Blavatnik Index of Public Administration","avatar_url":"https://avatars-next.observableusercontent.com/c3faf21eacfb754c1b8fa0d38430730fbffccd62e4469b8d9c9730ecf2644b10","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":88,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"3b25fb8111d386b0","login":"blavatnik-index-public-admin","name":"Blavatnik Index of Public Administration","avatar_url":"https://avatars-next.observableusercontent.com/4cf21a222e47302c445aec373f340fb0f601a87ac55bb489f375343bf9a1dcb1","tier":null,"bio":"","followed_by_you":false,"follows_you":false},{"type":"individual","id":"afeae8e7352fa689","login":"mattkerlogue","name":"Matt Kerlogue","avatar_url":"https://avatars-next.observableusercontent.com/f369be0d3aba4543a729bd6fba8ec14b7ff46b914a19660aade985a1988c1cea","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"64788a9292762d5c","login":"blavatnik-index","name":"Blavatnik Index of Public Administration","avatar_url":"https://avatars-next.observableusercontent.com/c3faf21eacfb754c1b8fa0d38430730fbffccd62e4469b8d9c9730ecf2644b10","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"c3398f772b8c0530","slug":"blavatnik-index-of-public-administration-2024","title":"Blavatnik Index of Public Administration 2024","owner":{"id":"64788a9292762d5c","login":"blavatnik-index","name":"Blavatnik Index of Public Administration"}},"type":"notebook","body":{"titling":"auto","title":"Blavatnik Index of Public Administration 2024 - Metrics tables","cells":[{"id":0,"value":"# Blavatnik Index of Public Administration 2024 - Metrics tables\n\nTables of data sources and metrics used in the Blavatnik Index of Public Administration, for use in web reporting @ https://index.bsg.ox.ac.uk.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":24,"value":"## Table of data sources","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"sources_table = Inputs.table(source_meta, {\n select: false,\n columns: [\"source_name\", \"publisher\", \"collection_type\", \"ref_year\", \"website\"],\n header: {\n \"source_name\": \"Source\",\n \"publisher\": \"Publisher\",\n \"collection_type\": \"Type of data collection\",\n \"ref_year\": \"Reference year(s)\",\n \"website\": \"Website\"\n },\n format: {\n source_name: (d) => html`${d}`,\n publisher: (d) => html`${d}`,\n collection_type: (d) => html`${d}`,\n ref_year: (d) => `${d}`,\n website: (d) => html`${d}`\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"## Metrics tables for each theme","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":31,"value":"str_cap_metrics = metrics_table(10100)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"str_opn_metrics = metrics_table(10300)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"str_int_metrics = metrics_table(10400)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"str_inv_metrics = metrics_table(10500)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"pub_pol_metrics = metrics_table(20100)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"pub_reg_metrics = metrics_table(20300)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"pub_crm_metrics = metrics_table(20400)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"pub_dat_metrics = metrics_table(20500)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"nat_sys_metrics = metrics_table(30100)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"nat_dig_metrics = metrics_table(30200)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"nat_tax_metrics = metrics_table(30300)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"nat_brd_metrics = metrics_table(30400)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"ppl_inc_metrics = metrics_table(40200)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"ppl_hrm_metrics = metrics_table(40300)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"ppl_prc_metrics = metrics_table(40400)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"ppl_tch_metrics = metrics_table(40500)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"## Data, libraries, funtions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"source_meta = FileAttachment(\"source_summary@1.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"metrics_meta = FileAttachment(\"metrics_summary@1.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"metrics_filter = function(structure_id) {\n return metrics_meta.filter(function(d) {\n return Math.floor(structure_id/100) == Math.floor(d.structure_id/100)\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3d","stdlib":"1"}} 33:null