names

15 rows where place_id = 760602

✎ 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
4471566 2191768 2191768 defendant Wymbulmore Thomas   760602 760602 Wymbulmore, Thomas, of Fordyngbrugge 0
4555447 2217640 2217640 defendant Olde Walter   760602 760602 Olde, Walter, of Fordyngbrugge 0
4555448 2217640 2217640 defendant Chapelleyn Thomas   760602 760602 Chapelleyn, Thomas, of Fordyngbrugge 1
4555450 2217640 2217640 defendant Forest John   760602 760602 Forest, John, of Fordyngbrugge 3
4559396 2218887 2218887 defendant Carpenter John   760602 760602 Carpenter, John, of Fordyngbrugge 0
4567053 2221251 2221251 defendant Reve Henry   760602 760602 Reve, Henry, of Fordyngbrugge 2
4613916 2235366 2235366 defendant Chapman John   760602 760602 Chapman, John, of Fordyngbrugge 2
4651979 2246553 2246553 defendant Grey William husbandman 760602 760602 Grey, William, of Fordyngbrugge, husbandman 3
4651984 2246554 2246554 defendant Grey William husbandman 760602 760602 Grey, William, of Fordyngbrugge, husbandman 3
4796072 2294925 2294925 defendant Goolde Joan widow 760602 760602 Goolde, Joan, of Fordyngbrugge, widow 0
4818382 2301829 2301829 defendant Couper John hoper or hoop maker 760602 760602 Couper, John, of Fordyngbrugge, hoper or hoop maker 1
4818383 2301829 2301829 defendant Couper Edward   760602 760602 Couper, Edward, of Fordyngbrugge, holy water clerk 2
4978473 2350508 2350508 defendant Strode William clerk 760602 760602 Strode, William, of Fordyngbrugge, clerk 0
5452181 2490528 2490528 defendant Forster John smith 760602 760602 Forster, John, of Fordyngbrugge, smith 1
5452182 2490528 2490528 defendant Hurst (illegible) husbandman 760602 760602 Hurst, _, of Fordyngbrugge, 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);