It would seem that I have far too much time on my hands. After the post about a Star Trek "test", I started wondering if there could be any data to back it up and... well here we go:

Those Old Scientists

The Next Generation

Deep Space Nine

Voyager

Enterprise

Discovery

Important Note: As the source material is incomplete for Discovery, the following table only includes line counts from seasons 1 and 4 along with a single episode of season 2.

If anyone is interested, here's the (rather hurried, don't judge me) Python used:

#!/usr/bin/env python

#
# This script assumes that you've already downloaded all the episode lines from
# the fantastic chakoteya.net:
#
# wget --accept=html,htm --relative --wait=2 --include-directories=/STDisco17/ http://www.chakoteya.net/STDisco17/episodes.html -m
# wget --accept=html,htm --relative --wait=2 --include-directories=/Enterprise/ http://www.chakoteya.net/Enterprise/episodes.htm -m
# wget --accept=html,htm --relative --wait=2 --include-directories=/Voyager/ http://www.chakoteya.net/Voyager/episode_listing.htm -m
# wget --accept=html,htm --relative --wait=2 --include-directories=/DS9/ http://www.chakoteya.net/DS9/episodes.htm -m
# wget --accept=html,htm --relative --wait=2 --include-directories=/NextGen/ http://www.chakoteya.net/NextGen/episodes.htm -m
# wget --accept=html,htm --relative --wait=2 --include-directories=/StarTrek/ http://www.chakoteya.net/StarTrek/episodes.htm -m
#
# Then you'll probably have to convert the following files to UTF-8 as they
# differ from the rest:
#
# * Voyager/709.htm
# * Voyager/515.htm
# * Voyager/416.htm
# * Enterprise/41.htm
#

import re
from collections import defaultdict
from pathlib import Path

EPISODE_REGEX = re.compile(r"^\d+\.html?$")
LINE_REGEX = re.compile(r"^(?P<name>[A-Z']+): ")

EPISODES = Path("www.chakoteya.net")
DISCO = EPISODES / "STDisco17"
ENT = EPISODES / "Enterprise"
TNG = EPISODES / "NextGen"
TOS = EPISODES / "StarTrek"
DS9 = EPISODES / "DS9"
VOY = EPISODES / "Voyager"

NAMES = {
    TOS.name: "Those Old Scientists",
    TNG.name: "The Next Generation",
    DS9.name: "Deep Space Nine",
    VOY.name: "Voyager",
    ENT.name: "Enterprise",
    DISCO.name: "Discovery",
}


class CharacterLines:
    def __init__(self, path: Path) -> None:
        self.path = path
        self.line_count = defaultdict(int)

    def collect(self) -> None:
        for episode in self.path.glob("*.htm*"):
            if EPISODE_REGEX.match(episode.name):
                for line in episode.read_text().split("\n"):
                    if m := LINE_REGEX.match(line):
                        self.line_count[m.group("name")] += 1

    @property
    def as_tablular_data(self) -> tuple[tuple[str, int, float], ...]:
        total = sum(self.line_count.values())
        r = []
        for k, v in self.line_count.items():
            percentage = round(v * 100 / total, 2)
            if percentage > 1:
                r.append((str(k), v, percentage))
        return tuple(reversed(sorted(r, key=lambda _: _[2])))

    def render(self) -> None:
        print(f"\n\n# {NAMES[self.path.name]}\n")
        print("| Name             | Total Lines | Percentage of Lines |")
        print("| ---------------- | :---------: | ------------------: |")
        for character, total, pct in self.as_tablular_data:
            print(f"| {character:16} | {total:11} | {pct:19} |")


if __name__ == "__main__":
    for series in (TOS, TNG, DS9, VOY, ENT, DISCO):
        counter = CharacterLines(series)
        counter.collect()
        counter.render()

Just why send bridge crew. Those crew are important and mean to stay on the ship. Unless the mission required someone on the top like first-mate, you should send your boarding team or land team on mission.

Most of the eps, I see a dangerous mission with 2-5 bridge crew member. Sometime it is include both captain and first mate.

Sometime, it is fighting sorties, a first mate said: I need volunteer who is trained in close combat. And multiple bridge crew go with him. The next scene is the crews start shoting handgun in some dangerous place, maybe they also teleport inside enermy ship (boarding action), and sometime is fighting kungfu.

Why not send a sergeant and handful of soldiers ? The ship is quite big but there are no spare personel to send ?

You've heard of the "Bechdel-Wallace test" and its potential value to some people in measuring various media in a given context.

I propose a measure we'll call the "Captain and Crew Test"....

I was enduring -- yes, that's the word I'll choose -- an episode of a certain Trek show and found myself thinking that I seem to enjoy Star Trek shows where the captain isn't the center of attention for the continued story, rather the crew as a whole (including the captain as professionally and relatively required) works together on the story of the day or is portrayed in multiple dimensions without the commanding officer present.

So, here's my attempt at codifying this "Captain and Crew Test":

• The episode/show has to have at least two crew members (i.e. not the captain) essential to the story,
• who interact with each other without the captain,
• about the story without specific direction from the captain

I think these "rules" could use some adjustment and addition, but I think you get what I'm proposing/suggesting/inciting.

UPDATE 2024-07-04 04:35:34 UTC: Check out the quick and amazing work by @danielquinn@lemmy.ca to compile a subset of the percentage of lines for each character in a few Star Trek shows.

I wanted some ambience for an upcoming Star Trek Adventures game, so I whipped up this simple web app.

These are the discussion threads for season two of Star Trek: Prodigy. Since people are likely to go at their own pace, use this index to join the conversation when you can!

2x01 & 2x02 "Into the Breach"

2x03 "Who Saves the Saviors"

2x04 "Temporal Mechanics 101"

2x05 "Observer's Paradox"

2x06 "Imposter Syndrome"

2x07 "The Fast and the Curious"

2x08 "Is There in Beauty No Truth?"

2x09 & 2x10 "The Devourer of All Things"

2x11 & 2x12 "Last Flight of the Protostar"

2x13 "A Tribble Called Quest"

2x14 "Cracked Mirror"

2x15 & 2x16 "Ascension"

2x17 "Brink"

2x18 "Touch of Grey"

2x19 & 2x20 "Ouroboros"

This is the c/startrek discussion thread for "Ouroboros" - join the conversation in the replies!

Part I written by: Kevin Hageman & Dan Hageman & Aaron J. Waltke

Part I directed by: Sean Bishop

Part II written by: Kevin Hageman & Dan Hageman & Aaron J. Waltke

Part II directed by: Ruolin Li

This is the c/startrek discussion thread for "Touch of Grey" - join the conversation in the replies!

Written by: Jennifer Muro

Directed by: Sung Shin

This is the c/startrek discussion thread for "Brink" - join the conversation in the replies!

Written by: Diandra Pendleton-Thompson

Directed by: Ruolin Li

This is the c/startrek discussion thread for "Ascension" - join the conversation in the replies!

Part I written by: Erin McNamara & Jennifer Muro & Diandra Pendleton-Thompson & Keith Sweet II & Aaron J. Waltke

Part I directed by: Sung Shin

Part II written by: Alex Hanson

Part II directed by: Sean Bishop

This is the c/startrek discussion thread for "Cracked Mirror" - join the conversation in the replies!

Written by: Erin McNamara

Directed by: Ruolin Li

This is the c/startrek discussion thread for "A Tribble Called Quest" - join the conversation in the replies!

Written by: Keith Sweet II

Directed by: Sean Bishop

This is the c/startrek discussion thread for "Last Flight of the Protostar" - join the conversation in the replies!

Part I written by: Diandra Pendleton-Thompson

Part I directed by: Ruolin Li and Andrew L. Schmidt

Part II written by: Alex Hanson & Aaron J. Waltke

Part II directed by: Sung Shin

This is the c/startrek discussion thread for "The Devourer of All Things" - join the conversation in the replies!

Part I written by: Jennifer Muro

Part I directed by: Sung Shin

Part II written by: Aaron J. Waltke

Part II directed by: Sean Bishop

This is the c/startrek discussion thread for "Is There in Beauty No Truth?" - join the conversation in the replies!

Written by: Keith Sweet II

Directed by: Ruolin Li and Andrew L. Schmidt

This is the c/startrek discussion thread for "The Fast and the Curious" - join the conversation in the replies!

Written by: Erin McNamara

Directed by: Sean Bishop and Sung Shin

This is the c/startrek discussion thread for "Imposter Syndrome" - join the conversation in the replies!

Written by: Diandra Pendleton-Thompson

Directed by: Sung Shin

This is the c/startrek discussion thread for "Observer's Paradox" - join the conversation in the replies!

Written by: Jennifer Muro

Directed by: Ruolin Li and Andrew L. Schmidt

This is the c/startrek discussion thread for "Temporal Mechanics 101" - join the conversation in the replies!

Written by: Keith Sweet II

Directed by: Ben Hibon