Background: Companies House data only includes registered office addresses. We require the actual trading addresses (principal place(s) of business) for analysis, marketing outreach, or compliance.
Objective: Build a pipeline that takes a list of UK company numbers (and optional SIC codes), and outputs a CSV with:
Company number
Company name
Number of employees
Turnover (where available)
SIC code(s)
Trading address (street, city, postcode)
2. Scope of Work
Core Data Ingestion
Download/ingest the monthly Companies House bulk CSV (or use the Companies House API) to get company number, name, postcode, SIC code(s).
Trading-Address Enrichment
Primary method: Parse iXBRL filings for .
Fallback method: Query a Places‐API (e.g. Google Places or Foursquare) by “company name + postcode” to retrieve formatted address.
Data Merging & Cleanup
Consolidate registered vs. trading address fields.
Standardize address formatting.
Deduplicate and log failures for manual review.
Export & Delivery
Export a final CSV with the key fields.
Provide a short one-page README describing usage and dependencies
4. Required Skills & Experience
Strong Python (or Node.js) coding for data pipelines.
Experience parsing XBRL/iXBRL (e.g. python-iXBRL or equivalent).
Familiar with REST-API consumption (Companies House, Google/Foursquare, OpenCorporates).
Familiarity with web-scraping frameworks (Scrapy, BeautifulSoup, Puppeteer) is a plus.
Data cleansing and address standardization best practices.
Docker and CLI scripting for packaging (optional but preferred).
Milestones:
Core data ingestion + sample of 50 records
iXBRL enrichment + fallback API integration
Data cleanup, export & documentation
Please include in your proposal:
Relevant past projects / GitHub samples (especially XBRL or address-enrichment work).
Confirmation you can deliver the three key deliverables.
Sales Specialist for Online Growth Category: Digital Marketing, Editing, Email Marketing, Facebook Marketing, Internet Marketing, Sales, Sales Management, Social Media Marketing, Social Sales, Video Services Budget: ₹4000 - ₹8000 INR
26-Jul-2025 03:51 GMT
Logo for nightclub Category: Adobe Creative Cloud, Adobe Illustrator, Graphic Design, HTML, Logo Design, Web Design, Web Development Budget: $8 - $15 USD
26-Jul-2025 03:50 GMT
True Blue Marine Merchandise Designer -- 2 Category: Branding, Fashion Design, Graphic Design, Logo Design, Print Design, Product Design, T Shirts, Visual Design Budget: $30 - $250 AUD
Feng Shui Canvas Web App Development -- 2 Category: API Integration, ChatGPT, Frontend Development, Graphic Design, Laravel, Node.js, React.js, Web Development, Web Design Budget: $100 - $150 USD
26-Jul-2025 03:47 GMT
Format Text Records into Groups Category: Data Analysis, Data Cleansing, Data Entry, Data Extraction, Data Management, Data Processing, Excel, Web Search Budget: ₹12500 - ₹37500 INR
Elementor Tab Video Control Category: CSS, Elementor, HTML, JavaScript, JQuery, PHP, Web Application, Web Design, Web Development Budget: $10 - $30 USD
26-Jul-2025 03:42 GMT
Convert HTML to React Pages Category: CSS, Frontend Development, Graphic Design, HTML, HTML5, JavaScript, React.js, Web Development Budget: $30 - $250 USD
26-Jul-2025 03:40 GMT
Google Ads Expert for Fashion Brand Category: Advertising, Digital Marketing, Google Ads, Google Adwords, Google Analytics, Internet Marketing, Marketing, PPC Marketing Budget: $3000 - $5000 USD
