names

26 rows where place_id = 595808

✎ 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
3621998 1874422 1874422 defendant Wyngilfeld John   595808 595808 Wyngilfeld, John, of Letheryngham, Suff, knight 0
3646706 1909372 1909372 defendant Wyngfeld Anthony   595808 595808 Wyngfeld, Anthony, of Letheryngham, Suff, knight, sheriff of Norf 1
3665258 1915087 1915087 defendant Wyngfeld Anthony   595808 595808 Wyngfeld, Anthony, of letheryngham, suff, knight 0
3669960 1916548 1916548 defendant Wyngfeld Anthony   595808 595808 Wyngfeld, Anthony, of Letheryngham, Suff, knight 0
3855398 1975330 1975330 defendant Wyngfeld Anthony   595808 595808 Wyngfeld, Anthony, of Letheryngham, Suff, knight 1
3855402 1975331 1975331 defendant Wyngfeld Anthony   595808 595808 Wyngfeld, Anthony, of Letheryngham, Suff, knight 1
3855421 1975336 1975336 defendant Wyngfeld Anthony   595808 595808 Wyngfeld, Anthony, of Letheryngham, Suff, knight 0
3891619 1987451 1987451 defendant Wyngfeld John esq 595808 595808 Wyngfeld, John, of Letheryngham, Suff, esq 0
3950501 2007253 2007253 defendant Wyngfield Robert   595808 595808 Wyngfield, Robert, of Letheryngham, Suff, knight, son of Anthony Wyngfield, Knight of the Garter 0
3973731 2015386 2015386 defendant Wyngfeld Robert   595808 595808 Wyngfeld, Robert, of Letheryngham, Suff, knight, son of Anthony Wyngfeld, of Letheryngham, Suff, Knight of the Garter 0
3987414 2020246 2020246 defendant Wyngfeld Robert   595808 595808 Wyngfeld, Robert, of Letheryngham, Suff, knight 0
5043089 2369550 2369550 defendant Wyngefeld Robert   595808 595808 Wyngefeld, Robert, of Letheryngham, Suff, knight 0
5048373 2371152 2371152 defendant Wynkefeld Robert   595808 595808 Wynkefeld, Robert, of Letheryngham, Suff, knight 0
5049134 2371375 2371375 defendant Wyngefeld Robert   595808 595808 Wyngefeld, Robert, of Letheryngham, Suff, knight 0
5085005 2382027 2382027 defendant Wyngefeld Robert   595808 595808 Wyngefeld, Robert, of Letheryngham, Suff, knight, executorsof 0
5086611 2382476 2382476 defendant Wyngefeld Robert (legal representative) 595808 595808 Wyngefeld, Robert, of Letheryngham, Suff, knight, executors of 0
5086617 2382477 2382477 defendant Wyngefeld Robert   595808 595808 Wyngefeld, Robert, of Letheryngham, Suff, knight, executorsof 0
5369569 2466070 2466070 defendant Wyngfeld John esq & sheriff of Norfolk 595808 595808 Wyngfeld, John, of Letheryngham, Suff, esq & sheriff of Norfolk 0
5375540 2467939 2467939 defendant Wyngfeld John esq 595808 595808 Wyngfeld, John, of Letheryngham, Suff, esq 0
5375547 2467941 2467941 defendant Wyngfeld John esq & sheriff of Norfolk 595808 595808 Wyngfeld, John, of Letheryngham, Suff, esq & sheriff of Norfolk 0
5501481 2505398 2505398 defendant Wyngfeld John   595808 595808 Wyngfeld, John, of Letheryngham, Suff, knight 0
5509907 2507938 2507938 defendant Wyngfeld Edward   595808 595808 Wyngfeld, Edward, of Letheryngham, Suff, knight 0
5509909 2507939 2507939 defendant Wyngfeld Edward   595808 595808 Wyngfeld, Edward, of Letheryngham, Suff, knight 0
5583823 2530018 2530018 defendant Echyngham John esq 595808 595808 Echyngham, John, of Letheryngham, Suff, esq 0
5595144 2533450 2533450 defendant Willughby Margaret widow 595808 595808 Willughby, Margaret, of Letheryngham, Suff, widow 0
5601200 2535264 2535264 defendant Wyngfeld Anthony esq 595808 595808 Wyngfeld, Anthony, of Letheryngham, Suff, esq 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);