names

17 rows where place_id = 606808

✎ 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
3666593 1915491 1915491 defendant Prentys John tailor 606808 606808 Prentys, John, of Towne Mallyng, tailor 0
3666595 1915491 1915491 defendant Chalton John cooper 606808 606808 Chalton, John, of Towne Mallyng, cooper 2
3698810 1925846 1925846 defendant Ayherst Thomas husbandman 606808 606808 Ayherst, Thomas, of Towne Mallyng, husbandman 3
3708168 1928854 1928854 defendant Maye John husbandman 606808 606808 Maye, John, of Towne Mallyng, husbandman 2
3723504 1933620 1933620 defendant Vyne Edward laborer 606808 606808 Vyne, Edward, of Towne Mallyng, laborer 0
3727743 1934947 1934947 defendant Style John shoemaker 606808 606808 Style, John, of Towne Mallyng, shoemaker 0
3753388 1942997 1942997 defendant Lovelas William gent 606808 606808 Lovelas, William, of Towne Mallyng, gent 0
3763361 1946168 1946168 defendant Pravys John clothier 606808 606808 Pravys, John, of Towne Mallyng, clothier 3
3818312 1963635 1963635 defendant Person John husbandman 606808 606808 Person, John, of Towne Mallyng, husbandman 0
3831895 1967869 1967869 plaintiff Hasell Richard butcher 606808 606808 Hasell, Richard, of Towne Mallyng, butcher 0
3854917 1975183 1975183 defendant Norton William gent 606808 606808 Norton, William, of Towne Mallyng, gent 0
3861955 1977458 1977458 defendant Cokker John butcher 606808 606808 Cokker, John, of Towne Mallyng, butcher 1
3865467 1978668 1978668 defendant Godhewe Nicholas tailor 606808 606808 Godhewe, Nicholas, of Towne Mallyng, tailor 0
3865469 1978668 1978668 defendant ap Richard Owen tiler 606808 606808 ap Richard, Owen, of Towne Mallyng, tiler 2
3870733 1980456 1980456 defendant Skate William innholder 606808 606808 Skate, William, of Towne Mallyng, innholder 0
3892878 1987867 1987867 defendant Bycker Thomas butcher 606808 606808 Bycker, Thomas, of Towne Mallyng, butcher 0
3983675 2018931 2018931 defendant Wylkyn Thomas yeoman 606808 606808 Wylkyn, Thomas, of Towne Mallyng, yeoman 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);