names

28 rows where place_id = 597137

✎ 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
3627439 1903438 1903438 defendant Busser William yeoman 597137 597137 Busser, William, of Bromlegh, yeoman 0
3627441 1903438 1903438 defendant Erlyche John husbandman 597137 597137 Erlyche, John, of Bromlegh, husbandman 2
3678328 1919275 1919275 defendant Croucher Henry husbandman 597137 597137 Croucher, Henry, of Bromlegh, husbandman 0
4430942 2174436 2174436 defendant atte Bregge William thatcher 597137 597137 atte Bregge, William, of Bromlegh, thatcher 0
4434038 2175406 2175406 defendant atte Bregge William thatcher 597137 597137 atte Bregge, William, of Bromlegh, thatcher 0
4554545 2217351 2217351 defendant Kere John   597137 597137 Kere, John, of Bromlegh 0
4555709 2217718 2217718 defendant Pot Andrew   597137 597137 Pot, Andrew, of Bromlegh 0
4563552 2220171 2220171 defendant Sudbury Richard   597137 597137 Sudbury, Richard, of Bromlegh, parson 3
4567154 2221287 2221287 plaintiff Taillour Hugh   597137 597137 Taillour, Hugh, of Bromlegh 0
4575451 2223834 2223834 plaintiff Cherche Roger   597137 597137 Cherche, Roger, of Bromlegh, parson 3
4656048 2247774 2247774 defendant Deye John husbandman 597137 597137 Deye, John, of Bromlegh, husbandman 0
4738179 2277040 2277040 defendant Deye John smith 597137 597137 Deye, John, of Bromlegh, smith 0
4802779 2297056 2297056 plaintiff atte Hyde Thomas   597137 597137 atte Hyde, Thomas, of Bromlegh 0
4802780 2297056 2297056 defendant Wygge Walter   597137 597137 Wygge, Walter, of Bromlegh, husbandman, son & heir of John Wygge, of Bromlegh 0
4847266 2310646 2310646 defendant Haukyn John farmer 597137 597137 Haukyn, John, of Bromlegh, farmer 0
4918862 2332412 2332412 defendant Damet Walter   597137 597137 Damet, Walter, of Bromlegh 0
4954168 2343218 2343218 defendant Aleyn John husbandman 597137 597137 Aleyn, John, of Bromlegh, husbandman 0
5116731 2391327 2391327 defendant Wylkyn Roger (legal representative) 597137 597137 Wylkyn, Roger, of Bromlegh, executrix of 0
5116748 2391332 2391332 defendant Rykard Joan widow 597137 597137 Rykard, Joan, of Bromlegh, widow 1
5257844 2432575 2432575 plaintiff Gawayn James tailor 597137 597137 Gawayn, James, of Bromlegh, tailor 0
5392806 2473011 2473011 defendant Whyte Thomas   597137 597137 Whyte, Thomas, of Bromlegh, parish clerk 0
5416532 2479862 2479862 defendant Shotte Simon husbandman 597137 597137 Shotte, Simon, of Bromlegh, husbandman 2
5495953 2503684 2503684 defendant Brysley John collier 597137 597137 Brysley, John, of Bromlegh, collier 1
5511698 2508506 2508506 defendant Bedell Thomas yeoman 597137 597137 Bedell, Thomas, of Bromlegh, yeoman 0
5595050 2533421 2533421 defendant Busser William yeoman 597137 597137 Busser, William, of Bromlegh, yeoman 0
5595052 2533421 2533421 defendant Erlyche John husbandman 597137 597137 Erlyche, John, of Bromlegh, husbandman 2
5637033 2555530 2555530 defendant Kere William husbandman 597137 597137 Kere, William, of Bromlegh, husbandman 0
5637035 2555531 2555531 defendant Kere William husbandman 597137 597137 Kere, William, of Bromlegh, 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);