The song first appears on They Might Be Giants (album).
The song (She Was A) Hotel Detective was found on They Might Be Giants' first album and was followed up by the very different She Was A Hotel Detective on the Back To Skull EP and later (She Was A) Hotel Detective In The Future, released on the band's podcast, and on the Cast Your Pod To The Wind CD that accompanied early pressings of The Else.
The release order of the tracks is canonical to the story. In the first track, she is actively working as a detective at the hotel (She's got her ear to the walls and she's tappin' the calls), later we catch up with her and she's become very rich and has changed her occupation, though it is unclear if she's still doing detective work. With riches, she has become extremely powerful and is "now running the world". In the final song, she has survived long past her years and has had several modifications to her person (She had a hundred mechanical fingers).