Production Forecasts For Pigs - Thousand Heads - Quarterly Data

Eurostat code: apro_mt_ppighq · (1995-Q1 - 2026-Q2)

@eurostat.apro_mt_ppighq

Table List

2 tables(137.24 KB)

Production Forecasts For Pigs - Thousand Heads - Quarterly Data - Raw

Production Forecasts For Pigs - Thousand Heads - Quarterly Data - Unpivoted

Production Forecasts For Pigs - Thousand Heads - Quarterly Data - Raw

@eurostat.apro_mt_ppighq.raw

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

110.64 KB
37 rows
131 columns
Only the first 100 columns are shown

freq Freq	meat Meat	meatitem Meatitem	unit Unit	geo Geo	n_1995_q1 1995-Q1	n_1995_q2 1995-Q2	n_1995_q3 1995-Q3	n_1995_q4 1995-Q4	n_1996_q1 1996-Q1	n_1996_q2 1996-Q2	n_1996_q3 1996-Q3	n_1996_q4 1996-Q4	n_1997_q1 1997-Q1	n_1997_q2 1997-Q2	n_1997_q3 1997-Q3	n_1997_q4 1997-Q4	n_1998_q1 1998-Q1	n_1998_q2 1998-Q2	n_1998_q3 1998-Q3	n_1998_q4 1998-Q4	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
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Austria	1286.02	1225.51	1186.28	1232.44	1332.4	1254.48	1242.94	1203.64	1243.62	1280.28	1239.32	1262.4	1309.87	1313.46	1260.63	1386.37	1384.89	1309.95	1235.28	1303.72	1296.65	1241.9	1217.51	1279.51	1239.99	1174.43	1145.32	1269.73	1214.96	1212.48	1231.32	1254.97	1233.89	1192.64	1218.11	1303.46	1275.14	1205.58	1218.38	1269.24	1190.71	1177.22	1159.96	1218.07	1182.48	1154.62	1140.13	1218.36	1222.01	1189.33	1182.61	1272.65	1260	1210	1160	1251.15	1180	1145	1100	1210	1220	1235	1240	1315	1280	1270	1245	1300	1220	1190	1220	1260	1200	1165	1130	1230	1190	1140	1190	1195	1100	1213	1200	1270	1170	1150	1140	1165	1175	1130	1160	1200	1190	1150	1160
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Belgium	2655	2783	2690	2879	2785	2757	2699	2839	2816	2769	2669	2754	2788	2746	2774	2954	2929	2276	2831	2881	2901	2708	2755	2927	2885	2742	2577	2956	2807	2691	2672	2855	2869	2794	2618	2850	2880	2655	2563	2814	2665	2642	2593	2771	2605	2708	2505	2673	2779	2519	2582	2725	2674	2399	2647	2610	2595	2621	2556	2295	2558	2297	2834	2821	2896	2868	2988	2945	2961	2930	2890	2856	2874	2822	2855	2829	2925	2856	2928	2916	2.97	2.97	2865	2795	2832	2781	2836	2786	2744	2714	2734	2748	2874	2892	2827
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Bulgaria																																													204.89	198.7	182.33	403.32	176.05	171.02	161.69	498.81	183.11	156.84	153.21	496.65	184.77	160.31	142.72	489.24	154.77	148.77	132.47	457.17	150.7	139.15	113.78	422.29	178.2	174.55	163.35	388.64	182.13	222.37	152.59	444.62	177.87	175	185	355	231	235	241	346	223	246	256	314	229	236	247	328	257	294	299
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Switzerland																																																																																					690	645	670	680	651	641	691	671	661.88	623.06	638.2
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Cyprus																																	156	161	177	175	154	166	184	174	165	162	175	170	153.48	154.17	167.77	165.07	147.73	173.01	179.28	178.78	151.57	165.81	176.03	191.66	172.13	171.31	179.12	185.78	168.08	175.84	182.54	183.15	174.5	178.35	176.35	185.78	169.89	175.3	187.9	193.2	142.99	172.9	169.57	170.25	171.14	135.22	150.49	147.12	130.45	134.95	150.1	148.42	132.84	132.84	136.73	135.98	156.67	133.81	147.51	154.51	131.89	139.02	153.09
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Czechia																																	1332	1332	1207	1283	1353	1224	1146	1244	1093.6	1078.35	1059.41	1118.62	1021.61	1001.83	948	1070.67	1027.77	989.28	993.21	999.02	969	923	938.51	898	810	771	670.4	738.9	776.7	719	647.7	778.7	733.8	620.7	599.4	762.7	721.8	623.9	683.6	695	602.85	560.17	600.33	616.65	642.9	634.4	611.2	674.6	648	656.5	636.7	710.5	668	635.5	610.5	656	711.5	695.3	666.7	693.5	684.6	645.4	626.5
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Germany	9351	9148	8981	9709	9307	8872	8885	9456	9154	9309	9110	9968	9725	9540	9623	10500	10534.41	10320.86	10126.98	10776.51	10105	9926	9832	10638	10172	9844	9581	10664	10123.01	9989.39	10012.43	10443.11	9965.84	9981.55	9959.21	10620.36	10668	9833	9998	10694	9875	10276	10446	10991	11002.49	10890.5	11005.16	11663.2	10903	10487	11032	11826	11098	10948	11158	11418	11029	10787	11389	11922	11327.66	11245.43	11910.85	11878.5	11644.78	11549.83	12189.67	12305.44	11586.1	11297.66	11711.8	11922.49	11568.42	11299.7	11731.5	11793.01	11386.09	11057.64	11726.2	11796.5	11974.12	11239.65	11768.2	12287.37	11657.02	11188.93	11147	11376	11008	10997	11062	11608	11422	10992	11266
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Denmark	5134	4895	5150	5155	5148	4855	5243	5179	5094	5153	5317	5498	5809	5164	5831	5934	5997	5516	5573	5787	5714	5291	5621	5788	5814	5490	5916	5979	5993	5961	5986	6263	6374	5734	6064	6262	6400	6049	6300	6448	6382	6295	6502.7	6578.8	6761.3	6035.1	6277.9	6530.35	6782.2	6204.4	6327.7	6996.9	7157.5	6473.4	6600	6847.3	7120.3	6660.4	6876.8	6945.9	7176.4	6911.3	7137.7	7279.8	7611.9	6969.3	7328.8	7488.9	7493	7039.6	7211.9	7302.6	7125.1	7418.5	7163.3	7435	7431.1	7402.6	7520.6	7783.4	7951.8	7453.5	7844.8	7780.4	7950	7700	8022.9	8064.8	7974.3	7790.2	7901.6	8249.8	8166.7	8121.2	8046.3
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Estonia																																	119	126	177	121	129	144	131	134	122	128	119	146	115	112	104	122	115	112	110	125	114	113	113	124	114	113	113	124	113	112	125	130	123	123	127	131	124	125	168.5	165.7	152.4	156.7	166.2	173.1	159.3	160.9	162.5	172.9	159.1	160.7	158.3	161.9	158.6	157.1	158.7	160.3	132	132	135	140	127	130	135
Quarterly	Pigmeat	Gross indigenous production	Thousand heads (animals)	Greece						453.11	527.62	735.62	511.77	462.2	519.83	725.97	539.47	469.13	519.21	718.5	536.84	453.75	500.19	689.42	526.1	451.94	512.77	706.19	536.49	468.24	522.16	755.5	532.62	449.91	495.88	752.85	534.98	425.34	485.78	733.11	543.8	435.9	550.8	720.3	538.2	442.8	474.4	711.9	529	432.5	465.6	707.5	532.2	430.7	458.5	702.4	528.6	428.5	453.3	699.6	520.3	425.8	441.4	680.2	509.7	417.6	430.5	672.8	500.1	413.4	418.6	650.5	486.4	401.3	415.5	648	440	398	417	615	398	370	390	590	360	340	380	560	340	320	350	520	285	284.5	330	460	283.5	282.3	325


CREATE TABLE raw (
  "freq" VARCHAR,
  "meat" VARCHAR,
  "meatitem" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1995_q1" DOUBLE,
  "n_1995_q2" DOUBLE,
  "n_1995_q3" DOUBLE,
  "n_1995_q4" DOUBLE,
  "n_1996_q1" DOUBLE,
  "n_1996_q2" DOUBLE,
  "n_1996_q3" DOUBLE,
  "n_1996_q4" DOUBLE,
  "n_1997_q1" DOUBLE,
  "n_1997_q2" DOUBLE,
  "n_1997_q3" DOUBLE,
  "n_1997_q4" DOUBLE,
  "n_1998_q1" DOUBLE,
  "n_1998_q2" DOUBLE,
  "n_1998_q3" DOUBLE,
  "n_1998_q4" DOUBLE,
  "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
);