Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

6.2 MB across 20 parts, newest sealed 4 November 2026 at 00:30 UTC.

The first build wrote 20 parts and 402,771 rows.

ONE_ROW_PER_LINE passed.

disclosure_index

integer

KAP disclosure index of the financial report.

Histogram: 1273288 to 1324085, 109,624; 1324086 to 1374883, 179,733; 1374884 to 1425681, 109,332; 1425682 to 1476479, 1,515; 1476480 to 1527277, 1,314; 1527278 to 1578075, 1,074; 1578076 to 1628873, 0; 1628874 to 1679670, 179
12732881679670
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
2,798 · 0.7% of valid
Min
1273288
25%
1320677
Median
1351010
75%
1392368
Max
1679670

kap_role

integer

KAP taxonomy role of the statement table, such as 210015 (balance sheet), 310003 (income statement) or 520003 (cash flow).

Histogram: 210004 to 248753, 209,461; 248754 to 287503, 0; 287504 to 326253, 97,742; 326254 to 365003, 0; 365004 to 403753, 0; 403754 to 442503, 0; 442504 to 481253, 0; 481254 to 520003, 95,568
210004520003
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
20 · 0% of valid
Min
210004
25%
210015
Median
210015
75%
310020
Max
520003

line_no

integer

Position of the line inside its statement table, as KAP renders it.

Histogram: 3 to 39, 93,526; 40 to 76, 93,411; 77 to 113, 48,972; 114 to 150, 40,718; 151 to 187, 45,073; 188 to 224, 29,597; 225 to 261, 30,414; 262 to 298, 21,060
3298
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
296 · 0.1% of valid
Min
3
25%
42
Median
87
75%
170
Max
298

mkk_member_oid

string

KAP's stable company identifier (MKK member OID).

  • 4028e4a140e95be70140ee2f466d01591%
  • 4028e4a140e95bea0140ed21b5c100781%
  • 4028e4a140e95bea0140edeb7a54015d1%
  • Other (668)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
680 · 0.2% of valid

ticker

string

First Borsa Istanbul stock code of the filer.

  • AGESA1%
  • ANSGR1%
  • TURSG1%
  • Other (668)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
680 · 0.2% of valid

tickers_all

string

Every stock code of the filer, comma separated, as KAP lists them.

  • AGESA1%
  • ANSGR1%
  • TURSG1%
  • Other (668)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
680 · 0.2% of valid

company_name

string

Filer's name on KAP.

  • AGESA HAYAT VE EMEKLİLİK A.Ş.1%
  • ANADOLU ANONİM TÜRK SİGORTA ŞİRKETİ1%
  • TÜRKİYE SİGORTA A.Ş.1%
  • Other (695)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
707 · 0.2% of valid

fiscal_year

integer

Fiscal year the report covers.

Histogram: 2024, 402,771
20242024
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid
Min
2024
25%
2024
Median
2024
75%
2024
Max
2024

fiscal_period

integer

Fiscal period the report covers: 1 = three months, 2 = six months, 3 = nine months, 4 = full year.

Histogram: 1 to 1, 91,531; 2 to 2, 105,927; 3 to 3, 95,077; 4 to 4, 110,236
14
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
4 · 0% of valid
Min
1
25%
2
Median
3
75%
4
Max
4

published_at

timestamp_utc

When KAP published the report, UTC (Istanbul is UTC+3).

Timeline per quarter: 2024-04-01, 85,522; 2024-07-01, 105,935; 2024-10-01, 97,900; 2025-01-01, 107,302; 2025-04-01, 3,272; 2025-07-01, 1,475; 2025-10-01, 112; 2026-01-01, 1,074; 2026-04-01, 0; 2026-07-01, 0; 2026-10-01, 179
2024-04-012026-10-01

per quarter

Valid
402,771 · 100%
Missing
0 · 0%
Distinct
2,783 · 0.7% of valid

statement_basis

string

consolidated or solo (KAP ftNiteligi CS or NC).

  • consolidated62%
  • solo38%
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

template

string

KAP statement template: general, banks, finance (leasing, factoring) or insurance.

  • general82%
  • banks8%
  • finance4%
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
5 · 0% of valid

statement

string

balance_sheet, income_statement or cash_flow.

  • balance_sheet52%
  • income_statement24%
  • cash_flow24%
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

concept

string

XBRL concept of the line, ifrs-full_* or kap-fr_* (KAP's Turkish extension).

  • kap-fr_CashAndCashEquivalentsForCashFlowStatement1%
  • ifrs-full_Assets1%
  • ifrs-full_Equity1%
  • Other (1,241)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
1,253 · 0.3% of valid

label_role

string

XBRL label role of the line, such as totalLabel or periodEndLabel; tells apart a concept used twice in one table.

  • terseLabel43%
  • standartCapitalsLabel9%
  • negatedLabel9%
  • Other (10)
Valid
286,329 · 71.1%
Missing
116,442 · 28.9%
Distinct
22 · 0% of valid

period_start

date

First day of the current period of a flow statement (income statement, cash flow).

Timeline per month: 2024-01-01, 190,006; 2024-02-01, 396; 2024-03-01, 0; 2024-04-01, 847; 2024-05-01, 100; 2024-06-01, 1,441; 2024-07-01, 520
2024-01-012024-07-01

per month

Valid
193,310 · 48%
Missing
209,461 · 52%
Distinct
6 · 0% of valid

period_end

date

Last day of the current period, the balance sheet date for a balance sheet.

Timeline per quarter: 2024-01-01, 89,980; 2024-04-01, 104,846; 2024-07-01, 95,047; 2024-10-01, 109,927; 2025-01-01, 1,682; 2025-04-01, 1,289
2024-01-012025-04-01

per quarter

Valid
402,771 · 100%
Missing
0 · 0%
Distinct
15 · 0% of valid

prior_period_end

date

Last day of the comparative period in the same report.

Timeline per quarter: 2023-01-01, 42,568; 2023-04-01, 50,235; 2023-07-01, 45,214; 2023-10-01, 259,803; 2024-01-01, 2,112; 2024-04-01, 2,839
2023-01-012024-04-01

per quarter

Valid
402,771 · 100%
Missing
0 · 0%
Distinct
15 · 0% of valid

currency

string

Presentation currency, TL for nearly every filer.

  • TL100%
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid

unit_multiplier

integer

Presentation unit the report used, 1, 1000 or 1000000; values below are already multiplied out.

Histogram: 1 to 125000, 401,053; 125001 to 250000, 0; 250001 to 375000, 0; 375001 to 500000, 0; 500001 to 625000, 0; 625001 to 750000, 0; 750001 to 875000, 0; 875001 to 1000000, 1,718
11000000
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid
Min
1
25%
1
Median
1
75%
1
Max
1000000

value

decimal

Current-period value in whole currency units: period end for the balance sheet, year to date for flows. Signs as KAP presents them: expenses and outflows are negative.

Histogram: -31252119687000000 to -23197482058625000, 1; -23197482058625000 to -15142844430250000, 0; -15142844430250000 to -7088206801875000, 0; -7088206801875000 to 966430826500000, 398,038; 966430826500000 to 9021068454875000, 30; 9021068454875000 to 17075706083250000, 7; 17075706083250000 to 25130343711625000, 0; 25130343711625000 to 33184981340000000, 1
-3125211968700000033184981340000000
Valid
398,077 · 98.8%
Missing
4,694 · 1.2%
Distinct
249,040 · 62.6% of valid
Min
-31252119687000000
25%
0
Median
8150733
75%
292973824
Max
33184981340000000

value_prior

decimal

Comparative-period value in the same report. From fiscal 2023 most non-financial filers restate it into current purchasing power (IAS 29).

Histogram: -26113163553000000 to -19396419463125000, 1; -19396419463125000 to -12679675373250000, 0; -12679675373250000 to -5962931283375000, 0; -5962931283375000 to 753812806500000, 396,544; 753812806500000 to 7470556896375000, 34; 7470556896375000 to 14187300986250000, 7; 14187300986250000 to 20904045076125000, 0; 20904045076125000 to 27620789166000000, 1
-2611316355300000027620789166000000
Valid
396,587 · 98.5%
Missing
6,184 · 1.5%
Distinct
240,157 · 60.6% of valid
Min
-26113163553000000
25%
0
Median
9069000
75%
306690440
Max
27620789166000000

value_3m

decimal

Current three-month value, for interim income statements that carry one.

Histogram: -566332267000 to -397394855375, 3; -397394855375 to -228457443750, 2; -228457443750 to -59520032125, 73; -59520032125 to 109417379500, 44,885; 109417379500 to 278354791125, 56; 278354791125 to 447292202750, 3; 447292202750 to 616229614375, 3; 616229614375 to 785167026000, 1
-566332267000785167026000
Valid
45,026 · 11.2%
Missing
357,745 · 88.8%
Distinct
28,933 · 64.3% of valid
Min
-566332267000
25%
-12641233
Median
0
75%
43124000
Max
785167026000

value_prior_3m

decimal

Comparative three-month value, for interim income statements that carry one.

Histogram: -711170320000 to -484273774000, 1; -484273774000 to -257377228000, 4; -257377228000 to -30480682000, 94; -30480682000 to 196415864000, 44,748; 196415864000 to 423312410000, 9; 423312410000 to 650208956000, 3; 650208956000 to 877105502000, 0; 877105502000 to 1104002048000, 1
-7111703200001104002048000
Valid
44,860 · 11.1%
Missing
357,911 · 88.9%
Distinct
28,884 · 64.4% of valid
Min
-711170320000
25%
-13813559
Median
0
75%
63409397
Max
1104002048000

audit_type

string

KAP audit type of the report.

  • LT53%
  • CT46%
  • OD0%
Valid
236,949 · 58.8%
Missing
165,822 · 41.2%
Distinct
3 · 0% of valid

auditor

string

Audit firm that signed the report, when named.

  • PwC BAĞIMSIZ DENETİM VE SERBEST MUHASEBECİ MALİ MÜŞAVİRLİK A.Ş16%
  • DRT BAĞIMSIZ DENETİM VE SERBEST MUHASEBECİ MALİ MÜŞAVİRLİK A.Ş.15%
  • GÜNEY BAĞIMSIZ DENETİM VE SERBEST MUHASEBECİ MALİ MÜŞAVİRLİK A.Ş.10%
  • Other (65)
Valid
236,949 · 58.8%
Missing
165,822 · 41.2%
Distinct
77 · 0% of valid

kap_url

string

Link to the disclosure on kap.org.tr.

  • https://www.kap.org.tr/tr/Bildirim/13897390%
  • https://www.kap.org.tr/tr/Bildirim/13140630%
  • https://www.kap.org.tr/tr/Bildirim/12770890%
  • Other (2,786)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
2,798 · 0.7% of valid

fetched_at

timestamp_utc

When the report was fetched from KAP.

Timeline per hour: 2026-11-03T23:00Z, 234,846; 2026-11-04T00:00Z, 167,925
2026-11-03T23:00Z2026-11-04T00:00Z

per hour

Valid
402,771 · 100%
Missing
0 · 0%
Distinct
758 · 0.2% of valid

window_start

string

KAP listing day the report was listed under in kap_disclosures.

  • 2024-11-117%
  • 2025-03-115%
  • 2025-03-034%
  • Other (235)
Valid
402,771 · 100%
Missing
0 · 0%
Distinct
247 · 0.1% of valid

Support

Talk to Mostly Right

Loading chat…