Accessing sales data from woocommerce database with python

I am using a Python script to access our WordPress db and download some data that I hope to use to create regular sales reports. I’m using mysql.connector to connect to the table called wp_woocommerce_order_items.

This table is giving me the name and order ID for each transaction, but it doesn’t include date or price. I can see that in another table called wp_woocommerce_sessions it seems to have much more info, but it looks encrypted or something, like:

"cart_totals";s:367:"a:15:{s:8:"subtotal";i:0;s:12:"subtotal_tax";i:0;s:14:"shipping_total";i:0;s:12:"shipping_tax";i:0;s:14:

I don’t quite understand what I’m seeing here. What kind of data is this? Is there any way to get actual values out of it?

The page I need help with: [log in to see the link]