names

39 rows where place_id = 773040

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4596128 2230041 2230041 defendant Blowere Simon   773040 773040 Blowere, Simon, of Rokelond Toftys 0
4965020 2346455 2346455 defendant Fuller John yeoman 773040 773040 Fuller, John, of Rokelond Toftys, yeoman 2
5019692 2362641 2362641 defendant Gladewyn John husbandman 773040 773040 Gladewyn, John, of Rokelond Toftys, or of Swafham Earl, Cams, husbandman 0
5044679 2370041 2370041 defendant Marleburgh William clerk 773040 773040 Marleburgh, William, of Rokelond Toftys, clerk 0
5044681 2370041 2370041 defendant Wyre John carpenter 773040 773040 Wyre, John, of Rokelond Toftys, carpenter 2
5048038 2371035 2371035 defendant Eyrys John husbandman 773040 773040 Eyrys, John, of Rokelond Toftys, husbandman 1
5102246 2387075 2387075 defendant Eyre John carpenter 773040 773040 Eyre, John, of Rokelond Toftys, carpenter 1
5106753 2388401 2388401 defendant Eyr John carpenter 773040 773040 Eyr, John, of Rokelond Toftys, carpenter 1
5110217 2389395 2389395 defendant Webster Richard yeoman 773040 773040 Webster, Richard, of Rokelond Toftys, yeoman 0
5110218 2389395 2389395 defendant Eyr John yeoman 773040 773040 Eyr, John, of Rokelond Toftys, yeoman 1
5114460 2390627 2390627 defendant Eyr John carpenter 773040 773040 Eyr, John, of Rokelond Toftys, carpenter 1
5127517 2394526 2394526 defendant Osmond John clerk 773040 773040 Osmond, John, of Rokelond Toftys, clerk 0
5135058 2396750 2396750 defendant Eyr John carpenter 773040 773040 Eyr, John, of Rokelond Toftys, carpenter 1
5136988 2397335 2397335 defendant Osmond John   773040 773040 Osmond, John, of Rokelond Toftys, vicar 4
5146467 2400099 2400099 defendant Dawys John husbandman 773040 773040 Dawys, John, of Rokelond Toftys, husbandman 0
5146471 2400100 2400100 defendant Dawys John husbandman 773040 773040 Dawys, John, of Rokelond Toftys, husbandman 0
5155323 2402707 2402707 defendant Webster Richard   773040 773040 Webster, Richard, of Rokelond Toftys, pedlar 1
5155324 2402707 2402707 defendant Webster Thomas   773040 773040 Webster, Thomas, of Rokelond Toftys, pedlar 2
5157548 2403336 2403336 defendant Osmond John   773040 773040 Osmond, John, of Rokelond Toftys, vicar 3
5163271 2404989 2404989 defendant Eyr John carpenter 773040 773040 Eyr, John, of Rokelond Toftys, carpenter 1
5166602 2405951 2405951 defendant Daweys John husbandman 773040 773040 Daweys, John, of Rokelond Toftys, husbandman 0
5172008 2407528 2407528 defendant Webster Richard   773040 773040 Webster, Richard, of Rokelond Toftys, pedlar 1
5172009 2407528 2407528 defendant Webster Thomas   773040 773040 Webster, Thomas, of Rokelond Toftys, pedlar 2
5173426 2407930 2407930 defendant Osmond John   773040 773040 Osmond, John, of Rokelond Toftys, vicar 4
5181412 2410306 2410306 defendant Osmond John clerk 773040 773040 Osmond, John, of Rokelond Toftys, clerk 0
5181413 2410306 2410306 defendant Eyre John yeoman 773040 773040 Eyre, John, of Rokelond Toftys, yeoman 1
5181414 2410306 2410306 defendant Duffeld Richard husbandman 773040 773040 Duffeld, Richard, of Rokelond Toftys, husbandman 2
5193410 2413798 2413798 defendant Osmond John   773040 773040 Osmond, John, of Rokelond Toftys, vicar 1
5203615 2416812 2416812 defendant Dawes John yeoman 773040 773040 Dawes, John, of Rokelond Toftys, yeoman 0
5214685 2420022 2420022 defendant Eyre John yeoman 773040 773040 Eyre, John, of Rokelond Toftys, yeoman 0
5238153 2426747 2426747 defendant Webster Richard yeoman 773040 773040 Webster, Richard, of Rokelond Toftys, yeoman 1
5245426 2428815 2428815 defendant Eyre John carpenter 773040 773040 Eyre, John, of Rokelond Toftys, carpenter 0
5268428 2435891 2435891 defendant Eyre John carpenter 773040 773040 Eyre, John, of Rokelond Toftys, carpenter 0
5268433 2435892 2435892 defendant Eyre John carpenter 773040 773040 Eyre, John, of Rokelond Toftys, carpenter 0
5270724 2436540 2436540 defendant Roper Katherine widow 773040 773040 Roper, Katherine, of Rokelond Toftys, widow 1
5333861 2455199 2455199 defendant Grom Richard butcher 773040 773040 Grom, Richard, of Rokelond Toftys, butcher 1
5370561 2466380 2466380 defendant Fytte Robert husbandman 773040 773040 Fytte, Robert, of Rokelond Toftys, husbandman 0
5519100 2510818 2510818 defendant Harwell John yeoman 773040 773040 Harwell, John, of Rokelond Toftys, yeoman 0
5579880 2528787 2528787 defendant Duffeld John, junior weaver 773040 773040 Duffeld, John, junior, of Rokelond Toftys, weaver 2

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