History of Agenda Items in Helsingin kaupunkiympariston toimiala (Country: Finland)

The table contains the version history of agenda items extracted from the website of Helsingin kaupunkiympäristön toimiala in Finland. It has additional columns '_start_date' and '_end_date' which indicate the extraction dates of the rows. The table provides historical data of multiple columns such as 'id', 'register_i', 'subject', 'policymake', 'meeting_da', 'meeting_id', 'preparer', 'introducer', 'geometry_t', 'geometry_n', 'view_url', 'origin_id', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The '_start_date' column denotes the start date of a specific version of the row, while the '_end_date' column represents the end date when a new version of the row was extracted. If '_end_date' is null, it means that the row is the most recent version. The data in this table can be utilized for data analytics purposes, such as analyzing the frequency of agenda item updates over time, tracking changes in the meeting participants or agenda subjects, and examining the spatial distribution of agenda items using geometric attributes.