scottbw/gist:55afc3927a12f1eb5fb919ef1a07b438

## gistfile1.txt
{"tableName":"jacs3_20120529","primaryKeys":["jacs3_20120529_index"],"columns":[{"columnName":"code","columnType":"VARCHAR","referencedColumnIndex":null,"referencedTable":null,"referencedColumn":null,"alternateColumns":null,"alternativeOptions":null,"orderIndex":1,"comment":""},{"columnName":"value","columnType":"VARCHAR","referencedColumnIndex":null,"referencedTable":null,"referencedColumn":null,"alternateColumns":null,"alternativeOptions":null,"orderIndex":2,"comment":""},{"columnName":"jacs3_20120529_index","columnType":"INTEGER","referencedColumnIndex":null,"referencedTable":null,"referencedColumn":null,"alternateColumns":null,"alternativeOptions":null,"orderIndex":3,"comment":""}],"rows":[{"cell":{"code":{"value":"A100","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"1","type":"INTEGER","defaultValue":null},"value":{"value":"Pre-clinical medicine","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"A200","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"2","type":"INTEGER","defaultValue":null},"value":{"value":"Pre-clinical dentistry","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"A300","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"3","type":"INTEGER","defaultValue":null},"value":{"value":"Clinical medicine","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"A400","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"4","type":"INTEGER","defaultValue":null},"value":{"value":"Clinical dentistry","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"A900","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"5","type":"INTEGER","defaultValue":null},"value":{"value":"Others in medicine & dentistry","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"A990","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"6","type":"INTEGER","defaultValue":null},"value":{"value":"Medicine & dentistry not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"A000","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"7","type":"INTEGER","defaultValue":null},"value":{"value":"Medicine & dentistry","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B100","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"8","type":"INTEGER","defaultValue":null},"value":{"value":"Anatomy, physiology & pathology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B110","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"9","type":"INTEGER","defaultValue":null},"value":{"value":"Anatomy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B120","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"10","type":"INTEGER","defaultValue":null},"value":{"value":"Physiology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B121","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"11","type":"INTEGER","defaultValue":null},"value":{"value":"Clinical physiology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B130","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"12","type":"INTEGER","defaultValue":null},"value":{"value":"Pathology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B131","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"13","type":"INTEGER","defaultValue":null},"value":{"value":"Cellular pathology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B132","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"14","type":"INTEGER","defaultValue":null},"value":{"value":"Pathobiology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B140","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"15","type":"INTEGER","defaultValue":null},"value":{"value":"Neuroscience","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B160","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"16","type":"INTEGER","defaultValue":null},"value":{"value":"Physiotherapy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B170","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"17","type":"INTEGER","defaultValue":null},"value":{"value":"Podiatry","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B190","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"18","type":"INTEGER","defaultValue":null},"value":{"value":"Anatomy, physiology & pathology not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B200","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"19","type":"INTEGER","defaultValue":null},"value":{"value":"Pharmacology, toxicology & pharmacy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B210","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"20","type":"INTEGER","defaultValue":null},"value":{"value":"Pharmacology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B220","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"21","type":"INTEGER","defaultValue":null},"value":{"value":"Toxicology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B230","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"22","type":"INTEGER","defaultValue":null},"value":{"value":"Pharmacy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B290","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"23","type":"INTEGER","defaultValue":null},"value":{"value":"Pharmacology, toxicology & pharmacy not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B300","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"24","type":"INTEGER","defaultValue":null},"value":{"value":"Complementary medicines, therapies & well-being","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B310","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"25","type":"INTEGER","defaultValue":null},"value":{"value":"Osteopathy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B320","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"26","type":"INTEGER","defaultValue":null},"value":{"value":"Chiropractic","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B340","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"27","type":"INTEGER","defaultValue":null},"value":{"value":"Alternative medicine & therapies","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B341","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"28","type":"INTEGER","defaultValue":null},"value":{"value":"Chinese","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B342","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"29","type":"INTEGER","defaultValue":null},"value":{"value":"Herbalism","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B343","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"30","type":"INTEGER","defaultValue":null},"value":{"value":"Acupuncture","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B344","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"31","type":"INTEGER","defaultValue":null},"value":{"value":"Aromatherapy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B345","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"32","type":"INTEGER","defaultValue":null},"value":{"value":"Hypnotherapy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B346","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"33","type":"INTEGER","defaultValue":null},"value":{"value":"Reflexology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B350","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"34","type":"INTEGER","defaultValue":null},"value":{"value":"Hair & beauty science","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B351","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"35","type":"INTEGER","defaultValue":null},"value":{"value":"Hair services","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B352","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"36","type":"INTEGER","defaultValue":null},"value":{"value":"Beauty therapies","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B353","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"37","type":"INTEGER","defaultValue":null},"value":{"value":"Make-up","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B360","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"38","type":"INTEGER","defaultValue":null},"value":{"value":"Spa & water-based therapies","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B390","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"39","type":"INTEGER","defaultValue":null},"value":{"value":"Complementary medicines, therapies & well-being not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B400","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"40","type":"INTEGER","defaultValue":null},"value":{"value":"Nutrition","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B410","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"41","type":"INTEGER","defaultValue":null},"value":{"value":"Dietetics","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B490","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"42","type":"INTEGER","defaultValue":null},"value":{"value":"Nutrition not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B500","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"43","type":"INTEGER","defaultValue":null},"value":{"value":"Ophthalmics","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B510","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"44","type":"INTEGER","defaultValue":null},"value":{"value":"Optometry","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B520","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"45","type":"INTEGER","defaultValue":null},"value":{"value":"Orthoptics","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B590","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"46","type":"INTEGER","defaultValue":null},"value":{"value":"Ophthalmics not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B600","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"47","type":"INTEGER","defaultValue":null},"value":{"value":"Aural & oral sciences","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B610","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"48","type":"INTEGER","defaultValue":null},"value":{"value":"Audiology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B620","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"49","type":"INTEGER","defaultValue":null},"value":{"value":"Speech science","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B630","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"50","type":"INTEGER","defaultValue":null},"value":{"value":"Language pathology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B690","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"51","type":"INTEGER","defaultValue":null},"value":{"value":"Aural & oral sciences not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B700","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"52","type":"INTEGER","defaultValue":null},"value":{"value":"Nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B701","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"53","type":"INTEGER","defaultValue":null},"value":{"value":"Palliative care nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B702","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"54","type":"INTEGER","defaultValue":null},"value":{"value":"Clinical practice nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B710","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"55","type":"INTEGER","defaultValue":null},"value":{"value":"Community nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B712","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"56","type":"INTEGER","defaultValue":null},"value":{"value":"Health visiting","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B713","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"57","type":"INTEGER","defaultValue":null},"value":{"value":"School nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B714","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"58","type":"INTEGER","defaultValue":null},"value":{"value":"Practice nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B720","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"59","type":"INTEGER","defaultValue":null},"value":{"value":"Midwifery","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B730","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"60","type":"INTEGER","defaultValue":null},"value":{"value":"Children&apos;s nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B731","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"61","type":"INTEGER","defaultValue":null},"value":{"value":"Neonatal care","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B740","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"62","type":"INTEGER","defaultValue":null},"value":{"value":"Adult nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B741","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"63","type":"INTEGER","defaultValue":null},"value":{"value":"Older people nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B750","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"64","type":"INTEGER","defaultValue":null},"value":{"value":"Dental nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B760","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"65","type":"INTEGER","defaultValue":null},"value":{"value":"Mental health nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B761","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"66","type":"INTEGER","defaultValue":null},"value":{"value":"Learning disability nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B770","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"67","type":"INTEGER","defaultValue":null},"value":{"value":"Medical nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B771","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"68","type":"INTEGER","defaultValue":null},"value":{"value":"Critical care nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B772","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"69","type":"INTEGER","defaultValue":null},"value":{"value":"Surgical nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B773","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"70","type":"INTEGER","defaultValue":null},"value":{"value":"Emergency nursing","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B790","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"71","type":"INTEGER","defaultValue":null},"value":{"value":"Nursing not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B800","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"72","type":"INTEGER","defaultValue":null},"value":{"value":"Medical technology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B810","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"73","type":"INTEGER","defaultValue":null},"value":{"value":"Cardiography","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B820","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"74","type":"INTEGER","defaultValue":null},"value":{"value":"Radiology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B821","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"75","type":"INTEGER","defaultValue":null},"value":{"value":"Radiography, diagnostic","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B822","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"76","type":"INTEGER","defaultValue":null},"value":{"value":"Radiography, therapeutic","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B830","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"77","type":"INTEGER","defaultValue":null},"value":{"value":"Biomechanics & prosthetics (non-clinical)","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B840","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"78","type":"INTEGER","defaultValue":null},"value":{"value":"Dental technology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B850","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"79","type":"INTEGER","defaultValue":null},"value":{"value":"Mortuary technology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B890","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"80","type":"INTEGER","defaultValue":null},"value":{"value":"Medical technology not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B900","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"81","type":"INTEGER","defaultValue":null},"value":{"value":"Others in subjects allied to medicine","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B910","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"82","type":"INTEGER","defaultValue":null},"value":{"value":"Environmental health","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B920","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"83","type":"INTEGER","defaultValue":null},"value":{"value":"Occupational health","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B930","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"84","type":"INTEGER","defaultValue":null},"value":{"value":"Occupational therapy","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B940","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"85","type":"INTEGER","defaultValue":null},"value":{"value":"Counselling","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B950","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"86","type":"INTEGER","defaultValue":null},"value":{"value":"Paramedical science","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B960","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"87","type":"INTEGER","defaultValue":null},"value":{"value":"Physician assistant studies","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B990","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"88","type":"INTEGER","defaultValue":null},"value":{"value":"Subjects allied to medicine not elsewhere classified","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"B000","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"89","type":"INTEGER","defaultValue":null},"value":{"value":"Subjects allied to medicine","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C100","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"90","type":"INTEGER","defaultValue":null},"value":{"value":"Biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C110","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"91","type":"INTEGER","defaultValue":null},"value":{"value":"Applied biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C111","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"92","type":"INTEGER","defaultValue":null},"value":{"value":"Parasitology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C120","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"93","type":"INTEGER","defaultValue":null},"value":{"value":"Behavioural biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C130","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"94","type":"INTEGER","defaultValue":null},"value":{"value":"Cell biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C131","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"95","type":"INTEGER","defaultValue":null},"value":{"value":"Applied cell biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C140","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"96","type":"INTEGER","defaultValue":null},"value":{"value":"Developmental/Reproductive biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C141","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"97","type":"INTEGER","defaultValue":null},"value":{"value":"Developmental biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C142","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"98","type":"INTEGER","defaultValue":null},"value":{"value":"Reproductive biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C150","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"99","type":"INTEGER","defaultValue":null},"value":{"value":"Environmental biology","type":"VARCHAR","defaultValue":null}},"indexCell":null},{"cell":{"code":{"value":"C160","type":"VARCHAR","defaultValue":null},"jacs3_20120529_index":{"value":"100","type":"INTEGER","defaultValue":null},"value":{"value":"Marine/Freshwater biology","type":"VARCHAR","defaultValue":null}},"indexCell":null}],"sequences":["jacs3_20120529_index"],"comment":"","numberOfRowsInEntireTable":1570,"currentRow":1,"originalDbType":null,"columnsByIndex":[{"columnName":"code","columnType":"VARCHAR","referencedColumnIndex":null,"referencedTable":null,"referencedColumn":null,"alternateColumns":null,"alternativeOptions":null,"orderIndex":1,"comment":""},{"columnName":"value","columnType":"VARCHAR","referencedColumnIndex":null,"referencedTable":null,"referencedColumn":null,"alternateColumns":null,"alternativeOptions":null,"orderIndex":2,"comment":""},{"columnName":"jacs3_20120529_index","columnType":"INTEGER","referencedColumnIndex":null,"referencedTable":null,"referencedColumn":null,"alternateColumns":null,"alternativeOptions":null,"orderIndex":3,"comment":""}]}