service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
47 rows where name = "Streetlight Issue" and status = "open"
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| Link | rowid ▼ | service_request_id | name | description | status | longitude | latitude | address | created_at | updated_at | permission | source_system |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123904 | 123904 | 206665 | Streetlight Issue | open | -77.12920098 | 38.90976198 | 3140 N ABINGDON ST, Arlington VA | 2025-05-27 17:05:00 | 2025-05-28 21:06:54.247000000 | public | QScend | |
| 126197 | 126197 | 210955 | Streetlight Issue | open | -77.11118399 | 38.85396600 | 4910 10th St S, Arlington VA | 2025-06-27 18:13:00 | 2025-06-28 21:01:54.680000000 | public | QScend | |
| 126574 | 126574 | 215034 | Streetlight Issue | open | -77.08262560 | 38.86831990 | 2200 6Th Street South, Arlington VA | 2025-07-28 12:36:00 | 2025-07-29 16:08:55.540000000 | public | QScend | |
| 127900 | 127900 | 215571 | Streetlight Issue | open | -77.08548390 | 38.86156386 | 2706 11th St S, Arlington VA | 2025-07-31 16:17:00 | 2025-08-01 16:07:55.300000000 | public | QScend | |
| 132938 | 132938 | 216929 | Streetlight Issue | open | -77.07149147 | 38.89195630 | Arlington Blvd, Arlington VA | 2025-08-05 17:42:00 | 2025-08-07 18:25:07.840000000 | public | QScend | |
| 138634 | 138634 | 231641 | Streetlight Issue | open | -77.09182607 | 38.86136386 | 3277 Columbia Pike, Arlington VA | 2025-10-20 09:34:00 | 2025-10-21 06:09:51.300000000 | public | QScend | |
| 138644 | 138644 | 231872 | Streetlight Issue | open | -77.14666526 | 38.89589429 | 5833 25th Rd N, Arlington VA | 2025-10-21 14:29:00 | 2025-10-22 06:08:49.053000000 | public | QScend | |
| 138742 | 138742 | 234456 | Streetlight Issue | open | -77.10451205 | 38.88167028 | 3807 Wilson Blvd, Arlington VA | 2025-11-10 20:48:00 | 2025-11-13 06:06:48.993000000 | public | QScend | |
| 140777 | 140777 | 229263 | Streetlight Issue | open | -77.13910650 | 38.90231060 | 5201 28Th Street North, Arlington VA | 2025-10-01 17:26:00 | 2025-10-02 07:00:13.553000000 | public | QScend | |
| 141490 | 141490 | 230729 | Streetlight Issue | open | -77.06289593 | 38.86481733 | 1101 S JOYCE ST, Arlington VA | 2025-10-12 14:59:00 | 2025-10-14 06:06:48.137000000 | public | QScend | |
| 141897 | 141897 | 239042 | Streetlight Issue | open | -77.10923080 | 38.85325843 | 1201 S Columbus St, Arlington VA | 2025-12-15 19:10:00 | 2025-12-16 11:00:11.200000000 | public | QScend | |
| 141957 | 141957 | 239795 | Streetlight Issue | open | -77.06229981 | 38.86332456 | 1201 S JOYCE ST, Arlington VA | 2025-12-22 10:29:00 | 2025-12-23 06:06:48.260000000 | public | QScend | |
| 141960 | 141960 | 239628 | Streetlight Issue | open | -77.10412369 | 38.89458361 | 1999 N Monroe St, Arlington VA | 2025-12-19 17:42:00 | 2025-12-20 07:00:08.797000000 | public | QScend | |
| 141991 | 141991 | 239692 | Streetlight Issue | open | -77.09156087 | 38.88090504 | 7TH ST N, Arlington VA | 2025-12-21 10:01:00 | 2025-12-22 06:01:47.070000000 | public | QScend | |
| 142026 | 142026 | 240271 | Streetlight Issue | open | -77.14808036 | 38.89318387 | 6100 Langston Blvd, Arlington VA | 2025-12-27 08:50:00 | 2025-12-28 06:02:49.593000000 | public | QScend | |
| 142149 | 142149 | 237974 | Streetlight Issue | open | -77.07849329 | 38.89349893 | N Quinn St, Arlington VA | 2025-12-06 21:11:00 | 2025-12-08 06:00:10.190000000 | public | QScend | |
| 142686 | 142686 | 230867 | Streetlight Issue | open | -77.11416728 | 38.88391177 | 4407 11th St N, Arlington VA | 2025-10-13 19:34:00 | 2025-10-14 11:00:09.973000000 | public | QScend | |
| 143131 | 143131 | 239993 | Streetlight Issue | open | -77.05408211 | 38.86178390 | 1350 S Eads St, Arlington VA | 2025-12-23 13:57:00 | 2025-12-24 06:05:48.250000000 | public | QScend | |
| 143354 | 143354 | 232430 | Streetlight Issue | open | -77.07085124 | 38.89638646 | N Lynn St, Arlington VA | 2025-10-25 17:06:00 | 2025-10-26 07:00:08.830000000 | public | QScend | |
| 144426 | 144426 | 235581 | Streetlight Issue | open | -77.07360505 | 38.89835187 | 1569 N Colonial Ter, Arlington VA | 2025-11-18 19:00:00 | 2025-11-19 11:00:15.290000000 | public | QScend | |
| 144668 | 144668 | 229929 | Streetlight Issue | open | -77.07077762 | 38.89716758 | 1919 North Lynn Street, Arlington VA | 2025-10-06 21:06:00 | 2025-10-08 06:06:51.410000000 | public | QScend | |
| 144994 | 144994 | 234209 | Streetlight Issue | open | -77.11314209 | 38.88372197 | 1050 N Taylor St, Arlington VA | 2025-11-07 18:51:00 | 2025-11-08 11:00:07.793000000 | public | QScend | |
| 145108 | 145108 | 237390 | Streetlight Issue | open | -77.08428611 | 38.86363396 | 930 S Barton St, Arlington VA | 2025-12-02 17:41:00 | 2025-12-03 07:00:13.713000000 | public | QScend | |
| 145212 | 145212 | 231041 | Streetlight Issue | open | -77.06273458 | 38.86548091 | 1047 S JOYCE ST, Arlington VA | 2025-10-14 23:02:00 | 2025-10-16 06:05:48.633000000 | public | QScend | |
| 145847 | 145847 | 238517 | Streetlight Issue | open | -77.14398003 | 38.89474299 | N LEXINGTON ST, Arlington VA | 2025-12-10 20:13:00 | 2025-12-11 11:00:14.107000000 | public | QScend | |
| 145906 | 145906 | 239376 | Streetlight Issue | open | -77.07366322 | 38.89826050 | 1569 N Colonial Ter, Arlington VA | 2025-12-17 22:48:00 | 2025-12-19 06:04:50.187000000 | public | QScend | |
| 146650 | 146650 | 240119 | Streetlight Issue | open | -77.09951898 | 38.89438001 | KIRKWOOD RD, Arlington VA | 2025-12-24 14:29:00 | 2025-12-25 07:00:07.990000000 | public | QScend | |
| 146666 | 146666 | 240381 | Streetlight Issue | open | -77.14485860 | 38.91266237 | 5109 38th St N, Arlington VA | 2025-12-28 08:47:00 | 2025-12-28 23:00:07.743000000 | public | QScend | |
| 146810 | 146810 | 234747 | Streetlight Issue | open | -77.06945170 | 38.86711571 | Columbia Pike, Arlington VA | 2025-11-12 19:32:00 | 2025-11-14 06:05:49.767000000 | public | QScend | |
| 147086 | 147086 | 235588 | Streetlight Issue | open | -77.14180309 | 38.88625119 | 1644 N McKinley Rd, Arlington VA | 2025-11-18 19:59:00 | 2025-11-20 06:07:53.127000000 | public | QScend | |
| 147551 | 147551 | 238587 | Streetlight Issue | open | -77.07148637 | 38.86625173 | 1554 Columbia Pike, Arlington VA | 2025-12-11 11:04:00 | 2025-12-12 03:00:11.770000000 | public | QScend | |
| 147754 | 147754 | 239741 | Streetlight Issue | open | -77.09136397 | 38.88062644 | 609 N Edgewood St, Arlington VA | 2025-12-21 17:25:00 | 2025-12-22 07:00:08.693000000 | public | QScend | |
| 148061 | 148061 | 240041 | Streetlight Issue | open | -77.13684200 | 38.90970402 | Old Dominion Dr, Arlington VA | 2025-12-23 18:08:00 | 2025-12-24 11:00:10.337000000 | public | QScend | |
| 148248 | 148248 | 240144 | Streetlight Issue | open | -77.13592400 | 38.88051200 | 2025-12-24 19:24:00 | 2025-12-26 06:00:08.863000000 | public | QScend | ||
| 148459 | 148459 | 237123 | Streetlight Issue | open | -77.10640832 | 38.88123081 | 3832 9th St N, Arlington VA | 2025-12-01 12:09:00 | 2025-12-02 06:07:50.610000000 | public | QScend | |
| 148738 | 148738 | 239079 | Streetlight Issue | open | -77.08219398 | 38.89624330 | 1802 Langston Blvd, Arlington VA | 2025-12-16 07:59:00 | 2025-12-16 23:00:13.167000000 | public | QScend | |
| 157719 | 157719 | 194145 | Streetlight Issue | open | -77.08026684 | 38.89303431 | 1836 Wilson Blvd, Arlington VA | 2025-02-07 16:04:00 | 2025-02-08 18:03:52.267000000 | public | QScend | |
| 158801 | 158801 | 193187 | Streetlight Issue | open | -77.08479331 | 38.89159800 | 2057 Wilson Blvd, Arlington VA | 2025-01-30 22:06:00 | 2025-01-31 18:05:58.323000000 | public | QScend | |
| 164156 | 164156 | 229714 | Streetlight Issue | open | -77.13811170 | 38.91016400 | 4913 Old Dominion Dr, Arlington VA | 2025-10-05 21:16:00 | 2025-10-06 11:00:16.140000000 | public | QScend | |
| 164240 | 164240 | 230304 | Streetlight Issue | open | -77.09399069 | 38.89805087 | 2883 Spout Run Pkwy, Arlington VA | 2025-10-08 19:41:00 | 2025-10-09 11:00:15.377000000 | public | QScend | |
| 164777 | 164777 | 232651 | Streetlight Issue | open | -77.05448140 | 38.85725252 | 18th St S, Arlington VA | 2025-10-27 20:41:00 | 2025-10-29 06:07:48.850000000 | public | QScend | |
| 165463 | 165463 | 229743 | Streetlight Issue | open | -77.11171029 | 38.87717377 | 4300 N Carlin Springs Rd, Arlington VA | 2025-10-06 09:06:00 | 2025-10-06 23:00:19.947000000 | public | QScend | |
| 165696 | 165696 | 237859 | Streetlight Issue | open | -77.11890456 | 38.87509606 | 5012 6th St N, Arlington VA | 2025-12-05 12:24:00 | 2025-12-06 06:05:52.173000000 | public | QScend | |
| 166036 | 166036 | 235962 | Streetlight Issue | open | -77.06305351 | 38.84916852 | 2550 S JOYCE ST, Arlington VA | 2025-11-21 09:40:00 | 2025-11-22 06:06:48.147000000 | public | QScend | |
| 166252 | 166252 | 238944 | Streetlight Issue | open | -77.10908072 | 38.85288884 | 1208 S Columbus St, Arlington VA | 2025-12-15 12:01:00 | 2025-12-16 06:05:50.120000000 | public | QScend | |
| 166273 | 166273 | 239512 | Streetlight Issue | open | -77.10385293 | 38.89443986 | 1905 N Monroe St, Arlington VA | 2025-12-19 08:14:00 | 2025-12-20 06:06:49.477000000 | public | QScend | |
| 166298 | 166298 | 239203 | Streetlight Issue | open | -77.08951612 | 38.87359220 | 4 N FILLMORE ST, Arlington VA | 2025-12-16 19:49:00 | 2025-12-18 06:06:47.803000000 | 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]);