Newbie questions

[pduk]

I have saved a single 10k from the rss feed into a xbrl_us postgres database and have a number of questions:

1. there seems to be no relationship to the data in the 'label_resource' table;

2. the documentation states that if data is saved from the rss feed, then the sic code of the filer is populated but standard_industrial_classification or irs number, business address or phone etc are not populated - am I missing something; and

3. I would like to be able to extract P&L, Balance sheet and cashflow data for all the years available for a particular company - what is the best way to go about doing that?

Many Thanks

Paul