What is `party_drug_physical` "G"

[agude]

SELECT party_drug_physical, count(1) as total
FROM parties
GROUP BY 1
ORDER BY 2 DESC
LIMIT 500;

What is the value G? It's not mentioned in the code book: https://tims.berkeley.edu/help/SWITRS.php

[jw997]

pretty sure G is borrowed from party_sobriety G
which means
G - Impairment Unknown
according to
https://iswitrs.chp.ca.gov/Reports/jsp/samples/RawData_template.pdf

they have a lot of agreement in the party records.

select count(*) as N, party_sobriety, party_drug_physical from old.party
where party_sobriety = 'G'
or party_drug_physical = 'G'
group by party_sobriety, party_drug_physical

"6" "A" "G"
"3" "D" "G"
"740" "G"
"8919" "G" "G"

[agude]

I think you've solved it! I'll have to add this to the next update, thanks!