names

17 rows where place_id = 761756

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4467307 2190454 2190454 plaintiff atte Rake John   761756 761756 atte Rake, John, of Capel, executor fo 0
4481619 2194947 2194947 defendant Roo Miles   761756 761756 Roo, Miles, of Capel 0
4481620 2194947 2194947 defendant Osbern Stephen   761756 761756 Osbern, Stephen, of Capel 1
4512972 2204492 2204492 plaintiff Brekles Joan   761756 761756 Brekles, Joan, of Capel 0
4512973 2204492 2204492 defendant Cardynal William   761756 761756 Cardynal, William, of Capel 0
4577275 2224411 2224411 defendant Cardenal William   761756 761756 Cardenal, William, of Capel 3
4591992 2228850 2228850 defendant Gerard William   761756 761756 Gerard, William, of Capel 1
4694230 2263696 2263696 defendant Lorker Richard   761756 761756 Lorker, Richard, of Capel, wheel wright 0
4696075 2264256 2264256 defendant Jenecok Robert yeoman 761756 761756 Jenecok, Robert, of Capel, yeoman 0
4753872 2281589 2281589 defendant Whityng Thomas gent 761756 761756 Whityng, Thomas, of Capel, gent 0
4775213 2288242 2288242 defendant Whytyng Thomas gent 761756 761756 Whytyng, Thomas, of Capel, gent 0
4801033 2296512 2296512 defendant Whytyng Thomas gent 761756 761756 Whytyng, Thomas, of Capel, gent 0
4940429 2339030 2339030 defendant Nicolle Walter husbandman 761756 761756 Nicolle, Walter, of Capel, husbandman 0
4994153 2355125 2355125 defendant Frenshman Giles miller 761756 761756 Frenshman, Giles, of Capel, miller 2
5020417 2362857 2362857 defendant Grote Roger gent 761756 761756 Grote, Roger, of Capel, gent 0
5020418 2362857 2362857 defendant Mekylfelde Thomas gent 761756 761756 Mekylfelde, Thomas, of Capel, gent, son of Mekylfeld, William, of Capel, gent 1
5082441 2381246 2381246 plaintiff Lucas Nicholas   761756 761756 Lucas, Nicholas, of Capel 1

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