names

27 rows where place_id = 843296

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648208 1909837 1909837 defendant Vyncent Robert gent 843296 843296 Vyncent, Robert, of Groby, Leics, gent 0
3969731 2014022 2014022 plaintiff Crampe John   843296 843296 Crampe, John, of Groby, Leics 0
5008064 2359244 2359244 defendant Ferrers William (legal representative) 843296 843296 Ferrers, William, of Groby, Leics, knight, executor of 4
5020682 2362945 2362945 defendant de Ferrarirs Thomas, senior esq 843296 843296 de Ferrarirs, Thomas, senior, of Groby, Leics, esq 0
5020690 2362948 2362948 defendant de Ferrarirs Thomas esq 843296 843296 de Ferrarirs, Thomas, of Groby, Leics, esq 0
5067834 2376881 2376881 defendant Russell Alice gentlewoman 843296 843296 Russell, Alice, of Groby, Leics, gentlewoman 0
5074406 2378847 2378847 defendant Grey Edward   843296 843296 Grey, Edward, of Groby, Leics, knight 0
5218535 2421152 2421152 defendant Bourgchier John   843296 843296 Bourgchier, John, of Groby, Leics, knight 0
5229061 2424109 2424109 defendant Heynesworth James yeoman 843296 843296 Heynesworth, James, of Groby, Leics, yeoman 1
5251512 2430580 2430580 defendant Grey Edward   843296 843296 Grey, Edward, of Groby, Leics, knight 0
5254856 2431633 2431633 defendant Bourgchier John   843296 843296 Bourgchier, John, of Groby, Leics, knight 0
5328610 2453635 2453635 defendant Bourchier John   843296 843296 Bourchier, John, of Groby, Leics, knight 0
5328612 2453636 2453636 defendant Bourgchier John   843296 843296 Bourgchier, John, of Groby, Leics, knight 0
5349702 2460043 2460043 defendant Bourghchier John   843296 843296 Bourghchier, John, of Groby, Leics, knight 0
5349705 2460044 2460044 defendant Bourghchier John   843296 843296 Bourghchier, John, of Groby, Leics, knight 1
5370480 2466351 2466351 defendant Bourgchier John   843296 843296 Bourgchier, John, of Groby, Leics, knight 0
5388295 2471698 2471698 defendant Bourgchier John   843296 843296 Bourgchier, John, of Groby, Leics, knight 0
5400903 2475318 2475318 defendant Bourgchier John   843296 843296 Bourgchier, John, of Groby, Leices, knight 0
5400970 2475343 2475343 defendant Bourghchcier John   843296 843296 Bourghchcier, John, of Groby, Leics, knight 0
5400972 2475344 2475344 defendant Bourghier John   843296 843296 Bourghier, John, of Groby, Leics, knight 0
5416072 2479738 2479738 defendant Coke John yeoman 843296 843296 Coke, John, of Groby, Leics, yeoman 2
5432768 2484767 2484767 defendant Coke John yeoman 843296 843296 Coke, John, of Groby, Leics, yeoman 2
5432771 2484768 2484768 defendant Coke John yeoman 843296 843296 Coke, John, of Groby, Leics, yeoman 1
5480676 2499184 2499184 defendant Farnham Richard gent 843296 843296 Farnham, Richard, of Groby, Leics, gent 1
5485969 2500692 2500692 defendant pledges for Bourchiher John   843296 843296 pledges for Bourchiher, John, of Groby, Leics, knight 4
5498385 2504478 2504478 defendant Grey Henry esq 843296 843296 Grey, Henry, of Groby, Leics, esq 0
5512379 2508733 2508733 defendant Coke John yeoman 843296 843296 Coke, John, of Groby, Leics, yeoman 3

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