names

31 rows where place_id = 614220

✎ 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
3702518 1927054 1927054 defendant Fygg Arthur yeoman 614220 614220 Fygg, Arthur, of Ancastre, yeoman 0
3803493 1958997 1958997 defendant Cotton William husbandman 614220 614220 Cotton, William, of Ancastre, husbandman 1
3803496 1958998 1958998 defendant Cotton William husbandman 614220 614220 Cotton, William, of Ancastre, husbandman 1
3903925 1991551 1991551 defendant Dobleday Thomas yeoman 614220 614220 Dobleday, Thomas, of Ancastre, yeoman 0
4440633 2181981 2181981 defendant Wytelefe John   614220 614220 Wytelefe, John, of Ancastre 0
4485405 2196139 2196139 plaintiff Quaryour Robert   614220 614220 Quaryour, Robert, of Ancastre 0
4501737 2201142 2201142 defendant Lyon John   614220 614220 Lyon, John, of Ancastre 5
4526785 2208655 2208655 defendant Tebaude John   614220 614220 Tebaude, John, of Ancastre 0
4662035 2249600 2249600 defendant Whitewell John yeoman 614220 614220 Whitewell, John, of Ancastre, yeoman 1
4696128 2264272 2264272 defendant Litstar Henry dyer or litstar 614220 614220 Litstar, Henry, of Ancastre, dyer or litstar 0
4718773 2271214 2271214 defendant Clerk William yeoman 614220 614220 Clerk, William, of Ancastre, yeoman 0
4718774 2271214 2271214 defendant Lutton Robert husbandman 614220 614220 Lutton, Robert, of Ancastre, husbandman 1
4747730 2279845 2279845 defendant Mason Richard   614220 614220 Mason, Richard, of Ancastre, mason 0
5025884 2364467 2364467 defendant Semere John, junior husbandman 614220 614220 Semere, John, junior, of Ancastre, husbandman 0
5027900 2365039 2365039 defendant May Thomas   614220 614220 May, Thomas, of Ancastre, bailiff 1
5034487 2366946 2366946 defendant Somer John, senior yeoman 614220 614220 Somer, John, senior, of Ancastre, yeoman 0
5034488 2366946 2366946 defendant Somer John, junior husbandman 614220 614220 Somer, John, junior, of Ancastre, husbandman 1
5293544 2443081 2443081 defendant Person Robert clerk 614220 614220 Person, Robert, of Ancastre, clerk 0
5293546 2443081 2443081 defendant Flecher Alice widow 614220 614220 (Flecher, Alice, of Ancastre, widow 2
5293547 2443081 2443081 defendant Fleccher John laborer 614220 614220 Fleccher, John, of Ancastre, laborer 3
5293549 2443082 2443082 defendant Person Robert clerk 614220 614220 Person, Robert, of Ancastre, clerk 0
5293551 2443082 2443082 defendant Flecher Alice widow 614220 614220 (Flecher, Alice, of Ancastre, widow 2
5293552 2443082 2443082 defendant Flecher John laborer 614220 614220 Flecher, John, of Ancastre, laborer 3
5320774 2451303 2451303 defendant Skelyngton John yeoman 614220 614220 Skelyngton, John, of Ancastre, yeoman 3
5348688 2459720 2459720 defendant Calnar or Calvar Richard   614220 614220 Calnar or Calvar, Richard, of Ancastre, yeoman, bailiff of Wymbred wapentake 0
5348692 2459721 2459721 defendant Calvar or Calnar Richard   614220 614220 Calvar or Calnar, Richard, of Ancastre, yeoman, bailiff of Wynybred and Threhous 0
5461227 2493305 2493305 defendant Motkyn Nicholas ostler 614220 614220 Motkyn, Nicholas, of Ancastre, ostler 2
5472776 2496823 2496823 defendant Motkyn Nicholas ostler 614220 614220 Motkyn, Nicholas, of Ancastre, ostler 2
5472782 2496824 2496824 defendant Motkyn Nicholas ostler 614220 614220 Motkyn, Nicholas, of Ancastre, ostler 2
5472788 2496825 2496825 defendant Motkyn Nicholas ostler 614220 614220 Motkyn, Nicholas, of Ancastre, ostler 2
5615888 2548769 2548769 defendant Spur Hugh   614220 614220 Spur, Hugh, of Ancastre 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);