Count works and assets associated with rare books and manuscripts

[eddierubeiz]

As part of a grant application, I spent some time looking into our inventory of rare books and manuscripts in the digital collections. What we want is work counts, child work counts, and asset counts for sets:

Manuscripts:

• Genre Manuscripts
• Not also categorized as Rare Books (to avoid double-counting)
• Start date before 1850
• Published
• Not a child work

  Rare books:

• Genre Rare books (regardless of other genres)
• Published
• Not a child work

[eddierubeiz]

Summary of results:

• 13 manuscripts, with 4 child works and 1196 assets
• 70 rare books, with 757 child works and 7004 assets

[eddierubeiz]

Here's the math:

manuscripts = Work.where("json_attributes -> 'genre' ?  'Manuscripts'").where(published:true).where(parent:nil)
manuscripts = manuscripts.select { |m| m.date_of_work.first.present? }
manuscripts = manuscripts.select { |m| m.date_of_work.first.attributes['start'].present? }
manuscripts = manuscripts.select { |m| Date::strptime(m.date_of_work.first.attributes['start'][0..3], "%Y").year  < 1850  }
manuscripts = manuscripts.select { |m| m.genre.none? 'Rare books' }
manuscript_assets      = Set.new()
manuscript_child_works = Set.new()
manuscripts.each { |m| manuscript_assets.merge( m.all_descendent_members.where(kithe_model_type:'asset', published: 'true')) }
manuscripts.each { |m| manuscript_child_works.merge( m.all_descendent_members.where(kithe_model_type:'work', published: 'true')) }
manuscripts.count
    13
manuscript_child_works.count
    4
manuscript_assets.count
    1196

rare_books = Work.where("json_attributes -> 'genre' ?  'Rare books'").where(published:true).where(parent:nil)
rare_book_assets      = Set.new()
rare_book_child_works = Set.new()
rare_books.each { |m| rare_book_assets.merge( m.all_descendent_members.where(kithe_model_type:'asset', published: 'true')) }
rare_books.each { |m| rare_book_child_works.merge( m.all_descendent_members.where(kithe_model_type:'work', published: 'true')) }
rare_books.count
    70
rare_book_child_works.count
    757
rare_book_assets.count
    7004

[eddierubeiz]

List of our 13 manuscript titles:

• "Handwritten letter by Marsilo Landriani to a naturalist",
• "Miscellany of Medical, Magical, and Alchemical Recipes",
• "Liber de secretis naturae seu de quinta essentia",
• "Notes on lecture by Matthieu Orfila in Paris",
• "Testamentum Theorica",
• "Handwritten letter by Giovanni Antonio Giobert",
• "[Alchemical miscellany]",
• "Isaac Newton's copy of the Preparation of the [Sophick] Mercury for the [Philosophers'] Stone",
• "Roth Mallor's Work",
• "[Recipes and extracts on alchemy, medicine, metal-working, cosmetics, veterinary science, agriculture, wine-making, and other subjects]",
• "Louis Pasteur lecture notes on crystal structure, tartaric acid, and arsenites",
• "Letter to Dr. Bostock from John Dalton, June 21, 1808",
• "Prospectus for Part 1 of \"A New System of Chemical Philosophy\" with letter to Dr. Bostock from John Dalton, June 11, 1808"

[eddierubeiz]

List of our 70 rare book titles:

• "Della Theriaca et del Mithridato Libri Due",
• "The History and Practice of Aerostation",
• "A Table of Chymicall & Philosophicall Charecters with their Significations as they are Usually Found in Chymicall Authors both Printed & Manuscript",
• "Traité de la Chymie, Vol. 1",
• "Artis Magnae Artilleriae",
• "A Dictionary of Chemistry, Vol. I",
• "Der Hermetische Triumph, oder, Der siegende philosophische Stein",
• "Pretiosa margarita novella",
• "Astronomie",
• "Le diverse et artificiose machine del capitano Agostino Ramelli",
• "A Dictionary of Chemistry, Vol. III",
• "The Microscope Made Easy",
• "Chemical Atlas; or, The Chemistry of Familiar Objects",
• "Britannia: or, a Chorographical Description of the Flourishing Kingdoms of England, Scotland, and Ireland, and the Islands Adjacent, Vol. 1",
• "A Journal of Travels in England, Holland and Scotland, and of Two Passages Over the Atlantic, in the Years 1805 and 1806, Vol. 2",
• "Britannia: or, a Chorographical Description of the Flourishing Kingdoms of England, Scotland, and Ireland, and the Islands Adjacent, Vol. 3",
• "Travels in England, Scotland, and the Hebrides: Undertaken for the Purpose of Examining the State of the Arts, the Sciences, Natural History and Manners, in Great Britain, Vol. 1",
• "A Voyage to England: Containing Many Things Relating to the State of Learning, Religion, and Other Curiosities of that Kingdom",
• "Britannia: or, a Chorographical Description of the Flourishing Kingdoms of England, Scotland, and Ireland, and the Islands Adjacent, Vol. 4",
• "Voyage en Angleterre, en Ecosse et Aux Iles Hebrides: Ayant Pour Objet les Sciences, les Arts, L'histoire Naturelle et les Moeurs Avec la Description Mineralogique, Vol. 2",
• "The Young Botanist",
• "Theatrum Chemicum Britannicum",
• "Arcana Naturae Detecta",
• "Descriptive Catalogue of Chemical Apparatus, Chemicals and Pure Reagents",
• "Traité de la Chymie, Vol. 2",
• "Vier Bücher der Ritterschafft",
• "Traité Théorique et Pratique de l'Impression des Tissus, Vol. 2",
• "Conversations on Botany",
• "A Treatise on Adulterations of Food, and Culinary Poisons",
• "An history of animals: containing descriptions of the birds, beasts, fishes, and insects, of the several parts of the world",
• "Neft︠i︡ana︠i︡a promyshlennostʹ v s︠i︡evero-amerikanskom shtat︠i︡e Pensilʹvanīi i na Kavkaze",
• "Experimentum Bellini",
• "Occasional Reflections upon Several Subjects. Whereto is premis'd a Discourse About such kind of Thoughts.",
• "An Atlas of Gas Poisoning",
• "New Experiments Physico-Mechanicall, Touching the Spring of the Air, and its Effects (Made, for the Most Part, in a New Pneumatical Engine)",
• "Polygraphice, or, the Arts of Drawing, Engraving, Etching, Limning, Painting, Washing, Varnishing, Gilding, Colouring, Dying, Beautifying and Perfuming",
• "Elémens de Pyrotechnie",
• "Elements of Metallurgy for Dental Students",
• "L'Arte Vetraria distinta in Libri Sette",
• "Musaeum Hermeticum Reformatum et Amplificatum",
• "Palmer's New Catalogue, with Three Hundred Engravings of Apparatus, Illustrative of Chemistry, Pneumatics, Frictional and Voltaic Electricity, Electro Magnetism, Optics, &c.",
• "A Dictionary of Chemistry, Vol. II",
• "Methode der Chemischen Nomenklatur",
• "Atalanta Fugiens",
• "Extraordinary Facts Relating to the Vision of Colours: With Observations",
• "The Mineral Kingdom",
• "An Explanatory Dictionary of the Apparatus and Instruments Employed in the Various Operations of Philosophical and Experimental Chemistry",
• "Der Bildungstrieb der Stoffe",
• "Museum Wormianum",
• "Notes for making aqua fortis",
• "A New System of Chemical Philosophy",
• "Voyage en Angleterre, en Ecosse et Aux Iles Hebrides: Ayant Pour Objet les Sciences, les Arts, L'histoire Naturelle et les Moeurs Avec la Description Mineralogique, Vol. 1",
• "Amphitheatrum Sapientiae Aeternae Solius Verae",
• "An Explanation of Terms Used in Chemistry",
• "Vollenkommene Unterweisung, wie Raketen, Feuer- Wasser- Sturm-Kugeln, Granaten, Pech-Sturm-Kräntze, und allerhand Lust und Ernsthaffte Feuer-wercke zubereiten",
• "A Translation of the Table of Chemical Nomenclature, Proposed by De Guyton, formerly De Morveau, Lavoisier, Berthollet, and De Fourcroy",
• "Élémens de Chymie, Théorique et Pratique",
• "The Misogynist Dinner of the American Chemical Society",
• "The Herball, or, Generall Historie of Plantes",
• "A Treatise on Adulterations of Food, and Culinary Poisons",
• "An Account of the First Aërial Voyage in England",
• "Traité Élémentaire de Chimie",
• "Des couleurs et de leurs applications aux arts industriels à l'aide des cercles chromatiques",
• "Three Alchemical Miniatures",
• "A Synoptic Scale of Chemical Equivalents",
• "Micrographia : or, Some physiological descriptions of minute bodies made by magnifying glasses. With observations and inquiries thereupon",
• "Tratado Instructivo, y Práctico Sobre el Arte de la Tintura",
• "Mendeleyev's Periodic Table of the Elements",
• "Le Soleil: Exposé des principales découvertes modernes sur la structure de cet astre, son influence dans l'univers et ses relations avec les autres corps célestes",
• "Description des expériences de la machine aérostatique de MM. de Montgolfier"