names

45 rows where place_id = 589452

✎ 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
3597683 1866901 1866901 defendant Sawyn John, senior husbandman 589452 589452 Sawyn, John, senior, of Parva Waltham, husbandman 2
3610528 1870955 1870955 defendant Wodham Thomas husbandman 589452 589452 Wodham, Thomas, of Parva Waltham, husbandman 0
3610529 1870955 1870955 defendant Wodham William husbandman 589452 589452 Wodham, William, of Parva Waltham, husbandman 1
3610530 1870955 1870955 defendant Wodham John husbandman 589452 589452 Wodham, John, of Parva Waltham, husbandman 2
3673367 1917687 1917687 defendant Burneby Eustace yeoman 589452 589452 Burneby, Eustace, of Parva Waltham, yeoman 1
3684047 1921145 1921145 defendant Scott John husbandman 589452 589452 Scott, John, of Parva Waltham, husbandman 1
3724441 1933929 1933929 defendant Wythers Robert husbandman 589452 589452 Wythers, Robert, of Parva Waltham, husbandman 0
3756589 1944042 1944042 defendant Serlee William husbandman 589452 589452 Serlee, William, of Parva Waltham, husbandman 0
3771309 1948717 1948717 defendant Stephen William husbandman 589452 589452 Stephen, William, of Parva Waltham, husbandman 1
3793791 1955922 1955922 defendant Garold John fuller 589452 589452 Garold, John, of Parva Waltham, fuller 0
3798921 1957576 1957576 defendant Payn William husbandman 589452 589452 Payn, William, of Parva Waltham, husbandman 2
3807998 1960392 1960392 defendant Serlee William husbandman 589452 589452 Serlee, William, of Parva Waltham, husbandman 0
3808001 1960392 1960392 defendant Dale John husbandman 589452 589452 Dale, John, of Parva Waltham, husbandman 3
3827806 1966563 1966563 defendant Garrold John husbandman 589452 589452 Garrold, John, of Parva Waltham, husbandman 2
3850644 1973792 1973792 defendant Malte John yeoman 589452 589452 Malte, John, of Parva Waltham, yeoman 1
3956886 2009478 2009478 defendant Pryte John laborer 589452 589452 Pryte, John, of Parva Waltham, laborer 1
4001052 2025151 2025151 defendant Edmond Thomas gent 589452 589452 Edmond, Thomas, of Parva Waltham, gent 0
4276584 2121745 2121745 defendant Pattenson Richard clerk 589452 589452 Pattenson, Richard, of Parva Waltham, clerk 0
4278032 2122249 2122249 defendant Northe Humphrey husbandman 589452 589452 Northe, Humphrey, of Parva Waltham, husbandman 0
4334510 2141816 2141816 defendant Pattenson Richard clerk 589452 589452 Pattenson, Richard, of Parva Waltham, clerk 0
4779537 2289581 2289581 defendant Lewegore John husbandman 589452 589452 Lewegore, John, of Parva Waltham, husbandman 0
4784889 2291281 2291281 defendant Crakebon Thomas fuller 589452 589452 Crakebon, Thomas, of Parva Waltham, fuller 3
4793535 2294087 2294087 plaintiff Osebarn John   589452 589452 Osebarn, John, of Parva Waltham 0
4867016 2316648 2316648 defendant Lewegore John husbandman 589452 589452 Lewegore, John, of Parva Waltham, husbandman 1
4867019 2316649 2316649 defendant Lewegore John husbandman 589452 589452 Lewegore, John, of Parva Waltham, husbandman 1
4878538 2320233 2320233 defendant Pernell William husbandman 589452 589452 Pernell, William, of Parva Waltham, husbandman 3
4886224 2322552 2322552 defendant Rolffe Roger barker 589452 589452 Rolffe, Roger, of Parva Waltham, barker 1
4889406 2323478 2323478 defendant Aleyn Thomas weaver 589452 589452 Aleyn, Thomas, of Parva Waltham, weaver 0
4893529 2324677 2324677 defendant Aleyn alias Webbe Thomas weaver 589452 589452 Aleyn alias Webbe, Thomas, of Parva Waltham, weaver 1
4893530 2324677 2324677 defendant Gerold William fuller 589452 589452 Gerold, William, of Parva Waltham, fuller 2
4893531 2324677 2324677 defendant atte Hill Stephen husbandman 589452 589452 atte Hill, Stephen, of Parva Waltham, husbandman 3
4898383 2326149 2326149 defendant Rolffe Roger barker 589452 589452 Rolffe, Roger, of Parva Waltham, barker 1
4904151 2327910 2327910 defendant Rolffe Roger barker 589452 589452 Rolffe, Roger, of Parva Waltham, barker 1
4956783 2343986 2343986 defendant Rolf Thomas butcher 589452 589452 Rolf, Thomas, of Parva Waltham, butcher 1
5116593 2391285 2391285 defendant Freman Thomas yeoman 589452 589452 Freman, Thomas, of Parva Waltham, yeoman 0
5279866 2439191 2439191 defendant Herde alias Freman Edmund husbandman 589452 589452 Herde alias Freman, Edmund, of Parva Waltham, husbandman 0
5279872 2439192 2439192 defendant Herde Edmund husbandman 589452 589452 Herde, Edmund, of Parva Waltham, husbandman 0
5316510 2450021 2450021 defendant Heerde William yeoman 589452 589452 (Heerde, William, of Parva Waltham, yeoman 1
5316511 2450021 2450021 defendant Heerde John yeoman 589452 589452 Heerde, John, of Parva Waltham, yeoman 2
5342066 2457710 2457710 plaintiff Rolf Thomas   589452 589452 Rolf, Thomas, of Parva Waltham 0
5342291 2457785 2457785 defendant Coke John, junior butcher 589452 589452 Coke, John, junior, of Parva Waltham, butcher 1
5348397 2459642 2459642 defendant Freman William husbandman 589452 589452 Freman, William, of Parva Waltham, husbandman 2
5348398 2459642 2459642 defendant Freman Thomas husbandman 589452 589452 Freman, Thomas, of Parva Waltham, husbandman 3
5491671 2502402 2502402 defendant Osbern John husbandman 589452 589452 Osbern, John, of Parva Waltham, husbandman 2
5601732 2535443 2535443 defendant Terbatt alias Parmentor John butcher 589452 589452 Terbatt alias Parmentor, John, of Parva Waltham, butcher 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);