Closed simonw closed 2 years ago
simonw
commented
2 years ago Andy put together this, with some short (~1,000 item) lists of artists, celebrities and fictional characters for us to count: https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/edit
simonw
commented
2 years ago Fun trick:
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv' | \
sqlite-utils memory stdin:csv - --analyzeOutput for the artist Type column:
stdin.Type: (2/2)
Total rows: 1834
Null rows: 0
Blank rows: 87
Distinct values: 18
Most common:
328: Illustrator
300: Portrait Artist
249: Concept Artist
226: Traditional Artist
206: Landscape Artist
108: Photographer
108: Comic Book Artist
87:
67: 3D Artist
61: Misc
Least common:
1: tra
3: Director
6: Collage
7: Fashion Designer
12: Graffiti / Street Artist
19: Still Life
22: Graphic Designer
24: Architect
61: Misc
67: 3D Artisthttps://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csvhttps://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv&gid=1037423923https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv&gid=480391249simonw
commented
2 years ago Importing those into data.db:
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv' \
| sqlite-utils insert data.db artists - --csv
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv&gid=1037423923' \
| sqlite-utils insert data.db celebrities - --csv
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv&gid=480391249' \
| sqlite-utils insert data.db characters - --csvThis almost works:
# sqlite-utils data.db 'select name, (select count(*) from images_fts where images_fts match name) as search_count from celebrities'
[{"Name": "2 Chainz", "search_count": 928},
{"Name": "21 Savage", "search_count": 96},
{"Name": "50 Cent", "search_count": 6213},
{"Name": "Aaliyah", "search_count": 314},
{"Name": "Aaron Eckhart", "search_count": 306},
{"Name": "Aaron Hernandez", "search_count": 43},
{"Name": "Aaron Judge", "search_count": 333},
{"Name": "Aaron Lewis", "search_count": 835},
Traceback (most recent call last):
File "/usr/local/bin/sqlite-utils", line 8, in <module>
sys.exit(cli())
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1130, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1657, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 760, in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/sqlite_utils/cli.py", line 1705, in query
_execute_query(
File "/usr/local/lib/python3.10/site-packages/sqlite_utils/cli.py", line 1922, in _execute_query
for line in output_rows(cursor, headers, nl, arrays, json_cols):
File "/usr/local/lib/python3.10/site-packages/sqlite_utils/cli.py", line 2968, in output_rows
for row, next_row in itertools.zip_longest(current_iter, next_iter):
sqlite3.OperationalError: no such column: JohnsonThat error is likely caused by one of these rows:
{"Name": "Aaron Taylor-Johnson"},
{"Name": "Dwayne 'The Rock' Johnson"},Wrapping double quotes around the search fixed that. Had to use this EOF escaping trick:
sqlite-utils data.db "$(cat <<EOF
select name, (
select count(*) from images_fts where images_fts match '"' || name || '"'
) as search_count from celebrities order by search_count desc
EOF
)" --fmt githubHere's the --fmt github output:
| Name | search_count |
|---|---|
| Pink | 1020015 |
| Queen | 145223 |
| Blog | 113701 |
| Prince | 49917 |
| Future | 39899 |
| Eve | 38808 |
| Madonna | 34753 |
| Common | 24617 |
| Aurora | 19667 |
| Walt Disney | 13673 |
| Vincent Van Gogh | 13364 |
| Ralph Lauren | 10015 |
| Donald Trump | 9765 |
| Martha Stewart | 9198 |
| Brad Pitt | 8626 |
| Miguel | 8188 |
| Seal | 8119 |
| Paul Walker | 7840 |
| Shakespeare | 7621 |
| Drake | 7290 |
| George Michael | 7270 |
| Elvis Presley | 7212 |
| Justin Bieber | 7050 |
| Justin Timberlake | 6741 |
| 50 Cent | 6028 |
| Frank Sinatra | 5914 |
| Michelangelo | 5465 |
| Johnny Depp | 5379 |
| Michael Jackson | 5349 |
| George Clooney | 5239 |
| Bruno Mars | 4875 |
| Jamie Oliver | 4796 |
| Sting | 4561 |
| Leonardo DiCaprio | 4546 |
| Ryan Gosling | 4399 |
| St. Vincent | 4368 |
| Queen Elizabeth II | 4278 |
| Eminem | 4153 |
| Coldplay | 4130 |
| Vin Diesel | 3902 |
| Jimmy Fallon | 3888 |
| Elton John | 3826 |
| Usher | 3584 |
| David Beckham | 3582 |
| Sylvester Stallone | 3517 |
| Pitbull | 3492 |
| R. Kelly | 3443 |
| Colin Firth | 3441 |
| Jason Statham | 3420 |
| Liam Hemsworth | 3319 |
| Tom Hanks | 3316 |
| Ryan Reynolds | 3312 |
| Jennifer Lopez | 3264 |
| Taylor Swift | 3206 |
| Emily Blunt | 3197 |
| Kanye West | 3166 |
| Bruce Springsteen | 3157 |
| Dr. Seuss | 3152 |
| Babe Ruth | 3145 |
| Olly Murs | 3141 |
| Marilyn Monroe | 3135 |
| Beyoncé | 3092 |
| Alex Rodriguez | 3039 |
| Judy Garland | 3037 |
| Green Day | 3023 |
| Bruce Willis | 2981 |
| Prince William | 2979 |
| Keanu Reeves | 2900 |
| Adele | 2844 |
| Chris Evans | 2826 |
| Russell Crowe | 2794 |
| Cate Blanchett | 2793 |
| Backstreet Boys | 2776 |
| Mark Wahlberg | 2754 |
| Tom Hardy | 2733 |
| Hugh Jackman | 2689 |
| JoJo | 2682 |
| George Washington | 2660 |
| Cary Grant | 2650 |
| Jude Law | 2648 |
| Cher | 2642 |
| Miley Cyrus | 2636 |
| Kate Middleton | 2619 |
| Shawn Mendes | 2617 |
| Keira Knightley | 2613 |
| Princess Diana | 2594 |
| Abraham Lincoln | 2571 |
| Aaron Paul | 2545 |
| Prince Harry | 2514 |
| Bob Ross | 2502 |
| Kate Moss | 2497 |
| Will Smith | 2496 |
| Chris Hemsworth | 2491 |
| Meryl Streep | 2443 |
| Blake Lively | 2433 |
| Banksy | 2397 |
| Channing Tatum | 2389 |
| Dwayne Johnson | 2370 |
| Kenny Chesney | 2296 |
| Clint Eastwood | 2289 |
| Britney Spears | 2281 |
| Leonardo da Vinci | 2256 |
| Macklemore | 2239 |
| Ricky Martin | 2227 |
| Idris Elba | 2223 |
| Adam Levine | 2186 |
| Nick Jonas | 2185 |
| Khalid | 2183 |
| Helen Mirren | 2181 |
| Ewan McGregor | 2174 |
| Barack Obama | 2167 |
| Charlie Hunnam | 2134 |
| Meghan Markle | 2134 |
| Daniel Craig | 2129 |
| Matt Damon | 2126 |
| Tim Tebow | 2126 |
| Mike Tyson | 2117 |
| Maroon 5 | 2108 |
| Cillian Murphy | 2104 |
| Tom Ford | 2094 |
| Brie Larson | 2070 |
| DJ Khaled | 2066 |
| Ben Affleck | 2055 |
| Joe Biden | 2053 |
| Angelina Jolie | 2032 |
| The Beatles | 2028 |
| Paul Hollywood | 1996 |
| Pablo Picasso | 1980 |
| Adam Sandler | 1969 |
| John Travolta | 1955 |
| Garth Brooks | 1922 |
| Marc Jacobs | 1914 |
| Armie Hammer | 1894 |
| Chris Pratt | 1882 |
| Katy Perry | 1875 |
| Michael B. Jordan | 1875 |
| Chuck Berry | 1872 |
| Michael Bublé | 1860 |
| Tory Burch | 1854 |
| Lady Gaga | 1841 |
| Julie Andrews | 1840 |
| Logic | 1833 |
| Jennifer Lawrence | 1831 |
| Prince George | 1817 |
| Diddy | 1809 |
| Patrick Dempsey | 1792 |
| Kevin Hart | 1785 |
| James Dean | 1765 |
| Zac Efron | 1764 |
| Kim Kardashian | 1754 |
| Samuel L. Jackson | 1752 |
| Carey Mulligan | 1748 |
| Tom Brady | 1733 |
| Jamie Foxx | 1726 |
| Maggie Smith | 1724 |
| Tom Clancy | 1722 |
| David Bowie | 1718 |
| Justin Theroux | 1712 |
| Jackie Robinson | 1708 |
| Jay Leno | 1697 |
| Anthony Joshua | 1695 |
| Jay-Z | 1689 |
| Henry Ford | 1677 |
| Nas | 1670 |
| Grimes | 1664 |
| Jared Leto | 1664 |
| Chadwick Boseman | 1657 |
| Ice Cube | 1654 |
| Cory Monteith | 1649 |
| Chris Brown | 1638 |
| The Weeknd | 1632 |
| Floyd Mayweather | 1617 |
| Princess Margaret | 1602 |
| Eric Clapton | 1596 |
| Harry Styles | 1596 |
| Aretha Franklin | 1595 |
| T.I. | 1579 |
| Hillary Clinton | 1575 |
| Robert Redford | 1575 |
| Kevin Costner | 1574 |
| Saoirse Ronan | 1535 |
| Denzel Washington | 1525 |
| Nicolas Cage | 1520 |
| Paul McCartney | 1501 |
| Quentin Tarantino | 1493 |
| Harrison Ford | 1467 |
| Lily James | 1467 |
| Cardi B | 1466 |
| Elizabeth Taylor | 1451 |
| Mark Ruffalo | 1446 |
| U2 | 1438 |
| Tom Cruise | 1437 |
| One Direction | 1435 |
| Bradley Cooper | 1433 |
| Matt Smith | 1425 |
| Michelle Dockery | 1414 |
| Rihanna | 1405 |
| Matthew McConaughey | 1404 |
| Nelly | 1401 |
| Metallica | 1384 |
| Steven Spielberg | 1374 |
| Gwyneth Paltrow | 1363 |
| will.i.am | 1360 |
| Robert Downey Jr. | 1353 |
| Luke Bryan | 1347 |
| Keith Urban | 1345 |
| Luke Combs | 1343 |
| EXO | 1320 |
| Mark Hamill | 1319 |
| Kate Winslet | 1312 |
| John Legend | 1311 |
| Ellen DeGeneres | 1304 |
| Naomi Campbell | 1300 |
| Vince Vaughn | 1296 |
| Meat Loaf | 1293 |
| Mahershala Ali | 1281 |
| Sam Smith | 1280 |
| Andy Warhol | 1279 |
| Robin Thicke | 1277 |
| Robert De Niro | 1266 |
| Priyanka Chopra | 1264 |
| Linkin Park | 1260 |
| Bob Marley | 1251 |
| Liam Neeson | 1249 |
| Jon Hamm | 1246 |
| Billy Joel | 1241 |
| Nicole Kidman | 1239 |
| Brantley Gilbert | 1235 |
| Snoop Dogg | 1234 |
| Al Pacino | 1230 |
| Paul Rudd | 1227 |
| John Lennon | 1226 |
| Woody Harrelson | 1223 |
| Jai Courtney | 1214 |
| Bono | 1209 |
| Michael Fassbender | 1208 |
| James Corden | 1205 |
| Scarlett Johansson | 1201 |
| Viola Davis | 1200 |
| John Galliano | 1184 |
| Charlize Theron | 1175 |
| Judi Dench | 1168 |
| Hugh Grant | 1166 |
| BTS | 1164 |
| Jennifer Aniston | 1164 |
| Lupita Nyong'o | 1163 |
| Ryan Seacrest | 1148 |
| Daisy Ridley | 1145 |
| Sean Connery | 1145 |
| Michelle Obama | 1143 |
| Tyler the Creator | 1140 |
| John Boyega | 1123 |
| Arnold Schwarzenegger | 1122 |
| The Pope | 1104 |
| Anne Hathaway | 1100 |
| Jonas Brothers | 1078 |
| Heath Ledger | 1075 |
| Chris Martin | 1071 |
| Stephen King | 1070 |
| Penn Badgley | 1069 |
| Mary J. Blige | 1059 |
| Martin Luther King Jr. | 1056 |
| Scott Eastwood | 1055 |
| Seth Rogen | 1051 |
| Cole Sprouse | 1038 |
| Emma Thompson | 1037 |
| Octavia Spencer | 1030 |
| Chace Crawford | 1028 |
| Emma Stone | 1028 |
| Lil Wayne | 1027 |
| Brett Young | 1026 |
| Johnny Cash | 1026 |
| Kid Rock | 1022 |
| Missy Elliott | 1020 |
| Hayley Atwell | 1017 |
| Steve Carell | 1015 |
| Alec Baldwin | 1009 |
| Pippa Middleton | 1000 |
| Pharrell Williams | 985 |
| Olivia Colman | 983 |
| Viggo Mortensen | 982 |
| Taron Egerton | 981 |
| Hilary Duff | 973 |
| Michael Strahan | 972 |
| Bob Dylan | 971 |
| Stella McCartney | 970 |
| Gisele Bündchen | 967 |
| Harriet Tubman | 966 |
| Will Ferrell | 953 |
| Rosa Parks | 952 |
| Jason Derulo | 941 |
| Ciara | 939 |
| Neil Patrick Harris | 939 |
| Ne-Yo | 935 |
| Amelia Earhart | 931 |
| ABBA | 930 |
| 2 Chainz | 928 |
| Eddie Murphy | 928 |
| Russell Brand | 922 |
| T-Pain | 922 |
| Anthony Hopkins | 921 |
| Julia Roberts | 921 |
| Christoph Waltz | 917 |
| Salvador Dali | 915 |
| Gianni Versace | 914 |
| Anthony Mackie | 913 |
| NF | 913 |
| Jonah Hill | 912 |
| Hailey Baldwin | 908 |
| Cee Lo Green | 907 |
| Bill Murray | 905 |
| Justin Hartley | 903 |
| Barbra Streisand | 900 |
| Gerard Butler | 900 |
| Bad Bunny | 894 |
| Michael Jordan | 894 |
| Michelle Williams | 893 |
| Dolly Parton | 883 |
| Oscar Isaac | 882 |
| James Franco | 874 |
| Karl Lagerfeld | 874 |
| Jeff Bridges | 869 |
| Usain Bolt | 867 |
| Kane Brown | 866 |
| Anderson .Paak | 856 |
| Reese Witherspoon | 852 |
| Rob Lowe | 852 |
| Toby Keith | 851 |
| Liev Schreiber | 848 |
| Neil Young | 844 |
| Jessica Biel | 843 |
| NSYNC | 843 |
| Tom Hiddleston | 837 |
| Kevin James | 833 |
| Ed Sheeran | 832 |
| Imagine Dragons | 830 |
| Aaron Lewis | 826 |
| John Wayne | 825 |
| Marc Anthony | 824 |
| Mark Salling | 824 |
| Marie Osmond | 818 |
| Colin Farrell | 813 |
| Kiefer Sutherland | 812 |
| Machine Gun Kelly | 811 |
| Mariah Carey | 811 |
| Amal Clooney | 808 |
| Gary Oldman | 804 |
| Kirsten Dunst | 803 |
| Oprah Winfrey | 798 |
| Robert Pattinson | 797 |
| Naomi Watts | 792 |
| Sam Hunt | 792 |
| Jason Aldean | 788 |
| Sarah Jessica Parker | 788 |
| Mozart | 787 |
| Jessica Chastain | 784 |
| LeBron James | 784 |
| Lil Nas X | 772 |
| Melissa McCarthy | 771 |
| Josh Duhamel | 767 |
| Janelle Monáe | 765 |
| Jesse Owens | 764 |
| UB40 | 759 |
| Joseph Gordon-Levitt | 755 |
| James Spader | 754 |
| Michael Keaton | 752 |
| Chance the Rapper | 750 |
| Dr. Dre | 748 |
| Joel Edgerton | 748 |
| Gordon Ramsay | 741 |
| Jimmy Kimmel | 741 |
| Joanna Gaines | 741 |
| John F. Kennedy | 740 |
| Celine Dion | 729 |
| Jack Black | 729 |
| Neil Armstrong | 723 |
| Josh Brolin | 719 |
| Rick Ross | 719 |
| Bryan Cranston | 718 |
| Tupac | 715 |
| Casey Affleck | 714 |
| Elle Fanning | 709 |
| Stanley Tucci | 709 |
| Benedict Cumberbatch | 707 |
| Forest Whitaker | 704 |
| Billie Eilish | 699 |
| Christian Bale | 694 |
| Michael Douglas | 694 |
| Mel Gibson | 692 |
| Guy Ritchie | 691 |
| Demi Lovato | 689 |
| Martin Scorsese | 688 |
| Sia | 685 |
| Lin-Manuel Miranda | 684 |
| Kevin Spacey | 683 |
| Tobey Maguire | 683 |
| Cynthia Erivo | 679 |
| Helena Bonham Carter | 677 |
| Daniel Day-Lewis | 676 |
| Ben Stiller | 675 |
| Chris Pine | 675 |
| David Letterman | 673 |
| Simon Baker | 671 |
| Liberace | 669 |
| Rascal Flatts | 669 |
| Bernie Sanders | 667 |
| Dean Martin | 666 |
| Deftones | 666 |
| Jake Gyllenhaal | 666 |
| Tiger Woods | 665 |
| Tim McGraw | 664 |
| Corey Taylor | 663 |
| Jeff Goldblum | 663 |
| Adam Driver | 662 |
| Tyler Perry | 662 |
| Tom Holland | 660 |
| Debbie Reynolds | 659 |
| Jessica Simpson | 656 |
| Jane Lynch | 654 |
| Dita Von Teese | 653 |
| Robin Wright | 646 |
| Nicky Jam | 644 |
| Amy Winehouse | 639 |
| Bobby Flay | 638 |
| David Oyelowo | 636 |
| Nick Cannon | 635 |
| Rooney Mara | 634 |
| Lenny Kravitz | 629 |
| Milo Ventimiglia | 629 |
| Lana Del Rey | 627 |
| Chris Rock | 625 |
| Nicki Minaj | 624 |
| Zac Posen | 624 |
| George Lucas | 623 |
| Serena Williams | 623 |
| Woody Allen | 622 |
| Tony Curtis | 620 |
| Wentworth Miller | 620 |
| Theo James | 618 |
| Mark Twain | 616 |
| Terry Crews | 613 |
| John Muir | 608 |
| Taylor Kinney | 608 |
| Tilda Swinton | 608 |
| Marion Cotillard | 604 |
| Amy Adams | 603 |
| Eddie Redmayne | 601 |
| Chris Young | 600 |
| Ralph Fiennes | 599 |
| Kobe Bryant | 595 |
| Drew Barrymore | 594 |
| Mia Wasikowska | 591 |
| Kelly Clarkson | 590 |
| Mac Miller | 590 |
| Natalie Portman | 585 |
| Alicia Keys | 584 |
| Melania Trump | 584 |
| Bella Hadid | 582 |
| Olivia Newton-John | 582 |
| Shakira | 582 |
| Morgan Freeman | 580 |
| Dustin Hoffman | 579 |
| Felicity Jones | 579 |
| AC/DC | 578 |
| Maluma | 577 |
| Ethan Hawke | 576 |
| Seth MacFarlane | 574 |
| Nick Carter | 572 |
| Russell Wilson | 570 |
| Billy Porter | 569 |
| Luke Evans | 567 |
| Alexander Skarsgård | 566 |
| Kurt Russell | 565 |
| Lamar Odom | 563 |
| Lance Armstrong | 563 |
| Oscar Wilde | 562 |
| Christopher Columbus | 560 |
| Daniel Radcliffe | 560 |
| Ian McKellen | 558 |
| Jason Sudeikis | 554 |
| The Rolling Stones | 554 |
| Owen Wilson | 552 |
| Bill Gates | 549 |
| Josh Gad | 549 |
| Renee Zellweger | 549 |
| Jesse Williams | 548 |
| Joel McHale | 547 |
| Josh Hutcherson | 547 |
| Kelly Ripa | 547 |
| Jennifer Hudson | 545 |
| Joe Jonas | 543 |
| Julianne Moore | 543 |
| Lizzo | 543 |
| Shia LaBeouf | 543 |
| Carrie Underwood | 542 |
| Ruby Rose | 542 |
| Rosamund Pike | 538 |
| Kylie Jenner | 535 |
| T-Series | 534 |
| Shaquille O'Neal | 531 |
| Dan Stevens | 530 |
| Sterling K. Brown | 528 |
| Halsey | 527 |
| Peyton Manning | 527 |
| Rachel McAdams | 525 |
| Edward Norton | 523 |
| Philip Seymour Hoffman | 520 |
| TikTok | 516 |
| Lauren Conrad | 514 |
| Rachel Brosnahan | 514 |
| Big Sean | 513 |
| Sam Rockwell | 513 |
| Steven Seagal | 512 |
| Simon Pegg | 511 |
| Sacha Baron Cohen | 508 |
| Willie Nelson | 508 |
| Evangeline Lilly | 506 |
| Margot Robbie | 505 |
| Iman | 502 |
| Kendall Jenner | 501 |
| Nelson Mandela | 501 |
| Karlie Kloss | 495 |
| Meek Mill | 493 |
| David Tennant | 491 |
| J. Cole | 490 |
| Sarah Paulson | 489 |
| Princess Eugenie | 488 |
| Florida Georgia Line | 487 |
| Stan Lee | 487 |
| Zachary Quinto | 487 |
| Aaron Taylor-Johnson | 486 |
| Amanda Seyfried | 486 |
| Kendrick Lamar | 485 |
| Elisabeth Moss | 481 |
| Simon Cowell | 481 |
| Victoria Beckham | 478 |
| Billy Ray Cyrus | 476 |
| Matt LeBlanc | 474 |
| John Cena | 471 |
| Jonathan Groff | 468 |
| Jerry Seinfeld | 466 |
| Will Arnett | 465 |
| Christy Turlington | 464 |
| Alanis Morissette | 461 |
| Gwen Stefani | 459 |
| Kylie Minogue | 459 |
| Emma Watson | 458 |
| Andy Samberg | 457 |
| Cameron Diaz | 457 |
| Henry Cavill | 455 |
| James Marsden | 454 |
| Kacey Musgraves | 454 |
| Logan Paul | 454 |
| Travis Scott | 454 |
| James McAvoy | 452 |
| Brody Jenner | 451 |
| Elon Musk | 450 |
| Jon Favreau | 449 |
| Nicky Hilton | 447 |
| Christopher Walken | 443 |
| Michael Sheen | 442 |
| Norman Reedus | 441 |
| Paul Bettany | 439 |
| Dave Chappelle | 438 |
| Sean Penn | 437 |
| Rosemary Clooney | 436 |
| Lea Michele | 435 |
| Justin Trudeau | 433 |
| Luke Perry | 433 |
| Martin Lawrence | 433 |
| Mario Testino | 432 |
| John Krasinski | 430 |
| Lil Baby | 426 |
| Selena Gomez | 424 |
| Donald Glover | 423 |
| Joe Manganiello | 422 |
| Ryan Phillippe | 421 |
| John Mayer | 420 |
| Alicia Vikander | 419 |
| Ludacris | 415 |
| Pierce Brosnan | 415 |
| Jenna Coleman | 414 |
| Joel Madden | 413 |
| Stephen Colbert | 410 |
| Sam Claflin | 409 |
| Jack Nicholson | 408 |
| Kellan Lutz | 408 |
| Ellen Pompeo | 407 |
| David Furnish | 402 |
| George Harrison | 401 |
| Miranda Kerr | 401 |
| Jason Segel | 400 |
| Taylor Kitsch | 400 |
| Sheryl Crow | 399 |
| William Shatner | 398 |
| Lewis Hamilton | 397 |
| Lily Collins | 397 |
| Thalia | 397 |
| Beethoven | 394 |
| Chris Lane | 392 |
| Jake Paul | 392 |
| Sam Worthington | 391 |
| Tina Fey | 391 |
| Kris Jenner | 390 |
| Nicholas Hoult | 390 |
| Jim Carrey | 389 |
| Pedro Pascal | 389 |
| Ronald Reagan | 389 |
| Solange Knowles | 389 |
| Heidi Klum | 387 |
| Betty White | 386 |
| Eric Dane | 386 |
| Gwendoline Christie | 385 |
| Khloe Kardashian | 385 |
| Christina Aguilera | 384 |
| Jason Momoa | 383 |
| Kit Harington | 383 |
| Richard Madden | 382 |
| Cindy Crawford | 381 |
| Joey Fatone | 381 |
| Bobby Cannavale | 379 |
| Kate Hudson | 379 |
| Marshmello | 379 |
| Aaron Rodgers | 378 |
| Chrissy Teigen | 378 |
| Young Thug | 378 |
| Matt Bomer | 377 |
| Andrew Garfield | 375 |
| Biggie Smalls | 375 |
| Adrien Brody | 374 |
| Andy Cohen | 374 |
| Ice-T | 374 |
| Leslie Odom Jr. | 374 |
| Steve Martin | 373 |
| Ray Liotta | 371 |
| Richard Branson | 371 |
| Tony Robbins | 370 |
| Stevie Wonder | 368 |
| Mick Jagger | 367 |
| Whitney Houston | 366 |
| Andrew Lincoln | 365 |
| Amy Poehler | 364 |
| Domhnall Gleeson | 364 |
| Fergie | 364 |
| Post Malone | 364 |
| Hayden Christensen | 363 |
| John Goodman | 363 |
| Michael J. Fox | 363 |
| Ansel Elgort | 362 |
| Queen Maxima | 362 |
| Gigi Hadid | 360 |
| Arnold Palmer | 358 |
| Ellie Goulding | 358 |
| Scooter Braun | 357 |
| Sebastian Stan | 357 |
| Cory Booker | 356 |
| Daniel Kaluuya | 356 |
| Zachary Levi | 356 |
| Peter Lindbergh | 354 |
| Paris Hilton | 353 |
| Ed Westwick | 352 |
| Seth Meyers | 352 |
| Anna Wintour | 351 |
| Dwayne 'The Rock' Johnson | 350 |
| Annette Bening | 347 |
| G-Eazy | 347 |
| Millie Bobby Brown | 347 |
| Rafael Nadal | 347 |
| Ashton Kutcher | 343 |
| Jennifer Garner | 343 |
| Olivia Wilde | 342 |
| Camila Cabello | 341 |
| Jimi Hendrix | 341 |
| Logan Lerman | 339 |
| Ray Charles | 339 |
| River Phoenix | 339 |
| Sofia Coppola | 339 |
| Steve Jobs | 339 |
| Tony Hawk | 339 |
| Calum Scott | 334 |
| Jojo Siwa | 334 |
| Amber Heard | 332 |
| Greta Gerwig | 330 |
| Ben Foster | 328 |
| Terrence Howard | 328 |
| Julianne Hough | 326 |
| Natalie Dormer | 326 |
| Conor McGregor | 325 |
| Ivan Moody | 325 |
| Johnny Carson | 325 |
| P!nk | 325 |
| Ted Bundy | 324 |
| Blake Shelton | 323 |
| Dwyane Wade | 323 |
| Ernest Hemingway | 323 |
| Taye Diggs | 323 |
| Bill Clinton | 322 |
| Robin Williams | 322 |
| Kristen Bell | 321 |
| Asa Butterfield | 320 |
| Benji Madden | 320 |
| Scott Disick | 320 |
| Paul Giamatti | 319 |
| Aaron Judge | 318 |
| Freddie Mercury | 318 |
| Jacob Tremblay | 318 |
| Mike Patton | 318 |
| Rosalia | 318 |
| Martin Freeman | 315 |
| Aaliyah | 314 |
| Hilary Swank | 314 |
| Hugh Laurie | 314 |
| Kendra Wilkinson | 314 |
| Richard Gere | 312 |
| Javier Bardem | 311 |
| J.J. Abrams | 310 |
| Cristiano Ronaldo | 309 |
| Diane Keaton | 308 |
| Aaron Eckhart | 306 |
| Gorillaz | 306 |
| Clive Owen | 305 |
| Gabriel Macht | 305 |
| Gus Kenworthy | 304 |
| Michelle Pfeiffer | 304 |
| Migos | 304 |
| Rob Gronkowski | 304 |
| Charlie Sheen | 303 |
| Gavin Rossdale | 303 |
| Hailey Bieber | 302 |
| Mike Pence | 302 |
| Jeremy Renner | 301 |
| Liam Payne | 300 |
| Jeff Daniels | 299 |
| Richard Rawlings | 298 |
| Matthew Morrison | 297 |
| Florence Pugh | 296 |
| Ricky Gervais | 296 |
| Paul Dano | 295 |
| Claire Danes | 293 |
| Kristen Stewart | 293 |
| Sophie Turner | 292 |
| John David Washington | 290 |
| Jussie Smollett | 290 |
| Liv Tyler | 289 |
| Bear Grylls | 287 |
| Dev Patel | 285 |
| Jamie Lee Curtis | 285 |
| Panic! at the Disco | 285 |
| Sally Field | 285 |
| Olivia Palermo | 284 |
| Led Zeppelin | 283 |
| Leighton Meester | 283 |
| Fred Rogers | 281 |
| Kate McKinnon | 280 |
| Orlando Bloom | 279 |
| Sandra Bullock | 279 |
| Tobias Menzies | 279 |
| Andrew Cuomo | 278 |
| Avril Lavigne | 274 |
| Matthew Perry | 274 |
| Zooey Deschanel | 274 |
| Mark Consuelos | 273 |
| Pete Davidson | 273 |
| Ariana Grande | 272 |
| Goldie Hawn | 272 |
| Gillian Anderson | 271 |
| Foster the People | 270 |
| Jackie Chan | 270 |
| Harper Lee | 269 |
| Queen Latifah | 269 |
| Zendaya | 269 |
| Sienna Miller | 268 |
| Amber Rose | 266 |
| Howard Hughes | 266 |
| Jodie Foster | 266 |
| Phoebe Waller-Bridge | 266 |
| Sutton Foster | 266 |
| Lily Cole | 265 |
| Timothy Olyphant | 265 |
| Tori Spelling | 265 |
| Matthew Broderick | 264 |
| Michael Pena | 262 |
| Michael Peña | 262 |
| January Jones | 261 |
| Kaley Cuoco | 261 |
| Charlie Chaplin | 260 |
| Jeffrey Dean Morgan | 260 |
| Candice Accola | 259 |
| Niall Horan | 259 |
| Lakeith Stanfield | 258 |
| Rick Astley | 258 |
| Bill Hader | 257 |
| Dane DeHaan | 257 |
| Matthew Rhys | 257 |
| Charlie Day | 254 |
| Nick Offerman | 254 |
| Alice Cooper | 253 |
| Spencer Pratt | 253 |
| Kurt Cobain | 252 |
| Beyoncé Knowles | 251 |
| Cuba Gooding Jr. | 251 |
| Rebel Wilson | 251 |
| Cara Delevingne | 250 |
| Aaron Tveit | 249 |
| Lil Yachty | 249 |
| Patrick Swayze | 249 |
| Katherine Heigl | 248 |
| Rebecca Hall | 248 |
| Sandra Oh | 248 |
| Diane Kruger | 247 |
| Kate Beckinsale | 247 |
| Danny Glover | 246 |
| Patrick Mahomes | 246 |
| Ivanka Trump | 244 |
| Janet Jackson | 244 |
| John Stamos | 244 |
| Twenty One Pilots | 244 |
| Anya Taylor-Joy | 242 |
| Kesha | 241 |
| Martin Kemp | 241 |
| Patrick Stewart | 241 |
| Billy Bob Thornton | 238 |
| Jimmy Buffet | 238 |
| Kate Bosworth | 238 |
| Ryan Lochte | 238 |
| Steve Harvey | 238 |
| British Royal Family | 237 |
| Bruce Lee | 237 |
| Christina Hendricks | 235 |
| Eddie Van Halen | 235 |
| Jessica Lange | 235 |
| Dane Cook | 234 |
| David Cassidy | 234 |
| Joaquin Phoenix | 234 |
| Mario Lopez | 234 |
| Novak Djokovic | 234 |
| Tom Selleck | 234 |
| Albert Einstein | 233 |
| Karen Elson | 232 |
| Kevin Bacon | 232 |
| Dakota Fanning | 231 |
| Andrew Scott | 230 |
| Nicole Richie | 230 |
| Sofia Vergara | 230 |
| Jaden Smith | 228 |
| Timothée Chalamet | 228 |
| Wiz Khalifa | 228 |
| Kevin Federline | 227 |
| Vanessa Kirby | 227 |
| Emilia Clarke | 226 |
| James Cameron | 226 |
| Ben Barnes | 225 |
| Will Poulter | 225 |
| Axl Rose | 224 |
| Jamie Bell | 224 |
| O.J. Simpson | 224 |
| Ashley Graham | 223 |
| Demi Moore | 223 |
| Greta Thunberg | 221 |
| Issa Rae | 220 |
| J. K. Rowling | 220 |
| Lily-Rose Depp | 220 |
| Jeremy Clarkson | 218 |
| Kelsey Grammer | 217 |
| Lili Reinhart | 217 |
| Lindsey Vonn | 217 |
| Rachel Weisz | 217 |
| Michael Bloomberg | 216 |
| Jennifer Connelly | 215 |
| Bam Margera | 214 |
| Diana Ross | 213 |
| Meg Ryan | 213 |
| Scott Foley | 213 |
| Corey Stoll | 212 |
| Drew Carey | 212 |
| Rob Halford | 212 |
| Gary Sinise | 211 |
| Tim Allen | 211 |
| Iggy Azalea | 210 |
| Thomas Edison | 210 |
| Carly Rae Jepsen | 209 |
| Kristen Wiig | 209 |
| Lorde | 209 |
| Chris Farley | 208 |
| Gal Gadot | 208 |
| Linda Evangelista | 208 |
| Laura Linney | 207 |
| Wendy Williams | 207 |
| Matthew Fox | 206 |
| Nick Lachey | 206 |
| Zayn Malik | 206 |
| Kourtney Kardashian | 205 |
| Macaulay Culkin | 205 |
| Maya Angelou | 205 |
| Skylar Astin | 205 |
| Maggie Gyllenhaal | 204 |
| Patrick Demarchelier | 204 |
| Trace Adkins | 204 |
| Garrett Hedlund | 203 |
| Jessica Alba | 202 |
| Zach Galifianakis | 202 |
| Mila Kunis | 200 |
| Milla Jovovich | 200 |
| Ruby Bridges | 200 |
| Calvin Harris | 199 |
| Taylor Hill | 199 |
| The Kardashians | 199 |
| Bruce Jenner | 198 |
| Tina Turner | 198 |
| Léa Seydoux | 196 |
| Winona Ryder | 196 |
| Colin Kaepernick | 195 |
| Hailee Steinfeld | 195 |
| Tracee Ellis Ross | 195 |
| Tory Lanez | 194 |
| Adrian Grenier | 193 |
| Amy Schumer | 193 |
| Jane Fonda | 193 |
| Jason Schwartzman | 193 |
| Laura Dern | 193 |
| Jake Johnson | 192 |
| Jamie Dornan | 192 |
| Brian Austin Green | 191 |
| Rosie O'Donnell | 191 |
| Uma Thurman | 191 |
| Ozzy Osbourne | 190 |
| Danny Devito | 188 |
| Deadmau5 | 188 |
| Halle Berry | 188 |
| Heidi Montag | 187 |
| Joel Kinnaman | 187 |
| Ben McKenzie | 186 |
| Cam Gigandet | 186 |
| Ed Helms | 186 |
| Henry Winkler | 185 |
| Mike Rowe | 185 |
| Miles Teller | 185 |
| Evan Rachel Wood | 184 |
| Lily Allen | 184 |
| Bode Miller | 183 |
| Jesse Eisenberg | 183 |
| Mandy Moore | 183 |
| Chad Michael Murray | 182 |
| Jeff Bezos | 182 |
| Roger Federer | 182 |
| Chloë Grace Moretz | 181 |
| Lionel Messi | 181 |
| Megan Fox | 181 |
| Bill Nye | 180 |
| Diane von Furstenberg | 180 |
| Quvenzhané Wallis | 180 |
| Rosie Huntington-Whiteley | 180 |
| Brad Paisley | 179 |
| Cody Simpson | 179 |
| Colton Haynes | 178 |
| Michael Phelps | 178 |
| Tracy Morgan | 178 |
| John Cusack | 177 |
| Pentatonix | 177 |
| Portia de Rossi | 177 |
| Hrithik Roshan | 176 |
| Malcolm X | 176 |
| Matt Ryan | 176 |
| Molly Sims | 175 |
| Poppy Delevingne | 175 |
| Riz Ahmed | 175 |
| Melanie Martinez | 173 |
| Emile Hirsch | 171 |
| Frank Ocean | 171 |
| Robert Irvine | 171 |
| Alex Pettyfer | 170 |
| Sam Heughan | 170 |
| Katie Holmes | 169 |
| Bob Odenkirk | 168 |
| Hugh Hefner | 168 |
| Taraji P. Henson | 168 |
| Joshua Jackson | 167 |
| Toni Collette | 167 |
| Diane Lane | 166 |
| James Madison | 166 |
| Kate Upton | 166 |
| Lil Dicky | 166 |
| Mark Zuckerberg | 166 |
| SZA | 166 |
| James Garner | 165 |
| Keegan-Michael Key | 165 |
| Sharon Stone | 165 |
| Brooke Shields | 164 |
| Steven Tyler | 164 |
| Hannah Davis | 162 |
| Jimmy Carter | 162 |
| Vincent Kartheiser | 162 |
| Billy Ocean | 161 |
| Jonathan Rhys Meyers | 161 |
| Weird Al' Yankovic | 161 |
| George Ezra | 160 |
| Jack Antonoff | 160 |
| Ryan Guzman | 160 |
| Penelope Cruz | 159 |
| Penélope Cruz | 159 |
| Salma Hayek | 159 |
| Tony Romo | 159 |
| Brendon Urie | 158 |
| Megan Thee Stallion | 158 |
| Elizabeth Warren | 157 |
| Jim Parsons | 157 |
| Marshawn Lynch | 157 |
| Natalia Vodianova | 157 |
| Vanessa Hudgens | 157 |
| Bebe Rexha | 156 |
| Idina Menzel | 156 |
| Regina King | 156 |
| Caitriona Balfe | 155 |
| Lindsey Wixson | 155 |
| Peter Sarsgaard | 155 |
| Richard Nixon | 155 |
| Anna Faris | 154 |
| Bryce Dallas Howard | 154 |
| Christina Applegate | 154 |
| Courtney Love | 154 |
| Mindy Kaling | 153 |
| Wayne Rooney | 153 |
| Chris McCandless | 152 |
| RuPaul | 152 |
| Fifth Harmony | 151 |
| Ray Romano | 151 |
| Anna Kournikova | 150 |
| Jason Bateman | 150 |
| Jodie Turner-Smith | 150 |
| Kamala Harris | 150 |
| Sammy Davis Jr. | 150 |
| Christie Brinkley | 149 |
| Michelle Rodriguez | 149 |
| Nico Tortorella | 149 |
| Joe Rogan | 148 |
| Jamie Campbell Bower | 147 |
| Tessa Thompson | 147 |
| Tiffany Haddish | 147 |
| Will Forte | 146 |
| Kevin Jonas | 145 |
| Dylan O'Brien | 144 |
| Regis Philbin | 144 |
| Maggie Rogers | 143 |
| Whitney Port | 143 |
| Zach Braff | 143 |
| Elizabeth Banks | 142 |
| Eva Green | 142 |
| Florence Welch | 142 |
| George Bush | 142 |
| Neymar | 141 |
| Dennis Quaid | 140 |
| Matt Lanter | 140 |
| Emma Corrin | 139 |
| Harvey Weinstein | 137 |
| Josh Groban | 137 |
| Katie Lee | 137 |
| Bill Paxton | 136 |
| Chloe Sevigny | 136 |
| Isaac Newton | 136 |
| Matt Dillon | 136 |
| Zion Williamson | 136 |
| Helen Hunt | 135 |
| Lil Pump | 135 |
| The Jackson 5 | 135 |
| Catherine Zeta-Jones | 134 |
| David Attenborough | 134 |
| Frederick Douglass | 134 |
| Trey Songz | 134 |
| Alan Rickman | 133 |
| Dua Lipa | 133 |
| Edie Falco | 133 |
| Jack Huston | 133 |
| Dylan Minnette | 132 |
| Jon Stewart | 132 |
| Zoe Saldana | 132 |
| Coco Rocha | 131 |
| Joan Smalls | 131 |
| Patricia Arquette | 131 |
| Elsa Pataky | 130 |
| Luke Wilson | 130 |
| Sarah Silverman | 130 |
| Eva Mendes | 129 |
| The Chainsmokers | 129 |
| Benicio Del Toro | 128 |
| Jack Nicklaus | 128 |
| Maya Rudolph | 128 |
| Rita Ora | 128 |
| Meghan Trainor | 127 |
| Roseanne Barr | 127 |
| Phoebe Bridgers | 126 |
| Rachel Zoe | 126 |
| Anna Paquin | 125 |
| Anthony Rizzo | 125 |
| Dan Bilzerian | 125 |
| Elijah Wood | 125 |
| Howard Stern | 125 |
| Katie Price | 125 |
| Letitia Wright | 125 |
| Matt Lauer | 125 |
| Charlie Daniels | 124 |
| Ginnifer Goodwin | 124 |
| Paul Ryan | 124 |
| Susan Sarandon | 124 |
| Alexis Bledel | 123 |
| Andie MacDowell | 122 |
| Blackpink | 122 |
| Dr. Phil | 122 |
| Kyle Chandler | 122 |
| Adam Scott | 121 |
| Alan Walker | 121 |
| Ezra Miller | 121 |
| Gabriel Aubry | 121 |
| Miranda Lambert | 121 |
| Anna Kendrick | 120 |
| Dakota Johnson | 120 |
| Dale Earnhardt | 120 |
| Dianna Agron | 120 |
| Gabrielle Union | 120 |
| Shailene Woodley | 120 |
| Ross Kemp | 119 |
| Eddie Hall | 118 |
| Alessandra Ambrosio | 117 |
| Dan Levy | 117 |
| Elizabeth Olsen | 117 |
| Rose Byrne | 117 |
| Ben Platt | 116 |
| Emily Mortimer | 116 |
| Finn Wolfhard | 116 |
| Justin Bartha | 116 |
| Mackenzie Foy | 116 |
| Shane West | 116 |
| Chrissy Metz | 115 |
| Clemence Poesy | 115 |
| George Strait | 115 |
| Kevin Durant | 115 |
| Michaela Coel | 115 |
| Antonio Banderas | 114 |
| Christopher Reeve | 114 |
| Mikaela Shiffrin | 114 |
| Adam Rodriguez | 113 |
| Anja Rubik | 113 |
| Doutzen Kroes | 113 |
| James Van Der Beek | 113 |
| Jodie Comer | 113 |
| Molly Ringwald | 113 |
| Shaun White | 113 |
| Taylor Schilling | 113 |
| Courteney Cox | 112 |
| Lizzy Caplan | 111 |
| Lucy Liu | 111 |
| Pat Sajak | 111 |
| Aidy Bryant | 110 |
| Booker T. Washington | 110 |
| Jenny McCarthy | 110 |
| Marvin Sapp | 110 |
| William H. Macy | 110 |
| Faith Hill | 109 |
| Kevin Connolly | 109 |
| Larry David | 109 |
| Rami Malek | 109 |
| Reggie Bush | 109 |
| Ava DuVernay | 108 |
| Rose Leslie | 108 |
| Zak Bagans | 108 |
| Bethany Hamilton | 107 |
| Ian Somerhalder | 107 |
| Stephen Curry | 107 |
| Wilmer Valderrama | 107 |
| Christina Ricci | 106 |
| Dax Shepard | 106 |
| Jada Pinkett Smith | 106 |
| Kerry Washington | 106 |
| Mariska Hargitay | 106 |
| Alexa Chung | 105 |
| Allison Janney | 105 |
| Behati Prinsloo | 105 |
| James Charles | 105 |
| Julia Stiles | 105 |
| Katharine McPhee | 105 |
| Shania Twain | 105 |
| Lena Dunham | 104 |
| Lewis Capaldi | 104 |
| Stephen Moyer | 104 |
| Uzo Aduba | 104 |
| Charlie Puth | 103 |
| Abigail Breslin | 102 |
| Conan O'Brien | 102 |
| David Schwimmer | 102 |
| Eva Longoria | 102 |
| Al Gore | 101 |
| Dennis Rodman | 101 |
| Pamela Anderson | 101 |
| PewDiePie | 101 |
| Britt Robertson | 100 |
| David Harbour | 100 |
| Emma Roberts | 100 |
| Tyra Banks | 100 |
| Wayne Gretzky | 100 |
| Chord Overstreet | 99 |
| Donna Karan | 99 |
| Jeffrey Tambor | 99 |
| Laura Prepon | 99 |
| Diego Luna | 98 |
| Eazy-E | 98 |
| Ashlee Simpson | 97 |
| Awkwafina | 97 |
| Emily VanCamp | 97 |
| Jenna Dewan | 97 |
| Agyness Deyn | 96 |
| Alison Brie | 95 |
| Anna Camp | 95 |
| Josh Hartnett | 95 |
| Kaia Gerber | 95 |
| Lindsay Lohan | 95 |
| S Club 7 | 95 |
| Cuco | 94 |
| David Arquette | 94 |
| Donatella Versace | 92 |
| Joey King | 92 |
| Jordan Belfort | 92 |
| Tom Ellis | 92 |
| Camilla Parker Bowles | 91 |
| Catherine O'Hara | 91 |
| Chelsea Handler | 91 |
| Mark Cuban | 91 |
| Mark-Paul Gosselaar | 91 |
| Rege-Jean Page | 91 |
| Zoe Kazan | 91 |
| Constance Wu | 90 |
| Helen Keller | 90 |
| June Carter | 90 |
| Lisa Kudrow | 90 |
| N.W.A | 90 |
| Venus Williams | 90 |
| Bar Refaeli | 89 |
| Blackbear | 89 |
| Jared Followill | 89 |
| KJ Apa | 89 |
| Taylor Lautner | 89 |
| Ana de Armas | 88 |
| Freddie Prinze Jr. | 88 |
| Haikyuu | 88 |
| Hunter Parrish | 88 |
| Jessica Stam | 88 |
| Lil Peep | 88 |
| Lyndon B. Johnson | 88 |
| Naya Rivera | 88 |
| Peter Dinklage | 88 |
| Phoebe Dynevor | 88 |
| Evan Peters | 87 |
| Jonathan Van Ness | 87 |
| Cheryl Cole | 86 |
| Danny Koker | 86 |
| Freddie Highmore | 86 |
| Kiernan Shipka | 86 |
| Paul Feig | 86 |
| Pete Wentz | 86 |
| Steven Yeun | 86 |
| Joss Whedon | 85 |
| Lara Stone | 85 |
| Michiel Huisman | 85 |
| Queen Letizia | 85 |
| Brooklyn Beckham | 84 |
| Dave Franco | 84 |
| Erin Wasson | 84 |
| Lily Tomlin | 84 |
| Mike Epps | 84 |
| Toni Garrn | 84 |
| Anna Gunn | 83 |
| Peter Thiel | 83 |
| Samira Wiley | 83 |
| 21 Savage | 82 |
| Alexander Hamilton | 82 |
| Julia Louis-Dreyfus | 82 |
| Amanda Gorman | 81 |
| Irina Shayk | 81 |
| Isla Fisher | 81 |
| Kevin Gates | 81 |
| Rodrigo Santoro | 81 |
| Pablo Neruda | 80 |
| Alyssa Milano | 79 |
| Candice Swanepoel | 79 |
| David Burtka | 79 |
| Frank Sheeran | 79 |
| Heather Morris | 79 |
| Josh Peck | 79 |
| Judd Apatow | 79 |
| Mel B | 79 |
| Ralph Macchio | 79 |
| Sammy Sosa | 79 |
| Eric Bana | 78 |
| Jungkook | 78 |
| Larry Bird | 78 |
| Little Mix | 78 |
| Rob Riggle | 78 |
| Valentino Garavani | 78 |
| Warren G | 78 |
| XXXTentacion | 78 |
| Charlie Cox | 77 |
| Emmy Rossum | 77 |
| John Corbett | 77 |
| Karolina Kurkova | 77 |
| Minnie Driver | 77 |
| Dana White | 76 |
| Jensen Ackles | 76 |
| Jesse Tyler Ferguson | 76 |
| Juice WRLD | 76 |
| Keri Russell | 76 |
| Lena Headey | 76 |
| Louis Tomlinson | 76 |
| Luke Hemsworth | 76 |
| Tom Sturridge | 76 |
| Adam Brody | 75 |
| Chris D'Elia | 75 |
| Rob Kardashian | 75 |
| Robert Kraft | 75 |
| Jhené Aiko | 74 |
| Kevin McHale | 74 |
| Selma Blair | 74 |
| Gavin Newsom | 73 |
| Liu Yifei | 73 |
| Naomie Harris | 73 |
| Peter Falk | 73 |
| Michael Cera | 72 |
| Phil Mickelson | 72 |
| Haylie Duff | 71 |
| Joyner Lucas | 71 |
| Lee Pace | 71 |
| Upchurch | 70 |
| Jordana Brewster | 69 |
| Rosario Dawson | 69 |
| Ashley Tisdale | 68 |
| Camila Alves | 68 |
| Derek Blasberg | 68 |
| Dylan Sprouse | 68 |
| Jim Sturgess | 68 |
| Jourdan Dunn | 68 |
| Lily Donaldson | 68 |
| Tiffani Thiessen | 68 |
| Bernie Mac | 67 |
| Hayden Panettiere | 67 |
| Kristin Chenoweth | 67 |
| Michael Buffer | 67 |
| Nancy Pelosi | 67 |
| Randy Jackson | 67 |
| Allen Iverson | 66 |
| ASAP Rocky | 66 |
| Becky G | 66 |
| Jane Krakowski | 66 |
| Malin Akerman | 66 |
| Peter Firth | 66 |
| Allison Williams | 65 |
| Ashley Judd | 65 |
| Bill Skarsgård | 65 |
| Colin Hanks | 65 |
| Nicola Peltz | 65 |
| Reggie Jackson | 65 |
| Steve Irwin | 65 |
| Anton Yelchin | 64 |
| Iskra Lawrence | 64 |
| Jackson Rathbone | 64 |
| Jared Padalecki | 64 |
| Katherine Johnson | 64 |
| Sasha Pivovarova | 64 |
| Stella Tennant | 64 |
| Zara Larsson | 64 |
| Eiza González | 63 |
| Johnny Galecki | 63 |
| Josh Dallas | 63 |
| Matthew Lewis | 63 |
| Rita Wilson | 63 |
| The Kennedy Family | 63 |
| Yung Gravy | 63 |
| Zedd | 63 |
| Barry Weiss | 62 |
| Evan Ross | 62 |
| Holland Taylor | 62 |
| Hugh Dancy | 62 |
| Leslie Mann | 62 |
| Lily Rabe | 62 |
| Linda Cardellini | 62 |
| Lori Loughlin | 62 |
| Magic Johnson | 62 |
| Zoë Kravitz | 62 |
| Alek Wek | 61 |
| Dove Cameron | 61 |
| Jackson Pollock | 61 |
| Melissa Joan Hart | 61 |
| Tabitha Simmons | 61 |
| Busy Philipps | 60 |
| Jay Baruchel | 60 |
| Kate Walsh | 60 |
| Marsai Martin | 60 |
| Omar Epps | 60 |
| Steph Curry | 60 |
| Tori Kelly | 60 |
| Wayne Brady | 60 |
| Betsy DeVos | 59 |
| Erin O'Connor | 59 |
| Giovanna Battaglia | 59 |
| Jamie Lynn Spears | 59 |
| Laverne Cox | 59 |
| Noah Centineo | 59 |
| Ben Carson | 58 |
| Bethenny Frankel | 58 |
| Chris Klein | 58 |
| Haile Selassie | 58 |
| Kristin Cavallari | 58 |
| Laetitia Casta | 58 |
| Danny Thomas | 57 |
| Ellie Kemper | 57 |
| Kyle Busch | 57 |
| Pete Buttigieg | 57 |
| Brittany Murphy | 56 |
| Jeffree Star | 56 |
| Jenna Fischer | 56 |
| Scott Speedman | 56 |
| Scottie Pippen | 56 |
| Daria Strokous | 55 |
| Rupert Grint | 55 |
| Tinashe | 55 |
| Ashley Olsen | 54 |
| Cash Warren | 54 |
| Davina McCall | 54 |
| Isaiah Washington | 54 |
| Michelle Monaghan | 54 |
| Tim Gunn | 54 |
| Caitlyn Jenner | 53 |
| Candace Cameron Bure | 53 |
| Deana Carter | 53 |
| Shawn Johnson | 53 |
| Taissa Farmiga | 53 |
| Amy Klobuchar | 52 |
| Darren Criss | 52 |
| Kyle Richards | 52 |
| Lauren Graham | 52 |
| Chanel Iman | 51 |
| Emily Ratajkowski | 51 |
| Gillian Jacobs | 51 |
| Kellie Pickler | 51 |
| Lauren Daigle | 51 |
| Teresa Palmer | 51 |
| Anderson Cooper | 50 |
| Grace VanderWaal | 50 |
| Kodak Black | 50 |
| Stephanie Seymour | 50 |
| Trevor Jackson | 50 |
| Lucy Hale | 49 |
| Stephen Amell | 49 |
| Taylor Momsen | 49 |
| Ted Turner | 49 |
| The Founding Fathers | 49 |
| Elizabeth Hurley | 48 |
| Leah Remini | 48 |
| Lisa Vanderpump | 48 |
| Mamie Gummer | 48 |
| Adam DeVine | 47 |
| Fka Twigs | 47 |
| Katherine Jenkins | 47 |
| Paris Jackson | 47 |
| Vanna White | 47 |
| Ian Poulter | 46 |
| Jodie Sweetin | 46 |
| Kathryn Hahn | 46 |
| Marisa Tomei | 46 |
| Sofia Hellqvist | 46 |
| Yara Shahidi | 46 |
| Mayim Bialik | 45 |
| Nina Dobrev | 45 |
| Aubrey Plaza | 44 |
| Bindi Irwin | 44 |
| Destiny's Child | 44 |
| Dree Hemingway | 44 |
| Jerry O'Connell | 44 |
| Jessica Seinfeld | 44 |
| Kim Cattrall | 44 |
| Doja Cat | 43 |
| Justice Smith | 43 |
| Lily Aldridge | 43 |
| Presley Gerber | 43 |
| Rachel Roy | 43 |
| Tamron Hall | 43 |
| Jaime King | 42 |
| Jennifer Love Hewitt | 42 |
| K. Michelle | 42 |
| Mary-Kate Olsen | 42 |
| Russell Westbrook | 42 |
| Suki Waterhouse | 42 |
| Tom Felton | 42 |
| Willow Smith | 42 |
| Alyson Hannigan | 41 |
| Amber Valletta | 41 |
| Aziz Ansari | 41 |
| Lil Uzi Vert | 41 |
| Martha Hunt | 41 |
| Matt McGorry | 41 |
| Padma Lakshmi | 41 |
| Seth Green | 41 |
| Sophia Lillis | 41 |
| Angela Lindvall | 40 |
| Billie Lourd | 40 |
| Jordan Fisher | 40 |
| Mat Fraser | 40 |
| Nat Wolff | 40 |
| Natasha Poly | 40 |
| Nicola Coughlan | 40 |
| Nikola Tesla | 40 |
| Rebecca Romijn | 40 |
| Roddy Ricch | 40 |
| Stephen 'Twitch' Boss | 40 |
| Stephen tWitch Boss | 40 |
| Vanessa Minnillo | 40 |
| Elisha Cuthbert | 39 |
| Elizabeth Reaser | 39 |
| Judy Greer | 39 |
| Kevin O'Leary | 39 |
| Margherita Missoni | 39 |
| Maria Bello | 39 |
| Morena Baccarin | 39 |
| Naomi Scott | 39 |
| Ross Lynch | 39 |
| Soulja Boy | 39 |
| Vanessa Paradis | 39 |
| Aaron Hernandez | 38 |
| Amandla Stenberg | 38 |
| Ana Beatriz Barros | 38 |
| Bella Thorne | 38 |
| Beto O'Rourke | 38 |
| Chuck Schumer | 38 |
| Diego Boneta | 38 |
| John Candy | 38 |
| Kim Sears | 38 |
| Lana Condor | 38 |
| Maisie Williams | 38 |
| Abbey Lee Kershaw | 37 |
| Adriana Lima | 37 |
| Alfonso Ribeiro | 37 |
| AnnaSophia Robb | 37 |
| Audrina Patridge | 37 |
| Heather Locklear | 37 |
| Helena Christensen | 37 |
| Katherine Schwarzenegger | 37 |
| Sabrina Carpenter | 37 |
| Sam Taylor Johnson | 37 |
| Sarah Michelle Gellar | 37 |
| Hanne Gaby Odiele | 36 |
| Mark Richt | 36 |
| Paul Wesley | 36 |
| Ashley McBryde | 35 |
| Emily DiDonato | 35 |
| Gina Rodriguez | 35 |
| James Harden | 35 |
| Jenny Slate | 35 |
| Katherine Langford | 35 |
| Keke Palmer | 35 |
| Kelly Osbourne | 35 |
| Megan Mullally | 35 |
| Rickie Fowler | 35 |
| Yungblud | 35 |
| Ali Larter | 34 |
| Blueface | 34 |
| Elle Macpherson | 34 |
| Felicity Huffman | 34 |
| Hunter Hayes | 34 |
| Kaya Scodelario | 34 |
| Nathan Fillion | 34 |
| Oliver Hudson | 34 |
| Olivia Munn | 34 |
| Perrie Edwards | 34 |
| Ayesha Curry | 33 |
| Casper Smart | 33 |
| Constance Jablonski | 33 |
| Danielle Jonas | 33 |
| Jennifer Morrison | 33 |
| Liu Wen | 33 |
| Magdalena Frackowiak | 33 |
| Maria Menounos | 33 |
| Tyler Hoechlin | 33 |
| Barbara Palvin | 32 |
| Chip Gaines | 32 |
| Fetty Wap | 32 |
| Kat Dennings | 32 |
| Sara Evans | 32 |
| Sofia Richie | 32 |
| Alfie Allen | 31 |
| America Ferrera | 31 |
| Calvin Johnson | 31 |
| Debra Messing | 31 |
| Denise Richards | 31 |
| Erin Foster | 31 |
| Jacquetta Wheeler | 31 |
| Krysten Ritter | 31 |
| Lisa Bonet | 31 |
| Madison Beer | 31 |
| Peter Hermann | 31 |
| Rae Sremmurd | 31 |
| Carl Edwards | 30 |
| Grant Gustin | 30 |
| Katie Ledecky | 30 |
| Minka Kelly | 30 |
| Shay Mitchell | 30 |
| Tai Lopez | 30 |
| Arizona Muse | 29 |
| Austin Butler | 29 |
| Beanie Feldstein | 29 |
| Isabeli Fontana | 29 |
| Jim Nabors | 29 |
| Kawhi Leonard | 29 |
| Liya Kebede | 29 |
| Rumer Willis | 29 |
| Summer Walker | 29 |
| Troye Sivan | 29 |
| David Duchovny | 28 |
| Gabourey Sidibe | 28 |
| Mary Elizabeth Winstead | 28 |
| Rock Lee | 28 |
| Tammy Hembrow | 28 |
| Ziyi Zhang | 28 |
| Brooklyn Decker | 27 |
| Cobie Smulders | 27 |
| Fei Fei Sun | 27 |
| Joe Alwyn | 27 |
| Mischa Barton | 27 |
| Naomi Osaka | 27 |
| Nikolaj Coster-Waldau | 27 |
| Rashida Jones | 27 |
| Troian Bellisario | 27 |
| Victor Garber | 27 |
| Danica Patrick | 26 |
| Joel Embiid | 26 |
| Justin Long | 26 |
| Kendra Spears | 26 |
| Lo Bosworth | 26 |
| Lori Harvey | 26 |
| Natasha Lyonne | 26 |
| Paz de la Huerta | 26 |
| Teri Hatcher | 26 |
| Wayne Carini | 26 |
| Amber Tamblyn | 25 |
| Camilla Luddington | 25 |
| Casey Neistat | 25 |
| Don Lemon | 25 |
| Eva Herzigova | 25 |
| Jacquelyn Jablonski | 25 |
| Lauren Bushnell | 25 |
| Matthew Garber | 25 |
| Melinda Gates | 25 |
| Parker Posey | 25 |
| Tatiana Maslany | 25 |
| Cheryl Ladd | 24 |
| Forrest Fenn | 24 |
| Georgina Chapman | 24 |
| Jay Gould | 24 |
| Riley Keough | 24 |
| Sam Darnold | 24 |
| Alia Shawkat | 23 |
| Ashley Benson | 23 |
| Bryson DeChambeau | 23 |
| Cacee Cobb | 23 |
| Camila Mendes | 23 |
| Chris Watts | 23 |
| David Boreanaz | 23 |
| Deborah Ann Woll | 23 |
| Kieran Culkin | 23 |
| Kyra Sedgwick | 23 |
| Lucy Boynton | 23 |
| Marcia Cross | 23 |
| Neve Campbell | 23 |
| Teyana Taylor | 23 |
| Zoey Deutch | 23 |
| Andrew Yang | 22 |
| Colin O'Donoghue | 22 |
| Connie Britton | 22 |
| Julia Stegner | 22 |
| Julie Bowen | 22 |
| Rachel Bilson | 22 |
| Rebecca Gayheart | 22 |
| Sara Foster | 22 |
| Warren Buffet | 22 |
| Bill Maher | 21 |
| Dave Ramsey | 21 |
| DJ Kool Herc | 21 |
| Harry Shum Jr. | 21 |
| Jamie Chung | 21 |
| Jill Wagner | 21 |
| Maggie Rizer | 21 |
| Rachel Antonoff | 21 |
| Randy Orton | 21 |
| Steve Bannon | 21 |
| Victoria Justice | 21 |
| Annie Murphy | 20 |
| Brady Quinn | 20 |
| Maddie Ziegler | 20 |
| Naira Marley | 20 |
| Charles Melton | 19 |
| Christina Perri | 19 |
| Devon Sawa | 19 |
| Erin Heatherton | 19 |
| Finneas | 19 |
| Hilary Rhoda | 19 |
| Katie Cassidy | 19 |
| Malgosia Bela | 19 |
| Matt Stonie | 19 |
| Rowan Blanchard | 19 |
| Sarah Chalke | 19 |
| Tara Reid | 19 |
| Belle Delphine | 18 |
| Cameron Boyce | 18 |
| Connor Cruise | 18 |
| Kyla Weber | 18 |
| N-Dubz | 18 |
| Nathalie Emmanuel | 18 |
| Patricia Field | 18 |
| Steve Ballmer | 18 |
| Amanda Bynes | 17 |
| Bonnie Wright | 17 |
| Brittany Snow | 17 |
| Courtney Cox | 17 |
| Emilie de Ravin | 17 |
| Kate Mara | 17 |
| Madelaine Petsch | 17 |
| Marcus Lemonis | 17 |
| Mark Harmon | 17 |
| Michelle Trachtenberg | 17 |
| Sandra Cisneros | 17 |
| Saweetie | 17 |
| Sofia Carson | 17 |
| Alexandria Ocasio-Cortez | 16 |
| Ashley Greene | 16 |
| Diane Ladd | 16 |
| Jay Ellis | 16 |
| John Cho | 16 |
| Luke Kuechly | 16 |
| Matthew Bomer | 16 |
| Olivia Culpo | 16 |
| Sam Querrey | 16 |
| Amanda Peet | 15 |
| Anna Cleveland | 15 |
| Arthur Blank | 15 |
| Charles Leclerc | 15 |
| Len Wiseman | 15 |
| Luka Sabbat | 15 |
| Manny Khoshbin | 15 |
| Martin Starr | 15 |
| Topher Grace | 15 |
| Una Stubbs | 15 |
| Vanessa Bryant | 15 |
| Ariel Winter | 14 |
| Bubba Wallace | 14 |
| Calista Flockhart | 14 |
| Crystal Renn | 14 |
| Ethan Suplee | 14 |
| Gregg Sulkin | 14 |
| Hailey Clauson | 14 |
| Hunter McGrady | 14 |
| J. B. Pritzker | 14 |
| Lake Bell | 14 |
| Mae Whitman | 14 |
| Rachel Lindsay | 14 |
| Ramona Singer | 14 |
| Simone Biles | 14 |
| Troy Polamalu | 14 |
| Tucker Carlson | 14 |
| Ava Max | 13 |
| Gary Vaynerchuk | 13 |
| Jayme Closs | 13 |
| Kaitlyn Dever | 13 |
| La La Anthony | 13 |
| Martina McBride | 13 |
| Nikki Reed | 13 |
| Rhea Perlman | 13 |
| Valtteri Bottas | 13 |
| Chase Stokes | 12 |
| Emma Barton | 12 |
| Emma Chamberlain | 12 |
| Evanna Lynch | 12 |
| Jamie Bochert | 12 |
| Jeremy Lin | 12 |
| Keemstar | 12 |
| Mary Fitzgerald | 12 |
| Steve Lacy | 12 |
| Yael Cohen | 12 |
| Aly Raisman | 11 |
| Austin Abrams | 11 |
| Carmen Electra | 11 |
| Christine Quinn | 11 |
| Daisy Fuentes | 11 |
| David Muir | 11 |
| Debby Ryan | 11 |
| Rachelle Lefevre | 11 |
| Tyler Posey | 11 |
| Allison Holker | 10 |
| Ava Phillippe | 10 |
| Camilla Belle | 10 |
| Eddie McGuire | 10 |
| Jason Ritter | 10 |
| Jessica Lowndes | 10 |
| Joel Osteen | 10 |
| Madelyn Cline | 10 |
| Phoebe Tonkin | 10 |
| Thomas Doherty | 10 |
| Tommy Dorfman | 10 |
| Anwar Hadid | 9 |
| DanTDM | 9 |
| Elisa Sednaoui | 9 |
| Jenna Lyons | 9 |
| Jennette McCurdy | 9 |
| Jim Walton | 9 |
| Joseph Haydn | 9 |
| Kim Zolciak-Biermann | 9 |
| Lamar Jackson | 9 |
| Lana Parrilla | 9 |
| Lauren London | 9 |
| Rachel Maddow | 9 |
| Sam Elliot | 9 |
| Stephanie Pratt | 9 |
| Tao Okamoto | 9 |
| Todd Chrisley | 9 |
| Aly Michalka | 8 |
| Bellamy Young | 8 |
| Ben Shapiro | 8 |
| Christiano Ronaldo | 8 |
| Condoleezza Rice | 8 |
| Cornel West | 8 |
| Dan Crenshaw | 8 |
| David Dobrik | 8 |
| Isabel Toledo | 8 |
| Izabel Goulart | 8 |
| Jacob Elordi | 8 |
| Justina Machado | 8 |
| Mariacarla Boscono | 8 |
| Olivia Rodrigo | 8 |
| Sophia Bush | 8 |
| Tommy Wiseau | 8 |
| Zosia Mamet | 8 |
| Alyson Stoner | 7 |
| Brandi Glanville | 7 |
| Elliot Page | 7 |
| Gabby Douglas | 7 |
| Hero Fiennes-Tiffin | 7 |
| Jerry Jones | 7 |
| Jessica Szohr | 7 |
| Ken Jennings | 7 |
| Lauren Bush Lauren | 7 |
| LaVar Ball | 7 |
| LazarBeam | 7 |
| Lindsay Price | 7 |
| Lindsay Wagner | 7 |
| Lydia Hearst | 7 |
| Marisa Miller | 7 |
| Miles Heizer | 7 |
| Miranda Cosgrove | 7 |
| Paul Mescal | 7 |
| Tina Knowles-Lawson | 7 |
| Addison Rae | 6 |
| Angie Harmon | 6 |
| Ashleigh Murray | 6 |
| Bregje Heinen | 6 |
| Ellen Barkin | 6 |
| Indya Moore | 6 |
| Janel Parrish | 6 |
| Kat Graham | 6 |
| Liberty Ross | 6 |
| Nikki Haley | 6 |
| Sarah Hyland | 6 |
| Sasha Pieterse | 6 |
| Tony Lopez | 6 |
| Wilt Chamberlain | 6 |
| Diane Guerrero | 5 |
| Jacob Sartorius | 5 |
| Joanna Hillman | 5 |
| M.C. Hammer | 5 |
| Nick Bolton | 5 |
| Normani Kordei | 5 |
| Andrew East | 4 |
| Barbie Ferreira | 4 |
| Daisy Edgar-Jones | 4 |
| Frankie Grande | 4 |
| Grant Achatz | 4 |
| Hunter Schafer | 4 |
| Jenna Marbles | 4 |
| Jenna Ortega | 4 |
| John Wayne Gacy | 4 |
| Kate Chastain | 4 |
| Kyle Cooke | 4 |
| Lacey Evans | 4 |
| Maitreyi Ramakrishnan | 4 |
| Simu Liu | 4 |
| Storm Reid | 4 |
| Sydney Sweeney | 4 |
| The ACE Family | 4 |
| The Koch Brothers | 4 |
| Will Reeve | 4 |
| AJ Michalka | 3 |
| Carla Bruni Sarkozy | 3 |
| Cole LaBrant | 3 |
| Douglas Brinkley | 3 |
| Genesis Rodriguez | 3 |
| Hannah Bronfman | 3 |
| Jamal Murray | 3 |
| Josie Maran | 3 |
| Max Verstappen | 3 |
| Rudy Gobert | 3 |
| Skai Jackson | 3 |
| Zdeno Chara | 3 |
| AnnaLynne McCord | 2 |
| Annie LeBlanc | 2 |
| Bob Corker | 2 |
| Bob Keeshan | 2 |
| Bob Morley | 2 |
| Dan Lok | 2 |
| David Brinkley | 2 |
| Grant Cardone | 2 |
| Irwin Winkler | 2 |
| Julia Fox | 2 |
| Julie Chrisley | 2 |
| Lindsay Ellingson | 2 |
| Madison Bailey | 2 |
| Miles O'Brien | 2 |
| Mossimo Giannulli | 2 |
| MrBeast | 2 |
| Nicholas Braun | 2 |
| Romain Bonnet | 2 |
| Ryan Upchurch | 2 |
| Sessilee Lopez | 2 |
| SSundee | 2 |
| Sue Aikens | 2 |
| Susan Rice | 2 |
| Taylor Mills | 2 |
| Torrey Devitto | 2 |
| Alex Choi | 1 |
| Allison Stokke | 1 |
| Bernard Arnault | 1 |
| Ciara Wilson | 1 |
| Dan Peña | 1 |
| Danielle Fishel | 1 |
| Danneel Harris | 1 |
| Darrell Issa | 1 |
| David Portnoy | 1 |
| Eric Porterfield | 1 |
| Fred Stoller | 1 |
| Greg Fishel | 1 |
| Jason Garrett | 1 |
| Liza Koshy | 1 |
| Nicole Fosse | 1 |
| Zaya Wade | 1 |
| Albert Lin | 0 |
| Alexa Demie | 0 |
| Alexandra Cooper | 0 |
| Angie Varona | 0 |
| Avani Gregg | 0 |
| Bailey Sarian | 0 |
| Ben Mallah | 0 |
| Brenda Song | 0 |
| Bridgette Doremus | 0 |
| Charli D'Amelio | 0 |
| Dallmyd | 0 |
| Danielle Cohn | 0 |
| Dixie D'Amelio | 0 |
| Ella Emhoff | 0 |
| Francia Raísa | 0 |
| Hannah Margaret Selleck | 0 |
| Isaak Presley | 0 |
| Jeremy Bamber | 0 |
| Jillie Mack | 0 |
| Joe Lacob | 0 |
| Joey Klaasen | 0 |
| Jordan Chiles | 0 |
| Kai Knapp | 0 |
| Lana Candor | 0 |
| Lei Li Keenan | 0 |
| Lew Alcindor | 0 |
| Lexi Underwood | 0 |
| Marcus Freeman | 0 |
| Mary Lee Pfeiffer | 0 |
| Melanie Iglesias | 0 |
| Miguel Bezos | 0 |
| Olivia O'Brien | 0 |
| Patrick Philbin | 0 |
| Portia Freeman | 0 |
| Quinton Reynolds | 0 |
| Sasha Calle | 0 |
| Scott Yancey | 0 |
| Selena Green Vargas | 0 |
| Selita Ebanks | 0 |
| Sha'Carri Richardson | 0 |
| Shenae Grimes-Beech | 0 |
| Sunisa Lee | 0 |
| Tara Lynn Wilson | 0 |
| Taylor Tomasi Hill | 0 |
| Ted Jorgensen | 0 |
| Thandiwe Newton | 0 |
| Theo Germaine | 0 |
| Trevor Wallace | 0 |
| Yamiche Alcindor | 0 |
| Zack Bia | 0 |
simonw
commented
2 years ago sqlite-utils feature idea inspired by this work:
simonw
commented
2 years ago Interface idea: a textarea you can paste newline-delimited search terms into which then churns away and does a fetch() for each one to get the count. Could do this as a new Datasette plugin.
simonw
commented
2 years ago Now working on the new DB from:
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv' \
| sqlite-utils insert laion-aesthetic-6pls.db artists - --csv
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv&gid=1037423923' \
| sqlite-utils insert laion-aesthetic-6pls.db celebrities - --csv
curl -L 'https://docs.google.com/spreadsheets/d/1JLQQ3U6P0d4vDkAGuB8avmXOPIDPeDUdAEZsWTRYpng/export?format=csv&gid=480391249' \
| sqlite-utils insert laion-aesthetic-6pls.db characters - --csvsqlite-utils add-column laion-aesthetic-6pls.db celebrities image_counts integersqlite-utils laion-aesthetic-6pls.db "$(cat <<EOF
with counts as (
select name,
(
select count(*) from images_fts where images_fts match '"' || name || '"'
) as search_count
from celebrities
)
update celebrities
set image_counts = counts.search_count
from counts
where celebrities.name = counts.name
EOF
)"Now for artists:
sqlite-utils add-column laion-aesthetic-6pls.db artists image_counts integersqlite-utils laion-aesthetic-6pls.db "$(cat <<EOF
with counts as (
select name,
(
select count(*) from images_fts where images_fts match '"' || name || '"'
) as search_count
from artists
)
update artists
set image_counts = counts.search_count
from counts
where artists.name = counts.name
EOF
)"https://laion-aesthetic.fly.dev/laion-aesthetic-6pls/artists?_sort_desc=image_counts
simonw
commented
2 years ago Characters:
sqlite-utils add-column laion-aesthetic-6pls.db characters image_counts integersqlite-utils laion-aesthetic-6pls.db "$(cat <<EOF
with counts as (
select name,
(
select count(*) from images_fts where images_fts match '"' || name || '"'
) as search_count
from characters
)
update characters
set image_counts = counts.search_count
from counts
where characters.name = counts.name
EOF
)"
Would be very interesting to see how many images in the data correspond to popular celebrities.
Running full term extraction (ala https://simonwillison.net/2022/Jul/11/sqlite-comprehend/) would be way too expensive for 52m rows.
Could try using something like spaCy, but my hunch is that given a good list of celebrity names just running dumb FTS searches and counting the results would be good enough.