service_requests

Service requests from Arlington VA residents

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

4 rows where name = "Streetlight Issue" 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 · 4 ✖

name 1

  • Streetlight Issue · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
138835 138835 225925 Streetlight Issue   in progress -77.08631731 38.88712859 2249 FAIRFAX DR, Arlington VA 2025-09-10 17:10:00 2025-09-18 07:00:11.153000000 public QScend
141270 141270 221546 Streetlight Issue   in progress -77.11653600 38.85943741 5000 7th Rd S, Arlington VA 2025-08-19 10:34:00 2025-09-26 06:07:51.193000000 public QScend
144625 144625 229494 Streetlight Issue   in progress -77.11416728 38.88391177 4407 11th St N, Arlington VA 2025-10-03 11:15:00 2025-10-11 07:00:12.080000000 public QScend
158430 158430 198120 Streetlight Issue   in progress -77.07383587 38.89848998 Langston Blvd, Arlington VA 2025-03-16 19:33:00 2025-06-12 16:10:03.480000000 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]);