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.
# 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!
RendererRegistry.enable('notebook')
The harvested metadata is currently sitting in another GitHub repository. We can load it directly from there using Pandas.
# 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')
# Let's have a look inside...
# Note that both the columns and rows are truncated in this preview
df
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
# What are the column headings?
# Can you see which ones are missing from the truncated sample above?
df.columns
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 items?
len(df)
1845
# How many images?
df['number_images'].sum()
60364
# What's the earliest start date?
df['date_start'].min()
'1900-01-01 00:00:00'
# What's the latest end date?
df['date_end'].max()
'1990-12-31 00:00:00'
# 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
# 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>'))
# 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 |
# 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 topics
search_term = 'work'
topics_filtered = df.loc[df['topics'].str.contains(search_term, case=False, na=False)].copy()
topics_filtered
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
# 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)))
Subjects are a set of controlled and hierarchical descriptive labels following the Library of Congress Subject Headings.
# 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.
# 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>'))
# 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 |
# 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_term = 'Pine Gap'
subjects_filtered = df.loc[df['subjects'].str.contains(search_term, case=False, na=False)].copy()
subjects_filtered
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
# 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)))
# 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.
# 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>'))
# 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 |
# 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_term = 'union'
people_filtered = df.loc[df['people'].str.contains(search_term, case=False, na=False)].copy()
people_filtered
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
# 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)))
# 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.)
# 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>'))
# 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 |
# 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_term = 'university'
places_filtered = df.loc[df['places'].str.contains(search_term, case=False, na=False)].copy()
places_filtered
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
# 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)))
# 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
date = '1900-01-01 00:00:00'
dates_filtered = df.loc[df['date_start'] == date].copy()
dates_filtered
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164 | 1 | 4.0 | 185 | ITEM | Item 185: Tribune negatives including Campaign... | ON 161/Item 185 | 1269553 | 110374102 | IE4531172 | between 1964 and 1967? | ... | 35 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4531174|FL4531183|FL4531187|FL4531189|FL4531... | Original negative sleeve titled: Cosmos - sail... | NaN | sailing boats|book launches | NaN | NaN |
215 | 1 | 5.0 | 241 | ITEM | Item 241: Tribune negatives including anti-Vie... | ON 161/Item 241 | 1290868 | 110374254 | IE4548869 | 1967? | ... | 36 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4548871|FL4548873|FL4548874|FL4548875|FL4548... | Original negative sleeve titled: Anti Viet. Wa... | NaN | demonstrations|peace movement | NaN | NaN |
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 |
217 | 1 | 5.0 | 243 | ITEM | Item 243: Tribune negatives including building... | ON 161/Item 243 | 1290871 | 110374256 | IE4534780 | 1967 | ... | 36 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4534782|FL4534784|FL4534786|FL4534787|FL4534... | Original negative sleeve titled: Anti Viet. Wa... | NaN | building suppliers|demonstrations|Aboriginal p... | 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 |
253 | 1 | 6.0 | 279 | ITEM | Item 279: Tribune negatives including Tribune ... | ON 161/Item 279 | 1302368 | 110374530 | IE4549662 | NaN | ... | 36 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4549664|FL4549667|FL4549669|FL4549670|FL4549... | Includes:|Photographs of ship's deck and cargo... | NaN | cargo ships|Christmas parties | Waterside Workers' Federation of Australia|Tri... | NaN |
279 | 1 | 7.0 | 305 | ITEM | Item 305 : Tribune negatives including model o... | ON 161/Item 305 | 1336570 | 110374689 | IE4545565 | NaN | ... | 33 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 33 | FL4545567|FL4545568|FL4545569|FL4545570|FL4545... | Includes:|Model of the Opera House on display ... | Sydney Opera House--Design and construction. | theatres & cinemas | NaN | Sydney Town Hall (Sydney, N.S.W.)|Fort Denison... |
344 | 1 | 8.0 | 372 | ITEM | Item 372: Tribune negatives including teachers... | ON 161/Item 372 | 1344391 | 110375009 | IE4544365 | NaN | ... | 36 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4544367|FL4544371|FL4544375|FL4544378|FL4544... | Original negative sleeve titled: World Ch'shi... | NaN | trade unions|teachers|demonstrators (political... | Sobers, Garry, 1936-|Tivoli Theatre (Sydney, N... | NaN |
503 | 1 | 11.0 | 531 | ITEM | Item 531: Tribune negatives including unidenti... | ON 161/Item 531 | 1342001 | 110374818 | IE4566152 | NaN | ... | 33 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 34 | FL4566224|FL4566225|FL4566226|FL4566227|FL4566... | Includes:|Speakers and audience from unidentif... | NaN | meetings|audiences | Lenin, Vladimir Ilich, 1870-1924. | NaN |
504 | 1 | 11.0 | 532 | ITEM | Item 532: Tribune negatives including demonstr... | ON 161/Item 532 | 1342003 | 110374820 | IE4564054 | NaN | ... | 36 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4564140|FL4564143|FL4564144|FL4564146|FL4564... | Includes:|Demonstration outside Honeywell comp... | NaN | meetings|demonstrations | Honeywell Ltd. | Bourke Street (Waterloo, 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.) |
11 rows × 22 columns
# Save as a CSV file
dates_filtered.to_csv('data/dates-search-{}.csv'.format(date.replace(' 00:00:00', '')), index=False)
display(HTML('<a target="_blank" href="data/dates-search-{0}.csv">Download dates-search-{0}.csv</a>'.format(date.replace(' 00:00:00', ''))))
stopwords = nltk.corpus.stopwords.words('english')
# Words we want to exclude
exclude = stopwords + ['tribune', 'negatives', 'including', 'item']
# Turn all the titles into one big string
titles = df['title'].str.lower().str.cat(sep=' ')
# Generate a word cloud image
wordcloud = WordCloud(width=1200, height=800, stopwords=exclude).generate(titles)
plt.figure(figsize=(12,8))
plt.imshow(wordcloud, interpolation='bilinear')
plt.axis("off")
(-0.5, 1199.5, 799.5, -0.5)
stopwords = nltk.corpus.stopwords.words('english')
# words we want to exclude
exclude = stopwords + ['image', 'descriptions', 'description', 'provided', 'cataloguer', 'negative', 'sleeve', 'titled', 'original', 'include', 'includes', 'row', 'rows']
# Add all the descriptions together to make one big string
descriptions = df['description'].str.lower().str.cat(sep=' ')
# Generate a word cloud image
wordcloud = WordCloud(width=1200, height=800, stopwords=exclude).generate(descriptions)
plt.figure(figsize=(12,8))
plt.imshow(wordcloud, interpolation='bilinear')
plt.axis("off")
(-0.5, 1199.5, 799.5, -0.5)
search_term = 'eviction'
desc_filtered = df.loc[df['description'].str.contains(search_term, case=False, na=False)].copy()
desc_filtered
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
656 | 1 | 14.0 | 695 | ITEM | Item 695: Tribune negatives including general ... | ON 161/695 | 965302 | 110366674 | IE468006 | March-May, 1972 | ... | 43 photographs | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 43 | FL468008|FL468011|FL468013|FL468015|FL468017|F... | Image descriptions provided by cataloguer.|1. ... | Aboriginal Australians--Land tenure.|Aborigina... | Aboriginal peoples (Australians) | Aboriginal Tent Embassy (Canberra, A.C.T.)|Cra... | Aboriginal Tent Embassy (Canberra, A.C.T.) |
666 | 1 | 15.0 | 706 | ITEM | Item 706: Tribune negatives including portrait... | ON 161/Item 706 | 1344470 | 110375069 | IE4580049 | 1972 | ... | 36 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 36 | FL4580125|FL4580126|FL4580127|FL4580128|FL4580... | Original negative sleeve titled: Aboriginal De... | NaN | portraits|posters & placards|evictions|process... | Liberal Party of Australia.|McMahon, William, ... | NaN |
1057 | 3 | 2.0 | 382 | ITEM | Item 0382: Tribune negatives including disarma... | ON 160/Item 0382 | 1045565 | 110369615 | IE4373180 | November 1978 | ... | 33 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 33 | FL4373276|FL4373280|FL4373281|FL4373284|FL4373... | Includes:|Glebe evictions, November 1978|Holla... | NaN | rallies|disarmament | NaN | NaN |
1231 | 3 | 6.0 | 559 | ITEM | Item 0559: Tribune negatives including Carol O... | ON 160/Item 0559 | 1045937 | 110369912 | IE4416963 | 1980-1981 | ... | 42 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 42 | FL4417070|FL4417071|FL4417073|FL4417075|FL4417... | Includes:|Rank & File Conference theatre, Sydn... | NaN | men|women | NaN | NaN |
1262 | 3 | 6.0 | 591 | ITEM | Item 0591: Tribune negatives including public ... | ON 160/Item 0591 | 1045994 | 110369948 | IE4416378 | March 1981 | ... | 34 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 34 | FL4416415|FL4416416|FL4416417|FL4416418|FL4416... | Includes:|Melbourne public transport, Coburg l... | NaN | demonstrations|demonstrators (political) | NaN | NaN |
1266 | 3 | 6.0 | 595 | ITEM | Item 0595: Tribune negatives including Surry S... | ON 160/Item 0595 | 1045999 | 110369953 | IE4422197 | March 1981 | ... | 37 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 37 | FL4422363|FL4422364|FL4422368|FL4422371|FL4422... | Includes:|Fresno city ship, Sydney, March 1981... | NaN | city & town streets|evictions|communities | NaN | NaN |
1525 | 3 | 12.0 | 868 | ITEM | Item 0868: Tribune negatives including Helen B... | ON 160/Item 0868 | 1055052 | 110370482 | IE4467925 | 1985 | ... | 35 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 35 | FL4467988|FL4467995|FL4467999|FL4468002|FL4468... | Includes:|Squats, Glebe just before first evic... | NaN | press conferences|evictions|vandalised buildings | NaN | NaN |
1570 | 3 | 13.0 | 915 | ITEM | Item 0915: Tribune negatives including house e... | ON 160/Item 0915 | 1055164 | 110370554 | IE690939 | 1984-1985 | ... | 16 transparencies | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 23 | FL691025|FL691027|FL691029|FL691031|FL691032|F... | Includes:|Glebe evictions, 1984/1985|Soup kitc... | NaN | evictions|soup kitchens | NaN | NaN |
1639 | 3 | 14.0 | 989 | ITEM | Item 0989: Tribune negatives including nurses ... | ON 160/Item 0989 | 1055339 | 110370678 | IE4470565 | November 1986 | ... | 41 negatives | http://archival.sl.nsw.gov.au/Details/archive/... | http://archival.sl.nsw.gov.au/Details/archive/... | 41 | FL4470654|FL4470656|FL4470658|FL4470660|FL4470... | Includes:|Glebe squats, last evictons, Novembe... | NaN | nurses|demonstrations | NaN | NaN |
9 rows × 22 columns
# Save as a CSV file
desc_filtered.to_csv('data/description-search-{}.csv'.format(search_term), index=False)
display(HTML('<a target="_blank" href="data/description-search-{0}.csv">Download description-search-{0}.csv</a>'.format(search_term)))
# Inspect a row by row number
# Change the row_number to display a different row
# The row number (or index), is in the first column
row_number = 650
df.loc[row_number]
series_number 1 part_number 14 item_number 680 level ITEM title Item 680: Tribune negatives including speakers... call_number ON 161/680 object_number 965301 priref 110366673 intellectual_entity IE467347 date_string February, 1972 date_start 1972-02-01 00:00:00 date_end 1972-02-29 00:00:00 quantity 36 negatives url http://archival.sl.nsw.gov.au/Details/archive/... parent_url http://archival.sl.nsw.gov.au/Details/archive/... number_images 36 images FL467349|FL467352|FL467354|FL467357|FL467359|F... description Image descriptions provided by cataloguer.|1-2... subjects Aboriginal Australians--Land tenure.|Aborigina... topics Aboriginal peoples (Australians)|demonstration... people Aboriginal Tent Embassy (Canberra, A.C.T.)|Bla... places Silverwater Prison|Aboriginal Tent Embassy (Ca... Name: 650, dtype: object
# Inspect a field in a particular row
# In this case we're looking at the 'description' field
df.loc[row_number]['description']
"Image descriptions provided by cataloguer.|1-2. First anniversary dinner of Retired Waterside Workers' Association members, February 1972.|3. Retired waterside worker Albert Hobson dancing with wife, Alice, at a Retired Waterside Workers' Association dinner, February 1972.|4. Women leaving Silverwater prison after visiting Wendy Bacon.|5-6. Crowd outside Silverwater prison.|7-8. Freedom of expression rally in Martin Place.|9. University of NSW law lecturer Tony Blackshield addresses a freedom of expression rally outside the G.P.O., Martin Place.|10-11. Freedom of expression rally in Martin place.|12. First anniversary dinner of Retired Waterside Workers' Association members, February 1972.|13-16. Wendy Bacon supporters outside court.|17-18. Freedom of expression rally in Martin Place.|19-21. Men seated at a meeting.|22-24. Wendy Bacon leaving court.|25-30. Men seated at a meeting.|31. Frank Roberts speaks at the Aboriginal Tent Embassy, 8 February 1972.|32. Gough Whitlam speaks at the Aboriginal Tent Embassy, 8 February, 1972.|33. Michael Anderson speaks at the Aboriginal Tent Embassy, 8 February 1972.|34. Bobbi Sykes speaks at the Aboriginal Tent Embassy, 8 February 1972.|35-36. Scenes at the Aboriginal Tent Embassy."
# Display a clickable url
display(HTML('<a target="_blank" href="{0}">{0}</a>'.format(df.loc[row_number]['url'])))
Just copy an image identifier from the images
column and paste in below as the value of image_id
.
image_id = 'FL1817297'
display(HTML('<a target="_blank" href="https://s3-ap-southeast-2.amazonaws.com/wraggetribune/images/{0}.jpg"><image src="https://s3-ap-southeast-2.amazonaws.com/wraggetribune/images/500/{0}-500.jpg"></a>'.format(image_id)))
df.loc[df['images'].str.contains(image_id, case=False, na=False)].copy().iloc[0]
series_number 2 part_number 2 item_number 57 level ITEM title Item 0057: Tribune negatives including PKIU de... call_number ON 160/Item 0057 object_number 1043421 priref 110369202 intellectual_entity IE1817133 date_string ca. 1974-1975 date_start 1974-01-01 00:00:00 date_end 1975-12-31 00:00:00 quantity 23 negatives url http://archival.sl.nsw.gov.au/Details/archive/... parent_url http://archival.sl.nsw.gov.au/Details/archive/... number_images 41 images FL1817297|FL1817300|FL1817303|FL1817307|FL1817... description Includes:|Timor demonstration|Tribune sellers|... subjects NaN topics demonstrations|newspaper sellers|portraits people NaN places NaN Name: 750, dtype: object
Just change the row_number
to view the images associated with an item. Click on the images to enlarge.
The item metadata is displayed below the images.
row_number = 900
images = df.loc[row_number]['images'].split('|')
html = ''
for image in images:
html += '<a title="{0}" target="_blank" href="https://s3-ap-southeast-2.amazonaws.com/wraggetribune/images/{0}.jpg"><image style="width: 300px; height: 300px; float: left; margin: 10px; object-fit: contain;" src="https://s3-ap-southeast-2.amazonaws.com/wraggetribune/images/500/{0}-500.jpg"></a>'.format(image)
display(HTML(html))
df.loc[row_number]
series_number 2 part_number 5 item_number 217 level ITEM title Item 0217: Tribune negatives including freeway... call_number ON 160/Item 0217 object_number 1045279 priref 110369421 intellectual_entity IE4508260 date_string June 1977 date_start 1977-01-01 00:00:00 date_end 1977-12-31 00:00:00 quantity 20 negatives url http://archival.sl.nsw.gov.au/Details/archive/... parent_url http://archival.sl.nsw.gov.au/Details/archive/... number_images 20 images FL4508262|FL4508264|FL4508266|FL4508267|FL4508... description Includes:|Freeways demonstration, Melbourne, J... subjects NaN topics demonstrations|expressways|bicycles people NaN places NaN Name: 900, dtype: object
# This cell creates a CSV file with a row for each image, preserving all the parent item metadata
def tidy_split(df, column, sep='|', keep=False):
"""
Split the values of a column and expand so the new DataFrame has one split
value per row. Filters rows where the column is missing.
Params
------
df : pandas.DataFrame
dataframe with the column to split and expand
column : str
the column to split and expand
sep : str
the string used to split the column's values
keep : bool
whether to retain the presplit value as it's own row
Returns
-------
pandas.DataFrame
Returns a dataframe with the same columns as `df`.
"""
indexes = list()
new_values = list()
df = df.dropna(subset=[column])
for i, presplit in enumerate(df[column].astype(str)):
values = presplit.split(sep)
if keep and len(values) > 1:
indexes.append(i)
new_values.append(presplit)
for value in values:
indexes.append(i)
new_values.append(value)
new_df = df.iloc[indexes, :].copy()
new_df[column] = new_values
return new_df
images_df = tidy_split(df, 'images', sep='|')
images_df.head()
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 | 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.) |
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 | FL4513559 | 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.) |
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 | FL4513561 | 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.) |
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 | FL4513564 | 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.) |
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 | FL4513567 | 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.) |
5 rows × 22 columns
images_df.to_csv('data/images.csv', index=False)
display(HTML('<a target="_blank" href="data/images.csv">Download images.csv</a>'))