service_requests
Data source: Arlington County Open Data Portal · About: DES - Environmental Services
176,617 rows where status = "closed"
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
name >30
- Metal, E-Waste, & Battery Collection 44,122
- Missed Service - Missed Collection 41,625
- Cart Services 33,343
- Signal Maintenance 5,103
- Transportation/Safety Investigation 3,719
- Streetlight Issue 3,554
- Tree Inspection/Maintenance 3,468
- Pothole 3,324
- Traffic Sign Damaged/Missing 3,250
- Concrete/Sidewalk Repair 2,849
- General Inquiry 2,670
- Fallen Trees or Limbs 2,549
- Illegal Dumping & Litter 2,185
- General Park Maintenance 1,751
- Street Surface Damage 1,693
- Parking Sign Damaged/Missing 1,681
- Single Family Voluntary Residential Credit 1,364
- No Water 1,287
- Blocked Sidewalk, Street, or Bike Lane 1,217
- Low Water Pressure 1,097
- Mowing 919
- Utility Cover Damaged/Missing 853
- Graffiti on County Building/Grounds 851
- Graffiti on Park Building/Trail/Park Grounds 831
- Litter in Park/Trail 746
- Signal Analysis 675
- General Trail Maintenance 664
- Lime - Parking 655
- In-Street Bollard Damaged/Missing 637
- Flooding or Water Ponding in Street 602
- …
status 1
- closed · 176,617 ✖
| Link | rowid ▼ | service_request_id | name | description | status | longitude | latitude | address | created_at | updated_at | permission | source_system |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 8662 | Concrete/Sidewalk Repair | closed | -77.08914101 | 38.86881500 | 2909 5th St S, Arlington VA | 2021-01-01 00:25:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 2 | 2 | 8671 | Cart Services | closed | -77.09141540 | 38.84834717 | Arlington VA (Private) | 2021-01-01 15:06:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 3 | 3 | 8678 | Metal, E-Waste, & Battery Collection | closed | -77.15860997 | 38.89626502 | Arlington VA (Private) | 2021-01-01 19:32:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 4 | 4 | 8685 | Cart Services | closed | -77.07493997 | 38.89754100 | Arlington VA (Private) | 2021-01-02 08:29:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 5 | 5 | 8705 | Metal, E-Waste, & Battery Collection | closed | -77.10548396 | 38.89478302 | Arlington VA (Private) | 2021-01-02 12:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 6 | 6 | 8719 | Metal, E-Waste, & Battery Collection | closed | -77.14524503 | 38.91347399 | Arlington VA (Private) | 2021-01-02 16:48:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 7 | 7 | 8728 | Missed Service - Missed Collection | closed | -77.05745004 | 38.85349900 | Arlington VA (Private) | 2021-01-03 08:54:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 8 | 8 | 8735 | Cart Services | closed | -77.12939602 | 38.87322799 | Arlington VA (Private) | 2021-01-03 10:34:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 9 | 9 | 8737 | Cart Services | closed | -77.08566897 | 38.87059100 | Arlington VA (Private) | 2021-01-03 11:21:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 10 | 10 | 8753 | Cart Services | closed | -77.11406996 | 38.87635800 | Arlington VA (Private) | 2021-01-03 13:44:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 11 | 11 | 8769 | Metal, E-Waste, & Battery Collection | closed | -77.11524603 | 38.88482800 | Arlington VA (Private) | 2021-01-03 16:54:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 12 | 12 | 8771 | Missed Service - Missed Collection | closed | -77.14388900 | 38.91260202 | Arlington VA (Private) | 2021-01-03 17:07:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 13 | 13 | 8778 | Metal, E-Waste, & Battery Collection | closed | -77.07325403 | 38.88802900 | Arlington VA (Private) | 2021-01-03 19:04:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 14 | 14 | 8787 | Pothole | closed | -77.11167360 | 38.89870565 | 4222 Old Dominion Dr, Arlington VA | 2021-01-03 22:31:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 15 | 15 | 8677 | Metal, E-Waste, & Battery Collection | closed | -77.12347002 | 38.89879300 | Arlington VA (Private) | 2021-01-01 17:20:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 16 | 16 | 8688 | Cart Services | closed | -77.12476603 | 38.89487098 | Arlington VA (Private) | 2021-01-02 09:19:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 17 | 17 | 8730 | Metal, E-Waste, & Battery Collection | closed | -77.14291402 | 38.90710001 | Arlington VA (Private) | 2021-01-03 09:06:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 18 | 18 | 8669 | Metal, E-Waste, & Battery Collection | closed | -77.14021899 | 38.87656399 | Arlington VA (Private) | 2021-01-01 12:29:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 19 | 19 | 8722 | Metal, E-Waste, & Battery Collection | closed | -77.09198398 | 38.87684599 | Arlington VA (Private) | 2021-01-02 19:58:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 20 | 20 | 8736 | Missed Service - Missed Collection | closed | -77.06160000 | 38.85646699 | Arlington VA (Private) | 2021-01-03 10:39:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 21 | 21 | 8744 | General Park Maintenance | closed | -77.09590105 | 38.85266924 | 1724 S Quincy St, Arlington VA | 2021-01-03 12:47:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 22 | 22 | 8696 | Metal, E-Waste, & Battery Collection | closed | -77.14734101 | 38.90458301 | Arlington VA (Private) | 2021-01-02 10:30:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 23 | 23 | 8747 | Missed Service - Missed Collection | closed | -77.09411143 | 38.86625864 | Arlington VA (Private) | 2021-01-03 13:14:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 24 | 24 | 8762 | Metal, E-Waste, & Battery Collection | closed | -77.06160000 | 38.85646699 | Arlington VA (Private) | 2021-01-03 15:43:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 25 | 25 | 8703 | Illegal Dumping & Litter | closed | -77.10943485 | 38.90052997 | Arlington VA (Private) | 2021-01-02 12:14:00 | 2021-12-29 14:00:25.593000000 | public | QScend | |
| 26 | 26 | 8704 | Water Fountain Damaged | closed | -77.08536810 | 38.87310940 | 101 S Barton St, Arlington VA | 2021-01-02 12:15:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 27 | 27 | 8709 | Pothole | closed | -77.04829096 | 38.86649379 | Long Bridge Dr, Arlington VA | 2021-01-02 13:46:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 28 | 28 | 8780 | Cart Services | closed | -77.09540598 | 38.88299999 | Arlington VA (Private) | 2021-01-03 19:14:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 29 | 29 | 8754 | Metal, E-Waste, & Battery Collection | closed | -77.14868697 | 38.89416900 | Arlington VA (Private) | 2021-01-03 14:06:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 30 | 30 | 8772 | Missed Service - Missed Collection | closed | -77.06672403 | 38.84605600 | Arlington VA (Private) | 2021-01-03 17:10:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 31 | 31 | 8795 | Metal, E-Waste, & Battery Collection | closed | -77.15173798 | 38.89553399 | Arlington VA (Private) | 2021-01-04 00:17:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 32 | 32 | 8822 | Metal, E-Waste, & Battery Collection | closed | -77.12954002 | 38.88014100 | Arlington VA (Private) | 2021-01-04 10:15:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 33 | 33 | 8838 | Missed Service - Missed Collection | closed | -77.13045901 | 38.89204901 | Arlington VA (Private) | 2021-01-04 11:01:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 34 | 34 | 8785 | Metal, E-Waste, & Battery Collection | closed | -77.13334096 | 38.89769300 | Arlington VA (Private) | 2021-01-03 21:45:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 35 | 35 | 8796 | Missed Service - Missed Collection | closed | -77.10929999 | 38.85400401 | Arlington VA (Private) | 2021-01-04 00:56:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 36 | 36 | 8803 | Missed Service - Missed Collection | closed | -77.05772497 | 38.85376701 | Arlington VA (Private) | 2021-01-04 08:00:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 37 | 37 | 8830 | Metal, E-Waste, & Battery Collection | closed | -77.13455701 | 38.90872799 | Arlington VA (Private) | 2021-01-04 10:46:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 38 | 38 | 8786 | Pothole | closed | -77.11161996 | 38.89858597 | 4149 21st Rd N, Arlington VA | 2021-01-03 22:29:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 39 | 39 | 8837 | Missed Service - Missed Collection | closed | -77.15838601 | 38.88912699 | Arlington VA (Private) | 2021-01-04 11:00:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 40 | 40 | 8839 | Metal, E-Waste, & Battery Collection | closed | -77.11494897 | 38.90225301 | Arlington VA (Private) | 2021-01-04 11:04:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 41 | 41 | 8855 | Metal, E-Waste, & Battery Collection | closed | -77.10630799 | 38.90889102 | Arlington VA (Private) | 2021-01-04 11:50:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 42 | 42 | 8794 | Streetlight Issue | closed | -77.10726302 | 38.90926900 | 3838 26TH ST N, Arlington VA | 2021-01-04 00:12:00 | 2021-11-28 18:00:48.780000000 | public | QScend | |
| 43 | 43 | 8805 | Metal, E-Waste, & Battery Collection | closed | -77.13098003 | 38.89710099 | Arlington VA (Private) | 2021-01-04 08:09:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 44 | 44 | 8871 | Metal, E-Waste, & Battery Collection | closed | -77.11131299 | 38.88440899 | Arlington VA (Private) | 2021-01-04 12:48:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 45 | 45 | 8878 | Missed Service - Missed Collection | closed | -77.08592404 | 38.85447499 | Arlington VA (Private) | 2021-01-04 13:00:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 46 | 46 | 8889 | Metal, E-Waste, & Battery Collection | closed | -77.13136501 | 38.87402900 | Arlington VA (Private) | 2021-01-04 13:17:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 47 | 47 | 8894 | Metal, E-Waste, & Battery Collection | closed | -77.14117503 | 38.91426801 | Arlington VA (Private) | 2021-01-04 13:21:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 48 | 48 | 8919 | Cart Services | closed | -77.10527098 | 38.89921201 | Arlington VA (Private) | 2021-01-04 14:27:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 49 | 49 | 8946 | Cart Services | closed | -77.09021004 | 38.84887902 | Arlington VA (Private) | 2021-01-04 16:17:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 50 | 50 | 8978 | Metal, E-Waste, & Battery Collection | closed | -77.12137303 | 38.88080301 | Arlington VA (Private) | 2021-01-04 19:58:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 51 | 51 | 8980 | Missed Service - Missed Collection | closed | -77.13759000 | 38.90084900 | Arlington VA (Private) | 2021-01-04 20:34:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 52 | 52 | 8987 | Missed Service - Missed Collection | closed | -77.14337402 | 38.91561699 | Arlington VA (Private) | 2021-01-04 23:26:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 53 | 53 | 8819 | Missed Service - Missed Collection | closed | -77.12946903 | 38.91144402 | Arlington VA (Private) | 2021-01-04 09:51:00 | 2021-05-02 16:00:49.863000000 | public | QScend | |
| 54 | 54 | 8821 | Concrete/Sidewalk Repair | closed | -77.10434117 | 38.88522903 | 1036 N Monroe St, Arlington VA | 2021-01-04 10:15:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 55 | 55 | 8847 | Missed Service - Missed Collection | closed | -77.08831102 | 38.84573884 | Arlington VA (Private) | 2021-01-04 11:29:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 56 | 56 | 8835 | Cart Services | closed | -77.13391596 | 38.90586599 | Arlington VA (Private) | 2021-01-04 10:51:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 57 | 57 | 8877 | Cart Services | closed | -77.11158196 | 38.85068398 | Arlington VA (Private) | 2021-01-04 12:56:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 58 | 58 | 8994 | Missed Service - Missed Collection | closed | -77.13681602 | 38.90272600 | Arlington VA (Private) | 2021-01-05 08:05:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 59 | 59 | 8861 | Streetlight Issue | closed | -77.05156932 | 38.86288524 | 12th St S, Arlington VA | 2021-01-04 12:23:00 | 2021-11-28 18:00:48.780000000 | public | QScend | |
| 60 | 60 | 8862 | Metal, E-Waste, & Battery Collection | closed | -77.11018101 | 38.88502799 | Arlington VA (Private) | 2021-01-04 12:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 61 | 61 | 9028 | Metal, E-Waste, & Battery Collection | closed | -77.12232103 | 38.86825002 | Arlington VA (Private) | 2021-01-05 10:30:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 62 | 62 | 9078 | Cart Services | closed | -77.05819201 | 38.85127398 | Arlington VA (Private) | 2021-01-05 14:22:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 63 | 63 | 8864 | Missed Service - Missed Collection | closed | -77.16378203 | 38.89967302 | Arlington VA (Private) | 2021-01-04 12:32:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 64 | 64 | 8911 | Metal, E-Waste, & Battery Collection | closed | -77.16049800 | 38.88924199 | Arlington VA (Private) | 2021-01-04 14:07:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 65 | 65 | 9105 | Metal, E-Waste, & Battery Collection | closed | -77.13944903 | 38.90110402 | Arlington VA (Private) | 2021-01-05 15:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 66 | 66 | 8929 | Cart Services | closed | -77.15108302 | 38.88641498 | Arlington VA (Private) | 2021-01-04 15:01:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 67 | 67 | 8952 | Cart Services | closed | -77.11539598 | 38.88691098 | Arlington VA (Private) | 2021-01-04 16:50:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 68 | 68 | 8961 | Missed Service - Missed Collection | closed | -77.15121697 | 38.90611602 | Arlington VA (Private) | 2021-01-04 17:56:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 69 | 69 | 8981 | Metal, E-Waste, & Battery Collection | closed | -77.15145300 | 38.89035599 | Arlington VA (Private) | 2021-01-04 20:58:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 70 | 70 | 8995 | Missed Service - Missed Collection | closed | -77.13969998 | 38.90431500 | Arlington VA (Private) | 2021-01-05 08:14:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 71 | 71 | 8869 | Metal, E-Waste, & Battery Collection | closed | -77.10209499 | 38.90288299 | Arlington VA (Private) | 2021-01-04 12:41:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 72 | 72 | 8896 | Metal, E-Waste, & Battery Collection | closed | -77.06435698 | 38.84988401 | Arlington VA (Private) | 2021-01-04 13:30:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 73 | 73 | 9153 | Metal, E-Waste, & Battery Collection | closed | -77.12994202 | 38.87343598 | Arlington VA (Private) | 2021-01-05 23:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 74 | 74 | 9189 | Cart Services | closed | -77.09129197 | 38.89369098 | Arlington VA (Private) | 2021-01-06 10:51:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 75 | 75 | 8903 | Metal, E-Waste, & Battery Collection | closed | -77.12081698 | 38.85881698 | Arlington VA (Private) | 2021-01-04 13:53:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 76 | 76 | 8930 | Metal, E-Waste, & Battery Collection | closed | -77.13787096 | 38.89128001 | Arlington VA (Private) | 2021-01-04 15:03:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 77 | 77 | 8939 | Cart Services | closed | -77.15059997 | 38.87781000 | Arlington VA (Private) | 2021-01-04 15:39:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 78 | 78 | 8944 | Missed Service - Missed Collection | closed | -77.12411802 | 38.85723900 | Arlington VA (Private) | 2021-01-04 16:16:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 79 | 79 | 8953 | Metal, E-Waste, & Battery Collection | closed | -77.10349804 | 38.89479001 | Arlington VA (Private) | 2021-01-04 16:50:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 80 | 80 | 8964 | Missed Service - Missed Collection | closed | -77.13832380 | 38.91031077 | Arlington VA (Private) | 2021-01-04 18:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 81 | 81 | 8996 | Missed Service - Missed Collection | closed | -77.15012899 | 38.90994299 | Arlington VA (Private) | 2021-01-05 08:19:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 82 | 82 | 9019 | Missed Service - Missed Collection | closed | -77.14753404 | 38.91114801 | Arlington VA (Private) | 2021-01-05 09:53:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 83 | 83 | 9023 | Metal, E-Waste, & Battery Collection | closed | -77.09570496 | 38.88047699 | Arlington VA (Private) | 2021-01-05 10:18:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 84 | 84 | 9062 | Cart Services | closed | -77.12826597 | 38.88071998 | Arlington VA (Private) | 2021-01-05 13:23:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 85 | 85 | 8812 | Missed Service - Missed Collection | closed | -77.13027604 | 38.86097000 | Arlington VA (Private) | 2021-01-04 08:38:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 86 | 86 | 9146 | Missed Service - Missed Collection | closed | -77.13837396 | 38.88075900 | Arlington VA (Private) | 2021-01-05 21:09:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 87 | 87 | 9148 | Missed Service - Missed Collection | closed | -77.13233103 | 38.89441601 | Arlington VA (Private) | 2021-01-05 21:27:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 88 | 88 | 9162 | Missed Service - Missed Collection | closed | -77.16179602 | 38.89116199 | Arlington VA (Private) | 2021-01-06 07:37:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 89 | 89 | 9164 | Missed Service - Missed Collection | closed | -77.13391001 | 38.87995300 | Arlington VA (Private) | 2021-01-06 07:56:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 90 | 90 | 9171 | Missed Service - Missed Collection | closed | -77.12804302 | 38.89556798 | Arlington VA (Private) | 2021-01-06 09:04:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 91 | 91 | 9173 | Missed Service - Missed Collection | closed | -77.12959501 | 38.88478600 | Arlington VA (Private) | 2021-01-06 09:08:00 | 2021-05-02 16:00:49.863000000 | public | QScend | |
| 92 | 92 | 9180 | Missed Service - Missed Collection | closed | -77.13124800 | 38.89322700 | Arlington VA (Private) | 2021-01-06 10:10:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 93 | 93 | 9196 | Missed Service - Missed Collection | closed | -77.13397799 | 38.88654599 | Arlington VA (Private) | 2021-01-06 11:31:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 94 | 94 | 9255 | Cart Services | closed | -77.14099699 | 38.86999002 | Arlington VA (Private) | 2021-01-06 15:44:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 95 | 95 | 9312 | Missed Service - Missed Collection | closed | -77.13937803 | 38.86987200 | Arlington VA (Private) | 2021-01-07 09:55:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 96 | 96 | 9330 | Cart Services | closed | -77.13533603 | 38.91623901 | Arlington VA (Private) | 2021-01-07 11:03:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 97 | 97 | 9244 | Traffic Sign Damaged/Missing | closed | -77.11876903 | 38.90431999 | 2370 N Vermont St, Arlington VA | 2021-01-06 14:50:00 | 2023-12-29 19:32:30.153000000 | public | QScend | |
| 98 | 98 | 9296 | Metal, E-Waste, & Battery Collection | closed | -77.15312402 | 38.87964899 | Arlington VA (Private) | 2021-01-07 09:06:00 | 2021-03-17 16:45:16.953000000 | public | QScend | |
| 99 | 99 | 9303 | Parking Sign Damaged/Missing | closed | -77.08870993 | 38.84092003 | Campbell Ave, Arlington VA | 2021-01-07 09:28:00 | 2023-12-22 19:32:19.170000000 | public | QScend | |
| 100 | 100 | 9031 | Missed Service - Missed Collection | closed | -77.15170015 | 38.89728064 | Arlington VA (Private) | 2021-01-05 10:40:00 | 2021-03-17 16:45:16.953000000 | 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]);