Property talk:P2088

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

Crunchbase organization ID
Identifier for an organization, in the Crunchbase database of companies and start-ups, operated by TechCrunch

Associated item	Crunchbase (Q10846831)
Applicable "stated in" value	Crunchbase (Q10846831)
Has quality	case sensitive (Q257869)
Data type	External identifier
Domain	According to this template: organisations According to statements in the property: organization (Q43229), website (Q35127) or periodical (Q1002697) When possible, data should only be stored as statements
Allowed values	According to this template: Valid CrunchBase URL slugs According to statements in the property: (?![a-z0-9]{8}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{12})[^A-Z /]+ When possible, data should only be stored as statements
Example	Facebook (Q355) → facebook Amazon (Q3884) → amazon Science (Q192864) → science-magazine RadicalMedia (Q4646764) → -radical-media
Source	According to this template: Wikipedia external links According to statements in the property: https://www.crunchbase.com/ When possible, data should only be stored as statements
Formatter URL	https://www.crunchbase.com/organization/$1
See also	Crunchbase person ID (P2087), PitchBook profile ID (P12689)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Mix'n'match (Report) Database reports/Constraint violations/P2088 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 73,224 Main statement 72,837 out of 3,132,264 (2% complete) 99.5% of uses Qualifier 7 <0.1% of uses Reference 380 0.5% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2088#Unique value, SPARQL (every item), SPARQL (by value)

Single best value: this property generally contains a single value. If there are several, one would have preferred rank (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2088#single best value, SPARQL

Conflicts with “Crunchbase person ID (P2087)”: this property must not be used with the listed properties and values. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2088#Conflicts with P2087, search, SPARQL

Format “(?![a-z0-9]{8}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{12})[^A-Z /]+”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P2088#Format, hourly updated report, SPARQL

Type “organization (Q43229), website (Q35127), periodical (Q1002697)”: item must contain property “instance of (P31)” with classes “organization (Q43229), website (Q35127), periodical (Q1002697)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2088#Type Q43229, Q35127, Q1002697, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2088#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2088#Scope, SPARQL

Pattern ^(https://www\.crunchbase\.com)?/?organization/([^A-Z /]+)$ will be automatically replaced to \2. Testing: TODO list

This property is being used by: en:Template:Crunchbase fa:الگو:Crunchbase id:Templat:Crunchbase ko:틀:Crunchbase vi:Bản mẫu:Crunchbase Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Uppercase permalinks

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

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

Most CB permalinks are in lowercase, but a tiny percentage include uppercase letters:

grep "[A-Z]" permalink.txt|sort>permalink-uppercase.txt
wc -l permalink.txt permalink-uppercase.txt
 2050775 permalink.txt
     272 permalink-uppercase.txt

I made a gist with the file so they can be added as exceptions to Wikidata over time: https://gist.github.com/VladimirAlexiev/39b12b9f7625ca61ab3fa9ea530c477c.

Currently we have recorded a few exceptions (https://www.wikidata.org/wiki/Property:P2088#P2088$7fc08d2e-4d2a-5670-f249-8a3d6699a841) and they work.

• But the respective section complains: "exceptions" is incompatible with "mandatory" parameter.
• Does anyone know how to fix this?

Note: there are permalinks with Chinese, Arabic and Russian characters. Vladimir Alexiev (talk) 11:14, 23 September 2022 (UTC)

Use permalink not guid

There were about 11 values that were not CB permalinks but GUIDs (I fixed them). CB redirects a GUID to the respective permalink, but I added a check in the regex:

    (?![a-z0-9]{8}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{12})[^A-Z /]+

with this syntax clarification:

• Don't use GUID, use Crunchbase Permalink (which is in lowercase)

Same for Crunchbase organization ID (P2088): there were 3 GUIDs, I fixed them -- Vladimir Alexiev (talk) 11:18, 23 September 2022 (UTC)