select count(*) from "NYTS 2012 Dataset"
Total responses in 2012 survey
24658
---
select qn7, count(*) from "NYTS 2012 Dataset" group by qn7
,403,
1,6361,
2,17894,
qn7 is "Tried cigarette smkg, even 1 or 2 puffs"
blank is no answer - 403 kids
1 is Yes
2 is No
----
select qn8, count(*) from "NYTS 2012 Dataset" group by qn8
,108, (blank answer)
1,1385, (definitely yes)
2,1686, (Probably yes)
3,4386, (probably no)
4,17093, (definitely no)
qn8 = "Think will smoke a cigarette anytime during next year"
----
Have tried cigs before - will try again this year?
select qn8, count(*) from "NYTS 2012 Dataset" where qn7 = 1 group by qn8
,15,
1,1349,
2,1410,
3,1533,
4,2054,
-----
have not tried cigs - will try this year?
select qn8, count(*) from "NYTS 2012 Dataset" where qn7 = 2 group by qn8
,27,
1,17,
2,249,
3,2728,
4,14873,
----
qn37g is EVER TRIED: e-cigt (e.g. Ruyan)
select qn37g, count(*) from "NYTS 2012 Dataset" group by qn37g
,23069,
1,1589,
Blank is unchecked box, 1=checked box
----
eelcigt_r = RECODE: Ever used electronic cigarettes, such as Ruyan, njoy or Blu
select eelcigt_r, count(*) from "NYTS 2012 Dataset" group by eelcigt_r
,861,
1,1589,
2,22208,
Same 1589 "Yes" answers but they've processed the Blanks into "no" and blank somehow
----
ever e-cig use where ever cig use is yes
select eelcigt_r, count(*) from "NYTS 2012 Dataset" where ecigt_r = 1 group by eelcigt_r
,333,
1,1413,
2,4615,
----
ever e-cig use where ever cig use is no
select eelcigt_r, count(*) from "NYTS 2012 Dataset" where ecigt_r = 2 group by eelcigt_r
,455,
1,150,
2,17289,
(Theres the 150 - kids who tried e-cigs that never tried a cig
= 150/17439 = 0.86% of never-tried-cig had tried an e-cig (leaving out the 455 non-answers)
or
= 150/24,658 = 0.6% of all kids had tried an ecig but not a cig
----
Kids who have tried cigs - do they think they will try a cig in next year
select qn8, count(*) from "NYTS 2012 Dataset" where ecigt_r = 1 group by qn8
,15,
1,1349,
2,1410,
3,1533,
4,2054,
----
Kids who have tried e-cigs - do they think they will try a cig in next year
select qn8, count(*) from "NYTS 2012 Dataset" where eelcigt_r = 1 group by qn8
,6,
1,576, (1= defyes
2,403, (2=probyes
3,308, (3=probno
4,296, (4=defno
576+403=979 / 1583 total = 61.8%
----
Kids who currently (tried in last 30 days) ecigs - think they will smoke cig in next year
select qn8, count(*) from "NYTS 2012 Dataset" where celcigt_r = 1 group by qn8
,3,
1,254,
2,124,
3,66,
4,53,
254+124= 378 yes / 497 total = 76.05% who used ecig in last 30 days expect to try cig this year.
-----
How many of those kids are already frequently smoking cigs?
Kids who used ecig in last 30 days - how many days did you smoke cigs? in the last 30 days
select qn13, count(*) from "NYTS 2012 Dataset" where celcigt_r = 1 group by qn13
,19,
1,108, (26%)
2,58, (13.8%)
3,45, (10.7%)
4,28, (6.7%)
5,60, (14.3%)
6,48, (11.4%)
7,134, (32%)
(419 total)
qn13 - past 30 days - how many days did you smoke cigs?
1 0 days
2 1 or 2 days
3 3 to 5 days
4 6 to 9 days
5 10 to 19 days
6 20 to 29 days
7 All 30 days
So - 74% of these kids smoke monthly, weekly, daily -
and 76% expect they will smoke again within a year - Brilliant.
-----
OK .... so how many kids who used an ecig in last 30 days - but didn't use cigs in the last 30 days
- think they will smoke cigs in the next year
select qn8, count(*) from "NYTS 2012 Dataset" where celcigt_r = 1 and qn13 = 1 group by qn8
1,6,
2,21,
3,41,
4,40,
6+21=27 Yes out of 108 total = 25% - tried ecig in last 30 days, but not cigs - think they will try cigs in next year.
----
current (last 30 days) cig usage = smoking rate?
select ccigt_r, count(*) from "NYTS 2012 Dataset" group by ccigt_r
,480,
1,2247,
2,21931,
= 9.29%
----
what if we count all smoking?
select count(*) from "NYTS 2012 Dataset"
where ccigt_r=1 or ccigar_r =1 or cpipe_r=1 or cbidis_r = 1 or ckreteks_r = 1 or chookah_r = 1
3492,
= 14.44%
----
How many don't know how old they are?
select count(*) from "NYTS 2012 Dataset" where qn1 is null
103, (0.426%)
-----
How many in each grade?
select (qn3+5) as Grade, count(*) from "NYTS 2012 Dataset" group by qn3
,68,
6,3701,
7,4037,
8,3929,
9,3262,
10,3113,
11,3344,
12,3180,
13,24,
---
How Old are they?
select (qn1+8) as Age, count(*) from "NYTS 2012 Dataset" group by qn1
,103,
9,42,
10,6,
11,1423,
12,3566,
13,3995,
14,3595,
15,3185,
16,3245,
17,3374,
18,1948,
19,176,
Total responses in 2012 survey
24658
---
select qn7, count(*) from "NYTS 2012 Dataset" group by qn7
,403,
1,6361,
2,17894,
qn7 is "Tried cigarette smkg, even 1 or 2 puffs"
blank is no answer - 403 kids
1 is Yes
2 is No
----
select qn8, count(*) from "NYTS 2012 Dataset" group by qn8
,108, (blank answer)
1,1385, (definitely yes)
2,1686, (Probably yes)
3,4386, (probably no)
4,17093, (definitely no)
qn8 = "Think will smoke a cigarette anytime during next year"
----
Have tried cigs before - will try again this year?
select qn8, count(*) from "NYTS 2012 Dataset" where qn7 = 1 group by qn8
,15,
1,1349,
2,1410,
3,1533,
4,2054,
-----
have not tried cigs - will try this year?
select qn8, count(*) from "NYTS 2012 Dataset" where qn7 = 2 group by qn8
,27,
1,17,
2,249,
3,2728,
4,14873,
----
qn37g is EVER TRIED: e-cigt (e.g. Ruyan)
select qn37g, count(*) from "NYTS 2012 Dataset" group by qn37g
,23069,
1,1589,
Blank is unchecked box, 1=checked box
----
eelcigt_r = RECODE: Ever used electronic cigarettes, such as Ruyan, njoy or Blu
select eelcigt_r, count(*) from "NYTS 2012 Dataset" group by eelcigt_r
,861,
1,1589,
2,22208,
Same 1589 "Yes" answers but they've processed the Blanks into "no" and blank somehow
----
ever e-cig use where ever cig use is yes
select eelcigt_r, count(*) from "NYTS 2012 Dataset" where ecigt_r = 1 group by eelcigt_r
,333,
1,1413,
2,4615,
----
ever e-cig use where ever cig use is no
select eelcigt_r, count(*) from "NYTS 2012 Dataset" where ecigt_r = 2 group by eelcigt_r
,455,
1,150,
2,17289,
(Theres the 150 - kids who tried e-cigs that never tried a cig
= 150/17439 = 0.86% of never-tried-cig had tried an e-cig (leaving out the 455 non-answers)
or
= 150/24,658 = 0.6% of all kids had tried an ecig but not a cig
----
Kids who have tried cigs - do they think they will try a cig in next year
select qn8, count(*) from "NYTS 2012 Dataset" where ecigt_r = 1 group by qn8
,15,
1,1349,
2,1410,
3,1533,
4,2054,
----
Kids who have tried e-cigs - do they think they will try a cig in next year
select qn8, count(*) from "NYTS 2012 Dataset" where eelcigt_r = 1 group by qn8
,6,
1,576, (1= defyes
2,403, (2=probyes
3,308, (3=probno
4,296, (4=defno
576+403=979 / 1583 total = 61.8%
----
Kids who currently (tried in last 30 days) ecigs - think they will smoke cig in next year
select qn8, count(*) from "NYTS 2012 Dataset" where celcigt_r = 1 group by qn8
,3,
1,254,
2,124,
3,66,
4,53,
254+124= 378 yes / 497 total = 76.05% who used ecig in last 30 days expect to try cig this year.
-----
How many of those kids are already frequently smoking cigs?
Kids who used ecig in last 30 days - how many days did you smoke cigs? in the last 30 days
select qn13, count(*) from "NYTS 2012 Dataset" where celcigt_r = 1 group by qn13
,19,
1,108, (26%)
2,58, (13.8%)
3,45, (10.7%)
4,28, (6.7%)
5,60, (14.3%)
6,48, (11.4%)
7,134, (32%)
(419 total)
qn13 - past 30 days - how many days did you smoke cigs?
1 0 days
2 1 or 2 days
3 3 to 5 days
4 6 to 9 days
5 10 to 19 days
6 20 to 29 days
7 All 30 days
So - 74% of these kids smoke monthly, weekly, daily -
and 76% expect they will smoke again within a year - Brilliant.
-----
OK .... so how many kids who used an ecig in last 30 days - but didn't use cigs in the last 30 days
- think they will smoke cigs in the next year
select qn8, count(*) from "NYTS 2012 Dataset" where celcigt_r = 1 and qn13 = 1 group by qn8
1,6,
2,21,
3,41,
4,40,
6+21=27 Yes out of 108 total = 25% - tried ecig in last 30 days, but not cigs - think they will try cigs in next year.
----
current (last 30 days) cig usage = smoking rate?
select ccigt_r, count(*) from "NYTS 2012 Dataset" group by ccigt_r
,480,
1,2247,
2,21931,
= 9.29%
----
what if we count all smoking?
select count(*) from "NYTS 2012 Dataset"
where ccigt_r=1 or ccigar_r =1 or cpipe_r=1 or cbidis_r = 1 or ckreteks_r = 1 or chookah_r = 1
3492,
= 14.44%
----
How many don't know how old they are?
select count(*) from "NYTS 2012 Dataset" where qn1 is null
103, (0.426%)
-----
How many in each grade?
select (qn3+5) as Grade, count(*) from "NYTS 2012 Dataset" group by qn3
,68,
6,3701,
7,4037,
8,3929,
9,3262,
10,3113,
11,3344,
12,3180,
13,24,
---
How Old are they?
select (qn1+8) as Age, count(*) from "NYTS 2012 Dataset" group by qn1
,103,
9,42,
10,6,
11,1423,
12,3566,
13,3995,
14,3595,
15,3185,
16,3245,
17,3374,
18,1948,
19,176,
