%matplotlib inline
from matplotlib import pyplot as plt
import sqlalchemy
import pandas as pd
import os.path
from IPython.core.display import display, HTML
engine = sqlalchemy.create_engine(open(os.path.expanduser('~/.sqlconninfo')).read())
z = pd.read_sql('select count(*) from subway_ingest;', engine)
z
count | |
---|---|
0 | 75006861 |
z = pd.read_sql('select ca, unit, scp, station, linename from subway_ingest;', engine)
z
ca | |
---|---|
0 | R229 |
1 | R229 |
2 | R229 |
3 | R229 |
4 | R229 |
5 | R229 |
6 | R229 |
7 | R229 |
8 | R229 |
9 | R229 |
10 | R229 |
11 | R229 |
12 | R229 |
13 | R229 |
14 | R229 |
15 | R229 |
16 | R229 |
17 | R229 |
18 | R229 |
19 | R229 |
20 | R229 |
21 | R229 |
22 | R229 |
23 | R229 |
24 | R229 |
25 | R229 |
26 | R229 |
27 | R229 |
28 | R229 |
29 | R229 |
... | ... |
75006831 | R229 |
75006832 | R229 |
75006833 | R229 |
75006834 | R229 |
75006835 | R229 |
75006836 | R229 |
75006837 | R229 |
75006838 | R229 |
75006839 | R229 |
75006840 | R229 |
75006841 | R229 |
75006842 | R229 |
75006843 | R229 |
75006844 | R229 |
75006845 | R229 |
75006846 | R229 |
75006847 | R229 |
75006848 | R229 |
75006849 | R229 |
75006850 | R229 |
75006851 | R229 |
75006852 | R229 |
75006853 | R229 |
75006854 | R229 |
75006855 | R229 |
75006856 | R229 |
75006857 | R229 |
75006858 | R229 |
75006859 | R229 |
75006860 | R229 |
75006861 rows × 1 columns
z2 = pd.read_sql("select * from subway_ingest where ca='N062' and unit='R011' and scp='01-03-00' ORDER BY endtime;", engine)
z3 = z2[1:].copy()
z3.cumul_entries = z2.cumul_entries.values[1:] - z2.cumul_entries.values[:-1]
z3.cumul_exits = z2.cumul_exits.values[1:] - z2.cumul_exits.values[:-1]
z4 = z3['endtime cumul_entries cumul_exits'.split()].groupby('endtime').sum()
plt.plot(z4.index.values, z4.cumul_entries.values
)
plt.plot(z4.index.values, z4.cumul_exits.values
)
# plt.ylim(0, 700)
plt.xlim('2010-04-01', '2010-06-01')
plt.gcf().set_size_inches(11, 4)
z3.endtime.dtype
dtype('<M8[ns]')
display(HTML(z3.head(200).to_html()))
turnstile_id | endtime | ca | unit | scp | station | linename | division | description | cumul_entries | cumul_exits | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 50620 | 2010-04-17 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 35 | 6 |
2 | 50621 | 2010-04-17 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 26 | 18 |
3 | 50622 | 2010-04-17 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 143 | 74 |
4 | 50623 | 2010-04-17 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 208 | 104 |
5 | 50624 | 2010-04-17 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 230 | 142 |
6 | 50625 | 2010-04-18 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 176 | 103 |
7 | 50626 | 2010-04-18 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 39 | 7 |
8 | 50627 | 2010-04-18 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 22 | 11 |
9 | 50628 | 2010-04-18 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 109 | 69 |
10 | 50629 | 2010-04-18 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 214 | 136 |
11 | 50630 | 2010-04-18 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 246 | 148 |
12 | 50631 | 2010-04-19 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 199 | 55 |
13 | 50632 | 2010-04-19 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 18 | 1 |
14 | 50633 | 2010-04-19 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 273 | 38 |
15 | 50634 | 2010-04-19 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 620 | 84 |
16 | 50635 | 2010-04-19 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 214 | 122 |
17 | 50636 | 2010-04-19 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 369 | 294 |
18 | 50637 | 2010-04-20 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 124 | 41 |
19 | 50638 | 2010-04-20 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 14 | 6 |
20 | 50639 | 2010-04-20 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | RECOVR | 0 | 0 |
21 | 50640 | 2010-04-20 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | AUD | 280 | 20 |
22 | 50641 | 2010-04-20 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 563 | 85 |
23 | 50642 | 2010-04-20 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 200 | 108 |
24 | 50643 | 2010-04-20 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 323 | 305 |
25 | 50644 | 2010-04-21 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 131 | 65 |
26 | 50645 | 2010-04-21 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 7 | 4 |
27 | 50646 | 2010-04-21 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 289 | 22 |
28 | 50647 | 2010-04-21 08:17:06 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 69 | 7 |
29 | 50648 | 2010-04-21 09:14:43 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 272 | 15 |
30 | 50649 | 2010-04-21 09:16:12 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 5 | 0 |
31 | 50650 | 2010-04-21 09:17:33 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 10 | 0 |
32 | 50651 | 2010-04-21 09:18:53 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 5 | 0 |
33 | 50652 | 2010-04-21 09:30:54 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 35 | 4 |
34 | 50653 | 2010-04-21 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 192 | 45 |
35 | 50654 | 2010-04-21 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 216 | 94 |
36 | 50655 | 2010-04-21 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 351 | 330 |
37 | 50656 | 2010-04-22 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 131 | 62 |
38 | 50657 | 2010-04-22 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 7 | 5 |
39 | 50658 | 2010-04-22 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | RECOVR | 0 | 0 |
40 | 50659 | 2010-04-22 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 273 | 30 |
41 | 50660 | 2010-04-22 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 569 | 82 |
42 | 50661 | 2010-04-22 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 246 | 114 |
43 | 50662 | 2010-04-22 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 332 | 288 |
44 | 50663 | 2010-04-23 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 120 | 111 |
45 | 50664 | 2010-04-23 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 13 | 7 |
46 | 50665 | 2010-04-23 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 268 | 25 |
47 | 50666 | 2010-04-23 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 506 | 88 |
48 | 50667 | 2010-04-23 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 227 | 144 |
49 | 50668 | 2010-04-23 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 405 | 343 |
50 | 290327 | 2010-05-01 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 9998 | 4154 |
51 | 290328 | 2010-05-01 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 26 | 13 |
52 | 290329 | 2010-05-01 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 31 | 18 |
53 | 290330 | 2010-05-01 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 119 | 101 |
54 | 290331 | 2010-05-01 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 205 | 159 |
55 | 290332 | 2010-05-01 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 236 | 202 |
56 | 290333 | 2010-05-02 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 268 | 161 |
57 | 290334 | 2010-05-02 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 31 | 12 |
58 | 290335 | 2010-05-02 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 19 | 9 |
59 | 290336 | 2010-05-02 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 108 | 57 |
60 | 290337 | 2010-05-02 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 191 | 116 |
61 | 290338 | 2010-05-02 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 238 | 109 |
62 | 290339 | 2010-05-03 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 201 | 69 |
63 | 290340 | 2010-05-03 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 20 | 7 |
64 | 290341 | 2010-05-03 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 372 | 36 |
65 | 290342 | 2010-05-03 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 779 | 109 |
66 | 290343 | 2010-05-03 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 226 | 119 |
67 | 290344 | 2010-05-03 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 327 | 268 |
68 | 290345 | 2010-05-04 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 135 | 57 |
69 | 290346 | 2010-05-04 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 8 | 5 |
70 | 290347 | 2010-05-04 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 292 | 27 |
71 | 290348 | 2010-05-04 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 569 | 93 |
72 | 290349 | 2010-05-04 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 256 | 98 |
73 | 290350 | 2010-05-04 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 257 | 281 |
74 | 290351 | 2010-05-05 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 133 | 72 |
75 | 290352 | 2010-05-05 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 11 | 0 |
76 | 290353 | 2010-05-05 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | RECOVR | 0 | 0 |
77 | 290354 | 2010-05-05 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | AUD | 310 | 21 |
78 | 290355 | 2010-05-05 10:29:01 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 563 | 54 |
79 | 290356 | 2010-05-05 10:29:09 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 0 | 0 |
80 | 290357 | 2010-05-05 10:30:12 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | OPEN | 0 | 0 |
81 | 290358 | 2010-05-05 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 79 | 39 |
82 | 290359 | 2010-05-05 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 194 | 102 |
83 | 290360 | 2010-05-05 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 297 | 248 |
84 | 290361 | 2010-05-06 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 133 | 73 |
85 | 290362 | 2010-05-06 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 10 | 3 |
86 | 290363 | 2010-05-06 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 256 | 22 |
87 | 290364 | 2010-05-06 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 578 | 85 |
88 | 290365 | 2010-05-06 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 227 | 80 |
89 | 290366 | 2010-05-06 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 335 | 286 |
90 | 290367 | 2010-05-07 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 153 | 103 |
91 | 290368 | 2010-05-07 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 5 | 5 |
92 | 290369 | 2010-05-07 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 251 | 21 |
93 | 290370 | 2010-05-07 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 481 | 91 |
94 | 290371 | 2010-05-07 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 233 | 134 |
95 | 290372 | 2010-05-07 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 368 | 423 |
96 | 499482 | 2010-05-08 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 241 | 130 |
97 | 499483 | 2010-05-08 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 53 | 10 |
98 | 499484 | 2010-05-08 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 48 | 27 |
99 | 499485 | 2010-05-08 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 162 | 170 |
100 | 499486 | 2010-05-08 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 189 | 157 |
101 | 499487 | 2010-05-08 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 212 | 151 |
102 | 499488 | 2010-05-09 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 188 | 109 |
103 | 499489 | 2010-05-09 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 29 | 17 |
104 | 499490 | 2010-05-09 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 25 | 9 |
105 | 499491 | 2010-05-09 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 102 | 59 |
106 | 499492 | 2010-05-09 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 149 | 110 |
107 | 499493 | 2010-05-09 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 239 | 119 |
108 | 499494 | 2010-05-10 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 287 | 83 |
109 | 499495 | 2010-05-10 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 14 | 5 |
110 | 499496 | 2010-05-10 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 338 | 50 |
111 | 499497 | 2010-05-10 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 655 | 119 |
112 | 499498 | 2010-05-10 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 259 | 120 |
113 | 499499 | 2010-05-10 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 341 | 311 |
114 | 499500 | 2010-05-11 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 139 | 66 |
115 | 499501 | 2010-05-11 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 5 | 2 |
116 | 499502 | 2010-05-11 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | RECOVR | 0 | 0 |
117 | 499503 | 2010-05-11 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | AUD | 319 | 31 |
118 | 499504 | 2010-05-11 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 571 | 85 |
119 | 499505 | 2010-05-11 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 207 | 130 |
120 | 499506 | 2010-05-11 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 382 | 311 |
121 | 499507 | 2010-05-12 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 146 | 78 |
122 | 499508 | 2010-05-12 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 11 | 4 |
123 | 499509 | 2010-05-12 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 283 | 47 |
124 | 499510 | 2010-05-12 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 867 | 120 |
125 | 499511 | 2010-05-12 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 255 | 143 |
126 | 499512 | 2010-05-12 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 352 | 304 |
127 | 499513 | 2010-05-13 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 146 | 75 |
128 | 499514 | 2010-05-13 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 3 | 5 |
129 | 499515 | 2010-05-13 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 281 | 31 |
130 | 499516 | 2010-05-13 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 577 | 102 |
131 | 499517 | 2010-05-13 12:04:29 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 5 | 0 |
132 | 499518 | 2010-05-13 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | OPEN | 227 | 97 |
133 | 499519 | 2010-05-13 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 374 | 295 |
134 | 499520 | 2010-05-14 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 172 | 111 |
135 | 499521 | 2010-05-14 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 6 | 3 |
136 | 499522 | 2010-05-14 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | RECOVR | 0 | 0 |
137 | 499523 | 2010-05-14 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | AUD | 225 | 29 |
138 | 499524 | 2010-05-14 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 490 | 124 |
139 | 499525 | 2010-05-14 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 231 | 140 |
140 | 499526 | 2010-05-14 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 409 | 350 |
141 | 713696 | 2010-05-22 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 10239 | 4595 |
142 | 713697 | 2010-05-22 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 21 | 15 |
143 | 713698 | 2010-05-22 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 38 | 12 |
144 | 713699 | 2010-05-22 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 138 | 105 |
145 | 713700 | 2010-05-22 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 222 | 185 |
146 | 713701 | 2010-05-22 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 213 | 159 |
147 | 713702 | 2010-05-23 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 237 | 105 |
148 | 713703 | 2010-05-23 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 31 | 18 |
149 | 713704 | 2010-05-23 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 14 | 8 |
150 | 713705 | 2010-05-23 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | RECOVR | 93 | 63 |
151 | 713706 | 2010-05-23 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | AUD | 193 | 115 |
152 | 713707 | 2010-05-23 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 274 | 168 |
153 | 713708 | 2010-05-24 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 197 | 92 |
154 | 713709 | 2010-05-24 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 16 | 5 |
155 | 713710 | 2010-05-24 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 314 | 34 |
156 | 713711 | 2010-05-24 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 669 | 114 |
157 | 713712 | 2010-05-24 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 258 | 138 |
158 | 713713 | 2010-05-24 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 377 | 294 |
159 | 713714 | 2010-05-25 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 163 | 88 |
160 | 713715 | 2010-05-25 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 14 | 3 |
161 | 713716 | 2010-05-25 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 279 | 32 |
162 | 713717 | 2010-05-25 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 562 | 108 |
163 | 713718 | 2010-05-25 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 270 | 98 |
164 | 713719 | 2010-05-25 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 399 | 309 |
165 | 713720 | 2010-05-26 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 176 | 79 |
166 | 713721 | 2010-05-26 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 11 | 4 |
167 | 713722 | 2010-05-26 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 228 | 28 |
168 | 713723 | 2010-05-26 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 650 | 119 |
169 | 713724 | 2010-05-26 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 277 | 134 |
170 | 713725 | 2010-05-26 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 403 | 289 |
171 | 713726 | 2010-05-27 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 181 | 106 |
172 | 713727 | 2010-05-27 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 9 | 3 |
173 | 713728 | 2010-05-27 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 259 | 24 |
174 | 713729 | 2010-05-27 09:02:48 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 277 | 39 |
175 | 713730 | 2010-05-27 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 280 | 61 |
176 | 713731 | 2010-05-27 12:08:32 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 10 | 3 |
177 | 713732 | 2010-05-27 12:08:38 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | OPEN | 0 | 0 |
178 | 713733 | 2010-05-27 12:08:50 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 0 | 0 |
179 | 713734 | 2010-05-27 12:09:31 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | OPEN | 0 | 0 |
180 | 713735 | 2010-05-27 12:11:12 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 0 | 0 |
181 | 713736 | 2010-05-27 12:11:15 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | DOOR | 0 | 0 |
182 | 713737 | 2010-05-27 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | OPEN | 212 | 120 |
183 | 713738 | 2010-05-27 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 423 | 331 |
184 | 713739 | 2010-05-28 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 118 | 100 |
185 | 713740 | 2010-05-28 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 21 | 5 |
186 | 713741 | 2010-05-28 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 233 | 25 |
187 | 713742 | 2010-05-28 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 433 | 133 |
188 | 713743 | 2010-05-28 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 307 | 207 |
189 | 713744 | 2010-05-28 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 358 | 366 |
190 | 928202 | 2010-05-29 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 243 | 173 |
191 | 928203 | 2010-05-29 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 31 | 19 |
192 | 928204 | 2010-05-29 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 25 | 29 |
193 | 928205 | 2010-05-29 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 140 | 146 |
194 | 928206 | 2010-05-29 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 205 | 210 |
195 | 928207 | 2010-05-29 20:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 317 | 227 |
196 | 928208 | 2010-05-30 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 249 | 132 |
197 | 928209 | 2010-05-30 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 22 | 10 |
198 | 928210 | 2010-05-30 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 27 | 20 |
199 | 928211 | 2010-05-30 12:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 123 | 116 |
200 | 928212 | 2010-05-30 16:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 203 | 174 |
z2
turnstile_id | endtime | ca | unit | scp | station | linename | division | description | cumul_entries | cumul_exits | |
---|---|---|---|---|---|---|---|---|---|---|---|
0 | 50466 | 2010-04-17 00:00:00 | N062 | R011 | 01-00-00 | NULL | NULL | NULL | REGULAR | 6001528 | 26135188 |
1 | 50619 | 2010-04-17 00:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 6766725 | 3846177 |
2 | 50769 | 2010-04-17 00:00:00 | N062 | R011 | 01-03-03 | NULL | NULL | NULL | REGULAR | 4571499 | 5790326 |
3 | 50819 | 2010-04-17 00:00:00 | N062 | R011 | 01-03-04 | NULL | NULL | NULL | REGULAR | 8208958 | 13612511 |
4 | 50517 | 2010-04-17 00:00:00 | N062 | R011 | 01-00-01 | NULL | NULL | NULL | REGULAR | 5405443 | 7757147 |
5 | 50568 | 2010-04-17 00:00:00 | N062 | R011 | 01-00-02 | NULL | NULL | NULL | REGULAR | 444993 | 338112 |
6 | 50669 | 2010-04-17 00:00:00 | N062 | R011 | 01-03-01 | NULL | NULL | NULL | REGULAR | 9444698 | 4628935 |
7 | 50869 | 2010-04-17 00:00:00 | N062 | R011 | 01-05-00 | NULL | NULL | NULL | REGULAR | 404 | 0 |
8 | 50719 | 2010-04-17 00:00:00 | N062 | R011 | 01-03-02 | NULL | NULL | NULL | REGULAR | 9150343 | 7293811 |
9 | 50918 | 2010-04-17 00:00:00 | N062 | R011 | 01-05-01 | NULL | NULL | NULL | REGULAR | 0 | 164 |
10 | 50467 | 2010-04-17 04:00:00 | N062 | R011 | 01-00-00 | NULL | NULL | NULL | REGULAR | 6001584 | 26135243 |
11 | 50620 | 2010-04-17 04:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 6766760 | 3846183 |
12 | 50770 | 2010-04-17 04:00:00 | N062 | R011 | 01-03-03 | NULL | NULL | NULL | REGULAR | 4571525 | 5790357 |
13 | 50820 | 2010-04-17 04:00:00 | N062 | R011 | 01-03-04 | NULL | NULL | NULL | REGULAR | 8208973 | 13612563 |
14 | 50468 | 2010-04-17 04:00:00 | N062 | R011 | 01-00-00 | NULL | NULL | NULL | RECOVR | 6001584 | 26135243 |
15 | 50870 | 2010-04-17 04:00:00 | N062 | R011 | 01-05-00 | NULL | NULL | NULL | REGULAR | 404 | 0 |
16 | 50670 | 2010-04-17 04:00:00 | N062 | R011 | 01-03-01 | NULL | NULL | NULL | REGULAR | 9444725 | 4628952 |
17 | 50518 | 2010-04-17 04:00:00 | N062 | R011 | 01-00-01 | NULL | NULL | NULL | RECOVR | 5405478 | 7757182 |
18 | 50569 | 2010-04-17 04:00:00 | N062 | R011 | 01-00-02 | NULL | NULL | NULL | REGULAR | 445022 | 338138 |
19 | 50570 | 2010-04-17 04:00:00 | N062 | R011 | 01-00-02 | NULL | NULL | NULL | RECOVR | 445022 | 338138 |
20 | 50519 | 2010-04-17 04:00:00 | N062 | R011 | 01-00-01 | NULL | NULL | NULL | AUD | 5405478 | 7757182 |
21 | 50919 | 2010-04-17 04:00:00 | N062 | R011 | 01-05-01 | NULL | NULL | NULL | REGULAR | 0 | 164 |
22 | 50720 | 2010-04-17 04:00:00 | N062 | R011 | 01-03-02 | NULL | NULL | NULL | REGULAR | 9150370 | 7293828 |
23 | 50721 | 2010-04-17 08:00:00 | N062 | R011 | 01-03-02 | NULL | NULL | NULL | REGULAR | 9150432 | 7293853 |
24 | 50469 | 2010-04-17 08:00:00 | N062 | R011 | 01-00-00 | NULL | NULL | NULL | AUD | 6001662 | 26135417 |
25 | 50771 | 2010-04-17 08:00:00 | N062 | R011 | 01-03-03 | NULL | NULL | NULL | REGULAR | 4571573 | 5790414 |
26 | 50621 | 2010-04-17 08:00:00 | N062 | R011 | 01-03-00 | NULL | NULL | NULL | REGULAR | 6766786 | 3846201 |
27 | 50821 | 2010-04-17 08:00:00 | N062 | R011 | 01-03-04 | NULL | NULL | NULL | REGULAR | 8209019 | 13612637 |
28 | 50871 | 2010-04-17 08:00:00 | N062 | R011 | 01-05-00 | NULL | NULL | NULL | REGULAR | 404 | 0 |
29 | 50671 | 2010-04-17 08:00:00 | N062 | R011 | 01-03-01 | NULL | NULL | NULL | REGULAR | 9444767 | 4628968 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
163854 | 74858154 | 2017-04-14 12:00:00 | N062 | R011 | 01-03-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 10398983 | 5536196 |
163855 | 74858070 | 2017-04-14 12:00:00 | N062 | R011 | 01-00-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 2032119815 | 1691969692 |
163856 | 74858112 | 2017-04-14 12:00:00 | N062 | R011 | 01-00-02 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 4136673 | 3039303 |
163857 | 74858406 | 2017-04-14 12:00:00 | N062 | R011 | 01-05-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 0 | 921 |
163858 | 74858028 | 2017-04-14 12:00:00 | N062 | R011 | 01-00-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 10517661 | 36488767 |
163859 | 74858238 | 2017-04-14 12:00:00 | N062 | R011 | 01-03-02 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 13576767 | 9504026 |
163860 | 74858322 | 2017-04-14 12:00:00 | N062 | R011 | 01-03-04 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 12483248 | 19254001 |
163861 | 74858196 | 2017-04-14 12:00:00 | N062 | R011 | 01-03-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 13749129 | 6118249 |
163862 | 74858364 | 2017-04-14 12:00:00 | N062 | R011 | 01-05-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 100665861 | 0 |
163863 | 74858280 | 2017-04-14 12:00:00 | N062 | R011 | 01-03-03 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 3475695 | 3175792 |
163864 | 74858113 | 2017-04-14 16:00:00 | N062 | R011 | 01-00-02 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 4136946 | 3039658 |
163865 | 74858071 | 2017-04-14 16:00:00 | N062 | R011 | 01-00-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 2032120173 | 1691969072 |
163866 | 74858239 | 2017-04-14 16:00:00 | N062 | R011 | 01-03-02 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 13577068 | 9504292 |
163867 | 74858029 | 2017-04-14 16:00:00 | N062 | R011 | 01-00-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 10518011 | 36489976 |
163868 | 74858197 | 2017-04-14 16:00:00 | N062 | R011 | 01-03-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 13749433 | 6118443 |
163869 | 74858155 | 2017-04-14 16:00:00 | N062 | R011 | 01-03-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 10399267 | 5536454 |
163870 | 74858281 | 2017-04-14 16:00:00 | N062 | R011 | 01-03-03 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 3475966 | 3176195 |
163871 | 74858407 | 2017-04-14 16:00:00 | N062 | R011 | 01-05-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 0 | 921 |
163872 | 74858365 | 2017-04-14 16:00:00 | N062 | R011 | 01-05-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 100665861 | 0 |
163873 | 74858323 | 2017-04-14 16:00:00 | N062 | R011 | 01-03-04 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 12483447 | 19254631 |
163874 | 74858156 | 2017-04-14 20:00:00 | N062 | R011 | 01-03-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 10399624 | 5536893 |
163875 | 74858198 | 2017-04-14 20:00:00 | N062 | R011 | 01-03-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 13749825 | 6118743 |
163876 | 74858282 | 2017-04-14 20:00:00 | N062 | R011 | 01-03-03 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 3476324 | 3176873 |
163877 | 74858366 | 2017-04-14 20:00:00 | N062 | R011 | 01-05-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 100665861 | 0 |
163878 | 74858072 | 2017-04-14 20:00:00 | N062 | R011 | 01-00-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 2032120508 | 1691967814 |
163879 | 74858114 | 2017-04-14 20:00:00 | N062 | R011 | 01-00-02 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 4137311 | 3040353 |
163880 | 74858408 | 2017-04-14 20:00:00 | N062 | R011 | 01-05-01 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 0 | 921 |
163881 | 74858240 | 2017-04-14 20:00:00 | N062 | R011 | 01-03-02 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 13577470 | 9504660 |
163882 | 74858030 | 2017-04-14 20:00:00 | N062 | R011 | 01-00-00 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 10518384 | 36491873 |
163883 | 74858324 | 2017-04-14 20:00:00 | N062 | R011 | 01-03-04 | 42 ST-PORT AUTH | ACENQRS1237W | IND | REGULAR | 12483702 | 19255474 |
163884 rows × 11 columns