service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
13 rows where name = "Public Art" and status = "in progress"
This data as json, CSV (advanced)
Suggested facets: address, created_at (date), updated_at (date)
| Link | rowid ▼ | service_request_id | name | description | status | longitude | latitude | address | created_at | updated_at | permission | source_system |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50609 | 50609 | 91420 | Public Art | in progress | -77.15810002 | 38.89881798 | 6522 29th St N, Arlington VA | 2022-10-16 23:52:00 | 2022-10-22 20:00:32.277000000 | public | QScend | |
| 54211 | 54211 | 94007 | Public Art | in progress | -77.08893901 | 38.87292301 | 21 S Fillmore St, Arlington VA | 2022-11-08 12:39:00 | 2022-11-13 16:00:23.917000000 | public | QScend | |
| 55536 | 55536 | 99621 | Public Art | in progress | -77.12521654 | 38.87951689 | 902 N Frederick St, Arlington VA | 2023-01-06 08:27:00 | 2023-01-16 16:00:28.020000000 | public | QScend | |
| 59174 | 59174 | 106636 | Public Art | in progress | -77.07347000 | 38.86431000 | 1105 S Queen St, Arlington VA | 2023-03-21 18:45:00 | 2023-03-28 12:00:43.333000000 | public | QScend | |
| 60939 | 60939 | 97406 | Public Art | in progress | -77.07964000 | 38.87238000 | Carpenter St, Arlington VA | 2022-12-14 13:48:00 | 2022-12-24 16:00:27.450000000 | public | QScend | |
| 61440 | 61440 | 109682 | Public Art | in progress | -77.08776000 | 38.84122000 | 2023-04-16 12:39:00 | 2023-04-30 20:00:41.987000000 | public | QScend | ||
| 85742 | 85742 | 138268 | Public Art | in progress | -77.10190000 | 38.88184000 | 3550 Wilson Blvd, Arlington VA | 2023-11-03 07:30:00 | 2023-11-05 01:31:54.993000000 | public | QScend | |
| 89100 | 89100 | 157610 | Public Art | in progress | -77.05859110 | 38.84741950 | 2800 Fort Scott Dr, Arlington VA | 2024-04-12 16:28:00 | 2024-04-17 20:31:58.137000000 | public | QScend | |
| 90128 | 90128 | 162112 | Public Art | in progress | -77.12722152 | 38.89386565 | 1945 N Dinwiddie St, Arlington VA | 2024-05-11 17:30:00 | 2024-05-14 20:32:12.907000000 | public | QScend | |
| 95487 | 95487 | 154920 | Public Art | in progress | -77.05860000 | 38.84748000 | 2800 Fort Scott Dr, Arlington VA | 2024-03-19 18:42:00 | 2024-03-21 20:31:44.953000000 | public | QScend | |
| 106215 | 106215 | 159346 | Public Art | in progress | -77.11836234 | 38.92867917 | George Washington Memorial Pkwy N, Arlington VA | 2024-04-27 20:32:00 | 2024-05-01 20:31:38.890000000 | public | QScend | |
| 117529 | 117529 | 199274 | Public Art | in progress | -77.11843751 | 38.88215168 | Bluemont Junction Trl, Arlington VA | 2025-03-25 16:11:00 | 2025-03-27 06:05:59.740000000 | public | QScend | |
| 135652 | 135652 | 125590 | Public Art | in progress | -77.08579403 | 38.89031198 | 2100 Clarendon Blvd, Arlington VA | 2023-08-02 14:54:00 | 2023-08-08 16:01:09.350000000 | public | QScend |
Advanced export
JSON shape: default, array, newline-delimited
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]);