Jump to content

Wikidata:Property proposal/SAM id

From Wikidata

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]

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) Jeanne Noiraud (talk) 12:02, 4 December 2024 (UTC) Pragmatic Puffin (talk) 10:00, 18 February 2025 (UTC)[reply]

Notified participants of WikiProject Economics

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]