{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"SALE_NUM","type":"number","width":6,"decimals":0},{"name":"ABBREV","type":"character","width":15},{"name":"SHOW_DATE","type":"date","width":8},{"name":"SHOW_TIME","type":"character","width":8},{"name":"CLERK","type":"character","width":7},{"name":"CAT1_TIX","type":"number","width":3,"decimals":0},{"name":"CAT2_TIX","type":"number","width":3,"decimals":0},{"name":"CAT3_TIX","type":"number","width":3,"decimals":0},{"name":"CAT4_TIX","type":"number","width":3,"decimals":0},{"name":"CAT5_TIX","type":"number","width":3,"decimals":0},{"name":"CAT6_TIX","type":"number","width":3,"decimals":0},{"name":"SPEC_TIX","type":"number","width":3,"decimals":0},{"name":"SPEC_PRICE","type":"number","width":7,"decimals":2},{"name":"COMP_TIX","type":"number","width":3,"decimals":0},{"name":"TOTAL_TIX","type":"number","width":3,"decimals":0},{"name":"TOTAL_SALE","type":"number","width":8,"decimals":2},{"name":"LAST","type":"character","width":15},{"name":"FIRST","type":"character","width":25},{"name":"PHONE","type":"character","width":25},{"name":"CARD_NUMBR","type":"character","width":20},{"name":"EXP","type":"character","width":5},{"name":"COMPANY","type":"character","width":40},{"name":"ADDRESS","type":"character","width":40},{"name":"CITY","type":"character","width":30},{"name":"STATE","type":"character","width":2},{"name":"ZIP","type":"character","width":5},{"name":"ADD_ZIP","type":"character","width":4},{"name":"REMARKS","type":"character","width":50},{"name":"TODAY_DATE","type":"date","width":8},{"name":"TODAY_TIME","type":"character","width":5},{"name":"CASH","type":"number","width":8,"decimals":2},{"name":"CHECK","type":"number","width":8,"decimals":2},{"name":"CARD","type":"number","width":8,"decimals":2},{"name":"CAT1_PRICE","type":"number","width":6,"decimals":2},{"name":"CAT2_PRICE","type":"number","width":6,"decimals":2},{"name":"CAT3_PRICE","type":"number","width":6,"decimals":2},{"name":"CAT4_PRICE","type":"number","width":6,"decimals":2},{"name":"CAT5_PRICE","type":"number","width":6,"decimals":2},{"name":"CAT6_PRICE","type":"number","width":6,"decimals":2},{"name":"PAID","type":"logical","width":1},{"name":"PAY_DATE","type":"date","width":8},{"name":"CHECK_NUM","type":"character","width":5},{"name":"PUBCODE","type":"character","width":4}],"n_rows":20,"rows_kept":20,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
[34,"THE ONLY WAY","1992-03-09","8:00","Diane",1,1,0,0,0,0,0,0.00,0,2,22.00,"Smith","John","408-655-1234",null,null,"Smith Sonian Sound Systems","126 Harbor Blvd.","Pacific Grove","CA","93950","1234","CENTER B-8 B-9","1992-03-08","11:18",22.50,null,0.00,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[35,"SEASON TICKETS","1992-08-18","8:00","Diane",1,1,1,0,0,0,0,0.00,0,3,160.00,"Justin","Roberts","987-1478",null,null,"Sunshine Solar Panels","852 Maplewood Way","Pacific Grove","CA","93950","1234","a regular customer MAIL","1992-03-08","11:39",null,163.25,null,45.00,40.00,75.00,0.00,0.00,0.00,null,null,null,null]
[36,"SEASON TICKETS","1992-08-18","8:00","Diane",2,0,0,0,0,0,0,0.00,0,2,90.00,"Smith","Christine","443-4568",null,null,"Good Health Organic Vegetable Supply","19 West 4th Street","Salinas","CA","93955",null,"MAIL","1992-03-08","12:09",null,null,95.00,45.00,40.00,75.00,0.00,0.00,0.00,null,null,null,null]
[38,"THE ONLY WAY","1992-03-09","8:00","Diane",0,2,0,0,0,0,0,0.00,0,2,20.00,"Smith","Christine","443-4568",null,null,"Good Health Organic Vegetable Supply","19 West 4th Street","Salinas","CA","93955",null,"CENTER B-10 B-11 MAIL","1992-03-08","12:21",22.50,null,null,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[42,"THE ONLY WAY","1992-03-09","8:00","Diane",1,1,0,0,0,0,0,0.00,0,2,22.00,"Myers","Sandra","604-455-6565","4555-2222-3333-6666","10/92",null,"3 Lake Drive","Saratoga","CA","95555",null,"CENTER C-8 C-9","1992-03-08","11:19",null,null,23.00,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[43,"SEASON TICKETS","1992-08-19","8:00","Diane",1,0,0,0,0,0,0,0.00,0,1,45.00,"Thompson","Gary","455-6565",null,null,null,"23 Merry Blvd.","Johnstown","CA","92225",null,"1 General Season","1992-03-08","11:21",null,null,null,45.00,40.00,75.00,0.00,0.00,0.00,null,null,null,null]
[45,"THE ONLY WAY","1992-03-10","8:00 PM","Diane",2,0,0,0,0,0,0,0.00,0,2,20.00,"Stevenson","Catherine","449-5112",null,null,null,"264 Maryal Drive","Salinas","CA","93955",null,"2 General admissions","1992-03-08","11:25",null,20.50,null,10.00,8.00,12.00,0.00,0.00,5.00,null,null,null,null]
[46,"THE ONLY WAY","1992-03-09","8:00","Diane",1,0,1,0,0,0,0,0.00,0,2,27.00,"Stevenson","Catherine","449-5112",null,null,null,"264 Maryal Drive","Salinas","CA","93955",null,"CENTER B-18 B-19","1992-03-08","11:25",null,27.50,null,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[47,"THE ONLY WAY","1992-03-09","8:00","Diane",1,0,1,0,0,0,0,0.00,0,2,27.00,"Stevenson","Catherine","449-5112",null,null,null,"264 Maryal Drive","Salinas","CA","93955",null,"CENTER C-18 C-19","1992-03-08","11:28",null,27.50,null,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[49,"THE ONLY WAY","1992-03-09","8:00","Diane",null,null,null,null,null,null,null,null,null,0,0.00,null,null,null,null,null,null,null,null,null,null,null,"Sale cancelled","1992-03-08","11:33",null,null,null,null,0.00,0.00,0.00,0.00,0.00,null,null,null,null]
[48,"THE ONLY WAY","1992-03-09","8:00","George",2,0,0,null,null,null,null,null,null,2,24.00,"Richardson","Louise","258-9514",null,null,null,"258 Laurel Drive","Monterey","CA","93940","1234",null,"1992-03-08","11:33",{"$raw":"."},12.00,{"$raw":"."},12.00,0.00,0.00,0.00,0.00,0.00,null,null,null,null]
[50,"THE ONLY WAY","1992-03-09","8:00","Diane",null,null,null,null,null,null,null,null,null,0,0.00,null,null,null,null,null,null,null,null,null,null,null,"Sale cancelled","1992-03-08","11:33",null,null,null,null,0.00,0.00,0.00,0.00,0.00,null,null,null,null]
[51,"THE ONLY WAY","1992-03-10","8:00 PM","Diane",1,1,0,0,0,0,0,0.00,0,2,18.00,"Cook","Simon",null,null,null,null,"123 Third Avenue","Seaside","CA","93955",null,"MAIL","1992-03-08","11:45",null,19.50,null,10.00,8.00,12.00,0.00,0.00,5.00,null,null,null,null]
[52,"SEASON TICKETS","1992-08-19","8:00","Bruce",2,3,0,0,0,0,0,0.00,0,5,210.00,"Thompson","James and Mary","800-488-2364",null,null,"Multi-Mega Inc.","123 Shady Lane","Salinas","CA","93901",null,"regular customers","1992-03-08","15:29",null,213.75,null,45.00,40.00,75.00,0.00,0.00,0.00,null,null,null,null]
[53,"THE ONLY WAY","1992-03-09","8:00","George",3,3,0,0,0,0,14,7.50,0,20,171.00,"Pendergrass","Roger","449-5088",null,null,null,"12979 Arthur St.","Salinas","CA","93955",null,"CENTER  D-10 to E-23  special deal for this group","1992-03-08","15:35",null,176.00,null,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[54,"THE ONLY WAY","1992-03-09","8:00","George",4,5,9,0,0,4,0,0.00,0,22,253.00,"Donatoni","Joy","449-2757",null,null,null,"120 Iris Drive","Carmel","CA","93921",null,"CENTER  B-12 to D-23 MAIL","1992-03-08","15:37",null,null,255.00,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[55,"THE ONLY WAY","1992-03-09","8:00","George",2,2,2,0,0,3,0,0.00,0,9,89.00,"Holland","John","443-8202",null,null,null,"1094 Polk Street","Carmel","CA","93921",null,"CENTER  E-10 to D-7  hold at will call","1992-03-08","15:38",null,null,null,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[56,"THE ONLY WAY","1992-03-09","8:00","George",0,0,1,0,0,9,0,0.00,0,10,60.00,"Kelley","Donna","443-1874",null,null,null,"2394 A North Main","Carmel","CA","93921",null,"CENTER  E-15 to G-15  student rush","1992-03-08","15:45",null,62.50,null,12.00,10.00,15.00,0.00,0.00,5.00,null,null,null,null]
[57,"THE ONLY WAY","1992-03-10","8:00 PM","George",3,2,1,0,0,0,0,0.00,0,6,58.00,"Bush","George","123-4567","1234-5678-9012-3456","05/92",null,"1600 Pennsylvania Ave","Washington","DC","10000",null,"MAIL his tix","1992-03-08","15:55",null,null,62.00,10.00,8.00,12.00,0.00,0.00,5.00,null,null,null,null]
[58,"THE ONLY WAY","1992-03-09","8:00","Fdgh",null,null,null,null,null,null,null,null,null,0,0.00,null,null,null,null,null,null,null,null,null,null,null,null,"1992-03-08","18:03",null,null,null,null,null,null,null,null,null,null,null,null,null]