names

51 rows where place_id = 631668

✎ 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
3802004 1958523 1958523 defendant Seley William husbandman 631668 631668 Seley, William, of North Currey, husbandman 0
3832489 1968082 1968082 defendant Hobs Walter smith 631668 631668 Hobs, Walter, of North Currey, smith 2
3999577 2024615 2024615 defendant Bere William tailor 631668 631668 Bere, William, of North Currey, tailor 0
4039350 2038700 2038700 plaintiff Lyte John gent 631668 631668 Lyte, John, of North Currey, gent 0
4046898 2041345 2041345 defendant Verior Nicholas yeoman 631668 631668 Verior, Nicholas, of North Currey, yeoman 0
4069575 2049400 2049400 defendant Beasley George husbandman 631668 631668 Beasley, George, of North Currey, or of Mourdon, husbandman 0
4070573 2049769 2049769 defendant Foster John husbandman 631668 631668 Foster, John, of North Currey, husbandman 0
4077282 2052158 2052158 defendant Verior Nicholas yeoman 631668 631668 Verior, Nicholas, of North Currey, yeoman 0
4088623 2056232 2056232 defendant Celey William husbandman 631668 631668 Celey, William, of North Currey, or of Lillesdon, husbandman 1
4089447 2056512 2056512 defendant Gyll Thomas butcher 631668 631668 Gyll, Thomas, of North Currey, butcher 0
4089448 2056512 2056512 defendant Boby alias Herne John weaver 631668 631668 Boby alias Herne, John, of North Currey, weaver 1
4089449 2056512 2056512 defendant Newman Thomas husbandman 631668 631668 Newman, Thomas, of North Currey, husbandman 2
4093429 2057967 2057967 defendant Stacye William yeoman 631668 631668 Stacye, William, of North Currey, yeoman 0
4096273 2058997 2058997 defendant Nurton or Norton Walter husbandman 631668 631668 Nurton or Norton, Walter, of North Currey, husbandman 1
4126065 2069608 2069608 defendant Besley or Bestlye Robert husbandman 631668 631668 Besley or Bestlye, Robert, of North Currey, husbandman 0
4134537 2072683 2072683 defendant Mudge William husbandman 631668 631668 Mudge, William, of North Currey, husbandman 0
4134541 2072684 2072684 defendant Mudge William husbandman 631668 631668 Mudge, William, of North Currey, husbandman 0
4134542 2072684 2072684 defendant Mudge Nicholas yeoman 631668 631668 Mudge, Nicholas, of North Currey, yeoman 1
4134543 2072684 2072684 defendant Besley Robert husbandman 631668 631668 Besley, Robert, of North Currey, husbandman 2
4147929 2077409 2077409 defendant Lyte John gent 631668 631668 Lyte, John, of North Currey, gent 2
4158072 2080892 2080892 defendant Foster William husbandman 631668 631668 Foster, William, of North Currey, husbandman 0
4158073 2080892 2080892 defendant Halsewell Robert husbandman 631668 631668 Halsewell, Robert, of North Currey, husbandman 1
4170889 2085306 2085306 defendant Mudge Richard husbandman 631668 631668 Mudge, Richard, of North Currey, husbandman 1
4203266 2096688 2096688 defendant Lyder Simon husbandman 631668 631668 Lyder, Simon, of North Currey, husbandman 1
4203268 2096688 2096688 defendant Gent Walter weaver 631668 631668 Gent, Walter, of North Currey, weaver 3
4208575 2098548 2098548 defendant Rowswell George butcher 631668 631668 Rowswell, George, of North Currey, butcher 3
4219074 2102167 2102167 defendant Bacon Grace widow 631668 631668 Bacon, Grace, of North Currey, widow 1
4219075 2102167 2102167 defendant Walter John tailor 631668 631668 Walter, John, of North Currey, tailor 2
4219076 2102167 2102167 defendant Stacye John weaver 631668 631668 Stacye, John, of North Currey, weaver 3
4224994 2104211 2104211 defendant Morse John gent 631668 631668 Morse, John, of North Currey, gent 0
4228761 2105544 2105544 defendant Lyder William husbandman 631668 631668 Lyder, William, of North Currey, husbandman 0
4241760 2110231 2110231 defendant Morsse John gent 631668 631668 Morsse, John, of North Currey, gent 0
4258175 2115709 2115709 defendant Lyder William husbandman 631668 631668 Lyder, William, of North Currey, husbandman 0
4284075 2124349 2124349 defendant Bruer Gabriel husbandman 631668 631668 Bruer, Gabriel, of North Currey, husbandman 0
4284076 2124349 2124349 defendant Leake Thomas husbandman 631668 631668 Leake, Thomas, of North Currey, husbandman 1
4284077 2124349 2124349 defendant Everye Gregory husbandman 631668 631668 Everye, Gregory, of North Currey, husbandman 2
4285026 2124693 2124693 defendant Lider William husbandman 631668 631668 Lider, William, of North Currey, husbandman 3
4285099 2124722 2124722 defendant Collens John husbandman 631668 631668 Collens, John, of North Currey, husbandman 0
4291816 2127150 2127150 defendant Lyder Simon husbandman 631668 631668 Lyder, Simon, of North Currey, husbandman 0
4291817 2127150 2127150 defendant Lyte John gent 631668 631668 Lyte, John, of North Currey, gent 1
4291818 2127150 2127150 defendant Hobbes Richard yeoman 631668 631668 Hobbes, Richard, of North Currey, yeoman 2
4303333 2131293 2131293 defendant Lyder William husbandman 631668 631668 Lyder, William, of North Currey, husbandman 1
4312342 2134453 2134453 defendant Ceeley John husbandman 631668 631668 Ceeley, John, of North Currey, husbandman 0
4354772 2148889 2148889 defendant Webber Lawrence butcher 631668 631668 Webber, Lawrence, of North Currey, butcher 0
4359100 2150417 2150417 defendant Knyghte John husbandman 631668 631668 Knyghte, John, of North Currey, husbandman 0
4362199 2151526 2151526 defendant Wynter Ezechial yeoman 631668 631668 Wynter, Ezechial, of North Currey, yeoman 0
4368205 2153680 2153680 defendant Webber Lawrence butcher 631668 631668 Webber, Lawrence, of North Currey, butcher 2
4380155 2158006 2158006 defendant Webber Lawrence butcher 631668 631668 Webber, Lawrence, of North Currey, butcher 1
4381341 2158438 2158438 defendant Webber Lawrence butcher 631668 631668 Webber, Lawrence, of North Currey, butcher 3
4389761 2161198 2161198 defendant Rogers John yeoman 631668 631668 Rogers, John, of North Currey, yeoman 2
4407108 2166939 2166939 defendant Vitterner George husbandman 631668 631668 Vitterner, George, of North Currey, husbandman 2

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