names

39 rows where place_id = 602783

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651766 1910907 1910907 defendant Fange alias Tayllour Richard yeoman 602783 602783 Fange alias Tayllour, Richard, of Dunmowe Magna, yeoman 0
3893087 1987934 1987934 defendant Melborn Robert butcher 602783 602783 Melborn, Robert, of Dunmowe Magna, butcher 1
3894770 1988457 1988457 defendant Hutte William smith 602783 602783 Hutte, William, of Dunmowe Magna, smith 0
3894771 1988457 1988457 defendant Hutte John smith 602783 602783 Hutte, John, of Dunmowe Magna, smith 1
4101333 2060780 2060780 defendant Pomfrett John butcher 602783 602783 Pomfrett, John, of Dunmowe Magna, butcher 0
4101336 2060781 2060781 defendant Pomfrett John butcher 602783 602783 Pomfrett, John, of Dunmowe Magna, butcher 0
4133928 2072470 2072470 defendant Long John yeoman 602783 602783 Long, John, of Dunmowe Magna, yeoman 0
4171614 2085536 2085536 defendant Pumfrett John butcher 602783 602783 Pumfrett, John, of Dunmowe Magna, butcher 1
4171615 2085536 2085536 defendant Purle William laborer 602783 602783 Purle, William, of Dunmowe Magna, laborer 2
4179805 2088413 2088413 defendant Turner Edward miller 602783 602783 Turner, Edward, of Dunmowe Magna, miller 0
4179806 2088413 2088413 defendant Swetinge Thomas bricklayer 602783 602783 Swetinge, Thomas, of Dunmowe Magna, bricklayer 1
4180727 2088741 2088741 defendant Pavyatt John (legal representative) 602783 602783 Pavyatt, John, of Dunmowe Magna, yeoman, executors of 0
4180728 2088741 2088741 defendant Pavyatt Thomas yeoman 602783 602783 (Pavyatt, Thomas, of Dunmowe Magna, yeoman 1
4180729 2088741 2088741 defendant Pavyatt Jerome yeoman 602783 602783 Pavyatt, Jerome, of Dunmowe Magna, yeoman 2
4220709 2102743 2102743 defendant Turner Robert glasier 602783 602783 Turner, Robert, of Dunmowe Magna, glasier 0
4223217 2103611 2103611 defendant Handleye William yeoman 602783 602783 Handleye, William, of Dunmowe Magna, yeoman 0
4236708 2108412 2108412 defendant Playell Jerome chapman 602783 602783 Playell, Jerome, of Dunmowe Magna, chapman 0
4248703 2112552 2112552 defendant Handley William yeoman 602783 602783 Handley, William, of Dunmowe Magna, yeoman 0
4277794 2122158 2122158 defendant Handley William yeoman 602783 602783 Handley, William, of Dunmowe Magna, yeoman 0
4280449 2123070 2123070 defendant Whitlock William husbandman 602783 602783 Whitlock, William, of Dunmowe Magna, husbandman 0
4280450 2123070 2123070 defendant Maude Thomas   602783 602783 Maude, Thomas, of Dunmowe Magna, collar maker 1
4281920 2123580 2123580 defendant Sorrell John husbandman 602783 602783 Sorrell, John, of Dunmowe Magna, husbandman 0
4281921 2123580 2123580 defendant Mott William husbandman 602783 602783 Mott, William, of Dunmowe Magna, husbandman 1
4281922 2123580 2123580 defendant Quilter Francis husbandman 602783 602783 Quilter, Francis, of Dunmowe Magna, husbandman 2
4281924 2123580 2123580 defendant Notage Samuel laborer 602783 602783 Notage, Samuel, of Dunmowe Magna, laborer 4
4281925 2123580 2123580 defendant Sworder William laborer 602783 602783 Sworder William, of Dunmowe Magna, laborer 5
4295660 2128534 2128534 defendant Handley William yeoman 602783 602783 Handley, William, of Dunmowe Magna, yeoman 0
4329842 2140282 2140282 defendant Mace alias Tyler George tailor 602783 602783 Mace alias Tyler, George, of Dunmowe Magna, tailor 0
4365015 2152542 2152542 defendant Kynwelmershe Richard gent 602783 602783 Kynwelmershe, Richard, of Dunmowe Magna, gent 1
4365017 2152542 2152542 defendant Bickmer William yeoman. Innholder 602783 602783 Bickmer, William, of Dunmowe Magna, yeoman. Innholder 3
4367163 2153312 2153312 defendant Brownynge Richard, senior blacksmith 602783 602783 Brownynge, Richard, senior, of Dunmowe Magna, blacksmith 0
4393422 2162402 2162402 defendant Ramsey Thomas tailor 602783 602783 Ramsey, Thomas, of Dunmowe Magna, tailor 0
4393423 2162402 2162402 defendant Bickmer Christopher bricklayer 602783 602783 Bickmer, Christopher, of Dunmowe Magna, bricklayer 1
4408180 2167307 2167307 defendant Sweetinge Thomas carpenter 602783 602783 Sweetinge, Thomas, of Dunmowe Magna, carpenter 0
4408181 2167307 2167307 defendant Sweetinge William carpenter 602783 602783 Sweetinge, William, of Dunmowe Magna, carpenter 1
5556292 2521835 2521835 defendant Prentys Richard butcher 602783 602783 Prentys, Richard, of Dunmowe Magna, butcher 0
5556293 2521835 2521835 defendant Fuller John husbandman 602783 602783 Fuller, John, of Dunmowe Magna, husbandman 1
5556294 2521835 2521835 defendant Palgrave Nicholas butcher 602783 602783 Palgrave, Nicholas, of Dunmowe Magna, butcher 2
5597406 2534091 2534091 plaintiff Cranemer William (legal representative) 602783 602783 Cranemer, William, of Dunmowe Magna, smith, son of Cranemer, John, senior, of Chelmesford, executors of 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);