names

18 rows where place_id = 615593

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3709672 1929336 1929336 defendant Wodall John gent 615593 615593 Wodall, John, of Bosham, Sussex, gent 0
4519718 2206523 2206523 defendant Nunnyngton William   615593 615593 Nunnyngton, William, of Bosham, Sussex 0
4551943 2216561 2216561 defendant Nunyngton Willia   615593 615593 Nunyngton, Willia, of Bosham, Sussex 0
4627579 2239558 2239558 defendant Spythe John   615593 615593 Spythe, John, of Bosham, Sussex 3
4652656 2246781 2246781 defendant Tylye Henry husbandman 615593 615593 (Tylye, Henry, of Bosham, Sussex, husbandman 21
4652681 2246782 2246782 defendant Tylye Henry husbandman 615593 615593 (Tylye, Henry, of Bosham, Sussex, husbandman 21
4744737 2278975 2278975 defendant Nouneton William husbandman 615593 615593 Nouneton, William, of Bosham, Sussex, husbandman 1
4858418 2314006 2314006 defendant Scardevill William gent 615593 615593 Scardevill, William, of Bosham, Sussex, gent 1
5310042 2448034 2448034 defendant Markewyk William yeoman 615593 615593 Markewyk, William, of Bosham, Sussex, yeoman 0
5373167 2467206 2467206 defendant Walter Richard husbandman 615593 615593 Walter, Richard, of Bosham, Sussex, husbandman 0
5373172 2467207 2467207 defendant Markwyk William gent 615593 615593 Markwyk, William, of Bosham, Sussex, gent 0
5390234 2472270 2472270 defendant Walter Richard husbandman 615593 615593 Walter, Richard, of Bosham, Sussex, husbandman 0
5390239 2472271 2472271 defendant Makwyk William yeoman 615593 615593 Makwyk, William, of Bosham, Sussex, yeoman 0
5403066 2475958 2475958 defendant Markwyk alias Makwyk William yeoman 615593 615593 Markwyk alias Makwyk, William, of Bosham, Sussex, yeoman 0
5403069 2475959 2475959 defendant Markwyk William yeoman 615593 615593 Markwyk, William, of Bosham, Sussex, yeoman 0
5432730 2484754 2484754 defendant Walter Richard husbandman 615593 615593 Walter, Richard, of Bosham, Sussex, husbandman 0
5432755 2484763 2484763 defendant Markwyk William yeoman 615593 615593 Markwyk, William, of Bosham, Sussex, yeoman 0
5448759 2489523 2489523 defendant Markwyk William yeoman 615593 615593 Markwyk, William, of Bosham, Sussex, yeoman 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);