Local Scraper
Israeli Knesset

A Python Decompiler from HTML-TXT to CSV an SQL Database

About This Image

This is a snippet of my local Python HTML-TXT to CSV SQL Database Decompiler of the Official Israeli Knesset website. The code extracts the years of birth of one Knesset cycle, combined with the rest of the code we can obtain a complete database of the Knesset.

About This Project

Aiming to streamline the process of creating a database of The Israeli Knesset Members, and after many failed attempts to scrape the Israeli Knesset website online, I decided to build a local offline HTML scraper to obtain the data.

I developed a program that extracts a CSV file with the full names, date of birth, and the candidacy of the Israeli Knesset members from the Official Israeli Knesset website by year of Knesset.

The CSV file is then imported into an SQL Database for further manipulations in Excel and R to produce visualizations of different generations in each Israeli Knesset cycle.

Working on this project allowed me to hone my skills with Python and HTML on an official government website, overcoming many challenges while making sure that the final program will be 100% accurate and dynamic.

The project is available on my GitHub.

For more works visit My Website.