The API returns the following columns when you query the postviews table:
- date
- post_id
- post_title
- post_permalink
- views
For my blog the post_id column was either empty or 0 (for the homepage). So unless you have good values there, you will have to work from the post_permalink value and determine whether it is a page or a post (via a query on the database or a regex on the URL?), and then query your database for the post thumbnail, because the WordPress.com stats API does not collect info on that.
Related Posts:
- Jetpack – stats_get_csv period parameter
- How to disable Jetpack modules such as Stats?
- What does this number represent in JetPack stats? [closed]
- I have a self hosted blog but now the WordPress.com stats plugin has stopped working
- How do I remove quantcast from my sites?
- Jetpack: Access visitor stats in templete
- Cannot activate Jetpack on my server
- Jetpack Infinite Scrolling For Multiple Columns On Same Page?
- Popular posts by view with Jetpack
- Gravatar Hovercards (Jetpack) jQuery error
- How do I update the site URL used by Jetpack subscribe widget [closed]
- Isotope with Infinite Scroll
- Jetpack infinite scroll not working on Twenty Twelve [closed]
- Can’t connect to my WordPress website using Windows 8 app?
- stats_get_csv (WordPress Stats) to only display top posts (not pages)
- jetpack suddendly stopped working [closed]
- Jetpack social icons in other places on site
- Why I can’t modified jetpack default blank.jpg on og:image?
- How to remove WordPress’ Jetpack plugin completely? [duplicate]
- Customizing JetPack Publicize Sharing
- Jetpack infinite scroll not working on twentysixteen custom theme
- Change $content_width based on screen size (functions.php)
- Jetpack button location buffering [closed]
- Does Jetpack conflicts with load_template()?
- Is it possible to remove subscription box from Jetpack stats page? [closed]
- Hide Jetpack for Contributor [closed]
- How do i import email addresses into WordPress.com subscriptions? [closed]
- Hiding Jetpack Ads from users who are signed in?
- Jetpack Infinite Scroll – changing number of posts
- How to allow users to write jetpack custom post types? [closed]
- Missing Jetpack Contact Form button when running locally [closed]
- Why does Jetpack insert it’s script outside the tag?
- Updating shortlinks from staging [closed]
- Jetpack Publicize and Android
- How can I get the Jetpack Image plugin to open links in a new window? [closed]
- Infinite Scroll on Self-hosted WordPress [closed]
- How to remove Stats by jetpack dashboard widget?
- Publicize in Jetpack stopped working on Custom Post Type it works in Blog Posts
- What is the difference between `Home page / Archieves` and the page set as homepage?
- Jetpack Top post widget (display post views)
- Unable to setup jetpack on my site
- Where does Jetpack store markdown?
- The plugin jetpack/jetpack.php has been deactivated due to an error: Plugin file does not exist
- Jetpack URL shortening, fixing after website URL change
- Infinite scroll function for Twenty Seventeen
- how to disable jetpack for non admins?
- Popular posts – based on pageviews
- Implementing backbone.js to retrieve category posts using JSON API
- Jetpack email sharing button to include image on email sent
- Is there a way to enable a Jetpack module via `functions.php`
- Pageview confusion [closed]
- Jetpack Infinite Scroll, Isotope and ImagesLoaded
- Delete old JetPack Site Stats? encrypted_search_terms in top search terms [closed]
- Force Jetpack to not use og:image tag for favicon / Site Icon [closed]
- Using Jetpack to track an Ajax powered blog [closed]
- Convert posts that used the Markdown Block into Markdown in Classic Editor posts?
- Generate Sitemap after removing JetPack
- TypeError: list indices must be integers or slices, not str
- IndexError: too many indices for array
- IndexError: too many indices for array
- Writing a pandas DataFrame to CSV file
- Writing a pandas DataFrame to CSV file
- What exactly does numpy.exp() do? [closed]
- f-statistics and p value suggest different results
- IndexError: too many indices for array
- ValueError : I/O operation on closed file
- How to normalize a NumPy array to a unit vector?
- How to plot ROC curve in Python
- Pandas: ValueError: cannot convert float NaN to integer
- csv.Error: iterator should return strings, not bytes
- How to normalize a NumPy array to a unit vector?
- Yahoo! Finance CSV file will not return Dow Jones (^DJI)
- Python – Reading and writing csv files with utf-8 encoding
- Invalid column count in CSV input on line 1 Error
- Invalid column count in CSV input on line 1 Error
- Python Error io.UnsupportedOperation: not readable
- load csv into 2D matrix with numpy for plotting
- Dump a NumPy array into a csv file
- (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
- How to parse a CSV file using PHP
- Is there a way to include commas in CSV columns without breaking the formatting?
- How to load a tsv file into a Pandas DataFrame?
- Parsing a comma-delimited std::string
- index 1 is out of bounds for axis 0 with size 1
- Difference between writerow() and writerows() methods of Python csv module
- Create a .csv file with values from a Python list
- Convert XML to CSV file
- TypeError: list indices must be integers or slices, not str
- How do I calculate percentiles with python/numpy?
- Bernoulli random number generator
- Convert from CSV to array in Python
- ValueError: cannot index with vector containing NA / NaN values
- (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
- ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
- Creating a dictionary from a csv file?
- Simple way to calculate median with MySQL
- How can I import an Excel file into SQL Server?
- Python import csv to list
- ValueError: x and y must be the same size
- Reading CSV file and storing values into an array