names

71 rows where place_id = 601524

✎ 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
3645724 1909066 1909066 defendant Same John, junior husbandman 601524 601524 Same, John, junior, of Pyrton, husbandman 2
3646541 1909319 1909319 defendant Camme John yeoman 601524 601524 Camme, John, of Pyrton, yeoman 0
3646542 1909319 1909319 defendant Byrell Henry husbandman 601524 601524 Byrell, Henry, of Pyrton, husbandman 1
3646544 1909320 1909320 defendant Camme John yeoman 601524 601524 Camme, John, of Pyrton, yeoman 0
3646545 1909320 1909320 defendant Byrell Henry husbandman 601524 601524 Byrell, Henry, of Pyrton, husbandman 1
3655632 1912025 1912025 defendant Laurence Thomas husbandman 601524 601524 Laurence, Thomas, of Pyrton, husbandman 0
3655633 1912025 1912025 defendant Came John husbandman 601524 601524 Came, John, of Pyrton, husbandman 1
3681207 1920204 1920204 defendant Samme Richard husbandman 601524 601524 Samme, Richard, of Pyrton, husbandman 2
3691123 1923385 1923385 defendant Awnsell Thomas husbandman 601524 601524 Awnsell, Thomas, of Pyrton, husbandman 0
3696903 1925252 1925252 defendant Walsshe Gilbert husbandman 601524 601524 Walsshe, Gilbert, of Pyrton, husbandman 2
3697978 1925592 1925592 defendant Welshe Gilbert husbandman 601524 601524 Welshe, Gilbert, of Pyrton, husbandman 0
3697979 1925592 1925592 defendant Samme Richard husbandman 601524 601524 Samme, Richard, of Pyrton, husbandman 1
3704285 1927640 1927640 defendant Evyt John husbandman 601524 601524 Evyt, John, of Pyrton, husbandman 0
3704286 1927640 1927640 defendant Combey William laborer 601524 601524 Combey, William, of Pyrton, laborer 1
3706876 1928436 1928436 plaintiff Knyght John   601524 601524 Knyght, John, of Pyrton, servant 0
3724584 1933971 1933971 defendant Gooderiche Robert gent 601524 601524 Gooderiche, Robert, of Pyrton, gent 2
3724973 1934098 1934098 defendant Symon Thomas yeoman 601524 601524 Symon, Thomas, of Pyrton, yeoman 0
3724974 1934098 1934098 defendant Stolard Thomas yeoman 601524 601524 Stolard, Thomas, of Pyrton, yeoman 1
3724975 1934098 1934098 defendant Pynchyn Thomas husbandman 601524 601524 Pynchyn, Thomas, of Pyrton, husbandman 2
3746820 1940925 1940925 defendant Colley Richard husbandman 601524 601524 Colley, Richard, of Pyrton, husbandman 0
3746821 1940925 1940925 defendant Colley John husbandman 601524 601524 Colley, John, of Pyrton, husbandman 1
3747540 1941144 1941144 defendant Ramsey John gent 601524 601524 Ramsey, John, of Pyrton, gent 0
3750226 1941988 1941988 defendant Pulley Richard gent 601524 601524 Pulley, Richard, of Pyrton, gent 0
3750986 1942236 1942236 defendant Leycetur Henry laborer 601524 601524 Leycetur, Henry, of Pyrton, laborer 0
3750987 1942236 1942236 defendant Poley Richard gent 601524 601524 Poley, Richard, of Pyrton, gent 1
3750989 1942237 1942237 defendant Pulley Richard gent 601524 601524 Pulley, Richard, of Pyrton, gent 0
3754387 1943330 1943330 defendant Payn Richard husbandman 601524 601524 Payn, Richard, of Pyrton, husbandman 0
3754388 1943330 1943330 defendant Payn David husbandman 601524 601524 Payn, David, of Pyrton, husbandman 1
3754390 1943331 1943331 defendant Payne Richard husbandman 601524 601524 Payne, Richard, of Pyrton, husbandman 0
3754391 1943331 1943331 defendant Payne David husbandman 601524 601524 Payne, David, of Pyrton, husbandman 1
3760108 1945157 1945157 defendant Wytt William husbandman 601524 601524 Wytt, William, of Pyrton, husbandman 0
3760109 1945157 1945157 defendant Overbury John husbandman 601524 601524 Overbury, John, of Pyrton, husbandman 1
3793161 1955720 1955720 defendant Stokke John husbandman 601524 601524 Stokke, John, of Pyrton, husbandman 0
3803405 1958966 1958966 defendant Overby John butcher 601524 601524 Overby, John, of Pyrton, butcher 3
3804820 1959450 1959450 defendant Clerk William husbandman 601524 601524 Clerk, William, of Pyrton, husbandman 0
3825401 1965796 1965796 defendant Hogys John husbandman 601524 601524 Hogys, John, of Pyrton, husbandman 0
3855120 1975235 1975235 defendant Farre John husbandman 601524 601524 Farre, John, of Pyrton, husbandman 0
3857122 1975858 1975858 defendant Stocke John caryer 601524 601524 Stocke, John, of Pyrton, caryer 2
3861592 1977337 1977337 defendant Stocke John caryer 601524 601524 Stocke, John, of Pyrton, caryer 1
3889484 1986715 1986715 defendant Hewster John butcher 601524 601524 Hewster, John, of Pyrton, butcher 2
3889486 1986715 1986715 defendant Causey John husbandman 601524 601524 Causey, John, of Pyrton, husbandman 4
3891876 1987534 1987534 defendant Knyght John husbandman 601524 601524 Knyght, John, of Pyrton, husbandman 5
3894269 1988301 1988301 defendant Paynell John husbandman 601524 601524 Paynell, John, of Pyrton, husbandman 0
4154492 2079663 2079663 defendant Parker alias Bruer Richard yeoman 601524 601524 Parker alias Bruer, Richard, of Pyrton, yeoman 0
4154493 2079663 2079663 defendant Pytt Richard husbandman 601524 601524 Pytt, Richard, of Pyrton, husbandman 1
4182903 2089504 2089504 defendant Maslyn John yeoman 601524 601524 Maslyn, John, of Pyrton, yeoman 1
4218935 2102118 2102118 defendant Pulley Richard husbandman 601524 601524 Pulley, Richard, of Pyrton, husbandman 0
4226945 2104897 2104897 defendant Allen Alice widow 601524 601524 Allen, Alice, of Pyrton, widow 0
4296237 2128752 2128752 defendant Pulley Richard yeoman 601524 601524 Pulley, Richard, of Pyrton, yeoman 1
4296796 2128953 2128953 defendant Thatcher William yeoman 601524 601524 Thatcher, William, of Pyrton, yeoman 1
4340381 2143899 2143899 defendant Sugar Henry (legal representative) 601524 601524 Sugar, Henry, of Pyrton, husbandman, executors of 1
4340382 2143899 2143899 defendant Sugar Thomas husbandman 601524 601524 (Sugar, Thomas, of Pyrton, husbandman 2
4340383 2143899 2143899 defendant Sugar Thomasine widow 601524 601524 Sugar, Thomasine, of Pyrton, widow 3
4362205 2151528 2151528 defendant Jabes alias Blake John yeoman 601524 601524 Jabes alias Blake, John, of Pyrton, yeoman 1
4389400 2161080 2161080 defendant Myntridge John gent 601524 601524 Myntridge, John, of Pyrton, or of Bushley, gent 0
4412584 2168798 2168798 defendant Deacon John yeoman 601524 601524 Deacon, John, of Pyrton, yeoman 1
4621609 2237746 2237746 defendant Soct John   601524 601524 Soct, John, of Pyrton 0
4621617 2237748 2237748 defendant Scot John   601524 601524 Scot, John, of Pyrton 0
4879096 2320396 2320396 plaintiff Tregees Robert   601524 601524 Tregees, Robert, of Pyrton 0
5199027 2415467 2415467 defendant Love William husbandman 601524 601524 Love, William, of Pyrton, husbandman 1
5199030 2415467 2415467 defendant Fort Henry husbandman 601524 601524 Fort, Henry, of Pyrton, husbandman 4
5210893 2418919 2418919 defendant Love William husbandman 601524 601524 Love, William, of Pyrton, husbandman 1
5210896 2418919 2418919 defendant Fort Henry husbandman 601524 601524 Fort, Henry, of Pyrton, husbandman 4
5336180 2455902 2455902 defendant Folyate Richard gent 601524 601524 Folyate, Richard, of Pyrton, gent 1
5362943 2464057 2464057 defendant Coteler Thomas smith 601524 601524 Coteler, Thomas, of Pyrton, smith 2
5368994 2465894 2465894 defendant Jones Henry husbandman 601524 601524 Jones, Henry, of Pyrton, husbandman 0
5514845 2509488 2509488 defendant Tayllour John yeoman 601524 601524 Tayllour, John, of Pyrton, yeoman 2
5517063 2510170 2510170 defendant Tayllour John yeoman 601524 601524 Tayllour, John, of Pyrton, yeoman 2
5539060 2516699 2516699 defendant Dunne William husbandman 601524 601524 Dunne, William, of Pyrton, husbandman 3
5539061 2516699 2516699 defendant Bedford Thomas butcher 601524 601524 Bedford, Thomas, of Pyrton, butcher 4
5589876 2531817 2531817 defendant Spencer Robert husbandman 601524 601524 Spencer, Robert, of Pyrton, husbandman 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);