names

37 rows where place_id = 608333

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651384 1910799 1910799 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 0
3673239 1917645 1917645 defendant Garlond Thomas gent 608333 608333 Garlond, Thomas, of Stourton, gent 1
3686217 1921853 1921853 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
3686226 1921854 1921854 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
3686235 1921855 1921855 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
3686244 1921856 1921856 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
3686253 1921857 1921857 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
3686262 1921858 1921858 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
3705949 1928148 1928148 defendant John Robert husbandman 608333 608333 John, Robert, of Stourton, husbandman 0
3754005 1943204 1943204 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 0
3754007 1943205 1943205 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 0
3754009 1943206 1943206 plaintiff Stourton William (legal representative) 608333 608333 Stourton, William, of Stourton, knight, executors of 0
3824900 1965666 1965666 defendant Lyllecropp William butcher 608333 608333 Lyllecropp, William, of Stourton, butcher 14
3825470 1965814 1965814 defendant Webbe John husbandman 608333 608333 Webbe, John, of Stourton, husbandman 3
3856822 1975757 1975757 defendant Wellys John husbandman 608333 608333 Wellys, John, of Stourton, husbandman 1
3916379 1995859 1995859 defendant Holme John husbandman 608333 608333 Holme, John, of Stourton, husbandman 4
3946862 2005971 2005971 defendant Ellys Roger yeoman 608333 608333 Ellys, Roger, of Stourton, yeoman 0
4237921 2108868 2108868 defendant Wise Thomas clerk 608333 608333 Wise, Thomas, of Stourton, clerk 2
4259274 2116077 2116077 defendant Wise Thomas gent 608333 608333 Wise, Thomas, of Stourton, clerk: Buckland, Richard, of Standlinche, gent 2
4501739 2201142 2201142 defendant Stevenson John   608333 608333 Stevenson, John, of Stourton 7
4590636 2228432 2228432 defendant Baker Robert   608333 608333 Baker, Robert, of Stourton 0
4591081 2228567 2228567 defendant Baker Robert   608333 608333 Baker, Robert, of Stourton 0
4626422 2239216 2239216 plaintiff Preston John   608333 608333 Preston, John, of Stourton, parson 0
4626423 2239216 2239216 defendant Hunte John   608333 608333 Hunte, John, of Stourton 0
4689479 2262264 2262264 defendant Dawe John husbandman 608333 608333 Dawe, John, of Stourton, husbandman 0
4823614 2303478 2303478 plaintiff Stourton John   608333 608333 Stourton, John, of Stourton, knight, on his own account 0
4907627 2328950 2328950 defendant Wyke Gilbert gent 608333 608333 Wyke, Gilbert, of Stourton, gent 0
4929382 2335607 2335607 plaintiff Stourton John   608333 608333 Stourton, John, of Stourton 0
4948392 2341478 2341478 defendant Wyke Gilbert gent 608333 608333 Wyke, Gilbert, of Stourton, gent 0
5248280 2429629 2429629 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 0
5248282 2429630 2429630 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 0
5448883 2489558 2489558 defendant Erdy Humphrey   608333 608333 Erdy, Humphrey, of Stourton 3
5505694 2506700 2506700 defendant Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
5505698 2506701 2506701 defendant Stourton William   608333 608333 Stourton, William, of Stourton, knight 1
5545913 2518794 2518794 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 0
5558661 2522484 2522484 defendant Forster William yeoman 608333 608333 Forster, William, of Stourton, yeoman 1
5605857 2536724 2536724 plaintiff Stourton William   608333 608333 Stourton, William, of Stourton, knight 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);