red_flags
Data license: Verejne udaje Slovenskej republiky · Data source: Centralny register zmluv
- id
- Automaticky generovany identifikator
- zmluva_id
- ID zmluvy (cudzi kluc na zmluvy.id)
- flag_type
- ID pravidla (cudzi kluc na flag_rules.id)
- detail
- Volitelny doplnkovy detail k vlajke
- created_at
- Datum vytvorenia vlajky
29,623 rows where flag_type = "missing_ico"
This data as json, CSV (advanced)
Suggested facets: created_at, created_at (date)
| id ▼ | zmluva_id | flag_type | detail | created_at |
|---|---|---|---|---|
| 13328 | 2679569 2679569 | missing_ico | 2026-03-07 11:24:17 | |
| 13329 | 2681503 2681503 | missing_ico | 2026-03-07 11:24:17 | |
| 13330 | 2704105 2704105 | missing_ico | 2026-03-07 11:24:17 | |
| 13331 | 2714411 2714411 | missing_ico | 2026-03-07 11:24:17 | |
| 13332 | 2961753 2961753 | missing_ico | 2026-03-07 11:24:17 | |
| 13333 | 6383724 6383724 | missing_ico | 2026-03-07 11:24:17 | |
| 13334 | 6383726 6383726 | missing_ico | 2026-03-07 11:24:17 | |
| 13335 | 6428226 6428226 | missing_ico | 2026-03-07 11:24:17 | |
| 13336 | 6485201 6485201 | missing_ico | 2026-03-07 11:24:17 | |
| 13337 | 6494168 6494168 | missing_ico | 2026-03-07 11:24:17 | |
| 13338 | 6494170 6494170 | missing_ico | 2026-03-07 11:24:17 | |
| 13339 | 6494172 6494172 | missing_ico | 2026-03-07 11:24:17 | |
| 13340 | 6554769 6554769 | missing_ico | 2026-03-07 11:24:17 | |
| 13341 | 6556819 6556819 | missing_ico | 2026-03-07 11:24:17 | |
| 13342 | 6560207 6560207 | missing_ico | 2026-03-07 11:24:17 | |
| 13343 | 6598169 6598169 | missing_ico | 2026-03-07 11:24:17 | |
| 13344 | 6655809 6655809 | missing_ico | 2026-03-07 11:24:17 | |
| 13345 | 6696724 6696724 | missing_ico | 2026-03-07 11:24:17 | |
| 13346 | 6723357 6723357 | missing_ico | 2026-03-07 11:24:17 | |
| 13347 | 6738306 6738306 | missing_ico | 2026-03-07 11:24:17 | |
| 13348 | 6738308 6738308 | missing_ico | 2026-03-07 11:24:17 | |
| 13349 | 6774114 6774114 | missing_ico | 2026-03-07 11:24:17 | |
| 13350 | 6794784 6794784 | missing_ico | 2026-03-07 11:24:17 | |
| 13351 | 6807288 6807288 | missing_ico | 2026-03-07 11:24:17 | |
| 13352 | 6815856 6815856 | missing_ico | 2026-03-07 11:24:17 | |
| 13353 | 6833697 6833697 | missing_ico | 2026-03-07 11:24:17 | |
| 13354 | 6850746 6850746 | missing_ico | 2026-03-07 11:24:17 | |
| 13355 | 6850748 6850748 | missing_ico | 2026-03-07 11:24:17 | |
| 13356 | 6859079 6859079 | missing_ico | 2026-03-07 11:24:17 | |
| 13357 | 6942995 6942995 | missing_ico | 2026-03-07 11:24:17 | |
| 13358 | 6981832 6981832 | missing_ico | 2026-03-07 11:24:17 | |
| 13359 | 6988045 6988045 | missing_ico | 2026-03-07 11:24:17 | |
| 13360 | 7024047 7024047 | missing_ico | 2026-03-07 11:24:17 | |
| 13361 | 7032958 7032958 | missing_ico | 2026-03-07 11:24:17 | |
| 13362 | 7048319 7048319 | missing_ico | 2026-03-07 11:24:17 | |
| 13363 | 7078608 7078608 | missing_ico | 2026-03-07 11:24:17 | |
| 13364 | 7078610 7078610 | missing_ico | 2026-03-07 11:24:17 | |
| 13365 | 7233188 7233188 | missing_ico | 2026-03-07 11:24:17 | |
| 13366 | 7233190 7233190 | missing_ico | 2026-03-07 11:24:17 | |
| 13367 | 7233192 7233192 | missing_ico | 2026-03-07 11:24:17 | |
| 13368 | 7233194 7233194 | missing_ico | 2026-03-07 11:24:17 | |
| 13369 | 7245894 7245894 | missing_ico | 2026-03-07 11:24:17 | |
| 13370 | 7245898 7245898 | missing_ico | 2026-03-07 11:24:17 | |
| 13371 | 7245901 7245901 | missing_ico | 2026-03-07 11:24:17 | |
| 13372 | 7302796 7302796 | missing_ico | 2026-03-07 11:24:17 | |
| 13373 | 7302798 7302798 | missing_ico | 2026-03-07 11:24:17 | |
| 13374 | 7337994 7337994 | missing_ico | 2026-03-07 11:24:17 | |
| 13375 | 7337996 7337996 | missing_ico | 2026-03-07 11:24:17 | |
| 13376 | 7417783 7417783 | missing_ico | 2026-03-07 11:24:17 | |
| 13377 | 7439508 7439508 | missing_ico | 2026-03-07 11:24:17 | |
| 13378 | 7439510 7439510 | missing_ico | 2026-03-07 11:24:17 | |
| 13379 | 7439512 7439512 | missing_ico | 2026-03-07 11:24:17 | |
| 13380 | 7439514 7439514 | missing_ico | 2026-03-07 11:24:17 | |
| 13381 | 7446314 7446314 | missing_ico | 2026-03-07 11:24:17 | |
| 13382 | 7601125 7601125 | missing_ico | 2026-03-07 11:24:17 | |
| 13383 | 7601127 7601127 | missing_ico | 2026-03-07 11:24:17 | |
| 13384 | 7601129 7601129 | missing_ico | 2026-03-07 11:24:17 | |
| 13385 | 7601131 7601131 | missing_ico | 2026-03-07 11:24:17 | |
| 13386 | 7622681 7622681 | missing_ico | 2026-03-07 11:24:17 | |
| 13387 | 7622684 7622684 | missing_ico | 2026-03-07 11:24:17 | |
| 13388 | 7622687 7622687 | missing_ico | 2026-03-07 11:24:17 | |
| 13389 | 7623492 7623492 | missing_ico | 2026-03-07 11:24:17 | |
| 13390 | 7623494 7623494 | missing_ico | 2026-03-07 11:24:17 | |
| 13391 | 7643143 7643143 | missing_ico | 2026-03-07 11:24:17 | |
| 13392 | 7643145 7643145 | missing_ico | 2026-03-07 11:24:17 | |
| 13393 | 7643147 7643147 | missing_ico | 2026-03-07 11:24:17 | |
| 13394 | 7659030 7659030 | missing_ico | 2026-03-07 11:24:17 | |
| 13395 | 7659032 7659032 | missing_ico | 2026-03-07 11:24:17 | |
| 13396 | 7667790 7667790 | missing_ico | 2026-03-07 11:24:17 | |
| 13397 | 7702288 7702288 | missing_ico | 2026-03-07 11:24:17 | |
| 13398 | 7702865 7702865 | missing_ico | 2026-03-07 11:24:17 | |
| 13399 | 7702868 7702868 | missing_ico | 2026-03-07 11:24:17 | |
| 13400 | 7731409 7731409 | missing_ico | 2026-03-07 11:24:17 | |
| 13401 | 7799364 7799364 | missing_ico | 2026-03-07 11:24:17 | |
| 13402 | 7799366 7799366 | missing_ico | 2026-03-07 11:24:17 | |
| 13403 | 7801906 7801906 | missing_ico | 2026-03-07 11:24:17 | |
| 13404 | 7801908 7801908 | missing_ico | 2026-03-07 11:24:17 | |
| 13405 | 7817243 7817243 | missing_ico | 2026-03-07 11:24:17 | |
| 13406 | 7834591 7834591 | missing_ico | 2026-03-07 11:24:17 | |
| 13407 | 7882840 7882840 | missing_ico | 2026-03-07 11:24:17 | |
| 13408 | 7908541 7908541 | missing_ico | 2026-03-07 11:24:17 | |
| 13409 | 7911575 7911575 | missing_ico | 2026-03-07 11:24:17 | |
| 13410 | 7920224 7920224 | missing_ico | 2026-03-07 11:24:17 | |
| 13411 | 7920227 7920227 | missing_ico | 2026-03-07 11:24:17 | |
| 13412 | 7920229 7920229 | missing_ico | 2026-03-07 11:24:17 | |
| 13413 | 7920231 7920231 | missing_ico | 2026-03-07 11:24:17 | |
| 13414 | 7937826 7937826 | missing_ico | 2026-03-07 11:24:17 | |
| 13415 | 8005709 8005709 | missing_ico | 2026-03-07 11:24:17 | |
| 13416 | 8014009 8014009 | missing_ico | 2026-03-07 11:24:17 | |
| 13417 | 8014011 8014011 | missing_ico | 2026-03-07 11:24:17 | |
| 13418 | 8039619 8039619 | missing_ico | 2026-03-07 11:24:17 | |
| 13419 | 8039621 8039621 | missing_ico | 2026-03-07 11:24:17 | |
| 13420 | 8039625 8039625 | missing_ico | 2026-03-07 11:24:17 | |
| 13421 | 8062051 8062051 | missing_ico | 2026-03-07 11:24:17 | |
| 13422 | 8062054 8062054 | missing_ico | 2026-03-07 11:24:17 | |
| 13423 | 8062582 8062582 | missing_ico | 2026-03-07 11:24:17 | |
| 13424 | 8246512 8246512 | missing_ico | 2026-03-07 11:24:17 | |
| 13425 | 8246514 8246514 | missing_ico | 2026-03-07 11:24:17 | |
| 13426 | 8391012 8391012 | missing_ico | 2026-03-07 11:24:17 | |
| 13427 | 8395098 8395098 | missing_ico | 2026-03-07 11:24:17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE red_flags (
id INTEGER PRIMARY KEY AUTOINCREMENT, zmluva_id INTEGER NOT NULL REFERENCES zmluvy(id),
flag_type TEXT NOT NULL REFERENCES flag_rules(id), detail TEXT,
created_at TEXT DEFAULT (datetime('now')), UNIQUE(zmluva_id, flag_type)
);
CREATE INDEX idx_red_flags_zmluva ON red_flags(zmluva_id);
CREATE INDEX idx_red_flags_type ON red_flags(flag_type);