Transjakarta - Public Transportation Transaction

Transjakarta April 2023 - Dummy Data generated with Faker

@kaggle.dikisahkan_transjakarta_transportation_transaction

Table List

2 tables(10.5 MB)

Dftransjakarta

@kaggle.dikisahkan_transjakarta_transportation_transaction.dftransjakarta

1.73 MB
37900 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
EIIW227B8L34VB	180062659848800	emoney	Bajragin Usada	M	2008	5	Matraman Baru - Ancol	1	P00142	Pal Putih	-6.184631	106.84402	7	Mon Apr 03 2023 05:21:44 GMT+0000 (Coordinated Universal Time)	P00253	Tegalan	-6.203101	106.85715	12	Mon Apr 03 2023 06:00:53 GMT+0000 (Coordinated Universal Time)	3500
LGXO740D2N47GZ	4885331907664776	dki	Gandi Widodo	F	1997	6C	Stasiun Tebet - Karet via Patra Kuningan		B01963P	Kemenkes 2	-6.2287	106.83302	13	Mon Apr 03 2023 05:42:44 GMT+0000 (Coordinated Universal Time)	B03307P	Sampoerna Strategic	-6.217152	106.81892	21	Mon Apr 03 2023 06:40:01 GMT+0000 (Coordinated Universal Time)	3500
DJWR385V2U57TO	4996225095064169	dki	Emong Wastuti	F	1992	R1A	Pantai Maju - Kota		B00499P	Gg. Kunir II	-6.133132	106.81435	38	Mon Apr 03 2023 05:59:06 GMT+0000 (Coordinated Universal Time)	B04962P	Simpang Kunir Kemukus	-6.133731	106.81475	39	Mon Apr 03 2023 06:50:55 GMT+0000 (Coordinated Universal Time)	3500
JTUZ800U7C86EH	639099174703	flazz	Surya Wacana	F	1978	11D	Pulo Gebang - Pulo Gadung 2 via PIK		B05587P	Taman Elok 1	-6.195743	106.93526	23	Mon Apr 03 2023 05:44:51 GMT+0000 (Coordinated Universal Time)	B03090P	Raya Penggilingan	-6.183068	106.93194	29	Mon Apr 03 2023 06:28:16 GMT+0000 (Coordinated Universal Time)	3500
VMLO535V7F95NJ	570928206772	flazz	Embuh Mardhiyah	M	1982	12	Tanjung Priok - Pluit		P00239	Sunter Boulevard Barat	-6.14965	106.889	5	Mon Apr 03 2023 06:17:35 GMT+0000 (Coordinated Universal Time)	P00098	Kali Besar Barat	-6.135355	106.81143	15	Mon Apr 03 2023 06:57:03 GMT+0000 (Coordinated Universal Time)	3500
DDES630K2F80KC	2251412124634980	dki	Tirta Siregar	F	1993	1T	Cibubur - Balai Kota		B00127P	Benhil 3	-6.21601	106.81632	3	Mon Apr 03 2023 05:08:01 GMT+0000 (Coordinated Universal Time)	B00694P	Grand Sahid	-6.210975	106.82059	6	Mon Apr 03 2023 05:52:25 GMT+0000 (Coordinated Universal Time)	20000
HEMW326B9N91TV	213155822653833	emoney	R. Devi Hariyah, S.T.	M	1974	JAK.18	Kalibata - Kuningan		B00243P	Cervino Village	-6.224355	106.85165	25	Mon Apr 03 2023 06:58:21 GMT+0000 (Coordinated Universal Time)	nan	nan
XTKE052E5E87LN	3587341902618993	dki	Darmanto Rajasa	F	1991	nan	nan	1	B03416P	SDN Pondok Labu 11	-6.313269	106.80221	2	Mon Apr 03 2023 06:44:24 GMT+0000 (Coordinated Universal Time)	B00899P	Jln. Baros	-6.311046	106.784	12	Mon Apr 03 2023 07:11:43 GMT+0000 (Coordinated Universal Time)
OIHS248V7S72EB	6510013988638519	dki	Cagak Maheswara, S.Sos	F	1992	B14	Bekasi Barat - Kuningan	1	B00795P	Imperium	-6.210363	106.83059	1	Mon Apr 03 2023 06:01:44 GMT+0000 (Coordinated Universal Time)	B01853P	Kayuringin 2	-6.245948	106.99247	16	Mon Apr 03 2023 06:51:12 GMT+0000 (Coordinated Universal Time)	20000
ERXO372B2H63RB	3580401035990896	dki	T. Dadap Pradana, M.Ak	M	2004	1Q	Rempoa - Blok M		B05781P	TPU Bungur	-6.247208	106.77889	15	Mon Apr 03 2023 05:57:47 GMT+0000 (Coordinated Universal Time)	B06578P	Blok M Jalur 3	-6.243426	106.80188	24	Mon Apr 03 2023 06:51:12 GMT+0000 (Coordinated Universal Time)	3500


CREATE TABLE dftransjakarta (
  "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
);