names

46 rows where place_id = 586099

✎ 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
3587940 1863879 1863879 defendant Folkard John husbandman 586099 586099 Folkard, John, of Eyke, husbandman 1
3598944 1867298 1867298 defendant Folkard John yeoman 586099 586099 Folkard, John, of Eyke, yeoman 0
3612961 1871700 1871700 defendant Westley Thomas husbandman 586099 586099 Westley, Thomas, of Eyke, husbandman 2
3665147 1915051 1915051 defendant Fyll Edward husbandman 586099 586099 Fyll, Edward, of Eyke, husbandman 0
3665178 1915062 1915062 defendant Bysshop Thomas miller 586099 586099 Bysshop, Thomas, of Eyke, miller 0
3675602 1918404 1918404 defendant Bysshop John miller 586099 586099 Bysshop, John, of Eyke, miller 2
3690086 1923061 1923061 plaintiff Fylle Edward   586099 586099 Fylle, Edward, of Eyke 0
3690088 1923062 1923062 plaintiff Fylle Edward   586099 586099 Fylle, Edward, of Eyke 0
3690090 1923063 1923063 plaintiff Fylle Edward   586099 586099 Fylle, Edward, of Eyke 0
3690092 1923064 1923064 plaintiff Fylle Edward   586099 586099 Fylle, Edward, of Eyke 0
3729666 1935530 1935530 defendant Byrde Robert butcher 586099 586099 Byrde, Robert, of Eyke, butcher 1
3756805 1944100 1944100 defendant Byrd Robert butcher 586099 586099 Byrd, Robert, of Eyke, butcher 2
3881777 1984158 1984158 defendant Newson John   586099 586099 Newson, John, of Eyke, twill weaver 1
3903113 1991269 1991269 defendant Kyngham Thomas husbandman 586099 586099 Kyngham, Thomas, of Eyke, husbandman 1
3960195 2010665 2010665 defendant Broke William smith 586099 586099 Broke, William, of Eyke, smith 0
4091215 2057147 2057147 defendant Crosse Abraham   586099 586099 Crosse, Abraham, of Eyke, twill weaver 0
4098037 2059628 2059628 defendant Garradd Gregory husbandman 586099 586099 Garradd, Gregory, of Eyke, husbandman 0
4124641 2069110 2069110 defendant Gade Ambrose blacksmith 586099 586099 Gade, Ambrose, of Eyke, blacksmith 0
4147833 2077382 2077382 defendant Man Richard tailor 586099 586099 Man, Richard, of Eyke, tailor 0
4151417 2078619 2078619 defendant Manne Richard tailor 586099 586099 Manne, Richard, of Eyke, tailor 0
4153743 2079407 2079407 defendant Grosse John (legal representative) 586099 586099 Grosse, John, of Eyke, yeoman, administrator of 0
4160346 2081693 2081693 defendant Grosse John (legal representative) 586099 586099 Grosse, John, of Eyke, yeoman, administrator of 0
4175122 2086761 2086761 defendant Bamber William yeoman 586099 586099 Bamber, William, of Eyke, yeoman 1
4182343 2089300 2089300 defendant Blumfeld William yeoman 586099 586099 Blumfeld, William, of Eyke, yeoman 1
4183978 2089894 2089894 defendant Bamber William husbandman 586099 586099 Bamber, William, of Eyke, husbandman 1
4193224 2093199 2093199 defendant Blomefeild William husbandman 586099 586099 Blomefeild, William, of Eyke, husbandman 0
4237019 2108528 2108528 defendant Marten William husbandman 586099 586099 Marten, William, of Eyke, husbandman 1
4239146 2109316 2109316 defendant Marten John husbandman 586099 586099 Marten, John, of Eyke, husbandman 3
4245628 2111518 2111518 defendant Marten William husbandman 586099 586099 Marten, William, of Eyke, husbandman 1
4253603 2114197 2114197 defendant Martyn William yeoman 586099 586099 Martyn, William, of Eyke, yeoman 1
4314925 2135330 2135330 defendant Martyn William husbandman 586099 586099 Martyn, William, of Eyke, husbandman 0
4335700 2142217 2142217 defendant Eade Ambrose blacksmith 586099 586099 Eade, Ambrose, of Eyke, blacksmith 2
4385770 2159932 2159932 defendant Playforde Robert husbandman 586099 586099 Playforde, Robert, of Eyke, husbandman 0
4390945 2161587 2161587 defendant Free John yeoman 586099 586099 Free, John, of Eyke, yeoman 2
4390952 2161589 2161589 defendant Free John yeoman 586099 586099 Free, John, of Eyke, yeoman 2
4967597 2347250 2347250 defendant Bury Nicholas gent 586099 586099 Bury, Nicholas, of Eyke, gent 0
4985060 2352462 2352462 defendant Mey John clerk 586099 586099 Mey, John, of Eyke, clerk 0
4995762 2355573 2355573 defendant Norman Stephen husbandman 586099 586099 Norman, Stephen, of Eyke, husbandman 1
5304142 2446247 2446247 defendant Spere Thomas husbandman 586099 586099 (Spere, Thomas, of Eyke, husbandman 1
5334464 2455381 2455381 defendant Aldewyn Thomas clerk 586099 586099 Aldewyn, Thomas, of Eyke, clerk 2
5341903 2457666 2457666 defendant Aylewyn Thomas clerk 586099 586099 Aylewyn, Thomas, of Eyke, clerk 0
5500190 2505010 2505010 defendant Kymbyr William husbandman 586099 586099 Kymbyr, William, of Eyke, husbandman 0
5500192 2505010 2505010 defendant Kymbyr Thomas butcher 586099 586099 Kymbyr, Thomas, of Eyke, butcher 2
5589086 2531594 2531594 defendant Bemond Charles laborer 586099 586099 Bemond, Charles, of Eyke, laborer 2
5596721 2533892 2533892 defendant Tastard John shoemaker 586099 586099 Tastard, John, of Eyke, shoemaker 2
5609522 2537874 2537874 defendant Westley Thomas husbandman 586099 586099 Westley, Thomas, of Eyke, husbandman 1

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);