names

28 rows where place_id = 598238

✎ 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
3631675 1904719 1904719 defendant Toukys John yeoman 598238 598238 Toukys, John, of Evysham, yeoman 0
3647631 1909644 1909644 defendant Darfytt or Darsytt John yeoman 598238 598238 Darfytt or Darsytt, John, of Evysham, yeoman 0
3676651 1918735 1918735 defendant Wyllys Thomas (legal representative) 598238 598238 Wyllys, Thomas, of Evysham, butcher, executrix of 0
3676652 1918735 1918735 defendant Wyllys Joan widow 598238 598238 Wyllys, Joan, of Evysham, widow 1
3693292 1924113 1924113 defendant Fylde Thomas draper 598238 598238 Fylde, Thomas, of Evysham, draper 0
3705127 1927891 1927891 defendant Holgrave Thomas gent 598238 598238 Holgrave, Thomas, of Evysham, gent 1
3725183 1934163 1934163 defendant Mylles Joan widow 598238 598238 Mylles, Joan, of Evysham, widow 2
3740476 1938878 1938878 plaintiff Rudhale John gent 598238 598238 Rudhale, John, of Evysham, gent 0
3772784 1949182 1949182 defendant Andrewes Thomas husbandman 598238 598238 Andrewes, Thomas, of Evysham, husbandman 0
3790433 1954830 1954830 plaintiff Watson Thomas yeoman 598238 598238 Watson, Thomas, of Evysham, yeoman 0
3791891 1955312 1955312 plaintiff Alye Adam (legal representative) 598238 598238 Alye, Adam, of Evysham, executors of 0
3791900 1955313 1955313 plaintiff Alye Adam (legal representative) 598238 598238 Alye, Adam, of Evysham, miller, executors of 0
3826733 1966211 1966211 plaintiff Baston Walter yeoman 598238 598238 Baston, Walter, of Evysham, yeoman 0
3826735 1966212 1966212 plaintiff Baston Walter yeoman 598238 598238 Baston, Walter, of Evysham, yeoman 0
3883905 1984887 1984887 defendant Clue William fuller 598238 598238 Clue, William, of Evysham, fuller 1
3914413 1995164 1995164 defendant Wery Robert tailor 598238 598238 Wery, Robert, of Evysham, tailor 1
4067556 2048714 2048714 defendant Baylye Richard draper 598238 598238 Baylye, Richard, of Evysham, draper 1
4067557 2048714 2048714 defendant Elle John (legal representative) 598238 598238 Elle, John, of Evysham, draper, administratrix of 2
4067558 2048714 2048714 defendant Elle Anne widow 598238 598238 Elle, Anne, of Evysham, widow 3
4101106 2060708 2060708 defendant Newington John yeoman 598238 598238 Newington, John, of Evysham, yeoman 2
5015757 2361493 2361493 defendant Sandull Thomas weaver 598238 598238 Sandull, Thomas, of Evysham, weaver 0
5036484 2367532 2367532 defendant Bocher Robert butcher 598238 598238 Bocher, Robert, of Evysham, butcher 0
5098679 2386043 2386043 defendant Blakeman Richard husbandman 598238 598238 Blakeman, Richard, of Evysham, husbandman 1
5103268 2387385 2387385 defendant Dyngley Richard baker 598238 598238 Dyngley, Richard, of Evysham, baker 1
5301724 2445472 2445472 defendant Melen William yeoman 598238 598238 Melen, William, of Evysham, yeoman 0
5336862 2456091 2456091 defendant Bente Robert yeoman 598238 598238 Bente, Robert, of Evysham, yeoman 0
5354089 2461343 2461343 defendant Cole Robert barker 598238 598238 Cole, Robert, of Evysham, barker 0
5586592 2530843 2530843 plaintiff Love Egewin (legal representative) 598238 598238 Love, Egewin, of Evysham, clothier, executors of 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);