Please join :-UKTiersponsors Slack

This project is the front-end for https://uktiersponsors.co.uk

Sorry i haven't open sourced the entire project yet.

Nitty Gritty

1 A service which downloads csv every day from government website and checks whether csv is new. If the csv is new , the csv is downloaded

2 Each page of csv is extracted and different company information is put to database. The database is SQL2016.

3 This scans will delete companies from the database, if the company no longer sponsors. The deleted data is moved to a new table, so as to display it back to users.

4 Another service, will fetch the company address, and SIC codes from Companies House API. https://developer.companieshouse.gov.uk/api/docs/

This is done to augment the existing data with the industry in which the company operates.

This also helps in finding the exact company address and other financial obligations like whether bankrupt or made arrears which are currently stored in the database, - This is not brought to website yet.

5 Another service, will crawl, the search engines like Bing, Yahoo and DuckDuckGo to extract company website. This is done using company name, town combination and a union of the results from Page 1 of the search engines are taken and the result which is appearing in all three are counted and ranked based on exclusions (eg:-listing from common company name aggregators like companieshouse,bizstats to name a few are avoided).

This data is put to a Mongo DB database,which contains a list of common urls , (website and social websites)

6 Another service, will fetch the first common url and social website link from Mongo DB and puts it back to the SQL database , which contains the tier 2 companies as described in step(b) , so as to avoid multiple db calls and data consolidation.

This has the added advantage , that if I want to change the algorithm for website finding after analysing existing mongo db search set, i can reinsert it back to the main database easily.

7 A service which will generate CSV files for All companies, recent and deleted companies and stores to Azure Blob Storage which can be downloaded from the website.

Techincal details

• Webiste front end - ReactJS
• Tier 2 Web Api - .NET 5
• Csv extractor service - .NET 4.5
• Industry finder service - .NET 4.5
• Website extractor service - .NET Core
• Website inserter service - .NET Core
• Csv file generator - .NET 4.5
• Database - MSSQL 2016, MongoDB
• Azure Storage - For storing csv files for download

The entire website is hosted at aspnethosting VPS.