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.35ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data' LIMIT 1
0.19ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.30ms	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.22ms	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.54ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data//' ORDER BY `id` DESC LIMIT 1
0.54ms	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.18ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
1.01ms	SELECT * FROM `opendata`
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.18ms	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.17ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.15ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.12ms	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.14ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '569' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.12ms	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.13ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '588' AND `lang` = 'lv'
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '612' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.17ms	SELECT * FROM `institutions` WHERE `status` = '1' ORDER BY `updated_at` DESC LIMIT 1
0.13ms	SELECT * FROM `Settings` WHERE `key` = 'footer' LIMIT 1

Time

Query

0.35ms

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

0.19ms

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

0.30ms

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

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

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

0.54ms

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

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

0.14ms

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

1.01ms

SELECT * FROM `opendata`

0.13ms

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

0.12ms

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

0.18ms

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

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

0.15ms

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

0.12ms

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

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

0.12ms

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

0.12ms

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

0.12ms

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

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

0.12ms

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

0.12ms

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

0.13ms

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

0.14ms

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

0.12ms

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

0.12ms

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

0.12ms

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

0.15ms

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

0.12ms

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

0.12ms

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

0.17ms

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

0.13ms

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

Iestāžu katalogs

Atvērta pieeja datiem