names

27 rows where place_id = 846142

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648231 1909843 1909843 defendant Whyte John, senior   846142 846142 Whyte, John, senior, of Est Raddon, court holder 0
4721903 2272181 2272181 defendant Chase Peter laborer 846142 846142 Chase, Peter, of East Raddon, laborer 3
5098524 2385999 2385999 defendant Chowene John gent 846142 846142 Chowene, John, of Est Raddon, gent 0
5098525 2385999 2385999 defendant Frere John   846142 846142 Frere, John, of Est Raddon, franklin 1
5105477 2388045 2388045 defendant Boeff William gent 846142 846142 (Boeff, William, of Est Raddon, gent 1
5106080 2388217 2388217 defendant More William husbandman 846142 846142 More, William, of Est Raddon, husbandman 0
5106087 2388218 2388218 defendant Waleys John esq 846142 846142 Waleys, John, of Est Raddon, esq 0
5106088 2388218 2388218 defendant More William husbandman 846142 846142 together with More, William, of Est Raddon, husbandman 1
5106095 2388219 2388219 defendant Walys John esq 846142 846142 Walys, John, of Est Raddon, esq 0
5126227 2394155 2394155 defendant Chonne John gent 846142 846142 Chonne, John, of East Raddon, gent 0
5126229 2394155 2394155 defendant Frere John   846142 846142 Frere, John, of East Raddon, franklin 2
5141687 2398678 2398678 defendant Chowne John gent 846142 846142 Chowne, John, of East Raddon, gent 0
5144877 2399651 2399651 defendant Frere John   846142 846142 together with Frere, John, of East Raddon, franklin 2
5144881 2399651 2399651 defendant atte Busshe William husbandman 846142 846142 atte Busshe, William, of East Raddon, husbandman 6
5144883 2399652 2399652 defendant Frere John   846142 846142 Frere, John, of East Raddon, franklin 0
5144887 2399652 2399652 defendant atte Busshe William husbandman 846142 846142 atte Busshe, William, of East Raddon, husbandman 4
5148145 2400604 2400604 defendant Waleys John esq 846142 846142 Waleys, John, of East Raddon, esq 0
5148146 2400604 2400604 defendant More William yeoman 846142 846142 More, William, of East Raddon, yeoman 1
5215918 2420385 2420385 defendant Waleys John esq 846142 846142 Waleys, John, of Est Raddon, esq 0
5215919 2420385 2420385 defendant More William yeoman 846142 846142 More, William, of Est Raddon, yeoman 1
5215926 2420386 2420386 defendant Waleys John esq 846142 846142 Waleys, John, of Est Raddon, esq 0
5297068 2444139 2444139 defendant Avery William laborer 846142 846142 Avery, William, of Est Raddon, laborer 2
5338607 2456646 2456646 defendant Hardyng John husbandman 846142 846142 Hardyng, John, of Est Raddon, husbandman 1
5346083 2458913 2458913 defendant Avery William laborer 846142 846142 Avery, William, of Est Raddon, laborer 1
5370084 2466227 2466227 defendant Walys John gent 846142 846142 Walys, John, of East Raddon, gent 0
5487421 2501134 2501134 defendant Waleys John esq 846142 846142 Waleys, John, of Est Raddon, esq 0
5512883 2508883 2508883 defendant Puntyngdon William gent 846142 846142 Puntyngdon, William, of Est Raddon, gent 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);