names

19 rows where place_id = 668092

✎ 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
3987767 2020374 2020374 defendant ap John Owen carpenter 668092 668092 ap John, Owen, of Smethecote, carpenter 2
3987768 2020374 2020374 defendant ap John Morgan carpenter 668092 668092 ap John, Morgan, of Smethecote, carpenter 3
3987776 2020375 2020375 defendant Longford Thomas laborer 668092 668092 Longford, Thomas, of Smethecote, laborer 6
3987783 2020376 2020376 defendant Gyttons Thomas laborer 668092 668092 Gyttons, Thomas, of Smethecote, laborer 5
3987784 2020376 2020376 defendant Longford Thomas laborer 668092 668092 Longford, Thomas, of Smethecote, laborer 6
4021689 2032482 2032482 defendant Johnson George husbandman 668092 668092 Johnson, George, of Smethecote, husbandman 0
4101410 2060808 2060808 defendant Perkes John tailor 668092 668092 Perkes, John, of Smethecote, tailor 1
4101412 2060808 2060808 defendant Haywarde John husbandman 668092 668092 Haywarde, John, of Smethecote, husbandman 3
4101416 2060809 2060809 defendant Gyles David husbandman 668092 668092 Gyles, David, of Smethecote, husbandman 1
4589401 2228063 2228063 plaintiff Ley John de   668092 668092 Ley, John de, of Smethecote 0
4621814 2237809 2237809 plaintiff Lee John   668092 668092 Lee, John, of Smethecote 0
4766426 2285492 2285492 plaintiff Lee John   668092 668092 Lee, John, of Smethecote 0
4767204 2285727 2285727 defendant Hoper William husbandman 668092 668092 Hoper, William, of Smethecote, husbandman 3
4801998 2296810 2296810 defendant Hoper William husbandman 668092 668092 Hoper, William, of Smethecote, husbandman 2
4857482 2313729 2313729 defendant Nicholas Walter chaplain 668092 668092 Nicholas, Walter, of Smethecote, chaplain 0
4857483 2313729 2313729 defendant Hochekys John laborer 668092 668092 Hochekys, John, of Smethecote, laborer 1
4857484 2313729 2313729 defendant Perkys Thomas husbandman 668092 668092 Perkys, Thomas, of Smethecote, husbandman 2
5026485 2364627 2364627 defendant Shelfork Thomas husbandman 668092 668092 Shelfork, Thomas, of Smethecote, husbandman 6
5256087 2432028 2432028 defendant Smethecote John clerk 668092 668092 Smethecote, John, of Smethecote, clerk 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);