MPEC statistics

Complete station directory

Statistical tables

All tables contain the complete database result. Pagination and browser search alter only the display, not the underlying data.

Methodology

A discovery marker is counted for a station only when the marked observation belongs to that station and the MPEC is eligible for discovery counting. Stars in daily orbit updates are not station discoveries.

Duplicate station names, instruments, observers, and measurers are removed by normalized identity within each station. Exact duplicate observation lines in the same MPEC are stored once. If a source MPEC is corrected, its relationships replace the earlier version transactionally.

No per-mille, percentage, sample, random, or Top-N filter is applied unless it is explicitly selected by the user. Pagination changes only how many rows the browser renders at once; it does not remove records.

Local MPECS database

The database uses SQLite journal mode DELETE, never WAL. New and changed MPEC source files are replaced transactionally; unchanged files are not parsed again. Persistent aggregate tables keep frequently requested totals ready instead of recalculating them for every page.

Download the database GUI (EXE version 2026.08.04.1). It provides paged station, person, object and MPEC searches, safe read-only SQL, name-variant decisions, and complete TSV export.

The generated website is backed by a local database used for incremental analysis and consistent statistics.