names

40 rows where place_id = 589292

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597125 1866725 1866725 defendant Harper Thomas husbandman 589292 589292 Harper, Thomas, of Ingoldesby, husbandman 0
3603758 1868845 1868845 defendant Echys John husbandman 589292 589292 Echys, John, of Ingoldesby, husbandman 0
3620335 1873941 1873941 defendant Harper Thomas husbandman 589292 589292 Harper, Thomas, of Ingoldesby, husbandman 2
3621640 1874307 1874307 defendant Lee William gent 589292 589292 Lee, William, of Ingoldesby, gent 0
3833736 1968482 1968482 defendant Lownde Thomas yeoman 589292 589292 Lownde, Thomas, of Ingoldesby, yeoman 0
3876621 1982427 1982427 defendant Todde John husbandman 589292 589292 Todde, John, of Ingoldesby, husbandman 1
3880351 1983682 1983682 defendant Pykkell Thomas clerk 589292 589292 Pykkell, Thomas, of Ingoldesby, clerk 0
3890051 1986907 1986907 defendant North Thomas yeoman 589292 589292 North, Thomas, of Ingoldesby, yeoman 0
3911130 1994049 1994049 defendant Legh Margery widow 589292 589292 Legh, Margery, of Ingoldesby, widow 1
4435567 2175884 2175884 defendant Prestesman Walter the   589292 589292 Prestesman, Walter the, of Ingoldesby 1
4441444 2182265 2182265 plaintiff Botessame John   589292 589292 Botessame, John, of Ingoldesby, parson 0
4593452 2229239 2229239 plaintiff Paunton William de   589292 589292 Paunton, William de, of Ingoldesby 0
4663716 2250135 2250135 plaintiff Greffreyson William   589292 589292 Greffreyson, William, of Ingoldesby 0
4728085 2274032 2274032 plaintiff Howet John   589292 589292 Howet, John, of Ingoldesby 0
4739100 2277320 2277320 defendant Metham John, sen   589292 589292 Metham, John, sen, of Ingoldesby 0
4814117 2300515 2300515 defendant Warner Robert husbandman 589292 589292 Warner, Robert, of Ingoldesby, husbandman 2
4857220 2313644 2313644 defendant Sprotburgh John husbandman 589292 589292 Sprotburgh, John, of Ingoldesby, husbandman 0
4859119 2314228 2314228 defendant Sprotburgh John husbandman 589292 589292 Sprotburgh, John, of Ingoldesby, husbandman 0
4897486 2325873 2325873 defendant Metham John clerk 589292 589292 Metham, John, of Ingoldesby, clerk 6
4945641 2340616 2340616 defendant Holand Robert clerk 589292 589292 Holand, Robert, of Ingoldesby, clerk 0
4966779 2346993 2346993 defendant Howet John husbandman 589292 589292 Howet, John, of Ingoldesby, husbandman 2
5024698 2364145 2364145 plaintiff Howet John, senior   589292 589292 Howet, John, senior, of Ingoldesby 0
5024699 2364145 2364145 plaintiff Howet John, junior   589292 589292 Howet, John, junior, of Ingoldesby 1
5042965 2369512 2369512 defendant Jankyns John husbandman 589292 589292 Jankyns, John, of Ingoldesby, husbandman 3
5042966 2369512 2369512 defendant Auburn Thomas husbandman 589292 589292 Auburn, Thomas, of Ingoldesby, husbandman 4
5042967 2369512 2369512 defendant Eve William husbandman 589292 589292 Eve, William, of Ingoldesby, husbandman 5
5116920 2391374 2391374 defendant Hewet John   589292 589292 Hewet, John, of Ingoldesby, notary 2
5196437 2414710 2414710 defendant Huet John yeoman 589292 589292 Huet, John, of Ingoldesby, yeoman 1
5196442 2414711 2414711 defendant Huet John yeoman 589292 589292 Huet, John, of Ingoldesby, yeoman 1
5209652 2418562 2418562 defendant Huet John yeoman 589292 589292 Huet, John, of Ingoldesby, yeoman 1
5209657 2418563 2418563 defendant Huet John yeoman 589292 589292 Huet, John, of Ingoldesby, yeoman 1
5344852 2458550 2458550 defendant Lee William esq 589292 589292 Lee, William, of Ingoldesby, esq 1
5578405 2528315 2528315 defendant Lee William gent 589292 589292 Lee, William, of Ingoldesby, gent 0
5578436 2528326 2528326 defendant Swynton John yeoman 589292 589292 Swynton, John, of Ingoldesby, yeoman 0
5590679 2532057 2532057 defendant Swynton John yeoman 589292 589292 Swynton, John, of Ingoldesby, yeoman 0
5600214 2534951 2534951 defendant Eldred Simon husbandman 589292 589292 Eldred, Simon, of Ingoldesby, husbandman 0
5604833 2536378 2536378 defendant Swynton John yeoman 589292 589292 Swynton, John, of Ingoldesby, yeoman 0
5618782 2549712 2549712 defendant Wylughby John de, senior   589292 589292 Wylughby, John de, senior, of Ingoldesby 6
5618783 2549712 2549712 defendant Wylughby John de, junior   589292 589292 Wylughby, John de, junior, of Ingoldesby 7
5624471 2551597 2551597 defendant Wylughby John   589292 589292 Wylughby, John, of Ingoldesby, court holder 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);