service_requests

Service requests from Arlington VA residents

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

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

name 1

  • Sinkholes · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
170228 170228 149522 Sinkholes   in progress -77.13755899 38.89065300 5605 19TH ST N, Arlington VA 2024-01-31 11:28:00 2024-03-06 19:31:50.890000000 public QScend
170655 170655 233304 Sinkholes   in progress -77.15445205 38.90189283 3338 N Pocomoke St, Arlington VA 2025-11-01 14:48:00 2025-11-04 06:07:49.823000000 public QScend
172156 172156 229729 Sinkholes   in progress -77.13287917 38.88416057 1401 N Ivanhoe St, Arlington VA 2025-10-06 08:19:00 2025-10-29 06:07:48.850000000 public QScend
178110 178110 167716 Sinkholes   in progress -77.14921201 38.88765299 6201 WASHINGTON BLVD, Arlington VA 2024-06-20 19:30:00 2024-06-22 20:31:55.307000000 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]);