service_requests

Service requests from Arlington VA residents

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

5 rows where name = "Litter in Park/Trail" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 5 ✖

name 1

  • Litter in Park/Trail · 5 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
130211 130211 204115 Litter in Park/Trail   open -77.14147800 38.88895300   2025-05-06 07:58:00 2025-05-07 06:06:52.257000000 public QScend
134850 134850 224788 Litter in Park/Trail   open -77.07496222 38.89108727 1597 Arlington Blvd, Arlington VA 2025-09-04 11:19:00 2025-09-05 06:11:52.117000000 public QScend
146420 146420 239755 Litter in Park/Trail   open -77.07331497 38.86390601 S Queen St, Arlington VA 2025-12-21 22:59:00 2025-12-24 06:05:48.250000000 public QScend
153006 153006 167062 Litter in Park/Trail   open -77.11721000 38.86509725 S Buchanan St, Arlington VA 2024-06-15 20:19:00 2024-06-16 20:31:38.850000000 public QScend
157658 157658 185638 Litter in Park/Trail   open -77.07024000 38.85051100 1414 24th St S, Arlington VA 2024-11-26 16:33:00 2024-11-28 19:36:46.733000000 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]);