names

19 rows where place_id = 615788

✎ 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
3710771 1929687 1929687 defendant Lee John gent 615788 615788 Lee, John, of Fytelworth, gent 0
3740502 1938887 1938887 defendant Horwode alias Nornyche Thomas miller 615788 615788 Horwode alias Nornyche, Thomas, of Fytelworth, or of Wansforth, Surrey, miller 0
3740504 1938888 1938888 defendant Horwode alias Cornyche Thomas yeoman 615788 615788 Horwode alias Cornyche, Thomas, of Fytelworth, miller, or of Wansforth, Surrey, yeoman 0
3810783 1961275 1961275 defendant Browne William husbandman 615788 615788 Browne, William, of Fytelworth, husbandman 2
3814550 1962464 1962464 defendant Rede Richard clothier 615788 615788 Rede, Richard, of Fytelworth, clothier 0
3817540 1963391 1963391 defendant Rede Richard fuller 615788 615788 Rede, Richard, of Fytelworth, fuller 0
3868412 1979673 1979673 defendant Kyng Thomas clothier 615788 615788 Kyng, Thomas, of Fytelworth, clothier 0
4467246 2190429 2190429 defendant Bredes Robert   615788 615788 Bredes, Robert, of fytelworth 0
4467253 2190432 2190432 defendant fuller John   615788 615788 fuller, John, of Fytelworth 1
4590058 2228250 2228250 defendant Chaper William   615788 615788 Chaper, William, of Fytelworth 0
4598729 2230837 2230837 defendant Lylye John   615788 615788 Lylye, John, of Fytelworth 0
4718416 2271098 2271098 defendant Smyth William, sen husbandman 615788 615788 Smyth, William, sen, of Fytelworth, husbandman 0
4751557 2280942 2280942 plaintiff Smyth William   615788 615788 Smyth, William, of Fytelworth, on his own account 0
4757468 2282712 2282712 defendant Hethesworth William   615788 615788 Hethesworth, William, of Fytelworth, whyte tawyer or leather dresser 0
4785510 2291490 2291490 defendant Kebell Robert smith 615788 615788 Kebell, Robert, of Fytelworth, smith 0
4891785 2324173 2324173 defendant Lee Robert gent 615788 615788 Lee, Robert, of Fytelworth, gent 0
4994031 2355087 2355087 defendant Wolfynm John husbandman 615788 615788 Wolfynm, John, of Fytelworth, husbandman 1
5212054 2419264 2419264 defendant Brabeef William husbandman 615788 615788 Brabeef, William, of Fytelworth, husbandman 4
5283810 2440302 2440302 defendant Comber John yeoman 615788 615788 Comber, John, of Fytelworth, yeoman 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);