Skip to content

Instantly share code, notes, and snippets.

@ptvans

ptvans/.block

Last active December 4, 2016 05:29
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 ptvans/c504c3d9e807b67d87e3e2912a19c7c5 to your computer and use it in GitHub Desktop.
Save ptvans/c504c3d9e807b67d87e3e2912a19c7c5 to your computer and use it in GitHub Desktop.
Download ZIP
Stacked bar - transactions (flat)
Raw
.block
license: gpl-3.0
Raw
README.md

This stacked bar chart is constructed from a CSV file storing the populations of different states by age group. The chart employs conventional margins and a number of D3 features:

  • d3-dsv - load and parse data
  • d3-scale - x- and y-position, and color encoding
  • d3-format - SI prefix formatting (e.g., “10M” for 10,000,000)
  • d3-array - compute simple statistics (e.g., max)
  • d3-axis - display axes
  • d3-shape - computed stacked positions

forked from mbostock's block: Stacked Bar Chart

Raw
data.csv
Date Description Original Description Amount Transaction Type Category Account Name Labels Notes
10/22/2016 Westbrae Biergarten WESTBRAE BIERGARTEN 15.86 debit Lawn & Garden Platinum Delta SkyMiles
10/22/2016 Transfer to BUSINESS CLASSIC ONLINE TRANSFER TO CHK ...6793 TRANSACTION#: 5746346321 10/21 365.00 debit Transfer CHASE PREMIER
10/22/2016 Transfer to PREMIER PLUS CKG ONLINE TRANSFER TO CHK ...1188 TRANSACTION#: 5746347261 10/21 1000.00 debit Transfer CHASE PREMIER
10/22/2016 Orig Name Facebook ORIG CO NAME:FACEBOOK INC CO ENTRY DESCR:DIRECT DEP SEC:PPD ORIG ID:9111111101 2872.06 credit Paycheck CHASE PREMIER
10/22/2016 Comcast COMCAST CALIFORNIA 39.99 debit Television CREDIT CARD
10/22/2016 Transfer from CHASE PREMIER ONLINE TRANSFER FROM CHK ...6819 TRANSACTION#: 5746346321 365.00 credit Transfer BUSINESS CLASSIC
10/22/2016 iTunes WWW.ITUNES.COM/BILL 14.99 debit Music Platinum Delta SkyMiles
10/21/2016 Netflix NETFLIX.COM 866-579-7172 1.00 debit Movies & DVDs Platinum Delta SkyMiles
10/18/2016 Airbnb AIRBNB 1.00 debit Hotel Platinum Delta SkyMiles
10/21/2016 Spotify SPOTIFY USA NEW YORK4601S1AMRJD BUSINESS SERVICE 320162950909375656 9.99 debit Music Platinum Delta SkyMiles
10/21/2016 The Fox Theater THE FOX THEATER 0099BERKELEY CA0000090111 510-302-2250 320162950899104206 20.00 debit Arts Platinum Delta SkyMiles
10/21/2016 The Fox Theater THE FOX THEATER 0099BERKELEY CA0000240076 510-302-2250 320162950899104205 14.00 debit Arts Platinum Delta SkyMiles
10/21/2016 Transfer from CHASE PREMIER Online Transfer from CHK ...6819transaction#: 5746347261 1000.00 credit Transfer PREMIER PLUS CKG
10/20/2016 iTunes WWW.ITUNES.COM/BILL CUPERTINO CA 320162940881100169 14.99 debit Music Platinum Delta SkyMiles
10/20/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00480400163 5108098293 320162940886843378 8.01 debit Groceries Platinum Delta SkyMiles
10/20/2016 Amazon Video AMAZON VIDEO ON DEMAAMZN.COM/BIR65E6MKIPCI DIGITAL 320162940890115941 16.99 debit Movies & DVDs Platinum Delta SkyMiles
10/20/2016 Amazon AMAZON MKTPLACE PMTS 49.00 debit Shopping CREDIT CARD
10/19/2016 Received Thank You PAYMENT RECEIVED - THANK YOU 320162930879405088 1276.02 credit Credit Card Payment Platinum Delta SkyMiles
10/19/2016 Airbnb AIRBNB AIRBNB SAN FRANCISCO CAA4X7Y9CA 8554247262 320162930871559898 287.00 debit Hotel Platinum Delta SkyMiles
10/19/2016 Amazon AMAZON.COM AMZN.COM/BILL WATVOVQYWVATB MERCHANDISE 320162930872142488 49.79 debit Shopping Platinum Delta SkyMiles
10/19/2016 Amazon AMAZON.COM AMZN.COM/BILL WATVO3TD7RKCB MERCHANDISE 320162930872142448 36.64 debit Shopping Platinum Delta SkyMiles
10/19/2016 Airbnb AIRBNB AIRBNB SAN FRANCISCO CAAW10HC84 8554247262 320162930868438174 32.00 credit Hotel Platinum Delta SkyMiles
10/19/2016 Airbnb AIRBNB AIRBNB SAN FRANCISCO CAJF6DG5Z7 8554247262 320162930868438173 255.00 credit Hotel Platinum Delta SkyMiles
10/19/2016 Interest INTEREST PAYMENT 0.06 credit Interest Income CHASE PREMIER
10/19/2016 American Express AMERICAN EXPRESS ACH PMT W2732 WEB ID: 2005032111 1276.02 debit Credit Card Payment CHASE PREMIER
10/19/2016 Transfer to Chase Sapphire Payment to Chase card ending in1279 29.90 debit Credit Card Payment CHASE PREMIER
10/19/2016 Chapters Indigo URBAN INDIGO 41.61 debit Books CREDIT CARD
10/19/2016 Chevron CHEVRON 0305604 49.54 debit Gas & Fuel CREDIT CARD
10/19/2016 Interest INTEREST PAYMENT 0.03 credit Interest Income PREMIER PLUS CKG
10/19/2016 Transfer from CHASE PREMIER Payment Thank You - Web 29.90 credit Credit Card Payment Chase Sapphire
10/18/2016 Aplpay Saint Frank AplPay SAINT FRANK CMenlo ParkIAYOE4 squareup.com/receipts 320162920856069759 4.25 debit Coffee Shops Platinum Delta SkyMiles
10/18/2016 Ing Meter OAKLAND PARKING METER 0.55 debit Parking CREDIT CARD
10/18/2016 O'Reilly Auto Parts OREILLY AUTO 00034454 9.84 debit Service & Parts CREDIT CARD
10/17/2016 Bittersweet Bistro BITTERSWEET BISTRO 12.83 debit Restaurants CREDIT CARD
10/17/2016 Verve VERVE COFFEE - PACIFIC 10.79 debit Business Services CREDIT CARD
10/17/2016 Ross ROSS STORE 418 10.86 debit Clothing CREDIT CARD
10/17/2016 Venmo Cashout Ppd VENMO CASHOUTPPD ID: 5264681992 80.45 credit Income CHASE PREMIER
10/16/2016 Alameda Imports ALAMEDA IMPORT AUTOMOTIVE 413.47 debit Service & Parts CREDIT CARD
10/16/2016 Shell SHELL OIL 57444675904 54.31 debit Gas & Fuel CREDIT CARD
10/16/2016 Netflix NETFLIX.COM 9.99 debit Movies & DVDs United Visa
10/14/2016 ATM Fee NON-CHASE ATM WITHDRAW702741 10/133121 16TH 1.95 debit ATM Fee CHASE PREMIER
10/14/2016 ATM Withdrawal NON-CHASE ATM WITHDRAW702741 10/133121 16TH 200.00 debit Transfer for Cash Spending CHASE PREMIER
10/14/2016 Starbucks STARBUCKS STORE 00570 10.90 debit Coffee Shops CREDIT CARD
10/14/2016 Andronico's ANDRONICOS MARKET 1 8.78 debit Groceries CREDIT CARD
10/14/2016 Uber Us X UBER *US OCT13 X7VI4 9.85 debit Rental Car & Taxi United Visa
10/14/2016 Uber Us U UBER *US OCT13 U74RC 11.48 debit Rental Car & Taxi United Visa
10/14/2016 New York Times NEW YORK TIMES DIGITAL 15.00 debit Books United Visa
10/14/2016 Hopkins Street Pizza HOPKINS STREET PIZZA BERKELEY CA10/12 8.00 debit Restaurants CHASE PREMIER
10/13/2016 Amazon AMAZON MKTPLACE PMTS 20.00 debit Shopping CREDIT CARD
10/13/2016 Espresso Roma Hopkins ESPRESSO ROMA-HOPKINS 15.99 debit Coffee Shops CREDIT CARD
10/13/2016 Amazon AMAZON MKTPLACE PMTS 45.04 debit Shopping CREDIT CARD
10/13/2016 Ditech DITECH FINANCIAL MTG PYT 0031975857 PPD ID: 4411795868 362.63 debit Mortgage & Rent BUSINESS CLASSIC
10/12/2016 Amazon Amazon.com 124.28 debit Shopping CREDIT CARD
10/12/2016 Amazon Amazon.com 136.60 debit Shopping CREDIT CARD
10/12/2016 BART BART FRUITVALE STATION OAKLAND CA 10/12 4.00 debit Public Transportation CHASE PREMIER
10/12/2016 Country Cheese Coffee Market COUNTRY CHEESE COFFEE BERKELEY CA 006160 10/12 6.74 debit Groceries CHASE PREMIER
10/12/2016 Amazon Video AMAZON VIDEO ON DEMAAMZN.COM/BIL67A0FV4P6C DIRECT MKTG INTERNET 320162860778145699 2.99 credit Movies & DVDs Platinum Delta SkyMiles
10/12/2016 Equator Coffees EQUATOR COFFEES - 2 MILL VALLEY 320162860769462947 16.75 debit Coffee Shops Platinum Delta SkyMiles
10/12/2016 Amazon Video AMAZON VIDEO ON DEMAAMZN.COM/BIL671CV02U7W DIGITAL 320162860776879381 2.99 debit Movies & DVDs Platinum Delta SkyMiles
10/11/2016 Sfmta SFMTA 5TH & MISSION GARA 4.50 debit Fees & Charges CREDIT CARD
10/11/2016 Beth Bolinas Ca SQ *BETH'S Bolinas CA10/09 5.00 debit Sports CHASE PREMIER
10/11/2016 Transfer to BUSINESS CLASSIC Online Transfer to CHK ...6793 transaction#: 5718033060 360.00 debit Transfer CHASE PREMIER
10/11/2016 Transfer to CREDIT CARD Payment to Chase card ending in3754 228.01 debit Credit Card Payment CHASE PREMIER
10/11/2016 Transfer from CHASE PREMIER Online Transfer from CHK ...6819transaction#: 5718033060 360.00 credit Transfer BUSINESS CLASSIC
10/11/2016 2 Mile Surf Shop 2 MILE SURF SHOP 641BOLINAS CA 320162850754991901 86.80 debit Sporting Goods Platinum Delta SkyMiles
10/10/2016 Transfer from CHASE PREMIER Payment Thank You - Web 228.01 credit Credit Card Payment CREDIT CARD
10/09/2016 Audible.com Audible 14.95 debit Books Chase Sapphire
10/09/2016 Home Depot THE HOME DEPOT EL CERRITO CA10080064329 800-654-0688 320162830730014166 44.76 debit Home Improvement Platinum Delta SkyMiles
10/08/2016 UPS THE UPS STORE BERKELEY CA4599485 OFFICE SUPPLY STORE 320162820717109847 10.91 debit Shipping Platinum Delta SkyMiles
10/08/2016 Aplpay Highwire Coff AplPay HIGHWIRE COFFAlbany CAP7YFHF squareup.com/receipts 320162820719906495 8.75 debit Coffee Shops Platinum Delta SkyMiles
10/07/2016 Check 5141 CHECK 5141 1123.00 debit Security Deposit CHASE PREMIER
10/07/2016 Facebook Direct Dep FACEBOOK INC DIRECT DEPPPD ID: 9111111101 2885.75 credit Paycheck CHASE PREMIER
10/07/2016 Walgreens WALGREENS BERKELEY CA99999996281 8002892273 320162810706035692 9.83 debit Pharmacy Platinum Delta SkyMiles
10/07/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00491100008 5108098293 320162810708112373 6.99 debit Groceries Platinum Delta SkyMiles
10/07/2016 Aplpay Saint Frank AplPay SAINT FRANK CMenlo ParkP7WVT3 squareup.com/receipts 320162810704150839 5.00 debit Coffee Shops Platinum Delta SkyMiles
10/06/2016 Chevron CHEVRON 0091745/CHEVBERKELEY CASERVICE STN 320162800688942707 49.20 debit Gas & Fuel Platinum Delta SkyMiles
10/06/2016 Whole Foods WHOLE FOODS MARKET CBerkeley CAyQjjEfklKLz squareup.com/receipts 320162800691178495 4.50 debit Groceries Platinum Delta SkyMiles
10/06/2016 Chevron CHEVRON 0094800/CHEVOAKLAND CASERVICE STN 320162800693187586 20.56 debit Gas & Fuel Platinum Delta SkyMiles
10/06/2016 Comcast COMCAST 800-934-6489 MI85291013100 CABLE SVCS 320162800697622356 39.49 debit Television Platinum Delta SkyMiles
10/05/2016 Delta DELTA AIR LINES ATLANTA18002211212 320162790683260777 39.00 debit Air Travel Platinum Delta SkyMiles
10/05/2016 Delta DELTA AIR LINES ATLANTA18002211212 320162790684220033 11.20 debit Air Travel Platinum Delta SkyMiles
10/04/2016 Hopkins HOPKINS STREET PIZZA 8.50 debit Business Services CREDIT CARD
10/04/2016 Wnyc Wqxr Njpr WNYC/WQXR/NJPR/NYPR RADIO 6.25 debit Charity United Visa
10/04/2016 Check 5142 CHECK 5142 3150.00 debit Mortgage & Rent CHASE PREMIER
10/04/2016 Airbnb Payments Q AIRBNB PAYMENTS Q3UCRPYW5TPPD ID: 3263051428 1544.00 credit Rental Income CHASE PREMIER
10/04/2016 Fastrak FASTRAK CSC TOLLS OAKLAND CA30265180 415-486-8655 320162780672102398 105.00 debit Public Transportation Platinum Delta SkyMiles
10/03/2016 Venmo Cashout Ppd VENMO CASHOUTPPD ID: 5264681992 1747.39 credit Mortgage & Rent CHASE PREMIER
10/03/2016 American Express AMERICAN EXPRESS ACH PMT W8336 WEB ID: 2005032111 4000.00 debit Credit Card Payment CHASE PREMIER
10/03/2016 Chase Ending In Payment to Chase card ending in9374 95.76 debit Financial CHASE PREMIER
10/03/2016 iTunes WWW.ITUNES.COM/BILL CUPERTINO CAMQ73NQHH600 ITUNES STORE & APP ST 320162770649812536 14.99 debit Music Platinum Delta SkyMiles
10/03/2016 Lyft LYFT *RIDE SAT 8PMSAN FRANCISCOCH_9IZ33BE5 8552800278 320162770651905000 11.61 debit Rental Car & Taxi Platinum Delta SkyMiles
10/03/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00250800106 5108098293 320162770653202639 29.91 debit Groceries Platinum Delta SkyMiles
10/03/2016 IKEA IKEA EAST BAY 165 EMERYVILLE CA15165939 MISC HOME FURNISHINGS 320162770656179286 32.83 debit Furnishings Platinum Delta SkyMiles
10/02/2016 Thank You ONLINE PAYMENT - THANK YOU 320162760644711236 4000.00 credit Credit Card Payment Platinum Delta SkyMiles
10/02/2016 Shell SHELL OIL 10008269002 11.17 debit Gas & Fuel CREDIT CARD
10/02/2016 Moshi Moshi MOSHI MOSHI 46.12 debit Restaurants CREDIT CARD
10/02/2016 Dog Patch DOGPATCH BOULDERS 24.00 debit Gym CREDIT CARD
10/02/2016 Annual Membership Fee ANNUAL MEMBERSHIP FEE 95.00 debit Service Fee CREDIT CARD
10/02/2016 Thank You Mobile Payment Thank You-Mobile 95.76 credit Credit Card Payment United Visa
10/01/2016 Gilman Coffee P 1312 GILMAN COFFEE &Albany CAP7IIKA squareup.com/receipts 320162750619486216 16.50 debit Coffee Shops Platinum Delta SkyMiles
9/30/2016 Lowe's LOWE'S SAN FRANCISCO CAINV # 01072 415-486-8611 320162740603721511 30.50 debit Home Improvement Platinum Delta SkyMiles
9/30/2016 Chevron CHEVRON 0091745/CHEVBERKELEY CASERVICE STN 320162740603526858 57.59 debit Gas & Fuel Platinum Delta SkyMiles
9/30/2016 Aplpay Saint Frank AplPay SAINT FRANK CMenlo ParkP7GTG7 squareup.com/receipts 320162740604254538 5.00 debit Coffee Shops Platinum Delta SkyMiles
9/30/2016 Account Maintenance Fee MONTHLY SERVICE FEE 12.00 debit Bank Fee BUSINESS CLASSIC
9/29/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00500300079 5108098293 320162730594265176 19.18 debit Groceries Platinum Delta SkyMiles
9/29/2016 Whole Foods SQ *WHOLE FOODS MARKET CA 8.00 debit Groceries CREDIT CARD
9/28/2016 Draegers DRAEGER'S LOS ALTO 5LOS ALTOS CA926001630 6509484425 320162720580486920 28.81 debit Groceries Platinum Delta SkyMiles
9/28/2016 Shell SHELL OIL 1000806100MOUNTAIN VI0650218 AUTO FUEL DISPENSER 320162720579363723 20.52 debit Gas & Fuel Platinum Delta SkyMiles
9/28/2016 Crate & Barrel CRATE & BARREL #405 19.50 debit Furnishings CREDIT CARD
9/27/2016 Ticketmaster Direct Ca TicketMaster Visa Direct CA119941 09/27 54.00 credit Music CHASE PREMIER
9/26/2016 Mozy Pleasant Gro MOZY 8610000079366 PLEASANT GRO68473335030 8017562331 320162700550613948 15.99 debit Groceries Platinum Delta SkyMiles
9/26/2016 Lane Splitter Pizza and Pub LANE SPLITTER PIZZ 14.86 debit Alcohol & Bars CREDIT CARD
9/26/2016 Teance Fine Teas SQ *TEANCE FINE TEAS GOSQ 10.66 debit Music CREDIT CARD
9/25/2016 Whole Foods WHOLEFDS SRF 10071 0SAN RAFAEL00480300036 4154516333 320162690541164284 10.15 debit Groceries Platinum Delta SkyMiles
9/25/2016 Sonoma County Regional Parks SONOMA COUNTY REGIONAL P 7.00 debit Entertainment CREDIT CARD
9/25/2016 Imperial Tea Court IMPERIAL TEA COURT 25.90 debit Coffee Shops CREDIT CARD
9/25/2016 Chevron CHEVRON 0306144 61.94 debit Gas & Fuel CREDIT CARD
9/23/2016 Facebook Direct Dep FACEBOOK INC DIRECT DEPPPD ID: 9111111101 2858.31 credit Paycheck CHASE PREMIER
9/23/2016 The Hills Online Payment 5616557676 To TheHills of Rochester 250.98 debit Service Fee BUSINESS CLASSIC
9/22/2016 Whole Foods WHOLE FOODS MARKET CBerkeley CA5boswYsiSvw squareup.com/receipts 320162660496701097 8.00 debit Groceries Platinum Delta SkyMiles
9/22/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00490100085 5108098293 320162660498341228 8.67 debit Groceries Platinum Delta SkyMiles
9/22/2016 Comcast COMCAST 800-934-6489 MI95110760AST CABLE SVCS 320162660500337656 35.99 debit Television Platinum Delta SkyMiles
9/22/2016 Comcast COMCAST CALIFORNIA C(800)266-2295125202VST CABLE SVCS 320162660501824756 39.99 debit Television Platinum Delta SkyMiles
9/22/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00250200004 5108098293 320162660497736481 37.67 debit Groceries Platinum Delta SkyMiles
9/22/2016 Pacific Gas & Electric PGANDE WEB ONLINE 58658872092116 WEB ID: 5940742640 117.31 debit Utilities CHASE PREMIER
9/21/2016 Amazon AMAZON.COM AMZN.COM/BILL WARLOANKVZZIO MERCHANDISE 320162650483824419 21.51 debit Shopping Platinum Delta SkyMiles
9/21/2016 Spotify SPOTIFY USA NEW YORK46013SREJEJ BUSINESS SERVICE 320162650490540351 9.99 debit Music Platinum Delta SkyMiles
9/21/2016 Agilebits Toronto Ch AGILEBITS INC. TORONTOCH_9EV37102 4165461397 320162650486036321 64.99 debit Computer/Technology Platinum Delta SkyMiles
9/20/2016 Mission Rock Resort MISSION ROCK RESORT SAN FRANCIS84275046264 415-701-7625 320162640476089291 33.12 debit Hotel Platinum Delta SkyMiles
9/20/2016 Ebmud Util Ez EBMUD UTIL/EZ-PAYFEE800-766-66100492319091 UTILITY 320162640465861153 1.99 debit Utilities Platinum Delta SkyMiles
9/20/2016 Ebmud Ca Utility EBMUD PAYMENT 866-403-2683 CA00099971091 UTILITY 320162640466154562 219.21 debit Utilities Platinum Delta SkyMiles
9/20/2016 Whole Foods SQ *WHOLE FOODS MARKET CA 2.50 debit Groceries CREDIT CARD
9/20/2016 Airbnb Payments Idssw AIRBNB PAYMENTS IDSSW6JS5NPPD ID: 3263051428 751.00 credit Rental Income CHASE PREMIER
9/19/2016 Ralphs RALPHS #0644 0000006SANTA BARBA999999962628884373496 320162630461098909 11.36 debit Groceries Platinum Delta SkyMiles
9/19/2016 Flickr Flickr C FLICKR FLICKR SUNNYVALE CAC1YBNJMX 4083493300 320162630455142494 24.95 debit Computer/Technology Platinum Delta SkyMiles
9/19/2016 Doubletree DOUBLETREE BARRA ARCSANTA BARBA4799031 RESTAURANT 320162630453228883 59.00 debit Hotel Platinum Delta SkyMiles
9/19/2016 Doubletree DOUBLETREE BARRA ARCSANTA BARBA36453866 RESTAURANT 320162630453450901 78.93 debit Hotel Platinum Delta SkyMiles
9/19/2016 Backyard Bowls BACKYARD BOWLS 21.83 debit Restaurants CREDIT CARD
9/19/2016 Peter Steynberg SQ *PETER STEYNBERG 4.25 debit Coffee Shops CREDIT CARD
9/19/2016 Interest INTEREST PAYMENT 0.06 credit Interest Income CHASE PREMIER
9/19/2016 Interest INTEREST PAYMENT 0.01 credit Interest Income PREMIER PLUS CKG
9/18/2016 iTunes WWW.ITUNES.COM/BILL CUPERTINO CAMQ7387N9L50 ITUNES STORE & APP ST 320162620441638628 14.99 debit Music Platinum Delta SkyMiles
9/18/2016 Milpas Liquor & Deli MILPAS LIQUOR & DELISANTA BARBA84223696262805-966-4435 320162620449789884 14.03 debit Alcohol & Bars Platinum Delta SkyMiles
9/18/2016 Espresso Roma Hopkins ESPRESSO ROMA-HOPKINS 5.48 debit Coffee Shops CREDIT CARD
9/17/2016 Shell SHELL OIL 5744417820SANTA BARBA0558940 AUTO FUEL DISPENSER 320162610429764156 54.55 debit Gas & Fuel Platinum Delta SkyMiles
9/17/2016 Dreamhost DREAMHOST.COM (877)829-4070 CAS57DB94A600 877-829-4070 320162610436064861 32.85 debit Business Services Platinum Delta SkyMiles
9/17/2016 AutoZone AUTOZONE #5688 00000SANTA BARBA408167 8002886966 320162610425904605 29.44 debit Service & Parts Platinum Delta SkyMiles
9/16/2016 Exxon EXXONMOBIL 9931 OAKLAND CA00008221 510-655-0803 320162600418458857 60.48 debit Gas & Fuel Platinum Delta SkyMiles
9/16/2016 Whole Foods WHOLEFDS GIL #10530 6.65 debit Groceries CREDIT CARD
9/16/2016 New York Times NEW YORK TIMES DIGITAL 15.00 debit Books United Visa
9/16/2016 ATM Withdrawal ATM WITHDRAWAL004489 09/163307 STAT 120.00 debit Cash & ATM CHASE PREMIER
9/15/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00470400175 5108098293 320162590400056604 2.99 debit Groceries Platinum Delta SkyMiles
9/15/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00470400174 5108098293 320162590399867353 108.61 debit Groceries Platinum Delta SkyMiles
9/15/2016 Whole Foods SQ *WHOLE FOODS MARKET CA 4.00 debit Groceries CREDIT CARD
9/15/2016 Netflix NETFLIX.COM 9.99 debit Movies & DVDs United Visa
9/15/2016 Sutter Stockton Garage SUTTER STOCKTON GARA SAN FRANCISCO CA 09/14 3.00 debit Parking CHASE PREMIER
9/14/2016 The Homestead THE HOMESTEAD 272400SAN FRANCIS12 RESTAURANT 320162580385202096 25.00 debit Alcohol & Bars Platinum Delta SkyMiles
9/14/2016 Shell SHELL OIL 57444216907 38.52 debit Gas & Fuel CREDIT CARD
9/14/2016 Piccino PICCINO 5.75 debit Restaurants CREDIT CARD
9/14/2016 Gilman Coffee SQ *1312 GILMAN COFFEE & 5.00 debit Coffee Shops CREDIT CARD
9/13/2016 Farm Burger FARM BURGER-BERKELEY 31.70 debit Fast Food CREDIT CARD
9/13/2016 Bay Street Garage BAY STREET GARAGE 3.00 debit Parking CREDIT CARD
9/13/2016 Roam Artisan Burgers ROAM ARTISAN BURGERS 15.89 debit Restaurants CREDIT CARD
9/13/2016 Saul's Restaurant SAULS RESTAURANT & DELICA 32.61 debit Restaurants CREDIT CARD
9/13/2016 Transfer to BUSINESS CLASSIC Online Transfer to CHK ...6793 transaction#: 5658892009 500.00 debit Transfer CHASE PREMIER
9/13/2016 Ditech DITECH FINANCIAL MTG PYT 0031975857 PPD ID: 4411795868 362.63 debit Mortgage & Rent BUSINESS CLASSIC
9/13/2016 Transfer from CHASE PREMIER Online Transfer from CHK ...6819transaction#: 5658892009 500.00 credit Transfer BUSINESS CLASSIC
9/12/2016 Autopay Thank You AUTOPAY PAYMENT - THANK YOU 320162560364633137 53.00 credit Credit Card Payment Platinum Delta SkyMiles
9/12/2016 Thank You ONLINE PAYMENT - THANK YOU 320162560365525772 3615.55 credit Credit Card Payment Platinum Delta SkyMiles
9/12/2016 Masse's Pastries MASSE'S PASTRIES 2.00 debit Restaurants CREDIT CARD
9/12/2016 Whole Foods WHOLEFDS GIL #10530 3.82 debit Groceries CREDIT CARD
9/12/2016 Masse's Pastries MASSE'S PASTRIES 3.00 debit Restaurants CREDIT CARD
9/12/2016 Shop Hair Cut THE SHOP HAIR CUT 35.00 debit Hair CREDIT CARD
9/12/2016 Uniqlo UNIQLO EMERYVILLE #40 41.07 debit Clothing CREDIT CARD
9/12/2016 Transfer from CHASE PREMIER Payment Thank You - Web 428.60 credit Credit Card Payment CREDIT CARD
9/12/2016 Sqc Alexis Konevich SQC*<ALEXIS KONEVICH SAN FRANCISCO CA 09/11 15.00 credit Restaurants CHASE PREMIER
9/12/2016 Transfer to CREDIT CARD Payment to Chase card ending in3754 428.60 debit Credit Card Payment CHASE PREMIER
9/12/2016 Transfer to PREMIER PLUS CKG Online Transfer to CHK ...1188 transaction#: 5658203950 2000.00 debit Transfer CHASE PREMIER
9/12/2016 Brandon SQC*BRANDON WEISS . / CA09/11 30.00 debit Business Services CHASE PREMIER
9/12/2016 Airbnb Payments Rbymzpjagx AIRBNB PAYMENTS RBYMZPJAGXPPD ID: 3263051428 415.00 credit Rental Income CHASE PREMIER
9/12/2016 Transfer to Platinum Delta SkyMiles AMERICAN EXPRESS ACH PMT A8546 WEB ID: 9493560001 53.00 debit Credit Card Payment CHASE PREMIER
9/12/2016 Transfer to Platinum Delta SkyMiles AMERICAN EXPRESS ACH PMT W5516 WEB ID: 2005032111 3615.55 debit Credit Card Payment CHASE PREMIER
9/12/2016 Transfer from CHASE PREMIER Online Transfer from CHK ...6819transaction#: 5658203950 2000.00 credit Transfer PREMIER PLUS CKG
9/11/2016 Whole Foods WHOLE FOODS MARKET SAN FRANCISC00251200091 4156261430 320162550345545385 15.32 debit Groceries Platinum Delta SkyMiles
9/11/2016 Four Barrel Coffee SQ *FOUR BARREL COFFEE VA 6.00 debit Coffee Shops CREDIT CARD
9/11/2016 City of Berkeley CITY OF BERKELEY- IPS 0.50 debit Fees & Charges CREDIT CARD
9/11/2016 Whole Foods SQ *WHOLE FOODS MARKET CA 4.00 debit Groceries CREDIT CARD
9/10/2016 Amazon AMAZON.COM AMZN.COM/BILL WAO7C86LDBI5D MERCHANDISE 320162540331088534 90.56 debit Shopping Platinum Delta SkyMiles
9/10/2016 Rare Device Divisasan RARE DEVICE - DIVISASan FrancisP5PXNQ squareup.com/receipts 320162540339371011 76.13 debit Gift Platinum Delta SkyMiles
9/10/2016 Chevron CHEVRON 0305604/CHEVBERKELEY CASERVICE STN 320162540337767157 36.15 debit Gas & Fuel Platinum Delta SkyMiles
9/09/2016 Aplpay Saint Frank AplPay SAINT FRANK CMenlo ParkP5O55L squareup.com/receipts 320162530314018994 5.00 debit Coffee Shops Platinum Delta SkyMiles
9/09/2016 Whole Foods WHOLEFDS PTH 10238 0SAN FRANCIS00200900223 4155521155 320162530318111284 58.39 debit Groceries Platinum Delta SkyMiles
9/09/2016 Clearwater Car Wash CLEARWATER CARWASH 4.85 debit Service & Parts CREDIT CARD
9/09/2016 Facebook Direct Dep FACEBOOK INC DIRECT DEPPPD ID: 9111111101 5108.15 credit Paycheck CHASE PREMIER
9/09/2016 Facebook Direct Dep FACEBOOK INC DIRECT DEPPPD ID: 9111111101 2858.31 credit Paycheck CHASE PREMIER
9/09/2016 Audible.com Audible 14.95 debit Books Chase Sapphire
9/08/2016 Caesars Palce Venus CAESARS PALCE VENUS LAS VEGAS NV06329007 866-209-4732 320162520309095934 45.00 debit Amusement Platinum Delta SkyMiles
9/08/2016 Whole Foods WHOLEFDS PTH #10238 SAN FRANCIS93439180 4155521155 320162520301684587 12.85 debit Groceries Platinum Delta SkyMiles
9/08/2016 Uber.com UBER TECHNOLOGIES INC 9.11 debit Rental Car & Taxi United Visa
9/07/2016 Jamba Juice JAMBA JUICE 00000129LAS VEGAS NV86544139 7025667210 320162510288676513 7.56 debit Food & Dining Platinum Delta SkyMiles
9/07/2016 Miracle Mile Coffe MIRACLE MILE COFFE 5LAS VEGAS NV000825071 7026960564 320162510290521088 8.20 debit Coffee Shops Platinum Delta SkyMiles
9/07/2016 Spearmint Rhino Highla Spearmint Rhino 3340 S HIGHLA NV7027963600 320162510290730307 43.60 debit Food & Dining Platinum Delta SkyMiles
9/07/2016 JetBlue JETBLUE AIRWAYS 4100WEB CHECKINTBMANO 8005382583 320162510288024293 25.00 debit Air Travel Platinum Delta SkyMiles
9/07/2016 Hudson News HUDSONNEWS ST1028 0LAS VEGAS NV14300072 800-326-7711 320162510293292652 4.75 debit Newspapers & Magazines Platinum Delta SkyMiles
9/07/2016 Check 5140 CHECK 5140 3150.00 debit Mortgage & Rent CHASE PREMIER
9/07/2016 Uber.com UBER TECHNOLOGIES INC 10.86 debit Rental Car & Taxi United Visa
9/06/2016 ATM Withdrawal NON-CHASE ATM WITHDRAW148158 09/06CAESARS P 106.99 debit Transfer for Cash Spending CHASE PREMIER
9/06/2016 ATM Withdrawal NON-CHASE ATM WITHDRAW002949 09/042801 WEST 436.00 debit Amusement CHASE PREMIER
9/05/2016 Whole Foods WHOLEFDS GIL #10530 BERKELEY CA00480400010 5108098293 320162490267126488 14.15 debit Groceries Platinum Delta SkyMiles
9/05/2016 Uber Us Un UBER *US SEP04 UN6FZ 12.51 debit Rental Car & Taxi United Visa
9/05/2016 Uber Us Zzbvi UBER *US SEP04 ZZBVI 13.03 debit Rental Car & Taxi United Visa
9/04/2016 The Brixton THE BRIXTON SAN FRANCISCO CA85180896248 415-403-1114 320162480257482201 29.45 debit Restaurants Platinum Delta SkyMiles
9/03/2016 REI REI #38 SAN CARLOS SAN CARLOS CA35399803800 SPORTING GOODS STORE 320162470236290733 13.00 debit Sporting Goods Platinum Delta SkyMiles
9/03/2016 Union 76 UNION 76 09436684 BERKELEY CA4917840911 UNION 76 320162470244689882 55.98 debit Gas & Fuel Platinum Delta SkyMiles
9/03/2016 Moshi Moshi MOSHI MOSHI SAN FRANCISCO CA6655190 RESTAURANT 320162470239176336 36.43 debit Restaurants Platinum Delta SkyMiles
9/02/2016 Tupper and Reed TUPPER AND REED 0000BERKELEY CA99999996246 4157422384 320162460225353170 39.05 debit Music Platinum Delta SkyMiles
9/02/2016 Philz Coffee AplPay PHILZ COFFEE Menlo ParkP5BKQA squareup.com/receipts 320162460218533379 2.75 debit Coffee Shops Platinum Delta SkyMiles
9/02/2016 ATM Withdrawal ATM WITHDRAWAL004734 09/021870 SOLA 100.00 debit Transfer for Cash Spending CHASE PREMIER
9/02/2016 ATM Deposit ATM CHECK DEPOSIT 09/02 1870 SOLANO AVE BERKELEY CA 1400.00 credit Mortgage & Rent CHASE PREMIER
9/02/2016 Transfer to United Visa Payment to Chase card ending in9374 125.49 debit Credit Card Payment CHASE PREMIER
9/02/2016 Wnyc Wqxr Njpr WNYC/WQXR/NJPR/NYPR RADIO 6.25 debit Charity United Visa
9/02/2016 Transfer from CHASE PREMIER Payment Thank You - Web 125.49 credit Credit Card Payment United Visa
9/01/2016 Fastrak FASTRAK CSC TOLLS OAKLAND CA29297163 415-486-8655 320162450213821911 105.00 debit Public Transportation Platinum Delta SkyMiles
9/01/2016 Ippuku IPPUKU 5429298051999BERKELEY CA24224436245 5106651969 320162450207404777 36.14 debit Restaurants Platinum Delta SkyMiles
9/01/2016 MTA CCSF MTA IPS PRKNG METER 2.50 debit Parking CREDIT CARD
8/31/2016 Gilman Coffee P 1312 GILMAN COFFEE &Albany CAP4ZHUX squareup.com/receipts 320162440187482812 6.25 debit Coffee Shops Platinum Delta SkyMiles
8/31/2016 Account Maintenance Fee MONTHLY SERVICE FEE 12.00 debit Bank Fee BUSINESS CLASSIC
8/29/2016 The Fremont Diner THE FREMONT DINER Sonoma CAP4TOKJ squareup.com/receipts 320162420168346774 69.95 debit Restaurants Platinum Delta SkyMiles
8/29/2016 U-Haul UHAUL RENTAL/PURCHASRICHMOND CA21598279 (800)528-0463 320162420163529620 60.17 debit Home Services Platinum Delta SkyMiles
8/29/2016 JetBlue JETBLUE AIRWAYS 9010JETBLUE NYTBMANO 8005382583 320162420164045213 135.20 debit Air Travel Platinum Delta SkyMiles
8/29/2016 CVS CVS/PHARMACY BERKELEY CA10128257 8007467287 320162420166554709 27.99 debit Pharmacy Platinum Delta SkyMiles
8/29/2016 Chevron CHEVRON 0090319/CHEVVALLEJO CASERVICE STN 320162420167524592 62.87 debit Gas & Fuel Platinum Delta SkyMiles
8/29/2016 Sqc Alexis Konevich SQC*<ALEXIS KONEVICH SAN FRANCISCO CA 08/29 120.00 credit Restaurants CHASE PREMIER
8/29/2016 Sqc Alexis Konevich SQC*<ALEXIS KONEVICH SAN FRANCISCO CA 08/29 40.00 credit Restaurants CHASE PREMIER
8/28/2016 Biergarten WESTBRAE BIERGARTEN BERKELEY CA10156320160 5107896875 320162410158260211 34.40 debit Alcohol & Bars Platinum Delta SkyMiles
8/28/2016 Fertile Grounds FERTILE GROUNDS CAFEBerkeley CAP4SWYO squareup.com/receipts 320162410148390138 17.49 debit Fast Food Platinum Delta SkyMiles
Raw
index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style>
.bar {
fill: steelblue;
}
.axis path {
display: none;
}
</style>
<svg width="960" height="500"></svg>
<script src="//d3js.org/d3.v4.min.js"></script>
<script>
var svg = d3.select("svg"),
margin = {top: 20, right: 20, bottom: 30, left: 40},
width = +svg.attr("width") - margin.left - margin.right,
height = +svg.attr("height") - margin.top - margin.bottom,
g = svg.append("g").attr("transform", "translate(" + margin.left + "," + margin.top + ")");
var x = d3.scaleBand()
.rangeRound([0, width])
.padding(0.1)
.align(0.1);
var y = d3.scaleLinear()
.rangeRound([height, 0]);
var z = d3.scaleOrdinal()
.range(["#98abc5", "#8a89a6", "#7b6888", "#6b486b", "#a05d56", "#d0743c", "#ff8c00"]);
var stack = d3.stack();
var parseDate = d3.timeParse("%m/%d/%Y");
var formatMonth = d3.timeFormat("%m-%y");
d3.csv("data.csv", type, function(error, data) {
if (error) throw error;
data.forEach(function(d) {
d.Date = +parseDate(d.Date);
var month = formatMonth(d.Date);
d.month = month;
//console.log(data[0]);
//d.categories = color.domain().map(function(Category) { return {month:month, Category: Category, y0: y0, y1: y0 += +d[Category]}; });
//d.total = d.categories[d.categories.length - 1].y1;
});
x.domain([d3.min(data, function(d) { return d.month; }),d3.max(data, function(d) { return d.month; })]);
//x domain map to month
y.domain([0, d3.max(data, function(d) { return d.Amount; })]).nice();
//y domain needs to map to amount by month
z.domain(function(d) { return d.Category; });
//z domain needs to map to categories
g.selectAll(".serie")
.data(stack.keys(data.columns.slice(1))(data))
.enter().append("g")
.attr("class", "serie")
.attr("fill", function(d) { return z(d.key); })
.selectAll("rect")
.data(function(d) { return d; })
.enter().append("rect")
.attr("x", function(d) { return x(d.data.month); })
.attr("y", function(d) { return y(d[1]); })
.attr("height", function(d) { return y(d[0]) - y(d[1]); })
.attr("width", x.bandwidth());
g.append("g")
.attr("class", "axis axis--x")
.attr("transform", "translate(0," + height + ")")
.call(d3.axisBottom(x));
g.append("g")
.attr("class", "axis axis--y")
.call(d3.axisLeft(y).ticks(10, "s"))
.append("text")
.attr("x", 2)
.attr("y", y(y.ticks(10).pop()))
.attr("dy", "0.35em")
.attr("text-anchor", "start")
.attr("fill", "#000")
.text("Population");
var legend = g.selectAll(".legend")
.data(z.domain())
.enter().append("g")
.attr("class", "legend")
.attr("transform", function(d, i) { return "translate(0," + i * 20 + ")"; })
.style("font", "10px sans-serif");
legend.append("rect")
.attr("x", width - 18)
.attr("width", 18)
.attr("height", 18)
.attr("fill", z);
legend.append("text")
.attr("x", width - 24)
.attr("y", 9)
.attr("dy", ".35em")
.attr("text-anchor", "end")
.text(function(d) { return d; });
});
function type(d, i, columns) {
for (i = 1, t = 0; i < columns.length; ++i) t += d[columns[i]] = +d[columns[i]];
d.total = t;
return d;
}
</script>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment