I have access to mimic database now, and for my research I need every patient's symptoms like fever, bleeding , .... I would like to know if this information is provided in the database and which table has this information?

In addition, I want to get query from the database to find all the disease that every patient has, So can you please help me if there is any code that I can use?

Also, in "PATIENTS.csv" file, I can see a column with DOB name and I supposed that it has the date of birth of every patient, but my problem is that those are like for future for example one of them is 3/13/2075 ! so could you please also help me to find patient's date of birth?