{
  "fields": [{"id":"_id","type":"int"},{"id":"id","type":"numeric","info":{"label":"id"}},{"id":"full_text","type":"text","info":{"label":"full_text"}},{"id":"customernumber","type":"numeric","info":{"label":"customernumber"}},{"id":"customername","type":"text","info":{"label":"customername"}},{"id":"contactlastname","type":"text","info":{"label":"contactlastname"}},{"id":"contactfirstname","type":"text","info":{"label":"contactfirstname"}},{"id":"phone","type":"text","info":{"label":"phone"}},{"id":"addressline","type":"text","info":{"label":"addressline"}},{"id":"city","type":"text","info":{"label":"city"}},{"id":"state","type":"text","info":{"label":"state"}},{"id":"postalcode","type":"text","info":{"label":"postalcode"}},{"id":"country","type":"text","info":{"label":"country"}},{"id":"salesrepemployeenumber","type":"numeric","info":{"label":"salesrepemployeenumber"}},{"id":"creditlimit","type":"numeric","info":{"label":"creditlimit"}},{"id":"map_reference","type":"text","info":{"label":"map_reference"}}],
  "records": [
    [2,2,"'112':1 '1166':16 '23':18 '7025551838':7 '71800.0':17 '83030':14 '8489':8 'gift':3 'king':5 'las':11 'nv':13 'signal':2 'st':10 'store':4 'strong':9 'sue':6 'usa':15 'vega':12",112,"Signal Gift Stores","King","Sue","7025551838","8489 Strong St.","Las Vegas","NV","83030","USA",1166,71800.0,"23"],
    [3,3,"'03':7 '114':1 '117300.0':19 '1611':18 '175':20 '3004':16 '4555':9 '636':10 '9520':8 'australia':17 'australian':2 'co':4 'collector':3 'ferguson':5 'kilda':12 'melbourn':14 'peter':6 'road':13 'st':11 'victoria':15",114,"Australian Collectors, Co.","Ferguson","Peter","03 9520 4555","636 St Kilda Road","Melbourne","Victoria","3004","Australia",1611,117300.0,"175"],
    [6,6,"'1165':17 '124':1 '210500.0':18 '23':19 '4155551450':8 '5677':9 '97562':15 'ca':14 'distributor':4 'gift':3 'ltd':5 'mini':2 'nelson':6 'rafael':13 'san':12 'st':11 'strong':10 'usa':16 'valari':7",124,"Mini Gifts Distributors Ltd.","Nelson","Valarie","4155551450","5677 Strong St.","San Rafael","CA","97562","USA",1165,210500.0,"23"],
    [9,9,"'1165':17 '129':1 '23':19 '5557':8 '64600.0':18 '6505555787':7 '94217':15 'ca':14 'co':4 'francisco':13 'juli':6 'mini':2 'murphi':5 'north':9 'pendal':10 'san':12 'street':11 'usa':16 'wheel':3",129,"Mini Wheels Co.","Murphy","Julie","6505555787","5557 North Pendale Street","San Francisco","CA","94217","USA",1165,64600.0,"23"],
    [10,10,"'10022':15 '114900.0':18 '131':1 '1323':17 '2125557818':8 '23':19 '897':9 'airport':11 'avenu':12 'inc':5 'kwai':7 'land':2 'long':10 'ny':14 'nyc':13 'toy':4 'usa':16 'yu':6",131,"Land of Toys Inc.","Yu","Kwai","2125557818","897 Long Airport Avenue","NYC","NY","10022","USA",1323,114900.0,"23"],
    [16,16,"'10022':13 '1286':15 '138500.0':16 '151':1 '2125557413':7 '23':17 '4092':8 'circl':10 'furth':9 'inc':4 'jeff':6 'machin':3 'muscl':2 'ny':12 'nyc':11 'usa':14 'young':5",151,"Muscle Machine Inc","Young","Jeff","2125557413","4092 Furth Circle","NYC","NY","10022","USA",1286,138500.0,"23"],
    [17,17,"'100600.0':16 '1216':15 '157':1 '2155551555':7 '23':17 '70267':13 '7586':8 'allentown':11 'classic':3 'diecast':2 'inc':4 'kyung':6 'pa':12 'pompton':9 'st':10 'usa':14 'yu':5",157,"Diecast Classics Inc.","Yu","Kyung","2155551555","7586 Pompton St.","Allentown","PA","70267","USA",1216,100600.0,"23"],
    [18,18,"'1165':15 '161':1 '23':17 '6505556809':7 '84600.0':16 '9408':8 '94217':13 'burlingam':11 'ca':12 'circl':10 'furth':9 'hirano':5 'inc':4 'juri':6 'store':3 'technic':2 'usa':14",161,"Technics Stores Inc.","Hirano","Juri","6505556809","9408 Furth Circle","Burlingame","CA","94217","USA",1165,84600.0,"23"],
    [21,21,"'0.0':17 '1286':16 '149':8 '168':1 '2035557845':7 '23':18 '97823':14 'american':2 'ct':13 'dr':10 'franco':5 'haven':12 'inc':4 'new':11 'souvenir':3 'spinnak':9 'sue':6 'usa':15",168,"American Souvenirs Inc","Franco","Sue","2035557845","149 Spinnaker Dr.","New Haven","CT","97823","USA",1286,0.0,"23"],
    [25,25,"'1188':15 '173':1 '23':17 '43400.0':16 '4658':8 '51247':13 '6175555555':7 'av':10 'baden':9 'cambridg':2,11 'co':4 'collect':3 'kyung':6 'ma':12 'tseng':5 'usa':14",173,"Cambridge Collectables Co.","Tseng","Kyung","6175555555","4658 Baden Av.","Cambridge","MA","51247","USA",1188,43400.0,"23"],
    [26,26,"'1323':16 '175':1 '2035552570':7 '23':18 '25593':8 '84300.0':17 '97562':14 'bay':10 'bridgewat':12 'ct':13 'depot':3 'gift':2 'inc':4 'juli':6 'king':5 'ln':11 'south':9 'usa':15",175,"Gift Depot Inc.","King","Julie","2035552570","25593 South Bay Ln.","Bridgewater","CT","97562","USA",1323,84300.0,"23"],
    [27,27,"'+81':7 '-0003':24 '-20':16 '-6':15 '06':8 '1':14 '107':28 '1621':26 '177':1 '4f':13 '530':23 '5555':10 '6342':9 '81200.0':27 'avanza':12 'co':4 'dojima':11,17 'japan':25 'kentari':5 'kita':19 'kita-ku':18 'ku':20 'mori':6 'osaka':2,21,22 'souveni':3",177,"Osaka Souveniers Co.","Kentary","Mory","+81 06 6342 5555","Dojima Avanza 4F, 1-6-20 Dojima, Kita-ku","Osaka","Osaka"," 530-0003","Japan",1621,81200.0,"107"],
    [28,28,"'10022':12 '1286':14 '181':1 '2125551500':6 '23':16 '2678':7 '76400.0':15 'frick':4 'inc':3 'kingston':8 'michael':5 'ny':11 'nyc':10 'rd':9 'usa':13 'vitachrom':2",181,"Vitachrome Inc.","Frick","Michael","2125551500","2678 Kingston Rd.","NYC","NY","10022","USA",1286,76400.0,"23"],
    [32,32,"'1216':17 '16780':10 '198':1 '23':19 '23000.0':18 '58339':15 '6175558428':9 'auto':3 'auto-moto':2 'brickhaven':13 'classic':5 'inc':6 'lesli':8 'ma':14 'moto':4 'pompton':11 'st':12 'taylor':7 'usa':16",198,"Auto-Moto Classics Inc.","Taylor","Leslie","6175558428","16780 Pompton St.","Brickhaven","MA","58339","USA",1216,23000.0,"23"],
    [34,34,"'-3392':10 '05':21 '1323':19 '1900':11 '202':1 '2k1':17 '555':9 '604':8 '90300.0':20 'bc':15 'canada':18 'canadian':2 'exchang':4 'gift':3 'network':5 'oak':12 'st':13 'tannamuri':6 'v3f':16 'vancouv':14 'yoshi':7",202,"Canadian Gift Exchange Network","Tannamuri","Yoshi","(604) 555-3392","1900 Oak St.","Vancouver","BC","V3F 2K1","Canada",1323,90300.0,"05"],
    [35,35,"'1188':15 '204':1 '23':17 '58339':13 '6175557555':7 '68700.0':16 '7635':8 'baraja':5 'brickhaven':11 'collect':4 'dr':10 'ma':12 'miguel':6 'mini':3 'onlin':2 'spinnak':9 'usa':14",204,"Online Mini Collectables","Barajas","Miguel","6175557555","7635 Spinnaker Dr.","Brickhaven","MA","58339","USA",1188,68700.0,"23"],
    [36,36,"'1166':13 '205':1 '23':15 '6265557265':5 '78934':6 '90003':11 '90700.0':14 'ca':10 'dr':8 'hillsid':7 'juli':4 'pasadena':9 'toys4grownups.com':2 'usa':12 'young':3",205,"Toys4GrownUps.com","Young","Julie","6265557265","78934 Hillside Dr.","Pasadena","CA","90003","USA",1166,90700.0,"23"],
    [41,41,"'11000.0':16 '1166':15 '219':1 '23':17 '3105552373':7 '4097':8 '92561':13 'av':10 'board':2 'ca':12 'co':4 'dougla':9 'glendal':11 'lesli':6 'toy':3 'usa':14 'young':5",219,"Boards & Toys Co.","Young","Leslie","3105552373","4097 Douglas Av.","Glendale","CA","92561","USA",1166,11000.0,"23"],
    [44,44,"'-8054':10 '05':22 '1286':20 '1c3':18 '233':1 '43':11 '48700.0':21 '514':8 '555':9 'canada':19 'fresnier':6 'h1j':17 'home':3 'jean':7 'laurent':14 'montrueal':15 'network':5 'quebec':2,16 'rue':12 'shop':4 'st':13",233,"Quebec Home Shopping Network","Fresniere","Jean","(514) 555-8054","43 rue St. Laurent","Montrueal","Quebec","H1J 1C3","Canada",1286,48700.0,"05"],
    [46,46,"'105000.0':18 '1166':17 '23':19 '239':1 '361':9 '7605558146':8 '91217':15 'ca':14 'circl':11 'co':5 'collect':2 'design':4 'diego':13 'furth':10 'mini':3 'san':12 'thompson':6 'usa':16 'valari':7",239,"Collectable Mini Designs Co.","Thompson","Valarie","7605558146","361 Furth Circle","San Diego","CA","91217","USA",1166,105000.0,"23"],
    [47,47,"'-8888':7 '1501':19 '170':21 '198':5 '240':1 '555':6 '7pj':17 '93900.0':20 'bennett':3 'cow':12 'crowther':10 'garden':8 'giftsbymail.co.uk':2 'helen':4 'hous':9 'isl':13 'po31':16 'uk':18 'way':11 'wight':15",240,"giftsbymail.co.uk","Bennett","Helen","(198) 555-8888","Garden House Crowther Way","Cowes","Isle of Wight","PO31 7PJ","UK",1501,93900.0,"170"],
    [54,54,"'-4555':10 '05':21 '1323':19 '23':11 '260':1 '555':9 '604':8 '89600.0':20 '8m4':17 'bc':15 'blvd':13 'canada':18 'canadian':3 'collect':4 'elizabeth':7 'lincoln':6 'ltd':5 'royal':2 't2f':16 'tsawassen':12,14",260,"Royal Canadian Collectables, Ltd.","Lincoln","Elizabeth","(604) 555-4555","23 Tsawassen Blvd.","Tsawassen","BC","T2F 8M4","Canada",1323,89600.0,"05"],
    [56,56,"'02':9 '107800.0':21 '1611':20 '175':22 '201':12 '2060':18 '276':1 '8555':11 '9936':10 'anna':2,8 'australia':19 'decor':4 'hara':7 'ltd':5 'miller':13 'north':15 'nsw':17 'o':6 'street':14 'sydney':16",276,"Anna's Decorations, Ltd","O'Hara","Anna","02 9936 8555","201 Miller Street","North Sydney","NSW","2060","Australia",1611,107800.0,"175"],
    [58,58,"'+61':8 '1611':22 '175':24 '2':9 '2067':20 '282':1 '815':15 '8555':11 '93300.0':23 '9495':10 'adrian':7 'australia':21 'build':14 'chatswood':18 'co':5 'huxley':6 'hwi':17 'money':13 'monitor':12 'nsw':19 'pacif':16 'souveni':2 'thing':4",282,"Souveniers And Things Co.","Huxley","Adrian","+61 2 9495 8555","Monitor Money Building, 815 Pacific Hwy","Chatswood","NSW","2067","Australia",1611,93300.0,"175"],
    [59,59,"'1216':16 '123700.0':17 '23':18 '286':1 '39323':9 '51247':14 '6175558555':8 'cambridg':12 'co':5 'dr':11 'hernandez':6 'ma':13 'marta':2,7 'replica':4 'spinnak':10 'usa':15",286,"Marta's Replicas Co.","Hernandez","Marta","6175558555","39323 Spinnaker Dr.","Cambridge","MA","51247","USA",1216,123700.0,"23"],
    [67,67,"'102700.0':17 '1323':16 '23':18 '24067':14 '319':1 '3758':7 '9145554562':6 'classic':3 'frick':4 'mini':2 'north':8 'ny':13 'pendal':9 'plain':12 'steve':5 'street':10 'usa':15 'white':11",319,"Mini Classics","Frick","Steve","9145554562","3758 North Pendale Street","White Plains","NY","24067","USA",1323,102700.0,"23"],
    [68,68,"'1188':17 '23':19 '320':1 '4575':9 '50553':15 '5085559555':8 '94500.0':18 'bedford':13 'c':7 'creation':3 'dr':11 'hillsid':10 'ltd':4 'ma':14 'mini':2 'new':12 'tam':5 'usa':16 'wing':6",320,"Mini Creations Ltd.","Tam","Wing C","5085559555","4575 Hillside Dr.","New Bedford","MA","50553","USA",1188,94500.0,"23"],
    [69,69,"'105000.0':18 '1165':17 '23':19 '321':1 '6505551386':8 '7734':9 '94217':15 'brown':6 'ca':14 'co':5 'corpor':2 'francisco':13 'gift':3 'idea':4 'juli':7 'san':12 'st':11 'strong':10 'usa':16",321,"Corporate Gift Ideas Co.","Brown","Julie","6505551386","7734 Strong St.","San Francisco","CA","94217","USA",1165,105000.0,"23"],
    [72,72,"'1323':15 '2015559350':7 '23':17 '328':1 '44100.0':16 '7476':8 '94019':13 'brown':5 'collect':3 'inc':4 'moss':9 'newark':11 'nj':12 'rd':10 'tekni':2 'usa':14 'william':6",328,"Tekni Collectables Inc.","Brown","William","2015559350","7476 Moss Rd.","Newark","NJ","94019","USA",1323,44100.0,"23"],
    [73,73,"'-3844':10 '-6555':11 '-7':9 '1611':22 '175':24 '31':12 '333':1 '4101':20 '51600.0':23 '61':8 'australia':21 'australian':2 'brisban':18 'calaghan':6 'co':5 'duncan':13 'end':16 'gift':3 'network':4 'queensland':19 'south':17 'st':14 'toni':7 'west':15",333,"Australian Gift Network, Co","Calaghan","Tony","61-7-3844-6555","31 Duncan St. West End","South Brisbane","Queensland","4101","Australia",1611,51600.0,"175"],
    [76,76,"'1188':16 '2155554695':8 '23':18 '339':1 '71270':14 '782':9 '81100.0':17 'cervant':6 'classic':2 'first':10 'francisca':7 'gift':3 'idea':4 'inc':5 'pa':13 'philadelphia':12 'street':11 'usa':15",339,"Classic Gift Ideas, Inc","Cervantes","Francisca","2155554695","782 First Street","Philadelphia","PA","71270","USA",1188,81100.0,"23"],
    [78,78,"'1166':18 '2155554369':9 '23':20 '347':1 '57700.0':19 '6047':10 '91003':16 'angel':14 'av':12 'ca':15 'chandler':7 'dougla':11 'los':13 'ltd':6 'men':2 'michael':8 'r':3 'retail':5 'us':4 'usa':17",347,"Men 'R' US Retailers, Ltd.","Chandler","Michael","2155554369","6047 Douglas Av.","Los Angeles","CA","91003","USA",1166,57700.0,"23"],
    [85,85,"'1216':13 '23':15 '362':1 '41900.0':14 '51003':11 '6175559555':5 '8616':6 'boston':9 'dr':8 'gifts4allages.com':2 'juri':4 'ma':10 'spinnak':7 'usa':12 'yoshido':3",362,"Gifts4AllAges.com","Yoshido","Juri","6175559555","8616 Spinnaker Dr.","Boston","MA","51003","USA",1216,41900.0,"23"],
    [86,86,"'114200.0':18 '1216':17 '23':19 '2304':9 '363':1 '6035558647':8 '62010':15 'airport':11 'avenu':12 'co':5 'creation':4 'diecast':3 'long':10 'nashua':13 'nh':14 'onlin':2 'usa':16 'valari':7 'young':6",363,"Online Diecast Creations Co.","Young","Valarie","6035558647","2304 Long Airport Avenue","Nashua","NH","62010","USA",1216,114200.0,"23"],
    [89,89,"'1188':16 '23':18 '379':1 '58339':14 '6175558555':8 '70700.0':17 '7825':9 'allen':7 'av':11 'brickhaven':12 'collect':2 'dougla':10 'inc':5 'less':4 'ma':13 'nelson':6 'usa':15",379,"Collectables For Less Inc.","Nelson","Allen","6175558555","7825 Douglas Av.","Brickhaven","MA","58339","USA",1188,70700.0,"23"],
    [94,94,"'+81':7 '-0032':20 '-2':12 '-8':13 '0555':10 '106':19 '107':24 '1621':22 '2':11 '3':8 '3584':9 '398':1 '94400.0':23 'akiko':6 'collect':3 'japan':21 'ku':17 'ltd':4 'minato':16 'minato-ku':15 'roppongi':14 'shimamura':5 'tokyo':2,18",398,"Tokyo Collectables, Ltd","Shimamura","Akiko","+81 3 3584 0555","2-2-8 Roppongi","Minato-ku","Tokyo","106-0032","Japan",1621,94400.0,"107"],
    [99,99,"'10022':13 '1286':15 '2125558493':7 '23':17 '424':1 '5905':8 '67500.0':16 'classic':2 'hernandez':5 'inc':4 'legend':3 'maria':6 'ny':12 'nyc':11 'pompton':9 'st':10 'usa':14",424,"Classic Legends Inc.","Hernandez","Maria","2125558493","5905 Pompton St.","NYC","NY","10022","USA",1286,67500.0,"23"],
    [101,101,"'1323':15 '2035554407':7 '23':17 '2440':8 '447':1 '49700.0':16 '97561':13 'corp':4 'ct':12 'dan':6 'gift':2 'glendal':11 'idea':3 'lewi':5 'pompton':9 'st':10 'usa':14",447,"Gift Ideas Corp.","Lewis","Dan","2035554407","2440 Pompton St.","Glendale","CT","97561","USA",1323,49700.0,"23"],
    [103,103,"'1165':17 '23':19 '3086':9 '4085553659':8 '450':1 '77600.0':18 '94217':15 'ca':14 'frick':6 'gift':4 'ingl':10 'jose':13 'ln':11 'san':12 'sharp':3 'sue':7 'usa':16 'warehous':5",450,"The Sharp Gifts Warehouse","Frick","Sue","4085553659","3086 Ingle Ln.","San Jose","CA","94217","USA",1165,77600.0,"23"],
    [105,105,"'1286':17 '2035559545':7 '23':19 '455':1 '567':8 '95400.0':18 '97823':15 'ct':14 'haven':13 'inc':4 'lesli':6 'murphi':5 'new':12 'north':9 'pendal':10 'scale':3 'street':11 'super':2 'usa':16",455,"Super Scale Inc.","Murphy","Leslie","2035559545","567 North Pendale Street","New Haven","CT","97823","USA",1286,95400.0,"23"],
    [106,106,"'10022':13 '1286':15 '2125551957':6 '23':17 '39800.0':16 '456':1 '5290':7 'inc':3 'kee':5 'kuo':4 'microscal':2 'north':8 'ny':12 'nyc':11 'pendal':9 'street':10 'usa':14",456,"Microscale Inc.","Kuo","Kee","2125551957","5290 North Pendale Street","NYC","NY","10022","USA",1286,39800.0,"23"],
    [109,109,"'1216':14 '1785':6 '23':16 '462':1 '50553':12 '5085552555':5 '85800.0':15 'bedford':10 'benitez':3 'first':7 'fungiftideas.com':2 'ma':11 'new':9 'street':8 'usa':13 'violeta':4",462,"FunGiftIdeas.com","Benitez","Violeta","5085552555","1785 First Street","New Bedford","MA","50553","USA",1216,85800.0,"23"],
    [111,111,"'-3844':9 '-6555':10 '-9':8 '1611':19 '175':21 '3150':17 '471':1 '60300.0':20 '61':7 '7':11 'allen':12 'australia':18 'australian':2 'collect':3 'conneri':5 'glen':14 'ltd':4 'sean':6 'street':13 'victoria':16 'waver':15",471,"Australian Collectables, Ltd","Connery","Sean","61-9-3844-6555","7 Allen Street","Glen Waverly","Victoria","3150","Australia",1611,60300.0,"175"],
    [113,113,"'1166':16 '23':18 '3105553722':8 '3675':9 '475':1 '55400.0':17 '94019':14 'burbank':12 'ca':13 'circl':11 'co':5 'coast':3 'collect':4 'furth':10 'steve':7 'thompson':6 'usa':15 'west':2",475,"West Coast Collectables Co.","Thompson","Steve","3105553722","3675 Furth Circle","Burbank","CA","94019","USA",1166,55400.0,"23"],
    [118,118,"'11328':9 '1323':16 '2155559857':8 '23':18 '486':1 '71270':14 '72600.0':17 'av':11 'distributor':4 'dougla':10 'hernandez':6 'inc':5 'mint':3 'motor':2 'pa':13 'philadelphia':12 'rosa':7 'usa':15",486,"Motor Mint Distributors Inc.","Hernandez","Rosa","2155559857","11328 Douglas Av.","Philadelphia","PA","71270","USA",1323,72600.0,"23"],
    [119,119,"'1165':15 '23':17 '2793':8 '4155554312':7 '487':1 '60300.0':16 '94217':13 'brisban':11 'ca':12 'circl':10 'collect':3 'furth':9 'ltd':4 'signal':2 'sue':6 'taylor':5 'usa':14",487,"Signal Collectibles Ltd.","Taylor","Sue","4155554312","2793 Furth Circle","Brisbane","CA","94217","USA",1165,60300.0,"23"],
    [121,121,"'1188':14 '23':16 '495':1 '51003':12 '6175552555':6 '6251':7 '85100.0':15 'boston':10 'collect':3 'diecast':2 'franco':4 'ingl':8 'ln':9 'ma':11 'usa':13 'valari':5",495,"Diecast Collectables","Franco","Valarie","6175552555","6251 Ingle Ln.","Boston","MA","51003","USA",1188,85100.0,"23"]
]}