Line Listing

Epidemiologist organizing anonymous case cards into a structured one-row-per-case outbreak table.

Line Listing Explainer

A line listing is a working table used to organize information about cases during an outbreak or other investigation. Each row usually represents one person or event, and each column represents a variable such as onset date, location, symptoms, laboratory status, exposures, or outcome. The format makes incomplete and inconsistent information easier to see.

Investigators decide which fields answer the main questions, create standard definitions, and update the table as new reports arrive. The line list supports counts, epidemic curves, maps, interview follow-up, and comparisons among groups. It can also show which records need confirmation, missing dates, or duplicate review.

A line list is only as reliable as the data entered. Different staff may interpret fields differently, free-text answers can be hard to compare, and early values may change. Collecting too many variables can slow response and increase privacy risk, while collecting too few can make important hypotheses impossible to test.

Because line lists often contain identifiable information, access should be limited and secure. Teams can separate direct identifiers from analytical variables, use unique case numbers, and document every revision. Public summaries should aggregate information and suppress small cells when needed to protect affected people and communities.

A consistent row-per-case structure allows sorting, filtering, counting, and follow-up.

Unique identifiers help avoid confusing names or accidentally counting the same report twice.

Variables should serve the case definition, descriptive analysis, hypotheses, or response decisions.

Unnecessary fields add work and can expose sensitive information without improving the investigation.

Data dictionaries, validation rules, revision logs, and staff training improve consistency.

Missing, provisional, and unknown values should be labeled rather than silently guessed.

Explore more "Explainers"

Discover additional explainers across politics, science, business, technology, and other fields. Each explainer breaks down a complex idea into clear, everyday language—helping you better understand how major concepts, systems, and debates shape the world around us.