names

13 rows where place_id = 622301

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3746278 1940745 1940745 defendant Lyn Robert mercer 622301 622301 Lyn, Robert, of Bykleswade, Beds, mercer 2
3748982 1941613 1941613 defendant Spencer Michael baker 622301 622301 Spencer, Michael, of Bykleswade, Beds, baker 0
3832914 1968219 1968219 defendant Damporte Thomas maltman 622301 622301 Damporte, Thomas, of Bykleswade, Beds, maltman 1
4827283 2304582 2304582 defendant Derlyng William chapman 622301 622301 Derlyng, William, of Bykleswade, Beds, chapman 1
4827291 2304583 2304583 defendant Derlynge William chapman 622301 622301 Derlynge, William, of Bykleswade, Beds, chapman 1
5123487 2393321 2393321 defendant Upton Robert smith 622301 622301 Upton, Robert, of Bykleswade, Beds, smith 1
5124017 2393479 2393479 defendant Upton Robert smith 622301 622301 Upton, Robert, of Bykleswade, Beds, smith 1
5392443 2472917 2472917 defendant Skaryngton Henry draper 622301 622301 Skaryngton, Henry, of Bykleswade, Beds, draper 0
5405493 2476652 2476652 defendant Skaryngton Henry brasier 622301 622301 Skaryngton, Henry, of Bykleswade, Beds, brasier 0
5418560 2480478 2480478 defendant Scaryngton Henry brasier 622301 622301 Scaryngton, Henry, of Bykleswade, Beds, brasier 0
5418563 2480479 2480479 defendant Skaryngton Henry brasier or brass worker 622301 622301 Skaryngton, Henry, of Bykleswade, Beds, brasier or brass worker 0
5439512 2486753 2486753 defendant Colworthe Thomas gent 622301 622301 Colworthe, Thomas, of Bykleswade, Beds, gent 1
5439518 2486754 2486754 defendant Colmorthe Thomas gent 622301 622301 Colmorthe, Thomas, of Bykleswade, Beds, gent 1

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