Business Analytics Lab Worksheet 04
CME Group Foundation Business Analytics Lab
Katie Kouvelis
July 31
Task 1
Vendor State and Department Name Data
mydata = read.csv(file="data/states_purchase_orders.csv")
head(mydata)#Vendor State Data
vendorstate = mydata$VENDOR.STATE
vendorstate [1] LA LA LA LA LA LA LA LA LA LA LA LA LA CA LA LA LA TX LA NJ LA LA LA LA LA VA VA VA VA
[30] PA PA PA , LA LA LA LA LA DC DC DC DC DC LA LA LA LA LA LA LA LA TX TX LA LA LA LA LA
[59] LA LA LA LA LA LA LA NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ
[88] NJ NJ NJ NJ NJ NJ NJ LA GA LA LA LA LA WI CA CA CA CA CA LA LA LA LA NY NY LA LA LA LA
[117] LA LA LA LA LA LA LA LA LA LA LA IL MI LA LA LA LA TX TX TX TX TX LA LA LA LA TX LA LA
[146] LA LA LA LA LA IL LA LA NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ LA LA LA LA LA LA LA LA LA IA IA
[175] IA IA IA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA MS LA LA LA LA LA LA LA LA LA
[204] LA LA LA LA LA LA LA TX TX LA OH OH OH OH LA LA CA CA CA CA IA IA IA IA IA IA IA IA IA
[233] IA IA IA IA IA IA IA IA IA IA LA IA IA IA IA IA IA IA GA LA LA LA GA LA LA LA LA LA LA
[262] LA LA LA LA LA LA NJ NJ LA CA LA LA LA LA LA LA LA LA LA TX LA LA LA LA IA IA IA IA IA
[291] IA IA IA IA IA IA IA LA LA LA LA TX TX TX CA CA DC TX TX TX TX TX TX LA TX TX TX TX TX
[320] TX TX LA LA LA LA LA LA LA LA LA LA LA LA LA LA TN TN KS TX TX TX TX FL TX TX TX TX TX
[349] TX CO IL IL TX TX TX TX TX TX TX TX TX TX LA LA LA LA LA LA LA LA LA OH OH OH OH LA LA
[378] LA LA LA LA NC LA LA LA WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI
[407] WI WI LA LA LA LA GA GA GA GA GA GA LA LA LA LA LA LA LA LA RI RI RI RI RI RI RI RI RI
[436] RI RI RI RI LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA
[465] LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA
[494] LA LA LA LA LA LA LA LA LA LA LA MO LA LA IA IA LA LA LA WA LA CA LA LA LA LA LA LA TX
[523] TX LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA
[552] LA LA LA LA LA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA
[581] CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA
[610] CA CA CA CA CA CA CA CA LA CA CA CA CA LA FL LA NV LA OH LA LA MA MA MA TX TX LA LA TX
[639] LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA CA LA LA LA LA LA LA LA LA
[668] LA LA LA LA LA LA LA LA LA CA LA LA LA LA LA LA LA LA LA LA LA LA LA TX NJ LA LA LA LA
[697] TX TX TX TX TX TX TX TX LA LA LA FL FL LA LA TX TX TX TX TX TX TX CA CA CA CA CA CA CA
[726] CA CA CA CA CA CA LA LA LA , , , NJ LA LA LA LA LA LA LA LA LA LA LA LA GA GA GA PA
[755] PA PA PA PA CA CA CA CA CA TX TX LA LA LA LA LA LA GA GA LA KY LA LA LA LA LA LA LA LA
[784] LA LA LA MO LA LA LA LA LA LA LA LA LA LA LA CA LA LA LA LA CT LA LA LA LA LA LA LA LA
[813] LA LA LA LA LA LA LA LA LA LA LA LA LA NY NY FL FL FL LA LA LA LA LA LA LA LA VA VA VA
[842] VA VA VA VA VA VA VA VA VA VA VA VA VA VA VA VA LA LA LA LA LA LA LA LA LA LA LA LA LA
[871] LA LA LA LA LA LA LA LA LA LA LA OH LA LA LA LA LA NJ NJ LA LA LA LA LA LA LA LA LA LA
[900] LA LA LA AZ LA LA LA LA FL LA LA LA LA LA LA LA LA LA LA LA LA MN LA LA LA LA LA LA LA
[929] LA LA LA LA LA LA LA LA LA LA LA LA LA LA VA VA VA VA VA CA CA CA CA CA TX TX TX TX LA
[958] LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA DC LA NJ NJ NJ NJ NJ NJ NJ NJ LA
[987] TX LA LA LA LA LA LA PA PA LA LA CA CA LA
[ reached getOption("max.print") -- omitted 31452 entries ]
49 Levels: , AL AR AZ CA CD CO CT DC FL GA IA ID IL IN KS KY LA MA MD ME MI MN MO MS ... WV#Department Name Data
departmentname = mydata$DEPARTMENT.NAME
departmentname [1] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[3] ROAD REHABILITATION PROGRAM COMMUNITY DEVELOPMENT PROGRAMS
[5] ROAD REHABILITATION PROGRAM CONSTRUCTION PROJECTS
[7] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[9] CONSTRUCTION PROJECTS POLICE DEPARTMENT
[11] POLICE DEPARTMENT POLICE DEPARTMENT
[13] POLICE DEPARTMENT PARISH ATTORNEY
[15] DEPT OF FLEET MANAGEMENT ROAD REHABILITATION PROGRAM
[17] DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL
[19] CONSTRUCTION PROJECTS DEPARTMENT OF PUBLIC WORKS
[21] LIBRARY BOARD OF CONTROL OFC. OF HOMELAND SECURITY & EMERGENCY PREPA
[23] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[25] DEPT OF FLEET MANAGEMENT POLICE DEPARTMENT
[27] POLICE DEPARTMENT POLICE DEPARTMENT
[29] POLICE DEPARTMENT DEPARTMENT OF PUBLIC WORKS
[31] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[33] DEPARTMENT OF PUBLIC WORKS DEPT OF FLEET MANAGEMENT
[35] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[37] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[39] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[41] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[43] EMERGENCY MEDICAL SERVICES CITY CONSTABLE
[45] CITY CONSTABLE CITY CONSTABLE
[47] CITY CONSTABLE POLICE DEPARTMENT
[49] POLICE DEPARTMENT POLICE DEPARTMENT
[51] POLICE DEPARTMENT DEPT OF TRANSPORTATION AND DRAINAGE
[53] DEPT OF TRANSPORTATION AND DRAINAGE POLICE DEPARTMENT
[55] POLICE DEPARTMENT POLICE DEPARTMENT
[57] POLICE DEPARTMENT POLICE DEPARTMENT
[59] POLICE DEPARTMENT POLICE DEPARTMENT
[61] POLICE DEPARTMENT POLICE DEPARTMENT
[63] POLICE DEPARTMENT POLICE DEPARTMENT
[65] POLICE DEPARTMENT HUMAN RESOURCES
[67] HUMAN RESOURCES HUMAN RESOURCES
[69] HUMAN RESOURCES HUMAN RESOURCES
[71] HUMAN RESOURCES HUMAN RESOURCES
[73] HUMAN RESOURCES HUMAN RESOURCES
[75] HUMAN RESOURCES HUMAN RESOURCES
[77] HUMAN RESOURCES HUMAN RESOURCES
[79] HUMAN RESOURCES HUMAN RESOURCES
[81] HUMAN RESOURCES HUMAN RESOURCES
[83] HUMAN RESOURCES HUMAN RESOURCES
[85] HUMAN RESOURCES HUMAN RESOURCES
[87] HUMAN RESOURCES HUMAN RESOURCES
[89] HUMAN RESOURCES HUMAN RESOURCES
[91] HUMAN RESOURCES HUMAN RESOURCES
[93] HUMAN RESOURCES HUMAN RESOURCES
[95] ROAD REHABILITATION PROGRAM GREATER BATON ROUGE AIRPORT DISTRICT
[97] POLICE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[99] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[101] CONSTRUCTION PROJECTS DEPARTMENT OF PUBLIC WORKS
[103] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[105] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[107] POLICE DEPARTMENT DEPT OF MAINTENANCE
[109] CONSTRUCTION PROJECTS ROAD REHABILITATION PROGRAM
[111] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[113] DEPT OF MAINTENANCE POLICE DEPARTMENT
[115] POLICE DEPARTMENT POLICE DEPARTMENT
[117] POLICE DEPARTMENT POLICE DEPARTMENT
[119] POLICE DEPARTMENT POLICE DEPARTMENT
[121] POLICE DEPARTMENT POLICE DEPARTMENT
[123] POLICE DEPARTMENT POLICE DEPARTMENT
[125] POLICE DEPARTMENT POLICE DEPARTMENT
[127] POLICE DEPARTMENT POLICE DEPARTMENT
[129] INFORMATION SERVICES INFORMATION SERVICES
[131] INFORMATION SERVICES INFORMATION SERVICES
[133] DEPT OF TRANSPORTATION AND DRAINAGE FINANCE DEPARTMENT
[135] FINANCE DEPARTMENT FINANCE DEPARTMENT
[137] FINANCE DEPARTMENT FINANCE DEPARTMENT
[139] COUNCIL ADMINISTRATOR FINANCE DEPARTMENT
[141] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[143] FINANCE DEPARTMENT DEPT OF MAINTENANCE
[145] DEPT OF MAINTENANCE DEPARTMENT OF PUBLIC WORKS
[147] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[149] OFFICE OF THE MAYOR-PRESIDENT POLICE DEPARTMENT
[151] GREATER BATON ROUGE AIRPORT DISTRICT HUMAN DEVELOPMENT AND SERVICES
[153] HUMAN DEVELOPMENT AND SERVICES POLICE DEPARTMENT
[155] POLICE DEPARTMENT POLICE DEPARTMENT
[157] POLICE DEPARTMENT POLICE DEPARTMENT
[159] POLICE DEPARTMENT POLICE DEPARTMENT
[161] POLICE DEPARTMENT POLICE DEPARTMENT
[163] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[165] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[167] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[169] DEPARTMENT OF PUBLIC WORKS FINANCE DEPARTMENT
[171] FINANCE DEPARTMENT FINANCE DEPARTMENT
[173] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[175] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[177] DEPT OF MAINTENANCE DISTRICT COURT
[179] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[181] FIRE DEPARTMENT LIBRARY BOARD OF CONTROL
[183] LIBRARY BOARD OF CONTROL DEPT OF BUILDINGS AND GROUNDS
[185] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[187] DEPT OF FLEET MANAGEMENT DEPARTMENT OF PUBLIC WORKS
[189] DEPARTMENT OF PUBLIC WORKS COMMUNITY DEVELOPMENT PROGRAMS
[191] OFFICE OF THE MAYOR-PRESIDENT CONSTRUCTION PROJECTS
[193] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[195] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[197] COMMUNITY DEVELOPMENT PROGRAMS EMERGENCY MEDICAL SERVICES
[199] EMERGENCY MEDICAL SERVICES DEPARTMENT OF PUBLIC WORKS
[201] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[203] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[205] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[207] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[209] MOSQUITO & RODENT CONTROL HUMAN DEVELOPMENT AND SERVICES
[211] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[213] HUMAN DEVELOPMENT AND SERVICES LIBRARY BOARD OF CONTROL
[215] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[217] LIBRARY BOARD OF CONTROL CONSTRUCTION PROJECTS
[219] CONSTRUCTION PROJECTS CITY COURT
[221] CITY COURT CITY COURT
[223] CITY COURT DEPT OF MAINTENANCE
[225] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[227] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[229] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[231] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[233] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[235] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[237] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[239] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[241] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[243] PARISH ATTORNEY DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[245] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[247] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[249] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[251] LIBRARY BOARD OF CONTROL DEPT OF FLEET MANAGEMENT
[253] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[255] LIBRARY BOARD OF CONTROL OFFICE OF THE MAYOR-PRESIDENT
[257] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[259] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[261] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[263] OFFICE OF THE MAYOR-PRESIDENT CONSTRUCTION PROJECTS
[265] SHERIFF'S OFFICE SHERIFF'S OFFICE
[267] SHERIFF'S OFFICE EMERGENCY MEDICAL SERVICES
[269] EMERGENCY MEDICAL SERVICES CONSTRUCTION PROJECTS
[271] DEPARTMENT OF PUBLIC WORKS POLICE DEPARTMENT
[273] POLICE DEPARTMENT POLICE DEPARTMENT
[275] POLICE DEPARTMENT POLICE DEPARTMENT
[277] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[279] COUNCIL ADMINISTRATOR LIBRARY BOARD OF CONTROL
[281] EMERGENCY MEDICAL SERVICES DEPT OF FLEET MANAGEMENT
[283] DEPT OF FLEET MANAGEMENT COUNCIL ADMINISTRATOR
[285] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[287] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[289] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[291] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[293] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[295] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[297] DEPT OF MAINTENANCE DEPT OF BUILDINGS AND GROUNDS
[299] DEPARTMENT OF PUBLIC WORKS CITY COURT
[301] CITY COURT FINANCE DEPARTMENT
[303] FINANCE DEPARTMENT FINANCE DEPARTMENT
[305] POLICE DEPARTMENT POLICE DEPARTMENT
[307] OFFICE OF THE MAYOR-PRESIDENT METROPOLITAN COUNCIL
[309] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[311] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[313] METROPOLITAN COUNCIL OFFICE OF THE MAYOR-PRESIDENT
[315] LIBRARY BOARD OF CONTROL DEPT OF TRANSPORTATION AND DRAINAGE
[317] DEPT OF TRANSPORTATION AND DRAINAGE DEPT OF TRANSPORTATION AND DRAINAGE
[319] DEPT OF TRANSPORTATION AND DRAINAGE DEPARTMENT OF PUBLIC WORKS
[321] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[323] HUMAN DEVELOPMENT AND SERVICES DEPARTMENT OF PUBLIC WORKS
[325] DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL
[327] LIBRARY BOARD OF CONTROL POLICE DEPARTMENT
[329] POLICE DEPARTMENT POLICE DEPARTMENT
[331] POLICE DEPARTMENT POLICE DEPARTMENT
[333] DOWNTOWN DEVELOPMENT DISTRICT HUMAN DEVELOPMENT AND SERVICES
[335] HUMAN DEVELOPMENT AND SERVICES EMERGENCY MEDICAL SERVICES
[337] EMERGENCY MEDICAL SERVICES INFORMATION SERVICES
[339] ANIMAL CONTROL CENTER ANIMAL CONTROL CENTER
[341] ANIMAL CONTROL CENTER ANIMAL CONTROL CENTER
[343] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[345] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[347] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[349] HUMAN DEVELOPMENT AND SERVICES CITY COURT
[351] INFORMATION SERVICES INFORMATION SERVICES
[353] POLICE DEPARTMENT POLICE DEPARTMENT
[355] POLICE DEPARTMENT POLICE DEPARTMENT
[357] POLICE DEPARTMENT POLICE DEPARTMENT
[359] POLICE DEPARTMENT POLICE DEPARTMENT
[361] POLICE DEPARTMENT POLICE DEPARTMENT
[363] POLICE DEPARTMENT POLICE DEPARTMENT
[365] DEPARTMENT OF PUBLIC WORKS POLICE DEPARTMENT
[367] DEPT OF MAINTENANCE CONSTRUCTION PROJECTS
[369] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[371] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[373] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[375] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[377] INFORMATION SERVICES GREATER BATON ROUGE AIRPORT DISTRICT
[379] GREATER BATON ROUGE AIRPORT DISTRICT EMERGENCY MEDICAL SERVICES
[381] EMERGENCY MEDICAL SERVICES BATON ROUGE RIVER CENTER
[383] HUMAN DEVELOPMENT AND SERVICES DEPT OF BUILDINGS AND GROUNDS
[385] HUMAN DEVELOPMENT AND SERVICES DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[387] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[389] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[391] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[393] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[395] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[397] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[399] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[401] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[403] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[405] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[407] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[409] POLICE DEPARTMENT POLICE DEPARTMENT
[411] POLICE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[413] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[415] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[417] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[419] COMMUNITY DEVELOPMENT PROGRAMS OFC. OF HOMELAND SECURITY & EMERGENCY PREPA
[421] OFC. OF HOMELAND SECURITY & EMERGENCY PREPA COMMUNITY DEVELOPMENT PROGRAMS
[423] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[425] COMMUNITY DEVELOPMENT PROGRAMS DEPT OF TRANSPORTATION AND DRAINAGE
[427] POLICE DEPARTMENT POLICE DEPARTMENT
[429] POLICE DEPARTMENT POLICE DEPARTMENT
[431] POLICE DEPARTMENT POLICE DEPARTMENT
[433] POLICE DEPARTMENT POLICE DEPARTMENT
[435] POLICE DEPARTMENT POLICE DEPARTMENT
[437] POLICE DEPARTMENT POLICE DEPARTMENT
[439] POLICE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[441] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[443] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[445] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[447] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[449] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[451] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[453] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[455] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[457] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[459] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[461] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[463] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[465] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[467] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[469] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[471] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[473] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[475] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[477] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[479] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[481] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[483] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[485] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[487] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[489] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[491] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[493] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[495] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[497] HUMAN DEVELOPMENT AND SERVICES POLICE DEPARTMENT
[499] POLICE DEPARTMENT POLICE DEPARTMENT
[501] POLICE DEPARTMENT POLICE DEPARTMENT
[503] POLICE DEPARTMENT POLICE DEPARTMENT
[505] DEPT OF TRANSPORTATION AND DRAINAGE DEPT OF FLEET MANAGEMENT
[507] DEPT OF BUILDINGS AND GROUNDS HUMAN DEVELOPMENT AND SERVICES
[509] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[511] INFORMATION SERVICES INFORMATION SERVICES
[513] INFORMATION SERVICES EMERGENCY MEDICAL SERVICES
[515] INFORMATION SERVICES INFORMATION SERVICES
[517] GREATER BATON ROUGE AIRPORT DISTRICT INFORMATION SERVICES
[519] INFORMATION SERVICES INFORMATION SERVICES
[521] INFORMATION SERVICES GREATER BATON ROUGE AIRPORT DISTRICT
[523] POLICE DEPARTMENT POLICE DEPARTMENT
[525] POLICE DEPARTMENT POLICE DEPARTMENT
[527] POLICE DEPARTMENT POLICE DEPARTMENT
[529] CONSTRUCTION PROJECTS ROAD REHABILITATION PROGRAM
[531] FIRE DEPARTMENT FIRE DEPARTMENT
[533] FIRE DEPARTMENT FIRE DEPARTMENT
[535] FIRE DEPARTMENT FIRE DEPARTMENT
[537] FIRE DEPARTMENT FIRE DEPARTMENT
[539] FIRE DEPARTMENT FIRE DEPARTMENT
[541] FIRE DEPARTMENT FIRE DEPARTMENT
[543] FIRE DEPARTMENT FIRE DEPARTMENT
[545] FIRE DEPARTMENT FIRE DEPARTMENT
[547] FIRE DEPARTMENT FIRE DEPARTMENT
[549] FIRE DEPARTMENT FIRE DEPARTMENT
[551] FIRE DEPARTMENT FIRE DEPARTMENT
[553] FIRE DEPARTMENT FIRE DEPARTMENT
[555] FIRE DEPARTMENT FIRE DEPARTMENT
[557] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[559] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[561] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[563] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[565] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[567] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[569] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[571] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[573] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[575] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[577] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[579] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[581] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[583] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[585] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[587] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[589] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[591] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[593] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[595] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[597] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[599] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[601] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[603] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[605] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[607] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[609] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[611] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[613] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[615] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[617] BATON ROUGE RIVER CENTER DEPT OF FLEET MANAGEMENT
[619] FINANCE DEPARTMENT FINANCE DEPARTMENT
[621] FINANCE DEPARTMENT FINANCE DEPARTMENT
[623] COMMUNITY DEVELOPMENT PROGRAMS FINANCE DEPARTMENT
[625] CONSTRUCTION PROJECTS INFORMATION SERVICES
[627] DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL
[629] OFFICE OF THE MAYOR-PRESIDENT CONSTRUCTION PROJECTS
[631] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[633] LIBRARY BOARD OF CONTROL DEPARTMENT OF PUBLIC WORKS
[635] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[637] DEPARTMENT OF PUBLIC WORKS GREATER BATON ROUGE AIRPORT DISTRICT
[639] GREATER BATON ROUGE AIRPORT DISTRICT COMMUNITY DEVELOPMENT PROGRAMS
[641] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[643] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[645] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[647] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[649] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[651] COMMUNITY DEVELOPMENT PROGRAMS FINANCE DEPARTMENT
[653] FINANCE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[655] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[657] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[659] EMERGENCY MEDICAL SERVICES FINANCE DEPARTMENT
[661] FINANCE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[663] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[665] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[667] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[669] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[671] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[673] GREATER BATON ROUGE AIRPORT DISTRICT FINANCE DEPARTMENT
[675] FINANCE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[677] PARISH ATTORNEY HUMAN DEVELOPMENT AND SERVICES
[679] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[681] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[683] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[685] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[687] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[689] POLICE DEPARTMENT POLICE DEPARTMENT
[691] HUMAN DEVELOPMENT AND SERVICES INFORMATION SERVICES
[693] COMMUNITY DEVELOPMENT PROGRAMS EMERGENCY MEDICAL SERVICES
[695] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[697] HUMAN RESOURCES HUMAN RESOURCES
[699] HUMAN RESOURCES HUMAN RESOURCES
[701] HUMAN RESOURCES HUMAN RESOURCES
[703] HUMAN RESOURCES HUMAN RESOURCES
[705] POLICE DEPARTMENT POLICE DEPARTMENT
[707] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[709] LIBRARY BOARD OF CONTROL OUTSIDE AGENCIES
[711] FINANCE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[713] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[715] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[717] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[719] INFORMATION SERVICES INFORMATION SERVICES
[721] INFORMATION SERVICES INFORMATION SERVICES
[723] INFORMATION SERVICES INFORMATION SERVICES
[725] INFORMATION SERVICES INFORMATION SERVICES
[727] INFORMATION SERVICES INFORMATION SERVICES
[729] INFORMATION SERVICES INFORMATION SERVICES
[731] INFORMATION SERVICES HUMAN DEVELOPMENT AND SERVICES
[733] HUMAN DEVELOPMENT AND SERVICES HUMAN RESOURCES
[735] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[737] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[739] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[741] DEPARTMENT OF PUBLIC WORKS JUVENILE SERVICES
[743] CONSTRUCTION PROJECTS DEPT OF TRANSPORTATION AND DRAINAGE
[745] POLICE DEPARTMENT POLICE DEPARTMENT
[747] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[749] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[751] INFORMATION SERVICES INFORMATION SERVICES
[753] INFORMATION SERVICES DEPARTMENT OF PUBLIC WORKS
[755] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[757] DEPARTMENT OF PUBLIC WORKS DEPT OF FLEET MANAGEMENT
[759] INFORMATION SERVICES INFORMATION SERVICES
[761] INFORMATION SERVICES INFORMATION SERVICES
[763] INFORMATION SERVICES HUMAN DEVELOPMENT AND SERVICES
[765] HUMAN DEVELOPMENT AND SERVICES COMMUNITY DEVELOPMENT PROGRAMS
[767] COMMUNITY DEVELOPMENT PROGRAMS MOSQUITO & RODENT CONTROL
[769] LIBRARY BOARD OF CONTROL OFFICE OF THE MAYOR-PRESIDENT
[771] HUMAN DEVELOPMENT AND SERVICES INFORMATION SERVICES
[773] INFORMATION SERVICES HUMAN DEVELOPMENT AND SERVICES
[775] COMMUNITY DEVELOPMENT PROGRAMS DEPARTMENT OF PUBLIC WORKS
[777] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[779] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[781] POLICE DEPARTMENT POLICE DEPARTMENT
[783] POLICE DEPARTMENT POLICE DEPARTMENT
[785] POLICE DEPARTMENT POLICE DEPARTMENT
[787] EMERGENCY MEDICAL SERVICES LIBRARY BOARD OF CONTROL
[789] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[791] LIBRARY BOARD OF CONTROL OFFICE OF THE MAYOR-PRESIDENT
[793] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[795] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[797] HUMAN DEVELOPMENT AND SERVICES PARISH ATTORNEY
[799] POLICE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[801] LIBRARY BOARD OF CONTROL HUMAN RESOURCES
[803] LIBRARY BOARD OF CONTROL DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[805] JUVENILE SERVICES DEPARTMENT OF PUBLIC WORKS
[807] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[809] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[811] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[813] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[815] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[817] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[819] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[821] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[823] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[825] DEPARTMENT OF PUBLIC WORKS DEPT OF TRANSPORTATION AND DRAINAGE
[827] DEPT OF TRANSPORTATION AND DRAINAGE POLICE DEPARTMENT
[829] POLICE DEPARTMENT POLICE DEPARTMENT
[831] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[833] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[835] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[837] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[839] INFORMATION SERVICES INFORMATION SERVICES
[841] INFORMATION SERVICES INFORMATION SERVICES
[843] INFORMATION SERVICES INFORMATION SERVICES
[845] INFORMATION SERVICES INFORMATION SERVICES
[847] INFORMATION SERVICES INFORMATION SERVICES
[849] INFORMATION SERVICES INFORMATION SERVICES
[851] INFORMATION SERVICES INFORMATION SERVICES
[853] INFORMATION SERVICES INFORMATION SERVICES
[855] INFORMATION SERVICES INFORMATION SERVICES
[857] INFORMATION SERVICES DEPARTMENT OF PUBLIC WORKS
[859] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[861] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[863] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[865] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[867] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[869] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[871] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[873] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[875] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[877] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[879] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[881] OFFICE OF THE MAYOR-PRESIDENT LIBRARY BOARD OF CONTROL
[883] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[885] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[887] LIBRARY BOARD OF CONTROL EMERGENCY MEDICAL SERVICES
[889] EMERGENCY MEDICAL SERVICES DEPT OF FLEET MANAGEMENT
[891] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[893] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[895] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[897] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[899] DEPT OF TRANSPORTATION AND DRAINAGE HUMAN DEVELOPMENT AND SERVICES
[901] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[903] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[905] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[907] MUNICIPAL FIRE & POLICE CIVIL SERVICE BOARD FINANCE DEPARTMENT
[909] JUVENILE SERVICES HUMAN DEVELOPMENT AND SERVICES
[911] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[913] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[915] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[917] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[919] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[921] ROAD REHABILITATION PROGRAM COMMUNITY DEVELOPMENT PROGRAMS
[923] DEPT OF BUILDINGS AND GROUNDS COMMUNITY DEVELOPMENT PROGRAMS
[925] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[927] COMMUNITY DEVELOPMENT PROGRAMS LIBRARY BOARD OF CONTROL
[929] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[931] COMMUNITY DEVELOPMENT PROGRAMS DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[933] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[935] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[937] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[939] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[941] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[943] CITY COURT CITY COURT
[945] CITY COURT CITY COURT
[947] CITY COURT COUNCIL ADMINISTRATOR
[949] COUNCIL ADMINISTRATOR COUNCIL ADMINISTRATOR
[951] COUNCIL ADMINISTRATOR COUNCIL ADMINISTRATOR
[953] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[955] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[957] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[959] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[961] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[963] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[965] DEPT OF FLEET MANAGEMENT CITY COURT
[967] POLICE DEPARTMENT POLICE DEPARTMENT
[969] POLICE DEPARTMENT OUTSIDE AGENCIES
[971] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[973] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[975] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[977] JUVENILE SERVICES OUTSIDE AGENCIES
[979] OUTSIDE AGENCIES DEPT OF DEVELOPMENT
[981] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[983] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[985] DEPT OF DEVELOPMENT JUVENILE SERVICES
[987] DEPARTMENT OF PUBLIC WORKS DEPT OF BUILDINGS AND GROUNDS
[989] DEPT OF DEVELOPMENT HUMAN DEVELOPMENT AND SERVICES
[991] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[993] CONSTRUCTION PROJECTS DEPARTMENT OF PUBLIC WORKS
[995] DEPARTMENT OF PUBLIC WORKS FIRE DEPARTMENT
[997] HUMAN RESOURCES EMERGENCY MEDICAL SERVICES
[999] EMERGENCY MEDICAL SERVICES DEPT OF BUILDINGS AND GROUNDS
[ reached getOption("max.print") -- omitted 31452 entries ]
45 Levels: ANIMAL CONTROL CENTER ... SHERIFF'S OFFICEFrequency Table for Vendor State and Department Name
# Command to create a frequency table: variable_table = table(variable)
# variable_table
vendorstate_table = table(vendorstate)
vendorstate_tablevendorstate
, AL AR AZ CA CD CO CT DC FL GA IA ID IL
2 62 400 125 189 877 1 114 99 69 418 555 1089 14 330
IN KS KY LA MA MD ME MI MN MO MS NC ND NE NH
180 76 100 20178 149 32 12 55 233 74 361 313 4 56 14
NJ NM NV NY OH OK OR PA RI SC SD TN TX UT VA
1633 3 12 210 180 9 27 401 15 41 6 152 2561 77 295
VT WA WI WV
3 60 583 3 departmentname_table = table(departmentname)
departmentname_tabledepartmentname
ANIMAL CONTROL CENTER BATON ROUGE CONVENTION & VISTORS COMMISSION
79 4
BATON ROUGE RIVER CENTER CITY CONSTABLE
134 115
CITY COURT COMMUNITY DEVELOPMENT PROGRAMS
1412 1674
CONSTRUCTION PROJECTS CORONER
2224 47
COUNCIL ADMINISTRATOR COUNCIL BUDGET OFFICE
182 84
DEPARTMENT OF PUBLIC WORKS DEPT OF BUILDINGS AND GROUNDS
5523 326
DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF DEVELOPMENT
107 69
DEPT OF FLEET MANAGEMENT DEPT OF MAINTENANCE
325 220
DEPT OF TRANSPORTATION AND DRAINAGE DISTRICT COURT
200 20
DOWNTOWN DEVELOPMENT DISTRICT EMERGENCY MEDICAL SERVICES
182 1640
FINANCE DEPARTMENT FIRE DEPARTMENT
758 498
FIRE PROTECTION DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
217 1677
HUMAN DEVELOPMENT AND SERVICES HUMAN RESOURCES
2733 561
INFORMATION SERVICES JUVENILE COURT
1156 1
JUVENILE SERVICES LIBRARY BOARD OF CONTROL
376 2620
METROPOLITAN COUNCIL MOSQUITO & RODENT CONTROL
186 413
MUNICIPAL FIRE & POLICE CIVIL SERVICE BOARD OFC. OF HOMELAND SECURITY & EMERGENCY PREPA
11 472
OFFICE OF THE MAYOR-PRESIDENT OUTSIDE AGENCIES
386 161
PARISH ATTORNEY PLANNING COMMISSION
259 138
POLICE DEPARTMENT PUBLIC INFORMATION OFFICE
4066 94
PURCHASING REGISTRAR OF VOTERS
253 43
RETIREMENT OFFICE ROAD REHABILITATION PROGRAM
4 607
SHERIFF'S OFFICE
195 Bar Plot of Vendor State and Department Name
# Plot a bar plot using the " barplot(variable) " command where variable is the extracted variable
barplot(vendorstate_table)
barplot(departmentname_table)
Histogram of vendor state and department name
# Plot a histogram using the " hist(variable) " command where variable is the extracted variable
hist(vendorstate_table)
hist(departmentname_table)
- What are some observable differences between the boxplot and the histogram? Please record your observations here.
A histogram is useful in showing the many varying frequencies, while a boxplot is best used for moderate frequencies in information.
Pie Chart for Vendor State with values above 10
# Plot a pie chart using:
# pie(variable) (command to make a pie chart)
vendorstatepie = pie(vendorstate_table)
vendorstatepieNULL# To get only values greather than N from a frequency table use:
# new_table = my_table[ my_table > N ] (command to select values greather than N)
new_table = vendorstatepie[vendorstatepie > 10]
new_tableNULLWhy is this visual not a good representation of the data? What makes the barplot a better representation?
This visual is not a good representation because there are no numerical values. This makes the data very hard to read because all the data is so smushed together. The barplot is a lot better representation because there is very exact data points so the information is easier to read.
Task 2
Illinois Tax Dataset
mydata = read.csv(file="data/state_tax_illinois.csv")
head(mydata)Naming and changing to decreasing order
# To change the way that R shows very large or small values we can use the following command:
options(scipen = 9999)
# read the dataset extract the year variable and order the dataset by year in decreasing order using the command:
year = mydata$year
year [1] 2016 2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012
[19] 2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008 2008 2008 2008 2007 2007
[37] 2007 2007 2006 2006 2006 2006 2005 2005 2005 2005 2004 2004 2004 2004 2003 2003 2003 2003
[55] 2002 2002 2002 2002 2001 2001 2001 2001 2000 2000 2000 2000 1999 1999 1999 1999 1998 1998
[73] 1998 1998 1997 1997 1997 1997 1996 1996 1996 1996 1995 1995 1995 1995 1994 1994 1994 1994# mydata = mydata[ order(year, decreasing = TRUE) , ] (! Order the data in decreasing order)
mydata = mydata[ order(year, decreasing = TRUE) , ]
# From the ordered dataset Extract personal_income_tax variable
personalincometax = mydata$personal_income_tax
personalincometax [1] 3746068 3950197 3982255 4527933 3059415 3048487 4505921 4961971 3680480 3723148 4345335
[12] 5353786 3608644 3565618 4197619 4790521 3403778 3435763 3195378 4096206 3343258 3180912
[23] 2515231 2702995 2134865 2291055 2448000 2899039 2104226 2110793 2803540 3427232 2149834
[34] 1968785 2522527 3101128 2071646 2017821 2264920 2817633 1963943 1820838 2130841 2511261
[45] 1817907 1734644 1902394 2181615 1675372 1661305 1862628 2169229 1600339 1571274 1945837
[56] 2195228 1648066 1661059 1867375 2405920 1679520 1650800 2272950 2713373 1763852 1631196
[67] 1877350 1984974 1644788 1640535 1877350 1984974 1579539 1545132 1689205 1786043 1579539
[78] 1545132 1553374 1642423 1421240 1390281 1427336 1509160 1306955 1278486 1360884 1425714
[89] 1200911 1174752# From the ordered dataset Extract corporate_income_tax variable
corporateincometax = mydata$corporate_income_tax
corporateincometax [1] 903017 1163900 1055932 1425459 674725 625819 1105062 1508593 787764 785112 1028486
[12] 1764708 877978 948199 834075 1365912 778008 891425 632404 1160954 655115 639437
[23] 729180 971001 507167 504933 642923 1403105 459494 527011 790459 1225043 519552
[34] 439074 704820 1158924 537828 562274 591623 901551 556344 516272 557161 735924
[45] 438193 468903 431059 470507 324041 354688 362344 421964 222017 395572 362374
[56] 432374 261916 246964 583639 786706 274660 313983 792893 828315 433323 412970
[67] 473585 814038 476261 457064 473585 814038 370340 303603 435527 748621 370340
[78] 303603 391428 672820 340579 279205 357650 614760 306094 250934 281377 532591
[89] 279680 229280Scatter Plot Personal and Corporate Income
# Plot personal_income_tax vs. corporate_income_tax
# personal_income_tax will be on the x-axis
# corporate_income_tax will be on the y-axis
plot(personalincometax,corporateincometax)
Naming Quarter
quarter = mydata$quarter
quarter [1] Q1 Q2 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
[31] Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2
[61] Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Levels: Q1 Q2 Q3 Q4Entries greater than 1999 and only entries from Q1
# To create a new_data filtering for an N NUMERIC value we can do the following
# new_data = mydata[ mydata$NUMERIC_VARIABLE > N, ]
new_data = mydata[mydata$year > 1999 , ]
# If we need to make another filter on a NON-NUMERIC we can do the following
# new_data = new_data[ new_data$CHAR_VARIABLE == "Q1", ]
new_data = new_data[new_data$quarter == "Q1" ,]
head(new_data)Scatter Smooth Graph Personal and Corporate Income Tax
scatter.smooth(personalincometax,corporateincometax)
Scatter Smooth Graph Total Tax US and Total State
# total_tax_US vs. total_state
totaltaxUS = mydata$total_tax_US
totaltaxUS [1] 222287206 271263780 218877926 277053403 212615988 217443823 207783584 258554691 204440284
[10] 212998203 207501165 260880904 195785584 201352044 188942321 236842680 185252300 195080471
[19] 181829622 228937671 178686442 184695636 165109821 205868100 170085231 179201087 159740520
[28] 201526713 160974777 165585529 181894597 240545336 180767288 170932192 176839082 228361858
[37] 176066516 177849972 168140829 216447550 171164001 172458009 156957207 196599615 162245445
[46] 165474617 141953121 169692044 147190204 153350871 131305076 152533357 138163664 140126145
[55] 129267848 149346624 129451673 131008319 137649419 164910108 127472720 126663650 133987401
[64] 162988584 126852612 128084166 119587068 145886283 118794468 122866643 115219000 140371196
[73] 111865625 114456862 108012557 126304908 106395324 107393718 102677692 119200042 100543930
[82] 102569374 93944974 109609563 94627837 94984540 91075715 104324554 90160343 91149689totalstate = mydata$total_state
totalstate [1] 9336875 10045643 9622256 10953294 8685450 8564364 10046029 11338476 9390536 9316965
[11] 9832505 11622644 9097693 9440340 9082749 10459078 8555361 8718812 7624965 9234900
[21] 8538565 8177370 7091648 7770695 7128096 6892476 6728486 8365087 6422330 6497882
[31] 7546742 8756653 6955768 6359947 7132023 8487980 6858279 6723925 6763926 8019376
[41] 6781697 6337485 6988957 7463948 6434580 6094696 6047406 6612900 6011795 5786577
[51] 5392903 6123292 5637669 5655878 5670224 6207903 5396931 5298567 5648355 6633372
[61] 5315230 5280986 6142447 7000901 5581641 5280512 4999164 5587108 5247786 5268964
[71] 4999164 5587107 4721429 4463584 4680894 5236808 4721429 4463584 4367395 4862738
[81] 4433669 4193211 4028215 4480566 4117755 3929430 3684023 4299796 3803301 3627632scatter.smooth(totaltaxUS,totalstate)
To quantify the data, its best to look at the correlation between two variables. What does this correlation explain?
This correlation shows how relative the data is to each other. Since the data is high at .96 they are very correlated.
Correlation of Total State and Personal Income Tax
cor(totalstate,personalincometax)[1] 0.9652176Correlation Between Every Pair of Variables
# To make a correlation table of all the NUMERIC variables you can select some columns or a range of columns, with the following command:
# corr01 = mydata[ c(3,4) ] (The command c(3,4,...) inside the brackets selects a given column )
# cor(corr01) (will give you the correlation table for variables in columns 3 and 4)
corr01 = mydata [c(3,4,5,6,7,8)]
cor(corr01) total_tax_US total_state personal_income_tax corporate_income_tax
total_tax_US 1.0000000 0.9621443 0.89216270 0.83789591
total_state 0.9621443 1.0000000 0.96521760 0.85471906
personal_income_tax 0.8921627 0.9652176 1.00000000 0.87948231
corporate_income_tax 0.8378959 0.8547191 0.87948231 1.00000000
general_sales_tax 0.8811287 0.8632035 0.73636583 0.55037249
motor_fuel_tax 0.2108519 0.1397864 -0.02182754 -0.05636253
general_sales_tax motor_fuel_tax
total_tax_US 0.8811287 0.21085187
total_state 0.8632035 0.13978644
personal_income_tax 0.7363658 -0.02182754
corporate_income_tax 0.5503725 -0.05636253
general_sales_tax 1.0000000 0.36033009
motor_fuel_tax 0.3603301 1.00000000# corr02 = mydata[3:5] ( the command [3:5] selects a range of columns from 3 to 5)
# cor(corr02)
corr02 = mydata [3:8]
cor(corr02) total_tax_US total_state personal_income_tax corporate_income_tax
total_tax_US 1.0000000 0.9621443 0.89216270 0.83789591
total_state 0.9621443 1.0000000 0.96521760 0.85471906
personal_income_tax 0.8921627 0.9652176 1.00000000 0.87948231
corporate_income_tax 0.8378959 0.8547191 0.87948231 1.00000000
general_sales_tax 0.8811287 0.8632035 0.73636583 0.55037249
motor_fuel_tax 0.2108519 0.1397864 -0.02182754 -0.05636253
general_sales_tax motor_fuel_tax
total_tax_US 0.8811287 0.21085187
total_state 0.8632035 0.13978644
personal_income_tax 0.7363658 -0.02182754
corporate_income_tax 0.5503725 -0.05636253
general_sales_tax 1.0000000 0.36033009
motor_fuel_tax 0.3603301 1.00000000Task 3 - TABLEAU
Sheet 1 with Department Name and Number of Records
- What department ‘bin’ has the highest count? What is the count?
The department bin that has the highest count is Department of Public Works with a count of 5,523
This is another view of the department name and the number of records. Each ring shows how many records and when you click on a ring it tells you the department name. It is interesting to note that most of the departments have between 0 and 1,000 records. It is rare that there are records above 1,000 in one department and very rare that there is above 4,000 records in a department.
New Sheet with ‘Number of Records’ and ‘Vendor.Zip’
The highlights on the map show where the most number of records occur in terms of vendor. There seems to be the largest concentration in the south and also the northeast.
LS0tCnRpdGxlOiAiQnVzaW5lc3MgQW5hbHl0aWNzIExhYiBXb3Jrc2hlZXQgMDQiCmF1dGhvcjogIkthdGllIEtvdXZlbGlzIgpkYXRlOiAiSnVseSAzMSIKb3V0cHV0OgogIGh0bWxfbm90ZWJvb2s6IGRlZmF1bHQKICBodG1sX2RvY3VtZW50OiBkZWZhdWx0CiAgcGRmX2RvY3VtZW50OiBkZWZhdWx0CnN1YnRpdGxlOiBDTUUgR3JvdXAgRm91bmRhdGlvbiBCdXNpbmVzcyBBbmFseXRpY3MgTGFiCi0tLQoKCi0tLS0tLS0tLS0KCiMjIyBUYXNrIDEKCiMjIyNWZW5kb3IgU3RhdGUgYW5kIERlcGFydG1lbnQgTmFtZSBEYXRhCgpgYGB7cn0KbXlkYXRhID0gcmVhZC5jc3YoZmlsZT0iZGF0YS9zdGF0ZXNfcHVyY2hhc2Vfb3JkZXJzLmNzdiIpCmhlYWQobXlkYXRhKQojVmVuZG9yIFN0YXRlIERhdGEKdmVuZG9yc3RhdGUgPSBteWRhdGEkVkVORE9SLlNUQVRFCnZlbmRvcnN0YXRlCiNEZXBhcnRtZW50IE5hbWUgRGF0YQpkZXBhcnRtZW50bmFtZSA9IG15ZGF0YSRERVBBUlRNRU5ULk5BTUUKZGVwYXJ0bWVudG5hbWUKYGBgCgoKIyMjI0ZyZXF1ZW5jeSBUYWJsZSBmb3IgVmVuZG9yIFN0YXRlIGFuZCBEZXBhcnRtZW50IE5hbWUKYGBge3J9CiMgQ29tbWFuZCB0byBjcmVhdGUgYSBmcmVxdWVuY3kgdGFibGU6IHZhcmlhYmxlX3RhYmxlID0gdGFibGUodmFyaWFibGUpIAojIHZhcmlhYmxlX3RhYmxlCnZlbmRvcnN0YXRlX3RhYmxlID0gdGFibGUodmVuZG9yc3RhdGUpCnZlbmRvcnN0YXRlX3RhYmxlCmRlcGFydG1lbnRuYW1lX3RhYmxlID0gdGFibGUoZGVwYXJ0bWVudG5hbWUpCmRlcGFydG1lbnRuYW1lX3RhYmxlCgpgYGAKCiMjIyNCYXIgUGxvdCBvZiBWZW5kb3IgU3RhdGUgYW5kIERlcGFydG1lbnQgTmFtZQoKYGBge3J9CiMgUGxvdCBhIGJhciBwbG90IHVzaW5nIHRoZSAiIGJhcnBsb3QodmFyaWFibGUpICIgY29tbWFuZCB3aGVyZSB2YXJpYWJsZSBpcyB0aGUgZXh0cmFjdGVkIHZhcmlhYmxlCmJhcnBsb3QodmVuZG9yc3RhdGVfdGFibGUpCgpiYXJwbG90KGRlcGFydG1lbnRuYW1lX3RhYmxlKQpgYGAKCiMjIyNIaXN0b2dyYW0gb2YgdmVuZG9yIHN0YXRlIGFuZCBkZXBhcnRtZW50IG5hbWUKCmBgYHtyfQojIFBsb3QgYSBoaXN0b2dyYW0gdXNpbmcgdGhlICIgaGlzdCh2YXJpYWJsZSkgIiBjb21tYW5kIHdoZXJlIHZhcmlhYmxlIGlzIHRoZSBleHRyYWN0ZWQgdmFyaWFibGUKaGlzdCh2ZW5kb3JzdGF0ZV90YWJsZSkKCmhpc3QoZGVwYXJ0bWVudG5hbWVfdGFibGUpCmBgYAoKKiBXaGF0IGFyZSBzb21lIG9ic2VydmFibGUgZGlmZmVyZW5jZXMgYmV0d2VlbiB0aGUgYm94cGxvdCBhbmQgdGhlIGhpc3RvZ3JhbT8gUGxlYXNlIHJlY29yZCB5b3VyIG9ic2VydmF0aW9ucyBoZXJlLiAKCkEgaGlzdG9ncmFtIGlzIHVzZWZ1bCBpbiBzaG93aW5nIHRoZSBtYW55IHZhcnlpbmcgZnJlcXVlbmNpZXMsIHdoaWxlIGEgYm94cGxvdCBpcyBiZXN0IHVzZWQgZm9yIG1vZGVyYXRlIGZyZXF1ZW5jaWVzIGluIGluZm9ybWF0aW9uLiAKCgojIyMjUGllIENoYXJ0IGZvciBWZW5kb3IgU3RhdGUgd2l0aCB2YWx1ZXMgYWJvdmUgMTAKYGBge3J9CiMgUGxvdCBhIHBpZSBjaGFydCB1c2luZzoKIyBwaWUodmFyaWFibGUpICAoY29tbWFuZCB0byBtYWtlIGEgcGllIGNoYXJ0KQp2ZW5kb3JzdGF0ZXBpZSA9IHBpZSh2ZW5kb3JzdGF0ZV90YWJsZSkKdmVuZG9yc3RhdGVwaWUKIyBUbyBnZXQgb25seSB2YWx1ZXMgZ3JlYXRoZXIgdGhhbiBOIGZyb20gYSBmcmVxdWVuY3kgdGFibGUgdXNlOgojIG5ld190YWJsZSA9IG15X3RhYmxlWyBteV90YWJsZSA+IE4gXSAgKGNvbW1hbmQgdG8gc2VsZWN0IHZhbHVlcyBncmVhdGhlciB0aGFuIE4pCm5ld190YWJsZSA9IHZlbmRvcnN0YXRlcGllW3ZlbmRvcnN0YXRlcGllID4gMTBdCm5ld190YWJsZQpgYGAKCldoeSBpcyB0aGlzIHZpc3VhbCBub3QgYSBnb29kIHJlcHJlc2VudGF0aW9uIG9mIHRoZSBkYXRhPyBXaGF0IG1ha2VzIHRoZSBiYXJwbG90IGEgYmV0dGVyIHJlcHJlc2VudGF0aW9uPwoKVGhpcyB2aXN1YWwgaXMgbm90IGEgZ29vZCByZXByZXNlbnRhdGlvbiBiZWNhdXNlIHRoZXJlIGFyZSBubyBudW1lcmljYWwgdmFsdWVzLiBUaGlzIG1ha2VzIHRoZSBkYXRhIHZlcnkgaGFyZCB0byByZWFkIGJlY2F1c2UgYWxsIHRoZSBkYXRhIGlzIHNvIHNtdXNoZWQgdG9nZXRoZXIuIFRoZSBiYXJwbG90IGlzIGEgbG90IGJldHRlciByZXByZXNlbnRhdGlvbiBiZWNhdXNlIHRoZXJlIGlzIHZlcnkgZXhhY3QgZGF0YSBwb2ludHMgc28gdGhlIGluZm9ybWF0aW9uIGlzIGVhc2llciB0byByZWFkLiAKLS0tLS0tLS0tLQoKIyMjIFRhc2sgMgoKIyMjI0lsbGlub2lzIFRheCBEYXRhc2V0CgpgYGB7cn0KbXlkYXRhID0gcmVhZC5jc3YoZmlsZT0iZGF0YS9zdGF0ZV90YXhfaWxsaW5vaXMuY3N2IikKaGVhZChteWRhdGEpCmBgYAoKIyMjI05hbWluZyBhbmQgY2hhbmdpbmcgdG8gZGVjcmVhc2luZyBvcmRlcgoKYGBge3J9CiMgVG8gY2hhbmdlIHRoZSB3YXkgdGhhdCBSIHNob3dzIHZlcnkgbGFyZ2Ugb3Igc21hbGwgdmFsdWVzIHdlIGNhbiB1c2UgdGhlIGZvbGxvd2luZyBjb21tYW5kOgpvcHRpb25zKHNjaXBlbiA9IDk5OTkpCgojIHJlYWQgdGhlIGRhdGFzZXQgZXh0cmFjdCB0aGUgeWVhciB2YXJpYWJsZSBhbmQgb3JkZXIgdGhlIGRhdGFzZXQgYnkgeWVhciBpbiBkZWNyZWFzaW5nIG9yZGVyIHVzaW5nIHRoZSBjb21tYW5kOgp5ZWFyID0gbXlkYXRhJHllYXIKeWVhcgoKIyBteWRhdGEgPSBteWRhdGFbIG9yZGVyKHllYXIsIGRlY3JlYXNpbmcgPSBUUlVFKSAsIF0gKCEgT3JkZXIgdGhlIGRhdGEgaW4gZGVjcmVhc2luZyBvcmRlcikKbXlkYXRhID0gbXlkYXRhWyBvcmRlcih5ZWFyLCBkZWNyZWFzaW5nID0gVFJVRSkgLCBdCgojIEZyb20gdGhlIG9yZGVyZWQgZGF0YXNldCBFeHRyYWN0IHBlcnNvbmFsX2luY29tZV90YXggdmFyaWFibGUKcGVyc29uYWxpbmNvbWV0YXggPSBteWRhdGEkcGVyc29uYWxfaW5jb21lX3RheApwZXJzb25hbGluY29tZXRheAoKIyBGcm9tIHRoZSBvcmRlcmVkIGRhdGFzZXQgRXh0cmFjdCBjb3Jwb3JhdGVfaW5jb21lX3RheCB2YXJpYWJsZQpjb3Jwb3JhdGVpbmNvbWV0YXggPSBteWRhdGEkY29ycG9yYXRlX2luY29tZV90YXgKY29ycG9yYXRlaW5jb21ldGF4CgpgYGAKCiMjIyNTY2F0dGVyIFBsb3QgUGVyc29uYWwgYW5kIENvcnBvcmF0ZSBJbmNvbWUKCmBgYHtyfQojIFBsb3QgcGVyc29uYWxfaW5jb21lX3RheCB2cy4gY29ycG9yYXRlX2luY29tZV90YXggCiMgcGVyc29uYWxfaW5jb21lX3RheCB3aWxsIGJlIG9uIHRoZSB4LWF4aXMKIyBjb3Jwb3JhdGVfaW5jb21lX3RheCB3aWxsIGJlIG9uIHRoZSB5LWF4aXMKCnBsb3QocGVyc29uYWxpbmNvbWV0YXgsY29ycG9yYXRlaW5jb21ldGF4KQoKYGBgCgojIyMjTmFtaW5nIFF1YXJ0ZXIKCmBgYHtyfQpxdWFydGVyID0gbXlkYXRhJHF1YXJ0ZXIKcXVhcnRlcgpgYGAKCiMjIyNFbnRyaWVzIGdyZWF0ZXIgdGhhbiAxOTk5IGFuZCBvbmx5IGVudHJpZXMgZnJvbSBRMQpgYGB7cn0KIyBUbyBjcmVhdGUgYSBuZXdfZGF0YSBmaWx0ZXJpbmcgZm9yIGFuIE4gTlVNRVJJQyB2YWx1ZSB3ZSBjYW4gZG8gdGhlIGZvbGxvd2luZwojIG5ld19kYXRhID0gbXlkYXRhWyBteWRhdGEkTlVNRVJJQ19WQVJJQUJMRSA+IE4sIF0KbmV3X2RhdGEgPSBteWRhdGFbbXlkYXRhJHllYXIgPiAxOTk5ICwgXQoKIyBJZiB3ZSBuZWVkIHRvIG1ha2UgYW5vdGhlciBmaWx0ZXIgb24gYSBOT04tTlVNRVJJQyB3ZSBjYW4gZG8gdGhlIGZvbGxvd2luZwojIG5ld19kYXRhID0gbmV3X2RhdGFbIG5ld19kYXRhJENIQVJfVkFSSUFCTEUgPT0gIlExIiwgXQpuZXdfZGF0YSA9IG5ld19kYXRhW25ld19kYXRhJHF1YXJ0ZXIgPT0gIlExIiAsXQoKaGVhZChuZXdfZGF0YSkKYGBgCgojIyMjU2NhdHRlciBTbW9vdGggR3JhcGggUGVyc29uYWwgYW5kIENvcnBvcmF0ZSBJbmNvbWUgVGF4CgpgYGB7cn0Kc2NhdHRlci5zbW9vdGgocGVyc29uYWxpbmNvbWV0YXgsY29ycG9yYXRlaW5jb21ldGF4KQpgYGAKCiMjIyNTY2F0dGVyIFNtb290aCBHcmFwaCBUb3RhbCBUYXggVVMgYW5kIFRvdGFsIFN0YXRlCgpgYGB7cn0KIyB0b3RhbF90YXhfVVMgdnMuIHRvdGFsX3N0YXRlCgp0b3RhbHRheFVTID0gbXlkYXRhJHRvdGFsX3RheF9VUwp0b3RhbHRheFVTCgp0b3RhbHN0YXRlID0gbXlkYXRhJHRvdGFsX3N0YXRlCnRvdGFsc3RhdGUKCnNjYXR0ZXIuc21vb3RoKHRvdGFsdGF4VVMsdG90YWxzdGF0ZSkKYGBgCgpUbyBxdWFudGlmeSB0aGUgZGF0YSwgaXRzIGJlc3QgdG8gbG9vayBhdCB0aGUgY29ycmVsYXRpb24gYmV0d2VlbiB0d28gdmFyaWFibGVzLgpXaGF0IGRvZXMgdGhpcyBjb3JyZWxhdGlvbiBleHBsYWluPwoKVGhpcyBjb3JyZWxhdGlvbiBzaG93cyBob3cgcmVsYXRpdmUgdGhlIGRhdGEgaXMgdG8gZWFjaCBvdGhlci4gU2luY2UgdGhlIGRhdGEgaXMgaGlnaCBhdCAuOTYgdGhleSBhcmUgdmVyeSBjb3JyZWxhdGVkLiAKCiMjIyNDb3JyZWxhdGlvbiBvZiBUb3RhbCBTdGF0ZSBhbmQgUGVyc29uYWwgSW5jb21lIFRheAoKYGBge3J9CmNvcih0b3RhbHN0YXRlLHBlcnNvbmFsaW5jb21ldGF4KQpgYGAKCgojIyMjQ29ycmVsYXRpb24gQmV0d2VlbiBFdmVyeSBQYWlyIG9mIFZhcmlhYmxlcwoKYGBge3J9CiMgVG8gbWFrZSBhIGNvcnJlbGF0aW9uIHRhYmxlIG9mIGFsbCB0aGUgTlVNRVJJQyB2YXJpYWJsZXMgeW91IGNhbiBzZWxlY3Qgc29tZSBjb2x1bW5zIG9yIGEgcmFuZ2Ugb2YgY29sdW1ucywgd2l0aCB0aGUgZm9sbG93aW5nIGNvbW1hbmQ6CgojIGNvcnIwMSA9IG15ZGF0YVsgYygzLDQpIF0gKFRoZSBjb21tYW5kIGMoMyw0LC4uLikgaW5zaWRlIHRoZSBicmFja2V0cyBzZWxlY3RzIGEgZ2l2ZW4gY29sdW1uICkKIyBjb3IoY29ycjAxKSAod2lsbCBnaXZlIHlvdSB0aGUgY29ycmVsYXRpb24gdGFibGUgZm9yIHZhcmlhYmxlcyBpbiBjb2x1bW5zIDMgYW5kIDQpCmNvcnIwMSA9IG15ZGF0YSBbYygzLDQsNSw2LDcsOCldCmNvcihjb3JyMDEpCgojIGNvcnIwMiA9IG15ZGF0YVszOjVdICggdGhlIGNvbW1hbmQgWzM6NV0gc2VsZWN0cyBhIHJhbmdlIG9mIGNvbHVtbnMgZnJvbSAzIHRvIDUpCiMgY29yKGNvcnIwMikKCmNvcnIwMiA9IG15ZGF0YSBbMzo4XQpjb3IoY29ycjAyKQpgYGAKCi0tLS0tLS0tLS0KCiMjIyBUYXNrIDMgLSBUQUJMRUFVCgojIyMjU2hlZXQgMSB3aXRoIERlcGFydG1lbnQgTmFtZSBhbmQgTnVtYmVyIG9mIFJlY29yZHMKCgoqIFdoYXQgZGVwYXJ0bWVudCAnYmluJyBoYXMgdGhlIGhpZ2hlc3QgY291bnQ/IFdoYXQgaXMgdGhlIGNvdW50PyAKClRoZSBkZXBhcnRtZW50IGJpbiB0aGF0IGhhcyB0aGUgaGlnaGVzdCBjb3VudCBpcyBEZXBhcnRtZW50IG9mIFB1YmxpYyBXb3JrcyB3aXRoIGEgY291bnQgb2YgNSw1MjMKCiFbXShpbWdzL2V4YW1wbGUxLnBuZykKVGhpcyBpcyBhbm90aGVyIHZpZXcgb2YgdGhlIGRlcGFydG1lbnQgbmFtZSBhbmQgdGhlIG51bWJlciBvZiByZWNvcmRzLiBFYWNoIHJpbmcgc2hvd3MgaG93IG1hbnkgcmVjb3JkcyBhbmQgd2hlbiB5b3UgY2xpY2sgb24gYSByaW5nIGl0IHRlbGxzIHlvdSB0aGUgZGVwYXJ0bWVudCBuYW1lLiBJdCBpcyBpbnRlcmVzdGluZyB0byBub3RlIHRoYXQgbW9zdCBvZiB0aGUgZGVwYXJ0bWVudHMgaGF2ZSBiZXR3ZWVuIDAgYW5kIDEsMDAwIHJlY29yZHMuIEl0IGlzIHJhcmUgdGhhdCB0aGVyZSBhcmUgcmVjb3JkcyBhYm92ZSAxLDAwMCBpbiBvbmUgZGVwYXJ0bWVudCBhbmQgdmVyeSByYXJlIHRoYXQgdGhlcmUgaXMgYWJvdmUgNCwwMDAgcmVjb3JkcyBpbiBhIGRlcGFydG1lbnQuIAoKCiMjIyMgTmV3IFNoZWV0IHdpdGggJ051bWJlciBvZiBSZWNvcmRzJyBhbmQgJ1ZlbmRvci5aaXAnCiFbXShpbWdzL2V4YW1wbGUyLnBuZykKClRoZSBoaWdobGlnaHRzIG9uIHRoZSBtYXAgc2hvdyB3aGVyZSB0aGUgbW9zdCBudW1iZXIgb2YgcmVjb3JkcyBvY2N1ciBpbiB0ZXJtcyBvZiB2ZW5kb3IuIFRoZXJlIHNlZW1zIHRvIGJlIHRoZSBsYXJnZXN0IGNvbmNlbnRyYXRpb24gaW4gdGhlIHNvdXRoIGFuZCBhbHNvIHRoZSBub3J0aGVhc3QuIA==