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.50ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data' LIMIT 1
0.20ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.34ms	SELECT * FROM `Pages` WHERE `parentid` IN ('573') ORDER BY `ord` ASC
0.25ms	SELECT * FROM `pagePersons` WHERE `pageid` IN ('573') ORDER BY `name` ASC
0.23ms	SELECT * FROM `PageImages` WHERE `pageid` IN ('573') ORDER BY `PageImages`.`order` ASC
0.19ms	SELECT * FROM `pageCustomFields` WHERE `pageid` IN ('573')
0.31ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data/' LIMIT 1
0.57ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data//' ORDER BY `id` DESC LIMIT 1
0.55ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data///' ORDER BY `id` DESC LIMIT 1
0.55ms	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.14ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.25ms	SELECT * FROM `opendata`
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.21ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.27ms	SELECT * FROM `Pages` WHERE `parentid` IN ('623', '568', '622', '569', '570', '571', '572', '573', '594', '595', '588', '612', '616') ORDER BY `ord` ASC
0.28ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.15ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.16ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '623' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '568' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.14ms	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.14ms	SELECT * FROM `Translations` WHERE `objectid` = '571' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.13ms	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.19ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '588' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '612' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.21ms	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.50ms

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

0.20ms

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

0.34ms

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

0.25ms

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

0.23ms

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

0.19ms

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

0.31ms

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

0.57ms

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

0.55ms

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

0.55ms

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.14ms

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

0.25ms

SELECT * FROM `opendata`

0.13ms

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

0.13ms

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

0.21ms

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

0.27ms

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

0.28ms

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

0.15ms

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

0.16ms

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

0.13ms

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

0.13ms

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

0.14ms

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

0.13ms

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

0.14ms

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.14ms

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

0.13ms

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

0.15ms

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

0.13ms

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

0.13ms

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

0.13ms

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.19ms

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

0.14ms

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

0.14ms

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

0.13ms

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

0.15ms

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

0.21ms

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