names

22 rows where place_id = 640530

✎ 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
3855846 1975458 1975458 defendant Kyng Thomas yeoman 640530 640530 Kyng, Thomas, of Est Claydon, yeoman 0
3855848 1975458 1975458 defendant Kyng John laborer 640530 640530 Kyng, John, of Est Claydon, laborer 2
4037990 2038233 2038233 plaintiff Kyng William gent 640530 640530 Kyng, William, of Est Claydon, gent 0
4436865 2176272 2176272 plaintiff Syward Robert (legal representative) 640530 640530 Syward, Robert, of East Claydon, parson, executors of 0
4436871 2176273 2176273 plaintiff Syward Robert (legal representative) 640530 640530 Syward, Robert, of East Claydon, parson, executors of 0
4657282 2248169 2248169 defendant Keyng John husbandman 640530 640530 Keyng, John, of Est Claydon, husbandman 0
4721896 2272180 2272180 defendant Kyng John husbandman 640530 640530 Kyng, John, of East Claydon, husbandman 2
4936265 2337741 2337741 defendant Claydon alis Jhonys William clerk 640530 640530 Claydon alis Jhonys, William, of Est Claydon, clerk 2
4990301 2354007 2354007 defendant Smyth alias Warner William husbandman 640530 640530 Smyth alias Warner, William, of East Claydon, husbandman 1
5098001 2385846 2385846 defendant Parnell Robert husbandman 640530 640530 Parnell, Robert, of Est Claydon, husbandman 0
5098002 2385846 2385846 defendant Parnell John   640530 640530 Parnell, John, of Est Claydon, servant 1
5146864 2400222 2400222 defendant Brook William husbandman 640530 640530 Brook, William, of East Claydon, husbandman 0
5146865 2400222 2400222 defendant Warner Richard husbandman 640530 640530 Warner, Richard, of East Claydon, husbandman 1
5274510 2437622 2437622 defendant Elyot Richard husbandman 640530 640530 Elyot, Richard, of East Claydon, husbandman 0
5318254 2450554 2450554 defendant Barker John gent 640530 640530 Barker, John, of Est Claydon, gent 0
5318256 2450555 2450555 defendant Barker John gent 640530 640530 Barker, John, of Est Claydon, gent 0
5321555 2451534 2451534 defendant Gillyot John husbandman 640530 640530 Gillyot, John, of Est Claydon, husbandman 0
5497231 2504110 2504110 defendant Taillour alias Pregett Robert yeoman 640530 640530 Taillour alias Pregett, Robert, of Est Claydon, yeoman 0
5555477 2521604 2521604 defendant Pontifex John carter 640530 640530 Pontifex, John, of Est Claydon, carter 0
5555478 2521604 2521604 defendant Sumiter John carter 640530 640530 Sumiter, John, of Est Claydon, carter 1
5558199 2522349 2522349 defendant Stevyns William husbandman 640530 640530 Stevyns, William, of Est Claydon, husbandman 0
5596109 2533698 2533698 defendant Pontyfex Robert husbandman or carrier 640530 640530 Pontyfex, Robert, of Est Claydon, husbandman or carrier 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);