names

35 rows where place_id = 616963

✎ 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
3717065 1931622 1931622 defendant Bay William   616963 616963 Bay, William, of Barnham Brome, ploughwright 1
3717067 1931622 1931622 defendant Dykney William husbandman 616963 616963 Dykney, William, of Barnham Brome, husbandman 3
3896643 1989089 1989089 defendant Brystowe Robert husbandman 616963 616963 Brystowe, Robert, of Barnham Brome, husbandman 1
3953186 2008181 2008181 defendant Starke John husbandman 616963 616963 Starke, John, of Barnham Brome, husbandman 2
3972804 2015061 2015061 plaintiff Gildensleve Richard (legal representative) 616963 616963 Gildensleve, Richard, of Barnham Brome, yeoman, executrix of 0
3986574 2019938 2019938 plaintiff Whireacre John tailor 616963 616963 Whireacre, John, of Barnham Brome, tailor 0
3986576 2019938 2019938 defendant Whiteacre William husbandman 616963 616963 Whiteacre, William, of Barnham Brome, husbandman 1
3986577 2019938 2019938 defendant Bayse William husbandman 616963 616963 Bayse, William, of Barnham Brome, husbandman 2
3986599 2019946 2019946 plaintiff Whiteacre John tailor 616963 616963 Whiteacre, John, of Barnham Brome, tailor 0
3986601 2019946 2019946 defendant Whiteacre William husbandman 616963 616963 Whiteacre, William, of Barnham Brome, husbandman 1
3986602 2019946 2019946 defendant Bayse William husbandman 616963 616963 Bayse, William, of Barnham Brome, husbandman 2
3996742 2023596 2023596 defendant Cryck Roger yeoman 616963 616963 Cryck, Roger, of Barnham Brome, yeoman 2
4041414 2039420 2039420 defendant Crede George husbandman 616963 616963 Crede, George, of Barnham Brome, husbandman 1
4046018 2041018 2041018 defendant Debney John yeoman 616963 616963 Debney, John, of Barnham Brome, yeoman 2
4046019 2041018 2041018 defendant Chamberlyn Edward yeoman 616963 616963 Chamberlyn, Edward, of Barnham Brome, yeoman 3
4046054 2041027 2041027 defendant Debney John yeoman 616963 616963 Debney, John, of Barnham Brome, yeoman 2
4046055 2041027 2041027 defendant Chamberleyn Edward yeoman 616963 616963 Chamberleyn, Edward, of Barnham Brome, yeoman 3
4053871 2043762 2043762 defendant Chamberleyn Henry gent 616963 616963 Chamberleyn, Henry, of Barnham Brome, gent 0
4063468 2047225 2047225 defendant Chamberleyn Edward esq 616963 616963 Chamberleyn, Edward, of Barnham Brome, esq 0
4064537 2047599 2047599 defendant Chamberleyn Elizabeth widow 616963 616963 Chamberleyn, Elizabeth, of Barnham Brome, widow 0
4147979 2077424 2077424 defendant Rick William   616963 616963 Rick, William, of Barnham Brome, wool chapman 2
4190460 2092217 2092217 defendant Thexton Geoffrey husbandman 616963 616963 Thexton, Geoffrey, of Barnham Brome, husbandman 0
4195471 2093960 2093960 defendant Chamberlyn John gent 616963 616963 Chamberlyn, John, of Barnham Brome, gent 1
4205924 2097615 2097615 defendant Thexton Geoffrey husbandman 616963 616963 Thexton, Geoffrey, of Barnham Brome, husbandman 0
4245284 2111406 2111406 defendant Whiting Thomas husbandman 616963 616963 Whiting, Thomas, of Barnham Brome, husbandman 3
4245289 2111407 2111407 defendant Whiting Thomas husbandman 616963 616963 Whiting, Thomas, of Barnham Brome, husbandman 3
4316954 2136046 2136046 defendant Mallett Thomas   616963 616963 Mallett, Thomas, of Barnham Brome, mason 2
4331977 2140989 2140989 defendant Mallett Thomas husbandman 616963 616963 Mallett, Thomas, of Barnham Brome, husbandman 3
5337076 2456165 2456165 defendant Cok Richard husbandman 616963 616963 Cok, Richard, of Barnham Brome, husbandman 2
5356314 2462048 2462048 defendant Cook Thomas clerk 616963 616963 Cook, Thomas, of Barnham Brome, clerk 0
5373988 2467462 2467462 defendant Myles John husbandman 616963 616963 Myles, John, of Barnham Brome, husbandman 1
5481549 2499409 2499409 defendant Brightyeve John gent 616963 616963 Brightyeve, John, of Barnham Brome, gent 0
5481558 2499411 2499411 defendant Brightyeve John gent 616963 616963 Brightyeve, John, of Barnham Brome, gent 0
5569533 2525651 2525651 plaintiff Hamelyn John clerk 616963 616963 Hamelyn, John, of Barnham Brome, clerk 0
5590535 2532008 2532008 defendant Lans John husbandman 616963 616963 Lans, John, of Barnham Brome, husbandman 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);