names

32 rows where place_id = 598871

✎ 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
3634395 1905555 1905555 defendant Malet Thomas husbandman 598871 598871 Malet, Thomas, of Hardewyke, husbandman 0
3651609 1910860 1910860 defendant Warde Johnm yeoman 598871 598871 Warde, Johnm, of Hardewyke, yeoman 1
3659385 1913195 1913195 defendant Bold Hugh yeoman 598871 598871 Bold, Hugh, of Hardewyke, yeoman 2
3669429 1916377 1916377 defendant Homersley Richard yeoman 598871 598871 Homersley, Richard, of Hardewyke, yeoman 1
3699332 1926008 1926008 defendant Wodefall John chapman 598871 598871 Wodefall, John, of Hardewyke, chapman 0
3772528 1949098 1949098 defendant Bolde Hugh yeoman 598871 598871 Bolde, Hugh, of Hardewyke, yeoman 1
3772529 1949098 1949098 defendant Bolde Ralph husbandman 598871 598871 Bolde, Ralph, of Hardewyke, husbandman 2
3833124 1968286 1968286 defendant Dobyns Guy yeoman 598871 598871 Dobyns, Guy, of Hardewyke, yeoman 0
3896975 1989205 1989205 defendant Pemeyer Robert gent 598871 598871 Pemeyer, Robert, of Hardewyke, gent 1
3898824 1989809 1989809 defendant Leyntwall Geward husbandman 598871 598871 Leyntwall, Geward, of Hardewyke, husbandman 0
3912416 1994484 1994484 defendant Colley William husbandman 598871 598871 Colley, William, of Hardewyke, husbandman 0
4212715 2099988 2099988 defendant Probert William yeoman 598871 598871 Probert, William, of Hardewyke, yeoman 0
4711443 2268908 2268908 defendant Matheuson Robert yeoman 598871 598871 Matheuson, Robert, of Hardewyke, yeoman 0
4809986 2299281 2299281 defendant Champayn John husbandman 598871 598871 Champayn, John, of Hardewyke, husbandman 5
4978277 2350450 2350450 defendant Sones William husbandman 598871 598871 Sones, William, of Hardewyke, husbandman 1
4979000 2350676 2350676 defendant Grove John husbandman 598871 598871 Grove, John, of Hardewyke, husbandman 0
5144341 2399501 2399501 defendant Solers Thomas yeoman 598871 598871 Solers, Thomas, of Hardewyke, yeoman 0
5165227 2405574 2405574 defendant Solers Thomas yeoman 598871 598871 Solers, Thomas, of Hardewyke, yeoman 0
5179079 2409611 2409611 defendant Solers Thomas yeoman 598871 598871 Solers, Thomas, of Hardewyke, yeoman 0
5287259 2441295 2441295 defendant Laneman John husbandman 598871 598871 Laneman, John, of Hardewyke, husbandman 0
5350952 2460410 2460410 defendant Dalamare William gent 598871 598871 Dalamare, William, of Hardewyke, gent 0
5350954 2460411 2460411 defendant Dalamare William gent 598871 598871 Dalamare, William, of Hardewyke, gent 0
5431513 2484382 2484382 defendant Ombersley Richard yeoman 598871 598871 Ombersley, Richard, of Hardewyke, yeoman 1
5443264 2487902 2487902 plaintiff Buntyng Thomas   598871 598871 Buntyng, Thomas, of Hardewyke 0
5445002 2488390 2488390 defendant Fendyke Simon husbandman 598871 598871 Fendyke, Simon, of Hardewyke, husbandman 3
5445118 2488428 2488428 plaintiff Dunnyng Thomas   598871 598871 Dunnyng, Thomas, of Hardewyke 0
5455988 2491703 2491703 plaintiff Bunnyng Thomas   598871 598871 Bunnyng, Thomas, of Hardewyke 0
5457632 2492182 2492182 defendant Fendyke Simon husbandman 598871 598871 Fendyke, Simon, of Hardewyke, husbandman 3
5480519 2499144 2499144 defendant Wortley John gent 598871 598871 Wortley, John, of Hardewyke, gent 2
5520449 2511215 2511215 defendant Bysshop Richard husbandman 598871 598871 Bysshop, Richard, of Hardewyke, husbandman 0
5520450 2511215 2511215 defendant Mallet John husbandman 598871 598871 Mallet, John, of Hardewyke, husbandman 1
5520451 2511215 2511215 defendant Toppyng Thomas husbandman 598871 598871 Toppyng, Thomas, of Hardewyke, 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);