Rent Audiences in Helsinki, Finland

The dataset collection consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympäristön toimiala' in Finland.

Tables

Rent Audiences for Winkki Rents in Helsinki, FinlandTSV
This table contains data from the 'Rent Audiences' section of the 'Helsingin kaupunkiympariston toimiala' website in Finland. The table contains information related to event rentals and licenses. It includes columns such as '_extract_date', '_row_number', 'event_iden', 'event_star', 'event_sta0', 'event_endd', 'event_endt', 'event_desc', 'location_d', 'licence_id', 'licence_i0', 'licence_ty', 'rental_sub', 'licence_st', 'lic_startd', 'licence_en', 'lic_enddat', 'licence_s0', 'licence_de', 'licence_ap', 'restaurant', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data can be utilized in various data analytics scenarios such as analyzing event rental patterns, identifying popular venues, determining event durations, tracking...
Version History of Rents Audiences for Winkki Rents Audiences PolygonTSV
This table contains the version history of the rows from the Helsingin kaupunkiympariston toimiala database table 'winkki_rents_audiencespolygon'. Each row in this table represents a specific version of a row in the base table. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. The data in this table is sourced from the website of 'Helsingin City Environment', which originates from Finland (ISO country code: 'FI'). Analyzing this data can provide insights into the historical changes and updates made to the rental audience polygon information, event details, location...

Column Descriptions

Rent Audiences for Winkki Rents in Helsinki, Finland

Column	Type	Comment
_extract_date	date
_row_number	long
event_iden	string
event_star	string
event_sta0	timestamp
event_endd	string
event_endt	timestamp
event_desc	string
location_d	string
licence_id	int
licence_i0	string
licence_ty	string
rental_sub	string
licence_st	string
lic_startd	timestamp
licence_en	string
lic_enddat	timestamp
licence_s0	string
licence_de	string
licence_ap	string
restaurant	string
geom_geojson	string
geom_geotext	string
geom_type	string
geom_centroid	string
geom_center_x	double
geom_center_y	double
geom	binary

Version History of Rents Audiences for Winkki Rents Audiences Polygon

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The number assigned to each row in the table.
event_iden	string	The identifier of the event associated with the row version.
event_star	string	The start date of the event.
event_sta0	timestamp	The start time of the event.
event_endd	string	The end date of the event.
event_endt	timestamp	The end time of the event.
event_desc	string	The description of the event.
location_d	string	The location of the event.
licence_id	int	The identifier of the licence associated with the row version.
licence_i0	string	The internal identifier of the licence.
licence_ty	string	The type of licence.
rental_sub	string	The rental subject associated with the row version.
licence_st	string	The status of the licence.
lic_startd	timestamp	The start date of the licence.
licence_en	string	The end date of the licence.
lic_enddat	timestamp	The end date of the licence.
licence_s0	string	The status of the licence.
licence_de	string	The description of the licence.
licence_ap	string	The application associated with the licence.
restaurant	string	The name of the restaurant associated with the row version.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the center of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The geometry.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018