names

37 rows where place_id = 613558

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3699034 1925905 1925905 defendant Watman William yeoman 613558 613558 Watman, William, of Hesill, yeoman 0
3823228 1965178 1965178 defendant Bell Thomas chaplain 613558 613558 Bell, Thomas, of Hesill, chaplain 0
4077050 2052077 2052077 defendant Bradford Thomas gent 613558 613558 Bradford, Thomas, of Hesill, gent 0
4459767 2188107 2188107 defendant Marsshall John chaplain 613558 613558 Marsshall, John, of Hesill, chaplain 0
4464547 2189580 2189580 defendant Preston Thomas de   613558 613558 Preston, Thomas de, of Hesill 0
4467365 2190471 2190471 defendant Waghen William de   613558 613558 Waghen, William de, of Hesill 2
4523528 2207683 2207683 defendant Bate Thomas   613558 613558 Bate, Thomas, of Hesill 0
4544200 2214102 2214102 plaintiff Dest Robert   613558 613558 Dest, Robert, of Hesill 1
4564831 2220567 2220567 defendant Milner Ralph   613558 613558 Milner, Ralph, of Hesill 2
4580491 2225385 2225385 plaintiff Deft Robert   613558 613558 Deft, Robert, of Hesill 0
4582822 2226061 2226061 defendant Stepheneson William   613558 613558 Stepheneson, William, of Hesill, shepherd 0
4584249 2226484 2226484 plaintiff Giliot John   613558 613558 Giliot, John, of Hesill 0
4584251 2226485 2226485 plaintiff Giliot John   613558 613558 Giliot, John, of Hesill 0
4608154 2233662 2233662 defendant Deste Robert   613558 613558 Deste, Robert, of Hesill 0
4614387 2235508 2235508 defendant Bustard Robert   613558 613558 Bustard, Robert, of Hesill 1
4621056 2237570 2237570 defendant Steryng John shoemaker 613558 613558 Steryng, John, of Hesill on Humber, shoemaker 0
4623836 2238430 2238430 defendant Dest Robert   613558 613558 Dest, Robert, of Hesill 0
4654115 2247169 2247169 plaintiff Bilton John   613558 613558 Bilton, John, of Hesill 0
4665333 2250647 2250647 defendant Gyliot John yeoman 613558 613558 Gyliot, John, of Hesill, yeoman 0
4697996 2264864 2264864 defendant Flaker Robert shipman 613558 613558 Flaker, Robert, of Hesill, shipman 0
4873194 2318568 2318568 plaintiff Payntour John   613558 613558 Payntour, John, of Hesill 0
4874288 2318902 2318902 defendant Dest or Deft Robert yeoman 613558 613558 Dest or Deft, Robert, of Hesill, yeoman 1
4924929 2334226 2334226 defendant Heryng Henry husbandman 613558 613558 Heryng, Henry, of Hesill, husbandman 2
4927511 2335041 2335041 defendant Salcok John tailor 613558 613558 Salcok, John, of Hesill, tailor 1
5152361 2401824 2401824 defendant Lyolff William husbandman 613558 613558 Lyolff, William, of Hesill, husbandman 0
5152362 2401824 2401824 defendant Raweson Thomas laborer 613558 613558 Raweson, Thomas, of Hesill, laborer 1
5152364 2401824 2401824 defendant Fereby John laborer 613558 613558 Fereby, John, of Hesill, laborer 3
5200957 2416044 2416044 defendant Cisson Thomas husbandman 613558 613558 Cisson, Thomas, of Hesill, husbandman 0
5200958 2416044 2416044 defendant Grene John husbandman 613558 613558 Grene, John, of Hesill, husbandman 1
5201029 2416056 2416056 defendant Harwod John chaplain & vicar 613558 613558 Harwod, John, of Hesill, chaplain & vicar 1
5201030 2416056 2416056 defendant Cornwall Thomas husbandman 613558 613558 Cornwall, Thomas, of Hesill, husbandman 2
5220186 2421604 2421604 defendant Welton John shipman 613558 613558 Welton, John, of Hesill, shipman 4
5256863 2432276 2432276 defendant Clerke James husbandman 613558 613558 Clerke, James, of Hesill, husbandman 0
5256864 2432276 2432276 defendant Wodde Thomas laborer 613558 613558 Wodde, Thomas, of Hesill, laborer 1
5256865 2432276 2432276 defendant Blasset Robert yeoman 613558 613558 Blasset, Robert, of Hesill, yeoman 2
5256866 2432276 2432276 defendant Geffreyson Robert butcher 613558 613558 Geffreyson, Robert, of Hesill, butcher 3
5522741 2511940 2511940 defendant Breray James husbandman 613558 613558 Breray, James, of Hesill, husbandman 2

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);