{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["1A","1B","1C","1D","1E","1F","1G"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1A","index":0,"n_rows":55,"n_cols":24,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Supplementary Table 1A. Descriptive statistics and alcohol consumption assessment in participating cohorts"]
["Cohort name","N (% women)","Age in years (SD), women","Age in years (SD), men","Mean BMI (SD), women","Mean BMI (SD), men","Period of alcohol consumption","Alcohol drinking assessment","Information collection","Definitoin of alcohol consumption frequency","Definition of a drink","Alcohol quantity assessment","Number of drinks calculation (NA if not on categorical scale)","Ethanol gms calculation","N (including non-drinkers) with nonmissing covariates ","N (only drinkers) with nonmissing covariates ","% drinkers in entire sample","% drinkers in males","% drinkers in females","Arithmetic mean (SD) alcohol intake in female drinkers g/day ","Arithmetic mean (SD) alcohol intake in male drinkers g/day ","Median (q1,q3) of alcohol intake in g/day in male drinkers","Median (q1,q3) of alcohol intake in g/day in female drinkers","Comments"]
["AGES (Iceland)","2,093 (53.7) ","75.6 (5.4)","76.2 (5.2)","27.1 (4.6)","27.0 (3.7)  ","Lifetime","Questionnaire","Self-reported","Question on frequency of drinking","14g of alcohol","Number of drinks, (1,2,3,4+)","Derived number times drinking * number of drinks per drinking","14g per drink",3129,2093,0.36299999999999999,0.71699999999999997,0.60199999999999998,"1.2 (1.9)","2.2 (3.4)","2.3 (0.69, 4.71)","0.91 (0.23, 2.3)"]
["Airwave (UK)","12,930 (36.4)","39.1 (9.2)","41.8 (8.7)","26.0 (4.6)","28.0 (3.7)","Last 7 days","Questionnaire","Interview","Weekly typical intake","Wines in small glasses (125ml), beer in pints, spirits in pub measures","Number of drinks separately for red wine, white wine/champagne, fortified wine, spirits and beer","NA","1 beer = 12 oz (360 ml) = 13.9 gm ETOH, 1 glass wine = 5 oz (150 ml) = 15 gm ETOH, 1 drink of spirits = 1.5 oz (45 ml) of 80 proof (40%) alcohol = 14 gm ETOH",12930,11480,0.88800000000000001,0.90600000000000003,0.85699999999999998,"12.7 (11.7)","21.3 (18.4)","16.5 (7.7, 30.0)","9.4 (4.0, 17.9)"]
["ARIC (USA)","4,106 (41.5) ","53.4 (5.6)","54.4 (5.7)","25.4 (4.6)","27.4 (3.9)","Last year","Questionnaire","Interveiw","Weekly","12 oz of beer, 4 oz of wine, or 1.5 oz of liquor","Separate number of beer, wine and spirit","NA","One beer ~13.2gm, one glass of wine ~ 10.8 gm, one drink of spirit ~ 15.1 gm ethanol",6356,4106,0.64599999999999991,0.64600000000000002,0.48599999999999999,"10.1 (9.8)","18.6 (19.6)","11.8 (5.7, 24.4)","6.8 (3.7, 13.0)"]
["ASPS (Austria)","470 (56.7)","65.8 (8.2)","64.6 (7.7)","26.6 (4.6)","27.0 (3.2)","Current","Questionnaire","Interview","Daily typical intake","500 ml of beer, 250 ml of wine, centiliter of liquor","Seperate number of beer, wine and spirit","NA","1 beer~ 19.3gm, 1 glass of wine~25 gm, one drink of spirit~3.11 gm",829,277,0.33399999999999996,0.501,0.20599999999999999,"16.9 (13.6)","31.5 (19.5)","25.0 (19.3,44.3)","19.3 (3.6, 25.0)"]
["B58C (UK)","3,807 (43.6)","45.2 (0.4)","45.2 (0.4)","26.9 (5.5)","27.9 (4.3)","Last 12 months (but analysis excluded respondents who drank once a week or less often on average, so effectively the measure is of current intake","Questionnaire","Self-reported","How many standard drinks on a typical day (1-2, 3-4, 5-6, 7-9, 10+) among respondents drinking more than once a week on average in the last 12 months","Half-pint of beer, small glass of wine, one shot of liquor","How many standard drinks on a typical day (1-2, 3-4, 5-6, 7-9,10+)","Above categories scored as 1.5, 3.5, 5.5, 8, 12. Number of times per week scored as 2.5 (2-3 times a week), or 5.5 (4+ times a week)","15g per standard drink","6,469 total (with GWAS and drink frequency)","3,807 (drank more than once a week on average in the past 12 months)",0.58899999999999997,0.66700000000000004,0.51100000000000001," 23.6 (19.3)"," 38.4 (30.8)","29.5 (17.7, 42.9)","17.7 (8.0, 29.5)","Cohort were all aged 44-45 years at the time of this ascertainment of alcohol consumption. Note that the \"non-drinkers\" include many who drank infrequently (once a week or less in the past 12 months). Only 395 of the 6469 had not drunk alcohol at all in the past year."]
["CHS (USA)","3,009 (62.5) ","71.9 (5.2)","73.0 (5.6)","26.3 (4.9)","26.3 (3.4)","Current","Questionnaire","Interview","Offered as daily, weekly, monthly, yearly, rarely","12 oz of beer, 6 oz of wine, 1 shot of liquor","Separate number of beer, wine, and liquor on one occasion","NA","14 gm per drink",3243,1752,0.58200000000000007,0.61060000000000003,0.49519999999999997,"7.6 (12.8)","13.4 (19.7)","4.5 (1.0, 16.5)","2.0 (0.5, 8.0)"]
["Colaus (Switzerland)","5,435 (52.9)","53.9 (10.7)","52.9 (10.8)","25.2 (4.9)","26.6 (4.0)","Last 7 days","Questionnaire","Self-reported","Consumption last seven days","Bottles of beer / glasses of wine / shots of spirits","Number of alcoholic drinks","NA","one bottle of beer=13.9 gm; one glass of wine=15 gm; one shot of spirit=14 gm",5406,3943,0.188,0.84,0.63100000000000001,"22.0 (8.4)","34.6 (13.0)","20.6 (10.4, 35.3)","10.4 (6.1, 16.8)"]
["DESIR (France)","317 (60.9)","48.5 (8.6)","52.6 (5.6)","21.5 (1.8)","23.2 (1.2)","NA","Questionnaire","Self-reported","Daily and weekly intake","NA","Separate categorical scales of beer/cider, wine per day; number of spirits/aperitifs per week","NA","NA",317,47,0.14800000000000002,0.22600000000000001,9.8000000000000004E-2,"1.2 (0.5)","14.9 (9.0)","67.5 (62, 74.75)","31 (31, 34)"]
["EGCUT (Estonia)","6,954 (51.1)","46.6 (19.7)","48.2 (19.7)","26.2 (5.7)","26.5 (4.6)","Last Year","Questionnaire","Interview","Typical intake per day, per week, per month or per year.","0.5l of beer, 100ml of wine, 40ml of Fortified wine, vermouth and liqueur (alcohol at 20% vol) or 40ml of fortified alcoholic drinks","Separate number of beer, wine, liqueur and spirit","NA","One beer ~15gm, wine~6,7gm, liqueur~1,1gm, spirit~1,1gm",7987,6032,0.84900000000000009,0.82799999999999996,0.69699999999999995,"2.48 (6.7)","10.4 (16.0)","4.0 (1.2; 9.7)","0.7 (0.2; 1.9)"]
["EPIC-Norfolk","1,717 (49.4)","58.0 (8.8)","59.9 (9.1)","26.1 (4.2)","26.6 (3.1)","Current at baseline health check","FFQ","Self-reported","Daily typical intake","units","Number of alcoholic drinks","NA","1 unit=10 gram",2336,1987,0.83799999999999997,0.90900000000000003,0.79900000000000004,"6.0 (8.0)","11.8 (15.4)","7.4 (2.8, 13.5)","4.1 (1.5, 8.2)"]
["ERF (Netherlands)","1,425 (35.7)","48.3 (14.5)","49.6 (14.2)","26.4 (4.7)","27.1 (3.9)","lifetime","Questionnaire","Interview","Weekly intake","glass","number of alcohlic drinks","NA","Number of glasses per week* 10 =grams/week; Grams/day = grams/week / 7",1353,1040,0.67700000000000005,0.86,0.66200000000000003,"11.4 (61.8)","23.6 (96.1)","11.4 (5.7, 21.4)","5.7 (2.9, 10.0)"]
["Fenland (UK)","948 (55.5)","44.8 (7.3)","44.4 (7.5)","26.3 (5.3)","27.5 (4.0)","Not specified","Questionnaire","Self-reported","Weekly typical intake","1/2 pint of beer, 1 glass of wine, 1 single measure of spirits, 1 glass of fortified wine","sum of the products of frequency and the specified amount of each alcohol beverage","NA","1 unit = 8g of ethanol",1099,948,0.86299999999999999,0.91400000000000003,0.82099999999999995,"9.1 (9.6)","14.2 (14.7)","8.5 (4.9, 16.2)","5.9 (2.3, 11.2)"]
["FHS (USA)","8,955 (52.1) ","37.4 (9.9)","38.3 (10.1)","24.9 (5.3)","27.2 (4.2)","Drinks per week on average over course of last year","Questinnaire","Self-reported","Weekly typical intake then coverted to average daily intake","12 oz of beer, 5 oz of wine and 1.5 oz of spirit","Number of alcoholic drinks per week","NA","one beer (12 oz) ~14 gm ethanol, or one glass of wine (5 oz) ~ 15 gm ethanol, or one drink of spirit (1.5 oz 80 proof alcohol) ~ 14 gm ethanol",6993,6139,0.8640000000000001,0.878,0.80500000000000005,"9.8 (11.5)","22.1(24.3)","14 (6, 28)","6 (2.3, 12)"]
["FinnTwin12 (Finland)","590 (44.2)","22.4 (0.7)","22.5 (0.7)","23.2 (4.2)","24.0 (3.5)","Last 6 months","Questionnaire","Interview","Questionnaires assessed average weekly consumption of beer (as bottles) and wine (as glasses) and monthly consumption of spirits (as bottles)","One drink was defined as a 330-ml bottle of beer, a 12-cl glass of wine or a 4-cl portion of spirits","Quantity of alcohol was assessed using continuous measures of beer, wine and spirits","NA","One drink (a 330-ml bottle of beer, a 12-cl glass of wine or a 4-cl portion of spirits) estimated to include 12 g of pure alcohol",590,586,0.495,"~100%",0.99,"10.4 (8.3)","22.2 (18.7)","18.86 (8.57, 28.50)","8.57 (3.86, 13.71)"]
["FinnTwinOld_1 (Finland)","914 (37.3)","43.0 (9.2)","40.5 (9.1)","24.1 (4.1)","25.2 (3.3)","A 12 month period of lifetime usage when alcohol consumption was most frequent","Questionnaire","Interview","Questionnaires assessed average weekly consumption of beer (as bottles) and wine (as glasses) and monthly consumption of spirits (as bottles)","One drink was defined as a 330-ml bottle of beer, a 12-cl glass of wine or a 4-cl portion of spirits","Quantity of alcohol was assessed using separate categorical scales of beer, wine and spirits","Class midpoints (medians) of the categories","One drink (a 330-ml bottle of beer, a 12-cl glass of wine or a 4-cl portion of spirits) estimated to include 12 g of pure alcohol",906,888,0.81599999999999995,0.626,0.374,"9.5 (13.4)","20.7 (27.0)","11.48 (6.79, 22.41)","5.80 (3.36, 10.54)"]
["FinnTwinOld_2 (Finland)","110 (100)","50.6 (11.3)","NA","25.8 (4.0)","NA","-","-","-","-","-","-","-","-","-","-",1,"-","-","11.8 (18.4)","NA","-","-"]
["FinnTwinOld_3 (Finland)","166 (100)","50.6 (11.3)","NA","NA*","NA","-","-","-","-","-","-","-","-","-","-",0.80799999999999994,"-","-"," 5.4 (7.5)","NA","-","-"]
["FTC_replication (Finland)","2,077 (53.5)","32.3 (14.7)","32.6 (15.0)","23.6 (4.1)","24.8 (3.9)","(see comments)","-","-","-","-","-","-","-",2077,2077,1,0.46500000000000002,0.53500000000000003,"10.6 (15.5)","23.7 (29.3)","17.14 (6.86, 29.14)","6.86 (3.00, 12.86)","Sample used for replication consists of subjects from the Older Finnish Twin Cohort and the Younger Finnish Twin Cohorts (non-overlapping with the discovery sample). Please see cohort descriptions of the discovery samples (FinnTwinOld and FinnTwin12)."]
["GRAPHIC (UK)","1,017 (50.0)","51.9 (4.4)","53.8 (4.2)","27.1 (4.6)","27.8 (3.9)","Current","Questionnaire","Interview","Weekly typical intake","Pints or Glasses converted to grams per week","Separate number of beer, wine and spirit","NA","1 beer = 12 oz = 13.9 gm ETOH.  1 glass wine = 5 oz = 15 gm ETOH. 1 drink of spirits = 1.5 oz = 14 gm ETOH",1007,"NA","81.2%   (\"heavy\" was 20.9%)",0.86499999999999999,0.76300000000000001,"10.9 (9.6)","19.7 (16.6)","16 (8.3, 25.1)","8 (4.6, 14.3)"]
["GS:SFHS (Scotland)","5,786 (58.7)","51.9 (13.5)","52.4 (13.9)","26.8 (5.6)","27.1 (4.3)","Past week","Questionnaire","Self-reported","Weekly typical intake","Calculate units using a guideline that states the typical units found in various drinks, pint of beer, glass of wine etc. In a later version of the questionnaire participants were asked how many of each kind of drink they had per week, glass of wine, pint of beer etc. and researchers calculated units from this measure.","(See drink definition)","NA","One unit = 7.9g ethanol",9860,"7,233 (excluding people who were current drinkers but reported 0 consumption in the previous week)","87.6% (current); 94.3% (current and former)",0.80100000000000005,0.68600000000000005,"11.9 (10.3)","22.9 (18.02)","18.05 (10.15, 31.6)","10.15 (4.51, 15.8)"]
["HBCS (Finland)","1,709 (57)","61.6 (3.1)","61.4 (2.8)","27.8 (5.1)","27.6 (4.3)","Last year","FFQ","Self-reported","Nine responses ranging from never to more than six times per day.","NA","Frequency responses were given to seven types of alcoholic drinks: a) glass of light beer, b) bottle (3,3dl) of normal beer, c) bottle (3,3 dl) of cider, d) glass (12cl) of red wine, e) glass (12cl) of white wine, f) 4 cl of liquor or fortified wine, g) spirits (4 cl).","NA","Amount of alcohol drunk (g/day) was calculated based on the responses on FFQ and Finnish food composition database",1664,1418,0.97799999999999998,0.89500000000000002,0.82,"5.1 (7.1)","14.6 (18.4)","10.97 (5.25, 19.71)","3.68 (1.75, 8.15)"]
["Health ABC (USA)","965 (42.7) ","73.5 (2.7)","73.7 (2.8)","25.9 (4.4)","27.1 (3.7)","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",0.6,"NA","NA","3.2 (3.9)","5.2 (6.1)","NA","NA"]
["INGI_CARL (Italy)","428 (61.9)","49.5 (16.5)","49.8 (16.5)","27.3 (5.8)","33.4 (40.2)","Current","Questionnaire","Interview","Daily typical intake","400ml of beer, 150ml of wine, 50 ml of liquor","Separate number of beer, wine and spirit","NA","One beer 14.5 gm, one glass of wine 15 gm, one drink of spirit 13 gm ethanol",477,169,0.39400000000000002,0.65700000000000003,0.34300000000000003,"22.0 (13.3)","50.6 (39.7)","38.5 (24.0, 64.2)","24.0 (12.0, 24.0)"]
["INGI_FVG (Italy)","902 (57.6)","52.9 (15.6)","53.7 (5.8)","24.6 (4.6)","26.7 (3.9)","Current","Questionnaire","Interview","Daily typical intake","400ml of beer, 150ml of wine, 50 ml of liquor","Separate number of beer, wine and spirit","NA","One beer 14.5 gm, one glass of wine 15 gm, one drink of spirit 13 gm ethanol",1008,656,0.65600000000000003,0.54100000000000004,0.45900000000000002,"12.8 (14.6)","30.0 (27.4)","24.0 (8.10, 43.48)","12.0 (2.65, 15.70)"]
["INGI_VB (Italy)","1,785 (55.8)","55.1 (18.3)","55.1 (17.6)","25.4 (5.2)","26.6 (4.0)","current and lifetime","Questionnaire","interview","Daily","1 beer = 360 ml, 1 glass of wine = 150 ml, 1 drink of spirits = 10 ml","Separate ml of beer, wine and spirit","Was measured in ml (in multiple of 25 ml)","1 beer ~14 gm, 1 glass of wine ~15 gm, 1 drink of spirit ~13 gm",1785,900,0.50600000000000001,0.59299999999999997,0.40699999999999997,"16.3 (13.7)","37.9 (37.6)","24 (12.0, 48.0)","12 (6.0, 24.0)"]
["KORA F3 (Germany)","831 (50.1)"," 62.1 (10.7)","63.0 (10.1)","27.8 (5.6)","28.6 (4.6)","Last 7 days","Questionnaire","Interview","Participants were asked how much alcohol they had consumed on the last workday (except Friday) and during the previous weekend.","0.5 l (~16.9 oz) of beer, 0.2 l (~6.8 oz) of wine, 0.02 l (~0.68 oz) of distilled spirits, or 0.1 l (~3.4 oz) of alcoholic cocktail","Separately: standard beer in 0.5 l, low-alcohol beer in 0.5 l, alcohol-free beer in 0.5 l, wine in 0.2 l, distilled spirits in drinks, alcoholic cocktails in 0.1 l; study participants had to specify the consumed cocktail","NA","1 l beer = 40 g, 1 l low-alcohol beer = 22 g, 1 l alcohol-free beer = 3 g, 1 l wine = 100 g, 1 glass of distilled spirits (0.02 l) = 6.2 g; calculation for cocktails depended on the details given by the study participant. The weekday consumption was multiplied by five. This figure was added to the weekend consumption to obtain the alcohol consumption per week.",921,217,0.70399999999999996,0.78300000000000003,0.217,"12.4 (12.4)","28.4 (22.7)","58.3 (45.7, 65.7)","37.1 (33.2, 48.6)"]
["KORA F4 (Germany)","930 (51.3)"," 60.6 (8.8)","61.2 (8.9)","28.0 (5.2)","28.4 (4.3)","Last 7 days","Questionnaire","Interview","Participants were asked how much alcohol they had consumed on the next-to-last workday (except Friday) and during the previous weekend.","0.5 l (~16.9 oz) of beer, 0.2 l (~6.8 oz) of wine, 0.02 l (~0.68 oz) of distilled spirits, or 0.1 l (~3.4 oz) of alcoholic cocktail; ; study participants had to specify the consumed cocktail","Separately: standard beer in 0.5 l, low-alcohol beer in 0.5 l, alcohol-free beer in 0.5 l, wine in 0.2 l, distilled spirits in drinks, alcoholic cocktails in 0.1 l","NA","1 l beer = 40 g, 1 l low-alcohol beer = 22 g, 1 l alcohol-free beer = 3 g, 1 l wine = 100 g, 1 glass of distilled spirits (0.02 l) = 6.2 g; calculation for cocktails depended on the details given by the study participant. The weekday consumption was multiplied by five. This figure was added to the weekend consumption to obtain the alcohol consumption per week.",989,233,0.74299999999999999,0.72099999999999997,0.27900000000000003,"13.9 (13.5)","28.6 (23.9)","57.9 (48.6, 71.4)","40.0 (34.3, 45.7)"]
["LBC1921 (Scotland)","517 (58.4)","79.0 (0.57)","79.1 (0.58)","26.1 (4.5)","26.3 (3.5)","Current","Questionnaire","Interview","Units of alcohol consumed per week","2 units","Units of alcohol consumed per week","NA","2 units = 15.8g",516,390,0.754,0.81799999999999995,0.71199999999999997,"5.8 (8.3)","12.1 (16.6)","6.8 (1.1, 15.8)","2.3 (1.1,7.9)"]
["LBC1936 (Scotland)","1,005 (49.4)","69.6 (0.84)","69.5 (0.83)","27.6 (4.8)","28.0 (3.8)","Current","Questionnaire","Interview","Units of alcohol consumed per week","2 units","Units of alcohol consumed per week","NA","2 units =15.8g",1004,811,0.80800000000000005,0.876,0.73799999999999999,"9.34 (10.0)","18.2 (18.3)","13.5 (5.6, 23.7)","5.6 (1.7,14.7)"]
["Lifelines (Netherlands)","1680 (54.7)","55.5 (6.9)","52.0 (6.6)","NA","NA","last 30 days","Questionnaires","Self-reported","Daily typical intake","glass of alcohol: 250cc of beer, 100cc wine, 35cc of liquor","0=0 drinks, 1=1, 2=2,3=3,4=4,5=5,6=6,7=7,8=8,9=9,10=10,11=11,12=12 or more (a day)","NA","one beer,wine or alcohol ~10g",1680,1223,0.72799999999999998,0.89900000000000002,"78,8%","6.6 (8.5)","14.1 (14.2)","12 (5.2,22)","6.4 (2.3,12.8)"]
["LOLIPOP_EW610 (UK)","927 (26.9)","55.7 (9.7)","56.1 (9.8)","26.6 (5.1)","27.8 (4.4)","Last week","Questionnaire","Interview","Weekly intake","1.Pints of beer; 2.Glasses of wine C; 3.Measures of spirits","One unit is equivalent to: 1 small glass of wine, 1 single pub measure of spirits, or half a pint of beer / lager.","NA","1 unit = 10 gm, 1 unit per week = 10/7 gm/day",927,683,0.73699999999999999,0.78900000000000003,0.59399999999999997,"9.9 (12.8)","23.4 (24.9)","17.1 (2.9, 34.3)","4.3 (0,15.0)"]
["LOLIPOP_EWA (UK)","589 (12.9)","53.8 (12.3)","54.4 (10.1)","29.0 (6.5)","28.3 (4.6)","Last week","Questionnaire","Interview","Weekly intake","1.Pints of beer; 2.Glasses of wine C; 3.Measures of spirits","One unit is equivalent to: 1 small glass of wine, 1 single pub measure of spirits, or half a pint of beer / lager.","NA","1 unit = 10 gm, 1 unit per week = 10/7 gm/day",589,439,0.745,0.78200000000000003,0.5,"7.1 (12.9)","24.4 (30.7)","14.3 (2.9, 34.3)","0.7 (0,7.5)"]
["LOLIPOP_EWP (UK)","650 (0)","NA","55.7 (9.1)","NA","28.6 (5.3)","Last week","Questionnaire","Interview","Weekly intake","1.Pints of beer; 2.Glasses of wine C; 3.Measures of spirits","One unit is equivalent to: 1 small glass of wine, 1 single pub measure of spirits, or half a pint of beer / lager.","NA","1 unit = 10 gm, 1 unit per week = 10/7 gm/day",650,515,0.79200000000000004,0.79200000000000004,"NA","NA","24.1 (28.4)","16.4 (2.9, 34.3)","NA"]
["MESA (USA) ","2,336 (52.3)# ","62.6 (10.4)","62.9 ( 10.1)","27.5 (5.8)","28.0 ( 4.1)","Last year","FFQ","FFQ self-administered with follow-up from an interviewer","Standard 9-item response scale (from rarely and never to 6 + per day)","Participants indicated serving size (small, medium or large) and servings were defined by age and gender in NDSR.","FFQ line items for (1) beer, (2) wine, and (3) liquor or mixed drinks. Frequency indicated using the standard 9-item response scale (from rarely and never to 6 + per day).  Servings defined by gender in NDSR.","Midpoint was used, except for the 6+ categority the lower-limit was used.","NDSR was used to define age and sex specific-specific serving sizes for each of wine, beer and liquor.  Alcohol (g) per 100 g of the food was assumed at 10.4, 3.9 and 12.9 for each of wine, beer and liquor, respectively.  Trace amounts of alcohol were also included from food content (such as arroz con pollo) were also included in the calculation based on NDSR specified amounts.",2336,1567,0.67100000000000004,0.74,0.60799999999999998,"8.2 (11.9)","16.0 (20.3)","8.01 (2.89, 19.80)","3.56 (1.18, 10.13)"]
["NFBC1966 (Finland)","2480 (52.0)","31.2 (0.36)","31.2 (0.36)","24.2 (4.7)","25.2 (3.6)","Past 6 months","Questionnaire","Self-reported and then validated by food diary in a sub-sample","On a scale of 10 options from  not at all up to daily","By quantity (bottles=1/3 liter, glasses = 16cl), type (beer, wine (normal, heavy..) and concentration of alcohol  in a product","Separate categorical scales for beer, wine and spirits","Also yes/no variable, see earlier definitions","gram per day based on earlier information",5594,5068,0.90600000000000003,0.88700000000000001,0.91800000000000004,"5.6 (8.7)","15.3 (23.8)","7.80 (2.55-17.30)","2.2 (0.6-5.8)"]
["NSPHS (Sweden)","1,060 (53.6)","50.1 (20.4)","50.8 (19.8)","26.8 (5.1)","26.6 (4.5)","Current","Questionnaire","Self-reported in presence of a distric nurse","Monthly/Weekly/Daily typical intake.","Can (500 g), Glass (150 g), Liquor (60 g).","Categorical; Less than 1 per month (pm), 3 pm, 1 per week (pw), 3 pw, 6 pw, 1 per day (pd), 3 pd and pd.","NA","Light beer (2.8%) ~ 7.7 gm, Beer (3.5%) ~ 19.3 gm, Wine ~ 15.0 gm, Spirit ~ 18.7 gm",1060,602,0.56799999999999995,0.64,0.52100000000000002,"2.2 (3.1)","3.6 (4.8)","2.5 (1.2, 4.5)","1.3 (0.73, 2.5)"]
["NTR-NESDA (Netherlands) - Continuous trait","2,789 (62.0)","41.8 (13.7)","45.0 (13.7)","24.6 (5.4)","25.8 (4.3)","Current (NTR+NESDA)","Questionnaire (NTR) + Interview (NESDA)","Self-reported (NTR) + Questionnaire (NESDA)","Weekly typical intake (NTR) + Weekly/Monthly intake (NESDA)","1 glass of alcohol (NTR) / One drink with alchol (NESDA)","Categorical scale of drinks (NTR + NESDA)","Mean (NTR + NESDA)","12g per drink (NTR + NESDA)",3506,2789,0.9,0.93,0.89,"11.2 (12.9)","19.2 (19.5)","13.71 (5.14, 26.57)","5.14 (1.78, 14.10)"]
["NTR (Netherlands) - Continuous trait","875 (55.0)","50.0 (13.9)","52.7 (14.2)","25.2 (4.2)","26.0 (3.3)","Current","Questionnaire","Self-reported","Weekly typical intake","1 glass of alcohol","Categorical scale of drinks","Mean","12g per drink",1163,875,0.75,0.86,0.67,"11.7 (11.2)","18.9 (17.2)","13.70 (6.90, 24.00)","8.6 (5.10, 15.40)"]
["NESDA (Netherlands) - Dichotomous trait","1,241 (61.5)","40.1 (12.9)","43.6 (12.5)","NA*","NA*","-","-","-","-","-","-","-","-","-","-","NA","-","-","NA","NA","-","-"]
["NTR (Netherlands) - Dichotomou trait","1,105 (62.6)","37.6 (12.1)","36.3 (12.4)","NA*","NA*","-","-","-","-","-","-","-","-","-","-","NA","-","-","NA","NA","-","-"]
["ORCADES (Scotland)","698 (54.3)","53.5 (13.3)","55.0 (13.4)","27.3 (5.2)","27.9 (3.8)","Last year","Questionniare","Self-reported with nurse check","Weekly typical intake","Drinks were defined as units of alcohol which are widely understood in the UK. It was clarified that one unit is equivalent to half a pint of beer or lager, one glass of wine, or a single pub measure of spirits such as whisky.","The participant provided the number of units drunk.","NA","Ethanol gms was not measured in this study",2054,1979,0.78900000000000003,0.98099999999999998,0.95199999999999996,"5.7 (5.5)","10.2 (10.5)","NA","NA"]
["OZALC (Australia)","8,620 (58.7)","50.8 (13.5)","51.3 (13.4)","26.6 (5.6)","27.1 (4.4)","Past 7 days","Subjects filled in a table reporting number of drinks, by beverage type, for each of the previous 7 days","Self-reported","Subjects filled in a table reporting number of drinks, by beverage type, for each of the previous 7 days","Standard drinks, 10g alcohol","Separate number of beer, wine, spirits, other","N/A","one standard drink ~10g",9015,6515,1,0.80100000000000005,0.66100000000000003,"8.41 (12.2)","22.8 (26.3)","14 (6, 27)","6 (3, 12)"]
["PREVEND (Netherlands)","2,898 (43.8)","47.1 (11.4)","50.4 (12.6)","NA","NA","Last 30 days","Questionaire","Self-reported","Typical intake per day, week or month, depending on the quantity","glass of beer(250cc) / wine(100cc) / liquor(35cc)","Categorized as: - No, almost never , - 1 to 4 drinks per month , -  2 to 7 drinks per week,  -  1 to 3 drinks per day,  -  >= 4 drinks per day","mean of category","one alcoholic drink ~10g.",2898,2173,0.75900000000000001,0.82299999999999995,0.67200000000000004,"2.0 (0.8)","13.28 (15.4)","13.28 (0.76,16.3)","2.0 (0.70,9.0)"]
["PROSPER (Scotland, Ireland, and Netherlands)","5,001 (52.4)","75.7 (3.4)","75.0 (3.3)","27.1 (4.7)","26.5 (3.6)","last 30 days","Questionnaire","Interview","Weekly typical intake","NA","Number of alcoholic units per week in the last month","NA","NA",5001,432,0.53400000000000003,0.124,4.3999999999999997E-2,"10.2 (12.9)","23.0 (25.3)","16.2 (8.11,30.4)","8.11 (4.06, 14.20)"]
["RS-I (Netherlands)","3,643 (54.2)","67.43 (7.8)","66.93 (7.2)","26.86 (5.6)","26.4 (7.3)","lifetime","Questionnaire","Self-reported","Weekly intake","glass","Number of alcohlic drinks","NA","For pure alcohol weight 0.789 g/cm³ COMPUTE beerglass2 = beergram / ( 12.5 * 0.789 ) .COMPUTE redglas2 = redgram / ( 12 * 0.789 ) . COMPUTE whitglas2 = whitgram / ( 12 * 0.789 ) . COMPUTE sherglas2 = shergram / ( 12.8 * 0.789 ) . COMPUTE liqglas2 = liqgram / ( 12.25 * 0.789 ) .",4576,3643,0.72199999999999998,0.878,0.73799999999999999,"8.4 (11.0)","18.69 (18.6)","13.96 (4.14,27.92)","3.52 (0.7,11.97)"]
["RS-II (Netherlands)","1,367 (50.9)","65.9 (9.1)","65.0 (8.0)","27.4 (4.0)","26.9 (3.4)","lifetime","Questionnaire","Interview","Weekly intake","glass","Separate number of beer, wine, spirit","NA","(glasses/week * 13)/7",1700,1367,0.82599999999999996,0.88200000000000001,0.74099999999999999,"11.9 (14.5)","22.0 (21.6)","18.57 (5.57,35.75)","5.57 (1.86,16.71)"]
["RS-III (Netherlands)","1,867 (54.6)","56.2 (5.90)","55.8 (5.2)","27.2 (4.7)","28.0 (4.1)","Last year","Questionnaire","Interview","Daily","glass","Categorical (0=1-2, 1=3-4, 2=5-6, 3=7-9, 4 = 10 or more)","Mean","mean glasses/day * 13",2062,1867,0.88600000000000001,0.93600000000000005,0.872,"27.2 (15.3)","37.3 (24.4)","19.5 (19.5,45.5)","19.5 ( 19.5,19.5)"]
["SHIP (Germany)","3,966 (50.9)","48.5 (16)","50.6 (16.4)","26.9 (5.3)","27.7 (4.0)","Last 30 days","Beverage-Specific quantity-frequency questionnaire","Self-reported","#drinks (beer, wine, spirits) over the past 30 days, see Reference 1 in Comments","Beverage-specific: small beer (0.2 bis 0.33 liters), large beer (0.4-0.5 liters), wine (0.2-0.25l), spirits small (0.02 liters), spirits large (0.04 liters)","Average # of beverages, using sizes as defined above, per day","NA","Average alcohol consumption (in grams per day) was calculated by multiplying frequency and amount of alcohol from beer, wine, and spirits, respectively, using a standard ethanol content of 4.8 percent (by volume) in beer, 11 percent (by volume) in wine, and 33 percent (by volume) in spirits for conversion. See Reference 2 in Comments",3966,2608,0.65800000000000003,0.77,0.54910000000000003,"9.8 (10.4)","25.6 (23.1)","19.05 (8.16, 36.13)","6.08 (2.99, 12.47)","Reference 1: Arterioscler Thromb Vasc Biol. 2015 May;35(5):1265-70, J Stud Alcohol. 2006 May;67(3):429-35\nReference 2: Journal of studies on alcohol. 2006;67:429-435"]
["TwinsUK (UK) - Continuous trait","3,471 (100)","55.5 (13.4)","NA","26.2 (5.0)","NA","Lifetime","Questionnaire","Self-reported","Daily typical intake","Units per day","In the past 30 days, approx. how many units if alcohol did you drink per week?  If less than one please enter zero","NA","1 U = 8 gm",3471,"NA",0.33,"NA",1,"8.4 (7.8)","NA","NA","2.86 (0,8)"]
["TwinsUK (UK) - Dichotomous trait","1,204 (100)","46.6 (13.1)","NA","24.9 (4.4)","NA","-","-","-","-","-","-","-","-","-","-",5.3999999999999999E-2,"-","-","8.0 (8.9)","NA","-","-"]
["WGHS (USA)","13,209 (100) ","54.0 (7.0)","NA","25.2 (4.4)","NA","Baseline data collected during enrollment 1992-1994","Questionnaire","Self-reported","Categorical as follows:  '9= 6+/day', '8= 4-5/day', '7= 2-3/day', '6= 1/day', '5= 5-6/wk', '4= 2-4/wk', '3= 1/wk', '2= 1-3/mon', '1= Never, <1/mon'","Beer (glass, bottle, can), wine (4oz), liquor (1 drink, shot)","Categorical \"alc variabe\" defined as: '9= 6+/day', '8= 4-5/day', '7= 2-3/day', '6= 1/day', '5= 5-6/wk', '4= 2-4/wk', '3= 1/wk', '2= 1-3/mon', '1= Never, <1/mon'","Based on \"alc\" variable converted to drinks/week as: 9=>42, 8=>31.5, 7=>17.5, 5=>5.5, 4=>3, 3=>1, 2=>0.5, 1=>0.0, missing=>0.0","13.2 gm/beer, 10.8 gm/wine, 15.1gm/spirit",23042,13082,0.56699999999999995,"NA",1,"7.5 (10.0)","NA","NA","3.63 (1.51, 9.85)","                                                                                              "]
["YFS (Finland)","1,794 (55.6)","37.8 (5.0)","37.8 (5.0)","25.3 (5.0)","26.7 (4.3)","Last year","Questionnaire","Self-reported","Weekly typical intake","12 oz of regular/strong beer, 12 oz of cider etc, 4 oz of wine, or 1.5 oz of liquor","Separate number of beer, wine and spirit","NA","One beer etc/glass of wine/drink of spirit ~ 14 gm",1794,1338,0.746,0.49,0.51,"11.5 (10.7)","24.6 (27.9)","14.0 (4.0, 28.0)","4.0 (0.0, 12.0)"]
[{"$nulls":21},"Averaged median across samples = 14.0","Averaged median across samples = 6.0"]

{"sheet":"1B","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,4,1,8],[1,0,2,0]]}
["Supplementary Table 1B. Genotyping and imputation of primary GWAS cohorts in the Alcohol Genome-wide Association (AlcGen) consortium"]
["Study (Country)","Genotyping platform","Calling algorithm","Genotype based exclusions","Imputation",{"$nulls":4},"NCBI reference sequence","Dosage vs best guess","N SNPs for analysis","Association software","Lambda"]
[{"$nulls":4},"Call rate filter","HWE (P-value) filter","MAF filter","Software","Reference panel"]
["Colaus (Switzerland)","Affymetrix 500K","BRLMM","PC outliers, related/duplicate individuals",">0.7",">10-7",">0.01","IMPUTE","HapMap CEU 21A","Build 35","dosage",2557249,"Matlab",1.08]
["EGCUT (Estonia)","Illumina 370K, Illumina OmniExpress","Illumina protocol","gender, duplication, contamination, relatedness",">0.95",">10-6",">0.01","IMPUTE","HapMap CEU 21A","Build 35","dosage",2230834,"SNPTEST",1.02]
["EPIC-Norfolk","Affymetrix 500K","BRLMM","heterozygosity <23% or >30%; >5.0% discordance in SNP pairs with r2= 1 in HapMap; ethnic outliers; related individuals and duplicates","≥0.90",">10-6",">0.01","IMPUTE","1000G March 2012","Build 37","dosage",15506845,"SNPTEST",0.91]
["ERF (Netherlands)","Illumina 318k, Illumina6k, \nIllumina 370k, Affymetrix250K","Illumina Beadstudio, BRLMM","Samples with low call rate (<97.5%), with excess autosomal heterozygosity (>0.336), or with sex‐mismatch were excluded, as were outliers identified by the identity‐by‐state clustering analysis (outliers were defined as being >3 s.d. from population mean or having identity‐by‐state probabilities >97%). SNPs with call rate >98% were used for imputations.","≥0.98",">10-6",">0.01","MACH 1.0.15","Hapmap CEU release 22","Build 36","dosage",3021330,"ProbABEL",1.04]
["Fenland (UK)","Affymatrix SNP5.0","BRLMM","gender discrepancy; duplication;  relatedness; heterozygosity(upper bound 0.28822 lower bound 0.27348)",">0.95",">10-6",">0.01","IMPUTE","HapMap CEU r22","Build 36","dosage",2622460,"SNPTEST",1.02]
["FinnTwin12 (Finland)","Human670-QuadCustom Illumina BeadChip","Illumina Genome Studio","gender discrepancy, duplication, excess heterozygosity",">0.95",">10-6",">0.01","IMPUTE","HapMap CEU release 24","Build 36","best guess",2569765,"PLINK",1.01]
["FinnTwinOld_1 (Finland)","Human670-QuadCustom Illumina BeadChip","Illumina Genome Studio","gender discrepancy, duplication, excess heterozygosity",">0.95",">10-6",">0.01","IMPUTE","HapMap CEU release 24","Build 36","best guess",2560990,"PLINK",1.01]
["FinnTwinOld_2 (Finland)","Illumina 318","Illumina protocol","duplication; contamination; relatedness",">0.90",">10-6",">0.01","MACH","HapMap CEU 22","Build 36","best guess",316407,"PLINK",1.01]
["FinnTwinOld_3 (Finland)","Illumina 610-Quad","Illuminus","gender discrepancy, duplication, excess heterozygosity",">0.97",">10-6",">0.01","Impute2 v2.1.0","Hapmap CEU 22","Build 36","dosage",505583,"SNPTEST v2",1.01]
["HBCS (Finland)","Illumina 670k","Illumina BeadStudio","gender discrepancy, duplication,  relatedness, ethnicity",">0.95",">10-5",">0.01","MACH","HapMap CEU","Build 36","dosage",2430603,"Plink, ProbABEL",1.01]
["KORA F3 (Germany)","Illumina 500K","Illumina protocol","NA","≥0.9","NA","NA","IMPUTE","HAPMAP CEU 21A","Build 35","dosage",2552926,"SNPTEST",1.04]
["KORA F4 (Germany)","Affymatrix 6.0","Affymetrix birdseed","NA","≥0.90","NA","NA","IMPUTE","HAPMAP CEU 21A","Build 35","dosage",2743206,"SNPTEST",1.02]
["Lifelines (Netherlands)","Illumina CytoSNP12 v2","GenomeStudio","gender discrepancy; duplication; contaminated sample; relatedness","≥0.95","≥0.00001","≥0.95","Beagle","phased CEU haplotypes, HapMap release 22 ","Build 36","dosage",2269099,"Plink 1.07",1.01]
["LOLIPOP_EW610 (UK)","Illumina Human610","BeadStudio","Missing rate, duplication, contamination, relatedness, population outlier, gender discrepancy","≥0.9",">10-6","≥0.01","MACH","HapMap CEU r22","Build 36","dosage",2543887,"mach2qtl",1.01]
["LOLIPOP_EWA (UK)","Affymetrix 500K","BRLMN","Missing rate, duplication, contamination, relatedness, population outlier","≥0.9",">10-6","≥0.01","MACH","HapMap CEU 21A","Build 35","dosage",2557252,"mach2qtl",1.02]
["LOLIPOP_EWP (UK)","Perlegen custom array","Custom","Missing rate, duplication, contamination, relatedness, population outlier","≥0.9",">10-6","≥0.01","MACH","HapMap CEU 21A","Build 35","dosage",2557252,"mach2qtl",1.02]
["NESDA (Netherlands)\n- Dichotomous trait","Affymetrix 6.0","Affy power tools","gender discrepancy, duplication, contaminated sample, relatedness","≥0.95","≥10-5","≥0.01","Beagle","HapMap CEU release 22","Build 36","dosage",673106,"SNPTEST 2.3.0",1]
["NFBC1966 (Finland)","Illumina infinium cnvDuo 370K array","Illumina protocol","Duplicates (2), contaminated samples (3), relatedness (53), gender mismatch (15)","> 0.95",">10-4","> 0.01","IMPUTE","HapMap CEU 21A","Build 35","dosage",2556690,"SNPTEST",1.01]
["NTR (Netherlands)\n- Continuous trait","Illumina Human660W-BeadQuad","Illumina Genome Studio","Gender & IBD mismatch, DNA heterozygosity F<-0.10 & F>0.10, Callrate 0.90",">0.95",">10-5",">0.01","IMPUTE1","Hapmap 2 CEU","Build 36 rel24","dosage",2537854,"SNPTEST",1.01]
["NTR (Netherlands)\n- Dichotomou trait","Affymetrix 6.0","Affy power tools","gender discrepancy; duplication; contaminated sample; relatedness","≥0.95","≥10-5","≥0.01","Beagle","HapMap CEU release 22","Build 36","dosage",673106,"SNPTEST 2.3.0",1]
["NTR-NESDA (Netherlands)\n- Continuous trait","Perlegen-Affymetrix","Perlegen Proprietary","Gender & IBD mismatch, DNA heterozygosity F<-0.10 & F>0.10, Callrate 0.90",">0.95",">10-5",">0.01","IMPUTE1","Hapmap 2 CEU","Build 36 rel24","dosage",2431587,"SNPTEST",1]
["OZALC (Australia)","Illumina 310, Illumina370, Illumina 610","Illumina BeadStudio","Duplication, sex discrepancy, mendelian errors",">0.95",">10-6",0.01,"MACH","HapMap CEU","Build 35","dosage",2543610,"Merlin",1.05]
["PREVEND (Netherlands)","Illumina CytoSNP12 v2","GenomeStudio","gender discrepancy; duplication; contaminated sample; relatedness","≥0.95","≥10-5","≥0.95","Beagle","Phased CEU haplotypes, HapMap release 22","Build 36","dosage",2472791,"Plink 1.07",0.99]
["SHIP (Germany)","Affymetrix SNP 6.0","Birdseed2","gender discrepancy, duplication","NA","NA","NA","IMPUTE","HapMap CEU 22","Build 36","dosage",2748910,"QUICKTEST",1.01]
["TwinsUK (UK)\n- Continuous trait","Illumina 317K/610K","Ilumina protocol","gender discrepancy, duplication, contamination, relatedness",">0.95",">10-6",">0.01","IMPUTE V2.1.0","HapMap2 r24","Build 36","best guess",3044097,"GenABEL",1.04]
["TwinsUK (UK) \n- Dichotomous trait","Illumina 317K/610K","Ilumina protocol","gender discrepancy, duplication, contamination, relatedness",">0.95",">10-6",">0.01","IMPUTE V2.1.0","HapMap2 r24","Build 36","dosage",3044097,"SNPTEST",1.05]
["YFS (Finland)","Illumina 670k Custom","Illumina","gender discrepancy, duplication, contamination, relatedness",">0.95",">10-6",">0.01","MACH 1.0","HapMap CEU 22","Build 36","dosage",2543887,"ProbABEL",1.02]
[]
[]
["* BMI was not included as covariates in the original analysis"]

{"sheet":"1C","index":2,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,4,1,8]]}
["Supplementary Table 1C. Genotyping and imputation of primary GWAS cohorts in the Cohorts for Heart and Aging Research in Genomic Epidemiology-Plus (CHARGE+) consortium"]
["Study (Country)","Genotyping platform","Calling algorithm","Genotype based exclusions","Imputation",{"$nulls":4},"NCBI reference sequence","Dosage vs best guess","N SNPs for analysis","Association software","Lambda"]
[{"$nulls":4},"Call rate filter","HWE (P-value) filter","MAF filter","Software","Reference panel"]
["AGES (Iceland)","Illumina 370CNV","Illumina BeadStudio","Sex discrepancy, duplication, contamination",null,">10-6",">0.01","MACH 1.0.16","Hapmap CEU release 22","Build 36","dosage",2593541,"PLINK and R",1.06]
["ARIC (USA)","Affymetrix 6.0","Birdseed","Sex discrepancy, duplication, contamination",">0.95",">10-5",">0.01","MACH 1.0.16","Hapmap CEU release 21","Build 36","dosage",2543887,"PLINK, MACH2QTL","NA*"]
["CHS (USA)","Illumina 370CNV","Illumina BeadStudio","Sex discrepancy",">0.95",">10-5","Heterozygote frequency >0","BIMBAM10 v.0.99","Hapmap II, CEU","Build 36","dosage",2543887,"R",1.01]
["FHS (USA)","Affymetrix 500K and MIPS 50K combined","BRLMM","Sex discrepancy, duplication, contamination",">0.95",">10-6",">0.01","MACH 1.0.15","Hapmap II, CEU","Build 36","dosage",2606763,"LME (R)",1.02]
["Health ABC (USA)","Illumina Human 1M-Duo BeadChip","Illumina BeadStudio 3.3.7","Sample failure, genotypic sex mismatch, first-degree relative of an included individual",">0.95",">10-6",">0.01","MACH 1.0.16","Hapmap CEU release 22","Build 36","dosage",2543887,"Linear regression",1.01]
["MESA (USA) ","Affymetrix 6.0","Birdseed","Monomorphic SNPs",">0.95","---","Monomorphic SNPs","IMPUTE v. 2.1.0","Hapmap I, II, CEU","Build 36","dosage",3861466,"SNPTEST v.2.4.0",0.99]
["RS1 (Netherlands)","Illumina 550k","Illumina BeadStudio","Samples with low call rate (<97.5%), with excess autosomal heterozygosity (>0.336), or with sex‐mismatch were excluded, as were outliers identified by the identity‐by‐state clustering analysis (outliers were defined as being >3 s.d. from population mean or having identity‐by‐state probabilities >97%). SNPs with call rate >98% were used for imputations.",">0.98",">10-6",">0.01","MACH 1.0.15","Hapmap CEU release 22","Build 36","dosage",2543887,"ProbABEL",1.03]
["RS2 (Netherlands)","Illumina 550K","Illumina BeadStudio","Same as that in RS1",">0.975",">10-6",">0.01","MACH 1.0.16","Hapmap CEU release 22","Build 36","dosage",2543887,"ProbABEL",1]
["RS3 (Netherlands)","Illumina 610K","Illumina BeadStudio","Same as that in RS1",">0.975",">10-6",">0.01","MACH 1.0.15","Hapmap CEU release 22","Build 36","dosage",2543887,"ProbABEL",1]
["WGHS (USA)","Illumina HumanHap 300 DuoPlus","Illumina BeadStudio 3.3","---","---",">10-6",">0.01","MACH 1.0.15","Hapmap CEU release 22","Build 36","dosage",2608508,"Linear regression",1.01]
[]
[]
["# Sample size and statistics are based on the full cohort"]
["* ARIC only contributed to meta-analysis of dichotomous alcohol phenotype"]

{"sheet":"1D","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[7,0,7,6]]}
["Supplementary Table 1D. Continuous trait primary GWAS cohorts - summary"]
[null,"All",null,"Men",null,"Women"]
[null,"# of Cohorts","Sample size","# of Cohorts","Sample size","# of Cohorts","Sample size"]
["AlcGen",21,38000,19,18260,20,19740]
["CHARGE+",9,32460,8,9300,9,23160]
["AlcGen & CHARGE+",30,70460,27,27560,29,42900]
[]
["Studies - AlcGen: CoLaus, EGCUT, EPIC-Norfolk, ERF, Fenland, FinnTwinOld_2, HBCS, KORA F3, KORA F4, Lifelines, LOLIPOP_EW610, LOLIPOP_EWA, LOLIPOP_EWP, FinnTwinOld_3, NESDA, NFBC1966, NTR, OZALC, SHIP, TwinsUK, YFS; CHARGE+: AGES, CHS, FHS, HABC, MESA, RS1, RS2, RS3, WGHS."]

{"sheet":"1E","index":4,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[7,0,7,6]]}
["Supplementary Table 1E. Dichotomous trait primary GWAS cohorts - summary"]
[null,"All",null,"Men",null,"Women"]
[null,"# of Cohorts","Sample size","# of Cohorts","Sample size","# of Cohorts","Sample size"]
["AlcGen",20,31868,19,17088,17,14780]
["CHARGE+",9,42843,8,9903,9,32940]
["AlcGen & CHARGE+",29,74711,27,26991,26,47720]
[]
["Studies - AlcGen: CoLaus, DESIR, EGCUT, EPIC-Norfolk, Fenland, FinnTwin12, FinnTwinOld_1, HBCS, KORA F3, KORA F4, Lifelines, LOLIPOP_EW610, LOLIPOP_EWA, LOLIPOP_EWP, NFBC1966, NTR-NESDA, OZALC, PREVEND, TwinsUK, YFS; CHARGE+: AGES, ARIC, CHS, FHS, HABC, MESA, RS1, RS2, WGHS.  "]

{"sheet":"1F","index":5,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,4,1,8],[1,0,2,0]]}
["Supplementary Table 1F. Characterization of replication cohorts"]
["Study (Country)","Genotyping platform","Calling algorithm","Genotype based exclusions","Imputation",{"$nulls":4},"NCBI reference sequence","Dosage vs best guess","Association software"]
[{"$nulls":4},"Call rate filter","HWE (P-value) filter","MAF filter","Software","Reference panel"]
["Airwave (UK)","Illumina Infinium HumanCoreExome-12v1-1 BeadChip Arrays","Genome Studio","gender discrepancy, excess heterozygosity, duplicated or related individuals ",">0.95",">10-4","NA","Minimac","1000G Phase 3","Build 36","best guess","PLINK"]
["ASPS (Austria)","Illumina  Human610-Quad BeadChip","Illumina","Ethnic outliers; duplicates; gender mismatch, relatedness",">0.98",">10-6",">0.01","IMPUTE 2","1000G ALL phase1 integrated variant set realease v3 (march 2012)","Build 37","dosage","SNPTEST"]
["B58C (UK)","Illumina 550k_v1/550k_v3/610k (3 subsets)","GenCall","duplication, relatedness","≥0.95",">10-4","≥0.01","MACH","1000G phase 1 (Mar 2012)","Build 36","dosage","SNPTEST"]
["DESIR (France)","Illumina HAP300 array + Illumina Human CNV370","Ilumina protocol","gender discrepancy",{"$nulls":5},"Build 37","dosage","PLINK"]
["FinnTwin_replication (Finland)","Human610-QuadCustom Illumina BeadChip, Human670-QuadCustom Illumina BeadChip, Illumina Human Core Exome BeadChip","Illumina Genome Studio, zcall for rare variants","gender discrepancy, duplication, excess heterozygosity",">0.95",">10-6",">0.01","IMPUTE v2","1000Genomes Phase I Release version III (September 2013)","Build 37","dosage","STATA"]
["GRAPHIC (UK)","HumanOmniExpress-12v1 array","Illumina","gender discrepancy, duplication",">0.95 (or >0.99 if MAF<5%) ",">10-6",">0.01","IMPUTE v2","1000G march 2012 v3 ","Build 37","dosage","SNPtest"]
["GS:SFHS (Scotland)","Illumina HumanOmniExpressExome-8v1_A","Genome Studio","gender discrepancy, duplication, gross genetic outlier",">0.98",">10-6","> 0.01 for OMNI chip variants, >10-4  for exome chip variants","IMPUTEv2.3.0","1000Genome-Phase I integrated release v3, April 2012","Build 37","dosage","GenABEL"]
["INGI_CARL (Italy)","Illumina 370k","Ilumina protocol","gender discrepancy, duplication",">0.97",">10-8",">0.01","IMPUTE2","1000G Phase I v3","Build 37","dosage","GenABEL"]
["INGI_FVG (Italy)","Illumina 370k + Illumina 700k","Ilumina protocol","gender discrepancy, duplication",">0.97",">10-8",">0.01","IMPUTE2","1000G Phase I v3","Build 37","dosage","GenABEL"]
["INGI_VB (Italy)","HumanCNV370-Quadv3_C (1664 samples) + HumanOmniExpress-12v1_H (121 samples)","Illumina protocol","call rate < 90%, MAF<0.01, pHWE< 10-3",">0.9",">10-3",">0.01","IMPUTE2","HapMap release 22 + HapMap 3","Build 36","dosage","ProbABEL"]
["LBC1921 (Scotland)","Illumina 610","Genome Studio","gender discrepancy, relatedness, non-European ancestry","≥0.98","≥10-3","≥0.01","MACH","HapMap phase II CEU","Build 36","dosage","MACH2QTL"]
["LBC1936 (Scotland)","Illumina 610","Genome Studio","gender discrepancy, relatedness, non-European ancestry","≥0.98","≥10-3","≥0.01","MACH","HapMap phase II CEU","Build 36","dosage","MACH2QTL"]
["NSPHS (Sweden)","Illumina Infinium HapMap 300v2/Human OmniExpress","Ilumina protocol","gender discrepancy, duplication",">0.90",">10-8",">0.005","IMPUTE2","1000G","Build 36","dosage","ProbABEL"]
["ORCADES (Scotland)","Illumina HumanHap300, Omni1 and OmniExpress","Illumina Genome Studio","gender discrepancy, duplication, excess heterozygosity, kinship discrepancy","NA","NA","NA","IMPUTE2","1000G version 3","Build 37","dosage","ProbABEL"]
["PROSPER (Scotland, Ireland, and Netherlands)","Illumina 660K quad beadchip","Illumina protocol","gender mismatch, heterogeneity, duplication",">0.97",">10-6","None","MACH","HapMap CEU 22","Build 36","dosage","ProbABEL"]

{"sheet":"1G","index":6,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[6,0,6,6],[7,0,7,6]]}
["Supplementary Table 1G. Replication studies – summary"]
[null,"All",null,"Men",null,"Women"]
[null,"# of Cohorts","Sample size","# of Cohorts","Sample size","# of Cohorts","Sample size"]
["Continuous trait",14,35438,13,19290,13,16148]
["Dichotomous trait",12,31021,12,16997,12,14024]
[]
["Studies for continuous trait – Airwave, ASPS, B58C, FinnTwinOld_2, GRAPHIC, GS:SFHS, INGI_CARL, INGI_FVG, INGI_VB, LBC1921, LBC1936, NSPHS, ORCADES, PROSPER."]
["Studies for dichotomous trait – Airwave, ASPS, B58C, FinnTwinOld_2, GRAPHIC, GS:SFHS, INGI_CARL, INGI_FVG, INGI_VB, LBC1921, LBC1936, PROSPER."]