names

64 rows where place_id = 589188

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596842 1866647 1866647 defendant Underhill John yeoman 589188 589188 Underhill, John, of Lyngfeld, yeoman 3
3620525 1873994 1873994 defendant Benbrigge Edmund husbandman 589188 589188 Benbrigge, Edmund, of Lyngfeld, husbandman 0
3630372 1904336 1904336 plaintiff Lustede John   589188 589188 Lustede, John, of Lyngfeld 2
3635576 1905929 1905929 defendant Wody Thomas tanner 589188 589188 Wody, Thomas, of Lyngfeld, tanner 0
3711312 1929842 1929842 defendant Wodsyre William husbandman 589188 589188 Wodsyre, William, of Lyngfeld, husbandman 2
3721939 1933125 1933125 defendant Lusted John yeoman 589188 589188 Lusted, John, of Lyngfeld, yeoman 0
3724036 1933801 1933801 defendant Clyff Christine widow 589188 589188 Clyff, Christine, of Lyngfeld, widow 0
3725547 1934280 1934280 defendant Culpeper Edward master of Lyngfeld College 589188 589188 Culpeper, Edward, of Lyngfeld, clerk, master of Lyngfeld College 0
3749542 1941770 1941770 defendant Camfyld John husbandman 589188 589188 Camfyld, John, of Lyngfeld, husbandman 0
3758058 1944506 1944506 defendant Gyles John husbandman 589188 589188 Gyles, John, of Lyngfeld, husbandman 0
3758059 1944506 1944506 defendant Boteley Roger husbandman 589188 589188 Boteley, Roger, of Lyngfeld, husbandman 1
3758854 1944758 1944758 defendant Degon Richard yeoman 589188 589188 Degon, Richard, of Lyngfeld, yeoman 0
3758857 1944759 1944759 defendant Degon Richard yeoman 589188 589188 Degon, Richard, of Lyngfeld, yeoman 0
3759079 1944825 1944825 defendant Rydley Robert husbandman 589188 589188 Rydley, Robert, of Lyngfeld, husbandman 0
3759082 1944825 1944825 defendant Knyght John husbandman 589188 589188 Knyght, John, of Lyngfeld, husbandman 3
3764541 1946569 1946569 defendant Camfeld John husbandman 589188 589188 Camfeld, John, of Lyngfeld, husbandman 0
3831771 1967837 1967837 defendant Wyllot John carpenter 589188 589188 Wyllot, John, of Lyngfeld, carpenter 0
4032597 2036307 2036307 defendant Owton Thomas husbandman 589188 589188 Owton, Thomas, of Lyngfeld, husbandman 1
4110075 2063869 2063869 defendant Saxpen Nicholas yeoman 589188 589188 Saxpen, Nicholas, of Lyngfeld, yeoman 0
4110076 2063869 2063869 defendant Chyppyngdale Leonard glover 589188 589188 Chyppyngdale, Leonard, of Lyngfeld, glover 1
4110077 2063869 2063869 defendant Pockenell Richard husbandman 589188 589188 Pockenell, Richard, of Lyngfeld, husbandman 2
4167838 2084237 2084237 defendant Jefferey John collier 589188 589188 Jefferey, John, of Lyngfeld, collier 0
4317872 2136362 2136362 defendant Welles William cooper 589188 589188 Welles, William, of Lyngfeld, cooper 0
4363303 2151946 2151946 defendant Warner Margaret widow 589188 589188 Warner, Margaret, of Lyngfeld, widow 1
4364465 2152348 2152348 defendant Warner Margaret widow 589188 589188 Warner, Margaret, of Lyngfeld, widow 2
4401453 2165081 2165081 defendant Holmden Anthony yeoman 589188 589188 Holmden, Anthony, of Lyngfeld, yeoman 0
4521874 2207180 2207180 defendant Brugger John   589188 589188 Brugger, John, of Lyngfeld 0
4585281 2226821 2226821 defendant Lounder John   589188 589188 Lounder, John, of Lyngfeld 0
4814986 2300797 2300797 defendant Toth Thomas husbandman 589188 589188 Toth, Thomas, of Lyngfeld, husbandman 0
4825574 2304038 2304038 defendant Mathewe Walter   589188 589188 Mathewe, Walter, of Lyngfeld, bailiff 1
4828526 2304963 2304963 defendant Mathewe Walter   589188 589188 Mathewe, Walter, of Lyngfeld, bailiff 0
4865000 2316030 2316030 defendant Tooth Thomas husbandman 589188 589188 Tooth, Thomas, of Lyngfeld, husbandman 1
4926164 2334611 2334611 defendant Mathewe Walter chapman 589188 589188 Mathewe, Walter, of Lyngfeld, chapman 2
4991266 2354271 2354271 defendant Umfray John tanner 589188 589188 Umfray, John, of Lyngfeld, tanner 0
4991269 2354271 2354271 defendant Lyllynden James butcher 589188 589188 Lyllynden, James, of Lyngfeld, butcher 3
5009053 2359531 2359531 defendant Barbour John   589188 589188 Barbour, John, of Lyngfeld, bailiff 0
5009057 2359532 2359532 defendant Barbour John   589188 589188 Barbour, John, of Lyngfeld, bailiff 0
5064939 2376046 2376046 defendant Umfray John tanner 589188 589188 Umfray, John, of Lyngfeld, tanner 1
5064943 2376047 2376047 defendant Mathewe John yeoman 589188 589188 Mathewe, John, of Lyngfeld, yeoman 2
5065200 2376127 2376127 defendant Humfrey William tanner 589188 589188 Humfrey, William, of Lyngfeld, tanner 3
5079312 2380310 2380310 defendant Jenkyn William husbandman 589188 589188 Jenkyn, William, of Lyngfeld, husbandman 0
5175346 2408480 2408480 defendant Godfray John husbandman 589188 589188 Godfray, John, of Lyngfeld, husbandman 0
5190551 2412983 2412983 defendant Stonehurst Richard husbandman 589188 589188 Stonehurst, Richard, of Lyngfeld, husbandman 1
5190556 2412984 2412984 defendant Stonehurst Richard husbandman 589188 589188 Stonehurst, Richard, of Lyngfeld, husbandman 1
5196480 2414722 2414722 defendant Godfray John husbandman 589188 589188 Godfray, John, of Lyngfeld, husbandman 0
5196483 2414723 2414723 defendant Godfrey John husbandman 589188 589188 Godfrey, John, of Lyngfeld, husbandman 0
5196486 2414724 2414724 defendant Godfrey John husbandman 589188 589188 Godfrey, John, of Lyngfeld, husbandman 0
5207002 2417785 2417785 defendant Stonehurst Richard husbandman 589188 589188 Stonehurst, Richard, of Lyngfeld, husbandman 1
5265404 2434936 2434936 defendant Chellesham Richard husbandman 589188 589188 Chellesham, Richard, of Lyngfeld, husbandman 0
5316664 2450071 2450071 defendant Humfrey John husbandman 589188 589188 Humfrey, John, of Lyngfeld, husbandman 1
5316670 2450072 2450072 defendant Humfrey John husbandman 589188 589188 Humfrey, John, of Lyngfeld, husbandman 1
5322504 2451805 2451805 defendant Dane Thomas usbandman 589188 589188 Dane, Thomas, of Lyngfeld, usbandman 0
5324716 2452467 2452467 defendant Baker Robert tailor 589188 589188 Baker, Robert, of Lyngfeld, tailor 4
5352473 2460870 2460870 defendant Underhyll John, junior husbandman 589188 589188 Underhyll, John, junior, of Lyngfeld, husbandman 1
5352480 2460871 2460871 defendant Underhild John, junior husbandman 589188 589188 Underhild, John, junior, of Lyngfeld, husbandman 2
5352487 2460872 2460872 defendant Underhild John, junior husbandman 589188 589188 Underhild, John, junior, of Lyngfeld, husbandman 2
5385048 2470799 2470799 defendant Umfrey John husbandman 589188 589188 Umfrey, John, of Lyngfeld, husbandman 4
5394653 2473533 2473533 defendant Umfrey James husbandman 589188 589188 Umfrey, James, of Lyngfeld, husbandman 0
5394654 2473533 2473533 defendant Umfrey John husbandman 589188 589188 Umfrey, John, of Lyngfeld, son of James, husbandman 1
5523673 2512231 2512231 plaintiff Gaynesford John   589188 589188 Gaynesford, John, of Lyngfeld 0
5526342 2512817 2512817 defendant Takyll Nicholas yeoman 589188 589188 Takyll, Nicholas, of Lyngfeld, yeoman 1
5560809 2523130 2523130 defendant Underhyll John yeoman 589188 589188 Underhyll, John, of Lyngfeld, yeoman 0
5575814 2527521 2527521 defendant Pyers Richard laborer 589188 589188 Pyers, Richard, of Lyngfeld, laborer 1
5575815 2527521 2527521 defendant Underhill John husbandman 589188 589188 Underhill, John, of Lyngfeld, husbandman 2

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);