names

37 rows where place_id = 591409

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604310 1869013 1869013 plaintiff Goche John yeoman 591409 591409 Goche, John, of Hemnale, yeoman 0
3608356 1870272 1870272 defendant Chetilbergh Walter yeoman 591409 591409 Chetilbergh, Walter, of Hemnale, yeoman 0
3622317 1874516 1874516 defendant Thorn Geoffrey husbandman 591409 591409 Thorn, Geoffrey, of Hemnale, husbandman 1
3627883 1903578 1903578 defendant Preest Robert butcher 591409 591409 Preest, Robert, of Hemnale, butcher 0
3634146 1905479 1905479 defendant Swan James husbandman 591409 591409 Swan, James, of Hemnale, husbandman 2
3670206 1916628 1916628 defendant Matchett Richard husbandman 591409 591409 Matchett, Richard, of Hemnale, husbandman 2
3694451 1924470 1924470 defendant Potter John yeoman 591409 591409 Potter, John, of Hemnale, yeoman 0
3696365 1925085 1925085 defendant Swan Robert husbandman 591409 591409 Swan, Robert, of Hemnale, husbandman 1
3871210 1980624 1980624 defendant More Thomas thatcher 591409 591409 More, Thomas, of Hemnale, thatcher 1
3938746 2003299 2003299 defendant Goldesmith John husbandman 591409 591409 Goldesmith, John, of Hemnale, husbandman 2
4475758 2193091 2193091 plaintiff Fet William   591409 591409 Fet, William, of Hemnale 0
4513419 2204616 2204616 defendant Warnere David   591409 591409 Warnere, David, of Hemnale 0
4513421 2204617 2204617 defendant Warnere David   591409 591409 Warnere, David, of Hemnale 0
4541803 2213326 2213326 defendant Fyn Richard   591409 591409 Fyn, Richard, of Hemnale 0
4547837 2215260 2215260 defendant Benslyn Robert   591409 591409 Benslyn, Robert, of Hemnale 6
4674619 2257670 2257670 plaintiff Edryche William   591409 591409 Edryche, William, of Hemnale, on his own account 0
4731816 2275137 2275137 defendant Hemnale David gent 591409 591409 Hemnale, David, of Hemnale, gent 3
4748313 2280013 2280013 defendant Ederyche William yeoman 591409 591409 Ederyche, William, of Hemnale, yeoman 5
4776011 2288496 2288496 defendant Fullere John yeoman 591409 591409 Fullere, John, of Hemnale, yeoman 4
4902517 2327404 2327404 defendant Colkyrke Henry tiler 591409 591409 Colkyrke, Henry, of Hemnale, tiler 0
5065093 2376091 2376091 defendant Colkyrk Henry   591409 591409 Colkyrk, Henry, of Hemnale, tile maker 0
5080652 2380703 2380703 plaintiff Colkirke Henry   591409 591409 Colkirke, Henry, of Hemnale 0
5163623 2405098 2405098 defendant Seferey Thomas husbandman 591409 591409 Seferey, Thomas, of Hemnale, husbandman 0
5226722 2423480 2423480 defendant Carter Edmund glover 591409 591409 Carter, Edmund, of Hemnale, glover 3
5264946 2434794 2434794 defendant Goldsmyth Robert yeoman 591409 591409 Goldsmyth, Robert, of Hemnale, yeoman 0
5534873 2515449 2515449 defendant Verdon John husbandman 591409 591409 Verdon, John, of Hemnale, husbandman 0
5541757 2517534 2517534 defendant Smyth Robert smith 591409 591409 Smyth, Robert, of Hemnale, smith 2
5565954 2524645 2524645 defendant Preyst Robert butcher 591409 591409 Preyst, Robert, of Hemnale, butcher 0
5580874 2529092 2529092 defendant Prest Robert butcher 591409 591409 Prest, Robert, of hemnale, butcher 0
5595415 2533515 2533515 defendant Molle Ambrose, senior husbandman 591409 591409 Molle, Ambrose, senior, of Hemnale, husbandman 2
5599338 2534676 2534676 defendant Swan James   591409 591409 Swan, James, of Hemnale, wood ash burner 0
5599339 2534676 2534676 defendant Prest Robert butcher 591409 591409 Prest, Robert, of Hemnale, butcher 1
5599340 2534676 2534676 defendant Wode Thomas laborer 591409 591409 Wode, Thomas, of Hemnale, laborer 2
5602152 2535570 2535570 defendant Goldsmyth Robert husbandman 591409 591409 Goldsmyth, Robert, of Hemnale, husbandman 0
5611106 2547196 2547196 defendant Brid John   591409 591409 Brid, John, of Hemnale 0
5616170 2548850 2548850 defendant Brid John   591409 591409 Brid, John, of Hemnale 0
5627848 2552679 2552679 defendant Warner David gent 591409 591409 Warner, David, of Hemnale, gent 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);