Revision history for IssuePositionResearchStandards


Revision [58132]

Last edited on 2023-08-31 16:31:43 by NickI
Deletions:
||**Percentage of Determinations Made**||55%||50%||40%||30%||||


Revision [57262]

Edited on 2020-11-20 09:37:50 by JamesW
Additions:
Percentage of Determinations Made represents how successful researchers are in finding evidence & making determinations. The figure calculated is ((Determinations Made / Total Possible Determinations) * 100).
In addition, This final figure can be found for a state after an issue position sheet is imported using the following query:
//SELECT state_id, y.count AS Researched_Determinations_Made, p.count AS Number_of_VE_Questions, e.count AS candidates, (p.count*e.count) AS Possible_Answers, (100*y.count/(p.count*e.count)) AS Percent_Answered
USING (state_id)//
Deletions:
Percentage of Determinations Made represents how successful researchers are in finding evidence & making determinations. The figure calculated is ((Determinations Made / Total Possible Determinations) * 100). This figure can be found for a state after an issue position sheet is imported using the following query:
SELECT state_id, y.count AS Researched_Determinations_Made, p.count AS Number_of_VE_Questions, e.count AS candidates, (p.count*e.count) AS Possible_Answers, (100*y.count/(p.count*e.count)) AS Percent_Answered


Revision [57261]

Edited on 2020-11-20 09:35:23 by JamesW
Additions:
To keep track of this determination rate prior to database import, you can use the formulas described in Step 3 at [[BuildingResearchSheets Building A Research Sheet]]. This running formula can be matched to the target determination rates noted in the above table.


Revision [56619]

Edited on 2020-04-23 11:51:44 by JamesW [Updating query for 2020 cycle]
Additions:
WHERE electionyear = 2020 AND ec.office_id IN (5,6) AND electioncandidatestatus_id IN (8,11,2)
WHERE electionyear = 2020 AND ec.office_id IN (5,6) AND np.profile = 't'
WHERE electionyear = 2020 AND ec.office_id IN (5,6) AND np.profile = 't'AND our_npatoption_id NOT IN (0, 71, 68)
Deletions:
WHERE electionyear = 2018 AND ec.office_id IN (5,6) AND electioncandidatestatus_id IN (8,11,2)
WHERE electionyear = 2018 AND ec.office_id IN (5,6) AND np.profile = 't'
WHERE electionyear = 2018 AND ec.office_id IN (5,6) AND np.profile = 't'AND our_npatoption_id NOT IN (0, 71, 68)


Revision [56392]

Edited on 2019-10-15 10:29:22 by JamesW [Adding Max time per question for research]
Additions:
||||**Experienced Staff**||**Target Intern Production**||**Weeks 2-5**||**Training Period (2 weeks)**||**Max Time per Question**||
||**Average Time Per Candidate (Challenger)**||15 Minutes||20 Minutes||25 - 35 Minutes||30 - 40 Minutes||5 - Minutes||
||**Average Time Per Candidate (Incumbent)**||30 Minutes||35 Minutes||40 - 50 Minutes||50 - 60 Minutes||10 - Minutes||
||**Errors Per 5 Candidates (For Candidates With IP Data)**||0||1||2||3||||
||**Percentage of Determinations Made**||55%||50%||40%||30%||||
Deletions:
||||**Experienced Staff**||**Target Intern Production**||**Weeks 2-5**||**Training Period (2 weeks)**||
||**Average Time Per Candidate (Challenger)**||15 Minutes||20 Minutes||25 - 35 Minutes||30 - 40 Minutes||
||**Average Time Per Candidate (Incumbent)**||30 Minutes||35 Minutes||40 - 50 Minutes||50 - 60 Minutes||
||**Errors Per 5 Candidates (For Candidates With IP Data)**||0||1||2||3||
||**Percentage of Determinations Made**||55%||50%||40%||30%||


Revision [53611]

Edited on 2018-07-06 09:38:01 by walker [changed title to Expectations to match other pages]
Additions:
===Issue Positions Expectations===
Deletions:
===Issue Position Research Standards===


Revision [53609]

Edited on 2018-07-05 15:42:58 by Peter [changed title to Expectations to match other pages]
Deletions:
{{files}}


Revision [53608]

Edited on 2018-07-05 15:39:41 by Peter [changed title to Expectations to match other pages]
Additions:
{{files}}


Revision [53607]

Edited on 2018-07-05 15:31:13 by Peter [changed title to Expectations to match other pages]
Additions:
Percentage of Determinations Made represents how successful researchers are in finding evidence & making determinations. The figure calculated is ((Determinations Made / Total Possible Determinations) * 100). This figure can be found for a state after an issue position sheet is imported using the following query:
Deletions:
Percentage of Determinations made can be found for a state after an issue position sheet is imported using the following query:


Revision [53606]

Edited on 2018-07-05 15:19:40 by Peter [changed title to Expectations to match other pages]

No Differences

Revision [53605]

Edited on 2018-07-05 15:19:34 by Peter [changed title to Expectations to match other pages]
Additions:
The goal of this page is establish clear metrics for successful issue positions research. These are inexact estimations due to the variance in Issue Position research available for different candidates.
Deletions:
The goal of this page is establish clear metrics for successful issue positions research. These are inexact estimations due to the variance in Issue Position research required for different candidates.


Revision [53604]

Edited on 2018-07-05 15:03:32 by Peter [changed title to Expectations to match other pages]
Additions:
||**Errors Per 5 Candidates (For Candidates With IP Data)**||0||1||2||3||
Percentage of Determinations made can be found for a state after an issue position sheet is imported using the following query:
SELECT state_id, y.count AS Researched_Determinations_Made, p.count AS Number_of_VE_Questions, e.count AS candidates, (p.count*e.count) AS Possible_Answers, (100*y.count/(p.count*e.count)) AS Percent_Answered
FROM
(SELECT COUNT (DISTINCT ec.candidate_id), e.state_id
FROM election e
JOIN election_candidate ec USING (election_id)
JOIN electionstage_candidate esd ON ec.election_candidate_id = esd.election_candidate_id
WHERE electionyear = 2018 AND ec.office_id IN (5,6) AND electioncandidatestatus_id IN (8,11,2)
GROUP BY e.state_id) e
FULL OUTER JOIN
(SELECT COUNT (DISTINCT np.npatrow_id), e.state_id
FROM election e
JOIN election_candidate ec USING (election_id)
JOIN npatcandidate nc USING (election_candidate_id)
JOIN npatanswer na USING (npatcandidate_id)
JOIN npatmatrix nm USING (npatmatrix_id)
JOIN npatrow np USING (npatrow_id)
JOIN npatrowtext nt USING (npatrowtext_id)
LEFT JOIN npatcitation nct USING (npatrow_id, npatcandidate_id)
WHERE electionyear = 2018 AND ec.office_id IN (5,6) AND np.profile = 't'
GROUP BY e.state_id) p
USING (state_id)
FULL OUTER JOIN
(SELECT COUNT (DISTINCT na.npatanswer_id), e.state_id
FROM election e
JOIN election_candidate ec USING (election_id)
JOIN npatcandidate nc USING (election_candidate_id)
JOIN npatanswer na USING (npatcandidate_id)
JOIN npatmatrix nm USING (npatmatrix_id)
JOIN npatrow np USING (npatrow_id)
JOIN npatrowtext nt USING (npatrowtext_id)
LEFT JOIN npatcitation nct USING (npatrow_id, npatcandidate_id)
JOIN npatstatus n ON nc.npatstatus_id = n.npatstatus_id
WHERE electionyear = 2018 AND ec.office_id IN (5,6) AND np.profile = 't'AND our_npatoption_id NOT IN (0, 71, 68)
GROUP BY e.state_id) y
USING (state_id)
Deletions:
||**Errors Per 5 Candidates**||0||1||2||3||
'*'Candidates With Issue Position Data
'**'Calculated with VE Efficiency Query after import is completed


Revision [53603]

Edited on 2018-07-05 14:23:37 by Peter [changed title to Expectations to match other pages]
Additions:

'*'Candidates With Issue Position Data
'**'Calculated with VE Efficiency Query after import is completed
Deletions:
*Candidates With Issue Position Data
**Calculated with VE Efficiency Query after import is completed


Revision [53602]

Edited on 2018-07-05 14:23:18 by Peter [changed title to Expectations to match other pages]
Additions:
*Candidates With Issue Position Data
**Calculated with VE Efficiency Query after import is completed


Revision [53601]

Edited on 2018-07-05 13:01:35 by Peter [changed title to Expectations to match other pages]
Additions:
||**Average Time Per Candidate (Incumbent)**||30 Minutes||35 Minutes||40 - 50 Minutes||50 - 60 Minutes||
||**Errors Per 5 Candidates**||0||1||2||3||
||**Percentage of Determinations Made**||55%||50%||40%||30%||
Deletions:
||**Full Roster Checks – includes all data in offices (office, dates, district, party, committees, leadership) and addresses tabs in admin**||5 minutes per politician or 90 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||
||**Simple Roster Check – just office, district, party in the offices tab in admin**||1 minute per politician or 500 per day||2 minutes per politician or 250 per day||5 minutes per politician or 90 per day||2 minutes per politician or 250 per day||5 minutes per politician or 90 per day||
||**Contact Information – verifying what we have and looking for new**||2 minutes per politician or 250 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||
||**Estimated errors per day**||less than 5||5 formatting errors, 0 collection errors, 5 categorization errors||20-30 formatting errors, 10 collection errors, 20-30 categorization errors||5 formatting errors, 0 collection errors, 5 categorization errors||20-30 formatting errors, 10 collection errors, 20-30 categorization errors||


Revision [53600]

Edited on 2018-07-05 12:57:36 by Peter [changed title to Expectations to match other pages]
Additions:
||**Average Time Per Candidate (Challenger)**||15 Minutes||20 Minutes||25 - 35 Minutes||30 - 40 Minutes||
Deletions:
||**Full Profile Research for a new candidate – bio, add.bio, addresses tabs in admin**||10-15 minutes per politician or 40-50 per day||15-20 minutes per politician or 30-40 per day||30 minutes per politician or 15-20 per day||15-20 minutes per politician or 30-40 per day||30 minutes per politician or 15-20 per day||


Revision [53599]

Edited on 2018-07-05 12:55:49 by Peter [changed title to Expectations to match other pages]
Additions:
||||**Experienced Staff**||**Target Intern Production**||**Weeks 2-5**||**Training Period (2 weeks)**||
||**Full Profile Research for a new candidate – bio, add.bio, addresses tabs in admin**||10-15 minutes per politician or 40-50 per day||15-20 minutes per politician or 30-40 per day||30 minutes per politician or 15-20 per day||15-20 minutes per politician or 30-40 per day||30 minutes per politician or 15-20 per day||
||**Full Roster Checks – includes all data in offices (office, dates, district, party, committees, leadership) and addresses tabs in admin**||5 minutes per politician or 90 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||
||**Simple Roster Check – just office, district, party in the offices tab in admin**||1 minute per politician or 500 per day||2 minutes per politician or 250 per day||5 minutes per politician or 90 per day||2 minutes per politician or 250 per day||5 minutes per politician or 90 per day||
||**Contact Information – verifying what we have and looking for new**||2 minutes per politician or 250 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||5 minutes per politician or 90 per day||10 minutes per politician or 50 per day||
||**Estimated errors per day**||less than 5||5 formatting errors, 0 collection errors, 5 categorization errors||20-30 formatting errors, 10 collection errors, 20-30 categorization errors||5 formatting errors, 0 collection errors, 5 categorization errors||20-30 formatting errors, 10 collection errors, 20-30 categorization errors||


Revision [53598]

The oldest known version of this page was created on 2018-07-05 12:47:40 by Peter [changed title to Expectations to match other pages]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki