names

31 rows where place_id = 609468

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678526 1919341 1919341 defendant Kyrkham George esq 609468 609468 Kyrkham, George, of Warmyngton, esq 0
3681100 1920169 1920169 defendant Kyrkeham George esq 609468 609468 Kyrkeham, George, of Warmyngton, esq 0
3681114 1920176 1920176 defendant Poorton Richard esq 609468 609468 Poorton, Richard, of Warmyngton, esq 0
3695505 1924816 1924816 defendant Kyrkham George gent 609468 609468 Kyrkham, George, of Warmyngton, gent 0
3765409 1946842 1946842 defendant Bakehouse Richard yeoman 609468 609468 Bakehouse, Richard, of Warmyngton, yeoman 0
3779427 1951289 1951289 defendant Kyrkeham Robert esq 609468 609468 Kyrkeham, Robert, of Warmyngton, esq 0
3839024 1970132 1970132 defendant Kyrkeham George (legal representative) 609468 609468 Kyrkeham, George, of Warmyngton, esq, executors of 0
3899571 1990075 1990075 plaintiff Blowfeld Thomas   609468 609468 Blowfeld, Thomas, of Warmyngton 0
4267362 2118721 2118721 defendant Reade Thomas husbandman 609468 609468 Reade, Thomas, of Warmyngton, husbandman 0
4292447 2127365 2127365 defendant Good William laborer 609468 609468 Good, William, of Warmyngton, laborer 1
4402448 2165406 2165406 defendant Pettyvere Richard husbandman 609468 609468 Pettyvere, Richard, of Warmyngton, husbandman 0
4515645 2205317 2205317 defendant Cook Robert   609468 609468 Cook, Robert, of Warmyngton 0
4526812 2208663 2208663 defendant Herd Adam   609468 609468 Herd, Adam, of Warmyngton 1
4532912 2210565 2210565 plaintiff Penruddok Thomas   609468 609468 Penruddok, Thomas, of Warmyngton, parson 2
4892785 2324470 2324470 defendant Hyll William clerk 609468 609468 Hyll, William, of Warmyngton, clerk 0
4906899 2328742 2328742 defendant Hyll William clerk 609468 609468 Hyll, William, of Warmyngton, clerk 0
5038628 2368197 2368197 defendant Stokke John esq 609468 609468 Stokke, John, of Warmyngton, esq 0
5038966 2368300 2368300 defendant Corke William husbandman 609468 609468 Corke, William, of Warmyngton, husbandman 3
5091098 2383791 2383791 defendant Mylner Walter husbandman 609468 609468 Mylner, Walter, of Warmyngton, husbandman 0
5117160 2391446 2391446 defendant Thelby John husbandman 609468 609468 Thelby, John, of Warmyngton, husbandman 0
5157869 2403428 2403428 defendant Thelby John husbandman 609468 609468 Thelby, John, of Warmyngton, husbandman 2
5181417 2410308 2410308 plaintiff Caker William   609468 609468 Caker, William, of Warmyngton 0
5181422 2410309 2410309 plaintiff Caker William   609468 609468 Caker, William, of Warmyngton 0
5181427 2410310 2410310 plaintiff Caker William   609468 609468 Caker, William, of Warmyngton 0
5206390 2417604 2417604 plaintiff Kaker William   609468 609468 Kaker, William, of Warmyngton 0
5208309 2418159 2418159 defendant Thelby John husbandman 609468 609468 Thelby, John, of Warmyngton, husbandman 2
5354010 2461315 2461315 defendant Fermour William, junior husbandman 609468 609468 Fermour, William, junior, of Warmyngton, husbandman 4
5359023 2462872 2462872 defendant Draper John husbandman 609468 609468 Draper, John, of Warmyngton, husbandman 2
5379904 2469300 2469300 defendant Coddyng William clerk 609468 609468 Coddyng, William, of Warmyngton, clerk 2
5609549 2537882 2537882 defendant Fermour William   609468 609468 Fermour, William, of Warmyngton 0
5632326 2554140 2554140 defendant Harry John husbandman 609468 609468 Harry, John, of Warmyngton, husbandman 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);