names

17 rows where place_id = 600016

✎ 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
3639353 1907117 1907117 defendant Wilson John yeoman 600016 600016 Wilson, John, of Whitechurch, yeoman 0
3643675 1908449 1908449 defendant Borde Robert clerk 600016 600016 Borde, Robert, of Whitechurch, clerk 0
3649342 1910186 1910186 defendant Hyde Thomas yeoman 600016 600016 Hyde, Thomas, of Whitechurch, yeoman 1
3671366 1917021 1917021 defendant Haywode John husbandman 600016 600016 Haywode, John, of Whitechurch, husbandman 0
3891505 1987424 1987424 defendant Pursell John husbandman 600016 600016 Pursell, John, of Whitechurch, husbandman 2
3897751 1989454 1989454 defendant Alee John tailor 600016 600016 Alee, John, of Whitechurch, tailor 3
3900694 1990460 1990460 defendant Graunge William butcher 600016 600016 Graunge, William, of Whitechurch, butcher 3
4750794 2280714 2280714 defendant Serle William husbandman 600016 600016 Serle, William, of Whitechurch,, husbandman 5
5090283 2383535 2383535 defendant Felton Nicholas clerk 600016 600016 Felton, Nicholas, of Whitechurch, clerk 0
5110215 2389394 2389394 defendant Glaswes William cordwainer 600016 600016 Glaswes, William, of Whitechurch, cordwainer 1
5111820 2389848 2389848 defendant Richard William husbandman 600016 600016 Richard, William, of Whitechurch, husbandman 2
5441018 2487222 2487222 defendant Johnson Richard, sen shoemaker 600016 600016 Johnson, Richard, sen, of Whitechurch, shoemaker 2
5444187 2488167 2488167 defendant Johnson Richard, sen shoemaker 600016 600016 Johnson, Richard, sen, of Whitechurch, shoemaker 2
5448148 2489336 2489336 defendant Mawedelegh Henry husbandman 600016 600016 Mawedelegh, Henry, of Whitechurch, husbandman 0
5448150 2489336 2489336 defendant Johnson Richard, sen shoemaker 600016 600016 Johnson, Richard, sen, of Whitechurch, shoemaker 2
5508488 2507524 2507524 defendant Mede Richard husbandman 600016 600016 Mede, Richard, of Whitechurch, husbandman 0
5603223 2535893 2535893 defendant Pokke Thomas husbandman 600016 600016 Pokke, Thomas, of Whitechurch, husbandman 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);