names

20 rows where place_id = 663376

✎ 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
3968587 2013650 2013650 defendant Bowdushe Richard yeoman 663376 663376 Bowdushe, Richard, of Barkinge, Essex, yeoman 0
4015920 2030383 2030383 defendant Ambrye John yeoman 663376 663376 Ambrye, John, of Barkinge, Essex, yeoman 2
4018196 2031230 2031230 defendant Ciceley Clement esq 663376 663376 Ciceley, Clement, of Barkinge, Essex, esq 1
4026228 2034029 2034029 defendant Russell Thomas yeoman 663376 663376 Russell, Thomas, of Barkinge, Essex, yeoman 2
4026232 2034030 2034030 defendant Russell Thomas yeoman 663376 663376 Russell, Thomas, of Barkinge, Essex, yeoman 2
4074953 2051341 2051341 defendant Mayle William yeoman 663376 663376 Mayle, William, of Barkinge, Essex, yeoman 1
4077456 2052227 2052227 defendant Body Thomas yeoman 663376 663376 Body, Thomas, of Barkinge, Essex, yeoman 0
4080864 2053466 2053466 defendant Mayle George yeoman 663376 663376 Mayle, George, of Barkinge, Essex, yeoman 0
4095617 2058760 2058760 defendant Sysley Anne widow 663376 663376 Sysley, Anne, of Barkinge, Essex, widow 1
4108067 2063159 2063159 defendant Sysseley Clement (legal representative) 663376 663376 Sysseley, Clement, of Barkinge, Essex, esq, administratrix of 2
4112475 2064718 2064718 defendant Parker Anne widow 663376 663376 Parker, Anne, of Barkinge, Essex, widow 3
4167963 2084280 2084280 defendant Stoke Samuel   663376 663376 Stoke, Samuel, of Barkinge, Essex, gent, administrators of 0
4176246 2087169 2087169 defendant Burre John gent 663376 663376 Burre, John, of Barkinge, Essex, gent 0
4185874 2090555 2090555 defendant Howse Nicholas yeoman 663376 663376 Howse, Nicholas, of Barkinge, Essex, yeoman 0
4240264 2109718 2109718 defendant Howe William gent 663376 663376 Howe, William, of Barkinge, Essex, or of Rowstone, Lincs, gent 0
4253545 2114176 2114176 defendant Speyght Marmaduke draper 663376 663376 Speyght, Marmaduke, of Barkinge, Essex, brewer, or of London, draper 0
4260142 2116356 2116356 defendant Speight Marmaduke draper 663376 663376 Speight, Marmaduke, of Barkinge, Essex, brewer, or of London, draper 0
4271546 2120065 2120065 defendant Speight Marmaduke brewer 663376 663376 Speight, Marmaduke, of Barkinge, Essex, brewer 0
4330440 2140479 2140479 defendant Waldegrave William gent 663376 663376 Waldegrave, William, of Barkinge, Essex, gent 2
4354716 2148878 2148878 defendant Goodwyn John chapman 663376 663376 Goodwyn, John, of Barkinge, Essex, chapman 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);