names

52 rows where place_id = 588346

✎ 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
3594174 1865820 1865820 defendant Aulaby Peter gent 588346 588346 Aulaby, Peter, of Hesyll, gent 0
3594175 1865820 1865820 defendant Aulaby Nicholas gent 588346 588346 Aulaby, Nicholas, of Hesyll, gent 1
3618192 1873314 1873314 defendant Wellis Isabel widow 588346 588346 Wellis, Isabel, of Hesyll, widow 0
3686665 1921984 1921984 defendant Dey Richard husbandman 588346 588346 Dey, Richard, of Hesyll, husbandman 0
3701763 1926798 1926798 defendant Dey Richard husbandman 588346 588346 Dey, Richard, of Hesyll, husbandman 0
4340112 2143805 2143805 defendant Constable William esq 588346 588346 Constable, William, of Hesyll, esq 2
4642894 2244033 2244033 defendant Gylyot John   588346 588346 Gylyot, John, of Hesyll 0
4642895 2244033 2244033 defendant Defe Robert   588346 588346 Defe, Robert, of Hesyll 1
4685454 2261047 2261047 defendant Best Robert husbandman 588346 588346 Best, Robert, of Hesyll, husbandman 3
4739880 2277549 2277549 defendant Bocher John butcher 588346 588346 Bocher, John, of Hesyll, butcher 0
4739881 2277549 2277549 defendant Grene William laborer 588346 588346 Grene, William, of Hesyll, laborer 1
4752269 2281129 2281129 defendant Deste Robert yeoman 588346 588346 Deste, Robert, of Hesyll, yeoman 2
4773237 2287597 2287597 defendant Clerk John   588346 588346 Clerk, John, of Hesyll, parish clerk 3
4854463 2312788 2312788 defendant Walthewe John husbandman 588346 588346 Walthewe, John, of Hesyll, husbandman 4
4873214 2318574 2318574 defendant Preston John, junior husbandman 588346 588346 Preston, John, junior, of Hesyll, husbandman 0
4927949 2335172 2335172 defendant Lordewyn John ostler 588346 588346 Lordewyn, John, of Hesyll upon Humber, ostler 4
4954313 2343261 2343261 defendant Deste Robert husbandman 588346 588346 Deste, Robert, of Hesyll on Humber, husbandman 1
4954314 2343261 2343261 defendant Heryng John husbandman 588346 588346 Heryng, John, of Hesyll on Humber, husbandman 2
4973787 2349117 2349117 defendant Robelot Robert yeoman 588346 588346 Robelot, Robert, of Hesyll, yeoman 0
4973788 2349117 2349117 defendant Osan Robert husbandman 588346 588346 Osan, Robert, of Hesyll, husbandman 1
4973789 2349117 2349117 defendant Cornewwayll Robert husbandman 588346 588346 Cornewwayll, Robert, of Hesyll, husbandman 2
4973790 2349117 2349117 defendant Taillour Thomas husbandman 588346 588346 Taillour, Thomas, of Hesyll, husbandman 3
4988691 2353575 2353575 plaintiff Breton William   588346 588346 Breton, William, of Hesyll 0
4997493 2356102 2356102 plaintiff Hobilthorn John   588346 588346 Hobilthorn, John, of Hesyll 0
4997494 2356102 2356102 defendant Bredan William husbandman 588346 588346 Bredan, William, of Hesyll on Humber, husbandman 0
4998421 2356405 2356405 defendant Byrkyn William   588346 588346 Byrkyn, William, of Hesyll, franklin 0
5012445 2360490 2360490 defendant Legeard Peter husbandman 588346 588346 Legeard, Peter, of Hesyll, husbandman 4
5052106 2372244 2372244 defendant Defte Robert husbandman 588346 588346 Defte, Robert, of Hesyll on Humber, husbandman 1
5052107 2372244 2372244 defendant Heryng John husbandman 588346 588346 Heryng, John, of Hesyll, husbandman 2
5132564 2396020 2396020 defendant Lyolff William husbandman 588346 588346 Lyolff, William, of Hesyll, husbandman 0
5132565 2396020 2396020 defendant Raweson Thomas laborer 588346 588346 Raweson, Thomas, of Hesyll, laborer 1
5132567 2396020 2396020 defendant Fereby John laborer 588346 588346 Fereby, John, of Hesyll, laborer 3
5170171 2407006 2407006 defendant Lyolff William husbandman 588346 588346 Lyolff, William, of Hesyll, husbandman 0
5170172 2407006 2407006 defendant Raweson Thomas laborer 588346 588346 together with Raweson, Thomas, of Hesyll, laborer 1
5170174 2407006 2407006 defendant Fereby John laborer 588346 588346 Fereby, John, of Hesyll, laborer 3
5170176 2407007 2407007 defendant Raweson Thomas laborer 588346 588346 Raweson, Thomas, of Hesyll, laborer 0
5170178 2407007 2407007 defendant Fereby John laborer 588346 588346 Fereby, John, of Hesyll, laborer 2
5170179 2407007 2407007 defendant Lyolff William husbandman 588346 588346 together with Lyolff, William, of Hesyll, husbandman 3
5264487 2434647 2434647 defendant Scot Edward husbandman 588346 588346 Scot, Edward, of Hesyll, husbandman 0
5264488 2434647 2434647 defendant Sysson Thomas husbandman 588346 588346 Sysson, Thomas, of Hesyll, husbandman 1
5264489 2434647 2434647 defendant Taillour William husbandman 588346 588346 Taillour, William, of Hesyll, husbandman 2
5264490 2434647 2434647 defendant Clerke James husbandman 588346 588346 Clerke, James, of Hesyll, husbandman 3
5264491 2434647 2434647 defendant Hameresley Richard husbandman 588346 588346 Hameresley, Richard, of Hesyll, husbandman 4
5264493 2434648 2434648 defendant Stot Edward husbandman 588346 588346 Stot, Edward, of Hesyll, husbandman 0
5264494 2434648 2434648 defendant Sysson Thomas husbandman 588346 588346 Sysson, Thomas, of Hesyll, husbandman 1
5264495 2434648 2434648 defendant Taillour William husbandman 588346 588346 Taillour, William, of Hesyll, husbandman 2
5264496 2434648 2434648 defendant Clerk James husbandman 588346 588346 Clerk, James, of Hesyll, husbandman 3
5264497 2434648 2434648 defendant Hameresley Richard husbandman 588346 588346 Hameresley, Richard, of Hesyll, husbandman 4
5298692 2444591 2444591 defendant Syggysworth Thomas barber 588346 588346 Syggysworth, Thomas, of Hesyll, barber 1
5346725 2459132 2459132 defendant Berkar Alice widow 588346 588346 Berkar, Alice, of Hesyll, widow 0
5346726 2459132 2459132 defendant Bocher John butcher 588346 588346 Bocher, John, of Hesyll, butcher 1
5577233 2527931 2527931 defendant Sisson John husbandman 588346 588346 Sisson, John, of Hesyll, 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);