November 7, 2022 at 9:37 PM
I am going through my data that I have had for a while. I am releasing the database for "localshop.vn".
15K phone numbers with some other info.
15K phone numbers with some other info.
Sample db layout
Sample
download here
id merchant_id user_id discount amount phone_number serial_number status pay_status pay_request_id pay_transaction_id pay_error_code pay_failed_message pay_response_data created_at updated_at created_by updated_by telecom_code topup_request_id topup_error_code topup_failed_message topup_response_dataSample
17004 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 1350 28650 911111111 1 13744900 0 2022-05-12 10:09:20.302 2022-05-12 10:10:07.802 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc VINA 7346_20220512170948_1a75b737-576a-4bb0-8a71-e32830440a13
17005 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 4500 95500 911111111 0 1 2022-05-12 10:10:42.635 2022-05-12 10:10:42.635 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc VINA
17006 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 4500 95500 911111111 1 13744915 0 2022-05-12 10:11:54.886 2022-05-12 10:12:35.603 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc VINA 7346_20220512171224_55da2555-4acf-4e24-ab79-a7926b795482
17007 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 9000 191000 911111112 2 13744924 0 2022-05-12 10:13:51.377 2022-05-20 06:30:10.650 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc VINA 7346_20220512171426_f223bad8-a496-4e06-9f7e-a7c27e8abd7b
17008 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 13500 286500 911111113 0 13744930 0 2022-05-12 10:15:22.817 2022-05-12 10:16:03.847 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc VINA 7346_20220512171553_acb9d6ad-9644-42f3-99ad-7833c1ba4a51
17009 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 450 9550 0 1 2022-05-12 10:16:35.750 2022-05-12 10:16:35.750 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc LCAL
17010 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 900 19100 6101003905311 1 13744938 0 2022-05-12 10:17:32.468 2022-05-12 10:18:03.576 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc LCAL 7346_20220512171803_a6415b2a-871f-49ef-8739-89eacd544d6d
17011 18560 c8668ea7-0618-4616-a557-08f91167eea7 1750 48250 968213564 1 f75974e3-7738-426e-b4e9-56b69cc4b4dc 0 2022-05-12 10:19:37.276 c8668ea7-0618-4616-a557-08f91167eea7 VTEL 7346_20220512171919_d4b7ae02-f2df-4c28-b8ba-15a33c355831 0
17012 18560 c8668ea7-0618-4616-a557-08f91167eea7 450 9550 16751000006032 1 c55f621e-2a74-404a-aab7-3df620f059c0 0 2022-05-12 10:20:03.255 c8668ea7-0618-4616-a557-08f91167eea7 MOBI 7346_20220512172003_a887d394-274e-46bb-bec1-3a3810321b45 0
17013 18559 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc 2250 47750 8421004946968 1 13744943 0 2022-05-12 10:20:06.459 2022-05-12 10:20:34.182 d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc d53b17d9-4a0f-4ccc-aa46-a8f9f629afcc MOBI 7346_20220512172033_06185141-9b41-4657-ba48-5432021a8bb4
17014 18560 c8668ea7-0618-4616-a557-08f91167eea7 900 19100 896569596 1 13744947 0 2022-05-12 10:21:57.407 2022-05-12 10:23:42.992 c8668ea7-0618-4616-a557-08f91167eea7 c8668ea7-0618-4616-a557-08f91167eea7 MOBI 7346_20220512172326_1cb3ac45-5807-4822-8971-9c689be7eb6d
17015 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 1050 28950 369780352 1 13744959 0 2022-05-12 10:29:00.944 2022-05-12 10:29:50.062 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL 7346_20220512172931_59774f02-1dbe-4672-b4f3-54d277a98692
17016 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 1750 48250 369780352 1 13744960 0 2022-05-12 10:30:21.382 2022-05-12 10:31:10.631 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL 7346_20220512173052_1cc8ca51-c5bf-48aa-bf19-0d2adb3006e7
17017 18560 c8668ea7-0618-4616-a557-08f91167eea7 1050 28950 369780352 1 13744962 0 2022-05-12 10:31:48.384 2022-05-12 10:32:36.746 c8668ea7-0618-4616-a557-08f91167eea7 c8668ea7-0618-4616-a557-08f91167eea7 VTEL 7346_20220512173217_d554f6a8-ae33-4f1e-abe6-febd4fc19bec
17018 18560 c8668ea7-0618-4616-a557-08f91167eea7 1050 28950 369780352 1 13744963 0 2022-05-12 10:32:57.922 2022-05-12 10:33:44.374 c8668ea7-0618-4616-a557-08f91167eea7 c8668ea7-0618-4616-a557-08f91167eea7 VTEL 7346_20220512173327_5df20402-393a-4933-8026-29ddc577f929
17019 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 1750 48250 0 1 2022-05-12 10:33:21.619 2022-05-12 10:33:21.619 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 LCAL
17020 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 2250 47750 8421004946970 1 13744972 0 2022-05-12 10:35:31.455 2022-05-12 10:36:02.069 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 LCAL 7346_20220512173601_f8a7fb58-cd57-4465-b8db-add926a28123
17021 18560 c8668ea7-0618-4616-a557-08f91167eea7 900 19100 6101003905279 1 feb3ddee-a922-4755-bd24-debfbe5f4db1 0 2022-05-12 10:49:54.868 c8668ea7-0618-4616-a557-08f91167eea7 MOBI 7346_20220512174954_1e78ec8d-128d-4242-bb36-db2f89e6eba3 0
17022 18560 c8668ea7-0618-4616-a557-08f91167eea7 700 19300 347071558 1 df15edfd-9423-4a1b-a960-d73a22550e6f 0 2022-05-12 10:50:40.263 c8668ea7-0618-4616-a557-08f91167eea7 VTEL 7346_20220512175023_301339ee-f230-4b44-97cf-4b004bb42374 0
17023 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 10500 289500 369780352 0 1 2022-05-12 11:21:01.090 2022-05-12 11:21:01.090 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL
17024 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 3500 96500 369780352 0 1 2022-05-12 11:21:58.273 2022-05-12 11:21:58.273 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL
17025 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 1050 28950 369780352 1 13745040 0 2022-05-12 11:27:51.559 2022-05-12 11:28:39.906 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL 7346_20220512182831_b14ba209-4545-4271-a36c-4437d9d99c30
17026 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 4500 95500 8281001917361 1 13745043 0 2022-05-12 11:30:01.122 2022-05-12 11:30:36.733 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 LCAL 7346_20220512183029_9d849464-c85a-4423-8edc-643ba7e7b844
17027 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 4500 95500 911111111 1 13745046 0 2022-05-12 11:33:40.127 2022-05-12 11:34:30.999 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VINA 7346_20220512183419_014be2d1-b242-401c-a2db-90e1a3ee4f45
17028 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 4500 95500 911111113 0 13745049 0 2022-05-12 11:35:28.256 2022-05-12 11:36:35.579 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VINA 7346_20220512183625_94bb9926-29a5-4ab4-8854-302f39a271af
17029 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 10500 289500 369780352 1 13745050 0 2022-05-12 11:37:38.329 2022-05-12 11:38:30.190 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL 7346_20220512183813_a363ac4c-b907-45f8-9795-4bffbdc80593
17030 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 4500 95500 911111111 1 13745052 0 2022-05-12 11:39:11.045 2022-05-12 11:40:10.703 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VINA 7346_20220512183952_2d8f4451-78a7-4ddb-aaea-d385b12f9a7e
17031 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 1350 28650 911111111 1 13745054 0 2022-05-12 11:41:37.601 2022-05-12 11:42:13.521 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VINA 7346_20220512184208_cd45f2c0-c3e4-4247-8e82-2cb7373fc141
17032 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 4500 95500 8281001917375 1 13745055 0 2022-05-12 11:43:24.371 2022-05-12 11:44:00.274 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 LCAL 7346_20220512184400_2e144da3-f461-44ce-8c44-614ec0798baf
17033 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 10500 289500 369780352 1 13745124 0 2022-05-12 13:34:15.770 2022-05-12 13:35:10.014 291b83a5-4396-4f6c-af61-1569c5bfcb01 291b83a5-4396-4f6c-af61-1569c5bfcb01 VTEL 7346_20220512203453_875894d7-5348-4ee2-9a8d-d36f4476d811
17034 18488 291b83a5-4396-4f6c-af61-1569c5bfcb01 13500 286500 921111111 0 1 2022-05-12 13:38:27.120 291b83a5-4396-4f6c-af61-1569c5bfcb01 HTEL
download here
