Dump the FARS crash record by ST_CASE

using sql server: azbikelaw.entrydns.org
dump another Case

query is: SELECT ST_CASE, CITY, TWAY_ID, TWAY_ID2 FROM 2015_incident WHERE ST_CASE = "40482"
40482 0 PINNACLE PEAK RD / 
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
        STATE: 4
      ST_CASE: 40482
     VE_TOTAL: 1
     VE_FORMS: 1
     PVH_INVL: 0
         PEDS: 1
   PERNOTMVIT: 1
      PERMVIT: 0
      PERSONS: 0
       COUNTY: 13
         CITY: 0
          DAY: 24
        MONTH: 7
         YEAR: 2015
     DAY_WEEK: 6
         HOUR: 6
       MINUTE: 21
          NHS: 0
      RUR_URB: 2
     FUNC_SYS: 7
     RD_OWNER: 99
        ROUTE: 9
      TWAY_ID: PINNACLE PEAK RD
     TWAY_ID2: 
       MILEPT: 0
     LATITUDE: 34
     LONGITUD: -112
       SP_JUR: 0
      HARM_EV: 9
     MAN_COLL: 0
      RELJCT1: 0
      RELJCT2: 1
      TYP_INT: 1
     WRK_ZONE: 0
     REL_ROAD: 1
     LGT_COND: 1
     WEATHER1: 1
     WEATHER2: 0
      WEATHER: 1
      SCH_BUS: 0
         RAIL: 0000000
     NOT_HOUR: 6
      NOT_MIN: 26
     ARR_HOUR: 6
      ARR_MIN: 40
      HOSP_HR: 7
      HOSP_MN: 2
          CF1: 16
          CF2: 0
          CF3: 0
       FATALS: 1
     DRUNK_DR: 0
    eLGT_COND: Daylight
    sLighting: Daylight
     ROAD_FNC: 7777
    eROAD_FNC: NOT DEFINED FOR YEARS AFTER 2014
     eRUR_URB: Urban
  sUrbanRural: Urban
    eMAN_COLL: Not a Collision with Motor Vehicle In-Transport
     eHARM_EV: Pedalcyclist
     eTYP_INT: Not an Intersection
     eRELJCT1: No
     eRELJCT2: Non-Junction
    eREL_ROAD: On Roadway
   sF_Bicycle: 1
sF_Pedestrian: 0
  sF_Motorist: 0
  sF_OtherUnk: 0
sF_Motorcycle: 0
     sHit_Run: NULL
       sModel: Light Trucks
*************************** 1. row ***************************
      STATE: 4
    ST_CASE: 40482
   VE_FORMS: 1
     VEH_NO: 0
     PER_NO: 1
    STR_VEH: 1
     COUNTY: 13
        DAY: 24
      MONTH: 7
       HOUR: 6
     MINUTE: 21
    RUR_URB: 2
   FUNC_SYS: 7
    HARM_EV: 9
   MAN_COLL: 0
    SCH_BUS: 0
       MAKE: 0
    MAK_MOD: 0
   BODY_TYP: 0
   MOD_YEAR: 0
    TOW_VEH: 0
   SPEC_USE: 0
   EMER_USE: 0
   ROLLOVER: 0
    IMPACT1: 0
   FIRE_EXP: 0
        AGE: 68
        SEX: 1
    PER_TYP: 6
    INJ_SEV: 4
   SEAT_POS: 0
   REST_USE: 96
   REST_MIS: 8
    AIR_BAG: 97
   EJECTION: 8
    EJ_PATH: 0
   EXTRICAT: 0
   DRINKING: 0
    ALC_DET: 1
 ALC_STATUS: 2
   ATST_TYP: 1
    ALC_RES: 0
      DRUGS: 0
   DRUG_DET: 1
    DSTATUS: 2
   DRUGTST1: 1
   DRUGTST2: 0
   DRUGTST3: 0
   DRUGRES1: 1
   DRUGRES2: 0
   DRUGRES3: 0
   HOSPITAL: 5
        DOA: 0
   DEATH_DA: 24
   DEATH_MO: 7
   DEATH_YR: 2015
   DEATH_HR: 8
   DEATH_MN: 6
   DEATH_TM: 806
    LAG_HRS: 1
   LAG_MINS: 45
      P_SF1: 0
      P_SF2: 0
      P_SF3: 0
   WORK_INJ: 0
   HISPANIC: 7
       RACE: 1
   LOCATION: 16
   ROAD_FNC: NULL
    CERT_NO: NULL
   eRUR_URB: Urban
  eDRINKING: No (Alcohol Not Involved)
   eALC_DET: Evidential Test (breath, blood, urine)
eALC_STATUS: Test Given
  eATST_TYP: Blood
   sALC_RES: Tested, negative
   eINJ_SEV: Fatal Injury (K)
   ePER_TYP: Bicyclist
  eLOCATION: Bicycle Lane
       YEAR: 2015
*************************** 1. row ***************************
    STATE: 4
  ST_CASE: 40482
   VEH_NO: 1
 VE_FORMS: 1
  NUMOCCS: 0
      DAY: 24
    MONTH: 7
     HOUR: 6
   MINUTE: 21
  HARM_EV: 9
 MAN_COLL: 0
 UNITTYPE: 1
  HIT_RUN: 0
 REG_STAT: 4
    OWNER: 3
     MAKE: 20
    MODEL: 481
  MAK_MOD: 20481
 BODY_TYP: 31
 MOD_YEAR: 2011
      VIN: 1GC0CVCG1BF1
    VIN_1: 1
    VIN_2: G
    VIN_3: C
    VIN_4: 0
    VIN_5: C
    VIN_6: V
    VIN_7: C
    VIN_8: G
    VIN_9: 1
   VIN_10: B
   VIN_11: F
   VIN_12: 1
  TOW_VEH: 1
  J_KNIFE: 1
 MCARR_I1: 0
 MCARR_I2: 000000000
 MCARR_ID: 00000000000
     GVWR: 0
 V_CONFIG: 0
 CARGO_BT: 0
  HAZ_INV: 1
 HAZ_PLAC: 0
   HAZ_ID: 0
  HAZ_CNO: 0
  HAZ_REL: 0
  BUS_USE: 0
 SPEC_USE: 0
 EMER_USE: 0
  TRAV_SP: 0
 UNDERIDE: 0
 ROLLOVER: 0
 ROLINLOC: 0
  IMPACT1: 6
 DEFORMED: 2
    TOWED: 5
   M_HARM: 9
  VEH_SC1: 0
  VEH_SC2: 0
 FIRE_EXP: 0
  DR_PRES: 0
  L_STATE: 0
   DR_ZIP: 99997
 L_STATUS: 7
   L_TYPE: 6
 CDL_STAT: 97
 L_ENDORS: 7
  L_COMPL: 6
 L_RESTRI: 7
   DR_HGT: 998
   DR_WGT: 997
 PREV_ACC: 998
 PREV_SUS: 998
 PREV_DWI: 998
 PREV_SPD: 998
 PREV_OTH: 998
 FIRST_MO: 98
 FIRST_YR: 9998
  LAST_MO: 98
  LAST_YR: 9998
 SPEEDREL: 8
   DR_SF1: 0
   DR_SF2: 0
   DR_SF3: 0
   DR_SF4: 0
 VTRAFWAY: 5
 VNUM_LAN: 3
 VSPD_LIM: 40
   VALIGN: 1
 VPROFILE: 1
 VPAVETYP: 2
 VSURCOND: 1
 VTRAFCON: 0
 VTCONT_F: 0
 P_CRASH1: 0
 P_CRASH2: 83
 P_CRASH3: 0
  PCRASH4: 0
  PCRASH5: 0
 ACC_TYPE: 98
   DEATHS: 0
 DR_DRINK: 0
   sModel: Light Trucks
     YEAR: 2015
eP_CRASH1: No Driver Present / Unknown if Driver Present
*************************** 1. row ***************************
         STATE: 4
       ST_CASE: 40482
        VEH_NO: 0
        PER_NO: 1
       PBPTYPE: 6
         PBAGE: 68
         PBSEX: 1
sBikeCrashType: Head On
      ePBPTYPE: Bicyclist
        ePBSEX: Male
      eBIKEDIR: With Traffic
      eBIKEPOS: Bike Lane / Paved Shoulder
      eBIKELOC: Non-intersection
      eBIKECGP: Bicyclist Overtaking Motorist
    eBIKECTYPE: Bicyclist Overtaking - Other / Unknown
      ePBSZONE: No
      ePBSWALK: Yes
      ePBCWALK: No
       PBCWALK: 0
       PBSWALK: 1
       PBSZONE: 0
      PEDCTYPE: 0
     BIKECTYPE: 249
        PEDLOC: 7
       BIKELOC: 3
        PEDPOS: 77
       BIKEPOS: 2
        PEDDIR: 7
       BIKEDIR: 1
        MOTDIR: 7
        MOTMAN: 7
        PEDLEG: 7
        PEDSNR: 7
        PEDCGP: 0
       BIKECGP: 240
          YEAR: 2015