# justice
Introduction:
My first larger project, an application using Pyhon, Flask and SQLite to download open commercial register data from the Czech Ministry of Justice (justice.cz) and convert them into an sqlite3 database. The applicaton also contains a front-end component to search in the database by various properties. The main goal of the application is to provide users with more advanced search options compared to the official search at the Ministry of Justice website.
Installation:
Running the application:
Firstly, you need to download the open data from the Ministry of Justice and build the database. Run "python justice_build.py", which will download all the source files, create an SQLite database and parse the downloaded data into the database. Note that after the downloaded data are uncompressed, they are around 13 GB and the database file has around 3.6 GB. It takes approximately 1 hour to download the data and build the database.
Once the database is built, run "python main.py" and open http://127.0.0.1:5000 You will be greeted with a search form that is described below.
Features:
Search by company properties:
You will be greeted with the following search form.
The form allows you to search for companies registered in the Commercial Register by the following properties:
- Company name
- Identification number
- Municipality
- Street name
- Court register section (oddíl)
- Court register file No. (vložka)
- Legal form
- Court of registration
- Active insolvency record
- Date of registration
In the fields where you fill-in input data, you can also select one of the following options:
- Your input can be anywere in the result. For example, if you input Trade as a company name, the application will find and return both SILOMAN Trade a.s. and Trade Bridge a.s.
- The result must start with your input. For example, if you input Trade as a company name, the application will find and reutrn only Trade Bridge a.s., but not SILOMAN Trade a.s.
- The result and your input must match. For example, if you input Trade as a company name, the application will neither SILOMAN Trade a.s. nor Trade Bridge a.s.
In addition, you can also select one of the following options:
- Your input must match the company data that are up-to-date. For example, if you input Trade as a company name, a company that used to be names Global Trade, a.s., but had since been renamed, will not be found.
- Your input may match the company data that are no longer up-to-date. For example, if you input Trade as a company name, a company that used to be names Global Trade, a.s., but had since been renamed, will be found.
Search by natural persons:
You will be greeted with the following search form:
The form allows you to search for natural persons registered in the Commercial Register as members of executive bodies, members of supervisory boards, prokurists, shareholders in a limited liability companies, sole shareholders in a joint stock companies. The form allows you to search by the following properties:
- First name
- Surname
- Date of birth
In the fields where you fill-in input data, you can also select one of the following options:
- Your input can be anywere in the result. For example, if you input Nová as a surname, the application will find and return both Novák and Kuhnová
- The result must start with your input. For example, if you input Nová as a surname, the application will find and reutrn only Novák, but not Kuhnová
- The result and your input must match. For example, if you input Nová as a surname, the application will neither Novák nor Kuhnová
In addition, you can also select whether the application shall return only the persons who are still active in the company or whether it shall reutrn also those that are no longer active.
Search by natural persons:
You will be greeted with the following search form:
The form allows you to search for legal persons registered in the Commercial Register as members of executive bodies, members of supervisory boards, shareholders in a limited liability companies, sole shareholders in a joint stock companies. The form allows you to search by the following properties:
- Company name
- Identification No. (for Czech companies)
- Foreign registration No. (for foreign copmpanies)
In the fields where you fill-in input data, you can also select one of the following options:
- Your input can be anywere in the result. For example, if you input Trade as a company name, the application will find and return both SILOMAN Trade a.s. and Trade Bridge a.s.
- The result must start with your input. For example, if you input Trade as a company name, the application will find and reutrn only Trade Bridge a.s., but not SILOMAN Trade a.s.
- The result and your input must match. For example, if you input Trade as a company name, the application will neither SILOMAN Trade a.s. nor Trade Bridge a.s.
In addition, you can also select whether the application shall return only the legal persons who are still active in the company or whether it shall reutrn also those that are no longer active.
Display search results:
Once you hit the search button, you the results will be displayed to you. Several examples are displayed below.
A stadard result when you search by company properties.
If a company has an active insolvency record, it will be highlighted in red and the relevant insovlency notes will be added.
A standard result when you search for a natural person active in a company. It firstly displays the natural person's identification details and then the identification details of the company in which such person is or was active.
A standard result when you search for a legal person active in a company. It firstly displays the legal person's identification details and then the identification details of the company in which such person is or was active.
Display search results:
Trivia:
Known issues: