GHOS7 ON RF

Overview: 
Call logs 
/etc/passwd
Departments 
Wifi 
Terminal logs 
Someother spooki cool shit



Target: www.pittsburghpa.gov

Vuln: www.pittsburghpa.gov/mayor/release?id=5709

DBMS: PostgreSQL 

█████████████████
█departments.csv█
█████████████████
id,web_dir,department,description
1,cis,Innovation & Performance,City Information Systems (CIS)
4,Office of the Mayor,Office of Mayor Luke Ravenstahl
5,311,311 Response Line Office
6,Bureau of Police,City of Pittsburgh Bureau of Police
7,City Council District 1
8,City Council District 2
9,City Council District 3
10,City Council District 4
11,City Council District 5
12,City Council District 6
13,City Council District 7
14,City Council District 8
15,City Council District 9
16,City Clerk Office
17,City Planning
18,Personnel
19,CMPTF,Comprehensive Municipal Pension Trust Fund
20,Board of Standards and Appeals
21,Department of Public Safety
22,Citiparks
23,Executive
24,\tCampus Affairs Systems
25,IT Department
26,Real Estat

███████████
█calls.csv█
███████████

id,ident,group_identifed,dob,pcsi,need,name,email,police,status,phone2,phone1,hotline,housing,zipcode,address,textmsg,reponse,comments,services,nickname,last_name,phonecmt2,call_time,non_group,phonecmt1,employment,first_name,policezone,neighborhood,last_updated,prob_officer,police_verified
1,<blank>,NULL,1978-05-02 00:00:00,NULL,Job and a good future,Raymond Dean,<blank>,NULL,BOP,<blank>,412-722-8556,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-14 09:51:48,NULL,Wants a good job and a future.,<blank>,<blank>,<blank>,0,<blank>,<blank>,No
2,<blank>,NULL,1978-07-15 00:00:00,NULL,Job,Jerome Holiday,<blank>,NULL,<blank>,412-481-1527,412-576-3515,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-14 10:06:56,NULL,<blank>,<blank>,<blank>,<blank>,0,<blank>,<blank>,<blank>
3,<blank>,NULL,1975-03-09 00:00:00,NULL,Nothing,Shawn Young,<blank>,NULL,<blank>,<blank>,412-475-6284,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,No,<blank>,<blank>,<blank>,2010-07-14 11:16:02,NULL,Lives in New Kensington,<blank>,<blank>,<blank>,0,<blank>,<blank>,<blank>
4,<blank>,NULL,1989-12-13 00:00:00,NULL,Full time employment in labor. Now works 3 days a week but would like to work more.,Phil Robinson,<blank>,NULL,BOP,412-728-2082,412-681-4247,0,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-14 14:36:00,NULL,<blank>,<blank>,<blank>,<blank>,0,<blank>,<blank>,<blank>
5,<blank>,NULL,1981-12-27 00:00:00,NULL,job,DeAndre Riley,<blank>,NULL,<blank>,412-853-3190,412-758-5644,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-15 09:06:31,NULL,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
6,<blank>,NULL,1988-10-29 00:00:00,NULL,GED and Job,Machi Brown,<blank>,NULL,<blank>,412-969-7631,412-488-8034,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-15 09:02:56,NULL,"Called 5:55 pm Wednesday July 13, 2010.\r\nPolice said they had a Machi Scott in their system.  Ask about the name discrepancy.",<blank>,<blank>,<blank>,Beltzhoover,<blank>,<blank>,<blank>
7,<blank>,NULL,1981-06-22 00:00:00,NULL,any kind of job,Dion Morgan,<blank>,NULL,PCSI,<blank>,412-290-0589,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-15 09:04:56,NULL,"Called 8:55 am Thursdaay, July 15, 2010. Not on Police list but is on probation.  Got information and phone number from his mother.  Coordinate with OVOL.\r\n7/21/2010: forwarded name to PCSI, non-PIRC client.",<blank>,<blank>,<blank>,Middle Hill,<blank>,<blank>,<blank>
8,<blank>,NULL,1964-10-27 00:00:00,NULL,"Job.  She firt called 4:17 pm Thursday, July 15, 2010.  Verified by police.",Saundra Cole,<blank>,NULL,PCSI,<blank>,412-670-8421,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-16 09:17:22,NULL,<blank>,<blank>,<blank>,<blank>,Hazelwood,<blank>,<blank>,<blank>
9,<blank>,NULL,1983-12-01 00:00:00,NULL,"Job training and housing assistance. Has 2 kids and it's hard to keep house with a criminal background. She heard this number would provide help for people trying to change their lives. \r\n7/21/2010: referred to Karen at PCSI, non-PIRC client.\r\n",Brandi Boyd,<blank>,NULL,PCSI,412-207-2626,412-309-7394,Received card,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-19 14:00:08,NULL,7/21/2010: Forwarded to Karen at PCSI for follow-up.\r\nLater working for OVOL.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,No
10,<blank>,NULL,1988-12-27 00:00:00,NULL,GED and job,Keith Lovelace,<blank>,NULL,PCSI,412-404-2988,412-735-6807,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-28 09:05:30,NULL,He calle 7/19/2010.  We called back several times; he went out of town and called back 7/28/2010.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
12,<blank>,NULL,1984-02-06 00:00:00,NULL,Wants a construction job; needs rent assistance; wants to start his own business.  He already has a job and drivers license and is in school.,Brandon Chapman,<blank>,NULL,PCSI,412-461-2855,412-403-6616,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-07-29 16:02:14,NULL,<blank>,<blank>,<blank>,<blank>,Lincoln Place,<blank>,<blank>,<blank>
13,<blank>,NULL,<blank>,NULL,"Was encouraged to call by Rich Carrington.  Initially called Tuesday, August 3, 2010.\r\n8/10/10: Not on police list.  Referred to Karen Garrett at PCSI -- non-PIRC client.","Marvin Manker, Jr.",<blank>,NULL,PCSI,412-512-3383,412-488-0595,Received card,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-09 09:53:39,NULL,<blank>,<blank>,<blank>,<blank>,South Side Flats,<blank>,<blank>,<blank>
14,<blank>,NULL,1989-05-12 00:00:00,NULL,GED/Job,Andre Holiday,<blank>,NULL,PCSI,412-537-8930,412-758-2754,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-09 09:55:27,NULL,"Initially called August 3, 2010\r\n8/10/10: Jay spoke with Andre; forwarded name to police.",<blank>,<blank>,<blank>,South Side Flats,<blank>,<blank>,<blank>
15,<blank>,NULL,1990-06-04 00:00:00,NULL,"Initially called August 4, 2010.  Needs help with schooling and job.",Paul Wilkins,<blank>,NULL,PCSI,412-478-3453,412-734-1579,<blank>,<blank>,<blank>,<blank>,<blank>,NULL,NULL,No,<blank>,<blank>,<blank>,2010-08-09 09:58:23,NULL,Was at the call-in.  \r\n8/10/10: On Police list.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
16,<blank>,NULL,1990-06-13 00:00:00,NULL,Needs GED and job.,Michael Smith-Shipp,<blank>,NULL,PCSI,<blank>,412-277-7533,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-09 09:59:25,NULL,"Initially called Thursday, August 5, 2010.  Jay spokek with him Monday, August 9, 2010.\r\n8/10/10: on police list.",<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
17,<blank>,NULL,<blank>,NULL,<blank>,Dorian Glenn,<blank>,NULL,<blank>,<blank>,412-224-8426,<blank>,<blank>,<blank>,<blank>,<blank>,NULL,NULL,<blank>,<blank>,<blank>,<blank>,2010-08-09 10:01:25,NULL,"Initially called Friday, August 6, 2010.  Jay left messge Monda, 8/9 10 am.",<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
18,<blank>,NULL,1976-08-14 00:00:00,NULL,"Home and job.  He's currently homeless.  The phone numebr is with his godmother.\r\n8/13/10: Not on police list but is on probation.  Referred to Karen @ PCSI, non-PIRC client.\r\n2/16/2011: Lester called back.  Now he's on home monitoring until May.  Is also partially disabled with physical and mental issues (PTSD).",Lester Jones,<blank>,NULL,PCSI,412-918-6216,412-362-6051,One Vision One Life,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-13 11:22:43,NULL,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,No
19,<blank>,NULL,1984-08-24 00:00:00,NULL,Education (GED) and job.,Lelyn Reed,<blank>,NULL,PCSI,<blank>,412-378-8238,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-16 12:52:18,NULL,8/16/10: Status verified by police.  Forwarded to PCSI.,<blank>,<blank>,<blank>,Hazelwood,<blank>,<blank>,<blank>
20,<blank>,NULL,1989-01-03 00:00:00,NULL,Income source.  He's just out of jail.  Was referred to PIRC by his probation officer.,Brandon Townes,<blank>,NULL,BOP,412-983-1909,412-431-0257,<blank>,<blank>,<blank>,<blank>,<blank>,NULL,NULL,No,<blank>,<blank>,<blank>,2010-08-17 08:06:27,NULL,Initial call 8/16/2010 @ 5:10 pm.  \r\n8/17/10: Spoke with grandmother (412-431-0257)\r\n8/17/10: Not on police list.  Sent to PCSI-Karen as non-PIRC client.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
21,<blank>,NULL,1990-12-18 00:00:00,NULL,Job.  Has 2 pending cases.  Hasn't worked in years.  Has 2 children.  He was referred to PIRC Service Hotlne by Brandon Chapman who is in the same class.,Samuel Rice,<blank>,NULL,PCSI,412-432-5972,412-583-3213,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-19 12:25:14,NULL,"Use 412-432-5972 number.\r\n8/20/2010: Not on police list.  Referred to Karen at PCSI as a non-PIRC client.\r\n9/3/10: Has 2 pending cases he's fighting, will be in court next week. Jay referred him to Labor Ready for quick money work.",<blank>,<blank>,<blank>,South Side Flats,<blank>,<blank>,<blank>
22,<blank>,NULL,1991-05-26 00:00:00,NULL,Job.  Learned about PIRC from an aunt.  Lives in Duquesne.,Lawrence Barren,<blank>,NULL,PCSI,<blank>,412-403-1419,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-20 13:31:48,NULL,8/25/2010: sent to Karen at PCSI.\r\n9/3/2010: Telephone numebr not working.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,No
23,<blank>,NULL,1979-02-18 00:00:00,NULL,"8/23/10: Family support, going through divorce, has a child.  Already working.",Donald Scott,<blank>,NULL,PCSI,412-580-8013,412-377-8757,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-23 08:38:00,NULL,"Currently lives in Wilkinsburg, has lived in Lawrenceville.\r\n8/23/10: Not on police list.  Referred to PCSI-Karen as non-PIRC.",<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
24,<blank>,NULL,1971-10-09 00:00:00,NULL,Education in a trade; employment.,Lawrence Simmons,<blank>,NULL,PCSI,<blank>,412-853-7997,One Vision One Life,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-24 14:22:44,NULL,From the north side.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
25,<blank>,NULL,1989-11-08 00:00:00,NULL,job and training,Anthony Moye,<blank>,NULL,PCSI,<blank>,412-401-4275,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-25 14:06:47,NULL,9/3/10: Penn Hill resident.  Just wants paying job.  Referred to Career Center East and Careerlink.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
26,<blank>,NULL,1986-04-10 00:00:00,NULL,Job -- wants to work with One Vision One Life,LeRico Morgan,<blank>,NULL,PCSI,412-431-2116,412-801-2610,Attended call-in session,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-08-26 13:05:42,NULL,8/26/10: Verified by police.,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>
27,<blank>,NULL,1980-11-11 00:00:00,NULL,Job.  Needs full time.,David Mitchell,<blank>,NULL,PCSI,412-304-2122,412-628-2242,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,No,<blank>,<blank>,<blank>,2010-08-31 14:57:19,NULL,He's on probation.\r\n9/3/10: referred to Goodwill (for Fathers program); PCSI (for GED); One Vision (to help with outreach),<blank>,<blank>,<blank>,Upper Hill,<blank>,<blank>,<blank>
28,<blank>,NULL,1982-12-06 00:00:00,NULL,Clear up identity theft issues; job.\r\n9/10/10: Not on police list.\r\n9/10/10: Referred to Neighborhood Legal Services for identity theft problem; Joblinks Oakland for employment (ask for Nia).\r\n9/13/10: Referred to Healthy Start (Benjamin Davis) for fatherhood issues.,John Walker,<blank>,NULL,BOP,412-687-7059,412-224-9240,Other,<blank>,<blank>,<blank>,<blank>,NULL,NULL,Yes,<blank>,<blank>,<blank>,2010-09-09 14:15:57,NULL,"Expecting child to be born next week, not married to mother.",<blank>,<blank>,<blank>,<blank>,<blank>,<blank>,<blank>

██████████████
█contacts.csv█
██████████████

id,name,email,organization
3,"Miazga, Eric -- CIS",[email protected],NULL
7,Jay Gilmer -- PIRC Coordinator,[email protected],NULL
9,Taili Thompson -- Youth Opportunities Development,[email protected],NULL
13,Barry Budd -- Sergeant at Police Intelligence,[email protected],NU$
14,Mike Olack -- Goodwill,[email protected],NULL
16,Mila Eggers-McNutt -- Goodwill,[email protected],NULL
18,Charles Saunders -- Goodwill,[email protected],NULL
19,Sabrina Orlansky -- County Adult Probation,sabrina.orlansky@alleghenycourts.$
20,Maurice Williams--Goodwill,[email protected],NULL
21,Brandon Ziats - Youth Opportunities Development,[email protected],NULL
22,Michelle Auge-Pittsburgh Police,[email protected],NULL

████████████
█phones.csv█ 
████████████

id,call_id,number,category
35,29,3221212,2
36,29,2EFCXCSX,20
37,29,333,17
38,30,433,2
39,30,555,1
42,30,333,2
43,30,666,32
44,30,222,1
45,30,654321,39
46,30,975,40
49,31,12121212,43
61,32,1111,1
62,32,2222,3
65,36,777,1
69,39,111,1
70,39,111,1
71,39,222,3
72,39,111,1
73,39,222,3
74,39,223,55
76,41,333,2
77,41,435,62
78,41,999,63
79,41,4546,59
83,232,111111111,1
84,232,444,63
85,234,dfh,63
86,234,444,59
87,234,fghgh,62
88,235,11,1
89,235,22,61
90,237,412-535-4343,66
94,238,412-452-1776,2
96,241,724-328-3712,2
97,241,412-377-8629,67
98,242,412-661-8650,68
99,242,412-697-1616,70
100,243,412-689-6301,2
101,243,412-628-5003,69
102,244,412-931-3525,2
103,244,412-657-4420,68
104,245,412-606-9816,2
105,245,412-315-1479,2
106,245,412-512-8902,71
108,246,412-512-8902,71
109,247,412-304-6611,2
110,247,412-925-1180,2
111,248,412-512-8854,2
112,249,412-452-1712,2
113,250,412-496-7439,68
114,250,412-473-7891,1
115,251,412-228-1006,2
116,252,412-535-4343,72
117,253,412-805-0494,2
118,254,412-431-6870,1
119,254,412-628-5570,71
120,255,412-628-8701,2
121,255,412-689-6321,71
122,256,412-370-8495,2
123,256,412-281-3159,1
124,257,412-853-8709,2
125,258,412-343-4782,1
126,259,412-758-6581,2
127,260,412-657-3808,2
128,260,412-920-3040,1
129,261,412-467-9826,2
130,246,412-689-3721,2
131,246,412-315-1479,68
132,261,412-315-5545,2
133,262,412-315-5545,2
134,263,412-918-0620,2
135,263,412-744-4950,1
136,264,412-687-2974,1
137,264,412-920-6189,68
138,266,412-439-6270,2
139,267,724-732-1818,2
140,267,412-925-6990,1
141,267,412-583-8468,2
143,268,412-925-6990,1
144,269,412-277-1322,2
145,269,412-506-0711,69
146,270,412-584-2603,2
147,270,412-758-8181,73
149,272,412-642-6873,74
150,272,412-322-4591,1
151,272,412-689-7352,2
152,272,412-773-0310,75
153,273,412-773-0310,75
154,273,412-689-7352,2
155,274,412-231-7868,1
156,274,412-336-8249,2
157,275,412-614-8040,2
158,275,412-969-9727,71
159,276,412-689-4573,2
160,276,412-290-9432,68
161,277,412-969-2297,2
162,277,412-377-6095,74
163,278,412-371-1026,1
164,278,412-639-4125,2
166,279,570-793-7808,2
167,279,570-486-9896,69
168,280,412-608-5073,2
169,280,412-737-8641,71
170,281,412-496-8581,2
171,282,412-354-2356,2
172,282,412-251-3044,71
173,283,412-321-3723,1
174,283,412-475-6705,2
175,284,412-251-6886,2
176,284,412-758-7893,2
177,285,304-914-0231,2
178,285,412-654-5504,76
179,286,412-320-5328,2
180,287,412-908-1372,2
181,288,412-801-2648,2
182,289,412-304-4473,2
183,289,412-403-9387,73
184,290,412-689-9563,2
185,291,412-315-1077,2
186,291,412-681-0545,1
187,292,412-607-4422,2
188,293,412-403-8139,2
189,293,412-793-0463,73
190,294,412-657-7153,2
192,295,412-320-9002,2
193,295,412-231-0182,1
194,296,252-366-0837,2
195,297,412-904-3153,1
196,298,412-407-0748,2
197,298,412-389-7766,2
198,299,412-758-1546,2
199,300,412-889-7648,2
200,300,412-389-5487,2
201,300,412-621-3626,73
202,301,412-389-5427,2
203,301,412-621-3626,73
204,302,412-758-6125,2
205,302,412-944-7154,71
206,303,412-951-6676,2
207,303,412-322-5609,1
208,304,412-969-4622,2
209,304,412-231-2939,1
210,305,412-403-0892,2
211,305,412-969-5473,73
212,306,412-401-1235,2
213,306,412-370-3867,73
214,307,412-628-8158,2
215,307,412-889-4223,2
216,308,412-894-6738,2
217,308,412-452-5208,69
218,309,412-689-9894,2
219,309,412-728-3122,2
220,310,412-758-3395,2
221,310,412-512-2287,68
222,311,412-403-4376,2
223,312,412-951-8461,2
224,312,412-904-2163,69
225,313,412-853-2961,2
226,313,412-458-1065,1
227,314,412-969-8344,2
228,314,412-403-2569,69
229,316,412-482-0537,2
230,316,412-727-6608,1
231,316,412-452-4321,2
232,316,412-901-2142,76
233,317,412-452-4321,2
234,317,412-901-2142,76
235,318,412-596-8366,71
236,318,412-689-1945,2
237,319,412-969-4609,68
238,319,412-969-4609,69
239,320,412-897-7382,2
240,320,412-322-5042,1
241,321,412-243-1079,2
242,321,412-506-3952,1
243,322,412-512-2448,2
244,322,412-867-4536,1
246,323,412-586-4890,1
247,323,412-628-7990,2
248,323,412-766-4239,1
249,325,412-628-7990,2
250,325,412-766-4239,1
253,326,412-626-2590,2
255,327,412-708-0267,2
256,327,412-215-9363,2
257,326,412-377-7010,73
258,328,412-537-9302,2
259,328,412-734-3017,1
260,329,412-339-7100,2
261,329,412-381-2969,73
263,330,412-452-3766,2
264,330,412-727-6194,1
266,331,412-855-5233,74
267,332,412-728-1191,2
268,332,412-489-5888,76
269,268,724-513-7425,2
270,333,412-251-2176,1
271,333,412-689-3210,2
272,333,209-481-1752,2
273,333,412-231-2480,1
274,334,209-481-1752,2
275,335,412-973-5301,2
276,335,412-621-6064,1
277,336,412-390-4213,2
278,336,412-403-7318,1
279,337,412-632-4136,2
280,337,412-322-1232,1
281,337,412-881-2542,1
282,337,412-853-3590,2
283,338,412-881-2542,1
284,338,412-853-3590,2
285,339,412-765-9558,2
286,340,412-235-7175,1
287,340,412-235-7175,1
288,331,412-431-5359,2
289,323,412-390-9948,2
290,344,412-805-0170,2
291,345,412-689-5812,73
292,345,412-463-6869,2
293,345,412-526-0263,76
294,345,412-853-6938,2
295,346,412-853-6938,2
296,347,412-482-7458,2
297,347,412-417-7483,1
298,348,412-361-6047,1
299,348,412-728-4585,71
300,349,412-452-7249,2
301,349,412-277-5150,1
302,350,412-592-2759,2
303,350,412-519-3184,73
306,351,412-969-2837,71
307,351,412-726-9575,73
308,352,412-731-1117,2
309,352,412-513-7284,73
310,353,412-513-5570,2
311,353,412-363-3037,74
312,354,412-265-7621,2
313,354,412-628-8158,73
314,355,412-277-8175,75
315,357,412-473-0138,1
316,358,412-801-3660,2
317,358,412-773-3172,1
318,359,412-969-4132,76
319,359,412-621-2979,73
320,360,412-596-1723,2
321,360,724-467-2634,76
322,343,412-537-5360,2
323,361,412-260-3113,2
324,361,412-377-8359,1
325,362,412-432-3211,1
326,362,740-792-0016,2
327,363,412-823-3648,1
328,363,412-447-1590,2
329,364,412-737-3340,2
330,364,412-916-5052,68
332,365,412-606-4151,68
333,366,412-231-1298,1
334,366,412-537-8005,68
335,366,412-403-2482,68
336,368,412-812-3680,2
337,368,412-297-6333,73
338,369,412-527-0587,2
339,370,412-580-4706,2
340,370,412-404-8519,73
341,371,412-287-2856,2
342,371,412-216-6645,69
343,371,313-974-8646,2
344,372,313-974-8646,2
345,372,412-657-0671,73
346,374,412-241-7879,1
348,374,412-628-8157,2
349,375,412-515-9240,2
350,373,412-583-4969,2
351,376,412-381-2676,77
352,376,412-742-4053,1
353,377,412-235-7228,1
354,377,412-478-5898,2
355,377,412-527-2001,2
356,378,412-527-2001,2
357,379,412-758-6114,2
358,379,412-452-1241,73
359,379,412-853-3216,73
360,380,412-737-9362,2
361,380,412-403-2204,1
362,381,412-377-1278,2
363,382,412-969-0790,2
364,382,412-241-6088,1
365,383,412-593-7112,2
366,383,412-403-1973,1
367,384,412-432-6989,2
368,385,412-609-9040,2
369,385,412-606-6557,1
370,386,412-609-9040,2
371,386,412-606-6557,1
372,387,412-628-0181,2
373,387,412-727-6103,1
374,388,412-265-7072,2
375,388,412-628-8185,1
376,389,412-758-6432,2
377,389,412-867-0140,73
378,390,412-312-0429,2
379,391,412-381-1041,1
380,391,347-369-6284,2
381,392,412-519-8252,2
382,393,412-247-1049,1
384,393,412-609-8197,2
385,394,412-235-7154,1
386,394,412-872-8033,2
387,395,878-201-8050,2
388,395,412-513-7962,1
389,396,412-294-6746,2
390,397,412-969-1726,2
391,398,412-377-0264,2
392,398,412-235-7563,1
393,399,412-430-1878,2
394,399,412-281-1343,1
395,400,412-682-2159,1
396,400,412-209-9776,2
397,401,412-537-7231,2
398,402,412-403-8041,2
399,402,412-638-3850,2
401,404,412-592-1285,2
402,405,412-506-5504,2
403,405,412-371-6143,1
404,405,412-378-3460,2
405,406,412-378-3460,2
406,403,412-638-3850,2
407,403,412-871-5357,1
408,407,878-201-8045,71
409,408,412-403-7104,2
410,408,412-853-9308,75
411,409,412-628-9725,2
412,409,412-452-3477,69
413,410,412-431-0907,1
414,410,412-417-5191,2
415,411,412-403-0354,2
416,365,412-403-7654,2
417,412,412-728-0537,2
418,412,484-223-6377,2
419,414,412-515-4673,2
420,413,412-923-8108,2
421,271,412-320-1358,2
422,415,412-481-1324,1
423,416,878-302-7363,2
424,417,412-621-1028,1
425,418,412-852-7355,2
426,418,412-377-8908,1
427,419,412-979-5891,2
428,419,412-853-0596,73
429,420,412-904-8348,2
430,420,412-923-8242,71
431,421,412-889-9527,2
432,422,412-448-6760,2
433,423,412-427-7643,2
434,423,412-904-3611,1
435,420,412-628-3018,2
436,424,412-923-8645,2
437,424,412-498-7374,78
438,425,412-580-6806,2
439,425,412-731-1102,1
440,423,412-606-1495,1
441,426,412-498-0268,2
442,426,412-583-8929,71
443,427,412-628-6871,1
444,427,412-320-6097,2
445,428,412-706-2787,2
446,429,412-606-1487,2
447,429,412-580-6806,2
448,430,412-693-4788,2
449,430,412-961-1295,68
450,431,412-463-8245,2
451,432,412-723-2093,1
452,433,412-689-2449,2
453,433,412-727-7344,1
454,434,412-969-4067,2
455,434,412-481-9491,73
456,435,412-526-7292,2
457,435,412-657-7044,73
458,436,412-327-3671,2
459,437,412-231-5215,1
460,437,412-923-8621,2
462,122,412-390-7657,2
463,438,412-243-6573,1
464,438,412-904-8979,2
465,439,412-932-9266,2
466,439,412-733-6098,79
467,440,412-932-0827,2
468,440,412-273-0447,79
469,441,412-923-8005,2
470,442,412-537-2399,2
471,437,412-727-4698,75
472,443,412-728-2429,71
473,443,412-223-8010,74
474,444,412-728-0028,2
475,444,412-482-7166,79
476,445,412-613-3515,2
477,445,412-488-7191,1
478,446,724-462-6123,2
479,446,724-884-8801,1
480,147,412-419-7743,2
481,147,412-731-1308,1
482,447,412-520-2393,73
483,448,412-937-6451,2
484,448,412-973-5351,71
485,449,412-973-5351,71
486,450,412-568-8282,2
487,451,412-537-7536,1
488,451,412-613-7764,2
490,452,412-712-3327,2
491,452,412-371-1413,1
492,453,412-606-5650,2
493,454,412-709-7748,2
494,454,412-422-3264,1
495,455,412-892-6525,2
496,455,856-693-6051,76
497,456,724-732-1211,2
498,456,412-223-8030,73
499,457,412-419-7977,2
500,457,412-584-0042,73
501,458,412-568-8613,2
502,458,412-304-6006,1
503,450,412-496-0222,71
504,459,412-232-0806,1
505,460,412-915-0791,2
506,461,412-639-4201,2
507,462,412-626-8515,1
508,462,412-689-5723,2
509,463,412-689-2578,2
510,463,412-243-8482,69
511,464,412-620-3363,2
512,465,412-620-3363,2
513,465,412-583-2421,80
514,466,412-354-1626,2
515,467,412-923-9749,2
516,467,412-277-5953,73

████████████
█fwdlog.csv█
████████████

call_id,contact_id,fwdtime,organization
1,7,2012-02-13 14:20:38.182063,pcsi
1,3,2012-02-13 14:22:02.535205,bop
10,4,2010-07-28 09:29:14.701693,pcsi
10,6,2010-07-28 09:29:19.089938,pcsi
100,9,2011-03-29 09:45:06.780793,pcsi
100,11,2011-03-29 09:45:11.321318,pcsi
101,11,2011-04-20 16:44:11.628697,pcsi
101,9,2011-04-20 16:44:15.173579,pcsi
102,13,2011-04-07 13:30:26.339681,bop
102,5,2011-04-07 13:30:23.324888,bop
103,4,2011-04-11 16:08:27.205369,pcsi
103,6,2011-04-11 16:08:31.550096,pcsi
104,4,2011-04-26 08:12:16.310473,pcsi
104,6,2011-04-26 08:12:20.11636,pcsi
105,4,2011-04-27 16:13:08.742133,pcsi
105,6,2011-04-27 16:13:12.463355,pcsi
106,6,2011-05-02 15:19:22.934276,pcsi
106,4,2011-05-02 15:19:18.995121,pcsi
107,6,2011-05-04 12:13:50.045405,pcsi
107,4,2011-05-04 12:13:46.174962,pcsi
108,9,2011-05-12 12:59:39.60413,pcsi
108,11,2011-05-12 12:59:35.723853,pcsi
109,11,2011-05-25 08:40:39.902007,pcsi
109,9,2011-05-25 08:40:36.351615,pcsi
111,4,2011-05-24 15:20:01.161782,pcsi
111,6,2011-05-24 15:20:05.051165,pcsi
112,6,2011-06-01 10:11:57.412881,pcsi
112,4,2011-06-01 10:11:53.749599,pcsi
113,9,2011-08-10 09:17:39.154323,pcsi
113,11,2011-08-10 09:17:35.535201,pcsi
114,14,2011-08-18 08:37:30.029732,pcsi
114,15,2011-08-18 08:37:26.315515,pcsi
115,15,2011-08-24 09:34:00.635266,pcsi
115,<blank>,2011-08-24 09:33:22.675256,bop
115,14,2011-08-24 09:34:04.378449,pcsi
116,2,2011-09-08 09:08:49.646087,pcsi
116,14,2011-09-07 13:08:53.926908,pcsi
116,15,2011-09-07 13:08:46.887697,pcsi
116,14,2011-09-08 09:08:52.272871,pcsi
117,14,2011-09-13 12:21:28.404177,pcsi
117,15,2011-09-13 12:21:24.458264,pcsi
118,15,2011-10-04 11:37:12.71337,pcsi
118,14,2011-10-04 11:37:16.895374,pcsi

██████████
█wifi.csv█ 
██████████

id,ip,title,uname,pword
1,http://10.1.254.10:9997/login,Ruckus,ccb5WiFi,ThreeRivers

███████████████
█terminals.csv█ 
███████████████

terminal_id,node,rate,location,latitude,longitude,terminal_status
301520-SHARVD0001,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",SHERIDAN HARVARD LOT,40.462616226637564,-79.92306504414557,Active
302521-KIRKWD0001,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",SHERIDAN KIRKWOOD LOT,40.46178797963549,-79.92312406994057,Active
302522-KIRKWD0002,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",SHERIDAN KIRKWOOD LOT,40.46178432797751,-79.92268570552255,Active
302523-KIRKWD0003,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",SHERIDAN KIRKWOOD LOT,40.46150367410059,-79.92232613128283,Active
304524-TAMELO0001,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",TAMELLO BEATTY LOT,40.46117887775765,-79.92672005522536,Active
304525-TAMELO0002,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",TAMELLO BEATTY LOT,40.46076269293209,-79.92752235581969,Active
304526-TAMELO0003,<blank>,"$1PH/10HRS/M-Sat,8AM-10PM",TAMELLO BEATTY LOT,<blank>,<blank>,Inactive
307527-EVABTY0001,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",EVA BEATTY LOT,40.461710350429335,-79.92784425644873,Active
307528-EVABTY0002,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",EVA BEATTY LOT,40.461593244410835,-79.92772613988114,Active
308529-HARVBT0001,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",HARVARD BEATTY LOT,40.46349722714609,-79.92553045767215,Active
308530-HARVBT0002,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",HARVARD BEATTY LOT,40.46308508137939,-79.92561699999999,Active
311001-ANSLEY0001,EastLiberty,"$1PH/10HRS/M-SAT,8AM-10PM",ANSLEY/BEATTY LOT,40.46304947210446,-79.92641430337244,Active
314001-PENNNW0001,EastLiberty,"$1PH/10HRS/M-Sat,8AM-10PM",PENN CIRCLE NW LOT,40.46359546943775,-79.92579970552253,Active
321533-BEBART0001,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",BEACON BARTLETT LOT,40.435041145395154,-79.923488317791,Active
321534-BEBART0002,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",BEACON BARTLETT LOT,40.4354452699404,-79.92366629447747,Active
321535-BEBART0003,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",BEACON BARTLETT LOT,40.435874667873556,-79.92369731779098,Active
322536-FSHADY0001,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",FORBES SHADY LOT,40.43861491713441,-79.91971131779098,Active
322537-FSHADY0002,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",FORBES SHADY LOT,40.43859358007499,-79.92013204662703,Active
322538-FSHADY0003,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",FORBES SHADY LOT,40.43859837290266,-79.92052231779098,Active
323539-DPHILP0001,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",DOUGLAS PHILLIPS LOT,40.43244041847253,-79.92249850429914,Active
323540-DPHILP0002,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",DOUGLAS PHILLIPS LOT,40.43279658253919,-79.92258678769684,Active
324541-FMURRY0001,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",FORBES MURRAY LOT,40.4385102900537,-79.9224455656414,Active
324542-FMURRY0002,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",FORBES MURRAY LOT,40.43844087568588,-79.92240972023774,Active
324572-FMURRY0003,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",FORBES MURRAY LOT,40.438876201348535,-79.92266641104504,Active
325543-JCCLOT0001,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",JCC/FORBES LOT,40.43774551824542,-79.92361679629516,Active
325544-JCCLOT0002,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",JCC/FORBES LOT,40.437766792707784,-79.9241852883606,Active
325570-JCCLOT0003,SquirellHill,"$1PH/10HRS/M-Sat,8AM-10PM",JCC/FORBES LOT,<blank>,<blank>,Inactive
328545-IVYBEL0001,ShadySide,"$1PH/$2PH_SplitRate/10HRS/M-Sat,8AM-10PM",IVY BELLEFONTE LOT,40.45156393844067,-79.93402075214959,Active
328546-IVYBEL0002,ShadySide,"$1PH/$2PH_SplitRate/10HRS/M-Sat,8AM-10PM",IVY BELLEFONTE LOT,40.451694425507156,-79.93359083680536,Active
328547-IVYBEL0003,ShadySide,"$1PH/$2PH_SplitRate/10HRS/M-Sat,8AM-10PM",IVY BELLEFONTE LOT,40.45176600000001,-79.93323038773155,Active
328548-IVYBEL0004,ShadySide,"$1PH/$2PH_SplitRate/10HRS/M-Sat,8AM-10PM",IVY BELLEFONTE LOT,40.451992999999994,-79.93288672883602,Active
328549-IVYBEL0005,ShadySide,"$1PH/$2PH_SplitRate/10HRS/M-Sat,8AM-10PM",IVY BELLEFONTE LOT,40.452052061537216,-79.93243434110451,Active
329001-CCRAIG0001,Oakland,"$1PH/10HRS/M-Sat,8AM-10PM",CENTRE/CRAIG LOT,40.45168996155256,-79.95195418596267,Active
331001-ZENITH0001,EastLiberty,"$1PH/10HRS/M-SAT,8AM-10PM",HOMEWOOD ZENITH LOT,40.455562043993496,-79.89687910306202,Active
334552-TAYLOR0001,Bloomfield,"$1PH/10HRS/M-Sat,8AM-10PM",TAYLOR STREET LOT,40.46331854384469,-79.95040618650819,Active
335553-FCEDAR0001,Bloomfield,"$1PH/10HRS/M-Sat,8AM-10PM",FRIENDSHIP CEDARVILLE LOT,40.46212481086781,-79.94840572883606,Active
335554-FCEDAR0002,Bloomfield,"$1PH/10HRS/M-Sat,8AM-10PM",FRIENDSHIP CEDARVILLE LOT,40.4625037719921,-79.94798197668649,Active
337555-52BUTL0001,Lawrenceville,"$1PH/10HRS/M-Sat,8AM-10PM",52ND & BUTLER LOT,40.48106749821452,-79.95390163558198,Active
338556-42BUTL0001,Lawrenceville,"$1PH/10HRS/M-Sat,8AM-10PM",42ND & BUTLER LOT,40.47053200000002,-79.96034624785045,Active
341334-18SDNY0001,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",18TH & SIDNEY LOT,40.42934161967123,-79.98058140277862,Active
341335-18SDNY0002,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",18TH & SIDNEY LOT,40.4294192047737,-79.98056262731552,Active
342336-ECARSN0001,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",EAST CARSON LOT,40.428857731617356,-79.98576879501343,Active
342337-ECARSN0002,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",EAST CARSON LOT,40.429372245380264,-79.98564004898071,Active
343338-19CARSN0001,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",19TH & CARSON LOT,40.428526970691195,-79.97839540243149,Active
344339-18CARSN0001,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",18TH & CARSON LOT,40.428647433192154,-79.98025953769684,Active
344340-18CARSN0002,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",18TH & CARSON LOT,40.42832075472265,-79.98029977083206,Active
345341-20SDNY0001,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",20TH & SIDNEY LOT,40.42924361730855,-79.97716158628464,Active
345342-20SDNY0002,SouthSide,"$1PH/10HRS/M-Sat,8AM-10PM",20TH & SIDNEY LOT,40.42918849091681,-79.97698456048965,Active
351001-BSANKY0001,Carrick,"$1PH/10HRS/M-Sat,8AM-10PM",BROWNSVILLE SANKEY LOT,40.3848306563963,-79.97706974853827,Active
351002-BSANKY0002,Carrick,"$1PH/10HRS/M-Sat,8AM-10PM",BROWNSVILLE SANKEY LOT,40.38486831112038,-79.97776916294242,Active
355560-ASTERW0001,Allentown,"$1PH/10HRS/M-Sat,8AM-10PM",ASTEROID WARRINGTON LOT,40.421746663239325,-79.99334165889547,Active
357561-SHILOH0001,MtWashington,"$1PH/10HRS/M-Sat,8AM-10PM",SHILOH STREET LOT,40.429843549595596,-80.00790468220901,Active
357568-SHILOH0002,MtWashington,"$1PH/10HRS/M-Sat,8AM-10PM",SHILOH STREET LOT,40.43007377477776,-80.00748024785042,Active
357569-SHILOH0003,MtWashington,"$1PH/10HRS/M-Sat,8AM-10PM",SHILOH STREET LOT,40.42985678150523,-80.00741275214955,Active
361001-BRKLOT0001,Brookline,"$1PH/10HRS/M-Sat,8AM-10PM",BROOKLINE LOT,40.39267412224306,-80.01872520899269,Active
363001-BEECHV0001,Beechview,"$1PH/10HRS/M-Sat,8AM-10PM",BEECHVIEW LOT,40.41116152161989,-80.0244512921472,Inactive
369001-MAINLT0001,West End,"$1PH/10HRS/M-Sat,8AM-10PM",MAIN/ALEXANDER LOT,40.440717969032434,-80.03386820671949,Active
371565-EOHIO-0001,NorthSide,"$1PH/10HRS/M-Sat,8AM-10PM",EAST OHIO STREET LOT,40.454414976194236,-79.99985956564137,Active
371566-EOHIO-0002,NorthSide,"$1PH/10HRS/M-Sat,8AM-10PM",EAST OHIO STREET LOT,40.45420663623736,-79.9993721165676,Active
371571-EOHIO-0003,NorthSide,"$1PH/10HRS/M-Sat,8AM-10PM",EAST OHIO STREET LOT,40.45410798860599,-79.99998836441801,Active
375001-OBHILL0001,NorthSide,"$1PH/10HRS/M-Sat,8AM-10PM",OBSERVATORY HILL LOT,40.49000215337434,-80.01855611801147,Active
401347-SMTHFD0403,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",SMITHFIELD,40.43980459193305,-79.9986782670021,Active
401348-SMTHFD0501,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",SMITHFIELD,40.440453752956515,-79.99833226203918,Active
401349-SMTHFD0503,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",SMITHFIELD,40.441000839769146,-79.9979916214943,Active
401350-SMTHFD0601,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",SMITHFIELD,40.441868412339666,-79.99742299318313,Active
401351-SMTHFD0603,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",SMITHFIELD,40.44255633839528,-79.99690532684326,Active
401352-SMTHFD0701,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",SMITHFIELD,40.44306462345091,-79.99649494886398,Active
401353-7THAVE0402,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",7TH AVE,40.44240528105154,-79.99534696340561,Active
401354-OLIVER0301,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",OLIVER AVE,40.4414070692608,-79.99963045120239,Active
401355-OLIVER0303,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",OLIVER AVE,40.44117231382381,-79.99897062778473,Active
401356-OLIVER0402,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",OLIVER AVE,40.44023940802874,-79.99681949615478,Active
401357-6THST-0101,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",6TH ST,40.443013590988365,-80.00221073627472,Active
401358-7THST-0101,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",7TH ST,40.4442669370593,-80.00063091516495,Active
401359-9THST-0101,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",9TH ST,40.44461599182077,-79.99867290258407,Active
401360-WILLPN0504,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",WILLIAM PENN PL,40.440359849548464,-79.9972003698349,Active
401361-WILLPN0502,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",WILLIAM PENN PL,40.439998524341966,-79.99759197235107,Active
401362-10THST0202,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",10TH ST,40.4439423757425,-79.9954703450203,Active
401363-WILLPN0602,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",WILLIAM PENN PL,<blank>,<blank>,Inactive
401364-WILLPN0604,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",WILLIAM PENN PL,40.44143156543307,-79.99655663967132,Active
401365-LIBRTY0602,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",LIBERTY AVE,40.44201742956031,-80.00108689069748,Active
401366-LIBRTY0801,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",LIBERTY AVE,40.44255633839528,-79.99969750642776,Active
401367-LIBRTY0901,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",LIBERTY AVE,40.44350962488237,-79.99605774879455,Active
401368-PENAVE0901,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",PENN AVE,40.44392138093136,-79.9979962245369,Active
401369-PENAVE0903,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",PENN AVE,40.44418415410659,-79.9968919300594,Active
401370-FTDUQN0602,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",FORT DUQUESNE,40.44440982519247,-80.00108689069748,Active
401371-FTDUQN0802,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",FORT DUQUESNE,40.445007910796214,-79.9991825222969,Active
401372-STANWX0601,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",STANWIX ST,40.44282374988759,-80.00422239303589,Active
401373-MARKET0001,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",MARKET ST,<blank>,<blank>,Removed
401374-FORBES0101,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.441109031783114,-80.00365912914276,Active
401375-FORBES0102,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.4410539151185,-80.00384420156479,Active
401376-FORBES0201,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.44050070461135,-80.00176012516022,Inactive
401377-FORBES0202,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.44009651103056,-80.00101447105408,Inactive
401378-FORBES0301,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.43960550317125,-79.99937738773155,Inactive
401379-FORBES0302,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.439728420419584,-80.00004131779099,Inactive
401380-FORBES0303,Downtown,"$3PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,<blank>,<blank>,Inactive
401381-FORBES0401,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",FORBES AVE,40.43930768941318,-79.99868300000003,Active
401500-MKTSQR0001,Downtown,"$4PH/2HRS/M-SAT,8AM-6PM",MARKET SQ,40.44089258636627,-80.00215200000002,Active

██████████
█aaab.csv█ 
██████████

adm:x:3:4:adm:/var/adm:/sbin/nologin
adm:x:3:4:adm:/var/adm:/sbin/nologin
apache:x:48:48:Apache:/var/www:/sbin/nologin
apache:x:48:48:Apache:/var/www:/sbin/nologin
avahi-autoipd:x:100:103:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin
avahi-autoipd:x:100:103:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin
avahi:x:70:70:Avahi daemon:/:/sbin/nologin
avahi:x:70:70:Avahi daemon:/:/sbin/nologin
bin:x:1:1:bin:/bin:/sbin/nologin
bin:x:1:1:bin:/bin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
dbus:x:81:81:System message bus:/:/sbin/nologin
dbus:x:81:81:System message bus:/:/sbin/nologin
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin
games:x:12:100:games:/usr/games:/sbin/nologin
games:x:12:100:games:/usr/games:/sbin/nologin
gdm:x:42:42::/var/gdm:/sbin/nologin
gdm:x:42:42::/var/gdm:/sbin/nologin
gopher:x:13:30:gopher:/var/gopher:/sbin/nologin
gopher:x:13:30:gopher:/var/gopher:/sbin/nologin
haldaemon:x:68:68:HAL daemon:/:/sbin/nologin
haldaemon:x:68:68:HAL daemon:/:/sbin/nologin
halt:x:7:0:halt:/sbin:/sbin/halt
halt:x:7:0:halt:/sbin:/sbin/halt
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin
mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin
mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash
mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash
news:x:9:13:news:/etc/news:
news:x:9:13:news:/etc/news:
nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin
nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin
nobody:x:99:99:Nobody:/:/sbin/nologin
nobody:x:99:99:Nobody:/:/sbin/nologin
nocadmin:x:503:503:NOC Admin:/home/nocadmin:/bin/bash
nocadmin:x:503:503:NOC Admin:/home/nocadmin:/bin/bash
nscd:x:28:28:NSCD Daemon:/:/sbin/nologin
nscd:x:28:28:NSCD Daemon:/:/sbin/nologin
ntp:x:38:38::/etc/ntp:/sbin/nologin
ntp:x:38:38::/etc/ntp:/sbin/nologin
operator:x:11:0:operator:/root:/sbin/nologin
operator:x:11:0:operator:/root:/sbin/nologin
oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin
oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin
pcap:x:77:77::/var/arpwatch:/sbin/nologin
pcap:x:77:77::/var/arpwatch:/sbin/nologin
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash
root:x:0:0:root:/root:/bin/bash
root:x:0:0:root:/root:/bin/bash
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin
rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin
rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin
rpm:x:37:37::/var/lib/rpm:/sbin/nologin
rpm:x:37:37::/var/lib/rpm:/sbin/nologin
sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin
sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown
smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin
smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin
sync:x:5:0:sync:/sbin:/bin/sync
sync:x:5:0:sync:/sbin:/bin/sync
uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin
uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin
vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin
vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin
xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin
xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin

███████████
█users.csv█
███████████

id,pid,email,username,password,usr_group,position,department,display_name,organization
22,733179,[email protected],ericm,2D3C73D21E3B0852E241BE093957D3AAEFF71028,superuser,Administrator,City Information Systems,Eric Miazga,City
24,550296,[email protected],padmin,D033E22AE348AEB5660FC2140AEC35850C4DA997,admin,<blank>,Enter Your Department,Park Administrator,City
25,300042,[email protected],davep,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,superuser,wed dev,City Information Systems,Dave,City
26,449281,[email protected],ura,55E9CD8001573EF21E30F1EF1456FA2A5F01B5F3,URA Users,<blank>,Enter Your Department,ura admin,ura
27,576992,[email protected],city,2C54892C40A1751663D9ACA4E03E6A833056BC9F,admin,<blank>,Enter Your Department,city admin,City
31,713424,[email protected],clerk,F38DE2358E07B0C3D99164B3494CE57BFF75EE70,admin,<blank>,<blank>,city clerk,clerk
33,657485,[email protected],district2,284D06980CE00B2EFDDEBA556C3CFC30C121E5E3,admin,<blank>,<blank>,district2,district 2
34,832204,[email protected],district3,F3055148F70BA929D7DC0C4FE547EB6EF6CAA7E2,admin,<blank>,<blank>,district3,district 3
35,706153,[email protected],district4,9A7DBB180B84A7B710680C770A4BE328C92D577A,admin,<blank>,<blank>,district4,district 4
36,22309,[email protected],district5,E3C89F2CD9BA780AFFBF490EFC33176449CA6772,admin,<blank>,<blank>,district5,district 5
37,133319,[email protected],district6,B834CD72FA4C82E436BE4FF3ED4EFA4DB3FAE917,admin,<blank>,<blank>,district6,district 6
38,238710,[email protected],district7,051B0F4EA1D0038FB25B5C81E6CFB07E41136FBE,admin,<blank>,<blank>,district7,district 7
39,492081,[email protected],district8,C28FAEFB489126581EDF1081C08F7C3FDBD00B50,admin,<blank>,<blank>,district8,district 8
40,111268,[email protected],district9,209672B5AB0FC6D2D54B72AD3A6AEE026FD6252F,admin,<blank>,<blank>,district9,district 9
41,17283,[email protected],district1,093EF9073477ED1FE12C1A984EEE73659805A6BA,admin,<blank>,Enter Your Department,district1,City
52,580053,[email protected],Todd,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,superuser,<blank>,City Information Systems,Todd,city
53,261170,[email protected],claireh,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,URA,Claire Hosteny,ura
54,249687,[email protected],stearmanm,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,<blank>,Megan Stearman,URA
55,985628,[email protected],mltenenbaum,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,city finance,<blank>,Finance,Mary Lou Tenenbaum,City
56,575145,[email protected],ejacob,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,city finance,<blank>,Finance,Ed Jacob,City
57,366933,[email protected],lrhyne,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,<blank>,Lynda Rhyne,City
58,790819,[email protected],alopata,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,<blank>,Enter Your Department,Amanda Lopata,City
59,241045,[email protected],lellis,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,<blank>,Linda Ellis,City
60,298268,[email protected],dp test,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,<blank>,DP Test,law
62,621941,[email protected],cisadmin,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,<blank>,CIMS Admin,cis
63,950004,[email protected],ccolbert,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,Intern,City Information Systems,Cathleen,CIS
64,564001,[email protected],jsloss,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,City Information Systems,Jim Sloss,City
65,506794,[email protected],lbaxter,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,Admin,<blank>,City Information Systems,Lindsay Baxter,City
76,62170,[email protected],test,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,URA Users,<blank>,Building Inspection,test,<blank>
77,146575,[email protected],test2,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,URA Users,<blank>,Building Inspection,test2,URA
78,729406,[email protected],test3,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,URA Users,tester,Credit Union,test3,<blank>
79,90743,[email protected],abarnes,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,URA Users,<blank>,Enter Your Department,Alexis Barnes,ura
80,469691,[email protected],parksadmin,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,parksadmin,<blank>,Parks and Recreation,parksadmin,City
81,804023,[email protected],sturner,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,parksadmin,Parks Administration,Parks and Recreation,Sauntee Turner,City
82,114353,[email protected],landrews,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,URA Users,Planning and Development Specialist,Enter Your Department,Lena Andrews,ura
83,691777,[email protected],tstephenson,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,Assistant Director,City Information Systems,Tajuana Stephenson,City
84,111280,[email protected],sharris,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,Web and Network Manager,City Information Systems,Sylvia Harris,City
85,500989,[email protected],smartz,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,Planner,City Planning,Shelly Martz,City
88,284862,[email protected],mevanshura,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,Director of Community Affairs,Building Inspection,Mary Esther VanShura,Allegheny County
89,718630,[email protected],bmjohnson,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,Partnership Specialist,Building Inspection,Benita Johnson,United States Census Bureau
90,519285,[email protected],jkohnfelder,6C55803D6F1D7A177A0DB3EB4B343B0D50F9C111,admin,Administration,Enter Your Department,Jenny Kohnfelder,ura

██████████
█apps.csv█
██████████

id,link,app_name,menu_type,menu_name
3,modules/property/,property,m,property_management
4,modules/events/,events,m,enent_management
6,modules/system/,system,m,sysmngt
7,modules/cts/,cts,m,cts
12,users/,users,s,users
13,users/add.aspx,new user,a,new_user
14,modules/,modules,s,modules
15,permissions/,permissions,s,permissions
16,usergroups/,user groups,s,user_groups
17,groups/,groups,a,groups
18,organizations/,organizations,a,organizations
19,/mod/test,test,a,test
20,modules/ura_homes/,URA Homes,m,URA Homes
21,modules/gd/,Gift Disclosure,m,Gift Disclosure
22,modules/solarcity/,SolarCity,m,SolarCity
23,modules/ann,announcements,m,announcements
24,modules/uraprojects,URA Projects,m,URA Projects
25,modules/stimulus,stimulus,m,stimulus
26,modules/census,Count Me In,m,Count Me In

██████████████████
█anouncements.csv█
██████████████████

id,title,active,post_by,message,msg_date,time_stamp
5,Riverview Park Concert and Movie Cancelled,N,parkadmin,"<p>Due to inclement weather, the STARS AT RIVERVIEW CONCERT tonight at Riverview Park has been cancelled. Also due to inclement weather, the DOLLAR BANK CINEMA IN THE PARK at Riverview Park for tonight has been cancelled.</p>\r\n",06/20/2015,8:19 PM
6,Mellon Square Concert Cancelled,N,parkadmin,"<p>Due to inclement weather, today's Mellon Square Summer Concert featuring ""Scheer Element"" downtown has been cancelled.</p>\r\n",06/18/2015, 8:39am
7,Stars at Riverview Concert Cancelled,N,parkadmin,"Due to inclement weather, tonight's STARS AT RIVERVIEW JAZZ CONCERT has been cancelled.",06/20/2015,6:50 PM
8,"Bach, Beethoven and Brunch Concert Cancelled",N,parkadmin,"Due to inclement weather, today's BACH, BEETHOVEN AND BRUNCH CONCERT at Mellon Park has been cancelled.",08/03/2014,9:55 AM
9,Reservoir of Jazz Concert Cancelled,N,parkadmin,"Due to inclement weather, RESERVOIR OF JAZZ CONCERT has been cancelled.",6/9/2010,10:33 AM
10,Schenley Park Movie and Concert Cancelled,N,parkadmin,"<p>Due to inclement weather, Dollar Bank Cinema in the Park and Wednesday Night Concert at Schenley Park Flagstaff Hill have been cancelled.</p>\r\n",06/11/2014,6:30 p.m.
11,Highland Park Movie Cancelled,N,parkadmin,"Due to inclement weather, DOLLAR BANK CINEMA IN THE PARK in Highland Park has been cancelled.",06/09/2010,10:34 AM
12,West End Overlook Movie Cancelled,N,parkadmin,"<p>Due to inclement weather, tonight's DOLLAR BANK CINEMA IN THE PARK at the West End Overlook has been cancelled. Enjoy ""The Lego Movie"" at a different venue later this week: Thursday at Brookline Park, Friday at Arsenal Park, or Saturday at Grandview Park.</p>\r\n",07/14/2015,8:50 p.m.
13,Brookline Movie Cancelled,N,parkadmin,"<p>Due to inclement weather, tonight's Dollar Bank Cinema in the Park at Brookline Memorial Park has been cancelled. Enjoy ""Cantinflas"" tomorrow night at Arsenal Park in Lawrenceville, and Saturday night at Grandview Park in Mt. Washington.</p>\r\n",07/09/2015,8:51 PM
14,Arsenal Park Movie Cancelled,N,parkadmin,"<p>Due to inclement weather, tonight's DOLLAR BANK CINEMA IN THE PARK at Arsenal Park has been cancelled.</p>\r\n",07/03/2015,9:20PM
15,Grandview Park Movie Cancelled,N,parkadmin,"Due to inclement weather, DOLLAR BANK CINEMA IN THE PARK at Grandview Park has been cancelled.",6/9/2010,10:36 AM
16,RIVERVIEW PARK & GRANDVIEW PARK MOVIES CANCELED,N,parkadmin,"Due to inclement weather, tonight's Dollar Bank Cinema in the Park showings at Riverview Park & Grandview Park have  been cancelled.",07/19/2014,8:45 p.m.
17,Reservoir of Jazz and Schenley Park movie cancelled tonight,N,parkadmin,"Due to inclement weather, RESERVOIR OF JAZZ CONCERT at Highland Park has been cancelled.\r\n\r\nDue to inclement weather, CINEMA IN THE PARK at Schenley Park has been cancelled.\r\n",07/27/2012,8:30 a.m.
18,Schenley Park Concert & Movie Cancelled,N,parkadmin,"Due to severe weather, the following events this evening have been cancelled:\r\n\r\n*Dollar Bank Cinema in the Park at Flagstaff Hill*\r\n*Wednesday Night Concert at Flagstaff Hill*\r\n",08/07/2013,6:49p.m.
19,SCHENLEY PARK MOVIE CANCELED,n,parkadmin,"<p>Due to the continued threat of severe weather, tonight's Dollar Bank Cinema in the Park at Schenley Park Flagstaff Hill has been canceled. Tonight's movie ""Maleficent"" can be seen Tuesday night at the West End Overlook.</p>\r\n",06/14/2015,8:21pm
20,Roving Art Cart cancelled today,N,parkadmin,"Due to inclement weather, ROVING ART CART will not appear today.",07/11/2010,12:24 PM
21,Schenley Tennis Camp cancelled this morning,N,parkadmin,"Due to inclement weather: Summer Tennis Camp at Schenley cancelled for today Friday, August 9, 2013. Please email [email protected] to receive credit for this last camp day towards one of the weekly clinics at the Mellon Park Tennis Center (bubble). Thanks to all 2013 camp players for a great summer!",08/09/2013,7:35 a.m.
22,OUTDOOR POOLS & SPRAY PARKS,N,parkadmin,"Due to inclement weather, all Citiparks outdoor pools and spray parks will close at 4:45pm Wednesday.\r\n",07/10/2013,3:09 p.m.
25,SKATING RINK CONCLUDES 40th ANNIVERSARY SEASON,N,parkadmin,<p>The Schenley Park Skating Rink has closed for the season now that warm weather has arrived in Pittsburgh.  Thanks to all who participated in 2014/15 events and activities held in conjunction with the rink's celebration of its 40th season.</p>\r\n<p> </p>\r\n,03/13/2015,11 a.m.
27,Miniature Golf course closed,N,parkadmin,"Due to inclement weather, the SCHENLEY PARK MINIATURE GOLF COURSE is closed today.",08/03/2011,5:07 PM
28,CITIPARKS POOLS & SPRAY PARKS CLOSE EARLY ON WEDNESDAY,N,parkadmin,"Due to unseasonably cool temperatures, OUTDOOR POOLS and SPRAY PARKS close today at 4:45 p.m.",08/14/2013,3:15 p.m.
29,Spray Parks opening at NOON today,N,parkadmin,"Due to inclement weather, Spray Parks are closed this morning (Wednesday, July 10) and will OPEN AT NOON TODAY.\r\n\r\n",07/10/2013,9:00 a.m.
30,MELLON PARK SPRAY PARK TEMPORARILY CLOSED,N,parkadmin,<p>The Mellon Park Spray Park in Shadyside is temporarily closed due to mechanical problems. All other spray parks remain open.</p>\r\n,07/09/2014,6:00 p.m.
31,BIG LEAGUE SPORTS WEDNESDAY BASEBALL & SOFTBALL GAMES -- CANCELLED DUE TO WEATHER,N,parkadmin,"Due to the threat of high winds and severe weather, BIG LEAGUE Sports baseball and softball games on Wednesday, June 12, have been CANCELLED.",06/12/2013,1:45 p.m.
32,INCLEMENT WEATHER RESULTS IN CLOSURES- SPRAY PARKS & POOLS,N,parkadmin,"Due to inclement weather, ALL CITIPARKS SPRAY PARKS and OUTDOOR SWIMMING POOLS will be closed today, Saturday, July 19.",07/19/2014,1:45 p.m.
33,"WEATHER-RELATED CITIPARKS CLOSURES ON WED., JUNE 12, 2013",N,parkadmin,"Due to the threat of high winds and severe weather, the following Citiparks events and facilities on Wed., June 12, have been cancelled: ***** Schenley Park Wednesday evening CONCERT and MOVIE  ***** BIG League Sports Wednesday BASEBALL and SOFTBALL games.  ***** Oliver Bath House will close Wednesday at 4 p.m. ***** All Spray Parks will close Wednesday at 4 p.m. and remain closed on Thursday, June 13",06/12/2013,3:45 p.m.
34,SCHENLEY PARK MINIATURE GOLF COURSE OPEN ALL SUMMER!,N,parkadmin,Enjoy 18 holes of fun at the Schenley Park Skating Rink Tues - Fri 4 - 9 p.m. and Sat - Sun 1 - 9 p.m.,06/18/2012,3:00pm
35,SCHENLEY PARK POOL TEMPORARILY CLOSED FOR REPAIRS,N,parkadmin,<p>Schenley Park Pool is temporarily closed for repairs.</p>\r\n<p> </p>\r\n<p> </p>\r\n,06/26/2015,11:00 p.m.
36,"SEVERE WEATHER TO CANCEL SEVERAL CITIPARKS ACTIVITIES TODAY (THURSDAY, JULY 26)",N,parkadmin,"Due to the threat of severe thunderstorms in western Pennsylvania, Citiparks has postponed the following event on Thursday, July 26:  BIG LEAGUE CHAMPIONSHIP GAMES at PNC Park.  In addition, OUTDOOR SWIMMING POOLS will close at 2 p.m.\r\n\r\nCooling centers at four Citiparks centers will remain open until 7 p.m. this evening.",07/26/2012,1:55 PM
37,FRICK PARK RED CLAY JUNIOR OPEN,N,parkadmin,"Due to inclement weather, the Thursday, June 27, matches have been postponed until Friday, June 28.  All updates are available at www.ClayFrickTennis.org.",06/27/2013,3:00 p.m.
38,HIGHLAND PARK POOL TEMPORARILY CLOSED  FOR MAINTENANCE,N,parkadmin,<p>The Highland Park Pool is temporarily closed for maintenance.</p>\r\n<p> </p>\r\n,06/16/2015,10:30 a.m.
39,"""ALPHABET TRAIL AND TALES"" CANCELLED",N,parkadmin,"Due to inclement weather, ALPHABET TRAIL AND TALES at Frick Park on Saturday, Sept. 8, has been cancelled.",09/08/2012,7:45 AM
40,GREENFIELD HEALTHY ACTIVE LIVING CENTER CLOSED ON FRIDAY,N,parkadmin,"The Greenfield Healthy Active Living Center will be closed on Friday, June 21.  The center will reopen on Monday, June 24, at 8 a.m.",06/20/2013,4:00 p.m.
41,"Community Recreation Centers closing early on Wednesday, July 10 --- Cooling Islands at HAL centers to remain open",N,parkadmin,"Due to severe weather, Citiparks COMMUNITY RECREATION CENTERS will CLOSE at 6 p.m. on Wednesday, July 10, and all programming is cancelled for this afternoon and evening.  COOLING ISLANDS at Healthy Active Living Centers will REMAIN OPEN.\r\n",07/10/2013,3:20 p.m.
42,Weather-relating Closings: 12/26/12,N,parkadmin,"Citiparks, Healthy Active Living Centers for Seniors will close early today and reopen tomorrow at 10:00 am. \r\nRecreation Centers will close at 2pm all nighttime activities are cancelled. Programs will resume their regular schedule tomorrow 12/27/2012.",12/26/2012,12/26/12
43,CITIPARKS 60+ SUMMER GAMES -- SCHEDULE CHANGE FOR THURSDAY -- HORSESHOES,N,parkadmin,"The HORSESHOES competition -- originally scheduled for Thursday, June 13 -- has been re-scheduled to take place instead on Thursday, June 20, from 10 a.m. - 2 p.m. at the West End Healthy Active Living Center.",06/12/2013,9:00 a.m.
44,CITIPARKS 60+ WINTER GAMES -- SCHEDULE CHANGE FOR SATURDAY -- POOL,N,parkadmin,"The 8-ball POOL competition -- originally scheduled for Saturday, January 26 -- has been re-scheduled to take place on a later date to be announced.",01/25/2013,10:40 a.m.
45,BASKETBALL LEAGUE -- WEEKEND GAMES CANCELLED,N,parkadmin,"Citiparks Youth Traveling Basketball League Games cancelled for Saturday, January 26",01/25/2013,4:15 p.m.
46,JEFFERSON RECREATION CENTER CLOSED TEMPORARILY,N,parkadmin,"<p>Beginning Monday, July 13 Jefferson Recreation Center on the Northside will be temporarily closed for emergency repair. For any questions, please call Jefferson Recreation Center at 412-422-6543. We apologize for the inconvenience.</p>\r\n",07/10/2015,1:14 p.m.
47,"OUTDOOR POOLS TO CLOSE ONE HOUR EARLY ON SUNDAY, JULY 19",n,parkadmin,"<p>Due to special programming, all outdoor swimming pools will close at 4:45 p.m. on Sunday, July 19.  All pools will resume normal operating hours on Monday.</p>\r\n<p><br type=""_moz"" />\r\n </p>\r\n",07/17/2015,8:00 p.m.
48,SPRAY PARKS CLOSED THIS WEEKEND,N,parkadmin,"<p>Due to inclement weather, all Citiparks SPRAY PARKS will be closed on Saturday, Sept. 12, and Sunday, Sept. 13.</p>\r\n<p> </p>\r\n<p> </p>\r\n<p> </p>\r\n",09/12/2015,9:00 a.m.
49,60+ SUMMER GAMES UPDATE,N,parkadmin,"Due to inclement weather, the GOLF (9 holes) COMPETITION HAS BEEN POSTPONED and will not take place on June 10 as scheduled.  The make-up date is Monday, June 17.",06/10/2013,8:00 a.m.
50,DOLLAR BANK JUNIOR GREAT RACE CANCELLED,N,parkadmin,"<p>Due to severe weather, the Sept. 21 Dollar Bank Junior Great Race at Point State Park has been cancelled. For more information, visit <a href=""http://www.rungreatrace.com/junior_great_race.html"">http://www.rungreatrace.com/junior_great_race.html</a>.</p>\r\n",09/21/2013,10:00 a.m.
51,SATURDAY'S RIVERVIEW PARK SOCCER FIELD RIBBON CUTTING – CANCELLED,N,parkadmin,"<p>Due to inclement weather, the Riverview Park Soccer Field dedication ceremony, scheduled for Dec. 7 at Noon, has been cancelled.</p>\r\n",12/07/2013,8:30 a.m.
52,"WINTER WEATHER  UPDATE -- four ""warming centers"" open Wednesday until 6 p.m.",N,parkadmin,"<p>Due to extreme cold weather, the City of Pittsburgh is operating four ""warming centers"" from 10 a.m. -  6 p.m. on Wednesday, Jan. 13.  Individuals can visit Citiparks Healthy Active Living centers in Greenfield, Homewood, Sheraden and South Side (Market House).  </p>\r\n",01/13/2016,10:00 a.m.
53,BEECHVIEW SENIOR CENTER TEMPORARILY CLOSED,N,parkadmin,"<p>Due to mechanical difficulties, the Healthy Active Living center in Beechview is temporarily closed.</p>\r\n<p> </p>\r\n",02/17/2015,11:00 a.m.
54,2014 O'CONNOR TENNIS CLASSIC MATCH SCHEDULE AVAILABLE,N,parkadmin,"<p>Match schedule available for 8th annual Bob O'Connor Summer Tennis Classic available by visiting <a href=""http://tennislink.usta.com/Tournaments/TournamentHome/Tournament.aspx?T=141333"">http://tennislink.usta.com/Tournaments/TournamentHome/Tournament.aspx?T=141333</a></p>\r\n",06/13/2014,2:30 p.m.
55,Friday Night 7pm-10pm Inner City Junior Tennis Program Clinics Cancelled Today,N,parkadmin,"<p>Due to inclement weather, today Friday, January 22, 2016, the 7pm-10pm Inner City Junior Tennis Program Clinics at the Mellon Park Tennis Bubble have been CANCELLED.</p>\r\n",01/22/2016,6:30pm
56,CITIPARKS SWIMMING POOLS & SPRAY PARKS CLOSED ON WEDNESDAY,N,parkadmin,"<p>Due to inclement weather, Citiparks outdoor swimming pools and spray parks will be closed on Wednesday, August 13.</p>\r\n<p> </p>\r\n",08/13/2014,2:45 p.m.
57,SCHENLEY PARK MINIATURE GOLF COURSE -- closed this weekend,N,parkadmin,"<p>Due to the Vintage Grand Prix, the Schenley Park Miniature Golf Course will be closed Friday, Saturday and Sunday (July 18, 19 and 20). </p>\r\n",07/16/2014,11:30 a.m.
58,OLIVER BATH HOUSE TEMPORARILY CLOSED FOR REPAIRS,N,parkadmin,<p>The Oliver Bath House indoor swimming pool is temporarily closed for repairs. </p>\r\n<p> </p>\r\n<p> </p>\r\n<p> </p>\r\n,09/16/2015,4:00 p.m.
59,INDOOR TENNIS CENTER TEMPORARILY CLOSED FOR SEASONAL MAINTENANCE,N,parkadmin,"<p>The Mellon Park Tennis Center is temporarily closed for seasonal maintenance.  The indoor tennis facility will reopen Sunday, October 4, for the beginning of the 2015-2016 winter season.</p>\r\n",09/28/2015,8:00 a.m.
60,SCHENLEY RINK HOSTING ANNIVERSARY CELEBRATION THIS WEEKEND,N,parkadmin,"<p>The Schenley Park Skating Rink celebrates its 40th anniversary season this weekend with ""FLASHBACK FRIDAY"" (1975 music) at 7 & 9:30 p.m. skating sessions and ""SEVENTIES SATURDAY"" (1970s music) at 7 & 9:30 p.m. skating sessions.  Sunday afternoon at 2 p.m. the Schenley Classic hockey game will take place, with admission $5/person to benefit rink renovation.  <em>Regular Sunday afternoon skating sessions at 1:30 & 4 p.m. will not take place this week.  </em></p>\r\n",01/23/2015,9:30 a.m.
62,SCHENLEY PARK SKATING RINK CELEBRATES 40th SEASON -- Special event on Saturday evening,N,parkadmin,"<p>The Schenley Park Skating Rink's 40th anniversary celebration features VALENTINES ON ICE on Saturday evening.  The ADULTS-ONLY EVENT takes place on February 14 from 7 - 10 p.m.  <strong>Please note:  Because of the special event, the rink will <em>NOT</em> offer its standard 7 - 9 and 9:30 - 11:30 p.m. sessions on Saturday, February 14.</strong></p>\r\n<p> </p>\r\n",02/14/2015,11:00 a.m.
63,"ROVING ART CART CANCELLED FOR TUESDAY, JUNE 16",N,parkadmin,"<p>Due to inclement weather, the Roving Art Cart appearance on Tuesday, June 16, as been cancelled.  ROVING ART CART APPEARANCES WILL RESUME ON WEDNESDAY.</p>\r\n",06/16/2015,8:30 a.m.
64,OLIVER BATH HOUSE CLOSED ON SATURDAY,N,parkadmin,"<p>Due to weather conditions, the Oliver Bath House indoor swimming pool is closed on Saturday, January 23.<br type=""_moz"" />\r\n </p>\r\n",01/23/2016,10:15 a.m.
65,"""THE GREAT RACE"" TAKES PLACE THIS WEEKEND",N,parkadmin,"<p>Register today for Pennsylvania's largest 10K -- THE GREAT RACE -- or the 5K run/walk, all taking place on Sunday, Sept. 27.  Registration continues Friday and Saturday at The Great Race Expo at the David L. Lawrence Convention Center.  For details, visit. www.RunGreatRace.com.</p>\r\n<p> </p>\r\n",09/25/2015,9:00 a.m
66,SCHENLEY PARK SKATING RINK OPEN FOR 2015/16 SEASON!,N,parkadmin,"<p>The Schenley Park Skating Rink is open for the 2015/16 season.  THE 29th ANNUAL CITIPARKS ""MASCOT SKATE"" WILL FEATURE 30+ beloved mascots on Saturday, January 9, from 1:30 - 3:30 p.m.</p>\r\n",12/28/2015,12:01 a.m.
67,SCHENLEY RINK OPENING DELAYED,N,parkadmin,"<p>Due to unseasonably warm weather in December, the opening of the Schenley Park Skating Rink has been delayed.  Opening date to be announced soon.</p>\r\n",12/11/2015,10:00 a.m.
68,test,N,webmastera,<p>test</p>\r\n,01/21/2016,8:00 am

█████████████████
█cims_groups.csv█
█████████████████

id,group_name
1,superuser
10,testers
16,devess
20,new one
21,admin
22,URA Users
23,parksadmin
24,city finance

██████████████████████
█usrs_permissions.csv█
██████████████████████

upid,appid
17283,7
22309,7
111268,7
111280,26
133319,7
238710,7
241045,3
284862,26
298268,21
300042,13
300042,14
300042,15
300042,17
300042,12
366933,3
469691,23
492081,7
500989,26
506794,22
550296,4
564001,22
576992,3
580053,17
580053,13
580053,15
621941,12
657485,7
691777,26
706153,7
713424,7
713424,12
713424,6
713424,13
718630,26
733179,12
733179,18
733179,15
733179,14
733179,16
733179,17
790819,3
832204,7
950004,22

██████████
█misc.csv█
██████████

data,data2
adm:x:3:4:adm:/var/adm:/sbin/nologin,<blank>
adm:x:3:4:adm:/var/adm:/sbin/nologin,<blank>
apache:x:48:48:Apache:/var/www:/sbin/nologin,<blank>
apache:x:48:48:Apache:/var/www:/sbin/nologin,<blank>
avahi-autoipd:x:100:103:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin,<blank>
avahi-autoipd:x:100:103:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin,<blank>
avahi:x:70:70:Avahi daemon:/:/sbin/nologin,<blank>
avahi:x:70:70:Avahi daemon:/:/sbin/nologin,<blank>
bin:x:1:1:bin:/bin:/sbin/nologin,<blank>
bin:x:1:1:bin:/bin:/sbin/nologin,<blank>
daemon:x:2:2:daemon:/sbin:/sbin/nologin,<blank>
daemon:x:2:2:daemon:/sbin:/sbin/nologin,<blank>
dbus:x:81:81:System message bus:/:/sbin/nologin,<blank>
dbus:x:81:81:System message bus:/:/sbin/nologin,<blank>
drwx------ 2 postgres postgres  4096 Feb  3  2009 pg_log,<blank>
drwx------ 2 postgres postgres  4096 Jan 28  2009 pg_tblspc,<blank>
drwx------ 2 postgres postgres  4096 Jan 28  2009 pg_twophase,<blank>
drwx------ 2 postgres postgres  4096 Sep  3 09:37 pg_clog,<blank>
drwx------ 2 postgres postgres  4096 Sep  7 11:52 pg_subtrans,<blank>
drwx------ 2 postgres postgres  4096 Sep  7 11:58 global,<blank>
drwx------ 3 postgres postgres  4096 Sep  2 08:57 pg_xlog,<blank>
drwx------ 4 postgres postgres  4096 Jan 28  2009 pg_multixact,<blank>
drwx------ 6 postgres postgres  4096 Mar  3  2010 base,<blank>
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin,<blank>
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin,<blank>
games:x:12:100:games:/usr/games:/sbin/nologin,<blank>
games:x:12:100:games:/usr/games:/sbin/nologin,<blank>
gdm:x:42:42::/var/gdm:/sbin/nologin,<blank>
gdm:x:42:42::/var/gdm:/sbin/nologin,<blank>
gopher:x:13:30:gopher:/var/gopher:/sbin/nologin,<blank>
gopher:x:13:30:gopher:/var/gopher:/sbin/nologin,<blank>
haldaemon:x:68:68:HAL daemon:/:/sbin/nologin,<blank>
haldaemon:x:68:68:HAL daemon:/:/sbin/nologin,<blank>
halt:x:7:0:halt:/sbin:/sbin/halt,<blank>
halt:x:7:0:halt:/sbin:/sbin/halt,<blank>
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin,<blank>
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin,<blank>
mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin,<blank>
mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin,<blank>
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin,<blank>
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin,<blank>
mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash,<blank>
mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash,<blank>
news:x:9:13:news:/etc/news:,<blank>
news:x:9:13:news:/etc/news:,<blank>
nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin,<blank>
nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin,<blank>
nobody:x:99:99:Nobody:/:/sbin/nologin,<blank>
nobody:x:99:99:Nobody:/:/sbin/nologin,<blank>
nocadmin:x:503:503:NOC Admin:/home/nocadmin:/bin/bash,<blank>
nocadmin:x:503:503:NOC Admin:/home/nocadmin:/bin/bash,<blank>
nscd:x:28:28:NSCD Daemon:/:/sbin/nologin,<blank>
nscd:x:28:28:NSCD Daemon:/:/sbin/nologin,<blank>
ntp:x:38:38::/etc/ntp:/sbin/nologin,<blank>
ntp:x:38:38::/etc/ntp:/sbin/nologin,<blank>
operator:x:11:0:operator:/root:/sbin/nologin,<blank>
operator:x:11:0:operator:/root:/sbin/nologin,<blank>
oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin,<blank>
oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin,<blank>
pcap:x:77:77::/var/arpwatch:/sbin/nologin,<blank>
pcap:x:77:77::/var/arpwatch:/sbin/nologin,<blank>
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash,<blank>
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash,<blank>
root:x:0:0:root:/root:/bin/bash,<blank>
root:x:0:0:root:/root:/bin/bash,<blank>
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin,<blank>
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin,<blank>
rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin,<blank>
rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin,<blank>
rpm:x:37:37::/var/lib/rpm:/sbin/nologin,<blank>
rpm:x:37:37::/var/lib/rpm:/sbin/nologin,<blank>
-rw------- 1 postgres postgres     0 Sep  7 11:58 blahfile,<blank>
-rw------- 1 postgres postgres 13699 Apr 16  2009 postgresql.conf,<blank>
-rw------- 1 postgres postgres  1460 Jan 28  2009 pg_ident.conf,<blank>
-rw------- 1 postgres postgres  3665 Mar 14 11:55 pg_hba.conf,<blank>
-rw------- 1 postgres postgres    45 Sep  7 09:52 postmaster.pid,<blank>
-rw------- 1 postgres postgres     4 Jan 28  2009 PG_VERSION,<blank>
-rw------- 1 postgres postgres    57 Sep  7 09:52 postmaster.opts,<blank>
-rw------- 1 root     root      3226 Jan 28  2009 pg_hba.conf.orig,<blank>
sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin,<blank>
sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin,<blank>
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown,<blank>
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown,<blank>
smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin,<blank>
smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin,<blank>
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin,<blank>
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin,<blank>
sync:x:5:0:sync:/sbin:/bin/sync,<blank>
sync:x:5:0:sync:/sbin:/bin/sync,<blank>
total 144,<blank>
uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin,<blank>
uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin,<blank>
vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin,<blank>
vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin,<blank>
xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin,<blank>
xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin,<blank>
<blank>,<blank>
<blank>,<blank>rwx 1 root root          13 Oct 22  2009 authconfig-gtk -> consolehelper
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root          13 Oct 22  2009 authconfig-tui -> consolehelper
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        7663 Oct 13  2006 autoconf
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        8123 Oct 13  2006 autoheader
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       30244 Oct 13  2006 autom4te
<blank>,<blank>
<blank>,-rwxr-xr-x 2 root root      221993 Mar  1  2010 automake
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      199948 Feb 16  2010 automake-1.4
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      215990 Feb 16  2010 automake-1.5
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      236997 Feb 16  2010 automake-1.6
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      270957 Feb 26  2010 automake-1.7
<blank>,<blank>
<blank>,-rwxr-xr-x 2 root root      221993 Mar  1  2010 automake-1.9
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       19057 Oct 13  2006 autoreconf
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       16338 Oct 13  2006 autoscan
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       33094 Oct 13  2006 autoupdate
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           8 Oct 22  2009 autovbox -> vboxcnvt
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root          14 Jan 23  2009 awk -> ../../bin/gawk
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       10296 Dec 10  2007 b2m
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      116024 Dec 21  2007 baobab
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       26264 Feb 23  2010 base64
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        6969 Oct 21  2008 bashbug-64
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root         975 Nov 16  2009 batch
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       78080 Jul 13  2006 bc
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       24112 Jul 12  2006 bcc
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       10376 Jul 14  2006 bdftopcf
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root         173 Aug  9 11:40 bdftops
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        2593 Jul 14  2006 bdftruncate
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       10232 Apr 16  2009 bioradtopgm
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      257296 Jul 12  2006 bison
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       16688 Jun 22 21:21 bmp2tiff
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       22360 Apr 16  2009 bmptopnm
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           8 Oct 22  2009 bmptoppm -> bmptopnm
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       23584 Sep  4  2006 bonobo-activation-run-query
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       48240 Sep  4  2006 bonobo-browser
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        5410 Sep  4  2006 bonobo-slay
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        9032 Apr 16  2009 brushtopbm
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       39112 Oct 18  2006 bt-applet
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       80208 Oct 18  2006 bug-buddy
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        1539 Sep 19  2006 build-classpath
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root         383 Sep 19  2006 build-classpath-directory
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        1572 Sep 19  2006 build-jar-repository
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           5 Jan 27  2009 bunzip2 -> bzip2
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           4 Jan 23  2009 byacc -> yacc
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           5 Jan 27  2009 bzcat -> bzip2
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           6 Jan 27  2009 bzcmp -> bzdiff
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        2128 Sep 10  2008 bzdiff
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        1677 Sep 10  2008 bzgrep
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       35216 Sep 10  2008 bzip2
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       13304 Sep 10  2008 bzip2recover
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           6 Jan 27  2009 bzless -> bzmore
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        1259 Sep 10  2008 bzmore
<blank>,<blank>
<blank>,-rwxr-xr-x 4 root root      221736 Dec  9  2009 c++
<blank>,<blank>
<blank>,-rwxr-xr-x 2 root root       36601 May 31 08:40 c2ph
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root         224 Dec  9  2009 c89
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root         215 Dec  9  2009 c99
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      109456 Dec  1  2006 cadaver
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       19360 Jan  7  2010 cal
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       40959 Nov 11  2009 callgrind_annotate
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       13662 Nov 11  2009 callgrind_control
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      109376 Apr 16  2009 cameratopam
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root          30 Jan 23  2009 cancel -> /etc/alternatives/print-cancel
<blank>,<blank>
<blank>,?--------- ? ?    ?              ?            ? cancel.cups
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       34128 Jun  8  2009 capifax
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       34952 Jun  8  2009 capifaxrcvd
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root       14640 Jun  8  2009 capiinfo
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           3 Jan 23  2009 captoinfo -> tic
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        7998 Jan 15  2008 card
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        3368 Jul 16 04:36 catchsegv
<blank>,<blank>
<blank>,lrwxrwxrwx 1 root root           3 Sep  7 09:33 cc -> gcc
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root        5041 Jul 18  2006 ccmakedep
<blank>,<blank>
<blank>,-rwxr-xr-x 1 root root      292008 Oct  3  2008 cdda2wav
<blank>,-rwxr-xr-x 1 root root       71784 Oct 18  2006 cddb-slave2-properties
<blank>,-rwxr-xr-x 1 root root       40880 Jul 12  2006 cdparanoia
<blank>,-rwxr-xr-x 1 root root      624136 Aug 21  2006 cdrdao
<blank>,-rwxr-xr-x 1 root root      368408 Oct  3  2008 cdrecord
<blank>,-rwxr-xr-x 1 root root       52312 Jan 28  2008 cdrwtool
<blank>,-rwxr-xr-x 1 root root      174088 Apr 30 13:54 certutil
<blank>,-rwxr-xr-x 1 root root       82152 Jan 14  2010 c++filt
<blank>,-rwxr-xr-x 1 root root       32064 Nov 11  2009 cg_annotate
<blank>,-rwxr-xr-x 1 root root       59956 Nov 11  2009 cg_merge
<blank>,-rwxr-xr-x 1 root root       14392 Oct 27  2009 chacl
<blank>,?--------- ? ?    ?              ?            ? chage
<blank>,lrwxrwxrwx 1 root root           9 Jan 23  2009 charmap -> gucharmap
<blank>,-rwxr-xr-x 1 root root       13096 Jun 30  2009 chattr
<blank>,-rwxr-xr-x 1 root root       13223 Jan  7  2010 chcat
<blank>,-rwxr-xr-x 1 root root       23872 Feb 23  2010 chcon
<blank>,-rwxr-xr-x 1 root root        3329 Sep 19  2006 check-binary-files
<blank>,-rwxr-xr-x 1 root root      269720 Nov  9  2009 checkmodule
<blank>,?--------- ? ?    ?              ?            ? checkpolicy
<blank>,?--------- ? ?    ?              ?            ? chfn
<blank>,-rwxr-xr-x 1 root root       12992 Jan  7  2010 chrt
<blank>,?--------- ? ?    ?              ?            ? chsh
<blank>,-rwxr-xr-x 1 root root        9592 Sep  8  2008 chvt
<blank>,-rwxr-xr-x 1 root root       85080 Jul 12  2006 ci
<blank>,-rwxr-xr-x 1 root root       15848 Jul  9  2008 ciptool
<blank>,-rwxr-xr-x 1 root root       28600 Jul 27  2006 cjpeg
<blank>,-rwxr-xr-x 1 root root       23440 Feb 23  2010 cksum
<blank>,-rwxr-xr-x 1 root root       13219 Sep 19  2006 clean-binary-files
<blank>,-rwxr-xr-x 1 root root         615 Jul 18  2006 cleanlinks
<blank>,-rwxr-xr-x 1 root root        7864 Aug 31  2006 clear
<blank>,-rwxr-xr-x 1 root root       43736 May 14 13:04 clusterdb
<blank>,-rwxr-xr-x 1 root root       22728 Jan 15  2008 cmp
<blank>,-rwxr-xr-x 1 root root      122488 Apr 30 13:54 cmsutil
<blank>,-rwxr-xr-x 1 root root        9528 Apr 16  2009 cmuwmtopbm
<blank>,-rwxr-xr-x 1 root root       83392 Jul 12  2006 co
<blank>,-rwxr-xr-x 1 root root       13960 Jan  7  2010 col
<blank>,-rwxr-xr-x 1 root root       10824 Jan  7  2010 colcrt
<blank>,-rwxr-xr-x 1 root root       17503 Jul 12  2006 collateindex.pl
<blank>,-rwxr-xr-x 1 root root        8528 Jan  7  2010 colrm
<blank>,-rwxr-xr-x 1 root root       14032 Jan  7  2010 column
<blank>,lrwxrwxrwx 1 root root           9 Jan 23  2009 combinediff -> interdiff
<blank>,-rwxr-xr-x 1 root root       23952 Feb 23  2010 comm
<blank>,-rwxr-xr-x 1 root root       12816 Aug 19 08:08 compare
<blank>,-rwxr-xr-x 1 root root        1063 Jun 30  2009 compile_et
<blank>,-rwxr-xr-x 1 root root       14000 Jan 15  2008 composeglyphs
<blank>,-rwxr-xr-x 1 root root       12760 Aug 19 08:08 composite
<blank>,-rwxr-xr-x 1 root root       12760 Aug 19 08:08 conjure
<blank>,-rwxr-xr-x 1 root root       59792 Jun 28  2007 conman
<blank>,-rwxr-xr-x 1 root root        5450 Jun 28  2007 conmen
<blank>,-rwxr-xr-x 1 root root        8640 Sep  8  2008 consolehelper
<blank>,-rwxr-xr-x 1 root root       31024 Sep  8  2008 consolehelper-gtk
<blank>,-rwxr-xr-x 1 root root       12760 Aug 19 08:08 convert
<blank>,-rwxr-xr-x 1 root root        3840 May 31 08:40 cpan
<blank>,-rwxr-xr-x 1 root root      221736 Dec  9  2009 cpp
<blank>,lrwxrwxrwx 1 root root          13 Jan 23  2009 cpufreq-selector -> consolehelper
<blank>,-rwxr-xr-x 1 root root     4358184 Jun  8 15:19 crash
<blank>,-rwxr-xr-x 1 root root       30536 Oct 18  2006 create-branching-keyboard
<blank>,-rwxr-xr-x 1 root root       43784 May 14 13:04 createdb
<blank>,-rwxr-xr-x 1 root root        4656 Sep 19  2006 create-jar-links
<blank>,-rwxr-xr-x 1 root root       48240 May 14 13:04 createlang
<blank>,-rwxr-xr-x 1 root root       46808 May 14 13:04 createuser
<blank>,-rwxr-xr-x 1 root root      134776 Apr 30 13:54 crlutil
<blank>,-rwxr-xr-x 1 root root        1355 Jul 13  2006 croco-0.6-config
<blank>,?--------- ? ?    ?              ?            ? crontab
<blank>,-rwxr-xr-x 1 root root      329168 May 14  2009 cscope

███████████████
█exhibitor.csv█
███████████████

id,city,email,phone,state,website,zipcode,contact,address,pub_agree,resources,organization
1,Pittsburgh,[email protected],412-885-7017,PA,www.wesleyspectrum.org,15236,Barb Saunders,5250 Caste Drive,yes,"Special Education, Mental Health Programming which includes School-based, Outpatient, In-home Family Services, and Autism Services",Wesley Spectrum Services
2,Pittsburgh,[email protected],(412) 657-7984,PA,www.enjeuxcarriere.com,15221,Robert Dove,406 Burlington Road,on,"I will be promoting the use of ""CARISM; A Practical Guide to Managing Your Career by Objectives.""  This is a workbook being used in afterschool programs in the Pittsburgh area to increase the likelihood of students staying in school based on actively engaging them in choosing a career path and understanding what is needed to help them realize their dreams.  See web site reference www.enjeuxcarriere.com.",WD & E Consulting LLC
3,PITTSBURGH,[email protected],412-362-8580,PA,n/a,15224,BILL WOODWARD,5321 PENN AVENUE,on,"resume writing, job search assistance, computer literacy training, computer access for employment databases and applying online for open jobs",EASTSIDE NEIGHBORHOOD EMPLOYMENT CENTER
4,Springdale,[email protected],724-864-2412,PA,www.cispac.org,15144,Nicole Molinaro,494 Pittsburgh Street,on,"Dropout prevention and intervention services through partnership with schools to serve at-risk students from 1st grade through age 21. Specifically, CIS works in schools, facilitates after-school programming, and operates alternative learning academies.",Communities In Schools
5,Pittsburgh,[email protected],412 456 4169,PA,<blank>,15222,Jerry Cozewith,307 Fourth Ave. Suite 500,YES,High School youth entrepreneurship and business creation,Entrepreneuring Youth
6,Pittsburgh,[email protected],412-390-2256,PA,www.youthLINKpittsburgh.org,15203,Tiffanee Heywood,2600 E Carson St,off,work with youth 14-21,Youth LINK
7,Pittsburgh,[email protected],412-417-6107,PA,www.operationhope.org,15236,Bill Long,p.o. box 18402,YES,financial literacy,Operation HOPE
8,Pittsburgh,[email protected],412-531-6200,PA,<blank>,15205,Debbie Bier,215 Beecham Dr.,off,Post Secondary tech training,Rosedale Technical Institute
9,Pittsburgh,[email protected],412 650-9004,PA,www.phase4learningcenter.org,15123,Terrie Suica-Reed,3075 Clairton Road,on,"PHASE 4 Learning Centers, Inc. operates four education centers in Western PA serving students in grades 8 thru 12.  The PHASE 4 Alternative Education program focuses on the academic, social, emotional and future needs of students who are referred by their public schools.  Students utilize computer-delivered courses combined with teachers and tutors to support academic improvement.  At the same time, behavioral plans are implemented for each student addressing a range of issues that often prevent students from succeeding in the comprehensive school setting.  In addition to the alternative education program, PHASE 4 also operates Diploma Retrieval Programs for students who have withdrawn from public school.",PHASE 4 Learning Center
10,Pittsburgh,[email protected],412-288-3900 x228,PA,www.pa-ementor.org and www.smartfutures.org,15222,Romy Banks,401 Wood Street,on,"Smart Futures provides online career development resources to schools and training providers designed to motivate and quide students towards postsecondary and career success.  Programs include Keys2Work, My Career Journey, PA eMentoring and Financial Literacy 101.  Our newest program PA eMentoring connects working adults with high school aged youth via a secure online system.  With the help of their eMentor, students complete 10 activities that lead to a personal postsecondary education and career plan.",Smart Futures
12,Pittsburgh,[email protected],412 323 4000 x142,PA,www.bidwell-training.org,15233,Bridgette Kennedy,1815 Metropolitan Street,on,"An accredited, nonprofit educational organization that offers effective career training and career placement at no cost to students. Each qualified student receives a full scholarship that includes tuition and books.",Bidwell Training Center
13,Pittsburgh,[email protected],412-255-2258 x55567,PA,<blank>,15219,Stephen Zumbrun,414 Grant St.,off,<blank>,City of Pittsburgh
14,sss,[email protected],ss,PA,ffff,sss,Dave,ssss,off,fffff,CIS
15,ddd,[email protected],333333333 x 333,PA,eee,ddd,David,ddd,off,eee,ddd
16,4455bb,[email protected],15551212 x 45678,PA,ss,44,Dave's namehhh,444,yes,ghjfgxjggyyg,"test"
17,Pittsburgh,[email protected],412-552-7100,PA,http://www.careerlinkpittsburgh.com/index_flash.html,15219,James Brenner,"Reg. Ent. Tower, Suite 2200, 425 Sixth Ave.",on,"CareerLink is a one-stop employment center that connects employers and job seekers in the most efficient manner possible. CareerLink  sites are located downtown Pittsburgh, Forest Hills, Robinson Township and South Side, offering a wide range of materials, consultation services, and on-line access to a comprehensive database of employment information.",CareerLink
18,Pittsburgh,[email protected],412-338-3704,PA,www.pghboe.net,15219,Sally Mole,1501 Bedford Avenue - Room 100,on,"Pamplets describing the ELECT Teen Parenting Program. Informational pamplets for parents/children around a variety of topics such as nutrition, child care etc.",Pittsburgh Public Schools - ELECT Teen Parenting Program
19,Pittsburgh,[email protected],412-441-8665,PA,http://pittsburgh.jobcorps.gov,15206,Dottie Sweeney,7175 Highland Drive,on,GED/High School Diplomas\r\n10 trades on center\r\nCollege program for 500 students at CCAC campuses\r\nDriver's Education,Pittsburgh Job Corps Center
20,Pittsburgh,[email protected],412-281-7605,PA,Pittsburghpromise.org,15219,Shawn Butler,1901 Centre Avenue; Suite 204,on,Scholarships for graduates of Pittsburgh Public High Schools,The Pittsburgh Promise
21,Pittsburgh,[email protected],412-922-6500,PA,www.storehouseforteachers.org,15220,Justin Brown,317 South Main Street,yes,Storehouse for Teachers is a nonprofit organization with a mission to serve kids and their teachers by providing a resource center where school and classroom supplies are distributed to teachers at no cost.,Storehouse for Teachers
22,Pittsburgh,[email protected],412-820-0100,PA,www.contactpgh.org,15224,James Earl Doyle,PO Box 9095,yes,"Student and Young Adult Hotline:\r\n\r\nOur Student and Young Adult line is incorporated into our 24-hour Crisis and Suicide hotline and provides a resource for any young person to connect with if they feel they are in crisis or in need of emotional support.  The hotline is staffed by trained volunteers 24-hours a day 7 days a week.\r\n\r\nWe also offer suicide intervention skills training to the local community including school ""gatekeepers""",CONTACT Pittsburgh

█████████████████
█participant.csv█
█████████████████

id,info,city,name,title,email,phone,state,zipcode,address,info_list,org_school
1,Administrator,Pittsburgh,Dr. Julia Stewart,Executive Director Career & Technical Education,[email protected],412-338-8090,PA,15219,1501 Bedford Avenue,Teacher - School,Pittsburgh Public Schools
2,Administration,Pittsburgh,Pat Gambridge,Coordinator of Program Improvement for Career & Technical Education,[email protected],412-338-8130,PA,15219,1501 Bedford Avenue,Teacher - School,Pittsburgh Public Schools
3,<blank>,Pittsburgh,Mikhail Pappas,Policy and Projects Liaison,[email protected],412.621.3006,PA,15201,3519 Butler Street,Public Offical,"Senator Jim Ferlo, 38th District"
4,college administrator,Pittsburgh,Charles Blocksidge,"Executive Director,CCAC-Allegheny County Workforce Alliance",[email protected],412.350.1199,PA,15219,"CCAC - Regional Enterprise Tower, 425 Sixth Avenue, Suite 700",Teacher - School,CCAC
5,<blank>,Pittsburgh,Holly M. McGraw,"Program Manager, Youth Engaged in Service",[email protected],412.715.9451,PA,15222,"239 Fourth Avenue, Suite 1007",Non Profit,Pittsburgh Cares
6,<blank>,Pittsburgh,Kathy Fine,<blank>,[email protected],412-417-8071,PA,15206,901 N. Highland Avenue,Community Leader,PURE Reform
7,<blank>,Irwin,Megan Schreck,<blank>,[email protected],412-720-9737,PA,15642,289 Bethel Rd,Teacher - School,Academy Charter School/ Pittsburgh Cares
8,<blank>,Homestead,Dennis Robinson,Asst. Director of Education,[email protected],412 462 0243,PA,15120,120 E. 9th Avenue,Teacher - School,Auberle
9,<blank>,Pittsburgh,Jerry M Cozewith,President,[email protected],412 456 4169,PA,15222,307 Fourth Avenue Suite 500,Non Profit,Entrepreneuring Youth
10,<blank>,Pittsburgh,C Dianne Colbert,<blank>,[email protected],412-784-0166,PA,15201,103 Elena Ct,Non Profit,"Delta Sigma Theta, Inc.  Pgh. Alumnae"
11,"CEOs for Cities, cons. to urban ed.",Pittsburgh,Sally Mizerak,Pres.,[email protected],412-343-4173,PA,15216,118 Marlin Drive W,Community Leader,Performance Drivers Inc
12,<blank>,Pittsburgh,Micah Frankenfield,Project Coordinator,[email protected],412-552-7087,PA,15219,"425 Sixth Avenue, Suite 650",Non Profit,Three Rivers Workforce Investment Board
14,<blank>,Pittsburgh,Shannon Flohr,Student,[email protected],(412)651-7568,PA,15210,125 Fitler Street,Youth,Carrick High School
15,<blank>,Pittsburgh,Saleem Ghubril,Executive Director,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
16,<blank>,Pittsburgh,Shawn Butler,Scholarship Manager,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
17,<blank>,Pittsburgh,Eugene Walker,Benchmarks Manager,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
18,<blank>,Pittsburgh,Amirah Hunt,Outreach Coordinator,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
19,<blank>,Pittsburgh,Oliver Beasley,Outreach Coordinator,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
20,<blank>,Pittsburgh,Amy Bishop,Special Projects Manager,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
21,Attending Keynote Only,Pittsburgh,Marsha Kolbe,Development Manager,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
22,<blank>,Pittsburgh,Katina Lee,Office Manager,[email protected],412-281-7605,PA,15219,1901 Centre Avenue,Non Profit,The Pittsburgh Promise
23,<blank>,Chester,Jeffrey Flynn,"Vice President, Business Development",[email protected],8562076340,PA,19013,810 E 16th Street,For Profit,Ombudsman
24,Also registered to exhibit,Pittsburgh,Barb Saunders,Assistant Director,[email protected],412-885-7017,PA,15236,5250 Caste Drive,Non Profit,Wesley Spectrum School Based Behavioral Health Services
25,<blank>,Pittsburgh,Ryan Parker,Director of Health Sciences Diversity,[email protected],412.648.2066,PA,15237,1822 Teal Trace,Teacher - School,University of Pittsburgh
26,<blank>,Harrisburg,Winifred Hynes,Audit Specialist,[email protected],717-787-2150,PA,17120,302 Finance Building,Public Offical,Pennsylvania Department of the Auditor General
27,<blank>,Pittsburgh,Audrey Bode,Director of Projects and Operations,[email protected],412-552-7098,PA,15219,"Regional Enterprise Tower, Suite 650 , 426 Sixth Ave",Non Profit,Three Rivers Workforce Investment Board
28,Education Consultant,Pittsburgh,Robert Dove,President,[email protected],(412) 657-7984,PA,15221,406 Burlington Road,Private Sector,WD&E Consulting LLC
29,<blank>,Pittsburgh,Akirah,<blank>,[email protected],412 849 5929,PA,15206,5715 Callowhill St. Apt 4,Non Profit,Pressley Ridge
31,<blank>,Pittsburgh,Richard Flanagan,Youth Development Director,[email protected],412-441-9833,PA,15224,5321 Penn Avenue,Non Profit,Bloomfield Garfield Corporation
32,<blank>,Pittsburgh,LouAnn Zwieryznski,Principal,[email protected],412-778-2100,PA,15204,2940 Sheraden Boulevard,Teacher - School,Pittsburgh Langley High School
33,Foundation,Pittsburgh,Jim Denova,Vice President,[email protected],412-246-3632,PA,15222,1400 Benedum-Trees Building,Non Profit,Benedum Foundation
34,<blank>,Pittsburgh,Yvette Yescas,<blank>,[email protected],412-552-7088,PA,15219,"425 Sixth Avenue, Ste. 650",Non Profit,Three Rivers Workforce Investment Board
35,<blank>,Pittsburgh,Nita Menendez,Assistant Educational Director,[email protected],412-885-7017,PA,15236,5250 Caste Drive,Non Profit,Wesley Spectrum Services (APS)
36,<blank>,Pittsburgh,Andre Gissendanner,Founder -Director,[email protected],412-732-9911,PA,15212,3407 Gass avenue,For Profit,GoodStuffConsults
37,<blank>,pgh,kristy rzepecki,Resource Specialist,[email protected],412-350-6661,PA,15222,one smithfield street,Non Profit,Allegheny County DHS
39,<blank>,Pittsburgh,Linda Thornhill,Family Support Partner,[email protected],412-241-2045,PA,15213,425 N. Craig Street,Non Profit,Allegheny Family Network
40,<blank>,"Springdale, PA",Nicole Molinaro,Executive Director,[email protected],412-977-7955,PA,15144,494 Pittsburgh Street,Non Profit,Communities In Schools
41,<blank>,Pittsburgh,Jeff McKee,Director of Development & Communications,[email protected],412-719-9848,PA,15239,4053 Impala Drive,Non Profit,Communities In Schools
42,<blank>,Pittsburgh,Jean Olivis,Program Director,[email protected],(412) 242-1639,PA,15206,1335 Olivant Street,Non Profit,Communities In Schools
43,Government agency,Harrisburg,Michelle Basom,<blank>,[email protected],717-787-2150,PA,17120-0018,302 Finance Building,Non Profit,Department of the Auditor General
44,<blank>,Pittsburgh,John Wallace,Associate Professor of Social Work,[email protected],412 624-6349,PA,15260,"4200 5th Avenue, 2301 Cathedral of Learning",Community Leader,University of Pittsburgh School of Social Work
45,<blank>,Springdale,Kate Gordon,Human Resource Manager,[email protected],412.860.3589,PA,15144,494 Pittsburgh Street,Non Profit,Communities In Schools of Pittsburgh-Allegheny County