names

15 rows where case_id = 2447929

✎ 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
5309654 2447929 2447929 plaintiff Sydenham Alexander     Sydenham, Alexander 0
5309655 2447929 2447929 plaintiff Sydenham Richard     Sydenham, Richard 1
5309656 2447929 2447929 defendant Welton George gent   Welton, George, gent 0
5309657 2447929 2447929 defendant Coke John husbandman 625176 625176 Coke, John, of West Coker, husbandman 1
5309658 2447929 2447929 defendant Hewet Giles glasier 586373 586373 Hewet, Giles, of Yevell, glasier 2
5309659 2447929 2447929 defendant Horne John shoemaker 586373 586373 Horne, John, of Yevell, shoemaker 3
5309660 2447929 2447929 defendant Broun Roger husbandman 586373 586373 Broun, Roger, of Yevell, husbandman 4
5309661 2447929 2447929 defendant Clays Alfred ostler 586373 586373 Clays, Alfred, of Yevell, ostler 5
5309662 2447929 2447929 defendant Courteys John mercer 586373 586373 Courteys, John, of Yevell, mercer 6
5309663 2447929 2447929 defendant Monke William husbandman 602299 602299 Monke, William, of Montacute, husbandman 7
5309664 2447929 2447929 defendant Knappe Nicholas barber 592235 592235 Knappe, Nicholas, of Montagu, barber 8
5309665 2447929 2447929 defendant Panter William yeoman 592235 592235 Panter, William, of Montagu, yeoman 9
5309666 2447929 2447929 defendant Chaunt John husbandman 592235 592235 Chaunt, John, of Montagu, husbandman 10
5309667 2447929 2447929 defendant Smert John husbandman 592235 592235 Smert, John, of Montagu, husbandman 11
5309668 2447929 2447929 defendant Eyot John laborer 602299 602299 Eyot, John, of Montacute, laborer 12

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