service_requests

Service requests from Arlington VA residents

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

6 rows where name = "Commercial" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 6 ✖

name 1

  • Commercial · 6 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
120469 120469 206398 Commercial   open -77.08832797 38.85311301 3500 19th St S, Arlington VA 2025-05-25 15:22:00 2025-05-26 16:03:50.573000000 public QScend
130727 130727 215380 Commercial   open -77.07058538 38.89724152 1919 North Lynn Street, Arlington VA 2025-07-30 14:13:00 2025-08-01 16:07:55.300000000 public QScend
133046 133046 223911 Commercial   open -77.16308599 38.88995818 25th St N, Arlington VA 2025-08-29 22:11:00 2025-09-03 06:08:49.250000000 public QScend
139819 139819 227723 Commercial   open -77.07830912 38.88977769 1721 FAIRFAX DR, Arlington VA 2025-09-22 13:40:00 2025-09-23 06:10:52.503000000 public QScend
142981 142981 231472 Commercial   open -77.07141422 38.89191449 N Meade St, Arlington VA 2025-10-17 17:23:00 2025-10-19 06:01:45.597000000 public QScend
165322 165322 229087 Commercial   open -77.11088650 38.88700990 1301 N Stafford St, Arlington VA 2025-09-30 17:19:00 2025-10-02 06:06:52.660000000 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]);