Tribune collection metadata magic

This notebook helps you explore metadata (and images) from the State Library of NSW's Tribune collection.

The metadata has been harvested from the SLNSW catalogue and saved in CSV format. See this post for more information on the structure of the metadata.

Just work your way down the page running each cell by either clicking the play icon that appears when you hover over a cell, or by clicking a cell then hitting Shift+Enter.

To edit a cell, just click on it.

Setting things up

In [1]:
# Import the libraries we need
import pandas as pd
import altair as alt
from altair import datum
from wordcloud import WordCloud
from textblob import TextBlob
import nltk
import matplotlib.pyplot as plt
nltk.download('stopwords')
nltk.download('punkt')
from IPython.display import display, HTML
alt.renderers.enable('notebook')
/usr/local/Cellar/python/3.6.5/Frameworks/Python.framework/Versions/3.6/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88
  return f(*args, **kwds)
/usr/local/Cellar/python/3.6.5/Frameworks/Python.framework/Versions/3.6/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88
  return f(*args, **kwds)
[nltk_data] Downloading package stopwords to /Users/tim/nltk_data...
[nltk_data]   Package stopwords is already up-to-date!
[nltk_data] Downloading package punkt to /Users/tim/nltk_data...
[nltk_data]   Package punkt is already up-to-date!
Out[1]:
RendererRegistry.enable('notebook')

Let's load some data

The harvested metadata is currently sitting in another GitHub repository. We can load it directly from there using Pandas.

In [2]:
# Load the CSV file from GitHub.
# This puts the data in a Pandas DataFrame
df = pd.read_csv('https://raw.githubusercontent.com/wragge/dxlab-tribune/master/negatives/csv/all_items.csv')

Have a peek...

In [142]:
# Let's have a look inside...
# Note that both the columns and rows are truncated in this preview
df
Out[142]:
series_number part_number item_number level title call_number object_number priref intellectual_entity date_string ... quantity url parent_url number_images images description subjects topics people places
0 1 1.0 1 ITEM Item 001: Tribune negatives including portrait... ON 161/Item 001 1046072 110370001 IE4513478 196- ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4513557|FL4513559|FL4513561|FL4513564|FL4513... Original negative sleeve titled No. 1 Personal... Anthropologists--Australia.|Labor unions--Aust... motorcycles|motorcyclists|artists|trade union ... Rose, Frederick G. G. (Frederick George Godfre... Parliament House (Sydney, N.S.W.)
1 1 1.0 2 ITEM Item 002 : Tribune negatives including portrai... ON 161/Item 002 1046078 110370005 IE4511913 ca. 1964-1965 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4512030|FL4512031|FL4512033|FL4512034|FL4512... Original negative sleeve titled No. 2 Personal... Authors, Australian--20th century.|Labor union... boilermakers|wharf labourers|bowling alleys|st... Hardy, Frank (Francis Joseph), 1917-1994 Rushcutter Bowl (Bayswater Road, Rushcutters B...
2 1 1.0 3 ITEM Item 003 : Tribune negatives including photogr... ON 161/Item 003 1046077 110370004 IE4513075 1964-1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4513174|FL4513175|FL4513180|FL4513182|FL4513... Original negative sleeve titled No. 3 December... Labor unions--Officials and employees. trade unionists|meetings Ross, Lloyd (Lloyd Maxwell), 1901-1987 NaN
3 1 1.0 4 ITEM Item 004: Tribune negatives including internat... ON 161/Item 004 1046087 110370012 IE4513350 February-March 1965 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4513444|FL4513445|FL4513446|FL4513447|FL4513... Original negative sleeve titled No. 4 Moscow T... Soccer--New South Wales--Sydney. soccer teams|soccer players|crowds|receptions NaN Sydney Showground (N.S.W.)
4 1 1.0 5 ITEM Item 005: Tribune negatives including Internat... ON 161/Item 005 1046091 110370014 IE4518248 March-April 1965 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4518250|FL4518251|FL4518252|FL4518253|FL4518... Original negative sleeve titled No. 5 Internat... International Women's Day--New South Wales--Sy... women|musicians|demonstrations|posters & placards NaN United States Consulate-General (7 Wynyard Str...
5 1 1.0 6 ITEM Item 006: Tribune negatives including New Worl... ON 161/Item 006 1046092 110370015 IE4518955 1965 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4518957|FL4518958|FL4518960|FL4518962|FL4518... Original negative sleeve titled No. 6 Soviet C... Circus--Australia.|Bookstores--New South Wales... airports|bookshops|performers Great Moscow Circus NaN
6 1 1.0 7 ITEM Item 007: Tribune negatives including Matt Mun... ON 161/Item 007 1046096 110370018 IE723690 February 1965 ... 23 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 23 FL723804|FL723806|FL723808|FL723810|FL723813|F... Image descriptions provided by cataloguer.|1-2... NaN houses|children|city & town streets|portraits|... Stanley, Alexander, 1895-1968|Cain, Jacqueline... Moree (N.S.W.)
7 1 1.0 8 ITEM Item 008: Tribune negatives including Committe... ON 161/Item 008 1046099 110370020 IE4519723 4 January 1965 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4519725|FL4519726|FL4519727|FL4519728|FL4519... Original negative sleeve titled No. 8 French W... NaN banners|demonstrations|sailors|warships|boats Jeanne d'Arc (French warship)|Victor Schoelche... Sydney Harbour (N.S.W.)
8 1 1.0 9 ITEM Item 009: Tribune negatives including Transpor... ON 161/Item 009 1046110 110370028 IE4516853 1965 ... 29 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 29 FL4516855|FL4516857|FL4516860|FL4516861|FL4516... Original negative sleeve annotated Nos. 1-9 Tr... Labor unions--New South Wales--Sydney. trade unionists|meetings|window displays|toys|... Transport Workers Union of Australia. New Sout... Sydney Stadium (Rushcutters Bay, N.S.W.)
9 1 1.0 11 ITEM Item 011: Tribune negatives including portrait... ON 161/Item 011 1046111 110370029 IE4516723 ca. 1964-1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4516725|FL4516731|FL4516737|FL4516742|FL4516... Includes:|Pickets at Five-Ways Theatre, Paddin... Labor unions--Australia--Officials and employe... demonstrations|theatres & cinemas|trade union ... Actors and Announcers Equity Association of Au... Woolloomooloo (N.S.W.)|Paddington (N.S.W.)
10 1 1.0 13 ITEM Item 013: Tribune negatives of a Christmas par... ON 161/Item 013 1046122 110370039 IE4517930 December 1964 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4517932|FL4517934|FL4517937|FL4517939|FL4517... Original negative sleeve titled W.W.F. Old Vet... NaN Christmas cakes|dinners|festivals, celebration... Waterside Workers' Federation of Australia. Sy... NaN
11 1 1.0 14 ITEM Item 014: Tribune negatives including Boilerma... ON 161/Item 014 1046124 110370040 IE4515445 1964 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4515447|FL4515448|FL4515449|FL4515450|FL4515... Original negative sleeve titled No. 14 Boilerm... Labor unions--Australia--Officials and employees. meetings|elections|astronomers|stalls Boilermakers' and Blacksmiths' Society of Aust... Sydney Town Hall (Sydney, N.S.W.)
12 1 1.0 16 ITEM Item 016: Tribune negatives including preparat... ON 161/Item 016 1046127 110370043 IE4519920 1965 ... 27 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 27 FL4519922|FL4519925|FL4519927|FL4519929|FL4519... Original negative sleeve titled No. 16 Sydney,... NaN interiors|conventions|meetings|posters & placa... NaN Sydney Town Hall (Sydney, N.S.W.)
13 1 1.0 18 ITEM Item 018: Tribune negatives including Transpor... ON 161/Item 018 1046129 110370045 IE4515453 1964 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4515455|FL4515456|FL4515457|FL4515458|FL4515... Original negative sleeve titled No. 18 Sydney,... Transport workers--Labor unions--New South Wal... trade unionists|trade union officials|crowds|m... Transport Workers Union of Australia. New Sout... Wentworth Park (Sydney, N.S.W.)
14 1 1.0 19 ITEM Item 019: Tribune negatives including price ri... ON 161/Item 019 1046130 110370046 IE4517342 1964-1965 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4517344|FL4517349|FL4517350|FL4517351|FL4517... Original negative sleeve titled No. 19 Late 19... NaN petitions|Tongans|conventions|houses|residenti... Union of Australian Women|Australian Labor Par... Sydney Town Hall (Sydney, N.S.W.)
15 1 1.0 20 ITEM Item 020: Tribune negatives including protests... ON 161/Item 020 1046132 110370048 IE723453 1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL723685|FL723687|FL723688|FL723699|FL723705|F... Image descriptions provided by cataloguer.|1. ... NaN audiences|musicians|sack races|petitions|demon... Bush, Jennifer, 1942-|Affley, Declan, 1939-198... Woolloomooloo (N.S.W.)|Paddington Town Hall (P...
16 1 1.0 21 ITEM Item 021: Tribune negatives including Building... ON 161/Item 021 1048213 110370049 IE4516206 1964 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4516208|FL4516210|FL4516211|FL4516212|FL4516... Original negative sleeve titled No. 21 Late 19... Labor unions--New South Wales--Sydney. running races|children|union picnics|games|tug... Building Workers' Industrial Union of Australia. Gunnamatta Bay (N.S.W.)
17 1 1.0 22 ITEM Item 022: Tribune negatives including portrait... ON 161/Item 022 1048224 110370050 IE4517013 1965 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4517015|FL4517018|FL4517023|FL4517025|FL4517... Includes:|John McNamara on a job, 18 June 1965... NaN union picnics|concerts|children's art|train ri... Ray Brown and the Whispers (musical group) NaN
18 1 1.0 23 ITEM Item 023: Tribune negatives including Watersid... ON 161/Item 023 1048225 110370051 IE4516399 February 1965 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4516401|FL4516402|FL4516404|FL4516405|FL4516... Original negative sleeve titled No. 23 Sydney ... Labor unions--New South Wales--Sydney. union picnics|children|clowns|jetties & wharve... Waterside Workers' Federation of Australia Bronte Park (Bronte, N.S.W.)
19 1 1.0 24 ITEM Item 024: Tribune negatives including copy neg... ON 161/Item 024 1048557 110370052 IE4518190 1965 ... 18 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 18 FL4518192|FL4518193|FL4518194|FL4518195|FL4518... Original negative sleeve titled No. 24 Copy, J... NaN Paintings|busts NaN NaN
20 1 1.0 25 ITEM Item 025: Tribune negatives including copy neg... ON 161/Item 025 1048558 110370053 IE4518809 1965 ... 27 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 27 FL4518811|FL4518812|FL4518814|FL4518816|FL4518... Original negative sleeve titled No. 25 Copy, M... NaN petitions|newspaper clippings NaN NaN
21 1 1.0 26 ITEM Item 026: Tribune negatives including photogra... ON 161/Item 026 1048559 110370054 IE4516693 ca. 1963-1965 ... 29 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4516695|FL4516696|FL4516697|FL4516698|FL4516... Original negative sleeve title illegible.|Orig... NaN meetings|workers|demonstrations|women|trade un... Paterson, Fred, 1897-1977|Eureka Youth League ... Sydney Cricket Ground (Sydney, N.S.W.)
22 1 1.0 27 ITEM Item 027: Tribune negatives including photogra... ON 161/Item 027 1048908 110370055 IE4515807 1965 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4515809|FL4515812|FL4515814|FL4515816|FL4515... Original negative sleeve titled No. 27 CPA Per... Communists--Australia. meetings|press conferences|portraits Aarons, Eric|Aarons, Laurie, 1917-2005|Sharkey... NaN
23 1 1.0 28 ITEM Item 028: Tribune negatives including Eric Sen... ON 161/Item 028 1048979 110370056 IE4520083 22 July 1965 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4520085|FL4520086|FL4520087|FL4520088|FL4520... Includes:|Lismore flood : Eric Senz and proper... Floods--New South Wales--North Coast. cattle|farms|sheep|floods|country scenes|farmers NaN Clarence River (N.S.W.)
24 1 1.0 31 ITEM Item 031: Tribune negatives including Budget p... ON 161/Item 031 1048983 110370057 IE4520301 18 August 1965 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4520303|FL4520305|FL4520306|FL4520307|FL4520... Includes:|Donnelly of the Canberra Trades & La... Demonstrations--Australia. demonstrations|flats|buses NaN Parliament House (Parkes, A.C.T.)
25 1 1.0 32 ITEM Item 032: Tribune negatives of anti-Vietnam Wa... ON 161/Item 032 960074 110366605 IE455085 1965 ... 37 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 37 FL455087|FL455088|FL455090|FL455092|FL455094|F... Original negative sleeve titled No. 32 Anti Vi... Vietnam War, 1961-1975--Protest movements--New... demonstrations|posters & placards|courthouses|... NaN Central Police Court (Liverpool Street, Sydney...
26 1 1.0 33 ITEM Item 033: Tribune negatives including anti-Vie... ON 161/Item 033 960075 110366606 IE468594 March-April 1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL468596|FL468598|FL468600|FL468602|FL468604|F... Includes:|May Queen at the Seamen's office, Sy... Vietnam War, 1961-1975--Protest movements--Aus... bus conductors|demonstrations|posters & placar... Malaita (ship) NaN
27 1 1.0 34 ITEM Item 034: Tribune negatives including gatherin... ON 161/Item 034 960077 110366608 IE466138 ca. 1965 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL466140|FL466141|FL466143|FL466145|FL466147|F... Includes:|Gathering outside Parliament House, ... Demonstrations--New South Wales--Sydney.|Vietn... demonstrations|posters & placards|crowds NaN Parliament House (Parkes, A.C.T.)|Elizabeth St...
28 1 1.0 35 ITEM Item 035: Tribune negatives including distribu... ON 161/Item 035 960076 110366607 IE468653 3- 4 March 1965 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL468655|FL468656|FL468658|FL468660|FL468662|F... Original negative sleeve titled No. 35 Vietnam... Vietnam War, 1961-1975--Protest movements--New... demonstrations|posters & placards Waterside Workers' Federation of Australia United States Consulate-General (7 Wynyard Str...
29 1 1.0 36 ITEM Item 036: Tribune negatives of anti-Vietnam Wa... ON 161/Item 036 960078 110366609 IE458092 5 March 1965 ... 27 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 27 FL458094|FL458099|FL458102|FL458104|FL458106|F... Original negative sleeve titled No. 36 Vietnam... Anti-war demonstrations--New South Wales--Sydn... demonstrations|posters & placards|youth Eureka Youth League (Australia) United States Consulate-General (7 Wynyard Str...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1815 4 NaN 18 ITEM Item 18: Tribune negatives including May Day m... ON 162/Item 18 1045766 110369786 IE4585479 1973 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4585532|FL4585533|FL4585534|FL4585536|FL4585... Original negative sleeve titled F786 May Day|I... May Day (Labor holiday)--New South Wales. demonstrations|posters & placards|banners|monks NaN George Street (Sydney, N.S.W.)|University of S...
1816 4 NaN 19 ITEM Item 19: Tribune negatives including Internati... ON 162/Item 19 1045767 110369787 IE4587877 1987 ... 18 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 18 FL4587898|FL4587899|FL4587900|FL4587901|FL4587... Original negative sleeve titled IWD '87 Sydney... NaN posters & placards|banners|crowds|women NaN NaN
1817 4 NaN 20 ITEM Item 20: Tribune negatives including Internati... ON 162/Item 20 1045768 110369788 IE4587915 198- ... 21 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 21 FL4587953|FL4587954|FL4587956|FL4587957|FL4587... Original negative sleeve titled Sydney IWD I|I... NaN posters & placards|banners|crowds|women NaN Queen Victoria Building (Sydney, N.S.W.)
1818 4 NaN 21 ITEM Item 21: Tribune negatives including Internati... ON 162/Item 21 1045769 110369789 IE4588320 198- ... 22 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 22 FL4588363|FL4588366|FL4588367|FL4588369|FL4588... Original negative sleeve titled Sydney IWD 2|I... NaN posters & placards|banners|crowds|women|parks NaN Victoria Park (Sydney, N.S.W.)|George Street (...
1819 4 NaN 22 ITEM Item 22: Tribune negatives including Internati... ON 162/Item 22 1045772 110369791 IE4588564 198-? ... 21 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 21 FL4588620|FL4588622|FL4588624|FL4588626|FL4588... Original negative sleeve titled Adelaide I.W.D... NaN posters & placards|banners|crowds|women NaN Adelaide (S. Aust.)
1820 4 NaN 23 ITEM Item 23: Tribune negatives including Internati... ON 162/Item 23 1045780 110369796 IE4589120 1981 ... 21 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 22 FL4589148|FL4589150|FL4589152|FL4589153|FL4589... Original negative sleeve titled Melb. IWD|Incl... NaN posters & placards|banners|crowds|women NaN Swanston Street (Melbourne, Vic.)
1821 4 NaN 24 ITEM Item 24: Tribune negatives including student r... ON 162/Item 24 1045784 110369799 IE4588929 February 1988 ... 12 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 12 FL4588967|FL4588970|FL4588971|FL4588972|FL4588... Original negative sleeve titled File No. 2, St... NaN university students|demonstrations NaN University of Sydney (N.S.W.)
1822 4 NaN 25 ITEM Item 25: Tribune negatives including Invasion ... ON 162/Item 25 1045788 110369803 IE724070 1988 ... 26 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 26 FL724195|FL724198|FL724200|FL724203|FL724206|F... Includes:|Meeting in hall with panel of speake... NaN meetings|concerts NaN NaN
1823 4 NaN 26 ITEM Item 26: Tribune negatives of Wilfred Burchett... ON 162/Item 26 1045790 110369805 IE4588848 197- ... 29 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 29 FL4588903|FL4588904|FL4588905|FL4588906|FL4588... Original negative sleeve titled Wilfred Burche... NaN press conferences|portraits Burchett, Wilfred, 1911-1983 NaN
1824 4 NaN 27 ITEM Item 27: Tribune negative of Fred Paterson, 19... ON 162/Item 27 1045847 110369846 IE4588482 194-?, copy negative 197-? ... 1 negative http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 1 FL4588490 Original envelope titled Fred Paterson negativ... NaN NaN Paterson, Fred, 1897-1977 NaN
1825 4 NaN 28 ITEM Item 28: Tribune negative of Jack Marks, 1972 ... ON 162/Item 28 1045848 110369847 IE4588709 1972 ... 1 negative http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 1 FL4588715 Original envelope titled Negative of copy of p... NaN NaN Marks, Jack NaN
1826 4 NaN 29 ITEM Item 29: Tribune negative of Elliott Johnston,... ON 162/Item 29 1045849 110369848 IE4588022 197-? ... 1 negative http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 1 FL4588026 Original envelope titled Elliott Johnston nega... NaN NaN Johnston, Elliott, 1918-2011 NaN
1827 4 NaN 30 ITEM Item 30: Tribune negatives of Rob Durbridge, 1... ON 162/Item 30 1045850 110369849 IE4588009 1976? ... 3 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 3 FL4588015|FL4588016|FL4588017 Original envelope titled Rob Durbridge.|One ne... NaN NaN Durbridge, Robert Stuart, 1946-2014 NaN
1828 4 NaN 31 ITEM Item 31: Tribune negative of Brian Dunnett, 197-? ON 162/Item 31 1045869 110369865 IE4587989 197-? ... 1 negative http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 1 FL4587999 Original envelope titled Brian Dunnet (P. E. C... NaN NaN Dunnett, Brian, 1943- NaN
1829 4 NaN 32 ITEM Item 32: Tribune negatives including election ... ON 162/Item 32 1045875 110369872 IE4588763 198- ... 22 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 22 FL4588802|FL4588806|FL4588808|FL4588810|FL4588... Includes:|Media interview with a man (with ele... NaN interviews|political rallies NaN NaN
1830 4 NaN 33 ITEM Item 33: Tribune negatives including Education... ON 162/Item 33 1045878 110369874 IE4588559 1985 ... 12 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 12 FL4588583|FL4588584|FL4588587|FL4588589|FL4588... Includes:|Protesters holding placards includin... NaN posters & placards|film posters NaN NaN
1831 4 NaN 34 ITEM Item 34: Tribune negatives including posters f... ON 162/Item 34 1045882 110369876 IE4589141 1974 ... 18 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 18 FL4589186|FL4589191|FL4589193|FL4589195|FL4589... Includes:|Posters for Women's Liberation event... NaN posters & placards|offices|demonstrations NaN NaN
1832 4 NaN 35 ITEM Item 35: Tribune negatives including dock work... ON 162/Item 35 1045886 110369879 IE4589690 1964 ... 25 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 25 FL4589725|FL4589726|FL4589727|FL4589728|FL4589... Includes:|Dock workers loading or unloading fr... NaN posters & placards|wharf labourers NaN NaN
1833 4 NaN 36 ITEM Item 36: Tribune negatives including man remov... ON 162/Item 36 1045894 110369883 IE4588119 197-? ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4588178|FL4588180|FL4588181|FL4588182|FL4588... Includes:|Copy negatives of posters[?] includi... NaN graffiti NaN NaN
1834 4 NaN 37 ITEM Item 37: Tribune negatives including portrait ... ON 162/Item 37 1045897 110369885 IE4587825 197-? ... 16 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 16 FL4587844|FL4587845|FL4587846|FL4587847|FL4587... Includes:|Woman standing outside The Illawarra... NaN NaN NaN Illawarra (N.S.W.)
1835 4 NaN 38 ITEM Item 38: Tribune negatives of Summary Offences... ON 162/Item 38 1045901 110369888 IE4588499 197-? ... 7 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 7 FL4588518|FL4588519|FL4588521|FL4588522|FL4588... Original envelope inscribed:|Ann Stephen|(This... NaN demonstrations NaN NaN
1836 4 NaN 40 ITEM Item 40: Tribune negatives including women's m... ON 162/Item 40 1045909 110369891 IE4589409 ca. 1970-1989 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4589486|FL4589487|FL4589488|FL4589489|FL4589... Includes:|Tribune seller|Musical concert|Speak... NaN demonstrations|musical events & activities|pos... NaN NaN
1837 4 NaN 41 ITEM Item 41: Tribune negatives including group wit... ON 162/Item 41 1045912 110369894 IE4589644 198-? ... 8 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 8 FL4589672|FL4589674|FL4589676|FL4589677|FL4589... Includes:|Group portraits of speakers seated a... NaN meetings NaN NaN
1838 4 NaN 42 ITEM Item 42: Tribune negatives of demonstration ag... ON 162/Item 42 1045913 110369895 IE4589872 1989 ... 22 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 22 FL4589913|FL4589914|FL4589915|FL4589916|FL4589... Includes demonstration outside the Art Gallery... Demonstrations--New South Wales--Sydney. posters & placards|banners NaN Art Gallery of New South Wales
1839 4 NaN 43 ITEM Item 43: Tribune negatives of march in Sydney,... ON 162/Item 43 1045915 110369897 IE4588991 198-? ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4589043|FL4589044|FL4589045|FL4589046|FL4589... Includes|Bondi Beach, N.S.W.|Fish markets|Marc... NaN NaN NaN Bondi Beach (N.S.W.)
1840 4 NaN 44 ITEM Item 44: Tribune negatives including woman bus... ON 162/Item 44 1045918 110369899 IE4588326 198-? ... 39 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 39 FL4588404|FL4588406|FL4588407|FL4588408|FL4588... Includes:|Women's march, Melbourne, Victoria -... Bus drivers--New South Wales banners|crowds|women NaN NaN
1841 4 NaN 45 ITEM Item 45: Tribune negatives possibly of Communi... ON 162/Item 45 1045921 110369901 IE4588069 197-? ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4588145|FL4588147|FL4588150|FL4588153|FL4588... Includes:|Speakers with banner in background '... NaN meetings|banners|audiences NaN NaN
1842 4 NaN 46 ITEM Item 46: Tribune negatives including group por... ON 162/Item 46 1045923 110369903 IE4588029 198-? ... 17 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 17 FL4588049|FL4588050|FL4588051|FL4588052|FL4588... Includes:|Group portraits at restaurant.|Meeti... NaN portraits|restaurants, cafes etc.|posters & pl... NaN NaN
1843 4 NaN 47 ITEM Item 47: Tribune negatives including protest, ... ON 162/Item 47 1045927 110369905 IE4588543 197-? ... 4 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 4 FL4588550|FL4588551|FL4588552|FL4588553 Includes:|Protest outside Clerk of Courts offi... NaN posters & placards|demonstrations NaN NaN
1844 4 NaN 48 ITEM Item 48: Tribune negatives including protest, ... ON 162/Item 48 1045933 110369909 IE4588822 197-? ... 4 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 4 FL4588831|FL4588833|FL4588835|FL4588836 Includes:|Protest outside Clerk of Courts offi... NaN demonstrations NaN NaN

1845 rows × 22 columns


Create some summary data

We can use Pandas to give us a quick overview of the dataset.

What are the column headings?

In [223]:
# What are the column headings?
# Can you see which ones are missing from the truncated sample above?
df.columns
Out[223]:
Index(['series_number', 'part_number', 'item_number', 'level', 'title',
       'call_number', 'object_number', 'priref', 'intellectual_entity',
       'date_string', 'date_start', 'date_end', 'quantity', 'url',
       'parent_url', 'number_images', 'images', 'description', 'subjects',
       'topics', 'people', 'places'],
      dtype='object')

How many records are there?

In [170]:
# How many items?
len(df)
Out[170]:
1845

How many images are there?

In [144]:
# How many images?
df['number_images'].sum()
Out[144]:
60364

What's the earliest start date?

In [145]:
# What's the earliest start date?
df['date_start'].min()
Out[145]:
'1900-01-01 00:00:00'

What's the latest end date?

In [146]:
# What's the latest end date?
df['date_end'].max()
Out[146]:
'1990-12-31 00:00:00'

Exploring topics

Topics are text tags describing features of the photographs. They're more free-form and fine-grained than the subjects, but there can bit a bit of overlap and inconsistency.

Create a list of unique topics and sort them alphabetically

In [5]:
# Get unique values
topics = pd.unique(df['topics'].str.split('|', expand=True).stack()).tolist()
for topic in sorted(topics, key=str.lower):
    print(topic)
Aboriginal art
Aboriginal culture
Aboriginal peoples (Australians)
Aboriginal reserves
abortion
accidents & disasters
acting
activists
actors
advertising signs
aerial photographs
aeroplanes
aged people
agricultural exhibits
agricultural shows
airlines
airports
aliens
ambulances
amusement rides
anniversaries
antinuclear movement
antismoking movement
apartheid
apprentices
architects
architectural models
army cadets
arrests
art
art exhibitions
art galleries
artists
asbestos fabric
Asian peoples
astronauts
astronomers
astronomy
athletes
athletics
audiences
Australian flags
Australiana
authors
backyards
badges
ballet dancers
balloons
ballot papers
balls & dances
bands
bank personnel
banks
Banner (oats)
banners
banquets
barbecues (events)
barmaids
basketball
bathrooms
batteries (electric)
beaches
bears
beauty contestants
beauty contests
Bedford (trucks)
benches (seats)
betting shops
bicycles
billboards
birth control
birthday parties
bishops
blacksmiths
boardrooms
boats
boilermakers
bombs
book illustrations
book launches
bookshops
bottles
bowling alleys
boxers
boxing (sports)
breweries
brewery workers
brick walls
brickyards
bridge construction
bridges
bridges (ships)
budgets (government)
building construction
building demolition
building labourers
building suppliers
buildings, structures & establishments
bus conductors
bus depots
bus drivers
bus-stops
buses
bush
busts
butcher shops
camps
canneries
car parks
caravan parks
caravans
card games
cargo ships
caricatures
carnivals
carpenters
cars
cathedrals
cats
cattle
chains
charitable organisations
charity fairs
chemical factories
cheques
chess
chess players
child care
child-care centres
child-care workers
children
children's art
children's rides
Chileans
Chinese peoples
Christmas cakes
Christmas parties
churches
cigarettes
circuses
city & town buildings
city & town streets
city & town views
civil & political rights
cleaners (people)
cleaning
cleared land
climbers (people)
clocks
clothing
clothing industry workers
clowns
coal industry
coal loaders (wharves)
coalmines
Coca-Cola
coke works
commemorative posters
commercial events & activities
commercial industry
commercial vans
committees & inquiries
communication workers
communism
communities
community art projects
community centres
community health centres
company signs
compensation claims
competitions
concentration camps
concerts
concrete construction
conscription
conservation of natural resources
conservationists
constitutions
construction & demolition workers
construction equipment
construction machines
construction materials
construction sites
consulates
container wharves
containers & packing equipment
containers (shipping)
controlled fires
conventions
cooperatives
cotton gins
council workers
country scenes
courthouses
courts
craft working
cranes (machines)
crews
cricket
cricket teams
cricketers
crowds
crowns (headgear)
cultural events & activities
customers
customs officers
damaged or faulty buildings
dams & reservoirs
dance studios
dancers
dancing
dancing displays
darkrooms
defence force bases
delegations
demonstrations
demonstrators (political)
department stores
deputations
design (technology)
diagrams
didgeridoos
dinners
disabled people
disarmament
discrimination
discrimination in employment
display stands
doctors (medical)
dogs
dole queues
dolls
Drawings
drill (military)
earthmoving equipment
eating & drinking
education
elections
embassies
employment
employment offices
engine rooms
engine rooms (ships)
engine-drivers
engineering
engineers
entertainment
escalators
essays & articles
events & activities
evictions
exhibits
explosions
expressways
facades (places)
factories
factory workers
families
fans (devotees)
farewells
farm machines
farmers
farms
Fascists
fashion models
fashion parades
federal government
feminism
feminists
ferries
ferris wheels
ferry terminals
festivals, celebrations etc.
fetes
figurines
filing systems
film actors
film posters
film producers & directors
film productions
film-making
fire damage
fish markets
fishing boats
flags
flats
floating docks
floats (processions)
floods
flowers
folk dancing
food
food production industry
food production workers
football
footballers
foreign trade
forests
frigates
fruits
funeral parlours
funeral processions
funerals
funfairs
games
gangs
garbage
gardens
gay men
gay rights
gays
girls' homes
glass doors
glassware
golf
golf courses
goods trains
graffiti
grandstands
Greeks
greengrocers
groups (people)
hair (people)
halls
hangings (capital punishment)
harbours
health centres
health services
health workers
high school students
high schools
high-rise buildings
historic buildings
holes
horse racing
horsedrawn carriages
horses
hospital personnel
hospitals
hotels & taverns
house construction
houses
housing developments
illustrations
immigration
Indians
indigenous people
industrial areas
industrial buildings
industrial equipment
industrial workers
injuries
insurance industry
interiors
interiors (buildings)
international sports events
interviews
Iranians
Irish people
iron & steel industry
iron & steel works
ironworkers
irrigation
Japanese
jetties & wharves
jewellery
journalists
journals
judo
jumpers (clothing)
Kanaks (New Caledonian people)
kitchens
Koreans
labour disputes
labourers
land
land rights
landscapes (views)
launches
Lebanese people
lecture theatres
lectures
lesbians
linesmen (power & telegraph)
liquor shops
local government
logging
logs
lunches
main streets
maintenance workers
Malaysian people
Maoris
marine & waterway places & structures
markets
marquees
mass media
meat
mechanical engineering
meetings
megaphones
membership badges
men
merchant seamen
metalworkers
microphones
migrants
military medals
military parades
military police
military uniforms
miners
mining
mining industry
ministers of religion
monks
monorail tracks
monuments & memorials
mortuaries
motor dealers
motor vehicle factories
motor vehicles
motorcades
motorcycle police
motorcycles
motorcyclists
multiculturalism
murals
museums
Music
music conductors
musical ensembles
musical events & activities
musicians
national parks
nature strips
naval ships
netball
newsagencies
newspaper buildings
newspaper clippings
newspaper editors
newspaper offices
newspaper sellers
newspapers
nuclear bombs
nuclear energy
nuclear reactors
nuclear weapons tests
nuns
nurses
nursing homes
objets d'art
observatories
occupations
office buildings
office equipment
office workers
offices
official visits
oil refineries
openings (events)
orators
organs
paddy wagons
painting
Paintings
Palestinians
pamphlets
parents
parks
parliamentary buildings
parliaments
parties
parts of buildings or structures
passenger terminals
passenger trains
passengers
patients
peace movement
pensioners
pensions
people
people in political roles
people in societal roles
performers
performing animals
periodicals
personnel
petitions
petrol pumps
Philippine people
photographers
Photographs
pianists
pickets
picnics
plant (industrial)
playgrounds
plumbers
poets
police
police boys' clubs
police cars
police stations
political activities
political candidates
political cartoons
political parties
political posters
political rallies
politicians
polling booths
pollution
portraits
ports
postal workers
posters & placards
postmen
poultry farms
power stations
Premiers
preschools
presentation ceremonies
presents
Presidents (republics)
press conferences
primary schools
Prime Ministers
printers (people)
printing
printing machines
printing presses
prisoners
prisons
private schools
prizes & awards
processions
professional fees
prostitution
psychiatric nurses
public housing
public servants
public speaking
public utilities
publishers
punts
puppeteers
puppets
races
racial discrimination
radio stations
radios
raffles
railway carriages
railway construction
railway lines
railway sidings
railway stations
railway workers
railway yards
railways
rallies
rape
real estate signs
receptions
recovery rooms
rehearsals
religious activities
reporters
research centres
residential streets
restaurants, cafes etc.
retirement ceremonies
retirement parties
retrenchments
returned servicepeople
returned services clubs (places)
rigging (ships)
rites & ceremonies
road construction & maintenance
road transportation
road workers
roads & streets
rock-climbing
rubbish tips
Rugby League players
Rugby Union
rugby union players
runners
running races
Russian flags
Russians
sack races
sailing boats
sailors
sashes (clothing)
satellite dishes
sawmills
schoolchildren
schools & colleges
scientists
scrub
seascapes (views)
service stations
sex discrimination
shearers
sheep
shields (prizes)
shipping industry
ships
ships' captains
shipwrights
shipyards
shoe factories
shop assistants
shopping centres
shopping malls
shops
shows & exhibitions
signal stations
signs
silos
singers
slums
smog
smoke
smoking
soccer
soccer players
soccer teams
social services
socialism
socialists
soft toys
softball players
soldiers
soup kitchens
South Africans
space capsules
spacecraft
sports
sports carnivals
sports events
sports training
sportsgrounds
squatters (housing)
stables
stadiums
stage sets
stages (theatres)
stalls
stalls (merchandise)
statues
stewards (ships)
stock exchanges
storemen
street scenes
streetscapes
strikes
students
submarines
suburban streets
sugar refineries
summer schools
sundials
supermarkets
surf-lifesavers
swimming pools
swimming races
symbols
tax forms
taxation
taxi ranks
taxis
teachers
technical colleges
technical education
technology
teddy bears
telescopes
television cameras
television stations
tenancy
tennis
tennis courts
tennis players
tennis racquets
tents
terrace houses
textile factories
theatre companies
theatre groups (performers)
theatre posters
theatres & cinemas
theatrical costumes
theatrical productions
three-legged races
timber industry
timber industry activities
timber industry equipment
timber workers
Timor (Indonesian people)
toasts
tobacco factories
toddlers
Tongans
tourist information bureaus
towers
town halls
towns
toys
trade delegations
trade shows
trade union officials
trade unionists
trade unions
traffic
train rides
trains
trampolines
trams
transport events & activities
tree planting ceremonies
trees
troupes
trucks
tug of war
Turks
typesetting
typewriters
typists
umbrellas
unemployed people
uniforms
union picnics
universities
university buildings
university students
uranium
uranium mines
vacant buildings
vandalised buildings
vandalism
vessels (watercraft)
victory celebrations
Vietnam War
Vietnamese people
views
violence
Volkswagen Beetle (cars)
Volkswagen Kombi (vans)
volleyball
volunteers
voting
voyages & travels
wages
wall-hangings
war memorials
war victims
warehouses
warships
waste management
watches
water-polo
wedding receptions
weddings
welders
welfare establishments
welfare workers
whalers (ships)
wharf labourers
window displays
women
women's employment
women's shelters
wool industry workers
workers
working conditions
workshops
youth
youth centres
youth hostels
youth refuges
Yugoslavs
In [19]:
# Save as a CSV file
topics_df = pd.DataFrame(topics)
topics_df.columns = ['topic']
topics_df.to_csv('data/topics.csv', index=False)
display(HTML('<a target="_blank" href="data/topics.csv">Download topics.csv</a>'))

How often is each topic used?

In [11]:
# Splits the topic column and counts frequencies
topic_counts = df['topics'].str.split('|').apply(lambda x: pd.Series(x).value_counts()).sum().astype('int').sort_values(ascending=False).to_frame().reset_index(level=0)
# Add column names
topic_counts.columns = ['topic', 'count']
# Display with horizontal bars
display(topic_counts.style.bar(subset=['count'], color='#d65f5f').set_properties(subset=['count'], **{'width': '300px'}))
topic count
0 demonstrations 926
1 meetings 349
2 portraits 273
3 posters & placards 207
4 women 195
5 conventions 133
6 demonstrators (political) 113
7 banners 110
8 public speaking 103
9 men 87
10 rallies 85
11 workers 79
12 Aboriginal peoples (Australians) 75
13 groups (people) 72
14 audiences 65
15 trade unions 64
16 city & town streets 58
17 processions 57
18 uranium 56
19 police 55
20 crowds 51
21 civil & political rights 46
22 trade unionists 46
23 strikes 44
24 political rallies 42
25 signs 42
26 conscription 41
27 apartheid 38
28 children 37
29 elections 33
30 festivals, celebrations etc. 32
31 wages 31
32 pickets 30
33 ships 30
34 students 29
35 teachers 29
36 nurses 28
37 university students 26
38 peace movement 26
39 land rights 25
40 abortion 25
41 activists 24
42 city & town buildings 23
43 book launches 23
44 politicians 23
45 buildings, structures & establishments 23
46 arrests 22
47 wharf labourers 21
48 construction & demolition workers 21
49 newspapers 21
50 houses 19
51 Vietnam War 19
52 political parties 18
53 city & town views 17
54 theatrical productions 17
55 orators 16
56 public servants 16
57 art exhibitions 16
58 musicians 16
59 industrial workers 16
60 education 16
61 railway workers 15
62 building labourers 15
63 gays 14
64 newspaper sellers 14
65 lesbians 13
66 pensioners 13
67 political posters 13
68 trade union officials 13
69 streetscapes 12
70 dinners 12
71 petitions 12
72 anniversaries 11
73 flags 11
74 concerts 11
75 press conferences 11
76 bands 11
77 jetties & wharves 10
78 construction sites 10
79 industrial areas 10
80 postal workers 10
81 journalists 10
82 bookshops 10
83 youth 10
84 airports 9
85 budgets (government) 9
86 unemployed people 9
87 eating & drinking 9
88 pamphlets 9
89 interviews 9
90 courthouses 9
91 performers 9
92 sportsgrounds 8
93 racial discrimination 8
94 spacecraft 8
95 hospitals 8
96 running races 8
97 roads & streets 8
98 fetes 8
99 Vietnamese people 8
100 miners 8
101 shows & exhibitions 8
102 employment 8
103 graffiti 8
104 theatre groups (performers) 8
105 building construction 8
106 television cameras 8
107 warships 8
108 Australian flags 7
109 buses 7
110 boats 7
111 migrants 7
112 hotels & taverns 7
113 landscapes (views) 7
114 schools & colleges 7
115 receptions 7
116 floats (processions) 6
117 health services 6
118 factories 6
119 beaches 6
120 shipyards 6
121 evictions 6
122 sports events 6
123 expressways 6
124 facades (places) 6
125 universities 6
126 public housing 6
127 iron & steel works 6
128 halls 6
129 street scenes 6
130 funerals 6
131 metalworkers 6
132 delegations 6
133 dancers 6
134 grandstands 6
135 railways 6
136 industrial buildings 6
137 shops 5
138 high schools 5
139 picnics 5
140 newspaper offices 5
141 university buildings 5
142 Paintings 5
143 prisons 5
144 parties 5
145 railway stations 5
146 parks 5
147 sailors 5
148 oil refineries 5
149 launches 5
150 mass media 5
151 office workers 5
152 monuments & memorials 5
153 Philippine people 5
154 theatres & cinemas 5
155 boxers 5
156 trade shows 5
157 dancing 5
158 feminism 5
159 brewery workers 5
160 diagrams 5
161 sports carnivals 5
162 singers 4
163 musical events & activities 4
164 South Africans 4
165 Timor (Indonesian people) 4
166 war memorials 4
167 railway lines 4
168 murals 4
169 toys 4
170 cultural events & activities 4
171 suburban streets 4
172 consulates 4
173 Russians 4
174 lunches 4
175 terrace houses 4
176 Aboriginal reserves 4
177 political cartoons 4
178 political activities 4
179 police stations 4
180 Chinese peoples 4
181 Christmas parties 4
182 chemical factories 4
183 Rugby Union 4
184 welfare workers 4
185 printers (people) 4
186 printing machines 4
187 cleaners (people) 4
188 tennis 4
189 Photographs 4
190 returned servicepeople 4
191 entertainment 4
192 child-care centres 4
193 aged people 4
194 airlines 4
195 health centres 4
196 labour disputes 4
197 labourers 4
198 beauty contestants 4
199 ferries 4
200 union picnics 4
201 harbours 4
202 funeral processions 4
203 advertising signs 4
204 shopping centres 4
205 uniforms 4
206 gay rights 4
207 disarmament 4
208 parts of buildings or structures 3
209 cats 3
210 parliamentary buildings 3
211 cars 3
212 high-rise buildings 3
213 communication workers 3
214 communism 3
215 balls & dances 3
216 linesmen (power & telegraph) 3
217 Lebanese people 3
218 health workers 3
219 people 3
220 communities 3
221 Koreans 3
222 Kanaks (New Caledonian people) 3
223 poets 3
224 Fascists 3
225 football 3
226 child care 3
227 circuses 3
228 ballet dancers 3
229 offices 3
230 Rugby League players 3
231 farewells 3
232 marine & waterway places & structures 3
233 lectures 3
234 boilermakers 3
235 actors 3
236 breweries 3
237 merchant seamen 3
238 deputations 3
239 microphones 3
240 military parades 3
241 customers 3
242 authors 3
243 motorcades 3
244 Turks 3
245 cranes (machines) 3
246 motorcycles 3
247 country scenes 3
248 beauty contests 3
249 iron & steel industry 3
250 newspaper clippings 3
251 interiors (buildings) 3
252 interiors 3
253 embassies 3
254 bridges 3
255 nuclear bombs 3
256 families 3
257 conservation of natural resources 3
258 caravan parks 3
259 motor vehicles 3
260 Aboriginal art 3
261 printing presses 3
262 smoke 3
263 prisoners 3
264 shopping malls 3
265 towns 3
266 swimming pools 3
267 town halls 3
268 tug of war 3
269 sports training 3
270 stock exchanges 3
271 squatters (housing) 3
272 wool industry workers 3
273 rape 3
274 presentation ceremonies 3
275 vessels (watercraft) 3
276 trampolines 3
277 television stations 3
278 sailing boats 3
279 socialists 3
280 radio stations 3
281 weddings 3
282 shop assistants 3
283 barmaids 2
284 barbecues (events) 2
285 soldiers 2
286 sack races 2
287 factory workers 2
288 kitchens 2
289 bank personnel 2
290 child-care workers 2
291 satellite dishes 2
292 bears 2
293 farmers 2
294 youth refuges 2
295 rubbish tips 2
296 tennis racquets 2
297 residential streets 2
298 restaurants, cafes etc. 2
299 tennis courts 2
300 floods 2
301 artists 2
302 tennis players 2
303 meat 2
304 tents 2
305 rock-climbing 2
306 markets 2
307 athletes 2
308 backyards 2
309 children's rides 2
310 road construction & maintenance 2
311 road workers 2
312 insurance industry 2
313 transport events & activities 2
314 blacksmiths 2
315 farms 2
316 soccer teams 2
317 fish markets 2
318 bus conductors 2
319 gangs 2
320 bus depots 2
321 funfairs 2
322 bus drivers 2
323 bus-stops 2
324 frigates 2
325 building demolition 2
326 flats 2
327 butcher shops 2
328 soccer 2
329 camps 2
330 soccer players 2
331 food 2
332 car parks 2
333 toddlers 2
334 cargo ships 2
335 scientists 2
336 horse racing 2
337 bicycles 2
338 seascapes (views) 2
339 indigenous people 2
340 containers & packing equipment 2
341 clothing 2
342 horses 2
343 ferris wheels 2
344 historic buildings 2
345 film producers & directors 2
346 train rides 2
347 shipping industry 2
348 shipwrights 2
349 traffic 2
350 boxing (sports) 2
351 film actors 2
352 goods trains 2
353 architects 2
354 art galleries 2
355 stalls 2
356 supermarkets 2
357 constitutions 2
358 conservationists 2
359 Irish people 2
360 Japanese 2
361 crowns (headgear) 2
362 painting 2
363 Music 2
364 psychiatric nurses 2
365 voyages & travels 2
366 official visits 2
367 office equipment 2
368 Prime Ministers 2
369 community health centres 2
370 community centres 2
371 darkrooms 2
372 nuns 2
373 construction equipment 2
374 pensions 2
375 primary schools 2
376 people in political roles 2
377 pollution 2
378 Aboriginal culture 2
379 police cars 2
380 youth centres 2
381 Asian peoples 2
382 working conditions 2
383 cooperatives 2
384 plant (industrial) 2
385 power stations 2
386 council workers 2
387 construction materials 2
388 petrol pumps 2
389 symbols 2
390 women's shelters 2
391 Drawings 2
392 nuclear energy 2
393 flowers 2
394 committees & inquiries 2
395 antinuclear movement 2
396 discrimination in employment 2
397 violence 2
398 musical ensembles 2
399 disabled people 2
400 statues 2
401 political candidates 2
402 clowns 2
403 drill (military) 2
404 vandalised buildings 2
405 volunteers 2
406 aeroplanes 2
407 ministers of religion 2
408 mining 2
409 naval ships 2
410 newspaper buildings 2
411 mining industry 2
412 timber workers 1
413 card games 1
414 churches 1
415 carnivals 1
416 technical colleges 1
417 climbers (people) 1
418 cigarettes 1
419 caricatures 1
420 theatre companies 1
421 cleared land 1
422 clothing industry workers 1
423 cleaning 1
424 coalmines 1
425 taxis 1
426 taxi ranks 1
427 construction machines 1
428 caravans 1
429 textile factories 1
430 coal loaders (wharves) 1
431 coke works 1
432 coal industry 1
433 technology 1
434 carpenters 1
435 charitable organisations 1
436 chess players 1
437 tenancy 1
438 chess 1
439 telescopes 1
440 community art projects 1
441 commercial vans 1
442 commercial industry 1
443 theatrical costumes 1
444 cheques 1
445 company signs 1
446 compensation claims 1
447 clocks 1
448 charity fairs 1
449 commercial events & activities 1
450 commemorative posters 1
451 competitions 1
452 chains 1
453 concentration camps 1
454 theatre posters 1
455 teddy bears 1
456 cattle 1
457 timber industry activities 1
458 cathedrals 1
459 concrete construction 1
460 timber industry equipment 1
461 children's art 1
462 three-legged races 1
463 technical education 1
464 timber industry 1
465 bishops 1
466 canneries 1
467 Russian flags 1
468 warehouses 1
469 war victims 1
470 Tongans 1
471 wall-hangings 1
472 voting 1
473 Volkswagen Beetle (cars) 1
474 Volkswagen Kombi (vans) 1
475 Yugoslavs 1
476 accidents & disasters 1
477 acting 1
478 volleyball 1
479 views 1
480 aerial photographs 1
481 victory celebrations 1
482 agricultural exhibits 1
483 agricultural shows 1
484 vandalism 1
485 aliens 1
486 ambulances 1
487 amusement rides 1
488 antismoking movement 1
489 waste management 1
490 watches 1
491 apprentices 1
492 water-polo 1
493 workshops 1
494 Australiana 1
495 Banner (oats) 1
496 Bedford (trucks) 1
497 Chileans 1
498 Christmas cakes 1
499 Coca-Cola 1
500 women's employment 1
501 Greeks 1
502 Indians 1
503 Iranians 1
504 window displays 1
505 whalers (ships) 1
506 welfare establishments 1
507 Malaysian people 1
508 Maoris 1
509 welders 1
510 Palestinians 1
511 wedding receptions 1
512 Premiers 1
513 Presidents (republics) 1
514 vacant buildings 1
515 architectural models 1
516 busts 1
517 benches (seats) 1
518 billboards 1
519 birth control 1
520 birthday parties 1
521 boardrooms 1
522 trams 1
523 bombs 1
524 book illustrations 1
525 trains 1
526 bottles 1
527 bowling alleys 1
528 trade delegations 1
529 brick walls 1
530 brickyards 1
531 bridge construction 1
532 bridges (ships) 1
533 towers 1
534 tourist information bureaus 1
535 building suppliers 1
536 tobacco factories 1
537 toasts 1
538 bush 1
539 betting shops 1
540 tree planting ceremonies 1
541 army cadets 1
542 trees 1
543 uranium mines 1
544 art 1
545 umbrellas 1
546 asbestos fabric 1
547 astronauts 1
548 astronomers 1
549 astronomy 1
550 athletics 1
551 typists 1
552 typewriters 1
553 badges 1
554 typesetting 1
555 balloons 1
556 ballot papers 1
557 trucks 1
558 banks 1
559 troupes 1
560 banquets 1
561 basketball 1
562 bathrooms 1
563 batteries (electric) 1
564 container wharves 1
565 polling booths 1
566 containers (shipping) 1
567 religious activities 1
568 returned services clubs (places) 1
569 marquees 1
570 retrenchments 1
571 mechanical engineering 1
572 retirement parties 1
573 megaphones 1
574 membership badges 1
575 retirement ceremonies 1
576 research centres 1
577 reporters 1
578 military medals 1
579 military police 1
580 multiculturalism 1
581 military uniforms 1
582 rehearsals 1
583 monks 1
584 monorail tracks 1
585 recovery rooms 1
586 mortuaries 1
587 motor dealers 1
588 motor vehicle factories 1
589 real estate signs 1
590 motorcycle police 1
591 railway yards 1
592 maintenance workers 1
593 main streets 1
594 rigging (ships) 1
595 logs 1
596 scrub 1
597 industrial equipment 1
598 injuries 1
599 schoolchildren 1
600 sawmills 1
601 international sports events 1
602 sashes (clothing) 1
603 ironworkers 1
604 irrigation 1
605 jewellery 1
606 youth hostels 1
607 journals 1
608 judo 1
609 jumpers (clothing) 1
610 runners 1
611 rugby union players 1
612 land 1
613 lecture theatres 1
614 road transportation 1
615 rites & ceremonies 1
616 liquor shops 1
617 local government 1
618 logging 1
619 motorcyclists 1
620 railway sidings 1
621 illustrations 1
622 presents 1
623 parents 1
624 professional fees 1
625 prizes & awards 1
626 parliaments 1
627 private schools 1
628 passenger terminals 1
629 passenger trains 1
630 passengers 1
631 patients 1
632 printing 1
633 people in societal roles 1
634 performing animals 1
635 museums 1
636 periodicals 1
637 personnel 1
638 photographers 1
639 pianists 1
640 preschools 1
641 playgrounds 1
642 plumbers 1
643 poultry farms 1
644 postmen 1
645 police boys' clubs 1
646 ports 1
647 prostitution 1
648 paddy wagons 1
649 organs 1
650 openings (events) 1
651 music conductors 1
652 railway construction 1
653 railway carriages 1
654 national parks 1
655 nature strips 1
656 netball 1
657 newsagencies 1
658 raffles 1
659 newspaper editors 1
660 radios 1
661 races 1
662 puppets 1
663 nuclear reactors 1
664 nuclear weapons tests 1
665 puppeteers 1
666 nursing homes 1
667 objets d'art 1
668 observatories 1
669 occupations 1
670 office buildings 1
671 punts 1
672 publishers 1
673 public utilities 1
674 immigration 1
675 housing developments 1
676 controlled fires 1
677 engine rooms 1
678 discrimination 1
679 display stands 1
680 dogs 1
681 dole queues 1
682 dolls 1
683 earthmoving equipment 1
684 stages (theatres) 1
685 stage sets 1
686 stadiums 1
687 stables 1
688 employment offices 1
689 engine rooms (ships) 1
690 softball players 1
691 engine-drivers 1
692 engineering 1
693 engineers 1
694 escalators 1
695 essays & articles 1
696 events & activities 1
697 exhibits 1
698 explosions 1
699 sports 1
700 space capsules 1
701 soup kitchens 1
702 stalls (merchandise) 1
703 didgeridoos 1
704 stewards (ships) 1
705 design (technology) 1
706 taxation 1
707 cotton gins 1
708 tax forms 1
709 courts 1
710 craft working 1
711 swimming races 1
712 crews 1
713 cricket 1
714 cricket teams 1
715 cricketers 1
716 surf-lifesavers 1
717 customs officers 1
718 damaged or faulty buildings 1
719 dams & reservoirs 1
720 dance studios 1
721 sundials 1
722 summer schools 1
723 dancing displays 1
724 defence force bases 1
725 sugar refineries 1
726 submarines 1
727 storemen 1
728 department stores 1
729 fans (devotees) 1
730 farm machines 1
731 service stations 1
732 hair (people) 1
733 gay men 1
734 smog 1
735 slums 1
736 girls' homes 1
737 glass doors 1
738 glassware 1
739 golf 1
740 golf courses 1
741 silos 1
742 signal stations 1
743 greengrocers 1
744 hangings (capital punishment) 1
745 fashion models 1
746 shoe factories 1
747 ships' captains 1
748 high school students 1
749 shields (prizes) 1
750 sheep 1
751 holes 1
752 horsedrawn carriages 1
753 hospital personnel 1
754 shearers 1
755 sex discrimination 1
756 house construction 1
757 gardens 1
758 garbage 1
759 games 1
760 smoking 1
761 fashion parades 1
762 federal government 1
763 soft toys 1
764 feminists 1
765 ferry terminals 1
766 socialism 1
767 social services 1
768 figurines 1
769 filing systems 1
770 film posters 1
771 film productions 1
772 film-making 1
773 fire damage 1
774 fishing boats 1
775 floating docks 1
776 folk dancing 1
777 food production industry 1
778 food production workers 1
779 footballers 1
780 foreign trade 1
781 forests 1
782 fruits 1
783 funeral parlours 1
784 doctors (medical) 1
In [12]:
# Save as a CSV file
topic_counts.to_csv('data/topic_counts.csv', index=False)
display(HTML('<a target="_blank" href="data/topic_counts.csv">Download topic_counts.csv</a>'))

Search for records that include a topic

In [35]:
# Search topics
search_term = 'work'
topics_filtered = df.loc[df['topics'].str.contains(search_term, case=False, na=False)].copy()
topics_filtered
Out[35]:
series_number part_number item_number level title call_number object_number priref intellectual_entity date_string ... quantity url parent_url number_images images description subjects topics people places
13 1 1.0 18 ITEM Item 018: Tribune negatives including Transpor... ON 161/Item 018 1046129 110370045 IE4515453 1964 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4515455|FL4515456|FL4515457|FL4515458|FL4515... Original negative sleeve titled No. 18 Sydney,... Transport workers--Labor unions--New South Wal... trade unionists|trade union officials|crowds|m... Transport Workers Union of Australia. New Sout... Wentworth Park (Sydney, N.S.W.)
21 1 1.0 26 ITEM Item 026: Tribune negatives including photogra... ON 161/Item 026 1048559 110370054 IE4516693 ca. 1963-1965 ... 29 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4516695|FL4516696|FL4516697|FL4516698|FL4516... Original negative sleeve title illegible.|Orig... NaN meetings|workers|demonstrations|women|trade un... Paterson, Fred, 1897-1977|Eureka Youth League ... Sydney Cricket Ground (Sydney, N.S.W.)
26 1 1.0 33 ITEM Item 033: Tribune negatives including anti-Vie... ON 161/Item 033 960075 110366606 IE468594 March-April 1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL468596|FL468598|FL468600|FL468602|FL468604|F... Includes:|May Queen at the Seamen's office, Sy... Vietnam War, 1961-1975--Protest movements--Aus... bus conductors|demonstrations|posters & placar... Malaita (ship) NaN
37 1 1.0 46 ITEM Item 046: Tribune negatives including Watersid... ON 161/Item 046 1050977 110370171 IE4518352 July 1965 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4518354|FL4518356|FL4518357|FL4518358|FL4518... Includes:|Wharfie hostages at Fed Rooms, 14 Ju... Demonstrations--New South Wales--Sydney.|Labor... demonstrations|posters & placards|workers|yout... Waterside Workers' Federation of Australia NaN
41 1 1.0 50 ITEM Item 050: Tribune negatives including Mick O'B... ON 161/Item 050 1051123 110370243 IE4519451 August 1965 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4519453|FL4519466|FL4519468|FL4519471|FL4519... Includes:|Lobby Train trip to Canberra, 18 Aug... Labor unions--Australia--Officials and employees. trade union officials|workers|audiences|youth|... Roach, Edward Charles, 1909-1997|O'Brien, Mich... Wynyard Park (Sydney, N.S.W.)
50 1 2.0 59 ITEM Item 059: Tribune negatives including Sydney I... ON 161/Item 059 1053937 110370348 IE4517081 October 1965 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4517083|FL4517086|FL4517087|FL4517088|FL4517... Includes:|Sydney International Trade Fair (Oct... Trade shows--New South Wales--Sydney. office workers|typists|women|harbours|meetings... Cairns, Jim, 1914-2003|Hughes, T. E. F. (Thoma... NaN
52 1 2.0 61 ITEM Item 061: Tribune negatives including gatherin... ON 161/Item 061 1054482 110370369 IE4516579 ca. November 1965 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4516581|FL4516582|FL4516583|FL4516585|FL4516... NaN Labor unions--New South Wales. trade unionists|trade unions|trade union offic... NaN Trades Hall (Goulburn Street, Sydney, N.S.W.)|...
56 1 2.0 65 ITEM Item 065: Tribune negatives including Soviet o... ON 161/Item 065 1054973 110370410 IE4517828 November 1965 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4517830|FL4517831|FL4517833|FL4517834|FL4517... Includes:|Soviet wheat & oil ship. Captain Rom... Demonstrations--New South Wales--Sydney.|Trans... ships' captains|ships|crews|workers|demonstrat... Kevans, Denis, 1939-2005 Parliament House (Sydney, N.S.W.)|Old Treasury...
61 1 2.0 70 ITEM Item 070: Tribune negatives including workers ... ON 161/Item 070 1055014 110370447 IE4519106 October 1965 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4519108|FL4519112|FL4519114|FL4519115|FL4519... Includes:|6-Hour Day March, [Sydney, N.S.W.], ... Labor movement--New South Wales. banners|floats (processions)|posters & placard... NaN Park Street (Sydney, N.S.W.)
66 1 2.0 79 ITEM Item 079: Tribune negatives including demonstr... ON 161/Item 079 1055147 110370546 IE4519308 November 1965-January 1966 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4519310|FL4519311|FL4519312|FL4519313|FL4519... Includes:|The Australian Ballet at Sydney Airp... Demonstrations--New South Wales--Sydney.|Balle... demonstrations|posters & placards|workers|meet... Australian Ballet|Gorham, Kathleen, 1932-1983 NaN
68 1 2.0 81 ITEM Item 081: Tribune negatives including Malcolm ... ON 161/Item 081 1055200 110370578 IE4524266 September 1965-February 1966 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4524268|FL4524270|FL4524272|FL4524273|FL4524... Includes:|YCAC [Youth Campaign Against Conscri... Anti-war demonstrations--New South Wales--Sydn... demonstrations|posters & placards|youth|women|... Save Our Sons Movement|Salmon, Malcolm, 1925-1... Central Railway Station (Sydney, N.S.W.)|Evele...
70 1 2.0 83 ITEM Item 083: Tribune negatives including display ... ON 161/Item 083 1055235 110370600 IE4522107 ca. 1966 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4522109|FL4522110|FL4522111|FL4522112|FL4522... Includes:|Northern Australia display.|Workers ... Vietnam War, 1961-1975--Protest movements--New... meetings|audiences|houses|children|women|worke... Save Our Sons Movement NaN
75 1 2.0 88 ITEM Item 088: Tribune negatives including traffic ... ON 161/Item 088 1055259 110370621 IE4525375 February 1966 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4525377|FL4525384|FL4525386|FL4525388|FL4525... Includes:|Traffic from Harbour Bridge ; Opera ... Anti-war demonstrations--New South Wales--Sydn... workers|city & town streets|traffic|demonstrat... NaN United States Consulate-General (7 Wynyard Str...
77 1 2.0 90 ITEM Item 090: Tribune negatives including Tribune ... ON 161/Item 090 1055262 110370624 IE4523515 March 1966 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4523517|FL4523518|FL4523519|FL4523520|FL4523... Includes:|Builders Labourers at the Australia ... NaN newspaper sellers|meetings|construction sites|... NaN NaN
80 1 2.0 93 ITEM Item 093: Tribune negatives including Yevgeny ... ON 161/Item 093 1055383 110370716 IE4523677 March 1966 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4523679|FL4523684|FL4523686|FL4523687|FL4523... Original negative sleeve titled Y. Yevtushenko... NaN airports|construction & demolition workers|hou... Yevtushenko, Yevgeny Aleksandrovich, 1933- Kingsford-Smith Airport (Sydney, N.S.W.)
99 1 3.0 117 ITEM Item 117: Tribune negatives including Vietnam ... ON 161/Item 117 1255945 110373928 IE4521809 April-August 1966 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4521811|FL4521815|FL4521818|FL4521820|FL4521... Original negative sleeve titled 1966.|Includes... Vietnam War, 1961-1975--Protest movements--New... demonstrations|newspapers|construction & demol... Tribune (Newspaper)|Gould, Bob, 1937- NaN
101 1 3.0 119 ITEM Item 119: Tribune negatives including anti-con... ON 161/Item 119 1255950 110373930 IE4524169 1966? ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4524171|FL4524174|FL4524176|FL4524178|FL4524... Includes:|Anti-conscription demonstration, Row... Vietnam War, 1961-1975--Protest movements--New... construction & demolition workers|demonstrations Sydney Steel Co. Ltd. Sydney Harbour (N.S.W.)|Sydney Harbour Bridge ...
102 1 3.0 120 ITEM Item 120: Tribune negatives including MWU demo... ON 161/Item 120 1255951 110373931 IE4522302 1966? ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4522304|FL4522307|FL4522309|FL4522310|FL4522... Original negative sleeve titled 1966.|Includes... Demonstrations--New South Wales--Sydney.|Vietn... demonstrations|cleaners (people)|working condi... NaN NaN
130 1 4.0 151 ITEM Item 151: Tribune negatives including unemploy... ON 161/Item 151 1261275 110374029 IE4526840 September 1966 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4526916|FL4526917|FL4526919|FL4526921|FL4526... Original negative sleeve titled: Youth week Al... NaN dole queues|construction & demolition workers|... NaN NaN
135 1 4.0 156 ITEM Item 156: Tribune negatives including railway ... ON 161/Item 156 1261281 110374034 IE4530203 7-11 October 1966 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4530205|FL4530207|FL4530208|FL4530209|FL4530... Original negative sleeve titled: Railway worke... NaN demonstrations|railway workers NaN NaN
168 1 4.0 189 ITEM Item 189: Tribune negatives including Kay Enga... ON 161/Item 189 1269566 110374106 IE4532357 20-21 March 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4532359|FL4532360|FL4532361|FL4532362|FL4532... Original negative sleeve titled: 21-3-67, 20-3... NaN meetings|trade unionists|wool industry workers NaN NaN
172 1 4.0 193 ITEM Item 193: Tribune negatives including May Quee... ON 161/Item 193 1287041 110374127 IE4536593 March-April 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4536595|FL4536597|FL4536599|FL4536602|FL4536... Original negative sleeve titled: Ted Wheelwrig... NaN trade unionists|industrial workers|women Wheelwright, E. L. (Edward Lawrence)|Sheet Met... NaN
205 1 5.0 231 ITEM Item 231: Tribune negatives including anti-Vie... ON 161/Item 231 1290424 110374194 IE4532142 25 July 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4532144|FL4532145|FL4532146|FL4532150|FL4532... Original negative sleeve titled: 25/7/67.|Incl... NaN demonstrations|meetings|metalworkers|trade uni... NaN Redfern Oval (Elizabeth Street, Redfern, N.S.W.)
216 1 5.0 242 ITEM Item 242: Tribune negatives including sawmill,... ON 161/Item 242 1290870 110374255 IE4549127 1967? ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4549129|FL4549136|FL4549140|FL4549142|FL4549... Original negative sleeve titled: Timber Suppli... NaN timber industry activities|timber industry equ... NaN NaN
240 1 6.0 266 ITEM Item 266: Tribune negatives including the Inte... ON 161/Item 266 1296813 110374495 IE4546075 NaN ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4546077|FL4546079|FL4546080|FL4546081|FL4546... Original negative sleeve titled: 24-27 October... NaN trade shows|craft working NaN NaN
250 1 6.0 276 ITEM Item 276: Tribune negatives including meeting ... ON 161/Item 276 1296839 110374508 IE4545592 December 1967 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4545595|FL4545611|FL4545620|FL4545625|FL4545... Includes:|Meeting for the Restoration of Democ... NaN meetings|brewery workers|Greeks NaN NaN
257 1 6.0 283 ITEM Item 283: Tribune negatives including water-po... ON 161/Item 283 1302380 110374536 IE4545904 January 1968 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4545906|FL4545908|FL4545910|FL4545915|FL4545... Includes:|Panorama of postal workers strike vo... NaN meetings|water-polo|maintenance workers Colgate-Palmolive Pty. Ltd. Berowra Waters (N.S.W.)
258 1 6.0 284 ITEM Item 284: Tribune negatives including postal w... ON 161/Item 284 1302382 110374538 IE4547830 January 1968 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4547832|FL4547834|FL4547835|FL4547836|FL4547... Includes:|Postal workers picketing the Redfern... NaN postal workers|journalists|meetings NaN NaN
259 1 6.0 285 ITEM Item 285: Tribune negatives including Metal Tr... ON 161/Item 285 1302388 110374540 IE4550104 January 1968 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4550106|FL4550107|FL4550108|FL4550110|FL4550... Includes:|Metal Trades Federation meeting at S... NaN postal workers|meetings|strikes|metalworkers|w... Metal Trades Federation of Unions (Australia) NaN
262 1 6.0 288 ITEM Item 288: Tribune negatives including Jack Mun... ON 161/Item 288 1302395 110374543 IE4548011 January 1968 ... 26 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4548013|FL4548016|FL4548017|FL4548019|FL4548... Includes:|Jack, Judy, and Michael Mundey. Meta... NaN teachers|students|metalworkers|meetings Mundey, Jack, 1932-|N.S.W. Teachers' Federation NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1498 3 11.0 841 ITEM Item 0841: Tribune negatives including Melbour... ON 160/Item 0841 1054994 110370428 IE4445893 June-August 1985 ... 84 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 84 FL4446093|FL4446094|FL4446095|FL4446096|FL4446... Includes:|Bronwyn Ridgeway, burnt out car, 198... NaN pickets|gays|lesbians|rallies|workers|tourist ... NaN NaN
1511 3 12.0 854 ITEM Item 0854: Tribune negatives including General... ON 160/Item 0854 1055019 110370451 IE4451083 1984 ... 49 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 50 FL4451085|FL4451087|FL4451088|FL4451089|FL4451... Includes:|Denis I broken window, 1984|General ... NaN pickets|demonstrations|workers NaN NaN
1532 3 12.0 875 ITEM Item 0875: Tribune negatives including Tribune... ON 160/Item 0875 1055070 110370496 IE4449705 1985 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4449707|FL4449709|FL4449710|FL4449711|FL4449... Includes:|Tribune intervention & Communist Par... NaN farewells|workers NaN NaN
1549 3 12.0 892 ITEM Item 0892: Tribune negatives including Gough W... ON 160/Item 0892 1055106 110370524 IE4461704 1985 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4461706|FL4461707|FL4461708|FL4461709|FL4461... Includes:|Transport House, October 1985|Sequeb... NaN demonstrations|workers Whitlam, Gough, 1916-2014 NaN
1581 3 13.0 926 ITEM Item 0926: Tribune negatives including steelwo... ON 160/Item 0926 1055184 110370565 IE4464624 1986 ... 40 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 40 FL4464702|FL4464705|FL4464708|FL4464710|FL4464... Includes:|Tenants Union, August 1986|Wollongon... NaN dinners|iron & steel works|hospitals|coalmines NaN NaN
1584 3 13.0 929 ITEM Item 0929: Tribune negatives including Grimes ... ON 160/Item 0929 1055195 110370574 IE4465843 March 1986 ... 47 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 47 FL4465893|FL4465894|FL4465895|FL4465896|FL4465... Includes:|Grimes (Childcare, Sydney University... NaN demonstrations|child care|child-care workers NaN NaN
1589 3 13.0 934 ITEM Item 0934: Tribune negatives including Palm Su... ON 160/Item 0934 1055206 110370583 IE4464860 March-April 1986 ... 44 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 44 FL4464950|FL4464954|FL4464958|FL4464960|FL4464... Includes:|Palm Sunday, April 1986|ABC producti... NaN demonstrations|workers NaN NaN
1603 3 13.0 949 ITEM Item 0949: Tribune negatives including dockyar... ON 160/Item 0949 1055240 110370605 IE4478938 June 1986 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4479049|FL4479050|FL4479051|FL4479052|FL4479... Includes:|Eileen Powell, ARU, June 1986|Willia... NaN workers|demonstrations|wharf labourers|apartheid NaN NaN
1608 3 14.0 954 ITEM Item 0954: Tribune negatives including work fo... ON 160/Item 0954 1055247 110370610 IE4466395 June-July 1986 ... 37 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 37 FL4466477|FL4466480|FL4466481|FL4466483|FL4466... Includes:|Gary Foley, June 1986|Work for Dole ... NaN demonstrations|welfare establishments|workers NaN NaN
1631 3 14.0 977 ITEM Item 0977: Tribune negatives including tram wo... ON 160/Item 0977 1055329 110370668 IE4491284 September 1986 ... 41 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 41 FL4491405|FL4491406|FL4491407|FL4491408|FL4491... Includes:|Jan Smith, demonstration, Sydney, Se... NaN demonstrations|meetings|workers NaN NaN
1635 3 14.0 986 ITEM Item 0986a: Tribune negatives including head s... ON 160/Item 0986a 1055334 110370673 IE4469818 October 1986 ... 39 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 39 FL4469904|FL4469907|FL4469909|FL4469910|FL4469... Includes:|Metalworkers, head shots, October 19... NaN industrial workers|portraits|cats NaN NaN
1636 3 14.0 986 ITEM Item 0986b: Tribune negatives including portra... ON 160/Item 0986b 1055335 110370674 IE4470061 June-October 1986 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4470147|FL4470149|FL4470152|FL4470153|FL4470... Includes:|Metalworkers, head shots, October 19... NaN industrial workers|portraits|ships|submarines NaN NaN
1637 3 14.0 987 ITEM Item 0987: Tribune negatives including Collect... ON 160/Item 0987 1055336 110370675 IE4471112 October 1986 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4471145|FL4471146|FL4471147|FL4471148|FL4471... Includes:|Collective posing with Tribune's, Oc... NaN newspapers|workers NaN NaN
1640 3 14.0 990 ITEM Item 0990: Tribune negatives including workers... ON 160/Item 0990 1055340 110370679 IE4469469 November 1986 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4469557|FL4469559|FL4469561|FL4469563|FL4469... Includes:|Workers compensation demonstration, ... NaN demonstrations|fetes|workers NaN NaN
1650 3 14.0 1000 ITEM Item 1000: Tribune negatives including concert... ON 160/Item 1000 1055364 110370697 IE4468244 March 1987 ... 37 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 37 FL4468320|FL4468322|FL4468323|FL4468326|FL4468... Includes:|Waterboard workers, March 1987|Stan ... NaN concerts|bands|demonstrations|construction & d... NaN NaN
1653 3 15.0 1003 ITEM Item 1003: Tribune negatives including Dick Sm... ON 160/Item 1003 1055368 110370701 IE4468498 March-April 1987 ... 42 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 42 FL4468611|FL4468612|FL4468613|FL4468615|FL4468... Includes:|Dick Smith, anti smoking campaign, A... NaN antismoking movement|demonstrations|workers NaN NaN
1654 3 15.0 1004 ITEM Item 1004: Tribune negatives including protest... ON 160/Item 1004 1055369 110370702 IE4468931 March-April 1987 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4468998|FL4468999|FL4469002|FL4469004|FL4469... Includes:|Queensland, Anti union legislation p... NaN demonstrations|meetings|workers NaN NaN
1684 3 15.0 1033 ITEM Item 1033: Tribune negatives including Tribune... ON 160/Item 1033 1055415 110370748 IE4473852 October-December 1987 ... 37 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 37 FL4473997|FL4474000|FL4474003|FL4474006|FL4474... Includes:|Tribune workers, December 1987|Socia... NaN workers|newspaper offices|book launches NaN NaN
1692 3 15.0 1041 ITEM Item 1041: Tribune negatives including metal w... ON 160/Item 1041 1055425 110370756 IE4479173 May 1988 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4479229|FL4479230|FL4479232|FL4479234|FL4479... Includes:|May Day, May 1988|Metalworkers votin... NaN demonstrations|industrial workers|wages NaN NaN
1694 3 15.0 1043 ITEM Item 1043: Tribune negatives including Adminis... ON 160/Item 1043 1055427 110370758 IE4480115 May 1988 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4480177|FL4480178|FL4480179|FL4480181|FL4480... Includes:|Printery, Jess Walker, Angela Dunnet... NaN demonstrations|evictions|workers NaN NaN
1732 3 16.0 1081 ITEM Item 1081: Tribune negatives including protest... ON 160/Item 1081 1055495 110370814 IE4478110 June 1989 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4478163|FL4478165|FL4478167|FL4478169|FL4478... Includes:|Chinese protest in Sydney against Ti... NaN Chinese peoples|demonstrations|food production... McIntosh, Carlotta NaN
1765 3 17.0 1106 ITEM Item 1106: Tribune negatives including buildin... ON 160/Item 1106 1057800 110370862 IE4483493 April 1990 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4483602|FL4483603|FL4483604|FL4483606|FL4483... Includes:|Peter Hayes at Korea Australia Churc... NaN monuments & memorials|tree planting ceremonies... Evans, Michael|Murphy, Peter NaN
1770 3 17.0 1111 ITEM Item 1111: Tribune negatives including New Lef... ON 160/Item 1111 1058366 110370872 IE4483129 May-June 1990 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4483239|FL4483240|FL4483241|FL4483242|FL4483... Includes:|New Left Party opening session and s... NaN political parties|conventions|demonstrations|c... NaN NaN
1781 3 17.0 1122 ITEM Item 1122: Tribune negatives including Sidetra... ON 160/Item 1122 1058378 110370885 IE4485286 August 1990 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4485366|FL4485367|FL4485368|FL4485369|FL4485... Includes:|Industrial Amendment Bill in New Sou... NaN delegations|workers|theatre groups (performers) Murphy, Peter NaN
1794 3 17.0 1135 ITEM Item 1135: Tribune negatives including buildin... ON 160/Item 1135 1058407 110370902 IE4489214 January-August 1990 ... 27 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 27 FL4489216|FL4489219|FL4489220|FL4489221|FL4489... Includes:|Rainforest, SRAG & unions meet to tr... NaN rallies|construction & demolition workers|meet... NaN NaN
1797 4 NaN 1 ITEM Item 01: Tribune negatives including ICI plant... ON 162/Item 01 1045602 110369649 IE4585865 197-? ... 41 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 41 FL4585951|FL4585955|FL4585960|FL4585964|FL4585... Original negative sleeve titled Around Sydney ... NaN trucks|containers & packing equipment|chemical... NaN Parramatta Road (Petersham, N.S.W.)|Kings Lang...
1798 4 NaN 2 ITEM Item 02: Tribune negatives including portraits... ON 162/Item 02 1045669 110369699 IE4586241 197-? ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4586313|FL4586316|FL4586317|FL4586318|FL4586... Original negative sleeve titled Around Sydney ... NaN workers|linesmen (power & telegraph)|buses NaN Martin Place (Sydney, N.S.W.)
1799 4 NaN 3 ITEM Item 03: Tribune negatives including Pyrmont B... ON 162/Item 03 1045674 110369704 IE4586845 198-? ... 41 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 41 FL4586927|FL4586929|FL4586930|FL4586933|FL4586... Original negative sleeve titled Around Sydney|... NaN containers & packing equipment|workers|constru... NaN Pyrmont Bridge (Sydney, N.S.W.)|Pyrmont (N.S.W.)
1801 4 NaN 4 ITEM Item 04: Tribune negatives including high-rise... ON 162/Item 04 1045703 110369730 IE4586787 197-? ... 44 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 44 FL4586834|FL4586835|FL4586836|FL4586837|FL4586... Original negative sleeve titled Around Sydney.... NaN workers|linesmen (power & telegraph)|high-rise... NaN Waterloo (N.S.W.)|Redfern Railway Station (Red...
1809 4 NaN 12 ITEM Item 12: Tribune negatives including kitchen p... ON 162/Item 12 1045742 110369764 IE4586475 1973 ... 25 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 25 FL4586503|FL4586504|FL4586505|FL4586506|FL4586... Original negative sleeve titled F783 Builder L... NaN workers|kitchens|bathrooms NaN NaN

182 rows × 22 columns

In [36]:
# Save as a CSV file
topics_filtered.to_csv('data/topics-search-{}.csv'.format(search_term), index=False)
display(HTML('<a target="_blank" href="data/topics-search-{0}.csv">Download topics-search-{0}.csv</a>'.format(search_term)))

Exploring subjects

Subjects are a set of controlled and hierarchical descriptive labels following the Library of Congress Subject Headings.

Create a list of unique subject headings and sort them alphabetically

In [13]:
# Get unique values
subjects = pd.unique(df['subjects'].str.split('|', expand=True).stack()).tolist()
for subj in sorted(subjects, key=str.lower):
    print(subj)
Aboriginal Australians--Anniversaries.
Aboriginal Australians--Australia--Pictorial works.
Aboriginal Australians--Civil rights.
Aboriginal Australians--Criminal justice system.
Aboriginal Australians--Land tenure.
Aboriginal Australians--Mortality.
Aboriginal Australians--New South Wales--Nambucca Heads.
Aboriginal Australians--New South Wales--Walgett.
Aboriginal Australians--New South Wales.
Aboriginal Australians.
Adult Females
Adult Males
Anthropologists--Australia.
Anti-apartheid movements--Australia.
Anti-fascist movements--Australia.
Anti-war demonstrations--Australia.
Anti-war demonstrations--New South Wales
Anti-war demonstrations--New South Wales--Sydney.
Antinuclear movement--Australia.
Antinuclear movement--Northern Territory--Pine Gap
Antinuclear movement.
Architects and builders--New South Wales--Sydney.
athletes
Australia--Race relations.
Australian Council of Trade Unions--Congresses.
Authors, Australian--20th century.
Ballet companies - Australia.
Boiler-makers--Labor unions--Australia.
Boiler-makers--Labor unions--New South Wales--Sydney.
Bookstores--New South Wales--Sydney.
Boxing--Australia.
Boycotts
Break dancing--Australia.
Bus drivers--New South Wales
Circus--Australia.
Civil rights--New South Wales.
College students--New South Wales--Sydney--Political activity.
Communists--Australia.
Conscientious objectors--New South Wales.
Construction workers--Labor unions--New South Wales.
Construction workers--New South Wales--Sydney
Cotton growing--New South Wales
Cotton machinery--New South Wales
Courts--New South Wales--Sydney.
Dance, Aboriginal Australian.
Demonstrations--Australia.
Demonstrations--Australian Capital Territory--Canberra.
Demonstrations--New South Wales--Sydney--Pictorial works
Demonstrations--New South Wales--Sydney.
Demonstrations--New South Wales.
Demonstrations--Northern Territory--Pine Gap
Equal pay for equal work--Australia.
Factories--New South Wales.
Festivals--New South Wales--Sydney.
Floods--New South Wales--North Coast.
Gay liberation movement--Australia.
Gay rights--New South Wales.
Greeks--New South Wales--Sydney.
Hospitals--New South Wales.
Hotels--New South Wales--Watsons Bay.
Housing--New South Wales--Sydney.
International Women's Day--New South Wales--Sydney.
Labor movement--New South Wales.
Labor movement.
Labor unions -- New South Wales -- Officials and employees.
Labor unions--Australia--Officials and employees.
Labor unions--Australia.
Labor unions--Congresses.
Labor unions--New South Wales--Sydney.
Labor unions--New South Wales.
Labor unions--Officials and employees.
Land tenure--Australia.
May Day (Labor holiday)--New South Wales.
Meetings--New South Wales.
Miners--Australia.
Musicians--20th century.
Newcastle (N.S.W.)--Pictorial works.
Nuclear disarmament--Australia.
Nuclear disarmament--Congresses.
Nurses--New South Wales--Sydney.
Old age pensions--Australia.
Pageants--New South Wales.
Peace movements--Australia.
Photography--Negatives
Photography--New South Wales--Sydney--20th century.
Photography--Russia--20th century.
Poetry--20th century.
Political parties--Australia.
Politicians--Australia.
Portraits, Australian--20th century.
Portraits, Group.
Prices--New South Wales.
Protest movements--New South Wales--Sydney.
Public housing--New South Wales.
Railroads--New South Wales--Sydney.
Running races--New South Wales--Sydney
Schools--New South Wales--Sydney.
Schools--New South Wales.
Sheep ranches--New South Wales.
Ships--Maintenance and repair.
Soccer--New South Wales--Sydney.
Socialists--New South Wales--Sydney.
Soldiers--New South Wales.
Sports--Australia.
Strikes and lockouts--Australia.
Student movements--New South Wales--Sydney.
Student movements--New South Wales.
Sydney Harbour (N.S.W.)--Pictorial works.
Sydney Harbour (N.S.W.).
Sydney Opera House--Design and construction.
Teachers--New South Wales--Political activity.
Tennis--Australia.
Theaters--New South Wales--Sydney.
Toymakers
Trade shows--New South Wales--Sydney.
Trade-unions--New South Wales--Officials and employees.
Trade-Unions--New South Wales.
Trade-unions--Shipbuilding industry employees--New South Wales.
Transport workers--Labor unions--New South Wales.
Universities and colleges--New South Wales--Sydney.
Vietnam War, 1961-1975
Vietnam War, 1961-1975--Draft resisters--New South Wales--Sydney
Vietnam War, 1961-1975--Mass media and the war
Vietnam War, 1961-1975--Pamphlets
Vietnam War, 1961-1975--Protest movements--Australia.
Vietnam War, 1961-1975--Protest movements--New South Wales--Sydney
Vietnam War, 1961-1975--Protest movements--Victoria.
Vietnamese--Australia
Wages--New South Wales.
Women musicians--Australia.
Women's health services--New South Wales--Sydney.
Women's rights--Australia.
Women's rights--New South Wales.
Women's rights--Pictorial works.
Women, Aboriginal Australian.
In [14]:
# Save as a CSV file
subjects_df = pd.DataFrame(subjects)
subjects_df.columns = ['subject']
subjects_df.to_csv('data/subjects.csv', index=False)
display(HTML('<a target="_blank" href="data/subjects.csv">Download subjects.csv</a>'))

How often is each subject used?

In [22]:
# Splits the subject column and counts frequencies
subject_counts = df['subjects'].str.split('|').apply(lambda x: pd.Series(x).value_counts()).sum().astype('int').sort_values(ascending=False).to_frame().reset_index(level=0)
# Add column names
subject_counts.columns = ['subject', 'count']
# Display with horizontal bars
display(subject_counts.style.bar(subset=['count'], color='#d65f5f').set_properties(subset=['count'], **{'width': '300px'}))
subject count
0 Vietnam War, 1961-1975--Protest movements--New South Wales--Sydney 58
1 Demonstrations--New South Wales--Sydney. 55
2 Photography--New South Wales--Sydney--20th century. 49
3 Anti-war demonstrations--New South Wales--Sydney. 35
4 Antinuclear movement--Australia. 25
5 Meetings--New South Wales. 23
6 May Day (Labor holiday)--New South Wales. 21
7 Demonstrations--Northern Territory--Pine Gap 12
8 Adult Females 12
9 Demonstrations--New South Wales--Sydney--Pictorial works 11
10 Aboriginal Australians--Civil rights. 11
11 Antinuclear movement--Northern Territory--Pine Gap 11
12 Aboriginal Australians--Land tenure. 10
13 Adult Males 10
14 Labor unions--New South Wales--Sydney. 9
15 Peace movements--Australia. 8
16 Anti-war demonstrations--Australia. 8
17 Portraits, Australian--20th century. 7
18 Australia--Race relations. 7
19 Women's rights--New South Wales. 7
20 Aboriginal Australians--Mortality. 7
21 Labor unions--Australia--Officials and employees. 6
22 Vietnam War, 1961-1975--Protest movements--Australia. 5
23 Labor movement. 5
24 Nurses--New South Wales--Sydney. 5
25 Nuclear disarmament--Australia. 5
26 Demonstrations--New South Wales. 5
27 Labor unions--New South Wales. 5
28 Aboriginal Australians--Criminal justice system. 5
29 Women's health services--New South Wales--Sydney. 4
30 Women's rights--Australia. 4
31 Wages--New South Wales. 4
32 Transport workers--Labor unions--New South Wales. 4
33 Demonstrations--Australian Capital Territory--Canberra. 4
34 Trade-Unions--New South Wales. 4
35 Student movements--New South Wales. 3
36 Vietnam War, 1961-1975--Draft resisters--New South Wales--Sydney 3
37 Circus--Australia. 3
38 Civil rights--New South Wales. 3
39 Prices--New South Wales. 3
40 Trade shows--New South Wales--Sydney. 3
41 Australian Council of Trade Unions--Congresses. 3
42 Protest movements--New South Wales--Sydney. 3
43 Floods--New South Wales--North Coast. 2
44 Dance, Aboriginal Australian. 2
45 Gay liberation movement--Australia. 2
46 Construction workers--New South Wales--Sydney 2
47 Festivals--New South Wales--Sydney. 2
48 Labor unions -- New South Wales -- Officials and employees. 2
49 Factories--New South Wales. 2
50 Demonstrations--Australia. 2
51 Pageants--New South Wales. 2
52 Photography--Russia--20th century. 2
53 Portraits, Group. 2
54 Teachers--New South Wales--Political activity. 2
55 Railroads--New South Wales--Sydney. 2
56 Sydney Opera House--Design and construction. 2
57 Soccer--New South Wales--Sydney. 2
58 Anti-war demonstrations--New South Wales 2
59 Trade-unions--New South Wales--Officials and employees. 2
60 Anthropologists--Australia. 1
61 Aboriginal Australians--New South Wales--Nambucca Heads. 1
62 Aboriginal Australians. 1
63 Aboriginal Australians--Australia--Pictorial works. 1
64 Anti-apartheid movements--Australia. 1
65 Anti-fascist movements--Australia. 1
66 Courts--New South Wales--Sydney. 1
67 Cotton machinery--New South Wales 1
68 Cotton growing--New South Wales 1
69 Boxing--Australia. 1
70 Architects and builders--New South Wales--Sydney. 1
71 Antinuclear movement. 1
72 Aboriginal Australians--New South Wales. 1
73 Construction workers--Labor unions--New South Wales. 1
74 Conscientious objectors--New South Wales. 1
75 Authors, Australian--20th century. 1
76 Communists--Australia. 1
77 College students--New South Wales--Sydney--Political activity. 1
78 Ballet companies - Australia. 1
79 Boiler-makers--Labor unions--Australia. 1
80 Bus drivers--New South Wales 1
81 Boiler-makers--Labor unions--New South Wales--Sydney. 1
82 Break dancing--Australia. 1
83 Bookstores--New South Wales--Sydney. 1
84 Boycotts 1
85 Aboriginal Australians--New South Wales--Walgett. 1
86 athletes 1
87 Equal pay for equal work--Australia. 1
88 Gay rights--New South Wales. 1
89 Sheep ranches--New South Wales. 1
90 Ships--Maintenance and repair. 1
91 Socialists--New South Wales--Sydney. 1
92 Soldiers--New South Wales. 1
93 Sports--Australia. 1
94 Strikes and lockouts--Australia. 1
95 Student movements--New South Wales--Sydney. 1
96 Sydney Harbour (N.S.W.)--Pictorial works. 1
97 Sydney Harbour (N.S.W.). 1
98 Tennis--Australia. 1
99 Theaters--New South Wales--Sydney. 1
100 Toymakers 1
101 Trade-unions--Shipbuilding industry employees--New South Wales. 1
102 Universities and colleges--New South Wales--Sydney. 1
103 Vietnam War, 1961-1975 1
104 Vietnam War, 1961-1975--Mass media and the war 1
105 Vietnam War, 1961-1975--Pamphlets 1
106 Vietnam War, 1961-1975--Protest movements--Victoria. 1
107 Vietnamese--Australia 1
108 Women musicians--Australia. 1
109 Women's rights--Pictorial works. 1
110 Schools--New South Wales. 1
111 Schools--New South Wales--Sydney. 1
112 Running races--New South Wales--Sydney 1
113 Labor unions--Officials and employees. 1
114 Greeks--New South Wales--Sydney. 1
115 Hospitals--New South Wales. 1
116 Hotels--New South Wales--Watsons Bay. 1
117 Housing--New South Wales--Sydney. 1
118 International Women's Day--New South Wales--Sydney. 1
119 Labor movement--New South Wales. 1
120 Labor unions--Australia. 1
121 Labor unions--Congresses. 1
122 Women, Aboriginal Australian. 1
123 Land tenure--Australia. 1
124 Public housing--New South Wales. 1
125 Miners--Australia. 1
126 Musicians--20th century. 1
127 Newcastle (N.S.W.)--Pictorial works. 1
128 Nuclear disarmament--Congresses. 1
129 Old age pensions--Australia. 1
130 Photography--Negatives 1
131 Poetry--20th century. 1
132 Political parties--Australia. 1
133 Politicians--Australia. 1
134 Aboriginal Australians--Anniversaries. 1
In [23]:
# Save as a CSV file
subject_counts.to_csv('data/subject_counts.csv', index=False)
display(HTML('<a target="_blank" href="data/subject_counts.csv">Download subject_counts.csv</a>'))

Search for records with a particular subject

In [33]:
search_term = 'Pine Gap'
subjects_filtered = df.loc[df['subjects'].str.contains(search_term, case=False, na=False)].copy()
subjects_filtered
Out[33]:
series_number part_number item_number level title call_number object_number priref intellectual_entity date_string ... quantity url parent_url number_images images description subjects topics people places
1438 3 10.0 765 ITEM Item 0765: Tribune negatives including Pine Ga... ON 160/Item 0765 1051266 110370322 IE4438816 November 1983 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4438818|FL4438819|FL4438821|FL4438822|FL4438... Includes:|Pine Gap, November 1983 Demonstrations--Northern Territory--Pine Gap|A... demonstrations|activists NaN Pine Gap (N.T.)
1439 3 10.0 766 ITEM Item 0766: Tribune negatives including Pine Ga... ON 160/Item 0766 1051267 110370323 IE4436528 November 1983 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4436530|FL4436531|FL4436532|FL4436533|FL4436... Includes:|Pine Gap, November 1983 Demonstrations--Northern Territory--Pine Gap|A... demonstrations|activists NaN Pine Gap (N.T.)
1440 3 10.0 767 ITEM Item 0767: Tribune negatives including Pine Ga... ON 160/Item 0767 1051270 110370325 IE4433455 November 1983 ... 20 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 20 FL4433457|FL4433458|FL4433459|FL4433460|FL4433... Includes:|Pine Gap, November 1983 Demonstrations--Northern Territory--Pine Gap|A... demonstrations|women|activists NaN Pine Gap (N.T.)
1441 3 10.0 768 ITEM Item 0768: Tribune negatives including Pine Ga... ON 160/Item 0768 1051271 110370326 IE4441815 November 1983 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4441941|FL4441943|FL4441944|FL4441946|FL4441... Includes:|Pine Gap, November 1983 Demonstrations--Northern Territory--Pine Gap|A... demonstrations|women|activists NaN Pine Gap (N.T.)
1632 3 14.0 981 ITEM Item 0981: Tribune negatives including anti-nu... ON 160/Item 0981 1055331 110370670 IE4468784 October-December 1986 ... 41 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 41 FL4468848|FL4468849|FL4468850|FL4468851|FL4468... Includes:|Subversive fashion parade, December ... Antinuclear movement--Northern Territory--Pine... demonstrations|fashion parades|fashion models NaN NaN
1667 3 15.0 1017 ITEM Item 1017: Tribune negatives including Seaman'... ON 160/Item 1017 1055395 110370728 IE4476729 October 1987 ... 41 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 41 FL4476907|FL4476909|FL4476911|FL4476913|FL4476... Includes:|Pine Gap protests by Stephen Long, O... Antinuclear movement--Northern Territory--Pine... banners|trade unions|activists|demonstrations Long, Stephen NaN
1668 3 15.0 1018 ITEM Item 1018: Tribune negatives including anti-ba... ON 160/Item 1018 1055396 110370729 IE4478552 October 1987 ... 42 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 42 FL4478708|FL4478709|FL4478710|FL4478711|FL4478... Includes:|Street Theatre at Pine Gap, October ... Demonstrations--Northern Territory--Pine Gap|A... activists|demonstrations Long, Stephen NaN
1669 3 15.0 1019 ITEM Item 1019: Tribune negatives including anti-nu... ON 160/Item 1019 1055397 110370730 IE4481831 October 1987 ... 40 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 40 FL4481969|FL4481976|FL4481980|FL4481983|FL4481... Includes:|Pine Gap protests by Stephen Long, O... Antinuclear movement--Northern Territory--Pine... activists|demonstrations Long, Stephen NaN
1670 3 15.0 1020 ITEM Item 1020: Tribune negatives including anti-ba... ON 160/Item 1020 1055398 110370731 IE4480336 October 1987 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4480457|FL4480459|FL4480461|FL4480462|FL4480... Includes:|Pine Gap protests by Stephen Long (p... Antinuclear movement--Northern Territory--Pine... demonstrations|activists Long, Stephen NaN
1671 3 15.0 1021 ITEM Item 1021: Tribune negatives including anti-US... ON 160/Item 1021 1055400 110370733 IE4475820 October 1987 ... 38 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 38 FL4475945|FL4475948|FL4475950|FL4475953|FL4475... Includes:|Pine Gap protests by Stephen Long (p... Demonstrations--Northern Territory--Pine Gap|A... conventions|demonstrations|activists Long, Stephen NaN
1672 3 15.0 1022 ITEM Item 1022: Tribune negatives including anti-nu... ON 160/Item 1022 1055402 110370735 IE4477933 October 1987 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4478007|FL4478008|FL4478009|FL4478010|FL4478... Includes:|Pine Gap protests by Stephen Long (p... Antinuclear movement--Northern Territory--Pine... demonstrations|activists Long, Stephen NaN
1800 4 NaN 39 ITEM Item 039: Tribune negatives including protest ... ON 162/Item 039 1045907 110369890 IE4589248 198- ... 22 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 28 FL4589279|FL4589280|FL4589284|FL4589285|FL4589... Includes:|Speaker, possibly at anti-US bases m... Demonstrations--Northern Territory--Pine Gap demonstrations|rallies|musical events & activi... NaN NaN

12 rows × 22 columns

In [34]:
# Save as a CSV file
subjects_filtered.to_csv('data/subjects-search-{}.csv'.format(search_term), index=False)
display(HTML('<a target="_blank" href="data/subjects-search-{0}.csv">Download subjects-search-{0}.csv</a>'.format(search_term)))

Exploring people and organisations

Create a list of unique names and sort them alphabetically

In [15]:
# Get unique values
people = pd.unique(df['people'].str.split('|', expand=True).stack()).tolist()
for person in sorted(people):
    print(person)
2UW (Radio station : Sydney, N.S.W.)
Aarons, Brian, 1945-
Aarons, Eric
Aarons, Laurie, 1917-2005
Aboriginal Tent Embassy (Canberra, A.C.T.)
Actors and Announcers Equity Association of Australia
Affley, Declan, 1939-1985
Air New Zealand
Air-India
Amalgamated Engineering Union.
Amalgamated Engineering Union. Australian Section.
Amalgamated Metal Workers' Union (Australia)
Amalgamated Postal Workers' Union
Ampol Petroleum Limited
Anderson, Michael
Ansett Airlines of Australia
Anzac Day
Ashe, Arthur, 1943-
Australian Ballet
Australian Broadcasting Corporation
Australian Builders' Labourers' Federation
Australian Builders' Labourers' Federation. New South Wales Branch
Australian Council of Trade Unions
Australian Iron and Steel
Australian Journalists' Association
Australian Labor Party
Australian Labor Party. Kings Cross Branch
Australian Labor Party. New South Wales Branch. Conference. (1965 : Sydney, N.S.W.)
Australian Workers Union. New South Wales Branch
Bacon, Wendy.
Bandler, Faith, 1918-2015
Beazley, Kim C. (Kim Christian), 1948-
Bennett, J. M.
Berry, John
Binge, Stanley
Blackshield, A. R. (Anthony Roland), 1937-
Boilermakers' and Blacksmiths' Society of Australia
Boilermakers' and Blacksmiths' Society of Australia. Sydney Branch
Boonaroo (cargo ship)
Boyd, David
Bradford, Colin
Bridges, Harry, 1901-
Briggs, Geraldine, 1910-2005
Briscoe, Gordon, 1938-
Broken Hill Proprietary Company
Brown, Billy
Brown, Peter
Building Workers Industrial Union
Building Workers' Industrial Union of Australia.
Burchett, Wilfred, 1911-1983
Burns, Philp & Company
Bush, Jennifer, 1942-
Butterworth, John
Cahill, J J (Mrs)
Cain, Jacqueline
Cairns, Jim, 1914-2003
Calwell, Arthur A. (Arthur Augustus), 1896-1973
Carmichael, Laurie
Cawley, Evonne, 1951-
Clancy, Pat, 1919-1987
Clark, Manning, 1915-1991
Cluff, Flo, 1902-1990
Clyde Engineering Co. Ltd.
Colgate-Palmolive Pty. Ltd.
Committee Against Atomic Testing (N.S.W.)
Commonwealth Engineering Co.
Communist Party of Australia
Coorey, Anthony Morris, 1925-1981
Cornwall (Ship)
Counihan, Noel, 1913-1986
Craigie, Billy
Cranbrook School (Bellevue Hill, N.S.W.)
Curthoys, Ann, 1945-
Cuthbert, Betty, 1938-
Daly, Fred, 1913-1995
Dee Why Surf Life Saving Club (N.S.W.)
Dixon, Chicka (Charles), 1928-2010
Dixon, Dean
Dixon, R. (Reginald)
Dougherty, Chris
Ducker, John
Dunnett, Brian, 1943-
Dunphy, Milo
Durbridge, Robert Stuart, 1946-2014
Electrical Trades Union (NSW Branch)
Elizabeth II, Queen of Great Britain, 1926-
Elliott, Eliot Valens, 1902-1984
Elphinston, Alex, 1913-1994
Eureka Youth League (Australia)
Evans, Michael
Fairbairn, Geoffrey (Geoffrey Forrester), 1924-1980
Federal Council for the Advancement of Aborigines and Torres Strait Islanders
Federated Ironworkers' Association of Australia
Federated Miscellaneous Workers' Union of Australia
Fields, Ted, 1933-2006
Fitzgibbon, Charlie, 1922-2001
Foley, Gary
Ford Motor Company of Australia
Franco, Francisco, 1892-1975
Fraser, Malcolm, 1930-
Freney, Denis
Funde, Eddie
Gallagher, Bob
Gandhi, Indira, 1917-1984
Garrett, Peter, 1953-
General Motors-Holden's Limited.
General Post Office (Sydney, N.S.W.)
George, Paddy
Gibson, Ralph, 1906-
Gifford, Charlie
Gilling, Bridget
Goldbloom, Sam
Gorham, Kathleen, 1932-1983
Gould, Bob, 1937-
Great Moscow Circus
Greenland, Hall
Gurindji (Australian people).
Haddrick, Ron
Hall, Harry, 1924-2013
Hammond, Heather
Hampson, Miriam
Hardy, Frank (Francis Joseph), 1917-1994
Hawke, Bob, 1929-
Haylen, Leslie
Hazard, Noel
Healy, Jim, 1898-1961
Healy, Patricia
Heffernan, Jack, 1916-
Higham, Louise
Ho Chi Minh, 1890-1969
Hobson, Albert
Holt, Harold, 1908-1967
Honeywell Ltd.
Hughes, T. E. F. (Thomas Eyre Forrest), 1923-
International Women's Day
Irish National Association of Australasia
James, Francis, 1918-1992
Jeanne d'Arc (French warship)
Jensen, Henry Frederick, 1913-
Jeparit (cargo ship)
Jim Endersby
Johnson, Les
Johnson, Lyndon Baines, 1908-1973.
Johnston, Elliott, 1918-2011
Jones, Michael
Kelly, J. H. (John Henry), 1895-1983
Kevans, Denis, 1939-2005
Ky, Prime Minister
Labor Council of New South Wales
Lenin, Vladimir Ilich, 1870-1924.
Leon, Charles (Lester), 1900-1982
Leppik, Raymond
Lewis, Jeannie.
Liberal Party of Australia.
Lockwood, Rupert, 1908-1997
Long, Stephen
Mackay, Norm
Mackie, Pat, 1914-2009
Malaita (ship)
Mandela, Nelson, 1918-
Maritime Services Board of New South Wales
Marks, Jack
Marrickville Margarine Ltd.
Mason, Gerry
Master Builders' Association of N.S.W.
Matteson, Michael
May Day
Mayers, Naomi, 1941-
Mayne Nickless Ltd.
Maza, Bob.
McCrae, Nita
McGuinness, Sandra
McIntosh, Carlotta
McLean, D.
McLean, Jean
McMahon, William, 1908-1988
McPhillips, L. J.
Meals On Wheels
Menzies, Robert, Sir, 1894-1978
Metal Trades Federation of Unions (Australia)
Miles, John Bramwell
Milliss, Roger, 1934-
Miners' Federation
Morcom, Elfrida
Moresby (naval survey vessel)
Morris, Bruce
Moyes, Bishop
Moyes, John Stoward, 1884-1972
Mundey, Jack, 1932-
Mundey, Judith Ann, 1944-
Munro, Julie
Munro, Matt, 1906-1980
Murphy, Lionel, 1922-1986
Murphy, Peter
N.S.W. Teachers' Federation
National Aborigines' Day (1965)
National Socialist Party of Australia
Neos kosmos (Melbourne, Vic.)
New South Wales Nurses' Association
New South Wales. Parliament
New Theatre (Sydney, N.S.W.)
Newfong, John, 1943-1999
Nixon, Richard M. (Richard Milhous), 1913-1994
Noffs, Ted, 1926-1995
O'Brien, Michael, 1900–1967
Ormonde, James Patrick, 1905-
Osipov (orchestra)
Outhred, Alan
Paine, Thomas, 1737-1809
Pan Am
Paterson, Fred, 1897-1977
Peckham, Ray
Perkins, Charles, 1936-2000
Peters Ice Cream Ltd.
Petty, Bruce, 1929-
Philip, Prince, consort of Elizabeth II, Queen of Great Britain, 1921-
Prasad, Nancy
Pringle, Robert Arthur, 1922-1996
Printing and Kindred Industries Union
Proclaim (ferry)
Qantas Airways
Ray Brown and the Whispers (musical group)
Reeves, Sue
Regan, Lyn
Regent Theatre (Sydney, N.S.W.)
Rigby, William Matthew, 1923-2003
Roach, Edward Charles, 1909-1997
Roberts, Frank, 1918-1992
Robertson, Alec, 1918-1974
Rose, Frederick G. G. (Frederick George Godfrey), 1915-1991
Ross, Edgar, 1904-2001
Ross, Lloyd (Lloyd Maxwell), 1901-1987
Royal Easter Show (1967 : Sydney, N.S.W.)
Royal Prince Alfred Hospital (Sydney, N.S.W.)
Rubbo, Sydney D.
Salmon, Malcolm, 1925-1986
Saragat, Giuseppe
Save Our Sons Movement
Scots College (Bellevue Hill, N.S.W.)
Seamen's Union of Australia
Searle, Betty
Sharkey, L. L. (Lawrence Louis), 1898-1967
Shearston, Gary, 1939-2013
Sheet Metal Workers Union of Australia
Sinclair, Ian McCahon, 1929-
Smith, Ronald
Smith, Shirley Coleen, 1924-1998
Sobers, Garry, 1936-
St. George Dragons (Rugby team)
Stanley, Alexander, 1895-1968
Stein, Harry
Stolle, Fred
Student Action for Aborigines (N.S.W.)
Sydney Harbour Bridge (Sydney, N.S.W.)
Sydney Hospital
Sydney Opera House
Sydney Steel Co. Ltd.
Sydney Technical College
Sydney Town Hall
Sydney Trade Fair, (3rd : 1965 : Sydney, N.S.W.)
Sydney Wharf Labourers' Union
Sykes, Roberta B., 1943-2010
Thornton, Ernie
Tivoli Theatre (Sydney, N.S.W.)
Tooheys Ltd.
Tooth & Co.
Townsend, Simon
Trans Australia Airlines
Transport Workers Union of Australia. New South Wales Branch
Transport Workers' Union of Australia
Tribune (Newspaper)
Tricolor (ship)
Union of Australian Women
United Nations.
United States. Consulate (Sydney, N.S.W.)
University of Sydney
Uren, Tom
Utzon, Jorn, 1918-2008
Victor Schoelcher (French warship)
Vietnam Moratorium Campaign (Australia)
Wakelin, Roland, 1887-1971
Walker, Alan, 1911-2003
Waratah Spring Festival (1967 : Sydney, N.S.W.)
Waterside Workers' Federation of Australia
Waterside Workers' Federation of Australia. Sydney Branch
Watson, Sam, 1952-
Watt, Alf
Wentworth, W. C. (William Charles), 1907-2003.
Wheelwright, E. L. (Edward Lawrence)
White, Bill
White, William Phillip Orrick
Whitlam, Edward Gough
Whitlam, Gough, 1916-2014
Williams, Bert
Women's Liberation (Sydney, N.S.W.)
Wood, Bill, 1911-1976
Woolworths Ltd.
Wran, Neville, 1926-2014
Wyner, Issy
Yevtushenko, Yevgeny Aleksandrovich, 1933-
Young Socialists
Youth Campaign Against Conscription.
In [20]:
# Save as a CSV file
people_df = pd.DataFrame(people)
people_df.columns = ['people']
people_df.to_csv('data/people.csv', index=False)
display(HTML('<a target="_blank" href="data/people.csv">Download people.csv</a>'))

How often is each name used?

In [24]:
# Splits the people column and counts frequencies
people_counts = df['people'].str.split('|').apply(lambda x: pd.Series(x).value_counts()).sum().astype('int').sort_values(ascending=False).to_frame().reset_index(level=0)
# Add column names
people_counts.columns = ['name', 'count']
# Display with horizontal bars
display(people_counts.style.bar(subset=['count'], color='#d65f5f').set_properties(subset=['count'], **{'width': '300px'}))
name count
0 Murphy, Peter 23
1 Waterside Workers' Federation of Australia 17
2 Tribune (Newspaper) 16
3 Building Workers' Industrial Union of Australia. 14
4 University of Sydney 14
5 McIntosh, Carlotta 14
6 Communist Party of Australia 13
7 Union of Australian Women 12
8 New Theatre (Sydney, N.S.W.) 12
9 Australian Builders' Labourers' Federation 12
10 Aarons, Laurie, 1917-2005 9
11 Townsend, Simon 9
12 Salmon, Malcolm, 1925-1986 8
13 Australian Labor Party 8
14 Whitlam, Gough, 1916-2014 8
15 Aboriginal Tent Embassy (Canberra, A.C.T.) 7
16 Australian Journalists' Association 7
17 Mundey, Judith Ann, 1944- 7
18 Australian Council of Trade Unions 7
19 N.S.W. Teachers' Federation 7
20 Sydney Town Hall 7
21 Boilermakers' and Blacksmiths' Society of Australia 6
22 Liberal Party of Australia. 6
23 Gould, Bob, 1937- 6
24 Long, Stephen 6
25 May Day 5
26 Evans, Michael 5
27 Sydney Opera House 5
28 Anderson, Michael 5
29 Save Our Sons Movement 5
30 Holt, Harold, 1908-1967 5
31 Cairns, Jim, 1914-2003 5
32 Wheelwright, E. L. (Edward Lawrence) 5
33 Hawke, Bob, 1929- 4
34 Dixon, Chicka (Charles), 1928-2010 4
35 Eureka Youth League (Australia) 4
36 Clancy, Pat, 1919-1987 4
37 Calwell, Arthur A. (Arthur Augustus), 1896-1973 4
38 Jim Endersby 4
39 Master Builders' Association of N.S.W. 4
40 Murphy, Lionel, 1922-1986 3
41 Yevtushenko, Yevgeny Aleksandrovich, 1933- 3
42 Ross, Lloyd (Lloyd Maxwell), 1901-1987 3
43 Great Moscow Circus 3
44 Qantas Airways 3
45 Greenland, Hall 3
46 Sharkey, L. L. (Lawrence Louis), 1898-1967 3
47 Federal Council for the Advancement of Aborigines and Torres Strait Islanders 3
48 Gurindji (Australian people). 3
49 Hall, Harry, 1924-2013 3
50 Ducker, John 3
51 General Motors-Holden's Limited. 3
52 Uren, Tom 3
53 Carmichael, Laurie 3
54 Building Workers Industrial Union 3
55 McGuinness, Sandra 3
56 Watt, Alf 3
57 Transport Workers' Union of Australia 3
58 Transport Workers Union of Australia. New South Wales Branch 3
59 Metal Trades Federation of Unions (Australia) 3
60 Johnson, Lyndon Baines, 1908-1973. 3
61 Student Action for Aborigines (N.S.W.) 3
62 Milliss, Roger, 1934- 2
63 James, Francis, 1918-1992 2
64 International Women's Day 2
65 McLean, D. 2
66 Higham, Louise 2
67 Ky, Prime Minister 2
68 Honeywell Ltd. 2
69 Kevans, Denis, 1939-2005 2
70 Mason, Gerry 2
71 Miners' Federation 2
72 Jensen, Henry Frederick, 1913- 2
73 Menzies, Robert, Sir, 1894-1978 2
74 Jeparit (cargo ship) 2
75 Mundey, Jack, 1932- 2
76 Youth Campaign Against Conscription. 2
77 Gilling, Bridget 2
78 George, Paddy 2
79 Aarons, Brian, 1945- 2
80 Aarons, Eric 2
81 Amalgamated Engineering Union. 2
82 Amalgamated Metal Workers' Union (Australia) 2
83 Amalgamated Postal Workers' Union 2
84 Ansett Airlines of Australia 2
85 Australian Broadcasting Corporation 2
86 Australian Iron and Steel 2
87 Australian Labor Party. Kings Cross Branch 2
88 Berry, John 2
89 Boilermakers' and Blacksmiths' Society of Australia. Sydney Branch 2
90 Bridges, Harry, 1901- 2
91 Briscoe, Gordon, 1938- 2
92 Brown, Peter 2
93 Cahill, J J (Mrs) 2
94 Cluff, Flo, 1902-1990 2
95 Clyde Engineering Co. Ltd. 2
96 Commonwealth Engineering Co. 2
97 Counihan, Noel, 1913-1986 2
98 Craigie, Billy 2
99 Durbridge, Robert Stuart, 1946-2014 2
100 Elphinston, Alex, 1913-1994 2
101 Fields, Ted, 1933-2006 2
102 Fraser, Malcolm, 1930- 2
103 Freney, Denis 2
104 Dee Why Surf Life Saving Club (N.S.W.) 2
105 Leon, Charles (Lester), 1900-1982 2
106 Roberts, Frank, 1918-1992 2
107 Sykes, Roberta B., 1943-2010 2
108 Rubbo, Sydney D. 2
109 Royal Prince Alfred Hospital (Sydney, N.S.W.) 2
110 Printing and Kindred Industries Union 2
111 Ross, Edgar, 1904-2001 2
112 Stein, Harry 2
113 Regent Theatre (Sydney, N.S.W.) 2
114 Women's Liberation (Sydney, N.S.W.) 2
115 Watson, Sam, 1952- 2
116 Seamen's Union of Australia 2
117 National Socialist Party of Australia 2
118 Robertson, Alec, 1918-1974 2
119 Reeves, Sue 2
120 New South Wales. Parliament 2
121 Paterson, Fred, 1897-1977 2
122 Tivoli Theatre (Sydney, N.S.W.) 2
123 Sydney Harbour Bridge (Sydney, N.S.W.) 2
124 Neos kosmos (Melbourne, Vic.) 2
125 Perkins, Charles, 1936-2000 2
126 Sydney Hospital 1
127 Committee Against Atomic Testing (N.S.W.) 1
128 National Aborigines' Day (1965) 1
129 Colgate-Palmolive Pty. Ltd. 1
130 Sydney Steel Co. Ltd. 1
131 Sydney Technical College 1
132 Coorey, Anthony Morris, 1925-1981 1
133 Sydney Trade Fair, (3rd : 1965 : Sydney, N.S.W.) 1
134 Cawley, Evonne, 1951- 1
135 Sydney Wharf Labourers' Union 1
136 Thornton, Ernie 1
137 Cain, Jacqueline 1
138 Butterworth, John 1
139 Clark, Manning, 1915-1991 1
140 Cranbrook School (Bellevue Hill, N.S.W.) 1
141 Cornwall (Ship) 1
142 Stolle, Fred 1
143 Sinclair, Ian McCahon, 1929- 1
144 Smith, Ronald 1
145 Elliott, Eliot Valens, 1902-1984 1
146 Elizabeth II, Queen of Great Britain, 1926- 1
147 Electrical Trades Union (NSW Branch) 1
148 Smith, Shirley Coleen, 1924-1998 1
149 Dunphy, Milo 1
150 Dunnett, Brian, 1943- 1
151 Sobers, Garry, 1936- 1
152 Dougherty, Chris 1
153 Dixon, R. (Reginald) 1
154 Dixon, Dean 1
155 St. George Dragons (Rugby team) 1
156 Stanley, Alexander, 1895-1968 1
157 Daly, Fred, 1913-1995 1
158 Cuthbert, Betty, 1938- 1
159 Curthoys, Ann, 1945- 1
160 Bush, Jennifer, 1942- 1
161 Tooth & Co. 1
162 Burns, Philp & Company 1
163 Wakelin, Roland, 1887-1971 1
164 Waratah Spring Festival (1967 : Sydney, N.S.W.) 1
165 Waterside Workers' Federation of Australia. Sydney Branch 1
166 Australian Builders' Labourers' Federation. New South Wales Branch 1
167 Wentworth, W. C. (William Charles), 1907-2003. 1
168 Australian Ballet 1
169 Ashe, Arthur, 1943- 1
170 Anzac Day 1
171 White, Bill 1
172 White, William Phillip Orrick 1
173 Ampol Petroleum Limited 1
174 Whitlam, Edward Gough 1
175 Williams, Bert 1
176 Amalgamated Engineering Union. Australian Section. 1
177 Air-India 1
178 Air New Zealand 1
179 Affley, Declan, 1939-1985 1
180 Actors and Announcers Equity Association of Australia 1
181 Wood, Bill, 1911-1976 1
182 Woolworths Ltd. 1
183 Wran, Neville, 1926-2014 1
184 Wyner, Issy 1
185 Walker, Alan, 1911-2003 1
186 Vietnam Moratorium Campaign (Australia) 1
187 Burchett, Wilfred, 1911-1983 1
188 Australian Labor Party. New South Wales Branch. Conference. (1965 : Sydney, N.S.W.) 1
189 Tooheys Ltd. 1
190 Fairbairn, Geoffrey (Geoffrey Forrester), 1924-1980 1
191 Trans Australia Airlines 1
192 Brown, Billy 1
193 Broken Hill Proprietary Company 1
194 Tricolor (ship) 1
195 Briggs, Geraldine, 1910-2005 1
196 United Nations. 1
197 Bradford, Colin 1
198 Boyd, David 1
199 Boonaroo (cargo ship) 1
200 United States. Consulate (Sydney, N.S.W.) 1
201 Utzon, Jorn, 1918-2008 1
202 Blackshield, A. R. (Anthony Roland), 1937- 1
203 Binge, Stanley 1
204 Victor Schoelcher (French warship) 1
205 Bennett, J. M. 1
206 Beazley, Kim C. (Kim Christian), 1948- 1
207 Bandler, Faith, 1918-2015 1
208 Bacon, Wendy. 1
209 Australian Workers Union. New South Wales Branch 1
210 Sheet Metal Workers Union of Australia 1
211 Ford Motor Company of Australia 1
212 Shearston, Gary, 1939-2013 1
213 McCrae, Nita 1
214 Mayne Nickless Ltd. 1
215 Mayers, Naomi, 1941- 1
216 Pan Am 1
217 Matteson, Michael 1
218 Peckham, Ray 1
219 Marrickville Margarine Ltd. 1
220 Marks, Jack 1
221 Maritime Services Board of New South Wales 1
222 Mandela, Nelson, 1918- 1
223 Malaita (ship) 1
224 Mackie, Pat, 1914-2009 1
225 Mackay, Norm 1
226 Lockwood, Rupert, 1908-1997 1
227 Peters Ice Cream Ltd. 1
228 Lewis, Jeannie. 1
229 Leppik, Raymond 1
230 Young Socialists 1
231 Lenin, Vladimir Ilich, 1870-1924. 1
232 Labor Council of New South Wales 1
233 Maza, Bob. 1
234 Paine, Thomas, 1737-1809 1
235 Federated Ironworkers' Association of Australia 1
236 Outhred, Alan 1
237 New South Wales Nurses' Association 1
238 Munro, Matt, 1906-1980 1
239 Munro, Julie 1
240 Newfong, John, 1943-1999 1
241 Moyes, John Stoward, 1884-1972 1
242 Moyes, Bishop 1
243 Morris, Bruce 1
244 Moresby (naval survey vessel) 1
245 Morcom, Elfrida 1
246 Nixon, Richard M. (Richard Milhous), 1913-1994 1
247 Noffs, Ted, 1926-1995 1
248 Miles, John Bramwell 1
249 O'Brien, Michael, 1900–1967 1
250 Ormonde, James Patrick, 1905- 1
251 Meals On Wheels 1
252 McPhillips, L. J. 1
253 McMahon, William, 1908-1988 1
254 McLean, Jean 1
255 Osipov (orchestra) 1
256 Petty, Bruce, 1929- 1
257 Philip, Prince, consort of Elizabeth II, Queen of Great Britain, 1921- 1
258 Kelly, J. H. (John Henry), 1895-1983 1
259 Jones, Michael 1
260 Haddrick, Ron 1
261 Rose, Frederick G. G. (Frederick George Godfrey), 1915-1991 1
262 Royal Easter Show (1967 : Sydney, N.S.W.) 1
263 Gorham, Kathleen, 1932-1983 1
264 Goldbloom, Sam 1
265 Gifford, Charlie 1
266 Gibson, Ralph, 1906- 1
267 General Post Office (Sydney, N.S.W.) 1
268 Saragat, Giuseppe 1
269 Garrett, Peter, 1953- 1
270 Gandhi, Indira, 1917-1984 1
271 Gallagher, Bob 1
272 Funde, Eddie 1
273 Scots College (Bellevue Hill, N.S.W.) 1
274 Franco, Francisco, 1892-1975 1
275 Foley, Gary 1
276 Fitzgibbon, Charlie, 1922-2001 1
277 Searle, Betty 1
278 Federated Miscellaneous Workers' Union of Australia 1
279 Hammond, Heather 1
280 Hampson, Miriam 1
281 Hardy, Frank (Francis Joseph), 1917-1994 1
282 Hughes, T. E. F. (Thomas Eyre Forrest), 1923- 1
283 Johnston, Elliott, 1918-2011 1
284 Prasad, Nancy 1
285 Johnson, Les 1
286 Pringle, Robert Arthur, 1922-1996 1
287 Proclaim (ferry) 1
288 Jeanne d'Arc (French warship) 1
289 Ray Brown and the Whispers (musical group) 1
290 Irish National Association of Australasia 1
291 Regan, Lyn 1
292 Roach, Edward Charles, 1909-1997 1
293 Hobson, Albert 1
294 Ho Chi Minh, 1890-1969 1
295 Rigby, William Matthew, 1923-2003 1
296 Heffernan, Jack, 1916- 1
297 Healy, Patricia 1
298 Healy, Jim, 1898-1961 1
299 Hazard, Noel 1
300 Haylen, Leslie 1
301 2UW (Radio station : Sydney, N.S.W.) 1
In [25]:
# Save as a CSV file
people_counts.to_csv('data/people_counts.csv', index=False)
display(HTML('<a target="_blank" href="data/people_counts.csv">Download people_counts.csv</a>'))

Search for names

In [31]:
search_term = 'union'
people_filtered = df.loc[df['people'].str.contains(search_term, case=False, na=False)].copy()
people_filtered
Out[31]:
series_number part_number item_number level title call_number object_number priref intellectual_entity date_string ... quantity url parent_url number_images images description subjects topics people places
8 1 1.0 9 ITEM Item 009: Tribune negatives including Transpor... ON 161/Item 009 1046110 110370028 IE4516853 1965 ... 29 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 29 FL4516855|FL4516857|FL4516860|FL4516861|FL4516... Original negative sleeve annotated Nos. 1-9 Tr... Labor unions--New South Wales--Sydney. trade unionists|meetings|window displays|toys|... Transport Workers Union of Australia. New Sout... Sydney Stadium (Rushcutters Bay, N.S.W.)
13 1 1.0 18 ITEM Item 018: Tribune negatives including Transpor... ON 161/Item 018 1046129 110370045 IE4515453 1964 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4515455|FL4515456|FL4515457|FL4515458|FL4515... Original negative sleeve titled No. 18 Sydney,... Transport workers--Labor unions--New South Wal... trade unionists|trade union officials|crowds|m... Transport Workers Union of Australia. New Sout... Wentworth Park (Sydney, N.S.W.)
14 1 1.0 19 ITEM Item 019: Tribune negatives including price ri... ON 161/Item 019 1046130 110370046 IE4517342 1964-1965 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4517344|FL4517349|FL4517350|FL4517351|FL4517... Original negative sleeve titled No. 19 Late 19... NaN petitions|Tongans|conventions|houses|residenti... Union of Australian Women|Australian Labor Par... Sydney Town Hall (Sydney, N.S.W.)
16 1 1.0 21 ITEM Item 021: Tribune negatives including Building... ON 161/Item 021 1048213 110370049 IE4516206 1964 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4516208|FL4516210|FL4516211|FL4516212|FL4516... Original negative sleeve titled No. 21 Late 19... Labor unions--New South Wales--Sydney. running races|children|union picnics|games|tug... Building Workers' Industrial Union of Australia. Gunnamatta Bay (N.S.W.)
38 1 1.0 47 ITEM Item 047: Tribune negatives including Building... ON 161/Item 047 1051083 110370227 IE4519410 August 1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4519412|FL4519414|FL4519415|FL4519417|FL4519... Includes:|Preach-In at State Theatre : A. Walk... Labor unions--New South Wales. musicians|audiences|ministers of religion|conv... Building Workers' Industrial Union of Australi... NaN
42 1 2.0 51 ITEM Item 051: Tribune negatives including Amalgama... ON 161/Item 051 1046086 110370011 IE4516396 July-August 1965 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4516398|FL4516403|FL4516406|FL4516410|FL4516... Original negative sleeve titled No. 51 Betty C... Labor unions--Australia--Officials and employees. receptions|trade unions|trade union officials|... Cuthbert, Betty, 1938-|Jensen, Henry Frederick... NaN
45 1 2.0 54 ITEM Item 054: Tribune negatives including Transpor... ON 161/Item 054 1051208 110370289 IE4519081 August 1965 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4519083|FL4519089|FL4519091|FL4519092|FL4519... Includes:|Buses at Waverley Depot ; Driver and... Labor unions--Australia--Officials and employe... trade unionists|bus drivers|bus conductors|bus... Mackie, Pat, 1914-2009|Transport Workers' Unio... Waverley Bus Depot (Oxford Street, Bondi Junct...
47 1 2.0 56 ITEM Item 056: Tribune negatives including Printing... ON 161/Item 056 1051264 110370320 IE4516178 13-14 September 1965 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4516180|FL4516181|FL4516182|FL4516183|FL4516... Includes:|PKIU [Printing & Kindred Industries ... Australian Council of Trade Unions--Congresses... audiences|conventions|meetings|demonstrations|... Printing and Kindred Industries Union|Australi... Sydney Town Hall (Sydney, N.S.W.)|George Stree...
48 1 2.0 57 ITEM Item 057: Tribune negatives including ships Bi... ON 161/Item 057 1053683 110370339 IE4518558 August-September 1965 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4518560|FL4518561|FL4518562|FL4518563|FL4518... Includes:|TWU [Transport Workers' Union] meeti... Labor unions -- New South Wales -- Officials a... ships|jetties & wharves|trade unionists|meetin... Tricolor (ship)|Cornwall (Ship)|Transport Work... Moore Park (Sydney, N.S.W.)
51 1 2.0 60 ITEM Item 060: Tribune negatives including portrait... ON 161/Item 060 1054477 110370368 IE4517979 November 1965 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4517981|FL4517985|FL4517986|FL4517987|FL4517... Includes:|Elfrida Morcom, 5 November 1965, Row... Transport workers--Labor unions--New South Wal... portraits|meetings|trade unionists Morcom, Elfrida|Aarons, Laurie, 1917-2005|Wood... NaN
63 1 2.0 76 ITEM Item 076: Tribune negatives including Peace Wo... ON 161/Item 076 1055026 110370458 IE4520456 October-November 1965 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4520458|FL4520459|FL4520460|FL4520461|FL4520... Includes:|Demo at Central Court regarding 51 a... Demonstrations--New South Wales--Sydney.|Vietn... meetings|audiences|judo|toys|conventions|poste... Hall, Harry, 1924-2013|Wheelwright, E. L. (Edw... Central Police Court (Liverpool Street, Sydney...
105 1 3.0 123 ITEM Item 123: Tribune negatives including a wages ... ON 161/Item 123 1260027 110373948 IE4523781 May 1966 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4523783|FL4523784|FL4523786|FL4523787|FL4523... Original negative sleeve titled Basic wages ra... Demonstrations--New South Wales--Sydney.|Vietn... demonstrations|politicians|rallies|wages Calwell, Arthur A. (Arthur Augustus), 1896-197... Wynyard Park (Sydney, N.S.W.)|Balmain Town Hal...
126 1 3.0 147 ITEM Item 147: Tribune negatives including Seamen's... ON 161/Item 147 1261269 110374022 IE4530831 19-25 August 1966 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4530833|FL4530836|FL4530837|FL4530838|FL4530... Original negative sleeve titled: Seamens union... NaN trade unionists|meetings|folk dancing Seamen's Union of Australia Botany Bay (N.S.W.)
167 1 4.0 188 ITEM Item 188: Tribune negatives including Gough Wh... ON 161/Item 188 1269564 110374105 IE4531361 17-20 March 1967 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4531363|FL4531366|FL4531367|FL4531369|FL4531... Original negative sleeve titled: More of Gough... NaN meetings|trade unionists Whitlam, Gough, 1916-2014|Metal Trades Federat... NaN
172 1 4.0 193 ITEM Item 193: Tribune negatives including May Quee... ON 161/Item 193 1287041 110374127 IE4536593 March-April 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4536595|FL4536597|FL4536599|FL4536602|FL4536... Original negative sleeve titled: Ted Wheelwrig... NaN trade unionists|industrial workers|women Wheelwright, E. L. (Edward Lawrence)|Sheet Met... NaN
179 1 5.0 205 ITEM Item 205: Tribune negatives including Osipov o... ON 161/Item 205 1287049 110374135 IE4536140 April-May 1967 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4536142|FL4536150|FL4536152|FL4536153|FL4536... Original negative sleeve titled: 16-5-67.|Incl... NaN puppeteers|puppets|musicians|art exhibitions|l... Union of Australian Women|Osipov (orchestra) NaN
183 1 5.0 209 ITEM Item 209: Tribune negatives including BWIU, Pl... ON 161/Item 209 1288300 110374156 IE4531492 9-21 May 1967 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4531494|FL4531503|FL4531504|FL4531506|FL4531... Original negative sleeve titled: Amalgamation ... NaN meetings|trade unions|trade unionists Building Workers' Industrial Union of Australia. NaN
184 1 5.0 210 ITEM Item 210: Tribune negatives including BWIU, Pl... ON 161/Item 210 1288303 110374157 IE4535457 21 May 1967 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4535459|FL4535466|FL4535467|FL4535468|FL4535... Original negative sleeve titled: Amalgamation ... NaN meetings|trade unions|trade unionists Building Workers' Industrial Union of Australia. NaN
190 1 5.0 216 ITEM Item 216: Tribune negatives including 21st Con... ON 161/Item 216 1288310 110374163 IE4533545 2-12 June 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4533547|FL4533556|FL4533559|FL4533562|FL4533... Original negative sleeve titled: 2, 8, 12/6/67... NaN meetings|demonstrations|hospitals Union of Australian Women|Communist Party of A... NaN
198 1 5.0 224 ITEM Item 224: Tribune negatives including Transpor... ON 161/Item 224 1290402 110374180 IE4531700 28 June 1967 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4531702|FL4531703|FL4531704|FL4531705|FL4531... Original negative sleeve titled: 28/6/67.|Incl... NaN meetings|trade unionists Transport Workers Union of Australia. New Sout... NaN
199 1 5.0 225 ITEM Item 225: Tribune negatives including a Liquor... ON 161/Item 225 1290405 110374181 IE4533268 30 June and 1 July 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4533270|FL4533274|FL4533275|FL4533277|FL4533... Original negative sleeve titled: 30-6, 1-7/67|... NaN meetings|trade unionists Amalgamated Postal Workers' Union Trocadero (George Street, Sydney, N.S.W.)
201 1 5.0 227 ITEM Item 227: Tribune negatives including the open... ON 161/Item 227 1290413 110374187 IE4533231 5-7 July 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4533233|FL4533236|FL4533237|FL4533239|FL4533... Original negative sleeve titled: 7-7-67.|Inclu... NaN meetings|youth hostels|wages Tribune (Newspaper)|Building Workers' Industri... NaN
202 1 5.0 228 ITEM Item 228: Tribune negatives including BWIU New... ON 161/Item 228 1290415 110374189 IE4535240 10-12 July 1967 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4535242|FL4535247|FL4535248|FL4535250|FL4535... Original negative sleeve titled: 10,12/7/67.|O... NaN meetings|trade unionists Building Workers' Industrial Union of Australia. NaN
203 1 5.0 229 ITEM Item 229: Tribune negatives including BWIU New... ON 161/Item 229 1290416 110374190 IE4532147 10-14 July 1967 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4532149|FL4532152|FL4532154|FL4532155|FL4532... Original negative sleeve titled: 10,12,14/7/67... NaN meetings|wharf labourers|anniversaries|houses|... Building Workers' Industrial Union of Australi... NaN
206 1 5.0 232 ITEM Item 232: Tribune negatives including Electric... ON 161/Item 232 1290429 110374198 IE4532582 25-26 July 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4532584|FL4532587|FL4532589|FL4532592|FL4532... Original negative sleeve titled: 25-7-67.|Incl... NaN meetings|demonstrations|posters & placards|tra... Electrical Trades Union (NSW Branch) NaN
219 1 5.0 245 ITEM Item 245: Tribune negatives including UAW Save... ON 161/Item 245 1290874 110374258 IE4535869 21-22 August 1967 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4535871|FL4535876|FL4535877|FL4535878|FL4535... Original negative sleeve titled: 21,22/8/67.|I... NaN demonstrations|meetings|nurses|wages|theatrica... Union of Australian Women|New Theatre (Sydney,... NaN
237 1 6.0 263 ITEM Item 263: Tribune negatives including Bellfiel... ON 161/Item 263 1296799 110374492 IE4548223 1-20 October 1967 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4548225|FL4548230|FL4548232|FL4548234|FL4548... Original negative sleeve titled: 14-20/10/67.|... NaN conventions|demonstrations|observatories|teles... Amalgamated Engineering Union.|Save Our Sons M... NaN
247 1 6.0 273 ITEM Item 273: Tribune negatives including Evonne G... ON 161/Item 273 1296836 110374505 IE4546942 November 1967 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4546944|FL4546946|FL4546948|FL4546950|FL4546... Includes:|Evonne Goolagong at the New South Wa... NaN anniversaries|tennis|elections Cawley, Evonne, 1951-|Union of Australian Women NaN
248 1 6.0 274 ITEM Item 274: Tribune negatives including UAW func... ON 161/Item 274 1296837 110374506 IE4549408 November 1967 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4549410|FL4549411|FL4549412|FL4549413|FL4549... Includes:|Union of Australian Women function a... NaN anniversaries|women|breweries|meetings Union of Australian Women|Tooth & Co.|Tooheys ... NaN
251 1 6.0 277 ITEM Item 277: Tribune negatives including UAW demo... ON 161/Item 277 1302365 110374528 IE4590226 December 1967 ... 22 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 29 FL4590288|FL4590289|FL4590290|FL4590291|FL4590... Includes:|Peter Barry's art exhibition at the ... NaN demonstrations|art exhibitions Union of Australian Women NaN
252 1 6.0 278 ITEM Item 278: Tribune negatives including UAW demo... ON 161/Item 278 1302367 110374529 IE4549244 December 1967 ... 24 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4549246|FL4549249|FL4549252|FL4549254|FL4549... Includes:|Portrait photographs of unidentified... NaN demonstrations|men Union of Australian Women NaN
255 1 6.0 281 ITEM Item 281: Tribune negatives including Tribune ... ON 161/Item 281 1302375 110374533 IE4549473 December 1967 ... 24 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4549475|FL4549477|FL4549478|FL4549479|FL4549... Includes:|Tribune popular sellers Christmas fu... NaN Christmas parties|children|performers Tribune (Newspaper)|Building Workers' Industri... NaN
256 1 6.0 282 ITEM Item 282: Tribune negatives including Christma... ON 161/Item 282 1302379 110374535 IE4545872 December 1967-January 1968 ... 32 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4545874|FL4545877|FL4545878|FL4545879|FL4545... Includes:|Building Workers' Industrial Union o... NaN Christmas parties|children|aged people|trade u... Waterside Workers' Federation of Australia|Bui... NaN
259 1 6.0 285 ITEM Item 285: Tribune negatives including Metal Tr... ON 161/Item 285 1302388 110374540 IE4550104 January 1968 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4550106|FL4550107|FL4550108|FL4550110|FL4550... Includes:|Metal Trades Federation meeting at S... NaN postal workers|meetings|strikes|metalworkers|w... Metal Trades Federation of Unions (Australia) NaN
260 1 6.0 286 ITEM Item 286: Tribune negatives including Metal Tr... ON 161/Item 286 1302390 110374541 IE4547812 January 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4547814|FL4547815|FL4547816|FL4547817|FL4547... Includes:|Metal Trades Federation meeting at S... NaN meetings|strikes|wages Metal Trades Federation of Unions (Australia) NaN
270 1 6.0 296 ITEM Item 296: Tribune negatives including Young So... ON 161/Item 296 1310014 110374558 IE4537186 March 1968 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4537260|FL4537261|FL4537263|FL4537264|FL4537... Includes:|Meeting of the Building Workers Indu... NaN demonstrations|meetings|lunches|trade unionists Building Workers' Industrial Union of Australi... Sydney Town Hall (Sydney, N.S.W.)
273 1 6.0 299 ITEM Item 299: Tribune negatives including PKIU del... ON 161/Item 299 1310018 110374562 IE4539072 March 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4539150|FL4539151|FL4539152|FL4539153|FL4539... Includes:|Ex-servicemen's anti-Vietnam war mee... NaN meetings|customers|butcher shops Printing and Kindred Industries Union|New Thea... NaN
275 1 7.0 301 ITEM Item 301: Tribune negatives including BWIU fun... ON 161/Item 301 1312761 110374574 IE4547173 March 1968 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4547175|FL4547176|FL4547177|FL4547178|FL4547... Includes:|Dance performances and speeches at B... NaN dancing displays Building Workers' Industrial Union of Australia. NaN
276 1 7.0 302 ITEM Item 302: Tribune negatives including Liquor T... ON 161/Item 302 1312769 110374577 IE4547183 March 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4547185|FL4547187|FL4547188|FL4547189|FL4547... Includes:|Kay Smith, the Liquor Trades May Que... NaN beauty contestants|office buildings Union of Australian Women NaN
284 1 7.0 310 ITEM Item 310: Tribune negatives including workplac... ON 161/Item 310 1336591 110374703 IE4540556 April 1968 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4540630|FL4540632|FL4540634|FL4540636|FL4540... Includes:|Workplace meeting at Clyde Engineeri... Meetings--New South Wales.|Boiler-makers--Labo... groups (people)|meetings|trade unions|trade un... Building Workers' Industrial Union of Australi... Clyde Engineering (Granville, N.S.W.)
292 1 7.0 320 ITEM Item 320: Tribune negatives including protest ... ON 161/Item 320 1336702 110374746 IE4538037 ca. 1968 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4538117|FL4538119|FL4538121|FL4538123|FL4538... Includes:|Protest march (May Day?) on George S... Vietnam War, 1961-1975--Protest movements--New... groups (people)|processions|socialists|demonst... Boilermakers' and Blacksmiths' Society of Aust... George Street (Sydney, N.S.W.)|Sydney Town Hal...
324 1 8.0 352 ITEM Item 352: Tribune negatives including job dele... ON 161/Item 352 1343076 110374908 IE4538896 July 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4538981|FL4538983|FL4538987|FL4538989|FL4538... Includes:|Job delegates meeting at Sydney Town... NaN demonstrations|ships|students|university stude... Australian Council of Trade Unions|New Theatre... Sydney Opera House (N.S.W.)|Sydney Harbour (N....
335 1 8.0 363 ITEM Item 363: Tribune negatives including hatch op... ON 161/Item 363 1344334 110374959 IE4543882 September 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4543938|FL4543940|FL4543941|FL4543943|FL4543... Includes:|Hatch opening on a ship for a WWF (W... NaN wharf labourers|ships|blacksmiths|boilermakers... Communist Party of Australia|Building Workers ... NaN
338 1 8.0 366 ITEM Item 366: Tribune negatives including football... ON 161/Item 366 1344345 110374969 IE4542995 September 1968 ... 1 negative http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4543036|FL4543037|FL4543038|FL4543040|FL4543... Original negative sleeve titled: Sept '68|Incl... NaN football|university students|trade unions|meet... New Theatre (Sydney, N.S.W.)|Federal Council f... St. Paul's College (University of Sydney, N.S.W.)
345 1 8.0 373 ITEM Item 373: Tribune negatives including high sch... ON 161/Item 373 1344417 110375025 IE4545205 September 1968 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4545207|FL4545211|FL4545212|FL4545213|FL4545... Original negative sleeve titled: Teachers Str... NaN teachers|trade unions|demonstrations|banners|s... Uren, Tom|Building Workers Industrial Union|Ne... NaN
498 1 11.0 526 ITEM Item 526: Tribune negatives including wharf la... ON 161/Item 526 1338229 110374794 IE4570827 March 1970 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4570902|FL4570906|FL4570908|FL4570911|FL4570... Includes:|Wharf labourers holding a meeting at... NaN meetings|wharf labourers|jetties & wharves|ships Building Workers' Industrial Union of Australia. Walsh Bay (N.S.W.)|Circular Quay No. 4
501 1 11.0 529 ITEM Item 529: Tribune negatives including BHP and ... ON 161/Item 529 1341990 110374807 IE4589509 March-April 1970 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4589511|FL4589516|FL4589517|FL4589518|FL4589... Includes:|Workers' protest in park over BHP, p... NaN demonstrations|pickets Australian Builders' Labourers' Federation|Bui... York Street (Sydney, N.S.W.)|Trades Hall (Goul...
515 1 11.0 545 ITEM Item 545: Tribune negatives including Builders... ON 161/Item 545 1342054 110374856 IE4565317 1970 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4565503|FL4565505|FL4565511|FL4565514|FL4565... Original negative sleeve titled: Vigilantes, B... NaN public speaking|posters & placards|demonstrati... Australian Builders' Labourers' Federation|Aus... NaN
518 1 11.0 548 ITEM Item 548: Tribune negatives including 5th Nati... ON 161/Item 548 1342062 110374864 IE4565165 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4565241|FL4565242|FL4565243|FL4565244|FL4565... Includes:|Speakers and audience in unidentifie... NaN meetings|processions|posters & placards|demons... Australian Broadcasting Corporation|Union of A... University of Sydney Library (N.S.W.)
536 1 12.0 566 ITEM Item 566: Tribune negatives including Vietnam ... ON 161/Item 566 1344309 110374940 IE4572184 [n.d.] ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4572222|FL4572223|FL4572224|FL4572225|FL4572... Includes:|Speaker and audience, including memb... NaN public speaking|demonstrations|posters & placa... Australian Council of Trade Unions Sydney Town Hall (Sydney, N.S.W.)
537 1 12.0 567 ITEM Item 567: Tribune negatives including demonstr... ON 161/Item 567 1344310 110374941 IE4569380 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4569438|FL4569439|FL4569441|FL4569443|FL4569... Includes:|Large demonstration of the Australia... NaN demonstrations|portraits|lunches|posters & pla... Australian Council of Trade Unions Hyde Park (Sydney, N.S.W.)
549 1 12.0 579 ITEM Item 579: Tribune negatives including demonstr... ON 161/Item 579 1344358 110374979 IE4571478 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4571547|FL4571549|FL4571551|FL4571554|FL4571... Includes:|Demonstration procession through cit... NaN demonstrations|city & town streets|banners|pos... Federated Miscellaneous Workers' Union of Aust... NaN
578 1 13.0 608 ITEM Item 608: Tribune negatives including demonstr... ON 161/item 608 1344437 110375043 IE4574862 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4574942|FL4574945|FL4574946|FL4574951|FL4574... Includes:|Demonstration by the Union of Austra... NaN demonstrations|posters & placards|meetings|pub... Union of Australian Women NaN
593 1 13.0 623 ITEM Item 623: Tribune negatives including May Day ... ON 161/Item 623 1344486 110375083 IE4575390 1971 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4575464|FL4575468|FL4575470|FL4575472|FL4575... Includes:|May Day rally through Sydney streets... NaN demonstrations|city & town streets|posters & p... Australian Council of Trade Unions|Amalgamated... NaN
594 1 13.0 624 ITEM Item 624: Tribune negatives including May Day ... ON 161/Item 624 1344503 110375100 IE4576329 1971 ... 26 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4576371|FL4576373|FL4576374|FL4576375|FL4576... Includes:|May Day rally through Sydney streets... NaN demonstrations|posters & placards|banners|city... Australian Council of Trade Unions|Seamen's Un... Sydney Town Hall (Sydney, N.S.W.)
658 1 14.0 697 ITEM Item 697: Tribune negatives including the Abor... ON 161/697 965303 110366675 IE456340 May 1972 ... 40 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 40 FL456342|FL456345|FL456347|FL456349|FL456350|F... Image descriptions provided by cataloguer.|13-... Aboriginal Australians--Land tenure.|Aborigina... NaN Aboriginal Tent Embassy (Canberra, A.C.T.)|Reg... Aboriginal Tent Embassy (Canberra, A.C.T.)|Wen...

56 rows × 22 columns

In [32]:
# Save as a CSV file
people_filtered.to_csv('data/people-search-{}.csv'.format(search_term), index=False)
display(HTML('<a target="_blank" href="data/people-search-{0}.csv">Download people-search-{0}.csv</a>'.format(search_term)))

Exploring places

Create a list of unique place names and sort them alphabetically

In [17]:
# Get unique values in multi-value column
places = pd.unique(df['places'].str.split('|', expand=True).stack()).tolist()
for place in sorted(places, key=str.lower):
    print(place)
Aboriginal Tent Embassy (Canberra, A.C.T.)
Adelaide (S. Aust.)
Alexandria (N.S.W.)
Aquatic Club (corner Riley & Cathedral Streets, Woolloomooloo, N.S.W.)
Art Gallery of New South Wales
Australia Square (Sydney, N.S.W.)
Australian Iron and Steel (Port Kembla, N.S.W.)
Australian Lubricating Oil Refinery (Kurnell, N.S.W.)
Balmain Town Hall (Balmain, N.S.W.)
Bank of New South Wales (George Street, Sydney, N.S.W.)
Bankstown (N.S.W.)
Bankstown Square (Bankstown, N.S.W.)
Belmore Park (Sydney, N.S.W.)
Berowra Waters (N.S.W.)
Boggabilla (N.S.W.)
Bondi Beach (N.S.W.)
Botany Bay (N.S.W.)
Bougainville (Papua New Guinea)
Bourke Street (Waterloo, N.S.W.)
Bowraville (N.S.W.)
Bronte Park (Bronte, N.S.W.)
Bulli (N.S.W.)
Burwood Council Chambers
Campbell Street (Sydney, N.S.W.)
Canberra (A.C.T.)
Cathedral Street (Woolloomooloo, N.S.W.)
Cenotaph (Martin Place, Sydney, N.S.W.)
Centennial Park (Sydney, N.S.W.)
Central Police Court (Liverpool Street, Sydney, N.S.W.)
Central Railway Station (Sydney, N.S.W.)
china
Chullora Railway Workshops (N.S.W.)
Circular Quay (Sydney, N.S.W.)
Circular Quay No. 4
Clarence River (N.S.W.)
Clyde Engineering (Granville, N.S.W.)
Cockatoo Island (N.S.W.)
Commonwealth Bank (Pitt Street and Martin Place, Sydney, N.S.W.)
Commonwealth Office (Martin Place, Sydney, N.S.W.)
Coogee Beach (N.S.W.)
Crown Street (Wollongong, N.S.W.)
Cuba
Darling Harbour (N.S.W.)
Darlinghurst Court House (Darlinghurst, N.S.W.)
David Jones (Sydney) Ltd.
Dee Why (N.S.W.)
Dept. Trade & Industry (ANZ Building, corner Pitt & Hunter Streets, Sydney, N.S.W.)
Domain, The (Sydney, N.S.W.)
Elizabeth Street (Sydney, N.S.W.)
Eveleigh Railway Workshops (Redfern, N.S.W.)
Fairfield (N.S.W.)
Fort Denison (Sydney, N.S.W.)
Garden Island (N.S.W.)
General Post Office (Sydney, N.S.W.)
George Street (Sydney, N.S.W.)
Gladstone (Qld.)
Gowings Building (corner George & Market Streets, Sydney, N.S.W.)
Granville (N.S.W.)
Great Synagogue (Sydney, N.S.W.)
Gunnamatta Bay (N.S.W.)
Gunnedah (N.S.W.)
Harwood Ferry (Grafton District, N.S.W.)
Harwood Island (N.S.W.)
Hordern Pavilion (Sydney Showground, N.S.W.)
Hotel Canberra (A.C.T.)
Hunter Street (Sydney, N.S.W.)
Hyde Park (Sydney, N.S.W.)
Illawarra (N.S.W.)
Indonesia
Industrial Court (Temple Court, 75 Elizabeth Street, Sydney, N.S.W.)
Inverell (N.S.W.)
Ireland
Japan
John Northcott Place (Belvoir Street, Surry Hills, N.S.W.)
King Street (Sydney, N.S.W.)
King's Head Hotel (199 Elizabeth Street, Sydney, N.S.W.)
Kings Cross (N.S.W)
Kings Langley (N.S.W.)
Kingsford-Smith Airport (Sydney, N.S.W.)
Kurnell Oil Refinery
La Perouse (N.S.W.)
Liberal House (30 Ash Street, Sydney, N.S.W.)
Lismore (N.S.W.)
Liverpool Arms (King Street, Sydney, N.S.W.)
Liverpool Street (Sydney, N.S.W.)
Long Bay Gaol (N.S.W.)
Macquarie Street (Sydney, N.S.W.)
Manly (N.S.W.)
Martin Place (Sydney, N.S.W.)
McMahons Point (N.S.W.)
Melbourne (Vic.)
Moore Park (Sydney, N.S.W.)
Moree (N.S.W.)
Moree Aboriginal Station (N.S.W.)
Nambucca Heads (N.S.W.)
National Library of Australia (A.C.T.)
New Caledonia
New Guinea
New Theatre (Sydney, N.S.W.)
Newcastle (N.S.W.)
North Sydney (N.S.W.)
Northern Suburbs Memorial Gardens and Crematorium (North Ryde, N.S.W.)
Old Treasury Building (Sydney, N.S.W.)
Oxford Street (Sydney, N.S.W.)
Paddington (N.S.W.)
Paddington Town Hall (Paddington, N.S.W.)
Papua New Guinea
Park Street (Sydney, N.S.W.)
Parliament House (Canberra, A.C.T.)
Parliament House (Parkes, A.C.T.)
Parliament House (Sydney, N.S.W.)
Parramatta Road (Petersham, N.S.W.)
Petersham Inn (N.S.W.)
Philippines
Pine Gap (N.T.)
Pitt Street (Sydney, N.S.W.)
Poland
Port Kembla (N.S.W.)
Pyrmont (N.S.W.)
Pyrmont Bridge (Sydney, N.S.W.)
Queen Victoria Building (Sydney, N.S.W.)
Redfern (N.S.W.)
Redfern Oval (Elizabeth Street, Redfern, N.S.W.)
Redfern Railway Station (Redfern, N.S.W.)
Richmond (N.S.W.)
Rockdale Town Hall (N.S.W.)
Rocks, The (Sydney, N.S.W.)
Roselands Shopping Centre (N.S.W.)
Royal Hyde Park Hotel (Elizabeth Street, Sydney, N.S.W.)
Rushcutter Bowl (Bayswater Road, Rushcutters Bay, N.S.W.)
Rushcutters Bay (N.S.W.)
Silverwater Prison
South Australia
South Bondi (N.S.W.)
St. James Station (Sydney, N.S.W.)
St. Paul's College (University of Sydney, N.S.W.)
State Dockyard (Dyke End, Newcastle, N.S.W.)
State Office Block (Bent Street, Sydney, N.S.W.)
Surf House (62 Buckingham Street, Surry Hills, N.S.W.)
Surry Hills (N.S.W.)
Sussex Street (Sydney, N.S.W.)
Swanston Street (Melbourne, Vic.)
Sydney (N.S.W.)
Sydney Cricket Ground (Sydney, N.S.W.)
Sydney Harbour (N.S.W.)
Sydney Harbour Bridge (Sydney, N.S.W.)
Sydney Hospital (Macquarie Street, Sydney, N.S.W.)
Sydney Metropolitan Area (N.S.W.)
Sydney Opera House (N.S.W.)
Sydney Showground (N.S.W.)
Sydney Stadium (Rushcutters Bay, N.S.W.)
Sydney Stock Exchange
Sydney Town Hall (Sydney, N.S.W.)
Teachers' Federation Building (166 Phillip Street, Sydney, N.S.W.)
Trades Hall (Goulburn Street, Sydney, N.S.W.)
Trocadero (George Street, Sydney, N.S.W.)
United States Consulate-General (7 Wynyard Street, Sydney, N.S.W.)
University of New South Wales
University of New South Wales. Roundhouse
University of Sydney (N.S.W.)
University of Sydney Library (N.S.W.)
Vanuatu
Victoria Barracks (Paddington, N.S.W.)
Victoria Park (Sydney, N.S.W.)
Victoria Street (Sydney, N.S.W.)
Walgett (N.S.W.)
Walgett Region (N.S.W.)
Wallace Theatre
Walsh Bay (N.S.W.)
War Memorial (Hyde Park, Sydney, N.S.W.)
Warringah Expressway
Waterloo (N.S.W.)
Waterside Workers' Federation of Australia Building (66 Sussex Street, Sydney, N.S.W.)
Watsons Bay Hotel (Watsons Bay, N.S.W.)
Wauchope Region (N.S.W.)
Waverley Bus Depot (Oxford Street, Bondi Junction, N.S.W.)
Waverley Cemetery (Waverley, N.S.W.)
Waverley Park
Wee Waa (N.S.W.)
Wentworth Park (Sydney, N.S.W.)
Wharf no. 11 (Walsh Bay, N.S.W.)
White Bay (N.S.W.)
White City (Rushcutters Bay, N.S.W.)
Wollongong (N.S.W.)
Woods Lane (East Sydney, N.S.W.)
Woolloomooloo (N.S.W.)
Wynyard Park (Sydney, N.S.W.)
Ye Olde Crusty Taverne (255 George Street, Sydney, N.S.W.)
York Street (Sydney, N.S.W.)
In [21]:
# Save as a CSV file
places_df = pd.DataFrame(places)
places_df.columns = ['place']
places_df.to_csv('data/places.csv', index=False)
display(HTML('<a target="_blank" href="data/places.csv">Download places.csv</a>'))

How many times is each place name used?

In [26]:
# Splits the place column and counts frequencies
place_counts = df['places'].str.split('|').apply(lambda x: pd.Series(x).value_counts()).sum().astype('int').sort_values(ascending=False).to_frame().reset_index(level=0)
# Add column names
place_counts.columns = ['place', 'count']
# Display with horizontal bars
display(place_counts.style.bar(subset=['count'], color='#d65f5f').set_properties(subset=['count'], **{'width': '300px'}))
place count
0 Sydney Town Hall (Sydney, N.S.W.) 31
1 University of Sydney (N.S.W.) 31
2 Newcastle (N.S.W.) 13
3 United States Consulate-General (7 Wynyard Street, Sydney, N.S.W.) 12
4 Martin Place (Sydney, N.S.W.) 11
5 Wentworth Park (Sydney, N.S.W.) 11
6 George Street (Sydney, N.S.W.) 8
7 Sydney Harbour (N.S.W.) 8
8 Wynyard Park (Sydney, N.S.W.) 8
9 Cuba 7
10 Hyde Park (Sydney, N.S.W.) 7
11 Parliament House (Sydney, N.S.W.) 6
12 Aboriginal Tent Embassy (Canberra, A.C.T.) 6
13 Wauchope Region (N.S.W.) 5
14 Central Police Court (Liverpool Street, Sydney, N.S.W.) 5
15 Sydney Opera House (N.S.W.) 5
16 Moree (N.S.W.) 4
17 Canberra (A.C.T.) 4
18 Pine Gap (N.T.) 4
19 Parliament House (Parkes, A.C.T.) 4
20 Ye Olde Crusty Taverne (255 George Street, Sydney, N.S.W.) 3
21 Paddington Town Hall (Paddington, N.S.W.) 3
22 Bondi Beach (N.S.W.) 3
23 Bougainville (Papua New Guinea) 3
24 Woolloomooloo (N.S.W.) 3
25 Sydney Harbour Bridge (Sydney, N.S.W.) 3
26 Sydney Cricket Ground (Sydney, N.S.W.) 3
27 Elizabeth Street (Sydney, N.S.W.) 3
28 Sydney (N.S.W.) 3
29 Bulli (N.S.W.) 3
30 Pitt Street (Sydney, N.S.W.) 3
31 Redfern (N.S.W.) 3
32 Alexandria (N.S.W.) 2
33 Philippines 2
34 Park Street (Sydney, N.S.W.) 2
35 Redfern Oval (Elizabeth Street, Redfern, N.S.W.) 2
36 Burwood Council Chambers 2
37 Bankstown Square (Bankstown, N.S.W.) 2
38 Art Gallery of New South Wales 2
39 Moore Park (Sydney, N.S.W.) 2
40 McMahons Point (N.S.W.) 2
41 Macquarie Street (Sydney, N.S.W.) 2
42 Kings Cross (N.S.W) 2
43 Bronte Park (Bronte, N.S.W.) 2
44 Richmond (N.S.W.) 2
45 Fairfield (N.S.W.) 2
46 Eveleigh Railway Workshops (Redfern, N.S.W.) 2
47 Dee Why (N.S.W.) 2
48 Coogee Beach (N.S.W.) 2
49 Clarence River (N.S.W.) 2
50 Circular Quay (Sydney, N.S.W.) 2
51 Chullora Railway Workshops (N.S.W.) 2
52 Central Railway Station (Sydney, N.S.W.) 2
53 Redfern Railway Station (Redfern, N.S.W.) 2
54 china 2
55 War Memorial (Hyde Park, Sydney, N.S.W.) 2
56 Sydney Stadium (Rushcutters Bay, N.S.W.) 2
57 Wallace Theatre 2
58 University of Sydney Library (N.S.W.) 2
59 St. Paul's College (University of Sydney, N.S.W.) 2
60 Trades Hall (Goulburn Street, Sydney, N.S.W.) 2
61 Sydney Showground (N.S.W.) 2
62 Walsh Bay (N.S.W.) 1
63 Commonwealth Office (Martin Place, Sydney, N.S.W.) 1
64 Domain, The (Sydney, N.S.W.) 1
65 Commonwealth Bank (Pitt Street and Martin Place, Sydney, N.S.W.) 1
66 Crown Street (Wollongong, N.S.W.) 1
67 Cockatoo Island (N.S.W.) 1
68 Clyde Engineering (Granville, N.S.W.) 1
69 Darling Harbour (N.S.W.) 1
70 Darlinghurst Court House (Darlinghurst, N.S.W.) 1
71 David Jones (Sydney) Ltd. 1
72 Walgett Region (N.S.W.) 1
73 Dept. Trade & Industry (ANZ Building, corner Pitt & Hunter Streets, Sydney, N.S.W.) 1
74 St. James Station (Sydney, N.S.W.) 1
75 Circular Quay No. 4 1
76 Victoria Street (Sydney, N.S.W.) 1
77 Victoria Park (Sydney, N.S.W.) 1
78 Fort Denison (Sydney, N.S.W.) 1
79 Garden Island (N.S.W.) 1
80 General Post Office (Sydney, N.S.W.) 1
81 Victoria Barracks (Paddington, N.S.W.) 1
82 Gladstone (Qld.) 1
83 Gowings Building (corner George & Market Streets, Sydney, N.S.W.) 1
84 Granville (N.S.W.) 1
85 Great Synagogue (Sydney, N.S.W.) 1
86 Gunnamatta Bay (N.S.W.) 1
87 Gunnedah (N.S.W.) 1
88 Harwood Ferry (Grafton District, N.S.W.) 1
89 Harwood Island (N.S.W.) 1
90 Walgett (N.S.W.) 1
91 Waterloo (N.S.W.) 1
92 Warringah Expressway 1
93 Hotel Canberra (A.C.T.) 1
94 Adelaide (S. Aust.) 1
95 Woods Lane (East Sydney, N.S.W.) 1
96 Aquatic Club (corner Riley & Cathedral Streets, Woolloomooloo, N.S.W.) 1
97 Wollongong (N.S.W.) 1
98 Australia Square (Sydney, N.S.W.) 1
99 Australian Iron and Steel (Port Kembla, N.S.W.) 1
100 Australian Lubricating Oil Refinery (Kurnell, N.S.W.) 1
101 Balmain Town Hall (Balmain, N.S.W.) 1
102 Bank of New South Wales (George Street, Sydney, N.S.W.) 1
103 Bankstown (N.S.W.) 1
104 White City (Rushcutters Bay, N.S.W.) 1
105 Belmore Park (Sydney, N.S.W.) 1
106 Berowra Waters (N.S.W.) 1
107 Boggabilla (N.S.W.) 1
108 White Bay (N.S.W.) 1
109 Botany Bay (N.S.W.) 1
110 Wharf no. 11 (Walsh Bay, N.S.W.) 1
111 Bourke Street (Waterloo, N.S.W.) 1
112 Bowraville (N.S.W.) 1
113 Wee Waa (N.S.W.) 1
114 Waverley Park 1
115 Waverley Cemetery (Waverley, N.S.W.) 1
116 Campbell Street (Sydney, N.S.W.) 1
117 Waverley Bus Depot (Oxford Street, Bondi Junction, N.S.W.) 1
118 Cathedral Street (Woolloomooloo, N.S.W.) 1
119 Cenotaph (Martin Place, Sydney, N.S.W.) 1
120 Centennial Park (Sydney, N.S.W.) 1
121 Watsons Bay Hotel (Watsons Bay, N.S.W.) 1
122 Waterside Workers' Federation of Australia Building (66 Sussex Street, Sydney, N.S.W.) 1
123 Hordern Pavilion (Sydney Showground, N.S.W.) 1
124 Illawarra (N.S.W.) 1
125 Hunter Street (Sydney, N.S.W.) 1
126 Vanuatu 1
127 Northern Suburbs Memorial Gardens and Crematorium (North Ryde, N.S.W.) 1
128 Old Treasury Building (Sydney, N.S.W.) 1
129 Oxford Street (Sydney, N.S.W.) 1
130 Paddington (N.S.W.) 1
131 Papua New Guinea 1
132 Parliament House (Canberra, A.C.T.) 1
133 Sydney Metropolitan Area (N.S.W.) 1
134 Sydney Hospital (Macquarie Street, Sydney, N.S.W.) 1
135 Parramatta Road (Petersham, N.S.W.) 1
136 Petersham Inn (N.S.W.) 1
137 Swanston Street (Melbourne, Vic.) 1
138 Sussex Street (Sydney, N.S.W.) 1
139 Surry Hills (N.S.W.) 1
140 Poland 1
141 Port Kembla (N.S.W.) 1
142 Pyrmont (N.S.W.) 1
143 Pyrmont Bridge (Sydney, N.S.W.) 1
144 Queen Victoria Building (Sydney, N.S.W.) 1
145 Surf House (62 Buckingham Street, Surry Hills, N.S.W.) 1
146 State Office Block (Bent Street, Sydney, N.S.W.) 1
147 State Dockyard (Dyke End, Newcastle, N.S.W.) 1
148 Rockdale Town Hall (N.S.W.) 1
149 Rocks, The (Sydney, N.S.W.) 1
150 Roselands Shopping Centre (N.S.W.) 1
151 Royal Hyde Park Hotel (Elizabeth Street, Sydney, N.S.W.) 1
152 Rushcutter Bowl (Bayswater Road, Rushcutters Bay, N.S.W.) 1
153 Rushcutters Bay (N.S.W.) 1
154 Silverwater Prison 1
155 South Australia 1
156 North Sydney (N.S.W.) 1
157 Sydney Stock Exchange 1
158 New Theatre (Sydney, N.S.W.) 1
159 Liberal House (30 Ash Street, Sydney, N.S.W.) 1
160 South Bondi (N.S.W.) 1
161 Indonesia 1
162 Industrial Court (Temple Court, 75 Elizabeth Street, Sydney, N.S.W.) 1
163 Inverell (N.S.W.) 1
164 Ireland 1
165 Japan 1
166 John Northcott Place (Belvoir Street, Surry Hills, N.S.W.) 1
167 King Street (Sydney, N.S.W.) 1
168 King's Head Hotel (199 Elizabeth Street, Sydney, N.S.W.) 1
169 Kings Langley (N.S.W.) 1
170 Kingsford-Smith Airport (Sydney, N.S.W.) 1
171 Kurnell Oil Refinery 1
172 La Perouse (N.S.W.) 1
173 Lismore (N.S.W.) 1
174 New Guinea 1
175 Liverpool Arms (King Street, Sydney, N.S.W.) 1
176 Liverpool Street (Sydney, N.S.W.) 1
177 Long Bay Gaol (N.S.W.) 1
178 University of New South Wales. Roundhouse 1
179 Manly (N.S.W.) 1
180 University of New South Wales 1
181 Trocadero (George Street, Sydney, N.S.W.) 1
182 Melbourne (Vic.) 1
183 Teachers' Federation Building (166 Phillip Street, Sydney, N.S.W.) 1
184 Moree Aboriginal Station (N.S.W.) 1
185 Nambucca Heads (N.S.W.) 1
186 York Street (Sydney, N.S.W.) 1
187 New Caledonia 1
188 National Library of Australia (A.C.T.) 1
In [27]:
# Save as a CSV file
place_counts.to_csv('data/place_counts.csv', index=False)
display(HTML('<a target="_blank" href="data/place_counts.csv">Download place_counts.csv</a>'))

Search for a place

In [28]:
search_term = 'university'
places_filtered = df.loc[df['places'].str.contains(search_term, case=False, na=False)].copy()
places_filtered
Out[28]:
series_number part_number item_number level title call_number object_number priref intellectual_entity date_string ... quantity url parent_url number_images images description subjects topics people places
40 1 1.0 49 ITEM Item 049: Tribune negatives including demonstr... ON 161/Item 049 1051112 110370240 IE4517651 August 1965 ... 29 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 29 FL4517653|FL4517655|FL4517656|FL4517659|FL4517... Includes:|Lobby Train trip to Canberra. Donnel... Vietnam War, 1961-1975--Protest movements--New... crowds|roads & streets|police|posters & placar... NaN University of New South Wales|Liverpool Street...
81 1 2.0 94 ITEM Item 094: Tribune negatives including anti-Vie... ON 161/Item 094 1248717 110373885 IE4523418 February-March 1966 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4523420|FL4523421|FL4523422|FL4523423|FL4523... Includes:|Canberra Anti-Vietnam War Vigil Comm... Vietnam War, 1961-1975--Protest movements--New... demonstrations|newspapers Cairns, Jim, 1914-2003|University of Sydney|Tr... University of Sydney (N.S.W.)
307 1 7.0 335 ITEM Item 335: Tribune negatives including Sydney U... ON 161/Item 335 1341997 110374814 IE4538882 June 1968 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4538941|FL4538942|FL4538944|FL4538945|FL4538... Includes:|Sydney University students meeting a... NaN university students|conscription|demonstration... New Theatre (Sydney, N.S.W.) University of Sydney (N.S.W.)
315 1 7.0 343 ITEM Item 343: Tribune negatives including police o... ON 161/Item 343 1342043 110374851 IE4539525 June 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4539600|FL4539602|FL4539603|FL4539605|FL4539... Includes:|Police officer speaks to demonstrato... NaN conscription|demonstrations|police|university ... NaN University of Sydney (N.S.W.)|Commonwealth Ban...
317 1 7.0 345 ITEM Item 345: Tribune negatives including demonstr... ON 161/Item 345 1342061 110374863 IE4539759 July 1968 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4539843|FL4539846|FL4539848|FL4539850|FL4539... Includes:|Demonstrators march on road and tram... NaN university students|demonstrations|occupations... NaN Liberal House (30 Ash Street, Sydney, N.S.W.)|...
318 1 7.0 346 ITEM Item 346: Tribune negatives including portrait... ON 161/Item 346 1342069 110374868 IE4541529 March 1969 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4541660|FL4541662|FL4541665|FL4541667|FL4541... Includes:|Portrait of unidentified man. Row 1.... NaN demonstrations|processions|wages|women|banners NaN University of Sydney (N.S.W.)
320 1 7.0 348 ITEM Item 348: Tribune negatives including demonstr... ON 161/Item 348 1342080 110374878 IE4555837 July 1968 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4555839|FL4555842|FL4555844|FL4555845|FL4555... Includes:|Demonstrators in front of Daily Tele... NaN trade unions|demonstrations|banners|posters & ... NaN University of New South Wales. Roundhouse|Live...
325 1 8.0 353 ITEM Item 353: Tribune negatives including construc... ON 161/Item 353 1343952 110374927 IE4538237 1968 ... 27 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4538271|FL4538272|FL4538273|FL4538274|FL4538... Includes:|Construction work at Sydney Opera Ho... NaN hospitals|building construction|tennis racquet... NaN University of Sydney (N.S.W.)|Sydney Opera Hou...
337 1 8.0 365 ITEM Item 365: Tribune negatives including Flo Davi... ON 161/Item 365 1344342 110374966 IE4543177 September 1968 ... 33 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4543248|FL4543249|FL4543250|FL4543254|FL4543... Includes:|Flo Davis testimonial dinner at the ... NaN dinners|university students|mechanical enginee... Aarons, Laurie, 1917-2005|Cahill, J J (Mrs)|Mu... St. Paul's College (University of Sydney, N.S.W.)
338 1 8.0 366 ITEM Item 366: Tribune negatives including football... ON 161/Item 366 1344345 110374969 IE4542995 September 1968 ... 1 negative http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4543036|FL4543037|FL4543038|FL4543040|FL4543... Original negative sleeve titled: Sept '68|Incl... NaN football|university students|trade unions|meet... New Theatre (Sydney, N.S.W.)|Federal Council f... St. Paul's College (University of Sydney, N.S.W.)
340 1 8.0 368 ITEM Item 368: Tribune negatives including guerilla... ON 161/item 368 1344362 110374983 IE4544612 September 1968 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4544614|FL4544618|FL4544619|FL4544620|FL4544... Original negative sleeve titled: Sept '68|Incl... NaN university students|theatrical productions|dem... Irish National Association of Australasia|Clan... Wynyard Park (Sydney, N.S.W.)|University of Sy...
423 1 10.0 451 ITEM Item 451: Tribune negatives including socialis... ON 161/Item 451 1342084 110374882 IE4557749 June 1969 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4557751|FL4557752|FL4557753|FL4557754|FL4557... Includes:|Socialist speakers at the Domain in ... NaN civil & political rights|processions|meetings|... Dougherty, Chris University of Sydney (N.S.W.)|Domain, The (Syd...
426 1 10.0 454 ITEM Item 454: Tribune negatives including Student ... ON 161/Item 454 1343062 110374897 IE4561616 July 1969 ... 26 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4561618|FL4561619|FL4561620|FL4561621|FL4561... Includes:|Student Representative Council meeti... NaN meetings|university students|tax forms Salmon, Malcolm, 1925-1986|Communist Party of ... University of Sydney (N.S.W.)
460 1 10.0 488 ITEM Item 488: Tribune negatives including views of... ON 161/Item 488 1344659 110375199 IE4564796 ca. 1969 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4564956|FL4564959|FL4564961|FL4564966|FL4564... Includes:|Views of Sydney streets and building... Anti-war demonstrations--New South Wales--Sydn... demonstrations|city & town buildings|groups (p... NaN University of Sydney (N.S.W.)
461 1 10.0 489 ITEM Item 489: Tribune negatives including demonstr... ON 161/Item 489 1344710 110375207 IE4565277 ca. 1969 ... 31 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4565364|FL4565366|FL4565367|FL4565369|FL4565... Includes:|Demonstration march protesting the V... Anti-war demonstrations--New South Wales--Sydn... portraits|war memorials|demonstrations|city & ... NaN Martin Place (Sydney, N.S.W.)|Cenotaph (Martin...
511 1 11.0 539 ITEM Item 539: Tribune negatives including demonstr... ON 161/Item 539 1342035 110374847 IE4565947 1970 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4566059|FL4566060|FL4566061|FL4566062|FL4566... Includes:|Student arrests in relation to Morat... NaN arrests|demonstrations|art galleries|art NaN University of Sydney (N.S.W.)
518 1 11.0 548 ITEM Item 548: Tribune negatives including 5th Nati... ON 161/Item 548 1342062 110374864 IE4565165 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4565241|FL4565242|FL4565243|FL4565244|FL4565... Includes:|Speakers and audience in unidentifie... NaN meetings|processions|posters & placards|demons... Australian Broadcasting Corporation|Union of A... University of Sydney Library (N.S.W.)
521 1 12.0 551 ITEM Item 551: Tribune negatives including the exte... ON 161/Item 551 1342073 110374872 IE4564586 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4564694|FL4564695|FL4564697|FL4564700|FL4564... Includes:|Arrests by police of members at demo... NaN demonstrations|bookshops|arrests|posters & pla... Australian Labor Party Sydney Town Hall (Sydney, N.S.W.)|University o...
543 1 12.0 573 ITEM Item 573: Tribune negatives including demonstr... ON 161/Item 573 1344328 110374956 IE4568105 1970 ... 23 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 29 FL4568154|FL4568156|FL4568157|FL4568159|FL4568... Includes:|Demonstration with police presence a... NaN posters & placards|banners|demonstrations|police NaN University of Sydney (N.S.W.)
584 1 13.0 614 ITEM Item 614: Tribune negatives including various ... ON 161/item 614 1344457 110375060 IE4576190 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4576326|FL4576327|FL4576328|FL4576334|FL4576... Includes:|Demonstration against racial segrega... NaN racial discrimination|jetties & wharves|demons... Dee Why Surf Life Saving Club (N.S.W.) Dee Why (N.S.W.)|University of Sydney (N.S.W.)
591 1 13.0 621 ITEM Item 621: Tribune negatives including demonstr... ON 161/Item 621 1344480 110375077 IE4574486 [n.d.] ... 27 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 31 FL4574559|FL4574560|FL4574561|FL4574563|FL4574... Includes:|Gentlemen seated at a conference des... NaN meetings|public speaking|demonstrations|theatr... NaN University of Sydney (N.S.W.)
592 1 13.0 622 ITEM Item 622: Tribune negatives including various ... ON 161/Item 622 1344484 110375081 IE4573819 [n.d.] ... 28 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 32 FL4573854|FL4573855|FL4573856|FL4573857|FL4573... Includes:|Demonstration and procession from th... NaN demonstrations|city & town streets|Vietnam War... NaN University of Sydney (N.S.W.)
634 1 14.0 664 ITEM Item 664: Tribune negatives including demonstr... ON 161/Item 664 1344359 110374980 IE4581314 NaN ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4581450|FL4581451|FL4581452|FL4581453|FL4581... Includes:|Demonstration calling for the releas... NaN processions|demonstrations|posters & placards|... NaN University of Sydney (N.S.W.)
635 1 14.0 665 ITEM Item 665: Tribune negatives including members ... ON 161/item 665 1344369 110374988 IE4582695 [n.d.] ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4582773|FL4582774|FL4582775|FL4582776|FL4582... Includes:|Members of the University of Sydney'... NaN petitions|crowds|posters & placards United Nations. University of Sydney (N.S.W.)
636 1 14.0 666 ITEM Item 666: Tribune negatives including a public... ON 161/item 666 1344376 110374994 IE4584929 [n.d.] ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 33 FL4585011|FL4585012|FL4585013|FL4585014|FL4585... Includes:|Speaker addressing a seated audience... NaN processions|posters & placards|crowds|vacant b... NaN University of Sydney (N.S.W.)
669 1 15.0 711 ITEM Item 711: Tribune negatives including a group ... ON 161/Item 711 1344496 110375093 IE4579497 [n.d.] ... 42 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 42 FL4579594|FL4579596|FL4579599|FL4579600|FL4579... Includes:|A group of unidentified people meeti... NaN portraits|groups (people)|posters & placards|a... NaN University of Sydney (N.S.W.)
671 1 15.0 714 ITEM Item 714: Tribune negatives including an unide... ON 161/Item 714 1344519 110375113 IE4587469 1972 ... 42 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 42 FL4587514|FL4587515|FL4587516|FL4587517|FL4587... Includes:|Unidentified man wearing a badge.|Ni... NaN land rights|demonstrations|crowds|posters & pl... NaN University of Sydney (N.S.W.)
673 1 15.0 716 ITEM Item 716: Tribune negatives including an unide... ON 161/Item 716 1344524 110375116 IE4587227 [n.d.] ... 42 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 42 FL4587272|FL4587273|FL4587274|FL4587275|FL4587... Includes:|Unidenified meeting at the Lower Syd... NaN audiences|processions|crowds|posters & placard... NaN University of Sydney (N.S.W.)
710 2 1.0 18 ITEM Item 0018: Tribune negatives including Vietnam... ON 160/Item 0018 1038214 110369160 IE4497055 1975 ... 30 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 30 FL4497115|FL4497116|FL4497117|FL4497118|FL4497... Includes:|Bicycle demonstration, February 1975... Vietnam War, 1961-1975--Protest movements--New... demonstrations|nurses|students NaN University of Sydney (N.S.W.)
718 2 1.0 26 ITEM Item 0026: Tribune negatives including politic... ON 160/Item 0026 1043324 110369169 IE4486788 March-April 1975 ... 17 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 17 FL4486790|FL4486791|FL4486792|FL4486793|FL4486... Includes:|Political Economy demonstration (Syd... Student movements--New South Wales--Sydney. demonstrations|students NaN University of Sydney (N.S.W.)
826 2 3.0 134 ITEM Item 0134: Tribune negatives including land ri... ON 160/Item 0134 1043895 110369326 IE4504043 September 1976 ... 17 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 17 FL4504117|FL4504120|FL4504123|FL4504127|FL4504... Includes:|Sydney University student (woman)|La... NaN land rights|demonstrations|university students NaN University of Sydney (N.S.W.)
857 2 4.0 171 ITEM Item 0171: Tribune negatives including Tertiar... ON 160/Item 0171 1045210 110369369 IE4495960 May 1977 ... 26 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 26 FL4496017|FL4496018|FL4496019|FL4496020|FL4496... Includes:|Education, Tertiary Education Assist... NaN strikes|universities|rock-climbing NaN University of Sydney (N.S.W.)
939 2 6.0 256 ITEM Item 0256: Tribune negatives including social ... ON 160/Item 0256 1045365 110369482 IE4508675 August 1977 ... 35 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 35 FL4508677|FL4508678|FL4508679|FL4508680|FL4508... Includes:|Fred Nichol, August 1977|Pollution, ... NaN demonstrations|welfare workers NaN University of Sydney (N.S.W.)
993 3 1.0 314 ITEM Item 0314: Tribune negatives including protest... ON 160/Item 0314 1045466 110369546 IE4366275 March 1978 ... 34 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 34 FL4366369|FL4366373|FL4366375|FL4366377|FL4366... Includes:|Sydney University - protest over stu... NaN demonstrations|women|students NaN University of Sydney (N.S.W.)
1596 3 13.0 942 ITEM Item 0942: Tribune negatives including May Day... ON 160/Item 0942 1055225 110370592 IE4464259 May 1986 ... 39 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 39 FL4464330|FL4464332|FL4464334|FL4464336|FL4464... Includes:|Monorail, May 1986|May Day, May 1986... NaN demonstrations|universities|university buildings NaN University of Sydney (N.S.W.)
1815 4 NaN 18 ITEM Item 18: Tribune negatives including May Day m... ON 162/Item 18 1045766 110369786 IE4585479 1973 ... 36 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 36 FL4585532|FL4585533|FL4585534|FL4585536|FL4585... Original negative sleeve titled F786 May Day|I... May Day (Labor holiday)--New South Wales. demonstrations|posters & placards|banners|monks NaN George Street (Sydney, N.S.W.)|University of S...
1821 4 NaN 24 ITEM Item 24: Tribune negatives including student r... ON 162/Item 24 1045784 110369799 IE4588929 February 1988 ... 12 negatives http://archival.sl.nsw.gov.au/Details/archive/... http://archival.sl.nsw.gov.au/Details/archive/... 12 FL4588967|FL4588970|FL4588971|FL4588972|FL4588... Original negative sleeve titled File No. 2, St... NaN university students|demonstrations NaN University of Sydney (N.S.W.)

37 rows × 22 columns

In [30]:
# Save as a CSV file
places_filtered.to_csv('data/places-search-{}.csv'.format(search_term), index=False)
display(HTML('<a target="_blank" href="data/places-search-{0}.csv">Download places-search-{0}.csv</a>'.format(search_term)))

Exploring dates

Chart the number of records per year

In [198]:
# Let's make a chart of the start dates!
# What happens when you change the :O to :T
chart = alt.Chart(df).mark_bar().encode(
    x=alt.X('year(date_start):O', title='Year'),
    y=alt.Y('count()', axis=alt.Axis(title='Number of records')),
    tooltip=[alt.Tooltip('year(date_start):O', title='Year'), alt.Tooltip(aggregate='count', type='quantitative', title='Total')]
)
chart