Pqrs: Petitions, Complaints, and Claims Processed by the Municipality of Madrid, Colombia

Petitions, complaints, and claims received and processed by the Mayor's Office of Madrid, Cundinamarca. The dataset includes monthly counts for each month of the year, a total, an average, and the responsible department. The data is provided by www.datos.gov.co and was last updated on 2026-05-18.

Use Cases

• Analyze seasonal trends in citizen complaints by comparing monthly columns like ENERO, FEBRERO, and JULIO.
• Identify high-volume departments by aggregating the TOTAL column grouped by the DEPENDENCIA column.
• Calculate yearly performance metrics using the AÑO, TOTAL, and PROMEDIO columns.
• Benchmark monthly performance against the annual average using the PROMEDIO column and specific month columns like MARZO or NOVIEMBRE.

Strengths

• Provides a breakdown of citizen service requests by month and department.
• Includes a calculated PROMEDIO (average) column for yearly benchmarking.
• Data is available in multiple machine-readable formats including CSV, JSON, XML, and RDF.

Limitations

• Row count is unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.
• License information is unknown, which may restrict commercial or derivative use.

Provenance

Source

www.datos.gov.co

Collection Method

Likely collected through municipal citizen service channels.

Time Range

Implied yearly coverage by the AÑO column, but specific range is unknown.

Freshness

Last updated 2026-05-18 16:54:43; freshness should be verified.

Geography

Municipality of Madrid, Cundinamarca, Colombia.