names

20 rows where place_id = 669473

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3993335 2022356 2022356 plaintiff Catheryns Humphrey gent 669473 669473 Catheryns, Humphrey, of New Inn, Middx, gent 0
4010105 2028381 2028381 plaintiff Orames Thomas gent 669473 669473 Orames, Thomas, of New Inn, Middx, gent 0
4017621 2031011 2031011 defendant Gage Robert gent 669473 669473 Gage, Robert, of New Inn, Middx, gent 1
4020503 2032057 2032057 plaintiff Willowes Robert gent 669473 669473 Willowes, Robert, of New Inn, Middx, gent 0
4020919 2032209 2032209 defendant Gyllett Thomas gent 669473 669473 Gyllett, Thomas, of New Inn, Middx, gent 1
4022808 2032881 2032881 plaintiff Aylesbury William   669473 669473 Aylesbury, William, of New Inn, Middx, gent, clerk of Robert Fylmer, Prothonotary of the Court 0
4047671 2041615 2041615 plaintiff Stone Thomas gent 669473 669473 Stone, Thomas, of New Inn, Middx, gent 0
4059067 2045639 2045639 defendant Brewne or Browne Thomas gent 669473 669473 Brewne or Browne, Thomas, of New Inn, Middx, gent 1
4104228 2061788 2061788 defendant Godwyn Michael gent 669473 669473 Godwyn, Michael, of New Inn, Middx, or of Corscombe, gent 0
4107152 2062852 2062852 defendant Marke Peter gent 669473 669473 Marke, Peter, of New Inn, Middx, gent 0
4129447 2070834 2070834 defendant Davies Mathew gent 669473 669473 Davies, Mathew, of New Inn, Middx, gent 4
4144268 2076155 2076155 defendant Gwyn John gent 669473 669473 Gwyn, John, of New Inn, Middx, gent 0
4227933 2105253 2105253 defendant Posterne Francis gent 669473 669473 Posterne, Francis, of New Inn, Middx, gent 0
4259540 2116167 2116167 defendant Hill Edward gent 669473 669473 Hill, Edward, of New Inn, Middx, gent 1
4278257 2122333 2122333 defendant Valett William gent 669473 669473 Valett, William, of New Inn, Middx, gent 0
4305645 2132109 2132109 defendant Jeeve James gent 669473 669473 Jeeve, James, of New Inn, Middx, attorney, gent 0
4318236 2136485 2136485 defendant Collyns Thomas gent 669473 669473 Collyns, Thomas, of New Inn, Middx, gent 0
4324291 2138524 2138524 defendant Blinco George gent 669473 669473 Blinco, George, of New Inn, Middx, gent 0
4348722 2146813 2146813 defendant Balthasar Leveus gent 669473 669473 Balthasar, Leveus, of New Inn, Middx, gent 1
4396858 2163519 2163519 defendant Smyth Richard gent 669473 669473 Smyth, Richard, of New Inn, Middx, 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);