names

21 rows where place_id = 664314

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3972357 2014904 2014904 plaintiff Fyske Ambrose yeoman 664314 664314 Fyske, Ambrose, of Well juxta Mare, yeoman 0
3972359 2014905 2014905 plaintiff Fyske Ambrose yeoman 664314 664314 Fyske, Ambrose, of Well juxta Mare, yeoman 0
3972361 2014906 2014906 plaintiff Fyske Ambrose yeoman 664314 664314 Fyske, Ambrose, of Well juxta Mare, yeoman 0
3982296 2018439 2018439 plaintiff Sabbes William mariner 664314 664314 Sabbes William, of Well juxta Mare, mariner 0
3982298 2018440 2018440 plaintiff Sabbs William   664314 664314 Sabbs, William, of Well juxta Mare, ship master 0
3998338 2024144 2024144 plaintiff Farye John mariner 664314 664314 Farye, John, of Well juxta Mare, mariner 0
3998339 2024144 2024144 defendant Brigg John husbandman 664314 664314 Brigg, John, of Well juxta Mare, husbandman 0
4010822 2028646 2028646 defendant Grene Thomas baker 664314 664314 Grene, Thomas, of Well juxta Mare, baker 1
4021509 2032420 2032420 defendant Farye William meriner 664314 664314 Farye, William, of Well juxta Mare, meriner 1
4036971 2037897 2037897 plaintiff Jarys Robert yeoman 664314 664314 Jarys, Robert, of Well juxta Mare, yeoman 0
4067525 2048701 2048701 plaintiff Jarye Robert yeoman 664314 664314 Jarye, Robert, of Well juxta Mare, yeoman 0
4180018 2088487 2088487 defendant Matchett Giles cordwainer 664314 664314 Matchett, Giles, of Well juxta Mare, or of Claye juxta Mare, cordwainer 0
4203420 2096748 2096748 defendant Matchet Giles cordwainer 664314 664314 Matchet, Giles, of Well juxta Mare, or of Claye juxta Mare, cordwainer 0
4204219 2097025 2097025 defendant Frary John yeoman 664314 664314 Frary, John, of Well juxta Mare, yeoman 3
4220912 2102809 2102809 defendant Tydd William yeoman 664314 664314 Tydd, William, of Well juxta Mare, yeoman 0
4257014 2115319 2115319 defendant Odder John butcher 664314 664314 Odder, John, of Well juxta Mare, butcher 1
4341468 2144292 2144292 defendant Farye William mariner 664314 664314 Farye, William, of Well juxta Mare, mariner 0
4354793 2148898 2148898 defendant Sabbe William yeoman 664314 664314 Sabbe, William, of Well juxta Mare, yeoman 0
4381882 2158622 2158622 defendant Cappyn or Cappell Ralph husbandman 664314 664314 Cappyn or Cappell, Ralph, of Well juxta Mare, husbandman 0
4401492 2165094 2165094 defendant Barwicke John mariner 664314 664314 Barwicke, John, of Well juxta Mare, mariner 1
5326384 2452976 2452976 defendant Burgony Hugh husbandman 664314 664314 Burgony, Hugh, of Well juxta Mare, husbandman 1

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