- query
- The line you submitted, echoed with its original capitalisation and repeated on every row it produced -
John Doe company.com and the like. - full_name
- The person's name as it was parsed out of the line. Lowercased, whatever case you typed. Empty when the line held no name - passing a bare email address is one way to land there.
- domain
- The company domain parsed out of the line. Empty when the line could not be read as a name plus a domain, which is what an
invalid row means. - email
- The address arrived at. Read
status before you use it. Depending on that column this is either an address something confirmed, or a construction nothing did. Empty on an invalid row. - pattern
- How the address was built:
first.last, firstlast, flast, firstl, first_last, first-last, last.first, lastfirst, f.last, first or last - or web, which means it was not built at all but found published. Empty on an invalid row. - status
- The column the row turns on.
found - a real published address. deliverable - the mail server accepted the mailbox. risky - a catch-all domain that accepts anything, so acceptance proves nothing. guess - a candidate the server did not confirm. not_found - no common pattern was accepted. invalid - the line could not be parsed. - status_details
- A plain sentence explaining that status, meant to be read rather than matched: Catch-all domain - accepts any address; candidate pattern. When a published address was found it also says how many sources carried it.
- deliverable
true where something confirmed the address. Otherwise empty - never false. Blank means unconfirmed, not undeliverable; do not cast this column to a boolean and read the blank as no.- catch_all
true where the domain accepts any address, which makes an SMTP acceptance meaningless. Otherwise empty - never false, with the same warning as above.- mx_host
- The mail exchanger the domain resolved to -
smtp.google.com, an Outlook mail.protection.outlook.com host, and so on. Useful for spotting which provider a company is on. Sometimes empty, including on rows where an address was found published. - position
- 1-based index within the query. On a single-answer row it is 1; on a candidate ladder it numbers the patterns in the order they were tried. JSON only - the CSV and XLSX exports stop at ten columns.