names

21 rows where place_id = 753950

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4417036 2170201 2170201 defendant David John   753950 753950 David, John, of Holm 0
4505344 2202201 2202201 plaintiff Sompnour Willim chaplain 753950 753950 Sompnour, Willim, of Holm, chaplain 0
4547385 2215112 2215112 defendant Puntynge John   753950 753950 Puntynge, John, of Holm 3
4602238 2231917 2231917 defendant Broun William   753950 753950 Broun, William, of Holm 1
4681995 2259986 2259986 plaintiff Morley Henry esq 753950 753950 Morley, Henry, of Holm, esq 0
4694295 2263714 2263714 defendant Barkere Thomas tanner 753950 753950 Barkere, Thomas, of Holm, tanner 0
4694302 2263716 2263716 defendant Barkere Thomas tanner 753950 753950 Barkere, Thomas, of Holm, tanner 0
4744417 2278889 2278889 defendant Ingram Robert gent 753950 753950 Ingram, Robert, of Holm, gent 3
4760590 2283657 2283657 defendant Barton John yeoman 753950 753950 together with Barton, John, of Holm, yeoman 3
4760591 2283657 2283657 defendant Berwys Stephen   753950 753950 Berwys, Stephen, of Holm, franklin 4
4784519 2291162 2291162 defendant Whyte William husbandman 753950 753950 Whyte, William, of Holm, husbandman 0
4804460 2297579 2297579 defendant White William husbandman 753950 753950 White, William, of Holm, husbandman 0
4855278 2313004 2313004 defendant del Scoles William chapman 753950 753950 del Scoles, William, of Holm, chapman 1
5022903 2363613 2363613 defendant Kaa William husbandman 753950 753950 Kaa, William, of Holm, husbandman 1
5022904 2363613 2363613 defendant Kaa Thomas husbandman 753950 753950 Kaa, Thomas, of Holm, husbandman 2
5084140 2381761 2381761 plaintiff Gilham William   753950 753950 (Gilham, William, of Holm 1
5395899 2473914 2473914 plaintiff Barton John merchant 753950 753950 Barton, John, of Holm, merchant 0
5409161 2477709 2477709 plaintiff Barton John merchant 753950 753950 Barton, John, of Holm, merchant 0
5565235 2524417 2524417 defendant Alye John husbandman 753950 753950 Alye, John, of Holm, husbandman 3
5609743 2546745 2546745 plaintiff Abot Richard   753950 753950 Abot, Richard, of Holm 0
5632949 2554311 2554311 defendant Whyte Nicholas yeoman 753950 753950 Whyte, Nicholas, of Holm, yeoman 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);