==============================================================================
Surface 2 � Q14 column structure verification
==============================================================================

Looking for Q14 rows under canonical 'Capitalized R&D equipment expenditures by field'
and raw 'Capitalized equipment expenditures by field and source'.

--- FY 2010 ---

  Question labels matching Q14 canonical/raw or containing 'capitalized' / 'equipment':
    n=21,387  question='Capitalized equipment expenditures by field and source'

  Distinct columns under Q14 raw label, with row counts:
    column='Nonfederal'              n= 7,129
    column='Total'                   n= 7,129
    column='Federal'                 n= 7,129

  Example rows at column='Total' for Q14 (top 5):
    inst='000166' row='All'                                 qno='14K'  data='408'      status=None
    inst='000166' row='Life sciences, all'                  qno='14D06' data='408'      status=None
    inst='000166' row='Life sciences, health sciences'      qno='14D03' data='408'      status=None
    inst='001002' row='All'                                 qno='14K'  data='20'       status=None
    inst='001002' row='Social sciences, all'                qno='14H06' data='20'       status=None

  Spot-check: per-(inst_id, row) sum across columns (top 3 by row-count):
    inst='330006' row='Geosciences, atmospheric sciences, ' n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=61062.0
    inst='029977' row='Engineering, all'                    n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=54600.0
    inst='003378' row='Life sciences, all'                  n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=49704.0

--- FY 2017 ---

  Question labels matching Q14 canonical/raw or containing 'capitalized' / 'equipment':
    n=19,959  question='Capitalized equipment expenditures by field and source'

  Distinct columns under Q14 raw label, with row counts:
    column='Nonfederal'              n= 6,653
    column='Total'                   n= 6,653
    column='Federal'                 n= 6,653

  Example rows at column='Total' for Q14 (top 5):
    inst='000166' row='All'                                 qno='14K'  data='844'      status=None
    inst='000166' row='Life sciences, all'                  qno='14D06' data='844'      status=None
    inst='000166' row='Life sciences, health sciences'      qno='14D03' data='844'      status=None
    inst='001002' row='All'                                 qno='14K'  data='1285'     status='i'
    inst='001002' row='Computer and information sciences, ' qno='14A'  data='44'       status='i'

  Spot-check: per-(inst_id, row) sum across columns (top 3 by row-count):
    inst='102045' row='Engineering, all'                    n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=191500.0
    inst='002290' row='Physical sciences, all'              n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=134402.0
    inst='029977' row='Engineering, all'                    n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=84584.0

--- FY 2024 ---

  Question labels matching Q14 canonical/raw or containing 'capitalized' / 'equipment':
    n=22,365  question='Capitalized equipment expenditures by field and source'

  Distinct columns under Q14 raw label, with row counts:
    column='Nonfederal'              n= 7,455
    column='Total'                   n= 7,455
    column='Federal'                 n= 7,455

  Example rows at column='Total' for Q14 (top 5):
    inst='000166' row='All'                                 qno='14K'  data='539'      status=None
    inst='000166' row='Life sciences, all'                  qno='14D06' data='539'      status=None
    inst='000166' row='Life sciences, health sciences'      qno='14D03' data='539'      status=None
    inst='001002' row='All'                                 qno='14K'  data='927'      status=None
    inst='001002' row='Computer and information sciences, ' qno='14A'  data='35'       status='i'

  Spot-check: per-(inst_id, row) sum across columns (top 3 by row-count):
    inst='008723' row='Engineering, all'                    n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=142862.0
    inst='029977' row='Engineering, all'                    n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=136920.0
    inst='003378' row='Life sciences, all'                  n_cells=3 cols_seen='Federal,Nonfederal,Total' sum=83936.0

==============================================================================
Surface 3 � Short Form Q2 raw structure verification
==============================================================================

--- FY 2012 ---

  Question labels matching short-form patterns:
    (none)

  Distinct questionnaire_no values in raw:
    qno='09K'      n= 5,216
    qno='01.1'     n= 4,982
    qno='09D06'    n= 4,728
    qno='09D02'    n= 4,392
    qno='09F06'    n= 3,968
    qno='11K'      n= 3,816
    qno='09J09'    n= 3,512
    qno='09F02'    n= 3,472
    qno='11D06'    n= 3,462
    qno='09C05'    n= 3,288
    qno='09F04'    n= 3,256
    qno='11D02'    n= 3,180
    qno='09H06'    n= 3,096
    qno='09E'      n= 3,080
    qno='11J09'    n= 3,072
    qno='10'       n= 2,972
    qno='11F06'    n= 2,922
    qno='09B10'    n= 2,848
    qno='09A'      n= 2,840
    qno='11F02'    n= 2,748
    qno='09G'      n= 2,712
    qno='11H06'    n= 2,682
    qno='09J03'    n= 2,600
    qno='11C05'    n= 2,532
    qno='09C02'    n= 2,496
    qno='11J03'    n= 2,364
    qno='11E'      n= 2,358
    qno='09H05'    n= 2,328
    qno='11G'      n= 2,304
    qno='11F04'    n= 2,298

  If short-form Q2 candidates exist, distinct columns:
    (no short-form candidates found in raw)

  Sample short-form rows (top 5):
    (none)

--- FY 2017 ---

  Question labels matching short-form patterns:
    (none)

  Distinct questionnaire_no values in raw:
    qno='09K'      n= 5,096
    qno='09D06'    n= 4,744
    qno='09D02'    n= 4,360
    qno='09F06'    n= 3,920
    qno='11K'      n= 3,798
    qno='09J09'    n= 3,624
    qno='11D06'    n= 3,534
    qno='09F02'    n= 3,512
    qno='11D02'    n= 3,258
    qno='09H06'    n= 3,152
    qno='11J09'    n= 3,138
    qno='09F04'    n= 3,112
    qno='09C05'    n= 3,104
    qno='09E'      n= 3,080
    qno='09A'      n= 2,984
    qno='10'       n= 2,961
    qno='09B10'    n= 2,952
    qno='09D03'    n= 2,928
    qno='11F06'    n= 2,916
    qno='09J03'    n= 2,840
    qno='11H06'    n= 2,832
    qno='11F02'    n= 2,730
    qno='09G'      n= 2,672
    qno='09C02'    n= 2,592
    qno='11J03'    n= 2,544
    qno='11D03'    n= 2,532
    qno='01.1'     n= 2,484
    qno='11E'      n= 2,472
    qno='11G'      n= 2,466
    qno='11F04'    n= 2,376

  If short-form Q2 candidates exist, distinct columns:
    (no short-form candidates found in raw)

  Sample short-form rows (top 5):
    (none)

--- FY 2024 ---

  Question labels matching short-form patterns:
    (none)

  Distinct questionnaire_no values in raw:
    qno='09K'      n= 5,392
    qno='09D06'    n= 5,048
    qno='09D02'    n= 4,504
    qno='09F06'    n= 4,112
    qno='11K'      n= 4,014
    qno='09J09'    n= 3,888
    qno='11D06'    n= 3,750
    qno='09F02'    n= 3,632
    qno='09A'      n= 3,560
    qno='11D02'    n= 3,432
    qno='11J09'    n= 3,420
    qno='09H06'    n= 3,392
    qno='09C05'    n= 3,368
    qno='10'       n= 3,307
    qno='09D03'    n= 3,272
    qno='09E'      n= 3,264
    qno='09B10'    n= 3,256
    qno='09F04'    n= 3,200
    qno='09J03'    n= 3,104
    qno='11F06'    n= 3,078
    qno='11H06'    n= 3,018
    qno='09G'      n= 2,952
    qno='11D03'    n= 2,886
    qno='11F02'    n= 2,820
    qno='11J03'    n= 2,730
    qno='11G'      n= 2,730
    qno='11A'      n= 2,712
    qno='11J08'    n= 2,712
    qno='09C02'    n= 2,696
    qno='01.1'     n= 2,640

  If short-form Q2 candidates exist, distinct columns:
    (no short-form candidates found in raw)

  Sample short-form rows (top 5):
    (none)
