Ad Hoc Query - Select Columns

Ad Hoc Query for RSA-661

Choose the columns you wish to query by checking the box.

If you wish to limit the selection, enter the criteria in the input boxes.

In setting the criteria, you may use the abbreviation in the 'Abbr' column (with the square brackets) in your comparisons or any numeric expression.

Abbr		Column Name	=	Criteria
		State Code	=<>containsdoesn't contain
		State Name	=not	AlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyomingAmerican SamoaGuamNorthern MarianasPuerto RicoVirgin Islands
		FY	=>>=<<=
		Pr Award Id	=<>containsdoesn't contain
		Status	=	Published
		Grantee Name	=<>containsdoesn't contain
		Header Info	=<>containsdoesn't contain
		Section 1 Agency Name	=<>containsdoesn't contain
		Section 1 Addr Main	Not BlankBlank
		Section 1 Addr Satellite	Not BlankBlank
		Section 1 Addr Contract	Not BlankBlank
		Section 1 Agency Phone	=<>containsdoesn't contain
		Section 1 Agency Tollfree Phone	=<>containsdoesn't contain
		Section 1 Agency Tty	=<>containsdoesn't contain
		Section 1 Agency Tollfree Tty	=<>containsdoesn't contain
		Section 1 Agency Fax	=<>containsdoesn't contain
		Section 1 Agency Email	=<>containsdoesn't contain
		Section 1 Agency Web	=<>containsdoesn't contain
		Section 1 Exec Director Name	=<>containsdoesn't contain
		Section 1 Exec Director Email	=<>containsdoesn't contain
		Section 1 Staff Preparing Name	=<>containsdoesn't contain
		Section 1 Staff Preparing Email	=<>containsdoesn't contain
		Section 1 Staff Preparing Location	=<>containsdoesn't contain
		Section 2 P1a Ir Individuals Receiving	=>>=<<=
		Section 2 P1a Ir Number Requests	=>>=<<=
		Section 2 P1b Training Num By Staff	=>>=<<=
		Section 2 P1b Training Num Attendees	=>>=<<=
		Section 2 P1b Training 1a Topcis	Not BlankBlank
		Section 2 P1b Training 1b Purpose	Not BlankBlank
		Section 2 P1b Training 1c Attendees	Not BlankBlank
		Section 2 P1b Training 2a Topcis	Not BlankBlank
		Section 2 P1b Training 2b Purpose	Not BlankBlank
		Section 2 P1b Training 2c Attendees	Not BlankBlank
		Section 2 P1b Outreach	Not BlankBlank
		Section 2 P1c Radio And Tv	=>>=<<=
		Section 2 P1c Articles Prepared	=>>=<<=
		Section 2 P1c Psa Video Aired	=>>=<<=
		Section 2 P1c Website Hits	=>>=<<=
		Section 2 P1c Pubs Disseminated	=>>=<<=
		Section 2 P1c Pubs Number Receiving	=>>=<<=
		Section 2 P1c Other	=>>=<<=
		Section 2 P1c Other Specify	Not BlankBlank
		Section 2 P1d Radiotv	Not BlankBlank
		Section 2 P1d News Mags Jour	Not BlankBlank
		Section 2 P1d Psa Video	Not BlankBlank
		Section 2 P1d Pubs Books Brochures	Not BlankBlank
		Section 3 P2a Individuals Prior Fy	=>>=<<=
		Section 3 P2a Individuals New Fy	=>>=<<=
		Section 3 P2a Individuals Total	=>>=<<=
		Section 3 P2a Num Cases Closed	=>>=<<=
		Section 3 P2a Num Individuals Closed	=>>=<<=
		Section 3 P2a Num Individuals Still Served	=>>=<<=
		Section 3 P2b Architectural Accessibility	=>>=<<=
		Section 3 P2b Education	=>>=<<=
		Section 3 P2b Employment Descrimination	=>>=<<=
		Section 3 P2b Ssi Ssdi Work Incentives	=>>=<<=
		Section 3 P2b Healthcare	=>>=<<=
		Section 3 P2b Healthcare Medicaid	=>>=<<=
		Section 3 P2b Healthcare Medicare	=>>=<<=
		Section 3 P2b Healthcare Private Insurance	=>>=<<=
		Section 3 P2b Healthcare Other	=>>=<<=
		Section 3 P2b Housing	=>>=<<=
		Section 3 P2b Post Secondary Education	=>>=<<=
		Section 3 P2b Rehabilitation Services	=>>=<<=
		Section 3 P2b Transportation	=>>=<<=
		Section 3 P2b Voting	=>>=<<=
		Section 3 P2b Voting Accessible	=>>=<<=
		Section 3 P2b Voting Registration	=>>=<<=
		Section 3 P2b Voting Other	=>>=<<=
		Section 3 P2b Other 1	=>>=<<=
		Section 3 P2b Other 2	=>>=<<=
		Section 3 P2b Total	=>>=<<=
		Section 3 P2b Voting Other Specify	=<>containsdoesn't contain
		Section 3 P2b Other 1 Specify	Not BlankBlank
		Section 3 P2b Other 2 Specify	Not BlankBlank
		Section 3 P2b Healthcare Other Specify	Not BlankBlank
		Section 3 P2c Number Individuals	=>>=<<=
		Section 3 P2c Communication	=>>=<<=
		Section 3 P2c Mobility	=>>=<<=
		Section 3 P2c Hearing Seeing	=>>=<<=
		Section 3 P2c Reading Writing	=>>=<<=
		Section 3 P2c Household Activites	=>>=<<=
		Section 3 P2c Play Recreation	=>>=<<=
		Section 3 P2c Personal Care	=>>=<<=
		Section 3 P2c Therapy Medical Treatment	=>>=<<=
		Section 3 P2c Transportation	=>>=<<=
		Section 3 P2c Employment	=>>=<<=
		Section 3 P2c School Learning	=>>=<<=
		Section 3 P2c At Services	=>>=<<=
		Section 3 P2c Other	=>>=<<=
		Section 3 P2c Total	=>>=<<=
		Section 3 P2c Other Specify	Not BlankBlank
		Section 3 P2d All In Clients Favor	=>>=<<=
		Section 3 P2d Some In Clients Favor	=>>=<<=
		Section 3 P2d Other Representation	=>>=<<=
		Section 3 P2d Withdrew Complaint	=>>=<<=
		Section 3 P2d Services Not Needed	=>>=<<=
		Section 3 P2d Individual Not Responsive	=>>=<<=
		Section 3 P2d Case Lacked Merit	=>>=<<=
		Section 3 P2d Conflict of Interest	=>>=<<=
		Section 3 P2d Lack of Resources	=>>=<<=
		Section 3 P2d Not Within Priorities	=>>=<<=
		Section 3 P2d Not In Clients Favor	=>>=<<=
		Section 3 P2d Other	=>>=<<=
		Section 3 P2d Total	=>>=<<=
		Section 3 P2d Other Specify	Not BlankBlank
		Section 3 P2e Short Term Assistance	=>>=<<=
		Section 3 P2e Systemic Policy Activities	=>>=<<=
		Section 3 P2e Investigation Monitoring	=>>=<<=
		Section 3 P2e Negotiation	=>>=<<=
		Section 3 P2e Mediation	=>>=<<=
		Section 3 P2e Administrative Hearing	=>>=<<=
		Section 3 P2e Legal Remedy Litigation	=>>=<<=
		Section 3 P2e Class Action Suit	=>>=<<=
		Section 3 P2e Total	=>>=<<=
		Section 4 P3a 0 To 4	=>>=<<=
		Section 4 P3a 5 To 13	=>>=<<=
		Section 4 P3a 14 To 18	=>>=<<=
		Section 4 P3a 19 To 21	=>>=<<=
		Section 4 P3a 22 To 40	=>>=<<=
		Section 4 P3a 41 To 64	=>>=<<=
		Section 4 P3a 65 Over	=>>=<<=
		Section 4 P3a Unknown	=>>=<<=
		Section 4 P3a Total	=>>=<<=
		Section 4 P3b Male	=>>=<<=
		Section 4 P3b Female	=>>=<<=
		Section 4 P3b Total	=>>=<<=
		Section 4 P3c American Indian Alaska	=>>=<<=
		Section 4 P3c Asian	=>>=<<=
		Section 4 P3c Black African American	=>>=<<=
		Section 4 P3c Hawaiian Pac Island	=>>=<<=
		Section 4 P3c White	=>>=<<=
		Section 4 P3c More Than One Race	=>>=<<=
		Section 4 P3c Unknown	=>>=<<=
		Section 4 P3c Total	=>>=<<=
		Section 4 P3c 2 Hispanic Latino	=>>=<<=
		Section 4 P3c 2 Non Hispanic Latino	=>>=<<=
		Section 4 P3c 2 Unknown	=>>=<<=
		Section 4 P3c 2 Total	=>>=<<=
		Section 4 P3d Community Home	=>>=<<=
		Section 4 P3d Foster Care	=>>=<<=
		Section 4 P3d Homeless Shelter	=>>=<<=
		Section 4 P3d Jail Prison	=>>=<<=
		Section 4 P3d Nursing Facility	=>>=<<=
		Section 4 P3d Parent Guardian Family	=>>=<<=
		Section 4 P3d Independent	=>>=<<=
		Section 4 P3d Private Institutional	=>>=<<=
		Section 4 P3d Public Institutional	=>>=<<=
		Section 4 P3d Public Housing	=>>=<<=
		Section 4 P3d Va Hospital	=>>=<<=
		Section 4 P3d Other 1	=>>=<<=
		Section 4 P3d Other 2	=>>=<<=
		Section 4 P3d Unknown	=>>=<<=
		Section 4 P3d Total	=>>=<<=
		Section 4 P3d Other 1 Specify	=<>containsdoesn't contain
		Section 4 P3d Other 2 Specify	=<>containsdoesn't contain
		Section 4 P3e Add Adhd	=>>=<<=
		Section 4 P3e Aids Hiv	=>>=<<=
		Section 4 P3e Abscence of Extremities	=>>=<<=
		Section 4 P3e Auto Immune	=>>=<<=
		Section 4 P3e Autism	=>>=<<=
		Section 4 P3e Blind	=>>=<<=
		Section 4 P3e Visual Impairment	=>>=<<=
		Section 4 P3e Cancer	=>>=<<=
		Section 4 P3e Cerebral Palsy	=>>=<<=
		Section 4 P3e Deafness	=>>=<<=
		Section 4 P3e Hearing Impaired	=>>=<<=
		Section 4 P3e Deaf Blind	=>>=<<=
		Section 4 P3e Diabetes	=>>=<<=
		Section 4 P3e Digestive Disorder	=>>=<<=
		Section 4 P3e Epilepsy	=>>=<<=
		Section 4 P3e Genitourinary	=>>=<<=
		Section 4 P3e Heart Circulatory	=>>=<<=
		Section 4 P3e Mental Illness	=>>=<<=
		Section 4 P3e Mental Retardation	=>>=<<=
		Section 4 P3e Multiple Sclerosis	=>>=<<=
		Section 4 P3e Muscular Dystrophy	=>>=<<=
		Section 4 P3e Muscular Skeletal	=>>=<<=
		Section 4 P3e Orthopedic	=>>=<<=
		Section 4 P3e Neurological	=>>=<<=
		Section 4 P3e Respiratory	=>>=<<=
		Section 4 P3e Skin Condition	=>>=<<=
		Section 4 P3e Specific Learning Disability	=>>=<<=
		Section 4 P3e Speech Impairment	=>>=<<=
		Section 4 P3e Spina Bifida	=>>=<<=
		Section 4 P3e Substance Abuse	=>>=<<=
		Section 4 P3e Tourette	=>>=<<=
		Section 4 P3e Brain Injury	=>>=<<=
		Section 4 P3e Other	=>>=<<=
		Section 4 P3e Total	=>>=<<=
		Section 4 P3e Other Specify	Not BlankBlank
		Section 4 P3f Urban Suburban	=>>=<<=
		Section 4 P3f Rural	=>>=<<=
		Section 4 P3f Other	=>>=<<=
		Section 4 P3f Unknown	=>>=<<=
		Section 4 P3f Total	=>>=<<=
		Section 4 P3f Other Specify	=<>containsdoesn't contain
		Section 5 P4b1 Total Resulting Change	=>>=<<=
		Section 5 P4b1 Num Newly Filed	=>>=<<=
		Section 5 P4b1 Num Pending	=>>=<<=
		Section 5 P4b1 Num Closed	=>>=<<=
		Section 5 P4b2 A	Not BlankBlank
		Section 5 P4b2 B	Not BlankBlank
		Section 5 P4b2 C	Not BlankBlank
		Section 5 P4b2 D	=>>=<<=
		Section 5 P4b2 E	Not BlankBlank
		Section 5 P4b3 A	Not BlankBlank
		Section 5 P4b3 B	Not BlankBlank
		Section 5 P4b3 C	Not BlankBlank
		Section 5 P4b3 D	=>>=<<=
		Section 5 P4b3 E	Not BlankBlank
		Section 5 P4b4 Total Filed	=>>=<<=
		Section 5 P4b4 Num Newly Filed	=>>=<<=
		Section 5 P4b4 Num Pending	=>>=<<=
		Section 5 P4b4 Num Closed	=>>=<<=
		Section 5 P4b5 A	Not BlankBlank
		Section 5 P4b5 B	Not BlankBlank
		Section 5 P4b5 C	Not BlankBlank
		Section 5 P4b5 D	=>>=<<=
		Section 5 P4b5 E	Not BlankBlank
		Section 5 P4b6 A	Not BlankBlank
		Section 5 P4b6 B	Not BlankBlank
		Section 5 P4b6 C	Not BlankBlank
		Section 5 P4b6 D	=>>=<<=
		Section 5 P4b6 E	Not BlankBlank
		Section 5 P4c1 Conduct Monitoring	=>>=<<=
		Section 5 P4c2 1	Not BlankBlank
		Section 5 P4c2 2	Not BlankBlank
		Section 5 P4c2 3	Not BlankBlank
		Section 5 P4c2 4	Not BlankBlank
		Section 6 P5c Significant Accomplishments	Not BlankBlank
		Section 7 P6a Federal Funds	=>>=<<=
		Section 7 P6a Program Income	=>>=<<=
		Section 7 P6a Other1	=>>=<<=
		Section 7 P6a Other1 Specify	Not BlankBlank
		Section 7 P6a Other2	=>>=<<=
		Section 7 P6a Other2 Specify	=<>containsdoesn't contain
		Section 7 P6a Other3	=>>=<<=
		Section 7 P6a Other3 Specify	=<>containsdoesn't contain
		Section 7 P6a Total	=>>=<<=
		Section 7 P6b Staffing Plan	Not BlankBlank
		Section 7 P6b Prof Fulltime Num	=>>=<<=
		Section 7 P6b Prof Parttime Num	=>>=<<=
		Section 7 P6b Admin Fulltime Num	=>>=<<=
		Section 7 P6b Admin Parttime Num	=>>=<<=
		Section 7 P6b Total Num	=>>=<<=
		Section 7 P6b Prof Fulltime Fte	=>>=<<=
		Section 7 P6b Prof Parttime Fte	=>>=<<=
		Section 7 P6b Admin Fulltime Fte	=>>=<<=
		Section 7 P6b Admin Parttime Fte	=>>=<<=
		Section 7 P6b Total Fte	=>>=<<=
		Section 7 P6c Consumer Responsive	Not BlankBlank
		Section 7 P6c Disability Agency Staff	=>>=<<=
		Section 7 P6c Family Agency Staff	=>>=<<=
		Section 7 P6c Agency Staff Total	=>>=<<=
		Section 7 P6c Disability Agency Board	=>>=<<=
		Section 7 P6c Family Agency Board	=>>=<<=
		Section 7 P6c Agency Board Total	=>>=<<=
		Section 7 P6d Num Paat Grievances	=<>containsdoesn't contain
		Section 7 P6e Collab P And A	Not BlankBlank
		Section 7 P6e Collab Other	Not BlankBlank
		Section 3 P2d Other Representation Specify	=<>containsdoesn't contain
		Section 5 P4a1 Num Changes	=>>=<<=
		Section 5 P4a3 Num Ongoing	=>>=<<=
		Section 5 P4b1 Total Pending End	=>>=<<=
		Section 7 P6a Carry Over	=>>=<<=
		User Id	=<>containsdoesn't contain
		Last Change Date	=<>containsdoesn't contain

Top of Main Content