names

63 rows where place_id = 591211

✎ 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
3603719 1868833 1868833 defendant Barnarde John husbandman 591211 591211 Barnarde, John, of Sende, husbandman 1
3801341 1958348 1958348 defendant Kelsaye John yeoman 591211 591211 Kelsaye, John, of Sende, yeoman 1
3801344 1958348 1958348 defendant Lutman John husbandman 591211 591211 Lutman, John, of Sende, husbandman 4
3801345 1958348 1958348 defendant Gylys William husbandman 591211 591211 Gylys, William, of Sende, husbandman 5
3801346 1958348 1958348 defendant Alderton Richard husbandman 591211 591211 Alderton, Richard, of Sende, husbandman 6
3802824 1958778 1958778 defendant Lutman John yeoman 591211 591211 Lutman, John, of Sende, yeoman 0
3814109 1962315 1962315 defendant Stokys Robert, junior butcher 591211 591211 Stokys, Robert, junior, of Sende, butcher 0
3818834 1963796 1963796 defendant Kelsayd John yeoman 591211 591211 Kelsayd, John, of Sende, yeoman 1
3818837 1963796 1963796 defendant Lutman John husbandman 591211 591211 Lutman, John, of Sende, husbandman 4
3818838 1963796 1963796 defendant Gylys William husbandman 591211 591211 Gylys, William, of Sende, husbandman 5
3818839 1963796 1963796 defendant Alderton Richard husbandman 591211 591211 Alderton, Richard, of Sende, husbandman 6
4081078 2053545 2053545 defendant Dalmer Simon weaver 591211 591211 Dalmer, Simon, of Sende, weaver 1
4104766 2061980 2061980 defendant Usher Robert husbandman 591211 591211 Usher, Robert, of Sende, husbandman 2
4428857 2173828 2173828 plaintiff Thomas William   591211 591211 Thomas, William, of Sende 0
4428858 2173828 2173828 defendant Byde John   591211 591211 Byde, John, of Sende 0
4428859 2173828 2173828 defendant Colyns William   591211 591211 Colyns, William, of Sende 1
4442999 2182772 2182772 defendant Shephurd Walter   591211 591211 Shephurd, Walter, of Sende 1
4452324 2185715 2185715 defendant Maltere Walter fuller 591211 591211 Maltere, Walter, of Sende, fuller 0
4467814 2190613 2190613 defendant Herberd Walter   591211 591211 Herberd, Walter, of Sende 0
4471390 2191716 2191716 defendant Knyght Geoffrey   591211 591211 Knyght, Geoffrey, of Sende, administrators of 0
4519092 2206327 2206327 defendant Bryce Thomas   591211 591211 Bryce, Thomas, of Sende 1
4537706 2212068 2212068 defendant Knyght John   591211 591211 Knyght, John, of Sende 0
4611356 2234612 2234612 plaintiff Clerk William   591211 591211 Clerk, William, of Sende 0
4613526 2235249 2235249 defendant Bowyer John   591211 591211 Bowyer, John, of Sende 0
4617668 2236530 2236530 defendant Harryes John   591211 591211 Harryes, John, of Sende 5
4617669 2236530 2236530 defendant Chapman John   591211 591211 Chapman, John, of Sende 6
4617670 2236530 2236530 defendant Bustard John   591211 591211 Bustard, John, of Sende 7
4617671 2236530 2236530 defendant Golderyng John   591211 591211 Golderyng, John, of Sende 8
4621460 2237706 2237706 defendant Curteys Henry   591211 591211 Curteys, Henry, of Sende 0
4621461 2237706 2237706 defendant Curteys Robert   591211 591211 Curteys, Robert, of Sende 1
4621462 2237706 2237706 defendant Selves Walter   591211 591211 Selves, Walter, of Sende 2
4627560 2239552 2239552 defendant Hoper William   591211 591211 Hoper, William, of Sende 0
4627567 2239555 2239555 defendant Uphavene John   591211 591211 Uphavene, John, of Sende 0
4627754 2239609 2239609 defendant Lange Thomas   591211 591211 Lange, Thomas, of Sende 0
4636273 2242178 2242178 defendant White John   591211 591211 White, John, of Sende 0
4657267 2248162 2248162 defendant Hoper Robert woolman 591211 591211 Hoper, Robert, of Sende, woolman 0
4664442 2250359 2250359 defendant Curteys Henry skinner 591211 591211 Curteys, Henry, of Sende, skinner 0
4664443 2250359 2250359 defendant Curteys Robert husbandman 591211 591211 Curteys, Robert, of Sende, husbandman 1
4664444 2250359 2250359 defendant Bowyer Ralph husbandman 591211 591211 Bowyer, Ralph, of Sende, husbandman 2
4664445 2250359 2250359 defendant Wastell William husbandman 591211 591211 Wastell, William, of Sende, husbandman 3
4665682 2250737 2250737 plaintiff Hopere Robert weaver 591211 591211 Hopere, Robert, of Sende, weaver 0
4665683 2250737 2250737 defendant Bevele John, junior laborer 591211 591211 Bevele, John, junior, of Sende, laborer 0
4676519 2258272 2258272 defendant atte Barwe Thomas husbandman 591211 591211 atte Barwe, Thomas, of Sende, husbandman 1
4707754 2267792 2267792 defendant atte Barwe Thomas husbandman 591211 591211 atte Barwe, Thomas, of Sende, husbandman 0
4715178 2270076 2270076 plaintiff Vyan John chaplain 591211 591211 Vyan, John, of Sende, chaplain 0
4792456 2293726 2293726 defendant Michell Walter husbandman 591211 591211 Michell, Walter, of Sende, husbandman 0
4804601 2297632 2297632 defendant Sende William husbandman 591211 591211 Sende, William, of Sende, husbandman 0
4818947 2302008 2302008 defendant Lethenard John husbandman 591211 591211 Lethenard, John, of Sende, husbandman 3
4904378 2327985 2327985 defendant Curteys Henry skinner 591211 591211 Curteys, Henry, of Sende, skinner 0
4917624 2332026 2332026 defendant Heyghwey Walter weaver 591211 591211 Heyghwey, Walter, of Sende, weaver 0
4917625 2332026 2332026 defendant Emys William husbandman 591211 591211 Emys, William, of Sende, husbandman 1
4968272 2347469 2347469 defendant Gregge William   591211 591211 Gregge, William, of Sende, tile maker 2
5007575 2359112 2359112 defendant Grigge William tiler 591211 591211 Grigge, William, of Sende, tiler 1
5178728 2409498 2409498 plaintiff Barbot Walter   591211 591211 Barbot, Walter, of Sende 0
5212992 2419537 2419537 defendant Barbyt Walter husbandman 591211 591211 Barbyt, Walter, of Sende, husbandman 0
5220401 2421662 2421662 defendant Summer William husbandman 591211 591211 Summer, William, of Sende, husbandman 0
5283989 2440342 2440342 defendant Courteys John chaplain 591211 591211 Courteys, John, of Sende, chaplain 1
5283990 2440342 2440342 defendant Baldenham Robert butcher 591211 591211 Baldenham, Robert, of Sende, butcher 2
5302562 2445740 2445740 defendant Baldenham Robert butcher 591211 591211 Baldenham, Robert, of Sende, butcher 0
5302565 2445741 2445741 defendant Baldenham Robert butcher 591211 591211 Baldenham, Robert, of Sende, butcher 0
5363438 2464216 2464216 defendant Sumner William husbandman 591211 591211 Sumner, William, of Sende, husbandman 2
5547469 2519276 2519276 defendant Tyllyng William husbandman 591211 591211 Tyllyng, William, of Sende, husbandman 0
5572850 2526610 2526610 defendant Somner Robert husbandman 591211 591211 Somner, Robert, of Sende, 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);