parlgov: viewcalc_country_year

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

9,069 rows

descending

Link	rowid ▼	id_type	year	id	share
1	1	cabinet	1900	1374	0.5989010989010989
2	2	cabinet	1900	1466	0.14835164835164835
3	3	cabinet	1900	1476	0.5027472527472527
4	4	cabinet	1901	996	0.7582417582417582
5	5	cabinet	1901	1365	0.43956043956043955
6	6	cabinet	1901	1374	1.0
7	7	cabinet	1901	1466	1.0
8	8	cabinet	1901	1476	1.0
9	9	cabinet	1901	1479	0.3076923076923077
10	10	cabinet	1902	996	1.0
11	11	cabinet	1902	1325	0.0989010989010989
12	12	cabinet	1902	1365	1.0
13	13	cabinet	1902	1374	0.3956043956043956
14	14	cabinet	1902	1376	0.6043956043956044
15	15	cabinet	1902	1378	0.6978021978021978
16	16	cabinet	1902	1387	0.5686813186813187
17	17	cabinet	1902	1456	0.054945054945054944
18	18	cabinet	1902	1466	1.0
19	19	cabinet	1902	1476	0.3021978021978022
20	20	cabinet	1903	996	0.7307692307692307
21	21	cabinet	1903	997	0.2692307692307692
22	22	cabinet	1903	1325	1.0
23	23	cabinet	1903	1365	0.45604395604395603
24	24	cabinet	1903	1366	0.5439560439560439
25	25	cabinet	1903	1376	1.0
26	26	cabinet	1903	1378	0.8076923076923077
27	27	cabinet	1903	1379	0.19230769230769232
28	28	cabinet	1903	1387	1.0
29	29	cabinet	1903	1456	1.0
30	30	cabinet	1903	1466	1.0
31	31	cabinet	1904	997	0.32054794520547947
32	32	cabinet	1904	998	0.3095890410958904
33	33	cabinet	1904	999	0.3698630136986301
34	34	cabinet	1904	1325	1.0
35	35	cabinet	1904	1366	1.0
36	36	cabinet	1904	1376	1.0
37	37	cabinet	1904	1379	1.0
38	38	cabinet	1904	1387	1.0
39	39	cabinet	1904	1456	1.0
40	40	cabinet	1904	1466	0.8410958904109589
41	41	cabinet	1904	1467	0.1589041095890411
42	42	cabinet	1905	999	0.5082417582417582
43	43	cabinet	1905	1000	0.49175824175824173
44	44	cabinet	1905	1325	0.9313186813186813
45	45	cabinet	1905	1326	0.06868131868131869
46	46	cabinet	1905	1364	0.9642857142857143
47	47	cabinet	1905	1366	0.03571428571428571
48	48	cabinet	1905	1376	1.0
49	49	cabinet	1905	1379	0.18956043956043955
50	50	cabinet	1905	1380	0.8104395604395604
51	51	cabinet	1905	1387	0.06318681318681318
52	52	cabinet	1905	1388	0.9368131868131868
53	53	cabinet	1905	1456	0.8269230769230769
54	54	cabinet	1905	1457	0.17307692307692307
55	55	cabinet	1905	1467	1.0
56	56	cabinet	1906	1000	1.0
57	57	cabinet	1906	1308	0.12637362637362637
58	58	cabinet	1906	1309	0.40384615384615385
59	59	cabinet	1906	1326	0.4697802197802198
60	60	cabinet	1906	1364	0.4065934065934066
61	61	cabinet	1906	1367	0.5934065934065934
62	62	cabinet	1906	1375	0.5989010989010989
63	63	cabinet	1906	1376	0.4010989010989011
64	64	cabinet	1906	1380	0.6538461538461539
65	65	cabinet	1906	1385	0.34615384615384615
66	66	cabinet	1906	1388	0.1978021978021978
67	67	cabinet	1906	1390	0.18406593406593408
68	68	cabinet	1906	1409	0.18406593406593408
69	69	cabinet	1906	1411	0.4340659340659341
70	70	cabinet	1906	1457	1.0
71	71	cabinet	1906	1467	1.0
72	72	cabinet	1907	1000	1.0
73	73	cabinet	1907	1309	1.0
74	74	cabinet	1907	1367	1.0
75	75	cabinet	1907	1373	0.0
76	76	cabinet	1907	1375	1.0
77	77	cabinet	1907	1381	0.18956043956043955
78	78	cabinet	1907	1385	0.8104395604395604
79	79	cabinet	1907	1390	1.0
80	80	cabinet	1907	1457	1.0
81	81	cabinet	1907	1467	1.0
82	82	cabinet	1908	1000	0.8684931506849315
83	83	cabinet	1908	1001	0.13150684931506848
84	84	cabinet	1908	1309	0.9671232876712329
85	85	cabinet	1908	1323	0.03287671232876712
86	86	cabinet	1908	1363	0.2191780821917808
87	87	cabinet	1908	1367	0.7808219178082192
88	88	cabinet	1908	1372	0.9780821917808219
89	89	cabinet	1908	1373	0.021917808219178082
90	90	cabinet	1908	1381	0.21095890410958903
91	91	cabinet	1908	1382	0.7890410958904109
92	92	cabinet	1908	1390	1.0
93	93	cabinet	1908	1457	0.8164383561643835
94	94	cabinet	1908	1458	0.18356164383561643
95	95	cabinet	1908	1467	0.8191780821917808
96	96	cabinet	1908	1468	0.18082191780821918
97	97	cabinet	1909	1001	0.4175824175824176
98	98	cabinet	1909	1002	0.5824175824175825
99	99	cabinet	1909	1323	1.0
100	100	cabinet	1909	1361	0.17582417582417584

Advanced export

JSON shape: default, array, newline-delimited

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