names

14 rows where place_id = 601788

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647011 1909465 1909465 defendant Hawkyns William husbandman 601788 601788 Hawkyns, William, of Alkerton, husbandman 1
4804334 2297542 2297542 defendant Swayn William husbandman 601788 601788 Swayn, William, of Alkerton, husbandman 0
4857021 2313576 2313576 defendant Oswald John, junior yeoman 601788 601788 Oswald, John, junior, of Alkerton, yeoman 1
4874935 2319106 2319106 defendant Wylkyns Thomas   601788 601788 Wylkyns, Thomas, of Alkerton, mason 0
5010491 2359945 2359945 defendant Osewold John husbandman 601788 601788 Osewold, John, of Alkerton, husbandman 1
5077459 2379756 2379756 defendant Upton John husbandman 601788 601788 Upton, John, of Alkerton, husbandman 0
5224527 2422842 2422842 defendant Warner Nicholas husbandman 601788 601788 Warner, Nicholas, of Alkerton, husbandman 0
5224528 2422842 2422842 defendant Hardyng Thomas husbandman 601788 601788 Hardyng, Thomas, of Alkerton, husbandman 1
5224529 2422842 2422842 defendant Oswold Joan widow 601788 601788 Oswold, Joan, of Alkerton, widow 2
5280793 2439457 2439457 plaintiff Chaunore William   601788 601788 Chaunore, William, of Alkerton 0
5306477 2446927 2446927 defendant Wyk Thomas yeoman 601788 601788 Wyk, Thomas, of Alkerton, yeoman 0
5310583 2448201 2448201 defendant Wyke Thomas yeoman 601788 601788 Wyke, Thomas, of Alkerton, yeoman 0
5331025 2454344 2454344 defendant Blanche Walter husbandman 601788 601788 Blanche, Walter, of Alkerton, husbandman 0
5331026 2454344 2454344 defendant Blanche William husbandman 601788 601788 Blanche, William, of Alkerton, husbandman 1

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);