names

41 rows where place_id = 649755

✎ 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
3908289 1993069 1993069 defendant Helme John butcher 649755 649755 Helme, John, of Menston, butcher 0
4449747 2184873 2184873 plaintiff Graver or Graner Walter   649755 649755 Graver or Graner, Walter, of Menston 0
4854374 2312768 2312768 defendant Olrede Richard husbandman 649755 649755 Olrede, Richard, of Menston, husbandman 2
4854375 2312768 2312768 defendant del Rodes John husbandman 649755 649755 del Rodes, John, of Menston, husbandman 3
4855437 2313060 2313060 defendant Ollerhed John yeoman 649755 649755 Ollerhed, John, of Menston, yeoman 0
4855438 2313060 2313060 defendant Ollerhed Richard yeoman 649755 649755 Ollerhed, Richard, of Menston, yeoman 1
4855439 2313060 2313060 defendant Ollerhed William yeoman 649755 649755 Ollerhed, William, of Menston, yeoman 2
4855440 2313060 2313060 defendant Ollerhed Thomas yeoman 649755 649755 Ollerhed, Thomas, of Menston, yeoman 3
4855441 2313060 2313060 defendant Ollerhed Roger yeoman 649755 649755 Ollerhed, Roger, of Menston, yeoman 4
4855442 2313060 2313060 defendant Ollerhed Robert yeoman 649755 649755 Ollerhed, Robert, of Menston, yeoman 5
4855444 2313061 2313061 defendant Ollerhed John yeoman 649755 649755 Ollerhed, John, of Menston, yeoman 0
4855445 2313061 2313061 defendant Ollerhed Richard yeoman 649755 649755 Ollerhed, Richard, of Menston, yeoman 1
4855446 2313061 2313061 defendant Ollerhed William yeoman 649755 649755 Ollerhed, William, of Menston, yeoman 2
4855447 2313061 2313061 defendant Ollerhed Thomas yeoman 649755 649755 Ollerhed, Thomas, of Menston, yeoman 3
4855448 2313061 2313061 defendant Ollerhed Roger yeoman 649755 649755 Ollerhed, Roger, of Menston, yeoman 4
4855449 2313061 2313061 defendant Ollerhed Robert yeoman 649755 649755 Ollerhed, Robert, of Menston, yeoman 5
4936796 2337888 2337888 defendant Flotemanby William yeoman 649755 649755 Flotemanby, William, of Menston, yeoman 0
5022527 2363489 2363489 defendant Pykard William husbandman 649755 649755 Pykard, William, of Menston, husbandman 0
5022528 2363489 2363489 defendant Pykard Richard husbandman 649755 649755 Pykard, Richard, of Menston, husbandman 1
5022529 2363489 2363489 defendant Pykard John husbandman 649755 649755 Pykard, John, of Menston, husbandman 2
5022530 2363489 2363489 defendant Bailly Richard husbandman 649755 649755 Bailly, Richard, of Menston, husbandman 3
5022531 2363489 2363489 defendant del Rodes John husbandman 649755 649755 del Rodes, John, of Menston, husbandman 4
5022532 2363489 2363489 defendant Brerehaugh William yeoman 649755 649755 Brerehaugh, William, of Menston, yeoman 5
5022533 2363489 2363489 defendant Brerehaugh Richard yeoman 649755 649755 Brerehaugh, Richard, of Menston, yeoman 6
5214709 2420031 2420031 defendant Brerehay William yeoman 649755 649755 Brerehay, William, of Menston, yeoman 0
5214710 2420031 2420031 defendant Pycard William yeoman 649755 649755 together with Pycard, William, of Menston, yeoman 1
5214711 2420031 2420031 defendant Pycard John, senior yeoman 649755 649755 Pycard, John, senior, of Menston, yeoman 2
5214712 2420031 2420031 defendant Pycard John, junior yeoman 649755 649755 Pycard, John, junior, of Menston, yeoman 3
5214725 2420033 2420033 defendant Pycard William yeoman 649755 649755 Pycard, William, of Menston, yeoman 0
5214726 2420033 2420033 defendant Pycard John, senior yeoman 649755 649755 Pycard, John, senior, of Menston, yeoman 1
5214727 2420033 2420033 defendant Pycard John, junior yeoman 649755 649755 Pycard, John, junior, of Menston, yeoman 2
5214734 2420033 2420033 defendant Brerehay William yeoman 649755 649755 together with Brerehay, William, of Menston, yeoman 9
5225454 2423121 2423121 defendant Pycard William yeoman 649755 649755 together with Pycard, William, of Menston, yeoman 1
5225455 2423121 2423121 defendant Pycard John yeoman 649755 649755 Pycard, John, of Menston, yeoman 2
5306019 2446786 2446786 defendant Rodys John   649755 649755 Rodys, John, of Menston 15
5306020 2446786 2446786 defendant Rodys William   649755 649755 Rodys, William, of Menston 16
5315033 2449548 2449548 defendant Brerehey Richard husbandman 649755 649755 Brerehey, Richard, of Menston, husbandman 2
5319304 2450866 2450866 defendant Yon Richard weaver 649755 649755 Yon, Richard, of Menston, weaver 2
5416917 2479975 2479975 defendant Braythewayte Richard yeoman 649755 649755 Braythewayte, Richard, of Menston, yeoman 0
5479297 2498824 2498824 defendant Pykard William, senior husbandman 649755 649755 Pykard, William, senior, of Menston, husbandman 0
5611453 2547313 2547313 defendant Williamson Dikson John   649755 649755 Williamson Dikson, John, of Menston 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);