names

20 rows where place_id = 591197

✎ 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
3603681 1868820 1868820 defendant Hill Humphrey yeoman 591197 591197 Hill, Humphrey, of Drayton in Hales, Salop, yeoman 0
3603683 1868821 1868821 defendant Hill Humphrey yeoman 591197 591197 Hill, Humphrey, of Drayton in Hales, Salop, yeoman 0
3616744 1872867 1872867 defendant Eggeley Thomas tanner 591197 591197 Eggeley, Thomas, of Drayton in Hales, Salop, tanner 0
3858745 1976408 1976408 defendant Bromley James gent 591197 591197 Bromley, James, of Drayton in Hales, Salop, gent 0
3858747 1976409 1976409 defendant Bromley Margaret widow 591197 591197 Bromley, Margaret, of Drayton in Hales, Salop, widow 0
3858749 1976410 1976410 defendant Bromley Roger gent 591197 591197 Bromley, Roger, of Drayton in Hales, Salop, gent 0
3858751 1976411 1976411 defendant Tytley John gent 591197 591197 Tytley, John, of Drayton in Hales, Salop, gent 0
3872882 1981147 1981147 defendant Tytley John gent 591197 591197 Tytley, John, of Drayton in Hales, Salop, gent 0
3948921 2006689 2006689 defendant Cureton Thomas butcher 591197 591197 Cureton, Thomas, of Drayton in Hales, Salop, butcher 0
3963527 2011851 2011851 defendant Jenk Richard gent 591197 591197 Jenk, Richard, of Drayton in Hales, Salop, gent 0
4351211 2147674 2147674 defendant Poole William carpenter 591197 591197 Poole, William, of Drayton in Hales, Salop, carpenter 0
5226452 2423399 2423399 defendant Wylde Richard smith 591197 591197 Wylde, Richard, of Drayton in Hales, Salop, smith 0
5243707 2428352 2428352 defendant Tytley Peter gent 591197 591197 Tytley, Peter, of Drayton in Hales, Salop, gent 1
5243710 2428353 2428353 defendant Tytley Peter gent 591197 591197 Tytley, Peter, of Drayton in Hales, Salop, gent 1
5283133 2440127 2440127 defendant Tytteley Humphrey yeoman 591197 591197 Tytteley, Humphrey, of Drayton in Hales, Salop, yeoman 0
5313978 2449202 2449202 defendant Tedyr Roger mercer 591197 591197 Tedyr, Roger, of Drayton in Hales, Salop, mercer 0
5313980 2449203 2449203 defendant Tedyr Roger mercer 591197 591197 Tedyr, Roger, of Drayton in Hales, Salop, mercer 0
5509510 2507818 2507818 defendant Massy Henry chapman 591197 591197 Massy, Henry, of Drayton in Hales, Salop, chapman 2
5509520 2507819 2507819 defendant Massy Henry chapman 591197 591197 Massy, Henry, of Drayton in Hales, Salop, chapman 2
5522813 2511965 2511965 defendant Coke Thomas yeoman 591197 591197 Coke, Thomas, of Drayton in Hales, Salop, yeoman 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);