crz
Data license: Verejne udaje Slovenskej republiky · Data source: Centralny register zmluv
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_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
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
vszp_debtors
id, name, address, city, postal_code, amount, payer_type, published_on, cin, health_care_claim
Many 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
Many rows
... and 5 hidden tables