service_requests

Service requests from Arlington VA residents

Data source: Arlington County Open Data Portal · About: DES - Environmental Services

4 rows where name = "Damaged rack or parking corral" and status = "in progress"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updated_at, created_at (date), updated_at (date)

status 1

  • in progress · 4 ✖

name 1

  • Damaged rack or parking corral · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
114990 114990 188730 Damaged rack or parking corral   in progress -77.10783054 38.87626637 419 N GLEBE RD, Arlington VA 2024-12-30 10:31:00 2025-12-25 07:00:07.990000000 public QScend
118079 118079 201760 Damaged rack or parking corral   in progress -77.09386696 38.88713552 2950 Clarendon Blvd, Arlington VA 2025-04-16 14:36:00 2025-04-25 16:05:53.027000000 public QScend
118655 118655 202637 Damaged rack or parking corral   in progress -77.07932992 38.89203494 1607 N RHODES ST, Arlington VA 2025-04-24 12:48:00 2025-04-25 16:05:53.027000000 public QScend
131117 131117 215663 Damaged rack or parking corral   in progress -77.14121318 38.88561969   2025-08-01 12:18:00 2025-08-02 16:05:55.820000000 public QScend

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [service_requests] (
   [service_request_id] TEXT,
   [name] TEXT,
   [description] TEXT,
   [status] TEXT,
   [longitude] TEXT,
   [latitude] TEXT,
   [address] TEXT,
   [created_at] TEXT,
   [updated_at] TEXT,
   [permission] TEXT,
   [source_system] TEXT
);
CREATE INDEX [idx_service_requests_name_status_created_at]
    ON [service_requests] ([name], [status], [created_at]);
CREATE INDEX [idx_service_requests_status]
    ON [service_requests] ([status]);
CREATE INDEX [idx_service_requests_name]
    ON [service_requests] ([name]);
CREATE INDEX [idx_service_requests_created_at]
    ON [service_requests] ([created_at]);