names

22 rows where place_id = 594226

✎ 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
3615165 1872389 1872389 defendant Elyot William husbandman 594226 594226 Elyot, William, of Froxfeld, husbandman 0
3757886 1944447 1944447 plaintiff Boyys Thomas husbandman 594226 594226 Boyys, Thomas, of Froxfeld, husbandman 0
3905602 1992142 1992142 defendant Langryshe Richard clerk 594226 594226 Langryshe, Richard, of Froxfeld, clerk 0
3977627 2016745 2016745 defendant Wekes Richard yeoman 594226 594226 Wekes, Richard, of Froxfeld, yeoman 0
4160846 2081867 2081867 defendant Tanner William husbandman 594226 594226 Tanner, William, of Froxfeld, husbandman 0
4160847 2081867 2081867 defendant Helyere Richard husbandman 594226 594226 Helyere, Richard, of Froxfeld, husbandman 1
4160848 2081867 2081867 defendant Helyere Richard, junior husbandman 594226 594226 Helyere, Richard, junior, of Froxfeld, husbandman 2
4533449 2210730 2210730 defendant atte Mere William   594226 594226 atte Mere, William, of Froxfeld 2
4983701 2352053 2352053 defendant Shawe Thomas yeoman 594226 594226 Shawe, Thomas, of Froxfeld, yeoman 0
5014675 2361158 2361158 defendant Okshete John husbandman 594226 594226 Okshete, John, of Froxfeld, husbandman 0
5038744 2368234 2368234 defendant Pyper Richard carpenter 594226 594226 Pyper, Richard, of Froxfeld, carpenter 1
5120570 2392446 2392446 plaintiff Staveley Richard gent 594226 594226 Staveley, Richard, of Froxfeld, gent 0
5132197 2395909 2395909 defendant Hayward Richard husbandman 594226 594226 Hayward, Richard, of Froxfeld, husbandman 0
5151760 2401675 2401675 defendant Hayward Richard husbandman 594226 594226 Hayward, Richard, of Froxfeld, husbandman 0
5151764 2401676 2401676 defendant Hayward Richard husbandman 594226 594226 Hayward, Richard, of Froxfeld, husbandman 0
5169835 2406920 2406920 defendant Hayward Richard husbandman 594226 594226 Hayward, Richard, of Froxfeld, husbandman 0
5313421 2449047 2449047 defendant Spaynell John husbandman 594226 594226 Spaynell, John, of Froxfeld, husbandman 3
5360760 2463398 2463398 defendant Elyot William husbandman 594226 594226 Elyot, William, of Froxfeld, husbandman 0
5438245 2486372 2486372 defendant Elyot William husbandman 594226 594226 Elyot, William, of Froxfeld, husbandman 3
5493373 2502935 2502935 defendant Butte John husbandman 594226 594226 Butte, John, of Froxfeld, husbandman 0
5532029 2514560 2514560 defendant Brygger Richard miller 594226 594226 Brygger, Richard, of Froxfeld, miller 2
5532038 2514562 2514562 defendant Stoner Thomas husbandman 594226 594226 Stoner, Thomas, of Froxfeld, husbandman 3

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