names

14 rows where place_id = 608606

✎ 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
3674425 1918046 1918046 defendant Balett John husbandman 608606 608606 Balett, John, of Sybertoft, husbandman 0
3708558 1928977 1928977 plaintiff Osborn Richard gent 608606 608606 Osborn, Richard, of Sybertoft, gent 0
3727143 1934760 1934760 defendant Balhed John yeoman 608606 608606 Balhed, John, of Sybertoft, yeoman 1
4564594 2220486 2220486 defendant Matoun John   608606 608606 Matoun, John, of Sybertoft 1
5001330 2357271 2357271 defendant Robert John yeoman 608606 608606 Robert, John, of Sybertoft, yeoman 0
5010065 2359812 2359812 defendant Roberd John drover 608606 608606 Roberd, John, of Sybertoft, drover 0
5027866 2365031 2365031 defendant Robert John yeoman 608606 608606 Robert, John, of Sybertoft, yeoman 0
5046378 2370555 2370555 defendant Robert John yeoman 608606 608606 Robert, John, of Sybertoft, yeoman 0
5063790 2375700 2375700 defendant Robert William husbandman 608606 608606 Robert, William, of Sybertoft, husbandman 1
5153579 2402198 2402198 defendant Pecche Thomas husbandman 608606 608606 Pecche, Thomas, of Sybertoft, husbandman 0
5170921 2407217 2407217 defendant Pecch Thomas husbandman 608606 608606 Pecch, Thomas, of Sybertoft, husbandman 0
5189018 2412518 2412518 defendant Pecch Thomas husbandman 608606 608606 Pecch, Thomas, of Sybertoft, husbandman 0
5189020 2412519 2412519 defendant Pecche Thomas husbandman 608606 608606 Pecche, Thomas, of Sybertoft, husbandman 0
5189022 2412520 2412520 defendant Pecche Thomas husbandman 608606 608606 Pecche, Thomas, of Sybertoft, 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);