service_requests

Service requests from Arlington VA residents

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

6 rows where name = "Recent Construction Drainage Changes" and status = "in progress"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: longitude, latitude, address, updated_at, created_at (date), updated_at (date)

status 1

  • in progress · 6 ✖

name 1

  • Recent Construction Drainage Changes · 6 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
113465 113465 194773 Recent Construction Drainage Changes   in progress -77.08667770 38.83315290 2750 S Stafford St, Arlington VA 2025-02-14 14:40:00 2025-02-19 06:05:52.317000000 public QScend
125450 125450 209592 Recent Construction Drainage Changes   in progress -77.11584984 38.91636994 3130 N Piedmont St, Arlington VA 2025-06-18 20:12:00 2025-07-18 06:05:56.107000000 public QScend
127750 127750 215134 Recent Construction Drainage Changes   in progress -77.11855202 38.87484699 507 N EDISON ST, Arlington VA 2025-07-28 21:30:00 2025-07-30 06:08:54.923000000 public QScend
128221 128221 212584 Recent Construction Drainage Changes   in progress -77.11510597 38.91552898 3101 N OAKLAND ST, Arlington VA 2025-07-09 20:35:00 2025-07-18 06:05:56.107000000 public QScend
128700 128700 213384 Recent Construction Drainage Changes   in progress -77.12867501 38.90350698 2640 N GLEBE RD, Arlington VA 2025-07-15 14:37:00 2025-07-18 06:05:56.107000000 public QScend
135189 135189 213245 Recent Construction Drainage Changes   in progress -77.11584984 38.91636994 3130 N Piedmont St, Arlington VA 2025-07-14 19:12:00 2025-07-18 06:05:56.107000000 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]);