names

12 rows where place_id = 602197

✎ 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
3648917 1910049 1910049 defendant Wylkynson Richard merchant of the staple 602197 602197 Wylkynson, Richard, of Harlaxston, merchant of the staple 0
3779893 1951440 1951440 defendant Blewett John esq 602197 602197 Blewett, John, of Harlaxston, esq 0
3787741 1953954 1953954 defendant Fletcher Robert husbandman 602197 602197 Fletcher, Robert, of Harlaxston, husbandman 0
3807238 1960160 1960160 defendant Devyas Henry husbandman 602197 602197 Devyas, Henry, of Harlaxston, husbandman 3
3807239 1960160 1960160 defendant Portynton William husbandman 602197 602197 Portynton, William, of Harlaxston, husbandman 4
3868731 1979782 1979782 defendant Walshe William husbandman 602197 602197 Walshe, William, of Harlaxston, husbandman 0
3921075 1997397 1997397 defendant Taylor Thomas chaplain 602197 602197 Taylor, Thomas, of Harlaxston, chaplain 0
4673522 2257349 2257349 plaintiff Dale Thomas   602197 602197 Dale, Thomas, of Harlaxston 0
4847104 2310595 2310595 plaintiff Ricard Thomas   602197 602197 Ricard, Thomas, of Harlaxston 0
4847106 2310596 2310596 plaintiff Ricard Thomas   602197 602197 Ricard, Thomas, of Harlaxston 0
5545972 2518814 2518814 plaintiff Strode William (legal representative) 602197 602197 Strode, William, of Harlaxston, gent, executors of 0
5577541 2528038 2528038 plaintiff Wilkynson Richard   602197 602197 Wilkynson, Richard, of Harlaxston 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);