names

25 rows where place_id = 677956

✎ 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
4029226 2035098 2035098 plaintiff Curlyngton John butcher 677956 677956 Curlyngton, John, of Oxboroughe, butcher 0
4061411 2046485 2046485 defendant Hewar Arthur (legal representative) 677956 677956 Hewar, Arthur, of Oxboroughe, gent, executors of 0
4128102 2070342 2070342 defendant Dyker Edward   677956 677956 Dyker, Edward, of Oxboroughe, shepherd 1
4139327 2074432 2074432 defendant Lackford Edward butcher 677956 677956 Lackford, Edward, of Oxboroughe, butcher 0
4151507 2078650 2078650 defendant Lackford Edward butcher 677956 677956 Lackford, Edward, of Oxboroughe, butcher 0
4155175 2079903 2079903 defendant Lackford Edward butcher 677956 677956 Lackford, Edward, of Oxboroughe, butcher 0
4157619 2080739 2080739 defendant Lackford Edward butcher 677956 677956 Lackford, Edward, of Oxboroughe, butcher 0
4182261 2089273 2089273 defendant Lackford Edward yeoman 677956 677956 Lackford, Edward, of Oxboroughe, yeoman 0
4182265 2089274 2089274 defendant Lackford Edward yeoman 677956 677956 Lackford, Edward, of Oxboroughe, yeoman 0
4186044 2090608 2090608 defendant Hewer Francis yeoman 677956 677956 Hewer, Francis, of Oxboroughe, yeoman 0
4186045 2090608 2090608 defendant Dyker Edward   677956 677956 Dyker, Edward, of Oxboroughe, shepherd 1
4199317 2095316 2095316 defendant Haker Francis yeoman 677956 677956 Haker, Francis, of Oxboroughe, yeoman 0
4199318 2095316 2095316 defendant Tryndell Robert blacksmith 677956 677956 Tryndell, Robert, of Oxboroughe, blacksmith 1
4199319 2095316 2095316 defendant Lane John husbandman 677956 677956 Lane, John, of Oxboroughe, husbandman 2
4199321 2095317 2095317 defendant Warden Thomas tailor 677956 677956 Warden, Thomas, of Oxboroughe, tailor 0
4199322 2095317 2095317 defendant Lewes Henry tailor 677956 677956 Lewes, Henry, of Oxboroughe, tailor 1
4199323 2095317 2095317 defendant Hogge William yeoman 677956 677956 Hogge, William, of Oxboroughe, yeoman 2
4199324 2095317 2095317 defendant Osborne Thomas cooper 677956 677956 Osborne, Thomas, of Oxboroughe, cooper 3
4211700 2099646 2099646 defendant Dykar Edward   677956 677956 Dykar, Edward, of Oxboroughe, shepherd 0
4212008 2099749 2099749 defendant Watson Francis   677956 677956 Watson, Francis, of Oxboroughe, wheelwright 0
4212009 2099749 2099749 defendant Lackford Edward butcher 677956 677956 Lackford, Edward, of Oxboroughe, butcher 1
4324232 2138505 2138505 defendant Anguyshe Thomas gent 677956 677956 Anguyshe, Thomas, of Oxboroughe, gent 0
4324233 2138505 2138505 defendant Wright Lawrence yeoman 677956 677956 Wright, Lawrence, of Oxboroughe, yeoman 1
4335851 2142267 2142267 defendant Daye Henry gent 677956 677956 Daye, Henry, of Oxboroughe, gent 0
4394930 2162890 2162890 defendant Breten Thomas gent 677956 677956 Breten, Thomas, of Oxboroughe, gent 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);