service_requests

Service requests from Arlington VA residents

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

4 rows where name = "General Park Maintenance" 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

  • General Park Maintenance · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
50689 50689 82486 General Park Maintenance   in progress -77.10904996 38.87990002 Wilson Blvd, Arlington VA 2022-08-15 19:01:00 2022-08-21 16:00:34.487000000 public QScend
89436 89436 160528 General Park Maintenance   in progress -77.10763401 38.87796157 541 N Quincy St, Arlington VA 2024-05-07 09:50:00 2024-05-23 20:31:55.430000000 public QScend
118982 118982 199017 General Park Maintenance   in progress -77.08835515 38.88729165 2512 FAIRFAX DR, Arlington VA 2025-03-24 08:01:00 2025-03-27 06:05:59.740000000 public QScend
137946 137946 128402 General Park Maintenance   in progress -77.09428216 38.89801762 Spout Run Pkwy, Arlington VA 2023-08-21 15:52:00 2024-02-06 19:31:55.347000000 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]);