Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
grants:cog [2025/09/18 13:44] – [Cog Grant] willgrants:cog [2025/09/18 14:08] (current) – [Behavioral] add links will
Line 6: Line 6:
  
 ==== MR ==== ==== MR ====
 +Functional MRI tasks include 4 runs of [[:tools:antisaccade]] block design (breaks maybe background [[:tools:rest]]) and 3 runs of [[:tools:mgs]]. There is also a [[:tool:dwi]] and structural scan.
 +
 <code> <code>
 for d in /Volumes/Hera/Raw/MRprojects/CogLong/150411090938/*; do  for d in /Volumes/Hera/Raw/MRprojects/CogLong/150411090938/*; do 
Line 34: Line 36:
 ==== Behavioral ==== ==== Behavioral ====
  
-Tasks recorded in the original MS Access Database (exported to postgresql)+Tasks recorded in the original MS Access Database (exported to postgresql). 
 +We have responses for [[:tools:wasi]] (IQ), [[:tools:Puberty]] ([[:tools:tanner]]), and [[:tools:stroop]] among others.
  
 <code> <code>
-lncddb "select task, count(*) cnt+lncddb " 
 +  select task, 
 +         count(*) cnt, 
 +         to_char(min(vtimestamp),'YYYY-MM-DD') first, 
 +         to_char(max(vtimestamp),'YYYY-MM-DD') last
   from visit_task natural   from visit_task natural
-  join visit_study+  join visit_study natural join visit
   where study like 'Cog%'   where study like 'Cog%'
   group by task   group by task
-  order by cnt desc;+  having count(*) > 10 
 +  order by cnt desc;" | sed 's/^\|$\|\t/|/g'
 </code> </code>
 +^task^ cnt ^first^last^
 +|Demographics|880|2000-01-01|2019-05-11|
 +|PaperStroop|845|2004-01-19|2019-05-11|
 +|PrePostBehavioral|837|2005-05-12|2019-05-11|
 +|CANTABQuestionnaire|831|2005-05-12|2019-05-11|
 +|SensationSeeking|680|2006-01-25|2019-05-11|
 +|PrePostScan|624|2005-07-05|2019-06-08|
 +|Puberty|581|2005-03-10|2018-01-26|
 +|WASI|553|2000-01-01|2018-08-25|
 +|Handedness|477|2000-01-01|2018-01-26|
 +|CBCL|12|2006-08-24|2010-08-11|
 +|EpilepsyQuestionnaire|11|2006-08-24|2008-12-03|
 +|BRIEF|11|2006-08-24|2008-12-03|
 +|CDI|11|2006-08-24|2008-12-03|
 +|SCARED|11|2006-08-24|2008-12-03| 
  
-^         task        ^ cnt ^ 
-|Demographics          | 880  | 
-|PaperStroop           | 845  | 
-|PrePostBehavioral     | 837  | 
-|CANTABQuestionnaire   | 831  | 
-|SensationSeeking      | 680  | 
-|PrePostScan           | 624  | 
-|Puberty               | 581  | 
-|WASI                  | 553  | 
-|Handedness            | 477  | 
-|CBCL                  | 12  | 
-|EpilepsyQuestionnaire | 11  | 
-|CDI                   | 11  | 
-|BRIEF                 | 11  | 
-|SCARED                | 11  | 
-|PVLHandedness         | 2  | 
-|WMPrePostScan         | 2  | 
-|WoodcockJohnson       | 1  | 
-|PVLQuestionnaire      | 1  | 
-|CELF                  | 1  | 
-|ASR                   | 1  | 
-|PPVT                  | 1  | 
-|RewardsPrePostScan    | 1  | 
  
 === Sensation Seeking === === Sensation Seeking ===
Line 86: Line 86:
  
 </code> </code>
 +
 +=== Puberty ===
 +
 +<code>
 +select measures::json from visit_task natural join visit_study where study like 'Cog%' and task like 'Puberty%' limit 1;
 +
 +
 + {"tsr": 3.5, "Notes": "", "Fpubic": null, "Mpubic": null, "pps1to5": 2.8, "Mgenital": null, "Tanner3m": null, "heightft": 5, "heightin": 2, "pps3skin": 3, "pps6devt": 4, "weightlbs": 90, "FppsMenstr": -1, "Mpps4voice": null, "pps1growth": 2, "Fage.Breast": null, "Fpps4breast": 2, "Tanner1hair": 4, "pubcomplete": 0, "agepubcompMO": null, "pps2bodyhair": 3, "Mpps5hairface": null, "agepubcompYRS": null, "FppsMenstrAgeMO": 10, "FppsMenstrAgeYR": 13, "Fage.Menstration": null, "Tanner2TSP.orBreast": 3}
 +</code>
 +