names

51 rows where place_id = 762124

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4484817 2195950 2195950 plaintiff Porter John   762124 762124 Porter, John, of Quappelod 0
4516987 2205721 2205721 plaintiff Couper Richard   762124 762124 Couper, Richard, of Quappelod 0
4516990 2205721 2205721 defendant Male William   762124 762124 Male, William, of Quappelod 2
4542052 2213406 2213406 defendant Stoo William thatcher 762124 762124 Stoo, William, of Quappelod, thatcher 0
4543989 2214029 2214029 defendant Roper Peter   762124 762124 Roper, Peter, of Quappelod 1
4546538 2214849 2214849 plaintiff Briston John   762124 762124 Briston, John, of Quappelod 0
4594523 2229545 2229545 plaintiff Porter John, sen   762124 762124 Porter, John, sen, of Quappelod 0
4594526 2229545 2229545 defendant Hayward Richard weaver 762124 762124 Hayward, Richard, of Quappelod, weaver 2
4727028 2273718 2273718 defendant Skynner Roger   762124 762124 Skynner, Roger, of Quappelod, bailiff 2
4727029 2273718 2273718 defendant Scarlet John husbandman 762124 762124 Scarlet, John, of Quappelod, husbandman 3
4727033 2273719 2273719 defendant Skynner Roger   762124 762124 Skynner, Roger, of Quappelod, bailiff 2
4727034 2273719 2273719 defendant Scarlet John husbandman 762124 762124 Scarlet, John, of Quappelod, husbandman 3
4760507 2283638 2283638 defendant Porter William husbandman 762124 762124 Porter, William, of Quappelod, husbandman 0
4787275 2292090 2292090 defendant Brumwell William laborer 762124 762124 Brumwell, William, of Quappelod, laborer 0
4787276 2292090 2292090 defendant Pynder William laborer 762124 762124 Pynder, William, of Quappelod, laborer 1
4787565 2292186 2292186 defendant Cawod William husbandman 762124 762124 Cawod, William, of Quappelod, husbandman 0
4787567 2292187 2292187 defendant Prowet John husbandman 762124 762124 Prowet, John, of Quappelod, husbandman 0
4787568 2292187 2292187 defendant Averay Nigel husbandman 762124 762124 Averay, Nigel, of Quappelod, husbandman 1
4787569 2292187 2292187 defendant Belle John husbandman 762124 762124 Belle, John, of Quappelod, husbandman 2
4787570 2292187 2292187 defendant Idon John husbandman 762124 762124 Idon, John, of Quappelod, husbandman 3
4787572 2292188 2292188 defendant Gamyll Simon, senior husbandman 762124 762124 Gamyll, Simon, senior, of Quappelod, husbandman 0
4787577 2292189 2292189 defendant Welby Geoffrey husbandman 762124 762124 Welby, Geoffrey, of Quappelod, husbandman 0
4787579 2292190 2292190 defendant Godehusband John husbandman 762124 762124 Godehusband, John, of Quappelod, husbandman 0
4795005 2294579 2294579 defendant Saunderson Thomas butcher 762124 762124 Saunderson, Thomas, of Quappelod, butcher 0
4800693 2296399 2296399 defendant Gamoll Simon husbandman 762124 762124 Gamoll, Simon, of Quappelod, husbandman 0
4865143 2316072 2316072 defendant Gamull Simon, junior husbandman 762124 762124 Gamull, Simon, junior, of Quappelod, husbandman 0
4888272 2323138 2323138 defendant Prowet John husbandman 762124 762124 Prowet, John, of Quappelod, husbandman 1
4944544 2340276 2340276 plaintiff Haultofte William   762124 762124 Haultofte, William, of Quappelod 0
5006270 2358730 2358730 plaintiff Scarlet William husbandman 762124 762124 Scarlet, William, of Quappelod, husbandman 0
5025122 2364247 2364247 plaintiff Ingram John   762124 762124 Ingram, John, of Quappelod 0
5025124 2364247 2364247 defendant Robertson William husbandman 762124 762124 Robertson, William, of Quappelod, husbandman 0
5025125 2364247 2364247 defendant Hull William husbandman 762124 762124 Hull, William, of Quappelod, husbandman 1
5025126 2364247 2364247 defendant Chapman John husbandman 762124 762124 Chapman, John, of Quappelod, husbandman 2
5069045 2377240 2377240 plaintiff Pynchebek William gent 762124 762124 Pynchebek, William, of Quappelod, gent 0
5086377 2382411 2382411 defendant Wenysley John, senior yeoman 762124 762124 Wenysley, John, senior, of Quappelod, yeoman 0
5086378 2382411 2382411 defendant Pynder John, senior yeoman 762124 762124 Pynder, John, senior, of Quappelod, yeoman 1
5086379 2382411 2382411 defendant Taylour Thomas yeoman 762124 762124 Taylour, Thomas, of Quappelod, yeoman 2
5093598 2384526 2384526 defendant Manner John laborer 762124 762124 Manner, John, of Quappelod, laborer 3
5093599 2384526 2384526 defendant Palfreman John laborer 762124 762124 Palfreman, John, of Quappelod, husbandman, or of Holbeche, laborer 4
5104304 2387681 2387681 defendant Glymne or Glynne Thomas husbandman 762124 762124 Glymne or Glynne, Thomas, of Quappelod, husbandman 1
5104305 2387681 2387681 defendant Wilsey Robert husbandman 762124 762124 Wilsey, Robert, of Quappelod, husbandman 2
5104306 2387681 2387681 defendant Washwy- John yeoman 762124 762124 Washwy-, John, of Quappelod, yeoman 3
5112484 2390037 2390037 defendant Stokwell Thomas shoemaker 762124 762124 Stokwell, Thomas, of Quappelod, shoemaker 2
5112486 2390037 2390037 defendant Seman Thomas husbandman 762124 762124 Seman, Thomas, of Quappelod, husbandman 4
5119707 2392201 2392201 defendant Porter John yeoman 762124 762124 Porter, John, of Quappelod, yeoman 0
5123514 2393331 2393331 defendant Weller John yeoman 762124 762124 Weller, John, of Quappelod, yeoman 0
5240533 2427445 2427445 defendant Daweson Alan husbandman 762124 762124 Daweson, Alan, of Quappelod, husbandman 0
5240534 2427445 2427445 defendant Spenser John husbandman 762124 762124 Spenser, John, of Quappelod, husbandman 1
5263376 2434293 2434293 defendant Wel by Thomas husbandman 762124 762124 Wel by, Thomas, of Quappelod, husbandman 0
5267742 2435671 2435671 plaintiff Ydon John   762124 762124 Ydon, John, of Quappelod 0
5267744 2435671 2435671 defendant Welbt Thomas husbandman 762124 762124 Welbt, Thomas, of Quappelod, husbandman 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);