names

40 rows where place_id = 776392

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4633282 2241276 2241276 defendant Richardson John   776392 776392 Richardson, John, of Lynstok 14
4659488 2248826 2248826 defendant Wyrell Robert yeoman 776392 776392 Wyrell, Robert, of Lynstok, yeoman 2
4659500 2248827 2248827 defendant Wyrell Robert yeoman 776392 776392 Wyrell, Robert, of Lynstok, yeoman 3
4721282 2271987 2271987 defendant Collane Thomas yeoman 776392 776392 Collane, Thomas, of Lynstok, yeoman 0
4803750 2297356 2297356 defendant Grave or Grame Thomas gent 776392 776392 Grave or Grame, Thomas, of Lynstok, gent 0
4811708 2299770 2299770 defendant Bartonman Thomas husbandman 776392 776392 with Bartonman, Thomas, of Lynstok, husbandman 1
4816188 2301148 2301148 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 0
4818048 2301721 2301721 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 2
4818051 2301722 2301722 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 1
4824756 2303789 2303789 defendant Grame Thomas esq 776392 776392 Grame, Thomas, of Lynstok, esq 0
4824758 2303790 2303790 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 0
4824817 2303801 2303801 defendant Stevenson William yeoman 776392 776392 Stevenson, William, of Lynstok, yeoman 2
4824823 2303801 2303801 defendant Nicolson Thomas, junior yeoman 776392 776392 Nicolson, Thomas, junior, of Lynstok, yeoman 8
4850773 2311693 2311693 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 0
4850799 2311699 2311699 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 0
4850800 2311699 2311699 defendant Grame John gent 776392 776392 Grame, John, of Lynstok, gent 1
4907109 2328788 2328788 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 2
4907110 2328788 2328788 defendant Grame John gent 776392 776392 Grame, John, of Lynstok, gent 3
4907111 2328788 2328788 defendant Nicholson Robert yeoman 776392 776392 Nicholson, Robert, of Lynstok, yeoman 4
4907112 2328788 2328788 defendant Rosse John yeoman 776392 776392 Rosse, John, of Lynstok, yeoman 5
4907113 2328788 2328788 defendant Richardson John yeoman 776392 776392 Richardson, John, of Lynstok, yeoman 6
4907114 2328788 2328788 defendant Richardson Richard yeoman 776392 776392 Richardson, Richard, of Lynstok, yeoman 7
4907115 2328788 2328788 defendant Richardson Thomas yeoman 776392 776392 Richardson, Thomas, of Lynstok, yeoman 8
4907116 2328788 2328788 defendant Blaykeloc Robert yeoman 776392 776392 Blaykeloc, Robert, of Lynstok, yeoman 9
4907117 2328788 2328788 defendant Blaykelok Simon yeoman 776392 776392 Blaykelok, Simon, of Lynstok, yeoman 10
4907118 2328788 2328788 defendant Blaykeloc John yeoman 776392 776392 Blaykeloc, John, of Lynstok, yeoman 11
4907119 2328788 2328788 defendant Rokell John yeoman 776392 776392 Rokell, John, of Lynstok, yeoman 12
4907120 2328788 2328788 defendant Nicholason Richard yeoman 776392 776392 Nicholason, Richard, of Lynstok, yeoman 13
4969216 2347754 2347754 defendant Grame or Graine John gent 776392 776392 Grame or Graine, John, of Lynstok, gent 0
4969217 2347754 2347754 defendant Laycok Robert husbandman 776392 776392 Laycok, Robert, of Lynstok, husbandman 1
4969218 2347754 2347754 defendant Richardson Richard yeoman 776392 776392 Richardson, Richard, of Lynstok, yeoman 2
4975538 2349645 2349645 defendant Laton John gent 776392 776392 Laton, John, of Lynstok, gent 17
4975539 2349645 2349645 defendant Blakelok Robert yeoman 776392 776392 Blakelok, Robert, of Lynstok, yeoman 18
4975540 2349645 2349645 defendant Blakelok John yeoman 776392 776392 Blakelok, John, of Lynstok, yeoman 19
4975541 2349645 2349645 defendant Blakelok Paton yeoman 776392 776392 Blakelok, Paton, of Lynstok, yeoman 20
4975542 2349645 2349645 defendant Richardson Richard yeoman 776392 776392 Richardson, Richard, of Lynstok, yeoman 21
4975543 2349645 2349645 defendant Nicolson Robert yeoman 776392 776392 Nicolson, Robert, of Lynstok, yeoman 22
5006807 2358892 2358892 defendant Grame John yeoman 776392 776392 Grame, John, of Lynstok, yeoman 0
5573554 2526829 2526829 defendant Nicolson James yeoman 776392 776392 Nicolson, James, of Lynstok, yeoman 0
5632191 2554093 2554093 defendant Collan John yeoman 776392 776392 Collan, John, of Lynstok, yeoman 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);