names

36 rows where place_id = 758127

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3711644 1929954 1929954 plaintiff Tomson John (legal representative) 758127 758127 Tomson, John, of Algarkirk, executors of 0
4451407 2185413 2185413 plaintiff Hoberd John   758127 758127 Hoberd, John, of Algarkirk, son of Richard 0
4451408 2185413 2185413 plaintiff Fissher John   758127 758127 Fissher, John, of Algarkirk 1
4453159 2185994 2185994 plaintiff Robert Thomas   758127 758127 Robert, Thomas, of Algarkirk 2
4493832 2198765 2198765 defendant Toup John   758127 758127 Toup, John, of Algarkirk 1
4501983 2201218 2201218 defendant Smyth John   758127 758127 Smyth, John, of Algarkirk, cook 1
4538395 2212293 2212293 plaintiff Toup John   758127 758127 Toup, John, of Algarkirk 0
4633590 2241361 2241361 defendant Amuford Robert   758127 758127 Amuford, Robert, of Algarkirk 0
4637049 2242393 2242393 plaintiff Betteson John   758127 758127 Betteson, John, of Algarkirk, son of John 0
4712361 2269182 2269182 defendant Pulvertoft Richard de gent 758127 758127 Pulvertoft, Richard de, of Algarkirk, gent 0
4754770 2281876 2281876 defendant Hunyng Katherine widow 758127 758127 Hunyng, Katherine, of Algarkirk, widow 0
4756457 2282386 2282386 defendant Fyssher John husbandman 758127 758127 Fyssher, John, of Algarkirk, husbandman 0
4773934 2287827 2287827 defendant Wylcokeson John husbandman 758127 758127 Wylcokeson, John, of Algarkirk, husbandman 0
4803144 2297176 2297176 defendant Kerver John chaplain 758127 758127 Kerver, John, of Algarkirk, chaplain 0
4812752 2300103 2300103 defendant Hungate or Hungaie John husbandman 758127 758127 Hungate or Hungaie, John, of Algarkirk, husbandman 1
4827435 2304628 2304628 defendant Nicolson Roger husbandman 758127 758127 Nicolson, Roger, of Algarkirk, husbandman 0
4829245 2305187 2305187 plaintiff Hughson Betson John   758127 758127 Hughson Betson, John, of Algarkirk 2
4839989 2308418 2308418 defendant Arnald William husbandman 758127 758127 Arnald, William, of Algarkirk, husbandman 0
4851506 2311909 2311909 defendant Marabull John husbandman 758127 758127 Marabull, John, of Algarkirk, husbandman 12
4851507 2311909 2311909 defendant London Thomas husbandman 758127 758127 London, Thomas, of Algarkirk, husbandman 13
4860064 2314518 2314518 defendant Garner John clerk 758127 758127 Garner, John, of Algarkirk, clerk 0
4867596 2316835 2316835 defendant Lundon Thomas husbandman 758127 758127 Lundon, Thomas, of Algarkirk, husbandman 1
4882116 2321306 2321306 defendant Hunnyng Thomas husbandman 758127 758127 Hunnyng, Thomas, of Algarkirk, husbandman 1
4884696 2322124 2322124 defendant Burnam John gent 758127 758127 Burnam, John, of Algarkirk, gent 6
4891168 2323974 2323974 defendant Burnam John gent 758127 758127 Burnam, John, of Algarkirk, gent 6
4900674 2326851 2326851 defendant Hunnyng Thomas husbandman 758127 758127 Hunnyng, Thomas, of Algarkirk, husbandman 1
4907879 2329024 2329024 defendant London Thomas husbandman 758127 758127 London, Thomas, of Algarkirk, husbandman 1
4909946 2329635 2329635 defendant Trumpet John yeoman 758127 758127 Trumpet, John, of Algarkirk, yeoman 0
5094114 2384680 2384680 defendant London Thomas husbandman 758127 758127 London, Thomas, of Algarkirk, husbandman 2
5130643 2395453 2395453 defendant Tomson John husbandman 758127 758127 Tomson, John, of Algarkirk, husbandman 0
5150085 2401164 2401164 defendant Tomson John husbandman 758127 758127 Tomson, John, of Algarkirk, husbandman 0
5168780 2406600 2406600 defendant Tomson John husbandman 758127 758127 Tomson, John, of Algarkirk, husbandman 0
5258458 2432760 2432760 defendant Looke Alice widow 758127 758127 Looke, Alice, of Algarkirk, widow 1
5270962 2436604 2436604 defendant Welby Thomas gent 758127 758127 Welby, Thomas, of Algarkirk, gent 0
5341551 2457547 2457547 defendant Welby Thomas gent 758127 758127 Welby, Thomas, of Algarkirk, gent 0
5619922 2550090 2550090 plaintiff Ravenser John de   758127 758127 Ravenser, John de, of Algarkirk, parson 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);