names

13 rows where place_id = 653459

✎ 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
3928669 1999928 1999928 defendant Bradwey John laborer 653459 653459 Bradwey, John, of Stoke Gregory, laborer 1
4550913 2216222 2216222 defendant Ofcourt John   653459 653459 Ofcourt, John, of Stoke Gregory 0
4550914 2216222 2216222 defendant Stagell William   653459 653459 Stagell, William, of Stoke Gregory 1
4685642 2261101 2261101 defendant Mountagu Agnes widow & formerly wife of John Mountagu 653459 653459 Mountagu, Agnes, of Stoke Gregory, widow & formerly wife of John Mountagu 0
4695801 2264170 2264170 defendant Soper John husbandman 653459 653459 Soper, John, of Stoke Gregory, husbandman 0
4699449 2265285 2265285 defendant Soper Hugh drover 653459 653459 Soper, Hugh, of Stoke Gregory, drover 0
4710714 2268706 2268706 defendant Soper Thomas husbandman 653459 653459 Soper, Thomas, of Stoke Gregory, husbandman 0
4710716 2268706 2268706 defendant Soper John husbandman 653459 653459 Soper, John, of Stoke Gregory, husbandman 2
4844345 2309740 2309740 defendant Benet Thomas husbandman 653459 653459 Benet, Thomas, of Stoke Gregory, husbandman 0
4849656 2311371 2311371 defendant Cradok John husbandman 653459 653459 Cradok, John, of Stoke Gregory, husbandman 0
4849658 2311371 2311371 defendant Curte John husbandman 653459 653459 Curte, John, of Stoke Gregory, husbandman 2
4923888 2333911 2333911 defendant Wydcombe John gent 653459 653459 Wydcombe, John, of Stoke Gregory, gent 0
5011458 2360216 2360216 defendant Cradok Thomas husbandman 653459 653459 Cradok, Thomas, of Stoke Gregory, 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);