Transjakarta - Public Transportation Transaction

Transjakarta April 2023 - Dummy Data generated with Faker

@kaggle.dikisahkan_transjakarta_transportation_transaction

Table List

2 tables(10.5 MB)

Dftransjakarta180krows

@kaggle.dikisahkan_transjakarta_transportation_transaction.dftransjakarta180krows

8.77 MB
189500 rows
22 columns

transid TransID	paycardid PayCardID	paycardbank PayCardBank	paycardname PayCardName	paycardsex PayCardSex	paycardbirthdate PayCardBirthDate	corridorid CorridorID	corridorname CorridorName	direction Direction	tapinstops TapInStops	tapinstopsname TapInStopsName	tapinstopslat TapInStopsLat	tapinstopslon TapInStopsLon	stopstartseq StopStartSeq	tapintime TapInTime	tapoutstops TapOutStops	tapoutstopsname TapOutStopsName	tapoutstopslat TapOutStopsLat	tapoutstopslon TapOutStopsLon	stopendseq StopEndSeq	tapouttime TapOutTime	payamount PayAmount
VRPJ892P3M98RA	3561407960318444	dki	Dr. Janet Nashiruddin, M.Ak	M	2010	4	Pulo Gadung 2 - Tosari	1	P00167	Pemuda Rawamangun	-6.193488	106.89165	12	Mon Apr 03 2023 06:53:02 GMT+0000 (Coordinated Universal Time)	P00127	Layur	-6.193539	106.89909	13	Mon Apr 03 2023 07:13:28 GMT+0000 (Coordinated Universal Time)	3500
ZWCH834I6M26HS	347728053419394	emoney	Balamantri Rahayu	M	2002	JAK.28	Kp. Rambutan - Taman Wiladatika	1	B04633P	Sekolah Islam PB Soedirman	-6.314293	106.86298	27	Mon Apr 03 2023 05:59:19 GMT+0000 (Coordinated Universal Time)	B00865P	Jln. Ar Ridho	-6.308148	106.86935	30	Mon Apr 03 2023 06:57:06 GMT+0000 (Coordinated Universal Time)
YRLD835V6L82GO	377105453850671	emoney	Dian Mustofa	F	1993	B13	Bekasi Barat - Blok M	1	B02192P	Mall Metropolitan	-6.247861	106.99215	6	Mon Apr 03 2023 05:13:24 GMT+0000 (Coordinated Universal Time)	B00108P	Bandar Djakarta Bekasi	-6.227085	106.99683	9	Mon Apr 03 2023 06:01:23 GMT+0000 (Coordinated Universal Time)	20000
ZZBX143N6N83HQ	4486493302356581	dki	Cut Janet Suryatmi, M.Ak	M	1980	8K	Batusari - Grogol	1	B03637P	Sbr. Jln. Angsana Kemanggisan	-6.194813	106.78213	16	Mon Apr 03 2023 05:20:24 GMT+0000 (Coordinated Universal Time)	nan	Yayasan Alkahfi Jakbar	-6.198896	106.76889	26	Mon Apr 03 2023 06:01:25 GMT+0000 (Coordinated Universal Time)	3500
EWEG491A2W45DR	30139379978125	bni	dr. Mulyanto Pudjiastuti, M.Ak	F	1997	nan	nan		nan	BRI Menteng	-6.186792	106.83514	2	Mon Apr 03 2023 06:00:54 GMT+0000 (Coordinated Universal Time)	B02755P	Perpustakaan Nasional	-6.180673	106.82643	5	Mon Apr 03 2023 06:47:32 GMT+0000 (Coordinated Universal Time)	3500
KTGG277R2I90ZB	30394281967910	bni	Dasa Prakasa, S.I.Kom	F	1993	JAK.117	Tanjung Priok - Tanah Merdeka	1	B04272P	Sbr. RPTRA Radar Pembangunan	-6.120126	106.89638	17	Mon Apr 03 2023 05:06:00 GMT+0000 (Coordinated Universal Time)	B04818P	Simpang Gotong Royong 2	-6.125482	106.89331	21	Mon Apr 03 2023 05:41:04 GMT+0000 (Coordinated Universal Time)
VSJU956Z4T24LI	4974829151599657	dki	Elvina Hasanah	M	1966	9F	Rusun Tambora - Pluit		P00090	Jembatan Dua	-6.143279	106.79352	5	Mon Apr 03 2023 06:21:07 GMT+0000 (Coordinated Universal Time)	P00170	Penjaringan	-6.126306	106.79203	7	Mon Apr 03 2023 06:52:58 GMT+0000 (Coordinated Universal Time)
HBMD368H3K77KW	3532177104809428	dki	Perkasa Prakasa, M.Pd	F	2011	JAK.31	Blok M - Andara		B00042P	Andara Margasatwa 1	-6.313471	106.80369	55	Mon Apr 03 2023 06:34:03 GMT+0000 (Coordinated Universal Time)	B01147P	Jln. H. Terin Pangkalan Jati	-6.327961	106.80054	56	Mon Apr 03 2023 07:32:53 GMT+0000 (Coordinated Universal Time)
SQHG432Q6Z10BR	3537522260639116	dki	Ayu Wahyudin	F	2009	JAK.37	Cililitan - Condet via Kayu Manis	1	B05218P	Simpang Waru Tengah	-6.293301	106.85862	10	Mon Apr 03 2023 05:48:17 GMT+0000 (Coordinated Universal Time)	B00405P	Gg. Ani Raya Condet	-6.266674	106.86054	37	Mon Apr 03 2023 06:13:38 GMT+0000 (Coordinated Universal Time)
EHWL093H6L20UL	4677151756111287186	brizzi	H. Xanana Santoso, S.Farm	M	2010	JAK.15	Bulak Turi - Tanjung Priok		B01327P	Jln. Lorong 5	-6.107716	106.8955	46	Mon Apr 03 2023 05:09:13 GMT+0000 (Coordinated Universal Time)	B05728P	Term. Tj. Priok 1	-6.1098	106.88118	52	Mon Apr 03 2023 06:07:24 GMT+0000 (Coordinated Universal Time)


CREATE TABLE dftransjakarta180krows (
  "transid" VARCHAR,
  "paycardid" BIGINT,
  "paycardbank" VARCHAR,
  "paycardname" VARCHAR,
  "paycardsex" VARCHAR,
  "paycardbirthdate" BIGINT,
  "corridorid" VARCHAR,
  "corridorname" VARCHAR,
  "direction" DOUBLE,
  "tapinstops" VARCHAR,
  "tapinstopsname" VARCHAR,
  "tapinstopslat" DOUBLE,
  "tapinstopslon" DOUBLE,
  "stopstartseq" BIGINT,
  "tapintime" TIMESTAMP,
  "tapoutstops" VARCHAR,
  "tapoutstopsname" VARCHAR,
  "tapoutstopslat" DOUBLE,
  "tapoutstopslon" DOUBLE,
  "stopendseq" DOUBLE,
  "tapouttime" TIMESTAMP,
  "payamount" DOUBLE
);