names

39 rows where place_id = 609519

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678791 1919434 1919434 defendant Okyr Richard laborer 609519 609519 Okyr, Richard, of West Dereham, laborer 0
3820426 1964271 1964271 defendant Laneham William husbandman 609519 609519 Laneham, William, of West Dereham, husbandman 0
3820427 1964271 1964271 defendant Segewyk John carpenter 609519 609519 Segewyk, John, of West Dereham, carpenter 1
3996044 2023337 2023337 defendant Nicoll Lewis gent 609519 609519 Nicoll, Lewis, of West Dereham, gent 0
4000878 2025086 2025086 defendant Crowne John   609519 609519 Crowne, John, of West Dereham, shepherd 0
4029223 2035097 2035097 defendant Pygott Adam laborer 609519 609519 Pygott, Adam, of West Dereham, laborer 1
4060303 2046084 2046084 defendant Nycoll Lewis gent 609519 609519 Nycoll, Lewis, of West Dereham, gent 3
4101833 2060965 2060965 defendant Thorowgood Thomas gent 609519 609519 Thorowgood, Thomas, of West Dereham, gent 0
4131418 2071556 2071556 defendant Pledger John husbandman 609519 609519 Pledger, John, of West Dereham, husbandman 0
4131419 2071556 2071556 defendant Adkyn John husbandman 609519 609519 Adkyn, John, of West Dereham, husbandman 1
4131420 2071556 2071556 defendant Moore Richard husbandman 609519 609519 Moore, Richard, of West Dereham, husbandman 2
4131421 2071556 2071556 defendant Randes Edward husbandman 609519 609519 Randes, Edward, of West Dereham, husbandman 3
4165369 2083394 2083394 defendant Rolf John weaver 609519 609519 Rolf, John, of West Dereham, weaver 2
4168419 2084439 2084439 defendant Browne Richard laborer 609519 609519 Browne, Richard, of West Dereham, laborer 3
4177180 2087490 2087490 defendant Kynne or Kynge John husbandman 609519 609519 Kynne or Kynge, John, of West Dereham, husbandman 0
4177181 2087490 2087490 defendant Malster Robert husbandman 609519 609519 Malster, Robert, of West Dereham, husbandman 1
4177182 2087490 2087490 defendant Remyngton Thomas husbandman 609519 609519 Remyngton, Thomas, of West Dereham, husbandman 2
4179879 2088438 2088438 defendant Towneshend Giles gent 609519 609519 Towneshend, Giles, of West Dereham, gent 0
4184158 2089956 2089956 defendant Barton Peter gent 609519 609519 Barton, Peter, of West Dereham, gent 0
4190417 2092190 2092190 defendant Kynge John husbandman 609519 609519 Kynge, John, of West Dereham, husbandman 0
4190418 2092190 2092190 defendant Thorbrond William husbandman 609519 609519 Thorbrond, William, of West Dereham, husbandman 1
4205774 2097567 2097567 defendant Thybrane or Thorbrande William husbandman 609519 609519 Thybrane or Thorbrande, William, of West Dereham, husbandman 3
4212760 2100003 2100003 defendant Nicholls Lewis gent 609519 609519 Nicholls, Lewis, of West Dereham, gent 0
4213599 2100277 2100277 defendant Nicholas Lewis gent 609519 609519 Nicholas, Lewis, of West Dereham, gent 0
4229346 2105745 2105745 defendant Hamond Thomas laborer 609519 609519 Hamond, Thomas, of West Dereham, laborer 2
4246510 2111808 2111808 defendant Hamond Thomas laborer 609519 609519 Hamond, Thomas, of West Dereham, laborer 1
4246511 2111808 2111808 defendant Monners John laborer 609519 609519 Monners, John, of West Dereham, laborer 2
4291204 2126921 2126921 defendant Tounshend Giles gent 609519 609519 Tounshend, Giles, of West Dereham, gent 0
4316961 2136048 2136048 defendant Lockwood John turner 609519 609519 Lockwood, John, of West Dereham, turner 3
4326973 2139353 2139353 defendant Wase William husbandman 609519 609519 Wase, William, of West Dereham, husbandman 0
4327922 2139663 2139663 defendant Taylor Philip laborer 609519 609519 Taylor, Philip, of West Dereham, laborer 0
4345503 2145697 2145697 defendant Spyncke Richard thatcher 609519 609519 Spyncke, Richard, of West Dereham, thatcher 2
4352221 2148011 2148011 defendant Wace William husbandman 609519 609519 Wace, William, of West Dereham, husbandman 0
4352222 2148011 2148011 defendant Malster Robert husbandman 609519 609519 Malster, Robert, of West Dereham, husbandman 1
4402940 2165569 2165569 defendant Pynchebecke Richard gent 609519 609519 Pynchebecke, Richard, of West Dereham, gent 1
4411447 2168419 2168419 defendant Maulster Robert yeoman 609519 609519 Maulster, Robert, of West Dereham, yeoman 2
5057114 2373708 2373708 defendant Denyel John husbandman 609519 609519 Denyel, John, of West Dereham, husbandman 0
5080459 2380643 2380643 defendant Denyell John husbandman 609519 609519 Denyell, John, of West Dereham, husbandman 3
5538437 2516505 2516505 defendant Bunt alias Fyssher John husbandman 609519 609519 Bunt alias Fyssher, John, of West Dereham, husbandman 4

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);