Description of database fields
Order columns by clicking their headings. Reset default order.
| field name | comments | data type | allowed values | required |
|---|---|---|---|---|
| id | primary key | int | - | yes |
| isolate | isolate name | text | - | yes |
| country | country where strain was isolated | text |
Afghanistan Åland Islands Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire, Sint Eustatius and Saba Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory British Virgin Islands Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China China [Hong Kong] China [Macao] Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo [DRC] Congo [Republic] Cook Islands Costa Rica Croatia Cuba Curaçao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands (Malvinas) Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern Territories Gabon Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard Island and McDonald Islands Holy See Honduras Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Ivory Coast Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands North Korea North Macedonia Norway Oman Pakistan Palau Palestinian territories Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Poland Portugal Puerto Rico Qatar Réunion Romania Russia Rwanda Saint Barthélemy Saint Helena Saint Kitts and Nevis Saint Lucia Saint Martin (French Part) Saint Pierre and Miquelon Saint Vincent and the Grenadines Samoa San Marino São Tomé and Príncipe Sark Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Sint Maarten (Dutch part) Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the South Sandwich Islands South Korea South Sudan Spain Sri Lanka Sudan Suriname Svalbard and Jan Mayen Islands Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand The Gambia The Netherlands Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda UK Ukraine United Arab Emirates Uruguay USA US Minor Outlying Islands US Virgin Islands Uzbekistan Vanuatu Venezuela Vietnam Wallis and Futuna Islands Western Sahara Yemen Zambia Zimbabwe Unknown |
yes |
| region | Region/city etc inside country | text | - | no |
| year | year of isolation | int | min: 1900; max: 2019 | no |
| month | month of isolation | int | min: 1; max: 12 | no |
| isolation_date | date | - | no | |
| received_date | date | - | no | |
| age_yr | age in years | int | max: 120 | no |
| age_mth | month part of age 0-11 when patient is less than 1 year old | int | min: 0; max: 11 | no |
| sex | text |
male female |
no | |
| disease | please put other diseases in comments field | text |
carrier gastroenteritis systemic disease Guillain Barre Syndrome Miller Fisher Syndrome other neurological sequelae reactive arthritis other rheumatological sequelae |
no |
| source | please put detail in comments field | text |
beef offal or meat broiler environment calf calf faeces carcass swab cat cattle cattle faeces CSF chick chicken chicken offal or meat cows milk dairy products dog duck environmental waters farm environment farm slurry gazelle giraffe goat goats milk goose goose faeces guinea pig horse human blood culture human stool human unspecified lamb lamb offal or meat manure marmoset ostrich other animal other food pig piglet pork offal or meat potable/drinking water rabbit sand (bathing beach) sediments sheep sheep faeces soil sparrow starling turkey turkey offal or meat vegetables wild bird |
no |
| epidemiology | human epidemiology | text |
carrier sporadic case general outbreak family outbreak environmental isolate hospital inpatient |
no |
| species | species name | text |
Campylobacter jejuni Campylobacter coli Campylobacter concisus Campylobacter corcagiensis Campylobacter cuniculorum Campylobacter curvus Campylobacter fetus Campylobacter fetus subsp. fetus Campylobacter fetus subsp. testudinum Campylobacter fetus subsp. venerealis Campylobacter gracilis Campylobacter hepaticus Campylobacter hominis Campylobacter hyointestinalis Campylobacter hyointestinalis subsp. hyointestinalis Campylobacter iguaniorum Campylobacter insulaenigrae Campylobacter lari Campylobacter lari subsp. concheus Campylobacter jejuni subsp. doylei Campylobacter mucosalis Campylobacter ornithocola Campylobacter peloridis Campylobacter pinnipediorum Campylobacter rectus Campylobacter showae Campylobacter sputorum subsp. sputorum Campylobacter subantarcticus Campylobacter upsaliensis Campylobacter ureolyticus Campylobacter volucris Campylobacter sp. |
yes |
| penner | Penner serotype | text | - | no |
| ENA_accession | ENA accession number to access short read data | text | - | no |
| private_project | Leave this blank unless you know what you are doing - entering anything here will hide your data in the public interface | text | - | no |
| comments | any other comments | text | - | no |
| sender | sender unique name, link to users | int | Click for list of sender ids | yes |
| curator | curator who entered data,link to users | int | Click for list of curator ids | yes |
| date_entered | date first entered | date | - | yes |
| datestamp | date last modified | date | - | yes |