names

45 rows where place_id = 609362

✎ 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
3678100 1919199 1919199 defendant Dawson John yeoman 609362 609362 Dawson, John, of Manston, yeoman 0
3800199 1957982 1957982 defendant Helde Humphrey yeoman 609362 609362 Helde, Humphrey, of Manston, yeoman 2
4176483 2087257 2087257 defendant Percye Christopher esq 609362 609362 Percye, Christopher, of Manston, esq 0
4183011 2089540 2089540 defendant Percye Christopher esq 609362 609362 Percye, Christopher, of Manston, esq 0
4231855 2106639 2106639 defendant Sheldon Philip esq 609362 609362 Sheldon, Philip, of Manston, esq 0
4262470 2117113 2117113 defendant Newell Francis gent 609362 609362 Newell, Francis, of Manston, gent 3
4262475 2117114 2117114 defendant Newell Francis gent 609362 609362 Newell, Francis, of Manston, gent 3
4304925 2131861 2131861 defendant Johnson Thomas clerk 609362 609362 Johnson, Thomas, of Manston, or of Sturminster Newton Castell, clerk 0
4306031 2132248 2132248 defendant Nowell Francis gent 609362 609362 Nowell, Francis, of Manston, gent 0
4309736 2133559 2133559 defendant Nowell Francis yeoman 609362 609362 Nowell, Francis, of Manston, yeoman 3
4508940 2203273 2203273 defendant Tarent Stephen   609362 609362 Tarent, Stephen, of Manston, mason 0
4525409 2208284 2208284 plaintiff Jacob William   609362 609362 Jacob, William, of Manston, in the parish of Minster 0
4609443 2234055 2234055 defendant Churcheman John   609362 609362 Churcheman, John, of Manston 0
4609444 2234055 2234055 defendant Vynhave William   609362 609362 Vynhave, William, of Manston 1
4622590 2238043 2238043 plaintiff Lyndessey Robert (legal representative) 609362 609362 Lyndessey, Robert, of Manston, executor of 0
4622593 2238044 2238044 plaintiff Lyndessey Robert (legal representative) 609362 609362 Lyndessey, Robert, of Manston, executor of 0
4725207 2273179 2273179 defendant Baker John husbandman 609362 609362 Baker, John, of Manston, husbandman 0
4741916 2278130 2278130 defendant Manston Alveredus or Alfred esq 609362 609362 Manston, Alveredus or Alfred, of Manston, esq 0
4846844 2310518 2310518 defendant Manston Alfred   609362 609362 Manston, Alfred, of Manston 1
4885648 2322385 2322385 defendant Manston Alvered gent 609362 609362 Manston, Alvered, of Manston, gent 0
4895473 2325251 2325251 defendant Manston Alvered esq 609362 609362 Manston, Alvered, of Manston, esq 0
4895643 2325309 2325309 defendant Horeston John gent 609362 609362 Horeston, John, of Manston, gent 0
4924323 2334041 2334041 defendant Manston John gent 609362 609362 Manston, John, of Manston, gent 0
4952368 2342663 2342663 defendant Manston Thomas gent 609362 609362 Manston, Thomas, of Manston, gent 0
5046147 2370477 2370477 plaintiff Manston Thomas   609362 609362 Manston, Thomas, of Manston 0
5101674 2386910 2386910 defendant Manston Thomas gent 609362 609362 Manston, Thomas, of Manston, gent 0
5115226 2390877 2390877 defendant Leyot William gent 609362 609362 Leyot, William, of Manston, gent 0
5135729 2396960 2396960 defendant Leyot William gent 609362 609362 Leyot, William, of Manston, gent 0
5141224 2398557 2398557 defendant Hall John husbandman 609362 609362 Hall, John, of Manston, husbandman 0
5155997 2402909 2402909 defendant Leyot William gent 609362 609362 Leyot, William, of Manston, gent 0
5190169 2412868 2412868 plaintiff Leyot William   609362 609362 Leyot, William, of Manston 0
5191755 2413325 2413325 defendant Leyot William gent 609362 609362 Leyot, William, of Manston, gent 0
5201000 2416051 2416051 defendant Hall John husbandman 609362 609362 Hall, John, of Manston, husbandman 1
5206790 2417723 2417723 plaintiff Leyot William   609362 609362 Leyot, William, of Manston 0
5207463 2417923 2417923 defendant Leyot William gent 609362 609362 Leyot, William, of Manston, gent 0
5240082 2427299 2427299 defendant Baker Thomas husbandman 609362 609362 Baker, Thomas, of Manston, husbandman 3
5318556 2450646 2450646 defendant Welle John gent 609362 609362 Welle, John, of Manston, gent 2
5318557 2450646 2450646 defendant Manston John, junior gent 609362 609362 Manston, John, junior, of Manston, gent, son of Manston, Thomas, junior, of Manston, gent 3
5378932 2469003 2469003 defendant Bloyston Ralph clerk 609362 609362 Bloyston, Ralph, of Manston, clerk 0
5464990 2494441 2494441 defendant Cameler Richard le chaplain 609362 609362 Cameler, Richard le, of Manston, chaplain 0
5589957 2531842 2531842 defendant Dyneley Peter chaplain 609362 609362 Dyneley, Peter, of Manston, chaplain 0
5589958 2531842 2531842 defendant Dyneley Roger, junior gent 609362 609362 Dyneley, Roger, junior, of Manston, gent 1
5589959 2531842 2531842 defendant Dyneley Francis gent 609362 609362 Dyneley, Francis, of Manston, gent 2
5589960 2531842 2531842 defendant Sotell John chaplain 609362 609362 Sotell, John, of Manston, chaplain 3
5589961 2531842 2531842 defendant Dyneley Roger, senior gent 609362 609362 Dyneley, Roger, senior, of Manston, gent 4

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