names

54 rows where place_id = 586847

✎ 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
3589798 1864450 1864450 defendant Wyllyamson John laborer 586847 586847 Wyllyamson, John, of Etton, laborer 0
3684937 1921421 1921421 defendant Newton William husbandman 586847 586847 Newton, William, of Etton, husbandman 1
3724402 1933920 1933920 defendant Ousteby Robert husbandman 586847 586847 Ousteby, Robert, of Etton, husbandman 0
3759050 1944817 1944817 defendant Appulton William clerk 586847 586847 Appulton, William, of Etton, clerk 0
3781249 1951876 1951876 defendant Ryston Thomas husbandman 586847 586847 Ryston, Thomas, of Etton, husbandman 0
3781250 1951876 1951876 defendant Levet Thomas husbandman 586847 586847 Levet, Thomas, of Etton, husbandman 1
3781251 1951876 1951876 defendant Wallys Roger husbandman 586847 586847 Wallys, Roger, of Etton, husbandman 2
3781252 1951876 1951876 defendant Ryston Isabel widow 586847 586847 Ryston, Isabel, of Etton, widow 3
3990658 2021410 2021410 defendant Jackelyng Robert yeoman 586847 586847 Jackelyng, Robert, of Etton, yeoman 1
3990659 2021411 2021411 plaintiff Blayston Christopher yeoman 586847 586847 Blayston, Christopher, of Etton, yeoman 0
3990661 2021411 2021411 defendant Jacklynge Robert yeoman 586847 586847 Jacklynge, Robert, of Etton, yeoman 1
4065195 2047835 2047835 defendant Akyd William yeoman 586847 586847 Akyd, William, of Etton, yeoman 1
4274819 2121138 2121138 defendant Bradley John husbandman 586847 586847 Bradley, John, of Etton, husbandman 0
4274821 2121139 2121139 defendant Bradley John husbandman 586847 586847 Bradley, John, of Etton, husbandman 0
4274823 2121140 2121140 defendant Bradley John husbandman 586847 586847 Bradley, John, of Etton, husbandman 0
4317519 2136243 2136243 defendant Lowthropp Thomas yeoman 586847 586847 Lowthropp, Thomas, of Etton, yeoman 0
4317526 2136245 2136245 defendant Lowthorp Thomas yeoman 586847 586847 Lowthorp, Thomas, of Etton, yeoman 0
4335283 2142072 2142072 defendant Bradley John yeoman 586847 586847 Bradley, John, of Etton, yeoman 0
4335689 2142215 2142215 defendant Bradley John yeoman 586847 586847 Bradley, John, of Etton, yeoman 0
4383042 2159042 2159042 defendant Elget Richard yeoman 586847 586847 Elget, Richard, of Etton, yeoman 0
4438325 2181282 2181282 defendant Ughtred Peter   586847 586847 Ughtred, Peter, of Etton 0
4448439 2184444 2184444 plaintiff Foxlowe Thomas de   586847 586847 Foxlowe, Thomas de, of Etton 0
4464542 2189578 2189578 defendant Jakelyn William   586847 586847 Jakelyn, William, of Etton 0
4478893 2194068 2194068 defendant Waghen William   586847 586847 Waghen, William, of Etton 0
4479848 2194361 2194361 defendant Cook Patrick   586847 586847 Cook, Patrick, of Etton 0
4708609 2268067 2268067 defendant Smyth Richard laborer 586847 586847 Smyth, Richard, of Etton, laborer 0
4723576 2272679 2272679 defendant Page William husbandman 586847 586847 Page, William, of Etton, husbandman 0
4756803 2282492 2282492 defendant Scot Thomas gent 586847 586847 Scot, Thomas, of Etton, gent 0
4764506 2284884 2284884 plaintiff Hephill Richard   586847 586847 Hephill, Richard, of Etton, parson 0
4773236 2287597 2287597 defendant Small John husbandman 586847 586847 Small, John, of Etton, husbandman 2
4775847 2288446 2288446 defendant Hephill Richard chaplain 586847 586847 Hephill, Richard, of Etton, chaplain 2
4785069 2291344 2291344 defendant Jonson Richard husbandman 586847 586847 Jonson, Richard, of Etton, husbandman 4
4821045 2302661 2302661 defendant Langedayle Thomas (legal representative) 586847 586847 Langedayle, Thomas, of Etton, executors of 0
4821393 2302775 2302775 defendant Anleby Richard gent 586847 586847 Anleby, Richard, of Etton, gent 0
4856281 2313336 2313336 plaintiff Barneby Henry   586847 586847 Barneby, Henry, of Etton 0
4866155 2316385 2316385 defendant Rayley William chaplain 586847 586847 Rayley, William, of Etton, chaplain 0
4925151 2334300 2334300 defendant Hephill Richard   586847 586847 Hephill, Richard, of Etton, parson 1
4955195 2343512 2343512 plaintiff Jakelyn William husbandman 586847 586847 Jakelyn, William, of Etton, husbandman 1
4963369 2345951 2345951 defendant Tudenham Thomas barker 586847 586847 Tudenham, Thomas, of Etton, barker 0
4986505 2352892 2352892 defendant Jakelyn William yeoman 586847 586847 Jakelyn, William, of Etton, yeoman 1
5045156 2370180 2370180 defendant Hancok William laborer 586847 586847 Hancok, William, of Etton, laborer 1
5083196 2381471 2381471 defendant Hog Robert husbandman 586847 586847 Hog, Robert, of Etton, husbandman 0
5105174 2387953 2387953 defendant Stronge Robert husbandman 586847 586847 Stronge, Robert, of Etton, husbandman 0
5308991 2447730 2447730 defendant Jakelyn John gent 586847 586847 Jakelyn, John, of Etton, gent 0
5309929 2448006 2448006 defendant Jaklyng John John gent 586847 586847 Jaklyng, John John, of Etton, gent 0
5325775 2452789 2452789 defendant Jakson Robert   586847 586847 Jakson, Robert, of Etton, wright 0
5325776 2452789 2452789 defendant Yole Thomas laborer 586847 586847 Yole, Thomas, of Etton, laborer 1
5325963 2452857 2452857 defendant Jakelyn John gent 586847 586847 Jakelyn, John, of Etton, gent 0
5327142 2453193 2453193 defendant Grant Ralph thatcher 586847 586847 Grant, Ralph, of Etton, thatcher 3
5338972 2456760 2456760 defendant Jakelyn John gent 586847 586847 Jakelyn, John, of Etton, gent 1
5338973 2456760 2456760 defendant Auleby Peter gent 586847 586847 Auleby, Peter, of Etton, gent 2
5338974 2456760 2456760 defendant Lyndale Beatrice widow 586847 586847 Lyndale, Beatrice, of Etton, widow 3
5542780 2517862 2517862 defendant Symkyn William husbandman 586847 586847 Symkyn, William, of Etton, husbandman 0
5546786 2519064 2519064 defendant Vane John chaplain 586847 586847 Vane, John, of Etton, chaplain 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);