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.43ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data' LIMIT 1
0.18ms	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.19ms	SELECT * FROM `pagePersons` WHERE `pageid` IN ('573') ORDER BY `name` ASC
0.20ms	SELECT * FROM `PageImages` WHERE `pageid` IN ('573') ORDER BY `PageImages`.`order` ASC
0.20ms	SELECT * FROM `pageCustomFields` WHERE `pageid` IN ('573')
0.27ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data/' LIMIT 1
0.53ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data//' ORDER BY `id` DESC LIMIT 1
0.52ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data///' ORDER BY `id` DESC LIMIT 1
0.51ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data////' ORDER BY `id` DESC LIMIT 1
0.25ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
9.86ms	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.21ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.23ms	SELECT * FROM `Pages` WHERE `parentid` IN ('623', '568', '622', '569', '570', '571', '572', '573', '594', '595', '588', '612', '616') ORDER BY `ord` ASC
0.26ms	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.12ms	SELECT * FROM `Translations` WHERE `objectid` = '623' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '568' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '569' AND `lang` = 'lv'
0.15ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '571' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.12ms	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.12ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.11ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.11ms	SELECT * FROM `Translations` WHERE `objectid` = '588' AND `lang` = 'lv'
0.12ms	SELECT * FROM `Translations` WHERE `objectid` = '612' AND `lang` = 'lv'
0.13ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.14ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.23ms	SELECT * FROM `institutions` WHERE `status` = '1' ORDER BY `updated_at` DESC LIMIT 1
0.12ms	SELECT * FROM `Settings` WHERE `key` = 'footer' LIMIT 1

Time

Query

0.43ms

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

0.18ms

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

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

0.20ms

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

0.20ms

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

0.27ms

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

0.53ms

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

0.52ms

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

0.51ms

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

0.25ms

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

0.15ms

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

9.86ms

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

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

0.23ms

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

0.26ms

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

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

0.12ms

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

0.12ms

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

0.12ms

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

0.12ms

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

0.15ms

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

0.12ms

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

0.14ms

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

0.12ms

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

0.12ms

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

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

0.12ms

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

0.11ms

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

0.12ms

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

0.11ms

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

0.12ms

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

0.13ms

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

0.14ms

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

0.23ms

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

0.12ms

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

Iestāžu katalogs

Atvērta pieeja datiem