How to query this table
All list views have search fields which can be used to search data.
You can search for a complete word or you can search for a part of a search term.
If you enclose two or more words in double quotes, LOVD will search for the combination of those words only exactly in the order you specify.
Note that search terms are case-insensitive and that wildcards such as * are treated as normal text!
For all options, like "and", "or", and "not" searches, or searching for prefixes or suffixes, see the table below.
Operator |
Column type |
Example |
Matches |
|
Text |
Arg |
all entries containing 'Arg' |
space |
Text |
Arg Ser |
all entries containing 'Arg' and 'Ser' |
| |
Text |
Arg|Ser |
all entries containing 'Arg' or 'Ser' |
! |
Text |
!fs |
all entries not containing 'fs' |
^ |
Text |
^p.(Arg |
all entries beginning with 'p.(Arg' |
$ |
Text |
Ser)$ |
all entries ending with 'Ser)' |
="" |
Text |
="" |
all entries with this field empty |
="" |
Text |
="p.0" |
all entries exactly matching 'p.0' |
!="" |
Text |
!="" |
all entries with this field not empty |
!="" |
Text |
!="p.0" |
all entries not exactly matching 'p.0?' |
combination |
Text |
*|Ter !fs |
all entries containing '*' or 'Ter' but not containing 'fs' |
|
Date |
2020 |
all entries matching the year 2020 |
| |
Date |
2020-03|2020-04 |
all entries matching March or April, 2020 |
! |
Date |
!2020-03 |
all entries not matching March, 2020 |
< |
Date |
<2020 |
all entries before the year 2020 |
<= |
Date |
<=2020-06 |
all entries in or before June, 2020 |
> |
Date |
>2020-06 |
all entries after June, 2020 |
>= |
Date |
>=2020-06-15 |
all entries on or after June 15th, 2020 |
combination |
Date |
2019|2020 <2020-03 |
all entries in 2019 or 2020, and before March, 2020 |
|
Numeric |
23 |
all entries exactly matching 23 |
| |
Numeric |
23|24 |
all entries exactly matching 23 or 24 |
! |
Numeric |
!23 |
all entries not exactly matching 23 |
< |
Numeric |
<23 |
all entries lower than 23 |
<= |
Numeric |
<=23 |
all entries lower than, or equal to, 23 |
> |
Numeric |
>23 |
all entries higher than 23 |
>= |
Numeric |
>=23 |
all entries higher than, or equal to, 23 |
combination |
Numeric |
>=20 <30 !23 |
all entries with values from 20 to 29, but not equal to 23 |
Some more advanced examples:
Example |
Matches |
Asian |
all entries containing 'Asian', 'asian', including 'Caucasian', 'caucasian', etc. |
Asian !Caucasian |
all entries containing 'Asian' but not containing 'Caucasian' |
Asian|African !Caucasian |
all entries containing 'Asian' or 'African', but not containing 'Caucasian' |
"South Asian" |
all entries containing 'South Asian', but not containing 'South East Asian' |
To sort on a certain column, click on the column header or on the arrows.
If that column is already selected to sort on, the sort order will be swapped.
The column currently sorted on has a darker blue background color than the other columns.
The up and down arrows next to the column name indicate the current sorting direction.
When sorting on any field other than the default, LOVD will sort secondarily on the default sort column.
|
Legend |
How to query |
Individual ID
|
Ethnic origin
|
Reference
|
Remarks
|
Cuadro familiar
|
Disease
|
Phenotype details
|
Variants
|
Panel size
|
Owner
|
00000100 |
Syrian-Sephardic-Polish-Ashkenazi |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Lina Nuñez-Private Practice |
00000260 |
Unknown |
- |
- |
- |
-- |
- |
3 |
1 |
Florencia Petracchi-CEMIC |
00000299 |
Italian-Argentinian |
- |
- |
- |
- |
- |
1 |
1 |
Vanesa Lotersztein-Genesia/Progenitest |
00000345 |
Spanish-Italian-Argentinian |
- |
- |
Medulloblastoma |
Medulloblastoma |
- |
1 |
1 |
Claudia Martin-Hospital de Córdoba |
00000379 |
Not available |
- |
- |
- |
- |
- |
1 |
1 |
Gonzalo Tabares-CEMA |
00000419 |
Spanish-Italian |
- |
- |
- |
-- |
- |
1 |
1 |
Gonzalo Tabares-CEMA |
00000430 |
Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Norma Rossi-Hospital de Córdoba |
00000446 |
Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Laura Vargas Roig-IMBECU |
00000459 |
Unknown |
- |
- |
- |
- |
- |
4 |
1 |
Pablo Kalfayan-CEMIC |
00000497 |
Italian-Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Pablo Kalfayan-Hospital Italiano |
00000786 |
French-Basque-German-Turkish |
- |
- |
Breast cancer, Gliosarcoma |
Breast cancer, Gliosarcoma |
- |
1 |
1 |
Lina Nuñez-Private Practice |
00000838 |
Spanish-Italian-German |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Lina Nuñez-Private Practice |
00000893 |
Bolivian |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Jesica Ramirez-Hospital Central de Mendoza |
00000939 |
Italian-Spanish |
- |
(antec ambos/explica cuadro clínico) |
Breast cancer |
Breast cancer, Osteosarcoma |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00000941 |
Lithuanian |
- |
- |
- |
- |
- |
1 |
1 |
Dolores Mansilla-Instituto Roffo |
00001024 |
Italian |
- |
(antec ambos/explica cuadro) |
Breast cancer, Ovarian cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001048 |
Spanish-Italian |
- |
- |
Breast cancer, Prostate cancer |
Breast cancer |
- |
1 |
1 |
Claudia Martin-Hospital de Córdoba |
00001072 |
Spanish-Italian-Argentinian |
- |
(antec personales/explica cuadro) |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001073 |
Italian |
- |
(antec ambos/explica cuadro) |
Breast cancer, Melanoma |
Breast cancer, Schwanoma |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001089 |
Syrian-Basque-Italian |
- |
- |
- |
- |
- |
1 |
1 |
Pablo Kalfayan-Hospital Italiano |
00001172 |
Italian |
- |
- |
- |
- |
- |
1 |
1 |
Pablo Kalfayan-Hospital Italiano |
00001252 |
Italian |
- |
- |
Breast cancer, Colon cancer, Ovarian cancer, Pancreatic cancer |
Pancreatic cancer |
- |
1 |
1 |
Lina Nuñez-Private Practice |
00001258 |
Italian-Spanish |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001275 |
Spanish-Italian-French |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001276 |
Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001277 |
Argentinian |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001278 |
Spanish-Argentinian |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001280 |
Argentinian |
- |
- |
Breast cancer, Colon cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001281 |
Spanish-Italian |
- |
- |
Pancreatic cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001282 |
Spanish-Lebanese |
- |
- |
Breast cancer, Pancreatic cancer |
N/A |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001283 |
Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001284 |
Spanish-Italian |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001285 |
Italian-French-Basque |
- |
- |
Melanoma |
Breast cancer |
- |
2 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001291 |
Italian-Argentinian |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001294 |
Russian-Italian |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001295 |
Italian-Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001296 |
Spanish-Italian |
- |
- |
Breast cancer, Kidney cancer |
Breast cancer, Kidney cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001299 |
Spanish-Italian |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001303 |
Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001304 |
Spanish-Italian |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001351 |
Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Dolores Mansilla-Instituto Roffo |
00001407 |
Spanish-Italian-Argentinian |
- |
(antec ambos/explica cuadro) |
Breast cancer, Melanoma |
Melanoma |
- |
1 |
1 |
Lina Nuñez-Private Practice |
00001420 |
Italian |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001436 |
Austrian |
- |
(antec ambos/explica cuadro) |
- |
- |
- |
1 |
1 |
Laura Vargas Roig-IMBECU |
00001439 |
Argentinian |
- |
- |
- |
- |
- |
1 |
1 |
Laura Vargas Roig-IMBECU |
00001452 |
Italian-Spanish |
- |
- |
Breast cancer, Colon cancer, Endometrial cancer, Ovarian cancer, Prostate cancer |
Endometrial cancer, Ovarian cancer |
- |
1 |
1 |
Lina Nuñez-Hospital Alemán |
00001475 |
Italian |
- |
- |
Breast cancer, Thyroid cancer |
Breast cancer, Thyroid cancer |
- |
1 |
1 |
Lina Nuñez-Hospital Alemán |
00001490 |
Argentinian |
- |
- |
- |
- |
- |
1 |
1 |
Erika Stegmayer-Inst. Nuestra Señora de las Mercedes |
00001491 |
Caucasian |
- |
- |
- |
- |
- |
1 |
1 |
Erika Stegmayer-CIOC |
00001495 |
Italian-Basque-French |
- |
- |
- |
- |
- |
3 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001496 |
Italian-Basque-French |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001497 |
Italian-Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001499 |
Italian |
- |
- |
- |
- |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001500 |
Spanish-Italian |
- |
- |
- |
- |
- |
2 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001505 |
Brazilian-Italian-German |
- |
(antec. ambos/explica cuadro) |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001508 |
Polish-Italian-German-Russian |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001533 |
Italian |
- |
- |
- |
- |
- |
1 |
1 |
Dolores Mansilla-Instituto Roffo |
00001536 |
Spanish-Italian |
- |
- |
Colon cancer |
Colon cancer |
- |
2 |
1 |
Lina Nuñez-Private Practice |
00001638 |
Italian |
- |
- |
Colon cancer |
Colon cancer |
- |
1 |
1 |
Jesica Ramirez-Hospital Central de Mendoza |
00001661 |
Italian |
- |
- |
Colon cancer, Prostate cancer |
Colon cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001664 |
Italian |
- |
- |
Breast cancer, Esophagus cancer |
Breast cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
00001679 |
Spanish; Spanish |
- |
- |
- |
- |
- |
1 |
1 |
Alejandra Mampel-COIR |
00001774 |
Italian/Italian:Italian/French |
- |
- |
- |
-- |
- |
1 |
1 |
Cecilia Montes-IMGO |
00001861 |
Argentinian |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Claudia Martin-Hospital de Córdoba |
00001983 |
Italian/Italian |
- |
- |
- |
-- |
- |
1 |
1 |
Cecilia Montes-IMGO |
00001984 |
Italian/Italian |
- |
- |
- |
-- |
- |
1 |
1 |
Cecilia Montes-IMGO |
00002008 |
Italian/Spanish |
- |
- |
- |
-- |
- |
1 |
1 |
Norma Rossi - Fundacion Para el Progreso de la Medicina |
00002064 |
Spanish/Spanish |
- |
- |
Colon cancer |
Colon cancer, Duodenal cancer, Gastric cancer, Melanoma |
- |
1 |
1 |
Maria Laura Gonzalez-Hospital Italiano |
00002128 |
Armenian/Armenian |
- |
- |
Ovarian cancer |
Peritoneal cancer |
- |
2 |
1 |
Pablo Kalfayan-Hospital Italiano |
00002241 |
Chilean/Jewish-Ukranian/Ashkenazi |
- |
- |
Breast cancer, Colon cancer, Melanoma |
Breast cancer |
- |
1 |
1 |
Lina Nuñez-Hospital Alemán |
00002242 |
Argentinean-Argentinean |
- |
- |
Breast cancer, Ovarian cancer |
Breast cancer |
- |
1 |
1 |
Laura Vargas Roig-IMBECU |
00002411 |
European |
- |
- |
Breast cancer |
Breast cancer |
- |
1 |
1 |
Erika Stegmayer-CIOC |
00002611 |
Spanish |
- |
- |
Gastric cancer |
Lung cancer |
- |
1 |
1 |
Silvina Sisterna-Hospital de Comunidad |
|
Legend |
How to query |