2c:null 2d:["$","title",null,{"children":"Convocatorias públicas del gobierno boliviano | Mauricio Foronda | Observable"}] 32:T4d8,Plot.plot({ caption: md`*Convocatorias publicadas por mes*`, height: 180, width: width, style: { background: palette['background'], color: palette['lines'] }, marginLeft: 50, y: { grid: true, label: null, labelOffset: 0, tickSize: 0, zero: true, tickFormat: x => d3.format('.0f')(x) }, x: { grid: true, tickSize: 0, label: "", ticks: years, tickFormat: d3.utcFormat("%y") }, marks: [ Plot.rectY( indice, { x: 'mes', y: 'convocatorias', interval: d3.utcMonth, fill: d => d.mes_str == selected_period ? palette['blue'] : palette['lightblue'], stroke: palette['blue'], strokeWidth: .1, title: d => d['convocatorias'] + ' convocatorias\nen ' + d['mes_str'], insetLeft: .5 } ), Plot.line( indice, { x: 'mes', y: 'convocatorias', stroke: palette['blue'], curve: "step-after", strokeWidth: 1, } ), Plot.ruleY( [0], { stroke: palette['blue'], strokeWidth: .1 } ) ] })33:T7ad,viewof scatterplot = { const get_entidad = publicaciones_por_entidades.getter('entidad') const get_fecha = publicaciones_por_entidades.getter('fecha_publicacion') return Plot.plot({ width: width, height: (width / 32) * entidades_top.length, style: { background: '#f9f9f9', color: palette['lines'] }, color: { legend: false, type: 'ordinal', scheme: 'set3', }, x: { axis: "top", grid: true, ticks: d3.utcTicks(...d3.extent(publicaciones_por_entidades, d => d['fecha_publicacion']), 10).map((d) => new Date(d)), insetRight: true, padding: 0, tickSize: 0, label: "", tickFormat: x => x.toLocaleDateString("es-US", {day: "numeric", timeZone: 'UTC'}), domain: d3.utcDays(mes, new Date(mes.getUTCFullYear(), mes.getUTCMonth() + 1, 1)) }, y: { grid: true, label: null, ticks: null, tickFormat: d => null, labelOffset: 0, tickSize: 0, }, r: { type: width > 700 ? 'sqrt' : 'pow', }, marks: [ Plot.dot(publicaciones_por_entidades, { x: 'fecha_publicacion', y: 'entidad', fill: 'tipo_entidad', fillOpacity: .8, r: d => width < 700 ? Math.sqrt(d.count) : d.count, stroke: palette['lines'], strokeWidth: .8, sort: { y: 'r', reduce: 'sum', reverse: true }, insetRight: 3, insetTop: 1 }), Plot.tooltip(publicaciones_por_entidades, { x: 'fecha_publicacion', y: "entidad", content: d => `${d.count} publicaciones\npor ${d.entidad}`, stroke: "#fff" , fill: "#fff", r: 2, onclick: (event, i, g) => { const owner = ownerFigure(g); owner.value = {'fecha' : get_fecha(i), 'entidad': get_entidad(i)}; owner.dispatchEvent(new CustomEvent("input")); } }) ] }) }34:T7af,plot_categories = (column, marginleft=10, figheight=300, width_div = 2, max_records=50, fill_color=palette['lightblue'], stroke_color=palette['blue']) => { let freq = ( data. groupby(column). count(). orderby(aq.desc('count')). slice(0,max_records) ) const freqmax = aq.agg(freq, op.max('count')) freq = freq. derive({ top: aq.escape(d => (d.count / freqmax >= .5) ? true : false), }) return Plot.plot({ marginLeft: marginleft, height: figheight, width: width > 500 ? width / width_div : width, style: { background: "#f8f9f9", color: palette['lines'] }, y: { labelAnchor: "top", labelOffset: 0, tickSize: 0, tickFormat: d => '' }, x: { grid: true, tickSize: 0, label: "", ticks: 3 }, marks: [ Plot.barX( freq, { x: 'count', y: column, title: column, fill: fill_color, stroke: stroke_color, strokeWidth: .5, insetBottom: 0, insetTop: 0, insetLeft: 1, sort: { y: "x", reverse: true }, } ), Plot.ruleX( [0], { stroke: stroke_color, strokeWidth: .5 } ), Plot.text( freq, { x: 'count', y: column, text: column, filter: d => d.top, textAnchor: 'end', dx: -10, stroke: fill_color, strokeWidth: .2, fill: palette['lines'] } ), Plot.text( freq, { x: 'count', y: column, text: column, filter: d => ! d.top, textAnchor: 'start', dx: 10, stroke: palette['background'], strokeWidth: .5, fill: palette['lines'] // stroke: palette['background'] } ) ] }) }35:T5f3,plot_time = (datos, figheight=180, fill_color=palette['blue2'], stroke_color=palette['blue']) => { if (datos.length > 0) { { const timeline = (aq.from(datos). groupby('fecha_publicacion'). count()) return Plot.plot({ caption: md`*Convocatorias publicadas por día*`, height: figheight, width: width, marginLeft: 50, style: { background: palette['background'], color: palette['lines'] }, y: { grid: true, label: null, labelOffset: 0, tickSize: 0, zero: true, tickFormat: x => d3.format('.0f')(x) }, x: { ticks: d3.utcTicks(...d3.extent(timeline, d => d['fecha_publicacion']), 10).map((d) => new Date(d)), insetRight: true, padding: 0, tickSize: 0, label: "", tickFormat: x => x.toLocaleDateString("es-US", {day: "numeric", timeZone: 'UTC'}), domain: d3.utcDays(mes, new Date(mes.getUTCFullYear(), mes.getUTCMonth() + 1, 1)) }, marks: [ Plot.rectY( timeline, { x: 'fecha_publicacion', y: 'count', interval: d3.utcDay, fill: fill_color, stroke: stroke_color, strokeWidth: 1, insetRight: -.1, title: d => d['count'] + ' convocatorias\nel ' + d3.utcFormat('%-d de %B')(d['fecha_publicacion']), } ), Plot.ruleY( [0], { stroke: stroke_color, strokeWidth: .3 } ) ] }) }} else { return md`` } }36:T6f7,html` `37:[{"id":"f0ff3add62be334de55d7c3e72a8bda0ee58f780d41d7900858d8d53988cebe8d7f0165270b9e3a1a7ba0a7792a3282018d337a7d3a3bc7dd8ee727da4ae9b59","href":"https://static.observableusercontent.com/files/f0ff3add62be334de55d7c3e72a8bda0ee58f780d41d7900858d8d53988cebe8d7f0165270b9e3a1a7ba0a7792a3282018d337a7d3a3bc7dd8ee727da4ae9b59","name":"entidades.csv","type":"text/csv","lastModified":1661035790096.781,"size":38449}] 30:{"id":"456887cb32b21fdb","slug":"convocatorias-publicas-del-gobierno-boliviano","title":"Convocatorias públicas del gobierno boliviano","thumbnail":"c2b0c0f6ec3330a1d9d4d4b40dbd6a461a69ff58731e30d9a76a423f047d2e9f","access_level":"public","create_time":"$D2022-07-27T15:01:36.909Z","update_time":"$D2024-07-12T22:31:08.181Z","view_time":null,"first_public_time":"$D2022-07-27T22:20:30.566Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"475974948549302f","login":"mauforonda","name":"Mauricio Foronda","avatar_url":"https://avatars-next.observableusercontent.com/4cc3af3b792916571df54649e193dbdbf80a875b4e37b1def6ecb0480c561075","tier":"starter_2024"},"version":2712,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"018969b4abf63b07","login":"mauforonda","name":"Mau Foronda","avatar_url":"https://avatars-next.observableusercontent.com/513f52feadea4c57a52e2ab0f2fbdad66bf45a132acf7f9fbb19eb61e86e345f","tier":null}],"members":[{"type":"individual","id":"018969b4abf63b07","login":"mauforonda","name":"Mau Foronda","avatar_url":"https://avatars-next.observableusercontent.com/513f52feadea4c57a52e2ab0f2fbdad66bf45a132acf7f9fbb19eb61e86e345f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":{"id":"d9392cefad8a061b","slug":"datos-abiertos-del-gobierno-boliviano","title":"Datos abiertos en Bolivia","owner":{"id":"475974948549302f","login":"mauforonda","name":"Mauricio Foronda"}},"type":"notebook","body":{"title":"Convocatorias públicas del gobierno boliviano","cells":[{"id":1308,"value":"

Convocatorias públicas del gobierno boliviano

Convocatorias Públicas
del gobierno boliviano

Información de convocatorias de contratación publicadas por el gobierno boliviano en el Sistema de Contrataciones Estatales

\n Acá encuentras\n

datos desde diciembre de 2011 hasta 2021 descargados por Gabriel Weise
datos desde enero de 2022 descargados por Mauricio Foronda

\n Toda esta información ha sido armonizada, puede ser descargada desde github y se actualiza cada noche.\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":502,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"viewof selected_period = Inputs.select(indice_menu, {value: indice_menu[0], label: md`**Ver datos de**`})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"md`**${data.numRows()} convocatorias** fueron publicadas durante **${selected_period}**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"plot_time(busqueda)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"viewof busqueda_entidades = Inputs.search(entidades_lista, {placeholder: '🔍 Filtra entidades'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"viewof entidades_seleccionadas = Inputs.table(busqueda_entidades, {\n multiple: true,\n header: {'entidad': 'Entidad', 'count': 'Publicaciones'},\n value: busqueda_entidades,\n width: {Entidad: 500, count: 100},\n format: {count: d => htl.html`${d}`}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"viewof busqueda = Inputs.search(data_filtered.orderby(aq.desc('fecha_publicacion')), {placeholder: '🔍 Busca convocatorias'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"viewof convocatoria = Inputs.table(busqueda, {\n multiple: false,\n columns: ['entidad', 'objeto_de_contratacion','Día', 'departamento'],\n header: {'entidad': 'Entidad', 'objeto_de_contratacion': 'Objeto de Contratación','Día': 'Día', 'departamento':'Departamento'},\n format: {\n 'entidad': d => html`${d}`,\n 'objeto_de_contratacion': d => html`${d}`,\n Día: d => html`${d}`,\n departamento: d => html`${d}`\n },\n rows: 21.5,\n width: {'entidad': 200, 'objeto_de_contratacion': 400, 'Día': 20, 'departamento': 50},\n value: busqueda[0]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"convocatoria_view = {\n if (convocatoria != undefined) {\n return display_convocatoria(convocatoria)\n} else {\n return md``\n}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2073,"value":"

Convocatorias durante
${selected_period}

Número de publicaciones por entidad y día según el tipo de objeto de contratación

\n Entre las ${n_entidades} entidades con más publicaciones\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1879,"value":"viewof tipo_seleccionado = Inputs.select(tipos, {value: 'Todas las contrataciones'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2234,"value":"viewof convocatoria_scatview = {\n if (scatterplot != '') {\n return Inputs.table(scatview, {\n columns: ['objeto_de_contratacion'], \n header: {objeto_de_contratacion: 'Objeto de Contratación'},\n multiple: false,\n height: 185\n })\n} else {\n return htl.html`\n

\n ((( \n selecciona una burbuja\n ))) \n

`\n}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2311,"value":"convocatoria_scatdetail = {\n if (convocatoria_scatview != undefined) {\n return display_convocatoria(convocatoria_scatview)\n} else {\n return md``\n}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2176,"value":"htl.html`

${Swatches(d3.scaleOrdinal(entidades_tipos, d3.schemeSet3))}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1586,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":483,"value":"# Anexos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":70,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"locale = fetch(\n \"https://unpkg.com/d3-time-format@2/locale/es-MX.json\"\n).then(res => res.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"d3 = require(\"d3@6\").then(_d3 => (_d3.timeFormatDefaultLocale(locale), _d3))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"wrap = (...elems) => {\n const div = document.createElement(\"div\");\n div.style.display = 'flex'\n div.style.flexWrap = 'wrap'\n elems.forEach(el => div.appendChild(el));\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"entidades_lista = data.groupby('entidad').count().orderby(aq.desc('count'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"data_filtered = data_derived.\n filter(aq.escape(d => entidades_seleccionadas.map(d => d.entidad).includes(d.entidad)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"indice_csv = aq.loadCSV('https://raw.githubusercontent.com/sociedatos/bo-convocatorias_publicas/master/indice.csv')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"indice = indice_csv.\n derive({'mes_str': aq.escape(d => d3.utcFormat('%B de %Y')(d.mes))})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":647,"value":"indice_menu = indice.orderby(aq.desc('mes')).array('mes_str')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1809,"value":"mes = indice.filter(aq.escape(d => d.mes_str == selected_period)).object()['mes']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"filename = d3.utcFormat('%Y%m.csv')(mes)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":567,"value":"data = aq.loadCSV('https://raw.githubusercontent.com/sociedatos/bo-convocatorias_publicas/master/data/' + filename)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":968,"value":"data_derived = data.derive({\n Día: d => op.utcdate(d['fecha_publicacion']),\n tipo_entidad: aq.escape(d => codigo2categoria[parseInt(d.cuce.split('-')[1])])}).\n impute({ tipo_entidad: () => 'otro' })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1106,"value":"years = indice.derive({y: d => op.year(d.mes)}).groupby(\"y\").count().numRows()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1156,"value":"palette = ({background: \"#f8f9f9\", lines: '#717275', blue: \"#357ff2\", blue2: \"#bad3fc\", lightblue: \"#e9f8fc\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1477,"value":"display_convocatoria = (c) => {\n const header = htl.html`\n

${c['objeto_de_contratacion']}

publicado por ${c['entidad']}

el ${d3.utcFormat('%d de %B de %Y')(c['fecha_publicacion'])}

`\n const table = Inputs.table(\n aq.from(c).rename({key:'Propiedad', value:'Valor'}), {\n width: {Propiedad: 150}, \n rows: 25,\n format: {\n Propiedad: d => html`${d}`\n }\n }\n )\n return htl.html`

${wrap(header, table)}

`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":985,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1845,"value":"Plot = require(\"@observablehq/plot\").then(addTooltip)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1831,"value":"import {addTooltip, ownerFigure} from \"@fil/experimental-plot-tooltip-01\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1614,"value":"n_entidades = 100","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1618,"value":"entidades_top = entidades.slice(0,n_entidades).array('entidad')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1898,"value":"data_scatter = data_derived.\n filter(aq.escape(d => tipo_seleccionado == 'Todas las contrataciones' ? d : d.tipo_de_contratacion == tipo_seleccionado))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1603,"value":"entidades = data_scatter.\n groupby('entidad').\n count().\n orderby(aq.desc('count'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1582,"value":"publicaciones_por_entidades = data_scatter.filter(aq.escape(d => entidades_top.includes(d.entidad))).groupby(['fecha_publicacion', 'tipo_entidad', 'entidad']).count()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1876,"value":"tipos = ['Todas las contrataciones'].concat(aq.agg(data, op.array_agg_distinct('tipo_de_contratacion')))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1233,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2173,"value":"import {Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2236,"value":"scatview = data_derived.\n filter(aq.escape(d => (d.entidad == scatterplot['entidad']) & (d.Día == op.utcdate(scatterplot['fecha'])))).\n filter(aq.escape(d => tipo_seleccionado == 'Todas las contrataciones' ? d : d.tipo_de_contratacion == tipo_seleccionado))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2405,"value":"entidades_codigos_csv = aq.fromCSV(await FileAttachment('entidades.csv').text())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2410,"value":"codigo2categoria = Object.assign({}, ...entidades_codigos_csv.objects().map((x) => ({[x.entrada]: x.categoria})))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2188,"value":"entidades_tipos = aq.agg(publicaciones_por_entidades, op.array_agg_distinct('tipo_entidad')).sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 31:"$30:body"