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:11] – [Tasks] willgrants:cog [2025/09/18 14:08] (current) – [Behavioral] add links will
Line 1: Line 1:
 ====== Cog Grant ====== ====== Cog Grant ======
  
-Scanned with 3T on southside (BIRC -> NIC) before it was shut down (c. 2018?).+Scanned with 3T on southside (BIRC -> NIC) before it was shut down (c. 2019).
  
 ===== Tasks ===== ===== Tasks =====
-Tasks recorded in the original MS Access Database (exported to postgresql)+ 
 +==== 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>
-lncddb "select task, count(*) cnt+for d in /Volumes/Hera/Raw/MRprojects/CogLong/150411090938/*; do  
 +  find $d -type f -iname '*dcm' -exec\ 
 +   dicom_hinfo \ 
 +       -sepstr \| -no_name -full_entry \ 
 +       -tag 0018,1030 -tag 0018,0080 -tag 0018,1310 {} \; \ 
 +       -quit 
 +   done | sed 's/^\|$/|/g' 
 +</code> 
 + 
 +^acq name ^ TR ^ Acq Mat ^ 
 +|circle_localizer|20| 0 256 256 0| 
 +|trufi_sag |5.43| 0 256 256 0| 
 +|t2_tse_tra|4790| 0 256 256 0| 
 +|t1_mprage_sag_ns_tilt |1630| 0 256 256 0| 
 +|ep2d_diff_mddw6 |3900| 128 0 0 128| 
 +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
 +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
 +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
 +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
 +|ep2d_bold_MGS |1500| 64 0 0 64| 
 +|ep2d_bold_MGS |1500| 64 0 0 64| 
 +|ep2d_bold_MGS |1500| 64 0 0 64| 
 +|t1_mprage_sag_ns_tilt |1630| 0 256 256 0| 
 + 
 + 
 +==== Behavioral ==== 
 + 
 +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> 
 +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| 
 +
 +
 +=== Sensation Seeking ===
 +
 +<code>
 +select measures::json 
 + from visit_task 
 + natural join visit_study
 + where study like 'Cog%' and
 +       task like 'SensationSeeking%'
 + limit 3;
 + 
 +                                   measures                                    
 +--------------------------------------------------------------------------------
 + {"Notes": "", "sssBS": 1, "sssES": 2, "sssDIS": 1, "sssTAS": 6, "sssTOT": 10}
 + {"Notes": "", "sssBS": 3, "sssES": 3, "sssDIS": 4, "sssTAS": 4, "sssTOT": 14}
 + {"Notes": "", "sssBS": 1, "sssES": 6, "sssDIS": 4, "sssTAS": 10, "sssTOT": 21}
 +
 +</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>
 +
  
-^         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  |