Answers.Body: <p>There are <strong>2,140</strong> heads that have only been included in one minifig based on the <a href="https://bricks.stackexchange.com/q/1781/708">current Rebrickable database</a>. I generated the <a href="https://gist.github.com/jncraton/3527e0cb839bc30aeb54649c63e4c955" rel="noreferrer">full list of all heads</a> (as of March 28, 2022) including the unique number of minifigs they have been used in.</p>
  <p>For those who are curious or want to explore this in a different way, here's the query I used:</p>
  <pre><code>select
    count(1),
    part_num,
    color_id,
    name
  from
    inventories
    join inventory_parts on inventories.id = inventory_parts.inventory_id
    natural join parts
  where
    set_num like 'fig%'
    and (
      part_num like '24581%'
      or part_num like '33464%'
      or part_num like '3626%'
    )
  group by
    part_num,
    color_id
  order by
    count(1) desc;
  </code></pre>
  <p>It's worth noting that &quot;unique&quot; here is based on the mold, print, and color combination used by Rebrickable. A minifig head with the same color and print but different mold (often open/blocked/closed stud) will count as a unique head in this query.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-30T02:43:15.080Z
Answers.Text: I salute your SQL skills.
Answers.UserDisplayName: IvanSanchez
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-28T16:19:13.343Z
Answers.LastActivityDate: 2022-03-28T18:37:51.233Z
Answers.LastEditDate: 2022-03-28T18:37:51.233Z
Answers.UserDisplayName: jncraton
Body: <p>Most minifig heads seem to be shared by a few designs, but Alex's <a href="https://bricks.stackexchange.com/a/17029/6174">answer to a minifig identification question</a> left me wondering: how many minifigs have heads that are unique to them?  Presumably you're talking about a unique, widely recognizable character.  Or a more precise way to put it: how many (and which) minifig heads have only one minifigure associated with them from official sets?  And I think we should limit the set of minifig heads to those that bricklink calls &quot;Minifigure, Head&quot; and leave out &quot;Minifigure, Head, Modified&quot;.</p>
  <p>I'm guessing most of these are going to be for Star Wars or other licensed themes, but I'm hoping someone can find a good way to come up with an answer that lists the examples or show how to do a bricklink query to determine the answer.  If the list is included here it would only be complete at this point in time, but that would still be cool to see.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-27T18:15:31.540Z
Comments.Text: Do you only consider minifig heads with the standard head piece or other non-standard heads like The Simpsons, Disney etc minifigs?
Comments.UserDisplayName: Ambo100
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-27T18:57:57.823Z
Comments.Text: I think you may get this kind of information on Rebrickable, but I didn't find the proper mean of doing that. Quick search reveals that each part has number of times it appears in sets listed and that results are limited to 1k entries. You may ask, politely, on Rebrickable forums to run a custom query for you.
Comments.UserDisplayName: Alex
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-28T01:43:54.983Z
Comments.Text: @Ambo100 Since bricklink categorizes those "non-standard" heads as "Minifigure, Head, Modified" I think we can safely exclude them.  It seems fair to assume that most of those are for unique character minifigs and so a new question might be "which modified minified heads are reused the most?"
Comments.UserDisplayName: chicks
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-28T03:05:16.487Z
Comments.Text: A data point I find interesting: Velma was only ever in one, big Scoob set. She's quite rare. But her head wasn't. I assume it was in a build-a-minifig kiosk somewhere, since there's a store in Deutschland with almost 200 of those heads: <https://www.bricklink.com/v2/catalog/catalogitem.page?P=3626cpb1377&idColor=90#T=S&C=90&O={%22color%22:90,%22st%22:%224%22,%22iconly%22:0}> (Alas, even with the bracketing, the URL gets mangled and you have to manually sort by Highest Quantity yourself.)
Comments.UserDisplayName: RSchulz
Tags: <minifigures><set-database>
Title: How many minifigs have unique heads?
UserDisplayName: chicks
ThreadText: # How many minifigs have unique heads?
  
  (Asked by: username_0 on 2022-03-27)
  
  Most minifig heads seem to be shared by a few designs, but username_2's [answer to a minifig identification question](https://bricks.stackexchange.com/a/17029/6174) left me wondering: how many minifigs have heads that are unique to them? Presumably you're talking about a unique, widely recognizable character. Or a more precise way to put it: how many (and which) minifig heads have only one minifigure associated with them from official sets? And I think we should limit the set of minifig heads to those that bricklink calls "Minifigure, Head" and leave out "Minifigure, Head, Modified".
  
  I'm guessing most of these are going to be for Star Wars or other licensed themes, but I'm hoping someone can find a good way to come up with an answer that lists the examples or show how to do a bricklink query to determine the answer. If the list is included here it would only be complete at this point in time, but that would still be cool to see.
  
  **Tags:** minifigures, set-database
  
  > **Comments:**
  > **username_1**: Do you only consider minifig heads with the standard head piece or other non-standard heads like The Simpsons, Disney etc minifigs?  
  > **username_2**: I think you may get this kind of information on Rebrickable, but I didn't find the proper mean of doing that. Quick search reveals that each part has number of times it appears in sets listed and that results are limited to 1k entries. You may ask, politely, on Rebrickable forums to run a custom query for you.  
  > **username_0**: @username_1 Since bricklink categorizes those "non-standard" heads as "Minifigure, Head, Modified" I think we can safely exclude them.  It seems fair to assume that most of those are for unique character minifigs and so a new question might be "which modified minified heads are reused the most?"  
  > **username_3**: A data point I find interesting: Velma was only ever in one, big Scoob set. She's quite rare. But her head wasn't. I assume it was in a build-a-minifig kiosk somewhere, since there's a store in Deutschland with almost 200 of those heads: <https://www.bricklink.com/v2/catalog/catalogitem.page?P=3626cpb1377&idColor=90#T=S&C=90&O={%22color%22:90,%22st%22:%224%22,%22iconly%22:0}> (Alas, even with the bracketing, the URL gets mangled and you have to manually sort by Highest Quantity yourself.)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2022-03-28. Score: 8 | Accepted answer
  
  There are **2,140** heads that have only been included in one minifig based on the [current Rebrickable database](https://bricks.stackexchange.com/q/1781/708). I generated the [full list of all heads](https://gist.github.com/username_4/3527e0cb839bc30aeb54649c63e4c955) (as of March 28, 2022) including the unique number of minifigs they have been used in.
  
  For those who are curious or want to explore this in a different way, here's the query I used:
  
  ```
  select
    count(1),
    part_num,
    color_id,
    name
  from
    inventories
    join inventory_parts on inventories.id = inventory_parts.inventory_id
    natural join parts
  where
    set_num like 'fig%'
    and (
      part_num like '24581%'
      or part_num like '33464%'
      or part_num like '3626%'
    )
  group by
    part_num,
    color_id
  order by
    count(1) desc;
  
  ```
  
  It's worth noting that "unique" here is based on the mold, print, and color combination used by Rebrickable. A minifig head with the same color and print but different mold (often open/blocked/closed stud) will count as a unique head in this query.
  
  > **Comments:**
  > **username_5**: I salute your SQL skills.  
  
  ---
  
  