Useful SQL queries for administrators of University of Michigan research cores, centers, institutes and labs, including queries to report on publications and grants.
- These example queries are organized by subject area or general reporting need (e.g. "Publications").
- To use them, copy the query you want to use, paste it into your favorite SQL development tool, and edit any input variables.
- The query documents which data sources are needed. To be granted access, submit a ticket to HITS or ITS depending on the source.
- Each query is self-documented.
- None.
The Mobile Technologies Core provides investigators across the University of Michigan the support and guidance needed to utilize mobile technologies and digital mental health measures in their studies. Experienced faculty and staff offer hands-on consultative services to researchers throughout the University – regardless of specialty or research focus.
To get in touch, contact the individual developers in the check-in history.
If you need assistance identifying a contact person, email the EFDC's Mobile Technologies Core at: [email protected].
- Eisenberg Family Depression Center (@DepressionCenter)
- Gabriel Mongefranco (@gabrielmongefranco)
- None
Copyright © 2023 The Regents of the University of Michigan
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program. If not, see https://www.gnu.org/licenses/gpl-3.0-standalone.html.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. You should have received a copy of the license included in the section entitled "GNU Free Documentation License". If not, see https://www.gnu.org/licenses/fdl-1.3-standalone.html
If you find this repository, code or paper useful for your research, please cite it.
Copyright © 2024 The Regents of the University of Michigan