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.48ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data' LIMIT 1
0.32ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.62ms	SELECT * FROM `Pages` WHERE `parentid` IN ('573') ORDER BY `ord` ASC
0.27ms	SELECT * FROM `pagePersons` WHERE `pageid` IN ('573') ORDER BY `name` ASC
0.30ms	SELECT * FROM `PageImages` WHERE `pageid` IN ('573') ORDER BY `PageImages`.`order` ASC
0.28ms	SELECT * FROM `pageCustomFields` WHERE `pageid` IN ('573')
0.37ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data/' LIMIT 1
0.70ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data//' ORDER BY `id` DESC LIMIT 1
0.67ms	SELECT * FROM `Pages` WHERE `realurl` = 'open-data///' ORDER BY `id` DESC LIMIT 1
0.71ms	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.21ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.35ms	SELECT * FROM `opendata`
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.18ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.27ms	SELECT * FROM `Pages` WHERE `parentid` = '0' AND `status` = '1' ORDER BY `ord` ASC
0.35ms	SELECT * FROM `Pages` WHERE `parentid` IN ('623', '568', '622', '569', '570', '571', '572', '573', '594', '595', '588', '612', '616') ORDER BY `ord` ASC
0.33ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.23ms	SELECT * FROM `Pages` WHERE `id` = '573' LIMIT 1
0.22ms	SELECT * FROM `Pages` WHERE `id` IN ('0') ORDER BY `ord` ASC
0.18ms	SELECT * FROM `Translations` WHERE `objectid` = '623' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '568' AND `lang` = 'lv'
0.18ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '622' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '569' AND `lang` = 'lv'
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.23ms	SELECT * FROM `Translations` WHERE `objectid` = '570' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '571' AND `lang` = 'lv'
0.18ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '572' AND `lang` = 'lv'
0.18ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '573' AND `lang` = 'lv'
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '594' AND `lang` = 'lv'
0.20ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '595' AND `lang` = 'lv'
0.17ms	SELECT * FROM `Translations` WHERE `objectid` = '588' AND `lang` = 'lv'
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '612' AND `lang` = 'lv'
0.19ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.23ms	SELECT * FROM `Translations` WHERE `objectid` = '616' AND `lang` = 'lv'
0.29ms	SELECT * FROM `institutions` WHERE `status` = '1' ORDER BY `updated_at` DESC LIMIT 1
0.18ms	SELECT * FROM `Settings` WHERE `key` = 'footer' LIMIT 1

Time

Query

0.48ms

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

0.32ms

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

0.62ms

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

0.27ms

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

0.30ms

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

0.28ms

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

0.37ms

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

0.70ms

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

0.67ms

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

0.71ms

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

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

0.35ms

SELECT * FROM `opendata`

0.19ms

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

0.18ms

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

0.27ms

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

0.35ms

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

0.33ms

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

0.23ms

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

0.22ms

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

0.18ms

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

0.20ms

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

0.18ms

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

0.20ms

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

0.20ms

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

0.19ms

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

0.23ms

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

0.20ms

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

0.18ms

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

0.20ms

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

0.18ms

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

0.19ms

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

0.19ms

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

0.20ms

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

0.20ms

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

0.19ms

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

0.17ms

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

0.19ms

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

0.19ms

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

0.23ms

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

0.29ms

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

0.18ms

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

Iestāžu katalogs

Atvērta pieeja datiem