names

32 rows where place_id = 608145

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672369 1917361 1917361 defendant Magior John saddler 608145 608145 Magior, John, of Southwark, Surrey, saddler 0
4013271 2029479 2029479 defendant Lawrymer Mark butcher 608145 608145 Lawrymer, Mark, of Southwark, Surrey, butcher 0
4013273 2029480 2029480 defendant Lawrymer Martin butcher 608145 608145 Lawrymer, Martin, of Southwark, Surrey, butcher 0
4013912 2029707 2029707 defendant Crane Nicholas   608145 608145 Crane, Nicholas, of Southwark, Surrey, surgeon 0
4021066 2032257 2032257 defendant Butler Edmund yeoman 608145 608145 Butler, Edmund, of Southwark, Surrey, yeoman 0
4021068 2032258 2032258 defendant Butler Edmund yeoman 608145 608145 Butler, Edmund, of Southwark, Surrey, yeoman 0
4034610 2037053 2037053 defendant Alyston or Ellystone George, junior   608145 608145 Alyston or Ellystone, George, junior, of Southwark, Surrey, linen drapee 0
4034612 2037054 2037054 defendant Alyston George, junior   608145 608145 Alyston, George, junior, of Southwark, Surrey, linen draper 0
4034713 2037096 2037096 defendant Aldredge John gent 608145 608145 Aldredge, John, of Southwark, Surrey, gent 3
4034718 2037097 2037097 defendant Aldridge John gent 608145 608145 Aldridge, John, of Southwark, Surrey, gent 3
4048958 2042069 2042069 defendant Nelson William yeoman 608145 608145 Nelson, William, of Southwark, Surrey, yeoman 0
4065335 2047887 2047887 defendant Lodwyck Henry   608145 608145 Lodwyck, Henry, of Southwark, Surrey, coppersmith 0
4067289 2048602 2048602 defendant Banck John   608145 608145 Banck, John, of Southwark, Surrey, nailer, or of Hallesowen 0
4097379 2059383 2059383 defendant Elyston or Alyston George   608145 608145 Elyston or Alyston, George, of Southwark, Surrey, linen draper 0
4106413 2062586 2062586 defendant Jaques Thomas baker 608145 608145 Jaques, Thomas, of Southwark, Surrey, baker 0
4115382 2065790 2065790 defendant Heath James miller 608145 608145 Heath, James, of Southwark, Surrey, miller 0
4115400 2065794 2065794 defendant Weston Vann grocer 608145 608145 Weston, Vann, of Southwark, Surrey, grocer 0
4221970 2103176 2103176 defendant Cartwrighte James baker 608145 608145 Cartwrighte, James, of Southwark, Surrey, baker 0
4221972 2103177 2103177 defendant Cartwrighte James baker 608145 608145 Cartwrighte, James, of Southwark, Surrey, baker 0
4235441 2107964 2107964 defendant Stubbes John beer brewer 608145 608145 Stubbes, John, of Southwark, Surrey, beer brewer 1
4265237 2118013 2118013 defendant Fowle Edward gent 608145 608145 Fowle, Edward, of Southwark, Surrey ,gent 0
4328427 2139822 2139822 defendant Hogge Robert victualer 608145 608145 Hogge, Robert, of Southwark, Surrey, victualer 0
4331831 2140937 2140937 defendant Ballard Edmund gent 608145 608145 Ballard, Edmund, of Southwark, Surrey, gent 2
4357672 2149918 2149918 defendant Stockdell Leonard   608145 608145 Stockdell, Leonard, of Southwark, Surrey, feltmaker, or of London, son of Brian Stockdaile, of Thriske 0
4372459 2155219 2155219 defendant Wood John, senior butcher 608145 608145 Wood, John, senior, of Southwark, Surrey, butcher 0
4374376 2155902 2155902 defendant Frye Christopher   608145 608145 Frye, Christopher, of Southwark, Surrey, cook 1
4665681 2250736 2250736 defendant Drake John clerk 608145 608145 Drake, John, of Southwark, Surrey, clerk 0
4828488 2304950 2304950 defendant Dorset William gent 608145 608145 Dorset, William, of Southwark, Surrey, gent 0
4989690 2353834 2353834 defendant Polle Richard clerk 608145 608145 Polle, Richard, of Southwark, Surrey, clerk 0
5001904 2357455 2357455 defendant Tounley William gent 608145 608145 Tounley, William, of Southwark, Surrey, gent 3
5626671 2552315 2552315 defendant Spellowe Robert   608145 608145 Spellowe, Robert, of Southwark, Surrey, esquire at arms 0
5633507 2554475 2554475 defendant Boteler William husbandman 608145 608145 Boteler, William, of Southwark, Surrey, husbandman 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);