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 = "40104"
40104 0 111TH AVE / 
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
        STATE: 4
      ST_CASE: 40104
     VE_TOTAL: 1
     VE_FORMS: 1
     PVH_INVL: 0
         PEDS: 1
   PERNOTMVIT: 1
      PERMVIT: 1
      PERSONS: 1
       COUNTY: 13
         CITY: 0
          DAY: 4
        MONTH: 2
         YEAR: 2015
     DAY_WEEK: 4
         HOUR: 16
       MINUTE: 46
          NHS: 0
      RUR_URB: 2
     FUNC_SYS: 5
     RD_OWNER: 2
        ROUTE: 6
      TWAY_ID: 111TH AVE
     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: 99
      NOT_MIN: 99
     ARR_HOUR: 99
      ARR_MIN: 99
      HOSP_HR: 99
      HOSP_MN: 99
          CF1: 0
          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: 40104
   VE_FORMS: 1
     VEH_NO: 0
     PER_NO: 1
    STR_VEH: 1
     COUNTY: 13
        DAY: 4
      MONTH: 2
       HOUR: 16
     MINUTE: 46
    RUR_URB: 2
   FUNC_SYS: 5
    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: 73
        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: 9
 ALC_STATUS: 0
   ATST_TYP: 0
    ALC_RES: 996
      DRUGS: 0
   DRUG_DET: 8
    DSTATUS: 0
   DRUGTST1: 0
   DRUGTST2: 0
   DRUGTST3: 0
   DRUGRES1: 0
   DRUGRES2: 0
   DRUGRES3: 0
   HOSPITAL: 3
        DOA: 0
   DEATH_DA: 17
   DEATH_MO: 2
   DEATH_YR: 2015
   DEATH_HR: 13
   DEATH_MN: 45
   DEATH_TM: 1345
    LAG_HRS: 308
   LAG_MINS: 59
      P_SF1: 0
      P_SF2: 0
      P_SF3: 0
   WORK_INJ: 0
   HISPANIC: 7
       RACE: 1
   LOCATION: 11
   ROAD_FNC: NULL
    CERT_NO: NULL
   eRUR_URB: Urban
  eDRINKING: No (Alcohol Not Involved)
   eALC_DET: Not Reported
eALC_STATUS: Test Not Given
  eATST_TYP: Test Not Given
   sALC_RES: No data
   eINJ_SEV: Fatal Injury (K)
   ePER_TYP: Bicyclist
  eLOCATION: Non-Intersection - On Roadway, Not in Crosswalk
       YEAR: 2015
*************************** 2. row ***************************
      STATE: 4
    ST_CASE: 40104
   VE_FORMS: 1
     VEH_NO: 1
     PER_NO: 1
    STR_VEH: 0
     COUNTY: 13
        DAY: 4
      MONTH: 2
       HOUR: 16
     MINUTE: 46
    RUR_URB: 2
   FUNC_SYS: 5
    HARM_EV: 9
   MAN_COLL: 0
    SCH_BUS: 0
       MAKE: 51
    MAK_MOD: 51401
   BODY_TYP: 14
   MOD_YEAR: 2004
    TOW_VEH: 0
   SPEC_USE: 0
   EMER_USE: 0
   ROLLOVER: 0
    IMPACT1: 12
   FIRE_EXP: 0
        AGE: 30
        SEX: 1
    PER_TYP: 1
    INJ_SEV: 0
   SEAT_POS: 11
   REST_USE: 3
   REST_MIS: 0
    AIR_BAG: 20
   EJECTION: 0
    EJ_PATH: 0
   EXTRICAT: 0
   DRINKING: 0
    ALC_DET: 2
 ALC_STATUS: 2
   ATST_TYP: 10
    ALC_RES: 0
      DRUGS: 0
   DRUG_DET: 2
    DSTATUS: 0
   DRUGTST1: 0
   DRUGTST2: 0
   DRUGTST3: 0
   DRUGRES1: 0
   DRUGRES2: 0
   DRUGRES3: 0
   HOSPITAL: 0
        DOA: 0
   DEATH_DA: 88
   DEATH_MO: 88
   DEATH_YR: 8888
   DEATH_HR: 88
   DEATH_MN: 88
   DEATH_TM: 8888
    LAG_HRS: 999
   LAG_MINS: 99
      P_SF1: 0
      P_SF2: 0
      P_SF3: 0
   WORK_INJ: 8
   HISPANIC: 0
       RACE: 0
   LOCATION: 0
   ROAD_FNC: NULL
    CERT_NO: NULL
   eRUR_URB: Urban
  eDRINKING: No (Alcohol Not Involved)
   eALC_DET: Preliminary Breath Test (PBT)
eALC_STATUS: Test Given
  eATST_TYP: Preliminary Breath Test (PBT)
   sALC_RES: Tested, negative
   eINJ_SEV: No Injury (O)
   ePER_TYP: Driver of a Motor Vehicle In-Transport
  eLOCATION: Occupant of a Motor Vehicle
       YEAR: 2015
*************************** 1. row ***************************
    STATE: 4
  ST_CASE: 40104
   VEH_NO: 1
 VE_FORMS: 1
  NUMOCCS: 1
      DAY: 4
    MONTH: 2
     HOUR: 16
   MINUTE: 46
  HARM_EV: 9
 MAN_COLL: 0
 UNITTYPE: 1
  HIT_RUN: 0
 REG_STAT: 4
    OWNER: 1
     MAKE: 51
    MODEL: 401
  MAK_MOD: 51401
 BODY_TYP: 14
 MOD_YEAR: 2004
      VIN: YV1CM91H7410
    VIN_1: Y
    VIN_2: V
    VIN_3: 1
    VIN_4: C
    VIN_5: M
    VIN_6: 9
    VIN_7: 1
    VIN_8: H
    VIN_9: 7
   VIN_10: 4
   VIN_11: 1
   VIN_12: 0
  TOW_VEH: 0
  J_KNIFE: 0
 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: 52
 UNDERIDE: 0
 ROLLOVER: 0
 ROLINLOC: 0
  IMPACT1: 12
 DEFORMED: 4
    TOWED: 5
   M_HARM: 9
  VEH_SC1: 0
  VEH_SC2: 0
 FIRE_EXP: 0
  DR_PRES: 1
  L_STATE: 4
   DR_ZIP: 85007
 L_STATUS: 6
   L_TYPE: 1
 CDL_STAT: 0
 L_ENDORS: 0
  L_COMPL: 3
 L_RESTRI: 3
   DR_HGT: 68
   DR_WGT: 160
 PREV_ACC: 0
 PREV_SUS: 0
 PREV_DWI: 0
 PREV_SPD: 0
 PREV_OTH: 0
 FIRST_MO: 0
 FIRST_YR: 0
  LAST_MO: 0
  LAST_YR: 0
 SPEEDREL: 3
   DR_SF1: 0
   DR_SF2: 0
   DR_SF3: 0
   DR_SF4: 0
 VTRAFWAY: 1
 VNUM_LAN: 4
 VSPD_LIM: 35
   VALIGN: 1
 VPROFILE: 1
 VPAVETYP: 2
 VSURCOND: 1
 VTRAFCON: 0
 VTCONT_F: 0
 P_CRASH1: 1
 P_CRASH2: 83
 P_CRASH3: 7
  PCRASH4: 1
  PCRASH5: 2
 ACC_TYPE: 13
   DEATHS: 0
 DR_DRINK: 0
   sModel: Light Trucks
     YEAR: 2015
eP_CRASH1: Going Straight
*************************** 1. row ***************************
         STATE: 4
       ST_CASE: 40104
        VEH_NO: 0
        PER_NO: 1
       PBPTYPE: 6
         PBAGE: 73
         PBSEX: 1
sBikeCrashType: Bicyclist Did Not Yield
      ePBPTYPE: Bicyclist
        ePBSEX: Male
      eBIKEDIR: With Traffic
      eBIKEPOS: Travel lane
      eBIKELOC: Non-intersection
      eBIKECGP: Bicyclist Left Turn / Merge
    eBIKECTYPE: Bicyclist Left Turn - Same Direction
      ePBSZONE: No
      ePBSWALK: Unknown
      ePBCWALK: No
       PBCWALK: 0
       PBSWALK: 9
       PBSZONE: 0
      PEDCTYPE: 0
     BIKECTYPE: 221
        PEDLOC: 7
       BIKELOC: 3
        PEDPOS: 77
       BIKEPOS: 1
        PEDDIR: 7
       BIKEDIR: 1
        MOTDIR: 7
        MOTMAN: 7
        PEDLEG: 7
        PEDSNR: 7
        PEDCGP: 0
       BIKECGP: 220
          YEAR: 2015