names

32 rows where place_id = 613930

✎ 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
3701006 1926562 1926562 defendant Lucton Thomas gent 613930 613930 Lucton, Thomas, of Clements Inn, Middx, gent 8
3945101 2005381 2005381 plaintiff Blakeham William gent 613930 613930 Blakeham, William, of Clements Inn, Middx, gent 0
3975230 2015903 2015903 plaintiff Horwood Richard gent 613930 613930 Horwood, Richard, of Clements Inn, Middx, gent 0
3976346 2016301 2016301 defendant Stephenson Leonard gent 613930 613930 Stephenson, Leonard, of Clements Inn, Middx, gent 0
3988870 2020765 2020765 defendant Clarke Thomas gent 613930 613930 Clarke, Thomas, of Clements Inn, Middx, gent 1
3996453 2023489 2023489 plaintiff Davys Robert   613930 613930 Davys, Robert, of Clements Inn, Middx, gent, attorney of the Bench 0
4000682 2025017 2025017 defendant Lloyde Griffin gent 613930 613930 Lloyde, Griffin, of Clements inn, Middx, gent 1
4007282 2027385 2027385 defendant Harwoode John gent 613930 613930 Harwoode, John, of Clements Inn, Middx, gent 0
4009538 2028178 2028178 defendant Harewode John gent 613930 613930 Harewode, John, of Clements Inn, Middx, gent 0
4016958 2030766 2030766 defendant Harewood John gent 613930 613930 Harewood, John, of Clements Inn, Middx, gent 1
4025482 2033774 2033774 defendant Rowley William gent 613930 613930 Rowley, William, of Clements Inn, Middx, gent 0
4025493 2033776 2033776 defendant Rawley William gent 613930 613930 Rawley, William, of Clements Inn, Middx, gent 0
4027611 2034523 2034523 defendant Francklinge William gent 613930 613930 Francklinge, William, of Clements Inn, Middx, gent 1
4035397 2037334 2037334 defendant Heynes Richard gent 613930 613930 Heynes, Richard, of Clements Inn, Middx, gent 0
4040538 2039110 2039110 plaintiff Modlicott Richard, junior   613930 613930 Modlicott, Richard, junior, of Clements Inn, Middx, gent, clerk of Richard Love, Prothonotary of the Bench 0
4040742 2039183 2039183 plaintiff More William gent 613930 613930 More, William, of Clements Inn, Middx, gent 0
4040744 2039184 2039184 plaintiff More William gent 613930 613930 More, William, of Clements Inn, Middx, gent 0
4071184 2049997 2049997 plaintiff Morehouse William gent 613930 613930 Morehouse, William, of Clements Inn, Middx, gent 0
4071186 2049998 2049998 plaintiff Morehouse William gent 613930 613930 Morehouse, William, of Clements Inn, Middx, gent 0
4071188 2049999 2049999 plaintiff Morehouse William gent 613930 613930 Morehouse, William, of Clements Inn, Middx, gent 0
4071190 2050000 2050000 plaintiff Morehouse William gent 613930 613930 Morehouse, William, of Clements Inn, Middx, gent 0
4073289 2050737 2050737 plaintiff Phellyps William gent 613930 613930 Phellyps, William, of Clements Inn, Middx, gent 0
4110353 2063963 2063963 defendant Paton Mercury gent 613930 613930 Paton, Mercury, of Clements Inn, Middx, gent 0
4142898 2075691 2075691 defendant Midlemore George gent 613930 613930 Midlemore, George, of Clements Inn, Middx, gent 2
4142903 2075692 2075692 defendant Mydlemore George gent 613930 613930 Mydlemore, George, of Clements Inn, Middx, gent 2
4149832 2078068 2078068 defendant Hopton Thomas gent 613930 613930 Hopton, Thomas, of Clements Inn, Middx, gent 2
4177304 2087534 2087534 defendant Bawldwyn William gent 613930 613930 Bawldwyn, William, of Clements Inn, Middx, gent 1
4220522 2102681 2102681 defendant Anderson John gent 613930 613930 Anderson, John, of Clements Inn, Middx, gent 0
4280064 2122937 2122937 defendant Osborne Thomas gent 613930 613930 Osborne, Thomas, of Clements Inn, Middx, gent 2
4324587 2138614 2138614 defendant Eyre Thomas gent 613930 613930 Eyre, Thomas, of Clements Inn, Middx, gent 0
4338425 2143190 2143190 defendant Lye Richard gent 613930 613930 Lye, Richard, of Clements Inn, Middx, gent 0
4406710 2166812 2166812 defendant Harryson Robert gent 613930 613930 Harryson, Robert, of Clements Inn, Middx, gent 3

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