AVPUSA DATABASE

Annual Report 4   Export to Excel  Export to Word
	Page   of 5      Records 1 to 3 of 14      Groups per page  1 2 3 4 5 10 20 50 All Year State Site & Age Group Level Workshops Participants Hours Inside Fac Outside Fac Youth Fac 1999 NV Prison -Adult Basic 1 16 22 0 2 0   Summary for State: NV (1 detail records)   SUM   1 16 22 0 2 0 2000 NE Prison -Adult Advanced 2 28 36 2 4 0       Basic 6 112 108 11 12 0       T4F 1 6 15 0 2 0   Summary for State: NE (3 detail records)   SUM   9 146 159 13 18 0   NY Prison -Adult Advanced 3 21 66 7 6 0   Summary for State: NY (1 detail records)   SUM   3 21 66 7 6 0 2001 FL Community-Adult Advanced 4 33 80 0 11 0       Basic 14 138 240 0 43 0       Mini 8 96 28 0 12 0       T4F 1 7 20 0 2 0   Summary for State: FL (4 detail records)   SUM   27 274 368 0 68 0   KY Community-Youth Basic 1 14 22 0 2 0   Summary for State: KY (1 detail records)   SUM   1 14 22 0 2 0   LA Community-Adult Basic 1 7 22 0 2 0     Prison -Adult Advanced 2 23 44 6 2 0       Basic 6 61 132 19 9 0       T4F 1 8 22 3 1 0   Summary for State: LA (4 detail records)   SUM   10 99 220 28 14 0   MA Prison -Adult Advanced 1 24 22 1 2 0       Basic 5 96 110 7 10 0       Mini 2 28 12 8 6 0   Summary for State: MA (3 detail records)   SUM   8 148 144 16 18 0   MD Prison -Adult Advanced 4 80 84 12 8 0       Basic 8 160 168 24 16 0   Summary for State: MD (2 detail records)   SUM   12 240 252 36 24 0   ME Prison -Adult Advanced 1 6 22 1 1 0       Basic 1 5 22 0 2 0   Summary for State: ME (2 detail records)   SUM   2 11 44 1 3 0   NE Prison -Adult Advanced 3 48 54 4 4 0       Basic 5 75 90 8 8 0       T4F 1 9 18 1 2 0   Summary for State: NE (3 detail records)   SUM   9 132 162 13 14 0   NY Community-Adult Advanced 1 10 22 0 4 0       Basic 7 67 154 0 18 0       Mini 1 15 12 0 3 0     Prison -Adult Advanced 48 603 1056 134 81 0       Basic 110 1766 2420 318 192 0       Mini 8 93 80 31 25 0       T4F 17 172 374 39 29 0     Special -Youth Basic 1 19 22 0 2 0   Summary for State: NY (8 detail records)   SUM   193 2745 4140 522 354 0   WY Prison -Adult Basic 1 12 18 1 3 0   Summary for State: WY (1 detail records)   SUM   1 12 18 1 3 0 Grand Total (575 detail records) SUM   4879 69380 96009 11502 9137 286

(Popup SQL): SELECT DISTINCT [Year] FROM [Workshops by site-age] ORDER BY [Year]
(Popup SQL): SELECT DISTINCT [State] FROM [Workshops by site-age] ORDER BY [State]
(Group SQL): SELECT DISTINCT [Year] FROM [Workshops by site-age] ORDER BY [Year] ASC
(Detail SQL): SELECT [Year], [State], [Site-Age], [Level], [Workshops], [Participants], [Hours], [Inside Fac], [Outside Fac], [Youth Fac] FROM [Workshops by site-age] WHERE ([Year] = 1999) ORDER BY [Year] ASC, [State] ASC, [Site-Age] ASC
(Detail SQL): SELECT [Year], [State], [Site-Age], [Level], [Workshops], [Participants], [Hours], [Inside Fac], [Outside Fac], [Youth Fac] FROM [Workshops by site-age] WHERE ([Year] = 2000) ORDER BY [Year] ASC, [State] ASC, [Site-Age] ASC
(Detail SQL): SELECT [Year], [State], [Site-Age], [Level], [Workshops], [Participants], [Hours], [Inside Fac], [Outside Fac], [Youth Fac] FROM [Workshops by site-age] WHERE ([Year] = 2001) ORDER BY [Year] ASC, [State] ASC, [Site-Age] ASC
(Total SQL): SELECT COUNT(*) FROM [Workshops by site-age]
(Aggregate SQL): SELECT SUM([Workshops]) AS [sum_workshops], SUM([Participants]) AS [sum_participants], SUM([Hours]) AS [sum_hours], SUM([Inside Fac]) AS [sum_inside_fac], SUM([Outside Fac]) AS [sum_outside_fac], SUM([Youth Fac]) AS [sum_youth_fac] FROM [Workshops by site-age]
(Total SQL): SELECT COUNT(*) FROM [Workshops by site-age]
(Aggregate SQL): SELECT SUM([Workshops]) AS [sum_workshops], SUM([Participants]) AS [sum_participants], SUM([Hours]) AS [sum_hours], SUM([Inside Fac]) AS [sum_inside_fac], SUM([Outside Fac]) AS [sum_outside_fac], SUM([Youth Fac]) AS [sum_youth_fac] FROM [Workshops by site-age]