service_requests

Service requests from Arlington VA residents

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

8 rows where name = "Flooding or Water Ponding in Street" 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 · 8 ✖

name 1

  • Flooding or Water Ponding in Street · 8 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
122911 122911 210634 Flooding or Water Ponding in Street   in progress -77.10528799 38.87313801 4211 2nd Rd N, Arlington VA 2025-06-25 17:53:00 2025-06-28 06:05:51.297000000 public QScend
127335 127335 212239 Flooding or Water Ponding in Street   in progress -77.08338079 38.89198215 2039 Wilson Blvd, Arlington VA 2025-07-07 17:47:00 2025-07-09 06:06:55.950000000 public QScend
145415 145415 237688 Flooding or Water Ponding in Street   in progress -77.05448448 38.85251617 517 24th St S, Arlington VA 2025-12-04 09:49:00 2025-12-06 06:05:52.173000000 public QScend
145838 145838 238802 Flooding or Water Ponding in Street   in progress -77.05430280 38.85338469 529 23Rd Street South, Arlington VA 2025-12-12 15:52:00 2025-12-13 07:00:09.997000000 public QScend
147619 147619 238978 Flooding or Water Ponding in Street   in progress -77.12102656 38.89076544 4669 17TH ST N, Arlington VA 2025-12-15 14:02:00 2025-12-17 03:00:13.003000000 public QScend
166606 166606 223983 Flooding or Water Ponding in Street   in progress -77.13889498 38.87387499 Wilson Blvd, Arlington VA 2025-08-31 09:57:00 2025-09-03 06:08:49.250000000 public QScend
172560 172560 229858 Flooding or Water Ponding in Street   in progress -77.10982118 38.85441824 1008 S Buchanan St, Arlington VA 2025-10-06 14:55:00 2025-10-09 06:07:51.530000000 public QScend
175276 175276 211911 Flooding or Water Ponding in Street   in progress -77.08884655 38.89264535 2500 Key Blvd, Arlington VA 2025-07-05 13:54:00 2025-07-08 06:10:57.910000000 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]);