names

44 rows where place_id = 763050

✎ 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
4493755 2198742 2198742 plaintiff Beauford Henry   763050 763050 Beauford, Henry, of Lincoln, bishop 0
4495062 2199145 2199145 plaintiff Bukyngham John (legal representative) 763050 763050 Bukyngham, John, of Lincoln, bishop, executors of 0
4510941 2203876 2203876 plaintiff Beauford Henry   763050 763050 Beauford, Henry, of Lincoln, bishop, formerly prebendary of the prebend of the chapel of Buckingham in the parish church of Sutton Auneys 0
4513869 2204759 2204759 plaintiff Bukyngham John de (legal representative) 763050 763050 Bukyngham, John de, of Lincoln, bishop, executors of 0
4547010 2214999 2214999 plaintiff Bukyngham John de (legal representative) 763050 763050 Bukyngham, John de, of Lincoln, bishop, executors of 0
4718284 2271057 2271057 defendant Repyngton Philip   763050 763050 Repyngton, Philip, of Lincoln, bishop 0
4744915 2279027 2279027 plaintiff Fleming Richard   763050 763050 Fleming, Richard, of Lincoln, bishop 0
4807332 2298489 2298489 defendant Fleming Richard   763050 763050 Fleming, Richard, of Lincoln, bishop 0
4810768 2299491 2299491 plaintiff Fleming Richard   763050 763050 Fleming, Richard, of Lincoln, bishop 0
4810770 2299492 2299492 plaintiff Fleming Richard   763050 763050 Fleming, Richard, of Lincoln, bishop 0
4812067 2299887 2299887 defendant Repyngdon Philip   763050 763050 Repyngdon, Philip, of Lincoln, bishop 3
4812076 2299888 2299888 defendant Repyngdon Philip   763050 763050 Repyngdon, Philip, of Lincoln, bishop 3
4907978 2329053 2329053 plaintiff Alnewyck William   763050 763050 Alnewyck, William, of Lincoln, bishop 0
4907979 2329053 2329053 defendant Alnewyck William   763050 763050 Alnewyck, William, of Lincoln, bishop 0
4907980 2329054 2329054 plaintiff Alnewyk William   763050 763050 Alnewyk, William, of Lincoln, bishop 0
4907985 2329055 2329055 plaintiff Alnewyk William   763050 763050 Alnewyk, William, of Lincoln, bishop 0
4907987 2329056 2329056 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop 0
4907988 2329056 2329056 defendant Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop 0
4907989 2329057 2329057 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop 0
4907995 2329060 2329060 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 0
4907996 2329061 2329061 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 0
4908000 2329062 2329062 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 0
4908004 2329063 2329063 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 0
4908006 2329064 2329064 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 0
4908010 2329065 2329065 plaintiff Alnwick William   763050 763050 Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 0
4921785 2333234 2333234 plaintiff Alnwick William   763050 763050 (Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 1
4921798 2333234 2333234 defendant Alnwick William   763050 763050 (Alnwick, William, of Lincoln, bishop, formerly bishop of Norwich 1
5042145 2369260 2369260 defendant Alnewyk or Alnwick William (legal representative) 763050 763050 Alnewyk or Alnwick, William, of Lincoln, bishop, executors of 0
5046012 2370437 2370437 plaintiff Lumley Marmaduke   763050 763050 Lumley, Marmaduke, of Lincoln, bishop 0
5047278 2370808 2370808 defendant Alnwick Thomas   763050 763050 Alnwick, Thomas, of Lincoln, bishop 0
5050700 2371837 2371837 defendant Alnewyk or Alnwick William (legal representative) 763050 763050 Alnewyk or Alnwick, William, of Lincoln, bishop, executors of 0
5124825 2393735 2393735 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, Bishop, executors of 0
5143396 2399208 2399208 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5164655 2405398 2405398 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5178015 2409277 2409277 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5178021 2409278 2409278 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5178030 2409279 2409279 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5178039 2409280 2409280 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5201216 2416115 2416115 plaintiff Alnewyk William (legal representative) 763050 763050 Alnewyk, William, of Lincoln, bishop, executors of 0
5269476 2436172 2436172 plaintiff Chadworth John   763050 763050 Chadworth, John, of Lincoln, bishop 0
5300347 2445061 2445061 plaintiff Chedworth John (legal representative) 763050 763050 Chedworth, John, of Lincoln, bishop, executor of 0
5300350 2445062 2445062 plaintiff Chedworth John (legal representative) 763050 763050 Chedworth, John, of Lincoln, bishop, executors of 0
5376002 2468089 2468089 plaintiff Russell John   763050 763050 Russell, John, of Lincoln, Bishop 0
5405241 2476585 2476585 plaintiff Russell John   763050 763050 Russell, John, of Lincoln, 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);