names

19 rows where place_id = 635410

✎ 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
3825233 1965754 1965754 defendant Skipwith William esq 635410 635410 Skipwith, William, of South Ormesby, esq 0
3825239 1965755 1965755 defendant Skipwith William esq 635410 635410 Skipwith, William, of South Ormesby, esq 0
3916908 1996021 1996021 plaintiff Garbray William clerk 635410 635410 Garbray, William, of South Ormesby, clerk 0
4275719 2121454 2121454 defendant Carsey John gent 635410 635410 Carsey, John, of South Ormesby, gent 1
4464309 2189503 2189503 defendant Warde John   635410 635410 Warde, John, of South Ormesby, son of Robert 0
4621282 2237643 2237643 plaintiff Kynson John   635410 635410 Kynson, John, of South Ormesby 0
4658629 2248574 2248574 defendant Wryght William   635410 635410 Wryght, William, of South Ormesby, wright 1
4681874 2259945 2259945 defendant Barbour Robert barber 635410 635410 Barbour, Robert, of South Ormesby, barber 0
4705850 2267203 2267203 defendant Flesshewer Robert butcher 635410 635410 Flesshewer, Robert, of South Ormesby, butcher 1
4706620 2267450 2267450 defendant Crosse John laborer 635410 635410 Crosse, John, of South Ormesby, laborer 0
4706621 2267450 2267450 defendant Barbour Robert barber 635410 635410 Barbour, Robert, of South Ormesby, barber 1
4800417 2296310 2296310 defendant Botere William husbandman 635410 635410 Botere, William, of South Ormesby, husbandman 0
4850005 2311472 2311472 defendant Lave John husbandman 635410 635410 Lave, John, of South Ormesby, husbandman 1
4850006 2311472 2311472 defendant Dowmay Robert husbandman 635410 635410 Dowmay, Robert, of South Ormesby, husbandman 2
4850034 2311476 2311476 defendant Gewnay John husbandman 635410 635410 Gewnay, John, of South Ormesby, husbandman 2
5227709 2423722 2423722 defendant Daweney Robert (legal representative) 635410 635410 Daweney, Robert, of South Ormesby, executors of 3
5227710 2423722 2423722 defendant Pyper Robert husbandman 635410 635410 (Pyper, Robert, of South Ormesby, husbandman 4
5227711 2423722 2423722 defendant Cust Simon husbandman 635410 635410 Cust, Simon, of South Ormesby, husbandman 5
5227712 2423722 2423722 defendant Pycher John husbandman 635410 635410 Pycher, John, of South Ormesby, husbandman 6

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