Historic data conversion

[tevpg]

So far:

• [x] put old gsheet records into csv
• [x] got dates for them figured out (despite poor data entry quality)
• [x] figure out valet hours
• [x] convert with csv2tracker
• [ ] clean up any egregious but reasonably fixable data errors (see far below)
• [x] figure out the tricky transition dates (part gsheet, part tagtracker)
• [x] put historic .dat files into common repo ('support' folder) for tracker2db

Valet hours, as far as I can figure:	Starting	Mo		Tu		We		Th		Fr		Sa		Su
March 17	730	1800	730	1800	730	1800	730	1800	730	2000	1000	2000	1000	1700
May 1	730	1800	730	1800	730	2000	730	2000	730	2200	1000	2200	1000	1700
May 22 ONLY	900	1700
June 11 ONLY													1000	1830

[tevpg]

Conversion errors (just for the record)

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>for %f in (*.csv) do python ..\tagtracker\csv2tracker.py %f

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-18.csv

Reading file 2023-03-18.csv, data for 2023-03-17...
   ...checking for errors...
Warning: Unmatched bike check-out bg7 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out pua15 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out bh4 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out bh8 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out ba5 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out pub7 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out bh1 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out pub1 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out pub14 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out bc1 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out pua13 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out bi4 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out bj2 (discarded) in file '2023-03-18.csv'
Warning: Unmatched bike check-out pub6 (discarded) in file '2023-03-18.csv'
   ...writing tags to cityhall_2023-03-17.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-19.csv

Reading file 2023-03-19.csv, data for 2023-03-18...
   ...checking for errors...
Warning: Unmatched bike check-out pa8 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pb1 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pb7 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pc2 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pb0 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bg8 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bg3 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pc6 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bh2 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bf3 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pa0 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bf10 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bb12 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bg9 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bh1 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bh0 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pc15 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bh8 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pd2 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bb8 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out bi2 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pd4 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pc3 (discarded) in file '2023-03-19.csv'
Warning: Unmatched bike check-out pd3 (discarded) in file '2023-03-19.csv'
Warning: Check out before check in for pc1 (discarded) in file '2023-03-19.csv'
   ...writing tags to cityhall_2023-03-18.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-20.csv

Reading file 2023-03-20.csv, data for 2023-03-19...
   ...checking for errors...
Warning: Unmatched bike check-out wa7 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wa8 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wa10 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wa6 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wa4 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bg5 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bg3 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out be8 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out be9 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wb4 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wb5 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out wa11 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bh4 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bi0 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bh2 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bg4 (discarded) in file '2023-03-20.csv'
Warning: Unmatched bike check-out bg0 (discarded) in file '2023-03-20.csv'
   ...writing tags to cityhall_2023-03-19.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-21.csv

Reading file 2023-03-21.csv, data for 2023-03-20...
   ...checking for errors...
Warning: Unmatched bike check-out wa0 (discarded) in file '2023-03-21.csv'
Warning: Unmatched bike check-out be1 (discarded) in file '2023-03-21.csv'
   ...writing tags to cityhall_2023-03-20.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-22.csv

Reading file 2023-03-22.csv, data for 2023-03-21...
Warning: Unrecognized tag 'wa1o' in line 5 in file '2023-03-22.csv'
Warning: Unrecognized tag 'bho' in line 16 in file '2023-03-22.csv'
Warning: Unrecognized tag 'bhs' in line 18 in file '2023-03-22.csv'
Warning: Unrecognized tag 'bfo' in line 46 in file '2023-03-22.csv'
Warning: Unrecognized tag 'wco' in line 48 in file '2023-03-22.csv'
Warning: Unrecognized tag 'wco' in line 49 in file '2023-03-22.csv'
   ...checking for errors...
Warning: Unmatched bike check-out wb7 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wc6 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bh0 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bg4 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bh6 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wc9 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bh2 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wc11 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bg5 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bg6 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bh1 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wd1 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wa10 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out bc9 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wd2 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wd3 (discarded) in file '2023-03-22.csv'
Warning: Unmatched bike check-out wd0 (discarded) in file '2023-03-22.csv'
   ...writing tags to cityhall_2023-03-21.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-23.csv

Reading file 2023-03-23.csv, data for 2023-03-22...
Warning: Unrecognized tag '-' in line 19 in file '2023-03-23.csv'
   ...checking for errors...
Warning: Unmatched bike check-out wc15 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out bg8 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out wd15 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out wd13 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out wd9 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out wd12 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out wd10 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out wd8 (discarded) in file '2023-03-23.csv'
Warning: Unmatched bike check-out bf0 (discarded) in file '2023-03-23.csv'
   ...writing tags to cityhall_2023-03-22.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-24.csv

Reading file 2023-03-24.csv, data for 2023-03-23...
   ...checking for errors...
Warning: Unmatched bike check-out wc8 (discarded) in file '2023-03-24.csv'
Warning: Unmatched bike check-out wa13 (discarded) in file '2023-03-24.csv'
Warning: Unmatched bike check-out ba15 (discarded) in file '2023-03-24.csv'
   ...writing tags to cityhall_2023-03-23.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-25.csv

Reading file 2023-03-25.csv, data for 2023-03-24...
   ...checking for errors...
Warning: Unmatched bike check-out bf1 (discarded) in file '2023-03-25.csv'
Warning: Unmatched bike check-out wc1 (discarded) in file '2023-03-25.csv'
Warning: Unmatched bike check-out wc4 (discarded) in file '2023-03-25.csv'
   ...writing tags to cityhall_2023-03-24.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-26.csv

Reading file 2023-03-26.csv, data for 2023-03-25...
Warning: Unrecognized tag ' ' in line 60 in file '2023-03-26.csv'
   ...checking for errors...
Warning: Unmatched bike check-out wa15 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wc12 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wc15 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wd1 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wd0 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wd2 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wd3 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wc13 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out bg2 (discarded) in file '2023-03-26.csv'
Warning: Unmatched bike check-out wc11 (discarded) in file '2023-03-26.csv'
   ...writing tags to cityhall_2023-03-25.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-27.csv

Reading file 2023-03-27.csv, data for 2023-03-26...
   ...checking for errors...
Warning: Unmatched bike check-out wb7 (discarded) in file '2023-03-27.csv'
   ...writing tags to cityhall_2023-03-26.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-28.csv

Reading file 2023-03-28.csv, data for 2023-03-27...
   ...checking for errors...
Warning: Unmatched bike check-out wc8 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wc2 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wc9 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wd0 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wc4 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wg7 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wg6 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out bh1 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out bh2 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wb1 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wh9 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out wd12 (discarded) in file '2023-03-28.csv'
Warning: Unmatched bike check-out bi1 (discarded) in file '2023-03-28.csv'
Warning: Check out before check in for wb11 (discarded) in file '2023-03-28.csv'
   ...writing tags to cityhall_2023-03-27.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-29.csv

Reading file 2023-03-29.csv, data for 2023-03-28...
   ...checking for errors...
Warning: Unmatched bike check-out wa7 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wa8 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wa10 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wa6 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wa4 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bg5 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bg3 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out be8 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out be9 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wb4 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wb5 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out wa11 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bh4 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bi0 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bh2 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bg4 (discarded) in file '2023-03-29.csv'
Warning: Unmatched bike check-out bg0 (discarded) in file '2023-03-29.csv'
   ...writing tags to cityhall_2023-03-28.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-30.csv

Reading file 2023-03-30.csv, data for 2023-03-29...
   ...checking for errors...
Warning: Unmatched bike check-out we4 (discarded) in file '2023-03-30.csv'
Warning: Unmatched bike check-out wa7 (discarded) in file '2023-03-30.csv'
Warning: Unmatched bike check-out we0 (discarded) in file '2023-03-30.csv'
Warning: Unmatched bike check-out bh10 (discarded) in file '2023-03-30.csv'
Warning: Unmatched bike check-out wa6 (discarded) in file '2023-03-30.csv'
   ...writing tags to cityhall_2023-03-29.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-03-31.csv

Reading file 2023-03-31.csv, data for 2023-03-30...
Warning: Unrecognized tag 'wco' in line 43 in file '2023-03-31.csv'
   ...checking for errors...
Warning: Check out before check in for bh2 (discarded) in file '2023-03-31.csv'
   ...writing tags to cityhall_2023-03-30.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-01.csv

Reading file 2023-04-01.csv, data for 2023-03-31...
   ...checking for errors...
Warning: Unmatched bike check-out wb14 (discarded) in file '2023-04-01.csv'
Warning: Unmatched bike check-out wb15 (discarded) in file '2023-04-01.csv'
Warning: Unmatched bike check-out wc2 (discarded) in file '2023-04-01.csv'
Warning: Unmatched bike check-out wc1 (discarded) in file '2023-04-01.csv'
Warning: Unmatched bike check-out wc3 (discarded) in file '2023-04-01.csv'
Warning: Unmatched bike check-out wc4 (discarded) in file '2023-04-01.csv'
   ...writing tags to cityhall_2023-03-31.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-02.csv

Reading file 2023-04-02.csv, data for 2023-04-01...
Warning: Unrecognized tag ' ' in line 17 in file '2023-04-02.csv'
Warning: Unrecognized tag '"' in line 55 in file '2023-04-02.csv'
Warning: Unrecognized tag '"' in line 55 in file '2023-04-02.csv'
   ...checking for errors...
Warning: Unmatched bike check-out bf3 (discarded) in file '2023-04-02.csv'
Warning: Unmatched bike check-out wab7 (discarded) in file '2023-04-02.csv'
Warning: Unmatched bike check-out wb4 (discarded) in file '2023-04-02.csv'
Warning: Unmatched bike check-out bf4 (discarded) in file '2023-04-02.csv'
Warning: Unmatched bike check-out bf5 (discarded) in file '2023-04-02.csv'
Warning: Unmatched bike check-out wb2 (discarded) in file '2023-04-02.csv'
Warning: Unmatched bike check-out bf6 (discarded) in file '2023-04-02.csv'
Warning: Check out before check in for wb1 (discarded) in file '2023-04-02.csv'
   ...writing tags to cityhall_2023-04-01.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-03.csv

Reading file 2023-04-03.csv, data for 2023-04-02...
   ...checking for errors...
Warning: Unmatched bike check-out be2 (discarded) in file '2023-04-03.csv'
Warning: Unmatched bike check-out be4 (discarded) in file '2023-04-03.csv'
Warning: Unmatched bike check-out wa6 (discarded) in file '2023-04-03.csv'
Warning: Unmatched bike check-out wa5 (discarded) in file '2023-04-03.csv'
Warning: Unmatched bike check-out wb3 (discarded) in file '2023-04-03.csv'
   ...writing tags to cityhall_2023-04-02.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-04.csv

Reading file 2023-04-04.csv, data for 2023-04-03...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-03.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-05.csv

Reading file 2023-04-05.csv, data for 2023-04-04...
   ...checking for errors...
Warning: Check out before check in for bh4 (discarded) in file '2023-04-05.csv'
   ...writing tags to cityhall_2023-04-04.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-06.csv

Reading file 2023-04-06.csv, data for 2023-04-05...
Warning: Unrecognized tag ' ' in line 40 in file '2023-04-06.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-04-05.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-07.csv

Reading file 2023-04-07.csv, data for 2023-04-06...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-06.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-08.csv

Reading file 2023-04-08.csv, data for 2023-04-07...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-07.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-09.csv

Reading file 2023-04-09.csv, data for 2023-04-08...
Warning: Unrecognized tag ' ' in line 49 in file '2023-04-09.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-04-08.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-10.csv

Reading file 2023-04-10.csv, data for 2023-04-09...
Warning: Unrecognized tag 'wbo' in line 45 in file '2023-04-10.csv'
Warning: Unrecognized tag ' ' in line 52 in file '2023-04-10.csv'
   ...checking for errors...
Warning: Unmatched bike check-out bf0 (discarded) in file '2023-04-10.csv'
   ...writing tags to cityhall_2023-04-09.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-11.csv

Reading file 2023-04-11.csv, data for 2023-04-10...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-10.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-12.csv

Reading file 2023-04-12.csv, data for 2023-04-11...
Warning: Unrecognized tag ' ' in line 49 in file '2023-04-12.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-04-11.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-13.csv

Reading file 2023-04-13.csv, data for 2023-04-12...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-12.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-14.csv

Reading file 2023-04-14.csv, data for 2023-04-13...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-13.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-15.csv

Reading file 2023-04-15.csv, data for 2023-04-14...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-14.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-16.csv

Reading file 2023-04-16.csv, data for 2023-04-15...
Warning: Unrecognized tag ' ' in line 62 in file '2023-04-16.csv'
Warning: Unrecognized tag ' ' in line 64 in file '2023-04-16.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-04-15.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-17.csv

Reading file 2023-04-17.csv, data for 2023-04-16...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-16.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-18.csv

Reading file 2023-04-18.csv, data for 2023-04-17...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-17.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-19.csv

Reading file 2023-04-19.csv, data for 2023-04-18...
   ...checking for errors...
Warning: Check out before check in for wb6 (discarded) in file '2023-04-19.csv'
   ...writing tags to cityhall_2023-04-18.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-20.csv

Reading file 2023-04-20.csv, data for 2023-04-19...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-19.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-21.csv

Reading file 2023-04-21.csv, data for 2023-04-20...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-20.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-22.csv

Reading file 2023-04-22.csv, data for 2023-04-21...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-21.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-23.csv

Reading file 2023-04-23.csv, data for 2023-04-22...
Warning: Unrecognized tag ' ' in line 49 in file '2023-04-23.csv'
Warning: Unrecognized tag ' ' in line 64 in file '2023-04-23.csv'
   ...checking for errors...
Warning: Check out before check in for be3 (discarded) in file '2023-04-23.csv'
   ...writing tags to cityhall_2023-04-22.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-24.csv

Reading file 2023-04-24.csv, data for 2023-04-23...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-23.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-25.csv

Reading file 2023-04-25.csv, data for 2023-04-24...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-24.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-26.csv

Reading file 2023-04-26.csv, data for 2023-04-25...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-25.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-27.csv

Reading file 2023-04-27.csv, data for 2023-04-26...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-26.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-28.csv

Reading file 2023-04-28.csv, data for 2023-04-27...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-27.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-29.csv

Reading file 2023-04-29.csv, data for 2023-04-28...
   ...checking for errors...
Warning: Check out before check in for wd8 (discarded) in file '2023-04-29.csv'
   ...writing tags to cityhall_2023-04-28.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-04-30.csv

Reading file 2023-04-30.csv, data for 2023-04-29...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-29.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-01.csv

Reading file 2023-05-01.csv, data for 2023-04-30...
   ...checking for errors...
   ...writing tags to cityhall_2023-04-30.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-02.csv

Reading file 2023-05-02.csv, data for 2023-05-01...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-01.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-03.csv

Reading file 2023-05-03.csv, data for 2023-05-02...
   ...checking for errors...
Warning: Unmatched bike check-out be0 (discarded) in file '2023-05-03.csv'
   ...writing tags to cityhall_2023-05-02.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-04.csv

Reading file 2023-05-04.csv, data for 2023-05-03...
Warning: Unrecognized tag '78' in line 12 in file '2023-05-04.csv'
Warning: Unrecognized tag ' ' in line 12 in file '2023-05-04.csv'
Warning: Unrecognized tag '60' in line 25 in file '2023-05-04.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-03.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-05.csv

Reading file 2023-05-05.csv, data for 2023-05-04...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-04.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-06.csv

Reading file 2023-05-06.csv, data for 2023-05-05...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-05.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-07.csv

Reading file 2023-05-07.csv, data for 2023-05-06...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-06.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-08.csv

Reading file 2023-05-08.csv, data for 2023-05-07...
Warning: Unrecognized tag ' ' in line 4 in file '2023-05-08.csv'
Warning: Unrecognized tag 'b09' in line 13 in file '2023-05-08.csv'
Warning: Unrecognized tag 'b07' in line 13 in file '2023-05-08.csv'
Warning: Unrecognized tag 'b09' in line 47 in file '2023-05-08.csv'
Warning: Unrecognized tag 'b07' in line 53 in file '2023-05-08.csv'
   ...checking for errors...
Warning: Check out before check in for wa15 (discarded) in file '2023-05-08.csv'
   ...writing tags to cityhall_2023-05-07.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-09.csv

Reading file 2023-05-09.csv, data for 2023-05-08...
Warning: Unrecognized tag '46' in line 12 in file '2023-05-09.csv'
Warning: Unrecognized tag '27' in line 12 in file '2023-05-09.csv'
Warning: Unrecognized tag '12' in line 21 in file '2023-05-09.csv'
Warning: Unrecognized tag '18' in line 22 in file '2023-05-09.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-08.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-10.csv

Reading file 2023-05-10.csv, data for 2023-05-09...
Warning: Unrecognized tag '87' in line 12 in file '2023-05-10.csv'
Warning: Unrecognized tag '48' in line 22 in file '2023-05-10.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-09.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-11.csv

Reading file 2023-05-11.csv, data for 2023-05-10...
Warning: Unrecognized tag '101' in line 12 in file '2023-05-11.csv'
Warning: Unrecognized tag '63' in line 25 in file '2023-05-11.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-10.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-12.csv

Reading file 2023-05-12.csv, data for 2023-05-11...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-11.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-13.csv

Reading file 2023-05-13.csv, data for 2023-05-12...
Warning: Unrecognized tag '78' in line 12 in file '2023-05-13.csv'
Warning: Unrecognized tag '41' in line 18 in file '2023-05-13.csv'
   ...checking for errors...
Warning: Check out before check in for we2 (discarded) in file '2023-05-13.csv'
   ...writing tags to cityhall_2023-05-12.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-14.csv

Reading file 2023-05-14.csv, data for 2023-05-13...
Warning: Unrecognized tag ' ' in line 8 in file '2023-05-14.csv'
   ...checking for errors...
Warning: Unmatched bike check-out wb15 (discarded) in file '2023-05-14.csv'
   ...writing tags to cityhall_2023-05-13.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-15.csv

Reading file 2023-05-15.csv, data for 2023-05-14...
   ...checking for errors...
Warning: Unmatched bike check-out wa5 (discarded) in file '2023-05-15.csv'
   ...writing tags to cityhall_2023-05-14.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-16.csv

Reading file 2023-05-16.csv, data for 2023-05-15...
Warning: Unrecognized tag '65' in line 12 in file '2023-05-16.csv'
Warning: Unrecognized tag ' ' in line 17 in file '2023-05-16.csv'
Warning: Unrecognized tag '26' in line 20 in file '2023-05-16.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-15.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-17.csv

Reading file 2023-05-17.csv, data for 2023-05-16...
Warning: Unrecognized tag '107' in line 12 in file '2023-05-17.csv'
Warning: Unrecognized tag '45' in line 22 in file '2023-05-17.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-16.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-18.csv

Reading file 2023-05-18.csv, data for 2023-05-17...
   ...checking for errors...
Warning: Unmatched bike check-out pa1 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out pa0 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out bk0 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out bk1 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out we11 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out pa5 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out wa0 (discarded) in file '2023-05-18.csv'
Warning: Unmatched bike check-out bk8 (discarded) in file '2023-05-18.csv'
   ...writing tags to cityhall_2023-05-17.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-19.csv

Reading file 2023-05-19.csv, data for 2023-05-18...
Warning: Unrecognized tag '78' in line 12 in file '2023-05-19.csv'
Warning: Unrecognized tag '58' in line 26 in file '2023-05-19.csv'
Warning: Unrecognized tag '136' in line 26 in file '2023-05-19.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-18.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-20.csv

Reading file 2023-05-20.csv, data for 2023-05-19...
Warning: Unrecognized tag ' ' in line 15 in file '2023-05-20.csv'
   ...checking for errors...
Warning: Unmatched bike check-out bj0 (discarded) in file '2023-05-20.csv'
   ...writing tags to cityhall_2023-05-19.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-21.csv

Reading file 2023-05-21.csv, data for 2023-05-20...
Warning: Unrecognized tag ' ' in line 24 in file '2023-05-21.csv'
   ...checking for errors...
Warning: Check out before check in for be6 (discarded) in file '2023-05-21.csv'
   ...writing tags to cityhall_2023-05-20.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-22.csv

Reading file 2023-05-22.csv, data for 2023-05-21...
Warning: Unrecognized tag ' ' in line 14 in file '2023-05-22.csv'
   ...checking for errors...
   ...writing tags to cityhall_2023-05-21.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-23.csv

Reading file 2023-05-23.csv, data for 2023-05-22...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-22.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-24.csv

Reading file 2023-05-24.csv, data for 2023-05-23...
Warning: Unrecognized tag '93' in line 12 in file '2023-05-24.csv'
Warning: Unrecognized tag '44' in line 23 in file '2023-05-24.csv'
Warning: Unrecognized tag '137' in line 23 in file '2023-05-24.csv'
   ...checking for errors...
Warning: Unmatched bike check-out wd7 (discarded) in file '2023-05-24.csv'
   ...writing tags to cityhall_2023-05-23.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-25.csv

Reading file 2023-05-25.csv, data for 2023-05-24...
   ...checking for errors...
Warning: Unmatched bike check-out wd15 (discarded) in file '2023-05-25.csv'
   ...writing tags to cityhall_2023-05-24.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-26.csv

Reading file 2023-05-26.csv, data for 2023-05-25...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-25.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-27.csv

Reading file 2023-05-27.csv, data for 2023-05-26...
Warning: Unrecognized tag ' ' in line 13 in file '2023-05-27.csv'
Warning: Unrecognized tag '`' in line 47 in file '2023-05-27.csv'
Warning: Unrecognized tag 'a001' in line 49 in file '2023-05-27.csv'
   ...checking for errors...
Warning: Check out before check in for pa2 (discarded) in file '2023-05-27.csv'
Warning: Check out before check in for pa8 (discarded) in file '2023-05-27.csv'
Warning: Check out before check in for bn1 (discarded) in file '2023-05-27.csv'
   ...writing tags to cityhall_2023-05-26.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-28.csv

Reading file 2023-05-28.csv, data for 2023-05-27...
Warning: Unrecognized tag '`WE6' in line 18 in file '2023-05-28.csv'
Warning: Unrecognized tag 'pc' in line 26 in file '2023-05-28.csv'
Warning: Unrecognized tag ' ' in line 26 in file '2023-05-28.csv'
Warning: Unrecognized tag 'bk' in line 64 in file '2023-05-28.csv'
   ...checking for errors...
Warning: Unmatched bike check-out ef1 (discarded) in file '2023-05-28.csv'
Warning: Unmatched bike check-out ef4 (discarded) in file '2023-05-28.csv'
Warning: Unmatched bike check-out ef5 (discarded) in file '2023-05-28.csv'
   ...writing tags to cityhall_2023-05-27.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-29.csv

Reading file 2023-05-29.csv, data for 2023-05-28...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-28.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-30.csv

Reading file 2023-05-30.csv, data for 2023-05-29...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-29.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-05-31.csv

Reading file 2023-05-31.csv, data for 2023-05-30...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-30.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-06-01.csv

Reading file 2023-06-01.csv, data for 2023-05-31...
   ...checking for errors...
   ...writing tags to cityhall_2023-05-31.dat
   ...done

C:\Users\todd\Documents\wk\capital_bike\tt-historic-data>python ..\tagtracker\csv2tracker.py 2023-06-02.csv

[tevpg]

Over to @ironwoodcall to figure out which files to use from the cutover period

[ironwoodcall]

Tasks now include:

• [x] Compare each day where both systems used & decide which record to use
• [ ] Append the contemporary tag colour assignments to old datafiles (meanings have changed, especially purple)
• [ ] Record historic data to database (after full quality constraints in place)

[tevpg]

Converted historic files and older TT files, selected for best available for any given date, are collected here: https://drive.google.com/drive/u/0/folders/1TYxTqizQKaYXqH48fb01twPVFJDu1W-o

To-do to clean them up more:

• [x] change 'pu' to 'p'
• [ ] scan for tags that 'just don't seem right'
• [ ] create context-sections of oversize v regular
  • For early files where tag context is missing:
    • B=oversize
    • O=regular
    • P=regular
    • W=regular

[tevpg]

Super-problematic days:

Some of the days have ridiculous numbers of apparent leftover bikes. This chart is by fix-contexts.py, which fabricates contexts for datafiles where it's missing.

It feels like my time is worth more than the effort to crawl through the google spreadsheets and fix up the data errors one painful bit at a time, so we clearly have some decisions to make here.

Particularly outstanding is May 12 (53 bikes "left over") - and where the records for that day in the google spreadsheet end ~3pm (I checked). To fix that one would require the paper dataform.

                -Bikes In--   -Bikes Out-  Left   ---Times----
Date        EC  Reg Ovr Ttl   Reg Ovr Ttl  over   Close Latest
2023-03-17:  n   32  47  79    31  45  76     3   18:00  19:46
2023-03-18:  n   47  35  82    43  34  77     5   20:00  19:16
2023-03-19:  n   32  32  64    28  32  60     4   18:00  16:46
2023-03-20:  n   28  25  53    28  24  52     1   17:00  17:46
2023-03-21:  n   39  29  68    29  25  54    14   18:00  17:46
2023-03-22:  n   54  29  83    46  28  74     9   18:00  18:16
2023-03-23:  n   40  24  64    40  23  63     1   18:00  17:46
2023-03-24:  n   36  29  65    33  24  57     8   18:00  19:46
2023-03-25:  n   47  22  69    47  19  66     3   20:00  19:16
2023-03-26:  n   29  14  43    26  12  38     5   18:00  16:46
2023-03-27:  n   44  37  81    43  34  77     4   17:00  17:46
2023-03-28:  n   32  32  64    28  32  60     4   18:00  16:46
2023-03-29:  n   68  38 106    57  36  93    13   18:00  18:16
2023-03-30:  n   50  38  88    48  37  85     3   18:00  17:46
2023-03-31:  n   33  16  49    31  16  47     2   18:00  19:46
2023-04-01:  n   29  16  45    24  15  39     6   20:00  19:46
2023-04-02:  n   19  11  30    18  10  28     2   18:00  16:46
2023-04-03:  n   39  23  62    37  23  60     2   17:00  17:46
2023-04-04:  n   54  33  87    54  31  85     2   18:00  18:16
2023-04-05:  n   69  36 105    69  36 105     0   18:00  17:46
2023-04-06:  n   32  25  57    31  25  56     1   18:00  17:46
2023-04-07:  n   58  29  87    55  24  79     8   18:00  19:46
2023-04-08:  n   31  18  49    22  16  38    11   20:00  19:46
2023-04-09:  n    8   8  16     5   7  12     4   18:00  17:16
2023-04-10:  n   25  17  42    25  17  42     0   17:00  17:16
2023-04-11:  n   51  34  85    50  34  84     1   18:00  17:46
2023-04-12:  n   71  45 116    71  45 116     0   18:00  18:16
2023-04-13:  n   48  45  93    48  45  93     0   18:00  17:46
2023-04-14:  n   73  53 126    69  51 120     6   18:00  19:46
2023-04-15:  n   53  23  76    53  23  76     0   20:00  19:46
2023-04-16:  n   19  11  30    19  11  30     0   18:00  16:46
2023-04-17:  n   35  26  61    34  25  59     2   17:00  18:16
2023-04-18:  n   32  45  77    32  45  77     0   18:00  17:46
2023-04-19:  n   62  42 104    61  40 101     3   18:00  18:16
2023-04-20:  y   55  37  92    55  37  92     0   18:00  17:46
2023-04-21:  n   62  43 105    62  43 105     0   18:00  20:03
2023-04-22:  n   31  22  53    31  22  53     0   20:00  19:16
2023-04-23:  n   24  16  40    24  16  40     0   18:00  17:00
2023-04-24:  n   50  32  82    50  32  82     0   17:00  18:16
2023-04-25:  n   69  50 119    69  50 119     0   18:00  17:46
2023-04-26:  n   54  48 102    54  48 102     0   18:00  18:16
2023-04-27:  n   56  59 115    56  59 115     0   18:00  17:46
2023-04-28:  n   72  53 125    72  53 125     0   18:00  19:46
2023-04-29:  n  108  59 167    96  59 155    12   20:00  19:46
2023-04-30:  n   41  24  65    41  24  65     0   18:00  17:16
2023-05-01:  n   80  37 117    80  37 117     0   17:00  18:25
2023-05-02:  n   72  58 130    72  58 130     0   18:00  17:46
2023-05-03:  n   80  58 138    80  58 138     0   18:00  19:46
2023-05-04:  n   74  59 133    74  59 133     0   20:00  19:46
2023-05-05:  n   36  22  58    36  22  58     0   20:00  21:46
2023-05-06:  n   83  44 127    82  42 124     3   22:00  21:46
2023-05-07:  n   54  27  81    52  24  76     5   12:00  16:46
2023-05-08:  n   64  39 103    58  32  90    13   17:00  17:40
2023-05-09:  n   74  61 135    74  61 135     0   18:00  18:16
2023-05-10:  n   94  70 164    94  70 164     0   18:00  20:16
2023-05-11:  n   81  66 147    81  66 147     0   20:00  20:16
2023-05-12:  n   68  52 120    33  34  67    53   20:00  15:16
2023-05-13:  n   81  40 121    81  40 121     0   22:00  21:46
2023-05-14:  n   49  26  75    49  25  74     1   12:00  16:46
2023-05-15:  n   57  36  93    55  35  90     3   17:00  17:46
2023-05-16:  n   88  64 152    88  64 152     0   18:00  18:16
2023-05-17:  n   88  73 161    85  70 155     6   18:00  20:16
2023-05-18:  n   72  64 136    72  64 136     0   20:00  19:16
2023-05-19:  n   85  64 149    85  64 149     0   20:00  21:46
2023-05-20:  n   83  61 144    83  61 144     0   22:00  21:46
2023-05-21:  n   75  21  96    74  21  95     1   12:00  16:46
2023-05-22:  y  112  72 184   112  72 184     0   17:00  17:05
2023-05-23:  n   75  61 136    75  61 136     0   18:00  17:46
2023-05-24:  y   98  75 173    98  75 173     0   18:00  19:55
2023-05-25:  y   69  69 138    69  69 138     0   20:00  19:55
2023-05-26:  n  110  89 199   110  89 199     0   20:00  21:46
2023-05-27:  n  121  68 189   118  65 183     6   22:00  20:46
2023-05-28:  y  111  43 154   111  43 154     0   12:00  18:26
2023-05-29:  y   78  56 134    78  56 134     0   17:00  18:03
2023-05-30:  y   87  62 149    87  62 149     0   18:00  17:59
2023-05-31:  y   93  61 154    93  61 154     0   18:00  20:04
2023-06-01:  y   98  67 165    98  67 165     0   20:00  19:55
2023-06-02:  y  132 114 246   132 114 246     0   20:00  22:04
2023-06-03:  y  148  61 209   147  60 207     2   22:00  21:57
2023-06-04:  y  100  67 167   100  67 167     0   12:00  19:29
2023-06-05:  y   70  48 118    70  48 118     0   17:00  17:58
2023-06-06:  y   84  48 132    83  48 131     1   18:00  18:00
2023-06-07:  y  107  74 181   107  74 181     0   18:00  20:00
2023-06-08:  y  100  77 177    99  77 176     1   20:00  20:06
2023-06-09:  y   64  55 119    64  55 119     0   22:00  22:00
2023-06-10:  y   37  26  63    37  26  63     0   22:00  21:54
2023-06-11:  y   71  52 123    71  52 123     0   18:30  18:11
2023-06-12:  y   70  47 117    70  47 117     0   18:00  17:46
2023-06-13:  y   94  65 159    93  65 158     1   18:00  17:53
2023-06-14:  y  137  81 218   136  81 217     1   20:00  20:02
2023-06-15:  y   99  75 174    99  75 174     0   20:00  20:03
2023-06-16:  y   81  54 135    81  54 135     0   22:00  21:59
2023-06-17:  y   83  36 119    82  36 118     1   22:00  21:48
2023-06-18:  y   48  40  88    48  40  88     0   17:00  16:59
2023-06-19:  y   54  56 110    54  56 110     0   18:00  17:54
2023-06-20:  y   63  52 115    62  52 114     1   18:00  17:58
2023-06-21:  y  114  69 183   113  69 182     1   20:00  20:03
2023-06-22:  y  120  76 196   120  76 196     0   20:00  19:56
(EC = Existing Context, not calculated from recorded tags)