names

29 rows where place_id = 794863

✎ 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
4743210 2278539 2278539 defendant Leget Henry mariner 794863 794863 Leget, Henry, of Bodennek, mariner 1
4743213 2278540 2278540 defendant Leget Henry mariner 794863 794863 Leget, Henry, of Bodennek, mariner 1
4765513 2285205 2285205 defendant Bonde John   794863 794863 Bonde, John, of Bodennek 0
4780442 2289881 2289881 defendant Bonde William mariner 794863 794863 Bonde, William, of Bodennek, mariner 1
4780443 2289881 2289881 defendant Mody John mariner 794863 794863 Mody, John, of Bodennek, mariner 2
4843497 2309486 2309486 plaintiff Martyn Richard   794863 794863 Martyn, Richard, of Bodennek 0
4902870 2327512 2327512 defendant Waterman John mariner 794863 794863 Waterman, John, of Bodennek, mariner 0
4916432 2331638 2331638 defendant Eston Roger husbandman 794863 794863 Eston, Roger, of Bodennek, husbandman 0
4937271 2338022 2338022 defendant Toker John tucker 794863 794863 Toker, John, of Bodennek, tucker 0
5035879 2367348 2367348 defendant Bonde John mariner 794863 794863 Bonde, John, of Bodennek, mariner 0
5115232 2390880 2390880 defendant Aprun John yeoman 794863 794863 Aprun, John, of Bodennek, yeoman 0
5115233 2390880 2390880 defendant Webbe William yeoman 794863 794863 Webbe, William, of Bodennek, yeoman 1
5156390 2403021 2403021 defendant Hayne Patrick mariner 794863 794863 Hayne, Patrick, of Bodennek, mariner 0
5156392 2403022 2403022 defendant Hayne Patrick mariner 794863 794863 Hayne, Patrick, of Bodennek, mariner 0
5172613 2407716 2407716 defendant Hayne Patrick mariner 794863 794863 Hayne, Patrick, of Bodennek, mariner 0
5192205 2413453 2413453 defendant Hayne Patrick   794863 794863 Hayne, Patrick, of Bodennek 0
5225988 2423268 2423268 defendant Cobbe Thomas mariner 794863 794863 Cobbe, Thomas, of Bodennek, mariner 0
5265918 2435094 2435094 defendant Gay John mariner 794863 794863 Gay, John, of Bodennek, mariner 0
5350782 2460355 2460355 defendant Rok Brian mariner 794863 794863 Rok, Brian, of Bodennek, mariner 1
5363724 2464307 2464307 defendant Beweferes Thomas merchant 794863 794863 Beweferes, Thomas, of Bodennek, merchant 0
5363725 2464307 2464307 defendant Cok Ralph merchant 794863 794863 Cok, Ralph, of Bodennek, merchant 1
5401317 2475436 2475436 defendant Trevarrak Thomas smith 794863 794863 Trevarrak, Thomas, of Bodennek, smith 2
5414335 2479222 2479222 defendant Trevarrak Thomas smith 794863 794863 Trevarrak, Thomas, of Bodennek, smith 1
5414616 2479307 2479307 defendant Trevarrak Thomas smith 794863 794863 Trevarrak, Thomas, of Bodennek, smith 1
5444021 2488129 2488129 defendant Hayne Patrick mariner 794863 794863 Hayne, Patrick, of Bodennek, mariner 0
5487695 2501208 2501208 defendant Brasy Robert mariner 794863 794863 Brasy, Robert, of Bodennek, mariner 6
5487926 2501278 2501278 defendant Barklay John mariner 794863 794863 Barklay, John, of Bodennek, mariner 5
5576624 2527737 2527737 defendant Mohun Thomas gent 794863 794863 Mohun, Thomas, of Bodennek, gent 0
5630902 2553677 2553677 defendant Gerard Thomas shipman 794863 794863 Gerard, Thomas, of Bodennek, shipman 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);