Be sure to read the Notes section (on this page beyond the two forms) for definitions and additional details on the data.
Form A - U.S. Cities or Towns
Form B - Locations Worldwide
How to Import the Table into a Spreadsheet
Open your favorite text editor, then copy the numerical part of the table (i.e., do not copy the table headings) from your browser and paste it into the text editor. Save the data as a text file.
In Excel for Windows, select Data on the menu bar, then From Text. Select your saved text file. Choose fixed width in the dialog box.
Sidereal time is equal to the hour angle of the catalog equinox and is a direct measure of the diurnal rotation of the Earth. Apparent sidereal time is defined by the intersection of the true equator of date with the ecliptic of date and is affected by the precession and nutation of the axis of the Earth. Mean sidereal time is measured against the mean equinox of date and is only affected by precession.
Equation of the Equinoxes
The Equation of the Equinoxes is equal to the apparent sidereal time minus the mean sidereal time.
Equation of Time
The Equation of Time is the difference apparent solar time minus mean solar time. To obtain this value for a specified time, calculate the apparent geocentric right ascension and declination of the Sun using the Geocentric Positions of Major Solar System Objects and Bright Stars service.
Application Programming Interface