names

30 rows where place_id = 591442

✎ 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
3604438 1869056 1869056 defendant Best John miller 591442 591442 Best, John, of Brakley, miller 0
3612237 1871463 1871463 defendant Swillyngton Richard gent 591442 591442 Swillyngton, Richard, of Brakley, gent 0
3801648 1958414 1958414 defendant Walker Richard yeoman 591442 591442 Walker, Richard, of Brakley, yeoman 0
3813822 1962236 1962236 defendant Benett Thomas mercer 591442 591442 Benett, Thomas, of Brakley, mercer 1
3835206 1968949 1968949 defendant Plome Matthew butcher 591442 591442 Plome, Matthew, of Brakley, butcher 3
4536914 2211814 2211814 defendant bocher Thomas   591442 591442 bocher, Thomas, of Brakley 3
4548101 2215346 2215346 defendant Dyer Roger   591442 591442 Dyer, Roger, of Brakley 0
4559172 2218821 2218821 defendant Baker Adam   591442 591442 Baker, Adam, of Brakley 0
4606394 2233117 2233117 defendant Glover John   591442 591442 Glover, John, of Brakley 2
4626008 2239092 2239092 plaintiff Plomere Robert   591442 591442 Plomere, Robert, of Brakley 0
4626020 2239096 2239096 defendant Chapman John   591442 591442 Chapman, John, of Brakley 0
4637642 2242558 2242558 plaintiff Brokehampton John master of the hospital of Sts James & John 591442 591442 Brokehampton, John, of Brakley, master of the hospital of Sts James & John 0
4641956 2243752 2243752 defendant Waldyene Elizabeth   591442 591442 Waldyene, Elizabeth, of Brakley 0
4691242 2262780 2262780 defendant Patrik John draper 591442 591442 Patrik, John, of Brakley, draper 0
4739688 2277488 2277488 defendant Dyer John dyer 591442 591442 Dyer, John, of Brakley, dyer 0
4773393 2287653 2287653 defendant Dorne Thomas yeoman 591442 591442 Dorne, Thomas, of Brakley, yeoman 0
4798720 2295778 2295778 defendant Dorne Thomas yeoman 591442 591442 Dorne, Thomas, of Brakley, yeoman 0
4851852 2312014 2312014 plaintiff Wale Robert   591442 591442 Wale, Robert, of Brakley 0
5023331 2363731 2363731 defendant Craft John husbandman 591442 591442 Craft, John, of Brakley, husbandman 0
5023332 2363731 2363731 defendant Stoke John husbandman 591442 591442 Stoke, John, of Brakley, husbandman 1
5023333 2363731 2363731 defendant Brydde John husbandman 591442 591442 Brydde, John, of Brakley, husbandman 2
5070235 2377588 2377588 defendant Wale Robert gent 591442 591442 Wale, Robert, of Brakley, gent 0
5079299 2380304 2380304 defendant Beste Thomas baker 591442 591442 Beste, Thomas, of Brakley, baker 0
5079300 2380304 2380304 defendant Raven Thomas chapman 591442 591442 Raven, Thomas, of Brakley, chapman 1
5093796 2384585 2384585 plaintiff Raven Thomas   591442 591442 Raven, Thomas, of Brakley 0
5118909 2391961 2391961 defendant Best Thomas baker 591442 591442 Best, Thomas, of Brakley, baker 0
5506104 2506828 2506828 defendant Shuflard Thomas yeoman 591442 591442 Shuflard, Thomas, of Brakley, yeoman 1
5518112 2510498 2510498 defendant Showelard Thomas yeoman 591442 591442 Showelard, Thomas, of Brakley, yeoman 0
5573399 2526777 2526777 defendant Yale David clerk 591442 591442 Yale, David, of Brakley, clerk 0
5578015 2528193 2528193 defendant Grey Richard husbandman 591442 591442 Grey, Richard, of Brakley, husbandman 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);