service_requests

Service requests from Arlington VA residents

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

5 rows where name = "Flooding, Runoff or Ponding in Yard" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 5 ✖

name 1

  • Flooding, Runoff or Ponding in Yard · 5 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
167344 167344 77181 Flooding, Runoff or Ponding in Yard   open -77.08967804 38.85179802 Arlington VA (Private) 2022-07-07 11:35:00 2022-07-19 12:00:40.790000000 public QScend
168895 168895 145055 Flooding, Runoff or Ponding in Yard   open -77.11917597 38.92684799 4104 40th St N, Arlington VA 2023-12-29 08:11:00 2024-01-03 19:32:06.410000000 public QScend
169058 169058 199454 Flooding, Runoff or Ponding in Yard   open -77.08833997 38.88736073 Arlington VA (Private) 2025-03-27 08:16:00 2025-04-02 08:00:06.033000000 public QScend
170580 170580 69670 Flooding, Runoff or Ponding in Yard   open -77.14982297 38.90784500 5340 36TH ST N, Arlington VA 2022-05-23 14:35:00 2025-04-29 06:08:54.403000000 public QScend
175938 175938 149029 Flooding, Runoff or Ponding in Yard   open -77.13508398 38.89874200 Arlington VA (Private) 2024-01-28 17:25:00 2024-01-30 19:32:04.033000000 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]);