names

37 rows where place_id = 599445

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636804 1906301 1906301 defendant Day John husbandman 599445 599445 Day, John, of Milbroke, husbandman 1
3678340 1919279 1919279 defendant Morton Ralph husbandman 599445 599445 Morton, Ralph, of Milbroke, husbandman 0
3680240 1919891 1919891 defendant Harry John   599445 599445 Harry, John, of Milbroke, "fyssheioter" 3
3700966 1926551 1926551 defendant Whyte Thomas yeoman 599445 599445 Whyte, Thomas, of Milbroke, yeoman 0
3707010 1928477 1928477 defendant Watson Richard tanner 599445 599445 Watson, Richard, of Milbroke, tanner 0
3859291 1976600 1976600 defendant Tele William husbandman 599445 599445 Tele, William, of Milbroke, husbandman 0
3859292 1976600 1976600 defendant Brode Thomas tailor 599445 599445 Brode, Thomas, of Milbroke, tailor 1
3859293 1976600 1976600 defendant Lyllyngston Thomas husbandman 599445 599445 Lyllyngston, Thomas, of Milbroke, husbandman 2
3859294 1976600 1976600 defendant Lyllyngston George husbandman 599445 599445 Lyllyngston, George, of Milbroke, husbandman 3
3859295 1976600 1976600 defendant Fowle William laborer 599445 599445 Fowle, William, of Milbroke, laborer 4
3859296 1976600 1976600 defendant Mascall Thomas husbandman 599445 599445 Mascall, Thomas, of Milbroke, husbandman 5
3859297 1976600 1976600 defendant Eton Thomas husbandman 599445 599445 Eton, Thomas, of Milbroke, husbandman 6
3859298 1976600 1976600 defendant Eton William laborer 599445 599445 Eton, William, of Milbroke, laborer 7
3859299 1976600 1976600 defendant Ball William warrener 599445 599445 Ball, William, of Milbroke, warrener 8
3862632 1977697 1977697 defendant Kyrke William yeoman 599445 599445 Kyrke, William, of Milbroke, yeoman 0
3985115 2019428 2019428 defendant Rowe Richard mariner 599445 599445 Rowe, Richard, of Milbroke, mariner 0
4091045 2057086 2057086 defendant Sendye William merchant 599445 599445 Sendye, William, of Milbroke, gent, son of Lawrence Sendye, of Milbroke, merchant 0
4178358 2087904 2087904 defendant Goyte John yeoman 599445 599445 Goyte, John, of Milbroke, yeoman 0
4457767 2187443 2187443 defendant Castre John   599445 599445 Castre, John, of Milbroke 0
4881021 2320975 2320975 defendant Mylleward William   599445 599445 Mylleward, William, of Milbroke, millward 0
5015168 2361325 2361325 defendant Grubbe Roger   599445 599445 Grubbe, Roger, of Milbroke, millward 0
5015169 2361325 2361325 defendant Grubbe Thomas fletcher 599445 599445 Grubbe, Thomas, of Milbroke, fletcher 1
5062033 2375202 2375202 defendant Hoper John husbandman 599445 599445 Hoper, John, of Milbroke, husbandman 1
5063503 2375608 2375608 defendant Hoper John husbandman 599445 599445 Hoper, John, of Milbroke, husbandman 1
5147249 2400337 2400337 defendant Cokkes Richard husbandman 599445 599445 Cokkes, Richard, of Milbroke, husbandman 2
5147253 2400338 2400338 defendant Cokkes Richard husbandman 599445 599445 Cokkes, Richard, of Milbroke, husbandman 2
5167026 2406089 2406089 defendant Cokkes Richard husbandman 599445 599445 Cokkes, Richard, of Milbroke, husbandman 2
5277832 2438601 2438601 defendant Carter Edmund husbandman 599445 599445 Carter, Edmund, of Milbroke, husbandman 0
5277833 2438601 2438601 defendant Gervel or Gernel John husbandman 599445 599445 Gervel or Gernel, John, of Milbroke, husbandman 1
5290181 2442131 2442131 defendant Borewe or Borough Richard dyer 599445 599445 Borewe or Borough, Richard, of Milbroke, dyer 1
5501925 2505526 2505526 defendant Carter Edmund husbandman 599445 599445 Carter, Edmund, of Milbroke, husbandman 0
5542613 2517812 2517812 defendant Russell John, senior husbandman 599445 599445 Russell, John, senior, of Milbroke, husbandman 0
5542617 2517813 2517813 defendant Russell John, senior husbandman 599445 599445 Russell, John, senior, of Milbroke, husbandman 0
5546807 2519071 2519071 defendant Garland John yeoman 599445 599445 Garland, John, of Milbroke, yeoman 0
5546816 2519072 2519072 defendant Garland John yeoman 599445 599445 Garland, John, of Milbroke, yeoman 2
5550530 2520178 2520178 defendant Torre Richard miller 599445 599445 Torre, Richard, of Milbroke, miller 0
5559540 2522750 2522750 defendant Bukket Thomas husbandman 599445 599445 Bukket, Thomas, of Milbroke, 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);