names

25 rows where place_id = 597142

✎ 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
3627456 1903443 1903443 defendant Oxenden William gent 597142 597142 Oxenden, William, of Wyngham, Kent, gent 0
3633615 1905324 1905324 defendant Oxenden Edward gent 597142 597142 Oxenden, Edward, of Wyngham, Kent, gent 0
3826193 1966036 1966036 defendant Leycetter Alexander clerk 597142 597142 Leycetter, Alexander, of Wyngham, kent, clerk 0
4023862 2033237 2033237 defendant Mundy Nicholas clerk 597142 597142 Mundy, Nicholas, of Wyngham, Kent, clerk 0
4035404 2037336 2037336 defendant Osborn Elizabeth widow 597142 597142 Osborn, Elizabeth, of Wyngham, Kent, widow 1
4035411 2037337 2037337 defendant Osborne Elizabeth widow 597142 597142 Osborne, Elizabeth, of Wyngham, Kent, widow 1
4651631 2246501 2246501 defendant Oxenden John husbandman 597142 597142 Oxenden, John, of Wyngham, Kent, husbandman 0
4651806 2246513 2246513 defendant Oxenden John husbandman 597142 597142 Oxenden, John, of Wyngham, Kent, husbandman 0
4845973 2310246 2310246 defendant Cherche Richard barber 597142 597142 Cherche, Richard, of Wyngham, Kent, barber 1
4981473 2351371 2351371 defendant Balle William gent 597142 597142 Balle, William, of Wyngham, Kent, gent 8
4981485 2351372 2351372 defendant Balle William gent 597142 597142 Balle, William, of Wyngham, Kent, gent 8
4993853 2355034 2355034 defendant Jardyn John yeoman 597142 597142 Jardyn, John, of Wyngham, Kent, yeoman 0
5083143 2381463 2381463 defendant Eldergate Richard gent 597142 597142 Eldergate, Richard, of Wyngham, Kent, gent 0
5089358 2383253 2383253 defendant Exhale William yeoman 597142 597142 Exhale, William, of Wyngham, Kent, yeoman 1
5228972 2424077 2424077 defendant Eldergate John esq 597142 597142 Eldergate, John, of Wyngham, Kent, esq 1
5249728 2430040 2430040 defendant Dryland John gent 597142 597142 Dryland, John,of Wyngham, Kent, gent 11
5270253 2436402 2436402 defendant Ylehalgate John gent 597142 597142 Ylehalgate, John, of Wyngham, Kent, gent 0
5299207 2444746 2444746 defendant Eldergate John gent 597142 597142 Eldergate, John, of Wyngham, Kent, gent 3
5299493 2444829 2444829 defendant Eldergate John gent 597142 597142 Eldergate, John, of Wyngham, Kent, gent 3
5303869 2446155 2446155 defendant Elthergate John gent 597142 597142 Elthergate, John, of Wyngham, Kent, gent 0
5513070 2508941 2508941 defendant Harrys John yeoman 597142 597142 Harrys, John, of Wyngham, Kent, yeoman 0
5590336 2531949 2531949 defendant Opynden Edward gent 597142 597142 Opynden, Edward, of Wyngham, Kent, gent 3
5624033 2551462 2551462 defendant Gaddesby Thomas chaplain 597142 597142 Gaddesby, Thomas, of Wyngham, Kent, chaplain 0
5624036 2551463 2551463 defendant Gaddesby Thomas chaplain 597142 597142 Gaddesby, Thomas, of Wyngham, Kent, chaplain 0
5626869 2552377 2552377 defendant Kedyngton John taverner 597142 597142 Kedyngton, John, of Wyngham, Kent, taverner 5

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