names

32 rows where place_id = 599652

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3637606 1906572 1906572 defendant Norton Richard husbandman 599652 599652 Norton, Richard, of Rede, husbandman 0
3664787 1914932 1914932 defendant Wright John husbandman 599652 599652 Wright, John, of Rede, husbandman 4
3664788 1914932 1914932 defendant Norton Richard husbandman 599652 599652 Norton, Richard, of Rede, husbandman 5
3717541 1931776 1931776 plaintiff Downyng Thomas gent 599652 599652 Downyng, Thomas, of Rede, gent 0
3744548 1940196 1940196 defendant Preest John laborer 599652 599652 Preest, John, of Rede, laborer 1
3755933 1943808 1943808 defendant Hedger John husbandman 599652 599652 Hedger, John, of Rede, husbandman 2
3779773 1951406 1951406 defendant Besouth William, senior husbandman 599652 599652 Besouth, William, senior, of Rede, husbandman 0
3779774 1951406 1951406 defendant Besouth John kaborer 599652 599652 Besouth, John, of Rede, kaborer 1
3790197 1954752 1954752 defendant Roger Thomas husbandman 599652 599652 Roger, Thomas, of Rede, husbandman 2
3790489 1954848 1954848 defendant Glocer John laborer 599652 599652 Glocer, John, of Rede, laborer 2
3823515 1965255 1965255 defendant Norton Richard husbandman 599652 599652 Norton, Richard, of Rede, husbandman 2
4062282 2046800 2046800 defendant Potter Roger yeoman 599652 599652 Potter, Roger, of Rede, yeoman 0
4062283 2046800 2046800 defendant Stanly William clerk 599652 599652 Stanly, William, of Rede, clerk 1
4528544 2209202 2209202 defendant Grene John   599652 599652 Grene, John, of Rede 1
4548795 2215560 2215560 defendant Rungeton Walter   599652 599652 Rungeton, Walter, of Rede 0
4672559 2257062 2257062 defendant Somner John clothmaker 599652 599652 Somner, John, of Rede, clothmaker 3
4672560 2257062 2257062 defendant Estonan John clothmaker 599652 599652 Estonan, John, of Rede, clothmaker 4
4710975 2268789 2268789 defendant Runggeton John laborer 599652 599652 Runggeton, John, of Rede, laborer 1
4753272 2281406 2281406 defendant Chapman William   599652 599652 Chapman, William, of Rede, vicar 1
5039600 2368492 2368492 defendant Mayho John husbandman 599652 599652 Mayho, John, of Rede, husbandman 0
5125184 2393843 2393843 defendant Mayhewe John laborer 599652 599652 Mayhewe, John, of Rede, laborer 0
5182446 2410621 2410621 defendant Middelmarch Richard husbandman 599652 599652 Middelmarch, Richard, of Rede, husbandman 1
5184590 2411240 2411240 plaintiff Estmond John   599652 599652 Estmond, John, of Rede 0
5191849 2413350 2413350 defendant Mayhewe John husbandman 599652 599652 Mayhewe, John, of Rede, husbandman 4
5203390 2416753 2416753 defendant Middelmarche Richard husbandman 599652 599652 Middelmarche, Richard, of Rede, husbandman 1
5206809 2417726 2417726 defendant Mayhewe John, sen husbandman 599652 599652 Mayhewe, John, sen, of Rede, husbandman 2
5222630 2422335 2422335 defendant Mayhewe John husbandman 599652 599652 Mayhewe, John, of Rede, husbandman 1
5319895 2451036 2451036 defendant Milward John clothmaker 599652 599652 Milward, John, of Rede, clothmaker 1
5466969 2495070 2495070 defendant Alwyn William clerk 599652 599652 Alwyn, William, of Rede, clerk 0
5483406 2499984 2499984 defendant Stalworth Richard husbandman 599652 599652 Stalworth, Richard, of Rede, husbandman 2
5531280 2514300 2514300 defendant Wilson Thomas yeoman 599652 599652 Wilson, Thomas, of Rede, yeoman 0
5531281 2514300 2514300 defendant Croft Christopher yeoman 599652 599652 Croft, Christopher, of Rede, yeoman 1

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