25:["$","title",null,{"children":"Convocatorias del gobierno boliviano | Mauricio Foronda | Observable"}] 49:T5b9,viewof seleccion_mes = { const gridOptions = { strokeWidth: .8, strokeDasharray: 1 } const scaleOptions = {tickSize: 0, label: null} return Plot.plot({ marginLeft: 50, marginBottom: 25, height: 150, width: width, x: { ...scaleOptions, ticks: 10, axis: 'top', }, y: { ...scaleOptions, tickFormat: (d) => d == 0 ? '' : d }, style: {color: colors.frame, background: colors.background}, marks: [ Plot.gridY({ ...gridOptions, strokeOpacity: .5 }), Plot.gridX({ ...gridOptions, strokeOpacity: .2 }), Plot.rectY(indice, { x: 'mes', y: 'convocatorias', interval: d3.utcMonth, fill: colors.inactive }), Plot.rectY(indice, Plot.pointer({ x: 'mes', y: 'convocatorias', interval: d3.utcMonth, fill: colors.title })), Plot.text(['convocatorias por mes'], { frameAnchor: 'bottom-left', lineAnchor: 'top', dy: 15 }), // Plot.text(indice, Plot.pointer({ // px: 'mes', // py: 'convocatorias', // text: (d) => monthFormatter.format(d.mes), // frameAnchor: 'bottom-right', // lineAnchor: 'top', // dy: 13, // fill: colors.title, // fontWeight: 'bold', // fontFamily: 'Archivo', // fontSize: 13, // })) ] }) }4a:Tc03,async function plot_entidades(data) { // const subset = subset const entidades = await getEntidades(data) // const entidades_subset = aq.agg(aq.from(subset), op.array_agg_distinct('entidad')) // const entidades_subset = data.filter(aq.escape(d => aq.agg(aq.from(subset), op.array_agg_distinct('entidad')).includes(d.entidad))) // const entidades_filtro = await getEntidades(entidades_subset) const scaleOptions = {tickSize: 0, label: null} const gridOptions = { strokeWidth: .8, strokeDasharray: 1 } return Plot.plot({ marginRight: 180, marginLeft: 50, marginTop: 0, marginBottom: 25, height: 180, width: width, x: {...scaleOptions, axis: 'bottom', ticks: 5, tickFormat: (d) => d == 0 ? '' : d}, tickPadding: 10, y: {...scaleOptions, axis: 'right'}, style: {color: colors.frame, background: colors.background}, marks: [ Plot.gridX({ ...gridOptions, strokeOpacity: .2, }), Plot.gridY({ ...gridOptions, strokeOpacity: .5 }), Plot.barX(entidades, { y: 'categoria', x: 'convocatorias', fill: colors.inactive, fillOpacity: .5, stroke: null, inset: .5, sort: { y: 'x', reverse: true } }), // Plot.barX(entidades_filtro, { // y: 'categoria', // x: 'convocatorias', // fill: colors.title, // fillOpacity: .9, // stroke: null, // inset: .5, // sort: { // y: 'x', // reverse: true // } // }), // Plot.text(entidades, Plot.groupY( // { // x: 'sum', // text: "first" // }, // { // x: 'convocatorias', // y: 'categoria', // text: 'categoria', // textAnchor: 'start', // lineAnchor: 'top', // dx: 5, // fill: colors.frame // })), Plot.barX(entidades, Plot.pointer({ y: 'categoria', x: 'convocatorias', fill: colors.title, stroke: null, inset: .5, sort: { y: 'x', reverse: true } })), // Plot.text([`en ${monthFormatter.format(seleccion_mes.mes)}`], { // frameAnchor: 'top', // lineAnchor: 'top', // fill: colors.title, // fontWeight: 'bold', // fontSize: 14, // fontFamily: 'Archivo', // dy: -50, // dx: 80 // }), Plot.text(['convocatorias por entidad'], { frameAnchor: 'bottom-left', lineAnchor: 'bottom', dy: 16 }) // Plot.text(entidades, Plot.stackX(Plot.pointer({ // x: 'convocatorias', // y: 'categoria', // text: 'entidad', // frameAnchor: 'bottom-right', // // lineAnchor: 'top', // // dy: 15, // // dx: 180, // fill: colors.title, // fontWeight: 'bold', // fontFamily: 'Archivo', // fontSize: 13, // }))) ] }) }4b:T7a3,plot_entidad = (seleccion_entidad) => { const gridOptions = { strokeWidth: .8, strokeDasharray: 1 } const entidad = data. filter(aq.escape(d => d.entidad == seleccion_entidad.entidad)). orderby(aq.desc('fecha_publicacion')) const scaleOptions = {tickSize: 0, label: null} return Plot.plot({ width: width, height: 180, marginTop: 5, marginLeft: 50, marginBottom: 50, x: { ...scaleOptions, tickFormat: d3.utcFormat('%-d'), domain: [seleccion_mes.mes, end_month] }, y: { ...scaleOptions, ticks: 3, tickFormat: (d) => d == 0 ? '' : d }, style: {color: colors.frame, background: colors.background}, marks: [ Plot.gridY({...gridOptions, ticks: 3, strokeOpacity: .5}), Plot.rectY(entidad, Plot.binX( {y: 'count'}, { x: 'fecha_publicacion', fill: d => colors[d['tipo_de_contratacion']], thresholds: 'day', opacity: .5, inset: 1 })), Plot.rectY(entidad, Plot.binX( {y: 'count'}, Plot.pointer({ x: 'fecha_publicacion', fill: d => colors[d['tipo_de_contratacion']], thresholds: 'day', inset: 1 }) )), // Plot.text(['publicadas por'], { // frameAnchor: 'top', // lineAnchor: 'bottom', // fill: colors.title, // fontWeight: 'normal', // fontSize: 10, // fontFamily: 'Archivo', // dy: -41 // }), // Plot.text([seleccion_entidad.entidad], { // frameAnchor: 'top', // lineAnchor: 'top', // fill: colors.title, // fontWeight: 'bold', // fontSize: 14, // fontFamily: 'Archivo', // dy: -28 // }), Plot.text(['convocatorias por día y tipo'], { frameAnchor: 'bottom-left', lineAnchor: 'top', dy: 40 }) ] }) }4c:[{"id":"01e7e2b52d6aa22fda2130a281c5fb7f035a48018572b567933f3ac6ddcc054197273139d0c9f3c86215ec032f71b53b3bd421a530681b90a1d8a6e03472b655","href":"https://static.observableusercontent.com/files/01e7e2b52d6aa22fda2130a281c5fb7f035a48018572b567933f3ac6ddcc054197273139d0c9f3c86215ec032f71b53b3bd421a530681b90a1d8a6e03472b655","name":"entidades (1).csv","type":"text/csv","lastModified":1687792532223.094,"size":38449}] 29:{"id":"cd8404af3f04a90d","slug":null,"title":"Convocatorias del gobierno boliviano","thumbnail":"312065e38ea0e529e5ea295bbbe4bee38d6641750258fe7604b17d9420beacf0","access_level":"public","create_time":"$D2023-06-25T14:12:38.794Z","update_time":"$D2023-07-07T05:02:50.376Z","view_time":null,"first_public_time":"$D2023-06-25T14:12:38.794Z","has_unpublished_edits":null,"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","bio":"","followed_by_you":false,"follows_you":false},"version":1148,"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,"bio":"","followed_by_you":false,"follows_you":false}],"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":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Convocatorias del gobierno boliviano","cells":[{"id":868,"value":"header = htl.html`

Convocatorias del gobierno boliviano

\n Convocatorias de contratación\n
\n del gobierno boliviano\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"seleccion_mes ? separator('en', monthFormatter.format(seleccion_mes.mes)) : html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":604,"value":"viewof seleccion_entidad = seleccion_mes ? plot_entidades(data) : html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"seleccion_entidad ? separator('publicadas por', seleccion_entidad.entidad) : html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":456,"value":"viewof seleccion_convocatorias = seleccion_entidad ? plot_entidad(seleccion_entidad) : html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"seleccion_convocatorias ? html`\n${separator('el', dateFormatter.format(seleccion_convocatorias[0].fecha_publicacion))}\n

\n ${seleccion_convocatorias.map(convocatoria => renderConvocatoria(convocatoria))}\n

` : html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":973,"value":"separator = (prefix, text) => {\n return html`

\n ${prefix}\n ${text}\n

`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1129,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"baseURL = 'https://raw.githubusercontent.com/sociedatos/bo-convocatorias_publicas/master'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"indice = aq.loadCSV(`${baseURL}/indice.csv`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"categorias = {\n const data = await aq.fromCSV(await FileAttachment('entidades (1).csv').text())\n return Object.fromEntries(data.objects().map(e => [e.entrada, {categoria: e.categoria, grupo: e.grupo}]))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"data = seleccion_mes ? getData(seleccion_mes) : []","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"getData = (seleccion_mes) => {\n const fn = `${seleccion_mes.mes.getUTCFullYear()}${String(seleccion_mes.mes.getUTCMonth() + 1).padStart(2, '0')}`\n return aq.loadCSV(`${baseURL}/data/${fn}.csv`)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"async function getEntidades(data) {\n \n return data.\n derive({\n codigo_entidad: d => op.parse_int(op.split(d.cuce, '-')[1])\n }).\n derive({\n categoria: aq.escape(d => categorias[d.codigo_entidad] ? categorias[d.codigo_entidad].categoria : 'otras entidades'),\n grupo: aq.escape(d => categorias[d.codigo_entidad] ? categorias[d.codigo_entidad].grupo : 'otras entidades')\n }).\n groupby('entidad', 'categoria', 'grupo').\n count({as: 'convocatorias'}).\n orderby(aq.desc('convocatorias'))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":669,"value":"end_month = seleccion_mes ? new Date(seleccion_mes.mes.getUTCFullYear(), seleccion_mes.mes.getUTCMonth() + 1, 1) - 86400000 : 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"dateFormatter = new Intl.DateTimeFormat('es-US', {\n day: 'numeric',\n month: 'long',\n year: 'numeric',\n timeZone: \"UTC\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":821,"value":"monthFormatter = new Intl.DateTimeFormat('es-US', {\n month: 'long',\n year: 'numeric',\n timeZone: \"UTC\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"renderConvocatoria = (convocatoria) => {\n return html`\n

${convocatoria.objeto_de_contratacion}

${convocatoria.cuce}

\n `\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"colors = ({\n shape: \"#49515B\",\n title: \"#49515B\",\n frame: \"#b9bfc7\",\n inactive: \"#c7cfd9\",\n background: \"#fff\",\n Bienes: '#68A0D3',\n Obras: '#C0E0DF',\n \"Servicios Generales\": '#F9CEA3',\n Consultoria: '#F6A395'\n // Bienes: '#B9D6E2',\n // \"Servicios Generales\": \"#E5A89D\",\n // Consultoria: \"#958AD1\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 24:null