Dump the FARS crash record by ST_CASE

php ver: 70215 using sql server: azbikelaw.entrydns.org
dump another Case

query is: SELECT ST_CASE, CITY, TWAY_ID, TWAY_ID2 FROM 2016_incident WHERE ST_CASE = "40501"
40501 530 VALENCIA RD / NEXUS DR
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
        STATE: 4
      ST_CASE: 40501
     VE_TOTAL: 1
     VE_FORMS: 1
     PVH_INVL: 0
         PEDS: 1
   PERNOTMVIT: 1
      PERMVIT: 1
      PERSONS: 1
       COUNTY: 19
         CITY: 530
          DAY: 12
        MONTH: 8
         YEAR: 2016
     DAY_WEEK: 6
         HOUR: 17
       MINUTE: 55
          NHS: 0
      RUR_URB: 2
     FUNC_SYS: 3
     RD_OWNER: 4
        ROUTE: 6
      TWAY_ID: VALENCIA RD
     TWAY_ID2: NEXUS DR
       MILEPT: 0
     LATITUDE: 32.11909167
     LONGITUD: -110.797
       SP_JUR: 0
      HARM_EV: 9
     MAN_COLL: 0
      RELJCT1: 0
      RELJCT2: 3
      TYP_INT: 3
     WRK_ZONE: 0
     REL_ROAD: 1
     LGT_COND: 1
     WEATHER1: 1
     WEATHER2: 0
      WEATHER: 1
      SCH_BUS: 0
         RAIL: 0000000
     NOT_HOUR: 17
      NOT_MIN: 55
     ARR_HOUR: 17
      ARR_MIN: 59
      HOSP_HR: 18
      HOSP_MN: 53
          CF1: 0
          CF2: 0
          CF3: 0
       FATALS: 1
     DRUNK_DR: 1
    eLGT_COND: Daylight
    sLighting: Daylight
    eFUNC_SYS: Principal Arterial - Other
     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: T-Intersection
     eRELJCT1: No
     eRELJCT2: Intersection-Related
    eREL_ROAD: On Roadway
   sF_Bicycle: 1
sF_Pedestrian: 0
  sF_Motorist: 0
  sF_OtherUnk: 0
sF_Motorcycle: 0
     sHit_Run: 1
       sModel: Automobiles
*************************** 1. row ***************************
      STATE: 4
    ST_CASE: 40501
   VE_FORMS: 1
     VEH_NO: 1
     PER_NO: 1
    STR_VEH: 0
     COUNTY: 19
        DAY: 12
      MONTH: 8
       HOUR: 17
     MINUTE: 55
    RUR_URB: 2
   FUNC_SYS: 3
    HARM_EV: 9
   MAN_COLL: 0
    SCH_BUS: 0
       MAKE: 7
    MAK_MOD: 7026
   BODY_TYP: 4
   MOD_YEAR: 2013
    TOW_VEH: 0
   SPEC_USE: 0
   EMER_USE: 0
   ROLLOVER: 0
    IMPACT1: 12
   FIRE_EXP: 0
        AGE: 44
        SEX: 1
    PER_TYP: 1
    INJ_SEV: 0
   SEAT_POS: 11
   REST_USE: 7
   REST_MIS: 0
    AIR_BAG: 20
   EJECTION: 0
    EJ_PATH: 0
   EXTRICAT: 0
   DRINKING: 0
    ALC_DET: 9
 ALC_STATUS: 2
   ATST_TYP: 1
    ALC_RES: 313
      DRUGS: 1
   DRUG_DET: 8
    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: Not Reported
eALC_STATUS: Test Given
  eATST_TYP: Blood
   sALC_RES: Tested, positive intox
   eINJ_SEV: No Injury (O)
   ePER_TYP: Driver of a Motor Vehicle In-Transport
  eLOCATION: Occupant of a Motor Vehicle
       YEAR: 2016
*************************** 2. row ***************************
      STATE: 4
    ST_CASE: 40501
   VE_FORMS: 1
     VEH_NO: 0
     PER_NO: 1
    STR_VEH: 1
     COUNTY: 19
        DAY: 12
      MONTH: 8
       HOUR: 17
     MINUTE: 55
    RUR_URB: 2
   FUNC_SYS: 3
    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: 58
        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: 2
   ATST_TYP: 1
    ALC_RES: 0
      DRUGS: 0
   DRUG_DET: 8
    DSTATUS: 2
   DRUGTST1: 1
   DRUGTST2: 0
   DRUGTST3: 0
   DRUGRES1: 1
   DRUGRES2: 0
   DRUGRES3: 0
   HOSPITAL: 5
        DOA: 0
   DEATH_DA: 12
   DEATH_MO: 8
   DEATH_YR: 2016
   DEATH_HR: 18
   DEATH_MN: 31
   DEATH_TM: 1831
    LAG_HRS: 0
   LAG_MINS: 36
      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: Not Reported
eALC_STATUS: Test Given
  eATST_TYP: Blood
   sALC_RES: Tested, negative
   eINJ_SEV: Fatal Injury (K)
   ePER_TYP: Bicyclist
  eLOCATION: Bicycle Lane
       YEAR: 2016
*************************** 1. row ***************************
    STATE: 4
  ST_CASE: 40501
   VEH_NO: 1
 VE_FORMS: 1
  NUMOCCS: 1
      DAY: 12
    MONTH: 8
     HOUR: 17
   MINUTE: 55
  HARM_EV: 9
 MAN_COLL: 0
 UNITTYPE: 1
  HIT_RUN: 1
 REG_STAT: 4
    OWNER: 1
     MAKE: 7
    MODEL: 26
  MAK_MOD: 7026
 BODY_TYP: 4
 MOD_YEAR: 2013
      VIN: 1C3CDZAB0DN5
    VIN_1: 1
    VIN_2: C
    VIN_3: 3
    VIN_4: C
    VIN_5: D
    VIN_6: Z
    VIN_7: A
    VIN_8: B
    VIN_9: 0
   VIN_10: D
   VIN_11: N
   VIN_12: 5
  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: 45
 UNDERIDE: 0
 ROLLOVER: 0
 ROLINLOC: 0
  IMPACT1: 12
 DEFORMED: 2
    TOWED: 5
   M_HARM: 9
  VEH_SC1: 0
  VEH_SC2: 0
 FIRE_EXP: 0
  DR_PRES: 1
  L_STATE: 4
   DR_ZIP: 85746
 L_STATUS: 6
   L_TYPE: 1
 CDL_STAT: 0
 L_ENDORS: 0
  L_COMPL: 3
 L_RESTRI: 0
   DR_HGT: 67
   DR_WGT: 160
 PREV_ACC: 0
 PREV_SUS: 2
 PREV_DWI: 1
 PREV_SPD: 0
 PREV_OTH: 0
 FIRST_MO: 12
 FIRST_YR: 2011
  LAST_MO: 8
  LAST_YR: 2012
 SPEEDREL: 0
   DR_SF1: 39
   DR_SF2: 91
   DR_SF3: 0
   DR_SF4: 0
 VTRAFWAY: 1
 VNUM_LAN: 4
 VSPD_LIM: 45
   VALIGN: 1
 VPROFILE: 1
 VPAVETYP: 2
 VSURCOND: 1
 VTRAFCON: 3
 VTCONT_F: 3
 P_CRASH1: 1
 P_CRASH2: 83
 P_CRASH3: 99
  PCRASH4: 9
  PCRASH5: 3
 ACC_TYPE: 13
   DEATHS: 2147483647
 DR_DRINK: 2147483647
   sModel: Automobiles
     YEAR: 2016
eP_CRASH1: Going Straight
*************************** 1. row ***************************
         STATE: 4
       ST_CASE: 40501
        VEH_NO: 0
        PER_NO: 1
       PBPTYPE: 6
         PBAGE: 58
         PBSEX: 1
sBikeCrashType: Overtaking
      ePBPTYPE: Bicyclist
        ePBSEX: Male
      eBIKEDIR: With Traffic
      eBIKEPOS: Bike Lane / Paved Shoulder
      eBIKELOC: Intersection-Related
      eBIKECGP: Motorist Overtaking Bicyclist
    eBIKECTYPE: Motorist Overtaking - Misjudged Space
      ePBSZONE: No
      ePBSWALK: No
      ePBCWALK: Yes
       PBCWALK: 1
       PBSWALK: 0
       PBSZONE: 0
      PEDCTYPE: 0
     BIKECTYPE: 232
        PEDLOC: 7
       BIKELOC: 2
        PEDPOS: 77
       BIKEPOS: 2
        PEDDIR: 7
       BIKEDIR: 1
        MOTDIR: 7
        MOTMAN: 7
        PEDLEG: 7
        PEDSNR: 7
        PEDCGP: 0
       BIKECGP: 230
          YEAR: 2016