{"entities":{"Q6677421":{"pageid":14396737,"ns":120,"title":"Item:Q6677421","lastrevid":54755651,"modified":"2026-01-29T20:33:36Z","type":"item","id":"Q6677421","labels":{"en":{"language":"en","value":"Brisbane Library Checkout Data"}},"descriptions":{"en":{"language":"en","value":"Dataset published at Zenodo repository."}},"aliases":{},"claims":{"P31":[{"mainsnak":{"snaktype":"value","property":"P31","hash":"dae155fd0809a7906855cd4fa50dd7d71bed552b","datavalue":{"value":{"entity-type":"item","numeric-id":56885,"id":"Q56885"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q6677421$72D5E567-D794-4119-9A01-F2F6CDF5CB9A","rank":"normal"}],"P1459":[{"mainsnak":{"snaktype":"value","property":"P1459","hash":"be95ca6f784015bdfdbd0104fe602b5f7406e1f9","datavalue":{"value":"This has been copied from the README.md file  bris-lib-checkout  This provides tidied up data from the Brisbane library checkouts  Retrieving and cleaning the data  The script for retrieving and cleaning the data is made available in scrape-library.R.  The data    The data/ folder contains the tidy data  The data-raw/ folder contains the raw data   data/  This contains four tidied up dataframes:    tidy-brisbane-library-checkout.csv  metadata_branch.csv  metadata_heading.csv  metadata_item_type.csv   tidy-brisbane-library-checkout.csv contains the following columns, with the metadata file metadata_heading containing the description of these columns.  knitr::kable(readr::read_csv(data/metadata_heading.csv)) # Parsed with column specification: # cols( # heading = col_character(), # heading_explanation = col_character() # )  heading  heading_explanation  Title  Title of Item  Author  Author of Item  Call Number  Call Number of Item  Item id  Unique Item Identifier  Item Type  Type of Item (see next column)  Status  Current Status of Item  Language  Published language of item (if not English)  Age  Suggested audience  Checkout Library  Checkout branch  Date  Checkout date  We also added year, month, and day columns.  The remaining data are all metadata files that contain meta information on the columns in the checkout data:  library(tidyverse) # \u2500\u2500 Attaching packages \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500 tidyverse 1.2.1 \u2500\u2500 # \u2714 ggplot2 3.1.0 \u2714 purrr 0.2.5 # \u2714 tibble 1.4.99.9006 \u2714 dplyr 0.7.8 # \u2714 tidyr 0.8.2 \u2714 stringr 1.3.1 # \u2714 readr 1.3.0 \u2714 forcats 0.3.0 # \u2500\u2500 Conflicts \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500 tidyverse_conflicts() \u2500\u2500 # \u2716 dplyr::filter() masks stats::filter() # \u2716 dplyr::lag() masks stats::lag() knitr::kable(readr::read_csv(data/metadata_branch.csv)) # Parsed with column specification: # cols( # branch_code = col_character(), # branch_heading = col_character() # )  branch_code  branch_heading  ANN  Annerley  ASH  Ashgrove  BNO  Banyo  BRR  BrackenRidge  BSQ  Brisbane Square Library  BUL  Bulimba  CDA  Corinda  CDE  Chermside  CNL  Carindale  CPL  Coopers Plains  CRA  Carina  EPK  Everton Park  FAI  Fairfield  GCY  Garden City  GNG  Grange  HAM  Hamilton  HPK  Holland Park  INA  Inala  IPY  Indooroopilly  MBG  Mt. Coot-tha  MIT  Mitchelton  MTG  Mt. Gravatt  MTO  Mt. Ommaney  NDH  Nundah  NFM  New Farm  SBK  Sunnybank Hills  SCR  Stones Corner  SGT  Sandgate  VAN  Mobile Library  TWG  Toowong  WND  West End  WYN  Wynnum  ZIL  Zillmere  knitr::kable(readr::read_csv(data/metadata_item_type.csv)) # Parsed with column specification: # cols( # item_type_code = col_character(), # item_type_explanation = col_character() # )  item_type_code  item_type_explanation  AD-FICTION  Adult Fiction  AD-MAGS  Adult Magazines  AD-PBK  Adult Paperback  BIOGRAPHY  Biography  BSQCDMUSIC  Brisbane Square CD Music  BSQCD-ROM  Brisbane Square CD Rom  BSQ-DVD  Brisbane Square DVD  CD-BOOK  Compact Disc Book  CD-MUSIC  Compact Disc Music  CD-ROM  CD Rom  DVD  DVD  DVD_R18+  DVD Restricted - 18+  FASTBACK  Fastback  GAYLESBIAN  Gay and Lesbian Collection  GRAPHICNOV  Graphic Novel  ILL  InterLibrary Loan  JU-FICTION  Junior Fiction  JU-MAGS  Junior Magazines  JU-PBK  Junior Paperback  KITS  Kits  LARGEPRINT  Large Print  LGPRINTMAG  Large Print Magazine  LITERACY  Literacy  LITERACYAV  Literacy Audio Visual  LOCSTUDIES  Local Studies  LOTE-BIO  Languages Other than English Biography  LOTE-BOOK  Languages Other than English Book  LOTE-CDMUS  Languages Other than English CD Music  LOTE-DVD  Languages Other than English DVD  LOTE-MAG  Languages Other than English Magazine  LOTE-TB  Languages Other than English Taped Book  MBG-DVD  Mt Coot-tha Botanical Gardens DVD  MBG-MAG  Mt Coot-tha Botanical Gardens Magazine  MBG-NF  Mt Coot-tha Botanical Gardens Non Fiction  MP3-BOOK  MP3 Audio Book  NONFIC-SET  Non Fiction Set  NONFICTION  Non Fiction  PICTURE-BK  Picture Book  PICTURE-NF  Picture Book Non Fiction  PLD-BOOK  Public Libraries Division Book  YA-FICTION  Young Adult Fiction  YA-MAGS  Young Adult Magazine  YA-PBK  Young Adult Paperback  Example usage  Lets explore the data  bris_libs - readr::read_csv(data/bris-lib-checkout.csv) # Parsed with column specification: # cols( # title = col_character(), # author = col_character(), # call_number = col_character(), # item_id = col_double(), # item_type = col_character(), # status = col_character(), # language = col_character(), # age = col_character(), # library = col_character(), # date = col_double(), # datetime = col_datetime(format = ), # year = col_double(), # month = col_double(), # day = col_character() # ) # Warning: 20 parsing failures. # row col expected actual file # 587795 item_id a double REFRESH data/bris-lib-checkout.csv # 590579 item_id a double REFRESH data/bris-lib-checkout.csv # 590597 item_id a double REFRESH data/bris-lib-checkout.csv # 595774 item_id a double REFRESH data/bris-lib-checkout.csv # 597567 item_id a double REFRESH data/bris-lib-checkout.csv # ...... ....... ........ ....... ............................ # See problems(...) for more details.  We can count the number of titles, item types, suggested age, and the library given:  library(dplyr) count(bris_libs, title, sort = TRUE) # # A tibble: 121,046 x 2 # title n # chr int # 1 Australian house and garden 1469 # 2 New scientist (Australasian ed.) 1380 # 3 Australian home beautiful 1331 # 4 Country style 1229 # 5 The New idea 1186 # 6 Hello 1133 # 7 Womans day 1096 # 8 Country life 1056 # 9 Better homes and gardens. (AU) 1041 # 10 Yi Zhou Kan 884 # #  with 121,036 more rows count(bris_libs, item_type, sort = TRUE) # # A tibble: 69 x 2 # item_type n # chr int # 1 PICTURE-BK 121126 # 2 DVD 98283 # 3 AD-PBK 91671 # 4 JU-PBK 88402 # 5 NONFICTION 76168 # 6 AD-MAGS 60516 # 7 AD-FICTION 53090 # 8 LARGEPRINT 19113 # 9 JU-FICTION 17261 # 10 LOTE-BOOK 12303 # #  with 59 more rows count(bris_libs, age, sort = TRUE) # # A tibble: 5 x 2 # age n # chr int # 1 ADULT 420287 # 2 JUVENILE 283902 # 3 YA 13715 # 4 NA 147 # 5 UNKNOWN 36 count(bris_libs, library, sort = TRUE) # # A tibble: 38 x 2 # library n # chr int # 1 SBK 49154 # 2 BSQ 45968 # 3 CNL 45642 # 4 IPY 44569 # 5 GCY 43090 # 6 CDE 42775 # 7 ASH 42086 # 8 WYN 35124 # 9 KEN 33947 # 10 MTO 31201 # #  with 28 more rows  License  This data is provided under a CC BY 4.0 license  It has been downloaded from Brisbane library checkouts, and tidied up using the code in data-raw.","type":"string"},"datatype":"string"},"type":"statement","id":"Q6677421$3637534B-FA64-4EF3-8579-B0DDDAB2EB3C","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"6dcfa2f686a29b91337cf0e5bf2d36b7222040b6","datavalue":{"value":{"time":"+2018-12-20T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q6677421$EEE22375-AA80-4D84-8AB9-A138C1E69262","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"42bf496508fe5b4376b0a70d120fb97ef3b85e13","datavalue":{"value":{"entity-type":"item","numeric-id":77008,"id":"Q77008"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q6677421$02A21899-0947-47A6-B95F-CC3137CC0C3E","rank":"normal"}],"P227":[{"mainsnak":{"snaktype":"value","property":"P227","hash":"fb48a71e803c11ef76f0abc398db8185e2335fb3","datavalue":{"value":"2437860","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q6677421$CB5236FE-DFD8-4445-96A0-4F52F1CB5AF1","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"0c5792c6fb43bf7ea5036dbff98cbe021c4127e9","datavalue":{"value":"10.5281/zenodo.2437860","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q6677421$B766E585-9163-484F-9390-7A67710B4268","rank":"normal"}],"P163":[{"mainsnak":{"snaktype":"value","property":"P163","hash":"45fcd4163b5f33e6e8c784f5522d7246c0a1a61e","datavalue":{"value":{"entity-type":"item","numeric-id":57056,"id":"Q57056"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q6677421$75AA3222-A557-4F2A-946E-ECBF774FCA25","rank":"normal"}],"P1474":[{"mainsnak":{"snaktype":"value","property":"P1474","hash":"b4477a2c2c6c1ef6d6d199cc77eb545ba9328829","datavalue":{"value":"0.5.0","type":"string"},"datatype":"string"},"type":"statement","id":"Q6677421$D3A9C6E5-090C-49B5-A46B-7E534DA184B7","rank":"normal"}],"P1460":[{"mainsnak":{"snaktype":"value","property":"P1460","hash":"d1e8073b72a070520efd3d14d4b3d2d3d03859e2","datavalue":{"value":{"entity-type":"item","numeric-id":5984635,"id":"Q5984635"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q6677421$BEF2BA77-98FA-4EA6-BA57-2F0BC879E321","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Brisbane Library Checkout Data","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Brisbane_Library_Checkout_Data"}}}}}