select sum(amount) as total,year,duns,zip,agencyid,countryCode,state from fedconnect.`fd_companyPerformanceAgency_current` as fd_companyPerformanceAgency where 1 and duns IN('001317601','945580587','078390708','175252894','848003661','007113228','001326495','785627931','926784042','826336344','167380711','099114287','095633152','798861048','086723285','152020629','806500521','089176176','007119050','009214214','177667227','078576738','602458721','027579460','626399831','808376193','624449968','621599893','968795604','195194779','963906529','805603128','147286186','159836121','126368257','159734151','824657969','878901396','128729373','933678708','797407517','612706465','043991108','050471416','968993910','121621346','078883327','032987476','017711888','883073371','783044597','053859500','040549461','178617031','004048013','089896737','056354640','004868105','079871820','010605464','073838534','877936518','958291411','797203932','167228357','073891921','007685969','077817617','603847393','835130485','007923014','876949058','076192475','079209257','145969783','006928857','088365767','154764257','024775638','153910070','087701231','141089040','134718985','161771535','867714768','032093028','967276440','615378007','557181422','196094283','926451519','968904698','177055329','805258373','103231817','002067155','041152224','134345326','002241164','787800114','959660036','801993788','126174635','019121586','002484665','147218333','805628182','078790103','001824663','932902364','603439428','048855423','004677399','131468071','133304415','965790186','175197565','003255213','161270579','831017848','804891851','555498187','798318598','965479863','006958318','147286269','161185269','135838084','110560104','792975781','076583830','607811387','120406462','006811389','161607291','826518438','829852727','077852341','033324117','097779698','127208879','018971870','808500081','965525418','096370655','078604247','836196972','608461898','015017382','024945706','017018859','118330203','966769072','068715424','830713637','127136252','165133646','606628410','125834866','006908511','006920284','154760784','006261481','956711444','066781956','069341972','786468199','012641031','054353644','780026048','077799799','142892145','110091808','805948051','965091606','801397204','086710329','053983862','094160959','078871879','079877690','080374438','361157287','079439450','805784683','145965872','961530545','078652615','963999651','087694808','806502816','001735856','043964519','962048646','160759135','134117691','004018891','968969514','800770810','961821852') group by duns,zip,agencyid,year FEDMINE™- TOP FEDERAL CONTRACTORS By Place Of Performance By - '' - '2017' - Copyright FEDMINE™
FEDMINE Home Page

Created on : 11/02/2016 09:22:37 AM
© FEDMINE™ All Rights Reserved

# 11) COMPARATIVE 4 - Year FEDERAL PRIME CONTRACTOR REVENUES Nested By Place Of Performance
Pre-Sorted For FY: 2017