names

37 rows where place_id = 617517

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3719906 1932495 1932495 defendant Grand Peter   617517 617517 Grand, Peter, of Southwark St Olav 0
4062736 2046972 2046972 plaintiff Frederick Hans joiner 617517 617517 Frederick, Hans, of Southwark St Olav, joiner 0
4063319 2047172 2047172 plaintiff Gawton Adriane widow 617517 617517 Adriane his wife, formerly Adriane Ceelie, of Southwark St Olav, widow 1
4166089 2083646 2083646 defendant Baker Christopher   617517 617517 Baker, Christopher, of Southwark St Olav, shipwright 0
4176228 2087162 2087162 defendant Melbanke Brian feltmaker 617517 617517 Melbanke, Brian, of Southwark St Olav, feltmaker 0
4176229 2087162 2087162 defendant Griffyn Thomas feltmaker 617517 617517 Griffyn, Thomas, of Southwark St Olav, feltmaker 1
4180040 2088497 2088497 defendant Woodwarde William blacksmith 617517 617517 Woodwarde, William, of Southwark St Olav, blacksmith 0
4180042 2088497 2088497 defendant Awnsell Richard   617517 617517 Awnsell, Richard, of Southwark St Olav, felt maker 2
4191668 2092641 2092641 defendant Burre Olav beer brewer 617517 617517 Burre, Olav, of Southwark St Olav, beer brewer 0
4197362 2094632 2094632 defendant Harper Thomas carpenter 617517 617517 Harper, Thomas, of Southwark St Olav, carpenter 0
4197363 2094632 2094632 defendant Gates John carpenter 617517 617517 Gates, John, of Southwark St Olav, carpenter 1
4199499 2095375 2095375 defendant Damper Stephen   617517 617517 Damper, Stephen, of Southwark St Olav, felt maker 0
4199500 2095375 2095375 defendant Bowmer Lambert cooper 617517 617517 Bowmer, Lambert, of Southwark St Olav, cooper 1
4211949 2099730 2099730 defendant Scrivener John   617517 617517 Scrivener, John, of Southwark St Olav, felt maker 0
4236574 2108364 2108364 defendant Hobland Peter dyer 617517 617517 Hobland, Peter, of Southwark St Olav, dyer 0
4236892 2108480 2108480 defendant Kyrbye Henry blacksmith 617517 617517 Kyrbye, Henry, of Southwark St Olav, blacksmith 0
4249084 2112678 2112678 defendant Webbe William ironmonger 617517 617517 Webbe, William, of Southwark St Olav, ironmonger 1
4259333 2116097 2116097 defendant Newes Bartholomew yeoman 617517 617517 Newes, Bartholomew, of Southwark St Olav, yeoman 0
4259334 2116097 2116097 defendant Robson William miller 617517 617517 Robson, William, of Southwark St Olav, miller 1
4259335 2116097 2116097 defendant Davyes William laborer 617517 617517 Davyes, William, of Southwark St Olav, laborer 2
4259336 2116097 2116097 defendant Taylor William laborer 617517 617517 Taylor, William, of Southwark St Olav, laborer 3
4262694 2117193 2117193 defendant Marcye or Mercye David mercer 617517 617517 Marcye or Mercye, David, of Southwark St Olav, mercer 1
4266526 2118453 2118453 defendant Westwraye Thomas brewer 617517 617517 Westwraye, Thomas, of Southwark St Olav, brewer 0
4272316 2120315 2120315 defendant Keyes Robert joiner 617517 617517 Keyes, Robert, of Southwark St Olav, joiner 1
4280160 2122968 2122968 defendant Noke John or of London, gent 617517 617517 Noke John, of Southwark St Olav, or of London, gent 0
4305986 2132232 2132232 defendant Smyth Thomas gent 617517 617517 Smyth, Thomas, of Southwark St Olav, gent 0
4312846 2134622 2134622 defendant Isacke Thomas   617517 617517 Isacke, Thomas, of Southwark St Olav, yeoman, administrators of 0
4321232 2137517 2137517 defendant Neave John smith 617517 617517 Neave, John, of Southwark St Olav, smith 0
4324891 2138710 2138710 defendant Bell William   617517 617517 Bell, William, of Southwark St Olav, felt maker 0
4330478 2140490 2140490 defendant Smythe Thomas gent 617517 617517 Smythe, Thomas, of Southwark St Olav, gent 0
4361051 2151124 2151124 defendant Bayly Edmund chapman 617517 617517 Bayly, Edmund, of Southwark St Olav, chapman 0
4394927 2162889 2162889 defendant Evans William   617517 617517 Evans, William, of Southwark St Olav, felt maker 2
4394928 2162889 2162889 defendant Gardener William smith 617517 617517 Gardener, William, of Southwark St Olav, smith 3
4396123 2163276 2163276 defendant Martyn James haberdasher 617517 617517 Martyn, James, of Southwark St Olav, haberdasher 2
4396763 2163486 2163486 defendant Standbacke Mauncell joiner 617517 617517 Standbacke, Mauncell, of Southwark St Olav, joiner 0
4410658 2168157 2168157 defendant Hughes Owen   617517 617517 Hughes, Owen, of Southwark St Olav, felt maker 0
4411718 2168514 2168514 defendant Price John   617517 617517 Price, John, of Southwark St Olav, felt maker 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);