Instantly share code, notes, and snippets.

View 0_giustizia-amministrativa.sh
#!/bin/bash
### requirements ###
# scrape-cli https://github.com/aborruso/scrape-cli
# xq https://github.com/kislyuk/yq
### requirements ###
set -x
rm ./uriR.txt
View 00xlsTask.md
pyexcel transcode input.xls out_.csv
for i in out_*.csv;do mlr --csv put '$foglio = "'"$i"'"' then cut -f "campoUno,campoTre,foglio" then filter '(NR == 3 || NR == 7)' "$i" >tmp_"$i"; done
mlr  --csv cat tmp_* >./output.csv
  • con pyexcel trasformo tutti i fogli in file CSV;
  • poi con miller estraggo soltanto le celle dei campi campoUno e campoTre di riga 3 e 7. Aggiungo pure una colonna con il nome del foglio;
  • e infine creo con miller un unico file di output.
View gist:610d7e08a6ae02ef4f6c5f3306b57c8e
<html>
<head>
<meta name="generator" content="HTML Tidy for HTML5 for Linux version 5.2.0">
<title>
</title>
</head>
<body>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">
<h4>
A PHP Error was encountered
View gist:4f395483929c7c6c2547bdf226ef34fd
BENEFICIARIO;DATI_FISCALI;IMPORTO;NORMA;UFFICIO;RESPONSABILE;INDIVIDUAZIONE;DOCUMENTI;DATA;NUMPROVVEDIMENTO;FOLDER;DATA_PUBBLICAZIONE;ID;anno
"1° CIRCOLO DIDATTICO ""N SPEDALIERI""";80013070877;€ 931,18;Art. 6 L.R. 09/08/1988 n°15;Servizio 8 Scuole Statali;Picone Giuseppa;ripartizione per funzione delegata;allegati_vari_2156.zip;28/05/2018;2156;dip_istr_form;29/05/2018;1008686;2018
"1° CIRCOLO DIDATTICO ""N SPEDALIERI""";80013070877;€ 14.925,00;Art. 7 L.R. 24/02/2000 n 6;Servizio 8 Scuole Statali;Picone Giuseppa;ripartizione per funzione delegata;allegato_vari_4821.zip;28/09/2018;4821;dip_istr_form;28/09/2018;1012405;2018
View gist:15c629c8d814c8bb7ae434d509a189f5
BENEFICIARIO;IMPORTO_CORRISPOSTO;NUM_PROVVEDIMENTI
"1° CIRCOLO DIDATTICO "N SPEDALIERI"";15.856,00;2
"1° IC " V VENETO "";22.412,00;2
"1° IC "G M COLUMBA"";26.112,00;2
View README.md
View 00README.md
statusid,user,id
1044561432141058050,synapta,01
1045273277256671232,GiorgiaLodi,02
1046660399108689920,openantani,03
View bo.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View index.html
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.10.0-alpha/dist/katex.min.css" integrity="sha384-BTL0nVi8DnMrNdMQZG1Ww6yasK9ZGnUxL1ZWukXQ7fygA1py52yPp9W4wrR00VML" crossorigin="anonymous">
<style>
/*--------------------------------------------------------------------------------------------- * Copyright (c) Microsoft Corporation. All rights reserved. * Licensed under the MIT License. See License.txt in the project root for license information. *--------------------------------------------------------------------------------------------*/ body { font-family: "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback"; font-size: 14px; padding: 0 26px; line-height: 22px; word-wrap: break-word; } #code-csp
View index.html
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.10.0-alpha/dist/katex.min.css" integrity="sha384-BTL0nVi8DnMrNdMQZG1Ww6yasK9ZGnUxL1ZWukXQ7fygA1py52yPp9W4wrR00VML" crossorigin="anonymous">
<style>
/*--------------------------------------------------------------------------------------------- * Copyright (c) Microsoft Corporation. All rights reserved. * Licensed under the MIT License. See License.txt in the project root for license information. *--------------------------------------------------------------------------------------------*/ body { font-family: "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback"; font-size: 14px; padding: 0 26px; line-height: 22px; word-wrap: break-word; } #code-csp