names

29 rows where place_id = 675884

✎ 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
4020492 2032051 2032051 defendant Sariante John carpenter 675884 675884 Sariante, John, of Kettering, carpenter 0
4457523 2187365 2187365 defendant Wade John   675884 675884 Wade, John, of Kettering, parson 0
4465298 2189817 2189817 defendant Thresher John   675884 675884 Thresher, John, of Kettering 0
4511890 2204168 2204168 plaintiff Bocher Thomas   675884 675884 Bocher, Thomas, of Kettering 0
4524583 2208021 2208021 defendant Bocher Thomas   675884 675884 Bocher, Thomas, of Kettering 0
4532999 2210591 2210591 defendant Milnere Nicholas   675884 675884 Milnere, Nicholas, of Kettering 3
4535431 2211354 2211354 defendant Bochere Thomas   675884 675884 Bochere, Thomas, of Kettering 0
4757861 2282836 2282836 defendant Bocher William butcher 675884 675884 Bocher, William, of Kettering, butcher 0
4765243 2285112 2285112 defendant Mutte William husbandman 675884 675884 Mutte, William, of Kettering, husbandman 2
4774536 2288022 2288022 defendant Taillour John tailor 675884 675884 Taillour, John, of Kettering, tailor 0
4774537 2288022 2288022 defendant Wryght Andrew husbandman 675884 675884 Wryght, Andrew, of Kettering, husbandman 1
4774538 2288022 2288022 defendant Brewester John husbandman 675884 675884 Brewester, John, of Kettering, husbandman 2
4774770 2288101 2288101 defendant Barber Adam (legal representative) 675884 675884 Barber, Adam, of Kettering, executrix of 1
5151609 2401626 2401626 plaintiff Myles John   675884 675884 Myles, John, of Kettering 1
5156858 2403156 2403156 defendant Drake John tailor 675884 675884 Drake, John, of Kettering, tailor 0
5156859 2403156 2403156 defendant Forster John weaver 675884 675884 Forster, John, of Kettering, weaver 1
5168530 2406511 2406511 defendant Drake Simon draper 675884 675884 Drake, Simon, of Kettering, draper 0
5168531 2406511 2406511 defendant Drake John tailor 675884 675884 Drake, John, of Kettering, tailor 1
5172913 2407802 2407802 defendant Drake John tailor 675884 675884 Drake, John, of Kettering, tailor 0
5172914 2407802 2407802 defendant Forster John weaver 675884 675884 Forster, John, of Kettering, weaver 1
5184518 2411215 2411215 defendant Drake Simon draper 675884 675884 Drake, Simon, of Kettering, draper 0
5184519 2411215 2411215 defendant Drake John tailor 675884 675884 Drake, John, of Kettering, tailor 1
5184522 2411216 2411216 defendant Drake Simon draper 675884 675884 Drake, Simon, of Kettering, draper 0
5184523 2411216 2411216 defendant Drake John tailor 675884 675884 Drake, John, of Kettering, tailor 1
5184526 2411217 2411217 defendant Drake Simon draper 675884 675884 Drake, Simon, of Kettering, draper 0
5184527 2411217 2411217 defendant Drake John tailor 675884 675884 Drake, John, of Kettering, tailor 1
5422492 2481673 2481673 defendant Mylys Richard dyer 675884 675884 Mylys, Richard, of Kettering, dyer 3
5442155 2487570 2487570 defendant Milys Richard dyer 675884 675884 Milys, Richard, of Kettering, dyer 3
5475538 2497682 2497682 defendant Vance John mercer 675884 675884 Vance, John, of Kettering, mercer 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);