names

29 rows where place_id = 608815

✎ 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
3675587 1918401 1918401 defendant Hoye John husbandman 608815 608815 Hoye, John, of Bures, husbandman 1
3767046 1947354 1947354 defendant Clarke Thomas, junior yeoman 608815 608815 (Clarke, Thomas, junior, of Bures, yeoman 1
3767047 1947354 1947354 defendant Clarke Rose widow 608815 608815 Clarke, Rose, of Bures, widow 2
3814762 1962529 1962529 defendant Pope John glover 608815 608815 Pope, John, of Bures, glover 0
3820146 1964178 1964178 defendant Moyne Thomas butcher 608815 608815 Moyne, Thomas, of Bures, butcher 0
3848489 1973109 1973109 plaintiff Jeffrey John chaplain 608815 608815 Jeffrey, John, of Bures, chaplain 0
3848770 1973200 1973200 defendant Smyth Robert husbandman 608815 608815 Smyth, Robert, of Bures, husbandman 0
3848771 1973200 1973200 defendant Bartlett Thomas husbandman 608815 608815 Bartlett, Thomas, of Bures, husbandman 1
3851154 1973952 1973952 defendant Semecote John yeoman 608815 608815 Semecote, John, of Bures, yeoman 0
3870420 1980350 1980350 defendant Molleyns Benedict fuller 608815 608815 Molleyns, Benedict, of Bures, fuller 0
4025709 2033846 2033846 defendant Page John husbandman 608815 608815 Page, John, of Bures, husbandman 2
4046265 2041105 2041105 plaintiff Sidey William gent 608815 608815 Sidey, William, of Bures, gent 0
4046267 2041106 2041106 plaintiff Sidey William gent 608815 608815 Sidey, William, of Bures, gent 0
4081873 2053821 2053821 plaintiff Wood alias Davye George   608815 608815 Wood alias Davye, George, of Bures, wheelwright 0
4230761 2106257 2106257 defendant Lorkyn James husbandman 608815 608815 Lorkyn, James, of Bures, husbandman 0
4382876 2158980 2158980 defendant Cooke Thomas yeoman 608815 608815 Cooke, Thomas, of Bures, yeoman 1
4472477 2192061 2192061 defendant Chapman William   608815 608815 Chapman, William, of Bures 0
4533359 2210698 2210698 plaintiff Reynold John   608815 608815 Reynold, John, of Bures 0
4533360 2210698 2210698 defendant Bolton Robert   608815 608815 Bolton, Robert, of Bures 0
4549909 2215904 2215904 defendant Waldegrave Richard   608815 608815 Waldegrave, Richard, of Bures, knight 0
4555749 2217733 2217733 defendant Tymeot John   608815 608815 Tymeot, John, of Bures 0
4576128 2224034 2224034 defendant Fullere William   608815 608815 Fullere, William, of Bures 0
4576129 2224034 2224034 defendant Smyth William   608815 608815 Smyth, William, of Bures 1
4584114 2226453 2226453 plaintiff Gerard Walter   608815 608815 Gerard, Walter, of Bures 0
4601564 2231714 2231714 defendant Parle Robert   608815 608815 Parle, Robert, of Bures 1
4632742 2241126 2241126 defendant Holt Nicholas   608815 608815 Holt, Nicholas, of Bures 0
4637976 2242640 2242640 defendant Bayhorde Andrew   608815 608815 Bayhorde, Andrew, of Bures 1
5093711 2384558 2384558 defendant Grysted John husbandman 608815 608815 Grysted, John, of Bures, husbandman 5
5180890 2410153 2410153 defendant Brasier Stephen clerk & formerly perpetual vicar 608815 608815 Brasier, Stephen, of Bures, clerk & formerly perpetual vicar 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);