service_requests

Service requests from Arlington VA residents

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

11 rows where name = "Pothole" and status = "in progress"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • in progress · 11 ✖

name 1

  • Pothole · 11 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
124318 124318 211815 Pothole   in progress -77.08323227 38.89205088 2039 Wilson Blvd, Arlington VA 2025-07-03 21:18:00 2025-07-09 06:06:55.950000000 public QScend
134997 134997 211975 Pothole   in progress -77.08308912 38.89197707 2026 Wilson Blvd, Arlington VA 2025-07-06 12:45:00 2025-07-09 06:06:55.950000000 public QScend
141129 141129 238156 Pothole   in progress -77.06693657 38.85318256 1201 23RD ST S, Arlington VA 2025-12-08 17:41:00 2025-12-16 06:05:50.120000000 public QScend
147603 147603 238727 Pothole   in progress -77.12381482 38.89752687 4753 Langston Blvd, Arlington VA 2025-12-12 09:48:00 2025-12-13 06:06:48.560000000 public QScend
160658 160658 211857 Pothole   in progress -77.08316670 38.89205680 2025 Wilson Blvd, Arlington VA 2025-07-04 14:18:00 2025-07-09 06:06:55.950000000 public QScend
167498 167498 208815 Pothole   in progress -77.06493380 38.86073680 1602 South Joyce Street, Arlington VA 2025-06-12 12:13:00 2025-06-28 06:05:51.297000000 public QScend
168521 168521 228996 Pothole   in progress -77.10871493 38.87743388 5th Rd N, Arlington VA 2025-09-30 11:47:00 2025-10-16 06:05:48.633000000 public QScend
170423 170423 204528 Pothole   in progress -77.08641003 38.86156436 2814 11th St S, Arlington VA 2025-05-09 09:14:00 2025-05-14 16:07:53.127000000 public QScend
170473 170473 208755 Pothole   in progress -77.11096872 38.89710812 4110 Cherry Hill Rd, Arlington VA 2025-06-12 00:46:00 2025-08-27 06:09:53.293000000 public QScend
172035 172035 219538 Pothole   in progress -77.11605237 38.86746579 N Park Dr, Arlington VA 2025-08-10 14:22:00 2025-08-12 06:19:01.950000000 public QScend
173052 173052 231663 Pothole   in progress -77.08874583 38.83351575 3416 S Utah St, Arlington VA 2025-10-20 11:04:00 2025-10-24 06:06:50.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]);