service_requests

Service requests from Arlington VA residents

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

4 rows where name = "Public Art" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 4 ✖

name 1

  • Public Art · 4 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
75931 75931 135085 Public Art   open -77.09685748 38.89017538 3136 Key Blvd, Arlington VA 2023-10-13 17:11:00 2023-10-18 12:57:58.517000000 public QScend
102376 102376 150760 Public Art   open -77.09490017 38.88587809 3100 Clarendon Blvd, Arlington VA 2024-02-09 16:33:00 2024-02-10 19:31:33.803000000 public QScend
119615 119615 181256 Public Art   open -77.04383800 38.86975499 333 Long Bridge Dr, Arlington VA 2024-10-15 19:07:00 2024-10-16 20:31:51.587000000 public QScend
142394 142394 131630 Public Art   open -77.12649000 38.88477000 1200 N GEORGE MASON DR, Arlington VA 2023-09-15 10:14:00 2023-09-20 14:00:47.470000000 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]);