names

20 rows where place_id = 784874

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4689335 2262225 2262225 defendant Haybergh William de yeoman 784874 784874 Haybergh, William de, of Medilton, yeoman 0
4689336 2262225 2262225 defendant Goselyng William laborer 784874 784874 Goselyng, William, of Medilton, laborer 1
4689337 2262225 2262225 defendant Lanfote Lawrence de laborer 784874 784874 Lanfote, Lawrence de, of Medilton, laborer 2
4689339 2262225 2262225 defendant del Myre Thomas yeoman 784874 784874 del Myre, Thomas, of Medilton, yeoman 4
4773875 2287808 2287808 defendant Mersshe John   784874 784874 Mersshe, John, of Medilton, shoe maker 0
4799305 2295958 2295958 defendant Mersshe John shoemaker 784874 784874 Mersshe, John, of Medilton, shoemaker 0
4819111 2302055 2302055 defendant Webster John weaver 784874 784874 Webster, John, of Medilton, weaver 9
4819686 2302232 2302232 defendant Olvere Julia single woman 784874 784874 Olvere, Julia, of Medilton, single woman 0
4895846 2325373 2325373 defendant Atkynson John yeoman 784874 784874 Atkynson, John, of Medilton, yeoman 8
4900119 2326666 2326666 defendant Hubberd Thomas husbandman 784874 784874 Hubberd, Thomas, of Medilton, husbandman 2
4901369 2327038 2327038 defendant Medilton Alexander gent 784874 784874 Medilton, Alexander, of Medilton, gent 0
4988500 2353522 2353522 defendant Hardwyk Henry yeoman 784874 784874 Hardwyk, Henry, of Medilton, yeoman 0
4988501 2353522 2353522 defendant Atkynson Robert yeoman 784874 784874 Atkynson, Robert, of Medilton, yeoman 1
4995467 2355488 2355488 defendant Hardwyk Henry yeoman 784874 784874 Hardwyk, Henry, of Medilton, yeoman 0
4995468 2355488 2355488 defendant Atkynson Robert yeoman 784874 784874 Atkynson, Robert, of Medilton, yeoman 1
5005494 2358511 2358511 defendant Hardwyk Henry yeoman 784874 784874 Hardwyk, Henry, of Medilton, yeoman 0
5005495 2358511 2358511 defendant Atkynson Robert yeoman 784874 784874 Atkynson, Robert, of Medilton, yeoman 1
5281548 2439669 2439669 defendant Turnley John smithman 784874 784874 Turnley, John, of Medilton, smithman 0
5281550 2439670 2439670 defendant Turnley John smithman 784874 784874 Turnley, John, of Medilton, smithman 0
5287449 2441353 2441353 defendant Dey John miller 784874 784874 Dey, John, of Medilton, miller 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);