rayvoelker · December 27, 2024 16:13
diff --git a/2024_juv_audio_formats.md b/2024_juv_audio_formats.md
diff --git a/item_category_item_format_checkouts_2024.md b/item_category_item_format_checkouts_2024.md
diff --git a/popular_childrens_av_2024.ipynb b/popular_childrens_av_2024.ipynb
 {
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "eedc4ed6-8254-440a-bf17-3d3aafaed790",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "%%capture\n",
    "\n",
    "!pip install -U pandas \n",
    "!pip install -U duckdb\n",
    "\n",
    "# !pip install -U tqdm  # optional for displaying a progress bar\n",
    "\n",
    "# 1. There's a hidden config directory with the login for the config for \n",
    "# connecting to either the sierra test database, or the production db\n",
    "import json\n",
    "import duckdb\n",
    "import pandas as pd\n",
    "    \n",
    "parquet_data_dir = '/home/jovyan/data-team-share/data/circ-trans-parquet/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9534606e-62b0-414b-b62b-d80fdf1fb375",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<duckdb.duckdb.DuckDBPyConnection at 0x7d87c35c54f0>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a view from Parquet files\n",
    "con = duckdb.connect(':memory:')\n",
    "\n",
    "con.execute(f\"\"\"\\\n",
    "    CREATE VIEW IF NOT EXISTS circ_trans_view AS\n",
    "        SELECT *\n",
    "        FROM read_parquet('{parquet_data_dir}/**/*.parquet')\n",
    "    ;\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "38818b75-247c-4a2e-b397-16fb9bd640b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('circ_trans_id', 'INTEGER', 'YES', None, None, None),\n",
       " ('transaction_gmt', 'VARCHAR', 'YES', None, None, None),\n",
       " ('application_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('source_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('op_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_record_id', 'BIGINT', 'YES', None, None, None),\n",
       " ('patron_record_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('patron_ptype_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_ptype_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_home_library_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_home_library_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_campus_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_agency_code_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('patron_create_date', 'TIMESTAMP', 'YES', None, None, None),\n",
       " ('patron_expiration_date', 'TIMESTAMP', 'YES', None, None, None),\n",
       " ('patron_birth_date', 'TIMESTAMP', 'YES', None, None, None),\n",
       " ('patron_addr_zip', 'VARCHAR', 'YES', None, None, None),\n",
       " ('patron_record_addrs_json', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_record_id', 'DOUBLE', 'YES', None, None, None),\n",
       " ('item_record_num', 'DOUBLE', 'YES', None, None, None),\n",
       " ('item_call_number', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_barcode', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_create_date', 'TIMESTAMP', 'YES', None, None, None),\n",
       " ('item_campus_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_location_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_location_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_agency_code_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('item_type_code_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('item_agency_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_format', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_branch_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_physical_format_id', 'DOUBLE', 'YES', None, None, None),\n",
       " ('item_physical_format_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('item_target_audience_id', 'DOUBLE', 'YES', None, None, None),\n",
       " ('item_collection_id', 'DOUBLE', 'YES', None, None, None),\n",
       " ('volume_record_id', 'DOUBLE', 'YES', None, None, None),\n",
       " ('volume_record_num', 'DOUBLE', 'YES', None, None, None),\n",
       " ('volume_record_stmnt', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_record_id', 'BIGINT', 'YES', None, None, None),\n",
       " ('bib_record_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('bib_create_date', 'TIMESTAMP', 'YES', None, None, None),\n",
       " ('bib_cat_date', 'TIMESTAMP', 'YES', None, None, None),\n",
       " ('bib_campus_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_best_title', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_best_author', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_pub_year', 'DOUBLE', 'YES', None, None, None),\n",
       " ('bib_lang_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_country_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_level_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_material_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_control_nums_json', 'VARCHAR', 'YES', None, None, None),\n",
       " ('bib_genres', 'VARCHAR[]', 'YES', None, None, None),\n",
       " ('bib_subjects', 'VARCHAR[]', 'YES', None, None, None),\n",
       " ('stat_group_code_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('stat_group_location_code', 'VARCHAR', 'YES', None, None, None),\n",
       " ('stat_group_location_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('statistic_group_id', 'INTEGER', 'YES', None, None, None),\n",
       " ('stat_group_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('stat_group_branch_name', 'VARCHAR', 'YES', None, None, None),\n",
       " ('due_date_gmt', 'TIMESTAMP WITH TIME ZONE', 'YES', None, None, None),\n",
       " ('count_type_code_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('icode1', 'INTEGER', 'YES', None, None, None),\n",
       " ('icode2', 'VARCHAR', 'YES', None, None, None),\n",
       " ('pcode1', 'VARCHAR', 'YES', None, None, None),\n",
       " ('pcode2', 'VARCHAR', 'YES', None, None, None),\n",
       " ('pcode3', 'INTEGER', 'YES', None, None, None),\n",
       " ('pcode4', 'INTEGER', 'YES', None, None, None),\n",
       " ('loanrule_code_num', 'INTEGER', 'YES', None, None, None),\n",
       " ('transaction_date', 'DATE', 'YES', None, None, None)]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get the schema of the circ_trans parquet data ...\n",
    "con.execute(\"\"\"\n",
    "    DESCRIBE SELECT * FROM circ_trans_view;\n",
    "\"\"\").fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "65a4429d-03cf-4889-b313-dad3dd33c159",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('Audio Enabled Juvenile Book', 15604),\n",
       " ('Bike Locks', 906),\n",
       " ('Bluray', 5168),\n",
       " ('Book', 1276495),\n",
       " ('Book on CD', 37933),\n",
       " ('Book on Cassette', 2),\n",
       " ('Braille', 50),\n",
       " ('Charging Kit', 3594),\n",
       " ('Cleanup', 1),\n",
       " ('DVD/Videocassette', 580396),\n",
       " ('Government Document', 107),\n",
       " ('InterLibrary Loan Item', 8),\n",
       " ('Juvenile Book', 1884182),\n",
       " ('Juvenile Book on CD', 6731),\n",
       " ('Juvenile Book on Cassette', 4),\n",
       " ('Juvenile Kit', 222),\n",
       " ('Juvenile Large Print Book', 3722),\n",
       " ('Juvenile Magazine', 5122),\n",
       " ('Juvenile Music Score', 69),\n",
       " ('Juvenile Music on CD', 3351),\n",
       " ('Juvenile Playaway', 5305),\n",
       " ('Kit', 41),\n",
       " ('LP Record', 3147),\n",
       " ('Laptop', 24157),\n",
       " ('Large Print Book', 159387),\n",
       " ('Leased Book', 31727),\n",
       " ('Leased DVD', 8935),\n",
       " ('Magazine', 115034),\n",
       " ('MakerSpace Equipment', 1060),\n",
       " ('Map', 192),\n",
       " ('Music Score', 3283),\n",
       " ('Music on CD', 166755),\n",
       " ('Music on Cassette', 1),\n",
       " ('New Release DVDs', 171207),\n",
       " ('OHPIR Requestable', 20838),\n",
       " ('OHPIR Requestable Movie', 13234),\n",
       " ('OhioLINK Book', 6701),\n",
       " ('OhioLINK Circulating Periodical', 11),\n",
       " ('OhioLINK Media', 1144),\n",
       " ('OhioLINK Microforms', 2),\n",
       " ('OhioLINK Non-Circ', 8),\n",
       " ('OhioLINK Periodical', 4),\n",
       " ('OhioLINK Sound Record', 48),\n",
       " ('Playaway', 5776),\n",
       " ('Playaway View', 98),\n",
       " ('Portable Technology Device', 647),\n",
       " ('Rare Book', 125),\n",
       " ('Reference Book', 1569),\n",
       " ('Reference Book on CD', 5),\n",
       " ('Reference CD-ROM', 2),\n",
       " ('Reference Graphic', 2),\n",
       " ('Reference Juvenile Book', 295),\n",
       " ('Reference Juvenile Magazine', 1),\n",
       " ('Reference LP Record', 4),\n",
       " ('Reference Large Print Book', 1),\n",
       " ('Reference Magazine', 62),\n",
       " ('Reference Music Score', 1),\n",
       " ('Reference Music on CD', 4),\n",
       " ('Reference Playaway View', 1),\n",
       " ('Reference Poster/Print', 2),\n",
       " ('Reference Video', 13),\n",
       " ('Teen Book', 175873),\n",
       " ('Teen Book on CD', 565),\n",
       " ('Teen Large Print Book', 1120),\n",
       " ('Teen Magazine', 817),\n",
       " ('Teen Playaway', 228),\n",
       " ('Telescope', 262),\n",
       " ('iPad', 226)]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sql = \"\"\"\\\n",
    "SELECT\n",
    "    item_format,\n",
    "    count(*)\n",
    "FROM circ_trans_view\n",
    "WHERE \n",
    "    transaction_date::DATE >= '2024-01-01'::DATE\n",
    "    and op_code = 'o'\n",
    "GROUP BY\n",
    "    1\n",
    "ORDER BY\n",
    "    1\n",
    ";\n",
    "\"\"\"\n",
    "\n",
    "# get the numbers of checkouts by stat groups\n",
    "con.execute(sql).fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a189f579-f63c-4cc5-b48d-a60dcf582008",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "|    | item_format                 |   format_rank | combined_title_author                                                                                                                                                                                                       | resource_link                                                      |   total_checkouts |\n",
      "|---:|:----------------------------|--------------:|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------------------------------------------------------------|------------------:|\n",
      "|  0 | Audio Enabled Juvenile Book |             1 | Pete the cat and his magic sunglasses / Dean, James, 1957- author.                                                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722018 |               133 |\n",
      "|  1 | Audio Enabled Juvenile Book |             2 | Pete the Cat : the Petes go marching / Dean, James, 1957- author, illustrator.                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722022 |               131 |\n",
      "|  2 | Audio Enabled Juvenile Book |             3 | Creepy crayon! / Reynolds, Aaron, 1970- author.                                                                                                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3771320 |               130 |\n",
      "|  3 | Audio Enabled Juvenile Book |             4 | Pete the Cat's groovy imagination / Dean, Kim, 1969- author, illustrator.                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3721818 |               122 |\n",
      "|  4 | Audio Enabled Juvenile Book |             5 | Pete the cat : crayons rock! / Dean, James, 1957- author, illustrator.                                                                                                                                                      | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722021 |               121 |\n",
      "|  5 | Audio Enabled Juvenile Book |             6 | Pete the Cat and the itsy bitsy spider / Dean, James, 1957- author.                                                                                                                                                         | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722019 |               118 |\n",
      "|  6 | Audio Enabled Juvenile Book |             7 | Pete the Kitty and the groovy playdate / Dean, Kim, 1969- author, illustrator.                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722023 |               116 |\n",
      "|  7 | Audio Enabled Juvenile Book |             8 | Pete the cat. Pete the cat plays hide-and-seek / Dean, Kim, 1969- author.                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3771319 |               115 |\n",
      "|  8 | Audio Enabled Juvenile Book |             9 | The Big Cheese / John, Jory, author.                                                                                                                                                                                        | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3844320 |               103 |\n",
      "|  9 | Audio Enabled Juvenile Book |            10 | Click, clack, moo : cows that type / Cronin, Doreen, author.                                                                                                                                                                | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3721933 |               103 |\n",
      "| 10 | Audio Enabled Juvenile Book |            11 | That's what dinosaurs do / John, Jory, author.                                                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3741235 |               101 |\n",
      "| 11 | Audio Enabled Juvenile Book |            12 | We love bubbles! / Madan, Vikram, author.                                                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3771318 |                90 |\n",
      "| 12 | Audio Enabled Juvenile Book |            13 | The digger and the flower / Kuefler, Joseph, author, illustrator.                                                                                                                                                           | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3844306 |                87 |\n",
      "| 13 | Audio Enabled Juvenile Book |            14 | The sour grape / John, Jory, author.                                                                                                                                                                                        | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3802288 |                86 |\n",
      "| 14 | Audio Enabled Juvenile Book |            15 | The bad seed / John, Jory, author.                                                                                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722029 |                84 |\n",
      "| 15 | Audio Enabled Juvenile Book |            16 | The good egg / John, Jory, author.                                                                                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722032 |                84 |\n",
      "| 16 | Audio Enabled Juvenile Book |            17 | The digger and the butterfly / Kuefler, Joseph, author, illustrator.                                                                                                                                                        | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3844323 |                84 |\n",
      "| 17 | Audio Enabled Juvenile Book |            18 | It came in the mail / Clanton, Ben, 1988- author.                                                                                                                                                                           | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3802258 |                84 |\n",
      "| 18 | Audio Enabled Juvenile Book |            19 | Pete the cat and the perfect pizza party / Dean, Kim, 1969- author.                                                                                                                                                         | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722020 |                83 |\n",
      "| 19 | Audio Enabled Juvenile Book |            20 | Corduroy lost and found / Freeman, Don, 1908-1978, author, illustrator.                                                                                                                                                     | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3818293 |                81 |\n",
      "| 20 | Juvenile Book on CD         |             1 | Harry Potter and the sorcerer's stone [sound recording] / Rowling, J. K.                                                                                                                                                    | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1818997 |                54 |\n",
      "| 21 | Juvenile Book on CD         |             2 | Harry Potter and the prisoner of Azkaban [sound recording] / Rowling, J. K.                                                                                                                                                 | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1803340 |                41 |\n",
      "| 22 | Juvenile Book on CD         |             3 | Harry Potter and the chamber of secrets [sound recording] / Rowling, J. K.                                                                                                                                                  | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1818334 |                40 |\n",
      "| 23 | Juvenile Book on CD         |             4 | Charlie and the chocolate factory [sound recording] / Dahl, Roald.                                                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2878966 |                35 |\n",
      "| 24 | Juvenile Book on CD         |             5 | Countdown to Christmas [sound recording] : advent collection                                                                                                                                                                | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3710738 |                34 |\n",
      "| 25 | Juvenile Book on CD         |             6 | Harry Potter and the deathly hallows [sound recording] / Rowling, J. K.                                                                                                                                                     | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2723390 |                32 |\n",
      "| 26 | Juvenile Book on CD         |             7 | Harry Potter and the goblet of fire [sound recording] / Rowling, J. K.                                                                                                                                                      | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1928925 |                31 |\n",
      "| 27 | Juvenile Book on CD         |             8 | The wild robot [sound recording] / Brown, Peter, 1979-                                                                                                                                                                      | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3162540 |                29 |\n",
      "| 28 | Juvenile Book on CD         |             9 | Matilda [sound recording] / Dahl, Roald.                                                                                                                                                                                    | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2878970 |                27 |\n",
      "| 29 | Juvenile Book on CD         |            10 | The story of the world : history for the classical child. Volume 1, Ancient times, from the earliest Nomads to the last Roman emperor / Bauer, Susan Wise, author.                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2602944 |                25 |\n",
      "| 30 | Juvenile Book on CD         |            11 | Big Nate in the zone / Peirce, Lincoln, author.                                                                                                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2930207 |                23 |\n",
      "| 31 | Juvenile Book on CD         |            12 | Hurry up, Houdini! [sound recording] / Osborne, Mary Pope.                                                                                                                                                                  | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890203 |                23 |\n",
      "| 32 | Juvenile Book on CD         |            13 | Frog and toad audio collection [CD Audiobook] / Lobel, Arnold.                                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2925640 |                23 |\n",
      "| 33 | Juvenile Book on CD         |            14 | The lion, the witch, and the wardrobe [sound recording] / Lewis, C. S. (Clive Staples), 1898-1963.                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2735715 |                23 |\n",
      "| 34 | Juvenile Book on CD         |            15 | Henry and Beezus [sound recording] / Cleary, Beverly.                                                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2617209 |                22 |\n",
      "| 35 | Juvenile Book on CD         |            16 | Soccer on Sunday [sound recording] / Osborne, Mary Pope.                                                                                                                                                                    | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2947670 |                22 |\n",
      "| 36 | Juvenile Book on CD         |            17 | How to train your dragon [sound recording] / Cowell, Cressida.                                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890259 |                22 |\n",
      "| 37 | Juvenile Book on CD         |            18 | The cat in the hat and other Dr. Seuss favorites [sound recording]. / Seuss, Dr.                                                                                                                                            | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2726359 |                22 |\n",
      "| 38 | Juvenile Book on CD         |            19 | A perfect time for pandas [sound recording] / Osborne, Mary Pope.                                                                                                                                                           | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2686434 |                22 |\n",
      "| 39 | Juvenile Book on CD         |            20 | Magic tree house [sound recording]. Books 29-32 / Osborne, Mary Pope.                                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2779921 |                22 |\n",
      "| 40 | Juvenile Book on Cassette   |             1 | The Polar Express [sound recording] / Van Allsburg, Chris.                                                                                                                                                                  | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1965729 |                 4 |\n",
      "| 41 | Juvenile Music on CD        |             1 | Disney classics [sound recording].                                                                                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2913408 |                76 |\n",
      "| 42 | Juvenile Music on CD        |             2 | Bluey : the album / Bush, Joff, composer, producer, performer.                                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3848318 |                70 |\n",
      "| 43 | Juvenile Music on CD        |             3 | Bluey : dance mode! / Bush, Joff, composer, producer, performer.                                                                                                                                                            | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3850582 |                45 |\n",
      "| 44 | Juvenile Music on CD        |             4 | The little mermaid greatest hits [sound recording]                                                                                                                                                                          | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2913401 |                36 |\n",
      "| 45 | Juvenile Music on CD        |             5 | Kidz Bop 2022 / Kidz Bop Kids, performer.                                                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3686036 |                33 |\n",
      "| 46 | Juvenile Music on CD        |             6 | Kidz bop.                                                                                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2668506 |                31 |\n",
      "| 47 | Juvenile Music on CD        |             7 | Kidz bop ultimate playlist / Kidz Bop Kids, performer.                                                                                                                                                                      | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3733508 |                27 |\n",
      "| 48 | Juvenile Music on CD        |             8 | Kidz Bop 2024 / Kidz Bop Kids, performer.                                                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3848361 |                24 |\n",
      "| 49 | Juvenile Music on CD        |             9 | Disney princess : the ultimate song collection.                                                                                                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3850583 |                22 |\n",
      "| 50 | Juvenile Music on CD        |            10 | Now that's what I call Disney. 2.                                                                                                                                                                                           | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2913407 |                21 |\n",
      "| 51 | Juvenile Music on CD        |            11 | The ultimate Laurie Berkner Band Collection [sound recording]. / Laurie Berkner Band.                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2994428 |                20 |\n",
      "| 52 | Juvenile Music on CD        |            12 | Kidz Bop 2021 / Kidz Bop Kids, performer.                                                                                                                                                                                   | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3564196 |                20 |\n",
      "| 53 | Juvenile Music on CD        |            14 | Kidz Bop 2023. Vol. 2 / Kidz Bop Kids, performer.                                                                                                                                                                           | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3848360 |                19 |\n",
      "| 54 | Juvenile Music on CD        |            13 | Kidz bop. All-time greatest hits / Kidz Bop Kids, performer.                                                                                                                                                                | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3607194 |                19 |\n",
      "| 55 | Juvenile Music on CD        |            15 | Kidz Bop. 39                                                                                                                                                                                                                | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3499190 |                18 |\n",
      "| 56 | Juvenile Music on CD        |            19 | Kidz bop. Halloween hits! [sound recording]. / Kidz Bop Kids.                                                                                                                                                               | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2795390 |                17 |\n",
      "| 57 | Juvenile Music on CD        |            18 | The best of the Laurie Berkner Band [sound recording]. / Laurie Berkner Band.                                                                                                                                               | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2574031 |                17 |\n",
      "| 58 | Juvenile Music on CD        |            17 | Sesame Street. All-time favorites. 2.                                                                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3499195 |                17 |\n",
      "| 59 | Juvenile Music on CD        |            16 | Kidz Bop. Party playlist! / Kidz Bop Kids, performer.                                                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3564197 |                17 |\n",
      "| 60 | Juvenile Music on CD        |            20 | Frozen.                                                                                                                                                                                                                     | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2972260 |                16 |\n",
      "| 61 | Juvenile Playaway           |             1 | Charlotte's web [electronic resource] / White, E. B. (Elwyn Brooks), 1899-1985.                                                                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773484 |                41 |\n",
      "| 62 | Juvenile Playaway           |             2 | Harry Potter and the sorcerer's stone / Rowling, J. K., author.                                                                                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3565347 |                39 |\n",
      "| 63 | Juvenile Playaway           |             3 | Frog and Toad audio collection [electronic resource] / Lobel, Arnold.                                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2559301 |                38 |\n",
      "| 64 | Juvenile Playaway           |             4 | Nate the Great collected stories. Volume 1 [electronic resource] / Sharmat, Marjorie Weinman.                                                                                                                               | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2770352 |                35 |\n",
      "| 65 | Juvenile Playaway           |             6 | Captain Underpants and the big, bad battle of the Bionic Booger Boy. Part 2, The revenge of the ridiculous Robo-Boogers / Pilkey, Dav, 1966- author.                                                                        | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776001 |                34 |\n",
      "| 66 | Juvenile Playaway           |             5 | Alice's adventures in Wonderland [electronic resource] / Carroll, Lewis, 1832-1898.                                                                                                                                         | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2560066 |                34 |\n",
      "| 67 | Juvenile Playaway           |             7 | Captain Underpants and the revolting revenge of the radioactive robo-boxers : the tenth epic novel / Pilkey, Dav, 1966- author.                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776005 |                32 |\n",
      "| 68 | Juvenile Playaway           |             9 | Captain Underpants and the big, bad battle of the Bionic Booger Boy. Part 1. The night of the nasty nostril nuggets / Pilkey, Dav, 1966- author.                                                                            | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776000 |                31 |\n",
      "| 69 | Juvenile Playaway           |             8 | Harry the dirty dog and other animal stories [electronic resource] / Zion, Gene.                                                                                                                                            | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014379 |                31 |\n",
      "| 70 | Juvenile Playaway           |            11 | The Gooney Bird collection [electronic resource] / Lowry, Lois.                                                                                                                                                             | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014376 |                30 |\n",
      "| 71 | Juvenile Playaway           |            13 | Captain Underpants and the perilous plot of Professor Poopypants / Pilkey, Dav, 1966- author.                                                                                                                               | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776003 |                30 |\n",
      "| 72 | Juvenile Playaway           |            12 | The mystery in the computer game [electronic resource] / Warner, Gertrude Chandler, 1890-1979.                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2634685 |                30 |\n",
      "| 73 | Juvenile Playaway           |            10 | Don't let the pigeon drive the bus! [electronic resource] : and more stories / Willems, Mo.                                                                                                                                 | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014370 |                30 |\n",
      "| 74 | Juvenile Playaway           |            14 | I survived the Joplin tornado, 2011 / Tarshis, Lauren, author.                                                                                                                                                              | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3589484 |                29 |\n",
      "| 75 | Juvenile Playaway           |            18 | Harry Potter and the chamber of secrets / Rowling, J. K., author.                                                                                                                                                           | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3565341 |                28 |\n",
      "| 76 | Juvenile Playaway           |            17 | Stuart Little [electronic resource] / White, E. B. (Elwyn Brooks), 1899-1985.                                                                                                                                               | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773622 |                28 |\n",
      "| 77 | Juvenile Playaway           |            16 | Pinkalicious audio collection [electronic resource] / Kann, Victoria.                                                                                                                                                       | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014669 |                28 |\n",
      "| 78 | Juvenile Playaway           |            15 | Captain Underpants and the attack of the talking toilets : the second epic novel / Pilkey, Dav, 1966- author.                                                                                                               | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3775999 |                28 |\n",
      "| 79 | Juvenile Playaway           |            20 | I survived the Wellington avalanche, 1910 / Tarshis, Lauren, author.                                                                                                                                                        | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776076 |                26 |\n",
      "| 80 | Juvenile Playaway           |            19 | Captain underpants and the invasion of the incredibly naughty cafeteria ladies from outer space (and the subsequent assault of the equally evil lunchroom zombie nerds) : the third epic novel / Pilkey, Dav, 1966- author. | https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776002 |                26 |\n"
     ]
    }
   ],
   "source": [
    "sql = \"\"\"\\\n",
    "WITH ranked_checkouts AS (\n",
    "    SELECT\n",
    "        item_format,\n",
    "        bib_best_author,\n",
    "        bib_best_title,\n",
    "        bib_record_num,\n",
    "        COUNT(*) AS total_checkouts,\n",
    "        ROW_NUMBER() OVER (\n",
    "            PARTITION BY item_format\n",
    "            ORDER BY COUNT(*) DESC\n",
    "        ) AS rn\n",
    "    FROM circ_trans_view\n",
    "    WHERE \n",
    "        transaction_date::DATE >= '2024-01-01'::DATE\n",
    "        AND op_code = 'o'\n",
    "        AND item_format IN (\n",
    "            'Audio Enabled Juvenile Book',\n",
    "            'Juvenile Book on CD',\n",
    "            'Juvenile Book on Cassette',\n",
    "            'Juvenile Music on CD',\n",
    "            'Juvenile Playaway'\n",
    "        )\n",
    "    GROUP BY 1,2,3,4\n",
    ")\n",
    "SELECT\n",
    "    item_format,\n",
    "    rn AS format_rank,\n",
    "    CASE \n",
    "       WHEN bib_best_author IS NOT NULL AND bib_best_author <> '' \n",
    "       THEN bib_best_title || ' / ' || bib_best_author\n",
    "       ELSE bib_best_title\n",
    "    END AS combined_title_author,\n",
    "    'https://cincinnatilibrary.bibliocommons.com/v2/record/S170C' || bib_record_num AS resource_link,\n",
    "    total_checkouts\n",
    "FROM ranked_checkouts\n",
    "WHERE rn <= 20\n",
    "ORDER BY item_format, total_checkouts DESC;\n",
    "\n",
    "\"\"\"\n",
    "\n",
    "# get the numbers of checkouts by stat groups\n",
    "df = con.execute(sql).fetchdf()\n",
    "print(\n",
    "    df.to_markdown()\n",
    ")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
 }
	item_format	format_rank	combined_title_author	resource_link	total_checkouts
0	Audio Enabled Juvenile Book	1	Pete the cat and his magic sunglasses / Dean, James, 1957- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722018	133
1	Audio Enabled Juvenile Book	2	Pete the Cat : the Petes go marching / Dean, James, 1957- author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722022	131
2	Audio Enabled Juvenile Book	3	Creepy crayon! / Reynolds, Aaron, 1970- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3771320	130
3	Audio Enabled Juvenile Book	4	Pete the Cat's groovy imagination / Dean, Kim, 1969- author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3721818	122
4	Audio Enabled Juvenile Book	5	Pete the cat : crayons rock! / Dean, James, 1957- author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722021	121
5	Audio Enabled Juvenile Book	6	Pete the Cat and the itsy bitsy spider / Dean, James, 1957- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722019	118
6	Audio Enabled Juvenile Book	7	Pete the Kitty and the groovy playdate / Dean, Kim, 1969- author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722023	116
7	Audio Enabled Juvenile Book	8	Pete the cat. Pete the cat plays hide-and-seek / Dean, Kim, 1969- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3771319	115
8	Audio Enabled Juvenile Book	9	The Big Cheese / John, Jory, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3844320	103
9	Audio Enabled Juvenile Book	10	Click, clack, moo : cows that type / Cronin, Doreen, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3721933	103
10	Audio Enabled Juvenile Book	11	That's what dinosaurs do / John, Jory, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3741235	101
11	Audio Enabled Juvenile Book	12	We love bubbles! / Madan, Vikram, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3771318	90
12	Audio Enabled Juvenile Book	13	The digger and the flower / Kuefler, Joseph, author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3844306	87
13	Audio Enabled Juvenile Book	14	The sour grape / John, Jory, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3802288	86
14	Audio Enabled Juvenile Book	15	The bad seed / John, Jory, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722029	84
15	Audio Enabled Juvenile Book	16	The good egg / John, Jory, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722032	84
16	Audio Enabled Juvenile Book	17	The digger and the butterfly / Kuefler, Joseph, author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3844323	84
17	Audio Enabled Juvenile Book	18	It came in the mail / Clanton, Ben, 1988- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3802258	84
18	Audio Enabled Juvenile Book	19	Pete the cat and the perfect pizza party / Dean, Kim, 1969- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3722020	83
19	Audio Enabled Juvenile Book	20	Corduroy lost and found / Freeman, Don, 1908-1978, author, illustrator.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3818293	81
20	Juvenile Book on CD	1	Harry Potter and the sorcerer's stone [sound recording] / Rowling, J. K.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1818997	54
21	Juvenile Book on CD	2	Harry Potter and the prisoner of Azkaban [sound recording] / Rowling, J. K.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1803340	41
22	Juvenile Book on CD	3	Harry Potter and the chamber of secrets [sound recording] / Rowling, J. K.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1818334	40
23	Juvenile Book on CD	4	Charlie and the chocolate factory [sound recording] / Dahl, Roald.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2878966	35
24	Juvenile Book on CD	5	Countdown to Christmas [sound recording] : advent collection	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3710738	34
25	Juvenile Book on CD	6	Harry Potter and the deathly hallows [sound recording] / Rowling, J. K.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2723390	32
26	Juvenile Book on CD	7	Harry Potter and the goblet of fire [sound recording] / Rowling, J. K.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1928925	31
27	Juvenile Book on CD	8	The wild robot [sound recording] / Brown, Peter, 1979-	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3162540	29
28	Juvenile Book on CD	9	Matilda [sound recording] / Dahl, Roald.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2878970	27
29	Juvenile Book on CD	10	The story of the world : history for the classical child. Volume 1, Ancient times, from the earliest Nomads to the last Roman emperor / Bauer, Susan Wise, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2602944	25
30	Juvenile Book on CD	11	Big Nate in the zone / Peirce, Lincoln, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2930207	23
31	Juvenile Book on CD	12	Hurry up, Houdini! [sound recording] / Osborne, Mary Pope.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890203	23
32	Juvenile Book on CD	13	Frog and toad audio collection [CD Audiobook] / Lobel, Arnold.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2925640	23
33	Juvenile Book on CD	14	The lion, the witch, and the wardrobe [sound recording] / Lewis, C. S. (Clive Staples), 1898-1963.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2735715	23
34	Juvenile Book on CD	15	Henry and Beezus [sound recording] / Cleary, Beverly.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2617209	22
35	Juvenile Book on CD	16	Soccer on Sunday [sound recording] / Osborne, Mary Pope.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2947670	22
36	Juvenile Book on CD	17	How to train your dragon [sound recording] / Cowell, Cressida.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2890259	22
37	Juvenile Book on CD	18	The cat in the hat and other Dr. Seuss favorites [sound recording]. / Seuss, Dr.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2726359	22
38	Juvenile Book on CD	19	A perfect time for pandas [sound recording] / Osborne, Mary Pope.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2686434	22
39	Juvenile Book on CD	20	Magic tree house [sound recording]. Books 29-32 / Osborne, Mary Pope.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2779921	22
40	Juvenile Book on Cassette	1	The Polar Express [sound recording] / Van Allsburg, Chris.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C1965729	4
41	Juvenile Music on CD	1	Disney classics [sound recording].	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2913408	76
42	Juvenile Music on CD	2	Bluey : the album / Bush, Joff, composer, producer, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3848318	70
43	Juvenile Music on CD	3	Bluey : dance mode! / Bush, Joff, composer, producer, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3850582	45
44	Juvenile Music on CD	4	The little mermaid greatest hits [sound recording]	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2913401	36
45	Juvenile Music on CD	5	Kidz Bop 2022 / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3686036	33
46	Juvenile Music on CD	6	Kidz bop.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2668506	31
47	Juvenile Music on CD	7	Kidz bop ultimate playlist / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3733508	27
48	Juvenile Music on CD	8	Kidz Bop 2024 / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3848361	24
49	Juvenile Music on CD	9	Disney princess : the ultimate song collection.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3850583	22
50	Juvenile Music on CD	10	Now that's what I call Disney. 2.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2913407	21
51	Juvenile Music on CD	11	The ultimate Laurie Berkner Band Collection [sound recording]. / Laurie Berkner Band.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2994428	20
52	Juvenile Music on CD	12	Kidz Bop 2021 / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3564196	20
53	Juvenile Music on CD	14	Kidz Bop 2023. Vol. 2 / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3848360	19
54	Juvenile Music on CD	13	Kidz bop. All-time greatest hits / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3607194	19
55	Juvenile Music on CD	15	Kidz Bop. 39	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3499190	18
56	Juvenile Music on CD	19	Kidz bop. Halloween hits! [sound recording]. / Kidz Bop Kids.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2795390	17
57	Juvenile Music on CD	18	The best of the Laurie Berkner Band [sound recording]. / Laurie Berkner Band.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2574031	17
58	Juvenile Music on CD	17	Sesame Street. All-time favorites. 2.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3499195	17
59	Juvenile Music on CD	16	Kidz Bop. Party playlist! / Kidz Bop Kids, performer.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3564197	17
60	Juvenile Music on CD	20	Frozen.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2972260	16
61	Juvenile Playaway	1	Charlotte's web [electronic resource] / White, E. B. (Elwyn Brooks), 1899-1985.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773484	41
62	Juvenile Playaway	2	Harry Potter and the sorcerer's stone / Rowling, J. K., author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3565347	39
63	Juvenile Playaway	3	Frog and Toad audio collection [electronic resource] / Lobel, Arnold.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2559301	38
64	Juvenile Playaway	4	Nate the Great collected stories. Volume 1 [electronic resource] / Sharmat, Marjorie Weinman.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2770352	35
65	Juvenile Playaway	6	Captain Underpants and the big, bad battle of the Bionic Booger Boy. Part 2, The revenge of the ridiculous Robo-Boogers / Pilkey, Dav, 1966- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776001	34
66	Juvenile Playaway	5	Alice's adventures in Wonderland [electronic resource] / Carroll, Lewis, 1832-1898.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2560066	34
67	Juvenile Playaway	7	Captain Underpants and the revolting revenge of the radioactive robo-boxers : the tenth epic novel / Pilkey, Dav, 1966- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776005	32
68	Juvenile Playaway	9	Captain Underpants and the big, bad battle of the Bionic Booger Boy. Part 1. The night of the nasty nostril nuggets / Pilkey, Dav, 1966- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776000	31
69	Juvenile Playaway	8	Harry the dirty dog and other animal stories [electronic resource] / Zion, Gene.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014379	31
70	Juvenile Playaway	11	The Gooney Bird collection [electronic resource] / Lowry, Lois.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014376	30
71	Juvenile Playaway	13	Captain Underpants and the perilous plot of Professor Poopypants / Pilkey, Dav, 1966- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776003	30
72	Juvenile Playaway	12	The mystery in the computer game [electronic resource] / Warner, Gertrude Chandler, 1890-1979.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2634685	30
73	Juvenile Playaway	10	Don't let the pigeon drive the bus! [electronic resource] : and more stories / Willems, Mo.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014370	30
74	Juvenile Playaway	14	I survived the Joplin tornado, 2011 / Tarshis, Lauren, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3589484	29
75	Juvenile Playaway	18	Harry Potter and the chamber of secrets / Rowling, J. K., author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3565341	28
76	Juvenile Playaway	17	Stuart Little [electronic resource] / White, E. B. (Elwyn Brooks), 1899-1985.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C2773622	28
77	Juvenile Playaway	16	Pinkalicious audio collection [electronic resource] / Kann, Victoria.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3014669	28
78	Juvenile Playaway	15	Captain Underpants and the attack of the talking toilets : the second epic novel / Pilkey, Dav, 1966- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3775999	28
79	Juvenile Playaway	20	I survived the Wellington avalanche, 1910 / Tarshis, Lauren, author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776076	26
80	Juvenile Playaway	19	Captain underpants and the invasion of the incredibly naughty cafeteria ladies from outer space (and the subsequent assault of the equally evil lunchroom zombie nerds) : the third epic novel / Pilkey, Dav, 1966- author.	https://cincinnatilibrary.bibliocommons.com/v2/record/S170C3776002	26
No results found