search

ebmdatalab / outliers

repo for outlier detection work
MIT License
0 stars 0 forks source link

Organisations to display #17

Closed brianmackenna closed 2 years ago

brianmackenna commented 3 years ago

Do we want to display all organisations that we show on main OP? i.e. practice, PCN, CCG, ICS, Region

Yes if possible but for discussion if we need to prioritise.

Jongmassey commented 3 years ago

Appears these are available in the CCGs table. If we join practice to this then that'll enable grouping by STP/Region

brianmackenna commented 3 years ago

In the sql we use hscic.practices to aggregate to pcn and ccg. We would like to aggregate to region and STP/ICS but these are not recorded in the hscic.practices table.

Do we use table above or is there a better one? (maybe @inglesp / @evansd )

Jongmassey commented 2 years ago

Does this still need region level added or can it now be closed?

brianmackenna commented 2 years ago

I think we don't need it now but we may want to revisit if we integrate into the main site - I think close for this reason? Or do we leave open until then?

Jongmassey commented 2 years ago

Happy to leave open, just wanted to be sure there wasn't something that needed doing right away

brianmackenna commented 2 years ago

Closing. Actually better to approach it fresh or see what feedback comes in from users

brianmackenna commented 2 years ago

you also added all the other ones in so nice to tick off the list!