names

17 rows where place_id = 618645

✎ 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
3725708 1934328 1934328 defendant Alen Thomas husbandman 618645 618645 Alen, Thomas, of Harmeston, husbandman 0
3959550 2010431 2010431 defendant Thorpe Richard husbandman 618645 618645 Thorpe, Richard, of Harmeston, husbandman 2
4496477 2199573 2199573 defendant Bochere William   618645 618645 Bochere, William, of Harmeston 0
4524315 2207941 2207941 defendant Blake John   618645 618645 Blake, John, of Harmeston 0
4575904 2223952 2223952 defendant Walker William   618645 618645 Walker, William, of Harmeston 0
4575905 2223952 2223952 defendant Bther William   618645 618645 Bther, William, of Harmeston 1
4576433 2224141 2224141 defendant Loveday John   618645 618645 Loveday, John, of Harmeston 1
4588362 2227751 2227751 defendant Grype John   618645 618645 Grype, John, of Harmeston 1
4683493 2260438 2260438 defendant Blake John gent 618645 618645 Blake, John, of Harmeston, gent 0
4981443 2351366 2351366 defendant Chaumberleyn William husbandman 618645 618645 Chaumberleyn, William, of Harmeston, husbandman 1
4981444 2351366 2351366 defendant Cape Roger husbandman 618645 618645 Cape, Roger, of Harmeston, husbandman 2
4981445 2351366 2351366 defendant Stanley John husbandman 618645 618645 Stanley, John, of Harmeston, husbandman 3
5000815 2357114 2357114 defendant Staunford Robert chaplain 618645 618645 Staunford, Robert, of Harmeston, chaplain 0
5007977 2359223 2359223 defendant Cap Roger husbandman 618645 618645 Cap, Roger, of Harmeston, husbandman 1
5007978 2359223 2359223 defendant Stanley John husbandman 618645 618645 Stanley, John, of Harmeston, husbandman 2
5007979 2359223 2359223 defendant Gold William husbandman 618645 618645 Gold, William, of Harmeston, husbandman 3
5036728 2367613 2367613 defendant Lylly John husbandman 618645 618645 Lylly, John, of Harmeston, husbandman 1

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);