X-ray surveys are a very efficient mean of detecting young stars and therefore allow us to study the young stellar population in the solar neighborhood and the local star formation history in the last billion of years. We want to study the young stellar population in the solar neighborhood, to constrain its spatial density and scale height as well as the recent local star formation history. We analyze the stellar content of the ROSAT North Ecliptic Pole survey, and compare the observations with the predictions derived from stellar galactic model. Since the ROSAT NEP survey is sensitive at intermediate fluxes is able to sample both the youngest stars and the intermediate age stars (younger than 10^9^years), linking the shallow and deep flux surveys already published in the literature. We confirm the existence of an excess of yellow stars in our neighborhood previously seen in shallow survey, which is likely due to a young star population not accounted for in the model. However the excellent agreement between observations and predictions of dM stars casts some doubt on the real nature of this active population.