Summary

Project that treats data from opendata-rncs.inpi.fr. The database provided content 100 000 profit and loss account of French compagnies. The overall project is meant to be low-code and open source. Aim to provide ethical indicators on companies.

Context

Economics is too serious a thing to leave to economists, yet economic information is often far too complex and plentiful to be comprehensible. Our ambition with Enthic is to reduce as much as possible the barriers to accessing and understanding this data in order to broaden the profiles that delve into it.

On the one hand, financiers, experts and professional consultants manipulate economic data in order to find out which economic actors can bring in big profits. And on the other hand, the general public (or citizens) are subjected to all kinds of more or less true statements made in the media, in order to convince, and not to inform.

This information asymmetry plays a deleterious role for democracy, consumption, the job market and ecological transition. This is why we believe in allowing as many people as possible to reappropriate publicly available economic data, and above all to have access to the information it contains. Enthic is therefore a collaborative, opendata, opensource and free platform that centralizes the public financial data of companies in a single database. This database is accompanied by a website allowing data to be explored, viewed and downloaded: https://enthic-dataviz.netlify.app/

Content

The project currently only deals with the National Trade and Companies Register (RNCS) dataset provided by the National Institute of Industrial Property (INPI), and more particularly the data on the profit and loss accounts of French companies. The database provided content 100 000 profit and loss account of French compagnies, such as annual sales, operating result.

The data comes https://data.inpi.fr/swagger, the extraction has been done in December 2020. Companies can distinguish themselves by their sector of activity (code APE or NAF)

data_kaggle.csv The file contains 100 000 profit and loss of companies. Each line correspond to the profit and loss of a company for one year. It means that a company can have many lines, corresponding to the profit and loss of the year 2016, 2017, 2018 and 2019. Some columns can be obtained by the sum or the subtraction of other columns.

ape_fusion.csv APE makes it possible to identify the main branch of activity of the company. For instance : 47.11C can be interpret as : Section : G Commerce ; réparation d'automobiles et de motocycles Division : 47 Commerce de détail, à l'exception des automobiles et des motocycles Groupe : 47.1 Commerce de détail en magasin non spécialisé Classe : 47.11 Commerce de détail en magasin non spécialisé à prédominance alimentaire Sous classe : 47.11C Supérettes

Profit and loss - Onthology.csv The file contains the description of the columns of 'data_kaggle.csv', the name in French, the translation in English, the liasse is the official ID of the column in the INPI database.

Acknowledgements

We would like to thank PapIT, Leonarf and Briac and Maxime Apercé, who made this dataset possible.

Inspiration

We are interested in Data Visualization and Data Correction. As the project is Open Source and Open data, your help is welcomed on the project. Our suggestion :

• a map of France with all the compagnies
• data visualization of the link between the compagnies
• data visualization of financial flow
• correct missing values
• identify and correct the outliers
• get a tree of the APE code (json)

License

The license to reuse information from the National Institute of Industrial Property (INPI) is approved by the approval decision of April 17, 2019 for data from the National Register of Commerce and Companies of the INPI until April 16 2022. https://www.data.gouv.fr/es/licences

Link

Front : https://enthic-dataviz.netlify.app/ Github : https://github.com/Enthic API : http://api.enthic.fr/