SemCor Analysis

cw_pospos_countpos_prop
brown1a17,9170.1741
brown1n48,1570.4680
brown1r10,5290.1023
brown1v26,2980.2556
download as csv
SELECT CONCAT('brown', a.c_id) AS c, a.w_pos, a.pos_count, (a.pos_count/(SELECT COUNT(*)
FROM wsd_sentences
WHERE c_id=a.c_id)) AS pos_prop
FROM (SELECT c_id, w_pos, COUNT(*) AS pos_count
FROM wsd_sentences
WHERE c_id=1
GROUP BY c_id, w_pos) a
ORDER BY a.c_id ASC, a.w_pos ASC
cw_pospos_countpos_prop
brown2a13,8360.1680
brown2n38,8450.4716
brown2r8,4180.1022
brown2v21,2690.2582
download as csv
SELECT CONCAT('brown', a.c_id) AS c, a.w_pos, a.pos_count, (a.pos_count/(SELECT COUNT(*)
FROM wsd_sentences
WHERE c_id=a.c_id)) AS pos_prop
FROM (SELECT c_id, w_pos, COUNT(*) AS pos_count
FROM wsd_sentences
WHERE c_id=2
GROUP BY c_id, w_pos) a
ORDER BY a.c_id ASC, a.w_pos ASC
w_pospos_countpos_prop
a31,7530.1714
n87,0020.4696
r18,9470.1023
v47,5670.2567
download as csv
SELECT a.w_pos, a.pos_count, (a.pos_count/(SELECT COUNT(*)
FROM wsd_sentences)) AS pos_prop
FROM (SELECT w_pos, COUNT(*) AS pos_count
FROM wsd_sentences
GROUP BY w_pos) a
ORDER BY a.w_pos ASC