JAMA Dermatology trial Doc
Welcome!
This guide provides the information you need to understand and begin querying the JAMA Dermatology Historical Archive sample data.
About This Dataset
This dataset contains a sample of three issues from the complete JAMA Dermatology archive, which spans from 1883 to 1930. It represents the historical foundation of modern dermatology, meticulously cleaned and prepared for AI training.
Source: Journal of the American Medical Association (JAMA) Dermatology & predecessor publications.
Date Range: 1883 – 1930 (Sample: 3 full issues)
Format: JSONL (JSON Lines) loaded into Snowflake tables.
Curated by: Devin Media Corp. Every line has been human-reviewed, bias-audited, and provenance-tracked.
2. Data Dictionary
This table describes the fields available in the dataset’s main table (e.g., JAMA_DERM_SAMPLE).
| Field Name | Data Type | Description | Example Value |
|---|---|---|---|
ISSUE_ID | TEXT | Unique identifier for the issue, derived from the publication date. | "1893-05-01" |
ARTICLE_TITLE | TEXT | The title of the article as it appeared in the original publication. | "A Case of Lupus Vulgaris Treated with X-Rays" |
AUTHOR | TEXT | The author(s) of the article. | "W.A. Hardaway, M.D." |
ILLUSTRATIONS | NUMBER | The number of illustrations accompanying the article. | 3 |
ARTICLE_TEXT | TEXT | The full, cleaned text of the article. [Bias Audit] statements are included at the top of relevant articles to provide historical context. | See “Quick Start Example” below. |
CONTENT_TYPE | TEXT | The type of content (e.g., ‘article’, ‘case report’, ‘society proceedings’). | "article" |
3. Quick Start Guide
Once you have access to the sample data in your Snowflake account, you can immediately start exploring it with SQL. The data will appear as a database you can query.
Example Query 1: Explore the table structure:
— View the first 10 rows to understand the data
SELECT *
FROM JAMA_DERM_SAMPLE
LIMIT 10;
Example Query 2: Search for articles on a specific topic
— Find all articles in the sample discussing ‘melanoma’
SELECT ISSUE_ID, ARTICLE_TITLE, AUTHOR
FROM JAMA_DERM_SAMPLE
WHERE ARTICLE_TEXT ILIKE ‘%melanoma%’;
Example Query 3: See the [Bias Audit] in action
— View the beginning of an article to see the embedded bias audit
SELECT SUBSTRING(ARTICLE_TEXT, 1, 500) AS text_preview
FROM JAMA_DERM_SAMPLE
WHERE ARTICLE_TEXT LIKE ‘%[Bias Audit%’;
4. Additional Information
Full Dataset: This trial represents 3 issues from a complete archive of ~60 issues. For information on subscribing to the full dataset, please contact Devin Media Corp.
Provenance: All source material is pre-1930, verified public domain, and ethically sourced. For detailed provenance statements, please see our main website.
Support: For questions about this dataset, please email support@devinmediacorp.com.