(in reflection) Centralization of datas, and psychiatric databases by country, for multi-factorial statistical analyzes

Hello, i had this idea last year on an alter-psychiatric forum, maybe we can join force here, because i can’t do that alone. And maybe this work could help you to analys your data of survey. For me, spectral analysis may well be “the intuition of the computer”, which could allow us to verify and prove our human intuitions.

the main problem is that to have robust data, it is necessary to be epidemiological (with an end which justifies the means: what one seeks is sponsored by the lab, the means is the money), and it is necessary to justify the why of his research, and without belonging to a research lab, no subsidy, it is very complicated to have access to the database of social security … Otherwise, we do as you will see in 4. a list where it is the bazaar.

here are some links where are available datas, and psychiatric databases around the world, in order to facilitate possible spectral analyzes: Summary: 1. statistical tools of spectral analysis 2. (co) variances to verify 3. data by country 4. data by “diseases”, “medicines”, other variables, metadata ---------------------------------------------------------------------------

1. statistical tools of spectral analysis: https://fr.wikipedia.org/wiki/Analyse_spectrale Powerful statistical tools exist: Principal Component Analysis (PCA) and Correspondence Factor Analysis (CFA). These two links explain it well, it is complex, but I think it would be worth looking at it, I will explain why then, in this kind of project: https://www.math.univ-toulouse.fr/~baccini/zpedago/asdm.pdf excell addon: https://www.xlstat.com/fr/solutions/fonctionnalites/analyse-en-composantes-principales-acp There is software calculating all of a sudden, out of diagrams highlighting, especially very obvious correlations, which is very interesting here! these tools (AFP, ACP) exist on excell. However, free software of data mining exist: https://fr.wikipedia.org/wiki/Logiciels_de_fouille_de_donn%C3%A9es

These statistical tools make it possible to direct calculations and to give tracks thanks to the visual diagrams, which project in an abstract space which makes align the correlated variables, and thus to have ideas of correlations to deepen. To give an example, on an aerial image taken by satellite or plane, of the terrestrial surface, by sorting the distribution, local variations, and proximity / distance, (even very light) in the frequency space of the light spectrum (at each pixel of any photo, is assigned a frequency value of wavelength corresponding to a color) and testing, groping with the computer grinders, it can for example bring out, underground elements (foundations, pipes, etc. ) invisible to the naked eye, yet recorded as a watermark in the image data, a bit like a Fourier transform, http://villemin.gerard.free.fr/Wwwgvmm/Analyse/Fourier.htm but statistical, which decomposes (in several integrals) a single curve, in several sub-periodic and cyclic curves (that we can name harmonic, or polyphony if one wants) which add up to form only one (which apparently has no cycle or logic) in order to see which sub-curves are related.

image

Another example, admitted unanimously by the scientific community, that I know a little bit: it is the idea that Milankovitch had in 1941 (died in 1968, his theory was proven posthumously in 1976, thanks to new experimental technologies, such as the analysis of the isotope δ18O (which allows to deduce the temperature related to dated sediments) that was finally developed in 1967 by his colleagues, https://fr.wikipedia.org/wiki /% CE% 9418O, and used on boreholes in order to have finally the global curve of evolution of the climate !! and subsequently the satellite observation of the distribution of terrestrial insolation confirmed the theory, it seems to me), which found that the curve of temperature fluctuations over the geological ages was largely EXOGENOUS part. “However, the idea that the Earth’s climate itself can be influenced by astronomical parameters, so exogenous, and in addition cyclical, took a long time to impose, because this idea was not self-evident.” (https://fr.wikipedia.org/wiki/Them_astronomy_of_palatoms), the curve of climatic variations is due to variations of the planet Earth itself (these variations being induced by the interactions with the other planets, and the sun), decomposable into several periodic and cyclic sub-curves, each perfectly corresponding [/ i] and exactly to an orbital parameter of the Earth or astronomical cycle (inclination axis of rotation, equinox precession, solar activity, eccentricity, etc …).

http://www.groupes.polymtl.ca/glq1100/milankovich/milankovich.html

https://fr.wikipedia.org/wiki/Param%C3%A8tres_de_Milankovi%C4%87



if we statistically analyzed these curves, they would all be interconnected necessarily because they form by adding, one and the same curve, the temperature variation of the Earth, a curve which at first sight has no link, no cycle ( apart from that of glaciations, unexplainable until then), no possible interpretation. We could see that the precession of the equinoxes (cone forming the terrestrial axis in space) is necessarily very correlated with the inclination of the terrestrial axis …, but less correlated with the eccentricity of the ellipse of revolution. of the Earth around the Sun, and that all variables are highly correlated to Sun’s parameters. And to end this example, that the orbital parameters of the Earth are strongly correlated with the fluctuations of the climate. I hope that I can express myself well and make myself understood. So Milankovitch (not alone, of course, but he died just before his colleagues publish the confirmation …) established a thought experiment, a theory, confirmed later by spectral analysis … Transposable, in theory, on presumptions concerning a certain branch of medicine. So, Fourier transform, then AFC, ACP, It’s a bit like “statistical X-rays”. This can apply to things more abstract than a photo, on any data for example. 2. (co) variances to check:

For example, it serves as a basis for epidemiologists to decide on the direction of their study, I think, and if not, well, that’s very disturbing. One could see, in the myriad of factors projected in the statistical matrix, that depression and suicide are correlated, it could be seen that the mood regulator and bipolarity variables are correlated. This is obvious. As diabetes and insulin are correlated, for example. But we get diabetic before taking insulin. If one spontaneously cures a dependent insulin-dependent diabetes, it is impossible to know, because the diag is without appeal, and there is little chance of knowing it, since the treatment is without interruption, and never interrupted. Less obvious, we could see that: . Suicide and AD are correlated (the causal relationship is then to be defined, which of the chicken and the egg? or both, or associated / weighted to other factors, and for what part attributed to each of the factors, and and so on…), . AD and Bipolarity are correlated, causally in a majority sense, then causally circularly … to prove. list of variables to cross: - each “disease” - each “class of” medicine - nocebo effect, placebo effect - in psychiatry or not: . socioprofessional category: (active, unemployed, student, unemployed) . in psychiatry: (disability, ald, esat, hospital, etc …)), duration of “care” in the year (from the first diagnosis), number of different diagnoses posed, number of pharmaceutical classes taken at the same time, alliance therapeutic or not, etc. to be continued…

3. data by country:

- in France -

Synthetic tabs (paid, therefore unavailable):

summary of the psychiatry activity of health institutions on the model of the tables produced on the e-PMSI platform:

reading guide of the paintings: https://www.atih.sante.fr/sites/default/files/public/content/1981/guide_de_lecture_des_tableaux_mapsy_2014_0.pdf

you do not need to be an epidemiologist, in theory, to have access to their data, but it’s a headache, and it pays:
https://epidemiologie-france.aviesan.fr/epidemiologie-france/fiches/medical-information-collection-system-for-psychiatry/fre-fr

“The PMSI databases (national, regional or special extractions) can be obtained by written request.This way requires the prior obtaining of a CNIL agreement.” https://www.atih.sante.fr/bases-de-donnees/commande-de-bases

“The raw data from the PMSI are exclusively accessible to structures (health establishments, companies, associations …) with a Siret number.” But it pays, alas … 500 euros minimum but this is enough and free:
https://www.scansante.fr/applications/statistiques-activite-PSY Link to French statistical studies on “mental illness”:
http://drees.solidarites-sante.gouv.fr/spip.php?page=recherche&recherche=maladie+mentale http://solidarites-sante.gouv.fr/IMG/pdf/Annexe_3_DREES_-_Representations_de_la_sante_mentale.pdf

http://www.irdes.fr/recherche/questions-d-economie-de-la-sante/202-l-hospitalisation-au-long-cours-en-psychiatrie-analyse-et-determinants-de-la-variability-territoriale.pdf

This link is interesting, it summarizes the epidemiological data concerning psychiatry in France until 2007:

link to drug consumption from 2001 to 2018:
https://www.ameli.fr/l-assurance-maladie/statistiques-et-publications/donnees-statistiques/medicament/medic-am/medic-am-2001-2002.php

history of drug reimbursement rate http://www.codage.ext.cnamts.fr/codif/bdm_it/index_tele_ucd.php?p_site=AMELI

Medical coding support site combining CCAM data (managed by AMELI Health Insurance) and ICD-10 (managed by WHO)

Medicated interactions (German site) http://bioinformatics.charite.de/transformer/index.php?site=cocktail_search

- in Canada -

an interactive and ergonomic data mining in canada that works:

http://infobase.phac-aspc.gc.ca:9600/PHAC/readPPReports.jsp?l=fr

http://infobase.phac-aspc.gc.ca:9600/PHAC/readPPReports.jsp?l=fr&folder=i80CD57B5207145E9A598DC0263E51719

scattered Canadian statistics: http://www.stat.gouv.qc.ca/statistiques/sante/etat-sante/mentale/sante-mentale-action.pdf

https://www.canada.ca/fr/sante-publique/services/publications/maladies-et-affections/rapport-systeme-canadien-surveillance-maladies-chroniques-maladies-mentales-canada-2015.html

https://www.canada.ca/fr/sante-publique/services/rapports-publications/aspect-humain-sante-mentale-maladie-mentale-canada-2006/suicidaire-2006.html

raw data is here:

Care for Children and Youth with Mental Disorders - Tables 2006-2017 data:
https://www.cihi.ca/sites/default/files/document/cymh-data-table-update-2018-fr-web.xlsx

Hospitalizations and ED visits associated with eating disorders, with age and sex comparisons, 2014: https://www.cihi.ca/sites/default/files/eatingdisord_2014_data_fr_0.xlsx

data hospitalization, year 2015/2016: https://www.cihi.ca/sites/default/files/document/hmhdb-quick-stats-2015-2016-suppl-tables-fr-web.xlsx

data hospitalization, year 2016/2017: https://www.cihi.ca/sites/default/files/document/hmhdb-qs-preformatted-201617-fr.xlsx

Pan-Canadian Trends in Prescribing Opioids and Benzodiazepines, 2012 to 2017:
https://www.cihi.ca/sites/default/files/document/opioid-prescribing-june2018-fr-web.pdf https://www.cihi.ca/sites/default/files/document/pan-canadian-prescribed-opioid-benzo-data-tables-june18-fr-web.xlsx

Children and young people with mental disorders: data tables
to complete

- in Germany -
to complete…

- to USA -
to complete…

- in Norway -
to complete…

- in Swiss -
to complete…

- other countries -
to complete…

_____________________________________________________________________ 4. data by “diseases”, “medicines”, other variables, metadata:

- data by “diseases” -

- data suicide -
https://www.oecd-ilibrary.org/sites/health_glance-2017-12-fr/index.html?itemId=/content/component/health_glance-2017-12-fr

Suicide Mortality by Country, 2015 (or nearest year):
http://dx.doi.org/10.1787/888933606965

Evolution of suicide mortality in selected OECD countries, 1990-2015:
http://dx.doi.org/10.1787/888933606984

Prevalence of chronic depression by country, 2014:
http://dx.doi.org/10.1787/888933607003

Antidepressant consumption by country, 2000 and 2011 (or nearest year): http://dx.doi.org/10.1787/888932921417

OECD, Suicide Rate of Member Countries, 2016:

Metadatas by country:
https://stats.oecd.org/

Eurostat: databases of the European Union - statistics on suicides:

CépiDc, INSERM, querying data on causes of death from 1979 to 2015: http://www.cepidc.inserm.fr/inserm/html/index2.htm

National Obsevatory of Suicide (ONS):

Suicide: 3rd Report, Department of Health, February 2018:

- data F0 “Organic mental disorders, including symptomatic disorders” -
To complete

- data F1 “Mental and behavioral disorders related to the use of psychoactive substances” -

- data F2 “Schizophrenia, schizotypal disorders and delusional disorders” -
To complete

- data F3 “Mood disorders (affective)” -
To complete

- data F4 “Neurotic disorders, disorders related to stressors and somatoform disorders” -
To complete

- data F5 “Behavioral syndromes associated with physiological disturbances and physical factors” -
To complete

- data F6 “Personality and behavioral disorders in adults” -
To complete

- data F7 “mental retardation” -
To complete

- data F8 “Psychological Development Disorders (PDD)” -
To complete

- data F9 “Behavioral and emotional disorders that usually appear during childhood and adolescence” -
To complete

- data F99 “Mental disorder, without further indication” -
To complete

- data by “drugs” -
To complete

- Metadata, databases -

. professional (paying): CNHIM National Hospital Center for Drug Information: http://www.theriaque.org/index.php?page=signup .

public:
http://base-donnees-publique.medicaments.gouv.fr/ https://www.vidal.fr/ .

International Classification of Diseases, ICD-10: Medical coding support site combining CCAM data (managed by AMELI Health Insurance) and ICD-10 (managed by WHO) Here we have a non-raw database, in the form of links and graphics that is very interesting! This site can be very useful, it can make it possible to make statistical links between iatrogenése and pathology, and especially to visualize visual diagrams generated from the statistics of the PMSI (program of medicalization of information systems) French, pertaining to each diagnosis of ICD-10 [pathology diagnosis]: - the statistical proportion of each symptoms encountered associated with [pathology diagnosis] - the statistical proportion of each CCAM Acts (CCAM code) associated with [pathology diagnosis] - the statistical proportion of each homogeneous group of patients (GHM) associated with [pathology diagnosis] (see future post on ):

https://www.aideaucodage.fr/ccam
http://taurus.unine.ch/icd10?term=&select=2369#select

- other variables-

- Data in bulk, to classify, to “peel” -

Eurostat: databases of the European Union - statistics on suicides:
http://ec.europa.eu/eurostat/data/database http://ec.europa.eu/eurostat/web/health/overview

Open Damir: complete basis for interregime health insurance expenses:

Medic’AM data provide detailed monthly and annual data on drugs reimbursed by Health Insurance:

Open MEDIC: complete base on interregime drug expenditure:
http://open-data-assurance-maladie.ameli.fr/medicaments/index.php#Open_Medic

Open PHMEV: bases on the hospital prescriptions of drugs delivered in town: http://open-data-assurance-maladie.ameli.fr/medicaments/index.php#Open_PHMEV

Open Bio: Complete Basis for Inter-Plan Medical Biology Expenses:
http://open-data-assurance-maladie.ameli.fr/biologie/index.php

The Hospital Information Technology Agency (ATIH) provides free access summary data via the Scan Health health facility data retrieval platform: https://www.scansante.fr/

The Center for Epidemiology of Medical Causes of Death (CépiDC), is a laboratory of INSERM:
http://www.cepidc.inserm.fr/inserm/html/index2.htm

Public Directory of studies recorded under reference methodologies: https://www.indsante.fr/fr/repertoire-public/etudes-sous-mr

SNIIRAM, national interregime information system for health insurance:
http://open-data-assurance-maladie.ameli.fr/wiki-sniiram/index.php

Drug Basis and Tariff Information:
http://www.codage.ext.cnamts.fr/codif/bdm_it/index_presentation.php?p_site=AMELI

Hospital summary data sheets:
www.institut-des-donnees-de-sante.fr/site-download-process/746-3yacrj.html

Psychiatric beds by country, 2005 to 2017 https://stats.oecd.org/viewhtml.aspx?datasetcode=HEALTH_REAC&lang=fr#

sorry I can not reissue before 7h to get in shape … because I exceeded my quota of post