names

39 rows where place_id = 668308

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3967231 2013169 2013169 plaintiff Bulbeck John, junior gent 668308 668308 Bulbeck, John, junior, of Middle Temple, or of Somerset, gent 0
3988567 2020656 2020656 plaintiff Lewkenor Richard gent 668308 668308 Lewkenor, Richard, of Middle Temple, gent 1
3999512 2024591 2024591 plaintiff Fytche John gent 668308 668308 Fytche, John, of Middle Temple, gent 0
4015335 2030178 2030178 plaintiff Smyth Mathew esq 668308 668308 Smyth, Mathew, of Middle Temple, esq 0
4017313 2030898 2030898 defendant Lucas John gent 668308 668308 Lucas, John, of Middle Temple, gent 1
4027025 2034313 2034313 plaintiff Chabnour Robert gent 668308 668308 Chabnour, Robert, of Middle Temple, gent 0
4034548 2037030 2037030 plaintiff Harryson Thomas gent 668308 668308 Harryson, Thomas, of Middle Temple, gent 0
4041081 2039302 2039302 plaintiff Mundy Edward gent 668308 668308 Mundy, Edward, of Middle Temple, gent 0
4046555 2041219 2041219 plaintiff Smyth John gent 668308 668308 Smyth, John, of Middle Temple, gent 0
4046575 2041228 2041228 plaintiff Smyth Mathew esq 668308 668308 Smyth, Mathew, of Middle Temple, esq 0
4046577 2041229 2041229 plaintiff Smyth Mathew esq 668308 668308 Smyth, Mathew, of Middle Temple, esq 0
4058531 2045440 2045440 defendant Walkeden Thomas gent 668308 668308 Walkeden, Thomas, of Middle Temple, gent 3
4077740 2052332 2052332 defendant Breauster John Chirographer of the Court 668308 668308 Breauster, John, of Middle Temple, gent, clerk of Thomas Gardner, Chirographer of the Court 0
4079938 2053127 2053127 plaintiff Vavasor Andrew (legal representative) 668308 668308 Vavasor, Andrew, of Middle Temple, gent, administrator of 0
4079957 2053135 2053135 plaintiff Vavasour Peter (legal representative) 668308 668308 Vavasour, Peter, of Middle Temple, esq, executor of 0
4115246 2065745 2065745 plaintiff Vavasor Andrew (legal representative) 668308 668308 Vavasor, Andrew, of Middle Temple, gent, administrator of 0
4127983 2070299 2070299 defendant Raynell Thomas gent 668308 668308 Raynell, Thomas, of Middle Temple, gent 0
4127984 2070299 2070299 defendant Raynell Josiah gent 668308 668308 Raynell, Josiah, of Middle Temple, gent 1
4130206 2071112 2071112 defendant Eveleigh George gent 668308 668308 Eveleigh, George, of Middle Temple, gent 0
4132428 2071914 2071914 defendant Lanard John (legal representative) 668308 668308 Lanard, John, of Middle Temple, gent, executor of 2
4152740 2079068 2079068 defendant Rowsewell William gent 668308 668308 Rowsewell, William, of Middle Temple, gent 0
4183779 2089816 2089816 defendant Harris Thomas esq 668308 668308 Harris, Thomas, of Middle Temple, esq 1
4192436 2092911 2092911 defendant Love John gent 668308 668308 Love, John, of Middle Temple, gent 0
4202237 2096323 2096323 defendant Rogers John gent 668308 668308 Rogers, John, of Middle Temple, or of Tolpuddell, gent 0
4202350 2096365 2096365 defendant Hubberd William (legal representative) 668308 668308 Hubberd, William, of Middle Temple, gent, administratrix of 0
4205374 2097430 2097430 defendant Scarre Robert (legal representative) 668308 668308 Scarre, Robert, of Middle Temple, gent, administrator of 0
4211246 2099484 2099484 defendant Tubbe Thomas gent 668308 668308 Tubbe, Thomas, of Middle Temple, gent 1
4212680 2099974 2099974 defendant Harris Thomas esq 668308 668308 Harris, Thomas, of Middle Temple, esq 0
4226679 2104803 2104803 defendant Eveleghe George gent 668308 668308 Eveleghe, George, of Middle Temple, gent 0
4251421 2113455 2113455 defendant Cole Philip gent 668308 668308 Cole, Philip, of Middle Temple, gent 3
4254370 2114456 2114456 defendant Dyer James (legal representative) 668308 668308 Dyer, James, of Middle Temple, esq, administratrix of 0
4259584 2116182 2116182 defendant Sayer Richard gent 668308 668308 Sayer, Richard, of Middle Temple, gent 0
4281514 2123436 2123436 defendant Gosnoll William gent 668308 668308 Gosnoll, William, of Middle Temple, gent 1
4292037 2127225 2127225 defendant Medley Henry (legal representative) 668308 668308 Medley, Henry, of Middle Temple, gent, administrator of 0
4298303 2129494 2129494 defendant Tatnall Henry gent 668308 668308 Tatnall, Henry, of Middle Temple, gent 0
4305409 2132034 2132034 defendant Thimble John gent 668308 668308 Thimble, John, of Middle Temple, gent 1
4306222 2132314 2132314 defendant Elmer John gent 668308 668308 Elmer, John, of Middle Temple, gent 0
4360513 2150927 2150927 defendant Burde William gent 668308 668308 Burde, William, of Middle Temple, gent Symons, Robert, of Staple Inn, gent 1
4399905 2164556 2164556 defendant Borrage John gent 668308 668308 Borrage, John, of Middle Temple, gent 1

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