Skip to main content
. 2020 Nov 12;9:1320. [Version 1] doi: 10.12688/f1000research.26870.1

Table 1. Database fields and descriptions.

Field Description
`study_id` Unique study identification number that can be joined with `articles_db` for study metadata
`study_country` Name of country where event occurred. Note that there are some studies that report on events
in multiple countries.
`study_iso3c` Three letter International Organization for Standardization (ISO) code
`study_location` Full study location (including hospital, city, and state if available)
`study_location_basis` Spatial basis of study location (e.g., "hospital, city, state_province_district, country")
`residence_location` Location of patient residence
`travel_location` Patient travel locations, if any reported. Multiple locations are separated by `;`.
`drug` Antimicrobial drug, standardized to the Medical Subject Headings (MeSH) ontology 13 . Drug
combinations are concatenated by `+`.
`drug_rank` Taxonomic classification of drug (i.e., drug name or group)
`segment_drug_combo` TRUE/FALSE resistance is to a combination of drugs
`drug_parent_name` Name of the taxonomic parent of antimicrobial drug, standardized to the Medical Subject
Headings (MeSH) ontology 13 .
`bacteria` Name of resistant bacteria, standardized to NCBI Organismal Classification ontology 14 .
`bacteria_rank` Taxonomic classification of bacteria name (e.g., “species”, “genus”)
`bacteria_parent_name` Name of the taxonomic parent of bacteria, standardized to NCBI Organismal Classification
ontology 14 .
`bacteria_parent_rank` Taxonomic classification of bacteria parent name (e.g., “species”, “genus”)
`start_date` Date that emergence was reported in format of yyyy-mm-dd
`end_date` Date that emergence was resolved, if reported, in format of yyyy-mm-dd
`start_date_rank` Specificity of the start date (i.e., year, month, day)