names

54 rows where place_id = 588490

✎ 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
3594674 1865964 1865964 defendant Dymmet William weaver 588490 588490 Dymmet, William, of Sproxton, weaver 0
3594675 1865964 1865964 defendant Walker William laborer 588490 588490 Walker, William, of Sproxton, laborer 1
3594677 1865965 1865965 defendant Dymmettm William weaver 588490 588490 Dymmettm William, of Sproxton, weaver 0
3594678 1865965 1865965 defendant Walker William laborer 588490 588490 Walker, William, of Sproxton, laborer 1
3745437 1940478 1940478 plaintiff Bruster Andrew husbandman 588490 588490 Bruster, Andrew, of Sproxton, husbandman 0
3785236 1953166 1953166 defendant Holyngworth Thomas husbandman 588490 588490 Holyngworth, Thomas, of Sproxton, husbandman 0
3785237 1953166 1953166 defendant Blake Robert husbandman 588490 588490 Blake, Robert, of Sproxton, husbandman 1
3953726 2008378 2008378 defendant Lonnesdale James miller 588490 588490 Lonnesdale, James, of Sproxton, or of Newburghe, miller 0
4255967 2114971 2114971 defendant Sowerby William yeoman 588490 588490 Sowerby, William, of Sproxton, yeoman 0
4459845 2188133 2188133 defendant Saweton John   588490 588490 Saweton, John, of Sproxton, junior 0
4565087 2220651 2220651 defendant Owytebred Walter   588490 588490 Owytebred, Walter, of Sproxton, silk man 0
4709247 2268260 2268260 defendant Malyn Thomas husbandman 588490 588490 Malyn, Thomas, of Sproxton, husbandman 1
4710654 2268688 2268688 defendant Sagher John husbandman 588490 588490 Sagher, John, of Sproxton, husbandman 1
4739456 2277424 2277424 defendant Coke John husbandman 588490 588490 Coke, John, of Sproxton, husbandman 0
4760292 2283572 2283572 defendant Cotes Robert de husbandman 588490 588490 Cotes, Robert de, of Sproxton, husbandman 0
4760293 2283572 2283572 defendant Cotes John de husbandman 588490 588490 Cotes, John de, of Sproxton, husbandman 1
4760926 2283758 2283758 defendant Wodford Robert   588490 588490 Wodford, Robert, of Sproxton, knight 0
4774491 2288007 2288007 defendant Wodford Robert   588490 588490 Wodford, Robert, of Sproxton, knight 0
4784215 2291061 2291061 defendant Wodford Robert   588490 588490 Wodford, Robert, of Sproxton, knight 0
4797565 2295408 2295408 defendant Marwyn Thomas husbandman 588490 588490 Marwyn, Thomas, of Sproxton, husbandman 0
4797567 2295408 2295408 defendant Lyndesey John husbandman 588490 588490 Lyndesey, John, of Sproxton, husbandman 2
4797568 2295408 2295408 defendant Myrth John husbandman 588490 588490 Myrth, John, of Sproxton, husbandman 3
4800165 2296228 2296228 defendant Wodford Robert   588490 588490 Wodford, Robert, of Sproxton, knight 0
4885957 2322473 2322473 defendant Clay Thomas gent 588490 588490 Clay, Thomas, of Sproxton, gent 7
4885958 2322473 2322473 defendant Burton William   588490 588490 Burton, William, of Sproxton, groom 8
4954875 2343413 2343413 defendant Laton John esq 588490 588490 Laton, John, of Sproxton, esq 0
5074568 2378897 2378897 defendant Molens John miller 588490 588490 Molens, John, of Sproxton, miller 0
5074571 2378897 2378897 defendant Mylner Hugh miller 588490 588490 Mylner, Hugh, of Sproxton, miller 3
5088888 2383127 2383127 plaintiff Laton John esq 588490 588490 Laton, John, of Sproxton, esq 0
5088889 2383127 2383127 defendant Dymmyt John husbandman 588490 588490 Dymmyt, John, of Sproxton, husbandman 0
5088890 2383127 2383127 defendant Walker Richard husbandman 588490 588490 Walker, Richard, of Sproxton, husbandman 1
5088891 2383127 2383127 defendant Tayllyour John husbandman 588490 588490 Tayllyour, John, of Sproxton, husbandman 2
5088892 2383127 2383127 defendant Couper John husbandman 588490 588490 Couper, John, of Sproxton, husbandman 3
5088893 2383128 2383128 plaintiff Laton John esq 588490 588490 Laton, John, of Sproxton, esq 0
5088894 2383128 2383128 defendant Dymyt John husbandman 588490 588490 Dymyt, John, of Sproxton, husbandman 0
5088895 2383128 2383128 defendant Walker Richard husbandman 588490 588490 Walker, Richard, of Sproxton, husbandman 1
5088896 2383128 2383128 defendant Tailliour John husbandman 588490 588490 Tailliour, John, of Sproxton, husbandman 2
5088897 2383128 2383128 defendant Couper John husbandman 588490 588490 Couper, John, of Sproxton, husbandman 3
5103912 2387570 2387570 defendant Sproxton Thomas chapman 588490 588490 Sproxton, Thomas, of Sproxton, chapman 2
5250132 2430151 2430151 defendant Flory William yeoman 588490 588490 Flory, William, of Sproxton, yeoman 1
5250133 2430151 2430151 defendant Davy John   588490 588490 Davy, John, of Sproxton, servant 2
5266677 2435333 2435333 defendant Flory William gent 588490 588490 Flory, William, of Sproxton, gent 1
5266678 2435333 2435333 defendant Davy John   588490 588490 Davy, John, of Sproxton, servant 2
5320989 2451370 2451370 defendant Taillour John husbandman 588490 588490 Taillour, John, of Sproxton, husbandman 0
5320990 2451370 2451370 defendant Walker William husbandman 588490 588490 Walker, William, of Sproxton, husbandman 1
5320991 2451370 2451370 defendant Dymett William weaver 588490 588490 Dymett, William, of Sproxton, weaver 2
5320992 2451370 2451370 defendant Couper Thomas husbandman 588490 588490 Couper, Thomas, of Sproxton, husbandman 3
5328390 2453566 2453566 defendant Loret John husbandman 588490 588490 Loret, John, of Sproxton, husbandman 0
5491112 2502239 2502239 defendant Lynton John husbandman 588490 588490 Lynton, John, of Sproxton, husbandman 0
5580241 2528907 2528907 defendant Mason William husbandman 588490 588490 Mason, William, of Sproxton, husbandman 0
5584407 2530185 2530185 defendant Lynryk alias Middelton Thomas chaplain 588490 588490 Lynryk alias Middelton, Thomas, of Sproxton, chaplain 0
5609773 2546759 2546759 plaintiff Adlyngton Robert de   588490 588490 Adlyngton, Robert de, of Sproxton, on his own account 0
5617936 2549423 2549423 defendant Wylde Adam   588490 588490 Wylde, Adam, of Sproxton 1
5617937 2549423 2549423 defendant Theker John   588490 588490 Theker, John, of Sproxton 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);