names

31 rows where place_id = 628907

✎ 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
3785104 1953129 1953129 plaintiff Muncy Roger yeoman 628907 628907 Muncy, Roger, of Histon, yeoman 0
4018212 2031237 2031237 plaintiff Turtle Thomas laborer 628907 628907 Turtle, Thomas, of Histon, laborer 0
4018213 2031237 2031237 defendant Atkyn Edmund husbandman 628907 628907 Atkyn, Edmund, of Histon, husbandman 0
4049371 2042221 2042221 plaintiff Turtell Thomas laborer 628907 628907 Turtell, Thomas, of Histon, laborer 0
4096383 2059038 2059038 defendant Cockerell John gent 628907 628907 Cockerell, John, of Histon, gent 0
4255985 2114978 2114978 defendant Banck Alexander, senior yeoman 628907 628907 Banck, Alexander, senior, of Histon, yeoman 1
4259502 2116155 2116155 defendant Banck Alexander, junior husbandman 628907 628907 Banck, Alexander, junior, of Histon, husbandman 0
4259504 2116156 2116156 defendant Wick William husbandman 628907 628907 Wick, William, of Histon, husbandman 0
4259506 2116156 2116156 defendant Mathewe Roger husbandman 628907 628907 Mathewe, Roger, of Histon, husbandman 2
4262024 2116974 2116974 defendant Barnard John yeoman 628907 628907 Barnard, John, of Histon, yeoman 1
4264873 2117890 2117890 defendant Blithe Edward carpenter 628907 628907 Blithe, Edward, of Histon, carpenter 0
4264877 2117891 2117891 defendant Blithe Edward carpenter 628907 628907 Blithe, Edward, of Histon, carpenter 0
4267432 2118744 2118744 defendant Banck Alexander husbandman 628907 628907 Banck, Alexander, of Histon, husbandman 0
4267433 2118744 2118744 defendant Wick William, senior yeoman 628907 628907 Wick, William, senior, of Histon, yeoman 1
4267434 2118744 2118744 defendant Wick William, junior husbandman 628907 628907 Wick, William, junior, of Histon, husbandman 2
4296008 2128672 2128672 defendant Wick William, senior yeoman 628907 628907 Wick, William, senior, of Histon, yeoman 0
4296009 2128672 2128672 defendant Wick William, junior husbandman 628907 628907 Wick, William, junior, of Histon, husbandman 1
4296010 2128672 2128672 defendant Banck Alexander yeoman 628907 628907 Banck, Alexander, of Histon, yeoman 2
4326494 2139222 2139222 defendant Garbridge Thomas husbandman 628907 628907 Garbridge, Thomas, of Histon, husbandman 1
4344327 2145296 2145296 defendant Banckes Alexander, senior yeoman 628907 628907 Banckes, Alexander, senior, of Histon, yeoman 0
4396315 2163342 2163342 defendant Sumpter William (legal representative) 628907 628907 Sumpter, William, of Histon, husbandman, executors of 0
4464901 2189694 2189694 plaintiff Westwod Roger de   628907 628907 Westwod, Roger de, of Histon, parson of the church of St Andrew's, on his own account 0
4469977 2191275 2191275 defendant Coke Robert   628907 628907 Coke, Robert, of Histon 1
4530486 2209830 2209830 defendant Nicholl William   628907 628907 Nicholl, William, of Histon 2
4675045 2257804 2257804 defendant Aylleward Thomas clerk 628907 628907 Aylleward, Thomas, of Histon, clerk 7
4790947 2293260 2293260 defendant Gotobedde John husbandman 628907 628907 Gotobedde, John, of Histon, husbandman 2
4989410 2353768 2353768 defendant Adam Roger husbandman 628907 628907 Adam, Roger, of Histon, husbandman 0
5041238 2368987 2368987 defendant (not given) John vicar of Bannyngate 628907 628907 Bannyngate, John, of Histon, vicar of St Etheldrede's church or of St Andrew's church in Hisdon 0
5041240 2368988 2368988 defendant (not given) John vicar of Bannyngate 628907 628907 Bannyngate, John, of Histon, vicar of St Etheldrede's church or of St Andrew's church in Hisdon 0
5282111 2439841 2439841 defendant Haylys Edward husbandman 628907 628907 Haylys, Edward, of Histon, husbandman 0
5620633 2550321 2550321 defendant Hervy John   628907 628907 Hervy, John, of Histon 1

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);