Invoices Dataset

Invoices datasets contains randomly generate data using Faker package in Python

@kaggle.cankatsrc_invoices

Table List

1 table(820.97 KB)

Invoices

@kaggle.cankatsrc_invoices.invoices

820.97 KB
10000 rows
11 columns

first_name First Name	last_name Last Name	email Email	product_id Product Id	qty Qty	amount Amount	invoice_date Invoice Date	address Address	city City	stock_code Stock Code	job Job
Carmen Nixon	Todd Anderson	marvinjackson@example.com	133	9	14.57	Fri Sep 10 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	283 Wendy Common	West Alexander	36239634	Logistics and distribution manager
Mrs. Heather Miller	Julia Moore	jeffrey84@example.net	155	5	65.48	Wed Oct 03 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	13567 Patricia Circles Apt. 751	Andreamouth	2820163	Osteopath
Crystal May	Philip Moody	ugoodman@example.com	151	9	24.66	Tue Mar 23 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	6389 Debbie Island Suite 470	Coxbury	27006726	Economist
Bobby Weber	Mark Scott	ssanchez@example.com	143	4	21.34	Sun Aug 17 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	6362 Ashley Plaza Apt. 994	Ninaland	83036521	Sports administrator
Kristen Welch	David David	cynthia66@example.net	168	2	83.9	Tue Jun 11 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	463 Steven Cliffs Suite 757	Isaiahview	80142652	Chief Marketing Officer
Jamie Garcia	Jonathan Tate	luis57@example.net	192	6	55.67	Thu Sep 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	54443 Kyle Haven Apt. 230	Millsside	53234087	Therapist, sports
Amanda Hicks	Stephanie Huff	hendersontracey@example.org	153	4	77.57	Sat Apr 17 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	5600 Hannah Vista	Port Susan	30928602	Special educational needs teacher
James Parker	Dustin Hanson Jr.	ffowler@example.net	107	3	86.5	Sat Sep 27 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	9076 Garrett Well	New Heatherfort	45734816	Textile designer
Susan Smith	Michael Campbell	thomaspatricia@example.net	149	1	53.73	Sat Nov 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	1684 John Circles	South Kim	13834685	Psychiatrist
Kylie Campos	Samantha Mendez	danny61@example.com	108	5	91.71	Wed Mar 23 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	15898 Jeanne Inlet Suite 973	West Patricia	92548268	Radio broadcast assistant


CREATE TABLE invoices (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "email" VARCHAR,
  "product_id" BIGINT,
  "qty" BIGINT,
  "amount" DOUBLE,
  "invoice_date" TIMESTAMP,
  "address" VARCHAR,
  "city" VARCHAR,
  "stock_code" BIGINT,
  "job" VARCHAR
);