names

24 rows where place_id = 670400

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3996891 2023654 2023654 defendant Cok Leonard husbandman 670400 670400 Cok, Leonard, of Spalding, husbandman 5
4054769 2044093 2044093 defendant Gamble Mathew gent 670400 670400 Gamble, Mathew, of Spalding, gent 0
4066262 2048223 2048223 defendant Preist Thomas waterman 670400 670400 Preist, Thomas, of Spalding, waterman 0
4080561 2053361 2053361 defendant Harte William, junior yeoman 670400 670400 Harte, William, junior, of Spalding, yeoman 0
4117669 2066615 2066615 defendant Hobson John butcher 670400 670400 Hobson, John, of Spalding, butcher 0
4119428 2067241 2067241 defendant Spencer Gilbert yeoman 670400 670400 Spencer, Gilbert, of Spalding, yeoman 1
4131007 2071404 2071404 defendant Baylye George mercer 670400 670400 Baylye, George, of Spalding, mercer 0
4247267 2112064 2112064 defendant Gleane Beatrix widow 670400 670400 (Gleane, Beatrix, of Spalding, widow 1
4276047 2121570 2121570 defendant Gallard John husbandman 670400 670400 Gallard, John, of Spalding, husbandman 0
4280254 2122998 2122998 defendant Tompson John saddler 670400 670400 Tompson, John, of Spalding, saddler 1
4295741 2128567 2128567 defendant Laughton Thomas yeoman 670400 670400 Laughton, Thomas, of Spalding, yeoman 0
4298791 2129666 2129666 defendant Awdley Robert gent 670400 670400 Awdley, Robert, of Spalding, gent 0
4357230 2149757 2149757 defendant Clay Richard yeoman 670400 670400 Clay, Richard, of Spalding, yeoman 0
4362399 2151603 2151603 defendant Elwood Isaac tailor 670400 670400 Elwood, Isaac, of Spalding, tailor 2
4417565 2170381 2170381 defendant atte Bothe Joan   670400 670400 atte Bothe, Joan, of Spalding, formerly wife of John 2
4425706 2172852 2172852 defendant Cok Richard   670400 670400 Cok, Richard, of Spalding, son of Thomas 0
4436121 2176038 2176038 defendant Capel John   670400 670400 Capel, John, of Spalding 0
4479335 2194186 2194186 plaintiff Hunte Lambert   670400 670400 Hunte, Lambert, of Spalding 0
4518409 2206133 2206133 plaintiff Thornton John de   670400 670400 Thornton, John de, of Spalding 4
4540323 2212870 2212870 defendant Ayleward Nicholas   670400 670400 Ayleward, Nicholas, of Spalding 0
4558592 2218641 2218641 defendant Halmer Roger   670400 670400 Halmer, Roger, of Spalding 1
4709239 2268257 2268257 defendant Adkynson William fishmonger 670400 670400 Adkynson, William, of Spalding, fishmonger 0
4775345 2288283 2288283 defendant Florys John weaver 670400 670400 Florys, John, of Spalding, weaver 0
4833352 2306439 2306439 defendant B_ John husbandman 670400 670400 B_, John, of Spalding, husbandman 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);