names

17 rows where place_id = 592103

✎ 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
3606579 1869730 1869730 defendant Norrys John husbandman 592103 592103 Norrys, John, of Tomworth, Warks, husbandman 0
3606581 1869731 1869731 defendant Norys John husbandman 592103 592103 Norys, John, of Tomworth, Warks, husbandman 0
3617160 1872991 1872991 defendant Gelot John mercer 592103 592103 Gelot, John, of Tomworth, Warks, mercer 0
3617162 1872992 1872992 defendant Milles Henry weaver 592103 592103 Milles, Henry, of Tomworth, Warks, weaver 0
3617164 1872993 1872993 defendant Symond Nicholas baker 592103 592103 Symond, Nicholas, of Tomworth, Warks, baker 0
3617166 1872994 1872994 defendant Tyeslowe John shoeamker 592103 592103 Tyeslowe, John, of Tomworth, Warks, shoeamker 0
3828963 1966940 1966940 defendant Archour Richard esq 592103 592103 Archour, Richard, of Tomworth, Warks, esq 0
3836508 1969326 1969326 defendant Ferrers Humphrey   592103 592103 Ferrers, Humphrey, of Tomworth, Warks, knight 0
4902865 2327510 2327510 defendant Stalkar William vintner 592103 592103 Stalkar, William, of Tomworth, Warks, vintner 2
5094347 2384752 2384752 defendant Ferrers Thomas esq 592103 592103 Ferrers, Thomas, of Tomworth, Warks, esq 0
5094350 2384753 2384753 defendant Ferrers Thomas esq 592103 592103 Ferrers, Thomas, of Tomworth, Warks, esq 0
5481328 2499358 2499358 defendant Jonson John yeoman 592103 592103 Jonson, John, of Tomworth, Warks, yeoman 1
5483261 2499938 2499938 defendant Coton Stephen draper 592103 592103 Coton, Stephen, of Tomworth, Warks, draper 0
5496294 2503792 2503792 defendant Raynold William yeoman 592103 592103 Raynold, William, of Tomworth, Warks, yeoman 0
5511244 2508360 2508360 defendant Raynold William yeoman 592103 592103 Raynold, William, of Tomworth, Warks, yeoman 0
5567740 2525138 2525138 defendant Dyxson Elizabeth widow 592103 592103 Dyxson, Elizabeth, of Tomworth, Warks, widow 1
5571787 2526287 2526287 defendant Ferres John   592103 592103 Ferres, John, of Tomworth, Warks, knight 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);