Dump the FARS crash record by ST_CASE

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

query is: SELECT ST_CASE, CITY, TWAY_ID, TWAY_ID2 FROM 2010_incident WHERE ST_CASE = "40264"
40264 490 MCCLINTOCK DR / ALAMEDA DR
Here is Stderr output (if any):

Query Results download:

*************************** 1. row ***************************
        STATE: 4
      ST_CASE: 40264
     VE_TOTAL: 1
     VE_FORMS: 1
         PEDS: 1
      PERSONS: 1
       COUNTY: 13
         CITY: 490
          DAY: 17
        MONTH: 5
         YEAR: 2010
     DAY_WEEK: 2
         HOUR: 17
       MINUTE: 25
          NHS: 0
     ROAD_FNC: 13
        ROUTE: 6
      TWAY_ID: MCCLINTOCK DR
     TWAY_ID2: ALAMEDA DR
       MILEPT: 0
     LATITUDE: 33.40014167
     LONGITUD: -111.90913333
       SP_JUR: 0
      HARM_EV: 9
     MAN_COLL: 0
      RELJCT1: 0
      RELJCT2: 2
      TYP_INT: 2
     REL_ROAD: 1
     WRK_ZONE: 0
     LGT_COND: 1
     WEATHER1: 1
     WEATHER2: 0
      WEATHER: 1
      SCH_BUS: 0
         RAIL: 0000000
     NOT_HOUR: 17
      NOT_MIN: 26
     ARR_HOUR: 17
      ARR_MIN: 29
      HOSP_HR: 17
      HOSP_MN: 53
          CF1: 0
          CF2: 0
          CF3: 0
       FATALS: 1
     DRUNK_DR: 0
    eLGT_COND: Daylight
    sLighting: Daylight
    eROAD_FNC: Urban-Other Principal Arterial
  sUrbanRural: Urban
    eMAN_COLL: Not a Collision with Motor Vehicle In-Transport
     eHARM_EV: Pedalcyclist
     eTYP_INT: Four-Way Intersection
     eRELJCT1: No
     eRELJCT2: Intersection
    eREL_ROAD: On Roadway
   sF_Bicycle: 1
sF_Pedestrian: 0
  sF_Motorist: 0
  sF_OtherUnk: 0
sF_Motorcycle: 0
     sHit_Run: NULL
       sModel: Automobiles
*************************** 1. row ***************************
      STATE: 4
    ST_CASE: 40264
   VE_FORMS: 1
     VEH_NO: 1
     PER_NO: 1
   N_MOT_NO: 0
     COUNTY: 13
        DAY: 17
      MONTH: 5
       HOUR: 17
     MINUTE: 25
   ROAD_FNC: 13
    HARM_EV: 9
   MAN_COLL: 0
    SCH_BUS: 0
       MAKE: 49
    MAK_MOD: 49032
   BODY_TYP: 4
   MOD_YEAR: 1999
    VINTYPE: P
    VINMAKE: TOYT
   VINA_MOD: UVL
     VIN_BT: 4D
   VINMODYR: 99
   VIN_LNGT: 17
    VIN_WGT: 2414
   WGTCD_TR: 2147483647
   WHLBS_LG: 0
   WHLBS_SH: 970
     SER_TR: 
   FUELCODE: G
   MCYCL_DS: 2147483647
    TOW_VEH: 0
   SPEC_USE: 0
   EMER_USE: 0
   ROLLOVER: 0
    IMPACT1: 12
    IMPACT2: 12
   FIRE_EXP: 0
        AGE: 20
        SEX: 2
    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: 9
 ALC_STATUS: 0
   ATST_TYP: 0
    ALC_RES: 96
      DRUGS: 0
   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
    CERT_NO: ************
   WORK_INJ: 8
   HISPANIC: 0
       RACE: 0
   LOCATION: 0
  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: No Injury (O)
   ePER_TYP: Driver of a Motor Vehicle In-Transport
  eLOCATION: Occupant of a Motor Vehicle
       YEAR: 2010
*************************** 2. row ***************************
      STATE: 4
    ST_CASE: 40264
   VE_FORMS: 1
     VEH_NO: 0
     PER_NO: 1
   N_MOT_NO: 1
     COUNTY: 13
        DAY: 17
      MONTH: 5
       HOUR: 17
     MINUTE: 25
   ROAD_FNC: 13
    HARM_EV: 9
   MAN_COLL: 0
    SCH_BUS: 0
       MAKE: 2147483647
    MAK_MOD: 2147483647
   BODY_TYP: 2147483647
   MOD_YEAR: 2147483647
    VINTYPE: 
    VINMAKE: 
   VINA_MOD: 
     VIN_BT: 
   VINMODYR: 2147483647
   VIN_LNGT: 2147483647
    VIN_WGT: 2147483647
   WGTCD_TR: 2147483647
   WHLBS_LG: 2147483647
   WHLBS_SH: 2147483647
     SER_TR: 
   FUELCODE: 
   MCYCL_DS: 2147483647
    TOW_VEH: 2147483647
   SPEC_USE: 2147483647
   EMER_USE: 2147483647
   ROLLOVER: 2147483647
    IMPACT1: 2147483647
    IMPACT2: 2147483647
   FIRE_EXP: 2147483647
        AGE: 36
        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: 348
   DRUGRES2: 0
   DRUGRES3: 0
   HOSPITAL: 5
        DOA: 0
   DEATH_DA: 17
   DEATH_MO: 5
   DEATH_YR: 2010
   DEATH_HR: 99
   DEATH_MN: 99
   DEATH_TM: 9999
    LAG_HRS: 999
   LAG_MINS: 99
      P_SF1: 0
      P_SF2: 0
      P_SF3: 0
    CERT_NO: ************
   WORK_INJ: 0
   HISPANIC: 99
       RACE: 99
   LOCATION: 3
  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: Intersection - Not In Crosswalk
       YEAR: 2010
*************************** 1. row ***************************
    STATE: 4
  ST_CASE: 40264
   VEH_NO: 1
 VE_FORMS: 1
  NUMOCCS: 1
      DAY: 17
    MONTH: 5
     HOUR: 17
   MINUTE: 25
  HARM_EV: 9
 MAN_COLL: 0
 UNITTYPE: 1
  HIT_RUN: 0
 REG_STAT: 4
    OWNER: 2
     MAKE: 49
    MODEL: 32
  MAK_MOD: 49032
 BODY_TYP: 4
 MOD_YEAR: 1999
      VIN: 1NXBR12E9XZ2
    VIN_1: 1
    VIN_2: N
    VIN_3: X
    VIN_4: B
    VIN_5: R
    VIN_6: 1
    VIN_7: 2
    VIN_8: E
    VIN_9: 9
   VIN_10: X
   VIN_11: Z
   VIN_12: 2
  TOW_VEH: 0
  VINTYPE: P
  VINMAKE: TOYT
 VINA_MOD: UVL
   VIN_BT: 4D
 VINMODYR: 99
 VIN_LNGT: 17
  VIN_WGT: 2414
 WGTCD_TR: 2147483647
 WHLBS_LG: 0
 WHLBS_SH: 970
   SER_TR: 
 FUELCODE: G
 MCYCL_DS: 2147483647
  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: 32
 UNDERIDE: 0
 ROLLOVER: 0
 ROLINLOC: 0
  IMPACT1: 12
  IMPACT2: 12
 DEFORMED: 4
    TOWED: 3
   M_HARM: 9
  VEH_SC1: 0
  VEH_SC2: 0
 FIRE_EXP: 0
  DR_PRES: 1
  L_STATE: 4
   DR_ZIP: 85044
 L_STATUS: 6
   L_TYPE: 1
 CDL_STAT: 0
 L_ENDORS: 0
  L_COMPL: 3
 L_RESTRI: 0
   DR_HGT: 60
   DR_WGT: 115
 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: 1
   DR_SF1: 99
   DR_SF2: 99
   DR_SF3: 99
   DR_SF4: 99
 VTRAFWAY: 5
 VNUM_LAN: 5
 VSPD_LIM: 35
   VALIGN: 1
 VPROFILE: 1
 VPAVETYP: 2
 VSURCOND: 1
 VTRAFCON: 2
 VTCONT_F: 3
 P_CRASH1: 1
 P_CRASH2: 83
 P_CRASH3: 1
  PCRASH4: 1
  PCRASH5: 1
 ACC_TYPE: 13
   DEATHS: 0
 DR_DRINK: 0
   sModel: Automobiles
     YEAR: 2010
eP_CRASH1: Going Straight
*************************** 1. row ***************************
         STATE: 4
       ST_CASE: 40264
        VEH_NO: 0
        PER_NO: 1
       PBPTYPE: 6
         PBAGE: 36
         PBSEX: 1
sBikeCrashType: Motorist Did Not Yield
      ePBPTYPE: Bicyclist
        ePBSEX: Male
      eBIKEDIR: With Traffic
      eBIKEPOS: Travel lane
      eBIKELOC: Intersection
      eBIKECGP: Motorist Failed to Yield - Signalized Intersection
    eBIKECTYPE: Motorist Drive Out - Signalized Intersection
      ePBSZONE: No
      ePBSWALK: No
      ePBCWALK: No
       PBCWALK: 0
       PBSWALK: 0
       PBSZONE: 0
      PEDCTYPE: 0
     BIKECTYPE: 152
        PEDLOC: 7
       BIKELOC: 1
        PEDPOS: 77
       BIKEPOS: 1
        PEDDIR: 7
       BIKEDIR: 1
        MOTDIR: 7
        MOTMAN: 7
        PEDLEG: 7
        PEDSNR: 7
        PEDCGP: 0
       BIKECGP: 150
          YEAR: 2010