{"system":{"name":"Smart Island","description":"AI-powered intelligence for the Isle of Man — 35+ datasets, 93+ MCP tools, 26+ API endpoints","version":"3.0.0","environment":"production","region":"Azure UK South","node":"v20.20.2","commit":"7e4deb6","branch":"master","uptime":"59s","pid":819289,"memoryMB":156,"timestamp":"2026-09-10T01:21:12.036Z"},"database":{"connected":true,"engine":"Microsoft SQL Azure (RTM) - 12.0.2000.8","latencyMs":3},"tables":{"counts":{"jobs":4722,"jobs_active":644,"jobs_inactive":4078,"job_enrichments":4722,"job_soc_recommendations":28152,"job_skills":49692,"job_knowledge":31962,"job_tasks":38855,"skill_canonical":36571,"knowledge_canonical":151,"market_snapshots":21,"weekly_advisors":25,"news_sentiment":23,"occupation_exposure":756,"occupation_metadata":1090,"sic_salaries":960,"soc_salaries":412,"jsa_ai_exposure":358,"soc_codes":2115,"crosswalk_soc_onet":1626,"soc4_ai_modes":491,"soc4_frs_aioe":524,"ai_exposure_frs":774,"census_soc4_summary":386,"vw_census_treemap":105,"data_sources":17,"vehicles":567468,"vehicle_normalizations":8902,"worldbank_indicators":226,"species_occurrences":1517863,"species_summary":9695,"foi_requests":5481},"queryMs":757},"pipelines":{"runs":{"ai_exposure_frs":{"lastRun":"2026-04-01T08:11:03.896Z","description":"Felten-Raj-Seamans AIOE scores by US SOC-2019 occupation (raw)","rowCount":774,"notes":"Source: github.com/AIOE-Data/AIOE → AIOE_DataAppendix.xlsx Appendix A. Imported via pnpm scrape:import-frs. z-score normalized FRS direction score (range ≈ −2.7…+1.5, mean ≈ 0)."},"census-refresh":{"lastRun":"2026-04-01T08:11:11.076Z","description":"Census AI metric tables refresh","rowCount":null,"notes":null},"compute-live-stats":{"lastRun":"2026-04-04T15:22:47.060Z","description":"Daily live stats ticker data","rowCount":null,"notes":null},"compute-my-job-ai":{"lastRun":"2026-04-04T18:32:52.733Z","description":"Pre-computed What Will AI Do to My Job guides","rowCount":null,"notes":null},"enrich":{"lastRun":"2026-09-09T06:02:58.233Z","description":"AI enrichment pipeline","rowCount":null,"notes":null},"news-digest":{"lastRun":"2026-09-06T12:15:43.686Z","description":"AI-summarised IoM news digest for advisor context","rowCount":null,"notes":null},"occupation_exposure":{"lastRun":"2026-04-01T08:11:06.023Z","description":"Felten AIOE observed exposure per SOC-2019 (Anthropic Economic Index, job_exposure.csv)","rowCount":756,"notes":"Last updated: 2026-04-01T07:58:15.743Z. Refresh: pnpm scrape:economic-index"},"scrape":{"lastRun":"2026-09-09T05:14:23.250Z","description":"Job scraper (services.gov.im)","rowCount":644,"notes":"Created: 23, Updated: 621"},"sector-advisor":{"lastRun":"2026-09-06T13:15:28.680Z","description":"Per-sector vacancy, skills & automation analysis","rowCount":null,"notes":null},"sector-deep-dive":{"lastRun":"2026-04-14T23:20:58.556Z","description":"Sector deep-dive assessment: accountancy","rowCount":null,"notes":null},"sentiment":{"lastRun":"2026-09-06T13:30:19.870Z","description":"Local news sentiment analysis","rowCount":null,"notes":null},"snapshot":{"lastRun":"2026-09-06T12:00:10.863Z","description":"Weekly market snapshot","rowCount":null,"notes":null},"soc4_ai_modes":{"lastRun":"2026-04-01T08:10:55.656Z","description":"Anthropic Economic Index — automation/augmentation share per UK SOC4","rowCount":373,"notes":"Downloaded from huggingface.co/datasets/Anthropic/EconomicIndex (release_2025_03_27). Computed from onet_task_statements.csv × automation_vs_augmentation_by_task.csv, aggregated to UK SOC4 via crosswalk_soc_onet."},"soc4_frs_aioe":{"lastRun":"2026-04-01T08:11:03.580Z","description":"Felten-Raj-Seamans AIOE direction score per UK SOC4","rowCount":492,"notes":"Recomputed from claude.dbo.ai_exposure_frs (774 US SOC rows) via crosswalk_soc_onet (LEFT(onet_code,7) join). Original data: github.com/AIOE-Data/AIOE → AIOE_DataAppendix.xlsx Appendix A. Refresh source: pnpm scrape:import-frs"},"strategy-advisor":{"lastRun":"2026-09-06T13:00:40.523Z","description":"AI strategy advisor from DfE agency news","rowCount":null,"notes":null},"vw_census_treemap":{"lastRun":"2026-04-01T08:11:09.896Z","description":"SQL VIEW: IoM census treemap (SOC3 minor groups with AI exposure + salary)","rowCount":105,"notes":"Joins: census_soc4_summary × soc_codes × soc4_ai_modes × soc4_frs_aioe × occupation_exposure (via crosswalk) × soc_salaries (ASHE GBP) × occupation_metadata (BLS USD). Recreated by: pnpm scrape:census-refresh"},"weekly-advisor":{"lastRun":"2026-09-10T00:50:51.600Z","description":"AI weekly advisor reports","rowCount":null,"notes":null}},"queryMs":2},"metrics":{"data":{"activeJobs":644,"enrichedJobs":644,"enrichmentCoverage":"100%","stemJobs":35,"brightOutlookJobs":396,"visaEligibleJobs":"521","avgAutomationRisk":45,"avgAioeScore":59,"distinctEmployers":166,"distinctCategories":12,"distinctSoc2020Codes":141,"latestSnapshot":"2026-W36","latestAdvisor":"2026-W37","latestSentiment":"2026-W36","newestJobSeen":"2026-09-09T05:14:06.3320000","oldestActiveJob":"2026-03-15T23:04:18.5830000"},"queryMs":273},"riskDistribution":{"bands":{"low":83,"high":23,"medium":538},"queryMs":70},"classification":{"arbitration":{"totalClassified":4722,"methods":{"agreement":1161,"ai_dominant":3245,"cascot_dominant":2,"cascot_only":172,"tiebreaker":142},"agreementLevels":{"disagree":2083,"exact":478,"minor_group":683,"sub_major":1306},"aiCascotAgreementRate":"25%"},"queryMs":266},"skillTaxonomy":{"data":{"totalCanonical":36571,"byCategory":{"Digital":1373,"Domain":19586,"Soft":2829,"Technical":12783},"bySource":{"ai_proposed":36420,"iom_seed":83,"onet_skill":35,"onet_knowledge":33},"topDemand":[{"skill":"Communication Skills","activeJobCount":471},{"skill":"Attention to Detail","activeJobCount":390},{"skill":"Time Management","activeJobCount":388},{"skill":"Teamwork","activeJobCount":352},{"skill":"Stakeholder Management","activeJobCount":307},{"skill":"Problem Solving","activeJobCount":277},{"skill":"Report Writing","activeJobCount":270},{"skill":"Record Keeping","activeJobCount":265},{"skill":"Relationship Management","activeJobCount":250},{"skill":"Risk Management","activeJobCount":240}]},"queryMs":238},"employers":{"data":{"byType":{"agency":326,"private":238,"public":80},"top10":[{"name":"Search and Select Recruitment Agency","vacancies":91},{"name":"Itchyfeet Recruitment Agency","vacancies":78},{"name":"Search & Select Recruitment Agency","vacancies":50},{"name":"Manx Care","vacancies":33},{"name":"Recruitment Works","vacancies":30},{"name":"Paragon Recruitment","vacancies":27},{"name":"Orchard Recruitment Limited","vacancies":21},{"name":"Shearwater Recruitment","vacancies":17},{"name":"Department of Education, Sport and Culture","vacancies":13},{"name":"Heron & Brearley Ltd","vacancies":11}]},"queryMs":15},"freshness":{"sources":[{"source":"scraper","lastRun":"2026-09-09T05:14:06.3320000","hoursAgo":20,"maxStaleHours":26,"status":"fresh"},{"source":"enrichment","lastRun":"2026-09-09T06:02:58.1220000","hoursAgo":19,"maxStaleHours":26,"status":"fresh"},{"source":"snapshot","lastRun":"2026-09-06T12:00:04.9690000","hoursAgo":85,"maxStaleHours":170,"status":"fresh"},{"source":"weekly_advisor","lastRun":"2026-09-10T00:50:51.5290000","hoursAgo":1,"maxStaleHours":170,"status":"fresh"},{"source":"sentiment","lastRun":"2026-09-06T13:30:19.3980000","hoursAgo":84,"maxStaleHours":170,"status":"fresh"}],"queryMs":63},"socDistribution":{"majorGroups":[],"queryMs":3},"vehicles":{"data":{"totalPlates":170364,"activeLicence":79547,"evHybrid":6644,"distinctMakes":812,"normalisedCombos":8902,"lastScrapedAt":"2026-08-23T22:00:51.8130000"},"queryMs":375},"estimatedAiTokens":{"note":"Rough estimates based on pipeline activity - actual usage may vary","breakdown":{"jobEnrichment":28332000,"socClassification":9444000,"vehicleNormalisation":336000,"weeklyReports":500000,"narratives":80000,"sentiment":150000,"total":38842000},"totalFormatted":"~39M tokens"},"fileDatasets":{"count":12,"total":12,"datasets":[{"file":"telecoms-page-data.json","exists":true,"sizeKB":10,"lastModified":"2026-09-06T08:45:07.499Z"},{"file":"broadband-speeds-page-data.json","exists":true,"sizeKB":16,"lastModified":"2026-09-06T09:07:51.300Z"},{"file":"grants-page-data.json","exists":true,"sizeKB":48,"lastModified":"2026-03-22T08:00:03.876Z"},{"file":"heritage-page-data.json","exists":true,"sizeKB":191,"lastModified":"2026-09-06T08:30:06.034Z"},{"file":"places-page-data.json","exists":true,"sizeKB":40,"lastModified":"2026-09-06T08:15:09.721Z"},{"file":"infrastructure-page-data.json","exists":true,"sizeKB":11,"lastModified":"2026-09-06T08:15:09.722Z"},{"file":"geography-page-data.json","exists":true,"sizeKB":16,"lastModified":"2026-09-06T08:15:09.738Z"},{"file":"parliament-page-data.json","exists":true,"sizeKB":18,"lastModified":"2026-08-23T07:45:06.769Z"},{"file":"health-page-data.json","exists":true,"sizeKB":27,"lastModified":"2026-09-01T03:30:22.435Z"},{"file":"planning-page-data.json","exists":true,"sizeKB":14,"lastModified":"2026-09-01T03:45:42.829Z"},{"file":"elections-page-data.json","exists":true,"sizeKB":6,"lastModified":"2026-09-01T04:00:05.781Z"},{"file":"economy-page-data.json","exists":true,"sizeKB":22,"lastModified":"2026-09-01T04:15:14.595Z"}],"iotDevices":4},"_diagnostics":{"totalResponseMs":2090,"sectionTimingMs":{"database":3,"tables":757,"pipelines":2,"metrics":273,"riskDistribution":70,"classification":266,"skillTaxonomy":238,"employers":15,"freshness":63,"socDistribution":3,"vehicles":375},"queriesExecuted":"50+","dataPoints":"150+"}}