service_requests

Service requests from Arlington VA residents

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

6 rows where name = "Parking Sign Damaged/Missing" and status = "in progress"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • in progress · 6 ✖

name 1

  • Parking Sign Damaged/Missing · 6 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
135791 135791 227962 Parking Sign Damaged/Missing   in progress -77.12539674 38.87673221 824 N GREENBRIER ST, Arlington VA 2025-09-23 14:30:00 2025-09-24 07:00:11.567000000 public QScend
143301 143301 232368 Parking Sign Damaged/Missing   in progress -77.11843400 38.89251701 18TH ST N, Arlington VA 2025-10-24 13:55:00 2025-11-07 07:00:09.527000000 public QScend
144965 144965 230289 Parking Sign Damaged/Missing   in progress -77.13417597 38.86631602 Manchester St, Arlington VA 2025-10-08 18:20:00 2025-10-24 06:06:50.957000000 public QScend
145142 145142 237700 Parking Sign Damaged/Missing   in progress -77.08736126 38.85358779 3164 19th St S, Arlington VA 2025-12-04 10:27:00 2025-12-18 07:00:10.800000000 public QScend
146415 146415 237577 Parking Sign Damaged/Missing   in progress -77.09067934 38.84682562 2440 S Oakland St, Arlington VA 2025-12-03 14:47:00 2025-12-09 06:06:49.863000000 public QScend
147484 147484 237918 Parking Sign Damaged/Missing   in progress -77.08856827 38.84704766 2446 S Monroe St, Arlington VA 2025-12-05 17:38:00 2025-12-20 06:06:49.477000000 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]);