Home United States Forum United States Guide Moving to United States Real Estate Healthcare in United States
United States
Resources
City Guides
JoinSign In

NYC Hospitals

By Betsy Burlingame

Last updated on: Sep 29, 2019

Summary: New York City is home to some of the most renowned hospitals in the world. If you're a NYC expat, you should familiarize yourself with NYC hospitals before a medical emergency or need arises. And, when you're choosing expat health insurance, you'll want to know which hospitals are included in network.

Healthcare in NYC - NYC Hospitals

NYU Langone Health

NYU Langone Health has numerous facilities throughout New York City. Most notable are Kimmel Pavilion, which is pictured above is located on East 34th Street (at 1st), Tisch Hospital just next door to Kimmel Pavilion at 1st Avenue (near 33rd Street), Hassenfeld Children's Hospital, NYU Langone Hospital in Brooklyn and

Kimmel Pavilion (includes Hassenfeld Children's Hospital)

30 7th Avenue
New York, New York 10011
Tel: 1(646) 665-6000

Expats living in United States interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA. Get a Quote

Expats living in United States interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

NYU Tisch Hospital

550 First Avenue
New York, New York 10016
Tel: 212-263-5800

NYU Langone Tisch Hospital

NYU Langone Orthopedic Hospital

301 East 17th Street
New York, New York 10003
Tel: 212-598-6000

NYU Langone Orthopedic Hospital

NYU Langone Hospital Brooklyn

150 55th Street
Brooklyn, New York 11220
Tel: 718-630-7000

Memorial Sloan Kettering Cancer Center

Memorial Sloan Kettering Cancer Center (MSK) is a world-renowned cancer hospital. In addition to its main locations on Manhattan's Upper East Side (multiple buildings and centers), MSK has 3 locations in New Jersey, 3 locations on Long Island and one location in Westchester. Their expansion into suburban NYC areas has made it easier for people through the tri-state area to access top quality cancer treatment.

Main Building
1275 York Avenue
New York, New York 10065
Tel: 800-525-2225

Memorial Sloan Kettering NYC

Expat Health Insurance in United States

Expats interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

New York-Presbyterian Hospital

New York-Presbyterian is another world-renowned hospital with locations throughout New York City. Over the years, several top hospitals joined together to become New York-Presbyterian with the most notable being Columbia Presbyterian and Weill Cornell Medical Center.

See Map for Numerous Locations
Tel: 877-697-9355

Weill Cornell Hospital NYC

Hospital for Special Surgery

The Hospital for Special Surgery is consistently ranked among the top orthopedic hospitals in the world.

See Map for Numerous Locations
Tel: 877-697-9355

Hospital for Special Surgery

Lenox Health Greenwich Village - Northwell Health

If you live in Greenwich Village, your local emergency room is located in Lenox Health Greenwich Village - Northwell Health. Lenox Health Greenwich Village also operates several neighborhood physician partner practices and urgent care facilities.

Emergency Department
30 7th Avenue
New York, New York 10011
Tel: 1(646) 665-6000

Lenox Health Greenwich Village Emergency

Bellevue Hospital

Bellevue Hospital (aka NYC Health + Hospitals/Bellevue) is the oldest hospital in America. Bellevue has an emergency room and level 1 Trauma center. Bellevue is known for its psychiatric care and services, but also has cardiology, neurology, toxicology, and neonatology departments. They have a list of services at Bellevue on their website that makes it easy to determine if Bellevue is the right choice for your medical issue or emergency.

NYC Health + Hospitals/Bellevue
462 First Avenue
New York, New York 10016

Tel: 1(212)562-4141

Bellevue Hospital

Mount Sinai Beth Israel Hospital

Mount Sinai has hospitals and facilities throughout New York City (List of Locations).

281 First Avenue
(First Avenue at 16th Street)
New York, New York 10003

Tel: 1(212) 420-2000

Mount Sinai Beth Israel Hospital

Other Key Mount Sinai Locations:

Mount Sinai Brooklyn
3201 Kings Highway
Brooklyn, New York 11234

Tel: 1(718) 252-3000

Mount Sinai Queens
25-10 30th Avenue
Astoria, New York 11102

Tel: 1(718) 932-1000

Mount Sinai St. Luke's
1111 Amsterdam Avenue
New York, New York 10025

Tel: 1(212) 523-4000

Mount Sinai West
1000 Tenth Avenue
New York, New York 10019

Tel: 1(212) 523-4000

The Mount Sinai Hospital
1 Gustave L. Levy Place
New York, New York 10029-6574

Tel: 1(212) 241-6500

Mount Sinai Kravis Children's Hospital
1184 Fifth Avenue
New York, New York 10029

Tel: 1(212) 241-9500

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in United States from our partner, Cigna Global Health.
Get a Quote

More about New York

Guide to Living in New York

Guide to Living in New York

Expats in New York City will quickly find that New Yorkers defy their stereotypes. New York is a melting pot of people from every corner of the globe and every income level -- all brought together by the city's subway system. Some expats enjoy living right in the hustle and bustle of the city. Others choose to enjoy a bit more greenery and space in a suburb on New York.

Best Places to Live in New York

Best Places to Live in New York

Expats moving to New York City often find it daunting figuring out where to live in. Here are 10 of the best options available in the five boroughs.

Healthcare in New York

Healthcare in New York

New York City is widely regarded as one of the best places in the world for specialized health care. Here are some important medical resources for expats living in New York City.

International-Schools-in-NYC

International Schools in NYC

Expats living in NYC have many international and bilingual school choices -- international schools, bilingual schools, language immersion schools, IB World schools, British Schools and more. Here's a list of the most well-known international schools in NYC.

Expats living in NYC have many international and bilingual school choices -- international schools, bilingual schools, language immersion schools, IB World schools, British Schools and more. Here's a ...

French-Schools-in-New-York

French Schools in New York

Are you a Francophone moving to NYC? This article offers an extensive list of French schools in NYC with addresses, maps and accreditation information from the French Consulate General. The list covers all ages ranges from French nursery schools through French high schools in New York City. In addition to private French schools in the NYC area, this article covers all of the NYC public schools with French dual language programs (DLP) and several well-known French schools in suburban New York and New Jersey.

Are you a Francophone moving to NYC? This article offers an extensive list of French schools in NYC with addresses, maps and accreditation information from the French Consulate General. The list cov...

Living in Brooklyn

New York may seem intimidating to a newcomer, but this expat living in Brooklyn has learned the truth.. New Yorkers can be very friendly, they love to give advice and there are so many ways to meet people.

Join our United States Expat Forum

Visit our United States Forum and talk with other expats who can offer you insight and tips about living in New York, United States.

More about United States

Transportation-in-New-York-Tri-State-AreaExpat New York: Public Transportation Options

Expats living in the New York Metropolitan area have a variety of public transportation options. Learn about the rail and bus systems near your home - or where you will live.

Top-10-Things-To-Do-For-Expats-Living-in-New-York-CityExpat New York: Top 10 Things To Do For Expats Living in New York City

Expats in New York City will learn a lot about the culture and people of New York if they get out and do some exploring. Here are 10 things to do that will help get you quickly settled.

Ten-New-York-City-Suburbs-For-ExpatsExpat New York: Top 10 New York Suburbs For Expats

Many expats that live in or around New York City choose not to live in the city, but instead in one of the many suburbs in New Jersey, Connecticut and Westchester County, NY. Here are just a few of the options available to expats.

Which-US-States-Are-Best-For-ExpatsWhich US States Are Best For Expats?

Ella Jameson shares her picks for the best US states for expats. What do you think? Share your favorite US states for expats.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Updated On: Sep 29, 2019

First Published: Sep 29, 2019

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in United States from our partner, Cigna Global Health.
Get a Quote

Guide to Living in New YorkGuide to Living in New York

Expats in New York City will quickly find that New Yorkers defy their stereotypes. New York is a melting pot of people from every corner of the globe and every income level -- all brought together by the city's subway system. Some expats enjoy living right in the hustle and bustle of the city. Others choose to enjoy a bit more greenery and space in a suburb on New York.

Healthcare in New YorkHealthcare in New York

New York City is widely regarded as one of the best places in the world for specialized health care. Here are some important medical resources for expats living in New York City.

Best Places to Live in New YorkBest Places to Live in New York

Expats moving to New York City often find it daunting figuring out where to live in. Here are 10 of the best options available in the five boroughs.

Restaurants in New YorkRestaurants in New York

Support your favorite restaurants in New York as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

International-Schools-in-NYCInternational Schools in NYC

Expats living in NYC have many international and bilingual school choices -- international schools, bilingual schools, language immersion schools, IB World schools, British Schools and more. Here's a list of the most well-known international schools in NYC.

Expats living in NYC have many international and bilingual school choices -- international schools, bilingual schools, language immersion schools, IB World schools, British Schools and more. Here's a ...

French-Schools-in-New-YorkFrench Schools in New York

Are you a Francophone moving to NYC? This article offers an extensive list of French schools in NYC with addresses, maps and accreditation information from the French Consulate General. The list covers all ages ranges from French nursery schools through French high schools in New York City. In addition to private French schools in the NYC area, this article covers all of the NYC public schools with French dual language programs (DLP) and several well-known French schools in suburban New York and New Jersey.

Are you a Francophone moving to NYC? This article offers an extensive list of French schools in NYC with addresses, maps and accreditation information from the French Consulate General. The list cov...

Transportation-in-New-York-Tri-State-AreaExpat New York: Public Transportation Options

Expats living in the New York Metropolitan area have a variety of public transportation options. Learn about the rail and bus systems near your home - or where you will live.

Top-10-Things-To-Do-For-Expats-Living-in-New-York-CityExpat New York: Top 10 Things To Do For Expats Living in New York City

Expats in New York City will learn a lot about the culture and people of New York if they get out and do some exploring. Here are 10 things to do that will help get you quickly settled.

United States Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /lib_rd.cfm
Time Stamp 05-Jun-20 12:32 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.75
Host Name 173.245.54.75


Execution Time

Total Time Avg Time Count Template
143 ms 143 ms 1 top level /home/www/html/lib_rd.cfm
61 ms 61 ms 1 /home/www/html/navcontentboxcitymobile.cfm
37 ms 37 ms 1 /home/www/html/commentsnew_rdesign4.cfm
20 ms 20 ms 1 /home/www/html/navmpu_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navbottomad_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/lib_rd_ctygd_readnext.cfm
12 ms 12 ms 1 /home/www/html/Application.cfm
9 ms 9 ms 1 /home/www/html/navtop_ctygd2.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
2 ms 1 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb_ctygd.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/navcontentboxcitypc.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_5441_33712.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 12 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
156 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 00:32:56.056
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=11ms, Records=1) in /home/www/html/Application.cfm @ 00:32:56.056
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 00:32:56.056
	Select *
	From articles
	Where articleID = 5441
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 00:32:56.056
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 00:32:56.056
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5441 
	and articles.articleID = 5441 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 00:32:56.056
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5441
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5441
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 00:32:56.056
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 00:32:56.056
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 129 
getcities (Datasource=expert, Time=2ms, Records=19) in /home/www/html/navmeta_rdesign4.cfm @ 00:32:56.056
	Select *
	From citynetworks
	Where networkID = 129
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 00:32:56.056
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 00:32:56.056
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5441 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 00:32:56.056
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-03-06"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 00:32:56.056
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-06-05 00:00:00.000"
and logtime < "2020-06-05 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 00:32:56.056
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-05-29"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 00:32:56.056
	SELECT *
	From contentcountcountry
	Where networkid = 129 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 00:32:56.056
	SELECT *
	From contentcountcity
	Where citynetworkid = 4258 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 00:32:56.056
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5441 
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 00:32:56.056
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5441 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 00:32:56.056
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 129
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-04"
and headerparagraphstart < "2020-06-05"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 129
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-04"
and natsentencestart < "2020-06-05"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 00:32:56.056
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 1
and natsentencetype = 2 
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4258
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and articles.articleID <> '5441'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-05" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4258
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
getbestsummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4258
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 4
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4258
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 3
 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
         and networkid = 129
          and citynetworkid = 4258
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 68567 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 00:32:56.056
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 5141 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 00:32:56.056
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5441 
gettaxgeneral (Datasource=expert, Time=11ms, Records=4) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 00:32:56.056
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 129 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 5441
    and publishdate < "2020-06-05"
    and publishdate > "2014-01-01"
 
    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 00:32:56.056
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-04"
    and fromDate < "2020-06-05"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 00:32:56.056
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-04"
    and fromDate < "2020-06-05"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=12ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 00:32:56.056
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 00:32:56.056
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-06-04 00:32:56'}
    and fromDate <{ts '2020-06-05 00:32:56'}
    and weight > 7
    and bannerPlacement.networkid = 129
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 00:32:56.056
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-06-04 00:32:56'}
    and fromDate <{ts '2020-06-05 00:32:56'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=18ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 00:32:56.056
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 00:32:56.056
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5441 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 00:32:56.056
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4258
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/lib_rd.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/lib_rd.cfm
QUERY_STRING=articleID=5441&networkid=129
REMOTE_ADDR=173.245.54.75
REMOTE_HOST=173.245.54.75
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=29023643
cftoken=25247223
sessionid=IBEXPATEXCHANGE.COM_29023643_25247223
urltoken=CFID=29023643&CFTOKEN=25247223
URL Parameters:
articleID=5441
networkid=129
Debug Rendering Time: 10 ms