Exploring unpublished works that might be entering the public domain on 1 January 2019

For more information on the data and how it was harvested see Finding unpublished works entering the public domain.

In [2]:
import pandas as pd
import requests
from IPython.display import display, HTML
In [3]:
df = pd.read_csv('unpublished_works_entering_pd_20181006.csv', keep_default_na=False)
df.head()
Out[3]:
creator date id nuc title trove_url
0 Kelly, F. S. (Frederick Septimus), 1881-1916 1893-1926 10201266 ANL Music manuscripts https://trove.nla.gov.au/work/10201266
1 1863-1925 10544890 ANL Collection of promissory notes from remote are... https://trove.nla.gov.au/work/10544890
2 Gugeri, Peter Anthony, 1845-1930 1863-1910 14022030 WLB Gugeri family papers https://trove.nla.gov.au/work/14022030
3 Kruse, Johann Secundus, 1859-1927 1870-1927 14952244 ANL Papers of Johann Kruse https://trove.nla.gov.au/work/14952244
4 Freycinet, Rose Marie de, d. 1832 1802-1927 152218670 ANL Documents relating to Louis and Rose de Freycinet https://trove.nla.gov.au/work/152218670

Add institution names

In [5]:
nuc_list = list(df['nuc'].unique())
nucs = []
api_url = 'http://api.trove.nla.gov.au/v2/contributor/{}/'

params = {
    'encoding': 'json',
    'key': 'ADD YOUR API KEY HERE'
}

for nuc in nuc_list:
    if nuc:
        response = requests.get(api_url.format(nuc), params=params)
        data = response.json()
        name = data['contributor']['name']
        nucs.append({'nuc': nuc, 'institution': name})
In [86]:
nucs_df = pd.DataFrame(nucs)
df_new = pd.merge(df, nucs_df, on='nuc')
df_new.head()
Out[86]:
creator date id nuc title trove_url institution
0 Kelly, F. S. (Frederick Septimus), 1881-1916 1893-1926 10201266 ANL Music manuscripts https://trove.nla.gov.au/work/10201266 National Library of Australia.
1 1863-1925 10544890 ANL Collection of promissory notes from remote are... https://trove.nla.gov.au/work/10544890 National Library of Australia.
2 Kruse, Johann Secundus, 1859-1927 1870-1927 14952244 ANL Papers of Johann Kruse https://trove.nla.gov.au/work/14952244 National Library of Australia.
3 Freycinet, Rose Marie de, d. 1832 1802-1927 152218670 ANL Documents relating to Louis and Rose de Freycinet https://trove.nla.gov.au/work/152218670 National Library of Australia.
4 Dickens, Charles, 1812-1870 1869 168122181 ANL Cheque written by Charles Dickens https://trove.nla.gov.au/work/168122181 National Library of Australia.

Top 50 institutions

In [87]:
institutions = df_new.groupby(['nuc', 'institution']).size().sort_values(ascending=False).to_frame().reset_index()
institutions.columns = ['nuc', 'institution', 'count']
institutions[:50]
Out[87]:
nuc institution count
0 QSA Queensland State Archives. 2965
1 TSL Libraries Tasmania. 2112
2 ANL National Library of Australia. 1781
3 VSL State Library Victoria. 1642
4 WLB State Library of Western Australia. 779
5 QBCL:BI Brisbane City Council. Brisbane Images. 709
6 NSL State Library of NSW. 643
7 QSL State Library of Queensland. 630
8 SSL State Library of South Australia. 375
9 QU The University of Queensland. University of Qu... 268
10 VUMA The University of Melbourne. University of Mel... 237
11 SFU Flinders University. Flinders University Centr... 226
12 SAUS AusStage. 220
13 QU:IR The University of Queensland. University of Qu... 169
14 AIAS Australian Institute of Aboriginal and Torres ... 133
15 VRHS Royal Historical Society of Victoria. Royal Hi... 128
16 NU The University of Sydney. University of Sydney... 101
17 NMUS:E Powerhouse Museum. Exhibitions and Programs. 96
18 ZZZ Location unknown. 96
19 AAWM Australian War Memorial. Research Centre. 93
20 NMTC:SM Moore Theological College. Moore Theological C... 93
21 VNMU:I Museum Victoria. Museum Victoria Collections. 75
22 VPRO Public Record Office Victoria. Victorian Archi... 72
23 NMMU:C Australian National Maritime Museum. Australia... 66
24 AMOA:C National Museum of Australia. National Museum ... 58
25 SRGS Royal Geographical Society of South Australia.... 58
26 SUSA:A University of South Australia. University of S... 52
27 NWU:DC University of Wollongong. University of Wollon... 49
28 VU The University of Melbourne. The University of... 41
29 NNPL Newcastle Region Libraries. Newcastle Region L... 40
30 NMQU:MA Macquarie University. Macquarie University Med... 33
31 APLS Libraries ACT. 25
32 SMU South Australian Museum. SA Museum Library. 25
33 VMOU Monash University. Monash University Library. 24
34 AAAR National Archives of Australia. National Archi... 22
35 VDU Deakin University. Deakin University Library. 21
36 XNLS Northern Territory Library . 20
37 NNCU:A University of Newcastle Library. 20
38 VTAT Tatura Historical Society. Tatura Irrigation &... 19
39 NCP Royal Australasian College of Physicians. Hist... 19
40 NRHS Royal Australian Historical Society. RAHS Libr... 18
41 SUA University of Adelaide. Barr Smith Library. 18
42 QCQU Central Queensland University. Rockhampton Cam... 17
43 NMMU Australian National Maritime Museum. Vaughan E... 15
44 NNEA University of New England and Regional Archives. 14
45 VU:Q University of Melbourne - Residential College.... 11
46 ADFA Academy Library, UNSW Canberra. 11
47 VGHR Geelong Heritage Centre. 11
48 NJHS Australian Jewish Historical Society Inc. Aust... 10
49 NSWA Art Gallery of New South Wales. Edmund and Joa... 9

Filter by title keyword

In [96]:
title_kw = 'federation' # Edit to add your own keyword!
filtered_title = df_new.loc[df_new['title'].str.contains(title_kw, case=False, na=False)]
filtered_title
Out[96]:
creator date id nuc title trove_url institution
654 1892-1909 10918152 ANL Federation - Australia https://trove.nla.gov.au/work/10918152 National Library of Australia.
752 1947 159853683 ANL Communist influence in Teachers Federation https://trove.nla.gov.au/work/159853683 National Library of Australia.
1140 Barton, Edmund Sir, 1849-1920 1897-1898 23733819 ANL Letter and handbills relating to Australian fe... https://trove.nla.gov.au/work/23733819 National Library of Australia.
1298 1899 27029040 ANL Synopsis of the Commonwealth Bill : approved b... https://trove.nla.gov.au/work/27029040 National Library of Australia.
1312 1890-1891 28833077 ANL The federation movement, and proceedings of th... https://trove.nla.gov.au/work/28833077 National Library of Australia.
1313 1895-1901 28833285 ANL The Australian federation movement from a Sout... https://trove.nla.gov.au/work/28833285 National Library of Australia.
1683 1895-1901 5891330 ANL The Australian federation movement from a Sout... https://trove.nla.gov.au/work/5891330 National Library of Australia.
1696 Henry, John, 1834-1912 1899 6050113 ANL [Comments of the honourable John Henry dealing... https://trove.nla.gov.au/work/6050113 National Library of Australia.
2059 1900 191699908 WLB Records of Australian Federation of Friends of... https://trove.nla.gov.au/work/191699908 State Library of Western Australia.
4774 1928 200344170 QSL Waterside Workers Federation Cutting Book https://trove.nla.gov.au/work/200344170 State Library of Queensland.
6395 1898-1901 157372346 TSL Federation League of Northern Tasmania NG2368 ... https://trove.nla.gov.au/work/157372346 Libraries Tasmania.
6719 1917 157373022 TSL National Federation League - Derby Branch NG14... https://trove.nla.gov.au/work/157373022 Libraries Tasmania.
8816 1901 197248968 VDU Federation Day photograph album https://trove.nla.gov.au/work/197248968 Deakin University. Deakin University Library.
9318 1902 206859905 VUMA FEDERATED WOOL AND BASIL WORKERS FEDERATION, V... https://trove.nla.gov.au/work/206859905 The University of Melbourne. University of Mel...
In [97]:
# Save filtered results as a CSV file
filtered_title.to_csv('filtered_title_{}.csv'.format(title_kw), index=False)
# Make a download link
display(HTML('<a target="_blank" href="{}">Download CSV file</a>'.format('filtered_title_{}.csv'.format(title_kw))))

Filter by creator name

In [98]:
creator_kw = 'barton' # Edit to add your own name!
filtered_creator = df_new.loc[df_new['creator'].str.contains(creator_kw, case=False, na=False)]
filtered_creator
Out[98]:
creator date id nuc title trove_url institution
28 Barton, Edmund, Sir, 1849-1920 1827-1940 27034442 ANL Papers of Sir Edmund Barton https://trove.nla.gov.au/work/27034442 National Library of Australia.
161 Barton, Edmund, Sir, 1849-1920 1827-1940 14890081 ANL Papers of Sir Edmund Barton https://trove.nla.gov.au/work/14890081 National Library of Australia.
237 Barton, Edmund Sir, 1849-1920 1902 21003348 ANL Correspondence between Edmund Barton and Capta... https://trove.nla.gov.au/work/21003348 National Library of Australia.
938 Paterson, A. B. (Andrew Barton), 1864-1941 1905-1969 20843868 ANL Material relating to Waltzing Matilda https://trove.nla.gov.au/work/20843868 National Library of Australia.
1008 Barton, Edmund Sir, 1849-1920 1887-1947 21730412 ANL Letters, papers, bill https://trove.nla.gov.au/work/21730412 National Library of Australia.
1140 Barton, Edmund Sir, 1849-1920 1897-1898 23733819 ANL Letter and handbills relating to Australian fe... https://trove.nla.gov.au/work/23733819 National Library of Australia.
1218 Barton, Edmund Sir, 1849-1920 1901 24351962 ANL Speech delivered by Barton at the opening of F... https://trove.nla.gov.au/work/24351962 National Library of Australia.
1291 Barton, G. B. (George Burnett), 1836-1901 1800-1899 24904338 ANL Manuscripts https://trove.nla.gov.au/work/24904338 National Library of Australia.
1396 Paterson, A. B. (Andrew Barton), 1864-1941 1896 34380059 ANL Letter : Sydney to Thos. Whitby, Blackheath https://trove.nla.gov.au/work/34380059 National Library of Australia.
1412 Barton, Edmund Sir, 1849-1920 1901 34392819 ANL Letters https://trove.nla.gov.au/work/34392819 National Library of Australia.
1443 Paterson, A. B. (Andrew Barton), 1864-1941 1939 34444414 ANL Letter : Sydney, to Lawrence Henry Copping https://trove.nla.gov.au/work/34444414 National Library of Australia.
1473 Hack, John Barton, 1805-1884 1820-1884 34692159 ANL Family papers https://trove.nla.gov.au/work/34692159 National Library of Australia.
1581 Paterson, A. B. (Andrew Barton), 1864-1941 1859-1896 34892978 ANL Early Australian letters and booklet https://trove.nla.gov.au/work/34892978 National Library of Australia.
1609 Barton, Edmund Sir, 1849-1920 1903 35097888 ANL Letter : to Isaac Isaacs https://trove.nla.gov.au/work/35097888 National Library of Australia.
1710 Barton, Edmund, Sir, 1849-1920 1902 6116810 ANL [Address, to welcome Sir Edmund Barton, Ottawa] https://trove.nla.gov.au/work/6116810 National Library of Australia.
1726 Barton, Edmund, Sir, 1849-1920 1902 6148440 ANL [Document of congratulation from British Fair ... https://trove.nla.gov.au/work/6148440 National Library of Australia.
1741 Paterson, A. B. (Andrew Barton), 1864-1941 1900-1915 6466365 ANL There's another bloody horse fell down [by] A.... https://trove.nla.gov.au/work/6466365 National Library of Australia.
1759 Paterson, A. B. (Andrew Barton), 1864-1941 1915-1920 8651892 ANL Letters https://trove.nla.gov.au/work/8651892 National Library of Australia.
1762 Paterson, A. B. (Andrew Barton), 1864-1941 1896 8994780 ANL Letter of A.B. Paterson https://trove.nla.gov.au/work/8994780 National Library of Australia.
2870 Barton, Edmund, Sir, 1849-1920 32034635 VSL Papers https://trove.nla.gov.au/work/32034635 State Library Victoria.
5249 Barton, Newton, 1870-1935 1894-1895 203843366 QSL Newton Barton Diary https://trove.nla.gov.au/work/203843366 State Library of Queensland.
5567 Paterson, A. B. (Andrew Barton), 1864-1941 1992 35083238 NSL The man from ironbark / A.B. Paterson ; [calli... https://trove.nla.gov.au/work/35083238 State Library of NSW.
5921 Barton, G. B. (George Burnett), 1836-1901 1890 35932172 NSL The life and speeches of William Charles Wentw... https://trove.nla.gov.au/work/35932172 State Library of NSW.
5979 Brady, Alfred Barton, 1856-1932 1893 231806214 QU Drawings of the new Victoria Bridge, Brisbane https://trove.nla.gov.au/work/231806214 The University of Queensland. University of Qu...
6121 Barton, Edmund, Sir, 1849-1920 1901 36300223 QU Letter : Milson's Point, N.S.W. to A.S. Cowley https://trove.nla.gov.au/work/36300223 The University of Queensland. University of Qu...
In [100]:
# Save filtered results as a CSV file
filtered_creator.to_csv('filtered_creator_{}.csv'.format(creator_kw), index=False)
# Make a download link
display(HTML('<a target="_blank" href="{}">Download CSV file</a>'.format('filtered_creator_{}.csv'.format(creator_kw))))

Filter by institution (nuc)

In [92]:
nuc = 'ANL' # Edit to add your own nuc!
filtered_nuc = df_new.loc[df_new['nuc'] == nuc]
filtered_nuc
Out[92]:
creator date id nuc title trove_url institution
0 Kelly, F. S. (Frederick Septimus), 1881-1916 1893-1926 10201266 ANL Music manuscripts https://trove.nla.gov.au/work/10201266 National Library of Australia.
1 1863-1925 10544890 ANL Collection of promissory notes from remote are... https://trove.nla.gov.au/work/10544890 National Library of Australia.
2 Kruse, Johann Secundus, 1859-1927 1870-1927 14952244 ANL Papers of Johann Kruse https://trove.nla.gov.au/work/14952244 National Library of Australia.
3 Freycinet, Rose Marie de, d. 1832 1802-1927 152218670 ANL Documents relating to Louis and Rose de Freycinet https://trove.nla.gov.au/work/152218670 National Library of Australia.
4 Dickens, Charles, 1812-1870 1869 168122181 ANL Cheque written by Charles Dickens https://trove.nla.gov.au/work/168122181 National Library of Australia.
5 Paton, John Gibson, 1824-1907 1858-1891 179335696 ANL Journal, research notes and correspondence fro... https://trove.nla.gov.au/work/179335696 National Library of Australia.
6 Paton, Maggie Whitecross, 1841?-1905 1870-1943 179335711 ANL Journals and correspondence from the New Hebrides https://trove.nla.gov.au/work/179335711 National Library of Australia.
7 Frazer, Charles Edward, 1880–1913 1910-1913 193288592 ANL Early Commonwealth currency, 1910-1913 https://trove.nla.gov.au/work/193288592 National Library of Australia.
8 Norcock, John Henry, 1809-1854 1835-1837 20308332 ANL Diary of John Henry Norcock https://trove.nla.gov.au/work/20308332 National Library of Australia.
9 Nobbs, George Hunn, 1799-1884 1845-1886 20850242 ANL Pitcairn and Norfolk Island correspondence https://trove.nla.gov.au/work/20850242 National Library of Australia.
10 Eden, Morton Frederick, 1865-1948 1890-1996 20888178 ANL Diaries of Morton Frederick Eden https://trove.nla.gov.au/work/20888178 National Library of Australia.
11 Archer, William Henry, 1825-1909 1847-1866 21080750 ANL Letters of William Archer https://trove.nla.gov.au/work/21080750 National Library of Australia.
12 Gould, John, 1804-1881 1838-1884 21123716 ANL Papers of John Gould https://trove.nla.gov.au/work/21123716 National Library of Australia.
13 Watson, Thomas Greenlees, 1859-1912 1901-1912 21123799 ANL Papers of Thomas Greenlees Watson https://trove.nla.gov.au/work/21123799 National Library of Australia.
14 Wakefield, George, active 1853-1887 1853-1887 21154508 ANL Papers of George Wakefield https://trove.nla.gov.au/work/21154508 National Library of Australia.
15 Petherick, Edward Augustus, 1847-1917 1756-1917 21205250 ANL Papers of Edward Augustus Petherick https://trove.nla.gov.au/work/21205250 National Library of Australia.
16 Cook, Joseph, Sir, 1860-1947 1919-1927 21888272 ANL Papers of Sir Joseph Cook https://trove.nla.gov.au/work/21888272 National Library of Australia.
17 Atkins, Richard, 1745-1820 1791-1810 22119334 ANL Journal of Richard Atkins https://trove.nla.gov.au/work/22119334 National Library of Australia.
18 Fawkner, John Pascoe, 1792-1869 1810-1869 22469947 ANL Sir John Ferguson collection of papers of John... https://trove.nla.gov.au/work/22469947 National Library of Australia.
19 Macpherson, Christina Rutherford, 1864-1936 1900-1986 22493150 ANL Papers relating to the song "Waltzing Matilda" https://trove.nla.gov.au/work/22493150 National Library of Australia.
20 Henry, Alice, 1857-1943 1873-1943 22576237 ANL Papers of Alice Henry https://trove.nla.gov.au/work/22576237 National Library of Australia.
21 Kingsford-Smith, Charles, 1897-1935 1917-1935 22587305 ANL Papers of Sir Charles Kingsford-Smith https://trove.nla.gov.au/work/22587305 National Library of Australia.
22 Gullett, Henry, Sir, 1878-1940 1887-1961 22821978 ANL Papers of Sir Henry and Lady Penelope Gullett https://trove.nla.gov.au/work/22821978 National Library of Australia.
23 Sandwich, John Montagu, Earl of, 1718-1792 1771-1784 23386022 ANL Papers of John Montagu Sandwich https://trove.nla.gov.au/work/23386022 National Library of Australia.
24 Godber, Josiah, -1822 1817-1824 23399685 ANL Letters of Josiah Godber https://trove.nla.gov.au/work/23399685 National Library of Australia.
25 Brisbane, Thomas, Sir, 1773-1860 1815-1858 23447253 ANL Papers of Sir Thomas Brisbane https://trove.nla.gov.au/work/23447253 National Library of Australia.
26 Cook, James, 1728-1779 1762 23727236 ANL Description of the sea coast of Nova Scotia https://trove.nla.gov.au/work/23727236 National Library of Australia.
27 Banks, Joseph, 1743-1820 1745-1923 27034363 ANL Papers of Sir Joseph Banks https://trove.nla.gov.au/work/27034363 National Library of Australia.
28 Barton, Edmund, Sir, 1849-1920 1827-1940 27034442 ANL Papers of Sir Edmund Barton https://trove.nla.gov.au/work/27034442 National Library of Australia.
29 Richardson, Henry Handel, 1870-1946 1896-1946 27067175 ANL Papers and correspondence of Henry Handel Rich... https://trove.nla.gov.au/work/27067175 National Library of Australia.
... ... ... ... ... ... ... ...
1751 Bonwick, James, 1817-1906 1641-1900 7564724 ANL Transcript copies of records mainly held in th... https://trove.nla.gov.au/work/7564724 National Library of Australia.
1752 Dennis, C. J. (Clarence James), 1876-1938 1916 7587881 ANL A Love song https://trove.nla.gov.au/work/7587881 National Library of Australia.
1753 Griffiths, W. Scott, 1864-1929 1912-1950 7623796 ANL Papers of W. Scott Griffiths https://trove.nla.gov.au/work/7623796 National Library of Australia.
1754 Delisser, E.A. (Edmund Alexander), 1829-1900 1965 7810684 ANL Journal of Edmund A. Delisser https://trove.nla.gov.au/work/7810684 National Library of Australia.
1755 Cory, William Johnson, 1823-1892 1842-1892 7823069 ANL Correspondence https://trove.nla.gov.au/work/7823069 National Library of Australia.
1756 Fisher, Andrew, 1862-1928 1908 8034232 ANL Letter https://trove.nla.gov.au/work/8034232 National Library of Australia.
1757 Richardson, Henry Handel, 1870-1946 1911-1946 8054582 ANL Letters from Henry Handel Richardson to Mary K... https://trove.nla.gov.au/work/8054582 National Library of Australia.
1758 McIntosh, Hugh D. (Hugh Donald), 1876-1942 1913-1923 8561663 ANL Journal of Hugh D. McIntosh https://trove.nla.gov.au/work/8561663 National Library of Australia.
1759 Paterson, A. B. (Andrew Barton), 1864-1941 1915-1920 8651892 ANL Letters https://trove.nla.gov.au/work/8651892 National Library of Australia.
1760 Franklin, Jane Lady, 1791-1875 1839-1840 8873496 ANL Diaries https://trove.nla.gov.au/work/8873496 National Library of Australia.
1761 Lawson, Henry, 1867-1922 1917 8873540 ANL Papers of Henry Lawson https://trove.nla.gov.au/work/8873540 National Library of Australia.
1762 Paterson, A. B. (Andrew Barton), 1864-1941 1896 8994780 ANL Letter of A.B. Paterson https://trove.nla.gov.au/work/8994780 National Library of Australia.
1763 Berry, Alexander, 1781-1873 1800-1899 9082975 ANL Delivery note https://trove.nla.gov.au/work/9082975 National Library of Australia.
1764 1900-1910 9352802 ANL Map of Tasmania https://trove.nla.gov.au/work/9352802 National Library of Australia.
1765 Aitken, James, fl. 1901 1901 9353304 ANL Letters patent https://trove.nla.gov.au/work/9353304 National Library of Australia.
1766 Egan, Michael, fl. 1888 1888 9353616 ANL Document https://trove.nla.gov.au/work/9353616 National Library of Australia.
1767 Botterill, Joseph, d. 1868 1881 9355611 ANL Probate of will https://trove.nla.gov.au/work/9355611 National Library of Australia.
1768 Lang, John Dunmore, 1799-1878 1877-1878 9401497 ANL Reminiscences of my life and times in Australia https://trove.nla.gov.au/work/9401497 National Library of Australia.
1769 Kenna, Francis, 1865-1932 1887-1909 9921911 ANL Letter book https://trove.nla.gov.au/work/9921911 National Library of Australia.
1770 Donaldson, Stuart Alexander Sir, 1812-1867 1835-1856 9921982 ANL Notebook of Stuart Alexander Donaldson https://trove.nla.gov.au/work/9921982 National Library of Australia.
1771 Griffith, Samuel Sir, 1845-1920 1862 9922092 ANL Notes https://trove.nla.gov.au/work/9922092 National Library of Australia.
1772 Cox, George, 1871-1946 1911-1926 9922103 ANL Letters and newspaper cuttings https://trove.nla.gov.au/work/9922103 National Library of Australia.
1773 1821-1872 9922356 ANL Convict documents https://trove.nla.gov.au/work/9922356 National Library of Australia.
1774 Gordon, Adam Lindsay, 1833-1870 1870 9923959 ANL Hunting under the Southern Cross https://trove.nla.gov.au/work/9923959 National Library of Australia.
1775 1867-1872 9924041 ANL Register of decrees relating to New Caledonia https://trove.nla.gov.au/work/9924041 National Library of Australia.
1776 Hodder, Edwin, 1837-1904 1862 9924046 ANL The Junior Clerk, a Tale of City Life https://trove.nla.gov.au/work/9924046 National Library of Australia.
1777 Eden, Charles H. (Charles Henry), 1839-1900 1875 9924065 ANL Ralph Somerville, or, a Midshipman's Adventure... https://trove.nla.gov.au/work/9924065 National Library of Australia.
1778 Beechey, Frederick William, 1796-1856 1856 9924073 ANL Biography https://trove.nla.gov.au/work/9924073 National Library of Australia.
1779 Farrer, William, 1845-1906 1901-1902 9946088 ANL Field book https://trove.nla.gov.au/work/9946088 National Library of Australia.
1780 Cawley, John, fl. 1834 1834-1835 9959583 ANL Letters and printed statement https://trove.nla.gov.au/work/9959583 National Library of Australia.

1781 rows × 7 columns

In [95]:
# Save filtered results as a CSV file
filtered_nuc.to_csv('filtered_nuc_{}.csv'.format(nuc), index=False)
# Make a download link
display(HTML('<a target="_blank" href="{}">Download CSV file</a>'.format('filtered_nuc_{}.csv'.format(nuc))))
In [ ]: