home / fivethirtyeight

Menu
  • GraphQL API

fivethirtyeight

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

Custom SQL query returning 32 rows (hide)

This data as json, copyable, CSV

rowidcountrycountry_idgroupspispi_offensespi_defensewin_groupsixteenquartersemicupwin
1 Algeria ALG h 64.31 1.1809 1.1672 0.0229 0.1528 0.021027220390059 0.004370765264809 0.000576713049575 8.1558122314e-05
2 Argentina ARG f 89.87 2.8229 0.4464 0.9036 0.9828 0.700138705617966 0.498182542514243 0.31593899890557 0.146763028823941
3 Australia AUS b 68.89 1.6481 1.2794 0.0 0.0031 0.000298875536712 7.4184948286e-05 1.2837946625e-05 2.312028276e-06
4 Belgium BEL h 81.76 2.1436 0.762 0.6521 0.8721 0.410505784126377 0.156824922013106 0.063683091738654 0.017693526680745
5 Bosnia and Herzegovina BIH f 80.6 2.3292 0.9776 0.04 0.5605 0.235649592100379 0.082652280270877 0.02256475885638 0.007609909688095
6 Brazil BRA a 90.87 3.17 0.531 0.921 0.995 0.753314517373174 0.613087485929048 0.452676706240401 0.34630042703384
7 Chile CHI b 86.81 2.7213 0.703 0.2664 0.776 0.322796454740158 0.20155149912042 0.102673537441406 0.043512901858137
8 Ivory Coast CIV c 79.16 2.213 1.0064 0.2266 0.7899 0.397734733010506 0.127661647001768 0.045403819435021 0.011161314997554
9 Cameroon CMR a 70.21 1.3672 0.9711 0.0044 0.0129 0.002627043704899 0.000843555164696 0.000191164595593 3.1757934521e-05
10 Colombia COL c 87.62 2.3867 0.4172 0.7524 0.9632 0.638209451165489 0.239628231371838 0.119410469642296 0.055347528912563
11 Costa Rica CRC d 77.5 1.5935 0.6832 0.4089 0.7217 0.287676524298726 0.078460906671701 0.024852880804847 0.005589829700293
12 Croatia CRO a 76.23 1.8127 0.9277 0.0162 0.1781 0.04850115088135 0.020497731176444 0.006280986340508 0.001180379654884
13 Ecuador ECU e 79.87 1.9878 0.7975 0.0358 0.2062 0.067444756323972 0.029648299873543 0.011024488071069 0.002756171669223
14 England ENG d 82.22 2.1666 0.742 0.0907 0.3224 0.148709405612397 0.043825585936929 0.017075895865959 0.005635600752756
15 Spain ESP b 86.76 2.6117 0.6396 0.0037 0.2226 0.061579656635719 0.035585433813723 0.017025559282279 0.008243812601831
16 France FRA e 86.92 2.5397 0.5798 0.6927 0.9212 0.560748809249763 0.276456012338045 0.113159985467084 0.051657637657079
17 Germany GER g 90.09 3.2839 0.6908 0.881 0.9826 0.800623274479749 0.552710638765162 0.274523270945022 0.16876841491392
18 Ghana GHA g 76.42 1.8491 0.9418 0.0049 0.1032 0.046740032211347 0.0135608189932 0.004602440395653 0.000904828543633
19 Greece GRE c 74.2 1.2966 0.6725 0.0104 0.144 0.058773528515287 0.01636031312176 0.004525160627554 0.000775242098635
20 Honduras HON e 68.16 1.508 1.2109 0.0058 0.0685 0.011711892565236 0.003439637451417 0.000813314362142 0.00010254550469
21 Iran IRN f 70.82 1.1905 0.7931 0.0219 0.1885 0.050278621529754 0.011008099527739 0.001896875572426 0.000359656574617
22 Italy ITA d 80.19 2.0408 0.8109 0.4406 0.7458 0.335996861835106 0.107469016416378 0.039077687987255 0.010188461646103
23 Japan JPN c 73.07 2.0699 1.334 0.0106 0.1029 0.040150978526725 0.010070867675947 0.002608302112807 0.000404004174554
24 South Korea KOR h 72.44 1.6875 1.0839 0.1271 0.4091 0.092030359057277 0.024067022874219 0.005001613959496 0.000902819017832
25 Mexico MEX a 78.6 1.4824 0.5291 0.0584 0.814 0.243506161666402 0.109374474647175 0.036430722206383 0.007651192924114
26 Netherlands NED b 86.87 2.8048 0.7484 0.7299 0.9983 0.567376139461621 0.369573974801907 0.194446213570591 0.075964188008969
27 Nigeria NGA f 74.94 1.5518 0.8196 0.0345 0.2682 0.087103324347998 0.023458026121861 0.00500806340576 0.001169299701613
28 Portugal POR g 78.86 2.0416 0.9083 0.009 0.2359 0.116866939311736 0.038082292774974 0.014514558182523 0.003282586035377
29 Russia RUS h 78.28 1.6108 0.6428 0.1979 0.566 0.174947496476308 0.059470010573821 0.016570918213655 0.004136567192528
30 Switzerland SUI e 79.35 2.074 0.8956 0.2657 0.8041 0.286924298264958 0.114840186957911 0.038744140397878 0.009912132414606
31 Uruguay URU d 80.88 2.193 0.8631 0.0598 0.2101 0.092748517035733 0.025935092201975 0.009670998865268 0.003030836555616
32 USA USA g 78.49 2.1028 0.9782 0.1051 0.6783 0.337258893947086 0.11122844368505 0.039013825512317 0.008879526577138
Powered by Datasette · Queries took 1.499ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette