service_requests

Service requests from Arlington VA residents

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

7 rows where name = "Suggest a Parking Corral" and status = "open"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 1

  • open · 7 ✖

name 1

  • Suggest a Parking Corral · 7 ✖
Link rowid ▼ service_request_id name description status longitude latitude address created_at updated_at permission source_system
80670 80670 132603 Suggest a Parking Corral   open -77.12270260 38.87619033 N Bluemont Dr, Arlington VA 2023-09-22 17:11:00 2023-09-27 20:00:48.963000000 public QScend
100686 100686 164609 Suggest a Parking Corral   open -77.08190282 38.87167128 110 S Courthouse Rd, Arlington VA 2024-05-31 15:08:00 2024-06-01 20:31:56.687000000 public QScend
107513 107513 176157 Suggest a Parking Corral   open -77.10353450 38.84102251 4847 28th St S, Arlington VA 2024-09-02 19:33:00 2024-09-03 20:32:08.580000000 public QScend
117766 117766 177664 Suggest a Parking Corral   open -77.07072742 38.89613303 1735 N Lynn St, Arlington VA 2024-09-13 15:39:00 2024-09-14 20:31:41.313000000 public QScend
117793 117793 177684 Suggest a Parking Corral   open -77.11049287 38.88124397 900 N Stafford St, Arlington VA 2024-09-13 17:46:00 2024-09-14 20:31:41.313000000 public QScend
119000 119000 199438 Suggest a Parking Corral   open -77.11615352 38.88186992 950 N GLEBE RD, Arlington VA 2025-03-26 20:09:00 2025-04-03 06:05:50.837000000 public QScend
161242 161242 207670 Suggest a Parking Corral   open -77.08226701 38.89198698 2001 Clarendon Blvd, Arlington VA 2025-06-03 22:55:00 2025-06-17 06:08:54.310000000 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]);