Weekly Report

Select Week

select IDVPIID,fundingRequestingAgencyID,PIID,principalNAICSCode,vendorName,ultimateCompletionDate,signedDate,descriptionOfContractRequirement,modNumber,numberOfActions,obligatedAmount,baseAndAllOptionsValue,agencyID from `aw_16`.all where 1 and (signedDate BETWEEN '2016-05-30' and '2016-06-05') and modNumber = '0' and ( principalNAICSCode LIKE ('333319%') OR principalNAICSCode LIKE ('336413%') OR principalNAICSCode LIKE ('443120%') OR principalNAICSCode LIKE ('488190%') OR principalNAICSCode LIKE ('512191%') OR principalNAICSCode LIKE ('517110%') OR principalNAICSCode LIKE ('517919%') OR principalNAICSCode LIKE ('519190%') OR principalNAICSCode LIKE ('518210%') OR principalNAICSCode LIKE ('541199%') OR principalNAICSCode LIKE ('541219%') OR principalNAICSCode LIKE ('541310%') OR principalNAICSCode LIKE ('541330%') OR principalNAICSCode LIKE ('541490%') OR principalNAICSCode LIKE ('541511%') OR principalNAICSCode LIKE ('541512%') OR principalNAICSCode LIKE ('541513%') OR principalNAICSCode LIKE ('541519%') OR principalNAICSCode LIKE ('541611%') OR principalNAICSCode LIKE ('541612%') OR principalNAICSCode LIKE ('541613%') OR principalNAICSCode LIKE ('541614%') OR principalNAICSCode LIKE ('541618%') OR principalNAICSCode LIKE ('541620%') OR principalNAICSCode LIKE ('541690%') OR principalNAICSCode LIKE ('541710%') OR principalNAICSCode LIKE ('541711%') OR principalNAICSCode LIKE ('541712%') OR principalNAICSCode LIKE ('541910%') OR principalNAICSCode LIKE ('541930%') OR principalNAICSCode LIKE ('541990%') OR principalNAICSCode LIKE ('561110%') OR principalNAICSCode LIKE ('561210%') OR principalNAICSCode LIKE ('561611%') OR principalNAICSCode LIKE ('561612%') OR principalNAICSCode LIKE ('561613%') OR principalNAICSCode LIKE ('561621%') OR principalNAICSCode LIKE ('611310%') OR principalNAICSCode LIKE ('611410%') OR principalNAICSCode LIKE ('611420%') OR principalNAICSCode LIKE ('611430%') OR principalNAICSCode LIKE ('611512%') OR principalNAICSCode LIKE ('611519%') OR principalNAICSCode LIKE ('611699%') OR principalNAICSCode LIKE ('611710%') OR principalNAICSCode LIKE ('811212%') OR principalNAICSCode LIKE ('811213%') OR principalNAICSCode LIKE ('811219%') OR principalNAICSCode LIKE ('811310%') OR principalNAICSCode LIKE ('921190%') OR principalNAICSCode LIKE ('922190%') OR principalNAICSCode LIKE ('923120%') OR principalNAICSCode LIKE ('926110%') OR principalNAICSCode LIKE ('926130%') OR principalNAICSCode LIKE ('927110%') OR principalNAICSCode LIKE ('928110%') OR principalNAICSCode LIKE ('928120%')) and (signedDate BETWEEN '-2016-05-30-' and '-2016-06-05-') and ((agencyID <> '96CE' and fundingRequestingAgencyID <> '96CE') or (agencyID = '96CE' and fundingRequestingAgencyID = '96CE'))

No Contracts Posted for the week selected