fivethirtyeight

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

This data as json, copyable, CSV

rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
1	Algeria	ALG	h	63.36	1.1191	1.1659	0.0572	0.2011	0.037598887698821	0.007784490409786	0.000960294827678	0.000123459942526
2	Argentina	ARG	f	90.0	2.8521	0.4498	0.7335	0.9209	0.662520141639225	0.461392282637745	0.283216416982212	0.130879647357264
3	Australia	AUS	b	69.04	1.6546	1.2727	0.0017	0.0177	0.001560015567208	0.00044555729625	9.4428772429e-05	1.4426893535e-05
4	Belgium	BEL	h	82.06	2.1405	0.7355	0.4959	0.7854	0.358667740662492	0.152204670838105	0.057301179712534	0.016179237405706
5	Bosnia and Herzegovina	BIH	f	80.23	2.3098	0.9905	0.1642	0.574	0.26874938737868	0.114896369849656	0.032989749806058	0.009481814336275
6	Brazil	BRA	a	91.63	3.3847	0.5572	0.9689	0.9985	0.790793049136349	0.66249216017071	0.535917984538475	0.429803814982014
7	Chile	CHI	b	86.79	2.7203	0.7033	0.3026	0.773	0.320302708358745	0.202418176241842	0.108908494097964	0.043698544435827
8	Ivory Coast	CIV	c	79.17	2.2141	1.0043	0.2227	0.7952	0.401877896883583	0.128634848220148	0.047935824675925	0.01124409321598
9	Cameroon	CMR	a	70.05	1.3531	0.9672	0.0004	0.0332	0.006599711876393	0.002218210582229	0.000532340428649	6.9930565999e-05
10	Colombia	COL	c	87.69	2.3949	0.4158	0.758	0.9641	0.640124350537793	0.219328658405039	0.118595774707873	0.054966349323482
11	Costa Rica	CRC	d	77.48	1.5852	0.6767	0.4091	0.7195	0.285536903230013	0.076686460176757	0.025785679861343	0.005532621481122
12	Croatia	CRO	a	76.22	1.8052	0.9215	0.0023	0.3793	0.103323169876281	0.044303794964945	0.014100768085761	0.002512051495659
13	Ecuador	ECU	e	80.8	2.0274	0.7549	0.2373	0.5623	0.232782669664075	0.102791764052184	0.033818892565163	0.009312020053874
14	England	ENG	d	82.21	2.1617	0.7381	0.0842	0.3228	0.146428377897102	0.039162217538005	0.016599455534634	0.005442438036593
15	Spain	ESP	b	86.78	2.6112	0.6368	0.0292	0.2508	0.06869215611347	0.040860525023039	0.021744159198933	0.00989038578156
16	France	FRA	e	86.13	2.4866	0.6193	0.5281	0.7899	0.446932662591163	0.243424466062159	0.091385307268714	0.038308154906802
17	Germany	GER	g	88.87	3.1972	0.7786	0.6627	0.8742	0.676984893445781	0.444575332121496	0.199217882705092	0.109782046624266
18	Ghana	GHA	g	77.38	1.9044	0.9135	0.0885	0.309	0.151570853391284	0.052530446274753	0.015891783497206	0.003393687271548
19	Greece	GRE	c	74.29	1.2891	0.6597	0.0094	0.1444	0.059057246276846	0.016811992435881	0.004857049294712	0.000790324885123
20	Honduras	HON	e	70.01	1.5756	1.1482	0.0569	0.2008	0.050004520629352	0.014818548717965	0.00325954901246	0.000472875107405
21	Iran	IRN	f	70.6	1.2971	0.8897	0.0354	0.1876	0.056641734644481	0.015335831471601	0.002428390291814	0.000439025782836
22	Italy	ITA	d	80.14	2.036	0.8097	0.4483	0.7475	0.336809322559795	0.105950694724692	0.040365076028128	0.01003918854591
23	Japan	JPN	c	73.13	2.0751	1.3309	0.0099	0.0963	0.037719111035921	0.009878204043086	0.002730955747414	0.0003992761189
24	South Korea	KOR	h	72.42	1.6883	1.0835	0.1424	0.3826	0.10176215345634	0.02875225661197	0.005493943192592	0.000975369363159
25	Mexico	MEX	a	77.77	1.5407	0.6249	0.0284	0.589	0.170455241590639	0.075206381812192	0.025327771144111	0.00483322686652
26	Netherlands	NED	b	86.92	2.8119	0.747	0.6665	0.9585	0.538273947480935	0.351766532060416	0.191517311088176	0.071686046907022
27	Nigeria	NGA	f	75.07	1.6598	0.8902	0.0669	0.3175	0.117477667814105	0.038906196350013	0.007872757571403	0.001779557057987
28	Portugal	POR	g	80.99	2.1415	0.8184	0.1532	0.4728	0.264878953388448	0.108980075262669	0.038585438278017	0.01027620888747
29	Russia	RUS	h	78.98	1.6544	0.625	0.3045	0.6309	0.23599983764316	0.087093523048574	0.024834288698619	0.006021521670105
30	Switzerland	SUI	e	78.03	1.9791	0.9216	0.1777	0.447	0.164891215638916	0.065903768023967	0.019197644045427	0.004517527374769
31	Uruguay	URU	d	80.89	2.194	0.8617	0.0584	0.2102	0.092446791578924	0.023835586304788	0.009683208319223	0.002991854636353
32	USA	USA	g	77.76	2.0627	1.0004	0.0956	0.344	0.17253668031371	0.060609978267342	0.018850200021257	0.004143272686408

fivethirtyeight

Custom SQL query returning 32 rows (hide)