RD IKSD iestāžu katalogs

Atvērta pieeja datiem

Piedāvājām iestāžu kataloga datus mašīnlasāmā formātā

Datu kopa	ANSI	UTF-8
Rīgas pašvaldības SKOLAS (atjaunots 31.01.2018)	Skolas.csv	Skolas_UTF8.txt
Rīgas pašvaldības PIRMSSKOLAS izglītības iestādes (atjaunots 01.02.2017)	Pirmsskolas_20170201.csv	Pirmsskolas_20170201_utf.csv
Rīgas pašvaldības Profesionālās ievirzes izglītības iestādes (sports) (atjaunots 01.02.2017)	BJSS_adreses_20170201.csv	BJSS_adreses_20170201_utf.csv
Rīgas pašvaldības Profesionālās ievirzes izglītības iestādes (mūzika un māksla) (atjaunots 31.01.2018)	MM_Skolas.csv	MM_Skolas_UTF8.txt
Rīgas pašvaldības KONCERTZĀLES (atjaunots 04.12.2015)	Koncertzales.csv	Koncertzales_UTF-8.csv
Rīgas pašvaldības MUZEJI (atjaunots 04.12.2015)	Muzeji.csv	Muzeji_UTF-8.csv
Rīgas pašvaldības BIBLIOTĒKAS (atjaunots 04.12.2015)	Bibliotekas.csv	Bibliotekas_UTF-8.csv
Rīgas pilsētas Kultūras iestāžu apvienība (atjaunots 30.01.2017)	RP_KIA_30012017.csv	RP_KIA_30012017_UTF.csv
Rīgas pašvaldības Kultūras centri (atjaunots 01.02.2017)	KulturasCentri_01022017.csv	KulturasCentri_01022017_utf8.csv
Rīgas pašvaldības Bērnu un jauniešu interešu izglītības iestādes (atjaunots 01.02.2017)	BJC_adreses_20170201.csv	BJC_adreses_20170201_utf.csv
Rīgas pašvaldības izglītības iestāžu Brīvā laika centri (atjaunots 04.12.2015)	BLC.csv	BLC_UTF-8.csv
RD IKSD licencētās pieaugušo neformālās izglītības un interešu izglītības programmas 2015. gadā (atjaunots 01.02.2017)	2015_programmas_e-skola.csv	2015_programmas_e-skola_utf.csv
RD IKSD licencētās pieaugušo neformālās izglītības un interešu izglītības programmas 2016. gadā (atjaunots 01.02.2017)	2016_programmas_e-skola.csv	2016_programmas_e-skola_utf.csv
RD IKSD licencētās pieaugušo neformālās izglītības un interešu izglītības programmas 2017. gadā (atjaunots 01.02.2017)	2017_programmas_e-skola.csv	2017_programmas_e-skola_utf.csv
Izglītojamo skaita dinamika 2003-2016 Skolēnu skaits katra gada 1.septembrī (atjaunots 19.09.2016)	Dinamika.csv	Dinamika UTF-8.csv
Iestāžu atrašanās vietas ģeogrāfiskās koordinātas (atjaunots 04.12.2015)	Geo.csv	Geo_UTF-8.csv
Izglītojamo skaits pa klasēm un iestādēm (atjaunots 20.09.2016)	Izglitojamie_klases.csv	Izglitojamie_klases UTF-8.csv
Rīgas pašvaldības līdzfinansējums bērniem privātajās pirmsskolas izglītības iestādēs (atjaunots 01.02.2017)	Privats_finansejums_20170201.csv	Privats_finansejums_20170201_utf.csv

Datu izmantošana

Datu lietotājs uzņemas pilnu atbildību par iegūto datu tālāku izmantošanu, to apstrādi, interpretāciju un secinājumiem, kas izdarīti, balsoties uz šiem datiem.

Izmantojos šo datus, atsauce uz Rīgas domes Izglītības, kultūras un sporta departamentu ir OBLIGĀTA.

Time	Query
0.31ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data' LIMIT 1
0.17ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.28ms	SELECT * FROM `Pages` WHERE `parentid` IN ('573') ORDER BY `ord` ASC
0.20ms	SELECT * FROM `pagePersons` WHERE `pageid` IN ('573') ORDER BY `name` ASC
0.19ms	SELECT * FROM `PageImages` WHERE `pageid` IN ('573') ORDER BY `PageImages`.`order` ASC
0.20ms	SELECT * FROM `pageCustomFields` WHERE `pageid` IN ('573')
0.26ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data/' LIMIT 1
0.55ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data//' ORDER BY `id` DESC LIMIT 1
0.50ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data///' ORDER BY `id` DESC LIMIT 1
0.53ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data////' ORDER BY `id` DESC LIMIT 1
0.19ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.23ms	SELECT * FROM `opendata`
0.16ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.21ms	SELECT * FROM `Pages` WHERE `parentid` IN ('623', '568', '622', '569', '570', '571', '572', '573', '594', '595', '588', '612', '616') ORDER BY `ord` ASC
0.24ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.16ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.15ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '623' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '568' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '569' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '571' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.29ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '588' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '612' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.22ms	SELECT * FROM `institutions` WHERE `status` = '1' ORDER BY `updated_at` DESC LIMIT 1
0.14ms	SELECT * FROM `Settings` WHERE `key` = 'footer' LIMIT 1

Time

Query

0.31ms

SELECT * FROM `Pages` WHERE `realurl` = 'open-data' LIMIT 1

0.17ms

SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC

0.28ms

SELECT * FROM `Pages` WHERE `parentid` IN ('573') ORDER BY `ord` ASC

0.20ms

SELECT * FROM `pagePersons` WHERE `pageid` IN ('573') ORDER BY `name` ASC

0.19ms

SELECT * FROM `PageImages` WHERE `pageid` IN ('573') ORDER BY `PageImages`.`order` ASC

0.20ms

SELECT * FROM `pageCustomFields` WHERE `pageid` IN ('573')

0.26ms

SELECT * FROM `Pages` WHERE `realurl` = 'open-data/' LIMIT 1

0.55ms

SELECT * FROM `Pages` WHERE `realurl` = 'open-data//' ORDER BY `id` DESC LIMIT 1

0.50ms

SELECT * FROM `Pages` WHERE `realurl` = 'open-data///' ORDER BY `id` DESC LIMIT 1

0.53ms

SELECT * FROM `Pages` WHERE `realurl` = 'open-data////' ORDER BY `id` DESC LIMIT 1

0.19ms

SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC

0.15ms

SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'

0.23ms

SELECT * FROM `opendata`

0.16ms

SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'

0.14ms

SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'

0.20ms

SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC

0.21ms

SELECT * FROM `Pages` WHERE `parentid` IN ('623', '568', '622', '569', '570', '571', '572', '573', '594', '595', '588', '612', '616') ORDER BY `ord` ASC

0.24ms

SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1

0.16ms

SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1

0.15ms

SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC

0.14ms

SELECT * FROM `Translations` WHERE `objectid` = '623' AND `lang` = 'lv'

0.12ms

SELECT * FROM `Translations` WHERE `objectid` = '568' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'

0.12ms

SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '569' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '571' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'

0.12ms

SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'

0.12ms

SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'

0.14ms

SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'

0.29ms

SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'

0.12ms

SELECT * FROM `Translations` WHERE `objectid` = '588' AND `lang` = 'lv'

0.13ms

SELECT * FROM `Translations` WHERE `objectid` = '612' AND `lang` = 'lv'

0.12ms

SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'

0.15ms

SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'

0.22ms

SELECT * FROM `institutions` WHERE `status` = '1' ORDER BY `updated_at` DESC LIMIT 1

0.14ms

SELECT * FROM `Settings` WHERE `key` = 'footer' LIMIT 1

Iestāžu katalogs

Atvērta pieeja datiem