names

20 rows where place_id = 612329

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692714 1923909 1923909 defendant Dernold Richard yeoman 612329 612329 Dernold, Richard, of Aylton, Hunts, yeoman 2
3754642 1943409 1943409 defendant Sapcote Richard esq 612329 612329 Sapcote, Richard, of Aylton, Hunts, esq 0
3824208 1965450 1965450 defendant Sapcottys Richard esq 612329 612329 Sapcottys, Richard, of Aylton, Hunts, esq 3
3859707 1976747 1976747 defendant Sapcotte Richard   612329 612329 Sapcotte, Richard, of Aylton, Hunts, knight 0
3868481 1979697 1979697 defendant Sapcot Richard   612329 612329 Sapcot, Richard, of Aylton, Hunts, knight 0
3883369 1984702 1984702 defendant Sapcote Richard   612329 612329 Sapcote, Richard, of Aylton, Hunts, knight 0
3940920 2003970 2003970 defendant Sandys Edward gent 612329 612329 Sandys, Edward, of Aylton, Hunts, gent 0
3947681 2006249 2006249 defendant Hyckeson John (legal representative) 612329 612329 Hyckeson, John, of Aylton, Hunts, yeoman, executors of 0
3982424 2018486 2018486 defendant Vyners Robert husbandman 612329 612329 Vyners, Robert, of Aylton, Hunts, husbandman 0
3988139 2020502 2020502 defendant Ivers Robert husbandman 612329 612329 Ivers, Robert, of Aylton, Hunts, husbandman 0
4015442 2030219 2030219 defendant Sapcotes Robert esq 612329 612329 Sapcotes, Robert, of Aylton, Hunts, esq 0
4374432 2155923 2155923 defendant Sapcot Robert esq 612329 612329 Sapcot, Robert, of Aylton, Hunts, esq 0
5055573 2373242 2373242 defendant Welles John mercer 612329 612329 Welles, John, of Aylton, Hunts, mercer 2
5404734 2476433 2476433 defendant Robynson John husbandman 612329 612329 Robynson, John, of Aylton, Hunts, husbandman 2
5417627 2480191 2480191 defendant Smyth Philip   612329 612329 Smyth, Philip, of Aylton, Hunts 1
5417658 2480205 2480205 defendant Robynson John husbandman 612329 612329 Robynson, John, of Aylton, Hunts, husbandman 0
5435039 2485409 2485409 defendant Smyth Philip yeoman 612329 612329 Smyth, Philip, of Aylton, Hunts, yeoman 1
5435419 2485534 2485534 defendant Robynson John husbandman 612329 612329 Robynson, John, of Aylton, Hunts, husbandman 0
5435423 2485535 2485535 defendant Robynson Thomas husbandman 612329 612329 Robynson, Thomas, of Aylton, Hunts, husbandman 1
5482649 2499755 2499755 defendant Robynson John husbandman 612329 612329 Robynson, John, of Aylton, Hunts, husbandman 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);