names

40 rows where place_id = 593619

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612600 1871578 1871578 defendant Payn William husbandman 593619 593619 Payn, William, of Sheryng, husbandman 0
3612601 1871578 1871578 defendant Castell William husbandman 593619 593619 Castell, William, of Sheryng, husbandman 1
3715801 1931228 1931228 defendant Hutt John, junior carpenter 593619 593619 Hutt, John, junior, of Sheryng, carpenter 4
3722056 1933162 1933162 defendant Noke John thatcher 593619 593619 Noke, John, of Sheryng, thatcher 1
3755623 1943716 1943716 defendant Hales William husbandman 593619 593619 Hales, William, of Sheryng, husbandman 3
3773590 1949452 1949452 defendant Halys John husbandman 593619 593619 Halys, John, of Sheryng, husbandman 2
3807742 1960309 1960309 defendant Halys William husbandman 593619 593619 Halys, William, of Sheryng, husbandman 2
3906683 1992528 1992528 defendant Monke William laborer 593619 593619 Monke, William, of Sheryng, laborer 0
3936221 2002440 2002440 defendant Waylet John husbandman 593619 593619 Waylet, John, of Sheryng, husbandman 0
4563298 2220094 2220094 defendant Lenyng John   593619 593619 Lenyng, John, of Sheryng 0
4606087 2233018 2233018 defendant Heth John   593619 593619 Heth, John, of Sheryng 0
4606088 2233018 2233018 defendant Whithede John   593619 593619 Whithede, John, of Sheryng 1
4606090 2233019 2233019 defendant Heth John   593619 593619 Heth, John, of Sheryng 0
4606091 2233019 2233019 defendant Whithede John   593619 593619 Whithede, John, of Sheryng 1
4720244 2271674 2271674 defendant Elyve William laborer 593619 593619 Elyve, William, of Sheryng, laborer 1
4728538 2274165 2274165 defendant Colyn William husbandman 593619 593619 Colyn, William, of Sheryng, husbandman 0
4756597 2282426 2282426 defendant Monke Richard plumber 593619 593619 Monke, Richard, of Sheryng, plumber 0
4854788 2312848 2312848 defendant Colyns John husbandman 593619 593619 Colyns, John, of Sheryng, husbandman 0
4855053 2312932 2312932 defendant Abbot Thomas laborer 593619 593619 Abbot, Thomas, of Sheryng, laborer 0
4869850 2317542 2317542 defendant Burgoyne William courser 593619 593619 Burgoyne, William, of Sheryng, courser 0
4901822 2327177 2327177 defendant Hothom or Hoton Robert yeoman 593619 593619 Hothom or Hoton, Robert, of Sheryng, yeoman 0
4992964 2354780 2354780 defendant Wryghte Thomas carpenter 593619 593619 Wryghte, Thomas, of Sheryng, carpenter 1
5022303 2363417 2363417 defendant Hothom Robert gent 593619 593619 Hothom, Robert, of Sheryng, gent 0
5022305 2363418 2363418 defendant Hothom Robert gent 593619 593619 Hothom, Robert, of Sheryng, gent 0
5033712 2366737 2366737 defendant Colyn Nicholas husbandman 593619 593619 Colyn, Nicholas, of Sheryng, husbandman 0
5077011 2379623 2379623 defendant Colyn John yeoman 593619 593619 Colyn, John, of Sheryng, yeoman 2
5120078 2392309 2392309 defendant Repynghale Robert husbandman 593619 593619 Repynghale, Robert, of Sheryng, husbandman 1
5123495 2393323 2393323 defendant Ryppyngale Robert husbandman 593619 593619 Ryppyngale, Robert, of Sheryng, or of Neuport, husbandman 0
5321505 2451524 2451524 defendant Rede John yeoman 593619 593619 Rede, John, of Sheryng, yeoman 0
5366767 2465263 2465263 defendant Sabbysworth Thomas laborer 593619 593619 Sabbysworth, Thomas, of Sheryng, laborer 2
5366777 2465266 2465266 defendant Sabbysworth Thomas laborer 593619 593619 Sabbysworth, Thomas, of Sheryng, laborer 2
5380585 2469498 2469498 defendant Sabbysworth Thomas   593619 593619 Sabbysworth, Thomas, of Sheryng 2
5384394 2470623 2470623 defendant Sabbysworth Thomas husbandman 593619 593619 Sabbysworth, Thomas, of Sheryng, husbandman 2
5385376 2470894 2470894 defendant Sakbys_ Thomas husbandman 593619 593619 Sakbys_, Thomas, of Sheryng, husbandman 2
5447636 2489165 2489165 defendant Munke William   593619 593619 Munke,William, of Sheryng 1
5487541 2501168 2501168 defendant Turtyll John husbandman 593619 593619 Turtyll, John, of Sheryng, husbandman 0
5487545 2501168 2501168 defendant Turtyll Thomas husbandman 593619 593619 Turtyll, Thomas, of Sheryng, husbandman 4
5502725 2505768 2505768 defendant Wryght William husbandman 593619 593619 Wryght, William, of Sheryng, husbandman 0
5502726 2505768 2505768 defendant Castell William laborer 593619 593619 Castell, William, of Sheryng, laborer 1
5523113 2512056 2512056 defendant Dene Edmund yeoman 593619 593619 Dene, Edmund, of Sheryng, yeoman 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);