names

30 rows where place_id = 606257

✎ 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
3664630 1914890 1914890 defendant Trewerrot Richard husbandman 606257 606257 Trewerrot, Richard, of Dyghton, husbandman 1
3679047 1919518 1919518 defendant Elys Henry husbandman 606257 606257 Elys, Henry, of Dyghton, husbandman 4
3679048 1919518 1919518 defendant Ingleby John husbandman 606257 606257 Ingleby, John, of Dyghton, husbandman 5
3679049 1919518 1919518 defendant Hunte William husbandman 606257 606257 Hunte, William, of Dyghton, husbandman 6
3679050 1919518 1919518 defendant Kyrkby John husbandman 606257 606257 Kyrkby, John, of Dyghton, husbandman 7
3679051 1919518 1919518 defendant Symson Richard husbandman 606257 606257 Symson, Richard, of Dyghton, husbandman 8
3679052 1919518 1919518 defendant Spirman Adam husbandman 606257 606257 Spirman, Adam, of Dyghton, husbandman 9
3679053 1919518 1919518 defendant Fetherston William husbandman 606257 606257 Fetherston, William, of Dyghton, husbandman 10
3679054 1919518 1919518 defendant Trewe Richard husbandman 606257 606257 Trewe, Richard, of Dyghton, husbandman 11
3679055 1919518 1919518 defendant Spice Richard husbandman 606257 606257 Spice, Richard, of Dyghton, husbandman 12
3679056 1919518 1919518 defendant Pulros Robert husbandman 606257 606257 Pulros, Robert, of Dyghton, husbandman 13
3972436 2014934 2014934 defendant Fulburn or Fulbaron Thomas gent 606257 606257 Fulburn or Fulbaron, Thomas, of Dyghton, gent 0
4525210 2208223 2208223 plaintiff Authorp William   606257 606257 Authorp, William, of Dyghton, parson 1
4679313 2259142 2259142 plaintiff Kaa John   606257 606257 Kaa, John, of Dyghton 0
4689827 2262377 2262377 plaintiff Authorp William   606257 606257 Authorp, William, of Dyghton, parson 2
4739538 2277446 2277446 defendant Warter Henry laborer 606257 606257 Warter, Henry, of Dyghton, laborer 3
4752801 2281274 2281274 defendant Leget Thomas husbandman 606257 606257 Leget, Thomas, of Dyghton, husbandman 0
4762729 2284323 2284323 defendant Garmondesway John husbandman 606257 606257 Garmondesway, John, of Dyghton, husbandman 0
4764282 2284825 2284825 plaintiff Hawethorp William   606257 606257 Hawethorp, William, of Dyghton, parson 0
4769767 2286516 2286516 defendant Godewyn Robert husbandman 606257 606257 Godewyn, Robert, of Dyghton, husbandman 0
4820829 2302601 2302601 defendant Roos John gent 606257 606257 Roos, John, of Dyghton, gent 0
4822756 2303197 2303197 plaintiff Solet John   606257 606257 Solet, John, of Dyghton 0
5059334 2374359 2374359 defendant Solett John husbandman 606257 606257 Solett, John, of Dyghton, husbandman 0
5059335 2374359 2374359 defendant Cooke Robert husbandman 606257 606257 Cooke, Robert, of Dyghton, husbandman 1
5059336 2374359 2374359 defendant Symson John husbandman 606257 606257 Symson, John, of Dyghton, husbandman 2
5059337 2374359 2374359 defendant Solette John husbandman 606257 606257 Solette, John, of Dyghton, husbandman 3
5065601 2376243 2376243 defendant Girlyngton Nicholas gent 606257 606257 Girlyngton, Nicholas, of Dyghton, gent 2
5371714 2466741 2466741 defendant Gayle Christopher yeoman 606257 606257 Gayle, Christopher, of Dyghton, yeoman 0
5549596 2519930 2519930 defendant geffrason George yeoman 606257 606257 geffrason, George, of Dyghton, yeoman 2
5615971 2548793 2548793 defendant Butiler Richard   606257 606257 Butiler, Richard, of Dyghton 0

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