names

44 rows where place_id = 604999

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3660021 1913398 1913398 defendant Foxe Richard   604999 604999 Foxe, Richard, of Winchester, bishop 0
4422266 2171834 2171834 plaintiff Edyngdon William de   604999 604999 Edyngdon, William de, of Winchester, bishop 0
4465677 2189942 2189942 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465680 2189943 2189943 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465682 2189944 2189944 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465686 2189945 2189945 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465690 2189946 2189946 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465693 2189947 2189947 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465703 2189948 2189948 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4465712 2189949 2189949 plaintiff Wykeham William of   604999 604999 Wykeham, William of, of Winchester, bishop 0
4492025 2198193 2198193 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4492027 2198194 2198194 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4492031 2198195 2198195 plaintiff Wykeham William   604999 604999 Wykeham, William, of Winchester, bishop 0
4507933 2202946 2202946 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4541725 2213305 2213305 plaintiff Wykeham William de   604999 604999 Wykeham, William de, of Winchester, bishop 0
4668493 2255853 2255853 plaintiff Beauford or Beaufort Henry   604999 604999 Beauford or Beaufort, Henry, of Winchester, bishop 0
4668497 2255854 2255854 plaintiff Beauford Henry   604999 604999 Beauford, Henry, of Winchester, bishop 0
4668501 2255855 2255855 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4740747 2277813 2277813 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4740752 2277814 2277814 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4740754 2277815 2277815 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4740760 2277816 2277816 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4740762 2277817 2277817 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803756 2297358 2297358 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803760 2297359 2297359 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803763 2297360 2297360 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803766 2297361 2297361 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803768 2297362 2297362 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803770 2297363 2297363 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803772 2297364 2297364 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 0
4803779 2297365 2297365 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop, on his own account 0
4806945 2298378 2298378 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4806953 2298379 2298379 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4806960 2298380 2298380 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4806968 2298381 2298381 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4806975 2298382 2298382 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4812065 2299887 2299887 defendant Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4812074 2299888 2299888 defendant Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4827323 2304593 2304593 plaintiff Wykeham William (legal representative) 604999 604999 Wykeham, William, of Winchester, bishop, executor of 0
4913154 2330612 2330612 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4913158 2330613 2330613 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
4913162 2330614 2330614 plaintiff Beaufort Henry   604999 604999 Beaufort, Henry, of Winchester, bishop 1
5274046 2437487 2437487 defendant Waynflete William   604999 604999 Waynflete, William, of Winchester, bishop 0
5407515 2477221 2477221 plaintiff Waynflete William   604999 604999 Waynflete, William, of Winchester, bishop 0

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