Transjakarta - Public Transportation Transaction
Transjakarta April 2023 - Dummy Data generated with Faker
@kaggle.dikisahkan_transjakarta_transportation_transaction
Transjakarta April 2023 - Dummy Data generated with Faker
@kaggle.dikisahkan_transjakarta_transportation_transaction
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
);
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
);
Anyone who has the link will be able to view this.