crz

Zmluvy zverejnene v Centralnom registri zmluv (CRZ). Zdrojom su denne XML exporty z crz.gov.sk/export/YYYY-MM-DD.zip.

Data license: Verejne udaje Slovenskej republiky · Data source: Centralny register zmluv

Custom SQL query

Tables

extractions

zmluva_id, service_category, actual_subject, penalty_asymmetry, auto_renewal, bezodplatne, funding_type, grant_amount, hidden_entity_count, penalty_count, iban_count, extraction_json, model, subcontracting_mentioned, subcontractor_count, subcontractor_max_percentage

Many rows

flag_rules

id, label, description, severity, sql_condition, needs_extraction, enabled, created_at

36 rows

fs_corporate_tax

id, ico, dic, nazov, obec, psc, ulica, stat, obdobie_od, obdobie_do, vyrubena_dan, dodat_vyrubena_dan, danova_strata

8,846 rows

fs_tax_debtors

id, nazov, nazov_normalized, suma, ulica, psc, obec

80,578 rows

fs_vat_dereg_reasons

id, ico, ic_dph, nazov, obec, psc, adresa, rok_porusenia, dat_zverejnenia

4,101 rows

fs_vat_deregistered

id, ico, ic_dph, nazov, obec, psc, adresa, rok_porusenia, dat_zverejnenia, dat_vymazu

42,233 rows

prilohy

id, zmluva_id, nazov, subor, url

123,117 rows

red_flags

id, zmluva_id, flag_type, detail, created_at

309,630 rows

rezorty

id, nazov

97 rows

ruz_entities

id, cin, tin, name, city, street, postal_code, region, district, established_on, terminated_on, legal_form, legal_form_id, nace_category, nace_code, organization_size, organization_size_id, ownership_type, consolidated, deleted, data_source

Many rows

ruz_equity

ico, ruz_id, nazov, obdobie, vlastne_imanie, zakladne_imanie, vysledok_hospodarenia, celkove_pasiva, uz_id, vykaz_id, fetched_at

2,252 rows

socpoist_debtors

id, name, address, city, amount, published_on, name_normalized

139,881 rows

sqlite_sequence

name, seq

5 rows

tax_reliability

ico, dic, nazov, status, obec, psc, ulica, stat

Many rows

vszp_debtors

id, name, address, city, postal_code, amount, payer_type, published_on, cin, health_care_claim

149,697 rows

zmluvy

id, nazov_zmluvy, cislo_zmluvy, dodavatel, dodavatel_ico, dodavatel_adresa, objednavatel, objednavatel_ico, objednavatel_adresa, suma, suma_celkom, datum_zverejnenia, datum_podpisu, datum_ucinnosti, platnost_do, poznamka, popis, typ, stav, druh, rezort_id, rezort, zdroj, uvo_url, crz_url

121,615 rows

... and 5 hidden tables