names

28 rows where place_id = 624241

✎ 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
3697618 1925478 1925478 defendant Styrtevaunt William   624241 624241 Styrtevaunt, William, of Norwell, parish clerk 3
3756900 1944134 1944134 defendant Broune James carpenter 624241 624241 Broune, James, of Norwell, carpenter 0
3892097 1987608 1987608 defendant Wooddall John gent 624241 624241 Wooddall, John, of Norwell, gent 0
4011204 2028779 2028779 defendant Cooke William yeoman 624241 624241 Cooke, William, of Norwell, yeoman 1
4068781 2049124 2049124 defendant Hanson Richard clerk 624241 624241 Hanson, Richard, of Norwell, clerk 0
4144952 2076394 2076394 defendant Porter John yeoman 624241 624241 Porter, John, of Norwell, yeoman 0
4157763 2080787 2080787 defendant Levers Stephen yeoman 624241 624241 Levers, Stephen, of Norwell, yeoman 1
4170205 2085076 2085076 defendant Clarke William yeoman 624241 624241 Clarke, William, of Norwell, yeoman 0
4209557 2098894 2098894 defendant Brygg William husbandman 624241 624241 Brygg, William, of Norwell, husbandman 0
4282938 2123934 2123934 defendant Harrope Edmund yeoman 624241 624241 Harrope, Edmund, of Norwell, yeoman 0
4406327 2166682 2166682 defendant Goddard Henry blacksmith 624241 624241 Goddard, Henry, of Norwell, blacksmith 1
4586403 2227161 2227161 defendant Gambrell Richard   624241 624241 Gambrell, Richard, of Norwell 0
4596441 2230135 2230135 defendant Gaymerell Richard   624241 624241 Gaymerell, Richard, of Norwell 0
4788691 2292517 2292517 defendant Gamerell Richard husbandman 624241 624241 Gamerell, Richard, of Norwell, husbandman 1
4961677 2345457 2345457 defendant Irland John husbandman 624241 624241 Irland, John, of Norwell, husbandman 0
4979315 2350773 2350773 defendant Thorp Olivia widow 624241 624241 Thorp, Olivia, of Norwell, widow 0
4979316 2350773 2350773 defendant Normandy William husbandman 624241 624241 Normandy, William, of Norwell, husbandman 1
4979317 2350773 2350773 defendant Paynell John weaver 624241 624241 Paynell, John, of Norwell, weaver 2
5018845 2362399 2362399 defendant Dalamond Thomas husbandman 624241 624241 Dalamond, Thomas, of Norwell, husbandman 0
5045725 2370356 2370356 defendant Grene Robert husbandman 624241 624241 Grene, Robert, of Norwell, husbandman 0
5096225 2385333 2385333 defendant Legat or Legeard Richard yeoman 624241 624241 Legat or Legeard, Richard, of Norwell, yeoman 1
5117526 2391559 2391559 defendant Legeard Henry yeoman 624241 624241 Legeard, Henry, of Norwell, yeoman 0
5322075 2451675 2451675 defendant Elot John husbandman 624241 624241 Elot, John, of Norwell, husbandman 0
5520997 2511388 2511388 defendant Holme Nicholas husbandman 624241 624241 Holme, Nicholas, of Norwell, husbandman 0
5520999 2511389 2511389 defendant Holme Nicholas husbandman 624241 624241 Holme, Nicholas, of Norwell, husbandman 0
5521001 2511390 2511390 defendant Holme Nicholas husbandman 624241 624241 Holme, Nicholas, of Norwell, husbandman 0
5573712 2526876 2526876 defendant Grene Christopher clerk 624241 624241 Grene, Christopher, of Norwell, clerk 1
5605873 2536729 2536729 plaintiff Strettevaunt Lawrence yeoman 624241 624241 Strettevaunt, Lawrence, of Norwell, 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);