names

16 rows where case_id = 1864193

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588938 1864193 1864193 plaintiff Brampton Thomas     Brampton, Thomas 0
3588939 1864193 1864193 defendant Buschop Edmund husbandman 586516 586516 Buschop, Edmund, of Marsham, husbandman 0
3588940 1864193 1864193 defendant Ocley John yeoman 586517 586517 Ocley, John, of Hyngham, yeoman 1
3588941 1864193 1864193 defendant Feld Thomas husbandman 586517 586517 Feld, Thomas, of Hyngham, husbandman 2
3588942 1864193 1864193 defendant Waliche John husbandman 586518 586518 Waliche, John, of Coutyshale, husbandman 3
3588943 1864193 1864193 defendant Crymbyll George yeoman 586519 586519 Crymbyll, George, of Blyklyng, yeoman 4
3588944 1864193 1864193 defendant Miller William husbandman 586520 586520 Miller, William, of Stafford Bernyngham, husbandman 5
3588945 1864193 1864193 defendant Bungge John husbandman 586521 586521 Bungge, John, of Lammes, husbandman 6
3588946 1864193 1864193 defendant Drawele Robert husbandman 586522 586522 Drawele, Robert, of Horsey, husbandman 7
3588947 1864193 1864193 defendant Pallyng Robert husbandman 586523 586523 Pallyng, Robert, of Cley juxta Mare, husbandman 8
3588948 1864193 1864193 defendant Rokysby Osbert yeoman 586524 586524 Rokysby, Osbert, of Swanton Morley, yeoman 9
3588949 1864193 1864193 defendant Bange John yeoman 586525 586525 Bange, John, of North Tudengham, yeoman 10
3588950 1864193 1864193 defendant Edmundis William husbandman 586471 586471 Edmundis, William, of Aylesham, husbandman 11
3588951 1864193 1864193 defendant Pynnyng Simon husbandman 586471 586471 Pynnyng, Simon, of Aylesham, husbandman 12
3588952 1864193 1864193 defendant Stanmowe John (legal representative) 586527 586527 Stanmowe, John, of Bedyngham, yeoman, executor of 13
3588953 1864193 1864193 defendant Stanmow John yeoman 586527 586527 Stanmow, John, of Bedyngham, yeoman 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);