Differences

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

Link to this comparison view

Next revision		Previous revision
grants:cog [2025/09/18 13:09] – created 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>
-select task, count(*) cnt from visit_task natural join visit_study where study like 'Cog%' group by task order by cnt desc;+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> </code>
  
-^         task        ^ cnt ^ +^acq name ^ TR ^ Acq Mat ^ 
-|Demographics          | 880| +|circle_localizer|20| 0 256 256 0| 
-|PaperStroop           | 845| +|trufi_sag |5.43| 0 256 256 0| 
-|PrePostBehavioral     | 837| +|t2_tse_tra|4790| 0 256 256 0| 
-|CANTABQuestionnaire   | 831| +|t1_mprage_sag_ns_tilt |1630| 0 256 256 0| 
-|SensationSeeking      | 680| +|ep2d_diff_mddw6 |3900| 128 0 0 128| 
-|PrePostScan           | 624| +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
-|Puberty               | 581| +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
-|WASI                  | 553| +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
-|Handedness            | 477| +|ep2d_bold_9VGSANTI|1500| 64 0 0 64| 
-|CBCL                  |  12| +|ep2d_bold_MGS |1500| 64 0 0 64| 
-|EpilepsyQuestionnaire |  11| +|ep2d_bold_MGS |1500| 64 0 0 64| 
-|CDI                   |  11| +|ep2d_bold_MGS |1500| 64 0 0 64| 
-|BRIEF                 |  11| +|t1_mprage_sag_ns_tilt |1630| 0 256 256 0| 
-|SCARED                |  11| + 
-|PVLHandedness         |   2| + 
-|WMPrePostScan         |   2| +==== Behavioral ==== 
-|WoodcockJohnson       |   1| + 
-|PVLQuestionnaire      |   1| +Tasks recorded in the original MS Access Database (exported to postgresql). 
-|CELF                  |   1| +We have responses for [[:tools:wasi]] (IQ), [[:tools:Puberty]] ([[:tools:tanner]]), and [[:tools:stroop]] among others. 
-|ASR                   |   1| + 
-|PPVT                  |   1| +<code> 
-|RewardsPrePostScan    |   1|  +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 
 +  join visit_study natural join visit 
 +  where study like 'Cog%' 
 +  group by task 
 +  having count(*) > 10 
 +  order by cnt desc;" | sed 's/^\|$\|\t/|/g' 
 +</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> 
 +