names

45 rows where place_id = 593617

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612593 1871576 1871576 defendant Yonge William husbandman 593617 593617 Yonge, William, of Chyngford, husbandman 0
3612594 1871576 1871576 defendant Webbe Richard husbandman 593617 593617 Webbe, Richard, of Chyngford, husbandman 1
3617413 1873065 1873065 defendant Wodeward Thomas yeoman 593617 593617 Wodeward, Thomas, of Chyngford, yeoman 0
3682084 1920506 1920506 defendant Webster William husbandman 593617 593617 Webster, William, of Chyngford, husbandman 0
3682085 1920506 1920506 defendant Case Thomas husbandman 593617 593617 Case, Thomas, of Chyngford, husbandman 1
3704333 1927656 1927656 defendant Ellesdale Richard (legal representative) 593617 593617 Ellesdale, Richard, of Chyngford, husbandman, executors of 0
3711101 1929783 1929783 defendant Cawell Richard husbandman 593617 593617 Cawell, Richard, of Chyngford, husbandman 0
3774218 1949653 1949653 plaintiff Archer John clerk 593617 593617 Archer, John, of Chyngford, clerk 0
3820157 1964182 1964182 defendant Melsham Thomas husbandman 593617 593617 Melsham, Thomas, of Chyngford, husbandman 0
3852270 1974310 1974310 defendant Frend Richard laborer 593617 593617 Frend, Richard, of Chyngford, laborer 0
3852271 1974310 1974310 defendant Lyghtfote John yeoman 593617 593617 Lyghtfote, John, of Chyngford, yeoman 1
3852273 1974311 1974311 defendant Frende Richard laborer 593617 593617 Frende, Richard, of Chyngford, laborer 0
3862597 1977685 1977685 defendant Stondon John husbandman 593617 593617 Stondon, John, of Chyngford, husbandman 0
3862693 1977716 1977716 defendant Stondon John husbandman 593617 593617 Stondon, John, of Chyngford, husbandman 0
5114292 2390575 2390575 defendant Wylson Nicholas yeoman 593617 593617 Wylson, Nicholas, of Chyngford, yeoman 0
5233327 2425332 2425332 defendant Mannyng Thomas, senior husbandman 593617 593617 Mannyng, Thomas, senior, of Chyngford, husbandman 0
5233328 2425332 2425332 defendant Hode John husbandman 593617 593617 Hode, John, of Chyngford, husbandman 1
5254771 2431608 2431608 defendant Mannyng Thomas fisher 593617 593617 Mannyng, Thomas, of Chyngford, fisher 0
5274298 2437565 2437565 defendant Chadkirke Nicholas gent 593617 593617 Chadkirke, Nicholas, of Chyngford, gent 0
5274299 2437565 2437565 defendant Mannyng Thomas, senior yeoman 593617 593617 Mannyng, Thomas, senior, of Chyngford, yeoman 1
5274300 2437565 2437565 defendant Tregette John husbandman 593617 593617 Tregette, John, of Chyngford, husbandman 2
5296732 2444033 2444033 defendant Courtman Richard husbandman 593617 593617 Courtman, Richard, of Chyngford, husbandman 1
5316910 2450137 2450137 defendant Brendewode John husbandman 593617 593617 Brendewode, John, of Chyngford, husbandman 0
5316911 2450137 2450137 defendant Fryday Thomas husbandman 593617 593617 Fryday, Thomas, of Chyngford, husbandman 1
5316912 2450137 2450137 defendant Whitehood Robert husbandman 593617 593617 Whitehood, Robert, of Chyngford, husbandman 2
5316913 2450137 2450137 defendant Foulden Henry husbandman 593617 593617 Foulden, Henry, of Chyngford, husbandman 3
5316914 2450137 2450137 defendant Bowyer Thomas husbandman 593617 593617 Bowyer, Thomas, of Chyngford, husbandman 4
5352116 2460769 2460769 defendant Foulden Henry brewer 593617 593617 Foulden, Henry, of Chyngford, brewer 1
5382186 2469962 2469962 defendant Buxton John husbandman 593617 593617 Buxton, John, of Chyngford, husbandman 1
5382387 2470019 2470019 defendant Ellesdale Richard husbandman 593617 593617 Ellesdale, Richard, of Chyngford, husbandman 3
5391549 2472654 2472654 defendant Ellesdale Richard husbandman 593617 593617 Ellesdale, Richard, of Chyngford, husbandman 3
5404555 2476375 2476375 defendant Ellesdale Richard husbandman 593617 593617 Ellesdale, Richard, of Chyngford, husbandman 3
5435137 2485438 2485438 defendant Ellesdale Richard husbandman 593617 593617 Ellesdale, Richard, of Chyngford, husbandman 2
5456426 2491842 2491842 defendant Cappes Richard   593617 593617 Cappes, Richard, of Chyngford, tile maker 0
5456430 2491843 2491843 defendant Cappes William   593617 593617 Cappes, William, of Chyngford, tile maker 2
5485379 2500540 2500540 defendant Glesdale Richard husbandman 593617 593617 Glesdale, Richard, of Chyngford, husbandman 3
5499348 2504745 2504745 defendant Balle William husbandman 593617 593617 Balle, William, of Chyngford, husbandman 3
5513859 2509187 2509187 defendant Ellesdale Richard husbandman 593617 593617 Ellesdale, Richard, of Chyngford, husbandman 2
5527677 2513237 2513237 defendant Sell William husbandman 593617 593617 Sell, William, of Chyngford, husbandman 0
5533181 2514927 2514927 defendant Sell William husbandman 593617 593617 Sell, William, of Chyngford, husbandman 0
5533183 2514928 2514928 defendant Sell William husbandman 593617 593617 Sell, William, of Chyngford, husbandman 0
5548104 2519474 2519474 defendant Freman William brewer 593617 593617 Freman, William, of Chyngford, brewer 1
5548106 2519474 2519474 defendant Speller John brewer 593617 593617 Speller, John, of Chyngford, brewer 3
5586154 2530711 2530711 defendant Claydon John   593617 593617 Claydon, John, of Chyngford, tile maker 0
5620958 2550431 2550431 plaintiff Smyth Walter   593617 593617 Smyth, Walter, of Chyngford 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);