names

10 rows where place_id = 742880

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4352308 2148043 2148043 defendant Bulcott Edward laborer 742880 742880 Bulcott, Edward, of Madley, Herefs, laborer 2
4376334 2156605 2156605 defendant Bulcott Edward laborer 742880 742880 Bulcott, Edward, of Madley, Herefs, laborer 2
4678817 2258979 2258979 defendant Ragon Thomas gent 742880 742880 Ragon, Thomas, of Madley, Herefs, gent 0
4739292 2277376 2277376 defendant Crektot William esq 742880 742880 Crektot, William, of Madley, Herefs, esq 0
4739295 2277377 2277377 defendant Criktot William esq 742880 742880 Criktot, William, of Madley, Herefs, esq 0
4998956 2356567 2356567 defendant Gaderne Geoffrey husbandman 742880 742880 Gaderne, Geoffrey, of Madley, Herefs, husbandman 3
5157629 2403359 2403359 defendant ap John Thomas gent 742880 742880 ap John, Thomas, of Madley, Herefs, gent 4
5335717 2455748 2455748 defendant Ragon Walter gent 742880 742880 Ragon, Walter, of Madley, Herefs, gent 0
5335883 2455801 2455801 defendant Ragon Walter gent 742880 742880 Ragon, Walter, of Madley, Herefs, gent 0
5491164 2502257 2502257 defendant Carwarden John husbandman 742880 742880 Carwarden, John, of Madley, Herefs, 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);