names

37 rows where place_id = 601684

✎ 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
3646502 1909304 1909304 defendant Chapman Philip clothman 601684 601684 Chapman, Philip, of Lemster, Herefs, clothman 0
3646504 1909305 1909305 defendant Chapman Philip clothman 601684 601684 Chapman, Philip, of Lemster, Herefs, clothman 0
3844089 1971698 1971698 defendant Skarlett Richard chapman 601684 601684 Skarlett, Richard, of Lemster, Herefs, chapman 2
3888945 1986546 1986546 defendant Carpenter Richard butcher 601684 601684 Carpenter, Richard, of Lemster, Herefs, butcher 0
3947073 2006041 2006041 defendant Baker John chapman 601684 601684 (Baker, John, of Lemster, Herefs, chapman 1
3953011 2008121 2008121 defendant Morrys Philip chapman 601684 601684 Morrys, Philip, of Lemster, Herefs, chapman 1
3954712 2008712 2008712 defendant Moris Philip draper 601684 601684 Moris, Philip, of Lemster, Herefs, draper 0
3962047 2011308 2011308 defendant Edward Thomas mercer 601684 601684 (Edward, Thomas, of Lemster, Herefs, mercer 1
3971352 2014538 2014538 defendant Baker John yeoman 601684 601684 Baker, John, of Lemster, Herefs, yeoman 1
4084489 2054728 2054728 defendant Perryn Thomas leather seller 601684 601684 Perryn, Thomas, of Lemster, Herefs, leather seller 0
4100499 2060504 2060504 defendant Creswell John gent 601684 601684 Creswell, John, of Lemster, Herefs, gent 0
4160756 2081840 2081840 defendant Peryn Thomas yeoman 601684 601684 Peryn, Thomas, of Lemster or Leominster, Herefs, yeoman 0
4160758 2081841 2081841 defendant Stevens Thomas yeoman 601684 601684 Stevens, Thomas, of Lemster, Herefs, yeoman 0
4208025 2098367 2098367 defendant Stevens Thomas yeoman 601684 601684 Stevens, Thomas, of Lemster, Herefs, yeoman 0
4398852 2164197 2164197 defendant Lane Richard chapman 601684 601684 Lane, Richard, of Lemster, Herefs, chapman 1
4891470 2324066 2324066 defendant Morton Thomas barker 601684 601684 Morton, Thomas, of Lemster, Herefs, barker 0
5079323 2380314 2380314 defendant Seynt John chapman 601684 601684 Seynt, John, of Lemster, Herefs, chapman 3
5243858 2428397 2428397 defendant Bocher Walter yeoman 601684 601684 Bocher, Walter, of Lemster, Herefs, yeoman 0
5250660 2430315 2430315 defendant Dyer alias Spenser William dyer 601684 601684 Dyer alias Spenser, William, of Lemster, Herefs, dyer 1
5250664 2430316 2430316 defendant Dyer alias Spenser William dyer 601684 601684 Dyer alias Spenser, William, of Lemster, Herefs, dyer 0
5271532 2436768 2436768 defendant Forest John clothman 601684 601684 Forest, John, of Lemster, Herefs, clothman 2
5274722 2437683 2437683 defendant Redyg Fylpolt chapman 601684 601684 Redyg, Fylpolt, of Lemster, Herefs, chapman 4
5275706 2437959 2437959 defendant Stevenson Alexander glover 601684 601684 Stevenson, Alexander, of Lemster, Herefs, glover 3
5285561 2440798 2440798 defendant Forest John clothman 601684 601684 Forest, John, of Lemster, Herefs, clothman 1
5310495 2448175 2448175 defendant Baret Thomas chapman 601684 601684 Baret, Thomas, of Lemster, Herefs, chapman 0
5355007 2461636 2461636 defendant Jones Philip cordwainer 601684 601684 Jones, Philip, of Lemster, Herefs, cordwainer 0
5381310 2469709 2469709 defendant Caryour John carrier 601684 601684 Caryour, John, of Lemster, Herefs, carrier 0
5505681 2506697 2506697 defendant Chatwall Elizabeth widow 601684 601684 Chatwall, Elizabeth, of Lemster, Herefs, widow 0
5505685 2506698 2506698 defendant Chatwall Elizabeth widow 601684 601684 Chatwall, Elizabeth, of Lemster, Herefs, widow 0
5529865 2513847 2513847 defendant Werrall Henry chapman 601684 601684 Werrall, Henry, of Lemster, Herefs, chapman 0
5529871 2513848 2513848 defendant Werrall Henry chapman 601684 601684 Werrall, Henry, of Lemster, Herefs, chapman 0
5574299 2527051 2527051 defendant Sebryght Humphrey chapman 601684 601684 Sebryght, Humphrey, of Lemster, Herefs, chapman 4
5574301 2527052 2527052 defendant Sebright Humphrey chapman 601684 601684 Sebright, Humphrey, of Lemster, Herefs, chapman 0
5584399 2530183 2530183 defendant Scarlet William chapman 601684 601684 Scarlet, William, of Lemster, Herefs, chapman 0
5591229 2532229 2532229 defendant Chapman John chapman 601684 601684 Chapman, John, of Lemster, Herefs, chapman 0
5591237 2532230 2532230 defendant Chapman Philip chapman 601684 601684 Chapman, Philip, of Lemster, Herefs, chapman 0
5608857 2537671 2537671 defendant Caryour John carrier 601684 601684 Caryour, John, of Lemster, Herefs, carrier 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);