service_requests

Service requests from Arlington VA residents

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

4 rows where name = "Signal Analysis" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 4 ✖

name 1

  • Signal Analysis · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
139321 139321 227149 Signal Analysis   open -77.12840947 38.86656601 Carlin Springs Rd, Arlington VA 2025-09-18 11:59:00 2025-09-19 06:08:50.083000000 public QScend
141685 141685 239190 Signal Analysis   open -77.10980238 38.85639670 Columbia Pike, Arlington VA 2025-12-16 17:46:00 2025-12-17 07:00:10.363000000 public QScend
142012 142012 240030 Signal Analysis   open -77.10266001 38.88200107 781 N Monroe St, Arlington VA 2025-12-23 16:34:00 2025-12-24 07:00:09.557000000 public QScend
164889 164889 233622 Signal Analysis   open -77.07378258 38.89455895 N Oak St, Arlington VA 2025-11-04 10:39:00 2025-11-05 03:00:11.757000000 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]);