Wikidata:Property proposal/SAM id

SAM id

Originally proposed at Wikidata:Property proposal/Authority control

   Done: SAM ID (P9955) (Talk and documentation)

Description	Entity identifier in the US System for Award Management (aliases: SAM, US SAM, US SAM id, UEI, Unique Entity ID)
Represents	System for Award Management (Q5060650)
Data type	External identifier
Domain	organization (Q43229)
Allowed values	[0-9A-Z]{12}
Example 1	Ontotext (Q7095072) → M9SFLVKSDLV1
Example 2	Consiglio Nazionale delle Ricerche (Q902464) → CWVEJHEWM684
Example 3	Istituto di Chimica Biomolecolare (Q30267025) → JXCSEVSG7785
Example 4	Institute for Research on Population and Social Policies (Q61932950) → ZMTEH4J6JCM7
Example 5	Astrium (Q499207) → CK6JEE77RH16
Example 6	Airbus Defence and Space (Q15529123) → MJ5MN6SGYKF6
Example 7	Walltopia (Q7963260) → ZL7TFP65JTM9
Example 8	Bergen (Q4891472) → KQCMWJUW94J1
Source	https://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 source	804186 (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 completeness	always incomplete (Q21873886)
Formatter URL	https://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 also	D-U-N-S number (P2771), CAGE code (P5574)
Distinct-values constraint	yes
Wikidata project	WikiProject Companies (Q15271936), WikiProject Economics (Q7212331), WikiProject Authority control (Q88300058)

Motivation

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

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)

Notified participants of WikiProject Economics

Vladimir Alexiev (talk) 11:59, 13 March 2017 (UTC) Jonathan Groß (talk) 17:52, 26 March 2017 (UTC) Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits Jneubert (talk) 13:47, 29 April 2017 (UTC) Sic19 (talk) 20:42, 12 July 2017 (UTC) Wikidelo (talk) 21:15, 8 May 2018 (UTC) ArthurPSmith (talk) 19:52, 22 August 2018 (UTC) PKM (talk) 19:40, 23 August 2018 (UTC) Ettorerizza (talk) 06:44, 8 October 2018 (UTC) Fuzheado (talk) 03:47, 19 December 2018 (UTC) Daniel Mietchen (talk) 16:30, 7 April 2019 (UTC) Iwan.Aucamp (talk) 21:48, 3 October 2019 (UTC) Epìdosis (talk) 23:49, 22 November 2019 (UTC) Sotho Tal Ker (talk) 00:52, 1 May 2020 (UTC) Bargioni (talk) 09:48, 02 May 2020 (UTC) Carlobia (talk) 14:34, 11 May 2020 (UTC) Pablo Busatto (talk) 03:22, 23 June 2020 (UTC) Matlin (talk) 10:53, 6 July 2020 (UTC) Msuicat (talk) 21:57, 27 August 2020 (UTC) Uomovariabile (talk) 10:04, 27 October 2020 (UTC) Silva Selva (talk) 17:21, 30 November 2020 (UTC) 1-Byte (talk) 15:52, 14 December 2020 (UTC) Alessandra.Moi (talk) 17:26, 16 February 2021 (UTC) CamelCaseNick (talk) 21:20, 20 February 2021 (UTC) Songceci (talk) 18:45, 24 February 2021 (UTC)]] moz (talk) 10:48, 8 March 2021 (UTC) AhavaCohen (talk) 14:41, 11 March 2021 (UTC) Kolja21 (talk) 17:37, 13 March 2021 (UTC) RShigapov (talk) 14:34, 19 September 2021 (UTC) Jason.nlw (talk) 15:15, 30 September 2021 (UTC) MasterRus21thCentury (talk) 20:22, 18 October 2021 (UTC) Newt713 (talk) 08:42, 13 March 2022 (UTC) Pierre Tribhou (talk) 08:00, 20 March 2022 (UTC) Powerek38 (talk) 17:21, 14 April 2022 (UTC) Ahatd (talk) 08:34, 4 August 2022 (UTC) JordanTimothyJames (talk) 00:54, 31 August 2022 (UTC) --Silviafanti (talk) 17:07, 14 September 2022 (UTC) Back ache (talk) 02:03, 1 November 2022 (UTC) AfricanLibrarian (talk) M.roszkowski (talk) 10:44, 4 January 2023 (UTC) Rhagfyr (talk) 19:36, 9 January 2023 (UTC) — Haseeb (talk) 13:10, 4 August 2023 (UTC) 沈澄心✉ 13:26, 15 November 2023 (UTC)

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)

Discussion

•  Support Nice. Yes DUNS would be nice but it's not a simple matter; I wasn't aware of the SAM id but this sounds very useful, especially as it's not limited to US organizations/companies. ArthurPSmith (talk) 16:42, 8 September 2021 (UTC)
•  Support RShigapov (talk) 16:31, 19 September 2021 (UTC)
• @Vladimir Alexiev, ArthurPSmith, RShigapov:
  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
  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)
  Notified participants of WikiProject Economics
  Vladimir Alexiev (talk) 11:59, 13 March 2017 (UTC) Jonathan Groß (talk) 17:52, 26 March 2017 (UTC) Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits Jneubert (talk) 13:47, 29 April 2017 (UTC) Sic19 (talk) 20:42, 12 July 2017 (UTC) Wikidelo (talk) 21:15, 8 May 2018 (UTC) ArthurPSmith (talk) 19:52, 22 August 2018 (UTC) PKM (talk) 19:40, 23 August 2018 (UTC) Ettorerizza (talk) 06:44, 8 October 2018 (UTC) Fuzheado (talk) 03:47, 19 December 2018 (UTC) Daniel Mietchen (talk) 16:30, 7 April 2019 (UTC) Iwan.Aucamp (talk) 21:48, 3 October 2019 (UTC) Epìdosis (talk) 23:49, 22 November 2019 (UTC) Sotho Tal Ker (talk) 00:52, 1 May 2020 (UTC) Bargioni (talk) 09:48, 02 May 2020 (UTC) Carlobia (talk) 14:34, 11 May 2020 (UTC) Pablo Busatto (talk) 03:22, 23 June 2020 (UTC) Matlin (talk) 10:53, 6 July 2020 (UTC) Msuicat (talk) 21:57, 27 August 2020 (UTC) Uomovariabile (talk) 10:04, 27 October 2020 (UTC) Silva Selva (talk) 17:21, 30 November 2020 (UTC) 1-Byte (talk) 15:52, 14 December 2020 (UTC) Alessandra.Moi (talk) 17:26, 16 February 2021 (UTC) CamelCaseNick (talk) 21:20, 20 February 2021 (UTC) Songceci (talk) 18:45, 24 February 2021 (UTC)]] moz (talk) 10:48, 8 March 2021 (UTC) AhavaCohen (talk) 14:41, 11 March 2021 (UTC) Kolja21 (talk) 17:37, 13 March 2021 (UTC) RShigapov (talk) 14:34, 19 September 2021 (UTC) Jason.nlw (talk) 15:15, 30 September 2021 (UTC) MasterRus21thCentury (talk) 20:22, 18 October 2021 (UTC) Newt713 (talk) 08:42, 13 March 2022 (UTC) Pierre Tribhou (talk) 08:00, 20 March 2022 (UTC) Powerek38 (talk) 17:21, 14 April 2022 (UTC) Ahatd (talk) 08:34, 4 August 2022 (UTC) JordanTimothyJames (talk) 00:54, 31 August 2022 (UTC) --Silviafanti (talk) 17:07, 14 September 2022 (UTC) Back ache (talk) 02:03, 1 November 2022 (UTC) AfricanLibrarian (talk) M.roszkowski (talk) 10:44, 4 January 2023 (UTC) Rhagfyr (talk) 19:36, 9 January 2023 (UTC) — Haseeb (talk) 13:10, 4 August 2023 (UTC) 沈澄心✉ 13:26, 15 November 2023 (UTC)
  Notified participants of WikiProject Authority control  Done as SAM ID (P9955). UWashPrincipalCataloger (talk) 08:08, 9 October 2021 (UTC)