names

14 rows where place_id = 613521

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3698819 1925848 1925848 defendant Fulthorp Thomas esq 613521 613521 Fulthorp, Thomas, of Ellesfeld, esq 0
4643165 2244109 2244109 defendant Carsewell Thomas   613521 613521 Carsewell, Thomas, of Ellesfeld 0
4730021 2274592 2274592 defendant Langeston David husbandman 613521 613521 Langeston, David, of Ellesfeld, husbandman 0
4762805 2284346 2284346 defendant Milward John   613521 613521 Milward, John, of Ellesfeld, vicar 0
4791488 2293432 2293432 defendant Hille John husbandman 613521 613521 Hille, John, of Ellesfeld, husbandman 0
5107178 2388529 2388529 defendant Turnour William husbandman 613521 613521 Turnour, William, of Ellesfeld, husbandman 0
5222475 2422288 2422288 defendant Blount Walter gent 613521 613521 Blount, Walter, of Ellesfeld, gent 1
5259447 2433078 2433078 plaintiff Hore John esq 613521 613521 Hore, John, of Ellesfeld, esq 0
5298631 2444573 2444573 defendant Knyght Walter yeoman 613521 613521 Knyght, Walter, of Ellesfeld, yeoman 0
5299195 2444743 2444743 defendant Gate_ Thomas husbandman 613521 613521 Gate_, Thomas, of Ellesfeld, husbandman 0
5312793 2448856 2448856 defendant Goodale Robert husbandman 613521 613521 Goodale, Robert, of Ellesfeld, husbandman 1
5536909 2516033 2516033 defendant Ley Florence husbandman 613521 613521 Ley, Florence, of Ellesfeld, husbandman 0
5536910 2516033 2516033 defendant Brytayn Thomas husbandman 613521 613521 Brytayn, Thomas, of Ellesfeld, husbandman 1
5557952 2522279 2522279 defendant Benet Robert husbandman 613521 613521 Benet, Robert, of Ellesfeld, husbandman 0

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