service_requests

Service requests from Arlington VA residents

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

7 rows where name = "Blocked Sidewalk, Street, or Bike Lane" 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 · 7 ✖

name 1

  • Blocked Sidewalk, Street, or Bike Lane · 7 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
124264 124264 213121 Blocked Sidewalk, Street, or Bike Lane   in progress -77.05459946 38.85412425 552 22nd St S, Arlington VA 2025-07-14 10:15:00 2025-07-29 16:08:55.540000000 public QScend
125070 125070 213327 Blocked Sidewalk, Street, or Bike Lane   in progress -77.05400484 38.85409853 506 22nd St S, Arlington VA 2025-07-15 10:28:00 2025-07-29 16:08:55.540000000 public QScend
133493 133493 209517 Blocked Sidewalk, Street, or Bike Lane   in progress -77.05475675 38.85408616 566 22nd St S, Arlington VA 2025-06-18 11:22:00 2025-07-29 16:08:55.540000000 public QScend
169205 169205 183893 Blocked Sidewalk, Street, or Bike Lane   in progress -77.08345196 38.84727301 Arlington VA 2024-11-11 14:29:00 2024-11-26 19:41:39.210000000 public QScend
170101 170101 195428 Blocked Sidewalk, Street, or Bike Lane   in progress -77.09392213 38.88705285 1221 N GARFIELD ST, Arlington VA 2025-02-20 11:58:00 2025-02-25 18:07:58.150000000 public QScend
174088 174088 239380 Blocked Sidewalk, Street, or Bike Lane   in progress -77.05419603 38.86469055   2025-12-18 06:44:00 2025-12-24 06:05:48.250000000 public QScend
175169 175169 208521 Blocked Sidewalk, Street, or Bike Lane   in progress -77.10145491 38.85389779 1379 S George Mason Dr, Arlington VA 2025-06-10 13:26:00 2025-09-16 06:11:52.140000000 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]);