names

31 rows where place_id = 768951

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4553675 2217075 2217075 defendant Kent Robert   768951 768951 Kent, Robert, of Dounham Market 0
4652108 2246599 2246599 defendant Spenser Thomas yeoman 768951 768951 Spenser, Thomas, of Dounham Market, yeoman 4
4652116 2246601 2246601 defendant Spenser Thomas yeoman 768951 768951 Spenser, Thomas, of Dounham Market, yeoman 2
4652121 2246602 2246602 defendant Spenser Thomas yeoman 768951 768951 Spenser, Thomas, of Dounham Market, yeoman 3
4655432 2247593 2247593 defendant Vynne William yeoman 768951 768951 Vynne, William, of Dounham Market, yeoman 2
4700289 2265506 2265506 defendant Frost John mariner 768951 768951 Frost, John, of Dounham Market, mariner 1
4736117 2276431 2276431 defendant Wynne William husbandman 768951 768951 Wynne, William, of Dounham Market, husbandman 2
4780885 2290022 2290022 defendant Lavenham John yeoman 768951 768951 Lavenham, John, of Dounham Market, yeoman 0
4834815 2306891 2306891 defendant Thomson Elwin weaver 768951 768951 Thomson, Elwin, of Dounham Market, weaver 0
4850936 2311743 2311743 defendant Smyth John smith 768951 768951 Smyth, John, of Dounham Market, smith 0
4858704 2314095 2314095 defendant Gascoyn John taverner 768951 768951 Gascoyn, John, of Dounham Market, taverner 0
4950879 2342243 2342243 defendant Wynne John husbandman 768951 768951 Wynne, John, of Dounham Market, husbandman 6
5065892 2376321 2376321 defendant Bevys Robert husbandman 768951 768951 Bevys, Robert, of Dounham Market, husbandman 0
5065893 2376321 2376321 defendant Sherman Robert tailor 768951 768951 Sherman, Robert, of Dounham Market, tailor 1
5090450 2383586 2383586 defendant Bevys Robert husbandman 768951 768951 Bevys, Robert, of Dounham Market, husbandman 0
5090451 2383586 2383586 defendant Sherman Robet tailor 768951 768951 Sherman, Robet, of Dounham Market, tailor 1
5207613 2417968 2417968 defendant Bevys Robert husbandman 768951 768951 Bevys, Robert, of Dounham Market, husbandman 0
5307818 2447354 2447354 defendant Shawe William yeoman 768951 768951 Shawe, William, of Dounham Market, yeoman 2
5308941 2447719 2447719 defendant Shawe William yeoman 768951 768951 Shawe, William, of Dounham Market, yeoman 1
5394137 2473383 2473383 defendant Rouse John husbandman 768951 768951 Rouse, John, of Dounham Market, husbandman 2
5394138 2473383 2473383 defendant Atmouth Richard husbandman 768951 768951 Atmouth, Richard, of Dounham Market, husbandman 3
5407271 2477141 2477141 defendant Rouse John husbandman 768951 768951 Rouse, John, of Dounham Market, husbandman 1
5407272 2477141 2477141 defendant Atmonth Richard husbandman 768951 768951 Atmonth, Richard, of Dounham Market, husbandman 2
5422376 2481639 2481639 defendant Prestman Thomas yeoman 768951 768951 Prestman, Thomas, of Dounham Market, yeoman 0
5428539 2483459 2483459 defendant Gauge Richard butcher 768951 768951 Gauge, Richard, of Dounham Market, butcher 14
5444737 2488322 2488322 defendant Jankynson George husbandman 768951 768951 Jankynson, George, of Dounham Market, husbandman 2
5457449 2492126 2492126 defendant Jankynson George husbandman 768951 768951 Jankynson, George, of Dounham Market, husbandman 2
5492108 2502549 2502549 defendant Bocher William butcher 768951 768951 Bocher, William, of Dounham Market, butcher 4
5493850 2503068 2503068 defendant Scottyn alias Baker Thomas baker 768951 768951 Scottyn alias Baker, Thomas, of Dounham Market, baker 0
5493852 2503069 2503069 defendant Scottyn alias Baker Thomas baker 768951 768951 Scottyn alias Baker, Thomas, of Dounham Market, baker 0
5541423 2517431 2517431 defendant Mowthe alias Baker Richard yeoman 768951 768951 Mowthe alias Baker, Richard, of Dounham Market, yeoman 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);