Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

5.2 MB across 20 parts, newest sealed 4 November 2026 at 01:36 UTC.

The first build wrote 20 parts and 344,702 rows.

ONE_ROW_PER_LINE passed.

disclosure_index

integer

KAP disclosure index of the financial report.

Histogram: 1020791 to 1050470, 86,069; 1050471 to 1080150, 159,051; 1080151 to 1109830, 13,484; 1109831 to 1139510, 83,381; 1139511 to 1169190, 1,310; 1169191 to 1198870, 1,074; 1198871 to 1228550, 0; 1228551 to 1258229, 333
10207911258229
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
2,332 · 0.7% of valid
Min
1020791
25%
1050513
Median
1074407
75%
1109605
Max
1258229

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, 180,988; 248754 to 287503, 0; 287504 to 326253, 81,696; 326254 to 365003, 0; 365004 to 403753, 0; 403754 to 442503, 0; 442504 to 481253, 0; 481254 to 520003, 82,018
210004520003
Valid
344,702 · 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, 82,020; 40 to 76, 77,478; 77 to 113, 42,509; 114 to 150, 36,799; 151 to 187, 38,041; 188 to 224, 24,524; 225 to 261, 24,966; 262 to 298, 18,365
3298
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
296 · 0.1% of valid
Min
3
25%
42
Median
86
75%
168
Max
298

mkk_member_oid

string

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

  • 4028e4a140e95bea0140ed21b5c100781%
  • 4028e4a140e95bea0140edeb7a54015d1%
  • 4028e4a140e95be70140ee2f466d01591%
  • Other (564)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
576 · 0.2% of valid

ticker

string

First Borsa Istanbul stock code of the filer.

  • AGESA1%
  • ANSGR1%
  • TURSG1%
  • Other (564)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
576 · 0.2% of valid

tickers_all

string

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

  • AGESA1%
  • ANSGR1%
  • TURSG1%
  • Other (564)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
576 · 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 (576)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
588 · 0.2% of valid

fiscal_year

integer

Fiscal year the report covers.

Histogram: 2022, 344,702
20222022
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid
Min
2022
25%
2022
Median
2022
75%
2022
Max
2022

fiscal_period

integer

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

Histogram: 1 to 1, 77,327; 2 to 2, 91,684; 3 to 3, 81,261; 4 to 4, 94,430
14
Valid
344,702 · 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: 2022-04-01, 75,991; 2022-07-01, 89,761; 2022-10-01, 81,843; 2023-01-01, 93,301; 2023-04-01, 2,322; 2023-07-01, 1,151; 2023-10-01, 0; 2024-01-01, 333
2022-04-012024-01-01

per quarter

Valid
344,702 · 100%
Missing
0 · 0%
Distinct
2,323 · 0.7% of valid

statement_basis

string

consolidated or solo (KAP ftNiteligi CS or NC).

  • consolidated60%
  • solo40%
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

template

string

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

  • general81%
  • banks9%
  • insurance5%
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
5 · 0% of valid

statement

string

balance_sheet, income_statement or cash_flow.

  • balance_sheet53%
  • cash_flow24%
  • income_statement24%
Valid
344,702 · 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,236)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
1,248 · 0.4% 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.

  • terseLabel44%
  • standartCapitalsLabel9%
  • negatedLabel9%
  • Other (10)
Valid
248,253 · 72%
Missing
96,449 · 28%
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: 2022-01-01, 161,113; 2022-02-01, 397; 2022-03-01, 0; 2022-04-01, 477; 2022-05-01, 30; 2022-06-01, 1,292; 2022-07-01, 405
2022-01-012022-07-01

per month

Valid
163,714 · 47.5%
Missing
180,988 · 52.5%
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: 2022-01-01, 76,124; 2022-04-01, 90,874; 2022-07-01, 81,227; 2022-10-01, 94,075; 2023-01-01, 1,341; 2023-04-01, 1,061
2022-01-012023-04-01

per quarter

Valid
344,702 · 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: 2021-01-01, 35,574; 2021-04-01, 43,536; 2021-07-01, 38,247; 2021-10-01, 223,508; 2022-01-01, 1,631; 2022-04-01, 2,206
2021-01-012022-04-01

per quarter

Valid
344,702 · 100%
Missing
0 · 0%
Distinct
15 · 0% of valid

currency

string

Presentation currency, TL for nearly every filer.

  • TL100%
Valid
344,702 · 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, 343,367; 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,335
11000000
Valid
344,702 · 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: -465139777000000 to -98702508625000, 17; -98702508625000 to 267734759750000, 339,234; 267734759750000 to 634172028125000, 21; 634172028125000 to 1000609296500000, 13; 1000609296500000 to 1367046564875000, 13; 1367046564875000 to 1733483833250000, 3; 1733483833250000 to 2099921101625000, 2; 2099921101625000 to 2466358370000000, 2
-4651397770000002466358370000000
Valid
339,305 · 98.4%
Missing
5,397 · 1.6%
Distinct
198,442 · 58.5% of valid
Min
-465139777000000
25%
0
Median
2714235
75%
109894717
Max
2466358370000000

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: -507267494000000 to -222910796000000, 4; -222910796000000 to 61445902000000, 338,145; 61445902000000 to 345802600000000, 67; 345802600000000 to 630159298000000, 18; 630159298000000 to 914515996000000, 6; 914515996000000 to 1198872694000000, 4; 1198872694000000 to 1483229392000000, 1; 1483229392000000 to 1767586090000000, 2
-5072674940000001767586090000000
Valid
338,247 · 98.1%
Missing
6,455 · 1.9%
Distinct
129,097 · 38.2% of valid
Min
-507267494000000
25%
0
Median
1523657
75%
62541701
Max
1767586090000000

value_3m

decimal

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

Histogram: -46410317000000 to -19693331875000, 4; -19693331875000 to 7023653250000, 37,736; 7023653250000 to 33740638375000, 0; 33740638375000 to 60457623500000, 1; 60457623500000 to 87174608625000, 0; 87174608625000 to 113891593750000, 5; 113891593750000 to 140608578875000, 4; 140608578875000 to 167325564000000, 2
-46410317000000167325564000000
Valid
37,752 · 11%
Missing
306,950 · 89%
Distinct
23,094 · 61.2% of valid
Min
-46410317000000
25%
-927980
Median
0
75%
30844778
Max
167325564000000

value_prior_3m

decimal

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

Histogram: -44473243000000 to -25396466625000, 2; -25396466625000 to -6319690250000, 2; -6319690250000 to 12757086125000, 37,419; 12757086125000 to 31833862500000, 1; 31833862500000 to 50910638875000, 6; 50910638875000 to 69987415250000, 3; 69987415250000 to 89064191625000, 1; 89064191625000 to 108140968000000, 1
-44473243000000108140968000000
Valid
37,435 · 10.9%
Missing
307,267 · 89.1%
Distinct
22,482 · 60.1% of valid
Min
-44473243000000
25%
-566335
Median
0
75%
9727121
Max
108140968000000

audit_type

string

KAP audit type of the report.

  • LT53%
  • CT47%
  • OD0%
Valid
207,415 · 60.2%
Missing
137,287 · 39.8%
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.Ş24%
  • GÜNEY BAĞIMSIZ DENETİM VE SERBEST MUHASEBECİ MALİ MÜŞAVİRLİK A.Ş.15%
  • DRT BAĞIMSIZ DENETİM VE SERBEST MUHASEBECİ MALİ MÜŞAVİRLİK A.Ş.10%
  • Other (58)
Valid
207,415 · 60.2%
Missing
137,287 · 39.8%
Distinct
70 · 0% of valid

kap_url

string

Link to the disclosure on kap.org.tr.

  • https://www.kap.org.tr/tr/Bildirim/10270240%
  • https://www.kap.org.tr/tr/Bildirim/10532490%
  • https://www.kap.org.tr/tr/Bildirim/10535790%
  • Other (2,320)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
2,332 · 0.7% of valid

fetched_at

timestamp_utc

When the report was fetched from KAP.

Timeline per hour: 2026-11-04T01:00Z, 344,702
2026-11-04T01:00Z

per hour

Valid
344,702 · 100%
Missing
0 · 0%
Distinct
647 · 0.2% of valid

window_start

string

KAP listing day the report was listed under in kap_disclosures.

  • 2022-05-106%
  • 2022-08-095%
  • 2022-10-315%
  • Other (176)
Valid
344,702 · 100%
Missing
0 · 0%
Distinct
188 · 0.1% of valid

Support

Talk to Mostly Right

Loading chat…