names

44 rows where place_id = 594459

✎ 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
3616205 1872708 1872708 defendant Crulle William gent 594459 594459 Crulle, William, of West Mallyng, Kent, gent 0
3859819 1976784 1976784 defendant Southern William shoemaker 594459 594459 Southern, William, of West Mallyng, Kent, shoemaker 1
3859823 1976785 1976785 defendant Southern William shoemaker 594459 594459 Southern, William, of West Mallyng, Kent, shoemaker 1
3859836 1976789 1976789 defendant Southern William shoemaker 594459 594459 Southern, William, of West Mallyng, Kent, shoemaker 1
3874034 1981538 1981538 defendant Southern William shoemaker 594459 594459 Southern, William, of West Mallyng, Kent, shoemaker 0
3874046 1981542 1981542 defendant Southern William shoemaker 594459 594459 Southern, William, of West Mallyng, Kent, shoemaker 0
4017743 2031052 2031052 defendant Bennett William yeoman 594459 594459 Bennett, William, of West Mallyng, Kent, yeoman 0
4045049 2040684 2040684 defendant Claygett Robert, senior yeoman 594459 594459 Claygett, Robert, senior, of West Mallyng, Kent, yeoman 0
4054023 2043820 2043820 defendant Claygate Robert haberdasher 594459 594459 Claygate, Robert, of West Mallyng, Kent, haberdasher 0
4082166 2053931 2053931 defendant Sotherne John yeoman 594459 594459 Sotherne, John, of West Mallyng, Kent, yeoman 0
4586417 2227166 2227166 defendant Rokeslee John   594459 594459 Rokeslee, John, of West Mallyng, Kent 1
4673770 2257419 2257419 defendant Large John skinner 594459 594459 Large, John, of West Mallyng, Kent, skinner 0
4673771 2257419 2257419 defendant Gerard Robert skinner 594459 594459 Gerard, Robert, of West Mallyng, Kent, skinner 1
4690145 2262473 2262473 defendant Kyne Richard spicer 594459 594459 Kyne, Richard, of West Mallyng, Kent, spicer 0
4732104 2275222 2275222 defendant Elwyn William husbandman 594459 594459 Elwyn, William, of West Mallyng, Kent, husbandman 0
4743885 2278741 2278741 defendant Wardon John chapman 594459 594459 Wardon, John, of West Mallyng, Kent, chapman 0
4743892 2278742 2278742 defendant Wardon John   594459 594459 Wardon, John, of West Mallyng, Kent, chapmanl 0
4793504 2294077 2294077 defendant Elwyn William husbandman 594459 594459 Elwyn, William, of West Mallyng, Kent, husbandman 0
4795940 2294877 2294877 defendant Dorant Richard chapman 594459 594459 Dorant, Richard, of West Mallyng, kent, chapman 3
4795946 2294878 2294878 defendant Dorant Richard chapman 594459 594459 Dorant, Richard, of West Mallyng, Kent, chapman 3
4799366 2295979 2295979 defendant Wardon John chapman 594459 594459 Wardon, John, of West Mallyng, Kent, chapman 0
4957455 2344199 2344199 defendant Deraunt Richard spicer 594459 594459 Deraunt, Richard, of West Mallyng, Kent, spicer 0
4968289 2347476 2347476 defendant Sprot Alice widow 594459 594459 Sprot, Alice, of West Mallyng, Kent, widow 1
4968292 2347477 2347477 defendant Sprot Alice widow 594459 594459 Sprot, Alice, of West Mallyng, Kent, widow 1
5020103 2362768 2362768 defendant Sprot William husbandman 594459 594459 Sprot, William, of West Mallyng, Kent, husbandman 1
5020113 2362771 2362771 defendant Sprott William husbandman 594459 594459 Sprott, William, of West Mallyng, Kent, husbandman 1
5023283 2363714 2363714 defendant Sutton John chaplain 594459 594459 Sutton, John, of West Mallyng, Kent, chaplain 0
5023287 2363715 2363715 defendant Sutton John chaplain 594459 594459 Sutton, John, of West Mallyng, Kent, chaplain 0
5056644 2373558 2373558 defendant Sexteyn John stainer 594459 594459 Sexteyn, John, of West Mallyng, Kent, stainer 9
5144260 2399476 2399476 defendant Sprot John taverner 594459 594459 Sprot, John, of West Mallyng, Kent, taverner 2
5235774 2426039 2426039 defendant Coveney Richard chapman 594459 594459 Coveney, Richard, of West Mallyng, Kent, chapman 0
5235777 2426040 2426040 defendant Coveney Richard chapman 594459 594459 Coveney, Richard, of West Mallyng, Kent, chapman 0
5364563 2464577 2464577 defendant Cam Nicholas yeoman 594459 594459 Cam, Nicholas, of West Mallyng, Kent, yeoman 0
5402991 2475937 2475937 defendant Clyterowe Mathew chapman 594459 594459 Clyterowe, Mathew, of West Mallyng, Kent, chapman 1
5415980 2479713 2479713 defendant Clyterowe Mathew chapman 594459 594459 Clyterowe, Mathew, of West Mallyng, Kent, chapman 1
5432394 2484659 2484659 defendant Clyderowe Mathew chapman 594459 594459 Clyderowe, Mathew, of West Mallyng, Kent, chapman 3
5448518 2489453 2489453 defendant Clyderowe Mathew chapman 594459 594459 Clyderowe, Mathew, of West Mallyng, Kent, chapman 3
5448520 2489454 2489454 defendant Clyderowe Mathew chapman 594459 594459 Clyderowe, Mathew, of West Mallyng, Kent, chapman 0
5483943 2500134 2500134 defendant Crull William gent 594459 594459 Crull, William, of West Mallyng, Kent, gent 1
5485407 2500549 2500549 defendant Ferne John yeoman 594459 594459 Ferne, John, of West Mallyng, Kent, yeoman 2
5485411 2500550 2500550 defendant Ferne John yeoman 594459 594459 Ferne, John, of West Mallyng, Kent, yeoman 2
5523491 2512175 2512175 defendant Cheveney alias Cheyne John mercer 594459 594459 Cheveney alias Cheyne, John, of West Mallyng, Kent, mercer 1
5631601 2553895 2553895 defendant Meneware William yeoman 594459 594459 Meneware, William, of West Mallyng, Kent, yeoman 0
5631618 2553900 2553900 defendant Brugges Reginald husbandman 594459 594459 Brugges, Reginald, of West Mallyng, Kent, 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);