Charles Dupont

Computer Systems Analyst II

• Email: charles.dupont@vanderbilt.edu
• Phone Number: (615) 936-6510
  
• Fax Number: (615) 343-4924
  

Vanderbilt University
School of Medicine
Department of Biostatistics
S-2323 Medical Center North
Nashville, TN 37232-2158 a b

This is a Change This is a Change THis is another change Why wont you change Why won't you change CHANGEEEEEEEEEEEE!!!!!!!!!!!!!!!!!!!!!! CHAGEWEES

Data for Stephanie Lindquist

• case_age.xml:
• case_counts.xml:

WebNotify DefaultPreferences? WikiUsers WebHome WebPreferences MoonProj > <

> <

deb ftp://ftp.nerim.net/debian-marillat/ sarge main
deb ftp://ftp.nerim.net/debian-marillat/ etch main
deb ftp://ftp.nerim.net/debian-marillat/ sid main

Latex Programing Hints

Current Projects

Misc Projects Completed Charles Dupont Misc List

Design

• The Design package | Design todo list

Hmisc

• The Hmisc package | Hmisc todo list

rreport

• The rreport package | rreport todo list?

Bug Reports

Please the the Hmisc, Design, and rreport bug reporting page.

-- CharlesDupont - 23 May 2005

• that_ddot.jpg:
  

• graph.jpg:
  

• givens.jpg:
  

• theta_dot.jpg:
  

• that_dot2.jpg:
  

• theta_ddot_vs_theta.gif:
  

• theta_dot_vs_theta.gif:
  

• theta_dot_vs_theta_y.gif:
  

• given2.jpg:
  

• given3.jpg:
  

• graph2.jpg:
  

• phi_dot.jpg:
  

• phi_dot_vs_phi_r.gif:
  

• christmas_house.wmv: The horror

1. hello
2. heser
   

   Verbatim text.
   

3. aher

proj

• outside-damage.xls:

SELECT orig_case.title as `Case Title` , orig_case.state as state, YEAR(orig_case.date) as `Year Decided`, neg_case.title as `Overrulling Case`, YEAR(neg_case.date) as `Year Overruled`, neg_ref.reason as `Negative Comment`, DATEDIFF(neg_case.date, orig_case.date) AS `age (in days)` FROM negative_citing_references neg_ref LEFT JOIN court_cases orig_case ON (neg_ref.original_case_id = orig_case.id) LEFT JOIN court_cases neg_case ON (neg_ref.overruling_case_id = neg_case.id) WHERE neg_ref.reason IN ('Overruled by', 'Overruled in Part by') AND orig_case.state = neg_case.state INTO OUTFILE '/tmp/case_age.csv' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '';

select orig_case.state, YEAR(neg_case.date), COUNT(*) AS `count` FROM negative_citing_references neg_ref LEFT JOIN court_cases orig_case ON (neg_ref.original_case_id = orig_case.id) LEFT JOIN court_cases neg_case ON (neg_ref.overruling_case_id = neg_case.id) WHERE neg_ref.reason IN ('Overruled by', 'Overruled in Part by') AND orig_case.state = neg_case.state GROUP BY orig_case.state, YEAR(neg_case.date) INTO OUTFILE '/tmp/neg_case_counts.csv' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '';

select orig_case.state, YEAR(neg_case.date), COUNT(*) AS `count` FROM negative_citing_references neg_ref LEFT JOIN court_cases orig_case ON (neg_ref.original_case_id = orig_case.id) LEFT JOIN court_cases neg_case ON (neg_ref.overruling_case_id = neg_case.id) WHERE neg_ref.reason IN ('Overruled by', 'Overruled in Part by') AND orig_case.state = neg_case.state GROUP BY orig_case.state, YEAR(orig_case.date) INTO OUTFILE '/tmp/case_counts.csv' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '';

select DISTINCT count(*) AS `Count`, neg_case.state AS state, YEAR(neg_case.date) AS year FROM negative_citing_references neg_ref LEFT JOIN court_cases neg_case ON (neg_ref.overruling_case_id = neg_case.id) LEFT JOIN court_cases orig_case ON (neg_ref.original_case_id = orig_case.id) WHERE neg_ref.reason IN ('Overruled by', 'Overruled in Part by') AND orig_case.state = neg_case.state GROUP BY neg_case.state, YEAR(neg_case.date) INTO OUTFILE '/tmp/overruling_case_counts.csv' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '';

• struture.png:
  

• struture1.png:
  

• struture2.png:
  

• struture1.png:
  

• WestCheck_dump.sql.zip:

• test.svg: test animated graph