names

25 rows where place_id = 589876

✎ 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
3599092 1867352 1867352 defendant Howchon Peter yeoman 589876 589876 Howchon, Peter, of Branton, yeoman 0
3666466 1915462 1915462 defendant Herybold John yeoman 589876 589876 Herybold, John, of Branton, yeoman 6
3861492 1977305 1977305 defendant Alyn Simon husbandman 589876 589876 Alyn, Simon, of Branton, husbandman 0
4391170 2161664 2161664 defendant Clarke Roland husbandman 589876 589876 Clarke, Roland, of Branton, husbandman 0
4391171 2161664 2161664 defendant Clarke Robert husbandman 589876 589876 Clarke, Robert, of Branton, husbandman 1
4403125 2165621 2165621 defendant Wright Lancelot husbandman 589876 589876 Wright, Lancelot, of Branton, husbandman 0
4483871 2195652 2195652 defendant Boukyn Thomas   589876 589876 Boukyn, Thomas, of Branton 1
4807256 2298470 2298470 defendant Furslond William husbandman 589876 589876 Furslond, William, of Branton, husbandman 0
4919948 2332750 2332750 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
4971453 2348389 2348389 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
4988698 2353576 2353576 defendant Hawell William yeoman 589876 589876 Hawell, William, of Branton, yeoman 4
4988699 2353576 2353576 defendant Shotton William yeoman 589876 589876 Shotton, William, of Branton, yeoman 5
4997837 2356212 2356212 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
4997845 2356215 2356215 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
4997957 2356250 2356250 plaintiff Huchons Robert   589876 589876 Huchons, Robert, of Branton 0
5044828 2370089 2370089 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
5087264 2382655 2382655 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
5112055 2389912 2389912 plaintiff Branton Robert   589876 589876 Branton, Robert, of Branton 1
5507011 2507107 2507107 defendant Veseke Henry husbandman 589876 589876 Veseke, Henry, of Branton, husbandman 1
5567455 2525052 2525052 defendant Lowe John yeoman 589876 589876 Lowe, John, of Branton, yeoman 15
5567456 2525052 2525052 defendant Wyllowesey Gilbert yeoman 589876 589876 Wyllowesey, Gilbert, of Branton, yeoman 16
5592257 2532569 2532569 defendant Flek John husbandman 589876 589876 Flek, John, of Branton, husbandman 14
5592258 2532569 2532569 defendant Robynson Alexander husbandman 589876 589876 Robynson, Alexander, of Branton, husbandman 15
5592273 2532570 2532570 defendant Flek John husbandman 589876 589876 Flek, John, of branton, husbandman 13
5592274 2532570 2532570 defendant Robynson Alexander husbandman 589876 589876 Robynson, Alexander, of Branton, husbandman 14

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