source(here::here("src/common_basis.R"))
## here() starts at /Users/jiemakel/tyo/reuse-analysis
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.4.0 ✔ purrr 1.0.0
## ✔ tibble 3.1.8 ✔ dplyr 1.0.10
## ✔ tidyr 1.2.1 ✔ stringr 1.5.0
## ✔ readr 2.1.3 ✔ forcats 0.5.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
library(ggplot2)
library(gghsci)
library(ggiraph)
library(gt)
reuses_per_work_id <- tbl(con,sql("
SELECT ewbc.w_id, COUNT(DISTINCT i.w_id)-1 AS reusing_works
FROM (
SELECT * FROM `hpc-hd`.clustered_textreuses_c ct
) ct
INNER JOIN `hpc-hd`.clustered_pieces_c cp USING (piece_id)
INNER JOIN `hpc-hd`.earliest_works_by_cluster_c ewbc USING (cluster_id)
LEFT JOIN `hpc-hd`.idmap i USING (t_id)
GROUP BY ewbc.w_id
")) %>%
compute_a(name="reuses_per_work_id",temporary=FALSE,overwrite=TRUE,unique_indexes=list(c("w_id")))
Number of works reusing a work by the year of the original
d <- reuses_per_work_id %>%
inner_join(earliest_years_of_publication_by_work_a,by=c("w_id")) %>%
inner_join(
estc_projected_ecco_modules_a %>%
union_all(
idmap_a %>%
distinct(w_id,ecco_id) %>%
inner_join(ecco_core_a,by=c("ecco_id")) %>%
distinct(w_id,projected_ecco_module=ecco_module)
)
,by=c("w_id")) %>%
group_by(w_id) %>%
filter(!(projected_ecco_module %in% c("Keyworded but not projected", "Not keyworded")) | all(projected_ecco_module %in% c("Keyworded but not projected", "Not keyworded"))) %>%
ungroup() %>%
inner_join(idmap_a,by=c("w_id")) %>%
distinct(publication_year,w_id,work_id_short,projected_ecco_module,reusing_works) %>%
collect()
## Warning: Missing values are always removed in SQL aggregation functions.
## Use `na.rm = TRUE` to silence this warning
## This warning is displayed once every 8 hours.
(d %>%
filter(reusing_works>=100) %>%
ggplot(aes(x=publication_year,y=reusing_works,color=projected_ecco_module,data_id=w_id,tooltip=work_id_short)) +
theme_hsci_discrete() +
geom_point_interactive() +
facet_wrap(~projected_ecco_module,ncol=3) +
scale_y_log10() +
theme(legend.position="bottom")
) %>%
girafe(ggobj=.,width_svg=8,height_svg=11)
Top reused works per genre
d %>%
group_by(projected_ecco_module) %>%
slice_max(reusing_works,n=25) %>%
select(work_id_short,projected_ecco_module,reusing_works) %>%
group_map(~
gt(.,rowname_col="work_id_short") %>%
tab_header(title = .y) %>%
fmt_integer(reusing_works) %>%
cols_label(reusing_works="Reusing works")
)
[[1]]
|
|
Reusing works
|
|
1-liturgies
|
70,957
|
|
15-liturgies
|
40,530
|
|
110-plays romeo and juliet
|
10,399
|
|
41-acts and orders
|
9,350
|
|
658-cyclopaedia
|
6,673
|
|
2304-miscellany poems
|
1,700
|
|
852-naturalis historia
|
1,647
|
|
386-tea table miscellany collection of choice songs
|
1,441
|
|
489-histoire ancienne des egyptiens
|
1,329
|
|
74-hamlet
|
1,280
|
|
54-cato tragedy
|
1,136
|
|
614-joviall crew
|
1,049
|
|
222-othello moor of venice
|
1,027
|
|
229-tragical history of king richard iii alterd from shakespear
|
973
|
|
1335-epistulae
|
940
|
|
X-the psalms of david in metre
|
922
|
|
286-complete french master for ladies and gentlemen
|
904
|
|
769-thousand notable things of sundry sortes
|
879
|
|
2242-archaeologia graeca or antiquities of greece
|
846
|
|
494-king lear
|
837
|
|
220-henry iv
|
836
|
|
3413-antiquities of england and wales
|
832
|
|
X-the wonders of nature and art
|
801
|
|
1156-rom antiqu notitia or antiquities of rome in two parts
|
794
|
|
264-alexanders feast
|
763
|
[[2]]
|
|
Reusing works
|
|
15-liturgies
|
40,530
|
|
3-public general acts
|
28,222
|
|
13-aesops fables
|
17,872
|
|
45-colloquia
|
9,693
|
|
1123-canterbury tales
|
8,836
|
|
22-iliad
|
8,490
|
|
X-the annual register
|
8,472
|
|
658-cyclopaedia
|
6,673
|
|
6137-dictionaire historique et critique
|
5,640
|
|
X-the monthly catalogue
|
5,637
|
|
X-encyclopædia britannica
|
5,330
|
|
39-whole works of homer translated by alexander popeuire
|
5,311
|
|
171-book of knowledge treating of wisdom of ancients
|
5,014
|
|
52654-catalogue of library of faculty of advocates edinburgh
|
4,492
|
|
72-history of england
|
4,216
|
|
X-the new annual register
|
4,188
|
|
756-moriae encomium
|
4,069
|
|
X-the spectator. .
|
3,986
|
|
X-the historical register
|
3,650
|
|
X-the spectator
|
3,496
|
|
77-miscellanies
|
2,858
|
|
2658-works of john locke in nine volumes
|
2,679
|
|
61-works
|
2,421
|
|
3887-compleat works of that eminent minister of gods word mr isaac
ambrose consisting of these following treatises viz
|
2,334
|
|
X-a catalogue of books
|
2,246
|
[[3]]
|
|
Reusing works
|
|
1-liturgies
|
70,957
|
|
3-public general acts
|
28,222
|
|
374-actes and monuments
|
13,255
|
|
75-proceedings
|
10,376
|
|
6137-dictionaire historique et critique
|
5,640
|
|
594-britannia
|
5,534
|
|
891-a compleat history of europe or view of affairs thereof civil and
military from
|
5,028
|
|
171-book of knowledge treating of wisdom of ancients
|
5,014
|
|
114-lives
|
4,636
|
|
709-essais
|
4,616
|
|
5659-chronicles
|
4,588
|
|
2285-historical collections
|
4,358
|
|
72-history of england
|
4,216
|
|
798-proceedings
|
4,155
|
|
433-history of england
|
3,984
|
|
96-don quixote
|
3,510
|
|
1293-history
|
3,502
|
|
1322-history of reign of queen anne
|
3,377
|
|
X-the statutes at large
|
3,342
|
|
2923-generall historie of turkes
|
3,311
|
|
98-histoire dangleterre
|
3,301
|
|
88-hudibras
|
3,022
|
|
140-treaties etc united states 1794-11-19
|
2,961
|
|
X-gesta romanorum
|
2,811
|
|
24861-athenae oxonienses exact history of all writers and bishops who
have had their education in
|
2,661
|
[[4]]
|
|
Reusing works
|
|
6-miscellaneous documents 1643
|
8,495
|
|
22912-help for understanding of holy scripture
|
8,334
|
|
4535-public general acts
|
5,037
|
|
130686-a salve for every sore or collection of promises out of whole
book of god and is christian centurions infallible ground of confidence
or his poore soules most assured comfortable companion at all times and
in all things
|
3,743
|
|
14803-boke answeringe unto m mores lettur
|
3,726
|
|
5102-soveraigne power of parliaments and kingdomes
|
3,533
|
|
X-the souper of the lorde
|
3,171
|
|
18087-purchas his pilgrimes in fiue bookes
|
3,029
|
|
6689-a learned and very usefull commentary upon whole prophesie of
malachy by that reverend godly and learned divine mr
|
2,852
|
|
338-visitation articles
|
2,601
|
|
175708-ad nominis christiani socios consultatio
|
2,461
|
|
131649-counsel to afflicted or instruction and consolation for such as
have suffered loss by fire with advice to such as have escaped that sore
judgement
|
2,322
|
|
49841-theologicall questions dogmaticall observations and evangelicall
essays vpon gospel of jesus christ according to st matthew wherein about
two thousand six hundred and fifty necessary and profitable questions
are discussed and five hundred and eighty
|
2,248
|
|
12358-de ludo scachorum
|
2,246
|
|
1370-theatre of empire of great britaine
|
2,213
|
|
49730-burden of england scotland and ireland or watchmans alarum in
plain declaration to kings most excellent majesty pointing out chiefe
sins and causes of this civill war and of all those judgements under
which three kingdomes now groane plainely proved
|
1,994
|
|
2688-de rerum inventoribus
|
1,991
|
|
79692-an exposicion vpon songe of blessed virgine mary called magnificat
where vnto are added songes of salue regina benedictus and nunc dimittis
|
1,813
|
|
156048-a breviate of prelates intollerable usurpations both upon kings
prerogative royall and subjects liberties published by w huntleyuier
|
1,798
|
|
309-history of independency
|
1,792
|
|
1270-by mayor to aldermen of ward of blank forasmuch as lords day
commonly called sunday is of much broken and prophaned by disorderly
sort of people in frequenting tavernes alehouses and like
|
1,679
|
|
4801-herod and pilate reconciled
|
1,661
|
|
531-laws etc 1689-03-14
|
1,600
|
|
2583-boke of saint albans
|
1,555
|
|
745-proceedings 1642
|
1,552
|
[[5]]
|
|
Reusing works
|
|
3-public general acts
|
28,222
|
|
38-proceedings
|
11,855
|
|
75-proceedings
|
10,376
|
|
41-acts and orders
|
9,350
|
|
X-anno tricesimo primo henrici octavi
|
6,293
|
|
3225-public general acts
|
5,727
|
|
21-reports
|
5,623
|
|
86-reports
|
5,569
|
|
5-public general acts
|
4,930
|
|
X-anno xi henrici vij
|
4,719
|
|
X-the statutes vvhiche the iustices of peace, mayres, shyryffes,
baylyffes, constables, & other officers were of late commaunded by
the
|
4,280
|
|
798-proceedings
|
4,155
|
|
1368-de laudibus legum angliae
|
3,725
|
|
X-anno. xxviii. henrici viii
|
3,710
|
|
X-anno primo & secundo philippi & mariæ
|
3,410
|
|
X-the statutes at large
|
3,342
|
|
158-institutes of laws of england
|
3,214
|
|
140-treaties etc united states 1794-11-19
|
2,961
|
|
1545-symbolaeographia
|
2,960
|
|
24-public general acts
|
2,867
|
|
2751-interpreter
|
2,724
|
|
X-anno quinto reginæ elizabethe. at the parliament holden at wesmynster
the .xii. of ianuary, in the fyfth yere of the
|
2,597
|
|
49-laws etc
|
2,452
|
|
399-young clerks guide
|
2,394
|
|
4565-briefe treatise of testaments and last willes
|
2,332
|
[[6]]
|
|
Reusing works
|
|
1-liturgies
|
70,957
|
|
31-book of hours
|
22,672
|
|
X-the weekly entertainer; or agreeable and instructive repository
|
19,363
|
|
13-aesops fables
|
17,872
|
|
110-plays romeo and juliet
|
10,399
|
|
45-colloquia
|
9,693
|
|
1123-canterbury tales
|
8,836
|
|
22-iliad
|
8,490
|
|
X-the annual register
|
8,472
|
|
5797-annotations upon five bookes of moses and booke of psalmes
|
8,447
|
|
611-works of most reverend
|
7,884
|
|
34-liturgies
|
7,660
|
|
658-cyclopaedia
|
6,673
|
|
80-works
|
6,672
|
|
18-paradise lost poem in twelve books
|
6,318
|
|
23-metamorphoses
|
6,021
|
|
X-the works of the english poets
|
5,674
|
|
6137-dictionaire historique et critique
|
5,640
|
|
X-the monthly catalogue
|
5,637
|
|
2737-de casibus illustrium virorum
|
5,596
|
|
303-moralia
|
5,413
|
|
X-encyclopædia britannica
|
5,330
|
|
39-whole works of homer translated by alexander popeuire
|
5,311
|
|
2378-satires of horace imitated to which are added satires of dr john
donne versifyd by same hand
|
5,031
|
|
112-works
|
5,019
|
[[7]]
|
|
Reusing works
|
|
3-public general acts
|
28,222
|
|
193315-european magazine and london review containing literature history
politics arts manners and amusements of age
|
11,194
|
|
171-book of knowledge treating of wisdom of ancients
|
5,014
|
|
1218-dissertations on prophecies which have remarkably been fulfilled
and at this time are fulfilling in world
|
4,614
|
|
59-elements
|
4,030
|
|
674-philosophical transactions
|
3,323
|
|
140-treaties etc united states 1794-11-19
|
2,961
|
|
1201-works of learned isaac barrow
|
2,693
|
|
X-the general magazine of arts and sciences
|
2,144
|
|
4517-book of husbandry
|
2,068
|
|
185-epistolae morales
|
1,994
|
|
668-de jure naturae et gentium
|
1,859
|
|
6163-medical essays and observations published
|
1,801
|
|
3473-lexicon technicum
|
1,766
|
|
852-naturalis historia
|
1,647
|
|
78-instructor
|
1,620
|
|
4762-medical and philosophical commentaries
|
1,561
|
|
4075-wonders of little world
|
1,551
|
|
4237-treatise and discourse of lawes of forrest
|
1,480
|
|
1566-young mans companion or arithmetick made easy
|
1,465
|
|
29-complaint or night-thoughts
|
1,262
|
|
759-dialectica
|
1,244
|
|
34885-by quene mary
|
1,208
|
|
457-entretiens sur la pluralite des mondes
|
1,200
|
|
2059-telluris theoria sacra
|
1,171
|
[[8]]
|
|
Reusing works
|
|
206-new testament
|
49,015
|
|
X-the byble in englyshe
|
31,093
|
|
117855-a plaine and familiar explication by way of paraphrase of all
hard texts of whole divine scripture of old and nevv testament by ios
exon
|
15,309
|
|
141106-a commentarie vpon fourth booke of moses called numbers
containing foundation of church and common-wealth of israelites while
they walked and wandered in vvildernesse
|
12,522
|
|
81864-a familiar and christian instruction containing collection of
diuerse and sundrie places of scripture seruinge for exposition vpon
lordes prayer creede tenne commaundementes sacraments together with
offices and duties of eche christian towardes anot
|
11,992
|
|
5501-parable of wicked mammon
|
10,793
|
|
X-the fou[n]tayne or well of lyfe
|
10,788
|
|
121509-a pistle to christen reader revelation of antichrist
|
9,344
|
|
6073-god in mount
|
7,584
|
|
4481-novi testamenti catholica expositio ecclesiastica
|
6,703
|
|
114599-nevv testament of iesus christ translated faithfully into english
out of authentical latin according to best corrected copies of same
diligently conferred vvith greeke and other editions in diuers languages
vvith arguments of bookes and chapters an
|
5,760
|
|
77650-christian divinitie contained in divine service of church of
england summarily and for most part in order according as point on point
dependeth composed and with holy scriptures plainly and plentifully
confirmed written for furtherance of peoples un
|
5,736
|
|
X-here begynneth the pystles and gospels, of euery sonday and holy day
in the yeare
|
5,710
|
|
33212-commentarii in prophetas minores
|
5,560
|
|
198586-monotessaron evangelicall harmonie reducing foure evangelists
into one continued context and in it entire historie of acts and sayings
life and death of our lord and saviour jesus christ duely ordered
according to distinction of times
|
5,553
|
|
2459-sermons de m jean calvin sur le livre de job
|
5,529
|
|
34021-in epistolam s pauli apostoli ad romanos commentarii doctissimi
|
5,273
|
|
10481-piththy sic and moost notable sayinges of al scripture
|
5,237
|
|
149203-doctrine of gospel by plaine and familiar interpretation of
particular points or articles thereof with promises comforts and duties
seuerally belonging to same
|
5,200
|
|
47572-prophete isaye translated into englysshe
|
5,188
|
|
183553-picture of christ wonder of meditation earnest of eternitie
touchstone of faith or counterbuffe to despaire
|
5,154
|
|
143672-clii lectures vpon psalme li preached at ashby-delazouch in
leicester-shire
|
5,086
|
|
3047-annotations upon holy bible
|
5,081
|
|
X-a paraphrase on the new testament
|
4,788
|
|
114598-holie bible faithfully translated into english out of authentical
latin diligently conferred with hebrew greeke and other editions in
diuers languages with arguments of bookes and chapters annotations
tables and other helpes by english college of d
|
4,749
|
[[9]]
|
|
Reusing works
|
|
1-liturgies
|
70,957
|
|
15-liturgies
|
40,530
|
|
455-paraphrases in novum testamentum
|
36,793
|
|
16-bible
|
30,859
|
|
X-the confession of faith
|
29,350
|
|
3-public general acts
|
28,222
|
|
X-the holy bible
|
27,124
|
|
3219-sermonum decades quinque
|
25,069
|
|
47-thirty-nine articles
|
24,919
|
|
31-book of hours
|
22,672
|
|
1180-holi bible
|
20,156
|
|
13-aesops fables
|
17,872
|
|
1836-commentaries upon apostles creed
|
16,149
|
|
711-doctrinae christianae compendium
|
13,687
|
|
374-actes and monuments
|
13,255
|
|
X-the holy bible, containing the old and new testaments
|
12,975
|
|
5500-obedyence of christian man and how christen rulers ought to gouerne
wherin also yf thou marke dylygentlye thou shalte finde eyes to perceyue
craftye conueighaunce of all iugglers
|
12,750
|
|
1502-enchiridion militis christiani
|
12,735
|
|
2471-a paraphrase and annotations upon all books of new testament
briefly explaining all difficult places thereof
|
12,323
|
|
7-book of common prayer
|
12,257
|
|
236-homilies
|
10,603
|
|
X-the new testament of our lord and saviour jesus christ
|
10,422
|
|
X-the epistles and gospelles with a brief postil vpon the same from
after easter tyll aduent, which is the somer
|
10,273
|
|
3095-summa der godliker scrifturen
|
10,129
|
|
9600-knowledge and practice or plain discourse of chief things necessary
to be known believd and practised in order to salvation
|
10,095
|
[[10]]
|
|
Reusing works
|
|
1-liturgies
|
70,957
|
|
3-public general acts
|
28,222
|
|
38-proceedings
|
11,855
|
|
193315-european magazine and london review containing literature history
politics arts manners and amusements of age
|
11,194
|
|
75-proceedings
|
10,376
|
|
45-colloquia
|
9,693
|
|
41-acts and orders
|
9,350
|
|
X-the london magazine. or, gentleman’s monthly intelligencer
|
9,015
|
|
X-the annual register
|
8,472
|
|
305-miscellaneous documents
|
6,773
|
|
21-reports
|
5,623
|
|
39-whole works of homer translated by alexander popeuire
|
5,311
|
|
891-a compleat history of europe or view of affairs thereof civil and
military from
|
5,028
|
|
112-works
|
5,019
|
|
1218-dissertations on prophecies which have remarkably been fulfilled
and at this time are fulfilling in world
|
4,614
|
|
1501-adagia
|
4,573
|
|
52654-catalogue of library of faculty of advocates edinburgh
|
4,492
|
|
2285-historical collections
|
4,358
|
|
72-history of england
|
4,216
|
|
X-the new annual register
|
4,188
|
|
798-proceedings
|
4,155
|
|
X-the spectator. .
|
3,986
|
|
4-proclamations
|
3,832
|
|
10-whole duty of man
|
3,811
|
|
1368-de laudibus legum angliae
|
3,725
|