Invoices Data

dataset with several columns related to invoices

@kaggle.ghassenkhaled_invoices_data

Table List

1 table(327.07 KB)

Newest Invoices Data

@kaggle.ghassenkhaled_invoices_data.newest_invoices_data

327.07 KB
10000 rows
11 columns

id_invoice Id Invoice	issueddate IssuedDate	country Country	service Service	total Total	discount Discount	tax Tax	invoicestatus InvoiceStatus	balance Balance	duedate DueDate	client Client
67	Mon Jul 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Cuba	AI Solution	8685.46	48.85	593.26	Paid	9229.87	Thu Aug 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Company B
57	Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Uruguay	Mobile App Development	3196.11	437.68	131.34	Pending	2889.77	Wed Oct 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Company A
79	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Liberia	UI/UX Design	294.28	48.23	7.74	Overdue	253.79	Tue Aug 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Company D
96	Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Mongolia	Mobile App Development	2720.38	469.24	164.15	Overdue	2415.29	Fri Dec 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Company D
87	Thu Mar 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Cyprus	E-commerce Development	2202.77	410.17	214.34	Pending	2006.94	Tue Apr 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Company D
94	Fri Feb 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	New Caledonia	E-commerce Development	2700.06	153.57	31.26	Paid	2577.75	Sat Feb 18 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Company B
67	Sun May 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Montenegro	AI Solution	4154.94	298.87	177.2	Overdue	4033.27	Tue May 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Company C
88	Mon Feb 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Kiribati	Web Development	845.23	35.66	34.76	Paid	844.33	Mon Mar 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Company C
26	Sun Aug 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Chile	AI Solution	5853.75	737.08	104.72	Overdue	5221.39	Sat Sep 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Company A
40	Sun Apr 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Anguilla	E-commerce Development	1546.54	280.52	134.35	Overdue	1400.37	Sun May 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Company C


CREATE TABLE newest_invoices_data (
  "id_invoice" BIGINT,
  "issueddate" TIMESTAMP,
  "country" VARCHAR,
  "service" VARCHAR,
  "total" DOUBLE,
  "discount" DOUBLE,
  "tax" DOUBLE,
  "invoicestatus" VARCHAR,
  "balance" DOUBLE,
  "duedate" TIMESTAMP,
  "client" VARCHAR
);