names

51 rows where place_id = 603130

✎ 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
3606891 1869821 1869821 plaintiff Peygott John (legal representative) 603130 603130 Peygott, John, of Hallysworth, yeoman, executors of 0
3653210 1911339 1911339 defendant Barett Robert husbandman 603130 603130 Barett, Robert, of Hallysworth, husbandman 1
3676589 1918716 1918716 defendant Flykke Henry shoemaker 603130 603130 Flykke, Henry, of Hallysworth, shoemaker 3
3689771 1922957 1922957 plaintiff Flyk John   603130 603130 Flyk, John, of Hallysworth 0
3689772 1922957 1922957 defendant Arnold John cordwainer 603130 603130 Arnold, John, of Hallysworth, cordwainer 0
3700430 1926371 1926371 defendant Norton Walter yeoman 603130 603130 Norton, Walter, of Hallysworth, yeoman 1
3704343 1927660 1927660 defendant Sudborne Edmund husbandman 603130 603130 Sudborne, Edmund, of Hallysworth, husbandman 0
3736623 1937704 1937704 defendant Launce John mercer 603130 603130 Launce, John, of Hallysworth, mercer 1
3738922 1938379 1938379 plaintiff Norton Walter   603130 603130 Norton, Walter, of Hallysworth 0
3738923 1938379 1938379 plaintiff Fokelyng Thomas   603130 603130 Fokelyng, Thomas, of Hallysworth 1
3779630 1951359 1951359 defendant Bradley Christopher tanner 603130 603130 Bradley, Christopher, of Hallysworth, tanner 0
3788458 1954192 1954192 defendant Flyke John tanner 603130 603130 Flyke, John, of Hallysworth, tanner 0
3832823 1968193 1968193 plaintiff John Hugh (legal representative) 603130 603130 John, Hugh, of Hallysworth, yeoman, executors of 0
3832829 1968194 1968194 plaintiff John Hugh (legal representative) 603130 603130 John, Hugh, of Hallysworth, yeoman, executors of 0
3834723 1968795 1968795 plaintiff Norton Robert yeoman 603130 603130 Norton, Robert, of Hallysworth, yeoman 0
3849329 1973387 1973387 defendant Pekke Thomas husbandman 603130 603130 Pekke, Thomas, of Hallysworth, husbandman 0
3864074 1978168 1978168 defendant Flyke John tanner 603130 603130 Flyke, John, of Hallysworth, tanner 0
3878373 1983014 1983014 defendant Daldy John tanner 603130 603130 Daldy, John, of Hallysworth, tanner 0
3878374 1983014 1983014 defendant Hopton Edward butcher 603130 603130 Hopton, Edward, of Hallysworth, butcher 1
3886428 1985714 1985714 plaintiff Burgeys John sawyer 603130 603130 Burgeys, John, of Hallysworth, sawyer 0
3886430 1985714 1985714 defendant Daffy Robert plumber 603130 603130 Daffy, Robert, of Hallysworth, plumber 1
3887988 1986234 1986234 plaintiff Dawdy John   603130 603130 Dawdy, John, of Hallysworth 0
3898377 1989669 1989669 defendant Pekk Thomas merchant 603130 603130 Pekk, Thomas, of Hallysworth, merchant 1
3900309 1990336 1990336 plaintiff Burgeys John sawyer 603130 603130 Burgeys, John, of Hallysworth, sawyer 0
3900311 1990336 1990336 defendant Daffy Robert plumber 603130 603130 Daffy, Robert, of Hallysworth, plumber 1
3907129 1992676 1992676 plaintiff Norton Walter (legal representative) 603130 603130 Norton, Walter, of Hallysworth, executor of 0
3915598 1995584 1995584 defendant West William husbandman 603130 603130 West, William, of Hallysworth, husbandman 4
3924374 1998463 1998463 defendant Launce John mercer 603130 603130 Launce, John, of Hallysworth, mercer 0
3937346 2002826 2002826 defendant Smythe Nicholas mercer 603130 603130 Smythe, Nicholas, of Hallysworth, mercer 0
3937352 2002829 2002829 plaintiff Norton Robert gent 603130 603130 Norton, Robert, of Hallysworth, gent 0
3937891 2003006 2003006 defendant Applyard John laborer 603130 603130 Applyard, John, of Hallysworth, laborer 2
3943564 2004867 2004867 defendant Dawson John mercer 603130 603130 Dawson, John, of Hallysworth, mercer 0
3943566 2004868 2004868 defendant Dawson John mercer 603130 603130 Dawson, John, of Hallysworth, mercer 0
3951886 2007721 2007721 defendant Pryme John butcher 603130 603130 Pryme, John, of Hallysworth, butcher 0
3977539 2016714 2016714 defendant Pryme John butcher 603130 603130 Pryme, John, of Hallysworth, butcher 0
4002842 2025784 2025784 defendant Pryme John butcher 603130 603130 Pryme, John, of Hallysworth, butcher 0
4019143 2031586 2031586 defendant Baker Valentine tanner 603130 603130 Baker, Valentine, of Hallysworth, tanner 0
4019144 2031586 2031586 defendant Cryspe Nicholas glover 603130 603130 Cryspe, Nicholas, of Hallysworth, glover 1
4030153 2035429 2035429 defendant Borrett John husbandman 603130 603130 Borrett, John, of Hallysworth, husbandman 3
4038548 2038427 2038427 defendant Lyngwood Anthony yeoman 603130 603130 Lyngwood, Anthony, of Hallysworth, yeoman 0
4038549 2038427 2038427 defendant Waynflete John husbandman 603130 603130 Waynflete, John, of Hallysworth, husbandman 1
4038551 2038428 2038428 defendant Lyngwood Anthony yeoman 603130 603130 Lyngwood, Anthony, of Hallysworth, yeoman 0
4038552 2038428 2038428 defendant Waynflete John husbandman 603130 603130 Waynflete, John, of Hallysworth, husbandman 1
4060150 2046031 2046031 defendant Gurney Robert tanner 603130 603130 Gurney, Robert, of Hallysworth, tanner 1
4282098 2123640 2123640 defendant Browne Robert sherman 603130 603130 Browne, Robert, of Hallysworth, sherman 0
5034103 2366840 2366840 defendant Broke Richard mercer 603130 603130 Broke, Richard, of Hallysworth, mercer 0
5470421 2496074 2496074 defendant Goderich William butcher 603130 603130 Goderich, William, of Hallysworth, butcher 0
5481835 2499500 2499500 defendant Goderich William butcher 603130 603130 Goderich, William, of Hallysworth, butcher 0
5499591 2504823 2504823 defendant Storke Stephen yeoman 603130 603130 Storke, Stephen, of Hallysworth, yeoman 0
5541246 2517380 2517380 defendant Hewys Hugh yeoman 603130 603130 Hewys, Hugh, of Hallysworth, yeoman 8
5574994 2527262 2527262 defendant John Hugh yeoman 603130 603130 John, Hugh, of Hallysworth, yeoman 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);