names

22 rows where place_id = 759933

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4465587 2189910 2189910 plaintiff Wryghte Nicholas le   759933 759933 Wryghte, Nicholas le, of Brunne 0
4486893 2196616 2196616 plaintiff Sempyngham Thomas   759933 759933 Sempyngham, Thomas, of Brunne 0
4584598 2226600 2226600 plaintiff Goldhyng John   759933 759933 Goldhyng, John, of Brunne 0
4597206 2230370 2230370 plaintiff Semphynham Thomas   759933 759933 Semphynham, Thomas, of Brunne 0
4612456 2234961 2234961 defendant Kerewyn John   759933 759933 Kerewyn, John, of Brunne 1
4645755 2244823 2244823 defendant Madon Richard   759933 759933 Madon, Richard, of Brunne 1
4646013 2244906 2244906 defendant Stuyer John   759933 759933 Stuyer, John, of Brunne 5
4719019 2271295 2271295 defendant Folkesworth John gent 759933 759933 Folkesworth, John, of Brunne, gent 0
4739323 2277385 2277385 plaintiff Wynt Robert   759933 759933 Wynt, Robert, of Brunne, vicar 0
4739324 2277385 2277385 defendant Ousthorp Thomas yeoman 759933 759933 Ousthorp, Thomas, of Brunne, yeoman 0
4790288 2293048 2293048 defendant Yonge Simon husbandman 759933 759933 Yonge, Simon, of Brunne, husbandman 0
4830298 2305514 2305514 defendant Marys Thomas husbandman 759933 759933 Marys, Thomas, of Brunne, husbandman 0
4864814 2315969 2315969 defendant Cherd John carpenter 759933 759933 Cherd, John, of Brunne, carpenter 1
4887949 2323038 2323038 defendant Raper John   759933 759933 Raper, John, of Brunne, "raper" 0
4931741 2336314 2336314 defendant Warde Simon tanner 759933 759933 Warde, Simon, of Brunne, tanner 0
4931742 2336314 2336314 defendant Crecy Simon butcher 759933 759933 Crecy, Simon, of Brunne, butcher 1
4931743 2336314 2336314 defendant Corvyser Thomas shoemaker 759933 759933 Corvyser, Thomas, of Brunne, shoemaker 2
5084179 2381773 2381773 defendant Lyghtfote William husbandman 759933 759933 Lyghtfote, William, of Brunne, husbandman 2
5085582 2382179 2382179 defendant Goneld Thomas husbandman 759933 759933 Goneld, Thomas, of Brunne, husbandman 1
5093607 2384528 2384528 defendant Love John husbandman 759933 759933 Love, John, of Brunne, husbandman 1
5612900 2547799 2547799 defendant Gymme John   759933 759933 Gymme, John, of Brunne 0
5628512 2552887 2552887 defendant Sakyn Robert chaplain 759933 759933 Sakyn, Robert, of Brunne, chaplain 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);