names

15 rows where case_id = 2361921

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5017181 2361921 2361921 plaintiff Cervyngton David esq   Cervyngton, David, esq 0
5017182 2361921 2361921 defendant Jones Edward dyer 602520 602520 Jones, Edward, of Castel Combe, dyer 0
5017183 2361921 2361921 defendant Dytton Richard fuller 602520 602520 Dytton, Richard, of Castel Combe, fuller 1
5017184 2361921 2361921 defendant Boys Robert weaver 602520 602520 Boys, Robert, of Castel Combe, weaver 2
5017185 2361921 2361921 defendant Deny Thomas cordwainer 602520 602520 Deny, Thomas, of Castel Combe, cordwainer 3
5017186 2361921 2361921 defendant Haynys Thomas fuller 602520 602520 Haynys, Thomas, of Castel Combe, fuller 4
5017187 2361921 2361921 defendant Benet Robert weaver 602520 602520 Benet, Robert, of Castel Combe, weaver 5
5017188 2361921 2361921 defendant Seman John qweaver 602520 602520 Seman, John, of Castel Combe, qweaver 6
5017189 2361921 2361921 defendant Stevenes John weaver 602520 602520 Stevenes, John, of Castel Combe, weaver 7
5017190 2361921 2361921 defendant Webley John dyer 602520 602520 Webley, John, of Castel Combe, dyer 8
5017191 2361921 2361921 defendant Gederygge John   602520 602520 Gederygge, John, of Castel Combe, servant 9
5017192 2361921 2361921 defendant Burgeys William weaver 602520 602520 Burgeys, William, of Castel Combe, weaver 10
5017193 2361921 2361921 defendant Marchall John baker 602520 602520 Marchall, John, of Castel Combe, baker 11
5017194 2361921 2361921 defendant Glover John glover 602520 602520 Glover, John, of Castel Combe, glover 12
5017195 2361921 2361921 defendant Barbour John barber 602520 602520 Barbour, John, of Castel Combe, barber 13

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