service_requests

Service requests from Arlington VA residents

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

7 rows where name = "Storm Drain Blocked, Damaged, Overflowing" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 7 ✖

name 1

  • Storm Drain Blocked, Damaged, Overflowing · 7 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
141623 141623 238823 Storm Drain Blocked, Damaged, Overflowing   open -77.10876397 38.88071902 801 N Randolph St, Arlington VA 2025-12-12 20:40:00 2025-12-24 06:05:48.250000000 public QScend
168986 168986 240207 Storm Drain Blocked, Damaged, Overflowing   open -77.08625221 38.86434098 2813 9th St S, Arlington VA 2025-12-26 13:01:00 2025-12-27 07:00:07.183000000 public QScend
174420 174420 211578 Storm Drain Blocked, Damaged, Overflowing   open -77.08829704 38.82813402 4118 36th St S, Arlington VA 2025-07-02 13:22:00 2025-07-09 06:06:55.950000000 public QScend
174793 174793 160979 Storm Drain Blocked, Damaged, Overflowing   open -77.10357565 38.87020888 3993 Cathedral Ln, Arlington VA 2024-05-10 09:51:00 2024-05-16 20:32:04.040000000 public QScend
176494 176494 123132 Storm Drain Blocked, Damaged, Overflowing   open -77.13174106 38.87614858 863 N KENTUCKY ST, Arlington VA 2023-07-18 17:09:00 2023-11-03 18:31:58.293000000 public QScend
177167 177167 172835 Storm Drain Blocked, Damaged, Overflowing   open -77.09383584 38.89873592 2707 Lorcom Ln, Arlington VA 2024-08-03 15:17:00 2024-08-09 20:31:45.553000000 public QScend
178889 178889 214634 Storm Drain Blocked, Damaged, Overflowing   open -77.11768399 38.87746802 719 N ALBEMARLE ST, Arlington VA 2025-07-24 13:12:00 2025-11-07 06:05:48.910000000 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]);