names

25 rows where place_id = 759366

✎ 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
4460914 2188481 2188481 defendant Wowere John   759366 759366 Wowere, John, of Wherewell 0
4669623 2256210 2256210 defendant atte Nassh Mary widow 759366 759366 atte Nassh, Mary, of Wherewell, widow 1
4669627 2256211 2256211 defendant atte Nasshe Mary widow 759366 759366 atte Nasshe, Mary, of Wherewell, widow 1
4673103 2257231 2257231 plaintiff Courtyour John   759366 759366 Courtyour, John, of Wherewell, on his own account 0
4706478 2267405 2267405 defendant Porter Isabel widow 759366 759366 Porter, Isabel, of Wherewell, widow 3
4753040 2281340 2281340 plaintiff Serle William   759366 759366 Serle, William, of Wherewell 1
4763423 2284548 2284548 plaintiff Gowe Robert   759366 759366 Gowe, Robert, of Wherewell, prebendary of the prebend 0
4765136 2285073 2285073 defendant Souter Alan   759366 759366 Souter, Alan, of Wherewell, shoe maker 2
4816039 2301107 2301107 defendant Wyltshyre John husbandman 759366 759366 Wyltshyre, John, of Wherewell, husbandman 0
4816041 2301107 2301107 defendant Coryor William tailor 759366 759366 Coryor, William, of Wherewell, tailor 2
4816042 2301107 2301107 defendant Halle Alan shoemaker 759366 759366 Halle, Alan, of Wherewell, shoemaker 3
4816043 2301107 2301107 defendant Heyer William laborer 759366 759366 Heyer, William, of Wherewell, laborer 4
4951695 2342486 2342486 defendant Dyckys Richard husbandman 759366 759366 Dyckys, Richard, of Wherewell, husbandman 0
5136647 2397241 2397241 plaintiff Overy Juliane   759366 759366 Overy, Juliane, of Wherewell, abbess of the House of Holy Cross 0
5153697 2402240 2402240 defendant Aubrey Thomas husbandman 759366 759366 Aubrey, Thomas, of Wherewell, husbandman 0
5153698 2402240 2402240 defendant Saunder Thomas weaver 759366 759366 Saunder, Thomas, of Wherewell, weaver 1
5193787 2413905 2413905 defendant Tanner John tanner 759366 759366 Tanner, John, of Wherewell, tanner 0
5234016 2425537 2425537 defendant Hadde Nicholas chapman 759366 759366 Hadde, Nicholas, of Wherewell, chapman 2
5274030 2437481 2437481 defendant Weste (illegible) yeoman 759366 759366 Weste, ---, of Wherewell, yeoman 0
5275456 2437890 2437890 defendant Rede John chaplain 759366 759366 Rede, John, of Wherewell, chaplain 0
5310924 2448300 2448300 defendant West William yeoman 759366 759366 West, William, of Wherewell, yeoman 0
5384798 2470727 2470727 defendant Symkyns William   759366 759366 Symkyns, William, of Wherewell 3
5396733 2474159 2474159 defendant Symkyns William smith 759366 759366 Symkyns, William, of Wherewell, smith 2
5396737 2474160 2474160 defendant Symkyns Willism smith 759366 759366 Symkyns, Willism, of Wherewell, smith 2
5479770 2498961 2498961 defendant Symkyns William smith 759366 759366 Symkyns, William, of Wherewell, smith 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);