Skip to content

Instantly share code, notes, and snippets.

@emilyw15

emilyw15/.block

Last active September 18, 2017 15:51
Show Gist options
  • Save emilyw15/4b9cf2866a6c8c96417d8126595c5642 to your computer and use it in GitHub Desktop.
Save emilyw15/4b9cf2866a6c8c96417d8126595c5642 to your computer and use it in GitHub Desktop.
Download ZIP
MTA Data Table Summary
Raw
.block
license: mit
Raw
README.md
Raw
index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Data Summary</title>
<script src="https://d3js.org/d3.v4.min.js"></script>
<script src="https://unpkg.com/datalib@1.8.0/datalib.min.js"></script>
<style>
</style>
</head>
<body>
<script>
// Use these for other formats:
// d3.tsv('data.tsv', data => {
// d3.json('data.json', data => {
// Load and summarize the data.
d3.csv('MTA_Average_Weekday_Ridership_-_by_Month.csv', data => {
// Assemble a summary string.
const summary = [
'Data table summary: ',
data.length + ' rows',
data.columns.length + ' columns',
Math.round(d3.csvFormat(data).length / 1024) + ' kB',
'\nSummary of each column:',
dl.format.summary(data)
].join('\n');
// Show the summary string on the page.
d3.select('body').append('pre').text(summary);
// Log the summary to the console.
console.log(summary);
});
</script>
</body>
</html>
Raw
MTA_Average_Weekday_Ridership_-_by_Month.csv
Month Bus Metro Light Rail Mobility Taxi Access MARC Total MARC - Brunswick MARC - Camden MARC - Penn Commuter Bus Total CB - Baltimore CB - Washington CB - ICC Total Average Weekday Ridership
6-Jul 205015 43358 22997 2838 1072 275280
6-Aug 215455 44427 22708 2860 1162 286612
6-Sep 251719 44062 24085 2985 1211 324062
6-Oct 251749 45510 22773 3055 1184 324271
6-Nov 247152 43469 22846 2997 1192 317656
6-Dec 232413 42324 23656 2940 1191 302524
7-Jan 240932 44371 23185 2981 1168 312637
7-Feb 220090 43082 26062 2783 1040 293057
7-Mar 250161 46007 23342 3211 1005 323726
7-Apr 234176 45422 25403 3132 1177 309310
7-May 250839 47849 25355 3223 1243 328509
7-Jun 220645 46893 27066 3129 1269 299002
7-Jul 207178 44009 29680 3189 1293 30318 6798 3909 19611 315667
7-Aug 215661 43381 24545 3150 1184 30941 6748 4719 19474 318862
7-Sep 266457 49827 27343 3309 1162 30838 7109 4312 19417 378936
7-Oct 241419 44364 25715 3272 1213 31221 6994 4370 19857 347204
7-Nov 249091 46899 26729 3333 1212 30349 6620 4256 19473 357613
7-Dec 229427 43027 23663 3200 1120 28811 6506 4027 18278 329248
8-Jan 233824 47448 22819 3485 1062 31059 7411 4083 19565 339697
8-Feb 227948 46219 23649 3429 1244 30819 7280 4706 18833 333308
8-Mar 240534 47055 26178 3474 1197 31943 7652 4181 20110 350381
8-Apr 273434 49644 27492 3573 1352 32631 7622 4721 20288 388126
8-May 267740 49531 26139 3409 1296 32604 7724 4466 20414 380719
8-Jun 233484 48137 25328 3495 1376 32844 6660 4544 21640 344664
8-Jul 226821 47906 22469 3420 1276 33147 7450 4961 20736 335039
8-Aug 231109 47665 25528 3546 1383 32312 7090 4603 20619 341543
8-Sep 298498 50761 28557 3618 1324 33989 7489 4724 21776 416747
8-Oct 284564 49771 29972 3721 1339 33575 7545 4943 21087 402942
8-Nov 258325 44549 25772 3421 1347 33106 8021 4111 20975 366520
8-Dec 239553 41732 23150 3337 1207 29241 6604 3634 19003 338220
9-Jan 226626 42918 27008 3289 631 30871 7099 4112 19660 331343
9-Feb 260922 45161 26078 3829 873 33599 7822 5358 20419 370462
9-Mar 261053 44420 36519 3842 813 32127 7654 3729 20744 378774
9-Apr 244026 43531 29462 3925 903 33229 7658 4744 20827 355076
9-May 261025 44721 33043 3829 907 31993 7355 4264 20374 375518
9-Jun 229081 43630 26330 3947 916 32303 7121 5047 20135 336207
9-Jul 224134 42950 27993 3864 765 32107 7518 4004 20585 331813
9-Aug 226909 43420 28787 3960 858 34361 7406 4797 22158 338295
9-Sep 290724 47856 27708 4035 882 33199 7557 4249 21393 404404
9-Oct 282070 47126 29162 4171 846 33342 7679 4474 21189 396717
9-Nov 263832 45127 28411 4023 848 32379 7130 4302 20947 374620
9-Dec 245722 42322 28850 3752 874 28360 6641 3421 18298 349880
10-Jan 245829 44206 26822 4047 809 33005 7969 4347 20689 354718
10-Feb 174809 37544 23381 3026 579 29518 6087 4700 18731 268857
10-Mar 267460 46537 21013 4446 836 33385 8007 4083 21295 373677
10-Apr 273363 48015 22036 4407 812 34618 7892 5164 21562 383251
10-May 276065 47861 25273 4291 670 33052 7503 4321 21228 387212
10-Jun 243601 46293 26858 4363 913 33918 7647 4972 21299 355946
10-Jul 226861 46636 28751 4161 866 31748 6819 3882 21047 339023
10-Aug 232061 46182 29289 4346 903 32874 7046 4921 20907 345655
10-Sep 287828 50792 28936 4396 920 33311 7624 4709 20978 406183
10-Oct 286782 51317 31310 4555 947 32175 7074 4865 20236 407086
10-Nov 275653 49329 28742 4340 986 33519 6853 5230 21436 392569
10-Dec 234057 43426 29281 4168 772 30338 7007 4228 19103 342042
11-Jan 234627 44524 23641 3863 814 30458 7129 4074 19255 14735 1169 13566 352662
11-Feb 271503 49318 24141 4539 932 33195 7434 4492 21269 14264 1143 13121 397892
11-Mar 284567 50825 23652 4862 948 33485 7810 4510 21165 18981 1540 17418 23 417320
11-Apr 264701 50049 24571 4829 983 34498 7552 4691 22255 17553 1414 16103 36 397184
11-May 288534 50988 28597 4721 977 34364 7701 4649 22014 18866 1533 17280 52 427047
11-Jun 242806 48994 30075 4850 1054 33459 7757 4492 21210 18222 1503 16659 59 379460
11-Jul 227036 47781 27861 4649 809 33357 7308 4410 21639 17583 1450 16010 123 359076
11-Aug 232580 48017 25849 4599 1083 29589 7402 4068 18119 20071 1727 18263 81 361788
11-Sep 263605 53799 26233 4858 952 33311 7624 4709 20978 15581 1300 14138 143 398339
11-Oct 291464 52713 27981 5177 1053 32175 7074 4865 20236 16520 1364 15013 144 427083
11-Nov 277541 51349 26613 4964 978 34619 8104 4447 22068 15435 1286 14071 78 411499
11-Dec 258615 48902 26879 4875 975 31923 6979 3822 21122 14345 1171 13006 168 386514
12-Jan 254593 49236 25913 5001 911 31472 7416 4375 19682 17625 1453 15878 294 384751
12-Feb 279570 52936 27313 5451 1233 35210 7670 4845 22696 17661 1459 15832 370 419374
12-Mar 287166 53273 26998 5543 1143 34465 7782 4665 22018 17614 1448 15756 410 426202
12-Apr 265804 51788 27777 5453 1194 36555 7805 4545 24205 17216 1438 15335 443 405787
12-May 278110 52713 28013 5314 1155 36741 7740 4452 24549 17373 1410 15506 457 419419
12-Jun 232444 49713 29606 5476 1036 34929 7742 4597 22590 17259 1430 15329 500 370463
12-Jul 247660 48910 27777 5535 1325 35494 7413 4248 23833 16826 1428 14825 573 383527
12-Aug 253937 50226 28013 5444 1044 36142 7778 4272 24092 16927 1408 14926 592 391733
12-Sep 300618 55839 28964 5511 1295 36413 8250 4354 23809 17714 1495 15621 598 446354
12-Oct 295628 50016 29939 5675 1165 36801 8067 4388 24346 16866 1478 14790 598 436090
12-Nov 277093 51961 31333 5664 1329 37035 8090 4434 24511 16965 1444 14926 595 421380
12-Dec 254834 48427 26270 5142 1377 34605 7783 4460 22362 14358 1237 12594 527 385013
13-Jan 254178 49093 22219 5580 1361 35550 8073 4362 23115 16811 1486 14752 573 384792
13-Feb 272158 52525 23496 5567 1462 37029 8316 4507 24207 17716 1483 15612 621 409953
13-Mar 255756 49275 24903 5650 1478 35539 7645 4251 23644 16529 1374 14529 627 389130
13-Apr 275833 52436 29833 5741 1481 38112 8149 4451 25512 17470 1491 15299 680 420906
13-May 279786 52399 29702 5806 1482 38537 8138 4354 26046 17040 1437 14875 727 424752
13-Jun 239642 47989 28000 5712 1313 38946 7956 4441 26567 17139 1461 14923 755 378741
13-Jul 235709 47275 25350 5314 1456 37463 7534 4210 25720 16623 1408 14443 772 369190
13-Aug 239655 47750 27130 5703 1486 37656 7359 4330 25967 16489 1400 14325 764 375869
13-Sep 271479 54095 28834 5970 1585 38199 7677 4460 26062 17550 1542 15245 763 417712
13-Oct 265318 51994 28661 6072 1545 33676 6718 3688 23271 14997 1539 12781 677 402263
13-Nov 252979 47897 27475 6196 1593 38143 7875 4410 25859 16949 1468 14749 733 391232
13-Dec 229607 45570 24159 5657 1360 30517 6355 3133 21029 13807 1258 11908 641 350677
14-Jan 219072 43681 23066 5494 1527 33201 7359 4094 21748 12413 1322 10590 501 338454
14-Feb 236292 46095 20377 5315 1504 34330 7233 4019 23078 12989 1324 10994 671 356902
14-Mar 243574 37037 22313 5995 1655 36622 7789 4286 24547 13224 1374 11174 676 360420
14-Apr 244475 48928 22170 6357 1732 37518 7869 4426 25223 13277 1366 11201 710 374457
14-May 258586 50872 25834 6396 1671 36922 7495 4408 25019 16441 1361 14330 750 396722
14-Jun 244708 46664 26827 6244 1708 37631 7847 4515 25269 16825 1421 14572 832 380605
14-Jul 242012 47792 25910 6439 1829 37464 7492 4422 25068 16646 1403 14324 919 379697
14-Aug 231893 47401 24381 6327 2258 36549 7396 4484 24669 15977 1350 13722 905 367653
14-Sep 283984 52581 25365 6610 1786 37342 7561 4626 25156 17272 1459 14933 880 424940
14-Oct 285882 51860 30691 6606 1848 37659 7790 4577 25293 17133 1465 14773 895 431680
14-Nov 262646 47212 26313 6283 1874 36057 7443 4474 24140 16659 1423 14386 850 526095
14-Dec 254007 44954 24207 6079 1847 31718 6527 3464 21727 13532 1162 11632 739 376345
15-Jan 234695 43750 18198 5973 1578 34016 6991 4134 22891 14693 1353 12935 406 352902
15-Feb 239529 43343 20202 5856 1567 33515 6999 4116 22400 15703 1385 13906 411 359715
15-Mar 258756 46584 23613 6152 1562 35139 7302 4436 23401 15778 1359 13969 450 387584
15-Apr 252756 42702 20469 6500 1705 36022 7426 4368 24228 15872 1300 14097 475 376562
15-May 275489 44611 22190 6710 1752 35678 7665 4371 23642 16427 1392 14502 532 402857
15-Jun 256876 41842 21579 6710 1733 36211 7808 4593 23811 15870 1233 14152 485 380821
15-Jul 237056 40573 19691 6579 1747 36239 7468 4596 24175 15643 1247 13864 532 357528
15-Aug 229776 41279 20074 6574 1776 35262 7662 4352 23249 15647 1242 13861 544 350388
15-Oct 266240 43987 21639 6793 1739 38730 7981 4716 26033 16284 1268 14118 897 395411
15-Sep 272241 43252 20047 6554 1764 36124 7202 4417 24505 15332 1287 13144 902 394441
15-Nov 267434 43583 21404 6550 1632 31509 6466 3670 21373 16067 1239 13906 922 388180
15-Dec 243492 40671 25443 6410 1716 31316 6271 3684 21360 13847 1051 12001 795 362895
16-Jan 229944 33618 23249 5490 1481 28525 5766 3284 19475 13411 1073 11617 720 335718
16-Feb 254355 29987 24638 6213 1685 32079 6752 3778 21548 15790 1184 13784 822 364746
16-Mar 242481 40194 22535 6798 1763 32888 7228 4000 21659 15652 1148 13651 853 362311
16-Apr 250669 38957 23443 6882 1850 33029 7331 4158 21541 15864 1147 13813 905 370695
16-May 256242 40615 24550 6653 1762 34541 7002 4428 23111 15911 1122 13857 931 380273
16-Jun 263289 40040 23785 6808 1829 36988 7516 4683 24790 16238 1144 14123 971 388977
16-Jul 226106 35659 23337 6557 1831 29648 7180 4364 18104 15408 1103 13316 988 338545
16-Aug 225322 32988 22733 6733 1677 35262 7644 4448 23170 15559 1112 13536 911 340274
16-Sep 252657 37443 24115 6419 1806 35561 7542 4607 23412 15825 1137 13795 893 375826
16-Oct 241282 38933 24247 6367 2033 35072 7247 4541 23284 16141 1166 14047 928 363825
16-Nov 228743 39951 25059 6318 1841 34374 7501 4256 22617 15977 1162 13912 902 352264
16-Dec 222547 31532 19751 6128 1972 30343 6214 3726 20403 13655 1029 11848 777 325927
17-Jan 215250 37667 18225 6210 1897 31186 6539 3669 20978 12040 994 10353 694 322476
17-Feb 223160 37428 20202 5911 1898 32709 7084 4110 21515 16061 1181 14049 832 317167
17-Mar 214454 34319 22669 6551 2413 32669 6824 4186 21659 15741 1174 13725 843 306147
17-Apr 216823 36558 23613 6088 2184 35163 7114 4575 23475 15431 1114 13422 895 275689
17-May 228239 36684 20547 6934 2234 35737 7333 4896 23508 15596 1139 13567 890 345970
17-Jun 226701 39484 23981 6700 22858 36448 7497 4684 24267 15447 1110 13450 887 351046
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment