File: statistic_of_slovak_places_by_dusan_krehel-2020.json Name: Statistic of Slovak places by Dušan Kreheľ v. 2020 Project: Statistic of Slovak places by Dušan Kreheľ Copyright: © Dušan Kreheľ (dusankrehel@gmail.com) License: Attribution 4.0 International (CC BY 4.0) [https://creativecommons.org/licenses/by/4.0/] URL of project: https://www.krehel.sk/statistic_of_slovak_places_by_dusan_krehel Source dates: © Statistical Office of the Slovak Republic [www.statistics.sk] Input dates are export from online http://datacube.statistics.sk/ (© Statistical Office of the Slovak Republic [www.statistics.sk], license "Attribution 4.0 International (CC BY 4.0)" [https://creativecommons.org/licenses/by/4.0/]) and saved as files with suffix ".xlsx". More informations read sections: - 'Statistic of Slovak places by Dušan Kreheľ' - 'Copyright/About input dates for "Statistic of Slovak places by Dušan Kreheľ"' ------------------------------------------------------------------------------------------------ -------------------------- 'Statistic of Slovak places by Dušan Kreheľ' ----------------------------- ------------------------------------------------------------------------------------------------ [Short description] Original source dates (look section 'Copyright/About input dates for "Statistic of Slovak places by Dušan Kreheľ"' are saved as tables, but i select dates and relationships, and store date in tree (implements as array containing arrays with keys) in format path: /PLACE_GROUP/NAME_PLACE/TYPE_STATISTIC/YEAR with values plus creates new nodes for some items (by me from exist dates from array): - /PLACE_GROUP/NAME_PLACE/places - for districts: This item contains a array of places. - /PLACE_GROUP/NAME_PLACE/pd_kmq - expanse in ㎢ Names of place groups (as "PLACE_GROUP") are: - places - for Slovak villages, towns and cities - places_2 - for Slovak big cities, districts and larger places Before finish, all keys in array are sorted by alphabet and all number values convert from decimal point on decimal dot. Output is as JSON file. More details read in [Longer description]. [Longer description] Notice: First read [Short description]. 2 root nodes are: - places (village, town) - places_2 (city, district, area, country) Root node and names of file with source data: - places - v_om7101rr_00_00_00_sk20210411120218.csv, v_om7101rr_00_00_00_sk20210411121846.csv - places_2 - v_om7102rr_00_00_000_sk20210419145229.csv, v_om7102rr_00_00_00_sk20210419145409.csv Source data of extra sup-node: - places_2/NAME_PLACEC/places - v_om7101rr_00_00_00_sk20210411120218.csv. Node (contains a array with "YEAR":"VALUE") of places/places_2 are: - Description: - Direct from input dates: - pop_01_01 - population in date -01-01 of year - pop_12_31 - population in date -01-31 of year - pd_count - population density, as count - pd_mq - expanse ㎡ - pd_pop - population density (to -06-30/-07-01) - Created by Dušan Kreheľ (on existing input data): - pd_kmq - expanse in ㎢ - converted from node "pd_mq" [values in ㎡] on ㎢ - size is in format: "123456789.99", "12345.9" or "123456" - places (only some /places_2)- Values of NAME_PLACEC are sumare values of another places. This array contains name of "another places" stored as array list. - Source data: - pop_01_01 - v_om7101rr_00_00_00_sk20210411120218.cvs, v_om7102rr_00_00_00_sk20210419145229.csv - pop_31_12 - v_om7101rr_00_00_00_sk20210411121846.cvs, v_om7102rr_00_00_00_sk20210419145409.csv - places_2/NAME_SUP_PLACE/places - v_om7101rr_00_00_00_sk20210411120218.csv Before finish: - No complete places with dates are removes. - All number are convert decimal point on dot. - All keys, no keys with name of year, are sorted by ASC. Finish: - Data in memory are converts on JSON (string) and saved. Names places: - Places are writes in Slovak. ------------------------------------------------------------------------------------------------ ----------- 'Copyright/About input dates for "Statistic of Slovak places by Dušan Kreheľ"' ---------- ------------------------------------------------------------------------------------------------ Dates/file are export from online http://datacube.statistics.sk/ and saved as files with suffix ".xlsx". Files .xlsx was saved as .csv by Dušan Kreheľ with softwer LibreOffice 7.0.4.2 with options: - "Character set: UTF-8" - "Field delimer: ," - "String delimer: '" - "[X] Save cell content as show" - "[X] Quote all text cells" ------------------------------ Title: Počet obyvateľov podľa pohlavia - obce (ročne) [om7101rr] URL source: http://datacube.statistics.sk/#!/view/sk/VBD_DEM/om7101rr/v_om7101rr_00_00_00_sk Copyright of dates: © Statistical Office of the Slovak Republic [www.statistics.sk] License: Attribution 4.0 International (CC BY 4.0) https://creativecommons.org/licenses/by/4.0/ Disclaimer of warranties: https://slovak.statistics.sk/wps/portal/ext/aboutus/webpage/terms/!ut/p/z1 (English) Last update: 2021-03-21 CEST Files download: 2021-04-11 CEST Files are export from online: - v_om7101rr_00_00_00_sk20210411120218.xlsx - view: "Stav trvale bývajúceho obyvateľstva na začiatku obdobia (Osoba)" - v_om7101rr_00_00_00_sk20210411121846.xlsx - view: "Stav trvale bývajúceho obyvateľstva na konci obdobia (Osoba)" files converted by Dušan Kreheľ: - v_om7101rr_00_00_00_sk20210411120218.csv - saved from v_om7101rr_00_00_00_sk20210411120218.xlsx - view: "Stav trvale bývajúceho obyvateľstva na začiatku obdobia (Osoba)" at 2021-04-11 CEST - v_om7101rr_00_00_00_sk20210411121846.csv - saved from v_om7101rr_00_00_00_sk20210411121846.xlsx - view: "Stav trvale bývajúceho obyvateľstva na konci obdobia (Osoba)" at 2021-04-11 CEST -------------------------------------------------------------------------------------------------- Title: Počet obyvateľov podľa pohlavia - SR-oblasť-kraj-okres, m-v (ročne) [om7102rr] URL source: http://datacube.statistics.sk/#!/view/sk/VBD_DEM/om7102rr/v_om7102rr_00_00_00_sk Copyright of dates: © Statistical Office of the Slovak Republic [www.statistics.sk] License: Attribution 4.0 International (CC BY 4.0) https://creativecommons.org/licenses/by/4.0/ Disclaimer of warranties: https://slovak.statistics.sk/wps/portal/ext/aboutus/webpage/terms/!ut/p/z1 (English) Last update: 2021-03-21 CEST Files download: 2021-04-19 CEST Files are online export: - v_om7102rr_00_00_00_sk20210419145229.xlsx - view: "Stav trvale bývajúceho obyvateľstva na začiatku obdobia (Osoba)" - v_om7102rr_00_00_00_sk20210419145409.xlsx - view: "Stav trvale bývajúceho obyvateľstva na konci obdobia (Osoba)" Files converted by Dušan Kreheľ: - v_om7102rr_00_00_00_sk20210419145229.csv - saved from v_om7102rr_00_00_00_sk20210419145229.xlsx at 2021-04-19 CEST - view: "Stav trvale bývajúceho obyvateľstva na začiatku obdobia (Osoba)" - v_om7102rr_00_00_00_sk20210419145409.csv - saved from v_om7102rr_00_00_00_sk20210419145409.xlsx at 2021-04-19 CEST - view: "Stav trvale bývajúceho obyvateľstva na konci obdobia (Osoba)" ----------------------------------------------------------------------------------------------- Title: Hustota obyvateľstva - obce [om7014rr] URL source: http://datacube.statistics.sk/#!/view/sk/VBD_DEM/om7014rr/v_om7014rr_00_00_00_sk Copyright of dates: © Statistical Office of the Slovak Republic [www.statistics.sk] License: Attribution 4.0 International (CC BY 4.0) https://creativecommons.org/licenses/by/4.0/ Disclaimer of warranties: https://slovak.statistics.sk/wps/portal/ext/aboutus/webpage/terms/!ut/p/z1 (English) Last update: 2021-03-21 CEST Files download: 2021-04-23 CEST Files are online export: - v_om7014rr_00_00_00_sk20210423202954.xlsx - view: "Hustota obyvateľstva (Osoba na kilometer štvorcový)" - v_om7014rr_00_00_00_sk20210423203548.xlsx - view: "Rozloha (Štvorcový meter)" - v_om7014rr_00_00_00_sk20210423204136.xlsx - view: "Stav trvale bývajúceho obyvateľstva k 30.6.(1.7.) (Osoba)" Files converted by Dušan Kreheľ: - v_om7014rr_00_00_00_sk20210423202954.csv - saved from v_om7014rr_00_00_00_sk20210423202954.xlsx at 2021-04-23 CEST - view: "Hustota obyvateľstva (Osoba na kilometer štvorcový)" - v_om7014rr_00_00_00_sk20210423203548.csv - saved from v_om7014rr_00_00_00_sk20210423203548.xlsx at 2021-04-23 CEST - view: "Rozloha (Štvorcový meter)" - v_om7014rr_00_00_00_sk20210423204136.csv - saved from v_om7014rr_00_00_00_sk20210423204136.xlsx at 2021-04-23 CEST - view: "Stav trvale bývajúceho obyvateľstva k 30.6.(1.7.) (Osoba)" ----------------------------------------------------------------------------------------------- Title: Hustota obyvateľstva - SR-oblasť-kraj-okres, m-v [om7015rr] URL source: http://datacube.statistics.sk/#!/view/sk/VBD_DEM/om7015rr/v_om7015rr_00_00_00_sk Copyright of dates: © Statistical Office of the Slovak Republic [www.statistics.sk] License: Attribution 4.0 International (CC BY 4.0) https://creativecommons.org/licenses/by/4.0/ Disclaimer of warranties: https://slovak.statistics.sk/wps/portal/ext/aboutus/webpage/terms/!ut/p/z1 (English) Last update: 2021-03-21 CEST Files download: 2021-04-23 CEST Files are online export: - v_om7015rr_00_00_00_sk20210423212732.xlsx - view: "Hustota obyvateľstva (Osoba na kilometer štvorcový)" - v_om7015rr_00_00_00_sk20210423212953.xlsx - view: "Rozloha (Štvorcový meter)" - v_om7015rr_00_00_00_sk20210423213457.xlsx - view: "Stav trvale bývajúceho obyvateľstva k 30.6.(1.7.) (Osoba)" Files converted/saved by Dušan Kreheľ: - v_om7015rr_00_00_00_sk20210423212732.csv - saved from v_om7015rr_00_00_00_sk20210423212732.xlsx at 2021-04-23 CEST - view: "Hustota obyvateľstva (Osoba na kilometer štvorcový)" - v_om7015rr_00_00_00_sk20210423212953.csv - saved from v_om7015rr_00_00_00_sk20210423212953.xlsx at 2021-04-23 CEST - view: "Rozloha (Štvorcový meter)" - v_om7015rr_00_00_00_sk20210423213457.csv - saved from v_om7015rr_00_00_00_sk20210423213457.xlsx at 2021-04-25 CEST - view: "Stav trvale bývajúceho obyvateľstva k 30.6.(1.7.) (Osoba)" -----------------------------------------------------------------------------------------------