{"id":"168f1956-f2ba-44cf-8b16-7e05e46c4f3d","type":"DATASET","name":"Comments posted on the Open Data Portal","slug":"comments-posted-on-the-open-data-portal","description":"This data set includes the comments published in the Open Data Portal of the City of Madrid. It incorporates the link to the dataset, the text of the comment and the date of publication. Associated with each dataset, comments related to the publications can be sent. In many cases, comments expand the information and add value to the published data.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-1-comentarios-datos-abiertos-xlsx/download/900035-1-comentarios-datos-abiertos-xlsx","status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=datos.madrid.es","primary_source_url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-1-comentarios-datos-abiertos-xlsx/download/900035-1-comentarios-datos-abiertos-xlsx","extraction_confidence":"0.16","created_at":"2026-07-18T12:44:47.988Z","updated_at":"2026-10-12T21:54:34.935Z","last_verified_at":"2026-10-12T21:54:34.935Z","deprecated_at":null,"ranking_score":36,"last_ranked_at":"2026-10-06T12:20:09.665Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-06T08:51:50.862Z","search_vector":"'a':231B 'access':128B 'accessible':269B 'add':62B,119B,203B,260B 'and':178B,202B,240B,251B,272B 'associ':42B 'associated':183B 'authent':130B 'authentication':271B 'ayuntamiento':79B,220B 'be':193B 'can':192B,245B 'case':56B 'cases':197B 'citi':22B,77B 'city':163B,218B 'comment':1A,13B,36B,46B,57B,72B,87B,97B,106B,177B,228B,238B 'comments':142A,154B,187B,198B,213B,247B 'contain':70B 'contains':211B 'council':78B,219B 'cover':132B 'covers':273B 'data':6A,9B,18B,67B,83B,140B,147A,150B,159B,208B,224B,281B 'dataset':31B,45B,69B,95B,109B,125B,172B,186B,210B,236B,266B 'datasets':250B 'date':39B,102B,180B,243B 'de':80B,221B 'each':185B,227B 'expand':58B,113B,199B,254B 'for':226B 'freeli':127B 'freely':268B 'in':156B,195B 'includ':11B,89B 'includes':152B,230B 'incorpor':26B 'incorporates':167B 'individu':108B 'individual':249B 'inform':60B,117B 'information':201B,258B 'is':267B 'it':166B,229B,264B 'link':28B,91B,169B,232B 'madrid':24B,76B,81B,137B,165B,217B,222B,278B 'mani':55B 'many':196B 'national/municipal':134B,275B 'of':161B,164B,175B,181B,277B 'offer':141B 'offering':282B 'often':112B,253B 'on':144A,215B,248B,255B 'open':5A,17B,82B,139B,146A,158B,223B,280B 'or':259B 'portal':7A,19B,84B,148A,160B,225B 'post':2A 'posted':143A 'public':41B,50B,101B 'publication':182B,242B 'publications':191B 'publish':14B,66B,73B,116B 'published':155B,207B,214B,257B 'relat':47B,94B 'related':188B,235B 's':279B 'scope':135B,276B 'sent':53B,194B 'set':10B,151B 'submit':105B,246B 'supplementari':120B 'supplementary':261B 'text':33B,98B,174B,239B 'the':145A,153B,157B,162B,168B,171B,173B,176B,179B,190B,200B,206B,212B,216B,234B,237B,241B,256B,265B,274B 'these':252B 'this':149B,209B 'to':170B,189B,205B,233B,263B 'user':103B 'users':244B 'valu':63B,121B 'value':204B,262B 'with':184B 'without':129B,270B","popularity_score":"0.0000","maintenance_score":"0.5000","institution_id":null,"institution_type":null,"country_code":null,"official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-18T13:30:57.926Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset contains the comments published on the Madrid City Council (Ayuntamiento de Madrid) Open Data Portal. For each comment, it includes a link to the related dataset, the comment text, and the publication date. Users can submit comments on individual datasets, and these often expand on the published information or add supplementary value to it. The dataset is freely accessible without authentication and covers the national/municipal scope of Madrid's open data offering.","native_lang":"en","access_level":"direct","formats":["CSV"],"capability_tier":"sample","trust_score":55.23076923076923,"merged_into_entry_id":null,"identity_key":"DATASET|https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-1-comentarios-datos-abiertos-xlsx/download/900035-1-comentarios-datos-abiertos-xlsx|comments posted on the open data portal","upstream_ref":null,"content_changed_at":null,"title_qualifier":null,"access":{"level":"direct","primary":{"kind":"download","label":"Download CSV","method":"GET","url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv","format":"CSV","byte_size":"379380","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv","format":"CSV","byte_size":"379380","source":"distribution","runnable":true},{"kind":"query","label":"Dataset metadata (DCAT)","method":"GET","url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos.rdf","source":"query_example","runnable":true,"direct":false},{"kind":"landing","label":"Open source page","method":"GET","url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos","source":"landing_page","runnable":false},{"kind":"landing","label":"Open source record","method":"GET","url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-1-comentarios-datos-abiertos-xlsx/download/900035-1-comentarios-datos-abiertos-xlsx","source":"primary_source","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"168f1956-f2ba-44cf-8b16-7e05e46c4f3d","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"profiled","level_index":3,"level_label":"Profiled","meaning":"Schema, dimensions and licence understood","counts_as_coverage":false,"blocked_by":null,"rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":false,"reached":false,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":null,"proven_threshold":80,"institution_id":null,"definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"datos.madrid.es","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-10-12T22:45:59.930Z"},"api_details":null,"dataset_details":{"id":"1d5ffbae-3e35-4e7c-956a-b0670c19bb81","entry_id":"168f1956-f2ba-44cf-8b16-7e05e46c4f3d","upstream_issued":"2025-11-17T00:00:00.000Z","upstream_modified":"2026-07-24T00:00:00.000Z","themes":["GOVE"],"update_frequency":"annual","temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos","license_id":"cc-by-4.0","license_raw":"https://creativecommons.org/licenses/by/4.0/legalcode.es","has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"ckan","source_portal_url":"https://datos.madrid.es","created_at":"2026-07-18T12:44:48.152Z","updated_at":"2026-10-06T16:18:11.376Z","publisher":"Ayuntamiento de Madrid","publisher_url":null,"distributions":[{"id":"ce757d43-b8d1-4bcd-8d48-ea4387e3505f","dataset_details_id":"1d5ffbae-3e35-4e7c-956a-b0670c19bb81","title":"900035-0-comentarios-datos-abiertos-csv","description":"Comentarios publicados en el Portal de Datos Abiertos","access_url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv","download_url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv","media_type":"https://www.iana.org/assignments/media-types/text/csv","format":null,"byte_size":"379380","license_id":null,"license_raw":null,"last_checked_at":"2026-10-12T21:54:33.697Z","is_available":true,"last_http_status":200,"created_at":"2026-10-06T16:18:10.361Z","updated_at":"2026-10-12T21:54:33.697Z"}],"license":{"id":"cc-by-4.0","spdx_id":"CC-BY-4.0","name":"Creative Commons Attribution 4.0","url":"https://creativecommons.org/licenses/by/4.0/","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"cc","notes":null,"created_at":"2026-06-12T16:29:19.729Z"}},"license":{"id":"cc-by-4.0","spdx_id":"CC-BY-4.0","name":"Creative Commons Attribution 4.0","url":"https://creativecommons.org/licenses/by/4.0/","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"cc","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"cc-by-4.0","license_name":"Creative Commons Attribution 4.0","license_url":"https://creativecommons.org/licenses/by/4.0/","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Deed: \"Share - copy and redistribute the material in any medium or format for any purpose, even commercially\" and \"Adapt - remix, transform, and build upon the material for any purpose, even commercially\". Under the following terms: \"Attribution - You must give appropriate credit, provide a link to the license, and indicate if changes were made.\" Notices: \"other rights such as publicity, privacy, or moral rights may limit how you use the material.\" Attribution is the only term listed; no ShareAlike term appears.","source_url":"https://creativecommons.org/licenses/by/4.0/","reviewed_at":null},"license_raw":"https://creativecommons.org/licenses/by/4.0/legalcode.es","latest_check":{"id":"10576d7e-0c3a-4758-a579-862e68534c8a","entry_id":"168f1956-f2ba-44cf-8b16-7e05e46c4f3d","status":"VERIFIED","last_checked_at":"2026-10-12T21:54:34.676Z","p50_latency_ms":1817,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-18T12:46:16.753Z","updated_at":"2026-10-12T21:54:34.676Z","consecutive_successes":193,"probe_url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/csv; charset=utf-8","probe_succeeded_at":"2026-10-12T21:54:34.676Z"},"data_profile":{"id":"8360a175-631d-44de-b673-d66ab5e5ea75","entry_id":"168f1956-f2ba-44cf-8b16-7e05e46c4f3d","profile_source":"ckan","profile_kind":"dataset","dataset_id":"900035-0-comentarios-datos-abiertos","fields":[{"name":"Dataset","type":"text","label":null,"description":null},{"name":"COMENTARIO","type":"text","label":null,"description":null},{"name":"FECHA","type":"text","label":null,"description":null}],"field_count":3,"sample_records":[{"FECHA":"2025/10/08","Dataset":"https://datos.madrid.es/sites/v/index.jsp?vgnextoid=7eb840252363c710VgnVCM1000001d4a900aRCRD","COMENTARIO":"No veo en el excel el significado de la letra A o -1 en la columna \"extensión plaza\" y no sé qué puede significar."},{"FECHA":"2025/10/06","Dataset":"https://datos.madrid.es/sites/v/index.jsp?vgnextoid=4985724ec1acd610VgnVCM1000001d4a900aRCRD","COMENTARIO":"El Sistema Integral del Ayuntamiento de Madrid incluye una red de estaciones de meteorología, que cubre todo el municipio. Las estaciones registran datos de diferentes parámetros meteorológicos (velocidad y dirección del viento, temperatura, humedad relativa, presión barométrica, radiación solar y precipitación) que sirven de apoyo y ayuda para la evaluación y predicción de la calidad del aire. El Servicio de Calidad del Aire es el encargado de gestionar y mantener la red meteorológica del Ayunt…"},{"FECHA":"2025/10/06","Dataset":"https://datos.madrid.es/sites/v/index.jsp?vgnextoid=4985724ec1acd610VgnVCM1000001d4a900aRCRD","COMENTARIO":"Buenas ¿Por qué hay estaciones que solo miden la temperatura y la humedad mientras hay otras que también miden la radiación, presión barométrica, etc...?"},{"FECHA":"2025/04/28","Dataset":"https://datos.madrid.es/sites/v/index.jsp?vgnextoid=33cb30c367e78410VgnVCM1000000b205a0aRCRD","COMENTARIO":"Hola, no consigo encontrar datos de los puntos de aforo con ID: 6985,6986,6987, 6988 y 6989 en la zona de Valdebernardo, Bulevar Jose Prat. Sin embargo, cuando lo miras a tiempo real si parece que hay dato. ¿Es posible que haya cambiado el ID, o falte en los csv por meses?  Muchas gracias de antemano."},{"FECHA":"2024/12/16","Dataset":"https://datos.madrid.es/sites/v/index.jsp?vgnextoid=4985724ec1acd610VgnVCM1000001d4a900aRCRD","COMENTARIO":"Hola. En la ficha de datos falta indicar claramete a que corresponde cada valor ¿don datos medios, mediana, maximo, primer valor, etc dentro del periodo temporal? Por ejemplo la temperatura ¿es la temperatura media en esa hora? Y la precipitación ¿es la precipitacion acumulada en la hora? etc."}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos.rdf","curl":"curl -s 'https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos.rdf' -H 'Accept: application/rdf+xml'","label":"Dataset metadata (DCAT)","method":"GET","description":"DCAT (RDF/XML) record: title, publisher, freshness and every distribution. This portal disallows /api/ in robots.txt, so this is the route to use."},{"url":"https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv","curl":"curl -sL 'https://datos.madrid.es/dataset/900035-0-comentarios-datos-abiertos/resource/900035-0-comentarios-datos-abiertos-csv/download/900035-0-comentarios-datos-abiertos-csv.csv' -o data.csv","label":"Download distribution","method":"GET","description":"Full csv file download — the schema shown was inferred from the file's first records."}],"status":"ok","error_message":null,"profiled_at":"2026-10-06T16:18:09.852Z","run_id":"3c5d5423-849b-4edb-a50a-2ba26c0ffaf2","created_at":"2026-07-18T12:46:22.266Z","updated_at":"2026-10-06T16:18:09.852Z","license_raw":"<dct:LicenseDocument>\n        <dct:identifier>cc-by</dct:identifier>\n        <dct:title xml:lang=\"es\">Creative Commons Attribution 4.0 International (CC BY 4.0)</dct:title>\n        <dct:type rdf:resource=\"http://purl.org/adms/licencetype/Attribution\"/>\n        <foaf:page rdf:resource=\"https://creativecommons.org/licenses/by/4.0/legalcode.es\"/>\n      </dct:LicenseDocument>","license_id":"cc-by-4.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"none","basis":"no_person_column_cited","grain":"none","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":[],"entity_identifiers":[]},"publication":null,"publication_evidence":null,"notice":"personal data: no cited column names a natural person (the cited columns are all this reads)"}},"datasets":[],"limits":[],"manifest":{"answer_sha256":"2ba99c790790fd81826a2db18486f9fc109d6a944b0b6dd25ba6f773b3db2536","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":22,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: maturity.rungs[] (7 rows).","live":true,"live_basis":"This body was produced by executing the request.","created_at":"2026-10-12T22:45:59.966Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}