names

63 rows where place_id = 598878

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634429 1905568 1905568 defendant Dawny Robert husbandman 598878 598878 Dawny, Robert, of Stapleford, husbandman 1
3641474 1907792 1907792 defendant Combe Thomas yeoman 598878 598878 Combe, Thomas, of Stapleford, yeoman 1
3688843 1922670 1922670 defendant Sharrard Thomas esq 598878 598878 Sharrard, Thomas, of Stapleford, esq 0
3688845 1922671 1922671 defendant Sharrard Thomas esq 598878 598878 Sharrard, Thomas, of Stapleford, esq 0
3724946 1934089 1934089 defendant Dovy Robert husbandman 598878 598878 Dovy, Robert, of Stapleford, husbandman 1
3732674 1936449 1936449 defendant Chykkyn William husbandman 598878 598878 Chykkyn, William, of Stapleford, husbandman 3
3737276 1937895 1937895 defendant Lincoln Thomas husbandman 598878 598878 Lincoln, Thomas, of Stapleford Abbot, husbandman 0
3738391 1938218 1938218 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3738393 1938218 1938218 defendant Alee Thomas yeoman 598878 598878 Alee, Thomas, of Stapleford, yeoman 3
3738401 1938219 1938219 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3738403 1938219 1938219 defendant Lee Thomas yeoman 598878 598878 Lee, Thomas, of Stapleford, yeoman 3
3738411 1938220 1938220 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3738413 1938220 1938220 defendant Lee Thomas yeoman 598878 598878 Lee, Thomas, of Stapleford, yeoman 3
3738650 1938298 1938298 defendant Harrys John husbandman 598878 598878 Harrys, John, of Stapleford, husbandman 0
3738651 1938298 1938298 defendant Harrys Thomas husbandman 598878 598878 Harrys, Thomas, of Stapleford, husbandman 1
3738652 1938298 1938298 defendant Smert John husbandman 598878 598878 Smert, John, of Stapleford, husbandman 2
3738653 1938298 1938298 defendant Whyte Nicholas husbandman 598878 598878 Whyte, Nicholas, of Stapleford, husbandman 3
3738654 1938298 1938298 defendant Doo John husbandman 598878 598878 Doo, John, of Stapleford, husbandman 4
3745811 1940593 1940593 defendant Daunce Robert husbandman 598878 598878 Daunce, Robert, of Stapleford, husbandman 2
3748684 1941516 1941516 defendant Dycheburn John laborer 598878 598878 Dycheburn, John, of Stapleford, laborer 0
3751060 1942262 1942262 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3751062 1942262 1942262 defendant Alee Thomas yeoman 598878 598878 Alee, Thomas, of Stapleford, yeoman 3
3751070 1942263 1942263 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3751072 1942263 1942263 defendant Alee Thomas yeoman 598878 598878 Alee, Thomas, of Stapleford, yeoman 3
3751284 1942325 1942325 defendant Harrys John husbandman 598878 598878 Harrys, John, of Stapleford, husbandman 0
3751285 1942325 1942325 defendant Harrys Thomas husbandman 598878 598878 Harrys, Thomas, of Stapleford, husbandman 1
3751286 1942325 1942325 defendant Smart John husbandman 598878 598878 Smart, John, of Stapleford, husbandman 2
3751287 1942325 1942325 defendant White Nicholas husbandman 598878 598878 White, Nicholas, of Stapleford, husbandman 3
3751288 1942325 1942325 defendant Doo John husbandman 598878 598878 Doo, John, of Stapleford, husbandman 4
3760917 1945419 1945419 defendant Dovy Robert yeoman 598878 598878 Dovy, Robert, of Stapleford, yeoman 0
3760918 1945419 1945419 defendant Harford Robert husbandman 598878 598878 Harford, Robert, of Stapleford, husbandman 1
3767015 1947347 1947347 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3767017 1947347 1947347 defendant Lee Thomas yeoman 598878 598878 Lee, Thomas, of Stapleford, yeoman 3
3767025 1947348 1947348 defendant Sherard Richard gent 598878 598878 Sherard, Richard, of Stapleford, gent 1
3767027 1947348 1947348 defendant Alee Thomas yeoman 598878 598878 Alee, Thomas, of Stapleford, yeoman 3
3767779 1947559 1947559 defendant Goodman Robert husbandman 598878 598878 Goodman, Robert, of Stapleford, husbandman 0
3799025 1957606 1957606 defendant Goodman Robert husbandman 598878 598878 Goodman, Robert, of Stapleford, husbandman 0
3801737 1958439 1958439 defendant Totehyll William clerk 598878 598878 Totehyll, William, of Stapleford, clerk 0
3801738 1958439 1958439 defendant Smyth John yeoman 598878 598878 Smyth, John, of Stapleford, yeoman 1
3801740 1958439 1958439 defendant Tyler John laborer 598878 598878 Tyler, John, of Stapleford, laborer 3
3830072 1967301 1967301 defendant Dant Robert yeoman 598878 598878 Dant, Robert, of Stapleford, yeoman 0
3833576 1968435 1968435 defendant Teverey Robert esq 598878 598878 Teverey, Robert, of Stapleford, esq 0
3851041 1973917 1973917 defendant Jessen Robert husbandman 598878 598878 Jessen, Robert, of Stapleford, husbandman 0
3914452 1995177 1995177 defendant Hartford Robert gent 598878 598878 Hartford, Robert, of Stapleford, gent 0
3916169 1995793 1995793 defendant Dant Robert yeoman 598878 598878 Dant, Robert, of Stapleford, yeoman 0
3995594 2023169 2023169 defendant White John husbandman 598878 598878 White, John, of Stapleford, husbandman 1
4048489 2041911 2041911 defendant Martyne alias Martell John (legal representative) 598878 598878 Martyne alias Martell, John, of Stapleford, yeoman, executors of 0
4048490 2041911 2041911 defendant Martyne alias Martell Peter husbandman 598878 598878 (Martyne alias Martell, Peter, of Stapleford, husbandman 1
4062978 2047062 2047062 defendant Cutler Richard gent 598878 598878 Cutler, Richard, of Stapleford, gent 1
4140228 2074749 2074749 defendant Warden Henry husbandman 598878 598878 Warden, Henry, of Stapleford, husbandman 0
4143804 2075993 2075993 defendant Lucke Thomas smith 598878 598878 Lucke, Thomas, of Stapleford, smith 1
4156795 2080455 2080455 defendant Harryes William yeoman 598878 598878 Harryes, William, of Stapleford, yeoman 0
4247918 2112287 2112287 defendant Dysney William gent 598878 598878 Dysney, William, of Stapleford, gent 0
4279228 2122666 2122666 defendant Taylor John yeoman 598878 598878 Taylor, John, of Stapleford, yeoman 0
4382185 2158735 2158735 defendant Cave Richard tailor 598878 598878 Cave, Richard, of Stapleford, tailor 0
4524781 2208089 2208089 defendant Wyllyng Robert chaplain 598878 598878 Wyllyng, Robert, of Stapleford, chaplain 2
4692098 2263058 2263058 defendant Ive John farmer 598878 598878 Ive, John, of Stapleford Abbot, farmer 0
4758828 2283114 2283114 defendant Porter Robert husbandman 598878 598878 Porter, Robert, of Stapleford, husbandman 1
5251649 2430619 2430619 defendant White Simon yeoman 598878 598878 White, Simon, of Stapleford, yeoman 0
5288820 2441742 2441742 defendant Sparowe John yeoman 598878 598878 Sparowe, John, of Stapleford Abbot, yeoman 1
5288821 2441742 2441742 defendant Bole Thomas yeoman 598878 598878 Bole, Thomas, of Stapleford Abbot, yeoman 2
5420237 2480974 2480974 defendant Pygot Thomas   598878 598878 Pygot, Thomas, of Stapleford 0
5557654 2522195 2522195 defendant Bevis John husbandman 598878 598878 Bevis, John, of Stapleford, husbandman 3

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