names

27 rows where place_id = 590364

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600819 1867919 1867919 defendant Alsebroke Henry carpenter 590364 590364 Alsebroke, Henry, of Criche, carpenter 0
4057516 2045065 2045065 plaintiff Butler William tanner 590364 590364 Butler, William, of Criche, tanner 0
4136468 2073384 2073384 defendant Seger Robert yeoman 590364 590364 Seger, Robert, of Criche, yeoman 0
4136469 2073384 2073384 defendant Rendell William husbandman 590364 590364 Rendell, William, of Criche, husbandman 1
4151230 2078552 2078552 defendant Haslame Anthony yeoman 590364 590364 Haslame, Anthony, of Criche, yeoman 1
4159920 2081537 2081537 defendant Adams Bartholomew   590364 590364 Adams, Bartholomew, of Criche, lead maker, administrators of 0
4199063 2095228 2095228 defendant Haslame Anthony yeoman 590364 590364 Haslame, Anthony, of Criche, yeoman 1
4203644 2096831 2096831 defendant Ball John, senior husbandman 590364 590364 Ball, John, senior, of Criche, husbandman 0
4203645 2096831 2096831 defendant Ball John husbandman 590364 590364 Ball, John, of Criche, husbandman 1
4230488 2106159 2106159 defendant Rodford Thomas husbandman 590364 590364 Rodford, Thomas, of Criche, husbandman 0
4239009 2109262 2109262 defendant Moggridge Walter husbandman 590364 590364 Moggridge, Walter, of Criche, husbandman 2
4249467 2112806 2112806 defendant Hellowe Christopher yeoman 590364 590364 Hellowe, Christopher, of Criche, yeoman 0
4380252 2158038 2158038 defendant Fowler Robert chapman 590364 590364 Fowler, Robert, of Criche, chapman 1
4601933 2231829 2231829 defendant Knyveton John   590364 590364 Knyveton, John, of Criche 1
4671963 2256875 2256875 defendant Mayson John husbandman 590364 590364 Mayson, John, of Criche, husbandman 2
4685496 2261059 2261059 defendant atte Water Alice widow 590364 590364 atte Water, Alice, of Criche, widow 0
4713709 2269609 2269609 defendant Assibrok Roger carpenter 590364 590364 Assibrok, Roger, of Criche, carpenter 2
4742886 2278428 2278428 defendant attte Wall Nicholas yeoman 590364 590364 attte Wall, Nicholas, of Criche, yeoman 2
4839684 2308326 2308326 defendant Wylcokkes John husbandman 590364 590364 Wylcokkes, John, of Criche, husbandman 0
4839685 2308326 2308326 defendant Broke John husbandman 590364 590364 Broke, John, of Criche, husbandman 1
4839686 2308326 2308326 defendant Richard William husbandman 590364 590364 Richard, William, of Criche, husbandman 2
4954500 2343312 2343312 defendant Mason Robert laborer 590364 590364 Mason, Robert, of Criche, laborer 0
4975010 2349501 2349501 plaintiff More John brewer 590364 590364 More, John, of Criche, brewer 0
5276634 2438246 2438246 plaintiff Woderose William   590364 590364 Woderose, William, of Criche, warden of the chantry of Sts Nicholas & Katherine, within the parish church 0
5530372 2514011 2514011 defendant Marshall Robert husbandman 590364 590364 Marshall, Robert, of Criche, husbandman 0
5606969 2537072 2537072 defendant Wylde William yeoman 590364 590364 Wylde, William, of Criche, yeoman 2
5606970 2537072 2537072 defendant Radford James yeoman 590364 590364 Radford, James, of Criche, yeoman 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);