service_requests

Service requests from Arlington VA residents

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

7 rows where name = "Traffic 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 · 7 ✖

name 1

  • Traffic Sign Damaged/Missing · 7 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
135819 135819 228004 Traffic Sign Damaged/Missing   in progress -77.10092639 38.87775558 3495 5th St N, Arlington VA 2025-09-23 16:54:00 2025-11-06 06:05:46.450000000 public QScend
142310 142310 238169 Traffic Sign Damaged/Missing   in progress -77.06871104 38.85265829 2310 S Arlington Ridge Rd, Arlington VA 2025-12-08 20:44:00 2025-12-10 06:05:49.430000000 public QScend
158828 158828 200871 Traffic Sign Damaged/Missing   in progress -77.08491374 38.86622115 795 S Barton St, Arlington VA 2025-04-08 15:05:00 2025-04-09 16:08:55.420000000 public QScend
165296 165296 235684 Traffic Sign Damaged/Missing   in progress -77.13290485 38.91122936 4748 34th St N, Arlington VA 2025-11-19 13:16:00 2025-12-03 07:00:13.713000000 public QScend
166746 166746 224479 Traffic Sign Damaged/Missing   in progress -77.14468385 38.88554694 1601 N Nicholas St, Arlington VA 2025-09-03 09:02:00 2025-09-17 07:00:12.597000000 public QScend
169233 169233 200206 Traffic Sign Damaged/Missing   in progress -77.05778096 38.85546351 700 20th St S, Arlington VA 2025-04-02 13:35:00 2025-04-04 06:06:54.967000000 public QScend
170789 170789 228385 Traffic Sign Damaged/Missing   in progress -77.10323825 38.85244284 S Four Mile Run Dr, Arlington VA 2025-09-25 15:57:00 2025-10-09 06:07:51.530000000 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]);