What you get
On a public database, each entry becomes a row. Every property is its own column, in the order the view shows them: Company, Location and Type on a job board, Status and Votes on a feedback board. Each row also carries the text of the entry's own page, who created it and when, and the links inside it.
On an ordinary public page, each block (a paragraph, heading, to-do or list item) becomes a row, with nested blocks under the block they sit in. A database embedded in the page adds its entries under its own row.
This is for pages you can only view: a public directory, job board, roadmap or resource list someone else published. If the page is in your own workspace, Notion's built-in export from the ••• menu does the job. Every site is on the review scraper hub.