How can I get a table with the number of published posts by date?

the fastest way imho would be to create a custom sql statement:

global $wpdb;
$rows = $wpdb->query('SELECT DATE(post_date) AS date, COUNT(*) AS count FROM ' . $wpdb->posts . ' GROUP BY DATE(post_date) ORDER BY DATE(post_date)');
foreach ($rows as $row) {
    echo $row->date . ': ' . $row->count . '<br>';
}

Related Posts:

  1. Add custom Attachment Display Setting for images
  2. Rewriting post slug before post save
  3. Getting the post_id in wp_ajax function
  4. Change the default number of posts to show on mobile version
  5. I am trying to create a simple frontend form for posting
  6. Post content being duplicated by the_content();
  7. How can I pass $post object to ‘save_post’ add_action?
  8. 1 column admin screen options – move submitdiv to bottom
  9. Single Post Navigation Within Each Category
  10. Add confirmation popup on “Move to Trash”
  11. How to get the latest posting time of archived pages in WordPress?
  12. Insert posts in two tables
  13. get_next_post() not working
  14. How To Keep Posts from Being Displayed Two or More Times on My Homepage? [closed]
  15. custom wordpress post loop – hide iframe content
  16. Different template for posts of all subcategories of category
  17. Search for posts based on their url in the admin?
  18. Add custom field automatically (add_post_meta) with value based on number of words of article
  19. How to access featured image?
  20. Mark menu item as current-menu-item for category
  21. Best way to assign post position in a news site homepage? (no categories, no sticky posts)
  22. How do I restart my loop with get_next_post()?
  23. How do I use WP_Query to get a range of posts with custom fields that have numbers with letters in them?
  24. How to give capability (publish contributors posts) to author role?
  25. “Duplicate” Posts Appearing Since 3.1.2 Update
  26. Rename “post” to “article” throughout the admin back end [duplicate]
  27. Setup a custom dynamic post
  28. How to make a price range slider from get_post_meta?
  29. One menu for frontpage (one pager), and a different menu for posts
  30. pagination for single post by category
  31. Post page to display specific category
  32. How to create new post content templates for my users?
  33. Start post pagination at 0 instead of 1
  34. How do I change the core post search algorithm? Where is it found/constructed?
  35. Is it possible to add/tick a category to a post when it is created?
  36. How many posts does the loop return?
  37. Posts loop displaying the same post data
  38. Display Posts on Custom Page
  39. Possible to alternate between two loops
  40. How to get a post’s content? [closed]
  41. Blog Post On Home Page Displaying Page Published Date Not Post Published Date
  42. Why does a published post only displays the title and not the content in the site? [closed]
  43. Counter is skipping post when I still want it visible [closed]
  44. The_excerpt() doesn’t parse – how to change that?
  45. Can’t understand why sometimes a [caption] field appears
  46. Trying to edit archive.php to only show post extract, with featured image
  47. Divs appearing everywhere in post content
  48. Latest posts by category — how to exclude current post?
  49. Change post author without using wp_update_post()
  50. Posts page not showing correct image
  51. wp_query with ajax
  52. Post Title List on home page with time
  53. Add “Posted on” to post date
  54. Use posts_where to exclude posts ids from wp_query
  55. Get x recent posts by author?
  56. How to compare post tags?
  57. Get a term each custom post type
  58. Remove Featured Image from posts in specific category?
  59. Delete all Tag Links from Posts
  60. Adjust the order for returned posts
  61. Post in bulk based on category template
  62. Delete Post but retain image of post [WP REST API]
  63. user_has_cap filter allows “edit_others_posts” but not is not allowing updating/publishing
  64. how to add tags to post in the Loop?
  65. Add data attribute of post_id for Internal links
  66. Menu Items disappearing/being empty on save or post edit
  67. Single Post function to display all single post images in a carousel
  68. Display/Filter post using if else statement
  69. Search results for ACF data
  70. link to edit a post has empty target
  71. Nestling Posts Under Page & Justify Text
  72. Redirect to custom post if custom archive page has just one result?
  73. Adding posts updates previous post
  74. Strange behaviour in WordPress admin
  75. How do you update post date (year only) in a separate custom field?
  76. Creating a link to the first post in a category
  77. sometimes on saving a post as draft, it says Access Denied You don’t have permission to access “mywebsite.com/wp-admin/post.php”
  78. How do I change the post title’s link on the posts page?
  79. WordPress text field in array problem
  80. List Authors For Current Category
  81. Get query result according to merged array
  82. Embed image in post from external url
  83. cleaning out posts that don’t exist anymore but links are still there
  84. Custom URL Structure for posts with subcategories
  85. Possible to display X number of authors posts from another WordPress site?
  86. Theme Unit testing not importing on MAMP server – Fatal error: Maximum execution time of 60 seconds exceeded
  87. Post/Edit/Delete Post From Frontend… How?
  88. Use radio buttons & checkboxes for post categories
  89. List posts that are in the same category as the current post title
  90. Wanting to apply different featured images for each post
  91. Password-protected Posts lead to 404 Error
  92. Multiple blog “feeds” in a single blog each with distinctly styled post pages
  93. How to get pagination working with “Pending” Posts
  94. How do I show the post title if an advanced custom field hasn’t been used?
  95. Deleting first four characters from all Post Titles
  96. Post’s arent displaying
  97. Show with echo if a post has two or more categories
  98. Can I get custom post items in select box (dropdown)
  99. Sort Posts Alphabetically Based on Specific Category (Divi)
  100. Inserting Media on New Post But Hides Previous Uploads for Editor/Contributor
error code: 523