names

31 rows where place_id = 641984

✎ 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
3865127 1978539 1978539 defendant Attforton John chapman 641984 641984 Attforton, John, of Lempster, Herefs, chapman 0
3887355 1986035 1986035 defendant Adforton John husbandman 641984 641984 Adforton, John, of Lempster, Herefs, husbandman 0
3887360 1986036 1986036 defendant Wulfe Thomas mercer 641984 641984 Wulfe, Thomas, of Lempster, Herefs, mercer 0
3923279 1998096 1998096 defendant Hutton Margaret widow 641984 641984 (Hutton, Margaret, of Lempster, Herefs, widow 1
3946062 2005698 2005698 defendant Baker John yeoman 641984 641984 Baker, John, of Lempster, Herefs, yeoman 0
4020963 2032226 2032226 defendant Creswell John gent 641984 641984 Creswell, John, of Lempster, Herefs, or of Lincolns Inn, Middx, gent 0
4020969 2032227 2032227 defendant Freman John cordwainer 641984 641984 Freman, John, of Lempster, Herefs, cordwainer 4
4040106 2038962 2038962 defendant Baker John yeoman 641984 641984 Baker, John, of Lempster, Herefs, yeoman 0
4040291 2039034 2039034 plaintiff Mellyn Richard yeoman 641984 641984 Mellyn, Richard, of Lempster, Herefs, yeoman 0
4051910 2043104 2043104 defendant Creswell John gent 641984 641984 Creswell, John, of Lempster, Herefs, or of Lincolns inn, Middx, gent 0
4053648 2043680 2043680 plaintiff ap Thomas John (legal representative) 641984 641984 ap Thomas, John, of Lempster, Herefs, mercer, executors of 0
4066605 2048351 2048351 defendant Powle or Poole Thomas vintner 641984 641984 Powle or Poole, Thomas, of Lempster, Herefs, vintner 0
4073732 2050899 2050899 defendant Poull Henry yeoman 641984 641984 Poull, Henry, of Lempster, Herefs, yeoman 0
4102918 2061334 2061334 defendant Stephens Thomas gent 641984 641984 Stephens, Thomas, of Lempster, Herefs, gent 0
4103518 2061544 2061544 defendant Shoeter Thomas chapman 641984 641984 Shoeter, Thomas, of Lempster, Herefs, chapman 1
4107841 2063080 2063080 defendant Poull Richard tanner 641984 641984 Poull, Richard, of Lempster, Herefs, tanner 0
4126757 2069857 2069857 defendant Warynge Thomas chapman 641984 641984 Warynge, Thomas, of Lempster, Herefs, chapman 0
4147875 2077393 2077393 defendant Wall Humphrey mercer 641984 641984 Wall, Humphrey, of Lempster, Herefs, mercer 0
4254052 2114355 2114355 defendant Shepperd William yeoman 641984 641984 Shepperd, William, of Lempster, Herefs, yeoman 2
4254056 2114356 2114356 defendant Shepperd William yeoman 641984 641984 Shepperd, William, of Lempster, Herefs, yeoman 2
4273792 2120780 2120780 defendant Shoter Thomas chapman 641984 641984 Shoter, Thomas, of Lempster, Herefs, chapman 2
4280221 2122988 2122988 defendant Jenens Richard carrier 641984 641984 Jenens, Richard, of Lempster, Herefs, carrier 3
4299528 2129921 2129921 defendant Wale Humphrey chapman 641984 641984 Wale, Humphrey, of Lempster, Herefs, chapman 1
4335410 2142113 2142113 defendant Shepperd William yeoman 641984 641984 Shepperd, William, of Lempster, Herefs, yeoman 1
4349571 2147110 2147110 defendant Higgins Robert chapman 641984 641984 Higgins, Robert, of Lempster, Herefs, chapman 1
4350824 2147545 2147545 defendant Higgins Robert chapman 641984 641984 Higgins, Robert, of Lempster, Herefs, chapman 1
4361964 2151437 2151437 defendant Wedgwood Stephen haberdasher 641984 641984 Wedgwood, Stephen, of Lempster, Herefs, haberdasher 0
4408804 2167541 2167541 defendant Crofte Richard esq 641984 641984 Crofte, Richard, of Lempster, Herefs, esq 0
5110088 2389364 2389364 defendant Hood William chapman 641984 641984 Hood, William, of Lempster, Herefs, chapman 3
5110094 2389365 2389365 defendant Hood William chapman 641984 641984 Hood, William, of Lempster, Herefs, chapman 3
5561544 2523359 2523359 defendant Scarlett William chapman 641984 641984 Scarlett, William, of Lempster, Herefs, chapman 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);