names

19 rows where place_id = 636432

✎ 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
3597022 1866694 1866694 plaintiff Quyke John, senior (legal representative) 636432 636432 Quyke, John, senior, of Prytewell, executors of 0
3830712 1967489 1967489 defendant Morecok William waterman 636432 636432 Morecok, William, of Prytewell, waterman 0
4426181 2172992 2172992 defendant Berland John de, senior   636432 636432 Berland, John de, senior, of Prytewell 1
4514504 2204957 2204957 defendant Fynche William butcher 636432 636432 Fynche, William, of Prytewell, butcher 0
4514505 2204957 2204957 defendant Heydon John chapman 636432 636432 Heydon, John, of Prytewell, chapman 1
4514506 2204957 2204957 defendant Heyworth Richard barber 636432 636432 Heyworth, Richard, of Prytewell, barber 2
4514981 2205090 2205090 defendant Peyntour Thomas   636432 636432 Peyntour, Thomas, of Prytewell 0
4516184 2205470 2205470 defendant Barbour Richard   636432 636432 Barbour, Richard, of Prytewell 7
4755284 2282040 2282040 plaintiff atte Graunge Ralph   636432 636432 atte Graunge, Ralph, of Prytewell 0
4770784 2286841 2286841 plaintiff Robkyn John, sen (legal representative) 636432 636432 Robkyn, John, sen, of Prytewell, executors of 0
4777173 2288843 2288843 plaintiff atte Grange Ralph   636432 636432 atte Grange, Ralph, of Prytewell 0
4917215 2331890 2331890 defendant Pakelesham Thomas gent 636432 636432 Pakelesham, Thomas, of Prytewell, gent 0
4962177 2345591 2345591 defendant Hochon William   636432 636432 Hochon, William, of Prytewell, hose maker 0
5025784 2364439 2364439 defendant May Richard gent 636432 636432 May, Richard, of Prytewell, gent 0
5031680 2366130 2366130 defendant Stukke Richard laborer 636432 636432 Stukke, Richard, of Prytewell, laborer 1
5101337 2386803 2386803 defendant Ferthyng Thomas drover 636432 636432 Ferthyng, Thomas, of Prytewell, drover 0
5233872 2425492 2425492 defendant Bowrys William spicer 636432 636432 Bowrys, William, of Prytewell, spicer 0
5486977 2501001 2501001 defendant Frye John butcher 636432 636432 Frye, John, of Prytewell, butcher 0
5607020 2537090 2537090 defendant (not given) John vicar of Kellom 636432 636432 Kellom, John, of Prytewell, vicar of Shoppelond 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);