search

ONSdigital / dp-find-insights-poc-api

Find Insights Proof of Concept
MIT License
1 stars 0 forks source link

TopicTableCategoryData #98

Closed stmuk closed 1 month ago

stmuk commented 2 years ago

display https://github.com/ONSdigital/census-atlas/blob/master/src/data/simpleTopicTableCategoryData.js via something like


select row_to_json
SELECT nd.name, nc.long_nomis_code,nc.category_name 
FROM nomis_desc nd, nomis_category nc 
WHERE nd.short_nomis_code='QS101EW' and nd.id=nc.nomis_desc_id