Skip to content

Instantly share code, notes, and snippets.

@amercader

amercader/report_goodtables.json

Created June 28, 2017 15:00
Show Gist options
  • Save amercader/755f4dd3d1ee6a27125ef3886191d54a to your computer and use it in GitHub Desktop.
Save amercader/755f4dd3d1ee6a27125ef3886191d54a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
report_goodtables.json
{
"error-count": 76,
"errors": [],
"table-count": 10,
"tables": [
{
"error-count": 13,
"errors": [
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 53 is duplicated to row(s) 52",
"row": [
"2012",
"Baja California",
"Ensenada",
"San Vicente",
"LLANO COLORADO",
"Atendido"
],
"row-number": 53
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 89 is duplicated to row(s) 87",
"row": [
"2012",
"Guerrero",
"Acapulco de Ju\u00e1rez",
"Acapulco de Ju\u00e1rez",
"MALECON",
"Atendido"
],
"row-number": 89
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 90 is duplicated to row(s) 87, 89",
"row": [
"2012",
"Guerrero",
"Acapulco de Ju\u00e1rez",
"Acapulco de Ju\u00e1rez",
"MALECON",
"Atendido"
],
"row-number": 90
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 118 is duplicated to row(s) 117",
"row": [
"2012",
"Oaxaca",
"San Pedro Pochutla",
"Puerto \u00c1ngel",
"PUERTO ANGEL",
"Atendido"
],
"row-number": 118
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 145 is duplicated to row(s) 140",
"row": [
"2012",
"Sinaloa",
"Angostura",
"La Reforma",
"LA REFORMA",
"Atendido"
],
"row-number": 145
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 157 is duplicated to row(s) 154",
"row": [
"2012",
"Sonora",
"Huatabampo",
"Las Bocas",
"PLAYA SUR",
"Atendido"
],
"row-number": 157
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 166 is duplicated to row(s) 165",
"row": [
"2012",
"Sonora",
"Empalme",
"Empalme",
"CRUZ DE PIEDRA",
"Atendido"
],
"row-number": 166
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 182 is duplicated to row(s) 178",
"row": [
"2012",
"Veracruz",
"Pueblo Viejo",
"Cd. Cuauht\u00e9moc",
"LAGUNA DE PUEBLO VIEJO",
"Atendido"
],
"row-number": 182
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 227 is duplicated to row(s) 226",
"row": [
"2013",
"Jalisco",
"Clhuati\u00e1n",
"Barra de Navidad",
"BARRA DE NAVIDAD",
"Atendido"
],
"row-number": 227
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 245 is duplicated to row(s) 244",
"row": [
"2013",
"Jalisco",
"Tomatl\u00e1n",
"Presa Caj\u00f3n de Pe\u00f1a (La Presa)",
"COOPERATIVA",
"Atendido"
],
"row-number": 245
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 247 is duplicated to row(s) 246",
"row": [
"2013",
"Jalisco",
"Chapala",
"Chapala",
"EL SITIO",
"Atendido"
],
"row-number": 247
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 251 is duplicated to row(s) 244, 245",
"row": [
"2013",
"Jalisco",
"Tomatl\u00e1n",
"Presa Caj\u00f3n de Pe\u00f1a (La Presa)",
"COOPERATIVA",
"Atendido"
],
"row-number": 251
},
{
"code": "duplicate-row",
"column-number": null,
"message": "Row 331 is duplicated to row(s) 330",
"row": [
"2013",
"Veracruz",
"Pueblo Viejo",
"Cd. Cuauht\u00e9moc",
"LAGUNA DE TAMIAHUA",
"Atendido"
],
"row-number": 331
}
],
"headers": [
"A\u00f1o",
"Estado",
"Municipio",
"Localidad",
"Lugar_Conocido",
"Estatus"
],
"row-count": 344,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/denuncias.csv",
"time": 0.721,
"valid": false
},
{
"error-count": 0,
"errors": [],
"headers": [
"Area_Adscripcion",
"A\u00f1o",
"Numero_oficiales"
],
"row-count": 161,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/numero-de-oficiales-federales-de-pesca.csv",
"time": 0.742,
"valid": true
},
{
"error-count": 0,
"errors": [],
"headers": [
"Estado",
"Tipo",
"A\u00f1o",
"Numero_embarcaciones"
],
"row-count": 141,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/numero-embarcaciones.csv",
"time": 0.701,
"valid": true
},
{
"error-count": 0,
"errors": [],
"headers": [
"A\u00f1o",
"Estado",
"Especie",
"Cantidad"
],
"row-count": 1000,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/pesca-ilegal.csv",
"time": 0.857,
"valid": true
},
{
"error-count": 0,
"errors": [],
"headers": [
"A\u00f1o",
"Estado",
"Recorridos_Terrestres",
"Recorridos_Acuaticos",
"Personas_MP"
],
"row-count": 161,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/recorridos-inspeccion.csv",
"time": 0.706,
"valid": true
},
{
"error-count": 0,
"errors": [],
"headers": [
"Tipo",
"Estado",
"A\u00f1o",
"Incautadas"
],
"row-count": 481,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/retenidas-provisionalmente.csv",
"time": 0.73,
"valid": true
},
{
"error-count": 0,
"errors": [],
"headers": [
"Estado",
"A\u00f1o",
"Actas_Verificaciones"
],
"row-count": 161,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2011-2013/total-de-actas-y-verificaciones-documentales.csv",
"time": 0.687,
"valid": true
},
{
"error-count": 21,
"errors": [
{
"code": "blank-header",
"column-number": 2,
"message": "Header in column 2 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 3,
"message": "Header in column 3 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 4,
"message": "Header in column 4 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 5,
"message": "Header in column 5 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 7,
"message": "Header in column 7 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 8,
"message": "Header in column 8 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 9,
"message": "Header in column 9 is blank",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 3,
"message": "Header in column 3 is duplicated to header in column(s) 2",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 4,
"message": "Header in column 4 is duplicated to header in column(s) 2, 3",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 5,
"message": "Header in column 5 is duplicated to header in column(s) 2, 3, 4",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 7,
"message": "Header in column 7 is duplicated to header in column(s) 2, 3, 4, 5",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 8,
"message": "Header in column 8 is duplicated to header in column(s) 2, 3, 4, 5, 7",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 9,
"message": "Header in column 9 is duplicated to header in column(s) 2, 3, 4, 5, 7, 8",
"row": null,
"row-number": null
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 3 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 3
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 24 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 24
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 25 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 25
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 26 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 26
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 27 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 27
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 28 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 28
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 29 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 29
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 30 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 30
}
],
"headers": [
"FORMATO DEL AVANCE FISICO FINANCIERO AL 31 DE DICIEMBRE DEL 2014",
null,
null,
null,
null,
"AVANCE FINANCIERO COMPONENTE 2014 - 2015",
null,
null,
null
],
"row-count": 30,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2014-2015/PRESUPUESTO DGIV 2014-2015 (ANEXO 1).ods",
"time": 0.73,
"valid": false
},
{
"error-count": 42,
"errors": [
{
"code": "blank-header",
"column-number": 1,
"message": "Header in column 1 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 2,
"message": "Header in column 2 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 3,
"message": "Header in column 3 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 4,
"message": "Header in column 4 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 5,
"message": "Header in column 5 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 6,
"message": "Header in column 6 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 7,
"message": "Header in column 7 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 8,
"message": "Header in column 8 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 9,
"message": "Header in column 9 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 10,
"message": "Header in column 10 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 11,
"message": "Header in column 11 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 12,
"message": "Header in column 12 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 13,
"message": "Header in column 13 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 14,
"message": "Header in column 14 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 15,
"message": "Header in column 15 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 16,
"message": "Header in column 16 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 17,
"message": "Header in column 17 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 18,
"message": "Header in column 18 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 19,
"message": "Header in column 19 is blank",
"row": null,
"row-number": null
},
{
"code": "blank-header",
"column-number": 20,
"message": "Header in column 20 is blank",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 2,
"message": "Header in column 2 is duplicated to header in column(s) 1",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 3,
"message": "Header in column 3 is duplicated to header in column(s) 1, 2",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 4,
"message": "Header in column 4 is duplicated to header in column(s) 1, 2, 3",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 5,
"message": "Header in column 5 is duplicated to header in column(s) 1, 2, 3, 4",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 6,
"message": "Header in column 6 is duplicated to header in column(s) 1, 2, 3, 4, 5",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 7,
"message": "Header in column 7 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 8,
"message": "Header in column 8 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 9,
"message": "Header in column 9 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 10,
"message": "Header in column 10 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 11,
"message": "Header in column 11 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 12,
"message": "Header in column 12 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 13,
"message": "Header in column 13 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 14,
"message": "Header in column 14 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 15,
"message": "Header in column 15 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 16,
"message": "Header in column 16 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 17,
"message": "Header in column 17 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 18,
"message": "Header in column 18 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 19,
"message": "Header in column 19 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18",
"row": null,
"row-number": null
},
{
"code": "duplicate-header",
"column-number": 20,
"message": "Header in column 20 is duplicated to header in column(s) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19",
"row": null,
"row-number": null
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 2 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 2
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 42 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 42
},
{
"code": "blank-row",
"column-number": null,
"message": "Row 43 is completely blank",
"row": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-number": 43
}
],
"headers": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
"row-count": 43,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2014-2015/RESULTADOS 2014-2015 (ANEXO 3).ods",
"time": 0.845,
"valid": false
},
{
"error-count": 0,
"errors": [],
"headers": [
"A\u00f1o",
"Arte de Pesca",
"Vehiculo",
"Embarcacion",
"NOMBRE ",
"RNPA",
"Estado",
"Municipio",
"Localidad"
],
"row-count": 10,
"source": "https://raw.githubusercontent.com/amercader/causanatura-datos/a16185585cea2ed3d5a5ec8fa79d442a00398882/Inspeccion/2014-2015/artes_pesca_vehiculos_embarcaciones_decomisadas.csv",
"time": 0.691,
"valid": true
}
],
"time": 0.861,
"valid": false
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment