names

17 rows where place_id = 610577

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625002 1875353 1875353 defendant Ayleworth Walter merchant 610577 610577 Ayleworth, Walter, of Nether Slaughter, merchant 0
3684221 1921199 1921199 defendant Edward Thomas husbandman 610577 610577 Edward, Thomas, of Nether Whitaker, husbandman 0
3804936 1959488 1959488 plaintiff Starke Thomas yeoman 610577 610577 Starke, Thomas, of Nether Whyttaker, yeoman 0
4035388 2037330 2037330 defendant Mustoe or Muscoe John weaver 610577 610577 Mustoe or Muscoe, John, of Nether Sloughter, weaver 1
4035391 2037331 2037331 defendant Mustoe John weaver 610577 610577 Mustoe, John, of Nether Slawghter, weaver 1
4146944 2077080 2077080 defendant Worseley John chapman 610577 610577 Worseley, John, of Nether Whytaker, chapman 1
4166002 2083612 2083612 defendant Mylner Robert husbandman 610577 610577 Mylner, Robert, of Nether Whitaker, husbandman 1
4205200 2097369 2097369 defendant Hoyland Anne widow 610577 610577 Hoyland, Anne, of Nether Shyer, widow 1
4234596 2107648 2107648 defendant Pruse Henry gent 610577 610577 Pruse, Henry, of Nether Slaughter, gent 0
4284373 2124460 2124460 defendant Hollyngshead Robert yeoman 610577 610577 Hollyngshead, Robert, of Nether Whitaker, yeoman 0
4308886 2133258 2133258 defendant Adhams John husbandman 610577 610577 Adhams, John, of Nether Adber, husbandman 1
4381556 2158512 2158512 defendant Snell or Suell Ralph yeoman 610577 610577 Snell or Suell, Ralph, of Nether Whittaker, yeoman 1
4400498 2164760 2164760 defendant Wilson Thomas husbandman 610577 610577 Wilson, Thomas, of Nether Whitaker, husbandman 0
4400499 2164760 2164760 defendant Farmer John weaver 610577 610577 Farmer, John, of Nether Whitaker, weaver 1
5284653 2440527 2440527 defendant Gyles John husbandman 610577 610577 Gyles, John, of Nether Sloughter, husbandman 0
5356235 2462028 2462028 defendant Robyns John yeoman 610577 610577 Robyns, John, of Nether Whitaker, yeoman 1
5483667 2500067 2500067 defendant Robyns John yeoman 610577 610577 Robyns, John, of Nether Whitaker, yeoman 3

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