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 @[email protected] 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.

Trip: A poop question, sir? Can't I talk about the warp reactor or the transporter?
Archer: It's a perfectly valid question.

In season one of ENT's "Breaking the Ice", the crew of the NX-01 records a video for Ms. Malvin's class of fourth graders back on Earth, and one of the questions is what happens when someone aboard the ship flushes the toilet, which Archer throws to Trip, and Trip is concerned the kids are going to think he's the ship's sanitation engineer.

Now, because Archer is an awkward goober in this episode, it seems like he's reading the questions off the cuff, with no one other than the possible exception of Ms. Malvin herself, having first vetted them. However, at the start of the recording, Archer announces that he's the one who selected the questions so he knew going in that the, as Trip puts it, "poop question," would be in there. Also before the recording Archer told Trip that he needed to there to participate as opposed to dealing with the large amount of work that was on his plate. What's more, we know from the start of the episode that Trip's nephew is one of the fourth grade students in Ms. Malvin's class.

So, my theory is that Archer made the intentional choice to have Trip answer a question he knew the engineer would find to be embarrassing, specifically to diminish him in the eyes of his nephew. Why would he do this extremely petty thing to someone who is ostensibly his friend and most loyal officer? Probably because he sucks and wanted to put Trip in his place for some imagined slight, just like he later has an outburst with the Vulcan captain whom he invited to dinner.

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

Part I written by: Kevin Hageman & Dan Hageman

Part I directed by: Ben Hibon

Part II written by: Aaron J. Waltke

Part II directed by: Patrick Krebs and Andrew L. Schmidt

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 "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 "Temporal Mechanics 101" - join the conversation in the replies!

Written by: Keith Sweet II

Directed by: Ben Hibon

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 "Who Saves the Saviors" - join the conversation in the replies!

Written by: Erin McNamara

Directed by: Sung Shin