service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
1,693 rows where name = "Street Surface Damage" and status = "closed"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 358 | 358 | 9591 | Street Surface Damage | closed | -77.08051234 | 38.89685884 | Langston Blvd, Arlington VA | 2021-01-10 12:01:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 534 | 534 | 9970 | Street Surface Damage | closed | -77.10818846 | 38.89046257 | N Quincy St, Arlington VA | 2021-01-13 16:56:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 738 | 738 | 9314 | Street Surface Damage | closed | -77.10544599 | 38.89325701 | 1728 N Nelson St, Arlington VA | 2021-01-07 10:25:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 851 | 851 | 10301 | Street Surface Damage | closed | -77.11966419 | 38.87130579 | 335 N EDISON ST, Arlington VA | 2021-01-17 23:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 929 | 929 | 8729 | Street Surface Damage | closed | -77.06267610 | 38.84752495 | 2701 S Inge St, Arlington VA | 2021-01-03 09:05:00 | 2021-05-31 14:00:38.500000000 | public | QScend | |
| 1029 | 1029 | 9522 | Street Surface Damage | closed | -77.11498099 | 38.89022401 | 4408 16th St N, Arlington VA | 2021-01-08 15:41:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1203 | 1203 | 9364 | Street Surface Damage | closed | -77.09244599 | 38.84886699 | 2123 S Pollard St, Arlington VA | 2021-01-07 13:30:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1529 | 1529 | 12885 | Street Surface Damage | closed | -77.10492516 | 38.88559943 | 1052 N Monroe St, Arlington VA | 2021-02-18 16:49:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1531 | 1531 | 12915 | Street Surface Damage | closed | -77.07076033 | 38.89794682 | N Lynn St, Arlington VA | 2021-02-19 12:18:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1652 | 1652 | 10656 | Street Surface Damage | closed | -77.10680988 | 38.90391921 | 2525 N Ridgeview Rd, Arlington VA | 2021-01-21 14:38:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1666 | 1666 | 11003 | Street Surface Damage | closed | -77.08722227 | 38.87908658 | 279 N BRYAN ST, Arlington VA | 2021-01-25 17:13:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1680 | 1680 | 10994 | Street Surface Damage | closed | -77.12590362 | 38.86449295 | 5714 2nd St S, Arlington VA | 2021-01-25 16:33:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1723 | 1723 | 11350 | Street Surface Damage | closed | -77.12192003 | 38.90386301 | 2419 N Woodrow St, Arlington VA | 2021-01-29 09:32:00 | 2021-05-10 18:00:55.110000000 | public | QScend | |
| 1784 | 1784 | 9622 | Street Surface Damage | closed | -77.11963328 | 38.87138872 | 335 N EDISON ST, Arlington VA | 2021-01-10 19:34:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1879 | 1879 | 10260 | Street Surface Damage | closed | -77.09679495 | 38.88443725 | 3193 10TH ST N, Arlington VA | 2021-01-17 07:33:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1959 | 1959 | 12223 | Street Surface Damage | closed | -77.13412903 | 38.89152300 | 5431 20th St N, Arlington VA | 2021-02-10 13:05:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 1975 | 1975 | 12539 | Street Surface Damage | closed | -77.11656098 | 38.88036199 | 824 N WAKEFIELD ST, Arlington VA | 2021-02-15 13:44:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2025 | 2025 | 12567 | Street Surface Damage | closed | -77.15811040 | 38.89455920 | 6505 26TH ST N, Arlington VA | 2021-02-15 15:14:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2072 | 2072 | 10842 | Street Surface Damage | closed | -77.10127398 | 38.87217799 | 44 N OAKLAND ST, Arlington VA | 2021-01-23 18:39:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2207 | 2207 | 11645 | Street Surface Damage | closed | -77.10481307 | 38.88935884 | 1416 N Monroe St, Arlington VA | 2021-02-03 08:43:00 | 2021-12-18 18:00:27.760000000 | public | QScend | |
| 2299 | 2299 | 11889 | Street Surface Damage | closed | -77.10813905 | 38.89074025 | 1607 N Quincy St, Arlington VA | 2021-02-05 15:15:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2454 | 2454 | 13545 | Street Surface Damage | closed | -77.10730996 | 38.90361700 | 4100 Nelly Custis Dr, Arlington VA | 2021-02-25 16:18:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2473 | 2473 | 12765 | Street Surface Damage | closed | -77.06411499 | 38.84677499 | 2800 S JOYCE ST, Arlington VA | 2021-02-17 08:40:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2681 | 2681 | 11371 | Street Surface Damage | closed | -77.12358200 | 38.91902398 | 4311 37th Rd N, Arlington VA | 2021-01-29 13:17:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2885 | 2885 | 13729 | Street Surface Damage | closed | -77.16382201 | 38.89603598 | 6642 Williamsburg Blvd, Arlington VA | 2021-02-28 18:00:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2940 | 2940 | 13888 | Street Surface Damage | closed | -77.10763956 | 38.90398944 | 4123 Nelly Custis Dr, Arlington VA | 2021-03-01 21:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2962 | 2962 | 14376 | Street Surface Damage | closed | -77.12425096 | 38.90564001 | 4617 26TH ST N, Arlington VA | 2021-03-05 17:52:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3101 | 3101 | 15123 | Street Surface Damage | closed | -77.12147765 | 38.89043576 | 4714 17TH ST N, Arlington VA | 2021-03-12 11:54:00 | 2021-03-20 10:00:49.027000000 | public | QScend | |
| 3182 | 3182 | 12778 | Street Surface Damage | closed | -77.08973403 | 38.85264899 | 1904 S Lorton St, Arlington VA | 2021-02-17 10:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3345 | 3345 | 14281 | Street Surface Damage | closed | -77.10956830 | 38.87972562 | 4100 Wilson Blvd, Arlington VA | 2021-03-04 18:48:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3403 | 3403 | 15124 | Street Surface Damage | closed | -77.08918426 | 38.88071724 | 2612 N Pershing Dr, Arlington VA | 2021-03-12 11:55:00 | 2021-03-20 12:00:46.100000000 | public | QScend | |
| 3452 | 3452 | 14468 | Street Surface Damage | closed | -77.08919390 | 38.88078488 | 2611 N Pershing Dr, Arlington VA | 2021-03-07 16:17:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3540 | 3540 | 13352 | Street Surface Damage | closed | -77.12921799 | 38.89394700 | 2014 N EDISON ST, Arlington VA | 2021-02-24 08:53:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3632 | 3632 | 14309 | Street Surface Damage | closed | -77.09332812 | 38.89856847 | Lorcom Ln, Arlington VA | 2021-03-05 10:43:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3688 | 3688 | 13797 | Street Surface Damage | closed | -77.10728749 | 38.90378216 | 4100 Nelly Custis Dr, Arlington VA | 2021-03-01 13:14:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3694 | 3694 | 13915 | Street Surface Damage | closed | -77.15816992 | 38.89432004 | 26TH ST N, Arlington VA | 2021-03-02 09:39:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3702 | 3702 | 15605 | Street Surface Damage | closed | -77.07940280 | 38.84471086 | 2711 S Cleveland St, Arlington VA | 2021-03-17 08:51:00 | 2021-11-27 16:01:00.190000000 | public | QScend | |
| 3818 | 3818 | 16990 | Street Surface Damage | closed | -77.12790698 | 38.87081409 | 5679 4th St N, Arlington VA | 2021-03-29 11:08:00 | 2021-04-14 14:00:55.487000000 | public | QScend | |
| 3874 | 3874 | 14275 | Street Surface Damage | closed | -77.10592401 | 38.90750599 | 4052 27TH ST N, Arlington VA | 2021-03-04 17:35:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3876 | 3876 | 14293 | Street Surface Damage | closed | -77.10952039 | 38.87965551 | 4100 Wilson Blvd, Arlington VA | 2021-03-05 08:22:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3967 | 3967 | 10633 | Street Surface Damage | closed | -77.09002195 | 38.86764702 | 6TH ST S, Arlington VA | 2021-01-21 13:31:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 4092 | 4092 | 14398 | Street Surface Damage | closed | -77.10911103 | 38.88052638 | 875 N Randolph St, Arlington VA | 2021-03-06 11:21:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 4218 | 4218 | 15426 | Street Surface Damage | closed | -77.12232222 | 38.89906047 | 4700 Old Dominion Dr, Arlington VA | 2021-03-15 16:48:00 | 2021-03-24 10:00:56.160000000 | public | QScend | |
| 4318 | 4318 | 11403 | Street Surface Damage | closed | -77.12472596 | 38.91849198 | 4316 37th Rd N, Arlington VA | 2021-01-29 16:07:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 4321 | 4321 | 11408 | Street Surface Damage | closed | -77.08485802 | 38.84818001 | 2402 S Kenmore St, Arlington VA | 2021-01-29 16:33:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 4508 | 4508 | 16845 | Street Surface Damage | closed | -77.13418100 | 38.92102902 | 4536 40th St N, Arlington VA | 2021-03-27 08:56:00 | 2021-04-05 18:00:45.330000000 | public | QScend | |
| 4568 | 4568 | 17016 | Street Surface Damage | closed | -77.08740393 | 38.85579188 | 3101 17th St S, Arlington VA | 2021-03-29 12:42:00 | 2021-04-03 18:00:43.270000000 | public | QScend | |
| 4582 | 4582 | 17267 | Street Surface Damage | closed | -77.10321498 | 38.90716501 | 2700 N Quincy St, Arlington VA | 2021-03-31 09:33:00 | 2021-04-14 14:00:55.487000000 | public | QScend | |
| 4672 | 4672 | 17545 | Street Surface Damage | closed | -77.09976097 | 38.86448801 | 3912 6TH ST S, Arlington VA | 2021-04-02 11:52:00 | 2021-04-07 16:00:46.887000000 | public | QScend | |
| 4749 | 4749 | 17272 | Street Surface Damage | closed | -77.10450540 | 38.90463754 | 2505 N Quincy St, Arlington VA | 2021-03-31 10:08:00 | 2021-04-14 14:00:55.487000000 | public | QScend | |
| 4791 | 4791 | 17620 | Street Surface Damage | closed | -77.08208697 | 38.89147602 | 2000 Clarendon Blvd, Arlington VA | 2021-04-02 19:08:00 | 2021-04-19 12:00:52.307000000 | public | QScend | |
| 4845 | 4845 | 18136 | Street Surface Damage | closed | -77.08383703 | 38.89968999 | 2137 N TROY ST, Arlington VA | 2021-04-07 13:10:00 | 2021-04-25 14:00:46.970000000 | public | QScend | |
| 4962 | 4962 | 12725 | Street Surface Damage | closed | -77.12548603 | 38.91392800 | 3443 N Venice St, Arlington VA | 2021-02-16 16:53:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 5033 | 5033 | 16398 | Street Surface Damage | closed | -77.10836097 | 38.87961102 | 4040 Wilson Blvd, Arlington VA | 2021-03-23 10:20:00 | 2021-03-29 10:01:17.090000000 | public | QScend | |
| 5068 | 5068 | 11160 | Street Surface Damage | closed | -77.13286202 | 38.88805901 | 5436 17TH ST N, Arlington VA | 2021-01-27 13:44:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 5257 | 5257 | 17907 | Street Surface Damage | closed | -77.12798501 | 38.87369700 | 5622 7TH ST N, Arlington VA | 2021-04-06 07:08:00 | 2021-04-19 12:00:52.307000000 | public | QScend | |
| 5263 | 5263 | 17269 | Street Surface Damage | closed | -77.10516388 | 38.90336272 | 2393 N Quincy St, Arlington VA | 2021-03-31 09:59:00 | 2021-04-14 14:00:55.487000000 | public | QScend | |
| 5606 | 5606 | 14189 | Street Surface Damage | closed | -77.12878993 | 38.90427003 | Old Dominion Dr, Arlington VA | 2021-03-04 09:25:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 5625 | 5625 | 13806 | Street Surface Damage | closed | -77.10778976 | 38.90386563 | 4124 Nelly Custis Dr, Arlington VA | 2021-03-01 13:55:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 5810 | 5810 | 17686 | Street Surface Damage | closed | -77.08525902 | 38.86318802 | 2601 Columbia Pike, Arlington VA | 2021-04-04 11:40:00 | 2021-04-10 14:00:51.090000000 | public | QScend | |
| 5877 | 5877 | 17273 | Street Surface Damage | closed | -77.09397504 | 38.89867812 | 2616 Lorcom Ln, Arlington VA | 2021-03-31 10:11:00 | 2021-04-14 12:04:45.327000000 | public | QScend | |
| 5884 | 5884 | 17400 | Street Surface Damage | closed | -77.09501991 | 38.89888005 | N Daniel St, Arlington VA | 2021-03-31 19:38:00 | 2021-04-14 12:04:45.327000000 | public | QScend | |
| 5889 | 5889 | 17513 | Street Surface Damage | closed | -77.05930504 | 38.84995098 | 2612 S Hayes St, Arlington VA | 2021-04-02 08:48:00 | 2021-04-07 14:00:43.640000000 | public | QScend | |
| 5963 | 5963 | 17868 | Street Surface Damage | closed | -77.07901931 | 38.89181607 | 1780 16th St N, Arlington VA | 2021-04-05 17:04:00 | 2021-04-19 12:00:52.307000000 | public | QScend | |
| 6013 | 6013 | 17944 | Street Surface Damage | closed | -77.06518136 | 38.85886529 | S Kent St, Arlington VA | 2021-04-06 11:06:00 | 2021-04-14 12:04:45.327000000 | public | QScend | |
| 6015 | 6015 | 17989 | Street Surface Damage | closed | -77.12681398 | 38.86435398 | 5724 2nd St S, Arlington VA | 2021-04-06 14:23:00 | 2021-04-12 16:00:51.927000000 | public | QScend | |
| 6062 | 6062 | 16116 | Street Surface Damage | closed | -77.13790717 | 38.89987623 | 5226 26TH RD N, Arlington VA | 2021-03-22 10:31:00 | 2021-03-28 12:00:45.163000000 | public | QScend | |
| 6336 | 6336 | 12914 | Street Surface Damage | closed | -77.07080593 | 38.89798993 | N Lynn St, Arlington VA | 2021-02-19 12:16:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 6458 | 6458 | 19588 | Street Surface Damage | closed | -77.10904996 | 38.87990002 | Wilson Blvd, Arlington VA | 2021-04-19 13:36:00 | 2021-05-02 12:00:49.410000000 | public | QScend | |
| 6507 | 6507 | 17460 | Street Surface Damage | closed | -77.14541164 | 38.87764423 | 953 N McKinley Rd, Arlington VA | 2021-04-01 14:03:00 | 2021-04-19 12:00:52.307000000 | public | QScend | |
| 6583 | 6583 | 19123 | Street Surface Damage | closed | -77.10131430 | 38.87265307 | 123 N OAKLAND ST, Arlington VA | 2021-04-14 16:30:00 | 2021-04-25 14:00:46.970000000 | public | QScend | |
| 6588 | 6588 | 19230 | Street Surface Damage | closed | -77.08728995 | 38.88066005 | N Pershing Dr, Arlington VA | 2021-04-15 13:45:00 | 2021-04-21 12:00:56.920000000 | public | QScend | |
| 6654 | 6654 | 17881 | Street Surface Damage | closed | -77.07566903 | 38.89149199 | 1523 FAIRFAX DR, Arlington VA | 2021-04-05 18:19:00 | 2021-05-04 12:00:56.797000000 | public | QScend | |
| 6783 | 6783 | 18746 | Street Surface Damage | closed | -77.07713703 | 38.89410098 | 1600 Wilson Blvd, Arlington VA | 2021-04-12 14:03:00 | 2021-04-20 10:01:16.647000000 | public | QScend | |
| 6966 | 6966 | 19165 | Street Surface Damage | closed | -77.08728995 | 38.88066005 | N Barton St, Arlington VA | 2021-04-15 08:01:00 | 2021-04-21 12:00:56.920000000 | public | QScend | |
| 7040 | 7040 | 21309 | Street Surface Damage | closed | -77.08464267 | 38.87581102 | 2330 WASHINGTON BLVD, Arlington VA | 2021-05-03 11:02:00 | 2021-05-15 12:01:08.057000000 | public | QScend | |
| 7101 | 7101 | 16827 | Street Surface Damage | closed | -77.14337402 | 38.91561699 | 3933 N Dumbarton St, Arlington VA | 2021-03-26 16:13:00 | 2021-04-04 18:00:41.337000000 | public | QScend | |
| 7228 | 7228 | 20258 | Street Surface Damage | closed | -77.12020437 | 38.90409657 | 4402 25th St N, Arlington VA | 2021-04-24 17:08:00 | 2021-05-09 14:01:09.980000000 | public | QScend | |
| 7250 | 7250 | 20199 | Street Surface Damage | closed | -77.08701402 | 38.89492002 | 1809 N Wayne St, Arlington VA | 2021-04-23 15:23:00 | 2021-05-05 12:00:58.287000000 | public | QScend | |
| 7327 | 7327 | 17867 | Street Surface Damage | closed | -77.11027598 | 38.84559901 | 1429 S Greenbrier St, Arlington VA | 2021-04-05 17:03:00 | 2021-04-12 14:00:54.827000000 | public | QScend | |
| 7499 | 7499 | 14647 | Street Surface Damage | closed | -77.10893238 | 38.90482839 | 2547 Military Rd, Arlington VA | 2021-03-08 19:59:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 7632 | 7632 | 21043 | Street Surface Damage | closed | -77.09782267 | 38.88994283 | 3161 Key Blvd, Arlington VA | 2021-04-30 13:29:00 | 2021-05-09 14:01:09.980000000 | public | QScend | |
| 7758 | 7758 | 22458 | Street Surface Damage | closed | -77.10908739 | 38.87988347 | 4102 Wilson Blvd, Arlington VA | 2021-05-11 11:40:00 | 2021-05-18 14:00:45.273000000 | public | QScend | |
| 7988 | 7988 | 15798 | Street Surface Damage | closed | -77.14670197 | 38.90493400 | 5534 32nd St N, Arlington VA | 2021-03-18 17:05:00 | 2021-03-28 12:00:45.163000000 | public | QScend | |
| 8026 | 8026 | 19517 | Street Surface Damage | closed | -77.09795791 | 38.87831604 | 3300 5th St N, Arlington VA | 2021-04-19 08:32:00 | 2021-04-27 16:00:48.823000000 | public | QScend | |
| 8111 | 8111 | 22596 | Street Surface Damage | closed | -77.09251134 | 38.88898057 | Wilson Blvd, Arlington VA | 2021-05-11 19:57:00 | 2021-05-18 14:00:45.273000000 | public | QScend | |
| 8310 | 8310 | 15818 | Street Surface Damage | closed | -77.10935617 | 38.90541074 | 2551 Military Rd, Arlington VA | 2021-03-19 07:15:00 | 2021-04-05 18:00:45.330000000 | public | QScend | |
| 8458 | 8458 | 23627 | Street Surface Damage | closed | -77.11883399 | 38.88973698 | 1535 N GLEBE RD, Arlington VA | 2021-05-19 13:29:00 | 2021-06-09 18:00:54.323000000 | public | QScend | |
| 8736 | 8736 | 24248 | Street Surface Damage | closed | -77.08822990 | 38.85961004 | 13th St S, Arlington VA | 2021-05-24 11:24:00 | 2021-05-30 14:00:43.617000000 | public | QScend | |
| 8808 | 8808 | 14648 | Street Surface Damage | closed | -77.09408367 | 38.89863311 | 2624 Lorcom Ln, Arlington VA | 2021-03-08 20:11:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 8918 | 8918 | 21110 | Street Surface Damage | closed | -77.08427104 | 38.89931201 | 2128 N TROY ST, Arlington VA | 2021-04-30 19:25:00 | 2021-05-08 10:01:07.487000000 | public | QScend | |
| 9263 | 9263 | 22638 | Street Surface Damage | closed | -77.13069999 | 38.87687001 | 863 N Kensington St, Arlington VA | 2021-05-12 09:51:00 | 2021-05-30 16:00:46.720000000 | public | QScend | |
| 9327 | 9327 | 22613 | Street Surface Damage | closed | -77.10969228 | 38.87941535 | 4150 Wilson Blvd, Arlington VA | 2021-05-12 05:06:00 | 2021-05-18 14:00:45.273000000 | public | QScend | |
| 9387 | 9387 | 22595 | Street Surface Damage | closed | -77.10961993 | 38.87993628 | 4121 Wilson Blvd, Arlington VA | 2021-05-11 19:53:00 | 2021-05-18 14:00:45.273000000 | public | QScend | |
| 9610 | 9610 | 25473 | Street Surface Damage | closed | -77.10854078 | 38.88241887 | 4038 N Fairfax Dr, Arlington VA | 2021-06-02 21:56:00 | 2021-06-19 14:00:50.623000000 | public | QScend | |
| 9630 | 9630 | 25610 | Street Surface Damage | closed | -77.07986819 | 38.88994766 | 1397 N Rolfe St, Arlington VA | 2021-06-03 22:36:00 | 2021-06-19 14:00:50.623000000 | public | QScend | |
| 9878 | 9878 | 26500 | Street Surface Damage | closed | -77.07551742 | 38.89906469 | Custis Trl, Arlington VA | 2021-06-10 18:30:00 | 2021-06-30 18:00:49.967000000 | public | QScend | |
| 10213 | 10213 | 24966 | Street Surface Damage | closed | -77.05434543 | 38.84607375 | 525S 31st St S, Arlington VA | 2021-05-29 13:04:00 | 2021-07-25 16:00:59.400000000 | public | QScend | |
| 10216 | 10216 | 25020 | Street Surface Damage | closed | -77.12761665 | 38.86818152 | 5625 N Carlin Springs Rd, Arlington VA | 2021-05-30 21:05:00 | 2021-06-13 16:00:55.643000000 | public | QScend | |
| 10558 | 10558 | 22605 | Street Surface Damage | closed | -77.10904996 | 38.87990002 | Wilson Blvd, Arlington VA | 2021-05-11 20:43:00 | 2021-05-18 14:00:45.273000000 | 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]);