names

54 rows where place_id = 597412

✎ 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
3628468 1903772 1903772 defendant Cateby alias Holyns Robert yeoman 597412 597412 Cateby alias Holyns, Robert, of Eynesbury, yeoman 0
3628866 1903903 1903903 defendant Irlond James smith 597412 597412 Irlond, James, of Eynesbury, smith 0
3629382 1904045 1904045 defendant Paratt William pulter 597412 597412 Paratt, William, of Eynesbury, pulter 0
3629383 1904045 1904045 defendant Powlter William pulter 597412 597412 Powlter, William, of Eynesbury, pulter 1
3632293 1904919 1904919 defendant Ireland James husbandman 597412 597412 Ireland, James, of Eynesbury, husbandman 1
3700268 1926319 1926319 defendant Wallyng Thomas husbandman 597412 597412 Wallyng, Thomas, of Eynesbury, husbandman 2
3795408 1956435 1956435 defendant Feggen William pulter 597412 597412 Feggen, William, of Eynesbury, pulter 4
4454095 2186298 2186298 defendant Lawe John   597412 597412 Lawe, John, of Eynesbury 0
4493528 2198679 2198679 defendant Fraunceys Simon   597412 597412 Fraunceys, Simon, of Eynesbury 0
4497027 2199733 2199733 defendant Tyler Reginald   597412 597412 Tyler, Reginald, of Eynesbury 1
4566873 2221202 2221202 defendant Ferrour John   597412 597412 Ferrour, John, of Eynesbury 3
4586923 2227310 2227310 defendant Adekyn William   597412 597412 Adekyn, William, of Eynesbury 0
4617202 2236389 2236389 defendant Admon Richard   597412 597412 Admon, Richard, of Eynesbury 0
4668595 2255887 2255887 defendant Dere Thomas husbandman 597412 597412 Dere, Thomas, of Eynesbury, husbandman 0
4668596 2255887 2255887 defendant Barker Thomas husbandman 597412 597412 Barker, Thomas, of Eynesbury, husbandman 1
4727509 2273845 2273845 defendant Barker William tanner 597412 597412 Barker, William, of Eynesbury, tanner 4
4739076 2277313 2277313 defendant Atkyn William tanner 597412 597412 Atkyn, William, of Eynesbury, tanner 0
4739244 2277364 2277364 defendant Barker William tanner 597412 597412 Barker, William, of Eynesbury, tanner 1
4760750 2283703 2283703 defendant Barker William tanner 597412 597412 Barker, William, of Eynesbury, tanner 1
4775655 2288382 2288382 plaintiff Wright Richard   597412 597412 Wright, Richard, of Eynesbury 0
4778707 2289319 2289319 defendant Barker William barker 597412 597412 Barker, William, of Eynesbury, barker 0
4778708 2289319 2289319 defendant Wryght Richard husbandman 597412 597412 Wryght, Richard, of Eynesbury, husbandman 1
4780288 2289836 2289836 defendant Barker William barker 597412 597412 Barker, William, of Eynesbury, barker 2
4782981 2290697 2290697 defendant Lytylwode Thomas husbandman 597412 597412 Lytylwode, Thomas, of Eynesbury, husbandman 1
4822896 2303243 2303243 defendant Mychell Thomas tanner 597412 597412 Mychell, Thomas, of Eynesbury, tanner 3
4828376 2304917 2304917 defendant Barkere William husbandman 597412 597412 Barkere, William, of Eynesbury, husbandman 2
4838535 2307971 2307971 defendant Stafford Robert clerk 597412 597412 Stafford, Robert, of Eynesbury, clerk 0
4844247 2309708 2309708 defendant Stafford Robert chaplain 597412 597412 Stafford, Robert, of Eynesbury, chaplain 0
4876780 2319711 2319711 defendant Mail John chaplain 597412 597412 Mail, John, of Eynesbury, chaplain 3
5004254 2358137 2358137 defendant Chelmesford Robert husbandman 597412 597412 Chelmesford, Robert, of Eynesbury, husbandman 0
5004255 2358137 2358137 defendant Poulter Richard husbandman 597412 597412 Poulter, Richard, of Eynesbury, husbandman 1
5004256 2358137 2358137 defendant Aylemer John laborer 597412 597412 Aylemer, John, of Eynesbury, laborer 2
5056379 2373481 2373481 defendant Rycroft William laborer 597412 597412 Rycroft, William, of Eynesbury, laborer 1
5082623 2381307 2381307 defendant Sexteyn John butcher 597412 597412 Sexteyn, John, of Eynesbury, butcher 0
5114539 2390655 2390655 defendant Peche John pulter 597412 597412 Peche, John, of Eynesbury, pulter 0
5158149 2403502 2403502 defendant Day William husbandman 597412 597412 Day, William, of Eynesbury, husbandman 0
5173818 2408040 2408040 defendant Day William husbandman 597412 597412 Day, William, of Eynesbury, husbandman 0
5193945 2413960 2413960 defendant Day William husbandman 597412 597412 Day, William, of Eynesbury, husbandman 0
5205782 2417428 2417428 defendant Reymont John butcher 597412 597412 Reymont, John, of Eynesbury, butcher 2
5291944 2442650 2442650 defendant Edrys Robert yeoman 597412 597412 Edrys, Robert, of Eynesbury, yeoman 2
5305924 2446757 2446757 defendant Warner Simon husbandman 597412 597412 Warner, Simon, of Eynesbury, husbandman 2
5320532 2451227 2451227 defendant Warner Simon courser 597412 597412 Warner, Simon, of Eynesbury, courser 3
5320533 2451227 2451227 defendant Seman Richard glover 597412 597412 Seman, Richard, of Eynesbury, glover 4
5351028 2460429 2460429 defendant Fluellyn David yeoman 597412 597412 Fluellyn, David, of Eynesbury, yeoman 0
5381117 2469656 2469656 defendant Llu David yeoman 597412 597412 Llu, David, of Eynesbury, yeoman 0
5381118 2469656 2469656 defendant Seman Richard glover 597412 597412 Seman, Richard, of Eynesbury, glover 1
5387581 2471516 2471516 defendant Llo David yeoman 597412 597412 Llo, David, of Eynesbury, yeoman 0
5387582 2471516 2471516 defendant Seman Richard glover 597412 597412 Seman, Richard, of Eynesbury, glover 1
5395588 2473818 2473818 defendant Dey Richard miller 597412 597412 Dey, Richard, of Eynesbury, miller 2
5411470 2478388 2478388 defendant Mot John tanner 597412 597412 Mot, John, of Eynesbury, tanner 0
5581055 2529148 2529148 defendant Holyns Richard husbandman 597412 597412 Holyns, Richard, of Eynesbury, husbandman 0
5592183 2532550 2532550 defendant Holyns Richard yeoman 597412 597412 Holyns, Richard, of Eynesbury, yeoman 2
5592830 2532758 2532758 defendant Awener Robert laborer 597412 597412 Awener, Robert, of Eynesbury, laborer 1
5592831 2532758 2532758 defendant Frauncys Simon husbandman 597412 597412 Frauncys, Simon, of Eynesbury, 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);