@jepyang @sewing I know nothing about antique sewing machines but I found these relevant links which look like a match:
collectorsweekly.com/stories/1
hudsonwoodworking.com/before-a

The last commenter on the first link appears to know what they're talking about, it does look like a Singer 9W (1905-1912)