CSV Files- a standard for data storage and interchange,

I have frequently used csv files as part of a LB solution to some problem, and also as a lingua franca for exchanging data with spreadsheets.

'CSV' stands for Comma Separated Values. The data is in ASCII text format, with rows and columns. The first row often holds column headings. Data items in a row are separated with ',' signs, ASCII 34 or h2C. Rows and whole file end with CRLF, ie h0D h0A, or chr$( 13) chr$( 10).

This should be visible in the printout below of part of a sample file as text and as a hex dump.

Note that while all spreadsheets will load and save in csv format, their native format is much bulkier, with all sorts of formatting data, macros, etc.

Using such files in LB

It is straightforward to write LB code to manipulate such files. It's a good exercise to generate a GUI front end for such programs. LB has continuously gained inbuilt functions to help- and hopefully a grid presentation method in LB5,

I've often found data on the web, such as astronomical star data, that can be read straight into LB for me to do whatever I like. See an example.

Another example was I found datafiles online of height above sea level by latitude and longitude, so in LB could generate animated maps of the effects of rising sea levels where I live.

There are always things to do with data that even the creators of Excel haven't thought of- 'though my LB code may run slower, it is more versatile.

CAUTION!

Two things may complicate your use of csv files obtained from others.

Linux and Microsoft use different line/file terminators. It may be CRLF, or one of these chars alone.

In an effort to make csv files hold more universal character strings, especially those holding commas ',' and '"' 'quote' characters, you may find strings surrounded by chr$( 34) quote characters.

Any decent spreadsheet ( Excel, Open Office) will offer to import all such files and allow you to chreck exactly what you are importing and what it may become on import.

User beware!


See other LB examples of mine at my web site.


Code for a read/display/modify/save application follows. It doesn't include other functions, but they are left 'as an exercise for the reader'!

    '   ************************************************************************************
    '   **                                                                                **
    '   **       readWriteCsv3.bas         tenochtitlanuk           Feb/July 2019         **
    '   **                                                                                **
    '   ************************************************************************************


    '   I have a csv-separated list of people's names, email, tel, addresses, etc. "MOCK_DATA.csv"

    '   Read csv file into an array...

    dim data$( 1000, 20)        '   anticipate up to 1000 rows, 20 columns. data$( col, row)

    i   =1                      '   (assume you want terms to start at 0 rather than zero)

    global recNum, numRows, numCols, fn$, firstRow$

    filedialog "Choose csv datafile", "*.csv", fn$

    open fn$ for input as #fileIn
        line input #fileIn, firstRow$
        numCols     =1    '   find number of columns

        for f =1 to len( firstRow$)
            if mid$( firstRow$, f, 1) ="," then numCols =numCols +1
        next f

        while eof( #fileIn) =0  '   read each row and its column entries into an array
            line input #fileIn, row$

            for k =0 to numCols
                item$       =word$( row$, k, ",")
                if item$ <>"" then data$( i, k) =item$  ': print item$,
            next k

            i     =i +1
            scan
            'print ""            '   start a new row
        wend

        numRows =i -1

    close #fileIn               '   array now holds all the data.

    textbox    #w.te1,  220,  40, 400, 30
    textbox    #w.te2,  220,  80, 400, 30
    textbox    #w.te3,  220, 120, 400, 30
    textbox    #w.te4,  220, 160, 400, 30
    textbox    #w.te5,  220, 200, 400, 30
    textbox    #w.te6,  220, 240, 400, 30
    textbox    #w.te7,  220, 280, 400, 30
    textbox    #w.te8,  220, 320, 400, 30
    textbox    #w.te9,  220, 360, 400, 30
    textbox    #w.te10, 220, 400, 400, 30
    textbox    #w.te11, 220, 440, 400, 30
    textbox    #w.te12, 220, 480, 400, 30

    statictext #w.st1,  "", 20,  40, 180, 30
    statictext #w.st2,  "", 20,  80, 180, 30
    statictext #w.st3,  "", 20, 120, 180, 30
    statictext #w.st4,  "", 20, 160, 180, 30
    statictext #w.st5,  "", 20, 200, 180, 30
    statictext #w.st6,  "", 20, 240, 180, 30
    statictext #w.st7,  "", 20, 280, 180, 30
    statictext #w.st8,  "", 20, 320, 180, 30
    statictext #w.st9,  "", 20, 360, 180, 30
    statictext #w.st10, "", 20, 400, 180, 30
    statictext #w.st11, "", 20, 440, 180, 30
    statictext #w.st11, "", 20, 480, 180, 30
    statictext #w.st12, "", 20, 520, 180, 30

    button     #w.bu1, "Record no?",      recordNumber, LR, 200, 420, 160, 30
    button     #w.bu2, "Print?",          printRecord,  LR, 200, 380, 160, 30
    button     #w.bu3, "Save Record",     saveEdit,     LR, 200, 340, 160, 30
    button     #w.bu4, "Save DBase",      saveFile,     LR, 200, 260, 160, 30
    button     #w.bu5, "Quit",            quit,         LR, 200, 140, 160, 30

    bmpbutton  #w.bb1,  "left.bmp",  returnVar, LR, 210, 390
    bmpbutton  #w.bb2,  "right.bmp", returnVar, LR,  10, 390

    nomainwin

    WindowWidth  =1000
    WindowHeight = 600

    open "Demo. csv data read/ alter/ write" for window as #w

    #w "trapclose quit"
    #w "font 10 bold"

    #w.st1  word$( firstRow$,  1, ",")
    #w.st2  word$( firstRow$,  2, ",")
    #w.st3  word$( firstRow$,  3, ",")
    #w.st4  word$( firstRow$,  4, ",")
    #w.st5  word$( firstRow$,  5, ",")
    #w.st6  word$( firstRow$,  6, ",")
    #w.st7  word$( firstRow$,  7, ",")
    #w.st8  word$( firstRow$,  8, ",")
    #w.st9  word$( firstRow$,  9, ",")
    #w.st10 word$( firstRow$, 10, ",")
    #w.st11 word$( firstRow$, 11, ",")
    #w.st12 word$( firstRow$, 12, ",")

    #w.te1  data$( 1,  1)
    #w.te2  data$( 1,  2)
    #w.te3  data$( 1,  3)
    #w.te4  data$( 1,  4)
    #w.te5  data$( 1,  5)
    #w.te6  data$( 1,  6)
    #w.te7  data$( 1,  7)
    #w.te8  data$( 1,  8)
    #w.te9  data$( 1,  9)
    #w.te10 data$( 1, 10)
    #w.te11 data$( 1, 11)
    #w.te12 data$( 1, 12)

    wait

    sub recordNumber a$
    prompt "Desired record number"; rec$
    recNum =val( rec$)

    for k =1 to numCols
        #w.te1  data$( recNum,  1)
        #w.te2  data$( recNum,  2)
        #w.te3  data$( recNum,  3)
        #w.te4  data$( recNum,  4)
        #w.te5  data$( recNum,  5)
        #w.te6  data$( recNum,  6)
        #w.te7  data$( recNum,  7)
        #w.te8  data$( recNum,  8)
        #w.te9  data$( recNum,  9)
        #w.te10 data$( recNum, 10)
        #w.te11 data$( recNum, 11)
        #w.te12 data$( recNum, 12)
    next k

    end sub

    sub printRecord a$
        '   not implemented...
    end sub

    sub saveEdit a$
    for k =1 to numCols
        #w.te1   "!contents? c$": data$( recNum,  1) =c$
        #w.te2   "!contents? c$": data$( recNum,  2) =c$
        #w.te3   "!contents? c$": data$( recNum,  3) =c$
        #w.te4   "!contents? c$": data$( recNum,  4) =c$
        #w.te5   "!contents? c$": data$( recNum,  5) =c$
        #w.te6   "!contents? c$": data$( recNum,  6) =c$
        #w.te7   "!contents? c$": data$( recNum,  7) =c$
        #w.te8   "!contents? c$": data$( recNum,  8) =c$
        #w.te9   "!contents? c$": data$( recNum,  9) =c$
        #w.te10  "!contents? c$": data$( recNum, 10) =c$
        #w.te11  "!contents? c$": data$( recNum, 11) =c$
        #w.te12  "!contents? c$": data$( recNum, 12) =c$
    next k
    end sub

    sub saveFile a$
        fileOut$    =word$( fn$, 1, ".") +"New.csv"
        open fileOut$ for output as #fOut
            #fOut firstRow$ +chr$( 13) +chr$( 10);

            for i =1 to numRows
                for j =1 to numCols
                    #fOut data$( i, j);
                    if j <>numCols then #fOut ",";
                next j
                #fOut chr$( 13) +chr$( 10);
            next i
        close #fOut
    end sub

    sub quit h$
        '   save array as csv file with amended name
        '   put up notice saying saving before exit
        close #w
        end
    end sub

    textbox    #w.te4,  220, 160, 400, 30
    textbox    #w.te5,  220, 200, 400, 30
    textbox    #w.te6,  220, 240, 400, 30
    textbox    #w.te7,  220, 280, 400, 30
    textbox    #w.te8,  220, 320, 400, 30
    textbox    #w.te9,  220, 360, 400, 30
    textbox    #w.te10, 220, 400, 400, 30
    textbox    #w.te11, 220, 440, 400, 30
    textbox    #w.te12, 220, 480, 400, 30

    statictext #w.st1,  "", 20,  40, 180, 30
    statictext #w.st2,  "", 20,  80, 180, 30
    statictext #w.st3,  "", 20, 120, 180, 30
    statictext #w.st4,  "", 20, 160, 180, 30
    statictext #w.st5,  "", 20, 200, 180, 30
    statictext #w.st6,  "", 20, 240, 180, 30
    statictext #w.st7,  "", 20, 280, 180, 30
    statictext #w.st8,  "", 20, 320, 180, 30
    statictext #w.st9,  "", 20, 360, 180, 30
    statictext #w.st10, "", 20, 400, 180, 30
    statictext #w.st11, "", 20, 440, 180, 30
    statictext #w.st11, "", 20, 480, 180, 30
    statictext #w.st12, "", 20, 520, 180, 30

    button     #w.bu1, "Record no?",      recordNumber, LR, 200, 420, 160, 30
    button     #w.bu2, "Print?",          printRecord,  LR, 200, 380, 160, 30
    button     #w.bu3, "Save Record",     saveEdit,     LR, 200, 340, 160, 30
    button     #w.bu4, "Save DBase",      saveFile,     LR, 200, 260, 160, 30
    button     #w.bu5, "Quit",            quit,         LR, 200, 140, 160, 30

    bmpbutton  #w.bb1,  "left.bmp",  returnVar, LR, 210, 390
    bmpbutton  #w.bb2,  "right.bmp", returnVar, LR,  10, 390

    nomainwin

    WindowWidth  =1000
    WindowHeight = 600

    open "Demo. csv data read/ alter/ write" for window as #w

    #w "trapclose quit"
    #w "font 10 bold"

    #w.st1  word$( firstRow$,  1, ",")
    #w.st2  word$( firstRow$,  2, ",")
    #w.st3  word$( firstRow$,  3, ",")
    #w.st4  word$( firstRow$,  4, ",")
    #w.st5  word$( firstRow$,  5, ",")
    #w.st6  word$( firstRow$,  6, ",")
    #w.st7  word$( firstRow$,  7, ",")
    #w.st8  word$( firstRow$,  8, ",")
    #w.st9  word$( firstRow$,  9, ",")
    #w.st10 word$( firstRow$, 10, ",")
    #w.st11 word$( firstRow$, 11, ",")
    #w.st12 word$( firstRow$, 12, ",")

    #w.te1  data$( 1,  1)
    #w.te2  data$( 1,  2)
    #w.te3  data$( 1,  3)
    #w.te4  data$( 1,  4)
    #w.te5  data$( 1,  5)
    #w.te6  data$( 1,  6)
    #w.te7  data$( 1,  7)
    #w.te8  data$( 1,  8)
    #w.te9  data$( 1,  9)
    #w.te10 data$( 1, 10)
    #w.te11 data$( 1, 11)
    #w.te12 data$( 1, 12)

    wait

    sub recordNumber a$
    prompt "Desired record number"; rec$
    recNum =val( rec$)

    for k =1 to numCols
        #w.te1  data$( recNum,  1)
        #w.te2  data$( recNum,  2)
        #w.te3  data$( recNum,  3)
        #w.te4  data$( recNum,  4)
        #w.te5  data$( recNum,  5)
        #w.te6  data$( recNum,  6)
        #w.te7  data$( recNum,  7)
        #w.te8  data$( recNum,  8)
        #w.te9  data$( recNum,  9)
        #w.te10 data$( recNum, 10)
        #w.te11 data$( recNum, 11)
        #w.te12 data$( recNum, 12)
    next k

    end sub

    sub printRecord a$
        '   not implemented...
    end sub

    sub saveEdit a$
    for k =1 to numCols
        #w.te1   "!contents? c$": data$( recNum,  1) =c$
        #w.te2   "!contents? c$": data$( recNum,  2) =c$
        #w.te3   "!contents? c$": data$( recNum,  3) =c$
        #w.te4   "!contents? c$": data$( recNum,  4) =c$
        #w.te5   "!contents? c$": data$( recNum,  5) =c$
        #w.te6   "!contents? c$": data$( recNum,  6) =c$
        #w.te7   "!contents? c$": data$( recNum,  7) =c$
        #w.te8   "!contents? c$": data$( recNum,  8) =c$
        #w.te9   "!contents? c$": data$( recNum,  9) =c$
        #w.te10  "!contents? c$": data$( recNum, 10) =c$
        #w.te11  "!contents? c$": data$( recNum, 11) =c$
        #w.te12  "!contents? c$": data$( recNum, 12) =c$
    next k
    end sub

    sub saveFile a$
        fileOut$    =word$( fn$, 1, ".") +"New.csv"
        open fileOut$ for output as #fOut
            #fOut firstRow$ +chr$( 13) +chr$( 10);

            for i =1 to numRows
                for j =1 to numCols
                    #fOut data$( i, j);
                    if j <>numCols then #fOut ",";
                next j
                #fOut chr$( 13) +chr$( 10);
            next i
        close #fOut
    end sub

    sub quit h$
        '   save array as csv file with amended name
        '   put up notice saying saving before exit
        close #w
        end
    end sub
and the data file
id,first_name,last_name,email,gender,ip_address,Town,Country,Telephone
1,Mellisent,Atkinson,matkinson0@ed.gov,Female,132.184.164.67,Ufimskiy,Russia,+7-528-235-0490
2,Merrel,Dewdney,mdewdney1@google.com,Male,70.194.5.103,Bergerac,France,+33-591-768-4351
3,Horace,Gillum,hgillum2@google.com.hk,Male,151.229.167.50,Xinsheng,China,+86-733-329-5150
4,Ruthie,De Avenell,rdeavenell3@noaa.gov,Female,46.101.6.221,Al Mughayyir,Palestinian Territory,+970-175-858-9294
5,Blayne,Sherrocks,bsherrocks4@walmart.com,Male,200.133.217.60,Cikuya,Indonesia,+62-104-965-3112
6,Phedra,Keizman,pkeizman5@creativecommons.org,Female,233.14.22.195,Kloulklubed,Palau,+680-683-365-3528
7,Kandy,Ketchell,kketchell6@sciencedaily.com,Female,152.161.77.217,Suhong,China,+86-192-941-0861
8,Jerrold,Risebrow,jrisebrow7@cloudflare.com,Male,44.2.25.162,Phùng,Vietnam,+84-770-132-7341
9,Adrianne,Yetton,ayetton8@usnews.com,Female,134.147.18.12,Quintães,Portugal,+351-683-326-1607
10,Alphonso,Garn,agarn9@cam.ac.uk,Male,58.247.147.67,Mosina,Poland,+48-491-200-1739
11,Daffi,Stoneman,dstonemana@ycombinator.com,Female,200.102.84.250,Sangongqiao,China,+86-388-291-5597
12,Bernardine,Ayre,bayreb@stanford.edu,Female,73.112.54.209,Podedwórze,Poland,+48-543-654-6838
13,Stesha,Dwelling,sdwellingc@wufoo.com,Female,64.224.239.181,Oygon,Mongolia,+976-995-338-8965
14,Lotte,Tremontana,ltremontanad@fda.gov,Female,221.162.119.2,Donglai,China,+86-700-740-3566
15,Brendin,Breazeall,bbreazealle@huffingtonpost.com,Male,128.227.20.247,Khŭjand,Tajikistan,+992-218-144-1725
16,Tadeo,Snaith,tsnaithf@gmpg.org,Male,133.17.119.34,Margen,Philippines,+63-285-446-4383
17,Cecil,Currington,ccurringtong@huffingtonpost.com,Male,215.116.19.24,Gongyi,China,+86-903-994-9291
18,Ula,Ikin,uikinh@tuttocitta.it,Female,125.26.174.192,Dallas,United States,+1-214-308-6606
19,Jamill,Bortol,jbortoli@hao123.com,Male,233.167.213.156,Qalyūb,Egypt,+20-660-288-7735
20,Loren,Toms,ltomsj@posterous.com,Male,78.25.89.59,Catumbela,Angola,+244-737-862-1467
21,Gerald,Coupar,gcoupark@vistaprint.com,Male,168.191.115.138,Mosteiro,Portugal,+351-411-183-6425
22,Wilhelmine,Portch,wportchl@live.com,Female,212.120.215.132,Catalina,Canada,+1-498-980-8191
23,Danella,Iannitti,diannittim@cafepress.com,Female,85.35.238.115,Cikijing,Indonesia,+62-351-439-3089
24,Merla,Bartosik,mbartosikn@wordpress.org,Female,97.34.148.119,Halimpu,Indonesia,+62-802-887-4954
25,Carolin,Hatwells,chatwellso@bbc.co.uk,Female,11.76.28.58,La Guata,Honduras,+504-539-930-1056
26,Charlotte,Housego,chousegop@edublogs.org,Female,15.244.59.36,Union,Philippines,+63-215-362-9722
27,Ermentrude,De la Yglesia,edelayglesiaq@cnet.com,Female,10.20.30.10,Fredrikstad,Norway,+47-920-543-5360
28,Waldemar,Dussy,wdussyr@bbb.org,Male,194.44.178.3,Sindangrasa,Indonesia,+62-663-525-6055
29,Chrissy,Jeffes,cjeffess@sourceforge.net,Male,67.78.158.212,Mozdok,Russia,+7-994-931-6910
30,Almira,Coggin,acoggint@ask.com,Female,33.185.159.208,Viengxay,Laos,+856-204-846-4348
31,Franni,Alloisi,falloisiu@exblog.jp,Female,105.81.104.18,Kelowna,Canada,+1-788-800-5974
32,Opaline,Barrack,obarrackv@intel.com,Female,50.87.131.158,Punta de Bombón,Peru,+51-838-997-6993
33,Lorrin,Lidington,llidingtonw@dedecms.com,Female,207.165.84.117,Khanu Woralaksaburi,Thailand,+66-898-641-8477
34,Tessy,Wyllie,twylliex@microsoft.com,Female,185.82.119.102,Biny Selo,Azerbaijan,+994-463-409-9764
35,Michelle,Lamey,mlameyy@ox.ac.uk,Female,171.239.200.244,Chodów,Poland,+48-330-635-9288
36,Christiane,Esome,cesomez@blogtalkradio.com,Female,151.0.7.26,Bulakan,Indonesia,+62-441-956-7520
37,Calypso,McConville,cmcconville10@sciencedaily.com,Female,96.106.196.11,Bamako,Mali,+223-147-170-1387
38,Mariska,Cajkler,mcajkler11@hc360.com,Female,40.81.46.120,Stockholm,Sweden,+46-250-912-7715
39,Laurianne,Bhar,lbhar12@bbb.org,Female,192.30.185.168,Rudnichnyy,Russia,+7-373-760-2913
40,Margarete,Kleinsmuntz,mkleinsmuntz13@trellian.com,Female,223.185.120.92,Chuoyuan,China,+86-729-800-7953
41,Gibb,Erett,gerett14@jugem.jp,Male,43.218.194.231,Wuma,China,+86-173-316-4743
42,Halsy,Selby,hselby15@vistaprint.com,Male,73.204.129.99,Porto Ferreira,Brazil,+55-521-227-0896
43,Vail,Keuneke,vkeuneke16@miitbeian.gov.cn,Male,131.173.59.121,La Asunción,Costa Rica,+506-679-947-5759
44,Timoteo,Cranfield,tcranfield17@nymag.com,Male,15.43.123.233,Provo,United States,+1-801-702-0105
45,Iris,Wailes,iwailes18@theglobeandmail.com,Female,32.120.146.157,Zhuoshui,China,+86-340-446-0402
46,Hurlee,Croote,hcroote19@people.com.cn,Male,2.15.218.99,Oklahoma City,United States,+1-405-467-5360
47,Trip,Biaggioni,tbiaggioni1a@ezinearticles.com,Male,249.235.191.248,Xiang Ngeun,Laos,+856-904-201-9963
48,Rosmunda,Spaven,rspaven1b@cafepress.com,Female,132.17.114.23,Jiepai,China,+86-551-474-3866
49,Pembroke,Healings,phealings1c@multiply.com,Male,180.141.93.26,Shuangqiao,China,+86-164-911-0662
50,Norbert,Mableson,nmableson1d@fastcompany.com,Male,171.2.77.2,Saint Ann’s Bay,Jamaica,+1-129-477-0756
51,Urban,Standingford,ustandingford1e@unicef.org,Male,176.8.59.134,El Charco,Colombia,+57-362-918-3490
52,Hy,Grinsted,hgrinsted1f@lulu.com,Male,214.151.253.75,Kashima-shi,Japan,+81-985-703-3000
53,Abdel,Trudgian,atrudgian1g@oaic.gov.au,Male,85.190.169.169,Bibis,Indonesia,+62-709-524-0810
54,Adelaide,Mileham,amileham1h@cpanel.net,Female,156.103.71.246,Xingcheng,China,+86-197-251-9291
55,Vicky,Nossent,vnossent1i@51.la,Female,78.57.121.128,Saint-Germain-en-Laye,France,+33-497-768-8418
56,Cordelia,Sibthorpe,csibthorpe1j@google.com,Female,10.89.138.163,Shiyu,China,+86-637-971-7501
57,Maurie,Schaffel,mschaffel1k@princeton.edu,Male,77.237.1.35,Öndörhoshuu,Mongolia,+976-207-506-1867
58,Bel,Grelik,bgrelik1l@chron.com,Female,97.35.181.181,Hongyi,China,+86-967-167-3437
59,Annabela,Barles,abarles1m@ucsd.edu,Female,224.156.95.19,Nanmen,China,+86-120-234-1505
60,Giuditta,Arthan,garthan1n@purevolume.com,Female,200.90.124.51,Lupane,Zimbabwe,+263-524-920-3341
61,Carley,Troucher,ctroucher1o@instagram.com,Female,40.81.12.21,Ostrzeszów,Poland,+48-433-595-1287
62,Elsworth,Deverell,edeverell1p@accuweather.com,Male,129.203.49.255,Svatava,Czech Republic,+420-705-293-7237
63,Davine,Durward,ddurward1q@spiegel.de,Female,44.111.82.181,Sanxixiang,China,+86-818-877-9762
64,Willis,Cardon,wcardon1r@cornell.edu,Male,2.149.231.159,Candelária,Portugal,+351-739-240-4462
65,Stefania,Georgins,sgeorgins1s@mozilla.com,Female,21.65.42.195,San Calixto,Colombia,+57-174-336-9255
66,Terese,Cherryman,tcherryman1t@edublogs.org,Female,147.93.30.17,Sahagún,Colombia,+57-317-520-7966
67,Rebecka,Dawltrey,rdawltrey1u@angelfire.com,Female,162.246.195.12,Solosolo,Samoa,+685-954-101-1438
68,Ricki,Doud,rdoud1v@cdc.gov,Female,157.177.245.23,Fort Worth,United States,+1-682-927-8447
69,Jeffy,Conrad,jconrad1w@xrea.com,Male,182.156.147.173,Vandœuvre-lès-Nancy,France,+33-414-711-1575
70,Joel,Faucherand,jfaucherand1x@booking.com,Male,236.232.85.41,Naviraí,Brazil,+55-926-346-4469
71,Raimund,Deeny,rdeeny1y@clickbank.net,Male,54.41.237.5,Megáli Khóra,Greece,+30-814-453-8281
72,Brodie,Keetley,bkeetley1z@wunderground.com,Male,97.254.112.232,Ryazanskiy,Russia,+7-921-494-9759
73,Fayre,Larmour,flarmour20@trellian.com,Female,203.69.189.118,Portalegre,Portugal,+351-248-783-7183
74,Derrik,Royan,droyan21@nsw.gov.au,Male,164.20.5.61,Hennenman,South Africa,+27-460-422-8942
75,Jorgan,Goulborn,jgoulborn22@wordpress.com,Male,42.83.219.184,Novokuz’minki,Russia,+7-250-652-0042
76,Syd,Nuccii,snuccii23@vk.com,Male,82.207.183.126,Manwakh,Yemen,+967-857-964-5153
77,Verney,Bertenshaw,vbertenshaw24@narod.ru,Male,2.30.102.38,Sundbyberg,Sweden,+46-993-652-1798
78,Adler,Bootyman,abootyman25@homestead.com,Male,131.75.47.178,Wuxi,China,+86-479-235-6679
79,Maynord,Hefferon,mhefferon26@sogou.com,Male,69.109.37.56,Erdaobaihe,China,+86-309-118-2040
80,Didi,Ambroisin,dambroisin27@blog.com,Female,11.244.157.71,Bayanhongor,Mongolia,+976-286-884-4813
81,Karel,Winship,kwinship28@cloudflare.com,Female,254.98.40.149,Yigo Village,Guam,+1-573-835-0519
82,Kip,Finlayson,kfinlayson29@weebly.com,Male,45.21.198.254,Zdounky,Czech Republic,+420-883-765-0356
83,Saw,Synder,ssynder2a@reddit.com,Male,35.205.142.137,Hoàn Kiếm,Vietnam,+84-158-237-0962
84,Falito,Avrasin,favrasin2b@is.gd,Male,90.162.22.20,Soasio,Indonesia,+62-975-753-9792
85,Codie,Stalley,cstalley2c@cloudflare.com,Female,112.56.233.104,Tafí del Valle,Argentina,+54-496-366-5285
86,Jess,Artinstall,jartinstall2d@google.de,Male,115.180.17.135,Sterlibashevo,Russia,+7-264-598-2801
87,Enrico,Habron,ehabron2e@rambler.ru,Male,221.161.117.41,Tiglauigan,Philippines,+63-642-828-3866
88,Wynny,Weepers,wweepers2f@blog.com,Female,97.235.38.95,Kogota,Japan,+81-109-169-6769
89,Decca,Picott,dpicott2g@unicef.org,Male,113.128.88.90,Marka,Somalia,+252-667-780-6135
90,Smith,Grieves,sgrieves2h@opera.com,Male,66.84.140.126,Domaradz,Poland,+48-586-136-4253
91,Friedrick,Fargie,ffargie2i@squarespace.com,Male,214.161.245.198,Prelog,Croatia,+385-665-216-9206
92,Jeni,Grover,jgrover2j@eepurl.com,Female,253.172.56.177,Inhambupe,Brazil,+55-572-321-1796
93,Shea,Zoellner,szoellner2k@gmpg.org,Female,245.13.15.4,Uppsala,Sweden,+46-471-443-7769
94,Kenton,Signori,ksignori2l@google.co.jp,Male,45.151.96.83,Velika Kladuša,Bosnia and Herzegovina,+387-202-494-3897
95,Donna,Wakley,dwakley2m@deliciousdays.com,Female,95.252.36.230,Bratislava,Slovakia,+421-943-157-4323
96,Ruthy,Tootal,rtootal2n@indiatimes.com,Female,142.41.103.32,Jiangning,China,+86-634-996-9618
97,Janella,Wyse,jwyse2o@opera.com,Female,130.130.70.95,Bat Khela,Pakistan,+92-964-274-4276
98,Latrena,de Werk,ldewerk2p@imgur.com,Female,39.100.170.248,Odolena Voda,Czech Republic,+420-809-561-7420
99,Sayer,Jouanny,sjouanny2q@theatlantic.com,Male,143.89.8.32,Usevia,Tanzania,+255-804-674-6057
100,Essie,MacAllister,emacallister2r@mediafire.com,Female,253.83.182.0,Zliten,Libya,+218-882-387-4522
101,Efrem,Goodinson,egoodinson2s@berkeley.edu,Male,153.227.107.46,Palopo,Indonesia,+62-481-978-1300
102,Sigismondo,Durtnall,sdurtnall2t@a8.net,Male,105.230.4.203,Lamatuka,Indonesia,+62-367-354-3581
103,Kanya,Orys,korys2u@goo.gl,Female,0.54.186.200,Veiga,Portugal,+351-452-909-7899
104,Sloane,Churly,schurly2v@canalblog.com,Male,86.235.66.247,Kamárai,Greece,+30-505-515-8796
105,Isac,Burgess,iburgess2w@ehow.com,Male,180.1.118.98,Lovisa,Finland,+358-825-100-0760
106,Verna,Jacson,vjacson2x@ucsd.edu,Female,135.247.48.160,Vlkoš,Czech Republic,+420-153-989-7240
107,Desiree,Serotsky,dserotsky2y@blogspot.com,Female,219.114.27.154,Vetlanda,Sweden,+46-627-224-5537
108,Neall,Carson,ncarson2z@1688.com,Male,216.119.38.132,Roma,Italy,+39-633-332-7735
109,Vanya,Vickress,vvickress30@samsung.com,Male,37.194.40.209,Yancheng,China,+86-145-587-0979
110,Sela,Starbeck,sstarbeck31@google.pl,Female,239.85.221.82,Shuangshi,China,+86-384-804-9905
111,Christian,Peevor,cpeevor32@ow.ly,Female,156.131.95.233,Hiratsuka,Japan,+81-670-328-0615
112,Emmy,Arrigucci,earrigucci33@gravatar.com,Male,157.204.125.109,Trmice,Czech Republic,+420-878-411-5028
113,Granthem,Itzhak,gitzhak34@w3.org,Male,166.34.229.207,Baima,China,+86-889-279-5526
114,Vivia,Carlill,vcarlill35@sbwire.com,Female,75.170.12.89,Wanghu,China,+86-118-640-3535
115,York,de Pinna,ydepinna36@noaa.gov,Male,217.64.221.209,Fengshuling,China,+86-613-418-1887
116,Rudy,Coushe,rcoushe37@themeforest.net,Male,195.104.176.30,Ash Shajarah,Syria,+963-279-699-3703
117,Petronilla,Pigford,ppigford38@squarespace.com,Female,196.75.69.17,Saint-Gratien,France,+33-585-116-8405
118,Willard,Bavister,wbavister39@amazonaws.com,Male,250.113.121.51,Placer,Philippines,+63-561-903-7007
119,Elset,Duncanson,eduncanson3a@theglobeandmail.com,Female,127.78.224.155,Puerto Esperanza,Argentina,+54-328-977-2855
120,Beitris,Schroeder,bschroeder3b@1und1.de,Female,240.35.38.129,Nová Role,Czech Republic,+420-283-650-1136
121,Brice,Wims,bwims3c@wunderground.com,Male,41.95.6.131,Panyingkiran,Indonesia,+62-184-958-8290
122,Emlynne,Teml,eteml3d@shinystat.com,Female,211.113.123.81,Erfurt,Germany,+49-638-466-5180
123,Ray,Hanscom,rhanscom3e@apple.com,Female,248.57.37.97,Tolitoli,Indonesia,+62-594-554-4242
124,Benedict,Morde,bmorde3f@google.com.hk,Male,192.129.251.173,Czarna Woda,Poland,+48-641-440-8079
125,Ignacio,Napthine,inapthine3g@statcounter.com,Male,46.106.65.245,Puerto Esperanza,Argentina,+54-657-562-0609
126,Chadd,Belfield,cbelfield3h@usa.gov,Male,148.142.94.164,Doumen,China,+86-157-537-6202
127,Sada,Havvock,shavvock3i@auda.org.au,Female,213.72.24.13,Boyeros,Cuba,+53-452-615-7083
128,Margaux,Halsey,mhalsey3j@zimbio.com,Female,129.35.227.81,Zhusha,China,+86-522-871-1032
129,Cordie,Moakson,cmoakson3k@github.com,Male,93.67.222.30,Bourail,New Caledonia,+687-108-798-3237
130,Boycey,Yegorchenkov,byegorchenkov3l@istockphoto.com,Male,194.182.4.65,Sorong,Indonesia,+62-885-269-5688
131,Chet,Wadman,cwadman3m@reverbnation.com,Male,88.13.99.216,Norsborg,Sweden,+46-966-137-1737
132,Alberik,Yelyashev,ayelyashev3n@vkontakte.ru,Male,148.198.73.33,Kaabong,Uganda,+256-824-713-7919
133,Glori,Cassam,gcassam3o@t.co,Female,124.65.25.213,Amio,Philippines,+63-447-529-7579
134,Val,Creaser,vcreaser3p@eventbrite.com,Female,219.249.106.176,Akbarābād,Iran,+98-347-847-4005
135,Zorine,Zarfati,zzarfati3q@zdnet.com,Female,199.72.117.146,Qinghu,China,+86-116-627-0397
136,Xena,Shaddock,xshaddock3r@imgur.com,Female,180.70.12.213,Tangkeng,China,+86-517-314-1002
137,Constantine,Pigrome,cpigrome3s@answers.com,Male,77.124.132.245,Peso da Régua,Portugal,+351-885-946-3878
138,Tyne,Phaup,tphaup3t@epa.gov,Female,96.156.32.208,Rambatan,Indonesia,+62-626-494-1260
139,Louie,Goodday,lgoodday3u@i2i.jp,Male,135.141.247.136,Anderstorp,Sweden,+46-970-638-4252
140,Jerad,Croot,jcroot3v@yandex.ru,Male,179.203.19.150,Mnich,Poland,+48-237-711-6162
141,Muire,Defau,mdefau3w@wix.com,Female,195.248.189.247,Khōshī,Afghanistan,+93-684-965-9589
142,Corenda,Paulusch,cpaulusch3x@ibm.com,Female,40.2.164.153,Aasiaat,Greenland,+299-638-273-5291
143,Leslie,Chave,lchave3y@weibo.com,Male,146.173.248.148,København,Denmark,+45-789-324-7956
144,Norry,Tyrer,ntyrer3z@cpanel.net,Female,96.138.246.245,La Garenne-Colombes,France,+33-208-848-7795
145,Jackson,Brikner,jbrikner40@icq.com,Male,83.215.178.129,Wurno,Nigeria,+234-816-564-0862
146,Barbi,Bellow,bbellow41@altervista.org,Female,250.233.251.183,Siepraw,Poland,+48-137-304-5776
147,Anallise,Gallier,agallier42@hexun.com,Female,67.26.76.159,Talun,Indonesia,+62-250-935-7285
148,Kate,Baxstar,kbaxstar43@latimes.com,Female,225.53.250.14,Poiares,Portugal,+351-610-409-5401
149,Merwyn,McGuggy,mmcguggy44@cbc.ca,Male,201.108.90.208,Trzemeszno,Poland,+48-983-414-0426
150,Berni,Purchase,bpurchase45@ucoz.ru,Female,86.220.246.212,Slatina,Croatia,+385-315-391-7691
151,Anya,Zucker,azucker46@netvibes.com,Female,7.80.95.142,Biecz,Poland,+48-729-733-7619
152,Donia,Trickett,dtrickett47@usa.gov,Female,25.151.108.83,Germiston,South Africa,+27-996-754-8761
153,Phyllys,Pendlington,ppendlington48@marketwatch.com,Female,107.194.108.35,Somié,Cameroon,+237-738-469-9038
154,Sebastien,Coghlin,scoghlin49@newyorker.com,Male,116.139.81.19,Minami-rinkan,Japan,+81-172-423-9841
155,Gordie,Kelling,gkelling4a@rambler.ru,Male,183.162.220.36,Yuelai,China,+86-796-464-2540
156,Tomasine,Itzik,titzik4b@ameblo.jp,Female,17.221.26.216,Wosai,China,+86-144-987-2164
157,Edward,Stockow,estockow4c@clickbank.net,Male,95.112.186.197,Baruta,Venezuela,+58-718-749-1636
158,Dara,Ianni,dianni4d@sina.com.cn,Female,97.216.36.133,Shunling,China,+86-412-204-6516
159,Clyde,Setford,csetford4e@globo.com,Male,191.121.45.150,Gaoqiao,China,+86-625-625-5198
160,Tynan,Faich,tfaich4f@usda.gov,Male,194.48.130.235,Las Flores,Mexico,+52-387-384-4328
161,Pancho,Malicki,pmalicki4g@utexas.edu,Male,107.176.143.122,Bayuin,Philippines,+63-119-397-4678
162,Alex,Yarnton,ayarnton4h@google.co.jp,Male,156.17.220.27,Vénissieux,France,+33-405-478-8099
163,Koral,Thorald,kthorald4i@comcast.net,Female,19.82.137.81,Tsiatsan,Armenia,+374-501-249-7822
164,Abner,Shacklady,ashacklady4j@godaddy.com,Male,251.130.217.70,Tancheng,China,+86-100-711-6012
165,Alanson,Van der Kruys,avanderkruys4k@techcrunch.com,Male,123.44.239.5,Krajan Puru,Indonesia,+62-332-895-3650
166,Noak,Tourne,ntourne4l@quantcast.com,Male,123.113.227.81,Kuhmalahti,Finland,+358-325-129-6774
167,Lexy,Beaglehole,lbeaglehole4m@vinaora.com,Female,172.250.143.139,Huangtang,China,+86-215-421-9016
168,Angelle,Elland,aelland4n@lulu.com,Female,31.120.230.177,San Pedro One,Philippines,+63-969-676-8408
169,Wain,O'Carmody,wocarmody4o@rakuten.co.jp,Male,6.149.107.31,Trollhättan,Sweden,+46-766-791-4342
170,Reube,Ruff,rruff4p@ameblo.jp,Male,227.25.193.202,Banjar Pasekan,Indonesia,+62-611-847-0878
171,Lyndsie,Moreby,lmoreby4q@oracle.com,Female,241.233.222.174,Dalmacio Vélez Sársfield,Argentina,+54-891-404-3315
172,Avrom,Kivlehan,akivlehan4r@toplist.cz,Male,236.238.74.132,Kamennogorsk,Russia,+7-490-143-5183
173,Ric,Shevell,rshevell4s@netvibes.com,Male,157.23.9.101,Melipilla,Chile,+56-629-600-5628
174,Langsdon,Tomasz,ltomasz4t@un.org,Male,178.251.33.5,Sigaboy,Philippines,+63-133-405-8084
175,Wrennie,Dagger,wdagger4u@state.tx.us,Female,219.167.203.216,Strawczyn,Poland,+48-842-794-6464
176,Jory,Goodere,jgoodere4v@blogtalkradio.com,Male,97.198.28.75,Thành Phố Hà Giang,Vietnam,+84-860-324-4227
177,Moishe,de Grey,mdegrey4w@mashable.com,Male,156.64.21.60,Haikou,China,+86-337-692-6244
178,Chicky,Davenell,cdavenell4x@digg.com,Male,56.67.56.223,Butel,Macedonia,+389-222-646-9456
179,Howie,Melia,hmelia4y@myspace.com,Male,97.119.218.18,Añatuya,Argentina,+54-797-559-0961
180,Cirilo,Fairhall,cfairhall4z@engadget.com,Male,56.92.54.158,Xiaomenjia,China,+86-857-935-6107
181,Taddeusz,Clarkin,tclarkin50@loc.gov,Male,69.110.33.8,Huaraz,Peru,+51-209-537-7254
182,Mackenzie,Peto,mpeto51@liveinternet.ru,Male,68.115.11.130,Shchelkovo,Russia,+7-100-585-9426
183,Lainey,D'Alessandro,ldalessandro52@cafepress.com,Female,253.232.241.110,Tha Bo,Thailand,+66-851-665-7838
184,Eugene,Borgnol,eborgnol53@arizona.edu,Male,80.92.249.161,El Kef,Tunisia,+216-570-599-0766
185,Roseline,Penzer,rpenzer54@slideshare.net,Female,119.52.45.72,Vila Nova,Portugal,+351-803-589-8238
186,Bekki,Jankiewicz,bjankiewicz55@a8.net,Female,146.154.143.5,Vreshtas,Albania,+355-165-623-0764
187,Perry,Korous,pkorous56@narod.ru,Male,103.8.122.178,Batuna Satu,Indonesia,+62-745-157-2883
188,Husein,Fursey,hfursey57@redcross.org,Male,195.36.168.102,Shazhenxi,China,+86-606-696-5162
189,Florette,Coldham,fcoldham58@storify.com,Female,67.66.185.145,Níkaia,Greece,+30-726-671-7761
190,Linc,Jerok,ljerok59@chicagotribune.com,Male,238.154.189.232,Kaznějov,Czech Republic,+420-411-234-0432
191,Ki,Flockhart,kflockhart5a@studiopress.com,Female,77.225.249.208,Tindog,Philippines,+63-288-882-7996
192,Lanni,Tufts,ltufts5b@sbwire.com,Female,245.99.46.208,Lazaro Cardenas,Mexico,+52-979-122-5969
193,Birdie,Hadlow,bhadlow5c@so-net.ne.jp,Female,58.207.57.72,Raub,Malaysia,+60-848-662-2414
194,Del,Kurdani,dkurdani5d@washington.edu,Male,19.227.168.34,Tawangrejo,Indonesia,+62-953-968-1186
195,Lezley,O'Connolly,loconnolly5e@hc360.com,Male,140.243.58.158,Paarl,South Africa,+27-594-540-1273
196,Irwin,Gravener,igravener5f@deviantart.com,Male,204.117.23.80,Jiuhua,China,+86-110-966-0382
197,Matthew,Toffel,mtoffel5g@opera.com,Male,150.140.59.206,Guayabal,Colombia,+57-988-952-3927
198,Nelle,Cromar,ncromar5h@geocities.com,Female,81.77.142.99,Isdalstø,Norway,+47-436-169-0258
199,Chandler,Didball,cdidball5i@mapy.cz,Male,16.64.110.155,Antony,France,+33-853-425-4253
200,Morgan,Cottu,mcottu5j@blogspot.com,Male,79.41.191.214,Bukomansimbi,Uganda,+256-964-259-1823
201,John,Fisher,mrjohnf@yahoo.com,Male,69.69.69.69,Keswick,UK,+44-1923-453132