Almost all ionic compounds are solids (s)
Many of them dissolve in water to become aqueous ions, for example table salt NaCl (sodium chloride) is a solid (white crystaline solid you have probably had on fries etc). So NaCl(s) is a solid at room temperature, when you put it in water however it becomes sodium ions Na+(aq) and chloride ions Cl-(aq).
Many gases are covalent compounds and not ionic, for example O2 and N2.
Often the state that a compound is in will be determined by things like temperature or pressure (or both)