names

29 rows where place_id = 666215

✎ 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
3980084 2017639 2017639 defendant Mathern Thomas gent 666215 666215 Mathern, Thomas, of London, of Inner Temple, gent 1
3989209 2020880 2020880 defendant Eveleigh Robert gent 666215 666215 Eveleigh, Robert, of London, of Inner Temple, gent 0
3995785 2023240 2023240 defendant Cope William gent 666215 666215 Cope, William, of London, of Inner Temple, gent 2
4003146 2025885 2025885 defendant Yeo George gent 666215 666215 Yeo, George, of London, of Inner Temple, gent 0
4010918 2028683 2028683 defendant Poyntor Anthony gent 666215 666215 Poyntor, Anthony, of London, of Inner Temple, gent 0
4013685 2029630 2029630 defendant Wright William gent 666215 666215 Wright, William, of London, of Inner Temple, gent 3
4014241 2029822 2029822 defendant Fytton George gent 666215 666215 Fytton, George, of London, of Inner Temple, gent 0
4018658 2031407 2031407 defendant Reynoldes John gent 666215 666215 Reynoldes, John, of London, of Inner Temple, gent 0
4022481 2032763 2032763 defendant Aldersey William chapman 666215 666215 Aldersey, William, of London, of Chester, chapman 2
4025917 2033919 2033919 defendant Strachye William, junior gent 666215 666215 Strachye, William, junior, of London, of Inner Temple, gent 0
4031099 2035793 2035793 defendant Denham George gent 666215 666215 Denham, George, of London, of Inner Temple, gent 0
4038507 2038411 2038411 defendant Moncke Nicholas gent 666215 666215 Moncke, Nicholas, of London, of Inner Temple, gent 2
4038916 2038539 2038539 defendant Cheyney John gent 666215 666215 Cheyney, John, of London, of Inner Temple, gent 0
4054510 2044002 2044002 defendant Lee William gent 666215 666215 Lee, William, of London, of Inner Temple, gent 1
4060191 2046045 2046045 defendant Mydleton Robert gent 666215 666215 Mydleton, Robert, of London, of Inner Temple, gent 1
4060193 2046046 2046046 defendant Myddleton Robert gent 666215 666215 Myddleton, Robert, of London, of Inner Temple, gent 0
4063661 2047294 2047294 defendant Blackwell Robert gent 666215 666215 Blackwell, Robert, of London, of Inner Temple, gent 0
4066810 2048429 2048429 defendant Wilson Simon gent 666215 666215 Wilson, Simon, of London, of Inner Temple, gent 0
4066812 2048430 2048430 defendant Wilson Simon gent 666215 666215 Wilson, Simon, of London, of Inner Temple, gent 0
4078083 2052464 2052464 defendant Medlicotte Richard gent 666215 666215 Medlicotte, Richard, of London, of Inner Temple, gent 0
4096676 2059138 2059138 defendant Taverner Richard gent 666215 666215 Taverner, Richard, of London, of Inner Temple, gent 0
4112246 2064638 2064638 defendant Myllington John mercer 666215 666215 Myllington, John, of London, of or of Tewxbury, Glos, mercer 1
4253169 2114055 2114055 defendant Ingrom William gent 666215 666215 Ingrom, William, of London, of Inner Temple, gent 0
4260316 2116415 2116415 defendant Woodlef Drew gent 666215 666215 Woodlef, Drew, of London, of Inner Temple, gent 0
4304869 2131839 2131839 defendant Grenewood James gent 666215 666215 Grenewood, James, of London, of Inner Temple, gent 2
4305692 2132128 2132128 defendant Ellys Roland gent 666215 666215 Ellys, Roland, of London, of Inner Temple, gent 1
4320937 2137419 2137419 defendant Savage Edward esq 666215 666215 Savage, Edward, of London, of Inner Temple, esq 0
4368703 2153858 2153858 defendant Badger Thomas gent 666215 666215 Badger, Thomas, of London, of Inner Temple, gent 0
4376801 2156774 2156774 defendant Broughton Richard esq 666215 666215 Broughton, Richard, of London, of Inner Temple, esq 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);