A sample of 18286 radio-loud active galactic nuclei (AGN) is presented, constructed by combining the seventh data release of the Sloan Digital Sky Survey with the NRAO (National Radio Astronomy Observatory) VLA (Very Large Array) Sky Survey (NVSS) and the Faint Images of the Radio Sky at Twenty centimetres (FIRST) survey. Using this sample, the differences between radio galaxies of "high-excitation" ("quasar-mode"; hereafter HERG) and "low-excitation" ("radio-mode"; LERG) are investigated.