names

47 rows where place_id = 586719

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589459 1864342 1864342 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 0
3603055 1868622 1868622 defendant Edward William husbandman 586719 586719 Edward, William, of North Oresby, husbandman 3
3623794 1874975 1874975 defendant Thorold William, junior husbandman 586719 586719 Thorold, William, junior, of North Oresby, husbandman 0
3637373 1906495 1906495 defendant Clerke Hugh husbandman 586719 586719 Clerke, Hugh, of North Oresby, husbandman 0
3637374 1906495 1906495 defendant Thorold Thomas, junior husbandman 586719 586719 Thorold, Thomas, junior, of North Oresby, husbandman 1
3637375 1906495 1906495 defendant Manby Thomas, junior husbandman 586719 586719 Manby, Thomas, junior, of North Oresby, husbandman 2
3690348 1923144 1923144 defendant Lyson Robert husbandman 586719 586719 Lyson, Robert, of North Oresby, husbandman 1
3693508 1924178 1924178 defendant Rechardson Martin merchant of the staple 586719 586719 Rechardson, Martin, of North Oresby, merchant of the staple 1
3693509 1924178 1924178 defendant Frauncys John husbandman 586719 586719 Frauncys, John, of North Oresby, husbandman 2
3693510 1924178 1924178 defendant Tharold John husbandman 586719 586719 Tharold, John, of North Oresby, husbandman 3
4752547 2281204 2281204 defendant Kele William husbandman 586719 586719 Kele, William, of North Oresby, husbandman 5
4859207 2314254 2314254 defendant Rumbold John husbandman 586719 586719 Rumbold, John, of North Oresby, husbandman 0
4871541 2318068 2318068 defendant Rumbald John husbandman 586719 586719 Rumbald, John, of North Oresby, husbandman 1
5233731 2425452 2425452 defendant Holdernesse John husbandman 586719 586719 Holdernesse, John, of North Oresby, husbandman 0
5330293 2454134 2454134 defendant Clerk Vincent yeoman 586719 586719 Clerk, Vincent, of North Oresby, yeoman 0
5330556 2454228 2454228 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 3
5332439 2454767 2454767 defendant Mumby John husbandman 586719 586719 Mumby, John, of North Oresby, husbandman 2
5343305 2458099 2458099 defendant Fraunces Henry husbandman 586719 586719 Fraunces, Henry, of North Oresby, husbandman 0
5343306 2458099 2458099 defendant Mumby John husbandman 586719 586719 Mumby, John, of North Oresby, husbandman 1
5343307 2458099 2458099 defendant Thorald William husbandman 586719 586719 Thorald, William, of North Oresby, husbandman 2
5343308 2458099 2458099 defendant Thorald Jon, junior husbandman 586719 586719 Thorald, Jon, junior, of North Oresby, husbandman 3
5343309 2458099 2458099 defendant Carter William, junior laborer 586719 586719 Carter, William, junior, of North Oresby, laborer 4
5343310 2458099 2458099 defendant Fraunkyssh Walter laborer 586719 586719 Fraunkyssh, Walter, of North Oresby,laborer 5
5348369 2459633 2459633 defendant Edward William husbandman 586719 586719 Edward, William, of North Oresby, husbandman 0
5348370 2459633 2459633 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 1
5349052 2459831 2459831 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 1
5395794 2473882 2473882 defendant Thorold William, junior husbandman 586719 586719 Thorold, William, junior, of North Oresby, husbandman 0
5481264 2499342 2499342 defendant Clerk William yeoman 586719 586719 Clerk, William, of North Oresby, yeoman 1
5500058 2504972 2504972 defendant Roote William husbandman 586719 586719 Roote, William, of North Oresby, husbandman 0
5500059 2504972 2504972 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 1
5500060 2504972 2504972 defendant Edward William husbandman 586719 586719 Edward, William, of North Oresby, husbandman 2
5506065 2506821 2506821 defendant Roote William, senior husbandman 586719 586719 Roote, William, senior, of North Oresby, husbandman 0
5506070 2506821 2506821 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 5
5506071 2506821 2506821 defendant Carter John husbandman 586719 586719 Carter, John, of North Oresby, husbandman 6
5506073 2506822 2506822 defendant Lyson John husbandman 586719 586719 Lyson, John, of North Oresby, husbandman 0
5506074 2506822 2506822 defendant Tenydale John husbandman 586719 586719 Tenydale, John, of North Oresby, husbandman 1
5506075 2506822 2506822 defendant Carter John husbandman 586719 586719 Carter, John, of North Oresby, husbandman 2
5515597 2509721 2509721 defendant Rote William, senior husbandman 586719 586719 Rote, William, senior, of North Oresby, husbandman 0
5515598 2509721 2509721 defendant Rote William, junior husbandman 586719 586719 Rote, William, junior, of North Oresby, husbandman 1
5520604 2511268 2511268 defendant Lyson John, senior husbandman 586719 586719 Lyson, John, senior, of North Oresby, husbandman 2
5520605 2511268 2511268 defendant Lyson John, junior husbandman 586719 586719 Lyson, John, junior, of North Oresby, husbandman 3
5520606 2511268 2511268 defendant Lyson Robert husbandman 586719 586719 Lyson, Robert, of North Oresby, husbandman 4
5531638 2514429 2514429 defendant Thoralde William, junior husbandman 586719 586719 Thoralde, William, junior, of North Oresby, husbandman 0
5550174 2520084 2520084 defendant Hompton William clerk 586719 586719 (Hompton, William, of North Oresby, clerk 4
5550175 2520084 2520084 defendant Fraunces William husbandman 586719 586719 Fraunces, William, of North Oresby, husbandman 5
5550176 2520084 2520084 defendant Clerk Thomas husbandman 586719 586719 Clerk, Thomas, of North Oresby, husbandman 6
5550177 2520084 2520084 defendant Clerk Elizabeth widow 586719 586719 Clerk, Elizabeth, of North Oresby, widow 7

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