names

12 rows where case_id = 2314271

✎ 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
4859252 2314271 2314271 plaintiff Calton Nicholas clerk   Calton, Nicholas, clerk 0
4859253 2314271 2314271 defendant Brid Robert tanner 813848 813848 Brid, Robert, of Mulverton, Soms, tanner 0
4859254 2314271 2314271 defendant Hurdyng William shoemaker 598982 598982 Hurdyng, William, of Mulverton, shoemaker 1
4859255 2314271 2314271 defendant Roo William carpenter 598982 598982 Roo, William, of Mulverton, carpenter 2
4859256 2314271 2314271 defendant Savage Thomas clerk 598982 598982 Savage, Thomas, of Mulverton, clerk 3
4859257 2314271 2314271 defendant Bocher William husbandman 744136 744136 Bocher, William, of Wyvelescombe, Soms, husbandman 4
4859258 2314271 2314271 defendant Combe Walter husbandman 813849 813849 Combe, Walter, of Haglegh, Soms, husbandman 5
4859259 2314271 2314271 defendant Aldeway John, senior tanner 598982 598982 Aldeway, John, senior, of Mulverton, tanner 6
4859260 2314271 2314271 defendant Wyvelescombe William shoemaker 598982 598982 Wyvelescombe, William, of Mulverton, shoemaker 7
4859261 2314271 2314271 defendant Rendall John laborer 598982 598982 Rendall, John, of Mulverton, laborer 8
4859262 2314271 2314271 defendant Wille John laborer 598982 598982 Wille, John, of Mulverton, laborer 9
4859263 2314271 2314271 defendant Aldeway John, junior laborer 598982 598982 Aldeway, John, junior, of Mulverton, laborer 10

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