names

18 rows where case_id = 2353438

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4988163 2353438 2353438 plaintiff Boteler Ralph knight   Boteler, Ralph, knight 0
4988164 2353438 2353438 plaintiff Beauchamp John knight   Beauchamp, John, knight 1
4988165 2353438 2353438 plaintiff Mountford William knight   Mountford, William, knight 2
4988166 2353438 2353438 plaintiff Norreys John     Norreys, John 3
4988167 2353438 2353438 plaintiff Nanfan John esq   Nanfan, John, esq 4
4988168 2353438 2353438 plaintiff Menston William     Menston, William 5
4988169 2353438 2353438 defendant Wexman Richard   620555 620555 Wexman, Richard, of Crekelade, Wilts, wax maker 0
4988170 2353438 2353438 defendant Teyntour John weaver 609101 609101 Teyntour, John, of Crekelade, weaver 1
4988171 2353438 2353438 defendant Monke George husbandman 831147 831147 Monke, George, of Merston Maysy, Wilts, husbandman 2
4988172 2353438 2353438 defendant Legger John husbandman 831148 831148 Legger, John, of Merston Maysy, husbandman 3
4988173 2353438 2353438 defendant Legger William jun, of Merston Maysy, husbandman   Legger, William, jun, of Merston Maysy, husbandman 4
4988174 2353438 2353438 defendant Maysy Thomas husbandman 831149 831149 Maysy, Thomas, of Sowtherop, Gloucs, husbandman 5
4988175 2353438 2353438 defendant Edward John husbandman 765176 765176 Edward, John, of Lechlade, husbandman 6
4988176 2353438 2353438 defendant Jamner Richard baker 633753 633753 Jamner, Richard, of Lechelade, baker 7
4988177 2353438 2353438 defendant Wheler John   633753 633753 Wheler, John, of Lechelade, wheel wright 8
4988178 2353438 2353438 defendant Joby Henry laborer 633753 633753 Joby, Henry, of Lechelade, laborer 9
4988179 2353438 2353438 defendant Chambrere William   633753 633753 Chambrere, William,of Lechelade, pedlar 10
4988180 2353438 2353438 defendant Shepherd Henry laborer 765176 765176 Shepherd, Henry, of Lechlade, laborer 11

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);