text: 136674199
  
  --total
  select *
  from nlp_comparisons nlc
  where  nlc.predicate = 'has_1p_status'
  
  --raw true positives
  select abstractor_abstraction_group_id_old, *
  from nlp_comparisons nlc
  where nlc.predicate = 'has_1p_status'
  and
  (
     nlc.value_old_normalized = nlc.value_new_normalized
  or
     nlc.value_old_normalized = nlc.value_new_normalized_raw
  )
  
  --punts
  select  nsif.note_id as note_id_new
        , nlc1.value_old
        , nlc1.value_old_normalized
        , nlc1.*
  from nlp_comparisons nlc1 join note_stable_identifier_full nsif on nlc1.stable_identifier_value = nsif.stable_identifier_value
  where nlc1.predicate = 'has_1p_status'
  and nlc1.value_new_normalized is null
  and nlc1.value_old_normalized is not null
  and not exists(
    select 1
    from note_stable_identifier nsi join abstractor_abstractions aa on nsi.id = aa.about_id
                                    join abstractor_subjects asb on aa.abstractor_subject_id = asb.id
                                    join abstractor_abstraction_schemas aas on asb.abstractor_abstraction_schema_id = aas.id
  
    where nlc1.stable_identifier_value = nsi.stable_identifier_value
    and aas.predicate = 'has_1p_status'
    and (
      aa.value is not null
      or
      aa.not_applicable = true
    )
  )
  
  --curated
  select nsif.note_id as note_id_new
        , *
  from(
  select nlc.stable_identifier_value, nlc.note_id, nlc.id, nlc.predicate, nlc.abstractor_subject_group_name, nlc.abstractor_subject_group_counter, nlc.value_old, nlc.value_old_normalized, nlc.value_new, nlc.value_new_normalized, nlc.value_new_normalized_raw
  -- select nlc.id
  from nlp_comparisons nlc
  where nlc.predicate = 'has_1p_status'
  and COALESCE (nlc.value_old_normalized, '') != COALESCE (nlc.value_new_normalized, '')
  and COALESCE (nlc.value_old_normalized, '') != COALESCE (nlc.value_new_normalized_raw, '')
  and nlc.id not in(
  select nlc1.id
  from nlp_comparisons nlc1
  where nlc1.predicate = 'has_1p_status'
  and nlc1.value_new_normalized is null
  and not exists(
    select 1
    from note_stable_identifier nsi join abstractor_abstractions aa on nsi.id = aa.about_id
                                    join abstractor_subjects asb on aa.abstractor_subject_id = asb.id
                                    join abstractor_abstraction_schemas aas on asb.abstractor_abstraction_schema_id = aas.id
    where nlc1.stable_identifier_value = nsi.stable_identifier_value
    and aas.predicate = 'has_1p_status'
    and (
      aa.value is not null
      or
      aa.not_applicable = true
    )
  )
  )
  union
  -- select abstractor_abstraction_group_id_old, *
  select nlc.stable_identifier_value, nlc.note_id, nlc.id, nlc.predicate, nlc.abstractor_subject_group_name, nlc.abstractor_subject_group_counter, nlc.value_old, nlc.value_old_normalized, nlc.value_new, nlc.value_new_normalized, nlc.value_new_normalized_raw
  --select nlc.id
  from nlp_comparisons nlc
  where nlc.predicate = 'has_1p_status'
  and nlc.value_old_normalized is null
  ) data JOIN note_stable_identifier_full nsif on data.stable_identifier_value = nsif.stable_identifier_value
  
  -- where stable_identifier_value in(
  -- )
  where data.value_new_normalized = 'not applicable' or data.value_new_normalized is null