7,612
edits
Changes
Jump to navigation
Jump to search
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.
#Collect addresses, phone numbers, and zipcodes 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 centers center names and their hospitals/or zipcodes correspond with already found zipcodes ==Deliverables== week 3-7: put all data into a database week 10-14: finish making the database, research centersfigure out what other data I want to pull and what data visualizations I want to make week 17-21: look at all data, and labs. make outline #Isolate specific zipcodes for each medical centerweek 24-28: finish outline, write draft, edit draft
Medical Centers and Grants (view source)
Revision as of 13:41, 21 September 2020
, 13:41, 21 September 2020no edit summary
{{Project|Has project output=Data|Has sponsor=McNair ProjectsCenter
|Has title=Medical Centers and Grants
|Has owner=Catherine Kirby,
|Has start date=Spring 2017
|Has deadline=November 16, 2017|Has keywords=Entrepreneurship, Start-ups, Patents, Grants, Medical Centers, Biotechnology,Data
|Has project status=Active
}}
==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 is in:Data Location==
E:\McNair\Projects\Biotech Project
==DeliverablesDependencies==*Patent Data: http://mcnair.bakerinstitute.org/wiki/Patent_Data*Federal Grant Data: http://mcnair.bakerinstitute.org/wiki/Federal_Grant_Data*FDA Trials: http://mcnair.bakerinstitute.org/wiki/FDA_Trials_Data ==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:
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
