Skip to content

Instantly share code, notes, and snippets.

@jasonost
Last active August 29, 2015 14:10
Show Gist options
  • Save jasonost/eee672d26aa9ef6ccd01 to your computer and use it in GitHub Desktop.
Save jasonost/eee672d26aa9ef6ccd01 to your computer and use it in GitHub Desktop.
Display the source blob
Display the rendered blob
Raw
{
"worksheets": [
{
"cells": [
{
"metadata": {},
"cell_type": "code",
"input": "import codecs, nltk, json, string, cPickle as pickle, random, collections, dedupe, numpy as np, itertools, time, re\nimport pandas as pd\nfrom string import punctuation\npd.set_option('display.max_rows', 500)",
"prompt_number": 71,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "markdown",
"source": "### Get facility data and prepare list to dedupe"
},
{
"metadata": {},
"cell_type": "code",
"input": "column_names = [\"facility_id\",\n \"nct_id\",\n \"status\",\n \"facility_name\",\n \"city\",\n \"state\",\n \"zipcode\",\n \"country\"]\n\nfacilities = pd.read_csv('../data/facilities.txt', names=column_names, sep=\"|\", encoding='utf-8', quoting=3)\n\nfor c in column_names[2:]:\n facilities[c] = facilities[c].apply(lambda x: x if pd.notnull(x) else u'')",
"prompt_number": 2,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "states = facilities[facilities.country == 'United States'].groupby(facilities.state).count().to_dict()['state'].keys()\nprint [(k, v) for k, v in enumerate(states)]",
"prompt_number": 3,
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": "[(0, u'Mississippi'), (1, u'Oklahoma'), (2, u'Delaware'), (3, u'Minnesota'), (4, u'Illinois'), (5, u'Arkansas'), (6, u'New Mexico'), (7, u'Indiana'), (8, u'Maryland'), (9, u'Louisiana'), (10, u'Idaho'), (11, u'Wyoming'), (12, u'Tennessee'), (13, u'Arizona'), (14, u'Iowa'), (15, u'Michigan'), (16, u'Kansas'), (17, u'Utah'), (18, u'Virginia'), (19, u'Oregon'), (20, u'Connecticut'), (21, u'Montana'), (22, u'California'), (23, u'Massachusetts'), (24, u'West Virginia'), (25, u'South Carolina'), (26, u'New Hampshire'), (27, u'Wisconsin'), (28, u'Vermont'), (29, u'Georgia'), (30, u'North Dakota'), (31, u'Pennsylvania'), (32, u'Florida'), (33, u'Alaska'), (34, u'Kentucky'), (35, u'Hawaii'), (36, u'Nebraska'), (37, u'Missouri'), (38, u'Ohio'), (39, u'Alabama'), (40, u'New York'), (41, u'South Dakota'), (42, u'Colorado'), (43, u'New Jersey'), (44, u'Washington'), (45, u'North Carolina'), (46, u'District of Columbia'), (47, u'Texas'), (48, u'Nevada'), (49, u'Maine'), (50, u'Rhode Island')]\n"
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "bad_names = [r'investigat[a-z]+ site',\n r'research site',\n r'research facility',\n r'local institution',\n r'study site',\n r'clinical site',\n r'call center',\n r'site ref',\n r'site[ :]+#?[0-9]+',\n r'^#?[0-9\\.]+$',\n r'for additional information',\n r'call for information',\n r'the study is '\n ]\n\npotential = facilities[(facilities.country == 'United States') & \n (facilities.facility_name.apply(lambda x: x != u'' and min([not re.search(b,x.lower()) for b in bad_names])))][['facility_id','facility_name','city','state','zipcode','country']].drop_duplicates(['facility_name','city','state','zipcode','country'])",
"prompt_number": 4,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": true
},
{
"metadata": {},
"cell_type": "code",
"input": "potential.shape",
"prompt_number": 5,
"outputs": [
{
"output_type": "pyout",
"prompt_number": 5,
"metadata": {},
"text": "(101559, 6)"
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "markdown",
"source": "### Train model\n(Done on data from all states)"
},
{
"metadata": {},
"cell_type": "code",
"input": "random_pairs = dedupe.randomPairs(len(potential), 100000) \nid_lookup = {i: k for i, k in enumerate(potential.facility_id)}\npotential_indexed = potential.set_index('facility_id')\n\ntemp_d = {}\n\nfor i in range(len(potential)):\n temp_d[i] = dedupe.frozendict(potential_indexed.loc[id_lookup[i]].to_dict())\n\ndef random_pair_generator():\n for k1, k2 in random_pairs:\n yield (temp_d[k1], temp_d[k2])\n\ntodo = tuple(pair for pair in random_pair_generator())",
"prompt_number": 6,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "variables = [\n {'field' : 'facility_name', 'type' : 'String'},\n {'field' : 'city', 'type' : 'ShortString', 'has missing' : True},\n {'field' : 'state', 'type' : 'ShortString'},\n {'field' : 'zipcode', 'type' : 'ShortString', 'has missing': True}\n ]\ndeduper = dedupe.Dedupe(variables, todo)",
"prompt_number": 7,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "# if already have training data...\ntraining_file = '../data/dedupe_training2.json'\ndeduper.readTraining(open(training_file,'r'))",
"prompt_number": 8,
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:reading training from file\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:Learned Weights\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(city: ShortString)', -0.3377057909965515)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(facility_name: String)', -0.5926158428192139)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(zipcode: ShortString)', -0.1446063369512558)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(state: ShortString)', -0.15747596323490143)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('((zipcode: ShortString): Not Missing)', 0.014522064477205276)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('((city: ShortString): Not Missing)', 0.27762895822525024)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('bias', 0.9713605642318726)\n"
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "dedupe.convenience.consoleLabel(deduper)",
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "deduper.train(ppc=0.01, uncovered_dupes=5)",
"prompt_number": 10,
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:20 folds\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.crossvalidation:using cross validation to find optimum alpha...\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.crossvalidation:optimum alpha: 0.010000\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:Learned Weights\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(city: ShortString)', -0.4464088976383209)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(facility_name: String)', -1.2190216779708862)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(zipcode: ShortString)', -0.49488386511802673)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(state: ShortString)', -0.48534145951271057)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('((zipcode: ShortString): Not Missing)', 0.14800745248794556)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('((city: ShortString): Not Missing)', 1.1579594612121582)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('bias', 2.345712661743164)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Tue Nov 25 09:45:13 2014\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.4, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.6, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.8, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.2, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Tue Nov 25 09:45:41 2014\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:coverage threshold: 322.64\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:Final predicate set:\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (nearIntegersPredicate, zipcode), SimplePredicate: (sameSevenCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (wholeFieldPredicate, zipcode), TfidfPredicate: (0.8, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (sameThreeCharStartPredicate, zipcode), SimplePredicate: (sameSevenCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (wholeFieldPredicate, facility_name), SimplePredicate: (tokenFieldPredicate, city))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (tokenFieldPredicate, zipcode), TfidfPredicate: (0.2, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (wholeFieldPredicate, zipcode), TfidfPredicate: (0.6, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (sameSevenCharStartPredicate, city), SimplePredicate: (firstTokenPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (sameSevenCharStartPredicate, city), TfidfPredicate: (0.2, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (firstIntegerPredicate, zipcode), SimplePredicate: (sameThreeCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (TfidfPredicate: (0.8, facility_name), SimplePredicate: (sameSevenCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (TfidfPredicate: (0.4, facility_name), SimplePredicate: (wholeFieldPredicate, city))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (TfidfPredicate: (0.6, facility_name), SimplePredicate: (sameSevenCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (firstIntegerPredicate, zipcode), SimplePredicate: (commonSixGram, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (TfidfPredicate: (0.2, facility_name), SimplePredicate: (commonFourGram, zipcode))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (sameSevenCharStartPredicate, city), SimplePredicate: (sameThreeCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (TfidfPredicate: (0.4, facility_name), SimplePredicate: (sameSevenCharStartPredicate, facility_name))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (tokenFieldPredicate, zipcode), SimplePredicate: (sameSevenCharStartPredicate, state))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (tokenFieldPredicate, facility_name), SimplePredicate: (sameSevenCharStartPredicate, city))\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.training:CompoundPredicate: (SimplePredicate: (tokenFieldPredicate, facility_name), SimplePredicate: (nearIntegersPredicate, zipcode))\n"
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "settings_file = '../data/dedupe_settings2'\ntraining_file = '../data/dedupe_training2.json'\ndeduper.writeTraining(open(training_file,'w'))\ndeduper.writeSettings(open(settings_file,'w'))",
"prompt_number": 11,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "markdown",
"source": "### Load model information and get blocking data ready"
},
{
"metadata": {},
"cell_type": "code",
"input": "settings_file = '../data/dedupe_settings'\ndeduper = dedupe.StaticDedupe(open(settings_file,'r'))",
"prompt_number": 49,
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:Learned Weights\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(city: ShortString)', -0.22436228394508362)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(facility_name: String)', -2.1074373722076416)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(zipcode: ShortString)', -1.4684042930603027)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('(state: ShortString)', -0.6717556715011597)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('((zipcode: ShortString): Not Missing)', 1.1019787788391113)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('((city: ShortString): Not Missing)', 5.169015884399414)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:('bias', 1.2692452669143677)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:[CompoundPredicate: (TfidfPredicate: (0.8, facility_name), SimplePredicate: (sameThreeCharStartPredicate, city)), CompoundPredicate: (SimplePredicate: (firstTokenPredicate, facility_name), SimplePredicate: (nearIntegersPredicate, zipcode)), CompoundPredicate: (TfidfPredicate: (0.4, facility_name), SimplePredicate: (nearIntegersPredicate, zipcode)), CompoundPredicate: (SimplePredicate: (wholeFieldPredicate, facility_name), SimplePredicate: (tokenFieldPredicate, state)), CompoundPredicate: (TfidfPredicate: (0.8, facility_name), SimplePredicate: (sameThreeCharStartPredicate, zipcode)), CompoundPredicate: (SimplePredicate: (wholeFieldPredicate, zipcode), TfidfPredicate: (0.6, facility_name)), CompoundPredicate: (SimplePredicate: (sameFiveCharStartPredicate, city), SimplePredicate: (sameThreeCharStartPredicate, facility_name)), CompoundPredicate: (TfidfPredicate: (0.6, facility_name), SimplePredicate: (commonSixGram, city)), CompoundPredicate: (SimplePredicate: (commonSixGram, facility_name), SimplePredicate: (firstTokenPredicate, zipcode)), CompoundPredicate: (SimplePredicate: (firstTokenPredicate, facility_name), TfidfPredicate: (0.6, facility_name)), CompoundPredicate: (SimplePredicate: (sameFiveCharStartPredicate, state), SimplePredicate: (sameSevenCharStartPredicate, facility_name)), CompoundPredicate: (TfidfPredicate: (0.4, facility_name), SimplePredicate: (sameSevenCharStartPredicate, city)), CompoundPredicate: (TfidfPredicate: (0.2, facility_name), SimplePredicate: (commonFourGram, zipcode)), CompoundPredicate: (TfidfPredicate: (0.4, facility_name), SimplePredicate: (sameSevenCharStartPredicate, facility_name)), CompoundPredicate: (SimplePredicate: (tokenFieldPredicate, zipcode), SimplePredicate: (sameSevenCharStartPredicate, state))]\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.api:{'facility_name': set([u'and', u'Center', u'Cancer', u'Institute', u'of', u'University', u'Research', u's', u'Health', u'at', u'Hospital', u'Medical'])}\n"
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "for field in deduper.blocker.tfidf_fields :\n field_data = potential[['facility_id',field]].T.to_dict().values()\n deduper.blocker.tfIdfBlock(field_data, field)",
"prompt_number": 12,
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Tue Nov 25 09:46:50 2014\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.4, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.6, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.8, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Canopy: TfidfPredicate: (0.2, facility_name)\n"
},
{
"output_type": "stream",
"stream": "stderr",
"text": "INFO:dedupe.blocking:Tue Nov 25 09:46:50 2014\n"
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "potential_indexed = potential.set_index('facility_id')\nfull_data = [(f, potential_indexed.loc[f].to_dict()) for f in potential_indexed.index \n if potential_indexed.loc[f].state == u'New York']\nblocks = [(i, j[0], j[1]) for i, j in enumerate(sorted(list(deduper.blocker(full_data))))]",
"prompt_number": 74,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "def candidates_gen(result_set) :\n \n block_key = None\n records = []\n for row in result_set :\n if row['block_key'] != block_key :\n if records:\n yield tuple(records)\n \n block_key = row['block_key']\n records = []\n \n records.append((row['facility_id'], row, set([])))\n \n if records :\n yield records\n",
"prompt_number": 75,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "bkfreq = nltk.FreqDist([bk for i, bk, f in blocks])",
"prompt_number": 76,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "c = [dict([(k, v if pd.notnull(v) else u'') \n for k, v in potential_indexed.loc[f].to_dict().items()] + [('block_key', bk), ('facility_id', f)]) \n for i, bk, f in blocks if bkfreq[bk] > 1]",
"prompt_number": 77,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "markdown",
"source": "### Find blocking threshold and cluster records"
},
{
"metadata": {},
"cell_type": "code",
"input": "clustered_dupes = deduper.matchBlocks(candidates_gen(c), .5)",
"prompt_number": 100,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "a = [[potential_indexed.loc[i] for i in t] for t, s in clustered_dupes]\nsorted([(i, len(b)) for i, b in enumerate(a)], key=lambda x: x[1], reverse=True)",
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "pd.DataFrame(a[951])",
"prompt_number": 110,
"outputs": [
{
"text": " facility_name city \\\n2547 Columbia University Medical Center New York City \n4956 Columbia University Medical Center - Morgan St... New York \n5336 Columbia University Medical Center New York \n8742 Columbia University New York \n11275 Columbia University Medical Center, Center for... New York \n12139 Columbia Univ New York \n12903 Columbia University / New York State Psychiatr... New-York \n15236 Columbia University New York \n17842 Columbia University New York City \n18652 Columbia University Medical Centre New York \n20133 Columbia University/NY Presbyterian Hospital New York \n22182 Columbia University New York \n22995 Columbia University New York \n28712 Columbia University - The Morgan Stanley Child... New York \n35366 Columbia P&S CRS New York \n38736 Columbia Universtiy Medical Center New York \n40126 Columbia Univerisity New York City New York City \n42422 Columbia University Medical Center New York \n47071 Columbia University New York \n52440 Columbia University Medical Center Children's ... New York \n59184 Columbia University Medical Center New york \n60118 Columbia University Medical Center NY \n60987 Columbia University Medical Center New York \n65031 Columbia University Medical Center- New York P... New York \n75798 Columbia University Department of Clinical Gen... New York \n75818 Columbia University Medical Center, Division o... New York \n76071 Columbia University, NY State Psychiatric Inst... New York \n78828 Columbia University New York \n83486 Columbia University Medical Center New York \n83758 Columbia University Medical Center - The Neuro... New York \n85568 Columbia University Medical Center - Departmen... New York City \n86522 Columbia University Neuropathy Research Center... New York \n87970 Columbia Univeristy Medical Center New York \n110955 Columbia University Medical Center New York \n118075 Columbia University Medical Center/New York Pr... New York \n122560 Columbia University NY \n130767 Columbia University- New York Presbyterian Hos... New York \n130892 Columbia University/New York State Psychiatric... New York \n134664 Columbia University Morningside Campus New York \n138803 Columbia University Medical Center, Morgan Sta... New York \n144025 Columbia Medical Center New York \n154025 Columbia University Medical Center - NYPH New York \n155013 Columbia University Medical Center, Harkness P... New York City \n168720 Columbia University Dialysis Center New York \n183705 Columbia University Medical Center New York \n190332 Columbia University Medical Center / Departmen... New York \n199622 Columbia University Medical Center, Herbert Ir... New York \n201520 Columbia University New York \n203757 Columbia University Medical Center- New York P... New York \n213622 Columbia University Medical Center- New York P... New York \n227281 Columbia University Medical Center/NY Presbyte... New York \n229846 Columbia University Medical Center - The Neuro... New York \n233589 Columbia University Medical Center Herbert Irv... New York \n240263 Columbia University Medical Center - Herbert I... New York \n247456 Columbia University Medical Center, Dept of Ca... New York \n256854 Columbia University-St. Luke's Hospital New York City \n268939 Columbia University Medical Center SC New York \n273694 Columbia University, New York \n275667 Columbia University Medical center / New York ... New York \n286765 Columbia University Medical Center- New York P... New York \n293719 Columbia Medical Center NY New York \n296436 Columbia University Medical Center/NY Presbyte... New York \n298063 Columbia University Medical Center/Center for ... New York \n309401 Columbia University & New York State Psyciatri... New York \n320034 Columbia Univ. Medical Center New York \n322769 Columbia University Medical Center, Department... New York \n327286 Columbia University Medical Center, Dept of De... New York \n329075 Columbia Univeristy New York \n329674 Columbia University Medical Center/New York-Pr... New York \n330967 Columbia University Medical Center, Neurologic... New York City \n332124 Columbia University Medical Center- New York P... New York \n348831 Columbia University Medical Center - Departmen... New York \n350720 Columbia University-NewYork-Presbyterian Hospital New York \n354523 Columbia University Medical Center-NYPH New York \n355819 Columbia University - Department of Neurology New York \n355900 Columbia University Medical Center New York \n363474 Columbia Univ Babies' Hosp New York \n368010 Columbia University Medical Center, Irving Cen... New York \n371192 Columbia University Medical Center - Neurologi... New York \n373756 Columbia University Hospital New York \n385969 Columbia University at the New York State Psyc... New York \n387619 Columbia University Medical Center New York, \n390253 Columbia University / Columbia Presbyterian Me... New York \n391620 Columbia University New York \n399865 Columbia University, Neurological Institute New York \n416039 Columbia University New York \n422003 Columbia University New York Presbyterian Hosp... New York \n447816 Columbia University New York \n454363 Columbia University New York \n458715 Columbia University Medical Center- New York P... New York \n469291 Columbia University Department of General Medi... New York \n471279 Columbia/New York State Psychiatric Institute New York \n504437 Columbia University, Statistical Analysis Center New York \n511669 Columbia University Medical Center Department ... New York \n524834 Columbia University Medical College/The New Yo... New York \n535163 Columbia University, Department of Surgery New York \n538581 Columbia University Medical Center, Neurologic... New York \n557585 Columbia University Medical Center; Pediatric ... New York \n559279 Columbia University Medical Center Neurologica... New York \n564795 Columbia University Cancer center New York \n582837 Columbia University/New York Presbyterian Hosp... New York \n587780 Columbia Medical Center, New York Psychiatric ... New York City \n601833 Columbia University Medical Center - New York ... New York \n614773 Columbia University, Department of Ophthalmolo... New York \n621714 Columbia University Medical Center New York \n646768 Columbia University, 180 Fort Washington Avenu... New York \n658845 Columbia University/New York State Psychiatric... New York City \n662069 Columbia University Medical Center- New York P... New York \n684091 Columbia University Department of Neurosurgery New York City \n689690 Columbia University Medical Center New York \n692345 Columbia University Medical Center., Dept. of ... New York \n706718 Columbia University Health Sciences New York \n710932 Columbia University (lung and liver) New York \n725310 Columbia University Medical Center Eastside New York \n725369 Columbia University Medical Center- New York P... New York \n739777 Columbia University Medical Center - Tier 2 site New York \n760849 Columbia University Medical Center (Cumc) New York \n767789 Columbia Unviversity, Deparment of Anesthesiology New York \n773810 Columbia University Sergievsky Center New York \n777957 Columbia University/Medical Center New York \n782030 Columbia University, Sergievsky Center P&S Box... New York \n782337 Columbia University Medical Center, 622 West 1... New York \n783541 Columbia University Medical Center- New York P... New York \n793428 Columbia University, Department of Anesthesiology New York \n794662 Columbia University Medical School New York City \n809748 Columbia University Medical Center and the New... New York \n816525 Columbia University Neuroendocrine Unit New York \n821022 Columbia University Medical Center & New York ... New York \n829556 Columbia University Medical Center NY \n833332 Columbia University/Presbyterian Medical Center New York \n839022 Columbia University Medical Center - Pediatric... New York \n843886 Columbia University Medical Center - Pediatric... New York \n852116 Columbia University Medical Center, Family Pla... New York \n853348 Columbia New York City \n869911 Columbia University - Neurology Institute New York \n889692 Columbia University Presbyterian Hospital New York \n897412 Columbia University/Health Science Division New York \n897916 Columbia University Rosenthal Center for CAM New York \n900397 Columbia University Neurological institute of NY New York \n913893 Columbia Medical University New York \n922654 Columbia Unviersity Medical Center New York \n941994 Columbia University Medical Ctr New York \n949858 Columbia University New York City \n958457 Columbia University New York City \n1002265 Columbia University, NewYork-Presbyterian Hosp... New York \n1006397 Columbia University Presbyterian Medical Center New York \n1011754 Columbia University/ New York Presbyterian Hos... New York \n1018203 Columbia University Department of Obstetrics &... New York \n1031267 Columbia University New York \n1045615 Columbai University Medical Center New York \n1052814 Columbia University Medical Center / Center fo... New York \n1056424 Columbia University Medical Center/The New Yor... New York \n1062122 Columbia University Medical Center/New York-Pr... New York \n1068526 Columbia University Health Center New York \n1076459 Columbia University Neurological Institute New York \n1077027 Columbia University Medical Center Herbert Irv... New York \n1095035 Columbia University Children's Hospital of New... New York \n1151766 Columbia University Medical College New York \n1157833 Columbia University Medical Center, Pediatric ... New York \n1182785 Columbia University Medical Center: Dept of Ne... New York \n1190285 Columbia University Medical Center/ NewYork Pr... New York \n1191558 Columbia New York \n1220634 Columbia University, New York Presbyterian Hos... New York \n1225967 Columbia University New York \n1252316 Columbia University Medical Center, Milstein H... New York \n1254275 Columbia University - Neurological Institute New York \n1256700 Columbia University Medical Center, Nephrology... New York \n1256701 Columbia University Medical Center, Glomerular... New York \n1260311 Columbia University Medical Center, Outpatient... New York \n1266213 Columbia University Medial Center New York \n1272034 Columbia University Medical Center New York City \n1276242 Columbia University Medical School New York City \n1280294 Columbia University Medical Center New York \n1284217 Columbia University Medical Center New York \n1284990 Columbia University Medical Center NYS Psychia... New York \n1313335 Columbia University, NY Presbyterian Hospital New York \n1316105 Columbia University Medical Center- Department... New York \n1323263 Columbia University Medical Center, Division o... New York \n\n state zipcode country \n2547 New York 10032 United States \n4956 New York 10032 United States \n5336 New York 10032 United States \n8742 New York United States \n11275 New York 10032 United States \n12139 New York 10032 United States \n12903 New York 10032 United States \n15236 New York 10032 United States \n17842 New York 10032 United States \n18652 New York 10032 United States \n20133 New York 10032 United States \n22182 New York 10032-3784 United States \n22995 New York 10032-1537 United States \n28712 New York 10032 United States \n35366 New York 10032-3732 United States \n38736 New York 10032 United States \n40126 New York 10032 United States \n42422 New York 10019 United States \n47071 New York 10032-3713 United States \n52440 New York 10032 United States \n59184 New York 10032 United States \n60118 New York 10032 United States \n60987 New York United States \n65031 New York 10032 United States \n75798 New York 10032 United States \n75818 New York 10032 United States \n76071 New York 10032 United States \n78828 New York 10021 United States \n83486 New York 10016 United States \n83758 New York 10032 United States \n85568 New York 10032 United States \n86522 New York 10032 United States \n87970 New York 10032 United States \n110955 New York 12549 United States \n118075 New York 10032 United States \n122560 New York 10032 United States \n130767 New York 10032 United States \n130892 New York 10032 United States \n134664 New York 10027 United States \n138803 New York 10032 United States \n144025 New York 10032 United States \n154025 New York 10032 United States \n155013 New York 10032 United States \n168720 New York 10032 United States \n183705 New York 10022 United States \n190332 New York 10032 United States \n199622 New York 10032 United States \n201520 New York 10027 United States \n203757 New York 10032 United States \n213622 New York 10032 United States \n227281 New York 10032-7133 United States \n229846 New York 10032 United States \n233589 New York 10032 United States \n240263 New York 10032 United States \n247456 New York 10032 United States \n256854 New York 10032 United States \n268939 New York 10032 United States \n273694 New York 10032 United States \n275667 New York 10032 United States \n286765 New York 10032 United States \n293719 New York 10032 United States \n296436 New York 10032 United States \n298063 New York 10019 United States \n309401 New York 10032 United States \n320034 New York 10032 United States \n322769 New York 10032 United States \n327286 New York 10032 United States \n329075 New York 10032 United States \n329674 New York 10032 United States \n330967 New York 10032 United States \n332124 New York 10032 United States \n348831 New York 10032 United States \n350720 New York 10032 United States \n354523 New York 10032 United States \n355819 New York 10032 United States \n355900 New York 10021 United States \n363474 New York 10032 United States \n368010 New York 10032 United States \n371192 New York 10032 United States \n373756 New York 10032 United States \n385969 New York 10032 United States \n387619 New York 10032 United States \n390253 New York 10032 United States \n391620 New York 10029 United States \n399865 New York 10032-3784 United States \n416039 New York 11032 United States \n422003 New York 10032 United States \n447816 New York 10023 United States \n454363 New York 10022 United States \n458715 New York 10032 United States \n469291 New York 10032 United States \n471279 New York 10032 United States \n504437 New York 10032 United States \n511669 New York 10032 United States \n524834 New York 10032 United States \n535163 New York 10032 United States \n538581 New York 10032 United States \n557585 New York 10032 United States \n559279 New York 10032 United States \n564795 New York United States \n582837 New York 10032 United States \n587780 New York 10032 United States \n601833 New York 10032 United States \n614773 New York 10032 United States \n621714 New York 10029 United States \n646768 New York 10032 United States \n658845 New York 10032 United States \n662069 New York 10032 United States \n684091 New York 10032 United States \n689690 New York 10068 United States \n692345 New York 10032 United States \n706718 New York 10032 United States \n710932 New York 10032 United States \n725310 New York 10022 United States \n725369 New York 10032 United States \n739777 New York 10032 United States \n760849 New York 10032 United States \n767789 New York 10032 United States \n773810 New York 10032 United States \n777957 New York 10032 United States \n782030 New York 10032 United States \n782337 New York 10032 United States \n783541 New York 10032 United States \n793428 New York 10032 United States \n794662 New York United States \n809748 New York 10032 United States \n816525 New York 10032 United States \n821022 New York 10027 United States \n829556 New York 10022 United States \n833332 New York 10032 United States \n839022 New York 10032 United States \n843886 New York United States \n852116 New York 10032 United States \n853348 New York United States \n869911 New York 10032 United States \n889692 New York 10032 United States \n897412 New York 10032 United States \n897916 New York 10032 United States \n900397 New York 10032 United States \n913893 New York 10032 United States \n922654 New York 10032 United States \n941994 New York United States \n949858 New York United States \n958457 New York 10027 United States \n1002265 New York 10022 United States \n1006397 New York 10032 United States \n1011754 New York 10032 United States \n1018203 New York 10032 United States \n1031267 New York 10036 United States \n1045615 New York 10032 United States \n1052814 New York 10032 United States \n1056424 New York 10032 United States \n1062122 New York 10032 United States \n1068526 New York 10032 United States \n1076459 New York 10032 United States \n1077027 New York 10032 United States \n1095035 New York 10032 United States \n1151766 New York 10032 United States \n1157833 New York 10032 United States \n1182785 New York 10032 United States \n1190285 New York 10032 United States \n1191558 New York 10032 United States \n1220634 New York 10032 United States \n1225967 New York 100027 United States \n1252316 New York 10032 United States \n1254275 New York 10032 United States \n1256700 New York 10032 United States \n1256701 New York 10032 United States \n1260311 New York 10032 United States \n1266213 New York 10032 United States \n1272034 New York United States \n1276242 New York 10032 United States \n1280294 New York 10087 United States \n1284217 New York 10032` United States \n1284990 New York 10032 United States \n1313335 New York 10032 United States \n1316105 New York 10032 United States \n1323263 New York 10032 United States \n\n[178 rows x 5 columns]",
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>facility_name</th>\n <th>city</th>\n <th>state</th>\n <th>zipcode</th>\n <th>country</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>2547 </th>\n <td> Columbia University Medical Center</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>4956 </th>\n <td> Columbia University Medical Center - Morgan St...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>5336 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>8742 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>11275 </th>\n <td> Columbia University Medical Center, Center for...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>12139 </th>\n <td> Columbia Univ</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>12903 </th>\n <td> Columbia University / New York State Psychiatr...</td>\n <td> New-York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>15236 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>17842 </th>\n <td> Columbia University</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>18652 </th>\n <td> Columbia University Medical Centre</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>20133 </th>\n <td> Columbia University/NY Presbyterian Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>22182 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032-3784</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>22995 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032-1537</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>28712 </th>\n <td> Columbia University - The Morgan Stanley Child...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>35366 </th>\n <td> Columbia P&amp;S CRS</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032-3732</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>38736 </th>\n <td> Columbia Universtiy Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>40126 </th>\n <td> Columbia Univerisity New York City</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>42422 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10019</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>47071 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032-3713</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>52440 </th>\n <td> Columbia University Medical Center Children's ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>59184 </th>\n <td> Columbia University Medical Center</td>\n <td> New york</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>60118 </th>\n <td> Columbia University Medical Center</td>\n <td> NY</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>60987 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>65031 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>75798 </th>\n <td> Columbia University Department of Clinical Gen...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>75818 </th>\n <td> Columbia University Medical Center, Division o...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>76071 </th>\n <td> Columbia University, NY State Psychiatric Inst...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>78828 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10021</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>83486 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10016</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>83758 </th>\n <td> Columbia University Medical Center - The Neuro...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>85568 </th>\n <td> Columbia University Medical Center - Departmen...</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>86522 </th>\n <td> Columbia University Neuropathy Research Center...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>87970 </th>\n <td> Columbia Univeristy Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>110955 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 12549</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>118075 </th>\n <td> Columbia University Medical Center/New York Pr...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>122560 </th>\n <td> Columbia University</td>\n <td> NY</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>130767 </th>\n <td> Columbia University- New York Presbyterian Hos...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>130892 </th>\n <td> Columbia University/New York State Psychiatric...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>134664 </th>\n <td> Columbia University Morningside Campus</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10027</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>138803 </th>\n <td> Columbia University Medical Center, Morgan Sta...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>144025 </th>\n <td> Columbia Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>154025 </th>\n <td> Columbia University Medical Center - NYPH</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>155013 </th>\n <td> Columbia University Medical Center, Harkness P...</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>168720 </th>\n <td> Columbia University Dialysis Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>183705 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10022</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>190332 </th>\n <td> Columbia University Medical Center / Departmen...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>199622 </th>\n <td> Columbia University Medical Center, Herbert Ir...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>201520 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10027</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>203757 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>213622 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>227281 </th>\n <td> Columbia University Medical Center/NY Presbyte...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032-7133</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>229846 </th>\n <td> Columbia University Medical Center - The Neuro...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>233589 </th>\n <td> Columbia University Medical Center Herbert Irv...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>240263 </th>\n <td> Columbia University Medical Center - Herbert I...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>247456 </th>\n <td> Columbia University Medical Center, Dept of Ca...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>256854 </th>\n <td> Columbia University-St. Luke's Hospital</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>268939 </th>\n <td> Columbia University Medical Center SC</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>273694 </th>\n <td> Columbia University,</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>275667 </th>\n <td> Columbia University Medical center / New York ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>286765 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>293719 </th>\n <td> Columbia Medical Center NY</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>296436 </th>\n <td> Columbia University Medical Center/NY Presbyte...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>298063 </th>\n <td> Columbia University Medical Center/Center for ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10019</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>309401 </th>\n <td> Columbia University &amp; New York State Psyciatri...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>320034 </th>\n <td> Columbia Univ. Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>322769 </th>\n <td> Columbia University Medical Center, Department...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>327286 </th>\n <td> Columbia University Medical Center, Dept of De...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>329075 </th>\n <td> Columbia Univeristy</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>329674 </th>\n <td> Columbia University Medical Center/New York-Pr...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>330967 </th>\n <td> Columbia University Medical Center, Neurologic...</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>332124 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>348831 </th>\n <td> Columbia University Medical Center - Departmen...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>350720 </th>\n <td> Columbia University-NewYork-Presbyterian Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>354523 </th>\n <td> Columbia University Medical Center-NYPH</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>355819 </th>\n <td> Columbia University - Department of Neurology</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>355900 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10021</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>363474 </th>\n <td> Columbia Univ Babies' Hosp</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>368010 </th>\n <td> Columbia University Medical Center, Irving Cen...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>371192 </th>\n <td> Columbia University Medical Center - Neurologi...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>373756 </th>\n <td> Columbia University Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>385969 </th>\n <td> Columbia University at the New York State Psyc...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>387619 </th>\n <td> Columbia University Medical Center</td>\n <td> New York,</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>390253 </th>\n <td> Columbia University / Columbia Presbyterian Me...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>391620 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>399865 </th>\n <td> Columbia University, Neurological Institute</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032-3784</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>416039 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 11032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>422003 </th>\n <td> Columbia University New York Presbyterian Hosp...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>447816 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10023</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>454363 </th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10022</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>458715 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>469291 </th>\n <td> Columbia University Department of General Medi...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>471279 </th>\n <td> Columbia/New York State Psychiatric Institute</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>504437 </th>\n <td> Columbia University, Statistical Analysis Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>511669 </th>\n <td> Columbia University Medical Center Department ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>524834 </th>\n <td> Columbia University Medical College/The New Yo...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>535163 </th>\n <td> Columbia University, Department of Surgery</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>538581 </th>\n <td> Columbia University Medical Center, Neurologic...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>557585 </th>\n <td> Columbia University Medical Center; Pediatric ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>559279 </th>\n <td> Columbia University Medical Center Neurologica...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>564795 </th>\n <td> Columbia University Cancer center</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>582837 </th>\n <td> Columbia University/New York Presbyterian Hosp...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>587780 </th>\n <td> Columbia Medical Center, New York Psychiatric ...</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>601833 </th>\n <td> Columbia University Medical Center - New York ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>614773 </th>\n <td> Columbia University, Department of Ophthalmolo...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>621714 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>646768 </th>\n <td> Columbia University, 180 Fort Washington Avenu...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>658845 </th>\n <td> Columbia University/New York State Psychiatric...</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>662069 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>684091 </th>\n <td> Columbia University Department of Neurosurgery</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>689690 </th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10068</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>692345 </th>\n <td> Columbia University Medical Center., Dept. of ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>706718 </th>\n <td> Columbia University Health Sciences</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>710932 </th>\n <td> Columbia University (lung and liver)</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>725310 </th>\n <td> Columbia University Medical Center Eastside</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10022</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>725369 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>739777 </th>\n <td> Columbia University Medical Center - Tier 2 site</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>760849 </th>\n <td> Columbia University Medical Center (Cumc)</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>767789 </th>\n <td> Columbia Unviversity, Deparment of Anesthesiology</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>773810 </th>\n <td> Columbia University Sergievsky Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>777957 </th>\n <td> Columbia University/Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>782030 </th>\n <td> Columbia University, Sergievsky Center P&amp;S Box...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>782337 </th>\n <td> Columbia University Medical Center, 622 West 1...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>783541 </th>\n <td> Columbia University Medical Center- New York P...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>793428 </th>\n <td> Columbia University, Department of Anesthesiology</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>794662 </th>\n <td> Columbia University Medical School</td>\n <td> New York City</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>809748 </th>\n <td> Columbia University Medical Center and the New...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>816525 </th>\n <td> Columbia University Neuroendocrine Unit</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>821022 </th>\n <td> Columbia University Medical Center &amp; New York ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10027</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>829556 </th>\n <td> Columbia University Medical Center</td>\n <td> NY</td>\n <td> New York</td>\n <td> 10022</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>833332 </th>\n <td> Columbia University/Presbyterian Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>839022 </th>\n <td> Columbia University Medical Center - Pediatric...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>843886 </th>\n <td> Columbia University Medical Center - Pediatric...</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>852116 </th>\n <td> Columbia University Medical Center, Family Pla...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>853348 </th>\n <td> Columbia</td>\n <td> New York City</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>869911 </th>\n <td> Columbia University - Neurology Institute</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>889692 </th>\n <td> Columbia University Presbyterian Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>897412 </th>\n <td> Columbia University/Health Science Division</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>897916 </th>\n <td> Columbia University Rosenthal Center for CAM</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>900397 </th>\n <td> Columbia University Neurological institute of NY</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>913893 </th>\n <td> Columbia Medical University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>922654 </th>\n <td> Columbia Unviersity Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>941994 </th>\n <td> Columbia University Medical Ctr</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>949858 </th>\n <td> Columbia University</td>\n <td> New York City</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>958457 </th>\n <td> Columbia University</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10027</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1002265</th>\n <td> Columbia University, NewYork-Presbyterian Hosp...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10022</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1006397</th>\n <td> Columbia University Presbyterian Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1011754</th>\n <td> Columbia University/ New York Presbyterian Hos...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1018203</th>\n <td> Columbia University Department of Obstetrics &amp;...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1031267</th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10036</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1045615</th>\n <td> Columbai University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1052814</th>\n <td> Columbia University Medical Center / Center fo...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1056424</th>\n <td> Columbia University Medical Center/The New Yor...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1062122</th>\n <td> Columbia University Medical Center/New York-Pr...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1068526</th>\n <td> Columbia University Health Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1076459</th>\n <td> Columbia University Neurological Institute</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1077027</th>\n <td> Columbia University Medical Center Herbert Irv...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1095035</th>\n <td> Columbia University Children's Hospital of New...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1151766</th>\n <td> Columbia University Medical College</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1157833</th>\n <td> Columbia University Medical Center, Pediatric ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1182785</th>\n <td> Columbia University Medical Center: Dept of Ne...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1190285</th>\n <td> Columbia University Medical Center/ NewYork Pr...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1191558</th>\n <td> Columbia</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1220634</th>\n <td> Columbia University, New York Presbyterian Hos...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1225967</th>\n <td> Columbia University</td>\n <td> New York</td>\n <td> New York</td>\n <td> 100027</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1252316</th>\n <td> Columbia University Medical Center, Milstein H...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1254275</th>\n <td> Columbia University - Neurological Institute</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1256700</th>\n <td> Columbia University Medical Center, Nephrology...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1256701</th>\n <td> Columbia University Medical Center, Glomerular...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1260311</th>\n <td> Columbia University Medical Center, Outpatient...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1266213</th>\n <td> Columbia University Medial Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1272034</th>\n <td> Columbia University Medical Center</td>\n <td> New York City</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1276242</th>\n <td> Columbia University Medical School</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1280294</th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10087</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1284217</th>\n <td> Columbia University Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032`</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1284990</th>\n <td> Columbia University Medical Center NYS Psychia...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1313335</th>\n <td> Columbia University, NY Presbyterian Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1316105</th>\n <td> Columbia University Medical Center- Department...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1323263</th>\n <td> Columbia University Medical Center, Division o...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n </tbody>\n</table>\n<p>178 rows × 5 columns</p>\n</div>",
"output_type": "pyout",
"metadata": {},
"prompt_number": 110
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "pd.DataFrame(a[956])",
"prompt_number": 109,
"outputs": [
{
"text": " facility_name city \\\n3426 Mount Sinai School of Medicine New York \n5229 Mount Sinai School of Medicine New York \n5231 Mount Sinai School of Medicine Department of U... New York \n5436 Mount Sinai School of Medicine & Mount Sinai G... New York \n11595 Mount Sinai Downtown Comprehensive Health Program New York \n19852 Mount Sinai School of Medicine Mt. Sinai Medic... New York \n24116 Mount Sinai New York City \n28461 Mount Sinai Med Ctr New York \n28825 Mount Sinai School of Medicine, Department of ... New York \n33277 Mt Sinai School of Medicine New York \n36194 Mt. Sinai Hospital New York \n36305 Mt Sinai Hospital New York \n37602 Mount Sinai School of Medicine New York City \n41545 Mount Sinai Hospital Neonatal Intensive Care Unit New York \n47184 Mt. Sinai School of Medicine - MS Center New York \n47571 Mt Sinai Hospital - Dept of Dermatology New York \n50602 Mount Sinai School of Medicine, The Tisch Canc... New York \n52113 The Mount Sinai School of Medicine New York \n55626 Mount Sinai School of Medicine New York \n63912 Mount Sinai Hospital New York \n64108 Mt Sinai Hospital, Department of Dermatology New York \n64772 Mount Sinai Med Ctr / Pediatrics New York \n67348 Mt. Sinai Hospital NY \n68603 Mount Sinai Med Ctr New York \n72084 Mount Sinai School of Medicine New York \n72360 Mount Sinai School Of Medicine New York \n73028 Mount Sinai School of Medicine Faculty Practic... New York \n87536 Mt. Sinai School of Medicine New York \n88177 Mount Sinai Hosp New York \n103042 Mount Sinai Hospital New York \n112638 Mounst Sinai School of Medicine New York \n119123 Mt Sinai Hospital New York \n123712 Mount Sinai School of Medicine New York \n124181 Mount Sinai School of Medicine / Mount Sinai H... New York \n124291 The Mount Sinai Hospital New York \n126660 Mount Sinai School of Medicine/Dept of Psychia... New York \n132633 Mount Sinai Porphyria Comprehensive Diagnostic... New York \n134775 Mount Sinai Rehabilitation Center New York \n140056 Mount Sinai School of Medicine - Medical Center New York \n140503 Mt. Sinai School of Med New York \n147079 Mt. Sinai New York City \n151393 Mt. Sinai New York \n153493 Mount Sinai School of Medicine Dept of Onc. New York \n154687 Mount Sinai Hospital New York \n162688 Mount Sinai Hospital - NY New York \n163143 Mount Sinai School of Medicine, Dept. of Ophth... New York \n170021 Mount Sinai School of Medicine Parkinson and m... New York \n177606 Mount Sinai School of Medecine New York \n185317 Mount Sinai - PRIME New York \n218353 Mount Sinai Hospital New York City \n235179 Mt. Sinai Hospital New York City \n240877 Mount Sinai School of Medicine/Seaver Center New York \n241167 Mount Sinai School of Medicine Lab New York \n242846 Mt. Sinai School of Medicine New york \n245185 Mount Sinai School of Medicine NY \n263860 Mt. Sinai School of Medicine, Div. of Ped. Inf... New York \n268547 Mt. Sinai Hospital New York City \n269527 Mt. Sinai School of Medicine New York \n278586 Mount Sinai School of Medicine Recanati/Miller... New York \n281270 Mount Sinai Hospital New York \n282947 Mount Sinai School of Medicine, The New York \n289549 Mount Sinai Med Ctr / Jack Martin Fund Clinic New York \n298433 Mount Sinai School of Medicine Dept of Oncology New York \n302962 Mount Sinai School of Medicine SC New York \n322345 Mount Sinai New York New York City \n340372 Mount Sinai School of Medicine-Tisch Cancer In... New York \n354820 Mount Sinai New York \n357793 Mount Sinai School of Medicine Mt. Sinai Schoo... New York \n366810 Mount Sinai Med Ctr / SOCA New York \n370886 Mount Sinai School of Medicine New York \n377755 Mt. Sinai School of Medicine New York City \n380486 Mount Sinai Hospital New York City \n417930 Mount Sinai Hospital New York City \n419709 Mount Sinai School of Medicine IBD Research Ce... New York \n421533 Mount Sinai Hemophilia Ctr / Mount Sinai Med Ctr New York \n448310 Mt. Sinai Hospital New York \n461007 Mt. Sinai New York \n486780 Mount Sinai School of Medicine New York \n492798 The Mount Sinai School of Medicine New York \n521684 Mt. Sinai School of Medicine/ Mt. Sinai Medica... New York \n535906 Mount Sinai School of Medicine, Department of ... New York \n543279 Mount Sinai Med Ctr / Hemophilia Treatment Ctr New York \n568603 Mount Sinai School of Medicine, IBD Research C... New York \n576247 Mt. Sinai School of Medicine New York \n596956 Mount Sinai Hospital - Mood & Personality Rese... New York \n613193 Mount Sinai's Child and Adolescent Outpatient ... New York \n635320 Mount Sinai Hospital, One Gustave L. Levy Plac... New York \n652584 Mt. Sinai School of Medicine New York \n665129 Mount Sinai School of Medicine, Alzheimer's Di... New York \n665623 Mount Sinai School of Medicine IBD Research Ce... New York \n688525 Mt. Sinai School Of Medicine New York \n689193 Mt Sinai Hospitl New York \n739776 Mount Sinai School of Medicine - Tier 2 Site New York \n748005 Mount Sinai School of Medicine, Pediatrics New York \n758905 Mt. Sinai School of Medicine NY \n762389 Mount Sinai School of Medicine, Corinne Goldsm... New York \n769347 Mount Sinai School of Medicine Division of Vas... New York \n773890 Mount Sinai School Of Medicine Imaging Science... New York \n779229 Mt. Sinai School of Medicine New York \n783568 Mount Sinai School Medicine New York \n790681 Mount Sinai School of Medcine New York \n790768 Mount Sinai School of Medicine New York \n793974 Mount Sinai New York \n794010 The Mt. Sinai Hospital New York \n828998 Mount Sinai School of Medicine Study Coordinator New York \n848796 Mount Sinai School of Medicine, Department of ... New York \n866908 Mount Sinai School of Medicine New York City \n871754 Mount Sinai School of Medicine NYC \n922498 Mount Sinai School of Medicine Clinical Dermat... New York \n927642 Mount Sinai School Medical Center New York \n933269 Mt Sinai New York \n935770 The Mount Sinai School of Medicine, Department... New York \n961572 Mt. Sinai School of Medicine Department of Der... New York \n1001468 Mount Sinai Hosp New York \n1026366 Mount SInai School of Medicine New York \n1039653 Mt Sinai School of Medcine New York \n1055920 Mount Sinai School of Medicine New York \n1087858 Mount Sinai, One Gustave L. Levy Place, Box 1118 New York \n1154249 Mount Sinai School of Medicine New York \n1195272 Mt. Sinai School of Medicine Div. Dermatologic... New York \n1216417 Mount Sinai School of Medicine - Seaver Autism... New York \n1217910 Mount Sinai School of Medicine, Department of ... New York \n1224411 Mount Sinai School of Medicine Department of D... New York \n1225483 Mount Sinai School of Medicine - Seaver Autism... New York \n1249180 Mount Sinai School of Medicine, Department of ... New York \n1265953 Mt. Sinai Hospital New York \n1274143 Mount Sinai Med Ctr / Klingenstein Clinical Ctr New York \n1276173 Mount Sinai New York \n1292397 Mount Sinai School of Medicine Hospital New York \n1306255 Mount Sinai School of Medicine Mt Sinai New York \n1307772 Mount Sinai Hospital Division of Newborn Medicine New York \n\n state zipcode country \n3426 New York United States \n5229 New York 10029 United States \n5231 New York 10029 United States \n5436 New York 10029 United States \n11595 New York 10011 United States \n19852 New York 10029 United States \n24116 New York 10029 United States \n28461 New York 10029 United States \n28825 New York 10029 United States \n33277 New York 10029 United States \n36194 New York United States \n36305 New York United States \n37602 New York 10029 United States \n41545 New York 10029 United States \n47184 New York 10029 United States \n47571 New York 10029 United States \n50602 New York 10029-6574 United States \n52113 New York 10029 United States \n55626 New York 11029 United States \n63912 New York 10029 United States \n64108 New York 10029 United States \n64772 New York 10029 United States \n67348 New York 10029 United States \n68603 New York 100296574 United States \n72084 New York NY 10029 United States \n72360 New York 10029 United States \n73028 New York 10029 United States \n87536 New York 10029 United States \n88177 New York 100296574 United States \n103042 New York 10128 United States \n112638 New York 10029 United States \n119123 New York 10029 United States \n123712 New York 10032 United States \n124181 New York 10029 United States \n124291 New York 10029 United States \n126660 New York 10029 United States \n132633 New York 10029 United States \n134775 New York 10029 United States \n140056 New York 10029 United States \n140503 New York United States \n147079 New York 10032 United States \n151393 New York 10029 United States \n153493 New York 10029 United States \n154687 New York 10021 United States \n162688 New York 10029 United States \n163143 New York 10029 United States \n170021 New York 10029 United States \n177606 New York 10029 United States \n185317 New York 10029 United States \n218353 New York United States \n235179 New York 10128 United States \n240877 New York 10029 United States \n241167 New York 10029 United States \n242846 New York 10001 United States \n245185 New York 10029 United States \n263860 New York 10029 United States \n268547 New York 01129 United States \n269527 New York 10128 United States \n278586 New York 10029 United States \n281270 New York United States \n282947 New York 10029 United States \n289549 New York 10029 United States \n298433 New York 10029 United States \n302962 New York 10029 United States \n322345 New York 10029 United States \n340372 New York 10029 United States \n354820 New York 10001 United States \n357793 New York 10029 United States \n366810 New York 100296574 United States \n370886 New York 10028 United States \n377755 New York 10029 United States \n380486 New York 10029 United States \n417930 New York 10128 United States \n419709 New York 10029 United States \n421533 New York 10029 United States \n448310 New York 10029 United States \n461007 New York United States \n486780 New York 10029-6574 United States \n492798 New York 10029-6547 United States \n521684 New York 10029 United States \n535906 New York 10029-6574 United States \n543279 New York 10029 United States \n568603 New York 10028 United States \n576247 New York United States \n596956 New York 10029 United States \n613193 New York 10029 United States \n635320 New York 10029 United States \n652584 New York 10029-6574 United States \n665129 New York 10029 United States \n665623 New York 10028 United States \n688525 New York 10029 United States \n689193 New York 10029 United States \n739776 New York 10029 United States \n748005 New York 10029 United States \n758905 New York 10029-6574 United States \n762389 New York United States \n769347 New York 10029 United States \n773890 New York 10029 United States \n779229 New York 10019 United States \n783568 New York 10029 United States \n790681 New York 10029 United States \n790768 New York 10128 United States \n793974 New York United States \n794010 New York 10029 United States \n828998 New York 10029 United States \n848796 New York 10029 United States \n866908 New York 10029-6574 United States \n871754 New York 10029 United States \n922498 New York 10029 United States \n927642 New York 10029 United States \n933269 New York United States \n935770 New York 10029 United States \n961572 New York 10029 United States \n1001468 New York 10029 United States \n1026366 New York 10029 United States \n1039653 New York 10029 United States \n1055920 New York 10029-6500 United States \n1087858 New York 10029 United States \n1154249 New York 07624 United States \n1195272 New York 10029 United States \n1216417 New York 10029 United States \n1217910 New York 10029 United States \n1224411 New York 10029 United States \n1225483 New York 10029 United States \n1249180 New York 10029 United States \n1265953 New York 10021 United States \n1274143 New York 10029 United States \n1276173 New York 10029 United States \n1292397 New York 10029 United States \n1306255 New York 10029 United States \n1307772 New York 10029 United States \n\n[131 rows x 5 columns]",
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>facility_name</th>\n <th>city</th>\n <th>state</th>\n <th>zipcode</th>\n <th>country</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>3426 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>5229 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>5231 </th>\n <td> Mount Sinai School of Medicine Department of U...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>5436 </th>\n <td> Mount Sinai School of Medicine &amp; Mount Sinai G...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>11595 </th>\n <td> Mount Sinai Downtown Comprehensive Health Program</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10011</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>19852 </th>\n <td> Mount Sinai School of Medicine Mt. Sinai Medic...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>24116 </th>\n <td> Mount Sinai</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>28461 </th>\n <td> Mount Sinai Med Ctr</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>28825 </th>\n <td> Mount Sinai School of Medicine, Department of ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>33277 </th>\n <td> Mt Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>36194 </th>\n <td> Mt. Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>36305 </th>\n <td> Mt Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>37602 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>41545 </th>\n <td> Mount Sinai Hospital Neonatal Intensive Care Unit</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>47184 </th>\n <td> Mt. Sinai School of Medicine - MS Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>47571 </th>\n <td> Mt Sinai Hospital - Dept of Dermatology</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>50602 </th>\n <td> Mount Sinai School of Medicine, The Tisch Canc...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029-6574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>52113 </th>\n <td> The Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>55626 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 11029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>63912 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>64108 </th>\n <td> Mt Sinai Hospital, Department of Dermatology</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>64772 </th>\n <td> Mount Sinai Med Ctr / Pediatrics</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>67348 </th>\n <td> Mt. Sinai Hospital</td>\n <td> NY</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>68603 </th>\n <td> Mount Sinai Med Ctr</td>\n <td> New York</td>\n <td> New York</td>\n <td> 100296574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>72084 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> NY 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>72360 </th>\n <td> Mount Sinai School Of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>73028 </th>\n <td> Mount Sinai School of Medicine Faculty Practic...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>87536 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>88177 </th>\n <td> Mount Sinai Hosp</td>\n <td> New York</td>\n <td> New York</td>\n <td> 100296574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>103042 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10128</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>112638 </th>\n <td> Mounst Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>119123 </th>\n <td> Mt Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>123712 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>124181 </th>\n <td> Mount Sinai School of Medicine / Mount Sinai H...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>124291 </th>\n <td> The Mount Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>126660 </th>\n <td> Mount Sinai School of Medicine/Dept of Psychia...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>132633 </th>\n <td> Mount Sinai Porphyria Comprehensive Diagnostic...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>134775 </th>\n <td> Mount Sinai Rehabilitation Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>140056 </th>\n <td> Mount Sinai School of Medicine - Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>140503 </th>\n <td> Mt. Sinai School of Med</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>147079 </th>\n <td> Mt. Sinai</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10032</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>151393 </th>\n <td> Mt. Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>153493 </th>\n <td> Mount Sinai School of Medicine Dept of Onc.</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>154687 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10021</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>162688 </th>\n <td> Mount Sinai Hospital - NY</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>163143 </th>\n <td> Mount Sinai School of Medicine, Dept. of Ophth...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>170021 </th>\n <td> Mount Sinai School of Medicine Parkinson and m...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>177606 </th>\n <td> Mount Sinai School of Medecine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>185317 </th>\n <td> Mount Sinai - PRIME</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>218353 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York City</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>235179 </th>\n <td> Mt. Sinai Hospital</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10128</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>240877 </th>\n <td> Mount Sinai School of Medicine/Seaver Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>241167 </th>\n <td> Mount Sinai School of Medicine Lab</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>242846 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New york</td>\n <td> New York</td>\n <td> 10001</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>245185 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> NY</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>263860 </th>\n <td> Mt. Sinai School of Medicine, Div. of Ped. Inf...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>268547 </th>\n <td> Mt. Sinai Hospital</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 01129</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>269527 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10128</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>278586 </th>\n <td> Mount Sinai School of Medicine Recanati/Miller...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>281270 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>282947 </th>\n <td> Mount Sinai School of Medicine, The</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>289549 </th>\n <td> Mount Sinai Med Ctr / Jack Martin Fund Clinic</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>298433 </th>\n <td> Mount Sinai School of Medicine Dept of Oncology</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>302962 </th>\n <td> Mount Sinai School of Medicine SC</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>322345 </th>\n <td> Mount Sinai New York</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>340372 </th>\n <td> Mount Sinai School of Medicine-Tisch Cancer In...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>354820 </th>\n <td> Mount Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10001</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>357793 </th>\n <td> Mount Sinai School of Medicine Mt. Sinai Schoo...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>366810 </th>\n <td> Mount Sinai Med Ctr / SOCA</td>\n <td> New York</td>\n <td> New York</td>\n <td> 100296574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>370886 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10028</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>377755 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>380486 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>417930 </th>\n <td> Mount Sinai Hospital</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10128</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>419709 </th>\n <td> Mount Sinai School of Medicine IBD Research Ce...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>421533 </th>\n <td> Mount Sinai Hemophilia Ctr / Mount Sinai Med Ctr</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>448310 </th>\n <td> Mt. Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>461007 </th>\n <td> Mt. Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>486780 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029-6574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>492798 </th>\n <td> The Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029-6547</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>521684 </th>\n <td> Mt. Sinai School of Medicine/ Mt. Sinai Medica...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>535906 </th>\n <td> Mount Sinai School of Medicine, Department of ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029-6574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>543279 </th>\n <td> Mount Sinai Med Ctr / Hemophilia Treatment Ctr</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>568603 </th>\n <td> Mount Sinai School of Medicine, IBD Research C...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10028</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>576247 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>596956 </th>\n <td> Mount Sinai Hospital - Mood &amp; Personality Rese...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>613193 </th>\n <td> Mount Sinai's Child and Adolescent Outpatient ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>635320 </th>\n <td> Mount Sinai Hospital, One Gustave L. Levy Plac...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>652584 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029-6574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>665129 </th>\n <td> Mount Sinai School of Medicine, Alzheimer's Di...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>665623 </th>\n <td> Mount Sinai School of Medicine IBD Research Ce...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10028</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>688525 </th>\n <td> Mt. Sinai School Of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>689193 </th>\n <td> Mt Sinai Hospitl</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>739776 </th>\n <td> Mount Sinai School of Medicine - Tier 2 Site</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>748005 </th>\n <td> Mount Sinai School of Medicine, Pediatrics</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>758905 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> NY</td>\n <td> New York</td>\n <td> 10029-6574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>762389 </th>\n <td> Mount Sinai School of Medicine, Corinne Goldsm...</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>769347 </th>\n <td> Mount Sinai School of Medicine Division of Vas...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>773890 </th>\n <td> Mount Sinai School Of Medicine Imaging Science...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>779229 </th>\n <td> Mt. Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10019</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>783568 </th>\n <td> Mount Sinai School Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>790681 </th>\n <td> Mount Sinai School of Medcine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>790768 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10128</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>793974 </th>\n <td> Mount Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>794010 </th>\n <td> The Mt. Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>828998 </th>\n <td> Mount Sinai School of Medicine Study Coordinator</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>848796 </th>\n <td> Mount Sinai School of Medicine, Department of ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>866908 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York City</td>\n <td> New York</td>\n <td> 10029-6574</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>871754 </th>\n <td> Mount Sinai School of Medicine</td>\n <td> NYC</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>922498 </th>\n <td> Mount Sinai School of Medicine Clinical Dermat...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>927642 </th>\n <td> Mount Sinai School Medical Center</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>933269 </th>\n <td> Mt Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> </td>\n <td> United States</td>\n </tr>\n <tr>\n <th>935770 </th>\n <td> The Mount Sinai School of Medicine, Department...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>961572 </th>\n <td> Mt. Sinai School of Medicine Department of Der...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1001468</th>\n <td> Mount Sinai Hosp</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1026366</th>\n <td> Mount SInai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1039653</th>\n <td> Mt Sinai School of Medcine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1055920</th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029-6500</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1087858</th>\n <td> Mount Sinai, One Gustave L. Levy Place, Box 1118</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1154249</th>\n <td> Mount Sinai School of Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 07624</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1195272</th>\n <td> Mt. Sinai School of Medicine Div. Dermatologic...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1216417</th>\n <td> Mount Sinai School of Medicine - Seaver Autism...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1217910</th>\n <td> Mount Sinai School of Medicine, Department of ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1224411</th>\n <td> Mount Sinai School of Medicine Department of D...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1225483</th>\n <td> Mount Sinai School of Medicine - Seaver Autism...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1249180</th>\n <td> Mount Sinai School of Medicine, Department of ...</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1265953</th>\n <td> Mt. Sinai Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10021</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1274143</th>\n <td> Mount Sinai Med Ctr / Klingenstein Clinical Ctr</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1276173</th>\n <td> Mount Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1292397</th>\n <td> Mount Sinai School of Medicine Hospital</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1306255</th>\n <td> Mount Sinai School of Medicine Mt Sinai</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n <tr>\n <th>1307772</th>\n <td> Mount Sinai Hospital Division of Newborn Medicine</td>\n <td> New York</td>\n <td> New York</td>\n <td> 10029</td>\n <td> United States</td>\n </tr>\n </tbody>\n</table>\n<p>131 rows × 5 columns</p>\n</div>",
"output_type": "pyout",
"metadata": {},
"prompt_number": 109
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "clustered_dupes_dict = {'Illinois': clustered_dupes[:]}",
"prompt_number": 73,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "",
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
}
],
"metadata": {}
}
],
"metadata": {
"name": "",
"signature": "sha256:87611c22ec6687bb887a6aba0f2505de7c6c038b91905c7f8e20fa8cf4257a51",
"gist_id": "eee672d26aa9ef6ccd01"
},
"nbformat": 3
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment