Skip to content

Instantly share code, notes, and snippets.

@bogdan

bogdan/gist:bd962f3bb04e893ea172

Created January 28, 2016 12:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bogdan/bd962f3bb04e893ea172 to your computer and use it in GitHub Desktop.
Save bogdan/bd962f3bb04e893ea172 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
+-----------+--------------+---------+----------+------------------+------------------+------------------+------------------+-------------------+------------+-----------+--------+----------+-------------------+------------------+
| id | order_number | site_id | subtotal | order_date | ip_address | internal_ip_a... | created_at | updated_at | visitor_id | person_id | is_new | type | traffic_source_id | event_categor... |
+-----------+--------------+---------+----------+------------------+------------------+------------------+------------------+-------------------+------------+-----------+--------+----------+-------------------+------------------+
| 95709621 | 489437 | 8269 | 153813.0 | 2015-09-13 00... | | | 2015-09-13 00... | 2015-09-17 05:... | | 38436040 | false | Purchase | 16893 | 16044 |
| 95711237 | 491641 | 8269 | 63945.0 | 2015-09-13 00... | | | 2015-09-13 00... | 2015-09-17 05:... | | 37873871 | false | Purchase | 16893 | 16044 |
| 95709220 | 488972 | 8269 | 56967.0 | 2015-09-13 00... | | | 2015-09-13 00... | 2015-09-17 05:... | | 39782198 | true | Purchase | 16893 | 16044 |
| 95709941 | 489802 | 8269 | 47017.0 | 2015-09-13 00... | | | 2015-09-13 00... | 2015-09-17 05:... | | 40291914 | true | Purchase | 16893 | 16044 |
| 96262134 | 494904 | 8269 | 1684.15 | 2015-09-22 13... | 205.121.112.211 | | 2015-09-22 13... | 2015-09-22 13:... | 97637485 | 40591065 | true | Purchase | 16893 | 16044 |
| 101083186 | 505405 | 8269 | 1619.04 | 2015-10-20 00... | | | 2015-10-20 00... | 2015-10-26 10:... | | 36206249 | false | Purchase | 16893 | 16044 |
| 86983666 | 455296 | 8269 | 1504.1 | 2015-07-07 14... | 2601:2c7:8300... | 10.0.0.3 | 2015-07-07 14... | 2015-07-07 14:... | 88717937 | 36026491 | true | Purchase | 16893 | 16044 |
| 92236002 | 480035 | 8269 | 1495.87 | 2015-08-19 12... | 24.20.223.151 | | 2015-08-19 12... | 2015-08-19 12:... | 93734960 | 38501429 | false | Purchase | 16893 | 16044 |
| 101078158 | 494939 | 8269 | 1376.9 | 2015-09-22 00... | | | 2015-09-22 00... | 2015-12-02 06:... | | 39394853 | false | Purchase | 16893 | 16044 |
| 113009521 | 522425 | 8269 | 1200.0 | 2015-12-11 11... | | | 2015-12-11 11... | 2015-12-11 11:... | | 47004369 | true | Purchase | 16893 | 16044 |
| 87410425 | 458580 | 8269 | 1136.25 | 2015-07-11 09... | 65.28.41.101 | 192.168.1.9 | 2015-07-11 09... | 2015-07-11 09:... | 89127813 | 36214049 | false | Purchase | 16893 | 16044 |
| 112891546 | 522304 | 8269 | 1064.07 | 2015-12-10 23... | | | 2015-12-10 23... | 2015-12-10 23:... | | 46960431 | true | Purchase | 16893 | 16044 |
| 108546338 | 518902 | 8269 | 995.19 | 2015-11-29 09... | | | 2015-11-29 09... | 2015-11-29 09:... | | 45347116 | true | Purchase | 16893 | 16044 |
| 115566869 | 523883 | 8269 | 992.12 | 2015-12-18 12... | | | 2015-12-18 12... | 2015-12-18 12:... | | 47885073 | true | Purchase | 16893 | 16044 |
| 97898432 | 498936 | 8269 | 956.82 | 2015-10-03 18... | 209.83.33.149 | | 2015-10-03 18... | 2015-10-03 18:... | 99122108 | 41328635 | false | Purchase | 16893 | 16044 |
| 93193379 | 483930 | 8269 | 946.8 | 2015-08-27 10... | 140.90.71.101 | | 2015-08-27 10... | 2015-08-27 10:... | 94644253 | 38983651 | false | Purchase | 16893 | 16044 |
| 106415157 | 515575 | 8269 | 931.96 | 2015-11-22 20... | | | 2015-11-22 20... | 2015-11-22 20:... | | 36799192 | false | Purchase | 16893 | 16044 |
| 102677262 | 509196 | 8269 | 906.52 | 2015-11-06 05... | | | 2015-11-06 05... | 2015-11-06 05:... | | 43337806 | false | Purchase | 16893 | 16044 |
| 91646237 | 477464 | 8269 | 890.35 | 2015-08-14 11... | 70.109.136.137 | | 2015-08-14 11... | 2015-08-14 11:... | 93176933 | 36761045 | false | Purchase | 16893 | 16044 |
| 101081315 | 502587 | 8269 | 883.94 | 2015-10-13 00... | | | 2015-10-13 00... | 2015-10-26 10:... | | 38501429 | false | Purchase | 16893 | 16044 |
| 95710829 | 490824 | 8269 | 876.82 | 2015-09-13 00... | | | 2015-09-13 00... | 2015-09-17 05:... | | 40047669 | true | Purchase | 16893 | 16044 |
| 96136560 | 494608 | 8269 | 872.35 | 2015-09-21 11... | 96.250.41.57 | 192.168.1.10 | 2015-09-21 11... | 2015-09-21 11:... | 97516131 | 40527227 | false | Purchase | 16893 | 16044 |
| 117274170 | 527108 | 8269 | 854.3 | 2015-12-27 12... | | | 2015-12-27 12... | 2015-12-27 12:... | | 48511252 | true | Purchase | 16893 | 16044 |
| 91060238 | 474925 | 8269 | 840.35 | 2015-08-09 17... | 24.34.201.163 | 192.168.1.77 | 2015-08-09 17... | 2015-08-09 17:... | 92613442 | 36799192 | false | Purchase | 16893 | 16044 |
| 96124773 | 494564 | 8269 | 828.35 | 2015-09-21 10... | 72.214.42.45 | | 2015-09-21 10... | 2015-09-21 10:... | 95947174 | 40521140 | true | Purchase | 16893 | 16044 |
| 94314892 | 487231 | 8269 | 821.3 | 2015-09-04 12... | 174.61.78.171 | | 2015-09-04 12... | 2015-09-04 12:... | 95725245 | 39548584 | true | Purchase | 16893 | 16044 |
| 89336939 | 468800 | 8269 | 809.03 | 2015-07-27 20... | 2601:140:8100... | 10.0.0.12 | 2015-07-27 20... | 2015-07-27 20:... | 90889615 | 37035727 | false | Purchase | 16893 | 16044 |
| 102320202 | 506298 | 8269 | 805.07 | 2015-10-24 00... | | | 2015-10-24 00... | 2015-11-04 05:... | | 43205105 | false | Purchase | 16893 | 16044 |
| 101078177 | 495044 | 8269 | 802.35 | 2015-09-23 00... | | | 2015-09-23 00... | 2015-12-02 06:... | | 42685021 | true | Purchase | 16893 | 16044 |
| 123656628 | 536142 | 8269 | 781.45 | 2016-01-27 07... | | | 2016-01-27 07... | 2016-01-27 07:... | | 50523128 | true | Purchase | 16893 | 16044 |
| 92311071 | 480253 | 8269 | 764.05 | 2015-08-20 07... | 38.97.84.180 | | 2015-08-20 07... | 2015-08-20 07:... | 93809014 | 38540715 | true | Purchase | 16893 | 16044 |
| 120603999 | 530835 | 8269 | 737.0 | 2016-01-11 15... | | | 2016-01-11 15... | 2016-01-11 15:... | | 49521003 | false | Purchase | 16893 | 16044 |
| 106014372 | 514966 | 8269 | 735.35 | 2015-11-21 11... | | | 2015-11-21 11... | 2015-11-21 11:... | | 43337806 | false | Purchase | 16893 | 16044 |
| 93407447 | 484533 | 8269 | 724.9 | 2015-08-29 06... | 71.54.50.220 | | 2015-08-29 06... | 2015-08-29 06:... | 94859429 | 39099911 | true | Purchase | 16893 | 16044 |
| 88282648 | 463543 | 8269 | 723.5 | 2015-07-19 07... | 2601:146:c001... | 10.0.0.14 | 2015-07-19 07... | 2015-07-19 07:... | 89935160 | 36593308 | true | Purchase | 16893 | 16044 |
| 97544151 | 497971 | 8269 | 721.92 | 2015-09-30 21... | 68.84.20.110 | | 2015-09-30 21... | 2015-09-30 21:... | 98787664 | 37205170 | false | Purchase | 16893 | 16044 |
| 96694141 | 385599 | 8269 | 719.45 | 2015-09-25 18... | 71.87.33.204 | 192.168.1.5 | 2015-09-25 18... | 2015-09-25 18:... | 98043723 | 40808654 | false | Purchase | 16893 | 16044 |
| 93154481 | 483824 | 8269 | 714.3 | 2015-08-27 01... | 205.185.223.36 | 172.20.33.85 | 2015-08-27 01... | 2015-08-27 01:... | 94607383 | 38964161 | true | Purchase | 16893 | 16044 |
| 123374226 | 535853 | 8269 | 702.6 | 2016-01-26 00... | | | 2016-01-26 00... | 2016-01-26 00:... | | 36799192 | false | Purchase | 16893 | 16044 |
| 99451448 | 502979 | 8269 | 676.95 | 2015-10-14 15... | 72.34.128.250 | | 2015-10-14 15... | 2015-10-14 15:... | 100533014 | 42012917 | false | Purchase | 16893 | 16044 |
| 88594736 | 464889 | 8269 | 667.4 | 2015-07-21 17... | 96.246.41.231 | 192.168.3.15 | 2015-07-21 17... | 2015-07-21 17:... | 90217313 | 36723896 | true | Purchase | 16893 | 16044 |
| 93557251 | 484958 | 8269 | 657.45 | 2015-08-30 10... | 2604:2000:812... | 192.168.0.3 | 2015-08-30 10... | 2015-08-30 10:... | 95002296 | 37127264 | false | Purchase | 16893 | 16044 |
| 101081781 | 503255 | 8269 | 656.94 | 2015-10-15 00... | | | 2015-10-15 00... | 2015-10-26 10:... | | 42686030 | true | Purchase | 16893 | 16044 |
| 114092114 | 523053 | 8269 | 654.38 | 2015-12-14 10... | | | 2015-12-14 10... | 2015-12-14 10:... | | 37819474 | false | Purchase | 16893 | 16044 |
| 115395350 | 523753 | 8269 | 647.7 | 2015-12-17 21... | | | 2015-12-17 21... | 2015-12-17 22:... | 114880781 | 36799192 | false | Purchase | 16893 | 16044 |
| 93161372 | 483846 | 8269 | 638.4 | 2015-08-27 05... | 205.185.223.40 | 172.20.33.85 | 2015-08-27 05... | 2015-08-27 05:... | 94607383 | 38966913 | true | Purchase | 16893 | 16044 |
| 90067765 | 471916 | 8269 | 636.75 | 2015-08-01 21... | 71.91.163.178 | | 2015-08-01 21... | 2015-08-01 21:... | 91582035 | 37403306 | false | Purchase | 16893 | 16044 |
| 95710303 | 490219 | 8269 | 627.52 | 2015-09-13 00... | | | 2015-09-13 00... | 2015-09-17 05:... | | 37035727 | false | Purchase | 16893 | 16044 |
| 92190699 | 479847 | 8269 | 624.45 | 2015-08-19 05... | 73.163.169.4 | | 2015-08-19 05... | 2015-08-19 05:... | 93693248 | 36463080 | false | Purchase | 16893 | 16044 |
| 95703566 | 404571 | 8269 | 622.16 | 2015-09-17 01... | 108.14.202.124 | | 2015-09-17 01... | 2015-09-17 01:... | 97086983 | 37373358 | false | Purchase | 16893 | 16044 |
| 88233742 | 463267 | 8269 | 608.27 | 2015-07-18 15... | 2602:304:b012... | | 2015-07-18 15... | 2015-07-18 15:... | 89889601 | 36575064 | false | Purchase | 16893 | 16044 |
| 121620343 | 532698 | 8269 | 604.72 | 2016-01-17 04... | | | 2016-01-17 04... | 2016-01-17 04:... | | 42066081 | false | Purchase | 16893 | 16044 |
| 90865164 | 474301 | 8269 | 603.4 | 2015-08-07 13... | 208.49.194.161 | 192.168.1.109 | 2015-08-07 13... | 2015-08-07 13:... | 92399131 | 37819474 | false | Purchase | 16893 | 16044 |
| 102677598 | 509503 | 8269 | 600.09 | 2015-11-06 05... | | | 2015-11-06 05... | 2015-11-06 05:... | | 36281875 | false | Purchase | 16893 | 16044 |
| 96081785 | 494404 | 8269 | 599.45 | 2015-09-20 20... | 108.4.11.181 | | 2015-09-20 20... | 2015-09-20 20:... | 97463651 | 40500833 | false | Purchase | 16893 | 16044 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment