Property talk:P3242
Documentation
U.S. Standard Industrial Classification number for industries and economic activities
List of violations of this constraint: Database reports/Constraint violations/P3242#Entity types
List of violations of this constraint: Database reports/Constraint violations/P3242#Scope, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3242#Type Q123186574, SPARQL
scope and/or datatype
[edit] Notified participants of WikiProject Companies
Somehow this isn't being used as planned. Instead of being added to sectors, it ended up on companies. --- Jura 20:52, 9 January 2022 (UTC)
- Yes, this looks bad. @James Hare (NIOSH): - how do you think we should proceed? BorkedBot (talk • contribs • logs) seems to have entered at least some of these (ones I looked at). One option is to just redefine this property according to the way it's being used, but that would mean changing the datatype to String from External ID. Or we could propose a new property for applying the SIC code to a company as has been done, and migrate the existing uses. ArthurPSmith (talk) 14:28, 10 January 2022 (UTC)
- Looks like I misunderstood the property. I'm definitely willing to undo all the bot edits that made this if we decide to change the use of this property. I don't think I made *that* many edits using this property. BrokenSegue (talk) 22:58, 10 January 2022 (UTC)
- https://w.wiki/4hTF shows that 816 items with this prop are orgs, and only 15 are not orgs. I think we should first map most WD industries to SIC, then transfer the existing values to "industry" statements. Nobody has worked on matching this prop for 5.5 years and there isn't even a Mix-n-Match catalog. Pinging proposer @James_Hare_(NIOSH): --Vladimir Alexiev (talk) 14:14, 17 January 2022 (UTC)
- It's probably easier to create a new property for organizations (with string datatype) and convert most uses to that. --- Jura 12:13, 18 January 2022 (UTC)
statements about orgs |
---|
Q667865 3714 Q470317 3621 Q372657 6211 Q735261 7029 Q946080 7389 Q931233 6719 Q689446 1752 Q938668 7372 Q950419 5961 Q899022 2821 Q1046482 3674 Q894585 3841 Q839466 5141 Q1577587 1311 Q1390577 7371 Q1335585 3569 Q1342041 3559 Q1660996 7371 Q1641437 2329 Q2068984 8071 Q25775 6282 Q1984481 4931 Q2069106 3826 Q1502712 6311 Q2178198 7513 Q27065 4899 Q1825763 6311 Q7240 3761 Q3511885 4812 Q4680345 6282 Q4811929 7389 Q4742937 4512 Q4492609 5812 Q4686051 5531 Q96574679 6798 Q2916497 2834 Q4118850 5812 Q5192200 6798 Q7095328 4899 Q7156760 7372 Q4957288 6798 Q6387063 6331 Q6819538 1531 Q7084595 6021 Q6795931 7389 Q7305846 6531 Q6715352 3841 Q6517792 6036 Q7083862 4213 Q7276947 6331 Q5380195 4832 Q5983823 4911 Q5038056 7374 Q5147194 7599 Q7234972 6798 Q5204430 2834 Q5096273 4833 Q5986662 2299 Q5120253 6331 Q5586622 3561 Q6035325 7319 Q5906990 7372 Q5516980 5961 Q5696498 1041 Q15109885 3669 Q14993631 7379 Q15109887 3829 Q7573905 3711 Q7893967 8062 Q7857512 5621 Q7912737 2721 Q7521341 7372 Q7695732 3812 Q7824332 2064 Q24908086 6798 Q28233195 8641 Q25111982 2834 Q28446528 6022 Q16985829 3089 Q17183768 4731 Q16858667 3761 Q16983192 4924 Q16994588 6022 Q16959629 7379 Q17155112 2836 Q20486914 2679 Q20711490 5013 Q20979194 6798 Q23090931 6798 Q30265399 3845 Q55454011 384 Q56273983 7379 Q54622058 6022 Q39046155 1311 Q97860351 9329 Q95158851 7379 Q66823616 8071 Q65089744 2834 Q60764327 6162 Q60744565 7371 Q193326 6211 Q154387 4899 Q444110 6331 Q533415 5731 Q260833 3572 Q538203 5047 Q822614 4512 Q930919 4911 Q836040 3531 Q675585 6289 Q798819 6021 Q642610 4512 Q905806 2873 Q908324 7299 Q920037 5311 Q645708 6029 Q1345971 2711 Q1141173 7011 Q1353939 5963 Q1275577 1311 Q1287771 3251 Q1562826 4812 Q2404292 3674 Q2373884 7373 Q1784671 3674 Q2140077 4833 Q1944412 7389 Q1740323 3577 Q3331496 2835 Q3146975 3561 Q3067119 5039 Q2759586 5812 Q5384453 7323 Q5206232 4911 Q4698062 7359 Q4692116 2836 Q4827416 3674 Q5122694 6022 Q4743779 6331 Q5509271 3944 Q5025090 2741 Q5072155 7372 Q4041705 4213 Q3433273 5912 Q8072576 6021 Q7983629 6021 Q7978891 6021 Q7440621 3089 Q7662493 5045 Q7668516 2030 Q7567571 4924 Q7865844 3578 Q7937913 4911 Q7501150 7721 Q7392916 7372 Q7271456 8071 Q8041701 3577 Q7120959 2834 Q6818651 7371 Q6042841 1731 Q6456630 3421 Q16988318 4953 Q16979157 2911 Q16974527 3569 Q16997309 2834 Q17113791 4941 Q17108492 3556 Q18349283 7513 Q17091323 6798 Q54569524 37372 Q16531742 2992 Q16250432 6022 Q16013760 3053 Q14705393 3577 Q15109912 2833 Q30588251 6022 Q21410960 7372 Q19923099 3669 Q20858163 4011 Q20708193 6029 Q101982463 4833, 4841 Q108474744 73731 Q69910086 7221 Q85867603 80801 Q145168 5331 Q301965 4813 Q328840 7389 Q219508 6021 Q338825 7379 Q265176 3674 Q642189 3845 Q552581 7371 Q926699 3021 Q632240 2834 Q739084 6021 Q474621 3678 Q899183 2879 Q908961 2834 Q1199757 4841 Q741707 3743 Q868587 6282 Q1112588 2339 Q607131 6311 Q496302 3523 Q1656230 2911 Q1786345 6411 Q2874395 7514 Q1526456 2531 Q1645081 3312 Q1937503 3537 Q2907743 7371 Q1630559 6798 Q2825507 8711 Q4708516 4813 Q106615565 7999 Q5140275 8731 Q4411116 5045 Q4742486 6021 Q5082076 8732 Q98424095 1531 Q5047528 6035 Q3019129 1091 Q4744658 8062 Q4726659 2834 Q5152058 7372 Q4951483 7372 Q4781837 2834 Q106508061 8221 Q4827537 6798 Q4041316 3679 Q4045482 7382 Q7313497 7359 Q6513538 4833 Q7205567 2836 Q5189320 6798 Q7692121 3669 Q7388926 4899 Q7073021 3679 Q6863447 7371 Q6757974 6531 Q7669439 3724 Q6806791 7372 Q7132349 5812 Q7399844 4213 Q7012977 5699 Q7128508 7379 Q5457038 6035 Q7301386 6798 Q94777120 5531 Q5209286 2721 Q5923178 3825 Q5183828 3674 Q7391016 6798 Q5611081 5511 Q6113060 7373 Q5512854 6211 Q6426028 6799 Q5912596 4724 Q15109906 3842 Q15109846 2834 Q7864706 4911 Q7838954 2834 Q7880250 7372 Q7889101 7359 Q10397787 7359 Q23781052 3843 Q28406599 3714 Q15734041 2834 Q15915960 7372 Q16952393 6211 Q16953039 6282 Q16966841 3842 Q16840288 3442 Q17109447 3674 Q17141691 3674 Q17131128 2834 Q17145997 3086 Q17141393 4941 Q17986287 6035 Q22121866 8731 Q19654979 3949 Q30284052 2834 Q60772582 5945 Q55670965 55300 Q48739877 6798 Q105443900 5045 Q106435940 8071 Q71946 3312 Q151670 6331 Q165858 4839 Q644289 4813 Q470517 2836 Q285161 3639 Q621592 4841 Q645525 3674 Q624375 8099 Q486737 3612 Q1156045 6798 Q634815 3663 Q629998 5411 Q55622230 6211 Q53605429 2621 Q48976878 6035 Q65091423 1311 Q368181 6798 Q156238 1311 Q144060 3571 Q206921 2834 Q483959 7389 Q247489 2834 Q426583 3672 Q462984 4931 Q415598 7389 Q407744 2819 Q609466 2844 Q677488 6324 Q1044059 4489 Q1066028 6211 Q1022711 7379 Q880942 6282 Q1002992 5945 Q1049080 3576 Q1194832 7021 Q915543 3519 Q1049080 3361 Q1155668 3674 Q1529234 3569 Q1741634 2676 Q1325987 2015 Q1703389 6531 Q1344587 4911 Q1815011 4922 Q1715931 5045 Q26049 6324 Q3598926 7389 Q5426537 3812 Q5445299 5984 Q5173965 7372 Q5674337 7331 Q5357940 3699 Q5452332 6022 Q5597139 2631 Q5453009 6021 Q5324991 6022 Q5307031 5621 Q5278020 5812 Q5684524 6331 Q6036711 7374 Q4744566 6311 Q2331913 4499 Q6045277 7372 Q4677870 3646 Q4914632 2834 Q4828988 4931 Q4868109 2512 Q4983306 5651 Q4967514 7374 Q4835755 5812 Q7921370 7389 Q7934906 6211 Q7958965 6211 Q7829730 3674 Q10659632 3549 Q7987101 6021 Q7800873 1382 Q7987345 4899 Q17112054 6020 Q7707945 5812 Q17080741 3411 Q7259716 1522 Q7241774 2834 Q7431916 3312 Q6822359 5169 Q16951448 5521 Q16983334 2631 Q17747021 3741 Q6545004 4512 Q17018954 3699 Q6843476 6022 Q6806861 2099 Q17141146 8099 Q19604459 4932 Q91360366 5812 Q15964806 2834 Q15109862 2082 Q30256497 4953 Q24525746 4821 Q24204493 8099 Q21992261 8221 Q22121862 2836 Q25046191 6798 Q28048853 5999 Q106435451 58110 Q60763554 6798 Q135325 3356 Q81965 3711 Q539056 7741 Q427881 4489 Q176587 7372 Q393762 3825 Q73883753 7372 Q80947821 3842 Q85811579 6331 Q188514 3711 Q291508 4911 Q290680 7381 Q202972 2657 Q182477 3674 Q180106 3221 Q165684 4821 Q390074 8299 Q705392 3572 Q596139 3944 Q733482 3861 Q768773 6282 Q815694 4821 Q568532 7011 Q935059 3524 Q726654 2621 Q917002 7372 Q897097 7382 Q1339966 4610 Q619121 6282 Q847743 5812 Q1027181 3949 Q1322011 8071 Q1230295 4011 Q1364176 7371 Q1419446 6021 Q2286044 3674 Q3216588 6798 Q2303478 7371 Q7414 7372 Q1666040 2273 Q1925384 4813 Q1631922 3423 Q2087612 7374 Q3216600 2038 Q2749364 7382 Q4474231 3944 Q5063137 7011 Q5554922 8731 Q4047452 7374 Q5013834 8111 Q5169368 6411 Q4671580 2834 Q5035425 6021 Q4035714 1311 Q5203782 1522 Q5431118 4832 Q5647768 2329 Q5201295 2836 Q5453106 6021 Q3973262 4953 Q5439999 6111 Q5013072 6331 Q4994426 3842 Q4928676 6282 Q4019844 7389 Q4816705 7999 Q8035757 5172 Q7696143 3841 Q7067716 3841 Q8073337 2834 Q7070498 7299 Q7304886 5812 Q7242563 5331 Q7239836 6022 Q7165802 6035 Q7935247 6282 Q7089136 3316 Q7251172 2834 Q6410043 6798 Q6550657 3549 Q6545549 2023 Q5703474 7299 Q5884072 3844 Q6703279 3841 Q6735371 6331 Q6348410 3354 Q15109925 5261 Q16002190 4513 Q15109896 6035 Q28782856 7379 Q29641502 7371 Q25831370 7379 Q17113726 2835 Q17114287 3533 Q16994890 3826 Q16988748 6531 Q17084959 7372 Q19865761 6798 Q17146520 5411 Q16968189 6719 Q17125902 2834 Q16824426 2834 Q17078915 7389 Q16998439 6411 Q19867417 3663 Q22917772 2711 Q485908 4813 Q489080 7389 Q459965 3531 Q400384 3312 Q470156 5122 Q460446 7379 Q608776 7372 Q747207 3674 Q663452 3679 Q861042 7389 Q677464 4931 Q880296 4911 Q864407 5211 Q715583 5331 Q596499 1629 Q963809 3661 Q891163 5812 Q787044 3714 Q834888 3843 Q846246 3679 Q898208 3999 Q941127 7372 Q1001788 1041 Q1285819 5399 Q1685287 1442 Q1400073 3559 Q1145004 1041 Q1472929 6231 Q1327874 7371 Q1531473 3661 Q1506045 7011 Q851641 6798 Q1073540 4813 Q1453620 1021 Q1760641 7373 Q2299611 7375 Q2502355 2833 Q3046549 6029 Q2837996 6159 Q3116307 3674 Q3511946 6282 Q2902305 7382 Q2895117 3351 Q6015591 8731 Q107682748 3471 Q5302508 7948 Q5376825 1311 Q5289230 5331 Q5206170 3674 Q5061578 6510 Q5275736 7373 Q8033550 3728 Q107677729 3731 Q5099601 2836 Q4972437 6035 Q5228205 5812 Q4787395 3751 Q5254919 7389 Q4045079 5122 Q4816569 4813 Q5453008 6022 Q5170128 5141 Q4844439 6798 Q2283 7372 Q4650338 7349 Q5422162 6798 Q26311 6321 Q7353317 90020 Q7858146 3566 Q7695737 7389 Q7298901 6221 Q7907548 8711 Q7420971 7372 Q7114736 3291 Q7314050 7371 Q7353317 7487 Q7353317 2741 Q7118707 5999 Q6968762 8071 Q7257522 3731 Q6549207 8999 Q6750663 2834 Q7835892 5541 Q7912506 3441 Q108119942 357 Q21070725 5812 Q15109928 7389 Q11074156 4923 Q96575974 3555 Q96575127 6799 Q95205133 7513 Q17050423 8999 Q17114312 7376 Q16958009 2032 Q16932650 3674 Q16992684 5045 Q28175069 8071 Q66662475 5084 Q60238941 4841 Q56273715 3171 Q23786068 2834 Q22917772 7375 Q22058448 3674 Q33127130 7363 Q91387266 4493 Q91490380 3826 Q73900179 7999 Q356212 3873 Q464092 4911 Q128896 3674 Q127074 2899 Q219635 6211 Q143435 6321 Q813780 3841 Q744683 6282 Q656165 1381 Q498746 2819 Q931032 4922 Q489921 7389 Q667599 3089 Q1106938 4899 Q1034654 6153 Q1150535 1389 Q1127536 4931 Q1107035 7371 Q1957521 3359 Q1053299 3241 Q1471346 3632 Q1200840 3315 Q1543874 7510 Q1425063 7011 Q2094989 6029 Q1152764 6029 Q1817417 3533 Q1135278 6798 Q1666568 2869 Q1885491 6289 Q1969091 3711 Q2945643 3149 Q3072937 6022 Q4376955 7371 Q3552193 5651 Q6537727 2836 Q6998317 7373 Q6029685 3661 Q6990264 6141 Q7086908 2899 Q6902124 6021 Q6109309 2052 Q7084833 6361 Q6386533 6282 Q6647881 5511 Q5762186 8748 Q6703090 5211 Q17086972 8742 Q4856124 6022 Q5050852 5651 Q5099579 3714 Q5130952 2621 Q5165314 1311 Q11306218 7261 Q4928282 5812 Q4740289 2834 Q4749580 2899 Q5579415 7993 Q17513511 3359 Q16824238 2836 Q7512923 5944 Q7314415 4953 Q16984522 8062 Q7921363 7373 Q17110635 7361 Q7917863 4932 Q17087372 8711 Q7772938 5499 Q7571280 4920 Q7571413 1311 Q16932392 3999 Q18169198 3823 Q7538146 3577 Q16974741 2834 Q16950815 5031 Q7374224 6719 Q16980281 3841 Q7118693 5045 Q7196294 6021 Q7727445 5961 Q16984687 1311 Q8042415 4731 Q7920749 3171 Q7856971 1542 Q8071921 7389 Q30256843 2836 Q30283314 2834 Q20858221 7371 Q19572527 6021 Q25230554 7379 Q27022329 7375 Q58041994 1531 Q63296010 4412 Q61483981 3652 Q48971221 7371 Q100323973 6798 Q119991 1311 Q155026 4513 Q174310 5651 Q305473 8099 Q187212 3674 Q319344 5651 Q385452 7372 Q430745 7374 Q306764 3841 Q841458 6231 Q1024454 4011 Q742196 5812 Q907311 7832 Q784804 7539 Q905086 5047 Q1056637 2066 Q1502794 6798 Q1318848 7372 Q1673079 7389 Q1197548 3674 Q1798370 7721 Q1591976 3542 Q1141267 7499 Q1381973 6331 Q1671509 3674 Q1508526 3482 Q92639564 3569 Q2483225 2711 Q2140315 3721 Q2099437 3672 Q2013404 1311 Q3259355 3663 Q5142829 8211 Q3370152 1381 Q2961234 4841 Q3403513 6371 Q2979728 7372 Q3121014 8299 Q5472859 2434 Q5152539 3714 Q5453107 6022 Q5122438 5699 Q5412010 6099 Q4037686 5812 Q6036100 7374 Q4967421 8351 Q5130494 9511 Q5532852 7372 Q5629085 1231 Q5375543 6799 Q4033665 4512 Q4810399 6321 Q5116536 2841 Q5130656 7312 Q4745391 2434 Q4886950 3672 Q4854030 6021 Q7995089 6331 Q7680886 3674 Q7809768 2836 Q7851426 5331 Q7280388 3944 Q7280957 4832 Q7501097 5411 Q7605667 3312 Q6902090 7534 Q7304530 7011 Q7236078 3613 Q7308054 2834 Q7331170 5812 Q7119110 7389 Q7248721 6331 Q6468754 4924 Q6398722 7361 Q6782217 4841 Q6398035 1389 Q6813052 3674 Q7573912 5141 Q6952158 1231 Q6758107 7832 Q6971495 7311 Q6952868 6021 Q7017778 1311 Q6807739 7375 Q11463 7372 Q35476 4899 Q26913624 5961 Q28404585 4922 Q25245434 2836 Q15507516 3724 Q16981897 6331 Q17082992 7372 Q16986355 7319 Q16984188 3679 Q17144598 4931 Q17006727 3711 Q18168364 5311 Q19730939 4612 Q17149417 3272 Q20708639 3533 Q50039646 7810 Q50239180 7389 Q39086685 7359 Q39086685 4789 Q5059571 86 Q38928 6021 Q17109731 7373 Q110628692 6411 Q1774447 931 Q53268 3711 Q38076 5812 Q48754 2851 Q48872 3569 Q54173 3621 |
Above the ids if you someone wants to use them. --- Jura 10:22, 1 March 2022 (UTC)
DnB extension?
[edit]DnB uses an extension with 8-digit codes: http://www.dnb.com/content/dam/english/dnb-solutions/sales-and-marketing/sic_8_digit_codes.xls. Is it also covered by this property? Examples:
- Apple Orchard -> 01759901
- Maple sap gathering -> 08310106
- Air conditioning units, complete: domestic or industrial -> 35850101
- Air conditioning, motor vehicle -> 35850102 --Vladimir Alexiev (talk) 14:14, 17 January 2022 (UTC)
- If someone wanted to import these I'd be fine. I doubt we already have items for most of these since they are so specific. We could use a qualifier to distinguish them. Though the only property that comes to mind would be authority (P797) which isn't great. BrokenSegue (talk) 16:02, 17 January 2022 (UTC)
SIC Wikidata structure documentation
[edit]SIC industry classifications are now modeled on Wikidata. The information is drawn from a Census Bureau spreadsheet and SIC Manuals.
- Each Wikidata item represents a unique classification definition, not a unique code number. Note that a single definition may have multiple codes (at the same time or at different times), and a single code may have multiple definitions (at different times), as detailed below.
- Each classification has its own item with a instance of (P31): SIC industry classification (Q123186574) statement. These are separate from any existing "general" item about a specific industry, as the SIC definitions are specific; they should not be merged, but may be linked in some way if appropriate.
- SIC codes are hierarchical. Two-digit codes are the broadest, with four-digit codes being the most specific. There are also high-level "divisions" represented by a letter; these contain sets of two-digit codes, but sometimes do not correspond to the first digit.
- These are linked with part of (P361)/has part(s) (P527) statements.
- In some cases, a node has only one child, both with the same title and definition. In these cases, all such codes are listed on a single Wikidata item.
- SIC codes were revised periodically, with the 1987 version being the final one.
- The 1987 SIC codes (which are valid on and after that date) are fully represented in Wikidata.
- All SIC codes that were abolished in 1987 or 1977, and some abolished in 1972, are also represented. If they had the same title or definition as a later code, they are both listed in the same item with start time (P580) and end time (P582) qualifiers, regardless of any splits or merges that happened. (This is different than how NAICS codes are modeled.) Otherwise, a new item was created with a dissolved, abolished or demolished date (P576) statement, as well as replaced by (P1366) and/or merged into (P7888) statements.
- No attempt has been made to otherwise represent the structure of merges, splits, or title or definition changes. There is no guarantee that any 1987 code existed or had the same definition before 1987.
- There are also replaced by (P1366) statements linking to the newer NAICS industry classifications.
- If more than one Wikidata item has the same SIC code, there is also a separate item with an additional instance of (P31): conflation (Q14946528) statement and "[unspecified definition]" in the label. This is to assist for making lookup tables and for cases where the date is not clear.
John P. Sadowski (NIOSH) (talk) 05:07, 1 November 2023 (UTC)
Items with this Property
[edit]Show entries currently in use (not been replaced, have an end date or a demolished) 383 items at time of writing - https://w.wiki/AoRL Back ache (talk) 09:26, 31 July 2024 (UTC)