names

30 rows where place_id = 613392

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3698094 1925630 1925630 defendant Johnson Thomas husbandman 613392 613392 Johnson, Thomas, of Barnehambrome, husbandman 0
3703545 1927385 1927385 defendant Louthe John husbandman 613392 613392 Louthe, John, of Barnehambrome, husbandman 3
3706131 1928211 1928211 defendant Lowth John husbandman 613392 613392 Lowth, John, of Barnehambrome, husbandman 1
3728778 1935245 1935245 defendant Lowe John husbandman 613392 613392 Lowe, John, of Barnehambrome, husbandman 1
3728779 1935245 1935245 defendant Debney Gregory husbandman 613392 613392 Debney, Gregory, of Barnehambrome, husbandman 2
3731043 1935936 1935936 defendant Lowe John husbandman 613392 613392 Lowe, John, of Barnehambrome, husbandman 0
3734831 1937137 1937137 defendant Poyntrell Thomas smith 613392 613392 Poyntrell, Thomas, of Barnehambrome, smith 0
3734832 1937137 1937137 defendant Lowe John smith 613392 613392 Lowe, John, of Barnehambrome, smith 1
3734833 1937137 1937137 defendant Debney George husbandman 613392 613392 Debney, George, of Barnehambrome, husbandman 2
3734834 1937137 1937137 defendant Buk William husbandman 613392 613392 Buk, William, of Barnehambrome, husbandman 3
3739022 1938410 1938410 defendant Lowe John husbandman 613392 613392 Lowe, John, of Barnehambrome, husbandman 1
3739023 1938410 1938410 defendant Debney Gregory husbandman 613392 613392 Debney, Gregory, of Barnehambrome, husbandman 2
3745066 1940364 1940364 defendant Hoberd Robert clerk 613392 613392 Hoberd, Robert, of Barnehambrome, clerk 1
3760359 1945244 1945244 defendant Lowth John husbandman 613392 613392 Lowth, John, of Barnehambrome, husbandman 0
3760360 1945244 1945244 defendant Willyngton John husbandman 613392 613392 Willyngton, John, of Barnehambrome, husbandman 1
3760361 1945244 1945244 defendant Qweynterell Thomas smith 613392 613392 Qweynterell, Thomas, of Barnehambrome, smith 2
3762743 1945988 1945988 defendant Quyntrell Thomas smith 613392 613392 Quyntrell, Thomas, of Barnehambrome, smith 0
3762744 1945988 1945988 defendant Lowe John husbandman 613392 613392 Lowe, John, of Barnehambrome, husbandman 1
3763424 1946191 1946191 defendant Lowthe John husbandman 613392 613392 Lowthe, John, of Barnehambrome, husbandman 4
3764285 1946488 1946488 defendant Frary John smith 613392 613392 Frary, John, of Barnehambrome, smith 1
3768026 1947637 1947637 defendant Lowe John husbandman 613392 613392 Lowe, John, of Barnehambrome, husbandman 2
3768028 1947637 1947637 defendant Kent John husbandman 613392 613392 Kent, John, of Barnehambrome, husbandman 4
3780949 1951776 1951776 defendant Bukke William husbandman 613392 613392 Bukke, William, of Barnehambrome, husbandman 3
3780956 1951778 1951778 defendant Lowthe John husbandman 613392 613392 Lowthe, John, of Barnehambrome, husbandman 1
4336360 2142453 2142453 defendant Austen Richard yeoman 613392 613392 Austen, Richard, of Barnehambrome, yeoman 3
4404720 2166148 2166148 defendant Mayes George yeoman 613392 613392 Mayes, George, of Barnehambrome, yeoman 0
4404721 2166148 2166148 defendant Mayes Edward yeoman 613392 613392 Mayes, Edward, of Barnehambrome, yeoman 1
4404722 2166148 2166148 defendant Buck Thomas yeoman 613392 613392 Buck, Thomas, of Barnehambrome, yeoman 2
4404723 2166148 2166148 defendant Buck Thomas husbandman 613392 613392 Buck, Thomas, of Barnehambrome, husbandman 3
4410765 2168190 2168190 defendant Rawson Thomas   613392 613392 Rawson, Thomas, of Barnehambrome, linen weaver 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);