names

31 rows where place_id = 605832

✎ 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
3663052 1914355 1914355 defendant Mody Thomas husbandman 605832 605832 Mody, Thomas, of Kelfeld, husbandman 0
3714385 1930796 1930796 defendant Snar or Suar Robert yeoman 605832 605832 Snar or Suar, Robert, of Kelfeld, yeoman 0
3729725 1935552 1935552 defendant Snar Robert yeoman 605832 605832 Snar, Robert, of Kelfeld, yeoman 0
3754113 1943233 1943233 defendant Carter Robert yeoman 605832 605832 Carter, Robert, of Kelfeld, yeoman 0
3754114 1943233 1943233 defendant Pattan Richard yeoman 605832 605832 Pattan, Richard, of Kelfeld, yeoman 1
3761392 1945575 1945575 defendant Snarre Robert yeoman 605832 605832 Snarre, Robert, of Kelfeld, yeoman 0
3853697 1974788 1974788 defendant Cowper Richard husbandman 605832 605832 Cowper, Richard, of Kelfeld, husbandman 0
3853700 1974788 1974788 defendant Scott John laborer 605832 605832 Scott, John, of Kelfeld, laborer 3
3877588 1982744 1982744 defendant Carter Roger husbandman 605832 605832 Carter, Roger, of Kelfeld, husbandman 0
3877589 1982744 1982744 defendant Rowgh Richard husbandman 605832 605832 Rowgh, Richard, of Kelfeld, husbandman 1
3877590 1982744 1982744 defendant Skerr Thomas laborer 605832 605832 Skerr, Thomas, of Kelfeld, laborer 2
3877591 1982744 1982744 defendant Rakys Robert husbandman 605832 605832 Rakys, Robert, of Kelfeld, husbandman 3
3987718 2020357 2020357 defendant Styllyngton Thomas gent 605832 605832 Styllyngton, Thomas, of Kelfeld, gent 0
3987722 2020358 2020358 defendant Styllyngton Thomas gent 605832 605832 Styllyngton, Thomas, of Kelfeld, gent 0
4021626 2032462 2032462 defendant Styllyngton Thomas gent 605832 605832 Styllyngton, Thomas, of Kelfeld, gent 0
4025355 2033730 2033730 defendant Wollen Thomas yeoman 605832 605832 Wollen, Thomas, of Kelfeld, or of Wekehall in Ricall, yeoman 1
4033425 2036610 2036610 defendant Carter Adam yeoman 605832 605832 Carter, Adam, of Kelfeld, yeoman 0
4532024 2210281 2210281 defendant Hobson William   605832 605832 Hobson, William, of Kelfeld 1
4668192 2255761 2255761 defendant Pryt John husbandman 605832 605832 Pryt, John, of Kelfeld, husbandman 0
4816307 2301185 2301185 defendant del Wall William husbandman 605832 605832 del Wall, William, of Kelfeld, husbandman 1
4832822 2306288 2306288 defendant Cravyn John husbandman 605832 605832 Cravyn, John, of Kelfeld, husbandman 0
4898551 2326192 2326192 defendant Robynson John husbandman 605832 605832 Robynson, John, of Kelfeld, husbandman 0
4898552 2326192 2326192 defendant Herryson Robert husbandman 605832 605832 Herryson, Robert, of Kelfeld, husbandman 1
5168851 2406619 2406619 defendant Johnson Robert yeoman 605832 605832 Johnson, Robert, of Kelfeld, yeoman 0
5185097 2411381 2411381 defendant Johnson Robert yeoman 605832 605832 Johnson, Robert, of Kelfeld, yeoman 1
5236000 2426111 2426111 defendant Hobson Robert husbandman 605832 605832 Hobson, Robert, of Kelfeld, husbandman 3
5236001 2426111 2426111 defendant Hobson William husbandman 605832 605832 Hobson, William, of Kelfeld, husbandman 4
5236006 2426112 2426112 defendant Hobson Robert husbandman 605832 605832 Hobson, Robert, of Kelfeld, husbandman 3
5236007 2426112 2426112 defendant Hobson William husbandman 605832 605832 Hobson, William, of Kelfeld, husbandman 4
5333161 2454985 2454985 plaintiff Brownflet William   605832 605832 Brownflet, William, of Kelfeld 1
5333162 2454985 2454985 defendant FitzHenry William   605832 605832 FitzHenry, William, of Kelfeld, esq, administrators of 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);