names

38 rows where place_id = 641624

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3862786 1977746 1977746 plaintiff Tompson Richard   641624 641624 (Tompson, Richard, of Aylisham 1
3862788 1977746 1977746 defendant Bone alias Boon Henry yeoman 641624 641624 Bone alias Boon, Henry, of Aylisham, yeoman 0
3862790 1977747 1977747 plaintiff Tompson Richard   641624 641624 (Tompson, Richard, of Aylisham 1
3862792 1977747 1977747 defendant Wythe John, senior   641624 641624 Wythe, John, senior, of Aylisham, worsted weaver 0
3871842 1980820 1980820 defendant Boon Henry yeoman 641624 641624 Boon, Henry, of Aylisham, yeoman 0
3876961 1982535 1982535 plaintiff Hawkyns Robert (legal representative) 641624 641624 Hawkyns, Robert, of Aylisham, executors of 0
3876962 1982535 1982535 plaintiff Tompson Richard   641624 641624 (Tompson, Richard, of Aylisham 1
3876964 1982535 1982535 defendant Boon Henry yeoman 641624 641624 Boon, Henry, of Aylisham, yeoman 0
3918257 1996440 1996440 defendant Bettys John shoemaker 641624 641624 Bettys, John, of Aylisham, shoemaker 0
3918258 1996440 1996440 defendant Cresy Simon engraver 641624 641624 Cresy, Simon, of Aylisham, engraver 1
3918259 1996440 1996440 defendant Cook John sherman 641624 641624 Cook, John, of Aylisham, sherman 2
3946305 2005782 2005782 defendant Jagg John mercer 641624 641624 Jagg, John, of Aylisham, mercer 1
3946308 2005783 2005783 defendant Jagg John mercer 641624 641624 Jagg, John, of Aylisham, mercer 1
3975372 2015952 2015952 defendant Spryngold William butcher 641624 641624 Spryngold, William, of Aylisham, butcher 0
3979713 2017498 2017498 plaintiff Orwell Thomas   641624 641624 Orwell, Thomas, of Aylisham 0
3979715 2017498 2017498 defendant Crowe Maurice husbandman 641624 641624 Crowe, Maurice, of Aylisham, husbandman 1
3979717 2017499 2017499 defendant Ball Edmund yeoman 641624 641624 Ball, Edmund, of Aylisham, yeoman 0
3997583 2023883 2023883 defendant Johnson Henry mercer 641624 641624 Johnson, Henry, of Aylisham, mercer 0
4012970 2029371 2029371 defendant Taylor alias Hollande John husbandman 641624 641624 Taylor alias Hollande, John, of Aylisham, husbandman 0
4013654 2029620 2029620 plaintiff Rumpe Thomas yeoman 641624 641624 Rumpe, Thomas, of Aylisham, yeoman 0
4015059 2030076 2030076 defendant Crede alias Taylor George thatcher 641624 641624 Crede alias Taylor, George, of Aylisham, thatcher 10
4023240 2033020 2033020 plaintiff Barker Alice   641624 641624 Barker, Alice, of Aylisham, widow, administrators of 0
4026800 2034232 2034232 defendant Barker Robert   641624 641624 Barker, Robert, of Aylisham, linen draper 0
4026803 2034233 2034233 defendant Barker Robert   641624 641624 Barker, Robert, of Aylisham, linen draper 0
4030392 2035523 2035523 defendant Johnson Henry mercer 641624 641624 Johnson, Henry, of Aylisham, mercer 0
4038535 2038421 2038421 defendant Woodward John yeoman 641624 641624 Woodward, John, of Aylisham, yeoman 0
4041965 2039615 2039615 defendant Marshall Thomas husbandman 641624 641624 Marshall, Thomas, of Aylisham, husbandman 1
4048516 2041921 2041921 defendant Taylor alias Hollyns John husbandman 641624 641624 Taylor alias Hollyns, John, of Aylisham, husbandman 2
4086670 2055521 2055521 defendant Smyth Thomas miller 641624 641624 Smyth, Thomas, of Aylisham, miller 1
4088822 2056303 2056303 defendant Sherwood Ralph yeoman 641624 641624 Sherwood, Ralph, of Aylisham, yeoman 1
4285978 2125040 2125040 defendant Wisiter James comber 641624 641624 Wisiter, James, of Aylisham, comber 1
4329251 2140096 2140096 defendant Wylson William yeoman 641624 641624 Wylson, William, of Aylisham, yeoman 0
4517856 2205969 2205969 defendant Kapon William smith 641624 641624 Kapon, William, of Aylisham, smith 1
4885083 2322227 2322227 defendant Goldston Robert miller 641624 641624 Goldston, Robert, of Aylisham, miller 0
5337686 2456344 2456344 defendant Fyssher Thomas husbandman 641624 641624 Fyssher, Thomas, of Aylisham, husbandman 3
5337687 2456344 2456344 defendant Fyssher Robert husbandman 641624 641624 Fyssher, Robert, of Aylisham, husbandman 4
5355024 2461640 2461640 defendant Skyppyng Thomas yeoman 641624 641624 Skyppyng, Thomas, of Aylisham, yeoman 2
5398380 2474599 2474599 defendant Folbergh John   641624 641624 Folbergh, John, of Aylisham, shoe maker 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);