URT PQRS Management: Public Service Request Tracking by Month

Monthly tracking of public service requests (PQRS) managed by the URT entity. Columns suggest data on request types, submission and resolution dates, legal deadlines, and territorial assignment. The dataset is hosted by the Colombian open data portal www.datos.gov.co and was last updated on May 18, 2026.

Use Cases

• Analyze request processing times using Fecha radicado inicial, Fecha radicado final, and Dias vencimiento terminos legales.
• Classify request types and subtypes for trend analysis using Tipo requerimiento and Subtipo.
• Monitor compliance with legal deadlines across different territories using Fecha vencimiento terminos legales and Territorial.
• Track monthly request volume and backlog by aggregating records by Fecha radicado inicial and Nivel.

Strengths

• Includes 10 distinct columns covering key administrative workflow stages.
• Provides temporal tracking with multiple date columns for submission, resolution, and deadlines.
• Hosted on a national open data platform (www.datos.gov.co), suggesting an official source.

Limitations

• Row count is unknown, which may limit suitability assessment for large-scale analysis.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

www.datos.gov.co (Colombian open data portal).

Collection Method

Likely extracted from an internal government request management system.

Freshness

Last updated 2026-05-18 16:42:21; freshness should be verified.

Geography

Colombia (implied by source domain .gov.co and column 'Territorial').