parlgov: viewcalc_country_year

Data source: ParlGov · About: simonw/parlgov-datasette

8,687 rows

descending

Link	rowid ▼	id_type	year	id	share
101	101	cabinet	1909	1362	0.20054945054945056
102	102	cabinet	1909	1363	0.6236263736263736
103	103	cabinet	1909	1372	1.0
104	104	cabinet	1909	1382	0.8159340659340659
105	105	cabinet	1909	1386	0.18406593406593408
106	106	cabinet	1909	1390	0.5604395604395604
107	107	cabinet	1909	1391	0.43956043956043955
108	108	cabinet	1909	1458	1.0
109	109	cabinet	1909	1468	1.0
110	110	cabinet	1910	1002	0.3241758241758242
111	111	cabinet	1910	1003	0.6758241758241759
112	112	cabinet	1910	1323	1.0
113	113	cabinet	1910	1360	0.49175824175824173
114	114	cabinet	1910	1361	0.5082417582417582
115	115	cabinet	1910	1372	0.3873626373626374
116	116	cabinet	1910	1377	0.6126373626373627
117	117	cabinet	1910	1383	0.9120879120879121
118	118	cabinet	1910	1386	0.08791208791208792
119	119	cabinet	1910	1391	0.3489010989010989
120	120	cabinet	1910	1392	0.15934065934065933
121	121	cabinet	1910	1412	0.49175824175824173
122	122	cabinet	1910	1458	1.0
123	123	cabinet	1910	1468	1.0
124	124	cabinet	1911	1003	1.0
125	125	cabinet	1911	1171	0.22527472527472528
126	126	cabinet	1911	1285	0.5384615384615384
127	127	cabinet	1911	1323	0.967032967032967
128	128	cabinet	1911	1324	0.03296703296703297
129	129	cabinet	1911	1360	1.0
130	130	cabinet	1911	1370	0.23351648351648352
131	131	cabinet	1911	1377	0.46153846153846156
132	132	cabinet	1911	1383	1.0
133	133	cabinet	1911	1392	0.16483516483516483
134	134	cabinet	1911	1393	0.32142857142857145
135	135	cabinet	1911	1394	0.5137362637362637
136	136	cabinet	1911	1458	0.9532967032967034
137	137	cabinet	1911	1459	0.046703296703296704
138	138	cabinet	1911	1468	0.7747252747252747
139	139	cabinet	1912	1003	1.0
140	140	cabinet	1912	1171	1.0
141	141	cabinet	1912	1284	0.5808219178082191
142	142	cabinet	1912	1285	0.4191780821917808
143	143	cabinet	1912	1310	0.31232876712328766
144	144	cabinet	1912	1311	0.4767123287671233
145	145	cabinet	1912	1324	0.21095890410958903
146	146	cabinet	1912	1360	1.0
147	147	cabinet	1912	1370	1.0
148	148	cabinet	1912	1383	0.136986301369863
149	149	cabinet	1912	1384	0.863013698630137
150	150	cabinet	1912	1394	0.03561643835616438
151	151	cabinet	1912	1395	0.9643835616438357
152	152	cabinet	1912	1459	1.0
153	153	cabinet	1913	1003	0.47802197802197804
154	154	cabinet	1913	1004	0.521978021978022
155	155	cabinet	1913	1171	1.0
156	156	cabinet	1913	1240	0.9175824175824175
157	157	cabinet	1913	1253	0.5302197802197802
158	158	cabinet	1913	1284	1.0
159	159	cabinet	1913	1311	1.0
160	160	cabinet	1913	1360	0.4697802197802198
161	161	cabinet	1913	1370	1.0
162	162	cabinet	1913	1384	0.08241758241758242
163	163	cabinet	1913	1395	0.054945054945054944
164	164	cabinet	1913	1396	0.16483516483516483
165	165	cabinet	1913	1397	0.7554945054945055
166	166	cabinet	1913	1398	0.024725274725274724
167	167	cabinet	1913	1459	1.0
168	168	cabinet	1914	1004	0.7115384615384616
169	169	cabinet	1914	1005	0.28846153846153844
170	170	cabinet	1914	1171	1.0
171	171	cabinet	1914	1240	1.0
172	172	cabinet	1914	1253	1.0
173	173	cabinet	1914	1283	0.6071428571428571
174	174	cabinet	1914	1284	0.39285714285714285
175	175	cabinet	1914	1311	0.8653846153846154
176	176	cabinet	1914	1320	0.1346153846153846
177	177	cabinet	1914	1369	0.5714285714285714
178	178	cabinet	1914	1370	0.12912087912087913
179	179	cabinet	1914	1371	0.29945054945054944
180	180	cabinet	1914	1398	0.4368131868131868
181	181	cabinet	1914	1399	0.01098901098901099
182	182	cabinet	1914	1400	0.2032967032967033
183	183	cabinet	1914	1401	0.3489010989010989
184	184	cabinet	1914	1459	0.8159340659340659
185	185	cabinet	1914	1465	0.18406593406593408
186	186	cabinet	1915	1005	0.8214285714285714
187	187	cabinet	1915	1006	0.17857142857142858
188	188	cabinet	1915	1171	1.0
189	189	cabinet	1915	1239	0.19505494505494506
190	190	cabinet	1915	1240	0.804945054945055
191	191	cabinet	1915	1252	0.6538461538461539
192	192	cabinet	1915	1253	0.34615384615384615
193	193	cabinet	1915	1283	1.0
194	194	cabinet	1915	1320	1.0
195	195	cabinet	1915	1371	1.0
196	196	cabinet	1915	1401	0.8269230769230769
197	197	cabinet	1915	1402	0.17307692307692307
198	198	cabinet	1915	1465	1.0
199	199	cabinet	1916	1006	0.8712328767123287
200	200	cabinet	1916	1007	0.12876712328767123

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE `viewcalc_country_year_share` (
  `id_type` TEXT,
  `year` INTEGER,
  `id` INTEGER,
  `share` REAL
);