service_requests

Service requests from Arlington VA residents

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

6 rows where name = "In-Street Bollard Damaged/Missing" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 6 ✖

name 1

  • In-Street Bollard Damaged/Missing · 6 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
105104 105104 171810 In-Street Bollard Damaged/Missing   open -77.05208051 38.84828860 Jefferson Davis Hwy, Arlington VA 2024-07-25 12:09:00 2025-12-25 07:00:07.990000000 public QScend
123486 123486 185415 In-Street Bollard Damaged/Missing   open -77.11791399 38.89860101 N Woodstock St, Arlington VA 2024-11-25 09:35:00 2025-12-25 07:00:07.990000000 public QScend
135088 135088 213614 In-Street Bollard Damaged/Missing   open -77.07408600 38.89517800 1501 Wilson Blvd, Arlington VA 2025-07-16 22:23:00 2025-07-17 21:06:56.123000000 public QScend
146577 146577 239502 In-Street Bollard Damaged/Missing   open -77.10931365 38.90039908 2254 Military Rd, Arlington VA 2025-12-18 22:29:00 2025-12-20 06:06:49.477000000 public QScend
160881 160881 212762 In-Street Bollard Damaged/Missing   open -77.09034616 38.88886538 Clarendon Blvd, Arlington VA 2025-07-10 18:17:00 2025-07-11 21:07:59.887000000 public QScend
165621 165621 230623 In-Street Bollard Damaged/Missing   open -77.11633877 38.88676396 1238 N VERNON ST, Arlington VA 2025-10-10 15:51:00 2025-10-14 07:00:08.957000000 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]);