Difference between revisions of "Medical Centers and Grants"

From edegan.com
Jump to navigation Jump to search
 
(17 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{McNair Projects
+
{{Project
 +
|Has project output=Data
 +
|Has sponsor=McNair Center
 
|Has title=Medical Centers and Grants
 
|Has title=Medical Centers and Grants
 
|Has owner=Catherine Kirby,
 
|Has owner=Catherine Kirby,
 
|Has start date=Spring 2017
 
|Has start date=Spring 2017
 +
|Has deadline=November 16, 2017
 
|Has keywords=Entrepreneurship, Start-ups, Patents, Grants, Medical Centers, Biotechnology,Data
 
|Has keywords=Entrepreneurship, Start-ups, Patents, Grants, Medical Centers, Biotechnology,Data
 
|Has project status=Active
 
|Has project status=Active
 
}}
 
}}
 
==Project Description==
 
==Project Description==
This project revolves around examining Medical Centers and viewing their research to see how innovative it is and whether or not Medical Centers in the U.S. are using the grants and money they receive to discover and create new treatments and services. For this project, I plan on collecting data on patents, NIH and NSF grants, and clinical trial data based on zipcodes of medical centers to show how much innovation occurs in these centers. For each research artifact, I plan on finding how many of each article is filed under each zipcode. At this time, I have all the raw data for each research artifact and through using regular expressions, I plan on finding out how many of each article is filed by the end of this week (March 23). After examining these results, I will decide how to present the data and create a paper around it.  
+
This project revolves around examining Medical Centers and viewing their research to see how innovative it is and whether or not Medical Centers in the U.S. are using the grants and money they receive to discover and create new treatments and services. For this project, I plan on collecting data on patents, NIH and NSF grants, and clinical trial data based on zipcodes of medical centers to show how much innovation occurs in these centers. For each research dataset, I plan on finding how many of each type of event (patent, trial, grant) is filed under each zipcode. At this time, I have all the raw data for each research dataset and am going through using regular expressions, I plan on finding out how many matches I have by the end of this week (March 23). After examining these results, I will decide how to present the data and create a paper around it.  
  
Progress report: March 23: I have all the raw data from all three research articles contained in my folder. By the end of the next week, I plan on gathering all the data from the zipcodes that I can, then deciding how to proceed after.  
+
==Progress Report==
Project data is in:
+
Catherine matched patents, grants, and clinical trials to Medical Centers. She is currently working on putting all the data into a database.  
 +
 
 +
==Project Data Location==
 
  E:\McNair\Projects\Biotech Project
 
  E:\McNair\Projects\Biotech Project
  
==Deliverables==
+
==Dependencies==
 
+
*Patent Data: http://mcnair.bakerinstitute.org/wiki/Patent_Data
week 20-24: learn SQL and database stuff
+
*Federal Grant Data: http://mcnair.bakerinstitute.org/wiki/Federal_Grant_Data
 
+
*FDA Trials: http://mcnair.bakerinstitute.org/wiki/FDA_Trials_Data
week 27-31: continue learn SQL
 
 
 
week 3-7: if SQL fails then condense all grant files into one excel thing and do it by hand, find way to get patent stuff
 
 
 
week 10-14: finish grant stuff then work on and finish up patent stuff
 
 
 
week 17-21: look at all data, make outline
 
 
 
week 24-28: finish outline, write draft, edit draft
 
  
 +
==Project Overview==
 
===Med Center Data===
 
===Med Center Data===
Catherine collected all center, institution, and hospital address, zipcode, and phone number data from all United States medical centers. Intending to use this as the basis analyzing the other data gathered.
 
 
Project data is in:
 
Project data is in:
 
  E:\McNair\Projects\Biotech Project\medcenter data
 
  E:\McNair\Projects\Biotech Project\medcenter data
 +
 +
Catherine collected all center, institution, and hospital address, zipcode, and phone number data from all United States medical centers. Intending to use this as the basis analyzing the other data gathered.
 
===Clinical Trial Data===
 
===Clinical Trial Data===
 
Project data is in:
 
Project data is in:
Line 58: Line 56:
  
 
2. search to see if medical center names and/or zipcodes correspond with already found zipcodes
 
2. search to see if medical center names and/or zipcodes correspond with already found zipcodes
 +
 +
==Deliverables==
 +
 +
week 3-7: put all data into a database
 +
 +
week 10-14: finish making the database, figure out what other data I want to pull and what data visualizations I want to make
 +
 +
week 17-21: look at all data, make outline
 +
 +
week 24-28: finish outline, write draft, edit draft

Latest revision as of 13:41, 21 September 2020


Project
Medical Centers and Grants
Project logo 02.png
Project Information
Has title Medical Centers and Grants
Has owner Catherine Kirby
Has start date Spring 2017
Has deadline date
Has keywords Entrepreneurship, Start-ups, Patents, Grants, Medical Centers, Biotechnology, Data
Has project status Active
Has sponsor McNair Center
Has project output Data
Copyright © 2019 edegan.com. All Rights Reserved.

Project Description

This project revolves around examining Medical Centers and viewing their research to see how innovative it is and whether or not Medical Centers in the U.S. are using the grants and money they receive to discover and create new treatments and services. For this project, I plan on collecting data on patents, NIH and NSF grants, and clinical trial data based on zipcodes of medical centers to show how much innovation occurs in these centers. For each research dataset, I plan on finding how many of each type of event (patent, trial, grant) is filed under each zipcode. At this time, I have all the raw data for each research dataset and am going through using regular expressions, I plan on finding out how many matches I have by the end of this week (March 23). After examining these results, I will decide how to present the data and create a paper around it.

Progress Report

Catherine matched patents, grants, and clinical trials to Medical Centers. She is currently working on putting all the data into a database.

Project Data Location

E:\McNair\Projects\Biotech Project

Dependencies

Project Overview

Med Center Data

Project data is in:

E:\McNair\Projects\Biotech Project\medcenter data

Catherine collected all center, institution, and hospital address, zipcode, and phone number data from all United States medical centers. Intending to use this as the basis analyzing the other data gathered.

Clinical Trial Data

Project data is in:

E:\McNair\Projects\FDA Trials

Jeemin collected all data in textpad. There are more entries than excel rows, need to fix the textpad things before looking at stuff again

1. Find the zipcodes that correspond with medical center zipcodes

2. See if the names of medical centers can be matched as well

3. go back and fix the problems encountered

Patent Data

Project data is in:

E:\McNair\Projects\PatentData
  • not sure if ready to use yet*

1. Find a way to combine all the excel data onto a couple of spreadsheets

2. search to see if medical center names and/or zipcodes correspond with already found zipcodes

NSF/NIH Grants

Raw Project data is in:

E:\McNair\Projects\Federal Grant Data

Compiled Excel Data for NIH grants can be found in my Biotech Project folder in the grants section.

1. Find a way to combine all the excel data onto a couple of spreadsheets

2. search to see if medical center names and/or zipcodes correspond with already found zipcodes

Deliverables

week 3-7: put all data into a database

week 10-14: finish making the database, figure out what other data I want to pull and what data visualizations I want to make

week 17-21: look at all data, make outline

week 24-28: finish outline, write draft, edit draft