names

54 rows where place_id = 712131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4192125 2092809 2092809 defendant Farmer William husbandman 712131 712131 Farmer, William, of Sallowe, husbandman 1
4192126 2092809 2092809 defendant Treysey Thomas husbandman 712131 712131 Treysey, Thomas, of Sallowe, husbandman 2
4192127 2092809 2092809 defendant Parkynson William husbandman 712131 712131 Parkynson, William, of Sallowe, husbandman 3
4468362 2190771 2190771 plaintiff Bate William   712131 712131 Bate, William, of Sallowe 0
4501212 2200987 2200987 defendant Geffrey John   712131 712131 Geffrey, John, of Sallowe 0
4501338 2201023 2201023 defendant Warde Thomas   712131 712131 Warde, Thomas, of Sallowe 0
4501339 2201023 2201023 defendant Geffrey John   712131 712131 Geffrey, John, of Sallowe 1
4501340 2201023 2201023 defendant Brandon Thomas   712131 712131 Brandon, Thomas, of Sallowe 2
4501342 2201024 2201024 defendant Bailly John   712131 712131 Bailly, John, of Sallowe 0
4568266 2221646 2221646 defendant Bate William   712131 712131 Bate, William, of Sallowe 1
4607635 2233497 2233497 defendant (illegible) William   712131 712131 _, William, of Sallowe 2
4612379 2234943 2234943 defendant Bate William   712131 712131 Bate, William, of Sallowe 1
4620193 2237295 2237295 defendant Gate William   712131 712131 Gate, William, of Sallowe 0
4640154 2243234 2243234 defendant Hauke Thomas   712131 712131 Hauke, Thomas, of Sallowe 2
4658823 2248632 2248632 defendant Haweke Thomas husbandman 712131 712131 Haweke, Thomas, of Sallowe, husbandman 1
4658824 2248632 2248632 defendant Braunston Thomas husbandman 712131 712131 Braunston, Thomas, of Sallowe, husbandman 2
4669508 2256168 2256168 defendant Wryght William laborer 712131 712131 Wryght, William, of Sallowe, laborer 0
4704371 2266743 2266743 defendant Pontrell William chaplain 712131 712131 Pontrell, William, of Sallowe, chaplain 0
4843248 2309405 2309405 defendant Rysley William husbandman 712131 712131 Rysley, William, of Sallowe, husbandman 0
5063135 2375510 2375510 defendant Sandyacre William chaplain 712131 712131 Sandyacre, William, of Sallowe, chaplain 0
5087541 2382735 2382735 defendant Sandyacre William chaplain 712131 712131 Sandyacre, William, of Sallowe, chaplain 0
5093730 2384563 2384563 defendant Geffrey John husbandman 712131 712131 Geffrey, John, of Sallowe, husbandman 0
5093731 2384563 2384563 defendant Sondeacre William chaplain 712131 712131 Sondeacre, William, of Sallowe, chaplain 1
5148771 2400762 2400762 defendant Ive Thomas laborer 712131 712131 Ive, Thomas, of Sallowe, laborer 0
5208819 2418306 2418306 defendant Sonday William chaplain 712131 712131 Sonday, William, of Sallowe, chaplain 0
5208822 2418307 2418307 defendant Sondeacre William chaplain 712131 712131 Sondeacre, William, of Sallowe, chaplain 0
5254069 2431393 2431393 defendant Brystowe William, junior yeoman 712131 712131 Brystowe, William, junior, of Sallowe, yeoman 0
5409857 2477915 2477915 defendant Syngleton Robert gent 712131 712131 Syngleton, Robert, of Sallowe, gent 0
5497497 2504194 2504194 defendant Bristowe William yeoman 712131 712131 Bristowe, William, of Sallowe, yeoman 1
5497498 2504194 2504194 defendant Oxman John, senior husbandman 712131 712131 Oxman, John, senior, of Sallowe, husbandman 2
5497499 2504194 2504194 defendant Oxman John, junior husbandman 712131 712131 Oxman, John, junior, of Sallowe, husbandman 3
5497500 2504194 2504194 defendant Wryght Robert husbandman 712131 712131 Wryght, Robert, of Sallowe, husbandman 4
5497501 2504194 2504194 defendant Russell Gilbert husbandman 712131 712131 Russell, Gilbert, of Sallowe, husbandman 5
5497502 2504194 2504194 defendant Clerke Thomas husbandman 712131 712131 Clerke, Thomas, of Sallowe, husbandman 6
5497503 2504194 2504194 defendant Glasyer Thomas husbandman 712131 712131 Glasyer, Thomas, of Sallowe, husbandman 7
5497506 2504195 2504195 defendant Bristowe William yeoman 712131 712131 Bristowe, William, of Sallowe, yeoman 1
5497507 2504195 2504195 defendant Oxman John, senior husbandman 712131 712131 Oxman, John, senior, of Sallowe, husbandman 2
5497508 2504195 2504195 defendant Oxman John, junior husbandman 712131 712131 Oxman, John, junior, of Sallowe, husbandman 3
5497509 2504195 2504195 defendant Wryght Robert husbandman 712131 712131 Wryght, Robert, of Sallowe, husbandman 4
5497510 2504195 2504195 defendant Russell Gilbert husbandman 712131 712131 Russell, Gilbert, of Sallowe, husbandman 5
5497511 2504195 2504195 defendant Clerke Thomas husbandman 712131 712131 Clerke, Thomas, of Sallowe, husbandman 6
5497512 2504195 2504195 defendant Glasyer Thomas husbandman 712131 712131 Glasyer, Thomas, of Sallowe, husbandman 7
5497515 2504196 2504196 defendant Brystowe William yeoman 712131 712131 Brystowe, William, of Sallowe, yeoman 1
5498859 2504598 2504598 defendant Brystowe William yeoman 712131 712131 Brystowe, William, of Sallowe, yeoman 2
5512293 2508704 2508704 defendant Brystowe William yeoman 712131 712131 Brystowe, William, of Sallowe, yeoman 1
5512296 2508705 2508705 defendant Brystowe William yeoman 712131 712131 Brystowe, William, of Sallowe, yeoman 1
5512297 2508705 2508705 defendant Oxman John, senior husbandman 712131 712131 Oxman, John, senior, of Sallowe, husbandman 2
5512298 2508705 2508705 defendant Oxman John, junior husbandman 712131 712131 Oxman, John, junior, of Sallowe, husbandman 3
5512299 2508705 2508705 defendant Wryght Robert husbandman 712131 712131 Wryght, Robert, of Sallowe, husbandman 4
5512300 2508705 2508705 defendant Russell Gilbert husbandman 712131 712131 Russell, Gilbert, of Sallowe, husbandman 5
5512302 2508705 2508705 defendant Glasyer Thomas husbandman 712131 712131 Glasyer, Thomas, of Sallowe, husbandman 7
5611646 2547377 2547377 plaintiff Godefray William chaplain 712131 712131 Godefray, William, of Sallowe, chaplain 4
5611649 2547378 2547378 plaintiff Braydeston Richard de (legal representative) 712131 712131 Braydeston, Richard de, of Sallowe, formerly vicar, executors of 0
5611653 2547378 2547378 plaintiff Godfray William chaplain 712131 712131 Godfray, William, of Sallowe, chaplain 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);