names

28 rows where place_id = 642643

✎ 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
3869160 1979934 1979934 defendant Cosen Robert husbandman 642643 642643 Cosen, Robert, of North Creke, husbandman 0
3888151 1986292 1986292 defendant Morse William husbandman 642643 642643 Morse, William, of North Creke, husbandman 0
3888152 1986292 1986292 defendant Morse Thomas husbandman 642643 642643 Morse, Thomas, of North Creke, husbandman 1
3902364 1991023 1991023 defendant Morsse William husbandman 642643 642643 Morsse, William, of North Creke, husbandman 1
3902365 1991023 1991023 defendant Morsse Thomas husbandman 642643 642643 Morsse, Thomas, of North Creke, husbandman 2
3903732 1991481 1991481 plaintiff Grey James yeoman 642643 642643 Grey, James, of North Creke, yeoman 0
3903735 1991482 1991482 plaintiff Grey James yeoman 642643 642643 Grey, James, of North Creke, yeoman 0
3928035 1999711 1999711 defendant Cosyn William yeoman 642643 642643 Cosyn, William, of North Creke, yeoman 4
3928447 1999852 1999852 defendant Morse William husbandman 642643 642643 Morse, William, of North Creke, husbandman 1
3928452 1999853 1999853 defendant Morse William husbandman 642643 642643 Morse, William, of North Creke, husbandman 1
3931531 2000845 2000845 defendant Lemen Thomas clerk 642643 642643 Lemen, Thomas, of North Creke, clerk 3
3936273 2002460 2002460 defendant Tolle James, senior husbandman 642643 642643 Tolle, James, senior, of North Creke, husbandman 0
3936274 2002460 2002460 defendant Tolle James, junior husbandman 642643 642643 Tolle, James, junior, of North Creke, husbandman 1
3953182 2008180 2008180 defendant Vowell Thomas gent 642643 642643 Vowell, Thomas, of North Creke, gent 0
3957699 2009751 2009751 defendant Greve Thomas husbandman 642643 642643 Greve, Thomas, of North Creke, husbandman 0
3975065 2015842 2015842 defendant Vowell Thomas gent 642643 642643 Vowell, Thomas, of North Creke, gent 0
3980823 2017905 2017905 defendant Knyvett Henry esq 642643 642643 Knyvett, Henry, of North Creke, esq 1
3988690 2020697 2020697 plaintiff Aslacke William gent 642643 642643 Aslacke, William, of North Creke, gent 0
3988692 2020698 2020698 plaintiff Aslacke William gent 642643 642643 Aslacke, William, of North Creke, gent 0
4033770 2036727 2036727 defendant Manser John yeoman 642643 642643 Manser, John, of North Creke, yeoman 4
4039626 2038783 2038783 defendant Craye James yeoman 642643 642643 Craye, James, of North Creke, yeoman 0
4057958 2045226 2045226 defendant Brampton Francis gent 642643 642643 Brampton, Francis, of North Creke, gent 1
4996257 2355736 2355736 defendant Deyn Reginald yeoman 642643 642643 Deyn, Reginald, of North Creke, yeoman 2
5550385 2520131 2520131 defendant Manser John husbandman 642643 642643 Manser, John, of North Creke, husbandman 0
5553617 2521092 2521092 defendant Grey Richard husbandman 642643 642643 Grey, Richard, of North Creke, husbandman 1
5553620 2521093 2521093 defendant Grey Richard husbandman 642643 642643 Grey, Richard, of North Creke, husbandman 1
5561245 2523273 2523273 defendant Dynne William esq 642643 642643 Dynne, William, of North Creke, esq 0
5561252 2523274 2523274 defendant Dynne William esq 642643 642643 Dynne, William, of North Creke, esq 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);