Wikidata:Property proposal/SAM id

From Wikidata
Jump to navigation Jump to search

SAM id[edit]

Originally proposed at Wikidata:Property proposal/Authority control

   Done: SAM ID (P9955) (Talk and documentation)
DescriptionEntity identifier in the US System for Award Management (aliases: SAM, US SAM, US SAM id, UEI, Unique Entity ID)
RepresentsSystem for Award Management (Q5060650)
Data typeExternal identifier
Domainorganization (Q43229)
Allowed values[0-9A-Z]{12}
Example 1Ontotext (Q7095072) → M9SFLVKSDLV1
Example 2Consiglio Nazionale delle Ricerche (Q902464) → CWVEJHEWM684
Example 3Istituto di Chimica Biomolecolare (Q30267025) → JXCSEVSG7785
Example 4Institute for Research on Population and Social Policies (Q61932950) → ZMTEH4J6JCM7
Example 5Astrium (Q499207) → CK6JEE77RH16
Example 6Airbus Defence and Space (Q15529123) → MJ5MN6SGYKF6
Example 7Walltopia (Q7963260) → ZL7TFP65JTM9
Example 8Bergen (Q4891472) → KQCMWJUW94J1
Sourcehttps://open.gsa.gov/api/sam-entity-extracts-api/, http://gsa.github.io/openIAE/developer_resources/Using_SAM_data_extracts/, https://sam.gov/data-services/Entity%20Registration/Public%20V2?privacy=Public
Number of IDs in source804186 (795638 Active, 8547 Expired in the last 6 months), date 2021-09-05, ref https://sam.gov/api/prod/fileextractservices/v1/api/download/Entity%20Registration/Public%20V2/SAM_PUBLIC_UTF-8_MONTHLY_V2_20210905.ZIP?privacy=Public
Expected completenessalways incomplete (Q21873886)
Formatter URLhttps://sam.gov/search/?index=ei&pageSize=25&page=1&sort=-modifiedDate&sfm%5Bstatus%5D%5Bis_active%5D=null&sfm%5Bkeywords%5D%5B0%5D%5Bvalue%5D=$1 (requires free registration)
See alsoD-U-N-S number (P2771), CAGE code (P5574)
Distinct-values constraintyes
Wikidata projectWikiProject Companies (Q15271936), WikiProject Economics (Q7212331), WikiProject Authority control (Q88300058)

Motivation[edit]

MD Imtiaz Ahammad Kopiersperre Jklamo ArthurPSmith S.K. Givegivetake fnielsen rjlabs ChristianKl Vladimir Alexiev Parikan User:Cardinha00 MB-one User:Simonmarch User:Jneubert Mathieudu68 User:Kippelboy User:Datawiki30 User:PKM User:RollTide882071 Andber08 Sidpark SilentSpike Susanna Ånäs (Susannaanas) User:Johanricher User:Celead User:Finnusertop cdo256 Mathieu Kappler RShigapov User:So9q User:1-Byte pmt Rtnf econterms Dollarsign8 User:Izolight maiki c960657 User:Automotom applsdev Bubalina Fordaemdur DaxServer

Notified participants of WikiProject Companies

Mcnabber091 (talk) 00:29, 18 June 2014 (UTC) Tobias1984 (talk) 10:23, 8 November 2015 (UTC) Note 1 PAC2 (talk) 09:29, 26 September 2016 (UTC) Rjlabs (talk) 20:30, 14 March 2017 (UTC) Datawiki30 (talk) 11:55, 2 September 2018 (UTC) Sidpark (talk) 09:31, 2 December 2018 (UTC) Mathieu Kappler (talk) 11:44, 6 September 2021 (UTC)[reply]

Notified participants of WikiProject Economics

Vladimir Alexiev Jonathan Groß Andy Mabbett Jneubert Sic19 Wikidelo ArthurPSmith PKM Ettorerizza Fuzheado Daniel Mietchen Iwan.Aucamp Epìdosis Sotho Tal Ker Bargioni Carlobia Pablo Busatto Matlin Msuicat Uomovariabile Silva Selva 1-Byte Alessandra.Moi CamelCaseNick Songceci moz AhavaCohen Kolja21 RShigapov Jason.nlw MasterRus21thCentury Newt713 Pierre Tribhou Powerek38 Ahatd JordanTimothyJames Silviafanti Back ache AfricanLibrarian M.roszkowski Rhagfyr 沈澄心 MrBenjo S.v.Mering

Notified participants of WikiProject Authority control

All entities in System for Award Management (Q5060650) have D-U-N-S number (P2771) and SAM id (military contractors also have CAGE code (P5574)), eg:

WD Entity SAM DUNS CAGE
Ontotext (Q7095072) ONTOTEXT USA INC M9SFLVKSDLV1 053393007 6H8F4
Consiglio Nazionale delle Ricerche (Q902464) CONSIGLIO NAZIONALE DELLE RICERCHE CWVEJHEWM684 440774594
Istituto di Chimica Biomolecolare (Q30267025) CNR - ISTITUTO DI CHIMICA BIOMOLECOLARE (ICB) JXCSEVSG7785 439307625 AQ773
Institute for Research on Population and Social Policies (Q61932950) CNR - ISTITUTO DI RICERCHE SULLA POPOLAZIONE E LE POLITICHE SOCIALI ZMTEH4J6JCM7 339096613 AK342
Astrium (Q499207) ASTRIUM SAS CK6JEE77RH16 737771675
Airbus Defence and Space (Q15529123) AIRBUS DEFENCE AND SPACE SAS MJ5MN6SGYKF6 261471459 F9073
Walltopia (Q7963260) WALLTOPIA AD ZL7TFP65JTM9 507489846 0154U
Bergen (Q4891472) TOWN OF BERGEN (Wisconsin, US) KQCMWJUW94J1 079103187 84NC0
  • DUNS seems to be their current choice of Unique Entity ID (UEI), but both are used fully
  • DUNS ids come with aggressive and offensive use restrictions, whereas SAM ids don't have such restrictions
  • There are public CSV dumps, updated monthly and daily; and more sophisticated API access
  • Currently there are 795k active entities and unknown total of expired entities (8.5k in the last 6 months alone)
  • Total of 120 fields including DUNS, SAM, CAGE, legal name, country, address, website, NAICS code (P3224) and PSC
  • 39.7% of the entities have a website (ENTITY URL), which is pretty good
  • I'm looking for collaborators to match SAM entities to WD by using name, country, website

Vladimir Alexiev (talk) 12:26, 8 September 2021 (UTC)[reply]

Discussion[edit]

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Property_proposal/SAM_id&oldid=1509762270"