names

23 rows where place_id = 620493

✎ 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
3735940 1937478 1937478 plaintiff Hooke Thomas husbandman 620493 620493 Hooke, Thomas, of Massyngham Magna, husbandman 0
3737214 1937871 1937871 defendant Hooke Thomas innholder 620493 620493 Hooke, Thomas, of Massyngham Magna, innholder 1
3742201 1939430 1939430 defendant Jaklove Thomas husbandman 620493 620493 Jaklove, Thomas, of Massyngham Magna, husbandman 0
3742202 1939430 1939430 defendant Tolle or Telle Robert husbandman 620493 620493 Tolle or Telle, Robert, of Massyngham Magna, husbandman 1
3742203 1939430 1939430 defendant Hoke Thomas husbandman 620493 620493 Hoke, Thomas, of Massyngham Magna, husbandman 2
3750249 1941995 1941995 defendant Hooke Thomas innholder 620493 620493 Hooke, Thomas, of Massyngham Magna, innholder 0
3843620 1971537 1971537 defendant Goodys Thomas husbandman 620493 620493 Goodys, Thomas, of Massyngham Magna, husbandman 0
3843621 1971537 1971537 defendant Gold John husbandman 620493 620493 Gold, John, of Massyngham Magna, husbandman 1
3872038 1980879 1980879 defendant Hoke Thomas yeoman 620493 620493 Hoke, Thomas, of Massyngham Magna, yeoman 0
3896772 1989132 1989132 defendant Jekler alias Jekleve Thomas yeoman 620493 620493 Jekler alias Jekleve, Thomas, of Massyngham Magna, yeoman 0
3901740 1990804 1990804 defendant Barker Robert husbandman 620493 620493 Barker, Robert, of Massyngham Magna, husbandman 2
3901741 1990804 1990804 defendant Jaklar Thomas husbandman 620493 620493 Jaklar, Thomas, of Massyngham Magna, husbandman 3
3904706 1991832 1991832 defendant Jekelove John yeoman 620493 620493 Jekelove, John, of Massyngham Magna, yeoman 1
3917418 1996184 1996184 defendant Jaklowe Thomas husbandman 620493 620493 Jaklowe, Thomas, of Massyngham Magna, husbandman 0
3917419 1996184 1996184 defendant Hoke Thomas husbandman 620493 620493 Hoke, Thomas, of Massyngham Magna, husbandman 1
3917420 1996184 1996184 defendant Jakloue John   620493 620493 Jakloue, John, of Massyngham Magna, single man 2
4066508 2048313 2048313 defendant Wright Robert   620493 620493 Wright, Robert, of Massyngham Magna, shepherd 0
4066509 2048313 2048313 defendant Watterden John husbandman 620493 620493 Watterden, John, of Massyngham Magna, husbandman 1
4066510 2048313 2048313 defendant Wright William husbandman 620493 620493 Wright, William, of Massyngham Magna, husbandman 2
4066511 2048313 2048313 defendant Asshwell Thomas yeoman 620493 620493 together with Asshwell, Thomas, of Massyngham Magna, yeoman 3
4082671 2054112 2054112 defendant Ashewell Thomas yeoman 620493 620493 Ashewell, Thomas, of Massyngham Magna, yeoman 0
4217528 2101624 2101624 defendant Carey Wimond esq 620493 620493 Carey, Wimond, of Massyngham Magna, or of Snettisham, Norf, esq 0
4242405 2110457 2110457 defendant Smythe Thomas yeoman 620493 620493 Smythe, Thomas, of Massyngham Magna, yeoman 1

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