Baselight

Balance Of Payments Of The EU Institutions - Quarterly Data (BPM6)

Eurostat code: bop_euins6_q ยท (1999-Q1 - 2024-Q4)

@eurostat.bop_euins6_q

Balance Of Payments Of The EU Institutions - Quarterly Data (BPM6) - Raw
@eurostat.bop_euins6_q.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 30.29 MB
  • 254244 rows
  • 112 columns
  • Only the first 100 columns are shown
freq

Freq

currency

Currency

bop_item

Bop Item

sector10

Sector10

sectpart

Sectpart

stk_flow

Stk Flow

partner

Partner

geo

Geo

n_1999_q1

1999-Q1

n_1999_q2

1999-Q2

n_1999_q3

1999-Q3

n_1999_q4

1999-Q4

n_2000_q1

2000-Q1

n_2000_q2

2000-Q2

n_2000_q3

2000-Q3

n_2000_q4

2000-Q4

n_2001_q1

2001-Q1

n_2001_q2

2001-Q2

n_2001_q3

2001-Q3

n_2001_q4

2001-Q4

n_2002_q1

2002-Q1

n_2002_q2

2002-Q2

n_2002_q3

2002-Q3

n_2002_q4

2002-Q4

n_2003_q1

2003-Q1

n_2003_q2

2003-Q2

n_2003_q3

2003-Q3

n_2003_q4

2003-Q4

n_2004_q1

2004-Q1

n_2004_q2

2004-Q2

n_2004_q3

2004-Q3

n_2004_q4

2004-Q4

n_2005_q1

2005-Q1

n_2005_q2

2005-Q2

n_2005_q3

2005-Q3

n_2005_q4

2005-Q4

n_2006_q1

2006-Q1

n_2006_q2

2006-Q2

n_2006_q3

2006-Q3

n_2006_q4

2006-Q4

n_2007_q1

2007-Q1

n_2007_q2

2007-Q2

n_2007_q3

2007-Q3

n_2007_q4

2007-Q4

n_2008_q1

2008-Q1

n_2008_q2

2008-Q2

n_2008_q3

2008-Q3

n_2008_q4

2008-Q4

n_2009_q1

2009-Q1

n_2009_q2

2009-Q2

n_2009_q3

2009-Q3

n_2009_q4

2009-Q4

n_2010_q1

2010-Q1

n_2010_q2

2010-Q2

n_2010_q3

2010-Q3

n_2010_q4

2010-Q4

n_2011_q1

2011-Q1

n_2011_q2

2011-Q2

n_2011_q3

2011-Q3

n_2011_q4

2011-Q4

n_2012_q1

2012-Q1

n_2012_q2

2012-Q2

n_2012_q3

2012-Q3

n_2012_q4

2012-Q4

n_2013_q1

2013-Q1

n_2013_q2

2013-Q2

n_2013_q3

2013-Q3

n_2013_q4

2013-Q4

n_2014_q1

2014-Q1

n_2014_q2

2014-Q2

n_2014_q3

2014-Q3

n_2014_q4

2014-Q4

n_2015_q1

2015-Q1

n_2015_q2

2015-Q2

n_2015_q3

2015-Q3

n_2015_q4

2015-Q4

n_2016_q1

2016-Q1

n_2016_q2

2016-Q2

n_2016_q3

2016-Q3

n_2016_q4

2016-Q4

n_2017_q1

2017-Q1

n_2017_q2

2017-Q2

n_2017_q3

2017-Q3

n_2017_q4

2017-Q4

n_2018_q1

2018-Q1

n_2018_q2

2018-Q2

n_2018_q3

2018-Q3

n_2018_q4

2018-Q4

n_2019_q1

2019-Q1

n_2019_q2

2019-Q2

n_2019_q3

2019-Q3

n_2019_q4

2019-Q4

n_2020_q1

2020-Q1

n_2020_q2

2020-Q2

n_2020_q3

2020-Q3

n_2020_q4

2020-Q4

n_2021_q1

2021-Q1

n_2021_q2

2021-Q2

n_2021_q3

2021-Q3

n_2021_q4

2021-Q4

n_2022_q1

2022-Q1

n_2022_q2

2022-Q2

n_2022_q3

2022-Q3

n_2022_q4

2022-Q4

n_2023_q1

2023-Q1

n_2023_q2

2023-Q2

n_2023_q3

2023-Q3

n_2023_q4

2023-Q4

n_2024_q1

2024-Q1

n_2024_q2

2024-Q2

n_2024_q3

2024-Q3

n_2024_q4

2024-Q4

QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEuropean Commission-65134531-118077218-110318259-167563714-60467969-121158440-153852401-150774726-173674467-124164112-152968675-207658714-88350101-122653066-233432522-165690626-72385023-160927029-200858001-290319006-68032454-131782297-229584110-218633858-73564493-183963034-255041455-269541149-150672942-119884570-162221172-348058081-43168243-46885515-135230771-127183351-145294808-264737812-285373027-479259883-207234202-225975320-314409095-440352568-297601528-359233002-374346433-441957871-203705296-269009627-345973984-459779344-252105379-220128317-363315152-480007438-278941695-258898848-220264958-493710228-271612610-275566060-214917130-284045493-350355300-360516446-211638707-273950849-249536115-344847245-263757467-346185815-254620355-360445325-271047776-326377583-202604547-396697743-300875266-440231559-189938595-298789299-265567345-394234929-199897481-446644288-304201958-315274895-235506219-410356123-334989786-354621750
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEuropean Development Fund-174044502-174044502-174044502-174044502-156765960-156765960-156765960-156765960-163060717-163060717-163060717-163060717-206348734-206348734-206348734-206348734-241740531-241740531-241740531-241740531-256563668-256563668-256563668-256563668-256563668-256563668-256563668-256563668-256563668-256563668-256563668-256563668-203556093-203556093-203556093-203556093-255063835-255063835-255063835-255063835-349453601-349453601-349453601-349453601-229334065-229334065-229334065-229334065-283237533-283237533-283237533-283237533-267981884-267981884-267981884-267981884-259927256-259927256-259927256-259927256-253027397-253027397-253027397-253027397-208118754-208118754-208118754-208118754-70936639-70936639-70936639-70936639-251657219-251657219-251657219-251657219-189957743-189957743-189957743-189957743-323120103-323120103-323120103-323120103-121111845-121111845-121111845-121111845
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEuropean Investment Bank (EIB)-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEU institutions except the institutions of the euro area (aggregate changing according to the context)-239179033-292121720-284362761-341608216-217233929-277924400-310618361-307540686-336735184-287224829-316029392-370719431-294698835-329001800-439781256-372039360-314125554-402667560-442598532-532059537-324596122-388345965-486147778-475197526-331221787-441620328-512698749-527198443-408330236-377541864-419878466-605715375-300825537-47979141-136324397-128276977-348923203-468366206-489001422-682888278-462376009-481117126-569550902-695494374-647138058-708769531-723882963-791494400-433115896-498420228-575384584-689189944-535419811-503442749-646629584-763321870-547000575-526957728-488323838-761769108-531619171-535572622-474923692-544052054-603462922-613624068-464746328-527058470-457739229-553050358-471960580-554388929-325644828-431469799-342072250-397402056-454351605-648444802-552622325-691978618-379988684-488839388-455617433-584285018-523112737-769859544-627417215-638490151-356618064-531467968-456101631-475733595
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEuropean Commission-62546402-113518794-103893458-152228522-57980988-116949654-147088083-141382356-157810257-120227784-144215861-198626398-80884804-118460006-224213220-151683957-70918350-148094678-197945982-278487732-63615896-125752531-220834016-201836834-70887044-176299586-247562477-250470231-143237399-112628157-155440905-337282604-35506623-35173110-127744344-110783752-125442143-235736850-270981996-436376987-169509079-203322788-291806693-385553263-248766538-313678163-322507899-355885451-165811093-243990267-316063723-384635346-229885970-192244692-340643005-403994325-246709821-229776010-202787204-409976410-241333097-245859111-186791151-253047174-311422468-327210048-181131460-263869418-218104007-324590884-253927890-277015183-239579790-347163157-248666805-309009255-188935128-379149678-274604901-422407921-178276898-290728559-256309019-373228983-190229928-438653702-293952625-304708090-227965265-386899928-318344783-345283596
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEuropean Development Fund-151469465-151469465-151469465-151469465-119732311-119732311-119732311-119732311-144152946-144152946-144152946-144152946-192737334-192737334-192737334-192737334-236016308-236016308-236016308-236016308-238258909-238258909-238258909-238258909-238258909-238258909-238258909-238258909-238258909-238258909-238258909-238258909-180110381-180110381-180110381-180110381-228475390-228475390-228475390-228475390-299121896-299121896-299121896-299121896-202971554-202971554-202971554-202971554-264079370-264079370-264079370-264079370-251239040-251239040-251239040-251239040-232679690-232679690-232679690-232679690-229891467-229891467-229891467-229891467-187693752-187693752-187693752-187693752-48438070-48438070-48438070-48438070-228026568-228026568-228026568-228026568-178359421-178359421-178359421-178359421-292669932-292669932-292669932-292669932-108047689-108047689-108047689-108047689
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEuropean Investment Bank (EIB)-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626-1093626
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEU institutions except the institutions of the euro area (aggregate changing according to the context)-214015867-264988259-255362923-303697987-177713299-236681965-266820394-261114667-301963203-264380730-288368807-342779344-273622138-311197340-416950554-344421291-306934658-384110986-433962290-514504040-301874805-364011440-459092925-440095743-310239579-415652121-486915012-489822766-382589934-351980692-394793440-576635139-274859158-36266736-128837970-111877378-305624826-415919533-451164679-616559670-398062440-431876150-520360055-614106625-547971362-612882987-621712723-655090275-368859182-447038357-519111812-587683436-494042239-456400960-604799273-668150594-498025857-481092046-454103240-661292447-474092093-478618107-419550146-485806170-541394159-557181739-411103151-493841109-405882117-512368995-441706001-464793294-288105696-395689062-297192710-357535160-417051536-607266086-502721309-650524329-356728664-469180325-434760785-551680749-482995014-731418788-586717711-597473176-336012954-494947617-426392472-453331284
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceCaribbean ACP statesEuropean Commission-2288128-4237469-6424800-13228389-2310306-3497042-5900099-8027777-14065180-3754577-8540031-8543549-7032956-4071319-8473165-13150487-1466673-12703277-2443646-9270031-4080251-5587827-7997235-14857144-2611815-7200938-6118614-16951191-7021136-5108117-6100267-9227343-7046044-11024508-6801882-13143353-18818074-27477618-13364129-40353810-36428168-20262608-21754853-52748414-45318901-43162875-49885704-83083535-36962340-24112608-26549348-71227805-20202647-24200302-19244417-71184781-29739060-24189268-13608256-78601382-26234107-27269515-25636387-28087597-28674906-28937976-23877215-7548463-28534819-15856165-9274645-64925357-11586007-8941603-12000856-14769958-8469681-16728814-24970878-11744468-6540039-7681898-7256671-18757052-8036580-7798917-8034793-8136866-5855864-21110420-10466623-7019750
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceCaribbean ACP statesEuropean Development Fund-18587236-18587236-18587236-18587236-21709168-21709168-21709168-21709168-15228020-15228020-15228020-15228020-10145549-10145549-10145549-10145549-3538671-3538671-3538671-3538671-16067747-16067747-16067747-16067747-16067747-16067747-16067747-16067747-16067747-16067747-16067747-16067747-22301775-22301775-22301775-22301775-25006182-25006182-25006182-25006182-44879154-44879154-44879154-44879154-20943853-20943853-20943853-20943853-16684770-16684770-16684770-16684770-15597928-15597928-15597928-15597928-23674019-23674019-23674019-23674019-17605259-17605259-17605259-17605259-14454247-14454247-14454247-14454247-19554209-19554209-19554209-19554209-17460496-17460496-17460496-17460496-7738806-7738806-7738806-7738806-20769923-20769923-20769923-20769923-7732675-7732675-7732675-7732675

CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "n_1999_q1" DOUBLE,
  "n_1999_q2" DOUBLE,
  "n_1999_q3" DOUBLE,
  "n_1999_q4" DOUBLE,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE,
  "n_2004_q4" DOUBLE,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE,
  "n_2019_q2" DOUBLE,
  "n_2019_q3" DOUBLE,
  "n_2019_q4" DOUBLE,
  "n_2020_q1" DOUBLE,
  "n_2020_q2" DOUBLE,
  "n_2020_q3" DOUBLE,
  "n_2020_q4" DOUBLE,
  "n_2021_q1" DOUBLE,
  "n_2021_q2" DOUBLE,
  "n_2021_q3" DOUBLE,
  "n_2021_q4" DOUBLE
);

Share link

Anyone who has the link will be able to view this.