How to Scrape Fire Bureau website via regular expression and importing the data into SQLite?

In the website of Fire Bureau of Taichung City Government, it is showing the real-time reporting cases with the info such as location, time, and status. In this session, we are going to study on how to gran this information via Python and store the data into the database of SQLite.

Target Website:

公告資訊-即時災情(臺中市政府消防局)

Tool:

• Python
• SQLite

Steps

1. Go through the structure of website: When you inspect the website, you can see the information of case located in the tag of <tr>.

2. I am designing a pattern based on the regular expression to extract the key elements.