names

15 rows where place_id = 595119

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618961 1873541 1873541 defendant Whityng Nicholas gent 595119 595119 Whityng, Nicholas, of Wareham, Dorset, gent 0
3728082 1935042 1935042 defendant Gay John mercer 595119 595119 Gay, John, of Wareham, Dorset, mercer 0
4073601 2050848 2050848 defendant Assheborne John gent 595119 595119 Assheborne, John, of Wareham, Dorset, gent 0
4091821 2057369 2057369 defendant Cole George merchant 595119 595119 Cole, George, of Wareham, Dorset, merchant 0
4208098 2098391 2098391 defendant Corynge Thomas chapman 595119 595119 Corynge, Thomas, of Wareham, Dorset, chapman 1
4217906 2101752 2101752 defendant Wyldey John weaver 595119 595119 Wyldey, John, of Wareham, Dorset, weaver 0
4248324 2112429 2112429 defendant Cleves Augustine merchant 595119 595119 Cleves, Augustine, of Wareham, Dorset, merchant 1
4262722 2117201 2117201 defendant Cleves Augustine merchant 595119 595119 Cleves, Augustine, of Wareham, Dorset, merchant 1
4377512 2157034 2157034 defendant Barrett John mercer 595119 595119 Barrett, John, of Wareham, Dorset, or of Swallowcliff, Wilts, mercer 0
4846134 2310297 2310297 defendant Stevyn Thomas merchant 595119 595119 Stevyn, Thomas, of Wareham, Dorset, merchant 3
5020033 2362745 2362745 plaintiff Doge Thomas   595119 595119 Doge, Thomas, of Wareham, Dorset 0
5218134 2421039 2421039 defendant Cheke Richard yeoman 595119 595119 Cheke, Richard, of Wareham, Dorset, yeoman 1
5296183 2443874 2443874 defendant Doweman Henry mercer 595119 595119 Doweman, Henry, of Wareham, Dorset, mercer 0
5506371 2506903 2506903 defendant Rawlyn Robert yeoman 595119 595119 Rawlyn, Robert, of Wareham, Dorset, yeoman 0
5521135 2511425 2511425 defendant Boucher Thomas butcher 595119 595119 Boucher, Thomas, of Wareham, Dorset, butcher 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);