names

49 rows where place_id = 612566

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693935 1924307 1924307 defendant Tykhull Ralph gent 612566 612566 Tykhull, Ralph, of Bedyngton, Surrey, gent 0
3694237 1924400 1924400 defendant Tykhull Ralph gent 612566 612566 Tykhull, Ralph, of Bedyngton, Surrey, gent 0
3756267 1943919 1943919 defendant Carowe Nicholas   612566 612566 Carowe, Nicholas, of Bedyngton, Surrey, knight 1
3756269 1943920 1943920 defendant Carowe Nicholas   612566 612566 Carowe, Nicholas, of Bedyngton, Surrey, knight 0
3841756 1971008 1971008 defendant Carewe Nicholas   612566 612566 Carewe, Nicholas, of Bedyngton, Surrey, knight, son of Carewe, Richard, of Bedyngton, knight 0
3865858 1978811 1978811 defendant Dennes Thomas gent 612566 612566 Dennes, Thomas, of Bedyngton, Surrey, gent 4
3878450 1983038 1983038 defendant Lussher Robert gent 612566 612566 Lussher, Robert, of Bedyngton, Surrey, gent 1
3900646 1990447 1990447 defendant Harvy Edmund esq 612566 612566 Harvy, Edmund, of Bedyngton, Surrey, esq 0
4002732 2025743 2025743 defendant Carewe Francis esq 612566 612566 Carewe, Francis, of Bedyngton, Surrey, esq 0
4733634 2275698 2275698 defendant Carrowe Nicholas gent 612566 612566 Carrowe, Nicholas, of Bedyngton, Surrey, gent 0
4859526 2314351 2314351 defendant Tykhill William chaplain 612566 612566 Tykhill, William, of Bedyngton, Surrey, chaplain 2
5024290 2364018 2364018 defendant Carren or Carreu Nicholas esq 612566 612566 Carren or Carreu, Nicholas, of Bedyngton, ,Surrey, esq 0
5024294 2364020 2364020 defendant Carren or Carreu Nicholas esq 612566 612566 Carren or Carreu, Nicholas, of Bedyngton, Surrey, esq 0
5026185 2364551 2364551 defendant Carrewe Nicholas esq 612566 612566 Carrewe, Nicholas, of Bedyngton, Surrey, esq 0
5026188 2364552 2364552 defendant Carrewe Nicholas esq 612566 612566 Carrewe, Nicholas, of Bedyngton, Surrey, esq 0
5031032 2365953 2365953 defendant Carewe Nicholas esq 612566 612566 Carewe, Nicholas, of Bedyngton, Surrey, esq 0
5031046 2365956 2365956 defendant Carrewe Nicholas esq 612566 612566 Carrewe, Nicholas, of Bedyngton, Surrey, esq 0
5062483 2375344 2375344 defendant Carewe Nicholas esq 612566 612566 Carewe, Nicholas, of Bedyngton, Surrey, esq 0
5143180 2399141 2399141 defendant Carreu Nicholas (legal representative) 612566 612566 Carreu, Nicholas, of Bedyngton, Surrey, esq, executors of 0
5143181 2399141 2399141 defendant Denys Walter esq 612566 612566 (Denys, Walter, of Bedyngton, Surrey, esq 1
5145238 2399748 2399748 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 0
5149196 2400895 2400895 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 0
5159596 2403923 2403923 defendant Denys William esq 612566 612566 Denys, William, of Bedyngton, Surrey, esq 0
5164111 2405238 2405238 defendant Denys Walter   612566 612566 Denys, Walter, of Bedyngton, Surrey 0
5164113 2405239 2405239 defendant Denys Walter gent 612566 612566 Denys, Walter, of Bedyngton, Surrey, gent 0
5164535 2405360 2405360 defendant Carreu Nicholas (legal representative) 612566 612566 Carreu, Nicholas, of Bedyngton, Surrey, esq, executors of 0
5164536 2405360 2405360 defendant Denys Walter esq 612566 612566 (Denys, Walter, of Bedyngton, Surrey, esq 1
5169428 2406794 2406794 defendant Denys Walter gent 612566 612566 Denys, Walter, of Bedyngton, Surrey, gent 0
5177827 2409219 2409219 defendant Carreu Nicholas (legal representative) 612566 612566 Carreu, Nicholas, of Bedyngton, Surrey, esq, executors of 0
5177828 2409219 2409219 defendant Denys Walter esq 612566 612566 (Denys, Walter, of Bedyngton, Surrey, esq 1
5184048 2411068 2411068 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 0
5186212 2411717 2411717 defendant W_ Walter esq 612566 612566 W_, Walter, of Bedyngton, Surrey, esq 0
5191774 2413332 2413332 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 1
5191777 2413332 2413332 defendant Chauntterel John yeoman 612566 612566 Chauntterel, John, of Bedyngton, Surrey, yeoman 4
5201111 2416086 2416086 defendant Carren Nicholas (legal representative) 612566 612566 Carren, Nicholas, of Bedyngton, Surrey, esq, executors of 0
5201112 2416086 2416086 defendant Denys Walter esq 612566 612566 (Denys, Walter, of Bedyngton, Surrey, esq 1
5204113 2416955 2416955 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 0
5207343 2417889 2417889 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 1
5207346 2417889 2417889 defendant Chaunterell John yeoman 612566 612566 Chaunterell, John, of Bedyngton, Surrey, yeoman 4
5214474 2419965 2419965 defendant Carru or Carrn Nicholas gent 612566 612566 Carru or Carrn, Nicholas, of Bedyngton, Surrey, gent 2
5227843 2423758 2423758 defendant Acclan William gent 612566 612566 Acclan, William, of Bedyngton, Surrey, gent 0
5231995 2424926 2424926 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 2
5257171 2432378 2432378 defendant Denys John esq 612566 612566 Denys, John, of Bedyngton, Surrey, esq 1
5302039 2445565 2445565 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 0
5334398 2455358 2455358 defendant Barby John husbandman 612566 612566 Barby, John, of Bedyngton, Surrey, husbandman 2
5351931 2460706 2460706 defendant Denys Walter esq 612566 612566 Denys, Walter, of Bedyngton, Surrey, esq 0
5550451 2520152 2520152 defendant Carewe Richard   612566 612566 Carewe, Richard, of Bedyngton, Surrey, knight 0
5550455 2520154 2520154 defendant Carewe Richard   612566 612566 Carewe, Richard, of Bedyngton, Surrey, knight 0
5557521 2522154 2522154 defendant Carewe Richard   612566 612566 Carewe, Richard, of Bedyngton, Surrey, knight 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);