2 rows
where address_postal_full_sv = "Hämeentie 80, 00550 Helsinki" and organizer_type = "ASSOCIATION"
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: created_time (date), last_modified_time (date)
id ▼
|
connections
|
accessibility_properties
|
identifiers_0_namespace
|
identifiers_0_value
|
identifiers_1_namespace
|
identifiers_1_value
|
department
|
root_department
|
provider_type
|
organizer_type
|
contract_type_id
|
contract_type_description_fi
|
contract_type_description_sv
|
contract_type_description_en
|
is_active
|
deleted_at
|
organizer_name
|
organizer_business_id
|
picture_url
|
picture_entrance_url
|
streetview_entrance_url
|
description_fi
|
description_en
|
short_description
|
name_fi
|
name_en
|
street_address_fi
|
street_address_sv
|
street_address_en
|
www_fi
|
www_sv
|
www_en
|
address_postal_full
|
call_charge_info_fi
|
call_charge_info_sv
|
call_charge_info_en
|
picture_caption
|
phone
|
fax
|
email
|
accessibility_phone
|
accessibility_email
|
accessibility_www
|
created_time
|
address_zip
|
data_source
|
extensions_maintenance_group
|
extensions_maintenance_organization
|
last_modified_time
|
accessibility_viewpoints
|
root_service_nodes
|
municipality
|
service_nodes
|
services
|
keywords
|
location_type
|
location_coordinates_0
|
location_coordinates_1
|
address_postal_full_fi
|
identifiers_2_value
|
picture_caption_fi
|
call_charge_info
|
www
|
name_sv
|
short_description_fi
|
accessibility_shortcoming_count_reduced_mobility
|
accessibility_shortcoming_count_wheelchair
|
location
|
picture_caption_sv
|
accessibility_shortcoming_count_stroller
|
address_postal_full_en
|
accessibility_shortcoming_count_hearing_aid
|
street_address
|
contract_type
|
accessibility_shortcoming_count_rollator
|
identifiers_2_namespace
|
address_postal_full_sv
|
short_description_sv
|
description_sv
|
accessibility_shortcoming_count_visually_impaired
|
short_description_en
|
description
|
picture_caption_en
|
63315 |
[{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Toimisto"}, "www": null, "email": "hey.jv@gmail.com", "phone": null, "contact_person": null}] |
[] |
internal |
32159 |
|
|
0154f8e4-443c-4d0c-821a-c3271a47a455 |
0154f8e4-443c-4d0c-821a-c3271a47a455 |
SELF_PRODUCED |
ASSOCIATION |
|
|
|
|
1 |
|
Helsingin Jyry |
1022671-6 |
|
|
|
Esiintyvä senioritanssiryhmä |
|
|
Helsingin Jyry |
Helsingin Jyry |
Hämeentie 80 |
Tavastvägen 80 |
Hämeentie 80 |
https://hejyvoimistelu.sporttisaitti.com/esiintyvat-ryhmat/lipstikka/ |
https://hejyvoimistelu.sporttisaitti.com/esiintyvat-ryhmat/lipstikka/ |
https://hejyvoimistelu.sporttisaitti.com/esiintyvat-ryhmat/lipstikka/ |
|
pvm/mpm |
lna/msa |
local network charge/mobile call charge |
|
|
|
hey.jv@gmail.com |
|
|
|
2020-12-11T14:48:01+02:00 |
00550 |
|
kaikki |
helsinki |
2020-12-11T15:32:24.034239+02:00 |
|
[1403] |
helsinki |
[2225] |
[900] |
{} |
Point |
24.96379 |
60.19294 |
Hämeentie 80, 00550 Helsinki |
|
|
|
|
Helsingin Jyry |
|
|
|
|
|
|
Hämeentie 80, 00550 Helsinki |
|
|
|
|
|
Hämeentie 80, 00550 Helsinki |
|
|
|
|
|
|
63316 |
[{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Toimisto"}, "www": null, "email": "hey.jv@gmail.com", "phone": null, "contact_person": null}] |
[] |
internal |
32160 |
|
|
0154f8e4-443c-4d0c-821a-c3271a47a455 |
0154f8e4-443c-4d0c-821a-c3271a47a455 |
OTHER_PRODUCTION_METHOD |
ASSOCIATION |
|
|
|
|
1 |
|
Helsingin Jyry |
1022671-6 |
|
|
|
Esiintyvä senioritanssiryhmä |
|
|
Helsingin Jyry |
Helsingin Jyry |
Hämeentie 80 |
Tavastvägen 80 |
Hämeentie 80 |
https://hejyvoimistelu.sporttisaitti.com/esiintyvat-ryhmat/lipstikka/ |
https://hejyvoimistelu.sporttisaitti.com/esiintyvat-ryhmat/lipstikka/ |
https://hejyvoimistelu.sporttisaitti.com/esiintyvat-ryhmat/lipstikka/ |
|
pvm/mpm |
lna/msa |
local network charge/mobile call charge |
|
|
|
hey.jv@gmail.com |
|
|
|
2020-12-11T14:48:01+02:00 |
00550 |
|
kaikki |
helsinki |
2020-12-11T15:32:24.051911+02:00 |
|
[1403] |
helsinki |
[2221] |
[895] |
{} |
Point |
24.96379 |
60.19294 |
Hämeentie 80, 00550 Helsinki |
|
|
|
|
Helsingin Jyry |
|
|
|
|
|
|
Hämeentie 80, 00550 Helsinki |
|
|
|
|
|
Hämeentie 80, 00550 Helsinki |
|
|
|
|
|
|
CREATE TABLE [unit] (
[id] INTEGER PRIMARY KEY,
[connections] TEXT,
[accessibility_properties] TEXT,
[identifiers_0_namespace] TEXT,
[identifiers_0_value] TEXT,
[identifiers_1_namespace] TEXT,
[identifiers_1_value] TEXT,
[department] TEXT,
[root_department] TEXT,
[provider_type] TEXT,
[organizer_type] TEXT,
[contract_type_id] TEXT,
[contract_type_description_fi] TEXT,
[contract_type_description_sv] TEXT,
[contract_type_description_en] TEXT,
[is_active] INTEGER,
[deleted_at] TEXT,
[organizer_name] TEXT,
[organizer_business_id] TEXT,
[picture_url] TEXT,
[picture_entrance_url] TEXT,
[streetview_entrance_url] TEXT,
[description_fi] TEXT,
[description_en] TEXT,
[short_description] TEXT,
[name_fi] TEXT,
[name_en] TEXT,
[street_address_fi] TEXT,
[street_address_sv] TEXT,
[street_address_en] TEXT,
[www_fi] TEXT,
[www_sv] TEXT,
[www_en] TEXT,
[address_postal_full] TEXT,
[call_charge_info_fi] TEXT,
[call_charge_info_sv] TEXT,
[call_charge_info_en] TEXT,
[picture_caption] TEXT,
[phone] TEXT,
[fax] TEXT,
[email] TEXT,
[accessibility_phone] TEXT,
[accessibility_email] TEXT,
[accessibility_www] TEXT,
[created_time] TEXT,
[address_zip] TEXT,
[data_source] TEXT,
[extensions_maintenance_group] TEXT,
[extensions_maintenance_organization] TEXT,
[last_modified_time] TEXT,
[accessibility_viewpoints] TEXT,
[root_service_nodes] TEXT,
[municipality] TEXT,
[service_nodes] TEXT,
[services] TEXT,
[keywords] TEXT,
[location_type] TEXT,
[location_coordinates_0] FLOAT,
[location_coordinates_1] FLOAT,
[address_postal_full_fi] TEXT,
[identifiers_2_value] TEXT,
[picture_caption_fi] TEXT,
[call_charge_info] TEXT,
[www] TEXT,
[name_sv] TEXT,
[short_description_fi] TEXT,
[accessibility_shortcoming_count_reduced_mobility] TEXT,
[accessibility_shortcoming_count_wheelchair] TEXT,
[location] TEXT,
[picture_caption_sv] TEXT,
[accessibility_shortcoming_count_stroller] TEXT,
[address_postal_full_en] TEXT,
[accessibility_shortcoming_count_hearing_aid] TEXT,
[street_address] TEXT,
[contract_type] TEXT,
[accessibility_shortcoming_count_rollator] TEXT,
[identifiers_2_namespace] TEXT,
[address_postal_full_sv] TEXT,
[short_description_sv] TEXT,
[description_sv] TEXT,
[accessibility_shortcoming_count_visually_impaired] TEXT,
[short_description_en] TEXT,
[description] TEXT,
[picture_caption_en] TEXT
);