names

35 rows where place_id = 620397

✎ 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
3735449 1937324 1937324 defendant Assheton Edward husbandman 620397 620397 Assheton, Edward, of Barenton, husbandman 1
3752750 1942789 1942789 defendant Palmer Thomas gent 620397 620397 Palmer, Thomas, of Barenton, gent 0
3752752 1942789 1942789 defendant Casson John laborer 620397 620397 Casson, John, of Barenton, laborer 2
3764750 1946640 1946640 defendant Calcot Robert husbandman 620397 620397 Calcot, Robert, of Barenton, husbandman 0
3799345 1957715 1957715 defendant Calcott Robert yeoman 620397 620397 Calcott, Robert, of Barenton, yeoman 0
3799347 1957716 1957716 defendant Calcott Robert yeoman 620397 620397 Calcott, Robert, of Barenton, yeoman 0
4574485 2223551 2223551 defendant Weston John   620397 620397 Weston, John, of Barenton 0
4620382 2237353 2237353 defendant Whityng John   620397 620397 Whityng, John, of Barenton 0
4628536 2239847 2239847 defendant Weston John   620397 620397 Weston, John, of Barenton 0
4638215 2242720 2242720 defendant Kyryot John   620397 620397 Kyryot, John, of Barenton 2
4669960 2256301 2256301 defendant Russell William husbandman 620397 620397 Russell, William, of Barenton, husbandman 2
4713670 2269600 2269600 defendant Bethewatyr John husbandman 620397 620397 Bethewatyr, John, of Barenton, husbandman 0
4713672 2269600 2269600 defendant Swetery John husbandman 620397 620397 Swetery, John, of Barenton, husbandman 2
4713674 2269600 2269600 defendant Herman William   620397 620397 Herman, William, of Barenton, plough wright 4
4721604 2272088 2272088 defendant Kyriot John husbandman 620397 620397 Kyriot, John, of Barenton, husbandman 0
4721608 2272088 2272088 defendant Hervy John husbandman 620397 620397 Hervy, John, of Barenton, husbandman 4
4741301 2277953 2277953 defendant Rykenere John husbandman 620397 620397 Rykenere, John, of Barenton, husbandman 0
4773450 2287666 2287666 defendant Walfren John yeoman 620397 620397 Walfren, John, of Barenton, yeoman 3
4773455 2287667 2287667 defendant Swan William husbandman 620397 620397 Swan, William, of Barenton, husbandman 2
4773456 2287667 2287667 defendant Russell William husbandman 620397 620397 Russell, William, of Barenton, husbandman 3
4789697 2292845 2292845 defendant Broun John husbandman 620397 620397 Broun, John, of Barenton, husbandman 2
4799553 2296040 2296040 defendant Bette Thomas, senior husbandman 620397 620397 Bette, Thomas, senior, of Barenton, husbandman 0
4803973 2297425 2297425 defendant Walfrey Simon laborer 620397 620397 Walfrey, Simon, of Barenton, laborer 0
4874247 2318890 2318890 defendant Swan William husbandman 620397 620397 Swan, William, of Barenton, husbandman 1
4889104 2323383 2323383 defendant Bendyssh Edmund gent 620397 620397 Bendyssh, Edmund, of Barenton, gent 0
4893393 2324635 2324635 defendant Bendissh Edmund gent 620397 620397 Bendissh, Edmund, of Barenton, gent 0
4913111 2330595 2330595 defendant Sweyn William yeoman 620397 620397 Sweyn, William, of Barenton, yeoman 0
5002907 2357755 2357755 defendant Bendyssh Edmund gent 620397 620397 Bendyssh, Edmund, of Barenton, gent 0
5008791 2359462 2359462 defendant Everard Robert husbandman 620397 620397 Everard, Robert, of Barenton, husbandman 1
5031729 2366150 2366150 defendant Norman John, senior husbandman 620397 620397 Norman, John, senior, of Barenton, husbandman 0
5297519 2444282 2444282 plaintiff Admund John (legal representative) 620397 620397 Admund, John, of Barenton, yeoman, executors of 0
5300097 2444992 2444992 defendant Bendissh Edmund esq 620397 620397 Bendissh, Edmund, of Barenton, esq 0
5300098 2444992 2444992 defendant Forth Thomas husbandman 620397 620397 Forth, Thomas, of Barenton, husbandman 1
5300099 2444992 2444992 defendant Scot Henry husbandman 620397 620397 Scot, Henry, of Barenton, husbandman 2
5300100 2444992 2444992 defendant Godfrey Robert thatcher 620397 620397 Godfrey, Robert, of Barenton, thatcher 3

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