Nested json select, PostgreSQL

Nested json select

Language: Layout:

--PostgreSQL 9.6
--'\\' is a delimiter
create table example (
   ID Serial CONSTRAINT pk_id_cars PRIMARY KEY,
     jsonTest jsonb NOT NULL, 
 create_at date
    
    );
insert into example( jsonTest,create_at) values 
('{"vehicle":[{"vehicle_type":"Van","car_make":"Suzuki","car_model":"XL-7","quantity":9,"seats":3,"price_hour":49,"price_day":187,"color":["White","Orange","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Dodge","car_model":"Caravan","quantity":7,"seats":8,"price_hour":37,"price_day":232,"color":["Pink","White","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"GMC","car_model":"Yukon XL 2500","quantity":5,"seats":2,"price_hour":37,"price_day":211,"color":["Silver","Pink","Indigo","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mazda","car_model":"Millenia","quantity":8,"seats":8,"price_hour":27,"price_day":186,"color":["Orange","Silver","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Audi","car_model":"S4","quantity":6,"seats":5,"price_hour":39,"price_day":262,"color":["Blue","White","Grey","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Toyota","car_model":"Echo","quantity":5,"seats":3,"price_hour":33,"price_day":223,"color":["Grey","Silver","Pink","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercury","car_model":"Topaz","quantity":9,"seats":4,"price_hour":33,"price_day":162,"color":["Purple","Indigo","Black","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Isuzu","car_model":"Trooper","quantity":9,"seats":5,"price_hour":16,"price_day":284,"color":["White","Silver","Purple","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Porsche","car_model":"Boxster","quantity":6,"seats":2,"price_hour":16,"price_day":198,"color":["Pink","Blue","Grey","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mitsubishi","car_model":"Pajero","quantity":6,"seats":4,"price_hour":32,"price_day":186,"color":["Purple","Orange","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mazda","car_model":"B-Series","quantity":9,"seats":7,"price_hour":32,"price_day":211,"color":["Purple","Silver","Indigo","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Lexus","car_model":"ES","quantity":8,"seats":8,"price_hour":25,"price_day":275,"color":["Pink","Indigo","Orange","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Lotus","car_model":"Esprit","quantity":6,"seats":2,"price_hour":46,"price_day":238,"color":["Grey","Black","Silver","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Hyundai","car_model":"Accent","quantity":6,"seats":4,"price_hour":17,"price_day":273,"color":["Orange","Silver","Purple","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ford","car_model":"Escort","quantity":5,"seats":7,"price_hour":28,"price_day":157,"color":["Pink","Indigo","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Plymouth","car_model":"Colt","quantity":6,"seats":2,"price_hour":29,"price_day":226,"color":["Orange","Grey","Silver","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Infiniti","car_model":"FX","quantity":7,"seats":8,"price_hour":29,"price_day":242,"color":["Pink","Blue","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Porsche","car_model":"928","quantity":9,"seats":2,"price_hour":28,"price_day":268,"color":["Grey","Black","Orange","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Cadillac","car_model":"Escalade EXT","quantity":9,"seats":7,"price_hour":50,"price_day":151,"color":["Blue","Pink","Grey","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Chevrolet","car_model":"Suburban 1500","quantity":5,"seats":2,"price_hour":48,"price_day":281,"color":["Indigo","Purple","Grey","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Buick","car_model":"Century","quantity":8,"seats":7,"price_hour":34,"price_day":251,"color":["Silver","Orange","Pink","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mercedes-Benz","car_model":"E-Class","quantity":8,"seats":4,"price_hour":49,"price_day":212,"color":["Purple","White","Pink","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Ram 2500","quantity":9,"seats":8,"price_hour":47,"price_day":261,"color":["Black","Purple","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"MINI","car_model":"MINI","quantity":9,"seats":7,"price_hour":39,"price_day":188,"color":["Purple","Black","White","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Ford","car_model":"Econoline E350","quantity":6,"seats":5,"price_hour":32,"price_day":163,"color":["Silver","Blue","Black","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Hyundai","car_model":"Sonata","quantity":6,"seats":2,"price_hour":49,"price_day":275,"color":["Orange","Blue","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Nissan","car_model":"Pathfinder","quantity":9,"seats":7,"price_hour":33,"price_day":294,"color":["Silver","Purple","Orange","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Nissan","car_model":"Maxima","quantity":8,"seats":2,"price_hour":44,"price_day":252,"color":["Grey","Pink","Silver","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mitsubishi","car_model":"Lancer Evolution","quantity":8,"seats":5,"price_hour":17,"price_day":182,"color":["Silver","White","Pink","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Thunderbird","quantity":7,"seats":7,"price_hour":25,"price_day":280,"color":["Indigo","Blue","Pink","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ferrari","car_model":"California","quantity":7,"seats":6,"price_hour":21,"price_day":238,"color":["White","Grey","Silver","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Acura","car_model":"CL","quantity":5,"seats":8,"price_hour":33,"price_day":180,"color":["Black","Silver","Pink","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Toyota","car_model":"Prius","quantity":5,"seats":2,"price_hour":49,"price_day":297,"color":["White","Purple","Pink","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Lotus","car_model":"Esprit","quantity":9,"seats":4,"price_hour":47,"price_day":254,"color":["Pink","Silver","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Dodge","car_model":"Avenger","quantity":6,"seats":5,"price_hour":39,"price_day":268,"color":["White","Black","Orange","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Cadillac","car_model":"CTS-V","quantity":5,"seats":6,"price_hour":18,"price_day":289,"color":["Black","Purple","Blue","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Pontiac","car_model":"1000","quantity":9,"seats":8,"price_hour":45,"price_day":172,"color":["Indigo","Grey","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mazda","car_model":"B-Series","quantity":6,"seats":6,"price_hour":15,"price_day":167,"color":["Blue","Indigo","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"BMW","car_model":"545","quantity":7,"seats":2,"price_hour":47,"price_day":265,"color":["Orange","White","Blue","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercury","car_model":"Cougar","quantity":5,"seats":8,"price_hour":21,"price_day":179,"color":["Grey","Orange","Purple","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Dodge","car_model":"Ram Van 2500","quantity":8,"seats":7,"price_hour":46,"price_day":186,"color":["Orange","Blue","Black","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Kia","car_model":"Rondo","quantity":6,"seats":5,"price_hour":19,"price_day":248,"color":["Pink","Indigo","Purple","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Acura","car_model":"TL","quantity":8,"seats":6,"price_hour":42,"price_day":177,"color":["Indigo","White","Grey","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mercedes-Benz","car_model":"600SEC","quantity":8,"seats":8,"price_hour":43,"price_day":145,"color":["Silver","White","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Cadillac","car_model":"SRX","quantity":9,"seats":3,"price_hour":30,"price_day":161,"color":["Purple","Orange","Black","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Subaru","car_model":"Loyale","quantity":7,"seats":3,"price_hour":50,"price_day":223,"color":["White","Silver","Pink","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Dodge","car_model":"Dakota Club","quantity":5,"seats":4,"price_hour":49,"price_day":156,"color":["Orange","Grey","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"GMC","car_model":"Savana 1500","quantity":6,"seats":3,"price_hour":35,"price_day":179,"color":["Indigo","Purple","Black","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Jeep","car_model":"Compass","quantity":8,"seats":5,"price_hour":29,"price_day":237,"color":["Indigo","Grey","Pink","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Volvo","car_model":"V50","quantity":9,"seats":4,"price_hour":45,"price_day":289,"color":["Silver","Black","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Cadillac","car_model":"Seville","quantity":7,"seats":8,"price_hour":22,"price_day":295,"color":["Black","Purple","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Pontiac","car_model":"Fiero","quantity":9,"seats":7,"price_hour":46,"price_day":152,"color":["Blue","Orange","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Saab","car_model":"9000","quantity":5,"seats":8,"price_hour":49,"price_day":238,"color":["Black","Pink","White","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Toyota","car_model":"Corolla","quantity":7,"seats":2,"price_hour":27,"price_day":236,"color":["Purple","White","Grey","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Colt","quantity":7,"seats":6,"price_hour":39,"price_day":207,"color":["Pink","Black","Silver","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Cadillac","car_model":"CTS-V","quantity":8,"seats":8,"price_hour":40,"price_day":205,"color":["Blue","Black","Purple","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Oldsmobile","car_model":"88","quantity":9,"seats":4,"price_hour":18,"price_day":140,"color":["Grey","Silver","Pink","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"GMC","car_model":"Sierra Hybrid","quantity":7,"seats":5,"price_hour":48,"price_day":246,"color":["Grey","Orange","Indigo","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Toyota","car_model":"RAV4","quantity":7,"seats":6,"price_hour":43,"price_day":143,"color":["White","Pink","Silver","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mitsubishi","car_model":"Montero","quantity":6,"seats":6,"price_hour":17,"price_day":282,"color":["Orange","White","Purple","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Plymouth","car_model":"Voyager","quantity":6,"seats":3,"price_hour":20,"price_day":198,"color":["Purple","White","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Infiniti","car_model":"FX","quantity":7,"seats":4,"price_hour":22,"price_day":242,"color":["Purple","White","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mitsubishi","car_model":"Lancer","quantity":8,"seats":2,"price_hour":36,"price_day":252,"color":["Black","Orange","Grey","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Ford","car_model":"Thunderbird","quantity":5,"seats":7,"price_hour":22,"price_day":282,"color":["Purple","Black","Blue","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"BMW","car_model":"3 Series","quantity":8,"seats":3,"price_hour":32,"price_day":180,"color":["Blue","Purple","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Oldsmobile","car_model":"Intrigue","quantity":6,"seats":2,"price_hour":25,"price_day":237,"color":["White","Silver","Grey","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Dodge","car_model":"Durango","quantity":7,"seats":3,"price_hour":44,"price_day":225,"color":["Blue","Pink","Orange","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"GMC","car_model":"Envoy","quantity":7,"seats":3,"price_hour":21,"price_day":192,"color":["White","Orange","Blue","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Spyker","car_model":"C8 Spyder","quantity":9,"seats":7,"price_hour":41,"price_day":253,"color":["Orange","Black","Pink","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Chevrolet","car_model":"Camaro","quantity":6,"seats":4,"price_hour":25,"price_day":196,"color":["Indigo","Orange","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Oldsmobile","car_model":"Aurora","quantity":8,"seats":5,"price_hour":22,"price_day":277,"color":["Silver","Orange","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Mazda","car_model":"Tribute","quantity":5,"seats":2,"price_hour":50,"price_day":257,"color":["Purple","Grey","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Audi","car_model":"Q5","quantity":9,"seats":6,"price_hour":17,"price_day":249,"color":["Purple","Blue","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Suzuki","car_model":"Kizashi","quantity":8,"seats":4,"price_hour":38,"price_day":215,"color":["Blue","Purple","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Ram 2500","quantity":8,"seats":3,"price_hour":17,"price_day":284,"color":["Indigo","Silver","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Maserati","car_model":"GranTurismo","quantity":8,"seats":5,"price_hour":50,"price_day":258,"color":["White","Blue","Silver","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Volkswagen","car_model":"Jetta","quantity":5,"seats":3,"price_hour":29,"price_day":212,"color":["Pink","Indigo","Purple","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mazda","car_model":"Miata MX-5","quantity":9,"seats":7,"price_hour":36,"price_day":276,"color":["Silver","Grey","Pink","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Buick","car_model":"Somerset","quantity":7,"seats":7,"price_hour":37,"price_day":149,"color":["Silver","White","Grey","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Saab","car_model":"9-5","quantity":7,"seats":6,"price_hour":16,"price_day":228,"color":["Blue","Pink","Grey","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Toyota","car_model":"Previa","quantity":9,"seats":6,"price_hour":24,"price_day":253,"color":["Blue","Purple","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mitsubishi","car_model":"Expo","quantity":9,"seats":8,"price_hour":31,"price_day":143,"color":["Black","Indigo","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Ram 1500","quantity":5,"seats":6,"price_hour":29,"price_day":163,"color":["Purple","White","Grey","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Infiniti","car_model":"I","quantity":6,"seats":4,"price_hour":42,"price_day":199,"color":["Indigo","Black","Purple","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mitsubishi","car_model":"Lancer Evolution","quantity":6,"seats":8,"price_hour":37,"price_day":230,"color":["Indigo","Orange","White","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Toyota","car_model":"Celica","quantity":7,"seats":8,"price_hour":48,"price_day":234,"color":["Indigo","Orange","Silver","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Hyundai","car_model":"Tucson","quantity":8,"seats":6,"price_hour":27,"price_day":256,"color":["Blue","Black","Pink","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Fillmore","car_model":"Fillmore","quantity":9,"seats":6,"price_hour":39,"price_day":253,"color":["Blue","Grey","Black","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Lexus","car_model":"IS","quantity":9,"seats":5,"price_hour":37,"price_day":204,"color":["Pink","Orange","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Pontiac","car_model":"Firebird Formula","quantity":5,"seats":8,"price_hour":35,"price_day":245,"color":["Indigo","Orange","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Buick","car_model":"Park Avenue","quantity":6,"seats":5,"price_hour":33,"price_day":176,"color":["Blue","Grey","Pink","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Chevrolet","car_model":"Corvette","quantity":6,"seats":5,"price_hour":30,"price_day":271,"color":["Pink","Grey","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"BMW","car_model":"M","quantity":7,"seats":7,"price_hour":18,"price_day":224,"color":["Orange","Blue","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Volvo","car_model":"S80","quantity":7,"seats":7,"price_hour":38,"price_day":235,"color":["Black","Orange","Silver","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Honda","car_model":"CR-V","quantity":5,"seats":2,"price_hour":41,"price_day":142,"color":["Black","Pink","Grey","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Aspire","quantity":6,"seats":7,"price_hour":48,"price_day":237,"color":["Blue","Orange","Silver","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Club Wagon","quantity":7,"seats":5,"price_hour":23,"price_day":247,"color":["White","Blue","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Subaru","car_model":"Legacy","quantity":9,"seats":5,"price_hour":21,"price_day":256,"color":["Pink","Black","White","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Volkswagen","car_model":"Passat","quantity":5,"seats":8,"price_hour":25,"price_day":193,"color":["Indigo","Grey","Blue","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Aston Martin","car_model":"DBS","quantity":8,"seats":8,"price_hour":34,"price_day":140,"color":["Blue","Pink","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercedes-Benz","car_model":"400SEL","quantity":7,"seats":8,"price_hour":45,"price_day":153,"color":["Black","Pink","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Buick","car_model":"Coachbuilder","quantity":6,"seats":2,"price_hour":21,"price_day":270,"color":["Indigo","Grey","Silver","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Chevrolet","car_model":"Suburban","quantity":5,"seats":5,"price_hour":34,"price_day":229,"color":["Purple","Blue","Black","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Buick","car_model":"Park Avenue","quantity":6,"seats":8,"price_hour":21,"price_day":209,"color":["Black","Pink","White","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Porsche","car_model":"928","quantity":8,"seats":6,"price_hour":35,"price_day":152,"color":["Blue","Purple","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Hyundai","car_model":"Elantra","quantity":6,"seats":6,"price_hour":24,"price_day":233,"color":["Orange","Silver","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Buick","car_model":"Century","quantity":6,"seats":8,"price_hour":31,"price_day":297,"color":["Purple","Blue","Grey","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Isuzu","car_model":"Ascender","quantity":6,"seats":8,"price_hour":44,"price_day":279,"color":["Grey","Blue","Pink","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Lotus","car_model":"Esprit","quantity":7,"seats":7,"price_hour":16,"price_day":147,"color":["Purple","Pink","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Infiniti","car_model":"QX","quantity":6,"seats":3,"price_hour":25,"price_day":162,"color":["White","Silver","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Toyota","car_model":"Highlander","quantity":5,"seats":5,"price_hour":47,"price_day":284,"color":["Silver","Indigo","Purple","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Dodge","car_model":"Durango","quantity":5,"seats":2,"price_hour":24,"price_day":298,"color":["White","Indigo","Orange","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mercedes-Benz","car_model":"S-Class","quantity":6,"seats":7,"price_hour":48,"price_day":271,"color":["Orange","Indigo","Grey","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Cadillac","car_model":"Fleetwood","quantity":6,"seats":6,"price_hour":30,"price_day":293,"color":["White","Orange","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Volkswagen","car_model":"Corrado","quantity":8,"seats":8,"price_hour":35,"price_day":213,"color":["Grey","Orange","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Chevrolet","car_model":"Sportvan G30","quantity":6,"seats":2,"price_hour":16,"price_day":144,"color":["Black","Pink","White","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Chevrolet","car_model":"Aveo","quantity":9,"seats":8,"price_hour":31,"price_day":244,"color":["Indigo","Blue","Black","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"GMC","car_model":"1500","quantity":6,"seats":6,"price_hour":18,"price_day":206,"color":["Black","Pink","Orange","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Maserati","car_model":"Quattroporte","quantity":6,"seats":3,"price_hour":19,"price_day":186,"color":["Silver","Blue","Indigo","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Ford","car_model":"Escort","quantity":7,"seats":3,"price_hour":43,"price_day":211,"color":["Blue","Purple","Pink","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Lexus","car_model":"ES","quantity":7,"seats":7,"price_hour":18,"price_day":145,"color":["White","Purple","Orange","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Chevrolet","car_model":"Impala","quantity":7,"seats":3,"price_hour":32,"price_day":212,"color":["Black","Purple","Indigo","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Dodge","car_model":"D250","quantity":5,"seats":2,"price_hour":46,"price_day":257,"color":["White","Purple","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Jeep","car_model":"Comanche","quantity":6,"seats":2,"price_hour":41,"price_day":252,"color":["Grey","Black","Silver","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Pontiac","car_model":"Sunbird","quantity":5,"seats":5,"price_hour":26,"price_day":169,"color":["Black","Grey","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Nissan","car_model":"GT-R","quantity":5,"seats":5,"price_hour":33,"price_day":232,"color":["White","Indigo","Black","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ford","car_model":"Explorer","quantity":5,"seats":2,"price_hour":35,"price_day":149,"color":["Pink","Orange","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Acura","car_model":"MDX","quantity":6,"seats":4,"price_hour":50,"price_day":221,"color":["Purple","Grey","Pink","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Land Rover","car_model":"Defender Ice Edition","quantity":8,"seats":4,"price_hour":48,"price_day":183,"color":["Silver","Purple","Pink","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ford","car_model":"Focus","quantity":7,"seats":6,"price_hour":15,"price_day":195,"color":["Pink","Silver","Orange","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Dodge","car_model":"Dakota Club","quantity":9,"seats":6,"price_hour":19,"price_day":221,"color":["Blue","Indigo","Pink","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Lexus","car_model":"IS-F","quantity":7,"seats":3,"price_hour":37,"price_day":170,"color":["Pink","Silver","Indigo","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Ranger","quantity":5,"seats":4,"price_hour":43,"price_day":290,"color":["Black","Orange","Grey","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Honda","car_model":"Accord","quantity":9,"seats":7,"price_hour":25,"price_day":143,"color":["Pink","Purple","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Subaru","car_model":"SVX","quantity":5,"seats":4,"price_hour":22,"price_day":167,"color":["Orange","Black","Blue","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercury","car_model":"Marquis","quantity":8,"seats":8,"price_hour":34,"price_day":185,"color":["Pink","Purple","Blue","White"]}]}','2020-08-04');
select * from example;
-- see json online in https://jsoneditoronline.org/
select * from example
where example.jsonTest->>'vehicle' ~ 'color"\s*:\s*"?.*?Blue.*"?';

select * from example
where example.jsonTest->>'vehicle' ~ 'vehicle_type"\s*:\s*"?.*?SUV.*"?';


absolute service time: 0,86 sec

	id	jsontest	create_at
1	1	{"vehicle": [{"color": ["White", "Orange", "Blue", "Indigo"], "seats": 3, "car_make": "Suzuki", "quantity": 9, "car_model": "XL-7", "price_day": 187, "price_hour": 49, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
2	2	{"vehicle": [{"color": ["Pink", "White", "Orange", "Grey"], "seats": 8, "car_make": "Dodge", "quantity": 7, "car_model": "Caravan", "price_day": 232, "price_hour": 37, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
3	3	{"vehicle": [{"color": ["Silver", "Pink", "Indigo", "Black"], "seats": 2, "car_make": "GMC", "quantity": 5, "car_model": "Yukon XL 2500", "price_day": 211, "price_hour": 37, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
4	4	{"vehicle": [{"color": ["Orange", "Silver", "Black", "White"], "seats": 8, "car_make": "Mazda", "quantity": 8, "car_model": "Millenia", "price_day": 186, "price_hour": 27, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
5	5	{"vehicle": [{"color": ["Blue", "White", "Grey", "Purple"], "seats": 5, "car_make": "Audi", "quantity": 6, "car_model": "S4", "price_day": 262, "price_hour": 39, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
6	6	{"vehicle": [{"color": ["Grey", "Silver", "Pink", "Black"], "seats": 3, "car_make": "Toyota", "quantity": 5, "car_model": "Echo", "price_day": 223, "price_hour": 33, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
7	7	{"vehicle": [{"color": ["Purple", "Indigo", "Black", "Pink"], "seats": 4, "car_make": "Mercury", "quantity": 9, "car_model": "Topaz", "price_day": 162, "price_hour": 33, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
8	8	{"vehicle": [{"color": ["White", "Silver", "Purple", "Grey"], "seats": 5, "car_make": "Isuzu", "quantity": 9, "car_model": "Trooper", "price_day": 284, "price_hour": 16, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
9	9	{"vehicle": [{"color": ["Pink", "Blue", "Grey", "Silver"], "seats": 2, "car_make": "Porsche", "quantity": 6, "car_model": "Boxster", "price_day": 198, "price_hour": 16, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
10	10	{"vehicle": [{"color": ["Purple", "Orange", "Blue", "White"], "seats": 4, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Pajero", "price_day": 186, "price_hour": 32, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
11	11	{"vehicle": [{"color": ["Purple", "Silver", "Indigo", "White"], "seats": 7, "car_make": "Mazda", "quantity": 9, "car_model": "B-Series", "price_day": 211, "price_hour": 32, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
12	12	{"vehicle": [{"color": ["Pink", "Indigo", "Orange", "Black"], "seats": 8, "car_make": "Lexus", "quantity": 8, "car_model": "ES", "price_day": 275, "price_hour": 25, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
13	13	{"vehicle": [{"color": ["Grey", "Black", "Silver", "White"], "seats": 2, "car_make": "Lotus", "quantity": 6, "car_model": "Esprit", "price_day": 238, "price_hour": 46, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
14	14	{"vehicle": [{"color": ["Orange", "Silver", "Purple", "Pink"], "seats": 4, "car_make": "Hyundai", "quantity": 6, "car_model": "Accent", "price_day": 273, "price_hour": 17, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
15	15	{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
16	16	{"vehicle": [{"color": ["Orange", "Grey", "Silver", "Blue"], "seats": 2, "car_make": "Plymouth", "quantity": 6, "car_model": "Colt", "price_day": 226, "price_hour": 29, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
17	17	{"vehicle": [{"color": ["Pink", "Blue", "White", "Black"], "seats": 8, "car_make": "Infiniti", "quantity": 7, "car_model": "FX", "price_day": 242, "price_hour": 29, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
18	18	{"vehicle": [{"color": ["Grey", "Black", "Orange", "White"], "seats": 2, "car_make": "Porsche", "quantity": 9, "car_model": "928", "price_day": 268, "price_hour": 28, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
19	19	{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 7, "car_make": "Cadillac", "quantity": 9, "car_model": "Escalade EXT", "price_day": 151, "price_hour": 50, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
20	20	{"vehicle": [{"color": ["Indigo", "Purple", "Grey", "Black"], "seats": 2, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban 1500", "price_day": 281, "price_hour": 48, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
21	21	{"vehicle": [{"color": ["Silver", "Orange", "Pink", "Indigo"], "seats": 7, "car_make": "Buick", "quantity": 8, "car_model": "Century", "price_day": 251, "price_hour": 34, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
22	22	{"vehicle": [{"color": ["Purple", "White", "Pink", "Grey"], "seats": 4, "car_make": "Mercedes-Benz", "quantity": 8, "car_model": "E-Class", "price_day": 212, "price_hour": 49, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
23	23	{"vehicle": [{"color": ["Black", "Purple", "Orange", "Grey"], "seats": 8, "car_make": "Dodge", "quantity": 9, "car_model": "Ram 2500", "price_day": 261, "price_hour": 47, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
24	24	{"vehicle": [{"color": ["Purple", "Black", "White", "Orange"], "seats": 7, "car_make": "MINI", "quantity": 9, "car_model": "MINI", "price_day": 188, "price_hour": 39, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
25	25	{"vehicle": [{"color": ["Silver", "Blue", "Black", "Purple"], "seats": 5, "car_make": "Ford", "quantity": 6, "car_model": "Econoline E350", "price_day": 163, "price_hour": 32, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
26	26	{"vehicle": [{"color": ["Orange", "Blue", "Black", "White"], "seats": 2, "car_make": "Hyundai", "quantity": 6, "car_model": "Sonata", "price_day": 275, "price_hour": 49, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
27	27	{"vehicle": [{"color": ["Silver", "Purple", "Orange", "White"], "seats": 7, "car_make": "Nissan", "quantity": 9, "car_model": "Pathfinder", "price_day": 294, "price_hour": 33, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
28	28	{"vehicle": [{"color": ["Grey", "Pink", "Silver", "Indigo"], "seats": 2, "car_make": "Nissan", "quantity": 8, "car_model": "Maxima", "price_day": 252, "price_hour": 44, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
29	29	{"vehicle": [{"color": ["Silver", "White", "Pink", "Orange"], "seats": 5, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer Evolution", "price_day": 182, "price_hour": 17, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
30	30	{"vehicle": [{"color": ["Indigo", "Blue", "Pink", "Purple"], "seats": 7, "car_make": "Ford", "quantity": 7, "car_model": "Thunderbird", "price_day": 280, "price_hour": 25, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
31	31	{"vehicle": [{"color": ["White", "Grey", "Silver", "Orange"], "seats": 6, "car_make": "Ferrari", "quantity": 7, "car_model": "California", "price_day": 238, "price_hour": 21, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
32	32	{"vehicle": [{"color": ["Black", "Silver", "Pink", "Blue"], "seats": 8, "car_make": "Acura", "quantity": 5, "car_model": "CL", "price_day": 180, "price_hour": 33, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
33	33	{"vehicle": [{"color": ["White", "Purple", "Pink", "Silver"], "seats": 2, "car_make": "Toyota", "quantity": 5, "car_model": "Prius", "price_day": 297, "price_hour": 49, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
34	34	{"vehicle": [{"color": ["Pink", "Silver", "Orange", "Indigo"], "seats": 4, "car_make": "Lotus", "quantity": 9, "car_model": "Esprit", "price_day": 254, "price_hour": 47, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
35	35	{"vehicle": [{"color": ["White", "Black", "Orange", "Silver"], "seats": 5, "car_make": "Dodge", "quantity": 6, "car_model": "Avenger", "price_day": 268, "price_hour": 39, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
36	36	{"vehicle": [{"color": ["Black", "Purple", "Blue", "Grey"], "seats": 6, "car_make": "Cadillac", "quantity": 5, "car_model": "CTS-V", "price_day": 289, "price_hour": 18, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
37	37	{"vehicle": [{"color": ["Indigo", "Grey", "Black", "White"], "seats": 8, "car_make": "Pontiac", "quantity": 9, "car_model": "1000", "price_day": 172, "price_hour": 45, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
38	38	{"vehicle": [{"color": ["Blue", "Indigo", "Purple", "Black"], "seats": 6, "car_make": "Mazda", "quantity": 6, "car_model": "B-Series", "price_day": 167, "price_hour": 15, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
39	39	{"vehicle": [{"color": ["Orange", "White", "Blue", "Purple"], "seats": 2, "car_make": "BMW", "quantity": 7, "car_model": "545", "price_day": 265, "price_hour": 47, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
40	40	{"vehicle": [{"color": ["Grey", "Orange", "Purple", "Pink"], "seats": 8, "car_make": "Mercury", "quantity": 5, "car_model": "Cougar", "price_day": 179, "price_hour": 21, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
41	41	{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
42	42	{"vehicle": [{"color": ["Pink", "Indigo", "Purple", "Blue"], "seats": 5, "car_make": "Kia", "quantity": 6, "car_model": "Rondo", "price_day": 248, "price_hour": 19, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
43	43	{"vehicle": [{"color": ["Indigo", "White", "Grey", "Black"], "seats": 6, "car_make": "Acura", "quantity": 8, "car_model": "TL", "price_day": 177, "price_hour": 42, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
44	44	{"vehicle": [{"color": ["Silver", "White", "Orange", "Indigo"], "seats": 8, "car_make": "Mercedes-Benz", "quantity": 8, "car_model": "600SEC", "price_day": 145, "price_hour": 43, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
45	45	{"vehicle": [{"color": ["Purple", "Orange", "Black", "Silver"], "seats": 3, "car_make": "Cadillac", "quantity": 9, "car_model": "SRX", "price_day": 161, "price_hour": 30, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
46	46	{"vehicle": [{"color": ["White", "Silver", "Pink", "Indigo"], "seats": 3, "car_make": "Subaru", "quantity": 7, "car_model": "Loyale", "price_day": 223, "price_hour": 50, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
47	47	{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
48	48	{"vehicle": [{"color": ["Indigo", "Purple", "Black", "Silver"], "seats": 3, "car_make": "GMC", "quantity": 6, "car_model": "Savana 1500", "price_day": 179, "price_hour": 35, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
49	49	{"vehicle": [{"color": ["Indigo", "Grey", "Pink", "Purple"], "seats": 5, "car_make": "Jeep", "quantity": 8, "car_model": "Compass", "price_day": 237, "price_hour": 29, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
50	50	{"vehicle": [{"color": ["Silver", "Black", "Orange", "Grey"], "seats": 4, "car_make": "Volvo", "quantity": 9, "car_model": "V50", "price_day": 289, "price_hour": 45, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
51	51	{"vehicle": [{"color": ["Black", "Purple", "Blue", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 7, "car_model": "Seville", "price_day": 295, "price_hour": 22, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
52	52	{"vehicle": [{"color": ["Blue", "Orange", "Indigo", "Grey"], "seats": 7, "car_make": "Pontiac", "quantity": 9, "car_model": "Fiero", "price_day": 152, "price_hour": 46, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
53	53	{"vehicle": [{"color": ["Black", "Pink", "White", "Indigo"], "seats": 8, "car_make": "Saab", "quantity": 5, "car_model": "9000", "price_day": 238, "price_hour": 49, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
54	54	{"vehicle": [{"color": ["Purple", "White", "Grey", "Pink"], "seats": 2, "car_make": "Toyota", "quantity": 7, "car_model": "Corolla", "price_day": 236, "price_hour": 27, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
55	55	{"vehicle": [{"color": ["Pink", "Black", "Silver", "Grey"], "seats": 6, "car_make": "Dodge", "quantity": 7, "car_model": "Colt", "price_day": 207, "price_hour": 39, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
56	56	{"vehicle": [{"color": ["Blue", "Black", "Purple", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 8, "car_model": "CTS-V", "price_day": 205, "price_hour": 40, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
57	57	{"vehicle": [{"color": ["Grey", "Silver", "Pink", "White"], "seats": 4, "car_make": "Oldsmobile", "quantity": 9, "car_model": "88", "price_day": 140, "price_hour": 18, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
58	58	{"vehicle": [{"color": ["Grey", "Orange", "Indigo", "Black"], "seats": 5, "car_make": "GMC", "quantity": 7, "car_model": "Sierra Hybrid", "price_day": 246, "price_hour": 48, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
59	59	{"vehicle": [{"color": ["White", "Pink", "Silver", "Black"], "seats": 6, "car_make": "Toyota", "quantity": 7, "car_model": "RAV4", "price_day": 143, "price_hour": 43, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
60	60	{"vehicle": [{"color": ["Orange", "White", "Purple", "Silver"], "seats": 6, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Montero", "price_day": 282, "price_hour": 17, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
61	61	{"vehicle": [{"color": ["Purple", "White", "Orange", "Grey"], "seats": 3, "car_make": "Plymouth", "quantity": 6, "car_model": "Voyager", "price_day": 198, "price_hour": 20, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
62	62	{"vehicle": [{"color": ["Purple", "White", "Orange", "Indigo"], "seats": 4, "car_make": "Infiniti", "quantity": 7, "car_model": "FX", "price_day": 242, "price_hour": 22, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
63	63	{"vehicle": [{"color": ["Black", "Orange", "Grey", "Blue"], "seats": 2, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer", "price_day": 252, "price_hour": 36, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
64	64	{"vehicle": [{"color": ["Purple", "Black", "Blue", "Orange"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Thunderbird", "price_day": 282, "price_hour": 22, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
65	65	{"vehicle": [{"color": ["Blue", "Purple", "Orange", "Indigo"], "seats": 3, "car_make": "BMW", "quantity": 8, "car_model": "3 Series", "price_day": 180, "price_hour": 32, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
66	66	{"vehicle": [{"color": ["White", "Silver", "Grey", "Black"], "seats": 2, "car_make": "Oldsmobile", "quantity": 6, "car_model": "Intrigue", "price_day": 237, "price_hour": 25, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
67	67	{"vehicle": [{"color": ["Blue", "Pink", "Orange", "Purple"], "seats": 3, "car_make": "Dodge", "quantity": 7, "car_model": "Durango", "price_day": 225, "price_hour": 44, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
68	68	{"vehicle": [{"color": ["White", "Orange", "Blue", "Purple"], "seats": 3, "car_make": "GMC", "quantity": 7, "car_model": "Envoy", "price_day": 192, "price_hour": 21, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
69	69	{"vehicle": [{"color": ["Orange", "Black", "Pink", "Silver"], "seats": 7, "car_make": "Spyker", "quantity": 9, "car_model": "C8 Spyder", "price_day": 253, "price_hour": 41, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
70	70	{"vehicle": [{"color": ["Indigo", "Orange", "Purple", "Black"], "seats": 4, "car_make": "Chevrolet", "quantity": 6, "car_model": "Camaro", "price_day": 196, "price_hour": 25, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
71	71	{"vehicle": [{"color": ["Silver", "Orange", "White", "Black"], "seats": 5, "car_make": "Oldsmobile", "quantity": 8, "car_model": "Aurora", "price_day": 277, "price_hour": 22, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
72	72	{"vehicle": [{"color": ["Purple", "Grey", "Orange", "Indigo"], "seats": 2, "car_make": "Mazda", "quantity": 5, "car_model": "Tribute", "price_day": 257, "price_hour": 50, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
73	73	{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
74	74	{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
75	75	{"vehicle": [{"color": ["Indigo", "Silver", "White", "Black"], "seats": 3, "car_make": "Dodge", "quantity": 8, "car_model": "Ram 2500", "price_day": 284, "price_hour": 17, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
76	76	{"vehicle": [{"color": ["White", "Blue", "Silver", "Indigo"], "seats": 5, "car_make": "Maserati", "quantity": 8, "car_model": "GranTurismo", "price_day": 258, "price_hour": 50, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
77	77	{"vehicle": [{"color": ["Pink", "Indigo", "Purple", "Grey"], "seats": 3, "car_make": "Volkswagen", "quantity": 5, "car_model": "Jetta", "price_day": 212, "price_hour": 29, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
78	78	{"vehicle": [{"color": ["Silver", "Grey", "Pink", "Purple"], "seats": 7, "car_make": "Mazda", "quantity": 9, "car_model": "Miata MX-5", "price_day": 276, "price_hour": 36, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
79	79	{"vehicle": [{"color": ["Silver", "White", "Grey", "Indigo"], "seats": 7, "car_make": "Buick", "quantity": 7, "car_model": "Somerset", "price_day": 149, "price_hour": 37, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
80	80	{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 6, "car_make": "Saab", "quantity": 7, "car_model": "9-5", "price_day": 228, "price_hour": 16, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
81	81	{"vehicle": [{"color": ["Blue", "Purple", "Indigo", "Grey"], "seats": 6, "car_make": "Toyota", "quantity": 9, "car_model": "Previa", "price_day": 253, "price_hour": 24, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
82	82	{"vehicle": [{"color": ["Black", "Indigo", "Silver", "Pink"], "seats": 8, "car_make": "Mitsubishi", "quantity": 9, "car_model": "Expo", "price_day": 143, "price_hour": 31, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
83	83	{"vehicle": [{"color": ["Purple", "White", "Grey", "Silver"], "seats": 6, "car_make": "Dodge", "quantity": 5, "car_model": "Ram 1500", "price_day": 163, "price_hour": 29, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
84	84	{"vehicle": [{"color": ["Indigo", "Black", "Purple", "Grey"], "seats": 4, "car_make": "Infiniti", "quantity": 6, "car_model": "I", "price_day": 199, "price_hour": 42, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
85	85	{"vehicle": [{"color": ["Indigo", "Orange", "White", "Pink"], "seats": 8, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Lancer Evolution", "price_day": 230, "price_hour": 37, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
86	86	{"vehicle": [{"color": ["Indigo", "Orange", "Silver", "Purple"], "seats": 8, "car_make": "Toyota", "quantity": 7, "car_model": "Celica", "price_day": 234, "price_hour": 48, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
87	87	{"vehicle": [{"color": ["Blue", "Black", "Pink", "Grey"], "seats": 6, "car_make": "Hyundai", "quantity": 8, "car_model": "Tucson", "price_day": 256, "price_hour": 27, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
88	88	{"vehicle": [{"color": ["Blue", "Grey", "Black", "Orange"], "seats": 6, "car_make": "Fillmore", "quantity": 9, "car_model": "Fillmore", "price_day": 253, "price_hour": 39, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
89	89	{"vehicle": [{"color": ["Pink", "Orange", "White", "Black"], "seats": 5, "car_make": "Lexus", "quantity": 9, "car_model": "IS", "price_day": 204, "price_hour": 37, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
90	90	{"vehicle": [{"color": ["Indigo", "Orange", "Black", "White"], "seats": 8, "car_make": "Pontiac", "quantity": 5, "car_model": "Firebird Formula", "price_day": 245, "price_hour": 35, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
91	91	{"vehicle": [{"color": ["Blue", "Grey", "Pink", "Indigo"], "seats": 5, "car_make": "Buick", "quantity": 6, "car_model": "Park Avenue", "price_day": 176, "price_hour": 33, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
92	92	{"vehicle": [{"color": ["Pink", "Grey", "Purple", "Black"], "seats": 5, "car_make": "Chevrolet", "quantity": 6, "car_model": "Corvette", "price_day": 271, "price_hour": 30, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
93	93	{"vehicle": [{"color": ["Orange", "Blue", "Indigo", "Grey"], "seats": 7, "car_make": "BMW", "quantity": 7, "car_model": "M", "price_day": 224, "price_hour": 18, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
94	94	{"vehicle": [{"color": ["Black", "Orange", "Silver", "Indigo"], "seats": 7, "car_make": "Volvo", "quantity": 7, "car_model": "S80", "price_day": 235, "price_hour": 38, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
95	95	{"vehicle": [{"color": ["Black", "Pink", "Grey", "Blue"], "seats": 2, "car_make": "Honda", "quantity": 5, "car_model": "CR-V", "price_day": 142, "price_hour": 41, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
96	96	{"vehicle": [{"color": ["Blue", "Orange", "Silver", "Black"], "seats": 7, "car_make": "Ford", "quantity": 6, "car_model": "Aspire", "price_day": 237, "price_hour": 48, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
97	97	{"vehicle": [{"color": ["White", "Blue", "Silver", "Pink"], "seats": 5, "car_make": "Ford", "quantity": 7, "car_model": "Club Wagon", "price_day": 247, "price_hour": 23, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
98	98	{"vehicle": [{"color": ["Pink", "Black", "White", "Indigo"], "seats": 5, "car_make": "Subaru", "quantity": 9, "car_model": "Legacy", "price_day": 256, "price_hour": 21, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
99	99	{"vehicle": [{"color": ["Indigo", "Grey", "Blue", "Silver"], "seats": 8, "car_make": "Volkswagen", "quantity": 5, "car_model": "Passat", "price_day": 193, "price_hour": 25, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
100	100	{"vehicle": [{"color": ["Blue", "Pink", "Black", "Grey"], "seats": 8, "car_make": "Aston Martin", "quantity": 8, "car_model": "DBS", "price_day": 140, "price_hour": 34, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
101	101	{"vehicle": [{"color": ["Black", "Pink", "Indigo", "Grey"], "seats": 8, "car_make": "Mercedes-Benz", "quantity": 7, "car_model": "400SEL", "price_day": 153, "price_hour": 45, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
102	102	{"vehicle": [{"color": ["Indigo", "Grey", "Silver", "Orange"], "seats": 2, "car_make": "Buick", "quantity": 6, "car_model": "Coachbuilder", "price_day": 270, "price_hour": 21, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
103	103	{"vehicle": [{"color": ["Purple", "Blue", "Black", "Orange"], "seats": 5, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban", "price_day": 229, "price_hour": 34, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
104	104	{"vehicle": [{"color": ["Black", "Pink", "White", "Purple"], "seats": 8, "car_make": "Buick", "quantity": 6, "car_model": "Park Avenue", "price_day": 209, "price_hour": 21, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
105	105	{"vehicle": [{"color": ["Blue", "Purple", "Black", "Grey"], "seats": 6, "car_make": "Porsche", "quantity": 8, "car_model": "928", "price_day": 152, "price_hour": 35, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
106	106	{"vehicle": [{"color": ["Orange", "Silver", "Black", "Grey"], "seats": 6, "car_make": "Hyundai", "quantity": 6, "car_model": "Elantra", "price_day": 233, "price_hour": 24, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
107	107	{"vehicle": [{"color": ["Purple", "Blue", "Grey", "Indigo"], "seats": 8, "car_make": "Buick", "quantity": 6, "car_model": "Century", "price_day": 297, "price_hour": 31, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
108	108	{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
109	109	{"vehicle": [{"color": ["Purple", "Pink", "Blue", "White"], "seats": 7, "car_make": "Lotus", "quantity": 7, "car_model": "Esprit", "price_day": 147, "price_hour": 16, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
110	110	{"vehicle": [{"color": ["White", "Silver", "Blue", "Indigo"], "seats": 3, "car_make": "Infiniti", "quantity": 6, "car_model": "QX", "price_day": 162, "price_hour": 25, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
111	111	{"vehicle": [{"color": ["Silver", "Indigo", "Purple", "White"], "seats": 5, "car_make": "Toyota", "quantity": 5, "car_model": "Highlander", "price_day": 284, "price_hour": 47, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
112	112	{"vehicle": [{"color": ["White", "Indigo", "Orange", "Purple"], "seats": 2, "car_make": "Dodge", "quantity": 5, "car_model": "Durango", "price_day": 298, "price_hour": 24, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
113	113	{"vehicle": [{"color": ["Orange", "Indigo", "Grey", "Blue"], "seats": 7, "car_make": "Mercedes-Benz", "quantity": 6, "car_model": "S-Class", "price_day": 271, "price_hour": 48, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
114	114	{"vehicle": [{"color": ["White", "Orange", "Purple", "Black"], "seats": 6, "car_make": "Cadillac", "quantity": 6, "car_model": "Fleetwood", "price_day": 293, "price_hour": 30, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
115	115	{"vehicle": [{"color": ["Grey", "Orange", "Silver", "Pink"], "seats": 8, "car_make": "Volkswagen", "quantity": 8, "car_model": "Corrado", "price_day": 213, "price_hour": 35, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
116	116	{"vehicle": [{"color": ["Black", "Pink", "White", "Orange"], "seats": 2, "car_make": "Chevrolet", "quantity": 6, "car_model": "Sportvan G30", "price_day": 144, "price_hour": 16, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
117	117	{"vehicle": [{"color": ["Indigo", "Blue", "Black", "Orange"], "seats": 8, "car_make": "Chevrolet", "quantity": 9, "car_model": "Aveo", "price_day": 244, "price_hour": 31, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
118	118	{"vehicle": [{"color": ["Black", "Pink", "Orange", "Purple"], "seats": 6, "car_make": "GMC", "quantity": 6, "car_model": "1500", "price_day": 206, "price_hour": 18, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
119	119	{"vehicle": [{"color": ["Silver", "Blue", "Indigo", "Pink"], "seats": 3, "car_make": "Maserati", "quantity": 6, "car_model": "Quattroporte", "price_day": 186, "price_hour": 19, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
120	120	{"vehicle": [{"color": ["Blue", "Purple", "Pink", "Black"], "seats": 3, "car_make": "Ford", "quantity": 7, "car_model": "Escort", "price_day": 211, "price_hour": 43, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
121	121	{"vehicle": [{"color": ["White", "Purple", "Orange", "Black"], "seats": 7, "car_make": "Lexus", "quantity": 7, "car_model": "ES", "price_day": 145, "price_hour": 18, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
122	122	{"vehicle": [{"color": ["Black", "Purple", "Indigo", "White"], "seats": 3, "car_make": "Chevrolet", "quantity": 7, "car_model": "Impala", "price_day": 212, "price_hour": 32, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
123	123	{"vehicle": [{"color": ["White", "Purple", "Orange", "Grey"], "seats": 2, "car_make": "Dodge", "quantity": 5, "car_model": "D250", "price_day": 257, "price_hour": 46, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
124	124	{"vehicle": [{"color": ["Grey", "Black", "Silver", "White"], "seats": 2, "car_make": "Jeep", "quantity": 6, "car_model": "Comanche", "price_day": 252, "price_hour": 41, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
125	125	{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
126	126	{"vehicle": [{"color": ["White", "Indigo", "Black", "Blue"], "seats": 5, "car_make": "Nissan", "quantity": 5, "car_model": "GT-R", "price_day": 232, "price_hour": 33, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
127	127	{"vehicle": [{"color": ["Pink", "Orange", "White", "Black"], "seats": 2, "car_make": "Ford", "quantity": 5, "car_model": "Explorer", "price_day": 149, "price_hour": 35, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
128	128	{"vehicle": [{"color": ["Purple", "Grey", "Pink", "Blue"], "seats": 4, "car_make": "Acura", "quantity": 6, "car_model": "MDX", "price_day": 221, "price_hour": 50, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
129	129	{"vehicle": [{"color": ["Silver", "Purple", "Pink", "Orange"], "seats": 4, "car_make": "Land Rover", "quantity": 8, "car_model": "Defender Ice Edition", "price_day": 183, "price_hour": 48, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
130	130	{"vehicle": [{"color": ["Pink", "Silver", "Orange", "White"], "seats": 6, "car_make": "Ford", "quantity": 7, "car_model": "Focus", "price_day": 195, "price_hour": 15, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
131	131	{"vehicle": [{"color": ["Blue", "Indigo", "Pink", "Grey"], "seats": 6, "car_make": "Dodge", "quantity": 9, "car_model": "Dakota Club", "price_day": 221, "price_hour": 19, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
132	132	{"vehicle": [{"color": ["Pink", "Silver", "Indigo", "Orange"], "seats": 3, "car_make": "Lexus", "quantity": 7, "car_model": "IS-F", "price_day": 170, "price_hour": 37, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
133	133	{"vehicle": [{"color": ["Black", "Orange", "Grey", "Purple"], "seats": 4, "car_make": "Ford", "quantity": 5, "car_model": "Ranger", "price_day": 290, "price_hour": 43, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
134	134	{"vehicle": [{"color": ["Pink", "Purple", "Black", "Grey"], "seats": 7, "car_make": "Honda", "quantity": 9, "car_model": "Accord", "price_day": 143, "price_hour": 25, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
135	135	{"vehicle": [{"color": ["Orange", "Black", "Blue", "Purple"], "seats": 4, "car_make": "Subaru", "quantity": 5, "car_model": "SVX", "price_day": 167, "price_hour": 22, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
136	136	{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00

	id	jsontest	create_at
1	1	{"vehicle": [{"color": ["White", "Orange", "Blue", "Indigo"], "seats": 3, "car_make": "Suzuki", "quantity": 9, "car_model": "XL-7", "price_day": 187, "price_hour": 49, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
2	5	{"vehicle": [{"color": ["Blue", "White", "Grey", "Purple"], "seats": 5, "car_make": "Audi", "quantity": 6, "car_model": "S4", "price_day": 262, "price_hour": 39, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
3	9	{"vehicle": [{"color": ["Pink", "Blue", "Grey", "Silver"], "seats": 2, "car_make": "Porsche", "quantity": 6, "car_model": "Boxster", "price_day": 198, "price_hour": 16, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
4	10	{"vehicle": [{"color": ["Purple", "Orange", "Blue", "White"], "seats": 4, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Pajero", "price_day": 186, "price_hour": 32, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
5	15	{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
6	16	{"vehicle": [{"color": ["Orange", "Grey", "Silver", "Blue"], "seats": 2, "car_make": "Plymouth", "quantity": 6, "car_model": "Colt", "price_day": 226, "price_hour": 29, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
7	17	{"vehicle": [{"color": ["Pink", "Blue", "White", "Black"], "seats": 8, "car_make": "Infiniti", "quantity": 7, "car_model": "FX", "price_day": 242, "price_hour": 29, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
8	19	{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 7, "car_make": "Cadillac", "quantity": 9, "car_model": "Escalade EXT", "price_day": 151, "price_hour": 50, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
9	25	{"vehicle": [{"color": ["Silver", "Blue", "Black", "Purple"], "seats": 5, "car_make": "Ford", "quantity": 6, "car_model": "Econoline E350", "price_day": 163, "price_hour": 32, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
10	26	{"vehicle": [{"color": ["Orange", "Blue", "Black", "White"], "seats": 2, "car_make": "Hyundai", "quantity": 6, "car_model": "Sonata", "price_day": 275, "price_hour": 49, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
11	30	{"vehicle": [{"color": ["Indigo", "Blue", "Pink", "Purple"], "seats": 7, "car_make": "Ford", "quantity": 7, "car_model": "Thunderbird", "price_day": 280, "price_hour": 25, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
12	32	{"vehicle": [{"color": ["Black", "Silver", "Pink", "Blue"], "seats": 8, "car_make": "Acura", "quantity": 5, "car_model": "CL", "price_day": 180, "price_hour": 33, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
13	36	{"vehicle": [{"color": ["Black", "Purple", "Blue", "Grey"], "seats": 6, "car_make": "Cadillac", "quantity": 5, "car_model": "CTS-V", "price_day": 289, "price_hour": 18, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
14	38	{"vehicle": [{"color": ["Blue", "Indigo", "Purple", "Black"], "seats": 6, "car_make": "Mazda", "quantity": 6, "car_model": "B-Series", "price_day": 167, "price_hour": 15, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
15	39	{"vehicle": [{"color": ["Orange", "White", "Blue", "Purple"], "seats": 2, "car_make": "BMW", "quantity": 7, "car_model": "545", "price_day": 265, "price_hour": 47, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
16	41	{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
17	42	{"vehicle": [{"color": ["Pink", "Indigo", "Purple", "Blue"], "seats": 5, "car_make": "Kia", "quantity": 6, "car_model": "Rondo", "price_day": 248, "price_hour": 19, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
18	47	{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
19	51	{"vehicle": [{"color": ["Black", "Purple", "Blue", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 7, "car_model": "Seville", "price_day": 295, "price_hour": 22, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
20	52	{"vehicle": [{"color": ["Blue", "Orange", "Indigo", "Grey"], "seats": 7, "car_make": "Pontiac", "quantity": 9, "car_model": "Fiero", "price_day": 152, "price_hour": 46, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
21	56	{"vehicle": [{"color": ["Blue", "Black", "Purple", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 8, "car_model": "CTS-V", "price_day": 205, "price_hour": 40, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
22	63	{"vehicle": [{"color": ["Black", "Orange", "Grey", "Blue"], "seats": 2, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer", "price_day": 252, "price_hour": 36, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
23	64	{"vehicle": [{"color": ["Purple", "Black", "Blue", "Orange"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Thunderbird", "price_day": 282, "price_hour": 22, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
24	65	{"vehicle": [{"color": ["Blue", "Purple", "Orange", "Indigo"], "seats": 3, "car_make": "BMW", "quantity": 8, "car_model": "3 Series", "price_day": 180, "price_hour": 32, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
25	67	{"vehicle": [{"color": ["Blue", "Pink", "Orange", "Purple"], "seats": 3, "car_make": "Dodge", "quantity": 7, "car_model": "Durango", "price_day": 225, "price_hour": 44, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
26	68	{"vehicle": [{"color": ["White", "Orange", "Blue", "Purple"], "seats": 3, "car_make": "GMC", "quantity": 7, "car_model": "Envoy", "price_day": 192, "price_hour": 21, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
27	73	{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
28	74	{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
29	76	{"vehicle": [{"color": ["White", "Blue", "Silver", "Indigo"], "seats": 5, "car_make": "Maserati", "quantity": 8, "car_model": "GranTurismo", "price_day": 258, "price_hour": 50, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
30	80	{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 6, "car_make": "Saab", "quantity": 7, "car_model": "9-5", "price_day": 228, "price_hour": 16, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
31	81	{"vehicle": [{"color": ["Blue", "Purple", "Indigo", "Grey"], "seats": 6, "car_make": "Toyota", "quantity": 9, "car_model": "Previa", "price_day": 253, "price_hour": 24, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
32	87	{"vehicle": [{"color": ["Blue", "Black", "Pink", "Grey"], "seats": 6, "car_make": "Hyundai", "quantity": 8, "car_model": "Tucson", "price_day": 256, "price_hour": 27, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
33	88	{"vehicle": [{"color": ["Blue", "Grey", "Black", "Orange"], "seats": 6, "car_make": "Fillmore", "quantity": 9, "car_model": "Fillmore", "price_day": 253, "price_hour": 39, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
34	91	{"vehicle": [{"color": ["Blue", "Grey", "Pink", "Indigo"], "seats": 5, "car_make": "Buick", "quantity": 6, "car_model": "Park Avenue", "price_day": 176, "price_hour": 33, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
35	93	{"vehicle": [{"color": ["Orange", "Blue", "Indigo", "Grey"], "seats": 7, "car_make": "BMW", "quantity": 7, "car_model": "M", "price_day": 224, "price_hour": 18, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
36	95	{"vehicle": [{"color": ["Black", "Pink", "Grey", "Blue"], "seats": 2, "car_make": "Honda", "quantity": 5, "car_model": "CR-V", "price_day": 142, "price_hour": 41, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
37	96	{"vehicle": [{"color": ["Blue", "Orange", "Silver", "Black"], "seats": 7, "car_make": "Ford", "quantity": 6, "car_model": "Aspire", "price_day": 237, "price_hour": 48, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
38	97	{"vehicle": [{"color": ["White", "Blue", "Silver", "Pink"], "seats": 5, "car_make": "Ford", "quantity": 7, "car_model": "Club Wagon", "price_day": 247, "price_hour": 23, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
39	99	{"vehicle": [{"color": ["Indigo", "Grey", "Blue", "Silver"], "seats": 8, "car_make": "Volkswagen", "quantity": 5, "car_model": "Passat", "price_day": 193, "price_hour": 25, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
40	100	{"vehicle": [{"color": ["Blue", "Pink", "Black", "Grey"], "seats": 8, "car_make": "Aston Martin", "quantity": 8, "car_model": "DBS", "price_day": 140, "price_hour": 34, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
41	103	{"vehicle": [{"color": ["Purple", "Blue", "Black", "Orange"], "seats": 5, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban", "price_day": 229, "price_hour": 34, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
42	105	{"vehicle": [{"color": ["Blue", "Purple", "Black", "Grey"], "seats": 6, "car_make": "Porsche", "quantity": 8, "car_model": "928", "price_day": 152, "price_hour": 35, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
43	107	{"vehicle": [{"color": ["Purple", "Blue", "Grey", "Indigo"], "seats": 8, "car_make": "Buick", "quantity": 6, "car_model": "Century", "price_day": 297, "price_hour": 31, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
44	108	{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
45	109	{"vehicle": [{"color": ["Purple", "Pink", "Blue", "White"], "seats": 7, "car_make": "Lotus", "quantity": 7, "car_model": "Esprit", "price_day": 147, "price_hour": 16, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
46	110	{"vehicle": [{"color": ["White", "Silver", "Blue", "Indigo"], "seats": 3, "car_make": "Infiniti", "quantity": 6, "car_model": "QX", "price_day": 162, "price_hour": 25, "vehicle_type": "Van"}]}	04.08.2020 00:00:00
47	113	{"vehicle": [{"color": ["Orange", "Indigo", "Grey", "Blue"], "seats": 7, "car_make": "Mercedes-Benz", "quantity": 6, "car_model": "S-Class", "price_day": 271, "price_hour": 48, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
48	117	{"vehicle": [{"color": ["Indigo", "Blue", "Black", "Orange"], "seats": 8, "car_make": "Chevrolet", "quantity": 9, "car_model": "Aveo", "price_day": 244, "price_hour": 31, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
49	119	{"vehicle": [{"color": ["Silver", "Blue", "Indigo", "Pink"], "seats": 3, "car_make": "Maserati", "quantity": 6, "car_model": "Quattroporte", "price_day": 186, "price_hour": 19, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
50	120	{"vehicle": [{"color": ["Blue", "Purple", "Pink", "Black"], "seats": 3, "car_make": "Ford", "quantity": 7, "car_model": "Escort", "price_day": 211, "price_hour": 43, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
51	125	{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
52	126	{"vehicle": [{"color": ["White", "Indigo", "Black", "Blue"], "seats": 5, "car_make": "Nissan", "quantity": 5, "car_model": "GT-R", "price_day": 232, "price_hour": 33, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
53	128	{"vehicle": [{"color": ["Purple", "Grey", "Pink", "Blue"], "seats": 4, "car_make": "Acura", "quantity": 6, "car_model": "MDX", "price_day": 221, "price_hour": 50, "vehicle_type": "Hatchback"}]}	04.08.2020 00:00:00
54	131	{"vehicle": [{"color": ["Blue", "Indigo", "Pink", "Grey"], "seats": 6, "car_make": "Dodge", "quantity": 9, "car_model": "Dakota Club", "price_day": 221, "price_hour": 19, "vehicle_type": "Truck"}]}	04.08.2020 00:00:00
55	135	{"vehicle": [{"color": ["Orange", "Black", "Blue", "Purple"], "seats": 4, "car_make": "Subaru", "quantity": 5, "car_model": "SVX", "price_day": 167, "price_hour": 22, "vehicle_type": "Sedan"}]}	04.08.2020 00:00:00
56	136	{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00

	id	jsontest	create_at
1	7	{"vehicle": [{"color": ["Purple", "Indigo", "Black", "Pink"], "seats": 4, "car_make": "Mercury", "quantity": 9, "car_model": "Topaz", "price_day": 162, "price_hour": 33, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
2	12	{"vehicle": [{"color": ["Pink", "Indigo", "Orange", "Black"], "seats": 8, "car_make": "Lexus", "quantity": 8, "car_model": "ES", "price_day": 275, "price_hour": 25, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
3	15	{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
4	18	{"vehicle": [{"color": ["Grey", "Black", "Orange", "White"], "seats": 2, "car_make": "Porsche", "quantity": 9, "car_model": "928", "price_day": 268, "price_hour": 28, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
5	20	{"vehicle": [{"color": ["Indigo", "Purple", "Grey", "Black"], "seats": 2, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban 1500", "price_day": 281, "price_hour": 48, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
6	29	{"vehicle": [{"color": ["Silver", "White", "Pink", "Orange"], "seats": 5, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer Evolution", "price_day": 182, "price_hour": 17, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
7	31	{"vehicle": [{"color": ["White", "Grey", "Silver", "Orange"], "seats": 6, "car_make": "Ferrari", "quantity": 7, "car_model": "California", "price_day": 238, "price_hour": 21, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
8	40	{"vehicle": [{"color": ["Grey", "Orange", "Purple", "Pink"], "seats": 8, "car_make": "Mercury", "quantity": 5, "car_model": "Cougar", "price_day": 179, "price_hour": 21, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
9	41	{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
10	47	{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
11	58	{"vehicle": [{"color": ["Grey", "Orange", "Indigo", "Black"], "seats": 5, "car_make": "GMC", "quantity": 7, "car_model": "Sierra Hybrid", "price_day": 246, "price_hour": 48, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
12	69	{"vehicle": [{"color": ["Orange", "Black", "Pink", "Silver"], "seats": 7, "car_make": "Spyker", "quantity": 9, "car_model": "C8 Spyder", "price_day": 253, "price_hour": 41, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
13	73	{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
14	74	{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
15	85	{"vehicle": [{"color": ["Indigo", "Orange", "White", "Pink"], "seats": 8, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Lancer Evolution", "price_day": 230, "price_hour": 37, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
16	101	{"vehicle": [{"color": ["Black", "Pink", "Indigo", "Grey"], "seats": 8, "car_make": "Mercedes-Benz", "quantity": 7, "car_model": "400SEL", "price_day": 153, "price_hour": 45, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
17	102	{"vehicle": [{"color": ["Indigo", "Grey", "Silver", "Orange"], "seats": 2, "car_make": "Buick", "quantity": 6, "car_model": "Coachbuilder", "price_day": 270, "price_hour": 21, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
18	108	{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
19	112	{"vehicle": [{"color": ["White", "Indigo", "Orange", "Purple"], "seats": 2, "car_make": "Dodge", "quantity": 5, "car_model": "Durango", "price_day": 298, "price_hour": 24, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
20	118	{"vehicle": [{"color": ["Black", "Pink", "Orange", "Purple"], "seats": 6, "car_make": "GMC", "quantity": 6, "car_model": "1500", "price_day": 206, "price_hour": 18, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
21	125	{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
22	127	{"vehicle": [{"color": ["Pink", "Orange", "White", "Black"], "seats": 2, "car_make": "Ford", "quantity": 5, "car_model": "Explorer", "price_day": 149, "price_hour": 35, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
23	130	{"vehicle": [{"color": ["Pink", "Silver", "Orange", "White"], "seats": 6, "car_make": "Ford", "quantity": 7, "car_model": "Focus", "price_day": 195, "price_hour": 15, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00
24	136	{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}	04.08.2020 00:00:00