	Job ID	Proposal ID	Customer Created	Date_Sold	Permit Packet Completed	Survey Date	Permit Submitted	Install Date	company_name	last_status_update	...	NoCancel	Cash PPC	Cash Permit	Cash Install	AutoDateSold	HistoricalSystemSize	AdPaid	Setter Location	company_location	Cancelled_Milestone
0	153900	198136	2019-04-09 12:53:07	0	2019-04-09 13:20:45	0	0	0	Encor Solar	2020-09-17 14:53:00	...	0	0	0	0	2019-04-09 00:33:20	0.000	0.0	NaN	Encor Solar	NaN
1	223916	313191	2019-09-14 11:17:00	0	2019-09-19 16:39:40	0	2019-09-19 18:06:15	2019-10-11 15:39:33	Encor Solar	2021-04-27 09:24:39	...	0	0	0	0	2019-09-17 00:26:40	7.150	1.0	Encor - Austin, TX	Encor Solar	NaN
2	214656	296126	2019-08-26 23:45:00	0	0	2019-10-08 09:34:40	0	0	Encor Solar	2020-01-09 10:33:37	...	0	0	0	0	0	9.920	0.0	NaN	Encor Solar	NaN
3	231358	324059	2019-09-30 18:39:40	0	2019-10-03 17:54:34	0	0	0	Encor Solar	2019-10-07 12:52:58	...	0	0	0	0	0	8.680	0.0	Encor - Austin, TX	Encor Solar	NaN
4	224679	313245	2019-09-16 18:08:00	0	2019-09-19 10:52:09	0	2019-09-19 18:19:27	2019-11-05 16:14:35	Encor Solar	2019-12-20 16:09:41	...	0	0	0	0	2019-09-17 00:26:40	9.300	1.0	Encor - Charlotte, NC	Encor Solar	NaN
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
5635	94336	95002	2018-09-26 17:23:00	2018-10-04 16:16:22	2018-10-26 09:44:06	0	2018-11-20 15:07:29	2019-02-05 13:05:02	Encor Solar	2019-06-12 10:45:19	...	0	0	0	0	2018-10-04 16:16:22	5.015	1.0	NaN	Encor Solar	NaN
5636	91926	125294	2018-09-18 14:35:00	2018-09-24 12:11:30	2018-10-04 10:23:13	0	2018-10-12 11:37:24	2019-02-13 12:20:24	Encor Solar	2021-07-29 10:56:38	...	0	0	0	0	2018-09-24 12:11:30	8.410	1.0	Encor - Austin, TX	Encor Solar	NaN
5637	89238	134358	2018-09-07 14:40:00	2018-09-14 15:56:57	2018-09-24 18:29:21	0	2019-01-08 09:39:05	2019-02-05 14:56:41	Encor Solar	2019-02-11 15:40:08	...	0	0	0	0	2018-09-14 15:56:57	10.800	1.0	Encor - Austin, TX	Encor Solar	NaN
5638	78646	115701	2018-07-17 18:17:00	2018-07-18 20:46:41	0	0	0	2018-11-13 15:18:03	Encor Solar	2020-09-02 15:37:00	...	0	0	0	0	2018-07-18 20:46:41	6.670	0.0	Encor - Austin, TX	Encor Solar	NaN
5639	74497	130256	2018-06-22 11:29:00	2018-06-23 00:04:55	0	2018-07-18 17:13:35	2019-01-30 15:37:22	2019-03-05 16:17:20	Encor Solar	2019-11-08 15:37:36	...	0	0	0	0	2018-06-23 00:04:55	11.000	1.0	NaN	Encor Solar	NaN

5640 rows × 89 columns