Retrieve hosted zones with aws route53 list-hosted-zones
then enter the zone Id below:
aws route53 list-resource-record-sets --hosted-zone-id "/hostedzone/xxxxxxxxxxx" | \
jq -r '.ResourceRecordSets[] | [.Name, .Type, (.ResourceRecords[]? | .Value), .AliasTarget.DNSName?] | @tsv'
I was trying to get the output into a CSV file that was uniform and able to be uploaded to Notion. After tweaking, I came up with the following, which works well for me. It combines the values and any alias into one column and provides a header row so the output is readily importable as a CSV.