names

37 rows where place_id = 826916

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3803969 1959157 1959157 defendant Abbott William   826916 826916 Abbott, William, of Parva Wenham, tile maker 2
4954624 2343340 2343340 defendant Debenham Gilbert esq 826916 826916 Debenham, Gilbert, of Parva Wenham, esq 0
5030575 2365814 2365814 defendant Spunne John husbandman 826916 826916 Spunne, John, of Parva Wenham, husbandman 1
5030576 2365814 2365814 defendant Clerk John, senior husbandman 826916 826916 Clerk, John, senior, of Parva Wenham, husbandman 2
5256206 2432066 2432066 plaintiff Debenham Gilbert esq 826916 826916 Debenham, Gilbert, of Parva Wenham, esq 0
5292451 2442788 2442788 defendant Debenham Gilbert esq 826916 826916 Debenham, Gilbert, of Parva Wenham, esq 0
5295614 2443708 2443708 defendant Neweman Richard laborer 826916 826916 Neweman, Richard, of Parva Wenham, laborer 0
5296211 2443882 2443882 defendant Debenham Gilbert esq 826916 826916 Debenham, Gilbert, of Parva Wenham, esq 0
5327504 2453295 2453295 defendant Clerke Richard husbandman 826916 826916 Clerke, Richard, of Parva Wenham, husbandman 1
5336996 2456137 2456137 defendant Debenham Gilbert   826916 826916 Debenham, Gilbert, of Parva Wenham, knight 1
5351086 2460446 2460446 defendant Debenham Gilbert   826916 826916 Debenham, Gilbert, of Parva Wenham, knight 0
5351087 2460446 2460446 defendant Danyell Richard yeoman 826916 826916 Danyell, Richard, of Parva Wenham, yeoman 1
5351088 2460446 2460446 defendant Dalby John yeoman 826916 826916 Dalby, John, of Parva Wenham, yeoman 2
5351089 2460446 2460446 defendant Godale John yeoman 826916 826916 Godale, John, of Parva Wenham, yeoman 3
5351090 2460446 2460446 defendant Danyell Robert yeoman 826916 826916 Danyell, Robert, of Parva Wenham, yeoman 4
5351091 2460446 2460446 defendant Haunten Robert yeoman 826916 826916 Haunten, Robert, of Parva Wenham, yeoman 5
5354643 2461529 2461529 defendant Debenham Gilbert   826916 826916 Debenham, Gilbert, of Parva Wenham, knight 1
5359715 2463077 2463077 defendant Debenham Gilbert   826916 826916 Debenham, Gilbert, of Parva Wenham, knight 0
5493052 2502833 2502833 defendant Heyward Robert yeoman 826916 826916 Heyward, Robert, of Parva Wenham, yeoman 0
5535457 2515618 2515618 defendant Boteler William yeoman 826916 826916 Boteler, William, of Parva Wenham, yeoman 1
5535458 2515618 2515618 defendant Berwyk John yeoman 826916 826916 Berwyk, John, of Parva Wenham, yeoman 2
5535459 2515618 2515618 defendant Shepperd Henry yeoman 826916 826916 Shepperd, Henry, of Parva Wenham, yeoman 3
5535460 2515618 2515618 defendant Philippys Thomas yeoman 826916 826916 Philippys, Thomas, of Parva Wenham, yeoman 4
5549479 2519903 2519903 defendant Berwyk John yeoman 826916 826916 Berwyk, John, of Parva Wenham, yeoman 1
5549480 2519903 2519903 defendant Shepard Henry yeoman 826916 826916 Shepard, Henry, of Parva Wenham, yeoman 2
5549481 2519903 2519903 defendant Phylyppes Thomas yeoman 826916 826916 Phylyppes, Thomas, of Parva Wenham, yeoman 3
5549484 2519904 2519904 defendant Botiller William yeoman 826916 826916 Botiller, William, of Parva Wenham, yeoman 1
5549486 2519904 2519904 defendant Smyth Leonard   826916 826916 Smyth, Leonard, of Parva Wenham 3
5549487 2519904 2519904 defendant Shepeherd Henry yeoman 826916 826916 Shepeherd, Henry, of Parva Wenham, yeoman 4
5549488 2519904 2519904 defendant Philippes Thomas   826916 826916 Philippes, Thomas, of Parva Wenham 5
5549490 2519904 2519904 defendant Berwyke John yeoman 826916 826916 Berwyke, John, of Parva Wenham, yeoman 7
5549494 2519905 2519905 defendant Smyth Leonard   826916 826916 Smyth, Leonard, of Parva Wenham 2
5549495 2519905 2519905 defendant Shepeherd Henry yeoman 826916 826916 Shepeherd, Henry, of Parva Wenham, yeoman 3
5549496 2519905 2519905 defendant Philippes Thomas   826916 826916 Philippes, Thomas, of Parva Wenham 4
5549498 2519905 2519905 defendant Berwyke John yeoman 826916 826916 Berwyke, John, of Parva Wenham, yeoman 6
5549499 2519905 2519905 defendant Botiller William yeoman 826916 826916 Botiller, William, of Parva Wenham, yeoman 7
5624510 2551606 2551606 defendant Sewale William weaver 826916 826916 Sewale, William, of Parva Wenham, weaver 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);