names

51 rows where place_id = 596708

✎ 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
3625846 1875617 1875617 defendant Colryk William innholder 596708 596708 Colryk, William, of Chepyng Barnet, Herts, innholder 2
3646230 1909213 1909213 defendant Olyvaunt Roger collier 596708 596708 Olyvaunt, Roger, of Chepyng Barnet, Herts, collier 4
3654253 1911590 1911590 defendant Migholl William laborer 596708 596708 Migholl, William, of Chepyng Barnet, Herts, laborer 0
3697202 1925345 1925345 defendant Edwardys William butcher 596708 596708 Edwardys, William, of Chepyng Barnet, Herts, butcher 0
3698167 1925654 1925654 defendant Edwardys William butcher 596708 596708 Edwardys, William, of Chepyng Barnet, Herts, butcher 0
3698180 1925657 1925657 defendant Edwardes William butcher 596708 596708 Edwardes, William, of Chepyng Barnet, Herts, butcher 4
3700697 1926468 1926468 defendant Mychell Robert baker 596708 596708 Mychell, Robert, of Chepyng Barnet, Herts, baker 0
3700699 1926469 1926469 defendant Mychell Robert baker 596708 596708 Mychell, Robert, of Chepyng Barnet, Herts, or of Aulton, baker 0
3705945 1928146 1928146 defendant Salford William gent 596708 596708 Salford, William, of Chepyng Barnet, Herts, gent 0
3769929 1948252 1948252 defendant Edwardes William butcher 596708 596708 Edwardes, William, of Chepyng Barnet, Herts, butcher 0
4977952 2350369 2350369 defendant Hardwyn William maltman 596708 596708 Hardwyn, William, of Chepyng Barnet, Herts, maltman 0
5118080 2391721 2391721 defendant Heron John husbandman 596708 596708 Heron, John, of Chepyng Barnet, Herts, husbandman 0
5130016 2395264 2395264 defendant Hardewyn William (legal representative) 596708 596708 Hardewyn, William, of Chepyng Barnet, Herts, yeoman & maltman, executors of 0
5141548 2398641 2398641 defendant Penycombe John barber 596708 596708 Penycombe, John, of Chepyng Barnet, Herts, barber 9
5141556 2398642 2398642 defendant Penycombe John barber 596708 596708 Penycombe, John, of Chepyng Barnet, Herts, barber 6
5217827 2420945 2420945 defendant Doveland or Doneland Robert yeoman 596708 596708 Doveland or Doneland, Robert, of Chepyng Barnet, Herts, yeoman 0
5218654 2421183 2421183 defendant Warde Walter   596708 596708 Warde, Walter, of Chepyng Barnet, Herts, coal burner 1
5247074 2429303 2429303 defendant Haksalt Thomas (legal representative) 596708 596708 Haksalt, Thomas, of Chepyng Barnet, Herts, administrator of 5
5247082 2429304 2429304 defendant Haksalt Thomas (legal representative) 596708 596708 Haksalt, Thomas, of Chepyng Barnet, Herts, administratrix of 5
5263764 2434420 2434420 defendant Godfrey John maltman 596708 596708 Godfrey, John, of Chepyng Barnet, Herts, maltman 0
5264580 2434673 2434673 defendant Kyrkham John ostler 596708 596708 Kyrkham, John, of Chepyng Barnet, Herts, ostler 0
5274716 2437682 2437682 defendant Godfrey John maltman 596708 596708 Godfrey, John, of Chepyng Barnet, Herts, maltman 0
5276065 2438073 2438073 defendant Banwell Richard yeoman 596708 596708 Banwell, Richard, of Chepyng Barnet, Herts, yeoman 0
5296248 2443892 2443892 defendant Hardyng Thomas husbandman 596708 596708 Hardyng, Thomas, of Chepyng Barnet, Herts, husbandman 1
5326950 2453134 2453134 plaintiff Taylour Henry yeoman 596708 596708 Taylour, Henry, of Chepyng Barnet, Herts, yeoman 0
5326953 2453135 2453135 plaintiff Taylour Henry yeoman 596708 596708 Taylour, Henry, of Chepyng Barnet, Herts, yeoman 0
5333489 2455089 2455089 defendant Meryden Richard collier 596708 596708 Meryden, Richard, of Chepyng Barnet, Herts, collier 1
5351677 2460624 2460624 defendant Rolfe Thomas collier or yeoman 596708 596708 Rolfe, Thomas, of Chepyng Barnet, Herts, collier or yeoman 0
5380690 2469525 2469525 defendant Taillour Henry gent 596708 596708 Taillour, Henry, of Chepyng Barnet, Herts, gent 0
5380691 2469525 2469525 defendant Barbour Henry yeoman 596708 596708 Barbour, Henry, of Chepyng Barnet, Herts, yeoman 1
5385725 2470989 2470989 defendant Taillour Henry gent 596708 596708 Taillour, Henry, of Chepyng Barnet, Herts, gent 0
5397923 2474480 2474480 defendant Taylour Henry gent 596708 596708 Taylour, Henry, of Chepyng Barnet, Herts, gent 0
5466798 2495019 2495019 defendant Hewet Henry maltman 596708 596708 Hewet, Henry, of Chepyng Barnet, Herts, maltman 0
5480686 2499187 2499187 plaintiff Deyer Thomas maltman 596708 596708 Deyer, Thomas, of Chepyng Barnet, Herts, maltman 0
5480690 2499188 2499188 plaintiff Deyer Thomas maltman 596708 596708 Deyer, Thomas, of Chepyng Barnet, Herts, maltman 0
5490134 2501931 2501931 defendant West Edmund yeoman 596708 596708 West, Edmund, of Chepyng Barnet, Herts, yeoman 0
5496437 2503844 2503844 defendant West Edmund innholder 596708 596708 West, Edmund, of Chepyng Barnet, Herts, innholder 1
5496669 2503922 2503922 defendant Smyth John   596708 596708 Smyth, John, of Chepyng Barnet, Herts, wheelwright 0
5499105 2504673 2504673 defendant Taylour Ellen widow 596708 596708 Taylour, Ellen, of Chepyng Barnet, Herts, widow 0
5502258 2505630 2505630 defendant Ratclyffe James gent 596708 596708 Ratclyffe, James, of Chepyng Barnet, Herts, gent 0
5510574 2508144 2508144 defendant Hewet Henry innholder 596708 596708 Hewet, Henry, of Chepyng Barnet, Herts, innholder 0
5510578 2508145 2508145 defendant Hewet Henry innholder 596708 596708 Hewet, Henry, of Chepyng Barnet, Herts, innholder 0
5512181 2508673 2508673 defendant Smyth John, senior   596708 596708 Smyth, John, senior, of Chepyng Barnet, Herts, wheelwright 0
5512956 2508904 2508904 defendant West Edmund innholder 596708 596708 West, Edmund, of Chepyng Barnet, Herts, innholder 0
5513688 2509133 2509133 defendant Taylour Ellen widow 596708 596708 Taylour, Ellen, of Chepyng Barnet, Herts, widow 0
5515760 2509775 2509775 defendant Wylson Robert smith 596708 596708 Wylson, Robert, of Chepyng Barnet, Herts, smith 0
5535223 2515544 2515544 defendant Whyte Thomas laborer 596708 596708 Whyte, Thomas, of Chepyng Barnet, Herts, laborer 4
5570727 2525998 2525998 defendant Mauntfeld Henry butcher 596708 596708 Mauntfeld, Henry, of Chepyng Barnet, Herts, butcher 0
5579127 2528544 2528544 defendant Baryngton William yeoman 596708 596708 Baryngton, William, of Chepyng Barnet, Herts, yeoman 0
5580726 2529052 2529052 defendant Rolfe William fisher 596708 596708 Rolfe, William, of Chepyng Barnet, Herts, fisher 1
5583444 2529892 2529892 defendant Daryngton William innholder 596708 596708 Daryngton, William, of Chepyng Barnet, Herts, innholder 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);