names

27 rows where place_id = 594483

✎ 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
3616298 1872738 1872738 defendant Dewe James yeoman 594483 594483 Dewe, James, of Wakeryng, yeoman 2
3685326 1921562 1921562 defendant Burfeld William husbandman 594483 594483 Burfeld, William, of Wakeryng, husbandman 0
3827486 1966461 1966461 defendant Dewe John yeoman 594483 594483 Dewe, John, of Wakeryng, yeoman 0
4519628 2206499 2206499 defendant Thurbarn John   594483 594483 Thurbarn, John, of Wakeryng 3
4747157 2279673 2279673 defendant Peeke Ralph drover 594483 594483 Peeke, Ralph, of Wakeryng, drover 1
4756952 2282542 2282542 defendant Welles William husbandman 594483 594483 Welles, William, of Wakeryng, husbandman 0
4772521 2287371 2287371 defendant Peek Ralph yeoman 594483 594483 Peek, Ralph, of Wakeryng, yeoman 0
4772523 2287372 2287372 defendant Peek Ralph yeoman 594483 594483 Peek, Ralph, of Wakeryng, yeoman 0
4797848 2295504 2295504 defendant Peek Ralph yeoman 594483 594483 Peek, Ralph, of Wakeryng, yeoman 0
4797850 2295505 2295505 defendant Peek Ralph yeoman 594483 594483 Peek, Ralph, of Wakeryng, yeoman 0
4971799 2348491 2348491 defendant Millere John husbandman 594483 594483 Millere, John, of Wakeryng, husbandman 1
4991617 2354374 2354374 defendant Lane Henry   594483 594483 Lane, Henry, of Wakeryng 2
5032453 2366376 2366376 plaintiff Samwelle John, junior husbandman 594483 594483 Samwelle, John, junior, of Wakeryng, husbandman 0
5079584 2380384 2380384 plaintiff Cartere Robert (legal representative) 594483 594483 Cartere, Robert, of Wakeryng, executor of 0
5146742 2400188 2400188 plaintiff Carter Robert (legal representative) 594483 594483 Carter, Robert, of Wakeryng, executor of 0
5181788 2410415 2410415 plaintiff Carter Robert (legal representative) 594483 594483 Carter, Robert, of Wakeryng, yeoman, executor of 0
5248628 2429721 2429721 defendant Miller William butcher 594483 594483 Miller, William, of Wakeryng, butcher 3
5305615 2446686 2446686 defendant Dewe John smith 594483 594483 Dewe, John, of Wakeryng, smith 0
5439116 2486623 2486623 defendant Rygby Hugh yeoman 594483 594483 Rygby, Hugh, of Wakeryng, yeoman 2
5445892 2488661 2488661 defendant Gylle Richard husbandman 594483 594483 Gylle, Richard, of Wakeryng, husbandman 0
5452983 2490772 2490772 defendant Rygby Hugh yeoman 594483 594483 Rygby, Hugh, of Wakeryng, yeoman 1
5464935 2494425 2494425 defendant Rygby Hugh yeoman 594483 594483 Rygby, Hugh, of Wakeryng, yeoman 1
5464941 2494426 2494426 defendant Rygby Hugn yeoman 594483 594483 Rygby, Hugn, of Wakeryng, yeoman 1
5539651 2516881 2516881 defendant Stephyn Thomas yeoman 594483 594483 Stephyn, Thomas, of Wakeryng, yeoman 0
5567292 2525011 2525011 defendant Crayford Lionel esq 594483 594483 Crayford, Lionel, of Wakeryng, esq 0
5567293 2525011 2525011 defendant Ynge Mary gentlewoman 594483 594483 Ynge, Mary, of Wakeryng, gentlewoman 1
5630480 2553544 2553544 plaintiff Sampson John   594483 594483 Sampson, John, of Wakeryng 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);