Calculation average of lead content of new paints based on data from O’Connor et al., 2018

	A	B	C	D	E	F	H	L	N	O	P	R	S	T	U	V	X	Y	Z
1	Calculating the weighted average lead content of new paints based on table 4-9 in O’Connor et al. (2018)
2									Calculations: (Scroll to the right to see more)			Weighted average per region					Selection of numbers used in report
3	Table in paper	Location	Year of publication	Product type	Number of samples	Average (mg/kg)	Median (mg/kg)	Comment	Number of samples, excluding studies for which average is not available	Average (if available, otherwise 0)	Average times number of samples	Table	Country	Sum of average times number of samples	Total number of samples for which average is available	Weighted average	Region (table in O' Connor paper)	Average lead content weighted by sample size (mg/kg)	Total number of samples used to calculate this average

4	Table 3. Lead content of new paints in China.	China	2013	N/A	277	20,284	N/A	The paper includes information on several individual cities. We use the average of those weighted by sample size as calculated in the paper. We checked this number in a seperate tab.	277	20,284	5618668	Table 3. Lead content of new paints in China.	China	5618668	277	20284	China (Table 3)	20284	277
5	Table 4. Lead content of new paints in India.	India	2013	N/A	441	23,008	N/A	The paper includes information on several individual cities. We use the average of those weighted by sample size as calculated in the paper. We checked this number in a seperate tab.	441	23,008	10146528	Table 4. Lead content of new paints in India.	India	10146528	441	23008	India (Table 4)	23008	441
6	Table 5. Lead content of new paints in other Asian countries.	Armenia	2014	Enamel paint	26	25,000	N/A		26	25,000	650000	Table 5. Lead content of new paints in other Asian countries.	Other Asian countries	27887341	1545	18050.0589	Other Asian countries (Table 5)	18050	1545
7	Table 5. Lead content of new paints in other Asian countries.	Bangladesh	2011	Paint	6	42,287	N/A		6	42,287	253722	Table 6. Lead content of new paints in Africa.	Africa	8410717	486	17306.00206	Africa (Table 6)	17306	486
8	Table 5. Lead content of new paints in other Asian countries.	Bangladesh	2011	Paint	29	5783	N/A		29	5783	167707	Table 8. Lead content of new paints in Europe.	Europe	375452.43	187	2007.767005	Latin America (Table 9)	16476	192
9	Table 5. Lead content of new paints in other Asian countries.	Bangladesh	2014	Oil based, enamel decorative paint	90	11,900	N/A		90	11,900	1071000	Table 9. Lead content of new paints in Latin America.	Latin America	3163444.8	192	16476.275	Total (weighted by sample size)	18778	2941
10	Table 5. Lead content of new paints in other Asian countries.	Indonesia	2009	Enamel paint	11	14,770	3474		11	14,770	162470
11	Table 5. Lead content of new paints in other Asian countries.	Indonesia	2014	Oil based, enamel decorative paint	78	17,300	N/A		78	17,300	1349400	Check: average of total, calculated in two different ways				17775.62379
12	Table 5. Lead content of new paints in other Asian countries.	Indonesia	2015	Enamel paint	121	17,217	4567		121	17,217	2083257					17775.62379
13	Table 5. Lead content of new paints in other Asian countries.	Jordan	2012	Paints	17	322	N/A		17	322	5474					OK
14	Table 5. Lead content of new paints in other Asian countries.	Kazakhstan	2014	Enamel paint	26	15,700	N/A		26	15,700	408200
15	Table 5. Lead content of new paints in other Asian countries.	Kazakhstan	2016	Home paints	45	N/A	N/A		0	0	0
16	Table 5. Lead content of new paints in other Asian countries.	Lebanon	2015	Enamel paint	15	48,300	30,100		15	48,300	724500
17	Table 5. Lead content of new paints in other Asian countries.	Malaysia	2006	Paint	32	N/A	21,300		0	0	0
18	Table 5. Lead content of new paints in other Asian countries.	Malaysia	2009	Enamel paint	72	24,510	614		72	24,510	1764720
19	Table 5. Lead content of new paints in other Asian countries.	Malaysia	2016	Enamel paint	39	21,429	200		39	21,429	835731
20	Table 5. Lead content of new paints in other Asian countries.	Mongolia	2017	Home paints	56	7706	555		56	7706	431536
21	Table 5. Lead content of new paints in other Asian countries.	Nepal	2011	Paint	24	6575	N/A		24	6575	157800
22	Table 5. Lead content of new paints in other Asian countries.	Nepal	2011	Paint	12	28,417	190		12	28,417	341004
23	Table 5. Lead content of new paints in other Asian countries.	Nepal	2014	Paint	75	23,367	5100		75	23,367	1752525
24	Table 5. Lead content of new paints in other Asian countries.	Nepal	2014	Oil based, enamel decorative paint	49	16,600	N/A		49	16,600	813400
25	Table 5. Lead content of new paints in other Asian countries.	Nepal	2015	Enamel paint	87	18,326	6200		87	18,326	1594362
26	Table 5. Lead content of new paints in other Asian countries.	Philippines	2009	Enamel paint	15	28,354	3199		15	28,354	425310
27	Table 5. Lead content of new paints in other Asian countries.	Philippines	2014	Oil based, enamel decorative paint	122	18,500	N/A		122	18,500	2257000
28	Table 5. Lead content of new paints in other Asian countries.	Philippines	2015	Enamel paint	140	21,820	2770		140	21,820	3054800
29	Table 5. Lead content of new paints in other Asian countries.	Philippines	2017	Home paints	104	N/A	N/A		0	0	0
30	Table 5. Lead content of new paints in other Asian countries.	Singapore	2006	Paint	22	N/A	9		0	0	0
31	Table 5. Lead content of new paints in other Asian countries.	Singapore	2009	Enamel paint	41	6988	N/A		41	6988	286508
32	Table 5. Lead content of new paints in other Asian countries.	Sri Lanka	2009	Enamel paint	19	25,210	5137		19	25,210	478990
33	Table 5. Lead content of new paints in other Asian countries.	Sri Lanka	2014	Oil based, enamel decorative paint	94	11,600	N/A		94	11,600	1090400
34	Table 5. Lead content of new paints in other Asian countries.	Sri Lanka	2015	Enamel paint	56	N/A	N/A		0	0	0
35	Table 5. Lead content of new paints in other Asian countries.	Tajikistan	2016	Oil based, enamel decorative paint	51	N/A	N/A		0	0	0
36	Table 5. Lead content of new paints in other Asian countries.	Thailand	2009	Enamel paint	18	19,410	15,170		18	19,410	349380
37	Table 5. Lead content of new paints in other Asian countries.	Thailand	2009	Enamel paint	17	61,893	35		17	61,893	1052181
38	Table 5. Lead content of new paints in other Asian countries.	Thailand	2014	Oil based, enamel decorative paint	120	19,100	N/A		120	19,100	2292000
39	Table 5. Lead content of new paints in other Asian countries.	Thailand	2015	Enamel paint	100	19,205	2109		100	19,205	1920500
40	Table 5. Lead content of new paints in other Asian countries.	Vietnam	2016	Paint	26	4364	970		26	4364	113464
41	Table 6. Lead content of new paints in Africa.	Egypt	2014	Enamel paint	52	14,300	N/A		52	14,300	743600
42	Table 6. Lead content of new paints in Africa.	Egypt	2009	Enamel paint	20	26,200	4717		20	26,200	524000
43	Table 6. Lead content of new paints in Africa.	Ethiopia	2013	Enamel paint	23	18,500	N/A		23	18,500	425500
44	Table 6. Lead content of new paints in Africa.	Ghana	2013	Enamel paint	18	5030	N/A		18	5030	90540
45	Table 6. Lead content of new paints in Africa.	Ivory Coast	2013	Enamel paint	20	8700	N/A		20	8700	174000
46	Table 6. Lead content of new paints in Africa.	Kenya	2012	Enamel paint	31	14,900	N/A		31	14,900	461900
47	Table 6. Lead content of new paints in Africa.	Nigeria	2007	Home paints	21	14,500	N/A		21	14,500	304500
48	Table 6. Lead content of new paints in Africa.	Nigeria	2009	Enamel paint	25	15,750	N/A		25	15,750	393750
49	Table 6. Lead content of new paints in Africa.	Nigeria	2009	Enamel paint	23	36,989	23,866		23	36,989	850747
50	Table 6. Lead content of new paints in Africa.	Senegal	2009	Enamel paint	21	5866	2771		21	5866	123186
51	Table 6. Lead content of new paints in Africa.	Seychelles	2009	Enamel paint	28	24,880	2527		28	24,880	696640
52	Table 6. Lead content of new paints in Africa.	South Africa	2009	Enamel paint	29	19,862	11		29	19,862	575998
53	Table 6. Lead content of new paints in Africa.	Tanzania	2015	Enamel paint	56	12,541	N/A		56	12,541	702296
54	Table 6. Lead content of new paints in Africa.	Tanzania	2009	Enamel paint	20	14,537	4130		20	14,537	290740
55	Table 6. Lead content of new paints in Africa.	Tunisia	2013	Enamel paint	30	17,900	N/A		30	17,900	537000
56	Table 6. Lead content of new paints in Africa.	Uganda	2017	Home paints	30	31,694	1450		30	31,694	950820
57	Table 6. Lead content of new paints in Africa.	Zambia	2017	Home paints	39	14,500	15,800		39	14,500	565500
58	Table 6. Lead content of new paints in Africa.	Cameroon	2013	Paint	61	N/A	2150		0	0	0
59	Table 6. Lead content of new paints in Africa.	Cameroon	2015	Enamel paint	35	N/A	N/A		0	0	0
60	Table 6. Lead content of new paints in Africa.	Ethiopia	2015	Enamel paint	36	N/A	N/A		0	0	0
61	Table 6. Lead content of new paints in Africa.	Ivory Coast	2015	Enamel paint	44	N/A	N/A		0	0	0
62	Table 6. Lead content of new paints in Africa.	Benin	2017	Home paints	28	N/A	N/A		0	0	0
63	Table 6. Lead content of new paints in Africa.	Cameroon	2017	Home paints	65	N/A	N/A		0	0	0
64	Table 6. Lead content of new paints in Africa.	Egypt	2017	Home paints	58	N/A	N/A		0	0	0
65	Table 6. Lead content of new paints in Africa.	Ethiopia	2017	Home paints	36	N/A	N/A		0	0	0
66	Table 6. Lead content of new paints in Africa.	Guinea	2017	Home paints	18	N/A	N/A		0	0	0
67	Table 6. Lead content of new paints in Africa.	Ivory Coast	2017	Home paints	51	N/A	N/A		0	0	0
68	Table 6. Lead content of new paints in Africa.	Kenya	2017	Home paints	51	N/A	N/A		0	0	0
69	Table 6. Lead content of new paints in Africa.	Morocco	2017	Home paints	33	N/A	N/A		0	0	0
70	Table 6. Lead content of new paints in Africa.	Mozambique	2017	Home paints	32	N/A	N/A		0	0	0
71	Table 6. Lead content of new paints in Africa.	Nigeria	2017	Home paints	54	N/A	N/A		0	0	0
72	Table 6. Lead content of new paints in Africa.	Sudan	2017	Home paints	25	N/A	N/A		0	0	0
73	Table 6. Lead content of new paints in Africa.	Tanzania	2017	Home paints	46	N/A	N/A		0	0	0
74	Table 6. Lead content of new paints in Africa.	Togo	2017	Home paints	27	N/A	N/A		0	0	0
75	Table 8. Lead content of new paints in Europe.	Armenia	2016	Decorative paint	49	N/A	N/A		0	0	0
76	Table 8. Lead content of new paints in Europe.	Azerbaijan	2013	Enamel paint	30	2600	N/A		30	2600	78000
77	Table 8. Lead content of new paints in Europe.	Belarus	2009	Enamel paint	22	5557	1678		22	5557	122254
78	Table 8. Lead content of new paints in Europe.	Belarus	2016	Home paints	48	N/A	N/A		0	0	0
79	Table 8. Lead content of new paints in Europe.	Georgia	2016	Home paints	37	N/A	N/A		0	0	0
80	Table 8. Lead content of new paints in Europe.	Kyrgyz	2016	Home paints	51	N/A	N/A		0	0	0
81	Table 8. Lead content of new paints in Europe.	Moldova	2016	Home paints	28	N/A	N/A		0	0	0
82	Table 8. Lead content of new paints in Europe.	Russia	2015	Enamel paint	21	8340	2140		21	8340	175140
83	Table 8. Lead content of new paints in Europe.	Russia	2016	Home paints	72	N/A	N/A		0	0	0
84	Table 8. Lead content of new paints in Europe.	Portugal	2015	Artist paints	54	0.52	N/A		54	0.52	28.08
85	Table 8. Lead content of new paints in Europe.	Portugal	2015	Gouaches	20	0.65	N/A		20	0.65	13
86	Table 8. Lead content of new paints in Europe.	Portugal	2015	Acrylics	5	0.29	N/A		5	0.29	1.45
87	Table 8. Lead content of new paints in Europe.	Portugal	2015	Watercolors	23	0.54	N/A		23	0.54	12.42
88	Table 8. Lead content of new paints in Europe.	Portugal	2015	Fingerpaints	6	ND	N/A		0	0	0
89	Table 8. Lead content of new paints in Europe.	Portugal	2015	Face paints	12	0.29	N/A		12	0.29	3.48
90	Table 8. Lead content of new paints in Europe.	Ukraine	2016	Home paints	53	N/A	N/A		0	0	0
91	Table 9. Lead content of new paints in Latin America.	Argentina	2013	Enamel paint	30	17,000	N/A		30	17,000	510000
92	Table 9. Lead content of new paints in Latin America.	Brazil	2009	Enamel paint	24	15,004	N/A		24	15,004	360096
93	Table 9. Lead content of new paints in Latin America.	Brazil	2014	Enamel paint	10	36,000	Reported before regulation		10	36,000	360000
94	Table 9. Lead content of new paints in Latin America.	Brazil	2014	Enamel paint	10	4.5	Same brand after regulation		10	4.5	45
95	Table 9. Lead content of new paints in Latin America.	Brazil	2014	Enamel paint	10	11,300	Other brand after regulation		10	11,300	113000
96	Table 9. Lead content of new paints in Latin America.	Chile	2013	Enamel paint	23	52.6	N/A		23	52.6	1209.8
97	Table 9. Lead content of new paints in Latin America.	Colombia	2016	Home paints	39	N/A	N/A		0	0	0
98	Table 9. Lead content of new paints in Latin America.	Ecuador	2009	Enamel paint	10	31,960	13,460		10	31,960	319600
99	Table 9. Lead content of new paints in Latin America.	Mexico	2009	Enamel paint	20	51,860	N/A		20	51,860	1037200
100	Table 9. Lead content of new paints in Latin America.	Paraguay	2015	Enamel paint	15	23,100	<9		15	23,100	346500