names

22 rows where place_id = 609262

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3677695 1919071 1919071 defendant Marten Thomas yeoman 609262 609262 Marten, Thomas, of Stonham, yeoman 0
3709587 1929308 1929308 defendant Damme Robert gent 609262 609262 Damme, Robert, of Stonham, gent 0
4183535 2089723 2089723 defendant Forsett William gent 609262 609262 (Forsett, William, of Stonham, gent 1
4212075 2099773 2099773 defendant Forcett William gent 609262 609262 Forcett, William, of Stonham, gent 0
4244800 2111249 2111249 defendant Blomefild William yeoman 609262 609262 Blomefild, William, of Stonham, yeoman 1
4307136 2132631 2132631 defendant Preston John yeoman 609262 609262 Preston, John, of Stonham, yeoman 1
4417655 2170404 2170404 defendant Gernegan Peter   609262 609262 Gernegan, Peter, of Stonham 0
4425036 2172670 2172670 defendant Bukston Richard   609262 609262 Bukston, Richard, of Stonham 0
4425042 2172672 2172672 defendant Bokston Peter   609262 609262 Bokston, Peter, of Stonham 0
4519424 2206435 2206435 defendant Waryn Richard   609262 609262 Waryn, Richard, of Stonham 1
4519427 2206436 2206436 defendant Waryn Richard   609262 609262 Waryn, Richard, of Stonham 1
4548213 2215383 2215383 plaintiff Chaworth Thomas   609262 609262 Chaworth, Thomas, of Stonham Abbot, parson 0
4608646 2233809 2233809 defendant Bradewey Richard   609262 609262 Bradewey, Richard, of Stonham 0
4610515 2234359 2234359 defendant Knyght Robert   609262 609262 Knyght, Robert, of Stonham 1
4722147 2272256 2272256 defendant Bryd Andrew chaplain 609262 609262 Bryd, Andrew, of Stonham, chaplain 0
4752260 2281128 2281128 defendant Busshe Peter laborer 609262 609262 Busshe, Peter, of Stonham, laborer 4
4822065 2302977 2302977 plaintiff Sengylton Thomas, senior   609262 609262 Sengylton, Thomas, senior, of Stonham 0
5038887 2368275 2368275 defendant Campe William husbandman 609262 609262 Campe, William, of Stonham, husbandman 1
5329061 2453772 2453772 defendant Buxton Thomas yeoman 609262 609262 Buxton, Thomas, of Stonham, yeoman 0
5545417 2518648 2518648 plaintiff Sawnder John   609262 609262 Sawnder, John, of Stonham 1
5593247 2532869 2532869 defendant Wylchyn John   609262 609262 Wylchyn, John, of Stonham, wheelwright 2
5614433 2548307 2548307 defendant Bockyng R   609262 609262 Bockyng, R, of Stonham 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);