names

37 rows where place_id = 589584

✎ 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
3598062 1867018 1867018 defendant Fuller Richard husbandman 589584 589584 Fuller, Richard, of Dychenyng, husbandman 0
3598064 1867019 1867019 defendant Fuller Richard husbandman 589584 589584 Fuller, Richard, of Dychenyng, husbandman 0
3819184 1963888 1963888 plaintiff Mychelburne John   589584 589584 Mychelburne, John, of Dychenyng 0
3850333 1973692 1973692 plaintiff Michelborne John   589584 589584 Michelborne, John, of Dychenyng 0
3850334 1973692 1973692 defendant Alchorn Thomas yeoman 589584 589584 Alchorn, Thomas, of Dychenyng, yeoman 0
3850702 1973810 1973810 plaintiff Mychelborne John   589584 589584 Mychelborne, John, of Dychenyng 0
3850703 1973810 1973810 defendant Alchorn Thomas yeoman 589584 589584 Alchorn, Thomas, of Dychenyng, yeoman 0
3856985 1975819 1975819 defendant Michelborne John yeoman 589584 589584 Michelborne, John, of Dychenyng, yeoman 0
3937798 2002973 2002973 plaintiff Parson Thomas tailor 589584 589584 Parson, Thomas, of Dychenyng, tailor 0
3947642 2006237 2006237 defendant Chelde Thomas mercer 589584 589584 Chelde, Thomas, of Dychenyng, mercer 1
3947645 2006238 2006238 defendant Chelde Thomas mercer 589584 589584 Chelde, Thomas, of Dychenyng, mercer 1
3952658 2007999 2007999 defendant Alchorne Thomas yeoman 589584 589584 Alchorne, Thomas, of Dychenyng, yeoman 2
4081206 2053586 2053586 defendant Pricket John yeoman 589584 589584 Pricket, John, of Dychenyng, yeoman 0
4115751 2065915 2065915 defendant Smythe Walter husbandman 589584 589584 Smythe, Walter, of Dychenyng, husbandman 0
4115752 2065915 2065915 defendant Underyll George butcher 589584 589584 Underyll, George, of Dychenyng, butcher 1
4129688 2070926 2070926 defendant Becher Henry mercer 589584 589584 Becher, Henry, of Dychenyng, mercer 0
4442203 2182489 2182489 defendant Betthelee John   589584 589584 Betthelee, John, of Dychenyng 0
4673428 2257328 2257328 plaintiff Cur Ralph (legal representative) 589584 589584 Cur, Ralph, of Dychenyng, diocese of Chichester, executors of 0
4678445 2258866 2258866 defendant Cur Walter husbandman 589584 589584 Cur, Walter, of Dychenyng, husbandman 0
4701290 2265804 2265804 defendant Curre Richard husbandman 589584 589584 (Curre, Richard, of Dychenyng, husbandman 1
4706041 2267263 2267263 defendant Birchere William husbandman 589584 589584 Birchere, William, of Dychenyng, husbandman 0
4706042 2267263 2267263 defendant Reynold Richard husbandman 589584 589584 Reynold, Richard, of Dychenyng, husbandman 1
4739714 2277497 2277497 defendant Cur Ralph laborer 589584 589584 Cur, Ralph, of Dychenyng, laborer 0
4760613 2283662 2283662 defendant Lawe John husbandman 589584 589584 Lawe, John, of Dychenyng, husbandman 0
4760615 2283662 2283662 defendant Petybon John tanner 589584 589584 Petybon, John, of Dychenyng, tanner 2
4842470 2309181 2309181 defendant Byrchyr Ralph tailor 589584 589584 Byrchyr, Ralph, of Dychenyng, tailor 0
4842471 2309181 2309181 defendant Byrcher William husbandman 589584 589584 Byrcher, William, of Dychenyng, husbandman 1
4842472 2309181 2309181 defendant Codyll John husbandman 589584 589584 Codyll, John, of Dychenyng, husbandman 2
4882361 2321395 2321395 defendant Crosby Thomas laborer 589584 589584 Crosby, Thomas, of Dychenyng, laborer 1
4906534 2328629 2328629 defendant Berd Walter forrester 589584 589584 Berd, Walter, of Dychenyng, forrester 0
4964586 2346314 2346314 defendant Berd John husbandman 589584 589584 Berd, John, of Dychenyng, husbandman 0
5107023 2388483 2388483 defendant Berde John yeoman 589584 589584 Berde, John, of Dychenyng, yeoman 0
5365745 2464943 2464943 defendant Maydewell Reginald weaver 589584 589584 Maydewell, Reginald, of Dychenyng, weaver 0
5386442 2471195 2471195 defendant Hurst Robert tanner 589584 589584 Hurst, Robert, of Dychenyng, tanner 3
5411850 2478497 2478497 defendant Hurst Robert tanner 589584 589584 Hurst, Robert, of Dychenyng, tanner 3
5411855 2478498 2478498 defendant Hurst Robert tanner 589584 589584 Hurst, Robert, of Dychenyng, tanner 3
5611849 2547442 2547442 defendant Betthele John   589584 589584 Betthele, John, of Dychenyng 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);