names

21 rows where place_id = 640268

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3854337 1974996 1974996 defendant Welsted John husbandman 640268 640268 Welsted, John, of Ellyngham, husbandman 0
3889017 1986566 1986566 defendant Bysshoppe Thomas gent 640268 640268 Bysshoppe, Thomas, of Ellyngham, gent 1
3949507 2006898 2006898 defendant Stevens John husbandman 640268 640268 Stevens, John, of Ellyngham, husbandman 0
3975842 2016113 2016113 defendant Baldrye Edmund husbandman 640268 640268 Baldrye, Edmund, of Ellyngham, husbandman 0
3983854 2018996 2018996 defendant Denton Edmund husbandman 640268 640268 Denton, Edmund, of Ellyngham, husbandman 1
4018343 2031288 2031288 defendant Gunnell John weaver 640268 640268 Gunnell, John, of Ellyngham, weaver 0
4018345 2031289 2031289 defendant Gunell John weaver 640268 640268 Gunell, John, of Ellyngham, weaver 0
4032016 2036119 2036119 defendant Bycker Paul glasier 640268 640268 Bycker, Paul, of Ellyngham, glasier 1
4045279 2040770 2040770 defendant Buckyngham John husbandman 640268 640268 Buckyngham, John, of Ellyngham, husbandman 0
4088513 2056191 2056191 defendant Rosse John miller 640268 640268 Rosse, John, of Ellyngham, miller 0
4088969 2056355 2056355 defendant Ogden Philip gent 640268 640268 Ogden, Philip, of Ellyngham, gent 0
4145546 2076597 2076597 defendant Holden John clerk 640268 640268 Holden, John, of Ellyngham, clerk 0
4147092 2077126 2077126 defendant Greneleff William husbandman 640268 640268 Greneleff, William, of Ellyngham, husbandman 0
4153419 2079292 2079292 defendant Holden John miller 640268 640268 Holden, John, of Ellyngham, miller 1
4207074 2098019 2098019 defendant Mussett John joiner 640268 640268 Mussett, John, of Ellyngham, joiner 2
4207075 2098019 2098019 defendant Sharpe Margaret widow 640268 640268 Sharpe, Margaret, of Ellyngham, widow 3
4241911 2110286 2110286 defendant Kede Thomas yeoman 640268 640268 Kede, Thomas, of Ellyngham, yeoman 0
4245721 2111548 2111548 defendant Allyn Anthony cordwainer 640268 640268 Allyn, Anthony, of Ellyngham, cordwainer 2
4245725 2111549 2111549 defendant Allyn Anthony cordwainer 640268 640268 Allyn, Anthony, of Ellyngham, cordwainer 2
4405777 2166501 2166501 defendant Pigeon John   640268 640268 Pigeon, John, of Ellyngham, "boller" 3
5503855 2506121 2506121 defendant Pyn Joan widow 640268 640268 Pyn, Joan, of Ellyngham, widow 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);