names

13 rows where place_id = 592750

✎ 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
3608747 1870399 1870399 defendant Emond John drover 592750 592750 Emond, John, of Tirlyngton, drover 0
4556213 2217882 2217882 defendant Boyville Thomas   592750 592750 Boyville, Thomas, of Tirlyngton 6
4661621 2249471 2249471 plaintiff Ernesby Thomas   592750 592750 Ernesby, Thomas, of Tirlyngton 0
4661623 2249472 2249472 plaintiff Ernesby Thomas   592750 592750 Ernesby, Thomas, of Tirlyngton 0
4991107 2354230 2354230 defendant Briges Thomas husbandman 592750 592750 Briges, Thomas, of Tirlyngton, husbandman 0
4991108 2354230 2354230 defendant Peke Thomas husbandman 592750 592750 Peke, Thomas, of Tirlyngton, husbandman 1
4991109 2354230 2354230 defendant Peke William husbandman 592750 592750 Peke, William, of Tirlyngton, husbandman 2
5172606 2407713 2407713 defendant Jakkes William husbandman 592750 592750 Jakkes, William, of Tirlyngton, husbandman 1
5257629 2432506 2432506 defendant Vyncent William weaver 592750 592750 Vyncent, William, of Tirlyngton, weaver 0
5310377 2448138 2448138 defendant Edmond Robert drover 592750 592750 Edmond, Robert, of Tirlyngton, drover 0
5310378 2448138 2448138 defendant Edmond John   592750 592750 Edmond, John, of Tirlyngton, laborer, son of the said Robert 1
5334283 2455323 2455323 defendant Dunche William husbandman 592750 592750 Dunche, William, of Tirlyngton, husbandman 1
5334284 2455323 2455323 defendant Spencer John husbandman 592750 592750 Spencer, John, of Tirlyngton, husbandman 2

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