names

23 rows where place_id = 772645

✎ 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
4591423 2228672 2228672 defendant Grene John   772645 772645 Grene, John, of Allerthorp 2
4732023 2275194 2275194 defendant Boker John husbandman 772645 772645 Boker, John, of Allerthorp, husbandman 3
4749314 2280276 2280276 defendant Baker William husbandman 772645 772645 Baker, William, of Allerthorp, husbandman 1
4760623 2283665 2283665 defendant Batte Thomas husbandman 772645 772645 Batte, Thomas, of Allerthorp, husbandman 1
4829117 2305148 2305148 defendant Hornse Robert husbandman 772645 772645 together with Hornse, Robert, of Allerthorp, husbandman 1
4923065 2333633 2333633 defendant burgh William yeoman 772645 772645 burgh, William, of Allerthorp, yeoman 1
4955786 2343698 2343698 defendant Grayse William yeoman 772645 772645 Grayse, William, of Allerthorp, yeoman 0
4957188 2344108 2344108 defendant Wright William yeoman 772645 772645 Wright, William, of Allerthorp, yeoman 6
5039697 2368516 2368516 defendant Wyndhyll Roger husbandman 772645 772645 Wyndhyll, Roger, of Allerthorp, husbandman 0
5040622 2368804 2368804 defendant Grymston William   772645 772645 Grymston, William, of Allerthorp, franklin 0
5096232 2385336 2385336 defendant Collyng John husbandman 772645 772645 Collyng, John, of Allerthorp, husbandman 0
5129734 2395182 2395182 defendant Bollyng William   772645 772645 Bollyng, William, of Allerthorp 11
5163413 2405030 2405030 defendant Bollyng William yeoman 772645 772645 Bollyng, William, of Allerthorp, yeoman 13
5177296 2409054 2409054 defendant Bollyng William husbandman 772645 772645 Bollyng, William, of Allerthorp, husbandman 0
5177297 2409054 2409054 defendant Bollyng Robert husbandman 772645 772645 Bollyng, Robert, of Allerthorp, husbandman 1
5177298 2409054 2409054 defendant Bollyng John husbandman 772645 772645 Bollyng, John, of Allerthorp, husbandman 2
5201014 2416053 2416053 defendant Bunney Thomas husbandman 772645 772645 Bunney, Thomas, of Allerthorp, husbandman 3
5231886 2424900 2424900 defendant Watson John laborer 772645 772645 Watson, John, of Allerthorp, laborer 0
5271985 2436890 2436890 defendant Jacson Robert husbandman 772645 772645 Jacson, Robert, of Allerthorp, husbandman 0
5271986 2436890 2436890 defendant (illegible) Roger   772645 772645 ---, Roger, of Allerthorp 1
5271987 2436890 2436890 defendant Bollyng Robert husbandman 772645 772645 Bollyng, Robert, of Allerthorp, husbandman 2
5334885 2455502 2455502 defendant Jakson Robert husbandman 772645 772645 Jakson, Robert, of Allerthorp, husbandman 1
5334886 2455502 2455502 defendant Wyndyll Roger husbandman 772645 772645 Wyndyll, Roger, of Allerthorp, husbandman 2

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