I’m almost scared to explain how I did this in 30 seconds (since I didn’t use code but brute forced it somehow)… but
- Open the file \config.storage\core.entity_registry (I’m on rpi4 / Hassio supervised - did this via Samba)
- Copy all the text and pasted in this random json to table converter…
Voilà. A beautiful table with everything posiible 
Edit: This is the list of data field available in this file:
entity_id
config_entry_id
device_id
area_id
unique_id
platform
name
icon
disabled_by
supported_features
device_class
unit_of_measurement
original_name
original_icon
capabilities/hvac_modes/0
capabilities/hvac_modes/1
capabilities/max_temp
capabilities/min_temp
capabilities/preset_modes/0
capabilities/preset_modes/1
capabilities/preset_modes/2
capabilities/preset_modes/3
capabilities/preset_modes/4
capabilities/source_list/0
capabilities/source_list/1
capabilities/min_mireds
capabilities/max_mireds
capabilities/effect_list/0
capabilities