Property talk:P2088
Documentation
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 sensitivity (Q257869) | ||||||||||||
Data type | External identifier | ||||||||||||
Domain | According to this template:
organisations
According to statements in the property:
When possible, data should only be stored as statementsorganization (Q43229), website (Q35127), periodical (Q1002697), software (Q7397), digital distribution platform (Q19307174), brand (Q431289), trademark (Q167270), service (Q7406919) or mass media (Q11033) | ||||||||||||
Allowed values | According to this template:
Valid CrunchBase URL slugs
According to statements in the property:
When possible, data should only be stored as statements(?![a-z0-9]{8}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{4}-[a-z0-9]{12})[^A-Z /]+ | ||||||||||||
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:
When possible, data should only be stored as statementshttps://www.crunchbase.com/ | ||||||||||||
Formatter URL | https://www.crunchbase.com/organization/$1 | ||||||||||||
See also | Crunchbase person ID (P2087), PitchBook profile ID (P12689), Cbonds company profile (P12700) | ||||||||||||
Lists |
| ||||||||||||
Proposal discussion | Proposal discussion | ||||||||||||
Current uses |
| ||||||||||||
Search for values |
List of violations of this constraint: Database reports/Constraint violations/P2088#Unique value, SPARQL (every item), SPARQL (by value)
List of violations of this constraint: Database reports/Constraint violations/P2088#single best value, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P2088#Conflicts with P2087, search, SPARQL
(?![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#Type Q43229, Q35127, Q1002697, Q7397, Q19307174, Q431289, Q167270, Q7406919, Q11033, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P2088#Entity types
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: Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.) |
Uppercase permalinks
[edit]Notified participants of WikiProject Economics
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
[edit]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)
- All Properties
- Properties with external-id-datatype
- Properties used on 10000+ items
- Properties with unique value constraints
- Properties with single best value constraints
- Properties with conflicts with constraints
- Mandatory constraints with exceptions
- Properties with format constraints
- Properties with constraints on type
- Properties with entity type constraints
- Properties with scope constraints