endpoints search/spending_by_award/ and search/spending_by_transaction/ include DUNS but not UEI

[charlie-dilorenzo-two-six-tech]

Summary

mod/ type issue

The bulk_downloads endpoints contains nearly all the fields that one would expect. Looking at the markdown page for this endpoint, DUNS is properly configured, however UEI is not.

I have tried recipient_uei (which is the column name for bulk downloads) which has not worked (just like "GarbleyGook").

It seems like this information should be available considering that UEI is simply the replacement for DUNS. Please add UEI as a field to those endpoints and probably all other endpoints that include a reasonable amount of data for the recipient.

Python Script File

import json
import requests
method = "POST"
endpoint = "/api/v2/search/spending_by_award/"
main_url = "https://api.usaspending.gov"
url = main_url + endpoint
headers = {'content-type': 'application/json'}

# ------ DUNS DISPLAYS WHERE APPLICABLE ------
print("------ DUNS DISPLAYS WHERE APPLICABLE ------")
cuttoff_date = "2020-04-04"
cutoff = cuttoff_date.split("-")
cutoff = [int(item) for item in cutoff]
data = {"filters": {"keywords": ["the"], "award_type_codes": ["A", "B", "C", "D"], "time_period": [{"end_date": cuttoff_date}]}, "fields": ["Recipient Name", "Award ID", "Recipient DUNS Number", "recipient_uei", "End Date"], "page": 1, "limit": 100, "sort": "Award ID", "order": "desc"}
r = requests.request(method, url, data=json.dumps(data), headers=headers)
print(r.status_code)
res = (json.loads(r.text))["results"]
COMPACT = [str((item["Recipient Name"],item["Recipient DUNS Number"],item["recipient_uei"],item["End Date"])) for item in res]
duns_list = [item["Recipient DUNS Number"] for item in res]
number_lacking_duns = duns_list.count(None)
COMPACT = [str(("Recipient Name", "Recipient DUNS Number","recipient_uei","End Date")), "-"*74] + COMPACT
print("\n".join(COMPACT))
hyphens = 22*"-"
print(f"\n\n{hyphens}\nNumber Lacking DUNS: {number_lacking_duns}\n{hyphens}")

Python Script Output

% python temp.py
200
('Recipient Name', 'Recipient DUNS Number', 'recipient_uei', 'End Date')
--------------------------------------------------------------------------
('CELLCO PARTNERSHIP', '968904698', None, '2012-03-16')
('IRON BOW TECHNOLOGIES, LLC', '827714507', None, '2015-10-15')
('THE CENTECH GROUP INC', '191341627', None, '2015-07-01')
('NATIONAL INDUSTRIES FOR THE BLIND', '001672120', None, '2018-02-28')
('WORLD WIDE TECHNOLOGY LLC', '614948396', None, '2015-10-30')
('WORLD WIDE TECHNOLOGY LLC', '614948396', None, '2015-10-24')
('CARAHSOFT TECHNOLOGY CORP', '088365767', None, '2017-09-29')
('CDW GOVERNMENT LLC', '026157235', None, '2014-10-27')
('J & J MAINTENANCE, INC.', '055124077', None, '2015-01-25')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2013-11-19')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2011-10-22')
('ROBINS & MORTON GROUP, THE', '798696928', None, '2014-09-28')
('ROBINS & MORTON GROUP, THE', '798696928', None, '2013-07-31')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2012-09-01')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2011-04-28')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2011-06-18')
('ROBINS & MORTON GROUP, THE', '798696928', None, '2015-04-17')
('VALIANT GOVERNMENT SERVICES LLC', '616858908', None, '2015-07-28')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2011-01-26')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2010-10-18')
('VALIANT GOVERNMENT SERVICES LLC', '616858908', None, '2013-06-30')
('DLT SOLUTIONS, LLC', '786468199', None, '2013-10-15')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2011-05-31')
('ROBINS & MORTON GROUP, THE', '798696928', None, '2015-01-05')
('DLT SOLUTIONS, LLC', '786468199', None, '2012-11-24')
('FLIPPEN GROUP, L.L.C., THE', '011932659', None, '2010-06-17')
('ROBINS & MORTON GROUP, THE', '798696928', None, '2014-09-18')
('AECOM TECHNICAL SERVICES, INC.', '003184462', None, '2014-09-30')
('NATIONAL INDUSTRIES FOR THE BLIND', '001672120', None, '2017-07-05')
('HON COMPANY LLC, THE', '147814735', None, '2014-09-30')
('THE CENTECH GROUP INC', '191341627', None, '2014-03-31')
('THE CENTECH GROUP INC', '191341627', None, '2013-10-26')
('THE CENTECH GROUP INC', '191341627', None, '2013-10-27')
('THE CENTECH GROUP INC', '191341627', None, '2013-09-22')
('THE CENTECH GROUP INC', '191341627', None, '2014-03-10')
('LOCKHEED MARTIN INTEGRATED SYSTEMS, LLC', '801371365', None, '2012-09-30')
('THE CENTECH GROUP INC', '191341627', None, '2013-09-23')
('THE CENTECH GROUP INC', '191341627', None, '2013-09-30')
('THE CENTECH GROUP INC', '191341627', None, '2013-09-28')
('THE CENTECH GROUP INC', '191341627', None, '2013-09-21')
('THE CENTECH GROUP INC', '191341627', None, '2012-07-23')
('THE CENTECH GROUP INC', '191341627', None, '2012-06-23')
('THE CENTECH GROUP INC', '191341627', None, '2012-11-30')
('THE CENTECH GROUP INC', '191341627', None, '2012-03-01')
('THE CENTECH GROUP INC', '191341627', None, '2011-12-01')
('THE CENTECH GROUP INC', '191341627', None, '2010-09-10')
('THE CENTECH GROUP INC', '191341627', None, '2010-09-10')
('THE CENTECH GROUP INC', '191341627', None, '2010-08-26')
('THE CENTECH GROUP INC', '191341627', None, '2010-05-31')
('THE CENTECH GROUP INC', '191341627', None, '2009-11-16')
('THE CENTECH GROUP INC', '191341627', None, '2010-05-21')
('THE CENTECH GROUP INC', '191341627', None, '2009-10-08')
('THE CENTECH GROUP INC', '191341627', None, '2008-07-06')
('THE CENTECH GROUP INC', '191341627', None, '2008-07-04')
('AMERICAN HOSPITAL SERVICES GROUP LLC', '002939064', None, '2012-05-13')
('DONALD L. MOONEY ENTERPRISES, LLC', '019732036', None, '2011-09-30')
('THE CENTECH GROUP INC', '191341627', None, '2009-09-30')
('MEDICAL NORTH AMERICA JV', '963908004', None, '2016-09-30')
('THE CENTECH GROUP INC', '191341627', None, '2012-09-28')
('MEDICAL NORTH AMERICA JV', '963908004', None, '2016-09-30')
('RLM SERVICES, INC', '171059632', None, '2008-09-30')
('HON COMPANY LLC, THE', '147814735', None, '2015-11-15')
('MEDICAL NORTH AMERICA JV', '963908004', None, '2016-09-30')
('HON COMPANY LLC, THE', '147814735', None, '2015-08-09')
('BLUE TECH INC.', '121701957', None, '2015-10-30')
('INGENESIS INC', '019992424', None, '2016-09-30')
('HON COMPANY LLC, THE', '147814735', None, '2015-06-18')
('WESTON SOLUTIONS, INC.', '044519429', None, '2010-03-31')
('THE CENTECH GROUP INC', '191341627', None, '2009-11-16')
('MEDICAL NORTH AMERICA JV', '963908004', None, '2018-01-22')
('ALOHA HEALTH JOINT VENTURE 8A, LLC', '826030681', None, '2016-09-30')
('INGENESIS INC', '019992424', None, '2017-11-30')
('HEALING STAFF, INC., THE', '089500636', None, '2010-09-28')
('HON COMPANY LLC, THE', '147814735', None, '2015-03-13')
('WESTON SOLUTIONS, INC.', '044519429', None, '2010-05-05')
('SARATOGA MEDICAL CENTER, INC.', '144992658', None, '2016-11-30')
('DONALD L. MOONEY ENTERPRISES, LLC', '019732036', None, '2016-09-30')
('ALOHA HEALTH JOINT VENTURE 8A, LLC', '826030681', None, '2015-12-16')
("MILLER'S OF COLUMBIA, INC.", '047279716', None, '2016-07-08')
('HEALING STAFF, INC., THE', '089500636', None, '2010-09-28')
('HON COMPANY LLC, THE', '147814735', None, '2014-11-18')
('WESTON SOLUTIONS, INC.', '044519429', None, '2010-05-05')
('MICROTECHNOLOGIES LLC', '145454182', None, '2017-09-28')
('BTAS INC', '883504854', None, '2016-09-27')
('THE CENTECH GROUP INC', '191341627', None, '2016-07-31')
('ABSOLUTE STAFFERS LLC', '122502961', None, '2016-09-30')
('SPECIALTY GOVERNMENT SERVICES, LLC', '079976506', None, '2016-09-30')
('DONALD L. MOONEY ENTERPRISES, LLC', '019732036', None, '2016-09-30')
('WASHINGTON-HARRIS GROUP INC.', '188815948', None, '2016-12-17')
('ALOHA HEALTH JOINT VENTURE 8A, LLC', '826030681', None, '2016-09-30')
('LUKE & ASSOCIATES, INC.', '140302188', None, '2012-05-13')
('HON COMPANY LLC, THE', '147814735', None, '2013-10-07')
('CAPITOL SUPPLY, INC.', '131781643', None, '2012-09-24')
('ARORA GROUP, INC., THE', '933685562', None, '2006-09-30')
('HENRY SCHEIN, INC.', '012430880', None, '2016-09-07')
('HENRY SCHEIN, INC.', '012430880', None, '2016-09-07')
('HENRY SCHEIN, INC.', '012430880', None, '2016-09-07')
('UNICOM GOVERNMENT, INC.', '107939357', None, '2014-03-31')
('WGL ENERGY SERVICES, INC.', '962034856', None, '2014-11-03')
('HENRY SCHEIN, INC.', '012430880', None, '2016-09-06')


----------------------
Number Lacking DUNS: 0
----------------------