service_requests

Service requests from Arlington VA residents

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

4 rows where name = "Utility Cover Damaged/Missing" 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

  • Utility Cover Damaged/Missing · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
170542 170542 202058 Utility Cover Damaged/Missing   open -77.10747902 38.85493901 4600 S Four Mile Run Dr, Arlington VA 2025-04-19 12:42:00 2025-04-23 06:06:54.163000000 public QScend
175503 175503 228658 Utility Cover Damaged/Missing   open -77.05850467 38.84416063 3342 S Glebe Rd, Arlington VA 2025-09-28 14:13:00 2025-09-30 06:08:51.020000000 public QScend
177852 177852 228118 Utility Cover Damaged/Missing   open -77.14100060 38.88150904 1200 N Livingston St, Arlington VA 2025-09-24 11:54:00 2025-09-26 06:07:51.193000000 public QScend
178460 178460 200403 Utility Cover Damaged/Missing   open -77.14553375 38.87860835 1029 N McKinley Rd, Arlington VA 2025-04-03 21:03:00 2025-04-05 06:08:02.707000000 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]);