names

35 rows where place_id = 589005

✎ 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
3596243 1866452 1866452 defendant Hakon Agnes widow 589005 589005 Hakon, Agnes, of Somerleton, widow 0
3634794 1905682 1905682 defendant Boyse Peter yeoman 589005 589005 Boyse, Peter, of Somerleton, yeoman 1
3648419 1909906 1909906 defendant Smyth Richard laborer 589005 589005 Smyth, Richard, of Somerleton, laborer 0
3712900 1930354 1930354 defendant Oweden Robert gent 589005 589005 Oweden, Robert, of Somerleton, gent 0
3721488 1933030 1933030 defendant Heynes Robert husbandman 589005 589005 Heynes, Robert, of Somerleton, husbandman 0
3746342 1940772 1940772 defendant Hacon alias Cristmas Simon yeoman 589005 589005 Hacon alias Cristmas, Simon, of Somerleton, yeoman 1
3750062 1941936 1941936 defendant Hakens alias Crystmas Simon husbandman 589005 589005 Hakens alias Crystmas, Simon, of Somerleton, husbandman 0
3819541 1963990 1963990 defendant London John clerk 589005 589005 London, John, of Somerleton, clerk 0
4464602 2189598 2189598 plaintiff Webstere John   589005 589005 Webstere, John, of Somerleton 0
4465032 2189724 2189724 defendant Webestere John   589005 589005 Webestere, John, of Somerleton 0
4465244 2189796 2189796 defendant Webstere John   589005 589005 Webstere, John, of Somerleton 0
4511510 2204046 2204046 plaintiff Bernard Hamon   589005 589005 Bernard, Hamon, of Somerleton 0
4575071 2223726 2223726 defendant Tudenham John   589005 589005 Tudenham, John, of Somerleton 0
4599547 2231074 2231074 defendant atte Hill John   589005 589005 atte Hill, John, of Somerleton 0
4606432 2233124 2233124 plaintiff Baker John   589005 589005 Baker, John, of Somerleton 0
4606435 2233125 2233125 plaintiff Baker John   589005 589005 Baker, John, of Somerleton, parson 0
4725555 2273282 2273282 defendant Bryd Thomas yeoman 589005 589005 Bryd, Thomas, of Somerleton, yeoman 0
4834106 2306674 2306674 defendant Todynham William husbandman 589005 589005 Todynham, William, of Somerleton, husbandman 0
5093055 2384357 2384357 defendant Owedyn Thomas yeoman 589005 589005 Owedyn, Thomas, of Somerleton, yeoman 1
5230401 2424506 2424506 defendant Nogge Thomas husbandman 589005 589005 Nogge, Thomas, of Somerleton, husbandman 1
5230402 2424506 2424506 defendant Cook Robert husbandman 589005 589005 Cook, Robert, of Somerleton, husbandman 2
5258040 2432635 2432635 defendant Webster Roger husbandman 589005 589005 Webster, Roger, of Somerleton, husbandman 0
5267669 2435646 2435646 defendant Jernegan John, junior esq 589005 589005 Jernegan, John, junior, of Somerleton, esq 0
5267685 2435651 2435651 defendant Coke Robert yeoman 589005 589005 Coke, Robert, of Somerleton, yeoman 0
5267691 2435654 2435654 defendant Jernegan John, junior esq 589005 589005 Jernegan, John, junior, of Somerleton, esq 0
5276878 2438319 2438319 defendant Grey John clerk 589005 589005 Grey, John, of Somerleton, clerk 0
5278229 2438729 2438729 defendant Baker John yeoman 589005 589005 Baker, John, of Somerleton, yeoman 1
5298408 2444510 2444510 defendant Baker John yeoman 589005 589005 Baker, John, of Somerleton, yeoman 1
5386176 2471110 2471110 defendant Jernegan John esq 589005 589005 Jernegan, John, of Somerleton, esq 0
5486476 2500847 2500847 defendant Tuddenham John yeoman 589005 589005 Tuddenham, John, of Somerleton, yeoman 0
5489686 2501797 2501797 defendant Meyr William husbandman 589005 589005 Meyr, William, of Somerleton, husbandman 1
5521623 2511579 2511579 defendant Jernyngham John esq 589005 589005 Jernyngham, John, of Somerleton, esq 0
5521625 2511580 2511580 defendant Jernyngham John esq 589005 589005 Jernyngham, John, of Somerleton, esq 0
5543195 2517989 2517989 defendant Knyght Thomas husbandman 589005 589005 Knyght, Thomas, of Somerleton, husbandman 1
5572801 2526593 2526593 defendant Phelipp Robert husbandman 589005 589005 Phelipp, Robert, of Somerleton, husbandman 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);