names

71 rows where place_id = 606625

✎ 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
3665923 1915279 1915279 plaintiff Warham William   606625 606625 Warham, William, of Canterbury, Archbishop 1
3666826 1915567 1915567 plaintiff Warham William   606625 606625 Warham, William, of Canterbury, Archbishop 0
3666833 1915568 1915568 plaintiff Warham William   606625 606625 Warham, William, of Canterbury, Archbishop 0
3666835 1915569 1915569 plaintiff Warham William   606625 606625 Warham, William, of Canterbury, Archbishop 0
4742823 2278408 2278408 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4742825 2278409 2278409 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4742827 2278410 2278410 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806914 2298369 2298369 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806916 2298370 2298370 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806919 2298371 2298371 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806922 2298372 2298372 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806924 2298373 2298373 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806926 2298374 2298374 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806928 2298375 2298375 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806930 2298376 2298376 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806944 2298378 2298378 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806952 2298379 2298379 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806959 2298380 2298380 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806967 2298381 2298381 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806974 2298382 2298382 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4806983 2298383 2298383 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4807067 2298409 2298409 plaintiff Chycheley Henry   606625 606625 Chycheley, Henry, of Canterbury, archbishop 0
4812064 2299887 2299887 defendant Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4812073 2299888 2299888 defendant Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4909861 2329608 2329608 defendant Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913118 2330597 2330597 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913120 2330598 2330598 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913122 2330599 2330599 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913124 2330600 2330600 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913125 2330600 2330600 defendant Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913126 2330601 2330601 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913127 2330601 2330601 defendant Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913128 2330602 2330602 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913130 2330603 2330603 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913133 2330604 2330604 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913136 2330605 2330605 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913138 2330606 2330606 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913141 2330607 2330607 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913143 2330608 2330608 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913145 2330609 2330609 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913148 2330610 2330610 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913153 2330612 2330612 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913157 2330613 2330613 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913161 2330614 2330614 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913166 2330615 2330615 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913169 2330616 2330616 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4913174 2330617 2330617 plaintiff Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4928241 2335260 2335260 defendant Chichele Henry   606625 606625 Chichele, Henry, of Canterbury, archbishop 0
4928246 2335261 2335261 defendant Chichele Henry   606625 606625 with Chichele, Henry, of Canterbury, archbishop 1
4928250 2335262 2335262 defendant Chichele Henry   606625 606625 with Chichele, Henry, of Canterbury, archbishop 1
5041106 2368965 2368965 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041115 2368966 2368966 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041124 2368967 2368967 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041135 2368968 2368968 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041144 2368969 2368969 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041152 2368970 2368970 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041160 2368971 2368971 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041169 2368972 2368972 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041177 2368973 2368973 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041185 2368974 2368974 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041193 2368975 2368975 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041201 2368976 2368976 plaintiff Chichele Henry (legal representative) 606625 606625 Chichele, Henry, of Canterbury, archbishop, executors of 0
5041209 2368977 2368977 plaintiff Chichelee Henry (legal representative) 606625 606625 Chichelee, Henry, of Canterbury, archbishop, executors of 0
5126507 2394229 2394229 plaintiff Bourchier Thomas   606625 606625 Bourchier, Thomas, of Canterbury, archbishop 0
5126512 2394230 2394230 plaintiff Bourchier Thomas   606625 606625 Bourchier, Thomas, of Canterbury, archbishop 0
5268710 2435965 2435965 plaintiff Bourchier Thomas   606625 606625 Bourchier, Thomas, of Canterbury, archbishop 0
5365967 2465014 2465014 plaintiff Bourchier Thomas   606625 606625 Bourchier, Thomas, of Canterbury, Archbishop 0
5396563 2474108 2474108 plaintiff Bouchier Thomas   606625 606625 Bouchier, Thomas, of Canterbury, Archbishop 0
5396579 2474114 2474114 plaintiff Bourchier Thomas   606625 606625 Bourchier, Thomas, of Canterbury, Archbishop 0
5442796 2487759 2487759 plaintiff Bourghchier Thomas   606625 606625 Bourghchier, Thomas, of Canterbury, archbishop 0
5455569 2491575 2491575 plaintiff Bourghchier Thomas   606625 606625 Bourghchier, Thomas, of Canterbury, archbishop 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);