names

51 rows where place_id = 591316

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604047 1868934 1868934 defendant Laverok John yeoman 591316 591316 Laverok, John, of Salle, Norf, yeoman 0
3720716 1932771 1932771 defendant Haydon Christopher   591316 591316 Haydon, Christopher, of Salle, Norf, knight 0
3931192 2000724 2000724 defendant Stone William draper 591316 591316 Stone, William, of Salle, Norf, draper 0
3958781 2010148 2010148 defendant Crane Thomas laborer 591316 591316 Crane, Thomas, of Salle, Norf, laborer 5
4722730 2272426 2272426 defendant Rook William mercer 591316 591316 Rook, William, of Salle, Norf, mercer 0
4744260 2278844 2278844 defendant Rook William husbandman 591316 591316 Rook, William, of Salle, Norf, husbandman 0
4817140 2301452 2301452 defendant Roke William mercer 591316 591316 Roke, William, of Salle, Norf, mercer 1
4826693 2304382 2304382 defendant Rook William chapman 591316 591316 Rook, William, of Salle, Norf, chapman 2
4894254 2324889 2324889 defendant Botte alias Farewell John   591316 591316 Botte alias Farewell, John, of Salle, Norf, mason 0
4908350 2329166 2329166 defendant Godeman Geoffrey chapman 591316 591316 Godeman, Geoffrey, of Salle, Norf, chapman 1
4927473 2335028 2335028 plaintiff Ryghtwys Thomas chapman 591316 591316 Ryghtwys, Thomas, of Salle, Norf, chapman 0
5023151 2363672 2363672 defendant Albon Thomas raffman 591316 591316 Albon, Thomas, of Salle, Norf, raffman 0
5027576 2364942 2364942 defendant Kysse Thomas merchant 591316 591316 Kysse, Thomas, of Salle, Norf, merchant 2
5124904 2393759 2393759 defendant Bolman John yeoman 591316 591316 Bolman, John, of Salle, Norf, yeoman 3
5126876 2394337 2394337 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 6
5127092 2394402 2394402 defendant Couper Robert chapman 591316 591316 Couper, Robert, of Salle, Norf, chapman 0
5129470 2395104 2395104 defendant Funteyn Thomas yeoman 591316 591316 Funteyn, Thomas, of Salle, Norf, yeoman 0
5133086 2396162 2396162 defendant Albon Thomas husbandman 591316 591316 Albon, Thomas, of Salle, Norf, husbandman 2
5136388 2397161 2397161 defendant Seggeford John yeoman 591316 591316 Seggeford, John, of Salle, Norf, yeoman 0
5139060 2397916 2397916 defendant Beyton or Ceyton Thomas gent 591316 591316 Beyton or Ceyton, Thomas, of Salle, Norf, gent 0
5139065 2397917 2397917 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 0
5148407 2400666 2400666 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 2
5148411 2400667 2400667 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 2
5156763 2403136 2403136 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 0
5156785 2403142 2403142 defendant Sedgeford John yeoman 591316 591316 Sedgeford, John, of Salle, Norf, yeoman 0
5159934 2404002 2404002 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 0
5164724 2405416 2405416 defendant Bolman John yeoman 591316 591316 Bolman, John, of Salle, Norf, yeoman 3
5167695 2406271 2406271 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 2
5170164 2407003 2407003 defendant Albon Thomas husbandman 591316 591316 Albon, Thomas, of Salle, Norf, husbandman 2
5183289 2410854 2410854 defendant Geyton Thomas gent 591316 591316 Geyton, Thomas, of Salle, Norf, gent 1
5187619 2412094 2412094 defendant Albon Thomas husbandman 591316 591316 Albon, Thomas, of Salle, Norf, husbandman 2
5192670 2413591 2413591 defendant Sedgeford John yeoman 591316 591316 Sedgeford, John, of Salle, Norf, yeoman 0
5232726 2425152 2425152 defendant Seggeford John kerchiefman 591316 591316 Seggeford, John, of Salle, Norf, kerchiefman 0
5308261 2447503 2447503 plaintiff Ryghtwyse Thomas   591316 591316 Ryghtwyse, Thomas, of Salle, Norf 0
5321407 2451496 2451496 defendant Laverok or Lanerok Geoffrey chaplman 591316 591316 Laverok or Lanerok, Geoffrey, of Salle, Norf, chaplman 0
5379794 2469263 2469263 defendant Bartilmewe Thomas   591316 591316 Bartilmewe, Thomas, of Salle, Norf 0
5380972 2469614 2469614 defendant Totehyll Thomas husbandman 591316 591316 Totehyll, Thomas, of Salle, Norf, husbandman 4
5387121 2471385 2471385 defendant Totehyll Thomas husbandman 591316 591316 Totehyll, Thomas, of Salle, Norf, husbandman 4
5394543 2473498 2473498 defendant Brygg Thomas gent 591316 591316 Brygg, Thomas, of Salle, Norf, gent 0
5407761 2477297 2477297 defendant Bryggys Thomas gent 591316 591316 Bryggys, Thomas, of Salle, Norf, gent 0
5418260 2480388 2480388 defendant Bartylmeweys Thomas yeoman 591316 591316 Bartylmeweys, Thomas, of Salle, Norf, yeoman 0
5420997 2481209 2481209 defendant Brygges Thomas gent 591316 591316 Brygges, Thomas, of Salle, Norf, gent 0
5423142 2481881 2481881 defendant Brygge John, sen (legal representative) 591316 591316 Brygge, John, sen, of Salle, Norf, yeoman, executors of 0
5423143 2481881 2481881 defendant Gryffyth William husbandman 591316 591316 (Gryffyth, William, of Salle, Norf, husbandman 1
5424848 2482392 2482392 defendant Funteyn William yeoman 591316 591316 Funteyn, William, of Salle, Norf, yeoman 0
5435678 2485608 2485608 defendant Ryghtwys John gent 591316 591316 Ryghtwys, John, of Salle, Norf, gent 6
5436150 2485749 2485749 defendant Bartilmewe Thomas kercheman or yeoman 591316 591316 Bartilmewe, Thomas, of Salle, Norf, kercheman or yeoman 0
5436292 2485791 2485791 defendant Bartilmewe Thomas mercer 591316 591316 Bartilmewe, Thomas, of Salle, Norf, mercer 0
5436297 2485792 2485792 defendant Funteyn John husbandman 591316 591316 (Funteyn, John, of Salle, Norf, husbandman 1
5442571 2487694 2487694 defendant Brygge John, sen (legal representative) 591316 591316 Brygge, John, sen, of Salle, Norf, yeoman, executors of 0
5462776 2493775 2493775 defendant Ryghtwys John gent 591316 591316 Ryghtwys, John, of Salle, Norf, gent 4

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);